Excel macro vba import csv text file jobs
I need assistance with matching two lists of brand and company names. The data is in Excel format. - The first list has 4 columns and the second list has 1 column. - The type of matching required is 'fuzzy match'. Ideal skills for this project include proficiency in Excel, experience with data analysis, and knowledge of fuzzy matching techniques. The work needs to be completed by Friday morning India time .
I need a professional who can decode a 300 MB .txt file for me. - File Size: 300 MB - File Format: .txt - Content: Unknown Please only apply if you have the necessary skills and experience to decode this file. Previous experience with large text files is a plus.
I need a QuickBooks expert to help me set up my accounts in QuickBooks Online for my manufacturing business. The setup will involve: - Inventory Management - Bill of Material...The setup will involve: - Inventory Management - Bill of Materials Currently, I have less than 10 suppliers and customers, and about 20-30 products. I also need assistance preparing my inventory and bill of materials data for import into QuickBooks. After the initial setup and training, I will be responsible for daily operations. Ideal candidates for this project should have: - Extensive experience with QuickBooks Online - Strong understanding of inventory management and bill of materials in a manufacturing context - Ability to assist with data preparation for import - Excellent training and comm...
...in a CSV file format. - I have partially labeled data for training and validation, but assistance with labeling may be needed. - The outputs of the model should be shared in an Excel file. - Include detailed data preprocessing steps and techniques. - Define clear performance metrics for evaluating the model, such as accuracy, F1 score, precision, and recall. - Outline the approach for hyperparameter tuning to optimize model performance. - Describe techniques for handling imbalanced classes within the dataset. Ideal Skills: - Proficient in Python and machine learning libraries such as TensorFlow and PyTorch. - Extensive experience with sentiment analysis and using BERT, RoBERTa and ModernBERT. - Familiarity with GCP. - Ability to assist with data labeling and...
I need a DWG file of an apartment to be redrawn according to a hand sketch I've provided. The new DWG file should be comprehensive, containing full construction details. It doesn't need to include any specific materials or textures, just the structural details. Ideal skills and experience for the job: - Proficiency in AutoCAD or similar software - Experience in creating detailed architectural plans and construction drawings - Ability to interpret hand sketches and translate them into digital formats - Attention to detail to ensure all structural elements are accurately represented
I need assistance with handling customer data. Key Responsibilities: - Data entry - Data analysis - Data cleaning The ideal candidate should: - Be proficient in Excel. - Have experience with data management and analysis. - Be capable of cleaning and maintaining data integrity. Please note that tasks will be primarily focused on customer data.
I'm in need of a field verification executive for assisting in conducting residence, office, business and document verification du...cover the following locations: Rajasthan, MP, UK, UP, Delhi NCR. All visits will be supported by visit photographs with Selfee of executive and Geo tagged. Verifications will be conducted multiple times in a day. Each verification must be completed within 24 hours. Verification reports should be detailed and comprehensive. The verification reports should be delivered in the format: either on call, excel, or informed punched in our software or shared over email with photographs evidence of visit duly geo tagged. Reports should include a basic summary of findings. Verification tasks will be assigned daily. Verification tasks are expected to be betwe...
I need a freelancer for some data entry work. The task involves entering textual data into an Excel spreadsheet. The dataset is relatively small, with less than 100 entries. Ideal skills for this job include: - Proficiency in Excel - Attention to detail - Ability to accurately transcribe textual data - Experience with data entry tasks
I have an Excel workbook that has an error in the February tab. The daily totals are not posting in the correct cells. I need you to fix this issue and ensure that the tab matches both the layout and the formula structure of the January tab. Additionally, I need the remaining months of the workbook resized to look like the January tab. Ideal skills and experience for this job: - Proficiency in Microsoft Excel - Strong analytical skills to identify and rectify errors - Prior experience with data management and workbook formatting - Attention to detail to ensure accuracy and consistency
I need a professional to develop a Bayesian Network for a decision support system. The primary goal of this project is to leverage the Bayesian Network's capabilities to assist in making informed decisions. Key Requirements: - Integration of existing data sets I have, which are in CSV format. - Expertise in developing and implementing Bayesian Networks. - Experience in creating decision support systems. Please, submit your bid if you have the relevant skills and experience. I look forward to collaborating with you!
I've got a PDF that contains a date error in the main body. This needs to be replaced with the correct date (24 September 2025) please. Ideal skills for this task: - Attention to detail - PDF editing expertise - Proficient in text replacement
I'm experiencing issues with Excel's conditional formatting and need an expert to help. Key issues: - Cannot copy entire conditional formatting rules across the spreadsheet. Ideal skills for this project: - Advanced Microsoft Excel expertise - Proficiency in identifying and resolving Excel-related issues - Strong understanding of conditional formatting techniques Please provide regular updates via remote. The troubleshooting will be for Excel 365.
I need help editing the text on 7 AI pages menu. The edits primarily involve updating menu item names and adding new ones that I have already prepared. Ideal Skills: - Proficiency in text editing - Attention to detail - Ability to follow provided instructions
I'm seeking an instructor to help me grasp the concept of optimization, focusing primarily on Linear Programming. As a beginner with Excel Solver, I need someone who can guide me through solving questions with various constraints. Key Requirements: - Expertise in Linear Programming. - Proficient in teaching Excel Solver. - Capable of explaining different types of constraints depending on the case study. -solve with me questions Ideal Skills: - Advanced knowledge of optimization techniques. - Strong communication and teaching skills. - Experience in using Excel Solver for complex problems. As the type of constraints we will be working with will depend on the case, I require a flexible and knowledgeable instructor who can adapt to different scenarios and explai...
We are looking for a...similar ideas that we may like. we are not 100% about the design so would look at all ideas that you may be creative to design. We are looking for different versions of the logo and text that can be displayed on a white background and a black background to suit the website that we are currently building. We will need versions that have the company name text next to the logo and versions where the text is under the logo (see examples). We will also need versions that show our website address as shown in the pictures Use dark black, white, and Gold as the primary colors to suit the website backgrounds. The Text font needs to be bold and easy to read. Please look at the PowerPoint attached to see examples. Thank You in advance for ...
I have approximately 3000 rows of data spread across three Excel 365 sheets. I need someone to extract, link, and manage this data for me. The final deliverable will be a detailed report in Excel. This report should include: - Data summaries - Trends and patterns - Comparative analysis PEASE REFER TO THE ATTACHED EXCEL FILES WHICH WILL BE USED THE SCOPE FOR THE BID IS IN THE WORD DOCUMENT There's no need for complex formulas, but the ability to identify and highlight these aspects of the data will be crucial. Your expertise in data management and proficiency in Excel will be key to the success of this project. THANK YOU FOR THE TIME TO READ AND BID
I'm in need of a modern, text-based logo. The logo should embody a sleek, contemporary style, consistent with modern design principles. Ideal skills and experience: - Proficient in graphic design, particularly logo creation - Strong understanding of modern design principles - Experience with text-based logos - Excellent communication skills for understanding and implementing feedback
I'm looking for an experienced developer to create an in-browser rich text editor with a virtual keyboard. The editor will need to support the following: - Platforms: It should function seamlessly across both Desktop and mobile platforms (Android and iOS), without triggering the mobile keyboard on these devices. A smooth user experience is crucial. - Download Options: Users should be able to download their edited content in both Image and PDF formats. - Text Formatting: The editor must provide basic text formatting options such as Bold, Italics, and Underline. - Color Options: Options to change the text color - Text Alignment: Options to align text to the left, center, or right. Ideal candidates will have a strong background in JavaScript an...
I'm looking for an expert in web scraping. The primary purpose of this project is to gather data for analysis. fixed $20 Key Requirements: - Proficient in web scraping techniques and tools - Experience in data collection for analysis purposes - Ability to deliver data in CSV format The ideal candidate will have a strong background in data analysis and web scraping, with the skills to deliver clean, well-organized data in a timely manner. Please provide examples of similar projects you have completed in your proposal.
I am looking for a data operator to assist with a complex data entry project. The ideal candidate should have experience in data entry from digital files, specifically using Microsoft Excel. The work involves significant formatting and clean-up of the data. Skills and experience required: - Proficiency in Microsoft Excel - Strong attention to detail - Ability to handle complex data entry tasks - Experience in formatting and cleaning up data - Experience with creating and using Excel Macros 1 year If you are meticulous, experienced in data entry, and proficient in Microsoft Excel, please apply for this project.
I have 35 pages of handwritten documents that need to be typed in xl. The specific requirements, such as document format and font style, can be budget is $10 if you think this is good for you then you are welcome. Otherwise please do not be on this project.
Hello! I found this project that you did before. Did you create a converter tool? We need a tool or routine to convert MT940 to CSV. I will provide output format. Important is description part is completed completely . The tool should be developed using Python. The CSV should follow a custom layout specified by us. The tool should include advanced error handling and logging for all operations. Please ensure errors trigger email notifications to us. Error notifications should be sent immediately when an error occurs. Please use the following method for email notifications: Outlook email. The expected turnaround time for the project is 1-2 weeks. The MT940 files will have consistent formatting. No user interface is needed for the tool. Input MT940 files will be provided b...
I'm in need of a freelancer who can help me connect with B2B buyers on a global scale, specifically within the Import-Export industry. The ideal candidate will have experience and skills in: - B2B Marketing - Networking - Communication - Understanding of the Import-Export industry Description: We are Tradetastic Overseas Pvt Ltd, an established export company dealing in high-quality tea, coffee, and other Indian agricultural products. We are looking for experienced B2B sales professionals, lead generation experts, and deal closers who can help us connect with international buyers and secure orders. What We Offer: ✔ A legitimate company with certifications and a strong product portfolio ✔ Competitive pricing and high-demand products ✔ Full support with product detai...
I'm seeking a professional for data entry, specifically focused on numeric data. The data will be sourced from various digital documents and should be entered into either Excel or Google Sheets. Ideal Skills: - Proficient in Excel or Google Sheets - Attention to detail - Experience in data entry, particularly with numeric data - Ability to maintain confidentiality and handle sensitive information responsibly.
I'm seeking an experienced data analyst and Power BI expert to design an engaging and insightful dashboard for tracking both project progress and financial metrics in the construction industry. Key Features: - The dashboard should track project-related metrics such as completion percentage, milestones achieved, and tasks overdue. - Financial metrics shou...percentage, milestones achieved, and tasks overdue. - Financial metrics should include revenue forecasts, expense categorization, and project rating. Ideal Skills: - Proficient in Power BI - Strong background in project management tracking and financial reporting - Experience in the construction industry is a plus - Excellent data visualization skills The dashboard should integrate data from Excel/CSV files. start...
I need a data entry/web/Instagram scraping specialist who can help me categorize the 2600 businesses I follow on Instagram. The businesses primarily belong to the fields of architecture, construction, and development, with specific focus on: - Architects - Builders - Developers - Project ...construction, and development, with specific focus on: - Architects - Builders - Developers - Project Managers - Landscape Architects The categorization should include the following fields: - Company Name - Website - State - Profession - Do they follow me back A good command of English is essential for this task, as is the ability to follow clear instructions and input data accurately into an Excel spreadsheet. Experience in data entry, web scraping, and social media analysis would be highly b...
I'm seeking a proficient Excel user for data entry and analysis. Skills and Experience: - Proficient in Excel with experience in using Pivot tables, Formulas and calculations, Charts and graphs - Attention to detail for accurate data entry - Ability to analyze data and generate reports if needed Please note that the specific type of data and primary goal for this project have not been specified. The successful freelancer will need to be flexible and adaptable to different types of data and tasks.
...10 compatible macro for an Online 2D Pixel Art game. The macro needs to control a player and manage various tasks, including mining, fighting spiders, and handling mine collapses. Key Features of the Macro: - Control a player near the screen center - Mine a rock wall with varied inputs - Move to the side and repeat mining - Return to the original position after a few cycles - Handle random events like spiders appearing or mines collapsing - If a spider appears, swap weapons and attack it - If a mine collapses, quickly head to the exit, re-enter and return to original position - Implement dynamic movement patterns to avoid detection from anti-cheat systems/game Admins lurking. Detection Methods: - Use pixel color detection to identify events Additional Requirement...
...via chatbot Feedback: Collect customer feedback to improve the website and user experience. To automatically extract data from PB Tech NZ () and load it onto your website, you can use web scraping techniques. However, before proceeding, it's important to note that web scraping may violate the terms of service of the target website. Always check the website's file (e.g., ) and ensure you have permission to scrape their data. If scraping is allowed, here’s how you can automate the process: Step 1: Understand the Data to Extract Identify the data you want to extract from PB Tech NZ, such as: Product name Product description Price Images Specifications Reviews and ratings Stock availability Step 2: Choose a Web Scraping
I need an annual Profit and Loss statement prepared for an SBA loan application. It will be in Excel format. Key Tasks: - Prepare the P&L statement in Excel - Follow a standard template or best practices, as I don't have a specific template - Cover the statement for the entire year Skills and Experience: - Proficiency in Excel - Experience in preparing Profit and Loss statements - Familiarity with SBA loan requirements - Ability to suggest and implement standard templates or best practices.
I'm seeking assistance in improving the organization of my Excel sheet which records staff daily work activities. The primary focus will be on refining the data layout for better clarity and accessibility. I need to separate outreach calls vs in-person assistance/community events. I started formula to total based on week and the month. Ideal Skills: - Proficiency in Excel, particularly in data sorting and filtering. - Experience with creating organized data layouts. Although I don't have specific formulas in mind, I would appreciate a professional with knowledge of various Excel functions who can suggest and implement suitable ones to enhance the functionality of the sheet.
...Team". The logo should be a fun, yet professional sports-themed design that incorporates text that would be seen as sports styled. Minimalist. See the Dallas Cowboys Cheerleader picture for inspiration and FONT choice. Key Requirements: - The logo should be primarily text-based, with the words "Making The Team" being the focal point. - It should have a retro feel, reminiscent of the golden age of sports broadcasting, while still being modern and appealing to today's audience. - There should be versions of the logo that are clean, minimalist text-only designs, as well as more complex designs. - The logo should ultimately be clean and simple, with the option to add in more complex elements as needed. The text should have glowing on the edge...
...data should include: - Company name and its corresponding LinkedIn page URL - Work email addresses of facility managers and office managers (London-based) - LinkedIn profile URLs of the aforementioned managers - The source link for each piece of data An Excel template will be provided for you to input the data. The ideal freelancer for this project should be: - Detail-oriented and able to follow instructions accurately - Proficient in data collection and research - Familiar with LinkedIn and its functionality - Able to work with Excel Please note, I only require work emails, not personal ones. The companies should be in the legal industry. Budget: Flat rate 5 NZD per 100 companies (100 office managers & 100 facility managers) Time: 2 days Please start your bid...
...a tailored Excel template to streamline my work checks. Currently, I have to manually copy and paste complicated formulas and use text replace functions to substitute keywords like LESS and PLUS with their mathematical counterparts. For examples sake, I want to put in "(25%LESS1/8LESS1/16 of 7/8) of 1/2 of 1/2 of 8/8" in A1, and have a Cell then automatically output that info. I have used substitute functions, then did evaluate formulas, but doesn't turn out right. Key Responsibilities: - Develop an Excel template that can process long form mathematical expressions and return values automatically, saving me the tedious work. - Ensure the template can handle mixed operations including addition, subtraction, multiplication, and division. Ideal Skill...
I'm looking for someone to analyze an academic paper focused on the energy sector within the realm of science. The analysis should specifically c...presented in the paper. Key Requirements: - Expertise in the energy sector of science. - Strong skills in analyzing experimental results. - Ability to provide clear and concise interpretations of findings. Task: - Understand the method that undergoes in the following research paper - Write the maths that goes from the data till the results step by step on paper and send the pdf - After that make an excel for conducting such step by step maths The ideal freelancer for this project will have a strong background in science, specifically the energy sector, and can demonstrate experience in analyzing academic papers and their experi...
...Notifications: Develop an alert system using WebSocket or tools like Pusher/Socket.io. 2. Data Features Data Synchronization: Create jobs to automatically update campaign data (e.g.: every 5 minutes). Store metrics history for temporal analysis. Automatic Insights Calculation: Develop algorithms to identify trends (e.g.: "CPA increased by 20% in the last week"). Report Export: Generate PDF/Excel with filtered data (e.g.: performance by period, platform). 3. AI System AI Integration in Chat: Connect to an NLP API . Train the model to answer technical marketing questions (e.g.: "How to improve ROAS?"). Automatic Insights Generation: Develop scripts for predictive analysis (e.g.: Python with Pandas/Scikit-learn). Example: "Suggest a 15% increas...
I am looking for an Excel professional who can assist me with implementing VLookup, HLookup, and X-Lookup functions in my spreadsheets. Key tasks include: - Implementing these lookup functions to streamline data analysis and financial report creation. - Assisting in the update of data across different sheets to ensure all reports are current. The primary report we need to generate is a product costing sheet. Ideal candidates should have: - Extensive experience with Microsoft Excel, particularly with lookup functions. - A strong understanding of financial reporting. - Excellent attention to detail and ability to work with complex data sets.
I'm seeking a Smartsheet professional who can help with automating data synchronization from Excel files into the platform. Ideal Skills and Experience: - Extensive knowledge of Smartsheet and its workflow automation features - Proficiency in Excel and understanding of data synchronization processes - Previous experience working on similar projects - Excellent problem-solving skills to troubleshoot any issues that may arise during the automation process - Ability to understand my specific needs and tailor the solution accordingly.
...Extraction: The AI should be able to extract 'Name' and 'Email' from Instagram, FaceBook, Ticktok, X, Youtube and compile this data into a CSV file. - Email Management: It should check for duplicate entries and manage email campaigns, sorting emails based on their status (with a focus on 'Opened'). It should have the ability to send emails in batches. - Extend data extraction capabilities to include LinkedIn, Twitter, and Pinterest. - Implement advanced filtering options to target specific demographics or interests. Ideal Skills: - Proficiency in AI development - Experience with data scraping - Understanding of email marketing systems - Ability to create and manage CSV files I'm looking for a professional who can deliver a s...
I need help with a mail merge project. I have a Word document that needs to be populated with names and from an Excel file. And then I then I also need one for mailing labels or printing on envelopes. Ideal Skills: - Proficiency in Microsoft Word and Excel - Experience with mail merge - Attention to detail
I need info from a PDF file transferred into an Excel spreadsheet. The PDF is a membership directory. I only need members that are a "Presenting Organization" (which starts about half-way down the directory). I've attached the PDF and a blank xls file with headers to populate. Please provide a bid and an estimate of the numbers of members to be imported so I know you understand the scope.
...Automate Flow for Extracting Data from Wedding Agreement (Adobe Sign) and Updating Excel Hi, I need help in creating a Power Automate flow with the following requirements: Objective: The goal is to extract data from a completed wedding agreement (Adobe Sign) and add the relevant information into an existing Excel file. Depending on specific data in the agreement, I need the flow to either add one or two rows in the Excel file and update those rows with the extracted data. Key Steps: Trigger: When a wedding agreement workflow is successfully completed (signed), the flow should be triggered. Extract Data: Use the Get form field data action to extract the form data from the agreement (preferably in Excel or JSON format). Condition Logic: T...
I'm seeking a freelancer to help me extract data from the Livescore app for all football matches over the weekend. The data should be organized into an Excel sheet with separate sheets for each match date. Ideal Skills: - Data Extraction - Excel Proficiency - Attention to Detail Please note, the specific leagues, tournaments, and data points to be extracted have not been determined yet. Therefore, flexibility and good communication skills will be vital for this project. A keen interest in football could also be an advantage. I need all this informations into Excel sheet please check image jointe
I'm looking for an AutoHotKey, PowerAutomate,UIPath or Macro Express professional to create a script for simulating mouse and keyboard events. Key Requirements: 0- Create a simple dialogn box with a) Button Start/Stop mouse capture b) enter the name of target program (text box) 1- capture mouse events for 10 second and save in a file ( precisely , clicks, moves, click+move etc etc , with timestamps) 2- play all these mouse events save in a file on a target program (word, paint, canva, etc etc) target program will be specificed 3- The events recorded in file must play exactly on the target window . This is simple 1 hour job, and might be more next week.. use any tool of your choice
I'm in need of an AI agent that can help me streamline my data extraction...Requirements: - Data Extraction: Primarily from Instagram, but also from other platforms like Facebook, TikTok, X, and YouTube. The AI should be capable of extracting 'Name' and 'Email', compiling this data into a CSV file. - Email Management: The AI should check for duplicate entries and manage email campaigns, sorting emails based on their status, with a focus on 'Opened'. It should have the ability to send emails in batches. Ideal Skills: - Proficiency in AI development - Experience with data scraping - Understanding of email marketing systems - Ability to create and manage CSV files I'm looking for a professional who can deliver a system that can he...
...platforms, not just social media sites but also blogs, forums, and public records and databases. - An exhaustive reach, covering 'everything that's out there'. - Specific tracking on all major social media platforms including Facebook, Twitter, Instagram, and more. - AI-powered analysis to identify and highlight patterns or connections in the gathered data. - Multiple data export options including CSV, PDF, and other formats for easy reporting. - Historical data retrieval to access information that has been deleted or altered. - User-friendly interface that allows investigators to easily navigate and use the software. - Cross-platform compatibility to ensure the tool works on different operating systems. - Anonymity features to conduct research without revealing th...
We are seeking someone to create a .thmx file for us to use across all Microsoft products. Will will use this as the standardizing format package for our business. OUTPUT GOAL Creation of a .thmx file SCOPE OF PROJECT Details: there may be more that goes into it, but my understanding is the 3 main pieces are: 1. Font selection (ideally one that works with online and desktop versions) -- we would love your help curating a few font choices that we can select between. We serve professional and corporate clients, so we'd want this to be easy to read, yet still crisp and not overly stuffy nor too informal 2. 10 theme colors (with gradients) -- I can share our website and the virtual background that we use for video calls. I imagine you might be able to extract a color p...
I'm in need of a modern, minimalist text logo for my company, Virtue Rise Developments. The logo should use a sleek flat Aptos / Arial type font and be presented in a simple monochrome scheme with some simple elegant geometric shapes or lines to add some flare but overall still minimalistic. Ideal Skills: - Graphic Design - Logo Design - Adobe Illustrator - Typography - Brand Identity Please provide samples of your previous work that align with this brief. Keep the logo mainly text.
I need an SQL expert to help me export specific query results from my SQL database into a CSV file. - Database Type: SQL - Export Format: CSV - Data to Export: Custom query results Ideal skills and experience for the job: - Proficiency in SQL with experience in data extraction. - Familiarity with exporting data to CSV format. - Ability to understand and execute custom queries. - Attention to detail to ensure data is accurately exported. No additional data processing or transformation is required before exporting the data. The data needs to be exported at scheduled intervals. The data needs to be exported daily at scheduled intervals.