"ID","Location","Type","Problem","Fix"
"E01","Orders!A47:J47","Duplicate order","Duplicates row 22 (SO-1011); count as one root cause.","Remove duplicate row 47."
"E02","Orders!I18","Unit conversion omitted","Quantity is in g but formula treats it as kg; result is 1000× too large.","=ROUND(IF(F18=""g"",E18/1000,E18)*G18*(1-H18),2)"
"E03","Orders!I36","Discount sign reversed","Formula uses 1 + discount instead of 1 − discount.","=ROUND(IF(F36=""g"",E36/1000,E36)*G36*(1-H36),2)"
"E04","Orders!I5","Incomplete total range","SUM(I12:I68) excludes the final three rows 69–71.","=SUM(I12:I71) before deduplication"
"E05","Orders!G29","Price mismatch","CF-103 has Catalog price 30, but this row uses 26.","30"
"E06","Orders!B42","Order outside reporting period","2026-08-31 is outside September 1–20.","Verify source; intended 2026-09-07."
"E07","Orders!C55","Delivery before order","Delivery occurs one day before the order.","Verify source; intended 2026-09-20."
"E08","Orders!H62","Percentage scale error","15 is stored as 1500%, exceeding the allowed 0–20%.","0.15 (15%) after source verification"
"E09","Orders!D65","Unknown SKU","CF-999 is absent from the complete Catalog.","Verify source; intended CF-104."
"E10","Orders!A70","Missing order ID","Required order ID is blank.","Verify source; intended SO-1059."
