{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Notes","Set Up","RecDisplay"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Notes","index":0,"n_rows":49,"n_cols":1,"rows_kept":49,"cut":false,"hidden":false,"merged":[[22,0,22,8],[15,0,15,8],[12,0,12,8],[13,0,13,8],[14,0,14,8],[18,0,18,8],[19,0,19,8],[16,0,16,8],[21,0,21,8],[0,0,0,8],[8,0,8,8],[9,0,9,8],[11,0,11,8],[2,0,2,8],[3,0,3,8],[4,0,4,8],[6,0,6,8],[5,0,5,8],[53,0,53,8],[49,0,49,8],[50,0,50,8],[51,0,51,8],[52,0,52,8],[23,0,23,8],[36,0,36,8],[37,0,37,8],[44,0,44,8],[45,0,45,8],[25,0,25,8],[26,0,26,8],[32,0,32,8],[30,0,30,8],[29,0,29,8],[38,0,38,8],[31,0,31,8],[34,0,34,8],[27,0,27,8],[35,0,35,8],[46,0,46,8],[48,0,48,8],[39,0,39,8],[40,0,40,8],[41,0,41,8],[43,0,43,8],[47,0,47,8]]}
["Notes on Keeping District Point Records"]
[]
["1. The following pages comprise a package intended to provide Shuffleboard Districts with a"]
["    method of keeping point records for one list of all players showing the 6 categories composed"]
["    of district am ladies, district am men, state an ladies, state am men, pro ladies, & pro men"]
["    with their points earned in district move-up points, state move-up points, and masters points, "]
["    in a relatively simple one screen format."]
[]
["2. The following procedures use Macros and as such the Security Level needs to be set to LOW. "]
["    On the Tools menu click Options - Security tab - Macro Security - set level"]
[]
["3. To Search for a player, type last name or FSA number, then click ok (or Enter), then click 'Find'."]
["    The name (or number) will be Selected if present. Click again if not the right name to search for"]
["    the next occurrence of the name. If the name is not found, the top of the list will be slected."]
["    When the desired name is found, click Mst Pts, Dist Mup, or State Mup, then type in the"]
["    new point values for the appropriate tournament, move the cursor away from the selected cell,"]
["    and click calculate to get the new point totals."]
[]
["4. In the Move-Up-Point listings, the Past-1 column is for 1 year ago, the Past-2 for 2 years ago."]
["    For the Pros, Instead of Past-2 it's Previous master points, Past-1 is total Master points."]
[]
["5. The example shown copied the SOU district (thanks Colleen). Column Names 1-21 can be "]
["     changed to more specific names to suit other Districts. Only a few of the records have been"]
["    calculated thus providing practice."]
[]
["6. For printing, the first 10 columns may be sufficient for posting for the membership. "]
["    If a PDF program is available, these columns could generated as such and be sent to the"]
["    District Webmaster for posting on the Website."]
[]
["7. New names should be added at the bottom of the list. A way to get there is to search for a blank"]
["    space. Just click 'Sort' afterwards to re-arrange the names alphabetically into their respective"]
["    rank & sex.For Pros, rank 'zP' is used to force the Pro divisions to the end of the listings."]
["    Names may be typed in, or use Copy and Paste if desired."]
[]
["8. To keep searches to a minimum, type a 'List Size' into cell 'H5'. This should be slightly larger"]
["    than the number of players. If more names are present than this size, and a name is entered"]
["    requiring a search beyond this size, a message will request an increase in size."]
[]
["9. Sometimes a space might be entered to cancel a numerical value in a cell. This could cause"]
["    an error in trying to add from that cell. Use a zero instead. An error message will indicate"]
["    which row to examine. A way to find cells that do contain a zero is to click "]
["    Tools - Options - View - then Check the Zero Value box. Afterwards clear the check mark."]
[]
["10. Player categories may be selected by typing '1,2,3,4,5,6' which have been assigned to"]
["    the Dist, State, & Pro M/L divisions. The underscore maintains the division color."]
[]
["11. The Point Display button copies columns A through I to the RecDisplay sheet, and"]
["      allows deletion of records with no Master Points, or No Move-Up  Points, to list only"]
["      those with points, more suitable for printing a shorter list."]

