Text mining excel vba jobs

I have to download everyday +- 3000 invoices (PDF files) from a server to my computer. I already have this task semi-automated in an Excel macro, but I want to do it easier. I need a tool (also in Excel/VB/Macro) where: - I'll write the day, month and year - I'll write the first invoice number and last invoice number that I want your tool to search - I'll hit a button "START" and your tool will search and download to my computer every invoices from that range that were issued on that specific day from an specific URL. The URL for these files is a standard URL. It's always an URL like this: The only part that changes is day, month, year and invoice number. Example: if I want to download any available invoices between numbers 5000

I need expert help with formatting documents across Microsoft Word, Excel, and PowerPoint. The key tasks include: - Formatting text: Ensuring consistency, readability, and visual appeal for all text elements. - Tables and charts: Skillfully organizing and presenting data in tables and charts. - Page layout and design: Creating visually engaging and professional layouts. - Resume: Crafting a creative resume with a professional touch. Ideal candidates should have: - Proficiency in Microsoft Office suite, with a focus on Word, Excel, and PowerPoint. - Proven experience in text formatting, table/chart creation, page design, and resume formatting. - A keen eye for detail, design, and visual presentation. - Ability to work efficiently and meet deadlines. - Fa...

I have a series of English PDF documents that I'd like to convert into plain text. The job does not require preserving the original formatting. Images within these PDFs are essentially icons that represent their respective content. I need the text converted to a text file. For the images, I would just like a description of what the icon represents. The file is here: If it makes a material difference to cost, the text above “Reasons for judgement can be left off. Please note text must be exactly what is in the pdf, no words can be missed or in the wrong order.

In need of an Excel whizz to immediately help in cleaning up my spreadsheet which has become cluttered and confusing. The main task will be: - Formatting cells and columns: Your experience in making spreadsheets intuitive, organized, and easy-to-read will be key. Expertise in creating visually appealing and easy-to-navigate cell and column formats is crucial. Though the specific type of cell and column formatting was not specified, the ability to quickly adapt and modify to different formatting styles would be a plus. Please note, this task is time-sensitive and requires prompt completion. If you have a proven track record of quick turnaround times on similar projects, don't hesitate to apply. Your efficiency and attention to detail will be prized.

...media management, data mining, and customer support. We are looking to pay about $100 monthly as this would be about 15 hrs max weekly. Key Responsibilities: - Handling data mining and research: I need someone to assist in researching various topics that pertain to my work as a speaker and coach. - Customer support: You'll also be responsible for providing basic customer support, responding to general inquiries and forwarding more complex issues to me. - Social Media e-mailing: I need someone who can assist in managing my social media accounts, specifically Facebook, Instagram, LinkedIn, and Tiktok. Hours: - I anticipate needing your assistance for less than 10 hours per week. Key Skills: - Excellent written and spoken English. - Proven experience in data ...

I'm in need of a programmer skilled in pine scripts (tradingview). I am looking for someone who can create an alert in my script that is triggered when all specified conditions (Multiple conditions) are met. The conditions were not delineated in the planning phase. The key task for this project is that for example when the first condition met shou...this project is that for example when the first condition met should keep a record of that value and then use that value to another condition to trigger the alert. The ideal freelancer would: - Have experience in building complex alert systems - Understand and be able to work with the existing code - Be able to complete this task within the given time frame - Have great attention to detail and excel under limited supervision My...

I'm seeking an Excel specialist who can help automate the process of managing my inventory. The main task includes creating a function that calculates and displays the number of pieces in boxes on pallets. This project mainly revolves around calculative automation and descriptive statistics. Key responsibilities: - Developing an Excel function that calculates the number of items in the boxes on pallets - Automating descriptive statistics to make the process more efficient An expert with profound knowledge in Excel and a strong background in performing operations associated with calculation automation and descriptive statistics would be the ideal fit for this task. Your role will revolve around simplifying my procedures and making my work a lot more manageab...

