Excel write file xml vba jobs

Looking for a freelancer experienced in Excel and VBA to develop a tool that automates the creation of Sorare teams based on data from three sheets: "Sorare Bot," "Classifications," and "GW." The tool should: Generate valid 5-player teams for competitions following specific rules (positions, exclusions, etc.). Organize teams into blocks categorized by competition. Create a list of unused players with exclusion reasons. Include a button to update the "GW" sheet whenever the other sheets are modified. Skills Required: Advanced Excel and VBA expertise. Data processing and automation. Attention to detail for applying prioritization and exclusion rules.

...Modeling Create the main assembly in 3D CAD software (SolidWorks, Fusion 360, or similar). Include major components: engine block placeholder, gearbox, clutch (if applicable), differential, chassis frame, wheels. Refinement of Layout Check for clearances, ergonomics (operator seat position), and weight distribution. Make adjustments based on feedback. Deliverables (Milestone 2) 3D CAD Assembly File (native format) with all major components. Exploded View Renderings (JPG/PNG/PDF) of the assembly from various angles. A short Design Progress Report highlighting any open questions or issues. Phase 3: Engineering Analysis & Finalization Mechanical Calculations & Stress Analysis Perform basic load/stress calculations on critical parts (e.g., frame, axles). Ensure...

I'm seeking a skilled software developer to create a tailored softw...Letter, Acceptance Letter, Engagement Letter, Management Representation Letter, NOC of previous auditor, Staff KYC, Etc. - Robust reporting and analytics capabilities - Automation of email notifications, data entry, scheduling, and other statutory records Integration: - Seamless integration with Excel sheets for reporting and analytics Ideal Skills & Experience: - Proficient in software development with a focus on analytics - Experience with task automation software - Strong understanding of Excel and data integration - Excellent communication skills for understanding office needs This project will significantly enhance our office efficiency and data management, making it a crucial investment fo...

Please Sign Up or Login to see details.

I'm in need of a proficient MS Excel professional who can assist me with complex formulas and functions, as well as creating charts and visuals. The primary goal of these tasks is to aid in financial modeling using sales data. Key Responsibilities: - Apply complex Excel formulas and functions for financial modeling. - Create detailed and informative charts and visuals based on sales data. Ideal Skills: - Advanced expertise in MS Excel. - Proficient in financial modeling and data interpretation. - Capable of creating professional charts and visuals.

I require an expert in Java or Python to develop a utility capable of mapping fields from XML to JSON. The utility will specifically handle metadata information, so understanding and processing this type of data is crucial. Key processing requirements include: - Handling authoring and development attribute details - Mapping contributor names and roles - Identifying and processing attributes - Tracking code versions Ideal candidates for this project should have: - Extensive experience in Java/Python - Strong understanding of XML and JSON - Previous experience with similar utility development - Able to handle complex metadata processing.

...must specify the location it pertains to, ensuring that users receive relevant information. - **User Customization:** While the initial focus is on the specified weather conditions, the system should be adaptable to incorporate other weather phenomena in the future. - **User Customization:** Needs to be used in OBS. Looking to do scrolling text. **Ideal Skills and Experience:** - Proficiency in XML and RSS feed creation and management. - Previous experience with weather data APIs and understanding how to integrate them effectively. - Ability to implement location-based functionalities within the RSS feed. - Strong attention to detail to ensure accuracy of weather alerts and location information. - A portfolio demonstrating previous projects involving data feeds, API integration...

Generate Leads of driving Schools in USA Deliver in Excel Sheet

I need an Excel expert who can help me analyze our sales data and identify trends. The main objective is to leverage Excel formulas and tools for data analysis. I have a considerable amount of sales data that needs to be examined. The ideal candidate for this project should be proficient in Excel, with a strong background in data analysis. Experience with analyzing sales data specifically will be a plus. Key tasks will include: - Utilizing Excel's advanced features for data analysis - Identifying and interpreting trends within the sales data - Providing clear, concise insights based on the analysis Please bid if you can help me find trends in my sales data using Excel.

I'm looking for an Excel expert to create an energy dashboard for me. The dashboard will need to display: - Electricity consumption - Renewable energy production - Water consumption - BTU consumption The data will be sourced from CSV files, and I would like the visualizations to consist of line charts. Ideal skills and experience for this job include: - Proficiency in Excel, particularly with data visualization - Experience in creating dashboards - Ability to work with CSV files - Understanding of energy data would be advantageous

