{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["configuration","Intro","Survey Questions","GOVT R&D","GOVT demonstration","STATE-OWNED R&D","STATE-OWNED demonstration","PRIVATE-SECTOR"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":10,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"configuration","index":0,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["title",null,"FOR THE "," / "," SLT / CERT ANNUAL REVIEW"]
[]
["country name",null,"Germany"]
[]
["cycle years",null,2023,{"$f":"C5+1","v":2024}]
[]
["data years",null,{"$f":"D7-1","v":2019},{"$f":"E7-1","v":2020},{"$f":"F7-1","v":2021},{"$f":"G7-1","v":2022},{"$f":"H7-1","v":2023},{"$f":"D5","v":2024}]
[]
[]
[]
["product - worksheet correspondance",null,null,null,"do not change, this is used in VB"]
[null,null,null,null,"product","worksheet"]
["product","worksheet name",null,null,"STATERD",{"$f":"VLOOKUP(E13,A14:B24,2,FALSE)","v":"STATE-OWNED R&D"}]
["GOVTRD","GOVT R&D"]
["GOVTDEMO","GOVT demonstration"]
["STATERD","STATE-OWNED R&D"]
["STATEDEMO","STATE-OWNED demonstration"]
["PRIVATERDD","PRIVATE-SECTOR"]
["RDDNC"]
["RDDNCREAL"]
["RDDUSD"]
["RDDUSDPPP"]
["RDDEURO"]
["SHARE"]

{"sheet":"Intro","index":1,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7],[41,0,41,7],[31,0,31,7],[34,0,34,7],[37,0,37,7],[5,0,5,7],[40,0,40,7],[24,0,29,6],[22,0,22,6]]}
["QUESTIONNAIRE FOR COUNTRY SUBMISSIONS"]
[{"$f":"configuration!C1&configuration!C5&configuration!D1&configuration!D5&configuration!E1","v":"FOR THE 2023 / 2024 SLT / CERT ANNUAL REVIEW"}]
[]
[{"$f":"configuration!C3","v":"Germany"}]
[]
["The International Energy Agency (IEA) acts as energy policy advisor for the governments of its 31 member countries and beyond to promote reliable, affordable and clean energy for the world’s consumers.\nAs such, one of its priorities is to collect data on research, development and demonstration (RD&D) spending in the field of energy. The IEA has been collecting data on government funding of RD&D activities across countries since 1974. These data provide invaluable information to policy makers across the globe to help their decisions on energy RD&D investments as well as their formulation of other policies affecting innovation, including market pull policies. The private sector can also benefit from a deeper understanding of government activities in energy RD&D."]
[]
["Instructions for completing the questionnaire:"]
[]
["Please complete the survey and the tables on the following sheets:"]
[]
["Survey Questions","Questions related to the data collection and coverage"]
[]
[null,"Funder",null,null,null,"Data"]
["Table 1","Government (excluding state-owned enterprises)",null,null,null,"R&D budget (excluding demonstration)"]
["Table 2","Government (excluding state-owned enterprises)",null,null,null,"Demonstration"]
["Table 3","State-owned enterprises",null,null,null,"R&D budget (excluding demonstration)"]
["Table 4","State-owned enterprises",null,null,null,"Demonstration"]
["Table 5","Private sector",null,null,null,"R&D and Demonstration budget"]
[]
["Entering the data:"]
["1. Data Format"]
["If a figure is nil, please enter a “0” in the cell. Do not put a blank."]
["2. Data Entry and Cutting/Pasting"]
["Data are entered by typing the data directly into the cell.\n\nIn case copying&pasting data, please use 'PasteSpecial-> PasteValues'-function\n\nWhen data entry is complete, click the \"Check\"-button on top. Potential errors are highlighted in orange (e.g. sub-totals not adding up). \n"]
[]
[]
[]
[]
[]
[]
["For more information on how to fill the questionnaire please refer to the IEA Guide to Reporting Energy RD&D Budget / Expenditure statistics which contains reporting instructions and detailed definitions:\n\n"]
["https://iea.blob.core.windows.net/assets/3432ae79-1645-4cf1-a415-faa3588e6f29/RDDManual.pdf"]
[]
["The database is available here:"]
["https://www.iea.org/data-and-statistics/data-product/energy-technology-rd-and-d-budget-database-2"]
[]
["A data explorer is available here:"]
["https://www.iea.org/data-and-statistics/data-tools/energy-technology-rdd-budgets-data-explorer"]
[]
["Note: Fundings from the European Union under projects such as Horizon Europe should not be included in national submissions. They are submitted separately by the European Union."]
["Note: A separate line for \"unallocated\" has been provided at each level of the questionnaire in the case where detailed information is not known.  However, countries should make every effort to report as detailed information as possible.  \n"]
["Please address your inquiries to:"]
["RDD@iea.org "]
[]
[]
[]
[null," "]

{"sheet":"Survey Questions","index":2,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,1,33,8],[8,1,8,8],[9,1,9,8],[10,1,10,8],[14,1,14,8],[17,0,17,8],[19,1,21,8],[23,1,25,8],[27,1,29,8],[4,1,4,8],[3,1,3,8],[7,1,7,8],[15,1,15,8],[16,1,16,8],[11,1,11,8],[12,1,12,8],[13,1,13,8],[5,1,5,8],[6,1,6,8]]}
["Survey questions / Comments"]
[]
["Survey Questions"]
["1)","Can you indicate which major institutions/programmes are included in the submission?\n\nCan you give an estimation of the data coverage? Which areas/institutions are not covered?"]
["Answer"]
["2)","Are demonstration budget data included? If yes, are they included separately (GOVT/STATE_OWNED demonstration) or in the R&D sections (GOVT/STATE-OWNED R&D)?"]
["Answer"]
["3)","Could you clarify the budgetary stages of the data you submitted for the years 2020/2021/2022E/2023E?\n\nOr alternatively select the budgetary stage in the green cells of each tables? (see Section IV.2 in the manual for details). Please also note that ideally final data should be based on final budget appropriations in order to best analyze the impact of policies."]
["Answer"]
["4)","If data has been submitted for state-owned companies, can you please indicate which companies are included?\n\nIf SOE data has been submitted, are they submitted separately (STATE-OWNED R&D/DEMONSTRATION sheets) or are they included in the Government or private sector sections?"]
["Answer"]
["5)","Could you let us know if there is an existing reference document published in your country, on which the energy RD&D data is based?\n\nDoes it lay out the Government’s programmes and budgets being undertaken or scheduled in this field? "]
["Answer"]
["6)","Could you clarify the scope of the data (inclusion of exclusion) concerning international/European R&D programmes?\n\nPlease not that European Union fundings under programmes such as Horizon Europe should not be included in national submissions, they are submitted separately."]
["Answer"]
["7)","If private sector data has been provided, can you provide more information about the estimated coverage of the data?"]
["Answer"]
["Please provide any comments about the tables or workbook here. You can also use this page as a scratch pad for workings."]
[]
["Comment 1:"]
[]
[]
[]
["Comment 2:"]
[]
[]
[]
["Comment 3:"]
[]
[]
[]
["Comment 4:"]