I am looking for a freelancer to create a pricing spreadsheet based on the specific website, which is Format and Structure: I am ...quantity. The spreadsheet should output the price of the product with tiered discounts based on quantity. The desired outcome would function like but on a spreadsheet. ***A future project will integrate this spreadsheet into a website for live front end pricing.** Ideal Skills and Experience: - Proficiency in spreadsheet software such as Microsoft Excel or Google Sheets - Experience in data entry and organizing information - Attention to detail to ensure accurate pricing information - Ability to work independently and efficiently in completing the task.

Develop new sheet with vba automation, as per requirement, in addition to some modifications in previous sheets

I am seeking an expert with proficiency and accuracy in data cleaning and data entry. The project involves handling a significant dataset of more than 1000 records. The data, currently in Excel spreadsheets, needs proper cleaning—deleting duplicates, handling missing entries—and subsequent entry into a new, streamlined database. Ideal Skills: * Expertise in Excel and spreadsheet management * Proficiency in data cleaning techniques * High-speed data entry with attention to detail Experience: * Experience handling large data sets * Previous work in data cleaning and data entry operations With your help, this project will result in accurate, well-organized, and easily-accessible data, which will make an enormous difference in how we run future analyses and make in...

I'm looking for a skilled Excel expert to help prepare a company operations sheet. The project involves: to Prepare a Small Company Operations Sheet My Budget is fixed . 1000 Rupees I want an auto-calculated Want to design an auto-calculated editable quotation, Purchase order, Invoice, and company letterhead in Excel and log-register quotation price and list in excel details as below All the Reports , Log, Purchase Order Quotation has to be Printed in PDF Sample Attached Customization is required as per our requirement The Provided Sample Sheets all Need to Be Combined in One Sheet Excel ERP Template Sales Pipeline Excel Template Excel Quotation Generator with Database Commercial Invoice Generator Excel Template Contractor Invoice ...

...Python, Excel VBA, and API integration. The primary task is to extract specific data from the API response, and populate it into a designated column in an Excel file. Key Requirements: - Experience in Python programming - Proficiency in Excel VBA - Demonstrable experience with API integration - Ability to parse specific data from an API response from Google Server - Good understanding of automating tasks in Excel Further Details: - The primary purpose of the project is to send API requests with image URLs listed in column A of the Excel file. Upon receiving the API response, the relevant data should be extracted and placed in column D and B/C/E to be populated. - The setup should be easy to execute when needed by click of few buttons a...

I need an Excel workbook that incorporates customer contact information, sales volumes, and insightful visualizations for better decision-making. Key Features Needed: - **Customer Contact Information**: The workbook should include customer names 2 contact info fields (email & phone). Data Representation: - **Sales Data & Customer Slicing**: There should be 3 sheets within the workbook with sales volumes. Users should be able to use a pivot table to filter and slice data by branch and year. - **Customer Variances Year-over-Year**: I need the workbook to show customer variances year-over-year. This should include both percentage change and absolute difference. Visualization: - **Top 10 Customers**: The workbook should contain an Excel table that presents the top 1...

I'm in need of an Excel VBA expert to assist me in my project. I require assistance in writing new code, as well as debugging existing code. Specifically, the VBA code is intended for various purposes: - Automating repetitive tasks - Performing data analysis and manipulation - Creating custom functions and macros I specifically have to macros that I've started working on and need debugging: - Replacing references to cell/range addresses in formulas by their name - Implementing Montecarlo simulations (with automatic creation of histograms and data output) The ideal freelancer would have proven expertise in Excel VBA, with a strong track record of writing efficient, maintainable code. It's crucial that the code is robust, error-free, and...

