Hi Manon and Stacey,
Good to read about this, because we have created an XmR generator a couple of years ago. It was too much work to do it all by hand. Being aware of the risks involved in re-calculating automatically the automated approach has been of great help to start our analysis on a large number of measures.
@Stacey: we have talked about this “manual override” before. Could you elaborate a bit about how you see this workflow from the user perspective ? Do you expect to have the signal detection (and recalculation) initially done automatically and then specify the start and end points of the periods you want to exclude to rerun the calculation?
@Manon: calculating the additional columns (as Stacey has done in her excel examples) is the principal part. The rendering of the chart is then easy in any reporting/presentation tool that can produce a line chart with some form of boundaries for the control limits (area, lines, etc). We have used all kinds of tools to render, whatever made sense for the project.