Spreadsheet: 39209d1237398063-update-formula-to-round-off-to-a-whole-number-mewsptosheet-1-
Sheet: Sheet1

 |  | 2009-01-31 00:00:00 |  |  |  |  |  | 2009-02-28 00:00:00 |  |  |  | 2009-03-31 00:00:00 |  |  |  | 2009-04-30 00:00:00 |  |  |  | 2009-05-31 00:00:00 |  |  |  | 2009-06-30 00:00:00 |  |  |  | 2009-07-31 00:00:00 |  |  |  | 2009-08-31 00:00:00 |  |  |  | 2009-09-30 00:00:00 |  |  |  | 2009-10-31 00:00:00 |  |  |  | 2009-11-30 00:00:00 |  |  |  | 2009-12-31 00:00:00
 |  | Bal. Forward | Accrued | Used | Remaining |  |  | Bal. Forward | Accrued | Used | Remaining | Bal. Forward | Accrued | Used | Remaining | Bal. Forward | Accrued | Used | Remaining | Bal. Forward | Accrued | Used | Remaining | Bal. Forward | Accrued | Used | Remaining | Bal. Forward | Accrued | Used | Remaining | Bal. Forward | Accrued | Used | Remaining | Bal. Forward | Accrued | Used | Remaining | Bal. Forward | Accrued | Used | Remaining | Bal. Forward | Accrued | Used | Remaining | Bal. Forward | Accrued | Used | Remaining
Employee | Hire Date
[NAME] | 2007-12-15 00:00:00 | 0 | 6.64 | 0 | 6.64 |  |  | 6.64 | 6.64 |  | 13.28 | 13.28 | 6.64 |  | 19.92 | 19.92 | 6.64 |  | 26.56 | 26.56 | 6.64 |  | 33.2 | 33.2 | 6.64 |  | 39.84 | 39.84 | 6.64 |  | 46.48 | 46.48 | 6.64 |  | 53.12 | 53.12 | 6.64 |  | 59.76 | 59.76 | 6.64 |  | 66.39999999999999 | 66.39999999999999 | 6.64 |  | 73.03999999999999 | 73.03999999999999 | 6.64 |  | 80 | Could we round this off any?
[NAME] | 2006-02-17 00:00:00 | 1 | 6.64 | 1 | 6.64 |  |  | 6.64 | 6.64 |  | 13.28 | 13.28 | 10 |  | 23.28 | 23.28 | 10 |  | 33.28 | 33.28 | 10 |  | 43.28 | 43.28 | 10 |  | 53.28 | 53.28 | 10 |  | 63.28 | 63.28 | 10 |  | 73.28 | 73.28 | 10 |  | 83.28 | 83.28 | 10 |  | 93.28 | 93.28 | 10 |  | 103.28 | 103.28 | 10 |  | 113
[NAME] | 2005-03-01 00:00:00 |  | 30 |  | 30 |  |  | 30 | 30 |  | 60 | 60 | 10 |  | 70 | 70 | 10 |  | 80 | 80 | 10 |  | 90 | 90 | 10 |  | 100 | 100 | 10 |  | 110 | 110 | 10 |  | 120 | 120 | 10 |  | 130 | 130 | 10 |  | 140 | 140 | 10 |  | 150 | 150 | 10 |  | 160
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Numbers are in brackets to show their significance within the formulas
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80
 |  | cat! |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rounds to the nearest (0) decimal aka whole number
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rounds up to the nearest (0) decimal, aka whole number
mew!----- |  |  |  |  | This table is used to reference the appropriate number by # of months |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 79
 |  |  |  | 0 | 0.83 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rounds down to the nearest (0) decimal, aka whole number
 |  |  |  | 37 | 1.25
 |  |  |  | 61 | 1.67 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | rounds up to the nearest multiple of (1)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 79
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | rounds down to the nearest multiple of (1)