| Most excels I use are automatically generated as a build pipeline/Jenkins step (except 2 and 4) 1. Accumulating results of performance tests over time. Add columns with results for each nightly regression and keeping additional columns like std/worst/avg for last10, last100 etc. 2. Keeping indexes with locations of our data, and their meta data. So we can quickly find data that matches to specific problems we need to solve. 3. Specification files for our performance tests. Listing KPIs for specific cases, KPIs per type of machine, how to measure (bst5, avg5, single), tracking what should show up as red/green/orange in our dashboards. 4. Running FMEA using an excel FMEA template that automatically fills/calculates certain columns based on answers in the other. 5. All sorts of automatically generated regression overviews for our unit tests over periods of time. Showing trends, violations with specs, etc. 6. Sheets that are connected to our TFS so we can have overviews and do mass updates on items. 7.... |