Macro data spreadsheet jobs

Hello, for our group of customers we need to create Excel template which will enable them to order our goods. We chose this method of ordering because the customer needs the solution by the end of this week and also that they are used to ordering via Excel template. The excel will contain macro which will control minimum order quantity and other conditions and if fulfilled, will enable to click on button which will create the output file (xml or csv). **IMPORTANT** We need the solution by the end of this week. Details in the attachment - pls. view it before asking questions. Thank you

I need a skilled developer to create a web scraper that performs daily data extractions, delivering the scraped textual content into an Excel spreadsheet. The project will involve setting up the tool to run an automated scraping process each day. **Requirements:** - Proficiency in Python and web scraping libraries. - Experience working with automation of tasks. - Ability to parse and structure text content. - Proficient in Excel spreadsheet formatting. **Freelancers with a background in data mining and automation will be preferred. Please include examples of previous web scraping projects, specifically with daily updates and Excel output.**

I'm seeking a freelancer skilled in data analysis and market research to provide in-depth insights on an Amazon brand's performance and competitive landscape over the past year. The specific deliverables include: - Historical sales volume data collection for the last 12 months - A detailed competitor analysis within our niche market The final output should be in a spreadsheet format, well-organized, and easy to interpret. Ideal Skills and Experience: - Proficiency in data analytics and research tools - Experience with eCommerce and Amazon marketplace - Ability to create spreadsheets with comparative data insights Candidates with a proven track record in delivering similar projects will be highly considered. I am looking forward to detailed p...

I need a skilled developer to create a web scraper that performs daily data extractions, delivering the scraped textual content into an Excel spreadsheet. The project will involve setting up the tool to run an automated scraping process each day. **Requirements:** - Proficiency in Python and web scraping libraries. - Experience working with automation of tasks. - Ability to parse and structure text content. - Proficient in Excel spreadsheet formatting. **Freelancers with a background in data mining and automation will be preferred. Please include examples of previous web scraping projects, specifically with daily updates and Excel output.**

...Integration of key financial statements: * Income statement * Cash flow statement - Development of an acquisitions model including: * Accurate asset valuation * Projection of potential returns - Utilization of advanced valuation techniques: * Internal Rate of Return (IRR) * Yield on Cost * Multiple on Invested Capital (MOIC) Ideal Candidate: - Proficient in financial modeling and spreadsheet creation - Strong background in mergers and acquisitions - Solid understanding of valuation methods, particularly IRR, Yield on Cost, and MOIC - Ability to analyze and project revenue and expenses effectively With a focus on clarity and precision, I anticipate the freelancer to deliver a well-structured model that aids decision-making in potential acquisitions. Please share ...

I'm seeking a detail-oriented freelancer who is proficient in Data Entry. Key task: • Enter over 500 different types of data (text, numeric, and image) meticulously and accurately. Required skills and experiences: • Expertise in handling Text Data, Numeric Data, Image Data • Proven experience with Excel Spreadsheets • Handle high volume data input Final Deliverable: • The completed project must be provided in the form of an Excel Spreadsheet.

...scrape details from 8 specified Dealer location websites. The specific data to gather includes the Business Name, Phone, Email (where available), Website (where available), Street Address, City, State, Postal Code, and Country. Furthermore, I have a comprehensive list of approximately 40,000 US Zip codes which are integral to this task. Key tasks include: - Web scraping of the aforementioned data from 8 specific Dealer location websites. - Using the provided list of 40k US zip codes as a base for the task. - Delivering the data in an Excel Spreadsheet format The ideal candidate should essentially have: - Proven web scraping skills, with attention to detail. - Proficient in Excel formatting and functions to ensure the data integrity and structured d...

I'm in need of a freelancer to assist with a data processing task focusing on text data within spreadsheets/whatsapp web. Attention to detail is crucial for the success of this project. - Task Requirements: • Precise transcription of text data • Verification of data accuracy and integrity • Organizing and formatting the text data as needed - Ideal Candidate Skills: • Proficiency in data entry and data processing • Familiarity with spreadsheet software (e.g., Excel, Google Sheets) • Keen attention to detail • Ability to work efficiently and meet deadlines Experience in similar data entry projects is highly valued. I look forward to reviewing bids and working with someone ...

