Macro data spreadsheet jobs
I use software that does not organize information as I need it. I can run a report and download as an excel file. I would like to know if an excel spreadsheet can be created with formulas built in so that I could copy and paste the information from my software report and have it organize it with formulas for sum, average and if/then statments.
...can assist me with three types of tasks: data analysis, spreadsheet design, as well as formatting and styling. The main requirement is to work with live tick-by-tick data, manipulating and assembling it as per my specific conditions on a daily basis. While the data structure tends to be simple in nature, the importance of understanding and implementing my specific conditions is paramount. The freelancer should be able to demonstrate: - A high level of efficiency and accuracy in Excel data analysis - Creativity and resourcefulness in spreadsheet design and formatting - Capability of effectively handling live and frequent data movement - Proficiency in working with simple data structures This role is ideally for someone who thrives...
Note: my budget not more 10$ Functionalities of Chrome extension : 1: scan any web page used web scraping or computer vision to recognize fields or buttons ( if needed) 2: record macro auctions in same time working voice and notes 3: shared the files with others that have same chorme extension
I need unlimited revisions. - need someone who is experienced in creating this type of spreadsheet - I need this to track my consumption accurately and to save time. - I would need zoom meeting upfront to go through my requirements, my docs etc
Note: my budget not more 10$ Funclities of Chrome extension : 1: scan any web page used web scraping or computer vision to recognize fields or buttons ( if needed) 2: record macro auctions in same time working voice and notes 3: shared the files with others that have same chorme extension
The document will profile the business including information on the company background, executive t... 4. The main content is the Projects section. I have started each main project section on a page break. Where there is a sub heading or another project heading not at the top, this means it is a sub project within the main project heading. 5. Title sizes and consistency all askew so needs the right design applied. 6. There may be an Appendices section which we will add later. 7. Spreadsheet table info needs to be tabled and designed nicely. 8. Images will need resizing and a consistent appearance. 9. Here is a DropBox link to assets which are referred to in the word brief document
I need columns h, i, m, and p to be formatted with the date in the American English style. I need to be able to view different merged information on the Dashboard, such as how many types of processes I have, which are in column c, how long they will take to be done, and which people were involved (column s). In other words, I need the Dashboard to be very interactive so I can compose variou...view different merged information on the Dashboard, such as how many types of processes I have, which are in column c, how long they will take to be done, and which people were involved (column s). In other words, I need the Dashboard to be very interactive so I can compose various pieces of information. Therefore, you can proceed with the creation of the Dashboard for this updated attached sp...
Note: my budget not more 10$ Funclities of Chrome extension : 1: scan any web page used web scraping or computer vision to recognize fields or buttons ( if needed) 2: record macro auctions in same time working voice and notes 3: shared the files with others that have same chorme extension
I am looking for professionals in web scraping who can help me collect best-seller products from various e-commerce websites. Websites: I need to search on many websites, Henc...of the website and URL Budget: 25$ for scraping one website (100 products from the defined website), As more websites you can scrap as more budget you can gain Category/Industry: - Data to be search by Months or Categories depend on the website structure itself - I am open to any category and industry for the best-seller products. Data Delivery: - I would like the data to be delivered in an Excel spreadsheet format. Ideal Skills and Experience: - Proficient in web scraping techniques and tools - Knowledgeable in extracting data from e-commerce websites - Experience in deliv...
As the primary stakeholder, I need help with uploading about 50 product records and a few hundred customers my Acumatica ERP system. The data is currently stored in a spreadsheet format, either CSV or Excel. This will be data we will use for testing so there may be other things that also need to be set up like Branches and Tax for example Ideal candidate skills and knowledge: - Prior experience with Acumatica
As the primary stakeholder, I need help with uploading about 50 product records and a few hundred customers my Acumatica ERP system. The data is currently stored in a spreadsheet format, either CSV or Excel. This will be data we will use for testing so there may be other things that also need to be set up like Branches and Tax for example Ideal candidate skills and knowledge: - Prior experience with Acumatica
I'm in need of a professional with advanced knowledge in Microsoft Excel to assist with data analysis, creating and modifying formulas and functions, and implementing macros and automation. I have intermediate knowledge about Excel features but need an expert who can guide and support me on this project. The project revolves around Financial Data, hence an understanding of such data will be necessary. Key responsibilities include: *Layering PnL Data from one excel on top of another excel with yearly PnL as columns. Goal is to employ a simple formula but see the overall result in a user friendly way on excel spreadsheet. All the work is done using Excel VBA A successful candidate should have: * Proficiency in MS Excel including VBA, Piv...
Note: my budget not more 10$ Funclities of Chrome extension : 1: scan any web page used web scraping or computer vision to recognize fields or buttons ( if needed) 2: record macro auctions in same time working voice and notes 3: shared the files with others that have same chorme extension
As the primary stakeholder, I need help with uploading about 50 product records and a few hundred customers my Acumatica ERP system. The data is currently stored in a spreadsheet format, either CSV or Excel. This will be data we will use for testing so there may be other things that also need to be set up like Branches and Tax for example Ideal candidate skills and knowledge: - Prior experience with Acumatica
Title: Pdf to Excel Conversion for Data Organization Description: I am looking for a freelancer who can quickly convert a PDF file into an Excel spreadsheet. The purpose of this conversion is to organize the data in a more manageable and accessible format. Skills and Experience: - Proficiency in converting PDF files to Excel spreadsheets - Attention to detail to ensure accurate data entry and organization - Familiarity with Excel functions and formulas for effective data manipulation - Ability to work efficiently and meet tight deadlines Project Requirements: - Convert the PDF file into an Excel spreadsheet - Ensure accurate data entry and organization - Complete the conversion within 24 hours If you have the necessary skills and can del...
I am looking for a freelancer who can scrape specific data from Semrush for my project. Data to be scraped: - organic and paid traffic, both on a monthly basis, from 4 years ago until today Websites: - I have a list of websites that I want to scrape data from Data delivery: - I would like the scraped data to be delivered in a spreadsheet Ideal skills and experience: - Proficiency in web scraping - Familiarity with Semrush - Strong data organization and analysis skills
Project Description: - I am looking for someone to convert a handwritten PDF into an Excel spreadsheet with 9 columns. - The handwriting is mostly legible and clear, so further evaluation is needed to determine if it can be converted accurately. - Attention to detail and accuracy are crucial in ensuring the conversion is done correctly. - The ability to decipher handwriting is a plus. - The project requires the freelancer to deliver an accurate and complete Excel spreadsheet within the given timeframe. I can provide a sample of the data before you accept the project. The PDF contains 118 pages
I am looking for a freelancer who can help me track my RRSP savings and provide regular updates on its progress. The project requires the following: - Tracking deposits, average rate of return, inflation, and target goal for my RRSP. - Using a spreadsheet to keep track of the information. - Providing monthly updates on the RRSP tracking. Ideal skills and experience for this job include: - Proficiency in spreadsheet software. - Knowledge of financial calculations and tracking. - Attention to detail and accuracy in data entry. - Ability to provide regular updates and communicate effectively. If you have experience in RRSP tracking and are comfortable working with spreadsheets, please submit your proposal.
For this project, I am seeking a methodical, detail-oriented freelancer proficient in manual website data mining / data entry. The task at hand involves: - searching a list of companies/website URLs provided by me (approx 1000) - clicking on the website and finding the official company name (usually at bottom footer) eg. "Joe Smith Pty Ltd" - Find the associated postcode/zipcode via the ABN search using this website - Enter the postcode into a spreadsheet I will provide - This task should take approx. 8 hours as it takes me 30 seconds each company/website (I have timed this) Simple yet precise performance is paramount in this task, and I look forward to working with someone who embraces these characteristics.
...adept at transferring data from a booking sheet to a spreadsheet template. This task requires acute attention to detail and familiarity with basic spreadsheet functions. Your responsibilities will include: - Migration of job details such as date, time, and location into the spreadsheet - Input of client information including name and contact details - Incorporation of service details like type of job and materials needed The spreadsheet you'll be working with has less than 10 columns and fewer than 100 rows. The booking sheet has a simple data structure, composed mainly of text, dates, and numbers. No complex formulas or multiple tabs are involved, so a basic understanding of Excel or Google Sheets should suffice. Ideal applicants shou...
I am looking for a freelancer to create a web scraping tool for me. The main tasks of this project include data scraping, lookup, and entry. Specific Websites to Scrape Data From: () Specific Data Fields to Scrape: - Yes, I have specific data fields that need to be scraped. Format for Delivery: - The scraped data needs to be delivered in an Excel Spreadsheet or Google Sheet. Ideal Skills and Experience: - Web scraping expertise - Proficiency in data entry and spreadsheet automation - Ability to handle additional website scraping - Proficient in Google sheets and Excel.
Note: my budget not more 10$ Funclities of Chrome extension : 1: scan any web page used web scraping or computer vision to recognize fields or buttons ( if needed) 2: record macro auctions in same time working voice and notes 3: shared the files with others that have same chorme extension
Note: my budget not more 10$ Funclities of Chrome extension : 1: scan any web page used web scraping or computer vision to recognize fields or buttons ( if needed) 2: record macro auctions in same time working voice and notes 3: shared the files with others that have same chorme extension
I require a proficient Excel expert to construct a comprehensive spreadsheet for my Home Owners Association (HOA) charge computations. The spreadsheet must be capable of accurately calculating HOA assessments, late fees, and interest. We would need to be able to edit each entry, as the late fees and amounts actually paid fluctuate month-to-month. As a highly skilled freelancer, your prior work experience will be pivotal for this project. Key Features Required: - In-depth HOA fee assessments - Tracking and computation of late fees - Precise interest calculations It is essential that your proposed solution is easy for me to maintain and update as needed after project completion. Ideal Skills: - Proficiency in Excel - Experience creating financial spreadsheets - Exce...
I'm currently searching f...capable of linking multiple spreadsheets and extracting specific columns of data to create a well-structured CSV file. Key tasks include: - Combine data from various Excel spreadsheets - Identify and extract specific, yet undefined, columns from these spreadsheets for CSV file formation As the desired column data are currently unspecified, freelancer must possess excellent communication skills to effectively discuss and identify my data needs. Experience in data extraction, manipulation in Microsoft Excel and CSV file formatting is vital. Knowledge in handling large Excel databases, data sorting and filtering would greatly enhance the project outcome. Therefore, if you're adept in Microsoft Excel and CSV...
...be separated into five milestones: 1. The fetching of the required data which should be done monthly to do the rebalancing. 2. The calculation of all necessary metrices and indicators. 3. As part of the project, we want to do a back test of the strategy to assess the risk and return metrics. 4. An easy export which can be loaded into an Excel spreadsheet to visualize the data. 5. Am option to re-run the model after manual input. For example, exclusion of certain stocks from the list. Requirements - The code must be commented and/or sufficient explanation must be given to understand each step. - The data must be free to access, and the program must load the required data monthly to feed the model. If possible, all data points should be loade...
I am looking for a freelancer to help me organize textual data in an Excel spreadsheet. Hello I have an excel spreadsheet that needs organising into the following column A column b column c column d column e column f column e Title Name surname address 1 address 2 city postcode The data is to be taken from column F onwards I will attach the spreadsheet to be organised and an example of how i want it to be organised. Any problems please let me know.
I am looking for a freelancer to help me organize textual data in an Excel spreadsheet. Hello I have an excel spreadsheet that needs organising into the following column A column b column c column d column e column f column e Title Name surname address 1 address 2 city postcode The data is to be taken from column F onwards I will attach the spreadsheet to be organised and an example of how i want it to be organised. Any problems please let me know.
Spreadsheet so I can enter my cost for my business (overhead), and in turn provide a quote to my customer.
I'm seeking a detail-oriented professional who is proficient in converting PDF content to Excel data. Key tasks include: - Transferring tables from a PDF document to an Excel spreadsheet. - Maintaining the exact structure of the PDF tables in the Excel format. - Keeping a standard Excel layout complete with cell borders. Ideal applicants should have experience handling PDF formats, proficiency in Excel, keen attention to detail, and the ability to accurately duplicate presented structures. Efficiency and accuracy are especially paramount. Therefore, those with a track record of successful similar work will be highly considered. This job also requires a keen eye for detail to ensure the flawless transition of information from one format to another.
...Excel use by automating various tasks. Specifically, this project will focus on automating formulas and calculations, streamlining an otherwise time-consuming process and making my Excel activity more efficient. Mastery in macro programming and a firm understanding of mathematics are desirable to successfully automate tasks in Excel. This process will mainly involve automating operations linked to: - Pick data of rows from multiple data sets and arrange in a prerequisite format In addition to the above, I also require automation for specific functionalities related to data manipulation and transformation as a crucial part of this project. Ideal candidates should possess experience with Excel automation, proficiency in macros programming, and a strong q...
I am looking for an accountant bookkeeper that has sound understandi...figures of previous lodgments from 2017 to 2020 I need to upload business records from previous years from the spreadsheet into Xero: The following financial years have not yet been lodged. 22-23 23-24 These all will need to be reconciled and ready for the submission of BAS. Once complete, Balance Sheet & Profit / Loss statements are to be up to data. Project details: - This is a one-time project, set up so that I can manage myself in the future. Ideal skills and experience: - Expertise in bookkeeping for small businesses - Knowledge of Australian accounting regulations and tax laws - Proficiency in accounting software Xero - Attention to detail and accuracy in financial data entry and rec...
Edit and Fix formula on excel spreadsheet. under " Job Consumable Tracker" the "MTL '' and "part number" do not populate correctly when I choose an item from the " description " drop down menu. sometimes if it does populate, it doesn't match what's on job bom tracker- dashboard under " daily tool - tool check out/in" the drop down menu for " assigned to" that choses a employee's name doesn't work. under " employee tool- tool check out/in " the " item name" drop down menu ends at torch 42. but if you look at " employee tool- dashboard" the list goes on further. so any new item I add will not show up in the drop down menu under employee tool-tool c...
Data analysis - daily fish prices I am looking for a data analyst to perform descriptive analysis on daily fish prices. The analysis will involve examining the data and providing insights on the trends, patterns, and characteristics of the prices. Skills and experience required: - Strong knowledge of descriptive analysis techniques and methodologies - Proficiency in data analysis tools such as Excel, Python, or R - Ability to work with mixed sources of data, including online databases and physical records - Experience in cleaning and organizing data for analysis - Strong attention to detail and ability to spot anomalies or inconsistencies in the data The final analysis report should be presented in a spreadsheet format, with clear ...
I am in need of a policy researcher with a strong focus and understanding of international relations. More specifically, I require an expert who has deep insights about foreign policies related to the Europe region. The required research is a Macro-level overview, not a detailed analysis of specific countries or a thematic focus. Skills and experience required: - A thorough understanding of foreign policies, particularly those pertaining to Europe - Proven experience with Macro-overview policy research - Excellent writing and presentation skills, as the research findings will need to be comprehensible and accessible - Knowledge of international relations is a must - Bonus: prior experience with European foreign policy research This project is suit for EU peoples
I require a skilled coder to execute web scraping on Website 1, specifi...require a skilled coder to execute web scraping on Website 1, specifically extracting products data. The successful candidate will: - Have expertise in web scraping, adhering to website terms and conditions, and able to avoid getting blacklisted - Be efficient in their scraping methods to ensure all relevant product data has been collected with accuracy The resulting data should be: - Comprehensive, including all relevant product data available - Well-structured and readable, with potential for further analytics Lastly, upon completion of the task, the scraped products data should be delivered in Excel Spreadsheet format. Ideal applicants would possess previous experie...
I am looking for a freelancer who can scrape ...beautifully set out with headline information downloadable as an excel spreadsheet... however behind every record is a wealth of information including: First Name Last Name Company City State Zipcode Country Phone Mobile Email I want to scrape all available information about members. The listing is provided on a state by state basis. I want the data from all states as well as the international group. Skills and experience required: - Proficiency in web scraping techniques and tools - Knowledge of data extraction and manipulation - Attention to detail to ensure accurate and complete data collection Please note that the selected freelancer should have access to the necessary tools and resources to efficie...
Data Entry Project: Typing and Organizing Medium Amount of Data into a Spreadsheet Skills and Experience Required: - Proficient typing skills - Attention to detail and accuracy in data entry - Experience with spreadsheet software (e.g. Microsoft Excel, Google Sheets) - Familiarity with organizing and formatting data in spreadsheets Project Details: - I need a freelancer to assist with typing and organizing a medium amount of data into a spreadsheet. - The data will be provided in a specific format and needs to be accurately entered into the spreadsheet. - The freelancer should have strong typing skills and be able to pay attention to detail to ensure accuracy. - Knowledge of spreadsheet software such as Microsof...
...typing skills to assist with a data entry project. The ideal candidate should have a typing speed of less than 40 words per minute and experience in data entry tasks. Skills and experience required: - Proficient typing skills with a speed of less than 40 words per minute - Experience in data entry tasks - Attention to detail and accuracy The project involves completing a data entry task with a quantity of less than 5000 words. The freelancer will be provided with the necessary data and instructions to accurately input the information into a spreadsheet or database. Responsibilities: - Inputting data accurately and efficiently - Ensuring data is organized and formatted correctly - Meeting project deadlines If you have excellen...
As the primary stakeholder, I need help with uploading about 50 product records and a few hundred customers my Acumatica ERP system. The data is currently stored in a spreadsheet format, either CSV or Excel. This will be data we will use for testing so there may be other things that also need to be set up like Branches and Tax for example Ideal candidate skills and knowledge: - Prior experience with Acumatica
I am looking for a skilled Excel VBA programmer or someone experienced with creating Excel macros. The goal of this project is to create a program that will break a single row into multiple ...for a skilled Excel VBA programmer or someone experienced with creating Excel macros. The goal of this project is to create a program that will break a single row into multiple rows in order to organize data. The client has provided a sample Excel file to demonstrate their desired outcome. The new rows created should follow a specific format, as specified by the client. The program should be designed to be used frequently, as the client anticipates needing to use it on a regular basis. Applicants should have a strong understanding of Excel VBA and be able to efficiently organize data...
I require a skilled coder to execute web scraping on Website 1, specifi...require a skilled coder to execute web scraping on Website 1, specifically extracting products data. The successful candidate will: - Have expertise in web scraping, adhering to website terms and conditions, and able to avoid getting blacklisted - Be efficient in their scraping methods to ensure all relevant product data has been collected with accuracy The resulting data should be: - Comprehensive, including all relevant product data available - Well-structured and readable, with potential for further analytics Lastly, upon completion of the task, the scraped products data should be delivered in Excel Spreadsheet format. Ideal applicants would possess previous experie...
I am seeking a proficient data entry freelancer to input text data from digital documents into an Excel spreadsheet. Essential skills and experience include: - An excellent understanding of Excel and its functionalities - Prior experience with data entry from digital documents - Strong attention to detail to ensure the accuracy of the input data - Good time management skills to ensure the project is completed within the set timeframe The main task for this project includes: - Transferring text data from various digital documents to an Excel spreadsheet - Checking the accuracy of all inputted data - Ensuring the layout and formatting of the excel spreadsheet is easy to read and understand - Submitting the final excel spr...
I am looking for a freelancer to assist with a data entry project. The task involves copying the EAN code, SKU, and size from digital images of labels. Label/Image Type: - Digital images will be provided for the project (VERY GOOD QUALITY/ IF the IMAGE IS NOT READIBLE IT CAN BE SKIPPED) Quantity: - There are between 375 labels/images that need to be processed (google drive access) Data Format: - The data should be entered into an Excel spreadsheet / google sheet file Skills and Experience: - Proficiency in data entry. - Attention to detail. - Familiarity with Excel. - Ability to accurately extract information from images. - Efficient and reliable work ethic.
Hello all, Requirements: To create a Microsoft Power Automate (MPA) flow to automate data collection from Instagram posts. I want the MPA flow to go through a list of user saved hashtags saved in an Excel sheet (or notepad etc, wherever it is easier), such as #cars, #carsforsale, etc. The flow should then store in an Excel spreadsheet the following values: Author of Post, Comment Author made (including tags), how many followers the Author has, how many likes the Post has, number of comments, registered country of Author, business or personal account. That is it! I am aware not all posts of the insta hashtag is visible, which is fine, as I will collect data over numerous days, running the flow as needed. I have looked into Insta API graph, if it's easier to p...
...visually compelling spreadsheet that aids in inventory tracking and order management. The key functions I require include: - Data Analysis: This is essential in making informed business decisions regarding inventory control and order fulfillment. - Budget Tracking: Keeping an eye on expenditures associated with inventory and orders will play a crucial role. - Inventory Management: The spreadsheet needs to effectively handle tracking of inventory and order status, allowing for quick updates and effortless retrieval of data. As for the design specifics, I expect a customized design with appealing colors and visuals that make data interpretation effortless. Furthermore, much of the data input and manipulation needs to be automated for ease...
I am looking for a freelancer who can assist me with a data entry project. The project involves copying and pasting data into an Excel spreadsheet. Requirements: - Experience with data entry and proficient in using Microsoft Excel - Attention to detail and accuracy in data entry - Ability to handle a medium volume of data, approximately 100 - 500 entries - Familiarity with Excel spreadsheet format - Excellent time management skills to ensure timely completion of the project If you are skilled in data entry and have experience working with Excel spreadsheets, please reach out to me.
I am looking for a freelancer who can scrape ...beautifully set out with headline information downloadable as an excel spreadsheet... however behind every record is a wealth of information including: First Name Last Name Company City State Zipcode Country Phone Mobile Email I want to scrape all available information about members. The listing is provided on a state by state basis. I want the data from all states as well as the international group. Skills and experience required: - Proficiency in web scraping techniques and tools - Knowledge of data extraction and manipulation - Attention to detail to ensure accurate and complete data collection Please note that the selected freelancer should have access to the necessary tools and resources to efficie...
