*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
Process idea: Do for each month (or quarter), starting with the past 6 months (or 2 years).
Implementation ideas
Example 1:
...
Spreadsheets
From Frank, 1/30/17, "Resolved Time Summary per Assignee: 04/01/2016 to 01/01/2017":
Total flow summary: There is an average of about 7 tickets resolved by our group per workday.
Chemistry, for this 8 month period:
Flow summary: 123 tickets per month averages to about 6 tickets per day.
| Resolved within 1 day | Resolved in more than 1 day | Total | Oliver's analysis: Avg. per month | Oliver's analysis: Percent of volume |
Lulu Zhu | 38 | 53 | 91 | 11.4 | 9% |
Michael E Hint | 285 | 247 | 532 | 66.5 | 54% |
Oliver B Habicht | 132 | 104 | 236 | 29.5 | 24% |
All others: | 66 | 58 | 124 | 15.5 | 13% |
Total | 521 | 462 | 983 | 123 |
Physics, for this 8 month period:
Flow summary: 15.5 tickets per month averages to about 0.7 tickets per day.
| Resolved within 1 day | Resolved in more than 1 day | Total | Oliver's analysis: Avg. per month | Oliver's analysis: Percent of volume |
Lulu Zhu | 2 | 1 | 3 | - | - |
Michael E Hint | 34 | 35 | 69 | 8.6 | 56% |
Oliver B Habicht | 21 | 14 | 35 | 4.4 | 28% |
All others: | 9 | 12 | 21 | 2.6 | 17% |
Total | 68 | 56 | 124 | 15.5 |
In the Month of Sept 2015, ChemIT (Assigned groups: Chemistry and Chemistry (L2)) and PhysIT (Assigned group: Physics) resolved x number of tickets. The are as follows (in a spreadsheet):
...