Vbscript manipulate excel export 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.
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í.
Mám databázi SQL obsahující objednávky zákazníků u odběratelů obsluhovanou v sw naprogramovaném v C#. SW běží ve Windows 7. Každá objednávka je definována identifikací odběratele, identifikací dodavatele, identifikací produktů, datumem a prostředníkem, přes kterého je objednávka dodána odběrateli. Potřebuju vytvořit reporty o těchto objednávkách ve formě 10-ti grafů a jedné tabulky. Reportům musí předcházet výpočty příslušných hodnot zobrazovaných v grafech přímo v SQL. Pro exporty se jeví jako vhodné namapovat SQL databázi s výpočty na excelový se&...
Dobrý den, máme shop s bateriemi, adaptéry a klávesnicemi. Běží na Prestashopu. Každý produkt v eshopu má několik stovek kompatibilit. Potřebujeme vytvořit XML feed, který bude generovat názvy v kombinaci s každou kompatibilitou. Příklad: NABÍJEČKA NA NOTEBOOK ACER 19V 3.42A (5.5X1.7) Kompatibility v databázi: Acer Aspire 1200, Acer Aspire 1200X, Acer Aspire 1200XV, Acer Aspire 1202, Acer Aspire 1202X, Acer Aspire 1203X, Acer Aspire 1203XC, Acer Aspire 1203XV, Acer Aspire 1360, Acer Aspire 1410 Výsledek v XML exportu: NABÍJEČKA NA NOTEBOOK Acer Aspire 1200 NABÍJEČKA NA NOTEBOOK Acer Aspire 1200X NABÍJEČKA NA NOTEBOOK Acer Aspire 1200XV NABÍJEČKA N...
Ahoj, hledám php programátora na vytvoření php skriptu který se připojí k DB a tam provede jednoduché úpravy které pošlu podrobně popsané (4 kroky). Dělám to nyní manuálně a zabírá to zbytečně moc času, tak to chci zautomatizovat. Skript také stáhne export DB před uděláním úprav. Po provedení úprav se připojí k další DB a udělá zase ty samé úpravy. Jde o opravdu jednoduchý skript. Platba ihned po dokončení a otestování. Skript potřebuji ještě dnes.
Dobrý den, zasílám odkaz na vytvořený projekt dle domluvy https://www.freelancer.com/projects/php/Magento-Ordes-Export/#/proposals
Vytvoření 2 formulářů, k nim databáze, práce s databází, posílání emailů osobám v databází, export databáze, iframe řešení. Popis úkolu je v příloze emilu. Důležité: zasílejte návrh ceny, který bude konečný, nic navíc doplácet nebudu! Cena bude konečná i při doupřesnění některých bodů k rámcovému nástinu toho, co má být výstupem úkolu.
...připravit obchod tak, aby fungoval hlavně e-shop a stránky obsahovaly již data a vše ze starého.. viz: Nově bych ocenila, vytvořit výstup pro Heureku. Cena -do 5.000,-Kč za obchod včetně instalace a zprovoznění šablony. Pzn: Konkrétně v bodech potřebuji: - objednávkový proces vyladěný(lidé si pletou dobírku s osobním odběrem, proto by bylo dobré je mít oddělené) - možnost v hotové objednávce změnit dopravce - objednávka bude mít stejné číslo jako faktura (nyní je to písmenný název) - funkční link google analytics: kod: UA-70139602-1 - funkcni export do Heureky - ...
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
Hledam spolehliveho externiho PHP/nette programátora, jez ma chut vyvijet aplikaci pro sitovou bezpecnost. Co nabizim: -zcela volnou pracovni dobu -jednou tydne se vecer potkame na skype a vyhodnotime/rozdelime si ukoly na dalsi tyden -zasveceni do dalsich technologii: bezpecnost na sitove vrstve, autentifikace Radius server, konfigurace zarizeni pres API/SSH, export/import ucto/banka -dlouhodobou spolupraci na nevsednim projektu. -oceneni dle nasi domluvy.
Dobrý den, chtěl bych vytvořit jednorázový projekt o případné dlouhodobé spolupráci. Jedná se o sowtware poskládán z open sorce , který bude schopen sosat data z webů a to buď na serveru , nebo na vlastním serveru. Preferuji však vlastní server. umožňu v podstatě vše co potřebuji, avšak nelze zadat podmínka u jednotlivých pavouků dle obsahu stránky,tak aby stahoval data pouze některá data. Umožňuje omezovat pouze dle url ale potřeba je dle obsahu. Tedy možnost zadat pokud např id, či div obsahuje nějaké slovo stahni pokud ne - nestahuj. Např.
Dobrý den, chtěl bych vytvořit jednorázový projekt o případné dlouhodobé spolupráci. Jedná se o sowtware poskládán z open sorce , který bude schopen sosat data z webů a to buď na serveru , nebo na vlastním serveru. Preferuji však vlastní server. umožňu v podstatě vše co potřebuji, avšak nelze zadat podmínka u jednotlivých pavouků dle obsahu stránky,tak aby stahoval data pouze některá data. Umožňuje omezovat pouze dle url ale potřeba je dle obsahu. Tedy možnost zadat pokud např id, či div obsahuje nějaké slovo stahni pokud ne - nestahuj. Např.
Hledáme vývojáře pro projekt eshopu s customizerem. Shop bude obsahovat male množství položek (desítky), ale každý produkt bude mít možnost přizpůsobení vzhledu - barva jednotlivých částí produktu, text potisku, font textu, velikost. V tuto chvíli nejde o funkcionalitu klasických eshopů, jako je sledování stavu objednávek, import položek, export xml feedů, fakturace a podobné vlastnosti monolitických CMS . Taktéž zatím není počítáno s backendem. Eshop by měl pouze představit jednotlivé produkty po kategoriích, umožnit jejich přizpůsobení přání zákazníka, vložení vybra...
Dobrý den, hledáme v...kompatibilní s Mac & PC. Již máme hotov design GUI a potřebujeme programátora pro napsání kódu pro deskopový software. Software bude script aplikace s textem, která umožní uživatelům vytvořit textový script pro nahrávání jejich hlasu. To budou moci následně použít při tvorbě videa svého videa, apod. Zde jsou vlastnosti, které by měla aplikace mít: - textový editor - drag and drop rozhraní - export script do Microsoft Word Documents, .PDF and PowerPoint Slides. - Nahrávání hlasu Přikládám link s dalšími informacemi: Software by měl...
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ů.
I am in need of an excellently crafted web form that can ...various services provided by my business. - Calculation logic: Addition is the primary calculation required. The system should be able to add up the costs of selected services. - Data entry: Your form would need to support product selection-based data entries. - User interface: the form should be easy to navigate, with clear instructions for inputting service choices. Ideal Candidate: - Proven experience in designing excel forms with integrated calculation logic. - Ability to design a user friendly interface. - Eye for detail, as the calculator must produce very accurate results. - Strong knowledge of Excel features and data calculation techniques. - Excellent communication skills to understand...
I am looking for an experienced web developer who is proficient in HTML, CSS, JavaScript, and Python to build...Experience in working with APIs, preferably Whatsapp API. - Knowledge of Python-based frameworks like Django, Node.js is a plus. Project Objectives: - Create a web based portal that can monitor conversations from the Whatsapp API. - Implement real-time monitoring of these conversations. - Incorporate search and filter options for easier navigation of these conversations. - Enable export option to collect conversation data. - Optional: intervene on the whatsapp conversation Please ensure your proposal includes previous related work samples, if any, along with your bid. Your understanding of the project requirements and how you plan to achieve them will be crucial t...
I'm seeking a proficient Excel expert who can assist me with enhancing my current study time tracker. I need the following features to be incorporated: - Auto-calculation of total study hours: I'd like for this to be automatically summed up based on the inputs provided. - Auto-calculation of average study hours per day: This should also be done automatically, providing me with a clear view of my daily commitment. - Study hours per subject: I require a part of the spreadsheet to allocate study hours to specific topics that I am learning. The spreadsheet will be utilized for tracking my study progress across different subjects. It should allow for easy input of study hours and materials covered. I will provide the current version of the spreadsheet to the chosen freelan...
...task will be to fix a challenge I'm facing with PHPSpreadsheet. My Excel data is not being imported correctly into MySQL as tables are not being created. Despite no error messages alerting me to these issues, the hiccup persists. Below is a more detailed description. After login, the user uploads 4 required and 2 optional Excel files on the dashboard page. The files are uploaded to an “upload” folder on the server and the file names and other info are stored in the “files” table of the mysql database. All of the above works with no problems. Once the actions above are complete, a button at the bottom of the dashboard page is activated. When the button is pressed, PHPSpreadsheet is used to move the data from the Excel ...
...within this plugin. The main feature of this plugin is Cargo Logistic, focusing on detailed shipment tracking. This feature should provide a comprehensive view of the shipment's journey, including its current location and expected delays & the warehouse rental fees Features: Shipment Management,Shipment Status Update,Shipping Charges,Shipment Tracking Shipment Documents,Shipment Labels,Excel Import and Export,Multiple Shipment Management Users and Permissions,Internal Messaging,Shipment Barcode,Payment Gateways Global Configurations,Shipping Rate,Proof of Delivery,Bulk Scanning,Real Time Notifications Google Map Integration,Manage shipment fields,Branch Manager,Containers and Manifest Shipment Consolidation,Item Consolidation,Parcel Consolidation Whatsapp Notifi...
I have an Excel spreadsheet containing a list of data, from which I need specific email addresses extracted and organized. Key requirements: - Extract email addresses: You'll need to go through the spreadsheet and locate email addresses contained within the data. - Excel Organization: The extracted email addresses should be neatly and accurately organized in the Excel spreadsheet. Each email should be placed in a separate cell. Ideal Skills: - Proficient in Excel: Ability to efficiently navigate and manipulate data in Excel. - Data mining and extraction: Skilled in identifying and extracting specific data from larger datasets. - Attention to detail: Accurate organization of email addresses is crucial. - Tim...
I have a requirement to develop a bespoke Microsoft Excel spreadsheet to calculate sales commissions. Let me share the specifics: - The variables: I want this spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined according to a custom formula that considers the Commission Percentage. - Data input: The spreadsheet should be easy to use, allowing me to manually input the data for calculation. The ideal freelancer for this project would be someone well-acquainted with the mechanics of Microsoft Excel and its formulas. Relevant experience in the field of sales calculations would be an asset. I am trusting that this tool will enhance ...
Hi, I'm looking for someone who can write script to automate daily data importing from csv files into a google sheet. We use a new google sheet each week to calculate production for each day, see example here: We have two online platforms that we receive orders through, one for wholesale customers and another for retail customers. For wholesale we use Ordermentum - www.ordermentum.com. To access the production reports we have to: 1. Open the "orders" page 2. Select the relevant delivery date 3. Export the production report for that date This data needs to populate into the relevant date column of the "ORDERMENTUM" tab in the google sheet. See sample production report attached (produc
I have a substantial Excel spreadsheet that requires competent attention. I'm on the lookout for someone who's proficient in: - Data entry - Data cleaning Your role will primarily involve entering various types of data that's currently on an Excel spreadsheet. Despite the data being available, it's in a raw unclean format that needs some cleaning. The ideal freelancer is someone who's used to working with Excel and recognizing inconsistencies, errors, and redundancies. Additionally, anyone versed in: - Proficient in Excel usage - Strong attention to detail - Experience in data cleaning - Strong data entry skills would be extremely helpful in achieving the goals of this project.
I need a proficient Excel specialist to develop a spreadsheet that will calculate gross pay based on clock in and clock out times. Some work-shifts will start on one calendar day and not clock out until the next calendar day (example- clock in May 1 at 3:30pm - clock out May 2 at 12:30am). It should also factor in specific overtime rules for the workplace, including: - Weekly overtime after 40 hours. -All hours on any given workday shall be paid at the straight time rate of pay unless forty (40) hours have already been worked at straight time. No matter the length of route: example- a driver's bid/scheduled route may be 10.8 hours, as long as the employee does not work any additional hours other than those bid/scheduled, they will be compensated at straight time rate of pay unl...
...specific emotional tone. This could be happy, sad, energetic or any other emotion. - Instruments: I would like to incorporate piano, guitar, and drums in the song. Expand your song project by incorporating techniques from the previous projects: Make a recording and import the audio into Studio One Use editing techniques (splicing, fading, transposing, and reversing audio) and plugin effects to manipulate audio (either the recording you make or audio you find--as in a song or field recording) Develop your structure beyond AABA'. Should you add an intro? What about a more free-form section that comes after the AABA? Or maybe between the B and the last A? It's up to you, but be prepared to explain how you expanded beyond AABA. For those that would prefer to start this ...
I'm in need of a meticulous professional to clean a mixed set of data contained in an Excel file. I am specifically struggling with duplicate values and missing entries. To effectively accomplish this: - You should possess excellent skills in data analysis and data management. - Previous experience with Excel-based data cleaning is preferable. - Profound knowledge of dealing with duplicate entries and filling in missing data is required. - A keen eye for detail and ability to spot and correct errors is essential. In summary, my ideal candidate would be someone with significant experience in data cleaning, particularly with mixed data in Excel files. It would be a bonus if you've previously resolved issues...
...PPC google ads companies The user must trust the design - the content - aif-usa com a couple of links as an example for additional content The theme of the design must correspond to the direction of the company’s activities: The company is globally engaged in transportation and logistics - WAREHOUSING SERVICES - Import Export operations The company is globally engaged in transportation and logistics - WAREHOUSING SERVICES - Import Export operations One of the company’s projects is the resale of electronics purchased at discounts in local USA stores in Asian markets. ADDENDUM: The implementation should allow for easy deployment and relocation to another domain - all settings - company name - telephone numbers - team - must be configured from the settings ...
I'm looking for a skilled data analyst to help me with a comprehensive statistical analysis of a survey I conducted with roughly 100 participants. Key Requirements: - Proficiency in Descriptive, Inferential, and Correlation data analysis techniques - Experience in interpreting survey data to identify trends and patterns - Ability to test hypotheses and make inferences - Knowledge of how to determine relationships between variables - Excellent skills in Excel and/or other statistical software or python for data manipulation and analysis Ideal Candidates: - A data analyst with a proven track record of handling survey data - Someone who can derive meaningful insights from the data - Excellent communication skills to explain the ...
I am in need of a detail-oriented individual to help with a data entry project. This involves manually entering alphabets into an Excel spreadsheet to create a comprehensive database. For this task, you should have: - Excellent attention to detail, as the entered alphabets should be strictly in lowercase. - Proficiency in Excel, as the data will be used to compile an Excel spreadsheet database. - Ability to work diligently on a potentially repetitive task. Your primary responsibility will be to manually input the alphabets into the spreadsheet with absolute accuracy. As it's vital that each data entry is correct, having strong attention to detail is paramount for this job. Experience in data entry and Excel is a must.
I have an Excel file that is corrupted and won't open. The latest version has over 5000 columns which I need retrieved. I have a previous version of the Excel file with over 4500 columns. The Excel file was last saved on a USB and I am using Excel 2016. I do have a backup copy of the corrupted file. Key Tasks: - Recover the latest version of the Excel file with over 5000 columns. - Integrate the data from the previous version (4500 columns) into the latest version. - Ensure all data is intact and functional. Skills and Experience: - Expertise in data recovery and Excel. - Proficiency in Excel 2016. - Attention to detail and thoroughness to ensure that all 5000+ columns of data are successfully retrieved and...
...knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and a strong under...
I'm in need of an Excel expert who can help me compile a detailed file for the merger of PVR and INOX. The document should contain two main sections: - Financial Data: - I require you to list the revenue, expenses, and profit/loss figures. These should be clearly presented in a way that allows easy comparison. - Merger Details: - You will also need to include specific merger details. This includes the merger date, the terms of the merger, and the name of the merged company. The ideal candidate for this project is an experienced Excel user, with a proven track record in data analysis and a keen eye for detail. You should be comfortable working with financial data and able to present complex information in a clear and insightful manner. ...
I am seeking a skilled freelancer who has significant experience in building WordPress landing pages. The purpose of this landing page and its specific features are left open for creative interpretation, as I have not specified any particular elements, color schemes, or branding guidelines. None...essential in order to create a high-quality page. Ideal skills and experience: - Expertise in WordPress - Exceptional creativity and ability to work within broad parameters - Understanding of best practices for landing page design - Willingness to provide design recommendations and insight based on previous success in similar projects. This project offers an excellent opportunity for those who excel at employing their creative judgment and WordPress capabilities. I will need a...
In this project, I need a competent photo editor to make a couple of specific changes to an image. The edits needed are: - Removal of 'Person C' from the photograph. The person sitting - Adjustment of 'Person B's' orientation in the photograph to face the opposite direction. To face th...couple of specific changes to an image. The edits needed are: - Removal of 'Person C' from the photograph. The person sitting - Adjustment of 'Person B's' orientation in the photograph to face the opposite direction. To face the man The ideal freelancer for this job should possess strong skills in photo manipulation, and have prior experience in using editing tools effectively to remove and manipulate subjects within photos. High attention to deta...
I am interested in creating an Excel VBA macro that will allow me to import PDF invoices into line items and parse them. The objective of this project is to streamline the process of invoice data entry by automating the extraction of key information from incoming PDF invoices, namely Invoice number, Vendor name, Pricelist, and Detail. The successful freelancer for this project should have: - Demonstrated experience in creating VBA macros for Excel - A strong understanding of PDF parsing and data importation - Knowledge of accounting principles is a plus The imported data should ideally be formatted in Excel as: - Each PDF invoice should be translated into a single row - The extracted information should be available in separate columns for each pi...
I'm in need of an experienced data entry specialist who is proficient with Excel and has a good attention to detail. The project is small scale, requiring less than 100 entries of numeric and text data to be input accurately. Requirements: - Skilled in data entry - Experience with Excel - Attention to detail - Efficient work pace The ideal candidate would have ample time to complete the project quickly. Make sure the entered data has to have no errors and is accurate since the output will be used for further analysis. Final format: Data should be delivered in an organized Excel spreadsheet.
I am launching a marketing campaign intended to increase brand awareness and am seeking a skilled professional who could create a diamond out of Feta cheese. The final output should be: - The same size as a standard engagement ring diamond. - Potentially a di...resemble block of feta) - Have an unconventional and abstract aesthetic. Your creative input will be highly valued, although the design should adhere to the specifications mentioned above. Prior experience in food carving or sculpture will be advantageous. The Freelancer should have a good understanding of different textures and properties of cheese, specifically Feta, and should know how to manipulate it effectively to create the required design. Creativity, attention to detail, and a passion for novelty are assets for thi...
I am looking for an expert to automate my daily incremental SQL scripting to extract multiple tables from my ERP system, and export them to CSV files. Key Requirements: - The system in question is Progress/OpenEdge. - The extraction should include tables such as Customers, Orders, Products, General Ledger detail, Job Costs, Invoicing, and Budgets. - The script should be set to run on a daily basis. I need a freelancer who: - Has a strong grasp of Progress/OpenEdge. - Has experience with automated SQL scripting. - Can efficiently export data to CSV files.
PLEASE DON'T BID IF YOU CANNOT WRITE EXCEL MACRO TO SCRAPE THE DATA. PYTHON SCRAPPER DON'T NEED I'm in need of a VBA developer who can help in creating a small code for scraping contact details from a specific website. The task involves creating a button in an Excel file that triggers the scraping process and saves the extracted data back into the same Excel file. Note : Project budget is only 6k because it will take max 2-3 hour for experience developer Key Requirements: - Scrape contact details from - Specifically, scrape Owner Name & Address - Implement a function where a user clicking a button triggers the scraping process - Save the extracted data back into the same Excel file Ideal Skills & Experience: - P...
I need help with my accounting and auditing tasks, including bookkeeping, financial statements preparation, and internal control evaluation. I'd like to include 1 year of financial data in the statements. I require a professional with the following skills: - Proficiency in QuickBooks, Xero, and Excel spreadsheets - Experience in bookkeeping - Preparing financial statements - Evaluating internal controls Your role will be crucial in ensuring that my financial records are accurate and compliant with accounting standards.
We need a list of all stores in US & Canada that fall under any of the following categories/keywords: Watch Store Watch Repair Shop Jewelry Store Jewelry Repair Shop Fashion Boutique Outdoor Goods Store Sporting Goods Store Electronics Store Mobile Phone Repair Shop You will have to scrape these websites: Yelp, Yellow Pages, Google Maps I have provided an Excel template to follow.
