An agency project management system web app built in Google Apps Script – 27 screens linking quotes, projects, milestones, timesheets, retainers, unbilled WIP, invoices and profitability, with six roles and twelve reports. Try the live demo.
Author: PK
Meet PK, the founder of NeotechNavigators.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your data analysis skills to the next level!
Co-working Space Booking Management System Web App
A co-working space booking management system web app on Google Apps Script – six locations, 360 bookable units, seven roles and 18 reports, with a live demo you can sign into.
Solar Panel Installation KPI Dashboard in Google Sheets
A formula-driven Solar Panel Installation KPI Dashboard in Google Sheets: 15 KPIs in five groups, MTD and YTD traffic lights, a month dropdown, a per-KPI trend page and a group roll-up.
Glass Installation KPI Dashboard in Google Sheets
Track 13 glass installation KPIs in Google Sheets with a month picker, MTD and YTD traffic lights, per-KPI trends, a group roll-up and prior-year comparison.
Freelance Gig & Deadline Tracker in Google Sheets
A one-page Google Sheets tracker for freelancers: 16 columns per gig, four self-calculating columns, a live outstanding-payment card and four charts that flag every Due Soon and Overdue deadline.
Billable Hours & Time Tracker in Google Sheets
A one-page billable hours time tracker in Google Sheets: sixteen columns, six of them automatic, four live charts and a Total Billable Amount card that shows exactly what each client still owes you.
Vocational Training Dashboard in Google Sheets Template
A six-tab Google Sheets reporting workbook for training providers: 4 KPIs, 17 charts, 15 slicers and a formula-only trainee lookup over a 16-column data model with no personal data.
Colleges & Universities Dashboard in Google Sheets
A ready-built Google Sheets dashboard for colleges and universities: six sheets, 15 slicers, 16 charts and 500 sample application records covering admissions, academics, tuition and scholarships.
Chemotherapy Cycle Calendar in Google Sheets
A scheduling spreadsheet with Annual, Monthly and Daily views over one 100-row events table – and no patient data field anywhere. Not a treatment plan, not a record.
Maternity Ward Duty Calendar in Google Sheets
The Maternity Ward Duty Calendar in Google Sheets ships 100 sample duties across 16 duty types and 15 ward locations, on Annual, Monthly and Daily views fed by one register – with no staff-name column anywhere.