Investment Portfolio Tracking System Web App: a role-based Google Apps Script system with FIFO holdings, XIRR, time-weighted returns, rebalancing, client statements and 19 reports, with a live demo.
Google Sheets
Study Abroad Deadline Calendar in Google Sheets
Study Abroad Deadline Calendar in Google Sheets: track university applications, English tests, scholarships, loans and visa steps in annual, monthly and date-range views from one shared sheet.
Auto Detailing KPI Scorecard in Google Sheets
Auto Detailing KPI Scorecard in Google Sheets with 10 traffic-light KPI cards, a month picker, MTD/YTD and Target/PY views, and a KPI Trend page for monthly reviews.
Handyman Services KPI Dashboard in Google Sheets
Handyman Services KPI Dashboard in Google Sheets: 12 KPIs in four groups with MTD and YTD traffic lights, prior-year arrows, KPI Trend and KPI Analysis pages.
Patreon & Membership Income Tracker in Google Sheets
Track every patron across Patreon, Ko-fi, Substack and YouTube in one Google Sheet: a live MRR card, 4 charts, 6 self-calculating columns and a 40-day churn flag.
Luxury Goods Dashboard in Google Sheets
A six-page Luxury Goods Dashboard in Google Sheets with 4 KPI tiles, 16 pivot-backed charts, 15 filter chips and an Order ID search page. Room for 1,000 orders.
How to Clean Messy Data in Google Sheets: 5 Tricks + a Bonus (Free Practice File)
Clean messy data in Google Sheets step by step: TRIM and CLEAN for spaces and hidden characters, PROPER/LOWER/UPPER for capitals, SPLIT and Split text to columns, UNIQUE and Remove duplicates, ISEMAIL for broken emails, plus ARRAYFORMULA to clean a whole column with one formula. Free practice file included.
Exam Invigilation Duty Calendar in Google Sheets
Plan every exam invigilation duty in one shared Google Sheets file: a 12-month Annual View, a Monthly View with an “N more” cue, a date-range Daily View and one Events register, with 100 fictional sample duties.
Faculty Workload Calendar in Google Sheets
Plan faculty teaching, research, advising and service commitments with annual, monthly, daily and detailed calendar views in an editable Google Sheets template.
Dissertation Milestone Calendar in Google Sheets
Plan proposal, IRB, chapter review and defense dates with annual, monthly, daily and event-list views in an editable Google Sheets dissertation calendar.