ビジュアルベーシック Jobs

I have id information in excel spreadsheet need to gather evidence for those ids from one portal and save the evidence (screenshot) in share folder

I'm looking for an AutoIt script fo manual photo comparisons using two side-by-side windows with FastStone Image Viewer. Requirements: - Switch focus between the windows - Drive each window to the same photo - User manually inputs if photos are equal or not, if not - automatically move unequal photos to a specified sub-directory (pre-manual setup in FastStone viewer) - Launch and Setup of windows manual, AutoIt script gets values from .ini file. Ideal Skills and Experience: - Proficient in AutoIt scripting - Experience with window manipulation and automation - Familiarity with photo handling and directory management

I have a collection of single-column scanned text documents that I need converted into a clean, fully searchable Excel file. The pages are almost entirely typed, but a handful contain small handwritten notes that must be captured as well. Your task is to run accurate OCR, transfer every line of typed text into logically structured spreadsheet columns, and add the handwritten snippets in a separate field or clearly mark them so I can review later. No fancy layout reproduction is necessary—clarity and searchability are what matter. Deliverables • One Excel workbook containing all extracted text, ready for filtering and formulas • Handwritten content entered or flagged in its own column • A quick quality check to ensure the spreadsheet matches the source scans Plea...

I have several Excel workbooks that already contain raw customer information, but they’re scattered across different tabs and follow no consistent structure. I need someone to consolidate every record into a single, clean master sheet, standardise the column headers, and ensure all values (names, phone numbers, email addresses, addresses, etc.) are formatted uniformly. Accuracy is critical, so I will be checking for duplicates and incomplete fields. You are free to rely on functions such as VLOOKUP/XLOOKUP, Power Query, or pivot tools—whatever speeds up the process without compromising quality. When you finish, I expect one tidy .xlsx file ready for import into our CRM plus a short note outlining any assumptions, data issues you encountered, and how you resolved them. If th...

I’m sitting on a sizeable customer-data workbook and need a sharp pair of hands to turn it into something clean, consistent, and instantly insightful—all within Excel. Here’s what I’m looking for you to do: • Data cleaning and organizing: remove duplicates, fix inconsistent labels, standardise formats, and flag any obvious outliers. • Pivot tables and charts: build dynamic pivots that let me slice results by region, segment, and purchase date, then link them to clear, presentation-ready charts. • Advanced formula implementation: craft robust formulas (INDEX-MATCH, SUMIFS, array functions, whatever is best) so key metrics update automatically when I drop in fresh data. Everything should stay inside one well-structured workbook with named ranges, ...

I have several CSV files—course lists (with numbers, requisites, labs and any concurrent pairings), faculty-preference forms in Excel, student-preference forms in Excel, and a record of which courses each instructor has previously taught. From those inputs I need a standalone scheduling tool that will: • read the CSVs directly (no manual re-formatting) • assign flexible time slots and days to every course, pairing each section with a qualified instructor such that each instructor either teach Mon/Wed or Sun/Tue/Thur but not both. • export the finished timetable as a single CSV laid out exactly like the sample I will share, showing day, start/end time, and instructor name • automatically flag overloads (any instructor teaching more than two courses) and anyone...

I need a set of automated dashboards in Google Sheets that continuously pulls data from our recurring CSV exports and turns it into a live view of company performance. The two figures I must see at a glance are Revenue and Net Profit, with the option to slice by product line and date once the basics are stable. Here is what the finished workbook should let me do: • Drop the latest CSVs into Drive and watch the data model update without manual copy-pasting. • View clean, interactive charts and tables that refresh on schedule or at the click of a button. • Export or share the P&L dashboard with teammates while keeping formulas locked down. Please build whichever mix of formulas, pivot tables, named ranges, or Apps Script you feel is best to keep refresh times f...

I have a collection of paper-based reports filled with numerical figures that I need captured accurately in a clean, well-structured Excel workbook. Your task is straightforward: read each sheet, key every number into the correct columns and rows I will provide, double-check totals as you go, and flag any values that are unclear or illegible so I can review them later. The final Excel file must mirror the original layout, preserve any subtotals or grand totals, and be free of transcription errors. I will scan and share the documents as high-resolution PDFs; you simply return the completed spreadsheet plus a brief note of any issues you encountered. Attention to detail and solid Excel skills are essential because these figures feed directly into our monthly reporting. If you have experien...