I am looking for excel macro expert who could deliver a tool for creating a supply plan and a production plan based on demand input, current inventory and safety stock targets and production line capacity constraints.

I need a capable individual who can assist me with a data entry task. This project involves typing text into an Excel spreadsheet. The amount of data to be typed amounts to less than 100 pages. Ideal candidates should possess: - Expertise in Excel and data entry - High typing speed with accuracy - Excellent attention to detail - Experience in data cleaning and organization This project requires a freelancer who can complete the task efficiently and error-free. Proficiency in English is also crucial for this project task.

My project requires the development of an advanced analytics solution for predicting player performance and kill rates in Counter-Strike: Global Offensive (CSGO). The predictive model should: - Combine past game statistics and bookmaker odds...bookmaker odds for the most accurate and precise predictions. The past game stats should hold more weight in the computation. - Display the predictive hit rates as a percentage of the total games played. This model should be clear and visually accessible in a spreadsheet format. Ideal skills and expertise for this work include: - Proven experience in advanced statistical analysis and predictive analytics. - A strong understanding of CSGO strategy and gameplay. - High proficiency in using Excel or other data analysis tools for spre...

I'm looking for a talented...contact list of mobile phone shops and wholesalers across the UK. Here's what I'm looking for: - **Data Collection:** Each entry should include the shop/wholesaler's name, phone number, email ID, and address. - **Accuracy:** Ensure all information is current and verified. - **Organization:** Present data in a clear, well-structured Excel spreadsheet. Ideal freelancer attributes: - **Proven Experience:** Previous work in data mining or web scraping. - **Attention to Detail:** No room for errors in the data provided. - **Efficiency:** Capable of quick turnaround without compromising quality. - **Tools Knowledge:** Familiarity with scraping tools or methods is a must. If you're experienced in data...

...Pipelines. Here's what I'll need: - Development of an Excel dashboard utilizing VBA and macros. - Real-time tracking of pipeline statuses through a progress bar display. - Capability to automatically retrieve data from Azure Release Pipelines. - Implementation of error notifications and alerts to promptly address issues. - Integration of VBA code to approve release pipelines efficiently. - Adherence to our company's branding guidelines for a cohesive aesthetic. Ideal Freelancer Qualities: - Proven experience with Excel dashboard creation. - Strong knowledge of VBA and macro programming. - Familiarity with Azure services and their APIs. - Aesthetic sensitivity to match our brand's design ethos. - Ability to communicate clearly and deliver...

I have an excel file with multiple sheets, i need to pull data from another excel file. Both have multiple sheets, so i need to reference according to sheet name, and then columns. I need a macro i can run and it does everything. Or something similar that will work.

I'm seeking a freelancer with expertise in data extraction and Excel organization to handle a variety of documents for my project. Here's what I need: - Extract text, numbers, and table content from PDFs, JPEGs, PNGs, and hand-written notes. - Accurately convert and organize the extracted data into Excel, ensuring each originating file corresponds to a unique row in a spreadsheet. - Handle potentially complex data in a structured and error-free manner. Essential Skills: - Data Extraction and OCR (Optical Character Recognition) proficiency. - Advanced Excel knowledge, with experience in data sorting and macros. - Attention to detail and accuracy in data input. - Experience with handwritten note transcription is highly advantageous...

...a database that must be informative and easily manipulated for comparison. Requirements: - Collect agency contact details and websites. - Organize data into a sortable spreadsheet format. - Ensure accuracy and currency of information. Skills Needed: - Exceptional research skills. - Proficiency in data entry and spreadsheet management. - Attention to detail. - Prior experience in market research is desirable. Ideal Candidate: - Someone familiar with the migration industry. - Efficient in sourcing and verifying online information. - Adept at creating structured, user-friendly spreadsheets. Deliverables: - A comprehensive, sortable spreadsheet with the required information of each identified migration agency. Deadline: - I aim to have this project co...

Seeking skilled individual for regular web data extraction tasks. - Task entails pulling specified information from websites on a weekly basis. - Extracted data should be organized and delivered in Excel spreadsheet format. - Accuracy and attention to detail are paramount. Ideal skills: - Proven experience with web scraping tools and techniques. - Strong proficiency in Excel and data manipulation. - Ability to deliver on a weekly deadline with consistency. - Experience in data extraction projects, particularly with ongoing data needs. It's important that the freelancer communicates clearly and delivers clean, organized datasets. Familiarity with automated scraping tools or scripts to streamline the weekly process is highly valued. Please i...

