Module 2 — Make the 5S Audit Smart: Checkboxes, Scoring & Radar Charts
This guide explains Module 2 in simple English. If you haven’t watched Module 1 yet, start there. This module shows how to add checkboxes, turn them into scores, and build a radar chart to display the five 5S areas clearly.
What This Module Covers
You will turn your checklist into a working audit tool. You will add checkboxes, convert them into numbers using the IF formula, calculate totals, and create a radar chart to visualize performance.
Why This Helps
Checkbox scoring saves time and gives consistent results. Radar charts show all five 5S categories in one view — perfect for reports and team reviews.
Step-by-Step Tasks
- Insert checkboxes next to each checklist item.
- Link each checkbox to a nearby cell (TRUE/FALSE output).
- Use an IF formula to convert TRUE to 1 and FALSE to 0:
=IF(D5=TRUE,1,0) - Copy the formula down the scoring column.
- Sum scores for each 5S phase using:
=SUM(E5:E24) - Create the Radar Chart using your five phase totals.
- Polish the chart: remove background, choose colours, set clean labels.
Useful Formulas
=IF(D5=TRUE,1,0)=SUM(E5:E24)=COUNTIFS(D5:D24,TRUE)Troubleshooting
Check these if something doesn’t work:
- Checkbox must be linked to a cell.
- Formula references must be correct when copied.
- Radar chart must point to the correct score range.
Thumbnail Text & Design Tips
Excel 5S Audit Automation
Checkboxes → Scoring → Radar
Design:
- Bold font (white on dark blue)
- Add small Excel icon
- Add a small “Module 2” badge
- Size: 1280×720 px
Short Description
Module 2 shows how to turn your 5S checklist into a scoring system using checkboxes and simple formulas. You’ll also create a radar chart to display results across the five 5S phases. Watch Module 1 first to learn the basic layout.
Call to Action
If you want the same Excel file used in the video or want your own department-specific version, comment with your team name and I’ll share it.
Comments