Survey Completion Dashboard
Housing & Property Surveys
A one-page management dashboard that tracks property survey progress against yearly and monthly targets. Weekly exports from the survey platform are imported with one click and…
View projectAvailable for new projects
Excel automation, dashboards and data tools that run real businesses.
I build spreadsheet systems that replace hours of manual work: VBA automation, Selenium and web scraping, interactive dashboards, invoicing and finance tools, and Power BI reports. Every project below is real client work.
- 10+
- years of Excel VBA
- 500+
- automation projects
- 5.0
- rating on Upwork and Fiverr
Excel VBA
UserForms
Selenium
Power Query
Power BI and DAX
Google Apps Script
SQL
Python
Selected work
37 real projects, sorted by what they do
Screenshots are taken from the delivered workbooks. Client names, contact details and figures that identify people are blurred.
Inventory Management System for Drilling Operations
Oil & Gas
A complete materials and inventory workbook for a drilling services company. It links every well design to the chemicals and cement it consumes, tracks monthly usage…
View project
Product Analysis Report Generator
FMCG / Retail Analytics
An automated sales analysis tool for a beverage brand. Raw point-of-sale data is imported, a pivot master is built and the macro produces Pareto, NIS and…
View project
Network Device Lifecycle Analysis
IT Infrastructure
A lifecycle report for more than ten thousand routers and switches. Each device is matched to its end of software maintenance date and replacement model, and…
View project
Staff Performance Benchmark Report
Healthcare (Residential Treatment)
A weekly benchmark report for two residential treatment programs. It compares individual sessions, group sessions, interventions and meeting attendance for every client and staff member against…
View project
Attendance & Compliance Automation Tool
Healthcare (Behavioral Health)
A control panel that logs into the electronic health record system with Selenium, downloads client, staff and charting reports and rebuilds the attendance, group capacity and…
View project
Client-Level Audit Tool
Healthcare (Behavioral Health)
An audit workbook that pulls documentation data from the EHR and checks every client against state compliance rules: admission paperwork, daily summaries, group and one-to-one notes,…
View project
Payroll & Billing Hours Automation
Healthcare (Home & Community Services)
Automates the bi-weekly payroll check for a home and community services provider. Staff and billing reports are downloaded from the EHR, billed hours are summarised by…
View project
Counselor Service Hours Report
Healthcare (Behavioral Health)
A counselor selector report that shows, for any week, how many minutes of individual, group, treatment coordination and peer support each assigned client received, with alerts…
View project
Automated Cashflow & Bank Categorisation
Accounting
Downloads bank and QuickBooks data, classifies every transaction into a ledger using a keyword table and produces a monthly cashflow statement with payroll summary. New vendors…
View project
Janitorial Bid Estimator
Facility Services
A transparent bid calculator for commercial cleaning contracts. Building size, frequency, labour rate and margins produce the rate per square foot and monthly and annual bid…
View project
On-Demand Courier Pricing Calculator
Logistics
A quoting calculator for a same-day courier business. Mileage, vehicle type, weight, pallets and service level are combined with editable rate tables to produce a total…
View project
Fire Extinguisher Service Report Generator
Fire Safety Services
Turns raw service visit data into printable inspection reports and certificates for each customer site. Reports are exported to PDF and CSV and follow-up reminders are…
View project
Luggage Transport Booking System
Travel & Tourism
Built for a hiking tour operator. Each booking is entered once with its stretches, dates and luggage count, and the system distributes it to every supplier…
View project
Bar Crash Price Timer Display
Hospitality
An animated TV display for a bar's happy-hour game. A countdown timer runs, drink prices crash at random and the display shows crash prices next to…
View project
Baseball Roster & Lineup Generator
Sports
Creates fair fielding lineups for a youth baseball team. Positions are randomised inning by inning while the equalizer rules make sure every player sits, catches and…
View project
Trade Opportunity Finder & Profitability Analysis
International Trade
A database-driven tool for an import and export business. Products, suppliers, clients and prices are added through forms, and sales simulations calculate landed cost, truck loading…
View project
Project Planner & Gantt Chart
Pharmaceutical Launch
A launch plan with more than a hundred tasks. Tasks, owners, priorities and dates are entered in the planner and the Gantt chart, progress counters and…
View project
Launch Readiness Tracker
Pharmaceutical Launch
A product launch readiness tracker with grouped task buckets. Add and delete task buttons keep the structure intact, a double-click calendar fills dates, and the Gantt…
View project
Team Resource Planner
IT / Project Management
A weekly capacity planner for a team. Members and tasks are added through forms, hours are planned week by week and the planner shows available FTE,…
View project
Invoice Generator with Customer & Product Database
Wholesale Distribution
An invoicing system for a skincare wholesaler. Invoices are created from customer and product databases, saved, searched, reloaded and printed, and a best-selling report is updated…
View project
Multi-Company Invoicing System
Security Services
Recurring service invoicing for several companies from one file. Invoices are saved to a database, PDFs are generated individually or for a whole month, and summary…
View project
Fire Sprinkler Estimating Workbook
Construction / Fire Protection
A full estimating workbook for sprinkler and alarm contracts. Unit entries, cost books, parts lists, rentals and subcontracts roll up to the contract value, cost per…
View project
Multi-Language Expense Report Form
Manufacturing (Baltics)
An employee expense claim form used in several countries. The form switches between eight languages, converts currencies, validates accounts and cost centres and emails the finished…
View project
Timesheet & Billing Dashboard
Legal Services
A timesheet and payout system for a small legal team. Users log in by role, workers record tasks and hours, and the admin dashboard shows billed,…
View project
Health Plan Quote Builder (Excel to Word)
Insurance
Builds self-funded health plan quotes. Premiums, claims forecasts and fees are calculated in Excel and a single click exports the finished quote into a formatted Word…
View project
Hotel & Restaurant Management System
Hospitality
A complete hotel system inside Excel. Rooms are shown on a building map with live status colours, and the restaurant module handles table bookings, orders, menu…
View project
Staff Leave & Attendance Manager
Human Resources
Tracks staff attendance and seventeen leave types with yearly allowances. Monthly attendance grids, period and yearly reports and PDF and CSV exports are all generated by…
View project
Bill of Materials Cost Comparison
Manufacturing
Compares part costs across product models from a grouped bill of materials. Raw data is imported and a results matrix shows quantity, cost and platform for…
View project
Window Pricing & Breakdown Worksheet
Construction / Windows
An estimator worksheet for a window installer. Product price books for five product lines feed a breakdown sheet where each opening is priced by size, options…
View project
Economic Data Web Scraper
Finance / Research
Collects treasury yield curves, consumer price index series, personal consumption data and wage indices from public government websites straight into Excel, ready for analysis.
View project
Sales & Purchase Inventory Data Model
Trading
A relational data model in Excel with customers, suppliers, products and countries. Sales and purchase orders are entered through forms, stock levels update automatically and customs…
View project
Cost & Savings Progression Model
Telecom / Hardware
A scenario model that projects component costs and savings as hardware moves from analog to IP over time. One button recalculates four scenarios using the ramp…
View project
Account Reporting Tracker
Food & Beverage Brokerage
A shared tracker for account managers. Each update entered on the form is sent to the internal database, a master log file and a separate file…
View project
Property Management Rent Ledger
Property Management
A rent and landlord statement system. Each property has its own ledger of rent, fees, VAT and landlord payments, statements are imported, and the dashboard totals…
View project
Production Order Tracker
Custom Products / E-commerce
Moves custom orders through the workshop. Orders flow from the order list to production lines and then to packing as tick boxes are checked, so the…
View project
Python Audit Dashboard (Desktop App)
Healthcare (Behavioral Health)
A desktop dashboard written in Python with Tkinter and pandas. It reads exported documentation data, normalises note titles, checks group, one-to-one and daily summary notes for…
View projectBrowse by category
Pick the kind of tool you need
A1
Dashboards & Reporting
Interactive Excel dashboards, KPI reports and automated analysis outputs that turn raw exports into decisions.
8 projects
B1
VBA Automation & Web Scraping
Macros, Selenium browser automation and web data collection that remove hours of repetitive work.
17 projects
C1
Management Systems
Inventory, HR, hotel, CRM and order management systems built entirely in Excel with forms and databases.
11 projects
D1
Finance, Invoicing & Accounting
Invoicing systems, cashflow automation, ledgers, expense claims and financial models.
9 projects
E1
Planners & Gantt Charts
Project planners, Gantt charts, team capacity planners and scheduling tools.
5 projects
F1
Calculators & Estimating
Pricing calculators, bid estimators and estimating workbooks for quoting jobs quickly and accurately.
5 projects
G1
Healthcare Billing & Compliance
Billing, payroll, audit and attendance tools for behavioral health providers, with EHR automation.
6 projects
H1
Python & Desktop Apps
Python tools with pandas and Tkinter for data cleaning, dashboards and reporting.
1 project
Services
What I can build for you
Excel VBA automation
Macros and UserForms that import, clean, reconcile and report in one click, with buttons your team can use without touching code.
Dashboards and reporting
KPI dashboards in Excel and Power BI with slicers, targets and charts that refresh from your own data.
Web scraping and browser automation
Selenium and Python bots that log in, download reports and bring web data straight into your workbook.
Finance and accounting tools
Invoicing, cashflow, ledgers, payroll checks and financial statements from someone with real accounting experience.
Management systems
Inventory, CRM, HR, booking and order systems built as structured databases inside Excel or Google Sheets.
Python and Apps Script
Python data tools and Google Sheets Apps Script automations when a spreadsheet alone is not enough.
About
Sourab Kr Saha
Kolkata, India (working with US, UK, EU and Middle East clients)
I am a commerce graduate (B.Com Accounts Honours, University of Calcutta) with three years as a senior accountant and more than ten years of Excel VBA development. Today I work as an Executive Assistant and Data Analyst for a US healthcare group, where I automate billing, payroll, audit and attendance reporting.
On Upwork and Fiverr I have delivered over 500 automation projects for clients in property, logistics, healthcare, retail, construction, finance and hospitality, with a 5.0 rating on both platforms.
How I work
- Understand the fileYou share the workbook and the problem. I map the data and confirm the result you expect.
- Build and testI build on a copy of your file and test it with your real data.
- Deliver with a demoYou get the file, a short video walkthrough and free revisions until it works the way you need.
Profiles and shop
Certifications
- B.Com (Accounts Honours), University of Calcutta
- SQL and MySQL for Data Analytics and BI
- Complete Web Automation with Excel VBA
- 15 Days of Power BI Bootcamp
- Medical Billing, Coding and RCM for US Healthcare