{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Лист2","Лист1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":1},"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":"Лист2","index":0,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Тип номера (стандарт, люкс, студия, аппартаменты, комфорт) ","Фамилия И.О.","Номер","количество прожитых дней","Стоимость проживания в номере с учетом количества мест "]
["Аппартаменты","Петров В.Д.",5,1,8800]
[null,"Помелов И.А.",10,2,4400]
[null,"Храмова М.Н.",9,8,4400]
["Аппартаменты Итог",null,null,11,17600]
["Комфорт","Арсеиньева И.И.",44,4,15900]
[null,"Былинкина Б.Д.",56,7,15900]
[null,"Одинцов В.А.",78,4,15900]
[null,"Чичваркина Т.И.",13,7,15900]
["Комфорт Итог",null,null,22,63600]
["Люкс","Борисов К.Е.",3,2,56000]
[null,"Булатов К.П.",27,5,14000]
[null,"Платушкина В.А.",15,5,28000]
[null,"Яблочкин Е.З.",6,8,28000]
["Люкс Итог",null,null,20,126000]
["Стандарт","Казнова М.Р.",4,5,3200]
[null,"Карамзина В.Р.",32,13,3200]
[null,"Нарышкина К.А.",74,2,3200]
[null,"Ошуркова А.В.",1,3,3200]
[null,"Сабитов К.С.",22,4,3200]
[null,"Шулёв А.К.",11,2,3200]
["Стандарт Итог",null,null,29,19200]
["Студия","Ивашин К.Е.",2,3,3100]
[null,"Холопов А.Г.",55,5,3100]
["Студия Итог",null,null,8,6200]
["Общий итог",null,null,90,232600]

{"sheet":"Лист1","index":1,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Фамилия И.О.","Номер","Количество мест в номере","Тип номера (стандарт, люкс, студия, аппартаменты, комфорт) ","Стоимость проживания (1 место в номере за сутки)","Дата бронирования","Дата заезда","Дата освобождения номера"," Стоимость проживания в номере с учетом количества мест","Статус номера","Освобождается через, дней"]
["Ошуркова А.В.",1,1,"Стандарт",3200,"2020-11-10","2020-11-12","2020-11-15",{"$f":"C2*E2","v":3200},{"$f":"IF(AND(ISNUMBER(F2),ISNUMBER(G2),ISNUMBER(H2)),IF(AND(F2<=G2,G2<=H2),IF(NOW()<G2,\"забронирован\",IF(NOW()<H2,\"занят\",\"освобожден\"))))","v":"освобожден"},{"$f":"IF(0>H2-NOW(),\"\",H2-NOW())","v":""}]
["Холопов А.Г.",55,2,"Студия",1550,"2020-11-10","2020-11-15","2020-11-20",{"$f":"C3*E3","v":3100},{"$f":"IF(AND(ISNUMBER(F3),ISNUMBER(G3),ISNUMBER(H3)),IF(AND(F3<=G3,G3<=H3),IF(NOW()<G3,\"забронирован\",IF(NOW()<H3,\"занят\",\"освобожден\"))))","v":"освобожден"},{"$f":"IF(0>H3-NOW(),\"\",H3-NOW())","v":""}]
["Булатов К.П.",27,1,"Люкс",14000,"2020-11-09","2020-11-16","2020-11-21",14000,"освобожден",""]
["Чичваркина Т.И.",13,3,"Комфорт",5300,"2020-11-09","2020-11-18","2020-11-25",15900,"освобожден",""]
["Храмова М.Н.",9,2,"Аппартаменты",2200,"2020-11-09","2020-11-20","2020-11-28",4400,"занят",1.2357271990767913]
["Казнова М.Р.",4,1,"Стандарт",3200,"2020-11-09","2020-11-25","2020-11-30",3200,"занят",3.2357271990767913]
["Петров В.Д.",5,4,"Аппартаменты",2200,"2020-11-13","2020-11-29","2020-11-30",8800,"забронирован",3.2357271990767913]
["Яблочкин Е.З.",6,2,"Люкс",14000,"2020-11-08","2020-11-13","2020-11-21",28000,"освобожден",""]
["Сабитов К.С.",22,1,"Стандарт",3200,"2020-11-07","2020-11-14","2020-11-18",3200,"освобожден",""]
["Арсеиньева И.И.",44,3,"Комфорт",5300,"2020-11-13","2020-11-24","2020-11-28",15900,"занят",1.2357271990767913]
["Платушкина В.А.",15,2,"Люкс",14000,"2020-11-17","2020-11-20","2020-11-25",28000,"освобожден",""]
["Шулёв А.К.",11,1,"Стандарт",3200,"2020-11-20","2020-11-28","2020-11-30",3200,"забронирован",3.2357271990767913]
["Ивашин К.Е.",2,2,"Студия",1550,"2020-11-20","2020-11-27","2020-11-30",3100,"забронирован",3.2357271990767913]
["Борисов К.Е.",3,4,"Люкс",14000,"2020-11-20","2020-11-24","2020-11-26",56000,"освобожден",""]
["Нарышкина К.А.",74,1,"Стандарт",3200,"2020-11-05","2020-11-24","2020-11-26",3200,"освобожден",""]
["Былинкина Б.Д.",56,3,"Комфорт",5300,"2020-11-19","2020-11-22","2020-11-29",15900,"занят",2.2357271990767913]
["Карамзина В.Р.",32,1,"Стандарт",3200,"2020-11-04","2020-11-10","2020-11-23",3200,"освобожден",""]
["Помелов И.А.",10,2,"Аппартаменты",2200,"2020-11-05","2020-11-16","2020-11-18",4400,"освобожден",""]
["Одинцов В.А.",78,3,"Комфорт",5300,"2020-11-23","2020-11-25","2020-11-29",15900,"занят",2.2357271990767913]