Vba excel write data xml file jobs
Hi. I have 2 different spreadsheets. They were originally made on Microsoft excel. See attached pictures. One is a meal plan document and a nutrient database document. An extended formula was made for me. The formula enabled for each row, there was a drop-down menu that I could select which food and this would sync the food, protein, carbohydrate, dietary fibre and dietary fat for the specific food selected I would be able to adjust the numbers to calculate the calories and macronutrients for the food. I have now moved from Microsoft excel to libre office. The formula doesn’t work anymore. The drop-down is not working. The only dropdown comes on "JB Foods", but not linked to nutrient database. The nutrient database doesnt have formulas. It is the meal plans ...
A filter is needed 8500leads with their different academic results. please show relevent project
I'm looking for an extremely meticulous freelancer to help me transfer mixed format data from a PDF to Excel. The content is comprised of simple list items, so no need to handle complex structures or tabular data with calculations. However, attention to detail is critical as I require 100% accuracy in the results. Ideal skills and experience for this task: - Significant data entry and file conversion experience - Superior attention to details - Proficient with Excel and PDFs - Proven track record of delivering 100% accuracy in similar tasks.
I am seeking an experienced data scraper who can extract news event information from and meticulously compile it into an excel file format (GOOGLE SHEET) , year by year. Subsequently, create another excel file once completed the orignal one where all the years' data will be consolidated into one single tab of the file. Key requirements include: - Proficient in data scraping. - Excellent skills in data organization and excel management. - Ensuring no miss-information during the data transfer. To apply, freelancers should provide: - Relevant past work, particularly in data scraping and excel data management. - Detailed project proposal, demonstrating your understanding of the task. P...
I am looking for an Excel professional to help me enhance the formatting of my sales data spreadsheets. Below are some key aspects of the project: - **Main Task**: The key task here is to significantly improve the formatting of my spreadsheets, making it simple and convenient to analyze and review extensive sales data. - **Ideal Candidate**: You should be highly skilled in Excel, proficient in creating and managing complex spreadsheet formats. The ability to offer innovative and creative solutions for better data visualization is also highly desirable. - **Formatting Needs**: While I've foregone specific formatting changes, your expertise in managing and tuning aspects such as data validation rules, cell colors and conditional formatting w...
I'm looking for an experienced Excel specialist that can help create templates tailored for project management. The focus will be on tracking activity such as: - Task progress: I need a clear way to visualize the start and end dates of different tasks. - Project timeline: We need to monitor a high-level view of all the activities in the business. - this will needs tabs for BG activity over various cost centres, to view as a dashboard. Comms tracker, social media tracker, bid tracker, awards tracker, pursuits tracker This system should help us understand where we are in a given project and what needs to be done to keep everything on track. Strongly proficiency in Excel and a background in project management software will be a great advantage for this project.
...standard-provided module, featuring an eye-catching, modern, and clean design. 2. Including more data analysis features: The revised worksheet should also come with advanced data analytics features to allow for an efficient insights extraction. 3. Enhancing decision rule options: Crucially, the final output should incorporate sophisticated decision rule options to facilitate better data-driven decisions. A crucial detail is that the current format of the worksheet and report is xls, and I want it to remain as such in its upgraded form, retaining an easy-to-read font and colour scheme while boasting organised and intuitive sections. Professionals with a strong background in spreadsheet management, data analysis and reporting, and seamless design transition...
I am in need of a professional who can provide meticulous bookkeeping and financial statement preparation for my business. Currently, we are using QuickBooks and Excel in managing our accounts, thus someone with capability and experience in these tools is highly appreciated. Additionally, I'm seeking quality editing services encompassing proofreading, copyediting and content editing. It is important for the successful freelancer to have an acute attention to detail and a solid understanding of grammatical rules. Ideal skills and expertise for this job would include: - Proficient in QuickBooks and Excel - Extensive bookkeeping and financial statement preparation experience - Strong proficiency in proofreading, copyediting and content editing - Exceptional attention...
...to assist in setting up my store that will carry more than 50 digital documents. The products range from Microsoft Word, Excel to Visio files. Ideal Skills: - Proficiency in Shopify - Experience with digital product setup - Ability to suggest and implement design and layout The project requires: • Set up for an extensive digital product inventory • Capability to advise on layout and design I am open to design suggestions to create an intuitive and customer-friendly Shopify store. This should make it easy for visitors to browse, select, and purchase digital documents. Demonstrable experience in similar projects would be an added advantage. I've attached a .png file that would be displayed as the item to be sold. Should be downloadable and show multipl...
Hi, I need someone very experienced with importing variable products from Excel. Attached is a sample file. I'm having issues Doc on importing variable products using this plugin - :~:text=To%20import%20variable%20products%2C%20go,data%2C%20then%20run%20the%20import.
1. We have 32 backups from the same database as .sql-files. From one table of this database we need all instances in one csv-file (with the same codepage as stated in the sql-file ). So basicly you must: - import 1st backup on your sql-server - export the table "contracts" to "csv for Excel" - repeat for all 31 other backups - put everything together in one big csv-file that is readable in Excel (pls maintain german umlaute) 2. There should be a menu-item (i.e. "Report"); clicking this asks for the date "Welches Datum?"; the current date is proposed but can be changed by choosing a date in a calendar. The report should consist of: 1. All customers that have been added at the given date. 2. All contracts tha...
...have a <last name> from the list in the attached Excel sheet - only these last names are acceptable 3. Must be based in USA/UK/Australia/Canada/New Zealand / - only these 5 countries are acceptable The data you will need to fill in are: 1. A specific industry which the company is involved in - for example, what do they do ? (Steel manufacturing company, data services provider company, petroleum refining company etc.) 2. What was their turnover in 2019/2020/2201/2022/2023? 3. What is the Email address of the CEO/Director or MD ? 4. What is the person's name? 5. What is the person's LinkedIN URL? 6. Which city is the person based in ? 7. Which country are they based in ? 8. What is the company name? Please fill in the data into the attached ...
Looking for Python expert to write a script and "mix" two PNG images together, I want to take left half of image one and right half of image two then create a new image. I also want options of the intersection, instead of just straight line from top to bottom, I'd like options of being slanted left, slanted right, or curved left / right Details to be discussed This needs to be done in Python3 with any popular library like PIL or Image Start your bid with "I do python" or your bid will be ignored
As a client requiring precise and frequent data extraction, I'm seeking a skilled freelancer experienced in web scraping to assist with extracting specific data points from Website 1. Data Details: - The data point of interest is "Time wise status" - The objective is to have this information converted into excel format. Frequency: - The task requires real-time data scraping, with updates to be captured every 5 minutes. Desirable Skills and Experience: - Solid experience with web scraping techniques - Proficiency with Excel - Ability to create a solution that can scrape data every 5 minutes - Experience with Website 1 or similar sites would be an added advantage.
I'm seeking a skilled freelancer to assist with a special effects video editing project. The focus will be primarily on delivering compelling motion graphics and animations within a short film of 5-10 minutes length. Key Skills and Experience: - Expertise in special effects editing - Creativity in im...within a short film of 5-10 minutes length. Key Skills and Experience: - Expertise in special effects editing - Creativity in implementing motion graphics and animations - Ability to deliver quality work efficiently despite tight deadlines - Previous experience in similar projects is a bonus Please note that audio service is not required in this project, so those who excel in special effects and visual editing will excel in this project. Let's create something ...
...in need of a professional who can assist with data cleaning, formatting and entry for my Excel sheets. This project requires an individual who is proficient in data validation as this is an essential function to successfully carry out the task. You will be working with Excel sheets specifically for data validation during data entry and database management. Experience with Excel and a good understanding of data formatting is an absolute must for this project. Key Responsibilities: - Data cleaning and formatting - Data entry and database management - Validating Excel sheets during data entry Skills and Experience: - Proficient in Excel - Experience in data validation - Knowledge in da...
I am looking for a specialist who can help automate several tasks on my desktop. Key Duties: • Open specific apps including Python, Excel, and one other unnamed app. • Execute data entry tasks. • Extract text files. • Run existing Python scripts. For this role, a background in automation, a firm grasp of Python, and knowledge in handling Excel are vital. Proficiency in other automation tools or scripts would be an added advantage. Understanding how different apps interact will also be key to this role. I will show you my desktop to you over TeamViewer. And explain you my work. The objective is to streamline my workload, improve efficiency and reduce manual input where possible. Your expertise will be invaluable in setting this up and ensuring...
I'm in need of a specialist service to meticulously scrutinize multiple video files. The primary goal is to extract niche data from these files pertaining to their originality and modifications. Key Responsibilities: - Extract key information from the video files, the purpose being to verify if the files are edited from their original state. - Focus on specific elements including timestamps, duration of the clip, as well as metadata and editing history, to carry out a comprehensive verification process. Ideal skills: - Detail-oriented approach to task assignment. - Skillful in video analysis and interpretation. - An understanding of video format, compression, and metadata would hugely benefit this task. - Experience in identifying discrepancies in documentation or footage is...
I am currently in need of a highly skilled virtual personal assistant (PA) ideally based in the Philippines who can aid me in staying impeccably organised and managing a variety of tasks. Here are the specific responsibilities: - Organising tasks and appointments to ensure that my schedule is fully optimised and nothing slips through the cracks. - Managing Zoom meetings, overseeing both the technical aspects and overall coordination. - Handling YouTube posting, including video uploads and channel management. Previous experience with YouTube channel management is preferred. - Designing visual content using Canva. A strong graphic design background and a keen eye for aesthetics would be beneficial. - Running email campaigns using MailerLite or Mailchimp. This would involve designing, ...
...database. Candidates must have expertise in: - Development of React applications. - Integration of .NET API. - Working with SQL databases. - **Core Functionalities:** - **User Authentication:** Secure login system using email and password. This system should ensure that user data is protected and only authorized users can access the application. - **CRUD Operations:** The ability for users to create, read, update, and delete data within the database seamlessly. This includes managing user details, settings, and other data points relevant to the application. - **Role-Based Access Control (RBAC):** Different levels of access and permissions for users based on their role within the application. - **Ideal Skills and Experience:** - **React.js:** Proficiency in buil...
...an efficient data scraping specialist who can extract information from I need all the fields provided in the URL listings. Criteria: -Ideal candidates should have a thorough working knowledge of data scraping software and have previously worked on similar projects. - I don't have specific fields to extract but I'm interested in, the more data you can extract, the better. - All the data gathered should be delivered in an organized Excel format. - Cleaning or preprocessing the data isn't a current requirement. - Efficient and detailed scraping abilities will be beneficial for this task. This project will require you to navigate through approximately 7,000 search results on the indicated website. An attached sample file w...
Hi, I need someone to organize some Excel Files for me. I have a list of domains and emails. I need to organize the domains and emails together. I can give more info in the chat. I have a $50 budget and am hoping to complete it within a day.
I have a pressing project involving my Wordpress Fluent Forms and my CRM, which happens to be Vin Solutions. I need to send leads from these fluent forms in the ADF format directly to my CRM, but I'm having trouble making this I need someone who can do this work now and who has experience posting XML ADF format leads into a CRM
---Project should be an APP that runs in Windows ---Programmer should have at least working knowledge of the stock market/symbols/shares/exchanges. --I do not have a preferred programming language for the app, it should have a gui for adjustments in addition to its own config file for adjustments to criteria, and a way to upload symbols and symbol profit data in order to make adjustments. ---They should also be open to later version improvements/future work if production goes smoothly. App should be able to: -Add symbols from with last price to config with x default parameters and specified exchange-- note on "day added" (Parameters include Price range (such as ">$3" and "<$300"), Average Volume/price such as ("500,000 shares/$2...
...in PDI Essentials (C Store Pro), a back office software widely used in convenience stores across the United States. My goal is to improve and streamline my sales reporting system by: - Setting up daily reports in PDI Essentials for better tracking and analysis. - Integrating this software with custom Excel sheets, which I currently use for reporting. Your main tasks would involve designing and setting up this integrated system. Therefore, proficiency in using PDI Essentials and advanced Excel skills are required. Knowledge in convenience store operations and sales reporting is a plus. This project will be paid hourly in U.S. dollars. Your task is crucial in optimizing my convenience store’s reporting system, thus impacting decision-making and overall operations. I...
Hi Lalit K., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
I'm seeking an experienced Python developer to build a program that can download specific weather data and parse it into an XML file. There isn't a preference for Python 2 or 3 – the chosen version will be left to the discretion of the professional. Data Points Needed: - Temperature - Humidity - Wind speed - Wind direction - Highest temperature - Lowest temperature - 'Feels like' temperature The program should be able to call an API and receive an API response, before parsing this data to XML. Ideal Skills: - Proficiency in Python - Experience with API calls - Knowledge of XML parsing. I look forward to having a streamlined process for fetching and parsing weather data.
I need an experienced Excel professional who can help me extract both textual and numerical data from a particular sheet and organize it in a new one with precision. Key tasks include: - Extract specific text and numerical data from one Excel spreadsheet - Prepare a new sheet and structure it in a table format You should be proficient in Excel with experience using specific formulas or functions in addition to a thorough understanding of data extraction and organization processes. Familiarity with my specific worksheet would be an added advantage. Please indicate in your bid if you have experience in handling similar tasks. If you are skillful, accurate, and timely, then I encourage you to apply for this project.
We are in need of a skilled illustrator to create bright, playful, cartoon-like MDMA pill images. The ideal candidate should excel in cute and playful aesthetics, as the art will be used to propel a marketing campaign intended to spark excitement. Key project requirements: - Highly inventive and colorful designs - Style should be cheerful and engaging to our audience - Previous experience in creating cartoon art preferred - Familiarity with marketing and understanding how to evoke emotions through artwork will be beneficial Please include any relevant work samples or portfolio pieces in your bid. Exciting opportunity for creative professionals looking to push the boundaries. We're all about fun and engaging content, can't wait to see what you bring to the table!
I require someone to take my large VCF contacts file containing 7000 entries and comprehensively transfer them to an Excel spreadsheet. Key Project Details: - Extraction of Name, Phone Number, and Email Address from each contact file. - Names need to be split; allocating 'First Name' and 'Last Name' to separate columns in the spreadsheet. Ideal Candidate Attributes: - Strong proficiency in Excel and data manipulation. - Experience in VCF and Excel conversions. - Strong attention to detail to ensure data accuracy. - Ability to work expediently is also a plus, given the volume of contacts. Please note, no additional fields or information are required beyond name, phone number, and email address. Remember to maintain ...
I need a system using Excel or Google Sheets, or a simple web application capable of compiling payroll tax data as per the attached Excel file to generate a PDF report named EA Form, with an emailing function to send it to the respective employees. Key tasks: - Generate a PDF report (EA FORM) using the excel data - Email the PDF report (EA FORM) - Print the PDF report (EA FORM) Ideal skills required: - Proficiency in generating reports from excel data - Skills in PDF report designing - Skills in automated email systems.
I'm seeking a skilled professional with architectural and CAD drawing proficiency. Your task will be: - Taking my hand-drawn residential landscape plans and transforming them into digital versions: - Experience in horticultural designs is not required. - Familiarity with various software is a plus, maybe Excel and Indesign. The proposed planting plan to be drawn up is in pencil. Other plans showing hard landscape and levels will follow in pencil, for drawing up. To illustrate what I need, I attach examples of: - a planting plan for your information, of the kind I need for this project. Yours need not be exactly the same - it is for use as a working drawing and does not need to be a pretty picture. - a planting schedule for copy pasting onto the planting plan, as an e...
...local utility to: 1. Back up the Excel Spreadsheet by making a copy, keeping the last 10 copies 2. Automatically append the contents of 1-2 CSV files found in a folder to an excel spreadsheet 3. Move processed files into a COMPLETE folder 4. Log the results in a local text file. Full story: My software exports 2 CSV files daily to a local computer. These CSVs show the products that have been sold and the quantities of each product sold for that day. We need to add these rows of data to a master Excel sheet, and it should be done automatically when a new file is detected, OR at a specific time each day. The fields would be Date Sold, Erply ID, UPC, Internal ID, Description, Qty Sold The CSV files would be The Excel Spreadsheet w...
I'm in need of a data extraction specialist with strong experience in web scraping to extract text content from a specific website with open data. This data should then be organized in an Excel spreadsheet following a format that I will provide. Skills required for this job include: - Experience with web scraping and data extraction - Knowledge of Excel and data organization Please note that the information extracted should adhere strictly to the provided format. With your bid, kindly include any past similar projects you've successfully completed. This helps me gauge your understanding and experience in this field. This is an important project for me, so completeness, accuracy, and confidentiality are top priorities. If you hav...
For my ongoing work, I need assistance in converting an existent VBA script from Excel 16 on Windows to properly function on Excel 2016 on a Mac. The script I currently have is responsible for automating a series of key tasks which substantially help my productivity, specifically: - Arranging and sorting my data Successful candidates should be comfortable with both operating systems, have an excellent command over Excel, and a deep understanding of VBA scripting. Prior experience in Excel-to-Mac conversions is also beneficial. This job requires clever problem-solving, meticulous attention to detail as well as the ability to clearly communicate the changes made.
I am urgently in need of a Virtual Assistant to streamline some data entry tasks and conduct web research for my organization. Expectations: - Perform data entry tasks - Conduct web research on various topics Time Commitment: - Full-time employment; over 40 hours per week. Required Skills & Experience: - Proficiency in Microsoft Excel - Extensive experience in web research - Solid understanding of Google Search engine - Detail-oriented; capacity for handling high-volume tasks Preference will be given to candidates proficient with data entry software. Although not required, this would be a plus. Overall, I'm looking for efficiency, accuracy, and a good work ethic. If you believe this describes you, please bid!
I need an expert Excel user who can effectively refine and organize data in an existing file. Your role will primarily entail removing any entries from file A which are already present in file B. Key responsibilities: - Scan through each entry in file A to identify duplicates in file B - Erase or omit entries that exist in both files For this project, proficiency in Excel and keen attention to detail is necessary. Previous experience with data refining tasks will be beneficial. To ensure the successful completion of this project, you should be able to follow directives strictly, and apply logical reasoning skills when necessary. For confidential reasons, the specific data information will be provided only to the ch...
I need an automated system built on Excel for my business. Invoice, Stock Mgmt, Payments, Expenses. Will pay in INR.
My host change the PHP version and my website is very old and Every day I have to upload a single file .htaccess to my server and the website working 100% with this file uploaded. I would like a automatic solution do upload this file 2 times a day. 1) Actually my website hosting in Hostgator; 2) I have AWS Account if necessary; 3) My PC is Windows if this informations is important or not. Regards, Robin
[Tool] Use UiPath, not UiPath X. DO NOT use other RPA tool. [Detail]Process Excel tables row by row and paste them into Google Docs. A (Create Notice of Appointment to Employees) --[Input] "" --[Output Goal]Copy Excel(.xlsx) data and paste to Google Docs( not microsoft Word). Create google docs that is very similar to following Example. --[Output Example] B (Create Test for Interview Candidates) --[Input] "", --[Output Goal]Copy Excel(.xlsx) data and paste to Google Docs( not microsoft Word). Create google docs that is very similar to following Example. --[Output Example]
I'm seeking a professional with proficient knowledge in Microsoft Excel, who can perform basic arithmetic calculations (addition, subtraction, multiplication, division) on a single worksheet. Your responsibilities will include: - Implementing formulas to perform arithmetic operations - Ensuring high data accuracy - Validating calculations results. Ideal candidates will have previous experience with similar tasks and a keen attention to detail for ensuring accurate calculations. Strong Excel skills are a must. The freelancer should be able to begin work immediately.
I am in need of a talented freelancer to revamp my resume. I want him/her to optimise it, rewrite / update it. I’ll send a draft and he/she has to write it efficiently.
...acceptable 2. Must have a <last name> from the list in the attached Excel sheet - only these last names are acceptable 3. Must be based in USA/UK/Australia/Canada/New Zealand / - only these 5 countries are acceptable The data you will need to fill in are: 1. A specific industry which the company is involved in - for example, what do they do ? (Steel manufacturing company, data services provider company, petroleum refining company etc.) 2. What was their turnover in 2019/2020/2201/2022/2023? 3. What is the Email address of the CEO/Director or MD ? 4. What is the person's name? 5. What is the person's LinkedIN URL? 6. Which city is the person based in ? 7. Which country are they based in ? Please fill in the data into the attached Excel...
In need of an experienced Microsoft Excel specialist who can assist with a task in MS Excel I have an excel workbook that has a lot of formulas. As a result, it is taking a lot of time even when I add a row. I need someone who can fix this for me. Due to the urgency of the project, I need someone who can start as soon as possible. If this sounds like something you’d be capable of, please place your bid. Completion is required ASAP, so your immediate availability is key. Please apply only if you have handled a similar situation below. Also, to make sure that you have read this description, please start your proposal with the word "Bruno" Thank you.
I'm in urgent need of an experienced XML developer to create a robust API. The API will primarily fetch data from an X20 device and represent it on an NMS. Key API Functions: • Data Retrieval: Capable of efficiently retrieving Device status, Network traffic data, and System logs from X20 device. Skills & Experience: Utilizing XML for data retrieval and transformation, the developer should also have a deep understanding of interfacing such APIs with diverse device types, primarily X20. Please, only professionals with proven experience with XML APIs should bid. I'm looking forward to a smooth, effective collaboration.
Repost of the following project: https://www.freelancer.com/projects/excel/transform-text-evaluable-format. The required files will be exchanged after nomination.
