DSO XmR calculator
DSO moves every month. This puts your monthly figures on an XmR chart and shows which months are consistent with routine variation, and which ones look like something actually changed.
The method, and what it can and can’t tell you, is in Does every DSO wobble need an explanation?
Paste or type your monthly DSO, oldest month first. One value per line works, and so does two columns copied straight from Excel (month, then DSO). Everything is calculated on your machine. The numbers are not sent anywhere and not saved.
The limits come from the first this-many months. Pick a run you believe was stable.
Want to keep it, or run it on more months? Download the Excel version.
Your chart appears here once you press Calculate.
- Average
- Avg moving range
- Upper limit
- Lower limit
- Range limit
Filled red: the month a rule fires. Hollow red: the months that make up that pattern. Red bar: a jump over the range limit. Hover or tap a month for its numbers.