Visual Basic Jobs

Necesito agilizar un proceso interno llamado MTM. Hoy lo ejecuto manualmente y pierdo demasiado tiempo en: • organizar datos • realizar cálculos complejos • generar reportes de salida Quiero que todo eso ocurra con un único clic desde un botón incrustado directamente en la hoja de Microsoft Excel. Alcance inmediato (entrega en 1-2 días): 1. Revisar conmigo el flujo actual de MTM para identificar qué pasos pueden convertirse en código VBA sencillo. 2. Crear las macros necesarias que automaticen los tres puntos anteriores sin alterar la estructura de mis archivos. 3. Insertar un botón visible y descriptivo dentro de la hoja que dispare todo el proceso. 4. Probar la solución con un pequeño set de datos y a...

Necesito crear cinco libros de Excel orientados a presupuestos y finanzas. Quiero una solución de complejidad intermedia: lo bastante robusta para seguir ingresos y gastos en detalle, pero aún fácil de entender para usuarios sin perfil técnico. Alcance general • Cada libro cubrirá un área distinta (operaciones, marketing, recursos humanos, inversiones y flujo de caja). • Las hojas deberán estar organizadas por secciones de captura, cálculo y reporte, con celdas protegidas donde convenga. • Incluiré datos de ejemplo; tú ajustarás fórmulas y estructura para que, al sustituirlos, todo se actualice automáticamente. Requisitos técnicos • Formulación avanzada: BUSCAR...

Necesito una macro para CorelDRAW que tome los vectores y grupos de objetos que yo seleccione y los reubique dentro de un rectángulo que yo mismo defina, aprovechando al máximo el espacio disponible sin que se superpongan. Requisitos clave • Funcione con vectores y grupos de objetos de cualquier tamaño. • Pida o permita introducir las dimensiones del área destino. • Calcule automáticamente la mejor distribución posible (similar a un “auto-nesting”), manteniendo proporciones. • Respete un margen configurable entre objetos y, de ser posible, permita rotación a 90° para ganar espacio. • Interfaz sencilla: botón o acceso directo dentro de CorelDRAW para ejecutar la orden en un solo paso. ...

Excel Project Description I have an existing Excel spreadsheet used to track field production, and I need help cleaning it up, updating some information, and building a dashboard with automated reporting. Updates Needed 1. Update Hourly Rate Update the hourly rate across the entire workbook to $65.00. Ensure all formulas and calculations reference this updated rate correctly. 2. Update Field Supervisor Names Replace the current supervisor names with the following: Steve Brent Shane Buzz These should be set up so they can be easily filtered and used in reporting. 3. Update Labor Names Replace labor names with: Anthony Marcus Ricky Levi Caleb Chase Gabe These should also work properly with filtering and reporting. Spreadsheet Cleanup The current sheet needs to be cleane...

I need a rolling Excel spreadsheet with the following features: - Data Entry and Validation - Automated Calculations (Sum and Averages) - Manual Input for Data Sourcing Ideal Skills and Experience: - Proficiency in Excel - Experience with Data Validation and Automated Calculations - Attention to Detail and Accuracy Looking for someone to create a user-friendly, efficient spreadsheet. 14 tabs with a corporate total page

I need a secure Android banking app built from the ground up for Arab Bank. The core scope is clear: users must be able to manage their accounts, transfer funds, and pay bills effortlessly from their phones. To make this happen, I’ll supply API documentation for our core-banking system along with brand guidelines and sample data. Your task is to design and code the full mobile experience—clean UI, solid architecture, and encrypted communication throughout. Performance, accessibility, and regulatory compliance (PCI-DSS level practices) are non-negotiable. Deliverables • Fully functional Android app (latest stable SDK) • Source code in Git, well-commented and neatly structured • UI/UX assets (Figma or similar) • Integration layer that consumes our ...

