{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Свод","Сидоров","Иванов","Петров"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Свод","index":0,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"День недели","С1","С2","С3","С4","С5"]
[null,"Понедельник",{"$f":"SUMIF($B:$B,$B5,D:D)","v":19},{"$f":"SUMIF($B:$B,$B5,E:E)","v":0},0,0,0]
[null,"Вторник",{"$f":"SUMIF($B:$B,$B6,D:D)","v":16},0,0,0,0]
[null,"Среда",{"$f":"SUMIF($B:$B,$B7,D:D)","v":13},0,0,0,0]
[null,"Четверг",{"$f":"SUMIF($B:$B,$B8,D:D)","v":23},0,0,0,0]
[null,"Пятница",{"$f":"SUMIF($B:$B,$B9,D:D)","v":22},0,0,0,0]
[]
[]
[]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(A1)/5,)+1),\"]\",REPT(\" \",30)),31))","v":"Сидоров"},{"$f":"IF(ISERR(A13),\"\",INDEX(B$5:B$9,MOD(ROW(A1)-1,5)+1))","v":"Понедельник"},null,{"$f":"VLOOKUP($B13,INDIRECT($A13&\"!A:ZZ\"),COLUMN()-2,)","v":4},{"$f":"VLOOKUP($B13,INDIRECT($A13&\"!A:ZZ\"),COLUMN()-2,)","v":0},0,0,0]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(A2)/5,)+1),\"]\",REPT(\" \",30)),31))","v":"Сидоров"},{"$f":"IF(ISERR(A14),\"\",INDEX(B$5:B$9,MOD(ROW(A2)-1,5)+1))","v":"Вторник"},null,{"$f":"VLOOKUP($B14,INDIRECT($A14&\"!A:ZZ\"),COLUMN()-2,)","v":5},0,0,0,0]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(A3)/5,)+1),\"]\",REPT(\" \",30)),31))","v":"Сидоров"},"Среда",null,2,0,0,0,0]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(B4)/5,)+1),\"]\",REPT(\" \",30)),31))","v":"Сидоров"},"Четверг",null,6,0,0,0,0]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(B5)/5,)+1),\"]\",REPT(\" \",30)),31))","v":"Сидоров"},"Пятница",null,12,0,0,0,0]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(B6)/5,)+1),\"]\",REPT(\" \",30)),31))","v":"Иванов"},"Понедельник",null,12,0,0,0,0]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(B7)/5,)+1),\"]\",REPT(\" \",30)),31))","v":"Иванов"},"Вторник",null,3,0,0,0,0]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(B8)/5,)+1),\"]\",REPT(\" \",30)),31))","v":"Иванов"},"Среда",null,7,0,0,0,0]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(B9)/5,)+1),\"]\",REPT(\" \",30)),31))","v":"Иванов"},"Четверг",null,14,0,0,0,0]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(A10)/5,)+1),\"]\",REPT(\" \",30)),31))","v":"Иванов"},"Пятница",null,4,0,0,0,0]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(A11)/5,)+1),\"]\",REPT(\" \",30)),31))","v":"Петров"},"Понедельник",null,3,0,0,0,0]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(A12)/5,)+1),\"]\",REPT(\" \",30)),31))","v":"Петров"},"Вторник",null,8,0,0,0,0]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(A13)/5,)+1),\"]\",REPT(\" \",30)),31))","v":"Петров"},"Среда",null,4,0,0,0,0]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(A14)/5,)+1),\"]\",REPT(\" \",30)),31))","v":"Петров"},"Четверг",null,3,0,0,0,0]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(A15)/5,)+1),\"]\",REPT(\" \",30)),31))","v":"Петров"},"Пятница",null,6,0,0,0,0]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(A16)/5,)+1),\"]\",REPT(\" \",30)),31))","v":{"$error":"#REF!"}},"",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(A17)/5,)+1),\"]\",REPT(\" \",30)),31))","v":{"$error":"#REF!"}},"",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(A18)/5,)+1),\"]\",REPT(\" \",30)),31))","v":{"$error":"#REF!"}},"",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(A19)/5,)+1),\"]\",REPT(\" \",30)),31))","v":{"$error":"#REF!"}},"",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(A20)/5,)+1),\"]\",REPT(\" \",30)),31))","v":{"$error":"#REF!"}},"",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(A21)/5,)+1),\"]\",REPT(\" \",30)),31))","v":{"$error":"#REF!"}},"",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(A22)/5,)+1),\"]\",REPT(\" \",30)),31))","v":{"$error":"#REF!"}},"",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(A23)/5,)+1),\"]\",REPT(\" \",30)),31))","v":{"$error":"#REF!"}},"",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(A24)/5,)+1),\"]\",REPT(\" \",30)),31))","v":{"$error":"#REF!"}},"",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(A25)/5,)+1),\"]\",REPT(\" \",30)),31))","v":{"$error":"#REF!"}},"",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$f":"TRIM(RIGHTB(SUBSTITUTE(INDEX(ю,ROUNDUP(ROW(A26)/5,)+1),\"]\",REPT(\" \",30)),31))","v":{"$error":"#REF!"}},"",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"Сидоров","index":1,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
["День недели","С1","С2","С3","С4","С5"]
["Понедельник",{"$f":"SUM(B4:B7)","v":4},{"$f":"SUM(C4:C7)","v":0},0,0,0]
["адрес01",1]
["адрес02",1]
["адрес03",1]
["адрес04",1]
["Вторник",{"$f":"SUM(B9:B14)","v":5},{"$f":"SUM(C9:C14)","v":0},0,0,0]
["адрес01",1]
["адрес02",1]
["адрес03",1]
["адрес04"]
["адрес05",1]
["адрес06",1]
["Среда",{"$f":"SUM(B16:B18)","v":2},{"$f":"SUM(C16:C18)","v":0},0,0,0]
["адрес01",1]
["адрес02"]
["адрес03",1]
["Четверг",{"$f":"SUM(B20:B26)","v":6},{"$f":"SUM(C20:C26)","v":0},0,0,0]
["адрес01",1]
["адрес02",1]
["адрес03",1]
["адрес04",1]
["адрес05",1]
["адрес06"]
["адрес07",1]
["Пятница",{"$f":"SUM(B28:B43)","v":12},{"$f":"SUM(C28:C43)","v":0},0,0,0]
["адрес01",1]
["адрес02",1]
["адрес03",1]
["адрес04",1]
["адрес05"]
["адрес06"]
["адрес07",1]
["адрес08",1]
["адрес09",1]
["адрес10"]
["адрес11",1]
["адрес12",1]
["адрес13",1]
["адрес14"]
["адрес15",1]
["адрес16",1]

{"sheet":"Иванов","index":2,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
["День недели","С1","С2","С3","С4","С5"]
["Понедельник",{"$f":"SUM(B4:B15)","v":12},{"$f":"SUM(C4:C15)","v":0},0,0,0]
["адрес01",1]
["адрес02",1]
["адрес03",1]
["адрес04",1]
["адрес05",1]
["адрес06",1]
["адрес07",1]
["адрес08",1]
["адрес09",1]
["адрес10",1]
["адрес11",1]
["адрес12",1]
["Вторник",{"$f":"SUM(B17:B19)","v":3},{"$f":"SUM(C17:C19)","v":0},{"$f":"SUM(D17:D19)","v":0},{"$f":"SUM(E17:E19)","v":0},{"$f":"SUM(F17:F19)","v":0}]
["адрес01",1]
["адрес02",1]
["адрес03",1]
["Среда",{"$f":"SUM(B21:B27)","v":7},{"$f":"SUM(C21:C27)","v":0},0,0,0]
["адрес01",1]
["адрес02",1]
["адрес03",1]
["адрес04",1]
["адрес05",1]
["адрес06",1]
["адрес07",1]
["Четверг",{"$f":"SUM(B29:B43)","v":14},{"$f":"SUM(C29:C43)","v":0},0,0,0]
["адрес01",1]
["адрес02",1]
["адрес03",1]
["адрес04",1]
["адрес05",1]
["адрес06",1]
["адрес07",1]
["адрес08",1]
["адрес09",1]
["адрес10",1]
["адрес11",1]
["адрес12",1]
["адрес13",1]
["адрес14"]
["адрес15",1]
["Пятница",{"$f":"SUM(B45:B48)","v":4},{"$f":"SUM(C45:C48)","v":0},{"$f":"SUM(D45:D48)","v":0},{"$f":"SUM(E45:E48)","v":0},{"$f":"SUM(F45:F48)","v":0}]
["адрес01",1]
["адрес02",1]
["адрес03",1]
["адрес04",1]

{"sheet":"Петров","index":3,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
["День недели","С1","С2","С3","С4","С5"]
["Понедельник",{"$f":"SUM(B4:B6)","v":3},{"$f":"SUM(C4:C6)","v":0},{"$f":"SUM(D4:D6)","v":0},{"$f":"SUM(E4:E6)","v":0},{"$f":"SUM(F4:F6)","v":0}]
["адрес01",1]
["адрес02",1]
["адрес03",1]
["Вторник",{"$f":"SUM(B8:B15)","v":8},{"$f":"SUM(C8:C15)","v":0},0,0,0]
["адрес01",1]
["адрес02",1]
["адрес03",1]
["адрес04",1]
["адрес05",1]
["адрес06",1]
["адрес07",1]
["адрес08",1]
["Среда",{"$f":"SUM(B17:B21)","v":4},{"$f":"SUM(C17:C21)","v":0},0,0,0]
["адрес01",1]
["адрес02",1]
["адрес03",1]
["адрес04"]
["адрес05",1]
["Четверг",{"$f":"SUM(B23:B26)","v":3},{"$f":"SUM(C23:C26)","v":0},{"$f":"SUM(D23:D26)","v":0},{"$f":"SUM(E23:E26)","v":0},{"$f":"SUM(F23:F26)","v":0}]
["адрес01",1]
["адрес02",1]
["адрес03"]
["адрес04",1]
["Пятница",{"$f":"SUM(B28:B35)","v":6},{"$f":"SUM(C28:C35)","v":0},{"$f":"SUM(D28:D35)","v":0},{"$f":"SUM(E28:E35)","v":0},{"$f":"SUM(F28:F35)","v":0}]
["адрес01",1]
["адрес02",1]
["адрес03",1]
["адрес04",1]
["адрес05"]
["адрес06"]
["адрес07",1]
["адрес08",1]