{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Раскрой","Раскрой (2)"],"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":"Раскрой","index":0,"n_rows":115,"n_cols":15,"rows_kept":115,"cut":false,"hidden":false,"merged":[]}
[null,"Есть",null,null,null,null,null,"Осталось",null,null,"Решение",null,null,null,{"$f":"O3/(L3+O3)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"B24","v":"№"},"Размер","Кол-во","Использовано","Не использов.",null,"Размер","Кол-во",null,"Размер","Расход","Кол-во исп.\nзаготовок","Раскрой",{"$f":"\"Отходы\"&IF((L3+O3)>0,TEXT(O3/(L3+O3),\"0,00%\"),\"\")","v":"Отходы"}]
[null,null,{"$f":"IF(COUNT(C4:C13)=COUNT(D4:D13),SUMPRODUCT(C4:C13,D4:D13),)","v":0},{"$f":"IF(COUNT(C4:C13)=COUNT(D4:D13),SUM(D4:D13),\"много\")","v":0},{"$f":"SUM(E4:E13)","v":0},{"$f":"IF(D3=\"много\",\"много\",D3-E3)","v":0},null,{"$f":"SUMPRODUCT(H4:H13,I4:I13)","v":0},{"$f":"IF(COUNT(H4:H13)=COUNT(I4:I13),SUM(I4:I13),\"много\")","v":0},null,{"$f":"SUMPRODUCT(K4:K1060,$M4:$M1060)","v":0},{"$f":"SUMPRODUCT(L4:L1060,$M4:$M1060)","v":0},{"$f":"SUM(M4:M1060)","v":0},null,{"$f":"SUM(IF((O4:O1060<D17)+(D17=0),$M4:$M1060*O4:O1060))","v":0}]
[null,{"$f":"IF(N(C4)=0,\"\",1)","v":""},null,null,{"$f":"MIN(SUMIF(K$4:K$1060,C4,M$4:M$1060),D4)","v":0},{"$f":"IF(D4,D4-E4,)","v":0}]
[null,{"$f":"IF(N(C5)=0,\"\",IF(ISNUMBER(MATCH(C5,C$4:C4,)),INDEX(B$4:B4,MATCH(C5,C$4:C4,)),MAX(B$4:B4)+1))","v":""},null,null,0,{"$f":"IF(D5,D5-E5,)","v":0}]
[null,{"$f":"IF(N(C6)=0,\"\",IF(ISNUMBER(MATCH(C6,C$4:C5,)),INDEX(B$4:B5,MATCH(C6,C$4:C5,)),MAX(B$4:B5)+1))","v":""},null,null,0,{"$f":"IF(D6,D6-E6,)","v":0}]
[null,{"$f":"IF(N(C7)=0,\"\",IF(ISNUMBER(MATCH(C7,C$4:C6,)),INDEX(B$4:B6,MATCH(C7,C$4:C6,)),MAX(B$4:B6)+1))","v":""},null,null,0,0]
[null,{"$f":"IF(N(C8)=0,\"\",IF(ISNUMBER(MATCH(C8,C$4:C7,)),INDEX(B$4:B7,MATCH(C8,C$4:C7,)),MAX(B$4:B7)+1))","v":""},null,null,0,0]
[null,{"$f":"IF(N(C9)=0,\"\",IF(ISNUMBER(MATCH(C9,C$4:C8,)),INDEX(B$4:B8,MATCH(C9,C$4:C8,)),MAX(B$4:B8)+1))","v":""},null,null,0,0]
[null,{"$f":"IF(N(C10)=0,\"\",IF(ISNUMBER(MATCH(C10,C$4:C9,)),INDEX(B$4:B9,MATCH(C10,C$4:C9,)),MAX(B$4:B9)+1))","v":""},null,null,0,0]
[null,{"$f":"IF(N(C11)=0,\"\",IF(ISNUMBER(MATCH(C11,C$4:C10,)),INDEX(B$4:B10,MATCH(C11,C$4:C10,)),MAX(B$4:B10)+1))","v":""},null,null,0,0]
[null,{"$f":"IF(N(C12)=0,\"\",IF(ISNUMBER(MATCH(C12,C$4:C11,)),INDEX(B$4:B11,MATCH(C12,C$4:C11,)),MAX(B$4:B11)+1))","v":""},null,null,0,{"$f":"IF(D12,D12-E12,)","v":0}]
[null,{"$f":"IF(N(C13)=0,\"\",IF(ISNUMBER(MATCH(C13,C$4:C12,)),INDEX(B$4:B12,MATCH(C13,C$4:C12,)),MAX(B$4:B12)+1))","v":""},null,null,0,{"$f":"IF(D13,D13-E13,)","v":0}]
[]
[null,"Ширина реза",null,null,true,null,"Быстро",3]
[null,"Кромка",null,null,true,null,"Нормально",1]
[null,"Деловой остат.",null,1000,false,false,"Медленно"]
[null,null,null,null,null,null,"Очень медленно"]
[]
[]
[]
[]
[null,"Нужно",null,null,null,null,null,"Не сделано"]
[null,"№","Размер","Кол-во","Разложено","Не разложено",null,"Размер","Кол-во"]
[null,null,{"$f":"IF(D25=\"много\",\"много\",SUMPRODUCT(C26:C115,D26:D115))","v":0},{"$f":"IF(OR((D26:D115=\"\")+(C26:C115=\"\")=1),\"много\",SUM(D26:D115))","v":0},{"$f":"SUM(E26:E115)","v":0},{"$f":"IF(D25=\"много\",\"много\",SUM(F26:F115))","v":0},null,{"$f":"SUMPRODUCT(H26:H115,I26:I115)","v":0},{"$f":"SUM(I26:I115)","v":0}]
[2,{"$f":"IF(N(C26)=0,\"\",1)","v":""},null,null,{"$f":"IF($K$3=0,0,IF(ISNA(VLOOKUP(C26,H$26:I$115,2,))*C26,D26,IF(C26=\"\",\"\",IF(D26=\"\",TRUNC($C$3/C26)-VLOOKUP(C26,H$26:I$115,2,),D26-VLOOKUP(C26,H$26:I$115,2,)))))","v":0},{"$f":"IF($K$3=0,\"\",IF(AND(C26<>\"\",D26<>\"\"),D26-E26,IF(D26=\"\",\"\",TRUNC($C$3/C26)-VLOOKUP(C26,H$26:I$115,2,))))","v":""}]
[3,{"$f":"IF(N(C27)=0,\"\",IF(ISNUMBER(MATCH(C27,C$26:C26,)),INDEX(B$26:B26,MATCH(C27,C$26:C26,)),MAX(B$26:B26)+1))","v":""},null,null,0,""]
[4,{"$f":"IF(N(C28)=0,\"\",IF(ISNUMBER(MATCH(C28,C$26:C27,)),INDEX(B$26:B27,MATCH(C28,C$26:C27,)),MAX(B$26:B27)+1))","v":""},null,null,0,""]
[5,{"$f":"IF(N(C29)=0,\"\",IF(ISNUMBER(MATCH(C29,C$26:C28,)),INDEX(B$26:B28,MATCH(C29,C$26:C28,)),MAX(B$26:B28)+1))","v":""},null,null,0,""]
[6,{"$f":"IF(N(C30)=0,\"\",IF(ISNUMBER(MATCH(C30,C$26:C29,)),INDEX(B$26:B29,MATCH(C30,C$26:C29,)),MAX(B$26:B29)+1))","v":""},null,null,0,""]
[7,{"$f":"IF(N(C31)=0,\"\",IF(ISNUMBER(MATCH(C31,C$26:C30,)),INDEX(B$26:B30,MATCH(C31,C$26:C30,)),MAX(B$26:B30)+1))","v":""},null,null,0,""]
[8,{"$f":"IF(N(C32)=0,\"\",IF(ISNUMBER(MATCH(C32,C$26:C31,)),INDEX(B$26:B31,MATCH(C32,C$26:C31,)),MAX(B$26:B31)+1))","v":""},null,null,0,""]
[16,{"$f":"IF(N(C33)=0,\"\",IF(ISNUMBER(MATCH(C33,C$26:C32,)),INDEX(B$26:B32,MATCH(C33,C$26:C32,)),MAX(B$26:B32)+1))","v":""},null,null,0,""]
[17,{"$f":"IF(N(C34)=0,\"\",IF(ISNUMBER(MATCH(C34,C$26:C33,)),INDEX(B$26:B33,MATCH(C34,C$26:C33,)),MAX(B$26:B33)+1))","v":""},null,null,0,""]
[18,{"$f":"IF(N(C35)=0,\"\",IF(ISNUMBER(MATCH(C35,C$26:C34,)),INDEX(B$26:B34,MATCH(C35,C$26:C34,)),MAX(B$26:B34)+1))","v":""},null,null,0,""]
[19,{"$f":"IF(N(C36)=0,\"\",IF(ISNUMBER(MATCH(C36,C$26:C35,)),INDEX(B$26:B35,MATCH(C36,C$26:C35,)),MAX(B$26:B35)+1))","v":""},null,null,0,""]
[20,{"$f":"IF(N(C37)=0,\"\",IF(ISNUMBER(MATCH(C37,C$26:C36,)),INDEX(B$26:B36,MATCH(C37,C$26:C36,)),MAX(B$26:B36)+1))","v":""},null,null,0,""]
[21,{"$f":"IF(N(C38)=0,\"\",IF(ISNUMBER(MATCH(C38,C$26:C37,)),INDEX(B$26:B37,MATCH(C38,C$26:C37,)),MAX(B$26:B37)+1))","v":""},null,null,0,""]
[22,{"$f":"IF(N(C39)=0,\"\",IF(ISNUMBER(MATCH(C39,C$26:C38,)),INDEX(B$26:B38,MATCH(C39,C$26:C38,)),MAX(B$26:B38)+1))","v":""},null,null,0,""]
[23,{"$f":"IF(N(C40)=0,\"\",IF(ISNUMBER(MATCH(C40,C$26:C39,)),INDEX(B$26:B39,MATCH(C40,C$26:C39,)),MAX(B$26:B39)+1))","v":""},null,null,0,""]
[24,{"$f":"IF(N(C41)=0,\"\",IF(ISNUMBER(MATCH(C41,C$26:C40,)),INDEX(B$26:B40,MATCH(C41,C$26:C40,)),MAX(B$26:B40)+1))","v":""},null,null,0,""]
[25,{"$f":"IF(N(C42)=0,\"\",IF(ISNUMBER(MATCH(C42,C$26:C41,)),INDEX(B$26:B41,MATCH(C42,C$26:C41,)),MAX(B$26:B41)+1))","v":""},null,null,0,""]
[26,{"$f":"IF(N(C43)=0,\"\",IF(ISNUMBER(MATCH(C43,C$26:C42,)),INDEX(B$26:B42,MATCH(C43,C$26:C42,)),MAX(B$26:B42)+1))","v":""},null,null,0,""]
[27,{"$f":"IF(N(C44)=0,\"\",IF(ISNUMBER(MATCH(C44,C$26:C43,)),INDEX(B$26:B43,MATCH(C44,C$26:C43,)),MAX(B$26:B43)+1))","v":""},null,null,0,""]
[28,{"$f":"IF(N(C45)=0,\"\",IF(ISNUMBER(MATCH(C45,C$26:C44,)),INDEX(B$26:B44,MATCH(C45,C$26:C44,)),MAX(B$26:B44)+1))","v":""},null,null,0,""]
[29,{"$f":"IF(N(C46)=0,\"\",IF(ISNUMBER(MATCH(C46,C$26:C45,)),INDEX(B$26:B45,MATCH(C46,C$26:C45,)),MAX(B$26:B45)+1))","v":""},null,null,0,""]
[30,{"$f":"IF(N(C47)=0,\"\",IF(ISNUMBER(MATCH(C47,C$26:C46,)),INDEX(B$26:B46,MATCH(C47,C$26:C46,)),MAX(B$26:B46)+1))","v":""},null,null,0,""]
[31,{"$f":"IF(N(C48)=0,\"\",IF(ISNUMBER(MATCH(C48,C$26:C47,)),INDEX(B$26:B47,MATCH(C48,C$26:C47,)),MAX(B$26:B47)+1))","v":""},null,null,0,""]
[32,{"$f":"IF(N(C49)=0,\"\",IF(ISNUMBER(MATCH(C49,C$26:C48,)),INDEX(B$26:B48,MATCH(C49,C$26:C48,)),MAX(B$26:B48)+1))","v":""},null,null,0,""]
[33,{"$f":"IF(N(C50)=0,\"\",IF(ISNUMBER(MATCH(C50,C$26:C49,)),INDEX(B$26:B49,MATCH(C50,C$26:C49,)),MAX(B$26:B49)+1))","v":""},null,null,0,""]
[34,{"$f":"IF(N(C51)=0,\"\",IF(ISNUMBER(MATCH(C51,C$26:C50,)),INDEX(B$26:B50,MATCH(C51,C$26:C50,)),MAX(B$26:B50)+1))","v":""},null,null,0,""]
[35,{"$f":"IF(N(C52)=0,\"\",IF(ISNUMBER(MATCH(C52,C$26:C51,)),INDEX(B$26:B51,MATCH(C52,C$26:C51,)),MAX(B$26:B51)+1))","v":""},null,null,0,""]
[36,{"$f":"IF(N(C53)=0,\"\",IF(ISNUMBER(MATCH(C53,C$26:C52,)),INDEX(B$26:B52,MATCH(C53,C$26:C52,)),MAX(B$26:B52)+1))","v":""},null,null,0,""]
[37,{"$f":"IF(N(C54)=0,\"\",IF(ISNUMBER(MATCH(C54,C$26:C53,)),INDEX(B$26:B53,MATCH(C54,C$26:C53,)),MAX(B$26:B53)+1))","v":""},null,null,0,""]
[38,{"$f":"IF(N(C55)=0,\"\",IF(ISNUMBER(MATCH(C55,C$26:C54,)),INDEX(B$26:B54,MATCH(C55,C$26:C54,)),MAX(B$26:B54)+1))","v":""},null,null,0,""]
[39,{"$f":"IF(N(C56)=0,\"\",IF(ISNUMBER(MATCH(C56,C$26:C55,)),INDEX(B$26:B55,MATCH(C56,C$26:C55,)),MAX(B$26:B55)+1))","v":""},null,null,0,""]
[40,{"$f":"IF(N(C57)=0,\"\",IF(ISNUMBER(MATCH(C57,C$26:C56,)),INDEX(B$26:B56,MATCH(C57,C$26:C56,)),MAX(B$26:B56)+1))","v":""},null,null,0,""]
[41,{"$f":"IF(N(C58)=0,\"\",IF(ISNUMBER(MATCH(C58,C$26:C57,)),INDEX(B$26:B57,MATCH(C58,C$26:C57,)),MAX(B$26:B57)+1))","v":""},null,null,{"$f":"IF($K$3=0,0,IF(ISNA(VLOOKUP(C58,H$26:I$115,2,))*C58,D58,IF(C58=\"\",\"\",IF(D58=\"\",TRUNC($C$3/C58)-VLOOKUP(C58,H$26:I$115,2,),D58-VLOOKUP(C58,H$26:I$115,2,)))))","v":0},{"$f":"IF($K$3=0,\"\",IF(AND(C58<>\"\",D58<>\"\"),D58-E58,IF(D58=\"\",\"\",TRUNC($C$3/C58)-VLOOKUP(C58,H$26:I$115,2,))))","v":""}]
[42,{"$f":"IF(N(C59)=0,\"\",IF(ISNUMBER(MATCH(C59,C$26:C58,)),INDEX(B$26:B58,MATCH(C59,C$26:C58,)),MAX(B$26:B58)+1))","v":""},null,null,0,""]
[43,{"$f":"IF(N(C60)=0,\"\",IF(ISNUMBER(MATCH(C60,C$26:C59,)),INDEX(B$26:B59,MATCH(C60,C$26:C59,)),MAX(B$26:B59)+1))","v":""},null,null,0,""]
[44,{"$f":"IF(N(C61)=0,\"\",IF(ISNUMBER(MATCH(C61,C$26:C60,)),INDEX(B$26:B60,MATCH(C61,C$26:C60,)),MAX(B$26:B60)+1))","v":""},null,null,0,""]
[45,{"$f":"IF(N(C62)=0,\"\",IF(ISNUMBER(MATCH(C62,C$26:C61,)),INDEX(B$26:B61,MATCH(C62,C$26:C61,)),MAX(B$26:B61)+1))","v":""},null,null,0,""]
[46,{"$f":"IF(N(C63)=0,\"\",IF(ISNUMBER(MATCH(C63,C$26:C62,)),INDEX(B$26:B62,MATCH(C63,C$26:C62,)),MAX(B$26:B62)+1))","v":""},null,null,0,""]
[47,{"$f":"IF(N(C64)=0,\"\",IF(ISNUMBER(MATCH(C64,C$26:C63,)),INDEX(B$26:B63,MATCH(C64,C$26:C63,)),MAX(B$26:B63)+1))","v":""},null,null,0,""]
[48,{"$f":"IF(N(C65)=0,\"\",IF(ISNUMBER(MATCH(C65,C$26:C64,)),INDEX(B$26:B64,MATCH(C65,C$26:C64,)),MAX(B$26:B64)+1))","v":""},null,null,0,""]
[49,{"$f":"IF(N(C66)=0,\"\",IF(ISNUMBER(MATCH(C66,C$26:C65,)),INDEX(B$26:B65,MATCH(C66,C$26:C65,)),MAX(B$26:B65)+1))","v":""},null,null,0,""]
[50,{"$f":"IF(N(C67)=0,\"\",IF(ISNUMBER(MATCH(C67,C$26:C66,)),INDEX(B$26:B66,MATCH(C67,C$26:C66,)),MAX(B$26:B66)+1))","v":""},null,null,0,""]
[51,{"$f":"IF(N(C68)=0,\"\",IF(ISNUMBER(MATCH(C68,C$26:C67,)),INDEX(B$26:B67,MATCH(C68,C$26:C67,)),MAX(B$26:B67)+1))","v":""},null,null,0,""]
[52,{"$f":"IF(N(C69)=0,\"\",IF(ISNUMBER(MATCH(C69,C$26:C68,)),INDEX(B$26:B68,MATCH(C69,C$26:C68,)),MAX(B$26:B68)+1))","v":""},null,null,0,""]
[53,{"$f":"IF(N(C70)=0,\"\",IF(ISNUMBER(MATCH(C70,C$26:C69,)),INDEX(B$26:B69,MATCH(C70,C$26:C69,)),MAX(B$26:B69)+1))","v":""},null,null,0,""]
[54,{"$f":"IF(N(C71)=0,\"\",IF(ISNUMBER(MATCH(C71,C$26:C70,)),INDEX(B$26:B70,MATCH(C71,C$26:C70,)),MAX(B$26:B70)+1))","v":""},null,null,0,""]
[55,{"$f":"IF(N(C72)=0,\"\",IF(ISNUMBER(MATCH(C72,C$26:C71,)),INDEX(B$26:B71,MATCH(C72,C$26:C71,)),MAX(B$26:B71)+1))","v":""},null,null,0,""]
[56,{"$f":"IF(N(C73)=0,\"\",IF(ISNUMBER(MATCH(C73,C$26:C72,)),INDEX(B$26:B72,MATCH(C73,C$26:C72,)),MAX(B$26:B72)+1))","v":""},null,null,0,""]
[57,{"$f":"IF(N(C74)=0,\"\",IF(ISNUMBER(MATCH(C74,C$26:C73,)),INDEX(B$26:B73,MATCH(C74,C$26:C73,)),MAX(B$26:B73)+1))","v":""},null,null,0,""]
[58,{"$f":"IF(N(C75)=0,\"\",IF(ISNUMBER(MATCH(C75,C$26:C74,)),INDEX(B$26:B74,MATCH(C75,C$26:C74,)),MAX(B$26:B74)+1))","v":""},null,null,0,""]
[59,{"$f":"IF(N(C76)=0,\"\",IF(ISNUMBER(MATCH(C76,C$26:C75,)),INDEX(B$26:B75,MATCH(C76,C$26:C75,)),MAX(B$26:B75)+1))","v":""},null,null,0,""]
[60,{"$f":"IF(N(C77)=0,\"\",IF(ISNUMBER(MATCH(C77,C$26:C76,)),INDEX(B$26:B76,MATCH(C77,C$26:C76,)),MAX(B$26:B76)+1))","v":""},null,null,0,""]
[61,{"$f":"IF(N(C78)=0,\"\",IF(ISNUMBER(MATCH(C78,C$26:C77,)),INDEX(B$26:B77,MATCH(C78,C$26:C77,)),MAX(B$26:B77)+1))","v":""},null,null,0,""]
[62,{"$f":"IF(N(C79)=0,\"\",IF(ISNUMBER(MATCH(C79,C$26:C78,)),INDEX(B$26:B78,MATCH(C79,C$26:C78,)),MAX(B$26:B78)+1))","v":""},null,null,0,""]
[63,{"$f":"IF(N(C80)=0,\"\",IF(ISNUMBER(MATCH(C80,C$26:C79,)),INDEX(B$26:B79,MATCH(C80,C$26:C79,)),MAX(B$26:B79)+1))","v":""},null,null,0,""]
[64,{"$f":"IF(N(C81)=0,\"\",IF(ISNUMBER(MATCH(C81,C$26:C80,)),INDEX(B$26:B80,MATCH(C81,C$26:C80,)),MAX(B$26:B80)+1))","v":""},null,null,0,""]
[65,{"$f":"IF(N(C82)=0,\"\",IF(ISNUMBER(MATCH(C82,C$26:C81,)),INDEX(B$26:B81,MATCH(C82,C$26:C81,)),MAX(B$26:B81)+1))","v":""},null,null,0,""]
[66,{"$f":"IF(N(C83)=0,\"\",IF(ISNUMBER(MATCH(C83,C$26:C82,)),INDEX(B$26:B82,MATCH(C83,C$26:C82,)),MAX(B$26:B82)+1))","v":""},null,null,0,""]
[67,{"$f":"IF(N(C84)=0,\"\",IF(ISNUMBER(MATCH(C84,C$26:C83,)),INDEX(B$26:B83,MATCH(C84,C$26:C83,)),MAX(B$26:B83)+1))","v":""},null,null,0,""]
[68,{"$f":"IF(N(C85)=0,\"\",IF(ISNUMBER(MATCH(C85,C$26:C84,)),INDEX(B$26:B84,MATCH(C85,C$26:C84,)),MAX(B$26:B84)+1))","v":""},null,null,0,""]
[69,{"$f":"IF(N(C86)=0,\"\",IF(ISNUMBER(MATCH(C86,C$26:C85,)),INDEX(B$26:B85,MATCH(C86,C$26:C85,)),MAX(B$26:B85)+1))","v":""},null,null,0,""]
[70,{"$f":"IF(N(C87)=0,\"\",IF(ISNUMBER(MATCH(C87,C$26:C86,)),INDEX(B$26:B86,MATCH(C87,C$26:C86,)),MAX(B$26:B86)+1))","v":""},null,null,0,""]
[71,{"$f":"IF(N(C88)=0,\"\",IF(ISNUMBER(MATCH(C88,C$26:C87,)),INDEX(B$26:B87,MATCH(C88,C$26:C87,)),MAX(B$26:B87)+1))","v":""},null,null,0,""]
[72,{"$f":"IF(N(C89)=0,\"\",IF(ISNUMBER(MATCH(C89,C$26:C88,)),INDEX(B$26:B88,MATCH(C89,C$26:C88,)),MAX(B$26:B88)+1))","v":""},null,null,0,""]
[73,{"$f":"IF(N(C90)=0,\"\",IF(ISNUMBER(MATCH(C90,C$26:C89,)),INDEX(B$26:B89,MATCH(C90,C$26:C89,)),MAX(B$26:B89)+1))","v":""},null,null,{"$f":"IF($K$3=0,0,IF(ISNA(VLOOKUP(C90,H$26:I$115,2,))*C90,D90,IF(C90=\"\",\"\",IF(D90=\"\",TRUNC($C$3/C90)-VLOOKUP(C90,H$26:I$115,2,),D90-VLOOKUP(C90,H$26:I$115,2,)))))","v":0},{"$f":"IF($K$3=0,\"\",IF(AND(C90<>\"\",D90<>\"\"),D90-E90,IF(D90=\"\",\"\",TRUNC($C$3/C90)-VLOOKUP(C90,H$26:I$115,2,))))","v":""}]
[74,{"$f":"IF(N(C91)=0,\"\",IF(ISNUMBER(MATCH(C91,C$26:C90,)),INDEX(B$26:B90,MATCH(C91,C$26:C90,)),MAX(B$26:B90)+1))","v":""},null,null,0,""]
[75,{"$f":"IF(N(C92)=0,\"\",IF(ISNUMBER(MATCH(C92,C$26:C91,)),INDEX(B$26:B91,MATCH(C92,C$26:C91,)),MAX(B$26:B91)+1))","v":""},null,null,0,""]
[76,{"$f":"IF(N(C93)=0,\"\",IF(ISNUMBER(MATCH(C93,C$26:C92,)),INDEX(B$26:B92,MATCH(C93,C$26:C92,)),MAX(B$26:B92)+1))","v":""},null,null,0,""]
[77,{"$f":"IF(N(C94)=0,\"\",IF(ISNUMBER(MATCH(C94,C$26:C93,)),INDEX(B$26:B93,MATCH(C94,C$26:C93,)),MAX(B$26:B93)+1))","v":""},null,null,0,""]
[78,{"$f":"IF(N(C95)=0,\"\",IF(ISNUMBER(MATCH(C95,C$26:C94,)),INDEX(B$26:B94,MATCH(C95,C$26:C94,)),MAX(B$26:B94)+1))","v":""},null,null,0,""]
[79,{"$f":"IF(N(C96)=0,\"\",IF(ISNUMBER(MATCH(C96,C$26:C95,)),INDEX(B$26:B95,MATCH(C96,C$26:C95,)),MAX(B$26:B95)+1))","v":""},null,null,0,""]
[80,{"$f":"IF(N(C97)=0,\"\",IF(ISNUMBER(MATCH(C97,C$26:C96,)),INDEX(B$26:B96,MATCH(C97,C$26:C96,)),MAX(B$26:B96)+1))","v":""},null,null,0,"",null,null,null,"Оптимизация остатка"]
[81,{"$f":"IF(N(C98)=0,\"\",IF(ISNUMBER(MATCH(C98,C$26:C97,)),INDEX(B$26:B97,MATCH(C98,C$26:C97,)),MAX(B$26:B97)+1))","v":""},null,null,0,"",null,null,null,"Оптимизация вариантов"]
[82,{"$f":"IF(N(C99)=0,\"\",IF(ISNUMBER(MATCH(C99,C$26:C98,)),INDEX(B$26:B98,MATCH(C99,C$26:C98,)),MAX(B$26:B98)+1))","v":""},null,null,0,""]
[83,{"$f":"IF(N(C100)=0,\"\",IF(ISNUMBER(MATCH(C100,C$26:C99,)),INDEX(B$26:B99,MATCH(C100,C$26:C99,)),MAX(B$26:B99)+1))","v":""},null,null,0,""]
[84,{"$f":"IF(N(C101)=0,\"\",IF(ISNUMBER(MATCH(C101,C$26:C100,)),INDEX(B$26:B100,MATCH(C101,C$26:C100,)),MAX(B$26:B100)+1))","v":""},null,null,0,""]
[85,{"$f":"IF(N(C102)=0,\"\",IF(ISNUMBER(MATCH(C102,C$26:C101,)),INDEX(B$26:B101,MATCH(C102,C$26:C101,)),MAX(B$26:B101)+1))","v":""},null,null,0,""]
[86,{"$f":"IF(N(C103)=0,\"\",IF(ISNUMBER(MATCH(C103,C$26:C102,)),INDEX(B$26:B102,MATCH(C103,C$26:C102,)),MAX(B$26:B102)+1))","v":""},null,null,0,""]
[87,{"$f":"IF(N(C104)=0,\"\",IF(ISNUMBER(MATCH(C104,C$26:C103,)),INDEX(B$26:B103,MATCH(C104,C$26:C103,)),MAX(B$26:B103)+1))","v":""},null,null,0,""]
[88,{"$f":"IF(N(C105)=0,\"\",IF(ISNUMBER(MATCH(C105,C$26:C104,)),INDEX(B$26:B104,MATCH(C105,C$26:C104,)),MAX(B$26:B104)+1))","v":""},null,null,0,""]
[89,{"$f":"IF(N(C106)=0,\"\",IF(ISNUMBER(MATCH(C106,C$26:C105,)),INDEX(B$26:B105,MATCH(C106,C$26:C105,)),MAX(B$26:B105)+1))","v":""},null,null,0,""]
[90,{"$f":"IF(N(C107)=0,\"\",IF(ISNUMBER(MATCH(C107,C$26:C106,)),INDEX(B$26:B106,MATCH(C107,C$26:C106,)),MAX(B$26:B106)+1))","v":""},null,null,0,""]
[91,{"$f":"IF(N(C108)=0,\"\",IF(ISNUMBER(MATCH(C108,C$26:C107,)),INDEX(B$26:B107,MATCH(C108,C$26:C107,)),MAX(B$26:B107)+1))","v":""},null,null,0,""]
[92,{"$f":"IF(N(C109)=0,\"\",IF(ISNUMBER(MATCH(C109,C$26:C108,)),INDEX(B$26:B108,MATCH(C109,C$26:C108,)),MAX(B$26:B108)+1))","v":""},null,null,0,""]
[93,{"$f":"IF(N(C110)=0,\"\",IF(ISNUMBER(MATCH(C110,C$26:C109,)),INDEX(B$26:B109,MATCH(C110,C$26:C109,)),MAX(B$26:B109)+1))","v":""},null,null,0,""]
[94,{"$f":"IF(N(C111)=0,\"\",IF(ISNUMBER(MATCH(C111,C$26:C110,)),INDEX(B$26:B110,MATCH(C111,C$26:C110,)),MAX(B$26:B110)+1))","v":""},null,null,0,""]
[95,{"$f":"IF(N(C112)=0,\"\",IF(ISNUMBER(MATCH(C112,C$26:C111,)),INDEX(B$26:B111,MATCH(C112,C$26:C111,)),MAX(B$26:B111)+1))","v":""},null,null,0,""]
[96,{"$f":"IF(N(C113)=0,\"\",IF(ISNUMBER(MATCH(C113,C$26:C112,)),INDEX(B$26:B112,MATCH(C113,C$26:C112,)),MAX(B$26:B112)+1))","v":""},null,null,0,""]
[97,{"$f":"IF(N(C114)=0,\"\",IF(ISNUMBER(MATCH(C114,C$26:C113,)),INDEX(B$26:B113,MATCH(C114,C$26:C113,)),MAX(B$26:B113)+1))","v":""},null,null,0,""]
[98,{"$f":"IF(N(C115)=0,\"\",IF(ISNUMBER(MATCH(C115,C$26:C114,)),INDEX(B$26:B114,MATCH(C115,C$26:C114,)),MAX(B$26:B114)+1))","v":""},null,null,0,""]

{"sheet":"Раскрой (2)","index":1,"n_rows":115,"n_cols":15,"rows_kept":115,"cut":false,"hidden":false,"merged":[]}
[null,"Есть",null,null,null,null,null,"Осталось",null,null,"Решение",null,null,null,{"$f":"O3/(L3+O3)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"B24","v":"№"},"Размер","Кол-во","Использовано","Не использов.",null,"Размер","Кол-во",null,"Размер","Расход","Кол-во исп.\nзаготовок","Раскрой",{"$f":"\"Отходы\"&IF((L3+O3)>0,TEXT(O3/(L3+O3),\"0,00%\"),\"\")","v":"Отходы"}]
[null,null,{"$f":"IF(COUNT(C4:C13)=COUNT(D4:D13),SUMPRODUCT(C4:C13,D4:D13),)","v":0},{"$f":"IF(COUNT(C4:C13)=COUNT(D4:D13),SUM(D4:D13),\"много\")","v":0},{"$f":"SUM(E4:E13)","v":0},{"$f":"IF(D3=\"много\",\"много\",D3-E3)","v":0},null,{"$f":"SUMPRODUCT(H4:H13,I4:I13)","v":0},{"$f":"IF(COUNT(H4:H13)=COUNT(I4:I13),SUM(I4:I13),\"много\")","v":0},null,{"$f":"SUMPRODUCT(K4:K1060,$M4:$M1060)","v":0},{"$f":"SUMPRODUCT(L4:L1060,$M4:$M1060)","v":0},{"$f":"SUM(M4:M1060)","v":0},null,{"$f":"SUM(IF((O4:O1060<D17)+(D17=0),$M4:$M1060*O4:O1060))","v":0}]
[null,{"$f":"IF(N(C4)=0,\"\",1)","v":""},null,null,{"$f":"MIN(SUMIF(K$4:K$1060,C4,M$4:M$1060),D4)","v":0},{"$f":"IF(D4,D4-E4,)","v":0}]
[null,{"$f":"IF(N(C5)=0,\"\",IF(ISNUMBER(MATCH(C5,C$4:C4,)),INDEX(B$4:B4,MATCH(C5,C$4:C4,)),MAX(B$4:B4)+1))","v":""},null,null,0,{"$f":"IF(D5,D5-E5,)","v":0}]
[null,{"$f":"IF(N(C6)=0,\"\",IF(ISNUMBER(MATCH(C6,C$4:C5,)),INDEX(B$4:B5,MATCH(C6,C$4:C5,)),MAX(B$4:B5)+1))","v":""},null,null,0,{"$f":"IF(D6,D6-E6,)","v":0}]
[null,{"$f":"IF(N(C7)=0,\"\",IF(ISNUMBER(MATCH(C7,C$4:C6,)),INDEX(B$4:B6,MATCH(C7,C$4:C6,)),MAX(B$4:B6)+1))","v":""},null,null,0,0]
[null,{"$f":"IF(N(C8)=0,\"\",IF(ISNUMBER(MATCH(C8,C$4:C7,)),INDEX(B$4:B7,MATCH(C8,C$4:C7,)),MAX(B$4:B7)+1))","v":""},null,null,0,0]
[null,{"$f":"IF(N(C9)=0,\"\",IF(ISNUMBER(MATCH(C9,C$4:C8,)),INDEX(B$4:B8,MATCH(C9,C$4:C8,)),MAX(B$4:B8)+1))","v":""},null,null,0,0]
[null,{"$f":"IF(N(C10)=0,\"\",IF(ISNUMBER(MATCH(C10,C$4:C9,)),INDEX(B$4:B9,MATCH(C10,C$4:C9,)),MAX(B$4:B9)+1))","v":""},null,null,0,0]
[null,{"$f":"IF(N(C11)=0,\"\",IF(ISNUMBER(MATCH(C11,C$4:C10,)),INDEX(B$4:B10,MATCH(C11,C$4:C10,)),MAX(B$4:B10)+1))","v":""},null,null,0,0]
[null,{"$f":"IF(N(C12)=0,\"\",IF(ISNUMBER(MATCH(C12,C$4:C11,)),INDEX(B$4:B11,MATCH(C12,C$4:C11,)),MAX(B$4:B11)+1))","v":""},null,null,0,{"$f":"IF(D12,D12-E12,)","v":0}]
[null,{"$f":"IF(N(C13)=0,\"\",IF(ISNUMBER(MATCH(C13,C$4:C12,)),INDEX(B$4:B12,MATCH(C13,C$4:C12,)),MAX(B$4:B12)+1))","v":""},null,null,0,{"$f":"IF(D13,D13-E13,)","v":0}]
[]
[null,"Ширина реза",null,null,true,null,"Быстро",3]
[null,"Кромка",null,null,true,null,"Нормально",1]
[null,"Деловой остат.",null,500,false,false,"Медленно"]
[null,null,null,null,null,null,"Очень медленно"]
[]
[]
[]
[]
[null,"Нужно",null,null,null,null,null,"Не сделано"]
[null,"№","Размер","Кол-во","Разложено","Не разложено",null,"Размер","Кол-во"]
[null,null,{"$f":"IF(D25=\"много\",\"много\",SUMPRODUCT(C26:C115,D26:D115))","v":0},{"$f":"IF(OR((D26:D115=\"\")+(C26:C115=\"\")=1),\"много\",SUM(D26:D115))","v":0},{"$f":"SUM(E26:E115)","v":0},{"$f":"IF(D25=\"много\",\"много\",SUM(F26:F115))","v":0},null,{"$f":"SUMPRODUCT(H26:H115,I26:I115)","v":0},{"$f":"SUM(I26:I115)","v":0}]
[2,{"$f":"IF(N(C26)=0,\"\",1)","v":""},null,null,{"$f":"IF($K$3=0,0,IF(ISNA(VLOOKUP(C26,H$26:I$115,2,))*C26,D26,IF(C26=\"\",\"\",IF(D26=\"\",TRUNC($C$3/C26)-VLOOKUP(C26,H$26:I$115,2,),D26-VLOOKUP(C26,H$26:I$115,2,)))))","v":0},{"$f":"IF($K$3=0,\"\",IF(AND(C26<>\"\",D26<>\"\"),D26-E26,IF(D26=\"\",\"\",TRUNC($C$3/C26)-VLOOKUP(C26,H$26:I$115,2,))))","v":""}]
[3,{"$f":"IF(N(C27)=0,\"\",IF(ISNUMBER(MATCH(C27,C$26:C26,)),INDEX(B$26:B26,MATCH(C27,C$26:C26,)),MAX(B$26:B26)+1))","v":""},null,null,0,""]
[4,{"$f":"IF(N(C28)=0,\"\",IF(ISNUMBER(MATCH(C28,C$26:C27,)),INDEX(B$26:B27,MATCH(C28,C$26:C27,)),MAX(B$26:B27)+1))","v":""},null,null,0,""]
[5,{"$f":"IF(N(C29)=0,\"\",IF(ISNUMBER(MATCH(C29,C$26:C28,)),INDEX(B$26:B28,MATCH(C29,C$26:C28,)),MAX(B$26:B28)+1))","v":""},null,null,0,""]
[6,{"$f":"IF(N(C30)=0,\"\",IF(ISNUMBER(MATCH(C30,C$26:C29,)),INDEX(B$26:B29,MATCH(C30,C$26:C29,)),MAX(B$26:B29)+1))","v":""},null,null,0,""]
[7,{"$f":"IF(N(C31)=0,\"\",IF(ISNUMBER(MATCH(C31,C$26:C30,)),INDEX(B$26:B30,MATCH(C31,C$26:C30,)),MAX(B$26:B30)+1))","v":""},null,null,0,""]
[8,{"$f":"IF(N(C32)=0,\"\",IF(ISNUMBER(MATCH(C32,C$26:C31,)),INDEX(B$26:B31,MATCH(C32,C$26:C31,)),MAX(B$26:B31)+1))","v":""},null,null,0,""]
[16,{"$f":"IF(N(C33)=0,\"\",IF(ISNUMBER(MATCH(C33,C$26:C32,)),INDEX(B$26:B32,MATCH(C33,C$26:C32,)),MAX(B$26:B32)+1))","v":""},null,null,0,""]
[17,{"$f":"IF(N(C34)=0,\"\",IF(ISNUMBER(MATCH(C34,C$26:C33,)),INDEX(B$26:B33,MATCH(C34,C$26:C33,)),MAX(B$26:B33)+1))","v":""},null,null,0,""]
[18,{"$f":"IF(N(C35)=0,\"\",IF(ISNUMBER(MATCH(C35,C$26:C34,)),INDEX(B$26:B34,MATCH(C35,C$26:C34,)),MAX(B$26:B34)+1))","v":""},null,null,0,""]
[19,{"$f":"IF(N(C36)=0,\"\",IF(ISNUMBER(MATCH(C36,C$26:C35,)),INDEX(B$26:B35,MATCH(C36,C$26:C35,)),MAX(B$26:B35)+1))","v":""},null,null,0,""]
[20,{"$f":"IF(N(C37)=0,\"\",IF(ISNUMBER(MATCH(C37,C$26:C36,)),INDEX(B$26:B36,MATCH(C37,C$26:C36,)),MAX(B$26:B36)+1))","v":""},null,null,0,""]
[21,{"$f":"IF(N(C38)=0,\"\",IF(ISNUMBER(MATCH(C38,C$26:C37,)),INDEX(B$26:B37,MATCH(C38,C$26:C37,)),MAX(B$26:B37)+1))","v":""},null,null,0,""]
[22,{"$f":"IF(N(C39)=0,\"\",IF(ISNUMBER(MATCH(C39,C$26:C38,)),INDEX(B$26:B38,MATCH(C39,C$26:C38,)),MAX(B$26:B38)+1))","v":""},null,null,0,""]
[23,{"$f":"IF(N(C40)=0,\"\",IF(ISNUMBER(MATCH(C40,C$26:C39,)),INDEX(B$26:B39,MATCH(C40,C$26:C39,)),MAX(B$26:B39)+1))","v":""},null,null,0,""]
[24,{"$f":"IF(N(C41)=0,\"\",IF(ISNUMBER(MATCH(C41,C$26:C40,)),INDEX(B$26:B40,MATCH(C41,C$26:C40,)),MAX(B$26:B40)+1))","v":""},null,null,0,""]
[25,{"$f":"IF(N(C42)=0,\"\",IF(ISNUMBER(MATCH(C42,C$26:C41,)),INDEX(B$26:B41,MATCH(C42,C$26:C41,)),MAX(B$26:B41)+1))","v":""},null,null,0,""]
[26,{"$f":"IF(N(C43)=0,\"\",IF(ISNUMBER(MATCH(C43,C$26:C42,)),INDEX(B$26:B42,MATCH(C43,C$26:C42,)),MAX(B$26:B42)+1))","v":""},null,null,0,""]
[27,{"$f":"IF(N(C44)=0,\"\",IF(ISNUMBER(MATCH(C44,C$26:C43,)),INDEX(B$26:B43,MATCH(C44,C$26:C43,)),MAX(B$26:B43)+1))","v":""},null,null,0,""]
[28,{"$f":"IF(N(C45)=0,\"\",IF(ISNUMBER(MATCH(C45,C$26:C44,)),INDEX(B$26:B44,MATCH(C45,C$26:C44,)),MAX(B$26:B44)+1))","v":""},null,null,0,""]
[29,{"$f":"IF(N(C46)=0,\"\",IF(ISNUMBER(MATCH(C46,C$26:C45,)),INDEX(B$26:B45,MATCH(C46,C$26:C45,)),MAX(B$26:B45)+1))","v":""},null,null,0,""]
[30,{"$f":"IF(N(C47)=0,\"\",IF(ISNUMBER(MATCH(C47,C$26:C46,)),INDEX(B$26:B46,MATCH(C47,C$26:C46,)),MAX(B$26:B46)+1))","v":""},null,null,0,""]
[31,{"$f":"IF(N(C48)=0,\"\",IF(ISNUMBER(MATCH(C48,C$26:C47,)),INDEX(B$26:B47,MATCH(C48,C$26:C47,)),MAX(B$26:B47)+1))","v":""},null,null,0,""]
[32,{"$f":"IF(N(C49)=0,\"\",IF(ISNUMBER(MATCH(C49,C$26:C48,)),INDEX(B$26:B48,MATCH(C49,C$26:C48,)),MAX(B$26:B48)+1))","v":""},null,null,0,""]
[33,{"$f":"IF(N(C50)=0,\"\",IF(ISNUMBER(MATCH(C50,C$26:C49,)),INDEX(B$26:B49,MATCH(C50,C$26:C49,)),MAX(B$26:B49)+1))","v":""},null,null,0,""]
[34,{"$f":"IF(N(C51)=0,\"\",IF(ISNUMBER(MATCH(C51,C$26:C50,)),INDEX(B$26:B50,MATCH(C51,C$26:C50,)),MAX(B$26:B50)+1))","v":""},null,null,0,""]
[35,{"$f":"IF(N(C52)=0,\"\",IF(ISNUMBER(MATCH(C52,C$26:C51,)),INDEX(B$26:B51,MATCH(C52,C$26:C51,)),MAX(B$26:B51)+1))","v":""},null,null,0,""]
[36,{"$f":"IF(N(C53)=0,\"\",IF(ISNUMBER(MATCH(C53,C$26:C52,)),INDEX(B$26:B52,MATCH(C53,C$26:C52,)),MAX(B$26:B52)+1))","v":""},null,null,0,""]
[37,{"$f":"IF(N(C54)=0,\"\",IF(ISNUMBER(MATCH(C54,C$26:C53,)),INDEX(B$26:B53,MATCH(C54,C$26:C53,)),MAX(B$26:B53)+1))","v":""},null,null,0,""]
[38,{"$f":"IF(N(C55)=0,\"\",IF(ISNUMBER(MATCH(C55,C$26:C54,)),INDEX(B$26:B54,MATCH(C55,C$26:C54,)),MAX(B$26:B54)+1))","v":""},null,null,0,""]
[39,{"$f":"IF(N(C56)=0,\"\",IF(ISNUMBER(MATCH(C56,C$26:C55,)),INDEX(B$26:B55,MATCH(C56,C$26:C55,)),MAX(B$26:B55)+1))","v":""},null,null,0,""]
[40,{"$f":"IF(N(C57)=0,\"\",IF(ISNUMBER(MATCH(C57,C$26:C56,)),INDEX(B$26:B56,MATCH(C57,C$26:C56,)),MAX(B$26:B56)+1))","v":""},null,null,0,""]
[41,{"$f":"IF(N(C58)=0,\"\",IF(ISNUMBER(MATCH(C58,C$26:C57,)),INDEX(B$26:B57,MATCH(C58,C$26:C57,)),MAX(B$26:B57)+1))","v":""},null,null,0,""]
[42,{"$f":"IF(N(C59)=0,\"\",IF(ISNUMBER(MATCH(C59,C$26:C58,)),INDEX(B$26:B58,MATCH(C59,C$26:C58,)),MAX(B$26:B58)+1))","v":""},null,null,0,""]
[43,{"$f":"IF(N(C60)=0,\"\",IF(ISNUMBER(MATCH(C60,C$26:C59,)),INDEX(B$26:B59,MATCH(C60,C$26:C59,)),MAX(B$26:B59)+1))","v":""},null,null,0,""]
[44,{"$f":"IF(N(C61)=0,\"\",IF(ISNUMBER(MATCH(C61,C$26:C60,)),INDEX(B$26:B60,MATCH(C61,C$26:C60,)),MAX(B$26:B60)+1))","v":""},null,null,0,""]
[45,{"$f":"IF(N(C62)=0,\"\",IF(ISNUMBER(MATCH(C62,C$26:C61,)),INDEX(B$26:B61,MATCH(C62,C$26:C61,)),MAX(B$26:B61)+1))","v":""},null,null,0,""]
[46,{"$f":"IF(N(C63)=0,\"\",IF(ISNUMBER(MATCH(C63,C$26:C62,)),INDEX(B$26:B62,MATCH(C63,C$26:C62,)),MAX(B$26:B62)+1))","v":""},null,null,0,""]
[47,{"$f":"IF(N(C64)=0,\"\",IF(ISNUMBER(MATCH(C64,C$26:C63,)),INDEX(B$26:B63,MATCH(C64,C$26:C63,)),MAX(B$26:B63)+1))","v":""},null,null,0,""]
[48,{"$f":"IF(N(C65)=0,\"\",IF(ISNUMBER(MATCH(C65,C$26:C64,)),INDEX(B$26:B64,MATCH(C65,C$26:C64,)),MAX(B$26:B64)+1))","v":""},null,null,0,""]
[49,{"$f":"IF(N(C66)=0,\"\",IF(ISNUMBER(MATCH(C66,C$26:C65,)),INDEX(B$26:B65,MATCH(C66,C$26:C65,)),MAX(B$26:B65)+1))","v":""},null,null,0,""]
[50,{"$f":"IF(N(C67)=0,\"\",IF(ISNUMBER(MATCH(C67,C$26:C66,)),INDEX(B$26:B66,MATCH(C67,C$26:C66,)),MAX(B$26:B66)+1))","v":""},null,null,0,""]
[51,{"$f":"IF(N(C68)=0,\"\",IF(ISNUMBER(MATCH(C68,C$26:C67,)),INDEX(B$26:B67,MATCH(C68,C$26:C67,)),MAX(B$26:B67)+1))","v":""},null,null,0,""]
[52,{"$f":"IF(N(C69)=0,\"\",IF(ISNUMBER(MATCH(C69,C$26:C68,)),INDEX(B$26:B68,MATCH(C69,C$26:C68,)),MAX(B$26:B68)+1))","v":""},null,null,0,""]
[53,{"$f":"IF(N(C70)=0,\"\",IF(ISNUMBER(MATCH(C70,C$26:C69,)),INDEX(B$26:B69,MATCH(C70,C$26:C69,)),MAX(B$26:B69)+1))","v":""},null,null,0,""]
[54,{"$f":"IF(N(C71)=0,\"\",IF(ISNUMBER(MATCH(C71,C$26:C70,)),INDEX(B$26:B70,MATCH(C71,C$26:C70,)),MAX(B$26:B70)+1))","v":""},null,null,0,""]
[55,{"$f":"IF(N(C72)=0,\"\",IF(ISNUMBER(MATCH(C72,C$26:C71,)),INDEX(B$26:B71,MATCH(C72,C$26:C71,)),MAX(B$26:B71)+1))","v":""},null,null,0,""]
[56,{"$f":"IF(N(C73)=0,\"\",IF(ISNUMBER(MATCH(C73,C$26:C72,)),INDEX(B$26:B72,MATCH(C73,C$26:C72,)),MAX(B$26:B72)+1))","v":""},null,null,0,""]
[57,{"$f":"IF(N(C74)=0,\"\",IF(ISNUMBER(MATCH(C74,C$26:C73,)),INDEX(B$26:B73,MATCH(C74,C$26:C73,)),MAX(B$26:B73)+1))","v":""},null,null,0,""]
[58,{"$f":"IF(N(C75)=0,\"\",IF(ISNUMBER(MATCH(C75,C$26:C74,)),INDEX(B$26:B74,MATCH(C75,C$26:C74,)),MAX(B$26:B74)+1))","v":""},null,null,0,""]
[59,{"$f":"IF(N(C76)=0,\"\",IF(ISNUMBER(MATCH(C76,C$26:C75,)),INDEX(B$26:B75,MATCH(C76,C$26:C75,)),MAX(B$26:B75)+1))","v":""},null,null,0,""]
[60,{"$f":"IF(N(C77)=0,\"\",IF(ISNUMBER(MATCH(C77,C$26:C76,)),INDEX(B$26:B76,MATCH(C77,C$26:C76,)),MAX(B$26:B76)+1))","v":""},null,null,0,""]
[61,{"$f":"IF(N(C78)=0,\"\",IF(ISNUMBER(MATCH(C78,C$26:C77,)),INDEX(B$26:B77,MATCH(C78,C$26:C77,)),MAX(B$26:B77)+1))","v":""},null,null,0,""]
[62,{"$f":"IF(N(C79)=0,\"\",IF(ISNUMBER(MATCH(C79,C$26:C78,)),INDEX(B$26:B78,MATCH(C79,C$26:C78,)),MAX(B$26:B78)+1))","v":""},null,null,0,""]
[63,{"$f":"IF(N(C80)=0,\"\",IF(ISNUMBER(MATCH(C80,C$26:C79,)),INDEX(B$26:B79,MATCH(C80,C$26:C79,)),MAX(B$26:B79)+1))","v":""},null,null,0,""]
[64,{"$f":"IF(N(C81)=0,\"\",IF(ISNUMBER(MATCH(C81,C$26:C80,)),INDEX(B$26:B80,MATCH(C81,C$26:C80,)),MAX(B$26:B80)+1))","v":""},null,null,0,""]
[65,{"$f":"IF(N(C82)=0,\"\",IF(ISNUMBER(MATCH(C82,C$26:C81,)),INDEX(B$26:B81,MATCH(C82,C$26:C81,)),MAX(B$26:B81)+1))","v":""},null,null,0,""]
[66,{"$f":"IF(N(C83)=0,\"\",IF(ISNUMBER(MATCH(C83,C$26:C82,)),INDEX(B$26:B82,MATCH(C83,C$26:C82,)),MAX(B$26:B82)+1))","v":""},null,null,0,""]
[67,{"$f":"IF(N(C84)=0,\"\",IF(ISNUMBER(MATCH(C84,C$26:C83,)),INDEX(B$26:B83,MATCH(C84,C$26:C83,)),MAX(B$26:B83)+1))","v":""},null,null,0,""]
[68,{"$f":"IF(N(C85)=0,\"\",IF(ISNUMBER(MATCH(C85,C$26:C84,)),INDEX(B$26:B84,MATCH(C85,C$26:C84,)),MAX(B$26:B84)+1))","v":""},null,null,0,""]
[69,{"$f":"IF(N(C86)=0,\"\",IF(ISNUMBER(MATCH(C86,C$26:C85,)),INDEX(B$26:B85,MATCH(C86,C$26:C85,)),MAX(B$26:B85)+1))","v":""},null,null,0,""]
[70,{"$f":"IF(N(C87)=0,\"\",IF(ISNUMBER(MATCH(C87,C$26:C86,)),INDEX(B$26:B86,MATCH(C87,C$26:C86,)),MAX(B$26:B86)+1))","v":""},null,null,0,""]
[71,{"$f":"IF(N(C88)=0,\"\",IF(ISNUMBER(MATCH(C88,C$26:C87,)),INDEX(B$26:B87,MATCH(C88,C$26:C87,)),MAX(B$26:B87)+1))","v":""},null,null,0,""]
[72,{"$f":"IF(N(C89)=0,\"\",IF(ISNUMBER(MATCH(C89,C$26:C88,)),INDEX(B$26:B88,MATCH(C89,C$26:C88,)),MAX(B$26:B88)+1))","v":""},null,null,0,""]
[73,{"$f":"IF(N(C90)=0,\"\",IF(ISNUMBER(MATCH(C90,C$26:C89,)),INDEX(B$26:B89,MATCH(C90,C$26:C89,)),MAX(B$26:B89)+1))","v":""},null,null,{"$f":"IF($K$3=0,0,IF(ISNA(VLOOKUP(C90,H$26:I$115,2,))*C90,D90,IF(C90=\"\",\"\",IF(D90=\"\",TRUNC($C$3/C90)-VLOOKUP(C90,H$26:I$115,2,),D90-VLOOKUP(C90,H$26:I$115,2,)))))","v":0},{"$f":"IF($K$3=0,\"\",IF(AND(C90<>\"\",D90<>\"\"),D90-E90,IF(D90=\"\",\"\",TRUNC($C$3/C90)-VLOOKUP(C90,H$26:I$115,2,))))","v":""}]
[74,{"$f":"IF(N(C91)=0,\"\",IF(ISNUMBER(MATCH(C91,C$26:C90,)),INDEX(B$26:B90,MATCH(C91,C$26:C90,)),MAX(B$26:B90)+1))","v":""},null,null,0,""]
[75,{"$f":"IF(N(C92)=0,\"\",IF(ISNUMBER(MATCH(C92,C$26:C91,)),INDEX(B$26:B91,MATCH(C92,C$26:C91,)),MAX(B$26:B91)+1))","v":""},null,null,0,""]
[76,{"$f":"IF(N(C93)=0,\"\",IF(ISNUMBER(MATCH(C93,C$26:C92,)),INDEX(B$26:B92,MATCH(C93,C$26:C92,)),MAX(B$26:B92)+1))","v":""},null,null,0,""]
[77,{"$f":"IF(N(C94)=0,\"\",IF(ISNUMBER(MATCH(C94,C$26:C93,)),INDEX(B$26:B93,MATCH(C94,C$26:C93,)),MAX(B$26:B93)+1))","v":""},null,null,0,""]
[78,{"$f":"IF(N(C95)=0,\"\",IF(ISNUMBER(MATCH(C95,C$26:C94,)),INDEX(B$26:B94,MATCH(C95,C$26:C94,)),MAX(B$26:B94)+1))","v":""},null,null,0,""]
[79,{"$f":"IF(N(C96)=0,\"\",IF(ISNUMBER(MATCH(C96,C$26:C95,)),INDEX(B$26:B95,MATCH(C96,C$26:C95,)),MAX(B$26:B95)+1))","v":""},null,null,0,""]
[80,{"$f":"IF(N(C97)=0,\"\",IF(ISNUMBER(MATCH(C97,C$26:C96,)),INDEX(B$26:B96,MATCH(C97,C$26:C96,)),MAX(B$26:B96)+1))","v":""},null,null,0,"",null,null,null,"Оптимизация остатка"]
[81,{"$f":"IF(N(C98)=0,\"\",IF(ISNUMBER(MATCH(C98,C$26:C97,)),INDEX(B$26:B97,MATCH(C98,C$26:C97,)),MAX(B$26:B97)+1))","v":""},null,null,0,"",null,null,null,"Оптимизация вариантов"]
[82,{"$f":"IF(N(C99)=0,\"\",IF(ISNUMBER(MATCH(C99,C$26:C98,)),INDEX(B$26:B98,MATCH(C99,C$26:C98,)),MAX(B$26:B98)+1))","v":""},null,null,0,""]
[83,{"$f":"IF(N(C100)=0,\"\",IF(ISNUMBER(MATCH(C100,C$26:C99,)),INDEX(B$26:B99,MATCH(C100,C$26:C99,)),MAX(B$26:B99)+1))","v":""},null,null,0,""]
[84,{"$f":"IF(N(C101)=0,\"\",IF(ISNUMBER(MATCH(C101,C$26:C100,)),INDEX(B$26:B100,MATCH(C101,C$26:C100,)),MAX(B$26:B100)+1))","v":""},null,null,0,""]
[85,{"$f":"IF(N(C102)=0,\"\",IF(ISNUMBER(MATCH(C102,C$26:C101,)),INDEX(B$26:B101,MATCH(C102,C$26:C101,)),MAX(B$26:B101)+1))","v":""},null,null,0,""]
[86,{"$f":"IF(N(C103)=0,\"\",IF(ISNUMBER(MATCH(C103,C$26:C102,)),INDEX(B$26:B102,MATCH(C103,C$26:C102,)),MAX(B$26:B102)+1))","v":""},null,null,0,""]
[87,{"$f":"IF(N(C104)=0,\"\",IF(ISNUMBER(MATCH(C104,C$26:C103,)),INDEX(B$26:B103,MATCH(C104,C$26:C103,)),MAX(B$26:B103)+1))","v":""},null,null,0,""]
[88,{"$f":"IF(N(C105)=0,\"\",IF(ISNUMBER(MATCH(C105,C$26:C104,)),INDEX(B$26:B104,MATCH(C105,C$26:C104,)),MAX(B$26:B104)+1))","v":""},null,null,0,""]
[89,{"$f":"IF(N(C106)=0,\"\",IF(ISNUMBER(MATCH(C106,C$26:C105,)),INDEX(B$26:B105,MATCH(C106,C$26:C105,)),MAX(B$26:B105)+1))","v":""},null,null,0,""]
[90,{"$f":"IF(N(C107)=0,\"\",IF(ISNUMBER(MATCH(C107,C$26:C106,)),INDEX(B$26:B106,MATCH(C107,C$26:C106,)),MAX(B$26:B106)+1))","v":""},null,null,0,""]
[91,{"$f":"IF(N(C108)=0,\"\",IF(ISNUMBER(MATCH(C108,C$26:C107,)),INDEX(B$26:B107,MATCH(C108,C$26:C107,)),MAX(B$26:B107)+1))","v":""},null,null,0,""]
[92,{"$f":"IF(N(C109)=0,\"\",IF(ISNUMBER(MATCH(C109,C$26:C108,)),INDEX(B$26:B108,MATCH(C109,C$26:C108,)),MAX(B$26:B108)+1))","v":""},null,null,0,""]
[93,{"$f":"IF(N(C110)=0,\"\",IF(ISNUMBER(MATCH(C110,C$26:C109,)),INDEX(B$26:B109,MATCH(C110,C$26:C109,)),MAX(B$26:B109)+1))","v":""},null,null,0,""]
[94,{"$f":"IF(N(C111)=0,\"\",IF(ISNUMBER(MATCH(C111,C$26:C110,)),INDEX(B$26:B110,MATCH(C111,C$26:C110,)),MAX(B$26:B110)+1))","v":""},null,null,0,""]
[95,{"$f":"IF(N(C112)=0,\"\",IF(ISNUMBER(MATCH(C112,C$26:C111,)),INDEX(B$26:B111,MATCH(C112,C$26:C111,)),MAX(B$26:B111)+1))","v":""},null,null,0,""]
[96,{"$f":"IF(N(C113)=0,\"\",IF(ISNUMBER(MATCH(C113,C$26:C112,)),INDEX(B$26:B112,MATCH(C113,C$26:C112,)),MAX(B$26:B112)+1))","v":""},null,null,0,""]
[97,{"$f":"IF(N(C114)=0,\"\",IF(ISNUMBER(MATCH(C114,C$26:C113,)),INDEX(B$26:B113,MATCH(C114,C$26:C113,)),MAX(B$26:B113)+1))","v":""},null,null,0,""]
[98,{"$f":"IF(N(C115)=0,\"\",IF(ISNUMBER(MATCH(C115,C$26:C114,)),INDEX(B$26:B114,MATCH(C115,C$26:C114,)),MAX(B$26:B114)+1))","v":""},null,null,0,""]