{"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":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[[19,9,22,9],[34,1,36,1],[19,2,19,5],[19,6,19,8],[20,2,22,2],[20,3,22,3],[20,5,21,5],[20,6,21,7],[23,1,23,9],[24,1,26,1],[27,1,29,1],[30,1,30,9],[31,1,33,1]]}
[2]
[{"$f":"MONTH(TODAY())","v":3}]
[null,"                                      АКТ                              «  25  »      12    2015 г."]
[null," "]
[null,"Мы, нижеподписавшиеся, представитель                                                                              "]
[null,"В лице___Начальника отдела ОДПУ_________________________с одной стороны  "]
[null,null,null,null,null,"(должность, Ф.И.О.) "]
[null,"                                                                                                                                                   "]
[null,null,null,null,null,"(наименование абонента, адрес)          "]
[null,"и представитель МУП « теплосеть»  в лице  начальника службы организации учета и "]
[null,"контроля         за потреблением тепловой энергии  с другой стороны."]
[null,"  Составили настоящий акт о том, что показания теплосчетчик (а,ов) и результаты последующих "]
[null,"расчетов потребленной тепловой энергии   и   теплоносителя   на   отопление   и   (или)    горячее    "]
[null,"водоснабжение    за    отчетный    период"]
[]
[null,"с    « 23_  »     _01__     2017   г.     по     «  _23 »     02__     2017   г.  "]
[null,"соответствуют значениям, приведенным в таблице."]
[]
[]
[null,"Тип прибора","Показания теплосчетчика",null,null,null,"Результаты расчета",null,null,"Примечание"]
[null,"зав. №","Параметры","Ед. изм.","Предыдущие","На данный момент (дата)","Кол-во потребл. тепловой энергии",null,"Кол-во потребл. теплоно"]
[null,null,null,null,"(дата)",null,null,null,"сителя"]
[null,null,null,null,"2017-01-23","2017-02-22","ГДж","Гкал"]
[null,"ОТОПЛЕНИЕ"]
[null,"№","Q1",null,{"$f":"CHOOSE(A1,Показания!D14,Показания!L14,Показания!T14,Показания!AB14,Показания!AJ14,Показания!AR14,Показания!AZ14,Показания!BH14,Показания!BP14,Показания!BX14,Показания!CF14,Показания!CN14)","v":1094},{"$f":"CHOOSE(A1,Показания!L14,Показания!T14,Показания!AB14,Показания!AJ14,Показания!AR14,Показания!AZ14,Показания!BH14,Показания!BP14,Показания!BX14,Показания!CF14,Показания!CN14,Показания!CV14)","v":1183},null,{"$f":"F25-E25","v":89}]
[null,null,"Q2"]
[null,null,"M1","т",{"$f":"CHOOSE(A1,Показания!E14,Показания!M14,Показания!U14,Показания!AC14,Показания!AK14,Показания!AS14,Показания!BA14,Показания!BI14,Показания!BQ14,Показания!BY14,Показания!CG14,Показания!CO14)","v":88126},{"$f":"CHOOSE(A1,Показания!M14,Показания!U14,Показания!AC14,Показания!AK14,Показания!AS14,Показания!BA14,Показания!BI14,Показания!BQ14,Показания!BY14,Показания!CG14,Показания!CO14,Показания!CW14)","v":93276},null,null,{"$f":"F27-E27","v":5150},"Дм="]
[null,"ТЭМ- 104","M2","т",{"$f":"CHOOSE(A1,Показания!F14,Показания!N14,Показания!V14,Показания!AD14,Показания!AL14,Показания!AT14,Показания!BB14,Показания!BJ14,Показания!BR14,Показания!BZ14,Показания!CH14,Показания!CP14)","v":86544},{"$f":"CHOOSE(A1,Показания!N14,Показания!V14,Показания!AD14,Показания!AL14,Показания!AT14,Показания!BB14,Показания!BJ14,Показания!BR14,Показания!BZ14,Показания!CH14,Показания!CP14,Показания!CX14)","v":91729},null,null,{"$f":"F28-E28","v":5185}]
[null,null,"T раб.",null,null,null,null,null,null,{"$f":"I27-I28","v":-35}]
[null,null,"T нар.",null,{"$f":"CHOOSE(A1,Показания!G14,Показания!O14,Показания!W14,Показания!AE14,Показания!AM14,Показания!AU14,Показания!BC14,Показания!BK14,Показания!BS14,Показания!CA14,Показания!CI14,Показания!CQ14)","v":19759},{"$f":"CHOOSE(A1,Показания!O14,Показания!W14,Показания!AE14,Показания!AM14,Показания!AU14,Показания!BC14,Показания!BK14,Показания!BS14,Показания!CA14,Показания!CI14,Показания!CQ14,Показания!CY14)","v":20503},null,{"$f":"F30-E30","v":744}]
[null,"ГВС "]
[null,"№","Q1",null,{"$f":"CHOOSE(A1,Показания!H14,Показания!P14,Показания!X14,Показания!AF14,Показания!AN14,Показания!AV14,Показания!BD14,Показания!BL14,Показания!BT14,Показания!CB14,Показания!CJ14,Показания!CR14)","v":883},{"$f":"CHOOSE(A1,Показания!P14,Показания!X14,Показания!AF14,Показания!AN14,Показания!AV14,Показания!BD14,Показания!BL14,Показания!BT14,Показания!CB14,Показания!CJ14,Показания!CR14,Показания!CZ14)","v":916},null,{"$f":"F32-E32","v":33}]
[null,null,"Q2"]
[null,null,"M1","т",{"$f":"CHOOSE(A1,Показания!I14,Показания!Q14,Показания!Y14,Показания!AG14,Показания!AO14,Показания!AW14,Показания!BE14,Показания!BM14,Показания!BU14,Показания!CC14,Показания!CK14,Показания!CS14)","v":72836},{"$f":"CHOOSE(A1,Показания!Q14,Показания!Y14,Показания!AG14,Показания!AO14,Показания!AW14,Показания!BE14,Показания!BM14,Показания!BU14,Показания!CC14,Показания!CK14,Показания!CS14,Показания!DA14)","v":75182},null,null,{"$f":"F34-E34","v":2346}]
[null,"ТЭМ- 104","M2","т",{"$f":"CHOOSE(A1,Показания!J14,Показания!R14,Показания!Z14,Показания!AH14,Показания!AP14,Показания!AX14,Показания!BF14,Показания!BN14,Показания!BV14,Показания!CD14,Показания!CL14,Показания!CT14)","v":63267},{"$f":"CHOOSE(A1,Показания!R14,Показания!Z14,Показания!AH14,Показания!AP14,Показания!AX14,Показания!BF14,Показания!BN14,Показания!BV14,Показания!CD14,Показания!CL14,Показания!CT14,Показания!DB14)","v":65285},null,null,{"$f":"F35-E35","v":2018}]
[null,null,"Tраб."]
[null,null,"Tнар.",null,{"$f":"CHOOSE(A1,Показания!K14,Показания!S14,Показания!AA14,Показания!AI14,Показания!AQ14,Показания!AY14,Показания!BG14,Показания!BO14,Показания!BW14,Показания!CE14,Показания!CM14,Показания!CU14)","v":19759},{"$f":"CHOOSE(A1,Показания!S14,Показания!AA14,Показания!AI14,Показания!AQ14,Показания!AY14,Показания!BG14,Показания!BO14,Показания!BW14,Показания!CE14,Показания!CM14,Показания!CU14,Показания!DC14)","v":20503},null,{"$f":"F37-E37","v":744}]
[]
[]
[]
[null,"Представитель потребителя      ____________________________                      "]
[null,"                                                                                          (подпись, дата)                                               ",null,null,null,null,null,null,"(Ф.И.О.)"]
[]
[null,"Представитель "]
[null,"МУП «теплосеть» _____________________________                     "]
[null,"                                                                                          (подпись, дата)                                               ",null,null,null,null,null,null,"(Ф.И.О.)"]

