Vba data extract vba jobs

I urgently need an experienced web scraper who can extract data efficiently from multiple websites. Applicants' guidelines are as follows: 1. Websites for Scraping: Due to security concerns, the websites to be scraped will only be shared with the selected freelancer. 2. Application Contents: I didn't explicitly mention what I want freelancers to include in their applications. However, demonstrating your skills, experience, and past work related to web scraping will surely be a significant advantage. 3. Project Deadline: I require this project to be completed as soon as possible. Please include your estimated completion date in your proposal. Ideal Skills & Experience: - Proven experience in web scraping - Knowledge of Python, Selenium or other scraping tools...

...will parse, extract, and vectorize content to understand issues. An explainable ML model like LIME will then diagnose the problem and provide steps, code samples, etc to resolve it. The LLM will be RAG augmented based on a vector protocol of a list of sites to augment the LLM. Key Criteria for Success: Robust technical execution that meets core requirements Modular, extensible architecture for flexibility over time Quality, well-tested code delivered on time Clear, prompt communication throughout project Key Components: Text/file ingestion and vectorization Semantic similarity search in Milvus/SPTAG Local post-hoc model explanations Production-ready Flask/FastAPI UI Documentation and usage guides Document Ingestion (spaCy, Beautiful Soup, PyMuPDF): Scrape/ingest docs, extrac...

...seeking an experienced data scientist and analyst to support me in improving my business operations through a data-driven approach. The project will involve tackling tasks across data cleaning, statistical analysis, and data structuring and algorithm implementation. Ideal Skills and Experience: - Proficiency in data cleaning and preprocessing to ensure that the data is in its most usable, accurate, and complete state. - Strong statistical analysis and modeling skills to extract meaningful insights and make accurate predictions. - Excellent experience in structuring data and implementing algorithms that are tailored to business needs. Data Sources: - Social Media Data: You should be comfortable working with a variety...

...institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements without disrupting existing functionalities. Key Features to Include: Advanced User Management: Implement a secure login system with multi-tier user roles and permissions. Dynamic Data Handling: Design the system to manage large volu...

I need a skilled freelancer to extract table data from a PDF file. The extracted data will be used for analysis in a Microsoft Excel spreadsheet. Key Requirements: - Extract tables from a PDF - Ensure data quality and integrity - Deliver the data in a Microsoft Excel format Ideal Skills: - Proficiency in PDF data extraction - Strong understanding of table structures - Experience in working with Microsoft Excel - Attention to detail and accuracy is crucial look attached PDF and EXCEL then Bid, start Bid writing PDF and sample attached. So I know you look my file

...professional who can help me extract specific data on the results of the Tokyo 2021 Paralympic Games from the official website - The data I require includes: - Athlete profiles - All the results of each competitor - Medal winners The extracted data should be presented in a CSV file format. It should be in a similar format as this dataset on the results of the Olympic games: No specific analysis is needed on the extracted data. Ideal skills and experience for this job include: - Proficiency in web scraping - Experience in data extraction - Expertise in data formatting and CSV files Your professional approach and ability to deliver accurate, complete data will be crucial. Please

...Description: We are seeking a skilled Freelance Full Stack Developer with experience in AI technologies, web development, and data processing to build an automated pipeline for creating AI images. The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external AP...

I am seeking an experienced developer to create a website scraper which is capable of collecting various pieces of data. This savvy tool must be designed to extract from () site: - Text content - Images - Product information - Address - Contact details - Videos It is essential for the scraper to perform its task on a daily basis. Yet, there won't be a need for the gathered data to be automatically integrated into a database. Ideal Skills: - Web scraping - Developing scraping bots - Programming knowledge - Manual data mining expertise Please only apply for this job if you have significant experience in creating web scrapers. This project requires a quick turnaround, so the ability to work under time constraints is key. Let's converse about specific...

