Macro extract datacông việc

I'm looking for a skilled freelancer to extract specific content from an entire forum for me. The essence of this project involves collecting post titles, authors, dates, and the actual content from both the main forum and all of its subforums. **Scope of Work:** - Scrape post titles - Extract post authors’ names - Collect post dates - Retrieve the main content of each post - Cover all areas of the forum including main and subforums **Delivery Format:** - The scrapped data should be delivered in a JSON file. **Skills and Experience Needed:** - Proficiency in web scraping tools and techniques - Familiarity with JSON format - Ability to work efficiently without affecting the forum's functionality - Past experience with similar projects would be bene...

...existing CSV file. The list provides hotel names and their destinations, which should be used to accurately locate and extract the corresponding URLs. **Key Requirements**: - Ability to perform web scraping tasks efficiently. - Experience with handling CSV files. - Ensure accuracy and relevance of the URLs collected. - Deliver the final output by updating the existing CSV file with the new URLs without altering the original data structure. - Adhere to best practices to prevent being blocked by the website. **Ideal Skills and Experience**: - Proficient in programming languages suited for web scraping (e.g., Python with BeautifulSoup, Scrapy, or Selenium). - Familiarity with data processing and manipulation in CSV format. - Strong attention to detail to ensure the U...

As part of this project, I am looking for a professional who possesses specialized knowledge in python3 who can efficiently automate various hardware control procedures. Key Areas of Responsiblity encompass: 1. Automation: Utilizing Python3 to undertake automated commands for my project. 2. Hardware control: The capacity to control and extract information from my hardware appliances namely USB4 MCCI switch, Arduino, ALS, and IPPDU is of paramount importance. Ideal Skills and Experience: - Proficient in Python3 scripting - Comprehensive understanding of Ubuntu OS - Prior experience in the control of USB4 switch, Arduino, especially ALS and IPPDU - Advanced knowledge in hardware control and information retrieval. Please ensure a robust understanding of the project's requirem...

I'm looking for a skilled freelancer who can extract data from a video presentation and craft it into a PowerPoint format. Here's what you need to know: - The video duration is not important is in the video you will see the presentation , so it shouldn't be excessively lengthy. - There are about 58 slides in the video that will need to be created in PowerPoint. - Simple and minimalistic designs are preferred, so familiarity with clean and focused design will be beneficial. Ideal applicants will have experience with variety of data entry tasks, particularly transcription, and will have a keen eye for design and presentation format. Efficient, precise, and attentive to details are important traits for this task. Proficiency in PowerPoint is a must. Lin...

We have a project that requires proficient data entry skills. The successful freelancer must: - Extract and enter text data from digital files. - Ensure the data is accurate and well-organized. - Transfer the entered data into an Excel spreadsheet. Skill set requirements: - Proficient in data entry. - Detail-oriented and accurate. - Deep knowledge in Excel. - Ability to handle digital files with ease. Anticipating your valuable participation.

...lot of data to be run through 3 calculator to create approximately 2000+ reports. By way of background: - Approximately 1200 schools have had their lighting upgraded. - Each school has approximately 50-100 "rooms". - Each room typically has 1 type of light, but may have multiple types of light. - I will shortly have a spreadsheet which contains approx. 120,000 rows of data. - Each line of data has approx. 10 variables - space name, floor area, wattage of lamps, use type etc. - I need the data for each school (~1200) to be run through the IPD Calculator, CLCT Calculator and EVI reports. - For each school, I require a stand alone Excel file with the data completed and the name of the school in the file name - for eg "IPD Report - Carlton ...

...applications. - Strong understanding of natural language processing (NLP) to accurately extract information from various document types. - Ability to integrate the AI system with existing bank software for seamless document verification. - Knowledge of data privacy laws and regulations to ensure the AI handles sensitive information securely. Also, in addition to this, I will need to the AI to investigate bank documents, for any discretionary spending or expenses out of the norm, so that when the application process is progressing, questions can be raised by the credit assessor. Usually this is about 3-6 months worth of bank statements I would ideally like the software to have an import feature where the data will be imported into the program , to make it easier ...