I'm looking for a professional to create a Gantt Chart in Excel for our project. The chart should include all project milestones, and be formatted using our company branding colors. Ideal Skills: - Proficiency in Excel - Experience with project management tools - Attention to detail Please note, the level of detail for task descriptions hasn't been specified yet, so some flexibility may be required.

I need a modern styled Excel spreadsheet quote template. The template should incorporate: - My company name - My company logo - My company stamp The design should be sleek and professional, in line with a contemporary business aesthetic. The ideal freelancer for this project will have strong skills in Excel and graphic design, with a keen understanding of modern design principles.

Data from pdf or word files to system software

Payment for 2nd logo!

Features 1. File Upload and Storage • Automatic saving of email attachments. • File upload functionality available on the website. • Uploaded files are stored on the server, categorized by customers. 2. File Analysis • Extract data from saved files using OCR and GPT. • Extracted data is stored and categorized in the database by customers. 3. Data Editing (Grid-based) • Data Grid: • Display data in a spreadsheet-like format. • Includes filtering and search functionality. • Editable Cells: • Customer data and analysis results can be edited in real-time. • Edit Logs: • Automatically save all modification history. • Logs include data before and after modification, along with timestamps. 4. Excel/CSV Ex...

...Responsibilities: Upload new products to the seller account. Create replenishment shipments as needed. Analyze return reasons and determine necessary actions to prevent future returns. Dispute returns with Takealot if they are a result of a Takealot error. Compare shipment sent items with purchase invoices to ensure accuracy. Requirements: Basic proficiency in English and Urdu is mandatory. Familiarity with Excel is important. Previous experience with e-commerce platforms such as , Amazon, or similar is a plus but not required. A willingness to find and watch instructional YouTube videos to enhance learning about e-commerce practices. Additional Notes: You will be granted access to my PC via TeamViewer to explore the seller portal and learn. We are looking for individuals wh...

I'm looking for an experienced Excel user to assist with creating a formula that sums a range of cells based on text matching criteria. Key Requirements: - Proficient in Excel with a strong understanding of creating and modifying formulas - Experience with conditional summing based on specific criteria - Ability to interpret and implement text matching criteria for the sum If you have the exemplary skills and experience for this task, please place your bid.

I'm looking for a skilled Excel expert to create formulas for data analysis. The focus will be on descriptive statistics, specifically calculating the mean and median from my dataset. Ideal skills for the project: - Advanced Excel knowledge - Data analysis expertise - Familiarity with descriptive statistics

I'm seeking brilliant minds for a thrilling task that tests intelligence and problem-solving abilities to the max! If you are an analytical thinker with exceptional cognitive skills and a strong desire to succeed, this is your chance. Your task will be to excel in Cognitive Aptitude Analysis, demonstrating your reasoning and critical thinking abilities; proving your Mathematics Mastery through complex numerical challenges; showcasing your English Proficiency with advanced comprehension and communication skills; and leveraging AI & Machine Learning in Education to transform contemporary learning strategies. - Task: Completing a trial exam + five challenging online exams in Mathematics and English - Difficulty: Questions rated 10/10 - Time: Extremely limited - Integrity: Che...

I'm looking for a freelancer who can assist me with my sales data. The tasks primarily involve data entry, data cleaning, and data analysis. The dataset is relatively small, with less than 1,000 rows. Ideal skills for this project: - Proficient in Microsoft Excel - Experience in data entry - Strong data cleaning skills - Capable of performing data analysis Please bid if you have the required skills and experience. Thank you!

1). I have a trading backtesting software, wherein I need to change n number of parameters for different instruments and different trade times and run the bac...software, wherein I need to change n number of parameters for different instruments and different trade times and run the backtest. 2). Any parameter if I need to change, I spend lot of time in changing those parameters for all; quite a repetitive task. 3). It would have been great if the whole portfolio could be exported in excel format, so that changes could be done via batch edit much faster and imported back. 4). Unfortunately presently export import is via some port file, which is encoded/encrypted and can't be read or batch edited. Requesting any developer to help with this and also some additional feat...

...functionality (add/edit/delete users) - CSV file upload for customer record updates, replacing existing data User Interface: - Secure login system - Spreadsheet (table) style display of customer data - Search functionality by: account number, last name, or service address (partial or full matches) Style: - Professional, streamlined interface with a focus on readability - Color-coded search results for quick identification - Design with optimized layouts for desktop / laptop use Files Provided 'Customer ' - This is the export from our ERP. - File will be uploaded to the app you develop weekly by our staff. - New data will replace old data (removing any data not overwritten by new file). 'THCSD Customer Account ' - This is an excel base...

