Vba excel word macroprá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í.
Customizing the spellchecker I will add dictionaries and rules for hunspell. Interlingo language see: Required skills: MS Visual Studio, C #, MS Office, Git
Přizpůsobení spellcheckeru Slovníky a pravidla pro hunspell dodám. Jazyk interlingva viz: žádané dovednosti: MS Visual Studio, C#, MS Office, Git
Pro účel vyúčtování potřebuje naše firma macro, které bude kontrolovat platby a jejich zdroje. Macro by také mělo identifikovat transakce, které buď nejsou spojené s žádným prodejem, nebo jsou nějakým jiným způsobem problematické. V příloze je vzor zdrojových souborů: report z našeho systému, výpis transakcí z paypalu, výpis transakcí z bankovního účtu. V případě zájmu/ dotazů mne neváhejte kontaktovat. Strobl
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...
Překlad do SK. Manuál k produktu, zdroj CZ (+ EN) ~520 slov. Word soubor. Obrázky zachovat původní, technická slovíčka v uvozovkách zachovat Anglicky.
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ů.
...practical lab exercises and troubleshooting scenarios. 3. Ensuring the materials are designed for a blended learning approach (theory + hands-on). 4. Providing step-by-step instructions for configuration, programming, and troubleshooting. 5. Aligning the content with industry best practices and real-world applications. 6. Delivering all materials in an editable digital format (e.g., Microsoft Word, PowerPoint, and PDF). **Deliverables** 1. Complete training manual (theory and labs). 2. Practical exercises for each day of training. 3. Answer keys and solutions for lab exercises. 4. PowerPoint presentations summarizing the content for each day. 5. Any supporting files (e.g., RSLogix or FactoryTalk project files). **Freelancer Requirements** Applicants shou...
I am in need of a freelancer that can assist me with copying data from a protected Excel worksheet to a new, unprotected spreadsheet. Details: - I do not have the password to the protected worksheet - I can edit the worksheet, but cannot remove the protection - I need all data transferred from the protected worksheet to the new spreadsheet Ideal skills for this job would include proficiency in Excel, data entry, and an understanding of data confidentiality. As I cannot remove the protection, the freelancer will need to handle this task with discretion and professionalism.
I have a startup business plan that needs professional formatting in Word. All sections of the plan - from the Executive Summary to the Financial Projections - require attention. Key Requirements: - Experienced business administrator with a strong background in business plan formatting - Proficient in Microsoft Word - Able to adhere to provided template and style guide Please note, I will provide the template and style guide. Your job will be to ensure that the business plan is formatted correctly and professionally.
...me identify trends in our QI project data. This will involve working with an Excel spreadsheet sourced from Redcap data. It is a NICU breast milk QI project. Data collection includes: Mother's age, mother's race, infant gestational age, insurance type, Breast pump useMilk volume at 3 different time points, volume goal of 500ml/day, Lactation clinic appointment. Scatter plot, run plot, effects of intervention: Yes/no lactation appointment attended, and does this correlate with milk volume. Key Responsibilities: - Analyze data to identify trends related to process improvements - Present findings in an accessible and clear manner Ideal Skills and Experience: - Proficiency in data analysis, particularly with Excel - Experience with QI projects - Ability to presen...
...ensure deadlines are met. 5. Sugarcrete Initiative: Research and compile a list of bagasse suppliers in Belize for future brick manufacturing. Track costs related to Sugarcrete separately from gym expenses. Ideal Skills & Experience: Strong project management and organization skills. Experience with branding, marketing, and social media management. Proficient in financial tracking tools like Excel or Google Sheets. Familiarity with website development, online payment systems, and POS systems. Great communicator and skilled at keeping others on task. Resourceful with research and able to present clear recommendations. Scope & Budget: Scope: Ongoing, with a focus on the gym setup and other key projects in the first few months. Estimated Hours: 15–20 hours per week...
Freelance Opportunity: AP Script Expert for Excel Sheet Automation We are looking for a skilled AP Script Expert to help automate processes in Excel sheets for our business. The ideal candidate should have expertise in creating, editing, and debugging Google Apps Scripts to streamline data handling, calculations, and report generation. Requirements: Proven experience with Google Apps Script for Excel/Google Sheets automation. Ability to create custom scripts to automate repetitive tasks, manage data, and enhance productivity. Knowledge of integrating third-party APIs (if needed) with Google Sheets. Strong problem-solving and debugging skills. Effective communication and ability to meet deadlines. Scope of Work: Analyze the current Excel workflow and id...
...Status Updates: Requests should have statuses: Pending Under Process (after Engineering Manager approval) Completed Status changes should trigger notifications. Dashboards & Reporting: Basic dashboard with the following insights: Request counts (by status, department, and priority) Average lead time (from submission to completion) Filter requests by department, category, status. Export reports to Excel/PDF. Access Control: Only authorized roles can approve/reject requests. Unauthorized users should see appropriate error messages. Custom request forms based on department/role. Technology Preferences: Web-based (accessible via PC & mobile). Simple UI with minimal complexity. Hosted online for real-time access. Suggested stack: Node.js (), MongoDB (or simple JSON storage...
I have a project which involves processing a spreadsheet of 4100 EANs. The primary task will be identifying the SKU and size from the data. The EANs are currently stored in an Excel (.xlsx) spreadsheet. - Skills Requirement: Proficiency in Excel and data mining is essential. Experience with SKU and size identification will be a significant advantage. - Task: Extract SKU and size information from the provided EANs data. Please note, the specific SKU and size information that needs to be extracted has not yet been defined. A flexible approach and readiness to adapt to evolving project requirements will be key.
I need assistance with an Excel file. The city name is currently located in the middle columns and needs to be moved to a different column. All of the data is in one sheet. The ideal freelancer for this project should have: - Proficient Excel skills - Attention to detail - Data management experience
I'm looking for an Excel expert to help with my homework focused on analyzing scientific data. The main goal is to conduct a thorough data analysis using various statistical techniques. Key Responsibilities: - Analyze provided scientific data using Excel - Apply various statistical analysis techniques Ideal Skills: - Proficient in Excel with strong data analysis skills - Experienced in conducting statistical analysis - Familiar with scientific data sets
...Operational analysis Which areas of operations do you want to focus on? - Balanced scorecard (BSC) of the given company based on template -> Which perspectives do you want to include in the balanced scorecard? - Financial, Customer, Internal processes, Learning and development perspective Extended description of the task: Describe the vision, mission, goals and strategies of in Excel 1. Describe the financial perspective of the company selected in point 1), taking into account the following indicators: profitability (2-3 indicators, e.g. ROA, ROE), debt (1-2 indicators, e.g. total debt ratio), liquidity (1-2 indicators, e.g. current liquidity), cash conversion period (1 indicator) and risk management (1-2 indicators). 2. Describe the perspective of the customer selecte...
I'm looking for an expert Java developer who can assist me with a project focused on creating a specific web application. This involves using Visual Studio Code (VSC) and developing weekly content to complete the assignment. Key Res...implementing user authentication and database interaction features. - Excellent content creation skills. - I have attached the assignment details (its in 3 parts), sot the students should be able to provide 3 submission. - I have attached the weekly contents in excel sheet. I will need you to be good in creating weekly contnets meeting the topic lsited in the excel sheet but at the same time implementing the skills and knowledge toward completing the assignment. Please only contanct me once you go through the assignment and the excel...
I'm in need of a proficient VBA CorelDRAW programmer for the 2024 version. My project involves creating a VBA script that generates QR codes within a specific template of a certain size. The script should also arrange these QR codes for printing on various printer sizes, specifically a custom size of 48x96 inches. Ideal candidate should be skilled in: - CorelDRAW and VBA - Understanding of QR code generation - Experience with custom printer size arrangements - Ability to work with specific size templates (small, medium, large)
I need a professional who can help me extract data...POS system on a daily basis. This data extraction will specifically focus on orders, with an emphasis on breaking out taxes and fees separately instead of having them lumped together as 'fees'. Key Requirements: - Data needs to be extracted daily and made available for download from a secure server. - The extracted data must be formatted in Excel. Ideal Skills and Experience: - Proficiency in data extraction from Clover POS system. - Expertise in Excel for data formatting. - Experience with secure server data handling. - Ability to meet daily deadlines. Please note, the goal is to have a detailed, clear and precise breakdown of each order, with taxes and fees itemized separately. This is essential for my accoun...
I need an Excel sheet specifically designed for conducting profit and loss analyses. The primary function of this sheet will be to facilitate financial calculations. Key Requirements: - Creation of an Excel sheet tailored for profit and loss analysis - Integration of functionalities for various financial calculations Data Entry: - All data will be entered manually, so the design should be user-friendly and intuitive for manual data input. Ideal Skills: - Proficiency in Excel - Experience in financial analysis - Ability to create user-friendly spreadsheets
I'm looking for a professional, engaging, and informative PowerPoint presentation on Saudi Arabian culture, targeted for a new American manager. The focus should primarily be on business interactions, but also touching on macro overview, religious customs, social norms, and other crucial aspects. The presentation should: - Be designed to fit within a 1 hour timeframe. - Incorporate infographics to make it visually appealing. - Include a selection of helpful videos at the end, providing further context and insight. I have provided some links to videos that can serve as a baseline for the content: - - - Ideal candidates for this project should have: - A deep understanding
...contracting business. The ideal candidate will have experience in the construction and real estate industry and be proficient in using Excel for financial modeling, reporting, and analysis. Key Responsibilities: Prepare and maintain annual budgets, revenue forecasts, and expense tracking using Excel. Analyze cash flow and ensure liquidity to meet operational needs. Assist in financial decision-making by providing insights and recommendations. Monitor project budgets and ensure financial alignment with company goals. Develop financial models to forecast project costs and returns. I am looking for an experienced financial analyst who can help prepare a comprehensive Excel workbook that includes all necessary formulas for financial analysis across various aspects of...
I'm looking for a professional teste...my website before we go live. The testing should cover both the front-end and back-end, with all glitches and errors documented in an Excel sheet, categorized, and using Scrum methodology. Front-End Testing: - Usability testing: Assess the user experience and interface design. - Performance testing: Measure the responsiveness and stability. - Cross-browser testing: Ensure consistent functionality across multiple browsers, specifically Chrome, Firefox, and Safari. Back-End Testing: - Security testing: Identify any potential vulnerabilities. Ideal candidates for this project should have extensive experience in website testing, and be proficient in using Excel for documentation and Scrum for project management. Experience with secur...
I'm looking for a skilled motion graphics artist to animate a word for me. There are two elements in the word, the airplane and the cocktail glass. We'd like some type of quick animation. Maybe the plane flying into place and the glass filling up, lime spinning. We don't have any set ideas. Any animation welcomed. Not long, it should be quick. Word itself can be animated also.
I'm looking for a meticulous data entry professional to transcribe my handwritten notes into a Word document. Key Requirements: - Exceptional attention to detail to ensure accuracy in transcribing - Proficiency in Microsoft Word - Ability to handle and interpret handwritten texts - Prior experience in data entry preferred Please reach out if you can help with this project. Thank you!
I need assistance with finding product codes (SKU and size in either US or EUR and link for a proof) for 4100 EANs. The data should be sourced from Google or VERY easy because 2 /3 brands only Key Requirements: - Data processing and research skills - Experience with Excel/CSV - Ability to follow a specific format for data input I will provide the EANs in a spreadsheet (Excel/CSV) and I already have a format for the SKU and size. This is a straightforward project that requires basic data input and online research. Please be prepared to work meticulously and efficiently.
Are you an experienced graphic designer with a proven track record in creating outstanding Amazon content? We are looking for top-tier professionals who excel in designing as well as creating captivating product images and brand content, including A+ Content and Brand Stores. We are particularly interested in working with forward-thinking designers who use AI tools for bulk image generation like Midjourney, Dezgo, Adobe Firefly, and equivalents to create compelling, emotion-driven product visuals —without the need for complex photoshoots. Bonus points if you also have expertise in digitally creating product videos to enhance listings further. What we’re looking for: - Extensive experience in designing Amazon-specific content. - A deep understanding of Amazon’s ec...
I need an expert in Excel 365 who can link two sheets for me. The first sheet should update the second in real-time. - Data Type: The data to be linked is mixed, consisting of both text and numerical data. - Version: The linking has to be done in Excel 365. Please only reach out if you're proficient in Excel and can ensure real-time data linking. Thank you.
I need a skilled Excel professional to clean up the formatting in my Excel document so that "amount" and "total" columns are formatted consistently (centered or justified to right) and ensure that existing formulas in "amount" columns calculate to amounts in "total" columns. Create formula for all "total" amounts to calculate and produce grand total at end of doc. The project involves adding new formulas ensuring that newly inserted data is added to "amount" colum that the numbers will automatically calculate and be added to the totals, similar to the setup at the beginning of the document. When in doubt please ask questions. This is a small project with a deadline of end of day to late evening Sunday, 01/26/25. Key...
I'm seeking assistance with converting a PDF document into a Word file. The main focus of this project is reformatting the document to improve its layout and overall appearance. Key tasks will include: - Altering the layout to enhance document flow - Modifying fonts and styles for consistency and visual appeal - Incorporating headers and footers appropriately - transfer images As of now, I don't have specific formatting guidelines or styles to adhere to. Therefore, I would appreciate a freelancer with strong design sensibilities who can make aesthetic decisions that will improve the document's presentation. Ideal skills and experience for the job include: - Proficiency in Microsoft Word and Adobe Acrobat - Prior experience in document reformatting - An eye...
...Email Address 2) Specific NGO Focus: Ensure the search targets Muslim-based NGOs only. 3) Use array aggregation to optimize credit usage, grouping multiple data points into a single data object. 2. Output Requirements: 1) Export the aggregated data into Excel format. 2) Automatically upload the Excel file to a designated Google Drive folder. 3) Provide sample outputs for the following locations: a. Malaysia, Selangor b. Indonesia, Jakarta c. Thailand, Bangkok d. England, London 3. Documentation: 1) Create a Microsoft Word instruction manual covering: a. How to run the workflow. b. Adjusting search parameters for countries, states, and categories. c. Ensuring compliance with website constraints to prevent scraping bans. d. Explanation of array aggregation and its im...
I have multiple Excel files that need to be consolidated into a single Excel workbook. Each file should be placed in a separate sheet named according to its original file name. No data transformations or cleaning are required. Ideal skills for this project include: - Proficiency in Microsoft Excel - Experience in data consolidation tasks - Attention to detail to ensure correct file placement and naming.
...Constraints: The report will be provided to the manager within 3 seconds. The report will include all tasks marked as "Completed" or "In Progress." Displaying the report: The system will present the report clearly and orderly, including graphs and statistics. Constraints: The system will ensure the report loads within 5 seconds without delay. The system will allow downloading reports in PDF or Excel format. 6. Use Case: Smart Recommendations for Employees or Managers User Actions: Requesting a smart recommendation: The manager or employee can request the system to provide a suggestion for improving or optimizing work. Constraints: Recommendations will be provided only after the system has gathered sufficient data on projects and tasks. System Actions: Collec...
Hello, I have experience in Python, web scraping, and data extraction using tools like Scrapy, Pandas, and Selenium. I can quickly debug your script and ensure it meets all your requirements. Here’s how I plan to help you: ...data extraction using tools like Scrapy, Pandas, and Selenium. I can quickly debug your script and ensure it meets all your requirements. Here’s how I plan to help you: 1. Fix bugs in your script within 2-3 hours. 2. Add functionality to match conditions and extract data as per your requirements. 3. Provide an easy-to-use script for future use. I will deliver the output in the required Excel format. Looking forward to your response so we can start immediately! Budget: $8 (as per your project description). Timeframe: First phase within 2-...
# Job Title: Submit Job Applications on Job portals using my Resume # Job Description: I am looking for a reliable freelancer to submit job applications on my behalf usi...postings on Linkedin, Glassdoor, Workday and Indeed that match my experience and skills. - Submit my resume to the job listings - Ensure each application is relevant to my background and experience. - Track and report the total number of applications submitted using MS Excel or Google Sheets # Requirements: - Strong attention to detail and understanding of different job roles. - Ability to follow instructions and submit applications appropriately. - Good communication skills for reporting progress. - Experience using MS Word, MS Excel, Google Doc, Google sheets. # Compensation: - $10 for every 100...
I'm seeking a proficient Excel VBA programmer to create a script for my Purchase Order workbook. This project involves both an existing workbook and the creation of a new one. The VBA script should be triggered automatically when the workbook opens. Key Tasks: 1. Implement filters at the top of the worksheet. 2. Adjust the width of Column C (Products). 3. Insert new columns with specified modifications: a. After Column I: Discrepancy (using formula: =I2-H2) b. After Column J: Reason (with a dropdown list sourced from the next sheet) c. After Column K: Notes (a free text column) 4. Apply specific formatting to the columns: a. Column A: 40 points b. Column B: 10 points c. Column C: 60 points d. Column D: 35 points e. Columns E-J: 15 points ...
I need a freelancer to convert a PDF document into a Word file accurately. The PDF contains text only and includes some special formatting, such as headers and footers, as well as bullet points and lists. Ideal skills and experience: - Proficiency in Microsoft Word - Attention to detail - Experience with PDF to Word conversion
Necesito un macro para uber para que me muestre cuanto gano por km recorrido en total para saber si me sale a cuenta o no el viaje
