{"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":24,"n_cols":10,"rows_kept":24,"merged":[[1,1,2,3],[2,4,2,6],[2,7,2,9],[22,1,22,3],[22,4,22,6],[22,7,22,9],[23,1,23,3],[23,4,23,6],[23,7,23,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 (NOK)",null,null,"Totale kostnader (NOK)"]
[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":220,"d":"kr 220.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-20,"d":"-kr 20.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":220,"d":"kr 220.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-20,"d":"-kr 20.00"}}]
[null,"Bad/dusj","Dusjhode, standard",1,{"v":50,"d":"kr 50.00"},{"v":69,"d":"kr 69.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":50,"d":"kr 50.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":69,"d":"kr 69.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-19,"d":"-kr 19.00"}}]
[null,"Bad/dusj","Badekarvegg, standard",1,{"v":200,"d":"kr 200.00"},{"v":207,"d":"kr 207.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-7,"d":"-kr 7.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":207,"d":"kr 207.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-7,"d":"-kr 7.00"}}]
[null,"Skap","Medisinskap 24'', deluxe",1,{"v":200,"d":"kr 200.00"},{"v":207,"d":"kr 207.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-7,"d":"-kr 7.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":207,"d":"kr 207.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-7,"d":"-kr 7.00"}}]
[null,"Skap","Dobbel servant 30'', standard",2,{"v":100,"d":"kr 100.00"},{"v":120,"d":"kr 120.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-20,"d":"-kr 20.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":240,"d":"kr 240.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-40,"d":"-kr 40.00"}}]
[null,"Benkeplater","Keramikkflis, deluxe (antall i lineære meter)",5,{"v":22.5,"d":"kr 22.50"},{"v":32,"d":"kr 32.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-9.5,"d":"-kr 9.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":160,"d":"kr 160.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-47.5,"d":"-kr 47.50"}}]
[null,"Kraner","Kran, badekar, standard",1,{"v":90,"d":"kr 90.00"},{"v":100,"d":"kr 100.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":90,"d":"kr 90.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":100,"d":"kr 100.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-10,"d":"-kr 10.00"}}]
[null,"Kraner","Kran, dusj, enkelt håndtak, standard",1,{"v":115,"d":"kr 115.00"},{"v":130,"d":"kr 130.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-15,"d":"-kr 15.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":130,"d":"kr 130.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-15,"d":"-kr 15.00"}}]
[null,"Kraner","Kran til vask, standard",1,{"v":95,"d":"kr 95.00"},{"v":100,"d":"kr 100.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":95,"d":"kr 95.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":100,"d":"kr 100.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-5,"d":"-kr 5.00"}}]
[null,"Gulvbelegg","Keramikkflis, standard (antall i kvadratmeter)",35,{"v":12,"d":"kr 12.00"},{"v":32,"d":"kr 32.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-20,"d":"-kr 20.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":1120,"d":"kr 1,120.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-700,"d":"-kr 700.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":30,"d":"kr 30.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-20,"d":"-kr 20.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":30,"d":"kr 30.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-20,"d":"-kr 20.00"}}]
[null,"Belysning","Lysarmatur, standard",4,{"v":25,"d":"kr 25.00"},{"v":36,"d":"kr 36.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":100,"d":"kr 100.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":144,"d":"kr 144.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-44,"d":"-kr 44.00"}}]
[null,"Vasker","Toalett, standard",2,{"v":60,"d":"kr 60.00"},{"v":73,"d":"kr 73.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":120,"d":"kr 120.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antall]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":146,"d":"kr 146.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-26,"d":"-kr 26.00"}}]
[null,"Annet",null,1,{"v":20,"d":"kr 20.00"},{"v":37,"d":"kr 37.00"},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-17,"d":"-kr 17.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":37,"d":"kr 37.00"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beregnet ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-17,"d":"-kr 17.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":1673,"d":"kr 1,673.00"}},{"$f":"SUBTOTAL(109,Kostnader[Differanse])","v":{"v":-208.5,"d":"-kr 208.50"}},{"$f":"SUBTOTAL(109,Kostnader[[Beregnet ]])","v":{"v":2212.5,"d":"kr 2,212.50"}},{"$f":"SUBTOTAL(109,Kostnader[[Faktisk ]])","v":{"v":3207,"d":"kr 3,207.00"}},{"$f":"SUBTOTAL(109,Kostnader[[Differanse ]])","v":{"v":-994.5,"d":"-kr 994.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"}}]