{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["a and b","Sheet3","Sheet4"],"not_rendered":{"charts":2,"images":3,"macros":1,"defined_names":9,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"a and b","index":0,"n_rows":46,"n_cols":9,"rows_kept":46,"merged":[[39,2,39,3]]}
[null,"   Comparing the Continuous and Discrete"]
[null,null,"        Logistic Growth Models"]
[]
[null,"              This DIGMath module you investigate the"]
[null,null,"       differences in the solutions"]
[null,null,"of the continuous logistic growth model "]
[]
[]
[null,null,"  and the discrete logistic growth model"]
[]
[null,null,"        based on values for a and b."]
[]
[]
[]
[null,"Enter a value for the initial growth rate a",null,null,{"$f":"F15/100+0.01","v":0.19},18]
[null,null,"   a is between 0.01 (1%) and 0.50 (50%)"]
[]
[null,"Enter a value for the inhibiting constant b",null,null,{"$f":"F18/50000+0.0001","v":{"v":2.1799999999999996E-3,"d":"0.0022"}},104]
[null,null,"   b is between 0.0001 and 0.005"]
[]
[null,"What is the initial population P0?",null,null,{"$f":"F21+1","v":45},44]
[]
[]
[null,"Based on either model, "]
[null,null,"the maximum sustainable population is"]
[{"$nulls":3},"L = a/b =",{"$f":"a/b","v":{"v":87.15596330275231,"d":"87"}}]
[]
[]
[]
[]
[null,"Click each item below for suggestions and investigations"]
[{"$nulls":3},"   Item 1"]
[{"$nulls":3},"   Item 2"]
[{"$nulls":3},"   Item 3"]
[{"$nulls":3},"   Item 4"]
[]
[]
[]
["To access/download all the DIGMath Apps for Calculus"]
["Click this link:",null,"DIGMath for Calculus",{"$nulls":5}," "]
[]
["Created by:  Sheldon P. Gordon   "]
["                      Farmingdale State College    "]
["Development of this module was supported by the "]
["NSF's Division of Undergraduate Education  "]
["under grants DUE-0310123 and DUE-0442160."]

{"sheet":"Sheet3","index":1,"n_rows":201,"n_cols":7,"rows_kept":201}
[null,"Continuous",null,"Discrete","Difference"]
[0,{"$f":"P0","v":45},null,{"$f":"P0","v":45},{"$f":"B2-D2","v":0},0,{"$f":"a/b","v":87.15596330275231}]
[1,{"$f":"P0*L/(P0+(L-P0)*EXP(-a*A3))","v":49.11039974173586},null,{"$f":"(1+a)*D2-b*D2^2","v":49.1355},{"$f":"B3-D3","v":-0.025100258264139086},200,{"$f":"a/b","v":87.15596330275231}]
[2,53.123122835186926,null,53.208076754654996,-0.08495391946807018]
[3,56.972733678999084,null,57.145814576433665,-0.17308089743458055,{"$f":"LOOKUP(G5,B2:B102,A2:A102)","v":{"$error":"#N/A"}},{"$f":"a/b/2","v":43.577981651376156}]
[4,60.60453785998188,null,60.884415156499045,-0.27987729651716364]
[5,63.97713282514245,null,64.3713858567252,-0.3942530315827497]
[6,67.06336379545182,null,67.56873697819141,-0.5053731827395893]
[7,69.84982514754903,null,70.45393241136271,-0.6041072638136882]
[8,72.3352564551926,null,73.01919019847142,-0.6839337432788142]
[9,74.52827112338746,null,75.26950767699661,-0.7412365536091556]
[10,76.44483685003449,null,77.21992678228231,-0.7750899322478233]
[11,78.10583910351045,null,78.89255360978689,-0.7867145062764394]
[12,79.53494394763241,null,80.31374246278705,-0.7787985151546337]
[13,80.75686768883601,null,81.51170557285063,-0.7548378840146199]
[14,81.79607607378148,null,82.51466487473095,-0.7185888009494761]
[15,82.67588031843081,null,83.34955077666146,-0.6736704582306459]
[16,83.41786803774366,null,84.04118362424377,-0.6233155865001123]
[17,84.04159746845978,null,84.61184172482888,-0.5702442563690937]
[18,84.56448611624789,null,85.08111465559924,-0.5166285393513448]
[19,85.00183423224684,null,85.46595100529757,-0.4641167730507334]
[20,85.3669352001255,null,85.78082695320107,-0.4138917530755748]
[21,85.67123647397342,null,86.03798047965971,-0.36674400568628585]
[22,85.92452485507044,null,86.24767246545514,-0.3231476103846944]
[23,86.13511814795231,null,86.41844924144725,-0.2833310934949367]
[24,86.31005158160517,null,86.55739115225565,-0.24733957065048173]
[25,86.45525204307299,null,86.67033879165983,-0.21508674858684174]
[26,86.57569645702327,null,86.76209333682601,-0.1863968798027429]
[27,86.67555286751288,null,86.83659043921288,-0.16103757170000677]
[28,86.75830421220876,null,86.89704892540877,-0.13874471320001192]
[29,86.82685564894476,null,86.9460965171966,-0.11924086825183622]
[30,86.8836267734257,null,86.98587519038463,-0.10224841695892906]
[31,86.93063028444719,null,87.01812886440868,-0.08749857996149046]
[32,86.96953870247862,null,87.04427599132936,-0.07473728885074138]
[33,{"$f":"P0*L/(P0+(L-P0)*EXP(-a*A35))","v":87.00174069428364},null,{"$f":"(1+a)*D34-b*D34^2","v":87.06546938705866},-0.06372869277501536]
[34,87.0283884450981,null,87.0826453786961,-0.05425693359799766]
[35,87.05043738037763,null,87.09656406563757,-0.04612668525993513]
[36,87.06867939027276,null,87.10784222906214,-0.039162838789380316]
[37,87.08377056344762,null,87.11698018497302,-0.03320962152540119]
[38,87.09625429933092,null,87.12438366444111,-0.028129365110189042]
[39,87.10658054280515,null,87.13038162166389,-0.023801078858738833]
[40,87.11512177403333,null,87.13524071442983,-0.020118940396500307]
[41,87.12218628864252,null,87.13917707006314,-0.01699078142061694]
[42,87.12802921911721,null,87.14236583999889,-0.014336620881678641]
[43,87.1328616759076,null,87.14494895485966,-0.012087278952051861]
[44,87.13685832514862,null,87.14704141649068,-0.010183091342057082]
[45,87.14016366771794,null,87.14873640135227,-0.008572733634323981]
[46,87.14289724038028,null,87.150109398761,-7.2121583807245315E-3]
[47,87.14515792282054,null,87.1512215658147,-0.006063642994149632]
[48,87.14702750342072,null,87.15212244681757,-0.005094943396855456]
[49,87.14857363077371,null,87.15285217728542,-0.004278546511713444]
[50,87.1498522563541,null,87.15344327002369,-3.5910136695918027E-3]
[51,87.15090965579961,null,87.1539220623979,-0.003012406598287498]
[52,87.15178410131263,null,87.15430988898191,-0.002525787669284796]
[53,87.1525072452727,null,87.15462403163865,-0.0021167863659457]
[54,87.15310526484109,null,87.15487848924008,-1.7732243989883045E-3]
[55,87.15359980878506,null,87.15508460124194,-1.484792456878381E-3]
[56,87.15400878065644,null,87.1552515528457,-1.2427721892578347E-3]
[57,87.15434698658046,null,87.1553867842236,-1.0397976431306688E-3]
[58,87.15462667104131,null,87.15549632201947,-8.6965097816005255E-4]
[59,87.15485796001687,null,87.1555850478833,-7.2708786643715939E-4]
[60,87.1550492274751,null,87.1556569159965,-6.0768852139858609E-4]
[61,87.15520739848087,null,87.15571512927546,-5.07730794595318E-4]
[62,87.15533819987252,null,87.15576228210179,-4.2408222927292627E-4]
[63,87.15544636757465,null,87.1558004759373,-3.5410836264304635E-4]
[64,87.15553581804674,null,87.15583141297435,-2.9559492760711237E-4]
[65,{"$f":"P0*L/(P0+(L-P0)*EXP(-a*A67))","v":87.15560979007039},null,{"$f":"(1+a)*D66-b*D66^2","v":87.15585647199423},{"$f":"B67-D67","v":-0.000246681923840697}]
[66,87.15567096200584,null,87.15587676981337,-2.0580780753221006E-4]
[67,87.15572154876148,null,87.15589321105544,-1.7166229396536892E-4]
[68,87.15576338198545,null,87.15590652846714,-1.4314648169033717E-4]
[69,87.15579797638249,null,87.1559173155743,-1.1933919181217334E-4]
[70,87.15582658455581,null,87.15592605313351,-9.9468577701600225E-5]
[71,87.15585024236026,null,87.15593313055805,-8.2888197795227825E-5]
[72,87.15586980640742,null,87.15593886327297,-6.90568655414836e-05]
[73,87.15588598508157,null,87.15594350677273,-5.7521691161355193E-5]
[74,87.15589936418846,null,87.15594726800799,-4.7903819535122238E-5]
[75,87.15591042816621,null,87.15595031460884,-3.9886442635861385E-5]
[76,87.1559195776258,null,87.15595278235573,-3.320472993095791E-5]
[77,87.15592714385642,null,87.15595478123083,-2.7637374415689919E-5]
[78,87.15593340082093,null,87.15595640031975,-2.299949882456076E-5]
[79,87.15593857507557,null,87.15595771178184,-1.9136706271183357E-5]
[80,87.15594285397316,null,87.15595877406615,-1.5920092991450474E-5]
[81,87.15594639244692,null,87.15595963451648,-1.3242069556440583E-5]
[82,87.15594931862034,null,87.15596033148125,-1.1012860909431765E-5]
[83,87.15595173844633,null,87.15596089602273,-9.15757640029824e-06]
[84,87.15595373954363,null,87.15596135330134,-7.6137577025292558E-6]
[85,87.1559553943694,null,87.155961723697,-6.3293276042486468E-6]
[86,87.15595676284272,null,87.1559620237175,-5.2608747864724137E-6]
[87,87.15595789451427,null,87.15596226673411,-4.3722198341811236E-6]
[88,87.15595883036042,null,87.15596246357757,-3.6332171475805808E-6]
[89,87.15595960426694,null,87.15596262302076,-3.01875381580885E-6]
[90,87.15596024425604,null,87.15596275216974,-2.507913706040199E-6]
[91,87.15596077350087,null,87.15596285678042,-2.08327955419918E-6]
[92,87.15596121116471,null,87.15596294151507,-1.7303503625498706E-6]
[93,87.15596157309483,null,87.15596301015015,-1.4370553174103406E-6]
[94,87.15596187239626,null,87.15596306574454,-1.1933482824133534E-6]
[95,87.1559621199063,null,87.15596311077601,-9.9086970806183672E-7]
[96,87.155962324587,null,87.1559631472515,-8.2266450363022159E-7]
[97,{"$f":"P0*L/(P0+(L-P0)*EXP(-a*A99))","v":87.15596249384957},null,{"$f":"(1+a)*D98-b*D98^2","v":87.15596317679666},-6.8294708910343616E-7]
[98,87.1559626338228,null,87.15596320072822,-5.6690542749038286E-7]
[99,87.15596274957494,null,87.1559632201128,-4.7053785579009855E-7]
[100,87.15596284529722,null,87.15596323581431,-3.9051708711212996E-7]
[101,87.15596292445565,null,87.15596324853253,-3.2407687911018e-07]
[102,87.15596298991643,null,87.15596325883428,-2.6891784443705546E-7]
[103,87.15596304404983,null,87.15596326717869,-2.2312886471809179E-7]
[104,87.15596308881592,null,87.15596327393766,-1.8512173483031802E-7]
[105,87.15596312583565,null,87.15596327941243,-1.5357677796146163E-7]
[106,87.15596315644947,null,87.155963283847,-1.2739752719426178E-7]
[107,87.15596318176584,null,87.15596328743901,-1.0567316621745704E-7]
[108,87.15596320270144,null,87.15596329034852,-8.76470807043006e-08]
[109,87.15596322001433,null,87.15596329270525,-7.2690923502705118E-8]
[110,87.15596323433138,null,87.15596329461418,-6.028280097325478E-8]
[111,87.155963246171,null,87.15596329616042,-4.9989424155683082E-8]
[112,87.15596325596188,null,87.15596329741288,-4.1451002630310541E-8]
[113,87.15596326405853,null,87.15596329842737,-3.4368838441878324E-8]
[114,87.15596327075413,null,87.1559632992491,-2.8494966386460874E-8]
[115,87.15596327629113,null,87.1559632999147,-2.3623570655217918E-8]
[116,87.15596328087,null,87.15596330045383,-1.9583836774472729E-8]
[117,87.15596328465652,null,87.15596330089053,-1.6234011468441167E-8]
[118,87.15596328778784,null,87.15596330124427,-1.345642886008136E-8]
[119,87.1559632903773,null,87.15596330153079,-1.1153488799209299E-8]
[120,87.15596329251869,null,87.15596330176287,-9.2441752030936186E-9]
[121,87.15596329428952,null,87.15596330195086,-7.661341783204989E-9]
[122,87.15596329575393,null,87.15596330210315,-6.3492109347862424E-9]
[123,87.15596329696494,null,87.1559633022265,-5.2615547474488267E-9]
[124,87.15596329796638,null,87.1559633023264,-4.3600181243164116E-9]
[125,87.15596329879455,null,87.15596330240732,-3.6127687508269446E-9]
[126,87.1559632994794,null,87.15596330247286,-2.9934597023384413E-9]
[127,87.15596330004576,null,87.15596330252595,-2.4801920517347753E-9]
[128,87.15596330051409,null,87.15596330256895,-2.0548611701087793E-9]
[129,{"$f":"P0*L/(P0+(L-P0)*EXP(-a*A131))","v":87.15596330090139},null,{"$f":"(1+a)*D130-b*D130^2","v":87.15596330260378},{"$f":"B131-D131","v":-1.702389340607624E-9}]
[130,87.15596330122168,null,87.15596330263199,-1.4103136436460773E-9]
[131,87.15596330148654,null,87.15596330265484,-1.1683027878461871E-9]
[132,87.15596330170557,null,87.15596330267336,-9.677876278146869e-10]
[133,87.15596330188669,null,87.15596330268835,-8.016627361939754e-10]
[134,87.15596330203648,null,87.1559633027005,-6.640163974225288e-10]
[135,87.15596330216034,null,87.15596330271033,-5.499884991877479e-10]
[136,87.15596330226279,null,87.1559633027183,-4.5551473704108503E-10]
[137,87.15596330234749,null,87.15596330272476,-3.772697709791828e-10]
[138,87.15596330241753,null,87.15596330272999,-3.1245406262314646E-10]
[139,87.15596330247547,null,87.15596330273422,-2.587512426543981e-10]
[140,87.15596330252338,null,87.15596330273766,-2.1428547825053101E-10]
[141,87.15596330256298,null,87.15596330274045,-1.7746515368344262E-10]
[142,87.15596330259575,null,87.15596330274269,-1.4694023775518872E-10]
[143,87.15596330262284,null,87.15596330274451,-1.2167333807155956E-10]
[144,87.15596330264525,null,87.15596330274599,-1.00740749076067E-10]
[145,87.15596330266376,null,87.15596330274718,-8.341771717823576e-11]
[146,87.1559633026791,null,87.15596330274815,-6.905054306116654e-11]
[147,87.15596330269176,null,87.15596330274893,-5.717026851925766e-11]
[148,87.15596330270225,null,87.15596330274957,-4.732214620162267e-11]
[149,87.1559633027109,null,87.15596330275008,-3.9179326449811924E-11]
[150,87.15596330271806,null,87.1559633027505,-3.242917046009097e-11]
[151,87.15596330272399,null,87.15596330275083,-2.6844304557016585E-11]
[152,87.15596330272888,null,87.1559633027511,-2.2225776774575934E-11]
[153,87.15596330273294,null,87.15596330275133,-1.8388846001471393E-11]
[154,87.15596330273628,null,87.15596330275152,-1.5234036254696548E-11]
[155,87.15596330273907,null,87.15596330275166,-1.2590817277668975E-11]
[156,87.15596330274136,null,87.15596330275177,-1.0416556506243069E-11]
[157,87.15596330274326,null,87.15596330275187,-8.611777957412414e-12]
[158,87.15596330274482,null,87.15596330275196,-7.133849067031406e-12]
[159,87.15596330274612,null,87.15596330275201,-5.8975047068088315E-12]
[160,87.15596330274718,null,87.15596330275207,-4.888534022029489e-12]
[161,{"$f":"P0*L/(P0+(L-P0)*EXP(-a*A163))","v":87.15596330274806},null,{"$f":"(1+a)*D162-b*D162^2","v":87.15596330275211},-4.050093593832571e-12]
[162,87.15596330274882,null,87.15596330275214,-3.325340003357269e-12]
[163,87.15596330274941,null,87.15596330275217,-2.7569058147491887E-12]
[164,87.15596330274991,null,87.15596330275218,-2.2737367544323206E-12]
[165,87.15596330275032,null,87.1559633027522,-1.8758328224066645E-12]
[166,87.15596330275066,null,87.15596330275221,-1.5489831639570184E-12]
[167,87.15596330275096,null,87.15596330275223,-1.2647660696529783E-12]
[168,87.15596330275119,null,87.15596330275224,-1.0516032489249483E-12]
[169,87.15596330275139,null,87.15596330275224,-8.526512829121202e-13]
[170,87.15596330275153,null,87.15596330275224,-7.105427357601002e-13]
[171,87.15596330275167,null,87.15596330275224,-5.684341886080801e-13]
[172,87.15596330275179,null,87.15596330275224,-4.547473508864641e-13]
[173,87.15596330275189,null,87.15596330275224,-3.552713678800501e-13]
[174,87.15596330275196,null,87.15596330275224,-2.8421709430404007E-13]
[175,87.155963302752,null,87.15596330275224,-2.4158453015843406E-13]
[176,87.15596330275206,null,87.15596330275224,-1.8474111129762605E-13]
[177,87.1559633027521,null,87.15596330275224,-1.4210854715202004E-13]
[178,87.15596330275214,null,87.15596330275224,0]
[179,87.15596330275217,null,87.15596330275224,0]
[180,87.1559633027522,null,87.15596330275224,0]
[181,87.15596330275221,null,87.15596330275224,0]
[182,87.15596330275223,null,87.15596330275224,0]
[183,87.15596330275224,null,87.15596330275224,0]
[184,87.15596330275226,null,87.15596330275224,0]
[185,87.15596330275227,null,87.15596330275224,0]
[186,87.15596330275227,null,87.15596330275224,0]
[187,87.15596330275228,null,87.15596330275224,0]
[188,87.15596330275228,null,87.15596330275224,0]
[189,87.15596330275228,null,87.15596330275224,0]
[190,87.1559633027523,null,87.15596330275224,0]
[191,87.1559633027523,null,87.15596330275224,0]
[192,87.1559633027523,null,87.15596330275224,0]
[193,{"$f":"P0*L/(P0+(L-P0)*EXP(-a*A195))","v":87.1559633027523},null,{"$f":"(1+a)*D194-b*D194^2","v":87.15596330275224},{"$f":"B195-D195","v":0}]
[194,87.1559633027523,null,87.15596330275224,0]
[195,87.15596330275231,null,87.15596330275224,0]
[196,87.15596330275231,null,87.15596330275224,0]
[197,87.15596330275231,null,87.15596330275224,0]
[198,87.15596330275231,null,87.15596330275224,0]
[199,87.15596330275231,null,87.15596330275224,0,{"$f":"a/b","v":87.15596330275231}]

{"sheet":"Sheet4","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}