{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Demand","Effort","Growth","CALCULATIONS","H,G&B","P,MEC&MUC","TWP,TEC,CS,Rent,PS","DynWelf","Phase","Supply"],"not_rendered":{"charts":16,"images":1,"macros":1,"external_links":0,"defined_names":248,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"H,G&B","index":4,"reason":"not_a_worksheet"},{"sheet":"P,MEC&MUC","index":5,"reason":"not_a_worksheet"},{"sheet":"TWP,TEC,CS,Rent,PS","index":6,"reason":"not_a_worksheet"},{"sheet":"DynWelf","index":7,"reason":"not_a_worksheet"}],"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":"Demand","index":0,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,"Consumer Demand"]
[null,"Intercept alpha:",{"$f":"CALCULATIONS!C5","v":60}]
[null,"Slope beta:",{"$f":"CALCULATIONS!C6","v":3}]
[]
[]
[null,"Harvest","Demand"]
[null,0,{"$f":"$C$2-$C$3*B7","v":60}]
[null,1,{"$f":"$C$2-$C$3*B8","v":57}]
[null,2,54]
[null,3,51]
[null,4,48]
[null,5,45]
[null,6,42]
[null,7,39]
[null,8,36]
[null,9,33]
[null,10,30]
[null,11,27]
[null,12,24]
[null,13,21]
[null,14,18]
[null,15,15]
[null,16,12]
[null,17,9]
[null,18,6]
[null,19,3]
[null,20,0]
[null,21,-3]
[null,22,-6]

{"sheet":"Effort","index":1,"n_rows":79,"n_cols":22,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Effort"]
[null,null,null,null,"Catchability c:",{"$f":"CALCULATIONS!F5","v":0.1}]
[null,null,null,null,"Effort elasticity a:",{"$f":"CALCULATIONS!F6","v":1.5}]
[null,null,null,null,"Biomass elasticity b:",{"$f":"CALCULATIONS!F7","v":0.5}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Biomass ",null,"Harvest"]
[null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[200,{"$f":"(B$34/($F$2*$A35^$F$4))^$F$3","v":0},0.5946035575013604,1.6817928305074288,3.0896507158606763,4.7568284600108832,6.6478698711812338,8.7388518907318193,11.012211992760262,13.454342644059432,16.054296052536735,18.803015465431965,21.692845891667776,24.717205726885407,27.87035699687792,31.147239103778425,34.543345136976811,38.054627680087073,41.677425640084273,45.408406423700569,49.24451955374591,53.182958969449857]
[190,0,0.61792362418106228,1.7477519396551873,3.2108253368360882,4.9433889934484982,6.90859614285944,9.0815854755295167,11.444105671703802,13.982015517241495,16.683937852888679,19.540460724380537,22.543628915556809,25.686602694688712,28.963419046969676,32.368818900308753,35.898118585220757,39.547111947588,43.311994308070844,47.189302370690058,51.175866020001493,55.268769142875513]
[180,0,0.64349565849348267,1.8200805751393774,3.3437015248821096,5.1479652679478622,7.1945001780870861,9.4574160900317583,11.917706374864524,14.560644601115019,17.374382779324026,20.349119452692818,23.476570187901121,26.749612199056873,30.162035699077304,33.708363975427396,37.383719530530499,41.183722143582877,45.104409683115335,49.142175528763183,53.293718373624792,57.556001424696717]
[170,0,0.67168137966789776,1.8998018334396263,3.4901588282482798,5.3734510373431821,7.50962612079132,9.8716598994898153,12.439713236118097,15.198414667517014,18.13539725103324,21.240430216748681,24.504866265293341,27.921270625986232,31.483161517171002,35.184822341100634,39.021161961170861,42.987608298745478,47.080025677232776,51.294649502869909,55.628033868376519,60.077008966330574]
[160,0,0.70292665648793617,1.9881768219176261,3.652514049094862,5.6234132519034903,7.8589589355183449,10.330869809976447,13.018383860896446,15.905414575341007,18.979019725174275,22.228492625486524,25.64478372180476,29.220112392758903,32.947695337150307,36.821550032517528,40.83634851274558,44.987306015227915,49.270094479954359,53.68077419177591,58.215738946684993,62.871671484146752]
[150,0,0.73778794646688095,2.086779440097716,3.8336586254776344,5.9023035717350476,8.2487200063996085,10.843224043318136,13.664023986566816,16.694235520781731,19.920274554605783,23.330903410537211,26.916623726052059,30.669269003821075,34.581719528273062,38.647696076788158,42.861606445481989,47.218428573880374,51.71361975403849,56.343044882638331,61.102918907819102,65.989760051196853]
[140,0,0.77696950424091227,2.197601620895596,4.0372519718305879,6.2157560339272981,8.686783139634958,11.419072986560673,14.389676591518191,17.580812967164771,20.978176614504637,24.56993305893139,28.3460795102711,32.298015774644696,36.418244031161777,40.700151587775359,45.137849256541294,49.726048271418378,54.459964675774209,59.335243764181094,64.347899472781663,69.494265117079678]
[130,0,0.82137690182495449,2.3232047087616898,4.2679995783730043,6.5710152145996368,9.1832729381438423,12.071725775875509,15.212113104170808,18.585637670093515,22.177176349273779,25.974218272193703,29.966188942997533,34.143996626984027,38.499714968151103,43.026353328543706,47.717685925912399,52.56812171679708,57.572603319336871,62.726527136565593,68.02567928265654,73.466183505150724]
[120,0,0.87219594949342116,2.4669426816409508,4.5320630960351513,6.9775675959473675,9.7514471638363123,12.818610191887021,16.153295038142108,19.735541453127603,23.549290636322372,27.581257663723935,31.820213789511921,36.256504768281218,40.881713835956894,45.688417839909206,50.67000580526377,55.820540767578933,61.134652441953428,66.607452404305675,72.234466053339276,78.011577310690512]
[110,0,0.93101244462222277,2.633300851845755,4.8376825696937864,7.4480995569777839,10.409035570367744,13.683032601033753,17.242591771836871,21.066406814766037,25.137336004800002,29.441198549676049,33.966008493597947,38.701460557550305,43.638570393346534,48.769414268388857,54.086935397005867,59.584796455822257,65.257265015012877,71.099122999835359,77.105594064453513,83.272284562941906]
[100,0,1,2.8284271247461898,5.196152422706632,7.9999999999999982,11.180339887498945,14.696938456699071,18.520259177452129,22.627416997969508,27,31.622776601683803,36.482872693909407,41.56921938165307,46.87216658103187,52.383203414835151,58.094750193111238,63.999999999999979,70.092795635500266,76.367532368147081,82.819079927272767,89.442719099991592]
[90,0,1.0822263849169962,3.0609984622152431,5.6234132519034903,8.6578110793359695,12.099658818591282,15.905414575341014,20.043113137339851,24.487987697721959,29.220112392758903,34.223003202678022,39.482727426916576,44.987306015227915,50.726295392217345,56.690484862008752,62.871671484146752,69.262488634687742,75.856272829333207,82.646958479811516,89.628993471844268,96.797270548730282]
[80,0,1.1821770112539696,3.3437015248821096,{"$f":"(E$34/($F$2*$A47^$F$4))^$F$3","v":6.1427719410953987},9.4574160900317583,13.217140793007051,17.374382779324034,21.894224642049277,26.749612199056873,31.918779303857164,37.383719530530499,43.12921340324489,49.142175528763204,55.411197799762469,61.926218852858575,68.678278152838246,75.659328720254052,82.862091654810953,90.27994117181693,97.906812383226992,105.73712634405643]
[70,{"$f":"(B$34/($F$2*$A48^$F$4))^$F$3","v":0},1.3067017417552778,3.6959106503337189,6.7898214211766614,10.453613934042224,14.609369604410883,19.204515079838796,24.200454924935883,29.567285202669744,35.280947027392514,41.321537264558245,47.672233293367455,54.318571369413306,61.247941711277832,68.449223140886119,75.912511264176231,83.628911472337776,91.590378141404884,99.789587559010371,108.21983599153693,116.87495683528699]
[60,0,1.4668528946556556,4.148886515256522,7.6219912223192203,11.734823157245247,16.399913927211919,21.558246717785043,27.166495784218636,33.191092122052183,39.605028155702719,46.385961395229018,53.515007416414782,60.975929778553748,68.754573228168653,76.838453560387066,85.216452485062462,93.878585257961959,102.81582017244082,112.01993591192615,121.48340712403821,131.1993114176953]
[50,0,1.6817928305074288,4.7568284600108832,8.7388518907318193,13.454342644059432,18.803015465431965,24.717205726885407,31.147239103778425,38.054627680087073,45.408406423700569,53.182958969449857,61.356633732932124,69.910815125854569,78.829273706329289,88.097695942082083,97.703334364894616,107.63474115247547,117.88156117000672,128.43436842029385,139.28453485090915,150.42412372345569]
[40,0,1.9881768219176261,5.6234132519034903,10.330869809976447,15.905414575341007,22.228492625486524,29.220112392758903,36.821550032517528,44.987306015227915,53.68077419177591,62.871671484146752,72.534401887002147,82.646958479811516,93.190155189469522,104.14707088717149,115.50263580903831,127.24331660272803,139.35687166591046,151.83215780139426,164.65897512394704,177.82794100389225]
[30,0,2.4669426816409508,6.9775675959473675,12.818610191887021,19.735541453127603,27.581257663723935,36.256504768281218,45.688417839909206,55.820540767578933,66.607452404305675,78.011577310690512,90.001155797478205,102.5488815350962,115.63094831973211,129.22636030513684,143.31641883065498,157.88433162502079,172.91490922875215,188.39432509057886,204.30992312682253,220.65006130979154]
[20,0,3.3437015248821096,9.4574160900317583,17.374382779324034,26.749612199056873,37.383719530530499,49.142175528763204,61.926218852858575,75.659328720254052,90.27994117181693,105.73712634405643,121.9878370587047,138.99506223459238,156.72653487152445,175.1537971363941,194.25150480835137,213.99689759245504,234.36938764967223,255.35023443085737,276.92228384215542,299.06975624424393]
[10,0,5.6234132519034903,15.905414575341007,29.220112392758903,44.987306015227915,62.871671484146752,82.646958479811516,104.14707088717149,127.24331660272803,151.83215780139426,177.82794100389225,205.15826977443797,233.76089914207108,263.58156269720229,294.57240026014045,326.69078810196459,359.89844812182326,394.16075583963499,429.44619353420705,465.72591157347966,502.97337187317413]
[1E-3,0,5623.4132519034893,15905.414575341025,29220.112392758896,44987.306015227929,62871.671484146791,82646.958479811496,104147.07088717166,127243.31660272801,151832.15780139421,177827.94100389219,205158.26977443791,233760.89914207163,263581.56269720272,294572.40026013984,326690.7881019648,359898.44812182349,394160.75583963527,429446.19353420695,465725.91157348122,502973.37187317444]
[]
["Harvest",null,"Biomass"]
[null,20,40,60,80,100,120,140,160]
[0,{"$f":"($A59/($F$2*B$58^$F$4))^$F$3","v":0},{"$f":"($A59/($F$2*C$58^$F$4))^$F$3","v":0},0,0,0,0,0,0]
[1,{"$f":"($A60/($F$2*B$58^$F$4))^$F$3","v":3.3437015248821096},1.9881768219176261,1.4668528946556556,1.1821770112539696,1,0.87219594949342116,0.77696950424091227,0.70292665648793617]
[2,9.4574160900317583,5.6234132519034903,4.148886515256522,3.3437015248821096,2.8284271247461898,2.4669426816409508,2.197601620895596,1.9881768219176261]
[3,17.374382779324034,10.330869809976447,7.6219912223192203,6.1427719410953987,5.196152422706632,4.5320630960351513,4.0372519718305879,3.652514049094862]
[4,26.749612199056873,15.905414575341007,11.734823157245247,9.4574160900317583,7.9999999999999982,6.9775675959473675,6.2157560339272981,5.6234132519034903]
[5,37.383719530530499,22.228492625486524,16.399913927211919,13.217140793007051,11.180339887498945,9.7514471638363123,8.686783139634958,7.8589589355183449]
[6,49.142175528763204,29.220112392758903,21.558246717785043,17.374382779324034,14.696938456699071,12.818610191887021,11.419072986560673,10.330869809976447]
[7,61.926218852858575,36.821550032517528,27.166495784218636,21.894224642049277,18.520259177452129,16.153295038142108,14.389676591518191,13.018383860896446]
[8,75.659328720254052,44.987306015227915,33.191092122052183,26.749612199056873,22.627416997969508,19.735541453127603,17.580812967164771,15.905414575341007]
[9,90.27994117181693,53.68077419177591,39.605028155702719,31.918779303857164,27,23.549290636322372,20.978176614504637,18.979019725174275]
[10,105.73712634405643,62.871671484146752,46.385961395229018,37.383719530530499,31.622776601683803,27.581257663723935,24.56993305893139,22.228492625486524]
[11,121.9878370587047,72.534401887002147,53.515007416414782,43.12921340324489,36.482872693909407,31.820213789511921,28.3460795102711,25.64478372180476]
[12,138.99506223459238,82.646958479811516,60.975929778553748,49.142175528763204,41.56921938165307,36.256504768281218,32.298015774644696,29.220112392758903]
[13,156.72653487152445,93.190155189469522,68.754573228168653,55.411197799762469,46.87216658103187,40.881713835956894,36.418244031161777,32.947695337150307]
[14,175.1537971363941,104.14707088717149,76.838453560387066,61.926218852858575,52.383203414835151,45.688417839909206,40.700151587775359,36.821550032517528]
[15,194.25150480835137,115.50263580903831,85.216452485062462,68.678278152838246,58.094750193111238,50.67000580526377,45.137849256541294,40.83634851274558]
[16,213.99689759245504,127.24331660272803,93.878585257961959,75.659328720254052,63.999999999999979,55.820540767578933,49.726048271418378,44.987306015227915]
[17,234.36938764967223,139.35687166591046,102.81582017244082,82.862091654810953,70.092795635500266,61.134652441953428,54.459964675774209,49.270094479954359]
[18,255.35023443085737,151.83215780139426,112.01993591192615,90.27994117181693,76.367532368147081,66.607452404305675,59.335243764181094,53.68077419177591]
[19,276.92228384215542,164.65897512394704,121.48340712403821,97.906812383226992,82.819079927272767,72.234466053339276,64.347899472781663,58.215738946684993]
[20,299.06975624424393,177.82794100389225,131.1993114176953,105.73712634405643,89.442719099991592,78.011577310690512,69.494265117079678,62.871671484146752]

{"sheet":"Growth","index":2,"n_rows":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"Growth"]
[null,null,null,null,null,null,null,"Growth rate g:",{"$f":"CALCULATIONS!I5","v":0.25}]
[null,null,null,null,null,null,null,"Carrying capacity K:",{"$f":"CALCULATIONS!I6","v":200}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"tau(0.999):","t","Growth",null,null,null,null,null,null,"Biomass","Growth"]
[null,null,{"$f":"-LN((1/0.999-1))/I2","v":27.62701911459386},0,{"$f":"$I$3/(1+EXP(-$I$2*(D32-$C$32)))","v":0.20000000000001766},null,null,null,null,null,null,0,{"$f":"$I$2*(1-L32/$I$3)*L32","v":0}]
[null,null,null,{"$f":"D32+$C$32/11","v":2.5115471922358057},{"$f":"$I$3/(1+EXP(-$I$2*(D33-$C$32)))","v":0.37440230421920867},null,null,null,null,null,null,{"$f":"$I$3/20","v":10},{"$f":"$I$2*(1-L33/$I$3)*L33","v":2.375}]
[null,null,null,{"$f":"D33+$C$32/11","v":5.0230943844716114},0.7003523431511095,null,null,null,null,null,null,{"$f":"L33+$I$3/20","v":20},4.5]
[null,null,null,7.5346415767074166,1.3082108513443471,null,null,null,null,null,null,30,6.375]
[null,null,null,10.046188768943223,2.4371977915447012,null,null,null,null,null,null,40,8]
[null,null,null,12.557735961179029,4.5183448851746233,null,null,null,null,null,null,50,9.375]
[null,null,null,15.069283153414835,8.3019266101806206,null,null,null,null,null,null,60,10.5]
[null,null,null,17.580830345650639,15.010526632978543,null,null,null,null,null,null,70,11.375]
[null,null,null,20.092377537886446,26.393799716164072,null,null,null,null,null,null,80,12]
[null,null,null,22.603924730122252,44.340460405015442,null,null,null,null,null,null,90,12.375000000000002]
[null,null,null,25.115471922358058,69.597970841715565,null,null,null,null,null,null,100,12.5]
[null,null,null,27.627019114593864,100.00000000000004,null,null,null,null,null,null,110,12.374999999999998]
[null,null,null,30.13856630682967,130.40202915828453,null,null,null,null,null,null,120,12]
[null,null,null,32.650113499065476,155.65953959498461,null,null,null,null,null,null,130,11.375]
[null,null,null,35.161660691301279,173.60620028383593,null,null,null,null,null,null,140,10.500000000000002]
[null,null,null,37.673207883537081,184.98947336702147,null,null,null,null,null,null,150,9.375]
[null,null,null,40.184755075772884,191.69807338981937,null,null,null,null,null,null,160,7.9999999999999982]
[null,null,null,42.696302268008687,195.48165511482537,null,null,null,null,null,null,170,6.3750000000000009]
[null,null,null,45.207849460244489,197.56280220845531,null,null,null,null,null,null,180,4.4999999999999991]
[null,null,null,47.719396652480292,198.69178914865566,null,null,null,null,null,null,190,2.3750000000000022]
[null,null,null,50.230943844716094,199.29964765684889,null,null,null,null,null,null,200,0]
[null,null,null,52.742491036951897,199.62559769578081,null,null,null,null,null,null,210,-2.6250000000000022]
[null,null,null,55.254038229187699,199.79999999999998,null,null,null,null,null,null,220,-5.5000000000000053]

{"sheet":"CALCULATIONS","index":3,"n_rows":66,"n_cols":26,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Capture Fishery"]
[]
[null,"Consumer Demand",null,null,null,"Effort",null,null,"Growth",null,null,"Other Prices",null,null,"Biomass"]
[null,"Intercept alpha:",60,null,"Catchability c:",0.1,null,"Growth rate g:",0.25,null,"Discount rate r:",0.05,null,"Initial Biomass B0:",60]
[null,"Slope beta:",3,null,"Effort elasticity a:",1.5,null,"Carrying Capacity K:",200,null,"Price of effort Pe:",3]
[null,null,null,null,"Biomass elasticity b:",0.5]
[]
[null,null,null,null,null,null,null,null,null,"Consumer Surplus:",{"$f":"SUM(X16:X66)","v":3502.3806385180833}]
[null,null,null,null,null,"Total Willing to Pay:",{"$f":"SUM(P16:P66)","v":9596.2431691320253},null,null,"Total Rent:",{"$f":"SUM(Y16:Y66)","v":2766.4460753886401},null,null,"Dynamic Welfare",{"$f":"SUM(W16:W66)","v":7965.1943575453643}]
[null,null,null,null,null,"Total Effort Costs:",{"$f":"SUM(Q16:Q66)","v":2218.2776368168666},null,null,"Producer Surplus:",{"$f":"SUM(Z16:Z66)","v":1109.1388184084328},null,null,"Total User Costs|Benefits",{"$f":"SUM(V16:V66)","v":587.22882523020633}]
[null,null,null,null,null,"Net Present Value:",{"$f":"SUM(R16:R66)","v":7377.9655323151519},null,null,"Net Present Value:",{"$f":"G12","v":7377.9655323151519},null,null,"Net Present Value:",{"$f":"G12","v":7377.9655323151519}]
[]
[null,null,null,null,"Undiscounted",null,null,null,null,null,null,null,null,null,null,"Discounted"]
["Time","Harvest","Growth","Biomass","TWP","TEC","TWP-TEC","Price","MEC","MUC","TUC|B","Dyn Welf","Con Sur","Tot Rent","Pro Sur","TWP","TEC","TWP-TEC","Price","MEC","MUC","TUC|B","Dyn Welf","Con Sur","Tot Rent","Pro Sur"]
[0,6.552092710274521,{"$f":"IF(D16<0,-1,$I$5*(1-D16/$I$6)*D16)","v":10.5},{"$f":"O5","v":60},{"$f":"$C$5*B16-0.5*$C$6*B16^2","v":328.73068429042246},{"$f":"IF(OR(B16<=0,D16<=0),0,$L$6*(B16/($F$5*D16^$F$7))^$F$6)","v":73.803654625296247},{"$f":"E16-F16","v":254.92702966512621},{"$f":"$C$5-$C$6*B16","v":40.343721869176434},{"$f":"IF($F$6=1,$F$6*$L$6/($F$5*D16^$F$7)^$F$6,IF(B16<=0,0,$F$6*$L$6*B16^($F$6-1)/($F$5*D16^$F$7)^$F$6))","v":16.896201997316663},{"$f":"(1/(1+L5))*(J17+F6*F7/D16*L6*(B16/(F5*D16^F7))^F6+J17*I5*(1-2*D16/I6))","v":25.442683373201856},{"$f":"J17*(C16-B16)","v":92.568634628098224},{"$f":"G16+K16","v":347.49566429322442},{"$f":"E16-H16*B16","v":64.394878326048797},{"$f":"J17*B16","v":153.63032402642938},{"$f":"I16*B16-F16","v":36.901827312648066},{"$f":"(1/(1+$L$5))^$A16*E16","v":328.73068429042246},{"$f":"(1/(1+$L$5))^$A16*F16","v":73.803654625296247},{"$f":"(1/(1+$L$5))^$A16*G16","v":254.92702966512621},{"$f":"(1/(1+$L$5))^$A16*H16","v":40.343721869176434},16.896201997316663,{"$f":"(1/(1+$L$5))^(A16-1)*J16","v":26.714817541861951},{"$f":"(1/(1+$L$5))^$A16*K16","v":92.568634628098224},347.49566429322442,64.394878326048797,153.63032402642938,36.901827312648066]
[1,7.1542519478292945,{"$f":"IF(D17<0,-1,$I$5*(1-D17/$I$6)*D17)","v":10.875308264012213},{"$f":"D16+C16-B16","v":63.947907289725478},{"$f":"$C$5*B17-0.5*$C$6*B17^2","v":352.48013547022879},{"$f":"IF(OR(B17<=0,D17<=0),0,$L$6*(B17/($F$5*D17^$F$7))^$F$6)","v":80.278240979824417},{"$f":"E17-F17","v":272.20189449040436},{"$f":"$C$5-$C$6*B17","v":38.537244156512116},{"$f":"IF($F$6=1,$F$6*$L$6/($F$5*D17^$F$7)^$F$6,IF(B17<=0,0,$F$6*$L$6*B17^($F$6-1)/($F$5*D17^$F$7)^$F$6))","v":16.831579646321096},{"$f":"H16-I16","v":23.447519871859772},{"$f":"J18*(C17-B17)","v":80.768000022593725},{"$f":"G17+K17","v":352.96989451299805},{"$f":"E17-H17*B17","v":76.774981399528883},{"$f":"J18*B17","v":155.28779260096329},{"$f":"I17*B17-F17","v":40.139120489912187},335.6953671145036,76.455467599832772,259.23989951467081,36.702137291916301,16.030075853639136,{"$f":"(1/(1+$L$5))^(A17-1)*J17","v":23.447519871859772},76.92190478342259,336.16180429809339,73.119029904313223,147.89313581044121,38.227733799916365]
[2,7.6897460626262983,11.193380107104904,{"$f":"D17+C17-B17","v":67.668963605908402},372.68647199606289,85.742690800563224,286.9437811954997,36.930761812121105,16.725394460804722,21.705664510191021,{"$f":"J19*(C18-B18)","v":70.792212933268587},{"$f":"G18+K18","v":357.73599412876831},88.698291761514952,155.37414403370312,42.871345400281598,338.03761632295954,77.771148118424691,260.26646820453487,33.497289625506667,15.170425814788862,20.672061438277161,64.210623975753819,324.47709218028871,80.451965316566842,140.92892882875566,38.885574059212331]
[3,8.1665755283777148,11.461226092216908,71.172597650387004,389.95509791161624,90.353840386444361,299.60125752517189,35.500273414866854,16.595788541808741,20.205367351316383,62.283671746110407,361.88492927128232,100.03943379104663,154.38490354090308,45.176920193222188,336.85787531507719,78.051044497522383,258.80683081755478,30.666470933909384,14.336066119692248,18.326863810717807,53.802977428882755,312.60980824643758,86.41782424450632,133.3634843242873,39.025522248761199]
[4,8.5917375145230395,11.685098232807579,74.467248214226188,404.77732059368861,94.247269355388056,310.53005123830053,34.224787456430882,16.454285736047666,18.904484873058113,54.970571966041277,365.50062320434182,110.72693027769384,152.67948628291268,47.123634677694014,333.01130339205457,77.537461741054841,255.47384165099973,28.156817339631843,13.536981595979176,16.330404814217136,45.224425597187398,300.69826724818711,91.095319565566882,125.60979121490544,38.768730870527406]
[5,8.9711980741393873,11.870592160650354,77.560608932510718,417.5482921201999,97.536241305772506,320.01205081442743,33.086405777581838,16.30823004347652,17.770501720383216,48.646543505906749,368.65859432033415,120.72359232816342,150.52033783337782,48.768120652886154,327.16001264039244,76.42219724205448,250.73781539833797,25.924064681128566,12.777924967850906,14.619835743652665,38.115839745124219,288.85365514346216,94.590093499186935,117.93662327812386,38.211098621027162]
[6,9.3101907249838654,12.022735647479198,80.460003019021684,428.59196649566854,100.31689653972794,328.27506995594058,32.069427825048407,16.162434181481572,16.778175734105318,43.148434840022752,371.42350479596331,130.01947700336336,148.09714468271326,50.158448269863982,319.82192427383745,74.858012740748606,244.96391153308883,23.930700804378194,12.060657233347657,13.146139713277661,32.198026418397255,277.1619379514861,97.022535602551656,110.51236956016288,37.429006370374317]
[7,9.6132351211087723,12.146046071524321,83.17254794151701,438.17267302594757,102.6692990178998,335.50337400804779,31.160294636673683,16.019991874399004,15.906993643566835,38.347524628896082,373.85089863694384,138.62143424057882,145.5472902585191,51.334649508949852,311.40113809275118,72.965153989568194,238.43598410318299,22.145039639637741,11.385109133971619,11.870043571030539,27.252869810461455,265.68885391364444,98.515665270639701,103.43774183775921,36.482576994784061]
[8,9.8842889282766837,12.244579044489436,85.705358891932562,446.5085842701215,104.66064792938931,341.84793634073219,30.347133215169947,15.882879692535983,15.140302762274679,34.139834627868431,375.98777096860061,146.54875142647961,142.96886094955792,52.330323964694685,302.21458531772129,70.838446174036889,231.37613914368438,20.540134284755204,10.750158158274443,10.759930505666119,23.107183889291345,254.48332303297573,99.189963421599089,96.766952635066843,35.419223087018459]
[9,10.126864603027487,12.321964083004019,88.065649008145314,453.78179614957264,106.34788442178015,347.43391172779252,29.619406190917537,15.752341211808069,14.464253522633964,30.439587124443975,377.87349885223648,153.83008003207664,140.42988948482576,53.17394221089009,292.51179181534138,68.552794519179258,223.95899729616212,19.092933323742066,10.154099596436541,9.7899761264807612,19.621629266405044,243.58062656256718,99.160241171173922,90.522358865398559,34.276397259589636]
[10,10.344083227434085,12.381433724985474,90.260748488121848,460.14490692192038,107.77922738679183,352.36567953512855,28.967750317697742,15.629112558899113,13.867064979109468,27.175480274546125,379.5411598096747,160.50008672412474,137.97597911760789,53.889613693395887,282.48905690864592,66.167096149134665,216.32196075951123,17.78368584529418,9.5949193409884934,8.9388337273055249,16.683387511879332,233.00534827139057,98.53313043438142,84.70528225056249,33.083548074567311]
[11,10.538702706348785,12.425850900956888,92.298098985673235,465.72578028172234,108.99521129476267,356.73056898695967,28.383891880953648,15.513561915324907,13.33863775879863,24.288219958646856,381.0187889456065,166.59638209920485,135.63658124037349,54.497605647381363,272.3002181243437,63.727242653647856,208.57297547069587,16.595473726462277,9.0704583518505952,8.1887665043056863,14.20081917859666,222.77379464929251,97.405454250135563,79.303899893736371,31.863621326823946]
[12,10.713148998422394,12.457735812056967,94.185247180281337,470.6315977117456,110.02967014190629,360.60192756983929,27.860553004732822,15.405788273565857,12.870329965628741,21.728418316914833,382.33034588675412,172.15734219359814,133.42975030528791,55.014835070953225,262.06528378258815,61.268637444747583,200.79664633784054,15.513798404154466,8.5785193672425297,7.5250153746116837,12.099196356672843,212.89584269451339,95.863649947393782,74.298677668072926,30.634318722373834]
[13,10.869559099973143,12.479292185853648,95.929833993915906,474.95257345667517,110.91081008802962,364.04176336864555,27.391322700080572,15.30570040623409,12.454764731166964,19.454626069859721,383.49638943850528,177.22097254171348,131.36538578291731,55.455405044014753,251.87749024800243,58.818370607047626,193.0591196409548,14.526203250267844,8.116939712006296,6.9352790369119353,10.317203573667165,203.37632321462198,93.98406552099415,69.665868816436884,29.409185303523781]
[14,11.009827127901875,12.492432837306474,97.539567079796413,478.76518759468649,111.66225312307772,367.10293447160876,26.97051861629437,15.213079891158612,12.085622293846482,17.431645781861,384.53458025346976,181.82444007942621,129.44736783064371,55.831126561538881,241.80895326396373,56.397025611740311,185.41192765222343,13.621944628759323,7.6836391193847664,6.4092635382615484,8.8041656523875016,194.21609330461092,91.833697755472116,65.379717090881158,28.198512805870166]
[15,11.135644301420093,12.498804817432276,99.022172789201022,482.1347970735809,112.3039265913466,369.83087048223433,26.59306709573972,15.12762848087176,11.757438725135758,15.629233218549416,385.46010370078375,186.00386101162468,127.67504617493628,56.151963295673312,231.91508097701259,54.020108873190864,177.89497210382174,12.791719963731181,7.2766479528672434,5.9383055093745565,7.5179284081736322,185.41290051199539,89.471037457527828,61.413880209698455,27.010054436595439]
[16,11.24852981489842,12.499814397804869,100.38533330521321,485.11765439891713,112.85276428383355,372.26489011508357,26.254410555304737,15.049001888366238,11.46543861486796,14.021155110106443,386.28604522519004,189.79413449498799,126.04437347817887,56.426382141916719,222.23798700158594,51.699151607003699,170.53883539458224,{"$f":"(1/(1+$L$5))^$A32*H32","v":12.027447978477731},6.8941211595309104,5.5150720108639373,{"$f":"(1/(1+$L$5))^$A32*K32","v":6.4232527075683592},176.9620881021506,86.946879818539429,57.742379772540978,25.849575803501825]
[17,11.349832510748895,12.496651852360358,101.63661788811966,487.7619036118549,113.32292617653587,374.43897743531903,25.950502467753317,14.97681918246983,11.205408666938499,12.584832240281528,387.02380967560055,193.22804703307889,124.54946731397226,56.66146308826788,212.80890288861849,49.442417321192302,163.36648556742617,11.322118268518146,6.5343366002583325,5.1333268189468209,5.4907206205731534,168.85720618799934,84.304756874047243,54.34052003278282,24.721208660596126]
[18,11.440753042992219,12.490315596485184,102.78343722973112,490.10893729342956,113.72627609684491,376.38266119658465,25.677740871023346,14.910680573579741,10.973683285283487,11.300703299397634,387.68336449598229,196.33624528610358,123.18327786205862,56.863138048422485,203.65038658057202,47.255616719401182,156.39476986117086,10.669631702245155,6.195695756453711,4.7877816682598144,4.6956756354288309,161.09044549659967,81.581765215504532,51.185196285965723,23.627808359700602]
[19,11.522356566678543,12.481635140827256,103.8329997832241,492.1943427261923,114.07268653585302,378.12165619033931,25.432930299964369,14.850176594830359,10.767060297443605,10.15180888482797,388.27346507516728,199.14705127452021,121.93826164789255,57.036343267926554,194.77801486824552,45.142435630353106,149.63557923789241,10.064674146133568,5.8767191462682664,4.4739359457914434,4.0174155008697623,153.6529947387622,78.809250629063669,48.255110793652186,22.571217815176571]
[20,11.5955895585506,12.471292585181819,104.79227835737281,494.0488276974844,114.37037483114328,379.6784528663411,25.2132313243482,14.794897782511597,10.58275370513401,9.1233662150398676,388.80181908138098,201.68654581555148,120.806719635218,57.185187415571633,186.20180718491699,43.104991426100817,143.09681575881618,9.502601715390929,5.576041374409697,4.1879549998653012,3.438500774847379,146.53531653366355,76.013537954864915,45.530782090900864,21.552495713050405]
[21,11.661297401718763,12.459842483788231,105.66798138400402,495.69905846612653,114.6262286041646,381.07282986196196,25.016107794843712,14.74444369122296,10.418333541836603,8.2023868546158454,389.2752167165778,203.97878563699908,119.78092992288056,57.313114302082312,177.92739219612534,41.144209545053258,136.78318265107211,8.9793408859941728,5.2924054838429475,3.9265603409812324,2.9441841332956784,139.72736678436777,73.216627653134452,42.994450225411001,20.572104772526632]
[22,11.720241292661031,12.447730044329463,106.4665264660735,497.16839362236681,114.8461048593102,382.32228876305658,24.839276122016905,14.698430944151008,10.271664103620752,7.3773507993084957,389.69963956236506,206.04608393729512,118.85315239610638,57.423052429655115,169.95695126814888,39.260126140955826,130.69682512719305,8.4913033401964793,5.0246567234336332,3.6869354021512253,2.5219464197043946,133.21877154689744,70.436827231867568,40.629934824847567,19.63006307047792]
[23,11.773112640371789,12.43530768130862,107.19401521774193,498.47748655798438,115.03508014664911,383.44240641133524,24.680662078884637,14.656499558856217,10.140845177865897,6.6379507103076705,390.08035712164292,207.90927186432299,118.01559447368773,57.517540073324568,162.28996620898107,37.452121255782082,124.83784495319898,8.0353153809516034,4.7717356997867855,3.466646616762846,2.1611262805695484,126.99897123376853,67.689293128125883,38.422491197182062,18.726060627891044]
[24,11.82054271255269,12.42284995046429,107.85621025867876,499.64471772423769,115.19762152166771,384.44709620256998,24.538371862341933,14.618316306154227,10.024162520028421,5.9749212619770322,390.42201746454703,209.58784502892377,117.2604404128124,57.5988107608338,154.92379350851891,35.719085774755136,119.20470773376378,7.6085616850949416,4.5326707889000284,3.2635796811648188,1.8526313498045925,121.05733908356838,64.986465128762291,36.358699717623942,17.85954288737755]
[25,11.863107898507069,12.410566852199844,108.45851749659035,500.68648039299285,115.33768428546448,385.34879610752836,24.410676304478791,14.583575223990762,9.9200555561877053,5.3799344753571168,390.72873058288548,211.09999351743113,116.5799604473649,57.668842142732316,147.85410541164791,34.059537850699058,113.79456756094885,7.2085403717294669,4.3065701849072813,3.0758908961949132,1.5887095621253011,115.38327712307415,62.338413191076988,34.42638544452231,17.029768925349554]
[26,11.901332916356546,12.39861548522118,109.00597645028313,501.61738720246501,115.45877047896444,386.15861672350059,24.29600125093036,14.551996565059214,9.8271010804880294,4.8455236812190323,391.00414040471964,212.46258777892768,115.96664370509069,57.729385239482198,141.07524264064511,32.471709465956124,108.60353317468899,6.8330252481638336,4.0926142089507582,2.9019701868221861,1.3627586413248787,109.96629181601386,59.753134336377506,32.614544105333422,16.235854732978055]
[27,11.935688798170549,12.387110085018733,109.50325901914776,502.45032726007202,115.56390307893636,386.88642418113568,24.192933605488349,14.523322243872025,9.7440046858711451,4.3650684041826633,391.25149258531832,213.69100063016089,115.41347201150663,57.781951539468139,134.58047553772951,30.95359717679948,103.62687836093004,6.4800365979144106,3.8900474493198796,2.7404110392130749,1.1691762343813759,104.79605459531142,57.23677530426729,30.913304468263014,15.476798588399728]
[28,11.966576282874939,12.376130425006769,109.95468030599595,503.19615507169885,115.65537871438053,387.54077635731835,24.100271151375182,14.497301815544173,9.6696113616163242,3.9329358682545368,391.47371222557291,214.79842190079751,114.91466509933066,57.827689357190167,128.36213739365465,29.502951211412075,98.859186182242581,6.1478258241388204,3.6981694488881889,2.5899891485945306,1.0032669152835403,99.862453097526128,54.79371069526897,29.313999881267602,14.751475605706013]
[29,11.994354319339148,12.365728305380301,110.36423444812777,503.86445585357433,115.73515546044928,388.12930039312505,24.016937041982558,14.473703925084552,9.6029693358310091,3.5441085223423485,391.67340891546741,215.79680330677445,114.46491935612602,57.86757773022461,122.41201587696078,28.117430239739228,94.294585637221559,5.8348264981674056,3.516333121125657,2.4496563752506315,0.86102812704200793,95.155613764263563,52.427039466072046,27.808831051279913,14.058715119869607]
[30,12.019326964805121,12.355933389435252,110.73560843416892,504.46328685797005,115.80465228492096,388.65863457304908,23.942019105584635,14.452304936543335,9.5432331168980067,3.1942987572028927,391.85293333025197,216.69633103033726,114.05997740025131,57.90232614246051,116.72142825374527,26.794584988163773,89.926843265581496,5.5396432963199773,3.3439374434138571,2.3184933770417491,0.73908869668618293,90.665931962267678,50.138644206884642,26.390906564614959,13.397292494081894]
[31,12.041751662863694,12.346757572650738,111.07221485879906,504.99942510670081,115.86484377869532,389.13458132800548,23.874745011408919,14.432889045870887,9.4897141690412994,2.8798218688471509,392.01440319685264,217.50567466512075,113.69648477353709,57.932421889347623,111.28140814653659,25.531916135641975,85.749492010894613,5.261026274332349,3.1804238515873191,2.1957058529061202,0.63459603485447469,86.384088045749095,47.92943625922544,25.054097683848198,12.765958067820979]
[32,12.061846672043258,12.338198559478567,111.3772207685861,505.47858261277395,115.91634466240308,389.5622379503709,23.814459983870229,14.415248487332207,9.4418559655380321,2.5974898374719402,392.15972778784283,218.2322177098215,113.37184790934788,57.958172331201496,{"$f":"(1/(1+$L$5))^$A48*E48","v":106.0828524218802},{"$f":"(1/(1+$L$5))^$A48*F48","v":24.326918898412604},{"$f":"(1/(1+$L$5))^$A48*G48","v":81.755933523467604},4.9978494260180648,3.0252729403529619,2.0806024227450299,0.54512523492406029,82.301058758391662,45.799558955290905,23.792915118970402,12.163459449206291]
[33,12.079800415179319,12.330242805438539,111.65357265602141,505.90565780490954,115.95952426511857,389.94613353979094,23.760598754462045,14.399185451699022,9.3992114965380225,2.3444947237484315,392.29062826353936,218.88236710584971,113.08400430138195,57.979762132559273,101.1166486240911,23.177124605818101,77.939524018272991,4.7490912154998224,2.8780017644199685,1.9725764856651025,0.46860011451725075,78.408124132790249,43.748574587371884,22.602387127992063,11.588562302909047]
[34,12.095780585296607,12.322868032222406,111.90401504628063,506.28497316633894,115.99462181874819,390.29035134759079,23.71265824411018,14.384514624845576,9.3614133027630224,2.1183043190559783,392.40865566664678,219.46186195145748,112.83117848675923,57.997310909374022,96.373774617799754,22.080132993329372,74.293641624470396,4.5138183085200163,2.7381613990464007,1.8710894510798541,0.40322939418851739,74.696871018658911,41.775618756046974,21.477956371758737,11.040066496664672]
[35,12.109943729983975,12.31604544037415,112.13110249320643,506.62051808397121,116.02187328158021,390.59864480239099,23.670168810048075,14.371066769820622,9.3281436192646048,1.9165608355836481,392.51520563797465,219.97610571506726,112.61160244653364,58.010936640790078,91.845378288913551,21.033638514358209,70.811739774555335,4.2911716579172836,2.6053347955217179,1.7756569094736159,0.34745386077853302,71.159193635333878,39.879530975833191,20.415389541543043,10.516819257179099]
[36,12.122444305298183,12.309741740548446,112.3372042035966,506.91617441530644,116.04163588448564,390.87453853082081,23.632667084105449,14.358692805101482,9.2991020402274529,1.7369915970343541,392.61153012785519,220.43048390258451,112.42323668599347,58.0208179422428,87.522836104369148,20.035448840264994,67.487387264104157,{"$f":"(1/(1+$L$5))^$A52*H52","v":4.0803551993523151},2.4791347770731829,1.6858368623955662,{"$f":"(1/(1+$L$5))^$A52*K52","v":0.29990447836322526},67.787291742467389,38.058957454386835,19.41070538958482,10.017724420132494]
[37,12.133441303635003,12.303921073373152,112.52450163884686,507.17588141496634,116.05448305291313,391.12139836205324,23.599676089094991,14.347267211587969,9.2739742790039674,1.5773485349606033,392.69874689701385,220.8305968031338,112.26356003246288,58.027241526456521,83.397787089037649,19.083492380143703,64.314294708893939,3.8806276756647797,2.359201965368213,1.6012204222791322,0.25937230476505857,64.573667013659005,36.312418965097514,18.460129553724585,9.5417461900718443]
[38,12.143102825430237,12.298546808794601,112.69498140858499,507.40375018235648,116.06127343208382,391.34247675027268,23.570691523709286,14.336690766015776,9.2524088775070226,1.4353698601654359,392.77784661043813,221.1824193434577,112.129420690773,58.030636716041926,79.462149365750662,18.17581805756263,61.286331308188032,3.6912967431515598,2.2452026865199488,1.5214257102965667,0.22478662048235001,61.51111792867038,34.638353454485518,17.560068824921188,9.0879090287813185]
[39,12.151606513033069,12.293583209057429,112.85042539194936,507.60407951060262,116.0631628306834,391.54091667991923,23.545180460900795,14.32689118589396,9.2340007576935097,1.3087822542622596,392.8496989341815,221.49231127138154,112.01702399319595,58.031581415341734,75.70811620311234,17.31058471192328,58.397531491189056,3.5117157846244105,2.1368266854292486,1.4460940566316109,0.19520221170363705,58.592733702892694,33.035127802749315,16.707111332478096,8.6552923559616453]
[40,12.159138980907995,12.28899685998052,112.99240208797372,507.7813477189253,116.06160111531676,391.71974660360854,23.522583057276016,14.317823157242557,9.2182892750068355,1.195310597990167,392.9150572015987,221.76699113555452,111.92195491039561,58.030800557658409,72.128147996089282,16.486049319287837,55.642098676801453,3.3412813598357234,2.0337849594252351,1.3748890991951617,0.16978870945226618,55.811887386253716,31.501043567529472,15.898030449628058,8.2430246596439218]
[41,12.165893375605719,12.28475786669657,113.12225996704623,507.94016009643246,116.05830108698947,391.88185900944302,23.502319873182842,14.309467151796129,9.2047599000334586,1.0927037604007677,392.97456276984377,222.0134424399107,111.83926602603762,58.029150543494694,68.714958674866693,15.700552918583313,53.014405756283381,3.1794314876434595,1.9358076427907545,1.3074964004104883,0.14782271542686304,53.162228471710243,30.034334201152895,15.129795095838837,7.850276459291651]
[42,12.172071062098331,12.280840778855156,113.24112445813708,508.0852928147425,116.0552639339696,392.03002888077287,23.483786813705009,14.301830396227125,9.1928527213867124,0.99871879880258219,393.02874767957547,222.23897091115737,111.76342600263062,58.027631966984899,65.461516630028527,14.952516235863508,50.509000394165021,3.025642195870287,1.8426424097731811,1.2436238448527048,0.1286745516571669,50.637674945822191,28.633184813412161,14.399557462821097,7.4762581179317662]
[43,12.177883332712904,12.27722540689892,113.3498941748939,508.22173626502416,116.05480577557981,392.16693048944433,23.466350001861287,14.294947973080053,9.1819564174778847,0.91110610073295928,393.07803659017731,222.45126369775016,111.6882639039043,58.027402887789862,62.361043764256237,14.240435435152524,48.12060832910371,2.8794244225129111,1.7540530295070746,1.1829997860971058,0.1117967284108055,48.232405057514519,27.295749081529777,13.704641529997676,7.1202177175762564]
[44,12.183545354664863,12.273897555395543,113.44923624907992,508.35455516612819,116.05947424390175,392.29508092222648,23.449363936005412,14.288879492634464,9.1714020287812339,0.82766992921771776,393.12275085144421,222.65816611376368,111.60717768651185,58.029737121950916,59.406991645684101,13.562865025487548,45.844126620196562,2.7403239595003424,1.6698175240462216,1.1253713930058362,9.6722612339634806E-2,45.940849232536195,26.020130398636883,13.042563708815893,6.7814325127437787]
[45,12.189260163804834,12.270849430762194,113.53958844981059,508.48851481691082,116.0718182974778,392.416696519433,23.432219508585497,14.283699347333446,9.1604844433709474,0.74642105370118694,393.16311757313417,222.86709501137915,111.513692359315,58.035909148738867,56.592996523071633,12.918388160057029,43.674608363014606,2.607924227462076,1.5897258717658627,1.0705064354541207,8.3074057458443679E-2,43.757682420473046,24.804329627046663,12.411084655939435,6.459194080028511]
[46,12.195205037982527,12.268079397010279,113.62117771676796,508.62776340129994,116.09418032135974,392.53358307994017,23.414384886052417,14.279486891747091,9.1485201612520513,0.66569983611889871,393.19928291605908,223.0845388776516,111.4019540416088,58.047090160679829,53.912851813700627,12.305597119283226,41.607254694417392,2.4818469487964827,1.5135781334906067,1.0181983556962131,7.0561969281976583E-2,41.677816663699375,23.646219400236198,11.808236734539593,6.1527985596416084]
[47,12.197886187424716,12.265591172181745,113.69405207579571,508.69053008343292,116.07663540878548,392.61389467464744,23.40634143772585,14.274190662041116,9.1348979943053266,0.61829212906662356,393.23218680371406,223.18264116205,111.39293580820473,58.038317704392711,51.351909403159461,11.717845158937536,39.634064244221925,2.362851780968628,1.4409683340484754,0.96826881530587605,6.2416104721486114E-2,39.69648034894341,22.530112301150339,11.24502936360282,5.8589225794687652]
[48,12.191304907269403,12.26326755325791,113.76175706055274,508.53642142314766,115.93093169940317,392.60548972374448,23.426085278191792,14.263969187204424,9.1321507756847335,0.65933011676132136,393.26481984050582,222.94187301301656,111.69815086102626,57.965465849701673,48.8917640523484,11.145844270414212,37.745919781934184,2.252233243955831,1.3713680801841237,0.92188344692015289,6.3389387944111031E-2,37.809309169878297,21.434101852994388,10.738895793732684,5.5729221352071141]
[49,12.260784647444332,12.260785248851066,113.83371970654125,510.15681859015001,116.86795799643902,393.28886059371098,23.217646057667004,14.297774737540864,9.162116090987368,5.36447068003965E-6,393.28886595818165,225.49026025651,109.36462133898158,58.433978998219416,46.711954717505371,10.700887575988155,36.011067141517216,2.1258985311418677,1.3091602067513683,0.88086516377170754,4.9119192836019388E-7,36.011067632709143,20.646770644856705,10.013852708666443,5.3504437879940685]
[50,null,null,113.83372030794797,null,null,null,null,null,8.9198713201261395,null,null,null,null,null,{"$f":"P65/$L$5","v":934.23909435010739},{"$f":"Q65/$L$5","v":214.0177515197631},720.22134283034427,null,null,0.81673832439049932,{"$f":"V65/$L$5","v":9.8238385672038763E-6},720.22135265418285,412.93541289713409,200.27705417332885,107.00887575988136]

{"sheet":"Phase","index":8,"n_rows":29,"n_cols":25,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,"Consumer Demand",null,null,null,"Effort",null,null,"Growth",null,null,"Other Prices",null,null,"Biomass"]
[null,"Intercept alpha:",{"$f":"CALCULATIONS!C5","v":60},null,"Catchability c:",{"$f":"CALCULATIONS!F5","v":0.1},null,"Growth rate g:",{"$f":"CALCULATIONS!I5","v":0.25},null,"Discount rate r:",{"$f":"CALCULATIONS!L5","v":0.05},null,"Initial Biomass B0:",{"$f":"CALCULATIONS!O5","v":60}]
[null,"Slope beta:",{"$f":"CALCULATIONS!C6","v":3},null,"Effort elasticity a:",{"$f":"CALCULATIONS!F6","v":1.5},null,"Carrying capacity K:",{"$f":"CALCULATIONS!I6","v":200},null,"Price of effort Pe:",{"$f":"CALCULATIONS!L6","v":3},null,"Stdy-state biomass:",{"$f":"CALCULATIONS!D66","v":113.83372030794797}]
[null,null,null,null,"Biomass elasticity b:",{"$f":"CALCULATIONS!F7","v":0.5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Optimal Steady State",null,null,null,"Biological Steady States",null,null,"Economic Steady States",null,null,"Profit Max Steady States"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Biomass","Harvest","MUC",null,"Biomass","Harvest",null,"Biomass","Harvest",null,"Biomass","Harvest"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,114.110375,12.251121646699218,8.9804914861406928,null,0,{"$f":"$I$2*(1-R7/$I$3)*R7","v":0},null,80,0,null,{"$f":"IF($F$4<=0.01,(1/$F$2)^(1/0.01)*($F$3*$L$3*Y7^($F$3-1)/($C$2-$C$3*Y7))^(1/($F$3*0.01)),(1/$F$2)^(1/$F$4)*($F$3*$L$3*Y7^($F$3-1)/($C$2-$C$3*Y7))^(1/($F$3*$F$4)))","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7+$I$3/20","v":10},{"$f":"$I$2*(1-R8/$I$3)*R8","v":2.375},null,82.518089843750005,3.8741448295362186,null,{"$f":"IF($C$2<=$C$3*Y8,X7,IF($F$4<=0.01,(1/$F$2)^(1/0.01)*($F$3*$L$3*Y8^($F$3-1)/($C$2-$C$3*Y8))^(1/($F$3*0.01)),(1/$F$2)^(1/$F$4)*($F$3*$L$3*Y8^($F$3-1)/($C$2-$C$3*Y8))^(1/($F$3*$F$4))))","v":10.396214708184841},{"$f":"V8","v":3.8741448295362186}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Open-Access Steady State",null,null,null,{"$f":"R8+$I$3/20","v":20},4.5,null,84.860356031417865,5.478868160527723,null,{"$f":"IF($C$2<=$C$3*Y9,X8,IF($F$4<=0.01,(1/$F$2)^(1/0.01)*($F$3*$L$3*Y9^($F$3-1)/($C$2-$C$3*Y9))^(1/($F$3*0.01)),(1/$F$2)^(1/$F$4)*($F$3*$L$3*Y9^($F$3-1)/($C$2-$C$3*Y9))^(1/($F$3*$F$4))))","v":15.06312063225988},5.478868160527723]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Biomass","Harvest",null,null,30,6.375,null,87.349864565088467,6.7102156806369972,null,19.40537715917938,6.7102156806369972]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2.1559358520507814,0.53317388876499794,null,null,40,8,null,90.049360720293322,7.7482896590724373,null,23.804731278962667,7.7482896590724373]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,9.375,null,93.00823011205938,8.6628511935223198,null,28.437437025691008,8.6628511935223198]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,10.5,null,96.28061299962431,9.4896780220054513,null,33.429866031427046,9.4896780220054513]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,11.375,null,99.93103169563382,10.250023761999556,null,38.898559360773838,10.250023761999556]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,12,null,104.04375337267231,10.957736321055446,null,44.967563115394768,10.957736321055446]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,12.375000000000002,null,108.72571081653057,11.622434488608654,null,51.780070788112113,11.622434488608654]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,12.5,null,114.11178159463005,12.251121646699218,null,59.509612549062375,12.251121646699218]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,12.374999999999998,null,120.38781641145457,12.849084783067017,null,68.373472429183352,12.849084783067017]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,12,null,127.8106553261379,13.420431361273994,null,78.650731532640734,13.420431361273994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,11.375,null,136.71912508807847,13.968427831466531,null,90.708083852581851,13.968427831466531]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,140,10.500000000000002,null,147.597676032706,14.495722618866264,null,105.03833849229058,14.495722618866264]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,9.375,null,161.13041391034733,15.004498405589347,null,122.31992252219048,15.004498405589347]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,160,7.9999999999999982,null,178.3072437304287,15.496579318144875,null,143.51222038289035,15.496579318144875]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,170,6.3750000000000009,null,200.57997863810391,15.973508341118356,null,170.01457297444196,15.973508341118356]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,180,4.4999999999999991,null,230.20685620191924,16.436604481583167,null,203.94405149155443,16.436604481583167]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,190,2.3750000000000022,null,null,16.887005804588984,null,248.64841737767938,16.887005804588984]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,0,null,null,17.32570238704464,null,309.72000897143477,17.32570238704464]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,210,-2.6250000000000022,null,null,17.753561934571511,null,397.1788180289812,17.753561934571511]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,220,-5.5000000000000053,null,null,18.171349964295135,null,530.72841726212664,18.171349964295135]

