Where to outsource excel spread sheet data mining jobs

I am seeking a skilled data miner for a project involving business data extraction from the Yellow Pages. Specifically, I am interested in the category of 'Equipment Hire in Australia'. The scope of the data to be extracted includes: - Business Names - Phone Numbers - Physical Addresses - Email Addresses This project would be ideal for freelancers who have experience in data mining, data extraction, scraping Yellow Pages, and processing information through Python, R, or a similar language. Knowledge of the business environment in Australia would be a plus. Please note that accuracy is paramount; I need the completed dataset to be as error-free as possible. Looking forward to reviewing your bids.

I'm in need of a skilled Excel expert who can help me build a formula that integrates data across multiple sheets. The formula needs to leverage advanced functions like VLOOKUP, INDEX/MATCH, and ARRAY. Key Requirements: - Advanced Excel proficiency - Expertise in VLOOKUP, INDEX/MATCH, and ARRAY functions - Experience with multiple sheets data integration - Strong problem-solving skills and attention to detail Please note that this isn't a project suited for beginners in Excel. You should have a proven track record in working with complex formulas and integrating data across different sheets. Your ability to deliver accurate and efficient solutions will be greatly valued.

I am struggling with incorrect results when attempting to subtract two values in a column of clock times in Excel. My data is in a 12-hour clock format, and I signify AM and PM directly within the time cells. I require an expert in Excel to address this issue promptly. To take on this project successfully, you should have: - Proficient Excel skills - Solid understanding of the 12-hour time format and functions in Excel - Ability to troubleshoot and rectify the problem quickly

**Project Overview:** We're looking to set up a Zoho Portal that allows users to create emails using their custom domain and integrate them with Zoho Sheets. The goal is to replicate the functionality of an existing Google Apps Script that forwards emails to Google Sheets. The freelancer will be responsible for configuring the Zoho Portal, setting up email forwarding, and integrating Zoho Sheets to achieve seamless email-to-sheet automation. **Prerequisites:** - Access to Zoho Mail and Zoho Sheet. - A custom domain configured with Zoho Mail. - Basic knowledge of Zoho Mail, Zoho Sheet, and email forwarding. **Scope of Work:** 1. **Zoho Portal Setup:** - Configure the Zoho Portal to enable email creatio...

I have some duplicate data that need to be copied to different sheets. - The project entails copying the duplicate information into different sheets. - The reasoning behind organizing the data into separate sheets is so that I can perform statistical analysis on each set distinctly. This will enable me to have cleaner and clearer results, helping in decision making. Ideal Skills: - Proficient in Excel or any other data manipulation software - Experience with data entry and copying

...based on Excel template and Data - you product financial Statement with filled out excel based on data given We need an expert Freelancer to enter basic financials data to attached financial Projection in Excel and produce a profit loss statement based on this Excel attached and the data of company projected Revenues and expenses Simple if you have done it before You will send us back the filled out excel with sheet tabs including the Financial Planning Tab and Profit Loss. Budget is $200 - $300 +/- Very Simple just summarize and detail the data correctly any questions or data you need for this ( not given in attachments in zip ) we will give you You need to put all Hungarian For...

I am in need of a skilled accountant to help with the preparation of my financial statements. The ideal candidate will have experience with Xero. Key requirements of the project include: - Preparation of Income Statement, Balance Sheet, and Cash Flow Statement - Proficiency with Xero accounting software Please note, the successful applicant should have a strong background in accounting, with prior experience in financial statement preparation being highly valued.

I am looking for an experienced freelancer who will assist with copying data from my Microsoft Word and Excel documents. The copied data will then be pasted into Google Sheets. Key tasks include: - Copying data accurately from existing Word and Excel documents - Pasting the data into a new Google Sheets document - Organizing the data in a clear, readable format Ideal skills and experience: - Proficiency with Excel and Google Sheets - Demonstrated experience in data entry - High level of accuracy and attention to detail.