{"sheet":"GOVT R&D","index":3,"n_rows":227,"n_cols":28,"rows_kept":227,"cut":false,"hidden":false,"merged":[[214,2,214,3],[4,0,4,3],[195,2,195,3],[193,0,193,3],[5,0,5,3],[6,0,6,3]]}
["Funder: Government (excluding state-owned enterprises)",null,null,null,"Data:  R&D budget (excluding demonstration)",null,null,null,null,"number of decimals",null,null,null,"CHECKS",null,null,null,null,null,null,null,null,null,null,null,null,"SHORTNAME"]
["Millions, national currency",null,null,null,null,{"$f":"configuration!C3","v":"Germany"},null,null,null,3,null,null,null,null,null,"TRUE means check is ok, FALSE will trigger the color change"]
[]
["Table 1",null,null,null,"2019","2020","2021","2022","2023Est","2024Est",null,null,null,null,{"$f":"E4","v":"2019"},"2020","2021","2022","2023Est","2024Est"]
["After checking data, orange cells denote that the sub-total does not equal the sum of the elements.",null,null,null,"R&D budget","R&D budget","R&D budget","R&D budget","R&D budget","R&D budget",null,null,null,"tolerance",{"$f":"VLOOKUP(J2,V7:W13,2,FALSE)","v":1E-3}]
["BUDGETARY STAGE (see Section IV.2 of manual on reporting issues)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"decimals","tolerance"]
["FISCAL YEAR STARTING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1]
["1  ENERGY EFFICIENCY (sum of rows 11 to 19)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E8-(E9+E14+E31+E44+E51)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,1,0.1,null,null,null,"EFFICIENCY","GROUP 1: ENERGY EFFICIENCY"]
[null,"11 Industry                      ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E9-SUM(E10:E13)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,2,0.01,null,null,null,"11EFFIND","11 Industry"]
[null,null,"111 Industrial techniques and processes",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,3,1E-3,null,null,null,"111INDTE","111 Industrial techniques and processes"]
[null,null,"112 Industrial equipment and systems",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,4,1E-4,null,null,null,"112INDEQ","112 Industrial equipment and systems"]
[null,null,"113 Other industry",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,5,1.0000000000000001E-5,null,null,null,"113INDOT","113 Other industry"]
[null,null,"119 Unallocated industry",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,6,9.9999999999999995E-7,null,null,null,"119INDUN","119 Unallocated industry"]
[null,"12 Residential and commercial buildings, appliances and equipment",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E14-(E15+E19+E25+E30)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"12EFFRCO","12 Res. and comm. buildings, appliances and equipment"]
[null,null,"121 Building design and envelope",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E15-SUM(E16:E18)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"121BUDEE","121 Building design and envelope"]
[null,null,null,"1211 Building envelope technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1211ENVE","1211 Building envelope technologies"]
[null,null,null,"1212 Building design ",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1212DESI","1212 Building design"]
[null,null,null,"1219 Unallocated building design and envelope",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1219BUUN","1219 Unallocated building design and envelope"]
[null,null,"122 Building operations and efficient building equipment ",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E19-SUM(E20:E24)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"122OPERA","122 Building operation and efficient building equipment"]
[null,null,null,"1221 Building energy management systems (incl. smart meters) and efficient internet\n          and communication technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1221EMAN","1221 Building management systems and eff. ICT"]
[null,null,null,"1222 Lighting technologies and control systems",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1222LTEC","1222 Lighting technologies and control systems"]
[null,null,null,"1223 Heating, cooling and ventilation technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1223HEAT","1223 Heating, cooling and ventilation technologies"]
[null,null,null,"1224 Other building operations and efficient building equipment",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1224OTHE","1224 Other building ops. and eff. building equipment"]
[null,null,null,"1229 Unallocated building operations and efficient building equipment",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1229OPUN","1229 Unallocated building operations and equipment"]
[null,null,"123 Appliances and other residential/commercial ",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E25-SUM(E26:E29)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"123APPLI","123 Appliances and other res/comm"]
[null,null,null,"1231 Appliances ",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1231APPL","1231 Appliances"]
[null,null,null,"1232 Batteries for portable devices",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1232BATT","1232 Batteries for portable devices"]
[null,null,null,"1233 Other residential/commercial",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1233ORCO","1233 Other residential/commercial"]
[null,null,null,"1239 Unallocated appliances and other residential/commercial",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1239APUN","1239 Unallocated appliances and other res/comm"]
[null,null,"129 Unallocated residential and commercial buildings, appliances and equipment",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"129EFFRUN","129 Unalloc. res/comm bldings, appliances and equipment"]
[null,"13 Transport             ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E31-(E32+E41+E42+E43)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"13TRANSP","13 Transport"]
[null,null,"131 On-road vehicles",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E32-SUM(E33:E40)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"131ORVEH","131 On-road vehicles"]
[null,null,null,"1311 Vehicle batteries/storage technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1311VBAT","1311 Vehicle batteries/storage technologies"]
[null,null,null,"1312 Advanced power electronics, motors and EV/HEV/FCV systems",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1312ADVA","1312 Advd power elecs, motors, EV/HEV/FCV sys"]
[null,null,null,"1313 Advanced combustion engines",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1313ENGI","1313 Advanced combustion engines"]
[null,null,null,"1314 Electric vehicle infrastructure (incl. smart chargers and grid communications)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1314INFR","1314 Electric vehicle infrastructure"]
[null,null,null,"1315 Use of fuels for on-road vehicles (excl. hydrogen)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1315UFUE","1315 Fuel for on-road vehicles (excl. hydrogen)"]
[null,null,null,"1316 Materials for on-road vehicles",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1316MATE","1316 Materials for on-road vehicles"]
[null,null,null,"1317 Other on-road transport",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1317OTHE","1317 Other on-road transport"]
[null,null,null,"1319 Unallocated on-road vehicles",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1319ORUN","1319 Unallocated on-road vehicles"]
[null,null,"132 Off-road transport and transport systems",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"132OFFRO","132 Off-road transport and transport systems"]
[null,null,"133 Other transport",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"133OTRAN","133 Other transport"]
[null,null,"139 Unallocated transport",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"139TRANUN","139 Unallocated transport"]
[null,"14 Other energy efficiency",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E44-SUM(E45:E50)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"14OEFFIC","14 Other energy efficiency"]
[null,null,"141 Waste heat recovery and utilisation",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"141WASTE","141 Waste heat recovery and utilisation"]
[null,null,"142 Communities",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"142COMMU","142 Communities"]
[null,null,"143 Agriculture and forestry",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"143AGRIF","143 Agriculture and forestry"]
[null,null,"144 Heat pumps and chillers",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"144HEATP","144 Heat pumps and chillers"]
[null,null,"145 Other energy efficiency",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"145OENEF","145 Other energy efficiency"]
[null,null,"149 Unallocated other energy efficiency",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"149OEFUN","149 Unallocated other energy efficiency"]
[null,"19 Unallocated energy efficiency",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"19EFFUN","19 Unallocated energy efficiency"]
["2  FOSSIL FUELS: OIL, GAS and COAL (sum of rows 21 to 29)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E52-(E53+E61+E67+E72)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"FOSSILFUEL","GROUP 2: FOSSIL FUELS"]
[null,"21 Oil and gas",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E53-SUM(E54:E60)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"21OILGAS","21 Oil and gas"]
[null,null,"211 Enhanced oil and gas production",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"211ENHAN","211 Enhanced oil and gas production"]
[null,null,"212 Refining, transport and storage of oil and gas",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"212REFIN","212 Refining, transpt, storage of oil and gas"]
[null,null,"213 Non-conventional oil and gas production",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"213NONCO","213 Non-conventional oil and gas production"]
[null,null,"214 Oil and gas combustion              ",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"214COMBU","214 Oil and gas combustion"]
[null,null,"215 Oil and gas conversion",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"215CONVE","215 Oil and gas conversion"]
[null,null,"216 Other oil and gas",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"216OTOIL","216 Other oil and gas"]
[null,null,"219 Unallocated oil and gas",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"219OGUN","219 Unallocated oil and gas"]
[null,"22 Coal",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E61-SUM(E62:E66)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"22COAL","22 Coal"]
[null,null,"221 Coal production, preparation and transport",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"221CPROD","221 Coal production, preparation and transport"]
[null,null,"222 Coal combustion (incl. IGCC)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"222CCOMB","222 Coal combustion (incl. IGCC)"]
[null,null,"223 Coal conversion (excl. IGCC)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"223CCONV","223 Coal conversion (excl. IGCC)"]
[null,null,"224 Other coal",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"224OCOAL","224 Other coal"]
[null,null,"229 Unallocated coal",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"229COALUN","229 Unallocated coal"]
[null,"23 CO2 capture and storage",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E67-SUM(E68:E71)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"23CO2CS","23 CO2 capture and storage"]
[null,null,"231 CO2 capture/separation",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"231CAPSE","231 CO2 capture/separation"]
[null,null,"232 CO2 transport",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"232CTRAN","232 CO2 transport"]
[null,null,"233 CO2 storage",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"233CSTOR","233 CO2 storage"]
[null,null,"239 Unallocated CO2 capture and storage",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"239CO2CSUN","239 Unallocated CO2 capture and storage"]
[null,"29 Unallocated fossil fuels",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"29FOSFUN","29 Unallocated fossil fuels"]
["3  RENEWABLE ENERGY SOURCES (sum of rows 31 to 39)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E73-(E74+E79+E84+E90+E106+E112+E116+E117)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"RENEWABLE","GROUP 3: RENEWABLE ENERGY SOURCES"]
[null,"31 Solar energy",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E74-SUM(E75:E78)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"31SOLAR","31 Solar energy"]
[null,null,"311 Solar heating and cooling",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"311SHEAT","311 Solar heating and cooling"]
[null,null,"312 Solar photovoltaics",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"312PHOTOV","312 Photovoltaics"]
[null,null,"313 Solar thermal power and high-temp. applications",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"313THERMA","313 Solar thermal power and high-temp. applications"]
[null,null,"319 Unallocated solar energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"319SOLUN","319 Unallocated solar energy"]
[null,"32 Wind energy",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E79-SUM(E80:E83)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"32WIND","32 Wind energy"]
[null,null,"321 Onshore wind technologies",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"321WONSH","321 Onshore wind technologies"]
[null,null,"322 Offshore wind technologies (excl. low wind speed)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"322WOFFS","322 Offshore wind techs (excl. low wind speed)"]
[null,null,"323 Wind energy systems and other technologies",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"323WSYST","323 Wind energy systems and other technologies"]
[null,null,"329 Unallocated wind energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"329WINDUN","329 Unallocated wind energy"]
[null,"33 Ocean energy                          ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E84-SUM(E85:E89)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"33OCEAN","33 Ocean energy"]
[null,null,"331 Tidal energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"331TIDAL","331 Tidal energy"]
[null,null,"332 Wave energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"332WAVE","332 Wave energy"]
[null,null,"333 Salinity gradient power",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"333SALIN","333 Salinity gradient power"]
[null,null,"334 Other ocean energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"334OOTHE","334 Other ocean energy"]
[null,null,"339 Unallocated ocean energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"339OCEUN","339 Unallocated ocean energy"]
[null,"34 Biofuels (incl. liquid biofuels, solid biofuels and biogases)",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E90-(E91+E97+E98+E103+E104+E105)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"34BIOFUE","34 Biofuels (incl. liquids, solids and biogases)"]
[null,null,"341 Production of liquid biofuels",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E91-SUM(E92:E96)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"341LPROD","341 Production of liquid biofuels"]
[null,null,null,"3411 Gasoline substitutes (incl. ethanol)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3411GAS","3411 Gasoline substitutes (incl. ethanol)"]
[null,null,null,"3412 Diesel, kerosene and jet fuel substitutes",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3412DIES","3412 Diesel, kerosene and jet fuel substitutes"]
[null,null,null,"3413 Algal biofuels",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3413ALG","3413 Algal biofuels"]
[null,null,null,"3414 Other liquid fuel substitutes",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3414LOTH","3414 Other liquid fuel substitutes"]
[null,null,null,"3419 Unallocated production of liquid biofuels ",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3419LPUN","3419 Unallocated production of liquid biofuels"]
[null,null,"342 Production of solid biofuels",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"342SPROD","342 Production of solid biofuels"]
[null,null,"343 Production of biogases",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E98-SUM(E99:E102)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"343GPROD","343 Production of biogases"]
[null,null,null,"3431 Thermochemical",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3431GTHE","3431 Thermochemical"]
[null,null,null,"3432 Biochemical (incl. anaerobic digestion)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3432GBIO","3432 Biochemical (incl. anaerobic digestion)"]
[null,null,null,"3433 Other biogases",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3433GOTH","3433 Other biogases"]
[null,null,null,"3439 Unallocated production of biogases",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3439GPUN","3439 Unallocated production of biogases"]
[null,null,"344 Applications for heat and electricity",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"344BAPPL","344 Applications for heat and electricity"]
[null,null,"345 Other biofuels",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"345BOTHE","345 Other biofuels"]
[null,null,"349 Unallocated biofuels",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"349BIOUN","349 Unallocated biofuels"]
[null,"35 Geothermal energy",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E106-SUM(E107:E111)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"35GEOTHE","35 Geothermal energy"]
[null,null,"351 Geothermal energy from hydrothermal resources",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"351GEOHY","351 Hydrothermal resources"]
[null,null,"352 Geothermal energy from hot dry rock (HDR) resources",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"352GEHDR","352 Hot dry rock resources"]
[null,null,"353 Advanced drilling and exploration",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"353DRILL","353 Advanced drilling and exploration"]
[null,null,"354 Other geothermal energy (incl. low-temp. resources)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"354GOTHE","354 Other geothermal energy"]
[null,null,"359 Unallocated geothermal energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"359GEOUN","359 Unallocated geothermal energy"]
[null,"36 Hydroelectricity",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E112-SUM(E113:E115)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"36HYDROE","36 Hydroelectricity"]
[null,null,"361 Large hydroelectricity (capacity of 10 MW and above)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"361HLARG","361 Large hydroelectricity (10MW plus)"]
[null,null,"362 Small hydroelectricity (capacity less than 10 MW)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"362HSMAL","362 Small hydroelectricity (less than 10MW)"]
[null,null,"369 Unallocated hydroelectricity",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"369HYDRUN","369 Unallocated hydroelectricity"]
[null,"37 Other renewable energy sources",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"37OTHREN","37 Other renewable energy sources"]
[null,"39 Unallocated renewable energy sources",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"39RENUN","39 Unallocated renewable energy sources"]
["4  NUCLEAR FISSION and FUSION (sum of rows 41 and 49)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E118-(E119+E139+E144)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"NUCLEAR","GROUP 4: NUCLEAR"]
[null,"41 Nuclear fission",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E119-(E120+E121+E125+E130+E136+E137+E138)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"41FISSON","41 Nuclear fission"]
[null,null,"411 Light water reactors (LWRs)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"411LWRS","411 Light water reactors (LWRs)"]
[null,null,"412 Other converter reactors",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E121-SUM(E122:E124)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"412OTHNU","412 Other converter reactors"]
[null,null,null,"4121 Heavy water reactors (HWRs)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4121HWRS","4121 Heavy water reactors (HWRs)"]
[null,null,null,"4122 Other converter reactors",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4122OTHE","4122 Other converter reactors"]
[null,null,null,"4129 Unallocated other converter reactors",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4129OTNUN","4129 Unallocated other converter reactors"]
[null,null,"413 Fuel cycle",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E125-SUM(E126:E129)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"413FUCYC","413 Fuel cycle"]
[null,null,null,"4131 Fissile material recycling / reprocessing",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4131RECY","4131 Fissile material recycling/reprocessing"]
[null,null,null,"4132 Nuclear waste management",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4132WAST","4132 Nuclear waste management"]
[null,null,null,"4133 Other fuel cycle",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4133OTCY","4133 Other fuel cycle"]
[null,null,null,"4139 Unallocated fuel cycle",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4139FUCUN","4139 Unallocated fuel cycle"]
[null,null,"414 Nuclear supporting technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E130-SUM(E131:E135)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"414SUPTE","414 Nuclear supporting technologies"]
[null,null,null,"4141 Plant safety and integrity",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4141SAFE","4141 Plant safety and integrity"]
[null,null,null,"4142 Environmental protection ",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4142PROT","4142 Environmental protection"]
[null,null,null,"4143 Decommissioning",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4143DECO","4143 Decommissioning"]
[null,null,null,"4144 Other nuclear supporting technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4144ONUC","4144 Other nuclear supporting technologies"]
[null,null,null,"4149 Unallocated nuclear supporting technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4149ONUN","4149 Unallocated nuclear supporting technologies"]
[null,null,"415 Nuclear breeder",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"415BREED","415 Nuclear breeder"]
[null,null,"416 Other nuclear fission",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"416OFISS","416 Other nuclear fission"]
[null,null,"419 Unallocated nuclear fission",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"419FISUN","419 Unallocated nuclear fission"]
[null,"42 Nuclear fusion",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E139-SUM(E140:E143)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"42FUSION","42 Nuclear fusion"]
[null,null,"421 Magnetic confinement",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"421MACON","421 Magnetic confinement"]
[null,null,"422 Inertial confinement",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"422INCON","422 Inertial confinement"]
[null,null,"423 Other nuclear fusion",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"423OFUSI","423 Other nuclear fusion"]
[null,null,"429 Unallocated nuclear fusion",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"429FUSUN","429 Unallocated nuclear fusion"]
[null,"49 Unallocated nuclear fission and fusion",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"49NUCUN","49 Unallocated nuclear"]
["5  HYDROGEN and FUEL CELLS (sum of rows 51 and 59)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E145-(E146+E153+E158)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"HGENCELL","GROUP 5: HYDROGEN AND FUEL CELLS"]
[null,"51 Hydrogen",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E146-SUM(E147:E152)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"51HYDROG","51 Hydrogen"]
[null,null,"511 Hydrogen production",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"511HYPRO","511 Hydrogen production"]
[null,null,"512 Hydrogen  storage",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"512HYSTO","512 Hydrogen storage"]
[null,null,"513 Hydrogen transport and distribution",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"513HYTRA","513 Hydrogen transport and distribution"]
[null,null,"514 Other infrastructure and systems ",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"514HYINF","514 Other infrastructure and systems"]
[null,null,"515 Hydrogen end-uses (incl. combustion; excl. fuel cells and vehicles)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"515HYEND","515 Hydrogen end-uses"]
[null,null,"519 Unallocated hydrogen",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"519HYDUN","519 Unallocated hydrogen"]
[null,"52 Fuel cells",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E153-SUM(E154:E157)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"52FUELCE","52 Fuel cells"]
[null,null,"521 Stationary applications",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"521FUSTA","521 Stationary applications"]
[null,null,"522 Mobile applications",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"522FUMOB","522 Mobile applications"]
[null,null,"523 Other applications",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"523FUOTH","523 Other applications"]
[null,null,"529 Unallocated fuel cells",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"529FUELUN","529 Unallocated fuel cells"]
[null,"59 Unallocated hydrogen and fuel cells",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"59HYFUUN","59 Unallocated hydrogen and fuel cells"]
["6  OTHER POWER and STORAGE TECHNOLOGIES (sum of rows 61 to 69)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E159-(E160+E165+E177+E186)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"OTHERPANDS","GROUP 6: OTHER POWER AND STORAGE TECHNOLOGIES"]
[null,"61 Electric power generation    ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E160-SUM(E161:E164)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"61POWCON","61 Electric power conversion"]
[null,null,"611 Power generation technologies",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"611GETEC","611 Power generation technologies"]
[null,null,"612 Power generation supporting technologies",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"612GESUP","612 Power generation supporting technologies"]
[null,null,"613 Other electric power generation",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"613GEOTH","613 Other electricity power generation"]
[null,null,"619 Unallocated electric power generation",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"619POWUN","619 Unallocated electric power generation"]
[null,"62 Electricity transmission and distribution",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E165-(E166+E171+E176)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"62TRADIS","62 Electricity transmission and distribution"]
[null,null,"621 Transmission and distribution technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E166-SUM(E167:E170)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"621TDTEC","621 Transmission and distribution technologies"]
[null,null,null,"6211 Cables and conductors (superconducting, conventional, composite core)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6211CABL","6211 Cables and conductors"]
[null,null,null,"6212 AC/DC conversion",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6212ACDC","6212 AC/DC conversion"]
[null,null,null,"6213 Other transmission and distribution technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6213OTHE","6213 Other transmission and distribution techs."]
[null,null,null,"6219 Unallocated transmission and distribution technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6219TDTUN","6219 Unallocated transmission and distribution"]
[null,null,"622 Grid communication, control systems and integration",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E171-SUM(E172:E175)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"622GRIDC","622 Grid comm, control systems and integration"]
[null,null,null,"6221 Load management (incl. renewable integration)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6221LOAD","6221 Load management"]
[null,null,null,"6222 Control systems and monitoring",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6222CONT","6222 Control systems and monitoring"]
[null,null,null,"6223 Standards, interoperability and grid cyber security",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6223STAN","6223 Standards, interoper.+grid cyber security"]
[null,null,null,"6229 Unallocated grid communication, control systems and integration",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6229GRIDUN","6229 Unallocated grid comm,, control and integration"]
[null,null,"629 Unallocated electricity transmission and distribution",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"629TRANUN","Unallocated electricity transmission/distribution"]
[null,"63 Energy storage (non-transport applications)              ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E177-(E178+E184+E185)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"63ENSTOR","63 Energy storage"]
[null,null,"631 Electrical storage",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E178-SUM(E179:E183)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"631ELSTO","631 Electrical storage"]
[null,null,null,"6311 Batteries and other electrochemical storage (excl. vehicles and general \n         public portable devices)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6311BATT","6311 Batteries/other electrochemical storage"]
[null,null,null,"6312 Electromagnetic storage",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6312ELMA","6312 Electromagnetic storage"]
[null,null,null,"6313 Mechanical storage",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6313MECH","6313 Mechanical storage"]
[null,null,null,"6314 Other storage (excl. fuel cells)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6314OSTO","6314 Other storage (excl. fuel cells)"]
[null,null,null,"6319 Unallocated electrical storage",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6319ELSUN","6319 Unallocated electrical storage"]
[null,null,"632 Thermal energy storage",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"632THEST","632 Thermal energy storage"]
[null,null,"639 Unallocated energy storage ",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"639ENSTUN","639 Unallocated energy storage"]
[null,"69 Unallocated other power and storage technologies",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"69OPOWUN","69 Unallocated other power and storage techs."]
["7  OTHER CROSS-CUTTING TECHNOLOGIES or RESEARCH (sum of rows 71 to 73)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E187-SUM(E188:E190)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"OTHERTECH","GROUP 7: OTHER CROSS-CUTTING TECHS/RESEARCH"]
[null,"71 Energy system analysis",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"71SYSANA","71 Energy system analysis"]
[null,"72 Basic energy research that cannot be allocated to a specific category",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"72BASICUN","72 Basic energy research not allocated"]
[null,"73 Other",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"73OTHER","73 Other"]
["8  UNALLOCATED",null,null,null,0,0,0,0,0,0,null,null,null,"blue",null,null,null,null,null,null,null,null,null,null,null,null,"UNALLOC","GROUP 8: UNALLOCATED"]
["TOTAL BUDGET (sum of rows 1 to 8)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL","TOTAL BUDGET"]
["CHECK 1st LEVEL TOTALS",null,null,null,{"$f":"IF(ROUND(ABS(E192-SUM(E8+E52+E73+E118+E145+E159+E187+E191)),$J$2)>$O$5,ROUND(ABS(E192-SUM(E8+E52+E73+E118+E145+E159+E187+E191)),$J$2),0)","v":0},0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"###"]
["MEMO ITEMS:",null,null,null,null,null,null,null,null,null,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"###"]
[null,"Smart grids",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E195-SUM(E196:E201)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEMSMART","Memo: Smart grids"]
[null,null,"Part of 1221 (optional) Building energy management systems (incl. smart meters) and \n            efficient internet and communication technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E196<=E20","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1221","Memo: Part of 1221"]
[null,null,"1314 (optional) Electric vehicle infrastructure",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E197=E36","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1314A","Memo: Electric vehicle infrastructure"]
[null,null,"621 Transmission and distribution technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E198=E166","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM621","Memo: Transmission and distribution technologies"]
[null,null,"622 Grid communication, control systems and integration",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E199=E171","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM622","Memo: Grid communication etc"]
[null,null,"Part of 71 Energy system analysis that is part of the smart grid concept",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E200<=E188","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM71","Memo: Part of 71"]
[null,null,"Smart grid figures not identified in previous categories",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEMOTHSM","Memo: Smart grids not specified"]
[null,"Electric vehicles",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E202-SUM(E203:E206)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEMELVEH","Memo: Electric vehicles"]
[null,null,"Part of 1311 (optional) Vehicle batteries/storage technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E203<=E33","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1311A","Memo: Part of 1311"]
[null,null,"Part of 1312 (optional) Advanced power electronics, motors, and EV/HEV/FCV systems",null,0,0,0,0,0,0,null,null,null,"white",true,true,true,true,true,true,null,null,null,null,null,null,"MEM1312","Memo: Parts of 1312"]
[null,null,"1314 (optional) Electric vehicle infrastructure ",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E205=E36","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1314B","Memo: Electric vehicle infrastructure"]
[null,null,"Electric vehicle figures not identified in previous categories",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEMOTHEV","Memo: Electric Vehicles not specified"]
[null,"Energy storage",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E207-SUM(E208:E212)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEMENSTO","Memo: Energy Storage"]
[null,null,"1232 (optional) Batteries for portable devices",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E208=E27","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1232","Memo: Batteries for portable devices"]
[null,null,"1311 (optional) Vehicle batteries/storage technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E209=E33","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1311B","Memo: Vehicle batteries/storage technologies"]
[null,null,"512 Hydrogen storage",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E210=E148","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM512","Memo: Hydrogen storage"]
[null,null,"63 Energy storage (non-transport applications)",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E211=E177","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM63","Memo: Energy storage (non-transport apps)"]
[null,null,"Energy storage figures not identified in previous categories",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEMOTES","Memo: Energy storage not specified"]
[null,"Low-carbon heating and cooling of buildings (relevant component of)",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E213-SUM(E214:E216,E220:E227)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEMHEAT","Memo: Low-carbon heating and cooling of buildings"]
[null,null,"1211 Building envelope technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E214=E16","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1211","Memo: Building envelope technologies"]
[null,null,"1221 Building energy management systems (incl. smart meters) and efficient internet\n          and communication technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E215=E20","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1221B","Memo: Building energy management systems"]
[null,null,"1223 Heating, cooling and ventilation technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E216=E22","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1223","Memo: Heating, cooling and ventilation technologies"]
[null,null,null,"12231 Heating (optional)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEM12231","Memo: Heating (optional)"]
[null,null,null,"12232 Cooling (optional)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEM12232","Memo: Cooling (optional)"]
[null,null,null,"12233 Ventilation/other (optional)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEM12233","Memo: Ventilation (optional)"]
[null,null,"Part of 141 Waste heat recovery and utilisation",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E220<=E45","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM141","Memo: Waste heat recovery"]
[null,null,"Part of 142 Communities - District heating and cooling",null,0,0,0,0,0,0,null,null,null,"white",true,true,true,true,true,true,null,null,null,null,null,null,"MEM142","Memo: Communities - district heating and cooling"]
[null,null,"Part of 144 Heat pumps and chillers",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E222<=E48","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM144","Memo: Heat pumps and chillers"]
[null,null,"Part of 311 Solar heating and cooling",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E223<=E75","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM311","Memo: Solar heating and cooling"]
[null,null,"Part of 344 Biofuels - Applications for heat and electricity",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E224<=E103","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM344","Memo: Biofuels - Applications for heat and electricity"]
[null,null,"Part of 354 Other geothermal energy (incl. low-temp. resources)",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E225<=E110","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM354","Memo: Other geothermal energy"]
[null,null,"Part of 632 Thermal energy storage",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E226<=E632","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM632","Memo: Thermal energy storage"]
[null,null,"Low-carbon heating and cooling of buildings not identified in previous categories",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEMOTHEAT","Memo: Heat and cooling of buildings not specified"]

{"sheet":"GOVT demonstration","index":4,"n_rows":227,"n_cols":28,"rows_kept":227,"cut":false,"hidden":false,"merged":[[4,0,4,3],[5,0,5,3],[6,0,6,3],[193,0,193,3],[214,2,214,3],[195,2,195,3]]}
["Funder: Government (excluding state-owned enterprises)",null,null,null,"Data:  Demonstration",null,null,null,null,"number of decimals",null,null,null,"CHECKS",null,null,null,null,null,null,null,null,null,null,null,null,"SHORTNAME"]
["Millions, national currency",null,null,null,null,{"$f":"configuration!C3","v":"Germany"},null,null,null,3,null,null,null,null,null,"TRUE means check is ok, FALSE will trigger the color change"]
[]
["Table 2",null,null,null,"2019","2020","2021","2022","2023Est","2024Est",null,null,null,null,{"$f":"E4","v":"2019"},"2020","2021","2022","2023Est","2024Est"]
["After checking data, orange cells denote that the sub-total does not equal the sum of the elements.",null,null,null,"Demonstration","Demonstration","Demonstration","Demonstration","Demonstration","Demonstration",null,null,null,"tolerance",{"$f":"VLOOKUP(J2,V7:W13,2,FALSE)","v":1E-3}]
["BUDGETARY STAGE (see Section IV.2 of manual on reporting issues)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"decimals","tolerance"]
["FISCAL YEAR STARTING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1]
["1  ENERGY EFFICIENCY (sum of rows 11 to 19)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E8-(E9+E14+E31+E44+E51)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,1,0.1,null,null,null,"EFFICIENCY","GROUP 1: ENERGY EFFICIENCY"]
[null,"11 Industry                      ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E9-SUM(E10:E13)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,2,0.01,null,null,null,"11EFFIND","11 Industry"]
[null,null,"111 Industrial techniques and processes",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,3,1E-3,null,null,null,"111INDTE","111 Industrial techniques and processes"]
[null,null,"112 Industrial equipment and systems",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,4,1E-4,null,null,null,"112INDEQ","112 Industrial equipment and systems"]
[null,null,"113 Other industry",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,5,1.0000000000000001E-5,null,null,null,"113INDOT","113 Other industry"]
[null,null,"119 Unallocated industry",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,6,9.9999999999999995E-7,null,null,null,"119INDUN","119 Unallocated industry"]
[null,"12 Residential and commercial buildings, appliances and equipment",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E14-(E15+E19+E25+E30)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"12EFFRCO","12 Res. and comm. buildings, appliances and equipment"]
[null,null,"121 Building design and envelope",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E15-SUM(E16:E18)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"121BUDEE","121 Building design and envelope"]
[null,null,null,"1211 Building envelope technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1211ENVE","1211 Building envelope technologies"]
[null,null,null,"1212 Building design ",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1212DESI","1212 Building design"]
[null,null,null,"1219 Unallocated building design and envelope",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1219BUUN","1219 Unallocated building design and envelope"]
[null,null,"122 Building operations and efficient building equipment ",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E19-SUM(E20:E24)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"122OPERA","122 Building operation and efficient building equipment"]
[null,null,null,"1221 Building energy management systems (incl. smart meters) and efficient internet\n          and communication technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1221EMAN","1221 Building management systems and eff. ICT"]
[null,null,null,"1222 Lighting technologies and control systems",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1222LTEC","1222 Lighting technologies and control systems"]
[null,null,null,"1223 Heating, cooling and ventilation technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1223HEAT","1223 Heating, cooling and ventilation technologies"]
[null,null,null,"1224 Other building operations and efficient building equipment",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1224OTHE","1224 Other building ops. and eff. building equipment"]
[null,null,null,"1229 Unallocated building operations and efficient building equipment",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1229OPUN","1229 Unallocated building operations and equipment"]
[null,null,"123 Appliances and other residential/commercial ",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E25-SUM(E26:E29)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"123APPLI","123 Appliances and other res/comm"]
[null,null,null,"1231 Appliances ",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1231APPL","1231 Appliances"]
[null,null,null,"1232 Batteries for portable devices",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1232BATT","1232 Batteries for portable devices"]
[null,null,null,"1233 Other residential/commercial",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1233ORCO","1233 Other residential/commercial"]
[null,null,null,"1239 Unallocated appliances and other residential/commercial",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1239APUN","1239 Unallocated appliances and other res/comm"]
[null,null,"129 Unallocated residential and commercial buildings, appliances and equipment",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"129EFFRUN","129 Unalloc. res/comm bldings, appliances and equipment"]
[null,"13 Transport             ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E31-(E32+E41+E42+E43)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"13TRANSP","13 Transport"]
[null,null,"131 On-road vehicles",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E32-SUM(E33:E40)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"131ORVEH","131 On-road vehicles"]
[null,null,null,"1311 Vehicle batteries/storage technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1311VBAT","1311 Vehicle batteries/storage technologies"]
[null,null,null,"1312 Advanced power electronics, motors and EV/HEV/FCV systems",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1312ADVA","1312 Advd power elecs, motors, EV/HEV/FCV sys"]
[null,null,null,"1313 Advanced combustion engines",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1313ENGI","1313 Advanced combustion engines"]
[null,null,null,"1314 Electric vehicle infrastructure (incl. smart chargers and grid communications)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1314INFR","1314 Electric vehicle infrastructure"]
[null,null,null,"1315 Use of fuels for on-road vehicles (excl. hydrogen)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1315UFUE","1315 Fuel for on-road vehicles (excl. hydrogen)"]
[null,null,null,"1316 Materials for on-road vehicles",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1316MATE","1316 Materials for on-road vehicles"]
[null,null,null,"1317 Other on-road transport",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1317OTHE","1317 Other on-road transport"]
[null,null,null,"1319 Unallocated on-road vehicles",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1319ORUN","1319 Unallocated on-road vehicles"]
[null,null,"132 Off-road transport and transport systems",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"132OFFRO","132 Off-road transport and transport systems"]
[null,null,"133 Other transport",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"133OTRAN","133 Other transport"]
[null,null,"139 Unallocated transport",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"139TRANUN","139 Unallocated transport"]
[null,"14 Other energy efficiency",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E44-SUM(E45:E50)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"14OEFFIC","14 Other energy efficiency"]
[null,null,"141 Waste heat recovery and utilisation",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"141WASTE","141 Waste heat recovery and utilisation"]
[null,null,"142 Communities",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"142COMMU","142 Communities"]
[null,null,"143 Agriculture and forestry",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"143AGRIF","143 Agriculture and forestry"]
[null,null,"144 Heat pumps and chillers",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"144HEATP","144 Heat pumps and chillers"]
[null,null,"145 Other energy efficiency",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"145OENEF","145 Other energy efficiency"]
[null,null,"149 Unallocated other energy efficiency",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"149OEFUN","149 Unallocated other energy efficiency"]
[null,"19 Unallocated energy efficiency",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"19EFFUN","19 Unallocated energy efficiency"]
["2  FOSSIL FUELS: OIL, GAS and COAL (sum of rows 21 to 29)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E52-(E53+E61+E67+E72)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"FOSSILFUEL","GROUP 2: FOSSIL FUELS"]
[null,"21 Oil and gas",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E53-SUM(E54:E60)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"21OILGAS","21 Oil and gas"]
[null,null,"211 Enhanced oil and gas production",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"211ENHAN","211 Enhanced oil and gas production"]
[null,null,"212 Refining, transport and storage of oil and gas",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"212REFIN","212 Refining, transpt, storage of oil and gas"]
[null,null,"213 Non-conventional oil and gas production",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"213NONCO","213 Non-conventional oil and gas production"]
[null,null,"214 Oil and gas combustion              ",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"214COMBU","214 Oil and gas combustion"]
[null,null,"215 Oil and gas conversion",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"215CONVE","215 Oil and gas conversion"]
[null,null,"216 Other oil and gas",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"216OTOIL","216 Other oil and gas"]
[null,null,"219 Unallocated oil and gas",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"219OGUN","219 Unallocated oil and gas"]
[null,"22 Coal",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E61-SUM(E62:E66)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"22COAL","22 Coal"]
[null,null,"221 Coal production, preparation and transport",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"221CPROD","221 Coal production, preparation and transport"]
[null,null,"222 Coal combustion (incl. IGCC)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"222CCOMB","222 Coal combustion (incl. IGCC)"]
[null,null,"223 Coal conversion (excl. IGCC)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"223CCONV","223 Coal conversion (excl. IGCC)"]
[null,null,"224 Other coal",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"224OCOAL","224 Other coal"]
[null,null,"229 Unallocated coal",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"229COALUN","229 Unallocated coal"]
[null,"23 CO2 capture and storage",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E67-SUM(E68:E71)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"23CO2CS","23 CO2 capture and storage"]
[null,null,"231 CO2 capture/separation",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"231CAPSE","231 CO2 capture/separation"]
[null,null,"232 CO2 transport",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"232CTRAN","232 CO2 transport"]
[null,null,"233 CO2 storage",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"233CSTOR","233 CO2 storage"]
[null,null,"239 Unallocated CO2 capture and storage",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"239CO2CSUN","239 Unallocated CO2 capture and storage"]
[null,"29 Unallocated fossil fuels",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"29FOSFUN","29 Unallocated fossil fuels"]
["3  RENEWABLE ENERGY SOURCES (sum of rows 31 to 39)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E73-(E74+E79+E84+E90+E106+E112+E116+E117)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"RENEWABLE","GROUP 3: RENEWABLE ENERGY SOURCES"]
[null,"31 Solar energy",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E74-SUM(E75:E78)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"31SOLAR","31 Solar energy"]
[null,null,"311 Solar heating and cooling",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"311SHEAT","311 Solar heating and cooling"]
[null,null,"312 Solar photovoltaics",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"312PHOTOV","312 Photovoltaics"]
[null,null,"313 Solar thermal power and high-temp. applications",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"313THERMA","313 Solar thermal power and high-temp. applications"]
[null,null,"319 Unallocated solar energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"319SOLUN","319 Unallocated solar energy"]
[null,"32 Wind energy",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E79-SUM(E80:E83)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"32WIND","32 Wind energy"]
[null,null,"321 Onshore wind technologies",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"321WONSH","321 Onshore wind technologies"]
[null,null,"322 Offshore wind technologies (excl. low wind speed)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"322WOFFS","322 Offshore wind techs (excl. low wind speed)"]
[null,null,"323 Wind energy systems and other technologies",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"323WSYST","323 Wind energy systems and other technologies"]
[null,null,"329 Unallocated wind energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"329WINDUN","329 Unallocated wind energy"]
[null,"33 Ocean energy                          ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E84-SUM(E85:E89)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"33OCEAN","33 Ocean energy"]
[null,null,"331 Tidal energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"331TIDAL","331 Tidal energy"]
[null,null,"332 Wave energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"332WAVE","332 Wave energy"]
[null,null,"333 Salinity gradient power",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"333SALIN","333 Salinity gradient power"]
[null,null,"334 Other ocean energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"334OOTHE","334 Other ocean energy"]
[null,null,"339 Unallocated ocean energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"339OCEUN","339 Unallocated ocean energy"]
[null,"34 Biofuels (incl. liquid biofuels, solid biofuels and biogases)",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E90-(E91+E97+E98+E103+E104+E105)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"34BIOFUE","34 Biofuels (incl. liquids, solids and biogases)"]
[null,null,"341 Production of liquid biofuels",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E91-SUM(E92:E96)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"341LPROD","341 Production of liquid biofuels"]
[null,null,null,"3411 Gasoline substitutes (incl. ethanol)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3411GAS","3411 Gasoline substitutes (incl. ethanol)"]
[null,null,null,"3412 Diesel, kerosene and jet fuel substitutes",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3412DIES","3412 Diesel, kerosene and jet fuel substitutes"]
[null,null,null,"3413 Algal biofuels",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3413ALG","3413 Algal biofuels"]
[null,null,null,"3414 Other liquid fuel substitutes",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3414LOTH","3414 Other liquid fuel substitutes"]
[null,null,null,"3419 Unallocated production of liquid biofuels ",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3419LPUN","3419 Unallocated production of liquid biofuels"]
[null,null,"342 Production of solid biofuels",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"342SPROD","342 Production of solid biofuels"]
[null,null,"343 Production of biogases",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E98-SUM(E99:E102)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"343GPROD","343 Production of biogases"]
[null,null,null,"3431 Thermochemical",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3431GTHE","3431 Thermochemical"]
[null,null,null,"3432 Biochemical (incl. anaerobic digestion)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3432GBIO","3432 Biochemical (incl. anaerobic digestion)"]
[null,null,null,"3433 Other biogases",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3433GOTH","3433 Other biogases"]
[null,null,null,"3439 Unallocated production of biogases",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3439GPUN","3439 Unallocated production of biogases"]
[null,null,"344 Applications for heat and electricity",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"344BAPPL","344 Applications for heat and electricity"]
[null,null,"345 Other biofuels",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"345BOTHE","345 Other biofuels"]
[null,null,"349 Unallocated biofuels",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"349BIOUN","349 Unallocated biofuels"]
[null,"35 Geothermal energy",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E106-SUM(E107:E111)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"35GEOTHE","35 Geothermal energy"]
[null,null,"351 Geothermal energy from hydrothermal resources",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"351GEOHY","351 Hydrothermal resources"]
[null,null,"352 Geothermal energy from hot dry rock (HDR) resources",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"352GEHDR","352 Hot dry rock resources"]
[null,null,"353 Advanced drilling and exploration",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"353DRILL","353 Advanced drilling and exploration"]
[null,null,"354 Other geothermal energy (incl. low-temp. resources)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"354GOTHE","354 Other geothermal energy"]
[null,null,"359 Unallocated geothermal energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"359GEOUN","359 Unallocated geothermal energy"]
[null,"36 Hydroelectricity",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E112-SUM(E113:E115)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"36HYDROE","36 Hydroelectricity"]
[null,null,"361 Large hydroelectricity (capacity of 10 MW and above)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"361HLARG","361 Large hydroelectricity (10MW plus)"]
[null,null,"362 Small hydroelectricity (capacity less than 10 MW)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"362HSMAL","362 Small hydroelectricity (less than 10MW)"]
[null,null,"369 Unallocated hydroelectricity",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"369HYDRUN","369 Unallocated hydroelectricity"]
[null,"37 Other renewable energy sources",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"37OTHREN","37 Other renewable energy sources"]
[null,"39 Unallocated renewable energy sources",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"39RENUN","39 Unallocated renewable energy sources"]
["4  NUCLEAR FISSION and FUSION (sum of rows 41 and 49)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E118-(E119+E139+E144)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"NUCLEAR","GROUP 4: NUCLEAR"]
[null,"41 Nuclear fission",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E119-(E120+E121+E125+E130+E136+E137+E138)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"41FISSON","41 Nuclear fission"]
[null,null,"411 Light water reactors (LWRs)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"411LWRS","411 Light water reactors (LWRs)"]
[null,null,"412 Other converter reactors",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E121-SUM(E122:E124)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"412OTHNU","412 Other converter reactors"]
[null,null,null,"4121 Heavy water reactors (HWRs)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4121HWRS","4121 Heavy water reactors (HWRs)"]
[null,null,null,"4122 Other converter reactors",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4122OTHE","4122 Other converter reactors"]
[null,null,null,"4129 Unallocated other converter reactors",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4129OTNUN","4129 Unallocated other converter reactors"]
[null,null,"413 Fuel cycle",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E125-SUM(E126:E129)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"413FUCYC","413 Fuel cycle"]
[null,null,null,"4131 Fissile material recycling / reprocessing",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4131RECY","4131 Fissile material recycling/reprocessing"]
[null,null,null,"4132 Nuclear waste management",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4132WAST","4132 Nuclear waste management"]
[null,null,null,"4133 Other fuel cycle",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4133OTCY","4133 Other fuel cycle"]
[null,null,null,"4139 Unallocated fuel cycle",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4139FUCUN","4139 Unallocated fuel cycle"]
[null,null,"414 Nuclear supporting technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E130-SUM(E131:E135)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"414SUPTE","414 Nuclear supporting technologies"]
[null,null,null,"4141 Plant safety and integrity",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4141SAFE","4141 Plant safety and integrity"]
[null,null,null,"4142 Environmental protection ",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4142PROT","4142 Environmental protection"]
[null,null,null,"4143 Decommissioning",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4143DECO","4143 Decommissioning"]
[null,null,null,"4144 Other nuclear supporting technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4144ONUC","4144 Other nuclear supporting technologies"]
[null,null,null,"4149 Unallocated nuclear supporting technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4149ONUN","4149 Unallocated nuclear supporting technologies"]
[null,null,"415 Nuclear breeder",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"415BREED","415 Nuclear breeder"]
[null,null,"416 Other nuclear fission",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"416OFISS","416 Other nuclear fission"]
[null,null,"419 Unallocated nuclear fission",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"419FISUN","419 Unallocated nuclear fission"]
[null,"42 Nuclear fusion",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E139-SUM(E140:E143)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"42FUSION","42 Nuclear fusion"]
[null,null,"421 Magnetic confinement",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"421MACON","421 Magnetic confinement"]
[null,null,"422 Inertial confinement",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"422INCON","422 Inertial confinement"]
[null,null,"423 Other nuclear fusion",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"423OFUSI","423 Other nuclear fusion"]
[null,null,"429 Unallocated nuclear fusion",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"429FUSUN","429 Unallocated nuclear fusion"]
[null,"49 Unallocated nuclear fission and fusion",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"49NUCUN","49 Unallocated nuclear"]
["5  HYDROGEN and FUEL CELLS (sum of rows 51 and 59)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E145-(E146+E153+E158)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"HGENCELL","GROUP 5: HYDROGEN AND FUEL CELLS"]
[null,"51 Hydrogen",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E146-SUM(E147:E152)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"51HYDROG","51 Hydrogen"]
[null,null,"511 Hydrogen production",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"511HYPRO","511 Hydrogen production"]
[null,null,"512 Hydrogen  storage",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"512HYSTO","512 Hydrogen storage"]
[null,null,"513 Hydrogen transport and distribution",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"513HYTRA","513 Hydrogen transport and distribution"]
[null,null,"514 Other infrastructure and systems ",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"514HYINF","514 Other infrastructure and systems"]
[null,null,"515 Hydrogen end-uses (incl. combustion; excl. fuel cells and vehicles)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"515HYEND","515 Hydrogen end-uses"]
[null,null,"519 Unallocated hydrogen",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"519HYDUN","519 Unallocated hydrogen"]
[null,"52 Fuel cells",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E153-SUM(E154:E157)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"52FUELCE","52 Fuel cells"]
[null,null,"521 Stationary applications",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"521FUSTA","521 Stationary applications"]
[null,null,"522 Mobile applications",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"522FUMOB","522 Mobile applications"]
[null,null,"523 Other applications",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"523FUOTH","523 Other applications"]
[null,null,"529 Unallocated fuel cells",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"529FUELUN","529 Unallocated fuel cells"]
[null,"59 Unallocated hydrogen and fuel cells",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"59HYFUUN","59 Unallocated hydrogen and fuel cells"]
["6  OTHER POWER and STORAGE TECHNOLOGIES (sum of rows 61 to 69)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E159-(E160+E165+E177+E186)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"OTHERPANDS","GROUP 6: OTHER POWER AND STORAGE TECHNOLOGIES"]
[null,"61 Electric power generation    ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E160-SUM(E161:E164)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"61POWCON","61 Electric power conversion"]
[null,null,"611 Power generation technologies",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"611GETEC","611 Power generation technologies"]
[null,null,"612 Power generation supporting technologies",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"612GESUP","612 Power generation supporting technologies"]
[null,null,"613 Other electric power generation",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"613GEOTH","613 Other electricity power generation"]
[null,null,"619 Unallocated electric power generation",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"619POWUN","619 Unallocated electric power generation"]
[null,"62 Electricity transmission and distribution",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E165-(E166+E171+E176)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"62TRADIS","62 Electricity transmission and distribution"]
[null,null,"621 Transmission and distribution technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E166-SUM(E167:E170)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"621TDTEC","621 Transmission and distribution technologies"]
[null,null,null,"6211 Cables and conductors (superconducting, conventional, composite core)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6211CABL","6211 Cables and conductors"]
[null,null,null,"6212 AC/DC conversion",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6212ACDC","6212 AC/DC conversion"]
[null,null,null,"6213 Other transmission and distribution technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6213OTHE","6213 Other transmission and distribution techs."]
[null,null,null,"6219 Unallocated transmission and distribution technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6219TDTUN","6219 Unallocated transmission and distribution"]
[null,null,"622 Grid communication, control systems and integration",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E171-SUM(E172:E175)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"622GRIDC","622 Grid comm, control systems and integration"]
[null,null,null,"6221 Load management (incl. renewable integration)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6221LOAD","6221 Load management"]
[null,null,null,"6222 Control systems and monitoring",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6222CONT","6222 Control systems and monitoring"]
[null,null,null,"6223 Standards, interoperability and grid cyber security",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6223STAN","6223 Standards, interoper.+grid cyber security"]
[null,null,null,"6229 Unallocated grid communication, control systems and integration",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6229GRIDUN","6229 Unallocated grid comm,, control and integration"]
[null,null,"629 Unallocated electricity transmission and distribution",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"629TRANUN","Unallocated electricity transmission/distribution"]
[null,"63 Energy storage (non-transport applications)              ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E177-(E178+E184+E185)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"63ENSTOR","63 Energy storage"]
[null,null,"631 Electrical storage",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E178-SUM(E179:E183)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"631ELSTO","631 Electrical storage"]
[null,null,null,"6311 Batteries and other electrochemical storage (excl. vehicles and general \n         public portable devices)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6311BATT","6311 Batteries/other electrochemical storage"]
[null,null,null,"6312 Electromagnetic storage",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6312ELMA","6312 Electromagnetic storage"]
[null,null,null,"6313 Mechanical storage",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6313MECH","6313 Mechanical storage"]
[null,null,null,"6314 Other storage (excl. fuel cells)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6314OSTO","6314 Other storage (excl. fuel cells)"]
[null,null,null,"6319 Unallocated electrical storage",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6319ELSUN","6319 Unallocated electrical storage"]
[null,null,"632 Thermal energy storage",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"632THEST","632 Thermal energy storage"]
[null,null,"639 Unallocated energy storage ",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"639ENSTUN","639 Unallocated energy storage"]
[null,"69 Unallocated other power and storage technologies",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"69OPOWUN","69 Unallocated other power and storage techs."]
["7  OTHER CROSS-CUTTING TECHNOLOGIES or RESEARCH (sum of rows 71 to 73)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E187-SUM(E188:E190)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"OTHERTECH","GROUP 7: OTHER CROSS-CUTTING TECHS/RESEARCH"]
[null,"71 Energy system analysis",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"71SYSANA","71 Energy system analysis"]
[null,"72 Basic energy research that cannot be allocated to a specific category",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"72BASICUN","72 Basic energy research not allocated"]
[null,"73 Other",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"73OTHER","73 Other"]
["8  UNALLOCATED",null,null,null,0,0,0,0,0,0,null,null,null,"blue",null,null,null,null,null,null,null,null,null,null,null,null,"UNALLOC","GROUP 8: UNALLOCATED"]
["TOTAL BUDGET (sum of rows 1 to 8)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL","TOTAL BUDGET"]
["CHECK 1st LEVEL TOTALS",null,null,null,{"$f":"IF(ROUND(ABS(E192-SUM(E8+E52+E73+E118+E145+E159+E187+E191)),$J$2)>$O$5,ROUND(ABS(E192-SUM(E8+E52+E73+E118+E145+E159+E187+E191)),$J$2),0)","v":0},0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"###"]
["MEMO ITEMS:",null,null,null,null,null,null,null,null,null,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"###"]
[null,"Smart grids",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E195-SUM(E196:E201)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEMSMART","Memo: Smart grids"]
[null,null,"Part of 1221 (optional) Building energy management systems (incl. smart meters) and \n            efficient internet and communication technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E196<=E20","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1221","Memo: Part of 1221"]
[null,null,"1314 (optional) Electric vehicle infrastructure",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E197=E36","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1314A","Memo: Electric vehicle infrastructure"]
[null,null,"621 Transmission and distribution technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E198=E166","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM621","Memo: Transmission and distribution technologies"]
[null,null,"622 Grid communication, control systems and integration",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E199=E171","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM622","Memo: Grid communication etc"]
[null,null,"Part of 71 Energy system analysis that is part of the smart grid concept",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E200<=E188","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM71","Memo: Part of 71"]
[null,null,"Smart grid figures not identified in previous categories",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEMOTHSM","Memo: Smart grids not specified"]
[null,"Electric vehicles",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E202-SUM(E203:E206)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEMELVEH","Memo: Electric vehicles"]
[null,null,"Part of 1311 (optional) Vehicle batteries/storage technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E203<=E33","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1311A","Memo: Part of 1311"]
[null,null,"Part of 1312 (optional) Advanced power electronics, motors, and EV/HEV/FCV systems",null,0,0,0,0,0,0,null,null,null,"white",true,true,true,true,true,true,null,null,null,null,null,null,"MEM1312","Memo: Parts of 1312"]
[null,null,"1314 (optional) Electric vehicle infrastructure ",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E205=E36","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1314B","Memo: Electric vehicle infrastructure"]
[null,null,"Electric vehicle figures not identified in previous categories",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEMOTHEV","Memo: Electric Vehicles not specified"]
[null,"Energy storage",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E207-SUM(E208:E212)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEMENSTO","Memo: Energy Storage"]
[null,null,"1232 (optional) Batteries for portable devices",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E208=E27","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1232","Memo: Batteries for portable devices"]
[null,null,"1311 (optional) Vehicle batteries/storage technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E209=E33","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1311B","Memo: Vehicle batteries/storage technologies"]
[null,null,"512 Hydrogen storage",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E210=E148","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM512","Memo: Hydrogen storage"]
[null,null,"63 Energy storage (non-transport applications)",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E211=E177","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM63","Memo: Energy storage (non-transport apps)"]
[null,null,"Energy storage figures not identified in previous categories",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEMOTES","Memo: Energy storage not specified"]
[null,"Low-carbon heating and cooling of buildings (relevant component of)",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E213-SUM(E214:E216,E220:E227)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEMHEAT","Memo: Low-carbon heating and cooling of buildings"]
[null,null,"1211 Building envelope technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E214=E16","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1211","Memo: Building envelope technologies"]
[null,null,"1221 Building energy management systems (incl. smart meters) and efficient internet\n          and communication technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E215=E20","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1221B","Memo: Building energy management systems"]
[null,null,"1223 Heating, cooling and ventilation technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E216=E22","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1223","Memo: Heating, cooling and ventilation technologies"]
[null,null,null,"12231 Heating (optional)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEM12231","Memo: Heating (optional)"]
[null,null,null,"12232 Cooling (optional)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEM12232","Memo: Cooling (optional)"]
[null,null,null,"12233 Ventilation/other (optional)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEM12233","Memo: Ventilation (optional)"]
[null,null,"Part of 141 Waste heat recovery and utilisation",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E220<=E45","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM141","Memo: Waste heat recovery"]
[null,null,"Part of 142 Communities - District heating and cooling",null,0,0,0,0,0,0,null,null,null,"white",true,true,true,true,true,true,null,null,null,null,null,null,"MEM142","Memo: Communities - district heating and cooling"]
[null,null,"Part of 144 Heat pumps and chillers",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E222<=E48","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM144","Memo: Heat pumps and chillers"]
[null,null,"Part of 311 Solar heating and cooling",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E223<=E75","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM311","Memo: Solar heating and cooling"]
[null,null,"Part of 344 Biofuels - Applications for heat and electricity",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E224<=E103","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM344","Memo: Biofuels - Applications for heat and electricity"]
[null,null,"Part of 354 Other geothermal energy (incl. low-temp. resources)",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E225<=E110","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM354","Memo: Other geothermal energy"]
[null,null,"Part of 632 Thermal energy storage",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E226<=E632","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM632","Memo: Thermal energy storage"]
[null,null,"Low-carbon heating and cooling of buildings not identified in previous categories",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEMOTHEAT","Memo: Heat and cooling of buildings not specified"]

{"sheet":"STATE-OWNED R&D","index":5,"n_rows":227,"n_cols":28,"rows_kept":227,"cut":false,"hidden":false,"merged":[[214,2,214,3],[195,2,195,3],[4,0,4,3],[5,0,5,3],[6,0,6,3],[193,0,193,3]]}
["Funder: State-owned enterprises",null,null,null,"Data:  R&D budget (excluding demonstration)",null,null,null,null,"number of decimals",null,null,null,"CHECKS",null,null,null,null,null,null,null,null,null,null,null,null,"SHORTNAME"]
["Millions, national currency",null,null,null,null,{"$f":"configuration!C3","v":"Germany"},null,null,null,3,null,null,null,null,null,"TRUE means check is ok, FALSE will trigger the color change"]
[]
["Table 3",null,null,null,"2019","2020","2021","2022","2023Est","2024Est",null,null,null,null,{"$f":"E4","v":"2019"},"2020","2021","2022","2023Est","2024Est"]
["After checking data, orange cells denote that the sub-total does not equal the sum of the elements.",null,null,null,"R&D budget","R&D budget","R&D budget","R&D budget","R&D budget","R&D budget",null,null,null,"tolerance",{"$f":"VLOOKUP(J2,V7:W13,2,FALSE)","v":1E-3}]
["BUDGETARY STAGE (see Section IV.2 of manual on reporting issues)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"decimals","tolerance"]
["FISCAL YEAR STARTING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1]
["1  ENERGY EFFICIENCY (sum of rows 11 to 19)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E8-(E9+E14+E31+E44+E51)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,1,0.1,null,null,null,"EFFICIENCY","GROUP 1: ENERGY EFFICIENCY"]
[null,"11 Industry                      ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E9-SUM(E10:E13)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,2,0.01,null,null,null,"11EFFIND","11 Industry"]
[null,null,"111 Industrial techniques and processes",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,3,1E-3,null,null,null,"111INDTE","111 Industrial techniques and processes"]
[null,null,"112 Industrial equipment and systems",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,4,1E-4,null,null,null,"112INDEQ","112 Industrial equipment and systems"]
[null,null,"113 Other industry",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,5,1.0000000000000001E-5,null,null,null,"113INDOT","113 Other industry"]
[null,null,"119 Unallocated industry",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,6,9.9999999999999995E-7,null,null,null,"119INDUN","119 Unallocated industry"]
[null,"12 Residential and commercial buildings, appliances and equipment",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E14-(E15+E19+E25+E30)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"12EFFRCO","12 Res. and comm. buildings, appliances and equipment"]
[null,null,"121 Building design and envelope",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E15-SUM(E16:E18)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"121BUDEE","121 Building design and envelope"]
[null,null,null,"1211 Building envelope technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1211ENVE","1211 Building envelope technologies"]
[null,null,null,"1212 Building design ",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1212DESI","1212 Building design"]
[null,null,null,"1219 Unallocated building design and envelope",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1219BUUN","1219 Unallocated building design and envelope"]
[null,null,"122 Building operations and efficient building equipment ",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E19-SUM(E20:E24)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"122OPERA","122 Building operation and efficient building equipment"]
[null,null,null,"1221 Building energy management systems (incl. smart meters) and efficient internet\n          and communication technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1221EMAN","1221 Building management systems and eff. ICT"]
[null,null,null,"1222 Lighting technologies and control systems",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1222LTEC","1222 Lighting technologies and control systems"]
[null,null,null,"1223 Heating, cooling and ventilation technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1223HEAT","1223 Heating, cooling and ventilation technologies"]
[null,null,null,"1224 Other building operations and efficient building equipment",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1224OTHE","1224 Other building ops. and eff. building equipment"]
[null,null,null,"1229 Unallocated building operations and efficient building equipment",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1229OPUN","1229 Unallocated building operations and equipment"]
[null,null,"123 Appliances and other residential/commercial ",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E25-SUM(E26:E29)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"123APPLI","123 Appliances and other res/comm"]
[null,null,null,"1231 Appliances ",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1231APPL","1231 Appliances"]
[null,null,null,"1232 Batteries for portable devices",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1232BATT","1232 Batteries for portable devices"]
[null,null,null,"1233 Other residential/commercial",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1233ORCO","1233 Other residential/commercial"]
[null,null,null,"1239 Unallocated appliances and other residential/commercial",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1239APUN","1239 Unallocated appliances and other res/comm"]
[null,null,"129 Unallocated residential and commercial buildings, appliances and equipment",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"129EFFRUN","129 Unalloc. res/comm bldings, appliances and equipment"]
[null,"13 Transport             ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E31-(E32+E41+E42+E43)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"13TRANSP","13 Transport"]
[null,null,"131 On-road vehicles",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E32-SUM(E33:E40)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"131ORVEH","131 On-road vehicles"]
[null,null,null,"1311 Vehicle batteries/storage technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1311VBAT","1311 Vehicle batteries/storage technologies"]
[null,null,null,"1312 Advanced power electronics, motors and EV/HEV/FCV systems",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1312ADVA","1312 Advd power elecs, motors, EV/HEV/FCV sys"]
[null,null,null,"1313 Advanced combustion engines",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1313ENGI","1313 Advanced combustion engines"]
[null,null,null,"1314 Electric vehicle infrastructure (incl. smart chargers and grid communications)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1314INFR","1314 Electric vehicle infrastructure"]
[null,null,null,"1315 Use of fuels for on-road vehicles (excl. hydrogen)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1315UFUE","1315 Fuel for on-road vehicles (excl. hydrogen)"]
[null,null,null,"1316 Materials for on-road vehicles",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1316MATE","1316 Materials for on-road vehicles"]
[null,null,null,"1317 Other on-road transport",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1317OTHE","1317 Other on-road transport"]
[null,null,null,"1319 Unallocated on-road vehicles",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1319ORUN","1319 Unallocated on-road vehicles"]
[null,null,"132 Off-road transport and transport systems",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"132OFFRO","132 Off-road transport and transport systems"]
[null,null,"133 Other transport",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"133OTRAN","133 Other transport"]
[null,null,"139 Unallocated transport",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"139TRANUN","139 Unallocated transport"]
[null,"14 Other energy efficiency",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E44-SUM(E45:E50)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"14OEFFIC","14 Other energy efficiency"]
[null,null,"141 Waste heat recovery and utilisation",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"141WASTE","141 Waste heat recovery and utilisation"]
[null,null,"142 Communities",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"142COMMU","142 Communities"]
[null,null,"143 Agriculture and forestry",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"143AGRIF","143 Agriculture and forestry"]
[null,null,"144 Heat pumps and chillers",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"144HEATP","144 Heat pumps and chillers"]
[null,null,"145 Other energy efficiency",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"145OENEF","145 Other energy efficiency"]
[null,null,"149 Unallocated other energy efficiency",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"149OEFUN","149 Unallocated other energy efficiency"]
[null,"19 Unallocated energy efficiency",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"19EFFUN","19 Unallocated energy efficiency"]
["2  FOSSIL FUELS: OIL, GAS and COAL (sum of rows 21 to 29)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E52-(E53+E61+E67+E72)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"FOSSILFUEL","GROUP 2: FOSSIL FUELS"]
[null,"21 Oil and gas",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E53-SUM(E54:E60)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"21OILGAS","21 Oil and gas"]
[null,null,"211 Enhanced oil and gas production",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"211ENHAN","211 Enhanced oil and gas production"]
[null,null,"212 Refining, transport and storage of oil and gas",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"212REFIN","212 Refining, transpt, storage of oil and gas"]
[null,null,"213 Non-conventional oil and gas production",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"213NONCO","213 Non-conventional oil and gas production"]
[null,null,"214 Oil and gas combustion              ",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"214COMBU","214 Oil and gas combustion"]
[null,null,"215 Oil and gas conversion",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"215CONVE","215 Oil and gas conversion"]
[null,null,"216 Other oil and gas",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"216OTOIL","216 Other oil and gas"]
[null,null,"219 Unallocated oil and gas",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"219OGUN","219 Unallocated oil and gas"]
[null,"22 Coal",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E61-SUM(E62:E66)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"22COAL","22 Coal"]
[null,null,"221 Coal production, preparation and transport",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"221CPROD","221 Coal production, preparation and transport"]
[null,null,"222 Coal combustion (incl. IGCC)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"222CCOMB","222 Coal combustion (incl. IGCC)"]
[null,null,"223 Coal conversion (excl. IGCC)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"223CCONV","223 Coal conversion (excl. IGCC)"]
[null,null,"224 Other coal",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"224OCOAL","224 Other coal"]
[null,null,"229 Unallocated coal",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"229COALUN","229 Unallocated coal"]
[null,"23 CO2 capture and storage",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E67-SUM(E68:E71)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"23CO2CS","23 CO2 capture and storage"]
[null,null,"231 CO2 capture/separation",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"231CAPSE","231 CO2 capture/separation"]
[null,null,"232 CO2 transport",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"232CTRAN","232 CO2 transport"]
[null,null,"233 CO2 storage",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"233CSTOR","233 CO2 storage"]
[null,null,"239 Unallocated CO2 capture and storage",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"239CO2CSUN","239 Unallocated CO2 capture and storage"]
[null,"29 Unallocated fossil fuels",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"29FOSFUN","29 Unallocated fossil fuels"]
["3  RENEWABLE ENERGY SOURCES (sum of rows 31 to 39)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E73-(E74+E79+E84+E90+E106+E112+E116+E117)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"RENEWABLE","GROUP 3: RENEWABLE ENERGY SOURCES"]
[null,"31 Solar energy",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E74-SUM(E75:E78)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"31SOLAR","31 Solar energy"]
[null,null,"311 Solar heating and cooling",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"311SHEAT","311 Solar heating and cooling"]
[null,null,"312 Solar photovoltaics",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"312PHOTOV","312 Photovoltaics"]
[null,null,"313 Solar thermal power and high-temp. applications",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"313THERMA","313 Solar thermal power and high-temp. applications"]
[null,null,"319 Unallocated solar energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"319SOLUN","319 Unallocated solar energy"]
[null,"32 Wind energy",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E79-SUM(E80:E83)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"32WIND","32 Wind energy"]
[null,null,"321 Onshore wind technologies",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"321WONSH","321 Onshore wind technologies"]
[null,null,"322 Offshore wind technologies (excl. low wind speed)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"322WOFFS","322 Offshore wind techs (excl. low wind speed)"]
[null,null,"323 Wind energy systems and other technologies",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"323WSYST","323 Wind energy systems and other technologies"]
[null,null,"329 Unallocated wind energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"329WINDUN","329 Unallocated wind energy"]
[null,"33 Ocean energy                          ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E84-SUM(E85:E89)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"33OCEAN","33 Ocean energy"]
[null,null,"331 Tidal energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"331TIDAL","331 Tidal energy"]
[null,null,"332 Wave energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"332WAVE","332 Wave energy"]
[null,null,"333 Salinity gradient power",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"333SALIN","333 Salinity gradient power"]
[null,null,"334 Other ocean energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"334OOTHE","334 Other ocean energy"]
[null,null,"339 Unallocated ocean energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"339OCEUN","339 Unallocated ocean energy"]
[null,"34 Biofuels (incl. liquid biofuels, solid biofuels and biogases)",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E90-(E91+E97+E98+E103+E104+E105)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"34BIOFUE","34 Biofuels (incl. liquids, solids and biogases)"]
[null,null,"341 Production of liquid biofuels",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E91-SUM(E92:E96)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"341LPROD","341 Production of liquid biofuels"]
[null,null,null,"3411 Gasoline substitutes (incl. ethanol)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3411GAS","3411 Gasoline substitutes (incl. ethanol)"]
[null,null,null,"3412 Diesel, kerosene and jet fuel substitutes",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3412DIES","3412 Diesel, kerosene and jet fuel substitutes"]
[null,null,null,"3413 Algal biofuels",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3413ALG","3413 Algal biofuels"]
[null,null,null,"3414 Other liquid fuel substitutes",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3414LOTH","3414 Other liquid fuel substitutes"]
[null,null,null,"3419 Unallocated production of liquid biofuels ",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3419LPUN","3419 Unallocated production of liquid biofuels"]
[null,null,"342 Production of solid biofuels",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"342SPROD","342 Production of solid biofuels"]
[null,null,"343 Production of biogases",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E98-SUM(E99:E102)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"343GPROD","343 Production of biogases"]
[null,null,null,"3431 Thermochemical",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3431GTHE","3431 Thermochemical"]
[null,null,null,"3432 Biochemical (incl. anaerobic digestion)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3432GBIO","3432 Biochemical (incl. anaerobic digestion)"]
[null,null,null,"3433 Other biogases",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3433GOTH","3433 Other biogases"]
[null,null,null,"3439 Unallocated production of biogases",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3439GPUN","3439 Unallocated production of biogases"]
[null,null,"344 Applications for heat and electricity",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"344BAPPL","344 Applications for heat and electricity"]
[null,null,"345 Other biofuels",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"345BOTHE","345 Other biofuels"]
[null,null,"349 Unallocated biofuels",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"349BIOUN","349 Unallocated biofuels"]
[null,"35 Geothermal energy",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E106-SUM(E107:E111)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"35GEOTHE","35 Geothermal energy"]
[null,null,"351 Geothermal energy from hydrothermal resources",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"351GEOHY","351 Hydrothermal resources"]
[null,null,"352 Geothermal energy from hot dry rock (HDR) resources",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"352GEHDR","352 Hot dry rock resources"]
[null,null,"353 Advanced drilling and exploration",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"353DRILL","353 Advanced drilling and exploration"]
[null,null,"354 Other geothermal energy (incl. low-temp. resources)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"354GOTHE","354 Other geothermal energy"]
[null,null,"359 Unallocated geothermal energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"359GEOUN","359 Unallocated geothermal energy"]
[null,"36 Hydroelectricity",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E112-SUM(E113:E115)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"36HYDROE","36 Hydroelectricity"]
[null,null,"361 Large hydroelectricity (capacity of 10 MW and above)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"361HLARG","361 Large hydroelectricity (10MW plus)"]
[null,null,"362 Small hydroelectricity (capacity less than 10 MW)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"362HSMAL","362 Small hydroelectricity (less than 10MW)"]
[null,null,"369 Unallocated hydroelectricity",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"369HYDRUN","369 Unallocated hydroelectricity"]
[null,"37 Other renewable energy sources",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"37OTHREN","37 Other renewable energy sources"]
[null,"39 Unallocated renewable energy sources",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"39RENUN","39 Unallocated renewable energy sources"]
["4  NUCLEAR FISSION and FUSION (sum of rows 41 and 49)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E118-(E119+E139+E144)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"NUCLEAR","GROUP 4: NUCLEAR"]
[null,"41 Nuclear fission",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E119-(E120+E121+E125+E130+E136+E137+E138)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"41FISSON","41 Nuclear fission"]
[null,null,"411 Light water reactors (LWRs)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"411LWRS","411 Light water reactors (LWRs)"]
[null,null,"412 Other converter reactors",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E121-SUM(E122:E124)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"412OTHNU","412 Other converter reactors"]
[null,null,null,"4121 Heavy water reactors (HWRs)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4121HWRS","4121 Heavy water reactors (HWRs)"]
[null,null,null,"4122 Other converter reactors",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4122OTHE","4122 Other converter reactors"]
[null,null,null,"4129 Unallocated other converter reactors",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4129OTNUN","4129 Unallocated other converter reactors"]
[null,null,"413 Fuel cycle",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E125-SUM(E126:E129)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"413FUCYC","413 Fuel cycle"]
[null,null,null,"4131 Fissile material recycling / reprocessing",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4131RECY","4131 Fissile material recycling/reprocessing"]
[null,null,null,"4132 Nuclear waste management",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4132WAST","4132 Nuclear waste management"]
[null,null,null,"4133 Other fuel cycle",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4133OTCY","4133 Other fuel cycle"]
[null,null,null,"4139 Unallocated fuel cycle",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4139FUCUN","4139 Unallocated fuel cycle"]
[null,null,"414 Nuclear supporting technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E130-SUM(E131:E135)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"414SUPTE","414 Nuclear supporting technologies"]
[null,null,null,"4141 Plant safety and integrity",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4141SAFE","4141 Plant safety and integrity"]
[null,null,null,"4142 Environmental protection ",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4142PROT","4142 Environmental protection"]
[null,null,null,"4143 Decommissioning",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4143DECO","4143 Decommissioning"]
[null,null,null,"4144 Other nuclear supporting technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4144ONUC","4144 Other nuclear supporting technologies"]
[null,null,null,"4149 Unallocated nuclear supporting technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4149ONUN","4149 Unallocated nuclear supporting technologies"]
[null,null,"415 Nuclear breeder",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"415BREED","415 Nuclear breeder"]
[null,null,"416 Other nuclear fission",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"416OFISS","416 Other nuclear fission"]
[null,null,"419 Unallocated nuclear fission",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"419FISUN","419 Unallocated nuclear fission"]
[null,"42 Nuclear fusion",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E139-SUM(E140:E143)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"42FUSION","42 Nuclear fusion"]
[null,null,"421 Magnetic confinement",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"421MACON","421 Magnetic confinement"]
[null,null,"422 Inertial confinement",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"422INCON","422 Inertial confinement"]
[null,null,"423 Other nuclear fusion",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"423OFUSI","423 Other nuclear fusion"]
[null,null,"429 Unallocated nuclear fusion",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"429FUSUN","429 Unallocated nuclear fusion"]
[null,"49 Unallocated nuclear fission and fusion",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"49NUCUN","49 Unallocated nuclear"]
["5  HYDROGEN and FUEL CELLS (sum of rows 51 and 59)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E145-(E146+E153+E158)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"HGENCELL","GROUP 5: HYDROGEN AND FUEL CELLS"]
[null,"51 Hydrogen",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E146-SUM(E147:E152)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"51HYDROG","51 Hydrogen"]
[null,null,"511 Hydrogen production",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"511HYPRO","511 Hydrogen production"]
[null,null,"512 Hydrogen  storage",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"512HYSTO","512 Hydrogen storage"]
[null,null,"513 Hydrogen transport and distribution",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"513HYTRA","513 Hydrogen transport and distribution"]
[null,null,"514 Other infrastructure and systems ",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"514HYINF","514 Other infrastructure and systems"]
[null,null,"515 Hydrogen end-uses (incl. combustion; excl. fuel cells and vehicles)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"515HYEND","515 Hydrogen end-uses"]
[null,null,"519 Unallocated hydrogen",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"519HYDUN","519 Unallocated hydrogen"]
[null,"52 Fuel cells",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E153-SUM(E154:E157)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"52FUELCE","52 Fuel cells"]
[null,null,"521 Stationary applications",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"521FUSTA","521 Stationary applications"]
[null,null,"522 Mobile applications",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"522FUMOB","522 Mobile applications"]
[null,null,"523 Other applications",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"523FUOTH","523 Other applications"]
[null,null,"529 Unallocated fuel cells",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"529FUELUN","529 Unallocated fuel cells"]
[null,"59 Unallocated hydrogen and fuel cells",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"59HYFUUN","59 Unallocated hydrogen and fuel cells"]
["6  OTHER POWER and STORAGE TECHNOLOGIES (sum of rows 61 to 69)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E159-(E160+E165+E177+E186)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"OTHERPANDS","GROUP 6: OTHER POWER AND STORAGE TECHNOLOGIES"]
[null,"61 Electric power generation    ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E160-SUM(E161:E164)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"61POWCON","61 Electric power conversion"]
[null,null,"611 Power generation technologies",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"611GETEC","611 Power generation technologies"]
[null,null,"612 Power generation supporting technologies",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"612GESUP","612 Power generation supporting technologies"]
[null,null,"613 Other electric power generation",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"613GEOTH","613 Other electricity power generation"]
[null,null,"619 Unallocated electric power generation",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"619POWUN","619 Unallocated electric power generation"]
[null,"62 Electricity transmission and distribution",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E165-(E166+E171+E176)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"62TRADIS","62 Electricity transmission and distribution"]
[null,null,"621 Transmission and distribution technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E166-SUM(E167:E170)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"621TDTEC","621 Transmission and distribution technologies"]
[null,null,null,"6211 Cables and conductors (superconducting, conventional, composite core)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6211CABL","6211 Cables and conductors"]
[null,null,null,"6212 AC/DC conversion",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6212ACDC","6212 AC/DC conversion"]
[null,null,null,"6213 Other transmission and distribution technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6213OTHE","6213 Other transmission and distribution techs."]
[null,null,null,"6219 Unallocated transmission and distribution technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6219TDTUN","6219 Unallocated transmission and distribution"]
[null,null,"622 Grid communication, control systems and integration",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E171-SUM(E172:E175)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"622GRIDC","622 Grid comm, control systems and integration"]
[null,null,null,"6221 Load management (incl. renewable integration)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6221LOAD","6221 Load management"]
[null,null,null,"6222 Control systems and monitoring",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6222CONT","6222 Control systems and monitoring"]
[null,null,null,"6223 Standards, interoperability and grid cyber security",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6223STAN","6223 Standards, interoper.+grid cyber security"]
[null,null,null,"6229 Unallocated grid communication, control systems and integration",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6229GRIDUN","6229 Unallocated grid comm,, control and integration"]
[null,null,"629 Unallocated electricity transmission and distribution",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"629TRANUN","Unallocated electricity transmission/distribution"]
[null,"63 Energy storage (non-transport applications)              ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E177-(E178+E184+E185)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"63ENSTOR","63 Energy storage"]
[null,null,"631 Electrical storage",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E178-SUM(E179:E183)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"631ELSTO","631 Electrical storage"]
[null,null,null,"6311 Batteries and other electrochemical storage (excl. vehicles and general \n         public portable devices)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6311BATT","6311 Batteries/other electrochemical storage"]
[null,null,null,"6312 Electromagnetic storage",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6312ELMA","6312 Electromagnetic storage"]
[null,null,null,"6313 Mechanical storage",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6313MECH","6313 Mechanical storage"]
[null,null,null,"6314 Other storage (excl. fuel cells)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6314OSTO","6314 Other storage (excl. fuel cells)"]
[null,null,null,"6319 Unallocated electrical storage",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6319ELSUN","6319 Unallocated electrical storage"]
[null,null,"632 Thermal energy storage",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"632THEST","632 Thermal energy storage"]
[null,null,"639 Unallocated energy storage ",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"639ENSTUN","639 Unallocated energy storage"]
[null,"69 Unallocated other power and storage technologies",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"69OPOWUN","69 Unallocated other power and storage techs."]
["7  OTHER CROSS-CUTTING TECHNOLOGIES or RESEARCH (sum of rows 71 to 73)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E187-SUM(E188:E190)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"OTHERTECH","GROUP 7: OTHER CROSS-CUTTING TECHS/RESEARCH"]
[null,"71 Energy system analysis",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"71SYSANA","71 Energy system analysis"]
[null,"72 Basic energy research that cannot be allocated to a specific category",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"72BASICUN","72 Basic energy research not allocated"]
[null,"73 Other",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"73OTHER","73 Other"]
["8  UNALLOCATED",null,null,null,0,0,0,0,0,0,null,null,null,"blue",null,null,null,null,null,null,null,null,null,null,null,null,"UNALLOC","GROUP 8: UNALLOCATED"]
["TOTAL BUDGET (sum of rows 1 to 8)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL","TOTAL BUDGET"]
["CHECK 1st LEVEL TOTALS",null,null,null,{"$f":"IF(ROUND(ABS(E192-SUM(E8+E52+E73+E118+E145+E159+E187+E191)),$J$2)>$O$5,ROUND(ABS(E192-SUM(E8+E52+E73+E118+E145+E159+E187+E191)),$J$2),0)","v":0},0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"###"]
["MEMO ITEMS:",null,null,null,null,null,null,null,null,null,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"###"]
[null,"Smart grids",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E195-SUM(E196:E201)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEMSMART","Memo: Smart grids"]
[null,null,"Part of 1221 (optional) Building energy management systems (incl. smart meters) and \n            efficient internet and communication technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E196<=E20","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1221","Memo: Part of 1221"]
[null,null,"1314 (optional) Electric vehicle infrastructure",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E197=E36","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1314A","Memo: Electric vehicle infrastructure"]
[null,null,"621 Transmission and distribution technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E198=E166","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM621","Memo: Transmission and distribution technologies"]
[null,null,"622 Grid communication, control systems and integration",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E199=E171","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM622","Memo: Grid communication etc"]
[null,null,"Part of 71 Energy system analysis that is part of the smart grid concept",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E200<=E188","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM71","Memo: Part of 71"]
[null,null,"Smart grid figures not identified in previous categories",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEMOTHSM","Memo: Smart grids not specified"]
[null,"Electric vehicles",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E202-SUM(E203:E206)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEMELVEH","Memo: Electric vehicles"]
[null,null,"Part of 1311 (optional) Vehicle batteries/storage technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E203<=E33","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1311A","Memo: Part of 1311"]
[null,null,"Part of 1312 (optional) Advanced power electronics, motors, and EV/HEV/FCV systems",null,0,0,0,0,0,0,null,null,null,"white",true,true,true,true,true,true,null,null,null,null,null,null,"MEM1312","Memo: Parts of 1312"]
[null,null,"1314 (optional) Electric vehicle infrastructure ",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E205=E36","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1314B","Memo: Electric vehicle infrastructure"]
[null,null,"Electric vehicle figures not identified in previous categories",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEMOTHEV","Memo: Electric Vehicles not specified"]
[null,"Energy storage",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E207-SUM(E208:E212)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEMENSTO","Memo: Energy Storage"]
[null,null,"1232 (optional) Batteries for portable devices",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E208=E27","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1232","Memo: Batteries for portable devices"]
[null,null,"1311 (optional) Vehicle batteries/storage technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E209=E33","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1311B","Memo: Vehicle batteries/storage technologies"]
[null,null,"512 Hydrogen storage",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E210=E148","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM512","Memo: Hydrogen storage"]
[null,null,"63 Energy storage (non-transport applications)",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E211=E177","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM63","Memo: Energy storage (non-transport apps)"]
[null,null,"Energy storage figures not identified in previous categories",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEMOTES","Memo: Energy storage not specified"]
[null,"Low-carbon heating and cooling of buildings (relevant component of)",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E213-SUM(E214:E216,E220:E227)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEMHEAT","Memo: Low-carbon heating and cooling of buildings"]
[null,null,"1211 Building envelope technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E214=E16","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1211","Memo: Building envelope technologies"]
[null,null,"1221 Building energy management systems (incl. smart meters) and efficient internet\n          and communication technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E215=E20","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1221B","Memo: Building energy management systems"]
[null,null,"1223 Heating, cooling and ventilation technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E216=E22","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1223","Memo: Heating, cooling and ventilation technologies"]
[null,null,null,"12231 Heating (optional)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEM12231","Memo: Heating (optional)"]
[null,null,null,"12232 Cooling (optional)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEM12232","Memo: Cooling (optional)"]
[null,null,null,"12233 Ventilation/other (optional)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEM12233","Memo: Ventilation (optional)"]
[null,null,"Part of 141 Waste heat recovery and utilisation",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E220<=E45","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM141","Memo: Waste heat recovery"]
[null,null,"Part of 142 Communities - District heating and cooling",null,0,0,0,0,0,0,null,null,null,"white",true,true,true,true,true,true,null,null,null,null,null,null,"MEM142","Memo: Communities - district heating and cooling"]
[null,null,"Part of 144 Heat pumps and chillers",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E222<=E48","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM144","Memo: Heat pumps and chillers"]
[null,null,"Part of 311 Solar heating and cooling",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E223<=E75","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM311","Memo: Solar heating and cooling"]
[null,null,"Part of 344 Biofuels - Applications for heat and electricity",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E224<=E103","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM344","Memo: Biofuels - Applications for heat and electricity"]
[null,null,"Part of 354 Other geothermal energy (incl. low-temp. resources)",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E225<=E110","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM354","Memo: Other geothermal energy"]
[null,null,"Part of 632 Thermal energy storage",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E226<=E632","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM632","Memo: Thermal energy storage"]
[null,null,"Low-carbon heating and cooling of buildings not identified in previous categories",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEMOTHEAT","Memo: Heat and cooling of buildings not specified"]

{"sheet":"STATE-OWNED demonstration","index":6,"n_rows":227,"n_cols":28,"rows_kept":227,"cut":false,"hidden":false,"merged":[[214,2,214,3],[195,2,195,3],[4,0,4,3],[5,0,5,3],[6,0,6,3],[193,0,193,3]]}
["Funder: State-owned enterprises",null,null,null,"Data:  Demonstration",null,null,null,null,"number of decimals",null,null,null,"CHECKS",null,null,null,null,null,null,null,null,null,null,null,null,"SHORTNAME"]
["Millions, national currency",null,null,null,null,{"$f":"configuration!C3","v":"Germany"},null,null,null,3,null,null,null,null,null,"TRUE means check is ok, FALSE will trigger the color change"]
[]
["Table 4",null,null,null,"2019","2020","2021","2022","2023Est","2024Est",null,null,null,null,{"$f":"E4","v":"2019"},"2020","2021","2022","2023Est","2024Est"]
["After checking data, orange cells denote that the sub-total does not equal the sum of the elements.",null,null,null,"Demonstration","Demonstration","Demonstration","Demonstration","Demonstration","Demonstration",null,null,null,"tolerance",{"$f":"VLOOKUP(J2,V7:W13,2,FALSE)","v":1E-3}]
["BUDGETARY STAGE (see Section IV.2 of manual on reporting issues)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"decimals","tolerance"]
["FISCAL YEAR STARTING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1]
["1  ENERGY EFFICIENCY (sum of rows 11 to 19)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E8-(E9+E14+E31+E44+E51)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,1,0.1,null,null,null,"EFFICIENCY","GROUP 1: ENERGY EFFICIENCY"]
[null,"11 Industry                      ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E9-SUM(E10:E13)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,2,0.01,null,null,null,"11EFFIND","11 Industry"]
[null,null,"111 Industrial techniques and processes",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,3,1E-3,null,null,null,"111INDTE","111 Industrial techniques and processes"]
[null,null,"112 Industrial equipment and systems",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,4,1E-4,null,null,null,"112INDEQ","112 Industrial equipment and systems"]
[null,null,"113 Other industry",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,5,1.0000000000000001E-5,null,null,null,"113INDOT","113 Other industry"]
[null,null,"119 Unallocated industry",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,6,9.9999999999999995E-7,null,null,null,"119INDUN","119 Unallocated industry"]
[null,"12 Residential and commercial buildings, appliances and equipment",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E14-(E15+E19+E25+E30)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"12EFFRCO","12 Res. and comm. buildings, appliances and equipment"]
[null,null,"121 Building design and envelope",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E15-SUM(E16:E18)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"121BUDEE","121 Building design and envelope"]
[null,null,null,"1211 Building envelope technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1211ENVE","1211 Building envelope technologies"]
[null,null,null,"1212 Building design ",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1212DESI","1212 Building design"]
[null,null,null,"1219 Unallocated building design and envelope",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1219BUUN","1219 Unallocated building design and envelope"]
[null,null,"122 Building operations and efficient building equipment ",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E19-SUM(E20:E24)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"122OPERA","122 Building operation and efficient building equipment"]
[null,null,null,"1221 Building energy management systems (incl. smart meters) and efficient internet\n          and communication technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1221EMAN","1221 Building management systems and eff. ICT"]
[null,null,null,"1222 Lighting technologies and control systems",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1222LTEC","1222 Lighting technologies and control systems"]
[null,null,null,"1223 Heating, cooling and ventilation technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1223HEAT","1223 Heating, cooling and ventilation technologies"]
[null,null,null,"1224 Other building operations and efficient building equipment",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1224OTHE","1224 Other building ops. and eff. building equipment"]
[null,null,null,"1229 Unallocated building operations and efficient building equipment",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1229OPUN","1229 Unallocated building operations and equipment"]
[null,null,"123 Appliances and other residential/commercial ",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E25-SUM(E26:E29)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"123APPLI","123 Appliances and other res/comm"]
[null,null,null,"1231 Appliances ",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1231APPL","1231 Appliances"]
[null,null,null,"1232 Batteries for portable devices",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1232BATT","1232 Batteries for portable devices"]
[null,null,null,"1233 Other residential/commercial",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1233ORCO","1233 Other residential/commercial"]
[null,null,null,"1239 Unallocated appliances and other residential/commercial",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1239APUN","1239 Unallocated appliances and other res/comm"]
[null,null,"129 Unallocated residential and commercial buildings, appliances and equipment",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"129EFFRUN","129 Unalloc. res/comm bldings, appliances and equipment"]
[null,"13 Transport             ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E31-(E32+E41+E42+E43)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"13TRANSP","13 Transport"]
[null,null,"131 On-road vehicles",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E32-SUM(E33:E40)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"131ORVEH","131 On-road vehicles"]
[null,null,null,"1311 Vehicle batteries/storage technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1311VBAT","1311 Vehicle batteries/storage technologies"]
[null,null,null,"1312 Advanced power electronics, motors and EV/HEV/FCV systems",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1312ADVA","1312 Advd power elecs, motors, EV/HEV/FCV sys"]
[null,null,null,"1313 Advanced combustion engines",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1313ENGI","1313 Advanced combustion engines"]
[null,null,null,"1314 Electric vehicle infrastructure (incl. smart chargers and grid communications)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1314INFR","1314 Electric vehicle infrastructure"]
[null,null,null,"1315 Use of fuels for on-road vehicles (excl. hydrogen)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1315UFUE","1315 Fuel for on-road vehicles (excl. hydrogen)"]
[null,null,null,"1316 Materials for on-road vehicles",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1316MATE","1316 Materials for on-road vehicles"]
[null,null,null,"1317 Other on-road transport",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1317OTHE","1317 Other on-road transport"]
[null,null,null,"1319 Unallocated on-road vehicles",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1319ORUN","1319 Unallocated on-road vehicles"]
[null,null,"132 Off-road transport and transport systems",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"132OFFRO","132 Off-road transport and transport systems"]
[null,null,"133 Other transport",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"133OTRAN","133 Other transport"]
[null,null,"139 Unallocated transport",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"139TRANUN","139 Unallocated transport"]
[null,"14 Other energy efficiency",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E44-SUM(E45:E50)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"14OEFFIC","14 Other energy efficiency"]
[null,null,"141 Waste heat recovery and utilisation",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"141WASTE","141 Waste heat recovery and utilisation"]
[null,null,"142 Communities",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"142COMMU","142 Communities"]
[null,null,"143 Agriculture and forestry",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"143AGRIF","143 Agriculture and forestry"]
[null,null,"144 Heat pumps and chillers",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"144HEATP","144 Heat pumps and chillers"]
[null,null,"145 Other energy efficiency",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"145OENEF","145 Other energy efficiency"]
[null,null,"149 Unallocated other energy efficiency",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"149OEFUN","149 Unallocated other energy efficiency"]
[null,"19 Unallocated energy efficiency",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"19EFFUN","19 Unallocated energy efficiency"]
["2  FOSSIL FUELS: OIL, GAS and COAL (sum of rows 21 to 29)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E52-(E53+E61+E67+E72)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"FOSSILFUEL","GROUP 2: FOSSIL FUELS"]
[null,"21 Oil and gas",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E53-SUM(E54:E60)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"21OILGAS","21 Oil and gas"]
[null,null,"211 Enhanced oil and gas production",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"211ENHAN","211 Enhanced oil and gas production"]
[null,null,"212 Refining, transport and storage of oil and gas",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"212REFIN","212 Refining, transpt, storage of oil and gas"]
[null,null,"213 Non-conventional oil and gas production",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"213NONCO","213 Non-conventional oil and gas production"]
[null,null,"214 Oil and gas combustion              ",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"214COMBU","214 Oil and gas combustion"]
[null,null,"215 Oil and gas conversion",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"215CONVE","215 Oil and gas conversion"]
[null,null,"216 Other oil and gas",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"216OTOIL","216 Other oil and gas"]
[null,null,"219 Unallocated oil and gas",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"219OGUN","219 Unallocated oil and gas"]
[null,"22 Coal",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E61-SUM(E62:E66)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"22COAL","22 Coal"]
[null,null,"221 Coal production, preparation and transport",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"221CPROD","221 Coal production, preparation and transport"]
[null,null,"222 Coal combustion (incl. IGCC)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"222CCOMB","222 Coal combustion (incl. IGCC)"]
[null,null,"223 Coal conversion (excl. IGCC)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"223CCONV","223 Coal conversion (excl. IGCC)"]
[null,null,"224 Other coal",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"224OCOAL","224 Other coal"]
[null,null,"229 Unallocated coal",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"229COALUN","229 Unallocated coal"]
[null,"23 CO2 capture and storage",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E67-SUM(E68:E71)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"23CO2CS","23 CO2 capture and storage"]
[null,null,"231 CO2 capture/separation",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"231CAPSE","231 CO2 capture/separation"]
[null,null,"232 CO2 transport",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"232CTRAN","232 CO2 transport"]
[null,null,"233 CO2 storage",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"233CSTOR","233 CO2 storage"]
[null,null,"239 Unallocated CO2 capture and storage",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"239CO2CSUN","239 Unallocated CO2 capture and storage"]
[null,"29 Unallocated fossil fuels",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"29FOSFUN","29 Unallocated fossil fuels"]
["3  RENEWABLE ENERGY SOURCES (sum of rows 31 to 39)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E73-(E74+E79+E84+E90+E106+E112+E116+E117)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"RENEWABLE","GROUP 3: RENEWABLE ENERGY SOURCES"]
[null,"31 Solar energy",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E74-SUM(E75:E78)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"31SOLAR","31 Solar energy"]
[null,null,"311 Solar heating and cooling",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"311SHEAT","311 Solar heating and cooling"]
[null,null,"312 Solar photovoltaics",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"312PHOTOV","312 Photovoltaics"]
[null,null,"313 Solar thermal power and high-temp. applications",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"313THERMA","313 Solar thermal power and high-temp. applications"]
[null,null,"319 Unallocated solar energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"319SOLUN","319 Unallocated solar energy"]
[null,"32 Wind energy",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E79-SUM(E80:E83)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"32WIND","32 Wind energy"]
[null,null,"321 Onshore wind technologies",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"321WONSH","321 Onshore wind technologies"]
[null,null,"322 Offshore wind technologies (excl. low wind speed)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"322WOFFS","322 Offshore wind techs (excl. low wind speed)"]
[null,null,"323 Wind energy systems and other technologies",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"323WSYST","323 Wind energy systems and other technologies"]
[null,null,"329 Unallocated wind energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"329WINDUN","329 Unallocated wind energy"]
[null,"33 Ocean energy                          ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E84-SUM(E85:E89)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"33OCEAN","33 Ocean energy"]
[null,null,"331 Tidal energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"331TIDAL","331 Tidal energy"]
[null,null,"332 Wave energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"332WAVE","332 Wave energy"]
[null,null,"333 Salinity gradient power",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"333SALIN","333 Salinity gradient power"]
[null,null,"334 Other ocean energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"334OOTHE","334 Other ocean energy"]
[null,null,"339 Unallocated ocean energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"339OCEUN","339 Unallocated ocean energy"]
[null,"34 Biofuels (incl. liquid biofuels, solid biofuels and biogases)",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E90-(E91+E97+E98+E103+E104+E105)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"34BIOFUE","34 Biofuels (incl. liquids, solids and biogases)"]
[null,null,"341 Production of liquid biofuels",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E91-SUM(E92:E96)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"341LPROD","341 Production of liquid biofuels"]
[null,null,null,"3411 Gasoline substitutes (incl. ethanol)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3411GAS","3411 Gasoline substitutes (incl. ethanol)"]
[null,null,null,"3412 Diesel, kerosene and jet fuel substitutes",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3412DIES","3412 Diesel, kerosene and jet fuel substitutes"]
[null,null,null,"3413 Algal biofuels",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3413ALG","3413 Algal biofuels"]
[null,null,null,"3414 Other liquid fuel substitutes",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3414LOTH","3414 Other liquid fuel substitutes"]
[null,null,null,"3419 Unallocated production of liquid biofuels ",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3419LPUN","3419 Unallocated production of liquid biofuels"]
[null,null,"342 Production of solid biofuels",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"342SPROD","342 Production of solid biofuels"]
[null,null,"343 Production of biogases",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E98-SUM(E99:E102)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"343GPROD","343 Production of biogases"]
[null,null,null,"3431 Thermochemical",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3431GTHE","3431 Thermochemical"]
[null,null,null,"3432 Biochemical (incl. anaerobic digestion)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3432GBIO","3432 Biochemical (incl. anaerobic digestion)"]
[null,null,null,"3433 Other biogases",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3433GOTH","3433 Other biogases"]
[null,null,null,"3439 Unallocated production of biogases",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3439GPUN","3439 Unallocated production of biogases"]
[null,null,"344 Applications for heat and electricity",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"344BAPPL","344 Applications for heat and electricity"]
[null,null,"345 Other biofuels",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"345BOTHE","345 Other biofuels"]
[null,null,"349 Unallocated biofuels",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"349BIOUN","349 Unallocated biofuels"]
[null,"35 Geothermal energy",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E106-SUM(E107:E111)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"35GEOTHE","35 Geothermal energy"]
[null,null,"351 Geothermal energy from hydrothermal resources",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"351GEOHY","351 Hydrothermal resources"]
[null,null,"352 Geothermal energy from hot dry rock (HDR) resources",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"352GEHDR","352 Hot dry rock resources"]
[null,null,"353 Advanced drilling and exploration",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"353DRILL","353 Advanced drilling and exploration"]
[null,null,"354 Other geothermal energy (incl. low-temp. resources)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"354GOTHE","354 Other geothermal energy"]
[null,null,"359 Unallocated geothermal energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"359GEOUN","359 Unallocated geothermal energy"]
[null,"36 Hydroelectricity",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E112-SUM(E113:E115)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"36HYDROE","36 Hydroelectricity"]
[null,null,"361 Large hydroelectricity (capacity of 10 MW and above)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"361HLARG","361 Large hydroelectricity (10MW plus)"]
[null,null,"362 Small hydroelectricity (capacity less than 10 MW)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"362HSMAL","362 Small hydroelectricity (less than 10MW)"]
[null,null,"369 Unallocated hydroelectricity",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"369HYDRUN","369 Unallocated hydroelectricity"]
[null,"37 Other renewable energy sources",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"37OTHREN","37 Other renewable energy sources"]
[null,"39 Unallocated renewable energy sources",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"39RENUN","39 Unallocated renewable energy sources"]
["4  NUCLEAR FISSION and FUSION (sum of rows 41 and 49)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E118-(E119+E139+E144)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"NUCLEAR","GROUP 4: NUCLEAR"]
[null,"41 Nuclear fission",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E119-(E120+E121+E125+E130+E136+E137+E138)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"41FISSON","41 Nuclear fission"]
[null,null,"411 Light water reactors (LWRs)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"411LWRS","411 Light water reactors (LWRs)"]
[null,null,"412 Other converter reactors",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E121-SUM(E122:E124)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"412OTHNU","412 Other converter reactors"]
[null,null,null,"4121 Heavy water reactors (HWRs)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4121HWRS","4121 Heavy water reactors (HWRs)"]
[null,null,null,"4122 Other converter reactors",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4122OTHE","4122 Other converter reactors"]
[null,null,null,"4129 Unallocated other converter reactors",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4129OTNUN","4129 Unallocated other converter reactors"]
[null,null,"413 Fuel cycle",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E125-SUM(E126:E129)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"413FUCYC","413 Fuel cycle"]
[null,null,null,"4131 Fissile material recycling / reprocessing",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4131RECY","4131 Fissile material recycling/reprocessing"]
[null,null,null,"4132 Nuclear waste management",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4132WAST","4132 Nuclear waste management"]
[null,null,null,"4133 Other fuel cycle",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4133OTCY","4133 Other fuel cycle"]
[null,null,null,"4139 Unallocated fuel cycle",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4139FUCUN","4139 Unallocated fuel cycle"]
[null,null,"414 Nuclear supporting technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E130-SUM(E131:E135)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"414SUPTE","414 Nuclear supporting technologies"]
[null,null,null,"4141 Plant safety and integrity",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4141SAFE","4141 Plant safety and integrity"]
[null,null,null,"4142 Environmental protection ",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4142PROT","4142 Environmental protection"]
[null,null,null,"4143 Decommissioning",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4143DECO","4143 Decommissioning"]
[null,null,null,"4144 Other nuclear supporting technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4144ONUC","4144 Other nuclear supporting technologies"]
[null,null,null,"4149 Unallocated nuclear supporting technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4149ONUN","4149 Unallocated nuclear supporting technologies"]
[null,null,"415 Nuclear breeder",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"415BREED","415 Nuclear breeder"]
[null,null,"416 Other nuclear fission",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"416OFISS","416 Other nuclear fission"]
[null,null,"419 Unallocated nuclear fission",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"419FISUN","419 Unallocated nuclear fission"]
[null,"42 Nuclear fusion",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E139-SUM(E140:E143)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"42FUSION","42 Nuclear fusion"]
[null,null,"421 Magnetic confinement",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"421MACON","421 Magnetic confinement"]
[null,null,"422 Inertial confinement",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"422INCON","422 Inertial confinement"]
[null,null,"423 Other nuclear fusion",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"423OFUSI","423 Other nuclear fusion"]
[null,null,"429 Unallocated nuclear fusion",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"429FUSUN","429 Unallocated nuclear fusion"]
[null,"49 Unallocated nuclear fission and fusion",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"49NUCUN","49 Unallocated nuclear"]
["5  HYDROGEN and FUEL CELLS (sum of rows 51 and 59)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E145-(E146+E153+E158)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"HGENCELL","GROUP 5: HYDROGEN AND FUEL CELLS"]
[null,"51 Hydrogen",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E146-SUM(E147:E152)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"51HYDROG","51 Hydrogen"]
[null,null,"511 Hydrogen production",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"511HYPRO","511 Hydrogen production"]
[null,null,"512 Hydrogen  storage",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"512HYSTO","512 Hydrogen storage"]
[null,null,"513 Hydrogen transport and distribution",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"513HYTRA","513 Hydrogen transport and distribution"]
[null,null,"514 Other infrastructure and systems ",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"514HYINF","514 Other infrastructure and systems"]
[null,null,"515 Hydrogen end-uses (incl. combustion; excl. fuel cells and vehicles)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"515HYEND","515 Hydrogen end-uses"]
[null,null,"519 Unallocated hydrogen",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"519HYDUN","519 Unallocated hydrogen"]
[null,"52 Fuel cells",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E153-SUM(E154:E157)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"52FUELCE","52 Fuel cells"]
[null,null,"521 Stationary applications",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"521FUSTA","521 Stationary applications"]
[null,null,"522 Mobile applications",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"522FUMOB","522 Mobile applications"]
[null,null,"523 Other applications",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"523FUOTH","523 Other applications"]
[null,null,"529 Unallocated fuel cells",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"529FUELUN","529 Unallocated fuel cells"]
[null,"59 Unallocated hydrogen and fuel cells",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"59HYFUUN","59 Unallocated hydrogen and fuel cells"]
["6  OTHER POWER and STORAGE TECHNOLOGIES (sum of rows 61 to 69)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E159-(E160+E165+E177+E186)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"OTHERPANDS","GROUP 6: OTHER POWER AND STORAGE TECHNOLOGIES"]
[null,"61 Electric power generation    ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E160-SUM(E161:E164)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"61POWCON","61 Electric power conversion"]
[null,null,"611 Power generation technologies",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"611GETEC","611 Power generation technologies"]
[null,null,"612 Power generation supporting technologies",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"612GESUP","612 Power generation supporting technologies"]
[null,null,"613 Other electric power generation",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"613GEOTH","613 Other electricity power generation"]
[null,null,"619 Unallocated electric power generation",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"619POWUN","619 Unallocated electric power generation"]
[null,"62 Electricity transmission and distribution",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E165-(E166+E171+E176)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"62TRADIS","62 Electricity transmission and distribution"]
[null,null,"621 Transmission and distribution technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E166-SUM(E167:E170)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"621TDTEC","621 Transmission and distribution technologies"]
[null,null,null,"6211 Cables and conductors (superconducting, conventional, composite core)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6211CABL","6211 Cables and conductors"]
[null,null,null,"6212 AC/DC conversion",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6212ACDC","6212 AC/DC conversion"]
[null,null,null,"6213 Other transmission and distribution technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6213OTHE","6213 Other transmission and distribution techs."]
[null,null,null,"6219 Unallocated transmission and distribution technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6219TDTUN","6219 Unallocated transmission and distribution"]
[null,null,"622 Grid communication, control systems and integration",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E171-SUM(E172:E175)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"622GRIDC","622 Grid comm, control systems and integration"]
[null,null,null,"6221 Load management (incl. renewable integration)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6221LOAD","6221 Load management"]
[null,null,null,"6222 Control systems and monitoring",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6222CONT","6222 Control systems and monitoring"]
[null,null,null,"6223 Standards, interoperability and grid cyber security",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6223STAN","6223 Standards, interoper.+grid cyber security"]
[null,null,null,"6229 Unallocated grid communication, control systems and integration",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6229GRIDUN","6229 Unallocated grid comm,, control and integration"]
[null,null,"629 Unallocated electricity transmission and distribution",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"629TRANUN","Unallocated electricity transmission/distribution"]
[null,"63 Energy storage (non-transport applications)              ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E177-(E178+E184+E185)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"63ENSTOR","63 Energy storage"]
[null,null,"631 Electrical storage",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E178-SUM(E179:E183)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"631ELSTO","631 Electrical storage"]
[null,null,null,"6311 Batteries and other electrochemical storage (excl. vehicles and general \n         public portable devices)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6311BATT","6311 Batteries/other electrochemical storage"]
[null,null,null,"6312 Electromagnetic storage",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6312ELMA","6312 Electromagnetic storage"]
[null,null,null,"6313 Mechanical storage",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6313MECH","6313 Mechanical storage"]
[null,null,null,"6314 Other storage (excl. fuel cells)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6314OSTO","6314 Other storage (excl. fuel cells)"]
[null,null,null,"6319 Unallocated electrical storage",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6319ELSUN","6319 Unallocated electrical storage"]
[null,null,"632 Thermal energy storage",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"632THEST","632 Thermal energy storage"]
[null,null,"639 Unallocated energy storage ",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"639ENSTUN","639 Unallocated energy storage"]
[null,"69 Unallocated other power and storage technologies",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"69OPOWUN","69 Unallocated other power and storage techs."]
["7  OTHER CROSS-CUTTING TECHNOLOGIES or RESEARCH (sum of rows 71 to 73)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E187-SUM(E188:E190)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"OTHERTECH","GROUP 7: OTHER CROSS-CUTTING TECHS/RESEARCH"]
[null,"71 Energy system analysis",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"71SYSANA","71 Energy system analysis"]
[null,"72 Basic energy research that cannot be allocated to a specific category",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"72BASICUN","72 Basic energy research not allocated"]
[null,"73 Other",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"73OTHER","73 Other"]
["8  UNALLOCATED",null,null,null,0,0,0,0,0,0,null,null,null,"blue",null,null,null,null,null,null,null,null,null,null,null,null,"UNALLOC","GROUP 8: UNALLOCATED"]
["TOTAL BUDGET (sum of rows 1 to 8)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL","TOTAL BUDGET"]
["CHECK 1st LEVEL TOTALS",null,null,null,{"$f":"IF(ROUND(ABS(E192-SUM(E8+E52+E73+E118+E145+E159+E187+E191)),$J$2)>$O$5,ROUND(ABS(E192-SUM(E8+E52+E73+E118+E145+E159+E187+E191)),$J$2),0)","v":0},0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"###"]
["MEMO ITEMS:",null,null,null,null,null,null,null,null,null,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"###"]
[null,"Smart grids",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E195-SUM(E196:E201)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEMSMART","Memo: Smart grids"]
[null,null,"Part of 1221 (optional) Building energy management systems (incl. smart meters) and \n            efficient internet and communication technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E196<=E20","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1221","Memo: Part of 1221"]
[null,null,"1314 (optional) Electric vehicle infrastructure",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E197=E36","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1314A","Memo: Electric vehicle infrastructure"]
[null,null,"621 Transmission and distribution technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E198=E166","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM621","Memo: Transmission and distribution technologies"]
[null,null,"622 Grid communication, control systems and integration",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E199=E171","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM622","Memo: Grid communication etc"]
[null,null,"Part of 71 Energy system analysis that is part of the smart grid concept",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E200<=E188","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM71","Memo: Part of 71"]
[null,null,"Smart grid figures not identified in previous categories",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEMOTHSM","Memo: Smart grids not specified"]
[null,"Electric vehicles",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E202-SUM(E203:E206)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEMELVEH","Memo: Electric vehicles"]
[null,null,"Part of 1311 (optional) Vehicle batteries/storage technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E203<=E33","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1311A","Memo: Part of 1311"]
[null,null,"Part of 1312 (optional) Advanced power electronics, motors, and EV/HEV/FCV systems",null,0,0,0,0,0,0,null,null,null,"white",true,true,true,true,true,true,null,null,null,null,null,null,"MEM1312","Memo: Parts of 1312"]
[null,null,"1314 (optional) Electric vehicle infrastructure ",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E205=E36","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1314B","Memo: Electric vehicle infrastructure"]
[null,null,"Electric vehicle figures not identified in previous categories",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEMOTHEV","Memo: Electric Vehicles not specified"]
[null,"Energy storage",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E207-SUM(E208:E212)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEMENSTO","Memo: Energy Storage"]
[null,null,"1232 (optional) Batteries for portable devices",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E208=E27","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1232","Memo: Batteries for portable devices"]
[null,null,"1311 (optional) Vehicle batteries/storage technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E209=E33","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1311B","Memo: Vehicle batteries/storage technologies"]
[null,null,"512 Hydrogen storage",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E210=E148","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM512","Memo: Hydrogen storage"]
[null,null,"63 Energy storage (non-transport applications)",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E211=E177","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM63","Memo: Energy storage (non-transport apps)"]
[null,null,"Energy storage figures not identified in previous categories",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEMOTES","Memo: Energy storage not specified"]
[null,"Low-carbon heating and cooling of buildings (relevant component of)",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E213-SUM(E214:E216,E220:E227)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEMHEAT","Memo: Low-carbon heating and cooling of buildings"]
[null,null,"1211 Building envelope technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E214=E16","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1211","Memo: Building envelope technologies"]
[null,null,"1221 Building energy management systems (incl. smart meters) and efficient internet\n          and communication technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E215=E20","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1221B","Memo: Building energy management systems"]
[null,null,"1223 Heating, cooling and ventilation technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E216=E22","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1223","Memo: Heating, cooling and ventilation technologies"]
[null,null,null,"12231 Heating (optional)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEM12231","Memo: Heating (optional)"]
[null,null,null,"12232 Cooling (optional)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEM12232","Memo: Cooling (optional)"]
[null,null,null,"12233 Ventilation/other (optional)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEM12233","Memo: Ventilation (optional)"]
[null,null,"Part of 141 Waste heat recovery and utilisation",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E220<=E45","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM141","Memo: Waste heat recovery"]
[null,null,"Part of 142 Communities - District heating and cooling",null,0,0,0,0,0,0,null,null,null,"white",true,true,true,true,true,true,null,null,null,null,null,null,"MEM142","Memo: Communities - district heating and cooling"]
[null,null,"Part of 144 Heat pumps and chillers",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E222<=E48","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM144","Memo: Heat pumps and chillers"]
[null,null,"Part of 311 Solar heating and cooling",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E223<=E75","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM311","Memo: Solar heating and cooling"]
[null,null,"Part of 344 Biofuels - Applications for heat and electricity",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E224<=E103","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM344","Memo: Biofuels - Applications for heat and electricity"]
[null,null,"Part of 354 Other geothermal energy (incl. low-temp. resources)",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E225<=E110","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM354","Memo: Other geothermal energy"]
[null,null,"Part of 632 Thermal energy storage",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E226<=E632","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM632","Memo: Thermal energy storage"]
[null,null,"Low-carbon heating and cooling of buildings not identified in previous categories",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEMOTHEAT","Memo: Heat and cooling of buildings not specified"]

{"sheet":"PRIVATE-SECTOR","index":7,"n_rows":227,"n_cols":28,"rows_kept":227,"cut":false,"hidden":false,"merged":[[214,2,214,3],[4,0,4,3],[6,0,6,3],[193,0,193,3],[195,2,195,3]]}
["Funder: Private sector and private enterprises",null,null,null,"Data:  R&D + Demonstration",null,null,null,null,"number of decimals",null,null,null,"CHECKS",null,null,null,null,null,null,null,null,null,null,null,null,"SHORTNAME"]
["Millions, national currency",null,null,null,null,{"$f":"configuration!C3","v":"Germany"},null,null,null,3,null,null,null,null,null,"TRUE means check is ok, FALSE will trigger the color change"]
[]
["Table 5",null,null,null,"2019","2020","2021","2022","2023Est","2024Est",null,null,null,null,{"$f":"E4","v":"2019"},"2020","2021","2022","2023Est","2024Est"]
["After checking data, orange cells denote that the sub-total does not equal the sum of the elements.",null,null,null,"R&D + Demonstration","R&D + Demonstration","R&D + Demonstration","R&D + Demonstration","R&D + Demonstration","R&D + Demonstration",null,null,null,"tolerance",{"$f":"VLOOKUP(J2,V7:W13,2,FALSE)","v":1E-3}]
[]
["FISCAL YEAR STARTING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1]
["1  ENERGY EFFICIENCY (sum of rows 11 to 19)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E8-(E9+E14+E31+E44+E51)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,1,0.1,null,null,null,"EFFICIENCY","GROUP 1: ENERGY EFFICIENCY"]
[null,"11 Industry                      ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E9-SUM(E10:E13)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,2,0.01,null,null,null,"11EFFIND","11 Industry"]
[null,null,"111 Industrial techniques and processes",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,3,1E-3,null,null,null,"111INDTE","111 Industrial techniques and processes"]
[null,null,"112 Industrial equipment and systems",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,4,1E-4,null,null,null,"112INDEQ","112 Industrial equipment and systems"]
[null,null,"113 Other industry",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,5,1.0000000000000001E-5,null,null,null,"113INDOT","113 Other industry"]
[null,null,"119 Unallocated industry",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,6,9.9999999999999995E-7,null,null,null,"119INDUN","119 Unallocated industry"]
[null,"12 Residential and commercial buildings, appliances and equipment",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E14-(E15+E19+E25+E30)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"12EFFRCO","12 Res. and comm. buildings, appliances and equipment"]
[null,null,"121 Building design and envelope",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E15-SUM(E16:E18)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"121BUDEE","121 Building design and envelope"]
[null,null,null,"1211 Building envelope technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1211ENVE","1211 Building envelope technologies"]
[null,null,null,"1212 Building design ",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1212DESI","1212 Building design"]
[null,null,null,"1219 Unallocated building design and envelope",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1219BUUN","1219 Unallocated building design and envelope"]
[null,null,"122 Building operations and efficient building equipment ",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E19-SUM(E20:E24)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"122OPERA","122 Building operation and efficient building equipment"]
[null,null,null,"1221 Building energy management systems (incl. smart meters) and efficient internet\n          and communication technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1221EMAN","1221 Building management systems and eff. ICT"]
[null,null,null,"1222 Lighting technologies and control systems",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1222LTEC","1222 Lighting technologies and control systems"]
[null,null,null,"1223 Heating, cooling and ventilation technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1223HEAT","1223 Heating, cooling and ventilation technologies"]
[null,null,null,"1224 Other building operations and efficient building equipment",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1224OTHE","1224 Other building ops. and eff. building equipment"]
[null,null,null,"1229 Unallocated building operations and efficient building equipment",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1229OPUN","1229 Unallocated building operations and equipment"]
[null,null,"123 Appliances and other residential/commercial ",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E25-SUM(E26:E29)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"123APPLI","123 Appliances and other res/comm"]
[null,null,null,"1231 Appliances ",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1231APPL","1231 Appliances"]
[null,null,null,"1232 Batteries for portable devices",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1232BATT","1232 Batteries for portable devices"]
[null,null,null,"1233 Other residential/commercial",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1233ORCO","1233 Other residential/commercial"]
[null,null,null,"1239 Unallocated appliances and other residential/commercial",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1239APUN","1239 Unallocated appliances and other res/comm"]
[null,null,"129 Unallocated residential and commercial buildings, appliances and equipment",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"129EFFRUN","129 Unalloc. res/comm bldings, appliances and equipment"]
[null,"13 Transport             ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E31-(E32+E41+E42+E43)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"13TRANSP","13 Transport"]
[null,null,"131 On-road vehicles",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E32-SUM(E33:E40)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"131ORVEH","131 On-road vehicles"]
[null,null,null,"1311 Vehicle batteries/storage technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1311VBAT","1311 Vehicle batteries/storage technologies"]
[null,null,null,"1312 Advanced power electronics, motors and EV/HEV/FCV systems",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1312ADVA","1312 Advd power elecs, motors, EV/HEV/FCV sys"]
[null,null,null,"1313 Advanced combustion engines",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1313ENGI","1313 Advanced combustion engines"]
[null,null,null,"1314 Electric vehicle infrastructure (incl. smart chargers and grid communications)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1314INFR","1314 Electric vehicle infrastructure"]
[null,null,null,"1315 Use of fuels for on-road vehicles (excl. hydrogen)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1315UFUE","1315 Fuel for on-road vehicles (excl. hydrogen)"]
[null,null,null,"1316 Materials for on-road vehicles",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1316MATE","1316 Materials for on-road vehicles"]
[null,null,null,"1317 Other on-road transport",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1317OTHE","1317 Other on-road transport"]
[null,null,null,"1319 Unallocated on-road vehicles",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"1319ORUN","1319 Unallocated on-road vehicles"]
[null,null,"132 Off-road transport and transport systems",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"132OFFRO","132 Off-road transport and transport systems"]
[null,null,"133 Other transport",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"133OTRAN","133 Other transport"]
[null,null,"139 Unallocated transport",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"139TRANUN","139 Unallocated transport"]
[null,"14 Other energy efficiency",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E44-SUM(E45:E50)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"14OEFFIC","14 Other energy efficiency"]
[null,null,"141 Waste heat recovery and utilisation",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"141WASTE","141 Waste heat recovery and utilisation"]
[null,null,"142 Communities",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"142COMMU","142 Communities"]
[null,null,"143 Agriculture and forestry",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"143AGRIF","143 Agriculture and forestry"]
[null,null,"144 Heat pumps and chillers",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"144HEATP","144 Heat pumps and chillers"]
[null,null,"145 Other energy efficiency",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"145OENEF","145 Other energy efficiency"]
[null,null,"149 Unallocated other energy efficiency",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"149OEFUN","149 Unallocated other energy efficiency"]
[null,"19 Unallocated energy efficiency",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"19EFFUN","19 Unallocated energy efficiency"]
["2  FOSSIL FUELS: OIL, GAS and COAL (sum of rows 21 to 29)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E52-(E53+E61+E67+E72)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"FOSSILFUEL","GROUP 2: FOSSIL FUELS"]
[null,"21 Oil and gas",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E53-SUM(E54:E60)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"21OILGAS","21 Oil and gas"]
[null,null,"211 Enhanced oil and gas production",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"211ENHAN","211 Enhanced oil and gas production"]
[null,null,"212 Refining, transport and storage of oil and gas",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"212REFIN","212 Refining, transpt, storage of oil and gas"]
[null,null,"213 Non-conventional oil and gas production",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"213NONCO","213 Non-conventional oil and gas production"]
[null,null,"214 Oil and gas combustion              ",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"214COMBU","214 Oil and gas combustion"]
[null,null,"215 Oil and gas conversion",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"215CONVE","215 Oil and gas conversion"]
[null,null,"216 Other oil and gas",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"216OTOIL","216 Other oil and gas"]
[null,null,"219 Unallocated oil and gas",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"219OGUN","219 Unallocated oil and gas"]
[null,"22 Coal",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E61-SUM(E62:E66)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"22COAL","22 Coal"]
[null,null,"221 Coal production, preparation and transport",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"221CPROD","221 Coal production, preparation and transport"]
[null,null,"222 Coal combustion (incl. IGCC)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"222CCOMB","222 Coal combustion (incl. IGCC)"]
[null,null,"223 Coal conversion (excl. IGCC)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"223CCONV","223 Coal conversion (excl. IGCC)"]
[null,null,"224 Other coal",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"224OCOAL","224 Other coal"]
[null,null,"229 Unallocated coal",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"229COALUN","229 Unallocated coal"]
[null,"23 CO2 capture and storage",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E67-SUM(E68:E71)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"23CO2CS","23 CO2 capture and storage"]
[null,null,"231 CO2 capture/separation",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"231CAPSE","231 CO2 capture/separation"]
[null,null,"232 CO2 transport",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"232CTRAN","232 CO2 transport"]
[null,null,"233 CO2 storage",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"233CSTOR","233 CO2 storage"]
[null,null,"239 Unallocated CO2 capture and storage",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"239CO2CSUN","239 Unallocated CO2 capture and storage"]
[null,"29 Unallocated fossil fuels",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"29FOSFUN","29 Unallocated fossil fuels"]
["3  RENEWABLE ENERGY SOURCES (sum of rows 31 to 39)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E73-(E74+E79+E84+E90+E106+E112+E116+E117)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"RENEWABLE","GROUP 3: RENEWABLE ENERGY SOURCES"]
[null,"31 Solar energy",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E74-SUM(E75:E78)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"31SOLAR","31 Solar energy"]
[null,null,"311 Solar heating and cooling",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"311SHEAT","311 Solar heating and cooling"]
[null,null,"312 Solar photovoltaics",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"312PHOTOV","312 Photovoltaics"]
[null,null,"313 Solar thermal power and high-temp. applications",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"313THERMA","313 Solar thermal power and high-temp. applications"]
[null,null,"319 Unallocated solar energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"319SOLUN","319 Unallocated solar energy"]
[null,"32 Wind energy",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E79-SUM(E80:E83)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"32WIND","32 Wind energy"]
[null,null,"321 Onshore wind technologies",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"321WONSH","321 Onshore wind technologies"]
[null,null,"322 Offshore wind technologies (excl. low wind speed)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"322WOFFS","322 Offshore wind techs (excl. low wind speed)"]
[null,null,"323 Wind energy systems and other technologies",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"323WSYST","323 Wind energy systems and other technologies"]
[null,null,"329 Unallocated wind energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"329WINDUN","329 Unallocated wind energy"]
[null,"33 Ocean energy                          ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E84-SUM(E85:E89)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"33OCEAN","33 Ocean energy"]
[null,null,"331 Tidal energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"331TIDAL","331 Tidal energy"]
[null,null,"332 Wave energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"332WAVE","332 Wave energy"]
[null,null,"333 Salinity gradient power",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"333SALIN","333 Salinity gradient power"]
[null,null,"334 Other ocean energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"334OOTHE","334 Other ocean energy"]
[null,null,"339 Unallocated ocean energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"339OCEUN","339 Unallocated ocean energy"]
[null,"34 Biofuels (incl. liquid biofuels, solid biofuels and biogases)",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E90-(E91+E97+E98+E103+E104+E105)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"34BIOFUE","34 Biofuels (incl. liquids, solids and biogases)"]
[null,null,"341 Production of liquid biofuels",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E91-SUM(E92:E96)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"341LPROD","341 Production of liquid biofuels"]
[null,null,null,"3411 Gasoline substitutes (incl. ethanol)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3411GAS","3411 Gasoline substitutes (incl. ethanol)"]
[null,null,null,"3412 Diesel, kerosene and jet fuel substitutes",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3412DIES","3412 Diesel, kerosene and jet fuel substitutes"]
[null,null,null,"3413 Algal biofuels",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3413ALG","3413 Algal biofuels"]
[null,null,null,"3414 Other liquid fuel substitutes",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3414LOTH","3414 Other liquid fuel substitutes"]
[null,null,null,"3419 Unallocated production of liquid biofuels ",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3419LPUN","3419 Unallocated production of liquid biofuels"]
[null,null,"342 Production of solid biofuels",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"342SPROD","342 Production of solid biofuels"]
[null,null,"343 Production of biogases",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E98-SUM(E99:E102)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"343GPROD","343 Production of biogases"]
[null,null,null,"3431 Thermochemical",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3431GTHE","3431 Thermochemical"]
[null,null,null,"3432 Biochemical (incl. anaerobic digestion)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3432GBIO","3432 Biochemical (incl. anaerobic digestion)"]
[null,null,null,"3433 Other biogases",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3433GOTH","3433 Other biogases"]
[null,null,null,"3439 Unallocated production of biogases",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"3439GPUN","3439 Unallocated production of biogases"]
[null,null,"344 Applications for heat and electricity",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"344BAPPL","344 Applications for heat and electricity"]
[null,null,"345 Other biofuels",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"345BOTHE","345 Other biofuels"]
[null,null,"349 Unallocated biofuels",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"349BIOUN","349 Unallocated biofuels"]
[null,"35 Geothermal energy",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E106-SUM(E107:E111)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"35GEOTHE","35 Geothermal energy"]
[null,null,"351 Geothermal energy from hydrothermal resources",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"351GEOHY","351 Hydrothermal resources"]
[null,null,"352 Geothermal energy from hot dry rock (HDR) resources",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"352GEHDR","352 Hot dry rock resources"]
[null,null,"353 Advanced drilling and exploration",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"353DRILL","353 Advanced drilling and exploration"]
[null,null,"354 Other geothermal energy (incl. low-temp. resources)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"354GOTHE","354 Other geothermal energy"]
[null,null,"359 Unallocated geothermal energy",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"359GEOUN","359 Unallocated geothermal energy"]
[null,"36 Hydroelectricity",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E112-SUM(E113:E115)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"36HYDROE","36 Hydroelectricity"]
[null,null,"361 Large hydroelectricity (capacity of 10 MW and above)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"361HLARG","361 Large hydroelectricity (10MW plus)"]
[null,null,"362 Small hydroelectricity (capacity less than 10 MW)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"362HSMAL","362 Small hydroelectricity (less than 10MW)"]
[null,null,"369 Unallocated hydroelectricity",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"369HYDRUN","369 Unallocated hydroelectricity"]
[null,"37 Other renewable energy sources",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"37OTHREN","37 Other renewable energy sources"]
[null,"39 Unallocated renewable energy sources",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"39RENUN","39 Unallocated renewable energy sources"]
["4  NUCLEAR FISSION and FUSION (sum of rows 41 and 49)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E118-(E119+E139+E144)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"NUCLEAR","GROUP 4: NUCLEAR"]
[null,"41 Nuclear fission",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E119-(E120+E121+E125+E130+E136+E137+E138)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"41FISSON","41 Nuclear fission"]
[null,null,"411 Light water reactors (LWRs)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"411LWRS","411 Light water reactors (LWRs)"]
[null,null,"412 Other converter reactors",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E121-SUM(E122:E124)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"412OTHNU","412 Other converter reactors"]
[null,null,null,"4121 Heavy water reactors (HWRs)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4121HWRS","4121 Heavy water reactors (HWRs)"]
[null,null,null,"4122 Other converter reactors",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4122OTHE","4122 Other converter reactors"]
[null,null,null,"4129 Unallocated other converter reactors",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4129OTNUN","4129 Unallocated other converter reactors"]
[null,null,"413 Fuel cycle",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E125-SUM(E126:E129)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"413FUCYC","413 Fuel cycle"]
[null,null,null,"4131 Fissile material recycling / reprocessing",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4131RECY","4131 Fissile material recycling/reprocessing"]
[null,null,null,"4132 Nuclear waste management",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4132WAST","4132 Nuclear waste management"]
[null,null,null,"4133 Other fuel cycle",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4133OTCY","4133 Other fuel cycle"]
[null,null,null,"4139 Unallocated fuel cycle",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4139FUCUN","4139 Unallocated fuel cycle"]
[null,null,"414 Nuclear supporting technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E130-SUM(E131:E135)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"414SUPTE","414 Nuclear supporting technologies"]
[null,null,null,"4141 Plant safety and integrity",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4141SAFE","4141 Plant safety and integrity"]
[null,null,null,"4142 Environmental protection ",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4142PROT","4142 Environmental protection"]
[null,null,null,"4143 Decommissioning",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4143DECO","4143 Decommissioning"]
[null,null,null,"4144 Other nuclear supporting technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4144ONUC","4144 Other nuclear supporting technologies"]
[null,null,null,"4149 Unallocated nuclear supporting technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"4149ONUN","4149 Unallocated nuclear supporting technologies"]
[null,null,"415 Nuclear breeder",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"415BREED","415 Nuclear breeder"]
[null,null,"416 Other nuclear fission",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"416OFISS","416 Other nuclear fission"]
[null,null,"419 Unallocated nuclear fission",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"419FISUN","419 Unallocated nuclear fission"]
[null,"42 Nuclear fusion",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E139-SUM(E140:E143)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"42FUSION","42 Nuclear fusion"]
[null,null,"421 Magnetic confinement",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"421MACON","421 Magnetic confinement"]
[null,null,"422 Inertial confinement",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"422INCON","422 Inertial confinement"]
[null,null,"423 Other nuclear fusion",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"423OFUSI","423 Other nuclear fusion"]
[null,null,"429 Unallocated nuclear fusion",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"429FUSUN","429 Unallocated nuclear fusion"]
[null,"49 Unallocated nuclear fission and fusion",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"49NUCUN","49 Unallocated nuclear"]
["5  HYDROGEN and FUEL CELLS (sum of rows 51 and 59)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E145-(E146+E153+E158)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"HGENCELL","GROUP 5: HYDROGEN AND FUEL CELLS"]
[null,"51 Hydrogen",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E146-SUM(E147:E152)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"51HYDROG","51 Hydrogen"]
[null,null,"511 Hydrogen production",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"511HYPRO","511 Hydrogen production"]
[null,null,"512 Hydrogen  storage",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"512HYSTO","512 Hydrogen storage"]
[null,null,"513 Hydrogen transport and distribution",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"513HYTRA","513 Hydrogen transport and distribution"]
[null,null,"514 Other infrastructure and systems ",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"514HYINF","514 Other infrastructure and systems"]
[null,null,"515 Hydrogen end-uses (incl. combustion; excl. fuel cells and vehicles)",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"515HYEND","515 Hydrogen end-uses"]
[null,null,"519 Unallocated hydrogen",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"519HYDUN","519 Unallocated hydrogen"]
[null,"52 Fuel cells",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E153-SUM(E154:E157)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"52FUELCE","52 Fuel cells"]
[null,null,"521 Stationary applications",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"521FUSTA","521 Stationary applications"]
[null,null,"522 Mobile applications",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"522FUMOB","522 Mobile applications"]
[null,null,"523 Other applications",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"523FUOTH","523 Other applications"]
[null,null,"529 Unallocated fuel cells",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"529FUELUN","529 Unallocated fuel cells"]
[null,"59 Unallocated hydrogen and fuel cells",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"59HYFUUN","59 Unallocated hydrogen and fuel cells"]
["6  OTHER POWER and STORAGE TECHNOLOGIES (sum of rows 61 to 69)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E159-(E160+E165+E177+E186)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"OTHERPANDS","GROUP 6: OTHER POWER AND STORAGE TECHNOLOGIES"]
[null,"61 Electric power generation    ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E160-SUM(E161:E164)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"61POWCON","61 Electric power conversion"]
[null,null,"611 Power generation technologies",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"611GETEC","611 Power generation technologies"]
[null,null,"612 Power generation supporting technologies",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"612GESUP","612 Power generation supporting technologies"]
[null,null,"613 Other electric power generation",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"613GEOTH","613 Other electricity power generation"]
[null,null,"619 Unallocated electric power generation",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"619POWUN","619 Unallocated electric power generation"]
[null,"62 Electricity transmission and distribution",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E165-(E166+E171+E176)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"62TRADIS","62 Electricity transmission and distribution"]
[null,null,"621 Transmission and distribution technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E166-SUM(E167:E170)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"621TDTEC","621 Transmission and distribution technologies"]
[null,null,null,"6211 Cables and conductors (superconducting, conventional, composite core)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6211CABL","6211 Cables and conductors"]
[null,null,null,"6212 AC/DC conversion",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6212ACDC","6212 AC/DC conversion"]
[null,null,null,"6213 Other transmission and distribution technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6213OTHE","6213 Other transmission and distribution techs."]
[null,null,null,"6219 Unallocated transmission and distribution technologies",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6219TDTUN","6219 Unallocated transmission and distribution"]
[null,null,"622 Grid communication, control systems and integration",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E171-SUM(E172:E175)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"622GRIDC","622 Grid comm, control systems and integration"]
[null,null,null,"6221 Load management (incl. renewable integration)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6221LOAD","6221 Load management"]
[null,null,null,"6222 Control systems and monitoring",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6222CONT","6222 Control systems and monitoring"]
[null,null,null,"6223 Standards, interoperability and grid cyber security",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6223STAN","6223 Standards, interoper.+grid cyber security"]
[null,null,null,"6229 Unallocated grid communication, control systems and integration",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6229GRIDUN","6229 Unallocated grid comm,, control and integration"]
[null,null,"629 Unallocated electricity transmission and distribution",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"629TRANUN","Unallocated electricity transmission/distribution"]
[null,"63 Energy storage (non-transport applications)              ",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E177-(E178+E184+E185)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"63ENSTOR","63 Energy storage"]
[null,null,"631 Electrical storage",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E178-SUM(E179:E183)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"631ELSTO","631 Electrical storage"]
[null,null,null,"6311 Batteries and other electrochemical storage (excl. vehicles and general \n         public portable devices)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6311BATT","6311 Batteries/other electrochemical storage"]
[null,null,null,"6312 Electromagnetic storage",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6312ELMA","6312 Electromagnetic storage"]
[null,null,null,"6313 Mechanical storage",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6313MECH","6313 Mechanical storage"]
[null,null,null,"6314 Other storage (excl. fuel cells)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6314OSTO","6314 Other storage (excl. fuel cells)"]
[null,null,null,"6319 Unallocated electrical storage",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"6319ELSUN","6319 Unallocated electrical storage"]
[null,null,"632 Thermal energy storage",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"632THEST","632 Thermal energy storage"]
[null,null,"639 Unallocated energy storage ",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"639ENSTUN","639 Unallocated energy storage"]
[null,"69 Unallocated other power and storage technologies",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"69OPOWUN","69 Unallocated other power and storage techs."]
["7  OTHER CROSS-CUTTING TECHNOLOGIES or RESEARCH (sum of rows 71 to 73)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",{"$f":"ROUND(ABS(E187-SUM(E188:E190)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"OTHERTECH","GROUP 7: OTHER CROSS-CUTTING TECHS/RESEARCH"]
[null,"71 Energy system analysis",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"71SYSANA","71 Energy system analysis"]
[null,"72 Basic energy research that cannot be allocated to a specific category",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"72BASICUN","72 Basic energy research not allocated"]
[null,"73 Other",null,null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"73OTHER","73 Other"]
["8  UNALLOCATED",null,null,null,0,0,0,0,0,0,null,null,null,"blue",null,null,null,null,null,null,null,null,null,null,null,null,"UNALLOC","GROUP 8: UNALLOCATED"]
["TOTAL BUDGET (sum of rows 1 to 8)",null,null,null,0,0,0,0,0,0,null,null,null,"blue",null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL","TOTAL BUDGET"]
["CHECK 1st LEVEL TOTALS",null,null,null,{"$f":"IF(ROUND(ABS(E192-SUM(E8+E52+E73+E118+E145+E159+E187+E191)),$J$2)>$O$5,ROUND(ABS(E192-SUM(E8+E52+E73+E118+E145+E159+E187+E191)),$J$2),0)","v":0},0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"###"]
["MEMO ITEMS:",null,null,null,null,null,null,null,null,null,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"###"]
[null,"Smart grids",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E195-SUM(E196:E201)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEMSMART","Memo: Smart grids"]
[null,null,"Part of 1221 (optional) Building energy management systems (incl. smart meters) and \n            efficient internet and communication technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E196<=E20","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1221","Memo: Part of 1221"]
[null,null,"1314 (optional) Electric vehicle infrastructure",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E197=E36","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1314A","Memo: Electric vehicle infrastructure"]
[null,null,"621 Transmission and distribution technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E198=E166","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM621","Memo: Transmission and distribution technologies"]
[null,null,"622 Grid communication, control systems and integration",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E199=E171","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM622","Memo: Grid communication etc"]
[null,null,"Part of 71 Energy system analysis that is part of the smart grid concept",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E200<=E188","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM71","Memo: Part of 71"]
[null,null,"Smart grid figures not identified in previous categories",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEMOTHSM","Memo: Smart grids not specified"]
[null,"Electric vehicles",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E202-SUM(E203:E206)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEMELVEH","Memo: Electric vehicles"]
[null,null,"Part of 1311 (optional) Vehicle batteries/storage technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E203<=E33","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1311A","Memo: Part of 1311"]
[null,null,"Part of 1312 (optional) Advanced power electronics, motors, and EV/HEV/FCV systems",null,0,0,0,0,0,0,null,null,null,"white",true,true,true,true,true,true,null,null,null,null,null,null,"MEM1312","Memo: Parts of 1312"]
[null,null,"1314 (optional) Electric vehicle infrastructure ",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E205=E36","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1314B","Memo: Electric vehicle infrastructure"]
[null,null,"Electric vehicle figures not identified in previous categories",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEMOTHEV","Memo: Electric Vehicles not specified"]
[null,"Energy storage",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E207-SUM(E208:E212)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEMENSTO","Memo: Energy Storage"]
[null,null,"1232 (optional) Batteries for portable devices",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E208=E27","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1232","Memo: Batteries for portable devices"]
[null,null,"1311 (optional) Vehicle batteries/storage technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E209=E33","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1311B","Memo: Vehicle batteries/storage technologies"]
[null,null,"512 Hydrogen storage",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E210=E148","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM512","Memo: Hydrogen storage"]
[null,null,"63 Energy storage (non-transport applications)",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E211=E177","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM63","Memo: Energy storage (non-transport apps)"]
[null,null,"Energy storage figures not identified in previous categories",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEMOTES","Memo: Energy storage not specified"]
[null,"Low-carbon heating and cooling of buildings (relevant component of)",null,null,0,0,0,0,0,0,null,null,null,"white",{"$f":"ROUND(ABS(E213-SUM(E214:E216,E220:E227)),$J$2)<=$O$5","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEMHEAT","Memo: Low-carbon heating and cooling of buildings"]
[null,null,"1211 Building envelope technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E214=E16","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1211","Memo: Building envelope technologies"]
[null,null,"1221 Building energy management systems (incl. smart meters) and efficient internet\n          and communication technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E215=E20","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1221B","Memo: Building energy management systems"]
[null,null,"1223 Heating, cooling and ventilation technologies",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E216=E22","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM1223","Memo: Heating, cooling and ventilation technologies"]
[null,null,null,"12231 Heating (optional)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEM12231","Memo: Heating (optional)"]
[null,null,null,"12232 Cooling (optional)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEM12232","Memo: Cooling (optional)"]
[null,null,null,"12233 Ventilation/other (optional)",0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEM12233","Memo: Ventilation (optional)"]
[null,null,"Part of 141 Waste heat recovery and utilisation",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E220<=E45","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM141","Memo: Waste heat recovery"]
[null,null,"Part of 142 Communities - District heating and cooling",null,0,0,0,0,0,0,null,null,null,"white",true,true,true,true,true,true,null,null,null,null,null,null,"MEM142","Memo: Communities - district heating and cooling"]
[null,null,"Part of 144 Heat pumps and chillers",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E222<=E48","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM144","Memo: Heat pumps and chillers"]
[null,null,"Part of 311 Solar heating and cooling",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E223<=E75","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM311","Memo: Solar heating and cooling"]
[null,null,"Part of 344 Biofuels - Applications for heat and electricity",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E224<=E103","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM344","Memo: Biofuels - Applications for heat and electricity"]
[null,null,"Part of 354 Other geothermal energy (incl. low-temp. resources)",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E225<=E110","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM354","Memo: Other geothermal energy"]
[null,null,"Part of 632 Thermal energy storage",null,0,0,0,0,0,0,null,null,null,"white",{"$f":"E226<=E632","v":true},true,true,true,true,true,null,null,null,null,null,null,"MEM632","Memo: Thermal energy storage"]
[null,null,"Low-carbon heating and cooling of buildings not identified in previous categories",null,0,0,0,0,0,0,null,null,null,"white",null,null,null,null,null,null,null,null,null,null,null,null,"MEMOTHEAT","Memo: Heat and cooling of buildings not specified"]