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 projectCategory
VBA Automation & Web Scraping
Macros, Selenium browser automation and web data collection that remove hours of repetitive work.
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
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
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
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
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
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
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
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
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
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
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
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
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