{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Helhedsplan"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Helhedsplan","index":0,"n_rows":272,"n_cols":62,"rows_kept":272,"cut":false,"hidden":false,"merged":[[243,3,243,4],[233,3,233,4],[234,3,234,4],[235,3,235,4],[236,3,236,4],[237,3,237,4],[238,3,238,4],[239,3,239,4],[240,3,240,4],[241,3,241,4],[242,3,242,4],[257,3,257,4],[258,3,258,4],[259,3,259,4],[260,3,260,4],[261,3,261,4],[267,3,267,4],[262,3,262,4],[263,3,263,4],[264,3,264,4],[265,3,265,4],[266,3,266,4]]}
[null,null,null,null,null,null,null,null,null,null,"Boligorganisationen X-bo",null,null,null,null,null,null,null,null,null,null,null,null,"[ Eksempel på budgetoverslag ]"]
[null,"Jnr: ","1053XX",null,null,null,null,null,null,"001 - afd. 1, X-bogård  -  Helhedsplan - Til drøftelse med LBF",null,null,null,null,null,"180 etageboliger"]
[null,"Dato: 25.10.2021/SKJ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Støttede arbejder",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ustøttede arbejder"]
[null,"Kalkulationsindeks: 109,3 (2. kvartal / 2021) - Alle priser inkl. moms.",null,null,null,null,null,null,"Helhedsplan etape 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opdeling af nødvendige ustøttede arbejder ",null,null,null,null,null,null,null,null,{"$f":"SUM(AK7:AK462)","v":6131587.5},1965580,469670,1098000,0,2100000,1417500,0,9730010,10291250,550000,{"$f":"SUM(AK4:AU4)","v":33753597.5},null,null,{"$f":"SUM(AY7:AY462)","v":4650912.5},3366920,4629330,9000000,0,3400000,9022500,0,12814455,22293750,1660000,{"$f":"SUM(AY4:BI4)","v":70837867.5}]
["BSF",null,"GRÅ FELTER UDFYLDES","Enh.","Antal","Enh. pris","Total",null,"Opretning",null,"Fællesarealer",null,"Ombygning /",null,"Tilgængelighed",null,"Modernisering",null,"Vedligeholdelse",null,"Nødvendlige ustøttede arbejder",null,null,null,null,null,null,"Opretning",null,"Fællesarealer",null,"Ombygning /",null,"Tilgængelighed",null,null,"BSF-håndværkerudgifter",null,null,null,null,null,null,null,null,null,null,null,null,null,"BSF-håndværkerudgifter"]
[null,null,null,null,null,"inkl. moms","inkl. moms",null," ",null," ",null,"Sammenlægn.",null," ",null," ",null," ",null," ","(automatisk)",null,null,null,null,null," ",{"$f":"SUM(AC7:AC176)","v":6269750}," ",{"$f":"SUM(AE7:AE176)","v":0},"Sammenlægn.",{"$f":"SUM(AG7:AG176)","v":522720}," ",{"$f":"SUM(AI7:AI176)","v":1961520},null,1,2,3,4,5,6,7,8,9,10,11,null,null,null,1,2,3,4,5,6,7,8,9,10,11]
[null,null,null,null,null,""]
[null,1,"Tag",null,null,null,{"$f":"I8+K8+M8+O8+Q8+S8+U8","v":0},{"$f":"E8*F8","v":0},null,{"$f":"IF(I8=0,0,SUM($H8*I8))","v":0},null,{"$f":"IF(K8=0,0,SUM($H8*K8))","v":0},null,{"$f":"IF(M8=0,0,SUM($H8*M8))","v":0},null,{"$f":"IF(O8=0,0,SUM($H8*O8))","v":0},null,{"$f":"IF(Q8=0,0,SUM($H8*Q8))","v":0},null,{"$f":"IF(S8=0,0,SUM($H8*S8))","v":0},null,{"$f":"IF(S8+Q8>0.5,0,IF(Q8<0.51,IF(S8<0.51,+R8+T8,+R8),IF(S8<0.51,T8,0)))","v":0},null,null,null,null,null,{"$f":"IF(J8>0,IF($V8>0,$V8,0),0)","v":0},{"$f":"IF(($AB8+$AD8+$AF8+$AH8)>($V8+1),AB8/2,AB8)","v":0},{"$f":"IF(L8>0,IF($V8>0,$V8,0),0)","v":0},{"$f":"IF(($AB8+$AD8+$AF8+$AH8)>($V8+1),AD8/2,AD8)","v":0},{"$f":"IF(N8>0,IF($V8>0,$V8,0),0)","v":0},{"$f":"IF(($AB8+$AD8+$AF8+$AH8)>($V8+1),AF8/2,AF8)","v":0},{"$f":"IF(P8>0,IF($V8>0,$V8,0),0)","v":0},{"$f":"IF(($AB8+$AD8+$AF8+$AH8)>($V8+1),AH8/2,AH8)","v":0}]
[1,null,"Ny tagbelægning","m2",10500,650,{"$f":"I9+K9+M9+O9+Q9+S9+U9","v":1},{"$f":"E9*F9","v":6825000},0.5,{"$f":"IF(I9=0,0,SUM($H9*I9))","v":3412500},null,{"$f":"IF(K9=0,0,SUM($H9*K9))","v":0},null,{"$f":"IF(M9=0,0,SUM($H9*M9))","v":0},null,{"$f":"IF(O9=0,0,SUM($H9*O9))","v":0},null,{"$f":"IF(Q9=0,0,SUM($H9*Q9))","v":0},0.5,{"$f":"IF(S9=0,0,SUM($H9*S9))","v":3412500},null,{"$f":"IF(S9+Q9>0.5,0,IF(Q9<0.51,IF(S9<0.51,+R9+T9,+R9),IF(S9<0.51,T9,0)))","v":3412500},null,null,null,null,null,{"$f":"IF(J9>0,IF($V9>0,$V9,0),0)","v":3412500},{"$f":"IF(($AB9+$AD9+$AF9+$AH9)>($V9+1),AB9/2,AB9)","v":3412500},{"$f":"IF(L9>0,IF($V9>0,$V9,0),0)","v":0},{"$f":"IF(($AB9+$AD9+$AF9+$AH9)>($V9+1),AD9/2,AD9)","v":0},{"$f":"IF(N9>0,IF($V9>0,$V9,0),0)","v":0},{"$f":"IF(($AB9+$AD9+$AF9+$AH9)>($V9+1),AF9/2,AF9)","v":0},{"$f":"IF(P9>0,IF($V9>0,$V9,0),0)","v":0},{"$f":"IF(($AB9+$AD9+$AF9+$AH9)>($V9+1),AH9/2,AH9)","v":0},null,{"$f":"IF($A9=AK$6,+$J9+$L9+$N9+$P9,\"\")","v":3412500},{"$f":"IF($A9=AL$6,+$J9+$L9+$N9+$P9,\"\")","v":""},{"$f":"IF($A9=AM$6,+$J9+$L9+$N9+$P9,\"\")","v":""},"","","","","","","","",null,null,null,{"$f":"IF($A9=AY$6,+$R9+$T9,\"\")","v":3412500},{"$f":"IF($A9=AZ$6,+$R9+$T9,\"\")","v":""},{"$f":"IF($A9=BA$6,+$R9+$T9,\"\")","v":""},"","","","","","","",""]
[1,null,"Renovering af tagkonstruktion","m2",10500,215,1,{"$f":"E10*F10","v":2257500},1,2257500,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,{"$f":"IF($A10=AK$6,+$J10+$L10+$N10+$P10,\"\")","v":2257500},{"$f":"IF($A10=AL$6,+$J10+$L10+$N10+$P10,\"\")","v":""},"","","","","","","","","",null,null,null,{"$f":"IF($A10=AY$6,+$R10+$T10,\"\")","v":0},"","","","","","","","","",""]
[1,null,"Tagrender og nedløb","m2",3730,375,1,1398750,0.33,461587.5,null,0,null,0,null,0,null,0,0.67,937162.5,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,461587.5,"","","","","","","","","","",null,null,null,937162.5,"","","","","","","","","",""]
[1,null,"Brandkamsforbedring","stk.",8,15000,1,120000,null,0,null,0,null,0,null,0,0.75,90000,0.25,30000,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,0,"","","","","","","","","","",null,null,null,120000,"","","","","","","","","",""]
[null,null,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,null,null,null,null,{"$f":"IFERROR(I14+K14+M14+O14+Q14+S14+U14,0)","v":1},{"$f":"SUM(H8:H13)","v":10601250},{"$f":"J14/$H14","v":0.5783834453484259},{"$f":"SUM(J8:J13)","v":6131587.5},{"$f":"L14/$H14","v":0},{"$f":"SUM(L8:L13)","v":0},{"$f":"N14/$H14","v":0},{"$f":"SUM(N8:N13)","v":0},{"$f":"P14/$H14","v":0},{"$f":"SUM(P8:P13)","v":0},{"$f":"R14/$H14","v":8.4895649097983736E-3},{"$f":"SUM(R8:R13)","v":90000},{"$f":"T14/$H14","v":0.41312698974177575},{"$f":"SUM(T8:T13)","v":4379662.5},null,{"$f":"SUM(V8:V13)","v":3412500}]
[null,null,null,null,null,""]
[null,2,"Facade",null,null,null,{"$f":"I16+K16+M16+O16+Q16+S16+U16","v":0},{"$f":"E16*F16","v":0},null,{"$f":"IF(I16=0,0,SUM($H16*I16))","v":0},null,{"$f":"IF(K16=0,0,SUM($H16*K16))","v":0},null,{"$f":"IF(M16=0,0,SUM($H16*M16))","v":0},null,{"$f":"IF(O16=0,0,SUM($H16*O16))","v":0},null,{"$f":"IF(Q16=0,0,SUM($H16*Q16))","v":0},null,{"$f":"IF(S16=0,0,SUM($H16*S16))","v":0},null,{"$f":"IF(S16+Q16>0.5,0,IF(Q16<0.51,IF(S16<0.51,+R16+T16,+R16),IF(S16<0.51,T16,0)))","v":0},null,null,null,null,null,{"$f":"IF(J16>0,IF($V16>0,$V16,0),0)","v":0},{"$f":"IF(($AB16+$AD16+$AF16+$AH16)>($V16+1),AB16/2,AB16)","v":0},{"$f":"IF(L16>0,IF($V16>0,$V16,0),0)","v":0},{"$f":"IF(($AB16+$AD16+$AF16+$AH16)>($V16+1),AD16/2,AD16)","v":0},{"$f":"IF(N16>0,IF($V16>0,$V16,0),0)","v":0},{"$f":"IF(($AB16+$AD16+$AF16+$AH16)>($V16+1),AF16/2,AF16)","v":0},{"$f":"IF(P16>0,IF($V16>0,$V16,0),0)","v":0},{"$f":"IF(($AB16+$AD16+$AF16+$AH16)>($V16+1),AH16/2,AH16)","v":0},null,{"$f":"IF($A16=AK$6,+$J16+$L16+$N16+$P16,\"\")","v":""},{"$f":"IF($A16=AL$6,+$J16+$L16+$N16+$P16,\"\")","v":""},"","","","","","","","","",null,null,null,{"$f":"IF($A16=AY$6,+$R16+$T16,\"\")","v":""},"","","","","","","","","",""]
[2,null,"Efterfugning af facader","m2",2000,1000,{"$f":"I17+K17+M17+O17+Q17+S17+U17","v":1},{"$f":"E17*F17","v":2000000},null,{"$f":"IF(I17=0,0,SUM($H17*I17))","v":0},null,{"$f":"IF(K17=0,0,SUM($H17*K17))","v":0},null,{"$f":"IF(M17=0,0,SUM($H17*M17))","v":0},null,{"$f":"IF(O17=0,0,SUM($H17*O17))","v":0},1,{"$f":"IF(Q17=0,0,SUM($H17*Q17))","v":2000000},null,{"$f":"IF(S17=0,0,SUM($H17*S17))","v":0},null,{"$f":"IF(S17+Q17>0.5,0,IF(Q17<0.51,IF(S17<0.51,+R17+T17,+R17),IF(S17<0.51,T17,0)))","v":0},null,null,null,null,null,{"$f":"IF(J17>0,IF($V17>0,$V17,0),0)","v":0},{"$f":"IF(($AB17+$AD17+$AF17+$AH17)>($V17+1),AB17/2,AB17)","v":0},{"$f":"IF(L17>0,IF($V17>0,$V17,0),0)","v":0},{"$f":"IF(($AB17+$AD17+$AF17+$AH17)>($V17+1),AD17/2,AD17)","v":0},{"$f":"IF(N17>0,IF($V17>0,$V17,0),0)","v":0},{"$f":"IF(($AB17+$AD17+$AF17+$AH17)>($V17+1),AF17/2,AF17)","v":0},{"$f":"IF(P17>0,IF($V17>0,$V17,0),0)","v":0},{"$f":"IF(($AB17+$AD17+$AF17+$AH17)>($V17+1),AH17/2,AH17)","v":0},null,"",0,"","","","","","","","","",null,null,null,"",2000000,"","","","","","","","",""]
[2,null,"Fjernelse af indvendig gavlefterisolering","m2",192,1500,{"$f":"I18+K18+M18+O18+Q18+S18+U18","v":1},288000,1,288000,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"",288000,"","","","","","","","","",null,null,null,"",0,"","","","","","","","",""]
[2,null,"Nye gavle ( skalmur + isolering mv.)","m2",230,4100,1,{"$f":"E19*F19","v":943000},1,{"$f":"IF(I19=0,0,SUM($H19*I19))","v":943000},null,{"$f":"IF(K19=0,0,SUM($H19*K19))","v":0},null,{"$f":"IF(M19=0,0,SUM($H19*M19))","v":0},null,{"$f":"IF(O19=0,0,SUM($H19*O19))","v":0},null,{"$f":"IF(Q19=0,0,SUM($H19*Q19))","v":0},null,{"$f":"IF(S19=0,0,SUM($H19*S19))","v":0},null,{"$f":"IF(S19+Q19>0.5,0,IF(Q19<0.51,IF(S19<0.51,+R19+T19,+R19),IF(S19<0.51,T19,0)))","v":0},null,null,null,null,null,{"$f":"IF(J19>0,IF($V19>0,$V19,0),0)","v":0},{"$f":"IF(($AB19+$AD19+$AF19+$AH19)>($V19+1),AB19/2,AB19)","v":0},{"$f":"IF(L19>0,IF($V19>0,$V19,0),0)","v":0},{"$f":"IF(($AB19+$AD19+$AF19+$AH19)>($V19+1),AD19/2,AD19)","v":0},{"$f":"IF(N19>0,IF($V19>0,$V19,0),0)","v":0},{"$f":"IF(($AB19+$AD19+$AF19+$AH19)>($V19+1),AF19/2,AF19)","v":0},{"$f":"IF(P19>0,IF($V19>0,$V19,0),0)","v":0},{"$f":"IF(($AB19+$AD19+$AF19+$AH19)>($V19+1),AH19/2,AH19)","v":0},null,"",943000,"","","","","","","","","",null,null,null,"",0,"","","","","","","","",""]
[2,null,"Sålbænke og muroverliggere","stk.",115,4500,{"$f":"I20+K20+M20+O20+Q20+S20+U20","v":1},517500,1,517500,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"",517500,"","","","","","","","","",null,null,null,"",0,"","","","","","","","",""]
[null,null,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,null,null,null,null,{"$f":"IFERROR(I22+K22+M22+O22+Q22+S22+U22,0)","v":1},{"$f":"SUM(H16:H21)","v":3748500},{"$f":"J22/$H22","v":0.46645324796585302},{"$f":"SUM(J16:J21)","v":1748500},{"$f":"L22/$H22","v":0},{"$f":"SUM(L16:L21)","v":0},{"$f":"N22/$H22","v":0},{"$f":"SUM(N16:N21)","v":0},{"$f":"P22/$H22","v":0},{"$f":"SUM(P16:P21)","v":0},{"$f":"R22/$H22","v":0.53354675203414703},{"$f":"SUM(R16:R21)","v":2000000},{"$f":"T22/$H22","v":0},{"$f":"SUM(T16:T21)","v":0},null,{"$f":"SUM(V16:V21)","v":0}]
[null,null,null,null,null,""]
[null,3,"Kælder",null,null,null,{"$f":"I24+K24+M24+O24+Q24+S24+U24","v":0},{"$f":"E24*F24","v":0},null,{"$f":"IF(I24=0,0,SUM($H24*I24))","v":0},null,{"$f":"IF(K24=0,0,SUM($H24*K24))","v":0},null,{"$f":"IF(M24=0,0,SUM($H24*M24))","v":0},null,{"$f":"IF(O24=0,0,SUM($H24*O24))","v":0},null,{"$f":"IF(Q24=0,0,SUM($H24*Q24))","v":0},null,{"$f":"IF(S24=0,0,SUM($H24*S24))","v":0},null,{"$f":"IF(S24+Q24>0.5,0,IF(Q24<0.51,IF(S24<0.51,+R24+T24,+R24),IF(S24<0.51,T24,0)))","v":0},null,null,null,null,null,{"$f":"IF(J24>0,IF($V24>0,$V24,0),0)","v":0},{"$f":"IF(($AB24+$AD24+$AF24+$AH24)>($V24+1),AB24/2,AB24)","v":0},{"$f":"IF(L24>0,IF($V24>0,$V24,0),0)","v":0},{"$f":"IF(($AB24+$AD24+$AF24+$AH24)>($V24+1),AD24/2,AD24)","v":0},{"$f":"IF(N24>0,IF($V24>0,$V24,0),0)","v":0},{"$f":"IF(($AB24+$AD24+$AF24+$AH24)>($V24+1),AF24/2,AF24)","v":0},{"$f":"IF(P24>0,IF($V24>0,$V24,0),0)","v":0},{"$f":"IF(($AB24+$AD24+$AF24+$AH24)>($V24+1),AH24/2,AH24)","v":0},null,{"$f":"IF($A24=AK$6,+$J24+$L24+$N24+$P24,\"\")","v":""},{"$f":"IF($A24=AL$6,+$J24+$L24+$N24+$P24,\"\")","v":""},"","","","","","","","","",null,null,null,{"$f":"IF($A24=AY$6,+$R24+$T24,\"\")","v":""},"","","","","","","","","",""]
[6,null,"Renovering af kælderindervæg",null,1,3000000,{"$f":"I25+K25+M25+O25+Q25+S25+U25","v":1},{"$f":"E25*F25","v":3000000},null,{"$f":"IF(I25=0,0,SUM($H25*I25))","v":0},null,{"$f":"IF(K25=0,0,SUM($H25*K25))","v":0},null,{"$f":"IF(M25=0,0,SUM($H25*M25))","v":0},null,{"$f":"IF(O25=0,0,SUM($H25*O25))","v":0},null,{"$f":"IF(Q25=0,0,SUM($H25*Q25))","v":0},1,{"$f":"IF(S25=0,0,SUM($H25*S25))","v":3000000},null,{"$f":"IF(S25+Q25>0.5,0,IF(Q25<0.51,IF(S25<0.51,+R25+T25,+R25),IF(S25<0.51,T25,0)))","v":0},null,null,null,null,null,{"$f":"IF(J25>0,IF($V25>0,$V25,0),0)","v":0},{"$f":"IF(($AB25+$AD25+$AF25+$AH25)>($V25+1),AB25/2,AB25)","v":0},{"$f":"IF(L25>0,IF($V25>0,$V25,0),0)","v":0},{"$f":"IF(($AB25+$AD25+$AF25+$AH25)>($V25+1),AD25/2,AD25)","v":0},{"$f":"IF(N25>0,IF($V25>0,$V25,0),0)","v":0},{"$f":"IF(($AB25+$AD25+$AF25+$AH25)>($V25+1),AF25/2,AF25)","v":0},{"$f":"IF(P25>0,IF($V25>0,$V25,0),0)","v":0},{"$f":"IF(($AB25+$AD25+$AF25+$AH25)>($V25+1),AH25/2,AH25)","v":0},null,{"$f":"IF($A25=AK$6,+$J25+$L25+$N25+$P25,\"\")","v":""},"","","","",0,"","","","","",null,null,null,"","","","","",3000000,"","","","",""]
[6,null,"Kældertapper (udvendig)",null,5,80000,{"$f":"I26+K26+M26+O26+Q26+S26+U26","v":1},{"$f":"E26*F26","v":400000},null,{"$f":"IF(I26=0,0,SUM($H26*I26))","v":0},null,{"$f":"IF(K26=0,0,SUM($H26*K26))","v":0},null,{"$f":"IF(M26=0,0,SUM($H26*M26))","v":0},null,{"$f":"IF(O26=0,0,SUM($H26*O26))","v":0},0.5,{"$f":"IF(Q26=0,0,SUM($H26*Q26))","v":200000},0.5,{"$f":"IF(S26=0,0,SUM($H26*S26))","v":200000},null,{"$f":"IF(S26+Q26>0.5,0,IF(Q26<0.51,IF(S26<0.51,+R26+T26,+R26),IF(S26<0.51,T26,0)))","v":0},null,null,null,null,null,{"$f":"IF(J26>0,IF($V26>0,$V26,0),0)","v":0},{"$f":"IF(($AB26+$AD26+$AF26+$AH26)>($V26+1),AB26/2,AB26)","v":0},{"$f":"IF(L26>0,IF($V26>0,$V26,0),0)","v":0},{"$f":"IF(($AB26+$AD26+$AF26+$AH26)>($V26+1),AD26/2,AD26)","v":0},{"$f":"IF(N26>0,IF($V26>0,$V26,0),0)","v":0},{"$f":"IF(($AB26+$AD26+$AF26+$AH26)>($V26+1),AF26/2,AF26)","v":0},{"$f":"IF(P26>0,IF($V26>0,$V26,0),0)","v":0},{"$f":"IF(($AB26+$AD26+$AF26+$AH26)>($V26+1),AH26/2,AH26)","v":0},null,{"$f":"IF($A26=AK$6,+$J26+$L26+$N26+$P26,\"\")","v":""},"","","","",0,"","","","","",null,null,null,"","","","","",400000,"","","","",""]
[null,null,null,null,null,null,{"$f":"I27+K27+M27+O27+Q27+S27+U27","v":0},{"$f":"E27*F27","v":0},null,{"$f":"IF(I27=0,0,SUM($H27*I27))","v":0},null,{"$f":"IF(K27=0,0,SUM($H27*K27))","v":0},null,{"$f":"IF(M27=0,0,SUM($H27*M27))","v":0},null,{"$f":"IF(O27=0,0,SUM($H27*O27))","v":0},null,{"$f":"IF(Q27=0,0,SUM($H27*Q27))","v":0},null,{"$f":"IF(S27=0,0,SUM($H27*S27))","v":0},null,{"$f":"IF(S27+Q27>0.5,0,IF(Q27<0.51,IF(S27<0.51,+R27+T27,+R27),IF(S27<0.51,T27,0)))","v":0},null,null,null,null,null,{"$f":"IF(J27>0,IF($V27>0,$V27,0),0)","v":0},{"$f":"IF(($AB27+$AD27+$AF27+$AH27)>($V27+1),AB27/2,AB27)","v":0},{"$f":"IF(L27>0,IF($V27>0,$V27,0),0)","v":0},{"$f":"IF(($AB27+$AD27+$AF27+$AH27)>($V27+1),AD27/2,AD27)","v":0},{"$f":"IF(N27>0,IF($V27>0,$V27,0),0)","v":0},{"$f":"IF(($AB27+$AD27+$AF27+$AH27)>($V27+1),AF27/2,AF27)","v":0},{"$f":"IF(P27>0,IF($V27>0,$V27,0),0)","v":0},{"$f":"IF(($AB27+$AD27+$AF27+$AH27)>($V27+1),AH27/2,AH27)","v":0},null,{"$f":"IF($A27=AK$6,+$J27+$L27+$N27+$P27,\"\")","v":""},"","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,null,null,null,null,{"$f":"IFERROR(I28+K28+M28+O28+Q28+S28+U28,0)","v":1},{"$f":"SUM(H24:H27)","v":3400000},{"$f":"J28/$H28","v":0},{"$f":"SUM(J24:J27)","v":0},{"$f":"L28/$H28","v":0},{"$f":"SUM(L24:L27)","v":0},{"$f":"N28/$H28","v":0},{"$f":"SUM(N24:N27)","v":0},{"$f":"P28/$H28","v":0},{"$f":"SUM(P24:P27)","v":0},{"$f":"R28/$H28","v":5.8823529411764705E-2},{"$f":"SUM(R24:R27)","v":200000},{"$f":"T28/$H28","v":0.94117647058823528},{"$f":"SUM(T24:T27)","v":3200000},null,{"$f":"SUM(V24:V27)","v":0}]
[null,null,null,null,null,""]
[null,4,"Indv. Trappe / opgang",null,null,null,{"$f":"I30+K30+M30+O30+Q30+S30+U30","v":0},{"$f":"E30*F30","v":0},null,{"$f":"IF(I30=0,0,SUM($H30*I30))","v":0},null,{"$f":"IF(K30=0,0,SUM($H30*K30))","v":0},null,{"$f":"IF(M30=0,0,SUM($H30*M30))","v":0},null,{"$f":"IF(O30=0,0,SUM($H30*O30))","v":0},null,{"$f":"IF(Q30=0,0,SUM($H30*Q30))","v":0},null,{"$f":"IF(S30=0,0,SUM($H30*S30))","v":0},null,{"$f":"IF(S30+Q30>0.5,0,IF(Q30<0.51,IF(S30<0.51,+R30+T30,+R30),IF(S30<0.51,T30,0)))","v":0},null,null,null,null,null,{"$f":"IF(J30>0,IF($V30>0,$V30,0),0)","v":0},{"$f":"IF(($AB30+$AD30+$AF30+$AH30)>($V30+1),AB30/2,AB30)","v":0},{"$f":"IF(L30>0,IF($V30>0,$V30,0),0)","v":0},{"$f":"IF(($AB30+$AD30+$AF30+$AH30)>($V30+1),AD30/2,AD30)","v":0},{"$f":"IF(N30>0,IF($V30>0,$V30,0),0)","v":0},{"$f":"IF(($AB30+$AD30+$AF30+$AH30)>($V30+1),AF30/2,AF30)","v":0},{"$f":"IF(P30>0,IF($V30>0,$V30,0),0)","v":0},{"$f":"IF(($AB30+$AD30+$AF30+$AH30)>($V30+1),AH30/2,AH30)","v":0},null,{"$f":"IF($A30=AK$6,+$J30+$L30+$N30+$P30,\"\")","v":""},{"$f":"IF($A30=AL$6,+$J30+$L30+$N30+$P30,\"\")","v":""},"","","","","","","","","",null,null,null,{"$f":"IF($A30=AY$6,+$R30+$T30,\"\")","v":""},"","","","","","","","","",""]
[10,null,"Maling af opgang","stk.",29,55000,1,1595000,null,0,null,0,null,0,null,0,null,0,1,1595000,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","",0,"",null,null,null,"","","","","","","","","",1595000,""]
[9,null,"Belysning","stk.",29,12000,1,348000,null,0,null,0,null,0,null,0,0.75,261000,0.25,87000,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","",0,"","",null,null,null,"","","","","","","","",348000,"",""]
[1,null,"Udskiftning af loftlem","stk.",29,6250,1,181250,null,0,null,0,null,0,null,0,0.5,90625,0.5,90625,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,0,"","","","","","","","","","",null,null,null,181250,"","","","","","","","","",""]
[3,null,"Udskiftning af vinduer","stk.",145,6000,1,870000,null,0,null,0,null,0,null,0,0.25,217500,0.75,652500,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","",0,"","","","","","","","",null,null,null,"","",870000,"","","","","","","",""]
[null,null,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,null,null,null,null,{"$f":"IFERROR(I36+K36+M36+O36+Q36+S36+U36,0)","v":1},{"$f":"SUM(H30:H35)","v":2994250},{"$f":"J36/$H36","v":0},{"$f":"SUM(J30:J35)","v":0},{"$f":"L36/$H36","v":0},{"$f":"SUM(L30:L35)","v":0},{"$f":"N36/$H36","v":0},{"$f":"SUM(N30:N35)","v":0},{"$f":"P36/$H36","v":0},{"$f":"SUM(P30:P35)","v":0},{"$f":"R36/$H36","v":0.19007263922518161},{"$f":"SUM(R30:R35)","v":569125},{"$f":"T36/$H36","v":0.80992736077481842},{"$f":"SUM(T30:T35)","v":2425125},null,{"$f":"SUM(V30:V35)","v":0}]
[null,null,null,null,null,""]
[null,5,"Boliger med tilgængelighed - 20 stk.",null,null,null,{"$f":"I38+K38+M38+O38+Q38+S38+U38","v":0},{"$f":"E38*F38","v":0},null,{"$f":"IF(I38=0,0,SUM($H38*I38))","v":0},null,{"$f":"IF(K38=0,0,SUM($H38*K38))","v":0},null,{"$f":"IF(M38=0,0,SUM($H38*M38))","v":0},null,{"$f":"IF(O38=0,0,SUM($H38*O38))","v":0},null,{"$f":"IF(Q38=0,0,SUM($H38*Q38))","v":0},null,{"$f":"IF(S38=0,0,SUM($H38*S38))","v":0},null,{"$f":"IF(S38+Q38>0.5,0,IF(Q38<0.51,IF(S38<0.51,+R38+T38,+R38),IF(S38<0.51,T38,0)))","v":0},null,null,null,null,null,{"$f":"IF(J38>0,IF($V38>0,$V38,0),0)","v":0},{"$f":"IF(($AB38+$AD38+$AF38+$AH38)>($V38+1),AB38/2,AB38)","v":0},{"$f":"IF(L38>0,IF($V38>0,$V38,0),0)","v":0},{"$f":"IF(($AB38+$AD38+$AF38+$AH38)>($V38+1),AD38/2,AD38)","v":0},{"$f":"IF(N38>0,IF($V38>0,$V38,0),0)","v":0},{"$f":"IF(($AB38+$AD38+$AF38+$AH38)>($V38+1),AF38/2,AF38)","v":0},{"$f":"IF(P38>0,IF($V38>0,$V38,0),0)","v":0},{"$f":"IF(($AB38+$AD38+$AF38+$AH38)>($V38+1),AH38/2,AH38)","v":0},null,{"$f":"IF($A38=AK$6,+$J38+$L38+$N38+$P38,\"\")","v":""},{"$f":"IF($A38=AL$6,+$J38+$L38+$N38+$P38,\"\")","v":""},"","","","","","","","","",null,null,null,{"$f":"IF($A38=AY$6,+$R38+$T38,\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,"Type: T1 (Tilgængelihed)",null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[7,null,"Bad","stk.",8,72000,1,576000,0.75,432000,null,0,0,0,0,0,0.25,144000,null,0,null,144000,null,null,null,null,null,144000,144000,0,0,0,0,0,0,null,"","","","","","",432000,"","","","",null,null,null,"","","","","","",144000,"","","",""]
[10,null,"Ombygning (Stue/Gang/køkken mv)","stk.",8,170000,1,1360000,null,0,null,0,0,0,0.67,911200,0.33,448800,null,0,null,448800,null,null,null,null,null,0,0,0,0,0,0,448800,448800,null,"","","","","","","","","",911200,"",null,null,null,"","","","","","","","","",448800,""]
[3,null,"Vinduer og døre","stk.",8,25000,1,200000,null,0,null,0,0,0,0.67,134000,0.33,66000,null,0,null,66000,null,null,null,null,null,0,0,0,0,0,0,66000,66000,null,"","",134000,"","","","","","","","",null,null,null,"","",66000,"","","","","","","",""]
[2,null,"Nyt facade parti","stk.",8,18000,1,144000,null,0,null,0,0,0,0.67,96480,0.33,47520,null,0,null,47520,null,null,null,null,null,0,0,0,0,0,0,47520,47520,null,"",96480,"","","","","","","","","",null,null,null,"",47520,"","","","","","","","",""]
[9,null,"EL-Installationer","stk.",8,25000,1,200000,null,0,null,0,0,0,0.67,134000,0.33,66000,null,0,null,66000,null,null,null,null,null,0,0,0,0,0,0,66000,66000,null,"","","","","","","","",134000,"","",null,null,null,"","","","","","","","",66000,"",""]
[9,null,"Vand og varme","stk.",8,24000,1,192000,null,0,null,0,0,0,0.67,128640.00000000001,0.33,63360,null,0,null,63360,null,null,null,null,null,0,0,0,0,0,0,63360,63360,null,"","","","","","","","",128640.00000000001,"","",null,null,null,"","","","","","","","",63360,"",""]
[9,null,"Afløb","stk.",8,12000,1,96000,null,0,null,0,0,0,0.67,64320.000000000007,0.33,31680,null,0,null,31680,null,null,null,null,null,0,0,0,0,0,0,31680,31680,null,"","","","","","","","",64320.000000000007,"","",null,null,null,"","","","","","","","",31680,"",""]
[4,null,"Altaner (udvidelse støttes)","stk.",8,75000,0.33,600000,null,0,null,0,null,0,0.33,198000,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","",198000,"","","","","","","",null,null,null,"","","",0,"","","","","","",""]
[10,null,"Forbedringer af lydforhold","stk.",8,25000,{"$f":"I49+K49+M49+O49+Q49+S49+U49","v":1},{"$f":"E49*F49","v":200000},null,{"$f":"IF(I49=0,0,SUM($H49*I49))","v":0},null,{"$f":"IF(K49=0,0,SUM($H49*K49))","v":0},null,{"$f":"IF(M49=0,0,SUM($H49*M49))","v":0},0.67,{"$f":"IF(O49=0,0,SUM($H49*O49))","v":134000},0.33,{"$f":"IF(Q49=0,0,SUM($H49*Q49))","v":66000},null,{"$f":"IF(S49=0,0,SUM($H49*S49))","v":0},null,{"$f":"IF(S49+Q49>0.5,0,IF(Q49<0.51,IF(S49<0.51,+R49+T49,+R49),IF(S49<0.51,T49,0)))","v":66000},null,null,null,null,null,{"$f":"IF(J49>0,IF($V49>0,$V49,0),0)","v":0},{"$f":"IF(($AB49+$AD49+$AF49+$AH49)>($V49+1),AB49/2,AB49)","v":0},{"$f":"IF(L49>0,IF($V49>0,$V49,0),0)","v":0},{"$f":"IF(($AB49+$AD49+$AF49+$AH49)>($V49+1),AD49/2,AD49)","v":0},{"$f":"IF(N49>0,IF($V49>0,$V49,0),0)","v":0},{"$f":"IF(($AB49+$AD49+$AF49+$AH49)>($V49+1),AF49/2,AF49)","v":0},{"$f":"IF(P49>0,IF($V49>0,$V49,0),0)","v":66000},{"$f":"IF(($AB49+$AD49+$AF49+$AH49)>($V49+1),AH49/2,AH49)","v":66000},null,"","","","","","","","","",134000,"",null,null,null,{"$f":"IF($A49=AY$6,+$R49+$T49,\"\")","v":""},"","","","","","","","",66000,""]
[null,null,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,"Type: T2 (Tilgængelihed)",null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","",{"$f":"IF($A51=AQ$6,+$J51+$L51+$N51+$P51,\"\")","v":""},"","","","",null,null,null,{"$f":"IF($A51=AY$6,+$R51+$T51,\"\")","v":""},"",{"$f":"IF($A51=BA$6,+$R51+$T51,\"\")","v":""},"","","","","","","",""]
[7,null,"Bad","stk.",12,72000,1,864000,0.75,648000,null,0,0,0,0,0,0.25,216000,null,0,null,216000,null,null,null,null,null,216000,216000,0,0,0,0,0,0,null,"","","","","","",648000,"","","","",null,null,null,"","","","","","",216000,"","","",""]
[10,null,"Ombygning (Stue/Gang/køkken mv)","stk.",12,165000,1,1980000,null,0,null,0,0,0,0.67,1326600,0.33,653400,null,0,null,653400,null,null,null,null,null,0,0,0,0,0,0,653400,653400,null,"","","","","","","","","",1326600,"",null,null,null,"","","","","","","","","",653400,""]
[3,null,"Vinduer og døre","stk.",12,25000,1,300000,null,0,null,0,0,0,0.67,201000,0.33,99000,null,0,null,99000,null,null,null,null,null,0,0,0,0,0,0,99000,99000,null,"","",201000,"","","","","","","","",null,null,null,"","",99000,"","","","","","","",""]
[2,null,"Nyt facade parti","stk.",12,15000,1,180000,null,0,null,0,0,0,0.67,120600,0.33,59400,null,0,null,59400,null,null,null,null,null,0,0,0,0,0,0,59400,59400,null,"",120600,"","","","","","","","","",null,null,null,"",59400,"","","","","","","","",""]
[9,null,"EL-Installationer","stk.",12,25000,1,300000,null,0,null,0,0,0,0.67,201000,0.33,99000,null,0,null,99000,null,null,null,null,null,0,0,0,0,0,0,99000,99000,null,"","","","","","","","",201000,"","",null,null,null,"","","","","","","","",99000,"",""]
[9,null,"Vand og varme","stk.",12,29000,1,348000,null,0,null,0,0,0,0.67,233160,0.33,114840,null,0,null,114840,null,null,null,null,null,0,0,0,0,0,0,114840,114840,null,"","","","","","","","",233160,"","",null,null,null,"","","","","","","","",114840,"",""]
[9,null,"Afløb","stk.",12,12000,1,144000,null,0,null,0,0,0,0.67,96480,0.33,47520,null,0,null,47520,null,null,null,null,null,0,0,0,0,0,0,47520,47520,null,"","","","","","","","",96480,"","",null,null,null,"","","","","","","","",47520,"",""]
[4,null,"Altaner (udvidelse støttes)","stk.",12,75000,1,900000,null,0,null,0,null,0,1,900000,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","",900000,"","","","","","","",null,null,null,"","","",0,"","","","","","",""]
[10,null,"Forbedringer af lydforhold","stk.",12,25000,{"$f":"I60+K60+M60+O60+Q60+S60+U60","v":1},{"$f":"E60*F60","v":300000},null,{"$f":"IF(I60=0,0,SUM($H60*I60))","v":0},null,{"$f":"IF(K60=0,0,SUM($H60*K60))","v":0},null,{"$f":"IF(M60=0,0,SUM($H60*M60))","v":0},0.67,{"$f":"IF(O60=0,0,SUM($H60*O60))","v":201000},0.33,{"$f":"IF(Q60=0,0,SUM($H60*Q60))","v":99000},null,{"$f":"IF(S60=0,0,SUM($H60*S60))","v":0},null,{"$f":"IF(S60+Q60>0.5,0,IF(Q60<0.51,IF(S60<0.51,+R60+T60,+R60),IF(S60<0.51,T60,0)))","v":99000},null,null,null,null,null,{"$f":"IF(J60>0,IF($V60>0,$V60,0),0)","v":0},{"$f":"IF(($AB60+$AD60+$AF60+$AH60)>($V60+1),AB60/2,AB60)","v":0},{"$f":"IF(L60>0,IF($V60>0,$V60,0),0)","v":0},{"$f":"IF(($AB60+$AD60+$AF60+$AH60)>($V60+1),AD60/2,AD60)","v":0},{"$f":"IF(N60>0,IF($V60>0,$V60,0),0)","v":0},{"$f":"IF(($AB60+$AD60+$AF60+$AH60)>($V60+1),AF60/2,AF60)","v":0},{"$f":"IF(P60>0,IF($V60>0,$V60,0),0)","v":99000},{"$f":"IF(($AB60+$AD60+$AF60+$AH60)>($V60+1),AH60/2,AH60)","v":99000},null,"","","","","","","","","",201000,"",null,null,null,{"$f":"IF($A60=AY$6,+$R60+$T60,\"\")","v":""},"","","","","","","","",99000,""]
[null,null,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,"Elevatorer",null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[6,null,"Elevator med 5 stop","stk.",2,1050000,1,2100000,null,0,null,0,null,0,1,2100000,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","",2100000,"","","","","",null,null,null,"","","","","",0,"","","","",""]
[9,null,"Elevator med 8 stop","stk.",1,1500000,1,1500000,null,0,null,0,null,0,1,1500000,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"",{"$f":"IF($A64=AL$6,+$J64+$L64+$N64+$P64,\"\")","v":""},"","","","","","",1500000,"","",null,null,null,{"$f":"IF($A64=AY$6,+$R64+$T64,\"\")","v":""},"","","","","","","",0,"",""]
[null,null,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,"Tilpasning af elevator til trapperum / opgang",null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[9,null,"Trappeopgang ved elevator med 5 stop","stk.",2,225000,1,450000,null,0,null,0,null,0,1,450000,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","",450000,"","",null,null,null,"","","","","","","","",0,"",""]
[9,null,"Trappeopgang ved elevator med 8 stop","stk.",1,360000,1,360000,null,0,null,0,null,0,1,360000,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","",360000,"","",null,null,null,"","","","","","","","",0,"",""]
[null,null,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,null,null,null,null,{"$f":"IFERROR(I70+K70+M70+O70+Q70+S70+U70,0)","v":0.96976079434331286},{"$f":"SUM(H38:H69)","v":13294000},{"$f":"J70/$H70","v":8.1239656988114944E-2},{"$f":"SUM(J38:J69)","v":1080000},{"$f":"L70/$H70","v":0},{"$f":"SUM(L38:L69)","v":0},{"$f":"N70/$H70","v":0},{"$f":"SUM(N38:N69)","v":0},{"$f":"P70/$H70","v":0.71389198134496767},{"$f":"SUM(P38:P69)","v":9490480},{"$f":"R70/$H70","v":0.17462915601023019},{"$f":"SUM(R38:R69)","v":2321520},{"$f":"T70/$H70","v":0},{"$f":"SUM(T38:T69)","v":0},null,{"$f":"SUM(V38:V69)","v":2321520}]
[null,null,null,null,null,""]
[null,6,"Boliger med ombygning/sammenlægning - 6 stk.",null,null,null,{"$f":"I72+K72+M72+O72+Q72+S72+U72","v":0},{"$f":"E72*F72","v":0},null,{"$f":"IF(I72=0,0,SUM($H72*I72))","v":0},null,{"$f":"IF(K72=0,0,SUM($H72*K72))","v":0},null,{"$f":"IF(M72=0,0,SUM($H72*M72))","v":0},null,{"$f":"IF(O72=0,0,SUM($H72*O72))","v":0},null,{"$f":"IF(Q72=0,0,SUM($H72*Q72))","v":0},null,{"$f":"IF(S72=0,0,SUM($H72*S72))","v":0},null,{"$f":"IF(S72+Q72>0.5,0,IF(Q72<0.51,IF(S72<0.51,+R72+T72,+R72),IF(S72<0.51,T72,0)))","v":0},null,null,null,null,null,{"$f":"IF(J72>0,IF($V72>0,$V72,0),0)","v":0},{"$f":"IF(($AB72+$AD72+$AF72+$AH72)>($V72+1),AB72/2,AB72)","v":0},{"$f":"IF(L72>0,IF($V72>0,$V72,0),0)","v":0},{"$f":"IF(($AB72+$AD72+$AF72+$AH72)>($V72+1),AD72/2,AD72)","v":0},{"$f":"IF(N72>0,IF($V72>0,$V72,0),0)","v":0},{"$f":"IF(($AB72+$AD72+$AF72+$AH72)>($V72+1),AF72/2,AF72)","v":0},{"$f":"IF(P72>0,IF($V72>0,$V72,0),0)","v":0},{"$f":"IF(($AB72+$AD72+$AF72+$AH72)>($V72+1),AH72/2,AH72)","v":0},null,{"$f":"IF($A72=AK$6,+$J72+$L72+$N72+$P72,\"\")","v":""},{"$f":"IF($A72=AL$6,+$J72+$L72+$N72+$P72,\"\")","v":""},"","","","","","","","","",null,null,null,{"$f":"IF($A72=AY$6,+$R72+$T72,\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,"Type: OS1 (Sammenlægning)","stk.",null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[7,null,"Bad","stk.",3,75000,1,225000,0.75,168750,null,0,0,0,null,0,0.25,56250,null,0,null,56250,null,null,null,null,null,56250,56250,0,0,0,0,0,0,null,"","","","","","",168750,"","","","",null,null,null,"","","","","","",56250,"","","",""]
[10,null,"Ombygning (Stue/Gang/køkken mv)","stk.",3,130000,1,390000,null,0,null,0,0.67,261300.00000000003,null,0,0.33,128700,null,0,null,128700,null,null,null,null,null,0,0,0,0,128700,128700,0,0,null,"","","","","","","","","",261300.00000000003,"",null,null,null,"","","","","","","","","",128700,""]
[3,null,"Vinduer og døre","stk.",3,42000,1,126000,null,0,null,0,0.67,84420,null,0,0.33,41580,null,0,null,41580,null,null,null,null,null,0,0,0,0,41580,41580,0,0,null,"","",84420,"","","","","","","","",null,null,null,"","",41580,"","","","","","","",""]
[9,null,"EL-Installationer","stk.",3,14000,1,42000,null,null,null,0,0.67,28140,null,0,0.33,13860,null,0,null,13860,null,null,null,null,null,0,0,0,0,13860,13860,0,0,null,"","","","","","","","",28140,"","",null,null,null,"","","","","","","","",13860,"",""]
[9,null,"Vand og varme","stk.",3,27500,1,82500,null,0,null,0,0.67,55275,null,0,0.33,27225,null,0,null,27225,null,null,null,null,null,0,0,0,0,27225,27225,0,0,null,"","","","","","","","",55275,"","",null,null,null,"","","","","","","","",27225,"",""]
[9,null,"Afløb","stk.",3,12500,1,37500,null,0,null,0,0.67,25125,null,0,0.33,12375,null,0,null,12375,null,null,null,null,null,0,0,0,0,12375,12375,0,0,null,"","","","","","","","",25125,"","",null,null,null,"","","","","","","","",12375,"",""]
[4,null,"Altaner","stk.",3,75000,1,225000,null,0,null,0,0,0,null,0,1,225000,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","",0,"","","","","","","",null,null,null,"","","",225000,"","","","","","",""]
[10,null,"Forbedringer af lydforhold","stk.",3,25000,1,75000,null,0,null,0,0.67,50250,null,0,0.33,24750,null,0,null,24750,null,null,null,null,null,0,0,0,0,24750,24750,0,0,null,"","","","","","","","","",50250,"",null,null,null,"","","","","","","","","",24750,""]
[null,null,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,"Type: OS2 (Ombygning)",null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[7,null,"Bad","stk.",3,75000,1,225000,0.75,168750,null,0,0,0,null,0,0.25,56250,null,0,null,56250,null,null,null,null,null,56250,56250,0,0,0,0,0,0,null,"","","","","","",168750,"","","","",null,null,null,"","","","","","",56250,"","","",""]
[10,null,"Ombygning (Stue/Gang/køkken mv)","stk.",3,165000,1,495000,null,0,null,0,0.67,331650,null,0,0.33,163350,null,0,null,163350,null,null,null,null,null,0,0,0,0,163350,163350,0,0,null,"","","","","","","","","",331650,"",null,null,null,"","","","","","","","","",163350,""]
[3,null,"Vinduer og døre","stk.",3,25000,1,75000,null,0,null,0,0.67,50250,null,0,0.33,24750,null,0,null,24750,null,null,null,null,null,0,0,0,0,24750,24750,0,0,null,"","",50250,"","","","","","","","",null,null,null,"","",24750,"","","","","","","",""]
[9,null,"EL-Installationer","stk.",3,15000,1,45000,null,0,null,0,0.67,30150,null,0,0.33,14850,null,0,null,14850,null,null,null,null,null,0,0,0,0,14850,14850,0,0,null,"","","","","","","","",30150,"","",null,null,null,"","","","","","","","",14850,"",""]
[9,null,"Vand og varme","stk.",3,32000,1,96000,null,0,null,0,0.67,64320.000000000007,null,0,0.33,31680,null,0,null,31680,null,null,null,null,null,0,0,0,0,31680,31680,0,0,null,"","","","","","","","",64320.000000000007,"","",null,null,null,"","","","","","","","",31680,"",""]
[9,null,"Afløb","stk.",3,15000,1,45000,null,0,null,0,0.67,30150,null,0,0.33,14850,null,0,null,14850,null,null,null,null,null,0,0,0,0,14850,14850,0,0,null,"","","","","","","","",30150,"","",null,null,null,"","","","","","","","",14850,"",""]
[4,null,"Altaner","stk.",3,75000,1,225000,null,0,null,0,0,0,null,0,1,225000,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","",0,"","","","","","","",null,null,null,"","","",225000,"","","","","","",""]
[10,null,"Forbedringer af lydforhold","stk.",3,25000,1,75000,null,0,null,0,0.67,50250,null,0,0.33,24750,null,0,null,24750,null,null,null,null,null,0,0,0,0,24750,24750,0,0,null,"","","","","","","","","",50250,"",null,null,null,"","",{"$f":"IF($A92=BA$6,+$R92+$T92,\"\")","v":""},"","","","","","",24750,""]
[null,null,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,null,null,null,null,{"$f":"IFERROR(I94+K94+M94+O94+Q94+S94+U94,0)","v":1},{"$f":"SUM(H72:H93)","v":2484000},{"$f":"J94/$H94","v":0.1358695652173913},{"$f":"SUM(J72:J93)","v":337500},{"$f":"L94/$H94","v":0},{"$f":"SUM(L72:L93)","v":0},{"$f":"N94/$H94","v":0.42724637681159422},{"$f":"SUM(N72:N93)","v":1061280},{"$f":"P94/$H94","v":0},{"$f":"SUM(P72:P93)","v":0},{"$f":"R94/$H94","v":0.43688405797101448},{"$f":"SUM(R72:R93)","v":1085220},{"$f":"T94/$H94","v":0},{"$f":"SUM(T72:T93)","v":0},null,{"$f":"SUM(V72:V93)","v":635220}]
[null,null,null,null,null,""]
[null,7,"Boliger med modernisering - 114 boliger",null,null,null,{"$f":"I96+K96+M96+O96+Q96+S96+U96","v":0},{"$f":"E96*F96","v":0},null,{"$f":"IF(I96=0,0,SUM($H96*I96))","v":0},null,{"$f":"IF(K96=0,0,SUM($H96*K96))","v":0},null,{"$f":"IF(M96=0,0,SUM($H96*M96))","v":0},null,{"$f":"IF(O96=0,0,SUM($H96*O96))","v":0},null,{"$f":"IF(Q96=0,0,SUM($H96*Q96))","v":0},null,{"$f":"IF(S96=0,0,SUM($H96*S96))","v":0},null,{"$f":"IF(S96+Q96>0.5,0,IF(Q96<0.51,IF(S96<0.51,+R96+T96,+R96),IF(S96<0.51,T96,0)))","v":0},null,null,null,null,null,{"$f":"IF(J96>0,IF($V96>0,$V96,0),0)","v":0},{"$f":"IF(($AB96+$AD96+$AF96+$AH96)>($V96+1),AB96/2,AB96)","v":0},{"$f":"IF(L96>0,IF($V96>0,$V96,0),0)","v":0},{"$f":"IF(($AB96+$AD96+$AF96+$AH96)>($V96+1),AD96/2,AD96)","v":0},{"$f":"IF(N96>0,IF($V96>0,$V96,0),0)","v":0},{"$f":"IF(($AB96+$AD96+$AF96+$AH96)>($V96+1),AF96/2,AF96)","v":0},{"$f":"IF(P96>0,IF($V96>0,$V96,0),0)","v":0},{"$f":"IF(($AB96+$AD96+$AF96+$AH96)>($V96+1),AH96/2,AH96)","v":0},null,{"$f":"IF($A96=AK$6,+$J96+$L96+$N96+$P96,\"\")","v":""},{"$f":"IF($A96=AL$6,+$J96+$L96+$N96+$P96,\"\")","v":""},"","","","","","","","","",null,null,null,{"$f":"IF($A96=AY$6,+$R96+$T96,\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,"Type: M1 (Oprindelig boligplan)",null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[7,null,"Bad","stk.",48,75000,1,3600000,null,0,null,0,null,0,null,0,1,3600000,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","",0,"","","","",null,null,null,"","","","","","",3600000,"","","",""]
[10,null,"Ombygning (Stue/Gang/køkken mv)","stk.",48,85000,1,4080000,null,0,null,0,null,0,null,0,1,4080000,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","",0,"",null,null,null,"","","","","","","","","",4080000,""]
[3,null,"Vinduer og døre","stk.",48,42000,1,2016000,null,0,null,0,null,0,null,0,1,2016000,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","",0,"","","","","","","","",null,null,null,"","",2016000,"","","","","","","",""]
[9,null,"EL-Installationer","stk.",48,13600,1,652800,null,0,null,0,null,0,null,0,1,652800,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","",0,"","",null,null,null,"","","","","","","","",652800,"",""]
[9,null,"Vand og varme","stk.",48,28000,1,1344000,null,0,null,0,null,0,null,0,1,1344000,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","",0,"","",null,null,null,"","","","","","","","",1344000,"",""]
[9,null,"Afløb","stk.",48,12500,1,600000,null,0,null,0,null,0,null,0,1,600000,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","",0,"","",null,null,null,"","","","","","","","",600000,"",""]
[4,null,"Altaner","stk.",48,75000,1,3600000,null,0,null,0,null,0,null,0,1,3600000,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","",0,"","","","","","","",null,null,null,"","","",3600000,"","","","","","",""]
[null,null,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,"Type: M2 (Oprindelig boligplan)",null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[7,null,"Bad","stk.",36,75000,1,2700000,null,0,null,0,null,0,null,0,1,2700000,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","",0,"","","","",null,null,null,"","","","","","",2700000,"","","",""]
[10,null,"Ombygning (Stue/Gang/køkken mv)","stk.",36,85000,1,3060000,null,0,null,0,null,0,null,0,1,3060000,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","",0,"",null,null,null,"","","","","","","","","",3060000,""]
[3,null,"Vinduer og døre","stk.",36,42000,1,1512000,null,0,null,0,null,0,null,0,1,1512000,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","",0,"","","","","","","","",null,null,null,"","",1512000,"","","","","","","",""]
[9,null,"EL-Installationer","stk.",36,13600,1,489600,null,0,null,0,null,0,null,0,1,489600,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","",0,"","",null,null,null,"","","","","","","","",489600,"",""]
[9,null,"Vand og varme","stk.",36,30500,1,1098000,null,0,null,0,null,0,null,0,1,1098000,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","",0,"","",null,null,null,"","","","","","","","",1098000,"",""]
[9,null,"Afløb","stk.",36,9000,1,324000,null,0,null,0,null,0,null,0,1,324000,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","",0,"","",null,null,null,"","","","","","","","",324000,"",""]
[4,null,"Altaner","stk.",36,75000,1,2700000,null,0,null,0,null,0,null,0,1,2700000,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","",0,"","","","","","","",null,null,null,"","","",2700000,"","","","","","",""]
[null,null,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,"Type: M3 (Oprindelig boligplan)",null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"",{"$f":"IF($A116=AL$6,+$J116+$L116+$N116+$P116,\"\")","v":""},"","","","",{"$f":"IF($A116=AQ$6,+$J116+$L116+$N116+$P116,\"\")","v":""},"","","","",null,null,null,{"$f":"IF($A116=AY$6,+$R116+$T116,\"\")","v":""},"",{"$f":"IF($A116=BA$6,+$R116+$T116,\"\")","v":""},"","","","","","","",""]
[7,null,"Bad","stk.",30,75000,1,2250000,null,0,null,0,null,0,null,0,1,2250000,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","",0,"","","","",null,null,null,"","","","","","",2250000,"","","",""]
[10,null,"Ombygning (Stue/Gang/køkken mv)","stk.",30,90000,1,2700000,null,0,null,0,null,0,null,0,1,2700000,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","",0,"",null,null,null,"","","","","","","","","",2700000,""]
[2,null,"Vinduer og døre","stk.",30,42000,1,1260000,null,0,null,0,null,0,null,0,1,1260000,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"",0,"","","","","","","","","",null,null,null,"",1260000,"","","","","","","","",""]
[10,null,"EL-Installationer","stk.",30,14000,1,420000,null,0,null,0,null,0,null,0,1,420000,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","",0,"",null,null,null,"","","","","","","","","",420000,""]
[10,null,"Vand og varme","stk.",30,21000,1,630000,null,0,null,0,null,0,null,0,1,630000,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","",0,"",null,null,null,"","","","","","","","","",630000,""]
[10,null,"Afløb","stk.",30,12500,1,375000,null,0,null,0,null,0,null,0,1,375000,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","",0,"",null,null,null,"","","","","","","","","",375000,""]
[4,null,"Altaner","stk.",30,75000,1,2250000,null,0,null,0,null,0,null,0,1,2250000,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","",0,"","","","","","","",null,null,null,"","","",2250000,"","","","","","",""]
[null,null,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,null,null,null,null,{"$f":"IFERROR(I125+K125+M125+O125+Q125+S125+U125,0)","v":1},{"$f":"SUM(H96:H124)","v":37661400},{"$f":"J125/$H125","v":0},{"$f":"SUM(J96:J124)","v":0},{"$f":"L125/$H125","v":0},{"$f":"SUM(L96:L124)","v":0},{"$f":"N125/$H125","v":0},{"$f":"SUM(N96:N124)","v":0},{"$f":"P125/$H125","v":0},{"$f":"SUM(P96:P124)","v":0},{"$f":"R125/$H125","v":1},{"$f":"SUM(R96:R124)","v":37661400},{"$f":"T125/$H125","v":0},{"$f":"SUM(T96:T124)","v":0},null,{"$f":"SUM(V96:V124)","v":0}]
[null,null,null,null,null,""]
[null,8,"Teknikrum",null,null,null,{"$f":"I127+K127+M127+O127+Q127+S127+U127","v":0},{"$f":"E127*F127","v":0},null,{"$f":"IF(I127=0,0,SUM($H127*I127))","v":0},null,{"$f":"IF(K127=0,0,SUM($H127*K127))","v":0},null,{"$f":"IF(M127=0,0,SUM($H127*M127))","v":0},null,{"$f":"IF(O127=0,0,SUM($H127*O127))","v":0},null,{"$f":"IF(Q127=0,0,SUM($H127*Q127))","v":0},null,{"$f":"IF(S127=0,0,SUM($H127*S127))","v":0},null,{"$f":"IF(S127+Q127>0.5,0,IF(Q127<0.51,IF(S127<0.51,+R127+T127,+R127),IF(S127<0.51,T127,0)))","v":0},null,null,null,null,null,{"$f":"IF(J127>0,IF($V127>0,$V127,0),0)","v":0},{"$f":"IF(($AB127+$AD127+$AF127+$AH127)>($V127+1),AB127/2,AB127)","v":0},{"$f":"IF(L127>0,IF($V127>0,$V127,0),0)","v":0},{"$f":"IF(($AB127+$AD127+$AF127+$AH127)>($V127+1),AD127/2,AD127)","v":0},{"$f":"IF(N127>0,IF($V127>0,$V127,0),0)","v":0},{"$f":"IF(($AB127+$AD127+$AF127+$AH127)>($V127+1),AF127/2,AF127)","v":0},{"$f":"IF(P127>0,IF($V127>0,$V127,0),0)","v":0},{"$f":"IF(($AB127+$AD127+$AF127+$AH127)>($V127+1),AH127/2,AH127)","v":0},null,{"$f":"IF($A127=AK$6,+$J127+$L127+$N127+$P127,\"\")","v":""},{"$f":"IF($A127=AL$6,+$J127+$L127+$N127+$P127,\"\")","v":""},"","","","","","","","","",null,null,null,{"$f":"IF($A127=AY$6,+$R127+$T127,\"\")","v":""},"","","","","","","","","",""]
[9,null,"Teknikrum","stk.",5,63013,{"$f":"I128+K128+M128+O128+Q128+S128+U128","v":1},{"$f":"E128*F128","v":315065},null,{"$f":"IF(I128=0,0,SUM($H128*I128))","v":0},null,{"$f":"IF(K128=0,0,SUM($H128*K128))","v":0},null,{"$f":"IF(M128=0,0,SUM($H128*M128))","v":0},null,{"$f":"IF(O128=0,0,SUM($H128*O128))","v":0},null,{"$f":"IF(Q128=0,0,SUM($H128*Q128))","v":0},1,{"$f":"IF(S128=0,0,SUM($H128*S128))","v":315065},null,{"$f":"IF(S128+Q128>0.5,0,IF(Q128<0.51,IF(S128<0.51,+R128+T128,+R128),IF(S128<0.51,T128,0)))","v":0},null,null,null,null,null,{"$f":"IF(J128>0,IF($V128>0,$V128,0),0)","v":0},{"$f":"IF(($AB128+$AD128+$AF128+$AH128)>($V128+1),AB128/2,AB128)","v":0},{"$f":"IF(L128>0,IF($V128>0,$V128,0),0)","v":0},{"$f":"IF(($AB128+$AD128+$AF128+$AH128)>($V128+1),AD128/2,AD128)","v":0},{"$f":"IF(N128>0,IF($V128>0,$V128,0),0)","v":0},{"$f":"IF(($AB128+$AD128+$AF128+$AH128)>($V128+1),AF128/2,AF128)","v":0},{"$f":"IF(P128>0,IF($V128>0,$V128,0),0)","v":0},{"$f":"IF(($AB128+$AD128+$AF128+$AH128)>($V128+1),AH128/2,AH128)","v":0},null,{"$f":"IF($A128=AK$6,+$J128+$L128+$N128+$P128,\"\")","v":""},"","","","","","","",0,"","",null,null,null,"","","","","","","","",315065,"",""]
[null,null,null,null,null,null,{"$f":"I129+K129+M129+O129+Q129+S129+U129","v":0},{"$f":"E129*F129","v":0},null,{"$f":"IF(I129=0,0,SUM($H129*I129))","v":0},null,{"$f":"IF(K129=0,0,SUM($H129*K129))","v":0},null,{"$f":"IF(M129=0,0,SUM($H129*M129))","v":0},null,{"$f":"IF(O129=0,0,SUM($H129*O129))","v":0},null,{"$f":"IF(Q129=0,0,SUM($H129*Q129))","v":0},null,{"$f":"IF(S129=0,0,SUM($H129*S129))","v":0},null,{"$f":"IF(S129+Q129>0.5,0,IF(Q129<0.51,IF(S129<0.51,+R129+T129,+R129),IF(S129<0.51,T129,0)))","v":0},null,null,null,null,null,{"$f":"IF(J129>0,IF($V129>0,$V129,0),0)","v":0},{"$f":"IF(($AB129+$AD129+$AF129+$AH129)>($V129+1),AB129/2,AB129)","v":0},{"$f":"IF(L129>0,IF($V129>0,$V129,0),0)","v":0},{"$f":"IF(($AB129+$AD129+$AF129+$AH129)>($V129+1),AD129/2,AD129)","v":0},{"$f":"IF(N129>0,IF($V129>0,$V129,0),0)","v":0},{"$f":"IF(($AB129+$AD129+$AF129+$AH129)>($V129+1),AF129/2,AF129)","v":0},{"$f":"IF(P129>0,IF($V129>0,$V129,0),0)","v":0},{"$f":"IF(($AB129+$AD129+$AF129+$AH129)>($V129+1),AH129/2,AH129)","v":0},null,{"$f":"IF($A129=AK$6,+$J129+$L129+$N129+$P129,\"\")","v":""},"","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,null,null,null,null,{"$f":"IFERROR(I130+K130+M130+O130+Q130+S130+U130,0)","v":1},{"$f":"SUM(H127:H129)","v":315065},{"$f":"J130/$H130","v":0},{"$f":"SUM(J127:J129)","v":0},{"$f":"L130/$H130","v":0},{"$f":"SUM(L127:L129)","v":0},{"$f":"N130/$H130","v":0},{"$f":"SUM(N127:N129)","v":0},{"$f":"P130/$H130","v":0},{"$f":"SUM(P127:P129)","v":0},{"$f":"R130/$H130","v":0},{"$f":"SUM(R127:R129)","v":0},{"$f":"T130/$H130","v":1},{"$f":"SUM(T127:T129)","v":315065},null,{"$f":"SUM(V127:V129)","v":0}]
[null,null,null,null,null,""]
[null,9,"Indeklima",null,null,null,{"$f":"I132+K132+M132+O132+Q132+S132+U132","v":0},{"$f":"E132*F132","v":0},null,{"$f":"IF(I132=0,0,SUM($H132*I132))","v":0},null,{"$f":"IF(K132=0,0,SUM($H132*K132))","v":0},null,{"$f":"IF(M132=0,0,SUM($H132*M132))","v":0},null,{"$f":"IF(O132=0,0,SUM($H132*O132))","v":0},null,{"$f":"IF(Q132=0,0,SUM($H132*Q132))","v":0},null,{"$f":"IF(S132=0,0,SUM($H132*S132))","v":0},null,{"$f":"IF(S132+Q132>0.5,0,IF(Q132<0.51,IF(S132<0.51,+R132+T132,+R132),IF(S132<0.51,T132,0)))","v":0},null,null,null,null,null,{"$f":"IF(J132>0,IF($V132>0,$V132,0),0)","v":0},{"$f":"IF(($AB132+$AD132+$AF132+$AH132)>($V132+1),AB132/2,AB132)","v":0},{"$f":"IF(L132>0,IF($V132>0,$V132,0),0)","v":0},{"$f":"IF(($AB132+$AD132+$AF132+$AH132)>($V132+1),AD132/2,AD132)","v":0},{"$f":"IF(N132>0,IF($V132>0,$V132,0),0)","v":0},{"$f":"IF(($AB132+$AD132+$AF132+$AH132)>($V132+1),AF132/2,AF132)","v":0},{"$f":"IF(P132>0,IF($V132>0,$V132,0),0)","v":0},{"$f":"IF(($AB132+$AD132+$AF132+$AH132)>($V132+1),AH132/2,AH132)","v":0},null,{"$f":"IF($A132=AK$6,+$J132+$L132+$N132+$P132,\"\")","v":""},{"$f":"IF($A132=AL$6,+$J132+$L132+$N132+$P132,\"\")","v":""},"","","","","","","","","",null,null,null,{"$f":"IF($A132=AY$6,+$R132+$T132,\"\")","v":""},"","","","","","","","","",""]
[9,null,"Asbest - VVS installationer","stk.",1,365000,{"$f":"I133+K133+M133+O133+Q133+S133+U133","v":1},{"$f":"E133*F133","v":365000},null,{"$f":"IF(I133=0,0,SUM($H133*I133))","v":0},null,{"$f":"IF(K133=0,0,SUM($H133*K133))","v":0},null,{"$f":"IF(M133=0,0,SUM($H133*M133))","v":0},null,{"$f":"IF(O133=0,0,SUM($H133*O133))","v":0},1,{"$f":"IF(Q133=0,0,SUM($H133*Q133))","v":365000},null,{"$f":"IF(S133=0,0,SUM($H133*S133))","v":0},null,{"$f":"IF(S133+Q133>0.5,0,IF(Q133<0.51,IF(S133<0.51,+R133+T133,+R133),IF(S133<0.51,T133,0)))","v":0},null,null,null,null,null,{"$f":"IF(J133>0,IF($V133>0,$V133,0),0)","v":0},{"$f":"IF(($AB133+$AD133+$AF133+$AH133)>($V133+1),AB133/2,AB133)","v":0},{"$f":"IF(L133>0,IF($V133>0,$V133,0),0)","v":0},{"$f":"IF(($AB133+$AD133+$AF133+$AH133)>($V133+1),AD133/2,AD133)","v":0},{"$f":"IF(N133>0,IF($V133>0,$V133,0),0)","v":0},{"$f":"IF(($AB133+$AD133+$AF133+$AH133)>($V133+1),AF133/2,AF133)","v":0},{"$f":"IF(P133>0,IF($V133>0,$V133,0),0)","v":0},{"$f":"IF(($AB133+$AD133+$AF133+$AH133)>($V133+1),AH133/2,AH133)","v":0},null,{"$f":"IF($A133=AK$6,+$J133+$L133+$N133+$P133,\"\")","v":""},"","","","","","","",0,"","",null,null,null,"","","","","","","","",365000,"",""]
[10,null,"Forbedringer af lydforhold","stk.",1,5000000,{"$f":"I134+K134+M134+O134+Q134+S134+U134","v":1},{"$f":"E134*F134","v":5000000},null,{"$f":"IF(I134=0,0,SUM($H134*I134))","v":0},null,{"$f":"IF(K134=0,0,SUM($H134*K134))","v":0},null,{"$f":"IF(M134=0,0,SUM($H134*M134))","v":0},null,{"$f":"IF(O134=0,0,SUM($H134*O134))","v":0},1,{"$f":"IF(Q134=0,0,SUM($H134*Q134))","v":5000000},null,{"$f":"IF(S134=0,0,SUM($H134*S134))","v":0},null,{"$f":"IF(S134+Q134>0.5,0,IF(Q134<0.51,IF(S134<0.51,+R134+T134,+R134),IF(S134<0.51,T134,0)))","v":0},null,null,null,null,null,{"$f":"IF(J134>0,IF($V134>0,$V134,0),0)","v":0},{"$f":"IF(($AB134+$AD134+$AF134+$AH134)>($V134+1),AB134/2,AB134)","v":0},{"$f":"IF(L134>0,IF($V134>0,$V134,0),0)","v":0},{"$f":"IF(($AB134+$AD134+$AF134+$AH134)>($V134+1),AD134/2,AD134)","v":0},{"$f":"IF(N134>0,IF($V134>0,$V134,0),0)","v":0},{"$f":"IF(($AB134+$AD134+$AF134+$AH134)>($V134+1),AF134/2,AF134)","v":0},{"$f":"IF(P134>0,IF($V134>0,$V134,0),0)","v":0},{"$f":"IF(($AB134+$AD134+$AF134+$AH134)>($V134+1),AH134/2,AH134)","v":0},null,{"$f":"IF($A134=AK$6,+$J134+$L134+$N134+$P134,\"\")","v":""},"","","","","","","","",0,"",null,null,null,"","","","","","","","","",5000000,""]
[null,null,null,null,null,null,{"$f":"I135+K135+M135+O135+Q135+S135+U135","v":0},{"$f":"E135*F135","v":0},null,{"$f":"IF(I135=0,0,SUM($H135*I135))","v":0},null,{"$f":"IF(K135=0,0,SUM($H135*K135))","v":0},null,{"$f":"IF(M135=0,0,SUM($H135*M135))","v":0},null,{"$f":"IF(O135=0,0,SUM($H135*O135))","v":0},null,{"$f":"IF(Q135=0,0,SUM($H135*Q135))","v":0},null,{"$f":"IF(S135=0,0,SUM($H135*S135))","v":0},null,{"$f":"IF(S135+Q135>0.5,0,IF(Q135<0.51,IF(S135<0.51,+R135+T135,+R135),IF(S135<0.51,T135,0)))","v":0},null,null,null,null,null,{"$f":"IF(J135>0,IF($V135>0,$V135,0),0)","v":0},{"$f":"IF(($AB135+$AD135+$AF135+$AH135)>($V135+1),AB135/2,AB135)","v":0},{"$f":"IF(L135>0,IF($V135>0,$V135,0),0)","v":0},{"$f":"IF(($AB135+$AD135+$AF135+$AH135)>($V135+1),AD135/2,AD135)","v":0},{"$f":"IF(N135>0,IF($V135>0,$V135,0),0)","v":0},{"$f":"IF(($AB135+$AD135+$AF135+$AH135)>($V135+1),AF135/2,AF135)","v":0},{"$f":"IF(P135>0,IF($V135>0,$V135,0),0)","v":0},{"$f":"IF(($AB135+$AD135+$AF135+$AH135)>($V135+1),AH135/2,AH135)","v":0},null,{"$f":"IF($A135=AK$6,+$J135+$L135+$N135+$P135,\"\")","v":""},"","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,null,null,null,null,{"$f":"IFERROR(I136+K136+M136+O136+Q136+S136+U136,0)","v":1},{"$f":"SUM(H132:H135)","v":5365000},{"$f":"J136/$H136","v":0},{"$f":"SUM(J132:J135)","v":0},{"$f":"L136/$H136","v":0},{"$f":"SUM(L132:L135)","v":0},{"$f":"N136/$H136","v":0},{"$f":"SUM(N132:N135)","v":0},{"$f":"P136/$H136","v":0},{"$f":"SUM(P132:P135)","v":0},{"$f":"R136/$H136","v":1},{"$f":"SUM(R132:R135)","v":5365000},{"$f":"T136/$H136","v":0},{"$f":"SUM(T132:T135)","v":0},null,{"$f":"SUM(V132:V135)","v":0}]
[null,null,null,null,null,""]
[null,10,"Ventilation",null,null,null,{"$f":"I138+K138+M138+O138+Q138+S138+U138","v":0},{"$f":"E138*F138","v":0},null,{"$f":"IF(I138=0,0,SUM($H138*I138))","v":0},null,{"$f":"IF(K138=0,0,SUM($H138*K138))","v":0},null,{"$f":"IF(M138=0,0,SUM($H138*M138))","v":0},null,{"$f":"IF(O138=0,0,SUM($H138*O138))","v":0},null,{"$f":"IF(Q138=0,0,SUM($H138*Q138))","v":0},null,{"$f":"IF(S138=0,0,SUM($H138*S138))","v":0},null,{"$f":"IF(S138+Q138>0.5,0,IF(Q138<0.51,IF(S138<0.51,+R138+T138,+R138),IF(S138<0.51,T138,0)))","v":0},null,null,null,null,null,{"$f":"IF(J138>0,IF($V138>0,$V138,0),0)","v":0},{"$f":"IF(($AB138+$AD138+$AF138+$AH138)>($V138+1),AB138/2,AB138)","v":0},{"$f":"IF(L138>0,IF($V138>0,$V138,0),0)","v":0},{"$f":"IF(($AB138+$AD138+$AF138+$AH138)>($V138+1),AD138/2,AD138)","v":0},{"$f":"IF(N138>0,IF($V138>0,$V138,0),0)","v":0},{"$f":"IF(($AB138+$AD138+$AF138+$AH138)>($V138+1),AF138/2,AF138)","v":0},{"$f":"IF(P138>0,IF($V138>0,$V138,0),0)","v":0},{"$f":"IF(($AB138+$AD138+$AF138+$AH138)>($V138+1),AH138/2,AH138)","v":0},null,{"$f":"IF($A138=AK$6,+$J138+$L138+$N138+$P138,\"\")","v":""},{"$f":"IF($A138=AL$6,+$J138+$L138+$N138+$P138,\"\")","v":""},"","","","","","","","","",null,null,null,{"$f":"IF($A138=AY$6,+$R138+$T138,\"\")","v":""},"","","","","","","","","",""]
[9,null,"Ventilation (ballanceret ventilationanlæg inkl. installation, rør mv.)","stk.",174,48500,{"$f":"I139+K139+M139+O139+Q139+S139+U139","v":1},{"$f":"E139*F139","v":8439000},0.75,{"$f":"IF(I139=0,0,SUM($H139*I139))","v":6329250},null,{"$f":"IF(K139=0,0,SUM($H139*K139))","v":0},null,{"$f":"IF(M139=0,0,SUM($H139*M139))","v":0},null,{"$f":"IF(O139=0,0,SUM($H139*O139))","v":0},0.25,{"$f":"IF(Q139=0,0,SUM($H139*Q139))","v":2109750},null,{"$f":"IF(S139=0,0,SUM($H139*S139))","v":0},null,{"$f":"IF(S139+Q139>0.5,0,IF(Q139<0.51,IF(S139<0.51,+R139+T139,+R139),IF(S139<0.51,T139,0)))","v":2109750},null,null,null,null,null,{"$f":"IF(J139>0,IF($V139>0,$V139,0),0)","v":2109750},{"$f":"IF(($AB139+$AD139+$AF139+$AH139)>($V139+1),AB139/2,AB139)","v":2109750},{"$f":"IF(L139>0,IF($V139>0,$V139,0),0)","v":0},{"$f":"IF(($AB139+$AD139+$AF139+$AH139)>($V139+1),AD139/2,AD139)","v":0},{"$f":"IF(N139>0,IF($V139>0,$V139,0),0)","v":0},{"$f":"IF(($AB139+$AD139+$AF139+$AH139)>($V139+1),AF139/2,AF139)","v":0},{"$f":"IF(P139>0,IF($V139>0,$V139,0),0)","v":0},{"$f":"IF(($AB139+$AD139+$AF139+$AH139)>($V139+1),AH139/2,AH139)","v":0},null,{"$f":"IF($A139=AK$6,+$J139+$L139+$N139+$P139,\"\")","v":""},"","","","","","","",6329250,"","",null,null,null,"","","","","","","","",2109750,"",""]
[9,null,"Varmeflade til ventilationanlæg inkl. rørføring mv.","stk.",174,6500,{"$f":"I140+K140+M140+O140+Q140+S140+U140","v":1},{"$f":"E140*F140","v":1131000},null,{"$f":"IF(I140=0,0,SUM($H140*I140))","v":0},null,{"$f":"IF(K140=0,0,SUM($H140*K140))","v":0},null,{"$f":"IF(M140=0,0,SUM($H140*M140))","v":0},null,{"$f":"IF(O140=0,0,SUM($H140*O140))","v":0},1,{"$f":"IF(Q140=0,0,SUM($H140*Q140))","v":1131000},null,{"$f":"IF(S140=0,0,SUM($H140*S140))","v":0},null,{"$f":"IF(S140+Q140>0.5,0,IF(Q140<0.51,IF(S140<0.51,+R140+T140,+R140),IF(S140<0.51,T140,0)))","v":0},null,null,null,null,null,{"$f":"IF(J140>0,IF($V140>0,$V140,0),0)","v":0},{"$f":"IF(($AB140+$AD140+$AF140+$AH140)>($V140+1),AB140/2,AB140)","v":0},{"$f":"IF(L140>0,IF($V140>0,$V140,0),0)","v":0},{"$f":"IF(($AB140+$AD140+$AF140+$AH140)>($V140+1),AD140/2,AD140)","v":0},{"$f":"IF(N140>0,IF($V140>0,$V140,0),0)","v":0},{"$f":"IF(($AB140+$AD140+$AF140+$AH140)>($V140+1),AF140/2,AF140)","v":0},{"$f":"IF(P140>0,IF($V140>0,$V140,0),0)","v":0},{"$f":"IF(($AB140+$AD140+$AF140+$AH140)>($V140+1),AH140/2,AH140)","v":0},null,{"$f":"IF($A140=AK$6,+$J140+$L140+$N140+$P140,\"\")","v":""},"","","","","","","",0,"","",null,null,null,"","","","","","","","",1131000,"",""]
[null,null,null,null,null,null,{"$f":"I141+K141+M141+O141+Q141+S141+U141","v":0},{"$f":"E141*F141","v":0},null,{"$f":"IF(I141=0,0,SUM($H141*I141))","v":0},null,{"$f":"IF(K141=0,0,SUM($H141*K141))","v":0},null,{"$f":"IF(M141=0,0,SUM($H141*M141))","v":0},null,{"$f":"IF(O141=0,0,SUM($H141*O141))","v":0},null,{"$f":"IF(Q141=0,0,SUM($H141*Q141))","v":0},null,{"$f":"IF(S141=0,0,SUM($H141*S141))","v":0},null,{"$f":"IF(S141+Q141>0.5,0,IF(Q141<0.51,IF(S141<0.51,+R141+T141,+R141),IF(S141<0.51,T141,0)))","v":0},null,null,null,null,null,{"$f":"IF(J141>0,IF($V141>0,$V141,0),0)","v":0},{"$f":"IF(($AB141+$AD141+$AF141+$AH141)>($V141+1),AB141/2,AB141)","v":0},{"$f":"IF(L141>0,IF($V141>0,$V141,0),0)","v":0},{"$f":"IF(($AB141+$AD141+$AF141+$AH141)>($V141+1),AD141/2,AD141)","v":0},{"$f":"IF(N141>0,IF($V141>0,$V141,0),0)","v":0},{"$f":"IF(($AB141+$AD141+$AF141+$AH141)>($V141+1),AF141/2,AF141)","v":0},{"$f":"IF(P141>0,IF($V141>0,$V141,0),0)","v":0},{"$f":"IF(($AB141+$AD141+$AF141+$AH141)>($V141+1),AH141/2,AH141)","v":0},null,{"$f":"IF($A141=AK$6,+$J141+$L141+$N141+$P141,\"\")","v":""},"","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,null,null,null,null,{"$f":"IFERROR(I142+K142+M142+O142+Q142+S142+U142,0)","v":1},{"$f":"SUM(H138:H141)","v":9570000},{"$f":"J142/$H142","v":0.66136363636363638},{"$f":"SUM(J138:J141)","v":6329250},{"$f":"L142/$H142","v":0},{"$f":"SUM(L138:L141)","v":0},{"$f":"N142/$H142","v":0},{"$f":"SUM(N138:N141)","v":0},{"$f":"P142/$H142","v":0},{"$f":"SUM(P138:P141)","v":0},{"$f":"R142/$H142","v":0.33863636363636362},{"$f":"SUM(R138:R141)","v":3240750},{"$f":"T142/$H142","v":0},{"$f":"SUM(T138:T141)","v":0},null,{"$f":"SUM(V138:V141)","v":2109750}]
[null,null,null,null,null,""]
[null,11,"Kloak og Dræn",null,null,null,{"$f":"I144+K144+M144+O144+Q144+S144+U144","v":0},{"$f":"E144*F144","v":0},null,{"$f":"IF(I144=0,0,SUM($H144*I144))","v":0},null,{"$f":"IF(K144=0,0,SUM($H144*K144))","v":0},null,{"$f":"IF(M144=0,0,SUM($H144*M144))","v":0},null,{"$f":"IF(O144=0,0,SUM($H144*O144))","v":0},null,{"$f":"IF(Q144=0,0,SUM($H144*Q144))","v":0},null,{"$f":"IF(S144=0,0,SUM($H144*S144))","v":0},null,{"$f":"IF(S144+Q144>0.5,0,IF(Q144<0.51,IF(S144<0.51,+R144+T144,+R144),IF(S144<0.51,T144,0)))","v":0},null,null,null,null,null,{"$f":"IF(J144>0,IF($V144>0,$V144,0),0)","v":0},{"$f":"IF(($AB144+$AD144+$AF144+$AH144)>($V144+1),AB144/2,AB144)","v":0},{"$f":"IF(L144>0,IF($V144>0,$V144,0),0)","v":0},{"$f":"IF(($AB144+$AD144+$AF144+$AH144)>($V144+1),AD144/2,AD144)","v":0},{"$f":"IF(N144>0,IF($V144>0,$V144,0),0)","v":0},{"$f":"IF(($AB144+$AD144+$AF144+$AH144)>($V144+1),AF144/2,AF144)","v":0},{"$f":"IF(P144>0,IF($V144>0,$V144,0),0)","v":0},{"$f":"IF(($AB144+$AD144+$AF144+$AH144)>($V144+1),AH144/2,AH144)","v":0},null,{"$f":"IF($A144=AK$6,+$J144+$L144+$N144+$P144,\"\")","v":""},{"$f":"IF($A144=AL$6,+$J144+$L144+$N144+$P144,\"\")","v":""},"","","","","","","","","",null,null,null,{"$f":"IF($A144=AY$6,+$R144+$T144,\"\")","v":""},"","","","","","","","","",""]
[9,null,"Udskiftning og rep. af eksisterende kloaksystem","stk.",5,400000,{"$f":"I145+K145+M145+O145+Q145+S145+U145","v":1},{"$f":"E145*F145","v":2000000},null,{"$f":"IF(I145=0,0,SUM($H145*I145))","v":0},null,{"$f":"IF(K145=0,0,SUM($H145*K145))","v":0},null,{"$f":"IF(M145=0,0,SUM($H145*M145))","v":0},null,{"$f":"IF(O145=0,0,SUM($H145*O145))","v":0},null,{"$f":"IF(Q145=0,0,SUM($H145*Q145))","v":0},1,{"$f":"IF(S145=0,0,SUM($H145*S145))","v":2000000},null,{"$f":"IF(S145+Q145>0.5,0,IF(Q145<0.51,IF(S145<0.51,+R145+T145,+R145),IF(S145<0.51,T145,0)))","v":0},null,null,null,null,null,{"$f":"IF(J145>0,IF($V145>0,$V145,0),0)","v":0},{"$f":"IF(($AB145+$AD145+$AF145+$AH145)>($V145+1),AB145/2,AB145)","v":0},{"$f":"IF(L145>0,IF($V145>0,$V145,0),0)","v":0},{"$f":"IF(($AB145+$AD145+$AF145+$AH145)>($V145+1),AD145/2,AD145)","v":0},{"$f":"IF(N145>0,IF($V145>0,$V145,0),0)","v":0},{"$f":"IF(($AB145+$AD145+$AF145+$AH145)>($V145+1),AF145/2,AF145)","v":0},{"$f":"IF(P145>0,IF($V145>0,$V145,0),0)","v":0},{"$f":"IF(($AB145+$AD145+$AF145+$AH145)>($V145+1),AH145/2,AH145)","v":0},null,"","","","","","","","",0,"","",null,null,null,"","","","","","","","",2000000,"",""]
[9,null,"Etablering af LAR","stk.",5,300000,1,1500000,null,0,null,0,null,0,null,0,1,1500000,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","",0,"","",null,null,null,"","","","","","","","",1500000,"",""]
[null,null,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,null,null,null,null,{"$f":"IFERROR(I148+K148+M148+O148+Q148+S148+U148,0)","v":1},{"$f":"SUM(H144:H147)","v":3500000},{"$f":"J148/$H148","v":0},{"$f":"SUM(J144:J147)","v":0},{"$f":"L148/$H148","v":0},{"$f":"SUM(L144:L147)","v":0},{"$f":"N148/$H148","v":0},{"$f":"SUM(N144:N147)","v":0},{"$f":"P148/$H148","v":0},{"$f":"SUM(P144:P147)","v":0},{"$f":"R148/$H148","v":0.42857142857142855},{"$f":"SUM(R144:R147)","v":1500000},{"$f":"T148/$H148","v":0.5714285714285714},{"$f":"SUM(T144:T147)","v":2000000},null,{"$f":"SUM(V144:V147)","v":0}]
[null,null,null,null,null,""]
[null,12,"Udearealer samlet",null,null,null,{"$f":"I150+K150+M150+O150+Q150+S150+U150","v":0},{"$f":"E150*F150","v":0},null,{"$f":"IF(I150=0,0,SUM($H150*I150))","v":0},null,{"$f":"IF(K150=0,0,SUM($H150*K150))","v":0},null,{"$f":"IF(M150=0,0,SUM($H150*M150))","v":0},null,{"$f":"IF(O150=0,0,SUM($H150*O150))","v":0},null,{"$f":"IF(Q150=0,0,SUM($H150*Q150))","v":0},null,{"$f":"IF(S150=0,0,SUM($H150*S150))","v":0},null,{"$f":"IF(S150+Q150>0.5,0,IF(Q150<0.51,IF(S150<0.51,+R150+T150,+R150),IF(S150<0.51,T150,0)))","v":0},null,null,null,null,null,{"$f":"IF(J150>0,IF($V150>0,$V150,0),0)","v":0},{"$f":"IF(($AB150+$AD150+$AF150+$AH150)>($V150+1),AB150/2,AB150)","v":0},{"$f":"IF(L150>0,IF($V150>0,$V150,0),0)","v":0},{"$f":"IF(($AB150+$AD150+$AF150+$AH150)>($V150+1),AD150/2,AD150)","v":0},{"$f":"IF(N150>0,IF($V150>0,$V150,0),0)","v":0},{"$f":"IF(($AB150+$AD150+$AF150+$AH150)>($V150+1),AF150/2,AF150)","v":0},{"$f":"IF(P150>0,IF($V150>0,$V150,0),0)","v":0},{"$f":"IF(($AB150+$AD150+$AF150+$AH150)>($V150+1),AH150/2,AH150)","v":0},null,{"$f":"IF($A150=AK$6,+$J150+$L150+$N150+$P150,\"\")","v":""},{"$f":"IF($A150=AL$6,+$J150+$L150+$N150+$P150,\"\")","v":""},"","","","","","","","","",null,null,null,{"$f":"IF($A150=AY$6,+$R150+$T150,\"\")","v":""},"","","","","","","","","",""]
[10,null,"Retablering af terræn og beplantning efter renovering","stk.",1,1100000,{"$f":"I151+K151+M151+O151+Q151+S151+U151","v":1},{"$f":"E151*F151","v":1100000},0.75,{"$f":"IF(I151=0,0,SUM($H151*I151))","v":825000},null,{"$f":"IF(K151=0,0,SUM($H151*K151))","v":0},null,{"$f":"IF(M151=0,0,SUM($H151*M151))","v":0},null,{"$f":"IF(O151=0,0,SUM($H151*O151))","v":0},null,{"$f":"IF(Q151=0,0,SUM($H151*Q151))","v":0},0.25,{"$f":"IF(S151=0,0,SUM($H151*S151))","v":275000},null,{"$f":"IF(S151+Q151>0.5,0,IF(Q151<0.51,IF(S151<0.51,+R151+T151,+R151),IF(S151<0.51,T151,0)))","v":275000},null,null,null,null,null,{"$f":"IF(J151>0,IF($V151>0,$V151,0),0)","v":275000},{"$f":"IF(($AB151+$AD151+$AF151+$AH151)>($V151+1),AB151/2,AB151)","v":275000},{"$f":"IF(L151>0,IF($V151>0,$V151,0),0)","v":0},{"$f":"IF(($AB151+$AD151+$AF151+$AH151)>($V151+1),AD151/2,AD151)","v":0},{"$f":"IF(N151>0,IF($V151>0,$V151,0),0)","v":0},{"$f":"IF(($AB151+$AD151+$AF151+$AH151)>($V151+1),AF151/2,AF151)","v":0},{"$f":"IF(P151>0,IF($V151>0,$V151,0),0)","v":0},{"$f":"IF(($AB151+$AD151+$AF151+$AH151)>($V151+1),AH151/2,AH151)","v":0},null,"","","","","","","","","",825000,"",null,null,null,"","","","","","","","","",275000,""]
[10,null,"Indretning af pladser for ophold, leg og aktiviteter","stk.",8,260000,1,2080000,null,0,1,2080000,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","",2080000,"",null,null,null,"","","","","","","","","",0,""]
[10,null,"private haver til boliger stueetage","stk.",58,15000,1,870000,null,0,1,870000,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","",870000,"",null,null,null,"","","","","","","","","",0,""]
[10,null,"Ramper i terræn for tilgængelighed","stk.",4,75000,1,300000,null,0,null,0,null,0,1,300000,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","",300000,"",null,null,null,"","","","","","","","","",0,""]
[10,null,"Ændringer og forbedring af p-pladsen","stk.",3,600000,{"$f":"I155+K155+M155+O155+Q155+S155+U155","v":1},{"$f":"E155*F155","v":1800000},null,{"$f":"IF(I155=0,0,SUM($H155*I155))","v":0},null,{"$f":"IF(K155=0,0,SUM($H155*K155))","v":0},null,{"$f":"IF(M155=0,0,SUM($H155*M155))","v":0},null,{"$f":"IF(O155=0,0,SUM($H155*O155))","v":0},0.5,{"$f":"IF(Q155=0,0,SUM($H155*Q155))","v":900000},0.5,{"$f":"IF(S155=0,0,SUM($H155*S155))","v":900000},null,{"$f":"IF(S155+Q155>0.5,0,IF(Q155<0.51,IF(S155<0.51,+R155+T155,+R155),IF(S155<0.51,T155,0)))","v":0},null,null,null,null,null,{"$f":"IF(J155>0,IF($V155>0,$V155,0),0)","v":0},{"$f":"IF(($AB155+$AD155+$AF155+$AH155)>($V155+1),AB155/2,AB155)","v":0},{"$f":"IF(L155>0,IF($V155>0,$V155,0),0)","v":0},{"$f":"IF(($AB155+$AD155+$AF155+$AH155)>($V155+1),AD155/2,AD155)","v":0},{"$f":"IF(N155>0,IF($V155>0,$V155,0),0)","v":0},{"$f":"IF(($AB155+$AD155+$AF155+$AH155)>($V155+1),AF155/2,AF155)","v":0},{"$f":"IF(P155>0,IF($V155>0,$V155,0),0)","v":0},{"$f":"IF(($AB155+$AD155+$AF155+$AH155)>($V155+1),AH155/2,AH155)","v":0},null,"","","","","","","","","",0,"",null,null,null,"","","","","","","","","",1800000,""]
[10,null,"Omlægning af belægninger","stk.",1,750000,1,750000,null,0,null,0,null,0,null,0,null,0,1,750000,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","",0,"",null,null,null,"","","","","","","","","",750000,""]
[10,null,"Kriminalpræventiv belysning","stk.",1,550000,{"$f":"I157+K157+M157+O157+Q157+S157+U157","v":1},{"$f":"E157*F157","v":550000},null,{"$f":"IF(I157=0,0,SUM($H157*I157))","v":0},1,{"$f":"IF(K157=0,0,SUM($H157*K157))","v":550000},null,{"$f":"IF(M157=0,0,SUM($H157*M157))","v":0},null,{"$f":"IF(O157=0,0,SUM($H157*O157))","v":0},null,{"$f":"IF(Q157=0,0,SUM($H157*Q157))","v":0},null,{"$f":"IF(S157=0,0,SUM($H157*S157))","v":0},null,{"$f":"IF(S157+Q157>0.5,0,IF(Q157<0.51,IF(S157<0.51,+R157+T157,+R157),IF(S157<0.51,T157,0)))","v":0},null,null,null,null,null,{"$f":"IF(J157>0,IF($V157>0,$V157,0),0)","v":0},{"$f":"IF(($AB157+$AD157+$AF157+$AH157)>($V157+1),AB157/2,AB157)","v":0},{"$f":"IF(L157>0,IF($V157>0,$V157,0),0)","v":0},{"$f":"IF(($AB157+$AD157+$AF157+$AH157)>($V157+1),AD157/2,AD157)","v":0},{"$f":"IF(N157>0,IF($V157>0,$V157,0),0)","v":0},{"$f":"IF(($AB157+$AD157+$AF157+$AH157)>($V157+1),AF157/2,AF157)","v":0},{"$f":"IF(P157>0,IF($V157>0,$V157,0),0)","v":0},{"$f":"IF(($AB157+$AD157+$AF157+$AH157)>($V157+1),AH157/2,AH157)","v":0},null,"","","","","","","","","",550000,"",null,null,null,"","","","","","","","","",0,""]
[null,null,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,null,null,null,null,{"$f":"IFERROR(I159+K159+M159+O159+Q159+S159+U159,0)","v":1},{"$f":"SUM(H150:H158)","v":7450000},{"$f":"J159/$H159","v":0.11073825503355705},{"$f":"SUM(J150:J158)","v":825000},{"$f":"L159/$H159","v":0.46979865771812079},{"$f":"SUM(L150:L158)","v":3500000},{"$f":"N159/$H159","v":0},{"$f":"SUM(N150:N158)","v":0},{"$f":"P159/$H159","v":4.0268456375838924E-2},{"$f":"SUM(P150:P158)","v":300000},{"$f":"R159/$H159","v":0.12080536912751678},{"$f":"SUM(R150:R158)","v":900000},{"$f":"T159/$H159","v":0.25838926174496646},{"$f":"SUM(T150:T158)","v":1925000},null,{"$f":"SUM(V150:V158)","v":275000}]
[null,null,null,null,null,""]
[null,13,"Fælleslokale",null,null,null,{"$f":"I161+K161+M161+O161+Q161+S161+U161","v":0},{"$f":"E161*F161","v":0},null,{"$f":"IF(I161=0,0,SUM($H161*I161))","v":0},null,{"$f":"IF(K161=0,0,SUM($H161*K161))","v":0},null,{"$f":"IF(M161=0,0,SUM($H161*M161))","v":0},null,{"$f":"IF(O161=0,0,SUM($H161*O161))","v":0},null,{"$f":"IF(Q161=0,0,SUM($H161*Q161))","v":0},null,{"$f":"IF(S161=0,0,SUM($H161*S161))","v":0},null,{"$f":"IF(S161+Q161>0.5,0,IF(Q161<0.51,IF(S161<0.51,+R161+T161,+R161),IF(S161<0.51,T161,0)))","v":0},null,null,null,null,null,{"$f":"IF(J161>0,IF($V161>0,$V161,0),0)","v":0},{"$f":"IF(($AB161+$AD161+$AF161+$AH161)>($V161+1),AB161/2,AB161)","v":0},{"$f":"IF(L161>0,IF($V161>0,$V161,0),0)","v":0},{"$f":"IF(($AB161+$AD161+$AF161+$AH161)>($V161+1),AD161/2,AD161)","v":0},{"$f":"IF(N161>0,IF($V161>0,$V161,0),0)","v":0},{"$f":"IF(($AB161+$AD161+$AF161+$AH161)>($V161+1),AF161/2,AF161)","v":0},{"$f":"IF(P161>0,IF($V161>0,$V161,0),0)","v":0},{"$f":"IF(($AB161+$AD161+$AF161+$AH161)>($V161+1),AH161/2,AH161)","v":0},null,{"$f":"IF($A161=AK$6,+$J161+$L161+$N161+$P161,\"\")","v":""},{"$f":"IF($A161=AL$6,+$J161+$L161+$N161+$P161,\"\")","v":""},"","","","","","","","","",null,null,null,{"$f":"IF($A161=AY$6,+$R161+$T161,\"\")","v":""},"","","","","","","","","",""]
[11,null,"Indretning af fælleslokaler i gl. servicebygning","stk.",1,550000,{"$f":"I162+K162+M162+O162+Q162+S162+U162","v":1},{"$f":"E162*F162","v":550000},null,{"$f":"IF(I162=0,0,SUM($H162*I162))","v":0},1,{"$f":"IF(K162=0,0,SUM($H162*K162))","v":550000},null,{"$f":"IF(M162=0,0,SUM($H162*M162))","v":0},null,{"$f":"IF(O162=0,0,SUM($H162*O162))","v":0},null,{"$f":"IF(Q162=0,0,SUM($H162*Q162))","v":0},null,{"$f":"IF(S162=0,0,SUM($H162*S162))","v":0},null,{"$f":"IF(S162+Q162>0.5,0,IF(Q162<0.51,IF(S162<0.51,+R162+T162,+R162),IF(S162<0.51,T162,0)))","v":0},null,null,null,null,null,{"$f":"IF(J162>0,IF($V162>0,$V162,0),0)","v":0},{"$f":"IF(($AB162+$AD162+$AF162+$AH162)>($V162+1),AB162/2,AB162)","v":0},{"$f":"IF(L162>0,IF($V162>0,$V162,0),0)","v":0},{"$f":"IF(($AB162+$AD162+$AF162+$AH162)>($V162+1),AD162/2,AD162)","v":0},{"$f":"IF(N162>0,IF($V162>0,$V162,0),0)","v":0},{"$f":"IF(($AB162+$AD162+$AF162+$AH162)>($V162+1),AF162/2,AF162)","v":0},{"$f":"IF(P162>0,IF($V162>0,$V162,0),0)","v":0},{"$f":"IF(($AB162+$AD162+$AF162+$AH162)>($V162+1),AH162/2,AH162)","v":0},null,"","","","","","","","","","",550000,null,null,null,"","","","","","","","","","",0]
[null,null,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,null,null,null,null,{"$f":"IFERROR(I164+K164+M164+O164+Q164+S164+U164,0)","v":1},{"$f":"SUM(H161:H163)","v":550000},{"$f":"J164/$H164","v":0},{"$f":"SUM(J161:J163)","v":0},{"$f":"L164/$H164","v":1},{"$f":"SUM(L161:L163)","v":550000},{"$f":"N164/$H164","v":0},{"$f":"SUM(N161:N163)","v":0},{"$f":"P164/$H164","v":0},{"$f":"SUM(P161:P163)","v":0},{"$f":"R164/$H164","v":0},{"$f":"SUM(R161:R163)","v":0},{"$f":"T164/$H164","v":0},{"$f":"SUM(T161:T163)","v":0},null,{"$f":"SUM(V161:V163)","v":0}]
[null,null,null,null,null,""]
[null,14,"Servicebygning mv.",null,null,null,{"$f":"I166+K166+M166+O166+Q166+S166+U166","v":0},{"$f":"E166*F166","v":0},null,{"$f":"IF(I166=0,0,SUM($H166*I166))","v":0},null,{"$f":"IF(K166=0,0,SUM($H166*K166))","v":0},null,{"$f":"IF(M166=0,0,SUM($H166*M166))","v":0},null,{"$f":"IF(O166=0,0,SUM($H166*O166))","v":0},null,{"$f":"IF(Q166=0,0,SUM($H166*Q166))","v":0},null,{"$f":"IF(S166=0,0,SUM($H166*S166))","v":0},null,{"$f":"IF(S166+Q166>0.5,0,IF(Q166<0.51,IF(S166<0.51,+R166+T166,+R166),IF(S166<0.51,T166,0)))","v":0},null,null,null,null,null,{"$f":"IF(J166>0,IF($V166>0,$V166,0),0)","v":0},{"$f":"IF(($AB166+$AD166+$AF166+$AH166)>($V166+1),AB166/2,AB166)","v":0},{"$f":"IF(L166>0,IF($V166>0,$V166,0),0)","v":0},{"$f":"IF(($AB166+$AD166+$AF166+$AH166)>($V166+1),AD166/2,AD166)","v":0},{"$f":"IF(N166>0,IF($V166>0,$V166,0),0)","v":0},{"$f":"IF(($AB166+$AD166+$AF166+$AH166)>($V166+1),AF166/2,AF166)","v":0},{"$f":"IF(P166>0,IF($V166>0,$V166,0),0)","v":0},{"$f":"IF(($AB166+$AD166+$AF166+$AH166)>($V166+1),AH166/2,AH166)","v":0},null,{"$f":"IF($A166=AK$6,+$J166+$L166+$N166+$P166,\"\")","v":""},{"$f":"IF($A166=AL$6,+$J166+$L166+$N166+$P166,\"\")","v":""},"","","","","","","","","",null,null,null,{"$f":"IF($A166=AY$6,+$R166+$T166,\"\")","v":""},"","","","","","","","","",""]
[11,null,"Etablering af ny servicebygning","stk.",1,1300000,{"$f":"I167+K167+M167+O167+Q167+S167+U167","v":1},{"$f":"E167*F167","v":1300000},null,{"$f":"IF(I167=0,0,SUM($H167*I167))","v":0},null,{"$f":"IF(K167=0,0,SUM($H167*K167))","v":0},null,{"$f":"IF(M167=0,0,SUM($H167*M167))","v":0},null,{"$f":"IF(O167=0,0,SUM($H167*O167))","v":0},1,{"$f":"IF(Q167=0,0,SUM($H167*Q167))","v":1300000},null,{"$f":"IF(S167=0,0,SUM($H167*S167))","v":0},null,{"$f":"IF(S167+Q167>0.5,0,IF(Q167<0.51,IF(S167<0.51,+R167+T167,+R167),IF(S167<0.51,T167,0)))","v":0},null,null,null,null,null,{"$f":"IF(J167>0,IF($V167>0,$V167,0),0)","v":0},{"$f":"IF(($AB167+$AD167+$AF167+$AH167)>($V167+1),AB167/2,AB167)","v":0},{"$f":"IF(L167>0,IF($V167>0,$V167,0),0)","v":0},{"$f":"IF(($AB167+$AD167+$AF167+$AH167)>($V167+1),AD167/2,AD167)","v":0},{"$f":"IF(N167>0,IF($V167>0,$V167,0),0)","v":0},{"$f":"IF(($AB167+$AD167+$AF167+$AH167)>($V167+1),AF167/2,AF167)","v":0},{"$f":"IF(P167>0,IF($V167>0,$V167,0),0)","v":0},{"$f":"IF(($AB167+$AD167+$AF167+$AH167)>($V167+1),AH167/2,AH167)","v":0},null,"","","","","","","","","","",0,null,null,null,"","","","","","","","","","",1300000]
[11,null,"Etablering af miljøstationer","stk.",8,45000,1,360000,null,0,null,0,null,0,null,0,1,360000,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","",0,null,null,null,"","","","","","","","","","",360000]
[null,null,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,null,null,null,null,{"$f":"IFERROR(I170+K170+M170+O170+Q170+S170+U170,0)","v":1},{"$f":"SUM(H166:H169)","v":1660000},{"$f":"J170/$H170","v":0},{"$f":"SUM(J166:J169)","v":0},{"$f":"L170/$H170","v":0},{"$f":"SUM(L166:L169)","v":0},{"$f":"N170/$H170","v":0},{"$f":"SUM(N166:N169)","v":0},{"$f":"P170/$H170","v":0},{"$f":"SUM(P166:P169)","v":0},{"$f":"R170/$H170","v":1},{"$f":"SUM(R166:R169)","v":1660000},{"$f":"T170/$H170","v":0},{"$f":"SUM(T166:T169)","v":0},null,{"$f":"SUM(V166:V169)","v":0}]
[null,null,null,null,null,""]
[null,15,"Emne",null,null,null,{"$f":"I172+K172+M172+O172+Q172+S172+U172","v":0},{"$f":"E172*F172","v":0},null,{"$f":"IF(I172=0,0,SUM($H172*I172))","v":0},null,{"$f":"IF(K172=0,0,SUM($H172*K172))","v":0},null,{"$f":"IF(M172=0,0,SUM($H172*M172))","v":0},null,{"$f":"IF(O172=0,0,SUM($H172*O172))","v":0},null,{"$f":"IF(Q172=0,0,SUM($H172*Q172))","v":0},null,{"$f":"IF(S172=0,0,SUM($H172*S172))","v":0},null,{"$f":"IF(S172+Q172>0.5,0,IF(Q172<0.51,IF(S172<0.51,+R172+T172,+R172),IF(S172<0.51,T172,0)))","v":0},null,null,null,null,null,{"$f":"IF(J172>0,IF($V172>0,$V172,0),0)","v":0},{"$f":"IF(($AB172+$AD172+$AF172+$AH172)>($V172+1),AB172/2,AB172)","v":0},{"$f":"IF(L172>0,IF($V172>0,$V172,0),0)","v":0},{"$f":"IF(($AB172+$AD172+$AF172+$AH172)>($V172+1),AD172/2,AD172)","v":0},{"$f":"IF(N172>0,IF($V172>0,$V172,0),0)","v":0},{"$f":"IF(($AB172+$AD172+$AF172+$AH172)>($V172+1),AF172/2,AF172)","v":0},{"$f":"IF(P172>0,IF($V172>0,$V172,0),0)","v":0},{"$f":"IF(($AB172+$AD172+$AF172+$AH172)>($V172+1),AH172/2,AH172)","v":0},null,{"$f":"IF($A172=AK$6,+$J172+$L172+$N172+$P172,\"\")","v":""},{"$f":"IF($A172=AL$6,+$J172+$L172+$N172+$P172,\"\")","v":""},"","","","","","","","","",null,null,null,{"$f":"IF($A172=AY$6,+$R172+$T172,\"\")","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,{"$f":"I173+K173+M173+O173+Q173+S173+U173","v":0},{"$f":"E173*F173","v":0},null,{"$f":"IF(I173=0,0,SUM($H173*I173))","v":0},null,{"$f":"IF(K173=0,0,SUM($H173*K173))","v":0},null,{"$f":"IF(M173=0,0,SUM($H173*M173))","v":0},null,{"$f":"IF(O173=0,0,SUM($H173*O173))","v":0},null,{"$f":"IF(Q173=0,0,SUM($H173*Q173))","v":0},null,{"$f":"IF(S173=0,0,SUM($H173*S173))","v":0},null,{"$f":"IF(S173+Q173>0.5,0,IF(Q173<0.51,IF(S173<0.51,+R173+T173,+R173),IF(S173<0.51,T173,0)))","v":0},null,null,null,null,null,{"$f":"IF(J173>0,IF($V173>0,$V173,0),0)","v":0},{"$f":"IF(($AB173+$AD173+$AF173+$AH173)>($V173+1),AB173/2,AB173)","v":0},{"$f":"IF(L173>0,IF($V173>0,$V173,0),0)","v":0},{"$f":"IF(($AB173+$AD173+$AF173+$AH173)>($V173+1),AD173/2,AD173)","v":0},{"$f":"IF(N173>0,IF($V173>0,$V173,0),0)","v":0},{"$f":"IF(($AB173+$AD173+$AF173+$AH173)>($V173+1),AF173/2,AF173)","v":0},{"$f":"IF(P173>0,IF($V173>0,$V173,0),0)","v":0},{"$f":"IF(($AB173+$AD173+$AF173+$AH173)>($V173+1),AH173/2,AH173)","v":0},null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,null,null,null,null,0,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"","","","","","","","","","","",null,null,null,"","","","","","","","","","",""]
[null,null,null,null,null,null,{"$f":"IFERROR(I175+K175+M175+O175+Q175+S175+U175,0)","v":0},{"$f":"SUM(H172:H174)","v":0},{"$f":"J175/$H175","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J172:J174)","v":0},{"$f":"L175/$H175","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L172:L174)","v":0},{"$f":"N175/$H175","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N172:N174)","v":0},{"$f":"P175/$H175","v":{"$error":"#DIV/0!"}},{"$f":"SUM(P172:P174)","v":0},{"$f":"R175/$H175","v":{"$error":"#DIV/0!"}},{"$f":"SUM(R172:R174)","v":0},{"$f":"T175/$H175","v":{"$error":"#DIV/0!"}},{"$f":"SUM(T172:T174)","v":0},null,{"$f":"SUM(V172:V174)","v":0}]
[null,null,null,null,null,""]
[]
[null,null,"Håndværkerudgift i alt inkl. moms",null,null,null,null,{"$f":"SUM(H7:H176)/2","v":102593465},null,{"$f":"SUM(J7:J176)/2","v":16451837.5},null,{"$f":"SUM(L7:L176)/2","v":4050000},null,{"$f":"SUM(N7:N176)/2","v":1061280},null,{"$f":"SUM(P7:P176)/2","v":9790480},null,{"$f":"SUM(R7:R176)/2","v":56593015},null,{"$f":"SUM(T7:T176)/2","v":14244852.5},null,{"$f":"SUM(V7:V176)/2","v":8753990},{"$f":"J178+L178+N178+P178","v":31353597.5},{"$f":"R178+T178","v":70837867.5}]
[null,null,"Byggepladsomkostninger og vinterforanstaltninger %",0.06,null,null,null,{"$f":"H178*D179","v":6155607.8999999994},null,{"$f":"J178*$D179","v":987110.25},null,{"$f":"L178*$D179","v":243000},null,{"$f":"N178*$D179","v":63676.799999999996},null,{"$f":"P178*$D179","v":587428.79999999993},null,{"$f":"R178*$D179","v":3395580.9},null,{"$f":"T178*$D179","v":854691.15},null,{"$f":"V178*$D179","v":525239.4}]
[null,null,"Håndværkerudgift i alt inkl. byggeplads og moms",null,null,null,null,{"$f":"SUM(H178:H179)","v":108749072.90000001},null,{"$f":"SUM(J178:J179)","v":17438947.75},null,{"$f":"SUM(L178:L179)","v":4293000},null,{"$f":"SUM(N178:N179)","v":1124956.8},null,{"$f":"SUM(P178:P179)","v":10377908.800000001},null,{"$f":"SUM(R178:R179)","v":59988595.899999999},null,{"$f":"SUM(T178:T179)","v":15099543.65},null,{"$f":"SUM(V178:V179)","v":9279229.4000000004}]
[]
[null,null,"Omkostninger % (skal detaljeres inden skema A)",0.19,null,null,null,{"$f":"H180*D182","v":20662323.851},null,{"$f":"J180*$D182","v":3313400.0725000002},null,{"$f":"L180*$D182","v":815670},null,{"$f":"N180*$D182","v":213741.79200000002},null,{"$f":"P180*$D182","v":1971802.6720000003},null,{"$f":"R180*$D182","v":11397833.220999999},null,{"$f":"T180*$D182","v":2868913.2935000001},null,{"$f":"V180*$D182","v":1763053.5860000001}]
[null,null,"Driftsudgifter i byggeperioden",null,null,null,null,100000,null,{"$f":"IFERROR($H183*J180/($J180+$N180+$P180),0)","v":60255.200802751358},null,null,null,{"$f":"IFERROR($H183*N180/($J180+$N180+$P180),0)","v":3886.9603172255961},null,{"$f":"IFERROR($H183*P180/($J180+$N180+$P180),0)","v":35857.838880023046},null,null,null,null,null,{"$f":"IF(U183=0,0,SUM($H183*U183))","v":0}]
[]
[null,null,"Totalsum samt summer af kategorier",null,null,null,{"$f":"IFERROR(I185+K185+M185+O185+Q185+S185+U185,0)","v":0.9960846472764483},{"$f":"SUM(H180:H183)","v":129511396.751},{"$f":"IFERROR(J185/$H185,0)","v":0.16070093864648288},{"$f":"SUM(J180:J183)","v":20812603.023302753},{"$f":"IFERROR(L185/$H185,0)","v":3.9445717737273608E-2},{"$f":"SUM(L180:L183)","v":5108670},{"$f":"IFERROR(N185/$H185,0)","v":1.0366543686487262E-2},{"$f":"SUM(N180:N183)","v":1342585.5523172258},{"$f":"IFERROR(P185/$H185,0)","v":9.5633045597467006E-2},{"$f":"SUM(P180:P183)","v":12385569.310880024},{"$f":"IFERROR(R185/$H185,0)","v":0.55119804829414587},{"$f":"SUM(R180:R183)","v":71386429.120999992},{"$f":"IFERROR(T185/$H185,0)","v":0.13874035331459167},{"$f":"SUM(T180:T183)","v":17968456.943500001},null,{"$f":"SUM(V180:V183)","v":11042282.986000001},{"$f":"SUM(J185:T185)","v":129004314.7863837}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+V185/V178","v":1.2614000000000001}]
[]
[null,null,"Nødvendige ustøttede arbejder (Indgår ikke i støttet sum)",null,null,null,null,null,null,{"$f":"IFERROR(AC6*$W186,0)","v":7908662.6500000004},null,{"$f":"IFERROR(AE6*$W186,0)","v":0},null,{"$f":"IFERROR(AG6*$W186,0)","v":659359.00800000003},null,{"$f":"IFERROR(AI6*$W186,0)","v":2474261.3280000002},null,null,null,null,null,null,{"$f":"SUM(J188:P188)","v":11042282.986}]
[]
[]
[null,null,"Yderligere støttede arbejder"]
[null,null,"Nedrivning (fra specifikation herunder)",null,null,null,null,{"$f":"H216","v":3000000}]
[null,null,"Miljø og Klimavenlige løsninger (fra specifikation herunder)",null,null,null,null,{"$f":"H225","v":0}]
[null,null,"Genhusning (antal boliger x enhedspris)","bolig",180,50000,null,{"$f":"E194*F194","v":9000000}]
[null,null,"Lejetab (antal boliger x gns. husleje x mdr.)","bolig",180,20000,null,{"$f":"E195*F195","v":3600000}]
[]
[null,null,"Støttet sum - Inkl. Nedrivning, Miljø og Klimavenlige løsninger, Genhusning, lejetab - excl. nødvendige ustøttede arbejder","bolig",180,{"$f":"IFERROR(H197/E197,0)","v":306941.2660361111},null,{"$f":"+J185+L185+N185+P185+SUM(H192:H195)","v":55249427.886500001}]
[]
[]
[null,null,"Samlede udgifter - ustøttede arbejder","bolig",{"$f":"E197","v":180},{"$f":"IFERROR(H200/E200,0)","v":496416.03369166661},null,{"$f":"+R185+T185","v":89354886.064499989}]
[]
[]
[]
[null,null,"Samlede udgifter - støttede og ustøttede arbejder","bolig",{"$f":"E197","v":180},{"$f":"IFERROR(H204/E204,0)","v":803357.2997277776},null,{"$f":"+H197+H200","v":144604313.95099998}]
[]
[]
[null,"Specifikationer til yderligere støttede arbejder"]
[]
["BSF",40,"Nedrivning (kun ved fjernelse af bygninger efter aftale med LBF)","Enh.","Antal","Enh.pris inkl. moms",null,"Total inkl. moms"]
[null,null,"Nedrivning af bygning(er) / boliger ",null,null,null,null,{"$f":"E210*F210","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($A210=AK$6,+$H210,\"\")","v":""},{"$f":"IF($A210=AL$6,+$H210,\"\")","v":""},"","","","","","","","",""]
[10,null,"6 boliger fjernes","bolig",6,350000,null,{"$f":"E211*F211","v":2100000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($A211=AK$6,+$H211,\"\")","v":""},"","","","","","","","",2100000,""]
[10,null,"Håndtering af miljøfremmede stoffer","bolig",6,10000,null,60000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",60000,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","",""]
[10,null,"Oprydning af grund","bolig",6,40000,null,240000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",240000,""]
[null,null,"Andel af byggeplads og omkostninger",null,null,null,null,{"$f":"(H210+H211+H212+H213+H214)*($D$179+$D$182)","v":600000}]
[null,null,"SUM",null,null,null,null,{"$f":"SUM(H210:H215)","v":3000000}]
[]
["BSF",41,"Miljø og Klimavenlige løsninger (Bæredygtighedspulje efter ansøgning)","Enh.","Antal","Enh.pris inkl. moms",null,"Total inkl. moms"]
[null,null,"Beskrivelse ",null,null,null,null,{"$f":"E219*F219","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($A219=AK$6,+$H219,\"\")","v":""},"","","","","","","","","",""]
[null,null,"xxxxxxxxxxxxxxxxxxxxx",null,null,null,null,{"$f":"E220*F220","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","",""]
[null,null,"xxxxxxxxxxxxxxxxxxxxxxxxx",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","",""]
[null,null,"xxxxxxxxxxxxxxxxxxx",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","",""]
[null,null,"xxxxxxxxxxxxxxxxxxxxxxxxx",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","",""]
[null,null,"Andel af byggeplads og omkostninger ",null,null,null,null,{"$f":"(H219+H220+H221+H222+H223)*($D$179+$D$182)","v":0}]
[null,null,"SUM",null,null,null,null,{"$f":"SUM(H219:H224)","v":0}]
[]
[null,"Støttede arbejder"]
[]
[null,"Håndværkerudgifter fordelt på bygningsdele (til Bossinf Skema A)"]
[]
[null,{"$f":"AK5&\" I ALT:\"","v":"BSF-håndværkerudgifter I ALT:"}]
[null,null,{"$f":"AV4","v":33753597.5}]
[]
[null,1,"Tag",{"$f":"$AK$4","v":6131587.5}]
[null,2,"Ydervægge",{"$f":"$AL$4","v":1965580}]
[null,3,"Døre og vinduer",{"$f":"$AM$4","v":469670}]
[null,4,"Altaner og altangange",{"$f":"$AN$4","v":1098000}]
[null,5,"Etageadskillelser",{"$f":"$AO$4","v":0}]
[null,6,"Fundament og kælder",{"$f":"$AP$4","v":2100000}]
[null,7,"Vådrum",{"$f":"$AQ$4","v":1417500}]
[null,8,"Afløb i jord og bygninger",{"$f":"$AR$4","v":0}]
[null,9,"Installationer (inkl. elevatorer)",{"$f":"$AS$4","v":9730010}]
[null,10,"Øvrige bygningsdele (indv. vægge, køkken mm.)",{"$f":"$AT$4","v":10291250}]
[null,11,"Arealudvidelser (primært fælleshuse)",{"$f":"$AU$4","v":550000}]
[]
[]
[null,"HVU uden BSF-bygningsdele:"]
[null,null,{"$f":"IF(ABS((W178+SUM(H210:H214)+SUM(H219:H223))-C232)<1,\"0\",((W178+SUM(H210:H214)+SUM(H219:H223)-C232)))","v":"0"}]
[]
[]
[null,"Ustøttede arbejder"]
[]
[null,"Håndværkerudgifter fordelt på bygningsdele (til Bossinf Skema A)"]
[]
[null,{"$f":"AY5&\" I ALT:\"","v":"BSF-håndværkerudgifter I ALT:"}]
[null,null,{"$f":"BJ4","v":70837867.5}]
[]
[null,1,"Tag",{"$f":"$AY$4","v":4650912.5}]
[null,2,"Ydervægge",{"$f":"$AZ$4","v":3366920}]
[null,3,"Døre og vinduer",{"$f":"$BA$4","v":4629330}]
[null,4,"Altaner og altangange",{"$f":"$BB$4","v":9000000}]
[null,5,"Etageadskillelser",{"$f":"$BC$4","v":0}]
[null,6,"Fundament og kælder",{"$f":"$BD$4","v":3400000}]
[null,7,"Vådrum",{"$f":"$BE$4","v":9022500}]
[null,8,"Afløb i jord og bygninger",{"$f":"$BF$4","v":0}]
[null,9,"Installationer (inkl. elevatorer)",{"$f":"$BG$4","v":12814455}]
[null,10,"Øvrige bygningsdele (indv. vægge, køkken mm.)",{"$f":"$BH$4","v":22293750}]
[null,11,"Arealudvidelser (primært fælleshuse)",{"$f":"$BI$4","v":1660000}]
[]
[]
[null,"HVU uden BSF-bygningsdele:"]
[null,null,{"$f":"IF(ABS(X178-C256)<1,\"0\",(X178-C256))","v":"0"}]