# coding: utf-8 # XII.a class Sheet44 < Spreadsheet def e8; @e8 ||= sheet5.ab28; end def e9; @e9 ||= sheet5.ab29; 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/sheet44.g188; end def h196; @h196 ||= h120/sheet44.h188; end def i196; @i196 ||= i120/sheet44.i188; end def j196; @j196 ||= j120/sheet44.j188; end def k196; @k196 ||= k120/sheet44.k188; end def l196; @l196 ||= l120/sheet44.l188; end def m196; @m196 ||= m120/sheet44.m188; end def n196; @n196 ||= n120/sheet44.n188; end def o196; @o196 ||= o120/sheet44.o188; end def c197; "CAR"; end def d197; "PHEV"; end def g197; @g197 ||= g121/sheet44.g188; end def h197; @h197 ||= h121/sheet44.h188; end def i197; @i197 ||= i121/sheet44.i188; end def j197; @j197 ||= j121/sheet44.j188; end def k197; @k197 ||= k121/sheet44.k188; end def l197; @l197 ||= l121/sheet44.l188; end def m197; @m197 ||= m121/sheet44.m188; end def n197; @n197 ||= n121/sheet44.n188; end def o197; @o197 ||= o121/sheet44.o188; end def c198; "BUS"; end def d198; "ICE"; end def f198; 0.239492423538389; end def g198; @g198 ||= g122/sheet44.g189; end def h198; @h198 ||= h122/sheet44.h189; end def i198; @i198 ||= i122/sheet44.i189; end def j198; @j198 ||= j122/sheet44.j189; end def k198; @k198 ||= k122/sheet44.k189; end def l198; @l198 ||= l122/sheet44.l189; end def m198; @m198 ||= m122/sheet44.m189; end def n198; @n198 ||= n122/sheet44.n189; end def o198; @o198 ||= o122/sheet44.o189; end def c199; "BUS"; end def d199; "HEV"; end def g199; @g199 ||= g123/sheet44.g189; end def h199; @h199 ||= h123/sheet44.h189; end def i199; @i199 ||= i123/sheet44.i189; end def j199; @j199 ||= j123/sheet44.j189; end def k199; @k199 ||= k123/sheet44.k189; end def l199; @l199 ||= l123/sheet44.l189; end def m199; @m199 ||= m123/sheet44.m189; end def n199; @n199 ||= n123/sheet44.n189; end def o199; @o199 ||= o123/sheet44.o189; end def c200; "RAIL"; end def d200; "DIESEL"; end def f200; 0.23040647569418302; end def g200; @g200 ||= g124/sheet44.g190; end def h200; @h200 ||= h124/sheet44.h190; end def i200; @i200 ||= i124/sheet44.i190; end def j200; @j200 ||= j124/sheet44.j190; end def k200; @k200 ||= k124/sheet44.k190; end def l200; @l200 ||= l124/sheet44.l190; end def m200; @m200 ||= m124/sheet44.m190; end def n200; @n200 ||= n124/sheet44.n190; end def o200; @o200 ||= o124/sheet44.o190; end def c201; "AIR"; end def d201; "AIR"; end def f201; 0.9194414607948442; end def g201; @g201 ||= g125/sheet44.g191; end def h201; @h201 ||= h125/sheet44.h191; end def i201; @i201 ||= i125/sheet44.i191; end def j201; @j201 ||= j125/sheet44.j191; end def k201; @k201 ||= k125/sheet44.k191; end def l201; @l201 ||= l125/sheet44.l191; end def m201; @m201 ||= m125/sheet44.m191; end def n201; @n201 ||= n125/sheet44.n191; end def o201; @o201 ||= o125/sheet44.o191; end def c206; "CAR"; end def d206; "PHEV"; end def g206; @g206 ||= g130/sheet44.g188; end def h206; @h206 ||= h130/sheet44.h188; end def i206; @i206 ||= i130/sheet44.i188; end def j206; @j206 ||= j130/sheet44.j188; end def k206; @k206 ||= k130/sheet44.k188; end def l206; @l206 ||= l130/sheet44.l188; end def m206; @m206 ||= m130/sheet44.m188; end def n206; @n206 ||= n130/sheet44.n188; end def o206; @o206 ||= o130/sheet44.o188; end def c207; "CAR"; end def d207; "EV"; end def g207; @g207 ||= g131/sheet44.g188; end def h207; @h207 ||= h131/sheet44.h188; end def i207; @i207 ||= i131/sheet44.i188; end def j207; @j207 ||= j131/sheet44.j188; end def k207; @k207 ||= k131/sheet44.k188; end def l207; @l207 ||= l131/sheet44.l188; end def m207; @m207 ||= m131/sheet44.m188; end def n207; @n207 ||= n131/sheet44.n188; end def o207; @o207 ||= o131/sheet44.o188; end def c208; "BUS"; end def d208; "EV"; end def g208; @g208 ||= g132/sheet44.g189; end def h208; @h208 ||= h132/sheet44.h189; end def i208; @i208 ||= i132/sheet44.i189; end def j208; @j208 ||= j132/sheet44.j189; end def k208; @k208 ||= k132/sheet44.k189; end def l208; @l208 ||= l132/sheet44.l189; end def m208; @m208 ||= m132/sheet44.m189; end def n208; @n208 ||= n132/sheet44.n189; end def o208; @o208 ||= o132/sheet44.o189; end def c209; "RAIL"; end def d209; "ELECTRIC"; end def f209; 0.10954818290623002; end def g209; @g209 ||= g133/sheet44.g190; end def h209; @h209 ||= h133/sheet44.h190; end def i209; @i209 ||= i133/sheet44.i190; end def j209; @j209 ||= j133/sheet44.j190; end def k209; @k209 ||= k133/sheet44.k190; end def l209; @l209 ||= l133/sheet44.l190; end def m209; @m209 ||= m133/sheet44.m190; end def n209; @n209 ||= n133/sheet44.n190; end def o209; @o209 ||= o133/sheet44.o190; end def c214; "CAR"; end def d214; "FCV"; end def o214; @o214 ||= o138/sheet44.o188; end def c215; "BUS"; end def d215; "FCV"; end def o215; @o215 ||= o139/sheet44.o189; end def f283; @f283 ||= index(a('f17','f20'),match(e8,a('c17','c20'),0.0)); end def g283; @g283 ||= index(a('g17','g20'),match(e8,a('c17','c20'),0.0)); end def h283; @h283 ||= index(a('h17','h20'),match(e8,a('c17','c20'),0.0)); end def i283; @i283 ||= index(a('i17','i20'),match(e8,a('c17','c20'),0.0)); end def j283; @j283 ||= index(a('j17','j20'),match(e8,a('c17','c20'),0.0)); end def k283; @k283 ||= index(a('k17','k20'),match(e8,a('c17','c20'),0.0)); end def l283; @l283 ||= index(a('l17','l20'),match(e8,a('c17','c20'),0.0)); end def m283; @m283 ||= index(a('m17','m20'),match(e8,a('c17','c20'),0.0)); end def n283; @n283 ||= index(a('n17','n20'),match(e8,a('c17','c20'),0.0)); end def o283; @o283 ||= index(a('o17','o20'),match(e8,a('c17','c20'),0.0)); end def f284; 60.973; end def g284; 62.222403; end def h284; 64.344156; end def i284; 66.521962; end def j284; 68.647528; end def k284; 70.575666; end def l284; 72.27823000000002; end def m284; 73.853253; end def n284; 75.356458; end def o284; 76.789483; end def f285; @f285 ||= f283*f284/1000.0; end def g285; @g285 ||= g283*g284/1000.0; end def h285; @h285 ||= h283*h284/1000.0; end def i285; @i285 ||= i283*i284/1000.0; end def j285; @j285 ||= j283*j284/1000.0; end def k285; @k285 ||= k283*k284/1000.0; end def l285; @l285 ||= l283*l284/1000.0; end def m285; @m285 ||= m283*m284/1000.0; end def n285; @n285 ||= n283*n284/1000.0; end def o285; @o285 ||= o283*o284/1000.0; end def c288; "WALK"; end def f288; 0.021680038900835603; end def g288; @g288 ||= sheet44.g160; end def h288; @h288 ||= sheet44.h160; end def i288; @i288 ||= sheet44.i160; end def j288; @j288 ||= sheet44.j160; end def k288; @k288 ||= sheet44.k160; end def l288; @l288 ||= sheet44.l160; end def m288; @m288 ||= sheet44.m160; end def n288; @n288 ||= sheet44.n160; end def o288; @o288 ||= sheet44.o160; end def c289; "BIKE"; end def f289; 0.005084268859379436; end def g289; @g289 ||= sheet44.g161; end def h289; @h289 ||= sheet44.h161; end def i289; @i289 ||= sheet44.i161; end def j289; @j289 ||= sheet44.j161; end def k289; @k289 ||= sheet44.k161; end def l289; @l289 ||= sheet44.l161; end def m289; @m289 ||= sheet44.m161; end def n289; @n289 ||= sheet44.n161; end def o289; @o289 ||= sheet44.o161; end def c290; "CAR"; end def f290; 0.832103179442072; end def g290; @g290 ||= sheet44.g162; end def h290; @h290 ||= sheet44.h162; end def i290; @i290 ||= sheet44.i162; end def j290; @j290 ||= sheet44.j162; end def k290; @k290 ||= sheet44.k162; end def l290; @l290 ||= sheet44.l162; end def m290; @m290 ||= sheet44.m162; end def n290; @n290 ||= sheet44.n162; end def o290; @o290 ||= sheet44.o162; end def c291; "BUS"; end def f291; 0.059627670922358024; end def g291; @g291 ||= sheet44.g163; end def h291; @h291 ||= sheet44.h163; end def i291; @i291 ||= sheet44.i163; end def j291; @j291 ||= sheet44.j163; end def k291; @k291 ||= sheet44.k163; end def l291; @l291 ||= sheet44.l163; end def m291; @m291 ||= sheet44.m163; end def n291; @n291 ||= sheet44.n163; end def o291; @o291 ||= sheet44.o163; end def c292; "RAIL"; end def f292; 0.07009723627466924; end def g292; @g292 ||= sheet44.g164; end def h292; @h292 ||= sheet44.h164; end def i292; @i292 ||= sheet44.i164; end def j292; @j292 ||= sheet44.j164; end def k292; @k292 ||= sheet44.k164; end def l292; @l292 ||= sheet44.l164; end def m292; @m292 ||= sheet44.m164; end def n292; @n292 ||= sheet44.n164; end def o292; @o292 ||= sheet44.o164; end def c293; "AIR"; end def f293; 0.011407605600685865; end def g293; @g293 ||= sheet44.g165; end def h293; @h293 ||= sheet44.h165; end def i293; @i293 ||= sheet44.i165; end def j293; @j293 ||= sheet44.j165; end def k293; @k293 ||= sheet44.k165; end def l293; @l293 ||= sheet44.l165; end def m293; @m293 ||= sheet44.m165; end def n293; @n293 ||= sheet44.n165; end def o293; @o293 ||= sheet44.o165; end def c296; "WALK"; end def f296; @f296 ||= f288*f285; end def g296; @g296 ||= g288*g285; end def h296; @h296 ||= h288*h285; end def i296; @i296 ||= i288*i285; end def j296; @j296 ||= j288*j285; end def k296; @k296 ||= k288*k285; end def l296; @l296 ||= l288*l285; end def m296; @m296 ||= m288*m285; end def n296; @n296 ||= n288*n285; end def o296; @o296 ||= o288*o285; end def c297; "BIKE"; end def f297; @f297 ||= f289*f285; end def g297; @g297 ||= g289*g285; end def h297; @h297 ||= h289*h285; end def i297; @i297 ||= i289*i285; end def j297; @j297 ||= j289*j285; end def k297; @k297 ||= k289*k285; end def l297; @l297 ||= l289*l285; end def m297; @m297 ||= m289*m285; end def n297; @n297 ||= n289*n285; end def o297; @o297 ||= o289*o285; end def c298; "CAR"; end def f298; @f298 ||= f290*f285; end def g298; @g298 ||= g290*g285; end def h298; @h298 ||= h290*h285; end def i298; @i298 ||= i290*i285; end def j298; @j298 ||= j290*j285; end def k298; @k298 ||= k290*k285; end def l298; @l298 ||= l290*l285; end def m298; @m298 ||= m290*m285; end def n298; @n298 ||= n290*n285; end def o298; @o298 ||= o290*o285; end def c299; "BUS"; end def f299; @f299 ||= f291*f285; end def g299; @g299 ||= g291*g285; end def h299; @h299 ||= h291*h285; end def i299; @i299 ||= i291*i285; end def j299; @j299 ||= j291*j285; end def k299; @k299 ||= k291*k285; end def l299; @l299 ||= l291*l285; end def m299; @m299 ||= m291*m285; end def n299; @n299 ||= n291*n285; end def o299; @o299 ||= o291*o285; end def c300; "RAIL"; end def f300; @f300 ||= f292*f285; end def g300; @g300 ||= g292*g285; end def h300; @h300 ||= h292*h285; end def i300; @i300 ||= i292*i285; end def j300; @j300 ||= j292*j285; end def k300; @k300 ||= k292*k285; end def l300; @l300 ||= l292*l285; end def m300; @m300 ||= m292*m285; end def n300; @n300 ||= n292*n285; end def o300; @o300 ||= o292*o285; end def c301; "AIR"; end def f301; @f301 ||= f293*f285; end def g301; @g301 ||= g293*g285; end def h301; @h301 ||= h293*h285; end def i301; @i301 ||= i293*i285; end def j301; @j301 ||= j293*j285; end def k301; @k301 ||= k293*k285; end def l301; @l301 ||= l293*l285; end def m301; @m301 ||= m293*m285; end def n301; @n301 ||= n293*n285; end def o301; @o301 ||= o293*o285; end def c308; "CAR"; end def d308; "ICE"; end def f308; @f308 ||= sumifs(a('f296','f301'),a('c296','c301'),c308)*sumifs(a('f173','f183'),a('c173','c183'),c308,a('d173','d183'),d308); end def g308; @g308 ||= sumifs(a('g296','g301'),a('c296','c301'),c308)*sumifs(a('g173','g183'),a('c173','c183'),c308,a('d173','d183'),d308); end def h308; @h308 ||= sumifs(a('h296','h301'),a('c296','c301'),c308)*sumifs(a('h173','h183'),a('c173','c183'),c308,a('d173','d183'),d308); end def i308; @i308 ||= sumifs(a('i296','i301'),a('c296','c301'),c308)*sumifs(a('i173','i183'),a('c173','c183'),c308,a('d173','d183'),d308); end def j308; @j308 ||= sumifs(a('j296','j301'),a('c296','c301'),c308)*sumifs(a('j173','j183'),a('c173','c183'),c308,a('d173','d183'),d308); end def k308; @k308 ||= sumifs(a('k296','k301'),a('c296','c301'),c308)*sumifs(a('k173','k183'),a('c173','c183'),c308,a('d173','d183'),d308); end def l308; @l308 ||= sumifs(a('l296','l301'),a('c296','c301'),c308)*sumifs(a('l173','l183'),a('c173','c183'),c308,a('d173','d183'),d308); end def m308; @m308 ||= sumifs(a('m296','m301'),a('c296','c301'),c308)*sumifs(a('m173','m183'),a('c173','c183'),c308,a('d173','d183'),d308); end def n308; @n308 ||= sumifs(a('n296','n301'),a('c296','c301'),c308)*sumifs(a('n173','n183'),a('c173','c183'),c308,a('d173','d183'),d308); end def o308; @o308 ||= sumifs(a('o296','o301'),a('c296','c301'),c308)*sumifs(a('o173','o183'),a('c173','c183'),c308,a('d173','d183'),d308); end def c309; "CAR"; end def d309; "PHEV"; end def f309; @f309 ||= sumifs(a('f296','f301'),a('c296','c301'),c309)*sumifs(a('f173','f183'),a('c173','c183'),c309,a('d173','d183'),d309); end def g309; @g309 ||= sumifs(a('g296','g301'),a('c296','c301'),c309)*sumifs(a('g173','g183'),a('c173','c183'),c309,a('d173','d183'),d309); end def h309; @h309 ||= sumifs(a('h296','h301'),a('c296','c301'),c309)*sumifs(a('h173','h183'),a('c173','c183'),c309,a('d173','d183'),d309); end def i309; @i309 ||= sumifs(a('i296','i301'),a('c296','c301'),c309)*sumifs(a('i173','i183'),a('c173','c183'),c309,a('d173','d183'),d309); end def j309; @j309 ||= sumifs(a('j296','j301'),a('c296','c301'),c309)*sumifs(a('j173','j183'),a('c173','c183'),c309,a('d173','d183'),d309); end def k309; @k309 ||= sumifs(a('k296','k301'),a('c296','c301'),c309)*sumifs(a('k173','k183'),a('c173','c183'),c309,a('d173','d183'),d309); end def l309; @l309 ||= sumifs(a('l296','l301'),a('c296','c301'),c309)*sumifs(a('l173','l183'),a('c173','c183'),c309,a('d173','d183'),d309); end def m309; @m309 ||= sumifs(a('m296','m301'),a('c296','c301'),c309)*sumifs(a('m173','m183'),a('c173','c183'),c309,a('d173','d183'),d309); end def n309; @n309 ||= sumifs(a('n296','n301'),a('c296','c301'),c309)*sumifs(a('n173','n183'),a('c173','c183'),c309,a('d173','d183'),d309); end def o309; @o309 ||= sumifs(a('o296','o301'),a('c296','c301'),c309)*sumifs(a('o173','o183'),a('c173','c183'),c309,a('d173','d183'),d309); end def c310; "CAR"; end def d310; "EV"; end def f310; @f310 ||= sumifs(a('f296','f301'),a('c296','c301'),c310)*sumifs(a('f173','f183'),a('c173','c183'),c310,a('d173','d183'),d310); end def g310; @g310 ||= sumifs(a('g296','g301'),a('c296','c301'),c310)*sumifs(a('g173','g183'),a('c173','c183'),c310,a('d173','d183'),d310); end def h310; @h310 ||= sumifs(a('h296','h301'),a('c296','c301'),c310)*sumifs(a('h173','h183'),a('c173','c183'),c310,a('d173','d183'),d310); end def i310; @i310 ||= sumifs(a('i296','i301'),a('c296','c301'),c310)*sumifs(a('i173','i183'),a('c173','c183'),c310,a('d173','d183'),d310); end def j310; @j310 ||= sumifs(a('j296','j301'),a('c296','c301'),c310)*sumifs(a('j173','j183'),a('c173','c183'),c310,a('d173','d183'),d310); end def k310; @k310 ||= sumifs(a('k296','k301'),a('c296','c301'),c310)*sumifs(a('k173','k183'),a('c173','c183'),c310,a('d173','d183'),d310); end def l310; @l310 ||= sumifs(a('l296','l301'),a('c296','c301'),c310)*sumifs(a('l173','l183'),a('c173','c183'),c310,a('d173','d183'),d310); end def m310; @m310 ||= sumifs(a('m296','m301'),a('c296','c301'),c310)*sumifs(a('m173','m183'),a('c173','c183'),c310,a('d173','d183'),d310); end def n310; @n310 ||= sumifs(a('n296','n301'),a('c296','c301'),c310)*sumifs(a('n173','n183'),a('c173','c183'),c310,a('d173','d183'),d310); end def o310; @o310 ||= sumifs(a('o296','o301'),a('c296','c301'),c310)*sumifs(a('o173','o183'),a('c173','c183'),c310,a('d173','d183'),d310); end def c311; "CAR"; end def d311; "FCV"; end def f311; @f311 ||= sumifs(a('f296','f301'),a('c296','c301'),c311)*sumifs(a('f173','f183'),a('c173','c183'),c311,a('d173','d183'),d311); end def g311; @g311 ||= sumifs(a('g296','g301'),a('c296','c301'),c311)*sumifs(a('g173','g183'),a('c173','c183'),c311,a('d173','d183'),d311); end def h311; @h311 ||= sumifs(a('h296','h301'),a('c296','c301'),c311)*sumifs(a('h173','h183'),a('c173','c183'),c311,a('d173','d183'),d311); end def i311; @i311 ||= sumifs(a('i296','i301'),a('c296','c301'),c311)*sumifs(a('i173','i183'),a('c173','c183'),c311,a('d173','d183'),d311); end def j311; @j311 ||= sumifs(a('j296','j301'),a('c296','c301'),c311)*sumifs(a('j173','j183'),a('c173','c183'),c311,a('d173','d183'),d311); end def k311; @k311 ||= sumifs(a('k296','k301'),a('c296','c301'),c311)*sumifs(a('k173','k183'),a('c173','c183'),c311,a('d173','d183'),d311); end def l311; @l311 ||= sumifs(a('l296','l301'),a('c296','c301'),c311)*sumifs(a('l173','l183'),a('c173','c183'),c311,a('d173','d183'),d311); end def m311; @m311 ||= sumifs(a('m296','m301'),a('c296','c301'),c311)*sumifs(a('m173','m183'),a('c173','c183'),c311,a('d173','d183'),d311); end def n311; @n311 ||= sumifs(a('n296','n301'),a('c296','c301'),c311)*sumifs(a('n173','n183'),a('c173','c183'),c311,a('d173','d183'),d311); end def o311; @o311 ||= sumifs(a('o296','o301'),a('c296','c301'),c311)*sumifs(a('o173','o183'),a('c173','c183'),c311,a('d173','d183'),d311); end def c312; "BUS"; end def d312; "ICE"; end def f312; @f312 ||= sumifs(a('f296','f301'),a('c296','c301'),c312)*sumifs(a('f173','f183'),a('c173','c183'),c312,a('d173','d183'),d312); end def g312; @g312 ||= sumifs(a('g296','g301'),a('c296','c301'),c312)*sumifs(a('g173','g183'),a('c173','c183'),c312,a('d173','d183'),d312); end def h312; @h312 ||= sumifs(a('h296','h301'),a('c296','c301'),c312)*sumifs(a('h173','h183'),a('c173','c183'),c312,a('d173','d183'),d312); end def i312; @i312 ||= sumifs(a('i296','i301'),a('c296','c301'),c312)*sumifs(a('i173','i183'),a('c173','c183'),c312,a('d173','d183'),d312); end def j312; @j312 ||= sumifs(a('j296','j301'),a('c296','c301'),c312)*sumifs(a('j173','j183'),a('c173','c183'),c312,a('d173','d183'),d312); end def k312; @k312 ||= sumifs(a('k296','k301'),a('c296','c301'),c312)*sumifs(a('k173','k183'),a('c173','c183'),c312,a('d173','d183'),d312); end def l312; @l312 ||= sumifs(a('l296','l301'),a('c296','c301'),c312)*sumifs(a('l173','l183'),a('c173','c183'),c312,a('d173','d183'),d312); end def m312; @m312 ||= sumifs(a('m296','m301'),a('c296','c301'),c312)*sumifs(a('m173','m183'),a('c173','c183'),c312,a('d173','d183'),d312); end def n312; @n312 ||= sumifs(a('n296','n301'),a('c296','c301'),c312)*sumifs(a('n173','n183'),a('c173','c183'),c312,a('d173','d183'),d312); end def o312; @o312 ||= sumifs(a('o296','o301'),a('c296','c301'),c312)*sumifs(a('o173','o183'),a('c173','c183'),c312,a('d173','d183'),d312); end def c313; "BUS"; end def d313; "HEV"; end def f313; @f313 ||= sumifs(a('f296','f301'),a('c296','c301'),c313)*sumifs(a('f173','f183'),a('c173','c183'),c313,a('d173','d183'),d313); end def g313; @g313 ||= sumifs(a('g296','g301'),a('c296','c301'),c313)*sumifs(a('g173','g183'),a('c173','c183'),c313,a('d173','d183'),d313); end def h313; @h313 ||= sumifs(a('h296','h301'),a('c296','c301'),c313)*sumifs(a('h173','h183'),a('c173','c183'),c313,a('d173','d183'),d313); end def i313; @i313 ||= sumifs(a('i296','i301'),a('c296','c301'),c313)*sumifs(a('i173','i183'),a('c173','c183'),c313,a('d173','d183'),d313); end def j313; @j313 ||= sumifs(a('j296','j301'),a('c296','c301'),c313)*sumifs(a('j173','j183'),a('c173','c183'),c313,a('d173','d183'),d313); end def k313; @k313 ||= sumifs(a('k296','k301'),a('c296','c301'),c313)*sumifs(a('k173','k183'),a('c173','c183'),c313,a('d173','d183'),d313); end def l313; @l313 ||= sumifs(a('l296','l301'),a('c296','c301'),c313)*sumifs(a('l173','l183'),a('c173','c183'),c313,a('d173','d183'),d313); end def m313; @m313 ||= sumifs(a('m296','m301'),a('c296','c301'),c313)*sumifs(a('m173','m183'),a('c173','c183'),c313,a('d173','d183'),d313); end def n313; @n313 ||= sumifs(a('n296','n301'),a('c296','c301'),c313)*sumifs(a('n173','n183'),a('c173','c183'),c313,a('d173','d183'),d313); end def o313; @o313 ||= sumifs(a('o296','o301'),a('c296','c301'),c313)*sumifs(a('o173','o183'),a('c173','c183'),c313,a('d173','d183'),d313); end def c314; "BUS"; end def d314; "EV"; end def f314; @f314 ||= sumifs(a('f296','f301'),a('c296','c301'),c314)*sumifs(a('f173','f183'),a('c173','c183'),c314,a('d173','d183'),d314); end def g314; @g314 ||= sumifs(a('g296','g301'),a('c296','c301'),c314)*sumifs(a('g173','g183'),a('c173','c183'),c314,a('d173','d183'),d314); end def h314; @h314 ||= sumifs(a('h296','h301'),a('c296','c301'),c314)*sumifs(a('h173','h183'),a('c173','c183'),c314,a('d173','d183'),d314); end def i314; @i314 ||= sumifs(a('i296','i301'),a('c296','c301'),c314)*sumifs(a('i173','i183'),a('c173','c183'),c314,a('d173','d183'),d314); end def j314; @j314 ||= sumifs(a('j296','j301'),a('c296','c301'),c314)*sumifs(a('j173','j183'),a('c173','c183'),c314,a('d173','d183'),d314); end def k314; @k314 ||= sumifs(a('k296','k301'),a('c296','c301'),c314)*sumifs(a('k173','k183'),a('c173','c183'),c314,a('d173','d183'),d314); end def l314; @l314 ||= sumifs(a('l296','l301'),a('c296','c301'),c314)*sumifs(a('l173','l183'),a('c173','c183'),c314,a('d173','d183'),d314); end def m314; @m314 ||= sumifs(a('m296','m301'),a('c296','c301'),c314)*sumifs(a('m173','m183'),a('c173','c183'),c314,a('d173','d183'),d314); end def n314; @n314 ||= sumifs(a('n296','n301'),a('c296','c301'),c314)*sumifs(a('n173','n183'),a('c173','c183'),c314,a('d173','d183'),d314); end def o314; @o314 ||= sumifs(a('o296','o301'),a('c296','c301'),c314)*sumifs(a('o173','o183'),a('c173','c183'),c314,a('d173','d183'),d314); end def c315; "BUS"; end def d315; "FCV"; end def f315; @f315 ||= sumifs(a('f296','f301'),a('c296','c301'),c315)*sumifs(a('f173','f183'),a('c173','c183'),c315,a('d173','d183'),d315); end def g315; @g315 ||= sumifs(a('g296','g301'),a('c296','c301'),c315)*sumifs(a('g173','g183'),a('c173','c183'),c315,a('d173','d183'),d315); end def h315; @h315 ||= sumifs(a('h296','h301'),a('c296','c301'),c315)*sumifs(a('h173','h183'),a('c173','c183'),c315,a('d173','d183'),d315); end def i315; @i315 ||= sumifs(a('i296','i301'),a('c296','c301'),c315)*sumifs(a('i173','i183'),a('c173','c183'),c315,a('d173','d183'),d315); end def j315; @j315 ||= sumifs(a('j296','j301'),a('c296','c301'),c315)*sumifs(a('j173','j183'),a('c173','c183'),c315,a('d173','d183'),d315); end def k315; @k315 ||= sumifs(a('k296','k301'),a('c296','c301'),c315)*sumifs(a('k173','k183'),a('c173','c183'),c315,a('d173','d183'),d315); end def l315; @l315 ||= sumifs(a('l296','l301'),a('c296','c301'),c315)*sumifs(a('l173','l183'),a('c173','c183'),c315,a('d173','d183'),d315); end def m315; @m315 ||= sumifs(a('m296','m301'),a('c296','c301'),c315)*sumifs(a('m173','m183'),a('c173','c183'),c315,a('d173','d183'),d315); end def n315; @n315 ||= sumifs(a('n296','n301'),a('c296','c301'),c315)*sumifs(a('n173','n183'),a('c173','c183'),c315,a('d173','d183'),d315); end def o315; @o315 ||= sumifs(a('o296','o301'),a('c296','c301'),c315)*sumifs(a('o173','o183'),a('c173','c183'),c315,a('d173','d183'),d315); end def c316; "RAIL"; end def d316; "DIESEL"; end def f316; @f316 ||= sumifs(a('f296','f301'),a('c296','c301'),c316)*sumifs(a('f173','f183'),a('c173','c183'),c316,a('d173','d183'),d316); end def g316; @g316 ||= sumifs(a('g296','g301'),a('c296','c301'),c316)*sumifs(a('g173','g183'),a('c173','c183'),c316,a('d173','d183'),d316); end def h316; @h316 ||= sumifs(a('h296','h301'),a('c296','c301'),c316)*sumifs(a('h173','h183'),a('c173','c183'),c316,a('d173','d183'),d316); end def i316; @i316 ||= sumifs(a('i296','i301'),a('c296','c301'),c316)*sumifs(a('i173','i183'),a('c173','c183'),c316,a('d173','d183'),d316); end def j316; @j316 ||= sumifs(a('j296','j301'),a('c296','c301'),c316)*sumifs(a('j173','j183'),a('c173','c183'),c316,a('d173','d183'),d316); end def k316; @k316 ||= sumifs(a('k296','k301'),a('c296','c301'),c316)*sumifs(a('k173','k183'),a('c173','c183'),c316,a('d173','d183'),d316); end def l316; @l316 ||= sumifs(a('l296','l301'),a('c296','c301'),c316)*sumifs(a('l173','l183'),a('c173','c183'),c316,a('d173','d183'),d316); end def m316; @m316 ||= sumifs(a('m296','m301'),a('c296','c301'),c316)*sumifs(a('m173','m183'),a('c173','c183'),c316,a('d173','d183'),d316); end def n316; @n316 ||= sumifs(a('n296','n301'),a('c296','c301'),c316)*sumifs(a('n173','n183'),a('c173','c183'),c316,a('d173','d183'),d316); end def o316; @o316 ||= sumifs(a('o296','o301'),a('c296','c301'),c316)*sumifs(a('o173','o183'),a('c173','c183'),c316,a('d173','d183'),d316); end def c317; "RAIL"; end def d317; "ELECTRIC"; end def f317; @f317 ||= sumifs(a('f296','f301'),a('c296','c301'),c317)*sumifs(a('f173','f183'),a('c173','c183'),c317,a('d173','d183'),d317); end def g317; @g317 ||= sumifs(a('g296','g301'),a('c296','c301'),c317)*sumifs(a('g173','g183'),a('c173','c183'),c317,a('d173','d183'),d317); end def h317; @h317 ||= sumifs(a('h296','h301'),a('c296','c301'),c317)*sumifs(a('h173','h183'),a('c173','c183'),c317,a('d173','d183'),d317); end def i317; @i317 ||= sumifs(a('i296','i301'),a('c296','c301'),c317)*sumifs(a('i173','i183'),a('c173','c183'),c317,a('d173','d183'),d317); end def j317; @j317 ||= sumifs(a('j296','j301'),a('c296','c301'),c317)*sumifs(a('j173','j183'),a('c173','c183'),c317,a('d173','d183'),d317); end def k317; @k317 ||= sumifs(a('k296','k301'),a('c296','c301'),c317)*sumifs(a('k173','k183'),a('c173','c183'),c317,a('d173','d183'),d317); end def l317; @l317 ||= sumifs(a('l296','l301'),a('c296','c301'),c317)*sumifs(a('l173','l183'),a('c173','c183'),c317,a('d173','d183'),d317); end def m317; @m317 ||= sumifs(a('m296','m301'),a('c296','c301'),c317)*sumifs(a('m173','m183'),a('c173','c183'),c317,a('d173','d183'),d317); end def n317; @n317 ||= sumifs(a('n296','n301'),a('c296','c301'),c317)*sumifs(a('n173','n183'),a('c173','c183'),c317,a('d173','d183'),d317); end def o317; @o317 ||= sumifs(a('o296','o301'),a('c296','c301'),c317)*sumifs(a('o173','o183'),a('c173','c183'),c317,a('d173','d183'),d317); end def c318; "AIR"; end def d318; "AIR"; end def f318; @f318 ||= sumifs(a('f296','f301'),a('c296','c301'),c318)*sumifs(a('f173','f183'),a('c173','c183'),c318,a('d173','d183'),d318); end def g318; @g318 ||= sumifs(a('g296','g301'),a('c296','c301'),c318)*sumifs(a('g173','g183'),a('c173','c183'),c318,a('d173','d183'),d318); end def h318; @h318 ||= sumifs(a('h296','h301'),a('c296','c301'),c318)*sumifs(a('h173','h183'),a('c173','c183'),c318,a('d173','d183'),d318); end def i318; @i318 ||= sumifs(a('i296','i301'),a('c296','c301'),c318)*sumifs(a('i173','i183'),a('c173','c183'),c318,a('d173','d183'),d318); end def j318; @j318 ||= sumifs(a('j296','j301'),a('c296','c301'),c318)*sumifs(a('j173','j183'),a('c173','c183'),c318,a('d173','d183'),d318); end def k318; @k318 ||= sumifs(a('k296','k301'),a('c296','c301'),c318)*sumifs(a('k173','k183'),a('c173','c183'),c318,a('d173','d183'),d318); end def l318; @l318 ||= sumifs(a('l296','l301'),a('c296','c301'),c318)*sumifs(a('l173','l183'),a('c173','c183'),c318,a('d173','d183'),d318); end def m318; @m318 ||= sumifs(a('m296','m301'),a('c296','c301'),c318)*sumifs(a('m173','m183'),a('c173','c183'),c318,a('d173','d183'),d318); end def n318; @n318 ||= sumifs(a('n296','n301'),a('c296','c301'),c318)*sumifs(a('n173','n183'),a('c173','c183'),c318,a('d173','d183'),d318); end def o318; @o318 ||= sumifs(a('o296','o301'),a('c296','c301'),c318)*sumifs(a('o173','o183'),a('c173','c183'),c318,a('d173','d183'),d318); end def c452; "CAR"; end def d452; "ICE"; end def f452_array; @f452_array ||= m(a('f308','f318'),m(a('c452','c462'),a('d452','d462')) { |r1,r2| sumifs(a('f196','f201'),a('c196','c201'),r1,a('d196','d201'),r2) }) { |r1,r2| r1*r2 }; end def f452; @f452 ||= f452_array.array_formula_offset(0,0); end def g452_array; @g452_array ||= m(a('g308','g318'),m(a('c452','c462'),a('d452','d462')) { |r1,r2| sumifs(a('g196','g201'),a('c196','c201'),r1,a('d196','d201'),r2) }) { |r1,r2| r1*r2 }; end def g452; @g452 ||= g452_array.array_formula_offset(0,0); end def h452_array; @h452_array ||= m(a('h308','h318'),m(a('c452','c462'),a('d452','d462')) { |r1,r2| sumifs(a('h196','h201'),a('c196','c201'),r1,a('d196','d201'),r2) }) { |r1,r2| r1*r2 }; end def h452; @h452 ||= h452_array.array_formula_offset(0,0); end def i452_array; @i452_array ||= m(a('i308','i318'),m(a('c452','c462'),a('d452','d462')) { |r1,r2| sumifs(a('i196','i201'),a('c196','c201'),r1,a('d196','d201'),r2) }) { |r1,r2| r1*r2 }; end def i452; @i452 ||= i452_array.array_formula_offset(0,0); end def j452_array; @j452_array ||= m(a('j308','j318'),m(a('c452','c462'),a('d452','d462')) { |r1,r2| sumifs(a('j196','j201'),a('c196','c201'),r1,a('d196','d201'),r2) }) { |r1,r2| r1*r2 }; end def j452; @j452 ||= j452_array.array_formula_offset(0,0); end def k452_array; @k452_array ||= m(a('k308','k318'),m(a('c452','c462'),a('d452','d462')) { |r1,r2| sumifs(a('k196','k201'),a('c196','c201'),r1,a('d196','d201'),r2) }) { |r1,r2| r1*r2 }; end def k452; @k452 ||= k452_array.array_formula_offset(0,0); end def l452_array; @l452_array ||= m(a('l308','l318'),m(a('c452','c462'),a('d452','d462')) { |r1,r2| sumifs(a('l196','l201'),a('c196','c201'),r1,a('d196','d201'),r2) }) { |r1,r2| r1*r2 }; end def l452; @l452 ||= l452_array.array_formula_offset(0,0); end def m452_array; @m452_array ||= m(a('m308','m318'),m(a('c452','c462'),a('d452','d462')) { |r1,r2| sumifs(a('m196','m201'),a('c196','c201'),r1,a('d196','d201'),r2) }) { |r1,r2| r1*r2 }; end def m452; @m452 ||= m452_array.array_formula_offset(0,0); end def n452_array; @n452_array ||= m(a('n308','n318'),m(a('c452','c462'),a('d452','d462')) { |r1,r2| sumifs(a('n196','n201'),a('c196','c201'),r1,a('d196','d201'),r2) }) { |r1,r2| r1*r2 }; end def n452; @n452 ||= n452_array.array_formula_offset(0,0); end def o452_array; @o452_array ||= m(a('o308','o318'),m(a('c452','c462'),a('d452','d462')) { |r1,r2| sumifs(a('o196','o201'),a('c196','c201'),r1,a('d196','d201'),r2) }) { |r1,r2| r1*r2 }; end def o452; @o452 ||= o452_array.array_formula_offset(0,0); end def c453; "CAR"; end def d453; "PHEV"; end def f453; @f453 ||= f452_array.array_formula_offset(1,0); end def g453; @g453 ||= g452_array.array_formula_offset(1,0); end def h453; @h453 ||= h452_array.array_formula_offset(1,0); end def i453; @i453 ||= i452_array.array_formula_offset(1,0); end def j453; @j453 ||= j452_array.array_formula_offset(1,0); end def k453; @k453 ||= k452_array.array_formula_offset(1,0); end def l453; @l453 ||= l452_array.array_formula_offset(1,0); end def m453; @m453 ||= m452_array.array_formula_offset(1,0); end def n453; @n453 ||= n452_array.array_formula_offset(1,0); end def o453; @o453 ||= o452_array.array_formula_offset(1,0); end def c454; "CAR"; end def d454; "EV"; end def f454; @f454 ||= f452_array.array_formula_offset(2,0); end def g454; @g454 ||= g452_array.array_formula_offset(2,0); end def h454; @h454 ||= h452_array.array_formula_offset(2,0); end def i454; @i454 ||= i452_array.array_formula_offset(2,0); end def j454; @j454 ||= j452_array.array_formula_offset(2,0); end def k454; @k454 ||= k452_array.array_formula_offset(2,0); end def l454; @l454 ||= l452_array.array_formula_offset(2,0); end def m454; @m454 ||= m452_array.array_formula_offset(2,0); end def n454; @n454 ||= n452_array.array_formula_offset(2,0); end def o454; @o454 ||= o452_array.array_formula_offset(2,0); end def c455; "CAR"; end def d455; "FCV"; end def f455; @f455 ||= f452_array.array_formula_offset(3,0); end def g455; @g455 ||= g452_array.array_formula_offset(3,0); end def h455; @h455 ||= h452_array.array_formula_offset(3,0); end def i455; @i455 ||= i452_array.array_formula_offset(3,0); end def j455; @j455 ||= j452_array.array_formula_offset(3,0); end def k455; @k455 ||= k452_array.array_formula_offset(3,0); end def l455; @l455 ||= l452_array.array_formula_offset(3,0); end def m455; @m455 ||= m452_array.array_formula_offset(3,0); end def n455; @n455 ||= n452_array.array_formula_offset(3,0); end def o455; @o455 ||= o452_array.array_formula_offset(3,0); end def c456; "BUS"; end def d456; "ICE"; end def f456; @f456 ||= f452_array.array_formula_offset(4,0); end def g456; @g456 ||= g452_array.array_formula_offset(4,0); end def h456; @h456 ||= h452_array.array_formula_offset(4,0); end def i456; @i456 ||= i452_array.array_formula_offset(4,0); end def j456; @j456 ||= j452_array.array_formula_offset(4,0); end def k456; @k456 ||= k452_array.array_formula_offset(4,0); end def l456; @l456 ||= l452_array.array_formula_offset(4,0); end def m456; @m456 ||= m452_array.array_formula_offset(4,0); end def n456; @n456 ||= n452_array.array_formula_offset(4,0); end def o456; @o456 ||= o452_array.array_formula_offset(4,0); end def c457; "BUS"; end def d457; "HEV"; end def f457; @f457 ||= f452_array.array_formula_offset(5,0); end def g457; @g457 ||= g452_array.array_formula_offset(5,0); end def h457; @h457 ||= h452_array.array_formula_offset(5,0); end def i457; @i457 ||= i452_array.array_formula_offset(5,0); end def j457; @j457 ||= j452_array.array_formula_offset(5,0); end def k457; @k457 ||= k452_array.array_formula_offset(5,0); end def l457; @l457 ||= l452_array.array_formula_offset(5,0); end def m457; @m457 ||= m452_array.array_formula_offset(5,0); end def n457; @n457 ||= n452_array.array_formula_offset(5,0); end def o457; @o457 ||= o452_array.array_formula_offset(5,0); end def c458; "BUS"; end def d458; "EV"; end def f458; @f458 ||= f452_array.array_formula_offset(6,0); end def g458; @g458 ||= g452_array.array_formula_offset(6,0); end def h458; @h458 ||= h452_array.array_formula_offset(6,0); end def i458; @i458 ||= i452_array.array_formula_offset(6,0); end def j458; @j458 ||= j452_array.array_formula_offset(6,0); end def k458; @k458 ||= k452_array.array_formula_offset(6,0); end def l458; @l458 ||= l452_array.array_formula_offset(6,0); end def m458; @m458 ||= m452_array.array_formula_offset(6,0); end def n458; @n458 ||= n452_array.array_formula_offset(6,0); end def o458; @o458 ||= o452_array.array_formula_offset(6,0); end def c459; "BUS"; end def d459; "FCV"; end def f459; @f459 ||= f452_array.array_formula_offset(7,0); end def g459; @g459 ||= g452_array.array_formula_offset(7,0); end def h459; @h459 ||= h452_array.array_formula_offset(7,0); end def i459; @i459 ||= i452_array.array_formula_offset(7,0); end def j459; @j459 ||= j452_array.array_formula_offset(7,0); end def k459; @k459 ||= k452_array.array_formula_offset(7,0); end def l459; @l459 ||= l452_array.array_formula_offset(7,0); end def m459; @m459 ||= m452_array.array_formula_offset(7,0); end def n459; @n459 ||= n452_array.array_formula_offset(7,0); end def o459; @o459 ||= o452_array.array_formula_offset(7,0); end def c460; "RAIL"; end def d460; "DIESEL"; end def f460; @f460 ||= f452_array.array_formula_offset(8,0); end def g460; @g460 ||= g452_array.array_formula_offset(8,0); end def h460; @h460 ||= h452_array.array_formula_offset(8,0); end def i460; @i460 ||= i452_array.array_formula_offset(8,0); end def j460; @j460 ||= j452_array.array_formula_offset(8,0); end def k460; @k460 ||= k452_array.array_formula_offset(8,0); end def l460; @l460 ||= l452_array.array_formula_offset(8,0); end def m460; @m460 ||= m452_array.array_formula_offset(8,0); end def n460; @n460 ||= n452_array.array_formula_offset(8,0); end def o460; @o460 ||= o452_array.array_formula_offset(8,0); end def c461; "RAIL"; end def d461; "ELECTRIC"; end def f461; @f461 ||= f452_array.array_formula_offset(9,0); end def g461; @g461 ||= g452_array.array_formula_offset(9,0); end def h461; @h461 ||= h452_array.array_formula_offset(9,0); end def i461; @i461 ||= i452_array.array_formula_offset(9,0); end def j461; @j461 ||= j452_array.array_formula_offset(9,0); end def k461; @k461 ||= k452_array.array_formula_offset(9,0); end def l461; @l461 ||= l452_array.array_formula_offset(9,0); end def m461; @m461 ||= m452_array.array_formula_offset(9,0); end def n461; @n461 ||= n452_array.array_formula_offset(9,0); end def o461; @o461 ||= o452_array.array_formula_offset(9,0); end def c462; "AIR"; end def d462; "AIR"; end def f462; @f462 ||= f452_array.array_formula_offset(10,0); end def g462; @g462 ||= g452_array.array_formula_offset(10,0); end def h462; @h462 ||= h452_array.array_formula_offset(10,0); end def i462; @i462 ||= i452_array.array_formula_offset(10,0); end def j462; @j462 ||= j452_array.array_formula_offset(10,0); end def k462; @k462 ||= k452_array.array_formula_offset(10,0); end def l462; @l462 ||= l452_array.array_formula_offset(10,0); end def m462; @m462 ||= m452_array.array_formula_offset(10,0); end def n462; @n462 ||= n452_array.array_formula_offset(10,0); end def o462; @o462 ||= o452_array.array_formula_offset(10,0); end def f463; @f463 ||= sum(a('f452','f462')); end def g463; @g463 ||= sum(a('g452','g462')); end def h463; @h463 ||= sum(a('h452','h462')); end def i463; @i463 ||= sum(a('i452','i462')); end def j463; @j463 ||= sum(a('j452','j462')); end def k463; @k463 ||= sum(a('k452','k462')); end def l463; @l463 ||= sum(a('l452','l462')); end def m463; @m463 ||= sum(a('m452','m462')); end def n463; @n463 ||= sum(a('n452','n462')); end def o463; @o463 ||= sum(a('o452','o462')); end def c467; "CAR"; end def d467; "ICE"; end def f467_array; @f467_array ||= m(a('f308','f318'),m(a('c467','c477'),a('d467','d477')) { |r1,r2| sumifs(a('f206','f209'),a('c206','c209'),r1,a('d206','d209'),r2) }) { |r1,r2| r1*r2 }; end def f467; @f467 ||= f467_array.array_formula_offset(0,0); end def g467_array; @g467_array ||= m(a('g308','g318'),m(a('c467','c477'),a('d467','d477')) { |r1,r2| sumifs(a('g206','g209'),a('c206','c209'),r1,a('d206','d209'),r2) }) { |r1,r2| r1*r2 }; end def g467; @g467 ||= g467_array.array_formula_offset(0,0); end def h467_array; @h467_array ||= m(a('h308','h318'),m(a('c467','c477'),a('d467','d477')) { |r1,r2| sumifs(a('h206','h209'),a('c206','c209'),r1,a('d206','d209'),r2) }) { |r1,r2| r1*r2 }; end def h467; @h467 ||= h467_array.array_formula_offset(0,0); end def i467_array; @i467_array ||= m(a('i308','i318'),m(a('c467','c477'),a('d467','d477')) { |r1,r2| sumifs(a('i206','i209'),a('c206','c209'),r1,a('d206','d209'),r2) }) { |r1,r2| r1*r2 }; end def i467; @i467 ||= i467_array.array_formula_offset(0,0); end def j467_array; @j467_array ||= m(a('j308','j318'),m(a('c467','c477'),a('d467','d477')) { |r1,r2| sumifs(a('j206','j209'),a('c206','c209'),r1,a('d206','d209'),r2) }) { |r1,r2| r1*r2 }; end def j467; @j467 ||= j467_array.array_formula_offset(0,0); end def k467_array; @k467_array ||= m(a('k308','k318'),m(a('c467','c477'),a('d467','d477')) { |r1,r2| sumifs(a('k206','k209'),a('c206','c209'),r1,a('d206','d209'),r2) }) { |r1,r2| r1*r2 }; end def k467; @k467 ||= k467_array.array_formula_offset(0,0); end def l467_array; @l467_array ||= m(a('l308','l318'),m(a('c467','c477'),a('d467','d477')) { |r1,r2| sumifs(a('l206','l209'),a('c206','c209'),r1,a('d206','d209'),r2) }) { |r1,r2| r1*r2 }; end def l467; @l467 ||= l467_array.array_formula_offset(0,0); end def m467_array; @m467_array ||= m(a('m308','m318'),m(a('c467','c477'),a('d467','d477')) { |r1,r2| sumifs(a('m206','m209'),a('c206','c209'),r1,a('d206','d209'),r2) }) { |r1,r2| r1*r2 }; end def m467; @m467 ||= m467_array.array_formula_offset(0,0); end def n467_array; @n467_array ||= m(a('n308','n318'),m(a('c467','c477'),a('d467','d477')) { |r1,r2| sumifs(a('n206','n209'),a('c206','c209'),r1,a('d206','d209'),r2) }) { |r1,r2| r1*r2 }; end def n467; @n467 ||= n467_array.array_formula_offset(0,0); end def o467_array; @o467_array ||= m(a('o308','o318'),m(a('c467','c477'),a('d467','d477')) { |r1,r2| sumifs(a('o206','o209'),a('c206','c209'),r1,a('d206','d209'),r2) }) { |r1,r2| r1*r2 }; end def o467; @o467 ||= o467_array.array_formula_offset(0,0); end def c468; "CAR"; end def d468; "PHEV"; end def f468; @f468 ||= f467_array.array_formula_offset(1,0); end def g468; @g468 ||= g467_array.array_formula_offset(1,0); end def h468; @h468 ||= h467_array.array_formula_offset(1,0); end def i468; @i468 ||= i467_array.array_formula_offset(1,0); end def j468; @j468 ||= j467_array.array_formula_offset(1,0); end def k468; @k468 ||= k467_array.array_formula_offset(1,0); end def l468; @l468 ||= l467_array.array_formula_offset(1,0); end def m468; @m468 ||= m467_array.array_formula_offset(1,0); end def n468; @n468 ||= n467_array.array_formula_offset(1,0); end def o468; @o468 ||= o467_array.array_formula_offset(1,0); end def c469; "CAR"; end def d469; "EV"; end def f469; @f469 ||= f467_array.array_formula_offset(2,0); end def g469; @g469 ||= g467_array.array_formula_offset(2,0); end def h469; @h469 ||= h467_array.array_formula_offset(2,0); end def i469; @i469 ||= i467_array.array_formula_offset(2,0); end def j469; @j469 ||= j467_array.array_formula_offset(2,0); end def k469; @k469 ||= k467_array.array_formula_offset(2,0); end def l469; @l469 ||= l467_array.array_formula_offset(2,0); end def m469; @m469 ||= m467_array.array_formula_offset(2,0); end def n469; @n469 ||= n467_array.array_formula_offset(2,0); end def o469; @o469 ||= o467_array.array_formula_offset(2,0); end def c470; "CAR"; end def d470; "FCV"; end def f470; @f470 ||= f467_array.array_formula_offset(3,0); end def g470; @g470 ||= g467_array.array_formula_offset(3,0); end def h470; @h470 ||= h467_array.array_formula_offset(3,0); end def i470; @i470 ||= i467_array.array_formula_offset(3,0); end def j470; @j470 ||= j467_array.array_formula_offset(3,0); end def k470; @k470 ||= k467_array.array_formula_offset(3,0); end def l470; @l470 ||= l467_array.array_formula_offset(3,0); end def m470; @m470 ||= m467_array.array_formula_offset(3,0); end def n470; @n470 ||= n467_array.array_formula_offset(3,0); end def o470; @o470 ||= o467_array.array_formula_offset(3,0); end def c471; "BUS"; end def d471; "ICE"; end def f471; @f471 ||= f467_array.array_formula_offset(4,0); end def g471; @g471 ||= g467_array.array_formula_offset(4,0); end def h471; @h471 ||= h467_array.array_formula_offset(4,0); end def i471; @i471 ||= i467_array.array_formula_offset(4,0); end def j471; @j471 ||= j467_array.array_formula_offset(4,0); end def k471; @k471 ||= k467_array.array_formula_offset(4,0); end def l471; @l471 ||= l467_array.array_formula_offset(4,0); end def m471; @m471 ||= m467_array.array_formula_offset(4,0); end def n471; @n471 ||= n467_array.array_formula_offset(4,0); end def o471; @o471 ||= o467_array.array_formula_offset(4,0); end def c472; "BUS"; end def d472; "HEV"; end def f472; @f472 ||= f467_array.array_formula_offset(5,0); end def g472; @g472 ||= g467_array.array_formula_offset(5,0); end def h472; @h472 ||= h467_array.array_formula_offset(5,0); end def i472; @i472 ||= i467_array.array_formula_offset(5,0); end def j472; @j472 ||= j467_array.array_formula_offset(5,0); end def k472; @k472 ||= k467_array.array_formula_offset(5,0); end def l472; @l472 ||= l467_array.array_formula_offset(5,0); end def m472; @m472 ||= m467_array.array_formula_offset(5,0); end def n472; @n472 ||= n467_array.array_formula_offset(5,0); end def o472; @o472 ||= o467_array.array_formula_offset(5,0); end def c473; "BUS"; end def d473; "EV"; end def f473; @f473 ||= f467_array.array_formula_offset(6,0); end def g473; @g473 ||= g467_array.array_formula_offset(6,0); end def h473; @h473 ||= h467_array.array_formula_offset(6,0); end def i473; @i473 ||= i467_array.array_formula_offset(6,0); end def j473; @j473 ||= j467_array.array_formula_offset(6,0); end def k473; @k473 ||= k467_array.array_formula_offset(6,0); end def l473; @l473 ||= l467_array.array_formula_offset(6,0); end def m473; @m473 ||= m467_array.array_formula_offset(6,0); end def n473; @n473 ||= n467_array.array_formula_offset(6,0); end def o473; @o473 ||= o467_array.array_formula_offset(6,0); end def c474; "BUS"; end def d474; "FCV"; end def f474; @f474 ||= f467_array.array_formula_offset(7,0); end def g474; @g474 ||= g467_array.array_formula_offset(7,0); end def h474; @h474 ||= h467_array.array_formula_offset(7,0); end def i474; @i474 ||= i467_array.array_formula_offset(7,0); end def j474; @j474 ||= j467_array.array_formula_offset(7,0); end def k474; @k474 ||= k467_array.array_formula_offset(7,0); end def l474; @l474 ||= l467_array.array_formula_offset(7,0); end def m474; @m474 ||= m467_array.array_formula_offset(7,0); end def n474; @n474 ||= n467_array.array_formula_offset(7,0); end def o474; @o474 ||= o467_array.array_formula_offset(7,0); end def c475; "RAIL"; end def d475; "DIESEL"; end def f475; @f475 ||= f467_array.array_formula_offset(8,0); end def g475; @g475 ||= g467_array.array_formula_offset(8,0); end def h475; @h475 ||= h467_array.array_formula_offset(8,0); end def i475; @i475 ||= i467_array.array_formula_offset(8,0); end def j475; @j475 ||= j467_array.array_formula_offset(8,0); end def k475; @k475 ||= k467_array.array_formula_offset(8,0); end def l475; @l475 ||= l467_array.array_formula_offset(8,0); end def m475; @m475 ||= m467_array.array_formula_offset(8,0); end def n475; @n475 ||= n467_array.array_formula_offset(8,0); end def o475; @o475 ||= o467_array.array_formula_offset(8,0); end def c476; "RAIL"; end def d476; "ELECTRIC"; end def f476; @f476 ||= f467_array.array_formula_offset(9,0); end def g476; @g476 ||= g467_array.array_formula_offset(9,0); end def h476; @h476 ||= h467_array.array_formula_offset(9,0); end def i476; @i476 ||= i467_array.array_formula_offset(9,0); end def j476; @j476 ||= j467_array.array_formula_offset(9,0); end def k476; @k476 ||= k467_array.array_formula_offset(9,0); end def l476; @l476 ||= l467_array.array_formula_offset(9,0); end def m476; @m476 ||= m467_array.array_formula_offset(9,0); end def n476; @n476 ||= n467_array.array_formula_offset(9,0); end def o476; @o476 ||= o467_array.array_formula_offset(9,0); end def c477; "AIR"; end def d477; "AIR"; end def f477; @f477 ||= f467_array.array_formula_offset(10,0); end def g477; @g477 ||= g467_array.array_formula_offset(10,0); end def h477; @h477 ||= h467_array.array_formula_offset(10,0); end def i477; @i477 ||= i467_array.array_formula_offset(10,0); end def j477; @j477 ||= j467_array.array_formula_offset(10,0); end def k477; @k477 ||= k467_array.array_formula_offset(10,0); end def l477; @l477 ||= l467_array.array_formula_offset(10,0); end def m477; @m477 ||= m467_array.array_formula_offset(10,0); end def n477; @n477 ||= n467_array.array_formula_offset(10,0); end def o477; @o477 ||= o467_array.array_formula_offset(10,0); end def f478; @f478 ||= sum(a('f467','f477')); end def g478; @g478 ||= sum(a('g467','g477')); end def h478; @h478 ||= sum(a('h467','h477')); end def i478; @i478 ||= sum(a('i467','i477')); end def j478; @j478 ||= sum(a('j467','j477')); end def k478; @k478 ||= sum(a('k467','k477')); end def l478; @l478 ||= sum(a('l467','l477')); end def m478; @m478 ||= sum(a('m467','m477')); end def n478; @n478 ||= sum(a('n467','n477')); end def o478; @o478 ||= sum(a('o467','o477')); end def c482; "CAR"; end def d482; "ICE"; end def f482_array; @f482_array ||= m(a('f308','o318'),m(a('c482','c492'),a('d482','d492')) { |r1,r2| sumifs(a('o214','o215'),a('c214','c215'),r1,a('d214','d215'),r2) }) { |r1,r2| r1*r2 }; end def f482; @f482 ||= f482_array.array_formula_offset(0,0); end def g482; @g482 ||= f482_array.array_formula_offset(0,1); end def h482; @h482 ||= f482_array.array_formula_offset(0,2); end def i482; @i482 ||= f482_array.array_formula_offset(0,3); end def j482; @j482 ||= f482_array.array_formula_offset(0,4); end def k482; @k482 ||= f482_array.array_formula_offset(0,5); end def l482; @l482 ||= f482_array.array_formula_offset(0,6); end def m482; @m482 ||= f482_array.array_formula_offset(0,7); end def n482; @n482 ||= f482_array.array_formula_offset(0,8); end def o482; @o482 ||= f482_array.array_formula_offset(0,9); end def c483; "CAR"; end def d483; "PHEV"; end def f483; @f483 ||= f482_array.array_formula_offset(1,0); end def g483; @g483 ||= f482_array.array_formula_offset(1,1); end def h483; @h483 ||= f482_array.array_formula_offset(1,2); end def i483; @i483 ||= f482_array.array_formula_offset(1,3); end def j483; @j483 ||= f482_array.array_formula_offset(1,4); end def k483; @k483 ||= f482_array.array_formula_offset(1,5); end def l483; @l483 ||= f482_array.array_formula_offset(1,6); end def m483; @m483 ||= f482_array.array_formula_offset(1,7); end def n483; @n483 ||= f482_array.array_formula_offset(1,8); end def o483; @o483 ||= f482_array.array_formula_offset(1,9); end def c484; "CAR"; end def d484; "EV"; end def f484; @f484 ||= f482_array.array_formula_offset(2,0); end def g484; @g484 ||= f482_array.array_formula_offset(2,1); end def h484; @h484 ||= f482_array.array_formula_offset(2,2); end def i484; @i484 ||= f482_array.array_formula_offset(2,3); end def j484; @j484 ||= f482_array.array_formula_offset(2,4); end def k484; @k484 ||= f482_array.array_formula_offset(2,5); end def l484; @l484 ||= f482_array.array_formula_offset(2,6); end def m484; @m484 ||= f482_array.array_formula_offset(2,7); end def n484; @n484 ||= f482_array.array_formula_offset(2,8); end def o484; @o484 ||= f482_array.array_formula_offset(2,9); end def c485; "CAR"; end def d485; "FCV"; end def f485; @f485 ||= f482_array.array_formula_offset(3,0); end def g485; @g485 ||= f482_array.array_formula_offset(3,1); end def h485; @h485 ||= f482_array.array_formula_offset(3,2); end def i485; @i485 ||= f482_array.array_formula_offset(3,3); end def j485; @j485 ||= f482_array.array_formula_offset(3,4); end def k485; @k485 ||= f482_array.array_formula_offset(3,5); end def l485; @l485 ||= f482_array.array_formula_offset(3,6); end def m485; @m485 ||= f482_array.array_formula_offset(3,7); end def n485; @n485 ||= f482_array.array_formula_offset(3,8); end def o485; @o485 ||= f482_array.array_formula_offset(3,9); end def c486; "BUS"; end def d486; "ICE"; end def f486; @f486 ||= f482_array.array_formula_offset(4,0); end def g486; @g486 ||= f482_array.array_formula_offset(4,1); end def h486; @h486 ||= f482_array.array_formula_offset(4,2); end def i486; @i486 ||= f482_array.array_formula_offset(4,3); end def j486; @j486 ||= f482_array.array_formula_offset(4,4); end def k486; @k486 ||= f482_array.array_formula_offset(4,5); end def l486; @l486 ||= f482_array.array_formula_offset(4,6); end def m486; @m486 ||= f482_array.array_formula_offset(4,7); end def n486; @n486 ||= f482_array.array_formula_offset(4,8); end def o486; @o486 ||= f482_array.array_formula_offset(4,9); end def c487; "BUS"; end def d487; "HEV"; end def f487; @f487 ||= f482_array.array_formula_offset(5,0); end def g487; @g487 ||= f482_array.array_formula_offset(5,1); end def h487; @h487 ||= f482_array.array_formula_offset(5,2); end def i487; @i487 ||= f482_array.array_formula_offset(5,3); end def j487; @j487 ||= f482_array.array_formula_offset(5,4); end def k487; @k487 ||= f482_array.array_formula_offset(5,5); end def l487; @l487 ||= f482_array.array_formula_offset(5,6); end def m487; @m487 ||= f482_array.array_formula_offset(5,7); end def n487; @n487 ||= f482_array.array_formula_offset(5,8); end def o487; @o487 ||= f482_array.array_formula_offset(5,9); end def c488; "BUS"; end def d488; "EV"; end def f488; @f488 ||= f482_array.array_formula_offset(6,0); end def g488; @g488 ||= f482_array.array_formula_offset(6,1); end def h488; @h488 ||= f482_array.array_formula_offset(6,2); end def i488; @i488 ||= f482_array.array_formula_offset(6,3); end def j488; @j488 ||= f482_array.array_formula_offset(6,4); end def k488; @k488 ||= f482_array.array_formula_offset(6,5); end def l488; @l488 ||= f482_array.array_formula_offset(6,6); end def m488; @m488 ||= f482_array.array_formula_offset(6,7); end def n488; @n488 ||= f482_array.array_formula_offset(6,8); end def o488; @o488 ||= f482_array.array_formula_offset(6,9); end def c489; "BUS"; end def d489; "FCV"; end def f489; @f489 ||= f482_array.array_formula_offset(7,0); end def g489; @g489 ||= f482_array.array_formula_offset(7,1); end def h489; @h489 ||= f482_array.array_formula_offset(7,2); end def i489; @i489 ||= f482_array.array_formula_offset(7,3); end def j489; @j489 ||= f482_array.array_formula_offset(7,4); end def k489; @k489 ||= f482_array.array_formula_offset(7,5); end def l489; @l489 ||= f482_array.array_formula_offset(7,6); end def m489; @m489 ||= f482_array.array_formula_offset(7,7); end def n489; @n489 ||= f482_array.array_formula_offset(7,8); end def o489; @o489 ||= f482_array.array_formula_offset(7,9); end def c490; "RAIL"; end def d490; "DIESEL"; end def f490; @f490 ||= f482_array.array_formula_offset(8,0); end def g490; @g490 ||= f482_array.array_formula_offset(8,1); end def h490; @h490 ||= f482_array.array_formula_offset(8,2); end def i490; @i490 ||= f482_array.array_formula_offset(8,3); end def j490; @j490 ||= f482_array.array_formula_offset(8,4); end def k490; @k490 ||= f482_array.array_formula_offset(8,5); end def l490; @l490 ||= f482_array.array_formula_offset(8,6); end def m490; @m490 ||= f482_array.array_formula_offset(8,7); end def n490; @n490 ||= f482_array.array_formula_offset(8,8); end def o490; @o490 ||= f482_array.array_formula_offset(8,9); end def c491; "RAIL"; end def d491; "ELECTRIC"; end def f491; @f491 ||= f482_array.array_formula_offset(9,0); end def g491; @g491 ||= f482_array.array_formula_offset(9,1); end def h491; @h491 ||= f482_array.array_formula_offset(9,2); end def i491; @i491 ||= f482_array.array_formula_offset(9,3); end def j491; @j491 ||= f482_array.array_formula_offset(9,4); end def k491; @k491 ||= f482_array.array_formula_offset(9,5); end def l491; @l491 ||= f482_array.array_formula_offset(9,6); end def m491; @m491 ||= f482_array.array_formula_offset(9,7); end def n491; @n491 ||= f482_array.array_formula_offset(9,8); end def o491; @o491 ||= f482_array.array_formula_offset(9,9); end def c492; "AIR"; end def d492; "AIR"; end def f492; @f492 ||= f482_array.array_formula_offset(10,0); end def g492; @g492 ||= f482_array.array_formula_offset(10,1); end def h492; @h492 ||= f482_array.array_formula_offset(10,2); end def i492; @i492 ||= f482_array.array_formula_offset(10,3); end def j492; @j492 ||= f482_array.array_formula_offset(10,4); end def k492; @k492 ||= f482_array.array_formula_offset(10,5); end def l492; @l492 ||= f482_array.array_formula_offset(10,6); end def m492; @m492 ||= f482_array.array_formula_offset(10,7); end def n492; @n492 ||= f482_array.array_formula_offset(10,8); end def o492; @o492 ||= f482_array.array_formula_offset(10,9); end def f493; @f493 ||= sum(a('f482','f492')); end def g493; @g493 ||= sum(a('g482','g492')); end def h493; @h493 ||= sum(a('h482','h492')); end def i493; @i493 ||= sum(a('i482','i492')); end def j493; @j493 ||= sum(a('j482','j492')); end def k493; @k493 ||= sum(a('k482','k492')); end def l493; @l493 ||= sum(a('l482','l492')); end def m493; @m493 ||= sum(a('m482','m492')); end def n493; @n493 ||= sum(a('n482','n492')); end def o493; @o493 ||= sum(a('o482','o492')); end def f497; @f497 ||= sum(a('f452','f459'))+sum(a('f467','f474'))+sum(a('f482','f489')); end def g497; @g497 ||= sum(a('g452','g459'))+sum(a('g467','g474'))+sum(a('g482','g489')); end def h497; @h497 ||= sum(a('h452','h459'))+sum(a('h467','h474'))+sum(a('h482','h489')); end def i497; @i497 ||= sum(a('i452','i459'))+sum(a('i467','i474'))+sum(a('i482','i489')); end def j497; @j497 ||= sum(a('j452','j459'))+sum(a('j467','j474'))+sum(a('j482','j489')); end def k497; @k497 ||= sum(a('k452','k459'))+sum(a('k467','k474'))+sum(a('k482','k489')); end def l497; @l497 ||= sum(a('l452','l459'))+sum(a('l467','l474'))+sum(a('l482','l489')); end def m497; @m497 ||= sum(a('m452','m459'))+sum(a('m467','m474'))+sum(a('m482','m489')); end def n497; @n497 ||= sum(a('n452','n459'))+sum(a('n467','n474'))+sum(a('n482','n489')); end def o497; @o497 ||= sum(a('o452','o459'))+sum(a('o467','o474'))+sum(a('o482','o489')); end def f498; @f498 ||= sum(a('f460','f461'))+sum(a('f475','f476'))+sum(a('f490','f491')); end def g498; @g498 ||= sum(a('g460','g461'))+sum(a('g475','g476'))+sum(a('g490','g491')); end def h498; @h498 ||= sum(a('h460','h461'))+sum(a('h475','h476'))+sum(a('h490','h491')); end def i498; @i498 ||= sum(a('i460','i461'))+sum(a('i475','i476'))+sum(a('i490','i491')); end def j498; @j498 ||= sum(a('j460','j461'))+sum(a('j475','j476'))+sum(a('j490','j491')); end def k498; @k498 ||= sum(a('k460','k461'))+sum(a('k475','k476'))+sum(a('k490','k491')); end def l498; @l498 ||= sum(a('l460','l461'))+sum(a('l475','l476'))+sum(a('l490','l491')); end def m498; @m498 ||= sum(a('m460','m461'))+sum(a('m475','m476'))+sum(a('m490','m491')); end def n498; @n498 ||= sum(a('n460','n461'))+sum(a('n475','n476'))+sum(a('n490','n491')); end def o498; @o498 ||= sum(a('o460','o461'))+sum(a('o475','o476'))+sum(a('o490','o491')); end def f499; @f499 ||= f462+f477+f492; end def g499; @g499 ||= g462+g477+g492; end def h499; @h499 ||= h462+h477+h492; end def i499; @i499 ||= i462+i477+i492; end def j499; @j499 ||= j462+j477+j492; end def k499; @k499 ||= k462+k477+k492; end def l499; @l499 ||= l462+l477+l492; end def m499; @m499 ||= m462+m477+m492; end def n499; @n499 ||= n462+n477+n492; end def o499; @o499 ||= o462+o477+o492; end def f503; @f503 ||= f463*sheet14.d43; end def g503; @g503 ||= g463*sheet14.d43; end def h503; @h503 ||= h463*sheet14.d43; end def i503; @i503 ||= i463*sheet14.d43; end def j503; @j503 ||= j463*sheet14.d43; end def k503; @k503 ||= k463*sheet14.d43; end def l503; @l503 ||= l463*sheet14.d43; end def m503; @m503 ||= m463*sheet14.d43; end def n503; @n503 ||= n463*sheet14.d43; end def o503; @o503 ||= o463*sheet14.d43; end def f504; @f504 ||= f463*sheet14.e43; end def g504; @g504 ||= g463*sheet14.e43; end def h504; @h504 ||= h463*sheet14.e43; end def i504; @i504 ||= i463*sheet14.e43; end def j504; @j504 ||= j463*sheet14.e43; end def k504; @k504 ||= k463*sheet14.e43; end def l504; @l504 ||= l463*sheet14.e43; end def m504; @m504 ||= m463*sheet14.e43; end def n504; @n504 ||= n463*sheet14.e43; end def o504; @o504 ||= o463*sheet14.e43; end def f505; @f505 ||= f463*sheet14.f43; end def g505; @g505 ||= g463*sheet14.f43; end def h505; @h505 ||= h463*sheet14.f43; end def i505; @i505 ||= i463*sheet14.f43; end def j505; @j505 ||= j463*sheet14.f43; end def k505; @k505 ||= k463*sheet14.f43; end def l505; @l505 ||= l463*sheet14.f43; end def m505; @m505 ||= m463*sheet14.f43; end def n505; @n505 ||= n463*sheet14.f43; end def o505; @o505 ||= o463*sheet14.f43; end def c525; "T.01"; end def f525; @f525 ||= f497; end def g525; @g525 ||= g497; end def h525; @h525 ||= h497; end def i525; @i525 ||= i497; end def j525; @j525 ||= j497; end def k525; @k525 ||= k497; end def l525; @l525 ||= l497; end def m525; @m525 ||= m497; end def n525; @n525 ||= n497; end def o525; @o525 ||= o497; end def c526; "T.02"; end def f526; @f526 ||= f498+f144; end def g526; @g526 ||= g498+g144; end def h526; @h526 ||= h498+h144; end def i526; @i526 ||= i498+i144; end def j526; @j526 ||= j498+j144; end def k526; @k526 ||= k498+k144; end def l526; @l526 ||= l498+l144; end def m526; @m526 ||= m498+m144; end def n526; @n526 ||= n498+n144; end def o526; @o526 ||= o498+o144; end def c527; "T.03"; end def f527; @f527 ||= f499; end def g527; @g527 ||= g499; end def h527; @h527 ||= h499; end def i527; @i527 ||= i499; end def j527; @j527 ||= j499; end def k527; @k527 ||= k499; end def l527; @l527 ||= l499; end def m527; @m527 ||= m499; end def n527; @n527 ||= n499; end def o527; @o527 ||= o499; end def c528; "V.04"; end def f528; @f528 ||= -f463; end def g528; @g528 ||= -g463; end def h528; @h528 ||= -h463; end def i528; @i528 ||= -i463; end def j528; @j528 ||= -j463; end def k528; @k528 ||= -k463; end def l528; @l528 ||= -l463; end def m528; @m528 ||= -m463; end def n528; @n528 ||= -n463; end def o528; @o528 ||= -o463; end def c529; "V.01"; end def f529; @f529 ||= -f478-f144; end def g529; @g529 ||= -g478-g144; end def h529; @h529 ||= -h478-h144; end def i529; @i529 ||= -i478-i144; end def j529; @j529 ||= -j478-j144; end def k529; @k529 ||= -k478-k144; end def l529; @l529 ||= -l478-l144; end def m529; @m529 ||= -m478-m144; end def n529; @n529 ||= -n478-n144; end def o529; @o529 ||= -o478-o144; end def c530; "V.12"; end def f530; @f530 ||= -f493; end def g530; @g530 ||= -g493; end def h530; @h530 ||= -h493; end def i530; @i530 ||= -i493; end def j530; @j530 ||= -j493; end def k530; @k530 ||= -k493; end def l530; @l530 ||= -l493; end def m530; @m530 ||= -m493; end def n530; @n530 ||= -n493; end def o530; @o530 ||= -o493; end def o537; @o537 ||= -sum(a('o452','o459')); end def o538; @o538 ||= -sum(a('o467','o474')); end def o539; @o539 ||= -sum(a('o482','o489')); end def o546; @o546 ||= -sum(a('o460','o461')); end def o547; @o547 ||= -(sum(a('o475','o476'))+o144); end def o555; @o555 ||= -o462; end def c566; "CO2"; end def d566; "1A"; end def f566; @f566 ||= f503; end def g566; @g566 ||= g503; end def h566; @h566 ||= h503; end def i566; @i566 ||= i503; end def j566; @j566 ||= j503; end def k566; @k566 ||= k503; end def l566; @l566 ||= l503; end def m566; @m566 ||= m503; end def n566; @n566 ||= n503; end def o566; @o566 ||= o503; end def c567; "CH4"; end def d567; "1A"; end def f567; @f567 ||= f504; end def g567; @g567 ||= g504; end def h567; @h567 ||= h504; end def i567; @i567 ||= i504; end def j567; @j567 ||= j504; end def k567; @k567 ||= k504; end def l567; @l567 ||= l504; end def m567; @m567 ||= m504; end def n567; @n567 ||= n504; end def o567; @o567 ||= o504; end def c568; "N2O"; end def d568; "1A"; end def f568; @f568 ||= f505; end def g568; @g568 ||= g505; end def h568; @h568 ||= h505; end def i568; @i568 ||= i505; end def j568; @j568 ||= j505; end def k568; @k568 ||= k505; end def l568; @l568 ||= l505; end def m568; @m568 ||= m505; end def n568; @n568 ||= n505; end def o568; @o568 ||= o505; end def c601; "B.08"; end def f601; @f601 ||= f468*sheet11.e58; end def g601; @g601 ||= g468*sheet11.e58; end def h601; @h601 ||= h468*sheet11.e58; end def i601; @i601 ||= i468*sheet11.e58; end def j601; @j601 ||= j468*sheet11.e58; end def k601; @k601 ||= k468*sheet11.e58; end def l601; @l601 ||= l468*sheet11.e58; end def m601; @m601 ||= m468*sheet11.e58; end def n601; @n601 ||= n468*sheet11.e58; end def o601; @o601 ||= o468*sheet11.e58; end def c606; "B.08"; end def f606; @f606 ||= f469*sheet11.e58; end def g606; @g606 ||= g469*sheet11.e58; end def h606; @h606 ||= h469*sheet11.e58; end def i606; @i606 ||= i469*sheet11.e58; end def j606; @j606 ||= j469*sheet11.e58; end def k606; @k606 ||= k469*sheet11.e58; end def l606; @l606 ||= l469*sheet11.e58; end def m606; @m606 ||= m469*sheet11.e58; end def n606; @n606 ||= n469*sheet11.e58; end def o606; @o606 ||= o469*sheet11.e58; end end