Output Exports

Build workbook outputs from parsed settlement data with selectable blocks and date ranges.

Export Builder

Settlement Workbook Output

This export builder writes raw parsed numbers into the workbook without formulas and can now include both operating-unit worksheets and the total business summary tab.

Selected blocks stack dynamically below one shared week-ending row, with exactly two blank rows between blocks and no empty gaps for omitted sections.

Current Scope

Included now: op-unit sheets, the Total Business Revenue summary tab, block selection, and Friday date-range export.

Flexible output: run the summary sheet by itself or alongside the operating-unit sheets.

Date range loaded: 2020-10-30 to 2026-07-24

Start FridayEnd Friday

Include Summary TabAdds the `Total Business Revenue` sheet as the first workbook tab.Include Op-Unit SheetsLeave this checked for the detailed worksheets, or uncheck it to export the summary tab by itself.

Blocks

Choose which sections to include. They will stack in this order with two blank rows between them.

Revenue ReportWeekly yellow, orange, and green settlement outputs.Outside WorkOutside-terminal quantities, dollars, and fuel offset.Route DataDaily route, stop, and package performance plus weekly rollups.RatesStored package and stop rates used for outside-terminal calculations.

Operating Units

One worksheet is created for each selected operating unit.

MountaineerMountaineer · 300 parsed weeksPro16-9 LNCPro16-9 · 82 parsed weeksStory GRNStory · 154 parsed weeksStory HICStory · 57 parsed weeksSwitchbackSwitchback · 57 parsed weeks

The workbook downloads immediately and writes output numbers only. Missing weeks remain blank so gaps stay visible across the selected Friday range, and the summary tab uses the full selected week range for cross-unit comparison.