{"sheet":"Показания","index":1,"n_rows":14,"n_cols":107,"rows_kept":14,"cut":false,"hidden":false,"merged":[[3,95,3,98],[3,91,3,94],[6,91,6,98],[3,103,3,106],[3,99,3,102],[6,99,6,106],[6,75,6,82],[6,83,6,90],[3,55,3,58],[3,67,3,70],[3,79,3,82],[3,75,3,78],[3,87,3,90],[3,83,3,86],[3,51,3,54],[6,51,6,58],[3,63,3,66],[3,59,3,62],[3,71,3,74],[6,59,6,66],[6,67,6,74],[3,35,3,38],[3,39,3,42],[6,35,6,42],[3,47,3,50],[3,43,3,46],[6,43,6,50],[6,3,6,10],[3,19,3,22],[3,31,3,34],[3,27,3,30],[3,1,6,1],[3,2,6,2],[3,11,3,14],[3,23,3,26],[6,19,6,26],[3,7,3,10],[3,3,3,6],[3,15,3,18],[6,11,6,18],[6,27,6,34]]}
[2]
[{"$f":"MONTH(TODAY())","v":3}]
[]
[null,"Улица","№ дома","Показания ТП",null,null,null,"Показания ГВС",null,null,null,"Показания ТП",null,null,null,"Показания ГВС",null,null,null,"Показания ТП",null,null,null,"Показания ГВС",null,null,null,"Показания ТП",null,null,null,"Показания ГВС",null,null,null,"Показания ГВС",null,null,null,"Показания ТП",null,null,null,"Показания ТП",null,null,null,"Показания ГВС",null,null,null,"Показания ТП",null,null,null,"Показания ГВС",null,null,null,"Показания ТП",null,null,null,"Показания ГВС",null,null,null,"Показания ТП",null,null,null,"Показания ГВС",null,null,null,"Показания ТП",null,null,null,"Показания ГВС",null,null,null,"Показания ТП",null,null,null,"Показания ГВС",null,null,null,"Показания ТП",null,null,null,"Показания ГВС",null,null,null,"Показания ТП",null,null,null,"Показания ГВС"]
[null,null,null,"Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар","Q","Мп","Мо","Tнар"]
[null,null,null,"гкал","т","т","час","гкал","т","т","час","гкал","т","т","час","гкал","т","т","час","гкал","т","т","час","гкал","т","т","час","гкал","т","т","час","гкал","т","т","час","гкал","т","т","час","гкал","т","т","час","гкал","т","т","час","гкал","т","т","час","гкал","т","т","час","гкал","т","т","час","гкал","т","т","час","гкал","т","т","час","гкал","т","т","час","гкал","т","т","час","гкал","т","т","час","гкал","т","т","час","гкал","т","т","час","гкал","т","т","час","гкал","т","т","час","гкал","т","т","час","гкал","т","т","час","гкал","т","т","час"]
[null,null,null,"2016-12-01",null,null,null,null,null,null,null,"2017-01-01",null,null,null,null,null,null,null,"2017-02-01",null,null,null,null,null,null,null,"2017-03-01",null,null,null,null,null,null,null,"2017-04-01",null,null,null,null,null,null,null,"2017-05-01",null,null,null,null,null,null,null,"2017-06-01",null,null,null,null,null,null,null,"2017-07-01",null,null,null,null,null,null,null,"2017-08-01",null,null,null,null,null,null,null,"2017-09-01",null,null,null,null,null,null,null,"2017-10-01",null,null,null,null,null,null,null,"2017-11-01",null,null,null,null,null,null,null,"2017-12-01"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,1094,88126,86544,19759,883,72836,63267,19759,1183,93276,91729,20503,916,75182,65285,20503]

{"sheet":"Лист1","index":2,"n_rows":150,"n_cols":34,"rows_kept":150,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"C140","v":1183},{"$f":"C141","v":93276},{"$f":"C142","v":91729},{"$f":"C143","v":20503},{"$f":"C146","v":916},{"$f":"C147","v":75182},{"$f":"C148","v":65285},{"$f":"C149","v":20503}]
[null,null,{"$f":"ROUND(D140,0)","v":1183},1183.3]
[null,null,{"$f":"ROUND(D141,0)","v":93276},93275.7]
[null,null,91729,91728.6]
[null,null,20503,20502.7]
[]
[]
[null,null,{"$f":"ROUND(D146,0)","v":916},916.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,883.1,null,null,null,null,null,null,null,null,null,null,null,null,null,916.2]
[null,null,75182,75181.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72835.5,null,null,null,null,null,null,null,null,null,null,null,null,null,75181.5]
[null,null,65285,65284.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63266.9,null,null,null,null,null,null,null,null,null,null,null,null,null,65284.7]
[null,null,20503,20502.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19758.7,null,null,null,null,null,null,null,null,null,null,null,null,null,20502.7]
[null,null,null,"Время неработы Тнер = Tmax + Tmin + Tтех.н, ч"]