For loop in excel formulaprá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í.
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
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'm looking for a web-based script for managing a domain portfolio. The script should enable me to: - Track domain renewal dates - Add and remove domains in bulk - Move domains between different portfolios - Name portfolios (e.g., Generics, traffic, jamesdomains, etc.) - Import domain name revenue for cost comparison - Add domain name costs per extension (e.g., .com, .net, .xyz, etc.) to monitor yearly costs of each portfolio - Export files per portfolio, as well as a global export - Backup daily and send via email The script should use a simple Username & Password authentication method. The ideal freelancer for this project should have prior experience in domain management and web script development. Knowledge of domain v...
Description: We need a creative, high-quality logo for Vocabble, a vocabulary-building board game for kids (same as Scrabble game - image attached). The logo should reflect the educational and fun nature of the game, appealing to both children and their parents. Requirements: Game Name: The logo must prominently feature Vocabble. Slogan: Include a slogan like below: "Play, Learn, Master English" "Building Brighter Minds!" "Unlock the Power of Words!" "Play, Learn, Excel!" ..... or you can suggest one. Design Style: Clean, modern, and colorful, appealing to families. Avoid overly complex elements. Format: Deliver in vector format (illustrator/corel draw format )and high-resolution PNG/JPEG for print and digit...
I'm in need of a seasoned full stack developer specialized in Laravel and Vue for 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 da...
...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 confi...
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 ...
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
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.
I'm in need of a detail-oriented, experienced professional to 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...
...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. Testing and Approval: A test email must be sent to my email for review and approval before the mass email is sent. Delivery Requirements: Emails must be deli...
I'm looking to create a mobile application and website specifically for my cloud kitchen. The primary purpose of this project is to develop a robust order management system. Key Features: - Real-time order tracking: Customers should be able to see the status of their order in real-time. - Order history: The app should keep track of past orders for customer convenience. - Push notifications for updates: Customers need to be kept in the loop with timely updates on their order status. Platform: - The mobile application should be designed exclusively for Android at this stage. Ideal Skills: - Proficiency in Android app development is crucial. - Experience in building eCommerce or order management systems is a plus. - Skills...
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.
...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 ...
Job Title: Power Query Expert - Tailor-Made PDF Bill Automation & Visualization Project: I need a skilled Power Query specialist to build a customized solution for automating the extraction and 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 Extractio...
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 h...
I'm looking 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 understanding of agri-business and related fields
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 ...
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
We’re looking for a company or an individual who can develop a Saas product for event organisers. It would include a CRM for businesses and a 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. - ...
...skilled Python programmer to help me automate the order placement on Interactive Brokers. Key Requirements: - Automate the placement of Market orders, Limit orders, and Stop orders - Strong proficiency in Python - Experience with Interactive Brokers platform - 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 b...
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.
...to create a custom application for our logistics company. This app 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 an...
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-S...
I'm in need of a skilled Motion Graphics animator for an engaging product promotion reel to be shared on Meta. The animation should compellingly showcase my product and drive viewer interest, ideally leading to potential purchases. Key requirements: - Proficiency in creating Motion Graphics - 3D animate - Experience with product promotion animations - Ability to incorporate specified branding elements It will be for an Australian underwear brand - 10 sec loop I have some elements of my branding that need to be integrated into the animation, so attention to detail and adherence to brand consistency is crucial. Please provide examples of previous similar work you have completed.
I'm looking for a proficient freelancer who can convert a PDF containing text only into a neatly organized Excel file. The main purpose of this conversion is for data manipulation, so the data will need to be structured in a way that facilitates this. Ideal skills for this job include: - Proficiency in Excel - Experience with data manipulation - Attention to detail The data should be organized in a single sheet. Freelancers with experience in similar projects would be preferred.
I need assistance with extracting data from a PDF and placing it into an Excel format I will provide. Key Requirements: - Data extraction from the PDF should be done according to specific column headers in the provided Excel format. - Minor data cleaning is needed during the extraction process. Ideal Skills: - Experience in data scraping. - Proficient in Excel. - Attention to detail for data cleaning.
...consists of a few thousand line items in an Excel spreadsheet. Key Aspects of the Audit: - Return on Investment: Assess the profitability of my trades. - Accuracy of Trades: Determine if there were any errors or discrepancies in trade execution. - Transaction Costs: Evaluate the expenses incurred during trading and their impact on overall performance. Requirements: - The auditor must be an official auditing firm, ideally with relevant past experience. - Preference for firms based in the EU or US. - The auditor must be able to work with a specific report format that I will provide. Ideal Skills and Experience: - Extensive experience in conducting performance audits. - Proficiency in analyzing stock trading data. - Familiarity with audit...
I'm looking for a skilled web developer to create a comprehensive and modern website/database platform for high school football teams, complete with individual player profiles. Key Features: - **Sleek Design**: The landing page should embody a modern and sleek design style. - **Player Profiles**: Develop profiles for individual players that include contact, academic, and athletic information. - **Media Uploads**: Implement functionality to upload unique pictures, videos, and documents for each player. - **User-friendly Filtering**: Enable robust filtering and sorting options for user convenience. - **Data Export**: Provide functionality to export data in CV or Excel format. - **Public and Secured Access**: Create a combinat...
...foundation for our business strategy, focusing on the following categories: Loans Credit Cards Insurance Taxation Stock Market and Trading Investments Wealth Management Since our website and platform are still in development, this project will operate from a blank slate perspective and guide our strategic direction. The emphasis is on industry-wide trends and competitor insights, rather than direct comparisons. Scope of Work The freelancer will: 1. Conduct Market Gap Analysis Identify major consumer pain points across each category. Highlight underserved demographics or regions (e.g., Tier-2 and Tier-3 cities, gig workers, students). Determine areas where existing platforms lack innovation, accessibility, or transparency. Provide actionable insights into potential value...
I'm looking for an expert in Excel or Win Calendar to help me organise multiple spreadsheets into a cohesive and easy to understand monthly calendar. The calendar needs to include: - Meetings and conferences - Promotional campaigns - Events - Program invitations - Media releases - Communication releases (both internal and external) Final deliverable: An Excel file that organizes all these activities by date per month and catergory. This calendar will be shared via Outlook and uploaded to our Teams folder. We have existing mulitple Excel spreadsheets that need to combined in one comprehensice Attention to detail and accuracy is extremely important. Ideal skills and experience for this job: - Proficiency in Excel, incl...
...looking for a freelancer to compile a comprehensive list of restaurants in specified areas that utilize GrubHub and DoorDash for food delivery. Key Requirements: - Gather information about each restaurant, including: - Name - Address - Phone Number - Email Address - Owner's Name (if available) - Delivery Platform - POS System - Whether they offer online ordering with delivery on their own website - The specific areas will be explained in detail with the chosen applicant. - Organize the information in a spreadsheet with separate columns for each piece of information. Ideal candidates should have experience in data collection, familiarity with food delivery platforms is a plus. Attention to detail is crucial as the a...