I'm looking for an expert who can strategically utilize retrieval augmented generation to compile a table of data drawn exclusively from Wikipedia. There are three inputs: (1) a list of State names; (2) a position type (eg head of state, defence minister, foreign minister, etc), and (3) a date. The objective is to compile a table of the formal titles for each position in each state as of that date. In the first stage the program will need to prompt sequentially for each State and position type (eg What was the title of the head of state of Austria on 1 January 1970?) and extract the responses into a single data table where the first column is the name of the state and the second column is the formal title for the position. In the second stage the program will n...

extract company data from the site. Fields (where data is available) should include: company name, address, telephone, website, description, year founded, # employees, revenue (see figure 1 below). The app should run as a standalone app on

...Requirements:** - Integration with the Mercadolibre Chile API to extract property listings. - Fetch and display specific data for each property: price and location. - Present these properties as geolocated points on a QGIS map for easy visualization and analysis. **Ideal Skills and Experience:** - Proficiency in API integration, especially with Mercadolibre Chile. - Strong background in GIS and experience with QGIS software. - Ability to handle geospatial data and accurately map it. - Familiarity with real estate listings and related data representation. - Excellent problem-solving skills to ensure accurate data representation and easy-to-use interface in QGIS. This project is perfect for a freelancer with a knack for connecting disparate data...

Web based PDF interpreter with API capabilities. We want to be able to take Vendor quotes and invoice PDF's, and intelligently interpret them in a reliable way to extract all relevant company, contact, PO, and line items, as well as totals, tax, discount information, and format it into a standardized JSON object that can be ingested by our database. I've used ChatGPT to help outline the project as I see it with a recommended tech stack, based in Python. The tech stack is as follows: Python for backend development. Flask or Django for the web framework to handle web interface and API endpoints. Integrate PyPDF2 and PDFMiner for PDF parsing. Use Tesseract for OCR capabilities to process image-based PDFs. Employ an NLP library like spaCy for interpreting the document co...

...proficient in web scraping to extract valuable data from specific sites and social platforms. This project will be conducted once but may open the door to future collaboration based on the outcomes and insights gathered. Below, I've outlined the core aspects of the project requirements and the ideal candidate's qualifications: **Project Requirements:** - Expertise in Python programming, specifically with libraries suited for web scraping (e.g., BeautifulSoup, Scrapy). - Experience with data extraction from social media platforms. Knowledge of API limits and ways to ethically scrape data without violating terms of service is crucial. - Experience scraping data behind logins. - Ability to clean and organize large datasets for analysis. The goa...

I need a talented individual to extract and save my coaching portal’s practice material and test series. Your main task includes: - Access the material before it expires - Extract the material as it is - Do not alter or reorganize the material; simply save it as presented Ideally, you have a knack for detail, are familiar with formatting, and have exceptional data archival skills. Your ability to work swiftly and accurately will be essential here.

I'm in need of a detail-oriented coder proficient in working with Azure Resources. The desired output is a script capable of parsing Azure Resource metadata to accurately extract specific details. This includes: - Resource Name - Resource Type - Resource Location - Creation Date - Availability Configurations (comprising of Available State, Fault Domain, and Update Domain) Experience with Azure Resource Manager API is desirable as an added advantage. Your code should be efficient, clean and easy to interpret as I may need to make changes or updates in the future. Thus, knowledge of best coding practices is necessary. Ultimately, you should be able to deliver a script that performs the job swiftly and accurately. Looking forward to your contributions.

Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.

Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.

In this project, I am seeking a proficient web scraper to extract data from several county auditor sites. Critical information to gather includes property owner names, property addresses, and measurements from the Sketch Report available on those sites. This detail-oriented role ideally suits an experienced data extraction specialist that has worked with public property records before; familiarity with county auditor sites is an advantage. Key Project Tasks: - Access various county auditor websites - Accurately extract property owner names - Capture exact property addresses - Retrieve measurement data from the Sketch Report A successful result from this project will provide a comprehensive list of the targeted data, precisely compiled and read...

I am in search of a skilled data scraping specialist. Here's what I'm hoping to achieve in this project: - Extract comprehensive data from a select ecommerce website. The specific website will be agreed upon once we start the project. - The required data types to be scraped include product information, customer reviews, and seller details. - An ideal freelancer should have extensive experience in data scraping from ecommerce websites. Please include this in your application. Note the website blocked many traditional scrapping methods. we need experts only Looking forward to collaborating with an adept individual who can realize this effectively and efficiently. Your bid should reflect your comfortability and skill in tackling such tasks.

