Macro data spreadsheetprojekty

I'm seeking a freelancer with outstanding Excel skills to compile a comprehensive list for personal contacts. The required data for each contact includes: - Name - Address - Phone number It's essential to meticulously organize and enter the required data into the spreadsheet. Precise attention to detail is crucial to ensure no errors are made when adding the details. While there isn't a specific order for the data I will provide you with, I expect clear and uncluttered presentation will be kept as a consistent standard. The ideal freelancer should have: - Proven experience with data entry - Keen attention to detail - Excellent organizational skills - Proficient Skills in Microsoft Excel. If this sounds like you, I encourage you ...

I'm looking for a skilled freelancer who can help in entering text data from PDF files and images. There are 60 rows of text, I need to add columns that contain the details from PDF files. This needs to be done now immediately. I will provide an example.

...require a solution to fetch real-time stock prices from the National Stock Exchange (NSE). The fetched data should populate in an Excel spreadsheet and refresh every second. Key Responsibilities: - Scrutinize the dedicated NSE platform to fetch live stock prices - Develop a method to automate data update in Excel every second Mandatory Skills: - Proficiency in Excel, with particular emphasis on data extraction and automation - Knowledge and experience of the NSE online system - Familiarity with automatic data retrieval and real-time updating This project must maintain a high standard of accuracy, as any mistakes could lead to misinformed financial decisions. Hence, meticulousness in data management and understanding of stock market trading...

I have a spreadsheet of ~2100 gas stations in the state of New York. The data includes a station ID, last known brand, and street address. For each address, I need you to find the most recent but not past November 2023 (month and year shown in the corner, most should have images in 2023 available) Google Streetview images and save a screenshot of the price advertising sign for each of the specified locations. The screenshot should be such that the sign and text can be clearly read (e.g. prices and "cash"/"credit"). The spreadsheet of locations and an example screenshot is attached to this post. For each screenshot, the filename should be the station id of that station from the spreadsheet. In the spreadsheet, I need you to also log so...

...create a detailed spreadsheet for my personal income and expenses for 2023. The dataset should include: income source, expense type, description, amount, and the date of each transaction. Key Tasks: - Suggest categories for income sources and expense types based on my lifestyle and spending patterns. - Ensure precise documentation of each financial transaction. - Offer insights on spending trends and potential savings. Ideal Skills & Experience: - Proven experience in personal finance management or accounting. - Proficiency in Excel or other spreadsheet software. - Strong analytical skills, and attention to detail. - Experience in creating custom income and expense categories. - Financial advisory experience is a bonus, but not a must. This endeavor is not just abo...

I am seeking an experienced freelancer who can facilitate the bulk transfer of my entire Grocery category listings from Amazon to Walmart. Necessary skills and experience would include: - Extensive knowledge of both Amazon and Walmart's platforms - Familiarity with ...that all listings in the grocery category are meticulously carried over. This includes product details, descriptions, prices, and images. Please note, proficiency in bulk product listing and understanding of grocery items is necessary for this task. Accuracy and speed are of the essence. If you have a proven track record in this area, please bid. I will supply you with the appropriate Amazon spreadsheet. I will need the Walmart listings in the form of an Excel file that I can upload into Walmart. This is for r...

...create a dynamic visualization dashboard for health data. - The dashboard will focus on a range of health data - It will need to display specific and diverse health metrics such as age, type of therapy given, time periods, and mortality - so be able to calculate mortality, time periods, - Each individual's health record data will be detailed in a specific manner ie data will be entered as numeric code -Each patient will have about 20 data points Ideally graphs will have consistent coloring eg PD patients orange, HD = green etc- to allow for intuitive understanding The ideal freelancer for this project needs to have: - Proficiency in Excel, especially in creating dynamic and interactive dashboards. - Experience working with health data...

We have 5 spreadsheets we need some information from. 4 are the same format and need to be combined, then added to a template. The other also needs to be added to the template. The 4 and the 1 all have an identifier number and a cost. After inputting into the template we need the costs to be compared between the 4 inputs spreadsheets and the 1. When they have different costs we need to know the difference. The final sheet on the template will be a filtered list of all the identifier numbers that have different costs, and what the costs are. We need the template to be simple to use so that all we have to do is add the information from the 5 spreadsheets. A strong understanding of lookups, filters, and building organized/usable spreadsheets is a must. I will provide the 5 input sp...

