Spreadsheet: 717124d1612494411-formula-for-last-3-characters-excel-help
Sheet: Sheet1

DEPT | RATE | Annual Salary
497010 | 47884.61 | 1244999.86 |  |  | 010 | Accounting/Admin
497010 | 13469.71 | 350212.46 |  | Looking to sum all departments ending with 011 | 011 | Dispatch
495052 | 12692.31 | 330000.06 |  |  | 012 | Safety
497050 | 10576.92 | 274999.92 |  |  | 015 | [NAME]
497010 | 9923.08 | 258000.08 |  |  | 016 | HH Claims
497007 | 9807.69 | 254999.94 |  |  | 017 | Fleet Admin
403010 | 9615.39 | 250000.14 |  |  | 018 | Training
497007 | 9604 | 249704 |  |  | 020 | EL Trailer Drivers
407010 | 7884.61 | 204999.86 |  |  | 021 | EL S/T Drivers
050010 | 7115.39 | 185000.14 |  |  | 022 | EL Trailer Drivers
497010 | 7115.39 | 185000.14 |  |  | 023 | HH S/T Drivers
017010 | 7076.93 | 184000.18 |  |  | 027 | Telecobuy Dedicated Trailer Drivers
495052 | 6923.08 | 180000.08 |  |  | 030 | EL Helpers
497008 | 6730.77 | 175000.02 |  |  | 031 | HH Helpers
335010 | 6730.76 | 174999.76 |  |  | 032 | EL Summer Helpers
018005 | 6346.15 | 164999.9 |  |  | 033 | HH [NAME]
497010 | 6153.85 | 160000.1 |  |  | 035 | Corporate Facilities
014005 | 6038.46 | 156999.96 |  |  | 039 | LF Installer
497058 | 5769.23 | 149999.98 |  |  | 040 | HH Warehouse
403011 | 5576.93 | 145000.18 |  |  | 045 | P/T Warehouse
497050 | 4807.7 | 125000.2 |  |  | 046 | EL Warehouse
594005 | 4807.7 | 125000.2 |  |  | 048 | EL Warehouse(Chicago)
335010 | 4615.39 | 120000.14 |  |  | 050 | Sales
403051 | 4423.08 | 115000.08 |  |  | 051 | Customer Service
010005 | 4423.07 | 114999.82 |  |  | 052 | HH Customer Service
027005 | 4230.77 | 110000.02 |  |  | 053 | Marketing
012005 | 4230.76 | 109999.76 |  |  | 054 | MTS Protection One
497050 | 4038.46 | 104999.96 |  |  | 055 | Information Technology
403050 | 4000 | 104000 |  |  | 056 | Billing
497010 | 4000 | 104000 |  |  | 057 | TAG TONNAGEACCEPTANCEGROUP
497050 | 3990.62 | 103756.12 |  |  | 058 | Business Development
014011 | 3961.54 | 103000.04 |  |  | 060 | Shop
011010 | 3846.16 | 100000.16
497055 | 3846.16 | 100000.16
497009 | 3846.15 | 99999.9
497010 | 3846.15 | 99999.9
497050 | 3692.31 | 96000.06
497046 | 3653.85 | 95000.1
497060 | 3653.85 | 95000.1
050010 | 3461.54 | 90000.04
497010 | 3461.53 | 89999.78
497050 | 3384.62 | 88000.12
497010 | 3384.62 | 88000.12
401010 | 3285.77 | 85430.02
403011 | 3269.24 | 85000.24
403020 | 3269.24 | 85000.24
403020 | 3269.24 | 85000.24
405020 | 3269.24 | 85000.24
405020 | 3269.24 | 85000.24
405020 | 3269.24 | 85000.24
405020 | 3269.24 | 85000.24
405020 | 3269.24 | 85000.24
405020 | 3269.24 | 85000.24
497010 | 3269.24 | 85000.24
405020 | 3269.24 | 85000.24
405020 | 3269.24 | 85000.24
497060 | 3269.24 | 85000.24
405020 | 3269.24 | 85000.24
405020 | 3269.23 | 84999.98
405020 | 3269.23 | 84999.98
497050 | 3269.23 | 84999.98
494011 | 3192.31 | 83000.06
497050 | 3122.05 | 81173.3
403020 | 3076.93 | 80000.18
403020 | 3076.93 | 80000.18
394021 | 3076.93 | 80000.18
403010 | 3076.93 | 80000.18
403020 | 3076.93 | 80000.18
403020 | 3076.93 | 80000.18
403020 | 3076.93 | 80000.18
403020 | 3076.93 | 80000.18
405020 | 3076.93 | 80000.18
497010 | 3076.93 | 80000.18
403020 | 3076.93 | 80000.18
495052 | 3076.92 | 79999.92
335051 | 3000 | 78000
403020 | 3000 | 78000
017046 | 2988.47 | 77700.22
403011 | 2884.62 | 75000.12
403020 | 2884.62 | 75000.12
403020 | 2884.62 | 75000.12
403020 | 2884.62 | 75000.12
403020 | 2884.62 | 75000.12
403020 | 2884.62 | 75000.12
018011 | 2884.62 | 75000.12
334010 | 2884.62 | 75000.12
494011 | 2884.62 | 75000.12
594011 | 2884.62 | 75000.12
497055 | 2830.81 | 73601.06
406046 | 2800 | 72800
404010 | 2786.54 | 72450.04
010011 | 2769.24 | 72000.24
497051 | 2769.23 | 71999.98
316046 | 2692.31 | 70000.06
497015 | 2692.3 | 69999.8
497012 | 2692.3 | 69999.8
314011 | 2615.38 | 67999.88
594040 | 2600 | 67600
494011 | 2576.93 | 67000.18
401010 | 2570.64 | 66836.64
012046 | 2500 | 65000
497035 | 2500 | 65000
328010 | 2500 | 65000
497050 | 2500 | 65000
497051 | 2500 | 65000
495052 | 2500 | 65000
014046 | 2500 | 65000
017046 | 2500 | 65000
017046 | 2500 | 65000
497050 | 2492.31 | 64800.06
494011 | 2433.2 | 63263.2
497035 | 30 | 62400
050010 | 2346.16 | 61000.16
497051 | 2335.75 | 60729.5
027011 | 2307.7 | 60000.2
497050 | 2307.7 | 60000.2
012011 | 2307.69 | 59999.94
497010 | 2287.79 | 59482.54
497046 | 28.5 | 59280
401055 | 2270.73 | 59038.98
014011 | 2240 | 58240
017011 | 2240 | 58240
335051 | 2211.54 | 57500.04
594046 | 2211.54 | 57500.04
497010 | 2205 | 57330
406046 | 2200 | 57200
018011 | 2178.85 | 56650.1
050010 | 2153.85 | 56000.1
405011 | 2134.62 | 55500.12
335039 | 2120.2 | 55125.2
310011 | 2115.39 | 55000.14
394011 | 2100 | 54600
050010 | 2092.31 | 54400.06
497050 | 2080 | 54080
317021 | 26 | 54080
317021 | 26 | 54080
403011 | 2038.47 | 53000.22
497046 | 2038.47 | 53000.22
018020 | 25.1 | 52208
335039 | 2000 | 52000
335039 | 2000 | 52000
497051 | 2000 | 52000
594020 | 25 | 52000
594020 | 25 | 52000
594022 | 25 | 52000
328020 | 25 | 52000
497010 | 2000 | 52000
334011 | 1980.77 | 51500.02
012046 | 24.72 | 51417.6
594046 | 1976 | 51376
407011 | 1923.08 | 50000.08
494011 | 1923.08 | 50000.08
497012 | 1923.08 | 50000.08
497035 | 1923.08 | 50000.08
011011 | 1923.08 | 50000.08
497056 | 1923.08 | 50000.08
497035 | 1923.07 | 49999.82
494020 | 24 | 49920
594020 | 24 | 49920
401055 | 23.69 | 49275.2
010046 | 1884.62 | 49000.12
018011 | 1881.74 | 48925.24
334021 | 23.5 | 48880
497016 | 1865.39 | 48500.14
018011 | 1861.93 | 48410.18
310020 | 23.25 | 48360
495052 | 1850 | 48100
497007 | 1846.16 | 48000.16
316021 | 23 | 47840
314011 | 23 | 47840
314020 | 23 | 47840
314020 | 23 | 47840
497056 | 1830.77 | 47600.02
403011 | 22.84 | 47507.2
403051 | 1807.7 | 47000.2
018046 | 22.5 | 46800
497009 | 1793 | 46618
497051 | 1788.47 | 46500.22
497055 | 1788.46 | 46499.96
050010 | 1784.62 | 46400.12
497050 | 1776 | 46176
497051 | 1769.24 | 46000.24
497009 | 1765.39 | 45900.14
497056 | 1764.8 | 45884.8
394020 | 22 | 45760
497035 | 1760 | 45760
328039 | 22 | 45760
328046 | 22 | 45760
497051 | 22 | 45760
012020 | 21.75 | 45240
327021 | 21.7 | 45136
497051 | 1730.77 | 45000.02
497051 | 1730.77 | 45000.02
594011 | 1730.77 | 45000.02
011046 | 1730.77 | 45000.02
018011 | 1730.77 | 45000.02
327011 | 1730.77 | 45000.02
497051 | 1730.76 | 44999.76
497035 | 1728 | 44928
394039 | 21.5 | 44720
494020 | 21.35 | 44408
497051 | 1700 | 44200
497060 | 1698.46 | 44159.96
497046 | 1692.3 | 43999.8
400021 | 21 | 43680
400021 | 21 | 43680
406021 | 21 | 43680
406021 | 21 | 43680
334021 | 21 | 43680
014046 | 21 | 43680
314020 | 21 | 43680
314020 | 21 | 43680
314021 | 21 | 43680
406021 | 20.79 | 43243.2
407051 | 1653.85 | 43000.1
394021 | 20.5 | 42640
497011 | 1636.77 | 42556.02
403011 | 1634.62 | 42500.12
310020 | 20.4 | 42432
401055 | 20.15 | 41912
407051 | 1607 | 41782
012020 | 20 | 41600
012046 | 20 | 41600
012046 | 20 | 41600
337020 | 20 | 41600
394021 | 20 | 41600
497035 | 20 | 41600
497056 | 20 | 41600
497060 | 1600 | 41600
594031 | 20 | 41600
018046 | 20 | 41600
334020 | 20 | 41600
401055 | 20 | 41600
401055 | 20 | 41600
494048 | 20 | 41600
014046 | 20 | 41600
017046 | 20 | 41600
317039 | 20 | 41600
317039 | 20 | 41600
497051 | 1592 | 41392
494020 | 19.87 | 41329.6
394021 | 19.75 | 41080
327046 | 19.75 | 41080
011046 | 1576.93 | 41000.18
316021 | 19.54 | 40643.2
334021 | 19.5 | 40560
018040 | 19.48 | 40518.4
316021 | 19.4 | 40352
495052 | 1540 | 40040
407051 | 1538.46 | 39999.96
401055 | 19.11 | 39748.8
401055 | 19.11 | 39748.8
497056 | 19 | 39520
594046 | 19 | 39520
594046 | 19 | 39520
327039 | 19 | 39520
334046 | 19 | 39520
494048 | 19 | 39520
497010 | 18.85 | 39208
494050 | 1500 | 39000
497010 | 18.75 | 39000
327021 | 18.7 | 38896
327021 | 18.7 | 38896
401055 | 18.54 | 38563.2
401055 | 18.54 | 38563.2
401055 | 18.54 | 38563.2
401055 | 18.54 | 38563.2
401055 | 18.54 | 38563.2
401055 | 18.54 | 38563.2
497008 | 18.5 | 38480
594046 | 18.5 | 38480
310046 | 18.5 | 38480
497009 | 18.27 | 38001.6
495052 | 1461.54 | 38000.04
497051 | 1461.54 | 38000.04
327039 | 18.25 | 37960
328021 | 18.18 | 37814.4
310039 | 18.1 | 37648
406046 | 18 | 37440
337039 | 18 | 37440
337046 | 18 | 37440
337046 | 18 | 37440
394046 | 18 | 37440
494027 | 18 | 37440
494027 | 18 | 37440
494027 | 18 | 37440
497056 | 18 | 37440
497056 | 18 | 37440
594031 | 18 | 37440
018046 | 18 | 37440
327021 | 18 | 37440
327021 | 18 | 37440
328021 | 18 | 37440
334046 | 18 | 37440
494048 | 18 | 37440
017046 | 18 | 37440
017046 | 18 | 37440
017046 | 18 | 37440
017046 | 18 | 37440
017046 | 18 | 37440
017046 | 18 | 37440
017046 | 18 | 37440
017046 | 18 | 37440
017046 | 18 | 37440
017046 | 18 | 37440
017046 | 18 | 37440
017046 | 18 | 37440
017046 | 18 | 37440
017046 | 18 | 37440
017046 | 18 | 37440
017046 | 18 | 37440
017046 | 18 | 37440
317010 | 18 | 37440
317046 | 18 | 37440
403020 | 18 | 37440
310039 | 17.95 | 37336
327021 | 17.85 | 37128
327039 | 17.82 | 37065.6
337039 | 17.75 | 36920
014046 | 17.75 | 36920
310021 | 17.6 | 36608
394039 | 17.5 | 36400
594046 | 17.5 | 36400
018046 | 17.5 | 36400
328039 | 17.5 | 36400
310039 | 17.45 | 36296
327039 | 17.45 | 36296
327039 | 17.45 | 36296
327039 | 17.31 | 36004.8
012046 | 1384.62 | 36000.12
497056 | 1384.61 | 35999.86
328039 | 17.25 | 35880
328039 | 17.25 | 35880
310039 | 17.15 | 35672
334039 | 17.11 | 35588.8
012011 | 17 | 35360
012046 | 17 | 35360
406046 | 17 | 35360
337039 | 17 | 35360
394039 | 17 | 35360
394039 | 17 | 35360
494027 | 17 | 35360
497035 | 17 | 35360
594045 | 17 | 35360
010046 | 17 | 35360
011030 | 17 | 35360
011030 | 17 | 35360
328046 | 17 | 35360
334030 | 17 | 35360
334039 | 17 | 35360
314021 | 17 | 35360
314039 | 17 | 35360
316039 | 16.95 | 35256
327039 | 16.95 | 35256
327039 | 16.8 | 34944
334039 | 16.75 | 34840
310039 | 16.7 | 34736
406046 | 16.63 | 34590.4
406046 | 16.63 | 34590.4
406046 | 16.63 | 34590.4
316039 | 16.5 | 34320
316039 | 16.5 | 34320
497017 | 16.5 | 34320
594030 | 16.5 | 34320
594031 | 16.5 | 34320
010046 | 16.5 | 34320
018046 | 16.5 | 34320
327021 | 16.5 | 34320
328039 | 16.5 | 34320
334030 | 16.5 | 34320
014046 | 16.5 | 34320
314039 | 16.5 | 34320
327039 | 16.4 | 34112
327039 | 16.2 | 33696
327039 | 16.2 | 33696
401046 | 16.06 | 33404.8
012021 | 16 | 33280
400030 | 16 | 33280
406046 | 16 | 33280
497046 | 16 | 33280
316039 | 16 | 33280
394039 | 16 | 33280
594031 | 16 | 33280
594040 | 16 | 33280
594045 | 16 | 33280
594046 | 16 | 33280
018046 | 16 | 33280
310020 | 16 | 33280
494048 | 16 | 33280
838046 | 16 | 33280
314039 | 16 | 33280
314039 | 16 | 33280
314039 | 16 | 33280
594045 | 15.96 | 33196.8
494048 | 15.75 | 32760
594031 | 15.5 | 32240
327046 | 15.5 | 32240
334039 | 15.5 | 32240
012030 | 15.4 | 32032
497051 | 15 | 31200
011046 | 15 | 31200
327046 | 15 | 31200
494048 | 15 | 31200
314039 | 15 | 31200
314046 | 15 | 31200
401046 | 14.98 | 31158.4
401046 | 14.9 | 30992
310039 | 14.5 | 30160
310039 | 14.5 | 30160
494048 | 14.5 | 30160
401046 | 14.47 | 30097.6
401046 | 14.31 | 29764.8
012046 | 14 | 29120
012046 | 14 | 29120
018046 | 14 | 29120
494048 | 14 | 29120
494048 | 14 | 29120
494048 | 14 | 29120
494048 | 14 | 29120
494048 | 14 | 29120
401046 | 13.64 | 28371.2
401046 | 13.64 | 28371.2
401046 | 13.64 | 28371.2
401046 | 13.25 | 27560
401046 | 13.25 | 27560
012046 | 13 | 27040
011030 | 13 | 27040
011030 | 13 | 27040