Excel vba web scraping chromepráce
pasar informacion a excel. pasar informacion a excel
Pro pracovní projekt potřebuji zajistit webscrapping jedné webové stránky (nejlépe pomocí Octoparse) vytvoření dvou relačních databází (malé datové sety, jedny jako výsledek webscrappingu, druhé dvě Excel tabulky) pomocí SQL, včetně jednoduché prediktivní analýzy, a grafické zobrazení dashboardu v Power BI. Dat je málo, tedy věřím, že pro zkušeného datového analytika je to práce max. na pár hodin, mně to však velmi pomůže.
In order to understand the real...I would like to scrape the real estate listings from a website (). The website has ~5000 listings of apartments for rent, and ~7000 listings of apartments to buy. Goal is to scrape all the listings including its details, categorized correctly in Excel, to enable comparison of apartments by their size, condition, location within the city, etc. The website is in Czech language and I will happily translate anything you need. It is a one-time scraping, but please consider also the option of continuous scraping. The web scraping could potentially be expanded to other cities (within the same real estate website) Apartments to buy: Apartments to rent:
Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.
Jedná se o vytvoření ekonomických posouzení investic do realit. Po vzájemné dohodě dojde k zadání základních parametrů a informací, které je zapotřebí posoudit pomocí ekonomických ukazatelů jako jsou IRR, CASH FLOW, YIELD, ROI, ROE. K tento činnosti je nutné perfektně ovládat Excel a mít vzdělání ekonomického zaměření ideálně se zaměřením na realitní trh a investice na tomto trhu.
Krátkodobá a dlouhodobá půjčovna elektromobilů: - Datábáze vozidel (současná evidence v excelu) - Databáze zákazníků (CRM) - Automatizované vytváření dokumentace: smluv, předávacích protokolů, fakturace, pojistných smluv a jejich následné zálohování. Současně používáme Excel a Word. Cíl je mít centrální přehled a systematičtější postup. Ideálně i jako cloudové řešení.
Dobrý den, potřebuji naprogramovat makro dle zadání v Excel příloze. Chtěl bych to rozložit na 2 části. 1: dle zadání v excelu 2: později po domluvě dodělat výstup na tiskárnu etiket
...vytvořená na míru našim potřebám, a úpravy jejích stávajících funkcí, - práci na vývoji nových funkcí (např. s cílem usnadnění administrativní práce v nadaci a tím dosažení významných finančních úspor). Hledaný programátor by měl mít: - perfektní znalost MS Access (tabulky, dotazy, formuláře, reporty), - znalost MySQL, - znalost základů relačních databází, - perfektní znalost programování ve VBA (Visual Basic for Application). Nabízíme: - Možnost komunikace s autorem databáze. - K dispozici bude dok...
Hi, I need the following scraped. You can use scraping software or script. YellowPages might be the easiest - law firms and lawyers - only name and email - Colorado, USA
...designed for web browsers, being compatible with Google Chrome, Mozilla Firefox, and Microsoft Edge. Key requirements include: - A voice activated scroll feature that operates when the user finishes reading a line of text. The text should then automatically scroll upward. - If a user misses a word or line of text, but starts reading the next line, the scrolling should resume from the new line. - The application should be responsive, efficient, and user-friendly. The successful freelancer should have experience with: - Blazor application development (WebAssembly). - Voice recognition technology - Web compatibility and optimization If you have worked on similar projects, please include details in your proposal. Required Delivery: Visual Studio 2022 solution Bla...
...need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as well as capability to implement adv...
I have an existing Excel macro that is predominantly used for handling formatting tasks within the Excel file. However, I need an expert who can assess and modify it to ensure compatibility with Excel for Mac 2019 or later. Key Requirements: - The existing macro primarily deals with formatting tasks within the Excel file. - The data in the Excel file is stored in both text and numerical formats. - The main change required is to update the formulas in the macro to ensure it functions smoothly on Excel for Mac 2019 or later. The ideal freelancer for this job would have prior experience with: - Excel macros and VBA - Formatting tasks in Excel - Updating or creating cross-platform Excel macros This project requires a me...
We are looking for freelancer for technological catalogues redesign and build in adobe indesign. Freelancer should be expert in adobe indesign, photoshop, ilustrator. We provide example project templates in adobe indesign, source data in pdf and excel. Based on source data our catalogue should be created and redesigned as template project. Project should be done in adobe indesign for printing and web
...file with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be a plus Please note that while the task is to transfer data,...
I need historical stock prices and income statement data, deliver python script to collect this data for an arbitrary stock from google finance.
--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automat...
Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for merging specificall...
I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Kno...
Hello, This is a $20 project. Looking for a freelancer to develop a python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should target restaurants that have a phone number and *do not* have a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (in meters) - Ensure the business/place is a restaurant, bakery, etc. Key Data to Retrieve, output in a .CSV: - Business Name - Address - Phone Number - Google Maps URL Thank you, trooper501
I'm in need of a skilled professional to help me create a data mining script. The task involves mining emails, data from a certain website and delivering the data in...and delivering the data in a raw text file format. Key Requirements: - Develop a data miner script that can effectively scrape email data from websites. - Ensure the script can handle multiple sources and is scalable for future needs. - Deliver the mined data in a raw text file format. Ideal Skills: - Proficiency in web scraping and data mining techniques. - Experience with developing scripts for text data mining. - Strong knowledge of scripting languages suitable for scraping like Python/BeautifulSoup, R, etc. Please provide samples of your previous similar projects or portfolio that demonstra...
I'm looking for an Indian Python developer to create a script that can retrieve specific data from Telegram. Key Points: - The script should be able to fetch phone numbers and migration of users from Telegram. The ideal candidate should: - Have a strong background in Python development - Be familiar with working with API's - Have experience in web scraping - Have a good understanding of data privacy and security - Be able to deliver the project on a monthly basis. Looking forward to hearing from Python developers with relevant experience.
...AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Native for cross-platform development. - Experience in building apps with live translation capabilities. - Strong background in AI development, specifi...
...my Google Chrome browser, two days ago. Being a macOS user and having multiple accounts on my browser, I have not tried any troubleshooting steps so far. Fortunately, I maintain a full system backup, which could be utilized for restoration. Key Points: - The disappearance of the bookmarks was sudden and unexplained, so this may require more advanced recovery methods. - Expertise in macOS is crucial, as the recovery should be compatible with this operating system. - The presence of multiple accounts on Chrome might complicate the recovery process, so understanding how to navigate this is essential. - Your deep understanding of Google Chrome's architecture is required to successfully retrieve the lost bookmarks from my full system backup. Ideal Skills: - Proficiency i...
I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.
...The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Excellent problem-solving skills and ...
For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!
I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work promptly.
I need an expert in Selenium to automate functionality testing of our web application. This project aims to ensure the application functions as expected with regular, automated testing. Key Responsibilities: - Developing automated functions testing for our web application - Ensuring tests are compatible with Google Chrome. Ideal Skills: - Proficient with Selenium - Familiar with functionality testing. - Reliable and consistent test development. Previous experience with Selenium-based functionality testing in Chrome is highly desirable.
I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.
I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant experience in your applicat...
I'm looking for someone who can...for someone who can create a WordPress plugin for scraping manga websites. Plugin Requirements: 1. Grab per chapter by link. 2. Grab full chapter by link. 3. Grab new manga by link. 4. Compatible with various manga themes. 5. Images from the scraped content should be uploaded to s3 storage. 6. Must have 10 sources for scraping (with a guarantee that if one source fails or the website goes down, it can switch to another source). Usage Flow: 1. I create a manga post and fill in the manga link in the metabox. 2. The plugin will automatically fill in the chapter links, scrape HTML images, and create posts. It will also automatically fill in the chapter number and the manga post ID number based on the manga link. Note: Speed during sc...
I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.
I have an excel file, need add product categorie on a column - budget 100€
...analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables, Statistical Formulas, or Macros/VBA would be an...
I'm in need of a professional who can consistently extract data from a specific website on a daily basis. Key Requirements: - Data Extraction: Extracting various forms of data from a website. - Ongoing basis: This is not a one-time job. I'm looking for long-term cooperation, with the extraction ideally happening on a daily schedule. Ideal Skills and Experience: - Web Scraping: Proficiency in web scraping tools and techniques is a must. - Automation: Experience with automating the extraction process to make it efficient. - Consistency: Ability to maintain a daily extraction schedule accurately is crucial. Please include in your bid how you plan to approach this sort of ongoing data extraction.
fichier sur Excel reproduire le même identique sur Excel avec calcul automatique
Hello, I need complet the Amazon categories catalogue excel in french
I need a professional who can extract data from a website on a daily basis. Key Responsibilities: - Extracting data from a specified website - Ensuring the data is accurate and up to date - Delivering the data in a specified format Skills and Experience: - Proficient in web scraping and data extraction - Experience in automating data extraction processes - Ability to maintain data accuracy and consistency - Knowledge of relevant data formats for delivery - Strong attention to detail and reliability This is an ongoing project, and I need someone who can commit to daily extractions. Be sure to include relevant experience in your bid.
I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.
I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.
I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.
...that the software is designed to run on Windows OS. Website Accessibility: - Restricted access: Websites that require restricted access or login should be identified and reported separately. The software should skip such pages and indicate them as inaccessible. Ideal candidates should possess: - Proficiency in software development and experience in creating similar tools. - Familiarity with web scraping, data extraction, and bulk processing. - Prior experience in creating Windows-compatible software. - Strong attention to detail and the ability to accurately handle and report inaccessible URLs. As the client, I am open to the choice of programming language(s), as the final product is more important to me. The primary goal is to have a reliable and efficient tool that c...
I need a skilled Excel professional to create a comprehensive spreadsheet for financial tracking. - Data Type: The primary focus will be on financial data, so the spreadsheet must expertly handle these calculations and entries. - Data Organization: The data should be organized by project. This includes clear separation of financial data under different project heads, ensuring a clean and easily navigable interface. - Functionality: I am looking for an Excel expert to incorporate some key features to help make the data easier to understand, like conditional formatting. Ideal Skills: - Proficient in Excel, particularly in managing financial data - Experience in creating user-friendly and logically structured spreadsheets - Understanding of conditional formatting and ot...
I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula
...of organizations. The ideal freelancer for this project should have: - Experience in web scraping, particularly with LinkedIn data - Ability to extract data at scale - Proficiency in organizing and structuring data for clear analysis - Strong attention to detail to ensure data accuracy The project involves: - Using the provided list of target companies to source employees' data - Identifying individuals who have previously worked at the provided specific companies - Compiling the data in a spreadsheet format for delivery The successful applicant should not only have the required technical skills but also the capability to deliver quality and timely results. Please showcase your experience in web scraping and the relevant tools you intend to use to ens...
