{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Неделя 29 (3)","Неделя 29 (2)","Неделя 29"],"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":"Неделя 29 (3)","index":0,"n_rows":13,"n_cols":18,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,4,0,9],[1,4,1,9]]}
[null,null,null,null,"2022-07-11"]
[null,null,null,null,"Понедельник"]
["Номер","Столбец1","Имя","Столбец2","СТ","СТ3","СТ4","СТ5","СТ6","ПР",null,null,null,null,null,"Имя","Час","Код"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Иван Петров",6,3572]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Иван Петров",2,3495]
[null,null,null,null,3572,3495,1,null,null,3572,null,null,null,null,null,"Иван Петров",null,1]
["757","C","Иван Петров",null,6,2,null,null,null,3,null,null,null,null,null,"Иван Петров",3,3572]
[null,null,null,null,3572,null,null,null,null,3572,null,null,null,null,null,"Петр Иванов",8,3572]
["758","C","Петр Иванов",null,8,null,null,null,null,3,null,null,null,null,null,"Петр Иванов",3,3572]
[null,null,null,null,3495,3569,null,null,null,3569,null,null,null,null,null,"Гриша Иванов",6,3495]
["511","C","Гриша Иванов",null,6,2,null,null,null,2,null,null,null,null,null,"Гриша Иванов",2,3569]
[null,null,null,null,3485,null,null,null,null,null,null,null,null,null,null,"Гриша Иванов",2,3569]
["742","C","Иван Игришин",null,8,null,null,null,null,null,null,null,null,null,null,"Иван Игришин",8,3485]

{"sheet":"Неделя 29 (2)","index":1,"n_rows":225,"n_cols":24,"rows_kept":225,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,4,0,9],[1,4,1,9]]}
[null,null,null,null,"2022-07-11"]
[null,null,null,null,"Понедельник"]
["Номер",null,"Имя",null,"СТ","СТ","СТ","СТ","СТ","ПР"]
[null,null,null,null,3572,3495,null,null,null,3572,null,null,null,null,null,null,null,"Должно получится",null,null,null,"Должно получится"]
["757","C","Иван Петров",null,6,2,null,null,null,3,null,null,null,null,null,null,null,"Имя","Часы","Код",null,"Имя","Часы","Код"]
[null,null,null,null,3572,null,null,null,null,3572,null,null,null,null,null,null,null,"Иван Петров",6,"3572",null,{"$f":"IF((ROW()-MATCH(V5,V$1:V5,))<COUNT(INDEX(E:J,MATCH(V5,C:C,),)),V5,INDEX(C:C,MATCH(V5,C:C,)+2))","v":"Иван Петров"},{"$f":"INDEX(A:J,MATCH(V6,C:C,),SMALL(IF(INDEX(E:J,MATCH(V6,C:C,),)<>\"\",COLUMN(E1:J1)),ROW()-MATCH(V6,V$1:V6,)+1))","v":6},{"$f":"INDEX(A:J,MATCH(V6,C:C,)-1,SMALL(IF(INDEX(E:J,MATCH(V6,C:C,)-1,)<>\"\",COLUMN(E1:J1)),ROW()-MATCH(V6,V$1:V6,)+1))","v":3572}]
["758","C","Петр Иванов",null,8,null,null,null,null,3,null,null,null,null,null,null,null,"Иван Петров",2,"3495",null,{"$f":"IF((ROW()-MATCH(V6,V$1:V6,))<COUNT(INDEX(E:J,MATCH(V6,C:C,),)),V6,INDEX(C:C,MATCH(V6,C:C,)+2))","v":"Иван Петров"},{"$f":"INDEX(A:J,MATCH(V7,C:C,),SMALL(IF(INDEX(E:J,MATCH(V7,C:C,),)<>\"\",COLUMN(E2:J2)),ROW()-MATCH(V7,V$1:V7,)+1))","v":2},{"$f":"INDEX(A:J,MATCH(V7,C:C,)-1,SMALL(IF(INDEX(E:J,MATCH(V7,C:C,)-1,)<>\"\",COLUMN(E2:J2)),ROW()-MATCH(V7,V$1:V7,)+1))","v":3495}]
[null,null,null,null,3495,3569,null,null,null,3569,null,null,null,null,null,null,null,"Иван Петров",3,"3572",null,{"$f":"IF((ROW()-MATCH(V7,V$1:V7,))<COUNT(INDEX(E:J,MATCH(V7,C:C,),)),V7,INDEX(C:C,MATCH(V7,C:C,)+2))","v":"Иван Петров"},{"$f":"INDEX(A:J,MATCH(V8,C:C,),SMALL(IF(INDEX(E:J,MATCH(V8,C:C,),)<>\"\",COLUMN(E3:J3)),ROW()-MATCH(V8,V$1:V8,)+1))","v":3},{"$f":"INDEX(A:J,MATCH(V8,C:C,)-1,SMALL(IF(INDEX(E:J,MATCH(V8,C:C,)-1,)<>\"\",COLUMN(E3:J3)),ROW()-MATCH(V8,V$1:V8,)+1))","v":3572}]
["511","C","Гриша Иванов",null,6,2,null,null,null,2,null,null,null,null,null,null,null,"Петр Иванов",8,"3572",null,{"$f":"IF((ROW()-MATCH(V8,V$1:V8,))<COUNT(INDEX(E:J,MATCH(V8,C:C,),)),V8,INDEX(C:C,MATCH(V8,C:C,)+2))","v":"Петр Иванов"},{"$f":"INDEX(A:J,MATCH(V9,C:C,),SMALL(IF(INDEX(E:J,MATCH(V9,C:C,),)<>\"\",COLUMN(E4:J4)),ROW()-MATCH(V9,V$1:V9,)+1))","v":8},{"$f":"INDEX(A:J,MATCH(V9,C:C,)-1,SMALL(IF(INDEX(E:J,MATCH(V9,C:C,)-1,)<>\"\",COLUMN(E4:J4)),ROW()-MATCH(V9,V$1:V9,)+1))","v":3572}]
[null,null,null,null,3485,null,null,null,null,null,null,null,null,null,null,null,null,"Гриша Иванов",6,"3495",null,{"$f":"IF((ROW()-MATCH(V9,V$1:V9,))<COUNT(INDEX(E:J,MATCH(V9,C:C,),)),V9,INDEX(C:C,MATCH(V9,C:C,)+2))","v":"Петр Иванов"},{"$f":"INDEX(A:J,MATCH(V10,C:C,),SMALL(IF(INDEX(E:J,MATCH(V10,C:C,),)<>\"\",COLUMN(E5:J5)),ROW()-MATCH(V10,V$1:V10,)+1))","v":3},{"$f":"INDEX(A:J,MATCH(V10,C:C,)-1,SMALL(IF(INDEX(E:J,MATCH(V10,C:C,)-1,)<>\"\",COLUMN(E5:J5)),ROW()-MATCH(V10,V$1:V10,)+1))","v":3572}]
["742","C","Иван Игришин",null,8,null,null,null,null,null,null,null,null,null,null,null,null,"Гриша Иванов",2,"3569",null,{"$f":"IF((ROW()-MATCH(V10,V$1:V10,))<COUNT(INDEX(E:J,MATCH(V10,C:C,),)),V10,INDEX(C:C,MATCH(V10,C:C,)+2))","v":"Гриша Иванов"},{"$f":"INDEX(A:J,MATCH(V11,C:C,),SMALL(IF(INDEX(E:J,MATCH(V11,C:C,),)<>\"\",COLUMN(E6:J6)),ROW()-MATCH(V11,V$1:V11,)+1))","v":6},{"$f":"INDEX(A:J,MATCH(V11,C:C,)-1,SMALL(IF(INDEX(E:J,MATCH(V11,C:C,)-1,)<>\"\",COLUMN(E6:J6)),ROW()-MATCH(V11,V$1:V11,)+1))","v":3495}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Гриша Иванов",2,"3569",null,{"$f":"IF((ROW()-MATCH(V11,V$1:V11,))<COUNT(INDEX(E:J,MATCH(V11,C:C,),)),V11,INDEX(C:C,MATCH(V11,C:C,)+2))","v":"Гриша Иванов"},{"$f":"INDEX(A:J,MATCH(V12,C:C,),SMALL(IF(INDEX(E:J,MATCH(V12,C:C,),)<>\"\",COLUMN(E7:J7)),ROW()-MATCH(V12,V$1:V12,)+1))","v":2},{"$f":"INDEX(A:J,MATCH(V12,C:C,)-1,SMALL(IF(INDEX(E:J,MATCH(V12,C:C,)-1,)<>\"\",COLUMN(E7:J7)),ROW()-MATCH(V12,V$1:V12,)+1))","v":3569}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Иван Игришин",8,"3485",null,{"$f":"IF((ROW()-MATCH(V12,V$1:V12,))<COUNT(INDEX(E:J,MATCH(V12,C:C,),)),V12,INDEX(C:C,MATCH(V12,C:C,)+2))","v":"Гриша Иванов"},{"$f":"INDEX(A:J,MATCH(V13,C:C,),SMALL(IF(INDEX(E:J,MATCH(V13,C:C,),)<>\"\",COLUMN(E8:J8)),ROW()-MATCH(V13,V$1:V13,)+1))","v":2},{"$f":"INDEX(A:J,MATCH(V13,C:C,)-1,SMALL(IF(INDEX(E:J,MATCH(V13,C:C,)-1,)<>\"\",COLUMN(E8:J8)),ROW()-MATCH(V13,V$1:V13,)+1))","v":3569}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((ROW()-MATCH(V13,V$1:V13,))<COUNT(INDEX(E:J,MATCH(V13,C:C,),)),V13,INDEX(C:C,MATCH(V13,C:C,)+2))","v":"Иван Игришин"},{"$f":"INDEX(A:J,MATCH(V14,C:C,),SMALL(IF(INDEX(E:J,MATCH(V14,C:C,),)<>\"\",COLUMN(E9:J9)),ROW()-MATCH(V14,V$1:V14,)+1))","v":8},{"$f":"INDEX(A:J,MATCH(V14,C:C,)-1,SMALL(IF(INDEX(E:J,MATCH(V14,C:C,)-1,)<>\"\",COLUMN(E9:J9)),ROW()-MATCH(V14,V$1:V14,)+1))","v":3485}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((ROW()-MATCH(V14,V$1:V14,))<COUNT(INDEX(E:J,MATCH(V14,C:C,),)),V14,INDEX(C:C,MATCH(V14,C:C,)+2))","v":0},{"$f":"INDEX(A:J,MATCH(V15,C:C,),SMALL(IF(INDEX(E:J,MATCH(V15,C:C,),)<>\"\",COLUMN(E10:J10)),ROW()-MATCH(V15,V$1:V15,)+1))","v":{"$error":"#N/A"}},{"$f":"INDEX(A:J,MATCH(V15,C:C,)-1,SMALL(IF(INDEX(E:J,MATCH(V15,C:C,)-1,)<>\"\",COLUMN(E10:J10)),ROW()-MATCH(V15,V$1:V15,)+1))","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"."]

{"sheet":"Неделя 29","index":2,"n_rows":14,"n_cols":24,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,4,0,9],[1,4,1,9]]}
[null,null,null,null,"2022-07-11"]
[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,3572,3495,null,null,null,3572,null,null,"Иван Петров",6,3572,null,{"$f":"_xlfn.FILTERXML(\"<t><s>\"&SUBSTITUTE(_xlfn.TEXTJOIN(\";\",1,SUBSTITUTE(IF(E6:J13<>\"\",C6:C13,\"\"),0,\"\")),\";\",\"</s><s>\")&\"</s></t>\",\"//s\")","v":"Иван Петров"},{"$f":"_xlfn.FILTERXML(\"<t><s>\"&SUBSTITUTE(_xlfn.TEXTJOIN(\";\",1,SUBSTITUTE(MOD(ROW(E6:J13),2)*E6:J13,0,\"\")),\";\",\"</s><s>\")&\"</s></t>\",\"//s\")","v":6},{"$f":"_xlfn.FILTERXML(\"<t><s>\"&SUBSTITUTE(_xlfn.TEXTJOIN(\";\",1,SUBSTITUTE((-MOD(ROW(E6:J13),2)+1)*E6:J13,0,\"\")),\";\",\"</s><s>\")&\"</s></t>\",\"//s\")","v":3572},null,null,"Иван Петров",6,"3572"]
["757","C","Иван Петров",null,6,2,null,null,null,3,null,null,"Иван Петров",2,3495,null,"Иван Петров",2,3495,null,null,"Иван Петров",2,"3495"]
[null,null,null,null,3572,null,null,null,null,3572,null,null,"Иван Петров",3,3572,null,"Иван Петров",3,3572,null,null,"Иван Петров",3,"3572"]
["758","C","Петр Иванов",null,8,null,null,null,null,3,null,null,"Петр Иванов",8,3572,null,"Петр Иванов",8,3572,null,null,"Петр Иванов",8,"3572"]
[null,null,null,null,3495,3569,null,null,null,3569,null,null,"Петр Иванов",3,3572,null,"Петр Иванов",3,3572,null,null,"Гриша Иванов",6,"3495"]
["511","C","Гриша Иванов",null,6,2,null,null,null,2,null,null,"Гриша Иванов",6,3495,null,"Гриша Иванов",6,3495,null,null,"Гриша Иванов",2,"3569"]
[null,null,null,null,3485,null,null,null,null,null,null,null,"Гриша Иванов",2,3569,null,"Гриша Иванов",2,3569,null,null,"Гриша Иванов",2,"3569"]
["742","C","Иван Игришин",null,8,null,null,null,null,null,null,null,"Гриша Иванов",2,3569,null,"Гриша Иванов",2,3569,null,null,"Иван Игришин",8,"3485"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Иван Игришин",8,3485,null,"Иван Игришин",8,3485]