{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["1","2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,10,2,11],[0,8,0,9],[2,1,2,2],[2,4,2,5],[2,6,2,7],[2,8,2,9],[3,1,3,2],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11]]}
[null,null,null,null,null,null,null,null,"2019-01-05"]
[]
[]
[null,{"$f":"E4-K4","v":172217},null,null,172217,null,134237,null,{"$f":"SUM(E4-G4-K4)","v":37980}]
[]
[]
[]
[null,-18,30]

{"sheet":"2","index":1,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[[3,4,4,4],[38,1,38,2],[39,1,39,2],[3,1,4,1],[3,2,4,2],[3,3,4,3]]}
[]
[null,null,null,null,null,null,"Январь"]
[]
[null,{"$f":"G2","v":"Январь"},-18,30,"Кол-во гостей",null,"Выручка"]
[null,null,null,null,null,null,"общий (М)"]
[]
[null,{"$f":"VLOOKUP($G$2,[1]Лист1!$B$3:$C$14,2,FALSE)","v":"2019-01-01"},{"$f":"TEXT(B7,\"дддд\")","v":"вторник"}]
[null,{"$f":"B7+1","v":"2019-01-02"},{"$f":"TEXT(B8,\"дддд\")","v":"среда"}]
[null,{"$f":"B8+1","v":"2019-01-03"},"четверг"]
[null,"2019-01-04","пятница",-18,30,null,172217]
[null,"2019-01-05","суббота"]
[null,"2019-01-06","воскресенье"]
[null,"2019-01-07","понедельник"]
[null,"2019-01-08","вторник"]
[null,"2019-01-09","среда"]
[null,"2019-01-10","четверг"]
[null,"2019-01-11","пятница"]
[null,"2019-01-12","суббота"]
[null,"2019-01-13","воскресенье"]
[null,"2019-01-14","понедельник"]
[null,"2019-01-15","вторник"]
[null,"2019-01-16","среда"]
[null,"2019-01-17","четверг"]
[null,"2019-01-18","пятница"]
[null,"2019-01-19","суббота"]
[null,"2019-01-20","воскресенье"]
[null,"2019-01-21","понедельник"]
[null,"2019-01-22","вторник"]
[null,"2019-01-23","среда"]
[null,"2019-01-24","четверг"]
[null,"2019-01-25","пятница"]
[null,"2019-01-26","суббота"]
[null,"2019-01-27","воскресенье"]
[null,"2019-01-28","понедельник"]
[null,"2019-01-29","вторник"]
[null,"2019-01-30","среда"]
[null,"2019-01-31","четверг"]
[]
[null,"ИТОГО",null,null,{"$f":"SUM(E7:E37)","v":30},null,{"$f":"SUM(G7:G37)","v":172217}]
[null,"Среднее значение",null,{"$f":"IFERROR(AVERAGE(D7:D37),0)","v":-18},30,null,172217]