Track moisture-sensitive component floor life across your production floor. Color-coded status dashboard, bake event logging, ambient RH correction, and automatic floor life recalculation. All per J-STD-033D.
Daily status overview. KPI counters for active, OK, caution, warning, and expired reels. Full reel table with color-coded floor life remaining. Open this in the morning.
Main data entry sheet. Log Reel ID, description, MSL level, opened date and time, and ambient RH. Everything else calculates automatically: adjusted floor life, hours exposed, hours remaining, and status.
Record bake events by Reel ID, start and end date and time, package body thickness, and bake temperature. Required bake time is looked up automatically from J-STD-033D Table 4-1. Floor life is restored only when the actual bake meets or exceeds the required time. The Reel Log updates immediately.
J-STD-033D tables embedded in the workbook: floor life by MSL level, RH correction multipliers, and required bake times for 40 C and 125 C bake options.
Go to the Reel Log sheet (blue tab). Find the first empty row. Enter the Reel ID in column A exactly as it appears on the label. You will need this ID again if you log a bake, so keep it consistent.
Click column B and select the MSL level from the dropdown. The value comes from the component datasheet or the label on the dry pack bag. Valid levels are 1, 2, 2a, 3, 4, 5, 5a, and 6. Base floor life calculates automatically from this selection.
Press Ctrl+; to insert today's date, then press Space, then type the current time manually, for example 14:30. Finnish and other European locales may use a dot separator, e.g. 14.30. Both work. Press Enter to confirm. The floor life countdown starts from this moment.
Type the relative humidity percentage in your production area. The workbook applies the J-STD-033D Table 5-2 correction automatically. At 40% RH you get 1.5x floor life. At or below 10% RH you get 5x. Leave it blank and the calculation defaults to the standard 60% RH condition.
Open the file and go to the Dashboard sheet (green tab). It recalculates the moment the file opens. The KPI boxes at the top give you a count by status. Scroll down for the full reel table. Any orange or red rows need action before production starts.
Go to the Bake Log sheet (orange tab). Enter the Reel ID in column A exactly as it appears in the Reel Log. Enter the bake start date and time, then the end date and time. Select the package body thickness from the dropdown in column F and the bake temperature from the dropdown in column G. The workbook looks up the required bake time from J-STD-033D Table 4-1. If actual bake time meets or exceeds the required time, full floor life is restored. A short bake grants nothing.
When a reel is fully used, select the entire row in the Reel Log and press Delete. This removes it from the Dashboard count and keeps the active reel list clean. The bake history in the Bake Log can stay as a permanent record.
The workbook is fully unlocked. Every shop tracks slightly different information, and there is no reason to work around a fixed template. Common additions people make include a component description or MPN column, a storage location or shelf number, a supplier or lot code field, and a responsible operator name on the Reel Log. If your process requires it, add it.
The only columns that must stay in place are Reel ID (A), MSL Level (B), and Opened Date & Time (C) in the Reel Log, and Reel ID (A) in the Bake Log. All formulas and cross-sheet lookups depend on these positions. Add new columns to the right of the existing ones, or insert them between input columns before the formula columns start at E. Do not insert columns between the formula columns or shift them left of their current positions.
Standards basis: All floor life values, RH correction multipliers, and bake recovery times are taken directly from J-STD-033D (IPC/JEDEC Joint Standard for Handling, Packing, Shipping and Use of Moisture/Reflow Sensitive Surface Mount Devices). The workbook embeds the relevant tables in the Reference sheet so you can verify any value without leaving Excel.