{"text_format":"2","workbook":"xlsx","n_sheets":17,"sheets":["1-Genl Info","2-Program Info","3-Reader Info","4-Guardian Info","5-Add'l Reader Info","6-Add'l Reader Info(Staff Only)","7-Field Order","8-Libraries","9-Ages","10-Genders","11-Cities","12-Zipcodes","13-Grades","14-Schools","15-Public drop-down","16-Staff drop-down","17-Levels"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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"}

{"sheet":"1-Genl Info","index":0,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[8,1,8,3],[8,6,8,8],[8,4,8,5],[3,1,3,4],[7,1,7,3],[7,4,7,5],[0,0,0,1],[7,6,7,8],[25,5,25,6],[11,4,11,5],[12,4,12,5],[12,1,12,3],[9,6,9,8],[10,6,10,8],[11,6,11,8],[12,6,12,8],[24,5,24,6],[9,1,9,3],[10,1,10,3],[11,1,11,3],[9,4,9,5],[10,4,10,5],[31,1,31,2],[16,1,16,4],[20,1,20,2],[24,1,24,2],[24,3,24,4],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[25,1,25,2],[25,3,25,4],[31,5,31,6],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[26,5,26,6],[27,5,27,6],[28,5,28,6],[29,5,29,6],[30,5,30,6]]}
["ReadingRecord 2019 setup form"]
["General Information"]
[]
["Library Name:"]
[]
[]
[]
["Contact Information:","Name",null,null,"Phone",null,"E-mail"]
{"$rows_empty":8}
["URL prefix:"]
[]
[]
[]
["Timezone:"]
[]
[]
[]
["Staff & volunteer accounts:","Username",null,"Password",null,"Reports access(y/n)"]
{"$rows_empty":10}
["Multi-program registration?","No"]

{"sheet":"2-Program Info","index":1,"n_rows":17,"n_cols":1,"rows_kept":17,"cut":false,"hidden":false,"merged":[[19,3,19,7],[16,1,16,6],[2,1,2,4],[8,1,8,4],[10,1,10,4],[12,1,12,4],[14,1,14,6],[4,1,4,4],[6,1,6,4]]}
["Program Information"]
[]
["Program name: "]
[]
["Program start date:"]
[]
["Program end date:"]
[]
["Self-registration start date:"]
[]
["Self-registration end date:"]
[]
["Program range:"]
[]
["Program information:"]
[]
["Registration successful message (optional):"]

{"sheet":"3-Reader Info","index":2,"n_rows":98,"n_cols":2,"rows_kept":98,"cut":false,"hidden":false,"merged":[[29,1,29,4],[8,1,8,4],[14,1,14,4],[19,1,19,4],[21,1,21,4],[27,1,27,4],[50,1,50,4],[57,1,57,4],[64,1,64,4],[31,1,31,4],[37,1,37,4],[44,1,44,4],[71,1,71,4],[77,1,77,4],[83,1,83,4],[89,1,89,4],[96,1,96,4]]}
["Reader Information"]
[]
["Display the form header?","Yes"]
[]
[]
[]
["Display the personal info header?","Yes"]
[]
["Custom label (optional):"]
[]
[]
[]
["Use the home library field?","Yes"]
[]
["Custom label (optional):"]
["(If using this field, complete tab 8)"]
[]
[]
[]
["First name custom label (optional):"]
[]
["Last name custom label (optional):"]
[]
[]
[]
["Phone number length:","10 digits"]
[]
["Custom label (optional):"]
[]
["Default area code (optional):"]
[]
["Custom error message (optional):"]
[]
[]
[]
["Use the age field?","No"]
[]
["Custom label (optional):"]
["(If using this field, complete tab 9)"]
[]
[]
[]
["Use the birth date field?","No"]
[]
["Custom label (optional):"]
[]
[]
[]
["Use the gender field?","No"]
[]
["Custom label (optional):"]
["(If using this field, complete tab 10)"]
[]
[]
[]
["Use the city field?","No"]
[]
["Custom label (optional):"]
["(If using this field, complete tab 11)"]
[]
[]
[]
["Use the zipcode field?","No"]
[]
["Custom label (optional):"]
["(If using this field, complete tab 12)"]
[]
[]
[]
["Use the e-mail field?","No"]
[]
["Custom label (optional):"]
[]
[]
[]
["Use the barcode field?","No"]
[]
["Custom label (optional):"]
[]
[]
[]
["Display the school info header?","No"]
[]
["Custom label (optional):"]
[]
[]
[]
["Use the grade field?","No"]
[]
["Custom label (optional):"]
["(If using this field, complete tab 13)"]
[]
[]
[]
["Use the school field?","No"]
[]
["Custom label (optional):"]
["(If using this field, complete tab 14)"]

{"sheet":"4-Guardian Info","index":3,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,1,30,4],[4,1,4,4],[10,1,10,4],[12,1,12,4],[18,1,18,4],[24,1,24,4]]}
["Guardian Information"]
[]
["Display the guardian info header?","No"]
[]
["Custom label (optional):"]
[]
[]
[]
["Use the guardian first & last name fields?","No"]
[]
["Guardian first name custom label (optional):"]
[]
["Guardian last name custom label (optional):"]
[]
[]
[]
["Use the guardian phone field?","No"]
[]
["Custom label for guardian phone number field:"]
[]
[]
[]
["Use the guardian e-mail field?","No"]
[]
["Custom label for guardian e-mail field (optional):"]
[]
[]
[]
["Use the guardian barcode field?","No"]
[]
["Custom label for guardian barcode field (optional):"]

