{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Kostnader för badrumsrenovering"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Kostnader för badrumsrenovering","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,"KALKYLBLADET KOSTNADER FÖR BADRUMSRENOVERING"]
[null,"Obs! Kolumnerna med skillnaden visas om det faktiska beloppet har överskridit det beräknade.  Röda tal anger överskridande (negativt) och svarta anger underskridande (positivt). "]
[{"$nulls":4},"Specificerad kostnad (kr)",null,null,"Totalkostnad (kr)"]
[null,"Område","Artiklar","Antal","Beräknad","Faktisk","Skillnad","Beräknad ","Faktisk ","Skillnad "]
[null,"Badkar/Dusch","Badkar, gjutjärn, 1,5 m, standard",1,{"v":250,"d":"250.00 kr"},{"$f":"RANDBETWEEN(E5+2,E5+20)","v":{"v":259,"d":"259.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-9,"d":"-9.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Beräknad]], \"\")","v":{"v":250,"d":"250.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":259,"d":"259.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-9,"d":"-9.00 kr"}}]
[null,"Badkar/Dusch","Duschdörrar, med gångjärn, standard",1,{"v":200,"d":"200.00 kr"},{"v":210,"d":"210.00 kr"},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-10,"d":"-10.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Beräknad]], \"\")","v":{"v":200,"d":"200.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":210,"d":"210.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-10,"d":"-10.00 kr"}}]
[null,"Badkar/Dusch","Duschmunstycke, standard",1,{"v":50,"d":"50.00 kr"},{"v":60,"d":"60.00 kr"},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-10,"d":"-10.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Beräknad]], \"\")","v":{"v":50,"d":"50.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":60,"d":"60.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-10,"d":"-10.00 kr"}}]
[null,"Badkar/Dusch","Badkarsvägg, standard",1,{"v":200,"d":"200.00 kr"},{"v":215,"d":"215.00 kr"},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-15,"d":"-15.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Beräknad]], \"\")","v":{"v":200,"d":"200.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":215,"d":"215.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-15,"d":"-15.00 kr"}}]
[null,"Skåp","Medicinskåp 60 cm, deluxe",1,{"v":200,"d":"200.00 kr"},{"v":215,"d":"215.00 kr"},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-15,"d":"-15.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Beräknad]], \"\")","v":{"v":200,"d":"200.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":215,"d":"215.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-15,"d":"-15.00 kr"}}]
[null,"Skåp","Tvättställ med skåp 75 cm, standard",2,{"v":100,"d":"100.00 kr"},{"v":106,"d":"106.00 kr"},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-6,"d":"-6.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Beräknad]], \"\")","v":{"v":200,"d":"200.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":212,"d":"212.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-12,"d":"-12.00 kr"}}]
[null,"Bänkar","Keramiska plattor, deluxe (antal i m²)",5,{"v":22.5,"d":"22.50 kr"},{"v":27,"d":"27.00 kr"},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-4.5,"d":"-4.50 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Beräknad]], \"\")","v":{"v":112.5,"d":"112.50 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":135,"d":"135.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-22.5,"d":"-22.50 kr"}}]
[null,"Kranar","Vattenkran, badkar, standard",1,{"v":90,"d":"90.00 kr"},{"v":94,"d":"94.00 kr"},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-4,"d":"-4.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Beräknad]], \"\")","v":{"v":90,"d":"90.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":94,"d":"94.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-4,"d":"-4.00 kr"}}]
[null,"Kranar","Vattenkran, dusch, ett handtag, standard",1,{"v":115,"d":"115.00 kr"},{"v":124,"d":"124.00 kr"},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-9,"d":"-9.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Beräknad]], \"\")","v":{"v":115,"d":"115.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":124,"d":"124.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-9,"d":"-9.00 kr"}}]
[null,"Kranar","Tvättställsblandare, standard",1,{"v":95,"d":"95.00 kr"},{"v":106,"d":"106.00 kr"},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-11,"d":"-11.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Beräknad]], \"\")","v":{"v":95,"d":"95.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":106,"d":"106.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-11,"d":"-11.00 kr"}}]
[null,"Golv","Keramiska plattor, standard (antal i m²)",35,{"v":12,"d":"12.00 kr"},{"v":25,"d":"25.00 kr"},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-13,"d":"-13.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Beräknad]], \"\")","v":{"v":420,"d":"420.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":875,"d":"875.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-455,"d":"-455.00 kr"}}]
[null,"Maskinvara","Handduksstång, standard",2,{"v":15,"d":"15.00 kr"},{"v":28,"d":"28.00 kr"},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-13,"d":"-13.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Beräknad]], \"\")","v":{"v":30,"d":"30.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":56,"d":"56.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-26,"d":"-26.00 kr"}}]
[null,"Maskinvara","Toalettrullehållare",1,{"v":10,"d":"10.00 kr"},{"v":19,"d":"19.00 kr"},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-9,"d":"-9.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Beräknad]], \"\")","v":{"v":10,"d":"10.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":19,"d":"19.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-9,"d":"-9.00 kr"}}]
[null,"Belysning","Infälld belysning, standard",4,{"v":25,"d":"25.00 kr"},{"v":38,"d":"38.00 kr"},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-13,"d":"-13.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Beräknad]], \"\")","v":{"v":100,"d":"100.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":152,"d":"152.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-52,"d":"-52.00 kr"}}]
[null,"Handfat","Toalett, standard",2,{"v":60,"d":"60.00 kr"},{"v":63,"d":"63.00 kr"},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-3,"d":"-3.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Beräknad]], \"\")","v":{"v":120,"d":"120.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":126,"d":"126.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-6,"d":"-6.00 kr"}}]
[null,"Övrigt",null,1,{"v":20,"d":"20.00 kr"},{"v":25,"d":"25.00 kr"},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad]]-Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":-5,"d":"-5.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Beräknad]], \"\")","v":{"v":20,"d":"20.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Antal]]*Kostnader[[#This Row],[Faktisk]], \"\")","v":{"v":25,"d":"25.00 kr"}},{"$f":"IFERROR(Kostnader[[#This Row],[Beräknad ]]-Kostnader[[#This Row],[Faktisk ]], \"\")","v":{"v":-5,"d":"-5.00 kr"}}]
[null,"Delsumma",null,null,{"$f":"SUBTOTAL(109,Kostnader[Beräknad])","v":{"v":1464.5,"d":"1,464.50 kr"}},{"$f":"SUBTOTAL(109,Kostnader[Faktisk])","v":{"v":1614,"d":"1,614.00 kr"}},{"$f":"SUBTOTAL(109,Kostnader[Skillnad])","v":{"v":-149.5,"d":"-149.50 kr"}},{"$f":"SUBTOTAL(109,Kostnader[[Beräknad ]])","v":{"v":2212.5,"d":"2,212.50 kr"}},{"$f":"SUBTOTAL(109,Kostnader[[Faktisk ]])","v":{"v":2883,"d":"2,883.00 kr"}},{"$f":"SUBTOTAL(109,Kostnader[[Skillnad ]])","v":{"v":-670.5,"d":"-670.50 kr"}}]
[]
[null,"Oförutsedda kostnader (lägg till 30 % av beräknat)",null,null,{"$f":"IFERROR(Kostnader[[#Totals],[Beräknad]]*0.3, \"\")","v":{"v":439.34999999999997,"d":"439.35 kr"}},null,null,{"$f":"IFERROR(Kostnader[[#Totals],[Beräknad ]]*0.3, \"\")","v":{"v":663.75,"d":"663.75 kr"}}]
[null,"Totala kostnader",null,null,{"$f":"IFERROR(SUM(E21:E21), \"\")","v":{"v":1464.5,"d":"1,464.50 kr"}},null,null,{"$f":"IFERROR(SUM(Kostnader[[#Totals],[Beräknad ]],Överskott), \"\")","v":{"v":2876.25,"d":"2,876.25 kr"}}]