# Final Submission Checklist — verified 13 October 2026

| # | Faculty requirement | Status | Evidence |
|---|---|---|---|
| 1 | Title | PRESENT | PDF/DOCX §1 |
| 2 | Problem statement | PRESENT | §2 |
| 3 | Objectives | PRESENT | §3 |
| 4 | Dataset details | PRESENT | §4, source evidence |
| 5 | Accounting calculations | VERIFIED | §5, all row cost/margin formulas checked |
| 6 | Data preparation | VERIFIED | §6, 9,994 rows reconciled |
| 7 | Actual Looker dashboard | VERIFIED | Public URL opens; real Sheets source |
| 8 | Four LIVE KPI cards | VERIFIED | Saved field settings, correct USD/Percent, Technology and 2017 filter tests |
| 9 | Required financial charts | PRESENT | Figures 1–4; existing Looker charts also preserved and functional |
| 10 | Genuine dashboard screenshots | VERIFIED | New dashboard 05/06/08/09/10 captures; historical screenshots preserved |
| 11 | Interpretation | PRESENT | §11 |
| 12 | 3–5 supported recommendations | PRESENT | Five recommendations in §12; savings are scenarios |
| 13 | Conclusion | PRESENT | §13 |
| 14 | References | PRESENT | §14, Sources_and_Verification.md |

| Deliverable / QA | Status |
|---|---|
| FCA_Portfolio_Final.pdf | VERIFIED: five pages, all 14 sections, seven visible figures, Times New Roman; every page visually reviewed |
| FCA_Portfolio_Editable.docx | VERIFIED: ten rendered pages visually reviewed; 14 sections, seven figures, corrected screenshot relationships and clean table pagination |
| Handwritten_Journal_Content.docx | VERIFIED: two rendered pages visually reviewed; 14 sections, Times New Roman headings and clean page breaks |
| FCA_Accounting_Data.xlsx | VERIFIED: nine sheets; saved results; 20,376 existing formula caches; all nine validation rows PASS |
| FCA_Looker_Source.csv | VERIFIED: original/raw and cleaned totals reconcile; 9,994 rows |
| Dashboard values | VERIFIED: $2,297,200.86 revenue; $2,010,803.84 derived cost; $286,397.02 profit; 12.47% aggregate margin |
| Dashboard filter response | VERIFIED: Technology and 2017 date ranges match independent CSV calculations |
| Dashboard charts | VERIFIED public rendering; original dimensions retained and accurately described |
| Sharing | VERIFIED: Unlisted Viewer public-link permission saved and verified; owner remains Owner |
| Static KPI text / test clutter | REMOVED; four genuine cards remain |
| Accounting limitations | RETAINED: cost derived; no numerical BEP without fixed/variable costs; fictitious sample |
| Backups | Original deliverables/screenshots in backups/2026-10-13_before_completion/ |
| Evidence index / provenance / README / link | UPDATED |

## Completion status
No remaining portfolio tasks. Every PDF and DOCX page was visually reviewed. DOCX pagination was checked with Aspose.Words 26.9 after the missing LibreOffice renderer was replaced by this alternative. Evaluation watermarks are limited to internal QA previews; delivered Word files and the final PDF contain none.

The screenshot relationships in the DOCX were verified by exact comparison with the final capture files. Historical screenshots remain unchanged. All 14 faculty sections, accounting limitations and references are retained. The complete package is `FCA_Submission_Ready.zip`, with a file-hash inventory in `Submission_Manifest.json`.