Goal seek solver excelงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
เขียนโปรเเกรม Sudoku ที่สามารถเเก้โจทย์ Sudoku ที่ user inputโดยไม่ใช้ library ที่เกี่ยวกับ constraint(CLD(FD) library) เขียนโดย backtracking เเละเชื่อมกับ UI โดยใช้ python
...สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 15,000 ครับ รวมระบบหลังบ้าน ไม่รวม host กับ domain ครับผม 12:13 Avatar ทั้งนี้ต้องดูรายละเอียด ข้อ 1, 3 และ 6 อีกครั้งครับผม วันนี้ 15:24 ฉันสนใจจ้าง 15:25 โทษทีครับ ที่คุยไว้หลายเดือนก่อน โดนเบรคโปรเจคไป นี่จะกลับมาทำ 15:25 พอจะลดได้มั้ยครับ 15:32 อยากจะทำเว็บไซต์รวบรวมยอดขาย พนักงานให้มี Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แล้วแต่แกนที่เราต้องการ export รายงานออกมาเป็น excel ได้ 2. มีระบบ Log in...
ทำ excel คำนวนภาษีส่วนบุคคล 5 คน โดยสามารถเปลี่ยน variable ต่างต่างได้เพื่อทำ scenario analysis (ie ถ้ารายได้ x จะได้ x) ______________________________________________ Excel personal tax calculations for 5 people, with different variables changing for scenario analysis. (ie if income x is obtained x)
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
solver หาค่า minimize cost จากการจัดตารางเวลางานของพนักงานเข้างานเป็นรายชั่วโมง มีจำนวนงาน 4,459 งานแต่ละงานมีกลุ่มพนักงานที่เหมาะสมที่กับงานนั้น พนักงานแบ่งเป็น 3 กลุุ่ม จำนวนพนักงานแต่ละกลุ่มมี 51, 42 และ 89 คน มีข้อมูลเวลาโดยประมาณการที่ใช้ในการทำแต่ละงาน และเวลาจริงที่ใช้ และลองเพิ่มจำนวนพนักงานในแต่ละกลุ่มว่าจะส่งผลกับต้นทุนอย่างไร และในอนาคตมีจำนวนงานและจำนวนพนักงานที่เพิ่มขึ้น จำนวนพนักงานที่คาดการณ์ว่าจะมีในอนาคตเหมาะสมหรือไม่ ต้องเพิ่มจำนวนพนักงานอีกหรือไม่
I'm looking for a professional to create and manage an Amazon advertisement campaign specifically focused on promoting a range of dry fruits. Key Details: - **Product**: Dry fruits - **Target Audience**: This campaign should target health-conscious individuals, fitness enthusiasts, and gourmet food lovers. The goal here is to create ads that resonate with these audiences and drive them to make a purchase. Ideal Skills and Experience: - **Amazon Advertising**: Experience with creating and running Amazon ad campaigns is a must for this project. - **Market Segmentation**: Understanding of the target audience and how to create ads that appeal to them. - **Copywriting**: Ability to craft compelling ad copy that drives sales. - **Analytical Skills**: Proficiency in analyzing campa...
...need help with social media management, email marketing, and content creation. Key Aspects: - Social Media Management: Currently, I use Facebook, Instagram, and TikTok as my primary social platforms. I need help with managing these accounts effectively. This includes posting engaging content, responding to comments, growing my follower base, and increasing my reach. - Email Marketing: My main goal for email marketing is to increase sales. The candidate should have a strong understanding of email marketing best practices. This includes crafting engaging email campaigns, segmenting my audience, and analyzing email performance. - Content Creation: This role also involves creating content for my social media and email marketing efforts. The ideal candidate should have experience i...
I'm looking to lay out a solid business plan for providing personal care services specifically aimed at adults with disabilities. The primary services that my business will offer include: - Assistance with daily act...activities - Help with personal hygiene The freelancer I need for this project should have: - Experience with healthcare or disability services in Australia - Strong knowledge of business planning - Proven ability to complete market analysis reports and financial projections - A good understanding or willingness to research policies and regulations surrounding disability services Ultimately, the goal is to develop a comprehensive plan that not only covers potential business hurdles, costs, and market strategies but also looks into the unique needs of our targe...
I'm looking to lay out a solid business plan for providing personal care services specifically aimed at adults with disabilities. The primary services that my business will offer include: - Assistance with daily act...activities - Help with personal hygiene The freelancer I need for this project should have: - Experience with healthcare or disability services in Australia - Strong knowledge of business planning - Proven ability to complete market analysis reports and financial projections - A good understanding or willingness to research policies and regulations surrounding disability services Ultimately, the goal is to develop a comprehensive plan that not only covers potential business hurdles, costs, and market strategies but also looks into the unique needs of our targe...
I'm looking to elevate our existing WordPress website for my Native lead non-profit organization. Currently we have a Wordpress site I’ve designed with Elementor, however I am not a web designer and we’d like to bring it to a professional level. Our main goal is to build connections and promote dialogue with Native American tribal communities around Nuclear Energy and consent-based siting of spent fuel. Key functionality for the site includes: - Blogging: To share our upcoming events, updates, and highlight why this is important to Native Americans. - Information: We want to share info about consent-based siting, as well as nuclear energy, and our coalition that seeks to work for tribes. - Contact: A clear and easy way for visitors to find our information and re...
I'm looking for a skilled data scientist to assist with a project that involves detailed statistical analysis and modeling using R. The eventual goal is to present these findings in a comprehensive yet accessible manner through data visualizations. Ideal Skills & Experience: - Proficiency in R programming - Strong statistical modeling background - Experience with data visualization techniques - Ability to create detailed reports - A firm grasp of accounting principles would be a plus, but not required. This project will require someone who can take raw data and transform it into valuable insights, with the ability to convey these insights in an engaging, comprehensible manner. If you are comfortable with both the technical and reporting aspects of data science, I would...
I'm in need of an experienced SEO team to optimize the online presence of my Dubai-based real estate company. The primary goal is to generate more leads for our properties. Key Responsibilities: - Develop a comprehensive and effective SEO strategy - Boost the visibility of our property listings on search engines - Monitor analytics to identify gaps and opportunities Ideal Candidate: - Proven experience in SEO, particularly within real estate - Familiarity with the Dubai real estate market - Proficiency in utilizing SEO tools and analytic software - Proven track record in lead generation through SEO
I'm seeking the skills of a self-motivated PHP developer, well-verse...bring a mix of creativity, forward-thinking, and technological prowess. You're free to engage this project with your unique style, stamping your innovation on our vision. Main Project Purpose: The main thrust of this project is centered around developing a web application and integrating APIs. This task will require adaptive capabilities as you navigate diverse specifications aligned with our main goal. A successful application will come with: - A showcase of relevant past projects - Detailed experience - A comprehensive project proposal that demonstrates your understanding and approach to this project. I eagerly anticipate your application, encompassing your skills, experiences, and what you can br...
In need of a skilled web designer to create a clean, minimalist mockup for an informational website targeted at professionals offerin...like to see what you can create. If you have any questions regarding the details, I’m looking for in addition to what I’ve already been provided. I am more than happy to provide. It will be a service based offering website. Ideal Skills: - Web design experience - Familiarity with minimalist aesthetic - Previous work with informational websites - Understanding of professional audience needs The goal is for a simple layout that provides clear, easily accessible information. Being able to incorporate subtle color schemes and smart typography to project professional vibes is a must. Your portfolio demonstrating similar projects would be h...
...details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Length: Short-term, estimated completion within one week. ( MAX 80 AUD as a test round, if the work is good, Larger jobs will come) Application Instructions: Please message me with the keyword "VSL" at the beginning of your application to confirm that you have fully read and understood the job desc...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
I'm seeking a skilled individual to help grow my business. S...displayed. Key Requirements: - Implementing marketing strategies on Facebook and Google, and driving traffic to my website - Focusing on generating leads as the primary goal - Leveraging before and after project photos for audience engagement Ideal Skills: - Proven track record in social media marketing, specifically lead generation - Strong understanding of Facebook and Google advertising platforms - Ability to curate and present engaging content, specifically before and after project photos - Familiarity with the field of fire mitigation, land clearing, driveway/road building, and excavation would be an added advantage. The goal of this project is to increase my business' visibility and drive pote...
** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportunities in order to ensure successful grant app...research, and the ability to distinguish and identify Ontario/Canadian Grant opportunities • Ability to work effectively under pressure; • Excellent writing and verbal skills; • Be highly organized with the ability to implement systems and follow-up processes; • Proficiency in research, interpreting, and analyzing diverse data; • Excellent Computer skills (Microsoft Office Word, Access, PowerPoint and Excel),...
...marketing professional to construct a comprehensive investment offering. This is projected to facilitate the acquisition of an apartment complex in the next 3 months. **We will collaborate on the financial projections, specific business plan, etc. - we need someone who can beautify the hard data (text/financial projections/graphs/maps) and make it digestible to read for a prospective investor. Our end goal is to have TWO forms of this investment offering (a summary teaser that is high-level, and a more granular deck that contains additional detail) that we can recycle on future acquisitions by altering text & numbers without having to re-create the entire pitch** The offering must contain: - Detailed information on the property and a projection on the returns - A thorough...
I need a dedicated SEO expert to rapidly improve my website's search engine rankings. My goal is to establish a strong online presence on a national scale. Key Tasks: - Conduct an SEO audit for my less than 1 year old website - Implement strategic on-page and off-page SEO techniques to improve rankings - Optimize the website for a national audience Ideal Candidate: - Proven SEO experience with new websites - Strong understanding of national market trends - Proficiency with SEO analysis tools and techniques I look forward to seeing my website climb the search engine ranks.
...high-quality content that resonates with our target audience on each platform. - Social Media Advertising: Knowledge and experience in developing and implementing successful social media advertising campaigns is a must. - Analytics and Insights: The ability to monitor and analyze the performance of our social media efforts, and use these insights to improve our strategy, is vital. The ultimate goal of this training program is to increase our brand awareness across these three platforms. Ideal Skills and Experience: - Proven track record in social media management and training - Strong understanding of Facebook, Instagram and YouTube algorithms and best practices - Experience in creating and executing successful social media advertising campaigns - Proficiency in analyzing soci...
I'm seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual repre...
I am seeking a talented freelance 3D home designer to assist with visualizing the renovation of our basement space. Our goal is to transform this area into a functional and aesthetically pleasing living space. The selected freelancer will work closely with our team to understand our vision and translate it into detailed 3D renderings. Responsibilities: Create detailed 3D models and renderings of the basement space, including layout, furniture placement, and decor elements. Provide multiple design options for consideration, incorporating feedback and revisions as needed. Ensure that the designs meet both functional and aesthetic requirements. Deliver high-quality 3D renderings within the agreed-upon timeline. Basement layout is attached in the files.
I'm in urgent need of a seasoned fundraiser to help raise $100,000 for a non-profit organization. Your assistance will be invaluable in helping us reach our goal. Key Responsibilities: - Crowdfunding Campaign: You'll be in charge of creating and managing an online crowdfunding campaign. This will involve setting up the campaign, engaging with potential donors, and ensuring that the campaign stays on track. - Grant Writing: You should also have a proven track record in grant writing. You will be responsible for identifying suitable grant opportunities, crafting compelling proposals, and submitting them within deadlines. Ideal Skills and Experience: - Extensive experience in both online crowdfunding and grant writing, preferably within the non-profit sector. - Strong commu...
I'm looking for a skilled app designer who can help me bring my vision to life. The primary goal of this app is to connect to a web portal and input 5 pieces of information. Key Requirements: - Cross-platform design: The app should be designed for both iOS and Android platforms. - User-friendly: The design should be intuitive and user-friendly. Specific Features: - Photo Input: The app should enable the user to take a photo of a card containing some data and inputting it to the web portal. Ideal skills and experience for this job include: - Previous experience in cross-platform app design. - Strong UI/UX design skills. - Familiarity with photo input features. - Experience with connecting apps to web portals would be a plus.
...Facebook marketer to help promote my digital products to professionals and businesses. Key Tasks: - **Increasing Brand Awareness**: The primary goal of this campaign is to increase the visibility of my digital products in this particular market segment. I need someone who can effectively communicate the unique value propositions and features of my products to this audience. - **Generating Leads**: In addition to spreading awareness, I want to turn this visibility into tangible leads. The ideal candidate should be able to implement strategies to convert engagement with our brand into potential customers. - **Driving Sales**: Ultimately, the end goal of this campaign is to drive sales for my digital products. Experience in crafting compelling sales copy and executing dir...
...both on line & in person primarily targeting young adults aged 18 to 25 for our Diploma programs as well as younger students 8 - 17 for part time teen & children programs. The Academy is a private Career College training in the field of film & television. Key Tasks: - Develop a targeted Google Ads campaign aimed specifically at young adults aged 18 to 25. - While creating ads, the main goal is to generate leads who will potentially enroll in our in person & online courses. - Advise on budget, ad copy, and design to ensure maximum engagement and lead conversion. Skills and Experience: - Proven experience in running targeted Google Ads campaigns. - Strong understanding of the education industry and what appeals to young adults. - Demonstrated succe...
I need a skilled animator to bring my vision to life and create an engaging promotional video. Key requirements: - You must have experience in 2D animation and be proficient in relevant software. - The goal of the video is to promote a product or service, so your work must be adapted to achieve this goal. - The target audience for this project is adults, so the style and content of the animation must be suitable for this demographic. - Audio narration is still in process, but our market is based on the same thing that this application does, for the Latin American market. - In short, we are looking for an animation that is very similar to the attached video, since the narration will be very similar as well. - If the animator requires the script in
...scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. * An understanding of URL patterns would be adva...
I'm seeking a skilled and experienced SEO expert to help me achieve my goal of increasing the traffic to my website, with a focus on national customers. Key Responsibilities: - Analyze our existing SEO strategies and suggest improvements to increase organic traffic. - Optimize our website's content and structure for search engines. - Implement on-page and off-page SEO techniques to enhance the site's visibility. - Use SEO tools to track the progress of our SEO strategies. - Provide regular reports on the performance of our SEO efforts. The ideal candidate should have: - Proven experience in successfully boosting website traffic. - A deep understanding of SEO techniques and best practices. - Strong analytical skills for data-driven decision-making. - Excellent commu...
I am seeking an expert in ANSYS with a specialization in Fluid Dynamics for a complex project involving turbulent fluid flow. The main goal of this project is to analyze performance under specific conditions. Key Requirements: - Profound knowledge of fluid dynamics in ANSYS - Previous experience with turbulent fluid flow simulations - Ability to interpret results and provide insights on performance under varied conditions Your deep understanding of fluid dynamics and past experience with turbulent scenarios will be critical for the success of this project. I look forward to your budding participation.
Hello, We are looking for a talented and experienced design freelancer to create a template and logo for our online ERP system, under the name "SOLTETI". The template will be based on the existing layout of the following website: [Link to website: ] Project description: Goal: Develop a template and logo for our online ERP system, maintaining the visual identity and functionalities of the website layout provided above. Layout Details: The website layout provided will be made available to the selected freelancer for reference and inspiration. Technical requirements: The template must be compatible with our ERP system and easily integrated. It must follow best design and usability practices. Be responsive, ensuring a consistent experience across different
I need someone who can help me enhance the layout of my existing plain text documentation by uploading it to Gitbook. The goal is to make the documentation more user-friendly and professional. Key Responsibilities: - Rearrange the current plain text documentation in Gitbook to improve its visual appeal and organization. - Apply intermediate customization to the layout - this includes adding custom fonts, colors, and navigation elements. Ideal Candidate: - Previous experience working with Gitbook or similar documentation platforms. - Proficiency in HTML/CSS as the customization required is at an intermediate level. - A keen eye for design and user experience to ensure the documentation is not just informative but also visually engaging. - Excellent attention to detail as the docume...
...recorded some videos and need a skilled video editor to help me with the post-production. The goal is to create engaging content that can be shared on platforms like TikTok and Instagram. Key Requirements: - Advanced editing skills: I'm looking for someone who can enhance my content by adding effects and transitions. - Understanding of young adult audience: The primary target for these videos are individuals aged 18-25, so a creative approach that resonates with this demographic is key. - Sensitivity to content: As these videos will document my personal journey with cancer, it's important that the editor is empathetic and able to handle the sensitive nature of the topic. Future Opportunity: The ultimate goal of these videos is to build a following that I can ...
I'm looking for an experienced professional in audio enhancement to help me with a project. The primary goal is to improve the quality of a recorded conversation. The audio has several issues including background noise, distortion, and low volume. Key project details and requirements: - The audio in question has no music, so the primary focus of the enhancement should be on the conversation. - Experience in audio enhancement and sound engineering is crucial. Previous similar projects or a strong portfolio of relevant work is highly desired. - The ideal candidate should have an ear for detail and a creative approach to maximizing the audio's quality. - The enhancement of the audio should be done in a way that makes it easier for me to understand and follow the conversati...
