ElyxAI

Excel for an energy manager: which reading is over the limit

The energy workbook on this page is the reading log you open after a round of meters. One row is one reading of one meter. You type the meter, the fluid word, the date, the previous index, the current index, and the limit for that row. Use is current minus previous when the current index is at least the previous one and the row is kept. The flag says high when that use is above the limit you typed, and within when it is not. This file is not a vehicle mileage log. A fleet sheet answers which vehicle is free. This list answers which building meter used more than the limit on the two indexes you typed. It is not a hotel occupancy rate. A backwards reading, where current is below previous, stays blank. The sheet does not guess a consumption. The guide below builds that reading log. Elyx writes the use and the flag in the workbook you already keep. You still type both indexes and the limit. The trial lasts 7 days, with no card.

1 workflows

Frequently asked questions

What goes on a meter reading log?

One row per reading: previous index, current index, limit, use, and a flag of high or within.

Is this a vehicle log?

No. A vehicle log tracks mileage and availability. This sheet tracks two meter indexes and a limit you typed for a fluid.

What if the current index is below the previous one?

Use and flag stay blank. Fix the cell that is wrong. The sheet does not turn a backwards reading into a consumption.

Essential
Popular