{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Home","WAPS CALC","E8 E9 WAPS CALC","Medals","SSgt Cutoff","TSgt Cutoff","MSgt Cutoff","SMSgt Cutoff","CMSgt Cutoff","Reference Sheet","Promo Rates","Finance","Macros"],"not_rendered":{"charts":1,"images":137,"macros":1,"defined_names":96,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":58,"n_cols":13,"rows_kept":58,"merged":[[1,6,3,11],[1,12,2,16],[3,12,3,16],[4,12,4,16],[5,12,5,16],[6,12,6,16],[7,12,7,16],[8,12,8,16],[9,12,9,16],[10,12,10,16],[11,12,11,16],[12,12,12,16],[13,12,13,16],[14,1,15,5],[15,12,15,16],[16,12,16,16],[17,2,17,4],[18,2,18,4],[19,2,19,4],[19,5,19,6],[19,11,19,12],[20,2,20,4],[20,5,20,6],[21,2,21,4],[21,5,21,6],[23,2,23,8],[25,2,25,8],[27,2,27,6],[27,7,27,8],[28,2,28,6],[28,7,28,8],[29,2,29,6],[29,7,29,8],[30,2,30,6],[30,7,30,8],[31,2,31,6],[31,7,31,8],[32,2,32,6],[32,7,32,8],[33,2,33,6],[33,7,33,8],[34,2,34,6],[34,7,34,8],[35,2,35,6],[35,7,35,8],[36,2,36,6],[36,7,36,8],[37,2,37,6],[37,7,37,8],[39,1,40,6],[39,11,40,16],[40,8,40,9],[41,1,47,6],[41,7,46,10],[41,11,49,16],[50,11,50,16]]}
[]
[{"$nulls":12},"Useful Air Force Links"]
[]
[{"$nulls":12},"Scott Career Assistance Advisor (Secure Website)"]
[{"$nulls":12},"Airman Promotion Program"]
[{"$nulls":12},"www.usmilitary.about.com"]
[{"$nulls":12},"www.gruntsmilitary.com"]
[{"$nulls":12},"www.chairforce.com"]
[{"$nulls":12},"EPR Bullet Tracker"]
[{"$nulls":12},"www.afmentor.com"]
[{"$nulls":12},"www.afforums.com"]
[{"$nulls":12},"Fitness Calculator"]
[{"$nulls":12},"www.stanish.net"]
[{"$nulls":12},"www.dfas.mil/"]
[]
[{"$nulls":12},"Get the latest version of WAPS Calculator @"]
[{"$nulls":12},"www.wapscalc.com"]
[null,null,"Select rank your testing for",null,null,1,{"$f":"VLOOKUP(F18,'Reference Sheet'!D14:E19,2)","v":0}]
[null,null,"What year will you test in",null,null,{"$f":"VLOOKUP(G19,'Reference Sheet'!T3:U16,2)","v":0},1]
[null,null,"What is your TAFMSD"]
[null,null,"What is your current DOR"]
[null,null,"What is your test date"]
[]
[null,{"$f":"IF($G$18=\"MSgt\",VLOOKUP($F$19,E7Cycle,13,FALSE),IF($G$18=\"TSgt\",VLOOKUP($F$19,E6Cycle,13,FALSE),IF($G$18=\"SSgt\",VLOOKUP($F$19,e5cycle,13,FALSE),IF($G$18=\"SMSgt\",VLOOKUP($F$19,E8Cycle,13,FALSE),IF($G$18=\"CMSgt\",VLOOKUP($F$19,E9Cycle,13,FALSE),\"\")))))-TODAY()","v":{"$error":"#VALUE!"}},{"$f":"\"You have \"&IF($G$18=\"MSgt\",VLOOKUP($F$19,E7Cycle,13,FALSE),IF($G$18=\"TSgt\",VLOOKUP($F$19,E6Cycle,13,FALSE),IF($G$18=\"SSgt\",VLOOKUP($F$19,e5cycle,13,FALSE),IF($G$18=\"SMSgt\",VLOOKUP($F$19,E8Cycle,13,FALSE),IF($G$18=\"CMSgt\",VLOOKUP($F$19,E9Cycle,13,FALSE),\"\")))))-TODAY()&\" days until your \"&H28&\" promotion cycle begins\"","v":{"$error":"#VALUE!"}}]
[]
[null,{"$f":"F22-TODAY()","v":-39773},{"$f":"IF(B26>=0,\"You have \"&B26&\" days before you will test for \"&G18&\".  Good luck!\",\"\")","v":""}]
[]
[null,null,"Testing Cycle",{"$nulls":4},{"$f":"IF($G$18=\"MSgt\",VLOOKUP($F$19,E7Cycle,2,FALSE),IF($G$18=\"TSgt\",VLOOKUP($F$19,E6Cycle,2,FALSE),IF($G$18=\"SSgt\",VLOOKUP($F$19,e5cycle,2,FALSE),IF($G$18=\"SMSgt\",VLOOKUP($F$19,E8Cycle,2,FALSE),IF($G$18=\"CMSgt\",VLOOKUP($F$19,E9Cycle,2,FALSE),\"\")))))","v":""}]
[null,null,{"$f":"IF(G18=0,\"DOR\",\"You must have put \"&VLOOKUP(G18,'Reference Sheet'!F26:G30,2,)&\" on before\")","v":"DOR"},{"$nulls":4},{"$f":"IF($G$18=\"MSgt\",VLOOKUP($F$19,E7Cycle,3,FALSE),IF($G$18=\"TSgt\",VLOOKUP($F$19,E6Cycle,3,FALSE),IF($G$18=\"SSgt\",VLOOKUP($F$19,e5cycle,3,FALSE),IF($G$18=\"SMSgt\",VLOOKUP($F$19,E8Cycle,3,FALSE),IF($G$18=\"CMSgt\",VLOOKUP($F$19,E9Cycle,3,FALSE),\"\")))))","v":""}]
[null,null,{"$f":"IF(G18=0,\"TIG\",\"TIG: You must have held \"&VLOOKUP(G18,'Reference Sheet'!F26:G30,2,FALSE)&\" for\")","v":"TIG"},{"$nulls":4},{"$f":"IF($G$18=\"MSgt\",VLOOKUP($F$19,E7Cycle,4,FALSE),IF($G$18=\"TSgt\",VLOOKUP($F$19,E6Cycle,4,FALSE),IF($G$18=\"SSgt\",VLOOKUP($F$19,e5cycle,4,FALSE),IF($G$18=\"SMSgt\",VLOOKUP($F$19,E8Cycle,4,FALSE),IF($G$18=\"CMSgt\",VLOOKUP($F$19,E9Cycle,4,FALSE),\"\")))))","v":""}]
[null,null,"Total Active Federal Mililtary Service Date (TAFMSD)",{"$nulls":4},{"$f":"IF($G$18=\"MSgt\",VLOOKUP($F$19,E7Cycle,5,FALSE),IF($G$18=\"TSgt\",VLOOKUP($F$19,E6Cycle,5,FALSE),IF($G$18=\"SSgt\",VLOOKUP($F$19,e5cycle,5,FALSE),IF($G$18=\"SMSgt\",VLOOKUP($F$19,E8Cycle,5,FALSE),IF($G$18=\"CMSgt\",VLOOKUP($F$19,E9Cycle,5,FALSE),\"\")))))","v":""}]
[null,null,"Time in Service (TIS) Required",{"$nulls":4},{"$f":"IF($G$18=\"MSgt\",VLOOKUP($F$19,E7Cycle,6,FALSE),IF($G$18=\"TSgt\",VLOOKUP($F$19,E6Cycle,6,FALSE),IF($G$18=\"SSgt\",VLOOKUP($F$19,e5cycle,6,FALSE),IF($G$18=\"SMSgt\",VLOOKUP($F$19,E8Cycle,6,FALSE),IF($G$18=\"CMSgt\",VLOOKUP($F$19,E9Cycle,6,FALSE),\"\")))))","v":""}]
[null,null,"PAFSC Skill Level",{"$nulls":4},{"$f":"IF($G$18=\"MSgt\",VLOOKUP($F$19,E7Cycle,7,FALSE),IF($G$18=\"TSgt\",VLOOKUP($F$19,E6Cycle,7,FALSE),IF($G$18=\"SSgt\",VLOOKUP($F$19,e5cycle,7,FALSE),IF($G$18=\"SMSgt\",VLOOKUP($F$19,E8Cycle,7,FALSE),IF($G$18=\"CMSgt\",VLOOKUP($F$19,E9Cycle,7,FALSE),\"\")))))","v":""}]
[null,null,"Promotion Eligible Cutoff Date (PECD)",{"$nulls":4},{"$f":"IF($G$18=\"MSgt\",VLOOKUP($F$19,E7Cycle,8,FALSE),IF($G$18=\"TSgt\",VLOOKUP($F$19,E6Cycle,8,FALSE),IF($G$18=\"SSgt\",VLOOKUP($F$19,e5cycle,8,FALSE),IF($G$18=\"SMSgt\",VLOOKUP($F$19,E8Cycle,8,FALSE),IF($G$18=\"CMSgt\",VLOOKUP($F$19,E9Cycle,8,FALSE),\"\")))))","v":""}]
[null,null,"Testing Cycle Dates",{"$nulls":4},{"$f":"IF($G$18=\"MSgt\",VLOOKUP($F$19,E7Cycle,9,FALSE),IF($G$18=\"TSgt\",VLOOKUP($F$19,E6Cycle,9,FALSE),IF($G$18=\"SSgt\",VLOOKUP($F$19,e5cycle,9,FALSE),IF($G$18=\"SMSgt\",VLOOKUP($F$19,E8Cycle,9,FALSE),IF($G$18=\"CMSgt\",VLOOKUP($F$19,E9Cycle,9,FALSE),\"\")))))","v":""}]
[null,null,"Promotion Months",{"$nulls":4},{"$f":"IF($G$18=\"MSgt\",VLOOKUP($F$19,E7Cycle,10,FALSE),IF($G$18=\"TSgt\",VLOOKUP($F$19,E6Cycle,10,FALSE),IF($G$18=\"SSgt\",VLOOKUP($F$19,e5cycle,10,FALSE),IF($G$18=\"SMSgt\",VLOOKUP($F$19,E8Cycle,10,FALSE),IF($G$18=\"CMSgt\",VLOOKUP($F$19,E9Cycle,10,FALSE),\"\")))))","v":""}]
[null,null,"EPR's Considered",{"$nulls":4},{"$f":"IF($G$18=\"MSgt\",VLOOKUP($F$19,E7Cycle,12,FALSE),IF($G$18=\"TSgt\",VLOOKUP($F$19,E6Cycle,12,FALSE),IF($G$18=\"SSgt\",VLOOKUP($F$19,e5cycle,12,FALSE),IF($G$18=\"SMSgt\",VLOOKUP($F$19,E8Cycle,12,FALSE),IF($G$18=\"CMSgt\",VLOOKUP($F$19,E9Cycle,12,FALSE),\"\")))))","v":""}]
[null,null,"Selections Announced",{"$nulls":4},{"$f":"IF($G$18=\"MSgt\",VLOOKUP($F$19,E7Cycle,11,FALSE),IF($G$18=\"TSgt\",VLOOKUP($F$19,E6Cycle,11,FALSE),IF($G$18=\"SSgt\",VLOOKUP($F$19,e5cycle,11,FALSE),IF($G$18=\"SMSgt\",VLOOKUP($F$19,E8Cycle,11,FALSE),IF($G$18=\"CMSgt\",VLOOKUP($F$19,E9Cycle,11,FALSE),\"\")))))","v":""}]
[]
[null,"Disclaimer:",{"$nulls":9},"Use of Macros/VBA"]
[{"$nulls":8},"Created by:"]
[null,"This is not an official Air Force product.  This was made as an independent way to calculate WAPS scores and provide you a little extra information in regards to rank and pay.  Contact the author for any questions or to report any errors.",{"$nulls":5},"\nSSgt Chuck Lane\nScott AFB, Il",{"$nulls":3},"There are no macros/VBA used in calculating your WAPS scores.  The only macros/VBA that is used is to clear the WAPS calculator, display comment cells, and to utilize the userform feature to show the rank detail.  You do not need to enable macros to utilize the WAPS calculator but it is recommended so you can get full use out of this worksheet."]
{"$rows_empty":11}
[null,"Versions:"]
[null,"V1.0: 2007 Results"]
[null,null,"E5/E6/E7 Calculator only"]
[null,"V2.0: 2008 Results"]
[null,null,"Added Home Page, E8/E9 Calc, Medals Calc, Pay Scale Calc"]

