Spreadsheet: 22189d1210798618-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 |  | 50 | 36 | 150 | 180 | 898.0899999999999
2 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
3 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
4 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
5 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
6 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
7 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
8 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
9 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
10 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
11 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
12 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
13 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
14 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
15 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
16 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
17 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
18 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
19 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
20 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
21 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
22 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
23 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
24 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
25 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
26 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
27 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
28 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
29 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
30 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
31 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
32 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
33 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
34 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
35 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
36 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
37 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
38 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
39 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A
40 |  |  |  |  |  |  |  |  | 0 | #N/A | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | #N/A