Spreadsheet: 552074d1513275914-bonus-allocation-once-a-certain-cap-is-hit-book1
Sheet: test

 |  |  |  |  |  |  |  |  | Total Pool | 250000
 |  |  |  |  |  |  |  |  | Rate
 |  | October | November | December | January | February | March | April | May | June | July | August | September | Total | Supervision Payment | [NAME] excluding any over $25K | Shifts Weighted Average excluding any over $25K | Additional Allocation | Grand Total
 | Manager 1 | 10 | 60
 | Manager 2 | 10 | 8
 | Manager 3 | 0 | 0
 | Manager 4 | 0 | 0
 | Manager 5 | 16 | 12
 | Manager 6 | 11 | 25
 | Manager 7 | 10 | 9
 | Manager 8 | 10 | 13
 | Manager 9 | 10 | 13
 | Manager 10 | 17 | 10
 | Manager 11 | 14 | 15
 | Manager 12 | 14 | 13
 | Manager 13 | 10 | 11
 | Manager 14 | 10 | 9
 | Manager 15 | 17 | 16
 | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | pearcep | PAP | 0 |  |  | 1 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 219 | 50010 | 5008 | -2482.57 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 220 | 50010 | 5011 | -16401.78 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 221 | 50010 | 5071 | -8588.55 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 222 | 50010 | 5074 | -974.61 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 223 | 50010 | 5246 | -11002.51 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 224 | 50010 | 5264 | -14865.63 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 225 | 50010 | 5269 | -10306.61 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 226 | 50010 | 5270 | -10441.59 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 227 | 50010 | 5289 | -12252.25 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 228 | 50010 | 5290 | -15272.53 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 229 | 50010 | 5292 | -18761.9 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 230 | 50010 | 5293 | -1169.16 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 231 | 50010 | 5294 | -13979.18 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 232 | 50010 | 5297 | -8570.21 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 233 | 50010 | 5302 | -3622.18 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 234 | 50010 | 5305 | -2932.15 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 235 | 50010 | 5307 | -10206.49 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 236 | 50010 | 5308 | -3746.82 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 237 | 50010 | 5309 | -4692.63 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 238 | 50010 | 5310 | -3991.4 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 239 | 50010 | 5329 | -4334.31 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 240 | 50010 | 5332 | -3435.01 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 241 | 50010 | 5333 | -6852.16 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 242 | 50010 | 5335 | -10795.23 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 243 | 50010 | 5337 | -9868.67 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 244 | 50010 | 5338 | -5952.02 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 245 | 50010 | 5339 | -5137.21 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 246 | 50010 | 5345 | -3318.02 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 247 | 50010 | 5346 | -4322.82 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 248 | 50010 | 5349 | -2999.03 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 249 | 50010 | 5350 | -1543.76 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 250 | 50010 | 5601 | -17120 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 251 | 50010 | 5608 | -16473.7 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 252 | 50010 | 5625 | -17705.76 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 253 | 50010 | 5640 | -2159.24 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 254 | 50010 | 5659 | -13990.7 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 255 | 50010 | 5667 | -10392.24 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 256 | 50010 | 5673 | -9401.71 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 257 | 50010 | 5676 | -4248.96 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 258 | 50010 | 5803 | -34351.92 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 261 | 50010 | 5802 | -21162.47 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 265 | 50010 | 5804 | -5244.07 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 266 | 50010 | 5810 | -48074.07 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 267 | 50010 | 5811 | -92501.82 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 268 | 50010 | 5812 | -18581 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 269 | 50010 | 5814 | -13259.75 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 270 | 50010 | 5815 | -33085.39 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 271 | 50010 | 5817 | -11496.07 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 272 | 50010 | 5827 | -20553.55 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 273 | 50010 | 5828 | -696.46 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 274 | 50010 | 5829 | -1869.59 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 275 | 50010 | 5833 | -3020.25 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 276 | 50010 | 5839 | -29898.88 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 277 | 50010 | 5840 | -14305 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 278 | 50010 | 5841 | -15374.98 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 279 | 50010 | 5842 | -11389.62 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 280 | 50010 | 5845 | -16860.63 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 281 | 50010 | 5847 | -4950.67 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 282 | 50010 | 5850 | -20987.87 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 283 | 50010 | 5897 | -13171.56 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 284 | 50010 | 5898 | -5553.1 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  | PAY730PTAS | 285 | 50010 | 5899 | -3309.99 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0
 | 00210 |  |  |  |  |  |  |  | 50010 | 5950 | -15652.71 | 2016-11-01 | S-Accrued PTO | stittd | PAP | 0 |  |  | 2 |  | 0