{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Раз","Два","Лист1"],"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":"Раз","index":0,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["ФИО","№ гостинциы","Класс номера","Стоимость в сутки","Срок проживания","Услуги","Непредвиденные расходы ","Итог"]
["Булгаков Михаил Афанасьевич",24,"Двухместный",{"$f":"IF(C2=Два!$A$2,Два!$D$2,IF(C2=Два!$A$3,Два!$D$3,IF(C2=Два!$A$4,Два!$D$4,\"\")))","v":2500},26,"Нет",12000,77000]
["Чехов Антон Павлович",66,"Люкс",{"$f":"IF(C3=Два!$A$2,Два!$D$2,IF(C3=Два!$A$3,Два!$D$3,IF(C3=Два!$A$4,Два!$D$4,\"\")))","v":3000},14,"Да",15000,57200]
["Иванов Иван Васильевич",33,"Одноместный",{"$f":"IF(C4=Два!$A$2,Два!$D$2,IF(C4=Два!$A$3,Два!$D$3,IF(C4=Два!$A$4,Два!$D$4,\"\")))","v":2000},29,"Да",30000,88200]
["Сидоров Иван Иванович",56,"Двухместный",{"$f":"IF(C5=Два!$A$2,Два!$D$2,IF(C5=Два!$A$3,Два!$D$3,IF(C5=Два!$A$4,Два!$D$4,\"\")))","v":2500},7,"Нет",13000,30500]
["Петров Юрий Александрович",36,"Одноместный",{"$f":"IF(C6=Два!$A$2,Два!$D$2,IF(C6=Два!$A$3,Два!$D$3,IF(C6=Два!$A$4,Два!$D$4,\"\")))","v":2000},4,"Нет",12000,12000]
["Павлюченко Павел Сергеевич",45,"Двухместный",{"$f":"IF(C7=Два!$A$2,Два!$D$2,IF(C7=Два!$A$3,Два!$D$3,IF(C7=Два!$A$4,Два!$D$4,\"\")))","v":2500},13,"Нет",12000,44500]
["Юрченко Михаил Юрьевич",15,"Одноместный",{"$f":"IF(C8=Два!$A$2,Два!$D$2,IF(C8=Два!$A$3,Два!$D$3,IF(C8=Два!$A$4,Два!$D$4,\"\")))","v":2000},35,"Нет",12000,82000]
["Минаков Кирилл Александрович ",34,"Люкс",{"$f":"IF(C9=Два!$A$2,Два!$D$2,IF(C9=Два!$A$3,Два!$D$3,IF(C9=Два!$A$4,Два!$D$4,\"\")))","v":3000},22,"Нет",12300,78300]
["Смолов Фёдор Михайлович ",45,"Двухместный",{"$f":"IF(C10=Два!$A$2,Два!$D$2,IF(C10=Два!$A$3,Два!$D$3,IF(C10=Два!$A$4,Два!$D$4,\"\")))","v":2500},32,"Нет",7500,87500]
["Стоунх Михаил Филлипович",67,"Одноместный",{"$f":"IF(C11=Два!$A$2,Два!$D$2,IF(C11=Два!$A$3,Два!$D$3,IF(C11=Два!$A$4,Два!$D$4,\"\")))","v":2000},27,"Нет",24600,78600]
["Лысов Михаил Павлович",23,"Двухместный",{"$f":"IF(C12=Два!$A$2,Два!$D$2,IF(C12=Два!$A$3,Два!$D$3,IF(C12=Два!$A$4,Два!$D$4,\"\")))","v":2500},19,"Да",13000,60700]
[null,null,null,{"$f":"IF(C13=Два!$A$2,Два!$D$2,IF(C13=Два!$A$3,Два!$D$3,IF(C13=Два!$A$4,Два!$D$4,\"\")))","v":""}]
[null,null,null,{"$f":"IF(C14=Два!$A$2,Два!$D$2,IF(C14=Два!$A$3,Два!$D$3,IF(C14=Два!$A$4,Два!$D$4,\"\")))","v":""}]
[null,null,null,{"$f":"IF(C15=Два!$A$2,Два!$D$2,IF(C15=Два!$A$3,Два!$D$3,IF(C15=Два!$A$4,Два!$D$4,\"\")))","v":""}]
[null,null,null,{"$f":"IF(C16=Два!$A$2,Два!$D$2,IF(C16=Два!$A$3,Два!$D$3,IF(C16=Два!$A$4,Два!$D$4,\"\")))","v":""}]
[null,null,null,{"$f":"IF(C17=Два!$A$2,Два!$D$2,IF(C17=Два!$A$3,Два!$D$3,IF(C17=Два!$A$4,Два!$D$4,\"\")))","v":""}]
[null,null,null,{"$f":"IF(C18=Два!$A$2,Два!$D$2,IF(C18=Два!$A$3,Два!$D$3,IF(C18=Два!$A$4,Два!$D$4,\"\")))","v":""}]
[null,null,null,{"$f":"IF(C19=Два!$A$2,Два!$D$2,IF(C19=Два!$A$3,Два!$D$3,IF(C19=Два!$A$4,Два!$D$4,\"\")))","v":""}]
[null,null,null,{"$f":"IF(C20=Два!$A$2,Два!$D$2,IF(C20=Два!$A$3,Два!$D$3,IF(C20=Два!$A$4,Два!$D$4,\"\")))","v":""}]
[null,null,null,{"$f":"IF(C21=Два!$A$2,Два!$D$2,IF(C21=Два!$A$3,Два!$D$3,IF(C21=Два!$A$4,Два!$D$4,\"\")))","v":""}]
[null,null,null,{"$f":"IF(C22=Два!$A$2,Два!$D$2,IF(C22=Два!$A$3,Два!$D$3,IF(C22=Два!$A$4,Два!$D$4,\"\")))","v":""}]

{"sheet":"Два","index":1,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Тип номера",null,null,"Стоимость проживания"]
["одноместный",null,null,2000]
["двухместный",null,null,2500]
["люкс",null,null,3000]
[]
[]
[]
[null,"s=ЕСЛИ(C2=Два!$A$2;Два!$D$2;ЕСЛИ(C2=Два!$A$3;Два!$D$3;ЕСЛИ(C2=Два!$A$4;Два!$D$4;\"\")))"]

{"sheet":"Лист1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}