{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Data Entry","Report","Mission_Symbols","Old Mission Symbols","VersionHistory","Aircraft"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":30,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":85,"n_cols":1,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
["Crew Chief Month Reporting Procedures"]
[{"$f":"\"Version\" & MAX(VersionHistory!$B:$B)","v":"Version39"}]
[]
[]
["1.    Inspect Aircraft"]
[]
["a.     Print a CAPF71 from the \"Forms & Publications\" section of the National Website and take it with you to aircraft."]
["b.    Complete Sections 2 through 6.  The remainder of the form will need to be completed later in the process with information from WMIRS. Ignore line item 1B"]
["c.     Print a copy of the WMIRS discrepancy log (obtain from WMIRS main page, link \"Aircraft Discrepancy Log\") and review at the aircraft."]
["d.    Note any new discrepancies or any items are complete but have not been closed out."]
[]
["2.    Inspect the Aircraft Information File Binder"]
[]
["This item is best accomplished inside the squadron officer or flight planning office where extended access to the internet and a printer is available.  Note that the AIF must be in the aircraft prior to flight."]
[]
["a.     Remove the Aircraft Flight Log Pages from Tab#1 for the previous month."]
["b.     Add blank flight log pages, if necessary.  A customized version for NCWG is available on the NCWG website in the operations section."]
["c.    Ensure all the other Tabs are up-to-date with the latest AIF information."]
[]
["(1)   Navigate to the capmembers.com page. "]
["(2)   Select the \"CAP Pilot\" link on the left column, then the \"AIF - Standardized CAP Aircraft Information File\" link in the left margin menu."]
["(3)   From the \"Current Version of Contents\" link, verify each tab of your AIF is up-to-date (review the AIF Layout instructions as necessary)."]
[]
["e.     Verify the VOR check has been completed within the last 30-days.  If necessary and if possible, do a VOR test when placing the AIF back in the aircraft and make the corresponding entry in Tab #3."]
["f.      Verify the GPS is updated and recorded in Tab#15 of AIF, if applicable."]
["g.    Ensure the latest FCIF files are place in Tab#13."]
[]
["Ensure the Binder is a 3” Heavy Duty White Binder in satisfactory condition with clear front back sleeve pockets (suggest Staples \"3 inch White Avery® Heavy-Duty View Binder).  Ensure the Tabs are Avery® 15-Tab Ready Index® Multicolor Table of Contents Dividers, Single Set\" (Avery P/N 11143).  If squadron funds are not available, please notify the NCWG DO for assistance."]
[]
["3.    Review/Update the WMIRS Maintenance Information "]
[]
["a.     Navigate to the WMIRS Maintenance module “Aircraft Availability Page”"]
["(1)   From the WMIRS Main menu, click \"tools and utilities\" link in the left-hand column."]
["(2)   Click the \"maintenance module\" link."]
["(3)   Click the \"Aircraft Resource Matrix\" link."]
["(4)   Select the appropriate aircraft “N-number” button.  This is the Aircraft Availability Page for this aircraft."]
["(5) Review Data then hit the \"Maintenance Data\" button and further review"]
[]
["b.    Verify the aircraft status and location.  If changes are made, update, click the “Submit Query\" button and then navigate back to the Aircraft Availability page."]
["c.     Click on \"Maintenance Data\" button."]
["d.    Review all information.  The last Hobbs/Tach times and dates are now automatically updated via WMIRS and should NOT require manual update.  Note any items due within 15-hours. Select “Update” when finished.  Note any items on the discrepancy list that are closed but still listed. "]
["e.     Add any new discrepancies."]
["f.      Print out a new “AIF Coverpage” and place in the front cover sleeve of the AIF binder.  "]
["If updates were made, the system will offer you to download the new Maintenance Data page; otherwise you can print it by clicking the “AIF Coverpage” button when on the Aircraft Availability page."]
["g.    Complete the CAPF71 Top information and Section 1 (except 1B) using information for the WMIRS Maintenance module. Make a copy for the monthly report and insert the completed CAPF71 into the sleeve in Tab#3 of the AIF binder."]
["h.    Return to the aircraft and complete the checklist on the bottom of the AIF coverpage.  Note any missing items."]
["i.      Place the AIF back in the aircraft (must be in the a/c prior to flight)."]
["j.      Notify the Wing Maintenance Officer and Wing DO by email if there are:"]
[]
["(1)   Any maintenance items within 15-hours.  Project the date that maintenance will be needed as the shop requires a minimum of 1 week notice to schedule otherwise delays may be incurred."]
["(2)   Any items on the discrepancy list that are complete but listed as open.  You’ll need to provide the tach time when the item was resolved so that the item can be closed out by the Wing Maint Officer or Wing DO."]
["(3)   Any missing inventory items noted from the “Coverpage” ie. tie-downs, pitot-tube covers, cargo net, etc."]
[]
["4.    Complete the \"NCWGF10 Spreadsheet “Data Entry\" worksheet "]
[]
["The remainder of this process can be completed at home.  All log entries and WMIRS entries must match 100%, all member check issues must be resolved and the reports must mailed/emailed prior to the 5th of the month.  "]
[]
["a.     Open the excel version of the NCWGF10 Worksheet (You must enable macros for this workbook to complete the forms).  The latest version is available for download from the NCWG Website operations section."]
["b.    Select the \"Data Entry\" worksheet tab."]
["c.     Complete all report header information in the \"blue\" cells and select an Aircraft from the dropdown list."]
["d.    Enter the starting Hobbs and Tach time in the top of the Hobbs/Tach columns (cells will display RED if not entered)."]
["e.     Each row in the table represents a line item from the AIF Flight Time Log.  Enter all information in the 'Blue' Cells.  The mission symbol is required for the “Amount Due” line item to be calculated. "]
["f.      Enter the member check information.  If an amount is due, the Check Amount, Check Number, and Check Payee information will show up in RED (header information must be entered correctly for this to function).  Enter the Check Amount.  If the amount is the correct amount the cell will show in GREEN otherwise it will show in YELLOW.  Enter the Check Number and Payee name.  NOTE:  If a check covers multiply flights, split the amounts accordingly and enter the EXACT Check No and Payee for each of the flight legs; they will be totaled on the “Report” summary worksheet tab."]
["g.    Calculate the total flight hours from the Aircraft Flight Log by subtracting the 1st flight starting time from the last flight ending time"]
["h.    Verify the worksheet hobbs and tach totals match the totals calculated in the previous items."]
["i.      RESOLVE ANY DISCREPANCIES.  "]
["(1)   Ensure the flight totals reported on the AIF Flight log match the spreadsheet totals for each flight. "]
["(2)   On the AIF logs, ensure that the starting flight times match the previous flight ending times.  If issues still persist, it may be helpful to print out the WMIRS aircraft log from the WMIRS report menu and compare each line item on the AIF Flight log to each line item in the .WMIRS Aircraft Log”."]
[]
["WMIRS CORRECTIONS.  If the reported times need correcting in WMIRS, notify the PIC and either fix it in WMIRS yourself or have the PIC correct if time is not of the essence.  If this becomes a chronic issue, report the PIC to the Wing DO.  If the WMIRS entry is locked, notify the Wing DO and Wing administrator by email"]
[]
["5.    Compare the “Report” summary to the WMIRS “Form 18” summary"]
[]
["a.     Navigate to the WMIRS report menu and select the “WMIRS Form 18 Comparison Report”."]
["b.    Compare the Mission Symbol Totals with those on the NCWGF10 spreadsheet “Report”."]
["c.     RESOLVE ANY DISCREPANCIES.  (See WMIRS Corrections above)."]
["All log entries and WMIRS entries must match 100%"]
[]
[]
["6.    Email the following items to \"AC-Reports@ncwgcap.org NLT the 5th of the month"]
[]
["(1)   The actual NCWGF10 spreadsheet file."]
["(2)   Scanned copies of all AIF Flight Log Pages."]
["(3)   Scanned copy of the newly created CAPF71."]
["(4)   Within body the email.  Specify the date of the latest VOR Check."]

{"sheet":"Data Entry","index":1,"n_rows":72,"n_cols":9,"rows_kept":72,"cut":false,"hidden":false,"merged":[[2,2,2,7],[10,1,10,8],[10,9,12,11],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,12,3],[4,8,4,10],[11,7,12,7],[11,4,12,4],[11,8,12,8],[8,4,9,10],[5,8,5,10],[6,8,6,10]]}
["Aircraft Flight Time Log"]
[{"$f":"\"Version \" & MAX(VersionHistory!$B:$B)","v":"Version 39"}]
[null,null,"Items in RED must be filled in.  NO EXCEPTIONS!!!"]
[]
[null,"Ending Month:  ","Oct","Year:  ",2020,null,null,"Date Prepared:  ",{"$f":"TODAY()","v":"2020-11-22"}]
[null,"Aircraft:  ",null,"Type:  ",{"$f":"IF(AirCraft<>\"\",VLOOKUP(AirCraft,Aircraft_Data,3,FALSE),\"\")","v":""},null,null,"Reporting Officer:  "]
[null,"Corporate A/C:  ","Yes",null,null,null,null,"Squadron Name:  "]
[]
[null,"Days Down:  (0 if none)",null,"Reason:  "]
[]
[null,"* Code must be the same as listed on Report Sheet (i.e. A02, not A2 or A-02) Use only \"CMX\" for Maintenance"]
["Date","Code*","Mission","Sortie","Name","Ending Hobbs","Ending Tach","Hobbs Time","Tach Time"]
[]
[null,null,null,null,null,null,null,{"$f":"IF(F14=0,0,F14-F13)","v":0},{"$f":"IF(G14=0,0,G14-G13)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(F15=0,0,F15-F14)","v":0},{"$f":"IF(G15=0,0,G15-G14)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(F16=0,0,F16-F15)","v":0},{"$f":"IF(G16=0,0,G16-G15)","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,{"$f":"IF(G65=0,0,G65-G64)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(F66=0,0,F66-F65)","v":0},{"$f":"IF(G66=0,0,G66-G65)","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
["TOTAL",null,null,null,null,null,null,{"$f":"SUM(H14:H71)","v":0},{"$f":"SUM(I14:I71)","v":0}]

{"sheet":"Report","index":2,"n_rows":113,"n_cols":9,"rows_kept":113,"cut":false,"hidden":false,"merged":[[112,2,115,7],[4,6,4,8],[3,6,3,8],[4,4,4,5],[9,1,9,3]]}
["North Carolina Wing Monthly Aircraft Use Summary"]
[{"$f":"\"NCWGF10 revised \" & TEXT(MAX(VersionHistory!$A:$A),\"d-mmm-yy\")","v":"NCWGF10 revised 22-Nov-20"}]
[]
["For the Month of:",null,{"$f":"Month_Ending&\" / \" &Year_Ending","v":"Oct / 2020"},null,"Reporting Officer:",null,{"$f":"IF(LEN(Reporting_Officer)>0,Reporting_Officer,\"\")","v":""}]
["Tail Number: ",null,{"$f":"AirCraft","v":0},null,"Date Prepared: ",null,{"$f":"'Data Entry'!I5","v":"2020-11-22"}]
["AC Type:",null,{"$f":"AirCraft_Type","v":""}]
["Corp. Aircraft:",null,{"$f":"IF(LEFT(UPPER(Corporate_AC),1)=\"Y\",\"Yes\",\"No\")","v":"Yes"}]
[]
[]
[null,"HOBBS Time Summary by Mission Code"]
[null,"Code","Mission Funded","Member/Wing Funded"]
[null,{"$f":"Mission_Symbols!A4","v":"A00"},{"$f":"IF(ISTEXT($B12),IF(LEFT(VLOOKUP($B12,MissionSymbols,3,FALSE),1)=\"N\",SUMIF(Mission_Sym,$B12,Hobbs_Times),\"\"),\"\")","v":0},{"$f":"IF(ISTEXT($B12),IF(LEFT(VLOOKUP($B12,MissionSymbols,3,FALSE),1)=\"Y\",SUMIF(Mission_Sym,$B12,Hobbs_Times),\"\"),\"\")","v":""}]
[null,{"$f":"Mission_Symbols!A5","v":"A01"},0,""]
[null,{"$f":"Mission_Symbols!A6","v":"A02"},0,""]
[null,{"$f":"Mission_Symbols!A7","v":"A03"},0,""]
[null,{"$f":"Mission_Symbols!A8","v":"A04"},0,""]
[null,{"$f":"Mission_Symbols!A9","v":"A05"},0,""]
[null,{"$f":"Mission_Symbols!A10","v":"A06"},0,""]
[null,{"$f":"Mission_Symbols!A11","v":"A07"},0,""]
[null,{"$f":"Mission_Symbols!A12","v":"A08"},0,""]
[null,{"$f":"Mission_Symbols!A13","v":"A09"},0,""]
[null,{"$f":"Mission_Symbols!A14","v":"A12"},0,""]
[null,{"$f":"Mission_Symbols!A15","v":"A15"},0,""]
[null,{"$f":"Mission_Symbols!A16","v":"A16"},0,""]
[null,{"$f":"Mission_Symbols!A17","v":"A17"},0,""]
[null,{"$f":"Mission_Symbols!A18","v":"A18"},0,""]
[null,{"$f":"Mission_Symbols!A19","v":"A19"},0,""]
[null,{"$f":"Mission_Symbols!A20","v":"A22"},0,""]
[null,{"$f":"Mission_Symbols!A21","v":"A23"},0,""]
[null,{"$f":"Mission_Symbols!A22","v":"A24"},0,""]
[null,{"$f":"Mission_Symbols!A23","v":"A25"},0,""]
[null,{"$f":"Mission_Symbols!A24","v":"A26"},0,""]
[null,{"$f":"Mission_Symbols!A25","v":"A27"},0,""]
[null,{"$f":"Mission_Symbols!A26","v":"A28"},0,""]
[null,{"$f":"Mission_Symbols!A27","v":"A40"},0,""]
[null,{"$f":"Mission_Symbols!A28","v":"A41"},0,""]
[null,{"$f":"Mission_Symbols!A29","v":"A42"},0,""]
[null,{"$f":"Mission_Symbols!A30","v":"A43"},0,""]
[null,{"$f":"Mission_Symbols!A31","v":"A50"},0,""]
[null,{"$f":"Mission_Symbols!A32","v":"A51"},0,""]
[null,{"$f":"Mission_Symbols!A33","v":"A52"},0,""]
[null,{"$f":"Mission_Symbols!A34","v":"A60"},0,""]
[null,{"$f":"Mission_Symbols!A35","v":"A62"},0,""]
[null,{"$f":"Mission_Symbols!A36","v":"A63"},0,""]
[null,{"$f":"Mission_Symbols!A37","v":"A80"},0,"",null,null,"Month","Hobbs","Tach"]
[null,{"$f":"Mission_Symbols!A38","v":"A81"},0,"",null,null,"End Time",{"$f":"MAX('Data Entry'!F13:F71)","v":0},{"$f":"MAX('Data Entry'!G13:G71)","v":0}]
[null,{"$f":"Mission_Symbols!A39","v":"A82"},0,"",null,null,"Start Time",{"$f":"'Data Entry'!F13","v":0},{"$f":"'Data Entry'!G13","v":0}]
[null,{"$f":"Mission_Symbols!A40","v":"A83"},0,"",null,null,"Total: ",{"$f":"H46-H47","v":0},{"$f":"I46-I47","v":0}]
[null,{"$f":"Mission_Symbols!A41","v":"A84"},0,""]
[null,{"$f":"Mission_Symbols!A42","v":"A85"},0,""]
[null,{"$f":"Mission_Symbols!A43","v":"A96"},0,""]
[null,{"$f":"Mission_Symbols!A44","v":"A97"},0,""]
[null,{"$f":"Mission_Symbols!A45","v":"A98"},0,""]
[null,{"$f":"Mission_Symbols!A46","v":"A99"},0,""]
[null,{"$f":"Mission_Symbols!A47","v":"B00"},0,""]
[null,{"$f":"Mission_Symbols!A48","v":"B03"},0,""]
[null,{"$f":"Mission_Symbols!A49","v":"B05"},"",0]
[null,{"$f":"Mission_Symbols!A50","v":"B07"},"",0]
[null,{"$f":"Mission_Symbols!A51","v":"B09"},"",0]
[null,{"$f":"Mission_Symbols!A52","v":"B10"},0,""]
[null,{"$f":"Mission_Symbols!A53","v":"B11"},0,""]
[null,{"$f":"Mission_Symbols!A54","v":"B12"},"",0]
[null,{"$f":"Mission_Symbols!A55","v":"B13"},0,""]
[null,{"$f":"Mission_Symbols!A56","v":"B14"},0,""]
[null,{"$f":"Mission_Symbols!A57","v":"B16"},0,""]
[null,{"$f":"Mission_Symbols!A58","v":"B17"},"",0]
[null,{"$f":"Mission_Symbols!A59","v":"B19"},0,""]
[null,{"$f":"Mission_Symbols!A60","v":"B20"},"",0]
[null,{"$f":"Mission_Symbols!A61","v":"B21"},0,""]
[null,{"$f":"Mission_Symbols!A62","v":"B22"},"",0]
[null,{"$f":"Mission_Symbols!A63","v":"B23"},"",0]
[null,{"$f":"Mission_Symbols!A64","v":"B24"},"",0]
[null,{"$f":"Mission_Symbols!A65","v":"B25"},"",0]
[null,{"$f":"Mission_Symbols!A66","v":"B26"},"",0]
[null,{"$f":"Mission_Symbols!A67","v":"B27"},"",0]
[null,{"$f":"Mission_Symbols!A68","v":"B28"},{"$f":"IF(ISTEXT($B76),IF(LEFT(VLOOKUP($B76,MissionSymbols,3,FALSE),1)=\"N\",SUMIF(Mission_Sym,$B76,Hobbs_Times),\"\"),\"\")","v":""},{"$f":"IF(ISTEXT($B76),IF(LEFT(VLOOKUP($B76,MissionSymbols,3,FALSE),1)=\"Y\",SUMIF(Mission_Sym,$B76,Hobbs_Times),\"\"),\"\")","v":0}]
[null,{"$f":"Mission_Symbols!A69","v":"B81"},"",0]
[null,{"$f":"Mission_Symbols!A70","v":"B82"},"",0]
[null,{"$f":"Mission_Symbols!A71","v":"B83"},"",0]
[null,{"$f":"Mission_Symbols!A72","v":"B84"},"",0]
[null,{"$f":"Mission_Symbols!A73","v":"B85"},0,""]
[null,{"$f":"Mission_Symbols!A74","v":"B86"},0,""]
[null,{"$f":"Mission_Symbols!A75","v":"B87"},0,""]
[null,{"$f":"Mission_Symbols!A76","v":"B88"},0,""]
[null,{"$f":"Mission_Symbols!A77","v":"B99"},0,""]
[null,{"$f":"Mission_Symbols!A78","v":"C07"},"",0]
[null,{"$f":"Mission_Symbols!A79","v":"C08"},"",0]
[null,{"$f":"Mission_Symbols!A80","v":"C09"},"",0]
[null,{"$f":"Mission_Symbols!A81","v":"C12"},"",0]
[null,{"$f":"Mission_Symbols!A82","v":"C14"},"",0]
[null,{"$f":"Mission_Symbols!A83","v":"C16"},"",0]
[null,{"$f":"Mission_Symbols!A84","v":"C17"},"",0]
[null,{"$f":"Mission_Symbols!A85","v":"C21"},0,""]
[null,{"$f":"Mission_Symbols!A86","v":"C22"},0,""]
[null,{"$f":"Mission_Symbols!A87","v":"C23"},"",0]
[null,{"$f":"Mission_Symbols!A88","v":"C24"},"",0]
[null,{"$f":"Mission_Symbols!A89","v":"C25"},"",0]
[null,{"$f":"Mission_Symbols!A90","v":"C26"},"",0]
[null,{"$f":"Mission_Symbols!A91","v":"C27"},"",0]
[null,{"$f":"Mission_Symbols!A92","v":"C28"},"",0]
[null,{"$f":"Mission_Symbols!A93","v":"C30"},0,""]
[null,{"$f":"Mission_Symbols!A94","v":"C80"},"",0]
[null,{"$f":"Mission_Symbols!A95","v":"C81"},"",0]
[null,{"$f":"Mission_Symbols!A96","v":"C88"},"",0]
[null,{"$f":"Mission_Symbols!A97","v":"C99"},0,""]
[null,{"$f":"Mission_Symbols!A98","v":"CMX"},0,""]
[null,{"$f":"Mission_Symbols!A99","v":"L01"},0,""]
[null,"Totals",{"$f":"SUM(C12:C107)","v":0},{"$f":"SUM(D12:D107)","v":0}]
[]
[]
[null,null,"Aircraft Down Days This Period:",null,{"$f":"Days_Down","v":0}]
[]
[null,"Reason:",{"$f":"Days_Down_Reason","v":0}]

{"sheet":"Mission_Symbols","index":3,"n_rows":99,"n_cols":3,"rows_kept":99,"cut":false,"hidden":true,"merged":[]}
["CIVIL AIR PATROL - FLIGHT MISSION SYMBOLS"]
[null,"2019-04-23"]
["Symbol Description",null,"Member Funded"]
["A00","On-Board pilot training","N"]
["A01","Search and rescue missions assigned by the Air Force Rescue Coordination Center (AFRCC), other DoD joint rescue coordination centers (Alaska, Hawaii, and Puerto Rico) or the Joint Personnel Recovery Center (JPRC).","N"]
["A02","RPA escort missions.","N"]
["A03","Counterdrug and drug interdiction missions.","N"]
["A04","Green flag missions.","N"]
["A05","AF training and evaluation missions.","N"]
["A06","Air Force Reserve Officer Training Corps (AFROTC) orientation flights, including flights to and from the orientation site and tow sorties in support of O-rides in gliders.","N"]
["A07","CAPFs 5 & 91 evaluations.","N"]
["A08","Air Force Junior Reserve Officer Training Corps (AFJROTC) orientation flights, including flights to and from the orientation site and tow sorties in support of O-rides in gliders.","N"]
["A09","Maintenance ferry flights of airworthy aircraft to and from Consolidated Maintenance Contract Program (CMCP) facilities; other CAP-USAF and NHQ/LG approved maintenance flights paid for with appropriated funds (All A9 flights must be flown by current and qualified TMPs, MPs or Cadet Orientation Pilots).","N"]
["A12","Proficiency Flights by qualified senior member pilots conducted in accordance with an Air Force Approved Proficiency Flight Profile. This includes sorties in support of proficiency flying, such as tow sorties in support of glider proficiency and vice versa.","N"]
["A15","CAP cadet orientation flights IAW CAPP 60-40 Cadet Orientation Flight Syllabus, including flights to and from the orientation site and tow sorties in support of cadet O-rides in gliders.","N"]
["A16","Regional and Wing flight academies for Cadets","N"]
["A17","National Check Pilot Standardization Course and Flight Clinic sorties flown under an Air Force mission number (reimbursed with AF funds).","N"]
["A18","Air Defense intercept and Target of Interest missions.","N"]
["A19","Teacher Orientation Program flights. Orientation flights for CAP teacher Aerospace Education Members. These missions are familiarization flights.","N"]
["A22","Nationally-accredited flight academies for Cadets. (Must be flown on a CAP approved syllabus.)","N"]
["A23","Air Force approved Technically Advanced Aircraft (TAA) Training sorties and sorties supporting aircraft upgrades.","N"]
["A24","Refresher pilot training","N"]
["A25","Flight training for senior members holding at least a Private Pilot Certificate and leading to an additional airman rating, certificate or endorsement. (Must be flown on a CAP approved syllabus.)","N"]
["A26","Flight training for approved senior members not holding at least a Private Pilot Certificate and leading to an initial FAA certificate, rating or endorsement IAW CAPR 70-1 (i.e., Solo, Private Pilot, Balloon, or Glider). (Must be flown on a CAP approved syllabus.)","N"]
["A27","Flight training for cadets holding at least a Private Pilot Certificate and leading to an additional airman rating, certificate or endorsement. (Must be flown on a CAP approved syllabus.)","N"]
["A28","Individualized flight training for cadets not holding at least a Private Pilot Certificate and leading to an initial FAA certificate, rating or endorsement. (Must be flown on a CAP approved syllabus.)","N"]
["A40","Cadet Wings – flight training for approved cadets using individualized instruction.","N"]
["A41","Cadet Wings – flight training for approved cadets using group instruction at a flight academy","N"]
["A42","Cadet Wings – Proficiency flying for cadet pilots qualified via the Cadet Wings program and conducted in accordance with an Air Force Approved Proficiency Flight Profile. This includes tow sorties in support of qualified cadet glider proficiency flying.","N"]
["A43","Cadet Wings – Follow-on flight training for cadet pilots qualified via the Cadet Wings program, holding at least a Private Pilot Certificate and leading to an additional airman rating, certificate or endorsement.","N"]
["A50","Compliance Inspections","N"]
["A51","Subordinate Unit Inspections","N"]
["A52","Command Directed Investigations and other IG-related missions","N"]
["A60","Air Force Junior ROTC Flight Academy training","N"]
["A62","Proficiency flying for pilots qualified via the AFJROTC Flight Academy program conducted in accordance with an Air Force Approved Proficiency Flight Profile.","N"]
["A63","Follow-on flight training for pilots qualified via the AFJROTC Flight Academy program and holding at least a Private Pilot Certificate and leading to an additional rating, certificate or endorsement.","N"]
["A80","sUAS Search and rescue missions assigned by the Air Force Rescue Coordination Center (AFRCC), other DoD joint rescue coordination centers (Alaska, Hawaii, and Puerto Rico) or the Joint Personnel Recovery Center (JPRC)","N"]
["A81","sUAS Proficiency Flights by qualified senior member sUAS pilots conducted in accordance with an Air Force Approved Proficiency Flight Profile.","N"]
["A82","sUAS CAP AE demonstration flights conducted within the requirements of FAA Part 101","N"]
["A83","sUAS training and evaluation missions","N"]
["A84","sUAS CAPF 5U & 91U flight evaluations","N"]
["A85","sUAS Counter sUAS and Air Defense Intercept / Target of Interest","N"]
["A96","Low-level route surveys approved and funded by the Air Force.","N"]
["A97","Range surveys approved and funded by the Air Force.","N"]
["A98","Chaplain support missions approved and funded by the Air Force.","N"]
["A99","Other missions specifically assigned by the Air Force (e.g. media, public official, etc.). This mission must be approved in advance by the Air Force.","N"]
["B00","On-Board pilot training","N"]
["B03","Counter-drug (CD) missions funded by state and/or local government","N"]
["B05","AF Training Missions paid with corporate or member funding.","Y"]
["B07","CAPFs 5 and 91 evaluations not reimbursed with AF Funds (may be paid with corporate or member funding).","Y"]
["B09","Maintenance ferry flights of airworthy aircraft to and from Consolidated Maintenance Contract Program (CMCP) facilities not reimbursed with AF Funds; other CAP-USAF and NHQ/LG approved maintenance flights (All B9 flights must be flown by current and qualified TMPs, MPs, or Cadet Orientation Pilots).","Y"]
["B10","Flights supporting the Federal Emergency Management Agency (FEMA) approved by the USAF approval authority.","N"]
["B11","Flights flown under a National Oceanic and Atmospheric Administration (NOAA) and National Weather Service (NWS) mission number and flown IAW the NOAA and NWS MOU.","N"]
["B12","Proficiency Flights by qualified senior member pilots conducted in accordance with an Air Force Approved Proficiency Flight Profile. This includes sorties in support of proficiency flying, such as tow sorties in support of glider proficiency and vice versa. (May be paid with corporate or member funding.)","Y"]
["B13","Support to federal or national agencies approved by the USAF approval authority.","N"]
["B14","Support to state, county, and local agencies when approved by the Air Force. (Exclusive of CD missions, which shall be flown under a B3 symbol.)","N"]
["B16","Regional and Wing flight academies for Cadets","N"]
["B17","National Check Pilot Standardization Course and Flight Clinic sorties flown under an Air Force mission number (not reimbursed with AF funds).","Y"]
["B19","Teacher Orientation Program flights. Orientation flights for CAP teacher Aerospace Education Members. Familiarization flights not reimbursed with AF funds.","N"]
["B20","Orientation flights for IACE cadets and their escorts including flights to and from the orientation sites.","Y"]
["B21","NHQ directed and funded missions.","N"]
["B22","Nationally-accredited flight academies for Cadets. (May be paid with corporate or member funding. Must be flown on a CAP approved syllabus.)","Y"]
["B23","Technically Advanced Aircraft (TAA) training sorties and sorties supporting aircraft upgrades.","Y"]
["B24","Refresher Pilot training","Y"]
["B25","Flight training for senior members holding at least a Private Pilot Certificate and leading to an additional airman rating, certificate or endorsement. (May be paid with corporate or member funding. Must be flown on a CAP approved syllabus.)","Y"]
["B26","Flight training for approved senior members not holding at least a Private Pilot Certificate and leading to an initial FAA certificate, rating or endorsement IAW CAPR 70-1 (i.e., Solo, Private Pilot, Balloon, or Glider). (May be paid with corporate or member funding. Must be flown on a CAP approved syllabus.)","Y"]
["B27","Flight training for cadets holding at least a Private Pilot Certificate and leading to an additional airman rating, certificate or endorsement. (May be paid with corporate or member funding.)","Y"]
["B28","Individualized flight training for cadets not holding at least a Private Pilot Certificate and leading to an initial FAA certificate, rating or endorsement. (May be paid with corporate or member funding. Must be flown on a CAP approved syllabus.)","Y"]
["B81","sUAS Proficiency Flights by qualified senior member sUAS pilots conducted in accordance with an Air Force Approved Proficiency Flight Profile.","Y"]
["B82","sUAS CAP AE demonstration flights conducted within the requirements of FAA Part 101 (not reimbursed with AF funds – may be member or corporate paid)","Y"]
["B83","sUAS training and evaluation missions paid with member or corporate funds","Y"]
["B84","sUAS CAPFs 5 and 91 evaluations not reimbursed with AF Funds (may be paid with corporate or member funding)","Y"]
["B85","sUAS Flights supporting the Federal Emergency Management Agency (FEMA) approved by the USAF approval authority.","N"]
["B86","sUAS Flights flown under a National Oceanic and Atmospheric Administration (NOAA) and National Weather Service (NWS) mission number and flown IAW the NOAA and NWS MOU.","N"]
["B87","sUAS Support to federal or national agencies approved by the USAF approval authority.","N"]
["B88","sUAS Support to state, county, and local agencies when approved by the Air Force.","N"]
["B99","Other missions specifically assigned by the Air Force (e.g. media, public official, etc.). This mission must be approved in advance by the Air Force.","N"]
["C07","CAPFs 5 & 91 evaluations not designated as an AFAM.","Y"]
["C08","Air transportation flights to and from squadron, or higher, official conferences or meetings.","Y"]
["C09","Maintenance flights associated with actual maintenance or operational checks of powered  or glider aircraft; ferry flights of airworthy aircraft to and from Consolidated Maintenance Contract Program (CMCP) facilities not reimbursed with AF Funds; other NHQ/LG approved maintenance flights (All C9 flights must be flown by current and qualified TMPs, MPs or Cadet Orientation Pilots).","Y"]
["C12","Proficiency flights not designated as an AFAM and conducted in accordance with guidance contained in the Self-Conducted Proficiency Profile.","Y"]
["C14","Support to state, county, and local agencies not assigned as an AF approved mission. (Exclusive of CD missions, which cannot be flown using corporate funds.)","Y"]
["C16","Regional and Wing flight academies for Cadets","Y"]
["C17","National Check Pilot Standardization Course sorties and Flight Clinic sorties flown & funded under CAP corporate missions.","Y"]
["C21","NHQ directed and funded missions.","N"]
["C22","Nationally-accredited flight academies for Cadets","N"]
["C23","Technically Advanced Aircraft (TAA) training and aircraft upgrades.","Y"]
["C24","Refresher Pilot training","Y"]
["C25","Flight training for senior members holding at least a Private Pilot Certificate and leading to an additional airman rating, certificate or endorsement.","Y"]
["C26","Flight training for approved senior members not holding at least a Private Pilot Certificate and leading to an initial FAA certificate, rating or endorsement IAW CAPR 70-1 (i.e., Solo, Private Pilot, Balloon, or Glider).","Y"]
["C27","Flight training for cadets holding at least a Private Pilot Certificate and leading to an additional airman rating, certificate or endorsement.","Y"]
["C28","Individualized flight training for cadets not holding at least a Private Pilot Certificate and leading to an initial FAA certificate, rating or endorsement.","Y"]
["C30","CSAG Member Corporate Flying utilizing NHQ managed budgets.","N"]
["C80","sUAS CAPF 5U & CAPF 91U not designated as an AFAM","Y"]
["C81","Maintenance flights associated with actual maintenance or operational checks of sUAS","Y"]
["C88","Support to state, county, and local agencies not assigned as an AF approved mission. (Exclusive of CD missions, which cannot be flown using corporate funds.)","Y"]
["C99","Other missions specifically approved by the National/Region/Wing Commander.","N"]
["CMX","Shop MX Time","N"]
["L01","USAF liaison personnel flying.","N"]

{"sheet":"Old Mission Symbols","index":4,"n_rows":52,"n_cols":4,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
["FLIGHT MISSION SYMBOLS"]
[]
[]
["Mission","Symbol Description","Mbr_Funded","Notes"]
["AIR FORCE ASSIGNED MISSIONS (AFAM) - Reimbursable with USAF funding"]
["A1","Search and rescue missions assigned by the Air Force Rescue Coordination Center (AFRCC)","N"]
["A2","Missions flown under a mission number issued by the Air Force National Security Emergency Preparedness office (AFNSEP) (NOTE 1)","N"]
["A3","Counterdrug actual missions","N"]
["A4","Counterdrug training missions","N"]
["A5","Search and rescue/disaster relief training/evaluations missions/CAPR 123-3 inspections (NOTE 2)","N"]
["A6","Air Force Reserve Officer Training Corps (AFROTC) orientation flights including flights to and from the orientation site","N"]
["A7","CAPFs 5 & 91 evals, NCPS course and CAPR 60-11, Pilot Continuation Training Program, Proficiency flights by qualified SAR/DR/CD mission pilots conducted pursuant to guidelines published by HQ CAP-USAF in the pilot profiles on the Stan/Eval website.","N"]
["A8","Air Force Junior Reserve Officer Training Corps (AFJROTC) orientation flights including flight to and from the orientation site","N"]
["A9","Maintenance flights in support of Consolidated Maintenance Contract Program (CMCP) (To be flown by current and qualified CAP Mission Pilots (including CAP Transport Mission Pilots))","N","modified 4/14/09 to clarify that TMP can fly this mission"]
["A15","CAP cadet orientation flights IAW CAPP 52-7 Cadet Orientation Flight Syllabus","N"]
["A18","Homeland Security missions","N"]
["A20","Glider tow plane operations supporting CAPP 52-7, Cadet Orientation Flight Syllabus. This includes ferry flights and training. If sufficient funds are available, the wing commander may fund initial tow pilot training for up to two pilots each fiscal year from the wing’s training or orientation flight budget.","N"]
["A99","Missions specifically approved by the Air Force including low-level survey, courier, etc","N"]
["AFAM – USAF Non-reimbursable (May be reimbursed by non-Air Force agencies)"]
["B5","AF Training Missions paid for with corporate funding","N","Added 10/2/2009"]
["B8","Flights flown for and funded by the American Red Cross","N"]
["B9","Maintenance flights in support of aircraft delivery and pickup (other than CMCP flights)","Y"]
["B10","Flights flown under a Federal Emergency Management Agency (FEMA) mission number and flown IAW the FEMA memorandum of understanding (MOU)","N"]
["B11","Flights flown under a National Oceanic and Atmospheric Administration (NOAA) and National Weather Service (NWS) mission number and flown IAW the NOAA and NWS memorandums of understanding.","N"]
["B12","Proficiency flight by qualified SAR/DR/CD mission pilots conducted pursuant to guidelines published by HQ CAP-USAF in the pilot profiles on the Stan/Eval website and SAR/DR training in accordance with CAPR 60-3.","Y"]
["B13","Support to federal or national relief agencies with an Air Force approved MOU","N"]
["B14","Support to state, county, and local agencies when approved and assigned by AF/XOS-HA","N"]
["B15","CAP cadet orientation flights IAW CAPP 52-7, Cadet Orientation Flight Syllabus, (not reimbursed with AF funds)","N"]
["B16","Orientation flights for IACE cadets and their escorts","N"]
["B17","CAPFs 5 and 91 evaluations, National Check Pilot Standardization Course, and flight clinics flown under an Air Force mission number","Y"]
["B18","Homeland Security Missions","N"]
["B20","Glider tow plane operations supporting CAPP 52-7, Cadet Orientation Flight Syllabus. This includes non-reimbursed ferry flights and training","N"]
["B21","NHQ directed and funded missions","N"]
["B99","Other missions specifically assigned by the Air Force (e.g. media, public official, etc.). This mission must be approved in advance by the Air Force","N"]
["CAP Corporate Missions"]
["C8","Air transportation flights to and from squadron or higher official conferences or meetings","Y"]
["C9","Maintenance flights (includes flights in support of aircraft delivery and pickup)","Y"]
["C14","Support to state, county, and local agencies not assigned as an AF approved mission","N"]
["C16","Cadet flights including training, flight encampments/academies, cadet encampments","Y"]
["C17","CAPFs 5 & 91 evaluations and proficiency flights not designated as an AFAM","Y"]
["C18","Homeland Security Missions not designated as an AFAM","N"]
["C19","Orientation flights for CAP Aerospace Education Members. These missions are familiarization flights flown without any formalized syllabus","N"]
["C20","Glider tow plane flights for non-USAF missions (includes ferry/training flights)","Y"]
["C21","NHQ directed and funded missions","N"]
["C99","Other missions specifically approved by the National/Region/Wing Commander","N"]
["C911","Missions requiring prompt action to save lives, prevent human suffering, or to mitigate great property damage. These missions may be funded by a customer or the CAP Wing’s corporate (non-appropriated) budget","N"]
["Other"]
["L1","USAF liaison personnel flying","N"]
["CMX","Consolidated Maintenance","N"]
[]
["NOTE 1:","Does not include FEMA (B10) missions, Red Cross (B8) missions, or support to other federal or national relief agencies with an Air Force approved MOU (B13)."]
["NOTE 2:","CAPR 123-3 inspections are only authorized as an A5 mission through a training mission request via WMIRS."]

{"sheet":"VersionHistory","index":5,"n_rows":56,"n_cols":6,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
["Revision History"]
[]
["Date","Version","Changes"]
["2006-11-01",4,"Changed C9 to be mission funded per NCWG policy. "]
["2007-01-02",5,"Corrected missing sum on 'Check Manifest K13 and K14.  Made that columns commands  consistant. "]
["2007-04-03","5a & 5b","Changed some fonts"]
["2007-08-05","5c","Removed inappropriate tach & hobbs totals in F47 and G47 of ENT page.  Added version reference to ENT page."]
["2007-10-31","5d","Set '0' values to show blanks. (Tools-Optons-ViewTab-uncheck 'Zero Values')"]
["2007-11-05","5e","Hobbs and Tach entry colums on 'Ent' page moved to match sequence of new form 10A.  "]
["2007-12-03","5f","Changed to calculate amount due from Hobbs instead of Tach time.   **UNUSEABLE  - CALCULATION ERRORS CREATED**"]
["2007-12-05",6,"Changed to calculate amount due from Hobbs instead of Tach time.  Version 5f calculation errors in 'ENT' column  L  fixed.  "]
["2008-01-06",7,"Added A9 mission code to Report page and ENT page for calculations.  Altered format of 'Aircraft down days reason'   to accommodate more text."]
["2008-01-07",8,"Added B8 and removed C20 & B20 mission codes.  Removed attempt at B17 mission funded calculation."]
["2008-01-25",9,"On report page, eliminated names from showing when there is no check amount entered on the 'ENT' page. "]
["2008-07-01",10,"Protected calculated cells.  Shaded all entry cells. Froze 'panes' to keep header visible in ENT page."]
["2008-07-01",11,"Moved all data entry to 1 page, Renamed ENT page to 'Data Entry', added conditional formating"]
[null,null,"If payee is not PIC, add payee after checkno separated by a space"]
["2009-04-14",12,"Added all mission codes except glider related (A20/B20/C20), due NFA missions (C21)"]
["2009-10-02",13,"Added B5 "]
["2010-01-30",14,"Populate Check_Manifest via Macro so that checks are listed without blank lines between entries"]
["2010-06-15",15,"Breakup check/payee data into 2 columns"]
["2010-08-01",16,"Add aircraft drop-down; A/C type and rate automatically populate"]
["2010-08-09",16.100000000000001,"Fixed missing missing formula in hobbs/tach column"]
["2010-10-04",16.2,"Change C16 to be member funded"]
["2011-02-05",16.3,"Added N727VA and N9841L"]
["2011-02-25",17,"Deleted Check Manifest Report, Summarized checks (applied to multiple flights on data entry page) on Summary Page, Deleted FRO column"]
[null,null,"Modified Report, added error cell for Hobss vs summary, changed conditional formating on data entry page",null,null,"PASSWORD: 737va"]
["2011-03-06",17.100000000000001,"Validaton and Autofil on Dates, Rearrange header info, Prevent adding addl sheets, Generate filename on save, conditional formulas and formats"]
[null,null,"on report page summary table."]
["2011-03-20",17.2,"Added addl conditional formating for date entry page.  If date entered on line item, all reqd. fields show red until entered"]
["2011-08-08",17.3,"Added CMX Mission Symbol , removed N1951F, N99700 and N6006C from AC List"]
["2011-09-12",17.399999999999999,"Modivied 'Save As' Code"]
["2011-09-18",17.5,"Added Missing Month of Sept and disabled Save-As code"]
["2012-09-05",17.600000000000001,"Added Aircraft: N179CP and N4813C, Modify default dates on worksheet open"]
["2012-10-26",18,"Add $2/hr NCWG adder, Removed Check/Pmt information due to online payments (orig listed as version 17.7, but maj change due to finance data removal)"]
["2012-11-05",18.100000000000001,"fix minor formating issues"]
["2013-07-31",20,"add new mission symbols"]
["2013-10-29",21,"removed pilot unfunded cost tracking as done no longer locally collected and ntl has reporting to track this and online billing, revised instructions"]
["2014-01-29",22,"Update Year Dropdown box values to allow for 2014 and future"]
["2014-09-09",23,"Added N893CP & N9522L"]
["2015-02-03",24,"Added N7360C removed N9421L and duplicate of N4813C"]
["2015-03-01",25,"Removed N893CP and Added N741CP. Also changed Callsign for N7360C."]
["2015-04-06",26,"Adjusted lines to match new AIF sheet. Removed N99162 added N908CP"]
["2015-08-05",27,"Removed N9522L from aircraft list"]
["2015-09-04",28,"Added N726CP to aircraft list"]
["2016-03-27",29,"Added N938CP to aircraft list. Modified all aircraft call signs to reflect April 1 2016 changes."]
["2017-01-04",30,"Added N405CV and N819CP to aircraft list."]
["2018-01-03",31,"Added N262CP and N358CP to aircraft list. Updated years"]
["2018-04-01",32,"Adding 262 to drop down"]
["2018-11-04",33,"New Mission Symbols and N98426 Addition"]
["2019-04-30",34,"New Mission Symbols"]
["2019-05-06",35,"Revised Mission symbols"]
["2020-01-24",36,"Added new years to data"]
["2020-02-05",37,"Corrected mission funding symbols on the report."]
["2020-11-03",38,"Added mission symbols A00, A24, B00, B24; adjusted Report sheet"]
["2020-11-22",39,"Added mission symbol C24; adjusted Report sheet"]

{"sheet":"Aircraft","index":6,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Aircraft","CAP","Type",null,"Month","Year"]
["N179CP",3279,"C182T/G1000",null,"Jan",2020]
["N262CP",3262,"C182T/G1000",null,"Feb",2021]
["N358CP",9958,"C182T/G1000",null,"Mar",2022]
["N405CV",3205,"C182T/G1000",null,"Apr"]
["N4813C",3213,"C172P",null,"May"]
["N716CP",3216,"C182T/G1000",null,"Jun"]
["N726CP",3226,"C172S/G1000",null,"Jul"]
["N727CP",3227,"C182T/G1000",null,"Aug"]
["N7360C",3260,"C206G",null,"Sep"]
["N741CP",3241,"C182T/G1000",null,"Oct"]
["N819CP",3219,"C182T/G1000",null,"Nov"]
["N908CP",3208,"C172P",null,"Dec"]
["N938CP",3238,"C182T/G1000"]
["N963CP",3263,"C182T/G1000"]
["N9930E",3230,"C182R"]
["N98426",3242,"C172P"]
["N99832",3232,"C172P"]
["N99885",3285,"C172P"]
["N605CP",4531,"GA8"]
["N608CP",9908,"GA8"]