I have an STL file for a 3D print and I need a latch to be moved 1mm up, maybe 2, we have to check after printing it. See attached picture. That's it! I do not have a STEP file, only the STL.

i have the excel file you need to analyse the data and I want to you create advanced PowerPoint presentation presentation it need to be present to the big forums, primarily aimed to the top management. The presentation should reflect a professional and corporate style, with clear, concise content and well-structured slides. Ideal Skills and Experience: - Proficiency in PowerPoint - Experience in designing corporate presentations - Excellent understanding of corporate language and presentation etiquette - Ability to condense complex information into clear, digestible content - Creative approach to maintaining viewer engagement within a professional context.

...press environment, I offer the following services: - Typing and document formatting using Microsoft Word - Data organization and spreadsheet creation in Microsoft Excel - Desktop publishing with Adobe PageMaker - Image editing and design with Adobe Photoshop I am dedicated, detail-oriented, and committed to delivering high-quality work that meets your specific needs. Ideal projects would involve typing, document creation and formatting, spreadsheet management, desktop publishing, or image editing. Skills and Experience: - Fluent in English with excellent typing speed (40 WPM) - Profound knowledge of Microsoft Office Suite (Word, Excel) - Proficient with Adobe PageMaker and Photoshop - A proven track record of 10 years in computer work related to printing press operation...

The project involves creating a mobile application for both Android and iOS platforms. The primary function of this app is to enable users to capture multiple photos in a single session, tag them with product SKU and quantity, and subsequently export this data into Excel and PDF formats. The app should also support date-wise search functionality to track the captured data over time. Key features include: - A user-friendly interface for capturing and tagging photos - Seamless integration with Excel and PDF for data export - Date-wise search capability Ideal candidates for this project should have: - Previous experience in mobile application development, particularly for Android and iOS - A strong understanding of data export functionalities - Excellent UI/UX design skills...

I need a master Excel spreadsheet designed and populated with data from financial documents I will provide. This will include a master page produced from all the data on the separate tabs. - Data Types: The project primarily involves working with financial data, specifically tracking revenue and expenses. - Update Frequency: The data will need to be updated monthly. Ideal skills for this job include advanced Excel proficiency, experience with financial data, and the ability to create clear and comprehensive master spreadsheets. Please provide examples of similar projects you've completed in the past. Each sheet will total and feed into the master page. I would like reports ideally that can be run on total expenses or revenue in a time period as well as ratios to be ...

I'm seeking an expert excel/vba programmer. I'm using an existing vba macro excel program that needs to be upgraded. It was created to automate the process of building a single inventory list from multiple vendors feeds. The website is now using the Shopify platform and requires data to be imported into different column names and for more columns added. Summary of work required: 1. Need to change the import process to a single form, where feed can be added, vendor profile selected, map file column names to names in the program, save profile and import feed. 2. Adjust Export functionality to use similar template with different columns for different export options. 3. Data in compiled list needs to be read only unless enabled for in-line ed...

I'm looking for a freelancer who can assist me with my sales data. The tasks primarily involve data entry, data cleaning, and data analysis. The dataset is relatively small, with less than 1,000 rows. Ideal skills for this project: - Proficient in Microsoft Excel - Experience in data entry - Strong data cleaning skills - Capable of performing data analysis Please bid if you have the required skills and experience. Thank you!

Budget $25 I'm looking for a Python expert who can write a script for me. The script will open a list of URLs from an Excel spreadsheet and check for specific content. Requirements: - The script needs to check for text on the URLs. - If the content exists, it should create a new column in the spreadsheet with the status of each URL. Skills required: - Proficiency in Python programming. - Experience with working on Excel files. - Knowledge in web scraping techniques. - Ability to understand and implement URL content checking. Please only apply if you can demonstrate your ability to complete this task successfully -

I'm seeking assistance in extracting numerical data from individual stock pages on a website and storing it in an Excel file in a specific format for multiple stocks. This needs to be done monthly. - Data Points: The data points to be extracted include various metrics like annual sales, operating profit margin (OPM), net profit, and others. - Excel Formatting: The extracted data needs to be stored in a particular format in Excel. Ideal Skills: - Proficiency in Excel - Experience with web data extraction - Attention to detail to ensure data is accurately captured and formatted. Please note, I need this to be set up for monthly updates.

