{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Лист1","index":0,"n_rows":69,"n_cols":76,"rows_kept":69,"cut":false,"hidden":false,"merged":[[46,71,46,72],[46,61,46,62],[46,63,46,64],[46,65,46,66],[46,67,46,68],[46,69,46,70],[46,51,46,52],[46,53,46,54],[46,55,46,56],[46,57,46,58],[46,59,46,60],[46,41,46,42],[46,43,46,44],[46,45,46,46],[46,47,46,48],[46,49,46,50],[46,31,46,32],[46,33,46,34],[46,35,46,36],[46,37,46,38],[46,39,46,40],[42,71,42,72],[46,1,46,2],[46,3,46,4],[46,5,46,6],[46,7,46,8],[46,9,46,10],[46,11,46,12],[46,13,46,14],[46,15,46,16],[46,17,46,18],[46,19,46,20],[46,21,46,22],[46,23,46,24],[46,25,46,26],[46,27,46,28],[46,29,46,30],[42,61,42,62],[42,63,42,64],[42,65,42,66],[42,67,42,68],[42,69,42,70],[42,51,42,52],[42,53,42,54],[42,55,42,56],[42,59,42,60],[42,41,42,42],[42,43,42,44],[42,45,42,46],[42,47,42,48],[42,49,42,50],[42,31,42,32],[42,33,42,34],[42,35,42,36],[42,37,42,38],[42,39,42,40],[42,25,42,26],[42,27,42,28],[42,29,42,30],[42,11,42,12],[42,13,42,14],[42,15,42,16],[42,17,42,18],[42,19,42,20],[42,57,42,58],[42,1,42,2],[42,3,42,4],[42,5,42,6],[42,7,42,8],[42,9,42,10],[2,1,2,12],[2,13,2,24],[3,13,3,14],[3,15,3,16],[3,17,3,18],[3,19,3,20],[3,21,3,22],[3,23,3,24],[3,11,3,12],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[42,21,42,22],[42,23,42,24],[2,25,2,36],[3,25,3,26],[3,27,3,28],[3,29,3,30],[3,31,3,32],[3,33,3,34],[3,35,3,36],[2,37,2,48],[3,37,3,38],[3,39,3,40],[3,41,3,42],[3,43,3,44],[3,45,3,46],[3,47,3,48],[2,49,2,60],[3,49,3,50],[3,51,3,52],[3,53,3,54],[3,55,3,56],[3,57,3,58],[3,59,3,60],[2,61,2,72],[3,61,3,62],[3,63,3,64],[3,65,3,66],[3,67,3,68],[3,69,3,70],[3,71,3,72]]}
[null,null,null,null,null,null,null,null,"Журнал учета замены нагр - на  2015г",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Установка"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Выход из строя"]
["№ СНИФ","СНИФ №1",null,null,null,null,null,null,null,null,null,null,null,"СНИФ №2",null,null,null,null,null,null,null,null,null,null,null,"СНИФ №3",null,null,null,null,null,null,null,null,null,null,null,"СНИФ №4",null,null,null,null,null,null,null,null,null,null,null,"СНИФ №5",null,null,null,null,null,null,null,null,null,null,null,"СНИФ №6"]
["Зона",1,null,2,null,3,null,4,null,5,null,6,null,1,null,2,null,3,null,4,null,5,null,6,null,1,null,2,null,3,null,4,null,5,null,6,null,1,null,2,null,3,null,4,null,5,null,6,null,1,null,2,null,3,null,4,null,5,null,6,null,1,null,2,null,3,null,4,null,5,null,6]
["Дата \\ Поставщик","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec","НПЦ","Pyrotec"]
["Идентификатор",null,"ID0001","ID0001"]
["2014-06-25",null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Идентификатор",null,"ID0001",null,null,null,"ID0003"]
["2015-01-27",null,2,null,null,null,1]
["Идентификатор","ID0004",null,"ID0001"]
["2015-02-13",1,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Идентификатор",null,null,"ID0005",null,null,"ID0003"]
["2015-02-20",null,null,1,null,null,2]
["Идентификатор",null,null,null,null,null,"ID0006"]
["2015-03-16",null,null,null,null,null,1]
["Идентификатор"]
["2015-03-17"]
["Идентификатор"]
["2015-04-18"]
["Идентификатор","ID0004"]
["2015-05-18",2]
["Идентификатор"]
["2015-06-18"]
["Идентификатор",null,null,"ID0005",null,null,"ID0006"]
["2015-07-18",null,null,2,null,null,2]
["Идентификатор","ID0007",null,null,null,"ID0007"]
["2015-09-18",1,null,null,null,1]
["Идентификатор"]
["2015-09-18"]
["Идентификатор"]
["2015-09-18"]
["Идентификатор","ID0007"]
["2015-09-28",2]
["Идентификатор","ID0008"]
["2015-10-28",1]
["Идентификатор"]
[]
["Идентификатор"]
[]
[]
["В работе, \nНе в работе",{"$f":"IF(SUM(B6:B38)>=1,LOOKUP(9E+307,B6:B38:B6:B38),)","v":1},{"$f":"IF(SUM(C6:C38)>=1,LOOKUP(9E+307,C6:C38:C6:C38),)","v":2},{"$f":"IF(SUM(D6:D38)>=1,LOOKUP(9E+307,D6:D38:D6:D38),)","v":2},{"$f":"IF(SUM(E6:E38)>=1,LOOKUP(9E+307,E6:E38:E6:E38),)","v":0},{"$f":"IF(SUM(F6:F38)>=1,LOOKUP(9E+307,F6:F38:F6:F38),)","v":1},{"$f":"IF(SUM(G6:G38)>=1,LOOKUP(9E+307,G6:G38:G6:G38),)","v":2},{"$f":"IF(SUM(H6:H38)>=1,LOOKUP(9E+307,H6:H38:H6:H38),)","v":0},{"$f":"IF(SUM(I6:I38)>=1,LOOKUP(9E+307,I6:I38:I6:I38),)","v":0},{"$f":"IF(SUM(J6:J38)>=1,LOOKUP(9E+307,J6:J38:J6:J38),)","v":0},{"$f":"IF(SUM(K6:K38)>=1,LOOKUP(9E+307,K6:K38:K6:K38),)","v":0},{"$f":"IF(SUM(L6:L38)>=1,LOOKUP(9E+307,L6:L38:L6:L38),)","v":0},{"$f":"IF(SUM(M6:M38)>=1,LOOKUP(9E+307,M6:M38:M6:M38),)","v":0},{"$f":"IF(SUM(N6:N38)>=1,LOOKUP(9E+307,N6:N38:N6:N38),)","v":0},{"$f":"IF(SUM(O6:O38)>=1,LOOKUP(9E+307,O6:O38:O6:O38),)","v":0},{"$f":"IF(SUM(P6:P38)>=1,LOOKUP(9E+307,P6:P38:P6:P38),)","v":0},{"$f":"IF(SUM(Q6:Q38)>=1,LOOKUP(9E+307,Q6:Q38:Q6:Q38),)","v":0},{"$f":"IF(SUM(R6:R38)>=1,LOOKUP(9E+307,R6:R38:R6:R38),)","v":0},{"$f":"IF(SUM(S6:S38)>=1,LOOKUP(9E+307,S6:S38:S6:S38),)","v":0},{"$f":"IF(SUM(T6:T38)>=1,LOOKUP(9E+307,T6:T38:T6:T38),)","v":0},{"$f":"IF(SUM(U6:U38)>=1,LOOKUP(9E+307,U6:U38:U6:U38),)","v":0},{"$f":"IF(SUM(V6:V38)>=1,LOOKUP(9E+307,V6:V38:V6:V38),)","v":0},{"$f":"IF(SUM(W6:W38)>=1,LOOKUP(9E+307,W6:W38:W6:W38),)","v":0},{"$f":"IF(SUM(X6:X38)>=1,LOOKUP(9E+307,X6:X38:X6:X38),)","v":0},{"$f":"IF(SUM(Y6:Y38)>=1,LOOKUP(9E+307,Y6:Y38:Y6:Y38),)","v":0},{"$f":"IF(SUM(Z6:Z38)>=1,LOOKUP(9E+307,Z6:Z38:Z6:Z38),)","v":0},{"$f":"IF(SUM(AA6:AA38)>=1,LOOKUP(9E+307,AA6:AA38:AA6:AA38),)","v":0},{"$f":"IF(SUM(AB6:AB38)>=1,LOOKUP(9E+307,AB6:AB38:AB6:AB38),)","v":0},{"$f":"IF(SUM(AC6:AC38)>=1,LOOKUP(9E+307,AC6:AC38:AC6:AC38),)","v":0},{"$f":"IF(SUM(AD6:AD38)>=1,LOOKUP(9E+307,AD6:AD38:AD6:AD38),)","v":0},{"$f":"IF(SUM(AE6:AE38)>=1,LOOKUP(9E+307,AE6:AE38:AE6:AE38),)","v":0},{"$f":"IF(SUM(AF6:AF38)>=1,LOOKUP(9E+307,AF6:AF38:AF6:AF38),)","v":0},{"$f":"IF(SUM(AG6:AG38)>=1,LOOKUP(9E+307,AG6:AG38:AG6:AG38),)","v":0},{"$f":"IF(SUM(AH6:AH38)>=1,LOOKUP(9E+307,AH6:AH38:AH6:AH38),)","v":0},{"$f":"IF(SUM(AI6:AI38)>=1,LOOKUP(9E+307,AI6:AI38:AI6:AI38),)","v":0},{"$f":"IF(SUM(AJ6:AJ38)>=1,LOOKUP(9E+307,AJ6:AJ38:AJ6:AJ38),)","v":0},{"$f":"IF(SUM(AK6:AK38)>=1,LOOKUP(9E+307,AK6:AK38:AK6:AK38),)","v":0},{"$f":"IF(SUM(AL6:AL38)>=1,LOOKUP(9E+307,AL6:AL38:AL6:AL38),)","v":0},{"$f":"IF(SUM(AM6:AM38)>=1,LOOKUP(9E+307,AM6:AM38:AM6:AM38),)","v":0},{"$f":"IF(SUM(AN6:AN38)>=1,LOOKUP(9E+307,AN6:AN38:AN6:AN38),)","v":0},{"$f":"IF(SUM(AO6:AO38)>=1,LOOKUP(9E+307,AO6:AO38:AO6:AO38),)","v":2},{"$f":"IF(SUM(AP6:AP38)>=1,LOOKUP(9E+307,AP6:AP38:AP6:AP38),)","v":0},{"$f":"IF(SUM(AQ6:AQ38)>=1,LOOKUP(9E+307,AQ6:AQ38:AQ6:AQ38),)","v":0},{"$f":"IF(SUM(AR6:AR38)>=1,LOOKUP(9E+307,AR6:AR38:AR6:AR38),)","v":0},{"$f":"IF(SUM(AS6:AS38)>=1,LOOKUP(9E+307,AS6:AS38:AS6:AS38),)","v":0},{"$f":"IF(SUM(AT6:AT38)>=1,LOOKUP(9E+307,AT6:AT38:AT6:AT38),)","v":0},{"$f":"IF(SUM(AU6:AU38)>=1,LOOKUP(9E+307,AU6:AU38:AU6:AU38),)","v":0},{"$f":"IF(SUM(AV6:AV38)>=1,LOOKUP(9E+307,AV6:AV38:AV6:AV38),)","v":0},{"$f":"IF(SUM(AW6:AW38)>=1,LOOKUP(9E+307,AW6:AW38:AW6:AW38),)","v":0},{"$f":"IF(SUM(AX6:AX38)>=1,LOOKUP(9E+307,AX6:AX38:AX6:AX38),)","v":0},{"$f":"IF(SUM(AY6:AY38)>=1,LOOKUP(9E+307,AY6:AY38:AY6:AY38),)","v":0},{"$f":"IF(SUM(AZ6:AZ38)>=1,LOOKUP(9E+307,AZ6:AZ38:AZ6:AZ38),)","v":0},{"$f":"IF(SUM(BA6:BA38)>=1,LOOKUP(9E+307,BA6:BA38:BA6:BA38),)","v":0},{"$f":"IF(SUM(BB6:BB38)>=1,LOOKUP(9E+307,BB6:BB38:BB6:BB38),)","v":0},{"$f":"IF(SUM(BC6:BC38)>=1,LOOKUP(9E+307,BC6:BC38:BC6:BC38),)","v":0},{"$f":"IF(SUM(BD6:BD38)>=1,LOOKUP(9E+307,BD6:BD38:BD6:BD38),)","v":0},{"$f":"IF(SUM(BE6:BE38)>=1,LOOKUP(9E+307,BE6:BE38:BE6:BE38),)","v":0},{"$f":"IF(SUM(BF6:BF38)>=1,LOOKUP(9E+307,BF6:BF38:BF6:BF38),)","v":0},{"$f":"IF(SUM(BG6:BG38)>=1,LOOKUP(9E+307,BG6:BG38:BG6:BG38),)","v":0},{"$f":"IF(SUM(BH6:BH38)>=1,LOOKUP(9E+307,BH6:BH38:BH6:BH38),)","v":0},{"$f":"IF(SUM(BI6:BI38)>=1,LOOKUP(9E+307,BI6:BI38:BI6:BI38),)","v":0},{"$f":"IF(SUM(BJ6:BJ38)>=1,LOOKUP(9E+307,BJ6:BJ38:BJ6:BJ38),)","v":0},{"$f":"IF(SUM(BK6:BK38)>=1,LOOKUP(9E+307,BK6:BK38:BK6:BK38),)","v":0},{"$f":"IF(SUM(BL6:BL38)>=1,LOOKUP(9E+307,BL6:BL38:BL6:BL38),)","v":0},{"$f":"IF(SUM(BM6:BM38)>=1,LOOKUP(9E+307,BM6:BM38:BM6:BM38),)","v":0},{"$f":"IF(SUM(BN6:BN38)>=1,LOOKUP(9E+307,BN6:BN38:BN6:BN38),)","v":0},{"$f":"IF(SUM(BO6:BO38)>=1,LOOKUP(9E+307,BO6:BO38:BO6:BO38),)","v":0},{"$f":"IF(SUM(BP6:BP38)>=1,LOOKUP(9E+307,BP6:BP38:BP6:BP38),)","v":0},{"$f":"IF(SUM(BQ6:BQ38)>=1,LOOKUP(9E+307,BQ6:BQ38:BQ6:BQ38),)","v":0},{"$f":"IF(SUM(BR6:BR38)>=1,LOOKUP(9E+307,BR6:BR38:BR6:BR38),)","v":0},{"$f":"IF(SUM(BS6:BS38)>=1,LOOKUP(9E+307,BS6:BS38:BS6:BS38),)","v":0},{"$f":"IF(SUM(BT6:BT38)>=1,LOOKUP(9E+307,BT6:BT38:BT6:BT38),)","v":0},{"$f":"IF(SUM(BU6:BU38)>=1,LOOKUP(9E+307,BU6:BU38:BU6:BU38),)","v":0}]
[]
["БылоУстановлено ВСЕГО",{"$f":"SUM(B44:C45)","v":4},null,{"$f":"SUM(D44:E45)","v":2},null,{"$f":"SUM(F44:G45)","v":3},null,{"$f":"SUM(H44:I45)","v":0},null,{"$f":"SUM(J44:K45)","v":0},null,{"$f":"SUM(L44:M45)","v":0},null,{"$f":"SUM(N44:O45)","v":0},null,{"$f":"SUM(P44:Q45)","v":0},null,{"$f":"SUM(R44:S45)","v":0},null,{"$f":"SUM(T44:U45)","v":0},null,{"$f":"SUM(V44:W45)","v":0},null,{"$f":"SUM(X44:Y45)","v":0},null,{"$f":"SUM(Z44:AA45)","v":0},null,{"$f":"SUM(AB44:AC45)","v":0},null,{"$f":"SUM(AD44:AE45)","v":0},null,{"$f":"SUM(AF44:AG45)","v":0},null,{"$f":"SUM(AH44:AI45)","v":0},null,{"$f":"SUM(AJ44:AK45)","v":0},null,{"$f":"SUM(AL44:AM45)","v":0},null,{"$f":"SUM(AN44:AO45)","v":1},null,{"$f":"SUM(AP44:AQ45)","v":0},null,{"$f":"SUM(AR44:AS45)","v":0},null,{"$f":"SUM(AT44:AU45)","v":0},null,{"$f":"SUM(AV44:AW45)","v":0},null,{"$f":"SUM(AX44:AY45)","v":0},null,{"$f":"SUM(AZ44:BA45)","v":0},null,{"$f":"SUM(BB44:BC45)","v":0},null,{"$f":"SUM(BD44:BE45)","v":0},null,{"$f":"SUM(BF44:BG45)","v":0},null,{"$f":"SUM(BH44:BI45)","v":0},null,{"$f":"SUM(BJ44:BK45)","v":0},null,{"$f":"SUM(BL44:BM45)","v":0},null,{"$f":"SUM(BN44:BO45)","v":0},null,{"$f":"SUM(BP44:BQ45)","v":0},null,{"$f":"SUM(BR44:BS45)","v":0},null,{"$f":"SUM(BT44:BU45)","v":0}]
["из них НПЦ",{"$f":"COUNTIF(B6:B38,\"1\")","v":3},null,{"$f":"COUNTIF(D6:D38,\"1\")","v":2},null,{"$f":"COUNTIF(F6:F38,\"1\")","v":1},null,{"$f":"COUNTIF(H6:H38,\"1\")","v":0},null,{"$f":"COUNTIF(J6:J38,\"1\")","v":0},null,{"$f":"COUNTIF(L6:L38,\"1\")","v":0},null,{"$f":"COUNTIF(N6:N38,\"1\")","v":0},null,{"$f":"COUNTIF(P6:P38,\"1\")","v":0},null,{"$f":"COUNTIF(R6:R38,\"1\")","v":0},null,{"$f":"COUNTIF(T6:T38,\"1\")","v":0},null,{"$f":"COUNTIF(V6:V38,\"1\")","v":0},null,{"$f":"COUNTIF(X6:X38,\"1\")","v":0},null,{"$f":"COUNTIF(Z6:Z38,\"1\")","v":0},null,{"$f":"COUNTIF(AB6:AB38,\"1\")","v":0},null,{"$f":"COUNTIF(AD6:AD38,\"1\")","v":0},null,{"$f":"COUNTIF(AF6:AF38,\"1\")","v":0},null,{"$f":"COUNTIF(AH6:AH38,\"1\")","v":0},null,{"$f":"COUNTIF(AJ6:AJ38,\"1\")","v":0},null,{"$f":"COUNTIF(AL6:AL38,\"1\")","v":0},null,{"$f":"COUNTIF(AN6:AN38,\"1\")","v":0},null,{"$f":"COUNTIF(AP6:AP38,\"1\")","v":0},null,{"$f":"COUNTIF(AR6:AR38,\"1\")","v":0},null,{"$f":"COUNTIF(AT6:AT38,\"1\")","v":0},null,{"$f":"COUNTIF(AV6:AV38,\"1\")","v":0},null,{"$f":"COUNTIF(AX6:AX38,\"1\")","v":0},null,{"$f":"COUNTIF(AZ6:AZ38,\"1\")","v":0},null,{"$f":"COUNTIF(BB6:BB38,\"1\")","v":0},null,{"$f":"COUNTIF(BD6:BD38,\"1\")","v":0},null,{"$f":"COUNTIF(BF6:BF38,\"1\")","v":0},null,{"$f":"COUNTIF(BH6:BH38,\"1\")","v":0},null,{"$f":"COUNTIF(BJ6:BJ38,\"1\")","v":0},null,{"$f":"COUNTIF(BL6:BL38,\"1\")","v":0},null,{"$f":"COUNTIF(BN6:BN38,\"1\")","v":0},null,{"$f":"COUNTIF(BP6:BP38,\"1\")","v":0},null,{"$f":"COUNTIF(BR6:BR38,\"1\")","v":0},null,{"$f":"COUNTIF(BT6:BT38,\"1\")","v":0}]
["из них Pyrotec",null,{"$f":"COUNTIF(C7:C39,\"1\")","v":1},null,{"$f":"COUNTIF(E7:E39,\"1\")","v":0},null,{"$f":"COUNTIF(G7:G39,\"1\")","v":2},null,{"$f":"COUNTIF(I7:I39,\"1\")","v":0},null,{"$f":"COUNTIF(K7:K39,\"1\")","v":0},null,{"$f":"COUNTIF(M7:M39,\"1\")","v":0},null,{"$f":"COUNTIF(O7:O39,\"1\")","v":0},null,{"$f":"COUNTIF(Q7:Q39,\"1\")","v":0},null,{"$f":"COUNTIF(S7:S39,\"1\")","v":0},null,{"$f":"COUNTIF(U7:U39,\"1\")","v":0},null,{"$f":"COUNTIF(W7:W39,\"1\")","v":0},null,{"$f":"COUNTIF(Y7:Y39,\"1\")","v":0},null,{"$f":"COUNTIF(AA7:AA39,\"1\")","v":0},null,{"$f":"COUNTIF(AC7:AC39,\"1\")","v":0},null,{"$f":"COUNTIF(AE7:AE39,\"1\")","v":0},null,{"$f":"COUNTIF(AG7:AG39,\"1\")","v":0},null,{"$f":"COUNTIF(AI7:AI39,\"1\")","v":0},null,{"$f":"COUNTIF(AK7:AK39,\"1\")","v":0},null,{"$f":"COUNTIF(AM7:AM39,\"1\")","v":0},null,{"$f":"COUNTIF(AO7:AO39,\"1\")","v":1},null,{"$f":"COUNTIF(AQ7:AQ39,\"1\")","v":0},null,{"$f":"COUNTIF(AS7:AS39,\"1\")","v":0},null,{"$f":"COUNTIF(AU7:AU39,\"1\")","v":0},null,{"$f":"COUNTIF(AW7:AW39,\"1\")","v":0},null,{"$f":"COUNTIF(AY7:AY39,\"1\")","v":0},null,{"$f":"COUNTIF(BA7:BA39,\"1\")","v":0},null,{"$f":"COUNTIF(BC7:BC39,\"1\")","v":0},null,{"$f":"COUNTIF(BE7:BE39,\"1\")","v":0},null,{"$f":"COUNTIF(BG7:BG39,\"1\")","v":0},null,{"$f":"COUNTIF(BI7:BI39,\"1\")","v":0},null,{"$f":"COUNTIF(BK7:BK39,\"1\")","v":0},null,{"$f":"COUNTIF(BM7:BM39,\"1\")","v":0},null,{"$f":"COUNTIF(BO7:BO39,\"1\")","v":0},null,{"$f":"COUNTIF(BQ7:BQ39,\"1\")","v":0},null,{"$f":"COUNTIF(BS7:BS39,\"1\")","v":0},null,{"$f":"COUNTIF(BU7:BU39,\"1\")","v":0}]
[]
["Вышло из строя всего",{"$f":"SUM(B48:C49)","v":3},null,{"$f":"SUM(D48:E49)","v":2},null,{"$f":"SUM(F48:G49)","v":2},null,{"$f":"SUM(H48:I49)","v":0},null,{"$f":"SUM(J48:K49)","v":0},null,{"$f":"SUM(L48:M49)","v":0},null,{"$f":"SUM(N48:O49)","v":0},null,{"$f":"SUM(P48:Q49)","v":0},null,{"$f":"SUM(R48:S49)","v":0},null,{"$f":"SUM(T48:U49)","v":0},null,{"$f":"SUM(V48:W49)","v":0},null,{"$f":"SUM(X48:Y49)","v":0},null,{"$f":"SUM(Z48:AA49)","v":0},null,{"$f":"SUM(AB48:AC49)","v":0},null,{"$f":"SUM(AD48:AE49)","v":0},null,{"$f":"SUM(AF48:AG49)","v":0},null,{"$f":"SUM(AH48:AI49)","v":0},null,{"$f":"SUM(AJ48:AK49)","v":0},null,{"$f":"SUM(AL48:AM49)","v":0},null,{"$f":"SUM(AN48:AO49)","v":1},null,{"$f":"SUM(AP48:AQ49)","v":0},null,{"$f":"SUM(AR48:AS49)","v":0},null,{"$f":"SUM(AT48:AU49)","v":0},null,{"$f":"SUM(AV48:AW49)","v":0},null,{"$f":"SUM(AX48:AY49)","v":0},null,{"$f":"SUM(AZ48:BA49)","v":0},null,{"$f":"SUM(BB48:BC49)","v":0},null,{"$f":"SUM(BD48:BE49)","v":0},null,{"$f":"SUM(BF48:BG49)","v":0},null,{"$f":"SUM(BH48:BI49)","v":0},null,{"$f":"SUM(BJ48:BK49)","v":0},null,{"$f":"SUM(BL48:BM49)","v":0},null,{"$f":"SUM(BN48:BO49)","v":0},null,{"$f":"SUM(BP48:BQ49)","v":0},null,{"$f":"SUM(BR48:BS49)","v":0},null,{"$f":"SUM(BT48:BU49)","v":0}]
["из них НПЦ",{"$f":"IFERROR(COUNTIF(B6:B38,\"2\"),\"\")","v":2},null,{"$f":"IFERROR(COUNTIF(D6:D38,\"2\"),\"\")","v":2},null,{"$f":"IFERROR(COUNTIF(F6:F38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(H6:H38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(J6:J38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(L6:L38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(N6:N38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(P6:P38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(R6:R38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(T6:T38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(V6:V38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(X6:X38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(Z6:Z38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AB6:AB38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AD6:AD38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AF6:AF38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AH6:AH38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AJ6:AJ38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AL6:AL38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AN6:AN38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AP6:AP38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AR6:AR38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AT6:AT38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AV6:AV38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AX6:AX38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AZ6:AZ38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(BB6:BB38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(BD6:BD38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(BF6:BF38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(BH6:BH38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(BJ6:BJ38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(BL6:BL38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(BN6:BN38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(BP6:BP38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(BR6:BR38,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(BT6:BT38,\"2\"),\"\")","v":0}]
["из них Pyrotec",null,{"$f":"IFERROR(COUNTIF(C7:C39,\"2\"),\"\")","v":1},null,{"$f":"IFERROR(COUNTIF(E7:E39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(G7:G39,\"2\"),\"\")","v":2},null,{"$f":"IFERROR(COUNTIF(I7:I39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(K7:K39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(M7:M39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(O7:O39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(Q7:Q39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(S7:S39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(U7:U39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(W7:W39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(Y7:Y39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AA7:AA39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AC7:AC39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AE7:AE39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AG7:AG39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AI7:AI39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AK7:AK39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AM7:AM39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AO7:AO39,\"2\"),\"\")","v":1},null,{"$f":"IFERROR(COUNTIF(AQ7:AQ39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AS7:AS39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AU7:AU39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AW7:AW39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(AY7:AY39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(BA7:BA39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(BC7:BC39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(BE7:BE39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(BG7:BG39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(BI7:BI39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(BK7:BK39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(BM7:BM39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(BO7:BO39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(BQ7:BQ39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(BS7:BS39,\"2\"),\"\")","v":0},null,{"$f":"IFERROR(COUNTIF(BU7:BU39,\"2\"),\"\")","v":0}]
["По причине"]
[" КАП. РЕМОНТ катриджа Кол-во",{"$f":"КолЦвет(B6:B38,A51)","v":1},{"$f":"КолЦвет(C6:C38,A51)","v":0},{"$f":"КолЦвет(D6:D38,A51)","v":0},{"$f":"КолЦвет(E6:E38,A51)","v":0},{"$f":"КолЦвет(F6:F38,A51)","v":0},{"$f":"КолЦвет(G6:G38,A51)","v":1},{"$f":"КолЦвет(H6:H38,A51)","v":0},{"$f":"КолЦвет(I6:I38,A51)","v":0},{"$f":"КолЦвет(J6:J38,A51)","v":0},{"$f":"КолЦвет(K6:K38,A51)","v":0},{"$f":"КолЦвет(L6:L38,A51)","v":0},{"$f":"КолЦвет(M6:M38,A51)","v":0},{"$f":"КолЦвет(N6:N38,A51)","v":0},{"$f":"КолЦвет(O6:O38,A51)","v":0},{"$f":"КолЦвет(P6:P38,A51)","v":0},{"$f":"КолЦвет(Q6:Q38,A51)","v":0},{"$f":"КолЦвет(R6:R38,A51)","v":0},{"$f":"КолЦвет(S6:S38,A51)","v":0},{"$f":"КолЦвет(T6:T38,A51)","v":0},{"$f":"КолЦвет(U6:U38,A51)","v":0},{"$f":"КолЦвет(V6:V38,A51)","v":0},{"$f":"КолЦвет(W6:W38,A51)","v":0},{"$f":"КолЦвет(X6:X38,A51)","v":0},{"$f":"КолЦвет(Y6:Y38,A51)","v":0},{"$f":"КолЦвет(Z6:Z38,A51)","v":0},{"$f":"КолЦвет(AA6:AA38,A51)","v":0},{"$f":"КолЦвет(AB6:AB38,A51)","v":0},{"$f":"КолЦвет(AC6:AC38,A51)","v":0},{"$f":"КолЦвет(AD6:AD38,A51)","v":0},{"$f":"КолЦвет(AE6:AE38,A51)","v":0},{"$f":"КолЦвет(AF6:AF38,A51)","v":0},{"$f":"КолЦвет(AG6:AG38,A51)","v":0},{"$f":"КолЦвет(AH6:AH38,A51)","v":0},{"$f":"КолЦвет(AI6:AI38,A51)","v":0},{"$f":"КолЦвет(AJ6:AJ38,A51)","v":0},{"$f":"КолЦвет(AK6:AK38,A51)","v":0},{"$f":"КолЦвет(AL6:AL38,A51)","v":0},{"$f":"КолЦвет(AM6:AM38,A51)","v":0},{"$f":"КолЦвет(AN6:AN38,A51)","v":0},{"$f":"КолЦвет(AO6:AO38,A51)","v":0},{"$f":"КолЦвет(AP6:AP38,A51)","v":0},{"$f":"КолЦвет(AQ6:AQ38,A51)","v":0},{"$f":"КолЦвет(AR6:AR38,A51)","v":0},{"$f":"КолЦвет(AS6:AS38,A51)","v":0},{"$f":"КолЦвет(AT6:AT38,A51)","v":0},{"$f":"КолЦвет(AU6:AU38,A51)","v":0},{"$f":"КолЦвет(AV6:AV38,A51)","v":0},{"$f":"КолЦвет(AW6:AW38,A51)","v":0},{"$f":"КолЦвет(AX6:AX38,A51)","v":0},{"$f":"КолЦвет(AY6:AY38,A51)","v":0},{"$f":"КолЦвет(AZ6:AZ38,A51)","v":0},{"$f":"КолЦвет(BA6:BA38,A51)","v":0},{"$f":"КолЦвет(BB6:BB38,A51)","v":0},{"$f":"КолЦвет(BC6:BC38,A51)","v":0},{"$f":"КолЦвет(BD6:BD38,A51)","v":0},{"$f":"КолЦвет(BE6:BE38,A51)","v":0},{"$f":"КолЦвет(BF6:BF38,A51)","v":0},{"$f":"КолЦвет(BG6:BG38,A51)","v":0},{"$f":"КолЦвет(BH6:BH38,A51)","v":0},{"$f":"КолЦвет(BI6:BI38,A51)","v":0},{"$f":"КолЦвет(BJ6:BJ38,A51)","v":0},{"$f":"КолЦвет(BK6:BK38,A51)","v":0},{"$f":"КолЦвет(BL6:BL38,A51)","v":0},{"$f":"КолЦвет(BM6:BM38,A51)","v":0},{"$f":"КолЦвет(BN6:BN38,A51)","v":0},{"$f":"КолЦвет(BO6:BO38,A51)","v":0},{"$f":"КолЦвет(BP6:BP38,A51)","v":0},{"$f":"КолЦвет(BQ6:BQ38,A51)","v":0},{"$f":"КолЦвет(BR6:BR38,A51)","v":0},{"$f":"КолЦвет(BS6:BS38,A51)","v":0},{"$f":"КолЦвет(BT6:BT38,A51)","v":0},{"$f":"КолЦвет(BU6:BU38,A51)","v":0}]
["Вытащить нагреватель из\n катриджа невозможно",{"$f":"КолЦвет(B6:B38,A52)","v":1},{"$f":"КолЦвет(C6:C38,A52)","v":0},{"$f":"КолЦвет(D6:D38,A52)","v":0},{"$f":"КолЦвет(E6:E38,A52)","v":0},{"$f":"КолЦвет(F6:F38,A52)","v":0},{"$f":"КолЦвет(G6:G38,A52)","v":0},{"$f":"КолЦвет(H6:H38,A52)","v":0},{"$f":"КолЦвет(I6:I38,A52)","v":0},{"$f":"КолЦвет(J6:J38,A52)","v":0},{"$f":"КолЦвет(K6:K38,A52)","v":0},{"$f":"КолЦвет(L6:L38,A52)","v":0},{"$f":"КолЦвет(M6:M38,A52)","v":0},{"$f":"КолЦвет(N6:N38,A52)","v":0},{"$f":"КолЦвет(O6:O38,A52)","v":0},{"$f":"КолЦвет(P6:P38,A52)","v":0},{"$f":"КолЦвет(Q6:Q38,A52)","v":0},{"$f":"КолЦвет(R6:R38,A52)","v":0},{"$f":"КолЦвет(S6:S38,A52)","v":0},{"$f":"КолЦвет(T6:T38,A52)","v":0},{"$f":"КолЦвет(U6:U38,A52)","v":0},{"$f":"КолЦвет(V6:V38,A52)","v":0},{"$f":"КолЦвет(W6:W38,A52)","v":0},{"$f":"КолЦвет(X6:X38,A52)","v":0},{"$f":"КолЦвет(Y6:Y38,A52)","v":0},{"$f":"КолЦвет(Z6:Z38,A52)","v":0},{"$f":"КолЦвет(AA6:AA38,A52)","v":0},{"$f":"КолЦвет(AB6:AB38,A52)","v":0},{"$f":"КолЦвет(AC6:AC38,A52)","v":0},{"$f":"КолЦвет(AD6:AD38,A52)","v":0},{"$f":"КолЦвет(AE6:AE38,A52)","v":0},{"$f":"КолЦвет(AF6:AF38,A52)","v":0},{"$f":"КолЦвет(AG6:AG38,A52)","v":0},{"$f":"КолЦвет(AH6:AH38,A52)","v":0},{"$f":"КолЦвет(AI6:AI38,A52)","v":0},{"$f":"КолЦвет(AJ6:AJ38,A52)","v":0},{"$f":"КолЦвет(AK6:AK38,A52)","v":0},{"$f":"КолЦвет(AL6:AL38,A52)","v":0},{"$f":"КолЦвет(AM6:AM38,A52)","v":0},{"$f":"КолЦвет(AN6:AN38,A52)","v":0},{"$f":"КолЦвет(AO6:AO38,A52)","v":0},{"$f":"КолЦвет(AP6:AP38,A52)","v":0},{"$f":"КолЦвет(AQ6:AQ38,A52)","v":0},{"$f":"КолЦвет(AR6:AR38,A52)","v":0},{"$f":"КолЦвет(AS6:AS38,A52)","v":0},{"$f":"КолЦвет(AT6:AT38,A52)","v":0},{"$f":"КолЦвет(AU6:AU38,A52)","v":0},{"$f":"КолЦвет(AV6:AV38,A52)","v":0},{"$f":"КолЦвет(AW6:AW38,A52)","v":0},{"$f":"КолЦвет(AX6:AX38,A52)","v":0},{"$f":"КолЦвет(AY6:AY38,A52)","v":0},{"$f":"КолЦвет(AZ6:AZ38,A52)","v":0},{"$f":"КолЦвет(BA6:BA38,A52)","v":0},{"$f":"КолЦвет(BB6:BB38,A52)","v":0},{"$f":"КолЦвет(BC6:BC38,A52)","v":0},{"$f":"КолЦвет(BD6:BD38,A52)","v":0},{"$f":"КолЦвет(BE6:BE38,A52)","v":0},{"$f":"КолЦвет(BF6:BF38,A52)","v":0},{"$f":"КолЦвет(BG6:BG38,A52)","v":0},{"$f":"КолЦвет(BH6:BH38,A52)","v":0},{"$f":"КолЦвет(BI6:BI38,A52)","v":0},{"$f":"КолЦвет(BJ6:BJ38,A52)","v":0},{"$f":"КолЦвет(BK6:BK38,A52)","v":0},{"$f":"КолЦвет(BL6:BL38,A52)","v":0},{"$f":"КолЦвет(BM6:BM38,A52)","v":0},{"$f":"КолЦвет(BN6:BN38,A52)","v":0},{"$f":"КолЦвет(BO6:BO38,A52)","v":0},{"$f":"КолЦвет(BP6:BP38,A52)","v":0},{"$f":"КолЦвет(BQ6:BQ38,A52)","v":0},{"$f":"КолЦвет(BR6:BR38,A52)","v":0},{"$f":"КолЦвет(BS6:BS38,A52)","v":0},{"$f":"КолЦвет(BT6:BT38,A52)","v":0},{"$f":"КолЦвет(BU6:BU38,A52)","v":0}]
[]
[]
["Средний срок службы",null,null,null,null,null,null,{"$f":"IFERROR(IF(COUNTIF(H$6:H$38,1)-COUNTIF(H$6:H$38,2)=0,(SUMIF(H$6:H$38,2,$A$6:$A$38)-SUMIF(H$6:H$38,1,$A$6:$A$38))/COUNTIF(H$6:H$38,2),\"\"),\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",233,"","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IFERROR(IF(COUNTIF(BO$6:BO$38,1)-COUNTIF(BO$6:BO$38,2)=0,(SUMIF(BO$6:BO$38,2,$A$6:$A$38)-SUMIF(BO$6:BO$38,1,$A$6:$A$38))/COUNTIF(BO$6:BO$38,2),\"\"),\"\")","v":""},"","","","","",""]
["Макс. срок службы"]
["Мин. Срок службы"]
["Идентификатор \\ срок службы"]
["ID0001",null,{"$f":"A9-A7","v":216},{"$f":"A11-A7","v":233}]
["ID0002"]
["ID0003",null,null,null,null,null,{"$f":"A13-A9","v":24}]
["ID0004",{"$f":"A21-A11","v":94}]
["ID0005",null,null,{"$f":"A25-A13","v":148}]
["ID0006",null,null,null,null,null,{"$f":"A25-A15","v":124}]
["ID0007",{"$f":"A33-A27","v":10}]
["ID0008"]
["ID0009"]
["ID0010"]
["ID0011"]