I need someone to post jobs for me on indeed and reply and orginziae replys into google sheet

Hello, I would like to have an Unreal Engine 5 map designed. It would be a jungle island (think sort of caribbean inspired) covered mostly in jungle type terrain, a few rivers winding through it, with a mountain range and volcano in one area, as well as the surrounding sea floor. I would like it to follow earth like geography as much as reasonable. I would also like it to be able to be dynamic, with native villages potentially moving around, maybe little charcoal/fishing/hunting/lumber camp type villages dotting the landscape, and the ability to be developed by an exploration group (building port cities, establishing mines, etc.) I'm thinking I would like it to take about an hour to traverse from one end to the other on foot at i...

Seeking a freelancer with expertise in Excel and PowerPoint for a project involving more than 5 Excel files. The task at hand is to assist with presentation design. Skills and Experience required: - Proficiency in Excel and PowerPoint - Strong design skills - Experience with handling multiple Excel files - Attention to detail and ability to create visually appealing presentations

I'm looking for a weekly editable check-in sheet for my fitness clients, to be created in Google Sheets. - The sheet should contain sections for clients' names, contact information, weight, body measurements, workout details, and progress. - Each client should have a separate sheet, making it easier to manage and update the data. - The sheet should include formulas for tracking workout improvements, such as increased weights or reps. - Each sheet should be able to be progressed for approximately 8 to 10 weeks and should be editable week to week. - Ideally this sheet would be a template that I can use over and over again with clients. The ideal candidate for this job should have: - A good un...

We operate a Google Sheet that fetches information from another spreadsheet identified in cell C1. Users mark checkboxes in Row A and click "Build Documents." When a user picks multiple checkboxes to generate documents, the Google Script halts after 300 seconds due to an overload. The objective is to devise a systematic workaround to finish processing the document batch without additional manual intervention. For example, here's a replica of the spreadsheet you can use to test your code. The documents created all appear here: Then deploy the working code to the Original spreadsheet. All bids are final

I need a professional with a significant background in data management, who can assist me in streaming entire worksheets live from my desktop Excel file to my Google Sheets. The core requirement is to: - Stream the entirety of my existing Excel worksheet data into Google Sheets instantaneously and update it in real-time. The ideal freelancer should: - Be experienced in data integration across various platforms. - Possess comprehensive expertise in both Excel and Google Sheets. - Have a past track record of successfully completed data streaming related projects. - Be able to implement a solution for real-time data update.

I'm seeking a versatile individual to assist in constructing the digital framework for a groundbreaking think tank. The ideal candidate will excel in the following areas: - Website Development: You will be responsible for constructing a user-friendly platform that encompasses discussion forums, document sharing, and other essential features. - Forum Features: You'll need to design and implement efficient user profiles, thread categorization, and effective comment moderation. - Document Sharing: The platform should support the sharing and collaboration of research papers and reports. Experience or skills in the following areas are highly valuable: - Intelligence analysis and investigative journalism - Data analytics and project management - Mental h...

I am looking for a detail-oriented professional who can assist in copying and pasting data for my business, BD Company. Required tasks: - Copy data provided in Excel sheets. Ideal Skills: - Proficient in Microsoft Excel - High attention to detail - Strong data entry skills Apply only BD interested person.

I am looking for a developer who can design a data uploader for my website. The primary purpose of this tool is to allow me to upload different types of files such as Excel spreadsheets, CSV files and Text files into my website's backend. Key Requirements: - Support for multiple file types: The uploader should be able to accept a variety of file formats, including Excel spreadsheets, CSV files, and Text files. - Basic Data Validation: Before the data is uploaded, I need this tool to perform basic data validation. This would involve checking for field completeness to ensure that all necessary fields are populated before the upload is allowed. Ideal Skills and Experience: - Proficiency in web development: Th...

