Ravi Sir's Cards › Excel
Electricity Meter Reading Tracker in Excel (card 1 of 2)
Revision card 1 for Electricity Meter Reading Tracker in Excel: Units used = this reading − last reading: =B9-B8 gives 158; Bill estimate = units × rate + fixed charge: =C9*$B$3+$B$4 gives ₹1,631; Change vs last month: =C10/C9-1 gives -4%. Includes an example data table.
Read card text
What this card says
1 for Electricity Meter Reading Tracker in Excel: Units used = this reading − last reading: =B9-B8 gives 158
Bill estimate = units × rate + fixed charge: =C9*$B$3+$B$4 gives ₹1,631
Change vs last month: =C10/C9-1 gives -4%. Includes an
Example
data table
Learn this in the lesson: Electricity Meter Reading Tracker in Excel: Units Used per Month, Bill Estimate and Usage Chart