Extract data excel macroprá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.

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í.

I'd need to extract names web-pages and emails from online database. It will have about 250 entries. Website:

datae

datae

Pro účel vyúčtování potřebuje naše firma macro, které bude kontrolovat platby a jejich zdroje. Macro by také mělo identifikovat transakce, které buď nejsou spojené s žádným prodejem, nebo jsou nějakým jiným způsobem problematické. V příloze je vzor zdrojových souborů: report z našeho systému, výpis transakcí z paypalu, výpis transakcí z bankovního účtu. V případě zájmu/ dotazů mne neváhejte kontaktovat. Strobl

mise en forme

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

Napraviti Excel VBA program

I'd like to extract the phone numbers of real estate agents from a particular website Key Requirements: - Extract agent contact information Ideal Skills and Experience: - Proficiency in web scraping - Experience with data extraction and automation - Strong understanding of data privacy laws and regulations Please note that the data is intended for internal use only and will not be shared with any third-parties.

This project requires a freelancer with advanced skills in Excel. I am outsourcing tasks revolving data management. Key Aspects include: - Advanced manipulation of Excel functions - Complex calculations - Refined data analysis When applying, please focus on: - Your practical experience with similar tasks Having realized the depth of this project, it's pivotal that you have an advanced understanding of Excel. Ideally, your background should perfectly align with data management, advanced calculations, and analytical tasks. Demonstrating this through past projects and describing your specific insights gained from those experiences will be a big plus.

...project requires three core competencies: meticulous data extraction from our website, proficient data entry into an Excel form, and the creation of engaging service descriptions using AI tools. The ultimate goal is to craft a CSV file that not only meets but exceeds the requirements for Square's platform, ensuring a seamless upload process. Key Responsibilities: Data Extraction and Accuracy: Initiate the project by extracting data from specific sections of our website. This data must be accurately transcribed into an Excel form, adhering closely to the required fields. Attention to detail is paramount to ensure that the information captured is both precise and aligned with our needs. Content Creation with AI Tools: With the basic ...

Description: I am looking for a talented and detail-oriented data analyst who is highly skilled in R programming to assist with a couple of important projects. If you have a passion for statistical analysis and can transform complex datasets into clear insights, this opportunity might be perfect for you. Projects Details: Project 1: This project requires deep statistical analysis and simulations involving various probability distributions. Your task will include creating insightful visualizations and interpreting data accurately. Project 2: This project involves calculating conditional probabilities and analyzing normal distributions. Precision and an analytical mindset are essential for success. Required Skills: Expertise in R Programming: You should be adept at writing e...

I have a PNG file that I need the text extracted from and accurately transferred into a Word document. This is to preserve the text and make it editable for future use. The key requirements for this job include: - The extracted text must be precise, with no paraphrasing. - The text should be structured into two continuous columns, which are to be part of a table. The ideal freelancer for this project should: - Have experience in text extraction and document formatting. - Be proficient in Microsoft Word and capable of using its advanced features to meet the specified formatting requirements. - Have an eye for detail and a commitment to delivering work accurately and efficiently. By providing this service, you are helping me to efficiently and effectively convert a non-editable file i...

I'm seeking a proficient ArcGIS Python specialist to help me with a project that involves data analysis and geoprocessing. Key tasks: - **Data Analysis:** You will be responsible for analyzing medium-sized data (1 GB to 10 GB), using ArcGIS Python. Your ability to extract meaningful insights from this data is crucial. - **Geoprocessing:** I need assistance with efficiently processing this spatial data. Your geoprocessing tasks should be meticulous and well-documented. I'm specifically looking for an expert who can create custom GIS tools that can streamline these processes. Ideal Skills and Experience: - Strong proficiency in ArcGIS Python - Extensive experience in data analysis, particularly with medium-sized dataset...

I am seeking an investigative journalist with a knack for unraveling complex crime activities and creating engaging video documentaries. Utilizing your expertise, trace evidence, pinpoint witnesses, and narrate the course of your investigation in a compelling storyline. Key Responsibilities: - Conduct extensive interviews with key witnesses. - Locate and analyze relevant evidence. ...particularly in crime. - Proficiency in conducting ground interviews and collecting evidence. - Strong storytelling ability to make the documentary impactful. - Experience in creating video documentation/reporting is an added advantage. This project is an excellent opportunity for a seasoned investigative journalist, keen to dive deep into the world of crime and bring out an engaging visual ex...

