Array group · Budget and commitments
Forecast closing spend from the approved budget, actuals and commitments. Stress-test the uncommitted forecast.
Premium preview · Member downloads are not yet available · Excel workbook in Turkish
Results from the sample workbook
- Current budget
- 316,000
- Stress forecast
- 303,886.4
- Overrun on at-risk lines
- 0
Who can use it, and for what?
Solar operations
For teams tracking array group records by facility. Forecast closing spend from the approved budget, actuals and commitments. Stress-test the uncommitted forecast.
A worked example from the workbook
These figures come from 16 fictional records in the workbook’s Panel sheet.
| Measure | Sample result |
|---|---|
| Current budget | 316,000 |
| Stress forecast | 303,886.4 |
| Overrun on at-risk lines | 0 |
| Net stress variance | 12,113.6 |
How do you start with your own data?
- Choose a start and end date on Panel. If the workbook has assumptions, replace the example values with your own.
- Replace the sample records in the yellow cells on Girdiler. Enter a unique ID and a valid date for each record.
- Review period totals and breakdowns on Panel. Resolve flags on Kontrol and trace calculations on Hesap.
Workbook input fields
Labels appear in Turkish in the workbook.
- Onaylı bütçe
- Gerçekleşen
- Açık taahhüt
- Kalan serbest tahmin
- Beklenen iade veya mahsup
- Onaylı bütçe değişimi
Sample assumptions
- Kalan harcama stres çarpanı
- 1.17