I'm looking for an google sheets / excel guru who can construct an advanced drop-down lookup system for my entire sheet. This system should include multiple variables that will inform the price from the database. Currently looking up values manually in a series of tables, tables may need reformatting to allow for efficient searching Key skills and experience: - Proficient in MS Excel Advanced Functions - Experience with both numerical and text data - Knowledge of creating drop-down lookups for entire sheets The final product should streamline our decision-making process by providing agile, accurate prices based on the selected variables. Your comprehensive understanding and application of numerical and text data within an Excel envi...

I am c...currently struggling with a specific issue in my App Sheet. The drop-down functionality isn't functioning as expected - it's not populating the correct values. I need assistance in making it work properly. The ideal candidate for this job would be an expert in App Sheet, with experience working with drop-down functionalities and troubleshooting them. Knowledge in data entry forms and calculations and formulas is a plus. To summarise, your job would be to: - Troubleshoot and fix the drop-down functionality in my App Sheet - Ensure correct values are populating in the drop-down list - Optimize for future efficiency and user experience. Please, only apply if you can demonstrate relevant past work in this area. We will collabor...

I require a VBA Developer well-versed in automating repetitive tasks in Microsoft Excel. Your primary task is to automate my existing work functions to increase efficiency. Key Responsibilities: * Understand the current Excel operations and identify scope for improvement. * Develop VBA codes to automate basic standard operations. * Test the robustness and accuracy of the automation. * Combining 2 files into 1 pdf. 1st file is pdf and 2nd is excel(with selected sheets, and selected columns within sheets) Desired Skills & Experience: * Proficient in VBA, specifically for Microsoft Excel. * Experience in automating repetitive tasks. * Sharp problem-solving and debugging skills.

Seeking a proficient Excel VBA developer to aid in the centralization and automation of tasks in Excel 2010. Project requirements include: - Expertise in Excel latest version - Strong understanding of EXCEL VBA for automation purposes. Please note, specific tasks and functions to be automated in VBA have yet to be defined. Flexibility and broad knowledge in different Excel functions will be considered an asset.

...for a professional with strong data entry skills to assist in transferring text data from digital documents into an excel sheet. The successful candidate should possess: - Reliable accuracy in typing - Fast typing speed (numeric keypad advantageous) - Proficiency in Excel (VLOOKUP, SUMIFS, Pivot Tables, etc.) - Able to interpret written information swiftly - Excellent attention to detail for proofreading entered data. This task will require someone with experience in handling large volumes of data entry, with absolute prioritization on maintaining the integrity and accuracy of the inputted data. Any previous involvement in similar projects handling text data is highly desirable. Understanding of and...

I'm seeking a skilled financial modelling salesperson to help me find clients based out of US/UK/Europe who are looking for candidates who can create advanced financial models with the aim of improving their financial forecasting, investment analysis, and risk assessment. Your responsibilities will include: A) Finding clients who are looking to outsource their financial modelling work. B) coordinating and setting up meeting with prospect who are interested in the above work. Ideal candidates will possess a strong background in financial modelling, exceptional communication skills, and a proven track record in sales. Experience with company financial statements, market research data, and historical sales data is a huge plus.

Hello, i liked your work you did a few years ago for a christmas flyer. We need a concert flyer including a program sheet (on the backside) for our school orchestra's summer concert. Style: Clipart black-and-white/gray objects like dance foot prints and simple fonts. The goal is to copy the flyer on colored paper using a photocopier to keep costs low. The concert information is located on the back. Are you in? I would need it within the week.

I need someone with specialized skills in password recovery to restore a forgotten password for an Microsoft Excel worksheet. This task requires a professional password hacker. I require one spreadsheet opened and password recovered and removed. Skills and Experience required: • Proficiency in programming languages, particularly those relevant to password recovery. • Expertise in methods of password recovery for Microsoft Excel worksheet xlsx files. • Strong ethics - the information on this spreadsheet must stay confidential. • Can deliver results within 7 days. • Will pay on successful confirmed completion only.