I need a professional to extract Pine Script code from a private TradingView script that I have. - I need the entire source code extracted - The script includes multiple indicators and strategies - I need a functional copy of the extracted Pine Script code Ideally, you should have: - Prior experience working with TradingView and Pine Script - Capable of handling private or invite-only scripts - Understanding of various technical indicators such as Moving Average, RSI, and Bollinger Bands. Please note that the extracted code should be fully functional and operational.

I require an Excel specialist proficient in creating dynamic and functional spreadsheets. This project involves designing a new Excel sheet that handles both numerical and text data. You would need to: - Set up the sheet, capable of performing multiple features such as automated calculations and conditional formatting rules. - Configure simple calculations for GP indicators basing on specific cost prices. - Ensure the spreadsheet can efficiently process a mix of numeric and text data. Strong skills in Excel and data management are essential for this project. Familiarity with advanced Excel functions and an ability to provide quick, efficient solutions to data processing problems would also be very beneficial. A good understanding o...

I'm seeking a professional with a strong background in Excel to develop a keyword search tool for an Excel database. This tool will primarily be used for filtering data and linking to articles hosted on a network. Key Requirements: - Experience creating and managing Excel databases - Proficiency in implementing keyword search tools in Excel I would like the sheet to have a Main/Search Page and another page for the database. I want to be able to add new entries to the database section and have them be searchable on the main page. I want to be able to create new searchable keywords on the database page and have them populate and be searchable on the main page. I would like to be able to enter multiple search terms into the search box to narrow the r...

...IMMEDIATELY! - Extract data in a specified format. - Transfer data from the price listing PDF to an Excel spreadsheet. - Input details such as SKU, Name, Description, Brand, Cost Price, Length, Width, Height, and Weight, which are highlighted in blue. - If any title or heading is not mentioned in the details provided in item #3, add it to columns U-Z. - Ensure all data is formatted correctly, with names in proper case and prices as numerical values. I'm in need of a proficient data entry freelancer to help convert a scanned image PDF to an Excel spreadsheet. Key Details: - The PDF contains less than 50 pages. - The data in the PDF is in the form of scanned images, making it crucial that the freelancer has experi...

I am seeking a skilled freelancer to guide me in creating Power Automate flows that efficiently import data from a single worksheet Excel document into Dataverse. Key Tasks: - Develop a couple of Power Automate flows to import Excel data into Dataverse. - I have had many difficulties with date and lookup/choice columns not correctly importing. Ideal Candidate: - Expert knowledge and experience in Power Automate. - Proficient in Data Integration between applications. - Knowledgeable in creating approval workflows and automated notifications. - Previous experience with Excel-data integration into Dataverse. - Excellent communication skills.

Tengo una asesoría energética, la cual paga comisión por contrato. La comisión depende de distintos factores. Actualmente tenemos un backend en excel y un frontend en pdf, es decir: Creamos las comisiones en excel para agilizar la creación, las copiamos en un POWERPOINT algo más atractivo y visual, y las convertimos a pdf. Nos gustaría poder implementar la subida de estos excels en una interfaz BONITA, incrustrada en una web. Lo ideal sería poder cargar estos excel a la web y que la web "pintara" estas comisiones a través de una interfaz visualmente atractiva y llamativa para nuestros agentes comerciales. Adjuntamos ejemplo de excel de comisiones de algunas de nuestras compa...

I'm in need of a freelancer who can automate my Excel spreadsheet to increase efficiency and accuracy in data entry and analysis. Key Duties: - Automate data input, validation, and manipulation - Perform calculations and formulas automatically - Generate reports and summaries for the data Ideal Skills: - Proficiency in Excel - Excel input form design - Previous experience in automating data entry processes - Understanding of data manipulation

I'm seeking an experienced Google Script specialist to automate tasks and manage data for my project. Here are the specifics: Automating tasks: Your main responsibility will be to automate data import/export processes using Google Script. I need to take the data attahed to a daily email in excel format, upload this data (and historic) to a data base and then allow to consult that data from different spreadsheet in google with a query. Ideal skills and experience include: - Proficiency in Google Scripts and automation - Experience in data management - Google spreadsheet analisis reports If you have the needed expertise, I'm excited to work with you!

