Private in-browser planning

Multi-Site Energy Cost Rollup Tool

Starting values are hypothetical. Replace them with your own figures. Inputs stay in this browser and are not included in the energy inquiry.

  • Hypothetical rows. Replace them and keep every site on the same reporting period and cost scope.
  • CSV is a local snapshot. No utility account numbers or confidential identifiers are required.

Agree on a reporting boundary first

Choose a period such as a calendar year or one common month. Every row should cover that same period. If bill read dates differ, document how the values were aligned instead of silently adding eleven months from one site to twelve from another. Decide whether a row represents a whole building, a tenant or a particular meter and use that definition consistently.

Use short internal site labels rather than full account numbers, confidential customer names or banking information. The calculator does not need those identifiers to add costs. Where electricity and gas are on different accounts, combine them into the row only if they serve the same reporting boundary. Keep source invoices outside the exported summary for audit support.

Enter costs and consumption as distinct fields

Record electricity cost, gas cost, electricity kWh and gas therms for each row. Costs should use the same scope: either comparable full bills or a clearly identified subset. If one row includes demand and taxes while another includes only commodity, a combined total may still add correctly but will not support a fair unit-cost comparison.

Use zero for a genuinely absent commodity. Investigate missing bills separately rather than converting missing information into zero and presenting the portfolio as complete. Gas volumes must be normalized to therms using applicable bill factors before entry. kWh and therms cannot be added as though they were the same physical quantity.

How the rollup and CSV work

The tool sums electricity costs, gas costs, kWh and therms independently. Combined cost is total electricity plus total gas spending. Electricity cost per entered kWh is portfolio electricity cost divided by portfolio kWh; gas cost per therm uses the gas totals. When a quantity is zero, the related ratio is not defined.

For an illustrative two-site set, $12,000 electricity cost with 100,000 kWh at one site and $24,000 with 200,000 kWh at another produce $36,000 and 300,000 kWh. The ratio is $0.12 per kWh. It is a weighted portfolio ratio, not the simple average of displayed site rates. The CSV preserves each row and adds its total cost so the arithmetic can be reviewed.

Use the totals to improve procurement records

Check unusually high unit-cost ratios against actual bills. A low-use site with a fixed customer charge can have a high effective cost without an incorrect tariff. A zero-use row with nonzero cost may reflect fixed charges or a data problem. Those cases deserve explanation instead of automatic deletion.

This browser worksheet is not an ongoing bill-ingestion system, credentialed utility connection or permanent portfolio database. Download a copy if you need to retain the work and reconcile it with your records. Use cost per square foot or production-unit measures only after adding consistent area or output data; raw portfolio totals alone do not establish building efficiency or the best supplier contract.

Sources & scope

Primary references reviewed October 15, 2026. These sources support the stated concepts; actual tariffs, program rules and signed agreements govern the account. Decision examples and operational worksheets are original educational analysis.

Continue the review

Commercial Energy Cost Per Square Foot Calculator Commercial Energy Budget Calculator Energy Cost Per Production Unit Calculator