{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":49,"n_cols":17,"rows_kept":49,"cut":false,"hidden":false,"merged":[[25,6,26,6],[4,6,6,6],[5,4,6,4],[7,4,7,6],[15,6,16,6],[17,4,17,6],[14,4,14,5],[15,4,15,5],[16,4,16,5],[24,4,24,5],[25,4,25,5],[26,4,26,5],[27,4,27,6],[35,6,36,6],[37,4,37,6],[45,6,46,6],[47,4,47,6],[34,4,34,5],[35,4,35,5],[36,4,36,5],[44,4,44,5],[45,4,45,5],[46,4,46,5]]}
[null,null,null,null,null,null,null,null,null,null,"Enter Information in Yellow fields below"]
[null,null,null,null,null,null,null,null,null,null,"Card # 1",null,"Card # 2",null,"Card # 3",null,"Card # 4"]
[null,null,null,null,null,null,null,null,null,"Expiration Date","2025-12-31",null,"2025-12-31",null,"2025-12-31",null,"2025-12-31"]
[null,null,null,null,null,null,null,null,null,"Member ID No *",null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,"First Name *"]
[null,null,null,null,null,null,null,null,null,"Middle (optional)"]
[null,null,null,null,null,null,null,null,null,"Last Name *"]
["Card","Required Fields = 6",null,null,null,null,null,null,null,"DOB * (MM/DD/YYYY)"]
[4,{"$f":"COUNTA(Q4:Q5,Q7:Q10)","v":0},null,null,null,null,null,null,null,"Department *"]
[3,{"$f":"COUNTA(O4:O5,O7:O10)","v":0},null,null,null,null,null,null,null,"Squadron # *"]
[2,{"$f":"COUNTA(M4:M5,M7:M10)","v":0}]
[1,{"$f":"COUNTA(K4:K5,K7:K10)","v":0},"4 Member Template Cards below",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(K4:K10)=7,\"Card Ready to Print\",\"* Update Required Fields\")","v":"* Update Required Fields"},null,{"$f":"IF(COUNTA(M4:M10)=7,\"Card Ready to Print\",\"* Update Required Fields\")","v":"* Update Required Fields"},null,{"$f":"IF(COUNTA(O4:O10)=7,\"Card Ready to Print\",\"* Update Required Fields\")","v":"* Update Required Fields"},null,{"$f":"IF(COUNTA(Q4:Q10)=7,\"Card Ready to Print\",\"* Update Required Fields\")","v":"* Update Required Fields"}]
[null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,"Card 4",null,{"$f":"IF(B9=6,\"Exp. \"&MONTH(Q3)&\"/\"&DAY(Q3)&\"/\"&YEAR(Q3),\"\")","v":""},null,{"$f":"IF(B9=6,Q4,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(B9=6,Q9,\"\")","v":""},null,{"$f":"IF(B9=6,Q10,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(B9=6,Q8,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(B9=6,Q5&\" \"&Q6&\" \"&Q7,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(Q10=\"\",\"\",K14)","v":""}]
[]
[]
[]
[]
[]
[null,null,"Card 3",null,{"$f":"IF(B10=6,\"Exp. \"&MONTH(O3)&\"/\"&DAY(O3)&\"/\"&YEAR(O3),\"\")","v":""},null,{"$f":"IF(B10=6,O4,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(B10=6,O9,\"\")","v":""},null,{"$f":"IF(B10=6,O10,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(B10=6,O8,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(B10=6,O5&\" \"&O6&\" \"&O7,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(O10=\"\",\"\",K14)","v":""}]
[]
[]
[]
[]
[]
[null,null,"Card 2",null,{"$f":"IF(B11=6,\"Exp. \"&MONTH(M3)&\"/\"&DAY(M3)&\"/\"&YEAR(M3),\"\")","v":""},null,{"$f":"IF(B11=6,M4,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(B11=6,M9,\"\")","v":""},null,{"$f":"IF(B11=6,M10,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(B11=6,M8,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(B11=6,M5&\" \"&M6&\" \"&M7,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(M10=\"\",\"\",K14)","v":""}]
[]
[]
[]
[]
[]
[null,null,"Card 1",null,{"$f":"IF(B12=6,\"Exp. \"&MONTH(K3)&\"/\"&DAY(K3)&\"/\"&YEAR(K3),\"\")","v":""},null,{"$f":"IF(B12=6,K4,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(B12=6,K9,\"\")","v":""},null,{"$f":"IF(B12=6,K10,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(B12=6,K8,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(B12=6,K5&\" \"&K6&\" \"&K7,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(K10=\"\",\"\",K14)","v":""}]

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