I have a set of printed documents that need to be converted into an excel file. The data primarily consists of text, and the excel sheet has 1-5 columns. Key Responsibilities: - Inputting data from printed documents accurately and efficiently into the excel sheet - Ensuring that the text data is correctly organized within the specified columns Ideal Skills and Experience: - Proficiency in typing and data entry - Experience with Excel or other spreadsheet software - Attention to detail and accuracy to prevent errors - Ability to handle and convert printed documents to digital format Your work will be essential in transforming this printed data into a digital, easily accessible and analyzable format.

I'm looking to organize reference images into spreadsheets. The spreadsheet should contain details specific to each image: primarily the image's name. These images must be saved in PNG format. Skills and Experience: - Expert knowledge in spreadsheet management. - Attention to detail for accurately naming images. - Proficiency in handling PNG image format.

...addresses from funeral directors, crematoriums and celebrants in the UK. The list should be organized according to geographic regions, focusing specifically on England. Key Deliverables: - An Excel spreadsheet with the collected email addresses - Inclusion of names of key contacts in these establishments with their own individual email address Ideal Skills and Experience: - Proficiency in conducting web research to gather contact information - Familiarity with the funeral services industry in the UK is a plus - Excellent attention to detail for accurate data collection - Experience in data entry and organization - Ability to deliver the project efficiently and on time Please note that providing only email addresses is not sufficient; the names of key contacts i...

I need a skilled freelancer to copy and paste data from several websites into an Excel spreadsheet. Key Requirements: - Proficiency in data entry - Detail-oriented and precise - Familiarity with using spreadsheets Please deliver the data in the spreadsheet format. Let's discuss the specifics and get started on this project.

I need an advanced Excel spreadsheet created, compatible to both Windows and Mac. It will be used primarily for team collaboration, and should have the following key features: - Real-Time Editing: The ability for multiple team members to edit the sheet simultaneously, reflecting changes in real-time. - Task Highlighting: An in-built mechanism for highlighting overdue tasks, enabling focused teamwork and timely task completion. - Report Creation: A feature that allows the easy conversion of the sheet into plain text. The report should maintain much of the original formatting for clarity. - Task List: An organized task list creation feature, enabling team members to assign and keep track of tasks efficiently. The spreadsheet should also be editable as part of a shared workshe...

I'm looking for a diligent data entry professional to assist with transferring text from various online sources into a structured spreadsheet format. Key Points: - The task involves pure text entry, requiring accuracy and attention to detail. - The data will be sourced from online content, so familiarity with the web and online research is preferred. - The final output should be a well-organized and error-free spreadsheet, most likely on platforms like Excel or Google Sheets. Ideal Candidates: - Proficient in data entry with a keen eye for detail. - Comfortable navigating online sources and extracting information. - Skilled in using spreadsheet software like Excel or Google Sheets. - Able to complete the task accurately and within the stipu...

I am looking for a data entry freelancer to transcribe handwritten notes into a spreadsheet. Key Responsibilities: - Accurately transcribe handwritten text into a spreadsheet format - Organize and format the data in a clear and structured manner Skills and Experience: - Proficient in data entry, especially from handwritten sources - Experience with spreadsheet software like Excel or Google Sheets - Attention to detail is crucial to ensure the accuracy of the transcription - Ability to work efficiently and deliver quality results within the agreed timeline. Please note that the data will be provided in handwritten notes, and must be transcribed into a spreadsheet.

I'm on the lookout for a detail-oriented freelancer to peruse through 1026 spec...entries in Companies House website here in the UK (). The main task is to: - Input the provided company number - Access their most recent accounts - Record the number of employees each company had last year. The ideal candidate will have: - Excellent attention to detail - Strong data entry abilities - Proficiency in using Spreadsheets Finally, I'd like the mapped data to be presented in the spreadsheet provided, the employee count should go next to the company number. Please note that industry sector or other details are not required. Simply focus on obtaining the employee count for each company. Your efficiency and accuracy will be much appreciated.

