{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Västerås","Hallstahammar","Kungsör","Surahammar"],"read":"whole","date_system":"1900"}

{"sheet":"Västerås","index":0,"n_rows":42,"n_cols":20,"rows_kept":42,"merged":[[0,0,0,7],[2,0,2,7],[4,0,4,7],[6,4,6,5],[7,4,7,5],[9,0,9,4],[9,5,9,6],[11,0,12,0],[11,2,12,3],[11,4,12,6],[11,7,12,7],[11,12,11,14],[13,2,13,3],[13,4,13,6],[14,2,14,3],[14,4,14,6],[15,2,15,3],[15,4,15,6],[16,2,16,3],[16,4,16,6],[18,0,18,6],[19,0,20,0],[19,1,20,1],[19,2,20,2],[19,3,20,4],[19,5,19,6],[19,7,20,7],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[26,0,26,6],[27,0,28,0],[27,1,28,1],[27,2,28,2],[27,3,28,4],[27,5,27,6],[27,7,28,7],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[34,0,34,6],[36,0,37,0],[36,1,37,1],[36,2,37,2],[36,3,37,4],[36,5,36,6],[36,7,37,7],[38,3,38,4],[39,3,39,4],[40,3,40,4],[41,3,41,4]]}
["Prisexempel 2025- Västerås"]
[]
["Här ser du prisexempel fjärrvärmekostnad för småhus, flerbostadshus, lokaler och samfälligheter. Alla summor är inkl.moms."]
[]
["Kategori Småhus Västerås"]
[]
[{"$nulls":3},"Vinter","Vår/Höst",null,"Sommar"]
["Rörligt Pris",null,null,975,780,460,265,"Kr/MWh"]
[]
["Fast Småhus",{"$nulls":4},{"v":5580,"d":"5,580"},null,"Kr/år"]
[]
["Årlig fbr (MWh)",null,"Total årskostnad",null,"Varav fast del",null,null,"Varav rörlig del",{"$nulls":4},"Fördelningsnyckel"]
[{"$nulls":12},"Vinter","Vår/Höst","Sommar"]
[15,null,{"$f":"E14+H14","v":{"v":18030.733040118947,"d":"18,031"}},null,{"$f":"$F$10","v":{"v":5580,"d":"5,580"}},null,null,{"$f":"A14*$M$14*$D$8+A14*$N$14*$E$8+A14*$O$14*$G$8","v":{"v":12450.733040118948,"d":"12,451"}},null,{"v":500,"d":"500.0"},null,"Småhus",{"v":0.4401632998774288,"d":"44.0%"},{"v":0.4903551969481335,"d":"49.0%"},{"v":0.06948150317443781,"d":"6.9%"},{"$nulls":4},16549]
[20,null,{"$f":"E15+H15","v":{"v":22180.977386825263,"d":"22,181"}},null,{"$f":"$F$10","v":{"v":5580,"d":"5,580"}},null,null,{"$f":"A15*$M$14*$D$8+A15*$N$14*$E$8+A15*$O$14*$G$8","v":{"v":16600.977386825263,"d":"16,601"}},{"$nulls":11},20205]
[30,null,{"$f":"E16+H16","v":{"v":30481.466080237897,"d":"30,481"}},null,{"v":5580,"d":"5,580"},null,null,{"$f":"A16*$M$14*$D$8+A16*$N$14*$E$8+A16*$O$14*$G$8","v":{"v":24901.466080237897,"d":"24,901"}},{"$nulls":11},27518]
[40,null,{"$f":"E17+H17","v":{"v":38781.95477365053,"d":"38,782"}},null,{"v":5580,"d":"5,580"},null,null,{"$f":"A17*$M$14*$D$8+A17*$N$14*$E$8+A17*$O$14*$G$8","v":{"v":33201.95477365053,"d":"33,202"}},{"$nulls":8},{"$f":"B22*P20","v":19897.5},{"$f":"A22*Q20","v":20550},null,34831]
[]
["Kategori Flerbostadshus Västerås",{"$nulls":6},1900]
["MAX Effekt","BAS Effekt","Årlig fbr (MWh)","Total årskostnad",null,"Varav fast del",null,"Varav rörlig del",{"$nulls":5},"10-24",452.5,1421.25,856.25,null,"Bas",572.5]
[{"$nulls":5},"Fast avg","Ansleffektavgift",null,null,"Bas","Spets","Sommar",null,"25-79",3033.75,1318.75,856.25,null,"Spets",1500]
[24,14,80,{"$f":"SUM(F22:H22)","v":{"v":88766.8275,"d":"88,767"}},null,{"$f":"IF(B22<25,$O$20,IF(B22<80,$O$21,IF(B22<150,$O$22,IF(B22<250,$O$23,IF(B22<500,$O$24,$O$25)))))","v":{"v":452.5,"d":"453"}},{"$f":"IF(B22<25,B22*$P$20+A22*$Q$20,IF(B22<80,B22*$P$21+A22*$Q$21,IF(B22<150,B22*$P$22+A22*$Q$22,IF(B22<250,B22*$P$23+A22*$Q$23,IF(B22<500,B22*$P$24+A22*$Q$24,B22*$P$25+A22*$Q$25)))))","v":{"v":40447.5,"d":"40,448"}},{"$f":"(J22*$T$20+K22*$T$21+L22*$T$22)","v":{"v":47866.8275,"d":"47,867"}},null,69.291,4.491,6.218,null,"80-149",14072.5,1181.25,856.25,null,"Sommar",235]
[57,36,193,{"$f":"SUM(F23:H23)","v":{"v":211629.83250000002,"d":"211,630"}},null,{"$f":"IF(B23<25,$O$20,IF(B23<80,$O$21,IF(B23<150,$O$22,IF(B23<250,$O$23,IF(B23<500,$O$24,$O$25)))))","v":{"v":3033.75,"d":"3,034"}},{"$f":"IF(B23<25,B23*$P$20+A23*$Q$20,IF(B23<80,B23*$P$21+A23*$Q$21,IF(B23<150,B23*$P$22+A23*$Q$22,IF(B23<250,B23*$P$23+A23*$Q$23,IF(B23<500,B23*$P$24+A23*$Q$24,B23*$P$25+A23*$Q$25)))))","v":{"v":96281.25,"d":"96,281"}},{"$f":"(J23*$T$20+K23*$T$21+L23*$T$22)","v":{"v":112314.8325,"d":"112,315"}},null,170.577,7.423,{"v":15.000000000000016,"d":"15.000"},null,"150-249",39480,1012.5,856.25]
[148,95,500,{"$f":"SUM(F24:H24)","v":{"v":541858.55,"d":"541,859"}},null,{"$f":"IF(B24<25,$O$20,IF(B24<80,$O$21,IF(B24<150,$O$22,IF(B24<250,$O$23,IF(B24<500,$O$24,$O$25)))))","v":{"v":14072.5,"d":"14,073"}},{"v":238943.75,"d":"238,944"},{"$f":"(J24*$T$20+K24*$T$21+L24*$T$22)","v":{"v":288842.3,"d":"288,842"}},null,444.206,16.935,38.859,null,"250-499",98075,778.75,856.25]
[295,197,1000,{"$f":"SUM(F25:H25)","v":{"v":1063497.825,"d":"1,063,498"}},null,{"$f":"IF(B25<25,$O$20,IF(B25<80,$O$21,IF(B25<150,$O$22,IF(B25<250,$O$23,IF(B25<500,$O$24,$O$25)))))","v":{"v":39480,"d":"39,480"}},{"v":452056.25,"d":"452,056"},{"$f":"(J25*$T$20+K25*$T$21+L25*$T$22)","v":{"v":571961.575,"d":"571,962"}},null,891.47,28.53,{"v":80.00000000000013,"d":"80.000"},null,">500",212018.75,551.25,856.25]
[]
["Kategori Lokaler Västerås",{"$nulls":6},1700]
["Ansl effekt","BAS Effekt","Årlig fbr (MWh)","Total årskostnad",null,"Varav fast del",null,"Varav rörlig del",{"$nulls":5},"10-24",452.5,1421.25,856.25,null,"Bas",572.5]
[{"$nulls":5},"Fast avg","Ansleffektavgift",null,null,"Bas","Spets","Sommar",null,"25-79",3033.75,1318.75,856.25,null,"Spets",1500]
[24,14,80,{"$f":"SUM(F30:H30)","v":{"v":88766.8275,"d":"88,767"}},null,{"$f":"IF(B30<25,$O$28,IF(B30<80,$O$29,IF(B30<150,$O$30,IF(B30<250,$O$31,IF(B30<500,$O$32,$O$33)))))","v":{"v":452.5,"d":"453"}},{"$f":"IF(B30<25,B30*$P$28+A30*$Q$28,IF(B30<80,B30*$P$29+A30*$Q$29,IF(B30<150,B30*$P$30+A30*$Q$30,IF(B30<250,B30*$P$31+A30*$Q$31,IF(B30<500,B30*$P$32+A30*$Q$32,B30*$P$33+A30*$Q$33)))))","v":{"v":40447.5,"d":"40,448"}},{"$f":"(J30*$T$28+K30*$T$29+L30*$T$30)","v":{"v":47866.8275,"d":"47,867"}},null,69.291,4.491,6.218,null,"80-149",14072.5,1181.25,856.25,null,"Sommar",235]
[57,36,193,{"$f":"SUM(F31:H31)","v":{"v":211629.83250000002,"d":"211,630"}},null,{"$f":"IF(B31<25,$O$28,IF(B31<80,$O$29,IF(B31<150,$O$30,IF(B31<250,$O$31,IF(B31<500,$O$32,$O$33)))))","v":{"v":3033.75,"d":"3,034"}},{"$f":"IF(B31<25,B31*$P$28+A31*$Q$28,IF(B31<80,B31*$P$29+A31*$Q$29,IF(B31<150,B31*$P$30+A31*$Q$30,IF(B31<250,B31*$P$31+A31*$Q$31,IF(B31<500,B31*$P$32+A31*$Q$32,B31*$P$33+A31*$Q$33)))))","v":{"v":96281.25,"d":"96,281"}},{"$f":"(J31*$T$28+K31*$T$29+L31*$T$30)","v":{"v":112314.8325,"d":"112,315"}},null,170.577,7.423,{"v":15.000000000000016,"d":"15.000"},null,"150-249",39480,1012.5,856.25]
[148,95,500,{"$f":"SUM(F32:H32)","v":{"v":541858.55,"d":"541,859"}},null,{"v":14072.5,"d":"14,073"},{"v":238943.75,"d":"238,944"},{"$f":"(J32*$T$28+K32*$T$29+L32*$T$30)","v":{"v":288842.3,"d":"288,842"}},null,444.206,16.935,38.859,null,"250-499",98075,778.75,856.25]
[295,197,1000,{"$f":"SUM(F33:H33)","v":{"v":1063497.825,"d":"1,063,498"}},null,{"$f":"IF(B33<25,$O$28,IF(B33<80,$O$29,IF(B33<150,$O$30,IF(B33<250,$O$31,IF(B33<500,$O$32,$O$33)))))","v":{"v":39480,"d":"39,480"}},{"v":452056.25,"d":"452,056"},{"$f":"(J33*$T$28+K33*$T$29+L33*$T$30)","v":{"v":571961.575,"d":"571,962"}},null,891.47,28.53,{"v":80.00000000000013,"d":"80.000"},null,">500",212018.75,551.25,856.25]
[]
["Kategori Samfälligheter Västerås",{"$nulls":6},2100]
[]
["Ansl effekt","BAS Effekt","Årlig fbr (MWh)","Total årskostnad",null,"Varav fast del",null,"Varav rörlig del",{"$nulls":5},"10-24",337.5,1167.5,706.25,null,"Bas",572.5]
[{"$nulls":5},"Fast avg","Ansleffektavgift",null,null,"Bas","Spets","Sommar",null,"25-79",2226.25,1092.5,706.25,null,"Spets",1500]
[24,14,80,{"$f":"SUM(F39:H39)","v":{"v":81499.3275,"d":"81,499"}},null,{"$f":"IF(B39<25,$O$37,IF(B39<80,$O$38,IF(B39<150,$O$39,IF(B39<250,$O$40,IF(B39<500,$O$41,$O$42)))))","v":{"v":337.5,"d":"338"}},{"$f":"IF(B39<25,B39*$P$37+A39*$Q$37,IF(B39<80,B39*$P$38+A39*$Q$38,IF(B39<150,B39*$P$39+A39*$Q$39,IF(B39<250,B39*$P$40+A39*$Q$40,IF(B39<500,B39*$P$41+A39*$Q$41,B39*$P$42+A39*$Q$42)))))","v":{"v":33295,"d":"33,295"}},{"$f":"(J39*$T$37+K39*$T$38+L39*$T$39)","v":{"v":47866.8275,"d":"47,867"}},null,69.291,4.491,6.218,null,"80-149",12653.75,962.5,706.25,null,"Sommar",235]
[57,35,193,{"$f":"SUM(F40:H40)","v":{"v":194367.65,"d":"194,368"}},null,{"$f":"IF(B40<25,$O$37,IF(B40<80,$O$38,IF(B40<150,$O$39,IF(B40<250,$O$40,IF(B40<500,$O$41,$O$42)))))","v":{"v":2226.25,"d":"2,226"}},{"$f":"IF(B40<25,B40*$P$37+A40*$Q$37,IF(B40<80,B40*$P$38+A40*$Q$38,IF(B40<150,B40*$P$39+A40*$Q$39,IF(B40<250,B40*$P$40+A40*$Q$40,IF(B40<500,B40*$P$41+A40*$Q$41,B40*$P$42+A40*$Q$42)))))","v":{"v":78493.75,"d":"78,494"}},{"$f":"(J40*$T$37+K40*$T$38+L40*$T$39)","v":{"v":113647.65,"d":"113,648"}},null,169.14,8.86,{"v":15,"d":"15.000"},null,"150-249",33926.25,821.25,706.25]
[148,94,500,{"$f":"SUM(F41:H41)","v":{"v":497696.235,"d":"497,696"}},null,{"v":12653.75,"d":"12,654"},{"v":195000,"d":"195,000"},{"$f":"(J41*$T$37+K41*$T$38+L41*$T$39)","v":{"v":290042.485,"d":"290,042"}},null,442.912,18.229,38.859,null,"250-499",80312.5,636.25,706.25]
[295,197,1000,{"$f":"SUM(F42:H42)","v":{"v":976017.825,"d":"976,018"}},null,{"v":33926.25,"d":"33,926"},{"v":370130,"d":"370,130"},{"$f":"(J42*$T$37+K42*$T$38+L42*$T$39)","v":{"v":571961.575,"d":"571,962"}},null,891.47,28.53,{"v":80.00000000000013,"d":"80.000"},null,">500",176100,445,706.25]

{"sheet":"Hallstahammar","index":1,"n_rows":42,"n_cols":20,"rows_kept":42,"merged":[[0,0,0,7],[2,0,2,7],[4,0,4,7],[6,4,6,5],[7,4,7,5],[9,0,9,4],[9,5,9,6],[11,0,12,0],[11,2,12,3],[11,4,12,6],[11,7,12,7],[11,12,11,14],[13,2,13,3],[13,4,13,6],[14,2,14,3],[14,4,14,6],[15,2,15,3],[15,4,15,6],[16,2,16,3],[16,4,16,6],[18,0,18,6],[19,0,20,0],[19,1,20,1],[19,2,20,2],[19,3,20,4],[19,5,19,6],[19,7,20,7],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[26,0,26,6],[27,0,28,0],[27,1,28,1],[27,2,28,2],[27,3,28,4],[27,5,27,6],[27,7,28,7],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[34,0,34,6],[36,0,37,0],[36,1,37,1],[36,2,37,2],[36,3,37,4],[36,5,36,6],[36,7,37,7],[38,3,38,4],[39,3,39,4],[40,3,40,4],[41,3,41,4]]}
["Prisexempel 2025- Hallstahammar"]
[]
["Här ser du prisexempel fjärrvärmekostnad för småhus, flerbostadshus, lokaler och samfälligheter. Alla summor är inkl.moms."]
[]
["Kategori Småhus Hallstahammar"]
[]
[{"$nulls":3},"Vinter","Vår/Höst",null,"Sommar"]
["Rörligt Pris",null,null,975,780,460,265,"Kr/MWh"]
[]
["Fast Småhus",{"$nulls":4},{"v":5580,"d":"5,580"},null,"Kr/år"]
[]
["Årlig fbr (MWh)",null,"Total årskostnad",null,"Varav fast del",null,null,"Varav rörlig del",{"$nulls":4},"Fördelningsnyckel"]
[{"$nulls":12},"Vinter","Vår/Höst","Sommar"]
[15,null,{"$f":"E14+H14","v":{"v":18030.733040118947,"d":"18,031"}},null,{"$f":"$F$10","v":{"v":5580,"d":"5,580"}},null,null,{"$f":"A14*$M$14*$D$8+A14*$N$14*$E$8+A14*$O$14*$G$8","v":{"v":12450.733040118948,"d":"12,451"}},null,{"v":500,"d":"500.0"},null,"Småhus",{"v":0.4401632998774288,"d":"44.0%"},{"v":0.4903551969481335,"d":"49.0%"},{"v":0.06948150317443781,"d":"6.9%"}]
[20,null,{"$f":"E15+H15","v":{"v":22180.977386825263,"d":"22,181"}},null,{"$f":"$F$10","v":{"v":5580,"d":"5,580"}},null,null,{"$f":"A15*$M$14*$D$8+A15*$N$14*$E$8+A15*$O$14*$G$8","v":{"v":16600.977386825263,"d":"16,601"}}]
[30,null,{"$f":"E16+H16","v":{"v":30481.466080237897,"d":"30,481"}},null,{"v":5580,"d":"5,580"},null,null,{"$f":"A16*$M$14*$D$8+A16*$N$14*$E$8+A16*$O$14*$G$8","v":{"v":24901.466080237897,"d":"24,901"}}]
[40,null,{"$f":"E17+H17","v":{"v":38781.95477365053,"d":"38,782"}},null,{"v":5580,"d":"5,580"},null,null,{"$f":"A17*$M$14*$D$8+A17*$N$14*$E$8+A17*$O$14*$G$8","v":{"v":33201.95477365053,"d":"33,202"}}]
[]
["Kategori Flerbostadshus Hallstahammar",{"$nulls":6},1900]
["MAX Effekt","BAS Effekt","Årlig fbr (MWh)","Total årskostnad",null,"Varav fast del",null,"Varav rörlig del",{"$nulls":5},"10-24",452.5,1421.25,856.25,null,"Bas",572.5]
[{"$nulls":5},"Fast avg","Ansleffektavgift",null,null,"Bas","Spets","Sommar",null,"25-79",3033.75,1318.75,856.25,null,"Spets",1500]
[24,15,80,{"$f":"SUM(F22:H22)","v":{"v":90188.0775,"d":"90,188"}},null,{"$f":"IF(B22<25,$O$20,IF(B22<80,$O$21,IF(B22<150,$O$22,IF(B22<250,$O$23,IF(B22<500,$O$24,$O$25)))))","v":{"v":452.5,"d":"453"}},{"$f":"IF(B22<25,B22*$P$20+A22*$Q$20,IF(B22<80,B22*$P$21+A22*$Q$21,IF(B22<150,B22*$P$22+A22*$Q$22,IF(B22<250,B22*$P$23+A22*$Q$23,IF(B22<500,B22*$P$24+A22*$Q$24,B22*$P$25+A22*$Q$25)))))","v":{"v":41868.75,"d":"41,869"}},{"$f":"(J22*$T$20+K22*$T$21+L22*$T$22)","v":{"v":47866.8275,"d":"47,867"}},null,69.291,4.491,6.218,null,"80-149",14072.5,1181.25,856.25,null,"Sommar",235]
[57,36,193,{"$f":"SUM(F23:H23)","v":{"v":211629.83250000002,"d":"211,630"}},null,{"$f":"IF(B23<25,$O$20,IF(B23<80,$O$21,IF(B23<150,$O$22,IF(B23<250,$O$23,IF(B23<500,$O$24,$O$25)))))","v":{"v":3033.75,"d":"3,034"}},{"$f":"IF(B23<25,B23*$P$20+A23*$Q$20,IF(B23<80,B23*$P$21+A23*$Q$21,IF(B23<150,B23*$P$22+A23*$Q$22,IF(B23<250,B23*$P$23+A23*$Q$23,IF(B23<500,B23*$P$24+A23*$Q$24,B23*$P$25+A23*$Q$25)))))","v":{"v":96281.25,"d":"96,281"}},{"$f":"(J23*$T$20+K23*$T$21+L23*$T$22)","v":{"v":112314.8325,"d":"112,315"}},null,170.577,7.423,{"v":15.000000000000016,"d":"15.000"},null,"150-249",39480,1012.5,856.25]
[148,95,500,{"$f":"SUM(F24:H24)","v":{"v":541858.55,"d":"541,859"}},null,{"$f":"IF(B24<25,$O$20,IF(B24<80,$O$21,IF(B24<150,$O$22,IF(B24<250,$O$23,IF(B24<500,$O$24,$O$25)))))","v":{"v":14072.5,"d":"14,073"}},{"v":238943.75,"d":"238,944"},{"$f":"(J24*$T$20+K24*$T$21+L24*$T$22)","v":{"v":288842.3,"d":"288,842"}},null,444.206,16.935,38.859,null,"250-499",98075,778.75,856.25]
[295,197,1000,{"$f":"SUM(F25:H25)","v":{"v":1063497.825,"d":"1,063,498"}},null,{"$f":"IF(B25<25,$O$20,IF(B25<80,$O$21,IF(B25<150,$O$22,IF(B25<250,$O$23,IF(B25<500,$O$24,$O$25)))))","v":{"v":39480,"d":"39,480"}},{"v":452056.25,"d":"452,056"},{"$f":"(J25*$T$20+K25*$T$21+L25*$T$22)","v":{"v":571961.575,"d":"571,962"}},null,891.47,28.53,{"v":80.00000000000013,"d":"80.000"},null,">500",212018.75,551.25,856.25]
[]
["Kategori Lokaler Hallstahammar",{"$nulls":6},1700]
["Ansl effekt","BAS Effekt","Årlig fbr (MWh)","Total årskostnad",null,"Varav fast del",null,"Varav rörlig del",{"$nulls":5},"10-24",452.5,1421.25,856.25,null,"Bas",572.5]
[{"$nulls":5},"Fast avg","Ansleffektavgift",null,null,"Bas","Spets","Sommar",null,"25-79",3033.75,1318.75,856.25,null,"Spets",1500]
[24,15,80,{"$f":"SUM(F30:H30)","v":{"v":90188.0775,"d":"90,188"}},null,{"$f":"IF(B30<25,$O$28,IF(B30<80,$O$29,IF(B30<150,$O$30,IF(B30<250,$O$31,IF(B30<500,$O$32,$O$33)))))","v":{"v":452.5,"d":"453"}},{"$f":"IF(B30<25,B30*$P$28+A30*$Q$28,IF(B30<80,B30*$P$29+A30*$Q$29,IF(B30<150,B30*$P$30+A30*$Q$30,IF(B30<250,B30*$P$31+A30*$Q$31,IF(B30<500,B30*$P$32+A30*$Q$32,B30*$P$33+A30*$Q$33)))))","v":{"v":41868.75,"d":"41,869"}},{"$f":"(J30*$T$28+K30*$T$29+L30*$T$30)","v":{"v":47866.8275,"d":"47,867"}},null,69.291,4.491,6.218,null,"80-149",14072.5,1181.25,856.25,null,"Sommar",235]
[57,36,193,{"$f":"SUM(F31:H31)","v":{"v":211629.83250000002,"d":"211,630"}},null,{"$f":"IF(B31<25,$O$28,IF(B31<80,$O$29,IF(B31<150,$O$30,IF(B31<250,$O$31,IF(B31<500,$O$32,$O$33)))))","v":{"v":3033.75,"d":"3,034"}},{"$f":"IF(B31<25,B31*$P$28+A31*$Q$28,IF(B31<80,B31*$P$29+A31*$Q$29,IF(B31<150,B31*$P$30+A31*$Q$30,IF(B31<250,B31*$P$31+A31*$Q$31,IF(B31<500,B31*$P$32+A31*$Q$32,B31*$P$33+A31*$Q$33)))))","v":{"v":96281.25,"d":"96,281"}},{"$f":"(J31*$T$28+K31*$T$29+L31*$T$30)","v":{"v":112314.8325,"d":"112,315"}},null,170.577,7.423,{"v":15.000000000000016,"d":"15.000"},null,"150-249",39480,1012.5,856.25]
[148,95,500,{"$f":"SUM(F32:H32)","v":{"v":541858.55,"d":"541,859"}},null,{"v":14072.5,"d":"14,073"},{"v":238943.75,"d":"238,944"},{"$f":"(J32*$T$28+K32*$T$29+L32*$T$30)","v":{"v":288842.3,"d":"288,842"}},null,444.206,16.935,38.859,null,"250-499",98075,778.75,856.25]
[295,197,1000,{"$f":"SUM(F33:H33)","v":{"v":1063497.825,"d":"1,063,498"}},null,{"$f":"IF(B33<25,$O$28,IF(B33<80,$O$29,IF(B33<150,$O$30,IF(B33<250,$O$31,IF(B33<500,$O$32,$O$33)))))","v":{"v":39480,"d":"39,480"}},{"v":452056.25,"d":"452,056"},{"$f":"(J33*$T$28+K33*$T$29+L33*$T$30)","v":{"v":571961.575,"d":"571,962"}},null,891.47,28.53,{"v":80.00000000000013,"d":"80.000"},null,">500",212018.75,551.25,856.25]
[]
["Kategori Samfälligheter Hallstahammar",{"$nulls":6},2100]
[]
["Ansl effekt","BAS Effekt","Årlig fbr (MWh)","Total årskostnad",null,"Varav fast del",null,"Varav rörlig del",{"$nulls":5},"10-24",337.5,1167.5,706.25,null,"Bas",572.5]
[{"$nulls":5},"Fast avg","Ansleffektavgift",null,null,"Bas","Spets","Sommar",null,"25-79",2226.25,1092.5,706.25,null,"Spets",1500]
[24,15,80,{"$f":"SUM(F39:H39)","v":{"v":82666.8275,"d":"82,667"}},null,{"$f":"IF(B39<25,$O$37,IF(B39<80,$O$38,IF(B39<150,$O$39,IF(B39<250,$O$40,IF(B39<500,$O$41,$O$42)))))","v":{"v":337.5,"d":"338"}},{"$f":"IF(B39<25,B39*$P$37+A39*$Q$37,IF(B39<80,B39*$P$38+A39*$Q$38,IF(B39<150,B39*$P$39+A39*$Q$39,IF(B39<250,B39*$P$40+A39*$Q$40,IF(B39<500,B39*$P$41+A39*$Q$41,B39*$P$42+A39*$Q$42)))))","v":{"v":34462.5,"d":"34,463"}},{"$f":"(J39*$T$37+K39*$T$38+L39*$T$39)","v":{"v":47866.8275,"d":"47,867"}},null,69.291,4.491,6.218,null,"80-149",12653.75,962.5,706.25,null,"Sommar",235]
[57,35,193,{"$f":"SUM(F40:H40)","v":{"v":194367.65,"d":"194,368"}},null,{"$f":"IF(B40<25,$O$37,IF(B40<80,$O$38,IF(B40<150,$O$39,IF(B40<250,$O$40,IF(B40<500,$O$41,$O$42)))))","v":{"v":2226.25,"d":"2,226"}},{"$f":"IF(B40<25,B40*$P$37+A40*$Q$37,IF(B40<80,B40*$P$38+A40*$Q$38,IF(B40<150,B40*$P$39+A40*$Q$39,IF(B40<250,B40*$P$40+A40*$Q$40,IF(B40<500,B40*$P$41+A40*$Q$41,B40*$P$42+A40*$Q$42)))))","v":{"v":78493.75,"d":"78,494"}},{"$f":"(J40*$T$37+K40*$T$38+L40*$T$39)","v":{"v":113647.65,"d":"113,648"}},null,169.14,8.86,{"v":15,"d":"15.000"},null,"150-249",33926.25,821.25,706.25]
[148,94,500,{"$f":"SUM(F41:H41)","v":{"v":497696.235,"d":"497,696"}},null,{"v":12653.75,"d":"12,654"},{"v":195000,"d":"195,000"},{"$f":"(J41*$T$37+K41*$T$38+L41*$T$39)","v":{"v":290042.485,"d":"290,042"}},null,442.912,18.229,38.859,null,"250-499",80312.5,636.25,706.25]
[295,197,1000,{"$f":"SUM(F42:H42)","v":{"v":976017.825,"d":"976,018"}},null,{"v":33926.25,"d":"33,926"},{"v":370130,"d":"370,130"},{"$f":"(J42*$T$37+K42*$T$38+L42*$T$39)","v":{"v":571961.575,"d":"571,962"}},null,891.47,28.53,{"v":80.00000000000013,"d":"80.000"},null,">500",176100,445,706.25]

{"sheet":"Kungsör","index":2,"n_rows":33,"n_cols":20,"rows_kept":33,"merged":[[0,0,0,7],[2,0,2,7],[4,0,4,7],[6,4,6,5],[7,4,7,5],[9,0,9,4],[9,5,9,6],[11,0,12,0],[11,2,12,3],[11,4,12,6],[11,7,12,7],[11,12,11,14],[13,2,13,3],[13,4,13,6],[14,2,14,3],[14,4,14,6],[15,2,15,3],[15,4,15,6],[16,2,16,3],[16,4,16,6],[18,0,18,6],[19,0,20,0],[19,1,20,1],[19,2,20,2],[19,3,20,4],[19,5,19,6],[19,7,20,7],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[26,0,26,6],[27,0,28,0],[27,1,28,1],[27,2,28,2],[27,3,28,4],[27,5,27,6],[27,7,28,7],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4]]}
["Prisexempel 2025- Kungsör"]
[]
["Här ser du prisexempel fjärrvärmekostnad för småhus, flerbostadshus, lokaler och samfälligheter. Alla summor är inkl.moms."]
[]
["Kategori Småhus Kungsör"]
[]
[{"$nulls":3},"Vinter","Vår/Höst",null,"Sommar"]
["Rörligt Pris",null,null,945,745,460,380,"Kr/MWh"]
[]
["Fast Småhus",{"$nulls":4},{"v":5580,"d":"5,580"},null,"Kr/år"]
[]
["Årlig fbr (MWh)",null,"Total årskostnad",null,"Varav fast del",null,null,"Varav rörlig del",{"$nulls":4},"Fördelningsnyckel"]
[{"$nulls":12},"Vinter","Vår/Höst","Sommar"]
[15,null,{"$f":"E14+H14","v":{"v":17923.586047201956,"d":"17,924"}},null,{"$f":"$F$10","v":{"v":5580,"d":"5,580"}},null,null,{"$f":"A14*$M$14*$D$8+A14*$N$14*$E$8+A14*$O$14*$G$8","v":{"v":12343.586047201956,"d":"12,344"}},{"$nulls":3},"Småhus",{"v":0.47440576355697456,"d":"47.4%"},{"v":0.47908624676832845,"d":"47.9%"},{"v":0.04650798967469679,"d":"4.7%"}]
[20,null,{"$f":"E15+H15","v":{"v":22038.11472960261,"d":"22,038"}},null,{"$f":"$F$10","v":{"v":5580,"d":"5,580"}},null,null,{"$f":"A15*$M$14*$D$8+A15*$N$14*$E$8+A15*$O$14*$G$8","v":{"v":16458.11472960261,"d":"16,458"}}]
[30,null,{"$f":"E16+H16","v":{"v":30267.17209440391,"d":"30,267"}},null,{"v":5580,"d":"5,580"},null,null,{"$f":"A16*$M$14*$D$8+A16*$N$14*$E$8+A16*$O$14*$G$8","v":{"v":24687.17209440391,"d":"24,687"}}]
[40,null,{"$f":"E17+H17","v":{"v":38496.22945920522,"d":"38,496"}},null,{"v":5580,"d":"5,580"},null,null,{"$f":"A17*$M$14*$D$8+A17*$N$14*$E$8+A17*$O$14*$G$8","v":{"v":32916.22945920522,"d":"32,916"}}]
[]
["Kategori Flerbostadshus Kungsör",{"$nulls":6},1900]
["MAX Effekt","BAS Effekt","Årlig fbr (MWh)","Total årskostnad",null,"Varav fast del",null,"Varav rörlig del",{"$nulls":5},"10-24",452.5,1421.25,856.25,null,"Bas",605]
[{"$nulls":5},"Fast avg","Ansleffektavgift",null,null,"Bas","Spets","Sommar",null,"25-79",3033.75,1318.75,856.25,null,"Spets",1530]
[24,14,80,{"$f":"SUM(F22:H22)","v":{"v":92055.125,"d":"92,055"}},null,{"$f":"IF(B22<25,$O$20,IF(B22<80,$O$21,IF(B22<150,$O$22,IF(B22<250,$O$23,IF(B22<500,$O$24,$O$25)))))","v":{"v":452.5,"d":"453"}},{"$f":"IF(B22<25,B22*$P$20+A22*$Q$20,IF(B22<80,B22*$P$21+A22*$Q$21,IF(B22<150,B22*$P$22+A22*$Q$22,IF(B22<250,B22*$P$23+A22*$Q$23,IF(B22<500,B22*$P$24+A22*$Q$24,B22*$P$25+A22*$Q$25)))))","v":{"v":40447.5,"d":"40,448"}},{"$f":"(J22*$T$20+K22*$T$21+L22*$T$22)","v":{"v":51155.125,"d":"51,155"}},null,69.291,4.491,6.218,null,"80-149",14072.5,1181.25,856.25,null,"Sommar",380]
[57,36,193,{"$f":"SUM(F23:H23)","v":{"v":219571.275,"d":"219,571"}},null,{"$f":"IF(B23<25,$O$20,IF(B23<80,$O$21,IF(B23<150,$O$22,IF(B23<250,$O$23,IF(B23<500,$O$24,$O$25)))))","v":{"v":3033.75,"d":"3,034"}},{"$f":"IF(B23<25,B23*$P$20+A23*$Q$20,IF(B23<80,B23*$P$21+A23*$Q$21,IF(B23<150,B23*$P$22+A23*$Q$22,IF(B23<250,B23*$P$23+A23*$Q$23,IF(B23<500,B23*$P$24+A23*$Q$24,B23*$P$25+A23*$Q$25)))))","v":{"v":96281.25,"d":"96,281"}},{"$f":"(J23*$T$20+K23*$T$21+L23*$T$22)","v":{"v":120256.275,"d":"120,256"}},null,170.577,7.423,{"v":15,"d":"15.000"},null,"150-249",39480,1012.5,856.25]
[148,95,500,{"$f":"SUM(F24:H24)","v":{"v":562437.85,"d":"562,438"}},null,{"$f":"IF(B24<25,$O$20,IF(B24<80,$O$21,IF(B24<150,$O$22,IF(B24<250,$O$23,IF(B24<500,$O$24,$O$25)))))","v":{"v":14072.5,"d":"14,073"}},{"v":238943.75,"d":"238,944"},{"$f":"(J24*$T$20+K24*$T$21+L24*$T$22)","v":{"v":309421.6,"d":"309,422"}},null,444.206,16.935,38.859,null,"250-499",98075,778.75,856.25]
[295,197,1000,{"$f":"SUM(F25:H25)","v":{"v":1104926.5,"d":"1,104,927"}},null,{"$f":"IF(B25<25,$O$20,IF(B25<80,$O$21,IF(B25<150,$O$22,IF(B25<250,$O$23,IF(B25<500,$O$24,$O$25)))))","v":{"v":39480,"d":"39,480"}},{"v":452056.25,"d":"452,056"},{"$f":"(J25*$T$20+K25*$T$21+L25*$T$22)","v":{"v":613390.25,"d":"613,390"}},null,891.47,28.53,{"v":80,"d":"80.000"},null,">500",212018.75,551.25,856.25]
[]
["Kategori Lokaler Kungsör",{"$nulls":6},1700]
["Ansl effekt","BAS Effekt","Årlig fbr (MWh)","Total årskostnad",null,"Varav fast del",null,"Varav rörlig del",{"$nulls":5},"10-24",452.5,1421.25,856.25,null,"Bas",605]
[{"$nulls":5},"Fast avg","Ansleffektavgift",null,null,"Bas","Spets","Sommar",null,"25-79",3033.75,1318.75,856.25,null,"Spets",1530]
[24,14,80,{"$f":"SUM(F30:H30)","v":{"v":92055.125,"d":"92,055"}},null,{"$f":"IF(B30<25,$O$28,IF(B30<80,$O$29,IF(B30<150,$O$30,IF(B30<250,$O$31,IF(B30<500,$O$32,$O$33)))))","v":{"v":452.5,"d":"453"}},{"$f":"IF(B30<25,B30*$P$28+A30*$Q$28,IF(B30<80,B30*$P$29+A30*$Q$29,IF(B30<150,B30*$P$30+A30*$Q$30,IF(B30<250,B30*$P$31+A30*$Q$31,IF(B30<500,B30*$P$32+A30*$Q$32,B30*$P$33+A30*$Q$33)))))","v":{"v":40447.5,"d":"40,448"}},{"$f":"(J30*$T$28+K30*$T$29+L30*$T$30)","v":{"v":51155.125,"d":"51,155"}},null,69.291,4.491,6.218,null,"80-149",14072.5,1181.25,856.25,null,"Sommar",380]
[57,36,193,{"$f":"SUM(F31:H31)","v":{"v":219571.275,"d":"219,571"}},null,{"$f":"IF(B31<25,$O$28,IF(B31<80,$O$29,IF(B31<150,$O$30,IF(B31<250,$O$31,IF(B31<500,$O$32,$O$33)))))","v":{"v":3033.75,"d":"3,034"}},{"$f":"IF(B31<25,B31*$P$28+A31*$Q$28,IF(B31<80,B31*$P$29+A31*$Q$29,IF(B31<150,B31*$P$30+A31*$Q$30,IF(B31<250,B31*$P$31+A31*$Q$31,IF(B31<500,B31*$P$32+A31*$Q$32,B31*$P$33+A31*$Q$33)))))","v":{"v":96281.25,"d":"96,281"}},{"$f":"(J31*$T$28+K31*$T$29+L31*$T$30)","v":{"v":120256.275,"d":"120,256"}},null,170.577,7.423,{"v":15,"d":"15.000"},null,"150-249",39480,1012.5,856.25]
[148,95,500,{"$f":"SUM(F32:H32)","v":{"v":562437.85,"d":"562,438"}},null,{"v":14072.5,"d":"14,073"},{"v":238943.75,"d":"238,944"},{"$f":"(J32*$T$28+K32*$T$29+L32*$T$30)","v":{"v":309421.6,"d":"309,422"}},null,444.206,16.935,38.859,null,"250-499",98075,778.75,856.25]
[295,197,1000,{"$f":"SUM(F33:H33)","v":{"v":1104926.5,"d":"1,104,927"}},null,{"$f":"IF(B33<25,$O$28,IF(B33<80,$O$29,IF(B33<150,$O$30,IF(B33<250,$O$31,IF(B33<500,$O$32,$O$33)))))","v":{"v":39480,"d":"39,480"}},{"v":452056.25,"d":"452,056"},{"$f":"(J33*$T$28+K33*$T$29+L33*$T$30)","v":{"v":613390.25,"d":"613,390"}},null,891.47,28.53,{"v":80,"d":"80.000"},null,">500",212018.75,551.25,856.25]

