{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["CSA Date Calc Details (ADT)","CSA Date Calc Details (Non-ADT)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":0,"comments":10,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"CSA Date Calc Details (ADT)","index":0,"n_rows":91,"n_cols":23,"rows_kept":91,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
{"$rows_empty":10}
["Course","Credits","Cost","Start Date","End Date","Length of Class Days","Length of Class Weeks","Contact Hours","Contact Weeks","Commitment Weeks","Commitment Days","CSA Date","Total Commitment Days (Incl Weekend/Holiday)","Cost/Commitment Day","Separation Date","Days Unfulfilled","Amount Due",null,"CSA Date Override (only for ADT)",null,null,"Holiday","Date"]
["BIO 101",3,100,"2013-07-01","2013-08-31",62,8.86,26.58,0.66,1.98,14,"2013-09-20",20,5,"2013-09-13",8,40,{"$nulls":4},"New Year's Day                     ","2013-01-01"]
["Trng & Dev",{"$nulls":4},0,0,0,0,0,0,"00:00:00",0,0,"2013-09-13",0,0,{"$nulls":4},"Martin Luther King, Jr. Birthday","2013-01-21"]
["Emp Law",{"$nulls":4},0,0,0,0,0,0,"00:00:00",0,0,"2013-09-13",0,0,{"$nulls":4},"President's Day          ","2013-02-18"]
["Staffing",{"$nulls":4},0,0,0,0,0,0,"00:00:00",0,0,"2013-09-17",0,0,{"$nulls":4},"Memorial Day                       ","2013-05-27"]
["Compensation",{"$nulls":4},0,0,0,0,0,0,"00:00:00",0,0,"2013-09-17",0,0,{"$nulls":4},"Independence Day                   ","2013-07-04"]
["Labor-Mgmt Rel",{"$nulls":4},0,0,0,0,0,0,"00:00:00",0,0,"2013-09-17",0,0,{"$nulls":4},"Labor Day                          ","2013-09-02"]
["Intergrated Studies in HR",{"$nulls":4},0,0,0,0,0,0,"00:00:00",0,0,"2013-09-17",0,0,{"$nulls":4},"Columbus Day                       ","2013-10-14"]
["Ethics, Values & Legal Issues",{"$nulls":4},0,0,0,0,0,0,"00:00:00",0,0,"2013-09-17",0,0,{"$nulls":4},"Veterans Day                       ","2013-11-11"]
["Career Management ",{"$nulls":4},0,0,0,0,0,0,"00:00:00",0,0,"2013-09-17",0,0,{"$nulls":4},"Thanksgiving Day                   ","2013-11-28"]
["Employee Benefits",{"$nulls":4},0,0,0,0,0,0,"00:00:00",0,0,"2013-09-17",0,0,{"$nulls":4},"Christmas Day                      ","2013-12-25"]
["Course 10",{"$nulls":4},0,0,0,0,0,0,"00:00:00",0,0,"2013-09-17",0,0,{"$nulls":4},"New Year's Day                     ","2014-01-01"]
["Course 11",{"$nulls":4},0,0,0,0,0,0,"00:00:00",0,0,"2013-09-17",0,0,{"$nulls":4},"Martin Luther King, Jr. Birthday","2014-01-20"]
["Course 12",{"$nulls":4},0,0,0,0,0,0,"00:00:00",0,0,"2013-09-17",0,0,{"$nulls":4},"President's Day          ","2014-02-17"]
["Course 13",{"$nulls":4},0,0,0,0,0,0,"00:00:00",0,0,"2013-09-17",0,0,{"$nulls":4},"Memorial Day                       ","2014-05-26"]
["Course 14",{"$nulls":4},0,0,0,0,0,0,"00:00:00",0,0,"2013-09-17",0,0,{"$nulls":4},"Independence Day                   ","2014-07-04"]
["Course 15",{"$nulls":4},0,0,0,0,0,0,"00:00:00",0,0,"2013-09-17",0,0,{"$nulls":4},"Labor Day                          ","2014-09-01"]
["Course 16",{"$nulls":4},0,0,0,0,0,0,"00:00:00",0,0,"2013-09-17",0,0,{"$nulls":4},"Columbus Day                       ","2014-10-13"]
["Course 17",{"$nulls":4},0,0,0,0,0,0,"00:00:00",0,0,"2013-09-17",0,0,{"$nulls":4},"Veterans Day                       ","2014-11-11"]
["Course 18",{"$nulls":4},0,0,0,0,0,0,"00:00:00",0,0,"2013-09-17",0,0,{"$nulls":4},"Thanksgiving Day                   ","2014-11-27"]
["Course 19",{"$nulls":4},0,0,0,0,0,0,"00:00:00",0,0,"2013-09-17",0,0,{"$nulls":4},"Christmas Day                      ","2014-12-25"]
["Course 20",{"$nulls":4},0,0,0,0,0,0,"00:00:00",0,0,"2013-09-17",0,0,{"$nulls":4},"New Year's Day                     ","2015-01-01"]
[{"$nulls":13},"00:00:00",0,{"$nulls":6},"Martin Luther King, Jr. Birthday","2015-01-19"]
["Continued Service Agreement Expiration Date",{"$nulls":18},"00:00:00",null,"President's Day          ","2015-02-16"]
["Period of Service Obligation (Number of Weeks)",{"$nulls":18},0,null,"Memorial Day                       ","2015-05-25"]
[{"$nulls":21},"Independence Day                   ","2015-07-03"]
[{"$nulls":21},"Labor Day                          ","2015-09-07"]
[{"$nulls":21},"Columbus Day                       ","2015-10-12"]
[{"$nulls":21},"Veterans Day                       ","2015-11-11"]
[{"$nulls":21},"Thanksgiving Day                   ","2015-11-26"]
[{"$nulls":21},"Christmas Day                      ","2015-12-25"]
[{"$nulls":21},"New Year's Day                     ","2016-01-01"]
[{"$nulls":21},"Martin Luther King, Jr. Birthday","2016-01-18"]
[{"$nulls":21},"President's Day          ","2016-02-15"]
[{"$nulls":21},"Memorial Day                       ","2016-05-30"]
[{"$nulls":21},"Independence Day                   ","2016-07-04"]
[{"$nulls":21},"Labor Day                          ","2016-09-05"]
[{"$nulls":21},"Columbus Day                       ","2016-10-10"]
[{"$nulls":21},"Veterans Day                       ","2016-11-11"]
[{"$nulls":21},"Thanksgiving Day                   ","2016-11-24"]
[{"$nulls":21},"Christmas Day                      ","2016-12-26"]
[{"$nulls":21},"New Year's Day                     ","2017-01-02"]
[{"$nulls":21},"Martin Luther King, Jr. Birthday","2017-01-16"]
[{"$nulls":21},"President's Day          ","2017-02-20"]
[{"$nulls":21},"Memorial Day                       ","2017-05-29"]
[{"$nulls":21},"Independence Day                   ","2017-07-04"]
[{"$nulls":21},"Labor Day                          ","2017-09-04"]
[{"$nulls":21},"Columbus Day                       ","2017-10-09"]
[{"$nulls":21},"Veterans Day                       ","2017-11-10"]
[{"$nulls":21},"Thanksgiving Day                   ","2017-11-23"]
[{"$nulls":21},"Christmas Day                      ","2017-12-25"]
[{"$nulls":21},"New Year's Day                     ","2018-01-01"]
[{"$nulls":21},"Martin Luther King, Jr. Birthday","2018-01-15"]
[{"$nulls":21},"President's Day          ","2018-02-19"]
[{"$nulls":21},"Memorial Day                       ","2018-05-28"]
[{"$nulls":21},"Independence Day                   ","2018-07-04"]
[{"$nulls":21},"Labor Day                          ","2018-09-03"]
[{"$nulls":21},"Columbus Day                       ","2018-10-08"]
[{"$nulls":21},"Veterans Day                       ","2018-11-12"]
[{"$nulls":21},"Thanksgiving Day                   ","2018-11-22"]
[{"$nulls":21},"Christmas Day                      ","2018-12-25"]
[{"$nulls":21},"New Year's Day                     ","2019-01-01"]
[{"$nulls":21},"Martin Luther King, Jr. Birthday","2019-01-21"]
[{"$nulls":21},"President's Day          ","2019-02-18"]
[{"$nulls":21},"Memorial Day                       ","2019-05-27"]
[{"$nulls":21},"Independence Day                   ","2019-07-04"]
[{"$nulls":21},"Labor Day                          ","2019-09-02"]
[{"$nulls":21},"Columbus Day                       ","2019-10-14"]
[{"$nulls":21},"Veterans Day                       ","2019-11-11"]
[{"$nulls":21},"Thanksgiving Day                   ","2019-11-18"]
[{"$nulls":21},"Christmas Day                      ","2019-12-25"]
[{"$nulls":21},"New Year's Day                     ","2020-01-01"]
[{"$nulls":21},"Martin Luther King, Jr. Birthday","2020-01-20"]
[{"$nulls":21},"President's Day          ","2020-02-17"]
[{"$nulls":21},"Memorial Day                       ","2020-05-25"]
[{"$nulls":21},"Independence Day                   ","2020-07-03"]
[{"$nulls":21},"Labor Day                          ","2020-09-07"]
[{"$nulls":21},"Columbus Day                       ","2020-10-12"]
[{"$nulls":21},"Veterans Day                       ","2020-11-11"]
[{"$nulls":21},"Thanksgiving Day                   ","2020-11-26"]
[{"$nulls":21},"Christmas Day                      ","2020-12-25"]

{"sheet":"CSA Date Calc Details (Non-ADT)","index":1,"n_rows":81,"n_cols":15,"rows_kept":81,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Course","Cost","Start Date","End Date","Length of Class","Adjusted Length","CSA Date","Cost/Commitment Day","Separation Date","Days Unfulfilled","Amount Due",null,null,"Holiday","Date"]
["Course 1",100,"2013-07-01","2013-08-31",62,44,"2014-01-11",0.75,"2013-09-13",121,90.75,null,null,"New Year's Day                     ","2013-01-01"]
["Course 2",200,"2013-11-01","2013-12-31",61,40,"2014-05-01",1.64,"2013-09-13",231,200,null,null,"Martin Luther King, Jr. Birthday","2013-01-21"]
["Course 3",1200,"2013-07-01","2013-08-18",49,34,"2013-11-29",11.54,"2013-09-13",78,900.1199999999999,null,null,"President's Day          ","2013-02-18"]
[{"$nulls":13},"Memorial Day                       ","2013-05-27"]
[{"$nulls":13},"Independence Day                   ","2013-07-04"]
[{"$nulls":13},"Labor Day                          ","2013-09-02"]
[{"$nulls":13},"Columbus Day                       ","2013-10-14"]
[{"$nulls":13},"Veterans Day                       ","2013-11-11"]
[{"$nulls":13},"Thanksgiving Day                   ","2013-11-28"]
[{"$nulls":13},"Christmas Day                      ","2013-12-25"]
[{"$nulls":13},"New Year's Day                     ","2014-01-01"]
[{"$nulls":13},"Martin Luther King, Jr. Birthday","2014-01-20"]
[{"$nulls":13},"President's Day          ","2014-02-17"]
[{"$nulls":13},"Memorial Day                       ","2014-05-26"]
[{"$nulls":13},"Independence Day                   ","2014-07-04"]
[{"$nulls":13},"Labor Day                          ","2014-09-01"]
[{"$nulls":13},"Columbus Day                       ","2014-10-13"]
[{"$nulls":13},"Veterans Day                       ","2014-11-11"]
[{"$nulls":13},"Thanksgiving Day                   ","2014-11-27"]
[{"$nulls":13},"Christmas Day                      ","2014-12-25"]
[{"$nulls":13},"New Year's Day                     ","2015-01-01"]
[{"$nulls":13},"Martin Luther King, Jr. Birthday","2015-01-19"]
[{"$nulls":13},"President's Day          ","2015-02-16"]
[{"$nulls":13},"Memorial Day                       ","2015-05-25"]
[{"$nulls":13},"Independence Day                   ","2015-07-03"]
[{"$nulls":13},"Labor Day                          ","2015-09-07"]
[{"$nulls":13},"Columbus Day                       ","2015-10-12"]
[{"$nulls":13},"Veterans Day                       ","2015-11-11"]
[{"$nulls":13},"Thanksgiving Day                   ","2015-11-26"]
[{"$nulls":13},"Christmas Day                      ","2015-12-25"]
[{"$nulls":13},"New Year's Day                     ","2016-01-01"]
[{"$nulls":13},"Martin Luther King, Jr. Birthday","2016-01-18"]
[{"$nulls":13},"President's Day          ","2016-02-15"]
[{"$nulls":13},"Memorial Day                       ","2016-05-30"]
[{"$nulls":13},"Independence Day                   ","2016-07-04"]
[{"$nulls":13},"Labor Day                          ","2016-09-05"]
[{"$nulls":13},"Columbus Day                       ","2016-10-10"]
[{"$nulls":13},"Veterans Day                       ","2016-11-11"]
[{"$nulls":13},"Thanksgiving Day                   ","2016-11-24"]
[{"$nulls":13},"Christmas Day                      ","2016-12-26"]
[{"$nulls":13},"New Year's Day                     ","2017-01-02"]
[{"$nulls":13},"Martin Luther King, Jr. Birthday","2017-01-16"]
[{"$nulls":13},"President's Day          ","2017-02-20"]
[{"$nulls":13},"Memorial Day                       ","2017-05-29"]
[{"$nulls":13},"Independence Day                   ","2017-07-04"]
[{"$nulls":13},"Labor Day                          ","2017-09-04"]
[{"$nulls":13},"Columbus Day                       ","2017-10-09"]
[{"$nulls":13},"Veterans Day                       ","2017-11-10"]
[{"$nulls":13},"Thanksgiving Day                   ","2017-11-23"]
[{"$nulls":13},"Christmas Day                      ","2017-12-25"]
[{"$nulls":13},"New Year's Day                     ","2018-01-01"]
[{"$nulls":13},"Martin Luther King, Jr. Birthday","2018-01-15"]
[{"$nulls":13},"President's Day          ","2018-02-19"]
[{"$nulls":13},"Memorial Day                       ","2018-05-28"]
[{"$nulls":13},"Independence Day                   ","2018-07-04"]
[{"$nulls":13},"Labor Day                          ","2018-09-03"]
[{"$nulls":13},"Columbus Day                       ","2018-10-08"]
[{"$nulls":13},"Veterans Day                       ","2018-11-12"]
[{"$nulls":13},"Thanksgiving Day                   ","2018-11-22"]
[{"$nulls":13},"Christmas Day                      ","2018-12-25"]
[{"$nulls":13},"New Year's Day                     ","2019-01-01"]
[{"$nulls":13},"Martin Luther King, Jr. Birthday","2019-01-21"]
[{"$nulls":13},"President's Day          ","2019-02-18"]
[{"$nulls":13},"Memorial Day                       ","2019-05-27"]
[{"$nulls":13},"Independence Day                   ","2019-07-04"]
[{"$nulls":13},"Labor Day                          ","2019-09-02"]
[{"$nulls":13},"Columbus Day                       ","2019-10-14"]
[{"$nulls":13},"Veterans Day                       ","2019-11-11"]
[{"$nulls":13},"Thanksgiving Day                   ","2019-11-18"]
[{"$nulls":13},"Christmas Day                      ","2019-12-25"]
[{"$nulls":13},"New Year's Day                     ","2020-01-01"]
[{"$nulls":13},"Martin Luther King, Jr. Birthday","2020-01-20"]
[{"$nulls":13},"President's Day          ","2020-02-17"]
[{"$nulls":13},"Memorial Day                       ","2020-05-25"]
[{"$nulls":13},"Independence Day                   ","2020-07-03"]
[{"$nulls":13},"Labor Day                          ","2020-09-07"]
[{"$nulls":13},"Columbus Day                       ","2020-10-12"]
[{"$nulls":13},"Veterans Day                       ","2020-11-11"]
[{"$nulls":13},"Thanksgiving Day                   ","2020-11-26"]
[{"$nulls":13},"Christmas Day                      ","2020-12-25"]