{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["78","79","77","75","общ"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"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":"78","index":0,"n_rows":12,"n_cols":22,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,3,2,3],[1,4,2,4],[1,20,2,20],[1,21,2,21],[4,0,4,20],[1,8,2,8],[1,9,2,9],[1,10,1,11],[1,12,1,13],[1,14,1,15],[1,16,2,16],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,17,1,18],[1,19,2,19],[1,0,2,0],[1,1,2,1],[1,2,2,2]]}
[]
["№","Наименование агрегата","Чертёжный номер","Заводской номер","Дата выпуска","Дата ремонта","Место ремонта","Количество ремонтов","Гарантия до","дата установки агрегата на вертолет","Назнач. ресурс",null,"Межрем. ресурс",null,"Наработка до установки",null,"Наработка вертолёта при установке агрегата","Наработка ",null,"Остаток ресурса час.","Дата снятия агрегата по выработке ресурса ","Бортовой номер вертолета"]
[null,null,null,null,null,null,null,null,null,null,"часов","лет","часов","лет","ППР","СНЭ",null,"СНЭ","ППР"]
[]
["Вертолет 78",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78]
[1,"Двигатель","ТВ3-117МТ",null,null,null,null,null,null,null,4500,null,1143,12,0,655,null,{"$f":"SUM(R$7,-Q6,P6)","v":2395},{"$f":"IF(ISBLANK(O6),0,SUM(R$7,-Q6,O6))","v":999},{"$f":"IF(ISBLANK(M6),K6-R6,IF(AND(ISBLANK(F6),K6-R6>M6-R6),M6-R6,IF(AND(ISNONTEXT(F6),K6-R6>M6-S6),M6-S6,K6-R6)))","v":1},{"$f":"IF(OR(AND(NOT(ISBLANK(F6)),L6>0,N6>0,E6+L6*365>F6+N6*365),AND(NOT(ISBLANK(F6)),ISBLANK(L6),N6>0)),F6+N6*365+IF(DAY(F6)>=DAY(F6+N6*365),DAY(F6)-DAY(F6+N6*365),IF(OR(EXACT(MONTH(F6),$V$34:$V$35)),31-DAY(F6+N6*365)+DAY(F6),IF(OR(EXACT(MONTH(F6),$W$34:$W$35)),30-DAY(F6+N6*365)+DAY(F6),28-DAY(F6+N6*365)+DAY(F6)))),IF(AND(ISBLANK(F6),OR(ISBLANK(L6),N6>0)),E6+N6*365+IF(DAY(E6)>=DAY(E6+N6*365),DAY(E6)-DAY(E6+N6*365),IF(OR(EXACT(MONTH(E6),$V$34:$V$35)),31-DAY(E6+N6*365)+DAY(E6),IF(OR(EXACT(MONTH(E6),$W$34:$W$35)),30-DAY(E6+N6*365)+DAY(E6),28-DAY(E6+N6*365)+DAY(E6)))),E6+L6*365+IF(DAY(E6)>=DAY(E6+365*L6),DAY(E6)-DAY(E6+L6*365),IF(OR(EXACT(MONTH(E6),$V$34:$V$35)),31-DAY(E6+L6*365)+DAY(E6),IF(OR(EXACT(MONTH(E6),$W$34:$W$35)),30-DAY(E6+L6*365)+DAY(E6),28-DAY(E6+L6*365)+DAY(E6))))))","v":"1911-12-28"},78]
[2,"Двигатель","ТВ3-117МТ",null,null,null,null,null,null,null,4500,null,1500,12,0,875,null,999,999,1,{"$f":"IF(OR(AND(NOT(ISBLANK(F7)),L7>0,N7>0,E7+L7*365>F7+N7*365),AND(NOT(ISBLANK(F7)),ISBLANK(L7),N7>0)),F7+N7*365+IF(DAY(F7)>=DAY(F7+N7*365),DAY(F7)-DAY(F7+N7*365),IF(OR(EXACT(MONTH(F7),$V$34:$V$35)),31-DAY(F7+N7*365)+DAY(F7),IF(OR(EXACT(MONTH(F7),$W$34:$W$35)),30-DAY(F7+N7*365)+DAY(F7),28-DAY(F7+N7*365)+DAY(F7)))),IF(AND(ISBLANK(F7),OR(ISBLANK(L7),N7>0)),E7+N7*365+IF(DAY(E7)>=DAY(E7+N7*365),DAY(E7)-DAY(E7+N7*365),IF(OR(EXACT(MONTH(E7),$V$34:$V$35)),31-DAY(E7+N7*365)+DAY(E7),IF(OR(EXACT(MONTH(E7),$W$34:$W$35)),30-DAY(E7+N7*365)+DAY(E7),28-DAY(E7+N7*365)+DAY(E7)))),E7+L7*365+IF(DAY(E7)>=DAY(E7+365*L7),DAY(E7)-DAY(E7+L7*365),IF(OR(EXACT(MONTH(E7),$V$34:$V$35)),31-DAY(E7+L7*365)+DAY(E7),IF(OR(EXACT(MONTH(E7),$W$34:$W$35)),30-DAY(E7+L7*365)+DAY(E7),28-DAY(E7+L7*365)+DAY(E7))))))","v":"1911-12-28"},78]
[4,"Лопасть НВ","8АТ-2710-00",null,null,null,null,null,null,null,2000,7,null,null,null,0,null,515,0,1,{"$f":"IF(OR(AND(NOT(ISBLANK(F8)),L8>0,N8>0,E8+L8*365>F8+N8*365),AND(NOT(ISBLANK(F8)),ISBLANK(L8),N8>0)),F8+N8*365+IF(DAY(F8)>=DAY(F8+N8*365),DAY(F8)-DAY(F8+N8*365),IF(OR(EXACT(MONTH(F8),$V$34:$V$35)),31-DAY(F8+N8*365)+DAY(F8),IF(OR(EXACT(MONTH(F8),$W$34:$W$35)),30-DAY(F8+N8*365)+DAY(F8),28-DAY(F8+N8*365)+DAY(F8)))),IF(AND(ISBLANK(F8),OR(ISBLANK(L8),N8>0)),E8+N8*365+IF(DAY(E8)>=DAY(E8+N8*365),DAY(E8)-DAY(E8+N8*365),IF(OR(EXACT(MONTH(E8),$V$34:$V$35)),31-DAY(E8+N8*365)+DAY(E8),IF(OR(EXACT(MONTH(E8),$W$34:$W$35)),30-DAY(E8+N8*365)+DAY(E8),28-DAY(E8+N8*365)+DAY(E8)))),E8+L8*365+IF(DAY(E8)>=DAY(E8+365*L8),DAY(E8)-DAY(E8+L8*365),IF(OR(EXACT(MONTH(E8),$V$34:$V$35)),31-DAY(E8+L8*365)+DAY(E8),IF(OR(EXACT(MONTH(E8),$W$34:$W$35)),30-DAY(E8+L8*365)+DAY(E8),28-DAY(E8+L8*365)+DAY(E8))))))","v":"1906-12-28"},78]
[5,"Лопасть НВ","8АТ-2710-00",null,null,null,null,null,null,null,2000,7,null,null,null,0,null,2395,0,1,{"$f":"IF(OR(AND(NOT(ISBLANK(F9)),L9>0,N9>0,E9+L9*365>F9+N9*365),AND(NOT(ISBLANK(F9)),ISBLANK(L9),N9>0)),F9+N9*365+IF(DAY(F9)>=DAY(F9+N9*365),DAY(F9)-DAY(F9+N9*365),IF(OR(EXACT(MONTH(F9),$V$34:$V$35)),31-DAY(F9+N9*365)+DAY(F9),IF(OR(EXACT(MONTH(F9),$W$34:$W$35)),30-DAY(F9+N9*365)+DAY(F9),28-DAY(F9+N9*365)+DAY(F9)))),IF(AND(ISBLANK(F9),OR(ISBLANK(L9),N9>0)),E9+N9*365+IF(DAY(E9)>=DAY(E9+N9*365),DAY(E9)-DAY(E9+N9*365),IF(OR(EXACT(MONTH(E9),$V$34:$V$35)),31-DAY(E9+N9*365)+DAY(E9),IF(OR(EXACT(MONTH(E9),$W$34:$W$35)),30-DAY(E9+N9*365)+DAY(E9),28-DAY(E9+N9*365)+DAY(E9)))),E9+L9*365+IF(DAY(E9)>=DAY(E9+365*L9),DAY(E9)-DAY(E9+L9*365),IF(OR(EXACT(MONTH(E9),$V$34:$V$35)),31-DAY(E9+L9*365)+DAY(E9),IF(OR(EXACT(MONTH(E9),$W$34:$W$35)),30-DAY(E9+L9*365)+DAY(E9),28-DAY(E9+L9*365)+DAY(E9))))))","v":"1906-12-28"},78]
[6,"Лопасть НВ","8АТ-2710-00",null,null,null,null,null,null,null,2000,7,null,null,null,0,null,999,0,1,{"$f":"IF(OR(AND(NOT(ISBLANK(F10)),L10>0,N10>0,E10+L10*365>F10+N10*365),AND(NOT(ISBLANK(F10)),ISBLANK(L10),N10>0)),F10+N10*365+IF(DAY(F10)>=DAY(F10+N10*365),DAY(F10)-DAY(F10+N10*365),IF(OR(EXACT(MONTH(F10),$V$34:$V$35)),31-DAY(F10+N10*365)+DAY(F10),IF(OR(EXACT(MONTH(F10),$W$34:$W$35)),30-DAY(F10+N10*365)+DAY(F10),28-DAY(F10+N10*365)+DAY(F10)))),IF(AND(ISBLANK(F10),OR(ISBLANK(L10),N10>0)),E10+N10*365+IF(DAY(E10)>=DAY(E10+N10*365),DAY(E10)-DAY(E10+N10*365),IF(OR(EXACT(MONTH(E10),$V$34:$V$35)),31-DAY(E10+N10*365)+DAY(E10),IF(OR(EXACT(MONTH(E10),$W$34:$W$35)),30-DAY(E10+N10*365)+DAY(E10),28-DAY(E10+N10*365)+DAY(E10)))),E10+L10*365+IF(DAY(E10)>=DAY(E10+365*L10),DAY(E10)-DAY(E10+L10*365),IF(OR(EXACT(MONTH(E10),$V$34:$V$35)),31-DAY(E10+L10*365)+DAY(E10),IF(OR(EXACT(MONTH(E10),$W$34:$W$35)),30-DAY(E10+L10*365)+DAY(E10),28-DAY(E10+L10*365)+DAY(E10))))))","v":"1906-12-28"},78]
[7,"Лопасть НВ","8АТ-2710-00",null,null,null,null,null,null,null,2000,7,null,null,null,0,null,515,0,1,{"$f":"IF(OR(AND(NOT(ISBLANK(F11)),L11>0,N11>0,E11+L11*365>F11+N11*365),AND(NOT(ISBLANK(F11)),ISBLANK(L11),N11>0)),F11+N11*365+IF(DAY(F11)>=DAY(F11+N11*365),DAY(F11)-DAY(F11+N11*365),IF(OR(EXACT(MONTH(F11),$V$34:$V$35)),31-DAY(F11+N11*365)+DAY(F11),IF(OR(EXACT(MONTH(F11),$W$34:$W$35)),30-DAY(F11+N11*365)+DAY(F11),28-DAY(F11+N11*365)+DAY(F11)))),IF(AND(ISBLANK(F11),OR(ISBLANK(L11),N11>0)),E11+N11*365+IF(DAY(E11)>=DAY(E11+N11*365),DAY(E11)-DAY(E11+N11*365),IF(OR(EXACT(MONTH(E11),$V$34:$V$35)),31-DAY(E11+N11*365)+DAY(E11),IF(OR(EXACT(MONTH(E11),$W$34:$W$35)),30-DAY(E11+N11*365)+DAY(E11),28-DAY(E11+N11*365)+DAY(E11)))),E11+L11*365+IF(DAY(E11)>=DAY(E11+365*L11),DAY(E11)-DAY(E11+L11*365),IF(OR(EXACT(MONTH(E11),$V$34:$V$35)),31-DAY(E11+L11*365)+DAY(E11),IF(OR(EXACT(MONTH(E11),$W$34:$W$35)),30-DAY(E11+L11*365)+DAY(E11),28-DAY(E11+L11*365)+DAY(E11))))))","v":"1906-12-28"},78]
[8,"Лопасть НВ","8АТ-2710-00",null,null,null,null,null,null,null,2000,7,null,null,null,0,null,2395,0,1,{"$f":"IF(OR(AND(NOT(ISBLANK(F12)),L12>0,N12>0,E12+L12*365>F12+N12*365),AND(NOT(ISBLANK(F12)),ISBLANK(L12),N12>0)),F12+N12*365+IF(DAY(F12)>=DAY(F12+N12*365),DAY(F12)-DAY(F12+N12*365),IF(OR(EXACT(MONTH(F12),$V$34:$V$35)),31-DAY(F12+N12*365)+DAY(F12),IF(OR(EXACT(MONTH(F12),$W$34:$W$35)),30-DAY(F12+N12*365)+DAY(F12),28-DAY(F12+N12*365)+DAY(F12)))),IF(AND(ISBLANK(F12),OR(ISBLANK(L12),N12>0)),E12+N12*365+IF(DAY(E12)>=DAY(E12+N12*365),DAY(E12)-DAY(E12+N12*365),IF(OR(EXACT(MONTH(E12),$V$34:$V$35)),31-DAY(E12+N12*365)+DAY(E12),IF(OR(EXACT(MONTH(E12),$W$34:$W$35)),30-DAY(E12+N12*365)+DAY(E12),28-DAY(E12+N12*365)+DAY(E12)))),E12+L12*365+IF(DAY(E12)>=DAY(E12+365*L12),DAY(E12)-DAY(E12+L12*365),IF(OR(EXACT(MONTH(E12),$V$34:$V$35)),31-DAY(E12+L12*365)+DAY(E12),IF(OR(EXACT(MONTH(E12),$W$34:$W$35)),30-DAY(E12+L12*365)+DAY(E12),28-DAY(E12+L12*365)+DAY(E12))))))","v":"1906-12-28"},78]

