CAPF 5s and CAPF9s Report: Difference between revisions

From CAPipedia
VisualWikitext
(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 17: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

  1. Download the excel "CAPF 5s and CAPF 91s given in the past year"
  2. Delete the first 4 lines (CAP Logo and title) TOP Line should be the headers Full Name Task Completed Aircraft Check Pilot
  3. Select Entire Speadsheet
  4. Click on Home > Merge & Center > Unmerge Cells
  5. Click on Home > Find & Select > Go to Special > Select Blanks
  6. Go to the first blank Cell that is highlighted
  7. Type = and the press Up Arrow (the cell should fill with the cell letter and Number
  8. Press CTRL + Enter
  9. Delete Column C and H (will have a #REF in them)
  10. Delete Bad rows at the bottom

To Fix the dates

  1. Select Column E
  2. type Ctrl-H (find/replace),
  3. in "Find What" field, type _Jan_ where the _ is really a blank
  4. in "Replace With" field, type -Jan-
  5. Click Replace All button or type Alt-A
  6. Repeat steps 3) to 5) for every month.

The report is then sortable

Retrieved from "https://capipedia.cap.gov/index.php?title=CAPF_5s_and_CAPF9s_Report&oldid=356"