I require a seasoned professional, well-versed with PowerAutomate, to automate my data entry process. The project involves: - Extracting data from an online PowerBi report. The data will be coming from four different visuals. - Each table will need to be pasted into an excel spreadsheet, replacing the existing data. The data to replace will be on three different pages in the spreadsheet, one page has two adjacent tables to replace. The freelancer hired for this project should have the following qualifications: - Extensive practical knowledge in PowerAutomate and data entry automation. - Experience in dealing with online PowerBi tables and spreadsheet data. - Detail-oriented with a knack for developing efficient syste...

I'm in need of a proficient team to accurately enter numeric data from 50-100 digital files into a database or spreadsheet. Requirements: - Fast typing and numeric data entry skills. - Experience with Excel or similar programs. - Attention to detail is critical for ensuring accuracy. Ideal Candidate: - Proven track record of handling large volumes of data. - Ability to interpret and enter data from PDFs and Word documents. - Excellent time management to meet project deadlines. Expectations: - Review each digital file for numeric data to be entered. - Ensure zero errors in data entry. - Communicate progress regularly. All qualified data entry gurus, I'm looking forward to your bids!

Extract values from the following website into the attached spreadsheet

I've got a list of court email addresses. All you have to do is send each of them an email, the email has 5 questions in it. Then, when they respond, put the response in a spreadsheet I made. This is an extremely easy task. I am taking bids. The lowest bid wins.

I'm looking for a skilled freelancer who can efficiently scrape an electronics webshop for comprehensive product data and organize it into an Excel spreadsheet. Here's what you need to know to submit a proposal: - Desired Data: - Product categories, subcategories & children (and more) - Product categories & subcategories textes - Product names, images, group, prices, unit, information, sku, ean, (?), article no., weight..... - Descriptions as HTML - Ideal Candidate: - Has experience in web scraping and data mining - Proficient in Excel or similar spreadsheet tools - Ability to organize and clean data effectively - Previous work on similar projects is a plus - Can provide a detailed approach to the project - Add...

My business receives court records monthly. We extract the names and mailing addresses from these court records. All of the courts format the records differently. Some are in excel, some pdf, some word, etc I need someone who can extract the names and mailing addresses from all of the court records - and put them in one excel spreadsheet. Rarely do people even read the job description - so please put the words 'radar data' at the top of your response so I know you have read the description. I will not respond otherwise When you bid, you are bidding on a small project of around 15-20 court records. For a total of 3,000 - 4000 names. The court records arrive the first part of every month, and need to be completed in about 3 days.

I need someone to send an email to 200 hundred municipal courts, (I have the email list of the courts) In the email will have 5 questions, when the court responds to the question, I need you to record the response in a spreadsheet I have. Everything will be as simple as cut and pasting. This is an extremely easy task. I am taking bids. The lowest bid wins.

I'm looking for an expert to Add a spec...is a multiclass classification for the histological images. The output must be structured into a comprehensive report print the plot of ROC and AUC for each class and the macro average then save it directly. **Requirements:** - Add the specific code of ROC and AUC ''I will send this code'' and run it in my code - Print the results of ROC and AUC with the class name, must include the percentages and plot for each class and the ''macro'' average for all classes - Save the results in the google drive directly **Ideal Freelancer:** - Proven Python & PyTorch expertise - Good understanding of data privacy for medical data The successful implementation of this feature is c...

I am looking for an expert in Excel reporting, with knowledge of deciphering and compiling sales, financial, and logistical data. The project will require: - Consolidation and reporting on sales and financial data. - Developing robust logistical reports that include product inventory, delivery timelines, and supplier performances, as well as other elements we may discuss later. Being proficient in Excel (Office Scripts, VBA Macros, ) and other spreadsheet software is a must, with a preference for those who have past experience in dealing with substantial financial, sales, and logistic data. While there is no pressing time constraint for the project completion, I seek someone who can work consistently and maintain open communication to ensure the project is p...