I am looking for a skilled freelancer, adept in ETL (Extract, Transform, Load) operations. In this project, your task will be to extract CSV files from an SFTP server and load them onto a SharePoint Document Library. Key responsibilities: - Source the data from the SFTP server. - Ensure accurate and smooth extraction of CSV files. - Successful Load of the data to SharePoint Document Library. Ideal candidate skills and experience: - Solid background in ETL operations. - Prior experience with SFTP servers. - Proficiency with working CSV files. - Familiarity with SharePoint Document Library.

I'm looking for an experienced IoT developer who can create an Arduino-based system that triggers actions or alerts based on scraped text data from a website. Key Responsibilities: - Develop a system using Arduino, Raspberry Pi, and ESP32 microcontroller - Implement website scraping functionality to extract specific text content - Design a mechanism to trigger predefined actions or alerts based on the scraped data Ideal Experience: - Proficient in Arduino programming - Familiarity with ESP32 microcontroller and Raspberry Pi - Experience with website scraping techniques - Ability to integrate scraped data to trigger actions or alerts on an IoT system Please note that my preferred programming language wasn't specified. Feel free to suggest the most a...

For my project, I need a freelancer with strong skills in data scraping and extraction, particularly with textual content and figures, from a specified public website - Tasks: - Effectively pull relevant textual content and figures - Ensuring the scraped data is comprehensive, accurate, and neatly organized Excel Skills: - The data collected must be meticulously stored in an Excel database - The organization method within the database is by entity An effective freelancer must be detail-oriented, proficient in using Excel and knowledgeable about data scraping techniques from public websites. A background in handling similar tasks would be advantageous. Accuracy and neatness in data organization are also paramount. Please indica...

It will crawl and extract all itags from all images from Docker Hub, , AWS ECR Public Gallery, Snapcraft, Flatpak, AppImages, Bundles, BitTorrent, EDonkey2000, SoulSeek and DC++, and it will build and publish deb packages (as APT repository). It will be also run a web server. More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Experience How soon do you need your project completed? No time limit

I need to extract pricing information and contact details from a Chinese website for market research and supplier contact purposes. - Extracting Contact Details: - The project also involves obtaining contact details from the website. This would typically include email addresses, phone numbers, names of suppliers, and any other relevant contact information. - It is important that this data is collected accurately and in a structured format for use in supplier outreach. Ideal Skills: - Proficiency in web scraping and data extraction. - Familiarity with Chinese websites and text. - Experience in market research and supplier sourcing. - Ability to organize data for easy analysis. - Attention to detail and accuracy in data collection. If you have e...

I am looking for a skilled professional to help me with the following project: - Crawl and download containers from Docker Hub and GitHub Container Registry - Extract all binaries, etc, from the containers - Publish the extracted binaries as deb packages in an APT repository - Utilize AI to ensure the repository is kept up-to-date with new and updated binaries daily. Ideal Skills: - Strong experience with container technologies, especially Docker and GitHub Container Registry - Proficiency in building and maintaining APT repositories - Knowledge of AI for automated software updates - Excellent understanding of binary extraction and packaging - Previous experience in software distribution is a plus. Please apply with your relevant experience and a brief outline of how you would ap...

I'm in need of an application that prints labels from an Excel spreadsheet. The scope is to print personalized employee labels with names and respective earnings for cash payments. Key project features: • Read an Excel spreadsheet in a consistent format, with different entries for each worker's name and earnings. • Print labels with the worker's name and corresponding earning. Candidates should have: • Extensive experience in programming • Familiarity with reading data from Excel • Expertise in printing functions Just to clarify, the format of the spreadsheet will always be the same, only the contents (worker names and earnings) will differ. Please ensure the program is capable of handling this accuratel...

...including text and images, for offline viewing. Key Requirements: - Archive text and images: The system should be able to save text and image content from websites. Use appropriate tools like HTTrack, Wget, or WebCopy to mirror the website. - Single archive process: The content will require archiving only once, as it won't be updated frequently. Ideal Skills: - Proficient in web scraping: Ability to extract and save content from websites. - Experience with archiving systems: Previous work on systems that save web content for offline use. - Knowledge of offline storage: Understanding of how to save and retrieve content without requiring an internet connection. This project is ideal for someone who is looking to work on a one-time archiving system, and who has a background ...

