Swell Sport · Practical guide

Sauna energy records: a worked kW and kWh error check

When a sauna energy figure looks wrong, audit the record before drawing a conclusion about the heater. This worked exercise repairs four common spreadsheet mistakes using hypothetical records. It produces a correction log, not a running-cost estimate or a claim about any sauna’s efficiency.

Swell Cedar Cube 2 in a home setting.

Keep the source value beside the interpretation

Start a correction log with these fields: original entry, where it came from, unit shown by the source, time window, equipment covered, proposed correction and reason. Preserve the original screenshot or export. Do not overwrite an uncertain number just to make it agree with an expected result.

Power is a rate, measured in watts or kilowatts; energy accumulated over time is measured in watt-hours or kilowatt-hours. The Australian Government explains this distinction using a water-flow analogy. ^[1] That tells you which question a unit answers. It does not tell you whether an app is displaying a live reading, an interval average or a cumulative total; check its own field description.

Error one: turning a power snapshot into session energy

Fictional record A reads “display at 18:10: 4.5 kW; session energy: 4.5 kWh”. The second entry does not follow from the first. A single power reading supplies no duration or complete energy record. Correction: retain 4.5 kW as the recorded power snapshot; mark session energy “not established by this record”.

Do not repair it by multiplying the snapshot by the entire evening. That would add an unverified constant-power assumption. The useful outcome is identifying the missing evidence, not producing an apparently complete total from incomplete data.

Error two: treating minutes as decimal hours

Fictional record B is explicitly a constant-power calculation: 6 kW for 1 hour 20 minutes. Its author enters 1.20 hours and obtains 7.2 kWh. Decimal hours and clock notation are different. The correct duration is 1 + 20/60 hours, so energy is 6 × (1 + 20/60) = 8 kWh. The mistaken entry understates this hypothetical calculation by 0.8 kWh.

Log the correction as “time conversion”, not “measured consumption updated”. Both numbers come from an assumption of constant power. Neither is a test result, a temperature prediction, or a recommendation for how long a person should remain in a sauna.

Error three: reporting the cumulative register as the interval total

Fictional record C has a cumulative energy register of 1,204.2 kWh at the start and 1,209.0 kWh at the end. Assuming the same register, unit and equipment boundary, with no reset, the interval energy is 1,209.0 − 1,204.2 = 4.8 kWh. Copying 1,209.0 into the interval column reports the accumulated register instead of the difference.

Before accepting the subtraction, confirm that both readings cover the intended interval and the same equipment. If one is a whole-home register and the other is a heater record, subtraction is not a valid repair. Flag the mismatch and obtain matching records instead.

Error four: adding the total to its own components

Fictional record D lists interval components of 3.0 kWh and 1.8 kWh, plus a total of 4.8 kWh for those same components. Adding every row gives 9.6 kWh, counting the same energy twice. Use either the component sum or its total, not both. Label subtotal and total rows before creating a spreadsheet SUM range.

Close the audit with a disposition for each record: A needs further evidence; B has a time-conversion correction; C has a cumulative-to-interval correction; D has a duplicate-total correction. Send the corrected record and original evidence together if asking a supplier to investigate. None of these bookkeeping corrections establishes a heater fault, and an unexplained discrepancy should not become an efficiency claim.