I require a proficient freelancer to design a distinctive Excel file that will be used for web form completion. Once the Excel file is uploaded, the system should automatically read and fill the corresponding fields. These may be a composition of dropdowns, text or checkboxes with comprehensive validation, such as numbers-only constraints, email format requirements, date format validation, dropdown list checks, value ranges among others. Ideal Skills: -Qualified in Excel -Understanding of data validation Experience: -Web development -Scripting in Excel -Web form design -Experience designing similar projects Please note that while the specific dropdown fields were not detailed, anticipate flexibility and adaptability in the code to confor...

...software developer to create an intuitive application. This app is intended to utilize LangChain and OpenAI's language model in categorizing PDF files into different groups; namely invoices, HR-contracts, or MOUs and then under go different ways for each document catagory: A. in case of invoice: - extract the data inside invoice (invoice number, date, buyer name, total amount sold, and total due amount) and save them in an Excel file. B. In case of HR-contract: - simply move the file from the existing location to the HR-contract folder. C. In case of MOU: - simply move the MOU from the existing location to the MOU folder. Details: - Your responsibility is to build a desktop application that processes and accurately categorizes ...

I require a proficient Excel expert with strong skills in data analysis and organization. The primary tasks you will handle include: - Analyzing business-related data - Organizing the analyzed data in an easy-to-understand format The purpose of these tasks is to help streamline business reporting processes. You must be adept at dissecting large volumes of data and summarizing key points to help inform business decisions. The final deliverable should be a standard Excel file that details the organized and analysed data. Relevant skills needed include data analysis, Excel proficiency, and a keen understanding of business data interpretation.

I'm in need of a fitness expert who can develop a comprehensive personal training program sheet for my clients. The ideal candidate would have a strong understanding of exercise physiology and program design, as well as extensive experience in personal training. The program should cater for three main fitness goals: - Weight loss - Muscle building - Endurance training It should also cater to two levels of fitness experience: - Beginners - Intermediate The training frequency may vary, though it typically falls between 3-5 days a week. I need the program to be versatile and adjustable according to the individual's schedule. Include - Nutrition - Graph for progress (weight, fat percentage, habit tracking, calories/steps calculator) whether fitness ...

I'm seeking a computer science tutor to guide me through QuickBooks and Excel. - Topics include QuickBooks, Excel, data structures, algorithms and programming languages. - Primarily need help with data entry and organization in QuickBooks and Excel. - Additionally, assistance with Formulas and Functions in Excel is required. Ideal candidate should have: - Proficiency in QuickBooks, Excel and knowledge of data structures and algorithms. - Strong background in programming languages. - Experience in tutoring or teaching will be a plus. Please note that the volume of entries or rows of data is minimal, less than 100. Looking forward to your proposals!

...looking to master SQL, Excel, or Python? Look no further! With years of experience in data analysis and programming, I offer comprehensive tutoring services tailored to your learning needs. **What I Offer:** 1. **SQL Mastery:** From basic queries to advanced database management, I'll guide you through understanding SQL syntax, optimizing queries, and database design. 2. **Excel Expertise:** Whether you're a beginner or looking to enhance your Excel skills, I'll cover everything from formulas and functions to data visualization and automation. 3. **Python Proficiency:** Dive into the world of Python programming with personalized lessons covering fundamental concepts, data manipulation, scripti...

...looking for an urgent build of a program to visually present and evaluate the quality of images in a Word document or PDF. The key features and functions of the program include: The objective is to develop a user-friendly program that organizes and presents images sourced from Word documents or PDFs. On the interface, Part A images will be displayed on the left side, while corresponding Part B images will be arranged in a tile layout on the right side. Filtering will be based on the presence of the "AAA" substring, and users will have the flexibility to choose the sequence of "AAA" substring images they wish to view—either the first, second, or third occurrence. The program will enable users to assess the quality of the Part B...

