Excel sheet name in formula dynamicงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แบ้วแต่แกนที่เราต้องการ 2. มีระบบ Log in ซึ่งจะยึด user ของพนักงานกับสาขาที่เรากำหนดไว้ หมายความว่าเมื่อพนักงานกดรายงานยอดขายระบบจะ แท็กว่ามาจากสาขาไหน 3. หน้าพื้นฐาน เพื่อแจ้งข่าวสารหรือโปรโมชั่นต่างๆ และสามารถแก้ไขได้ง่าย 4. มีแพลตฟอร์มหลังบ้านที่สามารถแก้ไข เพิ่ม ลบ ข้อมูลได้ ทั้งในเรื่องของข้อมูลพนักงานข้อมูลสาขา โดยกำหนดให้ทำได้เฉพาะ User ที่กำหนดไว้ 5. สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 1...
ทำ 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)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
คำนวณ Dynamic flow เพื่อดูการ action เปิด-ปิดของตัว Valve ที่ Condition เเตกต่างกัน
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
...delete - Design Web Page เรียบง่าย ใช้งานสะดวก ไม่เน้นลูกเล่น มี Concept , มีรูป ให้ 1. รถยนต์มือสอง 1.1 Download excel file format การกำหนดราคา รถยนต์มือสอง 1.1.1 Download excel file ใน Format ของการกำหนดราคา โดยเลือกเงื่อนไขได้ 2 วิธี 1.1.1.1 เลือกตามยี่ห้อ สามารถเลือกได้มากกว่า 1 ยี่ห้อ 1.1.1.2 เลือกตาม segment เลือกได้ครั้งละ 1 segment 1.1.1.3 ถ้ามีราคาที่เคยกำหนดในระบบให้แสดงด้วย 1.1.2 แสดงรุ่น รุ่นย่อยทั้งหมดตามเงื่อนไขที่เลือกด้านบน 1.1.3 แสดงข้อมูล 1 sheet ต่อ 1 ยี่ห้อ 1.2 Upload excel file การกำหนดราคา รถยนต์มือสอง 1.2.1 สามารถ Upload การกำหนดราคา รถยนต์มือสอง จาก excel file ในขั้นตอน Download เพื่อเพิ่มหรือปรับปรุงราคา รถยนต์มือสอง ...
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Create a Dynamic Web pages for calculate transport charge using MySQL and PHP ต้องการโปรแกรมที่สามารถคำนวณค่าขนส่งสินค้าโดยนำข้อมูลที่มีผู้กรอกลงหน้าเวบมาคำนวณกับ Data base ค่าขนส่งสินค้าที่มี แล้วส่งให้ผู้กรอกลงหน้าเวบทางอีเมล
I'm seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to create user-friendly systems....
I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufacturing processes.
I'm looking to revamp the user interface of my Solar2d application. The main goal of this project is to refresh the look and feel of the app. I have a UX Designer who has completed a number of screens in Figma. Key points: - The focus is on enhancing the user interface. - The design style should be modern and sleek. - Incorporating high-quality images and icons to make the app visually appealing would be a plus. - Dynamic animations and interactive elements can be considered but are not the main priority. Ideal skills and experience for this project include: - Proficiency in Solar2d or similar platforms. - A strong portfolio that showcases knowledge - Ability to work on enhancing user experience and visual appeal simultaneously.
I need a dedicated LinkedIn Specialist to refine and manage our company's LinkedIn presence. Responsibilities: - Post three times a week, maintaining a consistent and engaging schedule - Connect with HR professionals and key decision-...updates and achievements. You must translate our successes and milestones into compelling, shareable posts that will resonate with our LinkedIn audience. Ideal Skills: - Proven experience managing LinkedIn profiles for businesses - Excellent networking and relationship-building skills - Strong content creation and curation ability - Proficiency in LinkedIn's analytics and tracking tools This role is about more than just posting; it's about creating a dynamic, professional online presence that will help us establish strong re...
I'm looking to hire a skilled web designer for a position in my agency. The ideal candidate should be proficient in Front-end development, UI/UX design, and Responsive design. Key Responsibilities: - Collaborate with the team to brainstorm, design and create visually appealing web content - Translate wireframes and mockups into high-quality code - Implement best-practices in UI/UX design to enhance user experience - Ensure the website is responsive and optimized for a variety of devices - Regularly test and troubleshoot to maintain the quality of the website The ideal candidate should be: - Proficient in HTML, CSS, and JavaScript for front-end development - At least an intermediate level of experience in UI/UX design - Able to work both independent...
I'm in need of a skilled developer who can create an AI portal that is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel automatio...
...for a creative video creator with a knack for engaging with adult audiences through dynamic visuals and infographics. Key Requirements: - The primary goal of this project is to teach new concepts. The ideal freelancer should have a background in educational content or health and wellness. - The video should be at an intermediate level of detail, presenting the information with some depth but not delving into overly complex or technical language. Skills and Experience: - Experience in creating educational content, especially for adult audiences. - Proven ability in designing visually appealing and engaging infographics. - A good understanding of health and wellness topics and the ability to present them in a clear, accessible way. - Familiarity with ...
...produced, we need your artistic touch to develop the dynamic images for the inside pages. What I Love: Pink Hard Hat and Gloves: The vibrant pink hard hat and gloves, especially with our logo customization, are fantastic! Facial Expression and Lashes: The character's facial expression and lashes are perfect and align beautifully with our design style. What We Can Improve: Locs: I prefer the locs from the last photo over the first one – they have more character and personality. Safety Gear: Since our organization prioritizes safety, let's add a safety vest and possibly safety goggles to complete the look. I love the Locs in the last photo much better than the first. Our organization is also really big on safety, so adding in the...
...requires some thorough editing: • The first task needs precision and attention to detail, as it requires the elimination of obstructive elements in the photo. More specifically, I need the power lines and parking signs removed to highlight the mural. • Secondly, there are missing portions of the sign text that I would like restored. The complete text should read as: [Sharkey Issaquena Medical Clinic]. Freelancers must have excellent photo manipulation skills to integrate the missing text smoothly and convincingly. • Lastly, the picture lacks vibrancy, I want the colors and saturation adjusted for a more eye-catching and dynamic result. Expertise in Adobe Photoshop or similar graphic design software is a must, as well as an eye for detail and aesth...
I have an html form php file on my server. I would like a passcode (no username) added to the form that captures the u...captures the user connected to the passcode when the form is submitted. I would like the data sent to Google Sheets when a user submits the form. The Google sheet is complex. I would like the form data sent to 1 of 13 sheets. It should search for the sheet name, date, and user (from the html form) to find the correct sheet and row to insert the data from 5 fields. Can you help with this? We have an form in the laravel, these are three main tasks : 1) Secure the form with 6 code passcode. 2) Update the URL of the form. 3) Save the form data in google sheet. There are various tabs in the sheet, so we need to...
I need an expert to retrieve a missing Excel document from my Windows configured laptop. This document has been missing since February 2024, and I have no backup available. The document was created using an unknown version of Excel, so the freelancer would need to check the specifics during the recovery process. Key requirements: - Recover the missing Excel document which was lost for unknown reasons - No backup available - The document was created using an unknown version of Excel Skills and experience needed: - Proficient in data recovery - Experience in retrieving files from Windows systems - Familiarity with different versions of Microsoft Excel Can pay 12 usd
I am in need of detailed administrative work. It involves segmenting primary school level maths questions based on the specific skills required to answer them correctly. The task will be to review 50 past papers - containing approx 50 questions each. For each question, I need someone to: - cut & paste an image of the question into a Google slides / Powerpoint document - 1 question (or sub-question if it requires a different skill per page - 1 document for each paper - name the skill(s) that are required to answer each question - as the title for each page - create a new line in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides document) - page number of Google Slides document ...
I'm in need of a team of live streamers based in Saudi Arabia. The focus of the live streams will be on product reviews and promotions. I have specific products and brands that I want the team to promote during the live streams. Ideal candidates should: - Be based in Saudi Arabia and have a good understanding of the local TikTok community - Have a passion for product reviews and promotions - Have a strong presence on TikTok with a good number of followers - Be able to effectively engage with the audience and drive sales - Be creative, dynamic, and able to think on their feet Your primary responsibility will be to host live streams, review and promote the products I provide, and engage with the audience in a way that maximizes sales and brand aware...
...assist me in creating a web scraper that can extract specific text content from a website on a weekly basis. The scraped data should be efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency in Python programming - Experience with web scraping libraries such as BeautifulSoup or Scrapy - Understanding of scheduling tasks in Python - Familiarity with workin...
...looking for a proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in Excel. - In-depth knowledge o...
I need an expert to develop a macro tailored to automating report production tasks in Microsoft Excel. The main purpose of this project is to streamline the process of regular report production and increase overall efficiency. Ideal skills and experience include: - Proficient in Microsoft Excel - Experience in macro development to automate tasks - Knowledge in automating report production Your role will involve designing and implementing a suitable macro for regular report production in Excel. I'm looking for someone who can provide a timely and efficient solution.
...The website should include a product catalogue and testimonials. Key tasks: - Develop a dynamic and visually appealing Shopify store. - Incorporate a user-friendly product catalogue system. - Integrate a testimonials section. The successful candidate does not need to worry about generating product descriptions or snapping exquisite product images; I will provide all necessary content. However, they should be able to present this content in the most engaging manner possible on the platform. Also I have a crappy site hosted by Wordpress already and would like to take that domain name over to Spotify if possible. I would also like basic training in how to integrate new products and or lines of products in the future. I’m a serious woodworker bu...
...involve seamless integration. Frontend Developer Tasks: - JavaScript Development: Your JavaScript expertise will be crucial in building interactive and responsive user interfaces. - React Development: You will be working with React to create dynamic, efficient, and scalable frontend components. - User Interface Design: An eye for design and user experience is essential. You'll be responsible for creating an intuitive and appealing interface. The main purpose of this project is to build a sophisticated web payment application from the ground up. The successful team will need to communicate effectively, work well together, and demonstrate a high level of skill and creativity in their respective areas. Ideal Skills: - For the Python Developer: Python, Django, ...
I am looking for an artist to create character drawings. I have specific characters in mind that I would like to be drawn. The project involves drawing 2 characters in 2D, a man and a woman in different postures. These drawing will be used in a ergonomics review, it has to be professional and technical sometimes. Skills and Experience: - Proficiency in 2D character drawing - Ability to bring characters to life with expressive and dynamic poses - Attention to detail in line work and shading - Experience in creating unique and original character designs
Skills required Front-end: React or Angular for building a dynamic web application. Back-end: Node.js with Express for server management and API integration. Database: MongoDB or PostgreSQL for storing session data securely. Authentication: OAuth for handling secure authentication with streaming services. Technical Requirements and Development 1. Secure Authentication: Implement OAuth or a similar secure authentication protocol to allow users to log into their streaming services without storing their credentials. 2. Device Management: Develop a system to manage devices that can stream content, ensuring only authorized users can access the services during their stay. 3. Session Management: Ensure that user sessions are automatically ended upon checkout, or provide a simple way for ...
I'm in need of a skilled automation specialist to help me streamline and optimize a multi-step process that involves audio analysis and documentation. Key Responsibilities: - Develop a solution (on ) that initiates from an audio file recording and proceeds to: - Audio-to-text conversion using Google Cloud Speech-to-Text - Running the transcript through ChatGPT for analysis - Summarizing the outcome in Google Docs - Maintaining a daily list of patients' names in a Google Sheet Key Objectives: - The primary goal of this automation is to enhance productivity, allowing staff to focus on more intricate tasks. - All stages of this process need to be fully automated. Additional Details: - The daily list of patients' names will be crea...
I'm looking to create a dynamic and user-friendly business website that effectively communicates my brand and services to visitors. The website should be visually appealing, easy to navigate, and optimized for search engines to help increase visibility. - A clean, modern design that aligns with my brand's identity. - Intuitive navigation structure to help users find information quickly. - Responsive design to ensure the website looks great on all devices. - Content Management System (CMS) integration to easily manage and update content. - Search Engine Optimization (SEO) to enhance online presence and attract more traffic. - E-commerce functionality, if required, to sell products or services online. - Social media integration to connect with my audience on different platf...
I'm seeking a skilled virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You'll be responsible for using various messaging platforms to engage with potential clients and leads. Ideal candidates should excel in written communication and have a knack for sales. Proficiency in project management tools is a plus. Our preferred mode of communication with leads is through messaging platforms.
Fixed cost & developers from Uttar Pradesh only ....Pradesh only . I'm looking for a skilled freelancer who can help me develop a real-time temperature display system using NodeMCU ESP8266. Key Project Requirements: - Integration with 3 or more Bluetooth BLE sensors - Real-time temperature display on an LCD screen - Parsing advertisement data from nearby paired BLE sensors - Data sheet will be supplied for reference Ideal Skills/Experiences: - Proficient in programming with NodeMCU ESP8266 - Experienced in working with Bluetooth Low Energy (BLE) technology - Familiarity with parsing advertisement data - Knowledge of connecting and operating LCD displays This is a fixed cost project with a budget under $100. Please provide your quote for the project, alo...
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
...Qualifications: Proven experience in managing and maintaining WordPress websites, particularly e-commerce platforms. Strong understanding of WordPress CMS, including themes, plugins, and customizations. Proficiency in HTML, CSS, JavaScript, and PHP. Experience with SEO and content management strategies. Knowledge of website security protocols and best practices. Excellent problem-solving skills and attention to detail. Ability to work independently and meet deadlines. Strong communication skills for effective collaboration with content creators and other team members. Preferred Qualifications: Experience with e-commerce platforms such as WooCommerce. Familiarity with digital marketing tools and strategies. Basic graphic design skills for content updates. What We Offer: ...
...am in urgent need of a proficient mobile app and web developer to create a robust platform titled 'Legal Connect' that will serve as a bridge for effective communication between lawyers and their clients. Crucial Task Details: * The app needs to be dynamic and accessible from iOS, Android, as well as Web platforms - a wide reach is essential. * Key features that need to be integrated include: secure document sharing, intuitive appointment scheduling, seamless case tracking, ensuring up-to-date case details at everyone's fingertips. * The project has a strict deadline and needs to be completed and ready for use within a month. Desired Skills & Experience: * Proven expertise in cross-platform app development * Strong understanding of secure...
I need help with data entry and formatting for a Google Sheet. The data is to be sourced from ONLY 1 Website. Key Tasks: - Copy-pasting text information and images or screenshots from Website 1 into a Google Sheet. - Formatting the data in the Google Sheet with columns and tables. Ideal Skills: - Proficiency in data entry, specifically with Google Sheets. - Strong attention to detail to ensure accuracy and completeness of the data. - Ability to organize data efficiently using columns and tables along with images etc for capturing the User flow in a tree form . Example the website has Question 1 and N number of responses. Based on the responses there are different questions based on the responses. Need to capture that in a tree format.