{"sheet":"79","index":1,"n_rows":8,"n_cols":25,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,3,2,3],[1,4,2,4],[1,20,2,20],[1,21,2,21],[4,0,4,20],[1,8,2,8],[1,9,2,9],[1,10,1,11],[1,12,1,13],[1,14,1,15],[1,16,2,16],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,17,1,18],[1,19,2,19],[1,0,2,0],[1,1,2,1],[1,2,2,2]]}
[]
["№","Наименование агрегата","Чертёжный номер","Заводской номер","Дата выпуска","Дата ремонта","Место ремонта","Количество ремонтов","Гарантия до","дата установки агрегата на вертолет","Назнач. ресурс",null,"Межрем. ресурс",null,"Наработка до установки",null,"Наработка вертолёта при установке агрегата","Наработка ",null,"Остаток ресурса час.","Дата снятия агрегата по выработке ресурса ","Бортовой номер вертолета"]
[null,null,null,null,null,null,null,null,null,null,"часов","лет","часов","лет","ППР","СНЭ",null,"СНЭ","ППР"]
[]
["Вертолет 79",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79,"ВиД","АО","РЭО"]
[1,"Автомат перекоса","8-1950-000",null,null,null,null,1,null,null,6000,null,1000,8,0,1396,null,{"$f":"SUM(R$7,-Q6,P6)","v":2395},{"$f":"IF(ISBLANK(O6),0,SUM(R$7,-Q6,O6))","v":999},{"$f":"IF(ISBLANK(M6),K6-R6,IF(AND(ISBLANK(F6),K6-R6>M6-R6),M6-R6,IF(AND(ISNONTEXT(F6),K6-R6>M6-S6),M6-S6,K6-R6)))","v":1},{"$f":"IF(OR(AND(NOT(ISBLANK(F6)),L6>0,N6>0,E6+L6*365>F6+N6*365),AND(NOT(ISBLANK(F6)),ISBLANK(L6),N6>0)),F6+N6*365+IF(DAY(F6)>=DAY(F6+N6*365),DAY(F6)-DAY(F6+N6*365),IF(OR(EXACT(MONTH(F6),$V$29:$V$30)),31-DAY(F6+N6*365)+DAY(F6),IF(OR(EXACT(MONTH(F6),$W$29:$W$30)),30-DAY(F6+N6*365)+DAY(F6),28-DAY(F6+N6*365)+DAY(F6)))),IF(AND(ISBLANK(F6),OR(ISBLANK(L6),N6>0)),E6+N6*365+IF(DAY(E6)>=DAY(E6+N6*365),DAY(E6)-DAY(E6+N6*365),IF(OR(EXACT(MONTH(E6),$V$29:$V$30)),31-DAY(E6+N6*365)+DAY(E6),IF(OR(EXACT(MONTH(E6),$W$29:$W$30)),30-DAY(E6+N6*365)+DAY(E6),28-DAY(E6+N6*365)+DAY(E6)))),E6+L6*365+IF(DAY(E6)>=DAY(E6+365*L6),DAY(E6)-DAY(E6+L6*365),IF(OR(EXACT(MONTH(E6),$V$29:$V$30)),31-DAY(E6+L6*365)+DAY(E6),IF(OR(EXACT(MONTH(E6),$W$29:$W$30)),30-DAY(E6+L6*365)+DAY(E6),28-DAY(E6+L6*365)+DAY(E6))))))","v":"1907-12-28"},79]
[2,"Гл. редуктор","ВР-14",null,null,null,null,null,null,null,8000,null,2000,10,null,null,null,999,0,1001,{"$f":"IF(OR(AND(NOT(ISBLANK(F7)),L7>0,N7>0,E7+L7*365>F7+N7*365),AND(NOT(ISBLANK(F7)),ISBLANK(L7),N7>0)),F7+N7*365+IF(DAY(F7)>=DAY(F7+N7*365),DAY(F7)-DAY(F7+N7*365),IF(OR(EXACT(MONTH(F7),$V$29:$V$30)),31-DAY(F7+N7*365)+DAY(F7),IF(OR(EXACT(MONTH(F7),$W$29:$W$30)),30-DAY(F7+N7*365)+DAY(F7),28-DAY(F7+N7*365)+DAY(F7)))),IF(AND(ISBLANK(F7),OR(ISBLANK(L7),N7>0)),E7+N7*365+IF(DAY(E7)>=DAY(E7+N7*365),DAY(E7)-DAY(E7+N7*365),IF(OR(EXACT(MONTH(E7),$V$29:$V$30)),31-DAY(E7+N7*365)+DAY(E7),IF(OR(EXACT(MONTH(E7),$W$29:$W$30)),30-DAY(E7+N7*365)+DAY(E7),28-DAY(E7+N7*365)+DAY(E7)))),E7+L7*365+IF(DAY(E7)>=DAY(E7+365*L7),DAY(E7)-DAY(E7+L7*365),IF(OR(EXACT(MONTH(E7),$V$29:$V$30)),31-DAY(E7+L7*365)+DAY(E7),IF(OR(EXACT(MONTH(E7),$W$29:$W$30)),30-DAY(E7+L7*365)+DAY(E7),28-DAY(E7+L7*365)+DAY(E7))))))","v":"1909-12-28"},79]
[3,"Компрессор АК-50","АК-50Т1сер3",null,null,null,null,null,null,null,2250,null,750,6,null,236,null,515,0,235,{"$f":"IF(OR(AND(NOT(ISBLANK(F8)),L8>0,N8>0,E8+L8*365>F8+N8*365),AND(NOT(ISBLANK(F8)),ISBLANK(L8),N8>0)),F8+N8*365+IF(DAY(F8)>=DAY(F8+N8*365),DAY(F8)-DAY(F8+N8*365),IF(OR(EXACT(MONTH(F8),$V$29:$V$30)),31-DAY(F8+N8*365)+DAY(F8),IF(OR(EXACT(MONTH(F8),$W$29:$W$30)),30-DAY(F8+N8*365)+DAY(F8),28-DAY(F8+N8*365)+DAY(F8)))),IF(AND(ISBLANK(F8),OR(ISBLANK(L8),N8>0)),E8+N8*365+IF(DAY(E8)>=DAY(E8+N8*365),DAY(E8)-DAY(E8+N8*365),IF(OR(EXACT(MONTH(E8),$V$29:$V$30)),31-DAY(E8+N8*365)+DAY(E8),IF(OR(EXACT(MONTH(E8),$W$29:$W$30)),30-DAY(E8+N8*365)+DAY(E8),28-DAY(E8+N8*365)+DAY(E8)))),E8+L8*365+IF(DAY(E8)>=DAY(E8+365*L8),DAY(E8)-DAY(E8+L8*365),IF(OR(EXACT(MONTH(E8),$V$29:$V$30)),31-DAY(E8+L8*365)+DAY(E8),IF(OR(EXACT(MONTH(E8),$W$29:$W$30)),30-DAY(E8+L8*365)+DAY(E8),28-DAY(E8+L8*365)+DAY(E8))))))","v":"1905-12-28"},79]