I'm looking for a capable designer who can create a modern ...must be modern in style - The final deliverable should be in a word or excel format to allow for editing Content: - The title card should include the song title and artist in the right portion - A photo element should also be incorporated for visual appeal in the left portion. I'd like a card similar to the one you see here. It's exactly 18cm wide x 12cm high. However, the photo portion should be smaller, as the text does not contain the Artist, which I need. I have attached some examples here. Photos # 4 5 and 6 are from my actual machine. I need to edit and make 100 of these. There should be 22 columns on the right side for the Number Title and Artist text. Ideally, I wou...

A reliable database migration specialist (with previous email campaign setup skills) with their own computer and internet to work from home. You will be working with the Microsoft SQL server, experience is preferred but not essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experie...

I need my resume's job roles to be re-positioned in chronological order. This is a simple task for someone that knows their way around resume editing. The job is quite straightforward, all you need to do is: - Reorder the job roles in my resume to follow a chronological order. I need the Outsourced record switch from the GO-Outsource record, and Outsourced changed for present to March 2023

...seeking a proficient data collector who will assist me in acquiring vital information necessary for our sales and marketing campaigns. You'll be tasked with compiling a reliable list of emails and phone numbers for technology directors in K-12 school districts that I will specify. The ideal freelancer for this project: - Has a solid background in data-mining - Understands US K-12 Education System - Is meticulous and accurate The required data should include: - Technology Director's name - Their emails - Their contact numbers Accuracy and timeliness are critical for this project. Please only commit if you are confident you can deliver with great efficiency. This is a great opportunity for you to display your ability to garner h...

I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

...this form is to accurately calculate the cost of chosen services. My business involves a multitude of services, and I need an within-the-business platform that allows for easy calculation based on user preference. Here are some specifics: - Carousel selection of services: your form should allow selection of various services provided by my business. - Calculation logic: Addition is the primary calculation required. The system should be able to add up the costs of selected services. - Data entry: Your form would need to support product selection-based data entries. - User interface: the form should be easy to navigate, with clear instructions for inputting service choices. Ideal Candidate: - Proven experience in designing excel forms wit...

...that returns no results then by company name, or if that returns no results then by property address to find the email. Once the email is located append it to the row in column AW. Once completed, prefix “processed_” to the file name. Api to use: skip force Key Requirements: - The script should be able to scan a specified Google Drive folder for files. - When a file is found, the script should process it by skip tracing. This involves cross-referencing the information in the file with first names and last names, company names or property addresses. - The script should be able to handle files that already exist in the specified folder. - The script should be robust and reliable, able to handle a large number of files effi...

...proficient Excel expert who can assist me with enhancing my current study time tracker. I need the following features to be incorporated: - Auto-calculation of total study hours: I'd like for this to be automatically summed up based on the inputs provided. - Auto-calculation of average study hours per day: This should also be done automatically, providing me with a clear view of my daily commitment. - Study hours per subject: I require a part of the spreadsheet to allocate study hours to specific topics that I am learning. The spreadsheet will be utilized for tracking my study progress across different subjects. It should allow for easy input of study hours and materials covered. I will provide the current version of the spreadsheet to...

...expert, your task will be to fix a challenge I'm facing with PHPSpreadsheet. My Excel data is not being imported correctly into MySQL as tables are not being created. Despite no error messages alerting me to these issues, the hiccup persists. Below is a more detailed description. After login, the user uploads 4 required and 2 optional Excel files on the dashboard page. The files are uploaded to an “upload” folder on the server and the file names and other info are stored in the “files” table of the mysql database. All of the above works with no problems. Once the actions above are complete, a button at the bottom of the dashboard page is activated. When the button is pressed, PHPSpreadsheet is used to mo...

I have an Excel spreadsheet containing a list of data, from which I need specific email addresses extracted and organized. Key requirements: - Extract email addresses: You'll need to go through the spreadsheet and locate email addresses contained within the data. - Excel Organization: The extracted email addresses should be neatly and accurately organized in the Excel spreadsheet. Each email should be placed in a separate cell. Ideal Skills: - Proficient in Excel: Ability to efficiently navigate and manipulate data in Excel. - Data mining and extraction: Skilled in identifying and extracting specific data from larger datasets. - Attention to detail: Accurate organization of email addres...