I am looking for skilled programmers who have the expertise in converting Excel VBA macro codes into a cloud-based solution that can be run on MS Azure. Key Requirements: - Conversion of Excel VBA macro focusing on data analysis - Development of a scalable and secure MS Azure-based solution Ideal Skills and Experience: - Proficient in Excel VBA and cloud technologies - Experience in migrating Excel VBA macros to cloud-based platforms, especially MS Azure - Strong understanding of data analysis and cloud security - Proven track record in developing scalable cloud solutions

I have a small limited company and need help to do a end of year account to submit by June to HMRC. I have data in a spreadsheet. I can comply beforehand to faciitate the task I need to draft accounts mainly, calculate corporate tax to pay and submit. thanks

I need a freelancer with strong Excel skills for text data entry. The job requires accuracy and attention to detail, as it involves straightforward input in an Excel Spreadsheet. There's no need for specific formatting, making it an ideal gig for those with experience in simple data entry tasks.

...sector specifically, but also customers that need customized printing services. The work involves research and gathering critical data to create an excel spreadsheet containing the following: - Company Name - Contact Person - Contact Phone Number - Email Address - Company Website A demonstrated history of research skills, data mining, and lead-generation experience would be an ideal fit for the task at hand. Familiarity with the technology, healthcare, and finance sectors, as well as understanding the needs of companies requiring customized printing services, would be advantageous. I am seeking a detail-oriented professional who can ensure accurate and on point data collection and entry. Your work will play an essential role in the development and expansi...

...Logical functions (IF, AND, OR) and Arithmetic operations (SUM, AVERAGE, MIN, MAX) - Conducting Data analysis using Pivot tables and creating various scenarios in the Scenario Manager - Ability to work with multiple worksheets - Organising the spreadsheet using Grouping & Outlines and employing advanced Excel functions - The project also involves the creation and handling of intricate elements such as Worksheet Linking/Workbook features, the usage of Header and Footer and providing a touch of Creativity & Originality Structure-wise, the project involves a commission spreadsheet as the first, a forecast worksheet as the second, and a loan spreadsheet as the third. Accuracy in calculations and spreadsheet formatting is mandatory. The ability to p...

I'm looking for an individual who can proficiently collect and fill in a spreadsheet with specific sales and customer data for my business. Specifically, you will need to: - There are exactly 100 records to update - Capture 2 customer names of decision makers - Find customer contact information (email) and ensure it's accuracy - Collect the customer company data (address, website, etc) The collected data must be presented in separate rows in the spreadsheet we provide. We already have much of the data, you're just filling it in. You should bring experience in data collection and management, and comfort working with spreadsheets. Attention to detail and accuracy are paramount for this project.

I’m in need of someone experienced with Excel and product management to help me compile an organized sheet for auto parts dropshipping. Your task is to ensure accurate information on product descriptions and supplier details. Key Aspects: - Populate Excel spreadsheet with relevant fields: Product description and Supplier information. - Must be proficient in Excel and have prior experience in a similar role, proof of such experience is necessary. - Deliver the final product in Excel format (.xls or .xlsx) Knowledge in the auto parts industry will be a significant plus.

I need assistance with a very specific task: transposing customer list data from an existing Excel spreadsheet into a business plan. The format should arrange the data in a column arrangement within the business plan document. Specific elements required from the customer list include: - Telephone number - Email - Personal information Ideal candidates for this project should have experience with: - Excel spreadsheets - Business plan designing - Data transfer and organization Let me know if you need any further information to complete this task.

I am in need of a proficient professional to assist me in completing a spreadsheet and business plan for my project. Being located in New York, in-person collaboration is essential for this task. Key Responsibilities: - Data Entry: Assisting with populating my spreadsheet with pertinent data. - Business Plan Development: Adding relevant content into my business plan template. Ideal skills & Experience: - Proficient in Excel or similar spreadsheet programs. - Knowledge in business plan development and structuring. - Strong communication skills and an eye for detail are crucial. - Previous experience with similar tasks is highly preferred. - Being based in New York is a must. Benefit from the opportunity of comprehensive collaboration and the poten...