i want to create MS Access database sheet requirement database not to big or hard Database Requirement Explanation I belong to the Indian Army. My unit has a strength of approximately 445 personnel. Every year, individuals remain embodied (on service) and disembodied (service break) for varying periods, usually ranging from 1 to 4 months at a time. I want to create a database (preferably in MS Access) where each individual has a separate profile, and all service periods are calculated automatically. ⸻ Individual Profile Requirements Each individual profile should contain: • Army Number • Rank • Name • Date of Enrollment Example: Army No: 1245 Rank: Sepoy Name: Pankaj Date of Enrollment: 01 Dec 2015 ⸻ Embodiment / Disembodiment Logic For each individual, there can be m...

I have several Excel workbooks that need to start running themselves today. The goal is simple: turn my manual, time-consuming routines into push-button macros. The focus is on two areas: • Generating polished, ready-to-send reports from raw sheets • Cleaning and transforming data so downstream formulas, pivots, and dashboards work flawlessly Everything sits in Microsoft Excel and must be handled entirely with VBA. No add-ins or external tools are required—just clean, well-commented VBA modules that I can maintain later. I will provide the current files and a quick walkthrough of the reporting logic and data issues. From there, I need: 1. A single workbook (or a small set, if separation makes sense) containing fully automated procedures. 2. Clear triggers&mda...

I’m consolidating a collection of product details that currently live in multiple Excel sheets. Before these records move into our live system, they must be entered accurately and made analytics-ready. Here’s what has to happen: • Data cleaning & verification – detect typos, duplicate SKUs, or incomplete attribute fields and correct them. • Formatting & organizing – structure columns uniformly, apply consistent naming conventions, and ensure every record aligns with our template so the import runs smoothly. • Analysis & reporting – once the file is clean, generate a brief summary (e.g., item counts per category, missing image percentages) so I can validate data health at a glance. The final hand-off will include the clean...

I already have a working Microsoft Access file that stores classes, participants, teachers and hosts for our school-trip programme. What I need now is a set of practical refinements that will let our office staff spend less time wrestling with data and more time focusing on the children. 1. Improved data-entry and registration forms • One clean form for new trip registrations that captures student details, emergency contacts and essential medical information in a logical flow. • Auto-fill and look-ups wherever possible so teachers are not re-typing the same names or addresses each term. • A printable version of this form that doubles as the parental consent sheet. 2. Advanced reporting & export tools • A ready-to-print registration/attendance l...

I’m looking for an experienced spreadsheet designer to create a clean, modern, and easy-to-use fitness & weight loss tracker in Excel or Google Sheets. The design should be simple, beginner-friendly, and visually appealing — not overly complicated or cluttered. Think clean layout, soft aesthetic, organized structure. Required Pages: Goal Setup Page Current weight Goal weight Goal date Basic automatic calculations Weight Log Date Weight Progress tracking Simple trend chart Dashboard Overview of progress Clean, easy-to-read chart Summary metrics Workout Tracker Date Exercise Sets / Reps / Weight Habit Tracker 30-day layout Simple completion tracking Monthly Progress Summary Important: Must work well on desktop and mobile Clean formatting Automated ...

I need an Excel worksheet for monthly billing at my personal training studio. The worksheet should clearly display: - Client names - Services offered: Personal training sessions and group classes - Fixed cost per service - An option to apply credits Ideal skills and experience: - Proficient in Excel - Experience with billing or invoicing systems - Attention to detail and accuracy

I have a stack of paper documents that contain both text and numerical information. I need every line carefully transcribed and organised into a clean, well-structured Excel spreadsheet. Please keep the original order of the records, label the columns clearly, and double-check totals or calculations so the numbers match exactly what appears on the page. Accuracy and legibility are more important to me than speed, but I would like regular updates so I can spot-check your work as we go. Once complete, I expect a single .xlsx file that is ready for analysis with no stray characters or formatting issues.

