{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","EFF Date Calc","Vars"],"not_rendered":{"charts":0,"images":1,"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":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2],[9,1,9,2]]}
[]
[null,"Instructions for use with standard probationary periods "]
[null,"Step","Action"]
[null,1,"If a security warning banner is displayed upon opening, select the Enable Content button to activate the calculator."]
[null,2,"In the Event Date / Date of Hire field, enter the date the employee will begin serving the group's probationary period in a MM/DD/YYYY format.   "]
[null,3,"Go down to the line that represents your employee's probationary period and review the effective date for your employee. "]
[null,4,"If you have multiple employees coming onto coverage with different eligiblity or new hire dates, press  the Reset button at the bottom of the form to reset the calculator. "]
[]
[]
[null,"Instructions for use with custom probationary periods"]
[null,"Step","Action"]
[null,1,"If a security warning banner is displayed upon opening, select the Enable Content button to activate the calculator."]
[null,2,"In the Event Date / Date of Hire field, enter the date the employee will begin serving the group's probationary period.   "]
[null,3,"In the Custom Probationary Period section, enter your employee's probationary period into the appropriate field based on your group's contract.  "]
[null,4,"If you have multiple employees coming onto coverage with different eligiblity or new hire dates, press  the Reset button at the bottom of the form to reset the calculator. "]

{"sheet":"EFF Date Calc","index":1,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,4],[19,1,19,4],[20,1,20,4],[21,1,21,4],[6,0,16,0],[7,1,9,1],[10,1,13,1],[18,1,18,4]]}
["EMPLOYEE EFFECTIVE DATE CALCULATOR"]
[]
[null,"*Event Date / Date of Hire"]
[]
[]
[null,"Probationary Period Type","Measurement","Date Eligible","Effective Date"]
["Probationary Period"]
[null,"First of Month Following","Date of Hire",{"$f":"C3","v":"00:00:00"},"**See the Date hire note below"]
[null,null,"30 Days",{"$f":"C3+29","v":"1900-01-29"},{"$f":"EOMONTH(D9, 0)+1","v":"1900-02-01"}]
[null,null,"60 Days ",{"$f":"C3+59","v":"1900-02-28"},{"$f":"EOMONTH(D10, 0)+1","v":60}]
[null,"Actual Effective date","DOH",{"$f":"C3","v":"00:00:00"},{"$f":"C3","v":"00:00:00"}]
[null,null,"30th Day",{"$f":"C3+29","v":"1900-01-29"},{"$f":"C3+29","v":"1900-01-29"}]
[null,null,"60th Day",{"$f":"C3+59","v":"1900-02-28"},{"$f":"C3+59","v":"1900-02-28"}]
[null,null,"90th Day",{"$f":"C3+89","v":"1900-03-29"},{"$f":"C3+89","v":"1900-03-29"}]
[null,"***Custom Probationary Period\nEffective On Actual Date Met  ",null,{"$f":"C3+C15-1","v":-1},{"$f":"IF(ISBLANK(C3),\"\",D3+D15)","v":""}]
[null,"***Custom Probationary Period \nFirst of month following ",null,{"$f":"C3+C16-1","v":-1},{"$f":"IF(ISBLANK(C3),\"\",EOMONTH(D16, 0)+1)","v":""}]
[null,"Group Determines Own Eligiblity\nEnter the Groups requested effective date.  ",null,{"$f":"IF(ISBLANK(C17),\"\",C17)","v":""},{"$f":"IF(ISBLANK(C17),\"\",C17)","v":""}]
[]
[]
[null,"This tool is provided as a courtesy.  The contract rules will supersede this tool.   Refer to your current Group Master Application or contract to determine your employees probationary period. \n\n* Event Date / Date of Hire:  This should be the date the employee has satisfied all eligibility criteria and is eligible to begin serving the probationary period.  Refer to your contract and / or Group Administrator Guide for eligibility guidelines.\n\n** Date of Hire:  For members serving a First of the Month Following Date of Hire probationary period, refer to your Group Master Application for the appropriate selection.  \n   Employees hired on the first of the month: \n     a. Effective date = date of hire or,\n     b. Effective date = the first of the month following their date of hire. \n\n*** Custom Probationary Periods: These are available only to groups rated 101+ and must be selected and approved at set up or renewal. "]
[]
[]
[null,"Revision: 02/13/2018"]

{"sheet":"Vars","index":2,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Choose State…","Yes/No",63,"Choose State…","Group Size…","Prob Period…","Prob Type…","No","N/A"]
["OR","Yes",90,"Choose Group Size…","Small (1-50)","Not Renewed","FoM After","PT_to_FT","Regence Error"]
["ID","No",null,null,"Medium (51-99)","EventDate/DoH","Eff On","WaivePP(NewGrp)","Group Error"]
["UT",null,null,null,"Large (100+)","30th Day","Day After","NoPPCredit"]
["WA",null,null,null,null,"60th Day","No QualEvt"]
["WA Small",null,null,null,null,"90th Day"]