...Sales Data is pulled from Quickbooks and manually entered into a "Payments" sheet in the workbook. - When we process the workbook, it automatically pulls data from the Payments sheet and puts the related sales data into the appropriate persons commission sheet, in the same workbook. - We have used this for a very long time however, the workbook either has corruption or needs performance review as it takes several minutes to open and is very slow to navigate. So we would like a comprehensive review and fix of this workbook; * Check and repair as needed formulas and utilize conditional formatting to streamline tasks. * Check and repair or add macros to perform complex or repetitive tasks efficiently. - Enhanced capabilities of existing pivot tables;...

I'm on the hunt for a skilled professional who can create an automation program tailored to web scraping. - Target Website: The program must be designed to scrape data from one specific website that will be provided later. - Type of Data: I need to extract both text content and metadata from this site. Precise, complete, and structured data extraction is a must. - Detailed Info: The most critical elements to be retrieved from this data include product names, prices, descriptions along with various other pieces of information. All information to be extracted to Excel spreadsheet. See information detailed Information in the Excel document.

For my project, I require a proficient Excel user with a strong background in data analysis and data entry. Key Tasks to Perform: - Analysis of numerical data collected - Accurate data entry of said numerical data - Organization of data in a specific spreadsheet structure Ideal Skills and Experience: - Highly experienced with Excel and its functionalities - Strong knowledge of formulas and functions for data analysis - Excellent attention to detail for accurate data entry - An ability to accurately follow a specific spreadsheet structure Please bid if you possess these skills and can swiftly perform these tasks.

To streamline my records, I am in need of a proficient data entry specialists to assist with entering a combination of textual and numerical data into my spreadsheet. This comprehensive project involves approximately 10,000 invoices, each containing an average of 18-20 fields - this includes, but is not limited to, information such as vendor code, invoice number, and date. Skills and experience required: - Mastery of spreadsheet functions and formulae - High level of accuracy and attention to detail - Previous experience with invoice data entry would be advantageous - Ability to handle high volume of data-entry efficiently

There are around 2400 products. Products are divided into Categories. You have to check the spreadsheet below and add attributes to the product mentioned on the spreadsheet. https://docs.google.com/spreadsheets/d/14ubsbv-AZuXxLNgxWH38c-51GceGhYDi7W8KMFvqSaE/edit#gid=0 We are not providing you the values to select for attribute. You have to do it by yourself. For example, Colour -you have to check the colour of the product and select the value. Finish is mentioned on the product tabs. Sofa seats - you have to look at the image of sofa and find how many seats it has. Bed size is mentioned in dimension. If not mentioned then please guess. Material - it is mentioned in finish or you can see on the products what materials are used like wood, cloths, glass, leather etc.

...site comprising of around 10 pages. With all necessary files and graphic designs readily available in PDF, the site requires: - User registration and login - Product search and filtering - The capability to save pertinent data into a spreadsheet - An "Order" function that operates as a "Send Order" email button the features are: - there is a chart that will take data from a spreadsheet in Google Drive - need to storage data like account login, orders (No need payment functionalities) - the orders logic will be done simply by sending email with the data of the order - there will be some videos to be attached to the clicking at some images in a grid (page "Academy") - the first part of the pages are ...

I am seeking a skilled data scraping expert to gather information for a marketing campaign targeting the Melbourne metro area hospitality scene, specifically restaurants, cafes, and bars. The objective is to create a robust database that will aid in promoting our services within this sector. **Requirements:** - Scrape data for at least 3,000 unique establishments. - Collect the following fields: - Business Name - Email Address - Phone Number - Physical Address - Ensure accuracy and currency of data. **Preferences:** - The data must be delivered in an Excel spreadsheet, well-organized, and ready to use for marketing purposes. **Who Should Apply:** - Freelancers with proven experience in web scraping and data mining. - Proficiency in us...

I'm in need of a devoted freelancer with a knack for detailed data entry to collect numeric data from digital files that I will provide. Your primary role will involve: - Thoroughly reading through the supplied files. - Accurately entering numeric data from these files. - Ensuring that the entered data is correctly delivered in an Excel Spreadsheet format. Ideal Skills: - Proficiency in data entry tasks, specifically with numeric data. - Proficiency with Excel spreadsheets. - Good attention to detail. - Ability to work under deadlines. Experience with handling numeric data from digital files would be a major plus. Accuracy is paramount in this task, and so a keen eye for detail and dedication to precision is crucial for the s...

