Compute expected results mentally to verify code later? Just write correct parsing code. Data embedded as string. Write JS parsing.

Let me quickly sanity-check a few numbers: Duplicates: 1008 twice → drop 1. N/A rows: 1006, 1028 → 2 excluded; unknown 1017 → 3 excluded. Rows received 31, rows counted 27? 31 -1 dup -3 excluded = 27 counted (excluded rows counted in table? rows counted = valid rows used). Revenue Texas: Q1: 1240+312.50+(-450)+870.10 = 1972.60; Q2: 990+2075+1300+730.90 = 5095.90... plus tx 1580 Q1, 845 Q2? tx rows: 1013 (Q1 1580), 1022 Q2 845, 1028 excluded. So Texas Q1 3552.60, Q2 5940.90, total 9493.50. California: 980+1764+2310+640+3050 = 8744 Q1; Q2: 1420.50+1111.11+2940.40+1875.25 = 7347.26 → 16091.26. California top region. Ohio: 455+1102.25+1999.99+225.75 = 3783 - wait 1011 Ohio 1999.99 Q1. Q1 Ohio: 455+1102.25+1999.99+225.75 = 3783 - compute: 455+1102.25=1557.25; +1999.99=3557.24; +225.75=3782.99. Q2: -220+515+1660 = 1955. Ohio total 5737.99. Grand total = 9493.50+16091.26+5737.99 = 31322.75.

Write HTML with CSV parsing (handle quotes), cleaning, pivot, SVG bar chart, quality panel, headline.