Vba macro data excel wordprá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...
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 need an Excel expert to elevate my sales data spreadsheet into a high-end, professional looking document, perfect for data presentation. Key Requirements: - Extensive experience with Excel and data visualization. - Ability to incorporate company branding seamlessly into the spreadsheet. - Understanding of the principles of professional, high-quality design. Important Elements: - Integrate company logo and color scheme. - Create a visually appealing layout that enhances data presentation. Ideal Skills: - Excel - Data Visualization - Graphic Design in Excel - Branding Please note, this project is not about altering the underlying data, but about making the spreadsheet visually impressive and suitable for professiona...
...create a comprehensive Excel spreadsheet template with macros, active control options, and bar charts for my company, Measurement Solutions, Inc., an industrial distributor specializing in measurement equipment. This template will be used for quoting custom gages. The project will involve: - Creating macros to automate calculations, generate custom quotes, and handle data validation and cleanup. - Designing the template to input various types of data including customer information, product specifications, pricing details, and delivery information. - Incorporating bar charts for price/time comparisons. Ideal skills for this job include: - Advanced Excel expertise, particularly in creating and implementing macros. - Experience with data validation and ...
Puede usar chatgpt sin abusar. De ello Descripción del proyecto: Tengo un documento en Word que estoy convirtiendo en un Ebook, pero necesita varias mejoras para que quede profesional. Las tareas que necesito que realices son las siguientes: Correcciones: Ortografía y gramática. Redacción y estilo para mejorar la claridad y presentación. Estructura general del texto. Índice: Crear un índice nuevo. El índice debe incluir solo las especialidades y las enfermedades en orden alfabético, sin repetir la especialidad encima de cada enfermedad. Enumeración: Las enfermedades están actualmente enumeradas, pero el formato no es estético. Necesito que cada enfermedad tenga una enumeración clara, organ...
I'm seeking an experienced data collector to compile an exhaustive list of all commercial real estate agents located in Düsseldorf and within a 30km radius. These agents should be dealing specifically with store or warehouse properties. The data must be organized in an Excel spreadsheet with the following columns: - Company - Phone - Email - Website - Address Accuracy and precision are paramount. The details must be correctly and meticulously recorded. The data should be sourced primarily from online directories, although any reliable source will be considered. The final step of the project will involve verifying the gathered information to ensure its correctness and reliability. Ideal skills for this job include: - Proficient in data coll...
I have a picture of an Excel template that I need replicated. The template primarily consists of tables and is primarily text-based. I also need specific text formatting including bold and italics, as well as colored text. Ideal skills for this project: - Proficiency in Microsoft Excel - Attention to detail for accurate replication - Ability to format text according to specifications
I'm looking for a freelancer who can extract customer data from Apollo for me. The requirements are as follows: - Data Count: I'm looking for a dataset that contains between 50,000 to 100,000 customer records. - Specific Details: The data should primarily include contact information. Other customer details such as purchase history or demographic information are not required. - Delivery Format: The contact information should be delivered in an Excel format. Ideal skills for this project include data mining, Excel proficiency, and experience using Apollo's data extraction tools. Please provide a realistic timeline for data extraction and any prior experience you have with similar projects. Hi, I’m looking to gath...
...(1-5 stars) • Date range • Export feedback data as a CSV or Excel file. 4. Submission and Data Handling • Upon submission, the following data should be saved: • Cashier/User ID • Rating (1-5 stars) • Comment • Phone number • Date and time • After submission, a completion page will display. 5. Security Features • Prevent users from returning to the feedback page after submission. • Ensure the system validates QR codes and blocks unauthorized access. Deliverables: • Fully functional QR code generation and feedback system integrated with ERPNext. • A user-friendly feedback page as per the provided design. • An admin panel for QR code generation, feedback reporting, filtering...
...extracted URLs. Identify and report URLs returning 404 errors, redirects, or other HTTP issues. Provide the final report in a structured format (CSV or Excel) containing: URL HTTP Status Code Error Details (if applicable) Requirements: Proven experience with web crawling, sitemap parsing, and HTTP status checking. Proficiency in a scripting language like Python (preferred), PHP, or another suitable technology. Familiarity with tools and libraries such as requests, BeautifulSoup, or similar for parsing and requests. Ability to handle large sitemap files efficiently. Strong organizational skills and attention to detail. Deliverables: A CSV/Excel report listing all URLs with their respective HTTP status codes. Highlighted URLs that return 404 errors or other issues. Optio...
I'm in the process of constructing a Tableau dashboard to visualize Year-over-Year (YoY) growth on a monthly and yearly basis across various regions. The perc...to visualize Year-over-Year (YoY) growth on a monthly and yearly basis across various regions. The percent of YoY growth is to be derived from the same month of the previous year. Key Aspects: - Data Source: The dashboard will utilize data from Excel/CSV files. - Geographic Scope: Analysis will cover 1-5 regions. - Temporal Scope: The focus will be on the last 5 years. Ideal Skills: - Proficiency in Tableau is a must. - Strong background in data analysis and visualization. - Experience working with Excel/CSV files. - Understanding of YoY growth calculations. - Familiarity with interpreting ...
Descripción del proyecto: Tengo un documento en Word que estoy convirtiendo en un Ebook, pero necesita varias mejoras para que quede profesional. Las tareas que necesito que realices son las siguientes: Correcciones: Ortografía y gramática. Redacción y estilo para mejorar la claridad y presentación. Estructura general del texto. Índice: Crear un índice nuevo. El índice debe incluir solo las especialidades y las enfermedades en orden alfabético, sin repetir la especialidad encima de cada enfermedad. Enumeración: Las enfermedades están actualmente enumeradas, pero el formato no es estético. Necesito que cada enfermedad tenga una enumeración clara, organizada y visualmente agradable. Dise&ntild...
I need a client space on my website for companies to manage their training. Each company will have personalized access to a dashboard with key KPIs, allowing the HR manager to monitor, in real...Displayed: Scheduled training Ongoing training Completed training Cancelled or rescheduled training Document Management: Generate and download attendance sheets Issue training certificates Upload and access training materials Additional Requirements: Notifications (email or SMS) for scheduled sessions, cancellations, and rescheduling Export of data and reports in PDF or Excel formats Role-based access with strict data privacy (users can only see their own data) Scalable solution with technical support for deployment Please provide an estimate of the cost and timeli...
I'm looking for a freelancer who can meticulously extract a large mixed data (numerical and text) table from a statistical website and transfer it into Excel without missing any details. The ideal candidate should ensure that the data is formatted in Excel in the exact same way as it appears on the website. Skills and Experience: - Proficient in data extraction and Excel - Attention to detail to ensure no information is missed - Ability to format data in Excel as per the client's request
I need a skille...need a skilled Python programmer who can help in extracting table data from PDFs and converting it into an Excel file. The tables in the PDFs have varying structures, so your ability to handle different table layouts is essential. Key requirements: - Extract tables from multiple PDFs - Convert the data into a well-structured Excel file with 4 different formats across 2 sheets - Ensure the data is accurately represented as mixed data (both numeric and text) Ideal Skills: - Proficiency in Python, with experience in data manipulation using Pandas DataFrame - Excellent attention to detail for accurate data extraction and conversion - Prior experience in handling PDFs and Excel files With your expertise, I hope...
K zobrazení podrobností se zaregistrujte nebo přihlaste.
I need a translation of catalogs from Spanish to French, specifically focused on electricity and renewable energies. The document is around 2000 words. - Audience: The catalog is aimed at industry professionals. - Technical Terminology: The translation should incorporate advanced level technical terminology appropriate for the industry. - Format: The final document should be delivered as a Word document. Ideal candidates should be fluent in both Spanish and French, with a deep understanding of the electricity and renewable energy sectors. Prior experience in translating technical documents is highly preferred.
I'm seeking a seasoned Business Analyst with 3-6 years of experience, particularly in the retail sector. This remote, 3-month project entails developing and implementing brand marketing strategies to boost our brand visibility. Key Responsibilitie...case studies - Monitor and assess the impact of marketing initiatives - Analyze competitors' operations and identify their strengths and weaknesses. Desired Skills: - Strong analytical capabilities - Excellent marketing knowledge - Superb communication skills - A touch of sales experience. Ideal candidates will possess a BCA, MCA, B.E. or a relevant degree. Experience with tools like Microsoft Excel, Google Analytics, and Salesforce is a plus. Though not mandatory, a primary objective of enhancing brand recognition would be ...
I need assistance in entering mixed data, which is currently stored in digital files, into MS Word. Requirements: - Proficient in MS Word and data entry - Able to work with mixed data (text and numeric) - Experience handling digital files, particularly text files The data is sourced from various digital files including Excel, PDF and text files. Your role would primarily involve transcribing this into MS Word, so attention to detail and accuracy is crucial.
I need a freelancer to help with data scraping and organizing the information into an Excel file. The data source will be various databases. - Scope of Work: - Scraping email addresses and names/contact information from databases. - Organizing the data into an Excel file with separate columns for each data type. Ideal Skills: - Proficient in data scraping techniques. - Excel expertise, specifically in organizing and formatting data into separate columns. - Attention to detail to ensure data accuracy. - Previous experience with data scraping from databases is a plus.
I need a multi-purpose chassis designed for a heavy-duty construction vehicle primarily intended for excavation in mountainous terrains. The vehicle will face challenging conditions, so the chassis must excel in durability and flexibility. Key Requirements: - Design a chassis that can withstand tough, mountainous terrains while being able to adapt to different conditions and tasks. - The design should not prioritize being lightweight, but rather focus on durability and flexibility. - Previous experience in designing vehicle chassis, particularly for construction or heavy-duty vehicles, is highly desirable. Ideal Skills: - Mechanical Engineering - CAD Design - Experience with heavy-duty vehicle design - Knowledge of materials for durability - Creativity for flexible design
I need help formatting my typed notes in Microsoft Word. Ideal Skills: - Proficiency in Microsoft Word - Attention to detail - Good understanding of formatting conventions - Ability to follow specific preferences Please Note: - I do not have a specific template or style guide, but I do have preferences.
Project Title: Data Entry and Administrative Support Needed Project Description: Update a large database with accuracy and efficiency. Use Google Sheets and Excel for data entry and management. Ensure all data entries are accurate and error-free. Submit daily progress reports. Required Skills: Proven experience in data entry. Proficiency in Google Sheets and Microsoft Excel. Ability to complete tasks within deadlines and maintain accuracy. --- If your project is related to Sales & Marketing or Translation & Languages, you can modify it accordingly. Example: Project Title: Content Writing for Marketing Campaigns Project Description: Create engaging and customer-attractive content for a new product launch. Write short yet i...
...Description: We require a robust and scalable Project Management System built on Microsoft Power Apps. The system should allow users to manage projects, tasks, risks, budgets, and reports efficiently. The application will integrate with Microsoft tools like SharePoint, Power Automate, and Teams for seamless collaboration and automation. Project Goals: Centralized management of projects, tasks, and related data. Improved collaboration among team members. Automation of workflows for task assignments, approvals, and notifications. Advanced reporting and analytics for project tracking and decision-making. Core Features: 1. Dashboard Overview of all projects. Visual status indicators (e.g., progress bars, charts). Quick filters (by priority, status, department). 2. Project Manageme...
I need assistance with data entry. The data is mixed (text and numbers) and is currently in Excel/CSV format. The primary purpose of this data entry task is to populate a database. Ideal candidate should be proficient with: - Excel/CSV - Data entry - Attention to detail Experience with database management and data handling is a plus.
I'm seeking a graphic designer to create artwork as p[er the attached Word Doc for a trophy. The design should primarily use blue and gray, incorporating text, shapes, and my logo. Key Requirements: - Design should as per the sample provided. - Use of primary colors: Blue and gray. - Incorporation of text, shapes, and my logo into the design. - Delivery of the final design in vector format: .ai and .eps Ideal Candidate: - Expertise in graphic design, particularly in creating modern designs. - Proficient in vector graphic software. - Strong understanding of color theory and design aesthetics. - Experience with incorporating logos into designs. - Ability to deliver high-quality, print-ready files.
I'm looking to develop a mobile-based, Android-compatible, interactive word puzzle game. Key Features: - A grid where players can input letters to form words. - An intuitive interface allowing players to easily move letters within the grid. - A feature to return letters to their original position. Ideal Skills: - Proficient in Android game development. - Experience in creating interactive puzzle games. - Strong understanding of user interface (UI) and user experience (UX) design principles. Please provide examples of similar games you've developed in your bid.
I’m looking to automate sending birthday promotion messages to a list of contacts via WhatsApp. Here’s what I need: What I Have: • An Excel sheet with nearly 2,000 contacts. o Each entry has: Name Contact number (with country code) Birthday date • I’ve also got 2 promotional images and a message I’d like to send. What I Need: 1. Send WhatsApp Messages (direct from excel) two images I provide. 2. Reusable for Future Months o For upcoming months, I want to just update the Excel sheet with new names, numbers, and birthdays, and then click something to send messages to the new list. 3. Extras I’d Like: o Skip duplicate numbers so no one gets spammed. o Log which messages were sent successfully and which weren’t. How...
Bullet Points: Copywriting Skills: I have extensive experience in writing articles, product descriptions, website copy, and other forms of content. SEO Copywriting: I am proficient in creating SEO-friendly content that helps improve search engine rankings. Engaging and Persuasive Writing: I excel in writing compelling content that connects with readers and enhances brand engagement. Client Communication: I understand client needs and can craft clear, persuasive copy tailored to their target audience. Portfolio Examples: I have a portfolio showcasing my work, including blog posts, website copy, and product descriptions. Full Description: I am a skilled copywriter with a passion for creating content that not only informs but also engages and motivates readers. With a strong background...
...& OCR Data Extraction Description: We are looking for a Python developer to help automate the extraction of data from screenshots. The project involves two key tasks: Screenshot Cropping Script: Develop a script to crop screenshots and isolate the relevant data sections, focusing on the area below the column headers. The cropping areas may vary slightly between different screenshots. OCR Data Extraction and Excel Conversion: Use OCR tools (like Tesseract) to extract text from the cropped images. Convert the extracted data into a structured format, and save it into an Excel file, with each piece of data placed into corresponding columns. Requirements: Proficiency in Python (Pillow, OpenCV, pytesseract). Experience with OCR ...
We need an experienced data researcher with the following skills: 1) Experience in Internet Research 2) Good English skills 3) Knowledge of google sheets & excel 4) Attention to detail This is a long term project.
Excel Data Cleaning: Removing duplicates, errors, and inconsistencies for accurate analysis. Excel Data Formatting: Organizing data into a clear and professional layout. Excel Dashboards: Creating interactive and visually appealing dashboards for data visualization. Excel VBA: Automating repetitive tasks and creating custom macros to save time. Pivot Tables and Charts: Summarizing and visualizing large datasets effectively. Data Analysis: Performing advanced calculations and trend analysis for insights. Conditional Formatting: Highlighting important data with rules and color coding. Formulas and Functions: Using advanced formulas (e.g., VLOOKUP, INDEX-MATCH) for dynamic calculations. Data Validation: Ensuri...
...professional formatting of fractions, equations, and other mathematical expressions. Create visually engaging, age-appropriate layouts suitable for primary school students. Follow specific formatting guidelines (details will be provided). Requirements: Applicants must: Demonstrate experience in formatting educational materials or similar projects. Be proficient in using tools such as Microsoft Word, Adobe InDesign, Canva, or equivalent software. Show expertise in formatting fractions, equations, and mathematical content to a professional standard. Submit a sample of previous work that showcases your ability to format mathematical content effectively. Deliverables: Professionally formatted worksheets ready for student use. Consistent and clean formatting across all materials. To...
...above-industry-standard compensation for those who consistently exceed expectations. Key Responsibilities: - Design, build, and optimize Funnelish pages tailored to health and wellness products. - Implement strategies to maximize conversions, engagement, and sales. - Collaborate with our team to ensure alignment with branding and business goals. - Continuously analyze and improve funnel performance based on data and insights. - Meet tight deadlines while maintaining the highest quality of work. Key Requirements: - Proven experience building successful Funnelish pages, specifically for health and wellness products. - Portfolio showcasing your top 10 performing stores or projects. - Strong understanding of sales funnel strategies, customer psychology, and CRO (conversion rate optim...
...Sales and Marketing Data **Description:** We are seeking an experienced Power BI developer to create a comprehensive report for our sales and marketing data. The ideal candidate should have a strong background in data visualization and analysis, with a proven track record of delivering high-quality Power BI reports. **Project Requirements:** 1. **Data Integration:** - Integrate sales and marketing data from various sources (e.g., CRM, ERP, Excel files). - Ensure data accuracy and consistency. 2. **Report Design:** - Create visually appealing and interactive dashboards. - Include key metrics such as sales performance, marketing campaign effectiveness, customer segmentation, and ROI analysis. - Design reports that are easy...
I need a Word document transposed into an Excel file. Key Points: - The original document contains text only. - Text organization within the Excel file is not uniform. It varies and will need to be explained. Ideal Skills: - Proficient in Microsoft Excel and Word. - Good understanding of data transposition. - Detail-oriented to ensure accurate transfer of content.