{"sheet":"77","index":2,"n_rows":10,"n_cols":22,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,3,2,3],[1,4,2,4],[1,20,2,20],[1,21,2,21],[4,0,4,20],[1,8,2,8],[1,9,2,9],[1,10,1,11],[1,12,1,13],[1,14,1,15],[1,16,2,16],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,17,1,18],[1,19,2,19],[1,0,2,0],[1,1,2,1],[1,2,2,2]]}
[]
["№","Наименование агрегата","Чертёжный номер","Заводской номер","Дата выпуска","Дата ремонта","Место ремонта","Количество ремонтов","Гарантия до","дата установки агрегата на вертолет","Назнач. ресурс",null,"Межрем. ресурс",null,"Наработка до установки",null,"Наработка вертолёта при установке агрегата","Наработка ",null,"Остаток ресурса час.","Дата снятия агрегата по выработке ресурса ","Бортовой номер вертолета"]
[null,null,null,null,null,null,null,null,null,null,"часов","лет","часов","лет","ППР","СНЭ",null,"СНЭ","ППР"]
[]
["Вертолет 77",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77]
[1,"Г/усилитель","РА-60Б",null,null,null,null,2,null,null,9000,40,1500,15,0,2042,2520,{"$f":"SUM(R$14,-Q6,P6)","v":-478},{"$f":"IF(ISBLANK(O6),0,SUM(R$14,-Q6,O6))","v":-2520},{"$f":"IF(ISBLANK(M6),K6-R6,IF(AND(ISBLANK(F6),K6-R6>M6-R6),M6-R6,IF(AND(ISNONTEXT(F6),K6-R6>M6-S6),M6-S6,K6-R6)))","v":1978},{"$f":"IF(OR(AND(NOT(ISBLANK(F6)),L6>0,N6>0,E6+L6*365>F6+N6*365),AND(NOT(ISBLANK(F6)),ISBLANK(L6),N6>0)),F6+N6*365+IF(DAY(F6)>=DAY(F6+N6*365),DAY(F6)-DAY(F6+N6*365),IF(OR(EXACT(MONTH(F6),$V$36:$V$37)),31-DAY(F6+N6*365)+DAY(F6),IF(OR(EXACT(MONTH(F6),$W$36:$W$37)),30-DAY(F6+N6*365)+DAY(F6),28-DAY(F6+N6*365)+DAY(F6)))),IF(AND(ISBLANK(F6),OR(ISBLANK(L6),N6>0)),E6+N6*365+IF(DAY(E6)>=DAY(E6+N6*365),DAY(E6)-DAY(E6+N6*365),IF(OR(EXACT(MONTH(E6),$V$36:$V$37)),31-DAY(E6+N6*365)+DAY(E6),IF(OR(EXACT(MONTH(E6),$W$36:$W$37)),30-DAY(E6+N6*365)+DAY(E6),28-DAY(E6+N6*365)+DAY(E6)))),E6+L6*365+IF(DAY(E6)>=DAY(E6+365*L6),DAY(E6)-DAY(E6+L6*365),IF(OR(EXACT(MONTH(E6),$V$36:$V$37)),31-DAY(E6+L6*365)+DAY(E6),IF(OR(EXACT(MONTH(E6),$W$36:$W$37)),30-DAY(E6+L6*365)+DAY(E6),28-DAY(E6+L6*365)+DAY(E6))))))","v":"1914-12-28"},77]
[2,"Вентилятор","8А-6311-00",null,null,null,null,3,null,null,6500,null,1500,15,0,2276,2520,-244,-2520,1744,{"$f":"IF(OR(AND(NOT(ISBLANK(F7)),L7>0,N7>0,E7+L7*365>F7+N7*365),AND(NOT(ISBLANK(F7)),ISBLANK(L7),N7>0)),F7+N7*365+IF(DAY(F7)>=DAY(F7+N7*365),DAY(F7)-DAY(F7+N7*365),IF(OR(EXACT(MONTH(F7),$V$36:$V$37)),31-DAY(F7+N7*365)+DAY(F7),IF(OR(EXACT(MONTH(F7),$W$36:$W$37)),30-DAY(F7+N7*365)+DAY(F7),28-DAY(F7+N7*365)+DAY(F7)))),IF(AND(ISBLANK(F7),OR(ISBLANK(L7),N7>0)),E7+N7*365+IF(DAY(E7)>=DAY(E7+N7*365),DAY(E7)-DAY(E7+N7*365),IF(OR(EXACT(MONTH(E7),$V$36:$V$37)),31-DAY(E7+N7*365)+DAY(E7),IF(OR(EXACT(MONTH(E7),$W$36:$W$37)),30-DAY(E7+N7*365)+DAY(E7),28-DAY(E7+N7*365)+DAY(E7)))),E7+L7*365+IF(DAY(E7)>=DAY(E7+365*L7),DAY(E7)-DAY(E7+L7*365),IF(OR(EXACT(MONTH(E7),$V$36:$V$37)),31-DAY(E7+L7*365)+DAY(E7),IF(OR(EXACT(MONTH(E7),$W$36:$W$37)),30-DAY(E7+L7*365)+DAY(E7),28-DAY(E7+L7*365)+DAY(E7))))))","v":"1914-12-28"},77]
[3,"КВПВ","8А-6314-00",null,null,null,null,3,null,null,4500,null,1500,15,0,2871,2520,351,-2520,1149,{"$f":"IF(OR(AND(NOT(ISBLANK(F8)),L8>0,N8>0,E8+L8*365>F8+N8*365),AND(NOT(ISBLANK(F8)),ISBLANK(L8),N8>0)),F8+N8*365+IF(DAY(F8)>=DAY(F8+N8*365),DAY(F8)-DAY(F8+N8*365),IF(OR(EXACT(MONTH(F8),$V$36:$V$37)),31-DAY(F8+N8*365)+DAY(F8),IF(OR(EXACT(MONTH(F8),$W$36:$W$37)),30-DAY(F8+N8*365)+DAY(F8),28-DAY(F8+N8*365)+DAY(F8)))),IF(AND(ISBLANK(F8),OR(ISBLANK(L8),N8>0)),E8+N8*365+IF(DAY(E8)>=DAY(E8+N8*365),DAY(E8)-DAY(E8+N8*365),IF(OR(EXACT(MONTH(E8),$V$36:$V$37)),31-DAY(E8+N8*365)+DAY(E8),IF(OR(EXACT(MONTH(E8),$W$36:$W$37)),30-DAY(E8+N8*365)+DAY(E8),28-DAY(E8+N8*365)+DAY(E8)))),E8+L8*365+IF(DAY(E8)>=DAY(E8+365*L8),DAY(E8)-DAY(E8+L8*365),IF(OR(EXACT(MONTH(E8),$V$36:$V$37)),31-DAY(E8+L8*365)+DAY(E8),IF(OR(EXACT(MONTH(E8),$W$36:$W$37)),30-DAY(E8+L8*365)+DAY(E8),28-DAY(E8+L8*365)+DAY(E8))))))","v":"1914-12-28"},77]
[4,"Хв. Вал","8А-1516-000",null,null,null,null,3,null,null,6000,null,2000,14,0,3182,2520,662,-2520,1338,{"$f":"IF(OR(AND(NOT(ISBLANK(F9)),L9>0,N9>0,E9+L9*365>F9+N9*365),AND(NOT(ISBLANK(F9)),ISBLANK(L9),N9>0)),F9+N9*365+IF(DAY(F9)>=DAY(F9+N9*365),DAY(F9)-DAY(F9+N9*365),IF(OR(EXACT(MONTH(F9),$V$36:$V$37)),31-DAY(F9+N9*365)+DAY(F9),IF(OR(EXACT(MONTH(F9),$W$36:$W$37)),30-DAY(F9+N9*365)+DAY(F9),28-DAY(F9+N9*365)+DAY(F9)))),IF(AND(ISBLANK(F9),OR(ISBLANK(L9),N9>0)),E9+N9*365+IF(DAY(E9)>=DAY(E9+N9*365),DAY(E9)-DAY(E9+N9*365),IF(OR(EXACT(MONTH(E9),$V$36:$V$37)),31-DAY(E9+N9*365)+DAY(E9),IF(OR(EXACT(MONTH(E9),$W$36:$W$37)),30-DAY(E9+N9*365)+DAY(E9),28-DAY(E9+N9*365)+DAY(E9)))),E9+L9*365+IF(DAY(E9)>=DAY(E9+365*L9),DAY(E9)-DAY(E9+L9*365),IF(OR(EXACT(MONTH(E9),$V$36:$V$37)),31-DAY(E9+L9*365)+DAY(E9),IF(OR(EXACT(MONTH(E9),$W$36:$W$37)),30-DAY(E9+L9*365)+DAY(E9),28-DAY(E9+L9*365)+DAY(E9))))))","v":"1913-12-28"},77]
[5,"Пром. редуктор","8А-1515-000",null,null,null,null,3,null,null,6000,null,2000,15,0,1864,2520,-656,-2520,2656,{"$f":"IF(OR(AND(NOT(ISBLANK(F10)),L10>0,N10>0,E10+L10*365>F10+N10*365),AND(NOT(ISBLANK(F10)),ISBLANK(L10),N10>0)),F10+N10*365+IF(DAY(F10)>=DAY(F10+N10*365),DAY(F10)-DAY(F10+N10*365),IF(OR(EXACT(MONTH(F10),$V$36:$V$37)),31-DAY(F10+N10*365)+DAY(F10),IF(OR(EXACT(MONTH(F10),$W$36:$W$37)),30-DAY(F10+N10*365)+DAY(F10),28-DAY(F10+N10*365)+DAY(F10)))),IF(AND(ISBLANK(F10),OR(ISBLANK(L10),N10>0)),E10+N10*365+IF(DAY(E10)>=DAY(E10+N10*365),DAY(E10)-DAY(E10+N10*365),IF(OR(EXACT(MONTH(E10),$V$36:$V$37)),31-DAY(E10+N10*365)+DAY(E10),IF(OR(EXACT(MONTH(E10),$W$36:$W$37)),30-DAY(E10+N10*365)+DAY(E10),28-DAY(E10+N10*365)+DAY(E10)))),E10+L10*365+IF(DAY(E10)>=DAY(E10+365*L10),DAY(E10)-DAY(E10+L10*365),IF(OR(EXACT(MONTH(E10),$V$36:$V$37)),31-DAY(E10+L10*365)+DAY(E10),IF(OR(EXACT(MONTH(E10),$W$36:$W$37)),30-DAY(E10+L10*365)+DAY(E10),28-DAY(E10+L10*365)+DAY(E10))))))","v":"1914-12-28"},77]