...Refundable Tax on Revenue @ 18% Monthly/Quarterly/Yearly Growth (with charts) Implementation Options: Excel Spreadsheet: Utilize Microsoft Excel or Google Sheets to create a customized spreadsheet with formulas and data visualization features. Organize the data in a structured manner, using sheets for different categories (e.g., projects, financials, growth analysis). Benefits: Efficiency: Streamline project management processes and calculations in one central location. Analysis: Gain insights into financial metrics, revenue trends, and growth patterns. Decision Support: Make informed decisions based on comprehensive data. Suggestions for Enhancement: Explore automation options for data input and updates. Integrate with financial APIs fo...

I'm seeking an experienced data scraper to compile an extensive contact list of Australian mortgage brokers. This collection should be executed via a web scraping tool and ultimately provided in an Excel spreadsheet format. Requirements: - Proficient in automated web scraping tools - Experience with data extraction and compilation - Ability to deliver clean, organized data in Excel format Scope: - Extract contact data from relevant sources - Data fields: Name, Phone, Email, LinkedIn Profile, Business Name, City (Address) - Data accuracy and verification is paramount Deliverable: - An Excel spreadsheet with the specified broker information By applying, ensure you are adept at locating intricate details and comfortable with t...

...customer details across two spreadsheets and compile a clean, merged spreadsheet. Here are the specifics: - I have two spreadsheets with jobs listed in them, the first spreadsheet is a list of all the jobs titled "all issued work - November 2023" and the second spreadsheet is called "Vodaphone jobs". - I need all the jobs listed in "Vodaphone jobs" spreadsheet to be identified and matched to the first spreadsheet titled "all issued work - November 2023". I then need all the matched Vodaphone jobs to be put into a new spreadsheet so that we have all the job details available. You will see the "Vodaphone jobs" spreadsheet does not have the same level of information available as the "...

I'm seeking a skilled developer to transform my existing spreadsheet pricing list into an online digital pricing estimator. The primary objective is to streamline the pricing process with a user-friendly interface for estimating costs. Key Project Requirements: - Incorporating between 50 and 100 products/services and their respective price variables into the estimator - No integration with CRM or ERP systems needed - Deliver a solution that minimizes errors and simplifies the pricing process Ideal Candidate: - Proficiency in web development and UI designing - Experience in creating custom cost calculators or pricing estimators - Detailed understanding of spreadsheet data manipulation and transformation - Ability to work independently with minimal guidance - St...

...looking for a detail-oriented freelancer to assist with text and image data entry. I have both text data in digital formats (PDF, Word) and images that need to be systematically entered into a database or spreadsheet. Accuracy and efficiency are crucial. Ideal Skills & Experience: - Proficiency in data entry with a keen eye for detail - Familiarity with digital text formats and image data processing - Experience with database management and spreadsheet software - Strong organizational skills to categorize and manage data Responsibilities: - Enter text data from PDF and Word documents accurately - Process image data to fit database specifications - Organize files and ensure data is entered systematically - Verif...

Spreadsheet organization, data mapping and web scraping from Google Scholar, as discussed - to be delivered today.

...to efficiently transfer text data from job boards into a well-organized spreadsheet. Very simple and straightforward. - Skills Needed: - Proficient in data entry with a focus on text information - Experienced in sourcing data online - Skilled in organizing data within spreadsheets - Attention to detail to ensure accuracy - Ability to meet tight deadlines - Project Requirements: - Gather text data from specified online sources - Enter data into a structured spreadsheet format - Ensure the accuracy of all entered information - Organize columns and rows for ease of use and understanding - Deliver the completed spreadsheet in a mutually agreed-upon timeframe - Ideal Candidate: - Has previous experience ...

I need to collect real estate listings data from a web page into a spreadsheet: Here is a link to a webpage: !sunny-isles-beach It has about 75 properties (buildings). These are all the buildings in this town. For each building, there are number of units for sale. Average number of units for sale is about 10 for each building. You'll need to click on each building, click on every unit listing and collect 12 points of data for each. These points are as follows: Name Address Price Beds Baths Half Baths Area $/ Date listed Days on market HOA Tax Attached is a spreadsheet with an example of what I expect the output to be. I'm estimating 700-800 total lines (one line for each unit for sale).

