{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,6,1,7]]}
[]
[null,null,null,null,null,null,"инженер"]
["сканирование","квитанция","ячейка","время","статус","изделие","ССИ1","ССИ2"]
["150820-001ПA01",{"$f":"LEFT(A4,10)","v":"150820-001"},{"$f":"RIGHT(A4,4)","v":"ПA01"},"2020-08-15T13:00:00",{"$f":"IF(IFERROR(FIND(\"СИ\",C4),0)>0,\"в ремонте\",IF(IFERROR(FIND(\"Г\",C4),0)>0,\"отремонтирован\",\"\"))","v":""},{"$f":"B4","v":"150820-001"},{"$f":"IF(AND($E4=\"в ремонте\",$C4=G$3),_xlfn.AGGREGATE(15,6,$D4:$D$19/($F4=$F4:$F$19)/($E4:$E$19=\"отремонтирован\"),1)-$D4,\"\")","v":""},{"$f":"IF(AND($E4=\"в ремонте\",$C4=H$3),_xlfn.AGGREGATE(15,6,$D4:$D$19/($F4=$F4:$F$19)/($E4:$E$19=\"отремонтирован\"),1)-$D4,\"\")","v":""}]
["150820-002ПA02","150820-002","ПA02","2020-08-15T13:03:00","","150820-002",{"$f":"IF(AND($E5=\"в ремонте\",$C5=G$3),_xlfn.AGGREGATE(15,6,$D5:$D$19/($F5=$F5:$F$19)/($E5:$E$19=\"отремонтирован\"),1)-$D5,\"\")","v":""},{"$f":"IF(AND($E5=\"в ремонте\",$C5=H$3),_xlfn.AGGREGATE(15,6,$D5:$D$19/($F5=$F5:$F$19)/($E5:$E$19=\"отремонтирован\"),1)-$D5,\"\")","v":""}]
["150820-003ПA07","150820-003","ПA07","2020-08-15T13:05:59.995","","150820-003",{"$f":"IF(AND($E6=\"в ремонте\",$C6=G$3),_xlfn.AGGREGATE(15,6,$D6:$D$19/($F6=$F6:$F$19)/($E6:$E$19=\"отремонтирован\"),1)-$D6,\"\")","v":""},{"$f":"IF(AND($E6=\"в ремонте\",$C6=H$3),_xlfn.AGGREGATE(15,6,$D6:$D$19/($F6=$F6:$F$19)/($E6:$E$19=\"отремонтирован\"),1)-$D6,\"\")","v":""}]
["150820-004ПA05","150820-004","ПA05","2020-08-15T13:08:59.995","","150820-004",{"$f":"IF(AND($E7=\"в ремонте\",$C7=G$3),_xlfn.AGGREGATE(15,6,$D7:$D$19/($F7=$F7:$F$19)/($E7:$E$19=\"отремонтирован\"),1)-$D7,\"\")","v":""},{"$f":"IF(AND($E7=\"в ремонте\",$C7=H$3),_xlfn.AGGREGATE(15,6,$D7:$D$19/($F7=$F7:$F$19)/($E7:$E$19=\"отремонтирован\"),1)-$D7,\"\")","v":""}]
["150820-001ССИ1","150820-001","ССИ1","2020-08-15T13:11:59.995","в ремонте","150820-001",{"$f":"IF(AND($E8=\"в ремонте\",$C8=G$3),_xlfn.AGGREGATE(15,6,$D8:$D$19/($F8=$F8:$F$19)/($E8:$E$19=\"отремонтирован\"),1)-$D8,\"\")","v":3.3333391205815133E-2},{"$f":"IF(AND($E8=\"в ремонте\",$C8=H$3),_xlfn.AGGREGATE(15,6,$D8:$D$19/($F8=$F8:$F$19)/($E8:$E$19=\"отремонтирован\"),1)-$D8,\"\")","v":""}]
["150820-001ГА01","150820-001","ГА01","2020-08-15T14:00:00","отремонтирован","150820-001",{"$f":"IF(AND($E9=\"в ремонте\",$C9=G$3),_xlfn.AGGREGATE(15,6,$D9:$D$19/($F9=$F9:$F$19)/($E9:$E$19=\"отремонтирован\"),1)-$D9,\"\")","v":""},{"$f":"IF(AND($E9=\"в ремонте\",$C9=H$3),_xlfn.AGGREGATE(15,6,$D9:$D$19/($F9=$F9:$F$19)/($E9:$E$19=\"отремонтирован\"),1)-$D9,\"\")","v":""}]
["150820-002ССИ2","150820-002","ССИ2","2020-08-15T14:01:00","в ремонте","150820-002",{"$f":"IF(AND($E10=\"в ремонте\",$C10=G$3),_xlfn.AGGREGATE(15,6,$D10:$D$19/($F10=$F10:$F$19)/($E10:$E$19=\"отремонтирован\"),1)-$D10,\"\")","v":""},{"$f":"IF(AND($E10=\"в ремонте\",$C10=H$3),_xlfn.AGGREGATE(15,6,$D10:$D$19/($F10=$F10:$F$19)/($E10:$E$19=\"отремонтирован\"),1)-$D10,\"\")","v":1.250005787005648E-2}]
["150820-001В001","150820-001","В001","2020-08-15T14:10:00","","150820-001",{"$f":"IF(AND($E11=\"в ремонте\",$C11=G$3),_xlfn.AGGREGATE(15,6,$D11:$D$19/($F11=$F11:$F$19)/($E11:$E$19=\"отремонтирован\"),1)-$D11,\"\")","v":""},{"$f":"IF(AND($E11=\"в ремонте\",$C11=H$3),_xlfn.AGGREGATE(15,6,$D11:$D$19/($F11=$F11:$F$19)/($E11:$E$19=\"отремонтирован\"),1)-$D11,\"\")","v":""}]
["150820-003ССИ1","150820-003","ССИ1","2020-08-15T14:15:00","в ремонте","150820-003",{"$f":"IF(AND($E12=\"в ремонте\",$C12=G$3),_xlfn.AGGREGATE(15,6,$D12:$D$19/($F12=$F12:$F$19)/($E12:$E$19=\"отремонтирован\"),1)-$D12,\"\")","v":1.1111111110949423E-2},{"$f":"IF(AND($E12=\"в ремонте\",$C12=H$3),_xlfn.AGGREGATE(15,6,$D12:$D$19/($F12=$F12:$F$19)/($E12:$E$19=\"отремонтирован\"),1)-$D12,\"\")","v":""}]
["150820-002ГА02","150820-002","ГА02","2020-08-15T14:19:00.005","отремонтирован","150820-002",{"$f":"IF(AND($E13=\"в ремонте\",$C13=G$3),_xlfn.AGGREGATE(15,6,$D13:$D$19/($F13=$F13:$F$19)/($E13:$E$19=\"отремонтирован\"),1)-$D13,\"\")","v":""},{"$f":"IF(AND($E13=\"в ремонте\",$C13=H$3),_xlfn.AGGREGATE(15,6,$D13:$D$19/($F13=$F13:$F$19)/($E13:$E$19=\"отремонтирован\"),1)-$D13,\"\")","v":""}]
["150820-002В001","150820-002","В001","2020-08-15T14:22:00","","150820-002",{"$f":"IF(AND($E14=\"в ремонте\",$C14=G$3),_xlfn.AGGREGATE(15,6,$D14:$D$19/($F14=$F14:$F$19)/($E14:$E$19=\"отремонтирован\"),1)-$D14,\"\")","v":""},{"$f":"IF(AND($E14=\"в ремонте\",$C14=H$3),_xlfn.AGGREGATE(15,6,$D14:$D$19/($F14=$F14:$F$19)/($E14:$E$19=\"отремонтирован\"),1)-$D14,\"\")","v":""}]
["150820-004ССИ2","150820-004","ССИ2","2020-08-15T14:24:00","в ремонте","150820-004",{"$f":"IF(AND($E15=\"в ремонте\",$C15=G$3),_xlfn.AGGREGATE(15,6,$D15:$D$19/($F15=$F15:$F$19)/($E15:$E$19=\"отремонтирован\"),1)-$D15,\"\")","v":""},{"$f":"IF(AND($E15=\"в ремонте\",$C15=H$3),_xlfn.AGGREGATE(15,6,$D15:$D$19/($F15=$F15:$F$19)/($E15:$E$19=\"отремонтирован\"),1)-$D15,\"\")","v":1.3888888890505768E-2}]
["150820-003ГА01","150820-003","ГА01","2020-08-15T14:31:00","отремонтирован","150820-003",{"$f":"IF(AND($E16=\"в ремонте\",$C16=G$3),_xlfn.AGGREGATE(15,6,$D16:$D$19/($F16=$F16:$F$19)/($E16:$E$19=\"отремонтирован\"),1)-$D16,\"\")","v":""},{"$f":"IF(AND($E16=\"в ремонте\",$C16=H$3),_xlfn.AGGREGATE(15,6,$D16:$D$19/($F16=$F16:$F$19)/($E16:$E$19=\"отремонтирован\"),1)-$D16,\"\")","v":""}]
["150820-004ГА02","150820-004","ГА02","2020-08-15T14:44:00","отремонтирован","150820-004",{"$f":"IF(AND($E17=\"в ремонте\",$C17=G$3),_xlfn.AGGREGATE(15,6,$D17:$D$19/($F17=$F17:$F$19)/($E17:$E$19=\"отремонтирован\"),1)-$D17,\"\")","v":""},{"$f":"IF(AND($E17=\"в ремонте\",$C17=H$3),_xlfn.AGGREGATE(15,6,$D17:$D$19/($F17=$F17:$F$19)/($E17:$E$19=\"отремонтирован\"),1)-$D17,\"\")","v":""}]
["150820-004В001","150820-004","В001","2020-08-15T15:58:00","","150820-004",{"$f":"IF(AND($E18=\"в ремонте\",$C18=G$3),_xlfn.AGGREGATE(15,6,$D18:$D$19/($F18=$F18:$F$19)/($E18:$E$19=\"отремонтирован\"),1)-$D18,\"\")","v":""},{"$f":"IF(AND($E18=\"в ремонте\",$C18=H$3),_xlfn.AGGREGATE(15,6,$D18:$D$19/($F18=$F18:$F$19)/($E18:$E$19=\"отремонтирован\"),1)-$D18,\"\")","v":""}]
["150820-003В001","150820-003","В001","2020-08-15T16:37:00","","150820-003",{"$f":"IF(AND($E19=\"в ремонте\",$C19=G$3),_xlfn.AGGREGATE(15,6,$D19:$D$19/($F19=$F19:$F$19)/($E19:$E$19=\"отремонтирован\"),1)-$D19,\"\")","v":""},{"$f":"IF(AND($E19=\"в ремонте\",$C19=H$3),_xlfn.AGGREGATE(15,6,$D19:$D$19/($F19=$F19:$F$19)/($E19:$E$19=\"отремонтирован\"),1)-$D19,\"\")","v":""}]
[null,"",""]
[null,"","",null,null,null,null,null,{"$f":"IF(AND($E21=\"в ремонте\",$C21=G$3),INDEX($D$19:$D21,MATCH(1,($F21=$F$19:$F21)*($E$19:$E21=\"отремонтирован\"),0))-$D21,\"\")","v":""}]
[null,"","",null,null,null,null,null,{"$f":"IF(AND($E22=\"в ремонте\",$C22=G$3),INDEX($D$19:$D22,MATCH(1,($F22=$F$19:$F22)*($E$19:$E22=\"отремонтирован\"),0))-$D22,\"\")","v":""}]
[null,"","",null,null,null,null,null,{"$f":"IF(AND($E23=\"в ремонте\",$C23=G$3),INDEX($D$19:$D23,MATCH(1,($F23=$F$19:$F23)*($E$19:$E23=\"отремонтирован\"),0))-$D23,\"\")","v":""}]
[null,"","",null,null,null,null,null,{"$f":"IF(AND($E24=\"в ремонте\",$C24=G$3),INDEX($D$19:$D24,MATCH(1,($F24=$F$19:$F24)*($E$19:$E24=\"отремонтирован\"),0))-$D24,\"\")","v":""}]