I'm seeking a graphic designer to design a unique, modern text logo for my website. You must use the same or a very similar font (see attached file). The color scheme is open since I haven't chosen a specific color yet. Here's what I'm looking for: - A fresh and modern design - Usage one of the font from the attached file (or one very similar) To make a successful bid, you should have: - Proven experience in graphic design and logo creation - The ability to create simple and modern text logos - Strong attention to detail Be sure to share your previous work experiences or portfolio in your proposal. Preferably showing similar projects where you created modern text logos. Looking forward to your bids!

...Navigator. Skills and Experience: - Previous experience in lead generation using Linkedin Sales Navigator - Strong understanding of the technology industry and its key players - Excellent research and data mining skills - Proven track record of delivering high-quality leads Application Requirements: In your application, please include: - Detailed project proposals outlining your approach to generating the leads - Examples of past work and relevant experience in lead generation - Any additional information or strategies that you believe will help achieve the project goals You will deliver an excel file with the following information: First Name Last Name Company email phone cel phone Link to Linkedin profile You will be able to generate a second document with 2,000 lea...

I am seeking a professional who is adept at data entry and copywriting. This project will require: - Online form filling using data from existing digital documents. Attention to detail an...Skills in data entry and experience with handling digital documents will be essential. - Copy writing for blog and articles. I am looking for someone with experience in crafting engaging, informative, and high-quality content related to my industry. Expertise in blog and article writing is a must, as well as a strong command of English language and grammar. The perfect candidate will possess Excel skills for the data entry part of the project, and should have a track record of creating enticing blog posts that keep the reader's interest. Your bidding should reflect experience and skills ...

Looking for an experienced web developer to create a map-based public website with the following features: Functional Requirements: • Display locations pin on the map based on Excel/database details (name, Address (or Lat/log), Phone, picture etc. Attributes) • Provide a nearby location list on the left based on the current location or a list of locations based on search and filter criteria. • Enable zooming to the selected location from the list and vice versa. When a map location pin is selected, the corresponding list should be highlighted in the left places list. • Map zoom based on the mouse scroll (Should not be embedded google map) . • The list will include pictures and summaries of the place's rating from Google, cost, number of reviews, addr...

I'm in need of a data analysis and visualisation expert, particularly in R. The ideal candidate will be experienced in Excel, STATA, and SPSS as well. The main tasks include performing data analysis, creating engaging data visualisations, and building data models. Key Responsibilities: - Performing thorough data analysis using tools like STATA, SPSS, and Excel - Proficient in R for creating engaging data visualisations - Building data models to support the provided data Ideal Skills and Experience: - Proven experience in data analysis - Expertise in R and other relevant tools like Excel, STATA, and SPSS - Ability to create engaging data visualisations, preferably in the form of stacked bar charts - Strong understanding of data models and related concepts If you...

I have a set of scanned images in PDF format that I need converted into an Excel sheet. The job is purely data entry - you are to copy the content from the scanned images into an Excel sheet. The freelancer should have excellent typing skills and attention to detail to ensure that no data is missed or entered incorrectly. Ideal Skills: - Proficiency in Excel - Fast and accurate typing skills - Detail-oriented - Experience with data entry, especially from scanned images - Excellent communication to ensure any questions about the data are clarified before entry

Very simple project - need an excel wiz who can remove some duplicate entries & total up some columns. Only bid if you are an excel wiz & very experiened in excel

I'm looking for a skilled Excel expert to help prepare a company operations sheet. The project involves: to Prepare a Small Company Operations Sheet My Budget is fixed . 3000 Rupees I want an auto-calculated Want to design an auto-calculated editable quotation, Purchase order, Invoice, and company letterhead in Excel and log-register quotation price and list in excel details as below All the Reports , Log, Purchase Order Quotation has to be Printed in PDF Sample Attached Customization is required as per our requirement The Provided Sample Sheets all Need to Be Combined in One Sheet Excel ERP Template Sales Pipeline Excel Template Excel Quotation Generator with Database Commercial Invoice Generator Excel Template Contractor ...

