formualizer

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.

Savings SummaryA9:I26

Saved workbook valuesInputOutput

RowABDEFHI
9Cap the total UPS System Loss savings at:80%
10Cap the total Data Center Lighting energy use savings at:80%
11
12Table D: Estimated Savings.
13D1D2D4D5D6D8D9
18Total5,956,800664,109$99,6165,292,6913.2768,969
211.1
26 E2: T&D Losses5.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 / descriptionType / constraints / default
ups_input_kw

What 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_kw

What 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_kw

What 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_kw

What 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_kwh

What 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_21

Pursue 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_22

Pursue 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_37

Pursue 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_factor

Post-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_18

Estimated 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_33

Estimated 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_cap

Maximum 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_cap

Maximum 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_kwh

Plant 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_percent

Transmission 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 / descriptionType / constraints / default
annual_energy_savings_kwh

Annual avoided electricity; excludes cooling and interactive effects Units: kWh/year. Positive unless stated otherwise.

Type: number

annual_cost_savings_usd

Annual avoided electricity cost Units: USD/year. Positive unless stated otherwise.

Type: number

post_energy_kwh

Annual electricity after selected actions Units: kWh/year. Positive unless stated otherwise.

Type: number

implementation_cost_usd

Total implementation cost Units: USD. Positive unless stated otherwise.

Type: number

simple_payback_years

Implementation cost divided by savings, source returns N/A for zero savings Units: years. Positive unless stated otherwise.

Type: number

annual_co2_savings_lb

Annual 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/mcp

Slug: 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.