I am currently seeking a professional who can obtain email contacts for facilities maintenance staff for business introductions. These introductions will focus on the services and physical products my company offers. Ideal candidates should be experienced in: - Data mining or gathering - Understand privacy and act compliantly The aim is to reach out to potential customers for vendor outreach. The successful freelancer will skillfully gather legitimate contact information without breaching privacy rules. Familiarity with the facilities maintenance industry would be a bonus but isn't essential.

I have a requirement to develop a bespoke Microsoft Excel spreadsheet to calculate sales commissions. Let me share the specifics: - The variables: I want this spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined according to a custom formula that considers the Commission Percentage. - Data input: The spreadsheet should be easy to use, allowing me to manually input the data for calculation. The ideal freelancer for this project would be someone well-acquainted with the mechanics of Microsoft Excel and its formulas. Relevant experience in the field of sales calculations would be an asset. ...

I'm looking for a developer who can establish a connection between a wireless barcode scanner and Google Sheets. On my sheet I have: Serial number - Client name - Product process 1 - Product process 2 - Product process 3 - Delivered. I'd like to be able to put the Barcodes on my products and once they moved through production, scan them and the sheet will update itself to show progress. I'm currently doing it manually.

Hi, I'm looking for someone who can write script to automate daily data importing from csv files into a google sheet. We use a new google sheet each week to calculate production for each day, see example here: We have two online platforms that we receive orders through, one for wholesale customers and another for retail customers. For wholesale we use Ordermentum - www.ordermentum.com. To access the production reports we have to: 1. Open the "orders" page 2. Select the relevant delivery date 3. Export the production report for that date This data needs to populate into the relevant date column of the "ORDERMENTUM" tab in the google sheet. See sample production report attached (product

I have a substantial Excel spreadsheet that requires competent attention. I'm on the lookout for someone who's proficient in: - Data entry - Data cleaning Your role will primarily involve entering various types of data that's currently on an Excel spreadsheet. Despite the data being available, it's in a raw unclean format that needs some cleaning. The ideal freelancer is someone who's used to working with Excel and recognizing inconsistencies, errors, and redundancies. Additionally, anyone versed in: - Proficient in Excel usage - Strong attention to detail - Experience in data cleaning - Strong data entry skills would be extremely helpful in achieving the goals of this project.

We are seeking an experienced web developer to create an advanced instant quote form on our WordPress-based trucking company website. The form will integrate Google Maps for autocomplete suggestions and pull real-time data from Google Sheets to provide visitors with instant truckload quotes. Key Features Required: Google Maps Integration: Autocomplete suggestions for 'Pickup City, State' and 'Delivery City, State' using Google Maps API. Google Sheets Integration: Dynamically pull data from a Google Sheet that includes truckload rates, which are updated weekly. The data includes Pickup and Delivery points, Dead head radius, Max weight, Rate, and Rate per mile. Form Requirements: Fields for Pickup City, State; Delivery City, ...

...customizing one of my Google Forms to a Google Sheet in order to obtain graphical data representation. Key Responsibilities: - Identify and link my Google Forms to the corresponding Google Sheet. - Customize the Google Sheet to visually represent its data as a line graph. - Note that the data provided for this task will be multiple choice responses. Ideal Skills: - Proficiency in Google Forms and Google Sheets - Data Visualization expertise - Ability to deliver clear, concise, and intuitive line graphs - Strong understanding of data representation and analysis This project is suited to a freelancer who values precision and has a sound grasp on data visualization. I value timely ...

I have already prepared my Balance sheet, P&L, and Cashflow so that CPA Certified this statement. Ideal Candidate: - Must have a CPA and certified statement.