{"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":16,"n_cols":23,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,5,2,5],[1,21,2,21],[1,22,2,22],[4,1,4,21],[1,9,2,9],[1,10,2,10],[1,11,1,12],[1,13,1,14],[1,15,1,16],[1,17,2,17],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,18,1,19],[1,20,2,20],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,0,2,0],[1,4,2,4]]}
[]
["Новые данные (+)","№","Наименование агрегата","Чертёжный номер","Заводской номер","Дата выпуска","Дата ремонта","Место ремонта","Количество ремонтов","Гарантия до","дата установки агрегата на вертолет","Назнач. ресурс",null,"Межрем. ресурс",null,"Наработка до установки",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]
[null,1,"Двигатель","ТВ3-117МТ",null,null,null,null,null,null,null,4500,null,1143,12,0,655,null,{"$f":"SUM(S$7,-R6,Q6)","v":2395},{"$f":"IF(ISBLANK(P6),0,SUM(S$7,-R6,P6))","v":999},{"$f":"IF(ISBLANK(N6),L6-S6,IF(AND(ISBLANK(G6),L6-S6>N6-S6),N6-S6,IF(AND(ISNONTEXT(G6),L6-S6>N6-T6),N6-T6,L6-S6)))","v":1},{"$f":"IF(OR(AND(NOT(ISBLANK(G6)),M6>0,O6>0,F6+M6*365>G6+O6*365),AND(NOT(ISBLANK(G6)),ISBLANK(M6),O6>0)),G6+O6*365+IF(DAY(G6)>=DAY(G6+O6*365),DAY(G6)-DAY(G6+O6*365),IF(OR(EXACT(MONTH(G6),$W$34:$W$35)),31-DAY(G6+O6*365)+DAY(G6),IF(OR(EXACT(MONTH(G6),$X$34:$X$35)),30-DAY(G6+O6*365)+DAY(G6),28-DAY(G6+O6*365)+DAY(G6)))),IF(AND(ISBLANK(G6),OR(ISBLANK(M6),O6>0)),F6+O6*365+IF(DAY(F6)>=DAY(F6+O6*365),DAY(F6)-DAY(F6+O6*365),IF(OR(EXACT(MONTH(F6),$W$34:$W$35)),31-DAY(F6+O6*365)+DAY(F6),IF(OR(EXACT(MONTH(F6),$X$34:$X$35)),30-DAY(F6+O6*365)+DAY(F6),28-DAY(F6+O6*365)+DAY(F6)))),F6+M6*365+IF(DAY(F6)>=DAY(F6+365*M6),DAY(F6)-DAY(F6+M6*365),IF(OR(EXACT(MONTH(F6),$W$34:$W$35)),31-DAY(F6+M6*365)+DAY(F6),IF(OR(EXACT(MONTH(F6),$X$34:$X$35)),30-DAY(F6+M6*365)+DAY(F6),28-DAY(F6+M6*365)+DAY(F6))))))","v":"1911-12-28"},78]
[null,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(G7)),M7>0,O7>0,F7+M7*365>G7+O7*365),AND(NOT(ISBLANK(G7)),ISBLANK(M7),O7>0)),G7+O7*365+IF(DAY(G7)>=DAY(G7+O7*365),DAY(G7)-DAY(G7+O7*365),IF(OR(EXACT(MONTH(G7),$W$34:$W$35)),31-DAY(G7+O7*365)+DAY(G7),IF(OR(EXACT(MONTH(G7),$X$34:$X$35)),30-DAY(G7+O7*365)+DAY(G7),28-DAY(G7+O7*365)+DAY(G7)))),IF(AND(ISBLANK(G7),OR(ISBLANK(M7),O7>0)),F7+O7*365+IF(DAY(F7)>=DAY(F7+O7*365),DAY(F7)-DAY(F7+O7*365),IF(OR(EXACT(MONTH(F7),$W$34:$W$35)),31-DAY(F7+O7*365)+DAY(F7),IF(OR(EXACT(MONTH(F7),$X$34:$X$35)),30-DAY(F7+O7*365)+DAY(F7),28-DAY(F7+O7*365)+DAY(F7)))),F7+M7*365+IF(DAY(F7)>=DAY(F7+365*M7),DAY(F7)-DAY(F7+M7*365),IF(OR(EXACT(MONTH(F7),$W$34:$W$35)),31-DAY(F7+M7*365)+DAY(F7),IF(OR(EXACT(MONTH(F7),$X$34:$X$35)),30-DAY(F7+M7*365)+DAY(F7),28-DAY(F7+M7*365)+DAY(F7))))))","v":"1911-12-28"},78]
[null,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(G8)),M8>0,O8>0,F8+M8*365>G8+O8*365),AND(NOT(ISBLANK(G8)),ISBLANK(M8),O8>0)),G8+O8*365+IF(DAY(G8)>=DAY(G8+O8*365),DAY(G8)-DAY(G8+O8*365),IF(OR(EXACT(MONTH(G8),$W$34:$W$35)),31-DAY(G8+O8*365)+DAY(G8),IF(OR(EXACT(MONTH(G8),$X$34:$X$35)),30-DAY(G8+O8*365)+DAY(G8),28-DAY(G8+O8*365)+DAY(G8)))),IF(AND(ISBLANK(G8),OR(ISBLANK(M8),O8>0)),F8+O8*365+IF(DAY(F8)>=DAY(F8+O8*365),DAY(F8)-DAY(F8+O8*365),IF(OR(EXACT(MONTH(F8),$W$34:$W$35)),31-DAY(F8+O8*365)+DAY(F8),IF(OR(EXACT(MONTH(F8),$X$34:$X$35)),30-DAY(F8+O8*365)+DAY(F8),28-DAY(F8+O8*365)+DAY(F8)))),F8+M8*365+IF(DAY(F8)>=DAY(F8+365*M8),DAY(F8)-DAY(F8+M8*365),IF(OR(EXACT(MONTH(F8),$W$34:$W$35)),31-DAY(F8+M8*365)+DAY(F8),IF(OR(EXACT(MONTH(F8),$X$34:$X$35)),30-DAY(F8+M8*365)+DAY(F8),28-DAY(F8+M8*365)+DAY(F8))))))","v":"1906-12-28"},78]
[null,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(G9)),M9>0,O9>0,F9+M9*365>G9+O9*365),AND(NOT(ISBLANK(G9)),ISBLANK(M9),O9>0)),G9+O9*365+IF(DAY(G9)>=DAY(G9+O9*365),DAY(G9)-DAY(G9+O9*365),IF(OR(EXACT(MONTH(G9),$W$34:$W$35)),31-DAY(G9+O9*365)+DAY(G9),IF(OR(EXACT(MONTH(G9),$X$34:$X$35)),30-DAY(G9+O9*365)+DAY(G9),28-DAY(G9+O9*365)+DAY(G9)))),IF(AND(ISBLANK(G9),OR(ISBLANK(M9),O9>0)),F9+O9*365+IF(DAY(F9)>=DAY(F9+O9*365),DAY(F9)-DAY(F9+O9*365),IF(OR(EXACT(MONTH(F9),$W$34:$W$35)),31-DAY(F9+O9*365)+DAY(F9),IF(OR(EXACT(MONTH(F9),$X$34:$X$35)),30-DAY(F9+O9*365)+DAY(F9),28-DAY(F9+O9*365)+DAY(F9)))),F9+M9*365+IF(DAY(F9)>=DAY(F9+365*M9),DAY(F9)-DAY(F9+M9*365),IF(OR(EXACT(MONTH(F9),$W$34:$W$35)),31-DAY(F9+M9*365)+DAY(F9),IF(OR(EXACT(MONTH(F9),$X$34:$X$35)),30-DAY(F9+M9*365)+DAY(F9),28-DAY(F9+M9*365)+DAY(F9))))))","v":"1906-12-28"},78]
[null,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(G10)),M10>0,O10>0,F10+M10*365>G10+O10*365),AND(NOT(ISBLANK(G10)),ISBLANK(M10),O10>0)),G10+O10*365+IF(DAY(G10)>=DAY(G10+O10*365),DAY(G10)-DAY(G10+O10*365),IF(OR(EXACT(MONTH(G10),$W$34:$W$35)),31-DAY(G10+O10*365)+DAY(G10),IF(OR(EXACT(MONTH(G10),$X$34:$X$35)),30-DAY(G10+O10*365)+DAY(G10),28-DAY(G10+O10*365)+DAY(G10)))),IF(AND(ISBLANK(G10),OR(ISBLANK(M10),O10>0)),F10+O10*365+IF(DAY(F10)>=DAY(F10+O10*365),DAY(F10)-DAY(F10+O10*365),IF(OR(EXACT(MONTH(F10),$W$34:$W$35)),31-DAY(F10+O10*365)+DAY(F10),IF(OR(EXACT(MONTH(F10),$X$34:$X$35)),30-DAY(F10+O10*365)+DAY(F10),28-DAY(F10+O10*365)+DAY(F10)))),F10+M10*365+IF(DAY(F10)>=DAY(F10+365*M10),DAY(F10)-DAY(F10+M10*365),IF(OR(EXACT(MONTH(F10),$W$34:$W$35)),31-DAY(F10+M10*365)+DAY(F10),IF(OR(EXACT(MONTH(F10),$X$34:$X$35)),30-DAY(F10+M10*365)+DAY(F10),28-DAY(F10+M10*365)+DAY(F10))))))","v":"1906-12-28"},78]
[null,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(G11)),M11>0,O11>0,F11+M11*365>G11+O11*365),AND(NOT(ISBLANK(G11)),ISBLANK(M11),O11>0)),G11+O11*365+IF(DAY(G11)>=DAY(G11+O11*365),DAY(G11)-DAY(G11+O11*365),IF(OR(EXACT(MONTH(G11),$W$34:$W$35)),31-DAY(G11+O11*365)+DAY(G11),IF(OR(EXACT(MONTH(G11),$X$34:$X$35)),30-DAY(G11+O11*365)+DAY(G11),28-DAY(G11+O11*365)+DAY(G11)))),IF(AND(ISBLANK(G11),OR(ISBLANK(M11),O11>0)),F11+O11*365+IF(DAY(F11)>=DAY(F11+O11*365),DAY(F11)-DAY(F11+O11*365),IF(OR(EXACT(MONTH(F11),$W$34:$W$35)),31-DAY(F11+O11*365)+DAY(F11),IF(OR(EXACT(MONTH(F11),$X$34:$X$35)),30-DAY(F11+O11*365)+DAY(F11),28-DAY(F11+O11*365)+DAY(F11)))),F11+M11*365+IF(DAY(F11)>=DAY(F11+365*M11),DAY(F11)-DAY(F11+M11*365),IF(OR(EXACT(MONTH(F11),$W$34:$W$35)),31-DAY(F11+M11*365)+DAY(F11),IF(OR(EXACT(MONTH(F11),$X$34:$X$35)),30-DAY(F11+M11*365)+DAY(F11),28-DAY(F11+M11*365)+DAY(F11))))))","v":"1906-12-28"},78]
[null,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(G12)),M12>0,O12>0,F12+M12*365>G12+O12*365),AND(NOT(ISBLANK(G12)),ISBLANK(M12),O12>0)),G12+O12*365+IF(DAY(G12)>=DAY(G12+O12*365),DAY(G12)-DAY(G12+O12*365),IF(OR(EXACT(MONTH(G12),$W$34:$W$35)),31-DAY(G12+O12*365)+DAY(G12),IF(OR(EXACT(MONTH(G12),$X$34:$X$35)),30-DAY(G12+O12*365)+DAY(G12),28-DAY(G12+O12*365)+DAY(G12)))),IF(AND(ISBLANK(G12),OR(ISBLANK(M12),O12>0)),F12+O12*365+IF(DAY(F12)>=DAY(F12+O12*365),DAY(F12)-DAY(F12+O12*365),IF(OR(EXACT(MONTH(F12),$W$34:$W$35)),31-DAY(F12+O12*365)+DAY(F12),IF(OR(EXACT(MONTH(F12),$X$34:$X$35)),30-DAY(F12+O12*365)+DAY(F12),28-DAY(F12+O12*365)+DAY(F12)))),F12+M12*365+IF(DAY(F12)>=DAY(F12+365*M12),DAY(F12)-DAY(F12+M12*365),IF(OR(EXACT(MONTH(F12),$W$34:$W$35)),31-DAY(F12+M12*365)+DAY(F12),IF(OR(EXACT(MONTH(F12),$X$34:$X$35)),30-DAY(F12+M12*365)+DAY(F12),28-DAY(F12+M12*365)+DAY(F12))))))","v":"1906-12-28"},78]
[null,9,"Лопасть НВ","8АТ-2710-00",null,null,null,null,null,null,null,3000,7,null,null,null,0,null,{"$f":"SUM(S$7,-R13,Q13)","v":2395},{"$f":"IF(ISBLANK(P13),0,SUM(S$7,-R13,P13))","v":0},{"$f":"IF(ISBLANK(N13),L13-S13,IF(AND(ISBLANK(G13),L13-S13>N13-S13),N13-S13,IF(AND(ISNONTEXT(G13),L13-S13>N13-T13),N13-T13,L13-S13)))","v":1},{"$f":"IF(OR(AND(NOT(ISBLANK(G13)),M13>0,O13>0,F13+M13*365>G13+O13*365),AND(NOT(ISBLANK(G13)),ISBLANK(M13),O13>0)),G13+O13*365+IF(DAY(G13)>=DAY(G13+O13*365),DAY(G13)-DAY(G13+O13*365),IF(OR(EXACT(MONTH(G13),$W$34:$W$35)),31-DAY(G13+O13*365)+DAY(G13),IF(OR(EXACT(MONTH(G13),$X$34:$X$35)),30-DAY(G13+O13*365)+DAY(G13),28-DAY(G13+O13*365)+DAY(G13)))),IF(AND(ISBLANK(G13),OR(ISBLANK(M13),O13>0)),F13+O13*365+IF(DAY(F13)>=DAY(F13+O13*365),DAY(F13)-DAY(F13+O13*365),IF(OR(EXACT(MONTH(F13),$W$34:$W$35)),31-DAY(F13+O13*365)+DAY(F13),IF(OR(EXACT(MONTH(F13),$X$34:$X$35)),30-DAY(F13+O13*365)+DAY(F13),28-DAY(F13+O13*365)+DAY(F13)))),F13+M13*365+IF(DAY(F13)>=DAY(F13+365*M13),DAY(F13)-DAY(F13+M13*365),IF(OR(EXACT(MONTH(F13),$W$34:$W$35)),31-DAY(F13+M13*365)+DAY(F13),IF(OR(EXACT(MONTH(F13),$X$34:$X$35)),30-DAY(F13+M13*365)+DAY(F13),28-DAY(F13+M13*365)+DAY(F13))))))","v":"1906-12-28"},78]
[null,10,"Лопасть НВ","8АТ-2710-00",null,null,null,null,null,null,null,3000,7,null,null,null,0,null,2395,0,1,{"$f":"IF(OR(AND(NOT(ISBLANK(G14)),M14>0,O14>0,F14+M14*365>G14+O14*365),AND(NOT(ISBLANK(G14)),ISBLANK(M14),O14>0)),G14+O14*365+IF(DAY(G14)>=DAY(G14+O14*365),DAY(G14)-DAY(G14+O14*365),IF(OR(EXACT(MONTH(G14),$W$34:$W$35)),31-DAY(G14+O14*365)+DAY(G14),IF(OR(EXACT(MONTH(G14),$X$34:$X$35)),30-DAY(G14+O14*365)+DAY(G14),28-DAY(G14+O14*365)+DAY(G14)))),IF(AND(ISBLANK(G14),OR(ISBLANK(M14),O14>0)),F14+O14*365+IF(DAY(F14)>=DAY(F14+O14*365),DAY(F14)-DAY(F14+O14*365),IF(OR(EXACT(MONTH(F14),$W$34:$W$35)),31-DAY(F14+O14*365)+DAY(F14),IF(OR(EXACT(MONTH(F14),$X$34:$X$35)),30-DAY(F14+O14*365)+DAY(F14),28-DAY(F14+O14*365)+DAY(F14)))),F14+M14*365+IF(DAY(F14)>=DAY(F14+365*M14),DAY(F14)-DAY(F14+M14*365),IF(OR(EXACT(MONTH(F14),$W$34:$W$35)),31-DAY(F14+M14*365)+DAY(F14),IF(OR(EXACT(MONTH(F14),$X$34:$X$35)),30-DAY(F14+M14*365)+DAY(F14),28-DAY(F14+M14*365)+DAY(F14))))))","v":"1906-12-28"},78]
[null,11,"Лопасть НВ","8АТ-2710-00",null,null,null,null,null,null,null,3000,7,null,null,null,0,null,2395,0,1,{"$f":"IF(OR(AND(NOT(ISBLANK(G15)),M15>0,O15>0,F15+M15*365>G15+O15*365),AND(NOT(ISBLANK(G15)),ISBLANK(M15),O15>0)),G15+O15*365+IF(DAY(G15)>=DAY(G15+O15*365),DAY(G15)-DAY(G15+O15*365),IF(OR(EXACT(MONTH(G15),$W$34:$W$35)),31-DAY(G15+O15*365)+DAY(G15),IF(OR(EXACT(MONTH(G15),$X$34:$X$35)),30-DAY(G15+O15*365)+DAY(G15),28-DAY(G15+O15*365)+DAY(G15)))),IF(AND(ISBLANK(G15),OR(ISBLANK(M15),O15>0)),F15+O15*365+IF(DAY(F15)>=DAY(F15+O15*365),DAY(F15)-DAY(F15+O15*365),IF(OR(EXACT(MONTH(F15),$W$34:$W$35)),31-DAY(F15+O15*365)+DAY(F15),IF(OR(EXACT(MONTH(F15),$X$34:$X$35)),30-DAY(F15+O15*365)+DAY(F15),28-DAY(F15+O15*365)+DAY(F15)))),F15+M15*365+IF(DAY(F15)>=DAY(F15+365*M15),DAY(F15)-DAY(F15+M15*365),IF(OR(EXACT(MONTH(F15),$W$34:$W$35)),31-DAY(F15+M15*365)+DAY(F15),IF(OR(EXACT(MONTH(F15),$X$34:$X$35)),30-DAY(F15+M15*365)+DAY(F15),28-DAY(F15+M15*365)+DAY(F15))))))","v":"1906-12-28"},78]
[null,12,"Лопасть НВ","8АТ-2710-00",null,null,null,null,null,null,null,3000,7,null,null,null,0,null,2395,0,1,{"$f":"IF(OR(AND(NOT(ISBLANK(G16)),M16>0,O16>0,F16+M16*365>G16+O16*365),AND(NOT(ISBLANK(G16)),ISBLANK(M16),O16>0)),G16+O16*365+IF(DAY(G16)>=DAY(G16+O16*365),DAY(G16)-DAY(G16+O16*365),IF(OR(EXACT(MONTH(G16),$W$34:$W$35)),31-DAY(G16+O16*365)+DAY(G16),IF(OR(EXACT(MONTH(G16),$X$34:$X$35)),30-DAY(G16+O16*365)+DAY(G16),28-DAY(G16+O16*365)+DAY(G16)))),IF(AND(ISBLANK(G16),OR(ISBLANK(M16),O16>0)),F16+O16*365+IF(DAY(F16)>=DAY(F16+O16*365),DAY(F16)-DAY(F16+O16*365),IF(OR(EXACT(MONTH(F16),$W$34:$W$35)),31-DAY(F16+O16*365)+DAY(F16),IF(OR(EXACT(MONTH(F16),$X$34:$X$35)),30-DAY(F16+O16*365)+DAY(F16),28-DAY(F16+O16*365)+DAY(F16)))),F16+M16*365+IF(DAY(F16)>=DAY(F16+365*M16),DAY(F16)-DAY(F16+M16*365),IF(OR(EXACT(MONTH(F16),$W$34:$W$35)),31-DAY(F16+M16*365)+DAY(F16),IF(OR(EXACT(MONTH(F16),$X$34:$X$35)),30-DAY(F16+M16*365)+DAY(F16),28-DAY(F16+M16*365)+DAY(F16))))))","v":"1906-12-28"},78]