{"sheet":"Set Up","index":1,"n_rows":32,"n_cols":85,"rows_kept":32,"cut":false,"hidden":false,"merged":[[2,0,2,1],[4,5,4,6],[0,0,1,1],[1,66,1,72],[1,17,1,26],[1,40,1,54],[2,16,2,26],[2,68,2,78]]}
["DISTRICT\nPOINT RECORDS",null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amateur - District Move-Up Points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pro and Amateur Master Points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Amateur - State Move-Up Points"]
["Enter Name or #",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,1,1,1,.5,.5,.5,0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Doubles: 5-4-3-2  2-1-1-1           Singles: 7-5-4-3  3-2-1-1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1,1,1,1,.5,.5,.5,0"]
[3759,"ok"]
[{"$f":"TODAY()","v":"2015-11-13"},29,3759,null,null,"List Size:",null,310,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,"p01","p03b","p04a",null,"p06b",null,"p12a",null,null,"p15b",null,null,"p22b",null,"pxx",null,"pxx",null,null,null,"pxx",null,null,null,"pxx"]
["FSA#","Last","First","Rnk","Sex","Clb","Past-2","Past-1","TotMup","CurrMst"]
[1,"_DistAmLadies",null,"D","F",null,null,null,null,0]
[4889,"Ayotte","Patsy","D","F","IBE",null,0.5]
[4915,"Baker","Dorie","D","F","LC",0.5,2,5,7]
[4929,"Barrett","Judy","D","F","LC"]
[2,"_DistAmMen",null,"D","M"]
[77,"Baldus","Mel","D","M","LC"]
[4425,"Baucher","Jim","D","M","AO",null,3,4,0,null,null,null,null,1]
[4539,"Bilton","Rendall","D","M","LC",null,1,1,0]
[3,"_StateAmLadies",null,"S","F"]
[4708,"Barber","Carol","S","F","RW",null,null,0,0]
[3762,"Brenner","Joan","S","F","LC",null,0.5,1.5,0,null,null,null,null,null,1]
[2248,"Brodie","Colette","S","F","LC",1]
[4,"_StateAmMen",null,"S","M"]
[4728,"Boncher","Dave","S","M","LC",null,4,4,0]
[" ","Brino","Al","S","M","LC"]
[3763,"Brown","Al","S","M","LC"]
[5,"_ProLadies",null,"zP","F",null,"Prev-Mst","Tot-Mst"]
[2999,"Adkins","Landy","zP","F","PC"," ",0,0]
[3426,"Allen","Dianna","zP","F","RW",0,0,0,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[3726,"Austin","Colleen","zP","F","LC",0,0,0]
[6,"_ProMen",null,"zP","M",null,"Prev-Mst","Tot-Mst"]
[3090,"Adkins","George","zP","M","PC",0,0,0,0]
[3759,"Albert","Ray","zP","M","IBE",0,0,0,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[11,"Alexander","Wally","zP","M","LC",0,0,0,0]
[]
[null,null,null,null,null,null,null,null,0,0]

{"sheet":"RecDisplay","index":2,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,1,1],[2,0,2,1]]}
["DISTRICT\nPOINT RECORDS"]
[]
[]
[]
[{"$f":"TODAY()","v":"2015-11-13"}]
["FSA#","Last","First","Rnk","Sex","Clb","Past-2","Past-1","TotMup","CurrMst"]
[1,"_DistAmLadies",null,"D","F",null,null,null,null,0]
[4915,"Baker","Dorie","D","F","LC",0.5,2,5,7]
[2,"_DistAmMen",null,"D","M"]
[4425,"Baucher","Jim","D","M","AO",null,3,4,0]
[4539,"Bilton","Rendall","D","M","LC",null,1,1,0]
[3,"_StateAmLadies",null,"S","F"]
[3762,"Brenner","Joan","S","F","LC",null,0.5,1.5,0]
[4,"_StateAmMen",null,"S","M"]
[4728,"Boncher","Dave","S","M","LC",null,4,4,0]
[5,"_ProLadies",null,"zP","F",null,"Prev-Mst","Tot-Mst"]
[6,"_ProMen",null,"zP","M",null,"Prev-Mst","Tot-Mst"]