ROLLSI
Charts and annotations live on the ROLLSI ribbon tab. This panel is for export and settings.
Charts and annotations live on the ROLLSI ribbon tab. This panel is for export and settings.
Slide sizes fit a 16:9 PowerPoint slide. Use Copy and paste into PowerPoint, or drag the image into a slide.
Saved in this workbook and as your default. Ribbon buttons use these settings.
=ROLLSI.MA| 1 | AVERAGE (default) | 11 | VAR.P |
| 2 | COUNT | 12 | MEDIAN |
| 3 | COUNTA | 13 | MODE |
| 4 | MAX | 14 | LARGE (k) |
| 5 | MIN | 15 | SMALL (k) |
| 6 | PRODUCT | 16 | PERCENTILE.INC (k) |
| 7 | STDEV.S | 17 | QUARTILE.INC (k) |
| 8 | STDEV.P | 18 | PERCENTILE.EXC (k) |
| 9 | SUM | 19 | QUARTILE.EXC (k) |
| 10 | VAR.S |
Names also work: "sum", "avg", "first", "last", "range", "geomean", "harmean", "avedev", "skew", "kurt", "p90", "large:2".
| 0 | Last point: trailing window (default) |
| 1 | Mid point: centered window |
| 2 | First point: forward-looking window |
| 3 | Custom: rowsAbove and rowsBelow |