Open a workbook to enable editing. Auto-save is enabled.v9.1
Change notes
v9.1: Added Microsoft Entra ID SSO with MSAL, delegated Microsoft Graph access, cloud workbook loading, and direct Excel range updates.
v9.0: Promoted the custom slide builder, workbook visibility controls, and Excel-safe image configuration export to the v9.0 release.
v8.7.1: Fixed Excel configuration export for embedded images by splitting image data into Excel-safe chunks on a separate Custom_Slide_Images worksheet.
v8.6.2: Project Metrics & Overview now uses only Active, Paused, and Closed project icons. Paused and Closed rows receive subtle status shading and a matching left accent.
v8.6.1: Baseline Date, Planned Date, and Date Closed now display recognized dates as mm/dd/yyyy while preserving non-date text such as NA, TBD, Pending, or Week of 8/31.
v8.6: Restored the official VMware logo from the provided vmWareLogo.png asset.
v8.4: Updated the Excel icon with an upload arrow and updated the PDF icon to display PDF lettering.
v8.3: Removed the manual Save Workbook button; workbook edits continue to use the existing automatic save workflow.
v8.3: Replaced the Open Workbook and Export PDF text buttons with compact Excel and PDF icons.
v8.2: Corrected the workbook XML cell-type replacement that could create duplicate type attributes and cause Excel to repair or reject the saved workbook.
v8.2: Added package validation before the original workbook can be overwritten.
v8.1: Restored the original report styling. Editable values display normally and open an inline editor only when clicked.
v8.1: Workbook saves now patch only changed cell XML inside the original file package, preserving workbook formatting, formulas, validations, merges, and other workbook content.
v8.0: Project Status and RAID slides are editable and auto-save to the opened workbook.
v8.0: Pick-list fields use workbook-aligned options; calculated fields and Challenges/Decisions remain read-only.
v7.7: Project Timeline replaced with a Smartsheet-style Roadmap/Gantt view.
Roadmap now uses milestone status normalization aligned with the Artifact/Objectives Status column.
Roadmap KPI and legend updated to use Canceled milestones instead of At Risk.
Program report table widths tuned to prioritize Notes.
VMware logo restored in bottom-left footer.
Client status parsing corrected.
Project PDFs use the email subject as filename.
Project view uses a Share menu for Gmail/Outlook.
Gmail option downloads PDF and copies compose URL.
Program Reports now include a dynamic VCF Entitlement Pipeline slide sourced from the Jira Pipeline sheet.
Pipeline slide redesigned with modern KPI cards, status-driven colors, and opportunity cards.
Program dashboard RAG/status cells now render as theme-matched status circles.
Project report cover slide restyled to better match the original green Broadcom/VMware deck layout.
Program dashboard status cells restored to colored RAG blocks; Overall now displays normalized R/Y/G values.
Project report cover artwork simplified to two SVG paths: one main gradient fill and one clean green accent curve/line.
Email exports now use the selected project sheet for TO greeting and Project Manager signoff.
Project metadata parsing now avoids Communications Contacts rows so cover slides show the correct Project Manager.
Report date picker added; Program and Project cover dates, email subject lines, PDF output, and Project PDF filenames now use the selected local report date.
Email greetings now use the selected project sheet TO contact, prefer Client TO when available, and address only the recipient first name.
Project picker now keys selections by source worksheet so email exports use the correct project sheet contacts.
Email debug logging added to show selected project identity and parsed contacts during Gmail/Outlook export.
Contact parsing now continues through each project worksheet contact table so later Client TO rows, such as Eastman Phil Preast, are included.
Program Reports now separate dashboard narrative content from project metrics/overview table on a dedicated slide, with Risks added from Program_Dashboard.
Project Timeline page replaced with a Smartsheet-style Project Roadmap/Gantt view using Artifact/Objectives baseline and planned dates.
Roadmap metrics and legend now replace At Risk with Canceled, including a canceled milestone icon.
Roadmap status normalization fixed so Not Started values no longer classify as In Progress.