...categories pertinent to camping – Sleeping gear, Cooking equipment, First aid supplies, Tools, Maintenance, Necessities, Vehicles and Pets. Throughout the project, I'll require utmost flexibility, impeccable attention to detail and an innate sense of style, ideally from a graphic designer experienced in Google Sheets and Infographics. Your creative flair will truly come into play in making this spreadsheet engaging and easy to use. Your job will include, but not be limited to: - Designing an intuitive Camping Checklist template - Heading/Category design - The use of visual elements to differentiate categories. - Easy to follow instruction page I have a basic concept already created in google sheets that I can share with you to help you get started Experience in s...

...scraping and data organization to extract detailed information about Funko Pop collectibles valued at $150 or more from PopPriceGuide.com. The project aims to create an Excel document listing these collectibles, focusing on item names and detailed data for each variant, including chase versions and their sub-variants. Scope of Work 1. Data Extraction: • Target the Funko Pop section on for data collection. • Extract data for Funko Pop collectibles with an estimated value of $150 or more. Required data points include: • Item name • Estimated value • Details for each variant (e.g., colors, themes) • Information on chase versions and any sub-variants • Ensure the accuracy of the extracted data...

I'm searching for a professional with advanced Excel skills to modify my spreadsheet. The tasks include: 1. Quartering: Split my dataset into four sections (Q1, Q2, Q3, and Q4). 2. Data Removal: Erase specific rows or columns as per provided instructions. The ideal person for the job is quick, efficient, and meticulous, with a keen eye for detail. The ability to understand and work efficiently with large datasets is a must. Proficiency in Excel is expected and prior experience with similar projects would be highly advantageous. DETAILED DESCRIPTION OF JOB: On the attached spreadsheet: Remove all of the accounts that are exempt from work comp (column R shows who is exempt) Remove all columns except for Business name, address, city, state zip. Then I want it br...

I am in need of assistance with business planning, focusing primarily on data organization and sorting, specifically operational data. I am open to working remotely. Skills and Experience: * Proficiency with spreadsheets, particularly organizing and sorting large volumes of data. * Strong understanding and experience regarding business plan format and structure. * Previous experience working with operational data. Tasks: * Organize and sort operational data within prepared spreadsheets. * Adequately format and adjust business plan for improved clarity. * Establish remote work sessions for collaboration on tasks.

...can interlink and manage spreadsheet files for my machining process. Here's what the tool needs to be able to do: 1. **Document Linking**: The primary function of this software should be to connect various spreadsheet files relevant to the machining process. 2. **Control Plans & SOPs**: The software should allow us to create and manage control plans and Standard Operating Procedures (SOPs). 3. **Data Management**: It should handle spreadsheet files with embedded charts and calculation formulas, and needs to be capable of maintaining this functionality while linking documents. 4. **Runchart Plotting**: The software should be able to generate runcharts automatically using input data. Ideal applicants for this task would have prior experie...

I'm in need of a talented individual who is intimately familiar with Hubspot and Stripe for CRM integration. Your main task will be to coalesce these two systems to streamline my payment processing and manage customer subscriptions. - The main target is to import our current excel spreadsheet correctly into Hubspot (about 20 columns) with each field correctly displayed. (see attached sample). - To have each stripe payment correctly updating the right client, so we know if one is late on his subscription payment or not. Here's what I'm looking for: - Proficiency in both Hubspot and Stripe platforms - Proven expertise in CRM integration - Ability to optimize processes for ease and efficiency Your expertise in this field will directly enhance my team's workflo...

I'm seeking a detail-oriented freelancer to enter text data from PDF format into a spreadsheet. Your tasks would include: - Extracting and entering text data from PDF documents with high accuracy - Ensuring all entered data is correctly formatted and categorised according to my requirements Ideal skills and experience for the job: - Prior data entry experience, particularly with PDF to spreadsheet conversions - High attention to detail - Familiarity with spreadsheet software such as MS Excel or Google Sheets - Proficiency in English, as the text data to be entered is in this language. Feel free to reach out with any questions or clarifications desired.

I want someone who can create a VBA macro to merge specified excel workbooks from different excel files in one click. More details: What specific tasks do you need the VBA Excel program to perform? Automate data entry What types of data will the VBA program need to handle while automating the data entry? Text data, Numeric data How will the VBA program receive the data that needs to be entered? Files

