Spreadsheet: 869370d1715946057-averageif-criteria-with-less-that-but-great-than-column-reference-file-1
Sheet: 2019

 | Column1 | Column2 | Column3 | Column4 |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column1 | Column2
 | MTU (CET/CEST) | Day-ahead Price [EUR/MWh] | Currency | BZN|FI |  |  |  | MTU | Biomass  - Actual Aggregated [MW] | [NAME] coal/Lignite  - Actual Aggregated [MW] | [NAME] gas  - Actual Aggregated [MW] | [NAME] Aggregated [MW] | Fossil Hard coal  - Actual Aggregated [MW] | [NAME] Aggregated [MW] | [NAME] shale  - Actual Aggregated [MW] | [NAME] Aggregated [MW] | Geothermal  - Actual Aggregated [MW] | Hydro Pumped Storage  - Actual Aggregated [MW] | Hydro Pumped Storage  - Actual Consumption [MW] | [NAME] and poundage  - Actual Aggregated [MW] | Hydro Water Reservoir  - Actual Aggregated [MW] | Marine  - Actual Aggregated [MW] | Nuclear  - Actual Aggregated [MW] | Other  - Actual Aggregated [MW] | Other renewable  - Actual Aggregated [MW] | Solar  - Actual Aggregated [MW] | Waste  - Actual Aggregated [MW] | Wind Offshore  - Actual Aggregated [MW] | Wind Onshore  - Actual Aggregated [MW] | Capacity factor wind | Production Type | 2019 [MW]
1 | 01.01.2019 00:00 - 01.01.2019 01:00 | 28.32 | EUR |  | 0.1 |  |  | 01.01.2019 00:00 - 01.01.2019 01:00 (CET/CEST) | 848 | n/e | n/e | 548 | 711 | 1 | n/e | 532 | n/e | n/e | n/e | 595 | n/e | n/e | 2799 | 84 | 40 | n/e | 62 | n/e | 1468 |  | Biomass | 1804
2 | 01.01.2019 01:00 - 01.01.2019 02:00 | 10.07 | EUR |  | 0.2 |  |  | 01.01.2019 01:00 - 01.01.2019 02:00 (CET/CEST) | 832 | n/e | n/e | 571 | 707 | 1 | n/e | 518 | n/e | n/e | n/e | 566 | n/e | n/e | 2798 | 81 | 40 | n/e | 61 | n/e | 1427 |  | [NAME] coal/Lignite | n/e
3 | 01.01.2019 02:00 - 01.01.2019 03:00 | 10.03 | EUR |  | 0.3 |  |  | 01.01.2019 02:00 - 01.01.2019 03:00 (CET/CEST) | 826 | n/e | n/e | 549 | 709 | 1 | n/e | 511 | n/e | n/e | n/e | 520 | n/e | n/e | 2799 | 78 | 40 | n/e | 61 | n/e | 1352 |  | [NAME] gas | n/e
4 | 01.01.2019 03:00 - 01.01.2019 04:00 | 4.56 | EUR |  | 0.4 |  |  | 01.01.2019 03:00 - 01.01.2019 04:00 (CET/CEST) | 825 | n/e | n/e | 531 | 706 | 1 | n/e | 504 | n/e | n/e | n/e | 539 | n/e | n/e | 2799 | 78 | 40 | n/e | 63 | n/e | 1177 |  | Fossil Gas | 1912
5 | 01.01.2019 04:00 - 01.01.2019 05:00 | 4.83 | EUR |  | 0.5 |  |  | 01.01.2019 04:00 - 01.01.2019 05:00 (CET/CEST) | 831 | n/e | n/e | 536 | 705 | 1 | n/e | 501 | n/e | n/e | n/e | 568 | n/e | n/e | 2799 | 76 | 40 | n/e | 63 | n/e | 1001 |  | Fossil Hard coal | 2278
6 | 01.01.2019 05:00 - 01.01.2019 06:00 | 8.09 | EUR |  | 0.6 |  |  | 01.01.2019 05:00 - 01.01.2019 06:00 (CET/CEST) | 824 | n/e | n/e | 546 | 710 | 1 | n/e | 517 | n/e | n/e | n/e | 595 | n/e | n/e | 2799 | 75 | 40 | n/e | 62 | n/e | 826 |  | [NAME] | 1434
7 | 01.01.2019 06:00 - 01.01.2019 07:00 | 25.54 | EUR |  | 0.7 |  |  | 01.01.2019 06:00 - 01.01.2019 07:00 (CET/CEST) | 829 | n/e | n/e | 608 | 728 | 1 | n/e | 539 | n/e | n/e | n/e | 606 | n/e | n/e | 2799 | 75 | 41 | n/e | 62 | n/e | 642 |  | [NAME] shale | n/e
8 | 01.01.2019 07:00 - 01.01.2019 08:00 | 39.16 | EUR |  | 0.8 |  |  | 01.01.2019 07:00 - 01.01.2019 08:00 (CET/CEST) | 821 | n/e | n/e | 651 | 764 | 1 | n/e | 545 | n/e | n/e | n/e | 734 | n/e | n/e | 2799 | 75 | 42 | n/e | 62 | n/e | 423 |  | [NAME] | 1135
9 | 01.01.2019 08:00 - 01.01.2019 09:00 | 37.66 | EUR |  | 0.9 |  |  | 01.01.2019 08:00 - 01.01.2019 09:00 (CET/CEST) | 810 | n/e | n/e | 641 | 777 | 1 | n/e | 543 | n/e | n/e | n/e | 931 | n/e | n/e | 2799 | 75 | 42 | n/e | 61 | n/e | 284 |  | Geothermal | n/e
10 | 01.01.2019 09:00 - 01.01.2019 10:00 | 21.52 | EUR |  | 1 |  |  | 01.01.2019 09:00 - 01.01.2019 10:00 (CET/CEST) | 816 | n/e | n/e | 600 | 779 | 1 | n/e | 540 | n/e | n/e | n/e | 899 | n/e | n/e | 2799 | 75 | 42 | n/e | 61 | n/e | 247 |  | Hydro Pumped Storage | n/e
11 | 01.01.2019 10:00 - 01.01.2019 11:00 | 28.25 | EUR |  |  |  |  | 01.01.2019 10:00 - 01.01.2019 11:00 (CET/CEST) | 824 | n/e | n/e | 604 | 770 | 1 | n/e | 546 | n/e | n/e | n/e | 969 | n/e | n/e | 2800 | 75 | 42 | n/e | 62 | n/e | 259 |  | [NAME] and poundage | 3148
12 | 01.01.2019 11:00 - 01.01.2019 12:00 | 19.29 | EUR |  |  |  |  | 01.01.2019 11:00 - 01.01.2019 12:00 (CET/CEST) | 826 | n/e | n/e | 600 | 771 | 1 | n/e | 549 | n/e | n/e | n/e | 1068 | n/e | n/e | 2798 | 75 | 42 | n/e | 62 | n/e | 346 |  | Hydro Water Reservoir | n/e