{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Functions","Section1","Section2","Section3","Section4","Section5","Section6","Section7","Section8","Reference"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":"Functions","index":0,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Year 3 - OIC K-12 ESSB 5940 Heath Benefit Data Collection Project"]
["School District Data Collection Spreadsheet Template"]
[]
["This macro (Excel program) imports CSV (comma delimitted) files into this spreadsheet."]
[]
["This macro does validation on data within the spreadsheet and calculates totals. The validation includes cell formatting, range verification, cross references across sections (where values entered in a given cell must first be defined elswhere)."]
["Questions?"]
["Y3DataCallTeam@Treinen.com"]
["Please click on the following link to view the intructions for this spreadsheet"]
["http://www.insurance.wa.gov/for-insurers/data-calls-reporting/special-data-calls/k-12-health-benefits-data-collection/schools/index3.html"]

{"sheet":"Section1","index":1,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Field_Name","Status","District_Response","Field_Desc"]
["SD_Code",null,29103,"County/District Code (nnnnn) - Pre-filled based on school district name selection, do not edit"]
["District_Name",null,"Anacortes School District","District Name"]
["Report_Year_Ending",null,2014,"Report Year - Calendar Year 2014 - PRE-FILLED"]
["Desc_Affordability",null,"We did all these great things to reduce the cost of full family coverage as compared to to the cost of employee-only coverage:\n(a) we did asdfg\n(b) we stopped doing zxcvb\n(c) we introduced qwerty\n","Describe progress on affordability for full family coverage in line with the target 3:1 ratio as specified in ESSB 5940 "]
["Desc_CostSavings",null,"We cut costs left, right and center in all these wonderful ways: \n1) qwerty\n2) abcde\n3) The brown cow jumped over the blue cheese\n","Describe progress on health care cost savings"]
["Desc_ReducedAdmin",null,"We hired a ninja alien administrator who does not take breaks and works for free\n","Describe progress on reducing administrative expenses"]
["Desc_CustService",null,"We made all these service improvements: \n(i) Awesome new web site\n(ii) 24 hour hotline \n(iii) abc 123\n(iv) xyz 456\n","Describe efforts to improve service to employees for health benefits"]
["Desc_ReduceDiff",null,"We did all these great things to reduce the cost of full family coverage as compared to to the cost of employee-only coverage:\n(a) we did asdfg\n(b) we stopped doing zxcvb\n(c) we introduced qwerty\n","Describe efforts to reduce the differential between employee only and full family coverage"]
["Desc_PTCoverage",null,"We offered full benefits to all part time employees\n","Describe efforts to protect part time employee access to health insurance coverage"]
["Desc_Innovations",null,"We implemented all these great ideas to keep everyone healthy, thus driving down costs:\n(1) poiuy lkjhg mnbvc\n(2) lkjhg mnbvc\n(3) mnbvc qwerty asdfg\n","Describe innovations in delivery or management of benefits not listed in section 2"]
["HDHP_Offered",null,"Y","Y or N - Is a High Deductible Health Plan (HDHP) offered to any employee groups? "]
["Total_Premiums_Med",null,5084,"TOTAL MEDICAL PREMIUMS - Calculated by CheckMySpreadsheet"]
["Total_Premiums_Dental",null,203,"TOTAL DENTAL PREMIUMS - Calculated by CheckMySpreadsheet"]
["Total_Premiums_Vision",null,207,"TOTAL VISION PREMIUMS - Calculated by CheckMySpreadsheet"]
["Total_Broker",null,20,"TOTAL BROKERAGE FEES - Calculated by CheckMySpreadsheet"]
["Total_ExternalAdmin",null,40,"TOTAL EXTERNAL ADMINISTRATIVE FEES - Calculated by CheckMySpreadsheet"]
["Total_Supplemental",null,30,"TOTAL SUPPLEMENTAL FEES - Calculated by CheckMySpreadsheet"]
["Total_Retire_Carveout",null,1234567,"TOTAL RETIREE CARVEOUT - Calculated by CheckMySpreadsheet"]
["Total_InternalAdmin",null,1234,"Manual entry"]
["Desc_InternalAdmin",null,"Cost of a dedicated person who just does benefit admin. \n","Manual entry"]
["Total_Other",null,50,"TOTAL OTHER FEES - Calculated by CheckMySpreadsheet"]
["Submitted_By",null,"Freddie Flintstone","Person who submitted this report"]
["Submitter_Email",null,"fred@flintstone.com","Email address of the person submitting the report"]
["Submission_Date",null,null,"System generated date & time report was scanned & imported MM/DD/YYYY  -  hh:mm (24 hr clock)"]
["Spreadsheet_Check_Date",null,"2015-02-19","System generated - date & time of last time Check My Spreadsheet was run - MM/DD/YYYY   -  hh:mm (24 hr clock)"]
[null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"Section2","index":2,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Status","Used_YND","Innov_NO","Innov_Desc"]
["","Y",1,"Our district has a benefits strategy that includes improving the health of our employees."]
["","N",2,"Our district has specific health plan goals for our employees."]
["","Y",3,"We participate in a health plan coalition."]
["","N",4,"We offer a plan design with a network of providers (hospitals and professionals) and higher benefits for use of in-network providers."]
["","Y",5,"We receive health plan performance data from our health plan administrator/insurer."]
["","N",6,"We provide incentives for employees to use our wellness programs."]
["","Y",7,"We contract with our health plan to provide wellness services to our employees."]
["","N",8," We contract with an independent third party to provide wellness services to our employees."]
["","Y",9,"We offer a *consumer driven* health plan with a Health Savings Account."]
["","N",10,"We have a benefits budget that includes a wellness promotion component."]
["","Y",11,"To reduce unnecessary health services at least one of our health plans includes a copay for emergency room services."]
["","N",12,"To reduce unnecessary health services at least one of our health plans includes a copay for inpatient hospital admissions."]
["","Y",13,"To reduce unnecessary health services our pharmacy program requires higher copays for brand-name drugs where a generic drug is available."]
["","N",14,"Our health plan administrator/insurer or other third party works with us to find ways to reduce our health plan costs."]
["","Y",15,"Our health plan administrator/insurer provides us information on health care cost and trends."]
["","N",16,"…Offer a wellness program."]
["","Y",17,"…Provide wellness coaching to our employees."]
["","N",18,"…Send out wellness newsletters and/or post wellness messages on site."]
["","Y",19,"…Include case management and utilization management programs."]
["","N",20,"…Offer a focused disease management program."]
["","Y",21,"…Offer a high-risk maternity program or maternity education program."]
["","N",22,"…Offer our employees an opportunity to complete health risk assessments."]
["","Y",23,"…Offer our employees an opportunity to complete biometric screenings."]
["","N",24,"…Offer financial incentives for employees to lose weight."]
["","Y",25,"…Offer financial incentives for employees to stop smoking."]
["","N",26,"…Know the health risks of our population of employees."]
["","Y",27,"…Communicate to employees that healthy behaviors can reduce health benefit costs."]
["","N",28,"…Offer incentives to encourage our population to improve their health."]
["","Y",29,"…Encourage our employees to know their *numbers* (cholesterol, body mass index, blood pressure, blood glucose levels)."]
["","N",30,"…Offer centers of excellence for high-cost services such as transplants."]
["","Y",31,"…Offer a Nurse Line service. "]
["","N",32,"…Offer a website to employees which includes health tools and resources."]
["","Y",33,"…Offer a communication plan to target chronic conditions (e.g. diabetes and depression)."]

{"sheet":"Section3","index":3,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Status","Entity_Code","Entity_Name","Entity_Type_Role","Premiums_Paid","Premium_Type","Non_Premium_Fees_Paid","C_Name","C_Phone","C_Email"]
[]
[null,"AE123","Aetna","Medical Ins. Carrier",123,"Medical",0,"Joe A","360-123-4567","Joe@ae.com"]
[null,"GH123","Group Health","Medical Ins. Carrier",234,"Medical and Dental",0,"Fred B","360-234-4567","Fred@gh.com"]
[null,"KA123","Kaiser","Medical Ins. Carrier",345,"Medical and Vision",0,"Sally C","360-345-4567","Sally@ka.com"]
[null,"KP123","KPS Health Plans","Medical Ins. Carrier",456,"Medical and Vision and Dental",0,"Jim D","360-456-4567","Jim@kp.com"]
[null,"MH123","Moda Health","Medical Ins. Carrier",567,"Medical",0,"Nancy E","360-567-4567","Nancy@mh"]
[null,"PE123","PEBB","Medical Ins. Carrier",678,"Medical and Dental",0,"Mike F","360-678-4567","Mike@pebb.com"]
[null,"PREM123","Premera","Medical Ins. Carrier",789,"Medical and Vision",0,"Sue G","360-789-4567","Sue@prem.com"]
[null,"PROV123","Providence","Medical Ins. Carrier",890,"Medical and Vision and Dental",0,"Jill H","360-890-4567","Jill@prov.com"]
[null,"REG123","Regence","Medical Ins. Carrier",901,"Medical",0,"John I","360-901-4567","John@re.com"]
[null,"UH123","United Healthcare","Medical Ins. Carrier",101,"Medical and Vision and Dental",0,"Anne J","360-321-4567","Anne@uh.com"]
[]
[null,"ADS-111","American Dental Solutions","Dental Ins. Carrier",101,"Dental",0,"Mike K","360-901-4567","Mike@ads.com"]
[null,"ADP-222","Awesome Dental Provider","Dental Ins. Carrier",102,"Dental",0,"Jim L","360-321-4567","Jim@adp.com"]
[]
[null,"AVS-333","Awesome Vision Services","Vision Ins. Carrier",103,"Vision",0,"Ed M","360-123-4567","Ed@avs.com"]
[null,"WVS-444","Wonderful Vision Services","Vision Ins. Carrier",104,"Vision",0,"Stacy N","360-123-4567","Stacy@wvs.com"]
[]
[null,"HBB-555","Health Benefits Brokerage Inc","Broker",0,"N/A",20,"James O","360-123-4567","James@hbb.com"]
[null,"HCA-666","HCA (Carveout)","HCA (Carveout)",0,"N/A",1234567,"Brian P","360-123-4567","Brian@hca.com"]
[null,"SUP-777","ABCDE Supplemental","Supplemental",0,"N/A",30,"Liz Q","360-123-4567","Liz@abcde.com"]
[null,"PLANADM-888","ASDFG Plan Administration Inc","Third Party Administrator",0,"N/A",40,"Anne R","360-123-4567","Anne@asdfg.com"]
[null,"AMP-999","Alternative Medicine Practitioners","Other",0,"N/A",50,"William S","360-123-4567","William@amp.com"]
[""]

{"sheet":"Section4","index":4,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Status","Carrier_Code","Carrier_Name","Plan_Code","Plan_Name"]
[null,"AE123","Aetna","AE1","AE PLAN-1"]
[null,"AE123","Aetna","AE2","AE PLAN-2"]
[]
[null,"GH123","Group Health","GH1","GH PLAN-1"]
[null,"GH123","Group Health","GH2","GH PLAN-2"]
[]
[null,"KA123","Kaiser","KA1","KA PLAN-1"]
[null,"KA123","Kaiser","KA2","KA PLAN-2"]
[]
[null,"KP123","KPS Health Plans","KP1","KP PLAN-1"]
[null,"KP123","KPS Health Plans","KP2","KP PLAN-2"]
[]
[null,"MH123","Moda Health","MH1","MH PLAN-1"]
[null,"MH123","Moda Health","MH2","MH PLAN-2"]
[]
[null,"PE123","PEBB","PE1 ","PE PLAN-1"]
[null,"PE123","PEBB","PE2","PE PLAN-2"]
[]
[null,"PREM123","Premera","PREM1 ","PREM PLAN-1"]
[null,"PREM123","Premera","PREM2","PREM PLAN-2"]
[]
[null,"PROV123","Providence","PROV1 ","PROV PLAN-1"]
[null,"PROV123","Providence","PROV2","PROV PLAN-2"]
[]
[null,"REG123","Regence","RE1","REG PLAN-1"]
[null,"REG123","Regence","RE2","REG PLAN-2"]
[]
[null,"NewCarrier123","Other","New1","NEW PLAN-1"]
[null,"NewCarrier123","Other","New2","NEW PLAN-2"]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"Section5","index":5,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Status","Group_Code","Group_Name","Group_CT","Plan_Codes_Offered"]
["","NBO-Class","No Benefits Offered - Classified","C"]
["","NBO-Cert","No Benefits Offered - Certificated","T"]
[null,"CE","Certificated","T","AE1, GH1, KA1, KP1, MH1"]
[null,"CL","Classified","C","PE1, PREM1, PROV1, RE1, New1"]
[null,"CES","Certificated Job Share","T","AE2, GH2, KA2, KP2, MH2"]
[null,"DR","Drivers","T","PE2, PREM2, PROV2, RE2, New2"]
[null,"SP","Superintendents & Principals","C","AE1, GH1, KA1, KP1, MH1, PE1, PREM1, PROV1, RE1, New1"]
[null,"TA","Teacher's assistants","T","AE2, GH2, KA2, KP2, MH2, PE2, PREM2, PROV2, RE2, New2"]

{"sheet":"Section6","index":6,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Status","Group_Code","Group_Name","Plan_Code","Plan_Name"]
[null,"CE","Certificated","AE1","AE PLAN-1"]
[null,"CE","Certificated","GH1","GH PLAN-1"]
[null,"CE","Certificated","KA1","KA PLAN-1"]
[null,"CE","Certificated","KP1","KP PLAN-1"]
[null,"CE","Certificated","MH1","MH PLAN-1"]
[]
[null,"CL","Classified","PE1","PEBB PLAN-1"]
[null,"CL","Classified","PREM1","PREM PLAN-1"]
[null,"CL","Classified","PROV1","PROV PLAN-1"]
[null,"CL","Classified","RE1","REG PLAN-1"]
[null,"CL","Classified","New1","New PLAN-1"]
[]
[null,"CES","Certificated Job Share","AE2","AE PLAN-2"]
[null,"CES","Certificated Job Share","GH2","GH PLAN-2"]
[null,"CES","Certificated Job Share","KA2","KA PLAN-2"]
[null,"CES","Certificated Job Share","KP2","KP PLAN-2"]
[null,"CES","Certificated Job Share","MH2","MH PLAN-2"]
[""]
["","DR","Drivers","PE2","PEBB PLAN-2"]
["","DR","Drivers","PREM2","PREM PLAN-2"]
["","DR","Drivers","PROV2","PROV PLAN-2"]
["","DR","Drivers","RE2","RE PLAN-2"]
["","DR","Drivers","New2","New PLAN-2"]
[""]
["","SP","Superintendents & Principals","AE1","AE PLAN-1"]
["","SP","Superintendents & Principals","PREM1","PREM PLAN-1"]
["","SP","Superintendents & Principals","PROV1","PROV PLAN-1"]
["","SP","Superintendents & Principals","RE1","REG PLAN-1"]
[""]
["","TA","Teacher's assistants","AE2","AE PLAN-2"]
["","TA","Teacher's assistants","PREM2","PREM PLAN-2"]
["","TA","Teacher's assistants","PROV2","PROV PLAN-2"]
["","TA","Teacher's assistants","RE2","REG PLAN-2"]

{"sheet":"Section7","index":7,"n_rows":55,"n_cols":19,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Status","Emp_Code","Group_Code","Emp_CT","Gender","DOB","Calculated_FTE","Benefit_FTE","Benefit_Elig_YN","Plan_Code","Plan_Tier","SD_Contrib","Emp_Contrib","Total_Premium","Dep_YN","Cov_MaleDep_Ages","Cov_FemaleDep_Ages","Elig_MaleDep_Ages","Elig_FemaleDep_Ages"]
[null,192837,"CL","C","F","1945-06-11",0.1,0,"N",null,null,null,null,null,"N"]
[null,3413,"CL","C","F","1978-07-02",0.12,0,"N",null,null,null,null,null,"N"]
[null,5278,"NBO-Class","C","M","1955-04-02",0.13,0,"N",null,null,null,null,null,"N"]
[null,12110,"NBO-Cert","C","F","1965-10-31",0.14000000000000001,0,"N",null,null,null,null,null,"N"]
[null,12345,"CL","C","F","1978-07-02",0.15,0,"N",null,null,null,null,null,"N"]
[null,13579,"NBO-Cert","C","F","1953-04-22",0.16,0,"N",null,null,null,null,null,"N"]
[null,14683,"CES","T","F","1961-03-10",0.17,0,"N",null,null,null,null,null,"N"]
[null,15349,"DR","C","F","1961-03-10",0.18,0,"N",null,null,null,null,null,"N"]
[null,15469,"SP","C","F","1962-08-13",0.19,0,"N",null,null,null,null,null,"N"]
[null,16034,"NBO-Class","C","F","1949-08-05",0.1,0,"N",null,null,null,null,null,"N"]
[null,16583,"NBO-Cert","C","F","1961-02-09",0.11,0,"N",null,null,null,null,null,"N"]
[null,16611,"CL","C","F","1953-05-12",0.12,0,"N",null,null,null,null,null,"N"]
[null,16766,"CL","C","F","1969-07-01",0.13,0,"N",null,null,null,null,null,"N"]
[null,17055,"CL","C","F","1961-09-11",0.14000000000000001,0,"N",null,null,null,null,null,"N"]
[null,17137,"NBO-Class","C","F","1950-12-21",0.15,0,"N",null,null,null,null,null,"N"]
[null,17496,"NBO-Cert","C","F","1965-08-09",0.16,0,"N",null,null,null,null,null,"N"]
[null,17512,"CL","C","F","1962-11-19",0.17,0,"N",null,null,null,null,null,"N"]
[null,17554,"CES","C","F","1961-02-20",0.18,0,"N",null,null,null,null,null,"N"]
[null,17671,"DR","C","F","1951-09-16",0.19,0,"N",null,null,null,null,null,"N"]
[null,20211,"SP","C","F","1966-12-21",0.123,1,"N"," "," "," "," "," ","N"]
[null,17570,"TA","C","F","1963-06-26",0.59699999999999998,0.75,"Y",null,null,null,null,null,"N"]
[null,18118,"CES","T","F","1964-09-05",1,0.85,"Y",null,null,null,null,null,"N"]
[null,20315,"DR","T","F","1987-12-29",1,0.95,"Y",null,null,null,null,null,"N"]
[null,20970,"SP","T","F","1954-11-11",0.6,0.99,"Y",null,null,null,null,null,"N"]
[null,12737,"TA","C","F","1958-06-30",0.45900000000000002,0.4,"Y","KA2","EE",601.91999999999996,0,601.91999999999996,"Y"]
[null,17040,"CE","T","F","1972-01-12",1,0.5,"Y","KP1","EC",703.52,150.11000000000001,853.63,"Y"]
[null,20124,"CES","C","F","1964-03-27",0.59699999999999998,0.6,"Y","KP2","EC",707.22,146.41,853.63,"Y"]
[null,20887,"DR","T","F","1979-04-13",1,0.7,"Y","MH1","EC",704.17,149.46,853.63,"Y"]
[null,17947,"SP","C","F","1973-05-29",0.6,0.8,"Y","MH2","EC",706.32,147.31,853.63,"Y"]
[null,10508,"TA","T","F","1954-02-22",0.7,0.9,"Y","PE1 ","EC",703.03,150.6,853.63,"Y"]
[null,17928,"CE","T","F","1978-03-15",0.8,0.3,"Y","PE2","E2",767.57,337.77,1105.3399999999999,"Y"]
[null,18339,"CE","T","F","1975-06-12",1,0.4,"Y","PREM1 ","E2",766.6,338.74,1105.3399999999999,"Y"]
[null,16266,"CL","C","F","1949-06-15",0.63900000000000001,0.5,"Y","PREM2","ES",798.98,429.19,1228.17,"Y"]
[null,10999,"CE","T","M","1950-02-17",1,0.6,"Y","PROV1 ","F2",921.4,810.19,1731.59,"Y"]
[null,19292,"CES","T","M","1982-08-13",1,0.7,"Y","PROV2","EE",349.95,0,349.95,"Y"]
[null,18056,"DR","C","F","1961-03-25",0.46200000000000002,0.8,"Y","RE1","EF",739.45,241.72,981.17,"Y"]
[null,20296,"SP","C","F","1970-09-09",1,0.3,"Y","RE2","EE",351.2,3.75,354.95,"N"]
[null,16109,"TA","T","M","1976-07-09",0.5,0.4,"Y","New1","EE",351.2,3.75,354.95,"N"]
[null,14627,"CL","C","F","1964-06-17",0.63900000000000001,0.5,"Y","New2","E2",657.9,118.55,776.45,"Y"]
[null,20310,"CL","C","F","1973-01-12",1,0.6,"Y","AE1","E2",658.24,118.21,776.45,"Y"]
[null,10476,"CE","T","M","1967-01-23",1,0.7,"Y","AE2","F2",755.11,430.78,1185.8900000000001,"Y"]
[null,17085,"CES","T","F","1969-02-24",0.46200000000000002,0.8,"Y","GH1","EE",386.49,0,386.49,"N"]
[null,8809,"DR","C","F","1957-09-10",1,0.9,"Y","GH2","EE",386.49,0,386.49,"N"]
[null,15286,"SP","C","F","1964-07-07",0.59699999999999998,1,"Y","KA1","EE",386.49,0,386.49,"N"]
[null,21043,"TA","T","F","1985-11-06",1,1,"Y","KA2","EE",386.49,0,386.49,"N"]
[null,17495,"CE","T","M","1967-03-15",1,1,"Y","KP1","EE",386.49,0,386.49,"N"]
[null,19578,"CE","T","F","1979-03-27",0.6,0.3,"Y","KP2","EF",386.49,0,386.49,"N"]
[null,20068,"CES","T","M","1988-10-21",0.8,0.4,"Y","MH1","EC",386.49,0,386.49,"N"]
[null,15773,"DR","T","F","1974-11-29",1,0.5,"Y","MH2","ES",321.22000000000003,0,321.22000000000003,"Y"]
[null,15407,"SP","C","M","1982-07-04",1,0.6,"Y","PE1 ","EC",123,0,524.79,"Y"]
[null,19092,"TA","T","F","1983-10-03",1,0.7,"Y","PE2","ES",663.51,456,697.04,"Y"]
[null,19224,"CE","T","M","1985-01-26",1,0.8,"Y","PREM1 ","ES",665.02,32.020000000000003,789,"Y"]
[null,19670,"CE","T","M","1986-05-02",1,0.9,"Y","PREM2","ES",665.16,31.88,697.04,"N"]
[null,20239,"CL","C","F","1954-12-03",0.46400000000000002,1,"Y","PROV1 ","ES",668.26,28.78,697.04,"Y"]

{"sheet":"Section8","index":8,"n_rows":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Status","Emp_Code","Gender","DOB","Benefits_YN"]
[null,192837,"F","1964-07-16","N"]
[null,3413,"F","1994-12-13","N"]
[null,5278,"M","1997-01-24","N"]
[null,12110,"M","1952-12-30","Y"]
[null,12110,"F","1990-12-31","N"]
[null,12110,"F","1994-11-23","N"]
[null,14683,"M","1958-02-04","N"]
[null,15349,"M","1992-06-15","N"]
[null,15469,"F","1991-08-30","Y"]
[null,16034,"M","1955-02-21","Y"]
[null,16583,"F","1953-07-21","Y"]
[null,16611,"F","1994-04-10","Y"]
[null,16766,"M","1959-01-09","Y"]
[null,17055,"M","1990-07-19","Y"]
[null,17137,"M","1957-05-12","N"]
[null,17496,"F","1950-03-24","Y"]
[null,17512,"M","1988-12-27","Y"]
[null,17554,"M","1961-05-15","N"]
[null,17671,"M","1943-01-13","Y"]
[null,12737,"M","1946-02-01","Y"]
[null,17040,"M","1949-11-28","Y"]
[null,20124,"M","1948-09-10","Y"]
[null,20887,"M","1988-10-08","Y"]
[null,17947,"F","1963-04-17","Y"]
[null,10508,"F","1991-09-25","Y"]
[null,17928,"F","1997-03-29","Y"]
[null,18339,"F","1951-07-09","Y"]
[null,16266,"F","1962-11-06","Y"]
[null,10999,"M","1992-11-06","Y"]
[null,19292,"M","1951-10-19","Y"]
[null,18056,"M","1939-01-02","N"]
[null,20296,"M","1946-09-11","Y"]
[null,16109,"F","1949-01-11","Y"]
[null,14627,"F","1959-05-09","Y"]
[null,20310,"F","1992-03-17","Y"]
[null,10476,"F","1992-03-17","Y"]
[null,17085,"F","1955-09-17","Y"]
[null,8809,"M","1993-04-04","Y"]
[null,15286,"F","1952-05-28","Y"]
[null,21043,"F","1990-01-18","Y"]
[null,17495,"F","1954-02-11","Y"]
[null,19578,"M","1953-04-17","Y"]
[null,20068,"M","1990-06-13","Y"]
[null,15773,"F","1988-12-14","N"]
[null,15407,"F","1990-06-25","N"]
[null,19092,"F","1990-11-03","N"]
[null,19224,"M","1950-11-23","N"]
[null,19670,"M","1945-05-29","N"]
[null,20239,"F","1955-08-30","Y"]
[null,20211,"M","1962-10-02","Y"]
[""]
[""]
[""]
[""]

{"sheet":"Reference","index":9,"n_rows":338,"n_cols":5,"rows_kept":338,"cut":false,"hidden":false,"merged":[]}
["Category","Type","Value",null,"Description"]
["Tier Codes",null,"EE","Do not edit this value","Code used to identify Employee only coverage tier. E and EE are commonly used. EE is the only accepted value in this spreadsheet. Please set all E to EE."]
["Tier Codes",null,"ES","Do not edit this value","Code used to identify Employee+Spouse coverage tier. ES is almost universally used. ES is the only accepted value in this spreadsheet."]
["Tier Codes",null,"EC","Do not edit this value","Code used to identify Employee + Child(ren)  coverage tier. EC is almost universally used EC is the only value accepted in this spreadsheet."]
["Tier Codes",null,"EF","Do not edit this value","Code used to identify Employee + Family coverage tier. EF and ESC are commonly used. EF is the only accepted value in this spreadsheet. Please set all ESC to EF."]
["Tier Codes",null,"E2","Do not edit this value","Code used to identify Employee + 2 or more children coverage tier (optional tier in some plans). E2, E3, E4, E5 or above are accepted values in this spreadsheet."]
["Tier Codes",null,"F2","Do not edit this value","Code used to identify coverage for Family with 2 or more children coverage (optional tier in some plans). F2 is the accepted value"]
["Group_CT",null,"C","Do not edit this value","Code Used to identify Classified group/employee. Default = C"]
["Group_CT",null,"T","Do not edit this value","Code Used to identify Certificated group/employee. Default = T"]
["Emp_CT","EE_Code","EE","Do not edit this value"]
["Emp_CT","ES_Code","ES","Do not edit this value"]
["Emp_CT","EC_Code","EC","Do not edit this value"]
["Emp_CT","EF_Code","EF","Do not edit this value"]
["Emp_CT","E2_Code","E2","Do not edit this value"]
["Emp_CT","F2_Code","F2","Do not edit this value"]
["Entity Type Role","Insurance","Medical Ins. Carrier","Do not edit this value"]
["Entity Type Role","Insurance","Dental Ins. Carrier","Do not edit this value"]
["Entity Type Role","Insurance","Vision Ins. Carrier","Do not edit this value"]
["Entity Type Role","Supplemental","Supplemental","Do not edit this value"]
["Entity Type Role","Broker","Broker","Do not edit this value"]
["Entity Type Role","External Admin","Third Party Administrator","Do not edit this value"]
["Entity Type Role","Both","Broker + Administrator","Do not edit this value"]
["Entity Type Role","Other","HCA (Carveout)","Do not edit this value"]
["Entity Type Role","Other","Other","Do not edit this value"]
["Premium Type",null,"N/A","Do not edit this value"]
["Premium Type",null,"Medical","Do not edit this value"]
["Premium Type",null,"Dental","Do not edit this value"]
["Premium Type",null,"Vision","Do not edit this value"]
["Premium Type",null,"Medical and Dental","Do not edit this value"]
["Premium Type",null,"Medical and Vision","Do not edit this value"]
["Premium Type",null,"Dental and Vision","Do not edit this value"]
["Premium Type",null,"Medical and Vision and Dental","Do not edit this value"]
["Carrier Name",null,"Aetna","Do not edit this value"]
["Carrier Name",null,"Group Health","Do not edit this value"]
["Carrier Name",null,"Kaiser","Do not edit this value"]
["Carrier Name",null,"KPS Health Plans","Do not edit this value"]
["Carrier Name",null,"Moda Health","Do not edit this value"]
["Carrier Name",null,"PEBB","Do not edit this value"]
["Carrier Name",null,"Premera","Do not edit this value"]
["Carrier Name",null,"Providence","Do not edit this value"]
["Carrier Name",null,"Regence","Do not edit this value"]
["Carrier Name",null,"United Healthcare","Do not edit this value"]
["Carrier Name",null,"Other","Do not edit this value"]
["District Name","Aberdeen School District","14005","Do not edit this value"]
["District Name","Adna School District","21226","Do not edit this value"]
["District Name","Almira School District","22017","Do not edit this value"]
["District Name","Anacortes School District","29103","Do not edit this value"]
["District Name","Arlington School District","31016","Do not edit this value"]
["District Name","Asotin-Anatone School District","02420","Do not edit this value"]
["District Name","Auburn School District","17408","Do not edit this value"]
["District Name","Bainbridge Island School District","18303","Do not edit this value"]
["District Name","Battle Ground School District","06119","Do not edit this value"]
["District Name","Bellevue School District","17405","Do not edit this value"]
["District Name","Bellingham School District","37501","Do not edit this value"]
["District Name","Benge School District","01122","Do not edit this value"]
["District Name","Bethel School District","27403","Do not edit this value"]
["District Name","Bickleton School District","20203","Do not edit this value"]
["District Name","Blaine School District","37503","Do not edit this value"]
["District Name","Boistfort School District","21234","Do not edit this value"]
["District Name","Bremerton School District","18100","Do not edit this value"]
["District Name","Brewster School District","24111","Do not edit this value"]
["District Name","Bridgeport School District","09075","Do not edit this value"]
["District Name","Brinnon School District","16046","Do not edit this value"]
["District Name","Burlington-Edison School District","29100","Do not edit this value"]
["District Name","Camas School District","06117","Do not edit this value"]
["District Name","Cape Flattery School District","05401","Do not edit this value"]
["District Name","Carbonado School District","27019","Do not edit this value"]
["District Name","Cascade School District","04228","Do not edit this value"]
["District Name","Cashmere School District","04222","Do not edit this value"]
["District Name","Castle Rock School District","08401","Do not edit this value"]
["District Name","Centerville School District","20215","Do not edit this value"]
["District Name","Central Kitsap School District","18401","Do not edit this value"]
["District Name","Central Valley School District","32356","Do not edit this value"]
["District Name","Centralia School District","21401","Do not edit this value"]
["District Name","Chehalis School District","21302","Do not edit this value"]
["District Name","Cheney School District","32360","Do not edit this value"]
["District Name","Chewelah School District","33036","Do not edit this value"]
["District Name","Chimacum School District","16049","Do not edit this value"]
["District Name","Clarkston School District","02250","Do not edit this value"]
["District Name","Cle Elum-Roslyn School District","19404","Do not edit this value"]
["District Name","Clover Park School District","27400","Do not edit this value"]
["District Name","Colfax School District","38300","Do not edit this value"]
["District Name","College Place School District","36250","Do not edit this value"]
["District Name","Colton School District","38306","Do not edit this value"]
["District Name","Columbia (Stevens) School District","33206","Do not edit this value"]
["District Name","Columbia (Walla Walla) School District","36400","Do not edit this value"]
["District Name","Colville School District","33115","Do not edit this value"]
["District Name","Concrete School District","29011","Do not edit this value"]
["District Name","Conway School District","29317","Do not edit this value"]
["District Name","Cosmopolis School District","14099","Do not edit this value"]
["District Name","Coulee-Hartline School District","13151","Do not edit this value"]
["District Name","Coupeville School District","15204","Do not edit this value"]
["District Name","Crescent School District","05313","Do not edit this value"]
["District Name","Creston School District","22073","Do not edit this value"]
["District Name","Curlew School District","10050","Do not edit this value"]
["District Name","Cusick School District","26059","Do not edit this value"]
["District Name","Damman School District","19007","Do not edit this value"]
["District Name","Darrington School District","31330","Do not edit this value"]
["District Name","Davenport School District","22207","Do not edit this value"]
["District Name","Dayton School District","07002","Do not edit this value"]
["District Name","Deer Park School District","32414","Do not edit this value"]
["District Name","Dieringer School District","27343","Do not edit this value"]
["District Name","Dixie School District","36101","Do not edit this value"]
["District Name","East Valley School District (Spokane)","32361","Do not edit this value"]
["District Name","East Valley School District (Yakima)","39090","Do not edit this value"]
["District Name","Eastmont School District","09206","Do not edit this value"]
["District Name","Easton School District","19028","Do not edit this value"]
["District Name","Eatonville School District","27404","Do not edit this value"]
["District Name","Edmonds School District","31015","Do not edit this value"]
["District Name","Ellensburg School District","19401","Do not edit this value"]
["District Name","Elma School District","14068","Do not edit this value"]
["District Name","Endicott School District","38308","Do not edit this value"]
["District Name","Entiat School District","04127","Do not edit this value"]
["District Name","Enumclaw School District","17216","Do not edit this value"]
["District Name","Ephrata School District","13165","Do not edit this value"]
["District Name","Evaline School District","21036","Do not edit this value"]
["District Name","Everett School District","31002","Do not edit this value"]
["District Name","Evergreen School District (Clark)","06114","Do not edit this value"]
["District Name","Evergreen School District (Stevens)","33205","Do not edit this value"]
["District Name","Federal Way School District","17210","Do not edit this value"]
["District Name","Ferndale School District","37502","Do not edit this value"]
["District Name","Fife School District","27417","Do not edit this value"]
["District Name","Finley School District","03053","Do not edit this value"]
["District Name","Franklin Pierce School District","27402","Do not edit this value"]
["District Name","Freeman School District","32358","Do not edit this value"]
["District Name","Garfield School District","38302","Do not edit this value"]
["District Name","Glenwood School District","20401","Do not edit this value"]
["District Name","Goldendale School District","20404","Do not edit this value"]
["District Name","Grand Coulee Dam School District","13301","Do not edit this value"]
["District Name","Grandview School District","39200","Do not edit this value"]
["District Name","Granger School District","39204","Do not edit this value"]
["District Name","Granite Falls School District","31332","Do not edit this value"]
["District Name","Grapeview School District","23054","Do not edit this value"]
["District Name","Great Northern School District","32312","Do not edit this value"]
["District Name","Green Mountain School District","06103","Do not edit this value"]
["District Name","Griffin School District","34324","Do not edit this value"]
["District Name","Harrington School District","22204","Do not edit this value"]
["District Name","Highland School District","39203","Do not edit this value"]
["District Name","Highline School District","17401","Do not edit this value"]
["District Name","Hockinson School District","06098","Do not edit this value"]
["District Name","Hood Canal School District","23404","Do not edit this value"]
["District Name","Hoquiam School District","14028","Do not edit this value"]
["District Name","Inchelium School District","10070","Do not edit this value"]
["District Name","Index School District","31063","Do not edit this value"]
["District Name","Issaquah School District","17411","Do not edit this value"]
["District Name","Kahlotus School District","11056","Do not edit this value"]
["District Name","Kalama School District","08402","Do not edit this value"]
["District Name","Keller School District","10003","Do not edit this value"]
["District Name","Kelso School District","08458","Do not edit this value"]
["District Name","Kennewick School District","03017","Do not edit this value"]
["District Name","Kent School District","17415","Do not edit this value"]
["District Name","Kettle Falls School District","33212","Do not edit this value"]
["District Name","Kiona-Benton City School District","03052","Do not edit this value"]
["District Name","Kittitas School District","19403","Do not edit this value"]
["District Name","Klickitat School District","20402","Do not edit this value"]
["District Name","La Center School District","06101","Do not edit this value"]
["District Name","La Conner School District","29311","Do not edit this value"]
["District Name","LaCrosse School District","38126","Do not edit this value"]
["District Name","Lake Chelan School District","04129","Do not edit this value"]
["District Name","Lake Quinault School District","14097","Do not edit this value"]
["District Name","Lake Stevens School District","31004","Do not edit this value"]
["District Name","Lake Washington School District","17414","Do not edit this value"]
["District Name","Lakewood School District","31306","Do not edit this value"]
["District Name","Lamont School District","38264","Do not edit this value"]
["District Name","Liberty School District","32362","Do not edit this value"]
["District Name","Lind School District","01158","Do not edit this value"]
["District Name","Longview School District","08122","Do not edit this value"]
["District Name","Loon Lake School District","33183","Do not edit this value"]
["District Name","Lopez School District","28144","Do not edit this value"]
["District Name","Lyle School District","20406","Do not edit this value"]
["District Name","Lynden School District","37504","Do not edit this value"]
["District Name","Mabton School District","39120","Do not edit this value"]
["District Name","Mansfield School District","09207","Do not edit this value"]
["District Name","Manson School District","04019","Do not edit this value"]
["District Name","Mary M Knight School District","23311","Do not edit this value"]
["District Name","Mary Walker School District","33207","Do not edit this value"]
["District Name","Marysville School District","31025","Do not edit this value"]
["District Name","McCleary School District","14065","Do not edit this value"]
["District Name","Mead School District","32354","Do not edit this value"]
["District Name","Medical Lake School District","32326","Do not edit this value"]
["District Name","Mercer Island School District","17400","Do not edit this value"]
["District Name","Meridian School District","37505","Do not edit this value"]
["District Name","Methow Valley School District","24350","Do not edit this value"]
["District Name","Mill A School District","30031","Do not edit this value"]
["District Name","Monroe School District","31103","Do not edit this value"]
["District Name","Montesano School District","14066","Do not edit this value"]
["District Name","Morton School District","21214","Do not edit this value"]
["District Name","Moses Lake School District","13161","Do not edit this value"]
["District Name","Mossyrock School District","21206","Do not edit this value"]
["District Name","Mount Adams School District","39209","Do not edit this value"]
["District Name","Mount Baker School District","37507","Do not edit this value"]
["District Name","Mount Pleasant School District","30029","Do not edit this value"]
["District Name","Mount Vernon School District","29320","Do not edit this value"]
["District Name","Mukilteo School District","31006","Do not edit this value"]
["District Name","Naches Valley School District","39003","Do not edit this value"]
["District Name","Napavine School District","21014","Do not edit this value"]
["District Name","Naselle-Grays River Valley School District","25155","Do not edit this value"]
["District Name","Nespelem School District","24014","Do not edit this value"]
["District Name","Newport School District","26056","Do not edit this value"]
["District Name","Nine Mile Falls School District","32325","Do not edit this value"]
["District Name","Nooksack Valley School District","37506","Do not edit this value"]
["District Name","North Beach School District","14064","Do not edit this value"]
["District Name","North Franklin School District","11051","Do not edit this value"]
["District Name","North Kitsap School District","18400","Do not edit this value"]
["District Name","North Mason School District","23403","Do not edit this value"]
["District Name","North River School District","25200","Do not edit this value"]
["District Name","North Thurston Public Schools","34003","Do not edit this value"]
["District Name","Northport School District","33211","Do not edit this value"]
["District Name","Northshore School District","17417","Do not edit this value"]
["District Name","Oak Harbor School District","15201","Do not edit this value"]
["District Name","Oakesdale School District","38324","Do not edit this value"]
["District Name","Oakville School District","14400","Do not edit this value"]
["District Name","Ocean Beach School District","25101","Do not edit this value"]
["District Name","Ocosta School District","14172","Do not edit this value"]
["District Name","Odessa School District","22105","Do not edit this value"]
["District Name","Okanogan School District","24105","Do not edit this value"]
["District Name","Olympia School District","34111","Do not edit this value"]
["District Name","Omak School District","24019","Do not edit this value"]
["District Name","Onalaska School District","21300","Do not edit this value"]
["District Name","Onion Creek School District","33030","Do not edit this value"]
["District Name","Orcas Island School District","28137","Do not edit this value"]
["District Name","Orchard Prairie School District","32123","Do not edit this value"]
["District Name","Orient School District","10065","Do not edit this value"]
["District Name","Orondo School District","09013","Do not edit this value"]
["District Name","Oroville School District","24410","Do not edit this value"]
["District Name","Orting School District","27344","Do not edit this value"]
["District Name","Othello School District","01147","Do not edit this value"]
["District Name","Palisades School District","09102","Do not edit this value"]
["District Name","Palouse School District","38301","Do not edit this value"]
["District Name","Pasco School District","11001","Do not edit this value"]
["District Name","Pateros School District","24122","Do not edit this value"]
["District Name","Paterson School District","03050","Do not edit this value"]
["District Name","Pe Ell School District","21301","Do not edit this value"]
["District Name","Peninsula School District","27401","Do not edit this value"]
["District Name","Pioneer School District","23402","Do not edit this value"]
["District Name","Pomeroy School District","12110","Do not edit this value"]
["District Name","Port Angeles School District","05121","Do not edit this value"]
["District Name","Port Townsend School District","16050","Do not edit this value"]
["District Name","Prescott School District","36402","Do not edit this value"]
["District Name","Prosser School District","03116","Do not edit this value"]
["District Name","Pullman School District","38267","Do not edit this value"]
["District Name","Puyallup School District","27003","Do not edit this value"]
["District Name","Queets-Clearwater School District","16020","Do not edit this value"]
["District Name","Quilcene School District","16048","Do not edit this value"]
["District Name","Quillayute Valley School District","05402","Do not edit this value"]
["District Name","Quincy School District","13144","Do not edit this value"]
["District Name","Rainier School District","34307","Do not edit this value"]
["District Name","Raymond School District","25116","Do not edit this value"]
["District Name","Reardan-Edwall School District","22009","Do not edit this value"]
["District Name","Renton School District","17403","Do not edit this value"]
["District Name","Republic School District","10309","Do not edit this value"]
["District Name","Richland School District","03400","Do not edit this value"]
["District Name","Ridgefield School District","06122","Do not edit this value"]
["District Name","Ritzville School District","01160","Do not edit this value"]
["District Name","Riverside School District","32416","Do not edit this value"]
["District Name","Riverview School District","17407","Do not edit this value"]
["District Name","Rochester School District","34401","Do not edit this value"]
["District Name","Roosevelt School District","20403","Do not edit this value"]
["District Name","Rosalia School District","38320","Do not edit this value"]
["District Name","Royal School District","13160","Do not edit this value"]
["District Name","San Juan Island School District","28149","Do not edit this value"]
["District Name","Satsop School District","14104","Do not edit this value"]
["District Name","Seattle Public Schools","17001","Do not edit this value"]
["District Name","Sedro-Woolley School District","29101","Do not edit this value"]
["District Name","Selah School District","39119","Do not edit this value"]
["District Name","Selkirk School District","26070","Do not edit this value"]
["District Name","Sequim School District","05323","Do not edit this value"]
["District Name","Shaw Island School District","28010","Do not edit this value"]
["District Name","Shelton School District","23309","Do not edit this value"]
["District Name","Shoreline School District","17412","Do not edit this value"]
["District Name","Skamania School District","30002","Do not edit this value"]
["District Name","Skykomish School District","17404","Do not edit this value"]
["District Name","Snohomish School District","31201","Do not edit this value"]
["District Name","Snoqualmie Valley School District","17410","Do not edit this value"]
["District Name","Soap Lake School District","13156","Do not edit this value"]
["District Name","South Bend School District","25118","Do not edit this value"]
["District Name","South Kitsap School District","18402","Do not edit this value"]
["District Name","South Whidbey School District","15206","Do not edit this value"]
["District Name","Southside School District","23042","Do not edit this value"]
["District Name","Spokane School District","32081","Do not edit this value"]
["District Name","Sprague School District","22008","Do not edit this value"]
["District Name","St. John School District","38322","Do not edit this value"]
["District Name","Stanwood-Camano School District","31401","Do not edit this value"]
["District Name","Star School District","11054","Do not edit this value"]
["District Name","Starbuck School District","07035","Do not edit this value"]
["District Name","Stehekin School District","04069","Do not edit this value"]
["District Name","Steilacoom Hist. School District","27001","Do not edit this value"]
["District Name","Steptoe School District","38304","Do not edit this value"]
["District Name","Stevenson-Carson School District","30303","Do not edit this value"]
["District Name","Sultan School District","31311","Do not edit this value"]
["District Name","Summit Valley School District","33202","Do not edit this value"]
["District Name","Sumner School District","27320","Do not edit this value"]
["District Name","Sunnyside School District","39201","Do not edit this value"]
["District Name","Tacoma School District","27010","Do not edit this value"]
["District Name","Taholah School District","14077","Do not edit this value"]
["District Name","Tahoma School District","17409","Do not edit this value"]
["District Name","Tekoa School District","38265","Do not edit this value"]
["District Name","Tenino School District","34402","Do not edit this value"]
["District Name","Thorp School District","19400","Do not edit this value"]
["District Name","Toledo School District","21237","Do not edit this value"]
["District Name","Tonasket School District","24404","Do not edit this value"]
["District Name","Toppenish School District","39202","Do not edit this value"]
["District Name","Touchet School District","36300","Do not edit this value"]
["District Name","Toutle Lake School District","08130","Do not edit this value"]
["District Name","Trout Lake School District","20400","Do not edit this value"]
["District Name","Tukwila School District","17406","Do not edit this value"]
["District Name","Tumwater School District","34033","Do not edit this value"]
["District Name","Union Gap School District","39002","Do not edit this value"]
["District Name","University Place School District","27083","Do not edit this value"]
["District Name","Valley School District","33070","Do not edit this value"]
["District Name","Vancouver School District","06037","Do not edit this value"]
["District Name","Vashon Island School District","17402","Do not edit this value"]
["District Name","Wahkiakum School District","35200","Do not edit this value"]
["District Name","Wahluke School District","13073","Do not edit this value"]
["District Name","Waitsburg School District","36401","Do not edit this value"]
["District Name","Walla Walla Public Schools","36140","Do not edit this value"]
["District Name","Wapato School District","39207","Do not edit this value"]
["District Name","Warden School District","13146","Do not edit this value"]
["District Name","Washougal School District","06112","Do not edit this value"]
["District Name","Washtucna School District","01109","Do not edit this value"]
["District Name","Waterville School District","09209","Do not edit this value"]
["District Name","Wellpinit School District","33049","Do not edit this value"]
["District Name","Wenatchee School District","04246","Do not edit this value"]
["District Name","West Valley School District (Spokane)","32363","Do not edit this value"]
["District Name","West Valley School District (Yakima)","39208","Do not edit this value"]
["District Name","White Pass School District","21303","Do not edit this value"]
["District Name","White River School District","27416","Do not edit this value"]
["District Name","White Salmon Valley School District","20405","Do not edit this value"]
["District Name","Wilbur School District","22200","Do not edit this value"]
["District Name","Willapa Valley School District","25160","Do not edit this value"]
["District Name","Wilson Creek School District","13167","Do not edit this value"]
["District Name","Winlock School District","21232","Do not edit this value"]
["District Name","Wishkah Valley School District","14117","Do not edit this value"]
["District Name","Wishram School District","20094","Do not edit this value"]
["District Name","Woodland School District","08404","Do not edit this value"]
["District Name","Yakima School District","39007","Do not edit this value"]
["District Name","Yelm School District","34002","Do not edit this value"]
["District Name","Zillah School District","39205","Do not edit this value"]