Need to do data entry from chatgpt I to excel spreadsheet. Need basic math and English skills

I am seeking a proficient HTML/Js coder with substantial experience in ZOHO Creator. The scope of the project requires the creation of an advanced Gantt chart with the following functionalities: - Drag and drop tasks: Make tasks movable, enhancing usability and adaptability. - Zoom in/out feature: An essential functionality to swiftly and seamlessly navigate between micro and macro views of the project timeline. - Task dependencies: Tasks should be linkable, illustrating the sequential or dependent nature of tasks. The Gantt chart should display task duration in 'Days'. Therefore, candidates with grasp of fine-tuned date and time handling in Js are preferred. Moreover, the chart should provide additional task details which include: - Assignment of tasks to specific t...

I need to have text data entered into a Google Sheets spreadsheet. You'll be dealing with a simple list format, so past experience with Google Sheets would be ideal. Efficiency, accuracy, and attention to detail are the keys here. Feel free to bid if you are proficient in data entry, especially with text data.

With this project, I'm specifically looking for a detail-oriented and meticulous individual experienced in online data entry, ideally in an Excel environment. The selected freelancer will be responsible for: - Performing online data entry tasks. - Entering all data into an Excel spreadsheet. - Sorting and organizing the data in alphabetical order. It's crucial you have experience with Excel and an understanding of data structuring. Error-free work is a must, as well as a keen eye for details, to ensure the data's integrity. I'm counting on your expertise to deliver accurate and reliable results.

...efficient formula - Testing the formula rigorously on provided data - Ensuring accuracy and prompt delivery Please only apply if you are highly skilled in Excel and comfortable working with large datasets. Your work should be accurate, precise, and timely. Shaun is a Sales Director, Food Services Division at a major Food & Beverages Manufacturer. He has just been promoted into his role for top notch sales performance as well his keen analytic aptitude. True to his nature, he’s constantly on the lookout for newer sources of data to drive business (other than the sales data that comes from internal systems). In a review with his team, he landed on what he thought was right in this space (see attached a sample of this). The spreadsheet has 3 tabs, ...

I am searching for an Excel expert who can assist me with a moderate volume of data entries (100-1000). Tasks include: - Data Entry: You will input and organize both numerical and text data. Accuracy and attention to detail are crucial since the data will be mixed. - Data Organization: Categories and hierarchies within the spreadsheet need to be established for efficient use, so a strong understanding of Excel's organizational tools is essential. Ideal candidates will have extensive experience with Excel and data entry, particularly with mixed data types. Knowledge in creating effective organizational systems within spreadsheets will also be appreciated.

...tasks: • Data research: You will need to research and find the best prospects for my business based on their profile, industry, location, and other criteria. You will need to use sales navigator and other tools to conduct effective data research. • Profile research: You will need to analyze and evaluate the profiles of the prospects you find and determine their level of interest, need, and fit for my business. You will need to use sales navigator and other tools to conduct thorough profile research. • Data filtering: You will need to filter and sort the data you collect based on the most relevant and important criteria. You will need to use sales navigator and other tools to perform accurate data filtering. • Data col...

...require a quick and precise assist in compiling sales leads data from the New York Suppliers Day Exhibitor List. Your tasks will involve: - Extracting names and contact details of exhibitors. - Organizing the acquired details into a spreadsheet in an ordered and readable format. The list can be found here: Note: *ONLY 'RAW MATERIALS' EXHIBITORS REQUIRED* The first one is already done for you here: Given the urgency, applicants should have: - Proven data entry abilities, with strong attention to details. - Proficiency in Excel or similar spreadsheet tools. - Able to deliver as quickly as possible. Candidates

I am on the hunt for someone highly skilled using excel. The selected freelancer will process data from a CSV file, apply exact match criteria, then enter these matched results into another CSV file. It's vital for this task that duplicate entries from the CSV files are kept intact - they must not be removed or merged. Prior experience in data matching and a strong understanding of CSV files is highly desirable. Please ensure you can: - Handle large CSV files - Apply exact match criteria - Combine values of a column to replicate a formula - 16 columns of data combining to output a pre determined formula - match the formula across entries on another spreadsheet - 800 rows Let's maximize data accuracy and efficiency together. output formula s...

