Spreadsheet: 298912d1392942198-formula-needed-for-payroll-worksheet-calculation-index-match-vlook-other-formula-for-disability-payroll
Sheet: 2014

 |  |  |  |  |  |  |  |  | STD | STD | STD | STD | STD
2014-03-01 00:00:00 | Salary | DOB | AGE | STD Enrollment (Class # or Not Enrolled) | STD Benefit | STD                            Total Monthly Billed Premium |  | CLASS # | 1 | 2 | 3 | 4 | 5
1 | 30222.4 | 1970-12-08 00:00:00 |  | 1 | 349 |  |  | Age or Composite ---> | Age | Age | Age | Age | Composite
2 | 22812.4 | 1965-12-06 00:00:00 |  | 2 | 263
3 | 31200 | 1989-07-02 00:00:00 |  | 3 | 360 |  |  | Rate/$10 Benefit | 0.3 | 0.4 | 0.5 | 0.6 | 0.7
4 | 40000.064 | 1981-08-06 00:00:00 |  | 4 | 462
5 | 24086.4 | 1953-03-21 00:00:00 |  | 5 | 278
6 | 28080 | 1952-04-18 00:00:00 |  | 1 | 324
7 | 24086.4 | 1986-07-28 00:00:00 |  | 2 | 278
8 | 23400 | 1989-12-11 00:00:00 |  | 3 | 270
9 | 21840 | 1996-07-06 00:00:00 |  | 4 | 252
10 | 21031.92 | 1965-07-27 00:00:00 |  | 5 | 243 |  |  |  | Max Weekly Benefit | Max Weekly Benefit | Max Weekly Benefit | Max Weekly Benefit | Max Weekly Benefit
11 | 45760 | 1982-04-19 00:00:00 |  | 1 | 528 |  |  |  | 1000 | 750 | 500 | 400 | 250
12 | 30000.048 | 1962-07-27 00:00:00 |  | 2 | 346
13 | 23878.4 | 1953-11-11 00:00:00 |  | 3 | 276 |  |  |  | Benefit % | Max Weekly Benefit | Max Weekly Benefit | Max Weekly Benefit | Max Weekly Benefit
14 | 24086.4 | 1954-01-29 00:00:00 |  | 4 | 278 |  |  |  | 0.8 | 0.7 | 0.6 | 0.5 | 0.4
15 | 35314.032 | 1963-02-28 00:00:00 |  | 5 | 407
16 | 30000.048 | 1988-02-09 00:00:00 |  | Waiving | 0
17 | 65000 | 1963-10-01 00:00:00 |  | Not Enrolled | 750
18 | 24440 | 1986-02-17 00:00:00 |  | 1 | 282
19 | 26124.8 | 1957-01-10 00:00:00 |  | 2 | 301
20 | 30999.99968 | 1964-03-28 00:00:00 |  | 3 | 358
21 | 37000.08 | 1956-08-20 00:00:00 |  | 4 | 427
22 | 24086.4 | 1982-03-14 00:00:00 |  | 5 | 278
23 | 31999.968 | 1969-02-21 00:00:00 |  | 1 | 369
24 | 27949.168 | 1981-12-16 00:00:00 |  | 2 | 322
25 | 32908.72 | 1977-06-02 00:00:00 |  | 3 | 380
26 | 39520 | 1957-11-03 00:00:00 |  | 4 | 456
27 |  | 1951-12-04 00:00:00 |  | Not Enrolled | 0
28 | 100000 | 1956-07-16 00:00:00 |  | 1 | 750
29 | 28600 | 1979-05-18 00:00:00 |  | 1 | 330
30 | 59999.888 | 1965-11-08 00:00:00 |  | 2 | 692
31 | 49284.768 | 1956-12-29 00:00:00 |  | 3 | 569
32 | 32500 | 1984-10-07 00:00:00 |  | 4 | 375
33 | 24086.4 | 1981-03-15 00:00:00 |  | 5 | 278
34 | 21840 | 1963-02-26 00:00:00 |  | 1 | 252 |  |  | AGE | Rate/$10 benefit | Rate/$10 benefit | Rate/$10 benefit | Rate/$10 benefit | Rate/$10 benefit
35 | 26520 | 1974-04-05 00:00:00 |  | 2 | 306 |  |  | 1
36 | 32500 | 1962-01-31 00:00:00 |  | 3 | 375 |  |  | 2
 |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  | 19 | 0.2
 |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  | 37
 |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  | 39
 |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  | 41
 |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  | 43
 |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  | 45
 |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  | 47
 |  |  |  |  |  |  |  | 48
 |  |  |  |  |  |  |  | 49
 |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  | 51
 |  |  |  |  |  |  |  | 52
 |  |  |  |  |  |  |  | 53
 |  |  |  |  |  |  |  | 54
 |  |  |  |  |  |  |  | 55
 |  |  |  |  |  |  |  | 56
 |  |  |  |  |  |  |  | 57
 |  |  |  |  |  |  |  | 58
 |  |  |  |  |  |  |  | 59
 |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  | 61
 |  |  |  |  |  |  |  | 62
 |  |  |  |  |  |  |  | 63
 |  |  |  |  |  |  |  | 64
 |  |  |  |  |  |  |  | 65
 |  |  |  |  |  |  |  | 66
 |  |  |  |  |  |  |  | 67
 |  |  |  |  |  |  |  | 68
 |  |  |  |  |  |  |  | 69
 |  |  |  |  |  |  |  | 70
 |  |  |  |  |  |  |  | 71
 |  |  |  |  |  |  |  | 72
 |  |  |  |  |  |  |  | 73
 |  |  |  |  |  |  |  | 74
 |  |  |  |  |  |  |  | 75
 |  |  |  |  |  |  |  | 76
 |  |  |  |  |  |  |  | 77
 |  |  |  |  |  |  |  | 78
 |  |  |  |  |  |  |  | 79
 |  |  |  |  |  |  |  | 80
 |  |  |  |  |  |  |  | 81
 |  |  |  |  |  |  |  | 82
 |  |  |  |  |  |  |  | 83
 |  |  |  |  |  |  |  | 84
 |  |  |  |  |  |  |  | 85
 |  |  |  |  |  |  |  | 86
 |  |  |  |  |  |  |  | 87
 |  |  |  |  |  |  |  | 88
 |  |  |  |  |  |  |  | 89
 |  |  |  |  |  |  |  | 90
 |  |  |  |  |  |  |  | 91
 |  |  |  |  |  |  |  | 92
 |  |  |  |  |  |  |  | 93
 |  |  |  |  |  |  |  | 94
 |  |  |  |  |  |  |  | 95
 |  |  |  |  |  |  |  | 96
 |  |  |  |  |  |  |  | 97
 |  |  |  |  |  |  |  | 98
 |  |  |  |  |  |  |  | 99