Vba excel read csv dataprá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 nějakej json (případně ručně, ale je toho dost), do MyTanita pak naimportovat v podvrženém CSV jako data z váhy BC-601.
Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.
Jsme výrobci zařízení BCC, které slouží ke vzdálené správě ochranného obvodu bateriových článků. BCC exportuje data o napětí, atd do XML souboru, ale 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 & passwor...
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.
...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...
Ú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ů.
Create a consolidated financial statement for a transportation sector group. The tasks include: - Translating and reclassifying financial statements from...financial statement. - Paying particular attention to intercompany transactions, as 98% of the branch's revenue comes from the mother company. - Ensuring that intercompany transactions are correctly accounted for in the appropriate fiscal years. - Carefully handling different currencies (RON and EUR) present within the branch. - Producing the final result in English, using Euros as the currency, and in Excel format with notes on intercompany transactions regularized in the correct fiscal years. Requirements: - Certification in financial analysis. - Experience in creating consolidated financial statements. Note: - This pro...
1 am looking for a skilled data entry freelancer to help me with a large project involving the input of text data into an Excel spreadsheet. The ideal candidate will have experience with Excel and be able to accurately input a large amount of data efficiently. Skills/Experience: - Proficient in Excel - Accurate and efficient data entry skills - Experience with large data sets - Detail-oriented - Ability to meet deadlines Project Details: - Inputting text data into an Excel spreadsheet - Large data set consisting of more than 500 entries - No specific format required, however, the data must be accurately entered - Payment will be based on the number of entries completed - Deadline for completion will be disc...
I'm looking for someone to help me organize and input my personal finance data into an Excel sheet. The Excel sheet is intended to be a combination of both summary and itemized details. This means that your work will involve both categorizing transactions, and summarizing them by month or year. This project requires a good understanding of personal finance, as well as data entry experience. The ideal candidate should be able to work with sensitive financial information and must be able to keep this data confidential. If you have experience in personal finance or accounting, and can handle this kind of detailed data entry, I'd love to hear from you.
...assistance with a large data entry project. The task primarily involves inputting text and numeric data into an Excel spreadsheet. Key tasks include: - Data Entry: You would be required to input data across multiple columns and rows. This data consists of a mix of text and numbers. - Basic Arithmetic: In addition to the data entry, I will need some basic calculations added to the spreadsheet. This includes performing simple arithmetic like sum and average calculations across different columns. Ideal skills: - Proficient in Excel: You should have a strong understanding of Excel functions and formulas. - Attention to Detail: As this is a large dataset, precision and accuracy in data entry is key. - Basic Arithmetic: ...
Simple Shopify Store Fix: Need Logo, Copyright and Credit Card Icons centered on Footer of Shopify Store, For Both Desktop and Mobile Version. Look at photos attached. This is a very simple fix that will take less than 5 minutes if you read the description instead of just making an automatic bid. I will not consider any proposals over $20.
I have a PDF document that I need retyped into an Excel file. The PDF consists of a total of 10000 pages with data organized in 4 columns. I'm looking for an experienced multiple freelancer who can accurately retype the data from the PDF into an Excel spreadsheet as plain text. Key requirements: - Retyping the content of a large PDF file into Excel - Data organization into 4 columns - Ensuring high accuracy in data entry See the attached file and google sheet link I will give 500 pages first if we meet rate and deadline.
France French Recording Project We have a project, that needs Native France French speakers, we will give you the text, and you need to record 89 short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without an echo. 2. Each person Price is 5$ for 89 short sentences record. 4. The project will take about 10-15 mins only. If you are interested please let me know sure. I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :
...adept at managing my calendar and coordinating with my contacts. - Managing emails and correspondence: You'll be responsible for filtering and replying to emails on my behalf. - Organizing documents and files: Keeping my paperwork in order is crucial. You should be proficient at filing, archiving, and retrieving documents. The ideal candidate should be well-versed in: - Microsoft Office (Word, Excel, PowerPoint) - Google Suite (Gmail, Google Docs, Google Sheets) - Calendar and scheduling software (Outlook, Google Calendar) In addition, fluency in German and Spanish, on top of English, would be considered a significant asset. This is a long-term role, with no strict deadline for completion. I value professionalism, discretion, and efficiency in my secretary, and I'm e...
I require the expertise of a seasoned Wordpress web developer and designer with comprehensive experience in ...complete it so I need to outsource the project. The website is a basic travel/retreat website I have already installed and set everything up I just need the winning bidder to create a great redesign of the site using Elementor. The winning bidder must have previous experience with Elementor for Wordpress with previous proof of work/portfolio. Please start your bid with the word rebel so I know you read and understood this. Summary 5 page website redesign of an old website, to be redesigned using Wordpress with Elementor. Theme and everything already setup and design has already been started but needs finishing. Only half the home page has been started so there's s...
I need help transcribing six handwritten pages in Spanish into a Word document. The handwriting is mostly clear, but there are some parts that are hard to read. I'm comfortable with the transcriber using their best judgment to decipher these parts. Additionally, there are no specific formatting requirements. Ideal skills and experience for this project: - Fluent in Spanish - Strong transcription skills, particularly with handwritten text - Attention to detail and ability to make informed decisions in cases of uncertainty.
I am in need of an Excel expert to help in building a comprehensive Excel file. The purpose of this Excel file is to manage different types of data. This data is of intermediate complexity, consisting of multiple data sources and types. Key Tasks: - Data Analysis: I need assistance in analyzing the data that will be managed within the Excel file. - Formulas and Functions: The Excel file will require the use of various formulas and functions to ensure its smooth operation. - Data Visualization: Help is needed in visualizing the data in the Excel file. Skills and Experience: - Extensive experience with Excel, especially in data management. - Proven ability in data analysis, inclu...
I am seeking a proficient Excel programmer who can assist me in automating tasks, creating complex formulas and calculations, and generating reports and trading signals based on S&P500 Index data. The ideal candidate should have: - Proficiency in Excel with a strong track record of automating tasks and creating formulas - Experience in generating reports based on financial data, specifically S&P500 Index - Strong analytical skills to ensure the calculations and data analysis are accurate and reliable - Excellent communication skills to understand my requirements and provide regular updates Some of the key responsibilities and tasks include: - Automating the extraction of S&P500 Index data - Creating formulas and calculations to analyz...
I'm seeking a savvy graphic designer with a firm grasp on creating a compelling logo. The ideal candidate should excel at crafting Corporate and Bold designs. Key requirements: - Develop logo consistent with brand identity - Color scheme: Vibrant Colors - Experience in Corporate and Bold style preferred Your portfolio demonstrating similar work will greatly enhance your application. Be ready to provide a draft and work iteratively. This project will involve a creative, charming and bold design to reflect the character of my brand. Your committed engagement till the end of this project is appreciated.
Enlgish: I have a large quantity of PDFs to process and I am looking for the same specific information each time. I'd like it to input it into Google sheet. I would like to have a program where I can drag and drop the documents, then click on "extract," which allows me to have the information in the correct cells of my Excel or Google Sheet file. ------------------------ French: J'ai Une grande quantité de PDF à traiter et je recherche à chaque fois le même information spécifique Je souhaiterais automatiser le processus
I'm in search of a proficient Excel Macro programmer who can automate data entry tasks with emphasis on numeric data. The ideal candidate would deliver a macro that inputs numbers into Excel and uses "if, then else" logic to perform specific tasks. Essential skills include: - Extensive experience with Excel Macros - Solid understanding of data entry automation - Proficiency in working with numeric data - Good grasp on logical functions especially if, then else Your primary function will involve interpreting requirements and programming the macro to swiftly and accurately complete data entry tasks. Please ensure your portfolio showcases relevant work.
I have included examples of each of the following files I would like to have: - Each US state in a vector EPS file with a cut line. Each as their own file name. - A photo of each with dimensions - A mock up photo of each state decal on the back window - An excel sheet with all the states and associated dimensions Example: North Each state .EPS cut file would need to be within a 3.5" x 5.5" rectangle or a 5.5" x 3.5" rectangle. Whichever best fits the state. I have attached an "Examples" file as well that gives further instruction for setting up the file. There are 50 States. I will need 3 folders: 1- Cut Files (50 .EPS files) 2- Dimension Photos (50 Photos) 3- Mock Up Photos (50 Photos To find all the state outlines, you will need to Googl...
PLEASE READ: I’ve attached a poster I made using Canva. See link I need all the details on the poster. Put the sponsors at the bottom. Their logos are attached. Colours: Shades of cream and gold/brown ———— I'm in need of a creative and engaging poster design for an upcoming wine tasting event. The theme of the event is centered around wine, so I would like the design to reflect that. Key Points: - Primary Concept: Wine Tasting - Main Focus: The toast aspect of the event - Target Audience: Wine Enthusiasts The design should capture the essence of the event and appeal to our target audience, wine enthusiasts. This is a one-off
I have a level sensor which is currently sending data to a local Wi-Fi network, accessible through a web browser using the sensor's IP. I'm seeking assistance to automate this process and have the following requirements: 1. Data Fetching: The sensor is measuring liquid levels. This specific information needs to be fetched and transferred directly to an Excel sheet. 2. Data Update Frequency: The data should refresh in the Excel sheet every minute. 3. End Goal: The collected data will be used to generate a chart in Excel. Ideal skills for this project would include extensive experience with automation, proficiency in Excel, and understanding of level sensor operations. Knowledge of networking would be a plus. Are yo...
I'm seeking a proficient developer to build a user authentication and authorization system using JS, Node.js, and MySQL. The core function of this project will be role-based access control. Key Features: - Role-based access control system: The system should be able to accommodate three different roles - Admin, User, and Guest, each with different permissions. Ideal Skill...sent to the relevant address based on the campaign. • I have a list of ASM email addresses from a Company. I'd like to trigger emails to each of the ASMs on the list. (Campaign wise)" 8. Download Reports: • Include Camp Details Entry Date: This option focuses on the purpose of having the date - to track when the camp details were entered. • To select Date Range • To Select HQ Wise ...
...little hearing loss Key responsibilities will involve: -Building SMARTSHEET plans -- Linking to External data (i.e. Excel) that will be used in updating the SMARTSHEET plans. - Utilizing SMARTSHEET Functions: Proficient use of formulas and calculations is essential for this project. - Building Reports and Dashboards: Experience in creating comprehensive and visually appealing reports and dashboards is necessary. The primary goal for this project is to efficiently and accurately track the progress of different projects within the Smartsheet and create Dashboards for multiple audiences. Ideal candidates should have: - Expertise in Smartsheet - linking Smartsheet plans to external data - Linking Multiple Smartsheet project plans that share tassks - Proficiency in...
I need suggestion on how to present my portfolio of 60+ projects that is done on freelancer.com on my account. I need someone who can SUGGEST and CREATE the portfolio. I CAN PROVIDE KEY DETAILS OF THE PROJECT. This project entails creating the first 10 simple showcase focusing only on showcasing and not big designs. If you have read this much, start your cover letter with "I love working!" Include any little or more experience on such projects. Read again before sending proposal.
*** US CANDIDATES ON...background to manage various tasks. Key Responsibilities: - Budgeting: You'll be responsible for creating and monitoring budgets to ensure financial health. - Expense Tracking: Accurately log and keep track of expenses to maintain a clear financial picture. - Invoicing: Prepare and send invoices to vendors and clients in a timely manner. Your Experience: - Proficiency in Excel: Since I currently handle finance using Excel, it is essential that you are comfortable with this software. - Previous Finance Management: Experience in budgeting, expense tracking, and invoicing is a must. - Strong Communication: Being able to keep me updated and informed on financial matters is key. Please highlight your relevant experience and how you can support me in ...
I have a PDF document that I need retyped into an Excel file. The PDF consists of a total of 10000 pages with data organized in 4 columns. I'm looking for an experienced multiple freelancer who can accurately retype the data from the PDF into an Excel spreadsheet as plain text. Key requirements: - Retyping the content of a large PDF file into Excel - Data organization into 4 columns - Ensuring high accuracy in data entry See the attached file and google sheet link I will give 500 pages first if we meet rate and deadline.
I'm looking for an expert in Excel to build a comprehensive 'Team Scorecard' for my team. This sheet will be used to track a range of tasks and behaviors to ensure the team is performing at their best. Key Features: - The project involves tracking various tasks and behaviors including daily reports, client communication, social media postings, timekeeping, invoicing, and meeting attendance. - I need the sheet to calculate total and average points automatically. This will be based on the tasks completed and the quality of those tasks. - It should also include conditional formatting to highlight outstanding performances. This will help us recognize and reward exceptional work. - Data validation is important to ensure accuracy and consistency in point entries. ...
K zobrazení podrobností se zaregistrujte nebo přihlaste.
I am looking for an experienced Scala developer to implement a specific functionality in a data processing environment. The aim is to process text data more efficiently. Key Requirements: - Deep knowledge of Scala and spark - Proven experience in data processing, notably with excel, json and text data - Ability to deliver clean and efficient code The ideal candidate should be able to show previous projects where they successfully implemented or improved similar functionalities.
...platform to a Shopify store. I have exported the data to an Excel CSV file which includes: - Product names and descriptions - Product images - Product prices - Product options and variants - Product skus Given the format, an Excel specialist with thorough experience in CSV file formatting would be particularly suited to this project. Experience with Shopify's product listing format will also be immensely valuable. The task at hand is to modify the CSV file accordingly so it's compatible with Shopify's import method. - Key Skills: Excel, CSV file formatting, Knowledge of Wix and Shopify's product data structure - Ideal Experience: Previous product data migration between CMS platforms I'm e...