I'm looking for a skilled graphic designer to help produce a logo for my concrete polishing startup. This logo should ideally: - Incorporate a gray color scheme, suggesting the nature of the work - Be both text-based and include an image or symbol that relates to the polishing of concrete - While there were no specific style requirements, the logo should effectively communicate the nature of the business in a professional and memorable way. The ideal candidate would have previous experience in logo design and a creative flair for combining text and imagery. Understanding of the concrete industry would be beneficial but isn't a necessity.

I'm in need of a reliable freelancer with strong data entry skills. Your tasks will include the following: - Extracting text data from documents: You will be given various types of documents, from where you will need to accurately enter the data. - Compiled data should be delivered in a text document: The final document should be neatly organized, eliminating any chances of errors. What I'd like to see in a candidate, is a strong background in data entry, excellent attention to detail, and the ability to deliver error-free work. Experience with different document types and text editing software will also be vital.

I need help with transferring a significant amount of text data from multiple online sources to my website. The data is to be copied precisely as plain text, no additional formatting required. Key Project Details: - The task involves bulk data entry, so I need someone who can dedicate a considerable amount of time to this. - Data will be copied from various online sources and then pasted directly into the website. The ideal candidate should have: - Proven data entry experience, particularly on websites. - High attention to detail to ensure accurate data transfer. - Proficiency with plain text entry. - Capability to manage bulk data entry workload efficiently.

I'm looking for an experienced and creative logo designer to create a modern and text-only logo for my brand. I prefer neutral tones - specifically black, white, and gray. Ideal Skills and Experience: - Extensive experience with modern design approach - Proven success designing text-only logos - Strong understanding of color theory, specifically neutral tones Expectations: - Deliver a unique, modern, and visually appealing text-based logo - Efficient use of neutral colors in the design - Provide initial concepts and revisions as needed until satisfaction is met.

I'm seeking a skilled AI developer to create a cutting-edge Large Language Model (LLM) that can handle a wide range of text-to-text tasks. This model should be built from the ground up, using my provided dataset as the foundation. Key Requirements: - Creation of a Large Language Model: The core functionality of this AI model should be the ability to interpret and generate varied text inputs, in all languages. - Versatile Text-to-Text Tasks: The model should be equipped to handle diverse text-to-text tasks - from language translation to text summarization and chatbot responses. Ideal Candidate: - Extensive AI Development Experience: As the project demands the creation of a sophisticated LLM, prior experience in developing advan...

I need a one-time extraction of specific data from into an Excel spreadsheet. The task involves extracting all data for each date as far back as 1 January 2020. The end product is a long table in Excel also capturing the date of release. Key Requirements: - Extract earnings data that surpasses expectations from a specific website. - Transfer the extracted data into an Excel spreadsheet. Ideal Candidate: - Proficient in web scraping tools and techniques. - Experience in data extraction and manipulation. - Strong skills in Microsoft Excel.

I need a software developed urgently that can generate playlists on Apple Music. I can provide the Apple music song URLs in a Excel file as follows: ... I need to import the playlist into my Apple music player

Exciting opportunity for an excel whizz! I urgently require assistance with embedding photos into an excel sheet. Key Responsibilities: - Insert Photos: You'll be in charge of seamlessly integrating photos into an excel sheet. you should keep the same resolution Skills and Experience: - Excel Proficiency: Strong excel skills are a must. - Attention to Detail: Aligning photos properly within the sheet is critical. - Quick Turnaround: This project needs to be completed ASAP. Get in touch if you've got the passion and experience to deliver this project swiftly!

I am in need of a highly proficient Excel VBA developer who can implement and automate complex data analysis, and generate reports from large volumes of data. Key Tasks: - Implementing intricate data analysis using Excel VBA scripts. - Automating repetitive data management tasks. - Designing and developing report generation tools. This program will be used by a mix of both internal and external users. Therefore, the created solution should be intuitive, user-friendly and reliable. Essential skills: - Proven experience in Excel VBA programming, dealing with large complex sets of data. - Strong understanding of data analysis techniques. - Capable of designing user-friendly interfaces for report generation. This is a challenging and vital proj...

