{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Summary Data","Overview","Sectoral Analysis","Indicator Analysis","Summary Charts (3)","Bank Analysis","Detailed lending data","Tabulated impacts","Ranking","Sheet3","Bradesco","CEF","HSBC","All"],"not_rendered":{"charts":19,"images":4,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary Data","index":0,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"Client Sector","Credit exposure (BRLm)","Natural Capital Impact (BRLm)","NCER ratio"]
[null,"Agriculture",56,{"$f":"C9*E9","v":93.298413808896242},{"$f":"VLOOKUP($B9,'Bank Analysis'!$O$52:$R$71,4,0)","v":1.6660431037302901}]
[null,"Automobiles",504,220.82479384756039,{"$f":"VLOOKUP($B10,'Bank Analysis'!$O$52:$R$71,4,0)","v":0.43814443223722299}]
[null,"Chemicals",600,720.56874152268165,{"$f":"VLOOKUP($B11,'Bank Analysis'!$O$52:$R$71,4,0)","v":1.2009479025378027}]
[null,"Construction",200,157.15599789772193,{"$f":"VLOOKUP($B12,'Bank Analysis'!$O$52:$R$71,4,0)","v":0.78577998948860961}]
[null,"Energy",546,115.40231948482599,{"$f":"VLOOKUP($B13,'Bank Analysis'!$O$52:$R$71,4,0)","v":0.21135955949601831}]
[null,"Fishing",344,2487.0766898301986,{"$f":"VLOOKUP($B14,'Bank Analysis'!$O$52:$R$71,4,0)","v":7.2298740983436005}]
[null,"Food and Beverage",91,249.53001025602799,{"$f":"VLOOKUP($B15,'Bank Analysis'!$O$52:$R$71,4,0)","v":2.7420880247915163}]
[null,"Forestry",470,174.54429042555219,{"$f":"VLOOKUP($B16,'Bank Analysis'!$O$52:$R$71,4,0)","v":0.37137083069266424}]
[null,"Livestock",61,2207.696260711607,{"$f":"VLOOKUP($B17,'Bank Analysis'!$O$52:$R$71,4,0)","v":36.191741978878802}]
[null,"Manufacturing",386,86.413784120170746,{"$f":"VLOOKUP($B18,'Bank Analysis'!$O$52:$R$71,4,0)","v":0.22386990704707446}]
[null,"Mining",320,120.00195077636158,{"$f":"VLOOKUP($B19,'Bank Analysis'!$O$52:$R$71,4,0)","v":0.37500609617612995}]
[null,"Oil & Gas",1000,368.7910637428231,{"$f":"VLOOKUP($B20,'Bank Analysis'!$O$52:$R$71,4,0)","v":0.36879106374282311}]
[null,"Other Manufacturing",400,49.6513588412571,{"$f":"VLOOKUP($B21,'Bank Analysis'!$O$52:$R$71,4,0)","v":0.12412839710314275}]
[null,"Paper and celulose",335,96.069273200551478,{"$f":"VLOOKUP($B22,'Bank Analysis'!$O$52:$R$71,4,0)","v":0.28677394985239246}]
[null,"Petrochemicals",62,51.995951723490002,{"$f":"VLOOKUP($B23,'Bank Analysis'!$O$52:$R$71,4,0)","v":0.83864438263693553}]
[null,"Real Estate",50,1.1442296074736522,{"$f":"VLOOKUP($B24,'Bank Analysis'!$O$52:$R$71,4,0)","v":2.2884592149473044E-2}]
[null,"Siderurgy and Metalurgy",254,208.895684350251,{"$f":"VLOOKUP($B25,'Bank Analysis'!$O$52:$R$71,4,0)","v":0.82242395413484648}]
[null,"Telecommunications",50,2.2975188292901558,{"$f":"VLOOKUP($B26,'Bank Analysis'!$O$52:$R$71,4,0)","v":4.5950376585803115E-2}]
[null,"Transport",456,127.43399989990911,{"$f":"VLOOKUP($B27,'Bank Analysis'!$O$52:$R$71,4,0)","v":0.27946052609629191}]
[null,"Water",789,95.291214386670532,{"$f":"VLOOKUP($B28,'Bank Analysis'!$O$52:$R$71,4,0)","v":0.12077466969159764}]
[null,"Total",{"$f":"IFERROR(SUM($C$9:$C$28),\"\")","v":6974},{"$f":"IFERROR(SUM($D$9:$D$28),\"\")","v":7634.0835472633225}]

{"sheet":"Overview","index":1,"n_rows":44,"n_cols":11,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"The \"&'Bank Analysis'!$E$52&\" Sector receives the most credit.\"","v":"The Oil & Gas Sector receives the most credit."},null,null,null,null,null,null,null,null,{"$f":"\"The \"&'Bank Analysis'!$L$52&\" Sector causes the largest natural capital impact.\"","v":"The Fishing Sector causes the largest natural capital impact."}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"This bank's \"&'Bank Analysis'!$K$76&\" impact is the largest across its loan book.\"","v":"This bank's Land Use impact is the largest across its loan book."},null,null,null,null,null,null,null,null,{"$f":"\"The \"&'Bank Analysis'!$W$52&\" Sector causes the largest natural capital impact per unit of credit.\"","v":"The Livestock Sector causes the largest natural capital impact per unit of credit."}]

