CAPF 5s and CAPF9s Report: Difference between revisions
Created page with "== "CAPF 5s and CAPF9s Given by Check Pilots in the Past Year" Heading text == === To use the Report for sorting or filtering === # Download the excel "CAPF 5s and CAPF 9..." |
No edit summary |
||
| Line 13: | Line 13: | ||
# Delete Column C and H (will have a #REF in them) | # Delete Column C and H (will have a #REF in them) | ||
# Delete Bad rows at the bottom | # Delete Bad rows at the bottom | ||
To Fix the dates | |||
# Select Column E | |||
# type Ctrl-H (find/replace), | |||
# in "Find What" field, type _Jan_ where the _ is really a blank | |||
# in "Replace With" field, type -Jan- | |||
# Click Replace All button or type Alt-A | |||
# Repeat steps 3) to 5) for every month. | |||
The report is then sortable | The report is then sortable | ||
Latest revision as of 16:11, 31 March 2020
== "CAPF 5s and CAPF9s Given by Check Pilots in the Past Year" Heading text ==
To use the Report for sorting or filtering
- Download the excel "CAPF 5s and CAPF 91s given in the past year"
- Delete the first 4 lines (CAP Logo and title) TOP Line should be the headers Full Name Task Completed Aircraft Check Pilot
- Select Entire Speadsheet
- Click on Home > Merge & Center > Unmerge Cells
- Click on Home > Find & Select > Go to Special > Select Blanks
- Go to the first blank Cell that is highlighted
- Type = and the press Up Arrow (the cell should fill with the cell letter and Number
- Press CTRL + Enter
- Delete Column C and H (will have a #REF in them)
- Delete Bad rows at the bottom
To Fix the dates
- Select Column E
- type Ctrl-H (find/replace),
- in "Find What" field, type _Jan_ where the _ is really a blank
- in "Replace With" field, type -Jan-
- Click Replace All button or type Alt-A
- Repeat steps 3) to 5) for every month.
The report is then sortable