{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["2024","2025","Тариф","Формула"],"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":"2024","index":0,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,0,5]]}
["Период","Дата снятия показания счётчика","Показание счётчика","Разница показаний","Оплата потребителем",null,null,null,null,null,"лето",null,null,"зима"]
[null,null,null,null,"дата","сумма",null,null,null,null,0,650,null,0,650]
["2024-01-01",null,1250,501,null,{"$f":"Tarif(IF(OR(MONTH(A3)<3,MONTH(A3)>10),$N$2:$O$6,$K$2:$L$6),D3)","v":326500},null,null,null,null,100,1500,null,500,1500]
["2024-02-01",null,1867,{"$f":"C4-C3","v":617},null,{"$f":"Tarif(IF(OR(MONTH(A4)<3,MONTH(A4)>10),$N$2:$O$6,$K$2:$L$6),D4)","v":500500},null,null,null,null,2500,1950,null,2500,1950]
["2024-03-01",null,null,null,null,{"$f":"Tarif(IF(OR(MONTH(A5)<3,MONTH(A5)>10),$N$2:$O$6,$K$2:$L$6),D5)","v":0},null,null,null,null,5000,2275,null,5000,2275]
["2024-04-01",null,null,null,null,{"$f":"Tarif(IF(OR(MONTH(A6)<3,MONTH(A6)>10),$N$2:$O$6,$K$2:$L$6),D6)","v":0},null,null,null,null,10000,2600,null,10000,2600]
["2024-05-01",null,null,null,null,{"$f":"Tarif(IF(OR(MONTH(A7)<3,MONTH(A7)>10),$N$2:$O$6,$K$2:$L$6),D7)","v":0}]
["2024-06-01",null,null,null,null,{"$f":"Tarif(IF(OR(MONTH(A8)<3,MONTH(A8)>10),$N$2:$O$6,$K$2:$L$6),D8)","v":0}]
["2024-07-01",null,null,null,null,{"$f":"Tarif(IF(OR(MONTH(A9)<3,MONTH(A9)>10),$N$2:$O$6,$K$2:$L$6),D9)","v":0},null,null,null,null,"зима","лето"]
["2024-08-01","2024-08-30",39,null,null,{"$f":"Tarif(IF(OR(MONTH(A10)<3,MONTH(A10)>10),$N$2:$O$6,$K$2:$L$6),D10)","v":0},null,null,null,617,{"$f":"Tarif($N$2:$O$6,J10)","v":500500},{"$f":"Tarif($K$2:$L$6,J10)","v":840500}]
["2024-09-01","2024-09-29",78,{"$f":"C11-C10","v":39},null,{"$f":"Tarif(IF(OR(MONTH(A11)<3,MONTH(A11)>10),$N$2:$O$6,$K$2:$L$6),D11)","v":25350}]
["2024-10-01","2024-10-28",129,51,null,{"$f":"Tarif(IF(OR(MONTH(A12)<3,MONTH(A12)>10),$N$2:$O$6,$K$2:$L$6),D12)","v":33150}]
["2024-11-01","2023-11-27",350,221,null,{"$f":"Tarif(IF(OR(MONTH(A13)<3,MONTH(A13)>10),$N$2:$O$6,$K$2:$L$6),D13)","v":143650}]
["2024-12-01","2023-12-28",1250,900,null,{"$f":"Tarif(IF(OR(MONTH(A14)<3,MONTH(A14)>10),$N$2:$O$6,$K$2:$L$6),D14)","v":925000}]
["2025-01-01",null,1810,560,null,{"$f":"Tarif(IF(OR(MONTH(A15)<3,MONTH(A15)>10),$N$2:$O$6,$K$2:$L$6),D15)","v":415000}]
["2025-02-01",null,2020,210,null,{"$f":"Tarif(IF(OR(MONTH(A16)<3,MONTH(A16)>10),$N$2:$O$6,$K$2:$L$6),D16)","v":136500}]
["2025-03-01",null,2121,101,null,{"$f":"Tarif(IF(OR(MONTH(A17)<3,MONTH(A17)>10),$N$2:$O$6,$K$2:$L$6),D17)","v":66500},{"$f":"100*650","v":65000},{"$f":"1*1500","v":1500},{"$f":"G17+H17","v":66500}]

