<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> <META content="MSHTML 6.00.2713.1100" name=GENERATOR></HEAD> <BODY> <DIV>Wim:</DIV> <DIV> </DIV> <DIV>There is an Excel spreadsheet on the CAUT website that can make this job a lot easier.</DIV> <DIV> </DIV> <DIV>Check it out.</DIV> <DIV> </DIV> <DIV>dave<BR><FONT face=Arial size=2>*********** REPLY SEPARATOR ***********<BR><BR>On 4/15/02 at 5:42 PM Wimblees@aol.com wrote:</FONT></DIV> <BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid"><FONT face=arial,helvetica><FONT size=2>At the CW Regional, a couple of us discussed the workload formula. Richard West is going to make some recommendations, but I did some more figuring. I did this in the fall, and came up with 1,1 techs needed for this job. But now I am doing it again, and I am having difficulties doing with the math. <BR><BR>I got an average number for each of the 7 categories. According to directions, I have to multiply all seven averages together (1), and then multiply that number by the "base workload", as per what kind of department I have, to come up with a recommended workload. (I hope I have that right so far) Then I have to divide the number of pianos by the recommended workload, to come up with the number of technicians. <BR><BR>According to the formula, the lower number in the "workload", is for the better department, and thus the more techs are needed to take care of pianos. Higher numbers are for "general music departments." 40 is for a conservatory. 80 is for a genral music department.   <BR><BR>When I do the math, this is what I get. <BR><BR>(1) times 40 = 101.196. If I divide the number of pianos(71) by 101.196, I get .7. This would mean a tech working 3/4 time is needed to take care of 71 pianos in a conservatory school. That seems kind of low. However, if reverse the division, (101.196 by 71), I come up with 1.42. That means I need 1.42 techs to take care of 71 pianos in a conservatory setting. This seems about right.   <BR><BR>But wait, lets do the math again, this time 80, which is for general music departments. <BR><BR>(1) times 80 = 2.85. If I divide the number of pianos(71) by 2.85, I get .35. Which means a third time techs position. That seems awfully low. But If I divide 2.85 by 71, I get 2.85 techs. That seems very high for a general music department with 71 pianos.   <BR><BR>So, am I doing something wrong, or is there something wrong with the formula? <BR><BR>Wim</FONT><FONT size=2 Arial></BLOCKQUOTE></FONT></FONT></BODY></HTML> <PRE> _____________________________ David M. Porritt dporritt@mail.smu.edu Meadows School of the Arts Southern Methodist University Dallas, TX 75275 _____________________________</PRE>