Hello there!
I am a manager of individuals that work on technical writing investigations. The investigations are categorized by 4 levels of severity, each level taking a different amount of time (increasing in severity). Additionally, external factors or multiple root cause findings can extend the time of the investigation. I want to create a smart excel spreadsheet that assigns a finite percentage to each employee, which equates to workload, let's say 100%. Each investigation assigned will make up a certain percentage, with those being higher in severity also higher in percentage. Also, the external factors or >1 root cause will be weighted as additional percentage. This will allow me to ensure an even workload among my writers. Any guidance would be greatly appreciated!
Thank you,
S.
Bookmarks