{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Исходные данные"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":1,"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":"Исходные данные","index":0,"n_rows":93,"n_cols":19,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
[null,"Детали",null,null,null,"Заготовки",null,null,null,null,null,null,null,null,"Варианты схем"]
[null,"Ниаменование","Размер","Кол-во",null,"Ниаменование","Размер","Кол-во","Кромка мин","Кромка макс","Схем","Выборка",null,null,"Схема","Слагаемые","Сумма","Размер","Кромка"]
[null,null,{"$f":"SUMPRODUCT(C4:C93,D4:D93,--(E4:E93=\"\"))","v":36950},{"$f":"SUM(D4:D93)","v":360},null,{"$f":"IF(C3>0,SUMPRODUCT(G4:G23-I4:I23,H4:H23)/C3,\"\")","v":0},{"$f":"IF(H3=\"много\",\"много\",SUMPRODUCT(G4:G23,H4:H23))","v":"много"},{"$f":"IF(OR((H4:H23=\"\")+(G4:G23=\"\")=1),\"много\",SUM(H4:H23))","v":"много"},null,null,{"$f":"SUM(K4:K23)","v":0},"мин","макс"]
[{"$f":"IF(N(C4)>0,MAX(A$3:A3)+1,\"\")","v":1},null,165,10,null,null,420,null,0,60,{"$f":"COUNTIF(R:R,G4)","v":0}]
[{"$f":"IF(N(C5)>0,MAX(A$3:A4)+1,\"\")","v":2},null,160,20,null,null,null,null,null,null,0]
[{"$f":"IF(N(C6)>0,MAX(A$3:A5)+1,\"\")","v":3},null,135,30.000000000000007,null,null,null,null,null,null,0]
[{"$f":"IF(N(C7)>0,MAX(A$3:A6)+1,\"\")","v":4},null,125,40,null,null,null,null,null,null,0]
[{"$f":"IF(N(C8)>0,MAX(A$3:A7)+1,\"\")","v":5},null,110,49.999999999999986,null,null,null,null,null,null,0]
[{"$f":"IF(N(C9)>0,MAX(A$3:A8)+1,\"\")","v":6},null,100,60,null,null,null,null,null,null,0]
[{"$f":"IF(N(C10)>0,MAX(A$3:A9)+1,\"\")","v":7},null,85,69.999999999999972,null,null,null,null,null,null,0]
[{"$f":"IF(N(C11)>0,MAX(A$3:A10)+1,\"\")","v":8},null,70,80,null,null,null,null,null,null,0]
[{"$f":"IF(N(C12)>0,MAX(A$3:A11)+1,\"\")","v":""},null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(N(C13)>0,MAX(A$3:A12)+1,\"\")","v":""},null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(N(C14)>0,MAX(A$3:A13)+1,\"\")","v":""},null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(N(C15)>0,MAX(A$3:A14)+1,\"\")","v":""},null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(N(C16)>0,MAX(A$3:A15)+1,\"\")","v":""},null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(N(C17)>0,MAX(A$3:A16)+1,\"\")","v":""},null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(N(C18)>0,MAX(A$3:A17)+1,\"\")","v":""},null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(N(C19)>0,MAX(A$3:A18)+1,\"\")","v":""},null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(N(C20)>0,MAX(A$3:A19)+1,\"\")","v":""},null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(N(C21)>0,MAX(A$3:A20)+1,\"\")","v":""},null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(N(C22)>0,MAX(A$3:A21)+1,\"\")","v":""},null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(N(C23)>0,MAX(A$3:A22)+1,\"\")","v":""},null,null,null,null,null,null,null,null,null,0]
[{"$f":"IF(N(C24)>0,MAX(A$3:A23)+1,\"\")","v":""}]
[{"$f":"IF(N(C25)>0,MAX(A$3:A24)+1,\"\")","v":""}]
[{"$f":"IF(N(C26)>0,MAX(A$3:A25)+1,\"\")","v":""}]
[{"$f":"IF(N(C27)>0,MAX(A$3:A26)+1,\"\")","v":""},null,null,null,null,"Минимальная выборка",null,1]
[{"$f":"IF(N(C28)>0,MAX(A$3:A27)+1,\"\")","v":""},null,null,null,null,"Максимальная выборка",null,10]
[{"$f":"IF(N(C29)>0,MAX(A$3:A28)+1,\"\")","v":""},null,null,null,null,"Ширина режущей части",null,0]
[{"$f":"IF(N(C30)>0,MAX(A$3:A29)+1,\"\")","v":""}]
[{"$f":"IF(N(C31)>0,MAX(A$3:A30)+1,\"\")","v":""}]
[{"$f":"IF(N(C32)>0,MAX(A$3:A31)+1,\"\")","v":""}]
[{"$f":"IF(N(C33)>0,MAX(A$3:A32)+1,\"\")","v":""}]
[{"$f":"IF(N(C34)>0,MAX(A$3:A33)+1,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(J35>0,\"Схем:\",\"\")","v":""}]
[{"$f":"IF(N(C35)>0,MAX(A$3:A34)+1,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"COUNT(Q:Q)","v":0}]
[{"$f":"IF(N(C36)>0,MAX(A$3:A35)+1,\"\")","v":""}]
[{"$f":"IF(N(C37)>0,MAX(A$3:A36)+1,\"\")","v":""}]
[{"$f":"IF(N(C38)>0,MAX(A$3:A37)+1,\"\")","v":""}]
[{"$f":"IF(N(C39)>0,MAX(A$3:A38)+1,\"\")","v":""}]
[{"$f":"IF(N(C40)>0,MAX(A$3:A39)+1,\"\")","v":""}]
[{"$f":"IF(N(C41)>0,MAX(A$3:A40)+1,\"\")","v":""}]
[{"$f":"IF(N(C42)>0,MAX(A$3:A41)+1,\"\")","v":""}]
[{"$f":"IF(N(C43)>0,MAX(A$3:A42)+1,\"\")","v":""}]
[{"$f":"IF(N(C44)>0,MAX(A$3:A43)+1,\"\")","v":""}]
[{"$f":"IF(N(C45)>0,MAX(A$3:A44)+1,\"\")","v":""}]
[{"$f":"IF(N(C46)>0,MAX(A$3:A45)+1,\"\")","v":""}]
[{"$f":"IF(N(C47)>0,MAX(A$3:A46)+1,\"\")","v":""}]
[{"$f":"IF(N(C48)>0,MAX(A$3:A47)+1,\"\")","v":""}]
[{"$f":"IF(N(C49)>0,MAX(A$3:A48)+1,\"\")","v":""}]
[{"$f":"IF(N(C50)>0,MAX(A$3:A49)+1,\"\")","v":""}]
[{"$f":"IF(N(C51)>0,MAX(A$3:A50)+1,\"\")","v":""}]
[{"$f":"IF(N(C52)>0,MAX(A$3:A51)+1,\"\")","v":""}]
[{"$f":"IF(N(C53)>0,MAX(A$3:A52)+1,\"\")","v":""}]
[{"$f":"IF(N(C54)>0,MAX(A$3:A53)+1,\"\")","v":""}]
[{"$f":"IF(N(C55)>0,MAX(A$3:A54)+1,\"\")","v":""}]
[{"$f":"IF(N(C56)>0,MAX(A$3:A55)+1,\"\")","v":""}]
[{"$f":"IF(N(C57)>0,MAX(A$3:A56)+1,\"\")","v":""}]
[{"$f":"IF(N(C58)>0,MAX(A$3:A57)+1,\"\")","v":""}]
[{"$f":"IF(N(C59)>0,MAX(A$3:A58)+1,\"\")","v":""}]
[{"$f":"IF(N(C60)>0,MAX(A$3:A59)+1,\"\")","v":""}]
[{"$f":"IF(N(C61)>0,MAX(A$3:A60)+1,\"\")","v":""}]
[{"$f":"IF(N(C62)>0,MAX(A$3:A61)+1,\"\")","v":""}]
[{"$f":"IF(N(C63)>0,MAX(A$3:A62)+1,\"\")","v":""}]
[{"$f":"IF(N(C64)>0,MAX(A$3:A63)+1,\"\")","v":""}]
[{"$f":"IF(N(C65)>0,MAX(A$3:A64)+1,\"\")","v":""}]
[{"$f":"IF(N(C66)>0,MAX(A$3:A65)+1,\"\")","v":""}]
[{"$f":"IF(N(C67)>0,MAX(A$3:A66)+1,\"\")","v":""}]
[{"$f":"IF(N(C68)>0,MAX(A$3:A67)+1,\"\")","v":""}]
[{"$f":"IF(N(C69)>0,MAX(A$3:A68)+1,\"\")","v":""}]
[{"$f":"IF(N(C70)>0,MAX(A$3:A69)+1,\"\")","v":""}]
[{"$f":"IF(N(C71)>0,MAX(A$3:A70)+1,\"\")","v":""}]
[{"$f":"IF(N(C72)>0,MAX(A$3:A71)+1,\"\")","v":""}]
[{"$f":"IF(N(C73)>0,MAX(A$3:A72)+1,\"\")","v":""}]
[{"$f":"IF(N(C74)>0,MAX(A$3:A73)+1,\"\")","v":""}]
[{"$f":"IF(N(C75)>0,MAX(A$3:A74)+1,\"\")","v":""}]
[{"$f":"IF(N(C76)>0,MAX(A$3:A75)+1,\"\")","v":""}]
[{"$f":"IF(N(C77)>0,MAX(A$3:A76)+1,\"\")","v":""}]
[{"$f":"IF(N(C78)>0,MAX(A$3:A77)+1,\"\")","v":""}]
[{"$f":"IF(N(C79)>0,MAX(A$3:A78)+1,\"\")","v":""}]
[{"$f":"IF(N(C80)>0,MAX(A$3:A79)+1,\"\")","v":""}]
[{"$f":"IF(N(C81)>0,MAX(A$3:A80)+1,\"\")","v":""}]
[{"$f":"IF(N(C82)>0,MAX(A$3:A81)+1,\"\")","v":""}]
[{"$f":"IF(N(C83)>0,MAX(A$3:A82)+1,\"\")","v":""}]
[{"$f":"IF(N(C84)>0,MAX(A$3:A83)+1,\"\")","v":""}]
[{"$f":"IF(N(C85)>0,MAX(A$3:A84)+1,\"\")","v":""}]
[{"$f":"IF(N(C86)>0,MAX(A$3:A85)+1,\"\")","v":""}]
[{"$f":"IF(N(C87)>0,MAX(A$3:A86)+1,\"\")","v":""}]
[{"$f":"IF(N(C88)>0,MAX(A$3:A87)+1,\"\")","v":""}]
[{"$f":"IF(N(C89)>0,MAX(A$3:A88)+1,\"\")","v":""}]
[{"$f":"IF(N(C90)>0,MAX(A$3:A89)+1,\"\")","v":""}]
[{"$f":"IF(N(C91)>0,MAX(A$3:A90)+1,\"\")","v":""}]
[{"$f":"IF(N(C92)>0,MAX(A$3:A91)+1,\"\")","v":""}]
[{"$f":"IF(N(C93)>0,MAX(A$3:A92)+1,\"\")","v":""}]