{"sheet":"79","index":1,"n_rows":10,"n_cols":26,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,21,2,21],[1,22,2,22],[4,1,4,21],[1,9,2,9],[1,10,2,10],[1,11,1,12],[1,13,1,14],[1,15,1,16],[1,17,2,17],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,18,1,19],[1,20,2,20],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5]]}
[]
["Новые данные (+)","№","Наименование агрегата","Чертёжный номер","Заводской номер","Дата выпуска","Дата ремонта","Место ремонта","Количество ремонтов","Гарантия до","дата установки агрегата на вертолет","Назнач. ресурс",null,"Межрем. ресурс",null,"Наработка до установки",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,"ВиД","АО","РЭО"]
[null,1,"Автомат перекоса","8-1950-000",null,null,null,null,1,null,null,6000,null,1000,8,0,1396,null,{"$f":"SUM(S$7,-R6,Q6)","v":2395},{"$f":"IF(ISBLANK(P6),0,SUM(S$7,-R6,P6))","v":999},{"$f":"IF(ISBLANK(N6),L6-S6,IF(AND(ISBLANK(G6),L6-S6>N6-S6),N6-S6,IF(AND(ISNONTEXT(G6),L6-S6>N6-T6),N6-T6,L6-S6)))","v":1},{"$f":"IF(OR(AND(NOT(ISBLANK(G6)),M6>0,O6>0,F6+M6*365>G6+O6*365),AND(NOT(ISBLANK(G6)),ISBLANK(M6),O6>0)),G6+O6*365+IF(DAY(G6)>=DAY(G6+O6*365),DAY(G6)-DAY(G6+O6*365),IF(OR(EXACT(MONTH(G6),$W$23:$W$24)),31-DAY(G6+O6*365)+DAY(G6),IF(OR(EXACT(MONTH(G6),$X$23:$X$24)),30-DAY(G6+O6*365)+DAY(G6),28-DAY(G6+O6*365)+DAY(G6)))),IF(AND(ISBLANK(G6),OR(ISBLANK(M6),O6>0)),F6+O6*365+IF(DAY(F6)>=DAY(F6+O6*365),DAY(F6)-DAY(F6+O6*365),IF(OR(EXACT(MONTH(F6),$W$23:$W$24)),31-DAY(F6+O6*365)+DAY(F6),IF(OR(EXACT(MONTH(F6),$X$23:$X$24)),30-DAY(F6+O6*365)+DAY(F6),28-DAY(F6+O6*365)+DAY(F6)))),F6+M6*365+IF(DAY(F6)>=DAY(F6+365*M6),DAY(F6)-DAY(F6+M6*365),IF(OR(EXACT(MONTH(F6),$W$23:$W$24)),31-DAY(F6+M6*365)+DAY(F6),IF(OR(EXACT(MONTH(F6),$X$23:$X$24)),30-DAY(F6+M6*365)+DAY(F6),28-DAY(F6+M6*365)+DAY(F6))))))","v":"1907-12-28"},79]
[null,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(G7)),M7>0,O7>0,F7+M7*365>G7+O7*365),AND(NOT(ISBLANK(G7)),ISBLANK(M7),O7>0)),G7+O7*365+IF(DAY(G7)>=DAY(G7+O7*365),DAY(G7)-DAY(G7+O7*365),IF(OR(EXACT(MONTH(G7),$W$23:$W$24)),31-DAY(G7+O7*365)+DAY(G7),IF(OR(EXACT(MONTH(G7),$X$23:$X$24)),30-DAY(G7+O7*365)+DAY(G7),28-DAY(G7+O7*365)+DAY(G7)))),IF(AND(ISBLANK(G7),OR(ISBLANK(M7),O7>0)),F7+O7*365+IF(DAY(F7)>=DAY(F7+O7*365),DAY(F7)-DAY(F7+O7*365),IF(OR(EXACT(MONTH(F7),$W$23:$W$24)),31-DAY(F7+O7*365)+DAY(F7),IF(OR(EXACT(MONTH(F7),$X$23:$X$24)),30-DAY(F7+O7*365)+DAY(F7),28-DAY(F7+O7*365)+DAY(F7)))),F7+M7*365+IF(DAY(F7)>=DAY(F7+365*M7),DAY(F7)-DAY(F7+M7*365),IF(OR(EXACT(MONTH(F7),$W$23:$W$24)),31-DAY(F7+M7*365)+DAY(F7),IF(OR(EXACT(MONTH(F7),$X$23:$X$24)),30-DAY(F7+M7*365)+DAY(F7),28-DAY(F7+M7*365)+DAY(F7))))))","v":"1909-12-28"},79]
[null,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(G8)),M8>0,O8>0,F8+M8*365>G8+O8*365),AND(NOT(ISBLANK(G8)),ISBLANK(M8),O8>0)),G8+O8*365+IF(DAY(G8)>=DAY(G8+O8*365),DAY(G8)-DAY(G8+O8*365),IF(OR(EXACT(MONTH(G8),$W$23:$W$24)),31-DAY(G8+O8*365)+DAY(G8),IF(OR(EXACT(MONTH(G8),$X$23:$X$24)),30-DAY(G8+O8*365)+DAY(G8),28-DAY(G8+O8*365)+DAY(G8)))),IF(AND(ISBLANK(G8),OR(ISBLANK(M8),O8>0)),F8+O8*365+IF(DAY(F8)>=DAY(F8+O8*365),DAY(F8)-DAY(F8+O8*365),IF(OR(EXACT(MONTH(F8),$W$23:$W$24)),31-DAY(F8+O8*365)+DAY(F8),IF(OR(EXACT(MONTH(F8),$X$23:$X$24)),30-DAY(F8+O8*365)+DAY(F8),28-DAY(F8+O8*365)+DAY(F8)))),F8+M8*365+IF(DAY(F8)>=DAY(F8+365*M8),DAY(F8)-DAY(F8+M8*365),IF(OR(EXACT(MONTH(F8),$W$23:$W$24)),31-DAY(F8+M8*365)+DAY(F8),IF(OR(EXACT(MONTH(F8),$X$23:$X$24)),30-DAY(F8+M8*365)+DAY(F8),28-DAY(F8+M8*365)+DAY(F8))))))","v":"1905-12-28"},79]
[null,4,"Компрессор АК-50","АК-50Т1сер3",null,null,null,null,null,null,null,2250,null,750,6,null,236,null,{"$f":"SUM(S$7,-R9,Q9)","v":515},{"$f":"IF(ISBLANK(P9),0,SUM(S$7,-R9,P9))","v":0},{"$f":"IF(ISBLANK(N9),L9-S9,IF(AND(ISBLANK(G9),L9-S9>N9-S9),N9-S9,IF(AND(ISNONTEXT(G9),L9-S9>N9-T9),N9-T9,L9-S9)))","v":235},{"$f":"IF(OR(AND(NOT(ISBLANK(G9)),M9>0,O9>0,F9+M9*365>G9+O9*365),AND(NOT(ISBLANK(G9)),ISBLANK(M9),O9>0)),G9+O9*365+IF(DAY(G9)>=DAY(G9+O9*365),DAY(G9)-DAY(G9+O9*365),IF(OR(EXACT(MONTH(G9),$W$23:$W$24)),31-DAY(G9+O9*365)+DAY(G9),IF(OR(EXACT(MONTH(G9),$X$23:$X$24)),30-DAY(G9+O9*365)+DAY(G9),28-DAY(G9+O9*365)+DAY(G9)))),IF(AND(ISBLANK(G9),OR(ISBLANK(M9),O9>0)),F9+O9*365+IF(DAY(F9)>=DAY(F9+O9*365),DAY(F9)-DAY(F9+O9*365),IF(OR(EXACT(MONTH(F9),$W$23:$W$24)),31-DAY(F9+O9*365)+DAY(F9),IF(OR(EXACT(MONTH(F9),$X$23:$X$24)),30-DAY(F9+O9*365)+DAY(F9),28-DAY(F9+O9*365)+DAY(F9)))),F9+M9*365+IF(DAY(F9)>=DAY(F9+365*M9),DAY(F9)-DAY(F9+M9*365),IF(OR(EXACT(MONTH(F9),$W$23:$W$24)),31-DAY(F9+M9*365)+DAY(F9),IF(OR(EXACT(MONTH(F9),$X$23:$X$24)),30-DAY(F9+M9*365)+DAY(F9),28-DAY(F9+M9*365)+DAY(F9))))))","v":"1905-12-28"},79]
[null,5,"Компрессор АК-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(G10)),M10>0,O10>0,F10+M10*365>G10+O10*365),AND(NOT(ISBLANK(G10)),ISBLANK(M10),O10>0)),G10+O10*365+IF(DAY(G10)>=DAY(G10+O10*365),DAY(G10)-DAY(G10+O10*365),IF(OR(EXACT(MONTH(G10),$W$23:$W$24)),31-DAY(G10+O10*365)+DAY(G10),IF(OR(EXACT(MONTH(G10),$X$23:$X$24)),30-DAY(G10+O10*365)+DAY(G10),28-DAY(G10+O10*365)+DAY(G10)))),IF(AND(ISBLANK(G10),OR(ISBLANK(M10),O10>0)),F10+O10*365+IF(DAY(F10)>=DAY(F10+O10*365),DAY(F10)-DAY(F10+O10*365),IF(OR(EXACT(MONTH(F10),$W$23:$W$24)),31-DAY(F10+O10*365)+DAY(F10),IF(OR(EXACT(MONTH(F10),$X$23:$X$24)),30-DAY(F10+O10*365)+DAY(F10),28-DAY(F10+O10*365)+DAY(F10)))),F10+M10*365+IF(DAY(F10)>=DAY(F10+365*M10),DAY(F10)-DAY(F10+M10*365),IF(OR(EXACT(MONTH(F10),$W$23:$W$24)),31-DAY(F10+M10*365)+DAY(F10),IF(OR(EXACT(MONTH(F10),$X$23:$X$24)),30-DAY(F10+M10*365)+DAY(F10),28-DAY(F10+M10*365)+DAY(F10))))))","v":"1905-12-28"},79]

