Calculate the duration between two points in time(day, month & year are used)
From: Day
To: Day
Month
Month
times cal v* divide  kwh
Year
Year
Duration: Days
.
hour
hour
Economy 7 electricity   gas                                    
meter day night                                        
new reading
gas gal v
old reading
total units
converted KWH
                                                                                                                                                                                         
   
 
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
1 2 3 4 5 6 7 8 9 10 11 12
d 1900 1901 1902 1903 1904 1905 1906 1907 1908 1909 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1923 1924 1925 1926 1927 1928 1929 1930 1931 1932 1933 1934 1935 1936 1937 1938 1939 1940 1941 1942 1943 1944 1945 1946 1947 1948 1949 1950 1951 1952 1953 1954 1955 1956 1957 1958 1959 1960
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
electricity
gas
daily charge
daily charge after is
grand total
day night
KWH
price per KWH (price in pence)
more detail  brake down below
daily charge after is
electricity gas
new reading
old reading
total units
converted KWH
day night
KWH
price per KWH (price in pence)
electricity day
night
daily charge after
gas
daily charge after
average use over KWH/UNITS days
electricity day
e day
electricity night
e night
average use over UNITS
gas units
gas units
gas kwh
average use over KWH
gas kwh
electricity day
average spend £
electricity night
electricity day
gas 
  electricity night                      
gas 
electricity
gas
#
KWH  charge at a high price per year
day
night
high low
high low
price per KWH (price in pence)
more detail  brake down below
days since last bill Duration: days
electricity gas
new reading
old reading
total units
converted KWH
average use over   KWH
KWH  charge at a high price per year
electricity high
electricity low
day
night
electricity night
high low
high low
gas high 
gas low 
price per KWH (price in pence)
electricity day
electricity night
gas units
electricity
gas
gas kwh
high
low
average spend  £  
night
£0.00
electricity high
electricity low
electricity night
grand total
gas
gas high
gas low
average use over    KWH/UNITS days
electricity high
electricity low
electricity night
average use over   UNITS
gas units
average use over   KWH
gas high 
gas low 
electricity day
electricity night
gas units
gas kwh
average spend  £  
electricity high
electricity low
electricity night
gas
gas high
gas low
what if. further down the page 
electricity
gas
*
  test 1   grand total                            
  test 1                          
KWH  charge at a high price per year                          
Economy 7 high low night
high low
price per KWH (price in pence)
                      grand total                          
                      main form high & low                        
test 2
electricity
gas
                         
KWH  charge at a high price per year                                  
grand total
Economy 7 high low night
high low
test 2
                         
price per KWH (price in pence)
e
  test 3   electricity   gas                          
                                       
daily charge
grand total
  days           test 3                  
daily charge after
Economy 7 day night
price per KWH (price in pence)
  grand total                      
                      main form daily charge                      
  test 4   electricity   gas                        
daily charge
days
daily charge after
  Economy 7 day night   grand total                        
        test 4                        
price per KWH (price in pence)
                                                 
    grand total of...                                        
  main form high & low e7     main form daily charge e7                                    
test 1 test 2 yours test 3 test 4 yours
total for different company's
what if
high & low daily charge
days
  Economy 7       electricity              
  whit if         day night              
high & low
electricity
day night
gas
new reading
gas gal v
old reading
times cal v* divide  kwh
total units
useful information as a guide
          average use over UNITS days                                  
converted KWH
electricity high
electricity low
electricity night
KWH  charge at a high price per year
gas 
average use over   KWH
gas high 
high low night
high low
gas low 
price per KWH (price in pence)
average spend  £  
electricity high
electricity low
electricity night
total
gas
gas high
gas low
days
  Economy 7                        
  whit if                         
daily charge
electricity
gas
daily charge
daily charge after is
electricity
day night
gas
times cal v* divide  kwh
new reading
old reading
total units
useful information as a guide
average use over   UNITS days
converted KWH
electricity day
electricity night
gas
average use over   KWH
price per KWH (price in pence)
gas
average spend  £  
electricity day
total
electricity night
gas
yearly* discount 2
discount 3
charge 1
ad vat
days *
discount%
 
discount2
xxxx
total bill
please look at NOTES as it IS  more advance. More has to done by you.
notes                                      
days * type in days you looking at
type or copy & paste your readings in red box
discount% to get % EG: 10%. Type in blue box as -0.10
yearly* type in years discount EG £ 8.00
year
discount% 2 discount 2 EG discount for DD
/ dy days of year
yearly*
per day
 days
charge to minus .
EG
to   -  
  info to go in yellow cell.as this is  disount 2                                          
discount% 3 type as minus in the grey box. If there is no discount. Do nothing.
charge 1 type the green box if there no charges do nothing
ad
this for  adjustment if needed. If  keep a recored. EG 0.01 or -0.01 ( font is white)
VAT
MAY be change if vat changes