help with maths - new kwh meter installed

[icantchooseone]

unit 6 installed a new kwh meter today

these are the readings i took on 1 November on an excel SS so its auto calculated




her old meter today has a reading of 0447

so is this correct : 447 - 278 = 169 units she used from 1 nov to today



but her new meter is on 0000

so when i read the meters on 1 Dec i would need to make her start reading 9831 ?

 

[Steamy Tom]

I feel like I am on drugs...

how can her old meter be on 0447? maybe 1447?

Why complicate things? start it fresh and calculate the interim difference and add it

 

[icantchooseone]

I feel like I am on drugs...

how can her old meter be on 0447? maybe 1447?

it clocked over , 9999 to 0000 to 447

Why complicate things? start it fresh and calculate the interim difference and add it

i cant do anything until i read the new meter on 1 december , i need to jippo the excel SS so the only way is to reduce her OLD reading , so i want to know if my numbers above are accurate

thanks

 

[icantchooseone]

I feel like I am on drugs...

how can her old meter be on 0447? maybe 1447?

her old reading was 9655 , 1 nov it was 0278

so i make it 10278 so excel can get the difference

normally i would then put 278 as her old reading on 1 dec but she now has a new meter on 0000 today

 

[HAL 9000]

Here's how I would set up the worksheet... separate the months where there is a rollover from 9999 to 0 on any meters during that period & subtotal the combined units for that month...

PS - the #VALUE errors will disappear once you input the December values...



Here are the formulas....

 

[icantchooseone]

Here's how I would set up the worksheet... separate the months where there is a rollover from 9999 to 0 on any meters during that period & subtotal the combined units for that month...

PS - the #VALUE errors will disappear once you input the December values...

View attachment 1952549

Here are the formulas....

View attachment 1952547

thank you , thats a good plan for rollovers

my query for now is just factoring in this new meter and i wasnt sure if my maths was correctly done

 

[HAL 9000]

thank you , thats a good plan for rollovers

my query for now is just factoring in this new meter and i wasnt sure if my maths was correctly done

I have updated my example with the corrected readings for you, so they reflect the correct November totals...

Unit 4 may also need the extra row if it also rolls over to zero before 1 Dec...

 

[HAL 9000]

Here are the updated calculations for Unit 4 if it does roll over to zero during this month...



Here are the formulas...

 

[icantchooseone]

I have updated my example with the corrected readings for you, so they reflect the correct November totals...

Unit 4 may also need the extra row if it also rolls over to zero before 1 Dec...

thanks again

sorry to be a pain but what about the 447 reading taken today on the old removed meter ?

 

[HAL 9000]

thanks again

sorry to be a pain but what about the 447 reading taken today on the old removed meter ?

I will factor that in for you as well & revise the readings / formulas accordingly...

 

[HAL 9000]

Here you go... updated calculations & formulas for Unit 6 - just update it to the actual reading on the yellow shaded row on 1 Dec 26 for the total December consumption figure...



Here are the formulas...

 

[icantchooseone]

Here you go... updated calculations & formulas for Unit 6 - just update it to the actual reading on the yellow shaded row on 1 Dec 26 for the total December consumption figure...

View attachment 1952563

Here are the formulas...

View attachment 1952564

much appreciated !!!!

 

[Steamy Tom]

it clocked over , 9999 to 0000 to 447



i cant do anything until i read the new meter on 1 december , i need to jippo the excel SS so the only way is to reduce her OLD reading , so i want to know if my numbers above are accurate

thanks

ah ok, the 10278 threw me