Web scraping excel macro jobs
...between 50,000 and 100,000 (or near this range so e.g. could be 40,000-120,000 eur/year - in the UK and (ideally separately) in the EU. 3. Average investment amounts (mode, median) by each investor in each category from (1.) above over time and predictions (say 3 years, but flexible according to the data) on all of 1-3 above 5. All of above (1-4) presented in editable charts with editable excel files and all referenced by source of info and date NICE TO HAVE a. Total existing value of savings and investments in the UK and EU by investment media/category. b. total existing value of current accounts (and separately) savings accounts in banks/bldg societies in the UK and (ideally separately) the EU c. Average spend on accommodation of holiday-makers (or by household) vacationing ...
In this project, I am seeking an expert in data mining who is proficient in using Python libraries such as BeautifulSoup. Your task is to scrape names and contact details from numerous business directories. Ideally, you will have: - Experience using Python for web scraping, especially with BeautifulSoup. - An understanding of different business directory structures and the ability to adapt your scraping methods as necessary. - Exceptional attention to detail to ensure all data scraped is accurate and relevant. - Respect for the privacy and ethical standards associated with data extraction. Your role will involve: - Identifying key data on business directories: primarily names and contact details. - Creating efficient, reusable, and reliable Python code to scrape t...
I immediately need an experienced freelancer to scrape specific numerical data from a website for me and in Json or XML files and should be updated each 500 ms. The project needs to be completed as soon as possible. Key requirements for the job participation are: - Proven experience in JavaScript - A strong understanding and prior experience with data scraping, specifically numeric data. - Availability to start the project right away and ensure its swift completion. These skills will be paramount to successfully get the wanted information quickly and effectively.
I'm looking for an Excel expert to automate various tasks relating to our tracking system and create an intuitive dashboard. The tasks will involve automation of formula calculations and report generation, to streamline our data processing workflow, and reduce human error. Key tasks include: - Automate formula calculations: Efficiently automate intricate excel formula calculations. - Automatic report generation: Create a mechanism for generating immediate, error-free reports that highlight key aspects. - Dashboard creation: Design a user-friendly dashboard displaying information based on Automatic report Generation. The ideal freelancer for this job should have: - A deep understanding of Excel's advanced features; - Previous experience with automations and ...
Utilizing my knowledge of Excel and APIs, I need a freelancer to exceed Power Query's data size limitations. This is to compile a list of 266 pairs from Binance, which will be sent to you. The final output must: - Bypass Power Query's current limitation from 1000 to 2584. - Arrange the pairs in order of their price. Your solution will enable real-time updates of this data in Excel. It would be beneficial if you have previous experience managing API calls and dealing with large data sets in Excel. Proficiency in real-time data extraction and handling is also crucial. need it fast around 2 Hours not more then this, i had the excel to work on just make this on new sheet
I'm looking for a proficient developer with expertise in React.js and Node.js to design and implement an innovative web application with a dual focus. The primary functionality should be searching and aggregating information, united with web scraping and text extraction features. The application should: - Incorporate a connection to search APIs: Google, Bing and others. - Generate search parameters primarily based on keywords, plus an additional layer incorporating combination match words such as 'fraud', "charge" etc. - Develop an intelligent AI web scraping feature to extract text and info based on search results. - Consider additional features such as search parameters that can be controlled via data sources, sorting options a...
...well-versed in the sidereal time system to create an Excel sheet that provides the planetary positions in Vedic Astrology of Sun, Moon, Mercury, Venus, Mars, Jupiter, Saturn, Rahu, and Ketu. The final deliverable should have the planetary positions presented in degrees, minutes, and seconds format and zodiac placement of planet and if the planet is retrograde or not. Successful applicants should provide examples of their past work in Vedic astrology, especially on planetary positioning. A detailed project proposal would also be well appreciated. Ideal skills and experience for the job include: - Programming skills of C, C++, Python or Java and a bit of Vedic astrology knowledge, particularly on planetary positions - Proficiency in Excel - Experience in presenting comp...
I have printed documents that need to be typed into an Excel sheet. The final spreadsheet must also be formatted according to specific requirements. Ideal Skills and Experience: - Proficiency in data entry with high accuracy - Strong understanding of Excel, including: - Use of formulas - Conditional formatting - Data sorting and filtering - Attention to detail to ensure accurate data entry and formatting
Set up a Monte Carlo Simulation model to optimize the reduction of fatalities at roadway work zones using Excel with a Monte Carlo simulation add-on. The objective is to reduce crashes involving fatalities. Variables can include work zone speed limit, work area length, duration of work being done, time of day work is done, traffic volumes, work signs/flaggers present, etc. Expert knowledge in Monte Carlo simulations and risk engineering modeling. Limited time available to create model. More information available upon request.
Develop financial modelling in excel spreadsheets based on information supplied. This may lead to a long-term ongoing assignment(s) depending on your skill level and capabilities
Looking to setup forms in SharePoint (365). The forms will be basic drop down and redial buttons. Answers will need to be collected in a Excel sheet. Approx. 150 forms need to be created to begin with in the next 6 weeks. Possibly ongoing creation, modification and management required.
I need a software that can provide me with daily updates of opening and clossing odds from a similar site. Ideal Skills & Experience: - Proficient in web scraping - Expertise in data extraction and manipulation - Prior experience with similar odds comparison websites - Strong software development skills - Ability to deliver a detailed project proposal The software should be capable of extracting and presenting the opening and clossing odds from these three specified betting companies in a format that I can load onto my website. Please include a detailed proposal in your application, outlining how you plan to achieve this.
I. Project Description I'm looking for a freelancer to create an automated newsletter system that works with PDF files. This system will: 1. Data Scraping: Extract data from the given PDFs, including information in tables and XBRL format. 2. Keyword Analysis: Analyse the extracted data based on keywords I provide and remove PDFs that don’t meet the criteria. 3. AI Summarisation: Use AI to get summaries of relevant sections identified through keyword analysis after connecting it to an API. 4. Newsletter Generation: Put together a newsletter that includes: Summaries of the data points with references to the original PDF files along with the original table and URL links of the PDF scraped II. Requirements • Experience with PDF processing libraries like PyPDF2 or Apa...
I'm looking for an Excel expert to handle a set of 10 company accounts from 2014 to 2024. Key Responsibilities: - Data Entry and Organization: The successful freelancer will be responsible for ensuring that all company account data is correctly input into Excel. - Financial Analysis and Forecasting: I need someone with the ability to perform in-depth financial analysis and create accurate forecasts based on the data provided. - Data Visualization and Reporting: You should be able to create professional and easy-to-understand visualizations, graphs, and reports. - Audit and Dashboard: The final deliverables should include an audit of the accounts and a dashboard that provides a clear overview of the financial health of each company. The accounts are currently in digita...
I'm in need of an experienced developer or programmer who can create a modified bar graph for me. The project will require: - The modified bar graph should have basic text labels on the vertical axis. - The design should be clean and professional, ensuring a good user experience. Ideal applicants should have: - Proven experience in creating bar graphs. - Excellent knowledge of the technology needed to implement such a graph. - Strong attention to detail to ensure the labels are correctly aligned and clearly legible.
I have a project that involves converting text from txt format into an Excel spreadsheet. Key Requirements: - I need someone who is meticulous and efficient at data entry. Your responsibilities: - Convert text from provided txt file into an Excel spreadsheet. - Ensure accuracy and maintain proper formatting. Ideal Skills: - Proficient in Excel. - Strong attention to detail. Sample is attached.
We are seeking a skilled web scraping expert to scrape html pages and convert them into a pdf file. The selected candidate will be responsible for creating a web scraper script that can automatically extract and organize data from various websites. The data should be neatly formatted into a pdf document for easy accessibility. The website is in which there are various links - section - 1, section - 2, etc. The text which is present when a link is opened is to be scraped. There may be an odd number as well, like section - 5A. Also, there are pages which will give more links/sections (there are upto 93 pages). When the section is opened, there may be footnotes. The text when the footnote is opened is to be scraped if possible.
I am in need of an expert in Excel to assist with data entry and organization. The work involves entering both numerical and textual data into Excel, and then organizing it by category. In addition, I require the use of data validation functions to ensure the accuracy and integrity of the data. Key Responsibilities: - Inputting both numerical and textual data into an Excel spreadsheet - Organizing the data by category - Implementing data validation to maintain data quality Ideal Skills: - Proficiency in Excel - Experience with data entry and organization - Familiarity with data validation functions - Strong attention to detail This project is ideal for someone who is meticulous, organized, and has a good understanding of Excel functions.
Description: I'm seeking a skilled Python developer proficient in web automation and scraping to assist with a project involving logging into vfsglobal links, such as , an infinite number of times without triggering website blocking mechanisms. The freelancer should possess the expertise necessary to circumvent the website's restrictions, as repeated logins (typically 4-10 times per day) currently result in login prevention. Requirements: Proficiency in Python web automation and scraping Experience with handling website login restrictions and bypassing measures Ability to integrate proxies into the script (proxies will be provided) Attention to detail and commitment to delivering high-quality, functional code Willingness to undergo testing and revis...
As someone unfamiliar with the specific version of Microsoft excel I'm using, I am seeking a proficient freelancer in handling Excel Automation. To successfully take on this project, you need to demonstrate: 1. Proficiency in Data Entry, Calculation, Analysis and overall Data Manipulation using Excel. 2. Good knowledge across different versions of Excel, since I'm uncertain of the specific version I am currently using. 3. Responsiveness and good communication skills. While the turnaround time for the task isn't defined, I appreciate a quick and efficient service. However, quality should not be compromised. Experience in working across various Excel versions will be an added advantage. I look forward to receiving your bids.
...Managers up to 60 Projects). Output > Requirement 2 > Overarching Gantt Chart showing all projects to create an easy way for executives to see where projects are at in the stages and when the projects are expected to be complete. Requirement 3 & 4 will provide me with an overarching program/portolio view They should cater to a variety of project information, covering: Requirement 1 (Open to Excel or Word Formatting) Individual Project Reports should 1. Project Name and Brief Description, Project Manager/Lead Name 2. Project Stage and Project Type (i would like to choose from a selection/list ) 2. Status Indicators- Overall, Financial, Schedule, Risk and Issue 3. Risks and Issues Details 4. Critical Dependencies 5. Upcoming Milestones 6. Exceptions 7. Start, Fi...
The English national football league is very close to an end. The 4 bottom sides will get relegated. That might include my beloved York city !! I want simulate how likely this is given my predictions of the probability of outcomes of the remaining games. The bbc website shows the table and the remaining fixtures. The only way it can happen is if the 3 sides lower than York all over take York. York and Woking only have one game left. Borehamwood and ebbsfleet have 2, one of which is against each other. Rankings are conventional. 3 pts fir a win 1 fir a draw, 0 fir defeat. If points totals are equal the different between goals scored and conceded is considered. If that is also equal - quite possible - total scored decides it. I can supply my judgement of the probability of each result i...
I need a detail-oriented and focused individual who excels in manual data entry to convert data from my physical documents into a spreadsheet. Requirements include: - Transferring data from paper formats into a computer system - Strong typing speed and accuracy - Experience with MS Excel or similar spreadsheet software - Ability to maintain confidentiality when handling sensitive information. Accuracy is absolutely critical for this project, so keen attention to detail is a must. Previous experience with similar projects will be highly regarded.
I require the expertise of a Python developer to convert an excel file for automated task execution. The primary purpose of this project is to automate certain data manipulation tasks, specifically the application of formulas and calculations within the dataset. The chosen freelancer should demonstrate a proficient understanding of both Excel operations and Python programming in order to seamlessly translate the existing manual processes into an autonomous, error-free script. Your application should include any previous experience with similar data manipulation or automation tasks.
...experience in creating modern logos. - Proficient in color theory and can work with a neutral, earthy color palette. - The main element of the logo should be a symbol. The meaning behind it will be discussed further upon project commencement. - Ability to deliver a unique, compelling and memorable logo design that will resonate with our audience. This is an exciting opportunity for creatives who excel in translating brand vision into compelling visual design. Show me your portfolio that showcases your clean and modern design sensibility. Looking forward to seeing your applications! we need a logo for our cushion product used for orthopedic purposes. we have attached a sample logo for reference. we need the source file and all the fonts and elements. If you have any questions p...
...consolidate into a single Excel spreadsheet for my project. The main goal is to have all the information in one place to ease the decision-making process. I'm looking for a freelancer who can help me with this project and provide ideas on how to make this work. Key Points: - The data is spread across a large PDF and a website, and I need it all extracted and combined into a single Excel spreadsheet. - I need product decision, finish, list price, cast Qty, Master Qty, weight, length, and similar details extracted from both sources. - The extracted data should be organized in the Excel spreadsheet with each data point in a separate column. Ideal Skills and Experience: - Proficiency in data extraction and consolidation from PDFs and websites. - Experience in ...
I'm looking for a skilled professional who can crop the complete content of a website and save it in a zip file to be deployed on a new server. The website is a small Wordpress with about 41 pages (as per sitemap). Content must not be saved as Wordpress, but static html to be deployed on another server. Key Requirements: - Crop all website content including subpages. - Save the cropped content in a compressed zip file. - The purpose of this cropping is to save the content for future use. - all files must be included, esprecially but not limited to images, js, css, ... - inner paths must be relative paths. If you're confident in your ability to deliver this and can ensure all the content is correctly saved, please bid accordingly. IMPORTANT READ THIS: Auto-generated bids wil...
I'm seeking a meticulous freelancer to assist in Excel sheet data entry. The project involves analysis and entry of both text and numbers. Ideal Skills: - Proficiency in Excel - Excellent data entry skills - Strong analytical abilities Your application should include past work that demonstrates your experience with similar projects. The data entry task is more complex than simple copy-paste, so I'm particularly interested in freelancers who have experience with data analysis and entry.
Hi A bit of fun this one ! The English national football league is very close to an end. The 4 bottom sides will get relegated. That might include my beloved York city !! I want simulate how likely this is given my predictions of the probability of outcomes of the remaining games. The bbc website shows the table and the remaining fixtures. The only way it can happen is if the 3 sides lower than York all over take York. York and Woking only have one game left. Borehamwood and ebbsfleet have 2, one of which is against each other. Rankings are conventional. 3 pts fir a win 1 fir a draw, 0 fir defeat. If points totals are equal the different between goals scored and conceded is considered. If that is also equal - quite possible - total scored decides it. I can supply my judgem...
I am on the search for a professional who has proficiency in Excel. The main task of this project involves automating the process of conditional formatting in Excel based on cell content, which can help streamline and simplify my workflow. Skills and Experience Required: - Strong knowledge of Excel functionalities - Experience in automating conditional formatting - Ability to build scripts based on cell content Your expertise will help me ensure that my data is formatted accurately and consistently, saving me time and increasing efficiency. Please place your bid if you possess the necessary skills and experience, and we can discuss further details.
I'm seeking a meticulous freelancer to assist in Excel sheet data entry. The project involves analysis and entry of both text and numbers. Ideal Skills: - Proficiency in Excel - Excellent data entry skills - Strong analytical abilities Your application should include past work that demonstrates your experience with similar projects. The data entry task is more complex than simple copy-paste, so I'm particularly interested in freelancers who have experience with data analysis and entry.
I am seeking a talented web developer to create an impactful informational website focusing on showcasing digital products. Here’s what an ideal candidate will bring: - Strong expertise in web development with a proven track record of successful informational website builds. - Understands the necessity of an intuitive user interface and can implement seamless navigation for site visitors. - Ability to design a visually appealing site that attracts and retains attention. Attractive showcases for digital products are paramount. - Can ensure site is optimized for search engines to maximize traffic. - Since my goal is to provide information about digital products, the ability to creatively and effectively highlight said products is essential. Note: Selling of products is ...
**Project Description: Database Creation with GPT Assistance in Excel** **Overview:** The aim of this project is to leverage the capabilities of OpenAI's GPT (Generative Pre-trained Transformer) model to assist in the creation of a comprehensive database using Microsoft Excel. The database will serve as a centralized repository of structured information, facilitating efficient data management and analysis. **Objectives:** 1. Develop a structured database architecture suitable for the organization's requirements. 2. Utilize GPT to automate data entry, validation, and enhancement processes. 3. Ensure data integrity, accuracy, and consistency throughout the database. 4. Enable seamless data retrieval and reporting functionalities. 5. Facilitate collaboration and know...
...specific applications and tracks changes over time. System Administrators will use the script to identify current and historical versions of important software. The script would be executed locally as a scheduled task. Use Cases • User specifies applications for which to monitor version information • User schedules script to run at the desired interval • User analyzes report generated by script using Excel Inputs • The script should take a file with an application name to be tracked on each line • The script should require Administrator privileges Outputs • The script should output a CSV file in the $WINDIRTempSVT folder that contains the software version report • Each line in the software version report should include: o Computer Name o Soft...
I am seeking an expert in data visualization to create a pivot chart that can accurately represent my organization’s financial data. The focus of this pivot chart will be on expense analysis. Key requirements: - Ability to categorize expenses by department, project, and type of expense - Clear knowledge of financial data manipulation - Proficiency in Excel or any similar data visualization tool Ideal Skills: - Strong background in data visualization, particularly pivot charts - Proficiency in financial data interpretation - Detail orientation to ensure all categories of expense are correctly entered and represented This project will help us understand our cost drivers better and make informed budgeting decisions. Freelancers with previous experience in similar projects ...
I'm looking for a highly skilled macro coder to assist me with the development of advanced custom macros in Microsoft Excel. This project will require a deep understanding of VBA and prior experience with integrating macros with external databases or APIs. Key Requirements: - Develop advanced custom macros in Microsoft Excel - Implement integration with external databases or APIs - Ensure the macros are efficient, reliable and user-friendly Ideal Skills: - Proficient in VBA (Visual Basic for Applications) - Experience in developing advanced Excel macros - Knowledge in integrating with external databases or APIs I look forward to working with a professional who can deliver high-quality, efficient and effective macros.
I am in need of an expert web scraper who is capable of extracting telephone numbers from several websites. The specific websites in question will be provided soon. I NEED LIST OF 1M and more of Denmark ... if you have message me if you don't have don't waste time please for other candidates.. Key Requirements: - Freelancers should have significant experience in web scraping. - Proven track record in data extraction, specifically with telephone numbers. - Robust knowledge of data privacy ethics and regulations. This project will involve sifting through vast amounts of information and accurately capturing and organizing the necessary data. Consequently, attention to detail is paramount. Successful freelancers should provide details on previous scrapin...
I am looking for a skilled freelancer to assist me in organizing my Excel sheet data. The purpose of this organization is to pave the way for comprehensive statistical analysis. Key Responsibilities: - Organizing data in a user-friendly format - Ensuring that data is accurately inputted and maintained - Setting up the Excel sheet for further statistical analysis Ideal Skills and Experience: - Proficiency in Excel and data entry - Strong organizational skills - Understanding of statistical analysis - Previous experience with data organization for statistical purposes
need an expert in a multi-project task tracking Gant chart multi suppliers provide document control he must be an expert in MS excel and need to provide a solution for tracking ad document control by excel or another software he is an expert in it we can use later
I'm looking for a professional with advanced skills in data mining and excel to extract specific text information from a website into an excel spreadsheet. This job requires an understanding of website data scraping. The successful candidate should have: - Proven experience with Web Scraping. - Expert knowledge in Data mining and Excel. - The ability to handle large sets of information efficiently and effectively. - Accuracy and attention to detail. - Knowledge of and web scraping ethics. The task primarily involves text data mining, here are the specifics: - Extract exact information from a website. - The exact text data to be mined will be communicated to the successful candidate. This opportunity is ideal for someone with...
...for further details: > Python (or a python package) is to be used everywhere it possibly can! **Data Collection** Data can be collected (legally) from anywhere. You may use data that you already have; or from sites that allow you to download the data, for example, [UCI Machine Learning Repository]() or [Kaggle Datasets](); or via web scraping; or via an API. We can restrict ourselves to data that would fit nicely into a spreadsheet. The content and amount of data are not the main consideration, as long as the data has: - at least 10 variables - three or more data types - two or more problems: missing data, inconsistencies, errors, categorical data that needs to be converted to numeric, entries like text that need to be converted
I am seeking an experienced Excel expert to create a functional timeline sheet. As the project specifics were not indicated, the freelancer must be capable of handling a wide range of tasks including but not limited to designing tasks description, start and end dates, and task dependencies. The sheet needs to be well-organized, potentially categorized by project phases or team members, or put in chronological order. This can be further discussed as the project progresses. It's crucial that the timeline offers a clearly visible trajectory of tasks, milestones, or a high-level overview of the project timeline. It will be helpful if the freelancer possesses: - Expertise in Excel - Strong attention to detail - Understanding of project management processes - Ability to wo...
I'm in need of a professional who can scrape specific data from a website onto an Excel spreadsheet. The requirement is to list information in a table format. Key Requirements: - Scraping of content descriptions from the website - Transferring the extracted data into an Excel database The data should be organized in a clear and structured manner, following the format I will provide.
I'm in need of an Excel sheet that is set up for data analysis purposes. Key Requirements: - Utilize Pivot Tables: The main goal of the sheet is to leverage Pivot Tables for efficient and effective data analysis. - One-time setup: This is a one-time project, so the sheet will be used for data analysis and won't require regular updates. Ideal Skills: - Proficient in Excel: An expert in Excel who is comfortable working with large data sets and has a deep understanding of Pivot Tables. - Data Analysis Experience: Previous experience with data analysis is a plus, especially with a focus on creating actionable insights. - Attention to Detail: The ability to accurately set up the Excel sheet to ensure data integrity and reliable analysis. I'm lookin...
...seeking an experienced data scraper to collect and compile contact information, specifically email addresses and fax machine numbers, for doctor's offices in Hamilton, Ontario. The desired freelancer will have: - Proven experience in data scraping and data entry. - Ability to independently source from multiple platforms or websites. - Knowledge and capability to deliver the data in an Excel spreadsheet format. Primary Tasks: - Data scraping for email addresses and fax numbers across various sources. - Ensure accurate, complete data entry into the Excel spreadsheet. - Verification of compiled data to ensure its accuracy. This project is ideal for freelancers with a keen attention to detail and a dedication to data accuracy and integrity. If the qu...
I'm looking for a skilled Excel and Adobe professional to automate a series of Excel forms that have varying formats and information, with the data from a single fillable heading. Below are some key details: - Excel Version: The forms are based on different versions of Excel, as I'm not sure which ones to be exact. A freelancer who is proficient in all versions will be ideal. - Application Requirements: Please include detailed project proposals in your application. Experience with similar projects will also be a plus. - Final Documents: I need the final documents in both XLSX and PDF formats. The main goal of this project is to create a fillable heading where client information can be input on one page and have it automatically populate to the other ...
I'm looking for a Microsoft Access professional to work on generating a report concerning my inventory data. Your key tasks will include: - Utilize existing inventory data to create a excel sheet that shows all data required in one place.
I'm looking for an Excel VBA expert who'll be prepared to take on challenges on the go, as this listing lacks specific task detail. I rely on you to be innovative and foresee potential tasks such as automating data entry, creating macros, or generating reports. Ideal Skills & Experience: • Proven VBA scripting in the Excel environment • Experience with automation, macros, and report generation • Demonstrable troubleshooting skills In your application, please showcase your past work, how much experience you have, and provide a detailed project proposal. While the specific tasks aren't predefined, your application should reveal your versatility and expertise in VBA scripting. The project's ultimate purpose is unknown, potentially inv...
I have a daily dataset of the prices and funding fees of cryptocurrencies from Binance. I'm seeking an Excel expert to automate the task of calculating the price, funding fee, and percentage of each crypto every day at specific time. - The output should be in a table format for ease of understanding and comparison. Any tool or programming language that can efficiently and accurately perform this task is acceptable. The goal is to create a structured, automated process that can handle this daily task with precision. Ideal Skills and Experience: - Strong Excel skills, especially in formulas and functions. - Prior experience with automation in Excel, macros and VBA programming. - A good understanding of cryptocurrencies and their pricing. - Ability to deliver a ...
