Each cell shows which pack (B1-B9) is on which barge at each hour. Yellow = cargo discharge, grey = swap or barge not yet launched/done. Same pack color = same physical battery rotating through the fleet.
Cargo Rate Sensitivity
Diesel Price × Discount Rate
Lifecycle Emissions
Diesel — Year-by-Year Cash Flow (Cr INR)
Battery Swap — Year-by-Year Cash Flow (Cr INR)
PV/NPV column uses your discount rate. Cumulative row shows nominal running balance. Mirrors the TCO and NPV sheet in the Excel model.