*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
Implementation ideas
Example 1: Spreadsheets
From Frank, 5/2/17: Got data, but NOT time period, so still need to get that to give meaning to the below data. 
Assumptions for analysis portion
- In a year, 52 weeks * 5 workdays = 260 workdays/yr. Assume staff have 3 weeks vacation, and 2 weeks University Holidays, so 5 weeks * 5 days = 25 workdays. Thus 235 workdays per year (=260-25).
- 19.6 workdays per month (=235/12). This represents the available FTEs.
Total flow summary: There is an average of over ?? tickets resolved by our group each workday,.
- We averaged ??? resolved tickets per month.
- Per above assumption, 19.6 workdays per month: ??? / 19.6 = ~???? resolved tickets per workday.
Chemistry, for this mm month period:
Flow summary: xx tickets per month averages to yy tickets resolved 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 | 53 | 9 | 9% | |
Michael E Hint | 36 | 7 | 59 | 58% | |
Oliver B Habicht | 13 | 22 | 31 | 31% | |
All others: | 1 | 18 | 2 | 2% | |
Total | 52 | 48 | 100 |
Physics, for this mm month period:
Flow summary: xy tickets per month averages to about yx 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 |
Kelly Brower | 4 | 3 | 7 | 47% | |
Michael E Hint | 2 | 3 | 5 | 33% | |
Oliver B Habicht | 0 | 3 | 3 | 20% | |
All others: | 0 | 0 | 0 | - | |
Total | 6 | 9 | 15 |
---------------------------------------------------------------
From Frank, 1/30/17, "Resolved Time Summary per Assignee: 04/01/2016 to 01/01/2017"
...
Assumptions for analysis portion
- In a year, 52 weeks * 5 workdays = 260 workdays/yr. Assume staff have 3 weeks vacation, and 2 weeks University Holidays, so 5 weeks * 5 days = 25 workdays. Thus 235 workdays per year (=260-25).
- 19.6 workdays per month (=235/12). This represents the available FTEs.
...