{"product_id":"oee-tak-maskineffektivitet-excel-mall-2026-2027","title":"OEE \u0026 TAK – Machine Efficiency 2026\/2027 | Excel, Shift Logs \u0026 Downtime Word\/PDF","description":"\u003csection class=\"mb-product-description\" lang=\"sv\"\u003e\n\u003cp\u003e\u003cstrong\u003eOEE \u0026amp; TAK – Machine Efficiency 2026\/2027\u003c\/strong\u003e is a practical document package for production managers, manufacturing companies, machine operators, and quality managers who want to analyze how planned production time is used. You receive a professional OEE calculator in Excel with a shift register, downtime log, machine register, action follow-up, and a clear dashboard. In addition, editable Word templates and printable PDFs are included for shift reports, measurement routines, and user instructions.\u003c\/p\u003e\n\n\u003cp\u003e\u003cstrong\u003eSEK 79, one-time purchase.\u003c\/strong\u003e No recurring fees. The tool works offline in compatible software but is not machine-integrated, an MES system, or an automatic alarm and safety system.\u003c\/p\u003e\n\n\u003cnav aria-label=\"About the document template\"\u003e\u003cstrong\u003eAbout the document template:\u003c\/strong\u003e \u003ca href=\"#oee-inne\"\u003eWhat's included\u003c\/a\u003e · \u003ca href=\"#oee-formel\"\u003eOEE formula\u003c\/a\u003e · \u003ca href=\"#oee-excel\"\u003eExcel\u003c\/a\u003e · \u003ca href=\"#oee-guide\"\u003eHow to use\u003c\/a\u003e · \u003ca href=\"#oee-faq\"\u003eFAQ\u003c\/a\u003e · \u003ca href=\"#oee-kallor\"\u003eSources\u003c\/a\u003e\u003c\/nav\u003e\n\u003cdiv style=\"background:#e7f4eb;border-left:4px solid #2A865C;padding:15px 18px;margin:18px 0;\"\u003e\n\n\u003cstrong\u003eProfessionally reviewed: October 9, 2026\u003c\/strong\u003e\u003cp\u003eVersion 1.0 – for 2026\/2027. The calculation principles have been verified against public OEE guides and the Swedish explanation of the TAK method. The templates are general work tools, not a certified measurement solution or an assessment of machine safety. ISO standard texts or claimed ISO certification are not included.\u003c\/p\u003e\n\n\n\u003c\/div\u003e\n\n\u003ch2 id=\"oee-inne\"\u003eWhat is included in the package\u003c\/h2\u003e\n\n\u003ctable\u003e\n\n\u003cthead\u003e\u003ctr\u003e\n\n\u003cth\u003eDocument or tool\u003c\/th\u003e\n\n\u003cth\u003eContent\u003c\/th\u003e\n\n\u003cth\u003eFormat\u003c\/th\u003e\n\n\n\u003c\/tr\u003e\u003c\/thead\u003e\n\n\u003ctbody\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eOEE\/TAK – measurement routine\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eDefinitions, scope, responsibilities, measurement method, control points, and version control.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eShift log \u0026amp; downtime\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eShift ID, time data, production volumes, causes of stoppages, calculation verification, and decided improvements.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eSeparate user guide\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eStep-by-step instructions for all Excel sheets, a realistic calculation example, data quality, pitfalls, checklist, and sources.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eOEE – Shift Working Sheet (English)\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eSupplementary English shift worksheet for staff in Swedish operations – not a complete translation of all documents.\u003c\/td\u003e\n\n\u003ctd\u003eWord + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eOEE \u0026amp; TAK in Excel\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eSix sheets for machines, shift data, downtime, actions, instructions, and a dashboard with calculated KPIs.\u003c\/td\u003e\n\n\u003ctd\u003eExcel (XLSX)\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 of nine files:\u003c\/strong\u003e four Word (DOCX), four searchable A4-PDFs, and one Excel (XLSX), gathered in a ZIP file. Swedish is the primary language with an English working template as a supplement.\u003c\/p\u003e\n\n\u003ch2\u003eWho is the OEE template for?\u003c\/h2\u003e\n\n\u003cp\u003eThe template is particularly useful for small and medium-sized \u003cstrong\u003eindustrial companies, CNC workshops, manufacturing operations, production managers, and quality teams\u003c\/strong\u003e who need to track recurring stoppages, pace deficiencies, and scrap rates across different shifts. It can be used both for the initial implementation of a simpler TAK workflow and as an additional analysis base for existing production follow-up.\u003c\/p\u003e\n\n\u003ch2 id=\"oee-formel\"\u003eHow do you calculate OEE\/TAK?\u003c\/h2\u003e\n\n\u003cp\u003e\u003cstrong\u003eOEE = Availability × Performance × Quality.\u003c\/strong\u003e The three factors must be calculated from the same machine and time period:\u003c\/p\u003e\n\n\u003cul\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eAvailability (A)\u003c\/strong\u003e = (planned production time − downtime) \/ planned production time.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003ePerformance (P)\u003c\/strong\u003e = (verified ideal time in seconds\/unit × total produced quantity) \/ (operating time in minutes × 60).\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eQuality (Q)\u003c\/strong\u003e = (total produced quantity − scrapped units) \/ total produced quantity.\u003c\/li\u003e\n\n\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eCalculation example:\u003c\/strong\u003e Planned production time 420 minutes, downtime 42 minutes, ideal time 30 seconds per unit, and 680 units produced, of which 20 are scrapped. Availability becomes 90.0%, performance approximately 89.95%, quality approximately 97.06%, and \u003cstrong\u003eOEE approximately 78.57%\u003c\/strong\u003e. In Excel, the calculation is performed automatically once the necessary information has been entered and the downtime follow-up has been approved.\u003c\/p\u003e\n\n\u003cdiv style=\"background:#fff4d6;border-left:4px solid #d9a13a;padding:15px 18px;margin:17px 0;\"\u003e\n\n\u003cstrong\u003eImportant:\u003c\/strong\u003e Performance exceeding 100 percent is usually a reason to check the ideal time, time units, stop definition, or production volume. In this case, the calculator will show a data warning instead of using a misleading OEE value. A universal “world-class limit” is not a legal requirement or an appropriate goal for all machines.\u003c\/div\u003e\n\n\u003ch2 id=\"oee-excel\"\u003eThe Excel tool – six interconnected worksheets\u003c\/h2\u003e\n\n\u003ctable\u003e\n\n\u003cthead\u003e\u003ctr\u003e\n\n\u003cth\u003eSheet\u003c\/th\u003e\n\n\u003cth\u003ePractical function\u003c\/th\u003e\n\n\n\u003c\/tr\u003e\u003c\/thead\u003e\n\n\u003ctbody\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eOverview\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eNumber of shifts, reviewed shifts, average OEE and its sub-factors, summed downtime minutes, data warnings, and open actions.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eMachines\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003e50 rows for machine ID, name, process, responsible person, and reference to ideal time.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eShift data\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003e120 rows with planned time, ideal time, volumes, scrap, and automatic OEE formula, plus data status check.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eDowntime\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003e180 rows for stop ID, shift ID, machine, cause, stop time, and performed action. Stop time is automatically summed to the matching shift.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eActions\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003e100 improvement issues with loss category, responsible person, target date, status, effect check, and evidence reference.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd\u003e\u003cstrong\u003eInstructions\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd\u003eDefinitions, correct time units, step-by-step usage, method limitations, and source references.\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\n\u003c\/tbody\u003e\n\n\n\u003c\/table\u003e\n\n\u003cp\u003eExcel uses a unique \u003cstrong\u003eShift ID\u003c\/strong\u003e to link shifts and downtime together. For example, you register a shift with ID \u003cem\u003eSK-2026-0001\u003c\/em\u003e and use the same ID for all stoppages within that shift. Once you have checked the downtime log, mark it as reviewed. Calculations only begin when there is sufficiently reliable data.\u003c\/p\u003e\n\n\u003cp\u003e\u003cstrong\u003ePlease note:\u003c\/strong\u003e The dashboard average consists of simple averages over shifts with approved data status, not a separately weighted total OEE for an entire factory. An incomplete shift will not receive a final OEE value. For comparisons, you must use a consistent definition of downtime, ideal time, and approved output.\u003c\/p\u003e\n\n\u003ch2 id=\"oee-guide\"\u003eHow to get started – step by step\u003c\/h2\u003e\n\n\u003col\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eDetermine the method:\u003c\/strong\u003e select the relevant machine, product, reporting period, and a consistent definition of planned production time.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eVerify ideal time:\u003c\/strong\u003e use a realistic and documented cycle time in seconds per unit for the correct process.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eCreate machine and shift IDs:\u003c\/strong\u003e use the same designation in all registers.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eEnter real shift data:\u003c\/strong\u003e minutes, total production, and scrap.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eRegister downtime:\u003c\/strong\u003e enter stop causes and stop time in the separate log with the correct Shift ID.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eReview data:\u003c\/strong\u003e confirm the downtime log and check the data status before drawing conclusions.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eIdentify main loss:\u003c\/strong\u003e compare availability, performance, and quality with previous, comparable periods.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eFollow up on improvements:\u003c\/strong\u003e document the action, responsibility, deadline, and actual measured effect.\u003c\/li\u003e\n\n\n\u003c\/ol\u003e\n\n\u003ch2\u003eCommon pitfalls\u003c\/h2\u003e\n\n\u003cul\u003e\n\n\u003cli\u003eMixing minutes and seconds in the pace and time data.\u003c\/li\u003e\n\n\u003cli\u003eExcluding changeover time in some shifts but including it in others.\u003c\/li\u003e\n\n\u003cli\u003eRegistering the same downtime multiple times.\u003c\/li\u003e\n\n\u003cli\u003eCounting reworked units as approved without a documented and consistent definition.\u003c\/li\u003e\n\n\u003cli\u003eTreating high OEE as proof of safe operation, sufficient staffing, or high economic profitability.\u003c\/li\u003e\n\n\u003cli\u003eStating an improvement as verified without new measurement data.\u003c\/li\u003e\n\n\n\u003c\/ul\u003e\n\n\u003ch2\u003eOEE and legal or technical requirements\u003c\/h2\u003e\n\n\u003cp\u003eOEE\/TAK is a method for production follow-up – \u003cstrong\u003enot a general statutory KPI\u003c\/strong\u003e for all Swedish companies. The ISO 22400 series can provide support for terminology and KPIs in production, but protected standard text is not included here. The calculator does not replace work environment risk assessments, machine safety requirements, product control, certification, or industry-specific obligations.\u003c\/p\u003e\n\n\u003ch2 id=\"oee-faq\"\u003eFrequently asked questions\u003c\/h2\u003e\n\n\u003ch3\u003eWhat are OEE and TAK?\u003c\/h3\u003e\n\n\u003cp\u003eOverall Equipment Effectiveness, often called TAK in Swedish operations, is a combined measure of availability, performance, and quality during defined production time.\u003c\/p\u003e\n\n\u003ch3\u003eIs an OEE calculator in Excel better than a full MES system?\u003c\/h3\u003e\n\n\u003cp\u003eThey are different solutions. This product is affordable and stand-alone for manual follow-up, but it does not automatically collect data from machines and does not include real-time monitoring or advanced production control.\u003c\/p\u003e\n\n\u003ch3\u003eWhat do I do if my OEE is displayed as empty?\u003c\/h3\u003e\n\n\u003cp\u003eCheck if the Shift ID, planned time, ideal time, volumes, scrap, and downtime log are complete, and if the downtime log is marked as reviewed. Also, check if an incorrect cycle time value has been flagged.\u003c\/p\u003e\n\n\u003ch3\u003eIs downtime analysis included?\u003c\/h3\u003e\n\n\u003cp\u003eYes. A separate log can register multiple stops per shift and compile stop time into the shift calculation. Cause and action can be documented separately.\u003c\/p\u003e\n\n\u003ch3\u003eCan the tool be used for different machines?\u003c\/h3\u003e\n\n\u003cp\u003eYes. The machine register has space for 50 machines and the shift register for 120 shifts. The exact same measurement definitions should be used when comparing results.\u003c\/p\u003e\n\n\u003ch3\u003eAre there English files available?\u003c\/h3\u003e\n\n\u003cp\u003eYes, an English shift worksheet is included as a supplement for Swedish operations. The main documents and the user guide are in Swedish.\u003c\/p\u003e\n\n\u003ch3\u003eAre the PDF files editable forms?\u003c\/h3\u003e\n\n\u003cp\u003eThe Word documents are editable. The PDF files are searchable and printable but are not supplied as interactive, fillable AcroForm forms.\u003c\/p\u003e\n\n\u003ch2\u003eFormat and digital delivery\u003c\/h2\u003e\n\n\u003cp\u003ePrice \u003cstrong\u003eSEK 79\u003c\/strong\u003e. Digital ZIP with \u003cstrong\u003e4 DOCX, 4 PDF, and 1 XLSX\u003c\/strong\u003e. No physical shipping. Automated customer delivery in Shopify assumes that the ZIP file has been correctly linked to the product variant in Digital Products.\u003c\/p\u003e\n\n\u003ch2 id=\"oee-kallor\"\u003eMethod sources\u003c\/h2\u003e\n\n\u003cul\u003e\n\n\u003cli\u003e\u003ca href=\"https:\/\/www.oee.com\/calculating-oee\/\"\u003eOEE.com – Calculate OEE\u003c\/a\u003e\u003c\/li\u003e\n\n\u003cli\u003e\u003ca href=\"https:\/\/www.oee.com\/oee-factors\/\"\u003eOEE.com – Availability, Performance, Quality\u003c\/a\u003e\u003c\/li\u003e\n\n\u003cli\u003e\u003ca href=\"https:\/\/goodsolutions.se\/artiklar\/vad-%C3%A4r-oee-och-hur-ber%C3%A4knas-det\"\u003eGood Solutions – Vad är OEE och hur beräknas det?\u003c\/a\u003e\u003c\/li\u003e\n\n\n\u003c\/ul\u003e\n\n\u003ch2\u003eRelated documents\u003c\/h2\u003e\n\n\u003cp\u003eFor forward-looking capacity planning: \u003ca href=\"\/en\/products\/produktionsplanering-kapacitetskalkyl-excel-2026-2027\"\u003eProduction Planning \u0026amp; Capacity Calculator\u003c\/a\u003e. For scheduled machine maintenance: \u003ca href=\"\/en\/products\/maskinregister-forebyggande-underhall-excel-2026-2027\"\u003eMachine Register \u0026amp; Preventive Maintenance\u003c\/a\u003e. For preventive process risks: \u003ca href=\"\/en\/products\/fmea-feleffektanalys-mall-excel-2026-2027\"\u003eFMEA – Failure Mode and Effects Analysis\u003c\/a\u003e.\u003c\/p\u003e\n\n\u003cp\u003e\u003csmall\u003eDisclaimer: This is a general documentation and calculation tool, not a safety certification, site inspection, or guarantee of production, work environment, or quality requirements. Adapt the measurement method and usage to your operation's actual conditions.\u003c\/small\u003e\u003c\/p\u003e\n\n\u003c\/section\u003e\n\u003csection class=\"mallbutiken-related-guide\" aria-label=\"Related guide\"\u003e\u003ch2\u003eDeepen your knowledge with our guides\u003c\/h2\u003e\n\n\u003cp\u003eGet formulas and examples for availability, performance, and quality.\u003c\/p\u003e\n\n\u003cp\u003e\u003ca href=\"\/en\/blogs\/foretag\/oee-tak-berakna-maskineffektivitet\"\u003eHow to calculate OEE and TAK\u003c\/a\u003e\u003c\/p\u003e\n\n\u003cp\u003e\u003ca href=\"\/en\/blogs\/foretag\/produktion-kvalitetsledning-guide-mrp-oee-fmea-8d\"\u003eOverview: production control and quality management\u003c\/a\u003e\u003c\/p\u003e\u003c\/section\u003e","brand":"Svenska Dokumentmallar","offers":[{"title":"Default Title","offer_id":55655149994326,"sku":"OEE-TAK-2027","price":79.0,"currency_code":"SEK","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0827\/2373\/3846\/files\/01_OEE_TAK_Huvudbild_2027_51289ab4-d8b8-4688-985b-e30944f7dc3c.png?v=1791503038","url":"https:\/\/mallbutiken.se\/en\/products\/oee-tak-maskineffektivitet-excel-mall-2026-2027","provider":"Mallbutiken","version":"1.0","type":"link"}