{"sheet":"75","index":3,"n_rows":9,"n_cols":22,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,3,2,3],[1,4,2,4],[1,20,2,20],[1,21,2,21],[4,0,4,20],[1,10,1,11],[1,12,1,13],[1,14,1,15],[1,16,2,16],[1,8,2,8],[1,9,2,9],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,17,1,18],[1,19,2,19],[1,0,2,0],[1,1,2,1],[1,2,2,2]]}
[]
["№","Наименование агрегата","Чертёжный номер","Заводской номер","Дата выпуска","Дата ремонта","Место ремонта","Количество ремонтов","Гарантия до","дата установки агрегата на вертолет","Назнач. ресурс",null,"Межрем. ресурс",null,"Наработка до установки",null,"Наработка вертолёта при установке агрегата","Наработка ",null,"Остаток ресурса час.","Дата снятия агрегата по выработке ресурса ","Бортовой номер вертолета"]
[null,null,null,null,null,null,null,null,null,null,"часов","лет","часов","лет","ППР","СНЭ",null,"СНЭ","ППР"]
[]
["Вертолет 75"]
[1,"Компрессор АК-50","АК-50Т1сер3",null,null,null,null,null,null,null,2250,null,750,6,null,null,null,{"$f":"SUM(R$7,-Q6,P6)","v":2248},{"$f":"IF(ISBLANK(O6),0,SUM(R$7,-Q6,O6))","v":0},{"$f":"IF(ISBLANK(M6),K6-R6,IF(AND(ISBLANK(F6),K6-R6>M6-R6),M6-R6,IF(AND(ISNONTEXT(F6),K6-R6>M6-S6),M6-S6,K6-R6)))","v":-1498},{"$f":"IF(OR(AND(NOT(ISBLANK(F6)),L6>0,N6>0,E6+L6*365>F6+N6*365),AND(NOT(ISBLANK(F6)),ISBLANK(L6),N6>0)),F6+N6*365+IF(DAY(F6)>=DAY(F6+N6*365),DAY(F6)-DAY(F6+N6*365),IF(OR(EXACT(MONTH(F6),$V$20:$V$21)),31-DAY(F6+N6*365)+DAY(F6),IF(OR(EXACT(MONTH(F6),$W$20:$W$21)),30-DAY(F6+N6*365)+DAY(F6),28-DAY(F6+N6*365)+DAY(F6)))),IF(AND(ISBLANK(F6),OR(ISBLANK(L6),N6>0)),E6+N6*365+IF(DAY(E6)>=DAY(E6+N6*365),DAY(E6)-DAY(E6+N6*365),IF(OR(EXACT(MONTH(E6),$V$20:$V$21)),31-DAY(E6+N6*365)+DAY(E6),IF(OR(EXACT(MONTH(E6),$W$20:$W$21)),30-DAY(E6+N6*365)+DAY(E6),28-DAY(E6+N6*365)+DAY(E6)))),E6+L6*365+IF(DAY(E6)>=DAY(E6+365*L6),DAY(E6)-DAY(E6+L6*365),IF(OR(EXACT(MONTH(E6),$V$20:$V$21)),31-DAY(E6+L6*365)+DAY(E6),IF(OR(EXACT(MONTH(E6),$W$20:$W$21)),30-DAY(E6+L6*365)+DAY(E6),28-DAY(E6+L6*365)+DAY(E6))))))","v":"1905-12-28"},75]
[2,"Г/усилитель","КАУ-30Б",null,null,null,null,null,null,null,9000,40,1500,15,null,null,null,2248,0,-748,{"$f":"IF(OR(AND(NOT(ISBLANK(F7)),L7>0,N7>0,E7+L7*365>F7+N7*365),AND(NOT(ISBLANK(F7)),ISBLANK(L7),N7>0)),F7+N7*365+IF(DAY(F7)>=DAY(F7+N7*365),DAY(F7)-DAY(F7+N7*365),IF(OR(EXACT(MONTH(F7),$V$20:$V$21)),31-DAY(F7+N7*365)+DAY(F7),IF(OR(EXACT(MONTH(F7),$W$20:$W$21)),30-DAY(F7+N7*365)+DAY(F7),28-DAY(F7+N7*365)+DAY(F7)))),IF(AND(ISBLANK(F7),OR(ISBLANK(L7),N7>0)),E7+N7*365+IF(DAY(E7)>=DAY(E7+N7*365),DAY(E7)-DAY(E7+N7*365),IF(OR(EXACT(MONTH(E7),$V$20:$V$21)),31-DAY(E7+N7*365)+DAY(E7),IF(OR(EXACT(MONTH(E7),$W$20:$W$21)),30-DAY(E7+N7*365)+DAY(E7),28-DAY(E7+N7*365)+DAY(E7)))),E7+L7*365+IF(DAY(E7)>=DAY(E7+365*L7),DAY(E7)-DAY(E7+L7*365),IF(OR(EXACT(MONTH(E7),$V$20:$V$21)),31-DAY(E7+L7*365)+DAY(E7),IF(OR(EXACT(MONTH(E7),$W$20:$W$21)),30-DAY(E7+L7*365)+DAY(E7),28-DAY(E7+L7*365)+DAY(E7))))))","v":"1914-12-28"},75]
[3,"Г/усилитель","КАУ-30Б",null,null,null,null,null,null,null,9000,40,1500,10,null,null,null,2248,0,-748,{"$f":"IF(OR(AND(NOT(ISBLANK(F8)),L8>0,N8>0,E8+L8*365>F8+N8*365),AND(NOT(ISBLANK(F8)),ISBLANK(L8),N8>0)),F8+N8*365+IF(DAY(F8)>=DAY(F8+N8*365),DAY(F8)-DAY(F8+N8*365),IF(OR(EXACT(MONTH(F8),$V$20:$V$21)),31-DAY(F8+N8*365)+DAY(F8),IF(OR(EXACT(MONTH(F8),$W$20:$W$21)),30-DAY(F8+N8*365)+DAY(F8),28-DAY(F8+N8*365)+DAY(F8)))),IF(AND(ISBLANK(F8),OR(ISBLANK(L8),N8>0)),E8+N8*365+IF(DAY(E8)>=DAY(E8+N8*365),DAY(E8)-DAY(E8+N8*365),IF(OR(EXACT(MONTH(E8),$V$20:$V$21)),31-DAY(E8+N8*365)+DAY(E8),IF(OR(EXACT(MONTH(E8),$W$20:$W$21)),30-DAY(E8+N8*365)+DAY(E8),28-DAY(E8+N8*365)+DAY(E8)))),E8+L8*365+IF(DAY(E8)>=DAY(E8+365*L8),DAY(E8)-DAY(E8+L8*365),IF(OR(EXACT(MONTH(E8),$V$20:$V$21)),31-DAY(E8+L8*365)+DAY(E8),IF(OR(EXACT(MONTH(E8),$W$20:$W$21)),30-DAY(E8+L8*365)+DAY(E8),28-DAY(E8+L8*365)+DAY(E8))))))","v":"1909-12-28"},75]
[4,"Г/усилитель","КАУ-30Б",null,null,null,null,null,null,null,9000,40,1500,15,null,null,null,2248,0,-748,{"$f":"IF(OR(AND(NOT(ISBLANK(F9)),L9>0,N9>0,E9+L9*365>F9+N9*365),AND(NOT(ISBLANK(F9)),ISBLANK(L9),N9>0)),F9+N9*365+IF(DAY(F9)>=DAY(F9+N9*365),DAY(F9)-DAY(F9+N9*365),IF(OR(EXACT(MONTH(F9),$V$20:$V$21)),31-DAY(F9+N9*365)+DAY(F9),IF(OR(EXACT(MONTH(F9),$W$20:$W$21)),30-DAY(F9+N9*365)+DAY(F9),28-DAY(F9+N9*365)+DAY(F9)))),IF(AND(ISBLANK(F9),OR(ISBLANK(L9),N9>0)),E9+N9*365+IF(DAY(E9)>=DAY(E9+N9*365),DAY(E9)-DAY(E9+N9*365),IF(OR(EXACT(MONTH(E9),$V$20:$V$21)),31-DAY(E9+N9*365)+DAY(E9),IF(OR(EXACT(MONTH(E9),$W$20:$W$21)),30-DAY(E9+N9*365)+DAY(E9),28-DAY(E9+N9*365)+DAY(E9)))),E9+L9*365+IF(DAY(E9)>=DAY(E9+365*L9),DAY(E9)-DAY(E9+L9*365),IF(OR(EXACT(MONTH(E9),$V$20:$V$21)),31-DAY(E9+L9*365)+DAY(E9),IF(OR(EXACT(MONTH(E9),$W$20:$W$21)),30-DAY(E9+L9*365)+DAY(E9),28-DAY(E9+L9*365)+DAY(E9))))))","v":"1914-12-28"},75]

