Excel file xml file automatically vba jobs
I need an Excel expert based in India to update our sales data with the following fields: - Sale Date - Customer Name - Address - Product - Product Description - Product Quantity The work involves transferring this information accurately from CSV files into the appropriate format in an Excel sheet.
You give me a standalone C# solution, which can 1. Read all image files (JPG) in a file folder, 2. Extract text (Chinese Simplified) and save to a doc file in the same file folder, 3. Name the doc file the same as the image file. You can get a hint here: Sample Input and sample output are given in attached files. Steps: 1. You work on your own. 2. When you are ready, I send you an image file, you send me back the generated doc file in 2 minutes. 3. If the quality is fine, you send me code, and I test on my computer. If everything is good, I will pay you.
...interactions within a session. • Can retrieve past data (e.g., user preferences, order history). 1.4 Predefined & AI-Generated Responses • Combination of scripted responses (FAQs) and AI-generated replies. • Allows businesses to customize responses based on their needs. 1.5 Multi-Language Support • Supports multiple languages using translation APIs. • AI should detect and switch languages automatically. 1.6 Voice & Text Input Support • Text-based chat. • Voice input/output (optional). • Text-to-Speech (TTS) and Speech-to-Text (STT) integration for voice chatbots. 1.7 Live Chat Handoff • Transfers conversation to a human agent when needed. • Seamless escalation without user frustration. 1.8 Database & CRM...
...Develop and deliver comprehensive reports and interactive dashboards. Data Sources: The dashboard will need to pull data from a variety of sources, including: - Excel files - Tenica - HubSpot - BCI - PDF - CRM Database - Workflow - POAP/Project on a page/XL Integration Requirements: The following data sources need to be integrated into the Power BI dashboard: - Excel files - HubSpot - CRM Database Skills and Experience: - Proven experience with Power BI is a must. - Data visualization and analysis skills are crucial. - Prior experience integrating various data sources into Power BI is highly preferred. - Proficiency in handling Excel files, HubSpot, and CRM databases. - Strong understanding of finance and sales data will be an added advantage. Please provide exa...
I need a 600-page pdf written in Microsoft Excel for record-keeping, specifically for inventory data. The document must include: - Item names and quantities No formulas or complex Excel functions are required. This project is ideal for freelancers with excellent attention to detail and experience in data entry and inventory management.
I'm in need of a reliable and efficient data scraper who can pull order details from...and efficient data scraper who can pull order details from my Aliexpress account into an Excel file. The scraper should allow me to manually set a date range for the data I want to extract. -Data Requirements: I will provide a template for the data. - Frequency of Task: I would like the scraper to be user-friendly enough so that I can set a start and end date for future data scraping tasks each time I run the scrapper. Ideal skills for this project include experience with web scraping, familiarity with Aliexpress, and proficiency in Excel. A good understanding of data handling and the ability to create a user-friendly interface will be an added advantage. I have attached ...
I need assistance in updating a Word document with data from an Excel list. The data needs to be inserted inline with the text and formatted as plain text. Ideal Skills: - Proficiency in Microsoft Word and Excel - Strong attention to detail - Excellent data handling and formatting skills
...with your final price, no changes in bid will be done at later time. SharePoint Online: Create Employee Directory Info should be extracted from Active Directory plus some additional fields as needed such as Date of Birth, Date of joining, anniversary date etc. (should mimic existing directory) should have search functionality and some sorting functionality Employee Directory should update automatically when new users has been added or removed I'm looking to create an employee directory on SharePoint Online, based on our existing one. Key Requirements: - The directory should include each employee's name and job title, contact details, department, and location. - The layout of the new directory must replicate the existing one exactly. - The project should leverage Pow...
Please Sign Up or Login to see details.
I need a VBA script for Microsoft Word that will help me remove highlights from bullets and the space after in bulleted paragraph lists. The script should be manually executable by clicking a button. Ideal skills and experience for the job: - Proficiency in VBA (Visual Basic for Applications) - Strong understanding of Microsoft Word functionality - Prior experience creating Word scripts - Ability to write clear, user-friendly code Please note: The specific version of Microsoft Word this script will be used on has not been determined yet, so the script should be compatible with Microsoft Word 2016, 2019, and 365.
My Excel sheet requires some urgent formatting adjustments to properly calculate and display the gross profit (GP) of items. Key Issues: - Formatting problems predominantly in the cells and tables Necessary Skills: - Advanced Excel expertise - Experience with data validation and conditional formatting - Attention to detail to ensure accurate GP calculations Your role will be to troubleshoot and rectify the formatting issues to ensure the sheet operates correctly and efficiently. Your expertise will allow for the implementation of necessary data validation and conditional formatting to improve the functionality of the sheet.
This looks like a very simple fix, but there will be more work later. Look here to see the device. The home page has a two minute video that will explain what we are doing. The Arduino controls four pumps using PWM by pressing any of 12 keys on a keypad. All "formulas" are timed to shut off automatically. We have added (and it works) the monitoring of BLE beacons so that the MAC address nearest the Platform is identified and the Platform sends a line similar to the following message to Serial Monitor #2502101,10991,5,ff:ff:11:4c:50:d1,99& Serial # of Platform time in seconds since Platform powered up + 10000 MAC address of nearest beacon (They all transmit address,"iTAG" there are 13 spaces behind iTAG, and signal strength That is all we need to det...
I need a straightforward travel calculator focused solely on air travel. This tool should be built in Excel and utilize a simple user form with concealed tables that house the necessary data sets. Key Features: - The calculator should handle only air travel. - It should factor in flight distance and also calculate frequent flyer points based on the journey. - The user input form needs to encompass departure and arrival locations, class of service, and booking class. Ideal Skills: - Proficiency in Excel, particularly in creating interactive user forms and concealed data tables. - Understanding of air travel metrics and frequent flyer point systems. - Ability to create a user-friendly, simple yet effective travel calculator.
... Example: If the targeted wallet buys $2,000 worth, the bot must execute a trade for $500 (or another specified amount). Percentage-Based Selling: The bot must sell based on the percentage of the targeted wallet’s sell transactions. Example: If I purchase $500 worth of a token and the targeted wallet later sells 50% of its holdings (e.g., $1,000 of a $2,000 trade), the bot should automatically sell 50% of my holdings (e.g., $250). Helius Subscription Integration: I have already purchased the $500 Helius subscription, which should be fully utilized for this project. From my understanding, no additional purchases will be necessary to achieve the required functionality. High Reliability: The bot must perform consistently and accurately under high-pressure...
I'm experiencing issues with my Excel. The Copy/Cut/Paste functions are disabled, and I need someone to troubleshoot and assist me with these functions. Ideal skills for this job would include: - Expert knowledge of Microsoft Excel - Troubleshooting skills - Data entry experience Please help me get my Excel functioning properly again. Thank you!
I'm looking for a freelancer to assist with data entry from spreadsheets into Microsoft Excel. The data is mixed, consisting of both text and numerical values. Ideal Skills and Experience: - Proficient in Microsoft Excel - Attention to detail - Experience with data entry from spreadsheets - Ability to handle mixed types of data (text and numerical)
I have several transactions that need to be compiled into a billing statement. You will receive: - Transaction details in an Excel/CSV format - A template to follow for the billing statement Your task: - Convert the transactions into a Word and PDF billing statement using the provided template - Include all details I provide, such as client details, billing period summary, and payment instructions Ideal skills: - Proficient in Excel - Experienced in Word and PDF document creation - Attention to detail to ensure all supplied information is accurately included
...subscribing to Sales Navigator (cost covered by me), researching through LinkedIn and the web to locate the Melbourne Office and headcount located in Melbourne and populating an Excel spreadsheet with relevant data. Key Responsibilities is to research Melbourne businesses and fill in the following: - Fill in the spreadsheet with the Melbourne office address - Fill the number of staff located in Melbourne (details provided) The workload is anticipated to be about 400 hours. The ideal candidate for this project should have: - Excellent research skills - Familiarity with LinkedIn and Sales Navigator - Proficiency in Excel - Ability to work independently and manage time effectively Please note the list will provide a link to the LinkedIn page which will make it quicker to...
...Within 10-20 Days Guaranteed. I will also increase your Domain Aurthority to 40+ once the backlinks are indexed(MONTH 2 domain rating and trust flow) ?2/. Manual Easy to understand SEO Audit report Website audit is a must it will narrow down to the exact issues and save you Audit includes ● XML Sitemap Errors ● Robots' Errors ● Spam Score Checking and more ?3/. Fix any SEO errors and/or optimize your site for backlinks My SEO > Meta Tag Creation > Header Tags > Page Speed Optimization > Creation of XML sitemap/indexing/Google search console> and more ?4/. Backlinks for keywords -Link Pyramid foundation links are the actual SEO methods for ranking websites in SERPs of Google. Pattern as an example: ▲ TIER-1: 200 Web 2.0 + Article Directories Su...
...portfolio performance over various time frames (24h, 7d, 1m, etc.), with charts showing asset growth. Transaction history for deposits, withdrawals, and trades should be easily accessible. Web Responsiveness Mobile-first design: The platform must be designed with mobile devices in mind first, ensuring optimal usability on smaller screens (smartphones/tablets). The UI should be adaptive, automatically resizing and adjusting for desktop, tablet, and mobile devices. Touch-optimized UI for mobile users to place orders, interact with charts, and manage their portfolios with ease. Customizable UI Users should be able to customize their dashboard layout (drag-and-drop widgets), choose the theme (light/dark mode), and set up price alerts. Allow for customizing charts, including di...
I need assistance with modifying two Excel files. The modifications include: 1. Separating headers into individual cells (e.g., Serial Number, Last Name, First Name, etc.). 2. Ensuring the header row is consistent across all pages. 3. Removing empty rows. 4. Deleting duplicate words while preserving the main data integrity. 5. Maintaining the serial number and data alignment. The headers follow a specific format, which is a combination of uppercase and lowercase letters. I can describe this format to you, but I will need your assistance to determine it in some cases.
I have three PDF drawings that need to be analyzed and converted into a Bill of Quantity (BOQ) in an Excel format. The scope of the project includes: Ideal candidates for this project should have a strong understanding of construction and engineering principles, experience in BOQ preparation, and proficiency in Excel. Attention to detail and the ability to accurately interpret engineering drawings are essential for success in this task. BOQ should include the following: construction electric electronic works mechanic earth works site works railway perimeter security civil/mechanical/electrical infrastructure The 3 PDF drawings to be downloaded are in the link below under ATT_13: ATT__13_Drawings_HN_COMBINED
I need assistance in organizing my credit card statements. The ideal freelancer would have experience in data consolidation and categorization. Key tasks include: - Consolidating credit card statements from the last 12 to 24 months - Organizing the statements by expense category - Delivering the final product as a well-structured Excel spreadsheet Skills required: - Proficiency in Excel - Data analysis and categorization - Attention to detail
I have created a voting system using HTML and JavaScript. I can save votes in local memory, but I need assistance to ensure votes are saved to a file correctly. Key Requirements: - Expertise in JavaScript and HTML - Experience with file handling in JavaScript - Problem-solving skills to identify and rectify mistakes in my code Your task would be to help me correct my current implementation so that votes are saved to a file whenever the form is saved, instead of being lost after the session ends. The current system saves votes in local memory, but I need your expertise to help me save them in a file instead.
I'm in need of a highly efficient trading bot tailored for the Cardano Network. This bot should be capable of executing trades across various decentralized exchanges (DEXes) such as Minswap, Splash, Dexhunter, Sundae Swap, and Snek Fun. Key Functionalities: - Automated Buying: The bot should automatically initiate purchases when certain conditions are met. - Buying & Selling: It should handle both sides of the trade seamlessly. - Price Monitoring & Alerts: The bot needs to track price changes constantly and alert me when necessary. Specific Trade Triggers: - Immediate Purchase upon Liquidity Pool (LP) Addition: The bot should execute a buy order as soon as a new LP is introduced. - Policy ID-Based Buying: The bot should be able to initiate trades based on a specific ...
...seeking a skilled developer to create a Telegram bot that automates trading signals on the IQ Option binary platform. The bot should operate with 1-minute expiry trades, providing entry and exit quotes. Key Requirements: 1. Strategy Implementation: The bot should utilize a trading strategy aimed at maximizing the win rate, targeting at least a 101% success rate. 2. Market Analysis: It should automatically analyze the market, pinpoint the best investment opportunities, and execute transactions. 3. User Interaction: The bot will be semi-automated, requiring user confirmation for each trade. 4. User-friendliness: The bot must be stable, effective, and have visual indicators for signals and trades to enhance user experience. Ideal Skills and Experience: - Proficiency in developing ...
I need a professional Excel file for comprehensive inventory planning. This includes stock level monitoring, demand forecasting, order management, and raw material safety stock. The Excel file will need to integrate with SAP, specifically for seamless data transfer and process alignment. Key functionalities I need in the Excel file include: - Automated data import: I want the data to flow into the Excel file automatically from SAP, without needing manual input. - Custom reporting: The ability to generate tailored reports based on specific parameters or needs. - Data visualization: Incorporating graphs, charts and other visual aids to help interpret the data. Ideal candidates for this project should have: - Extensive experie...
I'm looking for an expert Excel specialist who can set up a comprehensive spreadsheet for me. The data I will be inputting is a combination of financial and sales tracking information. Key Requirements: - Design and setup of an Excel spreadsheet tailored to track both financial and sales data. - Incorporation of automatic calculations and formulas to facilitate data processing. - Implementation of data visualization tools within the spreadsheet, such as charts and graphs, to illustrate trends and patterns. Ideal Skills: - Extensive experience with Excel, particularly in setting up complex spreadsheets. - Strong understanding of financial and sales data tracking. - Proficiency in creating automatic calculations and data visualizations in Excel.
...as publication dates). • Contact details (email, phone, address, etc.). • Any other publicly accessible, relevant information. 2. Data Format: • Deliver all extracted data in a well-structured Excel/CSV format (with clear headings). • Images and files (e.g., PDFs) should be organised in folders and linked to their corresponding rows in the spreadsheet. 3. Requirements: • Ensure data accuracy and completeness. • Follow ethical web scraping practices (only scrape publicly accessible data). • Avoid causing disruption to the website’s operations. Deliverables: • A completed dataset in Excel/CSV format. • A folder containing all associated images/files. • A brief summary of the process and any challenges encou...
I'm looking for a professional to create a SketchUp file for an architectural design project. The file should represent the basic layout and structure, without the need for detailed building features or high-detail furnishings. Ideal Skills: - Proficiency in SketchUp - Understanding of architectural design - Ability to create basic layouts Experience: - Prior work with architectural SketchUp files - Experience with creating models for conceptual planning or client presentations Please note, the primary purpose of this project is not yet determined, so flexibility and creativity in your approach will be highly valued.
I'm in need of an Excel whiz who can help me set up a comprehensive sales tracking system. Key Requirements: - Define daily sales-related tasks for each team member - Create an Excel spreadsheet to monitor these activities - Design a final dashboard to consolidate the data Skills & Experience: - Proficient in Excel with proven experience in sales tracking - Capable of creating user-friendly dashboards - Excellent understanding of sales metrics, particularly the number of sales and client interactions. The ideal candidate will help me track the performance of each of my sales team members, ultimately enhancing our overall sales strategy.
I'm working on an automatically movable stage. This project requires a proficient Python coder with experience in robotics and automated control systems. Key Responsibilities: - Develop a Python code that will control the movement of the stage across three axes - Ensure the coding facilitates smooth and precise movements Required Skills: - Expertise in Python coding - Previous experience working with automated control systems - Familiarity with robotics and physical product coding I was wondering if you could code for me so that a stage holding a petri dish with two x axes , one y axis, and one z axis that have stepper motors in them can move automatically to keep a fish inside the petri dish in the focus of a Ti2 inverted microscope's camera. I attached the pi...
I'm in need of an Excel whiz who can help me set up a comprehensive sales tracking system. Key Requirements: - Define daily sales-related tasks for each team member - Create an Excel spreadsheet to monitor these activities - Design a final dashboard to consolidate the data Skills & Experience: - Proficient in Excel with proven experience in sales tracking - Capable of creating user-friendly dashboards - Excellent understanding of sales metrics, particularly the number of sales and client interactions. The ideal candidate will help me track the performance of each of my sales team members, ultimately enhancing our overall sales strategy.
Project Title: Advanced Telegram File Uploader Bot Project Description: I want to create a Telegram file uploader bot with advanced features that allow the admin to upload single or multiple files and generate unique download links for users to access these files. Below are the detailed features and requirements: Core Features: 1. File Uploading: Single-file upload. Batch upload (multiple files at once). 2. Download Link Generation: The bot should generate unique download links for each uploaded file or batch. Links should allow users to download the files directly via Telegram. 3. File Management: The admin should have the ability to add files to an already uploaded batch. Admin should be able to modify or delete files and batches. ...
I'm looking for an Excel expert to develop a program that calculates various real estate market trends. The program should specifically focus on analyzing general market tendencies. It should be a program that can be used numerous times with different data sets. Key Skills: - Advanced Excel skills: You should be proficient in Excel and able to create complex formulas and functions to analyze the data. - Real estate knowledge: A background or understanding of the real estate market would be a plus as it would help you comprehend what data is relevant and how to interpret. Please provide examples of similar projects you have completed.
I have an Illustrator (AI) file that needs to be converted to a Corel Draw (CDR) file. The primary purpose of this conversion is for further editing, so it is crucial that all editable elements, like text and layers, are preserved in the process. Key Requirements: - Convert AI file to CDR format - Ensure all editable elements are preserved - Specific fonts and text styles must be retained The AI file contains specific fonts and text styles that need to be preserved in the CDR file. Please only apply if you have experience with both Adobe Illustrator and Corel Draw and can ensure a seamless conversion of the file without any loss of quality or functionality.
I need a skilled professional to seamlessly integrate my Microsoft Access Database with a daily-updated Excel sheet. The Excel sheet contains mixed data (text and numbers). Key Tasks: - Daily integration of updates from the Excel sheet into the Access database. This includes both appending new records and updating existing ones. Ideal skills and experience: - Proficient in Microsoft Access and Excel. - Experience with data integration and automation. - Ability to set up a system that requires minimal manual intervention.
We’re running into a problem with provider blocks in our business. What we’d like to do is identify the countries of users’ IPs when they log in to our site. If their IP is from a country on our blacklist, we want to automatically redirect their traffic through a proxy or a similar solution that changes their IP to one from whitelisted regions like South Africa, Colombia, Finland, or others. Basically, we need a way to make sure all traffic from blacklisted countries goes through trusted IPs. We’re open to your suggestions on how to best handle this. I'm looking for a professional who can assist me in setting up a proxy solution to redirect traffic. The main purpose of this project is to bypass certain restrictions. We previously hired a developer wh...
need a script which 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.
I need someone skilled in data entry to help with inputting mixed data (numerical and text) into an Excel sheet. The data needs to be organized in chronological order. I will provide a PDF with data that contains 4 fields to be entered on Excel document. Ideal skills for this project include: - Proficiency in Excel - Excellent attention to detail - Strong organizational skills Please note, there will be no specific date or time formats involved in the data entries.
As a law firm, we're looking for a developer who can create an application for real-time analysis of Twitter, Facebook, and Instagram posts from a specific area. The app should categorize posts by theme, and generate an Excel file detailing demographic information such as age, gender, location, interests, and the profiles of followers and followees for each segment. The ideal candidate for this project should have: - Extensive experience in app development, particularly for social media analysis. - Proficiency in data segmentation and Excel file generation. - Ability to implement real-time data processing. - Skills in understanding and analyzing demographic data. Your work will help us conduct a market analysis to better orient our services.
Hello Sir/Madam, my name is Mohammed Shan. With five years of experience in Microsoft excel, I specialize in creating advanced spreadsheets tailored for sales data analysis. I am adept at using Excel formulae and data analysis tools, including the creation of effective - drop lis downts. My strong attention to detail and proven track record in handling complex Excel projects make me a suitable candidate for your needs. I look forward to delivering high-quality results for your project.
We are seeking a skilled language expert with a strong background in medical and clinical terminology to handle the conversion of case studies and hospital reports into major global languages for international medical research. This position requires a professional with a deep understanding of medical practices and terminology in both the Italian healthcare system and global medical research standards. You will play a crucial role in ensuring that Italian medical documentation is effectively adapted for use in global research initiatives, supporting advancements in healthcare on an international scale. The focus of this role is the precise and accurate conversion of clinical and hospital reports into English, French, Spanish, or other widely spoken languages. The documents in question inv...
...functionality to flag and exclude tokens created by developers associated with previous rug pulls. Store flagged developer information in the configuration file for easy updates. 3. Integration with TweetScout API Use the TweetScout API to: Analyze social media activity for specific coins. Cross-analyze insights from TweetScout with the data patterns from migrated tokens. Enhance prediction models by factoring in community sentiment and activity trends. 4. RugCheck Integration Leverage the RugCheck API: Verify the contract integrity of each token being considered for trading. Exclude contracts flagged as unsafe or tokens with bundled supply. Automatically add bundled tokens and their associated developers to the blacklist. 5. Autonomous Trading Decisions Pattern-Based Deci...
I'm looking for an AutoHotKey, PowerAutomate or Macro Express professional to create a script for simulating mouse and keyboard events. Key Requirements: The script should capture events from a foreground window and replicate them in a background window with a 10-second delay maximum. e,g - we have two ms paints running, we draw something on a ms paint in foreground, the same is automatically drawn on mspaint in background. - this can happen with 10second lag or less - both background and foreground windows are maximized. Ideal candidates should have significant experience with AutoHotKey, and ideally have previously developed similar scripts. Good understanding of Windows applications and ability to implement variable time delays is a must.
My custom Google Feed XML link is currently deployed on a Vercel server, but I'm encountering limitations. I'm looking for an experienced professional who can move this to a more suitable hosting service where my Google Feed XML file can efficiently fetch data from Shopify. Ideal Skills & Experience: - Extensive knowledge in various hosting services like AWS, Google Cloud, and DigitalOcean. - Experience in handling Google Feed XML links. - Proficient in integrating with Shopify. - Understanding of server limitations and how to circumvent them. Please note, my budget is currently tight, but I'm looking for long-term collaboration. The specific limitations on the Vercel server have not been identified yet, and there are no specific server conf...
...platform-specific rules to avoid penalties. 5. SEO-Driven Organic Growth Optimized Blog Content: Weekly AI-written blogs targeting high-traffic health-related keywords. Example: “How Calcium Syrup Supports Strong Bones – Get Your Free Trial!” Call-to-Action Placement: Strategic CTAs in blogs, landing pages, and product descriptions to drive subscriptions and coupon redemptions. Technical SEO Automation: Automatically update sitemaps, improve site speed, and resolve crawl errors. Featured Snippet Targeting: Structure content to secure featured snippets on Google for common health-related queries. 6. Social Media and Community Engagement Platform Coverage: Instagram, TikTok, Facebook, Pinterest, LinkedIn, and niche health forums. Organic Content Creation: AI gen...
I need a PowerApp developed that handles mixed data types (text and numerical). The app should be able to connect to an Excel spreadsheet, as this will be the primary data source. Key Requirements: - The PowerApp should store data for manual calculations, which will primarily involve basic maths. - Finally, the processed data should be able to enter into SharePoint. Ideal Skills: - Proven experience in developing PowerApps. - Familiarity with SharePoint and Excel integration. - Basic understanding of mathematical calculations for data processing.
I'm seeking a Magento expert to assist with some frontend customizations specifically on product pages. We have a custom site that displays an attribute table in the product page , this is all completed. However client wants a different layout for this table for just one category of products. Think this can be done as simply as checking if it's x category and displaying one tabl...frontend customizations specifically on product pages. We have a custom site that displays an attribute table in the product page , this is all completed. However client wants a different layout for this table for just one category of products. Think this can be done as simply as checking if it's x category and displaying one table and if not a different table. Also do need some help with some ...
I'hankm looking for a pPDF, Word. T y Hello Sir/Madam, my name is Mohammed Shan. With five years of experience in Microsoft Excel, I specialize in creating advanced spreadsheets tailored for sales data analysis. I am adept at using Excel formulae and data analysis tools, including the creation of effective drop-down lists. My strong attention to detail and proven track record in handling complex Excel projects make me a suitable candidate for your needs. I look forward to delivering high-quality results for your project.