{"sheet":"77","index":2,"n_rows":12,"n_cols":23,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,21,2,21],[1,22,2,22],[4,1,4,21],[1,9,2,9],[1,10,2,10],[1,11,1,12],[1,13,1,14],[1,15,1,16],[1,17,2,17],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,18,1,19],[1,20,2,20],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5]]}
[]
["Новые данные (+)","№","Наименование агрегата","Чертёжный номер","Заводской номер","Дата выпуска","Дата ремонта","Место ремонта","Количество ремонтов","Гарантия до","дата установки агрегата на вертолет","Назнач. ресурс",null,"Межрем. ресурс",null,"Наработка до установки",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]
[null,1,"Г/усилитель","РА-60Б",null,null,null,null,2,null,null,9000,40,1500,15,0,2042,2520,{"$f":"SUM(S$14,-R6,Q6)","v":-478},{"$f":"IF(ISBLANK(P6),0,SUM(S$14,-R6,P6))","v":-2520},{"$f":"IF(ISBLANK(N6),L6-S6,IF(AND(ISBLANK(G6),L6-S6>N6-S6),N6-S6,IF(AND(ISNONTEXT(G6),L6-S6>N6-T6),N6-T6,L6-S6)))","v":1978},{"$f":"IF(OR(AND(NOT(ISBLANK(G6)),M6>0,O6>0,F6+M6*365>G6+O6*365),AND(NOT(ISBLANK(G6)),ISBLANK(M6),O6>0)),G6+O6*365+IF(DAY(G6)>=DAY(G6+O6*365),DAY(G6)-DAY(G6+O6*365),IF(OR(EXACT(MONTH(G6),$W$36:$W$37)),31-DAY(G6+O6*365)+DAY(G6),IF(OR(EXACT(MONTH(G6),$X$36:$X$37)),30-DAY(G6+O6*365)+DAY(G6),28-DAY(G6+O6*365)+DAY(G6)))),IF(AND(ISBLANK(G6),OR(ISBLANK(M6),O6>0)),F6+O6*365+IF(DAY(F6)>=DAY(F6+O6*365),DAY(F6)-DAY(F6+O6*365),IF(OR(EXACT(MONTH(F6),$W$36:$W$37)),31-DAY(F6+O6*365)+DAY(F6),IF(OR(EXACT(MONTH(F6),$X$36:$X$37)),30-DAY(F6+O6*365)+DAY(F6),28-DAY(F6+O6*365)+DAY(F6)))),F6+M6*365+IF(DAY(F6)>=DAY(F6+365*M6),DAY(F6)-DAY(F6+M6*365),IF(OR(EXACT(MONTH(F6),$W$36:$W$37)),31-DAY(F6+M6*365)+DAY(F6),IF(OR(EXACT(MONTH(F6),$X$36:$X$37)),30-DAY(F6+M6*365)+DAY(F6),28-DAY(F6+M6*365)+DAY(F6))))))","v":"1914-12-28"},77]
[null,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(G7)),M7>0,O7>0,F7+M7*365>G7+O7*365),AND(NOT(ISBLANK(G7)),ISBLANK(M7),O7>0)),G7+O7*365+IF(DAY(G7)>=DAY(G7+O7*365),DAY(G7)-DAY(G7+O7*365),IF(OR(EXACT(MONTH(G7),$W$36:$W$37)),31-DAY(G7+O7*365)+DAY(G7),IF(OR(EXACT(MONTH(G7),$X$36:$X$37)),30-DAY(G7+O7*365)+DAY(G7),28-DAY(G7+O7*365)+DAY(G7)))),IF(AND(ISBLANK(G7),OR(ISBLANK(M7),O7>0)),F7+O7*365+IF(DAY(F7)>=DAY(F7+O7*365),DAY(F7)-DAY(F7+O7*365),IF(OR(EXACT(MONTH(F7),$W$36:$W$37)),31-DAY(F7+O7*365)+DAY(F7),IF(OR(EXACT(MONTH(F7),$X$36:$X$37)),30-DAY(F7+O7*365)+DAY(F7),28-DAY(F7+O7*365)+DAY(F7)))),F7+M7*365+IF(DAY(F7)>=DAY(F7+365*M7),DAY(F7)-DAY(F7+M7*365),IF(OR(EXACT(MONTH(F7),$W$36:$W$37)),31-DAY(F7+M7*365)+DAY(F7),IF(OR(EXACT(MONTH(F7),$X$36:$X$37)),30-DAY(F7+M7*365)+DAY(F7),28-DAY(F7+M7*365)+DAY(F7))))))","v":"1914-12-28"},77]
[null,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(G8)),M8>0,O8>0,F8+M8*365>G8+O8*365),AND(NOT(ISBLANK(G8)),ISBLANK(M8),O8>0)),G8+O8*365+IF(DAY(G8)>=DAY(G8+O8*365),DAY(G8)-DAY(G8+O8*365),IF(OR(EXACT(MONTH(G8),$W$36:$W$37)),31-DAY(G8+O8*365)+DAY(G8),IF(OR(EXACT(MONTH(G8),$X$36:$X$37)),30-DAY(G8+O8*365)+DAY(G8),28-DAY(G8+O8*365)+DAY(G8)))),IF(AND(ISBLANK(G8),OR(ISBLANK(M8),O8>0)),F8+O8*365+IF(DAY(F8)>=DAY(F8+O8*365),DAY(F8)-DAY(F8+O8*365),IF(OR(EXACT(MONTH(F8),$W$36:$W$37)),31-DAY(F8+O8*365)+DAY(F8),IF(OR(EXACT(MONTH(F8),$X$36:$X$37)),30-DAY(F8+O8*365)+DAY(F8),28-DAY(F8+O8*365)+DAY(F8)))),F8+M8*365+IF(DAY(F8)>=DAY(F8+365*M8),DAY(F8)-DAY(F8+M8*365),IF(OR(EXACT(MONTH(F8),$W$36:$W$37)),31-DAY(F8+M8*365)+DAY(F8),IF(OR(EXACT(MONTH(F8),$X$36:$X$37)),30-DAY(F8+M8*365)+DAY(F8),28-DAY(F8+M8*365)+DAY(F8))))))","v":"1914-12-28"},77]
[null,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(G9)),M9>0,O9>0,F9+M9*365>G9+O9*365),AND(NOT(ISBLANK(G9)),ISBLANK(M9),O9>0)),G9+O9*365+IF(DAY(G9)>=DAY(G9+O9*365),DAY(G9)-DAY(G9+O9*365),IF(OR(EXACT(MONTH(G9),$W$36:$W$37)),31-DAY(G9+O9*365)+DAY(G9),IF(OR(EXACT(MONTH(G9),$X$36:$X$37)),30-DAY(G9+O9*365)+DAY(G9),28-DAY(G9+O9*365)+DAY(G9)))),IF(AND(ISBLANK(G9),OR(ISBLANK(M9),O9>0)),F9+O9*365+IF(DAY(F9)>=DAY(F9+O9*365),DAY(F9)-DAY(F9+O9*365),IF(OR(EXACT(MONTH(F9),$W$36:$W$37)),31-DAY(F9+O9*365)+DAY(F9),IF(OR(EXACT(MONTH(F9),$X$36:$X$37)),30-DAY(F9+O9*365)+DAY(F9),28-DAY(F9+O9*365)+DAY(F9)))),F9+M9*365+IF(DAY(F9)>=DAY(F9+365*M9),DAY(F9)-DAY(F9+M9*365),IF(OR(EXACT(MONTH(F9),$W$36:$W$37)),31-DAY(F9+M9*365)+DAY(F9),IF(OR(EXACT(MONTH(F9),$X$36:$X$37)),30-DAY(F9+M9*365)+DAY(F9),28-DAY(F9+M9*365)+DAY(F9))))))","v":"1913-12-28"},77]
[null,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(G10)),M10>0,O10>0,F10+M10*365>G10+O10*365),AND(NOT(ISBLANK(G10)),ISBLANK(M10),O10>0)),G10+O10*365+IF(DAY(G10)>=DAY(G10+O10*365),DAY(G10)-DAY(G10+O10*365),IF(OR(EXACT(MONTH(G10),$W$36:$W$37)),31-DAY(G10+O10*365)+DAY(G10),IF(OR(EXACT(MONTH(G10),$X$36:$X$37)),30-DAY(G10+O10*365)+DAY(G10),28-DAY(G10+O10*365)+DAY(G10)))),IF(AND(ISBLANK(G10),OR(ISBLANK(M10),O10>0)),F10+O10*365+IF(DAY(F10)>=DAY(F10+O10*365),DAY(F10)-DAY(F10+O10*365),IF(OR(EXACT(MONTH(F10),$W$36:$W$37)),31-DAY(F10+O10*365)+DAY(F10),IF(OR(EXACT(MONTH(F10),$X$36:$X$37)),30-DAY(F10+O10*365)+DAY(F10),28-DAY(F10+O10*365)+DAY(F10)))),F10+M10*365+IF(DAY(F10)>=DAY(F10+365*M10),DAY(F10)-DAY(F10+M10*365),IF(OR(EXACT(MONTH(F10),$W$36:$W$37)),31-DAY(F10+M10*365)+DAY(F10),IF(OR(EXACT(MONTH(F10),$X$36:$X$37)),30-DAY(F10+M10*365)+DAY(F10),28-DAY(F10+M10*365)+DAY(F10))))))","v":"1914-12-28"},77]
[null,6,"Пром. редуктор","8А-1515-001",null,null,null,null,3,null,null,6000,null,2000,15,0,1864,2520,{"$f":"SUM(S$14,-R11,Q11)","v":-656},{"$f":"IF(ISBLANK(P11),0,SUM(S$14,-R11,P11))","v":-2520},{"$f":"IF(ISBLANK(N11),L11-S11,IF(AND(ISBLANK(G11),L11-S11>N11-S11),N11-S11,IF(AND(ISNONTEXT(G11),L11-S11>N11-T11),N11-T11,L11-S11)))","v":2656},{"$f":"IF(OR(AND(NOT(ISBLANK(G11)),M11>0,O11>0,F11+M11*365>G11+O11*365),AND(NOT(ISBLANK(G11)),ISBLANK(M11),O11>0)),G11+O11*365+IF(DAY(G11)>=DAY(G11+O11*365),DAY(G11)-DAY(G11+O11*365),IF(OR(EXACT(MONTH(G11),$W$36:$W$37)),31-DAY(G11+O11*365)+DAY(G11),IF(OR(EXACT(MONTH(G11),$X$36:$X$37)),30-DAY(G11+O11*365)+DAY(G11),28-DAY(G11+O11*365)+DAY(G11)))),IF(AND(ISBLANK(G11),OR(ISBLANK(M11),O11>0)),F11+O11*365+IF(DAY(F11)>=DAY(F11+O11*365),DAY(F11)-DAY(F11+O11*365),IF(OR(EXACT(MONTH(F11),$W$36:$W$37)),31-DAY(F11+O11*365)+DAY(F11),IF(OR(EXACT(MONTH(F11),$X$36:$X$37)),30-DAY(F11+O11*365)+DAY(F11),28-DAY(F11+O11*365)+DAY(F11)))),F11+M11*365+IF(DAY(F11)>=DAY(F11+365*M11),DAY(F11)-DAY(F11+M11*365),IF(OR(EXACT(MONTH(F11),$W$36:$W$37)),31-DAY(F11+M11*365)+DAY(F11),IF(OR(EXACT(MONTH(F11),$X$36:$X$37)),30-DAY(F11+M11*365)+DAY(F11),28-DAY(F11+M11*365)+DAY(F11))))))","v":"1914-12-28"},78]
[null,7,"Пром. редуктор","8А-1515-002",null,null,null,null,3,null,null,6000,null,2000,15,0,1864,2520,-656,-2520,2656,{"$f":"IF(OR(AND(NOT(ISBLANK(G12)),M12>0,O12>0,F12+M12*365>G12+O12*365),AND(NOT(ISBLANK(G12)),ISBLANK(M12),O12>0)),G12+O12*365+IF(DAY(G12)>=DAY(G12+O12*365),DAY(G12)-DAY(G12+O12*365),IF(OR(EXACT(MONTH(G12),$W$36:$W$37)),31-DAY(G12+O12*365)+DAY(G12),IF(OR(EXACT(MONTH(G12),$X$36:$X$37)),30-DAY(G12+O12*365)+DAY(G12),28-DAY(G12+O12*365)+DAY(G12)))),IF(AND(ISBLANK(G12),OR(ISBLANK(M12),O12>0)),F12+O12*365+IF(DAY(F12)>=DAY(F12+O12*365),DAY(F12)-DAY(F12+O12*365),IF(OR(EXACT(MONTH(F12),$W$36:$W$37)),31-DAY(F12+O12*365)+DAY(F12),IF(OR(EXACT(MONTH(F12),$X$36:$X$37)),30-DAY(F12+O12*365)+DAY(F12),28-DAY(F12+O12*365)+DAY(F12)))),F12+M12*365+IF(DAY(F12)>=DAY(F12+365*M12),DAY(F12)-DAY(F12+M12*365),IF(OR(EXACT(MONTH(F12),$W$36:$W$37)),31-DAY(F12+M12*365)+DAY(F12),IF(OR(EXACT(MONTH(F12),$X$36:$X$37)),30-DAY(F12+M12*365)+DAY(F12),28-DAY(F12+M12*365)+DAY(F12))))))","v":"1914-12-28"},79]

