Excel workbook · Catalog edition v2.5
LBNL Electrical Power Chain Tool
Lawrence Berkeley National Laboratory (LBNL — Center of Expertise for Energy Efficiency in Data Centers)
Estimate data center electricity and cost savings, simple payback and avoided carbon emissions from changes to the electrical power chain.
- Inputs
- 81
- Outputs
- 17
- File size
- 172 KB
- Verification
- Independent scenario check
Try it
Try it loads a copy of this file from formualizer.com.
Saved workbook valuesInputOutput
| Row | A | B | D | E | F | H | I |
|---|---|---|---|---|---|---|---|
| 9 | Cap the total UPS System Loss savings at: | 80% | |||||
| 10 | Cap the total Data Center Lighting energy use savings at: | 80% | |||||
| 11 | |||||||
| 12 | Table D: Estimated Savings. | ||||||
| 13 | D1 | D2 | D4 | D5 | D6 | D8 | D9 |
| 18 | Total | 5,956,800 | 664,109 | $99,616 | 5,292,691 | 3.2 | 768,969 |
| 21 | 1.1 | ||||||
| 26 | E2: T&D Losses | 5.0 |
What was checked
Changed-input scenarios match an independent calculation.
Scope and limitations
Catalog calculations, not certification.
LBNL Electrical Power Chain Tool with version-pinned publisher workbook calculations, scenario inputs and formula-level audit traces.
- Published source v2.5; historical UPS sampling and eGRID state factors remain pinned. No safety or equipment-sizing certification.
- F20 is display text; emissions selection uses source-linked T9. Workbook bytes and formulas are unchanged.
What it computes
Ports for the compact flow: quick_power_chain_savings. The full port contract includes all 98 ports.
Inputs (15)
| Port / description | Type / constraints / default |
|---|---|
ups_input_kwWhat is the annual average input power of the UPS system in kW? Zero activates claimed-efficiency fallback; savings formulas still use measured input minus output, so supply measured input for retrofit analysis. Units: kW. Omitted input retains publisher's source default 580. | Type: number Constraints: min: 0 Default: 580 |
ups_output_kwWhat is the annual average output power of the UPS system in kW? Units: kW. Omitted input retains publisher's source default 500. | Type: number Constraints: min: 0 Default: 500 |
it_equipment_kwWhat is the annual average IT equipment power demand in kW? Units: kW. Omitted input retains publisher's source default 515. | Type: number Constraints: min: 0 Default: 515 |
lighting_kwWhat is the annual average lighting power demand in kW for the data center? Units: kW. Omitted input retains publisher's source default 20. | Type: number Constraints: min: 0 Default: 20 |
electricity_cents_per_kwhWhat is the annual average unit cost of electricity in ¢/kWh? Units: cents/kWh. Omitted input retains publisher's source default 15. | Type: number Constraints: min: 0 Default: 15 |
pursue_action_21Pursue displayed action at row 21; requires a compatible question response. Yes selects it, No declines it, N/A means unavailable. Rows 21/22 are modular/right-size UPS; 37 is occupancy lighting. Units: source enum. Omitted input retains publisher's source default "Yes". | Type: string Constraints: one of: Yes, No, N/A Default: "Yes" |
pursue_action_22Pursue displayed action at row 22; requires a compatible question response. Yes selects it, No declines it, N/A means unavailable. Rows 21/22 are modular/right-size UPS; 37 is occupancy lighting. Units: source enum. Omitted input retains publisher's source default "Yes". | Type: string Constraints: one of: Yes, No, N/A Default: "Yes" |
pursue_action_37Pursue displayed action at row 37; requires a compatible question response. Yes selects it, No declines it, N/A means unavailable. Rows 21/22 are modular/right-size UPS; 37 is occupancy lighting. Units: source enum. Omitted input retains publisher's source default "Yes". | Type: string Constraints: one of: Yes, No, N/A Default: "Yes" |
new_ups_load_factorPost-retrofit UPS load fraction. Active if any UPS row 20–23 action is pursued; exact tenth-step lookup, no interpolation. Units: decimal fraction. Omitted input retains publisher's source default 0.8. | Type: number Constraints: one of: 0.1, 0.2, 0.3, 0.4, 0.5, 0.6, 0.7, 0.8, 0.9, 1 Default: 0.8 |
implementation_cost_18Estimated cost for action group row 18. Cost is counted by source even if pursuit is disabled; set cost to zero when cancelling an action. Rows 18 and 33 are UPS and lighting-control projects. Units: USD. Omitted input retains publisher's source default 300000. | Type: number Constraints: min: 0 Default: 300000 |
implementation_cost_33Estimated cost for action group row 33. Cost is counted by source even if pursuit is disabled; set cost to zero when cancelling an action. Rows 18 and 33 are UPS and lighting-control projects. Units: USD. Omitted input retains publisher's source default 15000. | Type: number Constraints: min: 0 Default: 15000 |
ups_savings_capMaximum combined savings fraction of UPS losses; source omits interactive effects. Units: decimal fraction 0..1. Omitted input retains publisher's source default 0.8. | Type: number Constraints: min: 0; max: 1 Default: 0.8 |
lighting_savings_capMaximum combined savings fraction of lighting consumption. Units: decimal fraction 0..1. Omitted input retains publisher's source default 0.8. | Type: number Constraints: min: 0; max: 1 Default: 0.8 |
custom_emissions_lb_per_kwhPlant emission rate, active only for emissions_region_index=1 (Custom). Units: lb CO2/kWh. Omitted input retains publisher's source default 1.1. | Type: number Constraints: min: 0 Default: 1.1 |
transmission_loss_percentTransmission and distribution loss percentage; rate is divided by 1-loss/100. Units: percent points 0..10. Omitted input retains publisher's source default 5. | Type: number Constraints: min: 0; max: 10 Default: 5 |
Outputs (6)
| Port / description | Type / constraints / default |
|---|---|
annual_energy_savings_kwhAnnual avoided electricity; excludes cooling and interactive effects Units: kWh/year. Positive unless stated otherwise. | Type: number |
annual_cost_savings_usdAnnual avoided electricity cost Units: USD/year. Positive unless stated otherwise. | Type: number |
post_energy_kwhAnnual electricity after selected actions Units: kWh/year. Positive unless stated otherwise. | Type: number |
implementation_cost_usdTotal implementation cost Units: USD. Positive unless stated otherwise. | Type: number |
simple_payback_yearsImplementation cost divided by savings, source returns N/A for zero savings Units: years. Positive unless stated otherwise. | Type: number |
annual_co2_savings_lbAnnual avoided CO2 with transmission-adjusted plant factor Units: lb CO2/year. Positive unless stated otherwise. | Type: number |
Questions this workbook answers
- LBNL electrical power chain savings calculator
- data center UPS efficiency retrofit payback
- data center lighting CO2 savings
Questions and answers
Does this include cooling electricity?
No. The source covers IT electrical power-chain losses, IT equipment, generator heaters and lighting. Cooling and interactive effects are excluded.
How are electricity and emissions entered?
Electricity is cents/kWh, emissions lb CO2/kWh, and T&D loss is percentage points. Savings caps and load factors are decimal fractions.
For agents
Connect an MCP client to the catalog endpoint:
https://catalog.formualizer.com/v1/mcpSlug: lbnl-power-chain · Edition: v2.5
- search_workbooks
- Optional arguments: query (string), theme (string), tag (string).
- inspect_workbook
- Required: slug (string). Optional: edition (string), flow (string).
- evaluate_workbook
- Required: slug (string), inputs (object). Optional: edition (string), flow (string), cellOverrides (object), selectCells (array of strings), trace (boolean).
{
"name": "evaluate_workbook",
"arguments": {
"slug": "lbnl-power-chain",
"edition": "v2.5",
"flow": "quick_power_chain_savings",
"inputs": {
"electricity_cents_per_kwh": 25
}
}
}cellOverrides sets individual cells. selectCells reads at most 256 cells per request. trace requests formula lineage.
Flows
quick_power_chain_savings
Quick UPS and lighting savings
UPS and occupancy-lighting retrofit; retains baseline active UPS, transformer/PDU measurements, Custom emissions selector and other diagnostic answers. Explicit action switches and caps control savings; costs must be reset when cancelling actions.
15 input ports · 6 output ports. Full membership in the port contract.
full_power_chain_assessment
Full electrical power-chain assessment
All numeric measurements, diagnostic source enums, pursuit switches, cost groups, savings caps and emissions list-box selection. Static reference tables stay source-pinned; selectCells/cellOverrides can inspect or override them.
81 input ports · 17 output ports. Full membership in the port contract.
REST example
Bundle scenario: quick_power_chain_savings_higher_tariff · Flow: quick_power_chain_savings
curl 'https://catalog.formualizer.com/v1/models/lbnl-power-chain/v2.5/evaluate?flow=quick_power_chain_savings' \
-H 'Content-Type: application/json' \
--data '{"inputs":{"electricity_cents_per_kwh":25}}'Expected response
Expected values from the bundle, subject to the check level above.
{
"outputs": {
"annual_energy_savings_kwh": 664109.4994299929,
"annual_cost_savings_usd": 166027.37485749822,
"post_energy_kwh": 5292690.500570007,
"implementation_cost_usd": 315000,
"simple_payback_years": 1.8972774837304114,
"annual_co2_savings_lb": 768968.8940768339
}
}Looking for another spreadsheet? Request a workbook.