{"sheet":"Sectoral Analysis","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Indicator Analysis","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Summary Charts (3)","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Bank Analysis","index":5,"n_rows":234,"n_cols":28,"rows_kept":234,"cut":false,"hidden":true,"merged":[[25,15,25,17],[49,4,49,5],[49,11,49,12],[49,15,49,17]]}
[]
[]
["Row Labels","Sum of Credit Exposure (BRLm)","Sum of GHG Direct (BRLm)","Sum of GHG Indirect (BRLm)","Sum of Air Pollution Direct (BRLm)","Sum of Air Pollution Indirect (BRLm)","Sum of Waste Direct (BRLm)","Sum of Waste Indirect (BRLm)","Sum of Land Use Direct (BRLm)","Sum of Land Use Indirect (BRLm)","Sum of Water Direct (BRLm)","Sum of Water Indirect (BRLm)","Sum of Water Pollutants Direct (BRLm)","Sum of Water Pollutants Indirect (BRLm)"]
["Agriculture",56,4.4688997642526758,2.7347716769816537,1.3064066299351558,19.239491104266005,0.18180338118551126,1.6204649796423742,44.360821008708939,6.5335087388615394,0.16162938190790993,1.3164146553701863,10.203556598412074,1.170645889372224]
["Chemicals",600,257.02367584299094,142.8266816335836,1.4563120180384153,155.40901573320721,2.3964905811091519,93.121100437366579,3.5010137899408836E-2,41.81647375822638,0.89252965534155571,10.746443524027182,1.1773873345531708E-2,14.833234327545775]
["Construction",200,70.660480836214774,41.203787703084664,3.339051546631608,9.846214572422527,1.0009005497544614,23.983596149600203,3.3382728541464284E-2,5.1524996539993175,3.8190360269458955E-2,0.51998646629147927,7.6619135199712117E-4,1.3771411395600024]
["Energy",546,9.638361693926005E-2,20.797860474641407,5.494795896104848,8.7446777366960955,0.18819362157658115,52.741183148533096,3.8243266203065476,19.35983454233234,1.9585292950918558,0.63505787397734159,0,1.5614766586266269]
["Fishing",344,1.538293253621855E-5,43.543173698864912,0,14.017564731914025,3.7940736652309566,13.662736942414462,0,85.109735889589331,1712.4706244184574,491.06100410137884,0,123.41776099941599]
["Food and Beverage",91,1.9216433390616321,52.986736990025321,1.7340333169900374E-2,11.028847663329092,0.29953311287628942,5.8796715721925921,5.8165932017425447E-3,39.471123861202756,2.6696610545828012E-3,83.901022309798506,5.0414669415737335E-5,54.01555440544616]
["Forestry",470,11.505409557720775,8.0976072571330331,0.52914722468354847,4.1466822622735764,1.5029024758503999,6.4791131661667585,0,127.71733187315327,0,0.31087194211558949,0,14.255224666455236]
["Livestock",61,271.67915507501851,62.606357919958874,11.611457018060086,8.1459762364397736,0.5112467357047662,5.1215876312111712,1765.7250957884526,27.9335920197104,6.142753828239189E-3,10.23919005162292,0,44.116459481599897]
["Manufacturing",386,0.7331409802112,23.256514791711986,0.10174446297093176,17.058549930378504,1.8607476785234403,12.404832578046159,5.0827640460918783E-2,9.3925879706801858,4.5110591954420857E-3,13.020238000602221,0,8.5300890273897547]
["Mining",320,2.9145307097331727,20.148773703015795,6.0713642124050873,12.905483604481162,0.22745240341240089,21.752401985366596,46.234421985111013,7.4953345494976373,6.8324952634889496E-2,0.34934784028373511,0,1.8345148304200896]
["Oil & Gas",1000,37.490760892880822,35.808816851298175,0.30651573845905167,6.1079225825224146,0.37330511582555859,160.73617561374942,52.931848557053698,73.572541584017927,4.3399484941453244E-2,0.40716406006674416,3.2489614323539254E-4,1.0122883658645898]
["Other Manufacturing",400,0.57809321477957043,23.276093131358223,1.007888036716895E-2,9.5818903005874922,0.49708241706176548,10.647538598417642,1.1512566294116837E-2,3.0120191529685574,1.656870742188898E-4,0.48629658227113337,0,1.55058831007721]
["Paper and celulose",335,14.281256913647818,14.610220271000667,4.2049752148388198,44.183980100702328,0.50179424083429247,9.1664294535878419,3.9923890241171942E-3,4.4118464646927986,0.1734293028559184,0.73194007728354882,0.56749741810791476,3.2319113539754274]
["Petrochemicals",62,13.991169460780274,12.85555896081893,7.4212375263720848E-2,5.1950893604786508,9.1167018891906246E-2,10.056392746316599,1.3566855221497346E-4,6.1820880049796614,9.8298242554625964E-3,0.13745001876539473,2.0981420336580437E-3,3.4007601423535254]
["Real Estate",50,3.3781721697644658E-2,0.5749175172134835,4.4817910572874001E-5,0.16313855527135726,2.2090901088076529E-3,0.23455660241049128,6.5103729287331676E-6,8.101090955730697E-2,1.6298909200482262E-5,1.4210841176801593E-2,0,4.0336742845057047E-2]
["Siderurgy and Metalurgy",254.00000000000003,42.625311232851523,51.526502371645769,4.9639241771419895,13.476104095582357,1.2163328908076829,77.157106231184912,2.7139232626796874E-2,14.952529353567559,0.42489343155957832,0.6333626224538127,0.10810191382616333,1.7843767970029081]
["Telecommunications",50,3.8348115553156641E-2,0.84172372167094689,4.1989090975073077E-5,0.62275361121000705,6.4455707830440925E-3,0.45080134423753898,6.4467032667032346E-4,0.1896793983154888,1.5637867130249483E-4,3.4430281184276497E-2,0,0.11249374824674918]
["Transport",456,43.594372247488295,16.769893261541959,0.54945990466495254,5.4260435239723463,6.0402868338649815E-2,39.518776641822512,0.55355385737946494,17.422592026769035,2.8816026106484151E-3,2.1678291075814213,0,1.3681948577398495]
["Water",789,17.356565903228145,13.824936948824206,0.64168119172904059,30.541608096186142,0.15457776293379086,9.7921670808185226,0,3.3523304007779915,18.337037687361892,0.25745578694718707,0,1.0328535278636355]
["Automobiles",504,2.9970527227842649,102.36771880661067,8.7249698078452884E-2,40.902090291525731,2.0654669425569212,47.990998644777349,8.6339577188264405E-2,13.45355418887852,1.1637457706618573E-3,4.0504449829553444,3.1579653973765347E-4,6.8223984498944015]
["Grand Total",6974,793.99004753076701,690.65864769098425,40.765803329544312,416.7431240934468,16.932128123366379,602.51763154786295,1913.8848755315009,506.61221434177804,1734.5961249817919,621.02016112615365,10.894485244429728,285.46830372169512]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Direct and Indirect Environmental Impacts"]
[null,{"$f":"RIGHT(B3,LEN(B3)-7)","v":"Credit Exposure (BRLm)"},{"$f":"RIGHT(C3,LEN(C3)-7)","v":"GHG Direct (BRLm)"},"GHG Indirect (BRLm)","Air Pollution Direct (BRLm)","Air Pollution Indirect (BRLm)","Waste Direct (BRLm)","Waste Indirect (BRLm)","Land Use Direct (BRLm)","Land Use Indirect (BRLm)","Water Direct (BRLm)","Water Indirect (BRLm)","Water Pollutants Direct (BRLm)","Water Pollutants Indirect (BRLm)",null,null,"Total Direct","Total Indirect"]
[{"$f":"A4","v":"Agriculture"},56,4.4688997642526758,2.7347716769816537,1.3064066299351558,19.239491104266005,0.18180338118551126,1.6204649796423742,44.360821008708939,6.5335087388615394,0.16162938190790993,1.3164146553701863,10.203556598412074,1.170645889372224,null,{"$f":"L52","v":"Fishing"},{"$f":"SUMIF($A$28:$A$48,$P28,C$28:C$48)+SUMIF($A$28:$A$48,$P28,E$28:E$48)+SUMIF($A$28:$A$48,$P28,G$28:G$48)+SUMIF($A$28:$A$48,$P28,I$28:I$48)+SUMIF($A$28:$A$48,$P28,K$28:K$48)+SUMIF($A$28:$A$48,$P28,M$28:M$48)","v":1716.2647134666208},{"$f":"SUMIF($A$28:$A$48,$P28,D$28:D$48)+SUMIF($A$28:$A$48,$P28,F$28:F$48)+SUMIF($A$28:$A$48,$P28,H$28:H$48)+SUMIF($A$28:$A$48,$P28,J$28:J$48)+SUMIF($A$28:$A$48,$P28,L$28:L$48)+SUMIF($A$28:$A$48,$P28,N$28:N$48)","v":770.81197636357763}]
[{"$f":"A5","v":"Chemicals"},600,257.02367584299094,142.8266816335836,1.4563120180384153,155.40901573320721,2.3964905811091519,93.121100437366579,3.5010137899408836E-2,41.81647375822638,0.89252965534155571,10.746443524027182,1.1773873345531708E-2,14.833234327545775,null,"Livestock",2049.5330973710638,158.16316334054304]
[{"$f":"A6","v":"Construction"},200,70.660480836214774,41.203787703084664,3.339051546631608,9.846214572422527,1.0009005497544614,23.983596149600203,3.3382728541464284E-2,5.1524996539993175,3.8190360269458955E-2,0.51998646629147927,7.6619135199712117E-4,1.3771411395600024,null,"Chemicals",261.81579210872502,458.75294941395674]
[{"$f":"A7","v":"Energy"},546,9.638361693926005E-2,20.797860474641407,5.494795896104848,8.7446777366960955,0.18819362157658115,52.741183148533096,3.8243266203065476,19.35983454233234,1.9585292950918558,0.63505787397734159,0,1.5614766586266269,null,"Oil & Gas",91.146154685303827,277.64490905751927]
[{"$f":"A8","v":"Fishing"},344,1.538293253621855E-5,43.543173698864912,0,14.017564731914025,3.7940736652309566,13.662736942414462,0,85.109735889589331,1712.4706244184574,491.06100410137884,0,123.41776099941599,null,"Food and Beverage",2.2470534540335629,247.28295680199443]
[{"$f":"A9","v":"Food and Beverage"},91,1.9216433390616321,52.986736990025321,1.7340333169900374E-2,11.028847663329092,0.29953311287628942,5.8796715721925921,5.8165932017425447E-3,39.471123861202756,2.6696610545828012E-3,83.901022309798506,5.0414669415737335E-5,54.01555440544616,null,"Automobiles",5.2375884829183024,215.58720536464202]
[{"$f":"A10","v":"Forestry"},470,11.505409557720775,8.0976072571330331,0.52914722468354847,4.1466822622735764,1.5029024758503999,6.4791131661667585,0,127.71733187315327,0,0.31087194211558949,0,14.255224666455236,null,"Siderurgy and Metalurgy",{"$f":"SUMIF($A$28:$A$48,$P34,C$28:C$48)+SUMIF($A$28:$A$48,$P34,E$28:E$48)+SUMIF($A$28:$A$48,$P34,G$28:G$48)+SUMIF($A$28:$A$48,$P34,I$28:I$48)+SUMIF($A$28:$A$48,$P34,K$28:K$48)+SUMIF($A$28:$A$48,$P34,M$28:M$48)","v":49.365702878813735},159.52998147143734]
[{"$f":"A11","v":"Livestock"},61,271.67915507501851,62.606357919958874,11.611457018060086,8.1459762364397736,0.5112467357047662,5.1215876312111712,1765.7250957884526,27.9335920197104,6.142753828239189E-3,10.23919005162292,0,44.116459481599897,null,"Forestry",13.537459258254723,161.00683116729746]
[{"$f":"A12","v":"Manufacturing"},386,0.7331409802112,23.256514791711986,0.10174446297093176,17.058549930378504,1.8607476785234403,12.404832578046159,5.0827640460918783E-2,9.3925879706801858,4.5110591954420857E-3,13.020238000602221,0,8.5300890273897547,null,"Construction",75.072772212763766,82.08322568495818]
[{"$f":"A13","v":"Mining"},320,2.9145307097331727,20.148773703015795,6.0713642124050873,12.905483604481162,0.22745240341240089,21.752401985366596,46.234421985111013,7.4953345494976373,6.8324952634889496E-2,0.34934784028373511,0,1.8345148304200896,null,"Transport",44.760670480482005,82.673329419427134]
[{"$f":"A14","v":"Oil & Gas"},1000,37.490760892880822,35.808816851298175,0.30651573845905167,6.1079225825224146,0.37330511582555859,160.73617561374942,52.931848557053698,73.572541584017927,4.3399484941453244E-2,0.40716406006674416,3.2489614323539254E-4,1.0122883658645898,null,"Mining",55.516094263296566,64.485856513065002]
[{"$f":"A15","v":"Other Manufacturing"},400,0.57809321477957043,23.276093131358223,1.007888036716895E-2,9.5818903005874922,0.49708241706176548,10.647538598417642,1.1512566294116837E-2,3.0120191529685574,1.656870742188898E-4,0.48629658227113337,0,1.55058831007721,null,"Energy",11.562229050019093,103.84009043480691]
[{"$f":"A16","v":"Paper and celulose"},335,14.281256913647818,14.610220271000667,4.2049752148388198,44.183980100702328,0.50179424083429247,9.1664294535878419,3.9923890241171942E-3,4.4118464646927986,0.1734293028559184,0.73194007728354882,0.56749741810791476,3.2319113539754274,null,"Paper and celulose",19.732945479308881,76.336327721242625]
[{"$f":"A17","v":"Petrochemicals"},62,13.991169460780274,12.85555896081893,7.4212375263720848E-2,5.1950893604786508,9.1167018891906246E-2,10.056392746316599,1.3566855221497346E-4,6.1820880049796614,9.8298242554625964E-3,0.13745001876539473,2.0981420336580437E-3,3.4007601423535254,null,"Water",36.489862545252869,58.801351841417691]
[{"$f":"A18","v":"Real Estate"},50,3.3781721697644658E-2,0.5749175172134835,4.4817910572874001E-5,0.16313855527135726,2.2090901088076529E-3,0.23455660241049128,6.5103729287331676E-6,8.101090955730697E-2,1.6298909200482262E-5,1.4210841176801593E-2,0,4.0336742845057047E-2,null,"Agriculture",60.683116764402257,32.615297044493978]
[{"$f":"A19","v":"Siderurgy and Metalurgy"},254.00000000000003,42.625311232851523,51.526502371645769,4.9639241771419895,13.476104095582357,1.2163328908076829,77.157106231184912,2.7139232626796874E-2,14.952529353567559,0.42489343155957832,0.6333626224538127,0.10810191382616333,1.7843767970029081,null,"Manufacturing",2.750971821361933,83.662812298808802]
[{"$f":"A20","v":"Telecommunications"},50,3.8348115553156641E-2,0.84172372167094689,4.1989090975073077E-5,0.62275361121000705,6.4455707830440925E-3,0.45080134423753898,6.4467032667032346E-4,0.1896793983154888,1.5637867130249483E-4,3.4430281184276497E-2,0,0.11249374824674918,null,"Petrochemicals",{"$f":"SUMIF($A$28:$A$48,$P44,C$28:C$48)+SUMIF($A$28:$A$48,$P44,E$28:E$48)+SUMIF($A$28:$A$48,$P44,G$28:G$48)+SUMIF($A$28:$A$48,$P44,I$28:I$48)+SUMIF($A$28:$A$48,$P44,K$28:K$48)+SUMIF($A$28:$A$48,$P44,M$28:M$48)","v":14.168612489777235},{"$f":"SUMIF($A$28:$A$48,$P44,D$28:D$48)+SUMIF($A$28:$A$48,$P44,F$28:F$48)+SUMIF($A$28:$A$48,$P44,H$28:H$48)+SUMIF($A$28:$A$48,$P44,J$28:J$48)+SUMIF($A$28:$A$48,$P44,L$28:L$48)+SUMIF($A$28:$A$48,$P44,N$28:N$48)","v":37.827339233712756}]
[{"$f":"A21","v":"Transport"},456,43.594372247488295,16.769893261541959,0.54945990466495254,5.4260435239723463,6.0402868338649815E-2,39.518776641822512,0.55355385737946494,17.422592026769035,2.8816026106484151E-3,2.1678291075814213,0,1.3681948577398495,null,"Other Manufacturing",1.0969327655768406,48.554426075680247]
[{"$f":"A22","v":"Water"},789,17.356565903228145,13.824936948824206,0.64168119172904059,30.541608096186142,0.15457776293379086,9.7921670808185226,0,3.3523304007779915,18.337037687361892,0.25745578694718707,0,1.0328535278636355,null,"Telecommunications",4.5636724425148621E-2,2.2518821048650075]
[{"$f":"A23","v":"Automobiles"},504,2.9970527227842649,102.36771880661067,8.7249698078452884E-2,40.902090291525731,2.0654669425569212,47.990998644777349,8.6339577188264405E-2,13.45355418887852,1.1637457706618573E-3,4.0504449829553444,3.1579653973765347E-4,6.8223984498944015,null,"Real Estate",3.6058438999154403E-2,1.1081711684744975]
[{"$f":"A24","v":"Grand Total"},6974,793.99004753076701,690.65864769098425,40.765803329544312,416.7431240934468,16.932128123366379,602.51763154786295,1913.8848755315009,506.61221434177804,1734.5961249817919,621.02016112615365,10.894485244429728,285.46830372169512]
[]
[null,null,null,null,"Credit Exposure",null,null,null,null,null,null,"Total Environmental Impact",null,null,null,"Credit vs Total Environmental Impact vs CREX"]
["Super Sector",{"$f":"B27","v":"Credit Exposure (BRLm)"},"Rank",null,{"$f":"A51","v":"Super Sector"},{"$f":"B51","v":"Credit Exposure (BRLm)"},null,null,"Total Environmental Impact (BRLm)",null,null,{"$f":"A51","v":"Super Sector"},{"$f":"I51","v":"Total Environmental Impact (BRLm)"},null,null,{"$f":"B51","v":"Credit Exposure (BRLm)"},{"$f":"I51","v":"Total Environmental Impact (BRLm)"},"CREX",null,"CREX Ranking",null,null,"Sector","CREX"]
[{"$f":"A28","v":"Agriculture"},{"$f":"VLOOKUP(A52,'Summary Data'!$B$9:$C$28,2,0)","v":56},{"$f":"RANK(B52,$B$52:$B$71)+COUNTIF(B$52:B52,B52)-1","v":18},1,{"$f":"IFERROR(INDEX($A$52:$A$71,MATCH(D52,$C$52:$C$71,0)),\"\")","v":"Oil & Gas"},{"$f":"IFERROR(VLOOKUP(E52,$A$52:$B$71,2,0),\"\")","v":1000},null,{"$f":"A52","v":"Agriculture"},{"$f":"VLOOKUP(H52,'Summary Data'!$B$9:$D$28,3,0)","v":93.298413808896242},{"$f":"IF(I52>0,(RANK(I52,$I$52:$I$71)+COUNTIF(B$52:I52,I52)-1),\"\")","v":15},1,{"$f":"IFERROR(INDEX($H$52:$H$71,MATCH(K52,$J$52:$J$71,0)),\"\")","v":"Fishing"},{"$f":"IFERROR(VLOOKUP(L52,$H$52:$I$71,2,0),\"\")","v":2487.0766898301986},null,{"$f":"E52","v":"Oil & Gas"},{"$f":"IFERROR(VLOOKUP(O52,$A$52:$B$71,2,0),\"\")","v":1000},{"$f":"IFERROR(VLOOKUP(O52,$H$52:$I$72,2,0),\"\")","v":368.7910637428231},{"$f":"VLOOKUP(O52,$AA$52:$AB$71,2,0)","v":0.36879106374282311},null,{"$f":"RANK(R52,$R$52:$R$72)","v":12},null,1,{"$f":"INDEX($O$52:$O$71,MATCH(V52,$T$52:$T$71,0))","v":"Livestock"},{"$f":"VLOOKUP(W52,$O$52:$R$71,4,)","v":36.191741978878802},null,null,"Livestock",36.191741978878802]
["Chemicals",{"$f":"VLOOKUP(A53,'Summary Data'!$B$9:$C$28,2,0)","v":600},{"$f":"RANK(B53,$B$52:$B$71)+COUNTIF(B$52:B53,B53)-1","v":3},{"$f":"D52+1","v":2},"Water",789,null,"Chemicals",{"$f":"VLOOKUP(H53,'Summary Data'!$B$9:$D$28,3,0)","v":720.56874152268165},{"$f":"IF(I53>0,(RANK(I53,$I$52:$I$71)+COUNTIF(B$52:I53,I53)-1),\"\")","v":3},{"$f":"K52+1","v":2},"Livestock",2207.696260711607,null,"Water",789,95.291214386670532,0.12077466969159764,null,{"$f":"RANK(R53,$R$52:$R$72)","v":18},null,{"$f":"V52+1","v":2},{"$f":"INDEX($O$52:$O$71,MATCH(V53,$T$52:$T$71,0))","v":"Fishing"},{"$f":"VLOOKUP(W53,$O$52:$R$71,4,)","v":7.2298740983436005},null,null,"Fishing",7.2298740983436005]
["Construction",{"$f":"VLOOKUP(A54,'Summary Data'!$B$9:$C$28,2,0)","v":200},{"$f":"RANK(B54,$B$52:$B$71)+COUNTIF(B$52:B54,B54)-1","v":14},3,"Chemicals",600,null,"Construction",{"$f":"VLOOKUP(H54,'Summary Data'!$B$9:$D$28,3,0)","v":157.15599789772193},{"$f":"IF(I54>0,(RANK(I54,$I$52:$I$71)+COUNTIF(B$52:I54,I54)-1),\"\")","v":9},3,"Chemicals",720.56874152268165,null,"Chemicals",600,720.56874152268165,1.2009479025378027,null,5,null,{"$f":"V53+1","v":3},"Food and Beverage",2.7420880247915163,null,null,"Food and Beverage",2.7420880247915163]
["Energy",{"$f":"VLOOKUP(A55,'Summary Data'!$B$9:$C$28,2,0)","v":546},{"$f":"RANK(B55,$B$52:$B$71)+COUNTIF(B$52:B55,B55)-1","v":4},4,"Energy",546,null,"Energy",{"$f":"VLOOKUP(H55,'Summary Data'!$B$9:$D$28,3,0)","v":115.40231948482599},{"$f":"IF(I55>0,(RANK(I55,$I$52:$I$71)+COUNTIF(B$52:I55,I55)-1),\"\")","v":12},4,"Oil & Gas",368.7910637428231,null,"Energy",546,115.40231948482599,0.21135955949601831,null,16,null,4,"Agriculture",1.6660431037302901,null,null,"Agriculture",1.6660431037302901]
["Fishing",{"$f":"VLOOKUP(A56,'Summary Data'!$B$9:$C$28,2,0)","v":344},{"$f":"RANK(B56,$B$52:$B$71)+COUNTIF(B$52:B56,B56)-1","v":10},5,"Automobiles",504,null,"Fishing",{"$f":"VLOOKUP(H56,'Summary Data'!$B$9:$D$28,3,0)","v":2487.0766898301986},{"$f":"IF(I56>0,(RANK(I56,$I$52:$I$71)+COUNTIF(B$52:I56,I56)-1),\"\")","v":1},5,"Food and Beverage",249.53001025602799,null,"Automobiles",504,220.82479384756039,0.43814443223722299,null,9,null,5,"Chemicals",1.2009479025378027,null,null,"Chemicals",1.2009479025378027]
["Food and Beverage",{"$f":"VLOOKUP(A57,'Summary Data'!$B$9:$C$28,2,0)","v":91},{"$f":"RANK(B57,$B$52:$B$71)+COUNTIF(B$52:B57,B57)-1","v":15},6,"Forestry",470,null,"Food and Beverage",{"$f":"VLOOKUP(H57,'Summary Data'!$B$9:$D$28,3,0)","v":249.53001025602799},{"$f":"IF(I57>0,(RANK(I57,$I$52:$I$71)+COUNTIF(B$52:I57,I57)-1),\"\")","v":5},6,"Automobiles",220.82479384756039,null,"Forestry",470,174.54429042555219,0.37137083069266424,null,11,null,6,"Petrochemicals",0.83864438263693553,null,null,"Petrochemicals",0.83864438263693553]
["Forestry",{"$f":"VLOOKUP(A58,'Summary Data'!$B$9:$C$28,2,0)","v":470},{"$f":"RANK(B58,$B$52:$B$71)+COUNTIF(B$52:B58,B58)-1","v":6},7,"Transport",456,null,"Forestry",{"$f":"VLOOKUP(H58,'Summary Data'!$B$9:$D$28,3,0)","v":174.54429042555219},{"$f":"IF(I58>0,(RANK(I58,$I$52:$I$71)+COUNTIF(B$52:I58,I58)-1),\"\")","v":8},7,"Siderurgy and Metalurgy",208.895684350251,null,"Transport",456,127.43399989990911,0.27946052609629191,null,14,null,7,"Siderurgy and Metalurgy",0.82242395413484648,null,null,"Siderurgy and Metalurgy",0.82242395413484648]
["Livestock",{"$f":"VLOOKUP(A59,'Summary Data'!$B$9:$C$28,2,0)","v":61},{"$f":"RANK(B59,$B$52:$B$71)+COUNTIF(B$52:B59,B59)-1","v":17},8,"Other Manufacturing",400,null,"Livestock",{"$f":"VLOOKUP(H59,'Summary Data'!$B$9:$D$28,3,0)","v":2207.696260711607},{"$f":"IF(I59>0,(RANK(I59,$I$52:$I$71)+COUNTIF(B$52:I59,I59)-1),\"\")","v":2},8,"Forestry",174.54429042555219,null,"Other Manufacturing",400,49.6513588412571,0.12412839710314275,null,17,null,8,"Construction",0.78577998948860961,null,null,"Construction",0.78577998948860961]
["Manufacturing",{"$f":"VLOOKUP(A60,'Summary Data'!$B$9:$C$28,2,0)","v":386},{"$f":"RANK(B60,$B$52:$B$71)+COUNTIF(B$52:B60,B60)-1","v":9},9,"Manufacturing",386,null,"Manufacturing",{"$f":"VLOOKUP(H60,'Summary Data'!$B$9:$D$28,3,0)","v":86.413784120170746},{"$f":"IF(I60>0,(RANK(I60,$I$52:$I$71)+COUNTIF(B$52:I60,I60)-1),\"\")","v":16},9,"Construction",157.15599789772193,null,"Manufacturing",386,86.413784120170746,0.22386990704707446,null,15,null,9,"Automobiles",0.43814443223722299,null,null,"Automobiles",0.43814443223722299]
["Mining",{"$f":"VLOOKUP(A61,'Summary Data'!$B$9:$C$28,2,0)","v":320},{"$f":"RANK(B61,$B$52:$B$71)+COUNTIF(B$52:B61,B61)-1","v":12},10,"Fishing",344,null,"Mining",{"$f":"VLOOKUP(H61,'Summary Data'!$B$9:$D$28,3,0)","v":120.00195077636158},{"$f":"IF(I61>0,(RANK(I61,$I$52:$I$71)+COUNTIF(B$52:I61,I61)-1),\"\")","v":11},10,"Transport",127.43399989990911,null,"Fishing",344,2487.0766898301986,7.2298740983436005,null,2,null,10,"Mining",0.37500609617612995,null,null,"Mining",0.37500609617612995]
["Oil & Gas",{"$f":"VLOOKUP(A62,'Summary Data'!$B$9:$C$28,2,0)","v":1000},{"$f":"RANK(B62,$B$52:$B$71)+COUNTIF(B$52:B62,B62)-1","v":1},11,"Paper and celulose",335,null,"Oil & Gas",{"$f":"VLOOKUP(H62,'Summary Data'!$B$9:$D$28,3,0)","v":368.7910637428231},{"$f":"IF(I62>0,(RANK(I62,$I$52:$I$71)+COUNTIF(B$52:I62,I62)-1),\"\")","v":4},11,"Mining",120.00195077636158,null,"Paper and celulose",335,96.069273200551478,0.28677394985239246,null,13,null,11,"Forestry",0.37137083069266424,null,null,"Forestry",0.37137083069266424]
["Other Manufacturing",{"$f":"VLOOKUP(A63,'Summary Data'!$B$9:$C$28,2,0)","v":400},{"$f":"RANK(B63,$B$52:$B$71)+COUNTIF(B$52:B63,B63)-1","v":8},12,"Mining",320,null,"Other Manufacturing",{"$f":"VLOOKUP(H63,'Summary Data'!$B$9:$D$28,3,0)","v":49.6513588412571},{"$f":"IF(I63>0,(RANK(I63,$I$52:$I$71)+COUNTIF(B$52:I63,I63)-1),\"\")","v":18},12,"Energy",115.40231948482599,null,"Mining",320,120.00195077636158,0.37500609617612995,null,10,null,12,"Oil & Gas",0.36879106374282311,null,null,"Oil & Gas",0.36879106374282311]
["Paper and celulose",{"$f":"VLOOKUP(A64,'Summary Data'!$B$9:$C$28,2,0)","v":335},{"$f":"RANK(B64,$B$52:$B$71)+COUNTIF(B$52:B64,B64)-1","v":11},13,"Siderurgy and Metalurgy",254,null,"Paper and celulose",{"$f":"VLOOKUP(H64,'Summary Data'!$B$9:$D$28,3,0)","v":96.069273200551478},{"$f":"IF(I64>0,(RANK(I64,$I$52:$I$71)+COUNTIF(B$52:I64,I64)-1),\"\")","v":13},13,"Paper and celulose",96.069273200551478,null,"Siderurgy and Metalurgy",254,208.895684350251,0.82242395413484648,null,7,null,13,"Paper and celulose",0.28677394985239246,null,null,"Paper and celulose",0.28677394985239246]
["Petrochemicals",{"$f":"VLOOKUP(A65,'Summary Data'!$B$9:$C$28,2,0)","v":62},{"$f":"RANK(B65,$B$52:$B$71)+COUNTIF(B$52:B65,B65)-1","v":16},14,"Construction",200,null,"Petrochemicals",{"$f":"VLOOKUP(H65,'Summary Data'!$B$9:$D$28,3,0)","v":51.995951723490002},{"$f":"IF(I65>0,(RANK(I65,$I$52:$I$71)+COUNTIF(B$52:I65,I65)-1),\"\")","v":17},14,"Water",95.291214386670532,null,"Construction",200,157.15599789772193,0.78577998948860961,null,8,null,14,"Transport",0.27946052609629191,null,null,"Transport",0.27946052609629191]
["Real Estate",{"$f":"VLOOKUP(A66,'Summary Data'!$B$9:$C$28,2,0)","v":50},{"$f":"RANK(B66,$B$52:$B$71)+COUNTIF(B$52:B66,B66)-1","v":19},15,"Food and Beverage",91,null,"Real Estate",{"$f":"VLOOKUP(H66,'Summary Data'!$B$9:$D$28,3,0)","v":1.1442296074736522},{"$f":"IF(I66>0,(RANK(I66,$I$52:$I$71)+COUNTIF(B$52:I66,I66)-1),\"\")","v":20},15,"Agriculture",93.298413808896242,null,"Food and Beverage",91,249.53001025602799,2.7420880247915163,null,3,null,15,"Manufacturing",0.22386990704707446,null,null,"Manufacturing",0.22386990704707446]
["Siderurgy and Metalurgy",{"$f":"VLOOKUP(A67,'Summary Data'!$B$9:$C$28,2,0)","v":254},{"$f":"RANK(B67,$B$52:$B$71)+COUNTIF(B$52:B67,B67)-1","v":13},16,"Petrochemicals",62,null,"Siderurgy and Metalurgy",{"$f":"VLOOKUP(H67,'Summary Data'!$B$9:$D$28,3,0)","v":208.895684350251},{"$f":"IF(I67>0,(RANK(I67,$I$52:$I$71)+COUNTIF(B$52:I67,I67)-1),\"\")","v":7},16,"Manufacturing",86.413784120170746,null,"Petrochemicals",62,51.995951723490002,0.83864438263693553,null,6,null,16,"Energy",0.21135955949601831,null,null,"Energy",0.21135955949601831]
["Telecommunications",{"$f":"VLOOKUP(A68,'Summary Data'!$B$9:$C$28,2,0)","v":50},{"$f":"RANK(B68,$B$52:$B$71)+COUNTIF(B$52:B68,B68)-1","v":20},17,"Livestock",61,null,"Telecommunications",{"$f":"VLOOKUP(H68,'Summary Data'!$B$9:$D$28,3,0)","v":2.2975188292901558},{"$f":"IF(I68>0,(RANK(I68,$I$52:$I$71)+COUNTIF(B$52:I68,I68)-1),\"\")","v":19},17,"Petrochemicals",51.995951723490002,null,"Livestock",61,2207.696260711607,36.191741978878802,null,1,null,17,"Other Manufacturing",0.12412839710314275,null,null,"Other Manufacturing",0.12412839710314275]
["Transport",{"$f":"VLOOKUP(A69,'Summary Data'!$B$9:$C$28,2,0)","v":456},{"$f":"RANK(B69,$B$52:$B$71)+COUNTIF(B$52:B69,B69)-1","v":7},18,"Agriculture",56,null,"Transport",{"$f":"VLOOKUP(H69,'Summary Data'!$B$9:$D$28,3,0)","v":127.43399989990911},{"$f":"IF(I69>0,(RANK(I69,$I$52:$I$71)+COUNTIF(B$52:I69,I69)-1),\"\")","v":10},18,"Other Manufacturing",49.6513588412571,null,"Agriculture",56,93.298413808896242,1.6660431037302901,null,4,null,18,"Water",0.12077466969159764,null,null,"Water",0.12077466969159764]
["Water",{"$f":"VLOOKUP(A70,'Summary Data'!$B$9:$C$28,2,0)","v":789},{"$f":"RANK(B70,$B$52:$B$71)+COUNTIF(B$52:B70,B70)-1","v":2},19,"Real Estate",50,null,"Water",{"$f":"VLOOKUP(H70,'Summary Data'!$B$9:$D$28,3,0)","v":95.291214386670532},{"$f":"IF(I70>0,(RANK(I70,$I$52:$I$71)+COUNTIF(B$52:I70,I70)-1),\"\")","v":14},19,"Telecommunications",2.2975188292901558,null,"Real Estate",50,1.1442296074736522,2.2884592149473044E-2,null,20,null,19,"Telecommunications",4.5950376585803115E-2,null,null,"Telecommunications",4.5950376585803115E-2]
["Automobiles",{"$f":"VLOOKUP(A71,'Summary Data'!$B$9:$C$28,2,0)","v":504},{"$f":"RANK(B71,$B$52:$B$71)+COUNTIF(B$52:B71,B71)-1","v":5},20,"Telecommunications",50,null,"Automobiles",{"$f":"VLOOKUP(H71,'Summary Data'!$B$9:$D$28,3,0)","v":220.82479384756039},{"$f":"IF(I71>0,(RANK(I71,$I$52:$I$71)+COUNTIF(B$52:I71,I71)-1),\"\")","v":6},20,"Real Estate",1.1442296074736522,null,"Telecommunications",50,2.2975188292901558,4.5950376585803115E-2,null,19,null,20,"Real Estate",2.2884592149473044E-2,null,null,"Real Estate",2.2884592149473044E-2]
["Grand Total",{"$f":"SUM(B52:B71)","v":6974},null,null,null,null,null,"Grand Total",{"$f":"SUM(I52:I71)","v":7634.0835472633225},null,null,null,null,null,null,"","",{"$f":"IFERROR(Q72/P72,\"\")","v":""}]
[]
["Total Impact",{"$f":"RANK(B95,$B$95:$G$95)","v":3},{"$f":"RANK(C95,$B$95:$G$95)","v":5},4,1,2,6]
[null,"Total GHG","Total Air Pollution","Total Waste","Total Land Use","Total Water","Total Water Pollution","Total Environmental Impact",null,null,"Natural Capital Indicator","Natural Capital Impact (BRLm)"]
[{"$f":"L52","v":"Fishing"},{"$f":"SUMIF($A$28:$A$48,$A76,$C$28:$C$48)+SUMIF($A$28:$A$48,$A76,$D$28:$D$48)","v":43.543189081797451},{"$f":"SUMIF($A$28:$A$48,$A76,$E$28:$E$48)+SUMIF($A$28:$A$48,$A76,$F$28:$F$48)","v":14.017564731914025},{"$f":"SUMIF($A$28:$A$48,$A76,$G$28:$G$48)+SUMIF($A$28:$A$48,$A76,$H$28:$H$48)","v":17.456810607645419},{"$f":"SUMIF($A$28:$A$48,$A76,$I$28:$I$48)+SUMIF($A$28:$A$48,$A76,$J$28:$J$48)","v":85.109735889589331},{"$f":"SUMIF($A$28:$A$48,$A76,$K$28:$K$48)+SUMIF($A$28:$A$48,$A76,$L$28:$L$48)","v":2203.5316285198364},{"$f":"SUMIF($A$28:$A$48,$A76,$M$28:$M$48)+SUMIF($A$28:$A$48,$A76,$N$28:$N$48)","v":123.41776099941599},{"$f":"SUM(B76:G76)","v":2487.0766898301986},null,1,{"$f":"RIGHT(HLOOKUP(J76,$B$74:$G$75,2,),LEN(HLOOKUP(J76,$B$74:$G$75,2,))-6)","v":"Land Use"},{"$f":"HLOOKUP(\"Total \"&K76,$B$75:$G$95,21,0)","v":2420.497089873279}]
["Livestock",{"$f":"SUMIF($A$28:$A$48,$A77,$C$28:$C$48)+SUMIF($A$28:$A$48,$A77,$D$28:$D$48)","v":334.28551299497741},{"$f":"SUMIF($A$28:$A$48,$A77,$E$28:$E$48)+SUMIF($A$28:$A$48,$A77,$F$28:$F$48)","v":19.757433254499858},{"$f":"SUMIF($A$28:$A$48,$A77,$G$28:$G$48)+SUMIF($A$28:$A$48,$A77,$H$28:$H$48)","v":5.6328343669159375},{"$f":"SUMIF($A$28:$A$48,$A77,$I$28:$I$48)+SUMIF($A$28:$A$48,$A77,$J$28:$J$48)","v":1793.658687808163},{"$f":"SUMIF($A$28:$A$48,$A77,$K$28:$K$48)+SUMIF($A$28:$A$48,$A77,$L$28:$L$48)","v":10.245332805451159},{"$f":"SUMIF($A$28:$A$48,$A77,$M$28:$M$48)+SUMIF($A$28:$A$48,$A77,$N$28:$N$48)","v":44.116459481599897},2207.6962607116075,null,{"$f":"J76+1","v":2},{"$f":"RIGHT(HLOOKUP(J77,$B$74:$G$75,2,),LEN(HLOOKUP(J77,$B$74:$G$75,2,))-6)","v":"Water"},{"$f":"HLOOKUP(\"Total \"&K77,$B$75:$G$95,21,0)","v":2355.6162861079456}]
["Chemicals",399.85035747657457,156.86532775124562,95.517591018475727,41.851483896125785,11.638973179368737,14.845008200891307,720.56874152268165,null,{"$f":"J77+1","v":3},"GHG",1484.6486952217513]
["Oil & Gas",73.299577744179004,6.4144383209814659,161.10948072957498,126.50439014107162,0.4505635450081974,1.0126132620078252,368.7910637428231,null,4,"Waste",619.44975967122934]
["Food and Beverage",54.908380329086953,11.046187996498992,6.1792046850688811,39.476940454404499,83.903691970853089,54.015604820115577,249.53001025602799,null,5,"Air Pollution",457.50892742299112]
["Automobiles",105.36477152939493,40.989339989604183,50.056465587334273,13.539893766066784,4.0516087287260065,6.8227142464341393,220.82479384756033,null,6,"Water Pollution",296.36278896612487]
["Siderurgy and Metalurgy",94.151813604497292,18.440028272724348,78.37343912199259,14.979668586194355,1.058256054013391,1.8924787108290715,208.89568435025103]
["Forestry",19.60301681485381,4.6758294869571246,7.9820156420171582,127.71733187315327,0.31087194211558949,14.255224666455236,174.54429042555219]
["Construction",111.86426853929945,13.185266119054134,24.984496699354665,5.1858823825407816,0.55817682656093826,1.3779073309119996,157.15599789772193]
["Transport",60.364265509030254,5.9755034286372988,39.579179510161161,17.976145884148501,2.1707107101920697,1.3681948577398495,127.43399989990914]
["Mining",23.06330441274897,18.976847816886249,21.979854388778996,53.729756534608647,0.41767279291862458,1.8345148304200896,120.00195077636157]
["Energy",20.894244091580667,14.239473632800944,52.929376770109677,23.184161162638887,2.5935871690691972,1.5614766586266269,115.40231948482599]
["Paper and celulose",28.891477184648487,48.388955315541146,9.6682236944221351,4.4158388537169158,0.90536938013946722,3.7994087720833423,96.069273200551493]
["Water",31.181502852052351,31.183289287915184,9.9467448437523132,3.3523304007779915,18.594493474309079,1.0328535278636355,95.291214386670546]
["Agriculture",7.203671441234329,20.545897734201162,1.8022683608278856,50.894329747570481,1.4780440372780963,11.374202487784299,93.298413808896257]
["Manufacturing",23.989655771923186,17.160294393349435,14.265580256569599,9.4434156111411038,13.024749059797664,8.5300890273897547,86.413784120170732]
["Petrochemicals",26.846728421599202,5.2693017357423715,10.147559765208504,6.1822236735318761,0.14727984302085734,3.4028582843871833,51.995951723490002]
["Other Manufacturing",23.854186346137794,9.5919691809546617,11.144621015479407,3.0235317192626741,0.48646226934535225,1.55058831007721,49.6513588412571]
["Telecommunications",0.88007183722410354,0.62279560030098213,0.45724691502058307,0.19032406864215912,3.4586659855578988E-2,0.11249374824674918,2.2975188292901563]
["Grand Total",1484.6486952217513,457.50892742299112,619.44975967122934,2420.497089873279,2355.6162861079456,296.36278896612487,7634.0835472633207]
[]
[]
[null,{"$f":"$B75","v":"Total GHG"},"Rank",null,null,"Super Sector",{"$f":"RIGHT(B98,LEN(B98)-6)","v":"GHG"}]
[{"$f":"$A76","v":"Fishing"},{"$f":"$B$76","v":43.543189081797451},{"$f":"RANK(B99,B$99:B$117,0)","v":9},null,1,{"$f":"IFERROR(INDEX($A$99:$A$118,MATCH(E99,$C$99:$C$118,0)),\"\")","v":"Chemicals"},{"$f":"VLOOKUP(F99,$A$99:$B$118,2,0)","v":399.85035747657457}]
["Livestock",{"$f":"$B$77","v":334.28551299497741},{"$f":"RANK(B100,B$99:B$117,0)","v":2},null,{"$f":"E99+1","v":2},"Livestock",334.28551299497741]
["Chemicals",{"$f":"$B$78","v":399.85035747657457},1,null,3,"Construction",111.86426853929945]
["Oil & Gas",{"$f":"$B$79","v":73.299577744179004},6,null,4,"Automobiles",105.36477152939493]
["Food and Beverage",{"$f":"$B$80","v":54.908380329086953},8,null,5,"Siderurgy and Metalurgy",94.151813604497292]
["Automobiles",{"$f":"$B$81","v":105.36477152939493},4,null,6,"Oil & Gas",73.299577744179004]
["Siderurgy and Metalurgy",{"$f":"$B$82","v":94.151813604497292},5,null,7,"Transport",60.364265509030254]
["Forestry",{"$f":"$B$83","v":19.60301681485381},17,null,8,"Food and Beverage",54.908380329086953]
["Construction",{"$f":"$B$84","v":111.86426853929945},3,null,9,"Fishing",43.543189081797451]
["Transport",{"$f":"$B$85","v":60.364265509030254},7,null,10,"Water",31.181502852052351]
["Mining",{"$f":"$B$86","v":23.06330441274897},15,null,11,"Paper and celulose",28.891477184648487]
["Energy",{"$f":"$B$87","v":20.894244091580667},16,null,12,"Petrochemicals",26.846728421599202]
["Paper and celulose",{"$f":"$B$88","v":28.891477184648487},11,null,13,"Manufacturing",23.989655771923186]
["Water",{"$f":"$B$89","v":31.181502852052351},10,null,14,"Other Manufacturing",23.854186346137794]
["Agriculture",{"$f":"$B$90","v":7.203671441234329},18,null,15,"Mining",23.06330441274897]
["Manufacturing",{"$f":"$B$91","v":23.989655771923186},13,null,16,"Energy",20.894244091580667]
["Petrochemicals",{"$f":"$B$92","v":26.846728421599202},12,null,17,"Forestry",19.60301681485381]
["Other Manufacturing",{"$f":"$B$93","v":23.854186346137794},14,null,18,"Agriculture",7.203671441234329]
["Telecommunications",{"$f":"$B$94","v":0.88007183722410354},19,null,19,"Telecommunications",0.88007183722410354]
["Grand Total",{"$f":"$B$95","v":1484.6486952217513},null,null,20,"",{"$error":"#N/A"}]
[0,{"$f":"$B$96","v":0}]
[]
[null,{"$f":"$C$75","v":"Total Air Pollution"},"Rank",null,null,"Super Sector",{"$f":"RIGHT(B121,LEN(B121)-6)","v":"Air Pollution"}]
[{"$f":"$A99","v":"Fishing"},{"$f":"$C$76","v":14.017564731914025},{"$f":"RANK(B122,$B$122:$B$140,0)","v":11},null,1,{"$f":"IFERROR(INDEX($A$122:$A$141,MATCH(E122,$C$122:$C$141,0)),\"\")","v":"Chemicals"},{"$f":"VLOOKUP(F122,$A122:$B141,2,0)","v":156.86532775124562}]
["Livestock",{"$f":"$C$77","v":19.757433254499858},{"$f":"RANK(B123,$B$122:$B$140,0)","v":6},null,{"$f":"E122+1","v":2},"Paper and celulose",{"$f":"VLOOKUP(F123,$A122:$B141,2,0)","v":48.388955315541146}]
["Chemicals",{"$f":"$C$78","v":156.86532775124562},1,null,3,"Automobiles",{"$f":"VLOOKUP(F124,$A122:$B141,2,0)","v":40.989339989604183}]
["Oil & Gas",{"$f":"$C$79","v":6.4144383209814659},15,null,4,"Water",{"$f":"VLOOKUP(F125,$A122:$B141,2,0)","v":31.183289287915184}]
["Food and Beverage",{"$f":"$C$80","v":11.046187996498992},13,null,5,"Agriculture",{"$f":"VLOOKUP(F126,$A122:$B141,2,0)","v":20.545897734201162}]
["Automobiles",{"$f":"$C$81","v":40.989339989604183},3,null,6,"Livestock",{"$f":"VLOOKUP(F127,$A122:$B141,2,0)","v":19.757433254499858}]
["Siderurgy and Metalurgy",{"$f":"$C$82","v":18.440028272724348},8,null,7,"Mining",{"$f":"VLOOKUP(F128,$A122:$B141,2,0)","v":18.976847816886249}]
["Forestry",{"$f":"$C$83","v":4.6758294869571246},18,null,8,"Siderurgy and Metalurgy",{"$f":"VLOOKUP(F129,$A122:$B141,2,0)","v":18.440028272724348}]
["Construction",{"$f":"$C$84","v":13.185266119054134},12,null,9,"Manufacturing",{"$f":"VLOOKUP(F130,$A122:$B141,2,0)","v":17.160294393349435}]
["Transport",{"$f":"$C$85","v":5.9755034286372988},16,null,10,"Energy",{"$f":"VLOOKUP(F131,$A122:$B141,2,0)","v":14.239473632800944}]
["Mining",{"$f":"$C$86","v":18.976847816886249},7,null,11,"Fishing",{"$f":"VLOOKUP(F132,$A122:$B141,2,0)","v":14.017564731914025}]
["Energy",{"$f":"$C$87","v":14.239473632800944},10,null,12,"Construction",{"$f":"VLOOKUP(F133,$A122:$B141,2,0)","v":13.185266119054134}]
["Paper and celulose",{"$f":"$C$88","v":48.388955315541146},2,null,13,"Food and Beverage",{"$f":"VLOOKUP(F134,$A122:$B141,2,0)","v":11.046187996498992}]
["Water",{"$f":"$C$89","v":31.183289287915184},4,null,14,"Other Manufacturing",{"$f":"VLOOKUP(F135,$A122:$B141,2,0)","v":9.5919691809546617}]
["Agriculture",{"$f":"$C$90","v":20.545897734201162},5,null,15,"Oil & Gas",{"$f":"VLOOKUP(F136,$A122:$B141,2,0)","v":6.4144383209814659}]
["Manufacturing",{"$f":"$C$91","v":17.160294393349435},9,null,16,"Transport",{"$f":"VLOOKUP(F137,$A122:$B141,2,0)","v":5.9755034286372988}]
["Petrochemicals",{"$f":"$C$92","v":5.2693017357423715},17,null,17,"Petrochemicals",{"$f":"VLOOKUP(F138,$A122:$B141,2,0)","v":5.2693017357423715}]
["Other Manufacturing",{"$f":"$C$93","v":9.5919691809546617},14,null,18,"Forestry",{"$f":"VLOOKUP(F139,$A123:$B142,2,0)","v":4.6758294869571246}]
["Telecommunications",{"$f":"$C$94","v":0.62279560030098213},19,null,19,"Telecommunications",{"$f":"VLOOKUP(F140,$A124:$B143,2,0)","v":0.62279560030098213}]
["Grand Total",{"$f":"$C$95","v":457.50892742299112},null,null,20,"",{"$f":"VLOOKUP(F141,$A125:$B144,2,0)","v":{"$error":"#N/A"}}]
[0,{"$f":"$C$96","v":0}]
[]
[null,{"$f":"$D$75","v":"Total Waste"},"Rank",null,null,"Super Sector",{"$f":"RIGHT(B144,LEN(B144)-6)","v":"Waste"}]
[{"$f":"$A122","v":"Fishing"},{"$f":"$D$76","v":17.456810607645419},{"$f":"RANK(B145,$B$145:$B$163,0)","v":9},null,1,{"$f":"IFERROR(INDEX($A$145:$A$164,MATCH(E145,$C$145:$C$164,0)),\"\")","v":"Oil & Gas"},{"$f":"VLOOKUP(F145,$A145:$B164,2,0)","v":161.10948072957498}]
["Livestock",{"$f":"$D$77","v":5.6328343669159375},{"$f":"RANK(B146,$B$145:$B$163,0)","v":17},null,{"$f":"E145+1","v":2},"Chemicals",{"$f":"VLOOKUP(F146,$A145:$B164,2,0)","v":95.517591018475727}]
["Chemicals",{"$f":"$D$78","v":95.517591018475727},2,null,3,"Siderurgy and Metalurgy",{"$f":"VLOOKUP(F147,$A145:$B164,2,0)","v":78.37343912199259}]
["Oil & Gas",{"$f":"$D$79","v":161.10948072957498},1,null,4,"Energy",{"$f":"VLOOKUP(F148,$A145:$B164,2,0)","v":52.929376770109677}]
["Food and Beverage",{"$f":"$D$80","v":6.1792046850688811},16,null,5,"Automobiles",{"$f":"VLOOKUP(F149,$A145:$B164,2,0)","v":50.056465587334273}]
["Automobiles",{"$f":"$D$81","v":50.056465587334273},5,null,6,"Transport",{"$f":"VLOOKUP(F150,$A145:$B164,2,0)","v":39.579179510161161}]
["Siderurgy and Metalurgy",{"$f":"$D$82","v":78.37343912199259},3,null,7,"Construction",{"$f":"VLOOKUP(F151,$A145:$B164,2,0)","v":24.984496699354665}]
["Forestry",{"$f":"$D$83","v":7.9820156420171582},15,null,8,"Mining",{"$f":"VLOOKUP(F152,$A145:$B164,2,0)","v":21.979854388778996}]
["Construction",{"$f":"$D$84","v":24.984496699354665},7,null,9,"Fishing",{"$f":"VLOOKUP(F153,$A145:$B164,2,0)","v":17.456810607645419}]
["Transport",{"$f":"$D$85","v":39.579179510161161},6,null,10,"Manufacturing",{"$f":"VLOOKUP(F154,$A145:$B164,2,0)","v":14.265580256569599}]
["Mining",{"$f":"$D$86","v":21.979854388778996},8,null,11,"Other Manufacturing",{"$f":"VLOOKUP(F155,$A145:$B164,2,0)","v":11.144621015479407}]
["Energy",{"$f":"$D$87","v":52.929376770109677},4,null,12,"Petrochemicals",{"$f":"VLOOKUP(F156,$A145:$B164,2,0)","v":10.147559765208504}]
["Paper and celulose",{"$f":"$D$88","v":9.6682236944221351},14,null,13,"Water",{"$f":"VLOOKUP(F157,$A145:$B164,2,0)","v":9.9467448437523132}]
["Water",{"$f":"$D$89","v":9.9467448437523132},13,null,14,"Paper and celulose",{"$f":"VLOOKUP(F158,$A145:$B164,2,0)","v":9.6682236944221351}]
["Agriculture",{"$f":"$D$90","v":1.8022683608278856},18,null,15,"Forestry",{"$f":"VLOOKUP(F159,$A145:$B164,2,0)","v":7.9820156420171582}]
["Manufacturing",{"$f":"$D$91","v":14.265580256569599},10,null,16,"Food and Beverage",{"$f":"VLOOKUP(F160,$A145:$B164,2,0)","v":6.1792046850688811}]
["Petrochemicals",{"$f":"$D$92","v":10.147559765208504},12,null,17,"Livestock",{"$f":"VLOOKUP(F161,$A145:$B164,2,0)","v":5.6328343669159375}]
["Other Manufacturing",{"$f":"$D$93","v":11.144621015479407},11,null,18,"Agriculture",{"$f":"VLOOKUP(F162,$A146:$B165,2,0)","v":1.8022683608278856}]
["Telecommunications",{"$f":"$D$94","v":0.45724691502058307},19,null,19,"Telecommunications",{"$f":"VLOOKUP(F163,$A147:$B166,2,0)","v":0.45724691502058307}]
["Grand Total",{"$f":"$D$95","v":619.44975967122934}]
[0,{"$f":"$D$96","v":0}]
[]
[null,{"$f":"$E$75","v":"Total Land Use"},"Rank",null,null,"Super Sector",{"$f":"RIGHT(B167,LEN(B167)-6)","v":"Land Use"}]
[{"$f":"$A145","v":"Fishing"},{"$f":"$E$76","v":85.109735889589331},{"$f":"RANK(B168,$B$168:$B$186,0)","v":4},null,1,{"$f":"IFERROR(INDEX($A$168:$A$187,MATCH(E168,$C$168:$C$187,0)),\"\")","v":"Livestock"},{"$f":"VLOOKUP(F168,$A168:$B187,2,0)","v":1793.658687808163}]
["Livestock",{"$f":"$E$77","v":1793.658687808163},{"$f":"RANK(B169,$B$168:$B$186,0)","v":1},null,{"$f":"E168+1","v":2},"Forestry",{"$f":"VLOOKUP(F169,$A168:$B187,2,0)","v":127.71733187315327}]
["Chemicals",{"$f":"$E$78","v":41.851483896125785},7,null,3,"Oil & Gas",{"$f":"VLOOKUP(F170,$A168:$B187,2,0)","v":126.50439014107162}]
["Oil & Gas",{"$f":"$E$79","v":126.50439014107162},3,null,4,"Fishing",{"$f":"VLOOKUP(F171,$A168:$B187,2,0)","v":85.109735889589331}]
["Food and Beverage",{"$f":"$E$80","v":39.476940454404499},8,null,5,"Mining",{"$f":"VLOOKUP(F172,$A168:$B187,2,0)","v":53.729756534608647}]
["Automobiles",{"$f":"$E$81","v":13.539893766066784},12,null,6,"Agriculture",{"$f":"VLOOKUP(F173,$A168:$B187,2,0)","v":50.894329747570481}]
["Siderurgy and Metalurgy",{"$f":"$E$82","v":14.979668586194355},11,null,7,"Chemicals",{"$f":"VLOOKUP(F174,$A168:$B187,2,0)","v":41.851483896125785}]
["Forestry",{"$f":"$E$83","v":127.71733187315327},2,null,8,"Food and Beverage",{"$f":"VLOOKUP(F175,$A168:$B187,2,0)","v":39.476940454404499}]
["Construction",{"$f":"$E$84","v":5.1858823825407816},15,null,9,"Energy",{"$f":"VLOOKUP(F176,$A168:$B187,2,0)","v":23.184161162638887}]
["Transport",{"$f":"$E$85","v":17.976145884148501},10,null,10,"Transport",{"$f":"VLOOKUP(F177,$A168:$B187,2,0)","v":17.976145884148501}]
["Mining",{"$f":"$E$86","v":53.729756534608647},5,null,11,"Siderurgy and Metalurgy",{"$f":"VLOOKUP(F178,$A168:$B187,2,0)","v":14.979668586194355}]
["Energy",{"$f":"$E$87","v":23.184161162638887},9,null,12,"Automobiles",{"$f":"VLOOKUP(F179,$A168:$B187,2,0)","v":13.539893766066784}]
["Paper and celulose",{"$f":"$E$88","v":4.4158388537169158},16,null,13,"Manufacturing",{"$f":"VLOOKUP(F180,$A168:$B187,2,0)","v":9.4434156111411038}]
["Water",{"$f":"$E$89","v":3.3523304007779915},17,null,14,"Petrochemicals",{"$f":"VLOOKUP(F181,$A168:$B187,2,0)","v":6.1822236735318761}]
["Agriculture",{"$f":"$E$90","v":50.894329747570481},6,null,15,"Construction",{"$f":"VLOOKUP(F182,$A168:$B187,2,0)","v":5.1858823825407816}]
["Manufacturing",{"$f":"$E$91","v":9.4434156111411038},13,null,16,"Paper and celulose",{"$f":"VLOOKUP(F183,$A168:$B187,2,0)","v":4.4158388537169158}]
["Petrochemicals",{"$f":"$E$92","v":6.1822236735318761},14,null,17,"Water",{"$f":"VLOOKUP(F184,$A168:$B187,2,0)","v":3.3523304007779915}]
["Other Manufacturing",{"$f":"$E$93","v":3.0235317192626741},18,null,18,"Other Manufacturing",{"$f":"VLOOKUP(F185,$A169:$B188,2,0)","v":3.0235317192626741}]
["Telecommunications",{"$f":"$E$94","v":0.19032406864215912},19,null,19,"Telecommunications",{"$f":"VLOOKUP(F186,$A170:$B189,2,0)","v":0.19032406864215912}]
["Grand Total",{"$f":"$E$95","v":2420.497089873279},null,null,20,"",{"$f":"VLOOKUP(F187,$A171:$B190,2,0)","v":{"$error":"#N/A"}}]
[0,{"$f":"$E$96","v":0}]
[]
[null,{"$f":"$F$75","v":"Total Water"},"Rank",null,null,"Super Sector",{"$f":"RIGHT(B190,LEN(B190)-6)","v":"Water"}]
[{"$f":"$A168","v":"Fishing"},{"$f":"$F$76","v":2203.5316285198364},{"$f":"RANK(B191,$B$191:$B$209,0)","v":1},null,1,{"$f":"IFERROR(INDEX($A$191:$A$210,MATCH(E191,$C$191:$C$210,0)),\"\")","v":"Fishing"},{"$f":"VLOOKUP(F191,$A191:$B210,2,0)","v":2203.5316285198364}]
["Livestock",{"$f":"$F$77","v":10.245332805451159},{"$f":"RANK(B192,$B$191:$B$209,0)","v":6},null,{"$f":"E191+1","v":2},"Food and Beverage",{"$f":"VLOOKUP(F192,$A191:$B210,2,0)","v":83.903691970853089}]
["Chemicals",{"$f":"$F$78","v":11.638973179368737},5,null,3,"Water",{"$f":"VLOOKUP(F193,$A191:$B210,2,0)","v":18.594493474309079}]
["Oil & Gas",{"$f":"$F$79","v":0.4505635450081974},15,null,4,"Manufacturing",{"$f":"VLOOKUP(F194,$A191:$B210,2,0)","v":13.024749059797664}]
["Food and Beverage",{"$f":"$F$80","v":83.903691970853089},2,null,5,"Chemicals",{"$f":"VLOOKUP(F195,$A191:$B210,2,0)","v":11.638973179368737}]
["Automobiles",{"$f":"$F$81","v":4.0516087287260065},7,null,6,"Livestock",{"$f":"VLOOKUP(F196,$A191:$B210,2,0)","v":10.245332805451159}]
["Siderurgy and Metalurgy",{"$f":"$F$82","v":1.058256054013391},11,null,7,"Automobiles",{"$f":"VLOOKUP(F197,$A191:$B210,2,0)","v":4.0516087287260065}]
["Forestry",{"$f":"$F$83","v":0.31087194211558949},17,null,8,"Energy",{"$f":"VLOOKUP(F198,$A191:$B210,2,0)","v":2.5935871690691972}]
["Construction",{"$f":"$F$84","v":0.55817682656093826},13,null,9,"Transport",{"$f":"VLOOKUP(F199,$A191:$B210,2,0)","v":2.1707107101920697}]
["Transport",{"$f":"$F$85","v":2.1707107101920697},9,null,10,"Agriculture",{"$f":"VLOOKUP(F200,$A191:$B210,2,0)","v":1.4780440372780963}]
["Mining",{"$f":"$F$86","v":0.41767279291862458},16,null,11,"Siderurgy and Metalurgy",{"$f":"VLOOKUP(F201,$A191:$B210,2,0)","v":1.058256054013391}]
["Energy",{"$f":"$F$87","v":2.5935871690691972},8,null,12,"Paper and celulose",{"$f":"VLOOKUP(F202,$A191:$B210,2,0)","v":0.90536938013946722}]
["Paper and celulose",{"$f":"$F$88","v":0.90536938013946722},12,null,13,"Construction",{"$f":"VLOOKUP(F203,$A191:$B210,2,0)","v":0.55817682656093826}]
["Water",{"$f":"$F$89","v":18.594493474309079},3,null,14,"Other Manufacturing",{"$f":"VLOOKUP(F204,$A191:$B210,2,0)","v":0.48646226934535225}]
["Agriculture",{"$f":"$F$90","v":1.4780440372780963},10,null,15,"Oil & Gas",{"$f":"VLOOKUP(F205,$A191:$B210,2,0)","v":0.4505635450081974}]
["Manufacturing",{"$f":"$F$91","v":13.024749059797664},4,null,16,"Mining",{"$f":"VLOOKUP(F206,$A191:$B210,2,0)","v":0.41767279291862458}]
["Petrochemicals",{"$f":"$F$92","v":0.14727984302085734},18,null,17,"Forestry",{"$f":"VLOOKUP(F207,$A191:$B210,2,0)","v":0.31087194211558949}]
["Other Manufacturing",{"$f":"$F$93","v":0.48646226934535225},14,null,18,"Petrochemicals",{"$f":"VLOOKUP(F208,$A192:$B211,2,0)","v":0.14727984302085734}]
["Telecommunications",{"$f":"$F$94","v":3.4586659855578988E-2},19,null,19,"Telecommunications",{"$f":"VLOOKUP(F209,$A193:$B212,2,0)","v":3.4586659855578988E-2}]
["Grand Total",{"$f":"$F$95","v":2355.6162861079456},null,null,20,"",{"$f":"VLOOKUP(F210,$A194:$B213,2,0)","v":{"$error":"#N/A"}}]
[0,{"$f":"$F$96","v":0}]
[]
[null,{"$f":"$G$75","v":"Total Water Pollution"},"Rank",null,null,"Super Sector",{"$f":"RIGHT(B213,LEN(B213)-6)","v":"Water Pollution"}]
[{"$f":"$A191","v":"Fishing"},{"$f":"$G$76","v":123.41776099941599},{"$f":"RANK(B214,$B$214:$B$232,0)","v":1},null,1,{"$f":"IFERROR(INDEX($A$214:$A$233,MATCH(E214,$C$214:$C$233,0)),\"\")","v":"Fishing"},{"$f":"VLOOKUP(F214,$A214:$B233,2,0)","v":123.41776099941599}]
["Livestock",{"$f":"$G$77","v":44.116459481599897},{"$f":"RANK(B215,$B$214:$B$232,0)","v":3},null,{"$f":"E214+1","v":2},"Food and Beverage",{"$f":"VLOOKUP(F215,$A214:$B233,2,0)","v":54.015604820115577}]
["Chemicals",{"$f":"$G$78","v":14.845008200891307},4,null,3,"Livestock",{"$f":"VLOOKUP(F216,$A214:$B233,2,0)","v":44.116459481599897}]
["Oil & Gas",{"$f":"$G$79","v":1.0126132620078252},18,null,4,"Chemicals",{"$f":"VLOOKUP(F217,$A214:$B233,2,0)","v":14.845008200891307}]
["Food and Beverage",{"$f":"$G$80","v":54.015604820115577},2,null,5,"Forestry",{"$f":"VLOOKUP(F218,$A214:$B233,2,0)","v":14.255224666455236}]
["Automobiles",{"$f":"$G$81","v":6.8227142464341393},8,null,6,"Agriculture",{"$f":"VLOOKUP(F219,$A214:$B233,2,0)","v":11.374202487784299}]
["Siderurgy and Metalurgy",{"$f":"$G$82","v":1.8924787108290715},11,null,7,"Manufacturing",{"$f":"VLOOKUP(F220,$A214:$B233,2,0)","v":8.5300890273897547}]
["Forestry",{"$f":"$G$83","v":14.255224666455236},5,null,8,"Automobiles",{"$f":"VLOOKUP(F221,$A214:$B233,2,0)","v":6.8227142464341393}]
["Construction",{"$f":"$G$84","v":1.3779073309119996},15,null,9,"Paper and celulose",{"$f":"VLOOKUP(F222,$A214:$B233,2,0)","v":3.7994087720833423}]
["Transport",{"$f":"$G$85","v":1.3681948577398495},16,null,10,"Petrochemicals",{"$f":"VLOOKUP(F223,$A214:$B233,2,0)","v":3.4028582843871833}]
["Mining",{"$f":"$G$86","v":1.8345148304200896},12,null,11,"Siderurgy and Metalurgy",{"$f":"VLOOKUP(F224,$A214:$B233,2,0)","v":1.8924787108290715}]
["Energy",{"$f":"$G$87","v":1.5614766586266269},13,null,12,"Mining",{"$f":"VLOOKUP(F225,$A214:$B233,2,0)","v":1.8345148304200896}]
["Paper and celulose",{"$f":"$G$88","v":3.7994087720833423},9,null,13,"Energy",{"$f":"VLOOKUP(F226,$A214:$B233,2,0)","v":1.5614766586266269}]
["Water",{"$f":"$G$89","v":1.0328535278636355},17,null,14,"Other Manufacturing",{"$f":"VLOOKUP(F227,$A214:$B233,2,0)","v":1.55058831007721}]
["Agriculture",{"$f":"$G$90","v":11.374202487784299},6,null,15,"Construction",{"$f":"VLOOKUP(F228,$A214:$B233,2,0)","v":1.3779073309119996}]
["Manufacturing",{"$f":"$G$91","v":8.5300890273897547},7,null,16,"Transport",{"$f":"VLOOKUP(F229,$A214:$B233,2,0)","v":1.3681948577398495}]
["Petrochemicals",{"$f":"$G$92","v":3.4028582843871833},10,null,17,"Water",{"$f":"VLOOKUP(F230,$A214:$B233,2,0)","v":1.0328535278636355}]
["Other Manufacturing",{"$f":"$G$93","v":1.55058831007721},14,null,18,"Oil & Gas",{"$f":"VLOOKUP(F231,$A215:$B234,2,0)","v":1.0126132620078252}]
["Telecommunications",{"$f":"$G$94","v":0.11249374824674918},19,null,19,"Telecommunications",{"$f":"VLOOKUP(F232,$A216:$B235,2,0)","v":0.11249374824674918}]
["Grand Total",{"$f":"$G$95","v":296.36278896612487},null,null,20,"",{"$f":"VLOOKUP(F233,$A217:$B236,2,0)","v":{"$error":"#N/A"}}]
[0,{"$f":"$G$96","v":0}]