{"sheet":"75","index":3,"n_rows":12,"n_cols":23,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,21,2,21],[1,22,2,22],[4,1,4,21],[1,11,1,12],[1,13,1,14],[1,15,1,16],[1,17,2,17],[1,9,2,9],[1,10,2,10],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,18,1,19],[1,20,2,20],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5]]}
[]
["Новые данные (+)","№","Наименование агрегата","Чертёжный номер","Заводской номер","Дата выпуска","Дата ремонта","Место ремонта","Количество ремонтов","Гарантия до","дата установки агрегата на вертолет","Назнач. ресурс",null,"Межрем. ресурс",null,"Наработка до установки",null,"Наработка вертолёта при установке агрегата","Наработка ",null,"Остаток ресурса час.","Дата снятия агрегата по выработке ресурса ","Бортовой номер вертолета"]
[null,null,null,null,null,null,null,null,null,null,null,"часов","лет","часов","лет","ППР","СНЭ",null,"СНЭ","ППР"]
[]
[null,"Вертолет 75"]
[null,1,"Компрессор АК-50","АК-50Т1сер3",null,null,null,null,null,null,null,2250,null,750,6,null,null,null,{"$f":"SUM(S$7,-R6,Q6)","v":2248},{"$f":"IF(ISBLANK(P6),0,SUM(S$7,-R6,P6))","v":0},{"$f":"IF(ISBLANK(N6),L6-S6,IF(AND(ISBLANK(G6),L6-S6>N6-S6),N6-S6,IF(AND(ISNONTEXT(G6),L6-S6>N6-T6),N6-T6,L6-S6)))","v":-1498},{"$f":"IF(OR(AND(NOT(ISBLANK(G6)),M6>0,O6>0,F6+M6*365>G6+O6*365),AND(NOT(ISBLANK(G6)),ISBLANK(M6),O6>0)),G6+O6*365+IF(DAY(G6)>=DAY(G6+O6*365),DAY(G6)-DAY(G6+O6*365),IF(OR(EXACT(MONTH(G6),$W$20:$W$21)),31-DAY(G6+O6*365)+DAY(G6),IF(OR(EXACT(MONTH(G6),$X$20:$X$21)),30-DAY(G6+O6*365)+DAY(G6),28-DAY(G6+O6*365)+DAY(G6)))),IF(AND(ISBLANK(G6),OR(ISBLANK(M6),O6>0)),F6+O6*365+IF(DAY(F6)>=DAY(F6+O6*365),DAY(F6)-DAY(F6+O6*365),IF(OR(EXACT(MONTH(F6),$W$20:$W$21)),31-DAY(F6+O6*365)+DAY(F6),IF(OR(EXACT(MONTH(F6),$X$20:$X$21)),30-DAY(F6+O6*365)+DAY(F6),28-DAY(F6+O6*365)+DAY(F6)))),F6+M6*365+IF(DAY(F6)>=DAY(F6+365*M6),DAY(F6)-DAY(F6+M6*365),IF(OR(EXACT(MONTH(F6),$W$20:$W$21)),31-DAY(F6+M6*365)+DAY(F6),IF(OR(EXACT(MONTH(F6),$X$20:$X$21)),30-DAY(F6+M6*365)+DAY(F6),28-DAY(F6+M6*365)+DAY(F6))))))","v":"1905-12-28"},75]
[null,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(G7)),M7>0,O7>0,F7+M7*365>G7+O7*365),AND(NOT(ISBLANK(G7)),ISBLANK(M7),O7>0)),G7+O7*365+IF(DAY(G7)>=DAY(G7+O7*365),DAY(G7)-DAY(G7+O7*365),IF(OR(EXACT(MONTH(G7),$W$20:$W$21)),31-DAY(G7+O7*365)+DAY(G7),IF(OR(EXACT(MONTH(G7),$X$20:$X$21)),30-DAY(G7+O7*365)+DAY(G7),28-DAY(G7+O7*365)+DAY(G7)))),IF(AND(ISBLANK(G7),OR(ISBLANK(M7),O7>0)),F7+O7*365+IF(DAY(F7)>=DAY(F7+O7*365),DAY(F7)-DAY(F7+O7*365),IF(OR(EXACT(MONTH(F7),$W$20:$W$21)),31-DAY(F7+O7*365)+DAY(F7),IF(OR(EXACT(MONTH(F7),$X$20:$X$21)),30-DAY(F7+O7*365)+DAY(F7),28-DAY(F7+O7*365)+DAY(F7)))),F7+M7*365+IF(DAY(F7)>=DAY(F7+365*M7),DAY(F7)-DAY(F7+M7*365),IF(OR(EXACT(MONTH(F7),$W$20:$W$21)),31-DAY(F7+M7*365)+DAY(F7),IF(OR(EXACT(MONTH(F7),$X$20:$X$21)),30-DAY(F7+M7*365)+DAY(F7),28-DAY(F7+M7*365)+DAY(F7))))))","v":"1914-12-28"},75]
[null,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(G8)),M8>0,O8>0,F8+M8*365>G8+O8*365),AND(NOT(ISBLANK(G8)),ISBLANK(M8),O8>0)),G8+O8*365+IF(DAY(G8)>=DAY(G8+O8*365),DAY(G8)-DAY(G8+O8*365),IF(OR(EXACT(MONTH(G8),$W$20:$W$21)),31-DAY(G8+O8*365)+DAY(G8),IF(OR(EXACT(MONTH(G8),$X$20:$X$21)),30-DAY(G8+O8*365)+DAY(G8),28-DAY(G8+O8*365)+DAY(G8)))),IF(AND(ISBLANK(G8),OR(ISBLANK(M8),O8>0)),F8+O8*365+IF(DAY(F8)>=DAY(F8+O8*365),DAY(F8)-DAY(F8+O8*365),IF(OR(EXACT(MONTH(F8),$W$20:$W$21)),31-DAY(F8+O8*365)+DAY(F8),IF(OR(EXACT(MONTH(F8),$X$20:$X$21)),30-DAY(F8+O8*365)+DAY(F8),28-DAY(F8+O8*365)+DAY(F8)))),F8+M8*365+IF(DAY(F8)>=DAY(F8+365*M8),DAY(F8)-DAY(F8+M8*365),IF(OR(EXACT(MONTH(F8),$W$20:$W$21)),31-DAY(F8+M8*365)+DAY(F8),IF(OR(EXACT(MONTH(F8),$X$20:$X$21)),30-DAY(F8+M8*365)+DAY(F8),28-DAY(F8+M8*365)+DAY(F8))))))","v":"1909-12-28"},75]
[null,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(G9)),M9>0,O9>0,F9+M9*365>G9+O9*365),AND(NOT(ISBLANK(G9)),ISBLANK(M9),O9>0)),G9+O9*365+IF(DAY(G9)>=DAY(G9+O9*365),DAY(G9)-DAY(G9+O9*365),IF(OR(EXACT(MONTH(G9),$W$20:$W$21)),31-DAY(G9+O9*365)+DAY(G9),IF(OR(EXACT(MONTH(G9),$X$20:$X$21)),30-DAY(G9+O9*365)+DAY(G9),28-DAY(G9+O9*365)+DAY(G9)))),IF(AND(ISBLANK(G9),OR(ISBLANK(M9),O9>0)),F9+O9*365+IF(DAY(F9)>=DAY(F9+O9*365),DAY(F9)-DAY(F9+O9*365),IF(OR(EXACT(MONTH(F9),$W$20:$W$21)),31-DAY(F9+O9*365)+DAY(F9),IF(OR(EXACT(MONTH(F9),$X$20:$X$21)),30-DAY(F9+O9*365)+DAY(F9),28-DAY(F9+O9*365)+DAY(F9)))),F9+M9*365+IF(DAY(F9)>=DAY(F9+365*M9),DAY(F9)-DAY(F9+M9*365),IF(OR(EXACT(MONTH(F9),$W$20:$W$21)),31-DAY(F9+M9*365)+DAY(F9),IF(OR(EXACT(MONTH(F9),$X$20:$X$21)),30-DAY(F9+M9*365)+DAY(F9),28-DAY(F9+M9*365)+DAY(F9))))))","v":"1914-12-28"},75]
[null,5,"Г/усилитель","КАУ-30Б",null,null,null,null,null,null,null,9000,40,1500,15,null,null,null,{"$f":"SUM(S$7,-R10,Q10)","v":2248},{"$f":"IF(ISBLANK(P10),0,SUM(S$7,-R10,P10))","v":0},{"$f":"IF(ISBLANK(N10),L10-S10,IF(AND(ISBLANK(G10),L10-S10>N10-S10),N10-S10,IF(AND(ISNONTEXT(G10),L10-S10>N10-T10),N10-T10,L10-S10)))","v":-748},{"$f":"IF(OR(AND(NOT(ISBLANK(G10)),M10>0,O10>0,F10+M10*365>G10+O10*365),AND(NOT(ISBLANK(G10)),ISBLANK(M10),O10>0)),G10+O10*365+IF(DAY(G10)>=DAY(G10+O10*365),DAY(G10)-DAY(G10+O10*365),IF(OR(EXACT(MONTH(G10),$W$20:$W$21)),31-DAY(G10+O10*365)+DAY(G10),IF(OR(EXACT(MONTH(G10),$X$20:$X$21)),30-DAY(G10+O10*365)+DAY(G10),28-DAY(G10+O10*365)+DAY(G10)))),IF(AND(ISBLANK(G10),OR(ISBLANK(M10),O10>0)),F10+O10*365+IF(DAY(F10)>=DAY(F10+O10*365),DAY(F10)-DAY(F10+O10*365),IF(OR(EXACT(MONTH(F10),$W$20:$W$21)),31-DAY(F10+O10*365)+DAY(F10),IF(OR(EXACT(MONTH(F10),$X$20:$X$21)),30-DAY(F10+O10*365)+DAY(F10),28-DAY(F10+O10*365)+DAY(F10)))),F10+M10*365+IF(DAY(F10)>=DAY(F10+365*M10),DAY(F10)-DAY(F10+M10*365),IF(OR(EXACT(MONTH(F10),$W$20:$W$21)),31-DAY(F10+M10*365)+DAY(F10),IF(OR(EXACT(MONTH(F10),$X$20:$X$21)),30-DAY(F10+M10*365)+DAY(F10),28-DAY(F10+M10*365)+DAY(F10))))))","v":"1914-12-28"},76]
[null,6,"Г/усилитель","КАУ-30Б",null,null,null,null,null,null,null,9000,40,1500,15,null,null,null,2248,0,-748,{"$f":"IF(OR(AND(NOT(ISBLANK(G11)),M11>0,O11>0,F11+M11*365>G11+O11*365),AND(NOT(ISBLANK(G11)),ISBLANK(M11),O11>0)),G11+O11*365+IF(DAY(G11)>=DAY(G11+O11*365),DAY(G11)-DAY(G11+O11*365),IF(OR(EXACT(MONTH(G11),$W$20:$W$21)),31-DAY(G11+O11*365)+DAY(G11),IF(OR(EXACT(MONTH(G11),$X$20:$X$21)),30-DAY(G11+O11*365)+DAY(G11),28-DAY(G11+O11*365)+DAY(G11)))),IF(AND(ISBLANK(G11),OR(ISBLANK(M11),O11>0)),F11+O11*365+IF(DAY(F11)>=DAY(F11+O11*365),DAY(F11)-DAY(F11+O11*365),IF(OR(EXACT(MONTH(F11),$W$20:$W$21)),31-DAY(F11+O11*365)+DAY(F11),IF(OR(EXACT(MONTH(F11),$X$20:$X$21)),30-DAY(F11+O11*365)+DAY(F11),28-DAY(F11+O11*365)+DAY(F11)))),F11+M11*365+IF(DAY(F11)>=DAY(F11+365*M11),DAY(F11)-DAY(F11+M11*365),IF(OR(EXACT(MONTH(F11),$W$20:$W$21)),31-DAY(F11+M11*365)+DAY(F11),IF(OR(EXACT(MONTH(F11),$X$20:$X$21)),30-DAY(F11+M11*365)+DAY(F11),28-DAY(F11+M11*365)+DAY(F11))))))","v":"1914-12-28"},77]
[null,7,"Г/усилитель","КАУ-30Б",null,null,null,null,null,null,null,9000,40,1500,15,null,null,null,2248,0,-748,{"$f":"IF(OR(AND(NOT(ISBLANK(G12)),M12>0,O12>0,F12+M12*365>G12+O12*365),AND(NOT(ISBLANK(G12)),ISBLANK(M12),O12>0)),G12+O12*365+IF(DAY(G12)>=DAY(G12+O12*365),DAY(G12)-DAY(G12+O12*365),IF(OR(EXACT(MONTH(G12),$W$20:$W$21)),31-DAY(G12+O12*365)+DAY(G12),IF(OR(EXACT(MONTH(G12),$X$20:$X$21)),30-DAY(G12+O12*365)+DAY(G12),28-DAY(G12+O12*365)+DAY(G12)))),IF(AND(ISBLANK(G12),OR(ISBLANK(M12),O12>0)),F12+O12*365+IF(DAY(F12)>=DAY(F12+O12*365),DAY(F12)-DAY(F12+O12*365),IF(OR(EXACT(MONTH(F12),$W$20:$W$21)),31-DAY(F12+O12*365)+DAY(F12),IF(OR(EXACT(MONTH(F12),$X$20:$X$21)),30-DAY(F12+O12*365)+DAY(F12),28-DAY(F12+O12*365)+DAY(F12)))),F12+M12*365+IF(DAY(F12)>=DAY(F12+365*M12),DAY(F12)-DAY(F12+M12*365),IF(OR(EXACT(MONTH(F12),$W$20:$W$21)),31-DAY(F12+M12*365)+DAY(F12),IF(OR(EXACT(MONTH(F12),$X$20:$X$21)),30-DAY(F12+M12*365)+DAY(F12),28-DAY(F12+M12*365)+DAY(F12))))))","v":"1914-12-28"},78]