I'm in need of a proficient social media manager who can post daily content on Facebook, Instagram, TikTok, and other platforms through Loomly. The job will mostly entail modification of existing content. However, your creative input is most welcome. There is an official step-by-step Process to follow. Minor Excel reporting is required as well. I need somebody who is proficient in English-written and listening/talking. Must be able to work in a New York time zone between the hours of 12 PM and 8 PM. Roughly 2-3 hours a day total Monday-Friday at $30 a week! This role requires: - Excellent understanding of these four platforms - Proven ability to edit and modify existing content in an appealing way - Capacity to deliver consistently on a daily basis - Attention-to-detail...

...level. Currently: 1) Written in MS Excel and utilizing Macros for a. Navigation between Sheets b. Set a subscription, 1st time the Worksheet is run, it writes a date in a database worksheet 2) There are 2 worksheets for Input: a. Customer Main Input Screen - worksheet (90% of the application runs off data from this worksheet i. The information from this worksheet is utilized for all 8 other reports (worksheets it produces). ii. It uses a “What is your current yearly revenue” number and pulls against an array (worksheet) – For the 8 other reports, it pulls data from the column in the array to produce reports. b. Customer EBITDA and P&L – Some data from the array is utilized here, and this being a customer input screen, ...

I'm urgently looking for a web scraping expert who can help me gather information from various medical service provider websites. Key Requirements: - Extract doctor names, contact information, medical service details, and additional data such as phone numbers, specialties, and participating plans. - The information should be pulled from three specific websites - Website 1, Website 2, and Website 3. Your deliverable: - The scraped data should be compiled into a CSV format for easy analysis and integration into our system. Ideal Skills: - Proficient in web scraping and data extraction - Advanced knowledge in handling and exporting data formats like CSV - Experience in scraping medical websites or similar domains would be a plus. Please bid only...

I'm seeking a talented developer to create a custom Telegram bot for my company. The bot will serve as a communication tool and a source of information. Ideal Skills & Experience: - Proficiency in Telegram Bot API - Experience with bot design, including user input and automated messagin...Documents and presentations - Training materials - Policies and procedures Your design should ensure the bot is user-friendly, reliable, and able to handle the company's internal resources efficiently. The Most important thing is the BOT must be PRIVATE and the only method to subscribe to BOT channel is by OTP sent to the registered e-mail in my company domain. The email list will be provided by excel sheet to you. The second MOST important thing is that the bot channel must be un...

You are asked to create an Excel file (FILE A) that: 1) Automatically extract data from another Excel file (FILE B) which is located in an FTP folder and which is updated every day. 2) The FILE A must extrapolate the data from the FILE B based on some filters that can be set or changed. For example, a filter could be the Brand or the Price. 3) The output (FILE C) of FILE A must be a .CSV file composed of 3 columns: SKU, Quantity and Price. 4) The final part is that this FILE C is saved inside another FTP folder. This entire 1+2+3+4 process must be done automatically every day at a certain time without the intervention of an operator.

I'm looking for a skilled Excel expert to work on my financial data. The task involves clearing the data and conducting a thorough analysis specifically focused on profitability. Key responsibilities: - Clearing the provided financial data - Analyzing the data based on the profitability metrics Ideal skills and qualifications: - Proficiency in MS Excel, especially in data analysis - Strong understanding of financial metrics, particularly profitability - Attention to detail and ability to ensure data accuracy - Ability to present findings in a clear, concise manner - Previous experience working with financial data is a plus Please note that the data requires thorough analysis. Clarity and precision are crucial as...

I have a set of Excel sheets that need to be transformed into a powerful data analysis tool. The primary purpose of this tool is to provide detailed data analysis in the form of summary reports. Key requirements: - Data analysis: The tool needs to be proficient in data analysis. It should be able to handle the data provided and present it in a clear and concise manner. - Summary reports: The data analysis results should be presented in summary reports. These reports need to be visually appealing and easily digestible for a non-technical audience. - Automated chart updates: When new data is added to the tool, the charts should be automatically updated to reflect these new changes. This automation is crucial to ensure the tool remains...

