{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Kund & Projekt","Kalkyl","Påslag","ROT","Timpriser","Offert","Licens"],"not_rendered":{"charts":0,"images":4,"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":"Kund & Projekt","index":0,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[[15,4,25,4],[0,0,0,4],[8,0,8,4],[24,1,29,1],[32,3,34,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
["KUND & PROJEKTUPPGIFTER"]
[]
["Kunduppgifter",null,null,"Intern kundinfo (syns ej på offert)"]
["Kundnamn","Exempel: Anders Andersson",null,"Tidigare kund?","Ja / Nej"]
["Personnr/Org.nr",null,null,"Hur fick vi kontakten?","Google, rekommendation, tidigare kund, offertförfrågan via mail"]
["Kontaktperson","Exempel: Anders Andersson",null,"Tidigare jobb","Exempel: Köksrenovering 2023"]
["Telefon","Exempel: 0123-456 789"]
["E-post","Exempel: Anders@Epost.se",null,"Anteckningar / historik","Exempel: Noggrann kund, vill ha löpande uppdateringar via sms. Känslig för damm → viktigt med täckning."]
["Adress","Exempel: Huset 3"]
["Postnr & Ort","Exempel: 123 45 Djupa dalen"]
[]
["Projektuppgifter"]
["Projektnamn"]
["Fastighetsbeteckning"]
["Arbetsplats (om annan)","Exempel: kundadress / Sommarstuga"]
[]
["Projektbeskrivning","Exempel: Rivning av befintligt badrum, ny tätskikt, kakel, klinker och installation av ny"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"🔒 DEMOVERSION\nBegränsad funktionalitet.\nFull version beställs via fribergbyggkonsult.se"]

{"sheet":"Kalkyl","index":1,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[23,3,24,5]]}
["Post","Materialkostnad","Arbetstimmar","Timpris","Summa","Egenkostnad arbete","Arbetsvinst"]
["Exempel: Renovera badrum",45000,40,"Snickare",{"$f":"IF(D2=\"\",\"\",B2 + C2*VLOOKUP(D2,Timpriser!A:C,3,FALSE))","v":67000},{"$f":"IF(D2=\"\",\"\",C2*VLOOKUP(D2,Timpriser!A:B,2,FALSE))","v":16000},{"$f":"IF(D2=\"\",\"\",C2*(VLOOKUP(D2,Timpriser!A:C,3,FALSE)-VLOOKUP(D2,Timpriser!A:B,2,FALSE)))","v":6000}]
[null,null,null,null,{"$f":"IF(D3=\"\",\"\",B3 + C3*VLOOKUP(D3,Timpriser!A:C,3,FALSE))","v":""},{"$f":"IF(D3=\"\",\"\",C3*VLOOKUP(D3,Timpriser!A:B,2,FALSE))","v":""},{"$f":"IF(D3=\"\",\"\",C3*(VLOOKUP(D3,Timpriser!A:C,3,FALSE)-VLOOKUP(D3,Timpriser!A:B,2,FALSE)))","v":""}]
[null,null,null,null,{"$f":"IF(D4=\"\",\"\",B4 + C4*VLOOKUP(D4,Timpriser!A:C,3,FALSE))","v":""},{"$f":"IF(D4=\"\",\"\",C4*VLOOKUP(D4,Timpriser!A:B,2,FALSE))","v":""},{"$f":"IF(D4=\"\",\"\",C4*(VLOOKUP(D4,Timpriser!A:C,3,FALSE)-VLOOKUP(D4,Timpriser!A:B,2,FALSE)))","v":""}]
[null,null,null,null,{"$f":"IF(D5=\"\",\"\",B5 + C5*VLOOKUP(D5,Timpriser!A:C,3,FALSE))","v":""},{"$f":"IF(D5=\"\",\"\",C5*VLOOKUP(D5,Timpriser!A:B,2,FALSE))","v":""},{"$f":"IF(D5=\"\",\"\",C5*(VLOOKUP(D5,Timpriser!A:C,3,FALSE)-VLOOKUP(D5,Timpriser!A:B,2,FALSE)))","v":""}]
[null,null,null,null,{"$f":"IF(D6=\"\",\"\",B6 + C6*VLOOKUP(D6,Timpriser!A:C,3,FALSE))","v":""},{"$f":"IF(D6=\"\",\"\",C6*VLOOKUP(D6,Timpriser!A:B,2,FALSE))","v":""},{"$f":"IF(D6=\"\",\"\",C6*(VLOOKUP(D6,Timpriser!A:C,3,FALSE)-VLOOKUP(D6,Timpriser!A:B,2,FALSE)))","v":""}]
[null,null,null,null,{"$f":"IF(D7=\"\",\"\",B7 + C7*VLOOKUP(D7,Timpriser!A:C,3,FALSE))","v":""},{"$f":"IF(D7=\"\",\"\",C7*VLOOKUP(D7,Timpriser!A:B,2,FALSE))","v":""},{"$f":"IF(D7=\"\",\"\",C7*(VLOOKUP(D7,Timpriser!A:C,3,FALSE)-VLOOKUP(D7,Timpriser!A:B,2,FALSE)))","v":""}]
[null,null,null,null,{"$f":"IF(D8=\"\",\"\",B8 + C8*VLOOKUP(D8,Timpriser!A:C,3,FALSE))","v":""},{"$f":"IF(D8=\"\",\"\",C8*VLOOKUP(D8,Timpriser!A:B,2,FALSE))","v":""},{"$f":"IF(D8=\"\",\"\",C8*(VLOOKUP(D8,Timpriser!A:C,3,FALSE)-VLOOKUP(D8,Timpriser!A:B,2,FALSE)))","v":""}]
[null,null,null,null,{"$f":"IF(D9=\"\",\"\",B9 + C9*VLOOKUP(D9,Timpriser!A:C,3,FALSE))","v":""},{"$f":"IF(D9=\"\",\"\",C9*VLOOKUP(D9,Timpriser!A:B,2,FALSE))","v":""},{"$f":"IF(D9=\"\",\"\",C9*(VLOOKUP(D9,Timpriser!A:C,3,FALSE)-VLOOKUP(D9,Timpriser!A:B,2,FALSE)))","v":""}]
[null,null,null,null,{"$f":"IF(D10=\"\",\"\",B10 + C10*VLOOKUP(D10,Timpriser!A:C,3,FALSE))","v":""},{"$f":"IF(D10=\"\",\"\",C10*VLOOKUP(D10,Timpriser!A:B,2,FALSE))","v":""},{"$f":"IF(D10=\"\",\"\",C10*(VLOOKUP(D10,Timpriser!A:C,3,FALSE)-VLOOKUP(D10,Timpriser!A:B,2,FALSE)))","v":""}]
[null,null,null,null,{"$f":"IF(D11=\"\",\"\",B11 + C11*VLOOKUP(D11,Timpriser!A:C,3,FALSE))","v":""},{"$f":"IF(D11=\"\",\"\",C11*VLOOKUP(D11,Timpriser!A:B,2,FALSE))","v":""},{"$f":"IF(D11=\"\",\"\",C11*(VLOOKUP(D11,Timpriser!A:C,3,FALSE)-VLOOKUP(D11,Timpriser!A:B,2,FALSE)))","v":""}]
[null,null,null,null,{"$f":"IF(D12=\"\",\"\",B12 + C12*VLOOKUP(D12,Timpriser!A:C,3,FALSE))","v":""},{"$f":"IF(D12=\"\",\"\",C12*VLOOKUP(D12,Timpriser!A:B,2,FALSE))","v":""},{"$f":"IF(D12=\"\",\"\",C12*(VLOOKUP(D12,Timpriser!A:C,3,FALSE)-VLOOKUP(D12,Timpriser!A:B,2,FALSE)))","v":""}]
[null,null,null,null,{"$f":"IF(D13=\"\",\"\",B13 + C13*VLOOKUP(D13,Timpriser!A:C,3,FALSE))","v":""},{"$f":"IF(D13=\"\",\"\",C13*VLOOKUP(D13,Timpriser!A:B,2,FALSE))","v":""},{"$f":"IF(D13=\"\",\"\",C13*(VLOOKUP(D13,Timpriser!A:C,3,FALSE)-VLOOKUP(D13,Timpriser!A:B,2,FALSE)))","v":""}]
[null,null,null,null,{"$f":"IF(D14=\"\",\"\",B14 + C14*VLOOKUP(D14,Timpriser!A:C,3,FALSE))","v":""},{"$f":"IF(D14=\"\",\"\",C14*VLOOKUP(D14,Timpriser!A:B,2,FALSE))","v":""},{"$f":"IF(D14=\"\",\"\",C14*(VLOOKUP(D14,Timpriser!A:C,3,FALSE)-VLOOKUP(D14,Timpriser!A:B,2,FALSE)))","v":""}]
[null,null,null,null,{"$f":"IF(D15=\"\",\"\",B15 + C15*VLOOKUP(D15,Timpriser!A:C,3,FALSE))","v":""},{"$f":"IF(D15=\"\",\"\",C15*VLOOKUP(D15,Timpriser!A:B,2,FALSE))","v":""},{"$f":"IF(D15=\"\",\"\",C15*(VLOOKUP(D15,Timpriser!A:C,3,FALSE)-VLOOKUP(D15,Timpriser!A:B,2,FALSE)))","v":""}]
[null,null,null,null,{"$f":"IF(D16=\"\",\"\",B16 + C16*VLOOKUP(D16,Timpriser!A:C,3,FALSE))","v":""},{"$f":"IF(D16=\"\",\"\",C16*VLOOKUP(D16,Timpriser!A:B,2,FALSE))","v":""},{"$f":"IF(D16=\"\",\"\",C16*(VLOOKUP(D16,Timpriser!A:C,3,FALSE)-VLOOKUP(D16,Timpriser!A:B,2,FALSE)))","v":""}]
[null,null,null,null,{"$f":"IF(D17=\"\",\"\",B17 + C17*VLOOKUP(D17,Timpriser!A:C,3,FALSE))","v":""},{"$f":"IF(D17=\"\",\"\",C17*VLOOKUP(D17,Timpriser!A:B,2,FALSE))","v":""},{"$f":"IF(D17=\"\",\"\",C17*(VLOOKUP(D17,Timpriser!A:C,3,FALSE)-VLOOKUP(D17,Timpriser!A:B,2,FALSE)))","v":""}]
[null,null,null,null,{"$f":"IF(D18=\"\",\"\",B18 + C18*VLOOKUP(D18,Timpriser!A:C,3,FALSE))","v":""},{"$f":"IF(D18=\"\",\"\",C18*VLOOKUP(D18,Timpriser!A:B,2,FALSE))","v":""},{"$f":"IF(D18=\"\",\"\",C18*(VLOOKUP(D18,Timpriser!A:C,3,FALSE)-VLOOKUP(D18,Timpriser!A:B,2,FALSE)))","v":""}]
[null,null,null,null,{"$f":"IF(D19=\"\",\"\",B19 + C19*VLOOKUP(D19,Timpriser!A:C,3,FALSE))","v":""},{"$f":"IF(D19=\"\",\"\",C19*VLOOKUP(D19,Timpriser!A:B,2,FALSE))","v":""},{"$f":"IF(D19=\"\",\"\",C19*(VLOOKUP(D19,Timpriser!A:C,3,FALSE)-VLOOKUP(D19,Timpriser!A:B,2,FALSE)))","v":""}]
[null,null,null,null,{"$f":"IF(D20=\"\",\"\",B20 + C20*VLOOKUP(D20,Timpriser!A:C,3,FALSE))","v":""},{"$f":"IF(D20=\"\",\"\",C20*VLOOKUP(D20,Timpriser!A:B,2,FALSE))","v":""},{"$f":"IF(D20=\"\",\"\",C20*(VLOOKUP(D20,Timpriser!A:C,3,FALSE)-VLOOKUP(D20,Timpriser!A:B,2,FALSE)))","v":""}]
[null,null,null,null,null,null,{"$f":"SUM(G2:G20)","v":6000}]
[]
["Total materialkostnad",{"$f":"SUM(B2:B20)","v":45000}]
["Total arbetskostnad",{"$f":"SUM(F2:F20) + SUM(G2:G20)","v":22000},null,"OBS kalkylblad fylls i exkl moms"]
["Total före påslag",{"$f":"SUM(E2:E20)","v":67000}]
[]
["Materialpåslag",{"$f":"B23*Påslag!B1/100","v":6750}]
["Övriga kostnader",{"$f":"Påslag!B2 + Påslag!B3 + Påslag!B4","v":3500}]
["Totalt efter påslag",{"$f":"Påslag!B7","v":77250}]
[]
["Beräknad vinst (kr)",{"$f":"B27 + G21","v":12750}]
["Vinstmarginal (%)",{"$f":"IF(B29=0,\"\",B31/B29)","v":0.1650485436893204}]