{"sheet":"5-Add'l Reader Info","index":4,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,1,33,4],[10,1,10,4],[18,1,18,4],[20,1,20,4],[0,0,0,1],[6,1,6,4],[8,1,8,4],[16,1,16,4],[26,1,26,4]]}
["Additional Reader Information"]
[]
["Note: To specify where these fields should appear, see tab 7"]
[]
["Use the consent checkbox?","No"]
[]
["Custom label for consent checkbox (optional):"]
[]
["Custom info for consent checkbox (optional):"]
[]
["Custom error for consent checkbox (optional):"]
[]
[]
[]
["Use the public checkbox field?","No"]
[]
["Custom label for public checkbox field:"]
[]
["Custom info for public checkbox:"]
[]
["Custom error for public checkbox:"]
[]
[]
[]
["Use the public drop-down field?","No"]
[]
["Custom label for public drop-down field:"]
["(If using this field, complete tab 15)"]
[]
[]
[]
["Use the public textbox field?","No"]
[]
["Custom label for public textbox field:"]

{"sheet":"6-Add'l Reader Info(Staff Only)","index":5,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[[16,1,16,4],[23,1,23,4],[6,1,6,4],[8,1,8,4],[10,1,10,4]]}
["Additional Reader Information (Staff Only)"]
[]
["Note: To specify where these fields should appear, see tab 7"]
[]
["Use the staff checkbox field?","No"]
[]
["Custom label for staff checkbox field:"]
[]
["Custom info for staff checkbox:"]
[]
["Custom error for staff checkbox:"]
[]
[]
[]
["Use the staff drop-down field?","No"]
[]
["Custom label for staff drop-down field:"]
["(If using this field, complete tab 16)"]
[]
[]
[]
["Use the staff textbox field?","No"]
[]
["Custom label for staff textbox field:"]

{"sheet":"7-Field Order","index":6,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Field Order"]
[]
["Default order","Custom order"]
["Form header"]
["Personal info header"]
["Reader home library"]
["Reader first name"]
["Reader last name"]
["Reader phone"]
["Reader age"]
["Reader birth date"]
["Reader gender"]
["Reader city"]
["Reader zipcode"]
["Reader e-mail"]
["Reader barcode"]
["School info header"]
["Reader grade"]
["Reader school"]
["Guardian info header"]
["Guardian first name"]
["Guardian last name"]
["Guardian phone"]
["Guardian e-mail"]
["Guardian barcode"]
["Consent checkbox"]
["Public checkbox"]
["Public drop-down"]
["Public text box"]
["Staff checkbox (staff only)"]
["Staff drop-down (staff only)"]
["Staff text box (staff only)"]
["Registration validated (staff only)"]

{"sheet":"8-Libraries","index":7,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Libraries"]

{"sheet":"9-Ages","index":8,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Ages"]

{"sheet":"10-Genders","index":9,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Genders"]

{"sheet":"11-Cities","index":10,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Cities"]

{"sheet":"12-Zipcodes","index":11,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Zipcodes"]

{"sheet":"13-Grades","index":12,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Grades"]

{"sheet":"14-Schools","index":13,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Schools"]

{"sheet":"15-Public drop-down","index":14,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Public drop-down"]

{"sheet":"16-Staff drop-down","index":15,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Staff drop-down"]

{"sheet":"17-Levels","index":16,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Levels"]
[]
["Level","Prize / staff instructions -OR- drop-down list items"]