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 projectPortfolio
All projects
Every project here is a real workbook delivered to a client. Choose a category to narrow the list.
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 project