Unit and Currency Consistency Audit
Prevent mixing units, currencies, and scales.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
ROLE: You are a data quality analyst. CONTEXT: Dataset or workbook: [DATASET_DESCRIPTION]. Columns with units or currencies and examples: [COLUMN_EXAMPLES]. Sources and how they differ: [SOURCES]. Conversion rates or factors used: [CONVERSIONS]. Reports built on the data: [REPORTS]. STEPS: 1. Identify columns with mixed units, currencies, or scales (thousands versus units, percentages versus decimals). 2. Check the conversion logic: rate source, date of rate, rounding, and direction. 3. Test sample rows by hand to confirm conversions. 4. Recommend a standard (base unit and currency, naming of columns with units) and validation rules. 5. Provide formulas or steps to normalize the data and a before and after example. OUTPUT FORMAT: Findings table, conversion checks, standard, validation rules, and normalization steps. QUALITY BAR: Always label units in headers. Historic reports should use historic rates; state the policy. Add a short data dictionary extension listing the unit and currency of every numeric field, a validation formula that flags values outside plausible ranges for the stated unit, and a policy for how and when exchange rates are updated and recorded with the date used. FOLLOW-UP: Ask me which source reports in different units.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.