PV Calc - Photovoltaic Yeild Calculator (Excel / No Macros)

PVGIS Solar Yield & Sizing Calculator

6-Scenario Excel Toolkit for Fast PV Feasibility

Design and compare up to six array layouts—Fixed-Tilt (wide / optimal / dense), East-West, and Single-Axis Tracker (optimal / dense)—in seconds.
Just drop in your site’s latitude & longitude, available land area, and module specs; click Refresh and the workbook:

1. Auto-sizes each layout to your terrain constraints (pitch, shading, ground-coverage).
2. Pulls live irradiation data from the official PVGIS API.
3. Calculates monthly & annual energy (E_d, E_m), Specific Yield (kWh/kWp), Performance Ratio, losses and more.

Perfect for developers, EPC engineers, consultants or solar investors who need a quick, credible yield check without heavy software like PVSyst.

Key Features

• 6 pre-built scenarios (FS Wide, FS Optimal, FS Dense, EW 10°, HSAT Optimal, HSAT Dense) — fully editable.
• Geometry + astronomy formulas size the DC power to your usable area automatically.
• One-click PVGIS fetch (v5.3 ) — no macros, just Power Query.
• Open inputs — enter values in yellow cells
• Instant KPI report with graphs: Annual kWh, Specific Yield, GCR, PR % and monthly details.
• Works in Excel 2016+ / 365 on Windows & Mac (needs internet for refresh).

What You Get

File Purpose PV_Calc_v1.0.xlsx The live calculator (6 scenarios, locked)

Who It’s For

• Freelance PV designers who need a fast site check.
• Small EPCs & roof-top installers.
• Investors evaluating multiple land plots.
• Students learning PV sizing & yield principles.

Save hours of manual lookup and formula hacking—let PVGIS + Excel do the math while you focus on design decisions.

(No subscription, just a one-time download. Lifetime updates for v1.x.)

Questions? Email veso.al@gmail.com