{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Produktionsanlæg","Distributionsanlæg","Fællesfunktionsanlæg","Genanskaffelsespriser","Variable priser"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":8,"comments":1,"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":"row_number_cap","date_system":"1900"}

{"sheet":"Produktionsanlæg","index":0,"n_rows":146,"n_cols":21,"rows_kept":146,"cut":false,"hidden":false,"merged":[]}
["Produktionsanlæg","Enhed","Standard-levetid","Samlet mængde per 31/12-2023","Samlet mængde per 31/12-2024","Samlet mængde per 31/12-2025","Afvigelse\n2023-2024","Afvigelse\n2024-2025","Bemærkninger","Enhedspris\n2024","Enhedspris\n2025","Netvolumenbidrag\n2024","Netvolumenbidrag\n2025","Ejerandel\n2024 (%)","Ejerandel\n2025 (%)",null,"Postnr.","Selskabsnavn","CAPEX Netvolumenmål\n2024","CAPEX Netvolumenmål\n2025","Gennemsnitligt\nCAPEX Netvolumenmål"]
["Boringer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2800,"Lyngby-Taarbæk Vand",{"$f":"SUMIFS(L:L,L:L,\">0\") + SUMIFS(Distributionsanlæg!L:L,Distributionsanlæg!L:L,\">0\") + SUMIFS(Fællesfunktionsanlæg!L:L,Fællesfunktionsanlæg!L:L,\">0\")","v":14469384.49586465},{"$f":"SUMIFS(M:M,M:M,\">0\") + SUMIFS(Distributionsanlæg!M:M,Distributionsanlæg!M:M,\">0\") + SUMIFS(Fællesfunktionsanlæg!M:M,Fællesfunktionsanlæg!M:M,\">0\")","v":14713012.954577981},{"$f":"AVERAGE(S2:T2)","v":14591198.725221315}]
["Boring (inkl. etablering, forerør, filter og prøvepumpning)","dybdemeter",{"$f":"Genanskaffelsespriser!E5","v":30},1321.3,1521.2,1521.2,{"$f":"IF($D3=\"\",IF($E3>0,\"Ny data\",IF($E3=\"\",\"\",0)),IF($D3=0,IF($E3=0,0,\"Ny data\"),($E3-$D3)/$D3))","v":0.15129039582229631},{"$f":"IF($E3=\"\",IF($F3>0,\"Ny data\",IF($F3=\"\",\"\",0)),IF($E3=0,IF($F3=0,0,\"Ny data\"),($F3-$E3)/$E3))","v":0},null,{"$f":"Genanskaffelsespriser!$D5","v":2538},{"$f":"J3","v":2538},{"$f":"IF(ISNUMBER(E3),((J3*E3)/C3)*N3,\"\")","v":128693.52},{"$f":"IF(ISNUMBER(F3),((K3*F3)/C3)*O3,\"\")","v":128693.52},1,1]
["Råvandsstationer"]
["Råvandsstation komplet montering og boringshus/tørbrønd","stk.",{"$f":"Genanskaffelsespriser!E7","v":30},9,9,9,{"$f":"IF($D5=\"\",IF($E5>0,\"Ny data\",IF($E5=\"\",\"\",0)),IF($D5=0,IF($E5=0,0,\"Ny data\"),($E5-$D5)/$D5))","v":0},{"$f":"IF($E5=\"\",IF($F5>0,\"Ny data\",IF($F5=\"\",\"\",0)),IF($E5=0,IF($F5=0,0,\"Ny data\"),($F5-$E5)/$E5))","v":0},null,{"$f":"Genanskaffelsespriser!$D7","v":59948.969999999994},{"$f":"J5","v":59948.969999999994},{"$f":"IF(ISNUMBER(E5),((J5*E5)/C5)*N5,\"\")","v":17984.690999999999},{"$f":"IF(ISNUMBER(F5),((K5*F5)/C5)*O5,\"\")","v":17984.690999999999},1,1]
["Instrumenter (flowmåler+tryk transducer+alarmer)","stk.",{"$f":"Genanskaffelsespriser!E8","v":10},9,9,9,0,0,null,{"$f":"Genanskaffelsespriser!$D8","v":67654.917000000001},{"$f":"J6","v":67654.917000000001},60889.425300000003,60889.425300000003,1,1]
["Pumpe inkl. stigrør og forerørsforsejlinger mv. 1","m³/h ",{"$f":"Genanskaffelsespriser!E9","v":15},27,27,27,0,0,null,{"$f":"IF(E7=0,\"Variabel pris\",IFERROR(((HLOOKUP(E7,'Variable priser'!$C$2:$H$4,2)+(E7-HLOOKUP(E7,'Variable priser'!$C$2:$H$4,1))*HLOOKUP(E7,'Variable priser'!$C$2:$H$4,3))/E7*(1+Genanskaffelsespriser!$D$203)),\"Fejl\"))","v":2799.5667773333325},{"$f":"IF(F7=0,\"Variabel pris\",IFERROR(((HLOOKUP(F7,'Variable priser'!$C$2:$H$4,2)+(F7-HLOOKUP(F7,'Variable priser'!$C$2:$H$4,1))*HLOOKUP(F7,'Variable priser'!$C$2:$H$4,3))/F7*(1+Genanskaffelsespriser!$D$203)),\"Fejl\"))","v":2799.5667773333325},{"$f":"IF(ISBLANK(E7),\"\",IF(E7=0,\"\",IF(ISNUMBER(E7),((J7*E7)/C7)*N7,\"\")))","v":5039.2201991999991},{"$f":"IF(ISBLANK(F7),\"\",IF(F7=0,\"\",IF(ISNUMBER(F7),((K7*F7)/C7)*N7,\"\")))","v":5039.2201991999991},1,1]
["Pumpe inkl. stigrør og forerørsforsejlinger mv. 2","m³/h ",{"$f":"Genanskaffelsespriser!E9","v":15},27,27,27,0,0,null,{"$f":"IF(E8=0,\"Variabel pris\",IFERROR(((HLOOKUP(E8,'Variable priser'!$C$2:$H$4,2)+(E8-HLOOKUP(E8,'Variable priser'!$C$2:$H$4,1))*HLOOKUP(E8,'Variable priser'!$C$2:$H$4,3))/E8*(1+Genanskaffelsespriser!$D$203)),\"Fejl\"))","v":2799.5667773333325},{"$f":"IF(F8=0,\"Variabel pris\",IFERROR(((HLOOKUP(F8,'Variable priser'!$C$2:$H$4,2)+(F8-HLOOKUP(F8,'Variable priser'!$C$2:$H$4,1))*HLOOKUP(F8,'Variable priser'!$C$2:$H$4,3))/F8*(1+Genanskaffelsespriser!$D$203)),\"Fejl\"))","v":2799.5667773333325},{"$f":"IF(ISBLANK(E8),\"\",IF(E8=0,\"\",IF(ISNUMBER(E8),((J8*E8)/C8)*N8,\"\")))","v":5039.2201991999991},{"$f":"IF(ISBLANK(F8),\"\",IF(F8=0,\"\",IF(ISNUMBER(F8),((K8*F8)/C8)*N8,\"\")))","v":5039.2201991999991},1,1]
["Pumpe inkl. stigrør og forerørsforsejlinger mv. 3","m³/h ",{"$f":"Genanskaffelsespriser!E9","v":15},27,27,27,0,0,null,{"$f":"IF(E9=0,\"Variabel pris\",IFERROR(((HLOOKUP(E9,'Variable priser'!$C$2:$H$4,2)+(E9-HLOOKUP(E9,'Variable priser'!$C$2:$H$4,1))*HLOOKUP(E9,'Variable priser'!$C$2:$H$4,3))/E9*(1+Genanskaffelsespriser!$D$203)),\"Fejl\"))","v":2799.5667773333325},{"$f":"IF(F9=0,\"Variabel pris\",IFERROR(((HLOOKUP(F9,'Variable priser'!$C$2:$H$4,2)+(F9-HLOOKUP(F9,'Variable priser'!$C$2:$H$4,1))*HLOOKUP(F9,'Variable priser'!$C$2:$H$4,3))/F9*(1+Genanskaffelsespriser!$D$203)),\"Fejl\"))","v":2799.5667773333325},5039.2201991999991,5039.2201991999991,1,1]
["Pumpe inkl. stigrør og forerørsforsejlinger mv. 4","m³/h ",{"$f":"Genanskaffelsespriser!E9","v":15},45,45,45,0,0,null,{"$f":"IF(E10=0,\"Variabel pris\",IFERROR(((HLOOKUP(E10,'Variable priser'!$C$2:$H$4,2)+(E10-HLOOKUP(E10,'Variable priser'!$C$2:$H$4,1))*HLOOKUP(E10,'Variable priser'!$C$2:$H$4,3))/E10*(1+Genanskaffelsespriser!$D$203)),\"Fejl\"))","v":2079.8708026666663},{"$f":"IF(F10=0,\"Variabel pris\",IFERROR(((HLOOKUP(F10,'Variable priser'!$C$2:$H$4,2)+(F10-HLOOKUP(F10,'Variable priser'!$C$2:$H$4,1))*HLOOKUP(F10,'Variable priser'!$C$2:$H$4,3))/F10*(1+Genanskaffelsespriser!$D$203)),\"Fejl\"))","v":2079.8708026666663},6239.612407999999,6239.612407999999,1,1]
["Pumpe inkl. stigrør og forerørsforsejlinger mv. 5","m³/h ",{"$f":"Genanskaffelsespriser!E9","v":15},43,43,43,0,0,null,{"$f":"IF(E11=0,\"Variabel pris\",IFERROR(((HLOOKUP(E11,'Variable priser'!$C$2:$H$4,2)+(E11-HLOOKUP(E11,'Variable priser'!$C$2:$H$4,1))*HLOOKUP(E11,'Variable priser'!$C$2:$H$4,3))/E11*(1+Genanskaffelsespriser!$D$203)),\"Fejl\"))","v":2134.4643734697675},{"$f":"IF(F11=0,\"Variabel pris\",IFERROR(((HLOOKUP(F11,'Variable priser'!$C$2:$H$4,2)+(F11-HLOOKUP(F11,'Variable priser'!$C$2:$H$4,1))*HLOOKUP(F11,'Variable priser'!$C$2:$H$4,3))/F11*(1+Genanskaffelsespriser!$D$203)),\"Fejl\"))","v":2134.4643734697675},6118.7978706133335,6118.7978706133335,1,1]
["Pumpe inkl. stigrør og forerørsforsejlinger mv. 6","m³/h ",{"$f":"Genanskaffelsespriser!E9","v":15},17,17,17,0,0,null,{"$f":"IF(E12=0,\"Variabel pris\",IFERROR(((HLOOKUP(E12,'Variable priser'!$C$2:$H$4,2)+(E12-HLOOKUP(E12,'Variable priser'!$C$2:$H$4,1))*HLOOKUP(E12,'Variable priser'!$C$2:$H$4,3))/E12*(1+Genanskaffelsespriser!$D$203)),\"Fejl\"))","v":3496.2412055999994},{"$f":"IF(F12=0,\"Variabel pris\",IFERROR(((HLOOKUP(F12,'Variable priser'!$C$2:$H$4,2)+(F12-HLOOKUP(F12,'Variable priser'!$C$2:$H$4,1))*HLOOKUP(F12,'Variable priser'!$C$2:$H$4,3))/F12*(1+Genanskaffelsespriser!$D$203)),\"Fejl\"))","v":3496.2412055999994},3962.4066996799997,3962.4066996799997,1,1]
["Pumpe inkl. stigrør og forerørsforsejlinger mv. 7","m³/h ",{"$f":"Genanskaffelsespriser!E9","v":15},17,17,17,0,0,null,{"$f":"IF(E13=0,\"Variabel pris\",IFERROR(((HLOOKUP(E13,'Variable priser'!$C$2:$H$4,2)+(E13-HLOOKUP(E13,'Variable priser'!$C$2:$H$4,1))*HLOOKUP(E13,'Variable priser'!$C$2:$H$4,3))/E13*(1+Genanskaffelsespriser!$D$203)),\"Fejl\"))","v":3496.2412055999994},{"$f":"IF(F13=0,\"Variabel pris\",IFERROR(((HLOOKUP(F13,'Variable priser'!$C$2:$H$4,2)+(F13-HLOOKUP(F13,'Variable priser'!$C$2:$H$4,1))*HLOOKUP(F13,'Variable priser'!$C$2:$H$4,3))/F13*(1+Genanskaffelsespriser!$D$203)),\"Fejl\"))","v":3496.2412055999994},3962.4066996799997,3962.4066996799997,1,1]
["Pumpe inkl. stigrør og forerørsforsejlinger mv. 8","m³/h ",{"$f":"Genanskaffelsespriser!E9","v":15},50,50,50,0,0,null,{"$f":"IF(E14=0,\"Variabel pris\",IFERROR(((HLOOKUP(E14,'Variable priser'!$C$2:$H$4,2)+(E14-HLOOKUP(E14,'Variable priser'!$C$2:$H$4,1))*HLOOKUP(E14,'Variable priser'!$C$2:$H$4,3))/E14*(1+Genanskaffelsespriser!$D$203)),\"Fejl\"))","v":1954.1545199999996},{"$f":"IF(F14=0,\"Variabel pris\",IFERROR(((HLOOKUP(F14,'Variable priser'!$C$2:$H$4,2)+(F14-HLOOKUP(F14,'Variable priser'!$C$2:$H$4,1))*HLOOKUP(F14,'Variable priser'!$C$2:$H$4,3))/F14*(1+Genanskaffelsespriser!$D$203)),\"Fejl\"))","v":1954.1545199999996},6513.8483999999989,6513.8483999999989,1,1]
["Pumpe inkl. stigrør og forerørsforsejlinger mv. 9","m³/h ",{"$f":"Genanskaffelsespriser!E9","v":15},48,48,48,0,0,null,{"$f":"IF(E15=0,\"Variabel pris\",IFERROR(((HLOOKUP(E15,'Variable priser'!$C$2:$H$4,2)+(E15-HLOOKUP(E15,'Variable priser'!$C$2:$H$4,1))*HLOOKUP(E15,'Variable priser'!$C$2:$H$4,3))/E15*(1+Genanskaffelsespriser!$D$203)),\"Fejl\"))","v":2001.2981259999997},{"$f":"IF(F15=0,\"Variabel pris\",IFERROR(((HLOOKUP(F15,'Variable priser'!$C$2:$H$4,2)+(F15-HLOOKUP(F15,'Variable priser'!$C$2:$H$4,1))*HLOOKUP(F15,'Variable priser'!$C$2:$H$4,3))/F15*(1+Genanskaffelsespriser!$D$203)),\"Fejl\"))","v":2001.2981259999997},6404.1540031999994,6404.1540031999994,1,1]
["Pumpe inkl. stigrør og forerørsforsejlinger mv. 10","m³/h ",15,0,0,0,0,0,null,{"$f":"IF(E16=0,\"Variabel pris\",IFERROR(((HLOOKUP(E16,'Variable priser'!$C$2:$H$4,2)+(E16-HLOOKUP(E16,'Variable priser'!$C$2:$H$4,1))*HLOOKUP(E16,'Variable priser'!$C$2:$H$4,3))/E16*(1+Genanskaffelsespriser!$D$203)),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F16=0,\"Variabel pris\",IFERROR(((HLOOKUP(F16,'Variable priser'!$C$2:$H$4,2)+(F16-HLOOKUP(F16,'Variable priser'!$C$2:$H$4,1))*HLOOKUP(F16,'Variable priser'!$C$2:$H$4,3))/F16*(1+Genanskaffelsespriser!$D$203)),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Hegn","stk.",{"$f":"Genanskaffelsespriser!E11","v":15},1,1,1,0,0,null,{"$f":"Genanskaffelsespriser!$D11","v":88588.835999999996},{"$f":"J17","v":88588.835999999996},5905.9223999999995,5905.9223999999995,1,1]
["Elanlæg","boring",{"$f":"Genanskaffelsespriser!E12","v":20},9,9,9,0,0,null,{"$f":"Genanskaffelsespriser!$D12","v":112677.30899999999},{"$f":"J18","v":112677.30899999999},50704.789049999999,50704.789049999999,1,1]
["SRO anlæg","boring",{"$f":"Genanskaffelsespriser!E13","v":10},9,9,9,0,0,null,{"$f":"Genanskaffelsespriser!$D13","v":30338.471999999998},30338.471999999998,27304.624799999998,27304.624799999998,1,1]
["Råvandsledninger - Land"]
["Ø 50mm < Ledningsnet ≤ Ø110 mm","meter",{"$f":"Genanskaffelsespriser!E15","v":75},52,52,52,0,0,null,{"$f":"Genanskaffelsespriser!$D15","v":367.09799999999996},{"$f":"J21","v":367.09799999999996},254.52127999999996,254.52127999999996,1,1]
["Ø110 mm < Ledningsnet ≤ Ø 250 mm","meter",{"$f":"Genanskaffelsespriser!E16","v":75},656,656,656,0,0,null,{"$f":"Genanskaffelsespriser!$D16","v":1055.6659999999999},{"$f":"J22","v":1055.6659999999999},9233.5586133333327,9233.5586133333327,1,1]
["Ø 250 mm < Ledningsnet ≤ Ø 500mm","meter",{"$f":"Genanskaffelsespriser!E17","v":75},3,3,3,0,0,null,{"$f":"Genanskaffelsespriser!$D17","v":2421.395},2421.395,96.855799999999988,96.855799999999988,1,1]
["Ledningsnet > Ø 500 mm","meter",{"$f":"Genanskaffelsespriser!E18","v":75},0,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D18","v":5215.0729999999994},5215.0729999999994,0,0,1,1]
["Råvandsledninger - By"]
["Ø 50mm < Ledningsnet ≤ Ø110 mm","meter",{"$f":"Genanskaffelsespriser!E20","v":75},210,210,210,0,0,null,{"$f":"Genanskaffelsespriser!$D20","v":993.44599999999991},{"$f":"J26","v":993.44599999999991},2781.6487999999995,2781.6487999999995,1,1]
["Ø110 mm < Ledningsnet ≤ Ø 250 mm","meter",{"$f":"Genanskaffelsespriser!E21","v":75},2620,2620,2620,0,0,null,{"$f":"Genanskaffelsespriser!$D21","v":1746.3079999999998},{"$f":"J27","v":1746.3079999999998},61004.359466666654,61004.359466666654,1,1]
["Ø 250 mm < Ledningsnet ≤ Ø 500mm","meter",{"$f":"Genanskaffelsespriser!E22","v":75},5223,5223,5223,0,0,null,{"$f":"Genanskaffelsespriser!$D22","v":3269.6609999999996},3269.6609999999996,227699.19203999997,227699.19203999997,1,1]
["Ledningsnet > Ø 500 mm","meter",{"$f":"Genanskaffelsespriser!E23","v":75},0,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D23","v":6219.9259999999995},6219.9259999999995,0,0,1,1]
["Råvandsledninger - City"]
["Ø 50mm < Ledningsnet ≤ Ø110 mm","meter",{"$f":"Genanskaffelsespriser!E25","v":75},0,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D25","v":1550.3149999999998},{"$f":"J31","v":1550.3149999999998},0,0,1,1]
["Ø110 mm < Ledningsnet ≤ Ø 250 mm","meter",{"$f":"Genanskaffelsespriser!E26","v":75},804,804,804,0,0,null,{"$f":"Genanskaffelsespriser!$D26","v":2273.1039999999998},{"$f":"J32","v":2273.1039999999998},24367.674879999999,24367.674879999999,1,1]
["Ø 250 mm < Ledningsnet ≤ Ø 500mm","meter",{"$f":"Genanskaffelsespriser!E27","v":75},916,916,916,0,0,null,{"$f":"Genanskaffelsespriser!$D27","v":3912.6009999999997},3912.6009999999997,47785.900213333334,47785.900213333334,1,1]
["Ledningsnet > Ø 500 mm","meter",{"$f":"Genanskaffelsespriser!E28","v":75},0,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D28","v":6981.0839999999998},6981.0839999999998,0,0,1,1]
["Vandværk 1"]
["Beluftningsanlæg, iltningstrappe, Konstruktioner","m³/h ",{"$f":"Genanskaffelsespriser!$E$30","v":50},0,0,0,0,0,null,{"$f":"IF(E36=0,\"Variabel pris\",IFERROR((HLOOKUP(E36,'Variable priser'!$C$6:$H$16,2)+(E36-HLOOKUP(E36,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E36,'Variable priser'!$C$6:$H$16,3))/E36*'Variable priser'!$K$7*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F36=0,\"Variabel pris\",IFERROR((HLOOKUP(F36,'Variable priser'!$C$6:$H$16,2)+(F36-HLOOKUP(F36,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F36,'Variable priser'!$C$6:$H$16,3))/F36*'Variable priser'!$K$7*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(ISBLANK(E36),\"\",IF(E36=0,\"\",IF(ISNUMBER(E36),((J36*E36)/C36)*N36,\"\")))","v":""},{"$f":"IF(ISBLANK(F36),\"\",IF(F36=0,\"\",IF(ISNUMBER(F36),((K36*F36)/C36)*N36,\"\")))","v":""},1,1]
["Beluftningsanlæg, iltningstrappe, Mek./EL","m³/h ",{"$f":"Genanskaffelsespriser!$E$31","v":25},0,0,0,0,0,null,{"$f":"IF(E37=0,\"Variabel pris\",IFERROR((HLOOKUP(E37,'Variable priser'!$C$6:$H$16,2)+(E37-HLOOKUP(E37,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E37,'Variable priser'!$C$6:$H$16,3))/E37*'Variable priser'!$L$7*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F37=0,\"Variabel pris\",IFERROR((HLOOKUP(F37,'Variable priser'!$C$6:$H$16,2)+(F37-HLOOKUP(F37,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F37,'Variable priser'!$C$6:$H$16,3))/F37*'Variable priser'!$L$7*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(ISBLANK(E37),\"\",IF(E37=0,\"\",IF(ISNUMBER(E37),((J37*E37)/C37)*N37,\"\")))","v":""},{"$f":"IF(ISBLANK(F37),\"\",IF(F37=0,\"\",IF(ISNUMBER(F37),((K37*F37)/C37)*N37,\"\")))","v":""},1,1]
["Beluftningsanlæg, ika-beluftning, Konstruktioner","m³/h ",{"$f":"Genanskaffelsespriser!$E$32","v":50},0,0,0,0,0,null,{"$f":"IF(E38=0,\"Variabel pris\",IFERROR((HLOOKUP(E38,'Variable priser'!$C$6:$H$16,4)+(E38-HLOOKUP(E38,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E38,'Variable priser'!$C$6:$H$16,5))/E38*'Variable priser'!$K$9*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F38=0,\"Variabel pris\",IFERROR((HLOOKUP(F38,'Variable priser'!$C$6:$H$16,4)+(F38-HLOOKUP(F38,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F38,'Variable priser'!$C$6:$H$16,5))/F38*'Variable priser'!$K$9*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Beluftningsanlæg, ika-beluftning, Mek./EL","m³/h ",{"$f":"Genanskaffelsespriser!$E$33","v":25},0,0,0,0,0,null,{"$f":"IF(E39=0,\"Variabel pris\",IFERROR((HLOOKUP(E39,'Variable priser'!$C$6:$H$16,4)+(E39-HLOOKUP(E39,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E39,'Variable priser'!$C$6:$H$16,5))/E39*'Variable priser'!$L$9*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F39=0,\"Variabel pris\",IFERROR((HLOOKUP(F39,'Variable priser'!$C$6:$H$16,4)+(F39-HLOOKUP(F39,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F39,'Variable priser'!$C$6:$H$16,5))/F39*'Variable priser'!$L$9*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Beluftningsanlæg, bundbeluftbning, Konstruktioner","m³/h ",{"$f":"Genanskaffelsespriser!$E$34","v":50},0,0,0,0,0,null,{"$f":"IF(E40=0,\"Variabel pris\",IFERROR((HLOOKUP(E40,'Variable priser'!$C$6:$H$16,6)+(E40-HLOOKUP(E40,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E40,'Variable priser'!$C$6:$H$16,7))/E40*'Variable priser'!$K$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F40=0,\"Variabel pris\",IFERROR((HLOOKUP(F40,'Variable priser'!$C$6:$H$16,6)+(F40-HLOOKUP(F40,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F40,'Variable priser'!$C$6:$H$16,7))/F40*'Variable priser'!$K$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Beluftningsanlæg, bundbeluftbning, Mek./EL","m³/h ",{"$f":"Genanskaffelsespriser!$E$35","v":25},0,0,0,0,0,null,{"$f":"IF(E41=0,\"Variabel pris\",IFERROR((HLOOKUP(E41,'Variable priser'!$C$6:$H$16,6)+(E41-HLOOKUP(E41,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E41,'Variable priser'!$C$6:$H$16,7))/E41*'Variable priser'!$L$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F41=0,\"Variabel pris\",IFERROR((HLOOKUP(F41,'Variable priser'!$C$6:$H$16,6)+(F41-HLOOKUP(F41,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F41,'Variable priser'!$C$6:$H$16,7))/F41*'Variable priser'!$L$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Beluftningsanlæg, rislebakke, Konstruktioner","m³/h ",{"$f":"Genanskaffelsespriser!$E$36","v":50},150,150,150,0,0,null,{"$f":"IF(E42=0,\"Variabel pris\",IFERROR((HLOOKUP(E42,'Variable priser'!$C$6:$H$18,12)+(E42-HLOOKUP(E42,'Variable priser'!$C$6:$H$18,1))*HLOOKUP(E42,'Variable priser'!$C$6:$H$18,13))/E42*'Variable priser'!$K$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":1681.3277797679998},{"$f":"IF(F42=0,\"Variabel pris\",IFERROR((HLOOKUP(F42,'Variable priser'!$C$6:$H$18,12)+(F42-HLOOKUP(F42,'Variable priser'!$C$6:$H$18,1))*HLOOKUP(F42,'Variable priser'!$C$6:$H$18,13))/F42*'Variable priser'!$K$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":1681.3277797679998},5043.9833393039999,5043.9833393039999,1,1]
["Beluftningsanlæg, rislebakke, Mek./EL","m³/h ",{"$f":"Genanskaffelsespriser!$E$37","v":25},150,150,150,0,0,null,{"$f":"IF(E43=0,\"Variabel pris\",IFERROR((HLOOKUP(E43,'Variable priser'!$C$6:$H$18,12)+(E43-HLOOKUP(E43,'Variable priser'!$C$6:$H$18,1))*HLOOKUP(E43,'Variable priser'!$C$6:$H$18,13))/E43*'Variable priser'!$L$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":720.56904847200008},{"$f":"IF(F43=0,\"Variabel pris\",IFERROR((HLOOKUP(F43,'Variable priser'!$C$6:$H$18,12)+(F43-HLOOKUP(F43,'Variable priser'!$C$6:$H$18,1))*HLOOKUP(F43,'Variable priser'!$C$6:$H$18,13))/F43*'Variable priser'!$L$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":720.56904847200008},4323.4142908320009,4323.4142908320009,1,1]
["Beluftningsanlæg, kompressorbeluftning","m³/h ",{"$f":"Genanskaffelsespriser!$E$38","v":25},0,0,0,0,0,null,{"$f":"IF(E44=0,\"Variabel pris\",IFERROR((HLOOKUP(E44,'Variable priser'!$C$6:$H$16,8)+(E44-HLOOKUP(E44,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E44,'Variable priser'!$C$6:$H$16,9))/E44*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F44=0,\"Variabel pris\",IFERROR((HLOOKUP(F44,'Variable priser'!$C$6:$H$16,8)+(F44-HLOOKUP(F44,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F44,'Variable priser'!$C$6:$H$16,9))/F44*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Beluftningsanlæg, ren ilt","m³/h ",{"$f":"Genanskaffelsespriser!$E$39","v":25},0,0,0,0,0,null,{"$f":"IF(E45=0,\"Variabel pris\",IFERROR((HLOOKUP(E45,'Variable priser'!$C$6:$H$16,10)+(E45-HLOOKUP(E45,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E45,'Variable priser'!$C$6:$H$16,11))/E45*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F45=0,\"Variabel pris\",IFERROR((HLOOKUP(F45,'Variable priser'!$C$6:$H$16,10)+(F45-HLOOKUP(F45,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F45,'Variable priser'!$C$6:$H$16,11))/F45*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Behandlingsanlæg, kalk anlæg","m³/h ",{"$f":"Genanskaffelsespriser!$E$40","v":25},0,0,0,0,0,null,{"$f":"IF(E46=0,\"Variabel pris\",IFERROR((HLOOKUP(E46,'Variable priser'!$C$20:$G$24,3)+(E46-HLOOKUP(E46,'Variable priser'!$C$20:$G$24,1))*HLOOKUP(E46,'Variable priser'!$C$20:$G$24,4))/E46*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F46=0,\"Variabel pris\",IFERROR((HLOOKUP(F46,'Variable priser'!$C$20:$G$24,3)+(F46-HLOOKUP(F46,'Variable priser'!$C$20:$G$24,1))*HLOOKUP(F46,'Variable priser'!$C$20:$G$24,4))/F46*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Behandlingsanlæg, luddosering","m³/h ",{"$f":"Genanskaffelsespriser!$E$41","v":25},0,0,0,0,0,null,{"$f":"IF(E47=0,\"Variabel pris\",IFERROR((HLOOKUP(E47,'Variable priser'!$C$20:$G$25,5)+(E47-HLOOKUP(E47,'Variable priser'!$C$20:$G$25,1))*HLOOKUP(E47,'Variable priser'!$C$20:$G$25,6))/E47*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F47=0,\"Variabel pris\",IFERROR((HLOOKUP(F47,'Variable priser'!$C$20:$G$25,5)+(F47-HLOOKUP(F47,'Variable priser'!$C$20:$G$25,1))*HLOOKUP(F47,'Variable priser'!$C$20:$G$25,6))/F47*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Filteranlæg, åbne filtre, enkelt filtrering, Konstruktioner","m³/h ",{"$f":"Genanskaffelsespriser!$E$42","v":50},0,0,0,0,0,null,{"$f":"IF(E48=0,\"Variabel pris\",IFERROR((HLOOKUP(E48,'Variable priser'!$C$28:$G$38,9)+(E48-HLOOKUP(E48,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(E48,'Variable priser'!$C$28:$G$38,10))/E48*'Variable priser'!$K$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F48=0,\"Variabel pris\",IFERROR((HLOOKUP(F48,'Variable priser'!$C$28:$G$38,9)+(F48-HLOOKUP(F48,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(F48,'Variable priser'!$C$28:$G$38,10))/F48*'Variable priser'!$K$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Filteranlæg, åbne filtre, enkelt filtrering, Mek./EL","m³/h ",{"$f":"Genanskaffelsespriser!$E$43","v":25},0,0,0,0,0,null,{"$f":"IF(E49=0,\"Variabel pris\",IFERROR((HLOOKUP(E49,'Variable priser'!$C$28:$G$38,9)+(E49-HLOOKUP(E49,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(E49,'Variable priser'!$C$28:$G$38,10))/E49*'Variable priser'!$L$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F49=0,\"Variabel pris\",IFERROR((HLOOKUP(F49,'Variable priser'!$C$28:$G$38,9)+(F49-HLOOKUP(F49,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(F49,'Variable priser'!$C$28:$G$38,10))/F49*'Variable priser'!$L$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Filteranlæg, åbne filtre, dobbelt filtrering, Konstruktioner","m³/h ",{"$f":"Genanskaffelsespriser!$E$44","v":50},150,150,150,0,0,null,{"$f":"IF(E50=0,\"Variabel pris\",IFERROR((HLOOKUP(E50,'Variable priser'!$C$28:$G$38,6)+(E50-HLOOKUP(E50,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(E50,'Variable priser'!$C$28:$G$38,7))/E50*'Variable priser'!$K$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":9480.5904691679989},{"$f":"IF(F50=0,\"Variabel pris\",IFERROR((HLOOKUP(F50,'Variable priser'!$C$28:$G$38,6)+(F50-HLOOKUP(F50,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(F50,'Variable priser'!$C$28:$G$38,7))/F50*'Variable priser'!$K$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":9480.5904691679989},28441.771407503998,28441.771407503998,1,1]
["Filteranlæg, åbne filtre, dobbelt filtrering, Mek./EL","m³/h ",{"$f":"Genanskaffelsespriser!$E$45","v":25},150,150,150,0,0,null,{"$f":"IF(E51=0,\"Variabel pris\",IFERROR((HLOOKUP(E51,'Variable priser'!$C$28:$G$38,6)+(E51-HLOOKUP(E51,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(E51,'Variable priser'!$C$28:$G$38,7))/E51*'Variable priser'!$L$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":14220.885703751997},{"$f":"IF(F51=0,\"Variabel pris\",IFERROR((HLOOKUP(F51,'Variable priser'!$C$28:$G$38,6)+(F51-HLOOKUP(F51,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(F51,'Variable priser'!$C$28:$G$38,7))/F51*'Variable priser'!$L$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":14220.885703751997},85325.314222511981,85325.314222511981,1,1]
["Filteranlæg, trykfiltre, enkelt filtrering","m³/h ",{"$f":"Genanskaffelsespriser!$E$46","v":25},0,0,0,0,0,null,{"$f":"IF(E52=0,\"Variabel pris\",IFERROR((HLOOKUP(E52,'Variable priser'!$C$40:$H$42,2)+(E52-HLOOKUP(E52,'Variable priser'!$C$40:$H$42,1))*HLOOKUP(E52,'Variable priser'!$C$40:$H$42,3))/E52*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F52=0,\"Variabel pris\",IFERROR((HLOOKUP(F52,'Variable priser'!$C$40:$H$42,2)+(F52-HLOOKUP(F52,'Variable priser'!$C$40:$H$42,1))*HLOOKUP(F52,'Variable priser'!$C$40:$H$42,3))/F52*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Filteranlæg, trykfiltre, dobbelt filtrering","m³/h ",{"$f":"Genanskaffelsespriser!$E$47","v":25},0,0,0,0,0,null,{"$f":"IF(E53=0,\"Variabel pris\",IFERROR((HLOOKUP(E53,'Variable priser'!$C$44:$H$46,2)+(E53-HLOOKUP(E53,'Variable priser'!$C$44:$H$46,1))*HLOOKUP(E53,'Variable priser'!$C$44:$H$46,3))/E53*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F53=0,\"Variabel pris\",IFERROR((HLOOKUP(F53,'Variable priser'!$C$44:$H$46,2)+(F53-HLOOKUP(F53,'Variable priser'!$C$44:$H$46,1))*HLOOKUP(F53,'Variable priser'!$C$44:$H$46,3))/F53*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Rentvandsbeholder  insitu støbt","m³",{"$f":"Genanskaffelsespriser!$E$48","v":50},300,300,300,{"$f":"IF($D54=\"\",IF($E54>0,\"Ny data\",IF($E54=\"\",\"\",0)),IF($D54=0,IF($E54=0,0,\"Ny data\"),($E54-$D54)/$D54))","v":0},0,null,{"$f":"IF(E54=0,\"Variabel pris\",IFERROR((HLOOKUP(E54,'Variable priser'!$C$48:$H$50,2)+(E54-HLOOKUP(E54,'Variable priser'!$C$48:$H$50,1))*HLOOKUP(E54,'Variable priser'!$C$48:$H$50,3))/E54*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":4950.2273480000003},{"$f":"IF(F54=0,\"Variabel pris\",IFERROR((HLOOKUP(F54,'Variable priser'!$C$48:$H$50,2)+(F54-HLOOKUP(F54,'Variable priser'!$C$48:$H$50,1))*HLOOKUP(F54,'Variable priser'!$C$48:$H$50,3))/F54*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":4950.2273480000003},29701.364088000002,29701.364088000002,1,1]
["Rentvandsbeholder  element","m³",{"$f":"Genanskaffelsespriser!$E$49","v":50},0,0,0,0,0,null,{"$f":"IF(E55=0,\"Variabel pris\",IFERROR((HLOOKUP(E55,'Variable priser'!$C$52:$H$54,2)+(E55-HLOOKUP(E55,'Variable priser'!$C$52:$H$54,1))*HLOOKUP(E55,'Variable priser'!$C$52:$H$54,3))/E55*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F55=0,\"Variabel pris\",IFERROR((HLOOKUP(F55,'Variable priser'!$C$52:$H$54,2)+(F55-HLOOKUP(F55,'Variable priser'!$C$52:$H$54,1))*HLOOKUP(F55,'Variable priser'!$C$52:$H$54,3))/F55*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Udpumpningsanlæg, rentvandspumper på vandværk","m³/h ",{"$f":"Genanskaffelsespriser!$E$50","v":25},295,295,295,0,0,null,{"$f":"IF(E56=0,\"Variabel pris\",IFERROR((HLOOKUP(E56,'Variable priser'!$C$71:$H$73,2)+(E56-HLOOKUP(E56,'Variable priser'!$C$71:$H$73,1))*HLOOKUP(E56,'Variable priser'!$C$71:$H$73,3))/E56*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":1098.0555720338982},{"$f":"IF(F56=0,\"Variabel pris\",IFERROR((HLOOKUP(F56,'Variable priser'!$C$71:$H$73,2)+(F56-HLOOKUP(F56,'Variable priser'!$C$71:$H$73,1))*HLOOKUP(F56,'Variable priser'!$C$71:$H$73,3))/F56*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":1098.0555720338982},12957.05575,12957.05575,1,1]
["Udpumpningsanlæg, frekvensomformer","kW",{"$f":"Genanskaffelsespriser!$E$51","v":25},0,0,0,0,0,null,{"$f":"IF(E57=0,\"Variabel pris\",IFERROR((HLOOKUP(E57,'Variable priser'!$C$76:$J$78,2)+(E57-HLOOKUP(E57,'Variable priser'!$C$76:$J$78,1))*HLOOKUP(E57,'Variable priser'!$C$76:$J$78,3))/E57*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F57=0,\"Variabel pris\",IFERROR((HLOOKUP(F57,'Variable priser'!$C$76:$J$78,2)+(F57-HLOOKUP(F57,'Variable priser'!$C$76:$J$78,1))*HLOOKUP(F57,'Variable priser'!$C$76:$J$78,3))/F57*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Udpumpningsanlæg, Hydrofor","liter",{"$f":"Genanskaffelsespriser!$E$52","v":25},0,0,0,0,0,null,{"$f":"IF(E58=0,\"Variabel pris\",IFERROR((HLOOKUP(E58,'Variable priser'!$C$81:$J$83,2)+(E58-HLOOKUP(E58,'Variable priser'!$C$81:$J$83,1))*HLOOKUP(E58,'Variable priser'!$C$81:$J$83,3))/E58*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F58=0,\"Variabel pris\",IFERROR((HLOOKUP(F58,'Variable priser'!$C$81:$J$83,2)+(F58-HLOOKUP(F58,'Variable priser'!$C$81:$J$83,1))*HLOOKUP(F58,'Variable priser'!$C$81:$J$83,3))/F58*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Skyllevand-/slamhåndteringsanlæg - lukkede betonbeholdere","m³",{"$f":"Genanskaffelsespriser!$E$53","v":50},60,60,60,0,0,null,{"$f":"IF(E59=0,\"Variabel pris\",IFERROR((HLOOKUP(E59,'Variable priser'!$C$59:$H$61,2)+(E59-HLOOKUP(E59,'Variable priser'!$C$59:$H$61,1))*HLOOKUP(E59,'Variable priser'!$C$59:$H$61,3))/E59*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":5400.2480159999986},{"$f":"IF(F59=0,\"Variabel pris\",IFERROR((HLOOKUP(F59,'Variable priser'!$C$59:$H$61,2)+(F59-HLOOKUP(F59,'Variable priser'!$C$59:$H$61,1))*HLOOKUP(F59,'Variable priser'!$C$59:$H$61,3))/F59*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":5400.2480159999986},6480.2976191999987,6480.2976191999987,1,1]
["Skyllevand-/slamhåndteringsanl. - åbne med faste sider/bund","m³",{"$f":"Genanskaffelsespriser!$E$54","v":50},0,0,0,0,0,null,{"$f":"IF(E60=0,\"Variabel pris\",IFERROR((HLOOKUP(E60,'Variable priser'!$C$59:$H$64,5)+(E60-HLOOKUP(E60,'Variable priser'!$C$59:$H$64,1))*HLOOKUP(E60,'Variable priser'!$C$59:$H$64,6))/E60*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F60=0,\"Variabel pris\",IFERROR((HLOOKUP(F60,'Variable priser'!$C$59:$H$64,5)+(F60-HLOOKUP(F60,'Variable priser'!$C$59:$H$64,1))*HLOOKUP(F60,'Variable priser'!$C$59:$H$64,6))/F60*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Skyllevand-/slamhåndteringsanlæg - jordbassiner","m³",{"$f":"Genanskaffelsespriser!$E$55","v":50},0,0,0,0,0,null,{"$f":"IF(E61=0,\"Variabel pris\",IFERROR((HLOOKUP(E61,'Variable priser'!$C$59:$H$67,8)+(E61-HLOOKUP(E61,'Variable priser'!$C$59:$H$67,1))*HLOOKUP(E61,'Variable priser'!$C$59:$H$67,9))/E61*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F61=0,\"Variabel pris\",IFERROR((HLOOKUP(F61,'Variable priser'!$C$59:$H$67,8)+(F61-HLOOKUP(F61,'Variable priser'!$C$59:$H$67,1))*HLOOKUP(F61,'Variable priser'!$C$59:$H$67,9))/F61*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Skyllevandsbehandling, inkl. UV-filter mv., Mek./EL","m³/h.",{"$f":"Genanskaffelsespriser!$E$56","v":25},0,0,0,0,0,null,{"$f":"IF(E62=0,\"Variabel pris\",IFERROR((HLOOKUP(E62,'Variable priser'!$C$108:$E$110,2)+(E62-HLOOKUP(E62,'Variable priser'!$C$108:$E$110,1))*HLOOKUP(E62,'Variable priser'!$C$108:$E$110,3))/E62*'Variable priser'!$H$109*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F62=0,\"Variabel pris\",IFERROR((HLOOKUP(F62,'Variable priser'!$C$108:$E$110,2)+(F62-HLOOKUP(F62,'Variable priser'!$C$108:$E$110,1))*HLOOKUP(F62,'Variable priser'!$C$108:$E$110,3))/F62*'Variable priser'!$H$109*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Skyllevandsbehandling, inkl. UV-filter mv., SRO","m³/h.",{"$f":"Genanskaffelsespriser!$E$57","v":10},0,0,0,0,0,null,{"$f":"IF(E63=0,\"Variabel pris\",IFERROR((HLOOKUP(E63,'Variable priser'!$C$108:$E$110,2)+(E63-HLOOKUP(E63,'Variable priser'!$C$108:$E$110,1))*HLOOKUP(E63,'Variable priser'!$C$108:$E$110,3))/E63*'Variable priser'!$I$109*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F63=0,\"Variabel pris\",IFERROR((HLOOKUP(F63,'Variable priser'!$C$108:$E$110,2)+(F63-HLOOKUP(F63,'Variable priser'!$C$108:$E$110,1))*HLOOKUP(F63,'Variable priser'!$C$108:$E$110,3))/F63*'Variable priser'!$I$109*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Nødstrømsanlæg på vandværk","kW",{"$f":"Genanskaffelsespriser!$E$58","v":25},150,0,0,-1,0,"Vi har ikke anlægget mere",{"$f":"IF(E64=0,\"Variabel pris\",IFERROR((HLOOKUP(E64,'Variable priser'!$C$86:$H$88,2)+(E64-HLOOKUP(E64,'Variable priser'!$C$86:$H$88,1))*HLOOKUP(E64,'Variable priser'!$C$86:$H$88,3))/E64*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F64=0,\"Variabel pris\",IFERROR((HLOOKUP(F64,'Variable priser'!$C$86:$H$88,2)+(F64-HLOOKUP(F64,'Variable priser'!$C$86:$H$88,1))*HLOOKUP(F64,'Variable priser'!$C$86:$H$88,3))/F64*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Elanlæg og SRO-anlæg - vandværk, Elanlæg","m³/h.",{"$f":"Genanskaffelsespriser!$E$59","v":25},150,150,150,0,0,null,{"$f":"IF(E65=0,\"Variabel pris\",IFERROR((HLOOKUP(E65,'Variable priser'!$C$91:$J$95,4)+(E65-HLOOKUP(E65,'Variable priser'!$C$91:$J$95,1))*HLOOKUP(E65,'Variable priser'!$C$91:$J$95,5))/E65*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":3944.0013599999997},{"$f":"IF(F65=0,\"Variabel pris\",IFERROR((HLOOKUP(F65,'Variable priser'!$C$91:$J$95,4)+(F65-HLOOKUP(F65,'Variable priser'!$C$91:$J$95,1))*HLOOKUP(F65,'Variable priser'!$C$91:$J$95,5))/F65*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":3944.0013599999997},23664.008159999998,23664.008159999998,1,1]
["Elanlæg og SRO-anlæg - vandværk, SRO","m³/h.",{"$f":"Genanskaffelsespriser!$E$60","v":10},150,150,150,0,0,null,{"$f":"IF(E66=0,\"Variabel pris\",IFERROR((HLOOKUP(E66,'Variable priser'!$C$91:$J$98,7)+(E66-HLOOKUP(E66,'Variable priser'!$C$91:$J$98,1))*HLOOKUP(E66,'Variable priser'!$C$91:$J$98,8))/E66*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":2292.2401066666666},{"$f":"IF(F66=0,\"Variabel pris\",IFERROR((HLOOKUP(F66,'Variable priser'!$C$91:$J$98,7)+(F66-HLOOKUP(F66,'Variable priser'!$C$91:$J$98,1))*HLOOKUP(F66,'Variable priser'!$C$91:$J$98,8))/F66*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":2292.2401066666666},34383.601600000002,34383.601600000002,1,1]
["Vandværk 2"]
["Beluftningsanlæg, iltningstrappe, Konstruktioner","m³/h ",{"$f":"Genanskaffelsespriser!$E$30","v":50},0,0,0,0,{"$f":"IF($E68=\"\",IF($F68>0,\"Ny data\",IF($F68=\"\",\"\",0)),IF($E68=0,IF($F68=0,0,\"Ny data\"),($F68-$E68)/$E68))","v":0},null,{"$f":"IF(E68=0,\"Variabel pris\",IFERROR((HLOOKUP(E68,'Variable priser'!$C$6:$H$16,2)+(E68-HLOOKUP(E68,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E68,'Variable priser'!$C$6:$H$16,3))/E68*'Variable priser'!$K$7*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F68=0,\"Variabel pris\",IFERROR((HLOOKUP(F68,'Variable priser'!$C$6:$H$16,2)+(F68-HLOOKUP(F68,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F68,'Variable priser'!$C$6:$H$16,3))/F68*'Variable priser'!$K$7*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(ISBLANK(E68),\"\",IF(E68=0,\"\",IF(ISNUMBER(E68),((J68*E68)/C68)*N68,\"\")))","v":""},{"$f":"IF(ISBLANK(F68),\"\",IF(F68=0,\"\",IF(ISNUMBER(F68),((K68*F68)/C68)*N68,\"\")))","v":""},1,1]
["Beluftningsanlæg, iltningstrappe, Mek./EL","m³/h ",{"$f":"Genanskaffelsespriser!$E$31","v":25},0,0,0,0,0,null,{"$f":"IF(E69=0,\"Variabel pris\",IFERROR((HLOOKUP(E69,'Variable priser'!$C$6:$H$16,2)+(E69-HLOOKUP(E69,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E69,'Variable priser'!$C$6:$H$16,3))/E69*'Variable priser'!$L$7*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F69=0,\"Variabel pris\",IFERROR((HLOOKUP(F69,'Variable priser'!$C$6:$H$16,2)+(F69-HLOOKUP(F69,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F69,'Variable priser'!$C$6:$H$16,3))/F69*'Variable priser'!$L$7*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(ISBLANK(E69),\"\",IF(E69=0,\"\",IF(ISNUMBER(E69),((J69*E69)/C69)*N69,\"\")))","v":""},{"$f":"IF(ISBLANK(F69),\"\",IF(F69=0,\"\",IF(ISNUMBER(F69),((K69*F69)/C69)*N69,\"\")))","v":""},1,1]
["Beluftningsanlæg, ika-beluftning, Konstruktioner","m³/h ",{"$f":"Genanskaffelsespriser!$E$32","v":50},0,0,0,0,0,null,{"$f":"IF(E70=0,\"Variabel pris\",IFERROR((HLOOKUP(E70,'Variable priser'!$C$6:$H$16,4)+(E70-HLOOKUP(E70,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E70,'Variable priser'!$C$6:$H$16,5))/E70*'Variable priser'!$K$9*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F70=0,\"Variabel pris\",IFERROR((HLOOKUP(F70,'Variable priser'!$C$6:$H$16,4)+(F70-HLOOKUP(F70,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F70,'Variable priser'!$C$6:$H$16,5))/F70*'Variable priser'!$K$9*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Beluftningsanlæg, ika-beluftning, Mek./EL","m³/h ",{"$f":"Genanskaffelsespriser!$E$33","v":25},0,0,0,0,0,null,{"$f":"IF(E71=0,\"Variabel pris\",IFERROR((HLOOKUP(E71,'Variable priser'!$C$6:$H$16,4)+(E71-HLOOKUP(E71,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E71,'Variable priser'!$C$6:$H$16,5))/E71*'Variable priser'!$L$9*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F71=0,\"Variabel pris\",IFERROR((HLOOKUP(F71,'Variable priser'!$C$6:$H$16,4)+(F71-HLOOKUP(F71,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F71,'Variable priser'!$C$6:$H$16,5))/F71*'Variable priser'!$L$9*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Beluftningsanlæg, bundbeluftbning, Konstruktioner","m³/h ",{"$f":"Genanskaffelsespriser!$E$34","v":50},120,120,120,0,0,null,{"$f":"IF(E72=0,\"Variabel pris\",IFERROR((HLOOKUP(E72,'Variable priser'!$C$6:$H$16,6)+(E72-HLOOKUP(E72,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E72,'Variable priser'!$C$6:$H$16,7))/E72*'Variable priser'!$K$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":2695.9221296279998},{"$f":"IF(F72=0,\"Variabel pris\",IFERROR((HLOOKUP(F72,'Variable priser'!$C$6:$H$16,6)+(F72-HLOOKUP(F72,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F72,'Variable priser'!$C$6:$H$16,7))/F72*'Variable priser'!$K$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":2695.9221296279998},6470.2131111071994,6470.2131111071994,1,1]
["Beluftningsanlæg, bundbeluftbning, Mek./EL","m³/h ",{"$f":"Genanskaffelsespriser!$E$35","v":25},120,120,120,0,0,null,{"$f":"IF(E73=0,\"Variabel pris\",IFERROR((HLOOKUP(E73,'Variable priser'!$C$6:$H$16,6)+(E73-HLOOKUP(E73,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E73,'Variable priser'!$C$6:$H$16,7))/E73*'Variable priser'!$L$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":1155.3951984119999},{"$f":"IF(F73=0,\"Variabel pris\",IFERROR((HLOOKUP(F73,'Variable priser'!$C$6:$H$16,6)+(F73-HLOOKUP(F73,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F73,'Variable priser'!$C$6:$H$16,7))/F73*'Variable priser'!$L$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":1155.3951984119999},5545.8969523775995,5545.8969523775995,1,1]
["Beluftningsanlæg, rislebakke, Konstruktioner","m³/h ",{"$f":"Genanskaffelsespriser!$E$36","v":50},0,0,0,0,0,null,{"$f":"IF(E74=0,\"Variabel pris\",IFERROR((HLOOKUP(E74,'Variable priser'!$C$6:$H$18,12)+(E74-HLOOKUP(E74,'Variable priser'!$C$6:$H$18,1))*HLOOKUP(E74,'Variable priser'!$C$6:$H$18,13))/E74*'Variable priser'!$K$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F74=0,\"Variabel pris\",IFERROR((HLOOKUP(F74,'Variable priser'!$C$6:$H$18,12)+(F74-HLOOKUP(F74,'Variable priser'!$C$6:$H$18,1))*HLOOKUP(F74,'Variable priser'!$C$6:$H$18,13))/F74*'Variable priser'!$K$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Beluftningsanlæg, rislebakke, Mek./EL","m³/h ",{"$f":"Genanskaffelsespriser!$E$37","v":25},0,0,0,0,0,null,{"$f":"IF(E75=0,\"Variabel pris\",IFERROR((HLOOKUP(E75,'Variable priser'!$C$6:$H$18,12)+(E75-HLOOKUP(E75,'Variable priser'!$C$6:$H$18,1))*HLOOKUP(E75,'Variable priser'!$C$6:$H$18,13))/E75*'Variable priser'!$L$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F75=0,\"Variabel pris\",IFERROR((HLOOKUP(F75,'Variable priser'!$C$6:$H$18,12)+(F75-HLOOKUP(F75,'Variable priser'!$C$6:$H$18,1))*HLOOKUP(F75,'Variable priser'!$C$6:$H$18,13))/F75*'Variable priser'!$L$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Beluftningsanlæg, kompressorbeluftning","m³/h ",{"$f":"Genanskaffelsespriser!$E$38","v":25},600,600,600,0,0,null,{"$f":"IF(E76=0,\"Variabel pris\",IFERROR((HLOOKUP(E76,'Variable priser'!$C$6:$H$16,8)+(E76-HLOOKUP(E76,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E76,'Variable priser'!$C$6:$H$16,9))/E76*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":530.68729410666651},{"$f":"IF(F76=0,\"Variabel pris\",IFERROR((HLOOKUP(F76,'Variable priser'!$C$6:$H$16,8)+(F76-HLOOKUP(F76,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F76,'Variable priser'!$C$6:$H$16,9))/F76*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":530.68729410666651},12736.495058559996,12736.495058559996,1,1]
["Beluftningsanlæg, ren ilt","m³/h ",{"$f":"Genanskaffelsespriser!$E$39","v":25},0,0,0,0,0,null,{"$f":"IF(E77=0,\"Variabel pris\",IFERROR((HLOOKUP(E77,'Variable priser'!$C$6:$H$16,10)+(E77-HLOOKUP(E77,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E77,'Variable priser'!$C$6:$H$16,11))/E77*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F77=0,\"Variabel pris\",IFERROR((HLOOKUP(F77,'Variable priser'!$C$6:$H$16,10)+(F77-HLOOKUP(F77,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F77,'Variable priser'!$C$6:$H$16,11))/F77*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Behandlingsanlæg, kalk anlæg","m³/h ",{"$f":"Genanskaffelsespriser!$E$40","v":25},0,0,0,0,0,null,{"$f":"IF(E78=0,\"Variabel pris\",IFERROR((HLOOKUP(E78,'Variable priser'!$C$20:$G$24,3)+(E78-HLOOKUP(E78,'Variable priser'!$C$20:$G$24,1))*HLOOKUP(E78,'Variable priser'!$C$20:$G$24,4))/E78*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F78=0,\"Variabel pris\",IFERROR((HLOOKUP(F78,'Variable priser'!$C$20:$G$24,3)+(F78-HLOOKUP(F78,'Variable priser'!$C$20:$G$24,1))*HLOOKUP(F78,'Variable priser'!$C$20:$G$24,4))/F78*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Behandlingsanlæg, luddosering","m³/h ",{"$f":"Genanskaffelsespriser!$E$41","v":25},0,0,0,0,0,null,{"$f":"IF(E79=0,\"Variabel pris\",IFERROR((HLOOKUP(E79,'Variable priser'!$C$20:$G$25,5)+(E79-HLOOKUP(E79,'Variable priser'!$C$20:$G$25,1))*HLOOKUP(E79,'Variable priser'!$C$20:$G$25,6))/E79*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F79=0,\"Variabel pris\",IFERROR((HLOOKUP(F79,'Variable priser'!$C$20:$G$25,5)+(F79-HLOOKUP(F79,'Variable priser'!$C$20:$G$25,1))*HLOOKUP(F79,'Variable priser'!$C$20:$G$25,6))/F79*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Filteranlæg, åbne filtre, enkelt filtrering, Konstruktioner","m³/h ",{"$f":"Genanskaffelsespriser!$E$42","v":50},0,0,0,0,0,null,{"$f":"IF(E80=0,\"Variabel pris\",IFERROR((HLOOKUP(E80,'Variable priser'!$C$28:$G$38,9)+(E80-HLOOKUP(E80,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(E80,'Variable priser'!$C$28:$G$38,10))/E80*'Variable priser'!$K$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F80=0,\"Variabel pris\",IFERROR((HLOOKUP(F80,'Variable priser'!$C$28:$G$38,9)+(F80-HLOOKUP(F80,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(F80,'Variable priser'!$C$28:$G$38,10))/F80*'Variable priser'!$K$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Filteranlæg, åbne filtre, enkelt filtrering, Mek./EL","m³/h ",{"$f":"Genanskaffelsespriser!$E$43","v":25},0,0,0,0,0,null,{"$f":"IF(E81=0,\"Variabel pris\",IFERROR((HLOOKUP(E81,'Variable priser'!$C$28:$G$38,9)+(E81-HLOOKUP(E81,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(E81,'Variable priser'!$C$28:$G$38,10))/E81*'Variable priser'!$L$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F81=0,\"Variabel pris\",IFERROR((HLOOKUP(F81,'Variable priser'!$C$28:$G$38,9)+(F81-HLOOKUP(F81,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(F81,'Variable priser'!$C$28:$G$38,10))/F81*'Variable priser'!$L$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Filteranlæg, åbne filtre, dobbelt filtrering, Konstruktioner","m³/h ",{"$f":"Genanskaffelsespriser!$E$44","v":50},120,120,120,0,0,null,{"$f":"IF(E82=0,\"Variabel pris\",IFERROR((HLOOKUP(E82,'Variable priser'!$C$28:$G$38,6)+(E82-HLOOKUP(E82,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(E82,'Variable priser'!$C$28:$G$38,7))/E82*'Variable priser'!$K$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":10209.866659104},{"$f":"IF(F82=0,\"Variabel pris\",IFERROR((HLOOKUP(F82,'Variable priser'!$C$28:$G$38,6)+(F82-HLOOKUP(F82,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(F82,'Variable priser'!$C$28:$G$38,7))/F82*'Variable priser'!$K$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":10209.866659104},24503.6799818496,24503.6799818496,1,1]
["Filteranlæg, åbne filtre, dobbelt filtrering, Mek./EL","m³/h ",{"$f":"Genanskaffelsespriser!$E$45","v":25},120,120,120,0,0,null,{"$f":"IF(E83=0,\"Variabel pris\",IFERROR((HLOOKUP(E83,'Variable priser'!$C$28:$G$38,6)+(E83-HLOOKUP(E83,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(E83,'Variable priser'!$C$28:$G$38,7))/E83*'Variable priser'!$L$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":15314.799988655997},{"$f":"IF(F83=0,\"Variabel pris\",IFERROR((HLOOKUP(F83,'Variable priser'!$C$28:$G$38,6)+(F83-HLOOKUP(F83,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(F83,'Variable priser'!$C$28:$G$38,7))/F83*'Variable priser'!$L$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":15314.799988655997},73511.039945548793,73511.039945548793,1,1]
["Filteranlæg, trykfiltre, enkelt filtrering","m³/h ",{"$f":"Genanskaffelsespriser!$E$46","v":25},0,0,0,0,0,null,{"$f":"IF(E84=0,\"Variabel pris\",IFERROR((HLOOKUP(E84,'Variable priser'!$C$40:$H$42,2)+(E84-HLOOKUP(E84,'Variable priser'!$C$40:$H$42,1))*HLOOKUP(E84,'Variable priser'!$C$40:$H$42,3))/E84*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F84=0,\"Variabel pris\",IFERROR((HLOOKUP(F84,'Variable priser'!$C$40:$H$42,2)+(F84-HLOOKUP(F84,'Variable priser'!$C$40:$H$42,1))*HLOOKUP(F84,'Variable priser'!$C$40:$H$42,3))/F84*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Filteranlæg, trykfiltre, dobbelt filtrering","m³/h ",{"$f":"Genanskaffelsespriser!$E$47","v":25},0,0,0,0,0,null,{"$f":"IF(E85=0,\"Variabel pris\",IFERROR((HLOOKUP(E85,'Variable priser'!$C$44:$H$46,2)+(E85-HLOOKUP(E85,'Variable priser'!$C$44:$H$46,1))*HLOOKUP(E85,'Variable priser'!$C$44:$H$46,3))/E85*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F85=0,\"Variabel pris\",IFERROR((HLOOKUP(F85,'Variable priser'!$C$44:$H$46,2)+(F85-HLOOKUP(F85,'Variable priser'!$C$44:$H$46,1))*HLOOKUP(F85,'Variable priser'!$C$44:$H$46,3))/F85*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Rentvandsbeholder  insitu støbt","m³",{"$f":"Genanskaffelsespriser!$E$48","v":50},400,400,400,0,0,null,{"$f":"IF(E86=0,\"Variabel pris\",IFERROR((HLOOKUP(E86,'Variable priser'!$C$48:$H$50,2)+(E86-HLOOKUP(E86,'Variable priser'!$C$48:$H$50,1))*HLOOKUP(E86,'Variable priser'!$C$48:$H$50,3))/E86*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":4893.9747644999989},{"$f":"IF(F86=0,\"Variabel pris\",IFERROR((HLOOKUP(F86,'Variable priser'!$C$48:$H$50,2)+(F86-HLOOKUP(F86,'Variable priser'!$C$48:$H$50,1))*HLOOKUP(F86,'Variable priser'!$C$48:$H$50,3))/F86*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":4893.9747644999989},39151.798115999991,39151.798115999991,1,1]
["Rentvandsbeholder  element","m³",{"$f":"Genanskaffelsespriser!$E$49","v":50},0,0,0,0,0,null,{"$f":"IF(E87=0,\"Variabel pris\",IFERROR((HLOOKUP(E87,'Variable priser'!$C$52:$H$54,2)+(E87-HLOOKUP(E87,'Variable priser'!$C$52:$H$54,1))*HLOOKUP(E87,'Variable priser'!$C$52:$H$54,3))/E87*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F87=0,\"Variabel pris\",IFERROR((HLOOKUP(F87,'Variable priser'!$C$52:$H$54,2)+(F87-HLOOKUP(F87,'Variable priser'!$C$52:$H$54,1))*HLOOKUP(F87,'Variable priser'!$C$52:$H$54,3))/F87*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Udpumpningsanlæg, rentvandspumper på vandværk","m³/h ",{"$f":"Genanskaffelsespriser!$E$50","v":25},130,130,130,0,0,null,{"$f":"IF(E88=0,\"Variabel pris\",IFERROR((HLOOKUP(E88,'Variable priser'!$C$71:$H$73,2)+(E88-HLOOKUP(E88,'Variable priser'!$C$71:$H$73,1))*HLOOKUP(E88,'Variable priser'!$C$71:$H$73,3))/E88*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":1395.3752346153847},{"$f":"IF(F88=0,\"Variabel pris\",IFERROR((HLOOKUP(F88,'Variable priser'!$C$71:$H$73,2)+(F88-HLOOKUP(F88,'Variable priser'!$C$71:$H$73,1))*HLOOKUP(F88,'Variable priser'!$C$71:$H$73,3))/F88*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":1395.3752346153847},7255.9512199999999,7255.9512199999999,1,1]
["Udpumpningsanlæg, frekvensomformer","kW",{"$f":"Genanskaffelsespriser!$E$51","v":25},37,37,37,0,0,null,{"$f":"IF(E89=0,\"Variabel pris\",IFERROR((HLOOKUP(E89,'Variable priser'!$C$76:$J$78,2)+(E89-HLOOKUP(E89,'Variable priser'!$C$76:$J$78,1))*HLOOKUP(E89,'Variable priser'!$C$76:$J$78,3))/E89*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":3710.3131297297341},{"$f":"IF(F89=0,\"Variabel pris\",IFERROR((HLOOKUP(F89,'Variable priser'!$C$76:$J$78,2)+(F89-HLOOKUP(F89,'Variable priser'!$C$76:$J$78,1))*HLOOKUP(F89,'Variable priser'!$C$76:$J$78,3))/F89*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":3710.3131297297341},5491.263432000007,5491.263432000007,1,1]
["Udpumpningsanlæg, Hydrofor","liter",{"$f":"Genanskaffelsespriser!$E$52","v":25},null,0,0,0,0,null,{"$f":"IF(E90=0,\"Variabel pris\",IFERROR((HLOOKUP(E90,'Variable priser'!$C$81:$J$83,2)+(E90-HLOOKUP(E90,'Variable priser'!$C$81:$J$83,1))*HLOOKUP(E90,'Variable priser'!$C$81:$J$83,3))/E90*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F90=0,\"Variabel pris\",IFERROR((HLOOKUP(F90,'Variable priser'!$C$81:$J$83,2)+(F90-HLOOKUP(F90,'Variable priser'!$C$81:$J$83,1))*HLOOKUP(F90,'Variable priser'!$C$81:$J$83,3))/F90*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Skyllevand-/slamhåndteringsanlæg - lukkede betonbeholdere","m³",{"$f":"Genanskaffelsespriser!$E$53","v":50},null,0,0,0,0,null,{"$f":"IF(E91=0,\"Variabel pris\",IFERROR((HLOOKUP(E91,'Variable priser'!$C$59:$H$61,2)+(E91-HLOOKUP(E91,'Variable priser'!$C$59:$H$61,1))*HLOOKUP(E91,'Variable priser'!$C$59:$H$61,3))/E91*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F91=0,\"Variabel pris\",IFERROR((HLOOKUP(F91,'Variable priser'!$C$59:$H$61,2)+(F91-HLOOKUP(F91,'Variable priser'!$C$59:$H$61,1))*HLOOKUP(F91,'Variable priser'!$C$59:$H$61,3))/F91*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Skyllevand-/slamhåndteringsanl. - åbne med faste sider/bund","m³",{"$f":"Genanskaffelsespriser!$E$54","v":50},null,0,0,0,0,null,{"$f":"IF(E92=0,\"Variabel pris\",IFERROR((HLOOKUP(E92,'Variable priser'!$C$59:$H$64,5)+(E92-HLOOKUP(E92,'Variable priser'!$C$59:$H$64,1))*HLOOKUP(E92,'Variable priser'!$C$59:$H$64,6))/E92*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F92=0,\"Variabel pris\",IFERROR((HLOOKUP(F92,'Variable priser'!$C$59:$H$64,5)+(F92-HLOOKUP(F92,'Variable priser'!$C$59:$H$64,1))*HLOOKUP(F92,'Variable priser'!$C$59:$H$64,6))/F92*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Skyllevand-/slamhåndteringsanlæg - jordbassiner","m³",{"$f":"Genanskaffelsespriser!$E$55","v":50},99,99,99,0,0,null,{"$f":"IF(E93=0,\"Variabel pris\",IFERROR((HLOOKUP(E93,'Variable priser'!$C$59:$H$67,8)+(E93-HLOOKUP(E93,'Variable priser'!$C$59:$H$67,1))*HLOOKUP(E93,'Variable priser'!$C$59:$H$67,9))/E93*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":391.36628879999995},{"$f":"IF(F93=0,\"Variabel pris\",IFERROR((HLOOKUP(F93,'Variable priser'!$C$59:$H$67,8)+(F93-HLOOKUP(F93,'Variable priser'!$C$59:$H$67,1))*HLOOKUP(F93,'Variable priser'!$C$59:$H$67,9))/F93*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":391.36628879999995},774.90525182399983,774.90525182399983,1,1]
["Skyllevandsbehandling, inkl. UV-filter mv., Mek./EL","m³/h.",{"$f":"Genanskaffelsespriser!$E$56","v":25},0,0,0,0,0,null,{"$f":"IF(E94=0,\"Variabel pris\",IFERROR((HLOOKUP(E94,'Variable priser'!$C$108:$E$110,2)+(E94-HLOOKUP(E94,'Variable priser'!$C$108:$E$110,1))*HLOOKUP(E94,'Variable priser'!$C$108:$E$110,3))/E94*'Variable priser'!$H$109*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F94=0,\"Variabel pris\",IFERROR((HLOOKUP(F94,'Variable priser'!$C$108:$E$110,2)+(F94-HLOOKUP(F94,'Variable priser'!$C$108:$E$110,1))*HLOOKUP(F94,'Variable priser'!$C$108:$E$110,3))/F94*'Variable priser'!$H$109*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Skyllevandsbehandling, inkl. UV-filter mv., SRO","m³/h.",{"$f":"Genanskaffelsespriser!$E$57","v":10},0,0,0,0,0,null,{"$f":"IF(E95=0,\"Variabel pris\",IFERROR((HLOOKUP(E95,'Variable priser'!$C$108:$E$110,2)+(E95-HLOOKUP(E95,'Variable priser'!$C$108:$E$110,1))*HLOOKUP(E95,'Variable priser'!$C$108:$E$110,3))/E95*'Variable priser'!$I$109*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F95=0,\"Variabel pris\",IFERROR((HLOOKUP(F95,'Variable priser'!$C$108:$E$110,2)+(F95-HLOOKUP(F95,'Variable priser'!$C$108:$E$110,1))*HLOOKUP(F95,'Variable priser'!$C$108:$E$110,3))/F95*'Variable priser'!$I$109*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Nødstrømsanlæg på vandværk","kW",{"$f":"Genanskaffelsespriser!$E$58","v":25},0,0,0,0,0,null,{"$f":"IF(E96=0,\"Variabel pris\",IFERROR((HLOOKUP(E96,'Variable priser'!$C$86:$H$88,2)+(E96-HLOOKUP(E96,'Variable priser'!$C$86:$H$88,1))*HLOOKUP(E96,'Variable priser'!$C$86:$H$88,3))/E96*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F96=0,\"Variabel pris\",IFERROR((HLOOKUP(F96,'Variable priser'!$C$86:$H$88,2)+(F96-HLOOKUP(F96,'Variable priser'!$C$86:$H$88,1))*HLOOKUP(F96,'Variable priser'!$C$86:$H$88,3))/F96*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Elanlæg og SRO-anlæg - vandværk, Elanlæg","m³/h.",{"$f":"Genanskaffelsespriser!$E$59","v":25},120,120,120,0,0,null,{"$f":"IF(E97=0,\"Variabel pris\",IFERROR((HLOOKUP(E97,'Variable priser'!$C$91:$J$95,4)+(E97-HLOOKUP(E97,'Variable priser'!$C$91:$J$95,1))*HLOOKUP(E97,'Variable priser'!$C$91:$J$95,5))/E97*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":4437.0015300000005},{"$f":"IF(F97=0,\"Variabel pris\",IFERROR((HLOOKUP(F97,'Variable priser'!$C$91:$J$95,4)+(F97-HLOOKUP(F97,'Variable priser'!$C$91:$J$95,1))*HLOOKUP(F97,'Variable priser'!$C$91:$J$95,5))/F97*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":4437.0015300000005},21297.607344000004,21297.607344000004,1,1]
["Elanlæg og SRO-anlæg - vandværk, SRO","m³/h.",{"$f":"Genanskaffelsespriser!$E$60","v":10},120,120,120,0,0,null,{"$f":"IF(E98=0,\"Variabel pris\",IFERROR((HLOOKUP(E98,'Variable priser'!$C$91:$J$98,7)+(E98-HLOOKUP(E98,'Variable priser'!$C$91:$J$98,1))*HLOOKUP(E98,'Variable priser'!$C$91:$J$98,8))/E98*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":2764.1718933333332},{"$f":"IF(F98=0,\"Variabel pris\",IFERROR((HLOOKUP(F98,'Variable priser'!$C$91:$J$98,7)+(F98-HLOOKUP(F98,'Variable priser'!$C$91:$J$98,1))*HLOOKUP(F98,'Variable priser'!$C$91:$J$98,8))/F98*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":2764.1718933333332},33170.062720000002,33170.062720000002,1,1]
["Vandværk 3"]
["Beluftningsanlæg, iltningstrappe, Konstruktioner","m³/h ",{"$f":"Genanskaffelsespriser!$E$30","v":50},0,0,0,0,0,null,{"$f":"IF(E100=0,\"Variabel pris\",IFERROR((HLOOKUP(E100,'Variable priser'!$C$6:$H$16,2)+(E100-HLOOKUP(E100,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E100,'Variable priser'!$C$6:$H$16,3))/E100*'Variable priser'!$K$7*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F100=0,\"Variabel pris\",IFERROR((HLOOKUP(F100,'Variable priser'!$C$6:$H$16,2)+(F100-HLOOKUP(F100,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F100,'Variable priser'!$C$6:$H$16,3))/F100*'Variable priser'!$K$7*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(ISBLANK(E100),\"\",IF(E100=0,\"\",IF(ISNUMBER(E100),((J100*E100)/C100)*N100,\"\")))","v":""},{"$f":"IF(ISBLANK(F100),\"\",IF(F100=0,\"\",IF(ISNUMBER(F100),((K100*F100)/C100)*N100,\"\")))","v":""},1,1]
["Beluftningsanlæg, iltningstrappe, Mek./EL","m³/h ",{"$f":"Genanskaffelsespriser!$E$31","v":25},0,0,0,0,0,null,{"$f":"IF(E101=0,\"Variabel pris\",IFERROR((HLOOKUP(E101,'Variable priser'!$C$6:$H$16,2)+(E101-HLOOKUP(E101,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E101,'Variable priser'!$C$6:$H$16,3))/E101*'Variable priser'!$L$7*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F101=0,\"Variabel pris\",IFERROR((HLOOKUP(F101,'Variable priser'!$C$6:$H$16,2)+(F101-HLOOKUP(F101,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F101,'Variable priser'!$C$6:$H$16,3))/F101*'Variable priser'!$L$7*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(ISBLANK(E101),\"\",IF(E101=0,\"\",IF(ISNUMBER(E101),((J101*E101)/C101)*N101,\"\")))","v":""},{"$f":"IF(ISBLANK(F101),\"\",IF(F101=0,\"\",IF(ISNUMBER(F101),((K101*F101)/C101)*N101,\"\")))","v":""},1,1]
["Beluftningsanlæg, ika-beluftning, Konstruktioner","m³/h ",{"$f":"Genanskaffelsespriser!$E$32","v":50},0,0,0,0,0,null,{"$f":"IF(E102=0,\"Variabel pris\",IFERROR((HLOOKUP(E102,'Variable priser'!$C$6:$H$16,4)+(E102-HLOOKUP(E102,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E102,'Variable priser'!$C$6:$H$16,5))/E102*'Variable priser'!$K$9*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F102=0,\"Variabel pris\",IFERROR((HLOOKUP(F102,'Variable priser'!$C$6:$H$16,4)+(F102-HLOOKUP(F102,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F102,'Variable priser'!$C$6:$H$16,5))/F102*'Variable priser'!$K$9*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Beluftningsanlæg, ika-beluftning, Mek./EL","m³/h ",{"$f":"Genanskaffelsespriser!$E$33","v":25},0,0,0,0,0,null,{"$f":"IF(E103=0,\"Variabel pris\",IFERROR((HLOOKUP(E103,'Variable priser'!$C$6:$H$16,4)+(E103-HLOOKUP(E103,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E103,'Variable priser'!$C$6:$H$16,5))/E103*'Variable priser'!$L$9*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F103=0,\"Variabel pris\",IFERROR((HLOOKUP(F103,'Variable priser'!$C$6:$H$16,4)+(F103-HLOOKUP(F103,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F103,'Variable priser'!$C$6:$H$16,5))/F103*'Variable priser'!$L$9*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Beluftningsanlæg, bundbeluftbning, Konstruktioner","m³/h ",{"$f":"Genanskaffelsespriser!$E$34","v":50},250,250,250,0,0,null,{"$f":"IF(E104=0,\"Variabel pris\",IFERROR((HLOOKUP(E104,'Variable priser'!$C$6:$H$16,6)+(E104-HLOOKUP(E104,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E104,'Variable priser'!$C$6:$H$16,7))/E104*'Variable priser'!$K$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":2145.1423397039998},{"$f":"IF(F104=0,\"Variabel pris\",IFERROR((HLOOKUP(F104,'Variable priser'!$C$6:$H$16,6)+(F104-HLOOKUP(F104,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F104,'Variable priser'!$C$6:$H$16,7))/F104*'Variable priser'!$K$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":2145.1423397039998},10725.711698519999,10725.711698519999,1,1]
["Beluftningsanlæg, bundbeluftbning, Mek./EL","m³/h ",{"$f":"Genanskaffelsespriser!$E$35","v":25},250,250,250,0,0,null,{"$f":"IF(E105=0,\"Variabel pris\",IFERROR((HLOOKUP(E105,'Variable priser'!$C$6:$H$16,6)+(E105-HLOOKUP(E105,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E105,'Variable priser'!$C$6:$H$16,7))/E105*'Variable priser'!$L$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":919.34671701599996},{"$f":"IF(F105=0,\"Variabel pris\",IFERROR((HLOOKUP(F105,'Variable priser'!$C$6:$H$16,6)+(F105-HLOOKUP(F105,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F105,'Variable priser'!$C$6:$H$16,7))/F105*'Variable priser'!$L$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":919.34671701599996},9193.46717016,9193.46717016,1,1]
["Beluftningsanlæg, rislebakke, Konstruktioner","m³/h ",{"$f":"Genanskaffelsespriser!$E$36","v":50},0,0,0,0,0,null,{"$f":"IF(E106=0,\"Variabel pris\",IFERROR((HLOOKUP(E106,'Variable priser'!$C$6:$H$18,12)+(E106-HLOOKUP(E106,'Variable priser'!$C$6:$H$18,1))*HLOOKUP(E106,'Variable priser'!$C$6:$H$18,13))/E106*'Variable priser'!$K$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F106=0,\"Variabel pris\",IFERROR((HLOOKUP(F106,'Variable priser'!$C$6:$H$18,12)+(F106-HLOOKUP(F106,'Variable priser'!$C$6:$H$18,1))*HLOOKUP(F106,'Variable priser'!$C$6:$H$18,13))/F106*'Variable priser'!$K$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Beluftningsanlæg, rislebakke, Mek./EL","m³/h ",{"$f":"Genanskaffelsespriser!$E$37","v":25},0,0,0,0,0,null,{"$f":"IF(E107=0,\"Variabel pris\",IFERROR((HLOOKUP(E107,'Variable priser'!$C$6:$H$18,12)+(E107-HLOOKUP(E107,'Variable priser'!$C$6:$H$18,1))*HLOOKUP(E107,'Variable priser'!$C$6:$H$18,13))/E107*'Variable priser'!$L$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F107=0,\"Variabel pris\",IFERROR((HLOOKUP(F107,'Variable priser'!$C$6:$H$18,12)+(F107-HLOOKUP(F107,'Variable priser'!$C$6:$H$18,1))*HLOOKUP(F107,'Variable priser'!$C$6:$H$18,13))/F107*'Variable priser'!$L$17*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Beluftningsanlæg, kompressorbeluftning","m³/h ",{"$f":"Genanskaffelsespriser!$E$38","v":25},0,0,0,0,0,null,{"$f":"IF(E108=0,\"Variabel pris\",IFERROR((HLOOKUP(E108,'Variable priser'!$C$6:$H$16,8)+(E108-HLOOKUP(E108,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E108,'Variable priser'!$C$6:$H$16,9))/E108*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F108=0,\"Variabel pris\",IFERROR((HLOOKUP(F108,'Variable priser'!$C$6:$H$16,8)+(F108-HLOOKUP(F108,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F108,'Variable priser'!$C$6:$H$16,9))/F108*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Beluftningsanlæg, ren ilt","m³/h ",{"$f":"Genanskaffelsespriser!$E$39","v":25},0,0,0,0,0,null,{"$f":"IF(E109=0,\"Variabel pris\",IFERROR((HLOOKUP(E109,'Variable priser'!$C$6:$H$16,10)+(E109-HLOOKUP(E109,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(E109,'Variable priser'!$C$6:$H$16,11))/E109*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F109=0,\"Variabel pris\",IFERROR((HLOOKUP(F109,'Variable priser'!$C$6:$H$16,10)+(F109-HLOOKUP(F109,'Variable priser'!$C$6:$H$16,1))*HLOOKUP(F109,'Variable priser'!$C$6:$H$16,11))/F109*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Behandlingsanlæg, kalk anlæg","m³/h ",{"$f":"Genanskaffelsespriser!$E$40","v":25},0,0,0,0,0,null,{"$f":"IF(E110=0,\"Variabel pris\",IFERROR((HLOOKUP(E110,'Variable priser'!$C$20:$G$24,3)+(E110-HLOOKUP(E110,'Variable priser'!$C$20:$G$24,1))*HLOOKUP(E110,'Variable priser'!$C$20:$G$24,4))/E110*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F110=0,\"Variabel pris\",IFERROR((HLOOKUP(F110,'Variable priser'!$C$20:$G$24,3)+(F110-HLOOKUP(F110,'Variable priser'!$C$20:$G$24,1))*HLOOKUP(F110,'Variable priser'!$C$20:$G$24,4))/F110*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Behandlingsanlæg, luddosering","m³/h ",{"$f":"Genanskaffelsespriser!$E$41","v":25},0,0,0,0,0,null,{"$f":"IF(E111=0,\"Variabel pris\",IFERROR((HLOOKUP(E111,'Variable priser'!$C$20:$G$25,5)+(E111-HLOOKUP(E111,'Variable priser'!$C$20:$G$25,1))*HLOOKUP(E111,'Variable priser'!$C$20:$G$25,6))/E111*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F111=0,\"Variabel pris\",IFERROR((HLOOKUP(F111,'Variable priser'!$C$20:$G$25,5)+(F111-HLOOKUP(F111,'Variable priser'!$C$20:$G$25,1))*HLOOKUP(F111,'Variable priser'!$C$20:$G$25,6))/F111*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Filteranlæg, åbne filtre, enkelt filtrering, Konstruktioner","m³/h ",{"$f":"Genanskaffelsespriser!$E$42","v":50},0,0,0,0,0,null,{"$f":"IF(E112=0,\"Variabel pris\",IFERROR((HLOOKUP(E112,'Variable priser'!$C$28:$G$38,9)+(E112-HLOOKUP(E112,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(E112,'Variable priser'!$C$28:$G$38,10))/E112*'Variable priser'!$K$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F112=0,\"Variabel pris\",IFERROR((HLOOKUP(F112,'Variable priser'!$C$28:$G$38,9)+(F112-HLOOKUP(F112,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(F112,'Variable priser'!$C$28:$G$38,10))/F112*'Variable priser'!$K$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Filteranlæg, åbne filtre, enkelt filtrering, Mek./EL","m³/h ",{"$f":"Genanskaffelsespriser!$E$43","v":25},0,0,0,0,0,null,{"$f":"IF(E113=0,\"Variabel pris\",IFERROR((HLOOKUP(E113,'Variable priser'!$C$28:$G$38,9)+(E113-HLOOKUP(E113,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(E113,'Variable priser'!$C$28:$G$38,10))/E113*'Variable priser'!$L$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F113=0,\"Variabel pris\",IFERROR((HLOOKUP(F113,'Variable priser'!$C$28:$G$38,9)+(F113-HLOOKUP(F113,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(F113,'Variable priser'!$C$28:$G$38,10))/F113*'Variable priser'!$L$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Filteranlæg, åbne filtre, dobbelt filtrering, Konstruktioner","m³/h ",{"$f":"Genanskaffelsespriser!$E$44","v":50},0,0,0,0,0,null,{"$f":"IF(E114=0,\"Variabel pris\",IFERROR((HLOOKUP(E114,'Variable priser'!$C$28:$G$38,6)+(E114-HLOOKUP(E114,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(E114,'Variable priser'!$C$28:$G$38,7))/E114*'Variable priser'!$K$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F114=0,\"Variabel pris\",IFERROR((HLOOKUP(F114,'Variable priser'!$C$28:$G$38,6)+(F114-HLOOKUP(F114,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(F114,'Variable priser'!$C$28:$G$38,7))/F114*'Variable priser'!$K$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Filteranlæg, åbne filtre, dobbelt filtrering, Mek./EL","m³/h ",{"$f":"Genanskaffelsespriser!$E$45","v":25},0,0,0,0,0,null,{"$f":"IF(E115=0,\"Variabel pris\",IFERROR((HLOOKUP(E115,'Variable priser'!$C$28:$G$38,6)+(E115-HLOOKUP(E115,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(E115,'Variable priser'!$C$28:$G$38,7))/E115*'Variable priser'!$L$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F115=0,\"Variabel pris\",IFERROR((HLOOKUP(F115,'Variable priser'!$C$28:$G$38,6)+(F115-HLOOKUP(F115,'Variable priser'!$C$28:$G$38,1))*HLOOKUP(F115,'Variable priser'!$C$28:$G$38,7))/F115*'Variable priser'!$L$31*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Filteranlæg, trykfiltre, enkelt filtrering","m³/h ",{"$f":"Genanskaffelsespriser!$E$46","v":25},0,0,0,0,0,null,{"$f":"IF(E116=0,\"Variabel pris\",IFERROR((HLOOKUP(E116,'Variable priser'!$C$40:$H$42,2)+(E116-HLOOKUP(E116,'Variable priser'!$C$40:$H$42,1))*HLOOKUP(E116,'Variable priser'!$C$40:$H$42,3))/E116*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F116=0,\"Variabel pris\",IFERROR((HLOOKUP(F116,'Variable priser'!$C$40:$H$42,2)+(F116-HLOOKUP(F116,'Variable priser'!$C$40:$H$42,1))*HLOOKUP(F116,'Variable priser'!$C$40:$H$42,3))/F116*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Filteranlæg, trykfiltre, dobbelt filtrering","m³/h ",{"$f":"Genanskaffelsespriser!$E$47","v":25},250,250,250,0,0,null,{"$f":"IF(E117=0,\"Variabel pris\",IFERROR((HLOOKUP(E117,'Variable priser'!$C$44:$H$46,2)+(E117-HLOOKUP(E117,'Variable priser'!$C$44:$H$46,1))*HLOOKUP(E117,'Variable priser'!$C$44:$H$46,3))/E117*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":15742.93650552},{"$f":"IF(F117=0,\"Variabel pris\",IFERROR((HLOOKUP(F117,'Variable priser'!$C$44:$H$46,2)+(F117-HLOOKUP(F117,'Variable priser'!$C$44:$H$46,1))*HLOOKUP(F117,'Variable priser'!$C$44:$H$46,3))/F117*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":15742.93650552},157429.3650552,157429.3650552,1,1]
["Rentvandsbeholder  insitu støbt","m³",{"$f":"Genanskaffelsespriser!$E$48","v":50},0,0,0,{"$f":"IF($D118=\"\",IF($E118>0,\"Ny data\",IF($E118=\"\",\"\",0)),IF($D118=0,IF($E118=0,0,\"Ny data\"),($E118-$D118)/$D118))","v":0},0,null,{"$f":"IF(E118=0,\"Variabel pris\",IFERROR((HLOOKUP(E118,'Variable priser'!$C$48:$H$50,2)+(E118-HLOOKUP(E118,'Variable priser'!$C$48:$H$50,1))*HLOOKUP(E118,'Variable priser'!$C$48:$H$50,3))/E118*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F118=0,\"Variabel pris\",IFERROR((HLOOKUP(F118,'Variable priser'!$C$48:$H$50,2)+(F118-HLOOKUP(F118,'Variable priser'!$C$48:$H$50,1))*HLOOKUP(F118,'Variable priser'!$C$48:$H$50,3))/F118*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Rentvandsbeholder  element","m³",{"$f":"Genanskaffelsespriser!$E$49","v":50},2000,2000,2000,0,0,null,{"$f":"IF(E119=0,\"Variabel pris\",IFERROR((HLOOKUP(E119,'Variable priser'!$C$52:$H$54,2)+(E119-HLOOKUP(E119,'Variable priser'!$C$52:$H$54,1))*HLOOKUP(E119,'Variable priser'!$C$52:$H$54,3))/E119*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":2589.9858723119996},{"$f":"IF(F119=0,\"Variabel pris\",IFERROR((HLOOKUP(F119,'Variable priser'!$C$52:$H$54,2)+(F119-HLOOKUP(F119,'Variable priser'!$C$52:$H$54,1))*HLOOKUP(F119,'Variable priser'!$C$52:$H$54,3))/F119*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":2589.9858723119996},103599.43489247999,103599.43489247999,1,1]
["Udpumpningsanlæg, rentvandspumper på vandværk","m³/h ",{"$f":"Genanskaffelsespriser!$E$50","v":25},600,600,600,0,0,null,{"$f":"IF(E120=0,\"Variabel pris\",IFERROR((HLOOKUP(E120,'Variable priser'!$C$71:$H$73,2)+(E120-HLOOKUP(E120,'Variable priser'!$C$71:$H$73,1))*HLOOKUP(E120,'Variable priser'!$C$71:$H$73,3))/E120*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":978.97754555555559},{"$f":"IF(F120=0,\"Variabel pris\",IFERROR((HLOOKUP(F120,'Variable priser'!$C$71:$H$73,2)+(F120-HLOOKUP(F120,'Variable priser'!$C$71:$H$73,1))*HLOOKUP(F120,'Variable priser'!$C$71:$H$73,3))/F120*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":978.97754555555559},23495.461093333335,23495.461093333335,1,1]
["Udpumpningsanlæg, frekvensomformer","kW",{"$f":"Genanskaffelsespriser!$E$51","v":25},90,90,90,0,0,null,{"$f":"IF(E121=0,\"Variabel pris\",IFERROR((HLOOKUP(E121,'Variable priser'!$C$76:$J$78,2)+(E121-HLOOKUP(E121,'Variable priser'!$C$76:$J$78,1))*HLOOKUP(E121,'Variable priser'!$C$76:$J$78,3))/E121*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":2597.3102973333384},{"$f":"IF(F121=0,\"Variabel pris\",IFERROR((HLOOKUP(F121,'Variable priser'!$C$76:$J$78,2)+(F121-HLOOKUP(F121,'Variable priser'!$C$76:$J$78,1))*HLOOKUP(F121,'Variable priser'!$C$76:$J$78,3))/F121*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":2597.3102973333384},9350.3170704000186,9350.3170704000186,1,1]
["Udpumpningsanlæg, Hydrofor","liter",{"$f":"Genanskaffelsespriser!$E$52","v":25},0,0,0,0,0,null,{"$f":"IF(E122=0,\"Variabel pris\",IFERROR((HLOOKUP(E122,'Variable priser'!$C$81:$J$83,2)+(E122-HLOOKUP(E122,'Variable priser'!$C$81:$J$83,1))*HLOOKUP(E122,'Variable priser'!$C$81:$J$83,3))/E122*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F122=0,\"Variabel pris\",IFERROR((HLOOKUP(F122,'Variable priser'!$C$81:$J$83,2)+(F122-HLOOKUP(F122,'Variable priser'!$C$81:$J$83,1))*HLOOKUP(F122,'Variable priser'!$C$81:$J$83,3))/F122*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Skyllevand-/slamhåndteringsanlæg - lukkede betonbeholdere","m³",{"$f":"Genanskaffelsespriser!$E$53","v":50},300,300,300,0,0,null,{"$f":"IF(E123=0,\"Variabel pris\",IFERROR((HLOOKUP(E123,'Variable priser'!$C$59:$H$61,2)+(E123-HLOOKUP(E123,'Variable priser'!$C$59:$H$61,1))*HLOOKUP(E123,'Variable priser'!$C$59:$H$61,3))/E123*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":4032.18518528},{"$f":"IF(F123=0,\"Variabel pris\",IFERROR((HLOOKUP(F123,'Variable priser'!$C$59:$H$61,2)+(F123-HLOOKUP(F123,'Variable priser'!$C$59:$H$61,1))*HLOOKUP(F123,'Variable priser'!$C$59:$H$61,3))/F123*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":4032.18518528},24193.111111679998,24193.111111679998,1,1]
["Skyllevand-/slamhåndteringsanl. - åbne med faste sider/bund","m³",{"$f":"Genanskaffelsespriser!$E$54","v":50},0,0,0,0,0,null,{"$f":"IF(E124=0,\"Variabel pris\",IFERROR((HLOOKUP(E124,'Variable priser'!$C$59:$H$64,5)+(E124-HLOOKUP(E124,'Variable priser'!$C$59:$H$64,1))*HLOOKUP(E124,'Variable priser'!$C$59:$H$64,6))/E124*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F124=0,\"Variabel pris\",IFERROR((HLOOKUP(F124,'Variable priser'!$C$59:$H$64,5)+(F124-HLOOKUP(F124,'Variable priser'!$C$59:$H$64,1))*HLOOKUP(F124,'Variable priser'!$C$59:$H$64,6))/F124*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Skyllevand-/slamhåndteringsanlæg - jordbassiner","m³",{"$f":"Genanskaffelsespriser!$E$55","v":50},0,0,0,0,0,null,{"$f":"IF(E125=0,\"Variabel pris\",IFERROR((HLOOKUP(E125,'Variable priser'!$C$59:$H$67,8)+(E125-HLOOKUP(E125,'Variable priser'!$C$59:$H$67,1))*HLOOKUP(E125,'Variable priser'!$C$59:$H$67,9))/E125*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F125=0,\"Variabel pris\",IFERROR((HLOOKUP(F125,'Variable priser'!$C$59:$H$67,8)+(F125-HLOOKUP(F125,'Variable priser'!$C$59:$H$67,1))*HLOOKUP(F125,'Variable priser'!$C$59:$H$67,9))/F125*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Skyllevandsbehandling, inkl. UV-filter mv., Mek./EL","m³/h.",{"$f":"Genanskaffelsespriser!$E$56","v":25},0,0,0,0,0,null,{"$f":"IF(E126=0,\"Variabel pris\",IFERROR((HLOOKUP(E126,'Variable priser'!$C$108:$E$110,2)+(E126-HLOOKUP(E126,'Variable priser'!$C$108:$E$110,1))*HLOOKUP(E126,'Variable priser'!$C$108:$E$110,3))/E126*'Variable priser'!$H$109*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F126=0,\"Variabel pris\",IFERROR((HLOOKUP(F126,'Variable priser'!$C$108:$E$110,2)+(F126-HLOOKUP(F126,'Variable priser'!$C$108:$E$110,1))*HLOOKUP(F126,'Variable priser'!$C$108:$E$110,3))/F126*'Variable priser'!$H$109*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Skyllevandsbehandling, inkl. UV-filter mv., SRO","m³/h.",{"$f":"Genanskaffelsespriser!$E$57","v":10},0,0,0,0,0,null,{"$f":"IF(E127=0,\"Variabel pris\",IFERROR((HLOOKUP(E127,'Variable priser'!$C$108:$E$110,2)+(E127-HLOOKUP(E127,'Variable priser'!$C$108:$E$110,1))*HLOOKUP(E127,'Variable priser'!$C$108:$E$110,3))/E127*'Variable priser'!$I$109*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F127=0,\"Variabel pris\",IFERROR((HLOOKUP(F127,'Variable priser'!$C$108:$E$110,2)+(F127-HLOOKUP(F127,'Variable priser'!$C$108:$E$110,1))*HLOOKUP(F127,'Variable priser'!$C$108:$E$110,3))/F127*'Variable priser'!$I$109*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Nødstrømsanlæg på vandværk","kW",{"$f":"Genanskaffelsespriser!$E$58","v":25},0,0,0,0,0,null,{"$f":"IF(E128=0,\"Variabel pris\",IFERROR((HLOOKUP(E128,'Variable priser'!$C$86:$H$88,2)+(E128-HLOOKUP(E128,'Variable priser'!$C$86:$H$88,1))*HLOOKUP(E128,'Variable priser'!$C$86:$H$88,3))/E128*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F128=0,\"Variabel pris\",IFERROR((HLOOKUP(F128,'Variable priser'!$C$86:$H$88,2)+(F128-HLOOKUP(F128,'Variable priser'!$C$86:$H$88,1))*HLOOKUP(F128,'Variable priser'!$C$86:$H$88,3))/F128*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},"","",1,1]
["Elanlæg og SRO-anlæg - vandværk, Elanlæg","m³/h.",{"$f":"Genanskaffelsespriser!$E$59","v":25},600,600,600,0,0,null,{"$f":"IF(E129=0,\"Variabel pris\",IFERROR((HLOOKUP(E129,'Variable priser'!$C$91:$J$95,4)+(E129-HLOOKUP(E129,'Variable priser'!$C$91:$J$95,1))*HLOOKUP(E129,'Variable priser'!$C$91:$J$95,5))/E129*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":2013.0840274999998},{"$f":"IF(F129=0,\"Variabel pris\",IFERROR((HLOOKUP(F129,'Variable priser'!$C$91:$J$95,4)+(F129-HLOOKUP(F129,'Variable priser'!$C$91:$J$95,1))*HLOOKUP(F129,'Variable priser'!$C$91:$J$95,5))/F129*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":2013.0840274999998},48314.016659999994,48314.016659999994,1,1]
["Elanlæg og SRO-anlæg - vandværk, SRO","m³/h.",{"$f":"Genanskaffelsespriser!$E$60","v":10},600,600,600,0,0,null,{"$f":"IF(E130=0,\"Variabel pris\",IFERROR((HLOOKUP(E130,'Variable priser'!$C$91:$J$98,7)+(E130-HLOOKUP(E130,'Variable priser'!$C$91:$J$98,1))*HLOOKUP(E130,'Variable priser'!$C$91:$J$98,8))/E130*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":819.13874399999997},{"$f":"IF(F130=0,\"Variabel pris\",IFERROR((HLOOKUP(F130,'Variable priser'!$C$91:$J$98,7)+(F130-HLOOKUP(F130,'Variable priser'!$C$91:$J$98,1))*HLOOKUP(F130,'Variable priser'!$C$91:$J$98,8))/F130*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":819.13874399999997},49148.324639999999,49148.324639999999,1,1]
["Bygninger"]
["Etageareal vandbehandlingsbygning","m²",{"$f":"Genanskaffelsespriser!E62","v":75},2624.57,2624.57,2624.57,0,{"$f":"IF($E132=\"\",IF($F132>0,\"Ny data\",IF($F132=\"\",\"\",0)),IF($E132=0,IF($F132=0,0,\"Ny data\"),($F132-$E132)/$E132))","v":0},null,{"$f":"Genanskaffelsespriser!$D62","v":18777.995999999999},{"$f":"J132","v":18777.995999999999},{"$f":"IF(ISNUMBER(E132),((J132*E132)/C132)*N132,\"\")","v":657122.19948959991},{"$f":"IF(ISNUMBER(F132),((K132*F132)/C132)*O132,\"\")","v":657122.19948959991},1,1]
["Etageareal kontor og mandskabsfaciliteter","m²",{"$f":"Genanskaffelsespriser!E63","v":75},687.42,687.42,687.42,0,0,null,{"$f":"Genanskaffelsespriser!$D63","v":20023.432999999997},{"$f":"J133","v":20023.432999999997},183526.77750479997,183526.77750479997,1,1]
["Værksted","m²",{"$f":"Genanskaffelsespriser!E64","v":75},60,60,60,0,0,null,{"$f":"Genanskaffelsespriser!$D64","v":15473.076999999999},15473.076999999999,12378.461600000001,12378.461600000001,1,1]
["Lager","m²",{"$f":"Genanskaffelsespriser!E65","v":75},95,95,95,0,0,null,{"$f":"Genanskaffelsespriser!$D65","v":15473.076999999999},15473.076999999999,19599.230866666665,19599.230866666665,1,1]
["Garage og rørlager","m²",{"$f":"Genanskaffelsespriser!E66","v":75},145.5,145.5,145.5,0,0,null,{"$f":"Genanskaffelsespriser!$D66","v":10830.428},10830.428,21011.030319999998,21011.030319999998,1,1]
["Bygning for trykforøgere","m²",{"$f":"Genanskaffelsespriser!E67","v":75},361,361,361,0,0,null,{"$f":"Genanskaffelsespriser!$D67","v":21069.766},21069.766,101415.80701333332,101415.80701333332,1,1]
["Laboratorium (bygning, inkl. inventar+udstyr), Konstruktioner","m²",{"$f":"Genanskaffelsespriser!E68","v":75},0,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D68","v":21115.393999999997},21115.393999999997,0,0,1,1]
["Laboratorium (bygning, inkl. inventar+udstyr), Mek./EL","m²",{"$f":"Genanskaffelsespriser!E69","v":10},0,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D69","v":14077.275},14077.275,0,0,1,1]
["Andre"]
["Sikring (terror, hærværk), Mek./EL","stk.",{"$f":"Genanskaffelsespriser!E71","v":25},33,33,33,0,0,null,{"$f":"Genanskaffelsespriser!$D71","v":6607.7639999999992},{"$f":"J141","v":6607.7639999999992},8722.2484799999984,8722.2484799999984,1,1]
["Sikring (terror, hærværk), SRO","stk.",{"$f":"Genanskaffelsespriser!E72","v":10},30,30,30,0,0,null,{"$f":"Genanskaffelsespriser!$D72","v":15418.115999999998},{"$f":"J142","v":15418.115999999998},46254.347999999991,46254.347999999991,1,1]
["Sikring, mindre avanceret (hegn, porte), Mek./EL","stk.",{"$f":"Genanskaffelsespriser!E73","v":25},2,2,2,0,0,null,{"$f":"Genanskaffelsespriser!$D73","v":27031.478999999999},27031.478999999999,2162.5183200000001,2162.5183200000001,1,1]
["Sikring, mindre avanceret (hegn, porte), SRO","stk.",{"$f":"Genanskaffelsespriser!E74","v":10},1,1,1,0,0,null,{"$f":"Genanskaffelsespriser!$D74","v":63073.450999999994},63073.450999999994,6307.3450999999995,6307.3450999999995,1,1]
["Sikring, avanceret (hegn, porte og overvågningssystemer), Mek./EL","stk.",{"$f":"Genanskaffelsespriser!E75","v":25},4,4,4,0,0,null,{"$f":"Genanskaffelsespriser!$D75","v":58401.765999999996},58401.765999999996,9344.2825599999996,9344.2825599999996,1,1]
["Sikring, avanceret (hegn, porte og overvågningssystemer), SRO","stk.",{"$f":"Genanskaffelsespriser!E76","v":10},4,4,4,0,0,null,{"$f":"Genanskaffelsespriser!$D76","v":233606.02699999997},233606.02699999997,93442.410799999983,93442.410799999983,1,1]

{"sheet":"Distributionsanlæg","index":1,"n_rows":128,"n_cols":15,"rows_kept":128,"cut":false,"hidden":false,"merged":[],"read":"row_number_cap"}
["Distributionsanlæg","Enhed","Standard-levetid","Samlet mængde per 31/12-2023","Samlet mængde per 31/12-2024","Samlet mængde per 31/12-2025","Afvigelse \n2023-2024","Afvigelse\n2024-2025","Bemærkninger","Enhedspris\n2024","Enhedspris\n2025","Netvolumenbidrag\n2024","Netvolumenbidrag\n2025","Ejerandel\n2024 (%)","Ejerandel\n2025 (%)"]
["Ledningsnet - Land",null,null,null,null,null,null,null,null,null,null,null,null,1]
["Ledningsnet ≤ Ø50 mm","meter",{"$f":"Genanskaffelsespriser!E81","v":75},1100,4453,4453,{"$f":"IF($D3=\"\",IF($E3>0,\"Ny data\",IF($E3=\"\",\"\",0)),IF($D3=0,IF($E3=0,0,\"Ny data\"),($E3-$D3)/$D3))","v":3.0481818181818183},{"$f":"IF($E3=\"\",IF($F3>0,\"Ny data\",IF($F3=\"\",\"\",0)),IF($E3=0,IF($F3=0,0,\"Ny data\"),($F3-$E3)/$E3))","v":0},"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D81","v":548.57299999999998},{"$f":"J3","v":548.57299999999998},{"$f":"IF(ISNUMBER(E3),((J3*E3)/C3)*N3,\"\")","v":32570.607586666669},{"$f":"IF(ISNUMBER(F3),((K3*F3)/C3)*O3,\"\")","v":32570.607586666669},1,1]
["Ø 50mm < Ledningsnet ≤ Ø110 mm","meter",{"$f":"Genanskaffelsespriser!E82","v":75},4091,8097,8097,{"$f":"IF($D4=\"\",IF($E4>0,\"Ny data\",IF($E4=\"\",\"\",0)),IF($D4=0,IF($E4=0,0,\"Ny data\"),($E4-$D4)/$D4))","v":0.97922268394035683},{"$f":"IF($E4=\"\",IF($F4>0,\"Ny data\",IF($F4=\"\",\"\",0)),IF($E4=0,IF($F4=0,0,\"Ny data\"),($F4-$E4)/$E4))","v":0},"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D82","v":837.89599999999996},{"$f":"J4","v":837.89599999999996},{"$f":"IF(ISNUMBER(E4),((J4*E4)/C4)*N4,\"\")","v":90459.252159999989},{"$f":"IF(ISNUMBER(F4),((K4*F4)/C4)*O4,\"\")","v":90459.252159999989},1,1]
["Ø110 mm < Ledningsnet ≤ Ø 250 mm","meter",{"$f":"Genanskaffelsespriser!E83","v":75},3711,3800,3800,2.3982753974669899E-2,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D83","v":1568.981},1568.981,79495.037333333326,79495.037333333326,1,1]
["Ø 250 mm < Ledningsnet ≤ Ø 500mm","meter",{"$f":"Genanskaffelsespriser!E84","v":75},299,70,70,-0.76588628762541811,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D84","v":3052.9279999999999},3052.9279999999999,2849.3994666666667,2849.3994666666667,1,1]
["Ledningsnet > Ø 500 mm","meter",{"$f":"Genanskaffelsespriser!E85","v":75},0,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D85","v":5963.7869999999994},5963.7869999999994,0,0,1,1]
["Støbejernsledninger ≤ Ø50 mm","meter",{"$f":"Genanskaffelsespriser!E86","v":100},485,1897,1897,2.9113402061855669,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D86","v":932.26299999999992},932.26299999999992,17685.029109999999,17685.029109999999,1,1]
["Støbejernsledninger Ø 50mm < Ledningsnet ≤ Ø110 mm","meter",{"$f":"Genanskaffelsespriser!E87","v":100},6923,8846,8846,0.27776975299725554,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D87","v":1091.961},1091.961,96594.870060000016,96594.870060000016,1,1]
["Støbejernsledninger Ø110 mm < Ledningsnet ≤ Ø 250 mm","meter",{"$f":"Genanskaffelsespriser!E88","v":100},4151,4237,4237,2.0717899301373164E-2,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D88","v":1545.1299999999999},1545.1299999999999,65467.158099999993,65467.158099999993,1,1]
["Støbejernsledninger Ø 250 mm < Ledningsnet ≤ Ø 500mm","meter",{"$f":"Genanskaffelsespriser!E89","v":100},23,27,27,0.17391304347826086,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D89","v":2864.194},2864.194,773.33237999999994,773.33237999999994,1,1]
["Støbejernsledninger Ledningsnet > Ø 500 mm","meter",{"$f":"Genanskaffelsespriser!E90","v":100},0,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D90","v":5686.9079999999994},5686.9079999999994,0,0,1,1]
["Eternitledninger ≤ Ø50 mm","meter",{"$f":"Genanskaffelsespriser!E91","v":75},0,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D91","v":679.2349999999999},679.2349999999999,0,0,1,1]
["Eternitledninger Ø 50mm < Ledningsnet ≤ Ø110 mm","meter",{"$f":"Genanskaffelsespriser!E92","v":75},0,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D92","v":917.74499999999989},917.74499999999989,0,0,1,1]
["Eternitledninger Ø110 mm < Ledningsnet ≤ Ø 250 mm","meter",{"$f":"Genanskaffelsespriser!E93","v":75},1069,1410,1410,0.31898971000935455,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D93","v":1334.6189999999999},1334.6189999999999,25090.837199999998,25090.837199999998,1,1]
["Eternitledninger Ø 250 mm < Ledningsnet ≤ Ø 500mm","meter",{"$f":"Genanskaffelsespriser!E94","v":75},0,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D94","v":3169.0719999999997},3169.0719999999997,0,0,1,1]
["Eternitledninger Ledningsnet > Ø 500 mm","meter",{"$f":"Genanskaffelsespriser!E95","v":75},0,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D95","v":8790.6489999999994},8790.6489999999994,0,0,1,1]
["Skelbrønd, Konstruktioner","stk.",{"$f":"Genanskaffelsespriser!E96","v":50},131,131,131,0,0,"Har ved en fejl ikke været indberettet tidligere",{"$f":"Genanskaffelsespriser!$D96","v":10800.355},10800.355,28296.930099999998,28296.930099999998,1,1]
["Skelbrønd, Mek./EL","stk.",{"$f":"Genanskaffelsespriser!E97","v":15},131,131,131,0,0,"Har ved en fejl ikke været indberettet tidligere",{"$f":"Genanskaffelsespriser!$D97","v":16201.050999999999},16201.050999999999,141489.17873333333,141489.17873333333,1,1]
["Inspektionsbrønd, Konstruktioner","stk.",{"$f":"Genanskaffelsespriser!E98","v":50},0,null,null,0,"",null,{"$f":"Genanskaffelsespriser!$D98","v":10800.355},10800.355,"","",1,1]
["Inspektionsbrønd, Mek./EL","stk.",{"$f":"Genanskaffelsespriser!E99","v":15},0,null,null,0,"",null,{"$f":"Genanskaffelsespriser!$D99","v":13500.703},13500.703,"","",1,1]
["Stik på ledningsnet, Konstruktioner","stk.",{"$f":"Genanskaffelsespriser!E100","v":75},245,246,252,4.0816326530612249E-3,2.4390243902439025E-2,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D100","v":4896.7139999999999},4896.7139999999999,16061.221920000002,16452.959040000002,1,1]
["Stik på ledningsnet, Mek./EL","stk.",{"$f":"Genanskaffelsespriser!E101","v":75},245,246,252,4.0816326530612249E-3,2.4390243902439025E-2,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D101","v":4896.7139999999999},4896.7139999999999,16061.221920000002,16452.959040000002,1,1]
["Ledningsnet - By"]
["Ledningsnet ≤ Ø50 mm","meter",{"$f":"Genanskaffelsespriser!E103","v":75},12994,12908,12908,-6.6184392796675385E-3,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D103","v":674.05},{"$f":"J25","v":674.05},116008.49866666665,116008.49866666665,1,1]
["Ø 50mm < Ledningsnet ≤ Ø110 mm","meter",{"$f":"Genanskaffelsespriser!E104","v":75},52314,40015,40015,-0.23509959093168176,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D104","v":993.44599999999991},{"$f":"J26","v":993.44599999999991},530036.5558666666,530036.5558666666,1,1]
["Ø110 mm < Ledningsnet ≤ Ø 250 mm","meter",{"$f":"Genanskaffelsespriser!E105","v":75},21967,17460,17460,-0.2051713934538171,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D105","v":1746.3079999999998},1746.3079999999998,406540.50239999994,406540.50239999994,1,1]
["Ø 250 mm < Ledningsnet ≤ Ø 500mm","meter",{"$f":"Genanskaffelsespriser!E106","v":75},11106,5838,5838,-0.47433819556996221,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D106","v":3269.6609999999996},3269.6609999999996,254510.41223999998,254510.41223999998,1,1]
["Ledningsnet > Ø 500 mm","meter",{"$f":"Genanskaffelsespriser!E107","v":75},null,0,0,0,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D107","v":6219.9259999999995},6219.9259999999995,0,0,1,1]
["Støbejernsledninger ≤ Ø50 mm","meter",{"$f":"Genanskaffelsespriser!E108","v":100},7660,10635,10635,0.38838120104438645,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D108","v":1057.74},1057.74,112490.649,112490.649,1,1]
["Støbejernsledninger Ø 50mm < Ledningsnet ≤ Ø110 mm","meter",{"$f":"Genanskaffelsespriser!E109","v":100},66814,61240,61240,-8.3425629359116349E-2,0,null,{"$f":"Genanskaffelsespriser!$D109","v":1247.511},1247.511,763975.73640000005,763975.73640000005,1,1]
["Støbejernsledninger Ø110 mm < Ledningsnet ≤ Ø 250 mm","meter",{"$f":"Genanskaffelsespriser!E110","v":100},14521,12962,12962,-0.1073617519454583,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D110","v":1722.4569999999999},1722.4569999999999,223264.87633999999,223264.87633999999,1,1]
["Støbejernsledninger Ø 250 mm < Ledningsnet ≤ Ø 500mm","meter",{"$f":"Genanskaffelsespriser!E111","v":100},3808,2885,2885,-0.2423844537815126,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D111","v":3080.9269999999997},3080.9269999999997,88884.743949999989,88884.743949999989,1,1]
["Støbejernsledninger Ledningsnet > Ø 500 mm","meter",{"$f":"Genanskaffelsespriser!E112","v":100},0,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D112","v":5943.0469999999996},5943.0469999999996,0,0,1,1]
["Eternitledninger ≤ Ø50 mm","meter",{"$f":"Genanskaffelsespriser!E113","v":75},0,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D113","v":804.71199999999999},804.71199999999999,0,0,1,1]
["Eternitledninger Ø 50mm < Ledningsnet ≤ Ø110 mm","meter",{"$f":"Genanskaffelsespriser!E114","v":75},0,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D114","v":1073.2949999999998},1073.2949999999998,0,0,1,1]
["Eternitledninger Ø110 mm < Ledningsnet ≤ Ø 250 mm","meter",{"$f":"Genanskaffelsespriser!E115","v":75},4972,3645,3645,-0.26689460981496382,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D115","v":1509.8719999999998},1509.8719999999998,73379.77919999999,73379.77919999999,1,1]
["Eternitledninger Ø 250 mm < Ledningsnet ≤ Ø 500mm","meter",{"$f":"Genanskaffelsespriser!E116","v":75},4637,3224,3224,-0.30472288117317231,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D116","v":3385.8049999999998},3385.8049999999998,145544.47093333333,145544.47093333333,1,1]
["Eternitledninger Ledningsnet > Ø 500 mm","meter",{"$f":"Genanskaffelsespriser!E117","v":75},0,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D117","v":9046.7879999999986},9046.7879999999986,0,0,1,1]
["Skelbrønd, Konstruktioner","stk.",{"$f":"Genanskaffelsespriser!E118","v":50},364,360,360,-1.098901098901099E-2,0,"Har ved en fejl ikke været indberettet tidligere",{"$f":"Genanskaffelsespriser!$D118","v":11880.909},11880.909,85542.544800000003,85542.544800000003,1,1]
["Skelbrønd, Mek./EL","stk.",{"$f":"Genanskaffelsespriser!E119","v":15},364,360,360,-1.098901098901099E-2,0,"Har ved en fejl ikke været indberettet tidligere",{"$f":"Genanskaffelsespriser!$D119","v":17820.844999999998},17820.844999999998,427700.27999999997,427700.27999999997,1,1]
["Inspektionsbrønd, Konstruktioner","stk.",{"$f":"Genanskaffelsespriser!E120","v":50},null,null,null,"","",null,{"$f":"Genanskaffelsespriser!$D120","v":11880.909},11880.909,"","",1,1]
["Inspektionsbrønd, Mek./EL","stk.",{"$f":"Genanskaffelsespriser!E121","v":15},null,null,null,"","",null,{"$f":"Genanskaffelsespriser!$D121","v":14850.876999999999},14850.876999999999,"","",1,1]
["Stik på ledningsnet, Konstruktioner","stk.",{"$f":"Genanskaffelsespriser!E122","v":75},9999,10065,10485,6.6006600660066007E-3,4.1728763040238454E-2,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D122","v":5875.6419999999998},5875.6419999999998,788511.15639999998,821414.75159999996,1,1]
["Stik på ledningsnet, Mek./EL","stk.",{"$f":"Genanskaffelsespriser!E123","v":75},9999,10065,10485,6.6006600660066007E-3,4.1728763040238454E-2,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D123","v":5875.6419999999998},5875.6419999999998,788511.15639999998,821414.75159999996,1,1]
["Ledningsnet - City"]
["Ledningsnet ≤ Ø50 mm","meter",{"$f":"Genanskaffelsespriser!E125","v":75},1770,3086,3086,0.74350282485875707,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D125","v":1117.886},{"$f":"J47","v":1117.886},45997.282613333336,45997.282613333336,1,1]
["Ø 50mm < Ledningsnet ≤ Ø110 mm","meter",{"$f":"Genanskaffelsespriser!E126","v":75},8953,16083,16083,0.79638110130682449,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D126","v":1550.3149999999998},{"$f":"J48","v":1550.3149999999998},332449.54859999992,332449.54859999992,1,1]
["Ø110 mm < Ledningsnet ≤ Ø 250 mm","meter",{"$f":"Genanskaffelsespriser!E127","v":75},8229,13835,13835,0.68124924049094671,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D127","v":2273.1039999999998},2273.1039999999998,419311.91786666663,419311.91786666663,1,1]
["Ø 250 mm < Ledningsnet ≤ Ø 500mm","meter",{"$f":"Genanskaffelsespriser!E128","v":75},3450,8838,8838,1.5617391304347825,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D128","v":3912.6009999999997},3912.6009999999997,461060.90183999995,461060.90183999995,1,1]
["Ledningsnet > Ø 500 mm","meter",{"$f":"Genanskaffelsespriser!E129","v":75},null,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D129","v":6981.0839999999998},6981.0839999999998,0,0,1,1]
["Støbejernsledninger ≤ Ø50 mm","meter",{"$f":"Genanskaffelsespriser!E130","v":100},962,2530,2530,1.62993762993763,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D130","v":1501.5759999999998},1501.5759999999998,37989.87279999999,37989.87279999999,1,1]
["Støbejernsledninger Ø 50mm < Ledningsnet ≤ Ø110 mm","meter",{"$f":"Genanskaffelsespriser!E131","v":100},22890,35915,35915,0.56902577544779376,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D131","v":1804.3799999999999},1804.3799999999999,648043.07699999993,648043.07699999993,1,1]
["Støbejernsledninger Ø110 mm < Ledningsnet ≤ Ø 250 mm","meter",{"$f":"Genanskaffelsespriser!E132","v":100},4434,6685,6685,0.50766801984663956,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D132","v":2249.2529999999997},2249.2529999999997,150362.56304999997,150362.56304999997,1,1]
["Støbejernsledninger Ø 250 mm < Ledningsnet ≤ Ø 500mm","meter",{"$f":"Genanskaffelsespriser!E133","v":100},541,1460,1460,1.6987060998151571,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D133","v":3723.8669999999997},3723.8669999999997,54368.458199999994,54368.458199999994,1,1]
["Støbejernsledninger Ledningsnet > Ø 500 mm","meter",{"$f":"Genanskaffelsespriser!E134","v":100},0,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D134","v":6704.2049999999999},6704.2049999999999,0,0,1,1]
["Eternitledninger ≤ Ø50 mm","meter",{"$f":"Genanskaffelsespriser!E135","v":75},0,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D135","v":1248.548},1248.548,0,0,1,1]
["Eternitledninger Ø 50mm < Ledningsnet ≤ Ø110 mm","meter",{"$f":"Genanskaffelsespriser!E136","v":75},0,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D136","v":1630.164},1630.164,0,0,1,1]
["Eternitledninger Ø110 mm < Ledningsnet ≤ Ø 250 mm","meter",{"$f":"Genanskaffelsespriser!E137","v":75},1247,2579,2579,1.0681635926222934,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D137","v":2038.7419999999997},2038.7419999999997,70105.541573333321,70105.541573333321,1,1]
["Eternitledninger Ø 250 mm < Ledningsnet ≤ Ø 500mm","meter",{"$f":"Genanskaffelsespriser!E138","v":75},680,2094,2094,2.0794117647058825,0,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D138","v":4028.7449999999999},4028.7449999999999,112482.56039999999,112482.56039999999,1,1]
["Eternitledninger Ledningsnet > Ø 500 mm","meter",{"$f":"Genanskaffelsespriser!E139","v":75},0,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D139","v":9807.9459999999999},9807.9459999999999,0,0,1,1]
["Skelbrønd, Konstruktioner","stk.",{"$f":"Genanskaffelsespriser!E140","v":50},46,45,45,-2.1739130434782608E-2,0,"Har ved en fejl ikke været indberettet tidligere",{"$f":"Genanskaffelsespriser!$D140","v":12960.425999999999},12960.425999999999,11664.383399999999,11664.383399999999,1,1]
["Skelbrønd, Mek./EL","stk.",{"$f":"Genanskaffelsespriser!E141","v":15},46,45,45,-2.1739130434782608E-2,0,"Har ved en fejl ikke været indberettet tidligere",{"$f":"Genanskaffelsespriser!$D141","v":19440.638999999999},19440.638999999999,58321.917000000001,58321.917000000001,1,1]
["Inspektionsbrønd, Konstruktioner","stk.",{"$f":"Genanskaffelsespriser!E142","v":50},null,null,null,"","",null,{"$f":"Genanskaffelsespriser!$D142","v":12960.425999999999},12960.425999999999,"","",1,1]
["Inspektionsbrønd, Mek./EL","stk.",{"$f":"Genanskaffelsespriser!E143","v":15},null,null,null,"","",null,{"$f":"Genanskaffelsespriser!$D143","v":16201.050999999999},16201.050999999999,"","",1,1]
["Stik på ledningsnet, Konstruktioner","stk.",{"$f":"Genanskaffelsespriser!E144","v":75},2081,2092,2148,5.2859202306583374E-3,2.676864244741874E-2,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D144","v":6366.1429999999991},6366.1429999999991,177572.94874666663,182326.33551999999,1,1]
["Stik på ledningsnet, Mek./EL","stk.",{"$f":"Genanskaffelsespriser!E145","v":75},2081,2092,2148,5.2859202306583374E-3,2.676864244741874E-2,"Der er lagt nyt zonekort, som har betydet ændring af længder mellem zonerne",{"$f":"Genanskaffelsespriser!$D145","v":6366.1429999999991},6366.1429999999991,177572.94874666663,182326.33551999999,1,1]
["Ledningsnet - Indre city"]
["Ledningsnet ≤ Ø50 mm","meter",{"$f":"Genanskaffelsespriser!E147","v":75},0,null,null,{"$f":"IF($D69=\"\",IF($E69>0,\"Ny data\",IF($E69=\"\",\"\",0)),IF($D69=0,IF($E69=0,0,\"Ny data\"),($E69-$D69)/$D69))","v":0},{"$f":"IF($E69=\"\",IF($F69>0,\"Ny data\",IF($F69=\"\",\"\",0)),IF($E69=0,IF($F69=0,0,\"Ny data\"),($F69-$E69)/$E69))","v":""},null,{"$f":"Genanskaffelsespriser!$D147","v":1759.7889999999998},{"$f":"J69","v":1759.7889999999998},{"$f":"IF(ISNUMBER(E69),((J69*E69)/C69)*N69,\"\")","v":""},{"$f":"IF(ISNUMBER(F69),((K69*F69)/C69)*O69,\"\")","v":""},1,1]
["Ø 50mm < Ledningsnet ≤ Ø110 mm","meter",{"$f":"Genanskaffelsespriser!E148","v":75},0,null,null,0,"",null,{"$f":"Genanskaffelsespriser!$D148","v":2351.9159999999997},{"$f":"J70","v":2351.9159999999997},"","",1,1]
["Ø110 mm < Ledningsnet ≤ Ø 250 mm","meter",{"$f":"Genanskaffelsespriser!E149","v":75},0,null,null,0,"",null,{"$f":"Genanskaffelsespriser!$D149","v":3120.3329999999996},3120.3329999999996,"","",1,1]
["Ø 250 mm < Ledningsnet ≤ Ø 500mm","meter",{"$f":"Genanskaffelsespriser!E150","v":75},0,null,null,0,"",null,{"$f":"Genanskaffelsespriser!$D150","v":4949.6009999999997},4949.6009999999997,"","",1,1]
["Ledningsnet > Ø 500 mm","meter",{"$f":"Genanskaffelsespriser!E151","v":75},0,null,null,0,"",null,{"$f":"Genanskaffelsespriser!$D151","v":8207.8549999999996},8207.8549999999996,"","",1,1]
["Støbejernsledninger ≤ Ø50 mm","meter",{"$f":"Genanskaffelsespriser!E152","v":100},0,null,null,0,"",null,{"$f":"Genanskaffelsespriser!$D152","v":2143.4789999999998},2143.4789999999998,"","",1,1]
["Støbejernsledninger Ø 50mm < Ledningsnet ≤ Ø110 mm","meter",{"$f":"Genanskaffelsespriser!E153","v":100},0,null,null,0,"",null,{"$f":"Genanskaffelsespriser!$D153","v":2605.9809999999998},2605.9809999999998,"","",1,1]
["Støbejernsledninger Ø110 mm < Ledningsnet ≤ Ø 250 mm","meter",{"$f":"Genanskaffelsespriser!E154","v":100},0,null,null,0,"",null,{"$f":"Genanskaffelsespriser!$D154","v":3096.482},3096.482,"","",1,1]
["Støbejernsledninger Ø 250 mm < Ledningsnet ≤ Ø 500mm","meter",{"$f":"Genanskaffelsespriser!E155","v":100},0,null,null,0,"",null,{"$f":"Genanskaffelsespriser!$D155","v":4760.8669999999993},4760.8669999999993,"","",1,1]
["Støbejernsledninger Ledningsnet > Ø 500 mm","meter",{"$f":"Genanskaffelsespriser!E156","v":100},0,null,null,0,"",null,{"$f":"Genanskaffelsespriser!$D156","v":7930.9759999999997},7930.9759999999997,"","",1,1]
["Eternitledninger ≤ Ø50 mm","meter",{"$f":"Genanskaffelsespriser!E157","v":75},0,null,null,0,"",null,{"$f":"Genanskaffelsespriser!$D157","v":1890.4509999999998},1890.4509999999998,"","",1,1]
["Eternitledninger Ø 50mm < Ledningsnet ≤ Ø110 mm","meter",{"$f":"Genanskaffelsespriser!E158","v":75},0,null,null,0,"",null,{"$f":"Genanskaffelsespriser!$D158","v":2431.7649999999999},2431.7649999999999,"","",1,1]
["Eternitledninger Ø110 mm < Ledningsnet ≤ Ø 250 mm","meter",{"$f":"Genanskaffelsespriser!E159","v":75},0,null,null,0,"",null,{"$f":"Genanskaffelsespriser!$D159","v":2885.971},2885.971,"","",1,1]
["Eternitledninger Ø 250 mm < Ledningsnet ≤ Ø 500mm","meter",{"$f":"Genanskaffelsespriser!E160","v":75},0,null,null,0,"",null,{"$f":"Genanskaffelsespriser!$D160","v":5065.7449999999999},5065.7449999999999,"","",1,1]
["Eternitledninger Ledningsnet > Ø 500 mm","meter",{"$f":"Genanskaffelsespriser!E161","v":75},0,null,null,0,"",null,{"$f":"Genanskaffelsespriser!$D161","v":11034.716999999999},11034.716999999999,"","",1,1]
["Skelbrønd, Konstruktioner","stk.",{"$f":"Genanskaffelsespriser!E162","v":50},0,null,null,0,"",null,{"$f":"Genanskaffelsespriser!$D162","v":14040.98},14040.98,"","",1,1]
["Skelbrønd, Mek./EL","stk.",{"$f":"Genanskaffelsespriser!E163","v":15},0,null,null,0,"",null,{"$f":"Genanskaffelsespriser!$D163","v":21061.469999999998},21061.469999999998,"","",1,1]
["Inspektionsbrønd, Konstruktioner","stk.",{"$f":"Genanskaffelsespriser!E164","v":50},0,null,null,0,"",null,{"$f":"Genanskaffelsespriser!$D164","v":14040.98},14040.98,"","",1,1]
["Inspektionsbrønd, Mek./EL","stk.",{"$f":"Genanskaffelsespriser!E165","v":15},0,null,null,0,"",null,{"$f":"Genanskaffelsespriser!$D165","v":17551.224999999999},17551.224999999999,"","",1,1]
["Stik på ledningsnet, Konstruktioner","stk.",{"$f":"Genanskaffelsespriser!E166","v":75},0,null,null,0,"",null,{"$f":"Genanskaffelsespriser!$D166","v":7834.5349999999999},7834.5349999999999,"","",1,1]
["Stik på ledningsnet, Mek./EL","stk.",{"$f":"Genanskaffelsespriser!E167","v":75},0,null,null,0,"",null,{"$f":"Genanskaffelsespriser!$D167","v":7834.5349999999999},7834.5349999999999,"","",1,1]
["Ventiler"]
["Ventiler på ledningsnet ≤ Ø50 mm","stk.",{"$f":"Genanskaffelsespriser!E169","v":75},288,1257,1282,3.3645833333333335,1.9888623707239459E-2,"Tidligere indberetning har indeholdt antallet af stophaner",{"$f":"Genanskaffelsespriser!$D169","v":8018.0839999999998},{"$f":"J91","v":8018.0839999999998},134383.08783999999,137055.78250666664,1,1]
["Ventiler på Ø 50mm < Ledningsnet ≤ Ø110 mm","stk.",{"$f":"Genanskaffelsespriser!E170","v":75},1089,91,93,-0.91643709825528008,2.197802197802198E-2,"Tidligere indberetning har indeholdt antallet af stophaner",{"$f":"Genanskaffelsespriser!$D170","v":9312.2599999999984},{"$f":"J92","v":9312.2599999999984},11298.875466666665,11547.202399999998,1,1]
["Ventiler på Ø110 mm < Ledningsnet ≤ Ø 250 mm","stk.",{"$f":"Genanskaffelsespriser!E171","v":75},404,22,23,-0.9455445544554455,4.5454545454545456E-2,"Tidligere indberetning har indeholdt antallet af stophaner",{"$f":"Genanskaffelsespriser!$D171","v":22540.232},22540.232,6611.801386666667,6912.3378133333335,1,1]
["Ventiler på Ø 250 mm < Ledningsnet ≤ Ø 500mm","stk.",{"$f":"Genanskaffelsespriser!E172","v":75},104,4,4,{"$f":"IF($D94=\"\",IF($E94>0,\"Ny data\",IF($E94=\"\",\"\",0)),IF($D94=0,IF($E94=0,0,\"Ny data\"),($E94-$D94)/$D94))","v":-0.96153846153846156},{"$f":"IF($E94=\"\",IF($F94>0,\"Ny data\",IF($F94=\"\",\"\",0)),IF($E94=0,IF($F94=0,0,\"Ny data\"),($F94-$E94)/$E94))","v":0},"Tidligere indberetning har indeholdt antallet af stophaner",{"$f":"Genanskaffelsespriser!$D172","v":81196.062999999995},81196.062999999995,4330.4566933333326,4330.4566933333326,1,1]
["Ventiler på ledningsnet > Ø 500 mm","stk.",{"$f":"Genanskaffelsespriser!E173","v":75},0,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D173","v":232011.12099999998},232011.12099999998,0,0,1,1]
["Pumpestationer, bygværker og bassiner 1"]
["Pumpestation (inkl. evt. hydrofor)/trykforøger, Konstruktioner","m³/h ",{"$f":"+Genanskaffelsespriser!$E$175","v":50},0,null,null,0,"",null,{"$f":"IF(E97=0,\"Variabel pris\",IFERROR((HLOOKUP(E97,'Variable priser'!$C$103:$F$105,2)+(E97-HLOOKUP(E97,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(E97,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$I$102/E97*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F97=0,\"Variabel pris\",IFERROR((HLOOKUP(F97,'Variable priser'!$C$103:$F$105,2)+(F97-HLOOKUP(F97,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(F97,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$I$102/F97*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(ISBLANK(E97),\"\",IF(E97=0,\"\",IF(ISNUMBER(E97),((J97*E97)/$C97)*N97,\"\")))","v":""},{"$f":"IF(ISBLANK(F97),\"\",IF(F97=0,\"\",IF(ISNUMBER(F97),((K97*F97)/$C97)*O97,\"\")))","v":""},1,1]
["Pumpestation (inkl. evt. hydrofor)/trykforøger, Mek./EL","m³/h ",{"$f":"+Genanskaffelsespriser!$E$176","v":25},0,null,null,0,"",null,{"$f":"IF(E98=0,\"Variabel pris\",IFERROR((HLOOKUP(E98,'Variable priser'!$C$103:$F$105,2)+(E98-HLOOKUP(E98,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(E98,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$J$102/E98*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F98=0,\"Variabel pris\",IFERROR((HLOOKUP(F98,'Variable priser'!$C$103:$F$105,2)+(F98-HLOOKUP(F98,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(F98,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$J$102/F98*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(ISBLANK(E98),\"\",IF(E98=0,\"\",IF(ISNUMBER(E98),((J98*E98)/$C98)*N97,\"\")))","v":""},{"$f":"IF(ISBLANK(F98),\"\",IF(F98=0,\"\",IF(ISNUMBER(F98),((K98*F98)/$C98)*O97,\"\")))","v":""},1,1]
["Pumpestation (inkl. evt. hydrofor)/trykforøger, SRO","m³/h ",{"$f":"+Genanskaffelsespriser!$E$177","v":10},0,null,null,0,"",null,{"$f":"IF(E99=0,\"Variabel pris\",IFERROR((HLOOKUP(E99,'Variable priser'!$C$103:$F$105,2)+(E99-HLOOKUP(E99,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(E99,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$L$102/E99*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F99=0,\"Variabel pris\",IFERROR((HLOOKUP(F99,'Variable priser'!$C$103:$F$105,2)+(F99-HLOOKUP(F99,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(F99,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$L$102/F99*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(ISBLANK(E99),\"\",IF(E99=0,\"\",IF(ISNUMBER(E99),((J99*E99)/$C99)*N97,\"\")))","v":""},{"$f":"IF(ISBLANK(F99),\"\",IF(F99=0,\"Samlet mængde kan ikke være nul i 2025\",IF(ISNUMBER(F99),((K99*F99)/$C99)*O97,\"\")))","v":""},1,1]
["Beholderanlæg - højdebeholder","m³",{"$f":"+Genanskaffelsespriser!$E$178","v":50},0,null,null,0,"",null,{"$f":"IF(E100=0,\"Variabel pris\",IFERROR((HLOOKUP(E100,'Variable priser'!$C$48:$H$50,2)+(E100-HLOOKUP(E100,'Variable priser'!$C$48:$H$50,1))*HLOOKUP(E100,'Variable priser'!$C$48:$H$50,3))/E100*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F100=0,\"Variabel pris\",IFERROR((HLOOKUP(F100,'Variable priser'!$C$48:$H$50,2)+(F100-HLOOKUP(F100,'Variable priser'!$C$48:$H$50,1))*HLOOKUP(F100,'Variable priser'!$C$48:$H$50,3))/F100*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(ISBLANK(E100),\"\",IF(E100=0,\"\",IF(ISNUMBER(E100),((J100*E100)/$C100)*N97,\"\")))","v":""},{"$f":"IF(ISBLANK(F100),\"\",IF(F100=0,\"\",IF(ISNUMBER(F100),((K100*F100)/$C100)*O97,\"\")))","v":""},1,1]
["Beholderanlæg - vandtårn","m³",{"$f":"+Genanskaffelsespriser!$E$179","v":50},0,null,null,0,"",null,{"$f":"IF(E101=0,\"Variabel pris\",IFERROR((HLOOKUP(E101,'Variable priser'!$C$55:$H$57,2)+(E101-HLOOKUP(E101,'Variable priser'!$C$55:$H$57,1))*HLOOKUP(E101,'Variable priser'!$C$55:$H$57,3))/E101*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F101=0,\"Variabel pris\",IFERROR((HLOOKUP(F101,'Variable priser'!$C$55:$H$57,2)+(F101-HLOOKUP(F101,'Variable priser'!$C$55:$H$57,1))*HLOOKUP(F101,'Variable priser'!$C$55:$H$57,3))/F101*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(ISBLANK(E101),\"\",IF(E101=0,\"\",IF(ISNUMBER(E101),((J101*E101)/$C101)*N97,\"\")))","v":""},{"$f":"IF(ISBLANK(F101),\"\",IF(F101=0,\"\",IF(ISNUMBER(F101),((K101*F101)/$C101)*O97,\"\")))","v":""},1,1]
["Pumpestationer, bygværker og bassiner 2"]
["Pumpestation (inkl. evt. hydrofor)/trykforøger, Konstruktioner","m³/h ",{"$f":"+Genanskaffelsespriser!$E$175","v":50},0,null,null,0,"",null,{"$f":"IF(E103=0,\"Variabel pris\",IFERROR((HLOOKUP(E103,'Variable priser'!$C$103:$F$105,2)+(E103-HLOOKUP(E103,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(E103,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$I$102/E103*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F103=0,\"Variabel pris\",IFERROR((HLOOKUP(F103,'Variable priser'!$C$103:$F$105,2)+(F103-HLOOKUP(F103,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(F103,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$I$102/F103*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(ISBLANK(E103),\"\",IF(E103=0,\"\",IF(ISNUMBER(E103),((J103*E103)/$C103)*N103,\"\")))","v":""},{"$f":"IF(ISBLANK(F103),\"\",IF(F103=0,\"\",IF(ISNUMBER(F103),((K103*F103)/$C103)*O103,\"\")))","v":""},1,1]
["Pumpestation (inkl. evt. hydrofor)/trykforøger, Mek./EL","m³/h ",{"$f":"+Genanskaffelsespriser!$E$176","v":25},0,null,null,0,"",null,{"$f":"IF(E104=0,\"Variabel pris\",IFERROR((HLOOKUP(E104,'Variable priser'!$C$103:$F$105,2)+(E104-HLOOKUP(E104,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(E104,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$J$102/E104*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F104=0,\"Variabel pris\",IFERROR((HLOOKUP(F104,'Variable priser'!$C$103:$F$105,2)+(F104-HLOOKUP(F104,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(F104,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$J$102/F104*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(ISBLANK(E104),\"\",IF(E104=0,\"\",IF(ISNUMBER(E104),((J104*E104)/$C104)*N103,\"\")))","v":""},{"$f":"IF(ISBLANK(F104),\"\",IF(F104=0,\"\",IF(ISNUMBER(F104),((K104*F104)/$C104)*O103,\"\")))","v":""},1,1]
["Pumpestation (inkl. evt. hydrofor)/trykforøger, SRO","m³/h ",{"$f":"+Genanskaffelsespriser!$E$177","v":10},0,null,null,0,"",null,{"$f":"IF(E105=0,\"Variabel pris\",IFERROR((HLOOKUP(E105,'Variable priser'!$C$103:$F$105,2)+(E105-HLOOKUP(E105,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(E105,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$L$102/E105*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F105=0,\"Variabel pris\",IFERROR((HLOOKUP(F105,'Variable priser'!$C$103:$F$105,2)+(F105-HLOOKUP(F105,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(F105,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$L$102/F105*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(ISBLANK(E105),\"\",IF(E105=0,\"\",IF(ISNUMBER(E105),((J105*E105)/$C105)*N103,\"\")))","v":""},{"$f":"IF(ISBLANK(F105),\"\",IF(F105=0,\"Samlet mængde kan ikke være nul i 2025\",IF(ISNUMBER(F105),((K105*F105)/$C105)*O103,\"\")))","v":""},1,1]
["Beholderanlæg - højdebeholder","m³",{"$f":"+Genanskaffelsespriser!$E$178","v":50},0,null,null,0,"",null,{"$f":"IF(E106=0,\"Variabel pris\",IFERROR((HLOOKUP(E106,'Variable priser'!$C$48:$H$50,2)+(E106-HLOOKUP(E106,'Variable priser'!$C$48:$H$50,1))*HLOOKUP(E106,'Variable priser'!$C$48:$H$50,3))/E106*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F106=0,\"Variabel pris\",IFERROR((HLOOKUP(F106,'Variable priser'!$C$48:$H$50,2)+(F106-HLOOKUP(F106,'Variable priser'!$C$48:$H$50,1))*HLOOKUP(F106,'Variable priser'!$C$48:$H$50,3))/F106*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(ISBLANK(E106),\"\",IF(E106=0,\"\",IF(ISNUMBER(E106),((J106*E106)/$C106)*N103,\"\")))","v":""},{"$f":"IF(ISBLANK(F106),\"\",IF(F106=0,\"\",IF(ISNUMBER(F106),((K106*F106)/$C106)*O103,\"\")))","v":""},1,1]
["Beholderanlæg - vandtårn","m³",{"$f":"+Genanskaffelsespriser!$E$179","v":50},0,null,null,0,"",null,{"$f":"IF(E107=0,\"Variabel pris\",IFERROR((HLOOKUP(E107,'Variable priser'!$C$55:$H$57,2)+(E107-HLOOKUP(E107,'Variable priser'!$C$55:$H$57,1))*HLOOKUP(E107,'Variable priser'!$C$55:$H$57,3))/E107*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F107=0,\"Variabel pris\",IFERROR((HLOOKUP(F107,'Variable priser'!$C$55:$H$57,2)+(F107-HLOOKUP(F107,'Variable priser'!$C$55:$H$57,1))*HLOOKUP(F107,'Variable priser'!$C$55:$H$57,3))/F107*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(ISBLANK(E107),\"\",IF(E107=0,\"\",IF(ISNUMBER(E107),((J107*E107)/$C107)*N103,\"\")))","v":""},{"$f":"IF(ISBLANK(F107),\"\",IF(F107=0,\"\",IF(ISNUMBER(F107),((K107*F107)/$C107)*O103,\"\")))","v":""},1,1]
["Pumpestationer, bygværker og bassiner 3"]
["Pumpestation (inkl. evt. hydrofor)/trykforøger, Konstruktioner","m³/h ",{"$f":"+Genanskaffelsespriser!$E$175","v":50},1200,1200,1200,0,0,null,{"$f":"IF(E109=0,\"Variabel pris\",IFERROR((HLOOKUP(E109,'Variable priser'!$C$103:$F$105,2)+(E109-HLOOKUP(E109,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(E109,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$I$102/E109*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":786.31156921874981},{"$f":"IF(F109=0,\"Variabel pris\",IFERROR((HLOOKUP(F109,'Variable priser'!$C$103:$F$105,2)+(F109-HLOOKUP(F109,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(F109,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$I$102/F109*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":786.31156921874981},{"$f":"IF(ISBLANK(E109),\"\",IF(E109=0,\"\",IF(ISNUMBER(E109),((J109*E109)/$C109)*N109,\"\")))","v":18871.477661249995},{"$f":"IF(ISBLANK(F109),\"\",IF(F109=0,\"\",IF(ISNUMBER(F109),((K109*F109)/$C109)*O109,\"\")))","v":18871.477661249995},1,1]
["Pumpestation (inkl. evt. hydrofor)/trykforøger, Mek./EL","m³/h ",{"$f":"+Genanskaffelsespriser!$E$176","v":25},1200,1200,1200,0,0,null,{"$f":"IF(E110=0,\"Variabel pris\",IFERROR((HLOOKUP(E110,'Variable priser'!$C$103:$F$105,2)+(E110-HLOOKUP(E110,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(E110,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$J$102/E110*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":2044.4100799687496},{"$f":"IF(F110=0,\"Variabel pris\",IFERROR((HLOOKUP(F110,'Variable priser'!$C$103:$F$105,2)+(F110-HLOOKUP(F110,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(F110,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$J$102/F110*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":2044.4100799687496},{"$f":"IF(ISBLANK(E110),\"\",IF(E110=0,\"\",IF(ISNUMBER(E110),((J110*E110)/$C110)*N109,\"\")))","v":98131.683838499986},{"$f":"IF(ISBLANK(F110),\"\",IF(F110=0,\"\",IF(ISNUMBER(F110),((K110*F110)/$C110)*O109,\"\")))","v":98131.683838499986},1,1]
["Pumpestation (inkl. evt. hydrofor)/trykforøger, SRO","m³/h ",{"$f":"+Genanskaffelsespriser!$E$177","v":10},1200,1200,1200,0,0,null,{"$f":"IF(E111=0,\"Variabel pris\",IFERROR((HLOOKUP(E111,'Variable priser'!$C$103:$F$105,2)+(E111-HLOOKUP(E111,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(E111,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$L$102/E111*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":314.52462768749996},{"$f":"IF(F111=0,\"Variabel pris\",IFERROR((HLOOKUP(F111,'Variable priser'!$C$103:$F$105,2)+(F111-HLOOKUP(F111,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(F111,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$L$102/F111*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":314.52462768749996},{"$f":"IF(ISBLANK(E111),\"\",IF(E111=0,\"\",IF(ISNUMBER(E111),((J111*E111)/$C111)*N109,\"\")))","v":37742.955322499991},{"$f":"IF(ISBLANK(F111),\"\",IF(F111=0,\"Samlet mængde kan ikke være nul i 2025\",IF(ISNUMBER(F111),((K111*F111)/$C111)*O109,\"\")))","v":37742.955322499991},1,1]
["Beholderanlæg - højdebeholder","m³",{"$f":"+Genanskaffelsespriser!$E$178","v":50},0,0,0,0,0,null,{"$f":"IF(E112=0,\"Variabel pris\",IFERROR((HLOOKUP(E112,'Variable priser'!$C$48:$H$50,2)+(E112-HLOOKUP(E112,'Variable priser'!$C$48:$H$50,1))*HLOOKUP(E112,'Variable priser'!$C$48:$H$50,3))/E112*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F112=0,\"Variabel pris\",IFERROR((HLOOKUP(F112,'Variable priser'!$C$48:$H$50,2)+(F112-HLOOKUP(F112,'Variable priser'!$C$48:$H$50,1))*HLOOKUP(F112,'Variable priser'!$C$48:$H$50,3))/F112*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(ISBLANK(E112),\"\",IF(E112=0,\"\",IF(ISNUMBER(E112),((J112*E112)/$C112)*N109,\"\")))","v":""},{"$f":"IF(ISBLANK(F112),\"\",IF(F112=0,\"\",IF(ISNUMBER(F112),((K112*F112)/$C112)*O109,\"\")))","v":""},1,1]
["Beholderanlæg - vandtårn","m³",{"$f":"+Genanskaffelsespriser!$E$179","v":50},0,0,0,0,0,null,{"$f":"IF(E113=0,\"Variabel pris\",IFERROR((HLOOKUP(E113,'Variable priser'!$C$55:$H$57,2)+(E113-HLOOKUP(E113,'Variable priser'!$C$55:$H$57,1))*HLOOKUP(E113,'Variable priser'!$C$55:$H$57,3))/E113*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F113=0,\"Variabel pris\",IFERROR((HLOOKUP(F113,'Variable priser'!$C$55:$H$57,2)+(F113-HLOOKUP(F113,'Variable priser'!$C$55:$H$57,1))*HLOOKUP(F113,'Variable priser'!$C$55:$H$57,3))/F113*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(ISBLANK(E113),\"\",IF(E113=0,\"\",IF(ISNUMBER(E113),((J113*E113)/$C113)*N109,\"\")))","v":""},{"$f":"IF(ISBLANK(F113),\"\",IF(F113=0,\"\",IF(ISNUMBER(F113),((K113*F113)/$C113)*O109,\"\")))","v":""},1,1]
["Pumpestationer, bygværker og bassiner 4"]
["Pumpestation (inkl. evt. hydrofor)/trykforøger, Konstruktioner","m³/h ",{"$f":"+Genanskaffelsespriser!$E$175","v":50},15,15,15,0,0,null,{"$f":"IF(E115=0,\"Variabel pris\",IFERROR((HLOOKUP(E115,'Variable priser'!$C$103:$F$105,2)+(E115-HLOOKUP(E115,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(E115,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$I$102/E115*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":1990.9622249999998},{"$f":"IF(F115=0,\"Variabel pris\",IFERROR((HLOOKUP(F115,'Variable priser'!$C$103:$F$105,2)+(F115-HLOOKUP(F115,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(F115,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$I$102/F115*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":1990.9622249999998},{"$f":"IF(ISBLANK(E115),\"\",IF(E115=0,\"\",IF(ISNUMBER(E115),((J115*E115)/$C115)*N115,\"\")))","v":597.28866749999997},{"$f":"IF(ISBLANK(F115),\"\",IF(F115=0,\"\",IF(ISNUMBER(F115),((K115*F115)/$C115)*O115,\"\")))","v":597.28866749999997},1,1]
["Pumpestation (inkl. evt. hydrofor)/trykforøger, Mek./EL","m³/h ",{"$f":"+Genanskaffelsespriser!$E$176","v":25},15,15,15,0,0,null,{"$f":"IF(E116=0,\"Variabel pris\",IFERROR((HLOOKUP(E116,'Variable priser'!$C$103:$F$105,2)+(E116-HLOOKUP(E116,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(E116,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$J$102/E116*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":5176.5017849999986},{"$f":"IF(F116=0,\"Variabel pris\",IFERROR((HLOOKUP(F116,'Variable priser'!$C$103:$F$105,2)+(F116-HLOOKUP(F116,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(F116,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$J$102/F116*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":5176.5017849999986},{"$f":"IF(ISBLANK(E116),\"\",IF(E116=0,\"\",IF(ISNUMBER(E116),((J116*E116)/$C116)*N115,\"\")))","v":3105.9010709999989},{"$f":"IF(ISBLANK(F116),\"\",IF(F116=0,\"\",IF(ISNUMBER(F116),((K116*F116)/$C116)*O115,\"\")))","v":3105.9010709999989},1,1]
["Pumpestation (inkl. evt. hydrofor)/trykforøger, SRO","m³/h ",{"$f":"+Genanskaffelsespriser!$E$177","v":10},15,15,15,0,0,null,{"$f":"IF(E117=0,\"Variabel pris\",IFERROR((HLOOKUP(E117,'Variable priser'!$C$103:$F$105,2)+(E117-HLOOKUP(E117,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(E117,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$L$102/E117*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":796.38488999999993},{"$f":"IF(F117=0,\"Variabel pris\",IFERROR((HLOOKUP(F117,'Variable priser'!$C$103:$F$105,2)+(F117-HLOOKUP(F117,'Variable priser'!$C$103:$F$105,1))*HLOOKUP(F117,'Variable priser'!$C$103:$F$105,3))*'Variable priser'!$L$102/F117*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":796.38488999999993},{"$f":"IF(ISBLANK(E117),\"\",IF(E117=0,\"\",IF(ISNUMBER(E117),((J117*E117)/$C117)*N115,\"\")))","v":1194.5773349999999},{"$f":"IF(ISBLANK(F117),\"\",IF(F117=0,\"Samlet mængde kan ikke være nul i 2025\",IF(ISNUMBER(F117),((K117*F117)/$C117)*O115,\"\")))","v":1194.5773349999999},1,1]
["Beholderanlæg - højdebeholder","m³",{"$f":"+Genanskaffelsespriser!$E$178","v":50},0,0,0,0,0,null,{"$f":"IF(E118=0,\"Variabel pris\",IFERROR((HLOOKUP(E118,'Variable priser'!$C$48:$H$50,2)+(E118-HLOOKUP(E118,'Variable priser'!$C$48:$H$50,1))*HLOOKUP(E118,'Variable priser'!$C$48:$H$50,3))/E118*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F118=0,\"Variabel pris\",IFERROR((HLOOKUP(F118,'Variable priser'!$C$48:$H$50,2)+(F118-HLOOKUP(F118,'Variable priser'!$C$48:$H$50,1))*HLOOKUP(F118,'Variable priser'!$C$48:$H$50,3))/F118*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(ISBLANK(E118),\"\",IF(E118=0,\"\",IF(ISNUMBER(E118),((J118*E118)/$C118)*N115,\"\")))","v":""},{"$f":"IF(ISBLANK(F118),\"\",IF(F118=0,\"\",IF(ISNUMBER(F118),((K118*F118)/$C118)*O115,\"\")))","v":""},1,1]
["Beholderanlæg - vandtårn","m³",{"$f":"+Genanskaffelsespriser!$E$179","v":50},0,0,0,0,0,null,{"$f":"IF(E119=0,\"Variabel pris\",IFERROR((HLOOKUP(E119,'Variable priser'!$C$55:$H$57,2)+(E119-HLOOKUP(E119,'Variable priser'!$C$55:$H$57,1))*HLOOKUP(E119,'Variable priser'!$C$55:$H$57,3))/E119*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(F119=0,\"Variabel pris\",IFERROR((HLOOKUP(F119,'Variable priser'!$C$55:$H$57,2)+(F119-HLOOKUP(F119,'Variable priser'!$C$55:$H$57,1))*HLOOKUP(F119,'Variable priser'!$C$55:$H$57,3))/F119*(1+Genanskaffelsespriser!$D$203),\"Fejl\"))","v":"Variabel pris"},{"$f":"IF(ISBLANK(E119),\"\",IF(E119=0,\"\",IF(ISNUMBER(E119),((J119*E119)/$C119)*N115,\"\")))","v":""},{"$f":"IF(ISBLANK(F119),\"\",IF(F119=0,\"\",IF(ISNUMBER(F119),((K119*F119)/$C119)*O115,\"\")))","v":""},1,1]
["Andre"]
["Afregningsmålere, mekaniske, ","stk.",{"$f":"Genanskaffelsespriser!E181","v":8},12607,12212,12209,-3.1331799793765366E-2,-2.4566000655093349E-4,null,{"$f":"Genanskaffelsespriser!$D181","v":1348.1},{"$f":"J121","v":1348.1},2057874.65,2057369.1124999998,1,1]
["Afregningsmålere, elektroniske med maksimal gennemstrømning ≤ 4 m3/t","stk.",10,0,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D182","v":1503.6499999999999},{"$f":"J122","v":1503.6499999999999},0,0,1,1]
["Afregningsmålere, elektroniske med maksimal gennemstrømning > 4 m3/t ≤ 15 m3/t","stk.",10,2,2,2,0,0,null,{"$f":"Genanskaffelsespriser!$D183","v":2152.8119999999999},2152.8119999999999,430.56239999999997,430.56239999999997,1,1]
["Afregningsmålere, elektroniske med maksimal gennemstrømning > 15 m3/t ≤ 300 m3/t ","stk.",10,1,2,3,1,0.5,"Opsat en ny måler i 2025, samt fejl i tidligere indberetning",{"$f":"Genanskaffelsespriser!$D184","v":20740},20740,4148,6222,1,1]
["Afregningsmålere, elektroniske med maksimal gennemstrømning > 300 m3/t","stk.",10,0,0,0,0,0,null,{"$f":"Genanskaffelsespriser!$D185","v":26961.999999999996},26961.999999999996,0,0,1,1]
["SRO-brønd/kvarterbrønd/sektionsbrønd, Konstruktioner","stk.",{"$f":"Genanskaffelsespriser!E186","v":50},21,21,21,{"$f":"IF($D126=\"\",IF($E126>0,\"Ny data\",IF($E126=\"\",\"\",0)),IF($D126=0,IF($E126=0,0,\"Ny data\"),($E126-$D126)/$D126))","v":0},{"$f":"IF($E126=\"\",IF($F126>0,\"Ny data\",IF($F126=\"\",\"\",0)),IF($E126=0,IF($F126=0,0,\"Ny data\"),($F126-$E126)/$E126))","v":0},null,{"$f":"Genanskaffelsespriser!$D186","v":81762.264999999999},81762.264999999999,{"$f":"IF(ISNUMBER(E126),((J126*E126)/C126)*N126,\"\")","v":34340.151299999998},{"$f":"IF(ISNUMBER(F126),((K126*F126)/C126)*O126,\"\")","v":34340.151299999998},1,1]
["SRO-brønd/kvarterbrønd/sektionsbrønd, Mek./EL","stk.",{"$f":"Genanskaffelsespriser!E187","v":15},21,21,21,0,0,null,{"$f":"Genanskaffelsespriser!$D187","v":93441.995999999999},93441.995999999999,130818.7944,130818.7944,1,1]
["SRO-brønd/kvarterbrønd/sektionsbrønd, SRO","stk.",{"$f":"Genanskaffelsespriser!E188","v":10},21,21,21,0,0,null,{"$f":"Genanskaffelsespriser!$D188","v":58401.765999999996},58401.765999999996,122643.70859999998,122643.70859999998,1,1]

{"sheet":"Fællesfunktionsanlæg","index":2,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Fællesfunktionsanlæg","Enhed","Standard-levetid","Samlet mængde per 31/12-2023","Samlet mængde per 31/12-2024","Samlet mængde per 31/12-2025","Afvigelse\n2023-2024","Afvigelse\n2024-2025","Bemærkninger","Enhedspris\n2024","Enhedspris\n2025","Netvolumenbidrag\n2024","Netvolumenbidrag\n2025","Ejerandel 2024 (%)","Ejerandel 2025 (%)"]
["Andre",null,null,null,null,null,{"$f":"IF($D$2=\"\",IF($E$2>0,\"Ny data\",IF($E$2=\"\",\"\",0)),IF($D$2=0,IF($E$2=0,0,\"Ny data\"),($E$2-$D$2)/$D$2))","v":""},{"$f":"IF($E$2=\"\",IF($F$2>0,\"Ny data\",IF($F$2=\"\",\"\",0)),IF($E$2=0,IF($F$2=0,0,\"Ny data\"),($F$2-$E$2)/$E$2))","v":""},null,null,null,null,null,1]
["Arbejdsplads og kontor","stk.",5,30,30,29,{"$f":"IF($D$3=\"\",IF($E$3>0,\"Ny data\",IF($E$3=\"\",\"\",0)),IF($D$3=0,IF($E$3=0,0,\"Ny data\"),($E$3-$D$3)/$D$3))","v":0},{"$f":"IF($E$3=\"\",IF($F$3>0,\"Ny data\",IF($F$3=\"\",\"\",0)),IF($E$3=0,IF($F$3=0,0,\"Ny data\"),($F$3-$E$3)/$E$3))","v":-3.3333333333333333E-2},null,{"$f":"Genanskaffelsespriser!D193","v":36295},{"$f":"J3","v":36295},{"$f":"IF(ISNUMBER(E3),((J3*E3)/C3)*N3,\"\")","v":217770},{"$f":"IF(ISNUMBER(F3),((K3*F3)/C3)*O3,\"\")","v":210511},1,1]
["Køretøjer, personbil","stk.",5,2,2,2,{"$f":"IF($D$4=\"\",IF($E$4>0,\"Ny data\",IF($E$4=\"\",\"\",0)),IF($D$4=0,IF($E$4=0,0,\"Ny data\"),($E$4-$D$4)/$D$4))","v":0},{"$f":"IF($E$4=\"\",IF($F$4>0,\"Ny data\",IF($F$4=\"\",\"\",0)),IF($E$4=0,IF($F$4=0,0,\"Ny data\"),($F$4-$E$4)/$E$4))","v":0},null,{"$f":"Genanskaffelsespriser!D194","v":225000},{"$f":"J4","v":225000},{"$f":"IF(ISNUMBER(E4),((J4*E4)/C4)*N4,\"\")","v":90000},{"$f":"IF(ISNUMBER(F4),((K4*F4)/C4)*O4,\"\")","v":90000},1,1]
["Køretøjer, små lastvogne (< 3.500 kg.)","stk.",5,3,3,8,{"$f":"IF($D$5=\"\",IF($E$5>0,\"Ny data\",IF($E$5=\"\",\"\",0)),IF($D$5=0,IF($E$5=0,0,\"Ny data\"),($E$5-$D$5)/$D$5))","v":0},{"$f":"IF($E$5=\"\",IF($F$5>0,\"Ny data\",IF($F$5=\"\",\"\",0)),IF($E$5=0,IF($F$5=0,0,\"Ny data\"),($F$5-$E$5)/$E$5))","v":1.6666666666666667},"Der er indkøbt 5 nye små lastvogne i 2025",{"$f":"Genanskaffelsespriser!D195","v":250000},250000,150000,400000,1,1]
["Køretøjer, store lastvogne (> 3.500 kg.)","stk.",5,3,0,0,{"$f":"IF($D$6=\"\",IF($E$6>0,\"Ny data\",IF($E$6=\"\",\"\",0)),IF($D$6=0,IF($E$6=0,0,\"Ny data\"),($E$6-$D$6)/$D$6))","v":-1},{"$f":"IF($E$6=\"\",IF($F$6>0,\"Ny data\",IF($F$6=\"\",\"\",0)),IF($E$6=0,IF($F$6=0,0,\"Ny data\"),($F$6-$E$6)/$E$6))","v":0},"Lastvognene er blevet solgt",{"$f":"Genanskaffelsespriser!$D196","v":1300000},1300000,0,0,1,1]
["Køretøjer, entreprenørmaskiner","stk.",5,16,5,4,{"$f":"IF($D$7=\"\",IF($E$7>0,\"Ny data\",IF($E$7=\"\",\"\",0)),IF($D$7=0,IF($E$7=0,0,\"Ny data\"),($E$7-$D$7)/$D$7))","v":-0.6875},{"$f":"IF($E$7=\"\",IF($F$7>0,\"Ny data\",IF($F$7=\"\",\"\",0)),IF($E$7=0,IF($F$7=0,0,\"Ny data\"),($F$7-$E$7)/$E$7))","v":-0.2},"Entreprenørmaskinerne er løbende blevet solgt, hvilket er årsag til ændringen i mængden",{"$f":"Genanskaffelsespriser!D197","v":400000},400000,400000,320000,1,1]
["Solcelleanlæg ekskl. Inverter","kWp",25,0,0,0,{"$f":"IF($D$8=\"\",IF($E$8>0,\"Ny data\",IF($E$8=\"\",\"\",0)),IF($D$8=0,IF($E$8=0,0,\"Ny data\"),($E$8-$D$8)/$D$8))","v":0},{"$f":"IF($E$8=\"\",IF($F$8>0,\"Ny data\",IF($F$8=\"\",\"\",0)),IF($E$8=0,IF($F$8=0,0,\"Ny data\"),($F$8-$E$8)/$E$8))","v":0},null,{"$f":"Genanskaffelsespriser!D199","v":5400},5400,{"$f":"IF(OR(ISBLANK(E8),ISBLANK(N8)),\"\",(((E8*J8)/C8)*N8)*(IF(SUM(E10:E11)<>0,E11/SUM(E10:E11),1)))","v":0},{"$f":"IF(OR(ISBLANK(F8),ISBLANK(O8)),\"\",(((F8*K8)/C8)*O8)*(IF(SUM(F10:F11)<>0,F11/SUM(F10:F11),1)))","v":0},1,1]
["Inverter til solcelleanlæg","kWp",10,0,0,0,{"$f":"IF($D$9=\"\",IF($E$9>0,\"Ny data\",IF($E$9=\"\",\"\",0)),IF($D$9=0,IF($E$9=0,0,\"Ny data\"),($E$9-$D$9)/$D$9))","v":0},{"$f":"IF($E$9=\"\",IF($F$9>0,\"Ny data\",IF($F$9=\"\",\"\",0)),IF($E$9=0,IF($F$9=0,0,\"Ny data\"),($F$9-$E$9)/$E$9))","v":0},null,{"$f":"Genanskaffelsespriser!D200","v":600},600,{"$f":"IF(OR(ISBLANK(E9),ISBLANK(N9)),\"\",(((E9*J9)/C9)*N9)*(IF(SUM(E10:E11)<>0,E11/SUM(E10:E11),1)))","v":0},{"$f":"IF(OR(ISBLANK(F9),ISBLANK(O9)),\"\",(((F9*K9)/C9)*O9)*(IF(SUM(F10:F11)<>0,F11/SUM(F10:F11),1)))","v":0},1,1]
["Internt brug af produceret solcellestrøm 2024","MWh",null,0,0,0,{"$f":"IF($D10=\"\",IF($E10>0,\"Ny data\",IF($E10=\"\",\"\",0)),IF($D10=0,IF($E10=0,0,\"Ny data\"),($E10-$D10)/$D10))","v":0},{"$f":"IF($E$10=\"\",IF($F$10>0,\"Ny data\",IF($F$10=\"\",\"\",0)),IF($E$10=0,IF($F$10=0,0,\"Ny data\"),($F$10-$E$10)/$E$10))","v":0},null,null,null,null,null,1,1]
["Eksternt afsat produceret solcellestrøm 2024","MWh",null,0,0,0,{"$f":"IF($D11=\"\",IF($E11>0,\"Ny data\",IF($E11=\"\",\"\",0)),IF($D11=0,IF($E11=0,0,\"Ny data\"),($E11-$D11)/$D11))","v":0},{"$f":"IF($E$11=\"\",IF($F$11>0,\"Ny data\",IF($F$11=\"\",\"\",0)),IF($E$11=0,IF($F$11=0,0,\"Ny data\"),($F$11-$E$11)/$E$11))","v":0},null,null,null,null,null,1,1]

{"sheet":"Genanskaffelsespriser","index":3,"n_rows":203,"n_cols":5,"rows_kept":203,"cut":false,"hidden":false,"merged":[[2471,2,2472,2],[2471,3,2472,3],[2471,4,2472,4],[2678,2,2679,2],[2678,3,2679,3],[2678,4,2679,4],[2057,2,2058,2],[2057,3,2058,3],[2057,4,2058,4],[2264,2,2265,2],[2264,3,2265,3],[2264,4,2265,4],[1643,2,1644,2],[1643,3,1644,3],[1643,4,1644,4],[1850,2,1851,2],[1850,3,1851,3],[1850,4,1851,4],[1436,2,1437,2],[1436,3,1437,3],[1436,4,1437,4],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[4955,2,4956,2],[4955,3,4956,3],[4955,4,4956,4],[5162,2,5163,2],[5162,3,5163,3],[5162,4,5163,4],[4541,2,4542,2],[4541,3,4542,3],[4541,4,4542,4],[4748,2,4749,2],[4748,3,4749,3],[4748,4,4749,4],[4127,2,4128,2],[4127,3,4128,3],[4127,4,4128,4],[4334,2,4335,2],[4334,3,4335,3],[4334,4,4335,4],[3713,2,3714,2],[3713,3,3714,3],[3713,4,3714,4],[3920,2,3921,2],[3920,3,3921,3],[3920,4,3921,4],[3299,2,3300,2],[3299,3,3300,3],[3299,4,3300,4],[3506,2,3507,2],[3506,3,3507,3],[3506,4,3507,4],[2885,2,2886,2],[2885,3,2886,3],[2885,4,2886,4],[3092,2,3093,2],[3092,3,3093,3],[3092,4,3093,4],[7439,2,7440,2],[7439,3,7440,3],[7439,4,7440,4],[7646,2,7647,2],[7646,3,7647,3],[7646,4,7647,4],[7025,2,7026,2],[7025,3,7026,3],[7025,4,7026,4],[7232,2,7233,2],[7232,3,7233,3],[7232,4,7233,4],[6611,2,6612,2],[6611,3,6612,3],[6611,4,6612,4],[6818,2,6819,2],[6818,3,6819,3],[6818,4,6819,4],[6197,2,6198,2],[6197,3,6198,3],[6197,4,6198,4],[6404,2,6405,2],[6404,3,6405,3],[6404,4,6405,4],[5783,2,5784,2],[5783,3,5784,3],[5783,4,5784,4],[5990,2,5991,2],[5990,3,5991,3],[5990,4,5991,4],[5369,2,5370,2],[5369,3,5370,3],[5369,4,5370,4],[5576,2,5577,2],[5576,3,5577,3],[5576,4,5577,4],[9923,2,9924,2],[9923,3,9924,3],[9923,4,9924,4],[10130,2,10131,2],[10130,3,10131,3],[10130,4,10131,4],[9509,2,9510,2],[9509,3,9510,3],[9509,4,9510,4],[9716,2,9717,2],[9716,3,9717,3],[9716,4,9717,4],[9095,2,9096,2],[9095,3,9096,3],[9095,4,9096,4],[9302,2,9303,2],[9302,3,9303,3],[9302,4,9303,4],[8681,2,8682,2],[8681,3,8682,3],[8681,4,8682,4],[8888,2,8889,2],[8888,3,8889,3],[8888,4,8889,4],[8267,2,8268,2],[8267,3,8268,3],[8267,4,8268,4],[8474,2,8475,2],[8474,3,8475,3],[8474,4,8475,4],[7853,2,7854,2],[7853,3,7854,3],[7853,4,7854,4],[8060,2,8061,2],[8060,3,8061,3],[8060,4,8061,4],[12407,2,12408,2],[12407,3,12408,3],[12407,4,12408,4],[12614,2,12615,2],[12614,3,12615,3],[12614,4,12615,4],[11993,2,11994,2],[11993,3,11994,3],[11993,4,11994,4],[12200,2,12201,2],[12200,3,12201,3],[12200,4,12201,4],[11579,2,11580,2],[11579,3,11580,3],[11579,4,11580,4],[11786,2,11787,2],[11786,3,11787,3],[11786,4,11787,4],[11165,2,11166,2],[11165,3,11166,3],[11165,4,11166,4],[11372,2,11373,2],[11372,3,11373,3],[11372,4,11373,4],[10751,2,10752,2],[10751,3,10752,3],[10751,4,10752,4],[10958,2,10959,2],[10958,3,10959,3],[10958,4,10959,4],[10337,2,10338,2],[10337,3,10338,3],[10337,4,10338,4],[10544,2,10545,2],[10544,3,10545,3],[10544,4,10545,4],[14891,2,14892,2],[14891,3,14892,3],[14891,4,14892,4],[15098,2,15099,2],[15098,3,15099,3],[15098,4,15099,4],[14477,2,14478,2],[14477,3,14478,3],[14477,4,14478,4],[14684,2,14685,2],[14684,3,14685,3],[14684,4,14685,4],[14063,2,14064,2],[14063,3,14064,3],[14063,4,14064,4],[14270,2,14271,2],[14270,3,14271,3],[14270,4,14271,4],[13649,2,13650,2],[13649,3,13650,3],[13649,4,13650,4],[13856,2,13857,2],[13856,3,13857,3],[13856,4,13857,4],[13235,2,13236,2],[13235,3,13236,3],[13235,4,13236,4],[13442,2,13443,2],[13442,3,13443,3],[13442,4,13443,4],[12821,2,12822,2],[12821,3,12822,3],[12821,4,12822,4],[13028,2,13029,2],[13028,3,13029,3],[13028,4,13029,4],[17375,2,17376,2],[17375,3,17376,3],[17375,4,17376,4],[17582,2,17583,2],[17582,3,17583,3],[17582,4,17583,4],[16961,2,16962,2],[16961,3,16962,3],[16961,4,16962,4],[17168,2,17169,2],[17168,3,17169,3],[17168,4,17169,4],[16547,2,16548,2],[16547,3,16548,3],[16547,4,16548,4],[16754,2,16755,2],[16754,3,16755,3],[16754,4,16755,4],[16133,2,16134,2],[16133,3,16134,3],[16133,4,16134,4],[16340,2,16341,2],[16340,3,16341,3],[16340,4,16341,4],[15719,2,15720,2],[15719,3,15720,3],[15719,4,15720,4],[15926,2,15927,2],[15926,3,15927,3],[15926,4,15927,4],[15305,2,15306,2],[15305,3,15306,3],[15305,4,15306,4],[15512,2,15513,2],[15512,3,15513,3],[15512,4,15513,4],[19859,2,19860,2],[19859,3,19860,3],[19859,4,19860,4],[20066,2,20067,2],[20066,3,20067,3],[20066,4,20067,4],[19445,2,19446,2],[19445,3,19446,3],[19445,4,19446,4],[19652,2,19653,2],[19652,3,19653,3],[19652,4,19653,4],[19031,2,19032,2],[19031,3,19032,3],[19031,4,19032,4],[19238,2,19239,2],[19238,3,19239,3],[19238,4,19239,4],[18617,2,18618,2],[18617,3,18618,3],[18617,4,18618,4],[18824,2,18825,2],[18824,3,18825,3],[18824,4,18825,4],[18203,2,18204,2],[18203,3,18204,3],[18203,4,18204,4],[18410,2,18411,2],[18410,3,18411,3],[18410,4,18411,4],[17789,2,17790,2],[17789,3,17790,3],[17789,4,17790,4],[17996,2,17997,2],[17996,3,17997,3],[17996,4,17997,4],[22343,2,22344,2],[22343,3,22344,3],[22343,4,22344,4],[22550,2,22551,2],[22550,3,22551,3],[22550,4,22551,4],[21929,2,21930,2],[21929,3,21930,3],[21929,4,21930,4],[22136,2,22137,2],[22136,3,22137,3],[22136,4,22137,4],[21515,2,21516,2],[21515,3,21516,3],[21515,4,21516,4],[21722,2,21723,2],[21722,3,21723,3],[21722,4,21723,4],[21101,2,21102,2],[21101,3,21102,3],[21101,4,21102,4],[21308,2,21309,2],[21308,3,21309,3],[21308,4,21309,4],[20687,2,20688,2],[20687,3,20688,3],[20687,4,20688,4],[20894,2,20895,2],[20894,3,20895,3],[20894,4,20895,4],[20273,2,20274,2],[20273,3,20274,3],[20273,4,20274,4],[20480,2,20481,2],[20480,3,20481,3],[20480,4,20481,4],[24827,2,24828,2],[24827,3,24828,3],[24827,4,24828,4],[25034,2,25035,2],[25034,3,25035,3],[25034,4,25035,4],[24413,2,24414,2],[24413,3,24414,3],[24413,4,24414,4],[24620,2,24621,2],[24620,3,24621,3],[24620,4,24621,4],[23999,2,24000,2],[23999,3,24000,3],[23999,4,24000,4],[24206,2,24207,2],[24206,3,24207,3],[24206,4,24207,4],[23585,2,23586,2],[23585,3,23586,3],[23585,4,23586,4],[23792,2,23793,2],[23792,3,23793,3],[23792,4,23793,4],[23171,2,23172,2],[23171,3,23172,3],[23171,4,23172,4],[23378,2,23379,2],[23378,3,23379,3],[23378,4,23379,4],[22757,2,22758,2],[22757,3,22758,3],[22757,4,22758,4],[22964,2,22965,2],[22964,3,22965,3],[22964,4,22965,4],[27311,2,27312,2],[27311,3,27312,3],[27311,4,27312,4],[27518,2,27519,2],[27518,3,27519,3],[27518,4,27519,4],[26897,2,26898,2],[26897,3,26898,3],[26897,4,26898,4],[27104,2,27105,2],[27104,3,27105,3],[27104,4,27105,4],[26483,2,26484,2],[26483,3,26484,3],[26483,4,26484,4],[26690,2,26691,2],[26690,3,26691,3],[26690,4,26691,4],[26069,2,26070,2],[26069,3,26070,3],[26069,4,26070,4],[26276,2,26277,2],[26276,3,26277,3],[26276,4,26277,4],[25655,2,25656,2],[25655,3,25656,3],[25655,4,25656,4],[25862,2,25863,2],[25862,3,25863,3],[25862,4,25863,4],[25241,2,25242,2],[25241,3,25242,3],[25241,4,25242,4],[25448,2,25449,2],[25448,3,25449,3],[25448,4,25449,4],[29795,2,29796,2],[29795,3,29796,3],[29795,4,29796,4],[30002,2,30003,2],[30002,3,30003,3],[30002,4,30003,4],[29381,2,29382,2],[29381,3,29382,3],[29381,4,29382,4],[29588,2,29589,2],[29588,3,29589,3],[29588,4,29589,4],[28967,2,28968,2],[28967,3,28968,3],[28967,4,28968,4],[29174,2,29175,2],[29174,3,29175,3],[29174,4,29175,4],[28553,2,28554,2],[28553,3,28554,3],[28553,4,28554,4],[28760,2,28761,2],[28760,3,28761,3],[28760,4,28761,4],[28139,2,28140,2],[28139,3,28140,3],[28139,4,28140,4],[28346,2,28347,2],[28346,3,28347,3],[28346,4,28347,4],[27725,2,27726,2],[27725,3,27726,3],[27725,4,27726,4],[27932,2,27933,2],[27932,3,27933,3],[27932,4,27933,4],[32279,2,32280,2],[32279,3,32280,3],[32279,4,32280,4],[32486,2,32487,2],[32486,3,32487,3],[32486,4,32487,4],[31865,2,31866,2],[31865,3,31866,3],[31865,4,31866,4],[32072,2,32073,2],[32072,3,32073,3],[32072,4,32073,4],[31451,2,31452,2],[31451,3,31452,3],[31451,4,31452,4],[31658,2,31659,2],[31658,3,31659,3],[31658,4,31659,4],[31037,2,31038,2],[31037,3,31038,3],[31037,4,31038,4],[31244,2,31245,2],[31244,3,31245,3],[31244,4,31245,4],[30623,2,30624,2],[30623,3,30624,3],[30623,4,30624,4],[30830,2,30831,2],[30830,3,30831,3],[30830,4,30831,4],[30209,2,30210,2],[30209,3,30210,3],[30209,4,30210,4],[30416,2,30417,2],[30416,3,30417,3],[30416,4,30417,4],[34763,2,34764,2],[34763,3,34764,3],[34763,4,34764,4],[34970,2,34971,2],[34970,3,34971,3],[34970,4,34971,4],[34349,2,34350,2],[34349,3,34350,3],[34349,4,34350,4],[34556,2,34557,2],[34556,3,34557,3],[34556,4,34557,4],[33935,2,33936,2],[33935,3,33936,3],[33935,4,33936,4],[34142,2,34143,2],[34142,3,34143,3],[34142,4,34143,4],[33521,2,33522,2],[33521,3,33522,3],[33521,4,33522,4],[33728,2,33729,2],[33728,3,33729,3],[33728,4,33729,4],[33107,2,33108,2],[33107,3,33108,3],[33107,4,33108,4],[33314,2,33315,2],[33314,3,33315,3],[33314,4,33315,4],[32693,2,32694,2],[32693,3,32694,3],[32693,4,32694,4],[32900,2,32901,2],[32900,3,32901,3],[32900,4,32901,4],[37247,2,37248,2],[37247,3,37248,3],[37247,4,37248,4],[37454,2,37455,2],[37454,3,37455,3],[37454,4,37455,4],[36833,2,36834,2],[36833,3,36834,3],[36833,4,36834,4],[37040,2,37041,2],[37040,3,37041,3],[37040,4,37041,4],[36419,2,36420,2],[36419,3,36420,3],[36419,4,36420,4],[36626,2,36627,2],[36626,3,36627,3],[36626,4,36627,4],[36005,2,36006,2],[36005,3,36006,3],[36005,4,36006,4],[36212,2,36213,2],[36212,3,36213,3],[36212,4,36213,4],[35591,2,35592,2],[35591,3,35592,3],[35591,4,35592,4],[35798,2,35799,2],[35798,3,35799,3],[35798,4,35799,4],[35177,2,35178,2],[35177,3,35178,3],[35177,4,35178,4],[35384,2,35385,2],[35384,3,35385,3],[35384,4,35385,4],[39731,2,39732,2],[39731,3,39732,3],[39731,4,39732,4],[39938,2,39939,2],[39938,3,39939,3],[39938,4,39939,4],[39317,2,39318,2],[39317,3,39318,3],[39317,4,39318,4],[39524,2,39525,2],[39524,3,39525,3],[39524,4,39525,4],[38903,2,38904,2],[38903,3,38904,3],[38903,4,38904,4],[39110,2,39111,2],[39110,3,39111,3],[39110,4,39111,4],[38489,2,38490,2],[38489,3,38490,3],[38489,4,38490,4],[38696,2,38697,2],[38696,3,38697,3],[38696,4,38697,4],[38075,2,38076,2],[38075,3,38076,3],[38075,4,38076,4],[38282,2,38283,2],[38282,3,38283,3],[38282,4,38283,4],[37661,2,37662,2],[37661,3,37662,3],[37661,4,37662,4],[37868,2,37869,2],[37868,3,37869,3],[37868,4,37869,4],[42215,2,42216,2],[42215,3,42216,3],[42215,4,42216,4],[42422,2,42423,2],[42422,3,42423,3],[42422,4,42423,4],[41801,2,41802,2],[41801,3,41802,3],[41801,4,41802,4],[42008,2,42009,2],[42008,3,42009,3],[42008,4,42009,4],[41387,2,41388,2],[41387,3,41388,3],[41387,4,41388,4],[41594,2,41595,2],[41594,3,41595,3],[41594,4,41595,4],[40973,2,40974,2],[40973,3,40974,3],[40973,4,40974,4],[41180,2,41181,2],[41180,3,41181,3],[41180,4,41181,4],[40559,2,40560,2],[40559,3,40560,3],[40559,4,40560,4],[40766,2,40767,2],[40766,3,40767,3],[40766,4,40767,4],[40145,2,40146,2],[40145,3,40146,3],[40145,4,40146,4],[40352,2,40353,2],[40352,3,40353,3],[40352,4,40353,4],[44699,2,44700,2],[44699,3,44700,3],[44699,4,44700,4],[44906,2,44907,2],[44906,3,44907,3],[44906,4,44907,4],[44285,2,44286,2],[44285,3,44286,3],[44285,4,44286,4],[44492,2,44493,2],[44492,3,44493,3],[44492,4,44493,4],[43871,2,43872,2],[43871,3,43872,3],[43871,4,43872,4],[44078,2,44079,2],[44078,3,44079,3],[44078,4,44079,4],[43457,2,43458,2],[43457,3,43458,3],[43457,4,43458,4],[43664,2,43665,2],[43664,3,43665,3],[43664,4,43665,4],[43043,2,43044,2],[43043,3,43044,3],[43043,4,43044,4],[43250,2,43251,2],[43250,3,43251,3],[43250,4,43251,4],[42629,2,42630,2],[42629,3,42630,3],[42629,4,42630,4],[42836,2,42837,2],[42836,3,42837,3],[42836,4,42837,4],[47183,2,47184,2],[47183,3,47184,3],[47183,4,47184,4],[47390,2,47391,2],[47390,3,47391,3],[47390,4,47391,4],[46769,2,46770,2],[46769,3,46770,3],[46769,4,46770,4],[46976,2,46977,2],[46976,3,46977,3],[46976,4,46977,4],[46355,2,46356,2],[46355,3,46356,3],[46355,4,46356,4],[46562,2,46563,2],[46562,3,46563,3],[46562,4,46563,4],[45941,2,45942,2],[45941,3,45942,3],[45941,4,45942,4],[46148,2,46149,2],[46148,3,46149,3],[46148,4,46149,4],[45527,2,45528,2],[45527,3,45528,3],[45527,4,45528,4],[45734,2,45735,2],[45734,3,45735,3],[45734,4,45735,4],[45113,2,45114,2],[45113,3,45114,3],[45113,4,45114,4],[45320,2,45321,2],[45320,3,45321,3],[45320,4,45321,4],[49667,2,49668,2],[49667,3,49668,3],[49667,4,49668,4],[49874,2,49875,2],[49874,3,49875,3],[49874,4,49875,4],[49253,2,49254,2],[49253,3,49254,3],[49253,4,49254,4],[49460,2,49461,2],[49460,3,49461,3],[49460,4,49461,4],[48839,2,48840,2],[48839,3,48840,3],[48839,4,48840,4],[49046,2,49047,2],[49046,3,49047,3],[49046,4,49047,4],[48425,2,48426,2],[48425,3,48426,3],[48425,4,48426,4],[48632,2,48633,2],[48632,3,48633,3],[48632,4,48633,4],[48011,2,48012,2],[48011,3,48012,3],[48011,4,48012,4],[48218,2,48219,2],[48218,3,48219,3],[48218,4,48219,4],[47597,2,47598,2],[47597,3,47598,3],[47597,4,47598,4],[47804,2,47805,2],[47804,3,47805,3],[47804,4,47805,4],[52151,2,52152,2],[52151,3,52152,3],[52151,4,52152,4],[52358,2,52359,2],[52358,3,52359,3],[52358,4,52359,4],[51737,2,51738,2],[51737,3,51738,3],[51737,4,51738,4],[51944,2,51945,2],[51944,3,51945,3],[51944,4,51945,4],[51323,2,51324,2],[51323,3,51324,3],[51323,4,51324,4],[51530,2,51531,2],[51530,3,51531,3],[51530,4,51531,4],[50909,2,50910,2],[50909,3,50910,3],[50909,4,50910,4],[51116,2,51117,2],[51116,3,51117,3],[51116,4,51117,4],[50495,2,50496,2],[50495,3,50496,3],[50495,4,50496,4],[50702,2,50703,2],[50702,3,50703,3],[50702,4,50703,4],[50081,2,50082,2],[50081,3,50082,3],[50081,4,50082,4],[50288,2,50289,2],[50288,3,50289,3],[50288,4,50289,4],[54635,2,54636,2],[54635,3,54636,3],[54635,4,54636,4],[54842,2,54843,2],[54842,3,54843,3],[54842,4,54843,4],[54221,2,54222,2],[54221,3,54222,3],[54221,4,54222,4],[54428,2,54429,2],[54428,3,54429,3],[54428,4,54429,4],[53807,2,53808,2],[53807,3,53808,3],[53807,4,53808,4],[54014,2,54015,2],[54014,3,54015,3],[54014,4,54015,4],[53393,2,53394,2],[53393,3,53394,3],[53393,4,53394,4],[53600,2,53601,2],[53600,3,53601,3],[53600,4,53601,4],[52979,2,52980,2],[52979,3,52980,3],[52979,4,52980,4],[53186,2,53187,2],[53186,3,53187,3],[53186,4,53187,4],[52565,2,52566,2],[52565,3,52566,3],[52565,4,52566,4],[52772,2,52773,2],[52772,3,52773,3],[52772,4,52773,4],[57119,2,57120,2],[57119,3,57120,3],[57119,4,57120,4],[57326,2,57327,2],[57326,3,57327,3],[57326,4,57327,4],[56705,2,56706,2],[56705,3,56706,3],[56705,4,56706,4],[56912,2,56913,2],[56912,3,56913,3],[56912,4,56913,4],[56291,2,56292,2],[56291,3,56292,3],[56291,4,56292,4],[56498,2,56499,2],[56498,3,56499,3],[56498,4,56499,4],[55877,2,55878,2],[55877,3,55878,3],[55877,4,55878,4],[56084,2,56085,2],[56084,3,56085,3],[56084,4,56085,4],[55463,2,55464,2],[55463,3,55464,3],[55463,4,55464,4],[55670,2,55671,2],[55670,3,55671,3],[55670,4,55671,4],[55049,2,55050,2],[55049,3,55050,3],[55049,4,55050,4],[55256,2,55257,2],[55256,3,55257,3],[55256,4,55257,4],[59603,2,59604,2],[59603,3,59604,3],[59603,4,59604,4],[59810,2,59811,2],[59810,3,59811,3],[59810,4,59811,4],[59189,2,59190,2],[59189,3,59190,3],[59189,4,59190,4],[59396,2,59397,2],[59396,3,59397,3],[59396,4,59397,4],[58775,2,58776,2],[58775,3,58776,3],[58775,4,58776,4],[58982,2,58983,2],[58982,3,58983,3],[58982,4,58983,4],[58361,2,58362,2],[58361,3,58362,3],[58361,4,58362,4],[58568,2,58569,2],[58568,3,58569,3],[58568,4,58569,4],[57947,2,57948,2],[57947,3,57948,3],[57947,4,57948,4],[58154,2,58155,2],[58154,3,58155,3],[58154,4,58155,4],[57533,2,57534,2],[57533,3,57534,3],[57533,4,57534,4],[57740,2,57741,2],[57740,3,57741,3],[57740,4,57741,4],[62087,2,62088,2],[62087,3,62088,3],[62087,4,62088,4],[62294,2,62295,2],[62294,3,62295,3],[62294,4,62295,4],[61673,2,61674,2],[61673,3,61674,3],[61673,4,61674,4],[61880,2,61881,2],[61880,3,61881,3],[61880,4,61881,4],[61259,2,61260,2],[61259,3,61260,3],[61259,4,61260,4],[61466,2,61467,2],[61466,3,61467,3],[61466,4,61467,4],[60845,2,60846,2],[60845,3,60846,3],[60845,4,60846,4],[61052,2,61053,2],[61052,3,61053,3],[61052,4,61053,4],[60431,2,60432,2],[60431,3,60432,3],[60431,4,60432,4],[60638,2,60639,2],[60638,3,60639,3],[60638,4,60639,4],[60017,2,60018,2],[60017,3,60018,3],[60017,4,60018,4],[60224,2,60225,2],[60224,3,60225,3],[60224,4,60225,4],[64571,2,64572,2],[64571,3,64572,3],[64571,4,64572,4],[64778,2,64779,2],[64778,3,64779,3],[64778,4,64779,4],[64157,2,64158,2],[64157,3,64158,3],[64157,4,64158,4],[64364,2,64365,2],[64364,3,64365,3],[64364,4,64365,4],[63743,2,63744,2],[63743,3,63744,3],[63743,4,63744,4],[63950,2,63951,2],[63950,3,63951,3],[63950,4,63951,4],[63329,2,63330,2],[63329,3,63330,3],[63329,4,63330,4],[63536,2,63537,2],[63536,3,63537,3],[63536,4,63537,4],[62915,2,62916,2],[62915,3,62916,3],[62915,4,62916,4],[63122,2,63123,2],[63122,3,63123,3],[63122,4,63123,4],[62501,2,62502,2],[62501,3,62502,3],[62501,4,62502,4],[62708,2,62709,2],[62708,3,62709,3],[62708,4,62709,4],[67055,2,67056,2],[67055,3,67056,3],[67055,4,67056,4],[67262,2,67263,2],[67262,3,67263,3],[67262,4,67263,4],[66641,2,66642,2],[66641,3,66642,3],[66641,4,66642,4],[66848,2,66849,2],[66848,3,66849,3],[66848,4,66849,4],[66227,2,66228,2],[66227,3,66228,3],[66227,4,66228,4],[66434,2,66435,2],[66434,3,66435,3],[66434,4,66435,4],[65813,2,65814,2],[65813,3,65814,3],[65813,4,65814,4],[66020,2,66021,2],[66020,3,66021,3],[66020,4,66021,4],[65399,2,65400,2],[65399,3,65400,3],[65399,4,65400,4],[65606,2,65607,2],[65606,3,65607,3],[65606,4,65607,4],[64985,2,64986,2],[64985,3,64986,3],[64985,4,64986,4],[65192,2,65193,2],[65192,3,65193,3],[65192,4,65193,4],[69539,2,69540,2],[69539,3,69540,3],[69539,4,69540,4],[69746,2,69747,2],[69746,3,69747,3],[69746,4,69747,4],[69125,2,69126,2],[69125,3,69126,3],[69125,4,69126,4],[69332,2,69333,2],[69332,3,69333,3],[69332,4,69333,4],[68711,2,68712,2],[68711,3,68712,3],[68711,4,68712,4],[68918,2,68919,2],[68918,3,68919,3],[68918,4,68919,4],[68297,2,68298,2],[68297,3,68298,3],[68297,4,68298,4],[68504,2,68505,2],[68504,3,68505,3],[68504,4,68505,4],[67883,2,67884,2],[67883,3,67884,3],[67883,4,67884,4],[68090,2,68091,2],[68090,3,68091,3],[68090,4,68091,4],[67469,2,67470,2],[67469,3,67470,3],[67469,4,67470,4],[67676,2,67677,2],[67676,3,67677,3],[67676,4,67677,4],[72023,2,72024,2],[72023,3,72024,3],[72023,4,72024,4]],"merged_total":15181,"flags":["merged_cut"]}
[null,"Genanskaffelsespriser","Måleenhed","Vægtet \nenhedspris","Teknisk levetid"]
[]
[null,"Produktionsanlæg:"]
[null,"Boringer"]
[null,"Boring (inkl. etablering, forerør, filter og prøvepumpning)","kr./m.",2538,30]
[null,"Råvandsstationer"]
[null,"Råvandsstation komplet montering og boringshus/tørbrønd","kr./stk.",{"$f":"57810*(1+D203)","v":59948.969999999994},30]
[null,"Instrumenter (flowmåler+tryk transducer+alarmer)","kr./stk.",{"$f":"65241*(1+D203)","v":67654.917000000001},10]
[null,"Pumpe inkl. stigrør og forerørsforsejlinger mv.","kr/m³/h ","Variabel",15]
[null,"Erstatninger (OBS ingen øst-tillæg eller øvrige tillæg) ","kr/stk",44911,30]
[null,"Hegn","kr./stk.",{"$f":"85428*(1+D203)","v":88588.835999999996},15]
[null,"Elanlæg","kr./boring",{"$f":"108657*(1+D203)","v":112677.30899999999},20]
[null,"SRO anlæg","kr./boring",{"$f":"29256*(1+D203)","v":30338.471999999998},10]
[null,"Råvandsledninger - Land"]
[null,"Ø 50mm < Ledningsnet ≤ Ø110 mm","kr./m.",{"$f":"354*(1+D203)","v":367.09799999999996},75]
[null,"Ø110 mm < Ledningsnet ≤ Ø 250 mm","kr./m.",{"$f":"1018*(1+D203)","v":1055.6659999999999},75]
[null,"Ø 250 mm < Ledningsnet ≤ Ø 500mm","kr./m.",{"$f":"2335*(1+D203)","v":2421.395},75]
[null,"Ledningsnet > Ø 500 mm","kr./m.",{"$f":"5029*(1+D203)","v":5215.0729999999994},75]
[null,"Råvandsledninger - By"]
[null,"Ø 50mm < Ledningsnet ≤ Ø110 mm","kr./m.",{"$f":"958*(1+D203)","v":993.44599999999991},75]
[null,"Ø110 mm < Ledningsnet ≤ Ø 250 mm","kr./m.",{"$f":"1684*(1+D203)","v":1746.3079999999998},75]
[null,"Ø 250 mm < Ledningsnet ≤ Ø 500mm","kr./m.",{"$f":"3153*(1+D203)","v":3269.6609999999996},75]
[null,"Ledningsnet > Ø 500 mm","kr./m.",{"$f":"5998*(1+D203)","v":6219.9259999999995},75]
[null,"Råvandsledninger - City"]
[null,"Ø 50mm < Ledningsnet ≤ Ø110 mm","kr./m.",{"$f":"1495*(1+D203)","v":1550.3149999999998},75]
[null,"Ø110 mm < Ledningsnet ≤ Ø 250 mm","kr./m.",{"$f":"2192*(1+D203)","v":2273.1039999999998},75]
[null,"Ø 250 mm < Ledningsnet ≤ Ø 500mm","kr./m.",{"$f":"3773*(1+D203)","v":3912.6009999999997},75]
[null,"Ledningsnet > Ø 500 mm","kr./m.",{"$f":"6732*(1+D203)","v":6981.0839999999998},75]
[null,"Vandværker: Behandling og Udpumpning"]
[null,"Beluftningsanlæg, iltningstrappe, Konstruktioner","kr/m³/h ","Variabel",50]
[null,"Beluftningsanlæg, iltningstrappe, Mek./EL","kr/m³/h ","Variabel",25]
[null,"Beluftningsanlæg, ika-beluftning, Konstruktioner","kr/m³/h ","Variabel",50]
[null,"Beluftningsanlæg, ika-beluftning, Mek./EL","kr/m³/h ","Variabel",25]
[null,"Beluftningsanlæg, bundbeluftbning, Konstruktioner","kr/m³/h ","Variabel",50]
[null,"Beluftningsanlæg, bundbeluftbning, Mek./EL","kr/m³/h ","Variabel",25]
[null,"Beluftningsanlæg, rislebakke, Konstruktioner","kr/m³/h ","Variabel",50]
[null,"Beluftningsanlæg, rislebakke, Mek./EL","kr/m³/h ","Variabel",25]
[null,"Beluftningsanlæg, kompressorbeluftning","kr/m³/h ","Variabel",25]
[null,"Beluftningsanlæg, ren ilt","kr/m³/h ","Variabel",25]
[null,"Behandlingsanlæg, kalk anlæg","kr/m³/h ","Variabel",25]
[null,"Behandlingsanlæg, luddosering","kr/m³/h ","Variabel",25]
[null,"Filteranlæg, åbne filtre, enkelt filtrering, Konstruktioner","kr/m³/h ","Variabel",50]
[null,"Filteranlæg, åbne filtre, enkelt filtrering, Mek./EL","kr/m³/h ","Variabel",25]
[null,"Filteranlæg, åbne filtre, dobbelt filtrering, Konstruktioner","kr/m³/h ","Variabel",50]
[null,"Filteranlæg, åbne filtre, dobbelt filtrering, Mek./EL","kr/m³/h ","Variabel",25]
[null,"Filteranlæg, trykfiltre, enkelt filtrering","kr/m³/h ","Variabel",25]
[null,"Filteranlæg, trykfiltre, dobbelt filtrering","kr/m³/h ","Variabel",25]
[null,"Rentvandsbeholder  insitu støbt","kr/m³","Variabel",50]
[null,"Rentvandsbeholder  element","kr/m³","Variabel",50]
[null,"Udpumpningsanlæg, rentvandspumper på vandværk","kr/m³/h ","Variabel",25]
[null,"Udpumpningsanlæg, Frekvensomformer","kr/kW","Variabel",25]
[null,"Udpumpningsanlæg, Hydrofor","kr/lilter","Variabel",25]
[null,"Skyllevand-/slamhåndteringsanlæg - lukkede betonbeholdere","kr/m³","Variabel",50]
[null,"Skyllevand-/slamhåndteringsanl. - åbne med faste sider/bund","kr/m³","Variabel",50]
[null,"Skyllevand-/slamhåndteringsanlæg - jordbassiner","kr/m³","Variabel",50]
[null,"Skyllevandsbehandling, inkl. UV-filter mv., Mek./EL","kr/m³/h ","Variabel",25]
[null,"Skyllevandsbehandling, inkl. UV-filter mv., SRO","kr/m³/h ","Variabel",10]
[null,"Nødstrømsanlæg på vandværk","kr/kW","Variabel",25]
[null,"Elanlæg og SRO-anlæg - vandværk, Elanlæg","kr./m³/h","Variabel",25]
[null,"Elanlæg og SRO-anlæg - vandværk, SRO","kr./m³/h","Variabel",10]
[null,"Bygninger"]
[null,"Etageareal vandbehandlingsbygning","kr/m²",{"$f":"18108*(1+D203)","v":18777.995999999999},75]
[null,"Etageareal kontor og mandskabsfaciliteter","kr/m²",{"$f":"19309*(1+D203)","v":20023.432999999997},75]
[null,"Værksted","kr/m²",{"$f":"14921*(1+D203)","v":15473.076999999999},75]
[null,"Lager","kr/m²",{"$f":"14921*(1+D203)","v":15473.076999999999},75]
[null,"Garage og rørlager","kr/m²",{"$f":"10444*(1+D203)","v":10830.428},75]
[null,"Bygning for trykforøgere","kr/m²",{"$f":"20318*(1+D203)","v":21069.766},75]
[null,"Laboratorium (bygning, inkl. inventar+udstyr), Konstruktioner","kr/m²",{"$f":"20362*(1+D203)","v":21115.393999999997},75]
[null,"Laboratorium (bygning, inkl. inventar+udstyr), Mek./EL","kr/m²",{"$f":"13575*(1+D203)","v":14077.275},10]
[null,"Andre"]
[null,"Sikring (terror, hærværk), Mek./EL","kr./stk.",{"$f":"6372*(1+D203)","v":6607.7639999999992},25]
[null,"Sikring (terror, hærværk), SRO","kr./stk.",{"$f":"14868*(1+D203)","v":15418.115999999998},10]
[null,"Sikring, mindre avanceret (hegn, porte), Mek./EL","kr./stk.",{"$f":"26067*(1+D203)","v":27031.478999999999},25]
[null,"Sikring, mindre avanceret (hegn, porte), SRO","kr./stk.",{"$f":"60823*(1+D203)","v":63073.450999999994},10]
[null,"Sikring, avanceret (hegn, porte og overvågningssystemer), Mek./EL","kr./stk.",{"$f":"56318*(1+D203)","v":58401.765999999996},25]
[null,"Sikring, avanceret (hegn, porte og overvågningssystemer), SRO","kr./stk.",{"$f":"225271*(1+D203)","v":233606.02699999997},10]
[]
[]
[null,"Distributionsanlæg:"]
[null,"Ledningsnet - Land"]
[null,"Ledningsnet ≤ Ø50 mm","kr./m.",{"$f":"529*(1+D203)","v":548.57299999999998},75]
[null,"Ø 50mm < Ledningsnet ≤ Ø110 mm","kr./m.",{"$f":"808*(1+D203)","v":837.89599999999996},75]
[null,"Ø110 mm < Ledningsnet ≤ Ø 250 mm","kr./m.",{"$f":"1513*(1+D203)","v":1568.981},75]
[null,"Ø 250 mm < Ledningsnet ≤ Ø 500mm","kr./m.",{"$f":"2944*(1+D203)","v":3052.9279999999999},75]
[null,"Ledningsnet > Ø 500 mm","kr./m.",{"$f":"5751*(1+D203)","v":5963.7869999999994},75]
[null,"Støbejernsledninger ≤ Ø50 mm","kr./m.",{"$f":"899*(1+D203)","v":932.26299999999992},100]
[null,"Støbejernsledninger Ø 50mm < Ledningsnet ≤ Ø110 mm","kr./m.",{"$f":"1053*(1+D203)","v":1091.961},100]
[null,"Støbejernsledninger Ø110 mm < Ledningsnet ≤ Ø 250 mm","kr./m.",{"$f":"1490*(1+D203)","v":1545.1299999999999},100]
[null,"Støbejernsledninger Ø 250 mm < Ledningsnet ≤ Ø 500mm","kr./m.",{"$f":"2762*(1+D203)","v":2864.194},100]
[null,"Støbejernsledninger Ledningsnet > Ø 500 mm","kr./m.",{"$f":"5484*(1+D203)","v":5686.9079999999994},100]
[null,"Eternitledninger ≤ Ø50 mm","kr./m.",{"$f":"655*(1+D203)","v":679.2349999999999},75]
[null,"Eternitledninger Ø 50mm < Ledningsnet ≤ Ø110 mm","kr./m.",{"$f":"885*(1+D203)","v":917.74499999999989},75]
[null,"Eternitledninger Ø110 mm < Ledningsnet ≤ Ø 250 mm","kr./m.",{"$f":"1287*(1+D203)","v":1334.6189999999999},75]
[null,"Eternitledninger Ø 250 mm < Ledningsnet ≤ Ø 500mm","kr./m.",{"$f":"3056*(1+D203)","v":3169.0719999999997},75]
[null,"Eternitledninger Ledningsnet > Ø 500 mm","kr./m.",{"$f":"8477*(1+D203)","v":8790.6489999999994},75]
[null,"Skelbrønd, Konstruktioner","kr./stk.",{"$f":"10415*(1+D203)","v":10800.355},50]
[null,"Skelbrønd, Mek./EL","kr./stk.",{"$f":"15623*(1+D203)","v":16201.050999999999},15]
[null,"Inspektionsbrønd, Konstruktioner","kr./stk.",{"$f":"10415*(1+D203)","v":10800.355},50]
[null,"Inspektionsbrønd, Mek./EL","kr./stk.",{"$f":"13019*(1+D203)","v":13500.703},15]
[null,"Stik på ledningsnet, Konstruktioner","kr./stk.",{"$f":"4722*(1+D203)","v":4896.7139999999999},75]
[null,"Stik på ledningsnet, Mek./EL","kr./stk.",{"$f":"4722*(1+D203)","v":4896.7139999999999},75]
[null,"Ledningsnet - By"]
[null,"Ledningsnet ≤ Ø50 mm","kr./m.",{"$f":"650*(1+D203)","v":674.05},75]
[null,"Ø 50mm < Ledningsnet ≤ Ø110 mm","kr./m.",{"$f":"958*(1+D203)","v":993.44599999999991},75]
[null,"Ø110 mm < Ledningsnet ≤ Ø 250 mm","kr./m.",{"$f":"1684*(1+D203)","v":1746.3079999999998},75]
[null,"Ø 250 mm < Ledningsnet ≤ Ø 500mm","kr./m.",{"$f":"3153*(1+D203)","v":3269.6609999999996},75]
[null,"Ledningsnet > Ø 500 mm","kr./m.",{"$f":"5998*(1+D203)","v":6219.9259999999995},75]
[null,"Støbejernsledninger ≤ Ø50 mm","kr./m.",{"$f":"1020*(1+D203)","v":1057.74},100]
[null,"Støbejernsledninger Ø 50mm < Ledningsnet ≤ Ø110 mm","kr./m.",{"$f":"1203*(1+D203)","v":1247.511},100]
[null,"Støbejernsledninger Ø110 mm < Ledningsnet ≤ Ø 250 mm","kr./m.",{"$f":"1661*(1+D203)","v":1722.4569999999999},100]
[null,"Støbejernsledninger Ø 250 mm < Ledningsnet ≤ Ø 500mm","kr./m.",{"$f":"2971*(1+D203)","v":3080.9269999999997},100]
[null,"Støbejernsledninger Ledningsnet > Ø 500 mm","kr./m.",{"$f":"5731*(1+D203)","v":5943.0469999999996},100]
[null,"Eternitledninger ≤ Ø50 mm","kr./m.",{"$f":"776*(1+D203)","v":804.71199999999999},75]
[null,"Eternitledninger Ø 50mm < Ledningsnet ≤ Ø110 mm","kr./m.",{"$f":"1035*(1+D203)","v":1073.2949999999998},75]
[null,"Eternitledninger Ø110 mm < Ledningsnet ≤ Ø 250 mm","kr./m.",{"$f":"1456*(1+D203)","v":1509.8719999999998},75]
[null,"Eternitledninger Ø 250 mm < Ledningsnet ≤ Ø 500mm","kr./m.",{"$f":"3265*(1+D203)","v":3385.8049999999998},75]
[null,"Eternitledninger Ledningsnet > Ø 500 mm","kr./m.",{"$f":"8724*(1+D203)","v":9046.7879999999986},75]
[null,"Skelbrønd, Konstruktioner","kr./stk.",{"$f":"11457*(1+D203)","v":11880.909},50]
[null,"Skelbrønd, Mek./EL","kr./stk.",{"$f":"17185*(1+D203)","v":17820.844999999998},15]
[null,"Inspektionsbrønd, Konstruktioner","kr./stk.",{"$f":"11457*(1+D203)","v":11880.909},50]
[null,"Inspektionsbrønd, Mek./EL","kr./stk.",{"$f":"14321*(1+D203)","v":14850.876999999999},15]
[null,"Stik på ledningsnet, Konstruktioner","kr./stk.",{"$f":"5666*(1+D203)","v":5875.6419999999998},75]
[null,"Stik på ledningsnet, Mek./EL","kr./stk.",{"$f":"5666*(1+D203)","v":5875.6419999999998},75]
[null,"Ledningsnet - City"]
[null,"Ledningsnet ≤ Ø50 mm","kr./m.",{"$f":"1078*(1+D203)","v":1117.886},75]
[null,"Ø 50mm < Ledningsnet ≤ Ø110 mm","kr./m.",{"$f":"1495*(1+D203)","v":1550.3149999999998},75]
[null,"Ø110 mm < Ledningsnet ≤ Ø 250 mm","kr./m.",{"$f":"2192*(1+D203)","v":2273.1039999999998},75]
[null,"Ø 250 mm < Ledningsnet ≤ Ø 500mm","kr./m.",{"$f":"3773*(1+D203)","v":3912.6009999999997},75]
[null,"Ledningsnet > Ø 500 mm","kr./m.",{"$f":"6732*(1+D203)","v":6981.0839999999998},75]
[null,"Støbejernsledninger ≤ Ø50 mm","kr./m.",{"$f":"1448*(1+D203)","v":1501.5759999999998},100]
[null,"Støbejernsledninger Ø 50mm < Ledningsnet ≤ Ø110 mm","kr./m.",{"$f":"1740*(1+D203)","v":1804.3799999999999},100]
[null,"Støbejernsledninger Ø110 mm < Ledningsnet ≤ Ø 250 mm","kr./m.",{"$f":"2169*(1+D203)","v":2249.2529999999997},100]
[null,"Støbejernsledninger Ø 250 mm < Ledningsnet ≤ Ø 500mm","kr./m.",{"$f":"3591*(1+D203)","v":3723.8669999999997},100]
[null,"Støbejernsledninger Ledningsnet > Ø 500 mm","kr./m.",{"$f":"6465*(1+D203)","v":6704.2049999999999},100]
[null,"Eternitledninger ≤ Ø50 mm","kr./m.",{"$f":"1204*(1+D203)","v":1248.548},75]
[null,"Eternitledninger Ø 50mm < Ledningsnet ≤ Ø110 mm","kr./m.",{"$f":"1572*(1+D203)","v":1630.164},75]
[null,"Eternitledninger Ø110 mm < Ledningsnet ≤ Ø 250 mm","kr./m.",{"$f":"1966*(1+D203)","v":2038.7419999999997},75]
[null,"Eternitledninger Ø 250 mm < Ledningsnet ≤ Ø 500mm","kr./m.",{"$f":"3885*(1+D203)","v":4028.7449999999999},75]
[null,"Eternitledninger Ledningsnet > Ø 500 mm","kr./m.",{"$f":"9458*(1+D203)","v":9807.9459999999999},75]
[null,"Skelbrønd, Konstruktioner","kr./stk.",{"$f":"12498*(1+D203)","v":12960.425999999999},50]
[null,"Skelbrønd, Mek./EL","kr./stk.",{"$f":"18747*(1+D203)","v":19440.638999999999},15]
[null,"Inspektionsbrønd, Konstruktioner","kr./stk.",{"$f":"12498*(1+D203)","v":12960.425999999999},50]
[null,"Inspektionsbrønd, Mek./EL","kr./stk.",{"$f":"15623*(1+D203)","v":16201.050999999999},15]
[null,"Stik på ledningsnet, Konstruktioner","kr./stk.",{"$f":"6139*(1+D203)","v":6366.1429999999991},75]
[null,"Stik på ledningsnet, Mek./EL","kr./stk.",{"$f":"6139*(1+D203)","v":6366.1429999999991},75]
[null,"Ledningsnet - Indre city"]
[null,"Ledningsnet ≤ Ø50 mm","kr./m.",{"$f":"1697*(1+D203)","v":1759.7889999999998},75]
[null,"Ø 50mm < Ledningsnet ≤ Ø110 mm","kr./m.",{"$f":"2268*(1+D203)","v":2351.9159999999997},75]
[null,"Ø110 mm < Ledningsnet ≤ Ø 250 mm","kr./m.",{"$f":"3009*(1+D203)","v":3120.3329999999996},75]
[null,"Ø 250 mm < Ledningsnet ≤ Ø 500mm","kr./m.",{"$f":"4773*(1+D203)","v":4949.6009999999997},75]
[null,"Ledningsnet > Ø 500 mm","kr./m.",{"$f":"7915*(1+D203)","v":8207.8549999999996},75]
[null,"Støbejernsledninger ≤ Ø50 mm","kr./m.",{"$f":"2067*(1+D203)","v":2143.4789999999998},100]
[null,"Støbejernsledninger Ø 50mm < Ledningsnet ≤ Ø110 mm","kr./m.",{"$f":"2513*(1+D203)","v":2605.9809999999998},100]
[null,"Støbejernsledninger Ø110 mm < Ledningsnet ≤ Ø 250 mm","kr./m.",{"$f":"2986*(1+D203)","v":3096.482},100]
[null,"Støbejernsledninger Ø 250 mm < Ledningsnet ≤ Ø 500mm","kr./m.",{"$f":"4591*(1+D203)","v":4760.8669999999993},100]
[null,"Støbejernsledninger Ledningsnet > Ø 500 mm","kr./m.",{"$f":"7648*(1+D203)","v":7930.9759999999997},100]
[null,"Eternitledninger ≤ Ø50 mm","kr./m.",{"$f":"1823*(1+D203)","v":1890.4509999999998},75]
[null,"Eternitledninger Ø 50mm < Ledningsnet ≤ Ø110 mm","kr./m.",{"$f":"2345*(1+D203)","v":2431.7649999999999},75]
[null,"Eternitledninger Ø110 mm < Ledningsnet ≤ Ø 250 mm","kr./m.",{"$f":"2783*(1+D203)","v":2885.971},75]
[null,"Eternitledninger Ø 250 mm < Ledningsnet ≤ Ø 500mm","kr./m.",{"$f":"4885*(1+D203)","v":5065.7449999999999},75]
[null,"Eternitledninger Ledningsnet > Ø 500 mm","kr./m.",{"$f":"10641*(1+D203)","v":11034.716999999999},75]
[null,"Skelbrønd, Konstruktioner","kr./stk.",{"$f":"13540*(1+D203)","v":14040.98},50]
[null,"Skelbrønd, Mek./EL","kr./stk.",{"$f":"20310*(1+D203)","v":21061.469999999998},15]
[null,"Inspektionsbrønd, Konstruktioner","kr./stk.",{"$f":"13540*(1+D203)","v":14040.98},50]
[null,"Inspektionsbrønd, Mek./EL","kr./stk.",{"$f":"16925*(1+D203)","v":17551.224999999999},15]
[null,"Stik på ledningsnet, Konstruktioner","kr./stk.",{"$f":"7555*(1+D203)","v":7834.5349999999999},75]
[null,"Stik på ledningsnet, Mek./EL","kr./stk.",{"$f":"7555*(1+D203)","v":7834.5349999999999},75]
[null,"Ventiler"]
[null,"Ventiler på ledningsnet ≤ Ø50 mm","kr./stk.",{"$f":"7732*(1+D203)","v":8018.0839999999998},75]
[null,"Ventiler på Ø 50mm < Ledningsnet ≤ Ø110 mm","kr./stk.",{"$f":"8980*(1+D203)","v":9312.2599999999984},75]
[null,"Ventiler på Ø110 mm < Ledningsnet ≤ Ø 250 mm","kr./stk.",{"$f":"21736*(1+D203)","v":22540.232},75]
[null,"Ventiler på Ø 250 mm < Ledningsnet ≤ Ø 500mm","kr./stk.",{"$f":"78299*(1+D203)","v":81196.062999999995},75]
[null,"Ventiler på ledningsnet > Ø 500 mm","kr./stk.",{"$f":"223733*(1+D203)","v":232011.12099999998},75]
[null,"Pumpestationer, bygværker og bassiner"]
[null,"Pumpestation (inkl. evt. hydrofor)/trykforøger, Konstruktioner","kr/m³/h ","Variabel",50]
[null,"Pumpestation (inkl. evt. hydrofor)/trykforøger, Mek./EL","kr/m³/h ","Variabel",25]
[null,"Pumpestation (inkl. evt. hydrofor)/trykforøger, SRO","kr/m³/h ","Variabel",10]
[null,"Beholderanlæg - højdebeholder","kr/m³/h ","Variabel",50]
[null,"Beholderanlæg - vandtårn","kr/m³/h ","Variabel",50]
[null,"Andre: "]
[null,"Afregningsmålere, mekaniske, ","kr./stk.",{"$f":"1300*(1+D203)","v":1348.1},8]
[null,"Afregningsmålere, elektroniske med maksimal gennemstrømning ≤ 4 m3/t","kr./stk.",{"$f":"1450*(1+D203)","v":1503.6499999999999},10]
[null,"Afregningsmålere, elektroniske med maksimal gennemstrømning > 4 m3/t ≤ 15 m3/t","kr./stk.",{"$f":"2076*(1+D203)","v":2152.8119999999999},10]
[null,"Afregningsmålere, elektroniske med maksimal gennemstrømning > 15 m3/t ≤ 300 m3/t ","kr./stk.",{"$f":"20000*(1+D203)","v":20740},10]
[null,"Afregningsmålere, elektroniske med maksimal gennemstrømning > 300 m3/t","kr./stk.",{"$f":"26000*(1+D203)","v":26961.999999999996},10]
[null,"SRO-brønd/kvarterbrønd/sektionsbrønd, Konstruktioner","kr./stk.",{"$f":"78845*(1+D203)","v":81762.264999999999},50]
[null,"SRO-brønd/kvarterbrønd/sektionsbrønd, Mek./EL","kr./stk.",{"$f":"90108*(1+D203)","v":93441.995999999999},15]
[null,"SRO-brønd/kvarterbrønd/sektionsbrønd, SRO","kr./stk.",{"$f":"56318*(1+D203)","v":58401.765999999996},10]
[]
[]
[null,"Fællesfunktionsanlæg: "]
[null,"Andre"]
[null,"Arbejdsplads og kontor","kr./stk.",{"$f":"35000*(1+D203)","v":36295},5]
[null,"Køretøjer, personbil","kr./stk.",225000,5]
[null,"Køretøjer, små lastvogne (< 3.500 kg.)","kr./stk.",250000,5]
[null,"Køretøjer, store lastvogne (> 3.500 kg.)","kr./stk.",1300000,5]
[null,"Køretøjer, entreprenørmaskiner","kr./stk.",400000,5]
[null,"Øvrige"]
[null,"Solcelleanlæg ekskl. Inverter","kWp",5400,25]
[null,"Inverter til solcelleanlæg","kWp",600,10]
[]
[]
[null,"Regionstillæg",null,3.6999999999999998E-2]

{"sheet":"Variable priser","index":4,"n_rows":110,"n_cols":12,"rows_kept":110,"cut":false,"hidden":false,"merged":[[0,0,0,12]]}
["Til bestemmelse af diverse variable priser"]
["Udpumpningsanlæg",null,0,10,20,30,45,300,"m³/time"]
[null,null,0,44147.303999999996,62958.911999999997,77148.072,90254.76,292560,"kr"]
[null,null,4414.7303999999995,1881.1608000000001,1418.9160000000004,873.77919999999961,793.35388235294113,793.35388235294113,"kr/m³"]
[]
["Beluftningsanlæg",null,0,10,50,100,200,500,null,null,"Anlæg","Mekn/El"]
["Iltningstrappe",null,0,58570.511999999995,266229.59999999998,439278.84,718819.92,1331148,"kr",null,0.8,0.2]
[null,null,5857.0511999999999,5191.4771999999994,3460.9847999999988,2795.4108000000015,2041.0935999999999,2041.0935999999999,"kr/m³/t"]
["Ikabelufter",null,0,87855.767999999982,399344.4,658918.26,1078229.8799999999,1996722,"kr",null,0.5,0.5]
[null,null,8785.5767999999989,7787.2158000000009,5191.4771999999975,4193.1162000000004,3061.6404000000002,3061.6404000000002,"kr/m³/t"]
["Bundbeluftning",null,0,52713.460799999993,239606.64,395350.95599999995,646937.92800000007,1198033.2,"kr"]
[null,null,5271.3460799999993,4672.3294799999985,3114.8863199999996,2515.8697200000011,1836.9842399999995,1836.9842399999995,"kr/m³/t"]
["Kompressorbeluftning",null,0,11714.1024,53245.919999999998,87855.767999999982,143763.984,266229.59999999998,"kr"]
[null,null,1171.4102399999999,1038.2954399999999,692.19695999999965,559.08216000000016,408.21871999999991,408.21871999999991,"kr/m³/t"]
["Rent ilt",null,0,11714.1024,53245.919999999998,87855.767999999982,143763.984,266229.59999999998,"kr"]
[null,null,1171.4102399999999,1038.2954399999999,692.19695999999965,559.08216000000016,408.21871999999991,408.21871999999991,"kr/m³/t"]
["Rislebakke",null,0,35142.307199999996,159737.76,263567.30399999995,431291.95200000005,798688.8,"kr",null,0.7,0.3]
[null,null,3514.2307199999996,3114.8863199999996,2076.5908799999993,1677.2464800000009,1224.65616,1224.65616,"kr/m³/t"]
[]
["pH Justering",null,0,50,100,200,500,"m³/time"]
["Kalkdoseringsanlæg",null,0,78552.36,133539.01199999999,213662.4192,427324.83840000001,"kr"]
[null,null,0,235657.08,400617.03599999996,640987.25760000001,1281974.5152,"kr"]
["Luddoseringsanlæg",null,4713.1415999999999,3299.1991199999993,2403.7022160000006,2136.6241920000002,2136.6241920000002,"kr/m³/time"]
[null,null,0,39276.18,66769.505999999994,106831.2096,213662.4192,"kr"]
[null,null,785.52359999999999,549.86651999999992,400.6170360000001,356.10403200000002,356.10403200000002,"kr/m³/time"]
[]
["Behandlingsanlæg"]
["Åbne filtre",null,0,50,100,200,500,"m³/time"]
["07-41,01 inkl. tillæg",null,null,544161.6]
["Skønnet inkl. tillæg",null,null,292560,null,null,null,"kr/m³/t",null,null,"Anlæg","Mekn/El"]
["Returskylning inkl. tillæg",null,null,null,null,null,null,null,null,null,0.4,0.6]
["07-61.01",null,null,714577.8]
[null,null,0,1551299.4,2637208.98,4219534.3679999998,8439068.7359999996,"kr"]
["Dobbelt filtrering",null,31025.987999999998,21718.191600000002,15823.253879999998,14065.11456,14065.11456,"kr/m³/time"]
[]
[null,null,0,1085909.58,1846046.2859999998,2953674.0575999999,5907348.1151999999,"kr "]
["Enkelt filtrering",null,21718.191600000002,15202.734119999996,11076.277716000001,9845.5801919999994,9845.5801919999994,"kr/m³/time"]
[]
["Behandlingsanlæg"]
["Lukkede filtre",null,0,30,100,200,500,"m³/t"]
["Enkelt filtrering inkl..rør mv.",null,0,516368.4,1290921,2323657.7999999998,4647315.5999999996,"kr "]
[null,null,17212.28,11065.037142857143,10327.368000000002,7745.5260000000007,7745.5260000000007,"kr/m³/time"]
[]
[null,null,0,30,100,200,500,"m³/t"]
["Dobbeltfiltrering ekskl. rør ",null,0,722915.76,1807289.4,3253120.92,6506241.8400000008,"kr"]
[null,null,24097.191999999999,15491.051999999998,14458.315200000005,10843.736400000002,10843.736400000002,"kr/m³/time"]
[]
["Rentvandsbeholdere",null,0,100,500,1000,3000,"m³"]
["In-situ støbt rentvandsbeholder ",null,0,520756.8,2343405.6,4218130.08,7500000,"kr"]
[null,null,5207.5679999999993,4556.6219999999994,3749.4489599999988,1640.9349600000005,1640.9349600000005,"kr/m³"]
[]
[null,null,0,120,500,1000,3000,"m³"]
["Element beholder ",null,0,509054.4,1883501.28,3390302.304,6600000,"kr"]
[null,null,4242.12,3616.9654736842108,3013.6020479999997,1604.8488480000001,1604.8488480000001,"kr/m³"]
["Vandtårne",null,0,100,500,1000,3000,"m³/time"]
["Skønnet inkl. tillæg",null,0,781135.2,3515108.4,6327195.1199999992,11250000,"kr"]
[null,null,7811.351999999998,6834.9329999999991,5624.1734399999996,2461.4024400000003,2461.4024400000003,"kr/m³"]
[]
["Skyllevandsbeholdere",null,0,100,200,500,1000,"m³"]
["Lukket skyllevandsbeholder 30 - 80 m³",null,0,520756.8,833210.88,1833063.936,3299515.0847999998,"kr "]
[null,null,5207.5679999999993,3124.5407999999998,3332.8435200000004,2932.9022975999997,2932.9022975999997,"kr/m³"]
[]
["Åbne beholder med faste side / bund",null,0,251601.6,402562.56,885637.6320000001,1594147.7376000001,"kr "]
[null,null,2516.0159999999996,1509.6096000000002,1610.2502400000003,1417.0202111999999,1417.0202111999999,"kr/m³"]
[]
["Jordbassin",null,0,37740.239999999998,60384.384000000005,132845.64480000001,239122.16064000002,"kr "]
[null,null,377.4024,226.44144000000009,241.53753600000002,212.55303168,212.55303168,"kr/m³"]
[]
["Udpumpningsanlæg"]
[]
["Udpumpningsanlæg",null,0,10,20,30,100,1000,"m³/time"]
[null,null,0,39349.32,51051.72,59974.8,149937,899622,"kr"]
[null,null,3934.9319999999998,1170.24,892.30800000000022,1285.1742857142858,832.98333333333335,832.98333333333335,"kr/m³"]
[]
["Frekvensomformere inkl. elinstallationer"]
[null,null,0,2.2000000000000002,4,5.5,"m³/time"]
[null,null,0,68605.320000000007,74456.52,77089.56,"kr"]
[null,null,31184.236363636359,3250.6666666666652,1755.3600000000054,1755.3600000000054,"kr/m³"]
[]
["Hydrofor"]
[null,null,0,2500,5000,"m³/time"]
["Hydrofor inkl. styring",null,0,200842.44,270032.88,"kr"]
[null,null,80.336975999999993,27.676176000000012,27.676176000000012,"kr/m³"]
[]
["Nødstrømsaggregat"]
[null,null,0,11.5,16,22,50,"kW"]
[null,null,0,134577.60000000001,155495.64000000001,174073.2,295924.44,"kr"]
[null,null,11702.4,4648.4533333333347,3096.26,4351.83,4351.83,"kr/m³"]
[]
["El + SRO Vandværk"]
[null,null,0,50,200,1000,"m³/time"]
["Eltavle + install inkl. tillæg",null,0,380328,665574,1663935,"Kr"]
[]
["Sum",null,null,380328,665574,1663935,"Kr"]
[null,null,7606.56,1901.64,1247.9512499999998,1247.9512499999998,"kr/m³"]
[]
["SRO inkl. tillæg",null,0,292560,351072,596822.4,"Kr"]
[null,null,5851.2,390.08,307.18800000000005,307.18800000000005,"kr/m³"]
[]
["Pumpestation / Trykforøgerstation"]
[null,null,null,null,null,null,null,null,"Anlæg","Mekn/El",null,"SRO"]
["Maskinanlæg pumpestation / trykforøger",null,null,null,null,null,null,null,0.25,0.65,null,0.1]
[null,null,0,30,50,250,"m³/time"]
[null,null,0,230391,296217,877680,"Kr","Inkl. El og styring"]
[null,null,7679.7,3291.3,2907.3149999999996,2907.3149999999996,"Kr/m³/time"]
[]
["Skyllevandsbehandling"]
[null,null,0,20,40,"m³/t",null,"Mekn/El","SRO"]
[null,null,0,515637,773455.5,"kr",null,0.85,0.15]
[null,null,25781.85,12890.924999999997,12890.924999999997,"kr/m³/time"]