# coding: utf-8 # XII.a class Sheet43 < Spreadsheet def e8; @e8 ||= sheet3.z26; end def e9; @e9 ||= sheet3.z27; end def c17; 1.0; end def f17; 14104.004213212675; end def g17; 14247.0; end def h17; 14113.0; end def i17; 14427.0; end def j17; 14683.0; end def k17; 14862.0; end def l17; 15056.0; end def m17; 15152.0; end def n17; 15254.0; end def o17; 15363.0; end def c18; 2.0; end def f18; 14104.004213212675; end def g18; 14079.0; end def h18; 14018.0; end def i18; 14373.0; end def j18; 14667.0; end def k18; 14792.0; end def l18; 14934.0; end def m18; 14956.0; end def n18; 14984.0; end def o18; 15023.0; end def c19; 3.0; end def f19; 14104.004213212675; end def g19; 14079.0; end def h19; 14018.0; end def i19; 14373.0; end def j19; 14667.0; end def k19; 14792.0; end def l19; 14934.0; end def m19; 14956.0; end def n19; 14984.0; end def o19; 15023.0; end def c20; 4.0; end def f20; 14104.004213212675; end def g20; 14077.0; end def h20; 13946.0; end def i20; 14150.0; end def j20; 14300.0; end def k20; 14300.0; end def l20; 14323.0; end def m20; 14231.0; end def n20; 14147.0; end def o20; 14076.0; end def g24; 1.0; end def h24; 2.0; end def i24; 3.0; end def j24; 4.0; end def g25; 0.022; end def h25; 0.022; end def i25; 0.022; end def j25; 0.022; end def g26; 0.007; end def h26; 0.009; end def i26; 0.01; end def j26; 0.047; end def g27; 0.823; end def h27; 0.803; end def i27; 0.736; end def j27; 0.624; end def g28; 0.072; end def h28; 0.088; end def i28; 0.132; end def j28; 0.187; end def g29; 0.055; end def h29; 0.057; end def i29; 0.079; end def j29; 0.098; end def g30; 0.021; end def h30; 0.021; end def i30; 0.021; end def j30; 0.021; end def g35; 1.0; end def h35; 2.0; end def i35; 3.0; end def j35; 4.0; end def g36; 1.4535833325868115; end def h36; 1.4535833325868115; end def i36; 1.511726665890284; end def j36; 1.5407983325420203; end def g37; 9.054545454545455; end def h37; 12.0; end def i37; 18.0; end def j37; 18.0; end def g38; 0.3681150635671386; end def h38; 0.3681150635671386; end def i38; 0.40588480110308967; end def j38; 0.42190146532760275; end def g39; 0.651; end def h39; 0.651; end def i39; 0.651; end def j39; 0.651; end def f47; 1.0; end def g47; 1.0; end def h47; 0.996; end def i47; 0.992; end def j47; 0.956; end def k47; 0.92; end def l47; 0.88; end def m47; 0.84; end def n47; 0.8075; end def o47; 0.775; end def f48; 0.0; end def g48; 0.0; end def h48; 0.0035; end def i48; 0.007; end def j48; 0.038500000000000006; end def k48; 0.07; end def l48; 0.10500000000000001; end def m48; 0.14; end def n48; 0.17; end def o48; 0.2; end def f49; 0.0; end def g49; 0.0; end def h49; 0.0005; end def i49; 0.001; end def j49; 0.0055; end def k49; 0.01; end def l49; 0.015; end def m49; 0.02; end def n49; 0.0225; end def o49; 0.025; end def f50; 0.0; end def g50; 0.0; end def h50; 0.0; end def i50; 0.0; end def j50; 0.0; end def k50; 0.0; end def l50; 0.0; end def m50; 0.0; end def n50; 0.0; end def o50; 0.0; end def f51; 1.0; end def g51; 0.987; end def h51; 0.9390000000000001; end def i51; 0.891; end def j51; 0.8425; end def k51; 0.794; end def l51; 0.746; end def m51; 0.698; end def n51; 0.6495; end def o51; 0.601; end def f52; 0.0; end def g52; 0.011; end def h52; 0.0595; end def i52; 0.108; end def j52; 0.156; end def k52; 0.204; end def l52; 0.2525; end def m52; 0.301; end def n52; 0.349; end def o52; 0.397; end def f53; 0.0; end def g53; 0.0; end def h53; 0.001; end def i53; 0.002; end def j53; 0.002; end def k53; 0.002; end def l53; 0.002; end def m53; 0.002; end def n53; 0.002; end def o53; 0.002; end def f54; 0.0; end def g54; 0.0; end def h54; 0.001; end def i54; 0.002; end def j54; 0.002; end def k54; 0.002; end def l54; 0.002; end def m54; 0.002; end def n54; 0.002; end def o54; 0.002; end def f55; 0.35; end def g55; 0.363354413782636; end def h55; 0.363354413782636; end def i55; 0.363354413782636; end def j55; 0.363354413782636; end def k55; 0.363354413782636; end def l55; 0.363354413782636; end def m55; 0.363354413782636; end def n55; 0.363354413782636; end def o55; 0.363354413782636; end def f56; 0.65; end def g56; 0.636645586217364; end def h56; 0.636645586217364; end def i56; 0.636645586217364; end def j56; 0.636645586217364; end def k56; 0.636645586217364; end def l56; 0.636645586217364; end def m56; 0.636645586217364; end def n56; 0.636645586217364; end def o56; 0.636645586217364; end def f57; 1.0; end def g57; 1.0; end def h57; 1.0; end def i57; 1.0; end def j57; 1.0; end def k57; 1.0; end def l57; 1.0; end def m57; 1.0; end def n57; 1.0; end def o57; 1.0; end def f62; 1.0; end def g62; 1.0; end def h62; 0.985; end def i62; 0.97; end def j62; 0.84; end def k62; 0.71; end def l62; 0.62; end def m62; 0.53; end def n62; 0.44; end def o62; 0.35; end def f63; 0.0; end def g63; 0.0; end def h63; 0.005; end def i63; 0.01; end def j63; 0.13; end def k63; 0.25; end def l63; 0.315; end def m63; 0.38; end def n63; 0.46; end def o63; 0.54; end def f64; 0.0; end def g64; 0.0; end def h64; 0.01; end def i64; 0.02; end def j64; 0.03; end def k64; 0.04; end def l64; 0.065; end def m64; 0.09; end def n64; 0.095; end def o64; 0.1; end def f65; 0.0; end def g65; 0.0; end def h65; 0.0; end def i65; 0.0; end def j65; 0.0; end def k65; 0.0; end def l65; 0.0; end def m65; 0.0; end def n65; 0.005; end def o65; 0.01; end def f66; 1.0; end def g66; 0.989; end def h66; 0.8935; end def i66; 0.798; end def j66; 0.448; end def k66; 0.098; end def l66; 0.049; end def m66; 0.0; end def n66; 0.0; end def o66; 0.0; end def f67; 0.0; end def g67; 0.011; end def h67; 0.10550000000000001; end def i67; 0.2; end def j67; 0.55; end def k67; 0.9; end def l67; 0.9490000000000001; end def m67; 0.998; end def n67; 0.998; end def o67; 0.998; end def f68; 0.0; end def g68; 0.0; end def h68; 0.001; end def i68; 0.002; end def j68; 0.002; end def k68; 0.002; end def l68; 0.002; end def m68; 0.002; end def n68; 0.002; end def o68; 0.002; end def f69; 0.0; end def g69; 0.0; end def h69; 0.001; end def i69; 0.002; end def j69; 0.002; end def k69; 0.002; end def l69; 0.002; end def m69; 0.002; end def n69; 0.002; end def o69; 0.002; end def f70; 0.35; end def g70; 0.363354413782636; end def h70; 0.363354413782636; end def i70; 0.2972945212673762; end def j70; 0.2972945212673762; end def k70; 0.268693979915269; end def l70; 0.268693979915269; end def m70; 0.268693979915269; end def n70; 0.268693979915269; end def o70; 0.268693979915269; end def f71; 0.65; end def g71; 0.636645586217364; end def h71; 0.636645586217364; end def i71; 0.7027054787326238; end def j71; 0.7027054787326238; end def k71; 0.731306020084731; end def l71; 0.731306020084731; end def m71; 0.731306020084731; end def n71; 0.731306020084731; end def o71; 0.731306020084731; end def f72; 1.0; end def g72; 1.0; end def h72; 1.0; end def i72; 1.0; end def j72; 1.0; end def k72; 1.0; end def l72; 1.0; end def m72; 1.0; end def n72; 1.0; end def o72; 1.0; end def f77; 1.0; end def g77; 1.0; end def h77; 0.985; end def i77; 0.97; end def j77; 0.705; end def k77; 0.44; end def l77; 0.41000000000000003; end def m77; 0.38; end def n77; 0.29000000000000004; end def o77; 0.2; end def f78; 0.0; end def g78; 0.0; end def h78; 0.005; end def i78; 0.01; end def j78; 0.2275; end def k78; 0.445; end def l78; 0.3825; end def m78; 0.32; end def n78; 0.32; end def o78; 0.32; end def f79; 0.0; end def g79; 0.0; end def h79; 0.01; end def i79; 0.02; end def j79; 0.05; end def k79; 0.08; end def l79; 0.14; end def m79; 0.2; end def n79; 0.24000000000000002; end def o79; 0.28; end def f80; 0.0; end def g80; 0.0; end def h80; 0.0; end def i80; 0.0; end def j80; 0.0175; end def k80; 0.035; end def l80; 0.0675; end def m80; 0.1; end def n80; 0.15000000000000002; end def o80; 0.2; end def f81; 1.0; end def g81; 0.989; end def h81; 0.712; end def i81; 0.435; end def j81; 0.2175; end def k81; 0.0; end def l81; 0.0; end def m81; 0.0; end def n81; 0.0; end def o81; 0.0; end def f82; 0.0; end def g82; 0.011; end def h82; 0.271; end def i82; 0.531; end def j82; 0.728; end def k82; 0.925; end def l82; 0.8925000000000001; end def m82; 0.86; end def n82; 0.8200000000000001; end def o82; 0.78; end def f83; 0.0; end def g83; 0.0; end def h83; 0.0085; end def i83; 0.017; end def j83; 0.02725; end def k83; 0.0375; end def l83; 0.053750000000000006; end def m83; 0.07; end def n83; 0.09; end def o83; 0.11; end def f84; 0.0; end def g84; 0.0; end def h84; 0.0085; end def i84; 0.017; end def j84; 0.02725; end def k84; 0.0375; end def l84; 0.053750000000000006; end def m84; 0.07; end def n84; 0.09; end def o84; 0.11; end def f85; 0.35; end def g85; 0.363354413782636; end def h85; 0.363354413782636; end def i85; 0.2972945212673762; end def j85; 0.28299425059132255; end def k85; 0.24182458192374212; end def l85; 0.21495518393221524; end def m85; 0.18808578594068837; end def n85; 0.1612163879491615; end def o85; 0.1343469899576345; end def f86; 0.65; end def g86; 0.636645586217364; end def h86; 0.636645586217364; end def i86; 0.7027054787326238; end def j86; 0.7170057494086775; end def k86; 0.7581754180762579; end def l86; 0.7850448160677848; end def m86; 0.8119142140593116; end def n86; 0.8387836120508385; end def o86; 0.8656530100423655; end def f87; 1.0; end def g87; 1.0; end def h87; 1.0; end def i87; 1.0; end def j87; 1.0; end def k87; 1.0; end def l87; 1.0; end def m87; 1.0; end def n87; 1.0; end def o87; 1.0; end def f92; 1.0; end def g92; 1.0; end def h92; 0.99; end def i92; 0.97; end def j92; 0.66; end def k92; 0.34; end def l92; 0.26; end def m92; 0.18; end def n92; 0.09; end def o92; 0.0; end def f93; 0.0; end def g93; 0.0; end def h93; 0.01; end def i93; 0.01; end def j93; 0.23; end def k93; 0.445; end def l93; 0.3825; end def m93; 0.32; end def n93; 0.16; end def o93; 0.0; end def f94; 0.0; end def g94; 0.0; end def h94; 0.01; end def i94; 0.02; end def j94; 0.09999999999999999; end def k94; 0.18; end def l94; 0.29000000000000004; end def m94; 0.4; end def n94; 0.6000000000000001; end def o94; 0.8; end def f95; 0.0; end def g95; 0.0; end def h95; 0.0; end def i95; 0.0; end def j95; 0.0175; end def k95; 0.035; end def l95; 0.0675; end def m95; 0.1; end def n95; 0.15000000000000002; end def o95; 0.2; end def f96; 1.0; end def g96; 0.989; end def h96; 0.712; end def i96; 0.435; end def j96; 0.2175; end def k96; 0.0; end def l96; 0.0; end def m96; 0.0; end def n96; 0.0; end def o96; 0.0; end def f97; 0.0; end def g97; 0.011; end def h97; 0.271; end def i97; 0.531; end def j97; 0.6779999999999999; end def k97; 0.825; end def l97; 0.7475; end def m97; 0.67; end def n97; 0.5900000000000001; end def o97; 0.51; end def f98; 0.0; end def g98; 0.0; end def h98; 0.0085; end def i98; 0.017; end def j98; 0.05225; end def k98; 0.0875; end def l98; 0.12625; end def m98; 0.165; end def n98; 0.20500000000000002; end def o98; 0.245; end def f99; 0.0; end def g99; 0.0; end def h99; 0.0085; end def i99; 0.017; end def j99; 0.05225; end def k99; 0.0875; end def l99; 0.12625; end def m99; 0.165; end def n99; 0.20500000000000002; end def o99; 0.245; end def f100; 0.35; end def g100; 0.363354413782636; end def h100; 0.363354413782636; end def i100; 0.2972945212673762; end def j100; 0.268693979915269; end def k100; 0.21495518393221524; end def l100; 0.1612163879491615; end def m100; 0.10747759196610773; end def n100; 0.05373879598305398; end def o100; 0.0; end def f101; 0.65; end def g101; 0.636645586217364; end def h101; 0.636645586217364; end def i101; 0.7027054787326238; end def j101; 0.731306020084731; end def k101; 0.7850448160677848; end def l101; 0.8387836120508385; end def m101; 0.8925224080338923; end def n101; 0.946261204016946; end def o101; 1.0; end def f102; 1.0; end def g102; 1.0; end def h102; 1.0; end def i102; 1.0; end def j102; 1.0; end def k102; 1.0; end def l102; 1.0; end def m102; 1.0; end def n102; 1.0; end def o102; 1.0; end def g120; 0.7; end def h120; 0.6238888888888889; end def i120; 0.5480555555555555; end def j120; 0.4711111111111111; end def k120; 0.39416666666666667; end def l120; 0.37222222222222223; end def m120; 0.3502777777777778; end def n120; 0.335; end def o120; 0.32; end def g121; 0.1411111111111111; end def h121; 0.1411111111111111; end def i121; 0.12611111111111112; end def j121; 0.0961111111111111; end def k121; 0.07694444444444444; end def l121; 0.06861111111111111; end def m121; 0.059444444444444446; end def n121; 0.049166666666666664; end def o121; 0.03944444444444444; end def g122; 3.9225; end def h122; 3.641388888888889; end def i122; 3.3602777777777777; end def j122; 3.0791666666666666; end def k122; 2.7980555555555555; end def l122; 2.777222222222222; end def m122; 2.756388888888889; end def n122; 2.7355555555555555; end def o122; 2.714722222222222; end def g123; 2.745833333333333; end def h123; 2.549027777777778; end def i123; 2.352222222222222; end def j123; 2.1554166666666665; end def k123; 1.958611111111111; end def l123; 1.944027777777778; end def m123; 1.9294444444444445; end def n123; 1.9148611111111111; end def o123; 1.9002777777777777; end def g124; 0.1059406157140987; end def h124; 0.10064358492839408; end def i124; 0.09534655414268915; end def j124; 0.09004952335698421; end def k124; 0.08475249257127927; end def l124; 0.07945546178557433; end def m124; 0.0741584309998694; end def n124; 0.06886140021416437; end def o124; 0.06356436942845943; end def g125; 0.5807786676090225; end def h125; 0.5523147340903598; end def i125; 0.5252458165330964; end def j125; 0.49950354527457563; end def k125; 0.47502290144589554; end def l125; 0.45174205274967494; end def m125; 0.42960219728634175; end def n125; 0.40854741503448777; end def o125; 0.38852452661016346; end def g130; 0.11583333333333333; end def h130; 0.11583333333333333; end def i130; 0.11222222222222222; end def j130; 0.10472222222222222; end def k130; 0.09861111111111111; end def l130; 0.09388888888888888; end def m130; 0.09083333333333334; end def n130; 0.09; end def o130; 0.09027777777777778; end def g131; 0.16666666666666666; end def h131; 0.16666666666666666; end def i131; 0.15888888888888889; end def j131; 0.14333333333333334; end def k131; 0.13055555555555556; end def l131; 0.12027777777777778; end def m131; 0.11277777777777778; end def n131; 0.10805555555555556; end def o131; 0.10527777777777778; end def g132; 0.9336111111111111; end def h132; 0.8666666666666667; end def i132; 0.7997222222222222; end def j132; 0.7327777777777778; end def k132; 0.6658333333333334; end def l132; 0.6609722222222223; end def m132; 0.6561111111111111; end def n132; 0.6511111111111111; end def o132; 0.6461111111111111; end def g133; 0.0318579183353621; end def h133; 0.030663246397786; end def i133; 0.02946857446021; end def j133; 0.0282739025226339; end def k133; 0.0270792305850578; end def l133; 0.0258845586474817; end def m133; 0.0246898867099056; end def n133; 0.0234952147723296; end def o133; 0.0223005428347535; end def o138; 0.13555555555555557; end def o139; 3.89; end def f144; 4.288; end def g144; 4.288; end def h144; 4.288; end def i144; 4.288; end def j144; 4.288; end def k144; 4.288; end def l144; 4.288; end def m144; 4.288; end def n144; 4.288; end def o144; 4.288; end def f159; 2007.0; end def g159; 2010.0; end def h159; 2015.0; end def i159; 2020.0; end def j159; 2025.0; end def k159; 2030.0; end def l159; 2035.0; end def m159; 2040.0; end def n159; 2045.0; end def o159; 2050.0; end def c160; "WALK"; end def f160; 0.021680038900835603; end def g160; @g160 ||= f160+(o160-f160)/(o159-f159)*(g159-f159); end def h160; @h160 ||= f160+(o160-f160)/(o159-f159)*(h159-f159); end def i160; @i160 ||= f160+(o160-f160)/(o159-f159)*(i159-f159); end def j160; @j160 ||= f160+(o160-f160)/(o159-f159)*(j159-f159); end def k160; @k160 ||= f160+(o160-f160)/(o159-f159)*(k159-f159); end def l160; @l160 ||= f160+(o160-f160)/(o159-f159)*(l159-f159); end def m160; @m160 ||= f160+(o160-f160)/(o159-f159)*(m159-f159); end def n160; @n160 ||= f160+(o160-f160)/(o159-f159)*(n159-f159); end def o160; @o160 ||= index(a('g25','j25'),match(e8,a('g24','j24'),0.0)); end def c161; "BIKE"; end def f161; 0.005084268859379436; end def g161; @g161 ||= f161+(o161-f161)/(o159-f159)*(g159-f159); end def h161; @h161 ||= f161+(o161-f161)/(o159-f159)*(h159-f159); end def i161; @i161 ||= f161+(o161-f161)/(o159-f159)*(i159-f159); end def j161; @j161 ||= f161+(o161-f161)/(o159-f159)*(j159-f159); end def k161; @k161 ||= f161+(o161-f161)/(o159-f159)*(k159-f159); end def l161; @l161 ||= f161+(o161-f161)/(o159-f159)*(l159-f159); end def m161; @m161 ||= f161+(o161-f161)/(o159-f159)*(m159-f159); end def n161; @n161 ||= f161+(o161-f161)/(o159-f159)*(n159-f159); end def o161; @o161 ||= index(a('g26','j26'),match(e8,a('g24','j24'),0.0)); end def c162; "CAR"; end def f162; 0.832103179442072; end def g162; @g162 ||= f162+(o162-f162)/(o159-f159)*(g159-f159); end def h162; @h162 ||= f162+(o162-f162)/(o159-f159)*(h159-f159); end def i162; @i162 ||= f162+(o162-f162)/(o159-f159)*(i159-f159); end def j162; @j162 ||= f162+(o162-f162)/(o159-f159)*(j159-f159); end def k162; @k162 ||= f162+(o162-f162)/(o159-f159)*(k159-f159); end def l162; @l162 ||= f162+(o162-f162)/(o159-f159)*(l159-f159); end def m162; @m162 ||= f162+(o162-f162)/(o159-f159)*(m159-f159); end def n162; @n162 ||= f162+(o162-f162)/(o159-f159)*(n159-f159); end def o162; @o162 ||= index(a('g27','j27'),match(e8,a('g24','j24'),0.0)); end def c163; "BUS"; end def f163; 0.059627670922358024; end def g163; @g163 ||= f163+(o163-f163)/(o159-f159)*(g159-f159); end def h163; @h163 ||= f163+(o163-f163)/(o159-f159)*(h159-f159); end def i163; @i163 ||= f163+(o163-f163)/(o159-f159)*(i159-f159); end def j163; @j163 ||= f163+(o163-f163)/(o159-f159)*(j159-f159); end def k163; @k163 ||= f163+(o163-f163)/(o159-f159)*(k159-f159); end def l163; @l163 ||= f163+(o163-f163)/(o159-f159)*(l159-f159); end def m163; @m163 ||= f163+(o163-f163)/(o159-f159)*(m159-f159); end def n163; @n163 ||= f163+(o163-f163)/(o159-f159)*(n159-f159); end def o163; @o163 ||= index(a('g28','j28'),match(e8,a('g24','j24'),0.0)); end def c164; "RAIL"; end def f164; 0.07009723627466924; end def g164; @g164 ||= f164+(o164-f164)/(o159-f159)*(g159-f159); end def h164; @h164 ||= f164+(o164-f164)/(o159-f159)*(h159-f159); end def i164; @i164 ||= f164+(o164-f164)/(o159-f159)*(i159-f159); end def j164; @j164 ||= f164+(o164-f164)/(o159-f159)*(j159-f159); end def k164; @k164 ||= f164+(o164-f164)/(o159-f159)*(k159-f159); end def l164; @l164 ||= f164+(o164-f164)/(o159-f159)*(l159-f159); end def m164; @m164 ||= f164+(o164-f164)/(o159-f159)*(m159-f159); end def n164; @n164 ||= f164+(o164-f164)/(o159-f159)*(n159-f159); end def o164; @o164 ||= index(a('g29','j29'),match(e8,a('g24','j24'),0.0)); end def c165; "AIR"; end def f165; 0.011407605600685865; end def g165; @g165 ||= f165+(o165-f165)/(o159-f159)*(g159-f159); end def h165; @h165 ||= f165+(o165-f165)/(o159-f159)*(h159-f159); end def i165; @i165 ||= f165+(o165-f165)/(o159-f159)*(i159-f159); end def j165; @j165 ||= f165+(o165-f165)/(o159-f159)*(j159-f159); end def k165; @k165 ||= f165+(o165-f165)/(o159-f159)*(k159-f159); end def l165; @l165 ||= f165+(o165-f165)/(o159-f159)*(l159-f159); end def m165; @m165 ||= f165+(o165-f165)/(o159-f159)*(m159-f159); end def n165; @n165 ||= f165+(o165-f165)/(o159-f159)*(n159-f159); end def o165; @o165 ||= index(a('g30','j30'),match(e8,a('g24','j24'),0.0)); end def c173; "CAR"; end def d173; "ICE"; end def f173_array; @f173_array ||= m(e9,a('f47','o57'),a('f62','o72'),a('f77','o87'),a('f92','o102')) { |r1,r2,r3,r4,r5| choose(r1,r2,r3,r4,r5) }; end def f173; @f173 ||= f173_array.array_formula_offset(0,0); end def g173; @g173 ||= f173_array.array_formula_offset(0,1); end def h173; @h173 ||= f173_array.array_formula_offset(0,2); end def i173; @i173 ||= f173_array.array_formula_offset(0,3); end def j173; @j173 ||= f173_array.array_formula_offset(0,4); end def k173; @k173 ||= f173_array.array_formula_offset(0,5); end def l173; @l173 ||= f173_array.array_formula_offset(0,6); end def m173; @m173 ||= f173_array.array_formula_offset(0,7); end def n173; @n173 ||= f173_array.array_formula_offset(0,8); end def o173; @o173 ||= f173_array.array_formula_offset(0,9); end def c174; "CAR"; end def d174; "PHEV"; end def f174; @f174 ||= f173_array.array_formula_offset(1,0); end def g174; @g174 ||= f173_array.array_formula_offset(1,1); end def h174; @h174 ||= f173_array.array_formula_offset(1,2); end def i174; @i174 ||= f173_array.array_formula_offset(1,3); end def j174; @j174 ||= f173_array.array_formula_offset(1,4); end def k174; @k174 ||= f173_array.array_formula_offset(1,5); end def l174; @l174 ||= f173_array.array_formula_offset(1,6); end def m174; @m174 ||= f173_array.array_formula_offset(1,7); end def n174; @n174 ||= f173_array.array_formula_offset(1,8); end def o174; @o174 ||= f173_array.array_formula_offset(1,9); end def c175; "CAR"; end def d175; "EV"; end def f175; @f175 ||= f173_array.array_formula_offset(2,0); end def g175; @g175 ||= f173_array.array_formula_offset(2,1); end def h175; @h175 ||= f173_array.array_formula_offset(2,2); end def i175; @i175 ||= f173_array.array_formula_offset(2,3); end def j175; @j175 ||= f173_array.array_formula_offset(2,4); end def k175; @k175 ||= f173_array.array_formula_offset(2,5); end def l175; @l175 ||= f173_array.array_formula_offset(2,6); end def m175; @m175 ||= f173_array.array_formula_offset(2,7); end def n175; @n175 ||= f173_array.array_formula_offset(2,8); end def o175; @o175 ||= f173_array.array_formula_offset(2,9); end def c176; "CAR"; end def d176; "FCV"; end def f176; @f176 ||= f173_array.array_formula_offset(3,0); end def g176; @g176 ||= f173_array.array_formula_offset(3,1); end def h176; @h176 ||= f173_array.array_formula_offset(3,2); end def i176; @i176 ||= f173_array.array_formula_offset(3,3); end def j176; @j176 ||= f173_array.array_formula_offset(3,4); end def k176; @k176 ||= f173_array.array_formula_offset(3,5); end def l176; @l176 ||= f173_array.array_formula_offset(3,6); end def m176; @m176 ||= f173_array.array_formula_offset(3,7); end def n176; @n176 ||= f173_array.array_formula_offset(3,8); end def o176; @o176 ||= f173_array.array_formula_offset(3,9); end def c177; "BUS"; end def d177; "ICE"; end def f177; @f177 ||= f173_array.array_formula_offset(4,0); end def g177; @g177 ||= f173_array.array_formula_offset(4,1); end def h177; @h177 ||= f173_array.array_formula_offset(4,2); end def i177; @i177 ||= f173_array.array_formula_offset(4,3); end def j177; @j177 ||= f173_array.array_formula_offset(4,4); end def k177; @k177 ||= f173_array.array_formula_offset(4,5); end def l177; @l177 ||= f173_array.array_formula_offset(4,6); end def m177; @m177 ||= f173_array.array_formula_offset(4,7); end def n177; @n177 ||= f173_array.array_formula_offset(4,8); end def o177; @o177 ||= f173_array.array_formula_offset(4,9); end def c178; "BUS"; end def d178; "HEV"; end def f178; @f178 ||= f173_array.array_formula_offset(5,0); end def g178; @g178 ||= f173_array.array_formula_offset(5,1); end def h178; @h178 ||= f173_array.array_formula_offset(5,2); end def i178; @i178 ||= f173_array.array_formula_offset(5,3); end def j178; @j178 ||= f173_array.array_formula_offset(5,4); end def k178; @k178 ||= f173_array.array_formula_offset(5,5); end def l178; @l178 ||= f173_array.array_formula_offset(5,6); end def m178; @m178 ||= f173_array.array_formula_offset(5,7); end def n178; @n178 ||= f173_array.array_formula_offset(5,8); end def o178; @o178 ||= f173_array.array_formula_offset(5,9); end def c179; "BUS"; end def d179; "EV"; end def f179; @f179 ||= f173_array.array_formula_offset(6,0); end def g179; @g179 ||= f173_array.array_formula_offset(6,1); end def h179; @h179 ||= f173_array.array_formula_offset(6,2); end def i179; @i179 ||= f173_array.array_formula_offset(6,3); end def j179; @j179 ||= f173_array.array_formula_offset(6,4); end def k179; @k179 ||= f173_array.array_formula_offset(6,5); end def l179; @l179 ||= f173_array.array_formula_offset(6,6); end def m179; @m179 ||= f173_array.array_formula_offset(6,7); end def n179; @n179 ||= f173_array.array_formula_offset(6,8); end def o179; @o179 ||= f173_array.array_formula_offset(6,9); end def c180; "BUS"; end def d180; "FCV"; end def f180; @f180 ||= f173_array.array_formula_offset(7,0); end def g180; @g180 ||= f173_array.array_formula_offset(7,1); end def h180; @h180 ||= f173_array.array_formula_offset(7,2); end def i180; @i180 ||= f173_array.array_formula_offset(7,3); end def j180; @j180 ||= f173_array.array_formula_offset(7,4); end def k180; @k180 ||= f173_array.array_formula_offset(7,5); end def l180; @l180 ||= f173_array.array_formula_offset(7,6); end def m180; @m180 ||= f173_array.array_formula_offset(7,7); end def n180; @n180 ||= f173_array.array_formula_offset(7,8); end def o180; @o180 ||= f173_array.array_formula_offset(7,9); end def c181; "RAIL"; end def d181; "DIESEL"; end def f181; @f181 ||= f173_array.array_formula_offset(8,0); end def g181; @g181 ||= f173_array.array_formula_offset(8,1); end def h181; @h181 ||= f173_array.array_formula_offset(8,2); end def i181; @i181 ||= f173_array.array_formula_offset(8,3); end def j181; @j181 ||= f173_array.array_formula_offset(8,4); end def k181; @k181 ||= f173_array.array_formula_offset(8,5); end def l181; @l181 ||= f173_array.array_formula_offset(8,6); end def m181; @m181 ||= f173_array.array_formula_offset(8,7); end def n181; @n181 ||= f173_array.array_formula_offset(8,8); end def o181; @o181 ||= f173_array.array_formula_offset(8,9); end def c182; "RAIL"; end def d182; "ELECTRIC"; end def f182; @f182 ||= f173_array.array_formula_offset(9,0); end def g182; @g182 ||= f173_array.array_formula_offset(9,1); end def h182; @h182 ||= f173_array.array_formula_offset(9,2); end def i182; @i182 ||= f173_array.array_formula_offset(9,3); end def j182; @j182 ||= f173_array.array_formula_offset(9,4); end def k182; @k182 ||= f173_array.array_formula_offset(9,5); end def l182; @l182 ||= f173_array.array_formula_offset(9,6); end def m182; @m182 ||= f173_array.array_formula_offset(9,7); end def n182; @n182 ||= f173_array.array_formula_offset(9,8); end def o182; @o182 ||= f173_array.array_formula_offset(9,9); end def c183; "AIR"; end def d183; "AIR"; end def f183; @f183 ||= f173_array.array_formula_offset(10,0); end def g183; @g183 ||= f173_array.array_formula_offset(10,1); end def h183; @h183 ||= f173_array.array_formula_offset(10,2); end def i183; @i183 ||= f173_array.array_formula_offset(10,3); end def j183; @j183 ||= f173_array.array_formula_offset(10,4); end def k183; @k183 ||= f173_array.array_formula_offset(10,5); end def l183; @l183 ||= f173_array.array_formula_offset(10,6); end def m183; @m183 ||= f173_array.array_formula_offset(10,7); end def n183; @n183 ||= f173_array.array_formula_offset(10,8); end def o183; @o183 ||= f173_array.array_formula_offset(10,9); end def c188; "CAR"; end def f188; 1.4535833325868115; end def g188; @g188 ||= f188+(o188-f188)/(o159-f159)*(g159-f159); end def h188; @h188 ||= f188+(o188-f188)/(o159-f159)*(h159-f159); end def i188; @i188 ||= f188+(o188-f188)/(o159-f159)*(i159-f159); end def j188; @j188 ||= f188+(o188-f188)/(o159-f159)*(j159-f159); end def k188; @k188 ||= f188+(o188-f188)/(o159-f159)*(k159-f159); end def l188; @l188 ||= f188+(o188-f188)/(o159-f159)*(l159-f159); end def m188; @m188 ||= f188+(o188-f188)/(o159-f159)*(m159-f159); end def n188; @n188 ||= f188+(o188-f188)/(o159-f159)*(n159-f159); end def o188_array; @o188_array ||= m(0.0,m(e8,0.0) { |r1,r2| match(r1,a('g35','j35'),r2) }) { |r1,r2| index(a('g36','j39'),r1,r2) }; end def o188; @o188 ||= o188_array.array_formula_offset(0,0); end def c189; "BUS"; end def f189; 9.054545454545455; end def g189; @g189 ||= f189+(o189-f189)/(o159-f159)*(g159-f159); end def h189; @h189 ||= f189+(o189-f189)/(o159-f159)*(h159-f159); end def i189; @i189 ||= f189+(o189-f189)/(o159-f159)*(i159-f159); end def j189; @j189 ||= f189+(o189-f189)/(o159-f159)*(j159-f159); end def k189; @k189 ||= f189+(o189-f189)/(o159-f159)*(k159-f159); end def l189; @l189 ||= f189+(o189-f189)/(o159-f159)*(l159-f159); end def m189; @m189 ||= f189+(o189-f189)/(o159-f159)*(m159-f159); end def n189; @n189 ||= f189+(o189-f189)/(o159-f159)*(n159-f159); end def o189; @o189 ||= o188_array.array_formula_offset(1,0); end def c190; "RAIL"; end def f190; 0.32418351096303916; end def g190; @g190 ||= f190+(o190-f190)/(o159-f159)*(g159-f159); end def h190; @h190 ||= f190+(o190-f190)/(o159-f159)*(h159-f159); end def i190; @i190 ||= f190+(o190-f190)/(o159-f159)*(i159-f159); end def j190; @j190 ||= f190+(o190-f190)/(o159-f159)*(j159-f159); end def k190; @k190 ||= f190+(o190-f190)/(o159-f159)*(k159-f159); end def l190; @l190 ||= f190+(o190-f190)/(o159-f159)*(l159-f159); end def m190; @m190 ||= f190+(o190-f190)/(o159-f159)*(m159-f159); end def n190; @n190 ||= f190+(o190-f190)/(o159-f159)*(n159-f159); end def o190; @o190 ||= o188_array.array_formula_offset(2,0); end def c191; "AIR"; end def f191; 0.651; end def g191; @g191 ||= f191+(o191-f191)/(o159-f159)*(g159-f159); end def h191; @h191 ||= f191+(o191-f191)/(o159-f159)*(h159-f159); end def i191; @i191 ||= f191+(o191-f191)/(o159-f159)*(i159-f159); end def j191; @j191 ||= f191+(o191-f191)/(o159-f159)*(j159-f159); end def k191; @k191 ||= f191+(o191-f191)/(o159-f159)*(k159-f159); end def l191; @l191 ||= f191+(o191-f191)/(o159-f159)*(l159-f159); end def m191; @m191 ||= f191+(o191-f191)/(o159-f159)*(m159-f159); end def n191; @n191 ||= f191+(o191-f191)/(o159-f159)*(n159-f159); end def o191; @o191 ||= o188_array.array_formula_offset(3,0); end def c196; "CAR"; end def d196; "ICE"; end def f196; 0.546297407872344; end def g196; @g196 ||= g120/sheet43.g188; end def h196; @h196 ||= h120/sheet43.h188; end def i196; @i196 ||= i120/sheet43.i188; end def j196; @j196 ||= j120/sheet43.j188; end def k196; @k196 ||= k120/sheet43.k188; end def l196; @l196 ||= l120/sheet43.l188; end def m196; @m196 ||= m120/sheet43.m188; end def n196; @n196 ||= n120/sheet43.n188; end def o196; @o196 ||= o120/sheet43.o188; end def c197; "CAR"; end def d197; "PHEV"; end def g197; @g197 ||= g121/sheet43.g188; end def h197; @h197 ||= h121/sheet43.h188; end def i197; @i197 ||= i121/sheet43.i188; end def j197; @j197 ||= j121/sheet43.j188; end def k197; @k197 ||= k121/sheet43.k188; end def l197; @l197 ||= l121/sheet43.l188; end def m197; @m197 ||= m121/sheet43.m188; end def n197; @n197 ||= n121/sheet43.n188; end def o197; @o197 ||= o121/sheet43.o188; end def c198; "BUS"; end def d198; "ICE"; end def f198; 0.239492423538389; end def g198; @g198 ||= g122/sheet43.g189; end def h198; @h198 ||= h122/sheet43.h189; end def i198; @i198 ||= i122/sheet43.i189; end def j198; @j198 ||= j122/sheet43.j189; end def k198; @k198 ||= k122/sheet43.k189; end def l198; @l198 ||= l122/sheet43.l189; end def m198; @m198 ||= m122/sheet43.m189; end def n198; @n198 ||= n122/sheet43.n189; end def o198; @o198 ||= o122/sheet43.o189; end def c199; "BUS"; end def d199; "HEV"; end def g199; @g199 ||= g123/sheet43.g189; end def h199; @h199 ||= h123/sheet43.h189; end def i199; @i199 ||= i123/sheet43.i189; end def j199; @j199 ||= j123/sheet43.j189; end def k199; @k199 ||= k123/sheet43.k189; end def l199; @l199 ||= l123/sheet43.l189; end def m199; @m199 ||= m123/sheet43.m189; end def n199; @n199 ||= n123/sheet43.n189; end def o199; @o199 ||= o123/sheet43.o189; end def c200; "RAIL"; end def d200; "DIESEL"; end def f200; 0.23040647569418302; end def g200; @g200 ||= g124/sheet43.g190; end def h200; @h200 ||= h124/sheet43.h190; end def i200; @i200 ||= i124/sheet43.i190; end def j200; @j200 ||= j124/sheet43.j190; end def k200; @k200 ||= k124/sheet43.k190; end def l200; @l200 ||= l124/sheet43.l190; end def m200; @m200 ||= m124/sheet43.m190; end def n200; @n200 ||= n124/sheet43.n190; end def o200; @o200 ||= o124/sheet43.o190; end def c201; "AIR"; end def d201; "AIR"; end def f201; 0.9194414607948442; end def g201; @g201 ||= g125/sheet43.g191; end def h201; @h201 ||= h125/sheet43.h191; end def i201; @i201 ||= i125/sheet43.i191; end def j201; @j201 ||= j125/sheet43.j191; end def k201; @k201 ||= k125/sheet43.k191; end def l201; @l201 ||= l125/sheet43.l191; end def m201; @m201 ||= m125/sheet43.m191; end def n201; @n201 ||= n125/sheet43.n191; end def o201; @o201 ||= o125/sheet43.o191; end def c206; "CAR"; end def d206; "PHEV"; end def g206; @g206 ||= g130/sheet43.g188; end def h206; @h206 ||= h130/sheet43.h188; end def i206; @i206 ||= i130/sheet43.i188; end def j206; @j206 ||= j130/sheet43.j188; end def k206; @k206 ||= k130/sheet43.k188; end def l206; @l206 ||= l130/sheet43.l188; end def m206; @m206 ||= m130/sheet43.m188; end def n206; @n206 ||= n130/sheet43.n188; end def o206; @o206 ||= o130/sheet43.o188; end def c207; "CAR"; end def d207; "EV"; end def g207; @g207 ||= g131/sheet43.g188; end def h207; @h207 ||= h131/sheet43.h188; end def i207; @i207 ||= i131/sheet43.i188; end def j207; @j207 ||= j131/sheet43.j188; end def k207; @k207 ||= k131/sheet43.k188; end def l207; @l207 ||= l131/sheet43.l188; end def m207; @m207 ||= m131/sheet43.m188; end def n207; @n207 ||= n131/sheet43.n188; end def o207; @o207 ||= o131/sheet43.o188; end def c208; "BUS"; end def d208; "EV"; end def g208; @g208 ||= g132/sheet43.g189; end def h208; @h208 ||= h132/sheet43.h189; end def i208; @i208 ||= i132/sheet43.i189; end def j208; @j208 ||= j132/sheet43.j189; end def k208; @k208 ||= k132/sheet43.k189; end def l208; @l208 ||= l132/sheet43.l189; end def m208; @m208 ||= m132/sheet43.m189; end def n208; @n208 ||= n132/sheet43.n189; end def o208; @o208 ||= o132/sheet43.o189; end def c209; "RAIL"; end def d209; "ELECTRIC"; end def f209; 0.10954818290623002; end def g209; @g209 ||= g133/sheet43.g190; end def h209; @h209 ||= h133/sheet43.h190; end def i209; @i209 ||= i133/sheet43.i190; end def j209; @j209 ||= j133/sheet43.j190; end def k209; @k209 ||= k133/sheet43.k190; end def l209; @l209 ||= l133/sheet43.l190; end def m209; @m209 ||= m133/sheet43.m190; end def n209; @n209 ||= n133/sheet43.n190; end def o209; @o209 ||= o133/sheet43.o190; end def c214; "CAR"; end def d214; "FCV"; end def o214; @o214 ||= o138/sheet43.o188; end def c215; "BUS"; end def d215; "FCV"; end def o215; @o215 ||= o139/sheet43.o189; end def f228; @f228 ||= index(a('f17','f20'),match(e8,a('c17','c20'),0.0)); end def g228; @g228 ||= index(a('g17','g20'),match(e8,a('c17','c20'),0.0)); end def h228; @h228 ||= index(a('h17','h20'),match(e8,a('c17','c20'),0.0)); end def i228; @i228 ||= index(a('i17','i20'),match(e8,a('c17','c20'),0.0)); end def j228; @j228 ||= index(a('j17','j20'),match(e8,a('c17','c20'),0.0)); end def k228; @k228 ||= index(a('k17','k20'),match(e8,a('c17','c20'),0.0)); end def l228; @l228 ||= index(a('l17','l20'),match(e8,a('c17','c20'),0.0)); end def m228; @m228 ||= index(a('m17','m20'),match(e8,a('c17','c20'),0.0)); end def n228; @n228 ||= index(a('n17','n20'),match(e8,a('c17','c20'),0.0)); end def o228; @o228 ||= index(a('o17','o20'),match(e8,a('c17','c20'),0.0)); end def f229; 60.973; end def g229; 62.222403; end def h229; 64.344156; end def i229; 66.521962; end def j229; 68.647528; end def k229; 70.575666; end def l229; 72.27823000000002; end def m229; 73.853253; end def n229; 75.356458; end def o229; 76.789483; end def f230; @f230 ||= f228*f229/1000.0; end def g230; @g230 ||= g228*g229/1000.0; end def h230; @h230 ||= h228*h229/1000.0; end def i230; @i230 ||= i228*i229/1000.0; end def j230; @j230 ||= j228*j229/1000.0; end def k230; @k230 ||= k228*k229/1000.0; end def l230; @l230 ||= l228*l229/1000.0; end def m230; @m230 ||= m228*m229/1000.0; end def n230; @n230 ||= n228*n229/1000.0; end def o230; @o230 ||= o228*o229/1000.0; end def c233; "WALK"; end def f233; 0.021680038900835603; end def g233; @g233 ||= sheet43.g160; end def h233; @h233 ||= sheet43.h160; end def i233; @i233 ||= sheet43.i160; end def j233; @j233 ||= sheet43.j160; end def k233; @k233 ||= sheet43.k160; end def l233; @l233 ||= sheet43.l160; end def m233; @m233 ||= sheet43.m160; end def n233; @n233 ||= sheet43.n160; end def o233; @o233 ||= sheet43.o160; end def c234; "BIKE"; end def f234; 0.005084268859379436; end def g234; @g234 ||= sheet43.g161; end def h234; @h234 ||= sheet43.h161; end def i234; @i234 ||= sheet43.i161; end def j234; @j234 ||= sheet43.j161; end def k234; @k234 ||= sheet43.k161; end def l234; @l234 ||= sheet43.l161; end def m234; @m234 ||= sheet43.m161; end def n234; @n234 ||= sheet43.n161; end def o234; @o234 ||= sheet43.o161; end def c235; "CAR"; end def f235; 0.832103179442072; end def g235; @g235 ||= sheet43.g162; end def h235; @h235 ||= sheet43.h162; end def i235; @i235 ||= sheet43.i162; end def j235; @j235 ||= sheet43.j162; end def k235; @k235 ||= sheet43.k162; end def l235; @l235 ||= sheet43.l162; end def m235; @m235 ||= sheet43.m162; end def n235; @n235 ||= sheet43.n162; end def o235; @o235 ||= sheet43.o162; end def c236; "BUS"; end def f236; 0.059627670922358024; end def g236; @g236 ||= sheet43.g163; end def h236; @h236 ||= sheet43.h163; end def i236; @i236 ||= sheet43.i163; end def j236; @j236 ||= sheet43.j163; end def k236; @k236 ||= sheet43.k163; end def l236; @l236 ||= sheet43.l163; end def m236; @m236 ||= sheet43.m163; end def n236; @n236 ||= sheet43.n163; end def o236; @o236 ||= sheet43.o163; end def c237; "RAIL"; end def f237; 0.07009723627466924; end def g237; @g237 ||= sheet43.g164; end def h237; @h237 ||= sheet43.h164; end def i237; @i237 ||= sheet43.i164; end def j237; @j237 ||= sheet43.j164; end def k237; @k237 ||= sheet43.k164; end def l237; @l237 ||= sheet43.l164; end def m237; @m237 ||= sheet43.m164; end def n237; @n237 ||= sheet43.n164; end def o237; @o237 ||= sheet43.o164; end def c238; "AIR"; end def f238; 0.011407605600685865; end def g238; @g238 ||= sheet43.g165; end def h238; @h238 ||= sheet43.h165; end def i238; @i238 ||= sheet43.i165; end def j238; @j238 ||= sheet43.j165; end def k238; @k238 ||= sheet43.k165; end def l238; @l238 ||= sheet43.l165; end def m238; @m238 ||= sheet43.m165; end def n238; @n238 ||= sheet43.n165; end def o238; @o238 ||= sheet43.o165; end def c241; "WALK"; end def f241; @f241 ||= f233*f230; end def g241; @g241 ||= g233*g230; end def h241; @h241 ||= h233*h230; end def i241; @i241 ||= i233*i230; end def j241; @j241 ||= j233*j230; end def k241; @k241 ||= k233*k230; end def l241; @l241 ||= l233*l230; end def m241; @m241 ||= m233*m230; end def n241; @n241 ||= n233*n230; end def o241; @o241 ||= o233*o230; end def c242; "BIKE"; end def f242; @f242 ||= f234*f230; end def g242; @g242 ||= g234*g230; end def h242; @h242 ||= h234*h230; end def i242; @i242 ||= i234*i230; end def j242; @j242 ||= j234*j230; end def k242; @k242 ||= k234*k230; end def l242; @l242 ||= l234*l230; end def m242; @m242 ||= m234*m230; end def n242; @n242 ||= n234*n230; end def o242; @o242 ||= o234*o230; end def c243; "CAR"; end def f243; @f243 ||= f235*f230; end def g243; @g243 ||= g235*g230; end def h243; @h243 ||= h235*h230; end def i243; @i243 ||= i235*i230; end def j243; @j243 ||= j235*j230; end def k243; @k243 ||= k235*k230; end def l243; @l243 ||= l235*l230; end def m243; @m243 ||= m235*m230; end def n243; @n243 ||= n235*n230; end def o243; @o243 ||= o235*o230; end def c244; "BUS"; end def f244; @f244 ||= f236*f230; end def g244; @g244 ||= g236*g230; end def h244; @h244 ||= h236*h230; end def i244; @i244 ||= i236*i230; end def j244; @j244 ||= j236*j230; end def k244; @k244 ||= k236*k230; end def l244; @l244 ||= l236*l230; end def m244; @m244 ||= m236*m230; end def n244; @n244 ||= n236*n230; end def o244; @o244 ||= o236*o230; end def c245; "RAIL"; end def f245; @f245 ||= f237*f230; end def g245; @g245 ||= g237*g230; end def h245; @h245 ||= h237*h230; end def i245; @i245 ||= i237*i230; end def j245; @j245 ||= j237*j230; end def k245; @k245 ||= k237*k230; end def l245; @l245 ||= l237*l230; end def m245; @m245 ||= m237*m230; end def n245; @n245 ||= n237*n230; end def o245; @o245 ||= o237*o230; end def c246; "AIR"; end def f246; @f246 ||= f238*f230; end def g246; @g246 ||= g238*g230; end def h246; @h246 ||= h238*h230; end def i246; @i246 ||= i238*i230; end def j246; @j246 ||= j238*j230; end def k246; @k246 ||= k238*k230; end def l246; @l246 ||= l238*l230; end def m246; @m246 ||= m238*m230; end def n246; @n246 ||= n238*n230; end def o246; @o246 ||= o238*o230; end def c253; "CAR"; end def d253; "ICE"; end def f253; @f253 ||= sumifs(a('f241','f246'),a('c241','c246'),c253)*sumifs(a('f173','f183'),a('c173','c183'),c253,a('d173','d183'),d253); end def g253; @g253 ||= sumifs(a('g241','g246'),a('c241','c246'),c253)*sumifs(a('g173','g183'),a('c173','c183'),c253,a('d173','d183'),d253); end def h253; @h253 ||= sumifs(a('h241','h246'),a('c241','c246'),c253)*sumifs(a('h173','h183'),a('c173','c183'),c253,a('d173','d183'),d253); end def i253; @i253 ||= sumifs(a('i241','i246'),a('c241','c246'),c253)*sumifs(a('i173','i183'),a('c173','c183'),c253,a('d173','d183'),d253); end def j253; @j253 ||= sumifs(a('j241','j246'),a('c241','c246'),c253)*sumifs(a('j173','j183'),a('c173','c183'),c253,a('d173','d183'),d253); end def k253; @k253 ||= sumifs(a('k241','k246'),a('c241','c246'),c253)*sumifs(a('k173','k183'),a('c173','c183'),c253,a('d173','d183'),d253); end def l253; @l253 ||= sumifs(a('l241','l246'),a('c241','c246'),c253)*sumifs(a('l173','l183'),a('c173','c183'),c253,a('d173','d183'),d253); end def m253; @m253 ||= sumifs(a('m241','m246'),a('c241','c246'),c253)*sumifs(a('m173','m183'),a('c173','c183'),c253,a('d173','d183'),d253); end def n253; @n253 ||= sumifs(a('n241','n246'),a('c241','c246'),c253)*sumifs(a('n173','n183'),a('c173','c183'),c253,a('d173','d183'),d253); end def o253; @o253 ||= sumifs(a('o241','o246'),a('c241','c246'),c253)*sumifs(a('o173','o183'),a('c173','c183'),c253,a('d173','d183'),d253); end def c254; "CAR"; end def d254; "PHEV"; end def f254; @f254 ||= sumifs(a('f241','f246'),a('c241','c246'),c254)*sumifs(a('f173','f183'),a('c173','c183'),c254,a('d173','d183'),d254); end def g254; @g254 ||= sumifs(a('g241','g246'),a('c241','c246'),c254)*sumifs(a('g173','g183'),a('c173','c183'),c254,a('d173','d183'),d254); end def h254; @h254 ||= sumifs(a('h241','h246'),a('c241','c246'),c254)*sumifs(a('h173','h183'),a('c173','c183'),c254,a('d173','d183'),d254); end def i254; @i254 ||= sumifs(a('i241','i246'),a('c241','c246'),c254)*sumifs(a('i173','i183'),a('c173','c183'),c254,a('d173','d183'),d254); end def j254; @j254 ||= sumifs(a('j241','j246'),a('c241','c246'),c254)*sumifs(a('j173','j183'),a('c173','c183'),c254,a('d173','d183'),d254); end def k254; @k254 ||= sumifs(a('k241','k246'),a('c241','c246'),c254)*sumifs(a('k173','k183'),a('c173','c183'),c254,a('d173','d183'),d254); end def l254; @l254 ||= sumifs(a('l241','l246'),a('c241','c246'),c254)*sumifs(a('l173','l183'),a('c173','c183'),c254,a('d173','d183'),d254); end def m254; @m254 ||= sumifs(a('m241','m246'),a('c241','c246'),c254)*sumifs(a('m173','m183'),a('c173','c183'),c254,a('d173','d183'),d254); end def n254; @n254 ||= sumifs(a('n241','n246'),a('c241','c246'),c254)*sumifs(a('n173','n183'),a('c173','c183'),c254,a('d173','d183'),d254); end def o254; @o254 ||= sumifs(a('o241','o246'),a('c241','c246'),c254)*sumifs(a('o173','o183'),a('c173','c183'),c254,a('d173','d183'),d254); end def c255; "CAR"; end def d255; "EV"; end def f255; @f255 ||= sumifs(a('f241','f246'),a('c241','c246'),c255)*sumifs(a('f173','f183'),a('c173','c183'),c255,a('d173','d183'),d255); end def g255; @g255 ||= sumifs(a('g241','g246'),a('c241','c246'),c255)*sumifs(a('g173','g183'),a('c173','c183'),c255,a('d173','d183'),d255); end def h255; @h255 ||= sumifs(a('h241','h246'),a('c241','c246'),c255)*sumifs(a('h173','h183'),a('c173','c183'),c255,a('d173','d183'),d255); end def i255; @i255 ||= sumifs(a('i241','i246'),a('c241','c246'),c255)*sumifs(a('i173','i183'),a('c173','c183'),c255,a('d173','d183'),d255); end def j255; @j255 ||= sumifs(a('j241','j246'),a('c241','c246'),c255)*sumifs(a('j173','j183'),a('c173','c183'),c255,a('d173','d183'),d255); end def k255; @k255 ||= sumifs(a('k241','k246'),a('c241','c246'),c255)*sumifs(a('k173','k183'),a('c173','c183'),c255,a('d173','d183'),d255); end def l255; @l255 ||= sumifs(a('l241','l246'),a('c241','c246'),c255)*sumifs(a('l173','l183'),a('c173','c183'),c255,a('d173','d183'),d255); end def m255; @m255 ||= sumifs(a('m241','m246'),a('c241','c246'),c255)*sumifs(a('m173','m183'),a('c173','c183'),c255,a('d173','d183'),d255); end def n255; @n255 ||= sumifs(a('n241','n246'),a('c241','c246'),c255)*sumifs(a('n173','n183'),a('c173','c183'),c255,a('d173','d183'),d255); end def o255; @o255 ||= sumifs(a('o241','o246'),a('c241','c246'),c255)*sumifs(a('o173','o183'),a('c173','c183'),c255,a('d173','d183'),d255); end def c256; "CAR"; end def d256; "FCV"; end def f256; @f256 ||= sumifs(a('f241','f246'),a('c241','c246'),c256)*sumifs(a('f173','f183'),a('c173','c183'),c256,a('d173','d183'),d256); end def g256; @g256 ||= sumifs(a('g241','g246'),a('c241','c246'),c256)*sumifs(a('g173','g183'),a('c173','c183'),c256,a('d173','d183'),d256); end def h256; @h256 ||= sumifs(a('h241','h246'),a('c241','c246'),c256)*sumifs(a('h173','h183'),a('c173','c183'),c256,a('d173','d183'),d256); end def i256; @i256 ||= sumifs(a('i241','i246'),a('c241','c246'),c256)*sumifs(a('i173','i183'),a('c173','c183'),c256,a('d173','d183'),d256); end def j256; @j256 ||= sumifs(a('j241','j246'),a('c241','c246'),c256)*sumifs(a('j173','j183'),a('c173','c183'),c256,a('d173','d183'),d256); end def k256; @k256 ||= sumifs(a('k241','k246'),a('c241','c246'),c256)*sumifs(a('k173','k183'),a('c173','c183'),c256,a('d173','d183'),d256); end def l256; @l256 ||= sumifs(a('l241','l246'),a('c241','c246'),c256)*sumifs(a('l173','l183'),a('c173','c183'),c256,a('d173','d183'),d256); end def m256; @m256 ||= sumifs(a('m241','m246'),a('c241','c246'),c256)*sumifs(a('m173','m183'),a('c173','c183'),c256,a('d173','d183'),d256); end def n256; @n256 ||= sumifs(a('n241','n246'),a('c241','c246'),c256)*sumifs(a('n173','n183'),a('c173','c183'),c256,a('d173','d183'),d256); end def o256; @o256 ||= sumifs(a('o241','o246'),a('c241','c246'),c256)*sumifs(a('o173','o183'),a('c173','c183'),c256,a('d173','d183'),d256); end def c257; "BUS"; end def d257; "ICE"; end def f257; @f257 ||= sumifs(a('f241','f246'),a('c241','c246'),c257)*sumifs(a('f173','f183'),a('c173','c183'),c257,a('d173','d183'),d257); end def g257; @g257 ||= sumifs(a('g241','g246'),a('c241','c246'),c257)*sumifs(a('g173','g183'),a('c173','c183'),c257,a('d173','d183'),d257); end def h257; @h257 ||= sumifs(a('h241','h246'),a('c241','c246'),c257)*sumifs(a('h173','h183'),a('c173','c183'),c257,a('d173','d183'),d257); end def i257; @i257 ||= sumifs(a('i241','i246'),a('c241','c246'),c257)*sumifs(a('i173','i183'),a('c173','c183'),c257,a('d173','d183'),d257); end def j257; @j257 ||= sumifs(a('j241','j246'),a('c241','c246'),c257)*sumifs(a('j173','j183'),a('c173','c183'),c257,a('d173','d183'),d257); end def k257; @k257 ||= sumifs(a('k241','k246'),a('c241','c246'),c257)*sumifs(a('k173','k183'),a('c173','c183'),c257,a('d173','d183'),d257); end def l257; @l257 ||= sumifs(a('l241','l246'),a('c241','c246'),c257)*sumifs(a('l173','l183'),a('c173','c183'),c257,a('d173','d183'),d257); end def m257; @m257 ||= sumifs(a('m241','m246'),a('c241','c246'),c257)*sumifs(a('m173','m183'),a('c173','c183'),c257,a('d173','d183'),d257); end def n257; @n257 ||= sumifs(a('n241','n246'),a('c241','c246'),c257)*sumifs(a('n173','n183'),a('c173','c183'),c257,a('d173','d183'),d257); end def o257; @o257 ||= sumifs(a('o241','o246'),a('c241','c246'),c257)*sumifs(a('o173','o183'),a('c173','c183'),c257,a('d173','d183'),d257); end def c258; "BUS"; end def d258; "HEV"; end def f258; @f258 ||= sumifs(a('f241','f246'),a('c241','c246'),c258)*sumifs(a('f173','f183'),a('c173','c183'),c258,a('d173','d183'),d258); end def g258; @g258 ||= sumifs(a('g241','g246'),a('c241','c246'),c258)*sumifs(a('g173','g183'),a('c173','c183'),c258,a('d173','d183'),d258); end def h258; @h258 ||= sumifs(a('h241','h246'),a('c241','c246'),c258)*sumifs(a('h173','h183'),a('c173','c183'),c258,a('d173','d183'),d258); end def i258; @i258 ||= sumifs(a('i241','i246'),a('c241','c246'),c258)*sumifs(a('i173','i183'),a('c173','c183'),c258,a('d173','d183'),d258); end def j258; @j258 ||= sumifs(a('j241','j246'),a('c241','c246'),c258)*sumifs(a('j173','j183'),a('c173','c183'),c258,a('d173','d183'),d258); end def k258; @k258 ||= sumifs(a('k241','k246'),a('c241','c246'),c258)*sumifs(a('k173','k183'),a('c173','c183'),c258,a('d173','d183'),d258); end def l258; @l258 ||= sumifs(a('l241','l246'),a('c241','c246'),c258)*sumifs(a('l173','l183'),a('c173','c183'),c258,a('d173','d183'),d258); end def m258; @m258 ||= sumifs(a('m241','m246'),a('c241','c246'),c258)*sumifs(a('m173','m183'),a('c173','c183'),c258,a('d173','d183'),d258); end def n258; @n258 ||= sumifs(a('n241','n246'),a('c241','c246'),c258)*sumifs(a('n173','n183'),a('c173','c183'),c258,a('d173','d183'),d258); end def o258; @o258 ||= sumifs(a('o241','o246'),a('c241','c246'),c258)*sumifs(a('o173','o183'),a('c173','c183'),c258,a('d173','d183'),d258); end def c259; "BUS"; end def d259; "EV"; end def f259; @f259 ||= sumifs(a('f241','f246'),a('c241','c246'),c259)*sumifs(a('f173','f183'),a('c173','c183'),c259,a('d173','d183'),d259); end def g259; @g259 ||= sumifs(a('g241','g246'),a('c241','c246'),c259)*sumifs(a('g173','g183'),a('c173','c183'),c259,a('d173','d183'),d259); end def h259; @h259 ||= sumifs(a('h241','h246'),a('c241','c246'),c259)*sumifs(a('h173','h183'),a('c173','c183'),c259,a('d173','d183'),d259); end def i259; @i259 ||= sumifs(a('i241','i246'),a('c241','c246'),c259)*sumifs(a('i173','i183'),a('c173','c183'),c259,a('d173','d183'),d259); end def j259; @j259 ||= sumifs(a('j241','j246'),a('c241','c246'),c259)*sumifs(a('j173','j183'),a('c173','c183'),c259,a('d173','d183'),d259); end def k259; @k259 ||= sumifs(a('k241','k246'),a('c241','c246'),c259)*sumifs(a('k173','k183'),a('c173','c183'),c259,a('d173','d183'),d259); end def l259; @l259 ||= sumifs(a('l241','l246'),a('c241','c246'),c259)*sumifs(a('l173','l183'),a('c173','c183'),c259,a('d173','d183'),d259); end def m259; @m259 ||= sumifs(a('m241','m246'),a('c241','c246'),c259)*sumifs(a('m173','m183'),a('c173','c183'),c259,a('d173','d183'),d259); end def n259; @n259 ||= sumifs(a('n241','n246'),a('c241','c246'),c259)*sumifs(a('n173','n183'),a('c173','c183'),c259,a('d173','d183'),d259); end def o259; @o259 ||= sumifs(a('o241','o246'),a('c241','c246'),c259)*sumifs(a('o173','o183'),a('c173','c183'),c259,a('d173','d183'),d259); end def c260; "BUS"; end def d260; "FCV"; end def f260; @f260 ||= sumifs(a('f241','f246'),a('c241','c246'),c260)*sumifs(a('f173','f183'),a('c173','c183'),c260,a('d173','d183'),d260); end def g260; @g260 ||= sumifs(a('g241','g246'),a('c241','c246'),c260)*sumifs(a('g173','g183'),a('c173','c183'),c260,a('d173','d183'),d260); end def h260; @h260 ||= sumifs(a('h241','h246'),a('c241','c246'),c260)*sumifs(a('h173','h183'),a('c173','c183'),c260,a('d173','d183'),d260); end def i260; @i260 ||= sumifs(a('i241','i246'),a('c241','c246'),c260)*sumifs(a('i173','i183'),a('c173','c183'),c260,a('d173','d183'),d260); end def j260; @j260 ||= sumifs(a('j241','j246'),a('c241','c246'),c260)*sumifs(a('j173','j183'),a('c173','c183'),c260,a('d173','d183'),d260); end def k260; @k260 ||= sumifs(a('k241','k246'),a('c241','c246'),c260)*sumifs(a('k173','k183'),a('c173','c183'),c260,a('d173','d183'),d260); end def l260; @l260 ||= sumifs(a('l241','l246'),a('c241','c246'),c260)*sumifs(a('l173','l183'),a('c173','c183'),c260,a('d173','d183'),d260); end def m260; @m260 ||= sumifs(a('m241','m246'),a('c241','c246'),c260)*sumifs(a('m173','m183'),a('c173','c183'),c260,a('d173','d183'),d260); end def n260; @n260 ||= sumifs(a('n241','n246'),a('c241','c246'),c260)*sumifs(a('n173','n183'),a('c173','c183'),c260,a('d173','d183'),d260); end def o260; @o260 ||= sumifs(a('o241','o246'),a('c241','c246'),c260)*sumifs(a('o173','o183'),a('c173','c183'),c260,a('d173','d183'),d260); end def c261; "RAIL"; end def d261; "DIESEL"; end def f261; @f261 ||= sumifs(a('f241','f246'),a('c241','c246'),c261)*sumifs(a('f173','f183'),a('c173','c183'),c261,a('d173','d183'),d261); end def g261; @g261 ||= sumifs(a('g241','g246'),a('c241','c246'),c261)*sumifs(a('g173','g183'),a('c173','c183'),c261,a('d173','d183'),d261); end def h261; @h261 ||= sumifs(a('h241','h246'),a('c241','c246'),c261)*sumifs(a('h173','h183'),a('c173','c183'),c261,a('d173','d183'),d261); end def i261; @i261 ||= sumifs(a('i241','i246'),a('c241','c246'),c261)*sumifs(a('i173','i183'),a('c173','c183'),c261,a('d173','d183'),d261); end def j261; @j261 ||= sumifs(a('j241','j246'),a('c241','c246'),c261)*sumifs(a('j173','j183'),a('c173','c183'),c261,a('d173','d183'),d261); end def k261; @k261 ||= sumifs(a('k241','k246'),a('c241','c246'),c261)*sumifs(a('k173','k183'),a('c173','c183'),c261,a('d173','d183'),d261); end def l261; @l261 ||= sumifs(a('l241','l246'),a('c241','c246'),c261)*sumifs(a('l173','l183'),a('c173','c183'),c261,a('d173','d183'),d261); end def m261; @m261 ||= sumifs(a('m241','m246'),a('c241','c246'),c261)*sumifs(a('m173','m183'),a('c173','c183'),c261,a('d173','d183'),d261); end def n261; @n261 ||= sumifs(a('n241','n246'),a('c241','c246'),c261)*sumifs(a('n173','n183'),a('c173','c183'),c261,a('d173','d183'),d261); end def o261; @o261 ||= sumifs(a('o241','o246'),a('c241','c246'),c261)*sumifs(a('o173','o183'),a('c173','c183'),c261,a('d173','d183'),d261); end def c262; "RAIL"; end def d262; "ELECTRIC"; end def f262; @f262 ||= sumifs(a('f241','f246'),a('c241','c246'),c262)*sumifs(a('f173','f183'),a('c173','c183'),c262,a('d173','d183'),d262); end def g262; @g262 ||= sumifs(a('g241','g246'),a('c241','c246'),c262)*sumifs(a('g173','g183'),a('c173','c183'),c262,a('d173','d183'),d262); end def h262; @h262 ||= sumifs(a('h241','h246'),a('c241','c246'),c262)*sumifs(a('h173','h183'),a('c173','c183'),c262,a('d173','d183'),d262); end def i262; @i262 ||= sumifs(a('i241','i246'),a('c241','c246'),c262)*sumifs(a('i173','i183'),a('c173','c183'),c262,a('d173','d183'),d262); end def j262; @j262 ||= sumifs(a('j241','j246'),a('c241','c246'),c262)*sumifs(a('j173','j183'),a('c173','c183'),c262,a('d173','d183'),d262); end def k262; @k262 ||= sumifs(a('k241','k246'),a('c241','c246'),c262)*sumifs(a('k173','k183'),a('c173','c183'),c262,a('d173','d183'),d262); end def l262; @l262 ||= sumifs(a('l241','l246'),a('c241','c246'),c262)*sumifs(a('l173','l183'),a('c173','c183'),c262,a('d173','d183'),d262); end def m262; @m262 ||= sumifs(a('m241','m246'),a('c241','c246'),c262)*sumifs(a('m173','m183'),a('c173','c183'),c262,a('d173','d183'),d262); end def n262; @n262 ||= sumifs(a('n241','n246'),a('c241','c246'),c262)*sumifs(a('n173','n183'),a('c173','c183'),c262,a('d173','d183'),d262); end def o262; @o262 ||= sumifs(a('o241','o246'),a('c241','c246'),c262)*sumifs(a('o173','o183'),a('c173','c183'),c262,a('d173','d183'),d262); end def c263; "AIR"; end def d263; "AIR"; end def f263; @f263 ||= sumifs(a('f241','f246'),a('c241','c246'),c263)*sumifs(a('f173','f183'),a('c173','c183'),c263,a('d173','d183'),d263); end def g263; @g263 ||= sumifs(a('g241','g246'),a('c241','c246'),c263)*sumifs(a('g173','g183'),a('c173','c183'),c263,a('d173','d183'),d263); end def h263; @h263 ||= sumifs(a('h241','h246'),a('c241','c246'),c263)*sumifs(a('h173','h183'),a('c173','c183'),c263,a('d173','d183'),d263); end def i263; @i263 ||= sumifs(a('i241','i246'),a('c241','c246'),c263)*sumifs(a('i173','i183'),a('c173','c183'),c263,a('d173','d183'),d263); end def j263; @j263 ||= sumifs(a('j241','j246'),a('c241','c246'),c263)*sumifs(a('j173','j183'),a('c173','c183'),c263,a('d173','d183'),d263); end def k263; @k263 ||= sumifs(a('k241','k246'),a('c241','c246'),c263)*sumifs(a('k173','k183'),a('c173','c183'),c263,a('d173','d183'),d263); end def l263; @l263 ||= sumifs(a('l241','l246'),a('c241','c246'),c263)*sumifs(a('l173','l183'),a('c173','c183'),c263,a('d173','d183'),d263); end def m263; @m263 ||= sumifs(a('m241','m246'),a('c241','c246'),c263)*sumifs(a('m173','m183'),a('c173','c183'),c263,a('d173','d183'),d263); end def n263; @n263 ||= sumifs(a('n241','n246'),a('c241','c246'),c263)*sumifs(a('n173','n183'),a('c173','c183'),c263,a('d173','d183'),d263); end def o263; @o263 ||= sumifs(a('o241','o246'),a('c241','c246'),c263)*sumifs(a('o173','o183'),a('c173','c183'),c263,a('d173','d183'),d263); end def c269; "CAR"; end def d269; "ICE"; end def f269_array; @f269_array ||= m(a('f253','f263'),m(a('c269','c279'),a('d269','d279')) { |r1,r2| sumifs(a('f196','f201'),a('c196','c201'),r1,a('d196','d201'),r2) }) { |r1,r2| r1*r2 }; end def f269; @f269 ||= f269_array.array_formula_offset(0,0); end def g269_array; @g269_array ||= m(a('g253','g263'),m(a('c269','c279'),a('d269','d279')) { |r1,r2| sumifs(a('g196','g201'),a('c196','c201'),r1,a('d196','d201'),r2) }) { |r1,r2| r1*r2 }; end def g269; @g269 ||= g269_array.array_formula_offset(0,0); end def h269_array; @h269_array ||= m(a('h253','h263'),m(a('c269','c279'),a('d269','d279')) { |r1,r2| sumifs(a('h196','h201'),a('c196','c201'),r1,a('d196','d201'),r2) }) { |r1,r2| r1*r2 }; end def h269; @h269 ||= h269_array.array_formula_offset(0,0); end def i269_array; @i269_array ||= m(a('i253','i263'),m(a('c269','c279'),a('d269','d279')) { |r1,r2| sumifs(a('i196','i201'),a('c196','c201'),r1,a('d196','d201'),r2) }) { |r1,r2| r1*r2 }; end def i269; @i269 ||= i269_array.array_formula_offset(0,0); end def j269_array; @j269_array ||= m(a('j253','j263'),m(a('c269','c279'),a('d269','d279')) { |r1,r2| sumifs(a('j196','j201'),a('c196','c201'),r1,a('d196','d201'),r2) }) { |r1,r2| r1*r2 }; end def j269; @j269 ||= j269_array.array_formula_offset(0,0); end def k269_array; @k269_array ||= m(a('k253','k263'),m(a('c269','c279'),a('d269','d279')) { |r1,r2| sumifs(a('k196','k201'),a('c196','c201'),r1,a('d196','d201'),r2) }) { |r1,r2| r1*r2 }; end def k269; @k269 ||= k269_array.array_formula_offset(0,0); end def l269_array; @l269_array ||= m(a('l253','l263'),m(a('c269','c279'),a('d269','d279')) { |r1,r2| sumifs(a('l196','l201'),a('c196','c201'),r1,a('d196','d201'),r2) }) { |r1,r2| r1*r2 }; end def l269; @l269 ||= l269_array.array_formula_offset(0,0); end def m269_array; @m269_array ||= m(a('m253','m263'),m(a('c269','c279'),a('d269','d279')) { |r1,r2| sumifs(a('m196','m201'),a('c196','c201'),r1,a('d196','d201'),r2) }) { |r1,r2| r1*r2 }; end def m269; @m269 ||= m269_array.array_formula_offset(0,0); end def n269_array; @n269_array ||= m(a('n253','n263'),m(a('c269','c279'),a('d269','d279')) { |r1,r2| sumifs(a('n196','n201'),a('c196','c201'),r1,a('d196','d201'),r2) }) { |r1,r2| r1*r2 }; end def n269; @n269 ||= n269_array.array_formula_offset(0,0); end def o269_array; @o269_array ||= m(a('o253','o263'),m(a('c269','c279'),a('d269','d279')) { |r1,r2| sumifs(a('o196','o201'),a('c196','c201'),r1,a('d196','d201'),r2) }) { |r1,r2| r1*r2 }; end def o269; @o269 ||= o269_array.array_formula_offset(0,0); end def c270; "CAR"; end def d270; "PHEV"; end def f270; @f270 ||= f269_array.array_formula_offset(1,0); end def g270; @g270 ||= g269_array.array_formula_offset(1,0); end def h270; @h270 ||= h269_array.array_formula_offset(1,0); end def i270; @i270 ||= i269_array.array_formula_offset(1,0); end def j270; @j270 ||= j269_array.array_formula_offset(1,0); end def k270; @k270 ||= k269_array.array_formula_offset(1,0); end def l270; @l270 ||= l269_array.array_formula_offset(1,0); end def m270; @m270 ||= m269_array.array_formula_offset(1,0); end def n270; @n270 ||= n269_array.array_formula_offset(1,0); end def o270; @o270 ||= o269_array.array_formula_offset(1,0); end def c271; "CAR"; end def d271; "EV"; end def f271; @f271 ||= f269_array.array_formula_offset(2,0); end def g271; @g271 ||= g269_array.array_formula_offset(2,0); end def h271; @h271 ||= h269_array.array_formula_offset(2,0); end def i271; @i271 ||= i269_array.array_formula_offset(2,0); end def j271; @j271 ||= j269_array.array_formula_offset(2,0); end def k271; @k271 ||= k269_array.array_formula_offset(2,0); end def l271; @l271 ||= l269_array.array_formula_offset(2,0); end def m271; @m271 ||= m269_array.array_formula_offset(2,0); end def n271; @n271 ||= n269_array.array_formula_offset(2,0); end def o271; @o271 ||= o269_array.array_formula_offset(2,0); end def c272; "CAR"; end def d272; "FCV"; end def f272; @f272 ||= f269_array.array_formula_offset(3,0); end def g272; @g272 ||= g269_array.array_formula_offset(3,0); end def h272; @h272 ||= h269_array.array_formula_offset(3,0); end def i272; @i272 ||= i269_array.array_formula_offset(3,0); end def j272; @j272 ||= j269_array.array_formula_offset(3,0); end def k272; @k272 ||= k269_array.array_formula_offset(3,0); end def l272; @l272 ||= l269_array.array_formula_offset(3,0); end def m272; @m272 ||= m269_array.array_formula_offset(3,0); end def n272; @n272 ||= n269_array.array_formula_offset(3,0); end def o272; @o272 ||= o269_array.array_formula_offset(3,0); end def c273; "BUS"; end def d273; "ICE"; end def f273; @f273 ||= f269_array.array_formula_offset(4,0); end def g273; @g273 ||= g269_array.array_formula_offset(4,0); end def h273; @h273 ||= h269_array.array_formula_offset(4,0); end def i273; @i273 ||= i269_array.array_formula_offset(4,0); end def j273; @j273 ||= j269_array.array_formula_offset(4,0); end def k273; @k273 ||= k269_array.array_formula_offset(4,0); end def l273; @l273 ||= l269_array.array_formula_offset(4,0); end def m273; @m273 ||= m269_array.array_formula_offset(4,0); end def n273; @n273 ||= n269_array.array_formula_offset(4,0); end def o273; @o273 ||= o269_array.array_formula_offset(4,0); end def c274; "BUS"; end def d274; "HEV"; end def f274; @f274 ||= f269_array.array_formula_offset(5,0); end def g274; @g274 ||= g269_array.array_formula_offset(5,0); end def h274; @h274 ||= h269_array.array_formula_offset(5,0); end def i274; @i274 ||= i269_array.array_formula_offset(5,0); end def j274; @j274 ||= j269_array.array_formula_offset(5,0); end def k274; @k274 ||= k269_array.array_formula_offset(5,0); end def l274; @l274 ||= l269_array.array_formula_offset(5,0); end def m274; @m274 ||= m269_array.array_formula_offset(5,0); end def n274; @n274 ||= n269_array.array_formula_offset(5,0); end def o274; @o274 ||= o269_array.array_formula_offset(5,0); end def c275; "BUS"; end def d275; "EV"; end def f275; @f275 ||= f269_array.array_formula_offset(6,0); end def g275; @g275 ||= g269_array.array_formula_offset(6,0); end def h275; @h275 ||= h269_array.array_formula_offset(6,0); end def i275; @i275 ||= i269_array.array_formula_offset(6,0); end def j275; @j275 ||= j269_array.array_formula_offset(6,0); end def k275; @k275 ||= k269_array.array_formula_offset(6,0); end def l275; @l275 ||= l269_array.array_formula_offset(6,0); end def m275; @m275 ||= m269_array.array_formula_offset(6,0); end def n275; @n275 ||= n269_array.array_formula_offset(6,0); end def o275; @o275 ||= o269_array.array_formula_offset(6,0); end def c276; "BUS"; end def d276; "FCV"; end def f276; @f276 ||= f269_array.array_formula_offset(7,0); end def g276; @g276 ||= g269_array.array_formula_offset(7,0); end def h276; @h276 ||= h269_array.array_formula_offset(7,0); end def i276; @i276 ||= i269_array.array_formula_offset(7,0); end def j276; @j276 ||= j269_array.array_formula_offset(7,0); end def k276; @k276 ||= k269_array.array_formula_offset(7,0); end def l276; @l276 ||= l269_array.array_formula_offset(7,0); end def m276; @m276 ||= m269_array.array_formula_offset(7,0); end def n276; @n276 ||= n269_array.array_formula_offset(7,0); end def o276; @o276 ||= o269_array.array_formula_offset(7,0); end def c277; "RAIL"; end def d277; "DIESEL"; end def f277; @f277 ||= f269_array.array_formula_offset(8,0); end def g277; @g277 ||= g269_array.array_formula_offset(8,0); end def h277; @h277 ||= h269_array.array_formula_offset(8,0); end def i277; @i277 ||= i269_array.array_formula_offset(8,0); end def j277; @j277 ||= j269_array.array_formula_offset(8,0); end def k277; @k277 ||= k269_array.array_formula_offset(8,0); end def l277; @l277 ||= l269_array.array_formula_offset(8,0); end def m277; @m277 ||= m269_array.array_formula_offset(8,0); end def n277; @n277 ||= n269_array.array_formula_offset(8,0); end def o277; @o277 ||= o269_array.array_formula_offset(8,0); end def c278; "RAIL"; end def d278; "ELECTRIC"; end def f278; @f278 ||= f269_array.array_formula_offset(9,0); end def g278; @g278 ||= g269_array.array_formula_offset(9,0); end def h278; @h278 ||= h269_array.array_formula_offset(9,0); end def i278; @i278 ||= i269_array.array_formula_offset(9,0); end def j278; @j278 ||= j269_array.array_formula_offset(9,0); end def k278; @k278 ||= k269_array.array_formula_offset(9,0); end def l278; @l278 ||= l269_array.array_formula_offset(9,0); end def m278; @m278 ||= m269_array.array_formula_offset(9,0); end def n278; @n278 ||= n269_array.array_formula_offset(9,0); end def o278; @o278 ||= o269_array.array_formula_offset(9,0); end def c279; "AIR"; end def d279; "AIR"; end def f279; @f279 ||= f269_array.array_formula_offset(10,0); end def g279; @g279 ||= g269_array.array_formula_offset(10,0); end def h279; @h279 ||= h269_array.array_formula_offset(10,0); end def i279; @i279 ||= i269_array.array_formula_offset(10,0); end def j279; @j279 ||= j269_array.array_formula_offset(10,0); end def k279; @k279 ||= k269_array.array_formula_offset(10,0); end def l279; @l279 ||= l269_array.array_formula_offset(10,0); end def m279; @m279 ||= m269_array.array_formula_offset(10,0); end def n279; @n279 ||= n269_array.array_formula_offset(10,0); end def o279; @o279 ||= o269_array.array_formula_offset(10,0); end def f280; @f280 ||= sum(a('f269','f279')); end def g280; @g280 ||= sum(a('g269','g279')); end def h280; @h280 ||= sum(a('h269','h279')); end def i280; @i280 ||= sum(a('i269','i279')); end def j280; @j280 ||= sum(a('j269','j279')); end def k280; @k280 ||= sum(a('k269','k279')); end def l280; @l280 ||= sum(a('l269','l279')); end def m280; @m280 ||= sum(a('m269','m279')); end def n280; @n280 ||= sum(a('n269','n279')); end def o280; @o280 ||= sum(a('o269','o279')); end def c284; "CAR"; end def d284; "ICE"; end def f284_array; @f284_array ||= m(a('f253','f263'),m(a('c284','c294'),a('d284','d294')) { |r1,r2| sumifs(a('f206','f209'),a('c206','c209'),r1,a('d206','d209'),r2) }) { |r1,r2| r1*r2 }; end def f284; @f284 ||= f284_array.array_formula_offset(0,0); end def g284_array; @g284_array ||= m(a('g253','g263'),m(a('c284','c294'),a('d284','d294')) { |r1,r2| sumifs(a('g206','g209'),a('c206','c209'),r1,a('d206','d209'),r2) }) { |r1,r2| r1*r2 }; end def g284; @g284 ||= g284_array.array_formula_offset(0,0); end def h284_array; @h284_array ||= m(a('h253','h263'),m(a('c284','c294'),a('d284','d294')) { |r1,r2| sumifs(a('h206','h209'),a('c206','c209'),r1,a('d206','d209'),r2) }) { |r1,r2| r1*r2 }; end def h284; @h284 ||= h284_array.array_formula_offset(0,0); end def i284_array; @i284_array ||= m(a('i253','i263'),m(a('c284','c294'),a('d284','d294')) { |r1,r2| sumifs(a('i206','i209'),a('c206','c209'),r1,a('d206','d209'),r2) }) { |r1,r2| r1*r2 }; end def i284; @i284 ||= i284_array.array_formula_offset(0,0); end def j284_array; @j284_array ||= m(a('j253','j263'),m(a('c284','c294'),a('d284','d294')) { |r1,r2| sumifs(a('j206','j209'),a('c206','c209'),r1,a('d206','d209'),r2) }) { |r1,r2| r1*r2 }; end def j284; @j284 ||= j284_array.array_formula_offset(0,0); end def k284_array; @k284_array ||= m(a('k253','k263'),m(a('c284','c294'),a('d284','d294')) { |r1,r2| sumifs(a('k206','k209'),a('c206','c209'),r1,a('d206','d209'),r2) }) { |r1,r2| r1*r2 }; end def k284; @k284 ||= k284_array.array_formula_offset(0,0); end def l284_array; @l284_array ||= m(a('l253','l263'),m(a('c284','c294'),a('d284','d294')) { |r1,r2| sumifs(a('l206','l209'),a('c206','c209'),r1,a('d206','d209'),r2) }) { |r1,r2| r1*r2 }; end def l284; @l284 ||= l284_array.array_formula_offset(0,0); end def m284_array; @m284_array ||= m(a('m253','m263'),m(a('c284','c294'),a('d284','d294')) { |r1,r2| sumifs(a('m206','m209'),a('c206','c209'),r1,a('d206','d209'),r2) }) { |r1,r2| r1*r2 }; end def m284; @m284 ||= m284_array.array_formula_offset(0,0); end def n284_array; @n284_array ||= m(a('n253','n263'),m(a('c284','c294'),a('d284','d294')) { |r1,r2| sumifs(a('n206','n209'),a('c206','c209'),r1,a('d206','d209'),r2) }) { |r1,r2| r1*r2 }; end def n284; @n284 ||= n284_array.array_formula_offset(0,0); end def o284_array; @o284_array ||= m(a('o253','o263'),m(a('c284','c294'),a('d284','d294')) { |r1,r2| sumifs(a('o206','o209'),a('c206','c209'),r1,a('d206','d209'),r2) }) { |r1,r2| r1*r2 }; end def o284; @o284 ||= o284_array.array_formula_offset(0,0); end def c285; "CAR"; end def d285; "PHEV"; end def f285; @f285 ||= f284_array.array_formula_offset(1,0); end def g285; @g285 ||= g284_array.array_formula_offset(1,0); end def h285; @h285 ||= h284_array.array_formula_offset(1,0); end def i285; @i285 ||= i284_array.array_formula_offset(1,0); end def j285; @j285 ||= j284_array.array_formula_offset(1,0); end def k285; @k285 ||= k284_array.array_formula_offset(1,0); end def l285; @l285 ||= l284_array.array_formula_offset(1,0); end def m285; @m285 ||= m284_array.array_formula_offset(1,0); end def n285; @n285 ||= n284_array.array_formula_offset(1,0); end def o285; @o285 ||= o284_array.array_formula_offset(1,0); end def c286; "CAR"; end def d286; "EV"; end def f286; @f286 ||= f284_array.array_formula_offset(2,0); end def g286; @g286 ||= g284_array.array_formula_offset(2,0); end def h286; @h286 ||= h284_array.array_formula_offset(2,0); end def i286; @i286 ||= i284_array.array_formula_offset(2,0); end def j286; @j286 ||= j284_array.array_formula_offset(2,0); end def k286; @k286 ||= k284_array.array_formula_offset(2,0); end def l286; @l286 ||= l284_array.array_formula_offset(2,0); end def m286; @m286 ||= m284_array.array_formula_offset(2,0); end def n286; @n286 ||= n284_array.array_formula_offset(2,0); end def o286; @o286 ||= o284_array.array_formula_offset(2,0); end def c287; "CAR"; end def d287; "FCV"; end def f287; @f287 ||= f284_array.array_formula_offset(3,0); end def g287; @g287 ||= g284_array.array_formula_offset(3,0); end def h287; @h287 ||= h284_array.array_formula_offset(3,0); end def i287; @i287 ||= i284_array.array_formula_offset(3,0); end def j287; @j287 ||= j284_array.array_formula_offset(3,0); end def k287; @k287 ||= k284_array.array_formula_offset(3,0); end def l287; @l287 ||= l284_array.array_formula_offset(3,0); end def m287; @m287 ||= m284_array.array_formula_offset(3,0); end def n287; @n287 ||= n284_array.array_formula_offset(3,0); end def o287; @o287 ||= o284_array.array_formula_offset(3,0); end def c288; "BUS"; end def d288; "ICE"; end def f288; @f288 ||= f284_array.array_formula_offset(4,0); end def g288; @g288 ||= g284_array.array_formula_offset(4,0); end def h288; @h288 ||= h284_array.array_formula_offset(4,0); end def i288; @i288 ||= i284_array.array_formula_offset(4,0); end def j288; @j288 ||= j284_array.array_formula_offset(4,0); end def k288; @k288 ||= k284_array.array_formula_offset(4,0); end def l288; @l288 ||= l284_array.array_formula_offset(4,0); end def m288; @m288 ||= m284_array.array_formula_offset(4,0); end def n288; @n288 ||= n284_array.array_formula_offset(4,0); end def o288; @o288 ||= o284_array.array_formula_offset(4,0); end def c289; "BUS"; end def d289; "HEV"; end def f289; @f289 ||= f284_array.array_formula_offset(5,0); end def g289; @g289 ||= g284_array.array_formula_offset(5,0); end def h289; @h289 ||= h284_array.array_formula_offset(5,0); end def i289; @i289 ||= i284_array.array_formula_offset(5,0); end def j289; @j289 ||= j284_array.array_formula_offset(5,0); end def k289; @k289 ||= k284_array.array_formula_offset(5,0); end def l289; @l289 ||= l284_array.array_formula_offset(5,0); end def m289; @m289 ||= m284_array.array_formula_offset(5,0); end def n289; @n289 ||= n284_array.array_formula_offset(5,0); end def o289; @o289 ||= o284_array.array_formula_offset(5,0); end def c290; "BUS"; end def d290; "EV"; end def f290; @f290 ||= f284_array.array_formula_offset(6,0); end def g290; @g290 ||= g284_array.array_formula_offset(6,0); end def h290; @h290 ||= h284_array.array_formula_offset(6,0); end def i290; @i290 ||= i284_array.array_formula_offset(6,0); end def j290; @j290 ||= j284_array.array_formula_offset(6,0); end def k290; @k290 ||= k284_array.array_formula_offset(6,0); end def l290; @l290 ||= l284_array.array_formula_offset(6,0); end def m290; @m290 ||= m284_array.array_formula_offset(6,0); end def n290; @n290 ||= n284_array.array_formula_offset(6,0); end def o290; @o290 ||= o284_array.array_formula_offset(6,0); end def c291; "BUS"; end def d291; "FCV"; end def f291; @f291 ||= f284_array.array_formula_offset(7,0); end def g291; @g291 ||= g284_array.array_formula_offset(7,0); end def h291; @h291 ||= h284_array.array_formula_offset(7,0); end def i291; @i291 ||= i284_array.array_formula_offset(7,0); end def j291; @j291 ||= j284_array.array_formula_offset(7,0); end def k291; @k291 ||= k284_array.array_formula_offset(7,0); end def l291; @l291 ||= l284_array.array_formula_offset(7,0); end def m291; @m291 ||= m284_array.array_formula_offset(7,0); end def n291; @n291 ||= n284_array.array_formula_offset(7,0); end def o291; @o291 ||= o284_array.array_formula_offset(7,0); end def c292; "RAIL"; end def d292; "DIESEL"; end def f292; @f292 ||= f284_array.array_formula_offset(8,0); end def g292; @g292 ||= g284_array.array_formula_offset(8,0); end def h292; @h292 ||= h284_array.array_formula_offset(8,0); end def i292; @i292 ||= i284_array.array_formula_offset(8,0); end def j292; @j292 ||= j284_array.array_formula_offset(8,0); end def k292; @k292 ||= k284_array.array_formula_offset(8,0); end def l292; @l292 ||= l284_array.array_formula_offset(8,0); end def m292; @m292 ||= m284_array.array_formula_offset(8,0); end def n292; @n292 ||= n284_array.array_formula_offset(8,0); end def o292; @o292 ||= o284_array.array_formula_offset(8,0); end def c293; "RAIL"; end def d293; "ELECTRIC"; end def f293; @f293 ||= f284_array.array_formula_offset(9,0); end def g293; @g293 ||= g284_array.array_formula_offset(9,0); end def h293; @h293 ||= h284_array.array_formula_offset(9,0); end def i293; @i293 ||= i284_array.array_formula_offset(9,0); end def j293; @j293 ||= j284_array.array_formula_offset(9,0); end def k293; @k293 ||= k284_array.array_formula_offset(9,0); end def l293; @l293 ||= l284_array.array_formula_offset(9,0); end def m293; @m293 ||= m284_array.array_formula_offset(9,0); end def n293; @n293 ||= n284_array.array_formula_offset(9,0); end def o293; @o293 ||= o284_array.array_formula_offset(9,0); end def c294; "AIR"; end def d294; "AIR"; end def f294; @f294 ||= f284_array.array_formula_offset(10,0); end def g294; @g294 ||= g284_array.array_formula_offset(10,0); end def h294; @h294 ||= h284_array.array_formula_offset(10,0); end def i294; @i294 ||= i284_array.array_formula_offset(10,0); end def j294; @j294 ||= j284_array.array_formula_offset(10,0); end def k294; @k294 ||= k284_array.array_formula_offset(10,0); end def l294; @l294 ||= l284_array.array_formula_offset(10,0); end def m294; @m294 ||= m284_array.array_formula_offset(10,0); end def n294; @n294 ||= n284_array.array_formula_offset(10,0); end def o294; @o294 ||= o284_array.array_formula_offset(10,0); end def f295; @f295 ||= sum(a('f284','f294')); end def g295; @g295 ||= sum(a('g284','g294')); end def h295; @h295 ||= sum(a('h284','h294')); end def i295; @i295 ||= sum(a('i284','i294')); end def j295; @j295 ||= sum(a('j284','j294')); end def k295; @k295 ||= sum(a('k284','k294')); end def l295; @l295 ||= sum(a('l284','l294')); end def m295; @m295 ||= sum(a('m284','m294')); end def n295; @n295 ||= sum(a('n284','n294')); end def o295; @o295 ||= sum(a('o284','o294')); end def c299; "CAR"; end def d299; "ICE"; end def f299_array; @f299_array ||= m(a('f253','o263'),m(a('c299','c309'),a('d299','d309')) { |r1,r2| sumifs(a('o214','o215'),a('c214','c215'),r1,a('d214','d215'),r2) }) { |r1,r2| r1*r2 }; end def f299; @f299 ||= f299_array.array_formula_offset(0,0); end def g299; @g299 ||= f299_array.array_formula_offset(0,1); end def h299; @h299 ||= f299_array.array_formula_offset(0,2); end def i299; @i299 ||= f299_array.array_formula_offset(0,3); end def j299; @j299 ||= f299_array.array_formula_offset(0,4); end def k299; @k299 ||= f299_array.array_formula_offset(0,5); end def l299; @l299 ||= f299_array.array_formula_offset(0,6); end def m299; @m299 ||= f299_array.array_formula_offset(0,7); end def n299; @n299 ||= f299_array.array_formula_offset(0,8); end def o299; @o299 ||= f299_array.array_formula_offset(0,9); end def c300; "CAR"; end def d300; "PHEV"; end def f300; @f300 ||= f299_array.array_formula_offset(1,0); end def g300; @g300 ||= f299_array.array_formula_offset(1,1); end def h300; @h300 ||= f299_array.array_formula_offset(1,2); end def i300; @i300 ||= f299_array.array_formula_offset(1,3); end def j300; @j300 ||= f299_array.array_formula_offset(1,4); end def k300; @k300 ||= f299_array.array_formula_offset(1,5); end def l300; @l300 ||= f299_array.array_formula_offset(1,6); end def m300; @m300 ||= f299_array.array_formula_offset(1,7); end def n300; @n300 ||= f299_array.array_formula_offset(1,8); end def o300; @o300 ||= f299_array.array_formula_offset(1,9); end def c301; "CAR"; end def d301; "EV"; end def f301; @f301 ||= f299_array.array_formula_offset(2,0); end def g301; @g301 ||= f299_array.array_formula_offset(2,1); end def h301; @h301 ||= f299_array.array_formula_offset(2,2); end def i301; @i301 ||= f299_array.array_formula_offset(2,3); end def j301; @j301 ||= f299_array.array_formula_offset(2,4); end def k301; @k301 ||= f299_array.array_formula_offset(2,5); end def l301; @l301 ||= f299_array.array_formula_offset(2,6); end def m301; @m301 ||= f299_array.array_formula_offset(2,7); end def n301; @n301 ||= f299_array.array_formula_offset(2,8); end def o301; @o301 ||= f299_array.array_formula_offset(2,9); end def c302; "CAR"; end def d302; "FCV"; end def f302; @f302 ||= f299_array.array_formula_offset(3,0); end def g302; @g302 ||= f299_array.array_formula_offset(3,1); end def h302; @h302 ||= f299_array.array_formula_offset(3,2); end def i302; @i302 ||= f299_array.array_formula_offset(3,3); end def j302; @j302 ||= f299_array.array_formula_offset(3,4); end def k302; @k302 ||= f299_array.array_formula_offset(3,5); end def l302; @l302 ||= f299_array.array_formula_offset(3,6); end def m302; @m302 ||= f299_array.array_formula_offset(3,7); end def n302; @n302 ||= f299_array.array_formula_offset(3,8); end def o302; @o302 ||= f299_array.array_formula_offset(3,9); end def c303; "BUS"; end def d303; "ICE"; end def f303; @f303 ||= f299_array.array_formula_offset(4,0); end def g303; @g303 ||= f299_array.array_formula_offset(4,1); end def h303; @h303 ||= f299_array.array_formula_offset(4,2); end def i303; @i303 ||= f299_array.array_formula_offset(4,3); end def j303; @j303 ||= f299_array.array_formula_offset(4,4); end def k303; @k303 ||= f299_array.array_formula_offset(4,5); end def l303; @l303 ||= f299_array.array_formula_offset(4,6); end def m303; @m303 ||= f299_array.array_formula_offset(4,7); end def n303; @n303 ||= f299_array.array_formula_offset(4,8); end def o303; @o303 ||= f299_array.array_formula_offset(4,9); end def c304; "BUS"; end def d304; "HEV"; end def f304; @f304 ||= f299_array.array_formula_offset(5,0); end def g304; @g304 ||= f299_array.array_formula_offset(5,1); end def h304; @h304 ||= f299_array.array_formula_offset(5,2); end def i304; @i304 ||= f299_array.array_formula_offset(5,3); end def j304; @j304 ||= f299_array.array_formula_offset(5,4); end def k304; @k304 ||= f299_array.array_formula_offset(5,5); end def l304; @l304 ||= f299_array.array_formula_offset(5,6); end def m304; @m304 ||= f299_array.array_formula_offset(5,7); end def n304; @n304 ||= f299_array.array_formula_offset(5,8); end def o304; @o304 ||= f299_array.array_formula_offset(5,9); end def c305; "BUS"; end def d305; "EV"; end def f305; @f305 ||= f299_array.array_formula_offset(6,0); end def g305; @g305 ||= f299_array.array_formula_offset(6,1); end def h305; @h305 ||= f299_array.array_formula_offset(6,2); end def i305; @i305 ||= f299_array.array_formula_offset(6,3); end def j305; @j305 ||= f299_array.array_formula_offset(6,4); end def k305; @k305 ||= f299_array.array_formula_offset(6,5); end def l305; @l305 ||= f299_array.array_formula_offset(6,6); end def m305; @m305 ||= f299_array.array_formula_offset(6,7); end def n305; @n305 ||= f299_array.array_formula_offset(6,8); end def o305; @o305 ||= f299_array.array_formula_offset(6,9); end def c306; "BUS"; end def d306; "FCV"; end def f306; @f306 ||= f299_array.array_formula_offset(7,0); end def g306; @g306 ||= f299_array.array_formula_offset(7,1); end def h306; @h306 ||= f299_array.array_formula_offset(7,2); end def i306; @i306 ||= f299_array.array_formula_offset(7,3); end def j306; @j306 ||= f299_array.array_formula_offset(7,4); end def k306; @k306 ||= f299_array.array_formula_offset(7,5); end def l306; @l306 ||= f299_array.array_formula_offset(7,6); end def m306; @m306 ||= f299_array.array_formula_offset(7,7); end def n306; @n306 ||= f299_array.array_formula_offset(7,8); end def o306; @o306 ||= f299_array.array_formula_offset(7,9); end def c307; "RAIL"; end def d307; "DIESEL"; end def f307; @f307 ||= f299_array.array_formula_offset(8,0); end def g307; @g307 ||= f299_array.array_formula_offset(8,1); end def h307; @h307 ||= f299_array.array_formula_offset(8,2); end def i307; @i307 ||= f299_array.array_formula_offset(8,3); end def j307; @j307 ||= f299_array.array_formula_offset(8,4); end def k307; @k307 ||= f299_array.array_formula_offset(8,5); end def l307; @l307 ||= f299_array.array_formula_offset(8,6); end def m307; @m307 ||= f299_array.array_formula_offset(8,7); end def n307; @n307 ||= f299_array.array_formula_offset(8,8); end def o307; @o307 ||= f299_array.array_formula_offset(8,9); end def c308; "RAIL"; end def d308; "ELECTRIC"; end def f308; @f308 ||= f299_array.array_formula_offset(9,0); end def g308; @g308 ||= f299_array.array_formula_offset(9,1); end def h308; @h308 ||= f299_array.array_formula_offset(9,2); end def i308; @i308 ||= f299_array.array_formula_offset(9,3); end def j308; @j308 ||= f299_array.array_formula_offset(9,4); end def k308; @k308 ||= f299_array.array_formula_offset(9,5); end def l308; @l308 ||= f299_array.array_formula_offset(9,6); end def m308; @m308 ||= f299_array.array_formula_offset(9,7); end def n308; @n308 ||= f299_array.array_formula_offset(9,8); end def o308; @o308 ||= f299_array.array_formula_offset(9,9); end def c309; "AIR"; end def d309; "AIR"; end def f309; @f309 ||= f299_array.array_formula_offset(10,0); end def g309; @g309 ||= f299_array.array_formula_offset(10,1); end def h309; @h309 ||= f299_array.array_formula_offset(10,2); end def i309; @i309 ||= f299_array.array_formula_offset(10,3); end def j309; @j309 ||= f299_array.array_formula_offset(10,4); end def k309; @k309 ||= f299_array.array_formula_offset(10,5); end def l309; @l309 ||= f299_array.array_formula_offset(10,6); end def m309; @m309 ||= f299_array.array_formula_offset(10,7); end def n309; @n309 ||= f299_array.array_formula_offset(10,8); end def o309; @o309 ||= f299_array.array_formula_offset(10,9); end def f310; @f310 ||= sum(a('f299','f309')); end def g310; @g310 ||= sum(a('g299','g309')); end def h310; @h310 ||= sum(a('h299','h309')); end def i310; @i310 ||= sum(a('i299','i309')); end def j310; @j310 ||= sum(a('j299','j309')); end def k310; @k310 ||= sum(a('k299','k309')); end def l310; @l310 ||= sum(a('l299','l309')); end def m310; @m310 ||= sum(a('m299','m309')); end def n310; @n310 ||= sum(a('n299','n309')); end def o310; @o310 ||= sum(a('o299','o309')); end def f314; @f314 ||= sum(a('f269','f276'))+sum(a('f284','f291'))+sum(a('f299','f306')); end def g314; @g314 ||= sum(a('g269','g276'))+sum(a('g284','g291'))+sum(a('g299','g306')); end def h314; @h314 ||= sum(a('h269','h276'))+sum(a('h284','h291'))+sum(a('h299','h306')); end def i314; @i314 ||= sum(a('i269','i276'))+sum(a('i284','i291'))+sum(a('i299','i306')); end def j314; @j314 ||= sum(a('j269','j276'))+sum(a('j284','j291'))+sum(a('j299','j306')); end def k314; @k314 ||= sum(a('k269','k276'))+sum(a('k284','k291'))+sum(a('k299','k306')); end def l314; @l314 ||= sum(a('l269','l276'))+sum(a('l284','l291'))+sum(a('l299','l306')); end def m314; @m314 ||= sum(a('m269','m276'))+sum(a('m284','m291'))+sum(a('m299','m306')); end def n314; @n314 ||= sum(a('n269','n276'))+sum(a('n284','n291'))+sum(a('n299','n306')); end def o314; @o314 ||= sum(a('o269','o276'))+sum(a('o284','o291'))+sum(a('o299','o306')); end def f315; @f315 ||= sum(a('f277','f278'))+sum(a('f292','f293'))+sum(a('f307','f308')); end def g315; @g315 ||= sum(a('g277','g278'))+sum(a('g292','g293'))+sum(a('g307','g308')); end def h315; @h315 ||= sum(a('h277','h278'))+sum(a('h292','h293'))+sum(a('h307','h308')); end def i315; @i315 ||= sum(a('i277','i278'))+sum(a('i292','i293'))+sum(a('i307','i308')); end def j315; @j315 ||= sum(a('j277','j278'))+sum(a('j292','j293'))+sum(a('j307','j308')); end def k315; @k315 ||= sum(a('k277','k278'))+sum(a('k292','k293'))+sum(a('k307','k308')); end def l315; @l315 ||= sum(a('l277','l278'))+sum(a('l292','l293'))+sum(a('l307','l308')); end def m315; @m315 ||= sum(a('m277','m278'))+sum(a('m292','m293'))+sum(a('m307','m308')); end def n315; @n315 ||= sum(a('n277','n278'))+sum(a('n292','n293'))+sum(a('n307','n308')); end def o315; @o315 ||= sum(a('o277','o278'))+sum(a('o292','o293'))+sum(a('o307','o308')); end def f316; @f316 ||= f279+f294+f309; end def g316; @g316 ||= g279+g294+g309; end def h316; @h316 ||= h279+h294+h309; end def i316; @i316 ||= i279+i294+i309; end def j316; @j316 ||= j279+j294+j309; end def k316; @k316 ||= k279+k294+k309; end def l316; @l316 ||= l279+l294+l309; end def m316; @m316 ||= m279+m294+m309; end def n316; @n316 ||= n279+n294+n309; end def o316; @o316 ||= o279+o294+o309; end def f320; @f320 ||= f280*sheet12.d43; end def g320; @g320 ||= g280*sheet12.d43; end def h320; @h320 ||= h280*sheet12.d43; end def i320; @i320 ||= i280*sheet12.d43; end def j320; @j320 ||= j280*sheet12.d43; end def k320; @k320 ||= k280*sheet12.d43; end def l320; @l320 ||= l280*sheet12.d43; end def m320; @m320 ||= m280*sheet12.d43; end def n320; @n320 ||= n280*sheet12.d43; end def o320; @o320 ||= o280*sheet12.d43; end def f321; @f321 ||= f280*sheet12.e43; end def g321; @g321 ||= g280*sheet12.e43; end def h321; @h321 ||= h280*sheet12.e43; end def i321; @i321 ||= i280*sheet12.e43; end def j321; @j321 ||= j280*sheet12.e43; end def k321; @k321 ||= k280*sheet12.e43; end def l321; @l321 ||= l280*sheet12.e43; end def m321; @m321 ||= m280*sheet12.e43; end def n321; @n321 ||= n280*sheet12.e43; end def o321; @o321 ||= o280*sheet12.e43; end def f322; @f322 ||= f280*sheet12.f43; end def g322; @g322 ||= g280*sheet12.f43; end def h322; @h322 ||= h280*sheet12.f43; end def i322; @i322 ||= i280*sheet12.f43; end def j322; @j322 ||= j280*sheet12.f43; end def k322; @k322 ||= k280*sheet12.f43; end def l322; @l322 ||= l280*sheet12.f43; end def m322; @m322 ||= m280*sheet12.f43; end def n322; @n322 ||= n280*sheet12.f43; end def o322; @o322 ||= o280*sheet12.f43; end def c331; "T.01"; end def f331; @f331 ||= f314; end def g331; @g331 ||= g314; end def h331; @h331 ||= h314; end def i331; @i331 ||= i314; end def j331; @j331 ||= j314; end def k331; @k331 ||= k314; end def l331; @l331 ||= l314; end def m331; @m331 ||= m314; end def n331; @n331 ||= n314; end def o331; @o331 ||= o314; end def c332; "T.02"; end def f332; @f332 ||= f315+f144; end def g332; @g332 ||= g315+g144; end def h332; @h332 ||= h315+h144; end def i332; @i332 ||= i315+i144; end def j332; @j332 ||= j315+j144; end def k332; @k332 ||= k315+k144; end def l332; @l332 ||= l315+l144; end def m332; @m332 ||= m315+m144; end def n332; @n332 ||= n315+n144; end def o332; @o332 ||= o315+o144; end def c333; "T.03"; end def f333; @f333 ||= f316; end def g333; @g333 ||= g316; end def h333; @h333 ||= h316; end def i333; @i333 ||= i316; end def j333; @j333 ||= j316; end def k333; @k333 ||= k316; end def l333; @l333 ||= l316; end def m333; @m333 ||= m316; end def n333; @n333 ||= n316; end def o333; @o333 ||= o316; end def c334; "V.04"; end def f334; @f334 ||= -f280; end def g334; @g334 ||= -g280; end def h334; @h334 ||= -h280; end def i334; @i334 ||= -i280; end def j334; @j334 ||= -j280; end def k334; @k334 ||= -k280; end def l334; @l334 ||= -l280; end def m334; @m334 ||= -m280; end def n334; @n334 ||= -n280; end def o334; @o334 ||= -o280; end def c335; "V.01"; end def f335; @f335 ||= -f295-f144; end def g335; @g335 ||= -g295-g144; end def h335; @h335 ||= -h295-h144; end def i335; @i335 ||= -i295-i144; end def j335; @j335 ||= -j295-j144; end def k335; @k335 ||= -k295-k144; end def l335; @l335 ||= -l295-l144; end def m335; @m335 ||= -m295-m144; end def n335; @n335 ||= -n295-n144; end def o335; @o335 ||= -o295-o144; end def c336; "V.12"; end def f336; @f336 ||= -f310; end def g336; @g336 ||= -g310; end def h336; @h336 ||= -h310; end def i336; @i336 ||= -i310; end def j336; @j336 ||= -j310; end def k336; @k336 ||= -k310; end def l336; @l336 ||= -l310; end def m336; @m336 ||= -m310; end def n336; @n336 ||= -n310; end def o336; @o336 ||= -o310; end def o343; @o343 ||= -sum(a('o269','o276')); end def o344; @o344 ||= -sum(a('o284','o291')); end def o345; @o345 ||= -sum(a('o299','o306')); end def o352; @o352 ||= -sum(a('o277','o278')); end def o353; @o353 ||= -(sum(a('o292','o293'))+o144); end def o361; @o361 ||= -o279; end def c372; "CO2"; end def d372; "1A"; end def f372; @f372 ||= f320; end def g372; @g372 ||= g320; end def h372; @h372 ||= h320; end def i372; @i372 ||= i320; end def j372; @j372 ||= j320; end def k372; @k372 ||= k320; end def l372; @l372 ||= l320; end def m372; @m372 ||= m320; end def n372; @n372 ||= n320; end def o372; @o372 ||= o320; end def c373; "CH4"; end def d373; "1A"; end def f373; @f373 ||= f321; end def g373; @g373 ||= g321; end def h373; @h373 ||= h321; end def i373; @i373 ||= i321; end def j373; @j373 ||= j321; end def k373; @k373 ||= k321; end def l373; @l373 ||= l321; end def m373; @m373 ||= m321; end def n373; @n373 ||= n321; end def o373; @o373 ||= o321; end def c374; "N2O"; end def d374; "1A"; end def f374; @f374 ||= f322; end def g374; @g374 ||= g322; end def h374; @h374 ||= h322; end def i374; @i374 ||= i322; end def j374; @j374 ||= j322; end def k374; @k374 ||= k322; end def l374; @l374 ||= l322; end def m374; @m374 ||= m322; end def n374; @n374 ||= n322; end def o374; @o374 ||= o322; end def balancing_shiftable_capacity; sheet43.a('f285','o286'); end end