Excel vba error detectionprá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.
Hi, I am looking for somebody to fix the way combinations load on load on my prestashop website. When somebody changes a combination it jumps and error message appears. The price doesn't recalculate until you go to the basket. You can see what happens in one of the products here: Experiance in prestashop required.
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
...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ů.
...reliable working relationships, clarifying rights and responsibilities, and minimizing potential disputes. To simplify this crucial process for you and provide professional support, I am here to offer freelance contract development services. Areas of Expertise: Understanding your business and industry is my priority. I provide tailored solutions for contract development in online platforms, Word or Excel documents, in both English and Turkish. Whether it's a general template or a customized contract, I can address all sorts of contract requirements. Diverse Industry Experience: From capital corporations to real estate sectors, construction projects to business relationships, I can assist you with creating contracts that cater to specific needs across various industries. T...
I cant figure out the correct formula for this hence asking our incredible freelance community online. I have a spreadsheet with two pages. -To-do page -Done Page The To-do page contains a table with data The Done page has that same table with no Data (it has the same headings) I want to be able to move a row of data from table in the To-do page to the table in the Done page. After I've moved that row of data, the row should be completely deleted from the To-do page. Also would like a Total counter on the To-do page that increments by 1 every time a row is moved. Attached is a test sheet containing small sample size of data. If someone can implement the correct formulas so it works on the test sheet, I'm happy to share the correct dataset with them for them to action. Dat...
...Scope of Work Your responsibilities will include: Items: Configure metrics collection (e.g., CPU usage, memory utilization, disk activity, etc.). Triggers: Set up thresholds and alerts based on best practices. Graphs: Build intuitive and detailed visualizations for key metrics. Dashboards: Design sleek, professional dashboards for a clear overview of server health. Discovery Rules: Automate the detection of hosts, services, and metrics. Templates: Create reusable templates optimized for cPanel and DirectAdmin environments. Monitoring Requirements Host-Level Metrics Ping and availability CPU usage (load averages, per-core utilization) Memory usage (RAM, swap) Disk activity (IOPS, free space, read/write operations) Network traffic (bandwidth usage, errors, dropped packets) Serv...
...data entry. The task involves entering specific sales data into Excel and tracking transactions in Tally Prime. Key Responsibilities: - Data Entry: Inputting sales invoices and summaries from Tally Prime into a standard Excel format. - Tally Prime: Manage and track all sales data in Tally Prime. Requirements: - Proficiency in Excel: Familiarity with the standard Excel format is necessary, as you will be expected to use this for all data entry. - Experience with Tally Prime: Prior experience working with Tally Prime is crucial, as this will be the primary platform for tracking sales data. - Attention to Detail: Precision is key, as data accuracy is critical for this task. Ideal skills for the job include: - Data Entry - Excel - Tally Prime - Attenti...
I cant figure out the correct formula for this hence asking our incredible freelance community online. I have a spreadsheet with two pages. -To-do page -Done Page The To-do page contains a table with data The Done page has that same table with no Data (it has the same headings) I want to be able to move a row of data from table in the To-do page to the table in the Done page. After I've moved that row of data, the row should be completely deleted from the To-do page. Also would like a Total counter on the To-do page that increments by 1 every time a row is moved. Attached is a test sheet containing small sample size of data. If someone can implement the correct formulas so it works on the test sheet, I'm happy to share the correct dataset with them for them to action. Dat...
I'm facing a compilation error on my Beb20 smart contract. Here is the warning I see whenever I view the contract on Bscsan Compiler specific version warnings: The compiled contract might be susceptible to FullInlinerNonExpressionSplitArgumentEvaluationOrder (low-severity), MissingSideEffectsOnSelectorAccess (low-severity), AbiReencodingHeadOverflowWithStaticArrayCleanup (medium-severity), DirtyBytesArrayToStorage (low-severity), DataLocationChangeInInternalOverride (very low-severity), NestedCalldataArrayAbiReencodingSizeValidation (very low-severity), SignedImmutables (very low-severity), ABIDecodeTwoDimensionalArrayMemory (very low-severity) Solidity Compiler Bugs. I need an expert in smart contracts who can help me troubleshoot and resolve this compilation error ...
As a class 11 commerce student, I'm seeking a dedicated tutor specializing in Accountancy, specifically Financial Accounting. Key Requirements: - Expertise in teaching Financial Accounting - Previous experience with 11th grade curriculum - Patience and ability to explain concepts clearly - Flexi...I'm seeking a dedicated tutor specializing in Accountancy, specifically Financial Accounting. Key Requirements: - Expertise in teaching Financial Accounting - Previous experience with 11th grade curriculum - Patience and ability to explain concepts clearly - Flexible schedule for tutoring sessions Your role will primarily involve conducting tutoring sessions aimed at helping me understand and excel in Financial Accounting. Please provide your tutoring approach and availabili...
I'm looking for a freelancer who can assist in gathering the details of company directors from a list of data centres. The project involves finding information for 100 plus data centres. Key Requirements: - Full Name, Title, Email Address, and Phone Number of the directors are required. - Experience wit...and research is crucial. - Prior experience in sourcing business contacts is a plus. - Directors' LinkedIn Profiles are required for validation. - Please include the directors’ specific company roles in your search. Your bid should reflect your ability to provide this information accurately and efficiently. Looking forward to your proposals. The gathered information should be organized in an Excel spreadsheet format. Please include the directors’ specific c...
...targets The AI behavior include advanced decision-making capabilities to make the interaction more life-like and unpredictable. The shooting simulator should be developed using Unreal Engine 5 or Cry Engine to ensure high graphical fidelity and performance. The simulator should be developed to support Windows PC only. The gun positioning system will utilize an inertial tracking system for precise detection. The enemy AI will have dynamic path finding. sound effects. The environments and weather conditions in the scenarios should be highly detailed and realistic. The scenario editor should offer basic customization options for creating simple scenarios quickly....
I cant figure out the correct formula for this hence asking our incredible freelance community online. I have a spreadsheet with two pages. -To-do page -Done Page The To-do page contains a table with data The Done page has that same table with no Data (it has the same headings) I want to be able to move a row of data from table in the To-do page to the table in the Done page. After I've moved that row of data, the row should be completely deleted from the To-do page. Also would like a Total counter on the To-do page that increments by 1 every time a row is moved. Attached is a test sheet containing small sample size of data. If someone can implement the correct formulas so it works on the test sheet, I'm happy to share the correct dataset with them for them to action. Dat...
I'm in need of an Excel worksheet It is already in a wook book split into 3 parts with a total of 32 questions. The questions are designed for a beginner level course, so they're not overly complex. Key Requirements: you are a financial analyst at a large corporation responsible for managing and analyzing the company's product reports and financial data. Your goal is to set up a dashboard to display the needed information. Ideal Skills: - Proficiency in Excel - Experience in creating educational materials - Competence in trend analysis - Ability to work with financial data Heres the Project: You are a financial analyst at a large corporation responsible for managing and analyzing the company's product reports and financial data. The company deals w...
My Shopify site needs a refresh after 4 years of inactivity. Key tasks: - Remove outdate...provided) - Implement minor design changes to improve overall aesthetics - Ensure the site’s security measures are up-to-date, including SSL certificates. - Optimize all product descriptions and pages for SEO to improve search engine rankings. - Make sure the site is fully responsive and looks good on all mobile devices. - Conduct extensive tests on the checkout process to ensure it is smooth and error-free. - It is for a Skin Clinic, I want someone with a good eye for design and has good aesthetic taste. Something exciting and new. I need to ensure everything is updated, functioning correctly, and the information is consistent across the site. Please adjust the layout to enhance us...
I need a proficient Excel developer to create an interactive dashboard that will help visualize work accomplished from different Excel sheets. Each sheet has slightly different data points but shares common elements like quantities completed on specific days and the number of additions per day. The dashboard should also incorporate some aging aspects of the efforts on each sheet. Key Requirements: - Proficient in Excel with experience creating dashboards - Skills in data visualization using line charts, bar charts, and pie charts - Ability to perform and display calculations including sum of quantities, count of entries, and difference between start and end values The dashboard must include: - Data visualization through number fields (count, sum, difference) - Abilit...
Looking to create the views in mariadb required for a calculation system to process sales data and automatically determines commissions based on various metrics. Category-based calculations Flexible rule implementation Experience with Excel/MariaDB Strong analytical skills Experience with business calculation systems Ability to implement complex business logic Looking for clean, maintainable code with proper documentation.
I need someone to transfer data from an Excel spreadsheet to a Word file, following a provided template, and then save it as a PDF. Ideal Skills and Experience: - Proficiency in Microsoft Excel and Word - Attention to detail (this is a must) - Ability to follow instructions accurately - Experience with data entry and document formatting Data Types: - The data consists of a mix of both text and numbers. Task Specifics: - A template will be provided for the Word file, which will require simple formatting (e.g., bold, italics, headings). - Instructions will be provided on how to organize the data in the Word file.
I am looking for a professional developer to create an e...Pending, Delivered, Rejected, In Warehouse ✅ Smart Scanning: Drivers can scan packages using a camera or scanner ✅ Warehouse Management: Accept and process incoming shipments ✅ API Integration: Connect with other courier companies in Albania and North Macedonia ✅ Reports & Analytics: Generate reports for orders, drivers, and sellers ✅ Order Printing: Print orders in A4 format and label prints ✅ Excel Import: Bulk order registration for higher efficiency Preferred Technologies: ✅ Laravel / Node.js for Backend ✅ React / Vue.js for Frontend ✅ MySQL / PostgreSQL for Database ✅ Mobile App (Optional) ? If you have experience in logistics platform development and can build a stable, fully functional system, contact me!
...with two Excel files: 1. “List to be sent to ” (Main Inventory File) • Contains a list of medical disposables and device parts used in our facilities. • Each row represents a unique item that must be mapped to both EMDN & UNSPSC. • You will add four new columns to this sheet: • EMDN Code (from reference sheet) • EMDN Name (from reference sheet) • UNSPSC Code (from reference sheet) • UNSPSC Name (from reference sheet) 2. “Global Item ” (Reference Data for Mapping) • Contains official EMDN & UNSPSC codes in two separate sheets. • You will use these sheets to correctly classify each item from our inventory. ✅ Requirements & Skills ✔ Experience in medical device classification & inventor...
...with two Excel files: 1. “List to be sent to ” (Main Inventory File) • Contains a list of medical disposables and device parts used in our facilities. • Each row represents a unique item that must be mapped to both EMDN & UNSPSC. • You will add four new columns to this sheet: • EMDN Code (from reference sheet) • EMDN Name (from reference sheet) • UNSPSC Code (from reference sheet) • UNSPSC Name (from reference sheet) 2. “Global Item ” (Reference Data for Mapping) • Contains official EMDN & UNSPSC codes in two separate sheets. • You will use these sheets to correctly classify each item from our inventory. ✅ Requirements & Skills ✔ Experience in medical device classification & inventor...
I can write code in VBA for moving rows (orders) from one sheet to the next upon entering specific data in a cell or any other event. Client will explain the rules for moving data in each particular sheet.
I have a CSV/Excel file containing product prices that I need adjusted. All product prices need to be increased by 20%. If the price is $0 then do not update and leave it at $0.
Architectural design - ongoing work: Architectural design of Self storage building and associated infrastructure. Software: • Revit 3D modelling • Lumion Rendering • Autocad • Excel Skills: • Experienced in architectural drafting and design • Knowledge and experience with Australian codes and standards • Full architectural drawing sets including: • Ability to create comprehensive fire safety and evacuation plans • Designing for energy-efficient and sustainable construction o Site plans o Self-storage unit layouts o Floor plans o Elevations o 3D views o Sections o Landscape plans o Traffic management plans o Window and door schedules o Cut and fill plans o Demolition plans o Office and amenity fitout o Construction details • Conve...
...connections. Target Audience: Businesses in Mississauga and the GTA, including but not limited to: ✅ Plumbing companies ✅ Electrical contractors ✅ HVAC companies ✅ Landscaping services ✅ Roofing companies ✅ Delivery & logistics businesses ✅ Mobile auto repair & detailing services ✅ Any business with fleet vehicles Deliverables: The freelancer will provide a detailed, organized list in Google Sheets or Excel, including: ? Business Name ? Industry Type ? Company Address ? Contact Person (Owner/Manager/Decision Maker) ? Phone Number ? Email Address ? Company Website Requirements: ✔ Proven experience in B2B lead generation ✔ Ability to source verified, up-to-date contact details ✔ Familiarity with Mississauga/GTA business landscape is a plus ✔ Strong research skills & a...
...resource management, and enhance urban livability. Key Features AI-Driven Air Quality Forecasting: Real-time air quality monitoring and forecasting using AI/ML models. Alerts for citizens and authorities when air quality deteriorates. Smart Traffic Flow Optimization: Real-time traffic monitoring and optimization using AI. Suggestions for alternate routes to reduce congestion. Water Leak Detection & Smart Irrigation: Detect water leaks in the city’s infrastructure. Optimize water usage through smart irrigation systems. Waste & Recycling Optimization: Track waste collection and recycling efforts. Provide insights for optimizing waste management. Smart Energy Management: Monitor energy consumption across the city. Suggest energy-saving measures for house...
...gestionar invitados. Permitir que los invitados confirmen su asistencia en línea. Funcionalidades adicionales: Envío automático de correos electrónicos con las invitaciones y confirmaciones. Posibilidad de agregar comentarios o notas adicionales al confirmar asistencia. Diseño visual y funcional atractivo y amigable para los usuarios. Posibilidad de exportar las listas de invitados a formatos como Excel o PDF. Referencias: Nos gustaría implementar algo similar a los sistemas que se encuentran en: Bliss & Bone The Knot
I need a professional to test my VBA on MAC. You will be testing for macro execution, user interface elements and data processing on MAC as we develop on PC but have mac clients. Skills: - Proficient in VBA - Experienced with testing/running VBA on MAC - Excellent problem-solving skills.
...newcomers from various countries seeking health insurance in Switzerland. Ideal Skills and Experience: - Proven experience in data entry - Familiarity with public services preferred - Ability to handle sensitive data with confidentiality - Experience with database management - Attention to detail and accuracy - Knowledge of health insurance processes and terminologies The data should be entered in Excel format. The project will involve entering between 100 entries for the beginning. The project should be completed within the shortest possible timeframe. Please include the following data validation requirements: newcomers coming in Switzerland and requiring health insurance. The data should be organized by the newcomer's country of origin. Please include accuracy checks ...
I'm looking for an expert in Excel to assist me with some formulas related to numerical data. The primary goal is to help me with summing and averaging calculations.
El objetivo es crear un *dashboard automático en Excel* para el gimnasio, que permita consolidar los datos diarios de nuevos afiliados, renovaciones, ventas de cafetería y suplementos, y el cuadre de caja. El dashboard debe ser fácil de usar para las recepcionistas, con gráficos dinámicos y filtros para ver información por día, semana o mes. Además, debe actualizarse automáticamente cada vez que se ingresen nuevos datos sin dañar el archivo y debe ser claro y sencillo para evitar errores en su uso.
I'm in need of an Excel expert who can assist with fixing my spreadsheet and importing a proposal sheet. Specific tasks include: - Creating templates - Inserting data - Design and layout I'm experiencing some issues with my current spreadsheet that have not been resolved, so I would also appreciate a review of this. Ideal candidate should be proficient in Microsoft Excel, have experience with spreadsheet troubleshooting, and capable of assisting with proposal sheet preparation.
I'm seeking a native professional translator to translate an English text into Arabic (KSA). The text contains a list of 870 words linked to DIY tools, with a 27 % repetition rate. The lists are marketing phrases intended for the web and tools for professionals (like grinders, drills, hammers, etc.). Deliverables: - The translated text must be delivered in an Excel spreadsheet + SDLXLIFF (or TMX). - The job has to be completed by Friday, 7th, at 17:00 CET. Tone: - The translated marketing phrases should have an informal tone. Terminology: - There are no specific terminologies or keywords that need to be kept in English. Ideal Skills: - Strong proficiency in English and Arabic (KSA) - Experience with translating technical and marketing content - Familiarity with DIY tools...
...contact info, Submission timestamp. - Data should be organized by Pick Up Location. - Knowledge of API and Google Sheets is essential. - The ability to distinguish different customer orders using the Order ID. - The ability to distinguish if that customer has skipped or canceled their order for that week -The ability to add new customers to respective pick up locations based on new orders - Include error handling to manage API call failures or data retrieval issues. - Provide filtering options to sort and view data based on specific criteria such as date, customer name, or order status. Ideal Skills: - Proficiency in Google Sheets and JotForm - Experience with APIs - Data organization skills - Attention to detail The freelancer will have full access to the website's API fo...
I require a proficient web scraper to gather contact details from websites. The final data needs to be formatted into an Excel spreadsheet. Ideal Skills and Experience: - Proficient in web scraping tools and techniques - Experience in data collection from websites - Ability to organize and format data into Excel - Attention to detail to ensure data accuracy
My WordPress site is facing plugin conflicts and is slow, leading to a poor user experience. I need a professional who can not only fix these issues but also enhance the UI/UX and redesign some layout aspects of the site. Additionally, I want to integrate my Shopify store into this WordPress website. Key Responsibilities: - Diagnose and fix plugin conflicts and speed issues - Implement regular maintenance tasks - Enhance the UI/UX of the site - Redesign certain layout aspects - Integrate Shopify into the WordPress site Ideal Skills: - Extensive experience with WordPress troubleshooting and maintenance - Proficiency in UI/UX design and layout redesign - Prior experience with Shopify integration - Strong understanding of website speed optimization techniques - Excellent problem-solving ski...
I want to change from to without affecting the SEO too badly. To be considered for this project, BRIEFLY tell me how you will approach this transition in one sentence. (This project is also to troubleshoot three minor issues on the site first: image upload error, blog thumbnail proportions and deleting one element from homepage.) I ignore all auto bids, ai bids and copy/paste proposals. Let me know if you're available to do this right now. No going to sleep until it's done.
