{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Verktøy","Beregninger","Energimerke D","Input"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":4,"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":"Verktøy","index":0,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,4,2,15],[44,4,46,6],[6,4,6,6],[21,4,23,6],[21,1,26,2],[8,4,8,5],[16,4,16,5]]}
[]
[null,null,"Oransje felt fylles ut av saksbehandler",null,"HUSK Å FYLLE UT DE ORANSJE FELTENE"]
[null,null,"Grønne felt beregnes automatisk"]
[]
[null,"Kundeinformasjon",null,null,null,"Tiltak 1",null,null,"Etterisolering vegg"]
[null,"Navn",null,null,"Utføres på",null,100,null,"Yttervegg isoleres så den tilsvarer energitiltakskravet for vegg i TEK17, dvs. at den "]
[null,"Adresse",null,null,"% av fasaden.",null,null,null,"oppnår en U-verdi på ≤ 0,18 W/(m²K). Angi %-andel av fasaden som etterisoleres."]
[null,null,null,null,null,null,null,null,"Gir ikke besparelse for boliger som er bygd etter 2008."]
[]
[null,null,null,null,null,"Tiltak 2",null,null,"Etterisolering tak"]
[null,"Prosjektinformasjon",null,null,"Utføres på",null,100,null,"Tak isoleres så det tilsvarer energitiltakskravet for tak i TEK17, dvs. en U-verdi på "]
[null,"Bygningstype","Rekkehus, enebolig, to- eller firemannsbolig",null,"% av taket.",null,null,null,"≤ 0,13 W/(m²K). Gir ikke besparelse for boliger som er bygd etter 1998."]
[null,"Byggeår/Rehabår"]
[null,"Kommune","Alstahaug",null,null,"Tiltak 3",null,null,"Etterisolering gulv"]
[null,"Bruksareal [m2]",null,null,"Utføres på",null,100,null,"Gulv isoleres så det tilsvarer energitiltakskravet for gulv i TEK17, dvs. en U-verdi på "]
[null,null,null,null,"% av gulvet.",null,null,null,"≤ 0,10 W/(m²K)."]
[null,"Krav besparelse i %",30]
[null,"Oppnådd besparelse i %",{"$f":"IF(C12=\"Rekkehus, enebolig, to- eller firemannsbolig\",Beregninger!H12,Beregninger!H22)","v":40.981443428067436},null,null,"Tiltak 4",null,null,"Skifte vinduer og dører"]
[null,null,null,null,"Utføres på",null,100,null,"Vinduer og dører erstattes. U-verdi på de nye skal være ≤ 0,80 W/(m²K). Angi"]
[null,"Oppnår energimerke D",{"$f":"IF(C15=\"\",\"Bruksareal mangler\",IF(C12=\"Leilighet\",'Energimerke D'!G25,'Energimerke D'!G24))","v":"Bruksareal mangler"},null,"vinduer/dører.",null,null,null,"%-andel som byttes ut."]
[]
[null,{"$f":"IF(C15=\"\",\"Bruksareal mangler\",IF(AND(C18>=C17,C20=\"Ja\"),\"Godkjent\",\"Ikke godkjent\"))","v":"Bruksareal mangler"},null,null,"       Tiltak 5",null,null,null,"Balansert ventilasjon"]
[null,null,null,null,null,null,null,null,"Balansert ventilasjon etableres eller eksisterende anlegg oppgraderes. Det skal"]
[null,null,null,null,null,null,null,null,"minimum oppnås 80 % varmegjenvinning og en SFP på maksimum 1,5 kW/(m3/s)."]
[null,null,null,null,null,null,null,null,"Gir ikke alltid energibesparelse, avhenger av førtilstand."]
[]
[null,null,null,null,null,"Tiltak 6",null,null,"Nattsenking"]
[null,null,null,null,"Utføres på",null,100,null,"Settpunkt romtemperatur for oppvarmingssystemet reduseres med minimum 2 °C"]
[null,null,null,null,"% av BRA.",null,null,null,"om natta, og % av BRA må settes iht. berørt areal. Gir ikke besparelse for boliger som "]
[null,null,null,null,null,null,null,null,"er bygd etter 1998."]
[]
[null,null,null,null,null,"Tiltak 7",null,null,"Energieffektiv belysningsutstyr"]
[null,null,null,null,"Utføres på",null,100,null,"Eksisterende belysning byttes med LED-belysning, alternativt annet energieffektiv"]
[null,null,null,null,"% av BRA.",null,null,null,"belysningsutstyr som i snitt trekker ≤ 1,95 W/m². Gjelder kun innfelte spotter i tak og"]
[null,null,null,null,null,null,null,null,"lysrørarmaturer, og % av BRA må settes iht. berørt areal."]
[]
[null,null,null,null,null,"Tiltak 8",null,null,"Solceller"]
[null,null,null,null,"Produksjon per",null,null,null,"Leverandør dokumenterer forventet elektrisitetsproduksjon for anlegget som skal"]
[null,null,null,null,"år i kWh",null,0,null,"installeres."]
[]
[null,null,null,null,null,"Tiltak 9",null,null,"Solfanger"]
[null,null,null,null,"Produksjon per",null,null,null,"Leverandør dokumenterer forventet termisk energiproduksjon for anlegget som skal"]
[null,null,null,null,"år i kWh",null,0,null,"installeres."]
[]
[null,null,null,null,"Tiltak 10",null,null,null,"Varmepumpe, luft til luft"]
[null,null,null,null,null,null,null,null,"Det installeres varmepumpe tilpasset nordisk vinterforhold,"]
[null,null,null,null,null,null,null,null,"plassert slik at størst mulig boareal nås av varmluften."]
[]
[null,null,null,null,null,"Tiltak 11",null,null,"Varmepumpe, øvrige (f.eks. luft til vann, vann til vann, avtrekksvarmepumpe)"]
[null,null,null,null,"Angi produksjon per",null,null,null,"Varmepumpeløsning er mer kompleks enn i tiltak 10. I dette tilfelle skal leverandør"]
[null,null,null,null,"år i kWh",null,0,null,"beregne forventet besparelse etter eventuelle etterisoleringstiltak er gjennomført."]