Python Developer: Screenshot Cropping & OCR to Excel Description: Seeking a Python developer to automate data extraction from screenshots with two key tasks: Screenshot Cropping: Crop images to isolate data below column headers. Handle minor variations across screenshots. OCR & Excel Conversion: Use OCR (e.g., Tesseract) to extract text from cropped areas. Save data to Excel in structured columns. Requirements: Proficient in Python (Pillow, OpenCV, pytesseract). Experience with OCR and Excel handling (openpyxl, pandas). Strong problem-solving skills and attention to detail. Deliverables: Scripts for cropping and OCR-to-Excel conversion, reusable and future-proof. Notes: Focused on screenshots only—no web scraping (e.g., Selenium). Prov...

I need a comprehensive, user-friendly sales report spreadsheet designed for monthly data tracking. Key Data: - Revenue: The primary focus of the report - Sales Rep Tracking: This includes new business, contract renewals, and lost business Re...The primary focus of the report - Sales Rep Tracking: This includes new business, contract renewals, and lost business Required Functionalities: - Automated Calculations: To reduce manual input and errors - Data Visualization: Charts and graphs to provide visual insights into the data - Summary Sheet: A separate sheet that auto-populates with a summary of all data Ideal Skills: - Proficiency in Excel or Google Sheets - Experience with sales reporting - Skills in data visualization and analytics I plan to update this spreadsheet on a mont...

I'm in need of an Administration Assistant with excellent document formatting skills. The primary task will be formatting policy documents to ensure they are consistent, aligned, and visually appealing. Key Requirements: - Proven experience with Microsoft Word and Excel. - Ability to work quickly without sacrificing quality. - Previous experience formatting policy documents is a plus. - Must provide government-issued photo ID and sign a Non-Disclosure Agreement (NDA). - Long-term work opportunity available for the right candidate. - No pay for work that is of poor quality Important Aspects of Formatting: - Consistent font styles and sizes - Use of headers and footers - Optimal spacing and alignment - Creation of 'beautiful' documents Aesthetic Elements Considered ...

- The data is easily selectable and copyable. - I want the final data saved to an Excel spreadsheet. - If possible, I would like the use of a VBA macro for ease of us

...tools such as SmartScout and Keepa (training provided if needed). Enter brand and product data into a basic spreadsheet with accuracy and consistency. Follow clear guidelines to meet weekly and monthly sourcing targets. Requirements: Familiarity with SmartScout and Keepa is a plus but not required; training will be provided. Strong attention to detail and accuracy in data entry. Basic knowledge of Excel or Google Sheets. Ability to work independently and meet deadlines. A positive attitude and willingness to learn new skills. What We Offer: Flexible working hours. Competitive pay structure. Weekly and monthly performance bonuses for meeting targets. Hands-on training and support to ensure your success. A straightforward workflow with no direct communication with suppliers or br...

1. Please fix the Stock Performance tab with Top 20 & Bottom 20. 2. Commodities & Chart_All_Commodities, I changed the commodity on a few of them including Antimony, Germanium, Gallium, Platinum & Niobium. This seems to work on the Commodities tab, but I have to manually update the Chart_All_Commodites Tab + others mentioned in Skype too, thanks

I'm looking for an expert who can transform my Excel sheet into a web-based calculator. The calculator needs to handle basic arithmetic operations like addition, subtraction, multiplication, and division. Key Features: - Data Input Options: The calculator should incorporate user-friendly data input options such as dropdowns and checkboxes. - Graphical Representation: A vital part of the project is the ability to visually represent results graphically. Ideal Skills: - Proficient in Excel and web development - Experience creating interactive web-based calculators - Ability to integrate graphical representations into a web platform Please provide examples of similar projects you have completed.

...need a professional to identify and correct any errors. Scope of Work: Review the entire Excel model for accuracy and logic in calculations. Verify key outputs (e.g., working capital changes, depreciation, FCF, OFCF and amortization schedules). Identify and fix formula errors, inconsistencies, or logical flaws. Provide a brief explanation of any changes made to help me understand the corrections. Expected Time Commitment: The work should take no more than 2-3 hours to complete for an experienced professional. Deadline: I need the edited version delivered within 6 hours of awarding the project. Please only bid if you can meet this deadline. Requirements: Expertise in financial modeling and Excel. Attention to detail and the ability to explain corrections clearly. Stron...

Hello, There is a website that has specific listings (around 1900) I need it extracted manually and then input in an Excel sheet (Number > price) I need the work to be finished in the next 2-3 hours max If you can start and finish it within the above time, type RED at the beginning of your proposal. A proposal without it will be ignored.

