{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Лист1","Лист2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":41,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":184,"n_cols":16,"rows_kept":184,"cut":false,"hidden":false,"merged":[[3,14,3,15],[9,0,17,6],[12,9,14,9],[15,9,19,9],[3,9,4,9],[3,10,3,11],[20,9,24,9],[25,9,30,9],[3,12,3,13],[5,9,8,9],[3,7,4,7],[3,8,4,8],[31,9,33,9],[34,9,37,9],[38,9,40,9],[41,9,46,9],[47,9,51,9],[52,9,57,9],[58,9,61,9],[62,9,68,9],[69,9,76,9],[77,9,82,9],[83,9,86,9],[87,9,90,9],[91,9,96,9],[97,9,100,9],[101,9,106,9],[107,9,114,9],[115,9,125,9],[126,9,129,9],[130,9,137,9],[138,9,143,9],[144,9,148,9],[149,9,150,9],[151,9,155,9],[156,9,159,9],[181,9,183,9],[160,9,163,9],[164,9,167,9],[168,9,171,9],[172,9,174,9],[175,9,177,9],[178,9,180,9]]}
[]
[]
[]
[null,null,null,null,null,null,null,"№ насоса","Производительность насоса, м3/час","Факт, м3/сут","Режим работы",null,"Режим работы Q + 2000 м3",null,"Режим работы Q - 2000 м3"]
[null,null,null,null,null,null,null,null,null,null,"час/сут","м3/сут","час/сут","м3/сут","час/сут","м3/сут"]
[null,null,null,null,null,null,null,1,287.463043478261,22053.548387096798,{"$f":"podbor($I$6:$I$9,L11)","v":7},{"$f":"K6*$I6","v":2012.2413043478271},{"$f":"podbor($I$6:$I$9,N11)","v":16},{"$f":"M6*$I6","v":4599.408695652176},{"$f":"podbor($I$6:$I$9,P11)","v":17},{"$f":"O6*$I6","v":4886.8717391304372}]
[null,null,null,null,null,null,null,2,269.25263157894739,null,9,{"$f":"K7*$I7","v":2423.2736842105264},1,{"$f":"M7*$I7","v":269.25263157894739},11,{"$f":"O7*$I7","v":2961.7789473684211}]
[null,null,null,null,null,null,null,3,201.73454157782515,null,12,{"$f":"K8*$I8","v":2420.8144989339016},16,{"$f":"M8*$I8","v":3227.7526652452025},4,{"$f":"O8*$I8","v":806.93816631130062}]
[null,null,null,null,null,null,null,4,759.86428571428598,null,20,{"$f":"K9*$I9","v":15197.285714285719},21,{"$f":"M9*$I9","v":15957.150000000005},15,{"$f":"O9*$I9","v":11397.96428571429}]
["1. Необходимо подобрать слагаемые из массива I6:I9 под сумму J6 (делённую на 24), после чего в соответствующую ячейку массива K6:K9 вернуть часовое значение, благодаря которому подбирается ближайшее значение суммы.\n2. Практически тоже самое, что и в п.1, только изменится значение в ячейке J6: (J6+2000)/24 и часовое значение необходимо вернуть в массив M6:M9.\n3. Практически тоже самое, что и в п.1, только изменится значение в ячейке J6: (J6-2000)/24 и часовое значение необходимо вернуть в массив O6:O9.",null,null,null,null,null,null,null,null,"Есть",null,{"$f":"SUM(L6:L9)","v":22053.615201777975},null,{"$f":"SUM(N6:N9)","v":24053.563992476331},null,{"$f":"SUM(P6:P9)","v":20053.553138524447}]
[null,null,null,null,null,null,null,null,null,"Нужно",null,{"$f":"J6","v":22053.548387096798},null,{"$f":"J6+2000","v":24053.548387096798},null,{"$f":"J6-2000","v":20053.548387096798}]
[null,null,null,null,null,null,null,null,null,"откл.",null,{"$f":"+L10-L11","v":6.6814681176765589E-2},null,{"$f":"+N10-N11","v":1.5605379532644292E-2},null,{"$f":"+P10-P11","v":4.7514276484434959E-3}]
[null,null,null,null,null,null,null,1,745.54794520547944,18777.290322580644,{"$f":"podbor($I$13:$I$15,$J13)","v":{"$error":"#VALUE!"}},{"$f":"K13*$I13","v":{"$error":"#VALUE!"}},{"$f":"podbor($I$13:$I$15,$J13+2000)","v":{"$error":"#VALUE!"}},{"$f":"M13*$I13","v":{"$error":"#VALUE!"}},{"$f":"podbor($I$13:$I$15,$J13-2000)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,2,795.47890625000002,null,{"$f":"podbor($I$13:$I$15,$J13)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"podbor($I$13:$I$15,$J13+2000)","v":{"$error":"#VALUE!"}},{"$f":"M14*$I14","v":{"$error":"#VALUE!"}},{"$f":"podbor($I$13:$I$15,$J13-2000)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,3,687.57037037037037,null,{"$f":"podbor($I$13:$I$15,$J13)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"podbor($I$13:$I$15,$J13+2000)","v":{"$error":"#VALUE!"}},{"$f":"M15*$I15","v":{"$error":"#VALUE!"}},{"$f":"podbor($I$13:$I$15,$J13-2000)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,1,736.45876132930516,38715.351612903221,{"$f":"podbor($I$16:$I$20,$J16)","v":22},16202.092749244714,{"$f":"podbor($I$16:$I$20,$J16+2000)","v":24},{"$f":"M16*$I16","v":17675.010271903324},{"$f":"podbor($I$16:$I$20,$J16-2000)","v":22},16202.092749244714]
[null,null,null,null,null,null,null,2,747.7109375,null,{"$f":"podbor($I$16:$I$20,$J16)","v":22},16449.640625,{"$f":"podbor($I$16:$I$20,$J16+2000)","v":24},{"$f":"M17*$I17","v":17945.0625},{"$f":"podbor($I$16:$I$20,$J16-2000)","v":22},16449.640625]
[null,null,null,null,null,null,null,3,193.19090909090909,null,{"$f":"podbor($I$16:$I$20,$J16)","v":22},4250.2,{"$f":"podbor($I$16:$I$20,$J16+2000)","v":24},{"$f":"M18*$I18","v":4636.5818181818177},{"$f":"podbor($I$16:$I$20,$J16-2000)","v":22},4250.2]
[null,null,null,null,null,null,null,4,256.52674418604653,null,{"$f":"podbor($I$16:$I$20,$J16)","v":22},5643.5883720930233,{"$f":"podbor($I$16:$I$20,$J16+2000)","v":24},{"$f":"M19*$I19","v":6156.6418604651171},{"$f":"podbor($I$16:$I$20,$J16-2000)","v":22},5643.5883720930233]
[null,null,null,null,null,null,null,5,774.14164456233425,null,{"$f":"podbor($I$16:$I$20,$J16)","v":22},17031.116180371355,{"$f":"podbor($I$16:$I$20,$J16+2000)","v":24},{"$f":"M20*$I20","v":18579.39946949602},{"$f":"podbor($I$16:$I$20,$J16-2000)","v":22},17031.116180371355]
[null,null,null,null,null,null,null,1,0,34046.774193548386,{"$f":"podbor($I$21:$I$25,$J21)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"podbor($I$21:$I$25,$J21+2000)","v":{"$error":"#VALUE!"}},{"$f":"M21*$I21","v":{"$error":"#VALUE!"}},{"$f":"podbor($I$21:$I$25,$J21-2000)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,2,740.62722007722016,null,{"$f":"podbor($I$21:$I$25,$J21)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"podbor($I$21:$I$25,$J21+2000)","v":{"$error":"#VALUE!"}},{"$f":"M22*$I22","v":{"$error":"#VALUE!"}},{"$f":"podbor($I$21:$I$25,$J21-2000)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,3,719.88190476190471,null,{"$f":"podbor($I$21:$I$25,$J21)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"podbor($I$21:$I$25,$J21+2000)","v":{"$error":"#VALUE!"}},{"$f":"M23*$I23","v":{"$error":"#VALUE!"}},{"$f":"podbor($I$21:$I$25,$J21-2000)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,4,685.35038520801231,null,{"$f":"podbor($I$21:$I$25,$J21)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"podbor($I$21:$I$25,$J21+2000)","v":{"$error":"#VALUE!"}},{"$f":"M24*$I24","v":{"$error":"#VALUE!"}},{"$f":"podbor($I$21:$I$25,$J21-2000)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,5,249.8,null,{"$f":"podbor($I$21:$I$25,$J21)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"podbor($I$21:$I$25,$J21+2000)","v":{"$error":"#VALUE!"}},{"$f":"M25*$I25","v":{"$error":"#VALUE!"}},{"$f":"podbor($I$21:$I$25,$J21-2000)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,1,288.03070175438597,13406.596774193549,{"$f":"podbor($I$26:$I$31,$J26)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"podbor($I$26:$I$31,$J26+2000)","v":{"$error":"#VALUE!"}},{"$f":"M26*$I26","v":{"$error":"#VALUE!"}},{"$f":"podbor($I$26:$I$31,$J26-2000)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,2,219.95,null,{"$f":"podbor($I$26:$I$31,$J26)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"podbor($I$26:$I$31,$J26+2000)","v":{"$error":"#VALUE!"}},{"$f":"M27*$I27","v":{"$error":"#VALUE!"}},{"$f":"podbor($I$26:$I$31,$J26-2000)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,3,291.89736842105259,null,{"$f":"podbor($I$26:$I$31,$J26)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"podbor($I$26:$I$31,$J26+2000)","v":{"$error":"#VALUE!"}},{"$f":"M28*$I28","v":{"$error":"#VALUE!"}},{"$f":"podbor($I$26:$I$31,$J26-2000)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,4,0,null,{"$f":"podbor($I$26:$I$31,$J26)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"podbor($I$26:$I$31,$J26+2000)","v":{"$error":"#VALUE!"}},{"$f":"M29*$I29","v":{"$error":"#VALUE!"}},{"$f":"podbor($I$26:$I$31,$J26-2000)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,5,270.29391891891891,null,{"$f":"podbor($I$26:$I$31,$J26)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"podbor($I$26:$I$31,$J26+2000)","v":{"$error":"#VALUE!"}},{"$f":"M30*$I30","v":{"$error":"#VALUE!"}},{"$f":"podbor($I$26:$I$31,$J26-2000)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,6,0,null,{"$f":"podbor($I$26:$I$31,$J26)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"podbor($I$26:$I$31,$J26+2000)","v":{"$error":"#VALUE!"}},{"$f":"M31*$I31","v":{"$error":"#VALUE!"}},{"$f":"podbor($I$26:$I$31,$J26-2000)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,1,259.70936227951154,18449.817777419354,{"$f":"podbor($I$32:$I$34,$J32)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"podbor($I$32:$I$34,$J32+2000)","v":{"$error":"#VALUE!"}},{"$f":"M32*$I32","v":{"$error":"#VALUE!"}},{"$f":"podbor($I$32:$I$34,$J32-2000)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,2,256.50906630581869,null,{"$f":"podbor($I$32:$I$34,$J32)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"podbor($I$32:$I$34,$J32+2000)","v":{"$error":"#VALUE!"}},{"$f":"M33*$I33","v":{"$error":"#VALUE!"}},{"$f":"podbor($I$32:$I$34,$J32-2000)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,3,258.42814614343706,null,{"$f":"podbor($I$32:$I$34,$J32)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"podbor($I$32:$I$34,$J32+2000)","v":{"$error":"#VALUE!"}},{"$f":"M34*$I34","v":{"$error":"#VALUE!"}},{"$f":"podbor($I$32:$I$34,$J32-2000)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,1,805.43169014084503,41212.419354838712,{"$f":"podbor($I$35:$I$38,$J35)","v":24},19330.36056338028,{"$f":"podbor($I$35:$I$38,$J35+2000)","v":18},{"$f":"M35*$I35","v":14497.77042253521},{"$f":"podbor($I$35:$I$38,$J35-2000)","v":13},10470.611971830986]
[null,null,null,null,null,null,null,2,774.82935323383083,null,{"$f":"podbor($I$35:$I$38,$J35)","v":24},18595.904477611941,{"$f":"podbor($I$35:$I$38,$J35+2000)","v":18},{"$f":"M36*$I36","v":13946.928358208956},{"$f":"podbor($I$35:$I$38,$J35-2000)","v":13},10072.781592039801]
[null,null,null,null,null,null,null,3,923.08951612903218,null,{"$f":"podbor($I$35:$I$38,$J35)","v":24},22154.148387096771,{"$f":"podbor($I$35:$I$38,$J35+2000)","v":18},{"$f":"M37*$I37","v":16615.61129032258},{"$f":"podbor($I$35:$I$38,$J35-2000)","v":13},12000.163709677418]
[null,null,null,null,null,null,null,4,242.44473684210524,null,{"$f":"podbor($I$35:$I$38,$J35)","v":24},5818.6736842105256,{"$f":"podbor($I$35:$I$38,$J35+2000)","v":18},{"$f":"M38*$I38","v":4364.0052631578947},{"$f":"podbor($I$35:$I$38,$J35-2000)","v":13},3151.781578947368]
[null,null,null,null,null,null,null,17,53.554030874785589,1285.9667096774194]
[null,null,null,null,null,null,null,18,53.682608695652171]
[null,null,null,null,null,null,null,19,0]
[null,null,null,null,null,null,null,1,863.07614942528733,49008.386580645158]
[null,null,null,null,null,null,null,2,280.57579831932776]
[null,null,null,null,null,null,null,3,861.20227272727266]
[null,null,null,null,null,null,null,4,875.67137809187284]
[null,null,null,null,null,null,null,5,279.94228187919464]
[null,null,null,null,null,null,null,6,914.10932754880696]
[null,null,null,null,null,null,null,1,0,10815.741935483871]
[null,null,null,null,null,null,null,2,222.26202020202021]
[null,null,null,null,null,null,null,3,217.96062992125985]
[null,null,null,null,null,null,null,4,223.89785202863962]
[null,null,null,null,null,null,null,5,234.85524691358026]
[null,null,null,null,null,null,null,1,243.32692307692307,72016.967741935485]
[null,null,null,null,null,null,null,2,818.5902872777018]
[null,null,null,null,null,null,null,3,784.5832196452933]
[null,null,null,null,null,null,null,4,244.05714285714288]
[null,null,null,null,null,null,null,5,705.15880758807589]
[null,null,null,null,null,null,null,6,706.27620967741939]
[null,null,null,null,null,null,null,1,815.52931034482765,51757.161290322583]
[null,null,null,null,null,null,null,2,705.8092558983667]
[null,null,null,null,null,null,null,3,772.47275132275138]
[null,null,null,null,null,null,null,4,807.1820163487738]
[null,null,null,null,null,null,null,2,0,46536.451612903227]
[null,null,null,null,null,null,null,3,769.05463258785949]
[null,null,null,null,null,null,null,4,725.52112676056333]
[null,null,null,null,null,null,null,5,530.45462012320331]
[null,null,null,null,null,null,null,6,728.50174731182801]
[null,null,null,null,null,null,null,7,457.92230215827334]
[null,null,null,null,null,null,null,8,244.54322033898305]
[null,null,null,null,null,null,null,5,482.63155258764607,44970.820430105487]
[null,null,null,null,null,null,null,6,0]
[null,null,null,null,null,null,null,7,235.58240000000001]
[null,null,null,null,null,null,null,8,742.29069767441865]
[null,null,null,null,null,null,null,9,0]
[null,null,null,null,null,null,null,10,582.94153846153847]
[null,null,null,null,null,null,null,11,745.06436781609193]
[null,null,null,null,null,null,null,12,727.63181148748163]
[null,null,null,null,null,null,null,4,901.60927419354846,63428.193548387098]
[null,null,null,null,null,null,null,5,853.05172413793105]
[null,null,null,null,null,null,null,6,927.11436170212767]
[null,null,null,null,null,null,null,7,774.48161993769475]
[null,null,null,null,null,null,null,8,893.21150684931513]
[null,null,null,null,null,null,null,9,891.98273504273504]
[null,null,null,null,null,null,null,1,640.77044145873322,56984.06451612903]
[null,null,null,null,null,null,null,2,742.19941089838005]
[null,null,null,null,null,null,null,3,631.18165137614676]
[null,null,null,null,null,null,null,4,731.79914893617024]
[null,null,null,null,null,null,null,1,811.54067547723923,45093.838709677417]
[null,null,null,null,null,null,null,2,767.44515306122446]
[null,null,null,null,null,null,null,3,688.9145669291338]
[null,null,null,null,null,null,null,4,731.53861386138612]
[null,null,null,null,null,null,null,1,809.94203187251003,41769.004558064516]
[null,null,null,null,null,null,null,2,771.34783333333337]
[null,null,null,null,null,null,null,3,699.48552631578957]
[null,null,null,null,null,null,null,4,656.74507042253526]
[null,null,null,null,null,null,null,5,277.78827586206899]
[null,null,null,null,null,null,null,6,188.27788461538464]
[null,null,null,null,null,null,null,1,962.30451127819549,31528.677419354837]
[null,null,null,null,null,null,null,2,670.39820554649259]
[null,null,null,null,null,null,null,3,711.24974446337308]
[null,null,null,null,null,null,null,4,272.0090909090909]
[null,null,null,null,null,null,null,5,780.18132911392399,48181.481093548391]
[null,null,null,null,null,null,null,6,747.23153153153157]
[null,null,null,null,null,null,null,7,711.77727272727282]
[null,null,null,null,null,null,null,8,672.06759581881533]
[null,null,null,null,null,null,null,9,243.69288888888889]
[null,null,null,null,null,null,null,10,177.32111111111109]
[null,null,null,null,null,null,null,1,756.67591240875913,62245.322580645159]
[null,null,null,null,null,null,null,2,996.90753424657532]
[null,null,null,null,null,null,null,3,1072.6481132075471]
[null,null,null,null,null,null,null,4,1086.4851955307263]
[null,null,null,null,null,null,null,5,1035.9180107526881]
[null,null,null,null,null,null,null,6,0]
[null,null,null,null,null,null,null,7,351.6630165289256]
[null,null,null,null,null,null,null,8,0]
[null,null,null,null,null,null,null,1,200.46680672268906,88718.145022580647]
[null,null,null,null,null,null,null,2,257.90269709543571]
[null,null,null,null,null,null,null,3,244.44049999999999]
[null,null,null,null,null,null,null,4,256.125]
[null,null,null,null,null,null,null,5,238.6735144312394]
[null,null,null,null,null,null,null,6,246.23410301953817]
[null,null,null,null,null,null,null,7,192.41775956284152]
[null,null,null,null,null,null,null,8,259.90221914008322]
[null,null,null,null,null,null,null,9,818.35793010752695]
[null,null,null,null,null,null,null,10,824.76626344086014]
[null,null,null,null,null,null,null,11,627.05219780219784]
[null,null,null,null,null,null,null,5,256.85807407407407,12212.41935483871]
[null,null,null,null,null,null,null,6,240.45217391304348]
[null,null,null,null,null,null,null,7,254.30053981106613]
[null,null,null,null,null,null,null,8,177.9]
[null,null,null,null,null,null,null,1,766.83260869565208,67567.612903225803]
[null,null,null,null,null,null,null,2,249.0532154340836]
[null,null,null,null,null,null,null,3,705.71209213051827]
[null,null,null,null,null,null,null,4,245.8784810126582]
[null,null,null,null,null,null,null,5,806.54352000000006]
[null,null,null,null,null,null,null,6,789.92487309644673]
[null,null,null,null,null,null,null,7,0]
[null,null,null,null,null,null,null,8,792.14630769230769]
[null,null,null,null,null,null,null,1,773.37608695652182,50959.838712903198]
[null,null,null,null,null,null,null,2,768.53283983849258]
[null,null,null,null,null,null,null,3,763.58209169054453]
[null,null,null,null,null,null,null,4,278.75181695827729]
[null,null,null,null,null,null,null,5,319.26972602739727]
[null,null,null,null,null,null,null,6,0]
[null,null,null,null,null,null,null,1,681.27623188405789,36763.838709677417]
[null,null,null,null,null,null,null,2,802.82005012531329]
[null,null,null,null,null,null,null,3,0]
[null,null,null,null,null,null,null,4,0]
[null,null,null,null,null,null,null,5,785.36760752688167]
[null,null,null,null,null,null,null,1,0,5733.4337159011002]
[null,null,null,null,null,null,null,4,0]
[null,null,null,null,null,null,null,1,518.88371777476254,50829.258064516129]
[null,null,null,null,null,null,null,2,557.51222570532912]
[null,null,null,null,null,null,null,3,553.4370422535211]
[null,null,null,null,null,null,null,4,553.94991482112437]
[null,null,null,null,null,null,null,5,535.82017937219723]
[null,null,null,null,null,null,null,5,742.78020833333335,38722.516129032258]
[null,null,null,null,null,null,null,6,817.29127906976748]
[null,null,null,null,null,null,null,7,849.11603773584909]
[null,null,null,null,null,null,null,8,810.7604]
[null,null,null,null,null,null,null,1,766.53366834170856,41261.677419354841]
[null,null,null,null,null,null,null,2,815.73099824868655]
[null,null,null,null,null,null,null,3,825.96707818930042]
[null,null,null,null,null,null,null,4,811.42751322751326]
[null,null,null,null,null,null,null,1,272.15045871559636,19294.354838709678]
[null,null,null,null,null,null,null,2,265.95835579514824]
[null,null,null,null,null,null,null,3,270.44176870748299]
[null,null,null,null,null,null,null,4,263.77120253164554]
[null,null,null,null,null,null,null,1,247.59940476190474,12465.806451612903]
[null,null,null,null,null,null,null,2,207.80582959641254]
[null,null,null,null,null,null,null,3,258.35537790697674]
[null,null,null,null,null,null,null,4,204.99559228650136]
[null,null,null,null,null,null,null,1,41.034374999999997,985.61290322580646]
[null,null,null,null,null,null,null,2,0]
[null,null,null,null,null,null,null,3,41.130780559646539]
[null,null,null,null,null,null,null,1,0,5371.9354838709678]
[null,null,null,null,null,null,null,2,0]
[null,null,null,null,null,null,null,3,224.73684210526315]
[null,null,null,null,null,null,null,1,0,6748.5483870967746]
[null,null,null,null,null,null,null,2,286.2419014084507]
[null,null,null,null,null,null,null,3,281.12593406593408]
[null,null,null,null,null,null,null,1,225.33611859838274,10577.741935483871]
[null,null,null,null,null,null,null,2,220.29917081260365]
[null,null,null,null,null,null,null,4,197.66099290780141]

{"sheet":"Лист2","index":1,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Нужно",38715.4,"Искомая сумма",null,null,null,"Нужно",22053.599999999999,null,"Нужно",{"$f":"H1+2000","v":24053.599999999999},null,"Нужно",{"$f":"H1-2000","v":20053.599999999999}]
["Кол-во не более",3,"Кол-во различных слагаемых",null,null,null,"Кол-во не более",2,null,"Кол-во не более",2,null,"Кол-во не более",2]
["Точность",1,"Кол-во знаков после запятой",null,null,null,"Точность",1,null,"Точность",1,null,"Точность",1]
[]
["Элементы","Кол-во",null,null,null,null,"Элементы","Кол-во",null,"Элементы","Кол-во",null,"Элементы","Кол-во"]
[736.5,{"$f":"myPodbor(A6:A15,B1,B2,B3)","v":4},null,null,null,null,287.5,{"$f":"myPodbor(G6:G15,H1,H2,H3)","v":28},null,287.5,{"$f":"myPodbor(J6:J15,K1,K2,K3)","v":64},null,287.5,{"$f":"myPodbor(M6:M15,N1,N2,N3)","v":0}]
[747.7,22,null,null,null,null,269.3,52,null,269.3,21,null,269.3,52]
[193.2,100,null,null,null,null,201.7,0,null,201.7,0,null,201.7,30]
[256.5,0,null,null,null,null,759.9,0,null,759.9,0,null,759.9,0]
[774.1,0,null,null,null,null,null,0,null,null,0,null,null,0]
[null,0,null,null,null,null,null,0,null,null,0,null,null,0]
[null,0,null,null,null,null,null,0,null,null,0,null,null,0]
[null,0,null,null,null,null,null,0,null,null,0,null,null,0]
[null,0,null,null,null,null,null,0,null,null,0,null,null,0]
[null,0,null,null,null,null,null,0,null,null,0,null,null,0]
["Сумма",{"$f":"SUMPRODUCT(B6:B15,A6:A15)","v":38715.4},null,null,null,null,"Сумма",{"$f":"SUMPRODUCT(H6:H15,G6:G15)","v":22053.599999999999},null,"Сумма",{"$f":"SUMPRODUCT(K6:K15,J6:J15)","v":24055.3},null,"Сумма",{"$f":"SUMPRODUCT(N6:N15,M6:M15)","v":20054.599999999999}]
["Откл. абс.",{"$f":"B16-B1","v":0},null,null,null,null,"Откл. абс.",{"$f":"H16-H1","v":0},null,"Откл. абс.",{"$f":"K16-K1","v":1.7000000000007276},null,"Откл. абс.",{"$f":"N16-N1","v":1}]
["Откл. отн.",{"$f":"B17/B1","v":0},null,null,null,null,"Откл. отн.",{"$f":"H17/H1","v":0},null,"Откл. отн.",{"$f":"K17/K1","v":7.0675491402564592E-5},null,"Откл. отн.",{"$f":"N17/N1","v":4.9866358160130853E-5}]