EdTechTrainLEARNING WITH PURPOSE
Explore +

Good tools.
Better learning.

Our partners ↗Contact & information ↗
EDUCATION / TECHNOLOGY / PRACTICEThe resource collection ↗
The education technology collection

Build a mining energy spreadsheet: watts, runtime and a bill you can check

A worked classroom spreadsheet using hypothetical mining equipment to separate power, energy, tariffs and unsupported profit claims.

A spreadsheet can calculate electricity use accurately while still giving a misleading answer if its inputs describe the wrong thing. A hypothetical mining setup makes a useful exercise in units, operating schedules and checking what a total includes.

This is a new classroom worksheet. Students do not need mining hardware, a pool account or a cryptocurrency purchase. Every equipment value and tariff below is invented for the exercise, not a current product specification or local electricity quote.

Begin with power and time, not a profit estimate

Power in watts describes a rate of energy use. Divide watts by 1,000 to obtain kilowatts, then multiply by operating hours to obtain kilowatt-hours. Electricity usage charges can then be calculated from the applicable price per kWh.

Before opening the spreadsheet, ask learners what happens if a device runs twice as long. Ask separately what happens if its power doubles. Keeping the variables separate makes it easier to spot a formula that accidentally multiplies by the number of days twice.

Make a small input sheet

Enter these labels in column A and values in column B. Give B7 the local currency unit chosen for the exercise; the numerical example uses 0.15 currency units per kWh.

  • B2: active power, 3,000 W.
  • B3: active hours each day, 18.
  • B4: standby power during the remaining hours, 30 W.
  • B5: additional fan power while the device is active, 150 W.
  • B6: number of days, 7.
  • B7: energy price, 0.15 per kWh.

The model assumes one device, the same schedule every day, and the separate fan running only during active hours. The hypothetical 3,000 W is measured at the device’s AC input and includes its power-supply losses. Do not add another allowance for the same losses.

Calculate each component before adding the total

Use ordinary multiplication and division so the formulas work in common spreadsheet tools without a language-dependent function name. Put the formulas in column C beside clear labels:

C2  =B2/1000*B3*B6
C3  =B4/1000*(24-B3)*B6
C4  =B5/1000*B3*B6
C5  =C2+C3+C4
C6  =C5*B7

The results should be 378 kWh for active use, 1.26 kWh for standby and 18.9 kWh for the additional fan. Total energy is 398.16 kWh. At the example price, the energy charge is 59.724, or 59.72 rounded to two decimal places.

Keep unrounded values in the calculations and format the final amount for display. If a learner gets 398,160 kWh, check the watts-to-kilowatts conversion first. If they get 2,787.12 kWh, check whether the seven-day factor has been applied twice.

Decide what belongs in the boundary

Standby means the device remains powered at the assumed 30 W. If it is disconnected for the other six hours, that component should be zero. If the extra fan runs all day, its hours differ from the device’s active hours. Change the model rather than disguising those differences in a single “efficiency” percentage.

Real premises may also have cooling equipment, network devices and shared infrastructure. Only add consumption not already included in the measurement. A plug-in reading for a device cannot automatically represent an entire room, while a room meter may include unrelated loads.

Test the spreadsheet before trusting a plausible total

Try zero days: every energy component should become zero. Try 24 active hours: standby should disappear. Try a zero tariff: the energy remains unchanged but the usage charge becomes zero. Reject negative power and hours outside the range zero to 24; a spreadsheet accepting those numbers is not evidence that the scenario is physically meaningful.

Then increase active power by 100 W. Over 18 hours on each of seven days, that adds 12.6 kWh. This independent mental calculation is a better check than copying the same formula into a second cell and finding that it agrees.

Keep the conclusion inside the evidence

The result is an energy charge under a flat-rate assumption, not a complete electricity bill or mining profit. Standing charges, demand charges and time-of-use rates require additional inputs. Mining revenue would introduce separate assumptions about hashrate, network conditions, fees and price; none are established by this worksheet.

Use the Bitcoin hashing lesson for a separate computing activity. Teachers planning how students will explain their assumptions can use the professional development notes and the resource collection.

Unit reference: the U.S. Energy Information Administration’s explanation of measuring electricity.