I'm seeking help with my introductory statistics homework, specifically focusing on data analysis and interpretation. The assignment has to have shown work in a word doc and excel sheet. I can show examples of this. Key Requirements: - Proficient in handling mixed data (both quantitative and qualitative) - Skilled in data analysis and interpretation - Strong understanding of introductory statistics principles Ideal Freelancers: - Have a solid background in statistics, particularly at the introductory level. - Experienced in analyzing mixed data sets. - Can provide clear explanations and guidance on data analysis techniques.

I'm seeking an expert to automate the process of extracting both text data and tabular data from a variety of PDF files into separate sheets in Excel corresponding to each PDF. The PDFs are inconsistent in their structure and layout, which adds a layer of complexity to the task. Key Requirements: - Can use excel, Adobe, Python Please provide examples of previous similar projects you have successfully completed.

... I need this converted into a file (best if it is a .txt file) where the first column is time broken into 10 s steps. The second column is the number of spikes during each 10 s epoch. The third column is the condition. My brute force idea is to do a loop counting spikes until the next 10 s limit is reached, then zero the count and start counting again. Be sure if two spikes are separated by more than 10 s that you save a 0 in each row without a spike. I forgot to mention that the two columns of data in Excel (Condition and Time) were originally in another spreadsheet (ClampFit Events) and I copied and pasted them into Excel. So you don’t have to read them from and Excel file. Instead you can just copy and paste them into a MatLab data ...

I need a script written for AutoCAD MEP that will automatically transfer data from my Excel spreadsheet to space properties. The data is in an XLSX file and includes room names, numbers, and HVAC specifications. Key requirements: - Proficiency in AutoCAD MEP - Scripting skills to automate data transfer - Experience in data integration from Excel - Ability to create a user-friendly script that can be run on AutoCAD MEP without extensive technical knowledge The ideal freelancer will have a strong understanding of AutoCAD MEP and its capabilities, as well as experience in scripting and data integration. They should be able to create a script that is easy to use and can be run on AutoCAD MEP without extensive technical knowledge.

I urgently need a skilled professional to create some bar charts for a business presentation. The charts need to be made using Excel and based on data from provided files. Ideal Skills: - Proficiency in Excel - Experience in creating professional-grade charts - Understanding of business presentation standards Key Requirements: - Ability to work on this task in the next 24 hours - Attention to detail - Ability to interpret data accurately from provided files

EXCEL Manufacturing Product scheduler/run time tracker We are developing a means to schedule components in an integrated excel spreadsheet that includes various production steps: (Functions) Laser, shear, punch, bend, paint, assembly, weld, assembly 2, shipping. To be save on a network-share point so all can access same document. The idea is to have a laptop at each station (listed above) 1a,1st step: Manual enter/copy paste-from engineering Initial step-Enter data (component part number(description)) into the first sequence, list all items from the project that needs to be produced. once entered, you can filter material gauges, material types in order to consolidate production run on the LASER. When running the selected items (check box) we track time to produce on lase...

i have understood completely sir i am start working after accepting this quote

I have an Excel sheet filled with survey data that I need analyzed and visualized with graphs. Key Requirements: - Analyze various aspects of the data including demographics, responses to multiple-choice questions, and open-ended responses. - Create visual representations of the data to illustrate different fields or columns. - Utilize both descriptive and comparative analysis techniques. Ideal Skills and Experience: - Proficiency in Excel and data analysis. - Experience with creating graphs and visual data representations. - Ability to interpret survey data and draw meaningful conclusions.

...skills to collect data from burger chains in Sweden, Norway, Denmark, and Finland. The task involves calling approximately 15 different restaurant brands in each country and asking specific questions about their bread/buns supply. Key Responsibilities: - Cold calling restaurant chains to collect data - Asking specific questions regarding their bread/buns supply - Compiling the information into an Excel spreadsheet Ideal Skills: - Proficient in cold calling - Sales experience - Telemarketing expertise - Strong data entry skills Experience in the food/foodservice industry, especially with restaurant chains, would be a plus. You will have a list of restaurant brands to call, and the data will focus primarily on the burger segment and any establishments using burger-type buns or...

I need some Excel spreadsheets and Word documents converted into editable PDFs. These PDFs are intended for client distribution and need to allow users to interact with them in specific ways. Key Requirements: - Conversion of Excel and Word files into editable PDFs - PDFs should allow users to fill out forms and edit text and data - Inclusion of specific form features such as drop-down menus, checkboxes, and fields for entering data - One form needs to have the capability to calculate totals Ideal Skills: - Proficiency in PDF creation and editing software - Experience with Excel and Word - Attention to detail to ensure all forms are accurately converted and functional - Ability to create interactive elements within PDFs