Autohotkey scraping excelงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...สามารถ 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
I am looking for an expert in Excel to design a dynamic spreadsheet for project tracking. This spreadsheet will focus on monitoring task progress and deadlines. Key Features: - Daily updates: I will be updating task progress and deadlines daily, and so I need the spreadsheet to be user-friendly and efficient. - Task highlighting: If a task is falling behind schedule, I need it to automatically become highlighted in red. This will help me prioritize tasks and ensure no deadlines are missed. - This will need to show throughput for every phase and also provide an average through in volume. Skills and Experience: - Proficient in Excel - Experience in creating dynamic spreadsheets - Understanding of project management principles. I look forward to working with a detail-orien...
I'm in need of a freelancer capable of efficient and precise textual data entry into Microsoft Excel. This project requires a keen eye for detail, a high level of accuracy, and excellent organizational skills. You should be fluent in English and proficient in using Excel. To make an informed bid, freelancers should include the following: - Examples of past work related to data entry, particularly with Microsoft Excel. Stats that display the accuracy and efficiency of your work would be a huge plus. - Any relevant experience in data entry or related fields. Please note, attention to detail and Excel proficiency are paramount to this project.
I'm searching for a well-versed Excel professional to create a mark sheet with Alphabetic grades input. The worksheet should have: • Only a single grading scale. • The ability to perform average calculations. The successful bidder should have extensive experience in Excel, with strong knowledge of creating custom functions for alphabetic grade calculations. Furthermore, understanding of academic grading systems will be a plus.
For this task, I am specifically seeking a freelancer who is proficient at data entry and familiar with Excel spreadsheets. The project primarily involves numeric data, so accuracy is vital. Key Responsibilities: - Input numeric data into an Excel spreadsheet. - Maintain a minimum 98% accuracy level. Ideal Skills and Experience: - Proficient in Excel. - High attention to detail. - Experienced in numeric data entry. - Proven track record of maintaining high levels of accuracy. Please ensure you have the necessary skills and experience before placing your bid. I look forward to your detailed proposals.
Need to extract data from website: , into an Excel file. Specifically name, discipline (medical practitioner, midwife, nurse, OT, physio, psychologist, podiatrist), location (incl suburb and postcode), initial registration date, registration expiry. There would be at least 100,000 rows of data. Only barrier, is this data is not able to be 'searched' efficiently. Individual names can be looked up. Or disciplines with a select number of names demonstrated...but I can't find a way to show ALL clinicians at once. Looking for a solution which can reliably pull all the names from the database.
I'm looking for an Excel expert who can build a simple yet effective sheet for basic arithmetic calculations. Key requirements: - Perform basic arithmetic operations: The main functionality of the sheet should be to perform basic arithmetic operations such as addition and subtraction. - Real-time collaboration: The sheet should support real-time collaboration, where multiple users can edit the Excel file simultaneously. Ideal skills and experience: - Strong background in Excel: The freelancer should have a deep understanding of Excel and the ability to create formulas for basic arithmetic. - Real-time collaboration proficiency: Experience in implementing real-time collaboration features in Excel will be highly beneficial. - Attention to detai...
I'm looking for a reliable and experienced data entry specialist who can assist me with entering data from images. The images will be directly uploaded to a website, and I need the data to be transcribed into various formats like Excel sheets, Word documents, and for copywriting purposes. Ideal Skills and Experience: - Prior experience with data entry from images - Proficiency in Excel and Word - Copywriting experience is a plus The primary goal of the project is to create a comprehensive database in various formats, so the ability to accurately transcribe and organize data is crucial. The chosen freelancer should have keen attention to detail and a high level of accuracy.
I need an expert to set up an automation system in Google Sheets for specific data from the NSE India website. Key Requirements: - Data Source: The data source will be ' Frequency: The automation should update the Google Sheets column once every day. - Data Display Format: The data in the Google Sheets should be displayed in percentage values. - Historical Data: No historical data tracking is required. The focus is solely on current updates from the source website. Ideal Skills: - Proficiency in Google Sheets and automation tools. - Experience with web scraping and data extraction. - Knowledge of data presentation and formatting in Google Sheets. - Ability to create a seamless automation system that updates the data accurately and timely.
...potential clients. - Convert conversations into promising leads. - Record conversational details into our database. REQUIRED SKILLS AND EXPERIENCE: - Exceptional persuasive communication skills. - Proven experience in lead generation. - Familiarity with the corporate events and conferences sector. - A resilient attitude to handle potential rejections and keep going. This role demands someone ready to excel in a fast-paced environment while showcasing dedication, autonomy and agility. Your ultimate aim will be to assist in the company's expansion through the successful generation of potential leads. This is an excellent opportunity for someone looking to apply and enhance their telecalling skills while significantly contributing to a growing company in the event managemen...
...manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for this project. The freelancer should be able ...
I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.
Specification: Facebook-Web-Scraping and Web-Crawling Write Swift Code that prompts the user to give username and password This information is used to login to facebook and scrape facebook for facebook friends and extract the following information: - Name - Birthday and month and if available year - Gender This information should be made available in a JSON or XML format. The code will be embedded in an app. It is important that this web-scraping activity can run in the background of the app invisible to the user.
...enthusiastic business, we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We're excited to colla...
I need an experienced PowerShell developer to create a script that logs me into , downloads today's menu, and displays it on a window. Requirements: - The sc...log in to bosch.aramark.cz. - After logging in, it should download today's menu. - The menu should be displayed in a window. - The menu display should be in the format: "Number of menu : Text of menu" with each number on a separate line and menu text following it. - The menu number should be displayed before the text. Ideal Skillset: - Proficient in PowerShell scripting. - Familiarity with web scraping is preferred. - Good understanding of GUI development. - Experience in parsing and displaying structured data is a plus. Please ensure the script is user-friendly and efficient. A clean, simple interface...
In search of a competent Excel specialist adept in Microsoft Access for multiple automation tasks. I need assistance with: - Macros Development: The main tasks include automation and creating tools. The proficient use of macros in daily operations is essential. - Report Generation: Specifically, the generation of technical proposal reports. Alongside this, the candidate should also be capable of automating the formula calculation process. Familiarity with financial, sales, and project status reports is an added advantage. - Tool Building: The capacity to build tools and other operations geared towards improving efficiency is crucial. Ideal skills include deep understanding of Excel functionalities, proficiency in Microsoft Access, extensive experience in automation via macr...
Me dirijo a ustedes con el interés de solicitar una cotización para el desarrollo de un bot automatizado. Este bot deberá ser capaz de responder mensajes de manera autónoma dentro de la plataforma LinkedIn, utilizando el perfil de un usuario específico, seguir y conectar usuarios. El bot deberá operar en base a una base de datos que se creará desde cero mediante técnicas de web scraping. Además, requerimos la implementación de un sistema de métricas que nos permita monitorear las respuestas automatizadas del bot. Entre las métricas de interés se incluyen: el seguimiento de contactos, las conexiones con contactos, los correos electrónicos enviados y la cantidad de respuestas generadas m...
I need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creati...
...manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for this project. The freelancer should be able ...
I need an expert to migrate my products from an Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Proficiency in handling product variations using attributes - Attention to detail for updating and modifying product descriptions - Excellent knowledge of data import/export and product management on WooCommerce. - Ability to ensure a smooth and error-free migration process.
I'm in search of an experienced graphic designer to design a logo that...designer to design a logo that fully encapsulates the identity of my data mining and scraping company, squrl.io. This project will require creativity to align the logo with the brand's modern tech essence. Your tasks will involve: - Creating a unique, eye-catching logo design - Ensuring the design matches with the identity of a technology startup in the data realm - Providing files suitable for websites, social media platforms, and databases Ideal skills and experience: - Proficiency in graphic design software - Previous experience in logo design - Knowledge about tech startup aesthetics and branding - The ability to align the logo with the purpose and spirit of , reflecting its data mining and s...
I have a significant amount of text that needs to be typed into Excel quickly. The data is in a simple text format, no complex formatting required. Key requirements: - Proficient in Excel and typing - Attention to detail - Ability to work under tight deadlines The data is straightforward text and requires no specific formatting or analysis. The ideal freelancer will be skilled in data entry and be able to commit to a quick turnaround time.
As a client with emphasis on quality, I need the support of an experienced Python programmer who can take charge of the frontend aspect of my web development project. At the core of this project are the following requirements: - Full proficiency in Python as the main programming language for the task - Demonstrated experience in frontend web development using Python - Familiarity with the best practices in Python programming - Capacity to effectively communicate, provide regular updates and accept feedback The missing response for the third question won't be an issue — I am more interested in a Python programmer who can bring their own unique ideas and solutions. You are encouraged to showcase your creative problem-solving skills. Apply if you have the necessary skills and ...
I am seeking an Excel expert who can meticulously enter extensive amounts of text, numeric, and alphanumeric data into my spreadsheet. The task involves entering names, contact details, sales information, and inventory data. The size of the task is quite substantial, with up to 1,048,576 rows and 16,384 columns involved. The role requires a keen eye for detail, accuracy, and dedication. If you are efficient in Excel and possess experience with handling large data sets, your skills will be highly valuable for this project.
I need a reliable freelancer to assist with data input. Here's a breakdown of the project: - **Task:** Your primary job will be to input data from online forms into either Microsoft Excel or Google Sheets. - **Experience Required:** It is necessary for you to have prior experience with both of these tools. This will ensure you're able to work efficiently and accurately. - **Attention to Detail:** Given the nature of the task, it's crucial that you have excellent attention to detail. Even the smallest mistake can have significant implications. If you have the experience and skills mentioned above, I would love to hear from you.
...problematic error with my Excel sheet. An error message keeps popping up and the sheet becomes protected every time I enter a price. Ideally, instead of locking the entire sheet, only specific columns should be locked when a password is triggered by clicking a button. Key issues: - Error message arising upon entering a price - Automatic sheet protection following action Work Required: - Identify and fix the error triggering the message pop-up - Adjust VBA codes to lock specific columns upon password entry: - Columns A to L - Columns Y, Z to AK - Columns CW to DH - Columns DO to DS - Columns DT, DV, DX, DZ, EB, ED For this task, I need a freelancer proficient in VBA and Excel, specifically with experience with sheet protection issues. A thorough understanding...
I'm looking for a skilled C++ developer to create a CAD software primarily focused on 3D modeling, compatible with Windows OS. Key Features: - Primarily 3D Modeling: The software should excel in 3D modeling capabilities, providing robust tools and functionalities for creating and editing 3D designs. - Compatibility: The software should be specifically designed to run seamlessly on Windows operating system, ensuring optimal performance and user experience. - File Format Support: The software should support importing and exporting of DWG files, for compatibility with AutoCAD files. Ideal Skills and Experience: - Proficient in C++: Extensive experience in C++ development, with a strong understanding of software architecture and design patterns. - CAD Software De...
Firstly, I want to know if what I am asking can actually be created in Excel 365 and used in Excel 365 Online. Please dont reply to this post without replying that it can or can't be done. If not, an alternative solution would be greatly appreciated. I need help creating an excel spreadsheet to track student progress in a course using 5 different options that also includes the date the option was selected. I can create the drop down list with the submission options, and apply color rules but I can not work out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell. I need to include the date the option was selected selected and because you can't have two formulas in conditional form...
I am in need of a proficient Excel expert who can create a custom spreadsheet for me. This spreadsheet will help in calculating the overtime rates for my 6 employees on a monthly basis. Key Requirements: - The Excel sheet should calculate 3 types of overtime rates: standard (1x), holiday (2x), and evening/weekend (1.5x) - The formulae should be designed to take into account that an employee works a 40 hour basic week with typical overtime of between 1-20 hours. - The sheet should take into account that the employees are not paid for 30mins of travel time to and from work, the employees tell me what time they left home, arrived at site, left site and arrived home. - Standard hours are 08.30-17.00 Mon-Fri with a 0.5hour unpaid break and a 0.5 hour unpaid break if working over ...
More details: What type of data do you need to type into the Excel sheet? Text What is the source of the data that will be typed into the Excel sheet? PDF documents Will the data need any kind of formatting or should it be entered as is in the source document? Enter as is
I need a thorough and capable freelancer to assist in data entry tasks. This project revolves around seeking out the contact details of companies provided by me. Key tasks will include: - Google each company name I provide - Gather relevant contact details such as phone numbers, email addresses, and the company's website As I am seeking information from ...Google each company name I provide - Gather relevant contact details such as phone numbers, email addresses, and the company's website As I am seeking information from a range of different companies without specific criteria, being detail-oriented and accurate will be crucial. Experience in data cleaning, analysis, and transcription would be advantageous. Understanding and utilization of web scraping techniques would...
I require a highly skilled professional with dexterity in MS Excel and Video Editing. Tasks will encompass: For MS Excel: - Comprehensive data analysis - Detailed spreadsheet formatting - Advanced formula creation for profound financial analysis. For Video Editing: - Apt video trimming - Expert color correction - Adding text and graphics creatively to videos. Ideal candidate will have proven ability in both fields, demonstrating both attention to detail in data management, and creativity in video enhancement. Proficiency in financial analysis and data visualization is a major plus.
...information, demographic information, purchase history) of customers on a sample customer file. The collected information will then be organized by customer name. - **Website Data Scraping**: In addition, the freelancer will be responsible for scraping data from a website. The main focus here will be customer data who use online payment methods. The specific data we're looking to extract is the 'Payment method'. This information will then be organized by customer name. **Ideal Skills and Experience:** - Strong data collection experience, especially in the context of customer data - Proficient in web scraping techniques - Attention to detail is crucial - Familiarity with organizing data in a meaningful way If you have the skills and experience in t...
