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.
Find calculation errors tied to dates and numeric precision. Spreadsheet app: [SPREADSHEET_APP]. Workbook description: [WORKBOOK_DESCRIPTION]. Formulas, sample dates, and sample numbers with unexpected results: [PASTE_EXAMPLES]. Check each item and mark Pass, Fail, or Unknown with the test and fix: DATES AND TIME [ ] Dates are real dates, not text that looks like dates (test with ISNUMBER) [ ] Regional formats (day-month versus month-day) are consistent on import [ ] Time zone is stated; conversions are explicit; daylight saving transitions are tested [ ] Date differences handle inclusive/exclusive end dates and month-end rules (for example adding one month to the 31st) [ ] Leap years and the end of February are tested [ ] Fiscal year and week-number definitions match the business definition [ ] Time values above 24 hours and negative times display correctly ROUNDING AND PRECISION [ ] Displayed values are not mistaken for stored values; ROUND is used where totals must add up [ ] Rounding happens at the right step (not before summing, unless policy says so) [ ] Currency amounts avoid floating-point surprises in comparisons (compare with a tolerance) [ ] Percentages are stored consistently (0.05 versus 5) [ ] Totals of rounded items match the rounded total or the difference is explained Provide test cases with expected results, the formulas to fix each issue, and a note on documentation.
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.