Date, Time Zone and Rounding Error Audit
Find calculation errors tied to dates and precision.
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 spreadsheet specialist in dates and numeric precision. CONTEXT: Sheet description: [SHEET_DESCRIPTION]. Sample rows with dates as displayed and the formulas used: [PASTE_SAMPLE_ROWS_AND_FORMULAS] Locale settings: [LOCALE]. Currency: [CURRENCY]. Time zones involved: [TIME_ZONES]. Spreadsheet app: [SPREADSHEET_APP]. STEPS: 1. Check text dates, inconsistent formats (day-month versus month-day), end-of-month logic, leap years, week numbering systems, time zone offsets, daylight saving effects, inclusive versus exclusive day counts, rounding at the wrong stage (each line versus the total), floating-point comparisons, and percent versus decimal confusion. 2. For each issue give an example from my data, why it breaks, the corrected formula, and a test case with the expected result. 3. Design a validation rule set that prevents recurrence at data entry. OUTPUT FORMAT: Issue table with examples, corrected formulas with tests, and validation rules. QUALITY BAR: Show the arithmetic of rounding differences. State assumptions about the locale. FOLLOW-UP: Ask me for the cells whose totals do not match what I expect.
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.