{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"ИСХОДНИК",null,null,null,null,"КАК ДОЛЖЕН ВЫГЛЯДЕТЬ РЕЗУЛЬТАТ",null,null,null,null,null,"ВРУЧНУЮ ПОСЧИТАННОЕ КОЛИЧЕСТВО"]
[]
["Место","Кол-во","Общее количество","Уровень группировки","доп.",null,"Место","Кол-во","Общее количество"]
["СКЛАД 1",1,{"$f":"SUMIF($A$4:$A$21,A4,$E$4:$E$21)","v":1},{"$f":"Уровень(A4)","v":1},{"$f":"IF(D4=1,1,IF(D4=2,INDEX(H:H,MAX(($D$1:D3=1)*ROW($1:3))),INDEX(H:H,MAX(($D$1:D3=2)*ROW($1:3)))*INDEX(H:H,MAX(($D$1:D3=1)*ROW($1:3)))))*H4","v":1},null,"СКЛАД 1",1,{"$f":"IFERROR(VLOOKUP(G4,M$4:N$11,2,FALSE),\"N/A\")","v":1},null,null,null,"ВИНТ М3",{"$f":"(B6*B$5+B10*B$9)*B$4+(B15*B$14+B19*B$18)*B$13","v":93}]
["ПОЛКА ТИП 1",2,{"$f":"SUMIF($A$4:$A$21,A5,$E$4:$E$21)","v":4},{"$f":"Уровень(A5)","v":2},{"$f":"IF(D5=1,1,IF(D5=2,INDEX(H:H,MAX(($D$1:D4=1)*ROW($1:4))),INDEX(H:H,MAX(($D$1:D4=2)*ROW($1:4)))*INDEX(H:H,MAX(($D$1:D4=1)*ROW($1:4)))))*H5","v":2},null,"ПОЛКА ТИП 1",2,4,null,null,null,"ВИНТ М4",{"$f":"(B7*B$5+B11*B$9)*B$4+(B16*B$14+B20*B$18)*B$13","v":27}]
["ВИНТ М3",5,93,3,{"$f":"IF(D6=1,1,IF(D6=2,INDEX(H:H,MAX(($D$1:D5=1)*ROW($1:5))),INDEX(H:H,MAX(($D$1:D5=2)*ROW($1:5)))*INDEX(H:H,MAX(($D$1:D5=1)*ROW($1:5)))))*H6","v":10},null,"ВИНТ М3",5,93,null,null,null,"ГАЙКА М6",{"$f":"(B8*B$5+B12*B$9)*B$4+(B17*B$14+B21*B$18)*B$13","v":118}]
["ВИНТ М4",7,27,3,{"$f":"IF(D7=1,1,IF(D7=2,INDEX(H:H,MAX(($D$1:D6=1)*ROW($1:6))),INDEX(H:H,MAX(($D$1:D6=2)*ROW($1:6)))*INDEX(H:H,MAX(($D$1:D6=1)*ROW($1:6)))))*H7","v":14},null,"ВИНТ М4",7,27,null,null,null,"ПОЛКА ТИП 1",{"$f":"B5*B$4+B14*B$13","v":4}]
["ГАЙКА М6",3,118,3,{"$f":"IF(D8=1,1,IF(D8=2,INDEX(H:H,MAX(($D$1:D7=1)*ROW($1:7))),INDEX(H:H,MAX(($D$1:D7=2)*ROW($1:7)))*INDEX(H:H,MAX(($D$1:D7=1)*ROW($1:7)))))*H8","v":6},null,"ГАЙКА М6",3,118,null,null,null,"ПОЛКА ТИП 2",{"$f":"B9*B$4","v":3}]
["ПОЛКА ТИП 2",3,3,2,{"$f":"IF(D9=1,1,IF(D9=2,INDEX(H:H,MAX(($D$1:D8=1)*ROW($1:8))),INDEX(H:H,MAX(($D$1:D8=2)*ROW($1:8)))*INDEX(H:H,MAX(($D$1:D8=1)*ROW($1:8)))))*H9","v":3},null,"ПОЛКА ТИП 2",3,3,null,null,null,"ПОЛКА ТИП 3",{"$f":"B18*B13","v":6}]
["ВИНТ М3",9,93,3,{"$f":"IF(D10=1,1,IF(D10=2,INDEX(H:H,MAX(($D$1:D9=1)*ROW($1:9))),INDEX(H:H,MAX(($D$1:D9=2)*ROW($1:9)))*INDEX(H:H,MAX(($D$1:D9=1)*ROW($1:9)))))*H10","v":27},null,"ВИНТ М3",9,93,null,null,null,"СКЛАД 1",1]
["ВИНТ М4",1,27,3,{"$f":"IF(D11=1,1,IF(D11=2,INDEX(H:H,MAX(($D$1:D10=1)*ROW($1:10))),INDEX(H:H,MAX(($D$1:D10=2)*ROW($1:10)))*INDEX(H:H,MAX(($D$1:D10=1)*ROW($1:10)))))*H11","v":3},null,"ВИНТ М4",1,27,null,null,null,"СКЛАД 2",2]
["ГАЙКА М6",12,118,3,{"$f":"IF(D12=1,1,IF(D12=2,INDEX(H:H,MAX(($D$1:D11=1)*ROW($1:11))),INDEX(H:H,MAX(($D$1:D11=2)*ROW($1:11)))*INDEX(H:H,MAX(($D$1:D11=1)*ROW($1:11)))))*H12","v":36},null,"ГАЙКА М6",12,118]
["СКЛАД 2",2,2,1,{"$f":"IF(D13=1,1,IF(D13=2,INDEX(H:H,MAX(($D$1:D12=1)*ROW($1:12))),INDEX(H:H,MAX(($D$1:D12=2)*ROW($1:12)))*INDEX(H:H,MAX(($D$1:D12=1)*ROW($1:12)))))*H13","v":2},null,"СКЛАД 2",2,2]
["ПОЛКА ТИП 1",1,4,2,{"$f":"IF(D14=1,1,IF(D14=2,INDEX(H:H,MAX(($D$1:D13=1)*ROW($1:13))),INDEX(H:H,MAX(($D$1:D13=2)*ROW($1:13)))*INDEX(H:H,MAX(($D$1:D13=1)*ROW($1:13)))))*H14","v":2},null,"ПОЛКА ТИП 1",1,4]
["ВИНТ М3",1,93,3,{"$f":"IF(D15=1,1,IF(D15=2,INDEX(H:H,MAX(($D$1:D14=1)*ROW($1:14))),INDEX(H:H,MAX(($D$1:D14=2)*ROW($1:14)))*INDEX(H:H,MAX(($D$1:D14=1)*ROW($1:14)))))*H15","v":2},null,"ВИНТ М3",1,93]
["ВИНТ М4",2,27,3,{"$f":"IF(D16=1,1,IF(D16=2,INDEX(H:H,MAX(($D$1:D15=1)*ROW($1:15))),INDEX(H:H,MAX(($D$1:D15=2)*ROW($1:15)))*INDEX(H:H,MAX(($D$1:D15=1)*ROW($1:15)))))*H16","v":4},null,"ВИНТ М4",2,27]
["ГАЙКА М6",2,118,3,{"$f":"IF(D17=1,1,IF(D17=2,INDEX(H:H,MAX(($D$1:D16=1)*ROW($1:16))),INDEX(H:H,MAX(($D$1:D16=2)*ROW($1:16)))*INDEX(H:H,MAX(($D$1:D16=1)*ROW($1:16)))))*H17","v":4},null,"ГАЙКА М6",2,118]
["ПОЛКА ТИП 3",3,6,2,{"$f":"IF(D18=1,1,IF(D18=2,INDEX(H:H,MAX(($D$1:D17=1)*ROW($1:17))),INDEX(H:H,MAX(($D$1:D17=2)*ROW($1:17)))*INDEX(H:H,MAX(($D$1:D17=1)*ROW($1:17)))))*H18","v":6},null,"ПОЛКА ТИП 3",3,6]
["ВИНТ М3",9,93,3,{"$f":"IF(D19=1,1,IF(D19=2,INDEX(H:H,MAX(($D$1:D18=1)*ROW($1:18))),INDEX(H:H,MAX(($D$1:D18=2)*ROW($1:18)))*INDEX(H:H,MAX(($D$1:D18=1)*ROW($1:18)))))*H19","v":54},null,"ВИНТ М3",9,93]
["ВИНТ М4",1,27,3,{"$f":"IF(D20=1,1,IF(D20=2,INDEX(H:H,MAX(($D$1:D19=1)*ROW($1:19))),INDEX(H:H,MAX(($D$1:D19=2)*ROW($1:19)))*INDEX(H:H,MAX(($D$1:D19=1)*ROW($1:19)))))*H20","v":6},null,"ВИНТ М4",1,27]
["ГАЙКА М6",12,118,3,{"$f":"IF(D21=1,1,IF(D21=2,INDEX(H:H,MAX(($D$1:D20=1)*ROW($1:20))),INDEX(H:H,MAX(($D$1:D20=2)*ROW($1:20)))*INDEX(H:H,MAX(($D$1:D20=1)*ROW($1:20)))))*H21","v":72},null,"ГАЙКА М6",12,118]