{"sheet":"Detailed lending data","index":6,"n_rows":45,"n_cols":16,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,2,{"$f":"E1+1","v":3},{"$f":"F1+1","v":4},5,6,7,8,9,10,11,12,13]
["Super Sector","Trucost Sector","Trucost Sector Number","Credit Exposure (BRLm)","GHG Direct (BRLm)","GHG Indirect (BRLm)","Air Pollution Direct (BRLm)","Air Pollution Indirect (BRLm)","Waste Direct (BRLm)","Waste Indirect (BRLm)","Land Use Direct (BRLm)","Land Use Indirect (BRLm)","Water Direct (BRLm)","Water Indirect (BRLm)","Water Pollutants Direct (BRLm)","Water Pollutants Indirect (BRLm)"]
["Petrochemicals","Petrochemical manufacturing",325110,{"$f":"IFERROR(VLOOKUP(A3,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A3)","v":62},{"$f":"$D3*VLOOKUP($C3,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":13.991169460780274},{"$f":"$D3*VLOOKUP($C3,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":12.85555896081893},{"$f":"$D3*VLOOKUP($C3,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":7.4212375263720848E-2},{"$f":"$D3*VLOOKUP($C3,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":5.1950893604786508},{"$f":"$D3*VLOOKUP($C3,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":9.1167018891906246E-2},{"$f":"$D3*VLOOKUP($C3,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":10.056392746316599},{"$f":"$D3*VLOOKUP($C3,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":1.3566855221497346E-4},{"$f":"$D3*VLOOKUP($C3,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":6.1820880049796614},{"$f":"$D3*VLOOKUP($C3,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":9.8298242554625964E-3},{"$f":"$D3*VLOOKUP($C3,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":0.13745001876539473},{"$f":"$D3*VLOOKUP($C3,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":2.0981420336580437E-3},{"$f":"$D3*VLOOKUP($C3,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":3.4007601423535254}]
["Energy","Hydroelectric Power Generation",221111,{"$f":"IFERROR(VLOOKUP(A4,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF($A$3:$A$45,A4)","v":182},{"$f":"$D4*VLOOKUP($C4,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":0},{"$f":"$D4*VLOOKUP($C4,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":6.1597017900897439},{"$f":"$D4*VLOOKUP($C4,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":0.72235749037541097},{"$f":"$D4*VLOOKUP($C4,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":2.5700684761159001},{"$f":"$D4*VLOOKUP($C4,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":5.5412883281755546E-2},{"$f":"$D4*VLOOKUP($C4,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":15.587740826472094},{"$f":"$D4*VLOOKUP($C4,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":3.6084526071326617},{"$f":"$D4*VLOOKUP($C4,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":5.7178718572724652},{"$f":"$D4*VLOOKUP($C4,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":1.9585292950918558},{"$f":"$D4*VLOOKUP($C4,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":0.19478822423879594},{"$f":"$D4*VLOOKUP($C4,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D4*VLOOKUP($C4,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":0.45980930897300032}]
["Energy","Electric Power distribution",221122,{"$f":"IFERROR(VLOOKUP(A5,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A5)","v":182},{"$f":"$D5*VLOOKUP($C5,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":4.1820091183074989E-2},{"$f":"$D5*VLOOKUP($C5,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":7.3186097866965421},{"$f":"$D5*VLOOKUP($C5,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":0.65496970363851614},{"$f":"$D5*VLOOKUP($C5,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":3.0779057985263227},{"$f":"$D5*VLOOKUP($C5,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":6.6390369147412795E-2},{"$f":"$D5*VLOOKUP($C5,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":18.576567575429397},{"$f":"$D5*VLOOKUP($C5,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":0},{"$f":"$D5*VLOOKUP($C5,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":6.8203873381339939},{"$f":"$D5*VLOOKUP($C5,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":0},{"$f":"$D5*VLOOKUP($C5,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":0.22013363803190303},{"$f":"$D5*VLOOKUP($C5,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D5*VLOOKUP($C5,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":0.55083370198252746}]
["Energy","Electric Bulk Power Transmission and Control",221121,{"$f":"IFERROR(VLOOKUP(A6,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A6)","v":182},{"$f":"$D6*VLOOKUP($C6,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":5.4563525756185061E-2},{"$f":"$D6*VLOOKUP($C6,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":7.3195488978551202},{"$f":"$D6*VLOOKUP($C6,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":4.1174687020909211},{"$f":"$D6*VLOOKUP($C6,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":3.0967034620538718},{"$f":"$D6*VLOOKUP($C6,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":6.6390369147412795E-2},{"$f":"$D6*VLOOKUP($C6,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":18.576874746631599},{"$f":"$D6*VLOOKUP($C6,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":0.21587401317388591},{"$f":"$D6*VLOOKUP($C6,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":6.8215753469258811},{"$f":"$D6*VLOOKUP($C6,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":0},{"$f":"$D6*VLOOKUP($C6,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":0.22013601170664268},{"$f":"$D6*VLOOKUP($C6,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D6*VLOOKUP($C6,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":0.55083364767109899}]
["Water","Water Supply and Irrigation Systems and Steam and Air-Conditioning Supply","221300A",{"$f":"IFERROR(VLOOKUP(A7,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A7)","v":789},{"$f":"$D7*VLOOKUP($C7,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":17.356565903228145},{"$f":"$D7*VLOOKUP($C7,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":13.824936948824206},{"$f":"$D7*VLOOKUP($C7,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":0.64168119172904059},{"$f":"$D7*VLOOKUP($C7,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":30.541608096186142},{"$f":"$D7*VLOOKUP($C7,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":0.15457776293379086},{"$f":"$D7*VLOOKUP($C7,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":9.7921670808185226},{"$f":"$D7*VLOOKUP($C7,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":0},{"$f":"$D7*VLOOKUP($C7,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":3.3523304007779915},{"$f":"$D7*VLOOKUP($C7,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":18.337037687361892},{"$f":"$D7*VLOOKUP($C7,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":0.25745578694718707},{"$f":"$D7*VLOOKUP($C7,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D7*VLOOKUP($C7,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":1.0328535278636355}]
["Food and Beverage","Animal (except poultry) slaughtering, rendering, and processing",311920,{"$f":"IFERROR(VLOOKUP(A8,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A8)","v":22.75},{"$f":"$D8*VLOOKUP($C8,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":1.2811042653092648},{"$f":"$D8*VLOOKUP($C8,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":4.0779062762469698},{"$f":"$D8*VLOOKUP($C8,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":3.7978049114059959E-3},{"$f":"$D8*VLOOKUP($C8,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":4.4541700161778399},{"$f":"$D8*VLOOKUP($C8,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":0.13810566764270502},{"$f":"$D8*VLOOKUP($C8,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":2.3324063733544667},{"$f":"$D8*VLOOKUP($C8,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":2.1271886063457413E-3},{"$f":"$D8*VLOOKUP($C8,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":10.395791087431157},{"$f":"$D8*VLOOKUP($C8,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":1.463851203289973E-4},{"$f":"$D8*VLOOKUP($C8,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":1.5280987542624931},{"$f":"$D8*VLOOKUP($C8,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D8*VLOOKUP($C8,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":13.0196055203886}]
["Food and Beverage","Coffee and Tea Manufacturing","31161A",{"$f":"IFERROR(VLOOKUP(A9,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A9)","v":22.75},{"$f":"$D9*VLOOKUP($C9,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":0.23576093405353804},{"$f":"$D9*VLOOKUP($C9,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":45.182841750195493},{"$f":"$D9*VLOOKUP($C9,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":3.9653071168553487E-3},{"$f":"$D9*VLOOKUP($C9,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":4.5959539730784984},{"$f":"$D9*VLOOKUP($C9,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":8.9911930367161011E-2},{"$f":"$D9*VLOOKUP($C9,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":2.0854927486922108},{"$f":"$D9*VLOOKUP($C9,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":8.0945819161159149E-4},{"$f":"$D9*VLOOKUP($C9,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":9.3969804802906616},{"$f":"$D9*VLOOKUP($C9,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":1.2055677085802643E-4},{"$f":"$D9*VLOOKUP($C9,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":81.515236583057415},{"$f":"$D9*VLOOKUP($C9,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":3.7042429240375437E-5},{"$f":"$D9*VLOOKUP($C9,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":11.266033433228923}]
["Food and Beverage","Breweries",312120,{"$f":"IFERROR(VLOOKUP(A10,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A10)","v":22.75},{"$f":"$D10*VLOOKUP($C10,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":8.1476622077957916E-2},{"$f":"$D10*VLOOKUP($C10,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":1.7973316313185339},{"$f":"$D10*VLOOKUP($C10,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":8.6736472881692329E-3},{"$f":"$D10*VLOOKUP($C10,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":1.1711630520209397},{"$f":"$D10*VLOOKUP($C10,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":4.9210323732939397E-2},{"$f":"$D10*VLOOKUP($C10,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":0.95251476187286677},{"$f":"$D10*VLOOKUP($C10,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":1.2608846463216749E-3},{"$f":"$D10*VLOOKUP($C10,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":3.5760361875347026},{"$f":"$D10*VLOOKUP($C10,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":2.3643704906352861E-3},{"$f":"$D10*VLOOKUP($C10,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":0.19393103490223984},{"$f":"$D10*VLOOKUP($C10,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":1.33722401753619E-5},{"$f":"$D10*VLOOKUP($C10,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":5.9417404183485747}]
["Food and Beverage","Fats and oils refining and blending",311225,{"$f":"IFERROR(VLOOKUP(A11,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A11)","v":22.75},{"$f":"$D11*VLOOKUP($C11,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":0.32330151762087145},{"$f":"$D11*VLOOKUP($C11,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":1.9286573322643232},{"$f":"$D11*VLOOKUP($C11,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":9.0357385346979675E-4},{"$f":"$D11*VLOOKUP($C11,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":0.80756062205181267},{"$f":"$D11*VLOOKUP($C11,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":2.2305191133484028E-2},{"$f":"$D11*VLOOKUP($C11,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":0.50925768827304785},{"$f":"$D11*VLOOKUP($C11,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":1.619061757463537E-3},{"$f":"$D11*VLOOKUP($C11,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":16.102316105946233},{"$f":"$D11*VLOOKUP($C11,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":3.8348672760491677E-5},{"$f":"$D11*VLOOKUP($C11,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":0.66375593757636364},{"$f":"$D11*VLOOKUP($C11,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D11*VLOOKUP($C11,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":23.788175033480066}]
["Siderurgy and Metalurgy","Primary smelting and refining of nonferrous metal (except copper and aluminum)",331419,{"$f":"IFERROR(VLOOKUP(A12,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A12)","v":42.333333333333336},{"$f":"$D12*VLOOKUP($C12,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":19.468912198981428},{"$f":"$D12*VLOOKUP($C12,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":12.178248483434672},{"$f":"$D12*VLOOKUP($C12,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":4.7517279289132643},{"$f":"$D12*VLOOKUP($C12,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":4.39913812936671},{"$f":"$D12*VLOOKUP($C12,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":0.35874074575402087},{"$f":"$D12*VLOOKUP($C12,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":37.986944544386617},{"$f":"$D12*VLOOKUP($C12,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":1.0000430468529158E-2},{"$f":"$D12*VLOOKUP($C12,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":9.0008751961224505},{"$f":"$D12*VLOOKUP($C12,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":0.31551127872536455},{"$f":"$D12*VLOOKUP($C12,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":0.20185027697297808},{"$f":"$D12*VLOOKUP($C12,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":9.497597785606357E-2},{"$f":"$D12*VLOOKUP($C12,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":0.52850356809300247}]
["Siderurgy and Metalurgy","Copper rolling, drawing, extruding and alloying",331420,{"$f":"IFERROR(VLOOKUP(A13,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A13)","v":42.333333333333336},{"$f":"$D13*VLOOKUP($C13,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":0.68450333495608107},{"$f":"$D13*VLOOKUP($C13,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":9.7435005505383998},{"$f":"$D13*VLOOKUP($C13,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":2.330156216595164E-3},{"$f":"$D13*VLOOKUP($C13,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":3.6671976658839363},{"$f":"$D13*VLOOKUP($C13,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":0.33813743773144367},{"$f":"$D13*VLOOKUP($C13,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":20.366627801795843},{"$f":"$D13*VLOOKUP($C13,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":2.8357786094413487E-3},{"$f":"$D13*VLOOKUP($C13,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":2.6461496761705541},{"$f":"$D13*VLOOKUP($C13,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":9.470532021932777E-3},{"$f":"$D13*VLOOKUP($C13,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":0.16897289121799605},{"$f":"$D13*VLOOKUP($C13,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":3.796679423813469E-3},{"$f":"$D13*VLOOKUP($C13,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":0.50602131241151627}]
["Siderurgy and Metalurgy","Plate work and fabricated structural product manufacturing",332310,{"$f":"IFERROR(VLOOKUP(A14,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A14)","v":42.333333333333336},{"$f":"$D14*VLOOKUP($C14,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":0.21013684332991908},{"$f":"$D14*VLOOKUP($C14,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":9.5665921657721054},{"$f":"$D14*VLOOKUP($C14,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":4.2914261976733587E-3},{"$f":"$D14*VLOOKUP($C14,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":1.4539182975340315},{"$f":"$D14*VLOOKUP($C14,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":0.1514977433060721},{"$f":"$D14*VLOOKUP($C14,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":3.8708596162041768},{"$f":"$D14*VLOOKUP($C14,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":5.8757632359936734E-3},{"$f":"$D14*VLOOKUP($C14,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":0.74824623715604288},{"$f":"$D14*VLOOKUP($C14,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":1.705518166607439E-4},{"$f":"$D14*VLOOKUP($C14,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":7.6697819825718133E-2},{"$f":"$D14*VLOOKUP($C14,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D14*VLOOKUP($C14,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":0.2285594766539446}]
["Siderurgy and Metalurgy","Iron and steel mills and ferroalloy manufacturing",331110,{"$f":"IFERROR(VLOOKUP(A15,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A15)","v":42.333333333333336},{"$f":"$D15*VLOOKUP($C15,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":21.983844624717996},{"$f":"$D15*VLOOKUP($C15,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":10.989685112937533},{"$f":"$D15*VLOOKUP($C15,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":0.19179911374051489},{"$f":"$D15*VLOOKUP($C15,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":1.8157697424788029},{"$f":"$D15*VLOOKUP($C15,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":0.16177376259249027},{"$f":"$D15*VLOOKUP($C15,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":10.545607862850082},{"$f":"$D15*VLOOKUP($C15,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":1.8084984308991835E-3},{"$f":"$D15*VLOOKUP($C15,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":1.5804406085829676},{"$f":"$D15*VLOOKUP($C15,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":9.9622312563021592E-2},{"$f":"$D15*VLOOKUP($C15,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":8.9023005236992636E-2},{"$f":"$D15*VLOOKUP($C15,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":9.196380813831416E-3},{"$f":"$D15*VLOOKUP($C15,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":0.22518361860077696}]
["Siderurgy and Metalurgy","Other fabricated metal manufacturing","33299C",{"$f":"IFERROR(VLOOKUP(A16,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A16)","v":42.333333333333336},{"$f":"$D16*VLOOKUP($C16,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":0.23932588034143989},{"$f":"$D16*VLOOKUP($C16,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":7.0644260811332842},{"$f":"$D16*VLOOKUP($C16,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":1.3472214937287447E-2},{"$f":"$D16*VLOOKUP($C16,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":1.6852509696418927},{"$f":"$D16*VLOOKUP($C16,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":0.15215606240413132},{"$f":"$D16*VLOOKUP($C16,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":3.3518039470708048},{"$f":"$D16*VLOOKUP($C16,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":5.0931326524375894E-3},{"$f":"$D16*VLOOKUP($C16,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":0.74493264400120385},{"$f":"$D16*VLOOKUP($C16,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":8.9419597928819757E-5},{"$f":"$D16*VLOOKUP($C16,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":6.988460795479369E-2},{"$f":"$D16*VLOOKUP($C16,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":1.3287573245488328E-4},{"$f":"$D16*VLOOKUP($C16,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":0.22636179184785615}]
["Mining","Iron ore mining ",212210,{"$f":"IFERROR(VLOOKUP(A17,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A17)","v":320},{"$f":"$D17*VLOOKUP($C17,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":2.9145307097331727},{"$f":"$D17*VLOOKUP($C17,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":20.148773703015795},{"$f":"$D17*VLOOKUP($C17,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":6.0713642124050873},{"$f":"$D17*VLOOKUP($C17,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":12.905483604481162},{"$f":"$D17*VLOOKUP($C17,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":0.22745240341240089},{"$f":"$D17*VLOOKUP($C17,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":21.752401985366596},{"$f":"$D17*VLOOKUP($C17,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":46.234421985111013},{"$f":"$D17*VLOOKUP($C17,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":7.4953345494976373},{"$f":"$D17*VLOOKUP($C17,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":6.8324952634889496E-2},{"$f":"$D17*VLOOKUP($C17,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":0.34934784028373511},{"$f":"$D17*VLOOKUP($C17,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D17*VLOOKUP($C17,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":1.8345148304200896}]
["Automobiles","Motor vehicle body manufacturing",336211,{"$f":"IFERROR(VLOOKUP(A18,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A18)","v":168},{"$f":"$D18*VLOOKUP($C18,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":1.1840506188294437},{"$f":"$D18*VLOOKUP($C18,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":26.631976503295903},{"$f":"$D18*VLOOKUP($C18,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":6.4851560668776703E-2},{"$f":"$D18*VLOOKUP($C18,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":12.015917315126689},{"$f":"$D18*VLOOKUP($C18,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":0.71018234061600227},{"$f":"$D18*VLOOKUP($C18,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":13.76154576988321},{"$f":"$D18*VLOOKUP($C18,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":1.4571693641669971E-2},{"$f":"$D18*VLOOKUP($C18,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":3.9632632343699057},{"$f":"$D18*VLOOKUP($C18,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":2.8354245654782712E-4},{"$f":"$D18*VLOOKUP($C18,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":1.1013523628512272},{"$f":"$D18*VLOOKUP($C18,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":3.1579653973765347E-4},{"$f":"$D18*VLOOKUP($C18,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":2.0288634612146046}]
["Paper and celulose","Paper mills",322120,{"$f":"IFERROR(VLOOKUP(A19,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A19)","v":167.5},{"$f":"$D19*VLOOKUP($C19,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":4.9856105508794784},{"$f":"$D19*VLOOKUP($C19,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":9.1294608441709091},{"$f":"$D19*VLOOKUP($C19,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":3.0135366409818656},{"$f":"$D19*VLOOKUP($C19,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":23.746092525925143},{"$f":"$D19*VLOOKUP($C19,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":0.3069382553278458},{"$f":"$D19*VLOOKUP($C19,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":5.4460247817779237},{"$f":"$D19*VLOOKUP($C19,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":3.0506901762224711E-3},{"$f":"$D19*VLOOKUP($C19,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":2.6918381145630179},{"$f":"$D19*VLOOKUP($C19,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":7.3221385096233785E-2},{"$f":"$D19*VLOOKUP($C19,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":0.42009114247049384},{"$f":"$D19*VLOOKUP($C19,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0.35390038180389582},{"$f":"$D19*VLOOKUP($C19,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":2.142080842430492}]
["Paper and celulose","Pulp mills",322110,{"$f":"IFERROR(VLOOKUP(A20,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A20)","v":167.5},{"$f":"$D20*VLOOKUP($C20,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":9.2956463627683394},{"$f":"$D20*VLOOKUP($C20,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":5.4807594268297581},{"$f":"$D20*VLOOKUP($C20,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":1.1914385738569542},{"$f":"$D20*VLOOKUP($C20,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":20.437887574777182},{"$f":"$D20*VLOOKUP($C20,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":0.19485598550644667},{"$f":"$D20*VLOOKUP($C20,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":3.7204046718099182},{"$f":"$D20*VLOOKUP($C20,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":9.4169884789472322E-4},{"$f":"$D20*VLOOKUP($C20,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":1.7200083501297803},{"$f":"$D20*VLOOKUP($C20,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":0.10020791775968461},{"$f":"$D20*VLOOKUP($C20,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":0.31184893481305498},{"$f":"$D20*VLOOKUP($C20,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0.21359703630401891},{"$f":"$D20*VLOOKUP($C20,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":1.0898305115449354}]
["Manufacturing","Apparel accessories and other apparel manufacturing",315900,{"$f":"IFERROR(VLOOKUP(A21,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A21)","v":193},{"$f":"$D21*VLOOKUP($C21,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":0.41376064367940152},{"$f":"$D21*VLOOKUP($C21,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":15.531656085399462},{"$f":"$D21*VLOOKUP($C21,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":2.111268299795439E-2},{"$f":"$D21*VLOOKUP($C21,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":12.098669421838817},{"$f":"$D21*VLOOKUP($C21,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":0.47082928280554337},{"$f":"$D21*VLOOKUP($C21,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":7.6783737527630631},{"$f":"$D21*VLOOKUP($C21,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":3.6905973699727861E-2},{"$f":"$D21*VLOOKUP($C21,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":5.9886054342186021},{"$f":"$D21*VLOOKUP($C21,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":2.4454751810513162E-3},{"$f":"$D21*VLOOKUP($C21,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":11.494924249580563},{"$f":"$D21*VLOOKUP($C21,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D21*VLOOKUP($C21,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":6.4651654080798817}]
["Manufacturing","All other miscellaneous wood product manufacturing",321999,{"$f":"IFERROR(VLOOKUP(A22,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A22)","v":193},{"$f":"$D22*VLOOKUP($C22,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":0.31938033653179848},{"$f":"$D22*VLOOKUP($C22,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":7.7248587063125225},{"$f":"$D22*VLOOKUP($C22,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":8.0631779972977366E-2},{"$f":"$D22*VLOOKUP($C22,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":4.959880508539686},{"$f":"$D22*VLOOKUP($C22,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":1.3899183957178969},{"$f":"$D22*VLOOKUP($C22,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":4.7264588252830961},{"$f":"$D22*VLOOKUP($C22,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":1.3921666761190924E-2},{"$f":"$D22*VLOOKUP($C22,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":3.4039825364615832},{"$f":"$D22*VLOOKUP($C22,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":2.065584014390769E-3},{"$f":"$D22*VLOOKUP($C22,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":1.5253137510216586},{"$f":"$D22*VLOOKUP($C22,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D22*VLOOKUP($C22,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":2.0649236193098726}]
["Automobiles","Motor vehicle parts manufacturing",336300,{"$f":"IFERROR(VLOOKUP(A23,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A23)","v":168},{"$f":"$D23*VLOOKUP($C23,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":1.8130021039548212},{"$f":"$D23*VLOOKUP($C23,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":73.231670448563747},{"$f":"$D23*VLOOKUP($C23,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":2.2267298980710077E-2},{"$f":"$D23*VLOOKUP($C23,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":28.175756420491979},{"$f":"$D23*VLOOKUP($C23,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":1.335251949780051},{"$f":"$D23*VLOOKUP($C23,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":33.051990071541532},{"$f":"$D23*VLOOKUP($C23,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":2.231197789216998E-2},{"$f":"$D23*VLOOKUP($C23,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":8.9753616562837557},{"$f":"$D23*VLOOKUP($C23,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":8.2992846684837209E-4},{"$f":"$D23*VLOOKUP($C23,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":2.8689592193765092},{"$f":"$D23*VLOOKUP($C23,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D23*VLOOKUP($C23,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":4.6083141001902703}]
["Oil & Gas","Petroleum Refineries",324110,{"$f":"IFERROR(VLOOKUP(A24,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A24)","v":333.33333333333331},{"$f":"$D24*VLOOKUP($C24,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":1.439253434270181},{"$f":"$D24*VLOOKUP($C24,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":7.3044735639937448},{"$f":"$D24*VLOOKUP($C24,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":3.612699198139209E-2},{"$f":"$D24*VLOOKUP($C24,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":1.7370909697835974},{"$f":"$D24*VLOOKUP($C24,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":0.10078485470247901},{"$f":"$D24*VLOOKUP($C24,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":35.010538347772943},{"$f":"$D24*VLOOKUP($C24,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":1.2586609146363387E-4},{"$f":"$D24*VLOOKUP($C24,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":15.6806512997052},{"$f":"$D24*VLOOKUP($C24,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":1.2955462078670885E-2},{"$f":"$D24*VLOOKUP($C24,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":4.7278198332421195E-2},{"$f":"$D24*VLOOKUP($C24,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":3.2489614323539254E-4},{"$f":"$D24*VLOOKUP($C24,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":0}]
["Chemicals","Pharmaceutical preparation manufacturing",325412,{"$f":"IFERROR(VLOOKUP(A25,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A25)","v":300},{"$f":"$D25*VLOOKUP($C25,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":1.1842058046772952},{"$f":"$D25*VLOOKUP($C25,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":30.003840039545146},{"$f":"$D25*VLOOKUP($C25,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":4.0101740207344548E-2},{"$f":"$D25*VLOOKUP($C25,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":14.737350230690929},{"$f":"$D25*VLOOKUP($C25,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":1.3100581968423055},{"$f":"$D25*VLOOKUP($C25,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":11.723669198574727},{"$f":"$D25*VLOOKUP($C25,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":1.8462924664219324E-2},{"$f":"$D25*VLOOKUP($C25,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":11.800795208175485},{"$f":"$D25*VLOOKUP($C25,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":1.5372961903758085E-3},{"$f":"$D25*VLOOKUP($C25,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":9.9984512892133495},{"$f":"$D25*VLOOKUP($C25,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":8.7067823650947032E-5},{"$f":"$D25*VLOOKUP($C25,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":11.785147514966713}]
["Construction","Cement manufacturing",327310,{"$f":"IFERROR(VLOOKUP(A26,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A26)","v":66.666666666666671},{"$f":"$D26*VLOOKUP($C26,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":69.246436118042809},{"$f":"$D26*VLOOKUP($C26,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":10.914912271989975},{"$f":"$D26*VLOOKUP($C26,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":3.3356144683923503},{"$f":"$D26*VLOOKUP($C26,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":2.0368648887390703},{"$f":"$D26*VLOOKUP($C26,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":7.8668937637597927E-2},{"$f":"$D26*VLOOKUP($C26,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":7.0834398735843411},{"$f":"$D26*VLOOKUP($C26,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":2.3021858133063997E-3},{"$f":"$D26*VLOOKUP($C26,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":1.6011357675404645},{"$f":"$D26*VLOOKUP($C26,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":3.7365738296298863E-2},{"$f":"$D26*VLOOKUP($C26,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":7.5193729206843848E-2},{"$f":"$D26*VLOOKUP($C26,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":7.6619135199712117E-4},{"$f":"$D26*VLOOKUP($C26,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":0.20714935875359611}]
["Construction","Valve and fittings other than plumbing","33291A",{"$f":"IFERROR(VLOOKUP(A27,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A27)","v":66.666666666666671},{"$f":"$D27*VLOOKUP($C27,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":1.3821626402140188},{"$f":"$D27*VLOOKUP($C27,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":28.183684217768764},{"$f":"$D27*VLOOKUP($C27,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":3.4203673197249827E-3},{"$f":"$D27*VLOOKUP($C27,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":6.8563529784757717},{"$f":"$D27*VLOOKUP($C27,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":0.88922341501147828},{"$f":"$D27*VLOOKUP($C27,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":15.478345694811733},{"$f":"$D27*VLOOKUP($C27,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":2.9414026029321399E-2},{"$f":"$D27*VLOOKUP($C27,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":3.0317151942325302},{"$f":"$D27*VLOOKUP($C27,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":6.4626485727861248E-4},{"$f":"$D27*VLOOKUP($C27,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":0.37613382402292833},{"$f":"$D27*VLOOKUP($C27,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D27*VLOOKUP($C27,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":0.97171557174451162}]
["Oil & Gas","Crude Petroleum and Natural Gas Extraction","211111B",{"$f":"IFERROR(VLOOKUP(A28,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A28)","v":333.33333333333331},{"$f":"$D28*VLOOKUP($C28,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":10.274772771203644},{"$f":"$D28*VLOOKUP($C28,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":3.143519312330715},{"$f":"$D28*VLOOKUP($C28,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":4.2140069271032553E-2},{"$f":"$D28*VLOOKUP($C28,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":0.79200263173264007},{"$f":"$D28*VLOOKUP($C28,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":7.5087259296397549E-2},{"$f":"$D28*VLOOKUP($C28,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":8.86917266430601},{"$f":"$D28*VLOOKUP($C28,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":52.300652325394459},{"$f":"$D28*VLOOKUP($C28,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":5.4798200755221362},{"$f":"$D28*VLOOKUP($C28,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":2.820121075580392E-2},{"$f":"$D28*VLOOKUP($C28,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":2.8965727485653892E-2},{"$f":"$D28*VLOOKUP($C28,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D28*VLOOKUP($C28,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":0.14644561289788494}]
["Oil & Gas","Natural Gas Distribution",221200,{"$f":"IFERROR(VLOOKUP(A29,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A29)","v":333.33333333333331},{"$f":"$D29*VLOOKUP($C29,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":25.776734687406996},{"$f":"$D29*VLOOKUP($C29,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":25.360823974973716},{"$f":"$D29*VLOOKUP($C29,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":0.22824867720662703},{"$f":"$D29*VLOOKUP($C29,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":3.5788289810061769},{"$f":"$D29*VLOOKUP($C29,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":0.19743300182668203},{"$f":"$D29*VLOOKUP($C29,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":116.85646460167048},{"$f":"$D29*VLOOKUP($C29,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":0.63107036556777318},{"$f":"$D29*VLOOKUP($C29,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":52.412070208790581},{"$f":"$D29*VLOOKUP($C29,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":2.2428121069784394E-3},{"$f":"$D29*VLOOKUP($C29,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":0.33092013424866906},{"$f":"$D29*VLOOKUP($C29,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D29*VLOOKUP($C29,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":0.86584275296670488}]
["Automobiles","Motor Vehicle and Parts Dealers",441000,{"$f":"IFERROR(VLOOKUP(A30,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A30)","v":168},{"$f":"$D30*VLOOKUP($C30,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":0},{"$f":"$D30*VLOOKUP($C30,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":2.5040718547510141},{"$f":"$D30*VLOOKUP($C30,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":1.3083842896610101E-4},{"$f":"$D30*VLOOKUP($C30,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":0.71041655590706931},{"$f":"$D30*VLOOKUP($C30,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":2.0032652160868216E-2},{"$f":"$D30*VLOOKUP($C30,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":1.1774628033526098},{"$f":"$D30*VLOOKUP($C30,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":4.9455905654424447E-2},{"$f":"$D30*VLOOKUP($C30,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":0.51492929822485778},{"$f":"$D30*VLOOKUP($C30,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":5.02748472656582E-5},{"$f":"$D30*VLOOKUP($C30,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":8.013340072760794E-2},{"$f":"$D30*VLOOKUP($C30,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D30*VLOOKUP($C30,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":0.18522088848952664}]
["Construction","Residential permanent site single- and multi-family structures",230201,{"$f":"IFERROR(VLOOKUP(A31,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A31)","v":66.666666666666671},{"$f":"$D31*VLOOKUP($C31,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":3.1882077957941041E-2},{"$f":"$D31*VLOOKUP($C31,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":2.1051912133259245},{"$f":"$D31*VLOOKUP($C31,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":1.6710919532674875E-5},{"$f":"$D31*VLOOKUP($C31,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":0.95299670520768565},{"$f":"$D31*VLOOKUP($C31,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":3.3008197105385204E-2},{"$f":"$D31*VLOOKUP($C31,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":1.4218105812041255},{"$f":"$D31*VLOOKUP($C31,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":1.6665166988364915E-3},{"$f":"$D31*VLOOKUP($C31,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":0.51964869222632282},{"$f":"$D31*VLOOKUP($C31,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":1.7835711588147868E-4},{"$f":"$D31*VLOOKUP($C31,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":6.8658913061707016E-2},{"$f":"$D31*VLOOKUP($C31,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D31*VLOOKUP($C31,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":0.19827620906189464}]
["Transport","Support activities for transportation","48A000",{"$f":"IFERROR(VLOOKUP(A32,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A32)","v":228},{"$f":"$D32*VLOOKUP($C32,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":2.5004495247104361},{"$f":"$D32*VLOOKUP($C32,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":5.6922811401354112},{"$f":"$D32*VLOOKUP($C32,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":0.54845022204200788},{"$f":"$D32*VLOOKUP($C32,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":2.7832503351585709},{"$f":"$D32*VLOOKUP($C32,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":2.1768936749587204E-2},{"$f":"$D32*VLOOKUP($C32,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":6.1139632867874525},{"$f":"$D32*VLOOKUP($C32,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":0.21680257525414093},{"$f":"$D32*VLOOKUP($C32,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":2.3394503727404969},{"$f":"$D32*VLOOKUP($C32,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":2.8672327072584388E-3},{"$f":"$D32*VLOOKUP($C32,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":1.6179846243524381},{"$f":"$D32*VLOOKUP($C32,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D32*VLOOKUP($C32,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":0.48340931357398736}]
["Real Estate","Real estate",531000,{"$f":"IFERROR(VLOOKUP(A33,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A33)","v":50},{"$f":"$D33*VLOOKUP($C33,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":3.3781721697644658E-2},{"$f":"$D33*VLOOKUP($C33,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":0.5749175172134835},{"$f":"$D33*VLOOKUP($C33,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":4.4817910572874001E-5},{"$f":"$D33*VLOOKUP($C33,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":0.16313855527135726},{"$f":"$D33*VLOOKUP($C33,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":2.2090901088076529E-3},{"$f":"$D33*VLOOKUP($C33,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":0.23455660241049128},{"$f":"$D33*VLOOKUP($C33,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":6.5103729287331676E-6},{"$f":"$D33*VLOOKUP($C33,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":8.101090955730697E-2},{"$f":"$D33*VLOOKUP($C33,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":1.6298909200482262E-5},{"$f":"$D33*VLOOKUP($C33,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":1.4210841176801593E-2},{"$f":"$D33*VLOOKUP($C33,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D33*VLOOKUP($C33,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":4.0336742845057047E-2}]
["Telecommunications","Telecommunications",517000,{"$f":"IFERROR(VLOOKUP(A34,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A34)","v":50},{"$f":"$D34*VLOOKUP($C34,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":3.8348115553156641E-2},{"$f":"$D34*VLOOKUP($C34,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":0.84172372167094689},{"$f":"$D34*VLOOKUP($C34,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":4.1989090975073077E-5},{"$f":"$D34*VLOOKUP($C34,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":0.62275361121000705},{"$f":"$D34*VLOOKUP($C34,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":6.4455707830440925E-3},{"$f":"$D34*VLOOKUP($C34,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":0.45080134423753898},{"$f":"$D34*VLOOKUP($C34,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":6.4467032667032346E-4},{"$f":"$D34*VLOOKUP($C34,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":0.1896793983154888},{"$f":"$D34*VLOOKUP($C34,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":1.5637867130249483E-4},{"$f":"$D34*VLOOKUP($C34,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":3.4430281184276497E-2},{"$f":"$D34*VLOOKUP($C34,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D34*VLOOKUP($C34,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":0.11249374824674918}]
["Agriculture","Soybean Farming",111110,{"$f":"IFERROR(VLOOKUP(A35,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A35)","v":18.666666666666668},{"$f":"$D35*VLOOKUP($C35,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":1.9051456968988214},{"$f":"$D35*VLOOKUP($C35,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":0.66025436653786262},{"$f":"$D35*VLOOKUP($C35,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":0.57789610150808191},{"$f":"$D35*VLOOKUP($C35,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":0.6749359256435512},{"$f":"$D35*VLOOKUP($C35,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":5.2785458310842984E-2},{"$f":"$D35*VLOOKUP($C35,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":0.32727603370425701},{"$f":"$D35*VLOOKUP($C35,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":20.519910824003016},{"$f":"$D35*VLOOKUP($C35,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":3.9588241333148524},{"$f":"$D35*VLOOKUP($C35,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":1.3529297011205296E-3},{"$f":"$D35*VLOOKUP($C35,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":0.3104548639462254},{"$f":"$D35*VLOOKUP($C35,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":4.2367012388555478},{"$f":"$D35*VLOOKUP($C35,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":0.55704401824618943}]
["Agriculture","Cotton farming",111920,{"$f":"IFERROR(VLOOKUP(A36,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A36)","v":18.666666666666668},{"$f":"$D36*VLOOKUP($C36,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":0.90901296881656912},{"$f":"$D36*VLOOKUP($C36,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":1.4832857085923123},{"$f":"$D36*VLOOKUP($C36,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":0.28702683177054411},{"$f":"$D36*VLOOKUP($C36,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":18.092346777184947},{"$f":"$D36*VLOOKUP($C36,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":6.6132277037188464E-2},{"$f":"$D36*VLOOKUP($C36,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":0.79709564197283023},{"$f":"$D36*VLOOKUP($C36,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":10.162225495401945},{"$f":"$D36*VLOOKUP($C36,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":1.7188511831761923},{"$f":"$D36*VLOOKUP($C36,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":1.6566707160955506E-2},{"$f":"$D36*VLOOKUP($C36,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":0.50268748276479458},{"$f":"$D36*VLOOKUP($C36,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0.72484434719295898},{"$f":"$D36*VLOOKUP($C36,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":0.40080108287100591}]
["Agriculture","Sugarcane Farming",111930,{"$f":"IFERROR(VLOOKUP(A37,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A37)","v":18.666666666666668},{"$f":"$D37*VLOOKUP($C37,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":1.654741098537285},{"$f":"$D37*VLOOKUP($C37,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":0.59123160185147883},{"$f":"$D37*VLOOKUP($C37,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":0.44148369665652981},{"$f":"$D37*VLOOKUP($C37,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":0.47220840143750603},{"$f":"$D37*VLOOKUP($C37,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":6.2885645837479826E-2},{"$f":"$D37*VLOOKUP($C37,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":0.49609330396528706},{"$f":"$D37*VLOOKUP($C37,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":13.678684689303974},{"$f":"$D37*VLOOKUP($C37,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":0.85583342237049465},{"$f":"$D37*VLOOKUP($C37,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":0.14370974504583389},{"$f":"$D37*VLOOKUP($C37,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":0.50327230865916639},{"$f":"$D37*VLOOKUP($C37,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":5.2420110123635677},{"$f":"$D37*VLOOKUP($C37,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":0.21280078825502866}]
["Livestock","Cattle ranching and farming ","1121A0",{"$f":"IFERROR(VLOOKUP(A38,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A38)","v":61},{"$f":"$D38*VLOOKUP($C38,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":271.67915507501851},{"$f":"$D38*VLOOKUP($C38,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":62.606357919958874},{"$f":"$D38*VLOOKUP($C38,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":11.611457018060086},{"$f":"$D38*VLOOKUP($C38,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":8.1459762364397736},{"$f":"$D38*VLOOKUP($C38,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":0.5112467357047662},{"$f":"$D38*VLOOKUP($C38,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":5.1215876312111712},{"$f":"$D38*VLOOKUP($C38,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":1765.7250957884526},{"$f":"$D38*VLOOKUP($C38,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":27.9335920197104},{"$f":"$D38*VLOOKUP($C38,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":6.142753828239189E-3},{"$f":"$D38*VLOOKUP($C38,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":10.23919005162292},{"$f":"$D38*VLOOKUP($C38,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D38*VLOOKUP($C38,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":44.116459481599897}]
["Forestry","Logging",113310,{"$f":"IFERROR(VLOOKUP(A39,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A39)","v":470},{"$f":"$D39*VLOOKUP($C39,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":11.505409557720775},{"$f":"$D39*VLOOKUP($C39,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":8.0976072571330331},{"$f":"$D39*VLOOKUP($C39,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":0.52914722468354847},{"$f":"$D39*VLOOKUP($C39,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":4.1466822622735764},{"$f":"$D39*VLOOKUP($C39,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":1.5029024758503999},{"$f":"$D39*VLOOKUP($C39,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":6.4791131661667585},{"$f":"$D39*VLOOKUP($C39,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":0},{"$f":"$D39*VLOOKUP($C39,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":127.71733187315327},{"$f":"$D39*VLOOKUP($C39,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":0},{"$f":"$D39*VLOOKUP($C39,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":0.31087194211558949},{"$f":"$D39*VLOOKUP($C39,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D39*VLOOKUP($C39,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":14.255224666455236}]
["Fishing","Other aquaculture",112519,{"$f":"IFERROR(VLOOKUP(A40,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A40)","v":344},{"$f":"$D40*VLOOKUP($C40,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":1.538293253621855E-5},{"$f":"$D40*VLOOKUP($C40,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":43.543173698864912},{"$f":"$D40*VLOOKUP($C40,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":0},{"$f":"$D40*VLOOKUP($C40,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":14.017564731914025},{"$f":"$D40*VLOOKUP($C40,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":3.7940736652309566},{"$f":"$D40*VLOOKUP($C40,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":13.662736942414462},{"$f":"$D40*VLOOKUP($C40,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":0},{"$f":"$D40*VLOOKUP($C40,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":85.109735889589331},{"$f":"$D40*VLOOKUP($C40,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":1712.4706244184574},{"$f":"$D40*VLOOKUP($C40,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":491.06100410137884},{"$f":"$D40*VLOOKUP($C40,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D40*VLOOKUP($C40,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":123.41776099941599}]
["Other Manufacturing","Other industrial machinery manufacturing","33329A",{"$f":"IFERROR(VLOOKUP(A41,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A41)","v":200},{"$f":"$D41*VLOOKUP($C41,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":0.1615233417126857},{"$f":"$D41*VLOOKUP($C41,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":8.3517994311907806},{"$f":"$D41*VLOOKUP($C41,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":2.1292145329896853E-3},{"$f":"$D41*VLOOKUP($C41,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":2.4102405374553753},{"$f":"$D41*VLOOKUP($C41,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":0.23766425585493609},{"$f":"$D41*VLOOKUP($C41,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":3.9543047449436783},{"$f":"$D41*VLOOKUP($C41,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":6.385987688312853E-3},{"$f":"$D41*VLOOKUP($C41,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":1.0094755693836157},{"$f":"$D41*VLOOKUP($C41,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":1.0931404540604445E-4},{"$f":"$D41*VLOOKUP($C41,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":0.14428220501797809},{"$f":"$D41*VLOOKUP($C41,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D41*VLOOKUP($C41,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":0.42097482342117526}]
["Siderurgy and Metalurgy","Rolling mill and other metalworking machinery manufacturing","33351B",{"$f":"IFERROR(VLOOKUP(A42,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A42)","v":42.333333333333336},{"$f":"$D42*VLOOKUP($C42,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":3.8588350524652495E-2},{"$f":"$D42*VLOOKUP($C42,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":1.9840499778297713},{"$f":"$D42*VLOOKUP($C42,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":3.0333713665425506E-4},{"$f":"$D42*VLOOKUP($C42,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":0.45482929067698558},{"$f":"$D42*VLOOKUP($C42,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":5.4027139019524641E-2},{"$f":"$D42*VLOOKUP($C42,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":1.0352624588773869},{"$f":"$D42*VLOOKUP($C42,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":1.5256292294959198E-3},{"$f":"$D42*VLOOKUP($C42,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":0.23188499153433945},{"$f":"$D42*VLOOKUP($C42,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":2.9336834669865757E-5},{"$f":"$D42*VLOOKUP($C42,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":2.6934021245334162E-2},{"$f":"$D42*VLOOKUP($C42,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D42*VLOOKUP($C42,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":6.9747029395811552E-2}]
["Transport","Air transportation",481000,{"$f":"IFERROR(VLOOKUP(A43,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A43)","v":228},{"$f":"$D43*VLOOKUP($C43,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":41.093922722777862},{"$f":"$D43*VLOOKUP($C43,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":11.077612121406547},{"$f":"$D43*VLOOKUP($C43,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":1.0096826229446412E-3},{"$f":"$D43*VLOOKUP($C43,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":2.6427931888137759},{"$f":"$D43*VLOOKUP($C43,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":3.8633931589062614E-2},{"$f":"$D43*VLOOKUP($C43,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":33.40481335503506},{"$f":"$D43*VLOOKUP($C43,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":0.33675128212532396},{"$f":"$D43*VLOOKUP($C43,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":15.083141654028537},{"$f":"$D43*VLOOKUP($C43,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":1.4369903389976401E-5},{"$f":"$D43*VLOOKUP($C43,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":0.54984448322898349},{"$f":"$D43*VLOOKUP($C43,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D43*VLOOKUP($C43,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":0.88478554416586208}]
["Other Manufacturing","All other transportation equipment manufacturing",336999,{"$f":"IFERROR(VLOOKUP(A44,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A44)","v":200},{"$f":"$D44*VLOOKUP($C44,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":0.41656987306688475},{"$f":"$D44*VLOOKUP($C44,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":14.924293700167443},{"$f":"$D44*VLOOKUP($C44,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":7.9496658341792637E-3},{"$f":"$D44*VLOOKUP($C44,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":7.171649763132117},{"$f":"$D44*VLOOKUP($C44,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":0.25941816120682937},{"$f":"$D44*VLOOKUP($C44,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":6.6932338534739637},{"$f":"$D44*VLOOKUP($C44,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":5.1265786058039848E-3},{"$f":"$D44*VLOOKUP($C44,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":2.0025435835849414},{"$f":"$D44*VLOOKUP($C44,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":5.6373028812845336E-5},{"$f":"$D44*VLOOKUP($C44,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":0.34201437725315526},{"$f":"$D44*VLOOKUP($C44,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":0},{"$f":"$D44*VLOOKUP($C44,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":1.1296134866560348}]
["Chemicals","Fertilizer manufacturing",325310,{"$f":"IFERROR(VLOOKUP(A45,'Summary Data'!$B$9:$C$28,2,0),\"\")/COUNTIF('Detailed lending data'!$A$3:$A$45,'Detailed lending data'!A45)","v":300},{"$f":"$D45*VLOOKUP($C45,'Tabulated impacts'!$B$4:$N$48,E$1,0)","v":255.83947003831366},{"$f":"$D45*VLOOKUP($C45,'Tabulated impacts'!$B$4:$N$48,F$1,0)","v":112.82284159403845},{"$f":"$D45*VLOOKUP($C45,'Tabulated impacts'!$B$4:$N$48,G$1,0)","v":1.4162102778310708},{"$f":"$D45*VLOOKUP($C45,'Tabulated impacts'!$B$4:$N$48,H$1,0)","v":140.67166550251628},{"$f":"$D45*VLOOKUP($C45,'Tabulated impacts'!$B$4:$N$48,I$1,0)","v":1.0864323842668464},{"$f":"$D45*VLOOKUP($C45,'Tabulated impacts'!$B$4:$N$48,J$1,0)","v":81.397431238791853},{"$f":"$D45*VLOOKUP($C45,'Tabulated impacts'!$B$4:$N$48,K$1,0)","v":1.6547213235189508E-2},{"$f":"$D45*VLOOKUP($C45,'Tabulated impacts'!$B$4:$N$48,L$1,0)","v":30.015678550050893},{"$f":"$D45*VLOOKUP($C45,'Tabulated impacts'!$B$4:$N$48,M$1,0)","v":0.89099235915117991},{"$f":"$D45*VLOOKUP($C45,'Tabulated impacts'!$B$4:$N$48,N$1,0)","v":0.74799223481383303},{"$f":"$D45*VLOOKUP($C45,'Tabulated impacts'!$B$4:$N$48,O$1,0)","v":1.1686805521880761E-2},{"$f":"$D45*VLOOKUP($C45,'Tabulated impacts'!$B$4:$N$48,P$1,0)","v":3.048086812579061}]

{"sheet":"Tabulated impacts","index":7,"n_rows":48,"n_cols":14,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
[null,null,"GHG ","GHG ","Air Pollution ","Air Pollution ","Waste ","Waste ","Land Use ","Land Use ","Water ","Water ","Water Pollutants ","Water Pollutants "]
[null,null,"Direct","Indirect","Direct","Indirect","Direct","Indirect","Direct","Indirect","Direct","Indirect","Direct","Indirect"]
["Trucost Sector","Sector Code",{"$f":"C1&C2","v":"GHG Direct"},{"$f":"D1&D2","v":"GHG Indirect"},"Air Pollution Direct","Air Pollution Indirect","Waste Direct","Waste Indirect","Land Use Direct","Land Use Indirect","Water Direct","Water Indirect","Water Pollutants Direct","Water Pollutants Indirect"]
["Animal (except poultry) slaughtering, rendering, and processing","31161A",1.0363117980375298E-2,1.9860589780305711,1.7429921392770763E-4,0.20201995486059335,3.9521727633916931E-3,9.1670010931525756E-2,3.5580579851058968E-5,0.41305408704574337,5.2991987190341288E-6,3.5830873223321942,1.6282386479285906E-6,0.49521026080127134]
["Breweries",312120,3.5813899814486996E-3,7.9003588189825669E-2,3.8125922145798829E-4,5.1479694594327025E-2,2.1630911530962373E-3,4.1868780741664474E-2,5.542350093721648E-5,0.15718840384767924,1.0392837321473784E-4,8.5244410946039486E-3,5.8779077693898463E-7,0.26117540300433295]
["Electric Power distribution",221122,2.297807207861263E-4,4.0212141685145836E-2,3.5987346353764625E-3,1.6911570321573203E-2,3.6478224806270765E-4,0.10206905261224944,0,3.7474655704032932E-2,0,1.2095254836917749E-3,0,3.026558802101799E-3]
["Natural Gas Distribution",221200,7.7330204062220992E-2,7.6082471924921152E-2,6.8474603161988116E-4,1.0736486943018531E-2,5.9229900548004612E-4,0.35056939380501145,1.8932110967033197E-3,0.15723621062637175,6.7284363209353186E-6,9.927604027460072E-4,0,2.5975282589001149E-3]
["Aircraft manufacturing",336411,6.7559619817976404E-4,5.3259498547756919E-2,3.3444649413840913E-5,2.3796027553007769E-2,2.7337692079609116E-3,2.8808289686960149E-2,5.316708256853821E-5,7.1362181341955225E-3,2.8080730164507572E-7,1.011668040178769E-3,1.1766398043466945E-6,2.9423499632619376E-3]
["Other industrial machinery manufacturing","33329A",8.0761670856342857E-4,4.1758997155953902E-2,1.0646072664948427E-5,1.2051202687276876E-2,1.1883212792746804E-3,1.9771523724718392E-2,3.1929938441564264E-5,5.0473778469180787E-3,5.4657022703022222E-7,7.2141102508989038E-4,0,2.1048741171058763E-3]
["Copper rolling, drawing, extruding and alloying",331420,1.6169370117072781E-2,0.23016143032767872,5.5043060234531435E-5,8.6626716516943369E-2,7.9874985290892195E-3,0.48110144413690964,6.6986896286016107E-5,6.2507472665446151E-2,2.2371335484880575E-4,3.991485619322741E-3,8.9685340720003202E-5,1.1953259348303534E-2]
["Motor vehicle body manufacturing",336211,7.0479203501752604E-3,0.15852366966247561,3.8602119445700417E-4,7.1523317351944574E-2,4.2272758370000135E-3,8.1913962915971486E-2,8.673627167660697E-5,2.3590852585535154E-2,1.68775271754659E-6,6.5556688264954005E-3,1.8797413079622231E-6,1.2076568221515503E-2]
["Motor Vehicle and Parts Dealers",441000,0,1.4905189611613179E-2,7.7880017241726797E-7,4.2286699756373175E-3,1.192419771480251E-4,7.008707162813153E-3,2.9438039080014551E-4,3.0650553465765341E-3,2.9925504324796547E-7,4.7698452814052346E-4,0,1.1025052886281348E-3]
["Telecommunications",517000,7.6696231106313287E-4,1.6834474433418938E-2,8.397818195014615E-7,1.245507222420014E-2,1.2891141566088185E-4,9.0160268847507795E-3,1.2893406533406468E-5,3.7935879663097759E-3,3.1275734260498965E-6,6.8860562368552988E-4,0,2.2498749649349837E-3]
["Plate work and fabricated structural product manufacturing",332310,4.96386244086423E-3,0.22598249210485288,1.0137227238598484E-4,3.4344526713402317E-2,3.5786868497497343E-3,9.1437628729232515E-2,1.3879755675575605E-4,1.7675107964315973E-2,4.0287830707262334E-6,1.8117595234421605E-3,0,5.3990427556049906E-3]
["Iron and steel mills and ferroalloy manufacturing",331110,0.51930341633192112,0.25959886093553225,4.5306877261538951E-3,4.289219864123156E-2,3.8214274628147306E-3,0.24910884715393891,4.2720435375571259E-5,3.7333242722432304E-2,2.3532829739296439E-3,2.1029056355195111E-3,2.1723734205900981E-4,5.3192980771837074E-3]
["Motor vehicle parts manufacturing",336300,1.0791679190207269E-2,0.43590280028906991,1.3254344631375046E-4,0.16771283583626179,7.9479282725003035E-3,0.19673803614012816,1.3280939221529749E-4,5.3424771763593781E-2,4.9400503979069765E-6,1.7077138210574459E-2,0,2.7430441072561134E-2]
["Support activities for transportation","48A000",1.096688388030893E-2,2.4966145351471101E-2,2.4054834300088067E-3,1.2207238312098995E-2,9.5477792761347393E-5,2.6815628450822158E-2,9.5088848795675843E-4,1.0260747248861829E-2,1.2575582049379118E-5,7.0964237910194653E-3,0,2.1202162876052077E-3]
["Coffee and Tea Manufacturing",311920,5.6312275398209446E-2,0.17924862752733933,1.6693647962224157E-4,0.19578769301880616,6.0705787974815392E-3,0.10252335707052601,9.3502795883329293E-5,0.45695784999697392,6.4345107836921884E-6,6.7169176011538156E-2,0,0.57229035254455385]
["Electric Bulk Power Transmission and Control",221121,2.9979959206695087E-4,4.0217301636566595E-2,2.2623454407092975E-2,1.7014854187109185E-2,3.6478224806270765E-4,0.10207074036610769,1.1861209515048677E-3,3.748118322486748E-2,0,1.209538525860674E-3,0,3.0265585036873574E-3]
["Paper mills",322120,2.9764839109728228E-2,5.4504243845796475E-2,1.7991263528249944E-2,0.14176771657268741,1.8324671959871392E-3,3.2513580786733873E-2,1.8213075678940125E-5,1.6070675310823988E-2,4.3714259758945541E-4,2.5080068207193663E-3,2.1128381003217662E-3,1.278854234286861E-2]
["Other fabricated metal manufacturing","33299C",5.6533672521599972E-3,0.16687620664094371,3.1824129773119954E-4,3.9809078023036834E-2,3.5942376945857788E-3,7.9176471190648925E-2,1.20310220136321E-4,1.7596834110264657E-2,2.1122739668225138E-6,1.6508175107431578E-3,3.1387968296429121E-6,5.3471289412879404E-3]
["Other aquaculture",112519,4.4717827140170207E-8,0.12657899331065381,0,4.0748734685796581E-2,1.1029283910555106E-2,3.9717258553530414E-2,0,0.2474120229348527,4.9781122802862132,1.4275029188993571,0,0.35877256104481392]
["Rolling mill and other metalworking machinery manufacturing","33351B",9.1153583916501948E-4,4.6867322310939478E-2,7.165444172935158E-6,1.0743998992369738E-2,1.2762316303824718E-3,2.445501871363906E-2,3.6038485736124089E-5,5.4775982252206167E-3,6.9299609456375802E-7,6.362367223307282E-4,0,1.6475676235231074E-3]
["Petrochemical manufacturing",325110,0.22566402356097215,0.20734772517449887,1.1969737945761428E-3,8.3791763878687919E-2,1.470435788579133E-3,0.16219988300510643,2.1882024550802172E-6,9.971109685451067E-2,1.5854555250746123E-4,2.2169357865386248E-3,3.3841000542871673E-5,5.4850970037960085E-2]
["Valve and fittings other than plumbing","33291A",2.0732439603210282E-2,0.42275526326653146,5.1305509795874736E-5,0.10284529467713657,1.3338351225172173E-2,0.23217518542217597,4.4121039043982098E-4,4.5475727913487952E-2,9.693972859179187E-6,5.6420073603439249E-3,0,1.4575733576167673E-2]
["All other transportation equipment manufacturing",336999,2.0828493653344236E-3,7.4621468500837215E-2,3.9748329170896317E-5,3.5858248815660583E-2,1.2970908060341469E-3,3.3466169267369818E-2,2.5632893029019925E-5,1.0012717917924708E-2,2.8186514406422668E-7,1.7100718862657763E-3,0,5.6480674332801744E-3]
["Fats and oils refining and blending",311225,1.4211055719598745E-2,8.4776146473157066E-2,3.9717532020650407E-5,3.5497170200079677E-2,9.8044796191138579E-4,2.2384953330683421E-2,7.1167549778617005E-5,0.70779411454708718,1.6856559455161177E-6,2.9176085168191809E-2,0,1.0456340674057172]
["Pulp mills",322110,5.5496396195631882E-2,3.2720951801968705E-2,7.1130661125788312E-3,0.12201723925240109,1.1633193164563981E-3,2.2211371174984586E-2,5.6220826739983478E-6,1.0268706567938986E-2,5.982562254309529E-4,1.8617846854510744E-3,1.2752061868896651E-3,6.5064508151936439E-3]
["Residential permanent site single- and multi-family structures",230201,4.782311693691156E-4,3.1577868199888864E-2,2.5066379299012311E-7,1.4294950578115284E-2,4.9512295658077799E-4,2.132715871806188E-2,2.4997750482547372E-5,7.7947303833948416E-3,2.6753567382221799E-6,1.0298836959256052E-3,0,2.9741431359284194E-3]
["Pharmaceutical preparation manufacturing",325412,3.9473526822576509E-3,0.10001280013181715,1.3367246735781517E-4,4.9124500768969764E-2,4.3668606561410184E-3,3.9078897328582426E-2,6.1543082214064417E-5,3.9335984027251615E-2,5.1243206345860285E-6,3.3328170964044501E-2,2.9022607883649013E-7,3.9283825049889046E-2]
["Air transportation",481000,0.18023650317007833,4.8586018076344509E-2,4.4284325567747418E-6,1.1591198196551649E-2,1.6944706837308164E-4,0.14651233927646956,1.4769793075672104E-3,6.6154130061528676E-2,6.3025892061300003E-8,2.4115986106534363E-3,0,3.8806383516046582E-3]
["All other miscellaneous wood product manufacturing",321999,1.654820396537816E-3,4.0025174644106334E-2,4.1778124338330238E-4,2.5698862738547594E-2,7.2016497187455796E-3,2.4489423965197391E-2,7.2132988399952968E-5,1.7637215214826855E-2,1.0702507846584296E-5,7.9031800571070388E-3,0,1.0699086110413846E-2]
["Real estate",531000,6.7563443395289319E-4,1.1498350344269669E-2,8.9635821145747999E-7,3.2627711054271451E-3,4.4181802176153054E-5,4.6911320482098257E-3,1.3020745857466335E-7,1.6202181911461394E-3,3.2597818400964526E-7,2.8421682353603185E-4,0,8.067348569011409E-4]
["Water Supply and Irrigation Systems and Steam and Air-Conditioning Supply","221300A",2.1998182386854429E-2,1.7522100061881124E-2,8.1328414667812489E-4,3.8709262479323374E-2,1.9591604934574252E-4,1.2410858150593819E-2,0,4.2488344750037915E-3,2.3240858919343337E-2,3.2630644733483785E-4,0,1.3090665752390816E-3]
["Petroleum refineries",324110,4.3177603028105435E-3,2.1913420691981236E-2,1.0838097594417628E-4,5.2112729093507929E-3,3.0235456410743704E-4,0.10503161504331884,3.7759827439090166E-7,4.7041953899115606E-2,3.8866386236012659E-5,1.4183459499726359E-4,9.7468842970617774E-7,0]
["Apparel accessories and other apparel manufacturing",315900,2.1438375320176244E-3,8.0474901996888407E-2,1.0939213988577404E-4,6.2687406330771078E-2,2.4395299627230226E-3,3.9784319962502916E-2,1.9122266165662105E-4,3.1029043700614517E-2,1.2670855860369514E-5,5.9559193003008097E-2,0,3.3498266363108195E-2]
["Tobacco product manufacturing","3122A0",2.18269853163574E-3,4.8315093623438735E-2,2.1011936466490961E-4,7.3732190607497694E-2,4.9973673216070005E-3,2.8451522986986527E-2,2.9574244102952788E-5,6.5653685734680917E-2,6.4601882974446345E-7,1.0990764459323015E-2,0,0.12635100289079346]
["Fertilizer manufacturing",325310,0.85279823346104555,0.37607613864679484,4.7207009261035692E-3,0.46890555167505427,3.6214412808894879E-3,0.27132477079597284,5.5157377450631691E-5,0.10005226183350298,2.9699745305039331E-3,2.4933074493794435E-3,3.8956018406269203E-5,1.0160289375263537E-2]
["Soybean Farming",111110,0.10206137661957972,3.5370769635956922E-2,3.0958719723647242E-2,3.6157281730904524E-2,2.8277924095094454E-3,1.7532644662728053E-2,1.0992809370001615,0.21207986428472422,7.2478376845742647E-5,1.6631510568547787E-2,0.22696613779583291,2.984164383461729E-2]
["Cotton farming",111920,4.8697123329459059E-2,7.946173438887387E-2,1.5376437416279148E-2,0.96923286306347922,3.5428005555636676E-3,4.2701552248544473E-2,0.54440493725367556,9.2081313384438868E-2,8.8750216933690201E-4,2.6929686576685419E-2,3.8830947171051372E-2,2.1471486582375316E-2]
["Sugarcane Farming",111930,8.864684456449741E-2,3.1673121527757794E-2,2.3650912320885523E-2,2.5296878648437823E-2,3.3688738841507046E-3,2.6576426998140376E-2,0.73278667978414147,4.584821905556221E-2,7.698736341741101E-3,2.6961016535312486E-2,0.2808220185194768,1.1400042227947963E-2]
["Cattle ranching and farming","1121A0",4.4537566405740741,1.0263337363927685,0.19035175439442764,0.1335405940399963,8.3810940279469871E-3,8.3960452970674934E-2,28.946313045712337,0.45792773802803932,1.0070088243015063E-4,0.16785557461676917,0,0.72322064723934254]
["Logging",113310,2.4479594803661221E-2,1.7228951610921348E-2,1.1258451589011671E-3,8.8227282176033539E-3,3.1976648422348936E-3,1.3785347162056934E-2,0,0.27173900398543249,0,6.6142966407572231E-4,0,3.03302652477771E-2]
["Crude Petroleum and Natural Gas Extraction","211111B",3.0824318313610932E-2,9.4305579369921462E-3,1.2642020781309768E-4,2.3760078951979204E-3,2.2526177788919266E-4,2.660751799291803E-2,0.15690195697618339,1.6439460226566411E-2,8.4603632267411769E-5,8.6897182456961681E-5,0,4.3933683869365486E-4]
["Iron ore mining",212210,9.1079084679161655E-3,6.2964917821924357E-2,1.8973013163765897E-2,4.0329636264003633E-2,7.1078876066375276E-4,6.7976256204270613E-2,0.14448256870347193,2.3422920467180117E-2,2.1351547698402967E-4,1.0917120008866721E-3,0,5.7328588450627797E-3]
["Hydroelectric Power Generation",221111,0,3.384451533016343E-2,3.9689971998648956E-3,1.4121255363274176E-2,3.0446639165799752E-4,8.5646927617978541E-2,1.9826662676553086E-2,3.1416878336661895E-2,1.0761149973032175E-2,1.0702649683450327E-3,0,2.5264247745769249E-3]
["Cement manufacturing",327310,1.038696541770642,0.16372368407984961,5.0034217025885251E-2,3.0552973331086052E-2,1.1800340645639689E-3,0.10625159810376511,3.4532787199595989E-5,2.4017036513106965E-2,5.6048607444448293E-4,1.1279059381026576E-3,1.1492870279956816E-5,3.1072403813039414E-3]
["Primary smelting and refining of nonferrous metal (except copper and aluminum)",331419,0.45989556375546681,0.28767516102601587,0.11224554162787238,0.10391664872519787,8.4741908445831703E-3,0.89732939868629802,2.3623064098887771E-4,0.21261909912100277,7.4530223320952256E-3,4.7681167788892458E-3,2.2435270359700056E-3,1.2484336254165411E-2]

{"sheet":"Ranking","index":8,"n_rows":70,"n_cols":8,"rows_kept":70,"cut":false,"hidden":true,"merged":[]}
["BANKS","TOTAL","% TOTAL",null,null,"BANKS","TOTAL","% TOTAL"]
["SECTORS",null,null,null,null,"Pessoa Fisica",743949400,38.969206922267666]
["Setor Publico",77064705.5,4.036767090655788,null,null,"Demais servicos",75698932.795288742,3.9652258283889212]
["Petroquimica",28678654.5,1.5022317666533809,null,null,"Transporte e armazenagens",41633871,2.180845812865766]
["Adm Direta",20221701,1.0592436133280396,null,null,"Construcao civil",34960665,1.8312930805846217]
["Saneamento e Infraestrutura",17908102,0.93805376067656665,null,null,"Atividades imbiliarias, alugueis e servicos prestados as empresas",29820909,1.5620648036427129]
["Producao e distribuicao de energia eletrica",7956402,0.41676850051192238,null,null,"Petroquimica",28678654.5,1.5022317666533809]
["Outros",2191809,0.11481030625885118,null,null,"Siderurgica, metalurgica e mecanica",28636781,1.5000383687071501]
["Setor Privado",null,null,null,null,"Alimenticia e bebidas",25070395,1.3132256177341963]
["Industry",210634140.62670535,11.033338303621331,null,null,"Comercio varejista",23941352,1.2540846193126129]
["Siderurgica, metalurgica e mecanica",28636781,1.5000383687071501,null,null,"Adm Direta",20221701,1.0592436133280396]
["Alimenticia e bebidas",25070395,1.3132256177341963,null,null,"Veiculos leves e pesados",18901500,0.99008946662399666]
["Veiculos leves e pesados",18901500,0.99008946662399666,null,null,"Saneamento e Infraestrutura",17908102,0.93805376067656665]
["Demais industrias",13945428,0.73048283841829209,null,null,"Demais comercios",16847018,0.88247255857074147]
["Acucar e alcool",9070434,0.47512319980468021,null,null,"Agricultura, pecuaria, pesaca, silvicultura e exploracao florestal",14926537.626705365,0.7818748605860768]
["Bens de capital",8486204,0.44452033923352252,null,null,"Demais industrias",13945428,0.73048283841829209]
["Papel e celulose",7365131,0.38579682159647977,null,null,"Intermdiarios financeiros",13436150,0.70380607819379482]
["Quimica",6872610.5,0.35999784484085806,null,null,"Diversos",10203257,0.53446220040512971]
["Eletroeletronica",6149884,0.32214032586617203,null,null,"Servicos sociais, educacao, saude, defesa e seguridade social",9290865,0.48666971257971903]
["Moveis e produtos de madeira",5393289,0.28250872308330383,null,null,"Acucar e alcool",9070434,0.47512319980468021]
["Material de construcao",5320762,0.27870964794398484,null,null,"Bens de capital",8486204,0.44452033923352252]
["Textil e confeccoes",5123813,0.26839315822824111,null,null,"Produtos agropecuarios",8457619.5,0.44302303942352261]
["Extracao de minerais metalicos e nao metalicos",4864015.1267053653,0.25478454844593107,null,null,"Vestuario e calcados",8263119,0.43283480588104711]
["Farmaceutico e cosmeticos",4394102,0.23016978046564751,null,null,"Produtos em lojas especializadas",8202678,0.42966881389881179]
["Petroleo e gas natural",3753504,0.19661427787905922,null,null,"Producao e distribuicao de energia eletrica",7956402,0.41676850051192238]
["Artigos de borracha e plastico",2700983,0.1414816188043532,null,null,"Atividades associativas, recreativas, culturais e disportivas",7486823,0.39217123459927888]
["Embalagens",2247092,0.11770611431553314,null,null,"Papel e celulose",7365131,0.38579682159647977]
["Edicao, impressao e reproducao",2101739,0.11009230195978371,null,null,"Quimica",6872610.5,0.35999784484085806]
["Materiais nao metalicos",2006362,0.10509630888737163,null,null,"Eletroeletronica",6149884,0.32214032586617203]
["Autopecas e acessorios",1967945,0.10308396769544009,null,null,"Atacadista de mercadorias em geral",6147668,0.32202424839834992]
["Refino de petroleo e producao de alcool",1657942,8.684553662267662E-2,null,null,"Holdings, atividades juridicas, contabeis e assessoria empresarial",5701013,0.29862777665193085]
["Artefatos de couro",758274,3.9719551369724333E-2,null,null,"Moveis e produtos de madeira",5393289,0.28250872308330383]
["Alimentos de origem vegetal",34941,1.8302629978207583E-3,null,null,"Material de construcao",5320762,0.27870964794398484]
["Alimentos de origem animal",14232,7.4549391788972935E-4,null,null,"Textil e confeccoes",5123813,0.26839315822824111]
["Comercio",135014020.5,7.0722408033016606,null,null,"Varejista nao especializado",4997814,0.26179313798089798]
["Comercio varejista",23941352,1.2540846193126129,null,null,"Extracao de minerais metalicos e nao metalicos",4864015.1267053653,0.25478454844593107]
["Demais comercios",16847018,0.88247255857074147,null,null,"Produtos alimenticios, bebidas e fumo",4627035,0.24237116711375095]
["Intermdiarios financeiros",13436150,0.70380607819379482,null,null,"Alojamento e alimentacao",4607991,0.24137361327927292]
["Produtos agropecuarios",8457619.5,0.44302303942352261,null,null,"Farmaceutico e cosmeticos",4394102,0.23016978046564751]
["Vestuario e calcados",8263119,0.43283480588104711,null,null,"Producao e distribuicao de eletricidade, gas e agua",3838925,0.20108876045073282]
["Produtos em lojas especializadas",8202678,0.42966881389881179,null,null,"Petroleo e gas natural",3753504,0.19661427787905922]
["Atacadista de mercadorias em geral",6147668,0.32202424839834992,null,null,"Telecomunicaoes",3683521,0.19294846134900884]
["Varejista nao especializado",4997814,0.26179313798089798,null,null,"Residuos e sucata",3592098,0.18815958484147421]
["Produtos alimenticios, bebidas e fumo",4627035,0.24237116711375095,null,null,"Veiculos automotores",3568729,0.18693548089493367]
["Residuos e sucata",3592098,0.18815958484147421,null,null,"Reparacao, pecas e acessorios para veiculos automotores",3083494,0.1615181297673885]
["Veiculos automotores",3568729,0.18693548089493367,null,null,"Utilidades domesticas",3035811,0.15902042132959088]
["Reparacao, pecas e acessorios para veiculos automotores",3083494,0.1615181297673885,null,null,"Artigos de borracha e plastico",2700983,0.1414816188043532]
["Utilidades domesticas",3035811,0.15902042132959088,null,null,"Intermediario do comercio",2495577,0.13072213849954309]
["Intermediario do comercio",2495577,0.13072213849954309,null,null,"Embalagens",2247092,0.11770611431553314]
["Artigos de uso pessoal e domestico",2179997,0.11419157564065882,null,null,"Outros",2191809,0.11481030625885118]
["Combustiveis",1921946,0.10067446975214261,null,null,"Artigos de uso pessoal e domestico",2179997,0.11419157564065882]
["Servicos",217821185.79528874,11.409806717110488,null,null,"Edicao, impressao e reproducao",2101739,0.11009230195978371]
["Demais servicos",75698932.795288742,3.9652258283889212,null,null,"Materiais nao metalicos",2006362,0.10509630888737163]
["Transporte e armazenagens",41633871,2.180845812865766,null,null,"Autopecas e acessorios",1967945,0.10308396769544009]
["Construcao civil",34960665,1.8312930805846217,null,null,"Combustiveis",1921946,0.10067446975214261]
["Atividades imbiliarias, alugueis e servicos prestados as empresas",29820909,1.5620648036427129,null,null,"Refino de petroleo e producao de alcool",1657942,8.684553662267662E-2]
["Servicos sociais, educacao, saude, defesa e seguridade social",9290865,0.48666971257971903,null,null,"Media",996835,5.2215741261917394E-2]
["Atividades associativas, recreativas, culturais e disportivas",7486823,0.39217123459927888,null,null,"Artefatos de couro",758274,3.9719551369724333E-2]
["Holdings, atividades juridicas, contabeis e assessoria empresarial",5701013,0.29862777665193085,null,null,"Terceiro setor",86328,4.5219926182957105E-3]
["Alojamento e alimentacao",4607991,0.24137361327927292,null,null,"Alimentos de origem vegetal",34941,1.8302629978207583E-3]
["Producao e distribuicao de eletricidade, gas e agua",3838925,0.20108876045073282,null,null,"Alimentos de origem animal",14232,7.4549391788972935E-4]
["Telecomunicaoes",3683521,0.19294846134900884,null,null,"Construcao pesada",8131,4.2591421067744446E-4]
["Media",996835,5.2215741261917394E-2,null,null,"Financeiro",6376,3.3398462763244201E-4]
["Terceiro setor",86328,4.5219926182957105E-3]
["Construcao pesada",8131,4.2591421067744446E-4]
["Financeiro",6376,3.3398462763244201E-4]
["Diversos",10203257,0.53446220040512971]
["Agricultura, pecuaria, pesaca, silvicultura e exploracao florestal",14926537.626705365,0.7818748605860768]
["Pessoa Fisica",743949400,38.969206922267666]
["TOTAL",1909069900.9706936,73.837696897948149]

{"sheet":"Sheet3","index":9,"n_rows":70,"n_cols":3,"rows_kept":70,"cut":false,"hidden":true,"merged":[]}
["BANKS"]
["SECTORS","TOTAL","% TOTAL"]
["Setor Publico",77064705.5,4.036767090655788]
["Adm Direta",28678654.5,1.5022317666533809]
["Petroquimica",20221701,1.0592436133280396]
["Producao e distribuicao de energia eletrica",17908102,0.93805376067656665]
["Saneamento e Infraestrutura",7956402,0.41676850051192238]
["Outros",2191809,0.11481030625885118]
["Setor Privado"]
["Industry",210634140.62670535,11.033338303621331]
["Alimentos de origem vegetal",28636781,1.5000383687071501]
["Alimentos de origem animal",25070395,1.3132256177341963]
["Alimenticia e bebidas",18901500,0.99008946662399666]
["Siderurgica, metalurgica e mecanica",13945428,0.73048283841829209]
["Veiculos leves e pesados",9070434,0.47512319980468021]
["Papel e celulose",8486204,0.44452033923352252]
["Quimica",7365131,0.38579682159647977]
["Textil e confeccoes",6872610.5,0.35999784484085806]
["Artigos de borracha e plastico",6149884,0.32214032586617203]
["Moveis e produtos de madeira",5393289,0.28250872308330383]
["Materiais nao metalicos",5320762,0.27870964794398484]
["Autopecas e acessorios",5123813,0.26839315822824111]
["Refino de petroleo e producao de alcool",4864015.1267053653,0.25478454844593107]
["Eletroeletronica",4394102,0.23016978046564751]
["Extracao de minerais metalicos e nao metalicos",3753504,0.19661427787905922]
["Artefatos de couro",2700983,0.1414816188043532]
["Edicao, impressao e reproducao",2247092,0.11770611431553314]
["Demais industrias",2101739,0.11009230195978371]
["Acucar e alcool",2006362,0.10509630888737163]
["Bens de capital",1967945,0.10308396769544009]
["Farmaceutico e cosmeticos",1657942,8.684553662267662E-2]
["Material de construcao",758274,3.9719551369724333E-2]
["Embalagens",34941,1.8302629978207583E-3]
["Petroleo e gas natural",14232,7.4549391788972935E-4]
["Comercio",135014020.5,7.0722408033016606]
["Comercio varejista",23941352,1.2540846193126129]
["Produtos em lojas especializadas",16847018,0.88247255857074147]
["Varejista nao especializado",13436150,0.70380607819379482]
["Produtos alimenticios, bebidas e fumo",8457619.5,0.44302303942352261]
["Residuos e sucata",8263119,0.43283480588104711]
["Veiculos automotores",8202678,0.42966881389881179]
["Reparacao, pecas e acessorios para veiculos automotores",6147668,0.32202424839834992]
["Vestuario e calcados",4997814,0.26179313798089798]
["Produtos agropecuarios",4627035,0.24237116711375095]
["Artigos de uso pessoal e domestico",3592098,0.18815958484147421]
["Combustiveis",3568729,0.18693548089493367]
["Atacadista de mercadorias em geral",3083494,0.1615181297673885]
["Utilidades domesticas",3035811,0.15902042132959088]
["Intermediario do comercio",2495577,0.13072213849954309]
["Demais comercios",2179997,0.11419157564065882]
["Intermdiarios financeiros",1921946,0.10067446975214261]
["Servicos",217821185.79528874,11.409806717110488]
["Construcao civil",75698932.795288742,3.9652258283889212]
["Construcao pesada",41633871,2.180845812865766]
["Transporte e armazenagens",34960665,1.8312930805846217]
["Atividades imbiliarias, alugueis e servicos prestados as empresas",29820909,1.5620648036427129]
["Holdings, atividades juridicas, contabeis e assessoria empresarial",9290865,0.48666971257971903]
["Atividades associativas, recreativas, culturais e disportivas",7486823,0.39217123459927888]
["Producao e distribuicao de eletricidade, gas e agua",5701013,0.29862777665193085]
["Alojamento e alimentacao",4607991,0.24137361327927292]
["Servicos sociais, educacao, saude, defesa e seguridade social",3838925,0.20108876045073282]
["Media",3683521,0.19294846134900884]
["Telecomunicaoes",996835,5.2215741261917394E-2]
["Demais servicos",86328,4.5219926182957105E-3]
["Terceiro setor",8131,4.2591421067744446E-4]
["Financeiro",6376,3.3398462763244201E-4]
["Diversos",10203257,0.53446220040512971]
["Agricultura, pecuaria, pesaca, silvicultura e exploracao florestal",14926537.626705365,0.7818748605860768]
["Pessoa Fisica",743949400,38.969206922267666]
["TOTAL",1909069900.9706936,73.837696897948149]

{"sheet":"Bradesco","index":10,"n_rows":54,"n_cols":3,"rows_kept":54,"cut":false,"hidden":true,"merged":[[0,1,0,2]]}
[null,"Bradesco"]
[null,null,"%"]
["Setor Publico"]
["Petroquimica",6126977,{"$f":"(B4/$B$54)*100","v":1.8641845343329724}]
["Producao e distribuicao de energia eletrica",29916,9.1021958347656945E-3]
["Saneamento e Infraestrutura",null,0]
["Outros",null,0]
["Setor Privado",null,0]
["Industry",null,0]
["Alimenticia e bebidas",13868061,4.2194747650246205]
["Siderurgica, metalurgica e mecanica",10054449,3.0591510833221052]
["Veiculos leves e pesados",4407580,1.3410434656169468]
["Papel e celulose",4024469,1.2244787060082785]
["Quimica",3661973,1.1141862343770701]
["Textil e confeccoes",3130392,0.95244822247572691]
["Artigos de borracha e plastico",2700983,0.82179690507998893]
["Moveis e produtos de madeira",2213129,0.6733632024869356]
["Materiais nao metalicos",2006362,0.61045259524776596]
["Autopecas e acessorios",1967945,0.59876389831688637]
["Refino de petroleo e producao de alcool",1657942,0.50444286557972662]
["Eletroeletronica",1200951,0.36539949157499985]
["Extracao de minerais metalicos e nao metalicos",1170875,0.35624861438799577]
["Artefatos de couro",755180,0.22976989739598733]
["Edicao, impressao e reproducao",541519,0.16476173239224776]
["Demais industrias",1406101,0.42781811289811061]
["Comercio",null,0]
["Produtos em lojas especializadas",8202678,2.4957341063485821]
["Varejista nao especializado",4997814,1.5206271484735148]
["Produtos alimenticios, bebidas e fumo",4627035,1.4078145040886174]
["Residuos e sucata",3592098,1.0929261750792278]
["Veiculos automotores",3568137,1.0856358383230833]
["Reparacao, pecas e acessorios para veiculos automotores",3083494,0.93817910961776319]
["Vestuario e calcados",2942289,0.89521629497516098]
["Produtos agropecuarios",2186741,0.66533443046902552]
["Artigos de uso pessoal e domestico",2179997,0.66328251147217909]
["Combustiveis",1921946,{"$f":"(B36/$B$54)*100","v":0.58476831380681182}]
["Atacadista de mercadorias em geral",1151577,0.35037703479114762]
["Intermediario do comercio",904057,0.27506698287841852]
["Demais comercios",2340900,0.71223860909222525]
["Intermdiarios financeiros",3742382,1.1386513522029049]
["Servicos",null,0]
["Construcao civil",23492691,7.1478497849858771]
["Transporte e armazenagens",17486148,5.3203083129996145]
["Atividades imbiliarias, alugueis e servicos prestados as empresas",12063574,3.6704443446713371]
["Holdings, atividades juridicas, contabeis e assessoria empresarial",5701013,1.7345813873026164]
["Atividades associativas, recreativas, culturais e disportivas",4037140,1.2283339648471043]
["Producao e distribuicao de eletricidade, gas e agua",3838605,1.1679280131805978]
["Alojamento e alimentacao",2799137,0.85166108912750826]
["Servicos sociais, educacao, saude, defesa e seguridade social",2790481,0.84902742797141351]
["Telecomunicaoes",427936,0.13020314469669381]
["Demais servicos",12125985,3.6894334188872597]
["Agricultura, pecuaria, pesaca, silvicultura e exploracao florestal",3580238,1.0893176698445599]
["Pessoa Fisica",133959048,40.758172507513621]
["TOTAL",{"$f":"SUM(B4:B53)","v":328667945},{"$f":"SUM(C4:C53)","v":100}]

{"sheet":"CEF","index":11,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Setor"]
["Setor Publico",37076753]
["Adm direta",20202347,{"$f":"(B3/$B$27)*100","v":4.0875822186388762}]
["Petroquimico",11241113,{"$f":"(B4/$B$27)*100","v":2.2744374015806339}]
["Saneamento e Infraestrutura",3643837,0.73726499840926552]
["Outros",1989456,0.40253070449509776]
["Setor Privado"]
["Pessoa Juridica"]
["Comercio varejista",23923477,4.8404860679413204]
["Contrucao civil",11450176,2.3167375462804207]
["Siderurgia e metarlugia",9520536,1.9263095354966082]
["Energia Electrica",7845936,1.5874842899282264]
["Servicos Financeiros",5081949,1.0282411428944183]
["Outras industrias",6800733,1.376006227618535]
["Transporte",6729159,1.3615245137009955]
["Agronegocio e extrativismo",4156287,0.84095005579103865]
["Comercio atacadista",4989191,1.0094732268975044]
["Saude",3393988,0.68671253884876471]
["Saneamento e Infraestrutura",2713321,0.54899179155072697]
["Petroquimico",2190992,0.44330789587863378]
["Textil",1979412,0.40049848141705596]
["Comunicacao",1672045,0.33830828718881228]
["Alimentacao",1808854,0.36598913217923673]
["Servicos Pessoais",344604,6.9724432654870813E-2]
["Outros Servicos",9595834,1.9415447339564245]
["Pessoa Fisica",352963833,71.415894776652536]
[null,{"$f":"SUM(B3:B26)","v":494237080},{"$f":"SUM(C3:C26)","v":100}]

{"sheet":"HSBC","index":12,"n_rows":32,"n_cols":26,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Industria",19301,{"$f":"(B1/B32)*100","v":3.4640013783498569}]
["Alimentos e bebidas",4637,{"$f":"(B2/$B$32)*100","v":0.83221462055894957}]
["Quimica e petroquimica",4209,{"$f":"(B3/$B$32)*100","v":0.7554003316654343}]
["Maquinas e equipamentos",1971,0.35374056871289405]
["Papel e celulose",963,0.17283215001040941]
["Textil e confeccoes",950,0.17049900572158769]
["Siderurgia e metalurgia",771,0.13837340359088854]
["Eletricidade gas e agua",320,5.7431244032534801E-2]
["Eletroeletronicas",916,0.16439693604313085]
["Madeiras e moveis",301,5.4021263918103045E-2]
["Automotiva",592,0.10624780146018939]
["Petroleo e gas natural",12,2.1536716512200551E-3]
["Demais indutrias",3658,0.65651090834691339]
["Comercio",9855,1.7687028435644701]
["Servicos",12414,2.2279733231871468]
["Financeiro ",2048,0.3675599618082227]
["Transporte",1847,0.33148596165028682]
["Educacao, Saude e outros",644,0.11558037861547628]
["Telecomunicacoes",138,2.4767223989030633E-2]
["Demais servicos",7736,1.3884003244865288,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4279]
["Construcao e imobiliario",6358,1.1410870298714257,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2079]
["Pessoa Fisica",4279,0.76796341629755127,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z20:Z21)","v":6358}]
["Pessoa Juridica",2079,0.37312361357387452]
["Setor Primario",1037,0.1861131251929331]
["Agropecuaria",916,0.16439693604313085]
["Mineracao",121,2.1716189149802223E-2]
["Outros Pessoa fisica",28153,5.0526931663998509]
["Total",77118,13.840570866565683]
["TVM e instrumentos financeiros",310930,55.803427209487644]
["Relacoes Interfinanceiras",10182,1.8273903960602169]
["Outros",42732,7.6692247499946156]
["TOTAL",{"$f":"SUM(B1:B31)","v":557188}]

{"sheet":"All","index":13,"n_rows":83,"n_cols":16,"rows_kept":83,"cut":false,"hidden":true,"merged":[[0,14,0,15],[0,4,0,5],[0,6,0,7],[0,8,0,9],[0,10,0,11],[0,12,0,13]]}
["BANKS",null,null,null,"Bradesco",null,"Caixa Economica Federal",null,"HSBC",null,"Santander",null,"Banco do Brasil",null,"Itau"]
["Setores","Sectors","TC Sectors ","TC Sector number",null,"%",null,"% ",null,"%",null,"%",null,"%",null,"%"]
["Setor Publico",null,null,null,{"$f":"SUM(E4:E12)","v":8347885},{"$f":"SUM(F4:F9)","v":2.3057995772306716},{"$f":"SUM(G4:G12)","v":49827002},{"$f":"SUM(H4:H12)","v":8.9267050510040686},{"$f":"SUM(I4:I12)","v":2104.5},{"$f":"SUM(J4:J12)","v":1.7717703812526571},108037,{"$f":"(K3/$K$83)*100","v":4.7195099115037616E-2},{"$f":"SUM(M4:M12)","v":48426},{"$f":"SUM(N4:N12)","v":6.2671639743546601},{"$f":"SUM(O4:O12)","v":18731251},{"$f":"SUM(P4:P12)","v":3.094780847772403}]
["Adm Direta","Direct adm",null,null,null,null,20202347,{"$f":"(G4/$G$83)*100","v":3.6193305992408873},null,null,null,null,19354,{"$f":"(M4/$M$83)*100","v":2.5047431454107318}]
["Petroquimica","Petrochemicals","Petrochemical manufacturing",325110,{"$f":"6126977+2190992","v":8317969},{"$f":"1.86+0.44","v":2.3000000000000003},{"$f":"11241113+2190992","v":13432105},{"$f":"(G5/$G$83)*100","v":2.4064148902459954},2104.5,{"$f":"(I5/$I$83)*100","v":1.7717703812526571},null,null,null,{"$f":"(M5/$M$83)*100","v":0},{"$f":"(6398104/2)+3727424","v":6926476},{"$f":"(O5/$O$83)*100","v":1.144393680238186}]
["Producao e distribuicao de energia eletrica","Production and Distribution of electric energy","Hydroelectric Power Generation",221111,29916,{"$f":"(E6/$E$83)*100","v":5.799577230671359E-3},7845936,{"$f":"(G6/$G$83)*100","v":1.4056305559193518},null,{"$f":"(I6/$I$83)*100","v":0},null,null,29072,{"$f":"(M6/$M$83)*100","v":3.7624208289439283},51478,{"$f":"(O6/$O$83)*100","v":8.5052049370128967E-3}]
[null,null,"Electric Power distribution",221122]
[null,null,"Electric Bulk Power Transmission and Control",221121]
["Saneamento e Infraestrutura","Sanitation and Infrastructure","Water Supply and Irrigation Systems and Steam and Air-Conditioning Supply","221300A",null,{"$f":"(E9/$E$83)*100","v":0},{"$f":"3643837+2713321","v":6357158},{"$f":"(G9/$G$83)*100","v":1.1389100718648679},null,{"$f":"(I9/$I$83)*100","v":0},null,null,null,{"$f":"(M9/$M$83)*100","v":0},{"$f":"6638648+4912296","v":11550944},{"$f":"(O9/$O$83)*100","v":1.9084491615050991}]
[null,null,"Water transportation",483000]
[]
["Outros","Others",null,null,null,{"$f":"(E12/$E$83)*100","v":0},1989456,{"$f":"(G12/$G$83)*100","v":0.35641893373296568},null,{"$f":"(I12/$I$83)*100","v":0},null,null,null,{"$f":"(M12/$M$83)*100","v":0},202353,{"$f":"(O12/$O$83)*100","v":3.3432801092104794E-2}]
["Setor Privado","Private Sector"]
["Industry","Industry",null,null,{"$f":"SUM(E15:E42)","v":54767911},10.617419762235439,18300681.126705363,3.2786396149335975,16404.5,13.810884874915283,43796778,{"$f":"(K14/K83)*100","v":19.132272079281162},{"$f":"SUM(M15:M42)","v":225810},{"$f":"SUM(N15:N42)","v":29.223728927622062},{"$f":"SUM(O15:O42)","v":93526556},{"$f":"SUM(P15:P42)","v":15.452475345448798}]
["Alimentos de origem vegetal","Food derived from animals","Coffee and Tea Manufacturing",311920,null,null,null,null,null,null,null,null,34941,{"$f":"(M15/$M$83)*100","v":4.5219711813473378}]
["Alimentos de origem animal","Food derived from plants","Animal (except poultry) slaughtering, rendering, and processing","31161A",null,null,null,null,null,null,null,null,14232,{"$f":"(M16/$M$83)*100","v":1.8418675439436569}]
["Alimenticia e bebidas","Food and Beverage","Breweries",312120,13868061,{"$f":"(E17/$E$83)*100","v":2.6884908012154525},null,{"$f":"(G17/$G$83)*100","v":0},4637,{"$f":"(I17/$I$83)*100","v":3.9038723011967558},null,null,2970,{"$f":"(M17/$M$83)*100","v":0.38436949167458268},11194727,{"$f":"(O17/$O$83)*100","v":1.8495949211102134}]
[null,null,"Fats and oils refining and blending",311225]
["Siderurgica, metalurgica e mecanica","Siderurgy, Metelurgy and Mechanical",null,null,10054449,{"$f":"(E19/$E$83)*100","v":1.9491761427779919},9520536,{"$f":"(G19/$G$83)*100","v":1.7056417883513455},771,{"$f":"(I19/$I$83)*100","v":0.64910190731565631},null,null,40421,{"$f":"(M19/$M$83)*100","v":5.2311781895549858},9020604,{"$f":"(O19/$O$83)*100","v":1.4903859061276328}]
["Veiculos leves e pesados",null,"Motor vehicle body manufacturing",336211,4407580,{"$f":"(E20/$E$83)*100","v":0.85446251538850337},null,{"$f":"(G20/$G$83)*100","v":0},1971,{"$f":"(I20/$I$83)*100","v":1.6593772494411914},null,null,25395,{"$f":"(M20/$M$83)*100","v":3.2865532798235786},14466554,{"$f":"(O20/$O$83)*100","v":2.3901667994553724}]
[]
["Papel e celulose","Paper and Cellulose","Paper mills",322120,4024469,{"$f":"(E22/$E$83)*100","v":0.78019182972131074},null,{"$f":"(G22/$G$83)*100","v":0},963,{"$f":"(I22/$I$83)*100","v":0.8107459620557419},null,null,10560,{"$f":"(M22/$M$83)*100","v":1.3666470815096274},3329139,{"$f":"(O22/$O$83)*100","v":0.55004097787020045}]
[null,null,"Pulp mills",322110]
["Quimica","Chemicals",null,null,3661973,{"$f":"(E24/$E$83)*100","v":0.70991761031332024},null,{"$f":"(G24/$G$83)*100","v":0},{"$f":"4209/2","v":2104.5},{"$f":"(I24/$I$83)*100","v":1.7717703812526571},null,null,9481,{"$f":"(M24/$M$83)*100","v":1.2270057746015888},{"$f":"6398104/2","v":3199052},{"$f":"(O24/$O$83)*100","v":0.52854797902329109}]
["Textil e confeccoes","Textile","Apparel accessories and other apparel manufacturing",315900,3130392,0.60686422537357176,1979412,0.3546195112926534,950,0.79980131251604858,null,null,13059,1.6900610073327864]
["Artigos de borracha e plastico","Rubber and plastic items",null,null,2700983,0.52361811429437155,null,0,null,0,null,null,null,0]
["Moveis e produtos de madeira","wooden based products","All other miscellaneous wood product manufacturing",321999,2213129,0.42904173542380236,null,0,301,0.25341073164982175,null,null,7207,0.93271074966286782,3172652,{"$f":"(O27/$O$83)*100","v":0.5241861660092435}]
["Materiais nao metalicos","Non metallic materials",null,null,2006362,0.38895745994398478,null,0,null,0,null,null,null,0,null,0]
["Autopecas e acessorios","Vehicles and accessories","Motor vehicle parts manufacturing",336300,1967945,0.38150986138566478,null,0,null,0,null,null,null,0,null,0]
["Refino de petroleo e producao de alcool","Petroleum refineries and alchool production",null,null,1657942,0.3214120428190177,null,0,null,0,null,null,null,0,null,0]
["Eletroeletronica","Electronics",null,null,1200951,0.23281882854499258,null,0,916,0.77117684448915846,null,null,12232,1.5830328694153184,4935785,0.81549133513411942]
["Extracao de minerais metalicos e nao metalicos","Metallic and non metallic minerals extraction","Iron ore mining                                                                                     ",212210,1170875,0.22698823338555713,{"$f":"J27/2","v":0.12670536582491088},2.2699768874285273E-8,121,0.10186943033099147,null,null,null,0,3693019,0.61016130058048934]
["Artefatos de couro","Leather artifacts",null,null,755180,0.14640074652555143,null,0,null,0,null,null,3094,0.40041724149533964,null,0]
["Edicao, impressao e reproducao","Publication, printing and reproduction",null,null,541519,0.10497998604010975,null,0,null,0,null,null,null,0,1560220,0.25777984472641247]
["Demais industrias","Other Industries",null,null,1406101,0.27258962908223783,6800733,1.2183782925898299,3658,3.0796560012460059,null,null,11730,1.5180653661087053,5723206,0.94558918230587485]
["Acucar e alcool","Sugar and alchool",null,null,null,null,null,null,null,null,null,null,null,null,9070434,1.4986188281916475]
["Bens de capital","Capital goods",null,null,null,null,null,null,null,null,null,null,null,null,8486204,1.4020922366311548]
["Farmaceutico e cosmeticos","Pharmaceuticals and cosmetics","Pharmaceutical preparation manufacturing",325412,null,null,null,null,null,null,null,null,null,null,4394102,0.72599436699441011]
["Material de construcao","Construction material","Cement manufacturing                                                                                ",327310,null,null,null,null,null,null,null,null,null,null,5320762,0.87909730819127807]
[null,null,"Valve and fittings other than plumbing","33291A"]
["Embalagens","Packaging",null,null,null,null,null,null,null,null,null,null,null,null,2247092,{"$f":"(O41/$O$83)*100","v":0.37126496702129419}]
["Petroleo e gas natural","Petroleum and natural gas","Crude Petroleum and Natural Gas Extraction","211111B",null,null,null,null,12,{"$f":"(I42/$I$83)*100","v":1.0102753421255351E-2},null,null,40488,{"$f":"(M42/$M$83)*100","v":5.2398491511516845},3713004,{"$f":"(O42/$O$83)*100","v":0.61346322607616133}]
["Comercio","Commerce",null,null,{"$f":"SUM(E44:E59)","v":45441145},8.8093137410628302,33994617,6.0902704778595496,10447,8.7952887493212213,20215915,{"$f":"(K43/K83)*100","v":8.8311607331393471},{"$f":"SUM(M44:M59)","v":34307},{"$f":"SUM(N44:N59)","v":4.4399205895218543},{"$f":"SUM(O44:O59)","v":35317589.5},{"$f":"SUM(P44:P59)","v":5.8351788449200592}]
["Comercio varejista","Commerce",null,null,null,null,23923477,{"$f":"(G44/$G$83)*100","v":4.2859857988943348},null,{"$f":"(I44/$I$83)*100","v":0},null,null,17875,{"$f":"(M44/$M$83)*100","v":2.3133349035970254},null,{"$f":"(O44/$O$83)*100","v":0}]
["Produtos em lojas especializadas","Specialist products business",null,null,8202678,{"$f":"(E45/$E$83)*100","v":1.5901880117438454},null,0,null,0,null,null,null,0,null,0]
["Varejista nao especializado","Non specialist proudcts business",null,null,4997814,0.96888649142701366,null,0,null,0,null,null,null,0,null,0]
["Produtos alimenticios, bebidas e fumo","Food, drinks and tabacco",null,null,4627035,0.89700651261931574,null,0,null,0,null,null,null,0,null,0]
["Residuos e sucata","Waste and scrap",null,null,3592098,0.69637149923586461,null,0,null,0,null,null,null,0,null,0]
["Veiculos automotores","Vehicles                 ",null,null,3568137,0.69172637054138286,null,0,592,0.49840250211526399,null,null,null,0,null,0]
["Reparacao, pecas e acessorios para veiculos automotores","Vehicles parts and accessories and repair",null,null,3083494,0.59777248272869865,null,0,null,0,null,null,null,0,null,0]
["Vestuario e calcados","Textile and accessories (shoes)",null,null,2942289,0.57039819128408886,null,0,null,0,null,null,null,0,5320830,0.87910854316419307]
["Produtos agropecuarios","Agricultural products",null,null,2186741,0.42392610352237992,null,0,null,0,null,null,9532,1.2336060588020614,{"$f":"12522693/2","v":6261346.5},1.0345008579227712]
["Artigos de uso pessoal e domestico","Personal and domestic use goods",null,null,2179997,0.42261869782497224,null,0,null,0,null,null,null,0,null,0]
["Combustiveis","Fuel",null,null,1921946,0.37259240072803496,null,0,null,0,null,null,null,0,null,0]
["Atacadista de mercadorias em geral","General goods wholesalers",null,null,1151577,0.22324708345249469,4989191,0.89383335766667316,null,0,null,null,6900,0.8929796271227679,null,0]
["Utilidades domesticas","Domestic utilities",null,null,null,null,null,null,null,null,null,null,null,null,3035811,0.50157726999957375]
["Intermediario do comercio","Business Traders",null,null,904057,{"$f":"(E57/$E$83)*100","v":0.17526234765440088},null,{"$f":"(G57/$G$83)*100","v":0},null,{"$f":"(I57/$I$83)*100","v":0},null,null,null,{"$f":"(M57/$M$83)*100","v":0},1591520,0.26295123667109765]
["Demais comercios","Other commerce",null,null,2340900,{"$f":"(E58/$E$83)*100","v":0.45381168402455485},null,{"$f":"(G58/$G$83)*100","v":0},9855,{"$f":"(I58/$I$83)*100","v":8.2968862472059577},null,null,null,{"$f":"(M58/$M$83)*100","v":0},14496263,2.395075326077885]
["Intermdiarios financeiros","Financial traders",null,null,3742382,{"$f":"(E59/$E$83)*100","v":0.72550586427578345},5081949,{"$f":"(G59/$G$83)*100","v":0.91045132129854156},null,{"$f":"(I59/$I$83)*100","v":0},null,null,null,{"$f":"(M59/$M$83)*100","v":0},4611819,0.76196561108453864]
["Servicos","Services",null,null,{"$f":"SUM(E61:E74)","v":84762710},16.432273128961072,25398834.795288749,4.5503020000425058,14812,12.470165306302855,43399045,18.958525600238598,102017,13.202768495678756,64143767,10.597845366311917]
["Construcao civil","Civil contruction",null,null,23492691,{"$f":"(E61/$E$83)*100","v":4.5543413494717866},11450176,{"$f":"(G61/$G$83)*100","v":2.0513444484194645},2079,{"$f":"(I61/$I$83)*100","v":1.7503020302324894},null,null,15719,{"$f":"(M61/$M$83)*100","v":2.0343111244554768},null,{"$f":"(O61/$O$83)*100","v":0}]
["Construcao pesada","Heavy construction",null,null,null,null,null,null,null,null,null,null,8131,1.0522923692949602,null,0]
["Transporte e armazenagens","Transport and storage",null,null,17486148,{"$f":"(E63/$E$83)*100","v":3.3899005813928835},6729159,{"$f":"(G63/$G$83)*100","v":1.2055555265859559},1847,{"$f":"(I63/$I$83)*100","v":1.5549821307548861},null,null,24425,3.1610184626773341,17392292,2.8735577874892169]
["Atividades imbiliarias, alugueis e servicos prestados as empresas","Business support related to real estate",null,null,12063574,2.3386692435793224,null,0,null,0,null,null,15443,1.998591939370566,17741892,2.9313187658873616]
["Holdings, atividades juridicas, contabeis e assessoria empresarial","Holdings, legal activities,  tax and business suport services",null,null,5701013,1.105210094483267,null,0,null,0,null,null,null,0,null,0]
["Atividades associativas, recreativas, culturais e disportivas","Social, sports and cultural activities",null,null,4037140,0.78264825581737429,null,0,null,0,null,null,null,0,3449683,0.56995728044464544]
["Producao e distribuicao de eletricidade, gas e agua","Production and distribution of electricity, gas and water",null,null,3838605,0.74415985277247054,null,0,320,0.26940675790014273,null,null,null,0,null,0]
["Alojamento e alimentacao","Food and Lodging  ",null,null,2799137,0.54264645041883053,1808854,0.32406336906099453,null,0,null,null,null,0,null,0]
["Servicos sociais, educacao, saude, defesa e seguridade social","Social services, education, health, and defense ",null,null,2790481,0.54096838047269169,3393988,0.60804641271909543,644,0.54218110027403721,null,null,null,0,{"$f":"1376212+1726480+3060","v":3105752},0.51313293530319126]
["Media","Media",null,null,null,null,null,null,null,null,null,null,null,null,996835,0.16469726802492815]
["Telecomunicaoes","Telecommunications","Telecommunications",517000,427936,{"$f":"(E71/$E$83)*100","v":8.296055227251567E-2},1672045,{"$f":"(G71/$G$83)*100","v":0.29955349404738613},138,{"$f":"(I71/$I$83)*100","v":0.11618166434443655},null,null,11821,{"$f":"(M71/$M$83)*100","v":1.5298423437997448},1571581,0.25965691130416224]
["Demais servicos","Other services",null,null,12125985,{"$f":"(E72/$E$83)*100","v":2.3507683682799314},{"$f":"344604+J43","v":344612.79528874933},{"$f":"(G72/$G$83)*100","v":6.1738749209609471E-2},7736,{"$f":"(I72/$I$83)*100","v":6.51290837223595},43394717,{"$f":"(K72/K83)*100","v":18.95663494806416},26478,{"$f":"(M72/$M$83)*100","v":3.4267122560806738},19799404,3.2712612893024766]
["Terceiro Setor","Third Sector",null,null,null,null,null,null,null,null,null,null,null,null,86328,1.4263128555935532E-2]
["Financeiro","Financial   ",null,null,null,null,null,null,2048,{"$f":"(I74/$I$83)*100","v":1.7242032505609133},4328,{"$f":"(K74/K83)*100","v":1.8906521744391531E-3},null,{"$f":"(M74/$M$83)*100","v":0},null,0]
["Diversos",null,null,null,null,null,null,null,null,null,null,null,null,null,10203257,1.6857840594042388]
["Agricultura, pecuaria, pesaca, silvicultura e exploracao florestal","Agriculture, livestock farming, fishing and forestry","Soybean Farming",111110,3580238,{"$f":"(E76/$E$83)*100","v":0.69407229526622427},{"$f":"J27/2","v":0.12670536582491088},{"$f":"(G76/$G$83)*100","v":2.2699768874285273E-8},916,{"$f":"(I76/$I$83)*100","v":0.77117684448915846},5084037,{"$f":"(K76/K83)*100","v":2.2209208893204968},null,null,{"$f":"12522693/2","v":6261346.5},1.0345008579227712]
[null,null,"Cotton farming",111920]
[null,null,"Sugarcane Farming",111930]
[null,null,"Cattle ranching and farming                                                                         ","1121A0"]
[null,null,"Logging",113310]
[null,null,"Other aquaculture",112519]
["Pessoa Fisica",null,null,null,133959048,{"$f":"(E82/$E$83)*100","v":25.969576301083418},352963833,{"$f":"(G82/$G$83)*100","v":63.234870740624856},{"$f":"4279+28153","v":32432},{"$f":"(I82/$I$83)*100","v":27.304374913179462},72912861,{"$f":"(K82/K83)*100","v":31.851399998666757},null,null,184081226,{"$f":"(O82/$O$83)*100","v":30.413935121539044}]
["TOTAL",null,null,null,{"$f":"SUM(E5:E82)","v":515830703},{"$f":"SUM(F5:F82)","v":100.68746143809901},{"$f":"SUM(G4:G82)","v":558179100.97069359},{"$f":"SUM(H4:H82)","v":100},{"$f":"SUM(I4:I82)","v":118779.5},{"$f":"SUM(J3:J82)","v":101.77177038125267},{"$f":"SUM(K3:K82)","v":228915718},{"$f":"SUM(L2:L82)","v":100},{"$f":"SUM(M4:M72)","v":772694},{"$f":"SUM(N4:N82)","v":100.00000000000001},{"$f":"SUM(O4:O82)","v":605252905.5},{"$f":"SUM(P4:P82)","v":100.00000000000001}]