nessus_tracker/CHANGELOG.md

Changelog

2026-02-26

• Added scripts/build_2026_tracker_workbook.py to build 2026_Nessus_Remediation_Tracker.xlsx with:
  • Intro sheet copied from OLD_Tracker.xlsx
  • current generated Remediations and Template sheets
  • month sheets (January..December) cloned from Template
  • exclusion of CVETracker, testing, and historical month CVE data
• Updated 2026 workbook generation to preserve Intro in-place from OLD_Tracker.xlsx (including original sheet outline/formatting fidelity).
• Set freeze panes to A2 on Template and all month sheets in 2026_Nessus_Remediation_Tracker.xlsx.
• Added WIKI.md quick usage guide with setup, workbook workflow, key formats, validation, and push/mirror steps.
• Simplified Remediations status options to exception, exception - permanent, in-progress variants, and resolved.
• Added Excepted until (date) to Remediations and Template, with overdue-date highlighting (red) when the date has passed.
• Added First seen to Remediations and Unresolved for to Template (days since first seen when first seen is before today).
• Fixed Template key lookup to match CVEs even when Remediations CVE cells include extra leading/trailing spaces.
• Updated key-driven Template formulas to return blank for missing source values (including exception date) instead of displaying Excel zero-date artifacts.
• Fixed malformed Template Unresolved for formula that caused Excel to remove formula records from sheet2.xml during file recovery.
• Fixed Template key lookup regression for numeric Plugin ID keys by matching Plugin IDs with numeric-first fallback logic.
• Added repository policy in AGENTS.md requiring blank output for missing key-driven auto-populated values.
• Updated scripts/build_tracker_workbook.py default seed rows for the new column layout and status set.
• Updated README.md workbook column definitions and behavior notes for exception dates and unresolved metrics.

2026-02-24

• Switched workbook generation to openpyxl in scripts/build_tracker_workbook.py.
• Kept Remediations and Template structure and matching logic (CVE first, then Plugin ID).
• Added repository baseline directives in AGENTS.md for git workflow, changelog updates, and workbook validation.
• Updated README.md with dependency and generation instructions.
• Updated template formulas so rows stay blank when both CVE and Plugin ID are empty.
• Updated template formulas so NEW ITEM appears only when an entered CVE/Plugin ID is unmatched.
• Made Template Name cells hyperlink to the matched Remediations row.
• Added Severity and Status dropdown validations on Remediations.
• Added severity/status conditional formatting on both Remediations and Template.
• Switched Template lookup flow to key-driven input (manual Key in column A).
• Added key normalization for lookup (CVE:..., PID:..., or raw value).
• Auto-populated both CVE and Plugin ID in Template when key match is found.
• Updated auto-populated Template CVE display to show n/a when a matched remediation row has no CVE value.
• Protected Template sheet so only Key, Hosts, and Owner cells are editable in data rows.
• Updated template scan note formulas to preserve blanks from Remediations instead of displaying 0.
• Seeded the generator with the current Remediations entries as default test data.
• Enabled word wrap for Name/Description/notes columns in Remediations and Name/notes columns in Template.
• Switched workbook write to atomic temp-file replacement to prevent partially written/corrupt .xlsx outputs.
• Expanded status options to exception/in-progress variants and removed nofix.
• Updated status conditional formatting rules to color any exception* as blue, any in progress* as yellow, and resolved as green.
• Updated README.md dependency requirements and install instructions (apt + pip).
• Updated AGENTS.md to require dependency documentation updates when module requirements change.