Spreadsheet: 123846d1317899810-sum-values-based-on-operational-timetable-example
Sheet: Sheet1

 | 1900-01-01 00:00:00 | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00 |  |  | Operational | Non Operational
2009-06-01 00:00:00 | 91.5 | 87.2 | 87.4 | 87.5 | 91.1 | 90.6 | 87.7 | 89.9 | 88.8 | 93.6 | 100 | 108.5 | 157 | 200.7 | 221.1 | 234.4 | 243.7 | 251.8 | 264.7 | 262.6 | 259.9 | 266 | 289.1 | 278.9 | 282.4 | 281.1 | 265 | 279.7 | 268.5 | 264.4 | 258.6 | 233.1 | 179.1 | 165.2 | 154.2 | 159.2 | 133.3 | 129.5 | 95.4 | 78.3 | 90.3 | 88.5 | 78.3 | 89.5 | 87.4 | 77.1 | 86.1 | 85.6
2009-06-02 00:00:00 | 86.7 | 90.8 | 90.3 | 78.4 | 89.6 | 82.9 | 81.6 | 79.4 | 74.9 | 89.5 | 111.9 | 111.7 | 175.2 | 216.8 | 232 | 238.9 | 279.5 | 262.1 | 262.9 | 268.7 | 270.9 | 252 | 256.7 | 244.6 | 243.1 | 260.2 | 261 | 273.6 | 273.3 | 247.4 | 255.9 | 224.5 | 171.9 | 159.4 | 143.4 | 148.8 | 139.9 | 119.1 | 81.9 | 90.7 | 78.4 | 91.9 | 83.7 | 84.5 | 82.1 | 86.6 | 74.6 | 84.7
2009-06-03 00:00:00 | 87.2 | 86.3 | 87.4 | 84 | 96.2 | 80.7 | 86.8 | 85.4 | 75.4 | 98.1 | 108.4 | 130.6 | 179.2 | 221.3 | 231.9 | 264 | 271.1 | 259.9 | 266.3 | 262.4 | 270.7 | 267.7 | 264.5 | 251.1 | 255.7 | 259.5 | 260.7 | 258.9 | 278.1 | 253.8 | 241.5 | 209.9 | 170.8 | 165.3 | 151.9 | 153.5 | 158.6 | 135.7 | 108 | 100.5 | 89 | 103.8 | 104.5 | 93 | 103.7 | 100.7 | 92.2 | 101.3
2009-06-04 00:00:00 | 106.1 | 95.9 | 102.7 | 101.6 | 93.8 | 97.3 | 97.5 | 88.2 | 102.6 | 95.7 | 118.9 | 137.6 | 196.8 | 218.9 | 265.9 | 280.5 | 310.9 | 285.3 | 288.5 | 285.3 | 279.7 | 290.9 | 286.1 | 269.5 | 253.9 | 272.4 | 270.6 | 273.9 | 265.6 | 251.4 | 250.4 | 217.3 | 161.8 | 173.2 | 167.7 | 155.7 | 144.3 | 130.8 | 106.6 | 105 | 97.8 | 107.9 | 105.5 | 107.2 | 102.6 | 107.9 | 99.5 | 96.5
2009-06-05 00:00:00 | 102.4 | 99.9 | 104 | 104.3 | 102.9 | 98.7 | 96.2 | 97.6 | 97.3 | 90.3 | 123.5 | 136.5 | 191.7 | 234.6 | 268.6 | 284.2 | 291.7 | 290 | 287.5 | 273.5 | 261.6 | 263.5 | 252.7 | 264.7 | 260.3 | 223.9 | 240.3 | 199.2 | 177 | 156.3 | 166.9 | 143 | 112.4 | 101.6 | 99.2 | 96.5 | 99.7 | 97.6 | 96.2 | 103.1 | 97.5 | 99.9 | 93.1 | 96.5 | 92.2 | 95.1 | 91.4 | 91.7
2009-06-06 00:00:00 | 104.7 | 102.1 | 101 | 97.9 | 100.7 | 95.6 | 97.1 | 95.4 | 101.6 | 104.5 | 127.2 | 126.6 | 137.5 | 146.1 | 135.4 | 139.5 | 149.6 | 164.3 | 154 | 156 | 143.7 | 138.9 | 135.4 | 135.4 | 110 | 108.3 | 110.8 | 112.8 | 106.9 | 98 | 98.6 | 96.2 | 93.9 | 97 | 85.9 | 87.5 | 97.2 | 94.4 | 88.3 | 86.8 | 88 | 86.9 | 87.9 | 88.3 | 87.1 | 95.2 | 91.7 | 87.5
2009-06-07 00:00:00 | 96.8 | 96.4 | 97.3 | 94.1 | 94.4 | 94.1 | 103.4 | 95.4 | 89.6 | 91.4 | 89.6 | 86.7 | 87.6 | 90.1 | 88.2 | 102.7 | 97.3 | 99.5 | 99.9 | 101.1 | 105.3 | 99.5 | 100 | 104.5 | 105.5 | 106.7 | 98.3 | 101.6 | 99.5 | 102 | 95 | 93.8 | 82.6 | 92 | 90.3 | 83.5 | 85.5 | 80.2 | 88.7 | 83.5 | 86.1 | 84.8 | 94.6 | 87.7 | 88.8 | 89.8 | 87.9 | 86.2
2009-06-08 00:00:00 | 95.9 | 98.4 | 97.5 | 101.6 | 97.1 | 95.4 | 92.2 | 94.9 | 87.4 | 99.2 | 123.4 | 132.7 | 190.1 | 232.7 | 245.3 | 277.1 | 305 | 310.6 | 277.6 | 298.6 | 317.8 | 296.5 | 300.8 | 279.2 | 270.1 | 296.8 | 294.7 | 284.4 | 276.7 | 277 | 284.2 | 248.3 | 184.2 | 157 | 154.9 | 148.4 | 167.7 | 161.6 | 127.6 | 125.3 | 110.6 | 114.2 | 114.9 | 109.8 | 111.6 | 107.5 | 112.2 | 116
2009-06-09 00:00:00 | 99.7 | 94.3 | 122.1 | 121.6 | 107.6 | 108 | 109.1 | 106.3 | 106.1 | 110.9 | 133 | 148.5 | 185.5 | 234.2 | 261.3 | 302.7 | 277.3 | 272.5 | 277 | 298.7 | 308.2 | 298.4 | 288.2 | 282.6 | 245.1 | 254.4 | 283.9 | 257 | 259.6 | 266.7 | 255.5 | 222.3 | 199.1 | 200.2 | 186.3 | 180.8 | 165.9 | 143.7 | 104.3 | 104.8 | 113.5 | 128.7 | 131.1 | 125.6 | 117.6 | 118.1 | 109.6 | 108.8
2009-06-10 00:00:00 | 103.4 | 95.5 | 89.3 | 93 | 110.4 | 130.3 | 127.5 | 110.4 | 103.9 | 110.7 | 133.3 | 152.7 | 186.4 | 239 | 261.3 | 274.7 | 276.2 | 278.1 | 291.1 | 301 | 305.5 | 285.9 | 283.1 | 260.4 | 255.2 | 273.3 | 278.1 | 280.7 | 260.5 | 255.4 | 228.8 | 201.6 | 216.4 | 207.5 | 197.2 | 177.3 | 161.2 | 130.4 | 99 | 105.6 | 132.5 | 133.9 | 113.6 | 115.9 | 123.6 | 123.7 | 99.4 | 100.8
2009-06-11 00:00:00 | 98.3 | 100.5 | 98.9 | 93 | 119.2 | 110.9 | 114.6 | 120.5 | 111.4 | 117.6 | 126.4 | 149.5 | 196.7 | 225.5 | 267 | 282.8 | 314.4 | 307.7 | 312 | 321.3 | 289.1 | 279.9 | 307.4 | 300.8 | 280 | 290.8 | 288.8 | 289.9 | 285.3 | 286.6 | 261 | 217.3 | 176.7 | 188.3 | 202.9 | 194.2 | 172.4 | 150.4 | 126.9 | 127.9 | 119.7 | 114.4 | 111.9 | 113 | 112.7 | 113.3 | 112.4 | 109.6
2009-06-12 00:00:00 | 115.2 | 111.7 | 118 | 111 | 108.5 | 107.2 | 109.5 | 109.5 | 104.2 | 103.4 | 128.2 | 138 | 182.6 | 212 | 252.5 | 269.6 | 279.9 | 279.9 | 283.1 | 289.9 | 287.1 | 298.9 | 294.9 | 266.9 | 254.6 | 279.4 | 269 | 219.6 | 174.7 | 170.8 | 168 | 160.6 | 150.3 | 146.3 | 148.8 | 147.7 | 107.4 | 106.1 | 109 | 106.1 | 105.5 | 110.3 | 97.6 | 111.2 | 96.8 | 105.5 | 101.3 | 100.5
2009-06-13 00:00:00 | 107.2 | 113.5 | 109.6 | 109.3 | 111.2 | 109.8 | 100.5 | 97.3 | 98.4 | 96.8 | 126.1 | 142.8 | 157.9 | 173.1 | 175.9 | 172.4 | 157.9 | 158.7 | 156.2 | 154.1 | 145.8 | 157.2 | 153.9 | 150.3 | 136 | 143.5 | 140.7 | 132.7 | 134.1 | 137.6 | 133.9 | 131.9 | 128.3 | 127.4 | 123.7 | 119.7 | 120.8 | 120.5 | 108.5 | 118.6 | 118.7 | 124.5 | 113.3 | 120.8 | 117.4 | 115.9 | 112 | 109.6
2009-06-14 00:00:00 | 124.5 | 128.3 | 122.9 | 127.5 | 118.9 | 127.9 | 119 | 119.7 | 109.9 | 118.4 | 119.2 | 106.6 | 113.4 | 117.2 | 113.8 | 112.3 | 120.4 | 118.6 | 127.7 | 125.8 | 117 | 108.3 | 99.2 | 110 | 107.5 | 122.1 | 112 | 121.5 | 113.6 | 110.2 | 105.3 | 108.2 | 92.8 | 100.4 | 91.2 | 96.2 | 99.4 | 104 | 88.2 | 96.5 | 93.6 | 97.3 | 101.2 | 95.5 | 97.6 | 101.2 | 93.9 | 87.4
2009-06-15 00:00:00 | 105.2 | 103 | 106 | 107.2 | 105 | 104.8 | 109.1 | 107.4 | 94.2 | 110.3 | 132.4 | 139.2 | 198.2 | 248.7 | 269.3 | 285.9 | 288.2 | 298.1 | 310.7 | 304.4 | 280.8 | 290.4 | 310.4 | 284.3 | 273 | 278.9 | 305.3 | 306.4 | 300.5 | 307.9 | 305.8 | 270.1 | 210.7 | 202.8 | 196.8 | 151.4 | 171.7 | 160.2 | 127 | 118.8 | 128.5 | 126.1 | 114.1 | 120.3 | 122.1 | 110.2 | 109.6 | 106.1
2009-06-16 00:00:00 | 115.2 | 109.5 | 108.8 | 106.9 | 114 | 112.5 | 103.9 | 102.4 | 103.1 | 109.8 | 130 | 144.5 | 218 | 230.7 | 263.2 | 287.4 | 292 | 300.7 | 295.9 | 288.3 | 300 | 302.3 | 298.1 | 275.2 | 274.7 | 293.5 | 300.8 | 295.4 | 307.9 | 306.7 | 281.6 | 260.8 | 235.2 | 225.6 | 217 | 216.8 | 210.3 | 193.6 | 133 | 134 | 126.9 | 129 | 115 | 119.9 | 120.4 | 116 | 114.2 | 114.4
2009-06-17 00:00:00 | 131.1 | 123.7 | 116 | 113.8 | 115.9 | 116 | 107.7 | 107.4 | 107.8 | 109.2 | 138.7 | 161.8 | 217.5 | 251.7 | 270.9 | 295.4 | 310.4 | 310.1 | 312.7 | 326.3 | 326.6 | 327.1 | 321.9 | 309 | 285 | 299.2 | 316.6 | 320.7 | 318.8 | 288.2 | 277.3 | 261.2 | 229 | 222.9 | 206.7 | 201.1 | 187.6 | 174.7 | 134.4 | 133.3 | 132 | 120.5 | 116.4 | 126.3 | 128 | 123.4 | 112.7 | 123
2009-06-18 00:00:00 | 125.2 | 121.9 | 125.2 | 119.7 | 115.7 | 112.3 | 114.8 | 107.8 | 104.5 | 108.8 | 139.9 | 159.1 | 249.6 | 268 | 271.2 | 292.2 | 316.7 | 303 | 318.6 | 289.6 | 307.4 | 321.1 | 300 | 303.4 | 294.1 | 302.6 | 327.2 | 318.3 | 315.9 | 328.5 | 313 | 264.8 | 217.4 | 200.8 | 198.4 | 202.9 | 197.8 | 178.6 | 132 | 128 | 125.6 | 130.4 | 131.7 | 130.7 | 110 | 108.5 | 102 | 107.1
2009-06-19 00:00:00 | 116.6 | 115.1 | 126.1 | 118.3 | 121.1 | 115.1 | 111.9 | 111.4 | 110.1 | 110.9 | 145.6 | 185 | 247.1 | 257.1 | 288.2 | 300.2 | 319.7 | 326 | 304.8 | 281.8 | 322.4 | 320.3 | 277.8 | 265.6 | 269.4 | 286.4 | 254.9 | 230.9 | 201.1 | 195.4 | 202 | 197.9 | 187.9 | 184.5 | 170.6 | 164.6 | 139.7 | 133.6 | 126.3 | 128.8 | 131.7 | 138.4 | 133 | 128.2 | 135.1 | 137.9 | 121.8 | 110
2009-06-20 00:00:00 | 123.7 | 123.2 | 115.1 | 117.5 | 117.3 | 120.4 | 121.8 | 123.9 | 161.8 | 160.2 | 164.5 | 161.9 | 176.4 | 193 | 176.5 | 176.8 | 189.2 | 195.9 | 212.5 | 201.3 | 182.6 | 180.8 | 178.7 | 187.1 | 178.8 | 167.2 | 165.6 | 159.5 | 165 | 155.6 | 160.3 | 167.4 | 163.2 | 159.6 | 157 | 155.7 | 150 | 135.2 | 105.8 | 110.3 | 109 | 109.6 | 107.5 | 124.2 | 117.6 | 120.8 | 124.6 | 128.5
2009-06-21 00:00:00 | 137.6 | 117.9 | 115.1 | 121.3 | 116.8 | 110.1 | 108.5 | 120.3 | 164.7 | 158.6 | 157.8 | 151.7 | 161.2 | 154.4 | 139.7 | 141 | 143.9 | 147.9 | 152 | 145 | 169.8 | 170.3 | 158.6 | 164.5 | 163.2 | 165.1 | 159.4 | 147.8 | 125.3 | 118.7 | 140.5 | 131.4 | 144.2 | 150.3 | 152.4 | 152.6 | 141.3 | 143.9 | 133.1 | 127.9 | 127.7 | 123 | 126.3 | 127.4 | 123.7 | 135.4 | 140.4 | 137.8
2009-06-22 00:00:00 | 151.1 | 148.2 | 151.2 | 142.6 | 139.4 | 136.7 | 124.7 | 125.6 | 145 | 165 | 146.6 | 162.4 | 238.8 | 276.2 | 290.3 | 310.6 | 295.5 | 306.9 | 309.1 | 308.8 | 326.1 | 325.3 | 328.2 | 314.6 | 286.7 | 278.4 | 318.8 | 322.3 | 331.7 | 318 | 290.9 | 265.8 | 227.9 | 210.4 | 204.8 | 197.6 | 186.4 | 167.4 | 126 | 123.2 | 110.9 | 104.4 | 105.5 | 107.4 | 102.9 | 105.6 | 126.8 | 124
2009-06-23 00:00:00 | 131.2 | 120.2 | 107.2 | 120.7 | 112.5 | 100.8 | 112.8 | 105.2 | 110.1 | 106.3 | 134.4 | 154.4 | 212.4 | 246.6 | 302.9 | 317.8 | 317.8 | 322.9 | 331.1 | 328.2 | 324.2 | 314.7 | 328.2 | 314.9 | 301.5 | 319.4 | 336.2 | 332.5 | 334.7 | 330.3 | 317.5 | 268.3 | 230.7 | 214.8 | 205.6 | 205 | 206.7 | 190.6 | 146.9 | 143.4 | 144.7 | 137.3 | 153.3 | 148.7 | 149.5 | 148.7 | 148.2 | 136.7
2009-06-24 00:00:00 | 153.6 | 160.3 | 161.6 | 157.3 | 160.3 | 141.2 | 147.4 | 135.2 | 140.8 | 142.3 | 157.1 | 169.5 | 243.1 | 274.9 | 291.4 | 302 | 306.1 | 309 | 324.6 | 311.6 | 329.9 | 315.2 | 320.2 | 299.6 | 277.6 | 304.2 | 311.5 | 323.6 | 320 | 320 | 316.5 | 269.6 | 219.7 | 212.2 | 203.9 | 201.9 | 197 | 181.8 | 156.5 | 157.5 | 146.4 | 142.8 | 138.6 | 148.3 | 132.5 | 126.3 | 124.3 | 133.3
2009-06-25 00:00:00 | 134.4 | 132.3 | 137.1 | 150.4 | 141.2 | 143.2 | 141 | 141.8 | 146 | 151.7 | 144.2 | 153.5 | 237.6 | 263.2 | 275.2 | 314.8 | 323.5 | 334.7 | 329.2 | 330.6 | 325.8 | 328.4 | 310.6 | 302.3 | 300.5 | 311.2 | 318.9 | 337.8 | 338.4 | 331.9 | 300.7 | 279.2 | 233.6 | 220.6 | 210.3 | 203.9 | 185.6 | 170.3 | 147.9 | 151.2 | 160.5 | 157.8 | 152.2 | 165.4 | 161.3 | 151.2 | 143.5 | 133.6
2009-06-26 00:00:00 | 145.6 | 143.7 | 139.9 | 148 | 139.2 | 153.9 | 139.6 | 150.7 | 144 | 158.6 | 165.3 | 179.5 | 227.1 | 250.9 | 266.4 | 289.8 | 294.9 | 315.4 | 312.6 | 309 | 314.9 | 321.6 | 307.4 | 295.4 | 285.9 | 281 | 263.1 | 238.6 | 181.8 | 176.7 | 177 | 175.9 | 166.1 | 164.3 | 162.9 | 161.9 | 148.4 | 137.1 | 130.4 | 137.9 | 132.8 | 134.8 | 141.6 | 142.7 | 140.8 | 139.9 | 135.7 | 138.7