quintel / etmodel

Professional interface of the Energy Transition model.
https://energytransitionmodel.com/
MIT License
33 stars 14 forks source link

"More..." link on http://et-model.com/scenarios does not work after first hit. #1321

Closed dennisquintel closed 11 years ago

dennisquintel commented 11 years ago

Should be fixed on live too.

jastix commented 11 years ago

error:

Processing by ScenariosController#index as JS
  Parameters: {"page"=>"3"}
  Rendered scenarios/_scenarios_slice.html.haml (12.1ms)
  Rendered scenarios/index.js.erb (12.7ms)
Completed 500 Internal Server Error in 892ms

ActionView::Template::Error (can't convert nil into String):
    3:     %td= check_box_tag 'scenario_ids[]', scenario.id
    4:     %td= link_to scenario.title, "/scenarios/#{scenario.id}"
    5:     %td= scenario.end_year
    6:     %td= scenario.parsed_created_at.andand.strftime("%d %b %H:%M")
    7:     - if scenario.created_at.to_date < Date.parse("2012-8-28")
    8:       %td= link_to t('scenario.load'), load_scenario_path(scenario), :confirm => t("scenario.warning")
    9:     - else
  app/models/api/scenario.rb:14:in `parse'
  app/models/api/scenario.rb:14:in `parsed_created_at'
  app/views/scenarios/_scenarios_slice.html.haml:6:in `block in _app_views_scenarios__scenarios_slice_html_haml__960479914_109483670'
  app/views/scenarios/_scenarios_slice.html.haml:1:in `each'
  app/views/scenarios/_scenarios_slice.html.haml:1:in `_app_views_scenarios__scenarios_slice_html_haml__960479914_109483670'
  app/views/scenarios/index.js.erb:1:in `_app_views_scenarios_index_js_erb___41214309_109488540'
  app/controllers/scenarios_controller.rb:19:in `index'
dennisquintel commented 11 years ago

Do we need to fix some records in the database?

jastix commented 11 years ago

this scenario breaks live server:

1.9.3 (main):0 > Api::Scenario.find(139197)
=> #<Api::Scenario:0x007faba1b62200
 @attributes=
  {"id"=>139197,
   "title"=>"Watt Nu 2013 - Sander Lensink",
   "area_code"=>"nl",
   "end_year"=>2030,
   "url"=>"http://etengine.dev/api/v3/scenarios/139197",
   "ordering"=>nil,
   "source"=>nil,
   "template"=>nil,
   "created_at"=>nil},
 @persisted=true,
 @prefix_options={}>

beta is ok. I exported both databases to my local machine and there is a 'created_at' field which in not empty.

dennisquintel commented 11 years ago

What part should be changed (into what) to make it work again?

jastix commented 11 years ago

this:

"created_at"=>nil

should be like this:

"created_at"=>"2013-02-15T13:54:50+02:00"
dennisquintel commented 11 years ago

Where? created_at is not nil on etengine: http://cl.ly/image/1d2B1P3M0K3E

On Thu, Apr 4, 2013 at 11:14 AM, Nikolay Petrachkov < notifications@github.com> wrote:

this:

"created_at"=>nil

should be like this:

"created_at"=>"2013-02-15T13:54:50+02:00"

— Reply to this email directly or view it on GitHubhttps://github.com/quintel/etmodel/issues/1321#issuecomment-15887096 .

Dennis Schoenmakers

Quintel Intelligence Atrium - Strawinskylaan 3051 1077 ZX Amsterdam The Netherlands

T : +31 (0)20 301 22 69 F : +31 (0)20 301 22 02 M : +31 (0)6 109 65 293

E : dennis.schoenmakers@quintel.com I : www.quintel.com and www.energytransitionmodel.com

This message (including any attachments) is confidential and may be privileged. Any review, retransmission, dissemination or other use of, or taking any action with reference to this information by persons other than the intended recipient is strictly prohibited. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Please note that e-mails are susceptible to change. The sender will not accept liability for the improper or incomplete transmission of the information contained in this message.

**

jastix commented 11 years ago

possibly that scenarios with ids:

have the same problem (i checked several of them and 'created_at' is nil). They all were added to etsource as presets.

dennisquintel commented 11 years ago

Apparently, there is an issue with scenarios that exist both in the database table 'scenarios' and in the presets in ETSource.

E.g. Preset does not have an attribute created_at, so it's cast as nil in the Preset#to_scenario method.

We should therefor delete all Preset scenarios from the database when they have been added.

dennisquintel commented 11 years ago

Deleted records:

INSERT INTO `scenarios` (`id`, `author`, `title`, `description`, `created_at`, `updated_at`, `user_values`, `end_year`, `in_start_menu`, `user_id`, `preset_scenario_id`, `use_fce`, `present_updated_at`, `protected`, `area_code`, `source`, `balanced_values`)
VALUES
    (80, NULL, 'Watt Nu - Jolande Sap', '<span class=\'nl\'>\nDit scenario is gemaakt door Jolande Sap (Lijsttrekker GroenLinks) voor het televisieprogramma \'Watt Nu?!\'. Als u dit scenario opent kunt u zien welke instellingen Mevr. Sap gedaan heeft. De uitzending zelf kunt u nakijken op <a href=\'http://rtl.nl/xl/#/u/32f8fbaf-fbc2-30b0-9762-435bdae07afa\' target=\'_new\'>RTL XL</a>\n</span>\n<span class=\'en\'>\nThis scenario has been made by Jolande Sap (Political leader GroenLinks) for the TV show \'Watt Nu?!\'. When you open this scenario you can see all the measures that Ms. Sap took for his scenario. The show itself can be seen on <a href=\'http://rtl.nl/xl/#/u/32f8fbaf-fbc2-30b0-9762-435bdae07afa\' target=\'_new\'>RTL XL</a>\n</span>\n', '2012-03-01 12:52:33', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, 1, NULL, NULL, 0, '2012-07-11 15:25:34', NULL, 'nl', NULL, '--- {}\n\n'),
    (81, NULL, 'Watt Nu - Hans Alders', '<span class=\'nl\'>\nDit scenario is gemaakt door Hans Alders (Bestuursvoorzitter Energie Nederland) voor het televisieprogramma \'Watt Nu?!\'. Als u dit scenario opent kunt u zien welke instellingen Dhr. Alders gedaan heeft. De uitzending zelf kunt u nakijken op <a href=\'http://rtl.nl/xl/#/u/32f8fbaf-fbc2-30b0-9762-435bdae07afa\' target=\'blank\'>RTL XL</a>\n</span>\n<span class=\'en\'>\nThis scenario has been made by Hans Alders (Director of Energie Nederland) for the TV show \'Watt Nu?!\'. When you open this scenario you can see all the measures that Mr. Alders took for his scenario. The show itself can be seen on <a href=\'http://rtl.nl/xl/#/u/32f8fbaf-fbc2-30b0-9762-435bdae07afa\' target=\'blank\'>RTL XL</a>\n</span>\n', '2012-03-06 10:38:31', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, 1, NULL, NULL, 0, '2012-07-11 12:58:02', NULL, 'nl', NULL, '--- {}\n\n'),
    (82, NULL, 'Watt Nu - Vera Dalm', '<span class=\'nl\'>\nDit scenario is gemaakt door <a href=\'http://wattnu.nl/guest/Vera%20Dalm\' target=\'blank\'>Vera Dalm</a> (Directeur Milieu Centraal) voor het televisieprogramma \'Watt Nu?!\'. Als u dit scenario opent kunt u zien welke keuzes Mevr. Dalm gemaakt heeft voor Nederland in 2030. De uitzending zelf kunt u nakijken op <a href=\'http://rtl.nl/xl/#/u/9e5b7b8d-c883-31c3-af2c-dbc65fcc299f\' target=\'blank\'>RTL XL</a>\n</span>\n<span class=\'en\'>\nThis scenario has been made by <a href=\'http://wattnu.nl/guest/Vera%20Dalm\' target=\'blank\'>Vera Dalm</a> (Director of Milieu Centraal) for the TV show \'Watt Nu?!\'. When you open this scenario you can see the choices that Mrs. Dalm made for the Netherlands in 2030. The show itself can be seen on <a href=\'http://rtl.nl/xl/#/u/9e5b7b8d-c883-31c3-af2c-dbc65fcc299f\' target=\'blank\'>RTL XL</a>\n</span>\n\n', '2012-03-13 10:23:51', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, 1, NULL, NULL, 0, '2012-07-10 15:12:56', NULL, 'nl', NULL, '--- {}\n\n'),
    (84, NULL, 'Watt Nu - Stef Kranendijk', '<span class=\'nl\'>\nDit scenario is gemaakt door <a href=\'http://wattnu.nl/guest/Stef%20Kranendijk\' target=\'blank\'>Stef Kranendijk</a> (CEO Desso) voor het televisieprogramma \'Watt Nu?!\'. Als u dit scenario opent kunt u zien welke keuzes Dhr. Kranendijk gemaakt heeft voor Nederland in 2030. De uitzending zelf kunt u nakijken op <a href=\'http://rtl.nl/xl/#/u/9e5b7b8d-c883-31c3-af2c-dbc65fcc299f\' target=\'blank\'>RTL XL</a>\n\n</span>\n<span class=\'en\'>\nThis scenario has been made by <a href=\'http://wattnu.nl/guest/Stef%20Kranendijk\' target=\'blank\'>Stef Kranendijk</a> (CEO of Desso) for the TV show \'Watt Nu?!\'. When you open this scenario you can see the choices that Mr. Kranendijk made for the Netherlands in 2030. The show itself can be seen on <a href=\'http://rtl.nl/xl/#/u/9e5b7b8d-c883-31c3-af2c-dbc65fcc299f\' target=\'blank\'>RTL XL</a>\n\n</span>\n\n', '2012-03-05 16:53:58', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, 1, NULL, NULL, 0, '2012-07-10 15:12:56', NULL, 'nl', NULL, '--- {}\n\n'),
    (85, NULL, 'Watt Nu - Marco Witschge', '<span class=\'nl\'>\nDit scenario is gemaakt door <a href=\'http://wattnu.nl/guest/Marco%20Witschge\' target=\'blank\'>Marco Witschge</a> (Directeur Stichting Nederland Krijgt Nieuwe Energie) voor het televisieprogramma \'Watt Nu?!\'. Als u dit scenario opent kunt u zien welke keuzes Dhr. Witschge gemaakt heeft voor Nederland in 2030. De uitzending zelf kunt u nakijken op <a href=\'http://rtl.nl/xl/#/u/0771fa47-7762-3692-9cf2-74a038958737\' target=\'blank\'>RTL XL</a>\n</span>\n<span class=\'en\'>\nThis scenario has been made by <a href=\'http://wattnu.nl/guest/Marco%20Witschge\' target=\'blank\'>Marco Witschge</a> (Director of Stichting Nederland Krijgt Nieuwe Energie) for the TV show \'Watt Nu?!\'. When you open this scenario you can see the choices that Mr. Witschge made for the Netherlands in 2030. The show itself can be seen on <a href=\'http://rtl.nl/xl/#/u/0771fa47-7762-3692-9cf2-74a038958737\' target=\'blank\'>RTL XL</a>\n</span>\n\n', '2012-03-06 13:55:42', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, 1, NULL, NULL, 0, '2012-07-10 15:12:56', NULL, 'nl', NULL, '--- {}\n\n'),
    (86, NULL, 'Watt Nu - Rene Leegte', '<span class=\'nl\'>\nDit scenario is gemaakt door <a href=\'http://wattnu.nl/guest/René%20Leegte\' target=\'blank\'>René Leegte</a> (Tweede Kamerlid VVD) voor het televisieprogramma \'Watt Nu?!\'. Als u dit scenario opent kunt u zien welke keuzes Dhr. Leegte gemaakt heeft voor Nederland in 2030. De uitzending zelf kunt u nakijken op <a href=\'http://rtl.nl/xl/#/u/0771fa47-7762-3692-9cf2-74a038958737\' target=\'blank\'>RTL XL</a>\n</span>\n<span class=\'en\'>\nThis scenario has been made by <a href=\'http://wattnu.nl/guest/René%20Leegte\' target=\'blank\'>René Leegte</a> (Member of parliament for VVD) for the TV show \'Watt Nu?!\'. When you open this scenario you can see the choices that Mr. Leegte made for the Netherlands in 2030. The show itself can be seen on <a href=\'http://rtl.nl/xl/#/u/0771fa47-7762-3692-9cf2-74a038958737\' target=\'blank\'>RTL XL</a>\n</span>\n\n', '2012-03-08 13:03:10', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, 1, NULL, NULL, 0, '2012-07-10 15:12:56', NULL, 'nl', NULL, '--- {}\n\n'),
    (87, NULL, 'Watt Nu - Pier Vellinga', '<span class=\'nl\'>\nDit scenario is gemaakt door <a href=\'http://wattnu.nl/guest/Pier%20Vellinga\' target=\'blank\'>Pier Vellinga</a> (Klimaatwetenschapper Universiteit Wageningen) voor het televisieprogramma \'Watt Nu?!\'. Als u dit scenario opent kunt u zien welke keuzes Dhr. Vellinga gemaakt heeft voor Nederland in 2030. De uitzending zelf kunt u nakijken op <a href=\'http://rtl.nl/xl/#/u/6cd6cd41-2f6e-3a85-97d2-fb33049d896d\' target=\'blank\'>RTL XL</a>.\n</span>\n<span class=\'en\'>\nThis scenario has been made by <a href=\'http://wattnu.nl/guest/Pier%20Vellinga\' target=\'blank\'>Pier Vellinga</a> (Climate scientist at University of Wageningen) for the TV show \'Watt Nu?!\'. When you open this scenario you can see the choices that Mr. Vellinga made for the Netherlands in 2030. The show itself can be seen on <a href=\'http://rtl.nl/xl/#/u/6cd6cd41-2f6e-3a85-97d2-fb33049d896d\' target=\'blank\'>RTL XL</a>.\n</span>', '2012-03-29 09:35:41', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, 1, NULL, NULL, 0, '2012-07-10 15:12:56', NULL, 'nl', NULL, '--- {}\n\n'),
    (88, NULL, 'Watt Nu - Richard Kooloos', '<span class=\'nl\'>\nDit scenario is gemaakt door <a href=\'http://wattnu.nl/guest/Richard%20Kooloos\' target=\'blank\'>Richard Kooloos</a> (Directeur Duurzame Ontwikkeling, ABN AMRO) voor het televisieprogramma \'Watt Nu?!\'. Als u dit scenario opent kunt u zien welke keuzes Dhr. Kooloos gemaakt heeft voor Nederland in 2030. De uitzending zelf kunt u nakijken op <a href=\'http://rtl.nl/xl/#/u/6cd6cd41-2f6e-3a85-97d2-fb33049d896d\' target=\'blank\'>RTL XL</a>.\n</span>\n\n<span class=\'en\'>\nThis scenario has been made by <a href=\'http://wattnu.nl/guest/Richard%20Kooloos\' target=\'blank\'>Richard Kooloos</a> (Director Sustainable Development at ABN AMRO) for the TV show \'Watt Nu?!\'. When you open this scenario you can see the choices that Mr. Kooloos made for the Netherlands in 2030. The show itself can be seen on <a href=\'http://rtl.nl/xl/#/u/6cd6cd41-2f6e-3a85-97d2-fb33049d896d\' target=\'blank\'>RTL XL</a>.\n</span>', '2012-04-04 13:21:54', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, 1, NULL, NULL, 0, '2012-07-10 15:12:56', NULL, 'nl', NULL, '--- {}\n\n'),
    (89, NULL, 'Watt Nu - Gertjan Lankhorst', '<span class=\'nl\'>\nDit scenario is gemaakt door <a href=\'http://wattnu.nl/guest/Gertjan%20Lankhorst\' target=\'blank\'>Gertjan Lankhorst</a> (CEO GasTerra) voor het televisieprogramma \'Watt Nu?!\'. Als u dit scenario opent kunt u zien welke keuzes Dhr. Lankhorst gemaakt heeft voor Nederland in 2030. De uitzending zelf kunt u nakijken op <a href=\'http://www.rtl.nl/xl/#/u/707b4f2a-b209-3a03-b654-4e788b8418b3\' target=\'blank\'>RTL XL</a>.\n</span>\n\n<span class=\'en\'>\nThis scenario has been made by <a href=\'http://wattnu.nl/guest/Gertjan%20Lankhorst\' target=\'blank\'>Gertjan Lankhorst</a> (CEO GasTerra) for the TV show \'Watt Nu?!\'. When you open this scenario you can see the choices that Mr. Lankhorst made for the Netherlands in 2030. The show itself can be seen on <a href=\'http://www.rtl.nl/xl/#/u/707b4f2a-b209-3a03-b654-4e788b8418b3\' target=\'blank\'>RTL XL</a>.\n</span>', '2012-04-04 13:21:54', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, 1, NULL, NULL, 0, '2012-07-10 15:12:56', NULL, 'nl', NULL, '--- {}\n\n'),
    (90, NULL, 'Watt Nu - Peter Molengraaf', '<span class=\'nl\'>\nDit scenario is gemaakt door <a href=\'http://wattnu.nl/guest/Peter%20Molengraaf\' target=\'blank\'>Peter Molengraaf</a> (CEO Liander) voor het televisieprogramma \'Watt Nu?!\'. Als u dit scenario opent kunt u zien welke keuzes Dhr. Molengraaf gemaakt heeft voor Nederland in 2030. De uitzending zelf kunt u nakijken op <a href=\'http://www.rtl.nl/xl/#/u/707b4f2a-b209-3a03-b654-4e788b8418b3\' target=\'blank\'>RTL XL</a>.\n</span>\n<span class=\'en\'>\nThis scenario has been made by <a href=\'http://wattnu.nl/guest/Peter%20Molengraaf\' target=\'blank\'>Peter Molengraaf</a> (CEO Liander) for the TV show \'Watt Nu?!\'. When you open this scenario you can see the choices that Mr. Molengraaf made for the Netherlands in 2030. The show itself can be seen on <a href=\'http://www.rtl.nl/xl/#/u/707b4f2a-b209-3a03-b654-4e788b8418b3\' target=\'blank\'>RTL XL</a>.\n</span>', '2012-04-04 13:21:54', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, 1, NULL, NULL, 0, '2012-07-11 12:40:56', NULL, 'nl', NULL, '--- {}\n\n'),
    (91, NULL, 'Watt Nu - Bernhard Fortuyn', '<span class=\'nl\'>\nDit scenario is gemaakt door <a href=\'http://wattnu.nl/guest/Bernard%20Fortuyn\' target=\'blank\'>Bernard Fortuyn</a> (Directeur Sector Energie bij Siemens Nederland) voor het televisieprogramma \'Watt Nu?!\'. Als u dit scenario opent kunt u zien welke keuzes Dhr. Fortuyn gemaakt heeft voor Nederland in 2030. De uitzending zelf kunt u nakijken op <a href=\'http://rtl.nl/xl/#/u/68d966a0-4371-34f7-b45a-ab843d550605\' target=\'blank\'>RTL XL</a>.\n</span>\n\n<span class=\'en\'>\nThis scenario has been made by <a href=\'http://wattnu.nl/guest/Bernard%20Fortuyn\' target=\'blank\'>Bernard Fortuyn</a> (CEO Sector Energy at Siemens Netherlands) for the TV show \'Watt Nu?!\'. When you open this scenario you can see the choices that Mr. Fortuyn made for the Netherlands in 2030. The show itself can be seen on <a href=\'http://rtl.nl/xl/#/u/68d966a0-4371-34f7-b45a-ab843d550605\' target=\'blank\'>RTL XL</a>.\n</span>', '2012-03-19 11:00:43', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, 1, NULL, NULL, 0, '2012-07-11 10:33:18', NULL, 'nl', NULL, '--- {}\n\n'),
    (92, NULL, 'Watt Nu - Anniek Mauser', '<span class=\'nl\'>\nDit scenario is gemaakt door <a href=\'http://wattnu.nl/guest/Anniek%20Mauser\' target=\'blank\'>Anniek Mauser</a> (Manager Duurzaamheid bij Unilever Benelux) voor het televisieprogramma \'Watt Nu?!\'. Als u dit scenario opent kunt u zien welke keuzes Mevr. Mauser gemaakt heeft voor Nederland in 2030. De uitzending zelf kunt u nakijken op <a href=\'http://rtl.nl/xl/#/u/68d966a0-4371-34f7-b45a-ab843d550605\' target=\'blank\'>RTL XL</a>.\n<span>\n\n<span class=\'en\'>\nThis scenario has been made by <a href=\'http://wattnu.nl/guest/Anniek%20Mauser\' target=\'blank\'>Anniek Mauser</a> (Head of Sustainability at Unilever Benelux) for the TV show \'Watt Nu?!\'. When you open this scenario you can see the choices that Ms. Mauser made for the Netherlands in 2030. The show itself can be seen on <a href=\'http://rtl.nl/xl/#/u/68d966a0-4371-34f7-b45a-ab843d550605\' target=\'blank\'>RTL XL</a>.\n</span>', '2012-03-30 09:01:11', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, 1, NULL, NULL, 0, '2012-07-10 15:12:56', NULL, 'nl', NULL, '--- {}\n\n'),
    (93, NULL, 'Watt Nu - Harm Post', '<span class=\'nl\'>\nDit scenario is gemaakt door <a href=\'http://wattnu.nl/guest/Harm%20Post\' target=\'blank\'>Harm Post</a> (Directeur Groningen Seaports) voor het televisieprogramma \'Watt Nu?!\'. Als u dit scenario opent kunt u zien welke keuzes Dhr. Post gemaakt heeft voor Nederland in 2030. De uitzending zelf kunt u nakijken op <a href=\'http://rtl.nl/xl/#/u/709d7638-f576-37b3-bbc3-69abe771f1b0\' target=\'blank\'>RTL XL</a>.\n</span>\n\n<span class=\'en\'>\nThis scenario has been made by <a href=\'http://wattnu.nl/guest/Harm%20Post\' target=\'blank\'>Harm Post</a> (CEO Groningen Seaports) for the TV show \'Watt Nu?!\'. When you open this scenario you can see the choices that Mr. Post made for the Netherlands in 2030. The show itself can be seen on <a href=\'http://rtl.nl/xl/#/u/709d7638-f576-37b3-bbc3-69abe771f1b0\' target=\'blank\'>RTL XL</a>.\n</span>', '2012-04-26 15:18:05', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, 1, NULL, NULL, 0, '2012-07-10 15:12:56', NULL, 'nl', NULL, '--- {}\n\n'),
    (94, NULL, 'Watt Nu - Tjerk Wagenaar', '<span class=\'nl\'>\nDit scenario is gemaakt door <a href=\'http://wattnu.nl/guest/Tjerk%20Wagenaar\' target=\'blank\'>Tjerk Wagenaar</a> (Directeur Natuur & Milieu) voor het televisieprogramma \'Watt Nu?!\'. Als u dit scenario opent kunt u zien welke keuzes Dhr. Wagenaar gemaakt heeft voor Nederland in 2030. De uitzending zelf kunt u nakijken op <a href=\'http://rtl.nl/xl/#/u/709d7638-f576-37b3-bbc3-69abe771f1b0\' target=\'blank\'>RTL XL</a>.\n</span>\n\n<span class=\'en\'>\nThis scenario has been made by <a href=\'http://wattnu.nl/guest/Tjerk%20Wagenaar\' target=\'blank\'>Tjerk Wagenaar</a> (CEO Natuur & Milieu) for the TV show \'Watt Nu?!\'. When you open this scenario you can see the choices that Mr. Wagenaar made for the Netherlands in 2030. The show itself can be seen on <a href=\'http://rtl.nl/xl/#/u/709d7638-f576-37b3-bbc3-69abe771f1b0\' target=\'blank\'>RTL XL</a>.\n</span>', '2012-04-23 16:30:55', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, 1, NULL, NULL, 0, '2012-07-10 15:12:56', NULL, 'nl', NULL, '--- {}\n\n'),
    (95, NULL, 'Watt Nu - Jo van den Brand', '<span class=\'nl\'>\nDit scenario is gemaakt door <a href=\'http://wattnu.nl/guest/Jo%20van%20den%20Brand\' target=\'blank\'>Jo van den Brand</a> (Professor Natuurkunde) voor het televisieprogramma \'Watt Nu?!\'. Als u dit scenario opent kunt u zien welke keuzes Dhr. Van den Brand gemaakt heeft voor Nederland in 2030. De uitzending zelf kunt u nakijken op <a href=\'http://www.rtl.nl/xl/#/u/53622af8-b1ca-3460-be9c-261b1866a5b7\' target=\'blank\'>RTL XL</a>.\n</span>\n\n<span class=\'en\'>\nThis scenario has been made by <a href=\'http://wattnu.nl/guest/Jo%20van%20den%20Brand\' target=\'blank\'>Jo van den Brand</a> (Professor of Physics) for the TV show \'Watt Nu?!\'. When you open this scenario you can see the choices that Mr. Van den Brand made for the Netherlands in 2030. The show itself can be seen on <a href=\'http://www.rtl.nl/xl/#/u/53622af8-b1ca-3460-be9c-261b1866a5b7\' target=\'blank\'>RTL XL</a>.\n</span>', '2012-04-24 14:38:20', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, 1, NULL, NULL, 0, '2012-07-10 15:12:56', NULL, 'nl', NULL, '--- {}\n\n'),
    (96, NULL, 'Watt Nu - Marjan Minnesma', '<span class=\'nl\'>\nDit scenario is gemaakt door <a href=\'http://wattnu.nl/guest/Marjan%20Minnesma\' target=\'blank\'>Marjan Minnesma</a> (Directeur Urgenda) voor het televisieprogramma \'Watt Nu?!\'. Als u dit scenario opent kunt u zien welke keuzes Mevr. Minnesma gemaakt heeft voor Nederland in 2030. De uitzending zelf kunt u nakijken op <a href=\'http://www.rtl.nl/xl/#/u/53622af8-b1ca-3460-be9c-261b1866a5b7\' target=\'blank\'>RTL XL</a>.\n</span>\n\n<span class=\'en\'>\nThis scenario has been made by <a href=\'http://wattnu.nl/guest/Marjan%20Minnesma\' target=\'blank\'>Marjan Minnesma</a> (Director Urgenda) for the TV show \'Watt Nu?!\'. When you open this scenario you can see the choices that Ms. Minnesma made for the Netherlands in 2030. The show itself can be seen on <a href=\'http://www.rtl.nl/xl/#/u/53622af8-b1ca-3460-be9c-261b1866a5b7\' target=\'blank\'>RTL XL</a>.\n</span>', '2012-04-23 16:11:46', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, 1, NULL, NULL, 0, '2012-07-10 15:12:56', NULL, 'nl', NULL, '--- {}\n\n'),
    (97, NULL, 'Watt Nu - Romeo Malizia', '<span class=\'nl\'>\nDit scenario is gemaakt door <a href=\'http://wattnu.nl/guest/Romeo%20Malizia\' target=\'blank\'>Romeo Malizia</a> (COO Ballast Nedam) voor het televisieprogramma \'Watt Nu?!\'. Als u dit scenario opent kunt u zien welke keuzes Dhr. Malizia gemaakt heeft voor Nederland in 2030. De uitzending zelf kunt u nakijken op <a href=\'http://www.rtl.nl/xl/#/u/c98eaff5-84f9-3310-90c7-de4d85ddca5f\' target=\'blank\'>RTL XL</a>.</span>\n\n<span class=\'en\'>\nThis scenario has been made by <a href=\'http://wattnu.nl/guest/Romeo%20Malizia\' target=\'blank\'>Romeo Malizia</a> (COO of Ballast Nedam) for the TV show \'Watt Nu?!\'. When you open this scenario you can see the choices that Mr. Malizia made for the Netherlands in 2030. The show itself can be seen on <a href=\'http://www.rtl.nl/xl/#/u/c98eaff5-84f9-3310-90c7-de4d85ddca5f\' target=\'blank\'>RTL XL</a>.\n</span>', '2012-04-19 14:28:46', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, 1, NULL, NULL, 0, '2012-07-11 07:53:20', NULL, 'nl', NULL, '--- {}\n\n'),
    (98, NULL, 'Watt Nu - Ronald Rovers', '<span class=\'nl\'>\nDit scenario is gemaakt door <a href=\'http://wattnu.nl/guest/Ronald %20Rovers\' target=\'blank\'>Ronald Rovers</a> (Lector Hogeschool Zuyd) voor het televisieprogramma \'Watt Nu?!\'. Als u dit scenario opent kunt u zien welke keuzes Dhr. Rovers gemaakt heeft voor Nederland in 2030. De uitzending zelf kunt u nakijken op <a href=\'http://www.rtl.nl/xl/#/u/c98eaff5-84f9-3310-90c7-de4d85ddca5f\' target=\'blank\'>RTL XL</a>.\n</span>\n\n<span class=\'en\'>\nThis scenario has been made by <a href=\'http://wattnu.nl/guest/Ronald %20Rovers\' target=\'blank\'>Ronald Rovers</a> (Lector Hogeschool Zuyd) for the TV show \'Watt Nu?!\'. When you open this scenario you can see the choices that Mr. Rovers made for the Netherlands in 2030. The show itself can be seen on <a href=\'http://www.rtl.nl/xl/#/u/c98eaff5-84f9-3310-90c7-de4d85ddca5f\' target=\'blank\'>RTL XL</a>.\n</span>', '2012-04-27 10:09:14', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, 1, NULL, NULL, 0, '2012-07-10 15:12:56', NULL, 'nl', NULL, '--- {}\n\n'),
    (99, NULL, 'Watt Nu - Stef van Dongen', '<span class=\'nl\'>\nDit scenario is gemaakt door <a href=\'http://wattnu.nl/guest/Stef%20van%20Dongen\' target=\'blank\'>Stef van Dongen</a> (Directeur Enviu) voor het televisieprogramma \'Watt Nu?!\'. Als u dit scenario opent kunt u zien welke keuzes Dhr. Van Dongen gemaakt heeft voor Nederland in 2030. De uitzending zelf kunt u nakijken op <a href=\'http://www.rtl.nl/xl/#/u/d3399a2f-32ba-3883-a0cb-2bf1e5b1deee\' target=\'blank\'>RTL XL</a>.\n</span>\n\n<span class=\'en\'>\nThis scenario has been made by <a href=\'http://wattnu.nl/guest/Stef%20van%20Dongen\' target=\'blank\'>Stef van Dongen</a> (Director Enviu) for the TV show \'Watt Nu?!\'. When you open this scenario you can see the choices that Mr. Van Dongen made for the Netherlands in 2030. The show itself can be seen on <a href=\'http://www.rtl.nl/xl/#/u/d3399a2f-32ba-3883-a0cb-2bf1e5b1deee\' target=\'blank\'>RTL XL</a>.\n</span>', '2012-05-15 13:07:13', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, 1, NULL, NULL, 0, '2012-07-10 15:12:56', NULL, 'nl', NULL, '--- {}\n\n'),
    (100, NULL, 'Watt Nu - Ewald Breunesse', '<span class=\'nl\'>\nDit scenario is gemaakt door <a href=\'http://wattnu.nl/guest/Ewald%20Breunesse\' target=\'blank\'>Ewald Breunesse</a> (Manager Energietransitie bij Shell) voor het televisieprogramma \'Watt Nu?!\'. Als u dit scenario opent kunt u zien welke keuzes Dhr. Breunesse gemaakt heeft voor Nederland in 2030. De uitzending zelf kunt u nakijken op <a href=\'http://www.rtl.nl/xl/#/u/d3399a2f-32ba-3883-a0cb-2bf1e5b1deee\' target=\'blank\'>RTL XL</a>.\n</span>\n\n<span class=\'en\'>\nThis scenario has been made by <a href=\'http://wattnu.nl/guest/Ewald%20Breunesse\' target=\'blank\'>Ewald Breunesse</a> (Manager Energy Transition at Shell) for the TV show \'Watt Nu?!\'. When you open this scenario you can see the choices that Mr. Breunesse made for the Netherlands in 2030. The show itself can be seen on <a href=\'http://www.rtl.nl/xl/#/u/d3399a2f-32ba-3883-a0cb-2bf1e5b1deee\' target=\'blank\'>RTL XL</a>.\n</span>', '2012-05-25 06:23:55', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, 1, NULL, NULL, 0, '2012-07-11 10:59:00', NULL, 'nl', NULL, '--- {}\n\n'),
    (101, NULL, 'Jan Borghuis - Ronde 3', NULL, '2012-05-22 14:23:26', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, NULL, NULL, NULL, 0, '2012-07-10 15:12:56', NULL, 'nl', NULL, '--- {}\n\n'),
    (102, NULL, 'PV 3', NULL, '2012-05-24 13:37:51', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, NULL, NULL, NULL, 0, '2012-07-10 15:12:56', NULL, 'nl', NULL, '--- {}\n\n'),
    (103, NULL, 'Jeroen de Haas - ronde 3', NULL, '2012-05-23 07:12:51', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, NULL, NULL, NULL, 0, '2012-07-10 15:12:56', NULL, 'nl', NULL, '--- {}\n\n'),
    (104, NULL, 'Paulus Jansen ronde 3', NULL, '2012-05-25 13:17:27', '2012-09-26 12:06:20', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2030, NULL, NULL, NULL, 0, '2012-06-18 10:01:56', NULL, 'nl', NULL, '--- {}\n\n'),
    (2996, 'NULL', '80% CO2 reductiescenario', 'Quintel Intelligence heeft een voorbeeldscenario gemaakt met 80% CO2 reductie voor 2050. Het is een scenario met beperkte economische groei (ongeveer 1% procent per jaar) tussen 2010 en 2050. De huidige 2010” state-of-the-art technology” wordt gebruik met uitzondering van zon en wind waar significante prestatieverbeteringen worden verondersteld (-37% voor wind op land tot –78% voor zonnepanelen). Brandstofprijzen stijgen met 100% tussen 2010 en 2050 en de CO2-prijs is ongeveer 50 Euro per ton terwijl de totale energiekosten minder dan 5% stijgen t.o.v. vandaag. Ongespecificeerde efficiëntie verbeteringen in iedere sector worden zo laag mogelijk gehouden om aan te blijven sluiten bij de realiteit van vandaag. De efficientie verbetering in de industrie is 1.2% per jaar in dit scenario. We hebben onze optimaliseringsmodule (die werkt bovenop het model dat je hier zelf ook kunt gebruiken) om dit scenario uit te rekenen. Gas, Olie, Kolen en Kernenergie leveren nog steeds een belangrijk deel  van de primaire energie. CCS is niet zinvol in dit scenario. Er zijn alternatieven aan zowel de vraag- als aanbodzijde die efficiënter zijn voor iedere gespendeerde euro. Er is een belangrijke aandeel biomassa, wind en zon in de energiemix. Volgen ons is dit niet een energietransitie maar een energierevolutie. De taak die voor ons ligt in dit scenario is immens maar realiseerbaar. Veel plezier met het onderzoeken en verbeteren van dit scenario. Probeer je de implicaties van een dergelijk scenario eens voor te stellen.', '2011-03-24 16:30:58', '2012-09-26 12:06:28', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2050, 1, 158, 0, 0, '2012-07-10 10:18:17', 0, 'nl', NULL, '--- {}\n\n'),
    (2998, 'NULL', '99% Duurzame Energie   \"Nederland krijgt nieuwe energie\"', '<p style=\'padding-left:0px\'>Op verzoek van Marco Witschge van het burgerinitiatief \"Nederland krijgt nieuwe energie\" hebben wij de afgelopen weken met het Energietranstitiemodel een extreem scenario berekent dat uitkomt op 99% CO2 en 99% duurzame energie in 2050. </p>\r\n\r\n<p style=\'padding-left:0px\'>Om dit scenario te kunnen berekenen hebben wij eerst een aantal aannames gedaan over de situatie in 2050:</p>\r\n<p style=\'padding-left:0px\'>- Brandstofprijzen   100% hoger dan vandaag<br/>\r\n- Gematigde economische groei (1-2% per jaar)<br/>\r\n- Gematigde efficiency verbeteringen (onder de 2% per jaar)<br/>\r\n- Gebruik van 2010 state of the art technology met uitzondering van wind en zon waar efficiency verbetering is verondersteld</p>\r\n\r\n<p style=\'padding-left:0px\'>Vervolgens hebben wij een optimalisatiealgoritme losgelaten op alle elementen uit ons energiesysteem en het algoritme de technologie- en brandstofmix vrij laten kiezen. Dit natuurlijk binnen de gebruikelijke beperkingen van landgebruik en een maximaal toegelaten kostenstijging van 100%.</p>\r\n\r\n<p style=\'padding-left:0px\'>U kunt zelf met de aannames spelen of de technologie- of brandstofmix aanpassen indien u een van de uitgerekende waarden niet reëel vindt. Het systeem zal dan in enkele milliseconden het gehele energiesysteem opnieuw doorrekenen op onze servers en u dan onmiddellijk feedback geven over de consequenties van de aanpassingen die u aan het scenario heeft gemaakt.</p>\r\n\r\n<p style=\'padding-left:0px\'>Ter vergelijking zijn er in dit menu ook twee scenario\'s voor 2050 te laden die minder extreem zijn. Het eerste scenario is gemaakt door een team van experts van GasTerra. Dit geeft een optimistische maar meer gematigde ontwikkeling tot aan 2050. En een  80% CO2 reductie scenario dat van dezelfde aannames uitgaat als het 99% duurzaam scenario maar in dit scenario is ook ruimte voor kernenergie en een beperkte hoeveelheid fossiele brandstoffen. </p>\r\n\r\n<p style=\'padding-left:0px\'>Groot verschil tussen het 80% CO2 reductie scenario en het 99% duurzaam scenario is de hoeveelheid biomassa die nodig is. Deze hoeveelheid is in het 80% CO2 reductie scenario ruim 2 x het Nederlands landbouwareaal en in het 99% duurzaam scenario ruim 5 x het Nederlands landbouwareaal. </p>\r\n', '2011-03-24 16:34:58', '2012-09-26 12:06:28', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2050, 1, 158, 0, 0, '2012-07-10 10:18:17', 0, 'nl', NULL, '--- {}\n\n'),
    (2999, 'NULL', 'DWARS, GroenLinkse jongeren energievisie', 'DWARS, GroenLinkse jongeren heeft nagedacht over de energietransitie, en geeft middels dit model haar visie. DWARS streeft naar een duurzame, leefbare en betrouwbare energievoorziening.\nWindenergie, zonne-energie en aardwarmte hebben hierin een sleutelrol. Dit zijn namelijk volgens DWARS de enige bronnen die echt duurzaam, leefbaar en betrouwbaar zijn. Dit scenario laat zien dat de transitie naar een duurzame, leefbare en betrouwbare energievoorziening mogelijk is en dat het niet eens veel geld kost. DWARS hoopt met dit scenario bij te dragen aan de discussie rond de energietransitie, en is van mening dat het energietransitiemodel een nuttige rol in deze discussie kan vervullen.', '2011-04-13 17:11:16', '2012-09-26 12:06:28', '--- !map:ActiveSupport::HashWithIndifferentAccess \nhouseholds_space_heater_heatpump_air_water_electricity_share: 0.04045729999998571\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_heating_electric_heater_share: 1.759974\nhouseholds_heating_oil_fired_heater_share: 1.2426933\nhouseholds_heating_gas_combi_heater_share: 82.100886\nhouseholds_heating_heat_pump_ground_share: 0.0748925\nhouseholds_heating_pellet_stove_share: 2.55678\nhouseholds_heating_coal_fired_heater_share: 0.0615575\nhouseholds_heating_gas_fired_heater_share: 9.1223511\nhouseholds_heating_district_heating_network_share: 3.0404083\nhouseholds_cooling_heat_pump_ground_share: 0.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 0.0\nhouseholds_cooling_airconditioning_share: 100.0\n', 2050, 0, 97, 0, 0, '2012-06-06 14:39:19', 0, 'nl', NULL, '--- {}\n\n'),
    (132824, NULL, 'Watt nu?! Sytse Jelles', '', '2013-02-11 10:34:13', '2013-02-11 10:34:13', '--- \npolicy_sustainability_co2_emissions: -40.0\npolicy_sustainability_renewable_percentage: 40.0\npolicy_dependence_max_electricity_dependence: 20.0\npolicy_cost_total_energy_cost: 20.0\npolicy_cost_electricity_cost: 50.0\nhouseholds_number_of_inhabitants: 0.2\nhouseholds_electricity_demand_per_person: -0.5\nhouseholds_insulation_level_old_houses: 2.0\nhouseholds_insulation_level_new_houses: 4.0\nhouseholds_replacement_of_existing_houses: 0.3\nhouseholds_cooling_demand_per_person: 1.0\nhouseholds_heating_gas_combi_heater_share: 64.3667845\nhouseholds_heating_heat_pump_ground_share: 5.0\nhouseholds_heating_district_heating_network_share: 3.5\nhouseholds_heating_pellet_stove_share: 5.0\nhouseholds_heating_electric_heater_share: 1.766591\nhouseholds_heating_gas_fired_heater_share: 10.3666245\nhouseholds_heating_oil_fired_heater_share: 0.0\nhouseholds_heating_coal_fired_heater_share: 0.0\nhouseholds_heating_micro_chp_share: 0.0\nhouseholds_space_heater_heatpump_air_water_electricity_share: 10.0\nhouseholds_heating_heat_pump_add_on_share: 20.0\nhouseholds_hot_water_gas_fired_heater_share: 73.8880978\nhouseholds_water_heater_heatpump_ground_water_electricity_share: 0.004058\nhouseholds_hot_water_micro_chp_share: 10.0\nhouseholds_hot_water_heat_network_share: 3.0\nhouseholds_hot_water_electric_boiler_share: 8.1078442\nhouseholds_hot_water_gas_water_heater_share: 5.0\nhouseholds_heating_geothermal_share: 10.0\nhouseholds_heating_heat_network_share: 90.0\nhouseholds_market_penetration_solar_panels: 60.0\nhouseholds_hot_water_solar_water_heater_share: 50.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 10.0\nhouseholds_cooling_airconditioning_share: 70.0\nhouseholds_cooling_heat_pump_ground_share: 20.0\nhouseholds_efficiency_dish_washer: 29.3\nhouseholds_efficiency_fridge_freezer: 37.9\nhouseholds_efficiency_washing_machine: 26.5\nhouseholds_efficiency_dryer: 43.5\nhouseholds_lighting_incandescent_share: 20.0\nhouseholds_lighting_low_energy_light_bulb_share: 20.0\nhouseholds_lighting_light_emitting_diode_share: 60.0\nhouseholds_behavior_standby_killer_turn_off_appliances: 5.0\nhouseholds_behavior_turn_off_the_light: 5.0\nhouseholds_behavior_close_windows_turn_off_heating: 5.0\nhouseholds_behavior_low_temperature_washing: 5.0\nbuildings_insulation_level: 2.0\nbuildings_heating_gas_fired_heater_share: 70.7028219\nbuildings_heating_heat_pump_with_ts_share: 15.0\nbuildings_heating_gas_fired_heat_pump_share: 1.5026221\nbuildings_heating_electric_heater_share: 1.8630502\nbuildings_heating_solar_thermal_panels_share: 5.0\nbuildings_heating_oil_fired_heater_share: 0.0\nbuildings_heating_district_heating_network_share: 5.9315058\nbuildings_heating_small_gas_chp_share: 72.0\nbuildings_heating_geothermal_share: 10.0\nbuildings_heating_heat_network_share: 18.0\nbuildings_cooling_heat_pump_with_ts_share: 15.0\nbuildings_cooling_gas_fired_heat_pump_share: 0.0\nbuildings_cooling_airconditioning_share: 85.0\nbuildings_waste_heat_recovery: 30.0\nbuildings_appliances_efficiency: 1.0\nbuildings_lighting_fluorescent_tube_conventional_share: 10.0\nbuildings_lighting_fluorescent_tube_high_performance_share: 30.0\nbuildings_lighting_led_tube_share: 60.0\nbuildings_lighting_motion_detection: 60.0\nbuildings_lighting_daylight_dependent_control: 60.0\nbuildings_market_penetration_solar_panels: 20.0\ntransport_cars_electric_share: 60.0\ntransport_cars_diesel_share: 0.0\ntransport_cars_gasoline_share: 35.2914612\ntransport_cars_lpg_share: 4.5708036\ntransport_cars_compressed_gas_share: 0.1377352\ntransport_trucks_diesel_share: 85.0\ntransport_trucks_compressed_gas_share: 10.0\ntransport_trucks_electric_share: 5.0\nindustry_electricity_demand: -0.5\nindustry_heat_demand: -0.5\nindustry_non_energetic_oil_demand: -0.5\nindustry_efficiency_electricity: 0.2\nindustry_heat_from_fuels: 0.2\nindustry_number_of_gas_chp: 100.0\nindustry_aluminium_production: -1.0\nindustry_steel_production: -2.0\nindustry_other_metals_production: -1.0\nagriculture_electricity_demand: -1.0\nagriculture_heat_demand: -0.5\nagriculture_heating_gas_fired_heater_share: 35.0\nagriculture_heating_oil_fired_heater_share: 0.0\nagriculture_heating_biomass_fired_heater_share: 5.0\nagriculture_heating_heat_pump_with_ts_share: 20.0\nagriculture_heating_geothermal_share: 5.0\nagriculture_heating_combined_heat_power_share: 35.0\nagriculture_number_of_small_gas_chp: 2000.0\ninvestment_costs_solar_solar_panels: -50.0\ncosts_oil: 20.0\ncosts_co2: 120.0\nsettings_enable_merit_order: 1.0\nnumber_of_pulverized_coal: 4.5\nnumber_of_pulverized_coal_ccs: 1.0\nnumber_of_coal_iggc: 0.0\nnumber_of_central_coal_chp: 0.0\nnumber_of_gas_conventional: 0.0\nnumber_of_wind_onshore_land: 2000.0\nnumber_of_wind_onshore_coast: 700.0\nnumber_of_wind_offshore: 1300.0\nnumber_of_waste_incinerator: 12.0\nshare_coal_co_firing_coal: 45.0\nshare_of_wood_pellets_co_firing_coal: 30.0\nshare_biocoal_co_firing_coal: 25.0\nelectricity_natural_gas_share: 100.0\nelectricity_oil_share_in_gas_production: 0.0\nnatural_gas_total_share: 99.0\ngreen_gas_total_share: 1.0\nnumber_of_hydro_river: 5.0\nnumber_of_gas_ccgt: 4.0\nnumber_of_nuclear_3rd_gen: 0.0\nindustry_heating_gas_fired_heater_share: 49.4110017\nindustry_heating_oil_fired_heater_share: 0.0\nindustry_heating_coal_fired_heater_share: 0.4349321\nindustry_heating_biomass_fired_heater_share: 20.0\nindustry_heating_combined_heat_power_share: 30.1540662\nindustry_number_of_biomass_chp: 100.0\nindustry_steel_blastfurnace_current_share: 40.0\nindustry_steel_blastfurnace_bat_share: 50.0\nindustry_steel_electricfurnace_share: 10.0\nindustry_steel_biofeedstock_for_hisarna_share: 10.0\nindustry_aluminium_electrolysis_current_share: 30.0\nindustry_aluminium_electrolysis_bat_share: 50.0\ninvestment_costs_fuel_cell: -50.0\n', 2030, NULL, NULL, 132814, 0, NULL, 1, 'nl', 'ETM', '--- \nhouseholds_hot_water_fuel_cell_share: 0.0\nhouseholds_hot_water_oil_fired_heater_share: 0.0\nhouseholds_water_heater_heatpump_air_water_electricity_share: 0.0\nhouseholds_hot_water_coal_fired_heater_hotwater_share: 0.0\nhouseholds_hot_water_biomass_heater_share: 0.0\nhouseholds_heating_biomass_chp_share: 0.0\nhouseholds_heating_small_gas_chp_share: 0.0\nbuildings_heating_coal_fired_heater_share: 0.0\nbuildings_heating_biomass_fired_heater_share: 0.0\nbuildings_heating_biomass_chp_share: 0.0\ntransport_trucks_gasoline_share: 0.0\nelectricity_bio_oil_share_in_gas_production: 0.0\nindustry_steel_hisarna_share: 0.0\nindustry_aluminium_smeltoven_share: 20.0\nindustry_aluminium_carbothermalreduction_share: 0.0\n'),
    (134183, NULL, 'Eric van den Dungen  WattNu Final Scenario 2030', '', '2013-02-15 10:21:11', '2013-02-15 10:21:11', '--- \npolicy_sustainability_co2_emissions: -50.0\npolicy_sustainability_renewable_percentage: 30.0\npolicy_cost_total_energy_cost: 20.0\nhouseholds_number_of_inhabitants: 0.1\nhouseholds_replacement_of_existing_houses: 1.0\nhouseholds_insulation_level_old_houses: 1.3\nhouseholds_insulation_level_new_houses: 3.0\nhouseholds_heating_gas_combi_heater_share: 76.0\nhouseholds_heating_heat_pump_ground_share: 4.0\nhouseholds_heating_district_heating_network_share: 4.0\nhouseholds_heating_pellet_stove_share: 3.0\nhouseholds_heating_electric_heater_share: 0.0\nhouseholds_heating_gas_fired_heater_share: 5.0\nhouseholds_heating_oil_fired_heater_share: 0.0\nhouseholds_heating_coal_fired_heater_share: 0.0\nhouseholds_heating_micro_chp_share: 4.0\nhouseholds_space_heater_heatpump_air_water_electricity_share: 4.0\nhouseholds_hot_water_gas_fired_heater_share: 78.0\nhouseholds_water_heater_heatpump_ground_water_electricity_share: 4.0\nhouseholds_hot_water_heat_network_share: 3.0\nhouseholds_hot_water_electric_boiler_share: 0.0\nhouseholds_hot_water_gas_water_heater_share: 6.0\nhouseholds_hot_water_micro_chp_share: 4.0\nhouseholds_water_heater_heatpump_air_water_electricity_share: 4.0\nhouseholds_hot_water_biomass_heater_share: 1.0\nhouseholds_market_penetration_solar_panels: 20.0\nhouseholds_hot_water_solar_water_heater_share: 15.0\nhouseholds_cooling_heat_pump_ground_share: 4.0\nhouseholds_cooling_airconditioning_share: 92.0\nhouseholds_cooling_heatpump_air_water_electricity_share: 4.0\nhouseholds_cooking_gas_share: 50.7658266\nhouseholds_cooking_electric_share: 25.1851682\nhouseholds_cooking_halogen_share: 8.0163351\nhouseholds_cooking_induction_share: 16.0326701\nhouseholds_efficiency_dish_washer: 31.9\nhouseholds_efficiency_fridge_freezer: 41.0\nhouseholds_efficiency_washing_machine: 33.9\nhouseholds_efficiency_dryer: 44.1\nhouseholds_efficiency_television: 40.4\nhouseholds_efficiency_computer_media: 38.5\nhouseholds_efficiency_vacuum_cleaner: 35.7\nhouseholds_efficiency_other: 33.0\nhouseholds_lighting_incandescent_share: 29.2592932\nhouseholds_lighting_low_energy_light_bulb_share: 34.4444275\nhouseholds_lighting_light_emitting_diode_share: 36.2962793\nhouseholds_behavior_low_temperature_washing: 35.4\nhouseholds_behavior_close_windows_turn_off_heating: 34.4\nhouseholds_behavior_turn_off_the_light: 14.1\nhouseholds_behavior_standby_killer_turn_off_appliances: 34.4\nbuildings_number_of_buildings: -0.5\nbuildings_electricity_per_student_employee: -1.0\nbuildings_cooling_per_student_employee: 0.0\nbuildings_insulation_level: 2.0\nbuildings_heating_gas_fired_heater_share: 68.2731411\nbuildings_heating_heat_pump_with_ts_share: 10.0\nbuildings_heating_gas_fired_heat_pump_share: 1.5026221\nbuildings_heating_electric_heater_share: 1.8630502\nbuildings_heating_solar_thermal_panels_share: 5.0\nbuildings_heating_oil_fired_heater_share: 3.3611866\nbuildings_heating_district_heating_network_share: 10.0\nbuildings_cooling_heat_pump_with_ts_share: 10.0\nbuildings_cooling_gas_fired_heat_pump_share: 0.0\nbuildings_cooling_airconditioning_share: 90.0\nbuildings_appliances_efficiency: 2.0\nbuildings_lighting_fluorescent_tube_conventional_share: 0.0\nbuildings_lighting_fluorescent_tube_high_performance_share: 0.0\nbuildings_lighting_led_tube_share: 100.0\nbuildings_lighting_motion_detection: 26.5\nbuildings_market_penetration_solar_panels: 50.0\ntransport_cars: 0.3\ntransport_trains: 1.0\ntransport_cars_electric_share: 20.0\ntransport_cars_diesel_share: 17.3104675\ntransport_cars_gasoline_share: 48.1187289\ntransport_cars_lpg_share: 4.5708036\ntransport_cars_compressed_gas_share: 10.0\ntransport_trucks_diesel_share: 79.2592932\ntransport_trucks_compressed_gas_share: 10.3703534\ntransport_trucks_electric_share: 10.3703534\ntransport_trains_diesel_share: 0.0\ntransport_trains_electric_share: 100.0\ntransport_efficiency_electric_vehicles: 0.5\ntransport_efficiency_combustion_engine_trucks: 0.7\ntransport_efficiency_combustion_engine_cars: 0.5\ntransport_efficiency_ships: 0.5\ntransport_efficiency_airplanes: 1.0\nindustry_electricity_demand: -1.0\nindustry_heat_demand: -1.0\nindustry_non_energetic_oil_demand: -1.0\nindustry_non_energetic_other_demand: -1.0\nindustry_efficiency_electricity: 1.0\nindustry_heat_from_fuels: 1.0\nindustry_heating_gas_fired_heater_share: 42.1838164\nindustry_heating_oil_fired_heater_share: 14.0740571\nindustry_heating_coal_fired_heater_share: 0.4349321\nindustry_heating_biomass_fired_heater_share: 0.5294336\nindustry_heating_combined_heat_power_share: 42.7777608\nindustry_number_of_biomass_chp: 20.0\nindustry_steel_production: -3.0\nindustry_aluminium_production: -3.0\nindustry_other_metals_production: -3.0\nagriculture_heat_demand: -2.0\nagriculture_electricity_demand: -2.0\nagriculture_heating_gas_fired_heater_share: 22.8075356\nagriculture_heating_oil_fired_heater_share: 13.173529\nagriculture_heating_biomass_fired_heater_share: 0.6\nagriculture_heating_heat_pump_with_ts_share: 3.0\nagriculture_heating_geothermal_share: 3.0\nagriculture_heating_combined_heat_power_share: 57.4189354\ncosts_gas: 40.0\ncosts_oil: 40.0\ncosts_coal: 40.0\ncosts_biomass: 40.0\ninvestment_costs_wind_offshore: 10.0\ninvestment_costs_solar_solar_panels: -20.0\ncosts_co2: 5.0\ncosts_co2_free_allocation: 0.0\nnumber_of_pulverized_coal: 3.4\nsettings_enable_merit_order: 1.0\nnumber_of_wind_onshore_land: 1000.0\nnumber_of_wind_onshore_coast: 66.7\nnumber_of_wind_offshore: 3000.0\nnumber_of_geothermal_electric: 2.0\nnatural_gas_total_share: 99.8\ngreen_gas_total_share: 0.2\n', 2030, NULL, NULL, 134179, 0, NULL, 1, 'nl', 'ETM', '--- \nhouseholds_hot_water_fuel_cell_share: 0.0\nhouseholds_hot_water_oil_fired_heater_share: 0.0\nhouseholds_hot_water_coal_fired_heater_hotwater_share: 0.0\nhouseholds_cooking_biomass_share: 1.0e-14\nbuildings_heating_coal_fired_heater_share: 0.0\nbuildings_heating_biomass_fired_heater_share: 0.0\ntransport_trucks_gasoline_share: 0.0\ntransport_trains_coal_share: 0.0\n'),
    (134237, NULL, 'Jo Peters Watt Nu Gas als transitieversneller', '', '2013-02-15 13:54:50', '2013-02-15 13:54:50', '--- \npolicy_sustainability_co2_emissions: -30.0\npolicy_sustainability_renewable_percentage: 25.0\npolicy_cost_total_energy_cost: 25.0\nhouseholds_insulation_level_old_houses: 1.0\nhouseholds_insulation_level_new_houses: 6.0\nhouseholds_replacement_of_existing_houses: 0.5\nhouseholds_climate_influence: 0.0\nhouseholds_market_penetration_solar_panels: 25.0\nhouseholds_cooking_gas_share: 59.91832472094052\nhouseholds_cooking_electric_share: 16.032670111623805\nhouseholds_cooking_halogen_share: 8.01633505581188\nhouseholds_cooking_induction_share: 16.032670111623805\nhouseholds_cooking_biomass_share: 0.0\nhouseholds_efficiency_dish_washer: 25.0\nhouseholds_efficiency_fridge_freezer: 25.0\nhouseholds_efficiency_washing_machine: 25.0\nhouseholds_efficiency_dryer: 25.0\nhouseholds_efficiency_television: 25.0\nhouseholds_efficiency_computer_media: 25.0\nhouseholds_efficiency_vacuum_cleaner: 25.0\nhouseholds_efficiency_other: 25.0\nhouseholds_lighting_incandescent_share: 0.0\nhouseholds_lighting_low_energy_light_bulb_share: 25.0\nhouseholds_lighting_light_emitting_diode_share: 75.0\nhouseholds_behavior_standby_killer_turn_off_appliances: 0.0\nhouseholds_behavior_turn_off_the_light: 0.0\nhouseholds_behavior_close_windows_turn_off_heating: 0.0\nhouseholds_behavior_low_temperature_washing: 0.0\nbuildings_electricity_per_student_employee: -1.0\nbuildings_heat_per_employee_student: -1.0\nbuildings_insulation_level: 1.5\nbuildings_heating_gas_fired_heater_share: 37.2539808\nbuildings_heating_heat_pump_with_ts_share: 50.0\nbuildings_heating_gas_fired_heat_pump_share: 1.5026221\nbuildings_heating_electric_heater_share: 1.8630502\nbuildings_heating_solar_thermal_panels_share: 0.0876545\nbuildings_heating_oil_fired_heater_share: 3.3611866\nbuildings_heating_district_heating_network_share: 5.9315058\nbuildings_cooling_heat_pump_with_ts_share: 50.0\nbuildings_cooling_gas_fired_heat_pump_share: 0.0\nbuildings_cooling_airconditioning_share: 50.0\nbuildings_lighting_fluorescent_tube_conventional_share: 0.0\nbuildings_lighting_fluorescent_tube_high_performance_share: 25.0\nbuildings_lighting_led_tube_share: 75.0\nbuildings_market_penetration_solar_panels: 50.0\ntransport_trains: 5.0\ntransport_inland_navigation: 10.0\ntransport_trucks: -1.0\ntransport_cars_electric_share: 10.0\ntransport_cars_diesel_share: 40.0\ntransport_cars_gasoline_share: 40.0\ntransport_cars_lpg_share: 9.8622648\ntransport_cars_compressed_gas_share: 0.1377352\ntransport_trucks_electric_share: 10.0\ntransport_trucks_diesel_share: 80.0\ntransport_trucks_gasoline_share: 0.0\ntransport_trucks_compressed_gas_share: 10.0\ntransport_efficiency_combustion_engine_trucks: 2.0\ntransport_efficiency_combustion_engine_cars: 3.0\nindustry_efficiency_electricity: 1.0\nindustry_heat_from_fuels: 1.0\nindustry_heating_gas_fired_heater_share: 34.5650679\nindustry_heating_oil_fired_heater_share: 0.0\nindustry_heating_coal_fired_heater_share: 0.4349321\nindustry_heating_biomass_fired_heater_share: 15.0\nindustry_heating_combined_heat_power_share: 50.0\nindustry_number_of_gas_chp: 180.0\nindustry_steel_blastfurnace_current_share: 48.1\nindustry_steel_hisarna_share: 0.0\nindustry_steel_electricfurnace_share: 1.9\nindustry_steel_blastfurnace_bat_share: 50.0\nagriculture_heating_gas_fired_heater_share: 31.5593628\nagriculture_heating_oil_fired_heater_share: 0.0\nagriculture_heating_biomass_fired_heater_share: 0.635429\nagriculture_heating_heat_pump_with_ts_share: 0.3862728\nagriculture_heating_geothermal_share: 10.0\nagriculture_heating_combined_heat_power_share: 57.4189354\ninvestment_costs_solar_solar_panels: -75.0\ncosts_gas: -50.0\ncosts_co2_free_allocation: 0.0\ncosts_co2: 1000.0\nsettings_enable_merit_order: 0.0\nnumber_of_pulverized_coal: 0.0\nnumber_of_coal_iggc: 0.0\nnumber_of_central_coal_chp: 0.0\nnumber_of_gas_conventional: 0.0\nnumber_of_pulverized_coal_ccs: 2.5\nnumber_of_wind_onshore_land: 2000.0\nnumber_of_wind_offshore: 100.0\nnatural_gas_total_share: 99.0\ngreen_gas_total_share: 1.0\nnumber_of_gas_turbines: 0.0\nnumber_of_large_gas_chp: 0.0\nhouseholds_heating_gas_combi_heater_share: 60.9348454\nhouseholds_heating_heat_pump_ground_share: 20.0\nhouseholds_heating_district_heating_network_share: 3.0538449504402303\nhouseholds_heating_pellet_stove_share: 2.56807929679186\nhouseholds_heating_electric_heater_share: 1.7665909822899801\nhouseholds_heating_gas_fired_heater_share: 10.3666245320529\nhouseholds_heating_oil_fired_heater_share: 1.2481851967881\nhouseholds_heating_coal_fired_heater_share: 0.06182960727123701\nhouseholds_heating_heat_pump_add_
dennisquintel commented 11 years ago

including @ChaelKruip: can you add the following to the deploy procedure?

We should therefor delete all Preset scenarios from the database when they have been added.

ChaelKruip commented 11 years ago

can you add the following to the deploy procedure?

Done.

dennisquintel commented 11 years ago

Also: it should be deleted from the user/scenario mapping on etmodel:

Deleted scenarios from etmodel@production database

INSERT INTO `saved_scenarios` (`id`, `user_id`, `scenario_id`, `settings`, `created_at`, `updated_at`)
VALUES
    (1201, 764, 132824, NULL, '2013-02-11 10:34:13', '2013-02-11 10:34:13'),
    (1404, 3, 134183, NULL, '2013-02-15 10:21:11', '2013-02-15 10:21:11'),
    (1406, 160, 134237, NULL, '2013-02-15 13:54:50', '2013-02-15 13:54:50'),
    (1413, 3, 134355, NULL, '2013-02-18 13:50:42', '2013-02-18 13:50:42'),
    (1414, 728, 134450, NULL, '2013-02-19 13:47:54', '2013-02-19 13:47:54'),
    (1415, 1250, 134476, NULL, '2013-02-19 15:38:11', '2013-02-19 15:38:11'),
    (1416, 158, 134491, NULL, '2013-02-19 16:53:08', '2013-02-19 16:53:08'),
    (1417, 158, 134527, NULL, '2013-02-20 09:52:01', '2013-02-20 09:52:01'),
    (1529, 161, 135570, NULL, '2013-02-27 12:29:05', '2013-02-27 12:29:05'),
    (1633, 158, 137349, NULL, '2013-03-05 16:07:15', '2013-03-05 16:07:15'),
    (1687, 158, 138750, NULL, '2013-03-11 09:59:58', '2013-03-11 09:59:58'),
    (1688, 160, 138814, NULL, '2013-03-11 12:03:28', '2013-03-11 12:03:28'),
    (1696, 1329, 139023, NULL, '2013-03-12 10:27:01', '2013-03-12 10:27:01'),
    (1698, 161, 139197, NULL, '2013-03-12 14:02:08', '2013-03-12 14:02:08');