I’m in need of a versatile spreadsheet to facilitate daily production planning. Key functionality required includes: - Generation of production schedules: Analyses should be drawn from sales forecasts and lead times to ensure accurate and effective scheduling. - Calculation of production capacity: Incorporated into the design should be the ability to comprehend and calculate our production capacity. For optimal results, a freelancer with experience in production planning, proficiency in Excel and deep understanding of sales forecasting and lead time analysis will be highly regarded. Updates are required to be managed daily, thus the freelancer should ideally construct this spreadsheet with ease of use in mind for consistent daily inputting. A clear and user-friendly...

As a plant enthusiast working on a significant project, it's crucial for me to have in-depth data about various plant characteristics. The plant data is currently housed in an Excel spreadsheet that requires thorough analysis and extraction. Specifically, I need these categories to be methodically analyzed and extracted: - Growth conditions - Size and growth pattern - Species-specific properties For this project, freelancers with considerable experience in data analysis, particularly with plant-related information, would be a strong fit. Key skills needed include Excel data extraction and an understanding of plant characteristics and botany. Knowledge concerning species-specific properties and growth conditions would be an additional advantage. Any...

We need to create an Excel Spreadsheet to track Cash income and expenses. We will begin with a specified amount of cash. First priority is to be able to know at any given time how much cash should be in the petty cash account. Would like to have a space for a weekly balance in order to identify losses or un recorded income/expense in a timely manner. At the end of each week, the keeper of the account will enter the actual amount of cash on hand. This should be subtracted from the recorded expenses and income and a + or - sum generated. (This allows us to catch and correct possible typo's and/or unrecorded income/expense in a timely manner) We want it to generate monthly totals to include Total Cash income Total Cash expenses. The cash expenses should be subdivided...

...highly-skilled data scraper to enrich a comprehensive contact database for SaaS ERP & CRM firms based in The United States. This database is specifically focused on obtaining valuable details from decision-makers in these companies. Key requirements include: - Extracting company decision-maker contact information, specifically from individuals holding the roles of Chief Executive Officer (CEO) and Chief Marketing Officer (CMO). - Contact details should include email addresses, verified mobile phone numbers, and LinkedIn profiles. Ideal applicants will have previous experience in data scraping, familiarity with SaaS companies and the structure of their leadership, as well as strong attention to detail. Efficiency and accuracy are paramount. You will be provided wit...

...development and prompt engineering. Expertise in conversational AI and natural language processing (NLP). Analytical ability to solve human-computer interaction problems. Specific skill in configuring the prompt to send links effectively. Excellent communication and documentation skills. Additional Information: The chatbot operates with prompts in XML standard. We use the ChatGPT-4 language model. A spreadsheet with relevant links will be provided as part of the project. The chatbot's training database is formatted in Q&A. The platform used to develop the AI is Dify. How to Apply: Send your portfolio, highlighting previous projects related to chatbots or conversational AI. Include a description of how you would address the specific needs of this project to improve our ...

Need to do data entry from chatgpt I to excel spreadsheet. Need basic math and English skills

I am looking for a proficient Excel VBA developer to create a macro that can automate sending payslips to employees on a monthly basis. Key Requirements: - The VBA code should be able to extract the pay information from an Excel spreadsheet and generate a PDF file with the payslip. - The generated PDF file should then be attached to an email that is sent to the corresponding employee. Ideal Skills: - Proficiency in Excel VBA, including the ability to work with PDF files - Experience with automating email sending processes - Strong communication skills to ensure the solution meets our needs. Please note that this project is specifically for creating the VBA code for the payslip emailing system - the design and content of the payslips themselves are already established. ...

I require competent services for data transcription. This project involves the transcription of data from a total of 265 JPEG images into an excel spreadsheet. Example Jpeg attached. The Details: - The JPEG images contain a combination of both text and numbers. - An integral part of this project is that the data from each image should be transcribed into a separate tab on the Excel spreadsheet. Key Qualities: - Proficiency in data transcription from images (JPEG) is essential. - Advanced skill level in Excel data management. - A keen eye for detail to ensure text and numbers are accurately transcribed. Thus, if you possess a high attention to detail and proven proficiency in this kind of work, I invite you to make your bid.