{"sheet":"общ","index":4,"n_rows":35,"n_cols":22,"rows_kept":35,"cut":false,"hidden":false,"merged":[[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],[2,17,2,18],[2,19,3,19],[2,20,3,20]]}
[]
[]
["№","Наименование агрегата","Чертёжный номер","Заводской номер","Дата выпуска","Дата ремонта","Место ремонта","Количество ремонтов","Гарантия до","дата установки агрегата на вертолет","Назнач. ресурс",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]
[null,"Лопасть НВ","8АТ-2710-00",null,null,null,null,null,null,null,2000,7,null,null,null,0,null,2395,0,1,"1906-12-28",78]
[null,"Лопасть НВ","8АТ-2710-00",null,null,null,null,null,null,null,2000,7,null,null,null,0,null,999,0,1,"1906-12-28",78]
[null,"Лопасть НВ","8АТ-2710-00",null,null,null,null,null,null,null,2000,7,null,null,null,0,null,515,0,1,"1906-12-28",78]
[null,"Лопасть НВ","8АТ-2710-00",null,null,null,null,null,null,null,2000,7,null,null,null,0,null,2395,0,1,"1906-12-28",78]
[null,"Автомат перекоса","8-1950-000",null,null,null,null,1,null,null,6000,null,1000,8,0,1396,null,2395,999,1,"1907-12-28",79]
[null,"Гл. редуктор","ВР-14",null,null,null,null,null,null,null,8000,null,2000,10,null,null,null,999,0,1001,"1909-12-28",79]
[null,"Компрессор АК-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]
[null,"Г/усилитель","РА-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]
[9,"Лопасть НВ","8АТ-2710-00",null,null,null,null,null,null,null,3000,7,null,null,null,0,null,2395,0,1,"1906-12-28",78]
[10,"Лопасть НВ","8АТ-2710-00",null,null,null,null,null,null,null,3000,7,null,null,null,0,null,2395,0,1,"1906-12-28",78]
[11,"Лопасть НВ","8АТ-2710-00",null,null,null,null,null,null,null,3000,7,null,null,null,0,null,2395,0,1,"1906-12-28",78]
[12,"Лопасть НВ","8АТ-2710-00",null,null,null,null,null,null,null,3000,7,null,null,null,0,null,2395,0,1,"1906-12-28",78]
[4,"Компрессор АК-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]
[5,"Компрессор АК-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]
[6,"Пром. редуктор","8А-1515-001",null,null,null,null,3,null,null,6000,null,2000,15,0,1864,2520,-656,-2520,2656,"1914-12-28",78]
[7,"Пром. редуктор","8А-1515-002",null,null,null,null,3,null,null,6000,null,2000,15,0,1864,2520,-656,-2520,2656,"1914-12-28",79]
[5,"Г/усилитель","КАУ-30Б",null,null,null,null,null,null,null,9000,40,1500,15,null,null,null,2248,0,-748,"1914-12-28",76]
[6,"Г/усилитель","КАУ-30Б",null,null,null,null,null,null,null,9000,40,1500,15,null,null,null,2248,0,-748,"1914-12-28",77]
[7,"Г/усилитель","КАУ-30Б",null,null,null,null,null,null,null,9000,40,1500,15,null,null,null,2248,0,-748,"1914-12-28",78]