Vba grabs data excel filepráce
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.
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í.
Disassemble Freescale MPC5674F hex file to assembler. IDA PRO, winhex is a must!
I AM LOOKING FOR A CAD DESIGNER TO CREATE A LIGHT WEIGHT YET TRENDY PROTECTIVE CASE THAT SLIPS RIGHT OVER THE LATEST IPAD PRO. HERE IS A LINK FOR THE SPECIFICATIONS FOR THE IPAD PRO. PLEASE REFER TO SIZE AND WEIGHT SPECIFICATIONS FOR DESIGNING GUIDELINES. FORMATTING FOR THE CAD FILE MUST BE IN .STEP, .STP, .STL, .OBJ
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
...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...
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ů.
...creating a custom web application with a primary focus on data analytics and reporting. Key Responsibilities: - Develop a robust custom web application - Implement user management features - Integrate data analytics and reporting functionalities - Ensure seamless integration with various data sources Ideal Skills: - Proficiency in Laravel and Vue - Extensive experience in REST API development - Strong background in data analytics and reporting - Skilled in working with databases (e.g., MySQL, MongoDB) and APIs (e.g., REST, GraphQL) The project will involve integrating with multiple data sources, including databases and APIs. Experience with external data sources such as CSV and Excel will also be beneficial. Your ability to handle com...
...transform multiple Excel sheets into an interactive Power Apps platform for various users. The project also includes the creation of a comprehensive dashboard. Key Requirements: - Transforming Excel sheets into a user-friendly Power Apps - Developing a dashboard tracking performance metrics, operational statistics, and assisting with actions and decisions Dashboard Visualizations: - Bar charts and line graphs - Pie charts and donut charts - Tables and matrices - Conditional formatted tables Additional Considerations: - Power App must support multiple clients in an Active Directory format Ideal Skills and Experience: - Proficiency in Power BI and Power Apps - Experience in creating interactive dashboards - Knowledge of Active Directory configurations - Ability to visua...
Good day, I have a MS word file that needs to be converted into Fillable/ Interactive PDF with all fields accurately. Need the task done within 12 hours or less. Please bid only if you can start working now. ideal Skills: - Proficiency in Adobe Acrobat and form creation I have attached a copy of the forms to be worked on. Please start your answer with "Pdf Filler Expert" Please refrain from including any special features such as digital signatures, calculations, or security options, as these are not needed for this project.
I'm in need of a skilled circuit board designer to create Gerber files for a single-sided circuit board. This board is meant for a hobbyist-level rpi project, so the design should be user-friendly and suitable for the DIY community. Key Responsibilities: - Design a single-sided circuit board capable of accommodating connectors. - Create detailed and accurate Gerber files for PCB manufacturing. - Ensure the design is robust yet simple enough for hobbyist use. Ideal Skills and Experience: - Proficiency in PCB design software (e.g., Altium Designer, Eagle, KiCad). - Previous experience designing single-sided circuit boards. - Familiarity with designing for hobbyist electronics projects. - Ability to design for and integrate LEDs and connectors. - Experience creating Gerber files for PC...
I'm in need of a Python script that can extract numerical data from an Excel/CSV file. The ideal freelancer for this project should: - Have extensive experience with Python, particularly in data extraction. - Be proficient with handling Excel and CSV files. - Be able to write clean, efficient code. Please note, the data will be purely numerical. The script will need to be able to handle large datasets with ease.
Objetivo del Proyecto Desarrollar una solución automatizada en Python que procese archivos Excel mensuales con múltiples tablas no estructuradas, extrayendo y organizando la información en un formato estructurado y agregando control temporal a los datos. Alcance del Proyecto Desarrollo completo del script en Python usando Jupyter Notebook Documentación del código Manual de usuario para la ejecución del script Requisitos Técnicos Tecnologías Requeridas Python 3.8+ Pandas Openpyxl/XlsxWriter Jupyter Notebook Funcionalidades Principales Procesamiento de Archivos Lectura de archivos Excel (.xlsx) Capacidad de procesar múltiples hojas Manejo de archivos de gran tamaño Control de errores y validaciones ...
Ciao devo avere un file in vettoriale che devo inviare all' azienda che mi fornirà l' insegna per il mio negozio , che sarà di 2 metri per 45 cm di altezza. Deve contenere sia il mio logo Noleggiamola che il logo del mio socio che è Moving che allego a questa richiesta, uniti solo da un & carina ed elegante.
Build quote template as below - 1. Polish quote template 2. Macro to create new tab 3. Macro to add new slot in existing quote 4. PDF generation with Inclusion and Exclusion List 5. Push quote info to CRM (if API exists)
I need to create 1 or 2 shortcut keys with macros in Excel for automating the formatting and reporting of my data. Ideal skills for this job: - Proficiency in Excel - Experience in creating and implementing macros - Ability to automate tasks efficiently
...this project: Graphic design expertise, with a strong understanding of color theory and composition Ability to create eye-catching and visually appealing designs Experience in creating thumbnails for YouTube or other social media platforms Understanding of the real estate and business industry to accurately represent the podcast theme The ideal candidate should be able to create a thumbnail that grabs attention, communicates the podcast's theme, and entices viewers to click and listen. The name of the podcast is "The Radiant Channel" You CAN use the podcast name in the design but it is not REQUIRED Here is a URL to the host Sean Son facebook for a picture of them: You can use a picture from social media or from the video podcast itself Here is a URL
Hi, we need the attached PDF document to be translated from Italian to German, destination: Switzerland. We don't have the OCR for this, but I send you both the Word editable document of the first part, and the Excel that contains the following part (table). Please, use the Word and the Excel documents to create one only final document, like the PDF. I kindly ask you to add [unleserliche Unterschrift] wherever a signature appears. We don't have any specific deadline for that.
...assist with various bookkeeping tasks. Key Responsibilities: - Recording transactions: Timely and accurately inputting all financial data - Reconciling accounts: Ensuring all accounts are balanced and discrepancies are addressed - Generating financial reports: Preparing clear and concise financial statements - Budgeting: Assisting in the preparation of budgets - Auditing: Conducting internal audits to ensure financial accuracy - Forecasting: Providing financial forecasts to aid in strategic planning - Invoicing: Preparing and sending out invoices - Project bookkeeping: Keeping track of finances for specific projects - Must know QuickBooks, NetSuite and Excel Ideal Candidates Should Have: - Extensive experience in bookkeeping - Proficiency in using accounting software - ...
Email Marketing Project Details Objective: Send two email campaigns to 5,000 current sports bettors with accounts who have not yet made a deposit. Project Overview: Target Audience: 5,000 recipients. Data provided in Excel format (includes recipient email addresses and other necessary details). Email Content: Email 1: Includes a dynamic, clickable banner and text for sports bettors. (both provided by me. Naturally I want your input). Email 2: Sent three days after the first email, includes new text aimed at casino and slots players (provided by me). Sending Details: Emails should be sent from a professional-looking sender name such as: "Mike Spencer – Your V.I.P. Host". The sender email address must be configured to forward any replies directly to my email. T...
I need an existing Excel spreadsheet, which tracks employee data, to be transformed into a secure, user-friendly system. Key Requirements: - The system should provide view-only access to certain users, while others can edit designated sections. - It should automate calculations and formulas, as well as validate data entries to ensure accuracy. Ideal Skills: - Proficient in Excel with experience in spreadsheet security and access control. - Capable of creating automated systems within Excel. - Previous experience with HR-related spreadsheets is a plus.
I need a professional to help me sharpen the icon/graphic of my logo and convert it into the necessary AI (Adobe Illustrator) vector files. Key Requirements: - Expertise in logo design and vectorization - Proficiency in Adobe Illustrator - Ability to understand and interpret verbal descriptions of design requirements - Experience creating logos and graphic elements from scratch would be beneficial I can provide a detailed description of the sharpness I am looking for, but I do not have specific reference examples. I'm open to suggestions and appreciate the expertise of the freelancer to help enhance my logo.
...un portal de empleo leader pero queremos procesar los datos de esos candidatos desde diferentes pragramas de mailing para lo cual necesitamos extraer algunos campos básicos de esa web a la que nos tenemos que logear, ir a la oferta en concreta, al listado de candidatos y de ahi extraer esos datos básicos del candidato (por ejemplo nombre, email, teléfono, experiencia, etc) y pasarlos todos a un excel. Actualmente lo estoy intentando hacer yo a través primero de Selenium y ahora con ParseHub, pero no soy experto en esas herramientas y me da siempre problemas ademas que el portal de empleo tiene sus controles para evitar este tipo de acciones e imagino que hay que tener los trucos o el conocimiento determinados para solventas estas cuestiones como los ca...
In my company the arrival of the inventory to the warehouse is recorded manually in the attached excel file, in the tab "ARRIVO PRODOTTI". Each product is assigned a specific row. For each row the following columns are filled in: ARTICOLO (item code) DESCRIZIONE (item description) DATA PREVISTA (estimated availability date) I° REVISIONE DATA (first revised availability date) II° REVISIONE DATA (second revised availability date) III° REVISIONE DATA (third revised availability date) QTY (quantity) STATO (status) I would need a button for each row, next to the column STATO. The button, powered by a macro, when pushed should trigger an email to be sent to a list of internal recipients, with subject and text filled in with ...
...organization of electricity and water bill data (PDF format) into a specific Excel structure. We will provide sample bills AND a detailed mockup of the desired final output format. This ensures your solution directly addresses our exact needs. Data Points (extracted from PDFs): Company Name Flat/Shop Number Account Number Disconnection Notices (flag/status) Electricity, Water Consumption Municipality Period Start Date, End Date Previous Balance, Total Amount Due Key Requirements & Deliverables: Automated Extraction & Formatting: Develop a Power Query workflow to: Pull data points reliably from PDFs according to the provided format guide . Structure the extracted data...
I'm looking for a WordPress professional to assist with the installation and configuration of SEO and OTP plugins on my site. 1. I want to add data by one person or by team or upload contacts in bulk, I want to have the facility to get contacts approval? When a new listing is added in my website a. From link posting advertisement- , the advertiser should get whats app or mail or SMS for confirming or declining the advertisement. or b. Upload bulk listings available in excel file containing listings data from admin panel using plugin wpallimport plugin, all numbers should get whats app or mail or SMS for confirming or declining the advertisement. 2. Need to disable the mail id as mandatory field and would like to have
I'm looking for an expert who can gather 5000 verified email IDs of researchers in the fields of agri-business, food, and retai...for an expert who can gather 5000 verified email IDs of researchers in the fields of agri-business, food, and retail from global sources, particularly focusing on academic journals, google scholar, and university directories. The email list should be delivered in an Excel spreadsheet. Key Requirements: - Expertise in data collection and verification - Familiarity with academic journals and university directories - Proficiency in creating and delivering data in Excel Ideal Skills and Experience: - Previous experience in similar data collection projects - Strong attention to detail for email verification - Excellent unders...
I'm in need of professional Excel templates tailored for the construction industry. These will be specifically for quotations and invoices. Key Requirements: - The templates must include: - Client details and project scope - A breakdown of material and labor costs - Payment terms and due dates - The templates should be visually appealing and aligned with our brand: - Incorporating our company logo and branding colors - Special layout and design elements Ideal Skills and Experience: - Proficient in Microsoft Excel with a strong understanding of template design - Previous experience in the construction industry is a plus - Graphic design skills to ensure a professional and appealing layout - Attention to detail to ensure all necessary information is included
Excel Spreadsheet & Invoice Creation Assistance Excel Spreadsheet & Invoice Creation Assistance
I need someone to convert my 28 page bank statement from PDF to Excel. - You will need to extract all details from the bank statement. - The data should be formatted into a standard table format on Excel. - No further data processing is required after extraction. Ideal candidates will have: - Experience in data entry and PDF to Excel conversion - Attention to detail to ensure all information is accurately captured. check sample
I need assistance with managing hospital paperwork and invoicing using Microsoft Excel. Requirements: - Managing patient records and billing/invoices in Excel - Utilizing an existing template for patient records - Following a specific format for billing and invoices Ideal Skills: - Proficient in Microsoft Excel - Detail-oriented with ability to follow specific formats and templates - Experience with hospital paperwork and invoicing preferred.
Want to recreate this spreadsheet to add another section, a sixth one called Operations Also want to add our company logo
I need assistance with selecting files on my Windows PC for OneDrive. The files will primarily consist of both documents and photos/videos. The main purpose for syncing these files is to access them from multiple devices. Ideal skills and experience for the job include: - Proficient in Windows OS - Experience with OneDrive - Good understanding of file organization - Knowledge of syncing processes
...customer portal. It will have 30 pages with different functions and all pages should be responsive. Pages will include but won’t be limited to: Business portal/CRM - Registration. - Settings (with business info.) - Login. - Events (where businesses can see all there events) - Create an event. - Edit event. - Create a menu. - Event summary and food order. - Individual food order. - Exports to excel - Food orders(sorted by course and table). - seating management Customer portal - Register. - Login. - Register and create an event. - Login and create an event. - Customer profile page. - Future events. - Past events. - Event details - Info page. - Event details - Food orders. - Guest food order - single page. - Food menu. - Guest list. - Add an admin. - seating manage...
...- Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont waste your time and bid If you h...
I need a macro or script for my Google Sheets and Excel to automate data entry. Specifically, I want it to automatically pull bold information from a specified source into designated columns, as demonstrated in a provided video. Ideal Skills: - Proficient in creating macros in Excel and scripts in Google Sheets. - Strong understanding of data entry processes. - Able to follow visual instructions precisely. Please note, the exact source of the bold information will be provided in the video.
Hello, I am seeking a skilled freelancer to assist with the repair and import of a corrupted SQL Server file. Here's the situation: I accidentally deleted both the MDF and BAK files from our disk, and unfortunately, the file structure cannot be recreated. Using a hexadecimal editor, I managed to locate four MDF files, but I am uncertain which one contains the correct data. After some repairs, I believe one file might have the data I need. My primary interest is in recovering data from a specific period, which I couldn't retrieve using automated repair methods. Due to the size of the file, I require you to work directly on our system remotely.
...will automate the process of downloading quotations from shipping lines and airlines, displaying the data in a user-friendly format, and allowing for edits to create customer quotations. Key features of the web app include: - Advanced data processing: The app needs to handle complex tasks such as data extraction, transformation, formatting, and validation. - Manual upload function: This should allow users to upload rate templates from shipping lines via Excel or CSV files. - Format standardization: The app should assist in converting inconsistent rate formats from different shipping lines into a specific Excel template before upload. - Compatibility: The app needs to process and convert Excel, CSV, and PDF files. User roles: - The app will ha...
I'm looking for a data analyst who can help me assess the performance of various projects based on Excel spreadsheet data. Your primary focus will be determining actual run rates, based on project entries and forecast dates, as well as identifying whether projects are ahead or behind schedule. Additionally, I would like you to provide both a written report and visual aids (charts and graphs) as part of your deliverables. Ideally, you should have a strong background in data analysis and visualization, with a good understanding of Excel. Experience with project performance analysis would be a plus. Please note that there are no set rules for this analysis; it is simply a test to assess your ability to perform basic data analysis.
I'm looking for a freelancer to source and add leads to an excel sheet based on specific criteria. Key Responsibilities: - Use LinkedIn to source leads based on current Job Title and Company Name - Include Name, Job Title, Company Name, and Email in the Excel sheet - Ensure that the leads apply to the industry and job function Ideal Skills and Experience: - Proficient in using LinkedIn/ search for lead generation - Detail-oriented with strong data entry skills - Familiarity with different levels of job titles within companies - Excellent communication and organizational skills - Proven experience in lead sourcing would be a plus The leads should involve the highest-level manager for that particular company within Drug Supply-Sourcing. The job titles and company...
