Compare two csv files in excelprá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.
I need to scrape data from real estate website. Specifically data under these two filters: Together some 9300 real estates in two separate datasets. Only the text data is needed (no pictures, no maps), preferably in xls or csv.
Převod v minulosti zaznamenaných měření z na Chci to mít někde pohromadě. Původní webapp je dost nepřehledná a non-user-friendly, nová lepší, ale nemá možnost ručního přidání starších dat ani nějaký jednoduchý import. Zdrojová data z Healthplanet by snad měla jít sosnout přes...zaznamenaných měření z na Chci to mít někde pohromadě. Původní webapp je dost nepřehledná a non-user-friendly, nová lepší, ale nemá možnost ručního přidání starších dat ani nějaký jednoduchý import. Zdrojová data z Healthplanet by snad měla jít sosnout přes nějakej...
Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.
...neumožňuje ukládání do XLS. Sháníme tedy programátora, který se chce na našem projektu podílet a vytvoří jednoduchou aplikaci, který bude sloužit k ukládání vyčítaných dat do PC. Požadavky: Spustitelný *.EXE SW s možností přidání do naplánovaných úloh. SW bude mít jen pár základních parametrů. 1) URL ke xml souboru (možnost zadání user & password) 2) Název souboru kam vyčítat 3) přípona (xls, xlsx, csv) 4) interval ukládání hodnot (xml je aktualizováno při každém obnovení) 5s, 10s, 30s, 60s, 120s, 300s, 600s, (3...
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í.
Dobry den, poptavam podporu pri web scrappingu informaci o nemovitostech z konkretniho webu. Jedna se mi o strukturovane ulozeni informaci z webove stranky (bude upresneno) do xlsx/csv a idealni automatickou aktualizaci teto databaze. [Removed for encouraging offsite communication which is against our Terms and Conditions -Section 13:Communication With Other Users] Predem dekuji. S pozdravem, Dan Vasko
Jedna se o dokonceni eshop od webnode na kterym uz pracuji. Par detailu + hlavne import produktu od Partnera pomoci CSV souboru. Predem dekuji.
Hledám programátora, který zajistí automatický import produktů (dat) ze stránek dodavatele do e-shopu. Součástí importu bude i překlad (Google)
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
Potřebuji vytvořit jednoduchý SW a GUI v Jave, který se bude připojovat na cca 5 zdrojů dat přes jejich API, bude ukládat data z těchto zdrojů do .csv plus bude schopen využít některé příkazy jednotlivých API zdroje.
Potřebuji vytvořit jednoduchý SW a GUI v Jave, který se bude připojovat na cca 5 zdrojů dat přes jejich API, bude ukládat data z těchto zdrojů do .csv plus bude schopen využít některé příkazy jednotlivých API zdroje.
Úpravu CSV importu pro import produktů do Magenta.
Chtěli bychom přenést stávající eshop (), který běží na pronájmu na vlastní prestashop řešení. Z eshopu bychom chtěli hromadně přenést produkty (xml nebo csv) a kdyby to bylo možné, tak i dosavadní objednávky a nějaká další data. Od systému prestashop bychom poté požadovali tyto funkce: xml import produktů (automatický z feedů dodavatelů), xml export na srovnávače (heureka, zboží, hyperzbozi,...), možnost SEO optimalizace (úprava meta informací, "dobré" url adresy), možnost integrace platební brány, integrace Ulož (výběr z odběrných míst), generování...
Nastavení vytvořených Facebook účtu podle parametrů zadaných v excelu - změna jména, skrytí privatních informací (skrýt zeď pouze přátelé, skrýt kamarády pouze pro přátelů), pohlaví, pohlaví a nastavení nějakých like stránek z Czech Republic. atd. Já pošlu Excel po dohodnutí se na zakázce. První zadání je úprava 300 FB účtů.
--- ### 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...
...(USPs) --Colors --Sizes --Call to Action (CTA) text --Description --Specifications --Other relevant information -Enable users to specify which pages, products, and categories to manage, and which information to include in exports. Generate XML or CSV links based on user selection. -Allow users to update specific pieces of collected information across all or selected pages, ensuring data remains current and accurate. 2. Proxy System -Implement a dedicated IP system (proxy system) to avoid server or firewall blocking. 3. Data Access and Export -Allow data export in formats such as CSV, XML, etc. -Ensure data export is compatible with Google Merchant Center and other similar advertising services. 4. User Interface -Provide an interface that allows users to explo...
I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our workflow. Looking forward to ...
...Your expertise in this area is crucial. You should have a deep understanding of project management principles, particularly as they apply to construction projects. - **Price Comparison:** You'll be required to create a template that allows me to compare prices for different construction-related products and services. - **Task Scheduling:** This is a key feature that the template should have. It should make it easy for me to schedule different tasks and track their progress. - **Budget Tracking:** Another essential feature. The template should have the capability to track my budget as I enter costs for different services and products. Given the complexity of construction projects and the need for accurate cost comparison, the ideal candidate should have: - Previou...
I need a professional to consolidate and transfer formatting and illustrations from two versions of a booklet on Microsoft Publisher 2019 to a Word file with the correct content. Your task will involve: - Ensuring the booklet's formatting is consistent and professional. - The formatting and placement of illustrations and other visual elements are according to instructed guidelines. - Utilizing advanced formatting tools in Word to create headers, footers, page numbers, and styles. - Maintaining and enhancing the booklet's overall aesthetic and educational value. The ideal candidate for this job should have: - Proficiency in Microsoft Publisher 2019 and Word. - Experience in handling booklet materials. - A keen eye for detail and design. - Strong comm...
...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...
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 ...
I have a PDF 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 whil...
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 crit...
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...
I’m looking for a skilled freelancer to assist in implementing specific modules in Odoo and integrating third-party apps in a bid to significantly improve the customer experience as well as streamline our business systems. You should have: - Outstanding experience and expertise in Odoo implementation and project management. - Proven track record in integrating third-party software and adapting functionalities. - Exceptional familiarity with CRM, Inventory Management, Accounting, and us of Odoo apps to manage food delivery. Key tasks include: 1. Data Migration: -Taking CSV files of my exported sales data from Shopkeep and importing it into Odoo without loss of critical information in order to enable reporting on old sales ...
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
...the next value in the sequence. Write recursive solution. • Test both programs for different input sizes and compare their performance. Task 2: Parallelize the algorithms for the second and third recursive equations obtained from the 1 practical selection test, and also parallelize second and third algorithms obtained from the 4 practical task selection test. Ensure that the programs correctly synchronizes the threads by comparing the final results of the sequential and parallel versions of the programs. • Analyze the sequential and parallel algorithms and determine their computational complexity using both Big O and Omega notations. • Measure and compare the execution time of the sequential and parallel versions of the programs and identify any p...
...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, specifically in language understanding. - Familiarity with integrating text-to-speech features for the AI assistant would be a plus. I'm looking for a professional who can deliver a high-quality, user-friendly app that meets these key requirements. Please include relevant examples of your previo...
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.
I'm looking for Shopify store owners to install and test two Shopify apps. This project entails the following: - Installing and testing two Shopify apps. - Providing comprehensive feedback on the apps based on usability, performance, features, and overall experience. - The chosen apps should heavily emphasize social media promotion features. The ideal freelancer for this project should: - Have a good understanding of Shopify and its app ecosystem. - Be experienced in using and evaluating marketing apps. - Be able to provide detailed and constructive feedback. - Have a keen eye for user experience and app performance.
I'm in need of an experienced C# desktop programmer who is well-versed in SQL Server 2019. 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 functio...
...design concept. - Interior design rendering with pictures of the floors in the shape of a running track, numbered with the track number and the distance traveled on both sides of the escalators, as well as in the floor areas that do not have escalators, showing the percentage of calories burned for each specific distance, and pictures on the walls of information about health, nutrition, and others related to the health facilities of the facility itself. Also, in the middle of the bridge, in the corners, there are giant wall advertising screens. The freelancer should be able to play around with different furniture layouts to help me decide on the best arrangement. see attached pics please. Ideal Skills: - Proficiency in 3D rendering software such as B...
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 ex...
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 ...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 ...
...and mobile app and also can be uploaded through excel sheet with serial number of all products. 4. Customer can see all the uploaded products and can request for quotation. There is no need to show the available quantity (stock) to customers. 5. Admin can see the requested quotes where the prices and quantity will be reflected of all the products in quotation. Admin can edit the prices manually and can share and download the requested quotation to anyone. 6. Admin can create multiple sub admins and can assign different rights to them as he wants. 7. After approval of the quotation of the customer, he can place the order and unique order id must be generated against each order. 8. Admin can see the order history and filter the data as required. In order history cust...
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€
...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 add...
fichier sur Excel reproduire le même identique sur Excel avec calcul automatique