{"sheet":"Påslag","index":2,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Materialpåslag %",15]
["Resekostnad",1500]
["Maskinkostnad",2000]
["Övriga kostnader",0]
[]
["Materialpåslag i kr",{"$f":"Kalkyl!B23 * B1 / 100","v":6750}]
["Totalt efter påslag",{"$f":"Kalkyl!B25 + B6 + B2 + B3 + B4","v":77250}]

{"sheet":"ROT","index":3,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Arbetskostnad exkl. moms",{"$f":"Kalkyl!B24","v":22000}]
["Arbetskostnad inkl. moms",{"$f":"B1*1.25","v":27500}]
["ROT-avdrag 30%",{"$f":"B2*0.3","v":8250}]
["Max ROT",50000]
["ROT att dra av",{"$f":"MIN(B3,B4)","v":8250},null,null,"Totalt exkl.moms",{"$f":"Påslag!B7","v":77250}]
[null,null,null,null,"totalt inkl moms",{"$f":"F5*1.25","v":96562.5}]
["Pris efter ROT",{"$f":"F6 - B5","v":88312.5}]

{"sheet":"Timpriser","index":4,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,1,6,3]]}
["Roll","Självkostnad/tim","Debiteras","Vinst/tim"]
["Snickare",400,550,{"$f":"C2-B2","v":150}]
["Lärling",250,380,{"$f":"C3-B3","v":130}]
["Arbetsledare",500,750,{"$f":"C4-B4","v":250}]
[]
[null,"OBS, timkostnad fylls i exkl. moms"]

