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...

I will turn your raw business data into a clean, reliable model and then build a modern Power BI—or, if you prefer, Excel—dashboard around it. Using SQL and Power Query I’ll handle the full preparation pipeline so every refresh runs automatically. The finished dashboard will surface your key sales, order, and performance indicators through intuitive charts, drill-through views, and slicers that non-technical users can explore with confidence. Colour palette, fonts, and layout will match your brand, and advanced filters will let you zero in on any segment or period in seconds. Deliverables • PBIX (or XLSX) file with documented queries and DAX formulas • Fully interactive report pages, mobile-friendly layout included • One-click refresh connection t...

I need an engaging trainer who can take absolute beginners through the fundamentals of data analysis in a series of online live sessions. The audience has no prior experience, so the material needs to start from scratch—explaining core concepts, demonstrating workflows step by step, and giving plenty of hands-on practice. We will meet over a video-conferencing platform (Zoom or similar) at agreed times. I expect you to bring a clear syllabus, lively examples drawn from real datasets, and interactive exercises that let participants follow along on their own machines. Recordings of each session, slide decks, and any code or spreadsheet templates you use should be shared afterward so the group can review. By the end of the program, participants should comfortably import raw data, perf...

Create an MS Excel add-in that lets me pull raw tables straight from ERP and excel files, clean the data, explore it visually, and push out polished, reusable reports—all without leaving the Excel worksheet. Core functionality I need built in: • Connectivity to ERP tables (ODBC or API—whichever suits Excel best) so a user can browse available tables, apply simple filters, and load the data into a sheet with one click. • Data-cleaning helpers that detect blanks, duplicates, and obvious outliers, then offer quick fixes or flag rows for review. • A visual exploration panel for instant charts and other data-visualization tools so users can slice the imported data on the fly. • A custom report builder where predefined templates pull refreshed figures a...

We are seeking a dedicated and experienced Punjabi language tutor for online lessons. The ideal tutor should be fluent in Punjabi (spoken and written) and able to teach grammar, vocabulary, pronunciation, and conversational skills in a clear and engaging way. Prior teaching experience and a structured approach to lessons are preferred. Requirements: • Strong command of Punjabi • Ability to teach online via video platforms (Zoom, Google Meet, etc.) • Patience and good communication skills • Flexible scheduling options If you are passionate about teaching Punjabi and can provide interactive, personalized lessons, please reach out with your details, availability, and teaching approach.

I’m putting together a personal-finance coaching workbook and need an Excel expert to turn my outline into a polished, user-friendly file. The core of the job is a 12-month layout (January through December) with a clear yearly dashboard that automatically rolls up every figure. Users will open this file on Excel for Office 365 and Excel Online, so every formula, table, and link has to behave perfectly in those environments and display well on phones as well as desktops. Each monthly sheet should include sections for Income (broken down into Salary/Wages, Investments, and Other Income), Expenses, and an at-a-glance Net Total. All totals must flow up to the summary page without complicated array formulas or VBA; simple SUM, SUMIF/SUMIFS, and basic links are fine so clients can audit o...

I need multiple Excel spreadsheets brought together into one clean, automated workbook that updates itself and delivers clear reporting and analysis. The source files hold similar data structures, so the key tasks are to merge them reliably, build VBA macros to refresh the data with one click, and present the consolidated figures in easy-to-read summary sheets. What success looks like • A single master file that pulls from all current and future source sheets without breaking existing formulas • Automated macros that handle data import, de-duplication, and error checking • Well-formatted summary tabs that give me instant insights instead of manual copy-paste work When you reply, focus on the experience you have building comparable Excel solutions—particu...

I want to convert my current Excel file into a simple fleet management system for our bus operations. Right now we are creating a separate sheet for every day’s collection. Instead of that, I want a better structure where we only enter the daily data once and all reports are generated automatically. The system should have one main sheet called DATA ENTRY where we enter the following columns: Date Route No Bus No Driver Conductor Total Collection RFID Collection HSD Litres (diesel filled) Expense From this data Excel should automatically calculate: HSD Cost = HSD Litres × Diesel Rate (currently ₹91) Net Collection = Total Collection − Expense If Net Collection becomes negative, it should automatically appear in red. From the DATA ENTRY sheet I want Excel to automati...

I need a small sales dataset reorganized into a clean, easy-to-read spreadsheet in Excel. After tidying the raw data into a proper table, create a concise summary that highlights total sales—this is the key metric I want front and center. Add a straightforward bar chart so I can see performance at a glance. To succeed, you should be comfortable structuring data in Excel, using formulas to pull totals, and inserting clear, well-labeled charts. The finished file should open to a sheet that immediately shows: • A neatly formatted data table • A summary block with total sales clearly displayed • One bar chart visualizing the figures Keep the layout simple and professional; clarity is more important than complexity. When you’re done, deliver the single Excel ...

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 have an existing Excel workbook that currently requires manual input of addition, subtraction, multiplication, and division formulas across several sheets. I need these basic arithmetic operations to run automatically as soon as new rows of data are entered, so totals, variances, and ratios update instantly without any further action from me. Please build the automation directly inside the file—VBA, dynamic array formulas, or another native Excel approach is fine as long as it works on both Windows and macOS versions of Office 365 without additional add-ins. Once complete I should be able to drop fresh data into the designated columns and see every calculated field refresh correctly. Deliverables • The updated workbook with the automation in place • A short note...

