Excel write file xml vba jobs
More details: Do you want the Excel program to convert purchase orders and local stock into separate TXT files? Yes Should the program automatically detect and apply specific parameters for each conversion, or will you provide the parameters? Mix of both Which specific parameters do you need for the TXT conversion of purchase orders? Each order should be a TXT
I am looking for a proficient data analyst who can assist me in providing data analysis using Excel. Specific tasks include: I have two online retail catalogs that sells similar products as one another. Medline & CVS Health. Medline has 313 products listed and CVS Health has 892. I need a comparison chart in any format (Excel or Word) that addresses: 1.) how many brand name products are under Medline. List then out. 2.) how many brand name products are under CVS Health. List them out. 3.) how many Medline specific products are under Medline. List them out. 4.) how many CVS branded products are under CVS Health. List them out. 5.) Which products does CVS health have that Medline does not? (Ex: reading glasses) 6.) Which products does Medline have that CVS Healt...
I am looking for a skilled and experienced Excel expert to create a detailed and comprehensive Excel spreadsheet which will serve as a trucking business operational tracker. Key Information to Include: - Revenue: Primarily from freight charges. - Expenses: comprising of fuel, maintenance, office expenses and rent. - Profit Margins: Determine the profit margins by deducing expenses from revenue. - Mileage and Fuel Costs: Tracking to determine efficiency and cost-effectiveness. Frequency: - The ideal candidate should create a sheet easy to update on a daily basis. Ideal Skills & Experience: - Proficiency in Excel - Astute attention to detail - Experience with financial and operational data tracking - Knowledge or experience in the trucking industry would be a ...
I am in need of an expert in Excel to create a system for managing my financial and inventory operations. With your specialized skills, I require a streamlined and seamless workflow for my business that includes the following: Accounting: - Managing both income and expenses in a clear and concise manner Invoicing: - Capabilities to create invoices directly within the sheet - Functionality for generating these invoices in a PDF format - A reliable system to track invoice payments Inventory Management: - A method to effectively track stock levels - A simple way to generate purchase orders as needed - A solution for generating sales reports for analysis The freelancer best suited for this project would have an extensive background in Excel, with a special focus on financial ...
More details: What colors would you like to see in your logo design? Blue What feeling or message do you want your logo to convey? Trustworthiness Where will your logo primarily be used? Online (websites, social media), Printed materials (business cards, flyers), Product packaging
I'm in need of someone to import XML files into WooCommerce as variable products. The XML files contain product data, which needs to be accurately translated and displayed in my WooCommerce store. The ideal candidate would have: - Expertise in WooCommerce and XML - Proven experience with product data import, specifically for variable products No special functionalities are needed for the product listings. However, quality is crucial, so attention to detail is a must. Your job is to ensure all product listings are imported correctly and displayed as variable products, with no errors.
بالمرفقات أنا بحاجة إلى شخص يمكنه إجراء بعض العمليات البسيطة على ملف Excel الحالي الخاص بي. تشمل المهام ما يلي: - تنظيم البيانات وتصنيفها - إضافة الصيغ والحسابات - اجرائات اخرى
...the species observed. Sighting areas: The system allows users to record the sighting area where the different bird species have been observed. Data analysis: The system should allow users to analyze sightings data, generating graphs showing the frequency of sightings of different species in different geographic areas. Data export: The system allows exporting bird sighting data either in PDF or EXCEL files. Administration of users and permissions: The system allows the administration of users and access permissions, to ensure that only authorized users can access the information stored in the system. Bird sounds: The system has an API that displays the sounds of the birds that have been registered in the system. These requirements can be modified according to the client's n...
Hi Kelvin Writer, I noticed your profile and would like to offer you my project. We can discuss any details over chat.
I require assistance with 3D manipulation of an existing STL file. - Specific Tasks: Accurately remove specific parts of the model inside and out making the most space inside as possible. I require the following to be removed: 1, front splitter up to the body (see pictures) 2, rear spoiler and uprights and make good the body. 3, rear engine parts inside body but keeping the roof vent. 4, remove front grill and bonnet vent mesh and reduce the protrusion of the bonnet vents to 8.5mm max . 5, make the model body smooth ready for FDM 3D printing. Ideal candidate possesses proficiency in STL file modification and 3D design while demonstrating attention to detail. Experience with STL design geared towards automotive components is a notable plus.
I require immediate assistance for a web scraping into Excel task. This project focuses on the extraction of complete tables from different websites. Requirements: - Have expertise in web scraping and excel. - Be able to deliver completed work ASAP. Ideal Skills: - Proficiency in tools or programming languages for web scraping. - Strong command of Excel and data wrangling. - Demonstrated punctuality and adherence to deadlines. This is a time-sensitive task, requiring both speed and accuracy. Please, only serious and dedicated freelancers should consider this project. Job Description: There are 2 sets of tables, Soccer and Basketball for my analysis during my free time. 1. The links are in the spreadsheet highlighted in yellow. The script must also be easy to un...
I need help developing a risk assessment in Excel for my clients. I had one developed for an Ergonomics assessment, now I need to amend this to include additional fields and scoring for Quickchangeover (QC). I need an expert to create a new worksheet, formulas, macros, etc. Review the attached Ergo assessment so you can see what was developed previously and what I need (directionally) the QC assessment to move toward. Are you interested? Read the ReadMe file and look at the docs. thank you.
I'm in need of an expert in Excel to create a spreadsheet that will automate data entry, perform calculations, and generate reports. The complexity isn't clear yet, as I'm unsure how many different tasks will need to be automated. The suitable candidate should have: - Proficiency in Excel, including advanced features - Experience with automation within Excel - A good understanding of data entry, calculations, and report generation I'm open to a dialogue to specify the details further. On the first tab in Excel, I'd like to have all the individual contributors. Then have a tab after that for each individual to show their trends over the months. Anything over 95 is considered good and below 95 would be not good. There are 15 contributo...
There is an excel file to modify according special rules
Expert in ...existing spreadsheets / excel csv files. - Data scrape images from external websites, and copy url to match the google spreadsheet lines - Download mass URL of these images into a separate accessible folder for future management. Potentially around 50,000 lines of data to manage and enter. Ideal Skills: - Google Spreadsheets - Data Organization - Image uploading and management - Web form integration - Excel We will provide as much data as possible. your job is to enter it in. Most of the database is in English, some of the entry is in Japanese. some example of websites we will work with; https://docs.google.com/spreadsheets/d/1iNPQ4Jt2-EFgkaD91vl7e87Se-xG_kSA/edit#gid=185003365 Data from these, need to be joined with another file.
...harness the power of Azure Databricks, Azure Data Lake Storage, Copilot, and Azure Data Factory. This project will also use Azure Kubernetes to ensure that the analytics processes are scalable. The main goal is to augment our standard business processes and make them more effective by leveraging these technologies. The data to be analyzed is structured and originates from various sources like Excel, CSV, SQL, etc. Ideal skills for this project include: - Proficient in AI analytics with a solid understanding of data analysis, predictive modeling, and natural language processing. - Experience with Azure Databricks, Azure Data Factory, and Azure Data Lake storage. - Knowledge and experience in working with structured data. - Familiarity with ML and the Copilot tool. - Experience...
More details: What type of data do you need to convert? Text data What is the desired output format for the converted text data? Excel spreadsheet Do you require any specific data manipulation or analysis within the Excel spreadsheet? Data sorting and filtering
I have an Excel sheet that contains text data and I need it to be parsed. I am looking for a Python expert who can use pandas to extract the text data and present it neatly in a new Excel sheet. Key requirements: - Extracting text data from an Excel sheet using Python pandas - Presenting the extracted text data in a new Excel sheet - Sorting and filtering the extracted text data as per business requirements Ideal Skills: - Excellent knowledge of Python, especially pandas - Proficiency in working with Excel sheets - Experience in sorting and filtering text data - Strong attention to detail and commitment to quality
I am seeking an experienced and creative fashion designer who specializes in men's clothing, specifically focused on trendy casual wear. Your responsibilities and qualifications would ideally inclu...Excellent verbal and visual communication skills to effectively convey design concepts and ideas. 8. Time Management: Capable of working under tight deadlines and managing multiple projects simultaneously. 9. Fashion Education: A degree or diploma in fashion design or a related field is preferred, but not mandatory. 10. Passion for Fashion: A genuine passion for fashion and a drive to innovate and excel in the industry. Please apply with your resume, portfolio, and a cover letter highlighting your relevant experience and why you would be a great fit for Verve Clothing's bot...
...budget for the upcoming year. This will encompass the following elements: Key Requirements: - Extract and organise data from a PDF P&L statement - Formulate an Excel-based budget plan for the upcoming year including Revenue, Expenditure, and Cost of Goods Sold - Base projection data on the historical records from the P&L statement - Breakdown of expenditure must be category-wise - Incorporation of a pie chart visualising the budget details Considering the urgency of this project, I require the final product within the next 12 hours. Ideal Skills: - Excellent understanding of financial document analysis - Proficiency in using Excel including complex formulas, calculations and data visualisation - Proven ability in formulating budget plans - Exceptional attent...
I need a data entry specialist to compile an Excel spreadsheet database of addresses and opening times relating to approximately 400 branches of the Citizens Advice Bureau. The data will be collected from URLs that I will provide. Ideal Skills and Experience: - Proficient in data entry and Excel - Experience with web research - Attention to detail - Ability to meet tight deadlines - Previous experience with similar projects is a plus This is an urgent project and I need it completed as soon as possible. Thank you.
I need editable forms created in Adobe XML that can be opened in Adobe Acrobat for data entry. Key Requirements: - Data validations, including required fields and numeric format validation - Drop downs, radio buttons and creation of bar codes post submission Ideal Skills: - Proficiency in Adobe XML and Adobe Acrobat - Experience in creating interactive forms - Attention to detail for validation requirements - Prior experience with barcode creation in forms is a plus
...of applications through appealing visual design Develop and manage well-functioning databases and applications Write and document effective APIs Test software to ensure responsiveness and efficiency Troubleshoot, debug and upgrade software Create security and data protection settings Build features and applications with a mobile responsive design Write technical documentation Work with data scientists and analysts to improve software Requirements: Proven experience as a Full Stack Developer or similar role Experience developing desktop and mobile applications Familiarity with common stacks Knowledge of multiple front-end languages and libraries (e.g. HTML/ CSS, React, Node.js, XML, jQuery) Knowledge of multiple back-end languages (e.g. Python) Familiarity with datab...
The work consists of: 1- extract the information from a calendar as the one I put as an example (can be another one) 2- Download the information to excel and using chatgpt for excel modify the description of each fair so that the content is original (we will give access to the plugin for excel with enough credits and chatgpt 4). 3- by means of chatgpt for excel modify the date format 4- include a no follow link to the fair in question. 5- (very important) check that Chatgpt does not make mistakes in the description or dates (this happens very often) We will not release the milestone if we see mistakes. 5- Create a dynamic calendar for wordpress that removes the old dates and leave only the content from the
I am looking for an experienced designer who can create a small, floral-themed relief artwork to be engraved on a marble tray using CNC software. Key project specifics are: * Design should be small in size. * Artwork should be based on a floral theme. * The design should be sourced 'from the internet', yet be unique and of good quality...floral theme. * The design should be sourced 'from the internet', yet be unique and of good quality to ensure precise CNC execution. The perfect candidate will have experience in relief style artwork, CNC design, and an understanding of marble engraving. Familiarity with floral designs is a plus. I anticipate your creativity and unique interpretation for this project. ---- I already have the .stl file for the marble tray, I ...
I'm in need of a skilled professional who can help me showcase live game data directly from an Excel spreadsheet on my WordPress website. Key Requirements: - Real-time data update: The data should be updated on the website as soon as changes are made in the Excel file. Ideal Skills: - Proficient in Excel: The freelancer should be well-versed in Excel in order to effectively parse and represent the data in a user-friendly manner. - WordPress Expertise: A solid understanding of WordPress is essential to ensure the data is displayed correctly on the website. - Experience with Real-time Data: Previous experience in displaying real-time data is a huge advantage. I don't have a specific plugin in mind for this task, so I'm open to suggestions...
I’m in search of a skilled API developer who can create a feature-rich PubMed API for a healthcare application I'm working on. The initial MVP is SaaS with advertising for the health consumer market. The ideal candidate will possess: - Expertise in API development - Experience with PubMed or similar platforms - Proficiency in JSON and XML for data format - Experience with Node/Edge Graph display for visual navigation This project is an implementation of Araicom's Associative Relevancy and other patents for knowledge domain frameworks and Perspectives for visualization, navigation, and curation of users, instances, and group networking. Specifically, I need the API to allow: - Search functionality - Retrieval of article metadata - Access to full-text a...
I require the skills of an audio professional who is adept at using Audacity. The task is to amplify the audio of a faint 14-minute M4A file, to a level where the speech can be understood clearly. The desired outcome will be high-quality audio with minimal background noise. Key requirements are: - Excellent understanding of Audacity software for audio amplification - Skill in volume amplification without distorting the audio - Experience in generating high-quality output with minimal background noise - Please note that the emphasis is on volume amplification over preservation of original tone With your expertise and attention to detail, we can make this whisper-talk audible and clear.
...track of your job is remote, and you will need a quality internet connection. Representing tinyB with politeness, professionalism and a sense of excitement Following up with and closing sales inquiries, quotes, and basic sales service as it pertains to business orders and events. Take accurate notes of your interactions Manage your time between cold calls and follow ups Work with Excel and Google Sheets Provide feedback to management and maintain the database according to the company’s guidelines WHO YOU ARE Honest and trustworthy Positive, energetic, and influential relationship builder Detail oriented Respectful and take pride in your responsibility Keen learner & self- motivated EXPERIENCE REQUIRED Minimum of 3 years of sales experience EMPLOYMENT This...
...options trading system implemented through an Excel sheet. This tool will execute real-time data trade operations, following a specific strategy. Ideal Skills and Experience: - Proficient in Python programming - Experience in Stock Market trading systems - Knowledge of Excel VBA and integrating with Python - Understanding of Custom Trading View Indicator strategy The work involves: - Engaging in the end-to-end development of the Excel system. - Coding a Python script to fetch and populate real-time trading data. - Implementing the Custom Trading View Indicator strategy in the Python script. - Testing the system to ensure the accuracy and efficiency of the trading. Please note, I don't have an existing Excel sheet for this trading system. Th...
I am in need of a freelancer well-acquainted with data entry for translating text data into a usable Excel spreadsheeet. Key Requirements: - Proficiency in text data entry - Experience working with a diverse range of project types - Skilled in Excel, especially formatting and data organization Your task will be to translate the original data (which could be a PDF file, printed hardcopies, handwritten notes, or a different format depending on the project) into neat, easy-to-read Excel spreadsheets. Prior experience with Excel and other similar tasks will be crucial for completing this project accurately and efficiently.
I'm in need of a professional proficient in Excel macros to assist with creating custom formulas specifically for data manipulation. The primary task would be to formulate macros that can effectively merge and separate data. Demonstrable experience in managing large datasets and solid knowledge in automated data manipulation will be essential for successful completion of the project. A background in eliminating duplications or inconsistencies would also be advantageous. I look forward to a hassle-free process and accurate results.
I am trying to fetch ebay api token. Code works in php but not in vba
I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!
...PDF creation, PowerPoint design, Excel data management, AI integration, translation services, and gaming-related tasks. Specifically, the tasks will include: - Blog writing: The primary purpose of the content is to share information with the general public. The ideal candidate will be able to write engaging, informative blog posts that are accessible to a wide audience. - Editing: The candidate will be responsible for ensuring that all content is well-written, error-free, and adheres to the project guidelines. - PDF creation: The candidate will need to create professional, visually appealing PDF documents. - PowerPoint design: The candidate will be responsible for designing PowerPoint presentations that are engaging, informative, and visually appealing. - Excel dat...
I've got a 14-minute audio file in the M4A format that is incredibly faint – almost like someone whispering. The task I need completed involves amplifying this recording enough that I can discern what's being said. The whole recording requires this enhancement, so your solution needs to be comprehensive, making the entire clip clearly audible. Notably, there's no noticeable background noise to be worried about, just the issue of the main audio being too soft. Ideal candidates for this project should have: - Strong skills with audio editing and enhancement - Experience working with M4A files - Expertise in noise reduction and audio clarity improvement Your task will be to achieve a clear and loud enough audio recording by applying your audio enhancement ski...
I'm seeking a professional with extensive Excel experience who can help convert data from a spreadsheet into a more user-friendly form. Here are the key elements for this project: - Autofilling: The form should make use of specific criteria for autofilling using text. Your proficiency in creating autofill functionality is crucial. - Conditional Formatting: I require a unique approach to formatting cells containing more than one line of text. Specifically, if a cell has multiple line items, they should be combined in the same cell but placed underneath each other. - File Format: The data to be converted resides in an Excel spreadsheet, therefore your familiarity with Excel is paramount. This task requires not only technical skills in Excel but als...
...opening a Quickbooks file that was saved in 2009. The file contains important financial data which I urgently need to access. I am currently using Reckon Accounts 2013 Pro and did not keep the earlier versions of the Quicken software. Based in Australia, I have evidence that I own the company who owns the Quickbook file and the software registration details. What I don't have is knowledge of the specific password that I used for the file at the time. I have a list of 35 passwords that I was using for various tech systems around 2009. One of which is likely to open it or as a professional you may know a different way to access the data. In addition to a Reckon Accounts 2013 Pro file of the data I can use, at minimum I need from you an Micros...
I am in need of an experienced data entry specialist who can assist me with entering basic data into Excel. The data to be entered will be from handwritten notes. Ideal skills and experience for the job: - Proficient in Excel for basic data entry and formatting - Detail-oriented with high accuracy in entering data - Ability to work with handwritten notes - Good communication skills to clarify data points if needed
...with WooCommerce. This plugin must interface with three travel agency operators using an XML API. It should include a daily cron job set for a specific time to update travel packages, fully integrated with WooCommerce. This ensures that when a travel purchase is made, it verifies availability with the operator’s API before proceeding with the purchase. The plugin will manage travel packages from the backoffice but also needs to support a shortcode for frontend implementation, displaying a search and filters along with a listing. A similar plugin can be found at However, my requirement is slightly different, as it must utilize the operator’s XML API and confirm the package's availability with the operator before purchase, all while
I'm in need of someone adept in bookkeeping, expense tracking, and financial reporting. You don't have to have experience in a specific software, but being proficient in tools like QuickBooks, Excel, and Xero would be ideal. I need the Account Assistant to handle: - Bookkeeping - Expense Tracking - Financial Reporting In your proposal, please include: - Details of your past work and experience in similar roles - A detailed project proposal outlining how you'll carry out the tasks I'm excited to hear from you, and start working together on this project.
I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!
I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!
I am in search of a seasoned data analyst who will perform a comprehensive analysis on a large Excel dataset, with more than 10,000 rows. The range of tasks to be undertaken includes: - Data Cleaning: Ensuring the data quality, eliminating any errors or redundancies. - Data Visualization: Creating intuitive charts and graphs to illustrate the data trends and patterns. - Statistical Analysis: Implementing statistical methods like Regression Analysis, Time Series Analysis, and Hypothesis Testing to interpret the data and draw conclusions. This demands a great deal of experience in Excel, data cleaning, statistical analysis, as well as in working with large datasets. A solid understanding of regression analysis, time series analysis, and hypothesis testing is strongly requir...
I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!
I'm seeking a Visual Basic for Applications (VBA) professional who can proficiently navigate through Microsoft Visio 2016. The core task involves developing custom shapes and stencils, but the complexity level of these shapes and stencils is yet to be determined. Skills & Experience: - Proficiency in Microsoft Visio 2016 - Strong knowledge of VBA - Experience creating custom shapes and stencils Potential candidates should showcase their ability to work with ambiguous project requirements. Your proposal should include examples of complex shapes and stencils you've created in the past, along with how you approached achieving the final result. I look forward to your applications!
I require an expert in Excel macros that can help me with a specific task. I have numerous .dl files from which I need certain sections of text extracted. Here's what I need: - Development of a reliable Excel macro that can accurately identify and extract the necessary data from .dl files. - The macro should be robust enough to handle any inconsistencies or errors within the .dl files. In the event of an issue, rather than stopping entirely or skipping the file, the macro should create a log file noting the inconsistency or error for later review. Ideal skills: - Experience in Excel macro development - Familiarity with .dl file structure - Attention to detail - Problem-solving skills, particularly regarding file inconsistencies or...
Hello, 1: you will create aspx webpage, and load data from mssql table to gridview with paging. 2: when user check some checkboxes, and enter value in textboxes and click on a button, it will store those values in session and save in database table. 3: when user enter some values in page 1 or anyother page and go to next page like page#2 and come back to page#1, the values he entered must...and save in database table. 3: when user enter some values in page 1 or anyother page and go to next page like page#2 and come back to page#1, the values he entered must show and not loss. Note: has the gridlayout. ischecked and grosspremium are editable checkbox and textbox I included the vb code as well in endorsements-vb The datasource contains 86 rows and attached as excel.