I'm in need of a skilled data analyst to conduct a thorough regression analysis using panel data in R. The primary goal is to understand the impact of one variable on another within a dataset that includes between 6-10 variables. Key Project Requirements: - Utilize panel data: Experience in handling panel data is a must for this project. The ability to understand the nuances of this data type will be crucial for accurate analysis. - Regression Analysis: In-depth knowledge of regression analysis is required, especially in the context of panel data. The ability to extract meaningful insights and estimate the impact of one variable on another is the core task. - Data Interpretation: The successful freelancer will be able to provid...

I am seeking a proficient data scientist to help me extract and analyze information within the Bangladesh construction industry. This project focuses on market trends, industry analysis, and project specific statistics. This project's primary intent includes: - Uncovering market opportunities - Competitive analysis within the construction sector The findings will be utilized for: - The development of robust marketing strategies - Making data-driven business decisions Ideal candidates should have prior experience in data mining within the construction industry and have a solid understanding of market analysis and project statistics. Previous work within the Bangladesh market would be advantageous.

We are looking for a freelancer with strong web scraping experience for an exciting and challenging project. We need to gather specific data from multiple online sources and transform it into useful, structured information for analysis. Responsibilities: Utilize web scraping techniques to extract data from selected websites. Automate the extraction process to ensure accuracy and efficiency. Clean and structure the collected data into readable and usable formats. Integrate the extracted data into a database or spreadsheet as needed. Collaborate with our team to understand specific requirements and ensure the quality of the obtained data. Requirements: Demonstrable experience in web scraping using tools like Python (Beautiful Soup, Scrapy), Seleni...

...designed to integrate data from various advertising platforms, website activity, CRM, and Marketing Automation Platforms (MAP) to provide a unified view of marketing performance. We require a highly skilled and efficient Data Engineer or Architect who can handle data export processes, model and create tables and entity relationships, and develop an efficient and scalable database within a tight one-month deadline. ### Responsibilities: - Data Integration: connect and streamline data from multiple sources including ad platforms (like Google Ads, Facebook), website analytics tools (e.g., Google Analytics), CRM systems (e.g., Salesforce), and MAPs (e.g., HubSpot). - **Accelerated Database Design:** Design and implement a robust and scalable database that...

I need a web scraper to extract specific data from various websites. The project will involve: - Identifying the necessary data to be scraped - Building a scraper to extract this data Ideal skills for this job include: - Proficiency in web scraping tools - Familiarity with web data extraction techniques - Ability to work with and extract data from various websites Please provide your quote for this project.

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.

...looking for a skilled web scraper who can extract detailed information regarding the sellers on the Miravia website. Requirements: - Extracting Seller Data: The main purpose of this project is to gather information about the sellers on the Miravia platform (). This includes the shop_id shop_name Ivl1_cate_name product_number avg_price shipping_duration company_location phone_number email_address vat_number company_name shop_rating shipping_on_time % followers comments etc. I require 10,000 entries of data I require the data to be well-structured and organized into a CSV or Excel file for further analysis. Skills and Experience: - Proficiency in Web Scraping: The ideal candidate should have extensive experience in web scraping and data extraction....

...number ... - the time position/time code ... - the data detected ...... - e.g. the sharpness and this should be outputed in a JSON file per video file. Ideal Skillset: - Proficiency in Python - Experience with video processing libraries (like OpenCV, PyAV, or MoviePy) - Experiences with OOP (classes and lists) - Familiarity with JSON output format. Milestones: MS1: provide python OOP module to measure the blurness & sharpness quantification of images and videos data will be written in same filename but with .json as extension we will share you testing images and videos 2 modes required - demo mode with showing the video+persisting the demo video - performance mode, which only processes the data MS2 same as MS1, except now you extract the differe...

