Public Service Solar & Roofing
Combined proposal builder
One tool for solar (cash & loan), new roofs, gutters, solar remove & reinstall, service calls, and FranklinWH batteries — mix any combination on a single proposal. You can add a design image later on the same share link.
What's on this proposal?
Mix and match — solar only, roof only, service/battery only, or the full package
Solar
$22,908
Roof & services
$25,600
Design
Optional
Grand total
$48,508
Design / layout image
Upload your array design, aerial, or layout here (optional). It shows on the proposal and PDF. You can also add it later from the share link.
JPG, PNG, or WebP · compressed automatically
No design attached yet — use Choose image file above, or leave blank and add later from the Open link.
Customer
New solar system
Annual kWh sizes the system · $/W DC sets the solution price
From utility bill or 12-month total
e.g. $2.49 · solution = kW × 1,000 × $/W
Optional — improves rate accuracy
Default REC 460
Size
9.20 kW
Modules
20×460W
Year-1
12,153 kWh
Price
$22,908
Roof system
Optional — uncheck for service/battery/gutters without a new roof
50.00 squares
Existing solar remove & reinstall
Storage & service
Other add-ons
Gutters, guards, dumpster, skylights
Dealer settings
Yield, loan terms, equipment names, rep info
Google Sheet log
Auto-log every proposal with a short clickable Open link
- Open your Google Sheet → Extensions → Apps Script
- Replace Code.gs with Copy Apps Script below
- Deploy → Manage deployments → pencil → New version → Deploy
- Paste the /exec URL here and Save
If Open links are mile-long or broken: update the Apps Script (step 2–3) and Publish this app so short links are used.