{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Лист1","Лист2","Лист4","Лист3"],"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":26,"n_cols":17,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["время","клиент 1","клиент 2","клиент 3","клиент 4","клиент 5","клиент 6","клиент 7","клиент 8","клиент 9","клиент 10","клиент 11","клиент 12","клиент 13","клиент 14","план"]
["00:00:00",null,{"$f":"IF(P2<=240,TRUE,FALSE)","v":true},{"$f":"IF(P2<=240,TRUE,FALSE)","v":true},{"$f":"IF(P2<=240,TRUE,FALSE)","v":true},{"$f":"IF(P2<=240,TRUE,FALSE)","v":true},{"$f":"IF(P2<=240,TRUE,FALSE)","v":true},{"$f":"IF(P2<=240,TRUE,FALSE)","v":true},{"$f":"IF(P2<=240,TRUE,FALSE)","v":true},{"$f":"IF(P2<=240,TRUE,FALSE)","v":true},{"$f":"IF(P2<=240,TRUE,FALSE)","v":true},{"$f":"IF(P2<=240,TRUE,FALSE)","v":true},{"$f":"IF(P2<=240,TRUE,FALSE)","v":true},{"$f":"IF(P2<=240,TRUE,FALSE)","v":true},{"$f":"IF(P2<=240,TRUE,FALSE)","v":true},{"$f":"SUM(B2:O2)","v":0},{"$f":"P2<=240","v":true}]
["01:00:00",null,{"$f":"IF(P3<=240,TRUE,FALSE)","v":true},{"$f":"IF(P3<=240,TRUE,FALSE)","v":true},{"$f":"IF(P3<=240,TRUE,FALSE)","v":true},{"$f":"IF(P3<=240,TRUE,FALSE)","v":true},{"$f":"IF(P3<=240,TRUE,FALSE)","v":true},{"$f":"IF(P3<=240,TRUE,FALSE)","v":true},{"$f":"IF(P3<=240,TRUE,FALSE)","v":true},{"$f":"IF(P3<=240,TRUE,FALSE)","v":true},{"$f":"IF(P3<=240,TRUE,FALSE)","v":true},{"$f":"IF(P3<=240,TRUE,FALSE)","v":true},{"$f":"IF(P3<=240,TRUE,FALSE)","v":true},{"$f":"IF(P3<=240,TRUE,FALSE)","v":true},{"$f":"IF(P3<=240,TRUE,FALSE)","v":true},{"$f":"SUM(B3:O3)","v":0},{"$f":"P3<=240","v":true}]
["02:00:00",null,true,true,true,true,true,true,true,true,true,true,true,true,true,0,true]
["03:00:00",null,true,true,true,true,true,true,true,true,true,true,true,true,true,0,true]
["04:00:00",null,true,true,true,true,true,true,true,true,true,true,true,true,true,0,true]
["05:00:00",null,true,true,true,true,true,true,true,true,true,true,true,true,true,0,true]
["06:00:00",null,true,true,true,true,true,true,true,true,true,true,true,true,true,0,true]
["07:00:00",null,true,true,true,true,true,true,true,true,true,true,true,true,true,0,true]
["08:00:00",null,true,true,true,true,true,true,true,true,true,true,true,true,true,0,true]
["09:00:00",null,true,true,true,true,true,true,true,true,true,true,true,true,true,0,true]
["10:00:00",null,true,true,true,true,true,true,true,true,true,true,true,true,true,0,true]
["11:00:00",null,true,true,true,true,true,true,true,true,true,true,true,true,true,0,true]
["12:00:00",null,true,true,true,true,true,true,true,true,true,true,true,true,true,0,true]
["13:00:00",null,true,true,true,true,true,true,true,true,true,true,true,true,true,0,true]
["14:00:00",null,true,true,true,true,true,true,true,true,true,true,true,true,true,0,true]
["15:00:00",null,true,true,true,true,true,true,true,true,true,true,true,true,true,0,true]
["16:00:00",null,true,true,true,true,true,true,true,true,true,true,true,true,true,0,true]
["17:00:00",null,true,true,true,true,true,true,true,true,true,true,true,true,true,0,true]
["18:00:00",null,true,true,true,true,true,true,true,true,true,true,true,true,true,0,true]
["19:00:00",null,true,true,true,true,true,true,true,true,true,true,true,true,true,0,true]
["20:00:00",null,true,true,true,true,true,true,true,true,true,true,true,true,true,0,true]
["21:00:00",null,true,true,true,true,true,true,true,true,true,true,true,true,true,0,true]
["22:00:00",null,true,true,true,true,true,true,true,true,true,true,true,true,true,0,true]
["23:00:00",null,true,true,true,true,true,true,true,true,true,true,true,true,true,0,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"итог",{"$f":"P25+P24+P23+P22+P21+P20+P19+P18+P17+P16+P15+P14+P13+P12+P11+P10+P9+P8+P7+P6+P5+P4+P3+P2","v":0}]

{"sheet":"Лист2","index":1,"n_rows":99,"n_cols":30,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
[240,{"$f":"Лист1!Q2","v":true},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,240,240,240,240,240,240,240,240]
[240,{"$f":"Лист1!Q3","v":true}]
[240,{"$f":"Лист1!Q4","v":true}]
[240,{"$f":"Лист1!Q5","v":true}]
[240,{"$f":"Лист1!Q6","v":true}]
[240,{"$f":"Лист1!Q7","v":true}]
[240,{"$f":"Лист1!Q8","v":true}]
[240,{"$f":"Лист1!Q9","v":true}]
[240,{"$f":"Лист1!Q10","v":true}]
[240,{"$f":"Лист1!Q11","v":true}]
[240,{"$f":"Лист1!Q12","v":true}]
[240,{"$f":"Лист1!Q13","v":true}]
[240,{"$f":"Лист1!Q14","v":true}]
[240,{"$f":"Лист1!Q15","v":true}]
[240,{"$f":"Лист1!Q16","v":true}]
[240,{"$f":"Лист1!Q17","v":true}]
[240,{"$f":"Лист1!Q18","v":true}]
[240,{"$f":"Лист1!Q19","v":true}]
[240,{"$f":"Лист1!Q20","v":true}]
[240,{"$f":"Лист1!Q21","v":true}]
[240,{"$f":"Лист1!Q22","v":true}]
[240,{"$f":"Лист1!Q23","v":true}]
[240,{"$f":"Лист1!Q24","v":true}]
[240,{"$f":"Лист1!Q25","v":true}]
[240,{"$f":"Лист1!Q26","v":0}]
[240,{"$f":"Лист1!Q27","v":0}]
[240,{"$f":"Лист1!Q28","v":0}]
[240,{"$f":"Лист1!Q29","v":0}]
[240,{"$f":"Лист1!Q30","v":0}]
[240,{"$f":"Лист1!Q31","v":0}]
[240,{"$f":"Лист1!Q32","v":0}]
[240,{"$f":"Лист1!Q33","v":0}]
[240,{"$f":"Лист1!Q34","v":0}]
[240,{"$f":"Лист1!Q35","v":0}]
[240,{"$f":"Лист1!Q36","v":0}]
[240,{"$f":"Лист1!Q37","v":0}]
[240,{"$f":"Лист1!Q38","v":0}]
[240,{"$f":"Лист1!Q39","v":0}]
[240,{"$f":"Лист1!Q40","v":0}]
[240,{"$f":"Лист1!Q41","v":0}]
[240,{"$f":"Лист1!Q42","v":0}]
[240,{"$f":"Лист1!Q43","v":0}]
[240,{"$f":"Лист1!Q44","v":0}]
[240,{"$f":"Лист1!Q45","v":0}]
[240,{"$f":"Лист1!Q46","v":0}]
[240,{"$f":"Лист1!Q47","v":0}]
[240,{"$f":"Лист1!Q48","v":0}]
[240,{"$f":"Лист1!Q49","v":0}]
[240,{"$f":"Лист1!Q50","v":0}]
[240,{"$f":"Лист1!Q51","v":0}]
[240,{"$f":"Лист1!Q52","v":0}]
[240,{"$f":"Лист1!Q53","v":0}]
[240,{"$f":"Лист1!Q54","v":0}]
[240,{"$f":"Лист1!Q55","v":0}]
[240,{"$f":"Лист1!Q56","v":0}]
[240,{"$f":"Лист1!Q57","v":0}]
[240,{"$f":"Лист1!Q58","v":0}]
[240,{"$f":"Лист1!Q59","v":0}]
[240,{"$f":"Лист1!Q60","v":0}]
[240,{"$f":"Лист1!Q61","v":0}]
[240,{"$f":"Лист1!Q62","v":0}]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]
[240]

{"sheet":"Лист4","index":2,"n_rows":26,"n_cols":17,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["время","клиент 1","клиент 2","клиент 3","клиент 4","клиент 5","клиент 6","клиент 7","клиент 8","клиент 9","клиент 10","клиент 11","клиент 12","клиент 13","клиент 14","количество"]
["00:00:00",{"$f":"IF(Лист1!B2<30,30,Лист1!B2)","v":30},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I2+H2+G2+F2+E2+D2+C2+B2","v":30},{"$f":"IF(P2<=Лист2!A1,TRUE,FALSE)","v":true}]
["01:00:00",{"$f":"IF(Лист1!B2-Лист4!B2<30,30,Лист1!B2-Лист4!B2)","v":30},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I3+H3+G3+F3+E3+D3+C3+B3","v":30},{"$f":"IF(P3<=Лист2!A2,TRUE,FALSE)","v":true}]
["02:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P4<=Лист2!A3,TRUE,FALSE)","v":true}]
["03:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P5<=Лист2!A4,TRUE,FALSE)","v":true}]
["04:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P6<=Лист2!A5,TRUE,FALSE)","v":true}]
["05:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P7<=Лист2!A6,TRUE,FALSE)","v":true}]
["06:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P8<=Лист2!A7,TRUE,FALSE)","v":true}]
["07:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P9<=Лист2!A8,TRUE,FALSE)","v":true}]
["08:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P10<=Лист2!A9,TRUE,FALSE)","v":true}]
["09:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P11<=Лист2!A10,TRUE,FALSE)","v":true}]
["10:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P12<=Лист2!A11,TRUE,FALSE)","v":true}]
["11:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P13<=Лист2!A12,TRUE,FALSE)","v":true}]
["12:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P14<=Лист2!A13,TRUE,FALSE)","v":true}]
["13:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P15<=Лист2!A14,TRUE,FALSE)","v":true}]
["14:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P16<=Лист2!A15,TRUE,FALSE)","v":true}]
["15:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P17<=Лист2!A16,TRUE,FALSE)","v":true}]
["16:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P18<=Лист2!A17,TRUE,FALSE)","v":true}]
["17:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P19<=Лист2!A18,TRUE,FALSE)","v":true}]
["18:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P20<=Лист2!A19,TRUE,FALSE)","v":true}]
["19:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P21<=Лист2!A20,TRUE,FALSE)","v":true}]
["20:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P22<=Лист2!A21,TRUE,FALSE)","v":true}]
["21:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P23<=Лист2!A22,TRUE,FALSE)","v":true}]
["22:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P24<=Лист2!A23,TRUE,FALSE)","v":true}]
["23:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P25<=Лист2!A24,TRUE,FALSE)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P25+P24+P23+P22+P21+P20+P19+P18+P17+P16+P15+P14+P13+P12+P11+P10+P9+P8+P7+P6+P5+P4+P3+P2","v":60}]

