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
                               
electricity
gas
standard                          
meter   gas gal v                        
new reading
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
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
e
KWH  charge at a high price per year
grand total
KWH
price per KWH (price in pence)
more detail  brake down below
g
new reading
old reading
total units
converted KWH
KWH  charge at a high price per year
electricity
gas
KWH
*
price per KWH (price in pence)
electricity
gas
high
low
e high
grand total
e low
g high
g low
average use over   KWH days
electricity high
electricity high
electricity
electricity low
electricity low
gas units
gas high
gas high
gas kwh
gas low
gas low
average spend  £  
electricity kwh
electricity
electricity kwh/units
gas kwh
gas
gas units
gas kwh
average spend  £  
electricity
gas
average spend  £  
electricity
gas
electricity
gas
*
 
daily charge
grand total
KWH
price per KWH (price in pence)                              
more detail  brake down below
daily charge after is
new reading
old reading
total units
converted KWH
KWH
price per KWH (price in pence)
electricity
£0.00
daily charge after
gas
daily charge after
average use over KWH days
electricity 
gas units
gas kwh
average spend £
electricity
gas 
what if. further down the page 
  test 5   electricity   gas                                                                                       *          
  grand total                                                                                              
KWH  charge at a high price per year
test 5
  standard high low   high low                                                                                        
price per KWH (price in pence)
grand total
main form high & low
  test 6   electricity   gas                                                                                          
KWH  charge at a high price per year
  grand total                                                                                      
  standard high low   high low   test 6                                                                                      
price per KWH (price in pence)
                                                                                                     
  test 7   electricity   gas                                                                                          
  grand total                                                                                          
  daily charge     test 7                                                                                      
days
daily charge after
                                                                                               
  standard                                                                                          
price per KWH (price in pence)     grand total                                                                                          
      main form daily charge                                                                                          
  test 8   electricity   gas                                                                                          
  daily charge     grand total                                                                                      
  days   test 8                                                                                  
daily charge after
                                                                                               
  standard                                                                                                    
                                                                                                   
price per KWH (price in pence)
grand total of...
main form high & low stand main form daily charge stand.                                                                                          
test 5 test 6 yours test 7 test 8 yours
total for different company's
what if
high & low daily charge
.
days
KWH  charge at a high price per year
electricity
standard
useful information as a guide
day night
average use over UNITS
high & low
electricity units
what if
gas units
cal v* divide  kwh
converted KWH
electricity high KWH
electricity low
gas high
price per KWH (price in pence)
gas low
electricity kwh
gas kwh
average spend  £  
electricity
gas
days
daily charge
days
useful information as a guide
daily charge after
average use over UNITS
electricity units
standard
gas units
daily charge
electricity  kwh KWH
whit if
gas kwh
converted KWH
average spend £
electricity
gas 
price per KWH (price in pence)
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
discount 2
discount% 2 discount 2 EG discount for DD
year
yearly*
/ dy days of year
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