{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","AnnuitantDaysCalculator"],"not_rendered":{"charts":0,"images":3,"macros":1,"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":"Instructions","index":0,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Double-click here to view the instructions:"]

{"sheet":"AnnuitantDaysCalculator","index":1,"n_rows":1000,"n_cols":17,"rows_kept":1000,"cut":false,"hidden":false,"merged":[]}
[{"$f":"COUNTIF($B$7:$B$154,\"Possible non-contiguous OT\")","v":0},null,null,{"$f":"IF(A1>0,\"Possible non-contiguous OT:\",\"\")","v":""}]
[null,null,"OT hours or multiple entries for the same day were detected. If multiple entries were due to labor distribution, please disregard this message.  ",{"$f":"IF($A$1>0,$C$2,\"\")","v":""}]
[null,null,"If OT hours did NOT run contiguously to regularly scheduled hours (i.e. the annuitant worked some hours and was called back later that day to work more hours),",{"$f":"IF($A$1>0,$C$3,\"\")","v":""}]
[null,"ANNUITANT DAYS CALCULATOR","please review the policy and adjust the Total Days Worked to reflect the correct day calculation.",{"$f":"IF($A$1>0,$C$4,\"\")","v":""}]
[]
[null,"Total Days Worked in Calendar Year:",null,{"$f":"SUM(G:G)","v":0},null,"Hrs/Day","Day Count",null,"Personnel Number","Name of employee or applicant","Period","Current Date","Wage Type","Wage Type Long Text","EE Group","Subgroup","Number of hours"]
[null,{"$f":"IF(AND(F7<>\"\",L7=L6),\"Possible non-contiguous OT\",IF(F7=\"\",\"\",IF(OR((AND(RIGHT(P7,1)=\"7\",F7>7.5)),(AND(RIGHT(P7,1)=\"8\",F7>8))),\"Possible non-contiguous OT\",\"\")))","v":""},null,null,null,{"$f":"IF(L7=L8,\"\",IF(AND(L7=L6,L6=L4,L4=L3,L3<>L2),Q7+Q6+Q4+Q3,IF(AND(L7=L6,L6=L4,L4<>L3),Q7+Q6+Q4,IF(AND(L7=L6,L6<>L4),Q7+Q6,Q7))))","v":""},{"$f":"IF(O7<>\"Annuitant\",\"\",IF(P7=\"\",\"\",IF(AND(RIGHT(P7,1)<>\"7\",RIGHT(P7,1)<>\"8\"),\"check subgroup\",IF(F7=\"\",\"\",IF(RIGHT(P7,1)=\"7\",IF(F7<3.75,0.5,1),IF(RIGHT(P7,1)=\"8\",IF(F7<4,0.5,1)))))))","v":""}]
[null,"",null,null,null,{"$f":"IF(L8=L9,\"\",IF(AND(L8=L7,L7=L6,L6=L4,L4<>L3),Q8+Q7+Q6+Q4,IF(AND(L8=L7,L7=L6,L6<>L4),Q8+Q7+Q6,IF(AND(L8=L7,L7<>L6),Q8+Q7,Q8))))","v":""},""]
[null,"",null,null,null,{"$f":"IF(L9=L10,\"\",IF(AND(L9=L8,L8=L7,L7=L6,L6<>L4),Q9+Q8+Q7+Q6,IF(AND(L9=L8,L8=L7,L7<>L6),Q9+Q8+Q7,IF(AND(L9=L8,L8<>L7),Q9+Q8,Q9))))","v":""},""]
[null,"",null,null,null,{"$f":"IF(L10=L11,\"\",IF(AND(L10=L9,L9=L8,L8=L7,L7<>L6),Q10+Q9+Q8+Q7,IF(AND(L10=L9,L9=L8,L8<>L7),Q10+Q9+Q8,IF(AND(L10=L9,L9<>L8),Q10+Q9,Q10))))","v":""},""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,{"$f":"IF(AND(F39<>\"\",L39=L38),\"Possible non-contiguous OT\",IF(F39=\"\",\"\",IF(OR((AND(RIGHT(P39,1)=\"7\",F39>7.5)),(AND(RIGHT(P39,1)=\"8\",F39>8))),\"Possible non-contiguous OT\",\"\")))","v":""},null,null,null,"",{"$f":"IF(O39<>\"Annuitant\",\"\",IF(P39=\"\",\"\",IF(AND(RIGHT(P39,1)<>\"7\",RIGHT(P39,1)<>\"8\"),\"check subgroup\",IF(F39=\"\",\"\",IF(RIGHT(P39,1)=\"7\",IF(F39<3.75,0.5,1),IF(RIGHT(P39,1)=\"8\",IF(F39<4,0.5,1)))))))","v":""}]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,{"$f":"IF(L42=L43,\"\",IF(AND(L42=L41,L41=L40,L40=L39,L39<>L38),Q42+Q41+Q40+Q39,IF(AND(L42=L41,L41=L40,L40<>L39),Q42+Q41+Q40,IF(AND(L42=L41,L41<>L40),Q42+Q41,Q42))))","v":""},""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,{"$f":"IF(AND(F71<>\"\",L71=L70),\"Possible non-contiguous OT\",IF(F71=\"\",\"\",IF(OR((AND(RIGHT(P71,1)=\"7\",F71>7.5)),(AND(RIGHT(P71,1)=\"8\",F71>8))),\"Possible non-contiguous OT\",\"\")))","v":""},null,null,null,"",{"$f":"IF(O71<>\"Annuitant\",\"\",IF(P71=\"\",\"\",IF(AND(RIGHT(P71,1)<>\"7\",RIGHT(P71,1)<>\"8\"),\"check subgroup\",IF(F71=\"\",\"\",IF(RIGHT(P71,1)=\"7\",IF(F71<3.75,0.5,1),IF(RIGHT(P71,1)=\"8\",IF(F71<4,0.5,1)))))))","v":""}]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,{"$f":"IF(L74=L75,\"\",IF(AND(L74=L73,L73=L72,L72=L71,L71<>L70),Q74+Q73+Q72+Q71,IF(AND(L74=L73,L73=L72,L72<>L71),Q74+Q73+Q72,IF(AND(L74=L73,L73<>L72),Q74+Q73,Q74))))","v":""},""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,{"$f":"IF(AND(F103<>\"\",L103=L102),\"Possible non-contiguous OT\",IF(F103=\"\",\"\",IF(OR((AND(RIGHT(P103,1)=\"7\",F103>7.5)),(AND(RIGHT(P103,1)=\"8\",F103>8))),\"Possible non-contiguous OT\",\"\")))","v":""},null,null,null,"",{"$f":"IF(O103<>\"Annuitant\",\"\",IF(P103=\"\",\"\",IF(AND(RIGHT(P103,1)<>\"7\",RIGHT(P103,1)<>\"8\"),\"check subgroup\",IF(F103=\"\",\"\",IF(RIGHT(P103,1)=\"7\",IF(F103<3.75,0.5,1),IF(RIGHT(P103,1)=\"8\",IF(F103<4,0.5,1)))))))","v":""}]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,{"$f":"IF(L106=L107,\"\",IF(AND(L106=L105,L105=L104,L104=L103,L103<>L102),Q106+Q105+Q104+Q103,IF(AND(L106=L105,L105=L104,L104<>L103),Q106+Q105+Q104,IF(AND(L106=L105,L105<>L104),Q106+Q105,Q106))))","v":""},""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,{"$f":"IF(AND(F135<>\"\",L135=L134),\"Possible non-contiguous OT\",IF(F135=\"\",\"\",IF(OR((AND(RIGHT(P135,1)=\"7\",F135>7.5)),(AND(RIGHT(P135,1)=\"8\",F135>8))),\"Possible non-contiguous OT\",\"\")))","v":""},null,null,null,"",{"$f":"IF(O135<>\"Annuitant\",\"\",IF(P135=\"\",\"\",IF(AND(RIGHT(P135,1)<>\"7\",RIGHT(P135,1)<>\"8\"),\"check subgroup\",IF(F135=\"\",\"\",IF(RIGHT(P135,1)=\"7\",IF(F135<3.75,0.5,1),IF(RIGHT(P135,1)=\"8\",IF(F135<4,0.5,1)))))))","v":""}]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,{"$f":"IF(L138=L139,\"\",IF(AND(L138=L137,L137=L136,L136=L135,L135<>L134),Q138+Q137+Q136+Q135,IF(AND(L138=L137,L137=L136,L136<>L135),Q138+Q137+Q136,IF(AND(L138=L137,L137<>L136),Q138+Q137,Q138))))","v":""},""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,{"$f":"IF(AND(F155<>\"\",L155=L154),\"Possible non-contiguous OT\",IF(F155=\"\",\"\",IF(OR((AND(RIGHT(P155,1)=\"7\",F155>7.5)),(AND(RIGHT(P155,1)=\"8\",F155>8))),\"Possible non-contiguous OT\",\"\")))","v":""},null,null,null,{"$f":"IF(L155=L156,\"\",IF(AND(L155=L154,L154=L153,L153=L152,L152<>L151),Q155+Q154+Q153+Q152,IF(AND(L155=L154,L154=L153,L153<>L152),Q155+Q154+Q153,IF(AND(L155=L154,L154<>L153),Q155+Q154,Q155))))","v":""},{"$f":"IF(O155<>\"Annuitant\",\"\",IF(P155=\"\",\"\",IF(AND(RIGHT(P155,1)<>\"7\",RIGHT(P155,1)<>\"8\"),\"check subgroup\",IF(F155=\"\",\"\",IF(RIGHT(P155,1)=\"7\",IF(F155<3.75,0.5,1),IF(RIGHT(P155,1)=\"8\",IF(F155<4,0.5,1)))))))","v":""}]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,{"$f":"IF(AND(F219<>\"\",L219=L218),\"Possible non-contiguous OT\",IF(F219=\"\",\"\",IF(OR((AND(RIGHT(P219,1)=\"7\",F219>7.5)),(AND(RIGHT(P219,1)=\"8\",F219>8))),\"Possible non-contiguous OT\",\"\")))","v":""},null,null,null,{"$f":"IF(L219=L220,\"\",IF(AND(L219=L218,L218=L217,L217=L216,L216<>L215),Q219+Q218+Q217+Q216,IF(AND(L219=L218,L218=L217,L217<>L216),Q219+Q218+Q217,IF(AND(L219=L218,L218<>L217),Q219+Q218,Q219))))","v":""},{"$f":"IF(O219<>\"Annuitant\",\"\",IF(P219=\"\",\"\",IF(AND(RIGHT(P219,1)<>\"7\",RIGHT(P219,1)<>\"8\"),\"check subgroup\",IF(F219=\"\",\"\",IF(RIGHT(P219,1)=\"7\",IF(F219<3.75,0.5,1),IF(RIGHT(P219,1)=\"8\",IF(F219<4,0.5,1)))))))","v":""}]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,{"$f":"IF(AND(F283<>\"\",L283=L282),\"Possible non-contiguous OT\",IF(F283=\"\",\"\",IF(OR((AND(RIGHT(P283,1)=\"7\",F283>7.5)),(AND(RIGHT(P283,1)=\"8\",F283>8))),\"Possible non-contiguous OT\",\"\")))","v":""},null,null,null,{"$f":"IF(L283=L284,\"\",IF(AND(L283=L282,L282=L281,L281=L280,L280<>L279),Q283+Q282+Q281+Q280,IF(AND(L283=L282,L282=L281,L281<>L280),Q283+Q282+Q281,IF(AND(L283=L282,L282<>L281),Q283+Q282,Q283))))","v":""},{"$f":"IF(O283<>\"Annuitant\",\"\",IF(P283=\"\",\"\",IF(AND(RIGHT(P283,1)<>\"7\",RIGHT(P283,1)<>\"8\"),\"check subgroup\",IF(F283=\"\",\"\",IF(RIGHT(P283,1)=\"7\",IF(F283<3.75,0.5,1),IF(RIGHT(P283,1)=\"8\",IF(F283<4,0.5,1)))))))","v":""}]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,{"$f":"IF(AND(F347<>\"\",L347=L346),\"Possible non-contiguous OT\",IF(F347=\"\",\"\",IF(OR((AND(RIGHT(P347,1)=\"7\",F347>7.5)),(AND(RIGHT(P347,1)=\"8\",F347>8))),\"Possible non-contiguous OT\",\"\")))","v":""},null,null,null,{"$f":"IF(L347=L348,\"\",IF(AND(L347=L346,L346=L345,L345=L344,L344<>L343),Q347+Q346+Q345+Q344,IF(AND(L347=L346,L346=L345,L345<>L344),Q347+Q346+Q345,IF(AND(L347=L346,L346<>L345),Q347+Q346,Q347))))","v":""},{"$f":"IF(O347<>\"Annuitant\",\"\",IF(P347=\"\",\"\",IF(AND(RIGHT(P347,1)<>\"7\",RIGHT(P347,1)<>\"8\"),\"check subgroup\",IF(F347=\"\",\"\",IF(RIGHT(P347,1)=\"7\",IF(F347<3.75,0.5,1),IF(RIGHT(P347,1)=\"8\",IF(F347<4,0.5,1)))))))","v":""}]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,{"$f":"IF(AND(F411<>\"\",L411=L410),\"Possible non-contiguous OT\",IF(F411=\"\",\"\",IF(OR((AND(RIGHT(P411,1)=\"7\",F411>7.5)),(AND(RIGHT(P411,1)=\"8\",F411>8))),\"Possible non-contiguous OT\",\"\")))","v":""},null,null,null,{"$f":"IF(L411=L412,\"\",IF(AND(L411=L410,L410=L409,L409=L408,L408<>L407),Q411+Q410+Q409+Q408,IF(AND(L411=L410,L410=L409,L409<>L408),Q411+Q410+Q409,IF(AND(L411=L410,L410<>L409),Q411+Q410,Q411))))","v":""},{"$f":"IF(O411<>\"Annuitant\",\"\",IF(P411=\"\",\"\",IF(AND(RIGHT(P411,1)<>\"7\",RIGHT(P411,1)<>\"8\"),\"check subgroup\",IF(F411=\"\",\"\",IF(RIGHT(P411,1)=\"7\",IF(F411<3.75,0.5,1),IF(RIGHT(P411,1)=\"8\",IF(F411<4,0.5,1)))))))","v":""}]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,{"$f":"IF(AND(F475<>\"\",L475=L474),\"Possible non-contiguous OT\",IF(F475=\"\",\"\",IF(OR((AND(RIGHT(P475,1)=\"7\",F475>7.5)),(AND(RIGHT(P475,1)=\"8\",F475>8))),\"Possible non-contiguous OT\",\"\")))","v":""},null,null,null,{"$f":"IF(L475=L476,\"\",IF(AND(L475=L474,L474=L473,L473=L472,L472<>L471),Q475+Q474+Q473+Q472,IF(AND(L475=L474,L474=L473,L473<>L472),Q475+Q474+Q473,IF(AND(L475=L474,L474<>L473),Q475+Q474,Q475))))","v":""},{"$f":"IF(O475<>\"Annuitant\",\"\",IF(P475=\"\",\"\",IF(AND(RIGHT(P475,1)<>\"7\",RIGHT(P475,1)<>\"8\"),\"check subgroup\",IF(F475=\"\",\"\",IF(RIGHT(P475,1)=\"7\",IF(F475<3.75,0.5,1),IF(RIGHT(P475,1)=\"8\",IF(F475<4,0.5,1)))))))","v":""}]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,{"$f":"IF(AND(F539<>\"\",L539=L538),\"Possible non-contiguous OT\",IF(F539=\"\",\"\",IF(OR((AND(RIGHT(P539,1)=\"7\",F539>7.5)),(AND(RIGHT(P539,1)=\"8\",F539>8))),\"Possible non-contiguous OT\",\"\")))","v":""},null,null,null,{"$f":"IF(L539=L540,\"\",IF(AND(L539=L538,L538=L537,L537=L536,L536<>L535),Q539+Q538+Q537+Q536,IF(AND(L539=L538,L538=L537,L537<>L536),Q539+Q538+Q537,IF(AND(L539=L538,L538<>L537),Q539+Q538,Q539))))","v":""},{"$f":"IF(O539<>\"Annuitant\",\"\",IF(P539=\"\",\"\",IF(AND(RIGHT(P539,1)<>\"7\",RIGHT(P539,1)<>\"8\"),\"check subgroup\",IF(F539=\"\",\"\",IF(RIGHT(P539,1)=\"7\",IF(F539<3.75,0.5,1),IF(RIGHT(P539,1)=\"8\",IF(F539<4,0.5,1)))))))","v":""}]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,{"$f":"IF(AND(F603<>\"\",L603=L602),\"Possible non-contiguous OT\",IF(F603=\"\",\"\",IF(OR((AND(RIGHT(P603,1)=\"7\",F603>7.5)),(AND(RIGHT(P603,1)=\"8\",F603>8))),\"Possible non-contiguous OT\",\"\")))","v":""},null,null,null,{"$f":"IF(L603=L604,\"\",IF(AND(L603=L602,L602=L601,L601=L600,L600<>L599),Q603+Q602+Q601+Q600,IF(AND(L603=L602,L602=L601,L601<>L600),Q603+Q602+Q601,IF(AND(L603=L602,L602<>L601),Q603+Q602,Q603))))","v":""},{"$f":"IF(O603<>\"Annuitant\",\"\",IF(P603=\"\",\"\",IF(AND(RIGHT(P603,1)<>\"7\",RIGHT(P603,1)<>\"8\"),\"check subgroup\",IF(F603=\"\",\"\",IF(RIGHT(P603,1)=\"7\",IF(F603<3.75,0.5,1),IF(RIGHT(P603,1)=\"8\",IF(F603<4,0.5,1)))))))","v":""}]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,{"$f":"IF(AND(F667<>\"\",L667=L666),\"Possible non-contiguous OT\",IF(F667=\"\",\"\",IF(OR((AND(RIGHT(P667,1)=\"7\",F667>7.5)),(AND(RIGHT(P667,1)=\"8\",F667>8))),\"Possible non-contiguous OT\",\"\")))","v":""},null,null,null,{"$f":"IF(L667=L668,\"\",IF(AND(L667=L666,L666=L665,L665=L664,L664<>L663),Q667+Q666+Q665+Q664,IF(AND(L667=L666,L666=L665,L665<>L664),Q667+Q666+Q665,IF(AND(L667=L666,L666<>L665),Q667+Q666,Q667))))","v":""},{"$f":"IF(O667<>\"Annuitant\",\"\",IF(P667=\"\",\"\",IF(AND(RIGHT(P667,1)<>\"7\",RIGHT(P667,1)<>\"8\"),\"check subgroup\",IF(F667=\"\",\"\",IF(RIGHT(P667,1)=\"7\",IF(F667<3.75,0.5,1),IF(RIGHT(P667,1)=\"8\",IF(F667<4,0.5,1)))))))","v":""}]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,{"$f":"IF(AND(F731<>\"\",L731=L730),\"Possible non-contiguous OT\",IF(F731=\"\",\"\",IF(OR((AND(RIGHT(P731,1)=\"7\",F731>7.5)),(AND(RIGHT(P731,1)=\"8\",F731>8))),\"Possible non-contiguous OT\",\"\")))","v":""},null,null,null,{"$f":"IF(L731=L732,\"\",IF(AND(L731=L730,L730=L729,L729=L728,L728<>L727),Q731+Q730+Q729+Q728,IF(AND(L731=L730,L730=L729,L729<>L728),Q731+Q730+Q729,IF(AND(L731=L730,L730<>L729),Q731+Q730,Q731))))","v":""},{"$f":"IF(O731<>\"Annuitant\",\"\",IF(P731=\"\",\"\",IF(AND(RIGHT(P731,1)<>\"7\",RIGHT(P731,1)<>\"8\"),\"check subgroup\",IF(F731=\"\",\"\",IF(RIGHT(P731,1)=\"7\",IF(F731<3.75,0.5,1),IF(RIGHT(P731,1)=\"8\",IF(F731<4,0.5,1)))))))","v":""}]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,{"$f":"IF(AND(F795<>\"\",L795=L794),\"Possible non-contiguous OT\",IF(F795=\"\",\"\",IF(OR((AND(RIGHT(P795,1)=\"7\",F795>7.5)),(AND(RIGHT(P795,1)=\"8\",F795>8))),\"Possible non-contiguous OT\",\"\")))","v":""},null,null,null,{"$f":"IF(L795=L796,\"\",IF(AND(L795=L794,L794=L793,L793=L792,L792<>L791),Q795+Q794+Q793+Q792,IF(AND(L795=L794,L794=L793,L793<>L792),Q795+Q794+Q793,IF(AND(L795=L794,L794<>L793),Q795+Q794,Q795))))","v":""},{"$f":"IF(O795<>\"Annuitant\",\"\",IF(P795=\"\",\"\",IF(AND(RIGHT(P795,1)<>\"7\",RIGHT(P795,1)<>\"8\"),\"check subgroup\",IF(F795=\"\",\"\",IF(RIGHT(P795,1)=\"7\",IF(F795<3.75,0.5,1),IF(RIGHT(P795,1)=\"8\",IF(F795<4,0.5,1)))))))","v":""}]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,{"$f":"IF(AND(F859<>\"\",L859=L858),\"Possible non-contiguous OT\",IF(F859=\"\",\"\",IF(OR((AND(RIGHT(P859,1)=\"7\",F859>7.5)),(AND(RIGHT(P859,1)=\"8\",F859>8))),\"Possible non-contiguous OT\",\"\")))","v":""},null,null,null,{"$f":"IF(L859=L860,\"\",IF(AND(L859=L858,L858=L857,L857=L856,L856<>L855),Q859+Q858+Q857+Q856,IF(AND(L859=L858,L858=L857,L857<>L856),Q859+Q858+Q857,IF(AND(L859=L858,L858<>L857),Q859+Q858,Q859))))","v":""},{"$f":"IF(O859<>\"Annuitant\",\"\",IF(P859=\"\",\"\",IF(AND(RIGHT(P859,1)<>\"7\",RIGHT(P859,1)<>\"8\"),\"check subgroup\",IF(F859=\"\",\"\",IF(RIGHT(P859,1)=\"7\",IF(F859<3.75,0.5,1),IF(RIGHT(P859,1)=\"8\",IF(F859<4,0.5,1)))))))","v":""}]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,{"$f":"IF(AND(F923<>\"\",L923=L922),\"Possible non-contiguous OT\",IF(F923=\"\",\"\",IF(OR((AND(RIGHT(P923,1)=\"7\",F923>7.5)),(AND(RIGHT(P923,1)=\"8\",F923>8))),\"Possible non-contiguous OT\",\"\")))","v":""},null,null,null,{"$f":"IF(L923=L924,\"\",IF(AND(L923=L922,L922=L921,L921=L920,L920<>L919),Q923+Q922+Q921+Q920,IF(AND(L923=L922,L922=L921,L921<>L920),Q923+Q922+Q921,IF(AND(L923=L922,L922<>L921),Q923+Q922,Q923))))","v":""},{"$f":"IF(O923<>\"Annuitant\",\"\",IF(P923=\"\",\"\",IF(AND(RIGHT(P923,1)<>\"7\",RIGHT(P923,1)<>\"8\"),\"check subgroup\",IF(F923=\"\",\"\",IF(RIGHT(P923,1)=\"7\",IF(F923<3.75,0.5,1),IF(RIGHT(P923,1)=\"8\",IF(F923<4,0.5,1)))))))","v":""}]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,{"$f":"IF(AND(F987<>\"\",L987=L986),\"Possible non-contiguous OT\",IF(F987=\"\",\"\",IF(OR((AND(RIGHT(P987,1)=\"7\",F987>7.5)),(AND(RIGHT(P987,1)=\"8\",F987>8))),\"Possible non-contiguous OT\",\"\")))","v":""},null,null,null,{"$f":"IF(L987=L988,\"\",IF(AND(L987=L986,L986=L985,L985=L984,L984<>L983),Q987+Q986+Q985+Q984,IF(AND(L987=L986,L986=L985,L985<>L984),Q987+Q986+Q985,IF(AND(L987=L986,L986<>L985),Q987+Q986,Q987))))","v":""},{"$f":"IF(O987<>\"Annuitant\",\"\",IF(P987=\"\",\"\",IF(AND(RIGHT(P987,1)<>\"7\",RIGHT(P987,1)<>\"8\"),\"check subgroup\",IF(F987=\"\",\"\",IF(RIGHT(P987,1)=\"7\",IF(F987<3.75,0.5,1),IF(RIGHT(P987,1)=\"8\",IF(F987<4,0.5,1)))))))","v":""}]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]
[null,"",null,null,null,"",""]