Macro data spreadsheetdela
I need an assistive hand in a data extraction task that requires sharp focus and meticulous attention to detail. The task involves: - Extracting email addresses from an Excel spreadsheet - Maintaining accuracy and precision during the data entry process, ensuring no data is missed or inaccurately entered Proficiency in Microsoft Excel is a must for this task. Previous experience in data extraction or data entry is highly desirable. You should be adept at handling large volumes of data, have a keen eye for detail, and are able to keep track of your progress systematically. Let me know your capacity per day/week as this can be an ongoing project. Please dont negotiate on the price beyond the Bid provided
We are looking for an individual to collect data and place into a spreadsheet. You will need to extract information from two mobile apps and place them into an excel spreadshet for the purpose of market analysis. You will need to create a list of locations shown on each app within a specific geographical location. This list must include: app, name, address, location type, borough.
I am looking for a data entry expert to input data into an Excel spreadsheet. I have a specific template that I would like the data to be formatted in. The data set is small, with less than 1000 entries. Ideal Skills and Experience: - Proficiency in data entry, specifically in Excel - Attention to detail to ensure accurate data entry - Familiarity with using templates for data entry - Ability to work efficiently and meet deadlines
This project aims to build an informative and precise contact list for our business use. We will provide you with a list of 1000 records, and your job will be to Google each one and fill the respective information - Website, Address, City, State, Zip, Phone - into a shared Google Spreadsheet. The focus of this data collection will be on the specific records we supply. Ideal skills and experience for the job: - Strong web research skills - Prior experience in data entry - Attention to detail and accuracy - Proficiency in Google Sheets - Ability to meet deadlines.
...on the CEO, senior management, and email addresses. The data should be compiled into a spreadsheet, such as Excel or Google Sheets, with separate columns for each piece of information. Key Responsibilities: - Researching and collecting information on the CEO, senior management, and email addresses of around 80 councils. - Ensuring the accuracy and relevancy of the data collected. - Organizing the data neatly into a spreadsheet, in a format suitable for subsequent upload to a CRM tool like Pipedrive. Ideal Skills and Experience: - Experience in data research and entry. - Proficiency in using Excel or Google Sheets. - Familiarity with CRM tools, particularly Pipedrive, is a plus. - Attention to detail and the ability to maintain data accu...
I'm in need of a skilled typist for a data entry project. The task involves entering data into an Excel spreadsheet. Requirements: - Excellent typing speed and accuracy. - Previous experience with data entry. - Proficiency in Excel. - Ability to follow instructions precisely. Ideal Candidate: - Proven track record in data entry tasks. - Strong attention to detail. - Reliable and able to meet deadlines. - Good communication skills. If you have the right skills and experience for the job, I look forward to receiving your bid.
I'm on the lookout for a teaching position in a Primary School, be it as a teacher or a teaching assistant. I require an urgent recruitment, within the shortest possible time. Address: ...Tong Rd, LS12 5HE, England. The school must be a Primary School The school must have a vacancy available online. The job role must be a Teacher or Teaching Assistant. The school must be within 1 hour drive. Please check Primary School websites for job vacancies and add into a spreadsheet with: Primary School name - Area/Town - Job Role - Year Group - Advert Posted Date (if stated) - Start Date Anyone who can help me with this job search may be able to get regular work until I find a job. Must use a spreadsheet. Thanks Must have the name of the specific school (no generalized ...
The project entails accurate entry of numerical data into an MS Excel spreadsheet, with a focus on report generation. The ideal freelancer should be well-versed with basic Excel functionalities, such as simulations and formulas, to ensure efficient data processing. Key responsibilities would include: - Accurate and efficient numerical data entry - Setting up Excel to run basic simulations and formulas - Generating effective and accurate reports from entered data The freelancer should have strong attention to detail to maintain data accuracy and proficiency in MS Excel, specifically in creating basic simulations and formulas. Previous experience in data entry and report generation is highly preferred.
Hi Akriti, As promised, here is the new spreadsheet for the Jan-Mar 2024 pivot tables at the $30 you suggested. Could you double check there's no data in the hidden rows ... somehow we couldn't unhide them :-) thanks, Omer
I will provide four sheets containing monthly AWS expenses, along with an output report for the last month. I need someone to update them for April. This involves updating the month, dollar amounts, percentages, and budget numbers. Ensure that the budget corresponds to April (specified in the budget tab), all percentages are accurate, and the line chart reflects the current month's expenses.
...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. 1. 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: In the Spreadsheet App Sscript: In "Rahul's Code". 2. Add a line of code to
I require a professional with a keen understanding of both Excel and iOS Numbers to convert a single-sheet Excel spreadsheet into an iOS Numbers document. The converted document will need to retain multiple functionalities including: - Basic calculations - Data visualization - Conditional formatting No data interdependency or connectivity with other aspects is required in this case. The ideal candidate should have significant experience with data conversion between these two platforms and a solid grasp of maintaining functionalities in iOS Numbers. Familiarity with creating visually engaging spreadsheets will be highly regarded. I would like to have conversation with someone to make sure I am asking for something reasonable and to clarify exactly whats neede...
I am looking for a proficient specialist who can modify my IRR (Internal Rate of Return) spreadsheet aimed at financial analysis. The main requirement is unspecified modifications, suggesting that I need a freelancer who can intuitively understand how to improve the spreadsheet based on its current state and purpose. The IRR spreadsheet is used mainly for analyzing financial data, with a specific focus on calculating the Internal Rate of Return. Ideal Skills Required: - Expertise in financial analysis, particularly in calculating the Internal Rate of Return - Strong understanding of Excel spreadsheets, their functionalities, formatting, and calculation adjustments - Ability to assess existing tools and intuitively suggest and implement improvements. Please d...
I need an expert in Excel spreadsheet and dashboard creation to help me with a project related to the management of properties. The project involves the following tasks: - Data analysis - Formulas and calculations - Data visualization The data to be used in this project will mainly revolve around a situation room containing property under management status and updates. Specifically, the dashboard should track and monitor the following key metrics: - Rent collection and payout status - Tenant and business complaints - Contacts details - Contracts status - Property profits - Property location - Owner notes - Comments If possible to have it as geolocation kml as a copy I'm looking for someone with strong experience in creating dashboards and spreadsh...
...by way of an MS Excel spreadsheet which will have columns that include the author (to be supplied); the verbatim quotation (or its English translation); the source of the information; and the name/date of the translation if the original quotation is not in English, plus any other pertinent information. Engagement Terms After an initial trial, we anticipate the ongoing engagement terms will be based on an hourly rate - as we understand some of the identified authors will prove more or less easy to obtain the required quotes/references. We are seeking an ongoing engagement with a suitable party which has the potential to expand past the initial task. Initial Trial Our starting point will be to provide a defined list of authors, along with the Excel spreadsheet temp...
I'm looking for a freelancer to copy type a printed document into a spreadsheet. Key Requirements: - The source material is printed, not handwritten. - The final document should be a spreadsheet, not a plain text file or a formatted Word document. - Basic formulas need to be applied to the spreadsheet. Ideal Skills and Experience: - Proficient in copy typing. - Experience in data entry and spreadsheet management. - Familiarity with basic formulas in spreadsheet software.
I'm looking for a skilled freelancer who can help me organize and manage my data in a spreadsheet. The data will consist of text, numbers, and dates. Key Requirements: - Experience in data entry and management - Proven track record of successful data handling - Proficiency in spreadsheet software (Excel, Google Sheets, etc.) Your application should include past work you've done in similar projects. I'm looking for someone who is detail-oriented and can assure the accuracy and structure of the data.
I'm in need of a skilled professional who can diligently carry out a large volume of data entry involving text, numbers, and images. The data is to be accurately entered into an Excel spreadsheet. Ideal Skills: - Proficiency in Excel - Accuracy in data entry - Ability to handle large volumes of data - Familiarity with processing text, numeric, and image data The right freelancer should have substantial experience handling this type of project and able to demonstrate precision and attention to detail.
As an investor, I require a CFA-qualified professional to assist with complex bond pricing tasks. Specifically, my investment portfolio focuses on municipal bond...pricing tasks. Specifically, my investment portfolio focuses on municipal bonds and I am keen on better understanding their quantitative pricing. Key tasks will include: - provide spreadsheet with all cash flows and formula - extrapolate discount rate using forward sofr and muni curve - The perfect candidate will have a strong background in quantitative investment analysis, a solid understanding of bond markets, and proven experience in pricing municipal bonds. In-depth knowledge and practical application of quantitative pricing models will also be highly advantageous. In the end, I just want excel spreadsheet d...
...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 Forint Currency Do the conversion from Euro as shown in the renew breakdow...
I require a competent freelancer with experience in creating management systems to develop an automated spreadsheet for my insurance business. It will encompass the management of multiple insurance policy types including, but not limited to life, health, motor, travel and term insurances. Key Requirements: - Accurate tracking of policy details: This will span essential areas such as policyholder's name, policy start & end dates, insurance company details, premium amounts, policy type and number, beneficiary information, registration number, contact numbers, email IDs, premium collected, next expiry and other insurance related parameters. - A fully functional dashboard: Capabilities include report generation, tracking of premium payments, calculation of policy expiry date...
I need a meticulous researcher to compile data from LinkedIn and Google, resulting in a thorough Google Doc. This task involves gathering the following specifics: Contact details, Company information, and Job titles. It also includes the LinkedIn Profile URLs of the relevant associates. The final document should contain around 100 to 500 entries. Ideal candidates possess conversance with LinkedIn's platform, effective Google search strategies, and proficiency in Google Docs. Excellent organization skills are also expected. Your meticulousness will help in ensuring that accurate, updated data are reported. Let your attention to detail shine through and exceed expectations in this task. I will give you a URL that contains approximately 50 records that have Organization...
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.
...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 the chosen freelancer, and they must be able to seamlessly integrate these additional features into it. Ideal skills for this job include: - Advanced proficiency in Excel - Experience in developing automated systems within E...
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 addresses is crucial. - Time management: Ability...
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 am trusting that this tool will e...
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 (produc
Please look at the spreadsheet and ensure the new coins are added
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.
I need a proficient Excel specialist to develop a spreadsheet that will calculate gross pay based on clock in and clock out times. Some work-shifts will start on one calendar day and not clock out until the next calendar day (example- clock in May 1 at 3:30pm - clock out May 2 at 12:30am). It should also factor in specific overtime rules for the workplace, including: - Weekly overtime after 40 hours. -All hours on any given workday shall be paid at the straight time rate of pay unless forty (40) hours have already been worked at straight time. No matter the length of route: example- a driver's bid/scheduled route may be 10.8 hours, as long as the employee does not work any additional hours other than those bid/scheduled, they will be compensated at straight time rate of pay unl...
I am in need of a detail-oriented individual to help with a data entry project. This involves manually entering alphabets into an Excel spreadsheet to create a comprehensive database. For this task, you should have: - Excellent attention to detail, as the entered alphabets should be strictly in lowercase. - Proficiency in Excel, as the data will be used to compile an Excel spreadsheet database. - Ability to work diligently on a potentially repetitive task. Your primary responsibility will be to manually input the alphabets into the spreadsheet with absolute accuracy. As it's vital that each data entry is correct, having strong attention to detail is paramount for this job. Experience in data entry and Excel is a must.
As my project deals intricately with WordPerfect, I'm in search of an experienced freelancer who knows the ins and outs of this software. - **Expertise Required**: In-depth knowledge of WordPerfect is a must. Your task will include document formatting, template designing, and macro automation. - **Application Criteria**: Please include proof of your expertise in WordPerfect in your application, such as a detailed description of a project you have worked on or a list of tasks performed using WordPerfect. Show me why you're the best candidate for this task! - **Note**: This project strictly requires WordPerfect skills only. Additional software expertise is not necessary for this particular project. Your exclusive proficiency in WordPerfect will be vital for the highest ...
...specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and a strong understanding of Excel...
I'm in need of a Python script that can efficiently take addresses from an excel spreadsheet and search google maps locate solar panels on roof tops Ideal Skills and Experience: - Proficiency in Python programming - Experience with image processing and analysis - Familiarity with satellite image utilization - Understanding of data output and manipulation in Excel Key Features: - The script should focus on residential rooftops specifically, using satellite images to identify solar panels. - It should be able to iteratively search through said images, pinpointing and marking the locations of solar panels. - The final output should be an Excel spreadsheet containing the results of the search, detailing the coordinates of the identified solar panels. Please, o...
I am interested in creating an Excel VBA macro that will allow me to import PDF invoices into line items and parse them. The objective of this project is to streamline the process of invoice data entry by automating the extraction of key information from incoming PDF invoices, namely Invoice number, Vendor name, Pricelist, and Detail. The successful freelancer for this project should have: - Demonstrated experience in creating VBA macros for Excel - A strong understanding of PDF parsing and data importation - Knowledge of accounting principles is a plus The imported data should ideally be formatted in Excel as: - Each PDF invoice should be translated into a single row - The extracted information should be available in separate columns for each piece of informa...
I want all funeral directorss email addresses scraped from All send on a spreadsheet with Names, phone number, city and email address Price for all contacts from the site PLEASE PROVIDE PRICE TO COMPLETE THE JOB. DO NOT MESSAGE FOR A CHAT DO NOT BID A PRICE THEN ASK FOR A HIGHER PRICE Feedback will be left according to quality of work.
I'm in need of an experienced data entry specialist who is proficient with Excel and has a good attention to detail. The project is small scale, requiring less than 100 entries of numeric and text data to be input accurately. Requirements: - Skilled in data entry - Experience with Excel - Attention to detail - Efficient work pace The ideal candidate would have ample time to complete the project quickly. Make sure the entered data has to have no errors and is accurate since the output will be used for further analysis. Final format: Data should be delivered in an organized Excel spreadsheet.
PLEASE DON'T BID IF YOU CANNOT WRITE EXCEL MACRO TO SCRAPE THE DATA. PYTHON SCRAPPER DON'T NEED I'm in need of a VBA developer who can help in creating a small code for scraping contact details from a specific website. The task involves creating a button in an Excel file that triggers the scraping process and saves the extracted data back into the same Excel file. Note : Project budget is only 6k because it will take max 2-3 hour for experience developer Key Requirements: - Scrape contact details from - Specifically, scrape Owner Name & Address - Implement a function where a user clicking a button triggers the scraping process - Save the extracted data back into the same Excel file Ideal Skills & Experience: - Proficient in VBA prog...
I need a pretty simple Excel spreadsheet. It is for a used car dealership. I need a row to imput the vehicle, one for the purchase price of the vehicle, one for the cost to prepare the vehicle for sale, one for the sale price, and one for the profit or loss on the sale. I would like it setup with tabs at the bottom for months and years
I'm in need of a skilled freelancer with proficient online research and data entry skills. Responsibilities: - Conduct online research to collect necessary data - Expertise in entering numerical data precisely - Compile, verify accuracy and organize the information into a Excel spreadsheet Desired skills/experience: - Attention to detail - Experience in data entry - Excellent knowledge of MS Excel - Strong ability in online researching
I need help with data entry into spreadsheets. Key Responsibilities: - Efficiently and accurately transfer data into spreadsheet format Ideal Skills: - Proficient in spreadsheet software - Experience with data entry The project involves basic data entry tasks. The data is mainly in digital format. Your primary responsibility will be to ensure all data is accurately entered into the spreadsheet.
I require an expert in Excel to build a comprehensive tracking file. This task involves: - Establishing a data entry form to easily input inventory and project progress details. Knowledge of creating user-friendly interfaces within Excel is beneficial. - Implementing automated calculations to streamline the data analysis process. Strong mathematical and analytical skills are essential. - Creating a graphical representation of data to facilitate understanding. Experience in data visualization is a must. The spreadsheet will track fewer than 10 types of inventory data and project progress data. Your familiarity with inventory management processes and project tracking would be highly valuable. This assignment calls for you to use Excel'...
I am seeking a proficient specialist in Excel 2010, with extensive experience in the creation of VBA Macros, designing data entry sheets, automating tasks, and generating reports. Key responsibilities include: - Design and develop efficient VBA Macros - Design accessible and streamlined data entry sheets - Automate various Excel tasks for increased productivity - Generate comprehensive and insightful reports Ideally, you have advanced knowledge of Excel and VBA Macro programming, demonstrating a proven track record in dealing with complex Excel projects. A strong understanding of spreadsheet automation and report generation is fundamental to execute this project successfully.
I have two PDF files that contain about 150 records each that I need entered into a single spreadsheet. I do not require any specific categorization, but rather a direct, one-to-one transfer of the information from the PDFs into the spreadsheet. The data fields needed are names, addresses, emails phone number etc Ideal Skills: - Proficiency in data entry - Experience with working on PDFs - Attention to detail - Familiarity with spreadsheet software (such as Excel)
I'm looking for an experienced data miner or online researcher who can compile a comprehensive contact list consisting of both industrial business owners and industrial property owners in the Charlotte market. The data points that you need to scrape are the following: For Business/tenant contacts: * Property address * Property city * Property size (square footage) * Business/tenant name * Business owner/executive contact name * Business owner/executive contact phone number * Business owner/executive contact email address * Business website (if any) For Property owners: * Property address * Property city * Property size (square footage) * Owner business name (unless individual owner) * Owner name * Owner phone number * Owner email address * Owner website (if any) T...
I'm in need of a freelancer who can assist me with the styling and formatting of an Excel spreadsheet. Your task will primarily involve applying cell style formatting. Specifically, I'm requiring assistance with: - Implementing cell style formatting. Please note that while the exact type of cell styles are not defined yet, I will be able to provide more details and guidance once the project begins. Ideal skills for this job would include: - Proficiency in Microsoft Excel - Previous experience with complex Excel formatting - Ability to work independently and on deadline Please, in your bid, include examples of any similar jobs you've completed.
I am seeking a detail-oriented freelancer to input text and numerical data into 3 small Excel spreadsheets, containing 1 column each. 2 spreadsheets for emails, one called Minnesota, one called Midwest. 1 spreadsheet of inventory numbers. See attached. Only emails are needed. Inventory is on yellow paper Ideal Skills: - Proficient in Excel - Attention to detail - Knowledge of data organization and management Highlight the entries that you are not sure of, or the handwriting is to difficult to read. English fluency in a must.
I am in need of an automated solution for a task I currently undertake on a daily basis. The task involves merging sales data from two spreadsheets to create one consolidated spreadsheet. This crucial operation currently takes me about an hour every day, and I am seeking assistance to build an efficient process, ideally through a script, that can handle this for me. The end result will be a daily spreadsheet detailing which locations are owed orders. Ideal Skills and Experience: - Proficiency in Excel and creating Excel scripts - Knowledge of sales data and data merging - Ability to automate manual tasks - Attention to detail with data accuracy.
...script writer to extract specific business data from an online directory, specifically Myagedcare.gov.au. This project will need a freelancer that possesses: • Significant knowledge and experience in data scraping technology • An understanding of the structure and functioning of online directories • Keen attention to detail The successful freelancer will carry out: 1. Extraction of business data: I require accurate extraction of contact details and business names from businesses listed on the directory. 2. Specific Directory Focus: The targeted directory for this exercise is Myagedcare.gov.au. The end goal is to create a clean and organized database of businesses in the aged care sector. Prior experience with online directories and specificall...