I need two small Windows utilities built as stand-alone .exe files, each with a simple point-and-click interface (no command line). Utility 1 – Excel-to-Excel re-formatter • I will pass you a source workbook and the target layout “ERP_CONVERTED_2”. • The tool must map every column exactly into that layout, then sort the sheet so that, within each Account No, the Disbursement dates appear first (oldest-to-newest) followed immediately by the corresponding Collection dates. • Finally, the macro should generate a second sheet in the same file called “VITRAN VASULI” that shows a dropdown-driven view arranged Account-wise in the same row order (Disbursement row first, Collection row next or combined when dates match). Utility 2 – PDF-to-...

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;...

Project Title: Excel Spreadsheet – Builder Retention Tracking I run a commercial plumbing business in Australia and need an Excel spreadsheet built to track builder retentions across multiple projects. In construction, builders typically hold 5% retention from the contract value. Usually 50% is released at practical completion and the remaining 50% after the defects liability period (typically 12 months). The spreadsheet needs to help us track how much retention is being held, when it should be released, and highlight when payments are overdue. Main Sheet – Retention Register Each row will represent one project. Columns required: Project Number Project Name Builder / Client Contract Value Retention % Total Retention Held (auto calculation) Practical Completion Date...

I need the AIA G702 and G703 application for payment documents recreated in Excel. The final product should be an Excel spreadsheet with custom formulas or calculations as needed. Requirements: - Recreate AIA G702 G703 documents - Deliver as Excel spreadsheets - Include custom formulas as required Ideal Skills and Experience: - Familiarity with AIA documents, particularly G702 and G703 - Proficiency in Excel, especially with custom formulas - Attention to detail and accuracy

I have a batch of information that needs to be keyed in quickly and without errors. The source material and final format are both straightforward, yet I’ll confirm the exact details with you once we connect—whether the records arrive as scans, handwritten pages, or an online pull, the goal remains the same: a clean, organised dataset ready for immediate use. I’m comfortable if you prefer working in Microsoft Excel, Google Sheets, or a lightweight bespoke tool; what matters to me is consistency, correct formatting, and zero duplication. Please let me know your usual turnaround time and the quality-control steps you follow so I’m confident the finished file will be reliable from day one.

I have two bed rooms i need 3d and 3d drawings for excellent looking

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 need an Excel macro that searches for whole numbers throughout the entire workbook and copies them to another sheet. Requirements: - Search for whole numbers - Operate on the entire workbook - Copy found numbers to a designated sheet - Editable for adding more search criteria

I have a backlog of records that contain both short text descriptions and corresponding numerical figures. They must be transferred quickly and flawlessly into a structured spreadsheet (Excel or Google Sheets is fine) so I can move ahead with analysis straight away. Accuracy is critical—text must be copied exactly as written, numbers must keep their original formatting, and every entry needs to land in the correct column. I will supply the source files and a template with clearly labeled fields the moment we start; I simply need the completed sheet returned, error-free and ready for use, as soon as you can turn it around. If you have a sharp eye for detail, solid data-handling skills, and the bandwidth to begin immediately, let’s get this finished today.

I need a reliable, easy-to-update forecast for medication supplies that tells me two things at a glance: how much stock I will need and when each batch will expire. I already have partial historical demand figures that you can build on; what I lack is a clean, formula-driven model that projects future requirements with confidence. Please use Excel or Google Sheets—whichever you feel gives the clearest, most maintainable formulas. The sheet should automatically pull forward the remaining stock, apply average or weighted consumption rates from my partial data, flag upcoming expiries, and highlight any shortfalls before they happen. If there’s a smarter way to visualise this, feel free to include a dashboard, but the core deliverable is the working set of formulas. Acceptance cr...

I need a simple Excel program to track customer scoring daily for a calendar month. Requirements: - Track customer scoring (1-100%) for each day - Manual data entry - Include graphs/charts for data visualization Ideal Skills: - Proficient in Excel - Experience with data visualization in Excel

I need a quick Power Automate flow that takes specific information arriving in Outlook and drops it into a separate Excel workbook, matching the first line of the body of the email with the name on the spreadsheet, and inputting a YES on a third column if the names match. The sole purpose is to remove manual data entry, so the flow only has to watch a dedicated folder, parse the required fields from each message, and append them to the target spreadsheet stored in OneDrive or SharePoint. The logic should be straightforward: • Trigger: email already stored in the outlook Outlook folder • Action: extract the client name • Destination: enter a "yes" in a new column if the extracted name matches the name present on the spreadsheet The complexity lays in the way th...

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 ...

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

see the attached excel dashboard I need the followings: Combine the Address book and task list with following fields: Customer, Contact Person, Phone, Email, Account Manager, Status, Long description. Rename Process Pipeline to Quote Pipeline with the following fields: Quote Type (Active, Expiring), Status (Won, Lost), Reason for Loss

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...