...should be able to provide real-time monitoring and reporting of cash flow changes. User Data Input: - Integrating with Accounting Software: The tool should allow users to input their financial data by directly integrating with their existing accounting software like quickbooks. Ideal Skills: - Proficiency in SaaS tool development using a no code tool flutterflow - Experience with real-time data processing - Previous work on financial reporting tools - Familiarity with integrating systems with accounting software User journey - Register with Google account - link with accounting platform like Quickbooks (1 click integration) - Extract data and save the data in AWS securely - Do some calculations on the data (we will provide it) - Di...

...freelancer who can work with OpenStreetMap data to extract specific elements and format them into a .csv file. Key Requirements: - Extracting Geographical locations: ID (from OSM), ZIP, City, District of City, Federal State, District, Street, Housenumber, Latitude, Longitude. If available the Community and the Code of the Community The dumpfile is on: The Download and Format-Process should be automated and if possible triggered with a download Button on an HTML Page. By clicking on the Download button, the process of formating the OSM into .csv is startet. Coding of .csv should be UTF-8 Ideal Skills: - Proficiency with OpenStreetMap data and extraction tools. - Experience in formatting data into .csv files. This is a monthly project

I am looking for a professional who has experience in data scraping to extract email addresses of senior level employees in the Building Industry, specifically from the United Kingdom. This task involves collecting the email addresses of 100 senior level employees. Key Requirements: - I need the first name, job title, and email address of each employee. - All the email addresses should be from the United Kingdom. The ideal freelancer for this project should have: - Experience in data scrapping and data mining. - Proficiency in tools and techniques for extracting data from web sources. - Attention to detail to ensure the accuracy of the collected information. - Familiarity with the Building Industry and the job titles associated with senior level roles i...

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 a skilled developer who can create a personalized Roblox script hub for the games Pet Simulator 99, Jailbreak, and The Survival Game. Key Requirements: - Decompilation: You'll be required to decompile the mentioned Roblox games and extract essential elements for the script hub. - Auto Farm Feature: Implement an auto farm feature within the script hub that works seamlessly across all the games. - Personalized Design: Design the script hub with a minimalist theme, ensuring it's visually appealing and user-friendly. User Interaction: - The script hub should offer a graphical user interface (GUI) for users to easily navigate and interact with. Ideal Skills and Experience: - Proficient in Roblox scripting and decompilation. - Experience in developing che...

I am looking for assistance in creating a visually engaging, professional PowerPoint presentation, using a provided style template, based on a 64 double side page Word document. Key details: - Extract key points and messages to form a summarized version of the Word document's content. - Encompass a range of 50 to 80 slides with a balance between text and relevant images to ensure readability and viewer engagement. - Align with pre-existing PowerPoint template aesthetic. Ideal candidate should have: - Excellent summarization skills and attention to detail. - Proficiency in PowerPoint. - Experience in creating engaging corporate presentations. Presentation would need to be done in 5 days

The machine learning component of this hybrid profile creation system in a Flutter app involves integrating a TensorFlow Lite model, possibly using DistilBERT for its efficiency and effectiveness in natural language processing tasks. The model's role is twofold: Text Analysis and Categorization: It processes user-generated text inputs and web-scraped content to extract meaningful insights, such as sentiment, key phrases, or categorization of interests. This helps in dynamically adjusting the user's profile to reflect their preferences and behaviors accurately. Usage Pattern Learning: The system tracks and analyzes app usage statistics to learn about user preferences over time. Machine learning algorithms can identify patterns in what features or content the user interacts...

Please Sign Up or Login to see details.

I'm in need of a skilled data miner who can help to extract certain details from a vast range of Shopify products. Your mission, if you choose to accept it, is as follows: - list products that contain non-English writing or words in text and videos - Organise and sort these findings for simple review - Identify and list any products filled with non-English language in the description, pictures or images - Compile lists of products that aren’t currently making top-seller lists - List any products can not be delivered in eight days or less. Please note that tractors and food vans may take up to two months to deliver. - List any products that are not suitable for industrial purposes/non-commercial products. Ensure that the products you are considering are meant for c...

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