I need immediate assistance with converting 50 invoices into an Excel sheet. The information to be transcribed includes the following columns: Date, CIF, Company Name, and Amount. Ideal Skills: - Proficiency in Excel - Attention to detail - Fast and accurate data entry skills The project has to be completed within 1 day. No specific formatting requirements are needed at this time. Once completed, I will review the Excel file.

I'm immediately needing a skilled computer operator who could expertly manage data entry tasks, file management, and maintain our database. You must be proficient in utilizing Microsoft Excel, Google Sheets, and QuickBooks. Key Duties: - Accurate Data Entry - Efficient File Management - Consistent Database Maintenance Preferred Skills and Experience: - Proficiency in Microsoft Excel, Google Sheets, QuickBooks - Fast yet accurate typing skills - Strong knowledge in File Management and Database Maintenance - Good time management skills Your ability to deliver quickly is essential as I require this project to be completed ASAP. Please provide proof of your skills in your proposal so I can make an informed decision. I greatly appreciate your interest and look forward to p...

...professional assistance with filing my crypto-related tax returns, as well as reporting mining income. Key Requirements: - Filing Tax Returns: I require a skilled individual who can accurately file my crypto-related tax returns. This person should have a deep understanding of the tax laws in Norway and how they apply to cryptocurrencies. - Reporting Mining Income: Another crucial aspect of this project is assistance with reporting my mining income. This requires someone with experience in crypto mining and tax reporting. Ideal Skills and Experience: - Taxation: A professional with a background in tax consultancy or similar field, particularly with experience in crypto tax laws. - Crypto Mining: Understanding of how mining works and its tax imp...

I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.

I'm looking for an expert in Excel data handling and financial analysis with special attention to franchising businesses. The end-goal is to develop a user-friendly, dynamic Excel document for cross-comparison of various franchisor fees, charges, and costs. Key Tasks: 1. Data Entry: Populate the document with the provided profit and loss data. 2. Categorization: Organize costs by frequency of occurrence (monthly, yearly, etc.). 3. Analysis Tools: Implement features to run various cost analysis scenarios with a focus on comparing costs between different franchisors. A back ground document that I can change that clearly show in $ cost the difference and in visual Competitive analysis comparison document Ideal freelancers should have an understanding of financial managem...

I'm in need of a highly proficient Excel specialist who will perform a series of tasks for me. Specifically, these include: - Data Analysis: Probing and evaluating a medium-size dataset (between 100-1000 rows) to derive meaningful insights. - Spreadsheet Formatting: Improving aesthetic appeal and readability of my spreadsheets. - Formula Creation: Establishing useful formulas to automate computations and functions. The entire project needs to be undertaken in Excel 2016 or later, therefore familiarity with this version is essential. Experience in data analysis and spreadsheet management is also expected. If you're an Excel whiz, I'd be eager to hear from you.

I have code for login trading accound and fetch token data. I need to update code I need to collect live data from the web and candle stick, I have attached the document for data collection from web. Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Please view the attach file. I need an intelligent programmer, who can see future problems and solve them clever and independently. Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the pa...

I need a freelancer to assist me with a small financial calculations task in Excel. - The work is focused on financial calculations, so experience in this area would be highly beneficial. - The task isn't extensive, but I need someone who is detail-oriented and can ensure accuracy in the calculations. - I'm open to seeing examples of your past work, particularly if you've done similar tasks. Please apply with your relevant experience and a brief explanation on how you would approach this task. Need it by today

I'm looking for a freelancer to help with the data entry of a combination of text and numerical data into an Excel sheet. The data will be provided in digital text files. Key Requirements: - Proficiency in Excel and data entry - Attention to detail - Ability to accurately enter both text and numerical data Experience in similar projects will be an added advantage. Please include any relevant samples or references in your bid.

