Vba extract data website jobs
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...
...directories. The role involves pinpointing vendors that provide accessibility services, such as video captioning and sign language interpretation, which are complementary to our consulting offerings. The specialist will evaluate these vendors to determine potential collaboration or contracting opportunities. Responsibilities: Access British Columbia and Federal Government procurement databases to extract a list of vendors offering specific accessibility services. Assess each vendor's service offerings to determine compatibility with our consulting goals, particularly in enhancing Deaf accessibility. Compile a comprehensive list of potential partner vendors, including detailed contact information and a strategic rationale for initiating contact. Provide a final report th...
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...
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...
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
I'm looking for an expert to assist with an important aspect of my Autocad project - calculating the material needed for ducts from drawing to excel sheet. Your main task will be to extract the dimensions and quantify each type of duct in the drawing. Key Responsibilities: - Extracting precise information from Autocad drawings - Accurately entering data in Excel for duct types and dimensions Skills and Experience: - Proficiency in Autocad and Excel - Strong understanding and experience in drafting and design - Excellent attention to detail - Experience with duct design or HVAC systems would be advantageous. Please note, material types are not specified for the ducts. This project primarily focuses on quantity and dimensions.
I'm seeking a proficient individual to help with a data entry project. I have about 40 URLs, from which I need to extract the product names, prices, and descriptions. The goal is to collate this information in a pre-defined Excel template. Key Aspects: - Extract product names, prices and descriptions from 40 URLs. - Populate an Excel file with the gathered data.
I'm seeking a skilled professional to help me with a research project. The specific deliverable is to find and provide 1,000 email addresses from Apollo. Key Requirements...professional to help me with a research project. The specific deliverable is to find and provide 1,000 email addresses from Apollo. Key Requirements: - Industry: The contacts should pertain to the industry I'll list for you. - Freshness: Email addresses need to be less than 3 months old. Ideal Skills: - Strong research skills: the ability to efficiently navigate through Apollo's platform to extract relevant email addresses. - Attention to detail: ensuring that the email addresses are recent and accurate. - Good understanding of various industries: to assist in collecting contacts aligned wit...
...multi-level marketing (MLM) databases, as well as knowledge of Dolibarr ERP. We need someone who can understand the complex terms associated with MLM compensation plans and create effective SQL queries to extract the necessary data, as well as integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requirements: Demonstrable experience in SQL and PHP. Deep knowledge of relational databases and experience in query optimization. Previous experience wo...
In this project, I'm needing assistance to extract text data from printed documents and entering it into Google Sheets. This task involves meticulous attention to detail to ensure the accuracy of the data entered. The project requires a freelancer with strong data entry skills and the following qualifications: - Proficient in Google Sheets and Microsoft Excel - Excellent typing speed - Previous experience with data extraction - Ability to work with printed documents - Good at data categorization and organization - Proven track record of accuracy - Strong attention to detail If you have these skills, please bid for this project. Thanks in advance for your time and effort.
One excel file with macro as per the customer requirement
I need a skilled developer to create an automation bot for Telegram Channels. This bot will have the essential functions of: - Auto-joining channels - Extracting basic channel information including the description and links I want the bot to be able to extract the following specific information from the channels it joins: - Channel Name - Channel Description - Channel Links - Member Count The frequency of this extraction should be set to a weekly basis. Ideal skills and experience for this job would include proficiency in Python or a similar programming language, previous experience with Telegram's API, and prior experience creating chatbots or automation bots. Expertise in web scraping technologies is also a must.
...handling sales inquiries and tracking orders. * **Chatbot Features** - The chatbot should be capable of handling customer support tasks, answering sales inquiries and tracking orders seamlessly. * **User Interaction** - The chatbot needs to be user-friendly for both Stone Crusher Owners and customers. * **Database Interaction** - The bot should interact with our MySQL database to extract data when needed. It doesn't need to update the database, just fetch necessary information when required. * **Skills and Experience** - Strong background in AI chatbot development. - Experience with Gen-AI platforms. - Proficiency in working with MySQL databases. - Knowledge about Stone Crusher operations would be a bonus. * **Sample QA** User: What is Ad...
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 for 2023-11 and 2023-12 from this academictorrents link: https://academictorrents.com/details/9c263fc85366c1ef8f5bb9da0203f4c8c8db75f4/tech&filelist=1?stats=True. 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.
We are searching for a highly skilled and experienced developer to assist us in building robust API integrations using CloudQuery. Our project involves extracting and integrating data from various sources into our system for advanced data analysis and reporting. We're looking for a developer who can effectively use CloudQuery to build these integrations in a scalable and efficient manner. Key Responsibilities: Design and implement API integrations using CloudQuery. Be able to write DBT transformations. Extract and manipulate data from various data sources (SQL, NoSQL, APIs, etc.). Ensure the integrations are scalable, efficient, and maintain high performance. Collaborate with our team to understand requirements and provide technical solutions. Writ...
...marked as spam. Your past freelance feedback should clearly show that you have completed similar tasks. I require a specialist in web scraping to extract the body text from articles on Google News. The information will be earmarked for natural language processing, hence, accuracy of extraction and correct formatting into an excel file is of utmost importance. Key responsibilities and skills: - Experience in web scraping, specifically from news websites. - Knowledge of creating Python or PHP scraping scripts or using API. - Ability to deliver results fast, as the project needs to be completed ASAP. Please note that the sole requirement is to extract the body of the news articles with no need for the title, date or author. Let me know your approach and estimated timefra...
I'm in need of a video editor with a knack for making videos sleek and engaging. The footage is a bit over 10 minutes long; thus, I need someone who can extract the most engaging parts, making it concise and appealing. Key Requirements and Responsibilities: - Trimming and cutting footage while maintaining the video's essence and message. - Incorporating calm and peaceful background music. The music's style should align with the video's content to ensure a seamless watch experience. Ideal Skills and Experience: - Proficient in video editing software (e.g., Adobe Premiere Pro, Final Cut Pro, etc.). - Prior experience in creating concise videos from longer footage. - A good understanding of music selection to create a cohesive video experience. If you're co...
We are looking for an expert in Machine Learning to help us extract value from our data. Ours is a data-intensive project demanding heavy analytics and normalisation of textual, numeric and image data RESPONSIBILITIES Understanding business objectives and developing models that help to achieve them, along with metrics to track their progress Develop scalable infrastructure that automates training and deployment of ML models Managing available resources such as hardware, data, and personnel so that deadlines are met Data visualizations and data comprehension Brainstorm and Design various POCs using ML/DL/NLP solutions for new or existing enterprise problems. Work with and mentor fellow Data and Software Engineers to build other parts...
I need a proficient data miner to help me extract student leads from the following websites - , college , , , mbauniverse.com. Key Information to Extract: - Student contact numbers As I require this data urgently, a prompt turnaround time is essential. Freelancers should possess the following skills and experience: - Expertise in web scraping - Familiarity with the aforementioned websites - Can deliver a high level of accuracy - Can ensure data is categorized correctly. Applications from freelancers who can demonstrate past experience in similar projects will be looked upon favorably. Immediate availability is preferred due to the urgent nature of this project.
Hi, The task is to scrape a pdf that is downloaded on website. Steps: 1. Go to website 2. Enter code in search and click search. (We provide list code) 3. On the results page Click on pdf document and open or download it 4. Extract 14 pieces of data from the PDF and export into excel sheet. There are about 150.000. Some codes do not have any data then skip. I have attached a word document with pictures and flow for you to review. Thanks!
I'm looking for a skilled developer to build me a web scraper for the Kumon UK website. The scraping needs to be able to: - Extract the names of tutors - Retrieve their addresses - Fetch contact information like phone numbers or email addresses The scraping process should be set to run just once, and must be accurate and reliable. The data should be presented in a structured format, ideally a XLSX file. Please provide an overview of your experience with web scraping and any similar projects you've worked on.
I am in immediate need of a Python expert who can extract data from external website and store in an MS SQL database. freelancer with extensive experience in data extraction from varied sources would be highly desirable. The skills and experience required for this job includes: - Extensive knowledge on Python-based data extraction methods - Proven experience with managing and manipulating MS SQL databases - Ability to adapt to multiple and potentially unexpected data sources - willing to work via anydesk for final installation of the project Given the urgent nature of this project, only those who can demonstrate a commitment to quick turnaround times need apply.
I need an experienced data scraper to extract specific financial information from the NASDAQ and HKEX stock markets. Your task will be to focus on: - Stock prices - Company financials - Last 5 Years ROE - Last 5 Years EPS - NAV - P/E Ratio - P/B Ratio -Net Cash Flow Other economic indicators(US & HK) -Interest rate -Unemployment rate -Inflation rate The ideal freelancer for this job should have experience in data scraping and familiarity with financial data. The requirements involve pulling data from the past five years. All data should be delivered in a CSV file format. The ability to achieve high-accuracy and precision in data extraction is critical for this role.
...marked as spam. Your past freelance feedback should clearly show that you have completed similar tasks. I require a specialist in web scraping to extract the body text from articles on Google News. The information will be earmarked for natural language processing, hence, accuracy of extraction and correct formatting into an excel file is of utmost importance. Key responsibilities and skills: - Experience in web scraping, specifically from news websites. - Knowledge of creating Python or PHP scraping scripts or using API. - Ability to deliver results fast, as the project needs to be completed ASAP. Please note that the sole requirement is to extract the body of the news articles with no need for the title, date or author. Let me know your approach and estimated timefra...
Everyday I have to extract some datas from around 100 invoices (PDF files) and copy it to an Excel file. I do it manually (copy/paste), but I need a tool to have it done automatically. These invoices have a consistent format structure, and the fields I need to copy to Excel are always the same. They are informations like: invoice number, date, customer's name, product code, price, etc. All the fields that need to be on Excel are highlighted in color red on the 2 files I'm providing as an example. Any other info not highlighted in red, doesn't need to be on Excel file. The automation process must execute without fail, ensuring that the location of highlighted fields - which are always the same in every file - does not affect the extraction. The only difference you�...
...developer to create a desktop application that will allow me to access artist reports from Spotify and manage playlists easily. Key requirements and tasks include: - Desktop Application: The application should be desktop-based, enabling me to efficiently access and interact with Spotify artist data. - Playlist Management: The application will be designed to build and maintain playlists from a FileMaker database, which I have already set up. The tool should allow for seamless playlist management based on the data present in the database. - Spotify Artist Report Access: The primary functionality of the application will be the extraction of artist reports from Spotify. The reports will be related to a variety of indie bands. It's crucial that the developer can integrate...
As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to delivering high...
I'm seeking a skilled developer to take my existing demo code and bring it to the next level. The application is web-based and is intended to automate the extraction of data from Word and Excel documents, and then compare the data for consistency. Key Responsibilities: - **Improved Data Extraction Accuracy:** The code should be enhanced to improve the accuracy of the data extraction process. The developer should implement robust methods to ensure that all necessary data is correctly captured. - **Enhanced Comparison Algorithm:** The comparison algorithm should be optimized to better handle the extracted data. The developer should ensure that the comparison is done accurately and efficiently. - **User-Friendly Interface:** The current demo cod...
MATLAB USERS Visual Processing and Object Detection: The first task will be to detect and segment objects in images using traditional computer vision methods. It will be necessary to automatically separate the balls from the background and evaluate the accuracy of the segmentation. Feature Calculation: The second task will be to extract texture and shape features. By using appropriate algorithms to calculate the shape attributes of the balls, it will then obtain textural attributes with gray level collaborative matrices. Object Tracking: The third and final task will be to track the movement of a ball by applying a Kalman filter. Working with real and noisy coordinates, it will create a tracking algorithm and compare the tracked path with the real one. summarize this in 250 words
I am urgently in need of an expert in Data Build Tool and SQLite database who can efficiently develop a data pipeline. The pipeline will handle extracting all files from a specific folder location on my local drive. The goal here is to create a pipeline that can universally extract all types of files. Ideal Skills and Experience: - Proficient with Data Build Tool - Extensive knowledge of SQLite database - Prior experience with data extraction projects - Quick turnaround time - Ability to work with local storage systems This is a two-hour assignment and the steps required for the task are detailed in the document provided. Your quick assistance is highly appreciated!
Need to extract data from website: , into an Excel file. Specifically name, discipline (medical practitioner, midwife, nurse, OT, physio, psychologist, podiatrist), location (incl suburb and postcode), initial registration date, registration expiry. There would be at least 100,000 rows of data. Only barrier, is this data is not able to be 'searched' efficiently. Individual names can be looked up. Or disciplines with a select number of names demonstrated...but I can't find a way to show ALL clinicians at once. Looking for a solution which can reliably pull all the names from the database.
I require a freelancer to extract and consolidate numeric data from existing databases. The data should be transformed and presented in a workable database file format. Key responsibilities include: - Extracting data from various data sources - Ensuring data integrity and quality - Transforming the data into a database file format Ideal Skills and Experience: - Proficiency in database management and data extraction - Strong understanding of data transformation - Attention to detail and precision - Ability to ensure data quality and integrity - Prior experience working with numeric data is a plus.
I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.
Specification: Facebook-Web-Scraping and Web-Crawling Write Swift Code that prompts the user to give username and password This information is used to login to facebook and scrape facebook for facebook friends and extract the following information: - Name - Birthday and month and if available year - Gender This information should be made available in a JSON or XML format. The code will be embedded in an app. It is important that this web-scraping activity can run in the background of the app invisible to the user.
I need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace inc...list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creating tools that can handle daily data updates would be ideal. If you have experience with similar projects, p...
...expert who can continuously build and manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for...
I'm looking for a skilled freelancer who can help me with importing product data from XML sheets. The data needs to be imported into multiple Prestashop faced search feature tables. Key project details: - I need the product information to be imported - The data needs to be updated daily and in real-time - Multilingual support is not required, so a single language is sufficient Ideal Skills and Experience - Proficiency in working with XML data and importing it into systems - Expertise in Prestashop and its search feature tables - Experience with real-time data updates in web applications - Strong problem-solving skills and attention to detail Import data from xml sheets into multiple prestashop faced search feature table. Here's an ou...
...freelancer who can help me with a data-oriented task. The project has two main aspects: - **Data Collection from Customer File**: The task involves searching for specific data (names and contact information, demographic information, purchase history) of customers on a sample customer file. The collected information will then be organized by customer name. - **Website Data Scraping**: In addition, the freelancer will be responsible for scraping data from a website. The main focus here will be customer data who use online payment methods. The specific data we're looking to extract is the 'Payment method'. This information will then be organized by customer name. **Ideal Skills and Experience:** - Stro...
In this ...attractively laid-out business website with an engaging logo. - Building WP website (responsive design, one pager) from already purchased WP theme (). Using same sample FONTS, photos and design. Adding some icons if necessary, favicon and other design elements. - Creating simple LOGO to fit in website design (black on white and white on black), vector file - WP extract files with plugins needed at the end. Ideal skills and experience needed: - Experience in WordPress (WP) website design - Proven track record in designing for a professional target audience - Proficient in creating an intuitive user interface - Graphic design skills, specifically for logo creation - Experience in incorporating product/service showcases in website design...