{"sheet":"WAPS CALC","index":1,"n_rows":5049,"n_cols":30,"rows_kept":5049,"merged":[[1,3,3,3],[4,6,4,10],[5,3,5,12],[6,3,6,12],[7,3,7,12],[7,17,7,18],[9,4,9,6],[9,10,9,11],[9,17,9,18],[10,4,10,6],[10,10,10,11],[11,4,11,6],[11,10,11,11],[12,4,12,6],[12,10,12,11],[12,17,13,17],[12,18,13,18],[13,4,13,6],[13,10,13,11],[14,3,14,6],[14,10,14,12],[15,4,15,6],[15,10,15,11],[16,4,16,6],[16,10,16,11],[17,10,17,11],[18,6,20,6],[18,10,18,11],[18,16,19,16],[18,17,19,17],[18,18,19,18],[18,19,19,19],[21,7,21,8],[21,10,22,12],[23,10,23,11],[23,17,23,18],[24,10,24,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[27,16,36,19],[28,10,28,11],[29,10,29,11],[30,10,30,11],[31,10,31,11],[32,10,32,11],[33,7,34,7],[33,8,34,8],[33,10,33,11],[34,3,34,4],[36,3,36,12],[43,1,43,14],[45,1,45,14],[46,1,48,14],[50,1,50,14],[74,3,74,12],[99,21,99,23],[99,24,99,26],[99,27,99,29],[5006,4,5006,5],[5007,4,5007,5],[5008,4,5008,6],[5009,4,5009,6]]}
[]
[]
[]
[]
[]
[{"$nulls":3},{"$f":"IF(E12=\"\",\"\",\"You have been in the Air Force for \"&DATEDIF(E12,E5009,\"y\")&\" years, \"&DATEDIF(E12,E5009,\"ym\")&\" months, \"&DATEDIF(E12,E5009,\"md\")&\" days\"&\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(E13=\"\",\"\",\"You have been a \"&E5010&\" for \"&DATEDIF(E13,E5009,\"y\")&\" years, \"&DATEDIF(E13,E5009,\"ym\")&\" months, \"&DATEDIF(E13,E5009,\"md\")&\" days\"&\"\")","v":""}]
[{"$nulls":17},"Compare yourslef to last years averages"]
[]
[{"$nulls":3},"Select rank your testing for",{"$nulls":6},"TAFMS Points",null,{"$f":"IF(I5007>40,40,I5007)","v":0},{"$nulls":3},"# Tested",{"$f":"IF(AND($E$10=\"ssgt\",$E$11=2009),V102,IF(AND($E$10=\"tsgt\",$E$11=2009),Y102,IF(AND($E$10=\"msgt\",$E$11=2009),AB102,\"\")))","v":""}]
[{"$nulls":3},"What year will you test in?",{"$nulls":6},"TIG Points",null,{"$f":"IF(I5008>60,60,I5008)","v":0},{"$nulls":3},"Promoted",{"$f":"IF(AND($E$10=\"ssgt\",$E$11=2009),X102,IF(AND($E$10=\"tsgt\",$E$11=2009),AA102,IF(AND($E$10=\"msgt\",$E$11=2009),AD102,\"\")))","v":""},{"$f":"R11/R10","v":{"$error":"#VALUE!"}}]
[{"$nulls":3},"What is your TAFMS?",{"$nulls":6},"EPR Points",null,{"$f":"I34","v":""},{"$nulls":3},"Not Promoted",{"$f":"IF(AND($E$10=\"ssgt\",$E$11=2009),W102,IF(AND($E$10=\"tsgt\",$E$11=2009),Z102,IF(AND($E$10=\"msgt\",$E$11=2009),AC102,\"\")))","v":""},{"$f":"R12/R10","v":{"$error":"#VALUE!"}}]
[{"$nulls":3},"What is your TIG?",{"$nulls":6},"Medals Points",null,{"$f":"F35","v":0},{"$nulls":4},"You","2008 Selects"]
[{"$nulls":3},"What is your est. cutoff score?",{"$nulls":6},"Total Points Earned",null,{"$f":"IF(ISNA(SUM(M10:M13)),\"\",SUM(M10:M13))","v":0}]
[{"$nulls":3},"See 2008 Cut Off Scores",{"$nulls":6},{"$f":"IF(ISNA(VLOOKUP(M16,quotetable,2,TRUE)),\"\",VLOOKUP(M16,quotetable,2,TRUE))","v":""},{"$nulls":5},"Years TIG",{"$f":"DATEDIF(E13,T15,\"m\")/12","v":{"v":0,"d":"0.00"}},{"$f":"IF(AND($E$10=\"ssgt\",$E$11=2009),X104,IF(AND($E$10=\"tsgt\",$E$11=2009),AA104,IF(AND($E$10=\"msgt\",$E$11=2009),AD104,\"\")))","v":""},{"$f":"IF(AND(E10=\"ssgt\",E11=2009),VLOOKUP(E11,e5cycle,13,FALSE),IF(AND(E10=\"TSGT\",E11=2009),VLOOKUP(E11,E6Cycle,13,FALSE),IF(AND(E10=\"MSGT\",E11=2009),VLOOKUP(E11,E7Cycle,13,FALSE))))","v":false}]
[{"$nulls":3},"Select AFSC",{"$nulls":6},"Need To Score on SKT",null,{"$f":"IF(ISERROR(I5010/2),\"\",I5010/2)","v":0},{"$nulls":3},"Years TIS",{"$f":"DATEDIF(E12,T16,\"m\")/12","v":{"v":0,"d":"0.00"}},{"$f":"IF(AND($E$10=\"ssgt\",$E$11=2009),X105,IF(AND($E$10=\"tsgt\",$E$11=2009),AA105,IF(AND($E$10=\"msgt\",$E$11=2009),AD105,\"\")))","v":""},{"$f":"IF(AND(E10=\"ssgt\",E11=2009),VLOOKUP(E11,e5cycle,13,FALSE),IF(AND(E10=\"TSGT\",E11=2009),VLOOKUP(E11,E6Cycle,13,FALSE),IF(AND(E10=\"MSGT\",E11=2009),VLOOKUP(E11,E7Cycle,13,FALSE))))","v":false}]
[{"$nulls":3},"2008 AFSC Cutoff Scores",{"$f":"IF(E10=tech,VLOOKUP(E16,TSGT,5,FALSE),IF(E10=staff,VLOOKUP(E16,ssgt,5,FALSE),IF(E10=master,VLOOKUP(E16,msgt,5,FALSE),\"\")))","v":""},{"$nulls":5},"Need To Score on PDG",null,{"$f":"IF(ISERROR(I5010/2),\"\",I5010/2)","v":0},{"$nulls":3},"TIG Points",{"$f":"M11","v":0},{"$f":"IF(AND($E$10=\"ssgt\",$E$11=2009),X107,IF(AND($E$10=\"tsgt\",$E$11=2009),AA107,IF(AND($E$10=\"msgt\",$E$11=2009),AD107,\"\")))","v":""}]
[{"$nulls":10},"If you score this on one, \n",{"$nulls":5},"TIS Points",{"$f":"M10","v":0},{"$f":"IF(AND($E$10=\"ssgt\",$E$11=2009),X108,IF(AND($E$10=\"tsgt\",$E$11=2009),AA108,IF(AND($E$10=\"msgt\",$E$11=2009),AD108,\"\")))","v":""}]
[{"$nulls":10},"you'll need this for the other",null,{"$f":"IF(M18=\"\",\"\",SUM(M16:M17)-M18)","v":""},{"$nulls":3},"EPR",{"$f":"M12","v":""},{"$f":"IF(AND($E$10=\"ssgt\",$E$11=2009),X109,IF(AND($E$10=\"tsgt\",$E$11=2009),AA109,IF(AND($E$10=\"msgt\",$E$11=2009),AD109,\"\")))","v":""}]
[]
[{"$nulls":16},"Decorations",{"$f":"M13","v":0},{"$f":"IF(AND($E$10=\"ssgt\",$E$11=2009),X110,IF(AND($E$10=\"tsgt\",$E$11=2009),AA110,IF(AND($E$10=\"msgt\",$E$11=2009),AD110,\"\")))","v":""}]
[{"$nulls":4},"#","Pts",null,"EPR's",null,null,"Testing Eligibility",{"$nulls":5},"SKT",{"$f":"M16","v":0},{"$f":"IF(AND($E$10=\"ssgt\",$E$11=2009),X111,IF(AND($E$10=\"tsgt\",$E$11=2009),AA111,IF(AND($E$10=\"msgt\",$E$11=2009),AD111,\"\")))","v":""}]
[{"$nulls":5},{"$f":"IF(ISNA(_med1),\"\",_med1)","v":""},null,"Newest","Rating",{"$nulls":7},"PDG",{"$f":"M17","v":0},{"$f":"IF(AND($E$10=\"ssgt\",$E$11=2009),X112,IF(AND($E$10=\"tsgt\",$E$11=2009),AA112,IF(AND($E$10=\"msgt\",$E$11=2009),AD112,\"\")))","v":""}]
[{"$nulls":5},{"$f":"IF(ISNA(_med2),\"\",_med2)","v":""},null,1,null,null,"Cycle",null,{"$f":"IF($E$10=\"MSgt\",VLOOKUP($E$11,E7Cycle,2,FALSE),IF($E$10=\"TSgt\",VLOOKUP($E$11,E6Cycle,2,FALSE),IF($E$10=\"SSgt\",VLOOKUP($E$11,e5cycle,2,FALSE),\"\")))","v":""},{"$nulls":3},"Enter Bday",null,null,{"$f":"IF(AND(E10=\"ssgt\",E11=2009),VLOOKUP(E11,e5cycle,13,FALSE),IF(AND(E10=\"TSGT\",E11=2009),VLOOKUP(E11,E6Cycle,13,FALSE),IF(AND(E10=\"MSGT\",E11=2009),VLOOKUP(E11,E7Cycle,13,FALSE))))","v":false}]
[{"$nulls":5},{"$f":"IF(ISNA(_med3),\"\",_med3)","v":""},null,2,null,null,"DOR",null,{"$f":"IF($E$10=\"MSgt\",VLOOKUP($E$11,E7Cycle,3,FALSE),IF($E$10=\"TSgt\",VLOOKUP($E$11,E6Cycle,3,FALSE),IF($E$10=\"SSgt\",VLOOKUP($E$11,e5cycle,3,FALSE),\"\")))","v":""},{"$nulls":3},"Age",{"$f":"DATEDIF(R24,T24,\"m\")/12","v":{"v":0,"d":"0.00"}},{"$f":"IF(AND($E$10=\"ssgt\",$E$11=2009),X106,IF(AND($E$10=\"tsgt\",$E$11=2009),AA106,IF(AND($E$10=\"msgt\",$E$11=2009),AD106,\"\")))","v":""}]
[{"$nulls":5},{"$f":"IF(ISNA(_med4),\"\",_med4)","v":""},null,3,null,null,"TIG Required",null,{"$f":"IF($E$10=\"MSgt\",VLOOKUP($E$11,E7Cycle,4,FALSE),IF($E$10=\"TSgt\",VLOOKUP($E$11,E6Cycle,4,FALSE),IF($E$10=\"SSgt\",VLOOKUP($E$11,e5cycle,4,FALSE),\"\")))","v":""},{"$nulls":3},"Total Average",{"$f":"M14+M16+M17","v":0},{"$f":"IF(AND($E$10=\"ssgt\",$E$11=2009),X113,IF(AND($E$10=\"tsgt\",$E$11=2009),AA113,IF(AND($E$10=\"msgt\",$E$11=2009),AD113,\"\")))","v":""}]
[{"$nulls":5},{"$f":"IF(ISNA(_med5),\"\",_med5)","v":""},null,4,null,null,"TAFMSD",null,{"$f":"IF($E$10=\"MSgt\",VLOOKUP($E$11,E7Cycle,5,FALSE),IF($E$10=\"TSgt\",VLOOKUP($E$11,E6Cycle,5,FALSE),IF($E$10=\"SSgt\",VLOOKUP($E$11,e5cycle,5,FALSE),\"\")))","v":""}]
[{"$nulls":5},{"$f":"IF(ISNA(_med6),\"\",_med6)","v":""},null,5,null,null,"TIS Required",null,{"$f":"IF($E$10=\"MSgt\",VLOOKUP($E$11,E7Cycle,6,FALSE),IF($E$10=\"TSgt\",VLOOKUP($E$11,E6Cycle,6,FALSE),IF($E$10=\"SSgt\",VLOOKUP($E$11,e5cycle,6,FALSE),\"\")))","v":""},{"$nulls":3},{"$f":"\"All dates are calculated based on the first day of the \"&M24&\" test cycle.\"","v":"All dates are calculated based on the first day of the  test cycle."}]
[{"$nulls":5},{"$f":"IF(ISNA(_med7),\"\",_med7)","v":""},null,6,null,null,"PAFSC Skill Level",null,{"$f":"IF($E$10=\"MSgt\",VLOOKUP($E$11,E7Cycle,7,FALSE),IF($E$10=\"TSgt\",VLOOKUP($E$11,E6Cycle,7,FALSE),IF($E$10=\"SSgt\",VLOOKUP($E$11,e5cycle,7,FALSE),\"\")))","v":""}]
[{"$nulls":5},{"$f":"IF(ISNA(_med8),\"\",_med8)","v":""},null,7,null,null,"Prom. Eligible Cutoff Date",null,{"$f":"IF($E$10=\"MSgt\",VLOOKUP($E$11,E7Cycle,8,FALSE),IF($E$10=\"TSgt\",VLOOKUP($E$11,E6Cycle,8,FALSE),IF($E$10=\"SSgt\",VLOOKUP($E$11,e5cycle,8,FALSE),\"\")))","v":""}]
[{"$nulls":5},{"$f":"IF(ISNA(_med9),\"\",_med9)","v":""},null,8,null,null,"Testing Cycle",null,{"$f":"IF($E$10=\"MSgt\",VLOOKUP($E$11,E7Cycle,9,FALSE),IF($E$10=\"TSgt\",VLOOKUP($E$11,E6Cycle,9,FALSE),IF($E$10=\"SSgt\",VLOOKUP($E$11,e5cycle,9,FALSE),\"\")))","v":""}]
[{"$nulls":5},{"$f":"IF(ISNA(_med10),\"\",_med10)","v":""},null,9,null,null,"Promotion Months",null,{"$f":"IF($E$10=\"MSgt\",VLOOKUP($E$11,E7Cycle,10,FALSE),IF($E$10=\"TSgt\",VLOOKUP($E$11,E6Cycle,10,FALSE),IF($E$10=\"SSgt\",VLOOKUP($E$11,e5cycle,10,FALSE),\"\")))","v":""}]
[{"$nulls":5},{"$f":"IF(ISNA(_med11),\"\",_med11)","v":""},null,10,null,null,"EPR's Considered",null,{"$f":"IF($E$10=\"MSgt\",VLOOKUP($E$11,E7Cycle,12,FALSE),IF($E$10=\"TSgt\",VLOOKUP($E$11,E6Cycle,12,FALSE),IF($E$10=\"SSgt\",VLOOKUP($E$11,e5cycle,12,FALSE),\"\")))","v":""}]
[{"$nulls":5},{"$f":"IF(ISNA(_med12),\"\",_med12)","v":""},null,"Oldest",{"$f":"IF(ISERROR(Q5017/O5017),\"\",Q5017/O5017)","v":""},null,"Selections Announced",null,{"$f":"IF($E$10=\"MSgt\",VLOOKUP($E$11,E7Cycle,11,FALSE),IF($E$10=\"TSgt\",VLOOKUP($E$11,E6Cycle,11,FALSE),IF($E$10=\"SSgt\",VLOOKUP($E$11,e5cycle,11,FALSE),\"\")))","v":""}]
[{"$nulls":3},"Total Points (not to exceed 25)",null,{"$f":"IF(SUM(F23:F34)>25,25,SUM(F23:F34))","v":0}]
{"$rows_empty":64}
[{"$nulls":21},"E5",null,null,"E6",null,null,"E7"]
[{"$nulls":21},"Eligibles","NonSelects","Selects","Eligibles","NonSelects","Selects","Eligibles","NonSelects","Selects"]
[{"$nulls":20},"Nbr",28098,15889,12209,{"v":38324,"d":"38,324"},31214,7110,{"v":24223,"d":"24,223"},18819,5404]
[{"$nulls":20},"Pct",null,{"$f":"56.55/100","v":{"v":0.5655,"d":"56.55%"}},{"$f":"43.45/100","v":{"v":0.43450000000000005,"d":"43.45%"}},null,81.45,18.55,null,77.69,22.31]
[{"$nulls":20},"YRS TIG",1.98,1.78,2.25,4.22,3.92,5.54,3.58,3.37,4.32]
[{"$nulls":20},"YRS TIS",4.6,4.4,4.85,9.35,9.01,10.88,15.91,15.72,16.56]
[{"$nulls":20},"AGE",24.77,24.48,25.14,29.65,29.31,31.16,36.25,36.11,36.75]
[{"$nulls":20},"TIG POINT",17.68,16.43,19.31,31.82,30.02,{"v":39.7,"d":"39.70"},27.98,26.71,32.38]
[{"$nulls":20},"TIS POINT",11.29,10.89,11.8,20.97,20.27,24.02,33.56,33.24,34.67]
[{"$nulls":20},"EPR",128.51,126.12,131.62,132.22,131.96,133.39,133.75,133.58,134.38]
[{"$nulls":20},"DEC",0.7,0.49,0.96,3.67,3.28,5.37,9.92,9.41,{"v":11.7,"d":"11.70"}]
[{"$nulls":20},"SKT",48.74,44.45,53.69,46.19,44.42,53.97,52.52,49.84,61.86]
[{"$nulls":20},"PFE",48.57,44.31,54.1,56.83,54.21,68.35,{"v":57.1,"d":"57.10"},53.32,70.28]
[{"$nulls":20},"Total",252.35,240.02,268.39,285.62,278.32,317.66,309.08,300.65,338.46]
[{"$nulls":20},"Board"]
{"$rows_empty":4883}
[{"$nulls":11},"1979-03-26"]
[{"$nulls":11},{"$f":"TODAY()","v":"2008-11-21"}]
[{"$nulls":11},{"$f":"L4999-L4998","v":10833}]
[]
[]
[]
[]
[]
[{"$nulls":7},"days","points"]
[{"$nulls":3},"TAFMS",{"$f":"IF(E10=staff,VLOOKUP(E11,ssgt5,3,FALSE),IF(E10=tech,VLOOKUP(E11,tsgt6,3,FALSE),IF(E10=master,VLOOKUP(E11,tsgt6,3,FALSE))))","v":false},null,null,{"$f":"DATEDIF(E12,E5007,\"d\")","v":0},{"$f":"H5007*0.00547945205479452","v":0},{"$nulls":3},{"$f":"IF(E23=\"\",VLOOKUP(D23,medals,2,FALSE),VLOOKUP(D23,medals,2,FALSE)*E23)","v":{"$error":"#N/A"}},null,{"$f":"IF(I24=\"\",\"\",50)","v":""},{"$f":"IF(I24=\"\",\"\",I24*O5007)","v":""},{"$f":"IF(I24=\"\",\"\",P5007*27)","v":""},null,null,"Cycle","DOR","TIG Required","TAFMS","TIS Required","PAFSC Skill Level","PECD","Testing Cycle","Promotion Months"]
[{"$nulls":3},"TIG",{"$f":"IF(E10=staff,VLOOKUP(E11,ssgt5,2,FALSE),IF(E10=tech,VLOOKUP(E11,tsgt6,2,FALSE),IF(E10=master,VLOOKUP(E11,tsgt6,2,FALSE))))","v":false},null,null,{"$f":"DATEDIF(E13,E5008,\"d\")","v":{"v":0,"d":"0.00"}},{"$f":"H5008*0.0164383561643835","v":0},{"$nulls":3},{"$error":"#N/A"},null,{"$f":"IF(I25=\"\",\"\",45)","v":""},"","",null,null,"08E7","2006-07-01",24,"2001-07-01","8 Years","7 Skill Level","2007-12-31","1 Feb - 31 Mar 08","Aug 08 - Jul 09"]
[{"$nulls":4},{"$f":"TODAY()","v":"2008-11-21"},{"$nulls":7},{"$error":"#N/A"},null,{"$f":"IF(I26=\"\",\"\",40)","v":""},"","",null,null,"08E6","2006-08-01",23,"2004-07-01","5 Years","5 Skill Level","2007-12-31","1 Feb - 31 Mar 08","Aug 08 - Jul 09"]
[{"$nulls":4},{"$f":"IF(E10=staff,\"SrA\",IF(E10=tech,\"SSgt\",IF(E10=master,\"TSgt\",IF(E10=senior,\"MSgt\",IF(E10=chief,\"SMSgt\")))))","v":false},{"$nulls":3},{"$f":"E14-M14","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"$error":"#N/A"},null,{"$f":"IF(I27=\"\",\"\",35)","v":""},"","",null,null,"08E5","2008-02-01",6,"2006-08-01","3 Years","5 Skill Level","2008-03-31","1 May - 15 Jun 08","Sep 08 - Aug 09"]
[{"$nulls":12},{"$error":"#N/A"},null,{"$f":"IF(I28=\"\",\"\",30)","v":""},"",""]
[{"$nulls":12},{"$error":"#N/A"},null,{"$f":"IF(I29=\"\",\"\",25)","v":""},"",""]
[{"$nulls":12},{"$error":"#N/A"},null,{"$f":"IF(I30=\"\",\"\",20)","v":""},"",""]
[{"$nulls":4},1985,"Jan",1,{"$nulls":5},{"$error":"#N/A"},null,{"$f":"IF(I31=\"\",\"\",15)","v":""},"",""]
[{"$nulls":4},1986,"Feb",2,{"$nulls":5},{"$error":"#N/A"},null,{"$f":"IF(I32=\"\",\"\",10)","v":""},"",""]
[{"$nulls":4},1987,"Mar",3,{"$nulls":5},{"$error":"#N/A"},null,{"$f":"IF(I33=\"\",\"\",5)","v":""},"",""]
[{"$nulls":4},1988,"Apr",4,{"$nulls":5},{"$error":"#N/A"},null,{"$f":"SUM(O5007:O5016)","v":0},null,{"$f":"SUM(Q5007:Q5016)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},1989,"May",5,{"$nulls":5},{"$error":"#N/A"}]
[{"$nulls":4},1990,"Jun",6]
[{"$nulls":4},1991,"Jul",7]
[{"$nulls":4},1992,"Aug",8]
[{"$nulls":4},1993,"Sep",9]
[{"$nulls":4},1994,"Oct",10]
[{"$nulls":4},1995,"Nov",11]
[{"$nulls":4},1996,"Dec",12,{"$nulls":9},0.01,"Fill your name in only, you passed"]
[{"$nulls":4},1997,null,13,{"$nulls":9},25,"Just study the night before"]
[{"$nulls":4},1998,null,14,{"$nulls":9},40,"Flip a coin"]
[{"$nulls":4},1999,null,15,{"$nulls":9},70,"Hope you studied"]
[{"$nulls":4},2000,null,16,{"$nulls":9},85,"Good luck, you're going to need it"]
[{"$nulls":4},2001,null,17,{"$nulls":9},95,"Unless your Einstein….."]
[{"$nulls":4},2002,null,18,{"$nulls":9},100,"Nice try, see you next year"]
[{"$nulls":4},2003,null,19]
[{"$nulls":4},2004,null,20]
[{"$nulls":4},2005,null,21]
[{"$nulls":4},2006,null,22]
[{"$nulls":4},2007,null,23]
[{"$nulls":4},2008,null,24]
[{"$nulls":4},2009,null,25]
[{"$nulls":4},2010,null,26]
[{"$nulls":4},2011,null,27]
[{"$nulls":4},2012,null,28]
[{"$nulls":4},2013,null,29]
[{"$nulls":4},2014,null,30]
[{"$nulls":4},2015,null,31]
[{"$nulls":4},2016]
[{"$nulls":4},2017]
[{"$nulls":4},2018]
[{"$nulls":4},2019]
[{"$nulls":4},2020]

{"sheet":"E8 E9 WAPS CALC","index":2,"n_rows":5049,"n_cols":26,"rows_kept":5049,"merged":[[4,6,4,10],[5,3,5,12],[6,3,6,12],[7,3,7,12],[7,17,7,18],[9,4,9,6],[9,10,9,12],[9,17,9,18],[10,4,10,6],[10,10,10,11],[11,4,11,6],[11,10,11,11],[12,4,12,6],[12,10,12,11],[12,17,13,17],[12,18,13,18],[13,4,13,6],[13,10,13,11],[14,3,14,6],[14,10,14,11],[15,4,15,6],[15,10,15,12],[16,4,16,6],[16,10,16,11],[17,10,17,11],[18,6,20,6],[18,10,18,11],[18,19,19,19],[19,10,19,11],[20,10,20,11],[21,7,21,8],[21,10,21,11],[22,10,22,11],[22,17,22,18],[23,10,23,12],[24,10,24,11],[25,10,25,11],[26,10,26,11],[26,16,33,19],[27,10,27,11],[28,10,28,11],[29,10,29,11],[30,10,30,11],[31,10,31,11],[32,10,32,11],[33,7,34,7],[33,8,34,8],[33,10,33,11],[34,3,34,4],[34,10,34,11],[50,14,50,16],[61,4,61,5],[62,4,62,5],[63,4,63,5],[99,20,99,22],[99,23,99,25]]}
[]
[]
[]
[]
[]
[{"$nulls":3},{"$f":"IF(E12=\"\",\"\",\"You have been in the Air Force for \"&DATEDIF(E12,E5009,\"y\")&\" years, \"&DATEDIF(E12,E5009,\"ym\")&\" months, \"&DATEDIF(E12,E5009,\"md\")&\" days\"&\"\")","v":""}]
[{"$nulls":3},{"$f":"IF(E13=\"\",\"\",\"You have been a \"&E5010&\" for \"&DATEDIF(E13,E5009,\"y\")&\" years, \"&DATEDIF(E13,E5009,\"ym\")&\" months, \"&DATEDIF(E13,E5009,\"md\")&\" days\"&\"\")","v":""}]
[{"$nulls":17},"Compare yourslef to last years averages"]
[]
[{"$nulls":3},"Select rank your testing for","SMSgt",{"$nulls":5},"Board Score Estimator",{"$nulls":5},"# Tested",{"$f":"IF(AND($E$10=\"smsgt\",$E$11=2009),U102,IF(AND($E$10=\"cmsgt\",$E$11=2009),X102,\"\"))","v":14404}]
[{"$nulls":3},"What year will you test in?",2009,{"$nulls":5},"        Board Member #",null,"Select Score",{"$nulls":3},"Promoted",{"$f":"IF(AND($E$10=\"smsgt\",$E$11=2009),W102,IF(AND($E$10=\"cmsgt\",$E$11=2009),Z102,\"\"))","v":1284},{"$f":"R11/R10","v":{"v":0.08914190502638156,"d":"8.91%"}}]
[{"$nulls":3},"What is your TAFMS?",{"$nulls":6},1,null,null,{"v":10,"d":"10.00"},null,null,"Not Promoted",{"$f":"IF(AND($E$10=\"smsgt\",$E$11=2009),V102,IF(AND($E$10=\"cmsgt\",$E$11=2009),Y102,\"\"))","v":13120},{"$f":"R12/R10","v":{"v":0.9108580949736185,"d":"91.09%"}}]
[{"$nulls":3},"What is your TIG?",{"$nulls":6},2,null,null,10,{"$nulls":3},"You","2008 Selects"]
[{"$nulls":3},"What is your est. cutoff score?",{"$nulls":6},3,null,null,{"v":10,"d":"10.00"}]
[{"$nulls":3},"See 2008 Cut Off Scores",{"$nulls":6},"Composite:",null,{"$f":"SUM(M12*15)+(M13*15)+(M14*15)","v":{"v":0,"d":"0.0"}},{"$nulls":3},"Years TIG",{"$f":"DATEDIF(E13,T15,\"m\")/12","v":{"v":109.83333333333333,"d":"109.83"}},{"$f":"IF(AND($E$10=\"smsgt\",$E$11=2009),W104,IF(AND($E$10=\"cmsgt\",$E$11=2009),Z104,\"\"))","v":4.54},{"$f":"IF(AND($E$10=\"smsgt\",$E$11=2009),VLOOKUP($E$11,E8Cycle,13,FALSE),IF(AND($E$10=\"cmsgt\",$E$11=2009),VLOOKUP($E$11,E9Cycle,13,FALSE),\"\"))","v":"2009-11-01"}]
[{"$nulls":3},"Select AFSC","9S100",{"$nulls":11},"Years TIS",{"$f":"DATEDIF(E12,T16,\"m\")/12","v":{"v":109.83333333333333,"d":"109.83"}},{"$f":"IF(AND($E$10=\"smsgt\",$E$11=2009),W105,IF(AND($E$10=\"cmsgt\",$E$11=2009),Z105,\"\"))","v":20.47},{"$f":"IF(AND($E$10=\"smsgt\",$E$11=2009),VLOOKUP($E$11,E8Cycle,13,FALSE),IF(AND($E$10=\"cmsgt\",$E$11=2009),VLOOKUP($E$11,E9Cycle,13,FALSE),\"\"))","v":"2009-11-01"}]
[{"$nulls":3},"2008 AFSC Cutoff Scores",{"$f":"IF(E10=senior,VLOOKUP(E16,smsgt,5,FALSE),IF(E10=chief,VLOOKUP(E16,cmsgt,5,FALSE),\"\"))","v":646.78},{"$nulls":5},"TIS Points",null,{"$f":"IF(H63>25,25,H63)","v":25},{"$nulls":3},"TIG Points",{"$f":"M18","v":60},{"$f":"IF(AND($E$10=\"smsgt\",$E$11=2009),W107,IF(AND($E$10=\"cmsgt\",$E$11=2009),Z107,\"\"))","v":33.17}]
[{"$nulls":10},"TIG Points",null,{"$f":"IF(H64>60,60,H64)","v":60},{"$nulls":3},"TIS Points",{"$f":"M17","v":25},{"$f":"IF(AND($E$10=\"smsgt\",$E$11=2009),W108,IF(AND($E$10=\"cmsgt\",$E$11=2009),Z108,\"\"))","v":21.43}]
[{"$nulls":10},"EPR Points",null,{"$f":"I34","v":""},{"$nulls":3},"EPR",{"$f":"I34","v":""},{"$f":"IF(AND($E$10=\"smsgt\",$E$11=2009),W109,IF(AND($E$10=\"cmsgt\",$E$11=2009),Z109,\"\"))","v":134.99}]
[{"$nulls":10},"Medals Points",null,{"$f":"F35","v":0},{"$nulls":3},"Decorations",{"$f":"F35","v":0},{"$f":"IF(AND($E$10=\"smsgt\",$E$11=2009),W110,IF(AND($E$10=\"cmsgt\",$E$11=2009),Z110,\"\"))","v":21.23}]
[{"$nulls":10},"Board Score",null,{"$f":"M15","v":{"v":0,"d":"0.0"}},{"$nulls":3},"PDG",{"$f":"E14-M22","v":-85},{"$f":"IF(AND($E$10=\"smsgt\",$E$11=2009),W112,IF(AND($E$10=\"cmsgt\",$E$11=2009),Z112,\"\"))","v":68.99}]
[{"$nulls":4},"#","Pts",null,"EPR's",null,null,"Total Points Scored",null,{"$f":"SUM(M17:M21)","v":85},{"$nulls":3},"Board Score",{"$f":"M15","v":0},{"$f":"IF(AND($E$10=\"smsgt\",$E$11=2009),W114,IF(AND($E$10=\"cmsgt\",$E$11=2009),Z114,\"\"))","v":392.86}]
[{"$nulls":5},{"$f":"IF(ISNA(_med13),\"\",_med13)","v":""},null,"Newest","Rating",null,"Need to score on AFSE",null,{"$f":"(E14-M22)/100","v":{"v":-0.85,"d":"-85%"}},{"$nulls":3},"Enter Bday",null,null,{"$f":"IF(AND($E$10=\"smsgt\",$E$11=2009),VLOOKUP($E$11,E8Cycle,13,FALSE),IF(AND($E$10=\"cmsgt\",$E$11=2009),VLOOKUP($E$11,E9Cycle,13,FALSE),\"\"))","v":"2009-11-01"}]
[{"$nulls":5},{"$f":"IF(ISNA(_med14),\"\",_med14)","v":""},null,1,null,null,"Testing Eligibility",{"$nulls":5},"Age",{"$f":"DATEDIF(R23,T23,\"m\")/12","v":{"v":109.83333333333333,"d":"109.83"}},{"$f":"IF(AND($E$10=\"smsgt\",$E$11=2009),W106,IF(AND($E$10=\"cmsgt\",$E$11=2009),Z106,\"\"))","v":40.45}]
[{"$nulls":5},{"$f":"IF(ISNA(_med15),\"\",_med15)","v":""},null,2,null,null,"Cycle",null,{"$f":"IF($E$10=\"sMSgt\",VLOOKUP($E$11,E8Cycle,2,FALSE),IF($E$10=\"cmsgt\",VLOOKUP($E$11,E9Cycle,2,FALSE),\"\"))","v":"09E8"},{"$nulls":3},"Total Average",{"$f":"M17+M18+M19+M20+M21","v":{"$error":"#VALUE!"}},{"$f":"IF(AND($E$10=\"smsgt\",$E$11=2009),W113,IF(AND($E$10=\"cmsgt\",$E$11=2009),Z113,\"\"))","v":672.67}]
[{"$nulls":5},{"$f":"IF(ISNA(_med16),\"\",_med16)","v":""},null,3,null,null,"DOR",null,{"$f":"IF($E$10=\"sMSgt\",VLOOKUP($E$11,E8Cycle,3,FALSE),IF($E$10=\"cmsgt\",VLOOKUP($E$11,E9Cycle,3,FALSE),\"\"))","v":"2007-07-01"}]
[{"$nulls":5},{"$f":"IF(ISNA(_med17),\"\",_med17)","v":""},null,4,null,null,"TIG Required",null,{"$f":"IF($E$10=\"sMSgt\",VLOOKUP($E$11,E8Cycle,4,FALSE),IF($E$10=\"cmsgt\",VLOOKUP($E$11,E9Cycle,4,FALSE),\"\"))","v":"20 Months"},{"$nulls":3},{"$f":"\"All dates are calculated based on the first day of the \"&M25&\" test cycle.\"","v":"All dates are calculated based on the first day of the 09E8 test cycle."}]
[{"$nulls":5},{"$f":"IF(ISNA(_med18),\"\",_med18)","v":""},null,5,null,null,"TAFMSD",null,{"$f":"IF($E$10=\"sMSgt\",VLOOKUP($E$11,E8Cycle,5,FALSE),IF($E$10=\"cmsgt\",VLOOKUP($E$11,E9Cycle,5,FALSE),\"\"))","v":"1999-03-01"}]
[{"$nulls":5},{"$f":"IF(ISNA(_med19),\"\",_med19)","v":""},null,6,null,null,"TIS Required",null,{"$f":"IF($E$10=\"sMSgt\",VLOOKUP($E$11,E8Cycle,6,FALSE),IF($E$10=\"cmsgt\",VLOOKUP($E$11,E9Cycle,6,FALSE),\"\"))","v":"11 Years"}]
[{"$nulls":5},{"$f":"IF(ISNA(_med20),\"\",_med20)","v":""},null,7,null,null,"PAFSC Skill Level",null,{"$f":"IF($E$10=\"sMSgt\",VLOOKUP($E$11,E8Cycle,7,FALSE),IF($E$10=\"cmsgt\",VLOOKUP($E$11,E9Cycle,7,FALSE),\"\"))","v":"7 Skill Level"}]
[{"$nulls":5},{"$f":"IF(ISNA(_med21),\"\",_med21)","v":""},null,8,null,null,"Prom. Eligible Cutoff Date",null,{"$f":"IF($E$10=\"sMSgt\",VLOOKUP($E$11,E8Cycle,8,FALSE),IF($E$10=\"cmsgt\",VLOOKUP($E$11,E9Cycle,8,FALSE),\"\"))","v":"2008-09-30"}]
[{"$nulls":5},{"$f":"IF(ISNA(_med22),\"\",_med22)","v":""},null,9,null,null,"Testing Cycle",null,{"$f":"IF($E$10=\"sMSgt\",VLOOKUP($E$11,E8Cycle,9,FALSE),IF($E$10=\"cmsgt\",VLOOKUP($E$11,E9Cycle,9,FALSE),\"\"))","v":"1 Dec - 31 Dec 08"}]
[{"$nulls":5},{"$f":"IF(ISNA(_med23),\"\",_med23)","v":""},null,10,null,null,"Promotion Months",null,{"$f":"IF($E$10=\"sMSgt\",VLOOKUP($E$11,E8Cycle,10,FALSE),IF($E$10=\"cmsgt\",VLOOKUP($E$11,E9Cycle,10,FALSE),\"\"))","v":"Apr 09 - Mar 10"}]
[{"$nulls":5},{"$f":"IF(ISNA(_med24),\"\",_med24)","v":""},null,"Oldest",{"$f":"IF(ISERROR(Q62/O62),\"\",Q62/O62)","v":""},null,"EPR's Considered",null,{"$f":"IF($E$10=\"sMSgt\",VLOOKUP($E$11,E8Cycle,12,FALSE),IF($E$10=\"cmsgt\",VLOOKUP($E$11,E9Cycle,12,FALSE),\"\"))","v":"Oct 04 - Sep 09"}]
[{"$nulls":3},"Total Points (not to exceed 25)",null,{"$f":"IF(SUM(F23:F34)>25,25,SUM(F23:F34))","v":0},{"$nulls":4},"Selections Announced",null,{"$f":"IF($E$10=\"sMSgt\",VLOOKUP($E$11,E8Cycle,11,FALSE),IF($E$10=\"cmsgt\",VLOOKUP($E$11,E9Cycle,11,FALSE),\"\"))","v":"2009-03-01"}]
{"$rows_empty":15}
[{"$nulls":8},1,{"$nulls":3},"Medals Data",null,"EPR Data"]
[{"$nulls":8},2,6,270,null,{"$f":"IF(E23=\"\",VLOOKUP(D23,medals,2,FALSE),VLOOKUP(D23,medals,2,FALSE)*E23)","v":{"$error":"#N/A"}},null,{"$f":"IF(I24=\"\",\"\",50)","v":""},{"$f":"IF(I24=\"\",\"\",I24*O52)","v":""},{"$f":"IF(I24=\"\",\"\",P52*27)","v":""}]
[{"$nulls":8},3,6.5,277.5,null,{"$error":"#N/A"},null,{"$f":"IF(I25=\"\",\"\",45)","v":""},{"$f":"IF(I25=\"\",\"\",I25*O53)","v":""},{"$f":"IF(I25=\"\",\"\",P53*27)","v":""}]
[{"$nulls":8},4,7,285,null,{"$error":"#N/A"},null,{"$f":"IF(I26=\"\",\"\",40)","v":""},"",""]
[{"$nulls":8},5,7.5,292.5,null,{"$error":"#N/A"},null,{"$f":"IF(I27=\"\",\"\",35)","v":""},"",""]
[{"$nulls":8},6,8,300,null,{"$error":"#N/A"},null,{"$f":"IF(I28=\"\",\"\",30)","v":""},"",""]
[{"$nulls":8},7,8.5,307.5,null,{"$error":"#N/A"},null,{"$f":"IF(I29=\"\",\"\",25)","v":""},"",""]
[{"$nulls":8},8,9,315,null,{"$error":"#N/A"},null,{"$f":"IF(I30=\"\",\"\",20)","v":""},"",""]
[{"$nulls":8},9,9.5,322.5,null,{"$error":"#N/A"},null,{"$f":"IF(I31=\"\",\"\",15)","v":""},"",""]
[{"$nulls":8},10,10,330,null,{"$error":"#N/A"},null,{"$f":"IF(I32=\"\",\"\",10)","v":""},"",""]
[{"$nulls":10},337.5,null,{"$error":"#N/A"},null,{"$f":"IF(I33=\"\",\"\",5)","v":""},"",""]
[{"$nulls":10},345,null,{"$error":"#N/A"},null,{"$f":"SUM(O52:O61)","v":0},null,{"$f":"SUM(Q52:Q61)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"TAFMS",{"$f":"IF(E10=senior,VLOOKUP(E11,smsgt6,3,FALSE),IF(E10=chief,VLOOKUP(E11,cmsgt6,3,FALSE)))","v":"2010-03-31"},null,{"$f":"DATEDIF(E12,E63,\"m\")","v":1322},{"$f":"G63*0.0833333","v":{"v":110.1666226,"d":"110.17"}},null,null,352.5,null,{"$error":"#N/A"}]
[{"$nulls":3},"TIG",{"$f":"IF(E10=senior,VLOOKUP(E11,smsgt6,2,FALSE),IF(E10=chief,VLOOKUP(E11,cmsgt6,2,FALSE)))","v":"2010-03-01"},null,{"$f":"DATEDIF(E13,E64,\"m\")","v":1322},{"$f":"G64*0.5","v":{"v":661,"d":"661.00"}},null,null,360]
[{"$nulls":10},367.5]
[{"$nulls":10},375]
[{"$nulls":10},382.5]
[{"$nulls":10},390]
[{"$nulls":10},397.5]
[{"$nulls":10},405]
[{"$nulls":10},412.5]
[{"$nulls":10},420]
[{"$nulls":10},427.5]
[{"$nulls":10},435]
[{"$nulls":10},442.5]
[{"$nulls":10},450]
{"$rows_empty":23}
[{"$nulls":20},"E8",null,null,"E9"]
[{"$nulls":20},"Eligibles","NonSelects","Selects","Eligibles","NonSelects","Selects"]
[{"$nulls":19},"Nbr",{"v":14404,"d":"14,404"},13120,1284,2415,1895,520]
[{"$nulls":19},"Pct",null,91.09,8.91,null,78.47,21.53]
[{"$nulls":19},"YRS TIG",3.52,3.42,4.54,3.14,3.05,3.47]
[{"$nulls":19},"YRS TIS",20.57,20.57,20.47,23.56,23.7,23.06]
[{"$nulls":19},"AGE",40.82,40.85,40.45,43.73,43.9,43.07]
[{"$nulls":19},"TIG POINT",27.08,26.49,33.17,25.34,24.8,27.31]
[{"$nulls":19},"TIS POINT",21.53,21.54,21.43,23.88,23.96,23.57]
[{"$nulls":19},"EPR",134.67,134.64,134.99,134.96,134.95,135]
[{"$nulls":19},"DEC",17.38,{"v":17,"d":"17.00"},21.23,23.79,23.64,24.34]
[{"$nulls":19},"SKT"]
[{"$nulls":19},"PFE",50.65,48.85,68.99,52.8,48.61,68.09]
[{"$nulls":19},"Total",583.06,574.29,672.67,609.96,595.7,661.9]
[{"$nulls":19},"Board",331.76,325.78,392.86,349.19,339.74,383.6]
{"$rows_empty":4891}
[{"$nulls":7},"days","points"]
[{"$nulls":3},"TAFMS",{"$f":"IF(E10=staff,VLOOKUP(E11,ssgt5,3,FALSE),IF(E10=tech,VLOOKUP(E11,tsgt6,3,FALSE),IF(E10=master,VLOOKUP(E11,tsgt6,3,FALSE))))","v":false},null,null,{"$f":"DATEDIF(E12,E5007,\"d\")","v":0},{"$f":"H5007*0.00547945205479452","v":0}]
[{"$nulls":3},"TIG",{"$f":"IF(E10=staff,VLOOKUP(E11,ssgt5,2,FALSE),IF(E10=tech,VLOOKUP(E11,tsgt6,2,FALSE),IF(E10=master,VLOOKUP(E11,tsgt6,2,FALSE))))","v":false},null,null,{"$f":"DATEDIF(E13,E5008,\"d\")","v":0},{"$f":"H5008*0.0164383561643835","v":0}]
[{"$nulls":4},{"$f":"TODAY()","v":"2008-11-21"}]
[{"$nulls":4},{"$f":"IF(E10=staff,\"SrA\",IF(E10=tech,\"SSgt\",IF(E10=master,\"TSgt\",IF(E10=senior,\"MSgt\",IF(E10=chief,\"SMSgt\")))))","v":"MSgt"},{"$nulls":3},{"$f":"E14-M21","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
[{"$nulls":4},1985,"Jan",1]
[{"$nulls":4},1986,"Feb",2]
[{"$nulls":4},1987,"Mar",3]
[{"$nulls":4},1988,"Apr",4]
[{"$nulls":4},1989,"May",5]
[{"$nulls":4},1990,"Jun",6]
[{"$nulls":4},1991,"Jul",7]
[{"$nulls":4},1992,"Aug",8]
[{"$nulls":4},1993,"Sep",9]
[{"$nulls":4},1994,"Oct",10]
[{"$nulls":4},1995,"Nov",11]
[{"$nulls":4},1996,"Dec",12]
[{"$nulls":4},1997,null,13]
[{"$nulls":4},1998,null,14]
[{"$nulls":4},1999,null,15]
[{"$nulls":4},2000,null,16]
[{"$nulls":4},2001,null,17]
[{"$nulls":4},2002,null,18]
[{"$nulls":4},2003,null,19]
[{"$nulls":4},2004,null,20]
[{"$nulls":4},2005,null,21]
[{"$nulls":4},2006,null,22]
[{"$nulls":4},2007,null,23]
[{"$nulls":4},2008,null,24]
[{"$nulls":4},2009,null,25]
[{"$nulls":4},2010,null,26]
[{"$nulls":4},2011,null,27]
[{"$nulls":4},2012,null,28]
[{"$nulls":4},2013,null,29]
[{"$nulls":4},2014,null,30]
[{"$nulls":4},2015,null,31]
[{"$nulls":4},2016]
[{"$nulls":4},2017]
[{"$nulls":4},2018]
[{"$nulls":4},2019]
[{"$nulls":4},2020]

{"sheet":"Medals","index":3,"n_rows":110,"n_cols":8,"rows_kept":110,"merged":[[1,1,2,4],[3,1,3,4],[5,3,5,4],[14,10,15,12]]}
[]
[null,"Check mark each medal you have and your total points will display below.  For additional devices, select how many you have from the drop down boxes.  Click each ribbon/medal to view more information about eligibility and descriptions."]
[]
[]
[{"$nulls":4},{"$f":"\"You have \"&SUM(G9:G28) &\" medal points\"","v":"You have 0 medal points"}]
[{"$nulls":3},{"$f":"IF(H100>25,\"You have maxed out your WAPS medal points\",\"\")","v":""}]
[{"$nulls":3},"Devices","Name of Medal/Ribbon"]
[]
[{"$nulls":4},{"$f":"IF(F9=TRUE,\"You Wish!\",\"Air Force Medal of Honor\")","v":"Air Force Medal of Honor"},false,{"$f":"IF(ISERROR(IF(F9=TRUE,15,\"\")*H9),\"\",IF(F9=TRUE,15,\"\")*H9)","v":""},1]
[{"$nulls":4},"Air Force Cross",false,{"$f":"IF(ISERROR(IF(F10=TRUE,11,\"\")*H10),\"\",IF(F10=TRUE,11,\"\")*H10)","v":""},1]
[{"$nulls":4},"Defense Distinguished Service Medal",false,{"$f":"IF(ISERROR(IF(F11=TRUE,9,\"\")*H11),\"\",IF(F11=TRUE,9,\"\")*H11)","v":""},1]
[{"$nulls":4},"Air Force Distinguished Service Medal",false,{"$f":"IF(ISERROR(IF(F12=TRUE,9,\"\")*H12),\"\",IF(F12=TRUE,9,\"\")*H12)","v":""},1]
[{"$nulls":4},"Silver Star",false,{"$f":"IF(ISERROR(IF(F13=TRUE,9,\"\")*H13),\"\",IF(F13=TRUE,9,\"\")*H13)","v":""},1]
[{"$nulls":4},"Defense Superior Service Medal",false,{"$f":"IF(ISERROR(IF(F14=TRUE,7,\"\")*H14),\"\",IF(F14=TRUE,7,\"\")*H14)","v":""},1]
[{"$nulls":4},"Legion of Merit",false,{"$f":"IF(ISERROR(IF(F15=TRUE,7,\"\")*H15),\"\",IF(F15=TRUE,7,\"\")*H15)","v":""},1]
[{"$nulls":4},"Distinguished Flying Cross",false,{"$f":"IF(ISERROR(IF(F16=TRUE,7,\"\")*H16),\"\",IF(F16=TRUE,7,\"\")*H16)","v":""},1]
[{"$nulls":4},"Airman's Medal",false,{"$f":"IF(ISERROR(IF(F17=TRUE,5,\"\")*H17),\"\",IF(F17=TRUE,5,\"\")*H17)","v":""},1]
[{"$nulls":4},"Bronze Star",false,{"$f":"IF(ISERROR(IF(F18=TRUE,5,\"\")*H18),\"\",IF(F18=TRUE,5,\"\")*H18)","v":""},1]
[{"$nulls":4},"Purple Heart",false,{"$f":"IF(ISERROR(IF(F19=TRUE,5,\"\")*H19),\"\",IF(F19=TRUE,5,\"\")*H19)","v":""},1]
[{"$nulls":4},"Defense Meritorious Service Medal",false,{"$f":"IF(ISERROR(IF(F20=TRUE,5,\"\")*H20),\"\",IF(F20=TRUE,5,\"\")*H20)","v":""},1]
[{"$nulls":4},"Meritiorious Service Medal",false,{"$f":"IF(ISERROR(IF(F21=TRUE,5,\"\")*H21),\"\",IF(F21=TRUE,5,\"\")*H21)","v":""},1]
[{"$nulls":4},"Air Medal",false,{"$f":"IF(ISERROR(IF(F22=TRUE,3,\"\")*H22),\"\",IF(F22=TRUE,3,\"\")*H22)","v":""},1]
[{"$nulls":4},"Aerial Achievement Medal",false,{"$f":"IF(ISERROR(IF(F23=TRUE,3,\"\")*H23),\"\",IF(F23=TRUE,3,\"\")*H23)","v":""},1]
[{"$nulls":4},"Joint Service Commendation Medal",false,{"$f":"IF(ISERROR(IF(F24=TRUE,3,\"\")*H24),\"\",IF(F24=TRUE,3,\"\")*H24)","v":""},1]
[{"$nulls":4},"Air Force Commendation Medal",false,{"$f":"IF(ISERROR(IF(F25=TRUE,3,\"\")*H25),\"\",IF(F25=TRUE,3,\"\")*H25)","v":""},1]
[{"$nulls":4},"Army Commendation Medal",false,{"$f":"IF(ISERROR(IF(F26=TRUE,3,\"\")*H26),\"\",IF(F26=TRUE,3,\"\")*H26)","v":""},1]
[{"$nulls":4},"Joint Service Achievement Medal",false,{"$f":"IF(ISERROR(IF(F27=TRUE,1,\"\")*H27),\"\",IF(F27=TRUE,1,\"\")*H27)","v":""},1]
[{"$nulls":4},"Air Force Achievement Medal",false,{"$f":"IF(ISERROR(IF(F28=TRUE,1,\"\")*H28),\"\",IF(F28=TRUE,1,\"\")*H28)","v":""},1]
[{"$nulls":4},"Air Force Combat Action Medal",null,null,1]
[{"$nulls":4},"Air Force Presidential Unit Citation",null,null,1]
[{"$nulls":4},"Gallant Unit Citation",null,null,1]
[{"$nulls":4},"Joint Meritorious Unit Award",null,null,1]
[{"$nulls":4},"Air Force Meritorious Unit Award",null,null,1]
[{"$nulls":4},"Outstanding Unit Award",null,null,1]
[{"$nulls":4},"Organizational Excellence Award",null,null,1]
[{"$nulls":4},"Prisoner of War Medal",null,null,1]
[{"$nulls":4},"Combat Readiness Medal",null,null,1]
[{"$nulls":4},"Air Force Good Conduct Medal",false,null,1]
[{"$nulls":4},"Army Good Conduct Medal",false,null,1]
[{"$nulls":4},"Air Reserve Meritorious Service Medal",null,null,1]
[{"$nulls":4},"Outstanding Airman of The Year",null,null,1]
[{"$nulls":4},"Air Force Recognition Ribbon",null,null,1]
[{"$nulls":4},"American Defense Medal",null,null,1]
[{"$nulls":4},"Women's Army CORPS Service Medal",null,null,1]
[{"$nulls":4},"American Campaign Medal",null,null,1]
[{"$nulls":4},"European/African/Middle Eastern Campaign Medal",null,null,1]
[{"$nulls":4},"Asiatic/Pacific Campaign Medal",false,null,1]
[{"$nulls":4},"WWII Victory Medal",null,null,1]
[{"$nulls":4},"Army and Air Force World War II Occupation Medal",null,null,1]
[{"$nulls":4},"Medal for Humane Action",null,null,1]
[{"$nulls":4},"National Defense Service Medal",null,null,1]
[{"$nulls":4},"Korea Service Medal",null,null,1]
[{"$nulls":4},"Antarctica Service Medal",null,null,1]
[{"$nulls":4},"Armed Forces Expeditionary Medal",null,null,1]
[{"$nulls":4},"Vietnam Service Medal",null,null,1]
[{"$nulls":4},"Southwest Asia Service Medal",null,null,1]
[{"$nulls":4},"Kosovo Campaign",null,null,1]
[{"$nulls":4},"Afghanistan Campaign Medal",false,null,1]
[{"$nulls":4},"Iraq Campaign Medal",null,null,1]
[{"$nulls":4},"Global War on Terrorism (Expeditionary)",null,null,1]
[{"$nulls":4},"Global War on Terrorism (Service)",null,null,1]
[{"$nulls":4},"Korea Defense Service Medal",null,null,1]
[{"$nulls":4},"Armed Forces Service Medal",null,null,1]
[{"$nulls":4},"Humanitarian Service Medal",null,null,1]
[{"$nulls":4},"Outstanding Volunteer Service Medal",false,null,1]
[{"$nulls":4},"Air and Space Campaign",null,null,1]
[{"$nulls":4},"Air Force Overseas Short Tour",false,null,1]
[{"$nulls":4},"Air Force Overseas Long Tour",false,null,1]
[{"$nulls":4},"Air Force Expeditionary Service Ribbon",false,null,1]
[{"$nulls":4},"Air Force Expeditionary Service Ribbon",null,null,1]
[{"$nulls":4},"Longevity Service Award",null,null,1]
[{"$nulls":4},"Military Training Instructor Ribbon",null,null,1]
[{"$nulls":4},"Air Force Recruiting Ribbon",null,null,1]
[{"$nulls":4},"Armed Forces Reserve Medal",null,null,1]
[{"$nulls":4},"NCO Professional Military Education Graduate",null,null,1]
[{"$nulls":4},"Basic Military Training Honor Graduate Ribbon",null,null,1]
[{"$nulls":4},"Small Arms Expert Marksmanship Ribbon",null,null,1]
[{"$nulls":4},"Air Force Training Ribbon",null,null,1]
[{"$nulls":4},"Philippine Defense Medal",null,null,1]
[{"$nulls":4},"Philippine Liberation Medal",null,null,1]
[{"$nulls":4},"Philippine Independence Medal",null,null,1]
[{"$nulls":4},"Philippine Presidential Unit Citation",null,null,1]
[{"$nulls":4},"Korean Presidential Unit Citation",false,null,1]
[{"$nulls":4},"Vietnam Gallantry Cross",null,null,1]
[{"$nulls":4},"Vietnam Presidential Unit Citation",null,null,1]
[{"$nulls":4},"Vietnam Wound Medal",false,null,1]
[{"$nulls":4},"RVN Armed Forces Honor Medal",null,null,1]
[{"$nulls":4},"Vietnam Gallantry Cross Unit Citation",null,null,1]
[{"$nulls":4},"Vietnam Civil Actions Unit Citation",null,null,1]
[{"$nulls":4},"United Nations Service Medal",null,null,1]
[{"$nulls":4},"United Nations Medal",null,null,1]
[{"$nulls":4},"NATO Medal",null,null,1]
[{"$nulls":4},"NATO Kosovo Medal",false,null,1]
[{"$nulls":4},"Republic of Vietnam Campaign Medal",null,null,1]
[{"$nulls":4},"Multinational Force & Observers Medal",null,null,1]
[{"$nulls":4},"Inter-American Defense Board Medal",null,null,1]
[{"$nulls":4},"Kuwait Liberation Medal (Saudi Arabia)",null,null,1]
[{"$nulls":4},"Kuwait Liberation Medal (Emirate of Kuwait)",false,null,1]
[{"$nulls":4},"Republic of Korea War Service Medal",false,null,1]
[{"$nulls":6},0,{"$f":"SUM(G9:G28)","v":0}]
[{"$nulls":6},1]
[{"$nulls":6},2]
[{"$nulls":6},3]
[{"$nulls":6},4]
[{"$nulls":6},5]
[{"$nulls":6},6]
[{"$nulls":6},7]
[{"$nulls":6},8]
[{"$nulls":6},9]
[{"$nulls":6},10]

{"sheet":"SSgt Cutoff","index":4,"n_rows":149,"n_cols":5,"rows_kept":149,"merged":[[0,0,0,4]]}
[]
["PROM","NBR","NBR2","PROM3","PROM4"]
["AFSC","ELIG","SEL","OPP","CUTOFF"]
["00XXX",318,138,{"v":43.4,"d":"43.40"},268.74]
["00XXXX",56,29,51.79,271.79]
["1A0X1",93,40,43.01,284.01]
["1A1X1",22,10,45.45,274.69]
["1A2X1",228,116,50.88,268.47]
["1A3X1",192,83,43.23,263.14]
["1A4X1",103,53,51.46,259.19]
["1A6X1",1,1,{"v":100,"d":"100.00"},286.86]
["1A7X1",27,14,51.85,272.75]
["1A8X1",220,113,51.36,251.06]
["1C0X2",140,61,43.57,{"v":269.2,"d":"269.20"}]
["1C1X1",399,200,50.13,258.73]
["1C2X1",37,19,51.35,263.56]
["1C3X1",153,78,50.98,265.63]
["1C4X1",116,59,50.86,262.33]
["1C5X1",188,82,43.62,{"v":264.5,"d":"264.50"}]
["1C6X1",73,32,43.84,257.37]
["1C7X1",61,26,42.62,249.17]
["1N0X1",368,183,49.73,258.81]
["1N1X1",243,123,50.62,261.56]
["1N2X1",164,72,{"v":43.9,"d":"43.90"},263.99]
["1N3X0",399,201,50.38,270.77]
["1N4X1",297,150,50.51,258.69]
["1N5X1",166,84,{"v":50.6,"d":"50.60"},256.15]
["1N6X1",75,33,{"v":44,"d":"44.00"},266.86]
["1P0X1",266,101,37.97,260.66]
["1S0X1",3,1,33.33,280.71]
["1T0X1",62,27,43.55,261.46]
["1T2X1",28,14,{"v":50,"d":"50.00"},265.67]
["1W0X1",295,128,43.39,263.91]
["2A0X1A",86,37,43.02,262.71]
["2A0X1B",63,27,42.86,{"v":261.4,"d":"261.40"}]
["2A0X1C",59,26,44.07,267.26]
["2A0X1D",49,21,42.86,263.65]
["2A3X1",217,96,44.24,260.56]
["2A3X2",327,142,43.43,248.68]
["2A3X3",1126,489,43.43,{"v":235.7,"d":"235.70"}]
["2A5X1J",587,255,43.44,{"v":256.8,"d":"256.80"}]
["2A5X1K",152,66,43.42,253.36]
["2A5X1L",268,116,43.28,{"v":256.6,"d":"256.60"}]
["2A5X2",59,26,44.07,{"v":267.3,"d":"267.30"}]
["2A5X3A",300,130,43.33,{"v":260.3,"d":"260.30"}]
["2A5X3B",187,81,43.32,261.54]
["2A5X3C",119,52,{"v":43.7,"d":"43.70"},270.03]
["2A5X3D",20,9,{"v":45,"d":"45.00"},269.53]
["2A6X1A",538,234,43.49,247.32]
["2A6X1B",126,55,43.65,{"v":253.1,"d":"253.10"}]
["2A6X2",386,168,43.52,252.96]
["2A6X3",115,50,43.48,255.64]
["2A6X4",234,102,43.59,263.71]
["2A6X5",245,106,43.27,246.01]
["2A6X6",470,204,{"v":43.4,"d":"43.40"},256.48]
["2A7X1",102,44,43.14,242.85]
["2A7X2",138,60,43.48,253.37]
["2A7X3",522,227,43.49,{"v":248.9,"d":"248.90"}]
["2E0X1",78,34,43.59,258.69]
["2E1X1",288,125,{"v":43.4,"d":"43.40"},{"v":257.3,"d":"257.30"}]
["2E1X2",171,74,43.27,253.56]
["2E1X3",278,121,43.53,255.18]
["2E1X4",58,25,{"v":43.1,"d":"43.10"},{"v":257.7,"d":"257.70"}]
["2E2X1",387,192,49.61,251.79]
["2E6X2",35,15,42.86,257.02]
["2E6X3",163,71,43.56,242.22]
["2F0X1",440,166,37.73,260.61]
["2G0X1",66,29,43.94,261.07]
["2M0X1",153,66,43.14,253.42]
["2M0X2",76,33,43.42,255.49]
["2M0X3",56,24,42.86,{"v":247.3,"d":"247.30"}]
["2P0X1",92,40,43.48,261.95]
["2R0X1",56,21,{"v":37.5,"d":"37.50"},262.83]
["2R1X1",93,40,43.01,261.05]
["2S0X1",620,234,37.74,250.28]
["2T0X1",153,56,{"v":36.6,"d":"36.60"},251.49]
["2T1X1",273,119,43.59,262.75]
["2T2X1",603,298,49.42,253.38]
["2T3X1",184,68,36.96,257.12]
["2T3X2A",38,14,36.84,{"v":247.6,"d":"247.60"}]
["2T3X2C",59,26,44.07,251.91]
["2T3X5",28,11,39.29,256.43]
["2T3X7",25,13,{"v":52,"d":"52.00"},250.15]
["2W0X1",909,395,43.45,257.37]
["2W1X1",902,342,37.92,258.19]
["2W2X1",93,34,36.56,253.35]
["3A0X1",498,216,43.37,{"v":254.3,"d":"254.30"}]
["3C0X1",513,193,37.62,270.88]
["3C0X2",123,45,36.59,269.53]
["3C1X1",37,14,37.84,254.55]
["3C1X2",3,1,33.33,267.44]
["3C2X1",209,91,43.54,255.41]
["3C3X1",42,18,42.86,263.18]
["3E0X1",162,59,36.42,253.89]
["3E0X2",170,74,43.53,{"v":258.5,"d":"258.50"}]
["3E1X1",169,62,36.69,252.47]
["3E2X1",106,46,{"v":43.4,"d":"43.40"},{"v":255.7,"d":"255.70"}]
["3E3X1",120,52,43.33,255.55]
["3E4X1",136,49,36.03,264.33]
["3E4X2",42,18,42.86,256.13]
["3E4X3",18,8,44.44,246.36]
["3E5X1",114,50,43.86,262.64]
["3E6X1",30,13,43.33,271.76]
["3E7X1",437,165,37.76,254.38]
["3E8X1",133,58,43.61,270.28]
["3E9X1",152,78,51.32,258.74]
["3M0X1",361,157,43.49,252.84]
["3N0X1",25,11,{"v":44,"d":"44.00"},273.26]
["3N0X2",63,27,42.86,273.42]
["3N0X3",20,9,{"v":45,"d":"45.00"},257.36]
["3N0X4",66,29,43.94,266.34]
["3N1X1",54,20,37.04,{"v":298.1,"d":"298.10"}]
["3P0X1",3138,1363,43.44,246.64]
["3S0X1",384,167,43.49,{"v":270.5,"d":"270.50"}]
["3S2X1",3,1,33.33,280.45]
["4A0X1",389,169,43.44,255.58]
["4A1X1",170,86,50.59,242.84]
["4A2X1",70,26,37.14,256.82]
["4B0X1",103,38,36.89,259.54]
["4C0X1",59,30,50.85,265.06]
["4D0X1",40,20,{"v":50,"d":"50.00"},244.27]
["4E0X1",92,40,43.48,264.47]
["4H0X1",54,28,51.85,249.06]
["4J0X2",26,11,42.31,262.32]
["4M0X1",41,15,36.59,266.53]
["4N0X1",576,250,{"v":43.4,"d":"43.40"},266.68]
["4N1X1",53,23,{"v":43.4,"d":"43.40"},261.35]
["4P0X1",88,32,36.36,252.26]
["4R0X1",77,28,36.36,271.23]
["4R0X1B",4,2,{"v":50,"d":"50.00"},272.54]
["4R0X1C",2,1,{"v":50,"d":"50.00"},280.62]
["4T0X1",140,61,43.57,266.24]
["4T0X2",11,5,45.45,{"v":261.1,"d":"261.10"}]
["4V0X1",28,12,42.86,265.86]
["4Y0X1",250,94,{"v":37.6,"d":"37.60"},267.38]
["4Y0X2",45,20,44.44,272.91]
["5J0X1",34,15,44.12,262.06]
["5R0X1",45,17,37.78,268.81]
["6C0X1",94,48,51.06,256.15]
["6F0X1",295,128,43.39,268.77]
["7S0X1",6,3,{"v":50,"d":"50.00"},287.95]
["8A200",1,1,{"v":100,"d":"100.00"},262.08]
["8B000",2,1,{"v":50,"d":"50.00"},299.48]
["8G000",58,25,{"v":43.1,"d":"43.10"},{"v":259.2,"d":"259.20"}]
["8M000",128,48,{"v":37.5,"d":"37.50"},{"v":268.1,"d":"268.10"}]
["8R000",63,27,42.86,286.22]
["9D000",5,2,{"v":40,"d":"40.00"},278.44]
["9L000",2,1,{"v":50,"d":"50.00"},320.04]
["9S100",54,28,51.85,{"v":271.7,"d":"271.70"}]

{"sheet":"TSgt Cutoff","index":5,"n_rows":164,"n_cols":5,"rows_kept":164,"merged":[[0,0,0,4]]}
[]
["PROM","NBR","NBR2","PROM3","PROM4"]
["AFSC","ELIG","SEL","OPP","CUTOFF"]
["00XXX",1910,355,18.59,316.36]
["00XXXX",379,83,{"v":21.9,"d":"21.90"},315.81]
["1A0X1",90,20,22.22,320.32]
["1A1X1",189,35,18.52,333.59]
["1A2X1",260,49,18.85,337.56]
["1A3X1",187,41,21.93,319.74]
["1A4X1",91,20,21.98,311.55]
["1A6X1",40,7,{"v":17.5,"d":"17.50"},319.89]
["1A7X1",48,9,18.75,339.32]
["1A8X1",98,22,22.45,315.17]
["1C0X2",254,45,17.72,305.15]
["1C1X1",377,70,18.57,302.75]
["1C2X1",43,9,20.93,317.86]
["1C3X1",265,49,18.49,311.34]
["1C4X1",131,29,22.14,303.45]
["1C5X1",159,35,22.01,304.28]
["1C6X1",129,24,{"v":18.6,"d":"18.60"},314.53]
["1C7X1",113,21,18.58,306.29]
["1N0X1",290,64,22.07,300.97]
["1N1X1",125,27,{"v":21.6,"d":"21.60"},306.09]
["1N2X1",188,35,18.62,311.29]
["1N3X0",242,53,{"v":21.9,"d":"21.90"},306.04]
["1N4X1",175,38,21.71,307.35]
["1N5X1",78,17,21.79,{"v":300.3,"d":"300.30"}]
["1N6X1",35,8,22.86,309.06]
["1S0X1",28,5,17.86,326.03]
["1T0X1",63,14,22.22,313.35]
["1T1X1",280,51,18.21,294.81]
["1T2X1",27,6,22.22,{"v":317.4,"d":"317.40"}]
["1W0X1",297,53,17.85,309.39]
["2A0X1A",85,15,17.65,304.24]
["2A0X1B",39,7,17.95,296.08]
["2A0X1C",74,14,18.92,296.93]
["2A0X1D",53,10,18.87,308.86]
["2A3X1",171,32,18.71,306.52]
["2A3X2",215,40,{"v":18.6,"d":"18.60"},297.91]
["2A3X3",1360,252,18.53,293.32]
["2A5X1",1375,255,18.55,298.37]
["2A5X2",138,26,18.84,309.55]
["2A5X3A",339,63,18.58,305.78]
["2A5X3B",269,50,18.59,309.18]
["2A5X3C",171,32,18.71,301.95]
["2A5X3D",41,8,19.51,298.34]
["2A6X1A",834,155,18.59,294.08]
["2A6X1B",179,33,18.44,299.66]
["2A6X2",620,115,18.55,308.17]
["2A6X3",133,25,{"v":18.8,"d":"18.80"},302.39]
["2A6X4",279,52,18.64,310.69]
["2A6X5",318,59,18.55,300.05]
["2A6X6",563,104,18.47,304.95]
["2A7X1",110,20,18.18,297.93]
["2A7X2",90,17,18.89,306.92]
["2A7X3",437,81,18.54,299.84]
["2A7X4",117,22,{"v":18.8,"d":"18.80"},303.12]
["2E0X1",101,19,18.81,309.38]
["2E1X1",364,68,18.68,304.39]
["2E1X2",166,31,18.67,301.06]
["2E1X3",216,40,18.52,312.91]
["2E1X4",61,11,18.03,316.03]
["2E2X1",363,68,18.73,308.35]
["2E6X2",82,15,18.29,298.86]
["2E6X3",222,41,18.47,289.68]
["2F0X1",565,102,18.05,301.72]
["2G0X1",59,11,18.64,327.27]
["2M0X1",129,23,17.83,302.91]
["2M0X2",88,16,18.18,320.28]
["2M0X3",43,8,{"v":18.6,"d":"18.60"},312.08]
["2P0X1",116,21,{"v":18.1,"d":"18.10"},305.17]
["2R0X1",96,18,18.75,300.64]
["2R1X1",125,23,{"v":18.4,"d":"18.40"},309.92]
["2S0X1",1277,230,18.01,296.77]
["2T0X1",309,55,{"v":17.8,"d":"17.80"},301.24]
["2T1X1",298,55,18.46,316.03]
["2T2X1",627,113,18.02,309.71]
["2T3X0",477,87,18.24,302.61]
["2T3X7",60,11,18.33,315.75]
["2W0X1",990,178,17.98,305.22]
["2W1X1",1085,196,18.06,303.77]
["2W2X1",114,20,17.54,304.17]
["3A0X1",1431,258,18.03,300.55]
["3C0X1",1328,239,{"v":18,"d":"18.00"},313.01]
["3C0X2",156,28,17.95,310.78]
["3C1X1",119,21,17.65,299.03]
["3C1X2",12,2,16.67,321.81]
["3C2X1",209,37,{"v":17.7,"d":"17.70"},305.91]
["3C3X1",76,14,18.42,311.93]
["3E0X1",239,44,18.41,{"v":295.8,"d":"295.80"}]
["3E0X2",208,39,18.75,{"v":315.2,"d":"315.20"}]
["3E1X1",238,42,17.65,300.91]
["3E2X1",203,38,18.72,302.78]
["3E3X1",193,36,18.65,306.38]
["3E4X1",166,30,18.07,{"v":310.3,"d":"310.30"}]
["3E4X2",45,8,17.78,311.02]
["3E4X3",39,7,17.95,315.53]
["3E5X1",109,20,18.35,317.48]
["3E6X1",67,12,17.91,306.29]
["3E7X1",414,77,{"v":18.6,"d":"18.60"},304.49]
["3E8X1",146,27,18.49,317.72]
["3E9X1",78,17,21.79,304.05]
["3M0X1",578,104,17.99,309.25]
["3N0X1",50,9,{"v":18,"d":"18.00"},326.75]
["3N0X2",81,15,18.52,321.97]
["3N0X3",56,10,17.86,309.83]
["3N0X4",63,12,19.05,323.05]
["3N1X0",114,20,17.54,{"v":342.6,"d":"342.60"}]
["3P0X1",2499,463,18.53,304.12]
["3S0X1",1205,217,18.01,322.85]
["3S1X1",20,4,{"v":20,"d":"20.00"},334.45]
["3S2X1",195,36,18.46,334.21]
["3S3X1",30,6,{"v":20,"d":"20.00"},320.65]
["4A0X1",455,83,18.24,311.75]
["4A1X1",140,26,18.57,307.16]
["4A2X1",93,17,18.28,302.55]
["4B0X1",152,28,18.42,297.78]
["4C0X1",68,13,19.12,319.44]
["4D0X1",43,8,{"v":18.6,"d":"18.60"},310.01]
["4E0X1",176,33,18.75,307.97]
["4H0X1",28,5,17.86,313.01]
["4J0X2",41,8,19.51,307.15]
["4J0X2A",6,1,16.67,341.08]
["4M0X1",58,11,18.97,301.64]
["4N0X1",892,161,18.05,305.41]
["4N0X1C",40,7,{"v":17.5,"d":"17.50"},316.67]
["4N1X1",61,11,18.03,304.95]
["4N1X1B",7,1,14.29,330.08]
["4N1X1C",19,4,21.05,323.76]
["4N1X1D",13,2,15.38,312.22]
["4P0X1",181,32,17.68,304.19]
["4R0X1",92,17,18.48,{"v":312.2,"d":"312.20"}]
["4R0X1A",8,1,{"v":12.5,"d":"12.50"},320.68]
["4R0X1B",16,3,18.75,318.94]
["4R0X1C",6,1,16.67,333.71]
["4T0X1",180,32,17.78,305.96]
["4T0X2",7,1,14.29,366.14]
["4V0X1",41,8,19.51,311.97]
["4V0X1A",0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["4Y0X1",326,58,17.79,302.51]
["4Y0X1H",0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["4Y0X2",66,12,18.18,333.98]
["5J0X1",128,23,17.97,{"v":309,"d":"309.00"}]
["5R0X1",73,14,19.18,314.24]
["6C0X1",123,27,21.95,312.62]
["6F0X1",310,55,17.74,313.12]
["7S0X1",134,24,17.91,313.92]
["8A200",17,3,17.65,331.72]
["8B000",147,27,18.37,{"v":326.1,"d":"326.10"}]
["8B100",146,27,18.49,326.23]
["8B200",0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["8C000",1,1,{"v":100,"d":"100.00"},266.29]
["8D000",2,1,{"v":50,"d":"50.00"},304.74]
["8G000",27,5,18.52,303.82]
["8M000",76,14,18.42,{"v":315.9,"d":"315.90"}]
["8P000",34,6,17.65,328.08]
["8P100",7,1,14.29,{"v":328.8,"d":"328.80"}]
["8R000",545,101,18.53,327.22]
["8S000",56,10,17.86,328.55]
["8T000",102,19,18.63,335.42]
["9D000",93,17,18.28,320.38]
["9F000",9,2,22.22,321.36]
["9L000",20,5,{"v":25,"d":"25.00"},334.59]
["9S100",58,11,18.97,324.42]

{"sheet":"MSgt Cutoff","index":6,"n_rows":163,"n_cols":5,"rows_kept":163,"merged":[[0,0,0,4]]}
[]
["PROM","NBR","NBR2","PROM3","PROM4"]
["AFSC","ELIG","SEL","OPP","CUTOFF"]
["00XXX",454,102,22.47,334.16]
["00XXXX",162,43,26.54,339.44]
["1A0X1",62,14,22.58,346.89]
["1A1X1",298,65,21.81,344.04]
["1A2X1",234,52,22.22,353.71]
["1A3X1",132,29,21.97,334.42]
["1A4X1",66,15,22.73,{"v":342.4,"d":"342.40"}]
["1A6X1",38,8,21.05,{"v":342.5,"d":"342.50"}]
["1A7X1",35,8,22.86,345.68]
["1A8X1",71,19,26.76,331.35]
["1C0X2",162,36,22.22,327.75]
["1C1X1",198,44,22.22,328.68]
["1C2X1",35,9,25.71,331.95]
["1C3X1",219,49,22.37,330.15]
["1C4X1",71,19,26.76,328.12]
["1C5X1",77,17,22.08,334.89]
["1C6X1",118,25,21.19,336.92]
["1C7X1",53,12,22.64,313.95]
["1N0X1",208,55,26.44,315.95]
["1N1X1",101,27,26.73,312.85]
["1N2X1",134,29,21.64,322.29]
["1N3X0",148,39,26.35,316.95]
["1N4X1",129,34,26.36,321.68]
["1N5X1",80,21,26.25,313.76]
["1N6X1",23,6,26.09,334.43]
["1S0X1",66,15,22.73,323.47]
["1T0X1",38,8,21.05,346.25]
["1T1X1",148,32,21.62,316.26]
["1T2X1",25,7,{"v":28,"d":"28.00"},{"v":317,"d":"317.00"}]
["1W0X1",259,58,22.39,321.91]
["2A0X1A",32,7,21.88,328.25]
["2A0X1B",43,10,23.26,318.16]
["2A0X1C",42,9,21.43,316.07]
["2A0X1D",41,9,21.95,345.02]
["2A3X1",121,27,22.31,{"v":321,"d":"321.00"}]
["2A3X2",175,39,22.29,311.42]
["2A3X3",798,178,22.31,306.89]
["2A5X1",884,197,22.29,316.75]
["2A5X2",96,21,21.88,325.52]
["2A5X3A",196,42,21.43,324.53]
["2A5X3B",170,36,21.18,327.28]
["2A5X3C",89,20,22.47,330.04]
["2A5X3D",23,5,21.74,315.82]
["2A6X1A",423,92,21.75,{"v":322.1,"d":"322.10"}]
["2A6X1B",108,23,{"v":21.3,"d":"21.30"},320.48]
["2A6X2",385,84,21.82,324.89]
["2A6X3",72,16,22.22,318.26]
["2A6X4",156,33,21.15,333.55]
["2A6X5",239,51,21.34,317.37]
["2A6X6",328,72,21.95,323.11]
["2A7X1",66,15,22.73,319.51]
["2A7X2",59,13,22.03,319.51]
["2A7X3",244,52,21.31,324.93]
["2A7X4",66,15,22.73,326.64]
["2E0X1",62,14,22.58,328.63]
["2E1X1",210,47,22.38,{"v":322.7,"d":"322.70"}]
["2E1X2",90,20,22.22,315.33]
["2E1X3",161,36,22.36,331.06]
["2E1X4",42,9,21.43,326.41]
["2E2X1",257,55,{"v":21.4,"d":"21.40"},325.13]
["2E6X2",41,9,21.95,312.11]
["2E6X3",112,24,21.43,313.54]
["2F0X1",364,79,{"v":21.7,"d":"21.70"},327.09]
["2G0X1",77,17,22.08,342.12]
["2M0X1",87,19,21.84,327.74]
["2M0X2",64,14,21.88,338.23]
["2M0X3",43,10,23.26,341.86]
["2P0X1",72,16,22.22,330.79]
["2R0X1",58,15,25.86,318.22]
["2R1X1",88,19,21.59,334.36]
["2S0X1",768,167,21.74,315.51]
["2T0X1",163,35,21.47,323.13]
["2T1X1",187,42,22.46,342.41]
["2T2X1",382,84,21.99,325.15]
["2T3X0",284,61,21.48,320.24]
["2T3X7",71,16,22.54,324.33]
["2W0X1",590,129,21.86,327.74]
["2W1X1",642,141,21.96,327.01]
["2W2X1",60,13,21.67,324.54]
["3A0X1",1019,223,21.88,321.57]
["3C0X1",802,175,21.82,331.61]
["3C0X2",114,25,21.93,330.16]
["3C1X1",41,9,21.95,{"v":335.2,"d":"335.20"}]
["3C1X2",14,3,21.43,336.17]
["3C2X1",205,44,21.46,323.81]
["3C3X1",70,18,25.71,332.76]
["3E0X1",135,29,21.48,{"v":318.9,"d":"318.90"}]
["3E0X2",108,24,22.22,336.87]
["3E1X1",145,31,21.38,{"v":327.2,"d":"327.20"}]
["3E2X1",115,26,22.61,335.79]
["3E3X1",128,29,22.66,326.43]
["3E4X1",119,25,21.01,{"v":328.2,"d":"328.20"}]
["3E4X2",30,7,23.33,333.39]
["3E4X3",20,4,{"v":20,"d":"20.00"},{"v":329.1,"d":"329.10"}]
["3E5X1",80,18,{"v":22.5,"d":"22.50"},{"v":334.6,"d":"334.60"}]
["3E6X1",26,6,23.08,340.19]
["3E7X1",222,50,22.52,323.24]
["3E8X1",71,19,26.76,341.18]
["3E9X1",45,12,26.67,329.95]
["3H0X1",0,0,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["3M0X1",356,78,21.91,327.41]
["3N0X1",35,8,22.86,339.17]
["3N0X2",49,11,22.45,343.33]
["3N0X3",31,7,22.58,330.32]
["3N0X4",39,9,23.08,{"v":333.2,"d":"333.20"}]
["3N1X0",78,17,21.79,353.74]
["3P0X1",1279,285,22.28,326.47]
["3S0X1",750,164,21.87,341.91]
["3S1X1",31,7,22.58,341.01]
["3S2X1",213,46,{"v":21.6,"d":"21.60"},345.42]
["3S3X1",86,19,22.09,336.57]
["4A0X1",290,65,22.41,326.67]
["4A1X1",95,21,22.11,324.21]
["4A2X1",52,14,26.92,323.17]
["4B0X1",101,22,21.78,322.37]
["4C0X1",65,15,23.08,330.21]
["4D0X1",32,7,21.88,317.42]
["4E0X1",125,27,{"v":21.6,"d":"21.60"},325.85]
["4H0X1",24,5,20.83,330.84]
["4J0X2",41,9,21.95,322.41]
["4J0X2A",5,1,{"v":20,"d":"20.00"},314.58]
["4M0X1",28,6,21.43,333.41]
["4N0X1",476,104,21.85,320.81]
["4N0X1C",104,23,22.12,321.03]
["4N1X1",44,10,22.73,314.32]
["4N1X1B",2,1,{"v":50,"d":"50.00"},322.79]
["4N1X1C",20,4,{"v":20,"d":"20.00"},328.41]
["4N1X1D",14,3,21.43,315.75]
["4P0X1",94,21,22.34,326.72]
["4R0X1",48,11,22.92,331.09]
["4R0X1A",10,2,{"v":20,"d":"20.00"},333.17]
["4R0X1B",15,3,{"v":20,"d":"20.00"},326.93]
["4R0X1C",9,2,22.22,334.91]
["4T0X1",103,22,21.36,320.06]
["4T0X2",6,1,16.67,339.16]
["4V0X1",36,8,22.22,321.79]
["4Y0X1",178,40,22.47,325.56]
["4Y0X2",70,15,21.43,333.62]
["5J0X1",179,39,21.79,321.08]
["5R0X1",47,12,25.53,325.29]
["6C0X1",133,35,26.32,339.61]
["6F0X1",272,59,21.69,333.96]
["7S0X1",211,56,26.54,326.61]
["8A200",25,7,{"v":28,"d":"28.00"},336.73]
["8B000",102,23,22.55,346.33]
["8B100",69,15,21.74,329.16]
["8B200",22,5,22.73,356.57]
["8C000",37,8,21.62,346.32]
["8D000",6,1,16.67,336.07]
["8G000",13,3,23.08,340.41]
["8M000",43,10,23.26,338.02]
["8P000",13,3,23.08,{"v":330.9,"d":"330.90"}]
["8P100",18,4,22.22,335.16]
["8R000",470,105,22.34,342.23]
["8S000",60,13,21.67,344.96]
["8T000",145,31,21.38,361.41]
["9D000",42,9,21.43,{"v":332.4,"d":"332.40"}]
["9F000",40,9,{"v":22.5,"d":"22.50"},344.49]
["9L000",10,2,{"v":20,"d":"20.00"},{"v":341.9,"d":"341.90"}]
["9S100",47,10,21.28,337.47]

{"sheet":"SMSgt Cutoff","index":7,"n_rows":119,"n_cols":5,"rows_kept":119,"merged":[[0,0,0,4]]}
[]
["PROM","NBR","NBR2","PROM3","PROM4"]
["AFSC","ELIG","SEL","OPP","CUTOFF"]
["1A0X1",61,6,9.84,665.95]
["1A1X1",235,17,7.23,662.66]
["1A2X1",175,19,10.86,663.43]
["1A3X1",92,9,9.78,657.44]
["1A4X1",59,5,8.33,656.24]
["1A6X1",27,2,7.41,672.06]
["1A7X1",36,4,11.11,685.47]
["1A8X1",50,5,{"v":10,"d":"10.00"},648.48]
["1C0X2",96,9,9.27,658.84]
["1C1X1",111,12,10.81,643.36]
["1C2X1",21,3,14.29,666.37]
["1C3X1",150,15,{"v":10,"d":"10.00"},{"v":649.5,"d":"649.50"}]
["1C4X1",32,4,{"v":12.5,"d":"12.50"},637.87]
["1C5X1",67,5,7.46,657.16]
["1C6X1",86,8,{"v":9.3,"d":"9.30"},670.99]
["1C7X1",28,3,10.71,620.27]
["1N0X1",107,12,11.11,657.97]
["1N1X1",42,5,{"v":11.9,"d":"11.90"},633.97]
["1N2X1",86,9,10.47,652.52]
["1N3X0",61,6,9.84,649.72]
["1N4X1",86,9,10.47,644.31]
["1N5X1",35,4,11.11,640.03]
["1N6X1",11,1,9.09,687.67]
["1S0X1",49,5,{"v":10.2,"d":"10.20"},636.71]
["1T0X1",17,3,17.65,661.16]
["1T1X1",74,9,12.16,672.33]
["1T2X1",12,1,8.33,652.38]
["1W0X1",141,15,10.64,641.43]
["2A0X0",114,12,10.53,648.48]
["2A3X0",637,67,10.52,656.28]
["2A5X0",849,75,8.82,{"v":659.6,"d":"659.60"}]
["2A6X0",417,31,7.43,645.95]
["2A6X1",317,23,7.26,633.05]
["2A6X2",247,18,7.29,{"v":644.6,"d":"644.60"}]
["2A7X0",250,18,{"v":7.2,"d":"7.20"},656.55]
["2E1X0",333,35,10.51,653.57]
["2E2X0",241,17,7.05,675.25]
["2F0X1",195,17,8.72,651.37]
["2G0X1",66,7,10.61,664.56]
["2M0X0",150,13,8.67,662.98]
["2P0X1",52,4,7.69,685.67]
["2R0X0",93,9,9.68,648.11]
["2S0X1",431,38,8.82,643.69]
["2T0X1",74,7,9.33,646.02]
["2T1X1",80,8,{"v":10,"d":"10.00"},649.66]
["2T2X1",214,19,8.88,649.23]
["2T3X0",160,11,6.88,657.02]
["2W0X1",355,32,9.01,658.79]
["2W1X1",411,30,{"v":7.3,"d":"7.30"},648.24]
["2W2X1",41,4,9.76,{"v":676.8,"d":"676.80"}]
["3A0X1",579,45,7.75,646.91]
["3C0X0",521,40,7.66,660.45]
["3C1X1",35,3,8.57,635.21]
["3C1X2",11,1,9.09,660.27]
["3C2X1",84,7,8.33,673.58]
["3C3X1",42,4,9.52,679.57]
["3E0X0",120,11,9.09,677.79]
["3E1X1",82,6,7.32,658.01]
["3E2X1",59,5,8.47,{"v":667.6,"d":"667.60"}]
["3E3X1",77,6,7.79,663.92]
["3E4X0",88,7,7.95,651.93]
["3E5X1",44,4,9.09,676.95]
["3E6X1",31,2,6.25,673.22]
["3E7X1",106,11,10.38,626.78]
["3E8X1",18,3,16.67,644.87]
["3E9X1",34,4,11.76,623.65]
["3M0X1",206,21,10.19,653.82]
["3N0X0",44,3,6.82,633.34]
["3N1X1",55,4,7.27,651.59]
["3P0X1",608,64,{"v":10.5,"d":"10.50"},644.82]
["3S0X1",437,39,{"v":8.9,"d":"8.90"},658.37]
["3S1X1",37,3,8.11,{"v":649.4,"d":"649.40"}]
["3S2X1",168,15,8.93,663.97]
["3S3X1",89,8,8.99,666.24]
["3V0X0",56,5,8.93,670.34]
["4A0X1",151,13,8.61,650.97]
["4A1X1",52,4,7.69,643.24]
["4A2X1",25,2,{"v":8,"d":"8.00"},689.56]
["4B0X1",52,6,11.54,643.29]
["4C0X1",38,2,5.26,701.51]
["4D0X1",20,2,{"v":10,"d":"10.00"},699.29]
["4E0X1",70,6,8.57,665.05]
["4H0X1",14,2,14.29,654.67]
["4J0X0",22,2,9.09,639.72]
["4M0X1",20,2,{"v":10,"d":"10.00"},695.77]
["4N0X1",315,23,{"v":7.3,"d":"7.30"},643.95]
["4N1X1",41,5,{"v":12.2,"d":"12.20"},645.17]
["4P0X1",37,4,10.81,641.93]
["4R0X0",41,3,7.32,668.07]
["4T0X0",77,6,7.79,651.55]
["4V0X0",22,2,9.09,688.38]
["4Y0X0",141,11,{"v":7.8,"d":"7.80"},642.23]
["5J0X1",104,11,10.58,654.44]
["5R0X1",27,3,11.11,622.46]
["6C0X1",104,11,10.58,661.84]
["6F0X1",176,16,9.09,654.52]
["7S0X1",80,8,{"v":10,"d":"10.00"},635.47]
["8A100",56,5,8.93,703.25]
["8A200",18,2,11.11,691.26]
["8B000",31,2,6.45,643.44]
["8B100",21,2,9.52,626.58]
["8B200",41,4,9.76,643.36]
["8C000",48,4,8.33,643.99]
["8D000",3,1,33.33,559.22]
["8F000",659,59,8.95,674.23]
["8G000",10,1,{"v":10,"d":"10.00"},638.49]
["8J000",2,1,{"v":50,"d":"50.00"},652.19]
["8M000",22,2,9.09,690.17]
["8P000",9,1,11.11,643.73]
["8P100",21,2,9.52,651.47]
["8R000",259,19,7.34,653.98]
["8S000",12,1,8.33,679.18]
["8T000",93,6,6.45,670.61]
["9D000",26,2,7.69,626.89]
["9L000",8,1,{"v":12.5,"d":"12.50"},638.25]
["9S100",31,4,{"v":12.9,"d":"12.90"},646.78]

{"sheet":"CMSgt Cutoff","index":8,"n_rows":90,"n_cols":5,"rows_kept":90,"merged":[[0,0,0,4]]}
[]
["PROM","NBR","NBR","PROM","PROM"]
["AFSC","ELIG","SEL","OPP","CUTOFF"]
["1A0X0","16","3","18.75","646.83"]
["1A1X0","38","8","21.05","645.66"]
["1A2X0","31","7","22.58","646.83"]
["1A3X0","11","2","18.18","688.66"]
["1A4X0","7","1","14.29","672.16"]
["1A6X0","3","1","33.33","594.00"]
["1A7X0","4","1","25.00","636.50"]
["1A8X0","10","2","20.00","641.25"]
["1C0X0","20","4","20.00","646.58"]
["1C1X0","20","4","20.00","624.58"]
["1C2X0","3","2","66.67","649.16"]
["1C3X0","23","5","21.74","647.08"]
["1C4X0","2","2","100.00","578.75"]
["1C5X0","11","3","27.27","658.25"]
["1C6X0","9","2","22.22","652.25"]
["1C7X0","9","3","33.33","643.50"]
["1N0X0","75","16","21.33","646.33"]
["1P0X0","21","4","19.05","675.50"]
["1S0X0","5","1","20.00","661.00"]
["1T0X0","5","1","20.00","631.25"]
["1T2X0","6","2","33.33","666.58"]
["1W0X0","25","5","20.00","658.91"]
["2A3X0","253","54","21.34","637.08"]
["2A6X0","204","39","19.12","661.41"]
["2E0X0","92","18","19.57","648.41"]
["2F0X0","23","6","26.09","642.00"]
["2G0X0","14","3","21.43","651.00"]
["2M0X0","27","7","25.93","639.16"]
["2P0X0","16","3","18.75","667.50"]
["2R0X0","19","4","21.05","644.50"]
["2S0X0","69","15","21.74","632.83"]
["2T0X0","17","5","29.41","627.08"]
["2T1X0","11","2","18.18","666.00"]
["2T2X0","29","6","20.69","654.00"]
["2T3X0","18","4","22.22","638.00"]
["2W0X0","58","15","25.86","644.00"]
["2W1X0","72","13","18.06","653.50"]
["2W2X0","6","1","16.67","693.75"]
["3A0X0","112","22","19.64","634.33"]
["3C0X0","141","27","19.15","650.50"]
["3E0X0","81","17","20.99","656.50"]
["3E7X0","21","4","19.05","660.08"]
["3E8X0","4","1","25.00","630.50"]
["3E9X0","7","1","14.29","623.00"]
["3M0X0","32","7","21.88","636.00"]
["3N0X0","27","7","25.93","614.00"]
["3N1X0","10","3","30.00","640.50"]
["3P0X0","83","22","26.51","633.50"]
["3S0X0","93","18","19.35","626.00"]
["3S1X0","7","1","14.29","618.50"]
["3S2X0","29","5","17.24","636.00"]
["4A0X0","34","7","20.59","661.50"]
["4A1X0","8","2","25.00","649.00"]
["4A2X0","6","1","16.67","662.00"]
["4B0X0","8","2","25.00","671.00"]
["4C0X0","2","1","50.00","665.50"]
["4D0X0","6","1","16.67","640.50"]
["4E0X0","11","2","18.18","650.00"]
["4H0X0","1","1","100.00","632.50"]
["4J0X0","4","1","25.00","654.00"]
["4M0X0","3","1","33.33","667.50"]
["4N0X0","49","11","22.45","648.00"]
["4P0X0","5","1","20.00","668.00"]
["4R0X0","7","1","14.29","640.66"]
["4T0X0","15","3","20.00","644.75"]
["4V0X0","1","1","100.00","589.00"]
["4Y0X0","23","5","21.74","653.66"]
["5J0X0","17","4","23.53","631.00"]
["5R0X0","1","1","100.00","609.00"]
["6C0X0","15","3","20.00","652.16"]
["6F0X0","35","7","20.00","642.00"]
["7S0X0","6","1","16.67","678.08"]
["8A100","8","2","25.00","636.50"]
["8A200","1","1","100.00","614.00"]
["8B000","7","1","14.29","691.58"]
["8B100","2","1","50.00","686.00"]
["8B200","1","1","100.00","652.08"]
["8C000","4","1","25.00","622.00"]
["8F000","102","22","21.57","644.00"]
["8G000","2","1","50.00","633.58"]
["8M000","8","2","25.00","650.00"]
["8P000","5","1","20.00","705.50"]
["8P100","13","3","23.08","639.41"]
["8R000","36","8","22.22","643.25"]
["8T000","32","7","21.88","633.33"]
["9L000","1","1","100.00","551.41"]
["9S100","7","2","28.57","635.50"]

{"sheet":"Reference Sheet","index":9,"n_rows":75,"n_cols":36,"rows_kept":75,"hidden":true,"merged":[[0,3,0,5],[0,7,0,9],[0,10,0,12],[0,13,0,15],[0,16,0,18],[2,22,14,22],[14,7,15,18],[15,22,27,22],[17,5,21,11],[28,22,40,22],[41,22,53,22],[54,22,66,22]]}
["TAFMS","TIG",{"$nulls":5},"SSgt",null,null,"TSgt/MSgt",null,null,"E8",null,null,"E9"]
[{"$f":"TODAY()","v":"2008-11-21"},{"$f":"TODAY()","v":"2008-11-21"},{"$nulls":6},"2009-08-01","2009-08-31",null,"2009-07-01","2009-07-31",2008,"2009-03-01","2009-03-31",2008,"2009-12-01","2009-12-31",{"$nulls":5},"Cycle","DOR","TIG Required","TAFMSD","TIS Required","PAFSC","PECD","Testing Cycle","Promotion Months","Announcements","EPRs Consdrd","1st Test date"]
[{"$f":"(YEAR('Reference Sheet'!A2)-YEAR(#REF!))*12+MONTH('Reference Sheet'!A2)-MONTH(#REF!)","v":{"$error":"#REF!"}},{"$f":"(YEAR(B2)-YEAR(#REF!))*12+MONTH(B2)-MONTH(#REF!)","v":{"$error":"#REF!"}},{"$nulls":5},2009,"2010-08-01","2010-08-31",2009,"2010-07-01","2010-07-31",2009,"2010-03-01","2010-03-31",2009,"2010-12-01","2010-12-31",1,null,null,"E7Cycle",2008,"08E7","2006-07-01","24 Months","2001-07-01","8 Years","7 Skill Level","2007-12-31","1 Feb - 31 Mar 08","Aug 08 - Jul 09","2008-06-08","Jan 03 - Dec 07","2008-02-01"]
[{"$f":"(A3)*(1/6)","v":{"$error":"#REF!"}},{"$f":"(B3)*(1/2)","v":{"$error":"#REF!"}},{"$nulls":5},2010,"2011-08-01","2011-08-31",2010,"2011-07-01","2011-07-31",2010,"2011-03-01","2011-03-31",2010,"2011-12-01","2011-12-31",2,2008,null,null,2009,"09E7","2007-07-01","24 Months","2002-07-01","8 Years","7 Skill Level","2008-12-31","1 Feb - 31 Mar 09","Aug 09 - Jul 10","2009-06-09","Jan 04 - Dec 08","2009-02-01"]
[{"$nulls":7},2011,"2012-08-01","2012-08-31",2011,"2012-07-01","2012-07-31",2011,"2012-03-01","2012-03-31",2011,"2012-12-01","2012-12-31",3,2009,null,null,2010,"10E7","2008-07-01","24 Months","2003-07-01","8 Years","7 Skill Level","2009-12-31","1 Feb - 31 Mar 10","Aug 10 - Jul 11","2010-06-10","Jan 05 - Dec 09","2010-02-01"]
[{"$nulls":7},2012,"2013-08-01","2013-08-31",2012,"2013-07-01","2013-07-31",2012,"2013-03-01","2013-03-31",2012,"2013-12-01","2013-12-31",4,2010,null,null,2011,"11E7","2009-07-01","24 Months","2004-07-01","8 Years","7 Skill Level","2010-12-31","1 Feb - 31 Mar 11","Aug 11 - Jul 12","2011-06-11","Jan 06 - Dec 10","2011-02-01"]
[{"$nulls":7},2013,"2014-08-01","2014-08-31",2013,"2014-07-01","2014-07-31",2013,"2014-03-01","2014-03-31",2013,"2014-12-01","2014-12-31",5,2011,null,null,2012,"12E7","2010-07-01","24 Months","2005-07-01","8 Years","7 Skill Level","2011-12-31","1 Feb - 31 Mar 12","Aug 12 - Jul 13","2012-06-11","Jan 07 - Dec 11","2012-02-01"]
[{"$nulls":7},2014,"2015-08-01","2015-08-31",2014,"2015-07-01","2015-07-31",2014,"2015-03-01","2015-03-31",2014,"2015-12-01","2015-12-31",6,2012,null,null,2013,"13E7","2011-07-01","24 Months","2006-07-01","8 Years","7 Skill Level","2012-12-31","1 Feb - 31 Mar 13","Aug 13 - Jul 14","2013-06-12","Jan 08 - Dec 12","2013-02-01"]
[{"$nulls":7},2015,"2016-08-01","2016-08-31",2015,"2016-07-01","2016-07-31",2015,"2016-03-01","2016-03-31",2015,"2016-12-01","2016-12-31",7,2013,null,null,2014,"14E7","2012-07-01","24 Months","2007-07-01","8 Years","7 Skill Level","2013-12-31","1 Feb - 31 Mar 14","Aug 14 - Jul 15","2014-06-13","Jan 09 - Dec 13","2014-02-01"]
[{"$nulls":7},2016,"2017-08-01","2017-08-31",2016,"2017-07-01","2017-07-31",2016,"2017-03-01","2017-03-31",2016,"2017-12-01","2017-12-31",8,2014,null,null,2015,"15E7","2013-07-01","24 Months","2008-07-01","8 Years","7 Skill Level","2014-12-31","1 Feb - 31 Mar 15","Aug 15 - Jul 16","2015-06-14","Jan 10 - Dec 14","2015-02-01"]
[{"$nulls":7},2017,"2018-08-01","2018-08-31",2017,"2018-07-01","2018-07-31",2017,"2018-03-01","2018-03-31",2017,"2018-12-01","2018-12-31",9,2015,null,null,2016,"16E7","2014-07-01","24 Months","2009-07-01","8 Years","7 Skill Level","2015-12-31","1 Feb - 31 Mar 16","Aug 16 - Jul 17","2016-06-14","Jan 11 - Dec 15","2016-02-01"]
["Decorations",{"$nulls":6},2018,"2019-08-01","2019-08-31",2018,"2019-07-01","2019-07-31",2018,"2019-03-01","2019-03-31",2018,"2019-12-01","2019-12-31",10,2016,null,null,2017,"17E7","2015-07-01","24 Months","2010-07-01","8 Years","7 Skill Level","2016-12-31","1 Feb - 31 Mar 17","Aug 17 - Jul 18","2017-06-15","Jan 12 - Dec 16","2017-02-01"]
[1,"AF Achievement",1,null,"Ranks",null,null,2019,"2020-08-01","2020-08-31",2019,"2020-07-01","2020-07-31",2019,"2020-03-01","2020-03-31",2019,"2020-12-01","2020-12-31",11,2017,null,null,2018,"18E7","2016-07-01","24 Months","2011-07-01","8 Years","7 Skill Level","2017-12-31","1 Feb - 31 Mar 18","Aug 18 - Jul 19","2018-06-16","Jan 13 - Dec 17","2018-02-01"]
[2,"Army Achievement",1,1,{"$nulls":3},2020,"2021-08-01","2021-08-31",2020,"2021-07-01","2021-07-31",2020,"2021-03-01","2021-03-31",2020,"2021-12-01","2021-12-31",12,2018,null,null,2019,"19E7","2017-07-01","24 Months","2012-07-01","8 Years","7 Skill Level","2018-12-31","1 Feb - 31 Mar 19","Aug 19 - Jul 20","2019-06-17","Jan 14 - Dec 18","2019-02-01"]
[3,"Coast Guard Achievement",1,2,"SSgt",null,null,"1st and last day of the promotion cycles",{"$nulls":11},13,2019,null,null,2020,"20E7","2018-07-01","24 Months","2013-07-01","8 Years","7 Skill Level","2019-12-31","1 Feb - 31 Mar 20","Aug 20 - Jul 21","2020-06-17","Jan 15 - Dec 19","2020-02-01"]
[4,"Joint Svc Achievement",1,3,"TSgt",{"$nulls":14},14,2020,null,"E6Cycle",2008,"08E6","2006-08-01","23 Months","2004-07-01","5 Years","5 Skill Level","2007-12-31","1 Feb - 31 Mar 08","Aug 08 - Jul 09","2008-06-08","Jan 03 - Dec 07","2008-02-01"]
[5,"Navy Achievement",1,4,"MSgt",{"$nulls":18},2009,"09E6","2007-08-01","23 Months","2005-07-01","5 Years","5 Skill Level","2008-12-31","1 Feb - 31 Mar 09","Aug 09 - Jul 10","2009-06-09","Jan 04 - Dec 08","2009-02-01"]
[6,"Aerial Achievement ",3,5,"SMSgt","DO NOT DELETE THIS PAGE.  IT CONTAINS THE FORMULAS FOR THE WAPS CALCULATOR",{"$nulls":17},2010,"10E6","2008-08-01","23 Months","2006-07-01","5 Years","5 Skill Level","2009-12-31","1 Feb - 31 Mar 10","Aug 10 - Jul 11","2010-06-10","Jan 05 - Dec 09","2010-02-01"]
[7,"AF Commendation",3,6,"CMSgt",{"$nulls":18},2011,"11E6","2009-08-01","23 Months","2007-07-01","5 Years","5 Skill Level","2010-12-31","1 Feb - 31 Mar 11","Aug 11 - Jul 12","2011-06-11","Jan 06 - Dec 10","2011-02-01"]
[8,"Air Medal",3,{"$nulls":20},2012,"12E6","2010-08-01","23 Months","2008-07-01","5 Years","5 Skill Level","2011-12-31","1 Feb - 31 Mar 12","Aug 12 - Jul 13","2012-06-11","Jan 07 - Dec 11","2012-02-01"]
[9,"Army Commendation",3,{"$nulls":20},2013,"13E6","2011-08-01","23 Months","2009-07-01","5 Years","5 Skill Level","2012-12-31","1 Feb - 31 Mar 13","Aug 13 - Jul 14","2013-06-12","Jan 08 - Dec 12","2013-02-01"]
[10,"Coast Guard Commendation",3,{"$nulls":20},2014,"14E6","2012-08-01","23 Months","2010-07-01","5 Years","5 Skill Level","2013-12-31","1 Feb - 31 Mar 14","Aug 14 - Jul 15","2014-06-13","Jan 09 - Dec 13","2014-02-01"]
[11,"Joint Svc Commendation",3,{"$nulls":20},2015,"15E6","2013-08-01","23 Months","2011-07-01","5 Years","5 Skill Level","2014-12-31","1 Feb - 31 Mar 15","Aug 15 - Jul 16","2015-06-14","Jan 10 - Dec 14","2015-02-01"]
[12,"Navy Commendation",3,{"$nulls":20},2016,"16E6","2014-08-01","23 Months","2012-07-01","5 Years","5 Skill Level","2015-12-31","1 Feb - 31 Mar 16","Aug 16 - Jul 17","2016-06-14","Jan 11 - Dec 15","2016-02-01"]
[13,"Airman's  Medal",5,{"$nulls":20},2017,"17E6","2015-08-01","23 Months","2013-07-01","5 Years","5 Skill Level","2016-12-31","1 Feb - 31 Mar 17","Aug 17 - Jul 18","2017-06-15","Jan 12 - Dec 16","2017-02-01"]
[14,"Bronze Star",5,null,null,"SSgt","SrA",{"$nulls":16},2018,"18E6","2016-08-01","23 Months","2014-07-01","5 Years","5 Skill Level","2017-12-31","1 Feb - 31 Mar 18","Aug 18 - Jul 19","2018-06-16","Jan 13 - Dec 17","2018-02-01"]
[15,"Coast Guard Medal",5,null,null,"TSgt","SSgt",{"$nulls":16},2019,"19E6","2017-08-01","23 Months","2015-07-01","5 Years","5 Skill Level","2018-12-31","1 Feb - 31 Mar 19","Aug 19 - Jul 20","2019-06-17","Jan 14 - Dec 18","2019-02-01"]
[16,"Def. Meritorious Svc Medal",5,null,null,"MSgt","TSgt",{"$nulls":16},2020,"20E6","2018-08-01","23 Months","2016-07-01","5 Years","5 Skill Level","2019-12-31","1 Feb - 31 Mar 20","Aug 20 - Jul 21","2020-06-17","Jan 15 - Dec 19","2020-02-01"]
[17,"Navy-Marine Corps Medal",5,null,null,"SMSgt","MSgt",{"$nulls":15},"E5Cycle",2008,"08E5","2008-02-01","6 Months","2006-08-01","3 Years","5 Skill Level","2008-03-31","1 May - 15 Jun 08","Sep 08 - Aug 09","2008-08-09","Apr 03 - Mar 08","2008-05-01"]
[18,"Purple Heart",5,null,null,"CMSgt","SMSgt",{"$nulls":16},2009,"09E5","2009-02-01","6 Months","2007-08-01","3 Years","5 Skill Level","2009-03-31","1 May - 15 Jun 09","Sep 09 - Aug 10","2009-08-09","Apr 04 - Mar 09","2009-05-01"]
[19,"Soldier's Medal",5,{"$nulls":20},2010,"10E5","2010-02-01","6 Months","2008-08-01","3 Years","5 Skill Level","2010-03-31","1 May - 15 Jun 10","Sep 10 - Aug 11","2010-08-09","Apr 05 - Mar 10","2010-05-01"]
[20,"Meritorious Svc Medal",5,{"$nulls":20},2011,"11E5","2011-02-01","6 Months","2009-08-01","3 Years","5 Skill Level","2011-03-31","1 May - 15 Jun 11","Sep 11 - Aug 12","2011-08-09","Apr 06 - Mar 11","2011-05-01"]
[21,"Def. Superior Svc Medal",7,{"$nulls":20},2012,"12E5","2012-02-01","6 Months","2010-08-01","3 Years","5 Skill Level","2012-03-31","1 May - 15 Jun 12","Sep 12 - Aug 13","2012-08-09","Apr 07 - Mar 12","2012-05-01"]
[22,"Distinguished Flying Cross",7,{"$nulls":20},2013,"13E5","2013-02-01","6 Months","2011-08-01","3 Years","5 Skill Level","2013-03-31","1 May - 15 Jun 13","Sep 13 - Aug 14","2013-08-09","Apr 08 - Mar 13","2013-05-01"]
[23,"Legion of Merit",7,{"$nulls":20},2014,"14E5","2014-02-01","6 Months","2012-08-01","3 Years","5 Skill Level","2014-03-31","1 May - 15 Jun 14","Sep 14 - Aug 15","2014-08-09","Apr 09 - Mar 14","2014-05-01"]
[24,"Def. Distinguished Svc Medal",9,{"$nulls":20},2015,"15E5","2015-02-01","6 Months","2013-08-01","3 Years","5 Skill Level","2015-03-31","1 May - 15 Jun 15","Sep 15 - Aug 16","2015-08-09","Apr 10 - Mar 15","2015-05-01"]
[25,"Distinguished Svc Medal",9,{"$nulls":20},2016,"16E5","2016-02-01","6 Months","2014-08-01","3 Years","5 Skill Level","2016-03-31","1 May - 15 Jun 16","Sep 16 - Aug 17","2016-08-09","Apr 11 - Mar 16","2016-05-01"]
[26,"Silver Star",9,{"$nulls":20},2017,"17E5","2017-02-01","6 Months","2015-08-01","3 Years","5 Skill Level","2017-03-31","1 May - 15 Jun 17","Sep 17 - Aug 18","2017-08-09","Apr 12 - Mar 17","2017-05-01"]
[27,"AF Cross",11,{"$nulls":20},2018,"18E5","2018-02-01","6 Months","2016-08-01","3 Years","5 Skill Level","2018-03-31","1 May - 15 Jun 18","Sep 18 - Aug 19 ","2018-08-09","Apr 13 - Mar 18","2018-05-01"]
[28,"Distinguished Svc Cross",11,{"$nulls":20},2019,"19E5","2019-02-01","6 Months","2017-08-01","3 Years","5 Skill Level","2019-03-31","1 May - 15 Jun 19","Sep 19 - Aug 20","2019-08-09","Apr 14 - Mar 19","2019-05-01"]
[29,"Navy Cross",11,{"$nulls":20},2020,"20E5","2020-02-01","6 Months","2018-08-01","3 Years","5 Skill Level","2020-03-31","1 May - 15 Jun 20","Sep 20 - Aug 21","2020-08-09","Apr 15 - Mar 20","2020-05-01"]
[30,"Medal of Honor",15,{"$nulls":19},"E8Cycle",2008,"08E8","2006-07-01","20 Months","1998-03-01","11 Years","7 Skill Level","2007-09-30","1 Dec - 31 Dec 08","Apr 08 - Mar 09","2008-03-01","Oct 03 - Sep 08","2008-11-01"]
[{"$nulls":23},2009,"09E8","2007-07-01","20 Months","1999-03-01","11 Years","7 Skill Level","2008-09-30","1 Dec - 31 Dec 08","Apr 09 - Mar 10","2009-03-01","Oct 04 - Sep 09","2009-11-01"]
[{"$nulls":23},2010,"10E8","2008-07-01","20 Months","2000-03-01","11 Years","7 Skill Level","2009-09-30","1 Dec - 31 Dec 09","Apr 10 - Mar 11","2010-03-01","Oct 05 - Sep 10","2010-11-01"]
[{"$nulls":23},2011,"11E8","2009-07-01","20 Months","2001-03-01","11 Years","7 Skill Level","2010-09-30","1 Dec - 31 Dec 10","Apr 11 - Mar 12","2011-03-01","Oct 06 - Sep 11","2011-11-01"]
[{"$nulls":23},2012,"12E8","2010-07-01","20 Months","2002-03-01","11 Years","7 Skill Level","2011-09-30","1 Dec - 31 Dec 11","Apr 12 - Mar 13","2012-03-01","Oct 07 - Sep 12","2012-11-01"]
["AF Achievement",{"$nulls":22},2013,"13E8","2011-07-01","20 Months","2003-03-01","11 Years","7 Skill Level","2012-09-30","1 Dec - 31 Dec 12","Apr 13 - Mar 14","2013-03-01","Oct 08 - Sep 13","2013-11-01"]
["Army Achievement",{"$nulls":22},2014,"14E8","2012-07-01","20 Months","2004-03-01","11 Years","7 Skill Level","2013-09-30","1 Dec - 31 Dec 13","Apr 14 - Mar 15","2014-03-01","Oct 09 - Sep 14","2014-11-01"]
["Coast Guard Achievement",{"$nulls":22},2015,"15E8","2013-07-01","20 Months","2005-03-01","11 Years","7 Skill Level","2014-09-30","1 Dec - 31 Dec 14","Apr 15 - Mar 16","2015-03-01","Oct 10 - Sep 15","2015-11-01"]
["Joint Svc Achievement",{"$nulls":22},2016,"16E8","2014-07-01","20 Months","2006-03-01","11 Years","7 Skill Level","2015-09-30","1 Dec - 31 Dec 15","Apr 16 - Mar 17","2016-03-01","Oct 11 - Sep 16","2016-11-01"]
["Navy Achievement",{"$nulls":22},2017,"17E8","2015-07-01","20 Months","2007-03-01","11 Years","7 Skill Level","2016-09-30","1 Dec - 31 Dec 16","Apr 17 - Mar 18","2017-03-01","Oct 12 - Sep 17","2017-11-01"]
["Aerial Achievement ",{"$nulls":22},2018,"18E8","2016-07-01","20 Months","2008-03-01","11 Years","7 Skill Level","2017-09-30","1 Dec - 31 Dec 17","Apr 18 - Mar 19","2018-03-01","Oct 13- Sep 18","2018-11-01"]
["AF Commendation",{"$nulls":22},2019,"19E8","2017-07-01","20 Months","2009-03-01","11 Years","7 Skill Level","2018-09-30","1 Dec - 31 Dec 18","Apr 19 - Mar 20","2019-03-01","Oct 14 - Sep 19","2019-11-01"]
["Air Medal",{"$nulls":22},2020,"20E8","2018-07-01","20 Months","2010-03-01","11 Years","7 Skill Level","2019-09-30","1 Dec - 31 Dec 19","Apr 20 - Mar 21","2020-03-01","Oct 15 - Sep 20","2020-11-01"]
["Army Commendation",{"$nulls":21},"E9Cycle",2008,"08E9","2007-03-01","21 Months","1995-12-01","14 Years","9 Skill Level","2008-07-31","1 Sep - 30 Sep 08","Jan 09 - Dec 09","2008-11-01","Aug 03 - Jul 08","2008-09-01"]
["Coast Guard Commendation",{"$nulls":22},2009,"09E9","2008-03-01","21 Months","1996-12-01","14 Years","9 Skill Level","2009-07-31","1 Sep - 30 Sep 09","Jan 10 - Dec 10","2009-11-01","Aug 04 - Jul 09","2009-09-01"]
["Joint Svc Commendation",{"$nulls":22},2010,"10E9","2009-03-01","21 Months","1997-12-01","14 Years","9 Skill Level","2010-07-31","1 Sep - 30 Sep 10","Jan 11 - Dec 11","2010-11-01","Aug 05 - Jul 10","2010-09-01"]
["Navy Commendation",{"$nulls":22},2011,"11E9","2010-03-01","21 Months","1998-12-01","14 Years","9 Skill Level","2011-07-31","1 Sep - 30 Sep 11","Jan 12 - Dec 12","2011-11-01","Aug 06 - Jul 11","2011-09-01"]
["Airman's  Medal",{"$nulls":22},2012,"12E9","2011-03-01","21 Months","1999-12-01","14 Years","9 Skill Level","2012-07-31","1 Sep - 30 Sep 12","Jan 13 - Dec 13","2012-11-01","Aug 07 - Jul 12","2012-09-01"]
["Bronze Star",{"$nulls":22},2013,"13E9","2012-03-01","21 Months","2000-12-01","14 Years","9 Skill Level","2013-07-31","1 Sep - 30 Sep 13","Jan 14 - Dec 14","2013-11-01","Aug 08 - Jul 13","2013-09-01"]
["Coast Guard Medal",{"$nulls":22},2014,"14E9","2013-03-01","21 Months","2001-12-01","14 Years","9 Skill Level","2014-07-31","1 Sep - 30 Sep 14","Jan 15 - Dec 15","2014-11-01","Aug 09 - Jul 14","2014-09-01"]
["Def. Meritorious Svc Medal",{"$nulls":22},2015,"15E9","2014-03-01","21 Months","2002-12-01","14 Years","9 Skill Level","2015-07-31","1 Sep - 30 Sep 15","Jan 16 - Dec 16","2015-11-01","Aug 10 - Jul 15","2015-09-01"]
["Navy-Marine Corps Medal",{"$nulls":22},2016,"16E9","2015-03-01","21 Months","2003-12-01","14 Years","9 Skill Level","2016-07-31","1 Sep - 30 Sep 16","Jan 17 - Dec 17","2016-11-01","Aug 11 - Jul 16","2016-09-01"]
["Purple Heart",{"$nulls":22},2017,"17E9","2016-03-01","21 Months","2004-12-01","14 Years","9 Skill Level","2017-07-31","1 Sep - 30 Sep 17","Jan 18 - Dec 18","2017-11-01","Aug 12 - Jul 17","2017-09-01"]
["Soldier's Medal",{"$nulls":22},2018,"18E9","2017-03-01","21 Months","2005-12-01","14 Years","9 Skill Level","2018-07-31","1 Sep - 30 Sep 18","Jan 19 - Dec 19","2018-11-01","Aug 13 - Jul 18","2018-09-01"]
["Def. Superior Svc Medal",{"$nulls":22},2019,"19E9","2018-03-01","21 Months","2006-12-01","14 Years","9 Skill Level","2019-07-31","1 Sep - 30 Sep 19","Jan 20 - Dec 20","2019-11-01","Aug 14 - Jul 19","2019-09-01"]
["Distinguished Flying Cross",{"$nulls":22},2020,"20E9","2019-03-01","21 Months","2007-12-01","14 Years","9 Skill Level","2020-07-31","1 Sep - 30 Sep 20","Jan 21 - Dec 21","2020-11-01","Aug 15 - Jul 20","2020-09-01"]
["Legion of Merit"]
["Def. Distinguished Svc Medal"]
["Distinguished Svc Medal"]
["Silver Star"]
["AF Cross"]
["Distinguished Svc Cross"]
["Navy Cross"]
["Medal of Honor"]

{"sheet":"Promo Rates","index":10,"n_rows":111,"n_cols":35,"rows_kept":111,"merged":[[1,5,3,14],[40,3,42,14],[48,0,48,3],[48,5,48,8],[48,10,48,13],[48,15,48,18],[48,20,48,23]]}
[]
[{"$nulls":5},{"$f":"\"\"&AA56&\" Yearly Promotion Rates\"","v":"MSgt Yearly Promotion Rates"}]
{"$rows_empty":38}
[{"$nulls":3},{"$f":"IF(AA55=1,\"WAPS testing was completed twice a year up to 1992 & again in 1995, the bar graph shows the average between the two.\",\"\")","v":""}]
{"$rows_empty":7}
["SSgt/E-5",{"$nulls":4},"TSgt/E-6",{"$nulls":4},"MSgt/E-7",{"$nulls":4},"SMSgt/E-8",{"$nulls":4},"CMSgt/E-9",{"$nulls":4},1,"E-5 Promotion Averages","SSgt",null,"E-5","E-6","E-7","E-8","E-9",{"$f":"OFFSET(AC49,0,$AA$55)","v":"E-7"}]
["CYCLE","CONSIDERED","SELECTED","%",null,"CYCLE","CONSIDERED","SELECTED","%",null,"CYCLE","CONSIDERED","SELECTED","%",null,"CYCLE","CONSIDERED","SELECTED","%",null,"CYCLE","CONSIDERED","SELECTED","%",null,2,"E-6 Promotion Averages","TSgt",1980,17.49,21.28,35.92,23.08,31.72,{"$f":"OFFSET(AC50,0,$AA$55)/100","v":{"v":0.3592,"d":"35.9%"}}]
["71A5",94882,17084,18.01,null,"71A6",89185,9391,10.53,null,"71A7",58114,6151,10.58,null,"71S8",27294,1339,4.91,null,"71S9",10695,687,6.42,null,3,"E-7 Promotion Averages","MSgt",1981,21.04,21.43,38.18,24.19,33.85,{"$f":"OFFSET(AC51,0,$AA$55)/100","v":{"v":0.3818,"d":"38.2%"}}]
["71B5",113001,33804,29.91,null,"71B6",96220,5079,5.28,null,"71B7",61197,3763,6.15,null,"72S8",30559,3401,11.13,null,"72S9",11824,1524,12.89,null,4,"E-8 Promotion Averages","SMSgt",1982,15.41,21.11,33.94,24.43,43.56,{"v":0.3394,"d":"33.9%"}]
["72A5",92430,21334,23.08,null,"72A6",94012,15057,16.02,null,"72A7",58712,8946,15.24,null,"73S8",30133,4818,15.99,null,"73S9",8975,1735,19.33,null,5,"E-9 Promotion Averages","CMSgt",1983,15,20.58,32.51,16.89,30.94,{"v":0.3251,"d":"32.5%"}]
["72B5",93975,20765,22.1,null,"72B6",84671,5262,6.21,null,"72B7",51516,1610,3.13,null,"74S8",30891,1793,5.8,null,"74S9",8238,664,8.06,{"$nulls":4},1984,14.85,15.49,28.25,15.35,17.79,{"v":0.2825,"d":"28.3%"}]
["73A5",94212,16210,17.21,null,"73A6",86991,8079,9.29,null,"73A7",52515,4862,"9,26",null,"75S8",28703,4350,15.16,null,"75S9",8338,1487,17.83,null,null,3,null,1985,15.3,18.12,29.28,12.8,22.64,{"v":0.2928,"d":"29.3%"}]
["73B5",82226,12982,15.79,null,"73B6",85152,3757,4.41,null,"74A7",56442,4276,7.58,null,"76S8",25909,3747,14.46,null,"76S9",6356,1218,19.16,null,null,{"$f":"VLOOKUP(AA55,Z49:AB53,3)","v":"MSgt"},null,1986,16.04,19.06,30.92,17.48,23.82,{"v":0.30920000000000003,"d":"30.9%"}]
["74A5",77986,7199,9.23,null,"74A6",88659,7064,7.97,null,"74B7",51729,4313,8.34,null,"77S8",24183,1899,7.85,null,"77S9",7027,833,11.85,{"$nulls":4},1987,14.6,19.19,32.2,15.2,19.3,{"v":0.322,"d":"32.2%"}]
["74B5",89020,15181,17.05,null,"74B6",87807,6883,7.84,null,"75A7",50516,4338,8.59,null,"78S8",20612,2808,13.62,null,"78S9",5733,1238,21.59,{"$nulls":4},1988,8.68,11.12,22.15,9.1,12.58,{"v":0.22149999999999997,"d":"22.2%"}]
["75A5",84706,6770,7.99,null,"75A6",85847,5227,6.09,null,"75B7",43085,4609,10.7,null,"79S8",14999,1869,12.46,null,"79S9",4578,819,17.89,{"$nulls":4},1989,10.36,11.24,18.87,5.62,13.14,{"v":0.1887,"d":"18.9%"}]
["75B5",78184,5976,7.64,null,"75B6",80503,6246,7.76,null,"76A7",42612,3065,7.19,null,"80S8",15216,3512,23.08,null,"80S9",3692,1171,31.72,{"$nulls":4},1990,8.8,11.86,20.31,8.76,13.55,{"v":0.20309999999999997,"d":"20.3%"}]
["76A5",84538,5821,6.89,null,"76A6",81986,5238,6.39,null,"76B7",41859,2621,6.26,null,"81S8",13995,3385,24.19,null,"81S9",3439,1164,33.85,{"$nulls":4},1991,8.08,12.16,19.53,8.69,13.77,{"v":0.1953,"d":"19.5%"}]
["76B5",77975,5020,6.44,null,"76B6",78383,4984,6.39,null,"77A7",41054,4324,10.53,null,"82S8",13136,3209,24.43,null,"82S9",2741,1194,43.56,{"$nulls":4},1992,5.67,14.33,19.56,7.23,11.85,{"v":0.1956,"d":"19.6%"}]
["77A5",83051,9799,11.8,null,"77A6",74881,4529,6.05,null,"77B7",39863,3648,9.15,null,"83S8",14501,2449,16.89,null,"83S9",3449,1067,30.94,{"$nulls":4},1993,16.35,11.32,19.23,6.17,9.38,{"v":0.1923,"d":"19.2%"}]
["77B5",85665,11658,13.61,null,"77B6",72779,4211,5.79,null,"78A7",38794,8385,21.61,null,"84S8",17135,2631,15.35,null,"84S9",4104,730,17.79,{"$nulls":4},1994,16.05,11.1,30.3,5.7,9.19,{"v":0.303,"d":"30.3%"}]
["78A5",85855,12163,14.17,null,"78A6",69822,11807,16.91,null,"79A7",30555,7433,24.33,null,"85S8",17963,2299,12.8,null,"84C9",5484,891,16.25,{"$nulls":4},1995,16.59,11.2,19.3,4.62,16.42,{"v":0.193,"d":"19.3%"}]
["78B5",79457,9828,12.37,null,"79A6",64691,11574,17.89,null,"80A7",27506,9881,35.92,null,"86S8",19202,3356,17.48,null,"85S9",5279,1195,22.64,{"$nulls":4},1996,16.59,11.2,19.47,7.31,19.42,{"v":0.19469999999999998,"d":"19.5%"}]
["79A5",78928,11420,14.47,null,"80A6",66002,14043,21.28,null,"81A7",25278,9651,38.18,null,"87S8",19077,2900,15.2,null,"86S9",5290,1260,23.82,{"$nulls":4},1997,18.66,15.13,21.62,7.56,18.1,{"v":0.2162,"d":"21.6%"}]
["79B5",73259,11330,15.47,null,"81A6",62399,13359,21.43,null,"82A7",23506,7978,33.94,null,"88S8",20693,1884,9.1,null,"87S9",4948,955,19.3,{"$nulls":4},1998,22.65,18.51,22.52,7.96,21.37,{"v":0.22519999999999998,"d":"22.5%"}]
["80A5",69161,12092,17.48,null,"82A6",62335,13159,21.11,null,"83A7",25940,8432,32.51,null,"89S8",22934,1290,5.62,null,"88S9",5793,729,12.58,{"$nulls":4},1999,36.39,24.4,29.7,7.98,17.58,{"v":0.297,"d":"29.7%"}]
["80B5",65637,11494,17.51,null,"83A6",65206,13418,20.58,null,"84A7",27565,7788,28.25,null,"90S8",25733,2255,8.76,null,"89S9",6201,815,13.14,{"$nulls":4},2000,50.72,27.65,39.11,7.89,14.21,{"v":0.3911,"d":"39.1%"}]
["81A5",67073,13276,19.79,null,"84A6",68870,10699,15.49,null,"85A7",29570,8658,29.28,null,"91S8",25399,2208,8.69,null,"90S9",5514,747,13.55,{"$nulls":4},2001,64.63,33.39,38.98,8.36,22.06,{"v":0.3898,"d":"39.0%"}]
["81B5",69617,15518,22.29,null,"85A6",74617,13519,18.12,null,"86A7",31120,9622,30.92,null,"92S8",23599,1706,7.23,null,"91S9",4590,632,13.77,{"$nulls":4},2002,62.98,33.51,33.23,10.09,19.93,{"v":0.3323,"d":"33.2%"}]
["82A5",67859,10856,15.6,null,"86A6",75646,14420,19.06,null,"87A7",29474,9520,32.2,null,"93S8",24343,1501,6.17,null,"92S9",4488,532,11.85,{"$nulls":4},2003,49.75,21.89,25.56,10.18,19.86,{"v":0.2556,"d":"25.6%"}]
["82B5",73143,11134,15.22,null,"87A6",75589,14506,19.19,null,"88A7",30372,6726,22.15,null,"94S8",24221,1380,5.7,null,"93S9",4711,442,9.38,{"$nulls":4},2004,40.91,21.57,25.95,9.48,21.06,{"v":0.2595,"d":"26.0%"}]
["83A5",74576,12529,16.8,null,"88A6",72108,8017,11.12,null,"89A7",34559,6521,18.87,null,"95S8",23827,1101,4.62,null,"94S9",4569,420,9.19,{"$nulls":4},2005,40.14,21.01,26.05,9.19,22.83,{"v":0.2605,"d":"26.1%"}]
["83B5",72982,9637,13.2,null,"89A6",84753,9524,11.24,null,"90A7",38827,7887,20.31,null,"95E8",22168,1605,7.24,null,"94E9",4195,503,11.99,{"$nulls":4},2006,35.87,16.76,19.86,8.63,16.85,{"v":0.1986,"d":"19.9%"}]
["84A5",77400,13024,16.83,null,"90A6",83028,9843,11.86,null,"91A7",35900,7011,19.53,null,"96E8",21139,1546,7.31,null,"95E9",3850,632,16.42,{"$nulls":4},2007,41.33,18.38,24.89,8.77,16.8,{"v":0.2489,"d":"24.9%"}]
["84B5",73991,9526,12.87,null,"91A6",81686,9932,12.16,null,"92A7",32338,6325,19.56,null,"97E8",21214,1603,7.56,null,"96E9",3197,621,19.42,{"$nulls":4},2008,43.45,18.55,22.31,8.91,21.53,{"v":0.2231,"d":"22.3%"}]
["85A5",74892,14771,19.72,null,"92A6",77147,11057,14.33,null,"93A7",32603,6268,19.23,null,"98E8",20439,1626,7.96,null,"97E9",2984,540,18.1]
["85B5",70425,7647,10.89,null,"93A6",77310,8748,11.32,null,"94A7",21125,6319,20.3,null,"99E8",18862,1506,7.98,null,"98E9",2864,612,21.37]
["86A5",83587,10854,12.99,null,"94A6",63168,7013,11.1,null,"95A7",30948,5997,19.3,null,"00E8",17812,1405,7.89,null,"99E9",2855,502,17.58]
["86B5",86530,16515,19.09,null,"95A6",56422,6320,11.2,null,"95E7",26833,5608,20.9,null,"01E8",16203,1354,8.36,null,"00E9",2935,417,14.21]
["87A5",83163,17856,21.47,null,"95E6","53624",6229,11.62,null,"96E7",24624,4794,19.47,null,"02E8",15307,1544,10.09,null,"01E9",2879,635,22.06]
["87B5",78694,6088,7.74,null,"96E6",54163,6068,11.2,null,"97E7",23233,5024,21.62,null,"03E8",15831,1612,10.18,null,"02E9",2815,561,19.93]
["88A5",82371,6742,8.18,null,"97E6",55114,8336,15.13,null,"98E7",21356,4810,22.52,null,"04E8","16,516","1566","9.48",null,"03E9","2649","526","19.86"]
["88B5",88495,8132,9.19,null,"98E6",53061,9.824,18.51,null,"99E7",19599,5827,29.7,null,"05E8","16708","1535","9.19",null,"04E9","2688","566","21.06"]
["89A5",84019,9028,10.75,null,"99E6",48092,11742,24.4,null,"00E7",19269,7536,39.11,null,"06E8","15107","1303","8.63",null,"05E9","2580","589","22.83"]
["89B5",91648,9133,9.97,null,"00E6",41414,11449,27.65,null,"01E7",18038,7031,38.98,null,"07E8","14626","1282","8.77",null,"06E9","2475","417","16.85"]
["90A5",94822,8543,9.01,null,"01E6",36095,12051,33.39,null,"02E7",19081,6340,33.23,null,"08E8","14404","1284","8.91",null,"07E9","2,476","416","16.80"]
["90B5",98206,8448,8.6,null,"02E6",34530,11571,33.51,null,"03E7",18903,4832,25.56,{"$nulls":6},"08E9",2415,520,{"$f":"W90/V90*100","v":{"v":21.532091097308488,"d":"21.53"}}]
["91A5",92028,7732,8.4,null,"03E6",32501,7116,21.89,null,"04E7","23956","6217","25.95"]
["91B5",88297,6853,7.76,null,"04E6","42248","9114","21.57",null,"05E7","25454","6630","26.05"]
["92A5",87657,4802,5.48,null,"05E6","43379","9116","21.01",null,"06E7","23230","4613","19.86"]
["92B5",85581,5027,5.87,null,"06E6","41186","6904","16.76",null,"07E7","24115","6002","24.89"]
["93A5",82758,13535,16.35,null,"07E6","39797","7314","18.38",null,"08E7 ",24223,5404,22.31]
["94A5",78212,12541,16.05,null,"08E6",38324,7110,18.55]
["95A5",72028,11953,16.59]
["95E5",63374,11548,18.22]
["96E5",57523,9541,16.59]
["97E5",52820,9854,18.66]
["98E5",48719,11033,22.65]
["99E5",44109,16053,36.39]
["00E5",38654,19605,50.72]
["01E5",32170,20793,64.63]
["02E5",30880,19448,62.98]
["03E5",27416,13651,49.79]
["04E5","33306","13625","40.91"]
["05E5","36405","14614","40.14"]
["06E5","37071","13298","35.87"]
["07E5","36608","15130","41.33"]
["08E5",28098,12209,43.45]

{"sheet":"Finance","index":11,"n_rows":190,"n_cols":21,"rows_kept":190,"merged":[[1,4,4,14],[4,2,4,3],[6,6,6,7],[6,8,6,9],[6,11,8,15],[7,1,9,1],[7,2,9,2],[8,6,8,7],[8,8,8,9],[9,11,9,12],[9,14,9,15],[10,11,10,12],[10,14,10,15],[11,6,11,7],[11,8,11,9],[11,11,11,12],[11,14,11,15],[14,6,14,7],[14,8,14,9],[14,11,14,12],[14,14,14,15],[16,6,16,7],[16,8,16,9],[16,11,16,15],[17,11,18,15],[18,6,18,7],[18,8,18,9],[19,11,20,11],[19,12,20,12],[19,13,20,13],[19,14,20,14],[19,15,20,15],[20,6,20,7],[20,8,20,9],[21,8,21,9],[22,6,22,7],[22,8,22,9],[25,1,26,1],[26,6,26,7],[26,8,26,9],[31,3,31,5],[31,6,31,7],[31,8,31,9],[32,3,32,9],[33,11,34,15],[34,3,34,7],[38,51,39,72],[40,51,40,72],[55,50,55,72],[56,51,56,72],[63,50,63,72],[64,51,64,72],[75,50,75,72],[164,15,164,16]]}
[]
[{"$nulls":4},"Calculate your pay!"]
[]
[]
[]
[]
[{"$nulls":6},"Monthly",null,"Annual",null,null,"Difference you will get paid if promoted"]
[null,"Basic Pay",null,{"$f":"VLOOKUP(C164,B136:C163,2)","v":0},{"$f":"VLOOKUP(H164,G166:H188,2)","v":0}]
[{"$nulls":6},{"$f":"IF(ISNA(INDEX(RANGE,MATCH(D8,INDEX(RANGE,,1),0),MATCH(E8,INDEX(RANGE,1,),0))),\"\",INDEX(RANGE,MATCH(D8,INDEX(RANGE,,1),0),MATCH(E8,INDEX(RANGE,1,),0)))","v":""},null,{"$f":"IF(ISERROR(G9*12),\"\",(G9*12))","v":""}]
[{"$nulls":11},"From:",null,null,"To:"]
[{"$nulls":11},{"$f":"VLOOKUP(K181,B136:C163,2)","v":0},null,null,{"$f":"VLOOKUP(K183,B136:C163,2)","v":0}]
[null,"Fly Pay",{"$nulls":4},{"$f":"IF(E165=1,\"\",VLOOKUP(E165,C166:E190,3))","v":""},null,{"$f":"IF(ISERROR(G12*12),\"\",(G12*12))","v":""},null,null,{"$f":"VLOOKUP(K182,G166:H188,2)","v":0},null,null,{"$f":"VLOOKUP(K184,G166:H188,2)","v":0}]
[]
[]
[null,"BAS",{"$nulls":4},{"$f":"IF(AND(K175=TRUE,L175=1),L176,IF(AND(K175=TRUE,L175=2),L177,\"\"))","v":""},null,{"$f":"IF(ISERROR(G15*12),\"\",(G15*12))","v":""},null,null,{"$f":"IF(ISNA(INDEX(RANGE,MATCH(L11,INDEX(RANGE,,1),0),MATCH(L12,INDEX(RANGE,1,),0))),\"\",INDEX(RANGE,MATCH(L11,INDEX(RANGE,,1),0),MATCH(L12,INDEX(RANGE,1,),0)))","v":""},null,null,{"$f":"IF(ISNA(INDEX(RANGE,MATCH(O11,INDEX(RANGE,,1),0),MATCH(O12,INDEX(RANGE,1,),0))),\"\",INDEX(RANGE,MATCH(O11,INDEX(RANGE,,1),0),MATCH(O12,INDEX(RANGE,1,),0)))","v":""}]
[{"$nulls":11},"Diff",{"$f":"O15-L15","v":{"$error":"#VALUE!"}}]
[null,"HDIP",1,false,null,{"$f":"VLOOKUP(C17,P166:Q178,2)","v":0},{"$f":"IF(D17=TRUE,150,\"\")","v":""},null,{"$f":"IF(ISERROR(IF(F17=0,G17,G17*F17)),\"\",(IF(F17=0,G17,G17*F17)))","v":""},null,null,{"$f":"IF(M16>1,\"You will receive a \"&M16&\" dollar pay raise!\",\"You will lose \"&M16&\" dollars!  Ouch!!!\")","v":{"$error":"#VALUE!"}}]
[{"$nulls":11},"Military Pay Prior Rates"]
[null,"HFP/IDP",1,null,false,{"$f":"VLOOKUP(C19,P166:Q178,2)","v":0},{"$f":"IF(E19=TRUE,225,\"\")","v":""},null,{"$f":"IF(ISERROR(IF(F19=0,G19,G19*F19)),\"\",(IF(F19=0,G19,G19*F19)))","v":""}]
[{"$nulls":11},"1949-1969 ","1970-1979 ","1980-1989 ","1990-1999 ","2000-2007 "]
[null,"FSA",1,null,false,{"$f":"VLOOKUP(C21,P166:Q178,2)","v":0},{"$f":"IF(E21=TRUE,250,\"\")","v":""},null,{"$f":"IF(ISERROR(IF(F21=0,G21,G21*F21)),\"\",IF(F21=0,G21,G21*F21))","v":""}]
[{"$nulls":11},"1949-10-01","1970-01-01","1980-10-01","1990-01-01","2000-01-01"]
[null,"Diving Pay",{"$nulls":4},{"$f":"IF(AND(K167=TRUE,K168=1),240,IF(AND(K167=TRUE,K168=2),340,\"\"))","v":""},null,{"$f":"IF(ISERROR(G23*12),\"\",(G23*12))","v":""},null,null,"1952-05-01","1971-01-01","1981-10-01","1991-01-01","2000-07-01"]
[{"$nulls":11},"1955-04-01","1971-10-01","1982-10-01","1992-01-01","2001-01-01"]
[{"$nulls":11},"1958-06-01","1972-01-01","1984-01-01","1993-01-01","2001-07-01"]
[null,"Clothing Allowance",{"$nulls":9},"1963-10-01","1972-10-01","1985-01-01","1994-01-01","2002-01-01"]
[{"$nulls":6},{"$f":"IF(AND(K172=TRUE,L172=1,M172=1),349.2,IF(AND(K172=TRUE,L172=1,M172=2),496.8,IF(AND(K172=TRUE,L172=2,M172=1),316.8,IF(AND(K172=TRUE,L172=2,M172=2),453.6,\"\"))))","v":""},null,{"$f":"G27","v":""},null,null,"1964-09-01","1973-10-01","1985-10-01","1995-01-01","2003-01-01"]
[{"$nulls":11},"1965-09-01","1974-10-01","1987-01-01","1996-01-01","2004-01-01"]
[{"$nulls":11},"1966-07-01","1975-10-01","1988-01-01","1997-01-01","2005-01-01"]
[{"$nulls":11},"1967-10-01","1976-10-01","1989-01-01","1998-01-01","2006-01-01"]
[{"$nulls":11},"1968-07-01","1977-10-01",null,"1999-01-01","2007-01-01"]
[{"$nulls":3},"Total",null,null,{"$f":"SUM(G9,G15,G12,G17,G19,G21,G23,G27)","v":0},null,{"$f":"SUM(I23,I15,I12,I9,I21,I19,I17,I27)","v":0},null,null,"1969-07-01","1978-10-01",null,null,"2007-04-01"]
[{"$nulls":3},"Does not compute taxes, BAH, per diem, etc.",{"$nulls":8},"1979-10-01"]
[{"$nulls":11},"Click here if the above links do not work"]
[{"$nulls":3},"Based on the 2009 Rates"]
{"$rows_empty":100}
[null,1,null,"< 2 ","Over 2 ","Over 3 ","Over 4 ","Over 6 ","Over 8 ","Over 10","Over 12 ","Over 14 ","Over 16 ","Over 18 ","Over 20","Over 22 ","Over 24 ","Over 26 ","Over 30","Over 34 ","Over 38 "]
[null,2,"O-10",{"$nulls":11},{"v":14618,"d":"$14,618"},{"v":14689,"d":"$14,689"},{"v":14995,"d":"$14,995"},{"v":15527,"d":"$15,527"},{"v":16303,"d":"$16,303"},{"v":17118,"d":"$17,118"},{"v":17974,"d":"$17,974"}]
[null,3,"O-9 ",{"$nulls":11},{"v":12785,"d":"$12,785"},{"v":12969,"d":"$12,969"},{"v":13235,"d":"$13,235"},{"v":13700,"d":"$13,700"},{"v":14385,"d":"$14,385"},{"v":15104,"d":"$15,104"},{"v":15859,"d":"$15,859"}]
[null,4,"O-8 ",{"v":9046,"d":"$9,046"},{"v":9342,"d":"$9,342"},{"v":9539,"d":"$9,539"},{"v":9594,"d":"$9,594"},{"v":9839,"d":"$9,839"},{"v":10249,"d":"$10,249"},{"v":10345,"d":"$10,345"},{"v":10734,"d":"$10,734"},{"v":10846,"d":"$10,846"},{"v":11181,"d":"$11,181"},{"v":11666,"d":"$11,666"},{"v":12114,"d":"$12,114"},{"v":12412,"d":"$12,412"},{"v":12412,"d":"$12,412"},{"v":12412,"d":"$12,412"},{"v":12723,"d":"$12,723"},{"v":13041,"d":"$13,041"},{"v":13041,"d":"$13,041"}]
[null,5,"O-7 ",{"v":7517,"d":"$7,517"},{"v":7866,"d":"$7,866"},{"v":8028,"d":"$8,028"},{"v":8156,"d":"$8,156"},{"v":8389,"d":"$8,389"},{"v":8618,"d":"$8,618"},{"v":8884,"d":"$8,884"},{"v":9149,"d":"$9,149"},{"v":9415,"d":"$9,415"},{"v":10249,"d":"$10,249"},{"v":10954,"d":"$10,954"},{"v":10955,"d":"$10,955"},{"v":10954,"d":"$10,954"},{"v":10954,"d":"$10,954"},{"v":11010,"d":"$11,010"},{"v":11230,"d":"$11,230"},{"v":11230,"d":"$11,230"},{"v":11230,"d":"$11,230"}]
[null,6,"O-6 ",{"v":5572,"d":"$5,572"},{"v":6121,"d":"$6,121"},{"v":6522,"d":"$6,522"},{"v":6522,"d":"$6,522"},{"v":6547,"d":"$6,547"},{"v":6828,"d":"$6,828"},{"v":6865,"d":"$6,865"},{"v":6865,"d":"$6,865"},{"v":7255,"d":"$7,255"},{"v":7945,"d":"$7,945"},{"v":8350,"d":"$8,350"},{"v":8754,"d":"$8,754"},{"v":8984,"d":"$8,984"},{"v":9218,"d":"$9,218"},{"v":9670,"d":"$9,670"},{"v":9863,"d":"$9,863"},{"v":9863,"d":"$9,863"},{"v":9863,"d":"$9,863"}]
[null,7,"O-5 ",{"v":4644,"d":"$4,644"},{"v":5232,"d":"$5,232"},{"v":5594,"d":"$5,594"},{"v":5662,"d":"$5,662"},{"v":5888,"d":"$5,888"},{"v":6024,"d":"$6,024"},{"v":6321,"d":"$6,321"},{"v":6539,"d":"$6,539"},{"v":6821,"d":"$6,821"},{"v":7252,"d":"$7,252"},{"v":7457,"d":"$7,457"},{"v":7660,"d":"$7,660"},{"v":7891,"d":"$7,891"},{"v":7891,"d":"$7,891"},{"v":7891,"d":"$7,891"},{"v":7891,"d":"$7,891"},{"v":7891,"d":"$7,891"},{"v":7891,"d":"$7,891"}]
[null,8,"O-4 ",{"v":4007,"d":"$4,007"},{"v":4639,"d":"$4,639"},{"v":4948,"d":"$4,948"},{"v":5017,"d":"$5,017"},{"v":5305,"d":"$5,305"},{"v":5613,"d":"$5,613"},{"v":5996,"d":"$5,996"},{"v":6295,"d":"$6,295"},{"v":6503,"d":"$6,503"},{"v":6622,"d":"$6,622"},{"v":6691,"d":"$6,691"},{"v":6691,"d":"$6,691"},{"v":6691,"d":"$6,691"},{"v":6691,"d":"$6,691"},{"v":6691,"d":"$6,691"},{"v":6691,"d":"$6,691"},{"v":6691,"d":"$6,691"},{"v":6691,"d":"$6,691"}]
[null,9,"O-3 ",{"v":3523,"d":"$3,523"},{"v":3994,"d":"$3,994"},{"v":4311,"d":"$4,311"},{"v":4700,"d":"$4,700"},{"v":4925,"d":"$4,925"},{"v":5172,"d":"$5,172"},{"v":5332,"d":"$5,332"},{"v":5595,"d":"$5,595"},{"v":5732,"d":"$5,732"},{"v":5732,"d":"$5,732"},{"v":5732,"d":"$5,732"},{"v":5732,"d":"$5,732"},{"v":5732,"d":"$5,732"},{"v":5732,"d":"$5,732"},{"v":5732,"d":"$5,732"},{"v":5732,"d":"$5,732"},{"v":5732,"d":"$5,732"},{"v":5732,"d":"$5,732"}]
[null,10,"O-2 ",{"v":3044,"d":"$3,044"},{"v":3467,"d":"$3,467"},{"v":3993,"d":"$3,993"},{"v":4128,"d":"$4,128"},{"v":4213,"d":"$4,213"},{"v":4213,"d":"$4,213"},{"v":4213,"d":"$4,213"},{"v":4213,"d":"$4,213"},{"v":4213,"d":"$4,213"},{"v":4213,"d":"$4,213"},{"v":4213,"d":"$4,213"},{"v":4213,"d":"$4,213"},{"v":4213,"d":"$4,213"},{"v":4213,"d":"$4,213"},{"v":4213,"d":"$4,213"},{"v":4213,"d":"$4,213"},{"v":4213,"d":"$4,213"},{"v":4213,"d":"$4,213"}]
[null,11,"O-1 ",{"v":2643,"d":"$2,643"},{"v":2750,"d":"$2,750"},{"v":3325,"d":"$3,325"},{"v":3325,"d":"$3,325"},{"v":3325,"d":"$3,325"},{"v":3325,"d":"$3,325"},{"v":3325,"d":"$3,325"},{"v":3325,"d":"$3,325"},{"v":3325,"d":"$3,325"},{"v":3325,"d":"$3,325"},{"v":3325,"d":"$3,325"},{"v":3325,"d":"$3,325"},{"v":3325,"d":"$3,325"},{"v":3325,"d":"$3,325"},{"v":3325,"d":"$3,325"},{"v":3325,"d":"$3,325"},{"v":3325,"d":"$3,325"},{"v":3325,"d":"$3,325"}]
[null,12,"O-3E",{"$nulls":3},{"v":4700,"d":"$4,700"},{"v":4925,"d":"$4,925"},{"v":5172,"d":"$5,172"},{"v":5332,"d":"$5,332"},{"v":5595,"d":"$5,595"},{"v":5817,"d":"$5,817"},{"v":5944,"d":"$5,944"},{"v":6117,"d":"$6,117"},{"v":6117,"d":"$6,117"},{"v":6117,"d":"$6,117"},{"v":6117,"d":"$6,117"},{"v":6117,"d":"$6,117"},{"v":6117,"d":"$6,117"},{"v":6117,"d":"$6,117"},{"v":6117,"d":"$6,117"}]
[null,13,"O-2E",{"$nulls":3},{"v":4128,"d":"$4,128"},{"v":4213,"d":"$4,213"},{"v":4347,"d":"$4,347"},{"v":4573,"d":"$4,573"},{"v":4748,"d":"$4,748"},{"v":4879,"d":"$4,879"},{"v":4879,"d":"$4,879"},{"v":4879,"d":"$4,879"},{"v":4879,"d":"$4,879"},{"v":4879,"d":"$4,879"},{"v":4879,"d":"$4,879"},{"v":4879,"d":"$4,879"},{"v":4879,"d":"$4,879"},{"v":4879,"d":"$4,879"},{"v":4879,"d":"$4,879"}]
[null,14,"O-1E",{"$nulls":3},{"v":3325,"d":"$3,325"},{"v":3551,"d":"$3,551"},{"v":3682,"d":"$3,682"},{"v":3816,"d":"$3,816"},{"v":3948,"d":"$3,948"},{"v":4128,"d":"$4,128"},{"v":4128,"d":"$4,128"},{"v":4128,"d":"$4,128"},{"v":4128,"d":"$4,128"},{"v":4128,"d":"$4,128"},{"v":4128,"d":"$4,128"},{"v":4128,"d":"$4,128"},{"v":4128,"d":"$4,128"},{"v":4128,"d":"$4,128"},{"v":4128,"d":"$4,128"}]
[null,15,"W-5 ",{"$nulls":11},{"v":6500,"d":"$6,500"},{"v":6803,"d":"$6,803"},{"v":7047,"d":"$7,047"},{"v":7318,"d":"$7,318"},{"v":7684,"d":"$7,684"},{"v":8068,"d":"$8,068"},{"v":8472,"d":"$8,472"}]
[null,16,"W-4 ",{"v":3641,"d":"$3,641"},{"v":3917,"d":"$3,917"},{"v":4029,"d":"$4,029"},{"v":4140,"d":"$4,140"},{"v":4330,"d":"$4,330"},{"v":4519,"d":"$4,519"},{"v":4710,"d":"$4,710"},{"v":4997,"d":"$4,997"},{"v":5249,"d":"$5,249"},{"v":5488,"d":"$5,488"},{"v":5684,"d":"$5,684"},{"v":5875,"d":"$5,875"},{"v":6156,"d":"$6,156"},{"v":6386,"d":"$6,386"},{"v":6650,"d":"$6,650"},{"v":6783,"d":"$6,783"},{"v":6783,"d":"$6,783"},{"v":6783,"d":"$6,783"}]
[null,17,"W-3 ",{"v":3325,"d":"$3,325"},{"v":3464,"d":"$3,464"},{"v":3605,"d":"$3,605"},{"v":3652,"d":"$3,652"},{"v":3801,"d":"$3,801"},{"v":4094,"d":"$4,094"},{"v":4399,"d":"$4,399"},{"v":4543,"d":"$4,543"},{"v":4709,"d":"$4,709"},{"v":4880,"d":"$4,880"},{"v":5188,"d":"$5,188"},{"v":5396,"d":"$5,396"},{"v":5521,"d":"$5,521"},{"v":5653,"d":"$5,653"},{"v":5833,"d":"$5,833"},{"v":5833,"d":"$5,833"},{"v":5833,"d":"$5,833"},{"v":5833,"d":"$5,833"}]
[null,18,"W-2 ",{"v":2942,"d":"$2,942"},{"v":3221,"d":"$3,221"},{"v":3306,"d":"$3,306"},{"v":3365,"d":"$3,365"},{"v":3556,"d":"$3,556"},{"v":3853,"d":"$3,853"},{"v":3999,"d":"$3,999"},{"v":4144,"d":"$4,144"},{"v":4321,"d":"$4,321"},{"v":4459,"d":"$4,459"},{"v":4585,"d":"$4,585"},{"v":4734,"d":"$4,734"},{"v":4833,"d":"$4,833"},{"v":4912,"d":"$4,912"},{"v":4912,"d":"$4,912"},{"v":4912,"d":"$4,912"},{"v":4912,"d":"$4,912"},{"v":4912,"d":"$4,912"}]
[null,19,"W-1 ",{"v":2583,"d":"$2,583"},{"v":2860,"d":"$2,860"},{"v":2935,"d":"$2,935"},{"v":3093,"d":"$3,093"},{"v":3280,"d":"$3,280"},{"v":3555,"d":"$3,555"},{"v":3684,"d":"$3,684"},{"v":3864,"d":"$3,864"},{"v":4040,"d":"$4,040"},{"v":4179,"d":"$4,179"},{"v":4307,"d":"$4,307"},{"v":4463,"d":"$4,463"},{"v":4463,"d":"$4,463"},{"v":4463,"d":"$4,463"},{"v":4463,"d":"$4,463"},{"v":4463,"d":"$4,463"},{"v":4463,"d":"$4,463"},{"v":4463,"d":"$4,463"}]
[null,20,"E-9",{"$nulls":6},{"v":4399,"d":"$4,399"},{"v":4499,"d":"$4,499"},{"v":4625,"d":"$4,625"},{"v":4773,"d":"$4,773"},{"v":4921,"d":"$4,921"},{"v":5160,"d":"$5,160"},{"v":5362,"d":"$5,362"},{"v":5575,"d":"$5,575"},{"v":5900,"d":"$5,900"},{"v":6195,"d":"$6,195"},{"v":6505,"d":"$6,505"},{"v":6830,"d":"$6,830"}]
[null,21,"E-8 ",{"$nulls":5},{"v":3601,"d":"$3,601"},{"v":3761,"d":"$3,761"},{"v":3859,"d":"$3,859"},{"v":3977,"d":"$3,977"},{"v":4105,"d":"$4,105"},{"v":4336,"d":"$4,336"},{"v":4453,"d":"$4,453"},{"v":4652,"d":"$4,652"},{"v":4763,"d":"$4,763"},{"v":5035,"d":"$5,035"},{"v":5136,"d":"$5,136"},{"v":5136,"d":"$5,136"},{"v":5136,"d":"$5,136"}]
[null,22,"E-7 ",{"v":2503,"d":"$2,503"},{"v":2732,"d":"$2,732"},{"v":2837,"d":"$2,837"},{"v":2976,"d":"$2,976"},{"v":3084,"d":"$3,084"},{"v":3270,"d":"$3,270"},{"v":3374,"d":"$3,374"},{"v":3560,"d":"$3,560"},{"v":3715,"d":"$3,715"},{"v":3820,"d":"$3,820"},{"v":3932,"d":"$3,932"},{"v":3976,"d":"$3,976"},{"v":4122,"d":"$4,122"},{"v":4201,"d":"$4,201"},{"v":4499,"d":"$4,499"},{"v":4499,"d":"$4,499"},{"v":4499,"d":"$4,499"},{"v":4499,"d":"$4,499"}]
[null,23,"E-6 ",{"v":2165,"d":"$2,165"},{"v":2382,"d":"$2,382"},{"v":2488,"d":"$2,488"},{"v":2590,"d":"$2,590"},{"v":2696,"d":"$2,696"},{"v":2937,"d":"$2,937"},{"v":3030,"d":"$3,030"},{"v":3211,"d":"$3,211"},{"v":3266,"d":"$3,266"},{"v":3307,"d":"$3,307"},{"v":3353,"d":"$3,353"},{"v":3353,"d":"$3,353"},{"v":3353,"d":"$3,353"},{"v":3353,"d":"$3,353"},{"v":3353,"d":"$3,353"},{"v":3353,"d":"$3,353"},{"v":3353,"d":"$3,353"},{"v":3353,"d":"$3,353"}]
[null,24,"E-5 ",{"v":1984,"d":"$1,984"},{"v":2117,"d":"$2,117"},{"v":2219,"d":"$2,219"},{"v":2324,"d":"$2,324"},{"v":2487,"d":"$2,487"},{"v":2658,"d":"$2,658"},{"v":2797,"d":"$2,797"},{"v":2815,"d":"$2,815"},{"v":2815,"d":"$2,815"},{"v":2815,"d":"$2,815"},{"v":2815,"d":"$2,815"},{"v":2815,"d":"$2,815"},{"v":2815,"d":"$2,815"},{"v":2815,"d":"$2,815"},{"v":2815,"d":"$2,815"},{"v":2815,"d":"$2,815"},{"v":2815,"d":"$2,815"},{"v":2815,"d":"$2,815"}]
[null,25,"E-4 ",{"v":1819,"d":"$1,819"},{"v":1912,"d":"$1,912"},{"v":2015,"d":"$2,015"},{"v":2117,"d":"$2,117"},{"v":2208,"d":"$2,208"},{"v":2208,"d":"$2,208"},{"v":2208,"d":"$2,208"},{"v":2208,"d":"$2,208"},{"v":2208,"d":"$2,208"},{"v":2208,"d":"$2,208"},{"v":2208,"d":"$2,208"},{"v":2208,"d":"$2,208"},{"v":2208,"d":"$2,208"},{"v":2208,"d":"$2,208"},{"v":2208,"d":"$2,208"},{"v":2208,"d":"$2,208"},{"v":2208,"d":"$2,208"},{"v":2208,"d":"$2,208"}]
[null,26,"E-3 ",{"v":1642,"d":"$1,642"},{"v":1745,"d":"$1,745"},{"v":1851,"d":"$1,851"},{"v":1851,"d":"$1,851"},{"v":1851,"d":"$1,851"},{"v":1851,"d":"$1,851"},{"v":1851,"d":"$1,851"},{"v":1851,"d":"$1,851"},{"v":1851,"d":"$1,851"},{"v":1851,"d":"$1,851"},{"v":1851,"d":"$1,851"},{"v":1851,"d":"$1,851"},{"v":1851,"d":"$1,851"},{"v":1851,"d":"$1,851"},{"v":1851,"d":"$1,851"},{"v":1851,"d":"$1,851"},{"v":1851,"d":"$1,851"},{"v":1851,"d":"$1,851"}]
[null,27,"E-2 ",{"v":1561,"d":"$1,561"},{"v":1561,"d":"$1,561"},{"v":1561,"d":"$1,561"},{"v":1561,"d":"$1,561"},{"v":1561,"d":"$1,561"},{"v":1561,"d":"$1,561"},{"v":1561,"d":"$1,561"},{"v":1561,"d":"$1,561"},{"v":1561,"d":"$1,561"},{"v":1561,"d":"$1,561"},{"v":1561,"d":"$1,561"},{"v":1561,"d":"$1,561"},{"v":1561,"d":"$1,561"},{"v":1561,"d":"$1,561"},{"v":1561,"d":"$1,561"},{"v":1561,"d":"$1,561"},{"v":1561,"d":"$1,561"},{"v":1561,"d":"$1,561"}]
[null,28,"E-1",{"v":1393,"d":"$1,393"},{"v":1393,"d":"$1,393"},{"v":1393,"d":"$1,393"},{"v":1393,"d":"$1,393"},{"v":1393,"d":"$1,393"},{"v":1393,"d":"$1,393"},{"v":1393,"d":"$1,393"},{"v":1393,"d":"$1,393"},{"v":1393,"d":"$1,393"},{"v":1393,"d":"$1,393"},{"v":1393,"d":"$1,393"},{"v":1393,"d":"$1,393"},{"v":1393,"d":"$1,393"},{"v":1393,"d":"$1,393"},{"v":1393,"d":"$1,393"}]
[null,null,1,"<Cell link for Basic Pay Form Control",{"$nulls":3},1,"<Cell Link for Years in Base pay"]
[{"$nulls":3},"Pay Grade",1,{"$nulls":10},"Special Pay lookup"]
[null,null,1,{"$nulls":3},1,{"$nulls":3},"Dive Pay Info",{"$nulls":4},1,0]
[null,null,2,"O-10",150,null,2,"< 2 ",null,null,false,{"$nulls":4},2,1]
[null,null,3,"O-9",150,null,3,"Over 2 ",null,null,2,{"$nulls":4},3,2]
[null,null,4,"O-8",150,null,4,"Over 3 ",{"$nulls":7},4,3]
[null,null,5,"O-7",150,null,5,"Over 4 ",{"$nulls":7},5,4]
[null,null,6,"O-6",250,null,6,"Over 6 ",null,null,"Clothing","Gender","Rate","Form",null,6,5]
[null,null,7,"O-5",250,null,7,"Over 8 ",null,null,false,2,2,null,null,7,6]
[null,null,8,"O-4",225,null,8,"Over 10",{"$nulls":7},8,7]
[null,null,9,"O-3",175,null,9,"Over 12 ",null,null,"BAS",{"$nulls":4},9,8]
[null,null,10,"O-2",150,null,10,"Over 14 ",null,null,false,2,{"$nulls":3},10,9]
[null,null,11,"O-1",150,null,11,"Over 16 ",null,null,"O's",202.76,{"$nulls":3},11,10]
[null,null,12,"W-5",250,null,12,"Over 18 ",null,null,"E's",294.43,{"$nulls":3},12,11]
[null,null,13,"W-4",250,null,13,"Over 20",{"$nulls":7},13,12]
[null,null,14,"W-3",175,null,14,"Over 22 "]
[null,null,15,"W-2",150,null,15,"Over 24 ",null,null,"Pay Diff Box"]
[null,null,16,"W-1",150,null,16,"Over 26 ",null,null,1,"1st Box Rank"]
[null,null,17,"E-9",240,null,17,"Over 30",null,null,1,"1st Box Years"]
[null,null,18,"E-8",240,null,18,"Over 34 ",null,null,1,"2nd Box Rank"]
[null,null,19,"E-7",240,null,19,"Over 38 ",null,null,1,"2nd Box Years"]
[null,null,20,"E-6",215,null,20]
[null,null,21,"E-5",190,null,21]
[null,null,22,"E-4",165,null,22]
[null,null,23,"E-3",150,null,23]
[null,null,24,"E-2",150]
[null,null,25,"E-1",150]

{"sheet":"Macros","index":12,"n_rows":94,"n_cols":12,"rows_kept":94,"merged":[[4,2,8,9],[4,11,5,15],[12,2,23,9],[27,2,31,9],[54,2,56,9],[80,1,80,5],[80,6,80,9],[82,1,86,7],[94,1,94,3]]}
[]
[]
[]
[null,"What are Macros?"]
[null,null,"Macros in a nutshell is Visual Basic code an author creates to trigger specific events that are not included in Excel's standard functions.  For example, to utilize the clear and start over macro I had to write the code for this because Excel does not have a built in feature on the ribbon to clear specific cells that I specify.",{"$nulls":8},"Example of a Compile Error"]
[]
[]
[]
[]
[]
[null,"What are the disadvantages to using Macros?"]
[]
[null,null,"The author could write bad code and a message compile error could display.  This is a result of misspelling code, not knowing how to write code correctly, or writing code to trigger events not related to the specific event.  If you ever are confronted with this error, the best course of action is to write down the error, close the worksheet and contact the author with the error so he/she can fix it.\n\nA few people will warn you not to use Macros from untrusted publishers because they think we will write code to crash your machine.  If the author of a spreadsheet is leaving his/her contact info, chances are they have not written code to do so.  Plus, it would be stupid of me to write bad code and pass it out to the entire Air Force to see!"]
{"$rows_empty":12}
[null,"How to enable Macros"]
[]
[null,null,"Immediately upon opening your workbook you should see the security warning displayed below.  This will show if macros are detected but Excel will not automatically enable them.  Click the options button and in the next window, select the 'Enable this content' radio button and select ok.  Macros are now enabled and you will have full use of this spreadsheet. "]
{"$rows_empty":24}
[null,"How to enable Macros without seeing the Security Warning message"]
[]
[null,null,"Select the office button           and select Excel Options to the bottom right.  Select Trust Center and then Macro Settings.  Select Enable all Macros and select ok."]
{"$rows_empty":25}
[null,"For more information regarding macros, please visit:"]
[]
[null,"You can use the WAPS calculator without enabling macros, the calculations will still work correctly.  However, other functions will not work which might be helpful when interacting with WAPS calculator."]
[]
[]
[]
[]
[]
[]
[null,"Contact me to report any errors with this workbook."]
[]
[null,"SSgt Chuck Lane"]
[null,"DSN 576-4289"]
[null,"Scott AFB"]