You will get Google Sheets KPI dashboard with Apps Script
Top Rated
Project details
You get a live KPI dashboard in Google Sheets. It updates itself. You see your numbers fast. You act with confidence. I build a clean data model, clear charts, and simple automation. You stop manual work. You get accurate results. I deliver fast, clear, and reliable.
Data Tool
Google SheetsWhat's included
| Service Tiers |
Starter
$50
|
Standard
$100
|
Advanced
$250
|
|---|---|---|---|
| Delivery Time | 1 day | 3 days | 4 days |
Number of Revisions | 3 | 4 | 7 |
Number of Macros | 3 | 4 | 6 |
Number of Buttons/Forms | 1 | ||
Model Documentation | - | - | - |
Data Source Connectivity | - | - | - |
Toolbar Integration | - | - | - |
Frequently asked questions
50 reviews
(48)
(0)
(2)
(0)
(0)
This project doesn't have any reviews.
MR
Moncompu R.
Jun 17, 2026
Analysis of Likert Scale data on Excel
Great service from Adnan.
Very quick to understand my request and suggest appropriate solutions.
In fact he gave me constructive advice that added value to my work.
Highly recommended.
Very quick to understand my request and suggest appropriate solutions.
In fact he gave me constructive advice that added value to my work.
Highly recommended.
NH
Nareen H.
Jun 4, 2026
Avery barcode labels from spreadsheet
I am based in Australia and needed help to develop master barcode sheets for our logistics partners here and in the USA. We had several hundred labels with specific requirements to ensure they would accurately scan. Adnan was able to add significant expertise to the job (none of which I have!), make suggestions and accurately reflect the requirements I had of the job. He was always pleasant, accurate and highly skilled. I will most certainly be seeking to use Adnan again for this ongoing work as we need to have further barcodes design work done.
HB
Heather B.
May 21, 2026
Excel Spreadsheet Development for Time Card Data
Adnan is quick to complete the work and very accurate. His communication is on point and he understands the scope of the work in record time.
AM
Audelino M.
May 19, 2026
Excel Data Organization and Summary Specialist
SB
Stephanie B.
May 19, 2026
Build Table of Contents for a product catalog
About Adnan
Financial Modeling & Excel Automation | VBA, Power Query | Top Rated
94%
Job Success
Charsadda, Pakistan - 5:21 am local time
Top Rated Excel and VBA specialist with 10 years building production-grade financial models, automation systems, and operational dashboards for clients across finance, real estate, manufacturing, and operations. 93% Job Success Score across 50+ delivered projects.
Recent work that defines what I do best:
A 23-sheet strategic financial model for an investment firm covering 5 strategic initiatives across 10 departments, with 805 formulas spanning scenario analysis, sensitivity tables, and executive dashboards. The model is what the leadership team uses for capital allocation decisions.
A multi-region sales control tower for a marketing operations firm covering 26 territories across 4 zones, with 1,624 formulas spanning pacing, ranking, variance analysis, and weekly leadership scorecards. Surfaced underperforming segments and cut the executive review cycle from days to minutes.
A 14-tab modular construction operating system covering project intake, status routing through inspection gates, financial tracking with a 26-week cash flow waterfall, factory utilization metrics, and client-facing portals. Delivered as the company's complete operational platform.
A multi-source pharmaceutical pricing engine reconciling 3,544 products across competing tender catalogs at 98.6% match accuracy, leveraging Portuguese-language fuzzy matching, normalization rules, and audit traceability for every match decision.
A dynamic Excel Sankey diagram engine using 600+ lines of VBA to visualize cohort risk shifts over time, with native 4-stop linear gradients on freeform shapes, deterministic regeneration on data changes, and a user-tunable settings architecture so the client can self-adjust styling without developer involvement.
What I bring to your project:
Excel and VBA: complex formula architecture (XLOOKUP, INDEX/MATCH, SUMIFS, array formulas), Power Query M language for ETL pipelines, VBA macros for automation and custom logic, Power Pivot data models, structured tables and named ranges for scalable systems.
Google Sheets and Apps Script: Sheets formula architecture (QUERY, FILTER, ARRAYFORMULA), Apps Script automation including calendar sync, Drive folder management, scheduled triggers, and email triggers.
Financial modeling: 3-statement integrated models, real estate cash flow models with year-by-year amortization and equity tracking, scenario analysis with sensitivity tables, DCF and IRR modeling, waterfall analysis with preferred return and GP promote tiers.
Dashboards and reporting: Power BI, Excel-native executive dashboards, multi-region KPI scorecards, weighted pipeline tracking, variance analysis, conditional formatting at scale.
How I work:
I deliver projects on tight cycles (typically 5 to 10 working days) with iterative client feedback and zero-defect handoffs. Every system ships with documentation so your team can maintain it independently. I work US, UK, and EU time zones reliably and respond within hours, not days.
If you have a complex spreadsheet, financial model, or automation challenge that needs a senior practitioner rather than a generalist, message me with the project details. I'll review and respond with a clear approach, scope, and timeline before you commit.
Adnan
Steps for completing your project
After purchasing the project, send requirements so Adnan can start the project.
Delivery time starts when Adnan receives requirements from you.
Adnan works on your project following the steps below.
Revisions may occur after the delivery date.
Kickoff and data intake
Upload sample data and KPI list You share a small data file and your top KPIs. I confirm scope and timeline.
Access and source verification
Grant edit access and share source links You add me to the Sheet and send links or exports for each data source.