We are looking for an experienced Excel automation specialist to help connect two existing Excel workbooks used in a digital media workflow: Traffic Sheet Workbook (placement-level trafficking instructions) CMW (Creative Specs) Workbook (creative details: ad names, rotation %, flight dates, etc.) Currently, these documents are separate and require manual copy/paste of data (e.g., ad names, rotation values, creative flights). We would like to implement a reliable, maintainable way for the Traffic Sheet to automatically pull select fields from the CMW. This is not a redesign of the documents — it is a structured automation enhancement. Current State CMW workbook contains multiple tabs: Standard Display Custom Units Video Audio Traffic sheet is placement-based (one row per placement...

I’m looking for an experienced Microsoft Copilot / Power Automate to help me build an end-to-end productivity automation system. The objective is to automate customer escalations, MIS reporting, fraud detection, growth analysis, email workflows, and PowerPoint creation using the Microsoft ecosystem + Copilot. ⚠️ Important: This project is time-critical and needs to be completed within this week, as all required data, formats, and inputs are already available. ⸻ Timeline (Critical) • Start: Immediately • Completion: Within 5 days ⸻ Scope of Work 1. Automated Customer Escalation Replies • Auto-reply to customer escalation emails with personalized responses • Replies based on: • Standard predefined issue types • Error screenshots attached by...

I need a sma vab in Microstation which I've started, just need add in a specific shape which I have dimensions and will need to be placedat end of line it creates but shape needs always rotate based on line. And then we need to allow to b offset shape by distance define by user and creates a copy with option to be included box

I’m looking for a skilled Excel Data Analyst to clean, organize, and analyze a sales dataset. The data is available in Excel format but requires proper structuring and detailed analysis to generate meaningful insights. Scope of work includes: - Cleaning and organizing raw sales data - Removing duplicates and correcting inconsistencies - Creating summary reports (sales by product, region, date, etc.) - Identifying trends, top-performing products, and key revenue drivers - Building pivot tables, charts, and a simple dashboard Strong proficiency in Excel (advanced formulas, pivot tables, and data visualization) is required. Please share examples of similar sales analysis projects you’ve completed.

I have seven divorce-case billing statements from my lawyer, and I need them consolidated into a single Microsoft Excel workbook that makes every inconsistency jump out at a glance. Your job is to import each statement onto its own tab, then build an analysis sheet that automatically flags: • Overcharged hours • Duplicate charges • Unusual expenses • Fraudulent billing Smart use of formulas, conditional formatting, and (if helpful) pivot tables should let me see where each new statement differs from the last and exactly how the totals shift over time. Please structure the workbook so I can drop in any additional statements later and have the discrepancy calculations update without extra work. Deliverables 1. One Excel file (.xlsx) containing: &nd...

I need a set of Excel sheets purpose-built for handling quotations. I’ll be typing in quotation details rather than running extensive analyses, so the layout has to make entering text, line items and basic figures quick and error-free. Here’s what matters to me: • A clean, intuitive structure where I can add or remove rows without breaking any formulas. • Logical sections for item description, quantity, price and total so the sheet doubles as a professional-looking quote I can send to clients. • Basic formulas that automatically extend when new lines are added, plus a final summary field that clearly shows the grand total. • Print- and PDF-friendly formatting. I’ll share a small sample of the data I’ll be entering and I’m happy to ...

I maintain a detailed tracker in Google Sheets (exportable to Excel) that now requires a tidy, professional refresh. The core file already exists; I simply need a skilled pair of hands to: • insert new records that have accumulated since our last update • clean and correct a few legacy rows where the data no longer matches source information • refine or extend formulas so totals, variance calculations, and date-driven reminders run automatically If you are comfortable adding light visual aids—quick charts, pivot summaries, or well-targeted conditional-formatting rules—that would be a welcome bonus, but the first priority is rock-solid data accuracy. Please be ready to work directly in Google Sheets, mirror the changes in an .xlsx copy, and leave concise ...

I have a paper-based form that I now need recreated as a fully editable Word (.docx) file. All of the wording, a few small images (logos) and several simple tables will come from me; what I need from you is the layout magic so the finished document mirrors my reference form exactly. Key points: • Follow the reference form’s fonts, spacing, headings and overall visual hierarchy so users recognise it instantly. • Build the document with properly formatted text styles, embedded images and cleanly aligned tables. • Add editable form fields (text boxes, date pickers, checkboxes, etc.) so staff can fill it out on screen, yet be able to print a clean hard copy when required. No macros or code—native Word features only. Deliverable: • A polished, print-ready a...

I’m looking for a sleek, easy-to-read dashboard that turns my financial data into clear revenue insights. You’ll start with a spreadsheet (or database connection, if you prefer) that contains historical revenue broken down by month, product line, and region. From there, I want an interactive visual that highlights total revenue, month-over-month and year-over-year changes, plus a simple trend line. An optional alert for any dip greater than 10 % would be a nice touch. I’m flexible on the platform—Power BI, Tableau, or Google Data Studio all work as long as I can refresh the figures without fuss. Once we kick off, I’ll supply sample data and branding colours so you can match the look and feel to the company style. Deliverables: • Fully functional dashboa...

Saya membutuhkan lulusan SMK Akuntansi yang teliti, jujur, dan sudah memahami dasar‐dasar laporan keuangan untuk membantu saya mengelola pembukuan sehari-hari menggunakan spreadsheet Excel. Lingkup pekerjaan: • Membuat dan menjaga file Excel yang merangkum pendapatan serta pengeluaran bisnis. • Memasukkan transaksi baru secara rutin, memverifikasi kelengkapan bukti, dan menata kategori akun agar rapi. • Menyiapkan rekap bulanan sederhana yang menampilkan arus kas dan saldo akhir, sehingga mudah saya pahami. Saya sudah memiliki sebagian data dan format dasar; Anda dipersilakan menyempurnakan struktur tabel, rumus, atau pivot sesuai kebutuhan agar hasil mudah dibaca dan minim kesalahan. Konsistensi, ketepatan angka, serta kerahasiaan informasi sangat saya utamakan....

I have a collection of customer information that must be organised accurately in Excel. Your job is to take the raw details I provide—names, contact numbers, email addresses, and any extra fields I specify—and enter them into a clean, well-structured spreadsheet. The spreadsheet has to follow the column layout I give you, preserve exact spelling, and avoid duplicate records. I will share the source files in batches; each batch should be completed and sent back for a quick review before you move on to the next. I value precision over speed, but I still need a reasonable turnaround so my own workflow isn’t delayed. If you are comfortable handling typical Excel functions—data validation, basic formatting, and simple filtering—that will help keep the file consis...

I need a well-structured MIS report in Excel that focuses solely on employee attendance. I will supply raw time-in/time-out sheets; what I’m looking for is a clean workbook that transforms that data into meaningful insights—daily, weekly, and monthly views, absence summaries, and any red-flag trends you feel would help management act quickly. Please rely on solid Excel techniques—pivot tables, lookup formulas, conditional formatting, perhaps a touch of Power Query if it speeds refresh. The final file should be plug-and-play: I drop new data into an “Input” sheet and every metric updates automatically, no extra tweaking. Deliverables • One unlocked Excel workbook containing the MIS attendance report • Brief notes inside the file (or a single-pag...

I have a raw file of purely numeric values that must be transferred into a fresh Google Sheet, checked for accuracy, and prepared for ongoing use. Every figure has to land in the correct row and column, so careful data entry is the first step. Next, I need automatic protection against future typos: please set up Data Validation rules on each numeric column so anything outside the accepted number format is immediately rejected. All true outliers—values that clearly sit outside the natural distribution—should trigger an “Issues” flag in a separate column. I do not need threshold checks; only statistical outliers matter here. When everything is in place, give me a concise report that highlights every anomaly you discovered. Pair a written explanation with a f...

Every event that I have, I take an average of 30 event orders, pull them apart and chronologically construct a production plan for moving in and setting up an event and moving it out at the end of the event. I would like to drop a text-based Event Order PDF into a dedicated local folder. The moment that file lands, I need an agent to wake up, read the document, and do three things automatically: 1. Pull out the essentials—event dates and times, the title of each order, and the Event Order Number. 2. Duplicate each order so it appears "chronologically" twice in the output: once for the install date and once again for the strike / move-out date. 3. Feed all rows into a single, combined Excel sheet that becomes my Production Plan (this is already formatted and I can send...

I’d like a detailed, realistic pencil rendering of a woman’s upper body, semi-nude, to be created from a specific pose I already have in mind. As soon as we open a dialogue I will share the reference photo so you can capture the exact posture, lighting, and expression I’m after. The piece will ultimately hang in her place in Medellín, so it needs to feel refined enough for display: clean graphite tones, subtle shading transitions, and a confident line that preserves anatomical accuracy without overworking the paper. Traditional graphite on quality drawing stock is preferred, though I’m open to your usual materials if they achieve a similarly crisp result. Deliverables • High-resolution scan (300 dpi or higher) suitable for archival printing - NO &bul...

Help provide a analysis on the commercial side

I have a raw sales dataset sitting in Excel and need it reshaped into clear, insightful pivot tables that let me track sales trends at a glance. The goal is to transform the sheet so I can slice results by time period, product line, region, or any other meaningful field, then spot upward or downward movements without manual filtering every week. What I’ll hand over: • A clean Excel workbook containing all transactional sales records. What I expect back: • One or more well-structured pivot tables designed specifically for trend tracking. • Any supporting formulas or helper columns you create, kept within the same file and clearly labeled. • Brief notes (a few lines inside the sheet or a separate tab) explaining how to refresh or expand the analysis when new s...

I need a single-file Excel dashboard that lets me monitor revenue and expenses alongside overall profit-and-loss performance, then projects those figures forward with clear, reliable forecasts. The workbook should pull raw data from one or more clean tables, refresh at the click of a button, and display the key numbers through interactive charts, slicers or drop-downs so I can drill down by month, quarter and year. A dedicated section for predictive analytics—using built-in Forecast Sheet, Power Query/Power Pivot, or another proven method you prefer—should show at least a 12-month outlook with confidence intervals highlighted. Deliverables • Finished .xlsx file, no external add-ins required • Documentation tab outlining data layout, formulas or DAX measures,...

I need an .xlsm workbook whose VBA macro fetches product data from both and lowes.com. When I type a valid item or model number into a row, the code should automatically pull back: product name, full description, regular price, sale price (if available), brand, product type/category, and the main image (inserted into the sheet or stored in an Image column). I work comfortably with VBA, so a concise, well-commented routine is all I need—no step-by-step user guide. The workbook must stay self-contained, relying only on standard references such as Microsoft XML, HTML, or WinHTTP libraries; please avoid external add-ins or Python bridges. Deliverables: • Finished macro-enabled Excel file (.xlsm) ready to test with my own SKU list • Clearly commented VBA code so I can...

I have an Excel workbook that already runs several VBA macros. Right now I need an extra routine added that, at the click of a button, builds an automated report containing clear graphs and charts drawn from the data that the existing code produces. Timing is tight—I will be online for the next two to three hours and would like to screenshare while you code so we can iterate quickly. Scope of the mini-upgrade • Insert a new sub or function into the current module stack that gathers the daily results, drops them onto a neatly formatted “Report” sheet, and then creates the required charts (line and bar are fine; feel free to suggest better visuals if you see fit). • Ensure the macro runs smoothly on both Office 365 and Excel 2016, without touching the pe...

I need a Power BI or custom app to create a workflow dashboard based on my existing process map. I am not sure whether an App or Power Bi is better? Essentially we want to track the duties of the 4 dutyholders under the building safety act. Client, Designer, Principal designer and the designer. The client will just see the summary dashboard with all the headlines... I have added some workflows to the files section with my initial thoughts. We will need some work to also build the trackers in the background. Most of mine is in either excell or word declarations etc.. Requirements: - Use Excel files as data sources. - Include interactive charts and graphs. - Generate summary reports. - Provide real-time data updates. Ideal skills and experience: - Proficiency in Power BI or app developmen...

I’m looking to streamline the way I track stock levels by turning a series of existing internal spreadsheets into a single, button-driven inventory report. Right now, the data sits in multiple Excel files that are updated daily by different team members; what I need is a routine—whether VBA macros, Power Query, or another native Excel solution—that pulls those sheets together, cleans the figures, and produces a polished inventory snapshot ready for management every morning. The core workflow I have in mind is simple: once the operator clicks “Generate,” your automation should gather the latest numbers from our internal workbooks, reconcile duplicates, highlight discrepancies, and output a formatted report (PDF and XLSX) showing on-hand counts, reorder points,...

I have a mixed set of text and numeric records that need to be moved into a master Excel workbook, carefully cleaned, and laid out so everything is easy to read and filter. Fewer than 1,000 numeric rows are involved, but each row carries accompanying text fields, so absolute precision matters. Key tasks include: • Typing the data exactly as supplied, checking every character for accuracy. • Applying my existing color-coding scheme to highlight status and priority. • Tidying column widths, headings, and basic formulas so the sheet is ready for quick sorting and filtering. I will supply the source files and the color legend; you return a finished .xlsx file—no broken formulas, no stray spaces, and every entry verified. If you spot inconsistencies, note them i...

I have a collection of customer information that must be organised accurately in Excel. Your job is to take the raw details I provide—names, contact numbers, email addresses, and any extra fields I specify—and enter them into a clean, well-structured spreadsheet. The spreadsheet has to follow the column layout I give you, preserve exact spelling, and avoid duplicate records. I will share the source files in batches; each batch should be completed and sent back for a quick review before you move on to the next. I value precision over speed, but I still need a reasonable turnaround so my own workflow isn’t delayed. If you are comfortable handling typical Excel functions—data validation, basic formatting, and simple filtering—that will help keep the file consis...

My recruitment pipeline already lives in Excel; what’s missing is a hands-free way to turn that raw sheet into insight I can act on every morning. I need an Excel-based solution—whether it relies on formulas, VBA macros, Power Query, or a light Power Pivot model—that will automatically crunch the data I enter during the day and, by the next day, give me: • Daily Candidate Performance reports • Daily Recruitment Progress summaries • Daily Source-of-Hire breakdowns The reports should refresh with a single click (or on workbook open), capture any new rows I add, and present the metrics in a clean, printable format—charts or pivot tables are welcome as long as they stay linked to the underlying data. Clear documentation inside the workbook or a sh...

I need a set of Excel sheets purpose-built for handling quotations. I’ll be typing in quotation details rather than running extensive analyses, so the layout has to make entering text, line items and basic figures quick and error-free. Here’s what matters to me: • A clean, intuitive structure where I can add or remove rows without breaking any formulas. • Logical sections for item description, quantity, price and total so the sheet doubles as a professional-looking quote I can send to clients. • Basic formulas that automatically extend when new lines are added, plus a final summary field that clearly shows the grand total. • Print- and PDF-friendly formatting. I’ll share a small sample of the data I’ll be entering and I’m happy to ...

I need a well-structured MIS report in Excel that focuses solely on employee attendance. I will supply raw time-in/time-out sheets; what I’m looking for is a clean workbook that transforms that data into meaningful insights—daily, weekly, and monthly views, absence summaries, and any red-flag trends you feel would help management act quickly. Please rely on solid Excel techniques—pivot tables, lookup formulas, conditional formatting, perhaps a touch of Power Query if it speeds refresh. The final file should be plug-and-play: I drop new data into an “Input” sheet and every metric updates automatically, no extra tweaking. Deliverables • One unlocked Excel workbook containing the MIS attendance report • Brief notes inside the file (or a single-pag...

Título del proyecto Automatización RPA en DATAX: Facturación/causación desde Excel con arquitectura escalable (futuro OCR + “memoria” por proveedor) Contexto Somos una firma contable en Colombia. Usamos DATAX para registrar/causar y/o facturar. Queremos eliminar digitación manual con un bot RPA. Empezaremos con Excel → RPA → DATAX, pero el diseño debe quedar preparado para escalar a: carpeta con facturas (PDF/XML) → extracción de datos → reglas contables por proveedor → ejecución en DATAX. Objetivo Fase 1 (MVP en 3–5 semanas) Implementar un bot RPA que, a partir de un Excel maestro, cree/registre (según aplique) facturas/causaciones en DATAX y genere evidencia de ejecución. A...

I want to make pdf hiking guides from data in a spreadsheet. There are 280 peaks, each with 1-5 hiking routes each. I want one pdf hiking guide for each peak that will contain information about the peak and about each of the routes including text descriptions (including the distance, difficulty, trailhead location, notes etc. points of interest, elevation profile, expected time), driving and hiking directions for each route, links to outside sites and links to documents on our web site that must stay active in the final document. Adding elevation profiles to the docs would be a plus (from existing images; a sample is in the files). The goal is to produce a set of documents, one per each of 280 peak and also have a repeatable process for future use. Sample results are in the files. W...

I already have a working estimating spreadsheet program with extensive data base. I now need to add further columns to improve the estimating spreadsheet. Here is what I’m looking for: • Add to the current spreadsheet with additional information i have. • Display the information from a data base. • Make sure the new calculations pick up the same input data fields • Provide clear, concise documentation of every new function and a short change-log so I can track what was modified. • Include a small sample project or test file showing the results of the new time calculations against known benchmarks; this will be the acceptance criterion. The existing program is stable and I have full source control access; you will receive a Git branch to work in. ...

I need an Excel sheet tidy-up to track factory production rates efficiently. Requirements: - Organize data into simple tables - Ensure sheet is user-friendly and easily updateable Ideal Skills: - Proficiency in Excel - Experience with data organization and automation - Attention to detail Please provide samples of previous work.

I have a set of voter-list PDFs released by the election commission. The layout across all files is identical, so positional parsing is reliable. Right now I simply need the current batch converted, but long-term I want a reusable Python utility that pulls the following six columns straight into Excel: • Name • FathersName • Age • Gender • VoterID • SerialNumber . Section Name . Polling Station Name .etc. Scope of work 1. Run the first extraction and hand me the .xlsx file so I can verify accuracy. 2. Package the underlying code (Python 3.x) with clear instructions and any so I can repeat the conversion on future lists without further help. Technical notes – Consistent layout means you can lean on libraries like pdfplumber, camelo...

I have a multi-sheet Recruitment Tracker that needs to be distilled into a single, interactive dashboard in Excel. During a live screen-sharing session I want to walk through the raw data with you, connect the sheets properly, and shape a view that updates automatically. The finished dashboard should let me monitor five specific hiring metrics at a glance: Time to hire, Source of applicants, Candidates by stage, Open roles, and Hires by department and more. Bar charts will handle comparisons, pie charts will highlight shares, and line graphs will show trends over time. I’m happy to lean on PivotTables, slicers, or Power Query—whatever keeps the file lightweight and refreshable. By the end of our session I expect: • one tidy, well-labeled workbook that pulls from my exist...

Excel Expert Needed – Advanced Quotation Calculator Automation We are looking for a highly skilled Microsoft Excel expert to help us finalize and optimize a complex quotation calculator. We are building an Excel-based pricing and quotation system for an extensive product range with multiple categories, variations, and optional add-ons. The main challenge is creating a fully automated structure where all selections dynamically update a central quotation summary. The workbook requires advanced formulas and smart automation so that: - Product categories, variations, and add-ons are linked logically - All selections are reflected correctly in the summary page - Prices, options, and totals update automatically - A change in one place updates multiple dependent fields - The structure is...

import pandas as pd EXCEL_FILE = "" # ----------------------------- # Create Excel Template # ----------------------------- def create_excel_template(): data = { "Service_ID": [], "Sub_Function": [], "DID": [], "Description": [], "Data": [] } df = (data) df.to_excel(EXCEL_FILE, index=False) print(f"Excel template created: {EXCEL_FILE}") # ----------------------------- # Read and Parse Excel # ----------------------------- def parse_excel(): df = pd.read_excel(EXCEL_FILE) # Remove completely empty rows df = (how="all") # Replace NaN with None df = ((df), None) structured_data = [] for _, row in (): service_d...