Spreadsheet: 157261d1337687799-calculate-electric-costs-sample
Sheet: Blad1

Date & Time | MJ | kWh | Costs/h |  |  | Variables
2012-05-15 00:59:59.575000 | 841.43 |  |  |  | Price kWh
2012-05-14 23:59:59.580000 | 858.99 |  |  |  | Day (07:00-23:00) |  | 0.1
2012-05-14 22:59:59.585000 | 865.68 |  |  |  | Night (23:00-07:00) |  | 0.06 |  | Weekend ( Friday 23:00 till Monday 07:00) also night price
2012-05-14 21:59:59.590000 | 873.2 |  |  |  | [NAME] to kWh |  | 3.6
2012-05-14 20:59:59.595000 | 910.41
2012-05-14 19:59:59.600000 | 915
2012-05-14 18:59:59.605000 | 976.45
2012-05-14 17:59:59.610000 | 1033.71
2012-05-14 16:59:59.615000 | 1009.47
2012-05-14 15:59:59.620000 | 968.09
2012-05-14 14:59:59.625000 | 963.91
2012-05-14 13:59:59.630000 | 1002.36
2012-05-14 12:59:59.635000 | 1020.76
2012-05-14 11:59:59.640000 | 901.2
2012-05-14 10:59:59.645000 | 845.62
2012-05-14 09:59:59.650000 | 759.92
2012-05-14 08:59:59.655000 | 737.77
2012-05-14 07:59:59.660000 | 540.89
2012-05-14 06:59:59.665000 | 552.18
2012-05-14 05:59:59.670000 | 540.89
2012-05-14 04:59:59.675000 | 540.47
2012-05-14 03:59:59.680000 | 571.41
2012-05-14 02:59:59.685000 | 589.8
2012-05-14 01:59:59.690000 | 562.62
2012-05-14 00:59:59.695000 | 550.51
2012-05-13 23:59:59.700000 | 606.94
2012-05-13 22:59:59.705000 | 602.75
2012-05-13 21:59:59.710000 | 672.15
2012-05-13 20:59:59.715000 | 705.16
2012-05-13 19:59:59.720000 | 768.7
2012-05-13 18:59:59.725000 | 853.56
2012-05-13 17:59:59.730000 | 916.26
2012-05-13 16:59:59.735000 | 934.64
2012-05-13 15:59:59.740000 | 948.86
2012-05-13 14:59:59.745000 | 1074.26
2012-05-13 13:59:59.750000 | 1523.61
2012-05-13 12:59:59.755000 | 1038.32
2012-05-13 11:59:59.760000 | 1101.01
2012-05-13 10:59:59.765000 | 749.89
2012-05-13 09:59:59.770000 | 677.58
2012-05-13 08:59:59.775000 | 646.64
2012-05-13 07:59:59.780000 | 629.93
2012-05-13 06:59:59.785000 | 678.41
2012-05-13 05:59:59.790000 | 664.62
2012-05-13 04:59:59.795000 | 667.55
2012-05-13 03:59:59.800000 | 684.68
2012-05-13 02:59:59.805000 | 688.87
2012-05-13 01:59:59.810000 | 699.31
2012-05-13 00:59:59.815000 | 711.86
2012-05-12 23:59:59.820000 | 762.85
2012-05-12 22:59:59.825000 | 742.78
2012-05-12 21:59:59.830000 | 826.81
2012-05-12 20:59:59.835000 | 882.81
2012-05-12 19:59:59.840000 | 897.03
2012-05-12 18:59:59.845000 | 884.91
2012-05-12 17:59:59.850000 | 926.28
2012-05-12 16:59:59.855000 | 889.93
2012-05-12 15:59:59.860000 | 918.76
2012-05-12 14:59:59.865000 | 830.98
2012-05-12 13:59:59.870000 | 701.83
2012-05-12 12:59:59.875000 | 692.2
2012-05-12 11:59:59.880000 | 672.15
2012-05-12 10:59:59.885000 | 670.05
2012-05-12 09:59:59.890000 | 595.65
2012-05-12 08:59:59.895000 | 499.51
2012-05-12 07:59:59.900000 | 430.12
2012-05-12 06:59:59.905000 | 430.13
2012-05-12 05:59:59.910000 | 388.74
2012-05-12 04:59:59.915000 | 361.15
2012-05-12 03:59:59.920000 | 380.8
2012-05-12 02:59:59.925000 | 384.56
2012-05-12 01:59:59.930000 | 386.23
2012-05-12 00:59:59.935000 | 400.02
2012-05-11 23:59:59.940000 | 428.45
2012-05-11 22:59:59.945000 | 497.01
2012-05-11 21:59:59.950000 | 543.4
2012-05-11 20:59:59.955000 | 575.16
2012-05-11 19:59:59.960000 | 597.74
2012-05-11 18:59:59.965000 | 609.45
2012-05-11 17:59:59.970000 | 673.4
2012-05-11 16:59:59.975000 | 627.83
2012-05-11 15:59:59.980000 | 590.64
2012-05-11 14:59:59.985000 | 952.2
2012-05-11 13:59:59.990000 | 717.29
2012-05-11 13:00:00 | 727.32
2012-05-11 12:00:00 | 769.12
2012-05-11 11:00:00 | 878.64
2012-05-11 10:00:00 | 809.24
2012-05-11 09:00:00 | 792.53
2012-05-11 08:00:00 | 801.31
2012-05-11 07:00:00 | 636.61
2012-05-11 06:00:00 | 584.37
2012-05-11 05:00:00 | 601.08
2012-05-11 04:00:00 | 622.82
2012-05-11 03:00:00 | 712.27
2012-05-11 02:00:00 | 820.12
2012-05-11 01:00:00 | 841.43
2012-05-11 00:00:00 | 858.99
2012-05-10 23:00:00 | 865.68
2012-05-10 22:00:00 | 873.2
2012-05-10 21:00:00 | 910.41
2012-05-10 20:00:00 | 915
2012-05-10 19:00:00 | 976.45
2012-05-10 18:00:00 | 1033.71
2012-05-10 17:00:00 | 1009.47
2012-05-10 16:00:00 | 968.09
2012-05-10 15:00:00 | 963.91
2012-05-10 14:00:00 | 1002.36
2012-05-10 13:00:00 | 1020.76
2012-05-10 12:00:00 | 901.2
2012-05-10 11:00:00 | 845.62
2012-05-10 10:00:00 | 759.92
2012-05-10 09:00:00 | 737.77
2012-05-10 08:00:00 | 708.51
2012-05-10 07:00:00 | 611.54
2012-05-10 06:00:00 | 540.89
2012-05-10 05:00:00 | 552.18
2012-05-10 04:00:00 | 540.89
2012-05-10 03:00:00 | 540.47
2012-05-10 02:00:00 | 571.41
2012-05-10 01:00:00 | 589.8
2012-05-10 00:00:00 | 562.62
2012-05-09 23:00:00 | 550.51
2012-05-09 22:00:00 | 606.94
2012-05-09 21:00:00 | 602.75
2012-05-09 20:00:00 | 672.15
2012-05-09 19:00:00 | 705.16
2012-05-09 18:00:00 | 768.7
2012-05-09 17:00:00 | 853.56
2012-05-09 16:00:00 | 916.26
2012-05-09 15:00:00 | 934.64
2012-05-09 14:00:00 | 948.86
2012-05-09 13:00:00 | 1074.26
2012-05-09 12:00:00 | 1523.61
2012-05-09 11:00:00 | 1038.32
2012-05-09 10:00:00 | 1101.01
2012-05-09 09:00:00 | 749.89
2012-05-09 08:00:00 | 677.58
2012-05-09 07:00:00 | 646.64
2012-05-09 06:00:00 | 629.93
2012-05-09 05:00:00 | 678.41
2012-05-09 04:00:00 | 664.62
2012-05-09 03:00:00 | 667.55
2012-05-09 02:00:00 | 684.68
2012-05-09 01:00:00 | 688.87
2012-05-09 00:00:00 | 699.31
2012-05-08 23:00:00 | 711.86
2012-05-08 22:00:00 | 762.85
2012-05-08 21:00:00 | 742.78
2012-05-08 20:00:00 | 826.81
2012-05-08 19:00:00 | 882.81
2012-05-08 18:00:00 | 897.03
2012-05-08 17:00:00 | 884.91
2012-05-08 16:00:00 | 926.28
2012-05-08 15:00:00 | 889.93
2012-05-08 14:00:00 | 918.76
2012-05-08 13:00:00 | 830.98
2012-05-08 12:00:00 | 701.83
2012-05-08 11:00:00 | 692.2
2012-05-08 10:00:00 | 672.15
2012-05-08 09:00:00 | 670.05
2012-05-08 08:00:00 | 595.65
2012-05-08 07:00:00 | 499.51
2012-05-08 06:00:00 | 430.12
2012-05-08 05:00:00 | 430.13
2012-05-08 04:00:00 | 388.74
2012-05-08 03:00:00 | 361.15
2012-05-08 02:00:00 | 380.8
2012-05-08 01:00:00 | 384.56
2012-05-08 00:00:00 | 386.23
2012-05-07 23:00:00 | 400.02
2012-05-07 22:00:00 | 428.45
2012-05-07 21:00:00 | 497.01
2012-05-07 20:00:00 | 543.4
2012-05-07 19:00:00 | 575.16
2012-05-07 18:00:00 | 597.74
2012-05-07 17:00:00 | 609.45
2012-05-07 16:00:00 | 673.4
2012-05-07 15:00:00 | 627.83
2012-05-07 14:00:00 | 590.64
2012-05-07 13:00:00 | 952.2
2012-05-07 12:00:00 | 825.13
2012-05-07 11:00:00 | 642.47
2012-05-07 10:00:00 | 575.17
2012-05-07 09:00:00 | 435.97
2012-05-07 08:00:00 | 424.27
2012-05-07 07:00:00 | 450.19
2012-05-07 06:00:00 | 439.73
2012-05-07 05:00:00 | 442.25
2012-05-07 04:00:00 | 440.99
2012-05-07 03:00:00 | 445.17
2012-05-07 02:00:00 | 458.54
2012-05-07 01:00:00 | 452.7
2012-05-07 00:00:00 | 497.42
2012-05-06 23:00:00 | 516.64
2012-05-06 22:00:00 | 525.85
2012-05-06 21:00:00 | 517.9
2012-05-06 20:00:00 | 517.48
2012-05-06 19:00:00 | 526.68
2012-05-06 18:00:00 | 522.09
2012-05-06 17:00:00 | 521.24
2012-05-06 16:00:00 | 536.71
2012-05-06 15:00:00 | 538.39
2012-05-06 14:00:00 | 519.57
2012-05-06 13:00:00 | 545.91
2012-05-06 12:00:00 | 555.1
2012-05-06 11:00:00 | 543.4
2012-05-06 10:00:00 | 519.16
2012-05-06 09:00:00 | 484.04
2012-05-06 08:00:00 | 418.42
2012-05-06 07:00:00 | 372.02
2012-05-06 06:00:00 | 383.73
2012-05-06 05:00:00 | 374.52
2012-05-06 04:00:00 | 368.68
2012-05-06 03:00:00 | 393.76
2012-05-06 02:00:00 | 384.56
2012-05-06 01:00:00 | 382.05
2012-05-06 00:00:00 | 382.89
2012-05-05 23:00:00 | 384.56
2012-05-05 22:00:00 | 388.74
2012-05-05 21:00:00 | 397.93
2012-05-05 20:00:00 | 382.47
2012-05-05 19:00:00 | 385.4
2012-05-05 18:00:00 | 398.77
2012-05-05 17:00:00 | 406.71
2012-05-05 16:00:00 | 423.44
2012-05-05 15:00:00 | 423.85
2012-05-05 14:00:00 | 444.33
2012-05-05 13:00:00 | 432.22
2012-05-05 12:00:00 | 413.4
2012-05-05 11:00:00 | 405.88
2012-05-05 10:00:00 | 408.8
2012-05-05 09:00:00 | 437.23
2012-05-05 08:00:00 | 438.48
2012-05-05 07:00:00 | 516.23
2012-05-05 06:00:00 | 526.26