...a skilled freelancer to perform a one-time task of webscraping to extract text content from specified websites. The ultimate goal is to have this information neatly formatted into an Excel spreadsheet for my analysis. **Requirements:** - Proficiency in webscraping technologies and tools. - Ability to identify and extract specific text content. - Expertise in data formatting and Excel spreadsheet manipulation. **Ideal Skills and Experience:** - Strong background in Python, particularly with libraries like BeautifulSoup or Scrapy. - Experience with data extraction and web crawling. - Proficient in Excel formatting, including creating tables, applying filters, and using formulas. - Attention to detail to ensure accurate data extraction and formatting...

Looking for a skilled freelancer experienced in Android Studio using Kotlin and WebView for a web scraping project. The goal is to extract text and images from dynamic websites efficiently and accurately. **Key Requirements:** - **Expertise in Android Studio:** You should have a strong understanding and practical experience in developing applications with Android Studio. - **Proficiency in Kotlin:** Kotlin will be the main programming language used for this project, so you should have a substantial background working with it. - **Experience with WebView:** Since the project involves web scraping through WebView, familiarity with its nuances is necessary. - **Dynamic Content Scraping:** The ability to handle and scrape dynamic content from unspecified websites efficiently. While th...

...freelancer to handle a data entry project that consists primarily of text data. The candidate will need to extract this data from online sources I will specify and enter it into an Excel spreadsheet format with accuracy and efficiency. **Key Requirements:** - Proficiency in data entry with a keen eye for details. - Strong experience in handling text data. - Excellent knowledge of Excel and its various functions. - Ability to source data online and discern what is relevant. **Desired Skills:** - Fast typing speed with high accuracy. - Experience in web research. - Familiarity with data entry protocols and spreadsheet management. - Good organizational skills to handle data in a logical and accessible manner. The perfect ...

I need a proficient developer to enhance our current Laravel site feature for a registration-based event. Registered users should receive a personalized invitation card via email, with their names dynamically inscribed. **Core Requirements:** - Extract names entered by users during event registration. - Generate a PDF invitation card for each user with their name dynamically printed on it. - Send the personalized PDF as an attachment via email to the registered user. **Ideal Skills and Experience:** - Proficiency in Laravel framework. - Experience with dynamic PDF generation in PHP. - Capable of integrating PDF generation and email services in a Laravel application. - Strong understanding of front-end technologies for capturing user input accurately. - Experience with SMTP or ...

VBA Tool to import two kinds of pdf inputs and extract data in one common sheet. Dynamic selection of inputs structure. and Input-2021-Extracted (without account numbers).pdf files conversion to excel output. Scalable and customizable for other input

Wordpress professionals, with expertise in GiveWP plugin, to help export crucial data. Here's what I need: - Specific extraction of donor information, primarily phone numbers. - Comprehensive knowledge of how to locate and extract this information from GiveWP is required. The exsisting export plugin doesnt export the phone number. I require a complete donation list for 2023, including all data and phone number

Dear, We need a macro script to Update, rebuild and maintain our CAD assemblies in our PDM Vault. The script will be run from SW PDM and through workflow The macro language is preffered in VBA but C is accepted The Macro scope is highlighted bellow, i will provide detailled requirement after our first contact. Best Regards, Macro Scope : This macro is mainly here to update, rebuild and make sure all our components settings and configuration are correct, from graphical properties, values of Custom properties, sheet template update, Unit and digit choice etc. Bellow are a list of actions to be performed with some details and screenshots of what we need. 1. **Rebuild and Configuration Management:* - **Automatic Rebuild for every configuration...

I'm in need of a specialist to extract text data from PDF files in a website. The primary goal is to extract and export this data into a csv file for delivery. Here's what you should possess for this project: - Proficiency in extracting text data accurately from PDFs - Excellent attention to detail for error-free results - Experience in data extraction and web scraping Please note that the extracted data must be as structured and clean as possible for seamless analysis. Only bid if you are confident in delivering high-quality work in this field. Please elaborate on prior similar project work experience as that will be of prime consideration. Also in your proposal please lay out your steps and tools that you would go about using t...