{"sheet":"Beregninger","index":1,"n_rows":39,"n_cols":50,"rows_kept":39,"cut":false,"hidden":true,"merged":[[12,30,12,43],[1,32,1,45]]}
[]
[null,"Graddagstall",null,{"$f":"VLOOKUP(Verktøy!C14,Input!B3:C424,2)","v":4009.6},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,"Småhus, besparelser i %"]
[null,"Småhus, kWh/m2 BRA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EIso vegg","EIso tak","EIiso gulv","Vinduer","Balansert ventilasjon",null,"Nattsenking","Energieffektiv belysningsutstyr",null,"Solceller","Solfanger","Varmepumpe, luft til luft","Varmepumpe, øvrige (f.eks. luft til vann, vann til vann, avtrekksvarmepumpe)",null,null,"Tiltak 1","Tiltak 2","Tiltak 3","Tiltak 4","Tiltak 5 OP","Tiltak 5 EL","Tiltak 6","Tiltak 7 OP","Tiltak 7 EL","Tiltak 8","Tiltak 9","Tiltak 10","Tiltak 11"]
[null,null,"Byggeår","Startpunkt","RO+Vent","Varmtvann","El","Besparelse %","SP kk","RO+Vent kk","Total etter","El etter tiltak","Varmtvann etter","RO etter","Romoppv etter T 1 - 6","Trekk samtidighet","Besp T1","Besp T2","Besp T3","Besp T4","Besp T5 OP","Besp T5 EL","Besp T6","Besp T7 OP","Besp T7 EL","Besp T8 EL","Besp T9 OP","Besp T10 OP","Besp T11 OP",null,null,true,true,false,false,false,{"$f":"AJ4","v":false},false,false,{"$f":"AM4","v":false},false,false,false,false,null,"Eldre",1,0,1950,{"$f":"IF(AND(Verktøy!$C$13>=AV4,Verktøy!$C$13<=AW4),AU4,\"\")","v":1}]
[null,"Eldre","< 1950",{"$f":"Input!F5","v":387},{"$f":"Input!G5","v":289.2},{"$f":"Input!H5","v":29.8},{"$f":"D5-E5-F5","v":68.000000000000014},{"$f":"100-(K5*100/I5)","v":40.981443428067436},{"$f":"D5-E5+J5","v":383.70569554711767},{"$f":"E5*(Beregninger!$D$2/Input!$C$254)","v":285.90569554711766},{"$f":"L5+M5+N5","v":226.45756299620297},{"$f":"G5-V5-Y5-Z5","v":68.000000000000014},{"$f":"IF(F5<0,0,F5)","v":29.8},{"$f":"O5-X5-AA5-AB5-AC5","v":128.65756299620296},{"$f":"IF(J5-SUM(Q5:U5)-W5+P5<0,0,J5-SUM(Q5:U5)-W5+P5)","v":128.65756299620296},{"$f":"AB26","v":0},{"$f":"IF($AF$4=TRUE,J5*(AF5/100)*(Verktøy!$G$6/100),0)","v":114.36227821884707},{"$f":"IF($AG$4=TRUE,J5*(AG5/100)*(Verktøy!$G$11/100),0)","v":42.885854332067645},{"$f":"IF($AH$4=TRUE,J$5*(AH5/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J5*(AI5/100)*(Verktøy!$G$19/100),0)","v":0},{"$f":"IF($AJ$4=TRUE,J5*AJ5/100,0)","v":0},{"$f":"IF($AK$4=TRUE,G5*AK5/100,0)","v":0},{"$f":"IF($AL$4=TRUE,(J5-SUM(Q5:U5))*AL5/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G5*AM5/100<-Y5,-Y5,G5*AM5/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G5*AN5/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},{"$f":"IF($AQ$4=TRUE,O5*0.3*0.8*(1-(1/2.5)),0)","v":0},{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15,0)","v":0},null,"Eldre",40,15,16,20,2,-5,6,-9,45,null,null,null,null,null,"TEK49",2,{"$f":"AW4+1","v":1951},1970,{"$f":"IF(AND(Verktøy!$C$13>=AV5,Verktøy!$C$13<=AW5),AU5,\"\")","v":""}]
[null,"TEK49","1951-1970",{"$f":"Input!F6","v":268},{"$f":"Input!G6","v":170.5},{"$f":"Input!H6","v":29.8},{"$f":"D6-E6-F6","v":67.7},{"$f":"100-(K6*100/I6)","v":25.975070367989389},{"$f":"D6-E6+J6","v":266.05781843286155},{"$f":"E6*(Beregninger!$D$2/Input!$C$254)","v":168.55781843286155},{"$f":"L6+M6+N6","v":196.94911287538832},67.7,{"$f":"IF(F6<0,0,F6)","v":29.8},99.449112875388309,{"$f":"IF(J6-SUM(Q6:U6)-W6+P6<0,0,J6-SUM(Q6:U6)-W6+P6)","v":99.449112875388309},0,{"$f":"IF($AF$4=TRUE,J6*(AF6/100)*(Verktøy!$G$6/100),0)","v":55.624080082844316},{"$f":"IF($AG$4=TRUE,J6*(AG6/100)*(Verktøy!$G$11/100),0)","v":13.484625474628924},{"$f":"IF($AH$4=TRUE,J$6*(AH6/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J6*(AI6/100)*(Verktøy!$G$19/100),0)","v":0},0,0,{"$f":"IF($AL$4=TRUE,(J6-SUM(Q6:U6))*AL6/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G6*AM6/100<-Y6,-Y6,G6*AM6/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G6*AN6/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},{"$f":"IF($AQ$4=TRUE,O6*0.3*0.8*(1-(1/2.5)),0)","v":0},{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15,0)","v":0},null,"TEK49",33,8,6,33,3,-5,6,-15,45,null,null,null,null,null,"TEK69",3,{"$f":"AW5+1","v":1971},1988,{"$f":"IF(AND(Verktøy!$C$13>=AV6,Verktøy!$C$13<=AW6),AU6,\"\")","v":""}]
[null,"TEK69","1971 - 1988",{"$f":"Input!F7","v":253.4},{"$f":"Input!G7","v":155.80000000000001},{"$f":"Input!H7","v":29.8},67.8,{"$f":"100-(K7*100/I7)","v":18.975770359460839},251.62526751812217,{"$f":"E7*(Beregninger!$D$2/Input!$C$254)","v":154.02526751812218},{"$f":"L7+M7+N7","v":203.8774345875043},67.8,29.8,106.2774345875043,106.2774345875043,0,{"$f":"IF($AF$4=TRUE,J7*(AF7/100)*(Verktøy!$G$6/100),0)","v":36.966064204349323},{"$f":"IF($AG$4=TRUE,J7*(AG7/100)*(Verktøy!$G$11/100),0)","v":10.781768726268554},{"$f":"IF($AH$4=TRUE,J$7*(AH7/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J7*(AI7/100)*(Verktøy!$G$19/100),0)","v":0},0,0,{"$f":"IF($AL$4=TRUE,(J7-SUM(Q7:U7))*AL7/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G7*AM7/100<-Y7,-Y7,G7*AM7/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G7*AN7/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},0,{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15,0)","v":0},null,"TEK69",24,7,7,33,3,-6,6,{"$f":"-39*(Beregninger!$D$2/Input!$C$254)","v":-38.555747324818775},56,null,null,null,null,null,"TEK87",4,1989,1998,{"$f":"IF(AND(Verktøy!$C$13>=AV7,Verktøy!$C$13<=AW7),AU7,\"\")","v":""}]
[null,"TEK87","1989 - 1998",{"$f":"Input!F8","v":208},{"$f":"Input!G8","v":139},{"$f":"Input!H8","v":29.8},39.200000000000003,11.983043166345865,206.41663790127717,{"$f":"E8*(Beregninger!$D$2/Input!$C$254)","v":137.41663790127717},181.68164307904726,39.200000000000003,29.8,112.68164307904728,112.68164307904728,0,{"$f":"IF($AF$4=TRUE,J8*(AF8/100)*(Verktøy!$G$6/100),0)","v":21.986662064204349},{"$f":"IF($AG$4=TRUE,J8*(AG8/100)*(Verktøy!$G$11/100),0)","v":2.7483327580255437},{"$f":"IF($AH$4=TRUE,J$8*(AH8/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J8*(AI8/100)*(Verktøy!$G$19/100),0)","v":0},0,0,{"$f":"IF($AL$4=TRUE,(J8-SUM(Q8:U8))*AL8/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G8*AM8/100<-Y8,-Y8,G8*AM8/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G8*AN8/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},0,{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15,0)","v":0},null,"TEK87",16,2,6,28,6,0,6,{"$f":"-8.7*(Beregninger!$D$2/Input!$C$254)","v":-8.6008974801518789},12,null,null,null,null,null,"TEK97",5,1999,2008,{"$f":"IF(AND(Verktøy!$C$13>=AV8,Verktøy!$C$13<=AW8),AU8,\"\")","v":""}]
[null,"TEK97","1999 - 2008",{"$f":"Input!F9","v":161.69999999999999},{"$f":"Input!G9","v":92.8},{"$f":"Input!H9","v":29.8},39.099999999999994,6.8531807706563939,160.64290645495339,{"$f":"E9*(Beregninger!$D$2/Input!$C$254)","v":91.742906454953385},149.63375768035897,39.099999999999994,29.8,80.733757680358977,80.733757680358977,0,{"$f":"IF($AF$4=TRUE,J9*(AF9/100)*(Verktøy!$G$6/100),0)","v":11.009148774594406},{"$f":"IF($AG$4=TRUE,J9*(AG9/100)*(Verktøy!$G$11/100),0)","v":0},{"$f":"IF($AH$4=TRUE,J$9*(AH9/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J9*(AI9/100)*(Verktøy!$G$19/100),0)","v":0},0,0,{"$f":"IF($AL$4=TRUE,(J9-SUM(Q9:U9))*AL9/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G9*AM9/100<-Y9,-Y9,G9*AM9/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G9*AN9/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},0,{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15,0)","v":0},null,"TEK97",12,0,3,19,9,0,0,{"$f":"-8.1*(Beregninger!$D$2/Input!$C$254)","v":-8.0077321366931287},12,null,null,null,null,null,"TEK07",6,2009,2011,{"$f":"IF(Verktøy!$C$13>=AV9,AU9,\"\")","v":""}]
[null,"TEK07","2009 -",{"$f":"Input!F10","v":132.6},{"$f":"Input!G10","v":61.1},{"$f":"Input!H10","v":29.8},41.7,0,131.90400414221608,{"$f":"E10*(Beregninger!$D$2/Input!$C$254)","v":60.404004142216081},131.90400414221608,41.7,29.8,60.404004142216081,60.404004142216081,0,{"$f":"IF($AF$4=TRUE,J10*(AF10/100)*(Verktøy!$G$6/100),0)","v":0},{"$f":"IF($AG$4=TRUE,J10*(AG10/100)*(Verktøy!$G$11/100),0)","v":0},{"$f":"IF($AH$4=TRUE,J$10*(AH10/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J10*(AI10/100)*(Verktøy!$G$19/100),0)","v":0},0,0,{"$f":"IF($AL$4=TRUE,(J10-SUM(Q10:U10))*AL10/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G10*AM10/100<-Y10,-Y10,G10*AM10/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G10*AN10/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},0,{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15,0)","v":0},null,"TEK07",0,0,5,23,6,7,0,{"$f":"-7.3*(Beregninger!$D$2/Input!$C$254)","v":-7.2168450120814622},12,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AX4:AX9)","v":1}]
[]
[null,null,null,null,null,null,null,{"$f":"INDEX(Beregninger!H5:H10,Beregninger!AX10)","v":40.981443428067436}]
[null,"Boligblokk, kWh/m2 BRA",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,"Boligblokk, besparelser i %"]
[null,null,"Byggeår","Startpunkt","RO+Vent","Varmtvann","El","Besparelse %","SP kk","RO+Vent kk","Total etter","El etter tiltak","Varmtvann etter","RO etter","Romoppv etter T 1 - 6","Trekk samtidighet","Besp T1","Besp T2","Besp T3","Besp T4","Besp T5 OP","Besp T5 EL","Besp T6","Besp T7 OP","Besp T7 EL","Besp T8 EL","Besp T9 OP","Besp T10 OP","Besp T11 OP",null,null,"Tiltak 1","Tiltak 2","Tiltak 3","Tiltak 4","Tiltak 5 OP","Tiltak 5 EL","Tiltak 6","Tiltak 7 OP","Tiltak 7 EL","Tiltak 8","Tiltak 9","Tiltak 10","Tiltak 11"]
[null,"Eldre","< 1950",{"$f":"Input!I5","v":297.3},{"$f":"Input!J5","v":199.7},{"$f":"Input!K5","v":29.8},{"$f":"D15-E15-F15","v":67.800000000000026},{"$f":"100-(K15*100/I15)","v":36.135763225878904},{"$f":"D15-E15+J15","v":295.02519848118743},{"$f":"E15*(Beregninger!$D$2/Input!$C$254)","v":197.42519848118741},{"$f":"L15+M15+N15","v":188.41559130134624},{"$f":"G15-V15-Y15-Z15","v":67.800000000000026},{"$f":"IF(F15<0,0,F15)","v":29.8},{"$f":"O15-X15-AA15-AB15-AC15","v":90.815591301346203},{"$f":"IF(J15-SUM(Q15:U15)-W15+P15<0,0,J15-SUM(Q15:U15)-W15+P15)","v":90.815591301346203},{"$f":"AB34","v":0},{"$f":"IF($AF$4=TRUE,J15*(AF15/100)*(Verktøy!$G$6/100),0)","v":82.918583362098715},{"$f":"IF($AG$4=TRUE,J15*(AG15/100)*(Verktøy!$G$11/100),0)","v":23.691023817742487},{"$f":"IF($AH$4=TRUE,J$15*(AH15/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J15*(AI16/100)*(Verktøy!$G$19/100),0)","v":0},{"$f":"IF($AJ$4=TRUE,J15*AJ15/100,0)","v":0},{"$f":"IF($AK$4=TRUE,G15*AK16/100,0)","v":0},{"$f":"IF($AL$4=TRUE,(J15-SUM(Q15:U15))*AL16/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G15*AM16/100<-Y15,-Y15,G15*AM16/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G15*AN15/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},{"$f":"IF($AQ$4=TRUE,O15*0.3*0.8*(1-(1/2.5)),0)","v":0},{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15,0)","v":0},null,"Eldre",42,12,12,20,6,-6,6,-12,45]
[null,"TEK49","1951-1970",{"$f":"Input!I6","v":245.1},{"$f":"Input!J6","v":147.80000000000001},{"$f":"Input!K6","v":29.8},{"$f":"D16-E16-F16","v":67.499999999999986},{"$f":"100-(K16*100/I16)","v":27.612577999887407},{"$f":"D16-E16+J16","v":243.4163962720055},{"$f":"E16*(Beregninger!$D$2/Input!$C$254)","v":146.11639627200552},{"$f":"L16+M16+N16","v":176.20285398688296},67.499999999999986,{"$f":"IF(F16<0,0,F16)","v":29.8},78.902853986882974,{"$f":"IF(J16-SUM(Q16:U16)-W16+P16<0,0,J16-SUM(Q16:U16)-W16+P16)","v":78.902853986882974},0,{"$f":"IF($AF$4=TRUE,J16*(AF16/100)*(Verktøy!$G$6/100),0)","v":58.446558508802212},{"$f":"IF($AG$4=TRUE,J16*(AG16/100)*(Verktøy!$G$11/100),0)","v":8.7669837763203304},{"$f":"IF($AH$4=TRUE,J$16*(AH16/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J16*(AI17/100)*(Verktøy!$G$19/100),0)","v":0},0,{"$f":"IF($AK$4=TRUE,G16*AK17/100,0)","v":0},{"$f":"IF($AL$4=TRUE,(J16-SUM(Q16:U16))*AL17/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G16*AM17/100<-Y16,-Y16,G16*AM17/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G16*AN16/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},0,{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15,0)","v":0},null,"TEK49",40,6,6,25,8,-6,6,-16,45]
[null,"TEK69","1971 - 1988",{"$f":"Input!I7","v":214.7},{"$f":"Input!J7","v":112.1},{"$f":"Input!K7","v":29.8},72.8,{"$f":"100-(K17*100/I17)","v":12.462352572415455},213.42305833620986,{"$f":"E17*(Beregninger!$D$2/Input!$C$254)","v":110.82305833620985},{"$f":"L17+M17+N17","v":186.82552433551948},72.8,29.8,84.225524335519481,84.225524335519481,0,{"$f":"IF($AF$4=TRUE,J17*(AF17/100)*(Verktøy!$G$6/100),0)","v":18.839919917155676},{"$f":"IF($AG$4=TRUE,J17*(AG17/100)*(Verktøy!$G$11/100),0)","v":7.7576140835346905},{"$f":"IF($AH$4=TRUE,J$17*(AH17/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J17*(AI18/100)*(Verktøy!$G$19/100),0)","v":0},0,{"$f":"IF($AK$4=TRUE,G17*AK18/100,0)","v":0},{"$f":"IF($AL$4=TRUE,(J17-SUM(Q17:U17))*AL18/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G17*AM18/100<-Y17,-Y17,G17*AM18/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G17*AN17/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},0,{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15,0)","v":0},null,"TEK69",17,7,6,31,16,0,6,{"$f":"-34*(Beregninger!$D$2/Input!$C$254)","v":-33.612702795995851},50]
[null,"TEK87","1989 - 1998",{"$f":"Input!I8","v":176.2},{"$f":"Input!J8","v":106.3},{"$f":"Input!K8","v":29.8},40.099999999999994,{"$f":"100-(K18*100/I18)","v":8.4076525293252473},174.98912668277526,{"$f":"E18*(Beregninger!$D$2/Input!$C$254)","v":105.08912668277527},160.27664894718674,40.099999999999994,29.8,90.376648947186737,90.376648947186737,0,{"$f":"IF($AF$4=TRUE,J18*(AF18/100)*(Verktøy!$G$6/100),0)","v":12.610695201933032},{"$f":"IF($AG$4=TRUE,J18*(AG18/100)*(Verktøy!$G$11/100),0)","v":2.1017825336555056},{"$f":"IF($AH$4=TRUE,J$18*(AH18/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J18*(AI19/100)*(Verktøy!$G$19/100),0)","v":0},0,{"$f":"IF($AK$4=TRUE,G18*AK19/100,0)","v":0},{"$f":"IF($AL$4=TRUE,(J18-SUM(Q18:U18))*AL19/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G18*AM19/100<-Y18,-Y18,G18*AM19/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G18*AN18/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},0,{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15,0)","v":0},null,"TEK87",12,2,3,25,22,1,5,{"$f":"-8.1*(Beregninger!$D$2/Input!$C$254)","v":-8.0077321366931287},12]
[null,"TEK97","1999 - 2008",{"$f":"Input!I9","v":146.1},{"$f":"Input!J9","v":76.599999999999994},{"$f":"Input!K9","v":29.8},39.700000000000003,8.8644852360420003,145.22744218156714,{"$f":"E19*(Beregninger!$D$2/Input!$C$254)","v":75.727442181567127},132.3537770107007,39.700000000000003,29.8,62.853777010700711,62.853777010700711,0,{"$f":"IF($AF$4=TRUE,J19*(AF19/100)*(Verktøy!$G$6/100),0)","v":12.873665170866413},{"$f":"IF($AG$4=TRUE,J19*(AG19/100)*(Verktøy!$G$11/100),0)","v":0},{"$f":"IF($AH$4=TRUE,J$19*(AH19/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J19*(AI20/100)*(Verktøy!$G$19/100),0)","v":0},0,{"$f":"IF($AK$4=TRUE,G19*AK20/100,0)","v":0},{"$f":"IF($AL$4=TRUE,(J19-SUM(Q19:U19))*AL20/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G19*AM20/100<-Y19,-Y19,G19*AM20/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G19*AN19/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},0,{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15,0)","v":0},null,"TEK97",17,0,2,12,27,0,0,{"$f":"-7.6*(Beregninger!$D$2/Input!$C$254)","v":-7.5134276838108374},12]
[null,"TEK07","2009 -",{"$f":"Input!I10","v":115.8},{"$f":"Input!J10","v":42.7},{"$f":"Input!K10","v":29.8},43.3,{"$f":"100-(K20*100/I20)","v":0},115.31360027614772,{"$f":"E20*(Beregninger!$D$2/Input!$C$254)","v":42.213600276147737},115.31360027614772,43.3,29.8,42.213600276147737,42.213600276147737,0,{"$f":"IF($AF$4=TRUE,J20*(AF20/100)*(Verktøy!$G$6/100),0)","v":0},{"$f":"IF($AG$4=TRUE,J20*(AG20/100)*(Verktøy!$G$11/100),0)","v":0},{"$f":"IF($AH$4=TRUE,J$20*(AH20/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J20*(AK21/100)*(Verktøy!$G$19/100),0)","v":0},0,{"$f":"IF($AK$4=TRUE,G20*AM21/100,0)","v":0},{"$f":"IF($AL$4=TRUE,(J20-SUM(Q20:U20))*AN21/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G20*AO21/100<-Y20,-Y20,G20*AO21/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G20*AN20/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},0,{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15,0)","v":0},null,"TEK07",0,0,4,20,11,9,0,{"$f":"-6.3*(Beregninger!$D$2/Input!$C$254)","v":-6.2282361063168787},11]
[]
[null,null,null,null,null,null,null,{"$f":"INDEX(H15:H20,AX10)","v":36.135763225878904}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mellomregning av reduksjon i besparelse ved gjennomføring av flere tiltak samtidig"]
[null,"1) Startpunkt er hentet fra NVE oppdraget (VV er tilpasset), eldre og TEK07 er laget med input i \"Historiske TEK\".",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tiltakskombinasjon","1+4","1+3+4","1+2+4","1+6","2+6","3+6","4+6","1+4+6","1+2+4+6","1+3+4+6","1+2+3+4+6","AKTUELL"]
[null,"2) Graddagstall er fra 2020 og hentet fra eklima",null,null,null,null,null,null,null,null,null,null,null,null,"Småhus","Byggeår",3.5,2.7,0.9,1.9,0.6,0.4,1.1000000000000001,6.1,5.4,5.3,4.9000000000000004,null,null,null,null,null,"1) I første fanen hukes det av for de forskjellige tiltakene. Er det huket av for et tiltak vil verdiene i AF4:AR4 bytte til TRUE som er en av faktorene for å hente ut riktig besparelse."]
[null,"3) Besparelser er hentet fra NVE arket, eller simulert selv",null,null,null,null,null,null,null,null,null,null,null,null,"Eldre","< 1950",{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AG$4=FALSE,$AH$4=FALSE,$AL$4=FALSE),(Q5+T5)*($Q$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=FALSE,$AH$4=TRUE,$AI$4=TRUE,$AL$4=FALSE),(Q5+T5+S5)*($R$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=TRUE,$AH$4=FALSE,$AI$4=TRUE,$AL$4=FALSE),(Q5+T5+R5)*($S$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=FALSE,$AH$4=FALSE,$AI$4=FALSE,$AL$4=TRUE),(Q5+W5)*($T$25/100),0)","v":0},{"$f":"IF(AND($AF$4=FALSE,$AG$4=TRUE,$AH$4=FALSE,$AI$4=FALSE,$AL$4=TRUE),(R5+W5)*($U$25/100),0)","v":0},{"$f":"IF(AND($AF$4=FALSE,$AG$4=FALSE,$AH$4=TRUE,$AI$4=FALSE,$AL$4=TRUE),(S5+W5)*($V$25/100),0)","v":0},{"$f":"IF(AND($AF$4=FALSE,$AG$4=FALSE,$AH$4=FALSE,$AI$4=TRUE,$AL$4=TRUE),(T5+W5)*($W$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=FALSE,$AH$4=FALSE,$AI$4=TRUE,$AL$4=TRUE),(Q5+T5+W5)*($X$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=TRUE,$AH$4=FALSE,$AI$4=TRUE,$AL$4=TRUE),(Q5+R5+T5+W5)*($Y$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=FALSE,$AH$4=TRUE,$AI$4=TRUE,$AL$4=TRUE),(Q5+S5+T5+W5)*($Z$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=TRUE,$AH$4=TRUE,$AI$4=TRUE,$AL$4=TRUE),(Q5+R5+S5+T5+W5)*($AA$25/100),0)","v":0},{"$f":"SUM(Q26:AA26)","v":0},null,null,null,null,"2) Formlene i Q5:AC20 sjekker om det er huket av for tiltaket gjennom TRUE/FALSE i rekke 4 og henter riktig verdi ut av tabellen."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEK49","1951-1970",0,{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AH$4=TRUE,$AG$4=FALSE,$AL$4=FALSE),(Q6+T6+S6)*($R$25/100),0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q27:AA27)","v":0},null,null,null,null,"3) Står det FALSE i tiltaket er blir verdien automatisk satt til 0."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEK69","1971 - 1988",0,{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AH$4=TRUE,$AG$4=FALSE,$AL$4=FALSE),(Q7+T7+S7)*($R$25/100),0)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,"4) I første fanen henter feltet som angir besparelsen summen fra H12 eller H22, avhengig av om det er valgt småhus eller boligblokk."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEK87","1989 - 1998",0,{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AH$4=TRUE,$AG$4=FALSE,$AL$4=FALSE),(Q8+T8+S8)*($R$25/100),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEK97","1999 - 2008",0,{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AH$4=TRUE,$AG$4=FALSE,$AL$4=FALSE),(Q9+T9+S9)*($R$25/100),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEK07","2009 -",0,{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AH$4=TRUE,$AG$4=FALSE,$AL$4=FALSE),(Q10+T10+S10)*($R$25/100),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Boligblokk","Byggeår",0.7,0.1,0,1.4,0.4,0.3,1.3,3.3,2.7,3,2.2999999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eldre","< 1950",{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AG$4=FALSE,$AH$4=FALSE,$AL$4=FALSE),(Q15+T15)*($Q$33/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AH$4=TRUE,$AG$4=FALSE,$AL$4=FALSE),(Q15+T15+S15)*($R$33/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=TRUE,$AH$4=FALSE,$AI$4=TRUE,$AL$4=FALSE),(Q15+T15+R15)*($S$33/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=FALSE,$AH$4=FALSE,$AI$4=FALSE,$AL$4=TRUE),(Q15+W15)*($T$33/100),0)","v":0},{"$f":"IF(AND($AF$4=FALSE,$AG$4=TRUE,$AH$4=FALSE,$AI$4=FALSE,$AL$4=TRUE),(R15+W15)*($U$33/100),0)","v":0},{"$f":"IF(AND($AF$4=FALSE,$AG$4=FALSE,$AH$4=TRUE,$AI$4=FALSE,$AL$4=TRUE),(S15+W15)*($V$33/100),0)","v":0},{"$f":"IF(AND($AF$4=FALSE,$AG$4=FALSE,$AH$4=FALSE,$AI$4=TRUE,$AL$4=TRUE),(T15+W15)*($W$33/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=FALSE,$AH$4=FALSE,$AI$4=TRUE,$AL$4=TRUE),(Q15+T15+W15)*($X$33/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=TRUE,$AH$4=FALSE,$AI$4=TRUE,$AL$4=TRUE),(Q15+R15+T15+W15)*($Y$33/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=FALSE,$AH$4=TRUE,$AI$4=TRUE,$AL$4=TRUE),(Q15+S15+T15+W15)*($Z$33/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=TRUE,$AH$4=TRUE,$AI$4=TRUE,$AL$4=TRUE),(Q15+R15+S15+T15+W15)*($AA$33/100),0)","v":0},{"$f":"SUM(Q34:AA34)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEK49","1951-1970",{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AG$4=FALSE,$AH$4=FALSE,$AL$4=FALSE),(Q16+T16)*($Q$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AH$4=TRUE,$AG$4=FALSE,$AL$4=FALSE),(Q16+T16+S16)*($R$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=TRUE,$AH$4=FALSE,$AI$4=TRUE,$AL$4=FALSE),(Q16+T16+R16)*($S$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=FALSE,$AH$4=FALSE,$AI$4=FALSE,$AL$4=TRUE),(Q16+W16)*($T$25/100),0)","v":0},{"$f":"IF(AND($AF$4=FALSE,$AG$4=TRUE,$AH$4=FALSE,$AI$4=FALSE,$AL$4=TRUE),(R16+W16)*($U$25/100),0)","v":0},{"$f":"IF(AND($AF$4=FALSE,$AG$4=FALSE,$AH$4=TRUE,$AI$4=FALSE,$AL$4=TRUE),(S16+W16)*($V$25/100),0)","v":0},{"$f":"IF(AND($AF$4=FALSE,$AG$4=FALSE,$AH$4=FALSE,$AI$4=TRUE,$AL$4=TRUE),(T16+W16)*($W$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=FALSE,$AH$4=FALSE,$AI$4=TRUE,$AL$4=TRUE),(Q16+T16+W16)*($X$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=TRUE,$AH$4=FALSE,$AI$4=TRUE,$AL$4=TRUE),(Q16+R16+T16+W16)*($Y$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=FALSE,$AH$4=TRUE,$AI$4=TRUE,$AL$4=TRUE),(Q16+S16+T16+W16)*($Z$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=TRUE,$AH$4=TRUE,$AI$4=TRUE,$AL$4=TRUE),(Q16+R16+S16+T16+W16)*($AA$25/100),0)","v":0},{"$f":"SUM(Q35:AA35)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEK69","1971 - 1988",{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AG$4=FALSE,$AH$4=FALSE,$AL$4=FALSE),(Q17+T17)*($Q$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AH$4=TRUE,$AG$4=FALSE,$AL$4=FALSE),(Q17+T17+S17)*($R$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=TRUE,$AH$4=FALSE,$AI$4=TRUE,$AL$4=FALSE),(Q17+T17+R17)*($S$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=FALSE,$AH$4=FALSE,$AI$4=FALSE,$AL$4=TRUE),(Q17+W17)*($T$25/100),0)","v":0},{"$f":"IF(AND($AF$4=FALSE,$AG$4=TRUE,$AH$4=FALSE,$AI$4=FALSE,$AL$4=TRUE),(R17+W17)*($U$25/100),0)","v":0},{"$f":"IF(AND($AF$4=FALSE,$AG$4=FALSE,$AH$4=TRUE,$AI$4=FALSE,$AL$4=TRUE),(S17+W17)*($V$25/100),0)","v":0},{"$f":"IF(AND($AF$4=FALSE,$AG$4=FALSE,$AH$4=FALSE,$AI$4=TRUE,$AL$4=TRUE),(T17+W17)*($W$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=FALSE,$AH$4=FALSE,$AI$4=TRUE,$AL$4=TRUE),(Q17+T17+W17)*($X$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=TRUE,$AH$4=FALSE,$AI$4=TRUE,$AL$4=TRUE),(Q17+R17+T17+W17)*($Y$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=FALSE,$AH$4=TRUE,$AI$4=TRUE,$AL$4=TRUE),(Q17+S17+T17+W17)*($Z$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=TRUE,$AH$4=TRUE,$AI$4=TRUE,$AL$4=TRUE),(Q17+R17+S17+T17+W17)*($AA$25/100),0)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEK87","1989 - 1998",{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AG$4=FALSE,$AH$4=FALSE,$AL$4=FALSE),(Q18+T18)*($Q$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AH$4=TRUE,$AG$4=FALSE,$AL$4=FALSE),(Q18+T18+S18)*($R$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=TRUE,$AH$4=FALSE,$AI$4=TRUE,$AL$4=FALSE),(Q18+T18+R18)*($S$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=FALSE,$AH$4=FALSE,$AI$4=FALSE,$AL$4=TRUE),(Q18+W18)*($T$25/100),0)","v":0},{"$f":"IF(AND($AF$4=FALSE,$AG$4=TRUE,$AH$4=FALSE,$AI$4=FALSE,$AL$4=TRUE),(R18+W18)*($U$25/100),0)","v":0},{"$f":"IF(AND($AF$4=FALSE,$AG$4=FALSE,$AH$4=TRUE,$AI$4=FALSE,$AL$4=TRUE),(S18+W18)*($V$25/100),0)","v":0},{"$f":"IF(AND($AF$4=FALSE,$AG$4=FALSE,$AH$4=FALSE,$AI$4=TRUE,$AL$4=TRUE),(T18+W18)*($W$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=FALSE,$AH$4=FALSE,$AI$4=TRUE,$AL$4=TRUE),(Q18+T18+W18)*($X$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=TRUE,$AH$4=FALSE,$AI$4=TRUE,$AL$4=TRUE),(Q18+R18+T18+W18)*($Y$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=FALSE,$AH$4=TRUE,$AI$4=TRUE,$AL$4=TRUE),(Q18+S18+T18+W18)*($Z$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=TRUE,$AH$4=TRUE,$AI$4=TRUE,$AL$4=TRUE),(Q18+R18+S18+T18+W18)*($AA$25/100),0)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEK97","1999 - 2008",{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AG$4=FALSE,$AH$4=FALSE,$AL$4=FALSE),(Q19+T19)*($Q$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AH$4=TRUE,$AG$4=FALSE,$AL$4=FALSE),(Q19+T19+S19)*($R$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=TRUE,$AH$4=FALSE,$AI$4=TRUE,$AL$4=FALSE),(Q19+T19+R19)*($S$25/100),0)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEK07","2009 -",{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AG$4=FALSE,$AH$4=FALSE,$AL$4=FALSE),(Q20+T20)*($Q$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AH$4=TRUE,$AG$4=FALSE,$AL$4=FALSE),(Q20+T20+S20)*($R$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=TRUE,$AH$4=FALSE,$AI$4=TRUE,$AL$4=FALSE),(Q20+T20+R20)*($S$25/100),0)","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"Energimerke D","index":2,"n_rows":39,"n_cols":50,"rows_kept":39,"cut":false,"hidden":true,"merged":[[1,32,1,45],[12,30,12,43],[23,1,23,4],[24,1,24,4]]}
[]
[null,"Graddagstall",null,{"$f":"Input!$C$254","v":4055.8},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,"Småhus, besparelser i %"]
[null,"Småhus, kWh/m2 BRA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EIso vegg","EIso tak","EIiso gulv","Vinduer","Balansert ventilasjon",null,"Nattsenking","Energieffektiv belysningsutstyr",null,"Solceller","Solfanger","Varmepumpe, luft til luft","Varmepumpe, øvrige (f.eks. luft til vann, vann til vann, avtrekksvarmepumpe)",null,null,"Tiltak 1","Tiltak 2","Tiltak 3","Tiltak 4","Tiltak 5 OP","Tiltak 5 EL","Tiltak 6","Tiltak 7 OP","Tiltak 7 EL","Tiltak 8","Tiltak 9","Tiltak 10","Tiltak 11"]
[null,null,"Byggeår","Startpunkt","RO+Vent","Varmtvann","El","Besparelse %","SP kk","RO+Vent kk","Total etter","El etter tiltak","Varmtvann etter","RO etter","Romoppv etter T 1 - 6","Trekk samtidighet","Besp T1","Besp T2","Besp T3","Besp T4","Besp T5 OP","Besp T5 EL","Besp T6","Besp T7 OP","Besp T7 EL","Besp T8 EL","Besp T9 OP","Besp T10 OP","Besp T11 OP",null,null,{"$f":"Beregninger!AF4","v":true},{"$f":"Beregninger!AG4","v":true},{"$f":"Beregninger!AH4","v":false},{"$f":"Beregninger!AI4","v":false},{"$f":"Beregninger!AJ4","v":false},{"$f":"Beregninger!AK4","v":false},{"$f":"Beregninger!AL4","v":false},{"$f":"Beregninger!AM4","v":false},{"$f":"Beregninger!AN4","v":false},{"$f":"Beregninger!AO4","v":false},{"$f":"Beregninger!AP4","v":false},{"$f":"Beregninger!AQ4","v":false},{"$f":"Beregninger!AR4","v":false},null,"Eldre",1,0,1950,{"$f":"IF(AND(Verktøy!$C$13>=AV4,Verktøy!$C$13<=AW4),AU4,\"\")","v":1}]
[null,"Eldre","< 1950",{"$f":"Input!F15","v":339.6},{"$f":"Input!G15","v":279.5},{"$f":"Input!H15","v":29.8},{"$f":"D5-E5-F5","v":30.300000000000022},{"$f":"100-(K5*100/I5)","v":45.266489988221437},{"$f":"D5-E5+J5","v":339.6},{"$f":"E5*('Energimerke D'!$D$2/Input!$C$254)","v":279.5},{"$f":"L5+M5+N5","v":185.875},{"$f":"G5-V5-Y5-Z5","v":30.300000000000022},{"$f":"IF(F5<0,0,F5)","v":29.8},{"$f":"O5-X5-AA5-AB5-AC5","v":125.77499999999998},{"$f":"IF(J5-SUM(Q5:U5)-W5+P5<0,0,J5-SUM(Q5:U5)-W5+P5)","v":125.77499999999998},{"$f":"AB26","v":0},{"$f":"IF($AF$4=TRUE,J5*(AF5/100)*(Verktøy!$G$6/100),0)","v":111.80000000000001},{"$f":"IF($AG$4=TRUE,J5*(AG5/100)*(Verktøy!$G$11/100),0)","v":41.924999999999997},{"$f":"IF($AH$4=TRUE,J$5*(AH5/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J5*(AI5/100)*(Verktøy!$G$19/100),0)","v":0},{"$f":"IF($AJ$4=TRUE,J5*AJ5/100,0)","v":0},{"$f":"IF($AK$4=TRUE,G5*AK5/100,0)","v":0},{"$f":"IF($AL$4=TRUE,(J5-SUM(Q5:U5))*AL5/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G5*AM5/100<-Y5,-Y5,G5*AM5/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G5*AN5/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},{"$f":"IF($AQ$4=TRUE,O5*0.3*0.8*(1-(1/2.5)),0)","v":0},{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15*Input!$C$254/Beregninger!$D$2,0)","v":0},null,"Eldre",40,15,16,20,2,-5,0,0,0,null,null,null,null,null,"TEK49",2,{"$f":"AW4+1","v":1951},1970,{"$f":"IF(AND(Verktøy!$C$13>=AV5,Verktøy!$C$13<=AW5),AU5,\"\")","v":""}]
[null,"TEK49","1951-1970",{"$f":"Input!F16","v":233.2},{"$f":"Input!G16","v":173.2},{"$f":"Input!H16","v":29.8},{"$f":"D6-E6-F6","v":30.2},{"$f":"100-(K6*100/I6)","v":30.451114922813034},{"$f":"D6-E6+J6","v":233.2},{"$f":"E6*('Energimerke D'!$D$2/Input!$C$254)","v":173.2},{"$f":"L6+M6+N6","v":162.18799999999999},30.2,{"$f":"IF(F6<0,0,F6)","v":29.8},102.18799999999999,{"$f":"IF(J6-SUM(Q6:U6)-W6+P6<0,0,J6-SUM(Q6:U6)-W6+P6)","v":102.18799999999999},0,{"$f":"IF($AF$4=TRUE,J6*(AF6/100)*(Verktøy!$G$6/100),0)","v":57.155999999999999},{"$f":"IF($AG$4=TRUE,J6*(AG6/100)*(Verktøy!$G$11/100),0)","v":13.856},{"$f":"IF($AH$4=TRUE,J$6*(AH6/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J6*(AI6/100)*(Verktøy!$G$19/100),0)","v":0},0,0,{"$f":"IF($AL$4=TRUE,(J6-SUM(Q6:U6))*AL6/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G6*AM6/100<-Y6,-Y6,G6*AM6/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G6*AN6/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},0,{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15*Input!$C$254/Beregninger!$D$2,0)","v":0},null,"TEK49",33,8,6,33,3,-5,0,0,0,null,null,null,null,null,"TEK69",3,{"$f":"AW5+1","v":1971},1988,{"$f":"IF(AND(Verktøy!$C$13>=AV6,Verktøy!$C$13<=AW6),AU6,\"\")","v":""}]
[null,"TEK69","1971 - 1988",{"$f":"Input!F17","v":220},{"$f":"Input!G17","v":160},{"$f":"Input!H17","v":29.8},30.2,{"$f":"100-(K7*100/I7)","v":22.545454545454547},220,{"$f":"E7*('Energimerke D'!$D$2/Input!$C$254)","v":160},{"$f":"L7+M7+N7","v":170.4},30.2,29.8,110.4,110.4,0,{"$f":"IF($AF$4=TRUE,J7*(AF7/100)*(Verktøy!$G$6/100),0)","v":38.4},{"$f":"IF($AG$4=TRUE,J7*(AG7/100)*(Verktøy!$G$11/100),0)","v":11.200000000000001},{"$f":"IF($AH$4=TRUE,J$7*(AH7/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J7*(AI7/100)*(Verktøy!$G$19/100),0)","v":0},0,0,{"$f":"IF($AL$4=TRUE,(J7-SUM(Q7:U7))*AL7/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G7*AM7/100<-Y7,-Y7,G7*AM7/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G7*AN7/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},0,{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15*Input!$C$254/Beregninger!$D$2,0)","v":0},null,"TEK69",24,7,7,33,3,-6,0,0,0,null,null,null,null,null,"TEK87",4,1989,1998,{"$f":"IF(AND(Verktøy!$C$13>=AV7,Verktøy!$C$13<=AW7),AU7,\"\")","v":""}]
[null,"TEK87","1989 - 1998",{"$f":"Input!F18","v":189.3},{"$f":"Input!G18","v":125.2},{"$f":"Input!H18","v":29.8},34.300000000000011,11.904912836767039,189.3,{"$f":"E8*('Energimerke D'!$D$2/Input!$C$254)","v":125.2},166.76400000000001,34.300000000000011,29.8,102.664,102.664,0,{"$f":"IF($AF$4=TRUE,J8*(AF8/100)*(Verktøy!$G$6/100),0)","v":20.032},{"$f":"IF($AG$4=TRUE,J8*(AG8/100)*(Verktøy!$G$11/100),0)","v":2.504},{"$f":"IF($AH$4=TRUE,J$8*(AH8/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J8*(AI8/100)*(Verktøy!$G$19/100),0)","v":0},0,0,{"$f":"IF($AL$4=TRUE,(J8-SUM(Q8:U8))*AL8/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G8*AM8/100<-Y8,-Y8,G8*AM8/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G8*AN8/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},0,{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15*Input!$C$254/Beregninger!$D$2,0)","v":0},null,"TEK87",16,2,6,28,6,0,0,0,0,null,null,null,null,null,"TEK97",5,1999,2008,{"$f":"IF(AND(Verktøy!$C$13>=AV8,Verktøy!$C$13<=AW8),AU8,\"\")","v":""}]
[null,"TEK97","1999 - 2008",{"$f":"Input!F19","v":153.1},{"$f":"Input!G19","v":89.1},{"$f":"Input!H19","v":29.8},34.200000000000003,6.9836708033964641,153.1,{"$f":"E9*('Energimerke D'!$D$2/Input!$C$254)","v":89.1},142.40800000000002,34.200000000000003,29.8,78.408000000000001,78.408000000000001,0,{"$f":"IF($AF$4=TRUE,J9*(AF9/100)*(Verktøy!$G$6/100),0)","v":10.691999999999998},{"$f":"IF($AG$4=TRUE,J9*(AG9/100)*(Verktøy!$G$11/100),0)","v":0},{"$f":"IF($AH$4=TRUE,J$9*(AH9/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J9*(AI9/100)*(Verktøy!$G$19/100),0)","v":0},0,0,{"$f":"IF($AL$4=TRUE,(J9-SUM(Q9:U9))*AL9/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G9*AM9/100<-Y9,-Y9,G9*AM9/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G9*AN9/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},0,{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15*Input!$C$254/Beregninger!$D$2,0)","v":0},null,"TEK97",12,0,3,19,9,0,0,0,0,null,null,null,null,null,"TEK07",6,2009,2011,{"$f":"IF(Verktøy!$C$13>=AV9,AU9,\"\")","v":""}]
[null,"TEK07","2009 -",{"$f":"Input!F20","v":125.8},{"$f":"Input!G20","v":59.1},{"$f":"Input!H20","v":29.8},36.899999999999991,0,125.79999999999998,{"$f":"E10*('Energimerke D'!$D$2/Input!$C$254)","v":59.1},125.79999999999998,36.899999999999991,29.8,59.1,59.1,0,{"$f":"IF($AF$4=TRUE,J10*(AF10/100)*(Verktøy!$G$6/100),0)","v":0},{"$f":"IF($AG$4=TRUE,J10*(AG10/100)*(Verktøy!$G$11/100),0)","v":0},{"$f":"IF($AH$4=TRUE,J$10*(AH10/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J10*(AI10/100)*(Verktøy!$G$19/100),0)","v":0},0,0,{"$f":"IF($AL$4=TRUE,(J10-SUM(Q10:U10))*AL10/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G10*AM10/100<-Y10,-Y10,G10*AM10/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G10*AN10/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},0,{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15*Input!$C$254/Beregninger!$D$2,0)","v":0},null,"TEK07",0,0,5,23,6,7,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AX4:AX9)","v":1}]
[]
[null,null,null,null,null,null,null,{"$f":"INDEX('Energimerke D'!H5:H10,'Energimerke D'!AX10)","v":45.266489988221437},null,"kWh/m2, år",{"$f":"INDEX('Energimerke D'!K5:K10,'Energimerke D'!AX10)","v":185.875}]
[null,"Boligblokk, kWh/m2 BRA",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,"Boligblokk, besparelser i %"]
[null,null,"Byggeår","Startpunkt","RO+Vent","Varmtvann","El","Besparelse %","SP kk","RO+Vent kk","Total etter","El etter tiltak","Varmtvann etter","RO etter","Romoppv etter T 1 - 6","Trekk samtidighet","Besp T1","Besp T2","Besp T3","Besp T4","Besp T5 OP","Besp T5 EL","Besp T6","Besp T7 OP","Besp T7 EL","Besp T8 EL","Besp T9 OP","Besp T10 OP","Besp T11 OP",null,null,"Tiltak 1","Tiltak 2","Tiltak 3","Tiltak 4","Tiltak 5 OP","Tiltak 5 EL","Tiltak 6","Tiltak 7 OP","Tiltak 7 EL","Tiltak 8","Tiltak 9","Tiltak 10","Tiltak 11"]
[null,"Eldre","< 1950",{"$f":"Input!I15","v":259.10000000000002},{"$f":"Input!J15","v":199.2},{"$f":"Input!K15","v":29.8},{"$f":"D15-E15-F15","v":30.100000000000033},{"$f":"100-(K15*100/I15)","v":41.516016981860275},{"$f":"D15-E15+J15","v":259.10000000000002},{"$f":"E15*('Energimerke D'!$D$2/Input!$C$254)","v":199.2},{"$f":"L15+M15+N15","v":151.53200000000004},{"$f":"G15-V15-Y15-Z15","v":30.100000000000033},{"$f":"IF(F15<0,0,F15)","v":29.8},{"$f":"O15-X15-AA15-AB15-AC15","v":91.632000000000005},{"$f":"IF(J15-SUM(Q15:U15)-W15+P15<0,0,J15-SUM(Q15:U15)-W15+P15)","v":91.632000000000005},{"$f":"AB34","v":0},{"$f":"IF($AF$4=TRUE,J15*(AF15/100)*(Verktøy!$G$6/100),0)","v":83.663999999999987},{"$f":"IF($AG$4=TRUE,J15*(AG15/100)*(Verktøy!$G$11/100),0)","v":23.903999999999996},{"$f":"IF($AH$4=TRUE,J$15*(AH15/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J15*(AI16/100)*(Verktøy!$G$19/100),0)","v":0},{"$f":"IF($AJ$4=TRUE,J15*AJ15/100,0)","v":0},{"$f":"IF($AK$4=TRUE,G15*AK16/100,0)","v":0},{"$f":"IF($AL$4=TRUE,(J15-SUM(Q15:U15))*AL16/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G15*AM16/100<-Y15,-Y15,G15*AM16/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G15*AN15/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},{"$f":"IF($AQ$4=TRUE,O15*0.3*0.8*(1-(1/2.5)),0)","v":0},{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15*Input!$C$254/Beregninger!$D$2,0)","v":0},null,"Eldre",42,12,12,20,6,-6,0,0,0]
[null,"TEK49","1951-1970",{"$f":"Input!I16","v":212.3},{"$f":"Input!J16","v":152.6},{"$f":"Input!K16","v":29.8},{"$f":"D16-E16-F16","v":29.900000000000016},{"$f":"100-(K16*100/I16)","v":33.064531323598672},{"$f":"D16-E16+J16","v":212.3},{"$f":"E16*('Energimerke D'!$D$2/Input!$C$254)","v":152.6},{"$f":"L16+M16+N16","v":142.10400000000001},29.900000000000016,{"$f":"IF(F16<0,0,F16)","v":29.8},82.403999999999996,{"$f":"IF(J16-SUM(Q16:U16)-W16+P16<0,0,J16-SUM(Q16:U16)-W16+P16)","v":82.403999999999996},0,{"$f":"IF($AF$4=TRUE,J16*(AF16/100)*(Verktøy!$G$6/100),0)","v":61.04},{"$f":"IF($AG$4=TRUE,J16*(AG16/100)*(Verktøy!$G$11/100),0)","v":9.1559999999999988},{"$f":"IF($AH$4=TRUE,J$16*(AH16/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J16*(AI17/100)*(Verktøy!$G$19/100),0)","v":0},0,{"$f":"IF($AK$4=TRUE,G16*AK17/100,0)","v":0},{"$f":"IF($AL$4=TRUE,(J16-SUM(Q16:U16))*AL17/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G16*AM17/100<-Y16,-Y16,G16*AM17/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G16*AN16/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},0,{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15*Input!$C$254/Beregninger!$D$2,0)","v":0},null,"TEK49",40,6,6,25,8,-6,0,0,0]
[null,"TEK69","1971 - 1988",{"$f":"Input!I17","v":185.2},{"$f":"Input!J17","v":120.2},{"$f":"Input!K17","v":29.8},35.199999999999989,{"$f":"100-(K17*100/I17)","v":15.576673866090729},185.2,{"$f":"E17*('Energimerke D'!$D$2/Input!$C$254)","v":120.2},{"$f":"L17+M17+N17","v":156.35199999999998},35.199999999999989,29.8,91.352000000000004,91.352000000000004,0,{"$f":"IF($AF$4=TRUE,J17*(AF17/100)*(Verktøy!$G$6/100),0)","v":20.434000000000001},{"$f":"IF($AG$4=TRUE,J17*(AG17/100)*(Verktøy!$G$11/100),0)","v":8.4140000000000015},{"$f":"IF($AH$4=TRUE,J$17*(AH17/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J17*(AI18/100)*(Verktøy!$G$19/100),0)","v":0},0,{"$f":"IF($AK$4=TRUE,G17*AK18/100,0)","v":0},{"$f":"IF($AL$4=TRUE,(J17-SUM(Q17:U17))*AL18/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G17*AM18/100<-Y17,-Y17,G17*AM18/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G17*AN17/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},0,{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15*Input!$C$254/Beregninger!$D$2,0)","v":0},null,"TEK69",17,7,6,31,16,0,0,0,0]
[null,"TEK87","1989 - 1998",{"$f":"Input!I18","v":161},{"$f":"Input!J18","v":96.2},{"$f":"Input!K18","v":29.8},35,{"$f":"100-(K18*100/I18)","v":8.3652173913043555},161,{"$f":"E18*('Energimerke D'!$D$2/Input!$C$254)","v":96.2},147.53199999999998,35,29.8,82.731999999999999,82.731999999999999,0,{"$f":"IF($AF$4=TRUE,J18*(AF18/100)*(Verktøy!$G$6/100),0)","v":11.544},{"$f":"IF($AG$4=TRUE,J18*(AG18/100)*(Verktøy!$G$11/100),0)","v":1.9240000000000002},{"$f":"IF($AH$4=TRUE,J$18*(AH18/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J18*(AI19/100)*(Verktøy!$G$19/100),0)","v":0},0,{"$f":"IF($AK$4=TRUE,G18*AK19/100,0)","v":0},{"$f":"IF($AL$4=TRUE,(J18-SUM(Q18:U18))*AL19/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G18*AM19/100<-Y18,-Y18,G18*AM19/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G18*AN18/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},0,{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15*Input!$C$254/Beregninger!$D$2,0)","v":0},null,"TEK87",12,2,3,25,22,1,0,0,0]
[null,"TEK97","1999 - 2008",{"$f":"Input!I19","v":138.4},{"$f":"Input!J19","v":73.7},{"$f":"Input!K19","v":29.8},34.900000000000006,9.0527456647398878,138.4,{"$f":"E19*('Energimerke D'!$D$2/Input!$C$254)","v":73.7},125.87100000000001,34.900000000000006,29.8,61.170999999999999,61.170999999999999,0,{"$f":"IF($AF$4=TRUE,J19*(AF19/100)*(Verktøy!$G$6/100),0)","v":12.529000000000002},{"$f":"IF($AG$4=TRUE,J19*(AG19/100)*(Verktøy!$G$11/100),0)","v":0},{"$f":"IF($AH$4=TRUE,J$19*(AH19/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J19*(AI20/100)*(Verktøy!$G$19/100),0)","v":0},0,{"$f":"IF($AK$4=TRUE,G19*AK20/100,0)","v":0},{"$f":"IF($AL$4=TRUE,(J19-SUM(Q19:U19))*AL20/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G19*AM20/100<-Y19,-Y19,G19*AM20/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G19*AN19/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},0,{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15*Input!$C$254/Beregninger!$D$2,0)","v":0},null,"TEK97",17,0,2,12,27,0,0,0,0]
[null,"TEK07","2009 -",{"$f":"Input!I20","v":110.1},{"$f":"Input!J20","v":41.9},{"$f":"Input!K20","v":29.8},38.399999999999991,{"$f":"100-(K20*100/I20)","v":0},110.1,{"$f":"E20*('Energimerke D'!$D$2/Input!$C$254)","v":41.9},110.1,38.399999999999991,29.8,41.9,41.9,0,{"$f":"IF($AF$4=TRUE,J20*(AF20/100)*(Verktøy!$G$6/100),0)","v":0},{"$f":"IF($AG$4=TRUE,J20*(AG20/100)*(Verktøy!$G$11/100),0)","v":0},{"$f":"IF($AH$4=TRUE,J$20*(AH20/100)*(Verktøy!$G$15/100),0)","v":0},{"$f":"IF($AI$4=TRUE,J20*(AK21/100)*(Verktøy!$G$19/100),0)","v":0},0,{"$f":"IF($AK$4=TRUE,G20*AM21/100,0)","v":0},{"$f":"IF($AL$4=TRUE,(J20-SUM(Q20:U20))*AN21/100*(Verktøy!$G$28/100),0)","v":0},{"$f":"IF($AM$4=TRUE,IF(G20*AO21/100<-Y20,-Y20,G20*AO21/100)*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AN$4=TRUE,G20*AN20/100*(Verktøy!$G$33/100),0)","v":0},{"$f":"IF($AO$4=TRUE,Verktøy!$G$39/Verktøy!$C$15,0)","v":0},{"$f":"IF($AP$4=TRUE,Verktøy!$G$43/Verktøy!$C$15,0)","v":0},0,{"$f":"IF($AR$4=TRUE,Verktøy!$G$51/Verktøy!$C$15*Input!$C$254/Beregninger!$D$2,0)","v":0},null,"TEK07",0,0,4,20,11,9,0,0,0]
[]
[null,null,null,null,null,null,null,{"$f":"INDEX(H15:H20,AX10)","v":41.516016981860275},null,"kWh/m2, år",{"$f":"INDEX('Energimerke D'!K15:K20,'Energimerke D'!AX10)","v":151.53200000000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mellomregning av reduksjon i besparelse ved gjennomføring av flere tiltak samtidig"]
[null,"Nedre grense energimerke D småhus",null,null,null,{"$f":"175+4100/Verktøy!C15","v":{"$error":"#DIV/0!"}},{"$f":"IF(K12<=F24,\"Ja\",\"Nei\")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Tiltakskombinasjon","1+4","1+3+4","1+2+4","1+6","2+6","3+6","4+6","1+4+6","1+2+4+6","1+3+4+6","1+2+3+4+6","AKTUELL"]
[null,"Nedre grense energimerke D boligblokk",null,null,null,{"$f":"135+2200/Verktøy!C15","v":{"$error":"#DIV/0!"}},{"$f":"IF(K22<=F25,\"Ja\",\"Nei\")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"Småhus","Byggeår",3.5,2.7,0.9,1.9,0.6,0.4,1.1000000000000001,6.1,5.4,5.3,4.9000000000000004,null,null,null,null,null,"1) I første fanen hukes det av for de forskjellige tiltakene. Er det huket av for et tiltak vil verdiene i AF4:AR4 bytte til TRUE som er en av faktorene for å hente ut riktig besparelse."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eldre","< 1950",{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AG$4=FALSE,$AH$4=FALSE),(Q5+T5)*($Q$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=FALSE,$AH$4=TRUE,$AI$4=TRUE),(Q5+T5+S5)*($R$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=TRUE,$AH$4=FALSE,$AI$4=TRUE),(Q5+T5+R5)*($S$25/100),0)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(Q26:AA26)","v":0},null,null,null,null,"2) Formlene i Q5:AC20 sjekker om det er huket av for tiltaket gjennom TRUE/FALSE i rekke 4 og henter riktig verdi ut av tabellen."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEK49","1951-1970",{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AG$4=FALSE,$AH$4=FALSE),(Q6+T6)*($Q$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=FALSE,$AH$4=TRUE,$AI$4=TRUE),(Q6+T6+S6)*($R$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=TRUE,$AH$4=FALSE,$AI$4=TRUE),(Q6+T6+R6)*($S$25/100),0)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,"3) Står det FALSE i tiltaket er blir verdien automatisk satt til 0."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEK69","1971 - 1988",0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,"4) I første fanen henter feltet som angir besparelsen summen fra H12 eller H22, avhengig av om det er valgt småhus eller boligblokk."]
[null,"1) Startpunkt, RO+Vent og Varmtvann oppdatert",null,null,null,null,null,null,null,null,null,null,null,null,"TEK87","1989 - 1998",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"2) Klimakorrigering er neglisjert ved å sette graddagstall for Osloklima fast i celle D2. Kontrolleres ved å se på f.eks. D5 og I5.",null,null,null,null,null,null,null,null,null,null,null,null,"TEK97","1999 - 2008",0,0,0,0,0,0,0,0,0,0,0,0]
[null,"3) Besparelse for tiltak 6 og 7 er neglisjert ved å sette 0 i besparelse i AL5 til AN20 (merket med gult).",null,null,null,null,null,null,null,null,null,null,null,null,"TEK07","2009 -",{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AG$4=FALSE,$AH$4=FALSE),(Q10+T10)*($Q$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=FALSE,$AH$4=TRUE,$AI$4=TRUE),(Q10+T10+S10)*($R$25/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=TRUE,$AH$4=FALSE,$AI$4=TRUE),(Q10+T10+R10)*($S$25/100),0)","v":0},0,0,0,0,0,0,0,0,0]
[null,"4) Klimakorriger for T11 er lagt inn i cellene AC5 til AC20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Boligblokk","Byggeår",0.7,0.1,0,1.4,0.4,0.3,1.3,3.3,2.7,3,2.2999999999999998]
[null,"SK: 29.01.21, TIB",null,null,null,null,null,null,null,null,null,null,null,null,"Eldre","< 1950",{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AG$4=FALSE,$AH$4=FALSE),(Q15+T15)*($Q$33/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AH$4=TRUE,$AG$4=FALSE),(Q15+T15+S15)*($R$33/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=TRUE,$AH$4=FALSE,$AI$4=TRUE),(Q15+T15+R15)*($S$33/100),0)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(Q34:AA34)","v":0}]
[null,"1) Ok",null,null,null,null,null,null,null,null,null,null,null,null,"TEK49","1951-1970",{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AG$4=FALSE,$AH$4=FALSE),(Q16+T16)*($Q$33/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AH$4=TRUE,$AG$4=FALSE),(Q16+T16+S16)*($R$33/100),0)","v":0},{"$f":"IF(AND($AF$4=TRUE,$AG$4=TRUE,$AH$4=FALSE,$AI$4=TRUE),(Q16+T16+R16)*($S$33/100),0)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(Q35:AA35)","v":0}]
[null,"2) Ok",null,null,null,null,null,null,null,null,null,null,null,null,"TEK69","1971 - 1988",{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AG$4=FALSE,$AH$4=FALSE),(Q17+T17)*($Q$33/100),0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"3) Ok",null,null,null,null,null,null,null,null,null,null,null,null,"TEK87","1989 - 1998",0,{"$f":"IF(AND($AF$4=TRUE,$AI$4=TRUE,$AH$4=TRUE,$AG$4=FALSE),(Q18+T18+S18)*($R$33/100),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"4) Ok",null,null,null,null,null,null,null,null,null,null,null,null,"TEK97","1999 - 2008",0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TEK07","2009 -",0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Input","index":3,"n_rows":358,"n_cols":13,"rows_kept":358,"cut":false,"hidden":true,"merged":[[2,5,2,6],[2,8,2,9],[12,5,12,6],[12,8,12,9]]}
[]
[null,"Kommune","GDT 19",null,"Startpunkter besparelse",null,null,null,null,null,null,null,"Rekkehus, enebolig, to- eller firemannsbolig"]
[null,"Alstahaug",4009.6,null,null,"Småhus",null,null,"Boligblokk",null,null,null,"Leilighet i boligblokk"]
[null,"Alta",5406.4,null,null,"Tot","RO+Vent","VV","Tot","RO+Vent","VV"]
[null,"Alvdal",5577.4,null,"Eldre",387,289.2,29.8,297.3,199.7,29.8]
[null,"Alver",3344.6999999999994,null,"TEK49",268,170.5,29.8,245.1,147.80000000000001,29.8]
[null,"Andøy",4499.6000000000004,null,"TEK69",253.4,155.80000000000001,29.8,214.7,112.1,29.8]
[null,"Aremark",3900,null,"TEK87",208,139,29.8,176.2,106.3,29.8]
[null,"Arendal",3361.7,null,"TEK97",161.69999999999999,92.8,29.8,146.1,76.599999999999994,29.8]
[null,"Asker",3808.7333333333336,null,"TEK07",132.6,61.1,29.8,115.8,42.7,29.8]
[null,"Askvoll",3327.1]
[null,"Askøy",3277.8,null,"Startpunkter energimerke D"]
[null,"Aukra",3446.8,null,null,"Småhus",null,null,"Boligblokk"]
[null,"Aure",3714.8,null,null,"Tot","RO+Vent","VV","Tot","RO+Vent","VV"]
[null,"Aurland",3850.2,null,"Eldre",339.6,279.5,29.8,259.10000000000002,199.2,29.8]
[null,"Aurskog-Høland",4204.8,null,"TEK49",233.2,173.2,29.8,212.3,152.6,29.8]
[null,"Austevoll",3180,null,"TEK69",220,160,29.8,185.2,120.2,29.8]
[null,"Austrheim",3352.5,null,"TEK87",189.3,125.2,29.8,161,96.2,29.8]
[null,"Averøy",3564.9,null,"TEK97",153.1,89.1,29.8,138.4,73.7,29.8]
[null,"Balsfjord",5193.5,null,"TEK07",125.8,{"$f":"49+10.1","v":59.1},29.8,110.1,{"$f":"29.7+12.2","v":41.9},29.8]
[null,"Bamble",3462.8]
[null,"Bardu",5316.7]
[null,"Beiarn",4452.7]
[null,"Bergen",3473.4]
[null,"Berlevåg",5316.3]
[null,"Bindal",4289.1000000000004]
[null,"Birkenes",3576.3]
[null,"Bjerkreim",3461.3]
[null,"Bjørnafjorden",3293.7]
[null,"Bodø",4232.6000000000004]
[null,"Bokn",3228.8]
[null,"Bremanger",3727.2]
[null,"Brønnøy",4021.8]
[null,"Bygland",3985.5]
[null,"Bykle",5410.8]
[null,"Bærum",3797.2]
[null,"Bø",4233.5]
[null,"Bømlo",3188.9]
[null,"Båtsfjord",5395.5]
[null,"Dovre",5243.9]
[null,"Drammen",3794.3666666666668]
[null,"Drangedal",3928.4]
[null,"Dyrøy",4893.7]
[null,"Dønna",3908]
[null,"Eidfjord",3661.9]
[null,"Eidskog",4317]
[null,"Eidsvoll",4212]
[null,"Eigersund",3469.2]
[null,"Elverum",4601.6000000000004]
[null,"Enebakk",4115.7]
[null,"Engerdal",5660.9]
[null,"Etne",3341.7]
[null,"Etnedal",4814.1000000000004]
[null,"Evenes",4594.3999999999996]
[null,"Evje og Hornnes",3895.2]
[null,"Farsund",3320.7]
[null,"Fauske",4565.8]
[null,"Fedje",3251.4]
[null,"Fitjar",3345.8]
[null,"Fjaler",3589.4]
[null,"Fjord",3552.6000000000004]
[null,"Flakstad",4433.3999999999996]
[null,"Flatanger",3902.4]
[null,"Flekkefjord",3473.4]
[null,"Flesberg",4278.3]
[null,"Flå",4437.5]
[null,"Folldal",5748.7]
[null,"Fredrikstad",3427.9]
[null,"Frogn",3827.6]
[null,"Froland",3693.2]
[null,"Frosta",4089.4]
[null,"Frøya",3598]
[null,"Fyresdal",4304.8]
[null,"Færder",3486.1]
[null,"Gamvik",5245.5]
[null,"Gausdal",4528.1000000000004]
[null,"Gildeskål",4251.5]
[null,"Giske",3333.6]
[null,"Gjemnes",3579.3]
[null,"Gjerdrum",4158]
[null,"Gjerstad",3694.2]
[null,"Gjesdal",3449.5]
[null,"Gjøvik",4350.3]
[null,"Gloppen",3626.8]
[null,"Gol",4638.6000000000004]
[null,"Gran",4332.8999999999996]
[null,"Grane",4938.5]
[null,"Gratangen",5041]
[null,"Grimstad",3327.1]
[null,"Grong",4647.8999999999996]
[null,"Grue",4379.3999999999996]
[null,"Gulen",3430.4]
[null,"Hadsel",4263.8999999999996]
[null,"Halden",3374.7]
[null,"Hamar",4397.3999999999996]
[null,"Hamarøy",4622.8500000000004]
[null,"Hammerfest",4970.4500000000007]
[null,"Hareid",3384.4]
[null,"Harstad",4566.6000000000004]
[null,"Hasvik",4775]
[null,"Hattfjelldal",5341.5]
[null,"Haugesund",3171]
[null,"Heim",3906.4333333333329]
[null,"Hemnes",4694.8]
[null,"Hemsedal",5265.4]
[null,"Herøy",3299.6]
[null,"Herøy",3854.2]
[null,"Hitra",3869.8]
[null,"Hjartdal",4172.3999999999996]
[null,"Hjelmeland",3339.5]
[null,"Hol",5056.3]
[null,"Hole",3978.3]
[null,"Holmestrand",3795.4]
[null,"Holtålen",5222.7]
[null,"Horten",3647.8]
[null,"Hurdal",4300.3999999999996]
[null,"Hustadvika",3492.05]
[null,"Hvaler",3286.3]
[null,"Hyllestad",3670.2]
[null,"Hægebostad",3766.4]
[null,"Høyanger",3989.5]
[null,"Høylandet",4529.3999999999996]
[null,"Hå",3268.9]
[null,"Ibestad",4782.6000000000004]
[null,"Inderøy",4053.4]
[null,"Indre Fosen",3891]
[null,"Indre Østfold",3991.8399999999992]
[null,"Iveland",4082.4]
[null,"Jevnaker",4135.7]
[null,"Karasjok",6528.4]
[null,"Karlsøy",4717.1000000000004]
[null,"Karmøy",3151.6]
[null,"Kautokeino",6637.5]
[null,"Kinn",3288.75]
[null,"Klepp",3250.1]
[null,"Kongsberg",4185.8]
[null,"Kongsvinger",4318.7]
[null,"Kragerø",3436.9]
[null,"Kristiansand",3353.1333333333332]
[null,"Kristiansund",3534.9]
[null,"Krødsherad",4306.6000000000004]
[null,"Kvam",3471.6]
[null,"Kvinesdal",3327.9]
[null,"Kvinnherad",3454]
[null,"Kviteseid",4036.7]
[null,"Kvitsøy",3099.7]
[null,"Kvæfjord",4975.8999999999996]
[null,"Kvænangen",5003.1000000000004]
[null,"Kåfjord",5035.8999999999996]
[null,"Larvik",3508.9]
[null,"Lavangen",4914.5]
[null,"Lebesby",5523.3]
[null,"Leirfjord",4268.7]
[null,"Leka",4059.9]
[null,"Lesja",5288.5]
[null,"Levanger",4046.7]
[null,"Lier",3852.9]
[null,"Lierne",5409.2]
[null,"Lillehammer",4648.8999999999996]
[null,"Lillesand",3357.9]
[null,"Lillestrøm",4047.2666666666669]
[null,"Lindesnes",3304.2999999999997]
[null,"Lom",5047.6000000000004]
[null,"Loppa",4845.3999999999996]
[null,"Lund",3452.3]
[null,"Lunner",4411.8999999999996]
[null,"Lurøy",4007.9]
[null,"Luster",3877.5]
[null,"Lyngdal",3401.3500000000004]
[null,"Lyngen",5045.8]
[null,"Lærdal",3971.5]
[null,"Lødingen",4416.2]
[null,"Lørenskog",4119.8]
[null,"Løten",4558.8]
[null,"Malvik",4059.5]
[null,"Marker",4045]
[null,"Masfjorden",4123.8999999999996]
[null,"Melhus",4153.6000000000004]
[null,"Meløy",4354]
[null,"Meråker",4446.6000000000004]
[null,"Midtre Gauldal",4374.8999999999996]
[null,"Midt-Telemark",3973.8]
[null,"Modalen",3561.5]
[null,"Modum",4050.6]
[null,"Molde",3508.7000000000003]
[null,"Moskenes",4057.6]
[null,"Moss",3612.7]
[null,"Målselv",5143.6000000000004]
[null,"Måsøy",4955.7]
[null,"Namsos",4211.7666666666664]
[null,"Namsskogan",5056.1000000000004]
[null,"Nannestad",4219.8999999999996]
[null,"Narvik",4722.5]
[null,"Nes",4153.1000000000004]
[null,"Nes",4531.8999999999996]
[null,"Nesna",4148.6000000000004]
[null,"Nesodden",3907.7]
[null,"Nesseby",5841.6]
[null,"Nissedal",4189.1000000000004]
[null,"Nittedal",4213.3]
[null,"Nome",3838.7]
[null,"Nord-Aurdal",4891.1000000000004]
[null,"Nord-Fron",4959.5]
[null,"Nordkapp",5225.7]
[null,"Nord-Odal",4290.5]
[null,"Nordre Follo",3978.45]
[null,"Nordre Land",4476.7]
[null,"Nordreisa",4973.8]
[null,"Nore og Uvdal",4762.3]
[null,"Notodden",4014]
[null,"Nærøysund",4024]
[null,"Oppdal",5049.8999999999996]
[null,"Orkland",4081.4249999999997]
[null,"Os",5697.4]
[null,"Osen",4032.8]
[null,"Oslo",3762.1]
[null,"Osterøy",3432.8]
[null,"Overhalla",4400.2]
[null,"Porsanger",5652.3]
[null,"Porsgrunn",3593.8]
[null,"Rakkestad",3929.3]
[null,"Rana",4717.5]
[null,"Randaberg",3181.3]
[null,"Rauma",3604.7]
[null,"Rendalen",5429.7]
[null,"Rennebu",5039.7]
[null,"Rindal",4163.5]
[null,"Ringebu",4883.3999999999996]
[null,"Ringerike",4107]
[null,"Ringsaker",4426.3]
[null,"Risør",3442]
[null,"Rollag",4396.8999999999996]
[null,"Rælingen",4131.8999999999996]
[null,"Rødøy",4122]
[null,"Røros",5723.6]
[null,"Røst",3892.1]
[null,"Røyrvik",5434.1]
[null,"Råde",3671.6]
[null,"Salangen",4930.1000000000004]
[null,"Saltdal",4638.3999999999996]
[null,"Samnanger",3689.5]
[null,"Sande",3578.1]
[null,"Sandefjord",3430.9]
[null,"Sandnes",3217.3]
[null,"Sarpsborg",3658.8]
[null,"Sauda",3504.2]
[null,"Sel",5068]
[null,"Selbu",4478.8999999999996]
[null,"Seljord",4220.1000000000004]
[null,"Senja",5092.7999999999993]
[null,"Sigdal",4189.5]
[null,"Siljan",3943.1]
[null,"Sirdal",3500.2]
[null,"Skaun",4055.8]
[null,"Skien",3648.4]
[null,"Skiptvet",3967.7]
[null,"Skjervøy",4905.2]
[null,"Skjåk",4962.2]
[null,"Smøla",3473.4]
[null,"Snåsa",4580.1000000000004]
[null,"Sogndal",3852.4666666666667]
[null,"Sokndal",3486.4]
[null,"Sola",3140.6]
[null,"Solund",3553.9]
[null,"Sortland",4388.7]
[null,"Stad",3490.65]
[null,"Stange",4477.5]
[null,"Stavanger",3190.5666666666671]
[null,"Steigen",4204.7]
[null,"Steinkjer",4119.1000000000004]
[null,"Stjørdal",4040.5]
[null,"Stord",3295.2]
[null,"Stor-Elvdal",5293.6]
[null,"Storfjord",5269.4]
[null,"Strand",3278.7]
[null,"Stranda",3631]
[null,"Stryn",3698]
[null,"Sula",3415.7]
[null,"Suldal",3454.8]
[null,"Sunndal",3758.3]
[null,"Sunnfjord",3781.375]
[null,"Surnadal",3829.4]
[null,"Sveio",3222.1]
[null,"Sykkylven",3429.5]
[null,"Sømna",4153.8]
[null,"Søndre Land",4493.3999999999996]
[null,"Sør-Aurdal",4680.5]
[null,"Sørfold",4548.8999999999996]
[null,"Sør-Fron",5040.1000000000004]
[null,"Sør-Odal",4253.1000000000004]
[null,"Sørreisa",5013.2]
[null,"Sør-Varanger",5782]
[null,"Tana",5872.7]
[null,"Time",3314.1]
[null,"Tingvoll",3722.8]
[null,"Tinn",4609.3]
[null,"Tjeldsund",4539.6000000000004]
[null,"Tokke",4018.7]
[null,"Tolga",5627.3]
[null,"Tromsø",4842.5]
[null,"Trondheim",4166.55]
[null,"Trysil",5264.2]
[null,"Træna",5097.8999999999996]
[null,"Tvedestrand",3571.3]
[null,"Tydal",5577.3]
[null,"Tynset",5548.6]
[null,"Tysnes",3483.6]
[null,"Tysvær",3422.6]
[null,"Tønsberg",3579.25]
[null,"Ullensaker",4251.7]
[null,"Ullensvang",3544.4333333333338]
[null,"Ulstein",3349.6]
[null,"Ulvik",3821.1]
[null,"Utsira",3071.1]
[null,"Vadsø",5622.5]
[null,"Vaksdal",4226.3]
[null,"Valle",4326.5]
[null,"Vang",5128.8]
[null,"Vanylven",3395.4]
[null,"Vardø",5291.7]
[null,"Vefsn",4388.6000000000004]
[null,"Vega",3853.5]
[null,"Vegårshei",3892.3]
[null,"Vennesla",3523]
[null,"Verdal",4106]
[null,"Vestby",3844.5]
[null,"Vestnes",3493.1]
[null,"Vestre Slidre",4915.8]
[null,"Vestre Toten",4649.7]
[null,"Vestvågøy",4098.6000000000004]
[null,"Vevelstad",4107.3999999999996]
[null,"Vik",3693.9]
[null,"Vindafjord",3300.7]
[null,"Vinje",4752.6000000000004]
[null,"Volda",3594.25]
[null,"Voss herad",3627.25]
[null,"Værøy",3990.8]
[null,"Vågan",4158.3]
[null,"Vågå",5028.8]
[null,"Våler",3717.6]
[null,"Våler",4498.3999999999996]
[null,"Øksnes",4360.8]
[null,"Ørland",3807.1]
[null,"Ørsta",3498.8]
[null,"Østre Toten",4432.3999999999996]
[null,"Øvre Eiker",3889.2]
[null,"Øyer",4763.1000000000004]
[null,"Øygarden",3238.9]
[null,"Øystre Slidre",5151.5]
[null,"Åfjord",3783.45]
[null,"Ål",4954.1000000000004]
[null,"Ålesund",3385.94]
[null,"Åmli",3861]
[null,"Åmot",4871.3]
[null,"Årdal",4123.1000000000004]
[null,"Ås",3912.6]
[null,"Åseral",4050]
[null,"Åsnes",4480.8]