Macro data spreadsheetprojekty
Proszę, Zarejestruj się lub Zaloguj, żeby zobaczyć szczegóły.
...dashboard that will serve as a real-time financial data visualization tool. Here's what I need: - Real-time data representation: The dashboard should update instantaneously with the latest financial statistics. - Advanced customization: Incorporation of advanced custom filters to sift through data specifics is crucial. - Visual appeal and clarity: The design must be both aesthetically pleasing and easy to interpret. IDEAL SKILLS: - Proficient in Excel and VBA - Strong in data visualization and financial analysis - Experience with real-time data systems EXPERIENCE REQUIRED: - Previous work on dynamic Excel dashboards - Solid understanding of financial metrics - Portfolio showing data visualization prowess This dashboard isn't just...
Proszę, Zarejestruj się lub Zaloguj, żeby zobaczyć szczegóły.
Hi there, You need to visit the website and collect contact details etc from the website. Fixed budget INR 50 for 265 Rows data. Please only bid if you are comfortable with the rate and ready to start now and finish the task within a few hours. Thank you.
...de la app: (Descargar y probar MyFitnessPal ya que es la app de referencia) Version 1 (MVP) Landing page Panel administrativo: * Registro de recetas * Conexión a USDA para tener listado de ingrediente con su valor nutricional. * Publicación de e-books para su venta App móvil Perfil del usuario (Home): 1. Buscador (recetas e ingredientes) 2. Video introductorio 3. Visualización de calorías 4. Macro nutrientes estándar (proteína, grasa, carbohidratos). 5. Cantidad de comida del día Resetas: 1. Simplecook (Lista de recetas de la app - Suministrada por la clienta) | Guardar en favorito 2. Propias: Personalizar receta (uso personal) Menú del usuario (Mi menú): Crea o genera menús personalizables y selecc...
I urgently need expert assistance to correct my Microsoft Excel formulas. My spreadsheet is integral to my work, and I'm encountering issues that are affecting my workflow. - **Problems Encountered:** - Encountering errors with INDEX and VLOOKUP functions. - Receiving incorrect lookup values. - Dealing with incorrect range or table references that are causing calculation mistakes. - **Project Requirements:** - Quickly identify and resolve the #VALUE! and #DIV/0! errors. - Adjust or rewrite the problematic formulas to produce accurate calculation results. - **Ideal Freelancer:** - In-depth experience with advanced Excel functions, especially INDEX and VLOOKUP. - Strong problem-solving skills with a keen attention to detail. - Capacity to deliver quick turnarou...
...operator, competent in entering physical products to my store. For physical products, each listing should include: - A comprehensive product description - Relevant product images - Selection of the correct collection - Brand data and other necessary information With respect to the physical products, each listing requires: - Detailed product description - Product images - Brand information The ideal freelancer for this project should have notable experience with Shopify and product data entry. Also it would be good if the freelancer knows how to upload an excel spreadsheet to Shopify which will make this a lot easier. IF someone can do this that has done it before and make it quick I would pay more for that kind of talent. Accuracy and attention to detail in fi...
I'm in need of a professional data entry specialist. - The main task for this project is entering textual data collected from various online resources. - The captured data will need to be accurately organized into predefined fields within spreadsheet software, specifically Microsoft Excel. - It will require excellent data capture capabilities, alongside strong time management skills to guarantee a swift turnaround of the task. - Proficiency in online research and the use of Excel for data entry is crucial. If you're an experienced data entry professional familiar with Excel, I'd be happy to consider your proposal.
I'm looking...skilled freelancer to create a VBA macro that efficiently create a z-scores matrix of spread daily changes. The data comes from a sql query and are organised in dynamic arrays (horizontal and vertical). Macro needs to find the correct length of array, calculate every possibile combination between 2 columns, compute daily changes, populate a matrix of daily changes zscore for the period and formatting the results by using graded color scale as backgroud. Outputs the results into a new Excel workbook. Ideal candidate will have: - Strong proficiency in VBA and Excel - Experience with statistical functions - Knowledge of error handling in macros - Ability to deliver clean, commented code Looking forward to finding the right expert to help streamli...
Hi there, You need to visit the website and collect contact details etc from the website. Fixed budget INR 50- 250 Rows data. Please only bid if you are comfortable with the rate and ready to start now and finish the task within a few hours. Thank you.
I need to programmatically rename a Google sheet using a Google App script. The non-functioning code is: // Step 5: Rename the copied Verkflo (DOESNT WORK!!!) ...Rename the copied Verkflo (DOESNT WORK!!!) var CurrentName = (); var newName = (().getRange("G8").getValue()); (newName); Replace it with a working script. The script must rename the Google sheet using the client's name to be pulled from Cell G8 of the Spreadsheet, joined by its original filename including its date. For example: The spreadsheet is called Verkflo 3-2-2024 (the date 3-2-2024 is the sheets version) Re-name it using the content of Cell G8 of the Sheet - "Joe Bloggs - Writ - 3 February 2024 - 3-2-2024" Thats it!
I'm in need of a highly skilled excel macro handler capable of handling complex formulas and data. This role involves creating a program where we will upload excel files consistently formatted in their structure. This program must be designed to extract data from entire sheets and apply predetermined complex formulas to this data. It will then need to generate an output file with the results. If you're an expert with excel macros and have a solid understanding of working with complex data, this project is for you. Ideal skills would include: - Expert knowledge of Excel macros - Knowledge of complex formulas - Strong understanding and experience with data extraction from Excel files. - Experience in generating output files from input d...
...Excel macro developer to automate my business's workflow and order monitoring system. My aim is to streamline efficiency and maintain comprehensive oversight by implementing a dynamic tracking solution. - Key Requirements: - Develop macros for workflow management. - Create a system to manage order status updates. - Automate report generation and formatting. - Desired Workflow Features: - Task assignment automation. - Approval processes integration. - Document tracking and notifications. - Essential Order Tracking Elements: - Capture and display order numbers. - Record and track order dates. - Reflect current status (e.g., in progress, completed). - Incorporate customer names as a reference. - Ideal Candidate: - Proficient in advanced Excel feature...
...scanned documents into organized Excel spreadsheets. Here's what I need: - **Task**: Convert scanned data into Excel format efficiently. - **Key Skills**: - Proficiency in data entry and conversion. - Expertise in Excel and handling scanned documents. - Keen attention to detail for high accuracy. - **Requirements**: - Ensure the integrity of the original data during conversion. - Organize information logically within the spreadsheet. - Delivered files should be ready for analysis and reporting. - **Experience**: - Previous work converting scans to Excel. - Strong understanding of data structure. The ideal candidate will demonstrate a track record of successful data conversion projects and the ability to del...
I am seeking a diligent freelancer with a strong data entry skill for the transferal of numeric data from digital documents into an Excel spreadsheet. Requirements: - Expertise in Excel - Excellent attention to detail, ensuring the accuracy of inputted data - Experience with numeric data entry - Efficiency in working with digital documents The ideal freelancer should demonstrate a proven track record in numeric data entry with the highest level of accuracy and quick delivery. Proficiency in handling and interpreting digital documents is also essential.
I'm looking for a professional to help with a small-scale spreadsheet entry job. I have fewer than 100 data points that need to be entered accurately and efficiently. Responsibilities: - Enter data into the spreadsheet - Format and sort the data to ensure easy readability Ideal Experience: - Expertise in Excel or similar spreadsheet software - Proven track record with data entry jobs - High attention to detail, ensuring that the data is entered correctly and sorted properly
I'm searching for an Excel virtuoso who can craft a macro to streamline my reporting workflow. I have heaps of raw data and need the macro to transform this into well-organized tables in a report format. Here's what's essential: - Develop a user-friendly macro to format raw data. - Create easy-to-read tables for the final report. - Incorporate prompts for manual review if data deviates from the expected format. Ideal Candidate: - Expert in Excel VBA and macro creation. - Strong grasp of data presentation in Excel. - Detail-oriented with a knack for identifying data inconsistencies. - Problem-solving mindset with the ability to create intuitive prompts for manual data review. - Great communication skills ...
I'm seeking an Excel data entry expert to transfer information from scanned documents into a clear, organized Excel spreadsheet. Here is what I'm looking for: - Transfer of simple text entries from scans to Excel. - Exceptional attention to detail. - Proficiency in Microsoft Excel. - Ability to interpret and accurately input data from scanned images. - Efficiency and reliability with data entry tasks. - Previous experience with similar projects preferred. The successful applicant will ensure the data is correctly and precisely entered, allowing me to easily utilize the information for my project needs. If you have a quick turnaround time and a proven track record of meticulous data entry work, I invite you to bid on this project.
I require a highly-skilled VBA macro developer to write a custom script for PowerPoint 2016. My primary need is for this macro to reference slide numbers within a text-box. To elaborate: - The macro needs to automatically update the referenced slide number whenever slides are added or deleted. - It should function seamlessly within PowerPoint 2016 Windows & Mac An ideal freelancer for this project would be proficient in Microsoft Office Suite, particularly PowerPoint, and have extensive knowledge and experience in programming VBA macros. This expertise will be critical in ensuring the macro functions as intended, improving the efficiency and accuracy of my PowerPoint presentation flow.
I'm seeking a proficient accountant, adept in bookkeeping, particularly in recording assets and liability transactions. The ideal freelancer will have: - Extensive experience with spreadsheet-based bookkeeping systems. - Proficiency in correctly recording asset and liability transactions. - Attention to detail and accuracy in recording financial information. - Knowledge of financial statement preparation and tax filing processes will be a plus, even though it’s not the main focus of this project. You should be able to work independently, handling bookkeeping tasks with minimal supervision, and sticking to schedules diligently. If you believe you are the right fit for this task, I'd be excited to connect.
...environment. - Enhancement of layout consistency across the pages to create a uniform user experience. - Adherence to best practices in UX/UI design, ensuring that the final design is user-friendly and aesthetically pleasing. Ideal Skills and Experience: - Proficiency in front-end development (HTML, CSS, JavaScript) - Experience with UI frameworks that mimic spreadsheets (e.g., Handsontable, x-spreadsheet) - Strong portfolio in web design with examples of interactive and interface design - Knowledge of Excel functionalities and an ability to translate them onto the web - Keen eye for layout consistency and detail-oriented design approach Please include your experience in your application, especially any past work that demonstrates your ability to create Excel-like functionalit...
I'm in urgent need of precise data entry services to update an existing Excel spreadsheet. The project needs to be completed within a week, and it entails gathering LinkedIn job titles and profile URLs based on specific geographic locations. Here's what I'm looking for in a freelancer: - Efficient in data mining and web research - Advanced skills in Excel management - Proven experience with LinkedIn data extraction - Excellent attention to detail - Ability to deliver work within a strict deadline The freelancer will be expected to: - Locate LinkedIn profiles by geographic location - Capture relevant job titles - Record corresponding profile URLs - Ensure the accuracy of all entries - Update the spreadsheet without disrupting existing ...
...create a custom macro focused on data automation. My main objective is to automatically generate performance metrics reports. This task would require proficient Excel skills, specifically with macros, with a strong understanding of VBA. This Excel macro will significantly streamline report generation, so timeliness and reliability are paramount. I will be using this macro with very large files. If you possess the right skills and experience, I'd be thrilled to discuss this project with you further. Take a look at this existing macro: There will be an initial Excel file similar to the file in the example above....but very large. I need 2 macros: One macro that adds a sheet
Hi Milan S., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
I need a proficient freelancer to create a dynamic Excel catalog for my sales and marketing activities. Here are the essentials of the project: **Project Requirements:** - Develop an Excel spreadsheet. - Use the provided spec sheet with over 10000+ variables. - Generate all possible combination without restrictions. **Ideal Skills:** - Expert use of Excel and formulae. - Strong understanding of combinatorial mathematics. - Experience in producing sales/marketing resources. - Ability to deliver a clean, user-friendly spreadsheet. **Objective:** The final Excel catalog will enhance our sales and marketing efforts by providing a comprehensive view of potential product variations. **Deliverables:** - An Excel file with all combinations neatly organized. - Ensure the catal...
I'm seeking an expert to create an Excel spreadsheet tailored for my needs. KEY FUNCTIONALITIES: - Execute basic math operations. - Handle complex financial calculations. WHAT I'M LOOKING FOR: - Proven experience with Excel. - Portfolio showcasing similar projects. - Understanding of financial computations. NO INTEGRATION: - Standalone spreadsheet, no external links necessary. Ideal candidates will demonstrate how their previous work aligns with my project's requirements. Anticipate immediate engagement with the right freelancer who can deliver efficiency and accuracy.
I'm searching for an Excel virtuoso who can craft a macro to streamline my reporting workflow. I have heaps of raw data and need the macro to transform this into well-organized tables in a report format. Here's what's essential: - Develop a user-friendly macro to format raw data. - Create easy-to-read tables for the final report. - Incorporate prompts for manual review if data deviates from the expected format. Ideal Candidate: - Expert in Excel VBA and macro creation. - Strong grasp of data presentation in Excel. - Detail-oriented with a knack for identifying data inconsistencies. - Problem-solving mindset with the ability to create intuitive prompts for manual data review. - Great communication skills ...
I'm seeking an expert to develop a macro that efficiently extracts specific data from government websites. Initially, the macro will target Florida and California for public records related to businesses. Key Requirements: - Extract filed business records, including company name and address, EIN, and years in operation. - Save data in a structured format, suitable for PDF creation via Adobe Acrobat. - Ensure accuracy and reliability of the scraped data. - Design the macro with scalability in mind for potential future expansion to other states. Ideal Skills: - Proficiency in data scraping techniques and tools. - Experience with macro creation, especially for PDFs in Adobe Acrobat. - Strong understanding of handling public record...
I am seeking a skilled data collector who can compile an extensive list of funeral home businesses in an Excel spreadsheet that are using for their online shop. An example will be: The indicated data elements should include (in your sample screen shot, I need to see all columns to make sure it is being done correctly): - Business name - Contact details (email and phone number) - Website URL - URL Please let me know: 1. How many funeral home businesses you will provide, if you are not going to do all? 2. How long it will take to deliver Excel spreadsheet? As this job requires fast but accurate turn-around, the freelancer must complete it within one week. Furthermore, please make note that this
I'm seeking a proficient UiPath engineer experienced in automating large volume data entry operations. Unique tasks encompass: - Data Extraction from Databases and Excel spreadsheets - Data Validation - Data Integration. The project's scope will involve handling and processing over 1000 records across different tasks and the primary data sources will be Databases and Excel spreadsheets. The ideal candidate should possess: - a deep understanding of UiPath on-premises solution - prior experience in handling data extraction, validation, and integration on a significant scale - proficiency in working with Database and excel spreadsheet data sources. Create excel interactive dashboard Your role will be pivotal for the proje...
More details: What specific data would you like to track in the spreadsheet? Client information,Fee agreements,Compliance status,Revenue ,Dynamic dashboard that summaries How would you like the spreadsheet to display the revenue information? Yearly revenue What functionality do you want the dynamic dashboard to have? Interactive charts,Real-time data updates,Customizable views,Reviews due per month
I'm in urgent need of a detail-oriented freelancer with expertise in data entry, specifically in managing and entering text data. The task involves: - Entering text data into a spreadsheet - Organising the data alphabetically Proficiency in Excel and a strong attention to detail are the ideal skills for this project. Previous experience in data entry projects is a plus.
I'm in need of a highly skilled excel macro handler capable of handling complex formulas and data. This role involves creating a program where we will upload excel files consistently formatted in their structure. This program must be designed to extract data from entire sheets and apply predetermined complex formulas to this data. It will then need to generate an output file with the results. If you're an expert with excel macros and have a solid understanding of working with complex data, this project is for you. Ideal skills would include: - Expert knowledge of Excel macros - Knowledge of complex formulas - Strong understanding and experience with data extraction from Excel files. - Experience in generating output files from input d...
I'm seeking an expert to create a Windows-compatible marketing tool that simplifies my Facebook Marketplace campaigns. **Core...Facebook Marketplace. - Sponsored Ad Filtering: Separate sponsored ads from the mix. - Boosted Ad Filtering: Identify boosted posts with precision. **User Interface:** The interface requirement was not specified, leaving room for the developer's creative approach. A proposal for a spreadsheet format, dashboard, or raw data management system is welcomed. **Skillset Needed:** - Proficiency in Facebook API and Marketplace. - Experience in developing Windows applications. - Strong background in ad filtering algorithms. - Data management and presentation skills. I await a freelancer who is confident in delivering a robust tool that...
...accurately and diligently handle the development of a macro that streamlines my data analysis process. Project Overview: This project is to help automate the compiling of two separate spreadsheets into one and adding minor formatting and analysis to the combined audit spreadsheet. We do this step for 7 different locations, thus in total there are 14 near identical spreadsheets which are combined into 7 final output files. This includes: - Consolidating two Excel spreadsheets into one composite document. Mastery of Excel is mandatory for this task. - Handling comparative data analysis on the combined spreadsheet. Past experience with analyzing data trends and making comparisons is crucial. - Further enhancing the readability of this final ...
I'm in need of a meticulous and dedicated freelancer to assist in entering data from digital documents into an Excel spreadsheet. Job roles and responsibility: - Conversion of digital documents data into Excel - Maintain accuracy of information Ideal skills and experience required: - Extensive experience in data entry - Proficient in Microsoft Excel - Excellent attention to detail - High degree of accuracy and consistency Applicants should provide a detailed project proposal outlining their ability to accomplish this task in a successful and timely manner. Looking forward to receiving your impressive proposals.
...accurately and diligently handle the development of a macro that streamlines my data analysis process. Project Overview: This project is to help automate the compiling of two separate spreadsheets into one and adding minor formatting and analysis to the combined audit spreadsheet. We do this step for 7 different locations, thus in total there are 14 near identical spreadsheets which are combined into 7 final output files. This includes: - Consolidating two Excel spreadsheets into one composite document. Mastery of Excel is mandatory for this task. - Handling comparative data analysis on the combined spreadsheet. Past experience with analyzing data trends and making comparisons is crucial. - Further enhancing the readability of this final ...
I require a proficient data entry specialist to transfer numeric data from a collection of scanned documents into Excel spreadsheet. - KEY TASK: Conversion of numeric data from scanned documents to a spreadsheet. Essential skills and experience: - Precise data entry skills - Prior experience in handling numeric data - Experience working with scanned materials - Proficiency in Excel Your main task will be to accurately input numeric data, ensure it's properly formatted, with extra care in avoiding mistakes. Please note that the resulting spreadsheet must adhere to my specified structure.
I'm looking for a skilled Power BI expert to help visualize critical financial metrics. Key Requirements: - Develop a dynamic financial dashboard in Power BI - Integrate data to display Revenue, Expenses, and Profit - Create a detailed monthly breakdown for in-depth analysis - Ensure accurate linkage of provided Excel spreadsheet data sources Ideal Candidate: - Proficient in Power BI and data visualization - Familiar with financial reporting and analysis - Experience with Excel and data integration - Attention to detail and accuracy Your expertise will enable better financial decisions driven by insightful data visualizations. I'm excited to work with a professional who can deliver a user-friendly and informative financial dashboard.
I need a professional who is adept at Excel data analysis and visualization, spreadsheet formatting, and pivot tables and charts for an urgent task. The job involves creating a PowerPoint presentation with the analyzed data within 24 hours. The PowerPoint presentation should have a moderate level of complexity, including charts and graphs to illustrate the data findings. This project requires strong skills in Excel, data analysis, PowerPoint presentations, and a quick turnaround. If you're an expert in these areas, please apply.
...specialist to develop an Excel macro that expedites and streamlines my data utilization needs. OVERVIEW: This project is to help automate the compiling of two separate spreadsheet types into one and adding minor formatting and analysis to the combined spreadsheet. This analysis is done to determine which locations > days > or cashiers are having the most sales adjustments. High sales adjustments like voided transactions, line cancellations, or discounts indicate that a cashier may be making errors or possibly stealing. This report is used by management to investigate said locations, days, or cashiers which are causing the high adjustments. The macro must be able to perform the following tasks: - Carry out calculations and formula automation. ...
I am looking for a well-organized, meticulous freelancer who has expertise in English language data entry. You will be required to: - Convert text data mainly in English into a structured format - Enter this data accurately into an Excel spreadsheet Ideal skills and experience for the job include: - Solid understanding of the English language - Proven experience with data entry - Proficient with Excel spreadsheets - High attention to detail - Ability to meet deadlines If these skills match your expertise, I encourage you to apply.
Good day, I need a simple script for Google Sheets to calculate a straight line. The start address should be in A2 and the destination in B2. The air route should then be output in KM in C2. This table is intended to be made publicly available to my customers so that customers can calculate a air distance. Optional: The Google Sheets spreadsheet should then be used by several customers at the same time. That would be the best solution. Best regards, Markus
I'm seeking a skille...a skilled developer to create a macro that automates data extraction specifically from the Sunbiz website. Here's what I need: - A macro that targets - Must extract the following for a single company: - Name - Address - EIN number - Years filed with the state Ideal Freelancer Qualifications: - Proficiency in data extraction and web scraping - Familiarity with automation macro creation - Ability to format extracted data into a PDF - Experience with scripting languages such as Python or JavaScript This project demands attention to detail and a knack for precision, as the data extracted will be used for official purposes. The macro should be robust, secure, and reliable to ensure accurate ...
...com/conversion-centered-design/) Key Tasks: - Design a visually appealing, user-friendly landing page. - Implement a form to collect email addresses effectively. - Ensure compatibility across various browsers and devices. - Set up FaceBook, X, TikTok, Instagram etc and link to landing page - allow export to XL spreadsheet (not CSV) Ideal Skills: - Proven experience in landing page design. - Strong understanding of UX/UI principles. - Expertise in responsive web design. - Basic knowledge of GDPR compliance for data collection. - No need for CRM integration know-how. I'm eager to work with a dynamic freelancer who can deliver a minimalist, clean design with a clear call-to-action. Your ability to create an engaging user experience without the need for backend integra...
I'm seeking an expert proficient in data organisation for a report creation project. The job will entail effectively cleaning up and arranging data in a spreadsheet for creating concise monthly reports. A Python-Panda script should be used to remove ambigous data from a particular row and replacing with the correct data by matching to other datasets in alternate rows. Then, a consistent naming convention will be needed so that a clean pivot table can be produced. Areas Of Focus: - Spreadsheet organisation - Data cleansing - Ensuring accuracy of report production. Ideal candidates should have: - Excellent attention to detail - Proficiency in Excel Python integration - Experience working with undefined datasets. While some data...
We are an Australia-based marketing company searching for a database scrapper or someone with time and advanced Microsoft Excel skills to populate details from a website. If done manually, you are expected to conduct approx. 6,000 searches, and extract details of approx. 25,000 entries (25,000 rows) to an Excel spreadsheet. Each entry will have details related to Practitioner’s Name, Profession, Registration Type, Speciality and Location (5 columns). We will require you to perform a test to our satisfaction before allocating this project to you. Do not bid if you want us to award the project before you perform the test. OTHER NOTES: Payment for this project is $50, which is budgeted and NON-NEGOTIABLE, so please don’t waste your time or ours asking for more money. ...
Use my spreadsheet to list the rankings of FindLaw, Super Lawyers, and LawInfo for each row. Do for the following cities: NEW ORLEANS BATON ROUGE METAIRIE Use this spreadsheet: https://docs.google.com/spreadsheets/d/1Sir7FMcgMTaK2ByPNTUPoPuqv6zCdHoyUOYNrJ3cim4/edit#gid=0