I need a logo designed for my upcoming construction company. The logo must embody a professional and elegant vibe. There are specific requirements for this task: company name “VBA Construction” - Primary Colors: Blue and Gray should be the main colors for the design. These colors should be used in a balanced way that conveys a sense of class and sophistication. - Additional Designs: Beyond the logo, I'll need a few related designs for social media and web posting. These should carry the same stylistic theme as the main logo. - Timeline: I'm in a hurry. The design should be completed ASAP. Ideal candidates for this job are experienced in creating professional logos that work well across different platforms. They should have a good understanding of balance and...

I'm looking for a graphics expert who can convert a PNG file and make its text editable. Your responsibilities will primarily involve: - Creating an editable file where the text can be easily modified Being proficient in graphics editing software is required, although no specific software has been stipulated. Experience in Adobe Photoshop, GIMP, or CorelDRAW will be favorable. The right candidate should demonstrate a good understanding of image formats and modifications along with proven experience in delivering similar projects.

I'm in need of a skilled typist with a minimum typing speed of 50WPM to transcribe online content for personal use. Key Requirements: - Proficiency in English language. - Minimum typing speed of 50 words per minute. - Able to adhere to specific formatting requirements. The ideal candidate should be able to ensure that the content is accurately transcribed and formatted according to my specifications. Experience in transcription and a good understanding of English language is essential for this task.

I need assistance with Excel to create multiple rules for a specific column in my spreadsheet. Here's what the project entails: - Developing rules based on cell formatting - The rules will be used to match multiple cells within the column following 5 specific criteria sets - The rules will be custom formulas specially designed for this task Ideally, you should be expert in handling Excel advanced features, specifically custom formulas. If you have experience in creating complex Excel tasks, that would be an added advantage. The ultimate goal is to automate the process where specific data is matched and inserted in another column.

...with a primary focus on the mining industry and local works. I am in need of professionals who can help me in several areas: - Regulatory Compliance Assistance: I want someone who has a solid understanding of the legal regulations and compliance requirements that pertain to the mining industry, both on a local and national level. - Business Plan Development: I need assistance with drafting a comprehensive business plan. This includes help with vision and mission development, strategic planning, financial planning, and competitive analysis. - Marketing and Client Acquisition Strategies: I am seeking guidance on how to attract and retain clients, gain market visibility, and establish a solid reputation within the industry. Our services would revolve around mining...

I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.

I need a market research-oriented individual with an expertise in data mining and web scraping. The project entails extracting data from the website harborfreight.com. Specifically detailing: - Product names - Product price - Product type (IE power tools) - Their associated number of customer ratings These details should provided in a CSV file then be categorized by product type. A strong understanding of categorization and proficiency in scraping complex websites will be beneficial. With this data, I intend to carry out detailed market research. Do not worry about descriptions, focus solely on the product names, price, rating numbers, and categorization. I'm looking forward to seeing your proposals if your skills align with these needs.

I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.

I have an ongoing project that involves the entry of text data from online sources directly into our website. Key Project Details: - Type of Data: Primarily text-based information - Data Source: Online sources - Organizational Structure: Directly input into our website Ideal Skills and Experience: - Proficiency in data entry - Experience with text-based data - Ability to navigate and use online sources - Attention to detail - Website data entry experience is a plus Please bid with your relevant experience and expected rates.

Your task involves application of k-Means clustering in Orange data mining software with the aim to segment and profile the churners in Customer Churn file. By applying the k-Means clustering you need to explore how many types of churners exist and what characterizes those types. More specifically, this assignment consists of two tasks:  Task a (Segmentation): Establish how many types of churners there are and the size of those types. This involves dividing the churners into segments.  Task b (Profiling): Profile and appropriately name the identified types of churners based on the values of their shared characteristics, i.e. variables. Your submission ought to include: 1. Orange workflow1 containing the k-Means clustering analysis of segments and profiles. 2. Summary file (max