Excel file xml file automatically vba jobs
I'm looking for an Excel Macro expert to create a macro for me that will automate reporting from local Excel files on my Mac. I need this to enhance efficiency and accuracy in my data handling.
More details: What specific functionalities do you need in the inventory management sheet? Track stock levels, Automate ordering, Generate usage reports How will the initial data be entered into the inventory sheet? Manually What type of items will be tracked in the inventory sheet? Finished goods, Cleaning supplies
I'm seeking a skilled PHP developer who can seamlessly publish real-time Excel data from my PC or OneDrive onto my WordPress website. This Excel file, which contains some external links, needs to be displayed in a customized table format. Key Requirements: - Expertise in PHP and WordPress - Proficient in handling Excel data and creating table formats - Capable of implementing real-time data updates - Experience with integrating external links into Excel Ideal Candidate: - A PHP developer with a strong background in WordPress and real-time data publishing - Able to customize Excel data into a table format - Quick and efficient in delivering high-quality work
... Key Responsibilities: 1. Robot Framework Integration - Seamlessly integrate the email server with Robot Framework on a Windows VM. - Ensure the server supports automation scripts for sending and receiving emails for validation purposes. 2. Email Content Validation - Enable the parsing and validation of email bodies and attachments within Robot Framework. - Attachments will include XML files, GZ files containing JSON, and ZIP files containing text files. - Ensure the automation process can extract and validate content from received email attachments. 3. Troubleshooting & Documentation - Identify and resolve any issues related to email transmission. - Provide a comprehensive, step-by-step guide of the setup process for future reference. The ideal candid...
I'm looking for an Excel sheet that can help me track my daily body vitals. The metrics I need to monitor are heart rate, blood pressure, and body temperature. I will be inputting the data manually, but I also want the sheet to be compatible with data from my smartwatch. Ideal Skills: - Excel expertise - Understanding of health metrics - Experience with data tracking sheets Key Features: - Manual data input fields - Compatibility with smartwatch data - User-friendly design
I'm seeking a freelancer proficient in Google Sheets to design a personalized expense manager for me. Key Requirements: - The first sheet will be where I input my data and it should automatically populate the second sheet. - The second sheet needs to summarize my expenses by category. - The third sheet needs to provide graphical interpretations of my expenses as Pie charts, Bar graphs, and Line charts. - The expense manager needs to track specific categories: Food and groceries, Transportation, and Utilities and bills. Ideal Skills and Experience: - Proficient in Google Sheets with advanced skills in formulas and data automation. - Experienced in creating visually appealing and easy-to-understand data presentations. - Knowledgeable about personal finance management and expen...
I am a data analyst in need of assistance with creating a sales report in MS Excel. Ideal skills for this project: - Expertise in MS Excel - Strong data analysis skills - Experience in sales report creation Looking forward to your bids.
I'm in need of a skilled developer to create a Meme Coin trading bot for me. This bot should be able to automatically find coins, decide when to buy and sell, and connect to an external wallet. It should also be compatible with DexScreener. Key features the bot should support: - Trading strategy: The bot should primarily use a trend-following strategy. - Blockchain Networks: It should be able to operate on Ethereum, Binance Smart Chain, and Polygon. - Buying Criteria: The bot should consider both price increase percentage and volume increase when deciding to buy. Ideal Skills for the Job: - Experience with creating trading bots. - Knowledge of meme coin trading and trends. - Proficiency in working with DexScreener. - Familiarity with the mentioned blockchain networks. - Unde...
Looking for a freelancer to assist with data entry and creation of documents in Excel. The ideal candidate should have experience with both numerical and textual data entry, and be proficient in Excel. The project involves creating and entering less than 50 documents, and we are open to suggestions on format and templates.
My pick slip template needs some modifications to align with the requirements of my growing business. The modifications are as follows: - Removing the 'Out of Stock' table from the bottom of the pick slip. - Adding a new alphanumeric 'Vendor code' ...alphanumeric 'Vendor code' column in-between the 'description' and 'quantity' of the middle table. - The new information to be added in this column is the Vendor code, which is accessible in Business Central. - Add borders between items The final output needs to be in .RDLC format, so that it can be uploaded as a custom template into Business Central. Ideal Skills: - Proficiency in .RDL [XML] and .RDLC file formats - Experience with Business Central - Strong attention to detai...
This is a project to design an Adobe XD file. You can use the PDF and PPT file as a reference to create your design. Pls read below notices carefully 1. I will provide another Adobe XD file as a design sample. You can use this and modify it to get the job done quickly. 2. The PDF file has Korean and English parts, but the content is the same, so you can refer to the English part. 3. if you make a low offer and ask me to negotiate the price again, I will not negotiate. and will Block 4. even if I make an award, if you don't accept within 1 hour, I will cancel it. Sometimes developers will develop without accepting to maintain their reputation. If freelancer try to develop, and it fails, the freelancer can go away, but I lose time. so mus...
Objective: Develop a comprehensive trading and analytics platform for meme coins, incorporating features for volume generation, bundling, automated trading, and social interaction tools such as commenting and user engagement. Key Features and Functionalities 1. Volume Modes Create various modes to simulate or manage trading volume for meme coins: Gen Volume: Automatically generate trading volume for a specific coin to attract attention and create market activity. Enable configuration for volume intensity (low, medium, high). Auto Volume: Set up continuous automated volume generation for a specific duration or until a target is reached. Human Mode: Mimic realistic human trading patterns (e.g., time intervals, trade sizes) to avoid suspicion from algorithms or audits. Micro...
I need someone who can accurately and efficiently copy 100+ recipes from MyFitnessPal into the Kahunas app. Each recipe needs to includes calories and macros (Protein, Carbs, Fat and Fibre). The recipes must be entered as "SERVES 1" and you must check the entries prior to saving to ensure the app has not automatically changed the numbers. Requirements: - Transferring data from MyFitnessPal to Kahunas app - Accurate data entry for 100 recipes - Completion within 24 hours Ideal Skills: - Familiarity with MyFitnessPal essential - Familiarity with Kahunas app preferred - Excellent data entry skills - Ability to work under tight deadlines
...Features: ✅ Trip Management • Manually add/edit trips or bulk upload via Excel/CSV. • Automated trip assignment based on driver availability & location. • Live trip modifications (e.g., change pickup times, cancel trips). ✅ Automated Route Optimization • Uses Google Directions API to generate optimized routes. • Real-time traffic adjustments to reduce delays. • Supports multi-passenger trips (patients traveling in the same direction). ✅ Driver Monitoring & Tracking • Live GPS tracking for active drivers. • View driver workload & trip acceptance rates. • Send manual trip reassignment notifications if needed. ✅ Medicaid Billing Integration • Generates Medicaid-compliant trip logs for reimbursement. • ...
I need assistance in arranging data related to gemstone manufacturing on a single spreadsheet. The ideal candidate should be proficient in Excel and experienced in data organization. Key requirements include: - Proficient in Excel - Ability to manipulate and analyze data - Experience relevant to gemstone or manufacturing processes Deliverables: A well-organized and clearly presented sheet containing all relevant data for gemstone manufacturing, ready for analysis.
I need a Python script that can extract hotel names and their corresponding page links from various travel and hotel booking w...Proficiency in Python, particularly in web scraping libraries such as BeautifulSoup or Scrapy, selenium. - Knowledge of data extraction techniques and tools. - Experience with manipulating and structuring data for easy interpretation and usage. Please note that the format for the extracted data has not been specified yet, so flexibility in your coding to allow for various output formats (CSV, JSON, Excel) would be beneficial. Additionally, while the primary focus is on hotel names and page links, potential to expand the data set to include hotel addresses, ratings, and room prices would be appreciated. Please bid if you have the required skills and e...
I need someone who can accurately and efficiently copy 100+ recipes from MyFitnessPal into the Kahunas app. Each recipe needs to includes calories and macros (Protein, Carbs, Fat and Fibre). The recipes must be entered as "SERVES 1" and you must check the entries prior to saving to ensure the app has not automatically changed the numbers. Requirements: - Transferring data from MyFitnessPal to Kahunas app - Accurate data entry for 100 recipes - Completion within 24 hours Ideal Skills: - Familiarity with MyFitnessPal essential - Familiarity with Kahunas app preferred - Excellent data entry skills - Ability to work under tight deadlines
...diagnosis, persuasive techniques, closing attempts). ✅ **Feedback & Coaching Insights:** Each agent should receive a summary of their performance, highlighting areas of improvement and strengths. ✅ **Integration with Dialpad & Zapier:** Our company uses **Dialpad**, which provides call recordings, transcriptions, and API access. The system should integrate with Dialpad (via API or Zapier) to automatically process calls. **Ideal Solution:** - A custom AI model (or integration with an existing AI tool) that can evaluate conversations and assign scores. - A dashboard or automated reports where managers can review agent performance. - The ability to adjust scoring criteria as needed. **Deliverables:** - Fully functional AI-based call grading system. - ...
I need an expert who can edit my .ipa file to modify its functionality, update it with new data and configuration files I have on hand, and then resign it. Ideal Skills and Experience: - Extensive experience with .ipa file editing and iOS app resigning - Strong understanding of modifying app functionality - Proficiency in working with data and configuration files - Familiarity with iOS app development standards and guidelines - Ability to deliver high-quality work promptly and efficiently
Looking for assistance with Excel sheets and real estate tasks for my building and real estate projects. Let me know if you're interested!
We are currently seeking a skilled professional for a virtual data entry role. Below are the job requirements and expectations: Primary Responsibilities: • Enter data from PDF files into Excel spreadsheets. • Ensure accuracy and attention to detail. Job Requirements: • Proficiency in Excel. • Typing speed of at least 30 words per minute (to be verified via a typing test on ). • Ability to work virtually with high-speed wired internet (minimum 25 Mbps). • Access to a desktop computer in a professional setting. • Familiarity with remote access software such as AnyDesk or TeamViewer, as the work will be done on our computer. • Availability to work between 10:00–11:00 AM Vancouver time (Pacific Daylight Time). Additional Real ...
...integration. Link Management: Links are numbered for easy organization. Users can add links (up to their plan limit) with a maximum click limit per link. A delete button allows users to remove links as needed. Only the top link will be clickable; the rest will remain grayed out. Once a link reaches its maximum click limit, it will: Show as “Completed” in blinking red text. Automatically move to the bottom of the page. Your Public Page Section: Users can customize their public-facing webpage by entering: A Title for their page. A Slogan to reflect their brand or opportunity. An About Us section to introduce themselves or their opportunity. The public page will display only these three elements for simplicity and clarity. Admin Dashboard ...
I'm looking for a freelancer to create an Excel workbook that consolidates data from 7 source sheets into a main sheet. The solution should dynamically update in real-time as the data in the source sheets change. PLEASE SEE THE ATTACHED PDF FOR A BETTER UNDERSTANDING. Key requirements: - Use either Excel formulas or Power Query. VBA and Macros are not allowed. - Summarize totals for each unique combination of columns A-D from the source sheets. Note : data both sheets could go up to 1000 + rows. Deliverables: - A fully functional Excel file where the main sheet updates in real-time. - Clear documentation or a short instructional guide explaining how the solution works. Ideal skills and experience: - Strong Excel skills and expertise in ...
...1. Creating posters for instagram 1080x1080 size. Creating and posting 15 posters per month including description and tags on alternative days. Cost per poster 300/-. So the total amount per month for poster uploads 4500/- 2. Running ads on instagram on alternative days. Estimated reach 3k-6k Followers depends on the content More Traffic to website / instagram page is targeting. It will automatically increase sales and bookings. Running ads for 15 alternative days Cost per day 300/- So the cost for 15 days will be 4500/- Client should provide us the idea or content for creating the posters like like captions, informations, offers, discounts etc... Once the design is ready, only minimal changes by the client accepted. Need payment for the first 10 days as advance, or cust...
Enhance an Excel file about real estate investment. I'll highlight entry values in green, correct and insert formulas when needed.
• Add sort by name/date etc. to open file dialog • plot GPS track bitmap • Add drag of y-axis to change size • Allocate colours to channels automatically
...#thread-detail li { border-top: solid 1px #5b5b5b; } .dli { border-top: solid 1px #5b5b5b !important; } .forum #thread-detail h3 strong, { color: unset !important; } #phorum { border: unset !important; background-color: #584a47; } a, .supplementary >input, aside >input { color: #e84d0e !important; } .golem-external-url { background: url("data:image/svg+xml,%3Csvg%20xmlns%3D%22http%3A//
...important; } .forum #thread-detail h3 strong, { color: unset !important; } #phorum { border: unset !important; background-color: #584a47; } a, .supplementary >input, aside >input { color: #e84d0e !important; } .golem-external-url { background: url("data:image/svg+xml,%3Csvg%20xmlns%3D%22http%3A//
I'm looking for a custom Excel template to organize my extensive sports memorabilia collection. The collection includes various types of items, such as: - Autographed items - Trading cards - Game-used items - Pop figures - Jerseys - Balls - Movie memorabilia The template should be user-friendly, allowing for easy input and tracking of each item. Ideal candidates should have experience in creating digital templates, preferably for memorabilia or similar collections. Skills needed: - Advanced proficiency in spreadsheet software - Experience in template creation - Knowledge of sports memorabilia is a plus. Please submit your proposal if you have the required skills and experience. I am not looking to create a logo or websitr
I need an Excel dashboard created from our data that we currently track in Excel across multiple locations. The dashboard should display a variety of key metrics including: - Sales data - YOY Data - Membership Sales - Membership Conversions - Labor as a percentage of revenue - Birthday party revenue and YOY data for same week LY - Concessions Revenue and YOY data for same week LY The ideal freelancer should have: - Expert proficiency in Excel - Experience in creating dynamic dashboards - Ability to visualize data using bar charts and line graphs - Understanding of sales and revenue tracking The dashboard should be able to visualize data using bar charts and line graphs, as well as dynamic dashboard visuals. The dashboard will need to refresh data on a weekly basis. ...
...with my Kubernetes setup and FluxCD ImageUpdateAutomation. I've configured everything with FluxCD, including Image Automation, but I'm having a problem with ImageUpdateAutomation. Here's the situation: - FluxCD is successfully detecting new Docker images via ImagePolicy. - However, ImageUpdateAutomation isn't applying the necessary changes to the yaml manifest, preventing Kubernetes from automatically updating to the new image version. I need an expert to either configure or repair this final stage of ImageUpdateAutomation so that changes from ImagePolicy are reflected in my Deployment yaml manifest. Important details: - My Kubernetes manifests are stored in GitLab. - I've confirmed that FluxCD has the necessary permissions to push changes to the repo...
I have an Excel workbook with 7 source sheets and 1 LV (Landing View) sheet. The task is to automatically consolidate data from the 7 sheets into the Main sheet using either Excel formulas or Power Query (VBA and Macros are strictly off-limits). Requirements: - The solution needs to be dynamic, updating the LV sheet in real time as data in the 7 source sheets changes. Deliverables: - A fully functional Excel file where the LV sheet updates in real-time based on data from the 7 sheets. - Clear documentation, or a short instructional guide, explaining how the solution works. Ideally, the freelancer will have strong Excel skills, expertise in using Power Query, and a good understanding of data mapping. Experience with creating dynamic ...
Scrape agent's full name, company, mobile number, and suburb from the provided RealCommercial link. Store the data in a structured spreadsheet format. Remove duplicate entries to ensure clean data. Deliver the final CSV or Excel file.
...trading signals and should encompass various essential features. Key Features: - Automated Trading: The bot should execute trades based on signals derived from technical indicators. - Risk Management: Incorporate robust risk management features to protect investments. - Trade History Logging: Maintain a comprehensive log of all trades for analysis and review. - Automatic Compound: The bot should automatically reinvest profits for compound growth. Ideal Skills and Experience: - Proficiency in API integration with Quotex and Pocket Option. - Extensive knowledge of binary options trading and technical indicators. - Experience in developing risk management features within trading bots. - Ability to create a reliable trade history logging system. - Familiarity with automatic compoun...
...Scientific research labs • Medical and clinical labs • School/educational labs • Governmental labs • Food testing labs • HPLC labs • Cytogenetics labs • Industrial labs Data Requirements: Each laboratory entry must include the following: 1. Laboratory Name 2. Address 3. Telephone Number 4. Email Address (mandatory) 5. Website (if available) Project Deliverables: • A spreadsheet (Excel, Google Sheets, or CSV format) containing at least 1,500 unique laboratory contacts. • Each row should represent one laboratory, with columns for the required data points above. Important Details: • Labs from Mexico or Brazil will NOT be accepted. Please do not include any contacts from those countries. • All data must be acc...
I need assistance in exporting questions, answers, and explanations from a ChatGPT report into an Excel document. The data consists of 400 items formatted as text paragraphs in the report. Please see example link below: If you open the file above, you will see there are 400 questions organised into: 1) questions 2) correct answer 3) Explanations When you try to ask ChatGPT to export all data into an excel document it doesn't do this properly. It only gives a sample of the questions. I want a freelancer to find a way so that you can instruct ChatGPT to properly export all data so it matches what is produced from before. We have over 100+ documents with each document containing 400+ questions. If you can do it for 1 correctly
...match, they will get 5 points automatically. Remaining Points (5 points left): The remaining points will be awarded based on: Player Performance: Points for each correctly predicted player's performance. For example, a user might get 1-2 points for correct player predictions. Team Runs and Wickets: Points for predicting team runs, wickets, or total performance. Wickets Taken: Additional points based on the number of wickets the team or players took. 5. Leaderboard System: The bot should track each user’s points and display a leaderboard. Users can check their current rank and points with the command /leaderboard. The leaderboard should show rankings by: Overall Points. Weekly and Monthly Rankings. 6. Notifications & Updates: After each match, the bot will automa...
I'm looking for a freelancer who can set up an automated process that transfers my inventory details from QuickBooks Desktop to an Excel sheet on a daily basis. Key Requirements: - Data Transfer: The project entails transferring inventory details from QuickBooks to an Excel sheet on a daily basis. - Data Processing: After the data is transferred, I need it to be summarized in the Excel sheet. Ideal Skills: - Proficiency in QuickBooks Desktop - Advanced Excel skills - Experience with data automation Please ensure you have the relevant experience and skills before bidding. I look forward to your proposals.
I'm seeking a proficient accountant with strong financial analysis skills and expertise in Microsoft Excel. Key Responsibilities: - Conduct comprehensive financial analysis - Manage accounts payable and receivable Ideal Skills: - Proficient in Microsoft Excel - Strong financial analysis capabilities - Experienced in managing accounts payable/receivable
I'm looking for a professional with experience in XML/ATS integration between indeed and GoHighLevel automation. The project is divided into three phases: 1st Phase: - Enable the XML/ATS integration on Indeed. - Generate an XML feed URL for my job postings. - Create a new API connection in GoHighLevel. - Configure the API connection to receive Indeed's XML feed. - Map Indeed's XML fields to GoHighLevel's contact fields. 2nd Phase: - Connect my Indeed account to the Integration App. - Connect my GoHighLevel account to the Integration App. - Create a new automation that triggers on a new applicant in Indeed and adds this contact to the GoHighLevel pipeline. - Configure the automation to map Indeed's applicant fields to GoHighLevel...
**GENERIC AUTO REPLIES WILL BE IGNORED* We have a finished website where we collect insurance papers from customers, and supply these to different insurance companies so they can give offers and see if they can save our clients some money. We are posting on Freelancer to see if anyone has any experience in implementing BANK ID in our site to automatically login to their current insurance providers website and pull out the documents automatically. I can show you examples on this upon request, but you would need experience in the Norwegian market and also in bank id to be able to help us here. You would need to create a software/robot that will in back end login to the other company's website which then will navigate on their actual website, find the documents, downloa...
...a tailored Excel template to streamline my work checks. Currently, I have to manually copy and paste complicated formulas and use text replace functions to substitute keywords like LESS and PLUS with their mathematical counterparts. For examples sake, I want to put in "(25%LESS1/8LESS1/16 of 7/8) of 1/2 of 1/2 of 8/8" in A1, and have a Cell then automatically output that info. I have used substitute functions, then did evaluate formulas, but doesn't turn out right. Key Responsibilities: - Develop an Excel template that can process long form mathematical expressions and return values automatically, saving me the tedious work. - Ensure the template can handle mixed operations including addition, subtraction, multiplication, and division. Idea...
I'm in search of a proficient Excel specialist to assist with various tasks related to public data and knows how to do formulas ! . Your primary responsibilities will include: - Data Entry: Accurately inputting information into Excel sheets. - Data Analysis: Utilizing Excel's powerful tools to make sense of the data, organize it and seperate it - Report Generation: Creating comprehensive reports based on the data analysis. Key skills and experience required for the job include: - Proficiency in Excel, with a particular focus on data entry, analysis and report generation. - Experience working with public data. - Expertise in generating charts and applying formulas.
Woork Scoop I need to update only some text an HTML template file through a plugin's admin page. The update primarily involves adding some new text content to the main section of the html template. Some area and text in the html template file have to be untouched or locked for updating due to functionality. Plugin : The admin plugin page is already created , this HTML approach is an aditional functionality to the page. The html file is located in the wordpress plugin folder structure. This html file is connected to the dompdf library function to attach a pdf file to customer mail when order is completed. Ideal Skills: - Proficiency in HTML - Experience with WordPress plugins - Attention to detail for content placement - Experience in PHP ...
I'm looking for command line based application for a Students Grading System. The key feature of this grading system should be the ability to input grades and have them calculated automatically (please follow the specification of the project in the attached file). Ideal skills for this project include: - Proficiency in Windows desktop application development - Strong understanding of grade calculation algorithms - Experience in creating user-friendly interfaces - Attention to detail to ensure accuracy in grade computation Please note, the scope of this project does not currently include features such as student performance tracking or report generation. However, the design of the system should allow for potential future upgrades to incorporate these features.
I'm looking for an Excel expert to help me create a comprehensive spreadsheet for an educational charity. Key Responsibilities: - The main purpose of the Excel Spreadsheet will be to compare various metrics of specific areas (London Boroughs) within the Region. - We need to compare a variety of metrics. The specific metrics will be populated later, but they could include population statistics, crime rates, and educational outcomes. - The level of detail in the comparison needs to cater for both high-level overviews and detailed analyses. Ideal Skills and Experience: - Proficiency in Excel is a must, with experience in data analysis and spreadsheet creation. - Understanding of educational metrics and social statistics would be a plus. - Ability to create user-f...
I have an old and heavy Excel sheet that often lags. I need an updated, optimized, and improved version without any errors. My primary use for this Excel sheet is data analysis. Specifically, I use it for: - Statistical analysis - Data visualization - Using pivot tables The sheet typically handles more than 100,000 rows of data. Ideal skills for the job include: - Advanced expertise in Excel - Experience with data analysis - Skills in optimizing Excel sheets for heavy data usage - Proficiency in creating error-free and efficient spreadsheets Please note, I need this task completed as soon as possible.
I'm looking for an Excel expert who can help me automate my spreadsheets to reduce manual data entry, specifically dealing with financial data. The ideal freelancer for this job should have extensive experience in Excel, particularly in spreadsheet automation. Skills in handling financial data and creating efficient solutions to streamline processes are a plus. Please include your relevant experience in your bid.
...Responsibilities: - Implement and integrate Zoho CRM, Zoho Books, and Zoho Projects into our operations via Zoho One. - Ensure the systems work seamlessly together to enhance efficiency and productivity. - Facilitate improved tracking and reporting of our financials through Zoho Books. - Optimize our project management processes through Zoho Projects. Data Migration: - I have existing data from excel on customers and past histrorical data that needs to be migrated from another accounting software to Zoho Books. This includes financial records, customer data, and project history. Ideal Skills: - Proven experience in Zoho One implementation and integration. - Proficiency in Zoho CRM, Zoho Books, and Zoho Projects. - Strong understanding of financial tracking and reporting. - Exp...
