{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Раз","Раз (2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":2},"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":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["ФИО","№ гостинциы","Класс номера","Стоимость в сутки","Срок проживания","Услуги","Непредвиденные расходы ","Итог"]
["Чехов Антон Павлович",1,"Двухместный",2500,23,"Нет",2600,57000]
["Петров Александр Владмирович",7,"Люкс",3000,16,"Нет",2500,50500,null,null,null,null,null,"Названия строк","Сумма по полю Итог"]
["Сидоров Пётр Сергеевич",2,"Двухместный",2500,6,"Нет",2000,67000,null,null,null,null,null,"Ахматова Анна Владимировна ",53750]
["Иванов Иван Васильевич",4,"Люкс",3000,28,"Нет",3000,87000,null,null,null,null,null,"Булгаков Михаил Афанасьевич",53200]
["Булгаков Михаил Афанасьевич",5,"Люкс",3000,16,"Да",5000,53200,null,null,null,null,null,"Ераева Марина Вячеславовна ",33200]
["Цветаева Марина Александровна",10,"Двухместный",2500,23,"Нет",2000,59500,null,null,null,null,null,"Иванов Иван Васильевич",87000]
["Ахматова Анна Владимировна ",11,"Люкс",2500,21,"Нет",1250,53750,null,null,null,null,null,"Кучня Юрий Михаилович",31900]
["Терешкова Марина Сергеевна",12,"Двухместный",2500,19,"Да",2500,50200,null,null,null,null,null,"Миняев Кирилл Александрович",37600]
["Кучня Юрий Михаилович",3,"Одноместный",2000,13,"Нет",5900,31900,null,null,null,null,null,"Павлова Яна Дмитриевна",21550]
["Ераева Марина Вячеславовна ",13,"Одноместный",2000,15,"Нет",3200,33200,null,null,null,null,null,"Петров Александр Владмирович",50500]
["Павлова Яна Дмитриевна",8,"Двухместный",2500,11,"Да",1350,21550,null,null,null,null,null,"Пичуев Егор Владимирович",43400]
["Пупкин Иван Павлович",32,"Одноместный",2000,20,"Да",2300,42500,null,null,null,null,null,"Пупкин Иван Павлович",42500]
["Миняев Кирилл Александрович",14,"Одноместный",2000,16,"Да",5400,37600,null,null,null,null,null,"Сидоров Пётр Сергеевич",67000]
["Пичуев Егор Владимирович",15,"Люкс",3000,14,"Да",1200,43400,null,null,null,null,null,"Терешкова Марина Сергеевна",50200]
["вфца",8,"Двухместный",2500,11,"Да",1350,21550,null,null,null,null,null,"Цветаева Марина Александровна",59500]
["qw",2,"Двухместный",2500,3,"Нет",44,7544,null,null,null,null,null,"Чехов Антон Павлович",57000]
[" wwww",3,"Одноместный",2000,4,"Да",443,8200,null,null,null,null,null,"вфца",21550]
["па",54,"Двухместный",2500,13,"Да",4300,37000,null,null,null,null,null,"qw",7544]
["Итог"," ",null," ",null,null,null," ",null,null,null,null,null," wwww",8200]
[{"$f":"\"Всего клиентов: \"  & COUNTA(A2:A19)","v":"Всего клиентов: 18"},{"$f":"\"Занято: \" & COUNT(B2:B19)","v":"Занято: 18"},null,{"$f":"\"Всего за номер \" &SUM(D2:D19)","v":"Всего за номер 44500"},null,null,null,{"$f":"\"Итого \"& SUM(H2:H19)","v":"Итого 762594"},null,null,null,null,null,"па",37000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Общий итог",762594]

{"sheet":"Раз (2)","index":1,"n_rows":22,"n_cols":15,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["ФИО","№ гостинциы","Класс номера","Стоимость в сутки","Срок проживания","Услуги","Непредвиденные расходы ","Итог"]
["Чехов Антон Павлович",1,"Двухместный",2500,23,"Нет",2600,57000]
["Петров Александр Владмирович",7,"Люкс",3000,16,"Нет",2500,50500,null,null,null,null,null,"Названия строк","Сумма по полю Итог"]
["Сидоров Пётр Сергеевич",2,"Двухместный",2500,6,"Нет",2000,67000,null,null,null,null,null,"Ахматова Анна Владимировна ",53750]
["Иванов Иван Васильевич",4,"Люкс",3000,28,"Нет",3000,87000,null,null,null,null,null,"Булгаков Михаил Афанасьевич",53200]
["Булгаков Михаил Афанасьевич",5,"Люкс",3000,16,"Да",5000,53200,null,null,null,null,null,"Ераева Марина Вячеславовна ",33200]
["Цветаева Марина Александровна",10,"Двухместный",2500,23,"Нет",2000,59500,null,null,null,null,null,"Иванов Иван Васильевич",87000]
["Ахматова Анна Владимировна ",11,"Люкс",2500,21,"Нет",1250,53750,null,null,null,null,null,"Кучня Юрий Михаилович",31900]
["Терешкова Марина Сергеевна",12,"Двухместный",2500,19,"Да",2500,50200,null,null,null,null,null,"Миняев Кирилл Александрович",37600]
["Кучня Юрий Михаилович",3,"Одноместный",2000,13,"Нет",5900,31900,null,null,null,null,null,"Павлова Яна Дмитриевна",21550]
["Ераева Марина Вячеславовна ",13,"Одноместный",2000,15,"Нет",3200,33200,null,null,null,null,null,"Петров Александр Владмирович",50500]
["Павлова Яна Дмитриевна",8,"Двухместный",2500,11,"Да",1350,21550,null,null,null,null,null,"Пичуев Егор Владимирович",43400]
["Пупкин Иван Павлович",32,"Одноместный",2000,20,"Да",2300,42500,null,null,null,null,null,"Пупкин Иван Павлович",42500]
["Миняев Кирилл Александрович",14,"Одноместный",2000,16,"Да",5400,37600,null,null,null,null,null,"Сидоров Пётр Сергеевич",67000]
["Пичуев Егор Владимирович",15,"Люкс",3000,14,"Да",1200,43400,null,null,null,null,null,"Терешкова Марина Сергеевна",50200]
["вфца",8,"Двухместный",2500,11,"Да",1350,21550,null,null,null,null,null,"Цветаева Марина Александровна",59500]
["qw",2,"Двухместный",2500,3,"Нет",44,7544,null,null,null,null,null,"Чехов Антон Павлович",57000]
[" wwww",3,"Одноместный",2000,4,"Да",443,8200,null,null,null,null,null,"вфца",21550]
["па",54,"Двухместный",2500,13,"Да",4300,37000,null,null,null,null,null,"qw",7544]
[{"$f":"SUBTOTAL(103,Таблица1[ФИО])","v":18},{"$f":"SUBTOTAL(103,Таблица1[№ гостинциы])","v":18},null,{"$f":"SUBTOTAL(109,Таблица1[Стоимость в сутки])","v":44500},null,null,null,{"$f":"SUBTOTAL(109,Таблица1[Итог])","v":762594},null,null,null,null,null," wwww",8200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"па",37000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Общий итог",762594]