Macro data spreadsheet jobs
I'm in need of a freelancer who can skillfully convert two PDF documents into editable XLS files. Here are the key requirements: - All texts and tables from the PDFs should be accurately tra...The final XLS files should maintain the column widths of the original documents to ensure consistency and easier readability. - The end result should be completely editable, allowing changes to be made as necessary. Ideal person for this job would be someone with a track record of converting PDF files to spreadsheets without losing the structure of the original file. Familiarity with Excel spreadsheet formatting is a must. Attention to detail would also be paramount to ensure nothing is lost during the conversion process. Experience with optical character recognition (OCR) tools or soft...
I'm in need of a skilled professional with experience in VBA and writing macros code. While the software used isn't Microsoft Excel or Access, the project involves simple tasks automation. Your role will involve: - Understanding the form and function of currently manual tasks. - Designing, developing, and implementing macros to a...used isn't Microsoft Excel or Access, the project involves simple tasks automation. Your role will involve: - Understanding the form and function of currently manual tasks. - Designing, developing, and implementing macros to automate these tasks. Ideal candidates will have a proven track record with VBA and a solid understanding of how to automate simple tasks efficiently. Experience with custom macro code in non-traditional applications wo...
I require a seasoned Excel wizard to create an intricate spreadsheet for me. My necessity involves handling both text and date/time data. The optimal organization for this data on the sheet would be a mixture of columns and rows. Hence, understanding the context and logic in data placement is key. Additionally, the project would extensively require text and string operations. Ideal candidates should be familiar with various string-related functions such as LEN, RIGHT, LEFT, MID, SUBSTITUTE, and REPT, among others. Your proposal should clearly mention previous similar projects you've undertaken. An understanding of VBA to create customized functions would be a bonus, but is not a compulsory requirement. Parametres Each entry has 2 lessons that must be one...
I am looking for an MS Excel add-in developer who can create functionalities similar to the WiseSheet add-in. The ideal candidate should be able to: - Implement data analysis and visualization features - Execute spreadsheet automation and macros - Integrate with external APIs This project will involve finance modeling and thus require experience in the following areas: - Forecasting and budgeting - Financial ratio analysis - Valuation modeling Additional skills in add-in development, REST API, and advanced Excel are highly desired. I anticipate needing this project completed as soon as possible. Developers with prior experience in finance or with similar projects will be given priority.
I urgently require skilled Excel experts who can design a functional spreadsheet for data entry and organization, and also build an interactive dashboard for reporting and visualization. The data I'll be working with is mainly text and numerical and the spreadsheet will be utilized predominantly on a Windows operating system. Key tasks: - Development of an easy-to-use Excel spreadsheet for data entry and organization - Provision of functionality for text and number manipulation - Construction of an interactive visualization dashboard for reporting Ideal skills and experience: - Proficient in Microsoft Excel - Proficient in data visualization - Familiar with Windows operating systems - Excellent in data analysis and organizat...
I need you to fill in a spreadsheet with data.
I'm in need of a professional proficient in Power Automate to help automate the process of extractin...store them into Excel. The task at hand involves: - Setting up email notifications automation within Power Automate - Streamlining data synchronization between the email server and Excel - Implementing an approval workflow to regulate the data extraction and storage process The specifics on how the email attachments will be integrated into the Excel spreadsheet is open-ended and up to your expert recommendation - it can either be in separate columns or merged into a single column. Ideal candidates for this project would have solid experience in Power Automate with a deep understanding of email servers, data extraction and transfer mechanisms. Expertise...
Hi Kym D., Feb has snuck up on me. Hope you are happy to continue. Topics should be in the previous google spreadsheet. Thanks, Steve
I need someone to copy details from invoices to an excel spreadsheet. I'm seeking an experienced professional for a manual data entry project. This task requires precision and accuracy as it involves transferring alphanumeric data into a spreadsheet format. The ideal candidate should have: - Extensive experience in performing data entry tasks accurately. - A sharp eye for detail to prevent data errors. - Proficiency in using spreadsheet software for data manipulations. - Excellent skills in handling alphanumeric data. Your role will primarily focus on the meticulous transcription of the provided data, maintaining its integrity. Thoroughness and consistency in the work are paramount for this project.
...individual to collect and organize data from specified UK job websites: Indeed, Monster, LinkedIn, Totaljobs, and Reed. This task entails identifying and categorizing current positions in the hospitality industry, specifically restaurants, hotels, and bars. Key responsibilities include: - Accurate data collection for each position which includes: job title, company name, location, job description, specific position details, and the contact email address or phone number. Please be advised that generic email addresses (like info@) are not acceptable. - Immediate start with a focus on the most recently posted jobs. The ideal freelancer for this project should demonstrate excellent attention-to-detail, familiarity with the named job portals, and have experience in data...
I'm seeking a proficient web scraper who can efficiently deliver comprehensive data from Yahoo Finance into an Excel spreadsheet. More specifically, the data to be obtained includes: - Stock prices, - Company financials, - Related news articles. To address this engagement, the key skills required from you are: - Web Scraping, - Data Extraction, - Knowledge of Yahoo Finance data structures, - Competence in Excel. Quick completion time is paramount; I require this project to be finished as soon as possible.
I am looking for an MS Excel add-in developer who can create functionalities similar to the WiseSheet add-in. The ideal candidate should be able to: - Implement data analysis and visualization features - Execute spreadsheet automation and macros - Integrate with external APIs This project will involve finance modeling and thus require experience in the following areas: - Forecasting and budgeting - Financial ratio analysis - Valuation modeling Additional skills in add-in development, REST API, and advanced Excel are highly desired. I anticipate needing this project completed as soon as possible. Developers with prior experience in finance or with similar projects will be given priority.
I need a professional with a solid background in data consolidation including different scales. During this project, you will be tasked with combining results from different tests. Key Objectives: - Combine results from up to 6-10 unique tests into a single, comprehensive report with overarching scores - Final report to be formatted as an Excel spreadsheet - Maintain accuracy and regard for detail when transcribing and analyzing data The ideal freelancer for this project would have: - Proficiency with Excel and data analysis - Keen attention to detail and accuracy This project requires a detail-oriented approach and familiarity with the characteristics measured in the assorted tests. Both these skills will ensure the produced reports are insightful and usefu...
Scraping tool required to pull info from competitor websites, namely Website A, Website B, and Website C. Requirements: - Automatic - Real Time - Options include - Spreadsheet (MVP) - Live System / Database / Platform Skills & experience: - Proficient in web scraping and data extraction - Previous experience with similar projects - Familiar with CSV file formats
I'm seeking an experienced VBA coder for building a macro code in Excel. The primary purpose of the code will be the creation of an Image Paste tool. Significant experience in VBA and familiarity with Excel are both vital attributes. Any previous work involving Image tools using VBA would be advantageous to this project. Scenario is, we have input folder(eg. 1,2,3,4,5,6) for images that folder contains multiple subfolders(eg. For folder name 1 we have subfolders 1-01,1-02,1-03....,for folder name 2 we have 2-01,2-02.... Like that and so on for other folders also), so we have to paste this images in the worksheets which will be created according to folders (e.g. inside the workbook worksheets should be named like "name of input folder-name of subfolder" like 1-1-01, ...
Hi, we are looking for someone that can help us decide what technology we should use to make automation of our laser with Ezcad 2, the job will consist on providing information. The flow will be, from an internal tool we generate an svg file, then we will launch the macro and it has to enter Ezcad, load the svg, position it correctly, select the engraving preset and fire the laser. We tried to use a software to imitate the clicks on certain coordinates but we are looking if there will be something better. there will be 5 macros for 3 pieces to handle all the types of engraving: - Ring silver - Bracelet gold, silver - Bracelet black - Necklace golf, silver - Necklace black Only bid if you have experience with software automation on real productions. Thanks!
I need someone to transcribe notes from an ebook. I have timestamps from an audiobook that I will provide, in addition to purchasing the Audible version of the audiobook and the Kindle version of the book, whic...version of the book, which you will use and get to keep. You will need to have an Amazon account, download the Kindle app, and the Audible app. Utilizing Whispersync on Amazon, you move your audio book to the timestamp and your Kindle version will go to that spot in the ebook, at which point you copy and paste the portion from that timestamp to an excel spreadsheet. This project is for transcribing 600 separate timestamps into an Excel Spreadsheet. I am offering $60 for this work (.10 cents a timestamp). The price is non-negotiable so if this is too low for you p...
I'm seeking a specialist well-versed in Excel 365 to assist me with creating and modifying formulas and functions, as well as improving the overall styling and formatting of my spreadsheets. Wh...formulas and functions, as well as improving the overall styling and formatting of my spreadsheets. While I'm uncertain if interactive dashboards and reporting will be required, an ideal candidate should have the know-how just in case it becomes necessary. This role might require: - Crafting and editing Excel formulas and functions - Enhancing spreadsheet styling and formatting - Knowledge of interactive dashboards and reporting Experience in data analysis is also desirable, though secondary to the main tasks. Applicants should be detail-oriented, organized, and comforta...
I need a data entry specialist who can manage both numerical and text data. Its simple : I have a few spreadsheet templates These I had printed then out and filled in by hand and scanned I needed the hand entries inputted into the templates Its a one-off Required Skills & Experience: - Proficiency in MS Excel or similar spreadsheet software - Experience in data entry from both hard copies and digitized data - Strong attention to detail for data accuracy
I need a spreadsheet with the name, email address, and company name of everyone in the USA with the job title "Director of Talent Acquisition". I want 9,000 contacts minimum. Please inform me how many email addresses you can provide, and provide a sample.
I require a succinct but comprehensive spreadsheet for my trucking company. It needs to present important data on a weekly basis. The following aspects must be included: - Expenses: I need a column where I can indicate my various weekly expenses owner operator. Examples include fuel, tolls, insurance and percentage the company deducts. Company Information: Lastly, please allocate space for driver/owner operator details and company information on the top of the spreadsheet. - Net: I'd like the spreadsheet to automatically calculate the net owner operator makes each week after their expenses. - Load Information: The spreadsheet should have a section where I can input specific details about the loads. This includes load ID, pick up locations, des...
I require an experienced developer with proficiency in LibreOffice and macro creation. This project involves developing a macro that: - Can identify and replace multiple words within selected cells. I need the macro to delete "W's", replace "l" with "-", among others. Details will be discussed further once the project commences. - Capable of not only replacing the text but also reformatting the modified cells. The specifics of this reformatting will be provided. - Can move the changed text to different cells. The ideal freelancer will have prior experience in creating macros, especially for LibreOffice. A deep understanding of the software and adept skill in macro writing is crucial for success in this project. A keen attenti...
I need an Excel wizard to create a custom spreadsheet focusing on basic arithmetic operations. The spreadsheet should be able to perform addition, subtraction, multiplication, and division. The data to be used for these arithmetic operations will all be manually inputted by me. Please note that error-checking feature is not necessary for this project. A candidate with strong Excel skills and a keen attention to detail would be the perfect fit for this task.
We currently use an Excel spreadsheet for an analysis. We would like to incorporate this into our Hubspot CRM. We would like to plug in the paramaters from "Input" tab on the attached spreadsheet. We would then like to the the customer a quote based on the data from "Input" tab. The quote does not need to look like "Pricing" tab, but needs to show something similar.
...am looking for a detail-oriented and experienced data collection professional to gather pertinent sales data for my business. Ideally, you should have a background in market research or a similar field, giving you the skills to provide in-depth, accurate data collection. Key Responsibilities: - Collect detailed sales data, focusing on product sale quantities, revenue data, and customer purchasing behavior. - Provide the data collection results in an organized Excel spreadsheet for easy manipulation and analysis. Ideal Skills and Experience: • Proven experience in data collection, data mining, or similar. • Proficiency in Excel, including advanced formulas and data visualization. • Strong attention to ...
I'm currently in need of an expert in Excel and Numbers. I have three sheets on Numbers that need to b...expert in Excel and Numbers. I have three sheets on Numbers that need to be transferred to Excel, adhering to the exact same layout as given in my example. The task primarily involves adjusting the frames and making small changes. • Skills required: Proficiency in Excel and Apple Numbers • Experience: Previous experience in data transfer between different spreadsheet software will be ideal. Familiarity with adjusting frame sizes in Excel is a must. Please note that no data cleaning or manipulation is required. What's crucial in this job is the need to quickly adapt the current sheets from Numbers to Excel within the specified layout. Delive...
I am looking for a talented developer to create a custom API that connects a third-party API to Google Sheets and performs specific calculations for profit and loss. Your responsibilities will include: - Designing a secure, reliable API integration between the...profit margin. Ideal Skills: - Proficiency in API development and integration - Experience with Google Sheets - Experience with Zapier - Familiarity with financial reporting and basic profit and loss calculations - Strong troubleshooting skills and the ability to solve complex technical problems. The successful freelancer must have experience building custom APIs, preferably with a focus on spreadsheet applications. A strong understanding of financial calculations is a plus, as the API will be used for revenue and cost...
I need a straightforward web application to generate and store dynamic editable QR codes. The code data, comprising short URL reference numbers and assigned telephone numbers, should be downloadable for easy export to an Excel spreadsheet. This spreadsheet will be used to produce stickers, each with a unique code, sent to specific customers. Upon receiving their sticker, customers should be able to edit their phone number by entering the code's reference number and updating their information.
I'm seeking a skilled web scraper to extract data from one simple, static website. This project is intended to aid my self-guided studies of the Sanskrit language, so the information gathered will be utilized strictly for my personal learning. There are about 4000 static pages on that site, 99% of the text being in Sanskrit language (unicode), with very small amount of text in most pages in English. There are 12 fields from each of these pages that I want to extract and kept in a data file in a spreadsheet file. Looking forward to working with a resourceful and educational-minded professional.
...consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Office skills to drive automation opportunities. • Well-versed with dynamic loops, data extraction from images. • Work with users and team members at all levels for performance improvement and suggestions. • Understand and prepare Ad hoc reports. • Identify the opportunities of automating reports, snapshots and dashboards using advanced formulas, Advanced Excel, Python and other techniques • Consolidate, sort, organize and summar...
...an Excel expert who possesses strong skills in Macro programming. I have different excel files organized in different directories with the same data structure. I need to create a main excel that contain all this data in only one sheet with an automation. (This process needs to be done every 15 days, so needs to be automated) What we do now is to enter to each sheet and copy the data into a main excel and its a lot of manual work. Some requeriments: 1) the row on each excel sheet needs to be added to the main file only when the column 2 ("Fecha de ingreso (dd/mm/aaaa)" is not empty, if not the row should be not consider. 2) There should not be empty rows in the "Main excel" 3) The titles should appear only once in the main excel, as the ...
I am working on a Google Sheets spreadsheet where I need to process a column of numeric values with a complex calculation function. This complex function involves multiple steps of calculation and cannot be directly translated into a single Google Sheets formula. Here's the scenario: I have a column of input values (let's say column A). Each input value needs to be individually processed by a series of complex calculations to produce a single output. The complex function uses multiple variables and parameters from different cells within the spreadsheet (for example, the annual growth rate in cell E6). The final result for each input should be placed in an adjacent column (let's say column B). Constraints: I would prefer to avoid using Google Apps Script for ...
I'm experiencing some technical issues with the macros...hampering the overall efficiency of my workflow. Specifically, here are the key areas requiring attention: • Identify the existing issues with macros not functioning properly or delivering inconsistent results. • Rectify and streamline those problematic macros to ascertain seamless financial operations. The ideal freelancer for this task should have a strong understanding of Excel, especially its macro functionality. Previous experience in dealing with financial statements and troubleshooting Excel macros is an added advantage. Critical skills include: • Microsoft Excel proficiency, particularly Macros • Keen eye for detail to spot inconsistencies • Prior financial statement experience •...
I am in need of an expert in managing spreadsheets. The task involves: - Putting together a spreadsheet that can handle both numeric and textual data. - Managing this data requires basic skills such as data entry and sorting. Ideally, you should: - Have experience in data management on spreadsheets - Demonstrate attention to detail - Be proficient in data entry and sorting tasks. This project could potentially be long-term for the right fit. Therefore, reliability and availability are key. Looking forward to your proposals.
As someone dealing with a crucial Excel project, I'm looking for a skilled VBA programmer to rectify two issues. The first one concerns a Macro that's not producing the expected results. Sadly, this malfunction is resulting in incorrect data processing. Secondly, I'm facing some formatting difficulties, needing an expert to resolve them. Both tasks are fairly straightforward, likely taking no more than 30 minutes. Ideal candidates should possess extensive knowledge of VBA and a keen eye for detail to ensure formatting accuracy.
I'm in need of a seasoned Excel specialist who ...seasoned Excel specialist who can assist in creating data-rich spreadsheets from jpeg photos supplied by me. There are 18 sheets to create in total. Specific tasks include: - Decoding and inputting text information from images into excel sheets. Ideal Skills and Experience: - Expertise in Excel, particularly in creating, sorting, and filtering data. - Proficiency in optical character recognition (OCR) or other data extraction methods. - Strong attention to detail and data accuracy. While no automatic sorting or filtering is required for this task, proficiency in these areas will be beneficial for potential future projects. Your prime focus should revolve around transforming image-based text into a clean a...
I'm seeking an experienced researcher to delve into the pharmaceutical industry and identify key co...companies. The primary objective is to collect detailed contact information. Specifically, I'm interested in obtaining the emails of decision-makers within these companies. Ideal capabilities for this task include: - A strong understanding of LinkedIn or similar networking sites to identify decision-makers - Experience conducting online company research - Ability to organize information neatly in a spreadsheet Responsibilities include: - Thoroughly researching pharmaceutical companies - Identifying key decision-makers within those companies - Collecting and organizing their contact details I'm looking forward to a successful collaboration that will help me gain va...
In English - I want to create a spreadsheet that will simulate trades in cryptocurrency history. The rules for buying and selling assets (crypto) and simulate gains, losses and value locks on diverse trade database. I will need to summarize the result. Example rule you will define: 1 - Every 1 hour buy (x)10 dollars of the asset at market price and close with (y)2% gain (stop gain) and place a stop loss (z) 30%, this position can be leveraged at (o ) 3X and with a market closing date, if it is not closed. 2 - At that same time open a short position (z) 10 dollars of the asset at market price and sell with a 2% gain (stop gain) and place an estop loss (b) of 30% this position can be leveraged at (o) 3X with a market closing deadline, if it is not closed. 3 - If the stop loss or stop...
...23 different funds - and I need these located on a municipality outline map provided by the Government. The properties' individual addresses are available in the Excel spreadsheet. However, specific details such as longitude and latitude are not provided. The ideal freelancer for this job will have experience in: - Working with bulk property addresses - Interpreting and working with municipality maps - Converting extensive data into practical, visual information Finally, the output should be delivered in the form of an interactive online map, not just a static image or PDF. This will enable me to interact with the data, understand the distribution of the properties across different municipalities, and identify the municipalities to which they belong. Yo...
Seeking a proficient writer for twice in a week engaging LinkedIn posts revolving around supply chain management, current macro economics, and people management. The ideal collaborator for this endeavor will understand these fields and be able to craft conversational, yet informative posts that work towards: - Building Professional Network: larger my contacts while creating meaningful engagement. - Sharing Industry Insights: creating a thought-leadership platform which showcases my knowledge and perspective of industry trends. - Promoting Personal Brand: establishing a unique voice that represents my professional identity well. Required skills: LinkedIn Content Creation, Content Writing, Knowledge in Supply Chain Management, Macroeconomics and People Management, Social Networking....
I need an expert Microsoft Excel user to set up an advanced Excel spreadsheet for me. It should contain: - Multiple tables organized across various sheets. - Each table should accommodate mixed data, so having a good understanding of handling both numeric and textual data in Excel is crucial. - The spreadsheet will also require complex functions like macros and pivot tables. Therefore, a strong proficiency in these areas is also needed. Ideal candidates should have extensive experience in handling large and complex datasets in Excel and must be able to perform advanced calculations. Knowledge of VBA for creating macros is a strong plus. In your proposal, please include examples of similar Excel projects you've completed.
I'm in need of an expert who can handle my AppSheet data, which includes text, numeric data, and photos, and then accurately fill them in a sheet template. Here's what you'll be working with: -Broadly, the data to work on is of one type - photos. -A good understanding of photo formatting on spreadsheets is essential, as these photos need to be formatted in columns in the spreadsheet. Ideal for this job would be someone with extensive experience in data entry and transformation, specifically with the Appsheet and spreadsheet data formatting. Proficiency in handling photo data and an eye for detail would be an added bonus ensuring accuracy.
I'm in need of a contractor skilled with copy and paste data entry. The task involves transferring a large volume of over 500 entries into an organized and efficient spreadsheet style. - The ideal freelancer should be proficient with Google Sheets or Excel. - You should have experience handling large amounts of data. - High-level organizational skills and attention to detail are crucial. - Accuracy in entering the data will be a priority in evaluating your work. Please only apply if you have a good track record with tasks of similar nature. I'm looking forward to collaborating with you on this project.
I have an ongoing project which requires the adept skills of an exceptional data entry professional. Broadly, the task requires inputting both text and numeric data into an Excel spreadsheet. Key tasks: - Accurate text and numeric data entry - Data validation An ideal candidate should have: - Proven experience in efficient and precise data entry - Strong knowledge of Excel - Demonstratable abilities in data validation - Attention to detail and accuracy Please only bid if you meet these requirements and can efficiently manage this project. Experience and references are a big plus. Someone with intense focus on data quality is what I'm after. Let's turn this data into meaningful information.
As a project owner, I am seeking a freelancer experienced in working with Wordpress to insert text (from spreadsheet) and images into my website's pages. This task requires two specific responsibilities: - Inserting text into both the page body and title. Ideal candidates would be attentive to detail, ensuring correct insertion in mentioned areas for consistent webpage appearance. - Skillfully implementing images that best correspond with the content. I'm aiming for a seamless, integral presentation hence the need to have images inline with the text. Visual design expertise for ensuring an aesthetically pleasing inline layout is necessary. This project demands a strong background in Wordpress editing functionalities and solid aesthetic acumen for effective content pr...
I'm seeking a proficient professional to design a functional spreadsheet that caters to the requirements of a wholesale foods business. The key functionalities needed include: - Inventory Management: Track our food items meticulously to avoid wastage and ensure optimum stock levels. - Sales Tracking: Monitor sales and discern patterns that would help in making more informed business decisions. - Purchase Orders: Manage incoming and outgoing orders comprehensively. Aside from the functionalities above, I also require the spreadsheet to track and email customer buying habits. This should be done by generating a customer list and allowing for weekly buying additions. Consequently, we would capture important buyers' information which includes: - Customer Name - Con...
