{"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":8,"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),VLOOKUP($F4,IF({1,0},$F5:$F99,$D5:$D99),2,)-$D4,\"\")","v":""},{"$f":"IF(AND($E4=\"в ремонте\",$C4=H$3),VLOOKUP($F4,IF({1,0},$F5:$F99,$D5:$D99),2,)-$D4,\"\")","v":""}]
["150820-002ПA02","150820-002","ПA02","2020-08-15T13:03:00","","150820-002",{"$f":"IF(AND($E5=\"в ремонте\",$C5=G$3),VLOOKUP($F5,IF({1,0},$F6:$F100,$D6:$D100),2,)-$D5,\"\")","v":""},{"$f":"IF(AND($E5=\"в ремонте\",$C5=H$3),VLOOKUP($F5,IF({1,0},$F6:$F100,$D6:$D100),2,)-$D5,\"\")","v":""}]
["150820-003ПA07","150820-003","ПA07","2020-08-15T13:05:59.995","","150820-003",{"$f":"IF(AND($E6=\"в ремонте\",$C6=G$3),VLOOKUP($F6,IF({1,0},$F7:$F101,$D7:$D101),2,)-$D6,\"\")","v":""},{"$f":"IF(AND($E6=\"в ремонте\",$C6=H$3),VLOOKUP($F6,IF({1,0},$F7:$F101,$D7:$D101),2,)-$D6,\"\")","v":""}]
["150820-004ПA05","150820-004","ПA05","2020-08-15T13:08:59.995","","150820-004",{"$f":"IF(AND($E7=\"в ремонте\",$C7=G$3),VLOOKUP($F7,IF({1,0},$F8:$F102,$D8:$D102),2,)-$D7,\"\")","v":""},{"$f":"IF(AND($E7=\"в ремонте\",$C7=H$3),VLOOKUP($F7,IF({1,0},$F8:$F102,$D8:$D102),2,)-$D7,\"\")","v":""}]
["150820-001ССИ1","150820-001","ССИ1","2020-08-15T13:11:59.995","в ремонте","150820-001",{"$f":"IF(AND($E8=\"в ремонте\",$C8=G$3),VLOOKUP($F8,IF({1,0},$F9:$F103,$D9:$D103),2,)-$D8,\"\")","v":3.3333391205815133E-2},{"$f":"IF(AND($E8=\"в ремонте\",$C8=H$3),VLOOKUP($F8,IF({1,0},$F9:$F103,$D9:$D103),2,)-$D8,\"\")","v":""}]
["150820-001ГА01","150820-001","ГА01","2020-08-15T14:00:00","отремонтирован","150820-001",{"$f":"IF(AND($E9=\"в ремонте\",$C9=G$3),VLOOKUP($F9,IF({1,0},$F10:$F104,$D10:$D104),2,)-$D9,\"\")","v":""},{"$f":"IF(AND($E9=\"в ремонте\",$C9=H$3),VLOOKUP($F9,IF({1,0},$F10:$F104,$D10:$D104),2,)-$D9,\"\")","v":""}]
["150820-002ССИ2","150820-002","ССИ2","2020-08-15T14:01:00","в ремонте","150820-002",{"$f":"IF(AND($E10=\"в ремонте\",$C10=G$3),VLOOKUP($F10,IF({1,0},$F11:$F105,$D11:$D105),2,)-$D10,\"\")","v":""},{"$f":"IF(AND($E10=\"в ремонте\",$C10=H$3),VLOOKUP($F10,IF({1,0},$F11:$F105,$D11:$D105),2,)-$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),VLOOKUP($F11,IF({1,0},$F12:$F106,$D12:$D106),2,)-$D11,\"\")","v":""},{"$f":"IF(AND($E11=\"в ремонте\",$C11=H$3),VLOOKUP($F11,IF({1,0},$F12:$F106,$D12:$D106),2,)-$D11,\"\")","v":""}]
["150820-003ССИ1","150820-003","ССИ1","2020-08-15T14:15:00","в ремонте","150820-003",{"$f":"IF(AND($E12=\"в ремонте\",$C12=G$3),VLOOKUP($F12,IF({1,0},$F13:$F107,$D13:$D107),2,)-$D12,\"\")","v":1.1111111110949423E-2},{"$f":"IF(AND($E12=\"в ремонте\",$C12=H$3),VLOOKUP($F12,IF({1,0},$F13:$F107,$D13:$D107),2,)-$D12,\"\")","v":""}]
["150820-002ГА02","150820-002","ГА02","2020-08-15T14:19:00.005","отремонтирован","150820-002",{"$f":"IF(AND($E13=\"в ремонте\",$C13=G$3),VLOOKUP($F13,IF({1,0},$F14:$F108,$D14:$D108),2,)-$D13,\"\")","v":""},{"$f":"IF(AND($E13=\"в ремонте\",$C13=H$3),VLOOKUP($F13,IF({1,0},$F14:$F108,$D14:$D108),2,)-$D13,\"\")","v":""}]
["150820-002В001","150820-002","В001","2020-08-15T14:22:00","","150820-002",{"$f":"IF(AND($E14=\"в ремонте\",$C14=G$3),VLOOKUP($F14,IF({1,0},$F15:$F109,$D15:$D109),2,)-$D14,\"\")","v":""},{"$f":"IF(AND($E14=\"в ремонте\",$C14=H$3),VLOOKUP($F14,IF({1,0},$F15:$F109,$D15:$D109),2,)-$D14,\"\")","v":""}]
["150820-004ССИ2","150820-004","ССИ2","2020-08-15T14:24:00","в ремонте","150820-004",{"$f":"IF(AND($E15=\"в ремонте\",$C15=G$3),VLOOKUP($F15,IF({1,0},$F16:$F110,$D16:$D110),2,)-$D15,\"\")","v":""},{"$f":"IF(AND($E15=\"в ремонте\",$C15=H$3),VLOOKUP($F15,IF({1,0},$F16:$F110,$D16:$D110),2,)-$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),VLOOKUP($F16,IF({1,0},$F17:$F111,$D17:$D111),2,)-$D16,\"\")","v":""},{"$f":"IF(AND($E16=\"в ремонте\",$C16=H$3),VLOOKUP($F16,IF({1,0},$F17:$F111,$D17:$D111),2,)-$D16,\"\")","v":""}]
["150820-004ГА02","150820-004","ГА02","2020-08-15T14:44:00","отремонтирован","150820-004",{"$f":"IF(AND($E17=\"в ремонте\",$C17=G$3),VLOOKUP($F17,IF({1,0},$F18:$F112,$D18:$D112),2,)-$D17,\"\")","v":""},{"$f":"IF(AND($E17=\"в ремонте\",$C17=H$3),VLOOKUP($F17,IF({1,0},$F18:$F112,$D18:$D112),2,)-$D17,\"\")","v":""}]
["150820-004В001","150820-004","В001","2020-08-15T15:58:00","","150820-004",{"$f":"IF(AND($E18=\"в ремонте\",$C18=G$3),VLOOKUP($F18,IF({1,0},$F19:$F113,$D19:$D113),2,)-$D18,\"\")","v":""},{"$f":"IF(AND($E18=\"в ремонте\",$C18=H$3),VLOOKUP($F18,IF({1,0},$F19:$F113,$D19:$D113),2,)-$D18,\"\")","v":""}]
["150820-003В001","150820-003","В001","2020-08-15T16:37:00","","150820-003",{"$f":"IF(AND($E19=\"в ремонте\",$C19=G$3),VLOOKUP($F19,IF({1,0},$F20:$F114,$D20:$D114),2,)-$D19,\"\")","v":""},{"$f":"IF(AND($E19=\"в ремонте\",$C19=H$3),VLOOKUP($F19,IF({1,0},$F20:$F114,$D20:$D114),2,)-$D19,\"\")","v":""}]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]