{"sheet":"Offert","index":5,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,3],[26,2,26,3],[32,0,32,3],[22,2,23,3]]}
["OFFERT"]
["Bygg & Renovering AB"]
["070‑123 45 67 | info@byggfirma.se | Org.nr 556123‑4567"]
[]
["Offertnummer:",{"$f":"TEXT(TODAY(),\"YYYYMMDD\")","v":"YYYY0212"},"Offertdatum:",{"$f":"TODAY()","v":"2026-02-12"}]
[null,null,"Giltig till:",{"$f":"D5+30","v":"2026-03-14"}]
[]
[{"$f":"'Kund & Projekt'!B12","v":"Exempel: Anders Andersson"},null,{"$f":"'Kund & Projekt'!B14","v":"Exempel: Anders Andersson"}]
[{"$f":"'Kund & Projekt'!B17","v":"Exempel: Huset 3"},null,{"$f":"'Kund & Projekt'!B15","v":"Exempel: 0123-456 789"}]
[{"$f":"'Kund & Projekt'!B18","v":"Exempel: 123 45 Djupa dalen"},null,{"$f":"'Kund & Projekt'!B16","v":"Exempel: Anders@Epost.se"}]
[]
[]
["Beskrivning av arbete",null,"Totalt före ROT",{"$f":"Kalkyl!B29","v":77250}]
["• Rivning av befintliga ytskikt\n• Montering av nya väggar enligt ritning\n• Material enligt överenskommen standard",null,"ROT-avdrag ",{"$f":"ROT!B5","v":8250}]
["• ",null,"TOTALT ATT BETALA",{"$f":"ROT!B7","v":88312.5}]
["• ",null,"Varav moms",{"$f":"D20*0.2","v":7065}]
[]
[null,null,"Betalningsplan"]
["Detta ingår inte",null,"30 % vid start",{"$f":"ROT!B7*0.3","v":26493.75}]
["• El- och VVS-arbeten utöver ovan\n• Oförutsedda skador i stomme",null,"40 % under projektet",{"$f":"D15*0.4","v":35325}]
["• ",null,"30 % efter slutfört arbete",{"$f":"ROT!B7*0.3","v":26493.75}]
[]
["Förutsättningar och avvikelser",null,"ROT-avdraget är preliminärt och baseras på kundens uppgifter.\nSlutligt avdrag fastställs av Skatteverket.\nOm avdraget inte beviljas betalar kunden mellanskillnaden."]
["• Arbetet förutsätter fri tillgång till arbetsplatsen\n• Tilläggsarbeten godkänns skriftligen"]
["• "]
[]
["Här kan företaget lämna ytterligare information till kund.",null,"“Genom underskrift godkänns denna offert och dess villkor.”"]
[]
["Ort & datum:",null,"Beställare underskrift:"]
[]
[]
[]
["Bygg & Renovering AB | Org.nr 556123-4567 | Godkänd för F-skatt | Momsreg.nr SE556123456701 | Telefon 070-123 45 67 | info@byggfirma.se"]

{"sheet":"Licens","index":6,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[[6,0,14,3]]}
["Licensierad till företag:","Byggfirma AB"]
["Organisationsnummer:","556123-4567"]
["Licens giltig till:","2029-12-31"]
[]
[]
[]
["Licens & användarvillkor\n\nDenna offertmall är licensierad för användning av ett (1) företag och gäller till det datum som anges i dokumentet. Mallen får inte kopieras, säljas eller spridas vidare utan skriftligt tillstånd.\n\nNär licensperioden löper ut krävs förnyelse för fortsatt användning."]