{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Drill Pay Review","Suggested Actions","Visual Representation"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Drill Pay Review","index":0,"n_rows":32,"n_cols":21,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,6,0,7],[0,0,0,1],[0,2,0,5],[0,8,0,12]]}
["CLAIM INFO",null,"REVIEW OF ALL 21-8951'S",null,null,null,"FISCAL YEAR ",null,"ACTIVE DUTY INFORMATION"]
["PENDING DRILL PAY CLAIM","DATE OF CLAIM","FISCAL YEAR FROM 21-8951","NUMBER OF DAYS ON         21-8951","HAS THE  21- 8951 BEEN SIGNED?","HAS THE ADJUSTMENT BEEN COMPLETED FOR THIS FISCAL YEAR?","FISCAL YEAR BEGIN DATE","FISCAL YEAR END DATE","WAS THERE ACTIVE DUTY DURING THIS FISCAL YEAR?","DID WE PAY COMPENSATION DURING THIS PERIOD OF ACTIVE DUTY?","EOD","RAD","# AD Days","NUMBER OF ACTIVE DUTY DAYS IN THIS FISCAL YEAR","TOTAL NUMBER OF DRILL DAYS TO ADJUST FOR"]
[null,null,null,null,null,null,{"$f":"IF(C3>0,\"10/1/\"&(C3-1),\" \")","v":" "},{"$f":"IF(C3>0,\"9/30/\"&C3,\" \")","v":" "},null,null,null,null,{"$f":"IF(K3=0*AND(L3=0),0,SUM((L3-K3)+1))","v":0},{"$f":"IF(K3=0*AND(L3=0),0,IF(K3<=DATEVALUE(G3),SUM((L3-DATEVALUE(G3))+1),IF(L3>=DATEVALUE(H3),SUM((DATEVALUE(H3)-K3)+1),SUM((L3-K3)+1))))","v":0},{"$f":"IF(F3=\"YES\",\"N/A \",IF((D3-N3)<1,0,(D3-N3)))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(C4>0,\"10/1/\"&(C4-1),\" \")","v":" "}," ",null,null,null,null,{"$f":"IF(K4=0*AND(L4=0),0,SUM((L4-K4)+1))","v":0},0,{"$f":"IF(F4=\"YES\",\"N/A \",IF((D4-N4)<1,0,(D4-N4)))","v":0}]
[null,null,null,null,null,null," "," ",null,null,null,null,0,0,0]
[null,null,null,null,null,null," "," ",null,null,null,null,0,0,0]
[null,null,null,null,null,null," "," ",null,null,null,null,0,0,0]
[null,null,null,null,null,null," "," ",null,null,null,null,0,0,0]
[null,null,null,null,null,null," "," ",null,null,null,null,0,0,0]
[null,null,null,null,null,null," "," ",null,null,null,null,0,0,0]
[null,null,null,null,null,null," "," ",null,null,null,null,0,0,0]
[null,null,null,null,null,null," "," ",null,null,null,null,0,0,0]
[null,null,null,null,null,null," "," ",null,null,null,null,0,0,0]
[null,null,null,null,null,null," "," ",null,null,null,null,0,0,0]
[null,null,null,null,null,null," "," ",null,null,null,null,0,0,0]
[null,null,null,null,null,null," "," ",null,null,null,null,0,0,0]
[null,null,null,null,null,null," "," ",null,null,null,null,0,0,0]
[null,null,null,null,null,null," "," ",null,null,null,null,0,0,0]
[null,null,null,null,null,null," "," ",null,null,null,null,0,0,0]
[null,null,null,null,null,null," "," ",null,null,null,null,0,0,0]
[null,null,null,null,null,null," "," ",null,null,null,null,0,0,0]
[]
[null,null,null,null,null,null,null,"WITHHOLDING CALULATOR FOR VBMS"]
[null,null,null,null,null,"FY to Withhold","# Drill Days","Gross Pay 1st Day of W/holding","Amt to Withold","Net pay","Date to Start Witholding ","Date to Stop Witholding "]
[null,null,null,null,null,{"$f":"IF(C3>0, C3,\"\")","v":""},{"$f":"IF(O3>0,O3,0)","v":0},null,null,{"$f":"H25-I25","v":0},null,{"$f":"IF(ISBLANK(K25),\"\",DATE(YEAR(N25),P25,U25))","v":""},null,{"$f":"EDATE(K25,QUOTIENT(G25,30))","v":"00:00:00"},{"$f":"DAY(K25)+(G25-QUOTIENT(G25,30)*30)","v":0},{"$f":"IF(O25>30,MONTH(N25)+1,MONTH(N25))","v":1},{"$f":"IF(O25>30,(O25-30),O25)","v":0},{"$f":"MONTH(N25)","v":1},{"$f":"IF(OR(MOD(YEAR(N25),400)=0,AND(MOD(YEAR(N25),4)=0,MOD(YEAR(N25),100)<>0)),1,0)","v":0},{"$f":"IF(MONTH(N25)=2,1,0)","v":0},{"$f":"IF(S25=0,IF(T25=1,IF(Q25=30,29,Q25),Q25),Q25)","v":0}]
[null,null,null,null,null,"",0,null,null,{"$f":"H26-I26","v":0},null,{"$f":"IF(ISBLANK(K26),\"\",DATE(YEAR(N26),P26,U26))","v":""},null,{"$f":"EDATE(K26,QUOTIENT(G26,30))","v":"00:00:00"},{"$f":"DAY(K26)+(G26-QUOTIENT(G26,30)*30)","v":0},{"$f":"IF(O26>30,MONTH(N26)+1,MONTH(N26))","v":1},{"$f":"IF(O26>30,(O26-30),O26)","v":0},{"$f":"MONTH(N26)","v":1},{"$f":"IF(OR(MOD(YEAR(N26),400)=0,AND(MOD(YEAR(N26),4)=0,MOD(YEAR(N26),100)<>0)),1,0)","v":0},{"$f":"IF(MONTH(N26)=2,1,0)","v":0},{"$f":"IF(S26=0,IF(T26=1,IF(Q26=30,29,Q26),Q26),Q26)","v":0}]
[null,null,null,null,null,"",0,null,null,0,null,"",null,"00:00:00",0,1,0,1,0,0,0]
[null,null,null,null,null,"",0,null,null,0,null,"",null,"00:00:00",0,1,0,1,0,0,0]
[null,null,null,null,null,"",0,null,null,0,null,"",null,"00:00:00",0,1,0,1,0,0,0]
[null,null,null,null,null,"",0,null,null,0,null,"",null,"00:00:00",0,1,0,1,0,0,0]
[null,null,null,null,null,"",0,null,null,0,null,"",null,"00:00:00",0,1,0,1,0,0,0]
[null,null,null,null,null,"",0,null,null,0,null,"",null,"00:00:00",0,1,0,1,0,0,0]

