OK...so here's what I have. I start with 3rd qtr 2014 (3Q14) and continue for four quarters total. The equations for 3Q14 are a bit different, reasons for which I hope will be clear upon further explanation.
The equations for the Tech adds in the following quarters go something like this:
* Sum all Type 1 accounts added for this and previous quarters, divide by 3, round down
* Sum all Type 2 accounts added for this and previous quarters, divide by 3, round down
* Add these together
* Sum all Tech hires for all previous quarters (i.e. not including this quarter)
* Subtract this number from the sum in step 3
e.g. =SUM(ROUNDDOWN(SUM($B2:C2)/3,0),ROUNDDOWN(SUM($B3:C3)/3,0))-SUM($B4:B4)
The equations for Support hires are the basically same only the divisors above are 2, not 3.
i.e. =SUM(ROUNDDOWN(SUM($B2:C2)/2,0),ROUNDDOWN(SUM($B3:C3)/2,0))-SUM($B5:B5)
See attached.
|