I am seeking a proficient Excel expert to develop a comprehensive asset management spreadsheet catered to equipment tracking. The key features of this project will include: - Automated calculations for a dynamic and responsive data handling - Data visualization charts for ease of understanding and presentation - Depreciation Tracking for accounting and valuation purposes. The spreadsheet will focus on tracking equipment-based assets. Regarding the categories of information, the following will be core: - Purchase information details - Comprehensive maintenance history - Current valuation of the equipment - Asset utilization tracking - Comparisons between actual and forecasted income - Forward forecast maintenance for effective planning. Ideal freelancers f...

I'm seeking a meticulous individual to assist with my spreadsheet data entry task. Familiarity with basic data input is the primary requirement for this project. Familiarity with matching data to existing formats is vital. Through your skills in basic data input and keen attention to detail, you will ensure smooth data flow and accuracy. Ideal Skills and Experiences: - Proficiency in basic data input. - Ability to match data to existing formats. - Exceptional attention to detail. - Experience with spreadsheet based projects.

I need a detail-oriented freelancer to transform my digital files into a well-organized Excel spreadsheet. Your tasks will include the following: - Transcribing content from PDF and Word documents into Excel. - Performing moderate calculations as data is entered. - Ensuring the spreadsheet is formatted for clarity and ease of use. - Validating all data for accuracy. Ideal Skills: - Proficient with Excel and performing calculations within spreadsheets. - Experience with data entry from various digital file formats. - Strong attention to detail and commitment to accuracy. - Ability to organize data effectively for analysis and reporting. The right candidate will have a proven track record of handling similar tasks and the ability to deliver high-q...

I'm seeking a knowledgeable expert to assist with an Excel project that primarily involves financial data. Key responsibilities will include: - Creating complex formulas and calculations - Formatting and designing the Excel spreadsheet for improved functionality and ease of analysis A solid understanding of financial data analysis is preferred. A successful freelancer would have comprehensive knowledge of Excel, including formula generation and sheet formatting. Prior experience working with financial data sets would be a definite advantage. If you are meticulous, analytical, and excel at Excel, then I am excited to hear from you.

I'm looking for a skilled freelancer to transform my basic draft of an Excel spreadsheet into a polished, professional accounting statement designed to impress my customers. Here's what I need: - **Data Inclusion**: The statement should feature specific categories such as Purchase Orders, Claims, and Invoices, neatly organized to provide a clear financial overview. - **Customization**: I want the ability to customize fields and layout. The statement should not only accommodate my current data but also reflect my company's brand identity. - **Expansion Capability**: To manage data efficiently, implement a dropdown menu system that allows for easy selection of various data sets without compromising the document's structure. **Ideal S...

I'm seeking a highly skilled freelancer to create a simple spreadsheet model aimed at policy analysis of the implications of wages growth for the change in income tax payable at different tax thresholds over time, also known as bracket creep. The model should accommodate different assumptions about wages growth. Thresholds and examples will be provided.

Create a Macros that will use a downloaded report that will contain the information from "Employee" tab columns A-H and automatically add the information to "Employee" tab and also "Employees IPM" tab. The macros should look in the spreadsheet for the position ID number, if it finds a match then nothing happens, if the report contains an ID that is not in the spreadsheet then it will add the information from columns A-H to both tabs. If a position ID is in the spreadsheet but not part of the report then it will remove it from both tabs. It would be helpful to get a pop up letting us know if anything was added or removed.

I'm seeking a professional to create a complex and well-structured spreadsheet predominantly using text data, with the primary purpose of facilitating record keeping. The spreadsheet will serve as an important organizational tool within my operations and needs to be designed in a thorough and meticulous fashion for easy navigation. Ideal Skills for this project: - Proficient in Excel or Google Sheets - Experience in designing spreadsheets for record-keeping purposes - Keen attention to detail - Strong communication skills Please note, there is no requirement for automation features, macros, or formulas for this project. The focus is solely on the organization and structure of the data.