{"sheet":"Suggested Actions","index":1,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["FY ","Action Needed On Drill Pay","Action To Take For Drill Pay","Action Needed On AD Period","Over 179 Day Autotext?"]
[{"$f":"IF('Drill Pay Review'!C3>0,'Drill Pay Review'!C3,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!F3=\"YES\",\"No Action Needed\",IF('Drill Pay Review'!E3=0*AND('Drill Pay Review'!F3=0),\" \",IF('Drill Pay Review'!E3=\"YES\",\"Work Under 290 EP\",IF('Suggested Actions'!C2=\"No Drill Pay Adjustment Required\",\"No Action Needed\",\"Issue Due Process\"))))","v":" "},{"$f":"IF('Drill Pay Review'!C3=0*AND('Drill Pay Review'!O3=0),\" \",IF('Drill Pay Review'!O3<1,\"No Drill Pay Adjustment Required\",\"Adjust for \"&'Drill Pay Review'!O3&\" Drill Pay Days \"))","v":" "},{"$f":"IF('Drill Pay Review'!J3=\"YES\",\"Issue Due Process For  Period Of Active Duty\",IF('Drill Pay Review'!J3=\"NO\",\"NONE\",IF('Drill Pay Review'!M3=0,\" \",\" \")))","v":" "},{"$f":"IF(('Drill Pay Review'!D3<179)*AND('Drill Pay Review'!I3=\"NO\"),\"NO\",IF('Drill Pay Review'!D3>=179,\"Check DPRIS Or VIS For Active Duty; If Not Found Add The Over 179 Day Autotext To The Letter\",\" \"))","v":" "}]
[{"$f":"IF('Drill Pay Review'!C4>0,'Drill Pay Review'!C4,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!F4=\"YES\",\"No Action Needed\",IF('Drill Pay Review'!E4=0*AND('Drill Pay Review'!F4=0),\" \",IF('Drill Pay Review'!E4=\"YES\",\"Work Under 290 EP\",IF('Suggested Actions'!C3=\"No Drill Pay Adjustment Required\",\"No Action Needed\",\"Issue Due Process\"))))","v":" "},{"$f":"IF('Drill Pay Review'!C4=0*AND('Drill Pay Review'!O4=0),\" \",IF('Drill Pay Review'!O4<1,\"No Drill Pay Adjustment Required\",\"Adjust for \"&'Drill Pay Review'!O4&\" Drill Pay Days \"))","v":" "},{"$f":"IF('Drill Pay Review'!J4=\"YES\",\"Issue Due Process For  Period Of Active Duty\",IF('Drill Pay Review'!J4=\"NO\",\"NONE\",IF('Drill Pay Review'!M4=0,\" \",\" \")))","v":" "},{"$f":"IF(('Drill Pay Review'!D4<179)*AND('Drill Pay Review'!I4=\"NO\"),\"NO\",IF('Drill Pay Review'!D4>=179,\"Check DPRIS Or VIS For Active Duty; If Not Found Add The Over 179 Day Autotext To The Letter\",\" \"))","v":" "}]
[{"$f":"IF('Drill Pay Review'!C5>0,'Drill Pay Review'!C5,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!F5=\"YES\",\"No Action Needed\",IF('Drill Pay Review'!E5=0*AND('Drill Pay Review'!F5=0),\" \",IF('Drill Pay Review'!E5=\"YES\",\"Work Under 290 EP\",IF('Suggested Actions'!C4=\"No Drill Pay Adjustment Required\",\"No Action Needed\",\"Issue Due Process\"))))","v":" "},{"$f":"IF('Drill Pay Review'!C5=0*AND('Drill Pay Review'!O5=0),\" \",IF('Drill Pay Review'!O5<1,\"No Drill Pay Adjustment Required\",\"Adjust for \"&'Drill Pay Review'!O5&\" Drill Pay Days \"))","v":" "},{"$f":"IF('Drill Pay Review'!J5=\"YES\",\"Issue Due Process For  Period Of Active Duty\",IF('Drill Pay Review'!J5=\"NO\",\"NONE\",IF('Drill Pay Review'!M5=0,\" \",\" \")))","v":" "},{"$f":"IF(('Drill Pay Review'!D5<179)*AND('Drill Pay Review'!I5=\"NO\"),\"NO\",IF('Drill Pay Review'!D5>=179,\"Check DPRIS Or VIS For Active Duty; If Not Found Add The Over 179 Day Autotext To The Letter\",\" \"))","v":" "}]
[{"$f":"IF('Drill Pay Review'!C6>0,'Drill Pay Review'!C6,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!F6=\"YES\",\"No Action Needed\",IF('Drill Pay Review'!E6=0*AND('Drill Pay Review'!F6=0),\" \",IF('Drill Pay Review'!E6=\"YES\",\"Work Under 290 EP\",IF('Suggested Actions'!C5=\"No Drill Pay Adjustment Required\",\"No Action Needed\",\"Issue Due Process\"))))","v":" "},{"$f":"IF('Drill Pay Review'!C6=0*AND('Drill Pay Review'!O6=0),\" \",IF('Drill Pay Review'!O6<1,\"No Drill Pay Adjustment Required\",\"Adjust for \"&'Drill Pay Review'!O6&\" Drill Pay Days \"))","v":" "},{"$f":"IF('Drill Pay Review'!J6=\"YES\",\"Issue Due Process For  Period Of Active Duty\",IF('Drill Pay Review'!J6=\"NO\",\"NONE\",IF('Drill Pay Review'!M6=0,\" \",\" \")))","v":" "},{"$f":"IF(('Drill Pay Review'!D6<179)*AND('Drill Pay Review'!I6=\"NO\"),\"NO\",IF('Drill Pay Review'!D6>=179,\"Check DPRIS Or VIS For Active Duty; If Not Found Add The Over 179 Day Autotext To The Letter\",\" \"))","v":" "}]
[{"$f":"IF('Drill Pay Review'!C7>0,'Drill Pay Review'!C7,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!F7=\"YES\",\"No Action Needed\",IF('Drill Pay Review'!E7=0*AND('Drill Pay Review'!F7=0),\" \",IF('Drill Pay Review'!E7=\"YES\",\"Work Under 290 EP\",IF('Suggested Actions'!C6=\"No Drill Pay Adjustment Required\",\"No Action Needed\",\"Issue Due Process\"))))","v":" "},{"$f":"IF('Drill Pay Review'!C7=0*AND('Drill Pay Review'!O7=0),\" \",IF('Drill Pay Review'!O7<1,\"No Drill Pay Adjustment Required\",\"Adjust for \"&'Drill Pay Review'!O7&\" Drill Pay Days \"))","v":" "},{"$f":"IF('Drill Pay Review'!J7=\"YES\",\"Issue Due Process For  Period Of Active Duty\",IF('Drill Pay Review'!J7=\"NO\",\"NONE\",IF('Drill Pay Review'!M7=0,\" \",\" \")))","v":" "},{"$f":"IF(('Drill Pay Review'!D7<179)*AND('Drill Pay Review'!I7=\"NO\"),\"NO\",IF('Drill Pay Review'!D7>=179,\"Check DPRIS Or VIS For Active Duty; If Not Found Add The Over 179 Day Autotext To The Letter\",\" \"))","v":" "}]
[{"$f":"IF('Drill Pay Review'!C8>0,'Drill Pay Review'!C8,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!F8=\"YES\",\"No Action Needed\",IF('Drill Pay Review'!E8=0*AND('Drill Pay Review'!F8=0),\" \",IF('Drill Pay Review'!E8=\"YES\",\"Work Under 290 EP\",IF('Suggested Actions'!C7=\"No Drill Pay Adjustment Required\",\"No Action Needed\",\"Issue Due Process\"))))","v":" "},{"$f":"IF('Drill Pay Review'!C8=0*AND('Drill Pay Review'!O8=0),\" \",IF('Drill Pay Review'!O8<1,\"No Drill Pay Adjustment Required\",\"Adjust for \"&'Drill Pay Review'!O8&\" Drill Pay Days \"))","v":" "},{"$f":"IF('Drill Pay Review'!J8=\"YES\",\"Issue Due Process For  Period Of Active Duty\",IF('Drill Pay Review'!J8=\"NO\",\"NONE\",IF('Drill Pay Review'!M8=0,\" \",\" \")))","v":" "},{"$f":"IF(('Drill Pay Review'!D8<179)*AND('Drill Pay Review'!I8=\"NO\"),\"NO\",IF('Drill Pay Review'!D8>=179,\"Check DPRIS Or VIS For Active Duty; If Not Found Add The Over 179 Day Autotext To The Letter\",\" \"))","v":" "}]
[{"$f":"IF('Drill Pay Review'!C9>0,'Drill Pay Review'!C9,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!F9=\"YES\",\"No Action Needed\",IF('Drill Pay Review'!E9=0*AND('Drill Pay Review'!F9=0),\" \",IF('Drill Pay Review'!E9=\"YES\",\"Work Under 290 EP\",IF('Suggested Actions'!C8=\"No Drill Pay Adjustment Required\",\"No Action Needed\",\"Issue Due Process\"))))","v":" "},{"$f":"IF('Drill Pay Review'!C9=0*AND('Drill Pay Review'!O9=0),\" \",IF('Drill Pay Review'!O9<1,\"No Drill Pay Adjustment Required\",\"Adjust for \"&'Drill Pay Review'!O9&\" Drill Pay Days \"))","v":" "},{"$f":"IF('Drill Pay Review'!J9=\"YES\",\"Issue Due Process For  Period Of Active Duty\",IF('Drill Pay Review'!J9=\"NO\",\"NONE\",IF('Drill Pay Review'!M9=0,\" \",\" \")))","v":" "},{"$f":"IF(('Drill Pay Review'!D9<179)*AND('Drill Pay Review'!I9=\"NO\"),\"NO\",IF('Drill Pay Review'!D9>=179,\"Check DPRIS Or VIS For Active Duty; If Not Found Add The Over 179 Day Autotext To The Letter\",\" \"))","v":" "}]
[{"$f":"IF('Drill Pay Review'!C10>0,'Drill Pay Review'!C10,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!F10=\"YES\",\"No Action Needed\",IF('Drill Pay Review'!E10=0*AND('Drill Pay Review'!F10=0),\" \",IF('Drill Pay Review'!E10=\"YES\",\"Work Under 290 EP\",IF('Suggested Actions'!C9=\"No Drill Pay Adjustment Required\",\"No Action Needed\",\"Issue Due Process\"))))","v":" "},{"$f":"IF('Drill Pay Review'!C10=0*AND('Drill Pay Review'!O10=0),\" \",IF('Drill Pay Review'!O10<1,\"No Drill Pay Adjustment Required\",\"Adjust for \"&'Drill Pay Review'!O10&\" Drill Pay Days \"))","v":" "},{"$f":"IF('Drill Pay Review'!J10=\"YES\",\"Issue Due Process For  Period Of Active Duty\",IF('Drill Pay Review'!J10=\"NO\",\"NONE\",IF('Drill Pay Review'!M10=0,\" \",\" \")))","v":" "},{"$f":"IF(('Drill Pay Review'!D10<179)*AND('Drill Pay Review'!I10=\"NO\"),\"NO\",IF('Drill Pay Review'!D10>=179,\"Check DPRIS Or VIS For Active Duty; If Not Found Add The Over 179 Day Autotext To The Letter\",\" \"))","v":" "}]
[{"$f":"IF('Drill Pay Review'!C11>0,'Drill Pay Review'!C11,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!F11=\"YES\",\"No Action Needed\",IF('Drill Pay Review'!E11=0*AND('Drill Pay Review'!F11=0),\" \",IF('Drill Pay Review'!E11=\"YES\",\"Work Under 290 EP\",IF('Suggested Actions'!C10=\"No Drill Pay Adjustment Required\",\"No Action Needed\",\"Issue Due Process\"))))","v":" "},{"$f":"IF('Drill Pay Review'!C11=0*AND('Drill Pay Review'!O11=0),\" \",IF('Drill Pay Review'!O11<1,\"No Drill Pay Adjustment Required\",\"Adjust for \"&'Drill Pay Review'!O11&\" Drill Pay Days \"))","v":" "},{"$f":"IF('Drill Pay Review'!J11=\"YES\",\"Issue Due Process For  Period Of Active Duty\",IF('Drill Pay Review'!J11=\"NO\",\"NONE\",IF('Drill Pay Review'!M11=0,\" \",\" \")))","v":" "},{"$f":"IF(('Drill Pay Review'!D11<179)*AND('Drill Pay Review'!I11=\"NO\"),\"NO\",IF('Drill Pay Review'!D11>=179,\"Check DPRIS Or VIS For Active Duty; If Not Found Add The Over 179 Day Autotext To The Letter\",\" \"))","v":" "}]
[{"$f":"IF('Drill Pay Review'!C12>0,'Drill Pay Review'!C12,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!F12=\"YES\",\"No Action Needed\",IF('Drill Pay Review'!E12=0*AND('Drill Pay Review'!F12=0),\" \",IF('Drill Pay Review'!E12=\"YES\",\"Work Under 290 EP\",IF('Suggested Actions'!C11=\"No Drill Pay Adjustment Required\",\"No Action Needed\",\"Issue Due Process\"))))","v":" "},{"$f":"IF('Drill Pay Review'!C12=0*AND('Drill Pay Review'!O12=0),\" \",IF('Drill Pay Review'!O12<1,\"No Drill Pay Adjustment Required\",\"Adjust for \"&'Drill Pay Review'!O12&\" Drill Pay Days \"))","v":" "},{"$f":"IF('Drill Pay Review'!J12=\"YES\",\"Issue Due Process For  Period Of Active Duty\",IF('Drill Pay Review'!J12=\"NO\",\"NONE\",IF('Drill Pay Review'!M12=0,\" \",\" \")))","v":" "},{"$f":"IF(('Drill Pay Review'!D12<179)*AND('Drill Pay Review'!I12=\"NO\"),\"NO\",IF('Drill Pay Review'!D12>=179,\"Check DPRIS Or VIS For Active Duty; If Not Found Add The Over 179 Day Autotext To The Letter\",\" \"))","v":" "}]
[{"$f":"IF('Drill Pay Review'!C13>0,'Drill Pay Review'!C13,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!F13=\"YES\",\"No Action Needed\",IF('Drill Pay Review'!E13=0*AND('Drill Pay Review'!F13=0),\" \",IF('Drill Pay Review'!E13=\"YES\",\"Work Under 290 EP\",IF('Suggested Actions'!C12=\"No Drill Pay Adjustment Required\",\"No Action Needed\",\"Issue Due Process\"))))","v":" "},{"$f":"IF('Drill Pay Review'!C13=0*AND('Drill Pay Review'!O13=0),\" \",IF('Drill Pay Review'!O13<1,\"No Drill Pay Adjustment Required\",\"Adjust for \"&'Drill Pay Review'!O13&\" Drill Pay Days \"))","v":" "},{"$f":"IF('Drill Pay Review'!J13=\"YES\",\"Issue Due Process For  Period Of Active Duty\",IF('Drill Pay Review'!J13=\"NO\",\"NONE\",IF('Drill Pay Review'!M13=0,\" \",\" \")))","v":" "},{"$f":"IF(('Drill Pay Review'!D13<179)*AND('Drill Pay Review'!I13=\"NO\"),\"NO\",IF('Drill Pay Review'!D13>=179,\"Check DPRIS Or VIS For Active Duty; If Not Found Add The Over 179 Day Autotext To The Letter\",\" \"))","v":" "}]
[{"$f":"IF('Drill Pay Review'!C14>0,'Drill Pay Review'!C14,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!F14=\"YES\",\"No Action Needed\",IF('Drill Pay Review'!E14=0*AND('Drill Pay Review'!F14=0),\" \",IF('Drill Pay Review'!E14=\"YES\",\"Work Under 290 EP\",IF('Suggested Actions'!C13=\"No Drill Pay Adjustment Required\",\"No Action Needed\",\"Issue Due Process\"))))","v":" "},{"$f":"IF('Drill Pay Review'!C14=0*AND('Drill Pay Review'!O14=0),\" \",IF('Drill Pay Review'!O14<1,\"No Drill Pay Adjustment Required\",\"Adjust for \"&'Drill Pay Review'!O14&\" Drill Pay Days \"))","v":" "},{"$f":"IF('Drill Pay Review'!J14=\"YES\",\"Issue Due Process For  Period Of Active Duty\",IF('Drill Pay Review'!J14=\"NO\",\"NONE\",IF('Drill Pay Review'!M14=0,\" \",\" \")))","v":" "},{"$f":"IF(('Drill Pay Review'!D14<179)*AND('Drill Pay Review'!I14=\"NO\"),\"NO\",IF('Drill Pay Review'!D14>=179,\"Check DPRIS Or VIS For Active Duty; If Not Found Add The Over 179 Day Autotext To The Letter\",\" \"))","v":" "}]
[{"$f":"IF('Drill Pay Review'!C15>0,'Drill Pay Review'!C15,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!F15=\"YES\",\"No Action Needed\",IF('Drill Pay Review'!E15=0*AND('Drill Pay Review'!F15=0),\" \",IF('Drill Pay Review'!E15=\"YES\",\"Work Under 290 EP\",IF('Suggested Actions'!C14=\"No Drill Pay Adjustment Required\",\"No Action Needed\",\"Issue Due Process\"))))","v":" "},{"$f":"IF('Drill Pay Review'!C15=0*AND('Drill Pay Review'!O15=0),\" \",IF('Drill Pay Review'!O15<1,\"No Drill Pay Adjustment Required\",\"Adjust for \"&'Drill Pay Review'!O15&\" Drill Pay Days \"))","v":" "},{"$f":"IF('Drill Pay Review'!J15=\"YES\",\"Issue Due Process For  Period Of Active Duty\",IF('Drill Pay Review'!J15=\"NO\",\"NONE\",IF('Drill Pay Review'!M15=0,\" \",\" \")))","v":" "},{"$f":"IF(('Drill Pay Review'!D15<179)*AND('Drill Pay Review'!I15=\"NO\"),\"NO\",IF('Drill Pay Review'!D15>=179,\"Check DPRIS Or VIS For Active Duty; If Not Found Add The Over 179 Day Autotext To The Letter\",\" \"))","v":" "}]
[{"$f":"IF('Drill Pay Review'!C16>0,'Drill Pay Review'!C16,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!F16=\"YES\",\"No Action Needed\",IF('Drill Pay Review'!E16=0*AND('Drill Pay Review'!F16=0),\" \",IF('Drill Pay Review'!E16=\"YES\",\"Work Under 290 EP\",IF('Suggested Actions'!C15=\"No Drill Pay Adjustment Required\",\"No Action Needed\",\"Issue Due Process\"))))","v":" "},{"$f":"IF('Drill Pay Review'!C16=0*AND('Drill Pay Review'!O16=0),\" \",IF('Drill Pay Review'!O16<1,\"No Drill Pay Adjustment Required\",\"Adjust for \"&'Drill Pay Review'!O16&\" Drill Pay Days \"))","v":" "},{"$f":"IF('Drill Pay Review'!J16=\"YES\",\"Issue Due Process For  Period Of Active Duty\",IF('Drill Pay Review'!J16=\"NO\",\"NONE\",IF('Drill Pay Review'!M16=0,\" \",\" \")))","v":" "},{"$f":"IF(('Drill Pay Review'!D16<179)*AND('Drill Pay Review'!I16=\"NO\"),\"NO\",IF('Drill Pay Review'!D16>=179,\"Check DPRIS Or VIS For Active Duty; If Not Found Add The Over 179 Day Autotext To The Letter\",\" \"))","v":" "}]
[{"$f":"IF('Drill Pay Review'!C17>0,'Drill Pay Review'!C17,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!F17=\"YES\",\"No Action Needed\",IF('Drill Pay Review'!E17=0*AND('Drill Pay Review'!F17=0),\" \",IF('Drill Pay Review'!E17=\"YES\",\"Work Under 290 EP\",IF('Suggested Actions'!C16=\"No Drill Pay Adjustment Required\",\"No Action Needed\",\"Issue Due Process\"))))","v":" "},{"$f":"IF('Drill Pay Review'!C17=0*AND('Drill Pay Review'!O17=0),\" \",IF('Drill Pay Review'!O17<1,\"No Drill Pay Adjustment Required\",\"Adjust for \"&'Drill Pay Review'!O17&\" Drill Pay Days \"))","v":" "},{"$f":"IF('Drill Pay Review'!J17=\"YES\",\"Issue Due Process For  Period Of Active Duty\",IF('Drill Pay Review'!J17=\"NO\",\"NONE\",IF('Drill Pay Review'!M17=0,\" \",\" \")))","v":" "},{"$f":"IF(('Drill Pay Review'!D17<179)*AND('Drill Pay Review'!I17=\"NO\"),\"NO\",IF('Drill Pay Review'!D17>=179,\"Check DPRIS Or VIS For Active Duty; If Not Found Add The Over 179 Day Autotext To The Letter\",\" \"))","v":" "}]
[{"$f":"IF('Drill Pay Review'!C18>0,'Drill Pay Review'!C18,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!F18=\"YES\",\"No Action Needed\",IF('Drill Pay Review'!E18=0*AND('Drill Pay Review'!F18=0),\" \",IF('Drill Pay Review'!E18=\"YES\",\"Work Under 290 EP\",IF('Suggested Actions'!C17=\"No Drill Pay Adjustment Required\",\"No Action Needed\",\"Issue Due Process\"))))","v":" "},{"$f":"IF('Drill Pay Review'!C18=0*AND('Drill Pay Review'!O18=0),\" \",IF('Drill Pay Review'!O18<1,\"No Drill Pay Adjustment Required\",\"Adjust for \"&'Drill Pay Review'!O18&\" Drill Pay Days \"))","v":" "},{"$f":"IF('Drill Pay Review'!J18=\"YES\",\"Issue Due Process For  Period Of Active Duty\",IF('Drill Pay Review'!J18=\"NO\",\"NONE\",IF('Drill Pay Review'!M18=0,\" \",\" \")))","v":" "},{"$f":"IF(('Drill Pay Review'!D18<179)*AND('Drill Pay Review'!I18=\"NO\"),\"NO\",IF('Drill Pay Review'!D18>=179,\"Check DPRIS Or VIS For Active Duty; If Not Found Add The Over 179 Day Autotext To The Letter\",\" \"))","v":" "}]
[{"$f":"IF('Drill Pay Review'!C19>0,'Drill Pay Review'!C19,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!F19=\"YES\",\"No Action Needed\",IF('Drill Pay Review'!E19=0*AND('Drill Pay Review'!F19=0),\" \",IF('Drill Pay Review'!E19=\"YES\",\"Work Under 290 EP\",IF('Suggested Actions'!C18=\"No Drill Pay Adjustment Required\",\"No Action Needed\",\"Issue Due Process\"))))","v":" "},{"$f":"IF('Drill Pay Review'!C19=0*AND('Drill Pay Review'!O19=0),\" \",IF('Drill Pay Review'!O19<1,\"No Drill Pay Adjustment Required\",\"Adjust for \"&'Drill Pay Review'!O19&\" Drill Pay Days \"))","v":" "},{"$f":"IF('Drill Pay Review'!J19=\"YES\",\"Issue Due Process For  Period Of Active Duty\",IF('Drill Pay Review'!J19=\"NO\",\"NONE\",IF('Drill Pay Review'!M19=0,\" \",\" \")))","v":" "},{"$f":"IF(('Drill Pay Review'!D19<179)*AND('Drill Pay Review'!I19=\"NO\"),\"NO\",IF('Drill Pay Review'!D19>=179,\"Check DPRIS Or VIS For Active Duty; If Not Found Add The Over 179 Day Autotext To The Letter\",\" \"))","v":" "}]
[{"$f":"IF('Drill Pay Review'!C20>0,'Drill Pay Review'!C20,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!F20=\"YES\",\"No Action Needed\",IF('Drill Pay Review'!E20=0*AND('Drill Pay Review'!F20=0),\" \",IF('Drill Pay Review'!E20=\"YES\",\"Work Under 290 EP\",IF('Suggested Actions'!C19=\"No Drill Pay Adjustment Required\",\"No Action Needed\",\"Issue Due Process\"))))","v":" "},{"$f":"IF('Drill Pay Review'!C20=0*AND('Drill Pay Review'!O20=0),\" \",IF('Drill Pay Review'!O20<1,\"No Drill Pay Adjustment Required\",\"Adjust for \"&'Drill Pay Review'!O20&\" Drill Pay Days \"))","v":" "},{"$f":"IF('Drill Pay Review'!J20=\"YES\",\"Issue Due Process For  Period Of Active Duty\",IF('Drill Pay Review'!J20=\"NO\",\"NONE\",IF('Drill Pay Review'!M20=0,\" \",\" \")))","v":" "},{"$f":"IF(('Drill Pay Review'!D20<179)*AND('Drill Pay Review'!I20=\"NO\"),\"NO\",IF('Drill Pay Review'!D20>=179,\"Check DPRIS Or VIS For Active Duty; If Not Found Add The Over 179 Day Autotext To The Letter\",\" \"))","v":" "}]
[{"$f":"IF('Drill Pay Review'!C21>0,'Drill Pay Review'!C21,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!F21=\"YES\",\"No Action Needed\",IF('Drill Pay Review'!E21=0*AND('Drill Pay Review'!F21=0),\" \",IF('Drill Pay Review'!E21=\"YES\",\"Work Under 290 EP\",IF('Suggested Actions'!C20=\"No Drill Pay Adjustment Required\",\"No Action Needed\",\"Issue Due Process\"))))","v":" "},{"$f":"IF('Drill Pay Review'!C21=0*AND('Drill Pay Review'!O21=0),\" \",IF('Drill Pay Review'!O21<1,\"No Drill Pay Adjustment Required\",\"Adjust for \"&'Drill Pay Review'!O21&\" Drill Pay Days \"))","v":" "},{"$f":"IF('Drill Pay Review'!J21=\"YES\",\"Issue Due Process For  Period Of Active Duty\",IF('Drill Pay Review'!J21=\"NO\",\"NONE\",IF('Drill Pay Review'!M21=0,\" \",\" \")))","v":" "},{"$f":"IF(('Drill Pay Review'!D21<179)*AND('Drill Pay Review'!I21=\"NO\"),\"NO\",IF('Drill Pay Review'!D21>=179,\"Check DPRIS Or VIS For Active Duty; If Not Found Add The Over 179 Day Autotext To The Letter\",\" \"))","v":" "}]

{"sheet":"Visual Representation","index":2,"n_rows":21,"n_cols":17,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,15,0,16],[0,3,0,4],[0,5,0,6],[0,7,0,8],[0,9,0,10],[0,11,0,12],[0,13,0,14]]}
[null,null,null,{"$f":"IF('Drill Pay Review'!C3=0,\"NONE\",\"FY \"& 'Drill Pay Review'!C3)","v":"NONE"},null,{"$f":"IF('Drill Pay Review'!C4=0,\"NONE\",\"FY \"& 'Drill Pay Review'!C4)","v":"NONE"},null,{"$f":"IF('Drill Pay Review'!C5=0,\"NONE\",\"FY \"& 'Drill Pay Review'!C5)","v":"NONE"},null,{"$f":"IF('Drill Pay Review'!C6=0,\"NONE\",\"FY \"& 'Drill Pay Review'!C6)","v":"NONE"},null,{"$f":"IF('Drill Pay Review'!C7=0,\"NONE\",\"FY \"& 'Drill Pay Review'!C7)","v":"NONE"},null,{"$f":"IF('Drill Pay Review'!E7=0,\"NONE\",\"FY \"& 'Drill Pay Review'!E7)","v":"NONE"},null,{"$f":"IF('Drill Pay Review'!C9=0,\"NONE\",\"FY \"& 'Drill Pay Review'!C9)","v":"NONE"}]
["FISCAL YEAR FROM DRILL PAY REVIEW TAB","EOD FROM DRILL PAY REVIEW TAB","RAD FROM DRILL PAY REVIEW TAB"]
[{"$f":"IF('Drill Pay Review'!C3>0,'Drill Pay Review'!C3,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!K3>0,'Drill Pay Review'!K3,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!L3>0,'Drill Pay Review'!L3,\" \")","v":" "},null,"EOD",null,"EOD",null,"EOD",null,"EOD",null,"EOD",null,"EOD",null,"EOD"]
[{"$f":"IF('Drill Pay Review'!C4>0,'Drill Pay Review'!C4,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!K4>0,'Drill Pay Review'!K4,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!L4>0,'Drill Pay Review'!L4,\" \")","v":" "},null,{"$f":"IF(B3<DATEVALUE(D5),B3,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(B4<DATEVALUE(F5),B4,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(B5<=DATEVALUE(H5),B5,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(B6<DATEVALUE(J5),B6,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(B7<DATEVALUE(L5),B7,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(B8<DATEVALUE(N5),B8,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(B9<DATEVALUE(P5),B9,\" \")","v":{"$error":"#VALUE!"}}]
[{"$f":"IF('Drill Pay Review'!C5>0,'Drill Pay Review'!C5,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!K5>0,'Drill Pay Review'!K5,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!L5>0,'Drill Pay Review'!L5,\" \")","v":" "},{"$f":"'Drill Pay Review'!G3","v":" "},null,{"$f":"'Drill Pay Review'!G4","v":" "},null,{"$f":"'Drill Pay Review'!G5","v":" "},null,{"$f":"'Drill Pay Review'!G6","v":" "},null,{"$f":"'Drill Pay Review'!G7","v":" "},null,{"$f":"'Drill Pay Review'!G8","v":" "},null,{"$f":"'Drill Pay Review'!G9","v":" "}]
[{"$f":"IF('Drill Pay Review'!C6>0,'Drill Pay Review'!C6,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!K6>0,'Drill Pay Review'!K6,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!L6>0,'Drill Pay Review'!L6,\" \")","v":" "}]
[{"$f":"IF('Drill Pay Review'!C7>0,'Drill Pay Review'!C7,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!K7>0,'Drill Pay Review'!K7,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!L7>0,'Drill Pay Review'!L7,\" \")","v":" "},null,{"$f":"IF(B3>=DATEVALUE(D5),B3,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(B4>=DATEVALUE(F5),B4,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(B5>=DATEVALUE(H5),B5,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(B6>=DATEVALUE(J5),B6,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(B7>=DATEVALUE(L5),B7,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(B8>=DATEVALUE(N5),B8,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(B9>=DATEVALUE(P5),B9,\" \")","v":{"$error":"#VALUE!"}}]
[{"$f":"IF('Drill Pay Review'!C8>0,'Drill Pay Review'!C8,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!K8>0,'Drill Pay Review'!K8,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!L8>0,'Drill Pay Review'!L8,\" \")","v":" "}]
[{"$f":"IF('Drill Pay Review'!C9>0,'Drill Pay Review'!C9,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!K9>0,'Drill Pay Review'!K9,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!L9>0,'Drill Pay Review'!L9,\" \")","v":" "}]
[{"$f":"IF('Drill Pay Review'!C10>0,'Drill Pay Review'!C10,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!K10>0,'Drill Pay Review'!K10,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!L10>0,'Drill Pay Review'!L10,\" \")","v":" "}]
[{"$f":"IF('Drill Pay Review'!C11>0,'Drill Pay Review'!C11,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!K11>0,'Drill Pay Review'!K11,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!L11>0,'Drill Pay Review'!L11,\" \")","v":" "}]
[{"$f":"IF('Drill Pay Review'!C12>0,'Drill Pay Review'!C12,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!K12>0,'Drill Pay Review'!K12,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!L12>0,'Drill Pay Review'!L12,\" \")","v":" "}]
[{"$f":"IF('Drill Pay Review'!C13>0,'Drill Pay Review'!C13,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!K13>0,'Drill Pay Review'!K13,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!L13>0,'Drill Pay Review'!L13,\" \")","v":" "}]
[{"$f":"IF('Drill Pay Review'!C14>0,'Drill Pay Review'!C14,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!K14>0,'Drill Pay Review'!K14,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!L14>0,'Drill Pay Review'!L14,\" \")","v":" "}]
[{"$f":"IF('Drill Pay Review'!C15>0,'Drill Pay Review'!C15,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!K15>0,'Drill Pay Review'!K15,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!L15>0,'Drill Pay Review'!L15,\" \")","v":" "},null,{"$f":"IF(C3<=DATEVALUE(D17),C3,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(C4<=DATEVALUE(F17),C4,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(C5<=DATEVALUE(H17),C5,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(C6<=DATEVALUE(J17),C6,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(C7<=DATEVALUE(L17),C7,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(C8<=DATEVALUE(N17),C8,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(C9<DATEVALUE(P17),C9,\" \")","v":{"$error":"#VALUE!"}}]
[{"$f":"IF('Drill Pay Review'!C16>0,'Drill Pay Review'!C16,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!K16>0,'Drill Pay Review'!K16,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!L16>0,'Drill Pay Review'!L16,\" \")","v":" "}]
[{"$f":"IF('Drill Pay Review'!C17>0,'Drill Pay Review'!C17,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!K17>0,'Drill Pay Review'!K17,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!L17>0,'Drill Pay Review'!L17,\" \")","v":" "},{"$f":"'Drill Pay Review'!H3","v":" "},null,{"$f":"'Drill Pay Review'!H4","v":" "},null,{"$f":"'Drill Pay Review'!H5","v":" "},null,{"$f":"'Drill Pay Review'!H6","v":" "},null,{"$f":"'Drill Pay Review'!H7","v":" "},null,{"$f":"'Drill Pay Review'!H8","v":" "},null,{"$f":"'Drill Pay Review'!H9","v":" "}]
[{"$f":"IF('Drill Pay Review'!C18>0,'Drill Pay Review'!C18,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!K18>0,'Drill Pay Review'!K18,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!L18>0,'Drill Pay Review'!L18,\" \")","v":" "}]
[{"$f":"IF('Drill Pay Review'!C19>0,'Drill Pay Review'!C19,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!K19>0,'Drill Pay Review'!K19,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!L19>0,'Drill Pay Review'!L19,\" \")","v":" "},null,{"$f":"IF(C3>DATEVALUE(D17),C3,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(C4>DATEVALUE(F17),C4,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(C5>DATEVALUE(H17),C5,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(C6>DATEVALUE(J17),C6,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(C7>DATEVALUE(L17),C7,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(C8>DATEVALUE(N17),C8,\" \")","v":{"$error":"#VALUE!"}},null,{"$f":"IF(C9>DATEVALUE(P17),C9,\" \")","v":{"$error":"#VALUE!"}}]
[{"$f":"IF('Drill Pay Review'!C20>0,'Drill Pay Review'!C20,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!K20>0,'Drill Pay Review'!K20,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!L20>0,'Drill Pay Review'!L20,\" \")","v":" "}]
[{"$f":"IF('Drill Pay Review'!C21>0,'Drill Pay Review'!C21,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!K21>0,'Drill Pay Review'!K21,\" \")","v":" "},{"$f":"IF('Drill Pay Review'!L21>0,'Drill Pay Review'!L21,\" \")","v":" "},null,"RAD",null,"RAD",null,"RAD",null,"RAD",null,"RAD",null,"RAD",null,"RAD"]