Supply Chain Audit Tracker In Excel

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.

Module 1 — Start from Basics Module 2 — Watch Video

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

1. Insert checkboxes next to each checklist item.
2. Link each checkbox to a nearby cell (TRUE/FALSE output).
3. Use an IF formula to convert TRUE to 1 and FALSE to 0:
   =IF(D5=TRUE,1,0)
4. Copy the formula down the scoring column.
5. Sum scores for each 5S phase using:
   =SUM(E5:E24)
6. Create the Radar Chart using your five phase totals.
7. Polish the chart: remove background, choose colours, set clean labels.

Useful Formulas

Convert checkbox to score
=IF(D5=TRUE,1,0)

Sum phase score
=SUM(E5:E24)

Count checked items
=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

Text (large, two lines):
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.

Start with Module 1 Watch Module 2

All rights reserved. Discover Talent.