We need a macro script to be run in Solidworks PDM. The Macro script will be inserted as a Task in the PDM and will be run on Solidworks Parts of our Vault. The trigger will be either through Workflows or through user input, this is configured in PDM. VBA is preffered for the language but C can be considered if more efficient here The macro need to do the following : -Check OUT ( with admin credentials) -Edit the Weldement features(scan the part from multiple if needed) exisiting inside the part to update it s Cut List Properties ( need to run for all configuration as As machined and As Welded configurations are created) ( The Weldment profiles of the library have seen their Custom Properties updated, we need to update all the project parts using these weldmeent...

I'm looking for a detailed-oriented freelancer to enter and format text data from various online sources into a customized page layout. This project requires diligence, accuracy, and a knack for organizing information engagingly and cohesively. **Ideal Skills and Experience:** - Proficiency in data entry and formatting - Strong attention to detail - Experience in navigating and extracting data from online sources - Solid understanding of page layout design principles - Flexibility in adapting to the customized format required for the final output - Ability to meet deadlines reliably **Project Requirements:** - Extract text data exclusively from provided online sources. - Enter and format the data into a specified custom page layout, ensuring...

Modify macro to include more data

I'm looking for a meticulous freelancer who can accurately transfer text data from various digital files into an Excel spreadsheet. Key Accountabilities: - Extract appropriate text data from digital files provided - Enter data accurately and efficiently into Excel spreadsheet format Ideal Candidate: - Excellent data-entry skills - Proficient in Excel - Meticulous attention to detail - Previous experience with text data entry from digital sources preferred Ultimately, I need a reliable professional who can guarantee accurate and quality work. Your skills in data entry and Excel will be essential for this project.

-Urgent- Let us know if you are available today I need a VBA Macro code to create a Quantity calculation function for our Bill Of Material. The problem is rather simple, we have list of Components in a hierarchized structure, the structure is expressed with a Level column formatted like 1.1.2 or 1.2.12 etc. We need the ability to calculate the total quantity of each child of the structure based on it’s level and parent quantity. This means we need a CumulQty column for the level 1.x, but also a column for the CumulQty for the Level 1.x.x and 1.x.x.x The solution can be done in Excel (VBA) , through Power Pivot or through Access. Regardless, we need a CumulQty Column for each level to be created in our structure. BOM example : Level Flat Level VER_ID Qty 1 1 Vpr-100054...

...who can create a comprehensive macro for my unique needs. I want a macro specifically targeting leave tracking for employees. This macro will be responsible for automating several tasks: - Data Entry: Ensuring seamless input of employee names, leave balances, and leave types into our system. - Data Analysis: Reviewing, assessing, and interpreting the entered information. - Formatting: Making sure the data is always well-organized and easy to understand. Our spreadsheet will function as an employee leave tracker, monitoring a few key points: - Employee names: We need to attach the relevant leave data to particular individuals. - Leave balance: It's imperative that the system tracks the number of leave days remaining for each emplo...

...for data scraping and manipulation (such as Tweepy for Twitter API interaction and Pandas for data frame handling). - Experience with using the Twitter Developer API to extract tweet data. - Ability to apply filters based on keywords and locations to the data extraction process. - Competency in saving the collected data into a CSV file format while maintaining data integrity and structure. **Ideal Skills and Experience:** - Strong background in data scraping and web scraping projects. - Previous experience with Twitter data extraction and analysis. - Expertise in handling large datasets and performing data cleansing and formatting to ensure usability. This project is perfect for a freelancer who is detail-oriented a...

...skilled Python programmer with expertise spanning web development, data analysis, and automation to spearhead a cutting-edge project intended to transform the way we handle API data. Our key objective is generating insightful graphs that depict various metrics extracted automatically from several APIs, smoothing our data analysis and decision-making processes. **Key Responsibilities:** - Develop a web application that serves as the front end for users to interact with. - Write scripts for automating the extraction of data from specified APIs. - Implement data analysis techniques to process and extract meaningful information from large datasets. - Design and generate graphs and visuals that accurately represent the analyzed data for easie...

The primary objective of this project is to extract specific information about the owner of a certain website. The information you'll be expected to collect includes the name of the website owner.

...model capable of understanding and analyzing customer reviews. - Extract sentiments, trends, and actionable insights from the text data. - Create a user-friendly dashboard to present these insights for easy consumption by our product and service development teams. **Ideal Skills and Experience:** - Robust experience in NLP and text analysis. - Proficiency in programming languages suitable for NLP tasks (e.g., Python, R). - Previous work involving sentiment analysis, especially with customer reviews. - Ability to work with NLP libraries and frameworks (e.g., NLTK, TensorFlow, PyTorch). - Experience in creating dashboards or visual representations of data insights. - Excellent communication skills to effectively translate complex data findings into actionable ...

...a SQL parsing project. The foremost objective of this project is data extraction. You must know how to traverse an AST! Key Tasks: There is a query it could be in SQL or in partial expression format.I need you too parse that query using sqlglot parser and extract functions and field names . You need to create 2 functions one for extracting fields one for extracting functions use only sqlglot library to parse. *expression could be a sql query or a partial expression Write your functions here:-------- import sqlglot def extract_field_names(expression): field_names = set() //write logic to extract field names using sqlglot return field_names def extract_function_names(expression): function_names =set() //write logic to extract function names using sqlglot ret...

I'm seeking an experienced professional capable of converting a 32bit Microsoft Word macro to 64bit. Understanding the potential challenges of this conversion and having relevant experience are fundamentally important. Ideal Skills and Experience: - Extensive experience with MS word macros - Proven track record of successful conversion from 32bit to 64bit - Deep understanding of Microsoft Word functionalities and capabilities - Prior work that is relevant to the current project

I'm seeking a freelancer to r...documents per week, which are in Excel and pdf, formats. The goal is to extract excel/pdf data from website,and create and calculate 'sum' create one page file and e mail us. I will provide, all instructions. Tasks include: - Re-formatting my documents to match the example's layout and style. - Making calculate datat edits and adjustments , from 2 data sheets/filter. Ideal skills required for the project: - Experience in Excel and PDF editing. - Attention to detail in matching document formatting. - Good command over language for content edits. Please note, it's not only data /calculate/single page file job. If you're meticulous and are proficient in Word, Excel, PDFs, this project could be for y...

I need someone to build a drop shipping website that can extract product images and prices from a wholesaler website and present them with the margin added in real-time. The freelancer must have experience building something similar and proficiency in these areas: Data Parsing: Use web scraping tools or libraries (e.g., BeautifulSoup in Python) to extract product images and prices from the wholesaler's website. Write scripts to fetch the data in real-time. Data Storage: Store the extracted product data (images and prices) in a database or cache to facilitate real-time access. Use a database management system like MySQL or MongoDB to efficiently store and manage the data. Price Markup: Calculate the desired margin to be added to the...

I need an expert in data entry to extract and organize information from the website into an excel spreadsheet. This task will cover approximately 500 items, where you'll be required to replicate the each item's identifying details. Key Responsibilities: - Significant transfer of data into excel from the website mentioned above. - Each item should copy the title, price, description, general specs, and technical specs into separate columns. - The data from each category should be further subdivided into related individual columns (e.g., each part of the technical specs in individual columns). Required Skills: - Exceptional attention to detail to ensure the accurate capturing of data. - Proficiency in data entry and excel spreadsheets. -...

I am looking for a tech-savvy web scraper who can extract detailed information for the purpose of data analysis. Your mission, if you decide to accept it, will involve scraping slots data from a websites. Responsibilities: - Successfully bypass Cloudflare login captcha using Python - Extract and structure targeted data (slots information) Ideal candidate: - Proficiency in Python - Experience in bypassing CAPTCHA's, specifically Cloudflare - Proven track record of successful web scraping for data analysis purposes. - Attention to detail and accuracy in data extraction. This project demands technical expertise and comprehension; only bid if you are confident in your Python and web scraping skills, and particularly proficient in bypass...

...and meticulous data entry operator specialized in handling alphanumeric information for a crucial project aiming to update and create a comprehensive database. Here's what I'm envisioning for this role: **Key Responsibilities:** - Extract alphanumeric data from various online sources, including websites and databases. - Ensure accurate and efficient entry of the data into a new and evolving database system. - Perform data verification and cleaning to maintain high accuracy and integrity of the database. - Collaborate closely with our team to ensure the database is continuously updated and meets the project's requirements. **Ideal Skills and Experience:** - Proven experience in alphanumeric data entry, particularly from online so...

As the client, I am on a quest to create a collective catalogue for PPE items. To achieve this, I am seeking a professional with extensive experience in image extraction from PDF files. Specifically, your task will be: - Extract more than 5-10 high-quality items images from each PDF file with white background. - Following extraction, ensure the images are saved in the preferred JPEG format. - Organize and categorize the images as per items (Ex. Helmets together, Shoes together, etc.) in separate pages. - Adding model name or specifications (whichever available in the original file) and manufacturer name under each image. The ideal candidate will possess: - Excellent attention to detail, ensuring no image is overlooked during extraction. - Proven experience with file conversio...

...Requirements:** - **Data to be Collected:** The primary focus will be on harvesting email addresses and website URLs. If possible, obtaining one contact email address from each domain is also a goal. - **Scope of Work:** This project is a one-off task, meaning the data needs to be collected just once. However, it is essential that the collected information is up-to-date and accurate at the time of scraping. - **Deliverable Format:** The final data should be organized and delivered in a structured format such as CSV or Excel sheet, ensuring it is ready for immediate use. **Ideal Skills and Experience:** - **Proven Experience in Web Scraping:** Applicants must have a solid track record of similar projects, with the ability to navigate various website structures to...

I'm in need of an adept web scraper who can efficiently extract specific text data from the web. The ideal person for this project should have a strong background in web scraping, data extraction and entry, and the following tasks will be required: - Extracting and collating contact details from specified businesses - Also scraping and compiling comprehensive company profiles such like name, email, phone number and location Strong attention to detail and accuracy is crucial for this job, as is a proficient timestamped delivery of the tasks. Experience with similar projects is a plus.

I urgently need an expert data scraper who can efficiently extract text content, tables and structure from multiple webpages. The content should be transferred into a Word document while adhering to the following formatting requirements: - Plain text - Tables - Sections An ideal candidate would have extensive experience in data scraping, proficiency in utilizing different relevant tools and a keen eye for detail to maintain the structure authenticity with an excellent turnaround time. I am not considering candidates without prior experience or a portfolio showcasing similar projects. Your proposals should demonstrate your understanding of my specific needs and explain how you would approach this project.

...Almaty) - Extensive data scraping from 2GIS - Business category : Cafe/pastry/bakery - Collection of business names, contact details, reviews, menu details specifics, and pricing of each items - Geolocation information for each listing Ideal Candidates should demonstrate: - Proven experience in data scraping and web automation - Ability to parse and extract varied information accurately - Proficiency in data management and organization Data Formatting: - Deliver all scraped data formatted in an Excel spreadsheet for easy analysis. Please include details of similar projects you've tackled and how your experience suits this task. I'm looking for efficiency, precision, and reliability. If you have the skills to perform a comprehensiv...

I need impeccable 3D models of two makeup products: a liquid lipstick mini and a primer. These models should meet the following criteria: - **Highly-Detailed Models**: Every little feature of the actual product needs to be captured, nothing can be overlook...branding into visual designs. Freelancers with a portfolio featuring cosmetic or similarly detailed items will be highly regarded. Please only bid if you can deliver high detail and high texture quality to bring these products to life virtually. refer to the attached PDF for details on the actual product and the render angles Deliverables will be 1. Source 3D model for the products 2. PNG extract for all 29 Renders as detailed in the attached pdf 3. A few small video clips to record product movement/ motion (reference will ...

I require a system that extracts specific product inventory details daily from Excel files. These documents possess cookies designed to prevent a seco...Excel file How much for this spec? - Ideal candidate skills: - Expertise in Python - Experience with web scraping against anti-scraping techniques - Proficiency in handling cookies and session management - Familiarity with Excel file structures - Ability to automate tasks and schedule daily runs - Main Objectives: - Navigate and overcome anti-scraping defenses - Accurately extract daily product inventory details - Automate the scraping process to run daily Interested freelancers should showcase similar work and explain their approach to ensure reliability and accuracy in the face of sophisticated anti-scraping...