{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["BCBSSC Instructions","Small Group Subscribers","Associated Dependents"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":10,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"BCBSSC Instructions","index":0,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[26,1,26,6],[27,1,27,6]]}
[null,null,null,null,null,null,"v2"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Please see the instructions below in order to complete the Small Group Enrollment Spread Form."]
[null,"Please type all enrollment data into this Blue Cross Blue Shield of South Carolina Census Enrollment Form. "]
[null,"By giving us this information, it allows us to ensure all group information is loaded timely and accurately."]
[]
[]
[]
[]
[]
[]
[null,"Basic Steps:"]
[null,"1.  Important - You must click \"Enable Content\" at the top of the page in the Yellow Bar."]
[null,"2. Update the Small Group Subscribers Tab to include demographic information and Health Coverage."]
[null,"     a.  Include all members refusing coverage."]
[null,"     b.  Dental and Life Coverage are NOT included with Medical coverage and should only be updated if electing a separate Dental Only policy."]
[null,"3.  If Refusal is selected for Medical Status, Refusal Reason must also be given."]
[null,"4.  If Member had prior coverage with BCBS, select \"Existing\".  If Member is new to BCBS, select \"New\"."]
[null,"5.  If a member has any dependents, please update the Associated Dependents tab for all Family, Employee/Spouse or Employee/Child coverages."]
[null,"     6.  Include full-time employees only.  Part-time and Terminated employees should not be listed."]
[null,"     7.  Confirm this file – the data will be automatically be extracted and updated in our system."]
[]
[]
[]
[null,"Do's and Don’t"]
[null,"- Please do not change the file format"]
[null,"- Please do not remove or change the order of any columns – they are needed for the upload"]
[null,"- Please do not change the  name of the \"Subscriber\"  or \"Dependents\" tab"]
[null,"- Do use only the values provided in the drop down fields"]
[null,"- Handwritten or Faxed forms will not be accepted"]

{"sheet":"Small Group Subscribers","index":1,"n_rows":213,"n_cols":33,"rows_kept":213,"cut":false,"hidden":false,"merged":[[11,32,12,32],[11,31,12,31],[11,23,12,23],[11,24,12,24],[11,25,12,25],[11,26,12,26],[11,27,12,27],[11,28,12,28],[11,22,12,22],[11,29,12,29],[11,30,12,30],[11,16,12,16],[11,17,12,17],[11,18,12,18],[11,19,12,19],[11,20,12,20],[11,11,12,11],[10,1,10,18],[10,19,10,22],[10,23,10,28],[10,30,10,31],[11,5,12,5],[11,6,12,6],[11,7,12,7],[11,8,12,8],[11,9,12,9],[11,10,12,10],[11,12,12,12],[11,13,12,13],[11,14,12,14],[11,15,12,15],[11,21,12,21],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4]]}
[null,null,null,null,null,null,null,null,"Level Funded Group Census Enrollment Form"]
[]
[null,null,null,null,null,null,null,"Group Name:"]
[null,null,null,null,null,null,null,null,"(Use Name from Master Application)"]
[null,null,null,null,null,null,null,"Effective Date of Coverage:"]
[null,null,null,null,null,null,null,"CES Client Number:"]
[null,null,null,null,null,null,null,null,"Due to the links between the subscriber and dependent tabs,"]
[null,null,null,null,null,null,null,null,"you can not sort either spreadsheet or delete any rows."]
[]
[null,"v2"]
[null,"Employee Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Health Coverage",null,null,null,"Life Coverage",null,null,null,null,null,"Dep Cvg","Dental Coverage"]
[null,"Last Name","Middle Initial","First Name","New or Existing Member","SS#","Date of Birth","Gender","Street Address","City","State","Zip Code","Phone Number","E-Mail Address","Date of Hire","Dept Code","Class","Cobra","Other Health Insurance","Health Cvg","Medical Plan Election","Medical Status","Refusal Reason Code","Life Cvg","Beneficiary","Relationship","Contingent ","Relationship","Annual Salary **If cvg based on Annual Salary","Dependent Cvg","Dental Cvg","Dental Status","CES Group Number (Internal Use Only)"]
[]
[1]
[2]
[{"$f":"A15+1","v":3}]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[{"$f":"A79+1","v":67}]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[{"$f":"A143+1","v":131}]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[{"$f":"A207+1","v":195}]
[196]
[197]
[198]
[199]
[200]

{"sheet":"Associated Dependents","index":2,"n_rows":13,"n_cols":50,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,6,12,6],[11,7,12,7],[11,0,12,0],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,5,12,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"v2"]
[]
[]
[null,"Last Name","Middle Initial","First Name","New or Existing Member","SS#","Date of Birth","Gender","Spouse",null,null,null,null,null,"Dependent One",null,null,null,null,null,"Dependent Two",null,null,null,null,null,"Dependent Three",null,null,null,null,null,"Dependent Four",null,null,null,null,null,"Dependent Five",null,null,null,null,null,"Dependent Six"]
[null,null,null,null,null,null,null,null,"Last Name","Middle Initial","First Name","Date of Birth","SS#","Gender","Last Name","Middle Initial","First Name","Date of Birth","SS#","Gender","Last Name","Middle Initial","First Name","Date of Birth","SS#","Gender","Last Name","Middle Initial","First Name","Date of Birth","SS#","Gender","Last Name","Middle Initial","First Name","Date of Birth","SS#","Gender","Last Name","Middle Initial","First Name","Date of Birth","SS#","Gender","Last Name","Middle Initial","First Name","Date of Birth","SS#","Gender"]