Graph csv files excelpráce
Dobrý den, prosím o pomoc při parsování dat z CSV do XLSX. Zdrojové CSV obsahuje HEADERS, pak je několik řádků dat vztahujících se k těmto Headers. Po datech následují další HEADERS, které jsou rozdílné od předchozích HEADERS v názvech i počtu, a opět následuje několik řádků dat. Toto se opakuje, celkem jde o cca 368 řádků v CSV, z toho asi 20 HEADERS řádků. Data z CSV nechť jsou exportována do jediného XLSX. Struktura cílového XLSX: 1) ke každému (skoro každému) HEADERS řádku bude vytvořen v XLSX nový List, jehož název bude zhruba odpovídat prvn&ia...
Potřebovala bych sestavit v Excel nebo v jiném programu algoritmy na manuální zadání nebo načtení přes SD kartu 8mi výstupů z měření na váze Tanita (množství tuku, viscerální tuk, metabolický věk, množství vody, ...) tak, aby se tyto hodnoty převedly do grafické analýzy v podobě grafů, "koláčů" či obrázků zatížení tuku na těle (podobně jak výstup z GMON tanita nebo InBody softwaru). Účel je pro použití pro výstup pro klienty výživového poradce a pro ios systém (MacBook Air). Hledám cenově dostupnou varientu, klidně pro cenovou efektivitu jen v Excelu, ale zajímaly by mě mož...
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ů.
Mo...you prefer for the email addresses? Excel spreadsheet How many local authorities are you targeting? More than 50 What specific information do you need besides email addresses? Contact names, Phone numbers, Email addresses The project needs to be completed within 1 week. Please verify all email addresses to ensure accuracy. These email addresses will be used for outreach campaigns targeting local authorities. Please include the contact departments associated with each email address. Please categorize the email addresses by region. Please conduct manual verification to ensure the accuracy of the email addresses. Please treat all regions with equal priority. The primary purpose of this outreach campaign is to request collaboration. Please name the files based on their re...
I'm looking for an Excel expert who can create a Google Sheet for tracking my cryptocurrency portfolio. The sheet should monitor Bitcoin (BTC) and Solana in real-time, displaying market prices, portfolio movements, and gain/loss metrics. It should also feature Line charts, Bar charts, and Pie charts to visualize the data. Key Requirements: - Proficiency in Excel and Google Sheets - Experience in creating real-time data tracking tools - Ability to create and integrate various types of charts Ideal Skills: - Strong understanding of cryptocurrency and market tracking - Excellent data visualization skills - Attention to detail to ensure accurate tracking of gains and losses
I'm in need of a professional who can develop a method to link multiple Word documents with various Excel files. The goal is to create a comprehensive mapping matrix to facilitate process automation. Key Requirements: - Mapping of diverse data types: This includes text, numbers, formulas, assessment questions and workbook content from the Word documents to the Excel files. - Establishing a Many-to-Many relationship: The project involves linking multiple Word docs to multiple Excel files, ensuring a well-structured and efficient mapping system. Ideal Skills: - Proficiency in Microsoft Word and Excel - Expertise in creating mapping matrices - Experience in process automation Your bid should reflect your ability to deliver a seamless, ...
...phase of this project will focus on core functionalities like order creation and invoicing, with a simplified user role system (admin and non-admin) and no external integrations. 2. Project Scope 2. Implement a search function to quickly locate orders using various filters such as customer name, order ID, or date range. 3. Allow exporting orders and invoicing data in various formats like CSV, PDF, and Excel for external reporting or bookkeeping needs. 4. Set up email or SMS notifications for important events like order creation, completion, and shipping updates. 5. Maintain a detailed log of changes and actions performed on each order, such as edits, status changes, and notes. 6. Enable bulk processing features to handle multiple orders simultaneously for operations like ...
I'm in need of a professional to help me organize some legal documents and prepare various spreadsheets for legal purposes. The types of documents that need to be organized include text messages, expenses, and emails. Ideal Skills: - Document management - Spreadsheet proficiency (Excel, Google Sheets) - Attention to detail - Understanding of legal documentation processes - Confidentiality and discretion Project Requirements: - Organize text messages, expenses, and emails - Prepare spreadsheets for expense tracking, communication logs, email records - Categorize expenses by date, type of expense, and client Please keep in mind that this project requires a high degree of confidentiality and discretion. Your ability to maintain privacy while handling these sensit...
I need an Excel spreadsheet template for a quality control inspection report tailored for a machine shop. Key Requirements: - The template should include an inspection checklist - There should be a section for Pass/Fail criteria - The template should be user-friendly and easy to navigate - The design should be professional and suitable for a machine shop context Ideal Skills and Experience: - Proficiency in Excel - Experience with quality control processes in machine shops - Ability to create clear, concise, and professional templates
I have a 2D data file (.dat) that ENVI can open and visualize. It is a datacube, in which every pixel has its own graph. It is in that sense a 3D data. I would like to do Principal Component Analyses on this data file to extract meaningful data, such as the variations and representative graphs / regions etc. I need someone who can write a code to do statistical analyses on a .dat file using python in jupyter notebook. Key Requirements: - Experience in Python, specifically in Jupyter Notebook - Proficient especially in using NumPy and SciPy for statistical analysis - Able to interpret and visualize data The data is structured in a gridded format with spatial dimensions. Each pixel in the datacube corresponds to a specific spatial location. I need someone who can write a code to do ...
I'm in urgent need of an Excel macros specialist who can help with data analysis and reporting on financial data. Key Requirements: - Expertise in Excel macros, specifically for data analysis and reporting. - Proficiency in handling and interpreting financial data. - Ability to create summary reports from complex datasets. Ideal candidates will have a strong background in finance and data analysis, with a track record of creating effective Excel macros. Please be prepared to showcase examples of your previous work in this area.
...enterprise users. B. Home Tab (Landing Page) Content: Company overview (e.g., mission, key metrics, sustainability goals). Customizable dashboard with widgets (e.g., emissions trends, compliance progress, ). Design Requirements: Modular widget-based layout with drag-and-drop functionality. Display of current Scope 1, 2, and 3 data summaries. C. Data Capture (Scope 1, 2, 3) Features: Data upload via CSV . Validation rules through template Bulk and single upload feature Scope 1, 2, and 3 categorization with a guided upload process. UI Design Notes: Step-by-step wizard for uploads. Icons and visual cues to differentiate emission scopes. D. Analyze Section Purpose: Display computations from uploaded data. Provide insights on emissions trends, hotspots, and anomalies. Visualization: I...
Description: We are looking for an experienced freelancer or team to extract data from a large volume of PDF files. Due to the scale of this task, we prefer candidates who can develop automated scripts for efficient data extraction or those with a team capable of handling bulk processing. Requirements: • Expertise in Python or other relevant programming languages for PDF parsing • Experience with libraries such as PyPDF2, PDFMiner, or similar tools • Ability to extract structured data accurately (tables, text, etc.) • Handling of different PDF formats and layouts • Data output must be in Excel (.xlsx) format per template provided. Preferred Qualifications: • Prior experience with large-scale data extraction • Strong attention to detail and...
...questionnaire with set parameters need to be uploaded on the site for the visitors to take the survey with a description of the survey and its importance. Once a survey is live we need to register the records for 45 days during that time our partner NPOs work locally in promoting and awaring people to take survey. Post 45 days we need to fetch all the information into spreadsheet (Google Sheet, Excel recommend) the using Power BI, python language another team work on analizing the records and forms a detailed illustration for the data. And a well defined resource backed research paper need to publish on the site in the form of blog and a download link for the papers. Based on working description of the company I need a mature design for the website. The work will include &quo...
I'm looking for a professional to help me fill out an Excel sheet for a financial model. The sheet will involve data from the Income Statement, Balance Sheet, Cash Flow, Operating Working Capital, debt, depreciation, amortization, equity, shares, and various financial ratios. The annual report is available for reference. Skills and experience required: - Extensive knowledge of financial modeling - Proficiency in Excel - Ability to interpret and analyze financial statements - Experience working with financial ratios - Attention to detail.
I'm looking for a freelancer who can build a comprehensive dashboard in Excel for tracking employee performance data. Key Requirements: - The dashboard should track 16 key performance indicators (KPIs) related to equipment conditions. - Visual elements should include charts, graphs, gauges, and meters. I already make it but need to enhance and also to add more slides. Ideal Skills: - Proficient in Excel with experience in building dashboards. - Understanding of employee performance and equipment condition metrics. - Capable of creating user-friendly, visually appealing dashboards.
...appointments. Your main responsibilities will include: - Data Entry: Accurately inputting information into Microsoft Excel/Word. - Email Handling: Managing my inbox, sorting emails, and responding to necessary correspondence. - Scheduling Appointments: Coordinating my calendar and setting up meetings. - Travel Arrangements: Booking flights, hotels, and transportation for business trips. - File Management: Organizing and maintaining digital and physical files. - Document Preparation: Creating and editing reports, presentations, and other documents as needed. - Meeting Minutes: Taking detailed notes during meetings and distributing them as needed. I prefer using Microsoft Excel/Word for task management, so proficiency in these programs is essential. Communication w...
I'm in need of a proficient data scraper who can extract the staff list from a specified university website. The data fields I require are: - Name - Email - Phone number - Department - Designation The scraped data needs to be delivered in CSV format. This is a one-time project, so I won't need recurring updates. Ideal skills and experience include: - Proficiency in data scraping tools and software - Experience with web scraping from .edu websites - Strong attention to detail for data accuracy - Ability to deliver data in specified format (CSV) Looking forward to your proposals.
I'm looking for a freelancer who can analyze and format my sales data into a clear, tabular Excel report. Key Requirements: - Experience with Excel is a must, especially with data formatting. - Familiarity with sales metrics and how to present them in an informative manner. - Ability to meet deadlines and provide a high-quality, easy-to-understand report. The report will primarily focus on total sales, sales by product category, and sales by region.
I'm looking for an experienced Excel professional to compile a calendar for 2025 and 2026. This will include marking work tasks and deadlines, 2nd & 4th Saturdays, Sundays and all Hindu holidays. Key Requirements: - Organize data week-wise in an Excel sheet - Distinctly mark 2nd & 4th Saturdays and all Sundays - Highlight all Hindu holidays and list them in a separate column - Use Conditional Formatting and Pivot Tables to ensure easy readability and proper formatting Ideal Skills: - Proficiency in Microsoft Excel (Formulas, Conditional Formatting, Pivot Tables, etc.) - Data Entry & Processing - Attention to detail - Experience handling large datasets Deliverables: - Well-structured Excel sheet - Clearly marked week-wise data - Properly high...
I'm seeking a meticulous Data Entry Operator to assist with inputting and structuring data into Microsoft Excel. The job will entail: - Transcribing data from a variety of sources including scanned documents, PDFs, and handwritten notes into an Excel spreadsheet. - Ensuring the accuracy of the data and catching any potential errors. - Structuring the data chronologically for easy access and retrieval. - Upholding confidentiality when dealing with sensitive information. Ideal candidates should have: - A good typing speed and a high degree of accuracy. - Proven experience with Microsoft Excel or other data entry software. - An exceptional attention to detail. - The ability to meet deadlines consistently. Project Duration: 1-2 weeks (potential for extension based...
I have a project that involves working with text data. Your task will be to create a macro that manipulates the data and copies it into a template table. Ideal skills for this job: - Macro creation/visual basic - Strong proficiency in data manipulation - Excellent attention to detail - Experience with text data - Familiarity with CSV file format - Content modification skills
I'm looking for a skilled developer to create a Windows application that scrapes data from e-commerce websites and updates it in a CSV file. Key Responsibilities: - The app should monitor and record product prices, stock levels, and sale prices. - Data should be sourced from various e-commerce websites. - Updated data should be formatted and saved in a CSV file. Ideal Skills: - Proficiency in Windows application development. - Experience with web scraping tools and techniques. - Familiarity with data formatting and file handling, particularly CSV files.
...Ideal candidates for this project should have: - Extensive experience in payroll and tax form preparation. - Familiarity with W-2C forms and the reasons for their use. - Ability to work meticulously and maintain a high level of accuracy. - Demonstrated track record of precision and attention to detail in payroll tasks. The employee information will be provided in a digital format such as an Excel or Spreadsheet. The W-2C forms should be completed within 2 weeks. The completed W-2C forms should be provided in PDF format. You may use any software you are comfortable with for preparing the W-2C forms. The freelancer should also review the corrected wage information to ensure its accuracy. The freelancer only needs to prepare the W-2C forms. The selected freelancer will be respons...
...organizing, and optimizing ad creatives for digital marketing campaigns✅ Web Development & Email Marketing Support: Help in basic website updates, email campaign execution, and tracking performance analytics✅ Inbox & Task Organization: Assist in managing and organizing business and customer emails for better workflow efficiency ? Requirements & Qualifications: ✔️ Expert in Google Sheets / Excel (advanced formulas, pivot tables, conditional formatting, scripting)✔️ Experience with Shopify API, , and Zapier✔️ Ability to automate data imports and reports✔️ Strong understanding of demand forecasting & financial modeling✔️ Experience working with inventory tracking and supplier forecasting✔️ Proficiency in customer support data tracking and report generation✔️ Ex...
...skills for various projects. Translation: Professional translation services for documents and content. Medical Writing: Assistance with healthcare-related content and research. Data Entry: Accurate and efficient data management. Diet & Public Health Research: Creating reports and articles related to diet and health. PowerPoint Presentations: Creating professional and engaging presentations. Excel Work: Data analysis, charts, and spreadsheet management. Requirements: Strong attention to detail. Relevant experience in any of the above-mentioned fields. Ability to meet deadlines. Deliverables: High-quality, error-free work. Submission within the agreed timeline. Budget: Flexible, depending on the project scope and quality. These projects are long-term, requirin...
I require an Excel expert to streamline my weekly report process. This involves merging four distinct reports - Maintenance, Operations, Supply Chain Management (SCM), and Finance - into one comprehensive Excel spreadsheet. Key tasks: - Combine the four reports into one Excel sheet on a weekly basis. - Visualize the data trends over time using a bar graph. - Ensure the graph highlights the key trends across the four departments. - Automate the import of data from each of the four reports to reduce manual input. - Develop a dashboard in Excel that displays key metrics and trends in a user-friendly format. - Generate a weekly summary report that provides insights and highlights key findings. - Set up conditional formatting or alerts to flag any sig...
Need to cover and update the following points 1: Prevent users from copying and pasting data to the Template file from other files 2: Link the new planning template to VLOOKUP file. Need the Dropdown data validation options on this file to match the Vlookup file that we maintain separately and use for our other templates. 3: Ensure that VLOOKUP file needs to be referenced from original location instead of creating a copy to the folder. 4: Stop workbook links message when file is opened 5: Stop VLOOKUP file closing message when file is closed
I am looking for a skilled Power BI expert to create a dashboard primarily focusing on sales analytics. Key Requirements: - The dashboard should connect to Excel/CSV files. - It should track revenue by product. Ideal Skills and Experience: - Proficiency in Power BI. - Experience in sales analytics. - Ability to work with Excel/CSV data sources.
