{"text_format":"2","workbook":"xlsx","n_sheets":11,"sheets":["алг.Джонсона","хищние-жертва","Монте-Карло1","Монте-Карло2","Монте-Карло3","Монте-Карло4","Монте-Карло5","Монте-Карло6","Монте-Карло7","Раскрой","РаспределениеИнвестиций"],"not_rendered":{"charts":9,"images":8,"macros":0,"external_links":0,"defined_names":36,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"алг.Джонсона","index":0,"n_rows":52,"n_cols":22,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["1.",{"$nulls":6},"Первая оценка:",null,"Вторая оценка:",null,null,"2.",{"$nulls":6},"Первая оценка:",null,"Вторая оценка:"]
["1.1.",14,4,-2,{"$f":"B10","v":4},{"$f":"C10","v":4},null,{"$f":"B2","v":14},null,{"$f":"E2","v":4},null,null,"2.1.",19,18,null,{"$f":"N22","v":4},{"$f":"O22","v":19},null,{"$f":"N2","v":19},null,{"$f":"Q2","v":4}]
[null,11,7,null,{"$f":"B19","v":6},{"$f":"C19","v":10},null,{"$f":"H2+B3-C2","v":21},null,{"$f":"J2+E3-F2","v":6},null,null,null,14,2,null,{"$f":"N27","v":6},{"$f":"O27","v":8},null,{"$f":"T2+N3-O2","v":15},null,{"$f":"V2+Q3-R2","v":-9}]
[null,20,6,null,{"$f":"B23","v":7},{"$f":"C23","v":17},null,34,null,3,null,null,null,19,1,-1,{"$f":"N29","v":7},{"$f":"O29","v":20},null,32,null,-10]
[null,20,7,null,{"$f":"B27","v":11},{"$f":"C27","v":12},null,48,null,-3,null,null,null,6,8,null,{"$f":"N28","v":11},{"$f":"O28","v":11},null,37,null,-19]
[null,7,17,null,{"$f":"B28","v":14},{"$f":"C28","v":19},null,48,null,-1,null,null,null,11,11,null,{"$f":"N32","v":19},{"$f":"O32","v":18},null,40,null,-11]
[null,11,12,null,{"$f":"B21","v":11},{"$f":"C21","v":7},null,42,null,-9,null,null,null,7,3,null,{"$f":"N33","v":18},{"$f":"O33","v":12},null,36,null,-11]
[null,14,19,null,{"$f":"B22","v":20},{"$f":"C22","v":7},null,44,null,4,null,null,null,16,4,null,{"$f":"N20","v":11},{"$f":"O20","v":4},null,49,null,-12]
[null,18,4,-1,{"$f":"B14","v":20},{"$f":"C14","v":6},null,43,null,17,null,null,null,11,4,null,{"$f":"N19","v":16},{"$f":"O19","v":4},null,56,null,0]
[null,4,4,1,{"$f":"B2","v":14},{"$f":"C2","v":4},null,43,null,25,null,null,null,7,20,null,{"$f":"N18","v":7},{"$f":"O18","v":3},null,59,null,3]
[null,6,10,null,{"$f":"B9","v":18},{"$f":"C9","v":4},null,45,null,39,null,null,null,4,19,null,{"$f":"N15","v":14},{"$f":"O15","v":2},null,43,null,14]
[{"$nulls":13},18,12,null,{"$f":"N4","v":19},{"$f":"O4","v":1},null,42,null,31]
["1.2.",11,7,{"$nulls":4},"Разница:",{"$f":"MAX(H2:H11)-MAX(J2:J11)","v":9}]
[null,20,6,-1,{"$nulls":8},"2.2.",19,18,{"$nulls":4},"Разница:",{"$f":"MAX(T2:T12)-MAX(V2:V12)","v":28}]
[null,20,7,{"$nulls":10},14,2,-1]
[null,7,17,{"$nulls":10},6,8]
[null,11,12,{"$nulls":10},11,11]
[null,14,19,{"$nulls":10},7,3,-2]
[null,6,10,1,{"$nulls":9},16,4,-3]
[{"$nulls":13},11,4,-4]
["1.3.",11,7,-2,{"$nulls":9},7,20]
[null,20,7,-1,{"$nulls":9},4,19,1]
[null,7,17,1,{"$nulls":9},18,12]
[null,11,12]
[null,14,19]
[{"$nulls":12},"2.3.",19,18]
["1.4.",11,12,1,{"$nulls":9},6,8,1]
[null,14,19,{"$nulls":10},11,11,3]
[{"$nulls":13},7,20,2]
[{"$nulls":13},18,12]
[]
[{"$nulls":12},"2.4.",{"$f":"N26","v":19},{"$f":"O26","v":18}]
[{"$nulls":13},{"$f":"N30","v":18},{"$f":"O30","v":12},-1]
[{"$nulls":7},"Первая оценка:",null,"Вторая оценка:"]
["3.",11,10,null,{"$f":"B37","v":1},{"$f":"C37","v":5},null,{"$f":"B35","v":11},null,{"$f":"E35","v":1}]
["3.1.",9,10,null,{"$f":"B38","v":7},{"$f":"C38","v":15},null,{"$f":"H35+B36-C35","v":10},null,{"$f":"J35+E36-F35","v":3}]
[null,1,5,1,{"$f":"B46","v":9},{"$f":"C46","v":10},null,{"$f":"H36+B37-C36","v":1},null,{"$f":"J36+E37-F36","v":-3}]
[null,7,15,2,{"$f":"B48","v":10},{"$f":"C48","v":14},null,3,null,{"$f":"J37+E38-F37","v":-3}]
[null,20,20,null,{"$f":"B51","v":20},{"$f":"C51","v":20},null,8,null,3]
[null,16,7,-2,{"$f":"B52","v":19},{"$f":"C52","v":18},null,4,null,2]
[null,10,14,null,{"$f":"B45","v":11},{"$f":"C45","v":10},null,7,null,-5]
[null,18,6,-1,{"$f":"B40","v":16},{"$f":"C40","v":7},null,11,null,1]
[null,19,18,null,{"$f":"B42","v":18},{"$f":"C42","v":6},null,24,null,12]
[]
["3.2.",{"$f":"B35","v":11},{"$f":"C35","v":10},-1,null,null,null,"Разница:",{"$f":"MAX(H35:H43)-MAX(J35:J43)","v":12}]
[null,{"$f":"B36","v":9},{"$f":"C36","v":10},1]
[null,{"$f":"B39","v":20},{"$f":"C39","v":20}]
[null,{"$f":"B41","v":10},{"$f":"C41","v":14},2]
[null,{"$f":"B43","v":19},{"$f":"C43","v":18}]
[]
["3.3.",{"$f":"B47","v":20},{"$f":"C47","v":20}]
[null,{"$f":"B49","v":19},{"$f":"C49","v":18},-1]

{"sheet":"хищние-жертва","index":1,"n_rows":368,"n_cols":6,"rows_kept":368,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["жертвы","v(t)=(a-b x(t))x(t)-cx(t)y(t)"]
["x(t)"]
["x(0)",600,null,"начальная численность"]
["a",{"$f":"B15/100","v":0.06},null,"коэффициент естественного прироста популяции жертв"]
["b",{"$f":"C15/100000","v":1.0000000000000001E-5},null," коэффициент смертности жертв от внутривидовой конкуренции "]
["c",{"$f":"D15/1000","v":1E-3},null," коэффициент смертности жертв от хищников"]
["хищники","w(t)=-dy(t)+fx(t)y(t)"]
["y(t)"]
["y(0)",60,null,"начальная численность"]
["d",{"$f":"E15/100","v":0.13},null,"коэффициент смертности хищников"]
["f",{"$f":"F15/10000","v":2.0000000000000001E-4},null,"коэффициент, определяющий прирост численности хищников"]
[null,6,1,1,13,2]
["t","x(t)","y(t)"]
[0,{"$f":"B6","v":600},{"$f":"B12","v":60}]
[{"$f":"A17+1","v":1},{"$f":"B17+($B$7-$B$8*B17)*B17-$B$9*B17*C17","v":596.4},{"$f":"C17-$B$13*C17+$B$14*B17*C17","v":59.400000000000006}]
[{"$f":"A18+1","v":2},{"$f":"B18+($B$7-$B$8*B18)*B18-$B$9*B18*C18","v":593.2009104},{"$f":"C18-$B$13*C18+$B$14*B18*C18","v":58.763232000000002}]
[3,590.41568910255967,58.095692384089283]
[4,588.05411533648635,57.403374024726155]
[5,586.12299550159389,56.692193467399704]
[6,584.62637531646374,55.967927967971384]
[7,583.5657509864069,55.236162704512715]
[8,582.94027341808169,54.502248106979323]
[9,582.74694078605648,53.771266935748542]
[10,582.98077595426685,53.048010495900812]
[11,583.63498633847007,52.336963195779774]
[12,584.70110474622925,51.64229454028159]
[13,586.16911054275556,50.967857583911545]
[14,588.02753116754479,50.317192847249295]
[15,590.26352457823828,49.693536714156735]
[16,592.86294363880108,49.099833367247605]
[17,595.81038381544749,48.538749377961622]
[18,599.08921581294612,48.012690138187637]
[19,602.68160499273233,47.523817397014604]
[20,606.5685195781158,47.074067244245562]
[21,610.72972978450809,46.665167958266181]
[22,615.14380012565141,46.298657207191695]
[23,619.78807724971352,45.975898157286132]
[24,624.63867575895426,45.698094100585543]
[25,629.67046456825472,45.46630126424899]
[26,634.85705646359406,45.281439507748601]
[27,640.17080363166997,45.144300651405999]
[28,645.58280204394566,45.055554212203283]
[29,651.0629076876761,45.015750351808279]
[30,656.57976773547853,45.025319869231367]
[31,662.1008698236559,45.084571098622398]
[32,667.59261265483849,45.193683603806349]
[33,673.0204011368545,45.352698597823768]
[34,678.34876919865542,45.561506060695919]
[35,683.54153326473124,45.81982858462748]
[36,688.56197909897264,46.12720204555859]
[37,693.37308432351597,46.482953285793577]
[38,697.93777835404717,46.88617509628773]
[39,702.2192407485303,47.33569891021471]
[40,706.18123802363573,47.830065761693199]
[41,709.78849784134354,48.367496223541963]
[42,713.00711810629082,48.945860212252448]
[43,715.80500695479441,49.562647731293922]
[44,718.15234788826956,50.214941807025085]
[45,720.02208245600355,50.899395043669401]
[46,721.39040099602732,51.612211371011107]
[47,722.23723009207151,52.349134664224749]
[48,722.54670371467853,53.105445961396832]
[49,722.30760361836451,53.875970972156296]
[50,721.51375360750649,54.655099442878132]
[51,720.16435190468644,55.436817705868485]
[52,718.26422618661957,56.214755383066588]
[53,715.8239969961337,56.982246738365617]
[54,712.86013725106966,57.732406585993438]
[55,709.39491845059183,58.45821998635946]
[56,705.45623785440182,59.152644228130775]
[57,701.07732523407208,59.808720849737185]
[58,696.29633254953774,60.419694747072356]
[59,691.15581480914159,60.979136803182762]
[60,685.70211511068328,61.481066015481389]
[61,679.98467110457648,61.920066834683837]
[62,674.05526356012319,62.291397402446115]
[63,667.96723009676532,62.591084598854962]
[64,661.77466828949036,62.816002282653713]
[65,655.53165219708808,62.963929800683744]
[{"$f":"A82+1","v":66},{"$f":"B82+($B$7-$B$8*B82)*B82-$B$9*B82*C82","v":649.29148492752722},{"$f":"C82-$B$13*C82+$B$14*B82*C82","v":63.0335887128076}]
[67,643.10600728353506,63.024656663272587]
[68,637.02497904737254,62.937758358473729]
[69,631.09554535131645,62.774434611791207]
[70,625.36179615332378,62.537091321348136]
[71,619.86442240671931,62.228931000557424]
[72,614.64046835781812,61.853870044814585]
[73,609.7231757517676,61.416445269806381]
[74,605.1419127330945,60.921713395389745]
[75,600.92217798055401,60.375147088201786]
[76,597.08566913535981,59.782530943563259]
[77,593.65040382957045,59.149860419108599]
[78,590.63088151540796,58.483246269477789]
[79,588.03827472631144,57.788826514050548]
[80,585.88063924267874,57.072687435580058]
[81,584.16313376479013,56.3407945885657]
[82,582.88824099652368,55.598934317183136]
[83,582.05598341597079,54.852665861034154]
[84,581.66412837189387,54.107283773246088]
[85,581.70837843732522,53.367790093631278]
[86,582.18254413197315,52.638875508689168]
[87,583.07869716907692,51.924908585338557]
[88,584.38730327973497,51.22993207895707]
[89,586.09733441934782,50.55766527965779]
[90,588.19636077550103,49.91151136427689]
[91,590.67062348846298,49.29456875597544]
[92,593.50508938156133,48.709645550036015]
[93,596.68348929731849,48.159276135714997]
[94,600.18834186446588,47.645739223410345]
[95,604.00096469782818,47.171076568648083]
[96,608.1014751728402,46.737111765383546]
[97,612.46878303228914,46.345468557853209]
[98,617.08057718564635,45.997588190670207]
[99,621.91330915954097,45.694745379852364]
[100,626.94217575762912,45.438062542548884]
[101,632.14110359301299,45.228521970544897]
[102,637.4827382677347,45.066975672842275]
[103,642.93844109053657,44.954152646846552]
[104,648.47829634233995,44.890663367418412]
[105,654.07113221242867,44.877001310090215]
[106,659.68455862804853,44.913541351216359]
[107,665.28502527410888,45.000534916098189]
[108,670.83790313301097,45.138101778806387]
[109,676.30759284949374,45.326218457301337]
[110,681.65766312117682,45.564703197417714]
[111,686.85102210916739,45.853197602225762]
[112,691.85012452993101,46.191145041948893]
[113,696.61721660415367,46.577766076386027]
[114,701.11462037593833,47.012031238410124]
[115,705.30505805462599,47.492631664380738]
[116,709.15201595551616,48.017948214653842]
[117,712.62014631704005,48.586019902442715]
[118,715.67570375485195,49.194512637493432]
[119,718.28701139797795,49.840689485162301]
[120,720.42494987811438,50.521383831353575]
[121,722.06346037225649,51.232977016172789]
[122,723.18005091707437,51.971382137964326]
[123,723.7562933308908,52.732035816181721]
[124,723.77829642727204,53.509899716500385]
[125,723.2371399303139,54.299473565115903]
[126,722.12925275943076,55.094821193842058]
[127,720.45671928846411,55.889610850567315]
[128,718.22749792638433,56.6771705751353]
[129,715.45553800246512,57.450558882712969]
[{"$f":"A146+1","v":130},{"$f":"B146+($B$7-$B$8*B146)*B146-$B$9*B146*C146","v":712.16078350005535},{"$f":"C146-$B$13*C146+$B$14*B146*C146","v":58.202650330755027}]
[131,708.3690556331743,58.926234800022925]
[132,704.11181048406752,59.614128535482131]
[133,699.42577272293181,60.2592942205791]
[134,694.35245154684992,60.854966656697222]
[135,688.93755008309029,61.394780048702486]
[136,683.23028425428754,61.872892513299817]
[137,677.28263115682603,62.284103274470205]
[138,671.14853005659177,62.623958117784412]
[139,664.88306092893947,62.888839049887757]
[140,658.54162593181672,63.076034734553701]
[141,652.17915828545176,63.18378911334667]
[142,645.84938083633165,63.211326608857185]
[143,639.60413330707127,63.158853380140464]
[144,633.49278315518757,63.027535176096833]
[145,627.5617304072847,62.819453338027657]
[146,621.85401213695161,62.537541372094523]
[147,616.40900772964289,62.185505196005749]
[148,611.2622419922825,61.767730631132295]
[149,606.44527971860384,61.28918195075736]
[150,601.98570263693887,60.755295315529196]
[151,597.90715779392872,60.171870752397119]
[152,594.2294653474429,59.544965998727371]
[153,590.96877338386298,58.8807950808039]
[154,588.13774763097717,58.185633969253246]
[155,585.74578467979438,57.46573509468174]
[156,583.79923842264498,56.727251951420222]
[157,582.30165073312639,55.976174495145315]
[158,581.2539788424001,55.218275572826151]
[159,580.65481331222168,54.459068224663014]
[160,580.50058189557922,53.703773374086673]
[161,580.78573585985737,52.957297174184532]
[162,581.50291649320809,52.224217103232128]
[163,582.64310050679546,51.508775791232743]
[164,584.19572388120821,50.814881504435128]
[165,586.14878439164852,50.146114205742826]
[166,588.48892359704848,49.505736135728448]
[167,591.20148951051283,48.896705912162616]
[168,594.27058150172104,48.321695217067081]
[169,597.67907923564496,47.783107222007438]
[170,601.40865764475643,47.283095988639971]
[171,605.43979008072506,46.823586167679998]
[172,609.75174191125177,46.406292401918982]
[173,614.32255693057584,46.03273791521211]
[174,619.12903904828511,45.70427183795217]
[175,624.14673181782075,45.422084879704975]
[176,629.3498984684818,45.187223011347228]
[177,634.71150521530376,45.000598862724893]
[178,640.20321073994501,44.863000578520698]
[179,645.79536486012739,44.775097906072396]
[180,651.45701953008677,44.737445316062974]
[181,657.15595543194911,44.750481982373309]
[182,662.85872751710247,44.814528473298132]
[183,668.53073292358329,44.929780035387239]
[184,674.13630471321198,45.09629638621746]
[185,679.63883482062442,45.313987976420478]
[186,685.00092946252835,45.582598737359852]
[187,690.18459999422578,45.901685401984864]
[188,695.15149179495779,46.270593575372772]
[189,699.86315318704908,46.688430840606024]
[190,704.28134562092089,47.15403731641964]
[191,708.36839536761283,47.665954235818511]
[192,712.08758573841999,48.22239128830067]
[193,715.40358739407793,48.821193659025475]
[{"$f":"A210+1","v":194},{"$f":"B210+($B$7-$B$8*B210)*B210-$B$9*B210*C210","v":718.28292262463162},{"$f":"C210-$B$13*C210+$B$14*B210*C210","v":49.459809900257724}]
[195,720.69445760515191,50.13526197474738]
[196,722.60991461345043,50.844119005186769]
[197,724.00439411034665,51.582476433099316]
[198,724.85689453339921,52.345942416127869]
[199,725.15081576869864,53.129633354266957]
[200,724.87443069038193,53.928180411879964]
[201,724.0213080548881,54.735748773181506]
[202,722.59066956888364,55.546071117492431]
[203,720.5876642648268,56.352496416360353]
[204,718.02354453365285,57.148054635864938]
[205,714.91573034777866,57.925537283771817]
[206,711.28775136064314,58.677592995484524]
[207,707.16906061291172,59.39683654147418]
[208,702.59471834639191,60.075968811165126]
[209,697.60494967842578,60.7079045429671]
[210,692.2445853071938,61.285903891137224]
[211,686.56239964245731,61.803703410148749]
[212,680.61036541491421,62.255641750841903]
[213,674.44284756352636,62.636775339468556]
[214,668.11576174889387,62.942979569767253]
[215,661.68572400085441,63.171031574097533]
[216,655.20921770445273,63.318671422062366]
[217,648.74180240853639,63.384639570901214]
[218,642.33738597088393,63.368689490732436]
[219,636.04757759510017,63.271575528912756]
[220,629.92113469536991,63.095017179312173]
[221,624.00351160251682,62.841641909044824]
[222,618.33651324763332,62.514909506091364]
[223,612.95805243635107,62.119021504297059]
[224,607.9020054015408,61.658819596843585]
[225,603.19815716030803,61.139677065976528]
[226,598.87222588633722,60.567387154514257]
[227,594.9459540487934,59.948052016696103]
[228,591.4372534088908,59.287975454613601]
[229,588.36039100317532,58.593562118123913]
[230,585.72620384826348,57.871225266385451]
[231,583.54233113308669,57.127304599220878]
[232,581.81345398165024,56.367995100758016]
[233,580.54153434461591,55.599287322378025]
[234,579.72604610370036,54.82691908458898]
[235,579.3641929636558,54.056338207783668]
[236,579.45110910026779,53.292675592836396]
[237,579.98003978871873,52.540727761605631]
[238,580.94250033280434,51.804947828137756]
[239,582.32841254495452,51.089443794657612]
[240,584.12621879433289,50.397983041901654]
[241,586.32297425803631,49.734001900279821]
[242,588.90441849616366,49.100619236428827]
[243,591.85502784545974,48.500653059539218]
[244,595.15805040925125,47.936639235214429]
[245,598.795525633735,47.410851484716915]
[246,602.74829062103527,46.925321938810519]
[247,606.99597545437177,46.481861603857112]
[248,611.51698991428771,46.082080180389362]
[249,616.28850405870605,45.727404749118861]
[250,621.2864252325578,45.419096905197698]
[251,626.48537417120747,45.158267978226277]
[252,631.85866296971278,44.945892023309412]
[253,637.37827780836744,44.78281630824506]
[254,643.01486945269221,44.669769054964746]
[255,648.73775467912105,44.607364221291341]
[256,654.51493190933297,44.596103133938321]
[257,660.313114456839,44.636372807752579]
[{"$f":"A274+1","v":258},{"$f":"B274+($B$7-$B$8*B274)*B274-$B$9*B274*C274","v":666.09778488626876},{"$f":"C274-$B$13*C274+$B$14*B274*C274","v":44.728440812093474}]
[259,671.83327404278896,44.872446575791727]
[260,677.48286830692155,45.068389060403661]
[261,683.00894854622845,45.316110780674094]
[262,688.37316404454725,45.615278214488981]
[263,693.53664436417296,45.965358725261432]
[264,698.46025160795091,46.365594220440101]
[265,703.10487486850479,46.814971892815038]
[266,707.43176775530628,47.312192537683146]
[267,711.40292875701812,47.855637108446857]
[268,714.98152281551643,48.44333236364519]
[269,718.13234086115426,49.072916665094759]
[270,720.82229220532747,49.741607202150213]
[271,723.02092264681482,50.446170130156872]
[272,724.70094898826903,51.182895307537322]
[273,725.83879847158062,51.947577477825369]
[274,726.41513954619461,52.735505849710897]
[275,726.41538852849021,53.541464057419859]
[276,725.83017525763478,54.359742413086245]
[277,724.65574997729732,55.184164171915086]
[278,722.8943135413142,56.00812720454001]
[279,720.55425380002885,56.824662001601922]
[280,717.6502727753342,57.626506326594296]
[281,714.2033920173393,58.40619610101102]
[282,710.24082731651697,59.156171281913977]
[283,705.79572859549137,59.86889462169399]
[284,700.90678610645921,60.536980340818815]
[285,695.61770971347266,61.153328962767013]
[286,689.97659368117627,61.711263924494219]
[287,684.03518462938541,62.204665149186489]
[288,677.84807475890602,62.628094601818816]
[289,671.47184576823531,62.976908973914675]
[290,664.96419080824273,63.247355069204289]
[291,658.38304222180966,63.43664416707874]
[292,651.78573167720208,63.543002580371244]
[293,645.22820674784077,63.565696730885705]
[294,638.76432425253438,63.50503225833986]
[295,632.44523607117458,63.362327868182447]
[296,626.31887806254201,63.139865726641091]
[297,620.42956751318991,62.840821154763631]
[298,614.81770959031155,62.469175102889096]
[299,609.5196088487171,62.029613370864389]
[300,604.5673781650828,61.527416768421304]
[301,599.98893466661889,60.968346396717493]
[302,595.80807032644032,60.358528005734605]
[303,592.04458388052444,59.704338984757335]
[304,588.71446049024075,59.01230102275737]
[305,585.83008600085179,58.288980881578972]
[306,583.40048358150784,57.540901103525186]
[307,581.43156182445455,56.774461865969378]
[308,579.92636488859205,55.995874630288064]
[309,578.88531687187833,55.211107732970675]
[310,578.30645418844438,54.425843646654116]
[311,578.18564123467979,53.645447303691327]
[312,578.51676600285498,52.874944623932649]
[313,579.29191351114468,52.119010216104911]
[314,580.501515952825,51.381963119690134]
[315,582.13447932614702,50.66776941085287]
[316,584.17828700090854,49.980050500362815]
[317,586.61908122540899,49.322095992419818]
[318,589.44172399917136,48.696880040442188]
[319,592.62983905479143,48.107080220068518]
[320,596.16583692848269,47.555098033102638]
[321,600.03092527386457,47.043080252623433]
[{"$f":"A338+1","v":322},{"$f":"B338+($B$7-$B$8*B338)*B338-$B$9*B338*C338","v":604.20510670573208},{"$f":"C338-$B$13*C338+$B$14*B338*C338","v":46.572940414125242}]
[323,608.66716656586686,46.146379846792208]
[324,613.39465309464651,45.764907720433065]
[325,618.36385258079076,45.429859655793479]
[326,623.54976215489148,45.142414508332543]
[327,628.92606299558247,44.903608988202969]
[328,634.46509683292265,44.714349822785294]
[329,640.13784876177124,44.575423203850136]
[330,645.9139395159458,44.48750129082125]
[331,651.76163049631737,44.451145566609505]
[332,657.64784498430174,44.466806865334782]
[333,663.53820909491435,44.534821914505379]
[334,669.39711611580844,44.655406260722046]
[335,675.18781792220818,44.828643480809617]
[336,680.87254713061463,45.054470622748461]
[337,686.41267353155797,45.332659876297598]
[338,691.76889809561783,45.662796545176157]
[339,696.90148744760972,46.04425348430744]
[340,701.77055112077073,46.476162279673197]
[341,706.3363631068288,46.957381586712614]
[342,710.55972818379064,47.486463206635605]
[343,714.40239221313527,48.061616667476287]
[344,717.82749404504909,48.680673284879518]
[345,720.80005486317123,49.341050900347341]
[346,723.28749876807717,50.03972072249757]
[347,725.26019619499152,50.773177916658561]
[348,726.69201946756402,51.537417782948751]
[349,727.56089751720492,52.327919512532333]
[350,727.84935468653066,53.139639593052344]
[351,727.54501675046856,53.96701692317113]

{"sheet":"Монте-Карло1","index":2,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
["Задача. Методом Монте-Карло найти площадь фигуры, ограниченной графиками функций  "]
[]
[]
[]
[]
["x0",-5]
["xn",15]
["h",1]
["n",{"$f":"(B8-B7)/B9","v":20}]
[]
["x","y1","y2",{"$nulls":7},"Уточнение",null,null,"h=",{"$f":"B9/10","v":0.1}]
[{"$f":"B7","v":-5},{"$f":"A13*(10-A13)/5","v":-15},{"$f":"A13/3","v":-1.6666666666666667},{"$nulls":7},8,{"$f":"K13*(10-K13)/5","v":3.2},{"$f":"K13/3","v":2.6666666666666665}]
[{"$f":"A13+$B$9","v":-4},{"$f":"A14*(10-A14)/5","v":-11.2},{"$f":"A14/3","v":-1.3333333333333333},{"$nulls":7},{"$f":"K13+$O$12","v":8.1},3.0780000000000003,{"$f":"K14/3","v":2.6999999999999997}]
[{"$f":"A14+$B$9","v":-3},-7.8,-1,{"$nulls":7},8.1999999999999993,2.9520000000000008,2.7333333333333329]
[-2,-4.8,-0.66666666666666663,{"$nulls":7},8.2999999999999989,2.8220000000000014,2.7666666666666662,"ширина"]
[-1,-2.2000000000000002,-0.33333333333333331,{"$nulls":7},8.3999999999999986,2.6880000000000019,2.7999999999999994]
[0,0,0,{"$nulls":7},8.4999999999999982,2.5500000000000025,2.8333333333333326]
[1,1.8,0.33333333333333331,{"$nulls":7},8.5999999999999979,2.408000000000003,2.8666666666666658]
[2,3.2,0.66666666666666663,{"$nulls":7},8.6999999999999975,2.2620000000000036,2.899999999999999]
[3,4.2,1,{"$nulls":7},8.7999999999999972,2.1120000000000045,2.9333333333333322]
[4,4.8,1.3333333333333333,{"$nulls":7},8.8999999999999968,1.9580000000000051,2.9666666666666655]
[5,5,1.6666666666666667,"высота",{"$nulls":6},8.9999999999999964,1.8000000000000056,2.9999999999999987]
[6,4.8,2]
[7,4.2,2.3333333333333335]
[8,3.2,2.6666666666666665]
[9,1.8,3]
[10,0,3.3333333333333335]
[11,-2.2000000000000002,3.6666666666666665]
[12,-4.8,4]
[13,-7.8,4.333333333333333]
[14,-11.2,4.666666666666667]
[{"$f":"A32+$B$9","v":15},-15,5]

{"sheet":"Монте-Карло2","index":3,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["x0",-5]
["xn",15]
["h",1,null,null,"Ширина - 20"]
["n",{"$f":"(B5-B4)/B6","v":20},null,null,"Высота - 1 (2, но y > 0)"]
[]
["x","y1","y2"]
[{"$f":"B4","v":-5},{"$f":"SIN(A10)","v":0.95892427466313845},0]
[{"$f":"A10+$B$6","v":-4},{"$f":"SIN(A11)","v":0.7568024953079282},0]
[{"$f":"A11+$B$6","v":-3},-0.14112000805986721,0]
[-2,-0.90929742682568171,0]
[-1,-0.8414709848078965,0]
[0,0,0]
[1,0.8414709848078965,0]
[2,0.90929742682568171,0]
[3,0.14112000805986721,0]
[4,-0.7568024953079282,0]
[5,-0.95892427466313845,0]
[6,-0.27941549819892586,0]
[7,0.65698659871878906,0]
[{"$f":"A22+$B$6","v":8},0.98935824662338179,0]
[9,0.41211848524175659,0]
[10,-0.54402111088936977,0]
[11,-0.99999020655070348,0]
[12,-0.53657291800043494,0]
[{"$f":"A27+$B$6","v":13},0.42016703682664092,0]
[14,0.99060735569487035,0]
[15,0.65028784015711683,0]

{"sheet":"Монте-Карло3","index":4,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["x0",-5]
["xn",15,null,null,"Ширина",7]
["h",1,null,null,"Высота",8]
["n",{"$f":"(B5-B4)/B6","v":20}]
[]
["x","y1","y2"]
[{"$f":"B4","v":-5},{"$f":"A10*(8-A10)/2","v":-32.5},{"$f":"A10/2","v":-2.5}]
[{"$f":"A10+$B$6","v":-4},{"$f":"A11*(8-A11)/2","v":-24},{"$f":"A11/2","v":-2}]
[{"$f":"A11+$B$6","v":-3},-16.5,-1.5]
[-2,-10,-1]
[-1,-4.5,-0.5]
[0,0,0]
[1,3.5,0.5]
[2,6,1]
[3,7.5,1.5]
[4,8,2]
[5,7.5,2.5]
[6,6,3]
[7,3.5,3.5]
[8,0,4]
[9,-4.5,4.5]
[10,-10,5]
[11,-16.5,5.5]
[12,-24,6]
[13,-32.5,6.5]
[{"$f":"A28+$B$6","v":14},-42,7]
[15,-52.5,7.5]

{"sheet":"Монте-Карло4","index":5,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["x0",-5]
["xn",15,null,null,"Ширина",12]
["h",1,null,null,"Высота",6]
["n",{"$f":"(B5-B4)/B6","v":20}]
[]
["x","y1","y2"]
[{"$f":"B4","v":-5},{"$f":"(A10-6)^2/6","v":20.166666666666668},6]
[{"$f":"A10+$B$6","v":-4},{"$f":"(A11-6)^2/6","v":16.666666666666668},6]
[{"$f":"A11+$B$6","v":-3},13.5,6]
[-2,10.666666666666666,6]
[-1,8.1666666666666661,6]
[0,6,6]
[1,4.166666666666667,6]
[2,2.6666666666666665,6]
[3,1.5,6]
[4,0.66666666666666663,6]
[5,0.16666666666666666,6]
[6,0,6]
[7,0.16666666666666666,6]
[8,0.66666666666666663,6]
[9,1.5,6]
[10,2.6666666666666665,6]
[11,4.166666666666667,6]
[12,6,6]
[13,8.1666666666666661,6]
[14,10.666666666666666,6]
[{"$f":"A29+$B$6","v":15},13.5,6]

{"sheet":"Монте-Карло5","index":6,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["x0",-5]
["xn",15]
["h",1,null,null,"Ширина",10.199999999999999]
["n",{"$f":"(B5-B4)/B6","v":20},null,null,"Высота",4]
[{"$nulls":12},"Уточнение ширины"]
["x","y1","y2",{"$nulls":9},"x","y1","y2"]
[{"$f":"B4","v":-5},{"$f":"A10*(12-A10)/9","v":-9.4444444444444446},{"$f":"A10/5","v":-1},{"$nulls":9},10,{"$f":"M10*(12-M10)/9","v":2.2222222222222223},{"$f":"M10/5","v":2}]
[{"$f":"A10+$B$6","v":-4},{"$f":"A11*(12-A11)/9","v":-7.1111111111111107},{"$f":"A11/5","v":-0.8},{"$nulls":9},{"$f":"M10+0.1","v":10.1},{"$f":"M11*(12-M11)/9","v":2.1322222222222225},{"$f":"M11/5","v":2.02}]
[{"$f":"A11+$B$6","v":-3},-5,-0.6,{"$nulls":9},10.199999999999999,2.0400000000000009,2.04]
[-2,-3.1111111111111112,-0.4,{"$nulls":9},10.299999999999999,1.9455555555555566,2.0599999999999996]
[-1,-1.4444444444444444,-0.2,{"$nulls":9},10.399999999999999,1.8488888888888901,2.0799999999999996]
[0,0,0,{"$nulls":9},10.499999999999998,1.7500000000000018,2.0999999999999996]
[1,1.2222222222222223,0.2,{"$nulls":9},10.599999999999998,1.6488888888888911,2.1199999999999997]
[2,2.2222222222222223,0.4,{"$nulls":9},10.699999999999998,1.5455555555555582,2.1399999999999997]
[3,3,0.6,{"$nulls":9},10.799999999999997,1.4400000000000031,2.1599999999999993]
[4,3.5555555555555554,0.8,{"$nulls":9},10.899999999999997,1.3322222222222257,2.1799999999999993]
[5,3.8888888888888888,1,{"$nulls":9},10.999999999999996,1.2222222222222261,2.1999999999999993]
[6,4,1.2]
[7,3.8888888888888888,1.4]
[8,3.5555555555555554,1.6]
[9,3,1.8]
[10,2.2222222222222223,2]
[11,1.2222222222222223,2.2000000000000002]
[{"$f":"A26+$B$6","v":12},0,2.4]
[13,-1.4444444444444444,2.6]
[{"$f":"A28+$B$6","v":14},-3.1111111111111112,2.8]
[15,-5,3]

{"sheet":"Монте-Карло6","index":7,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["x0",-5]
["xn",15]
["h",1,null,null,"Ширина",8]
["n",{"$f":"(B5-B4)/B6","v":20},null,null,"Высота",4]
[]
["x","y1","y2"]
[{"$f":"B4","v":-5},{"$f":"A10*(8-A10)/4","v":-16.25},{"$f":"(8-A10)/8","v":1.625}]
[{"$f":"A10+$B$6","v":-4},{"$f":"A11*(8-A11)/4","v":-12},{"$f":"(8-A11)/8","v":1.5}]
[{"$f":"A11+$B$6","v":-3},-8.25,1.375]
[-2,-5,1.25]
[-1,-2.25,1.125]
[0,0,1]
[1,1.75,0.875]
[2,3,0.75]
[3,3.75,0.625]
[4,4,0.5]
[5,3.75,0.375]
[6,3,0.25]
[7,1.75,0.125]
[8,0,0]
[9,-2.25,-0.125]
[10,-5,-0.25]
[11,-8.25,-0.375]
[{"$f":"A26+$B$6","v":12},-12,-0.5]
[13,-16.25,-0.625]
[{"$f":"A28+$B$6","v":14},-21,-0.75]
[15,-26.25,-0.875]

{"sheet":"Монте-Карло7","index":8,"n_rows":33,"n_cols":19,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["x0",-5]
["xn",15,null,null,"Ширина","2,81-0,8=2,01","[0,8; 2,81]"]
["h",1,null,null,"Высота",1]
["n",{"$f":"(B5-B4)/B6","v":20}]
[{"$nulls":12},"Уточнение ширины слева",null,null,null,"Уточнение ширины справа"]
["x","y1","y2",{"$nulls":9},"x","y1","y2",null,"x","y1","y2"]
[{"$f":"B4","v":-5},{"$f":"SIN(A10)","v":0.95892427466313845},{"$f":"(A10-2)^2/2","v":24.5},{"$nulls":9},0,{"$f":"SIN(M10)","v":0},{"$f":"(M10-2)^2/2","v":2},null,2,{"$f":"SIN(Q10)","v":0.90929742682568171},{"$f":"(Q10-2)^2/2","v":0}]
[{"$f":"A10+$B$6","v":-4},{"$f":"SIN(A11)","v":0.7568024953079282},{"$f":"(A11-2)^2/2","v":18},{"$nulls":9},{"$f":"M10+0.1","v":0.1},{"$f":"SIN(M11)","v":9.9833416646828155E-2},{"$f":"(M11-2)^2/2","v":1.8049999999999999},null,{"$f":"Q10+0.1","v":2.1},{"$f":"SIN(Q11)","v":0.86320936664887371},{"$f":"(Q11-2)^2/2","v":5.0000000000000088E-3}]
[{"$f":"A11+$B$6","v":-3},-0.14112000805986721,12.5,{"$nulls":9},{"$f":"M11+0.1","v":0.2},0.19866933079506122,1.62,null,{"$f":"Q11+0.1","v":2.2000000000000002},0.80849640381959009,2.0000000000000035E-2]
[-2,-0.90929742682568171,8,{"$nulls":9},0.30000000000000004,0.2955202066613396,1.4449999999999998,null,2.3000000000000003,0.74570521217672003,4.5000000000000082E-2]
[-1,-0.8414709848078965,4.5,{"$nulls":9},0.4,0.38941834230865052,1.2800000000000002,null,2.4000000000000004,0.67546318055115062,8.000000000000014E-2]
[0,0,2,{"$nulls":9},0.5,0.47942553860420301,1.125,null,2.5000000000000004,0.59847214410395611,0.12500000000000022]
[1,0.8414709848078965,0.5,{"$nulls":9},0.6,0.56464247339503537,0.97999999999999987,null,2.6000000000000005,0.51550137182146383,0.18000000000000033]
[2,0.90929742682568171,0,{"$nulls":9},0.7,0.64421768723769102,0.84500000000000008,null,2.7000000000000006,0.42737988023382939,0.24500000000000044]
[3,0.14112000805986721,0.5,{"$nulls":9},{"$f":"M17+0.1","v":0.79999999999999993},0.71735609089952268,0.7200000000000002,null,2.8000000000000007,0.33498815015590427,0.32000000000000056]
[4,-0.7568024953079282,2,{"$nulls":9},0.89999999999999991,0.7833269096274833,0.60500000000000009,null,2.9000000000000008,0.23924932921398157,0.40500000000000069]
[5,-0.95892427466313845,4.5,{"$nulls":9},{"$f":"M19+0.1","v":0.99999999999999989},0.84147098480789639,0.5,null,3.0000000000000009,0.14112000805986635,0.50000000000000089]
[6,-0.27941549819892586,8]
[7,0.65698659871878906,12.5,{"$nulls":13},"x","y1","y2"]
[8,0.98935824662338179,18,{"$nulls":13},2.8,{"$f":"SIN(Q23)","v":0.33498815015590511},{"$f":"(Q23-2)^2/2","v":0.31999999999999984}]
[9,0.41211848524175659,24.5,{"$nulls":13},{"$f":"Q23+0.01","v":2.8099999999999996},{"$f":"SIN(Q24)","v":0.32554933451756046},{"$f":"(Q24-2)^2/2","v":0.32804999999999968}]
[10,-0.54402111088936977,32,{"$nulls":13},{"$f":"Q24+0.01","v":2.8199999999999994},0.31607796421705425,0.3361999999999995]
[11,-0.99999020655070348,40.5,{"$nulls":13},2.8299999999999992,0.30657498638352376,0.34444999999999931]
[{"$f":"A26+$B$6","v":12},-0.53657291800043494,50,{"$nulls":13},2.839999999999999,0.29704135130683323,0.35279999999999911]
[13,0.42016703682664092,60.5,{"$nulls":13},2.8499999999999988,0.28747801234254566,0.36124999999999896]
[{"$f":"A28+$B$6","v":14},0.99060735569487035,72,{"$nulls":13},2.8599999999999985,0.27788592581658805,0.36979999999999874]
[15,0.65028784015711683,84.5,{"$nulls":13},2.8699999999999983,0.26826605092961964,0.37844999999999857]
[{"$nulls":16},2.8799999999999981,0.25861934966111255,0.38719999999999832]
[{"$nulls":16},{"$f":"Q31+0.01","v":2.8899999999999979},0.24894678667315473,0.39604999999999813]
[{"$nulls":16},2.8999999999999977,0.23924932921398456,0.40499999999999792]

{"sheet":"Раскрой","index":9,"n_rows":25,"n_cols":21,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
{"$rows_empty":7}
["Минимизация расходов",{"$nulls":11},"Минимизация отходов"]
["Исходные данные"]
[null,"          Способы Заготовки",1,2,3,4,5,6,7,8,"Заказ",null,"Способы",1,2,3,4,5,6,7,8]
[null,2.2999999999999998,2,1,1,1,0,0,0,0,720,null,"Бревна",20,380,300,0,0,0,0,0]
[null,2.1,0,0,2,1,1,3,2,0,600]
[null,1.4,1,3,0,1,3,0,1,4,900,null,700,": максимальный расход"]
["Max=",6.5,{"$f":"C11*$B$11+C12*$B$12+C13*$B$13","v":6},6.4999999999999991,6.5,5.8000000000000007,6.2999999999999989,6.3000000000000007,5.6,5.6,null,null,{"$f":"SUM(N11:U11)","v":700},": общий расход"]
[null,"Остатки",{"$f":"$B$14-C14","v":0.5},{"$f":"$B$14-D14","v":0},0,0.69999999999999929,0.20000000000000107,0.19999999999999929,0.90000000000000036,0.90000000000000036,null,null,{"$f":"SUMPRODUCT($N$11:$U$11,C11:J11)","v":720},": заготовк по 2,3м"]
[{"$nulls":12},{"$f":"SUMPRODUCT($N$11:$U$11,C12:J12)","v":600},": заготовк по 2,1м"]
[{"$nulls":12},1160,": заготовк по 1,4м"]
["Расчет",{"$nulls":11},{"$f":"SUMPRODUCT($N$11:$U$11,C15:J15)","v":10},":отходы"]
[null,"Способы",1,2,3,4,5,6,7,8]
[null,"Бревна",72,276,300,0,0,0,0,0]
[null,{"$f":"SUM(C20:J20)","v":648},": общий расход"]
[null,{"$f":"SUMPRODUCT($C$20:$J$20,C11:J11)","v":720},": заготовк по 2,3м"]
[null,{"$f":"SUMPRODUCT($C$20:$J$20,C12:J12)","v":600},": заготовк по 2,1м"]
[null,{"$f":"SUMPRODUCT($C$20:$J$20,C13:J13)","v":900},": заготовк по 1,4м"]
[null,{"$f":"SUMPRODUCT($C$20:$J$20,C15:J15)","v":36},":отходы"]

{"sheet":"РаспределениеИнвестиций","index":10,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[[10,17,14,17],[10,16,14,16],[1,11,2,11],[1,10,2,10],[10,14,14,14],[10,13,14,13],[6,14,9,14],[6,13,9,13],[3,14,5,14],[3,13,5,13],[1,14,2,14],[1,13,2,13],[1,6,2,6],[3,6,5,6],[6,6,9,6],[10,6,14,6],[10,11,14,11],[10,10,14,10],[6,11,9,11],[6,10,9,10],[3,11,5,11],[3,10,5,10]]}
[null,1,2,3,4,null,0,0,0,0,0,0,0,0,0]
[0,0,0,0,0,null,50,0,50,{"$f":"D2+E3","v":28},{"$f":"MAX(J2:J3)","v":28},0,{"$f":"C9+D10","v":28},{"$f":"MAX(M2:M3)","v":28},0]
[50,25,26,27,28,null,null,50,0,{"$f":"D3+E2","v":27},null,null,{"$f":"C10+D9","v":26}]
[100,34,33,35,55,null,100,0,100,{"$f":"D2+E4","v":55},{"$f":"MAX(J4:J6)","v":55},"0 50",{"$f":"C9+D11","v":55},{"$f":"MAX(M4:M6)","v":55},0]
[150,46,46,45,44,null,null,50,50,{"$f":"D3+E3","v":55},null,null,{"$f":"C10+D10","v":54}]
[200,57,58,56,55,null,null,100,0,{"$f":"D4+E2","v":35},null,null,{"$f":"C11+D9","v":33}]
[{"$nulls":6},150,0,150,{"$f":"D2+E5","v":44},{"$f":"MAX(J7:J10)","v":82},50,{"$f":"C9+D12","v":82},{"$f":"MAX(M7:M10)","v":82},0]
[null,1,2,34,null,null,null,50,100,{"$f":"D3+E4","v":82},null,null,{"$f":"C10+D11","v":81}]
[0,0,0,0,null,null,null,100,50,{"$f":"D4+E3","v":63},null,null,{"$f":"C11+D10","v":61}]
[50,25,26,{"$f":"K2","v":28},null,null,null,150,0,{"$f":"D5","v":45},null,null,{"$f":"C12","v":46}]
[100,34,33,{"$f":"K4","v":55},null,null,200,0,200,{"$f":"E6","v":55},{"$f":"MAX(J11:J15)","v":90},100,{"$f":"D13","v":90},{"$f":"MAX(M11:M15)","v":108},50,{"$f":"C20","v":108},{"$f":"MAX(P11:P15)","v":108},0]
[150,46,46,{"$f":"K7","v":82},null,null,null,50,150,{"$f":"D3+E5","v":71},null,null,{"$f":"C10+D12","v":108},null,null,{"$f":"B17+C19","v":107}]
[200,57,58,{"$f":"K11","v":90},null,null,null,100,100,{"$f":"D4+E4","v":90},null,null,{"$f":"C11+D11","v":88},null,null,{"$f":"B18+C18","v":89}]
[{"$nulls":7},150,50,{"$f":"D5+E3","v":73},null,null,{"$f":"C12+D10","v":74},null,null,{"$f":"B19+C17","v":74}]
[null,1,234,{"$nulls":4},200,0,{"$f":"D6","v":56},null,null,{"$f":"C13","v":58},null,null,{"$f":"B20","v":57}]
[0,0,0,{"$nulls":4},3,4,null,"max(3;4)",3,null,"max(2;34)",2,null,"max(1;234)",1]
[50,25,28,{"$nulls":4},2,34]
[100,34,55,{"$nulls":4},1,234,null,null,null,1,0]
[150,46,82,{"$nulls":9},2,50]
[200,57,108,{"$nulls":7},"F",{"$f":"C3+D3+E4","v":108},3,50]
[{"$nulls":12},4,100]