{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Add DeMolay","Input","Merit Bars Earned","Event Worksheet"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"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":"Add DeMolay","index":0,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[33,2,33,4],[0,0,0,6],[27,2,27,4],[3,1,3,5],[1,1,1,5],[2,1,2,5],[23,1,23,5],[24,1,24,5]]}
["Merit Bar Calculator"]
[null,"Add a DeMolay"]
[null,"Enter the first, middle and last name."]
[null,"Then press Enter and then click the save button below.  "]
[]
[null,"First",null,"Middle",null,"Last"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"F7 &\", \" &B7 &\" \" &D7","v":",  "}]
[{"$f":"TRIM(A19)","v":","}]
[]
[]
[]
[null,"Remove a Name"]
[null,"Select a name (press the UP arrow) and click the remove button."]
[]
[null,null,null,"Name"]
[]
[]
[]
[]
[]
[null,null,null,"Name of Chapter"]
[null,null,"Colorado Springs"]

{"sheet":"Input","index":1,"n_rows":3,"n_cols":23,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,5,0,6],[0,7,0,8],[0,13,0,14]]}
["DeMolay","Athletic","Attendance","Civic Service","Conclave","Fine Art",null,"Fund-Raising",null,"Installing","Journalism","Correspond","Masonic Attend","Masonic Service",null,"Membership","Merit","Priory","Religion","Scholastic","Visitation","Ritual"]
["Name","Years","Years","Hours","Events","Music","Theater","Events","Hours","Events","Years","Lessons","Masons","Events","Hours","Members","Hours","Years","Years","Years","Miles","Points","NOTES"]
["1 Hide"]

{"sheet":"Merit Bars Earned","index":2,"n_rows":2,"n_cols":19,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Name","Athletic","Attendance","Civic Service","Conclave","Fine Art","Fund-Raising","Installing","Journalism","Correspondence","Masonic Attendance","Masonic Service","Membership","Merit","Priory","Religion","Scholastic","Visitation","Ritual"]
["1 Hide",{"$f":"Vmerit(VLOOKUP($A2,Input!$A:$V,2,FALSE))","v":""},{"$f":"Vmerit(VLOOKUP($A2,Input!$A:$V,3,FALSE))","v":""},{"$f":"CService(VLOOKUP($A2,Input!$A:$V,4,FALSE))","v":""},{"$f":"Conclave(VLOOKUP($A2,Input!$A:$V,5,FALSE))","v":""},{"$f":"FineArt(VLOOKUP($A2,Input!$A:$V,6,FALSE),VLOOKUP($A2,Input!$A:$V,7,FALSE))","v":""},{"$f":"Fundraise(VLOOKUP($A2,Input!$A:$V,8,FALSE),VLOOKUP($A2,Input!$A:$V,9,FALSE))","v":""},{"$f":"Install(VLOOKUP($A2,Input!$A:$V,10,FALSE))","v":""},{"$f":"Vmerit(VLOOKUP($A2,Input!$A:$V,11,FALSE))","v":""},{"$f":"Vmerit(VLOOKUP($A2,Input!$A:$V,12,FALSE))","v":""},{"$f":"MAttend(VLOOKUP($A2,Input!$A:$V,13,FALSE))","v":""},{"$f":"Mservice(VLOOKUP($A2,Input!$A:$V,14,FALSE),VLOOKUP($A2,Input!$A:$V,15,FALSE))","v":""},{"$f":"Membership(VLOOKUP($A2,Input!$A:$V,16,FALSE))","v":""},{"$f":"Merit(VLOOKUP($A2,Input!$A:$V,17,FALSE))","v":""},{"$f":"Vmerit(VLOOKUP($A2,Input!$A:$V,18,FALSE))","v":""},{"$f":"Vmerit(VLOOKUP($A2,Input!$A:$V,19,FALSE))","v":""},{"$f":"Vmerit(VLOOKUP($A2,Input!$A:$V,20,FALSE))","v":""},{"$f":"Visit(VLOOKUP($A2,Input!$A:$V,21,FALSE))","v":""},{"$f":"Ritual(VLOOKUP($A2,Input!$A:$V,22,FALSE))","v":""}]

{"sheet":"Event Worksheet","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[7,1,7,9],[0,0,0,10],[2,0,2,10],[4,1,4,3],[5,1,5,3],[6,1,6,9]]}
[{"$f":"'Add DeMolay'!C34 &\" Chapter Order of DeMolay \"","v":"Colorado Springs Chapter Order of DeMolay "}]
[]
["EVENT WORKSHEET"]
[]
["Event:"]
["Date:"]
["Advised by:"]
[]
[]
["Name","Attended","Paid"]
["1 Hide"]