{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Лист1","Лист2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["текущая  дата",null,null,null,null,null,null,null,null,"2020-11-20"]
["Фамилия И.О.","Номер","Количество мест в номере","Тип номера (стандарт, люкс, студия, аппартаменты, комфорт) ","Стоимость проживания (1 место в номере за сутки)","Дата бронирования","Дата заезда","Дата освобождения номера"," Стоимость проживания в номере с учетом количества мест","Текущая дата","Забронирован, не занят на текущую дату"]
["Ошуркова А.В.",1,1,"Стандарт",3200,"2020-11-10","2020-11-12","2020-11-15",{"$f":"C3*E3","v":3200},{"$f":"TODAY()","v":"2020-11-20"},{"$f":"IF(AND(J3=current_date,J3-H3>0),\"+\",\"\")","v":"+"}]
["Холопов А.Г.",55,2,"Студия",1550,"2020-11-10","2020-11-15","2020-11-20",{"$f":"C4*E4","v":3100},{"$f":"TODAY()","v":"2020-11-20"},{"$f":"IF(AND(J4=current_date,J4-H4>0),\"+\",\"\")","v":""}]
["Булатов К.П.",27,1,"Люкс",14000,"2020-11-09","2020-11-16","2020-11-21",14000,"2020-11-20",{"$f":"IF(AND(J5=current_date,J5-H5>0),\"+\",\"\")","v":""}]
["Чичваркина Т.И.",13,3,"Комфорт",5300,"2020-11-09","2020-11-18","2020-11-25",15900,"2020-11-20",{"$f":"IF(AND(J6=current_date,J6-H6>0),\"+\",\"\")","v":""}]
["Храмова М.Н.",9,2,"Аппартаменты",2200,"2020-11-09","2020-11-20","2020-11-28",4400,"2020-11-20",{"$f":"IF(AND(J7=current_date,J7-H7>0),\"+\",\"\")","v":""}]
["Казнова М.Р.",4,1,"Стандарт",3200,"2020-11-09","2020-11-25","2020-11-30",3200,"2020-11-20",{"$f":"IF(AND(J8=current_date,J8-H8>0),\"+\",\"\")","v":""}]
["Петров В.Д.",5,4,"Аппартаменты",2200,"2020-11-13","2020-11-29","2020-11-30",8800,"2020-11-20",{"$f":"IF(AND(J9=current_date,J9-H9>0),\"+\",\"\")","v":""}]
["Яблочкин Е.З.",6,2,"Люкс",14000,"2020-11-08","2020-11-13","2020-11-21",28000,"2020-11-20",{"$f":"IF(AND(J10=current_date,J10-H10>0),\"+\",\"\")","v":""}]
["Сабитов К.С.",22,1,"Стандарт",3200,"2020-11-07","2020-11-14","2020-11-18",3200,"2020-11-20",{"$f":"IF(AND(J11=current_date,J11-H11>0),\"+\",\"\")","v":"+"}]
["Арсеиньева И.И.",44,3,"Комфорт",5300,"2020-11-13","2020-11-24","2020-11-28",15900,"2020-11-20",{"$f":"IF(AND(J12=current_date,J12-H12>0),\"+\",\"\")","v":""}]
["Платушкина В.А.",15,2,"Люкс",14000,"2020-11-17","2020-11-20","2020-11-25",28000,"2020-11-20",{"$f":"IF(AND(J13=current_date,J13-H13>0),\"+\",\"\")","v":""}]
["Шулёв А.К.",11,1,"Стандарт",3200,"2020-11-20","2020-11-28","2020-11-30",3200,"2020-11-20",{"$f":"IF(AND(J14=current_date,J14-H14>0),\"+\",\"\")","v":""}]
["Ивашин К.Е.",2,2,"Студия",1550,"2020-11-20","2020-11-27","2020-11-30",3100,"2020-11-20",{"$f":"IF(AND(J15=current_date,J15-H15>0),\"+\",\"\")","v":""}]
["Борисов К.Е.",3,4,"Люкс",14000,"2020-11-20","2020-11-24","2020-11-26",56000,"2020-11-20",{"$f":"IF(AND(J16=current_date,J16-H16>0),\"+\",\"\")","v":""}]
["Нарышкина К.А.",74,1,"Стандарт",3200,"2020-11-05","2020-11-24","2020-11-26",3200,"2020-11-20",{"$f":"IF(AND(J17=current_date,J17-H17>0),\"+\",\"\")","v":""}]
["Былинкина Б.Д.",56,3,"Комфорт",5300,"2020-11-19","2020-11-22","2020-11-29",15900,"2020-11-20",{"$f":"IF(AND(J18=current_date,J18-H18>0),\"+\",\"\")","v":""}]
["Карамзина В.Р.",32,1,"Стандарт",3200,"2020-11-04","2020-11-10","2020-11-23",3200,"2020-11-20",{"$f":"IF(AND(J19=current_date,J19-H19>0),\"+\",\"\")","v":""}]
["Помелов И.А.",10,2,"Аппартаменты",2200,"2020-11-05","2020-11-16","2020-11-18",4400,"2020-11-20",{"$f":"IF(AND(J20=current_date,J20-H20>0),\"+\",\"\")","v":"+"}]
["Одинцов В.А.",78,3,"Комфорт",5300,"2020-11-23","2020-11-25","2020-11-29",15900,"2020-11-20",{"$f":"IF(AND(J21=current_date,J21-H21>0),\"+\",\"\")","v":""}]

{"sheet":"Лист2","index":1,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Как это сделать ?"]
[null,"Формирование списка забронированных, но не занятых номеров на текущую дату"]
[null,"(номер, тип, количество мест, дата бронирования)."]