Spreadsheet: 22896d1212073733-spread-sheet-formulas-and-drop-down-payscale
Sheet: Pay Calculator

Mission | Heartland Park Topeka Static Display |  |  |  |  |  |  |  |  | Mission Cost Estimate Sheet
Location: | Heartland Park, Topeka
Start Point: | 23
[NAME] | 5
End Point:
Unit | 1-108th Av
Unit POC | 1LT [NAME]
Count | Name | SSN | Start Date | End Date | HOR City, State | Rank | Years in Service | [NAME] | Mission Days | Total Pay | Total Mileage Paid | [NAME], must be Over 50 radius | Nights in Hotel | Per Diem Locale | Hotel Per Diem | Meal Rate | Total Hotel Cost | Total Meal Cost | Total Travel Cost | remarks
1 | [NAME], [NAME] |  | 2008-05-30 00:00:00 | 2008-06-01 00:00:00 | [NAME], KS | O-2 | 6 | 135.81 | 3 | 407.43 | 26.52 | 52 | 2 | Topeka | 70 | 36 | 140 | 108 | 681.95 | ON ADSW, JUST NEED TRAVEL ORDERS
2 | Lindsey, [NAME] |  | 2008-05-31 00:00:00 | 2008-05-31 00:00:00 | Topeka, KS | E-6 | 22 | 108.11 | 1 | 108.11 | 6.12 | 12 | 0 |  | 0 | 0 | 0 | 0 | 114.23
3 | Hood, [NAME] |  | 2008-06-01 00:00:00 | 2008-06-01 00:00:00 | Topeka, KS | W-4 | 20 | 189.39 | 1 | 189.39 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 189.39
4 | Guyette, Damon |  | 2008-05-30 00:00:00 | 2008-06-01 00:00:00 | Manhattan, KS | E-5 | 6 | 80.17 | 3 | 240.51 | 32.64 | 64 | 2 | Topeka | 70 | 36 | 140 | 108 | 521.15 | E-5 Rank and below having issue on the reference
5 | Corkran, [NAME] |  | 2008-05-30 00:00:00 | 2008-06-01 00:00:00 | Olathe, KS | E-5 | 20 | 90.74 | 3 | 272.22 | 38.25 | 75 | 2 | Topeka | 70 | 36 | 140 | 108 | 558.47 | Same
6 | Seats, [NAME] |  | 2008-06-01 00:00:00 | 2008-06-01 00:00:00 | Topeka, KS | [NAME] | 24 | 153.54 | 1 | 153.54 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 153.54
7 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
8 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
9 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
10 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
11 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
12 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
13 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
14 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
15 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
16 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
17 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
18 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
19 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
20 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
21 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
22 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
23 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
24 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
25 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
26 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
27 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
28 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
29 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
30 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
31 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
32 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
33 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
34 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
35 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
36 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
37 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
38 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
39 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
40 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0