{"product_id":"semesterplanering-bemanningsoversikt-2027-excel-word-pdf","title":"Vacation Planning \u0026 Staffing Overview 2027 – Excel, Word \u0026 PDF | Swedish + English","description":"\n\u003csection style=\"color:#17324D;line-height:1.75\"\u003e\n\u003ch2\u003eHoliday Planning 2027 – Excel template, holiday list, and staffing overview\u003c\/h2\u003e\n\n\u003cp\u003ePlan holidays, document decisions, and identify periods with insufficient office staffing. This downloadable package includes an Excel-based holiday planner for the \u003cstrong\u003e2027 calendar year\u003c\/strong\u003e, an editable form for holiday requests and employer decisions, and a detailed user guide. Primarily suited for smaller Swedish employers with a standard Monday–Friday office week.\u003c\/p\u003e\n\n\u003cp\u003e\u003cstrong\u003eFormat:\u003c\/strong\u003e Excel (XLSX) + Word (DOCX) + PDF. \u003cstrong\u003eLanguage:\u003c\/strong\u003e Swedish with an English reference translation of the form and guide. The Swedish text and Swedish law serve as the baseline.\u003c\/p\u003e\n\n\u003cnav aria-label=\"About the document template\"\u003e\u003cstrong\u003eAbout the document template:\u003c\/strong\u003e \u003ca href=\"#mb-ingar\"\u003eWhat's included\u003c\/a\u003e · \u003ca href=\"#mb-excel\"\u003eThe Excel tool\u003c\/a\u003e · \u003ca href=\"#mb-sa\"\u003eHow to do it\u003c\/a\u003e · \u003ca href=\"#mb-juridik\"\u003eLegal information\u003c\/a\u003e · \u003ca href=\"#mb-faq\"\u003eFAQ\u003c\/a\u003e\u003c\/nav\u003e\n\u003cdiv style=\"background:#e8f4ed;border-left:5px solid #337b5f;padding:16px;margin:18px 0\"\u003e\n\n\u003cstrong\u003eSource-verified October 12, 2026.\u003c\/strong\u003e The product's legal guidance has been checked against the Annual Leave Act, Verksamt, and the IMY's workplace guidance. The package is a standard template and does not replace legal advice, individual collective agreement interpretation, or payroll administration.\u003c\/div\u003e\n\n\u003ch2 id=\"mb-ingar\"\u003eWhat is included in the package\u003c\/h2\u003e\n\n\u003ctable style=\"width:100%;border-collapse:collapse\"\u003e\n\n\u003cthead\u003e\u003ctr style=\"background:#17324D;color:#fff\"\u003e\n\n\u003cth style=\"padding:10px;text-align:left\"\u003eFile\u003c\/th\u003e\n\n\u003cth style=\"padding:10px;text-align:left\"\u003eUsage\u003c\/th\u003e\n\n\n\u003c\/tr\u003e\u003c\/thead\u003e\n\n\u003ctbody\u003e\n\n\u003ctr\u003e\n\n\u003ctd style=\"padding:9px;border-bottom:1px solid #dae4ea\"\u003e\u003cstrong\u003eSemesterplanering 2027.xlsx\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd style=\"padding:9px;border-bottom:1px solid #dae4ea\"\u003eSix worksheets: overview, personnel, applications, daily summary, holidays, and instructions.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd style=\"padding:9px;border-bottom:1px solid #dae4ea\"\u003e\u003cstrong\u003eSemesteransökan \u0026amp; beslut.docx + .pdf\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd style=\"padding:9px;border-bottom:1px solid #dae4ea\"\u003eBilingual request and decision form: Swedish version and English reference translation.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd style=\"padding:9px;border-bottom:1px solid #dae4ea\"\u003e\u003cstrong\u003eAnvändarguide.docx + .pdf\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd style=\"padding:9px;border-bottom:1px solid #dae4ea\"\u003eStep-by-step, Annual Leave Act checklists, common mistakes, GDPR, and an English quick guide.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\n\u003c\/tbody\u003e\n\n\n\u003c\/table\u003e\n\n\u003cp\u003e\u003cstrong\u003eTotal:\u003c\/strong\u003e five delivery files in a ZIP. The documents can be edited locally and used offline.\u003c\/p\u003e\n\n\u003ch2 id=\"mb-excel\"\u003eWhat does the Excel template do?\u003c\/h2\u003e\n\n\u003cul\u003e\n\n\u003cli\u003eRegister up to \u003cstrong\u003e50 employees\u003c\/strong\u003e and \u003cstrong\u003e150 leave requests\u003c\/strong\u003e.\u003c\/li\u003e\n\n\u003cli\u003eTrack which holiday requests are requested, approved, denied, or withdrawn.\u003c\/li\u003e\n\n\u003cli\u003eCalculate planned weekdays considering an editable list of holidays and equivalent days.\u003c\/li\u003e\n\n\u003cli\u003eIdentify overlapping \u003cstrong\u003eapproved periods\u003c\/strong\u003e for the same person.\u003c\/li\u003e\n\n\u003cli\u003eShow, day by day, how many office employees are in the planning base and how many have approved leave.\u003c\/li\u003e\n\n\u003cli\u003eSet your own minimum staffing level and highlight weekdays that fall below this level.\u003c\/li\u003e\n\n\u003cli\u003eGet a month-by-month overview, without macros or subscriptions.\u003c\/li\u003e\n\n\n\u003c\/ul\u003e\n\n\u003cdiv style=\"background:#fff3d7;border-left:5px solid #d2a94c;padding:14px\"\u003e\n\n\u003cstrong\u003eImportant limitation:\u003c\/strong\u003e The workbook is intended for simple Monday–Friday office planning. It does not calculate holiday pay, holiday compensation, qualifying years, net holiday days for irregular working hours, working hours, or actual production capacity. Approval and legal checks must be performed by the employer.\u003c\/div\u003e\n\n\u003ch2 id=\"mb-sa\"\u003eHow to use the package\u003c\/h2\u003e\n\n\u003col\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eCreate the personnel register:\u003c\/strong\u003e enter names or employee IDs, teams, and employment type. Mark relevant office employees as active.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eCollect requests:\u003c\/strong\u003e use the Word form and register the desired leave periods in Excel.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eReview scheduling:\u003c\/strong\u003e consider personnel needs, consultations, the Annual Leave Act, applicable collective agreements, and individual employment terms.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eDocument decisions:\u003c\/strong\u003e fill in approved or denied status and decision date. Mark the request as \"Approved\" in Excel when the decision is final.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eFollow up on staffing:\u003c\/strong\u003e set the minimum level and review days marked BELOW MINIMUM.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eSave securely:\u003c\/strong\u003e manage access and disposal according to the employer's data protection procedures.\u003c\/li\u003e\n\n\n\u003c\/ol\u003e\n\n\u003ch2\u003eTypical use cases\u003c\/h2\u003e\n\n\u003cp\u003ePlanning for summer holidays, holiday distribution between departments, holiday requests in small companies, holiday coordination in finance departments and administrative teams, documentation of approval, and preparation of staffing levels before periods of high leave.\u003c\/p\u003e\n\n\u003ch2 id=\"mb-juridik\"\u003eThe Annual Leave Act and personal data\u003c\/h2\u003e\n\n\u003cp\u003eThe Annual Leave Act (1977:480) specifies, among other things, a standard right to 25 days of holiday, the baseline for the holiday year, obligations regarding holiday scheduling, and provisions regarding notice and main holiday periods. According to Section 12, the baseline is at least four consecutive weeks during June–August unless otherwise agreed, with exceptions as provided by law. Scheduling may also be affected by collective agreements, negotiations, and individual circumstances.\u003c\/p\u003e\n\n\u003cp\u003eInformation regarding employees' holidays and other leave is personal data. \u003cstrong\u003eDo not register diagnoses or sensitive health information\u003c\/strong\u003e in a generally accessible planning file. Secure the document, restrict access, and determine necessary retention periods.\u003c\/p\u003e\n\n\u003ch3\u003eOfficial sources\u003c\/h3\u003e\n\n\u003cul\u003e\n\n\u003cli\u003e\u003ca href=\"https:\/\/www.riksdagen.se\/sv\/dokument-och-lagar\/dokument\/svensk-forfattningssamling\/semesterlag-1977480_sfs-1977-480\/\"\u003eThe Riksdag – Annual Leave Act (1977:480)\u003c\/a\u003e\u003c\/li\u003e\n\n\u003cli\u003e\u003ca href=\"https:\/\/verksamt.se\/personal-rekrytering\/ledighet\/semester-semesterdagar\"\u003eVerksamt – holiday and holiday days\u003c\/a\u003e\u003c\/li\u003e\n\n\u003cli\u003e\u003ca href=\"https:\/\/www.imy.se\/verksamhet\/dataskydd\/dataskydd-pa-olika-omraden\/arbetsliv\/tillaten-behandling--vilka-krav-galler\/grundlaggande-principer\/\"\u003eIMY – data protection in working life\u003c\/a\u003e\u003c\/li\u003e\n\n\n\u003c\/ul\u003e\n\n\u003ch2 id=\"mb-faq\"\u003eFrequently asked questions\u003c\/h2\u003e\n\n\u003ch3\u003eCan I use it for 2027 immediately?\u003c\/h3\u003e\n\n\u003cp\u003eYes. The Excel workbook's daily summary and adjustable holiday list refer to the 2027 calendar year.\u003c\/p\u003e\n\n\u003ch3\u003eDoes the file calculate how many holiday days someone is entitled to?\u003c\/h3\u003e\n\n\u003cp\u003eNo. It shows a planning template for weekdays, not legal holiday calculation, net holiday, or holiday pay.\u003c\/p\u003e\n\n\u003ch3\u003eDoes the template work for shift work and part-time employment?\u003c\/h3\u003e\n\n\u003cp\u003eThe application form can be adapted. However, the Excel calculation should not be used as a correct working time or net holiday calculation for shifts or intermittent work.\u003c\/p\u003e\n\n\u003ch3\u003eIs an English version included?\u003c\/h3\u003e\n\n\u003cp\u003eYes. The form includes an English reference translation and the guide includes an English summary. The Excel workbook is in Swedish and adapted to Swedish conditions.\u003c\/p\u003e\n\n\u003ch3\u003eDo I need software?\u003c\/h3\u003e\n\n\u003cp\u003eExcel\/Office or compatible alternatives are required for editing. The PDF can be read and printed separately. For full compatibility with formulas, Microsoft Excel is recommended.\u003c\/p\u003e\n\n\u003ch3\u003eAre the files completed legal decisions?\u003c\/h3\u003e\n\n\u003cp\u003eNo. They are editable work templates. An authorized employer must decide, verify applicable rules, and document the correct information.\u003c\/p\u003e\n\n\u003ch2\u003eFormat, delivery, and related categories\u003c\/h2\u003e\n\n\u003cp\u003eDigital download – a ZIP package with five editable\/searchable files. No physical item and no shipping. Feel free to take a look at more \u003ca href=\"\/en\/collections\/hr-arbetsratt-visselblasning-mallar\"\u003eHR and labor law templates\u003c\/a\u003e as well as \u003ca href=\"\/en\/collections\/mallar-for-aktiebolag\"\u003ecompany templates\u003c\/a\u003e.\u003c\/p\u003e\n\n\u003cp\u003e\u003csmall\u003eMallbutiken.se · Version 1.0 · Source check 2026-10-12 · Planning year 2027.\u003c\/small\u003e\u003c\/p\u003e\n\n\u003c\/section\u003e","brand":"Svenska Dokumentmallar","offers":[{"title":"Default Title","offer_id":55710733402454,"sku":"SEMESTERPLANERING-BEMANNING-2027","price":79.0,"currency_code":"SEK","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0827\/2373\/3846\/files\/semesterplanering-bemanning-2027-hero.png?v=1791790013","url":"https:\/\/mallbutiken.se\/en\/products\/semesterplanering-bemanningsoversikt-2027-excel-word-pdf","provider":"Mallbutiken","version":"1.0","type":"link"}