{"sheet":"Surahammar","index":3,"n_rows":33,"n_cols":20,"rows_kept":33,"merged":[[0,0,0,7],[2,0,2,7],[4,0,4,7],[6,4,6,5],[7,4,7,5],[9,0,9,4],[9,5,9,6],[11,0,12,0],[11,2,12,3],[11,4,12,6],[11,7,12,7],[11,12,11,14],[13,2,13,3],[13,4,13,6],[14,2,14,3],[14,4,14,6],[15,2,15,3],[15,4,15,6],[16,2,16,3],[16,4,16,6],[18,0,18,6],[19,0,20,0],[19,1,20,1],[19,2,20,2],[19,3,20,4],[19,5,19,6],[19,7,20,7],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[26,0,26,6],[27,0,28,0],[27,1,28,1],[27,2,28,2],[27,3,28,4],[27,5,27,6],[27,7,28,7],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4]]}
["Prisexempel 2025- Surahammar"]
[]
["Här ser du prisexempel fjärrvärmekostnad för småhus, flerbostadshus, lokaler och samfälligheter. Alla summor är inkl.moms."]
[]
["Kategori Småhus Surahammar"]
[]
[{"$nulls":3},"Vinter","Vår/Höst",null,"Sommar"]
["Rörligt Pris",null,null,975,780,460,265,"Kr/MWh"]
[]
["Fast Småhus",{"$nulls":4},{"v":5580,"d":"5,580"},null,"Kr/år"]
[]
["Årlig fbr (MWh)",null,"Total årskostnad",null,"Varav fast del",null,null,"Varav rörlig del",{"$nulls":4},"Fördelningsnyckel"]
[{"$nulls":12},"Vinter","Vår/Höst","Sommar"]
[15,null,{"$f":"E14+H14","v":{"v":18083.35572476479,"d":"18,083"}},null,{"$f":"$F$10","v":{"v":5580,"d":"5,580"}},null,null,{"$f":"A14*$M$14*$D$8+A14*$N$14*$E$8+A14*$O$14*$G$8","v":{"v":12503.355724764793,"d":"12,503"}},{"$nulls":3},"Småhus",{"v":0.43607665910102383,"d":"43.6%"},{"v":0.5028012045746133,"d":"50.3%"},{"v":0.06112213632436302,"d":"6.1%"}]
[20,null,{"$f":"E15+H15","v":{"v":22251.140966353058,"d":"22,251"}},null,{"$f":"$F$10","v":{"v":5580,"d":"5,580"}},null,null,{"$f":"A15*$M$14*$D$8+A15*$N$14*$E$8+A15*$O$14*$G$8","v":{"v":16671.140966353058,"d":"16,671"}}]
[30,null,{"$f":"E16+H16","v":{"v":30586.711449529586,"d":"30,587"}},null,{"$f":"$F$10","v":{"v":5580,"d":"5,580"}},null,null,{"$f":"A16*$M$14*$D$8+A16*$N$14*$E$8+A16*$O$14*$G$8","v":{"v":25006.711449529586,"d":"25,007"}}]
[40,null,{"$f":"E17+H17","v":{"v":38922.281932706115,"d":"38,922"}},null,{"$f":"$F$10","v":{"v":5580,"d":"5,580"}},null,null,{"$f":"A17*$M$14*$D$8+A17*$N$14*$E$8+A17*$O$14*$G$8","v":{"v":33342.281932706115,"d":"33,342"}}]
[]
["Kategori Flerbostadshus Surahammar",{"$nulls":6},1900]
["MAX Effekt","BAS Effekt","Årlig fbr (MWh)","Total årskostnad",null,"Varav fast del",null,"Varav rörlig del",{"$nulls":5},"10-24",562.5,1637.5,912.5,null,"Bas",620]
[{"$nulls":5},"Fast avg","Ansleffektavgift",null,null,"Bas","Spets","Sommar",null,"25-79",3180,1533.75,912.5,null,"Spets",1550]
[24,14,80,{"$f":"SUM(F22:H22)","v":{"v":96863.47,"d":"96,863"}},null,{"$f":"IF(B22<25,$O$20,IF(B22<80,$O$21,IF(B22<150,$O$22,IF(B22<250,$O$23,IF(B22<500,$O$24,$O$25)))))","v":{"v":562.5,"d":"563"}},{"$f":"IF(B22<25,B22*$P$20+A22*$Q$20,IF(B22<80,B22*$P$21+A22*$Q$21,IF(B22<150,B22*$P$22+A22*$Q$22,IF(B22<250,B22*$P$23+A22*$Q$23,IF(B22<500,B22*$P$24+A22*$Q$24,B22*$P$25+A22*$Q$25)))))","v":{"v":44825,"d":"44,825"}},{"$f":"(J22*$T$20+K22*$T$21+L22*$T$22)","v":{"v":51475.97,"d":"51,476"}},null,69.291,4.491,6.218,null,"80-149",14320,1395,912.5,null,"Sommar",250]
[57,34,193,{"$f":"SUM(F23:H23)","v":{"v":231148.04,"d":"231,148"}},null,{"$f":"IF(B23<25,$O$20,IF(B23<80,$O$21,IF(B23<150,$O$22,IF(B23<250,$O$23,IF(B23<500,$O$24,$O$25)))))","v":{"v":3180,"d":"3,180"}},{"$f":"IF(B23<25,B23*$P$20+A23*$Q$20,IF(B23<80,B23*$P$21+A23*$Q$21,IF(B23<150,B23*$P$22+A23*$Q$22,IF(B23<250,B23*$P$23+A23*$Q$23,IF(B23<500,B23*$P$24+A23*$Q$24,B23*$P$25+A23*$Q$25)))))","v":{"v":104160,"d":"104,160"}},{"$f":"(J23*$T$20+K23*$T$21+L23*$T$22)","v":{"v":123808.04000000001,"d":"123,808"}},null,167.572,10.428,{"v":15,"d":"15.000"},null,"150-249",40103.75,1223.75,912.5]
[148,91,500,{"$f":"SUM(F24:H24)","v":{"v":592825.8999999999,"d":"592,826"}},null,{"$f":"IF(B24<25,$O$20,IF(B24<80,$O$21,IF(B24<150,$O$22,IF(B24<250,$O$23,IF(B24<500,$O$24,$O$25)))))","v":{"v":14320,"d":"14,320"}},{"v":261995,"d":"261,995"},{"$f":"(J24*$T$20+K24*$T$21+L24*$T$22)","v":{"v":316510.89999999997,"d":"316,511"}},null,438.68,22.461,38.859,null,"250-499",99015,988.75,912.5]
[295,188,1000,{"$f":"SUM(F25:H25)","v":{"v":1166477.3,"d":"1,166,477"}},null,{"$f":"IF(B25<25,$O$20,IF(B25<80,$O$21,IF(B25<150,$O$22,IF(B25<250,$O$23,IF(B25<500,$O$24,$O$25)))))","v":{"v":40103.75,"d":"40,104"}},{"v":499252.5,"d":"499,253"},{"$f":"(J25*$T$20+K25*$T$21+L25*$T$22)","v":{"v":627121.05,"d":"627,121"}},null,880.515,39.485,{"v":80,"d":"80.000"},null,">500",214215,758.75,912.5]
[]
["Kategori Lokaler Surahammar",{"$nulls":6},1700]
["Ansl effekt","BAS Effekt","Årlig fbr (MWh)","Total årskostnad",null,"Varav fast del",null,"Varav rörlig del",{"$nulls":5},"10-24",562.5,1637.5,912.5,null,"Bas",620]
[{"$nulls":5},"Fast avg","Ansleffektavgift",null,null,"Bas","Spets","Sommar",null,"25-79",3180,1533.75,912.5,null,"Spets",1550]
[24,14,80,{"$f":"SUM(F30:H30)","v":{"v":96863.47,"d":"96,863"}},null,{"$f":"IF(B30<25,$O$28,IF(B30<80,$O$29,IF(B30<150,$O$30,IF(B30<250,$O$31,IF(B30<500,$O$32,$O$33)))))","v":{"v":562.5,"d":"563"}},{"$f":"IF(B30<25,B30*$P$28+A30*$Q$28,IF(B30<80,B30*$P$29+A30*$Q$29,IF(B30<150,B30*$P$30+A30*$Q$30,IF(B30<250,B30*$P$31+A30*$Q$31,IF(B30<500,B30*$P$32+A30*$Q$32,B30*$P$33+A30*$Q$33)))))","v":{"v":44825,"d":"44,825"}},{"$f":"(J30*$T$28+K30*$T$29+L30*$T$30)","v":{"v":51475.97,"d":"51,476"}},null,69.291,4.491,6.218,null,"80-149",14320,1395,912.5,null,"Sommar",250]
[57,34,193,{"$f":"SUM(F31:H31)","v":{"v":231148.04,"d":"231,148"}},null,{"$f":"IF(B31<25,$O$28,IF(B31<80,$O$29,IF(B31<150,$O$30,IF(B31<250,$O$31,IF(B31<500,$O$32,$O$33)))))","v":{"v":3180,"d":"3,180"}},{"$f":"IF(B31<25,B31*$P$28+A31*$Q$28,IF(B31<80,B31*$P$29+A31*$Q$29,IF(B31<150,B31*$P$30+A31*$Q$30,IF(B31<250,B31*$P$31+A31*$Q$31,IF(B31<500,B31*$P$32+A31*$Q$32,B31*$P$33+A31*$Q$33)))))","v":{"v":104160,"d":"104,160"}},{"$f":"(J31*$T$28+K31*$T$29+L31*$T$30)","v":{"v":123808.04000000001,"d":"123,808"}},null,167.572,10.428,{"v":15,"d":"15.000"},null,"150-249",40103.75,1223.75,912.5]
[148,91,500,{"$f":"SUM(F32:H32)","v":{"v":592825.8999999999,"d":"592,826"}},null,{"v":14320,"d":"14,320"},{"v":261995,"d":"261,995"},{"$f":"(J32*$T$28+K32*$T$29+L32*$T$30)","v":{"v":316510.89999999997,"d":"316,511"}},null,438.68,22.461,38.859,null,"250-499",99015,988.75,912.5]
[295,188,1000,{"$f":"SUM(F33:H33)","v":{"v":1166477.3,"d":"1,166,477"}},null,{"$f":"IF(B33<25,$O$28,IF(B33<80,$O$29,IF(B33<150,$O$30,IF(B33<250,$O$31,IF(B33<500,$O$32,$O$33)))))","v":{"v":40103.75,"d":"40,104"}},{"v":499252.5,"d":"499,253"},{"$f":"(J33*$T$28+K33*$T$29+L33*$T$30)","v":{"v":627121.05,"d":"627,121"}},null,880.515,39.485,{"v":80,"d":"80.000"},null,">500",214215,758.75,912.5]