I have a database with 200,000 SKU's from retail sales, un...SKU's from retail sales, unfortunately lacking category, subcategory, and brand details. I'm seeking a skilled professional who can assist in mapping these details effectively. Key Deliverables: - Utilize a data matching algorithm to automatically map the SKU's with high accuracy (90-95%). - Present the final output in an Excel spreadsheet. Ideal Skills: - Proven experience in data matching and SKU mapping. - Proficiency in using data matching algorithms. - Experience with handling large datasets. Accuracy is paramount for this project, as the mapped details will be used for further data analysis and decision-making in our retail operations. A high level of precision will...

I'm seeking a proficient video editor with a knack for enhancing gameplay footage. The task is twofold: 1. Edit Gameplay Highlights: I require someone who can take raw footage and extract the most exhilarating gameplay moments. 2. Create Montage of Funny Moments: Additionally, you must be able to identify and compile hilarious incidents in the game into a separate, engaging montage. Experience in gaming video editing and a good sense of timing and humor are crucial for this job.

I'm seeking an experienced Tableau and Excel expert to assist in creating a high-quality data visualization project. Key project requirements include: - Intermediate level of complexity: The data that needs to be visualized is sourced from multiple sources and requires the implementation of filters. - User-driven data filtering: I am looking to implement specific interactivity features that allow users to manipulate and filter data. The ideal candidate will have: - Proficiency in Tableau and Excel - Experience in creating intermediate level data visualizations - Strong understanding of data filtering and interactivity features If you possess the required skills and experience, please bid on this project.

...app, where users can take a photo of the red scratches on the package and convert the red intensity into the applied pressure values. Below we explain these steps. 1. Users scan the red scratch by taking a photo with a mobile. 2. The app separates the photo into R, G, B images. 3. The app only uses R channel (discard the rest). The app detects the starched line from the R channel image and extract the average value of the red intensity on the scratched line. The app also detects the red intensity on the background. The app calculates Rstratch – Rbackground = dR. 4. We have a calibration equation (Pressure = dR x alpha). Based on the calibration equation, the app converts the average red intensity to the average pressure. 5. The app displays the estimated average press...

...an experienced and knowledgeable data scraping professional to collect specific information from three major platforms - RERA websites (specifically Maharashtra, Telangana, Haryana, and Delhi), Google, and Justdial. Here's what I am looking for: Details to Scrape: - Name - Mobile Numbers - Locality - City - Address - Pincode Platforms: - RERA Websites (Maharashtra, Telangana, Haryana, Delhi) - Google (DSA and Loan Agents data) - Justdial (DSA and Loan Agents data) The ideal freelancer for this job will be highly experienced in data scraping and will be able to deliver the results in an organized manner. Proficiency in scraping from Google, RERA websites, and Justdial is particularly important. Delivery Format: - The data should be delivere...

I'm in need of a detail-oriented specialist to perform data entry on textual content that's already well-organized. Key Tasks: - Accurate entry of textual data into Excel format - Pace of work should be efficient without compromising the quality - Ensure a smooth transition of data, maintaining its organization Ideal Skills and Experience: - Previous experience in data entry jobs would be beneficial - Proficiency in Excel - Excellent attention to detail - Ability to handle data in an organized manner - Good command of English language to understand textual data.

I'm seeking an expert in developing a conversational AI platform that can transcribe and summarize patient-physician conversations. Key Features: - Real-time transcription - Speaker identification - Language detection - Segment transcripts - Validate outputs with evidence mapping - Extract structured medical terms - Summarized clinical notes - Identify Medications and Doses The ideal candidate should have: - Proficiency in developing and implementing generative AI - Proven experience in building advanced conversational AI platforms - Strong background in real-time transcription and summarization - Previous work in the medical field or conversant with medical terminology The project has a tight deadline and needs to be completed within a month or two. Please...

I have a 3.5-page handwritten sign-in sheet that I need transcribed into an Excel spreadsheet. The main purpose of this task is to make it easier for me to search through the records. The final document should be a straightforward, clean and well-organized spreadsheet, reflecting the original sign-in sheet's content as accurately as possible. Skills and experience necessary: - Proficiency in transcription, especially from handwritten documents - Strong knowledge of Excel or Google Sheets for high-quality spreadsheet creation - Attention to detail to ensure accuracy and completeness of the transcription The ideal freelancer should be reliable, with good communication skills to ensure smooth and efficient completion of the project. Color-coding or highlighting of spec...