Create a quick-invoicing program. for an environmental testing lab; for quick-receipt of payment from walk-in clients. - MS Excel or MS Access. local network or single device storage. - 1 screen "menu" that pulls up existing walk-in customers, or can add new ones. - has a new invoice each time the sheet is opened (preferably sequential, starting with last 2 digits of the year; ie: 2026 = 260001 - 'list' price is added. 'discount' can be added at our company's discretion as an item. - pre-populates an invoice with common services, with customer-specific prices - the services have different priorities (Normal, rush, emergency); think of a restaurant menu of adding 'extra' items to a routine menu item - compile items into an invoice, preferabl...

I will send you one master Excel workbook and a set of clear photographs taken directly from the dispatch register. Your task is simple but must be done with total accuracy: work through every line, compare the cab number and destination in the spreadsheet against what you see in the register image, and note any mismatch you find. I need both location and cab-number discrepancies flagged. Feel free to colour-code, add a comments column, or use any other neat method you prefer, as long as the final sheet makes each issue obvious on first glance. A brief daily progress note is essential so I always know how many rows are left and how many mismatches you have already caught. When you send your offer, focus on the experience you have with high-volume data checking or Excel data entry pro...

I have several Excel spreadsheets that need to be keyed into our system by hand. Everything is already organized in clear columns and rows; no importing scripts or macros are required—this is purely manual data entry. Your task is to read each cell, verify the value is complete and legible, then enter it into the web-based form I provide. Accuracy is critical, so I will run spot checks after each batch. I will share the first sheet as a sample; once that is confirmed correct, the remaining files will follow in groups of five. Deliverable • Completed web forms (or CSV export from the form tool) for every row in the supplied spreadsheets, returned in the same order as the source files. Acceptance criteria • 99%+ accuracy on spot-checked fields • All mandatory f...

I need a clean, well-structured Excel workbook that will automatically calculate our storage fees at $0.60 per cubic foot. I’ll supply the raw numbers as cubic feet per line item, spanning more than 10 different organizations, so the file must scale gracefully. Workbook requirements • A data sheet where I can paste or import the monthly cubic-foot figures per line item. • Formulas that multiply each entry by 0.60 to generate the charge, then roll those charges up:  - by line item and organization for each month,  - into directorate-level totals for the same period. • Pivot tables that let me view charges month-by-month for every organization and its individual line items, plus a grand-total row for each directorate. • An additional pivot (or...

I have several Excel spreadsheets that need to be keyed into our system by hand. Everything is already organized in clear columns and rows; no importing scripts or macros are required—this is purely manual data entry. Your task is to read each cell, verify the value is complete and legible, then enter it into the web-based form I provide. Accuracy is critical, so I will run spot checks after each batch. I will share the first sheet as a sample; once that is confirmed correct, the remaining files will follow in groups of five. Deliverable • Completed web forms (or CSV export from the form tool) for every row in the supplied spreadsheets, returned in the same order as the source files. Acceptance criteria • 99%+ accuracy on spot-checked fields • All mandatory f...

I’m spending far too much time re-typing purchase vouchers into Tally when everything is already organised in Excel. I need a small utility that reads those spreadsheets and posts each row as a purchase entry in my Tally company, with all taxes, supplier details and inventory lines carried over exactly as they appear in the sheet. You are free to choose the most efficient route—Tally XML import, ODBC, TDL, or a Python/.NET bridge—so long as the final result is a one-click (or near one-click) process that any non-technical staff member can run on a Windows machine. Deliverables • Executable tool or script with a simple UI or clear command-line instructions • Mapping configuration so I can point new spreadsheet layouts to the correct Tally fields without cod...

I’m looking to lock in a reliable baseline schedule for an upcoming project so I can measure progress against a fixed set of dates right from day one. The focus is a project-level timeline presented as a Gantt chart, detailed enough to highlight every key milestone without drilling all the way down into individual task subtasks. Here’s what I need: • A complete Gantt chart that maps the full project duration, major phases, and clearly defined milestones (with start, finish, and baseline dates). • Logical sequencing with dependencies called out so the critical path is obvious at a glance. • A baseline saved alongside the live schedule so variance tracking is effortless later on. • Editable source file—MS Project, Excel, or another mainstream too...

I need all mixed data—numbers and text—lifted accurately from a PDF and placed into Google Sheets. Once the transfer is complete, I expect advanced formatting: formulas where they add value and conditional formatting set up to highlight any duplicate entries automatically. Deliverables: • A Google Sheet populated with every record from the PDF, checked for integrity • Conditional-formatting rule that flags duplicates clearly • Any supporting formulas documented in-cell or with a brief note so I can tweak them later Attention to detail is critical; the sheet should be ready for immediate analysis the moment you hand it back.

I have a collection of PDFs containing tables that must be transcribed into a single Google Sheet. Each table holds both text and numerical values, and while many files have just one table, a portion include several that need to be captured separately yet placed in the same worksheet for easy consolidation. Accuracy is critical: every label, figure, and formatting nuance in the source tables should appear exactly the same in the sheet. Keep column order and headings consistent so downstream formulas run without rework. For files with multiple tables, please insert a blank row between each set so I can quickly distinguish them later. I will share the PDFs and an empty Google Sheet with the required header row. When finished, simply notify me—no extra macros or scripts are necessary;...

I have between 11 and 20 pages of handwritten notes that must be turned into a clean, well-structured Excel workbook. Every figure, label and annotation from the pages needs to appear in the sheet, and a handful of embedded charts sketched in the margins must be rebuilt with Excel’s native chart tools so the file remains fully editable. Accuracy matters more than speed: spelling, numeric values and any units written in the notes must match what I wrote, and the charts should mirror the original scales, series colours and titles. Please keep the workbook tidy—use clear headings, consistent column widths and chart formatting that looks professional. You can use any version of Microsoft Excel for Windows or Mac as long as the final file opens flawlessly in the current 365 releas...

I have one PDF that contains a series of clearly formatted tables. I need every row and column from those tables transferred accurately into a Google Sheet, preserving the original layout, headings, and cell order. You will receive the PDF as a single file. Your job is simply to open it, copy—or, if you prefer, programmatically extract—the data, and paste or upload it into the sheet I will share. Accuracy is critical; I’ll be double-checking totals, column alignment, and that no rows are missed. Deliverable • A Google Sheet mirroring each table in the PDF, ready for immediate use and further analysis. Acceptance criteria • 100 % of table rows and columns captured. • Original table headings retained. • No extra spacing, merged cells, or forma...

EXCEL RELATED TASK...IN SIMPLE LANGUAGE EK EXE DEVELOP KRNI H APKO AI SE JISME MAX 10 MIN LGENGE JO ME APKO FORMAT FILE DUNGA USKO APKO ERP_CONVERTED_2 WALE FORMAT ME KRNA H ..FIR APKO USME DATE WALE COLUM ME IS TARH KRNA H JO DISBURSEMENT DATE H SAME ACCOUNTS KI WO EK SATH OLDEST TO NEWEST AAE AND COLL KI B ISI TRAH SE AAE FIR APKO ISKO UTILITIY WITH DROPDOWN WALE FORMAT ME VITRAN VASULI KI SHEET WALE FORMAT ME LEKR AANA H OR USME ACC NO WISE AARANGE KRNA H OR SAME ACCOUNT KI JHA DISURSMENT DATE KI ROW H OR COLL YANI KI VITRAN DATE USKE BAAD KI YA SAME H USI ROW ME ARRANGE KRNA H ...EXE ME GUI DE DO OR 2 SE 3 STEP ME KR DO MAXIMUM BUDGET 2000 RS H OR MUJE30 MIN TO 1 HOOUR ME DE DO

I already run a private AI assistant in-house and now need its answers to come directly from our own material. I have chosen Pinecone as the vector store and will start by loading several Excel spreadsheets that contain operating procedures, KPIs and reference tables. The single most important outcome is lightning-fast information retrieval when staff query the bot; analytics, reports, and other add-ons can wait until phase two. Here’s what I need you to do: • Build a clean ingestion pipeline that takes our Excel files, splits them sensibly (sheet, row or custom logic), converts the text to embeddings, and writes everything to a Pinecone index. • Wire up a basic retrieval function (Python / LangChain or similar) that the chatbot can call, returning the most relevant co...

I have several years’ worth of appraisal data currently scattered across multiple CSV and TXT files. The goal of this project is to collect that raw information, move it into a clean Microsoft Access back-end, and then give me simple, point-and-click ways to work with it every day. Core objectives • Build the Access tables from my existing CSV/TXT files • Design friendly forms so I can review, edit, and manage the records without touching the tables directly • Enable one-click exports that feed the data into Excel, produce mail-merge ready form letters, or create custom on-screen/printable reports Technical notes • Source files are standard comma-delimited and tab-delimited text or other • Front-end can be Access or an Excel interface, as long as it...

Our entire pricing catalogue currently sits in a single Excel workbook, but we have a new CMS system that contains a new spreadsheet structure that will serve as the future-proof version of our pricing system. I need every element moved across—product and service descriptions, image links, materials, equipment, labour rates, and any related look-ups—while reshaping the data to fit the new column order, field names, and calculation logic that lives in our new program. Because the new template differs from the old one, this is more than a simple copy-and-paste job; it calls for significant data transformation. You may need to: • split or merge fields, • convert formulas into more efficient functions, • normalise units and naming conventions, and • ...

**Title:** Need Expert to Create Critical Path Method (CPM) Schedule in Excel for Construction Project **Description:** I’m looking for an experienced construction planning professional who can create a **Critical Path Method (CPM) project schedule** for a construction project using **Microsoft Excel**. The goal is to clearly map the **entire project timeline**, dependencies between activities, and the **estimated completion time for each stage of the project**. **Scope of Work:** • Create a **complete CPM schedule** for a construction project • Provide **activity breakdown (tasks and sub-tasks)** for the project • Show **start date, finish date, duration, and dependencies** for each activity • Identify the **critical path** clearly • Calculate **total p...

I need a robust Excel model that focuses on revenue projections for a short-term rental / Airbnb portfolio. The spreadsheet should let me plug in nightly rates, expected occupancy, and seasonal adjustments so I can see monthly and annual revenue at a glance. Key elements to build in • Seasonal variations – automatic high, shoulder, and low-season multipliers • Occupancy rates – editable assumptions down to individual property, with a summary dashboard • Pricing strategies – side-by-side scenarios for static, dynamic, and minimum-stay pricing Please structure the workbook so I can easily add properties, change assumptions, and export clean PDF reports for investors. Charts that visualise ADR, RevPAR, and total income over time will be helpful, but...

I am putting together a comprehensive inventory-management report that draws on several different raw data sources and I need your help building it in Advance Excel, enhancing it with Macros/VBA automation, and visualising the results in Power BI. Here is what I have in mind. Multiple CSV and spreadsheet feeds will be consolidated, cleaned and reshaped inside Excel. Macros or VBA routines should automate the refresh and mapping process so I can drop new files into a folder and have the workbook update itself without manual intervention. From there, the prepared tables need to flow into a Power BI model that produces an at-a-glance dashboard highlighting current stock levels, inbound and outbound movements, and any exceptions that require action. I will supply sample data so you can design...

Each week I’ll send you a fresh export of our inventory data straight from the ERP. Your job is to turn that raw sheet into an easy-to-digest story in both Excel and Power BI. Here is what I’m after: • In Excel: a cleaned, well-structured workbook with dynamic tables, formulas or Power Query steps that let me drop in the new file and refresh. Pivot tables and slicers should make it effortless for me to drill down by SKU, warehouse and ageing bucket. • In Power BI: an interactive dashboard that mirrors the Excel logic but adds richer visuals—bar charts, pie charts, line graphs and any other view you feel best highlights stock movement, excess, and potential shortages. The report needs to refresh from the same data source I provide and should be easy for me t...

I have several Excel sheets filled with customer information that must be transferred into a single, clean master file right away. The data is already digital—no PDFs or scans—so the job is purely data entry, but accuracy is critical. The master file should mirror the column structure I will share (name, email, phone, address, plus a few custom fields) and come back to me fully deduplicated and spell-checked. I also need basic validation: phone numbers in one format, emails verified as valid, and any obvious gaps highlighted. Because this is time-sensitive, I plan to hand over the spreadsheets as soon as we agree, and I’d like the completed file returned within 24 hours. Speed matters, yet mistakes will slow us both down, so meticulous attention to detail is essential...

I’m looking to have a single, well-structured Excel workbook that lets me stay on top of my raw-materials inventory at a glance. The sheet needs to record every item, its current stock level. Inlcuding stock entry and exit at a complex level. Here’s what I expect from the finished file: • A clean input area where I can add, edit, or deactivate materials without breaking formulas • Automatic stock-on-hand calculations and clear visual cues for low or out-of-stock items • Location fields that accept only valid entries (drop-downs or similar data-validation) so mistakes are minimized • A summary view that aggregates totals and lets me filter or sort by material type, location, or status I’m comfortable updating raw data; what I need is the underlying st...

I have several Excel workbooks that contain strictly numerical information. I need the contents brought to a clean, reliable state and organised so I can run accurate analyses later on. The work involves three clear steps: 1. Data entry & organisation – move or copy the figures into the correct sheets, fields and rows so every value sits where it belongs. 2. Data cleaning & formatting – remove duplicates, fix inconsistent number formats, standardise units and make sure each column is uniformly typed. 3. Data validation & verification – cross-check totals, spot any outliers or obvious entry mistakes and flag anything that does not reconcile. Acceptance criteria: once complete, each workbook should open without errors, every column must contain only the ...

I’m building a new solution whose entire code-base is written in Python, and I’d like an experienced developer to help me take it from concept to a clean, working release. The exact feature set is still flexible, but it will draw on core areas of programming, database design, networking concepts and general system development, so a broad understanding of these disciplines will be valuable. Here’s what I need from you: • Translate the high-level requirements I provide into clear, efficient Python modules. • Advise on and implement an appropriate tech stack—whether that means a lightweight Flask or FastAPI service, a Django web app, a data-driven script, or something else that fits the goals best. • Design or refine database schemas and integrat...

I have an existing Excel workbook that I use for staff rostering. At the moment every step is manual, so I want the entire process wrapped into one push-button VBA routine. When I click the button the macro should: • Allocate each employee to the required shifts • Detect any conflicts such as overlapping hours or breaches of contracted limits • Check every assignment against the applicable awards and internal policies, preventing non-compliant rosters from being published The file is already structured; your job is to build the automation logic, wire it to a clearly labelled button, and return a macro-enabled workbook (.xlsm) that produces the finished roster on demand. Please comment the code so I can maintain it later and include a brief note or screen recording th...

I need an Excel workbook enhanced with VBA that can pull sales data directly from our database, crunch the numbers automatically and present clear, on-demand reports. The focus is pure analysis and reporting—no manual copy-pasting, no repetitive filter steps—just hit a button and the figures are there. Here is what I’m after: • A reliable VBA routine that connects to the database, refreshes the data set, and stores it in well-structured worksheets. • Automated calculations for common sales KPIs—revenue by product and region, period-over-period growth, averages, and any additional measures you suggest that add quick insight. • Polished summary views (pivot tables or a lightweight dashboard) that update whenever the refresh runs, so management can ...

I have an Excel workbook waiting for a fresh set of numeric records. Each figure must be entered exactly as provided—every value is in decimal form—so preserving precision is non-negotiable. Beyond typing, I also need you to run a quick error-check: use whatever light-touch Excel techniques you prefer (COUNTIF, conditional formatting, cross-totals, etc.) to flag blanks, obvious outliers, or mismatches. No elaborate validation rules, just a reliable sanity sweep so I receive a clean, trustworthy sheet. The source file will be in your inbox as soon as we start, and I need the finished workbook back within 48 hours. Accuracy and a sharp eye for inconsistencies are essential; solid experience with Excel data entry will make this task straightforward. Deliverable: • Complet...

I have between 11 and 20 pages of handwritten notes that must be turned into a clean, well-structured Excel workbook. Every figure, label and annotation from the pages needs to appear in the sheet, and a handful of embedded charts sketched in the margins must be rebuilt with Excel’s native chart tools so the file remains fully editable. Accuracy matters more than speed: spelling, numeric values and any units written in the notes must match what I wrote, and the charts should mirror the original scales, series colours and titles. Please keep the workbook tidy—use clear headings, consistent column widths and chart formatting that looks professional. You can use any version of Microsoft Excel for Windows or Mac as long as the final file opens flawlessly in the current 365 releas...

I need a secure Android banking app built from the ground up for Arab Bank. The core scope is clear: users must be able to manage their accounts, transfer funds, and pay bills effortlessly from their phones. To make this happen, I’ll supply API documentation for our core-banking system along with brand guidelines and sample data. Your task is to design and code the full mobile experience—clean UI, solid architecture, and encrypted communication throughout. Performance, accessibility, and regulatory compliance (PCI-DSS level practices) are non-negotiable. Deliverables • Fully functional Android app (latest stable SDK) • Source code in Git, well-commented and neatly structured • UI/UX assets (Figma or similar) • Integration layer that consumes our ...

I have a batch of travel receipts already exported from our expense-management system and need a clean, reliable reconciliation focused solely on traveler names and their respective departments. Amounts, dates, and destinations are handled elsewhere—your task is to make sure every line item carries the correct name-to-department mapping, flag any anomalies, and consolidate everything into a single Excel workbook using a standard reporting layout. You will receive: • The raw spreadsheet dump from the system (CSV and XLSX) • A short reference list of approved traveler names and department codes What I expect back: • A reconciled Excel file in the usual columnar, easy-to-filter format • Clear highlights or comments for any mismatched or missing name/department pair...

The objective of this project is to analyze UPI transaction data to understand transaction trends, user behavior, payment methods, and failure rates. The dashboard helps identify patterns in digital payments and supports better financial decision-making. Tools & Technologies Used Power BI – Data visualization and dashboard creation Microsoft Excel / CSV – Data storage and preprocessing Data Cleaning & Transformation – Handling missing values and formatting data The dataset contains information about UPI transactions, including: Transaction Time Transaction Amount Payment Method (UPI ID, QR Code, Phone Number) Device Type (Mobile, Laptop, Tablet) Transaction Status (Successful / Failed) Transaction Purpose (Bill Payment, Food, Others) Age Group Gender

I manage recurring financial data and want everything captured, calculated, and summarised inside one easy-to-use workbook. The flow is straightforward: enter raw figures once, let Excel handle the math, and finish with a clear monthly report I can share with management. Core requirements • Data entry sheet – clean layout, protected formulas, drop-downs or data validation where sensible so typing errors are minimal. • Automated calculations – built-in formulas (and, if helpful, a lightweight VBA macro) to deliver running sums, averages, trend analysis, and cost-projection figures the moment new numbers are added. • Monthly summary – a separate tab that refreshes automatically, showing key KPIs, charts or tables that pull directly from the live data; re...

I manage recurring financial data and want everything captured, calculated, and summarised inside one easy-to-use workbook. The flow is straightforward: enter raw figures once, let Excel handle the math, and finish with a clear monthly report I can share with management. Core requirements • Data entry sheet – clean layout, protected formulas, drop-downs or data validation where sensible so typing errors are minimal. • Automated calculations – built-in formulas (and, if helpful, a lightweight VBA macro) to deliver running sums, averages, trend analysis, and cost-projection figures the moment new numbers are added. • Monthly summary – a separate tab that refreshes automatically, showing key KPIs, charts or tables that pull directly from the live data; re...

I need to take data from 2-3 spreadsheets and create different reports.

I’m halfway through a Power BI report and need an expert hand to finish the data-modeling side. All source data arrives as clean CSV files, each holding coordinate pairs alongside several lookup fields. Here’s what’s left to do: • Write DAX (or Power Query M if you prefer) that calculates the Euclidean distance between two coordinate columns in each row. • Build proper one-to-many relationships so my fact table links cleanly to the lookups. • Implement value-based filtering so end-users can slice results by numerical thresholds rather than dates or categories. I will share the PBIX, the raw CSVs, and a short explainer video that walks through the current model. Feel free to add supporting tables, custom measures, or quick visuals that prove each form...

Our trout club keeps a running census of everything from monthly fish counts to member participation, but the sheet has started to feel messy and outdated. I’m looking for someone who can jump in, identify the best way to work with the file—whether it turns out to be Excel, Google Sheets, or even a PDF—and then bring it up to standard. What I need done: • Update all existing data entries, including fish counts, member details, date-and-time logs, and a small set of non-fishing notes. • Correct typos, inconsistent labels, and any formatting hiccups that make the sheet hard to read or sort. • Add a few new columns so we can track extra metrics for upcoming seasons, then relocate certain sections to make the layout intuitive. You’ll have the freed...

I have a set of weekly-refreshed sales figures that I want to explore in depth through a single, well-structured Excel workbook built around Power Pivot. The file must let me load new data each week, refresh the model with one click, and instantly see the impact across all reports. Here is what I need you to put in place: • Robust Power Pivot data model that ingests my raw sales tables and maintains clean relationships • Import and export routines (ideally via Power Query) so I can pull in CSV files and, when required, push summarized data back out • A suite of advanced DAX calculations: period-over-period growth, cumulative totals, top-N products, regional contribution, and any other metrics that help reveal trends • Interactive visualizations—charts, sli...

Projet : Automatisation de la Conception de Guides Genou 3D Ce projet vise à automatiser plusieurs étapes critiques du flux de traitement d'un cas de genou 3D, spécifiquement axé sur la conception de guides orthopédiques. L'objectif principal est de réduire la variabilité, d'améliorer la robustesse, d'accélérer les délais et de minimiser les erreurs humaines. Les défis incluent la gestion de différents formats de fichiers (STL, SLDPRT), la création de géométries de référence spécifiques à chaque client, l'assemblage précis de pièces, la conception paramétrique de guides, l'application d'inscript...

I already have an Excel system with a Measurement Sheet (input) and Dashboard. I need a small automation to generate an RA Bill sheet automatically from the measurement data. Requirement: RA Bill should be generated automatically based on the selected RA number. Each Item No. should appear as a heading with its BOQ description. Under each item, the measurement rows should appear automatically from the Measurement Sheet. The table should have these columns: Description | Unit | N1 | N2 | Length | Width | Depth | Qty The Description column should show location/sub-item from the measurement sheet. When entries for the same Item No. end, the system should automatically show Total Quantity. After the total row, the next Item No. section should start automatically. The number of rows under each ...

I’m looking for an expert who can install the necessary components for automating and scripting workflows between Excel and OneNote, then walk me through how everything works. My priority is getting the automation up and running smoothly, followed by clear, hands-on training so I can maintain or adjust it myself later. Deliverables • Fully installed and configured automation solution connecting Excel and OneNote • Live training session(s) showing how to run, modify, and troubleshoot the scripts • Quick-reference documentation or a short recording summarising the key steps and best practices If you’ve built similar Excel-to-OneNote automations before and enjoy teaching, I’d love to hear how you would approach the setup and training.

I need a straightforward, low-overhead way to keep my small clinic organised. The solution can be a well-structured Microsoft Excel workbook (with formulas or VBA) or a lightweight standalone program—whichever you feel will deliver speed and reliability without forcing us into a steep learning curve. Core functions • Patient appointment scheduling presented in an intuitive daily calendar view—simple drag-or-drop or dropdown rescheduling is ideal. • A unified medical record section that stores and lets me update basic patient information, treatment history and current / past medication records in just a few clicks. Essential workflow features – Quick patient search by name or ID. – One-page printable visit summary. – Automatic backup o...

I need a clean, easy-to-maintain Excel workbook that lets me log and review all of my financial activity in one place. The file should focus on tracking income and expenses only—there’s no need for full budget planning tools or tax worksheets at this stage. What matters most to me is clarity and automation. I want to open the sheet, enter a transaction, and instantly see updated totals, category breakdowns, and a running balance. Well-labeled tabs, drop-down categories, and built-in formulas or pivot tables that summarise monthly and yearly figures will make the book truly useful. A simple dashboard or summary page that highlights key metrics such as total revenue, total outgoings, and net position would be a plus. Deliverables • An unlocked Excel workbook (.xlsx) ...

I need a clean, easy-to-maintain Excel workbook that lets me log and review all of my financial activity in one place. The file should focus on tracking income and expenses only—there’s no need for full budget planning tools or tax worksheets at this stage. What matters most to me is clarity and automation. I want to open the sheet, enter a transaction, and instantly see updated totals, category breakdowns, and a running balance. Well-labeled tabs, drop-down categories, and built-in formulas or pivot tables that summarise monthly and yearly figures will make the book truly useful. A simple dashboard or summary page that highlights key metrics such as total revenue, total outgoings, and net position would be a plus. Deliverables • An unlocked Excel workbook (.xlsx) ...

All of our production figures are already captured in a single Excel workbook; what I need now is a clear, interactive dashboard that turns those raw rows into insight. The layout should feature bar charts, pie charts, and line graphs so supervisors can see at a glance where we stand. Key metrics are straightforward—total production volume and accumulated downtime—updated automatically each day as fresh data is entered. The solution must sit entirely inside Excel (Power Query, PivotTables, dynamic arrays, or light VBA—use whichever combination keeps the file fast and maintenance-friendly). A single click refresh is plenty; real-time streaming is not required. Deliverables • One dashboard tab with the visualisations laid out cleanly for shop-floor display • A...

I want to make education video of history for competitive exams in way of cinematic story telling with visuals ,map animations and AI character talking . For that I have to make 20-25 videos each of length 30 minute