{"sheet":"2025","index":1,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,0,5]]}
["Период","Дата снятия показания счётчика","Показание счётчика","Разница показаний","Оплата потребителем",null,null,null,null,null,"лето",null,null,"зима"]
[null,null,null,null,"дата","сумма",null,null,null,null,0,650,null,0,650]
["2025-01-01",null,1810,{"$f":"C3-'2024'!C14","v":560},null,{"$f":"D3*VLOOKUP(D3,IF(OR(MONTH(A3)<3,MONTH(A3)>10),$N$2:$O$6,$K$2:$L$6),2,1)","v":840000},{"$f":"500*650","v":325000},{"$f":"60*1500","v":90000},{"$f":"G3+H3","v":415000},{"$f":"Tarif(IF(OR(MONTH(A3)<3,MONTH(A3)>10),$N$2:$O$6,$K$2:$L$6),D3)","v":415000},100,1500,null,500,1500]
["2025-02-01",null,2020,{"$f":"C4-C3","v":210},null,{"$f":"D4*VLOOKUP(D4,IF(OR(MONTH(A4)<3,MONTH(A4)>10),$N$2:$O$6,$K$2:$L$6),2,1)","v":136500},{"$f":"210*650","v":136500},null,{"$f":"G4","v":136500},{"$f":"Tarif(IF(OR(MONTH(A4)<3,MONTH(A4)>10),$N$2:$O$6,$K$2:$L$6),D4)","v":136500},2500,1950,null,2500,1950]
["2025-03-01",null,2121,{"$f":"C5-C4","v":101},null,{"$f":"D5*VLOOKUP(D5,IF(OR(MONTH(A5)<3,MONTH(A5)>10),$N$2:$O$6,$K$2:$L$6),2,1)","v":151500},{"$f":"100*650","v":65000},{"$f":"1*1500","v":1500},{"$f":"G5+H5","v":66500},{"$f":"Tarif(IF(OR(MONTH(A5)<3,MONTH(A5)>10),$N$2:$O$6,$K$2:$L$6),D5)","v":66500},5000,2275,null,5000,2275]
["2025-04-01",null,2194,{"$f":"C6-C5","v":73},null,{"$f":"D6*VLOOKUP(D6,IF(OR(MONTH(A6)<3,MONTH(A6)>10),$N$2:$O$6,$K$2:$L$6),2,1)","v":47450},null,null,null,{"$f":"Tarif(IF(OR(MONTH(A6)<3,MONTH(A6)>10),$N$2:$O$6,$K$2:$L$6),D6)","v":47450},10000,2600,null,10000,2600]
["2025-05-01",null,2356,{"$f":"C7-C6","v":162},null,{"$f":"D7*VLOOKUP(D7,IF(OR(MONTH(A7)<3,MONTH(A7)>10),$N$2:$O$6,$K$2:$L$6),2,1)","v":243000},{"$f":"100*650","v":65000},{"$f":"62*1500","v":93000},{"$f":"G7+H7","v":158000},{"$f":"Tarif(IF(OR(MONTH(A7)<3,MONTH(A7)>10),$N$2:$O$6,$K$2:$L$6),D7)","v":158000}]
["2025-06-01",null,2518,{"$f":"C8-C7","v":162},null,{"$f":"IF(D8>0,IF(D8<=100,D8*Тариф!$B$4,IF(D8<=2500,100*Тариф!$B$4+(D8-100)*Тариф!$B$5,IF(D8<=5000,100*Тариф!$B$4+2400*Тариф!$B$5+(D8-5000)*Тариф!$B$6))),2)","v":158000},null,null,null,{"$f":"Tarif(IF(OR(MONTH(A8)<3,MONTH(A8)>10),$N$2:$O$6,$K$2:$L$6),D8)","v":158000}]
["2025-07-01"]
["2025-08-01"]
["2025-09-01"]
["2025-10-01"]
["2025-11-01"]
["2025-12-01"]

{"sheet":"Тариф","index":2,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,1,1],[8,0,8,1],[0,0,0,1]]}
["Социальная норма на газ (с 01.05.2024)"]
["летний период (март-октябрь)"]
["куб. м","тариф",null,"лето",null,null,"зима"]
["0-100",650,null,0,650,null,0,650,null,null,221,{"$f":"K4*VLOOKUP(K4,$G$4:$H$8,2,1)","v":143650}]
["101-2500",1500,null,100,1500,null,500,1500]
["2501-5000",1950,null,2500,1950,null,2500,1950]
["5001-10000",2275,null,5000,2275,null,5000,2275]
["10001 и более",2600,null,10000,2600,null,10000,2600]
["зимний период (ноябрь-февраль)"]
["0-500",650]
["501-2500",1500]
["2501-5000",1950]
["5001-10000",2275]
["10001 и более",2600]

{"sheet":"Формула","index":3,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Формула расчёта по оплате израсходованного газа"]
["летний период (март-октябрь)"]
["ЕСЛИ(D11>0;ЕСЛИ(D11<=100;D11*Тариф!$B$3;ЕСЛИ(D11<=2500;100*Тариф!$B$3+(D11-100)*Тариф!$B$4;ЕСЛИ(D11<=5000;100*Тариф!$B$3+2400*Тариф!$B$4+(D11-5000)*Тариф!$B$5)));2)"]
["зимний период (ноябрь-февраль)"]
["ЕСЛИ(D11>0;ЕСЛИ(D11<=500;D11*Тариф!$B$9;ЕСЛИ(D11<=2500;500*Тариф!$B$9+(D11-500)*Тариф!$B$10;ЕСЛИ(D11<=5000;500*Тариф!$B$9+2000*Тариф!$B$10+(D11-5000)*Тариф!$B$11)));2)"]