{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Kostnader for oppussing av bad"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Kostnader for oppussing av bad","index":0,"n_rows":23,"n_cols":10,"rows_kept":23,"merged":[[1,1,2,3],[2,4,2,6],[2,7,2,9],[21,1,21,3],[21,4,21,6],[21,7,21,9],[22,1,22,3],[22,4,22,6],[22,7,22,9]]}
[null,"Arbeidsbok med kostnader for oppussing av bad"]
[null,"OBS! Differansekolonner i tabellen viser om faktisk beløp har overgått estimerte beløp. Røde tall viser overgåtte beløp (negative), og svarte tall viser beløp som er under (positive). "]
[{"$nulls":4},"Spesifiserte kostnader (kr)",null,null,"Totale kostnader (kr)"]
[null,"Område","Artikler","Antall","Beregnet","Faktisk","Differanse","Beregnet ","Faktisk ","Differanse "]
[null,"Bad/dusj","Badekar, støpejern, 5'', standard",1,{"v":250,"d":"kr 250.00"},{"$f":"RANDBETWEEN(E5+2,E5+20)","v":{"v":263,"d":"kr 263.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-13,"d":"-kr 13.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Beregnet]], \"\")","v":{"v":250,"d":"kr 250.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":263,"d":"kr 263.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-13,"d":"-kr 13.00"}}]
[null,"Bad/dusj","Dusjdører, hengslede, standard",1,{"v":200,"d":"kr 200.00"},{"v":216,"d":"kr 216.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-16,"d":"-kr 16.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Beregnet]], \"\")","v":{"v":200,"d":"kr 200.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":216,"d":"kr 216.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-16,"d":"-kr 16.00"}}]
[null,"Bad/dusj","Dusjhode, standard",1,{"v":50,"d":"kr 50.00"},{"v":58,"d":"kr 58.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-8,"d":"-kr 8.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Beregnet]], \"\")","v":{"v":50,"d":"kr 50.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":58,"d":"kr 58.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-8,"d":"-kr 8.00"}}]
[null,"Bad/dusj","Badekarvegg, standard",1,{"v":200,"d":"kr 200.00"},{"v":202,"d":"kr 202.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-2,"d":"-kr 2.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Beregnet]], \"\")","v":{"v":200,"d":"kr 200.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":202,"d":"kr 202.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-2,"d":"-kr 2.00"}}]
[null,"Skap","Medisinskap 24'', deluxe",1,{"v":200,"d":"kr 200.00"},{"v":216,"d":"kr 216.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-16,"d":"-kr 16.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Beregnet]], \"\")","v":{"v":200,"d":"kr 200.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":216,"d":"kr 216.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-16,"d":"-kr 16.00"}}]
[null,"Skap","Dobbel servant 30'', standard",2,{"v":100,"d":"kr 100.00"},{"v":106,"d":"kr 106.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-6,"d":"-kr 6.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Beregnet]], \"\")","v":{"v":200,"d":"kr 200.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":212,"d":"kr 212.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-12,"d":"-kr 12.00"}}]
[null,"Benkeplater","Keramikkflis, deluxe (antall i lineære meter)",5,{"v":22.5,"d":"kr 22.50"},{"v":25,"d":"kr 25.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-2.5,"d":"-kr 2.50"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Beregnet]], \"\")","v":{"v":112.5,"d":"kr 112.50"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":125,"d":"kr 125.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-12.5,"d":"-kr 12.50"}}]
[null,"Kraner","Kran, badekar, standard",1,{"v":90,"d":"kr 90.00"},{"v":101,"d":"kr 101.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-11,"d":"-kr 11.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Beregnet]], \"\")","v":{"v":90,"d":"kr 90.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":101,"d":"kr 101.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-11,"d":"-kr 11.00"}}]
[null,"Kraner","Kran, dusj, enkelt håndtak, standard",1,{"v":115,"d":"kr 115.00"},{"v":125,"d":"kr 125.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-10,"d":"-kr 10.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Beregnet]], \"\")","v":{"v":115,"d":"kr 115.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":125,"d":"kr 125.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-10,"d":"-kr 10.00"}}]
[null,"Kraner","Kran til vask, standard",1,{"v":95,"d":"kr 95.00"},{"v":99,"d":"kr 99.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-4,"d":"-kr 4.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Beregnet]], \"\")","v":{"v":95,"d":"kr 95.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":99,"d":"kr 99.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-4,"d":"-kr 4.00"}}]
[null,"Gulvbelegg","Keramikkflis, standard (antall i kvadratmeter)",35,{"v":12,"d":"kr 12.00"},{"v":17,"d":"kr 17.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-5,"d":"-kr 5.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Beregnet]], \"\")","v":{"v":420,"d":"kr 420.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":595,"d":"kr 595.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-175,"d":"-kr 175.00"}}]
[null,"Metalldeler","Håndkleholder, standard",2,{"v":15,"d":"kr 15.00"},{"v":17,"d":"kr 17.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-2,"d":"-kr 2.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Beregnet]], \"\")","v":{"v":30,"d":"kr 30.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":34,"d":"kr 34.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-4,"d":"-kr 4.00"}}]
[null,"Metalldeler","Toalettpapirholder",1,{"v":10,"d":"kr 10.00"},{"v":29,"d":"kr 29.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-19,"d":"-kr 19.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Beregnet]], \"\")","v":{"v":10,"d":"kr 10.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":29,"d":"kr 29.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-19,"d":"-kr 19.00"}}]
[null,"Belysning","Lysarmatur, standard",4,{"v":25,"d":"kr 25.00"},{"v":37,"d":"kr 37.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-12,"d":"-kr 12.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Beregnet]], \"\")","v":{"v":100,"d":"kr 100.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":148,"d":"kr 148.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-48,"d":"-kr 48.00"}}]
[null,"Vasker","Toalett, standard",2,{"v":60,"d":"kr 60.00"},{"v":63,"d":"kr 63.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-3,"d":"-kr 3.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Beregnet]], \"\")","v":{"v":120,"d":"kr 120.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":126,"d":"kr 126.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-6,"d":"-kr 6.00"}}]
[null,"Annet",null,1,{"v":20,"d":"kr 20.00"},{"v":24,"d":"kr 24.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-4,"d":"-kr 4.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Beregnet]], \"\")","v":{"v":20,"d":"kr 20.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":24,"d":"kr 24.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-4,"d":"-kr 4.00"}}]
[null,"Delsum",null,null,{"$f":"SUBTOTAL(109,Kostnader[Beregnet])","v":{"v":1464.5,"d":"kr 1,464.50"}},{"$f":"SUBTOTAL(109,Kostnader[Faktisk])","v":{"v":1598,"d":"kr 1,598.00"}},{"$f":"SUBTOTAL(109,Kostnader[Differanse])","v":{"v":-133.5,"d":"-kr 133.50"}},{"$f":"SUBTOTAL(109,Kostnader[[Beregnet ]])","v":{"v":2212.5,"d":"kr 2,212.50"}},{"$f":"SUBTOTAL(109,Kostnader[[Faktisk ]])","v":{"v":2573,"d":"kr 2,573.00"}},{"$f":"SUBTOTAL(109,Kostnader[[Differanse ]])","v":{"v":-360.5,"d":"-kr 360.50"}}]
[null,"Uventede kostnader (legg til 30 % estimert)",null,null,{"$f":"IFERROR(Kostnader[[#Totals],[Beregnet]]*0.3, \"\")","v":{"v":439.34999999999997,"d":"kr 439.35"}},null,null,{"$f":"IFERROR(Kostnader[[#Totals],[Beregnet ]]*0.3, \"\")","v":{"v":663.75,"d":"kr 663.75"}}]
[null,"Totale kostnader",null,null,{"$f":"IFERROR(SUM(E21:E21), \"\")","v":{"v":1464.5,"d":"kr 1,464.50"}},null,null,{"$f":"IFERROR(SUM(Kostnader[[#Totals],[Beregnet ]],Overskytende), \"\")","v":{"v":2876.25,"d":"kr 2,876.25"}}]