| Col | Spreadsheet Header | POA&M Tracker Field | Required | Sample Value | |
|---|---|---|---|---|---|
| B | POAM ID | → | Mandatory | V-0142-AC(2) | |
| C | Controls | → | Mandatory | RA-5, SC-13 | |
| D | Weakness Name | → | Mandatory | Red Hat Update for glibc security | |
| E | Weakness Description | → | Mandatory | The remote host contains one or more… | |
| F | Weakness Detector Source | → | Mandatory | Tenable Nessus | |
| H | Asset Identifier | → | Mandatory | 172.246.15.3 (80/TCP) | |
| I | Point of Contact | → | Mandatory | John Doe — Example CSP | |
| R | Original Risk Rating | → | Mandatory | Moderate | |
| X | Supporting Documents | → | Situational | \\fileshare\poam\evidence\0142.pdf | |
| Z | BOD 22-01 tracking | → | Situational | Yes | |
| AB | CVE | → | Situational | CVE-2026-0714 |
| Row | Severity | Column | Issue | Resolution |
|---|---|---|---|---|
| 31 | Error | POAM ID | Duplicate of row 18 — V-0087-SI(2) already appears in this sheet | |
| 44 | Error | Original Risk Rating | Value “Critical” is not in the template list (Low, Moderate, High) | |
| 52 | Error | Scheduled Completion Date | Not a valid date — cell contains “TBD” | |
| 67 | Warning | Point of Contact | “A. Sandoval” does not match any user in this organization | |
| 89 | Warning | Asset Identifier | Asset 10.42.9.6 is not present in the Integrated Inventory Workbook | |
| 104 | Warning | Deviation Rationale | Risk adjustment is “Yes” but no rationale was supplied |
Produce a submission-ready workbook in the same template, with the Open, Closed and Configuration Findings worksheets populated.