|
739
|
83743744669670
7403031LEFT([Code], FIND(".", [Code])-1)IINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Hydrocarbon fuel power generation2550
8682585LEFT([Code], FIND(".", [Code])-1)IINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Hydrocarbon fuel power generation
7541595LEFT([Code], FIND(".", [Code])-1)IIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Nuclear power generation
1701878LEFT([Code], FIND(".", [Code])-1)IIIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))National renewable power generation
1702879LEFT([Code], FIND(".", [Code])-1)IIIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))National renewable power generation
7983015LEFT([Code], FIND(".", [Code])-1)IIIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))National renewable power generation799
8033030LEFT([Code], FIND(".", [Code])-1)IIIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))National renewable power generation
25602LEFT([Code], FIND(".", [Code])-1)IIIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))National renewable power generation
25612802LEFT([Code], FIND(".", [Code])-1)IIIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))National renewable power generation
25622803LEFT([Code], FIND(".", [Code])-1)IIIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))National renewable power generation
8042784LEFT([Code], FIND(".", [Code])-1)IIIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))National renewable power generation
8052431LEFT([Code], FIND(".", [Code])-1)IIIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))National renewable power generation
96368LEFT([Code], FIND(".", [Code])-1)IVINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Distributed renewable power generation
13133032LEFT([Code], FIND(".", [Code])-1)IVINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Distributed renewable power generation
15743033LEFT([Code], FIND(".", [Code])-1)IVINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Distributed renewable power generation
9503035LEFT([Code], FIND(".", [Code])-1)VINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Bioenergy
16661667LEFT([Code], FIND(".", [Code])-1)VINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Bioenergy
9112339LEFT([Code], FIND(".", [Code])-1)VIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Agriculture and waste
9523034LEFT([Code], FIND(".", [Code])-1)VIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Agriculture and waste
22052204672INDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Agriculture and waste
77255LEFT([Code], FIND(".", [Code])-1)VIIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Electricity distribution, storage, and balancing
782773LEFT([Code], FIND(".", [Code])-1)VIIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Electricity distribution, storage, and balancing
7923036LEFT([Code], FIND(".", [Code])-1)VIIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Electricity distribution, storage, and balancing796
9682625LEFT([Code], FIND(".", [Code])-1)VIIIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))H2 Production
8241267LEFT([Code], FIND(".", [Code])-1)IXINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Heating
27262822LEFT([Code], FIND(".", [Code])-1)IXINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Heating
27342823LEFT([Code], FIND(".", [Code])-1)IXINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Heating
3331333267629
8852432LEFT([Code], FIND(".", [Code])-1)IXINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Heating
9321310LEFT([Code], FIND(".", [Code])-1)IXINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Heating
9332433LEFT([Code], FIND(".", [Code])-1)IXINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Heating
937939LEFT([Code], FIND(".", [Code])-1)XINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Lighting and appliances
938940LEFT([Code], FIND(".", [Code])-1)XINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Lighting and appliances
887460LEFT([Code], FIND(".", [Code])-1)XIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Industry
8901347LEFT([Code], FIND(".", [Code])-1)XIIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Transport
9031348LEFT([Code], FIND(".", [Code])-1)XIIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Transport
906942LEFT([Code], FIND(".", [Code])-1)XIIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Transport
9412429LEFT([Code], FIND(".", [Code])-1)XIIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Transport
944955LEFT([Code], FIND(".", [Code])-1)XIIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Transport
9462430LEFT([Code], FIND(".", [Code])-1)XIIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Transport
9172428LEFT([Code], FIND(".", [Code])-1)XIIIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Food consumption [UNUSED]
949453LEFT([Code], FIND(".", [Code])-1)XIVINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Geosequestration
958162LEFT([Code], FIND(".", [Code])-1)XVINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Fossil fuel production
975976LEFT([Code], FIND(".", [Code])-1)XVINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Fossil fuel production
9991001LEFT([Code], FIND(".", [Code])-1)XVIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Transfers1193
10002177LEFT([Code], FIND(".", [Code])-1)XVIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))Transfers
13221321LEFT([Code], FIND(".", [Code])-1)XVIIINDEX(Workstreams[Workstream], MATCH([WS Code], Workstreams[Code], 0))District heating1323
|
|
|
|
|