{"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":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,"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":263,"d":"263.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":250,"d":"250.00 kr"}},{"$f":"IFERROR(KOSTNADER[[#This Row],[Antal]]*KOSTNADER[[#This Row],[Faktisk]], \"\")","v":{"v":263,"d":"263.00 kr"}},{"$f":"IFERROR(KOSTNADER[[#This Row],[Beräknad ]]-KOSTNADER[[#This Row],[Faktisk ]], \"\")","v":{"v":-13,"d":"-13.00 kr"}}]
[null,"Badkar/Dusch","Duschdörrar, med gångjärn, 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,"Badkar/Dusch","Duschmunstycke, standard",1,{"v":50,"d":"50.00 kr"},{"v":68,"d":"68.00 kr"},{"$f":"IFERROR(KOSTNADER[[#This Row],[Beräknad]]-KOSTNADER[[#This Row],[Faktisk]], \"\")","v":{"v":-18,"d":"-18.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":68,"d":"68.00 kr"}},{"$f":"IFERROR(KOSTNADER[[#This Row],[Beräknad ]]-KOSTNADER[[#This Row],[Faktisk ]], \"\")","v":{"v":-18,"d":"-18.00 kr"}}]
[null,"Badkar/Dusch","Badkarsvägg, standard",1,{"v":200,"d":"200.00 kr"},{"v":212,"d":"212.00 kr"},{"$f":"IFERROR(KOSTNADER[[#This Row],[Beräknad]]-KOSTNADER[[#This Row],[Faktisk]], \"\")","v":{"v":-12,"d":"-12.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,"Skåp","Medicinskåp 60 cm, deluxe",1,{"v":200,"d":"200.00 kr"},{"v":212,"d":"212.00 kr"},{"$f":"IFERROR(KOSTNADER[[#This Row],[Beräknad]]-KOSTNADER[[#This Row],[Faktisk]], \"\")","v":{"v":-12,"d":"-12.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,"Skåp","Tvättställ med skåp 75 cm, standard",2,{"v":100,"d":"100.00 kr"},{"v":113,"d":"113.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":200,"d":"200.00 kr"}},{"$f":"IFERROR(KOSTNADER[[#This Row],[Antal]]*KOSTNADER[[#This Row],[Faktisk]], \"\")","v":{"v":226,"d":"226.00 kr"}},{"$f":"IFERROR(KOSTNADER[[#This Row],[Beräknad ]]-KOSTNADER[[#This Row],[Faktisk ]], \"\")","v":{"v":-26,"d":"-26.00 kr"}}]
[null,"Bänkar","Keramiska plattor, deluxe (antal i m²)",5,{"v":22.5,"d":"22.50 kr"},{"v":31,"d":"31.00 kr"},{"$f":"IFERROR(KOSTNADER[[#This Row],[Beräknad]]-KOSTNADER[[#This Row],[Faktisk]], \"\")","v":{"v":-8.5,"d":"-8.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":155,"d":"155.00 kr"}},{"$f":"IFERROR(KOSTNADER[[#This Row],[Beräknad ]]-KOSTNADER[[#This Row],[Faktisk ]], \"\")","v":{"v":-42.5,"d":"-42.50 kr"}}]
[null,"Kranar","Vattenkran, badkar, standard",1,{"v":90,"d":"90.00 kr"},{"v":93,"d":"93.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":90,"d":"90.00 kr"}},{"$f":"IFERROR(KOSTNADER[[#This Row],[Antal]]*KOSTNADER[[#This Row],[Faktisk]], \"\")","v":{"v":93,"d":"93.00 kr"}},{"$f":"IFERROR(KOSTNADER[[#This Row],[Beräknad ]]-KOSTNADER[[#This Row],[Faktisk ]], \"\")","v":{"v":-3,"d":"-3.00 kr"}}]
[null,"Kranar","Vattenkran, dusch, ett handtag, standard",1,{"v":115,"d":"115.00 kr"},{"v":117,"d":"117.00 kr"},{"$f":"IFERROR(KOSTNADER[[#This Row],[Beräknad]]-KOSTNADER[[#This Row],[Faktisk]], \"\")","v":{"v":-2,"d":"-2.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":117,"d":"117.00 kr"}},{"$f":"IFERROR(KOSTNADER[[#This Row],[Beräknad ]]-KOSTNADER[[#This Row],[Faktisk ]], \"\")","v":{"v":-2,"d":"-2.00 kr"}}]
[null,"Kranar","Tvättställsblandare, standard",1,{"v":95,"d":"95.00 kr"},{"v":113,"d":"113.00 kr"},{"$f":"IFERROR(KOSTNADER[[#This Row],[Beräknad]]-KOSTNADER[[#This Row],[Faktisk]], \"\")","v":{"v":-18,"d":"-18.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":113,"d":"113.00 kr"}},{"$f":"IFERROR(KOSTNADER[[#This Row],[Beräknad ]]-KOSTNADER[[#This Row],[Faktisk ]], \"\")","v":{"v":-18,"d":"-18.00 kr"}}]
[null,"Golv","Keramiska plattor, standard (antal i m²)",35,{"v":12,"d":"12.00 kr"},{"v":21,"d":"21.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":420,"d":"420.00 kr"}},{"$f":"IFERROR(KOSTNADER[[#This Row],[Antal]]*KOSTNADER[[#This Row],[Faktisk]], \"\")","v":{"v":735,"d":"735.00 kr"}},{"$f":"IFERROR(KOSTNADER[[#This Row],[Beräknad ]]-KOSTNADER[[#This Row],[Faktisk ]], \"\")","v":{"v":-315,"d":"-315.00 kr"}}]
[null,"Maskinvara","Handduksstång, standard",2,{"v":15,"d":"15.00 kr"},{"v":18,"d":"18.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":30,"d":"30.00 kr"}},{"$f":"IFERROR(KOSTNADER[[#This Row],[Antal]]*KOSTNADER[[#This Row],[Faktisk]], \"\")","v":{"v":36,"d":"36.00 kr"}},{"$f":"IFERROR(KOSTNADER[[#This Row],[Beräknad ]]-KOSTNADER[[#This Row],[Faktisk ]], \"\")","v":{"v":-6,"d":"-6.00 kr"}}]
[null,"Maskinvara","Toalettrullehållare",1,{"v":10,"d":"10.00 kr"},{"v":25,"d":"25.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":10,"d":"10.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":-15,"d":"-15.00 kr"}}]
[null,"Belysning","Infälld belysning, standard",4,{"v":25,"d":"25.00 kr"},{"v":44,"d":"44.00 kr"},{"$f":"IFERROR(KOSTNADER[[#This Row],[Beräknad]]-KOSTNADER[[#This Row],[Faktisk]], \"\")","v":{"v":-19,"d":"-19.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":176,"d":"176.00 kr"}},{"$f":"IFERROR(KOSTNADER[[#This Row],[Beräknad ]]-KOSTNADER[[#This Row],[Faktisk ]], \"\")","v":{"v":-76,"d":"-76.00 kr"}}]
[null,"Handfat","Toalett, standard",2,{"v":60,"d":"60.00 kr"},{"v":74,"d":"74.00 kr"},{"$f":"IFERROR(KOSTNADER[[#This Row],[Beräknad]]-KOSTNADER[[#This Row],[Faktisk]], \"\")","v":{"v":-14,"d":"-14.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":148,"d":"148.00 kr"}},{"$f":"IFERROR(KOSTNADER[[#This Row],[Beräknad ]]-KOSTNADER[[#This Row],[Faktisk ]], \"\")","v":{"v":-28,"d":"-28.00 kr"}}]
[null,"Övrigt",null,1,{"v":20,"d":"20.00 kr"},{"v":32,"d":"32.00 kr"},{"$f":"IFERROR(KOSTNADER[[#This Row],[Beräknad]]-KOSTNADER[[#This Row],[Faktisk]], \"\")","v":{"v":-12,"d":"-12.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":32,"d":"32.00 kr"}},{"$f":"IFERROR(KOSTNADER[[#This Row],[Beräknad ]]-KOSTNADER[[#This Row],[Faktisk ]], \"\")","v":{"v":-12,"d":"-12.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":1651,"d":"1,651.00 kr"}},{"$f":"SUBTOTAL(109,KOSTNADER[Skillnad])","v":{"v":-186.5,"d":"-186.50 kr"}},{"$f":"SUBTOTAL(109,KOSTNADER[[Beräknad ]])","v":{"v":2212.5,"d":"2,212.50 kr"}},{"$f":"SUBTOTAL(109,KOSTNADER[[Faktisk ]])","v":{"v":2826,"d":"2,826.00 kr"}},{"$f":"SUBTOTAL(109,KOSTNADER[[Skillnad ]])","v":{"v":-613.5,"d":"-613.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"}}]