Oxaide sample — Excel audit & clean • Private research desk • brief@oxaide.com • UEN 201806463W • Research, not advice

F1 | Audited table D3:N3,D12:N12,D17:N17,D23:N23,D29:N35 (orig rows 3,12,17,23,29-35) | ISSUE: zero formulas in source file; all 132 subtotal/total cells are typed-in values | FIX: replaced with own-column formulas (e.g. D3=SUM(D4:D9), D35=SUM(D29:D34)); recomputed values match typed-ins all 11 years
F2 | Audited table row 28 D28:N28 (orig 'TOTAL MOTOR VEHICLES') | ISSUE: caption row completely blank; real grand total sits at row 35 under second caption | FIX: D28:N28 now link to row 35 (=D35..=N35) so both captions agree
F3 | Audited table D2:N2 (orig year headers '2015'..'2025') | ISSUE: years stored as text, breaking year arithmetic and numeric-year lookups | FIX: converted to numbers 2015-2025 with 0 format; header shaded ink
F4 | Audited table A3, A23 (orig '1', '6') | ISSUE: index column mixes text (A3,A23) with numbers (A10-A12,A17,A28) | FIX: A3,A23 stored as numbers 1 and 6
F5 | Audited table B7,B8 (orig '(iv)','(v)') | ISSUE: numbering mixes parenthesised (iv),(v) with plain i),ii),iii),vi) in one list | FIX: unified to iv), v)
F6 | Audited table C9,B12,B23 (orig 'Off peak cars 1','GOODS AND OTHER VEHICLES 2','TAX EXEMPTED VEHICLES 3') | ISSUE: footnote digits baked into labels so exact-match lookups vs data.gov.sg labels fail | FIX: digits removed from labels; pointers added in column O
F7 | Audited table A1,C6,B36 (orig title + 'Tuition cars ' + 'Note : ') | ISSUE: trailing/stray spaces; 'Tuition cars ' fails exact match vs data.gov.sg 'Tuition cars' | FIX: trimmed to 'MOTOR VEHICLE POPULATION BY VEHICLE TYPE','Tuition cars','Note:'
F8 | Labels rows 3/10/11/12/17/23 vs rows 29-34 vs data.gov.sg | ISSUE: same concepts spelled several ways (& vs and, ALL-CAPS vs Title Case); 'Private Hire Cars' workbook-only | FIX: LTA wording preserved; mapping table added on Findings sheet rows 24-32; match by row/category not raw text
F9 | Audited table C25 vs B11 (orig 'Motorcycles and scooters' vs 'MOTORCYCLES & SCOOTERS') | ISSUE: one-letter case gap separates tax-exempt row (488 vehicles, 2024) from the 147,395-vehicle class; case-insensitive match merges them | FIX: wording kept; pink flag + column-O warning added; always filter by row/category
F10 | Audited table rows 3:35 and 29:35 | ISSUE: double-count trap; section 7 re-slices same fleet: 2024 SUM(3:35)=3,867,864 (3.84x true 1,007,094), SUM(29:35)=2x true | FIX: total formulas sum parts only; warning on sheet; never sum a full column
F11 | Whole sheet (orig no freeze, no print footer) | ISSUE: year row scrolls away; printouts carry no source line | FIX: panes frozen at D3; print footer with source REF on every sheet
F12 | Coverage workbook 2015-2025 vs data.gov.sg 2005-2024 | ISSUE: version drift; workbook adds 2025 (ALL 1,012,023) but drops 2005-2014; 'Rental cars' ends 2012 in API history, two Private Hire rows start 2013 | FIX: 2025 kept labelled LTA-workbook-only; overlap 2015-2024 verified 210/210 identical (Checks sheet)
F13 | Audited table C36,C38 (orig 'which was implemented' / 'etc,.') | ISSUE: grammar slip (plural subject) and 'etc,.' punctuation | FIX: 'which were implemented' and 'etc.'; originals quoted on Findings sheet
F14 | Audited table C37 (orig 'HGV (max laden weight 3.5mt - 16mt)') | ISSUE: band wording overlaps LGV '<= 3.5mt' at exactly 3.5mt | FIX: clarified to '> 3.5mt - 16mt' (standard LTA banding); original quoted on Findings sheet
Oxaide • UEN 201806463W • Research, not advice • REF SAMPLE-excel

---
ILLUSTRATIVE SAMPLE — real public findings, not commissioned. Research, not advice. Oxaide UEN 201806463W • brief@oxaide.com
