Total pipeline
—
Est. capex
—
Avg IRR
—
Active (stage 3–6)
—
MW by country
Capex by stage (USD m)
Add GPS coordinates to projects to see them on the map
Step 1 — Create the Google Sheet
Create a new Google Sheet (e.g. "Provitaz Portfolio"). The Apps Script will auto-create the Projects and Milestones tabs on first use.
Step 2 — Deploy the Apps Script
In your Sheet go to Extensions → Apps Script, paste
Code.gs, then:- Click Deploy → New deployment
- Type: Web app
- Execute as: Me
- Who has access: Anyone
- Click Deploy — copy the Web app URL
Step 3 — Paste the URL
The URL looks like
https://script.google.com/macros/s/.../exec