Spreadsheet: 22227d1210855238-spread-sheet-formulas-and-drop-down-request-for-orders-mission-sheet
Sheet: Pay Calculator

Mission | Military Appreciation Days |  |  |  |  |  |  |  |  | Mission Cost Estimate Sheet
Location: | Heartland Park, Topeka, KS
Start Point: | Kansas City Armory
[NAME] | Topeka, Kansas
End Point: | Kansas City Armory
Unit | 778th TC
Unit POC
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
1 |  |  |  |  |  | E-6 | 22 | 108.11 | 5 | 540.55 | 27.54 | 54 | 3 |  | 0 | 0 | 0 | 0 | 568.0899999999999
2 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
3 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
4 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
5 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
6 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
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