{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Лист4"],"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":"Лист4","index":0,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Фамилия И.О.","Номер","Количество мест в номере","Тип номера (стандарт, люкс, студия, аппартаменты, комфорт) ","Стоимость проживания (1 место в номере за сутки)","Дата бронирования","Дата заезда","Дата освобождения номера"," Стоимость проживания в номере с учетом количества мест","Статус номера"]
["Ошуркова А.В.",1,1,"Стандарт",3200,"2020-11-10","2020-11-12","2020-12-10",{"$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":"освобожден"}]
["Холопов А.Г.",55,2,"Студия",1550,"2020-11-10","2020-11-15","2020-12-15",{"$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":"занят"}]
["Булатов К.П.",27,1,"Люкс",14000,"2020-11-09","2020-11-16","2020-12-16",14000,"занят"]
["Чичваркина Т.И.",13,3,"Комфорт",5300,"2020-11-09","2020-11-18","2020-12-20",15900,"занят"]
["Храмова М.Н.",9,2,"Аппартаменты",2200,"2020-11-09","2020-11-20","2020-12-23",4400,"занят"]
["Казнова М.Р.",4,1,"Стандарт",3200,"2020-11-09","2020-11-25","2020-12-25",3200,"занят"]
["Петров В.Д.",5,4,"Аппартаменты",2200,"2020-11-13","2020-11-29","2020-12-25",8800,"занят"]
["Яблочкин Е.З.",6,2,"Люкс",14000,"2020-11-08","2020-11-13","2020-12-16",28000,"занят"]
["Сабитов К.С.",22,1,"Стандарт",3200,"2020-11-07","2020-11-14","2020-12-13",3200,"освобожден"]
["Арсеиньева И.И.",44,3,"Комфорт",5300,"2020-11-13","2020-11-24","2020-12-23",15900,"занят"]
["Платушкина В.А.",15,2,"Люкс",14000,"2020-11-17","2020-11-20","2020-12-20",28000,"занят"]
["Шулёв А.К.",11,1,"Стандарт",3200,"2020-11-20","2020-11-28","2020-12-15",3200,"занят"]
["Ивашин К.Е.",2,2,"Студия",1550,"2020-11-20","2020-11-27","2020-12-25",3100,"занят"]
["Борисов К.Е.",3,4,"Люкс",14000,"2020-11-20","2020-11-24","2020-12-21",56000,"занят"]
["Нарышкина К.А.",74,1,"Стандарт",3200,"2020-11-05","2020-11-24","2020-12-16",3200,"занят"]
["Былинкина Б.Д.",56,3,"Комфорт",5300,"2020-11-19","2020-11-22","2020-12-24",15900,"занят"]
["Карамзина В.Р.",32,1,"Стандарт",3200,"2020-11-04","2020-11-10","2020-12-18",3200,"занят"]
["Помелов И.А.",10,2,"Аппартаменты",2200,"2020-11-05","2020-11-16","2020-12-15",4400,"занят"]
["Одинцов В.А.",78,3,"Комфорт",5300,"2020-11-23","2020-11-25","2020-12-24",15900,"занят"]