{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Sheet Entry","Key","Already Keyed","Sheet Info","Valid Effective Dates"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":27,"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":"Sheet Entry","index":0,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Enrollment Type","First Initial","Middle Initial","Last Name","SSN","Account Type","Routing Number","Account Number"]

{"sheet":"Key","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Already Keyed","index":2,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Enrollment Type","First Initial","Middle Initial","Last Name","SSN","Account Type","Routing Number","Account Number","File Keyed To"]

{"sheet":"Sheet Info","index":3,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[0,0,1,4],[6,1,6,3],[9,1,9,3],[10,1,10,3],[5,5,5,7],[2,1,2,3],[3,1,3,3],[11,1,11,3],[12,1,12,3],[4,1,4,3],[5,1,5,3],[4,5,4,7]]}
["Sheet Info"]
[]
[null,"Number of Records"]
[null,0]
[null,"Social Security Number Format"]
[null,123456789]
[null,"Batch ID"]
[null,"Agency",null,"Form Type"]
[null,null,null,699]
[null,"Enrollment Types"]
[null,"New"]
[null,"Change"]
[null,"Cancel"]
[null,"Account Types"]
[null,"Checking"]
[null,"Savings"]

{"sheet":"Valid Effective Dates","index":4,"n_rows":489,"n_cols":2,"rows_kept":489,"cut":false,"hidden":true,"merged":[]}
["Valid 699 Effective Dates","Next 12 Effective dates"]
["2020-09-02",{"$f":"MIN(IF($A$2:$A$489>TODAY(),$A$2:$A$489))","v":"2021-08-03"}]
["2020-09-03",{"$f":"OFFSET(INDEX($A$2:$A$489,MATCH(B2,$A$2:$A$489,0),1),1,0)","v":"2021-08-04"}]
["2020-09-04",{"$f":"OFFSET(INDEX($A$2:$A$489,MATCH(B3,$A$2:$A$489,0),1),1,0)","v":"2021-08-05"}]
["2020-09-09","2021-08-06"]
["2020-09-10","2021-08-09"]
["2020-09-11","2021-08-10"]
["2020-09-14","2021-08-11"]
["2020-09-15","2021-08-12"]
["2020-10-02","2021-08-13"]
["2020-10-05","2021-09-02"]
["2020-10-06","2021-09-03"]
["2020-10-07","2021-09-08"]
["2020-10-08"]
["2020-10-09"]
["2020-10-12"]
["2020-10-13"]
["2020-10-14"]
["2020-10-15"]
["2020-11-03"]
["2020-11-04"]
["2020-11-05"]
["2020-11-06"]
["2020-11-09"]
["2020-11-10"]
["2020-12-02"]
["2020-12-03"]
["2020-12-04"]
["2020-12-07"]
["2020-12-08"]
["2020-12-09"]
["2020-12-10"]
["2020-12-11"]
["2020-12-14"]
["2021-01-05"]
["2021-01-06"]
["2021-01-07"]
["2021-01-08"]
["2021-01-11"]
["2021-01-12"]
["2021-01-13"]
["2021-01-14"]
["2021-02-02"]
["2021-02-03"]
["2021-02-04"]
["2021-02-05"]
["2021-02-08"]
["2021-02-09"]
["2021-02-10"]
["2021-02-11"]
["2021-03-02"]
["2021-03-03"]
["2021-03-04"]
["2021-03-05"]
["2021-03-08"]
["2021-03-09"]
["2021-03-10"]
["2021-03-11"]
["2021-03-12"]
["2021-03-15"]
["2021-04-02"]
["2021-04-05"]
["2021-04-06"]
["2021-04-07"]
["2021-04-08"]
["2021-04-09"]
["2021-04-12"]
["2021-04-13"]
["2021-04-14"]
["2021-04-15"]
["2021-05-04"]
["2021-05-05"]
["2021-05-06"]
["2021-05-07"]
["2021-05-10"]
["2021-05-11"]
["2021-05-12"]
["2021-05-13"]
["2021-06-02"]
["2021-06-03"]
["2021-06-04"]
["2021-06-07"]
["2021-06-08"]
["2021-06-09"]
["2021-06-10"]
["2021-06-11"]
["2021-06-14"]
["2021-07-02"]
["2021-07-07"]
["2021-07-08"]
["2021-07-09"]
["2021-07-12"]
["2021-07-13"]
["2021-07-14"]
["2021-07-15"]
["2021-08-03"]
["2021-08-04"]
["2021-08-05"]
["2021-08-06"]
["2021-08-09"]
["2021-08-10"]
["2021-08-11"]
["2021-08-12"]
["2021-08-13"]
["2021-09-02"]
["2021-09-03"]
["2021-09-08"]
["2021-09-09"]
["2021-09-10"]
["2021-09-13"]
["2021-09-14"]
["2021-09-15"]
["2021-10-04"]
["2021-10-05"]
["2021-10-06"]
["2021-10-07"]
["2021-10-08"]
["2021-10-11"]
["2021-10-12"]
["2021-10-13"]
["2021-10-14"]
["2021-11-02"]
["2021-11-03"]
["2021-11-04"]
["2021-11-05"]
["2021-11-08"]
["2021-11-09"]
["2021-11-10"]
["2021-12-02"]
["2021-12-03"]
["2021-12-06"]
["2021-12-07"]
["2021-12-08"]
["2021-12-09"]
["2021-12-10"]
["2021-12-13"]
["2021-12-14"]
["2021-12-15"]
["2022-01-04"]
["2022-01-05"]
["2022-01-06"]
["2022-01-07"]
["2022-01-10"]
["2022-01-11"]
["2022-01-12"]
["2022-01-13"]
["2022-01-14"]
["2022-02-02"]
["2022-02-03"]
["2022-02-04"]
["2022-02-07"]
["2022-02-08"]
["2022-02-09"]
["2022-02-10"]
["2022-03-02"]
["2022-03-03"]
["2022-03-04"]
["2022-03-07"]
["2022-03-08"]
["2022-03-09"]
["2022-03-10"]
["2022-03-11"]
["2022-03-14"]
["2022-03-15"]
["2022-04-04"]
["2022-04-05"]
["2022-04-06"]
["2022-04-07"]
["2022-04-08"]
["2022-04-11"]
["2022-04-12"]
["2022-04-13"]
["2022-04-14"]
["2022-05-03"]
["2022-05-04"]
["2022-05-05"]
["2022-05-06"]
["2022-05-09"]
["2022-05-10"]
["2022-05-11"]
["2022-05-12"]
["2022-05-13"]
["2022-06-02"]
["2022-06-03"]
["2022-06-06"]
["2022-06-07"]
["2022-06-08"]
["2022-06-09"]
["2022-06-10"]
["2022-06-13"]
["2022-06-14"]
["2022-07-06"]
["2022-07-07"]
["2022-07-08"]
["2022-07-11"]
["2022-07-12"]
["2022-07-13"]
["2022-07-14"]
["2022-08-02"]
["2022-08-03"]
["2022-08-04"]
["2022-08-05"]
["2022-08-08"]
["2022-08-09"]
["2022-08-10"]
["2022-08-11"]
["2022-08-12"]
["2022-08-15"]
["2022-09-02"]
["2022-09-07"]
["2022-09-08"]
["2022-09-09"]
["2022-09-12"]
["2022-09-13"]
["2022-09-14"]
["2022-09-15"]
["2022-10-04"]
["2022-10-05"]
["2022-10-06"]
["2022-10-07"]
["2022-10-10"]
["2022-10-11"]
["2022-10-12"]
["2022-10-13"]
["2022-10-14"]
["2022-11-02"]
["2022-11-03"]
["2022-11-04"]
["2022-11-07"]
["2022-11-08"]
["2022-11-09"]
["2022-11-10"]
["2022-12-02"]
["2022-12-05"]
["2022-12-06"]
["2022-12-07"]
["2022-12-08"]
["2022-12-09"]
["2022-12-12"]
["2022-12-13"]
["2023-01-04"]
["2023-01-05"]
["2023-01-06"]
["2023-01-09"]
["2023-01-10"]
["2023-01-11"]
["2023-01-12"]
["2023-01-13"]
["2023-02-02"]
["2023-02-03"]
["2023-02-06"]
["2023-02-07"]
["2023-02-08"]
["2023-02-09"]
["2023-02-10"]
["2023-03-02"]
["2023-03-03"]
["2023-03-06"]
["2023-03-07"]
["2023-03-08"]
["2023-03-09"]
["2023-03-10"]
["2023-03-13"]
["2023-03-14"]
["2023-03-15"]
["2023-04-04"]
["2023-04-05"]
["2023-04-06"]
["2023-04-07"]
["2023-04-10"]
["2023-04-11"]
["2023-04-12"]
["2023-04-13"]
["2023-05-02"]
["2023-05-03"]
["2023-05-04"]
["2023-05-05"]
["2023-05-08"]
["2023-05-09"]
["2023-05-10"]
["2023-05-11"]
["2023-05-12"]
["2023-05-15"]
["2023-06-02"]
["2023-06-05"]
["2023-06-06"]
["2023-06-07"]
["2023-06-08"]
["2023-06-09"]
["2023-06-12"]
["2023-06-13"]
["2023-06-14"]
["2023-07-06"]
["2023-07-07"]
["2023-07-10"]
["2023-07-11"]
["2023-07-12"]
["2023-07-13"]
["2023-07-14"]
["2023-08-02"]
["2023-08-03"]
["2023-08-04"]
["2023-08-07"]
["2023-08-08"]
["2023-08-09"]
["2023-08-10"]
["2023-08-11"]
["2023-08-14"]
["2023-08-15"]
["2023-09-06"]
["2023-09-07"]
["2023-09-08"]
["2023-09-11"]
["2023-09-12"]
["2023-09-13"]
["2023-09-14"]
["2023-10-03"]
["2023-10-04"]
["2023-10-05"]
["2023-10-06"]
["2023-10-09"]
["2023-10-10"]
["2023-10-11"]
["2023-10-12"]
["2023-10-13"]
["2023-11-02"]
["2023-11-03"]
["2023-11-06"]
["2023-11-07"]
["2023-11-08"]
["2023-11-09"]
["2023-12-04"]
["2023-12-05"]
["2023-12-06"]
["2023-12-07"]
["2023-12-08"]
["2023-12-11"]
["2023-12-12"]
["2024-01-03"]
["2024-01-04"]
["2024-01-05"]
["2024-01-08"]
["2024-01-09"]
["2024-01-10"]
["2024-01-11"]
["2024-01-12"]
["2024-02-02"]
["2024-02-05"]
["2024-02-06"]
["2024-02-07"]
["2024-02-08"]
["2024-02-09"]
["2024-02-12"]
["2024-02-13"]
["2024-02-14"]
["2024-03-04"]
["2024-03-05"]
["2024-03-06"]
["2024-03-07"]
["2024-03-08"]
["2024-03-11"]
["2024-03-12"]
["2024-03-13"]
["2024-03-14"]
["2024-04-03"]
["2024-04-04"]
["2024-04-05"]
["2024-04-08"]
["2024-04-09"]
["2024-04-10"]
["2024-04-11"]
["2024-04-12"]
["2024-04-15"]
["2024-05-02"]
["2024-05-03"]
["2024-05-06"]
["2024-05-07"]
["2024-05-08"]
["2024-05-09"]
["2024-05-10"]
["2024-05-13"]
["2024-05-14"]
["2024-06-04"]
["2024-06-05"]
["2024-06-06"]
["2024-06-07"]
["2024-06-10"]
["2024-06-11"]
["2024-06-12"]
["2024-07-02"]
["2024-07-03"]
["2024-07-08"]
["2024-07-09"]
["2024-07-10"]
["2024-07-11"]
["2024-07-12"]
["2024-07-15"]
["2024-08-02"]
["2024-08-05"]
["2024-08-06"]
["2024-08-07"]
["2024-08-08"]
["2024-08-09"]
["2024-08-12"]
["2024-08-13"]
["2024-08-14"]
["2024-09-04"]
["2024-09-05"]
["2024-09-06"]
["2024-09-09"]
["2024-09-10"]
["2024-09-11"]
["2024-09-12"]
["2024-09-13"]
["2024-10-02"]
["2024-10-03"]
["2024-10-04"]
["2024-10-07"]
["2024-10-08"]
["2024-10-09"]
["2024-10-10"]
["2024-10-11"]
["2024-10-14"]
["2024-10-15"]
["2024-11-04"]
["2024-11-05"]
["2024-11-06"]
["2024-11-07"]
["2024-11-08"]
["2024-12-03"]
["2024-12-04"]
["2024-12-05"]
["2024-12-06"]
["2024-12-09"]
["2024-12-10"]
["2024-12-11"]
["2024-12-12"]
["2025-01-03"]
["2025-01-06"]
["2025-01-07"]
["2025-01-08"]
["2025-01-09"]
["2025-01-10"]
["2025-01-13"]
["2025-01-14"]
["2025-01-15"]
["2025-02-04"]
["2025-02-05"]
["2025-02-06"]
["2025-02-07"]
["2025-02-10"]
["2025-02-11"]
["2025-02-12"]
["2025-02-13"]
["2025-03-04"]
["2025-03-05"]
["2025-03-06"]
["2025-03-07"]
["2025-03-10"]
["2025-03-11"]
["2025-03-12"]
["2025-03-13"]
["2025-04-02"]
["2025-04-03"]
["2025-04-04"]
["2025-04-07"]
["2025-04-08"]
["2025-04-09"]
["2025-04-10"]
["2025-04-11"]
["2025-04-14"]
["2025-04-15"]
["2025-05-02"]
["2025-05-05"]
["2025-05-06"]
["2025-05-07"]
["2025-05-08"]
["2025-05-09"]
["2025-05-12"]
["2025-05-13"]
["2025-05-14"]
["2025-06-03"]
["2025-06-04"]
["2025-06-05"]
["2025-06-06"]
["2025-06-09"]
["2025-06-10"]
["2025-06-11"]
["2025-06-12"]