{"sheet":"общ","index":4,"n_rows":24,"n_cols":22,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,17,2,18],[2,19,3,19],[2,20,3,20],[2,21,3,21],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[2,7,3,7],[2,8,3,8],[2,9,3,9],[2,10,2,11],[2,12,2,13],[2,14,2,15],[2,16,3,16]]}
[]
[]
["№","Наименование агрегата","Чертёжный номер","Заводской номер","Дата выпуска","Дата ремонта","Место ремонта","Количество ремонтов","Гарантия до","дата установки агрегата на вертолет","Назнач. ресурс",null,"Межрем. ресурс",null,"Наработка до установки",null,"Наработка вертолёта при установке агрегата","Наработка ",null,"Остаток ресурса час.","Дата снятия агрегата по выработке ресурса ","Бортовой номер вертолета"]
[null,null,null,null,null,null,null,null,null,null,"часов","лет","часов","лет","ППР","СНЭ",null,"СНЭ","ППР"]
[]
[1,"Двигатель","ТВ3-117МТ",null,null,null,null,null,null,null,4500,null,1143,12,0,655,null,2395,999,1,"1911-12-28",78]
[2,"Двигатель","ТВ3-117МТ",null,null,null,null,null,null,null,4500,null,1500,12,0,875,null,999,999,1,"1911-12-28",78]
[4,"Лопасть НВ","8АТ-2710-00",null,null,null,null,null,null,null,2000,7,null,null,null,0,null,515,0,1,"1906-12-28",78]
[5,"Лопасть НВ","8АТ-2710-00",null,null,null,null,null,null,null,2000,7,null,null,null,0,null,2395,0,1,"1906-12-28",78]
[6,"Лопасть НВ","8АТ-2710-00",null,null,null,null,null,null,null,2000,7,null,null,null,0,null,999,0,1,"1906-12-28",78]
[7,"Лопасть НВ","8АТ-2710-00",null,null,null,null,null,null,null,2000,7,null,null,null,0,null,515,0,1,"1906-12-28",78]
[8,"Лопасть НВ","8АТ-2710-00",null,null,null,null,null,null,null,2000,7,null,null,null,0,null,2395,0,1,"1906-12-28",78]
[1,"Автомат перекоса","8-1950-000",null,null,null,null,1,null,null,6000,null,1000,8,0,1396,null,2395,999,1,"1907-12-28",79]
[2,"Гл. редуктор","ВР-14",null,null,null,null,null,null,null,8000,null,2000,10,null,null,null,999,0,1001,"1909-12-28",79]
[3,"Компрессор АК-50","АК-50Т1сер3",null,null,null,null,null,null,null,2250,null,750,6,null,236,null,515,0,235,"1905-12-28",79]
[1,"Г/усилитель","РА-60Б",null,null,null,null,2,null,null,9000,40,1500,15,0,2042,2520,-478,-2520,1978,"1914-12-28",77]
[2,"Вентилятор","8А-6311-00",null,null,null,null,3,null,null,6500,null,1500,15,0,2276,2520,-244,-2520,1744,"1914-12-28",77]
[3,"КВПВ","8А-6314-00",null,null,null,null,3,null,null,4500,null,1500,15,0,2871,2520,351,-2520,1149,"1914-12-28",77]
[4,"Хв. Вал","8А-1516-000",null,null,null,null,3,null,null,6000,null,2000,14,0,3182,2520,662,-2520,1338,"1913-12-28",77]
[5,"Пром. редуктор","8А-1515-000",null,null,null,null,3,null,null,6000,null,2000,15,0,1864,2520,-656,-2520,2656,"1914-12-28",77]
[1,"Компрессор АК-50","АК-50Т1сер3",null,null,null,null,null,null,null,2250,null,750,6,null,null,null,2248,0,-1498,"1905-12-28",75]
[2,"Г/усилитель","КАУ-30Б",null,null,null,null,null,null,null,9000,40,1500,15,null,null,null,2248,0,-748,"1914-12-28",75]
[3,"Г/усилитель","КАУ-30Б",null,null,null,null,null,null,null,9000,40,1500,10,null,null,null,2248,0,-748,"1909-12-28",75]
[4,"Г/усилитель","КАУ-30Б",null,null,null,null,null,null,null,9000,40,1500,15,null,null,null,2248,0,-748,"1914-12-28",75]