{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Send Text or Email","People","Carriers","Import from Google Sheets","Total Percentages","Matts District","Javiers District","Dans District"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":4,"comments":1,"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":"Send Text or Email","index":0,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[4,1,4,2],[10,1,10,2],[13,1,13,2]]}
[]
[null,"Send Text:"]
[]
[null,"Message:"]
[null,"Elders, if you've done your home teaching this week please report it here: http://goo.gl/forms/ySlTx2Lps3\nThis text is sent weekly. Reply STOP to opt out.",null,{"$f":"\"characters:\" & (LEN(B5)+4)","v":"characters:158"}]
[]
[]
[null,"Send Email:"]
[]
[null,"Subject:"]
[null,"Please report your home teaching"]
[]
[null,"Email Body:"]
[null,"Elders,\n\nPlease report your home teaching through the Google Form: http://goo.gl/forms/ySlTx2Lps3\n\nThanks,\n\n-Eric"]

{"sheet":"People","index":1,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","Email","Cell Phone","Carrier"]
["Eric","Wardell","erock523@gmail.com",6028128329,"T-Mobile"]
["Rachael","Wardell","ejwardell@byu.net",6028128331,"T-Mobile"]

{"sheet":"Carriers","index":2,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Provider","Gateway"]
["AllTel","text.wireless.alltel.com"]
["AT&T","txt.att.net"]
["Boost Mobile","myboostmobile.com"]
["Cricket","sms.mycricket.com"]
["Sprint","messaging.sprintpcs.com"]
["T-Mobile","tmomail.net"]
["US Cellular","email.uscc.net"]
["Verizon","vtext.com"]
["Virgin Mobile","vmobl.com"]

{"sheet":"Import from Google Sheets","index":3,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"For a sample Google Sheet use this key:"]
[null,"1BekkvgM552jQEu-bALKBSFH2pPIWXMNmfipmQVc_HCQ"]

{"sheet":"Total Percentages","index":4,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["district","Matt","Javier","Daniel","Total"]
["Number taught",{"$f":"'Matts District'!C17","v":2},{"$f":"'Javiers District'!C25","v":16},{"$f":"'Dans District'!C20","v":8},{"$f":"SUM(B2:D2)","v":26}]
["Number of Families",{"$f":"'Matts District'!C18","v":15},{"$f":"'Javiers District'!C26","v":23},{"$f":"'Dans District'!C21","v":18},{"$f":"SUM(B3:D3)","v":56}]
["Percent taught",{"$f":"B2/B3","v":0.13333333333333333},{"$f":"C2/C3","v":0.69565217391304346},0.44444444444444442,0.4642857142857143]

{"sheet":"Matts District","index":5,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Companionship","Family","Y/N"]
["Reschke/Keele","Walker"]
[null,"Lund"]
["Toronto/Faux ","Sanders","Y"]
["Mohammad/Vorwaller","Politis"]
[null,"Toone"]
["Broadbent/Prisby","Mohammed"]
[null,"Vorwaller"]
["Lund/Politis","Toronto"]
[null,"Prisbrey"]
["Toone/Reshke","Wardell","N"]
[null,"Lund","N"]
["Sanders/Coreless","Reshke"]
["Kiki/Sanders","Broadbent"]
[null,"Coreless"]
["Wardell/Justin Ambler","Mejia","Y"]
[null,"Total Visits:",{"$f":"COUNTIF(C2:C16,\"Y\")","v":2},null,"District Percentage:"]
[null,"Total Families",{"$f":"COUNTA(C2:C16)+COUNTBLANK(C2:C16)","v":15},null,{"$f":"C17/C18","v":0.13333333333333333}]

{"sheet":"Javiers District","index":6,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Companionship","Family","Y/N"]
["Arce/Kimball","Rhodes","N"]
[null,"Schriever","N"]
["Ascanio/Romney/Reynolds","Rucker","Y"]
[null,"Reynolds, Martin","Y"]
[null,"Roberto, Christian","Y"]
["Benson/Lambson","Lyman","Y"]
[null,"Reynolds, Marc","Y"]
["De Hoyos/Keeler","Arce","Y"]
[null,"Everett","Y"]
["LeBaron/Chamberlain","Pearce, Austin","Y"]
[null,"Lambson, Benji","N"]
["Hall/Thornburg","Ascanio, Javier","Y"]
[null,"Romney, Jackson","Y"]
["Rhodes/ Flemming","Schiller, Brett","N"]
[null,"Lebaron, Dean","N"]
["Lyman/Reynolds","Keeler","Y"]
[null,"Meredith","Y"]
["Meredith/Everett","Kimball","N"]
[null,"De Hoyos","N"]
["Schiller/Rucker","Hall","Y"]
[null,"Kiki","Y"]
["Schriever/Pearce","Benson, Taylor","Y"]
[null,"Flemming, Richard","Y"]
[null,"Total Visits:",{"$f":"COUNTIF(C2:C24,\"Y\")","v":16},null,"District Percentage:"]
[null,"Total Families",{"$f":"COUNTA(C2:C24)+COUNTBLANK(C2:C24)","v":23},null,{"$f":"C25/C26","v":0.69565217391304346}]

{"sheet":"Dans District","index":7,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Companionship","Family","Y/N"]
["Calvert/Pope","Colver","N"]
[null,"Massey","Y"]
["Colver/Selway","Grasser","Y"]
[null,"Pope","Y"]
["Courson/Lund","Martinsen","Y"]
["Gallacher/Peterson","Courson","Y"]
[null,"Murphy","Y"]
["Kelley/Larsen","Calvert","N"]
[null,"Lund","N"]
["Martinsen/Grasser","Gallacher","Y"]
[null,"Larsen","Y"]
[null,"Peterson","N"]
["Rather/Murphy","Reynolds","N"]
[null,"Trotter","N"]
["Trotter/Reynolds","Kelley","N"]
[null,"Rather","N"]
["Eagar/Shull","McQuivey","N"]
[null,"Unklesbay","N"]
[null,"Total Visits:",{"$f":"COUNTIF(C2:C19,\"Y\")","v":8},null,"District Percentage:"]
[null,"Total Families",{"$f":"COUNTA(C2:C19)+COUNTBLANK(C2:C19)","v":18},null,{"$f":"C20/C21","v":0.44444444444444442}]