{"sheet":"Лист3","index":3,"n_rows":26,"n_cols":17,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["время","клиент 1","клиент 2","клиент 3","клиент 4","клиент 5","клиент 6","клиент 7","клиент 8","клиент 9","клиент 10","клиент 11","клиент 12","клиент 13","клиент 14","количество"]
["00:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I2+H2+G2+F2+E2+D2+C2+B2","v":0},{"$f":"IF(P2<=Лист2!A1,TRUE,FALSE)","v":true}]
["01:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I3+H3+G3+F3+E3+D3+C3+B3","v":0},{"$f":"IF(P3<=Лист2!A2,TRUE,FALSE)","v":true}]
["02:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P4<=Лист2!A3,TRUE,FALSE)","v":true}]
["03:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P5<=Лист2!A4,TRUE,FALSE)","v":true}]
["04:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P6<=Лист2!A5,TRUE,FALSE)","v":true}]
["05:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P7<=Лист2!A6,TRUE,FALSE)","v":true}]
["06:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P8<=Лист2!A7,TRUE,FALSE)","v":true}]
["07:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P9<=Лист2!A8,TRUE,FALSE)","v":true}]
["08:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P10<=Лист2!A9,TRUE,FALSE)","v":true}]
["09:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P11<=Лист2!A10,TRUE,FALSE)","v":true}]
["10:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P12<=Лист2!A11,TRUE,FALSE)","v":true}]
["11:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P13<=Лист2!A12,TRUE,FALSE)","v":true}]
["12:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P14<=Лист2!A13,TRUE,FALSE)","v":true}]
["13:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P15<=Лист2!A14,TRUE,FALSE)","v":true}]
["14:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P16<=Лист2!A15,TRUE,FALSE)","v":true}]
["15:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P17<=Лист2!A16,TRUE,FALSE)","v":true}]
["16:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P18<=Лист2!A17,TRUE,FALSE)","v":true}]
["17:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P19<=Лист2!A18,TRUE,FALSE)","v":true}]
["18:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P20<=Лист2!A19,TRUE,FALSE)","v":true}]
["19:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P21<=Лист2!A20,TRUE,FALSE)","v":true}]
["20:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P22<=Лист2!A21,TRUE,FALSE)","v":true}]
["21:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P23<=Лист2!A22,TRUE,FALSE)","v":true}]
["22:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P24<=Лист2!A23,TRUE,FALSE)","v":true}]
["23:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(P25<=Лист2!A24,TRUE,FALSE)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P25+P24+P23+P22+P21+P20+P19+P18+P17+P16+P15+P14+P13+P12+P11+P10+P9+P8+P7+P6+P5+P4+P3+P2","v":0}]