{"sheet":"Supply","index":9,"n_rows":55,"n_cols":15,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[null,"Consumer Demand",null,null,null,"Effort",null,null,"Growth",null,null,"Other Prices",null,null,"Biomass"]
[null,"Intercept alpha:",{"$f":"CALCULATIONS!C5","v":60},null,"Catchability c:",{"$f":"CALCULATIONS!F5","v":0.1},null,"Growth rate g:",{"$f":"CALCULATIONS!I5","v":0.25},null,"Discount rate r:",{"$f":"CALCULATIONS!L5","v":0.05},null,"Initial biomass B0",{"$f":"CALCULATIONS!O5","v":60}]
[null,"Slope beta:",{"$f":"CALCULATIONS!C6","v":3},null,"Effort elasticity a:",{"$f":"CALCULATIONS!F6","v":1.5},null,"Carrying capacity K:",{"$f":"CALCULATIONS!I6","v":200},null,"Price of effort pe:",{"$f":"CALCULATIONS!L6","v":3},null,"Stdy-state biomass:",{"$f":"CALCULATIONS!D66","v":113.83372030794797}]
[null,null,null,null,"Biomass elasticity b:",{"$f":"CALCULATIONS!F7","v":0.5}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Initial",null,null,null,"Steady-state"]
[null,"Harvest","Demand","Biomass","Growth","Long Sply",null,"Shrt Sply","Dashed lines",null,null,"Shrt Sply","Dashed lines"]
[null,0,{"$f":"$C$2-$C$3*B33","v":60},0.1,{"$f":"$I$2*(1-D33/$I$3)*D33","v":2.4987500000000003E-2},{"$f":"$L$3*$F$3*ABS(E33)^($F$3-1)/($F$2*D33^$F$4)^$F$3","v":126.49516251333532},null,{"$f":"$L$3*$F$3*B33^($F$3-1)/($F$2*$O$2^$F$4)^$F$3","v":0},{"$f":"CALCULATIONS!B16","v":6.552092710274521},0,null,{"$f":"$L$3*$F$3*B33^($F$3-1)/($F$2*$O$3^$F$4)^$F$3","v":0},{"$f":"CALCULATIONS!B65","v":12.260784647444332},0]
[null,{"$f":"B33+1","v":1},{"$f":"$C$2-$C$3*B34","v":57},3,{"$f":"$I$2*(1-D34/$I$3)*D34","v":0.73875000000000002},{"$f":"$L$3*$F$3*ABS(E34)^($F$3-1)/($F$2*D34^$F$4)^$F$3","v":53.656250350782919},null,6.6008380259504502,{"$f":"I33","v":6.552092710274521},{"$f":"C2-C3*I34","v":40.343721869176434},null,4.0832814572765868,{"$f":"M33","v":12.260784647444332},{"$f":"C2-C3*M34","v":23.217646057667004}]
[null,{"$f":"B34+1","v":2},54,{"$f":"$I$3/40","v":5},1.21875,46.983170992793511,null,9.334994659327176,null,null,null,5.7746320158671249]
[null,3,51,{"$f":"$I$3/20","v":10},2.375,38.998178318829581,null,11.432986833478829,{"$f":"CALCULATIONS!C16","v":10.5},0,null,7.0724509456069331,0,{"$f":"CALCULATIONS!I65","v":14.297774737540864}]
[null,4,48,{"$f":"D36+$I$3/20","v":20},4.5,31.918779303857175,null,13.2016760519009,{"$f":"I36","v":10.5},{"$f":"J43","v":40.343721869176434},null,8.1665629145531735,{"$f":"M34","v":12.260784647444332},{"$f":"N36","v":14.297774737540864}]
[null,5,45,30,6.375,28.029262270375082,null,14.759922534490727,null,null,null,9.1304949097348516]
[null,6,42,40,8,25.305359633565701,null,16.168685038338786,0,{"$f":"CALCULATIONS!I16","v":16.896201997316663},null,10.001956046495746,0,{"$f":"N34","v":23.217646057667004}]
[null,7,39,50,9.375,23.172380368955071,null,17.464175861283408,{"$f":"MAX(I34,I37)","v":10.5},{"$f":"J39","v":16.896201997316663},null,10.803347269035262,{"$f":"M37","v":12.260784647444332},{"$f":"N39","v":23.217646057667004}]
[null,8,36,60,10.5,21.38915981918764,null,18.669989318654352,null,null,null,11.54926403173425]
[null,9,33,70,11.375,19.83191655536849,null,19.802514077851349,0,{"$f":"J34","v":40.343721869176434},null,12.249844371829759]
[null,10,30,80,12,18.428315823286198,null,20.873682627853054,{"$f":"I40","v":10.5},{"$f":"J42","v":40.343721869176434},null,12.912469732525535]
[null,11,27,90,12.375000000000002,17.131809458851031,null,21.892503033987861,null,null,null,13.542712507202049]
[null,12,24,100,12.5,15.90990257669732,null,22.865973666957657,null,null,null,14.144901891213866]
[null,13,21,110,12.374999999999998,14.738069619611361,null,23.799659963596845,null,null,null,14.722480666362054]
[null,14,18,120,12,13.596189288105453,null,24.69807435869582,null,null,null,15.278240226896004]
[null,15,15,130,11.375,12.466102750898704,null,25.564935745518735,null,null,null,15.814481081909774]
[null,16,12,140,10.500000000000002,11.329510247000684,null,26.403352103801801,null,null,null,16.333125829106347]
[null,17,9,150,9.375,10.165522540610752,null,27.215952398587273,null,null,null,16.835800747477375]
[null,18,6,160,7.9999999999999982,8.946795698629316,null,28.004983977981521,null,null,null,17.323896047601373]
[null,19,3,170,6.3750000000000009,7.6316055873320119,null,28.772385897798522,null,null,null,17.798611230302136]
[null,20,0,180,4.4999999999999991,6.1427719410953978,null,29.519845068981454,null,null,null,18.260989819469703]
[null,null,null,190,2.3750000000000022,4.2852791718754668]
[null,null,null,200,0,0]