Full Year Forecast
$0
YTD + Remaining
Remaining Year
$0
From OJL + manual
Revenue YTD
$0
From P&L (manual)
OJL Original
$0
Before haircut
Haircut
$0
vs original
Gastonia
$0
Adjusted remaining
Upload Open Job List .xlsx export from Power BI · pre-filtered to Non-MP
Drop OJL .xlsx file here, or click to browse
Expected: 25 columns, header in row 1, Service Center / Customer / Task Status / Revenue Remaining
Manual Entries YTD comes from P&L · adjustments are free-form
Adjustments (+/− amounts that roll into the forecast)
| Label | Amount | Sign | Bucket | Notes |
|---|
Manually-Added Projects Sales not on the OJL yet · revenue counts toward Remaining Year
| Customer | Service Center | Task Type | Status | Revenue | Notes |
|---|
Confidence Tiers Default haircut % by Task Status · editable, applied to all OJL rows not manually overridden
Carve-Out Customers Customers pulled out of service-center totals · matched as case-insensitive substring of Customer name
By Task Status
By Service Center (Gastonia carved out)
Gastonia Carve-Out
Edit Revenue Remaining inline. Press Reset on a row to revert to tier-haircut. Manual rows can be removed with ×.
Saved Versions Each save snapshots the full forecast · load to view, duplicate to start a new revision
Label · Date · Notes
Full Year
Remaining
Gastonia
Rows
Actions
Delta — compare two versions
Earlier (baseline)
Later (current)