I require an efficient solution to extract contact details, specifically phone numbers and email addresses, for newly sold residential properties.

...Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Office skills t...

More details: What format are the company names provided in? pdf Do you have the capability to extract text from the PDF files? Not sure How soon do you need your project completed? ASAP

...Python that can extract the SKU (product) list from the following Indonesian online grocery apps: - Astro - Sayurbox - Segari The scraper must be IP-block tolerant, meaning if the scraper gets blocked, execution can be continued from the point where the last row of data was successfully extracted. Scraper Functions Function: list_category_tree Input: competitor_name(astro | sayurbox | segari), existing_csv (optional - CSV file to append to for continuing execution, if the scraper stopped or got IP blocked) Output: CSV of category tree with the following columns (scrape_date, URL, category name, position index, parent_category (null if top level)) Function: extract_sku Input: competitor_name, location (autocomplete place from google maps API), category (optional - ...

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfac...

I'm in need of a developer who can create a n8n script to login to a specific website and extract stock data for multiple companies. Key features of this project include: - Extraction of table data: You should have knowledge and experience working with web data extraction, specifically with table data. - Selection of stocks data: The script should have the ability to select and extract information from the stock table. - Capability for multiple companies: The tool should be versatile to handle data extraction for multiple companies, not limited to just one. Experience in the use of n8n for data extraction from websites, especially in the finance sector, will be a significant advantage for this project. One of the p...

I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...

I need a professional to mine data for me. I need you to download and extract the submissions and comments from a public Reddit dataset for 40 subreddits that I will give you. - Data Collection: Please extract the submissions and comments from this academictorrents link: https://academictorrents.com/details/56aa49f9653ba545f48df2e33679f014d2829c10/tech&filelist=1 I only want the comments and submissions for specific subreddits that I will supply to you. Please save the extracted data as csv file. - Frequency: This is a one-time job. Skills and Experience: - Torrent download and extraction.

...have a tool developed that can accurately scrape specific data from Airbnb and AirDna. The aim is to retrieve information about rental prices, occupancy rates, and property descriptions, etc. Key Features: - Efficient data scraping: The tool should successfully extract rental prices, occupancy rates, and property descriptions from Airbnb and AirDna. - Localized scraping: The data scraping should be focused on a specific city, which will be revealed once the project commences. Use of Data: The scraped information will be primarily used for market analysis purposes. The data will be instrumental in helping me understand the dynamics of the rental market within the specific city. Skills & Experience Required: - Proven experience in data...

...are in search of a skilled freelancer proficient in web scraping with Scrapy to extract product data from This project involves scraping the Category page to retrieve product details including name, price, SKU, URL, breadcrumb, currency, and brand. Targeted webpage: Category page of Required data: Product name, price, SKU, URL, breadcrumb, currency, and brand Experience: Prior experience in scraping product-related information from e-commerce sites is essential, with proficiency in Scrapy being crucial for accurate and efficient data extraction. Data Handling: Ability to ensure accuracy and consistency of extracted data. Familiarity with different data formats is advantageous. Dynamic Scraping: Navigation logic for all categories must

...tracking visitor data, and can help me in capturing contact information of potential customers who do not complete any forms on the site. Key Requirements: - Advanced Visitor Data Collection: The system should be able to capture details like device type, referral source, behavior patterns, and time on page for all visitors. - Contact Information Extraction: The primary goal is to extract the contact details (Name, Address, Phone, and Email) of the visitors who do not submit any form on the site. Ideal Skills and Experience: - Proficiency in Third-Party Tracking Services: The selected freelancer should be well-versed with various third-party tracking services and should be able to recommend and integrate the most suitable one for my website. - Expertise in Visito...

I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.

...number ... - the time position/time code ... - the data detected ...... - e.g. the sharpness and this should be outputed in a JSON file per video file. Ideal Skillset: - Proficiency in Python - Experience with video processing libraries (like OpenCV, PyAV, or MoviePy) - Experiences with OOP (classes and lists) - Familiarity with JSON output format. Milestones: MS1: provide python OOP module to measure the blurness & sharpness quantification of images and videos data will be written in same filename but with .json as extension we will share you testing images and videos 2 modes required - demo mode with showing the video+persisting the demo video - performance mode, which only processes the data MS2 same as MS1, except now you extract the differe...

I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.

For this project, I require an expert who can efficiently extract text content from two distinct webpages and input my data into an Excel file organized by rows. Given that all types of data hold equal importance to me, of essence is for the professional to: - Accurately scrape all text content from the specified webpages - Ensure no data is skewed or omitted during this process - Neatly organize the data by rows in the Excel file The ideal candidate for this job should be proficient in web scraping tools and techniques, possesses an acute attention to detail, and is experienced in using Excel to ensure data is properly formatted and easy to analyze. Please note that minimizing errors during this process is critical, as the data collected...

Please Sign Up or Login to see details.

I'm looking for a proficient practitioner in Tensorflow and machine learning to help develop a solution based on image and video data. Here's what I need: - Design and train a machine learning model that can extract meaningful information from our data. - The model should be capable of scene recognition in video and images. Your solution needs to reliably and accurately identify and classify different scenes. - You should be comfortable working with Tensorflow and have a solid understanding of its capabilities and limitations. Ideal skills and experience: Tensorflow proficiency, solid training in machine learning, experience in working with image and video data, and expertise in scene recognition algorithms. Your proposal should detail your plan ...

Project Description: I am looking for a skilled Data Analyst to help develop a system for classifying email messages as SPAM or HAM. This involves downloading data from a public source, processing it to extract and compute various features, and analyzing these to determine patterns indicative of SPAM. Responsibilities: Download email data from a specified public archive. Create R functions to extract and calculate over 20 variables from each email, such as the number of recipients, percentage of capitals, and URL presence. Analyze this data to explore variable relationships and determine SPAM/HAM status. Generate visual representations of the data and analysis findings. Provide a detailed report on the methodologies used, results obtained, ...

...extracting metadata from the images, not manually added. - **Output Format:** I need the final points to be saved in KML format, for easy integration into Google Earth. - **Quality Assurance:** Accuracy is key, the points should correctly represent the image positions. They will be broken into 3 colours depending on the date they were taken, the data is in the folder name and file name. Ideal Skills: - **GPS Data Handling:** Understanding of how to extract and work with GPS metadata from images. - **Google Earth Proficiency:** Experience in creating KML files and working with Google Earth is a must. - **Automation:** Familiarity with tools or methods that can automate the process of generating points from image metadata would be a significant advantage. I...

I'm looking for a proficient professional who can create a report in Microsoft Access from a MySQL database. The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work wit...

...Key Requirements: - Extract data from PDF files: The freelancer should have experience in data extraction from PDFs. The goal is to extract content like questions, answers, and any other relevant details. This extractor should be able to be used for different exam boards - Organize data by year, subject, and difficulty level: The extracted data should be categorized based on these parameters. This is crucial for our business as it will help us create a user-friendly interface for our educational platform. - Be able to build an extractor that can be run in a google collab notebook, using whatever packages required, even if large language models are needed. Ideal Skills: - Proficiency in Python - Familiarity with Large Language models for data...

I'...successful freelancer must be capable of performing high-quality data scrapings, potentially for lead generation, market research, or data analysis. As a dedicated data professional, you should have a strong background in web scraping, data extraction, and data analysis. Please be sure to include in your application: - Your previous experience and samples of past work - A detailed project proposal outlining your approach. Your proficiency in using software and tools for data scraping, knowledge of data protection laws, and understanding of various databases will make you a top contender for this project. Time management skills and meticulous attention to detail are also crucial. The goal is to efficiently and accurately extrac...

As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.

2 excel files with VBA macro as per customer requirement