{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Excel VBA Scrabble","Version"],"not_rendered":{"macros":1,"defined_names":57},"read":"whole","date_system":"1900"}

{"sheet":"Excel VBA Scrabble","index":0,"n_rows":206,"n_cols":31,"rows_kept":206,"merged":[[1,17,1,18],[1,19,1,20],[1,21,1,24],[2,17,2,18],[2,19,2,20],[2,21,2,24],[4,17,4,19],[4,20,4,26],[4,27,4,29],[5,17,5,19],[5,27,5,29],[7,17,7,19],[7,20,7,26],[7,27,7,29],[8,17,8,19],[8,27,8,29],[10,17,10,19],[10,20,10,26],[10,27,10,29],[11,17,11,19],[11,27,11,29],[13,17,13,19],[13,20,13,26],[13,27,13,29],[14,17,14,19],[14,27,14,29]]}
[null,"Excel VBA Scrabble"]
[{"$nulls":17},"Turn",null,"Player",null,"Letters Left"]
[{"$nulls":17},1,null,1,null,{"$f":"100-SUM(UsedLetterDist)","v":100}]
[]
[{"$nulls":17},"Player 1",{"$nulls":9},"Score"]
[{"$nulls":17},"Letters"]
[]
[{"$nulls":17},"Player 2",{"$nulls":9},"Score"]
[{"$nulls":17},"Letters"]
[]
[{"$nulls":17},"Player 3",{"$nulls":9},"Score"]
[{"$nulls":17},"Letters"]
[]
[{"$nulls":17},"Player 4",{"$nulls":9},"Score"]
[{"$nulls":17},"Letters"]
[]
[]
[null,null,"TRIPLE WORD SCORE",{"$nulls":6},"TRIPLE LETTER SCORE"]
[null,null,"DOUBLE WORD SCORE",{"$nulls":6},"DOUBLE LETTER SCORE"]
{"$rows_empty":80}
[null,null,"LETTER DISTRIBUTION:",{"$nulls":9},"PLAYER LETTERS:",{"$nulls":8},"ALPHABET:",{"$nulls":8},"PLAYERS:"]
[]
[null,null,"INDEX",null,"LETTER",null,"VALUE",null,"USED",{"$nulls":3},1,2,3,4,5,6,7,null,null,"LETTER",null,"INDEX",null,"DIST","PL"]
[null,null,1,null,"A",null,1,{"$nulls":4},"P1",{"$nulls":9},"A",null,1,null,{"$f":"SUMIF($E$103:$E$202,V103,$I$103:$I$202)","v":0},{"$f":"IF(V103=\"BLANK\",COUNTIF(Board,VLOOKUP(\"-\",$E$103:$H$200,1,FALSE)&VLOOKUP(\"-\",$E$103:$H$200,3,FALSE))+COUNTIF($M$103:$S$106,VLOOKUP(\"-\",$E$103:$H$200,1,FALSE)&VLOOKUP(\"-\",$E$103:$H$200,3,FALSE)),COUNTIF(Board,VLOOKUP(V103,$E$103:$H$200,1,FALSE)&VLOOKUP(V103,$E$103:$H$200,3,FALSE))+COUNTIF($M$103:$S$106,VLOOKUP(V103,$E$103:$H$200,1,FALSE)&VLOOKUP(V103,$E$103:$H$200,3,FALSE)))","v":0},{"$nulls":3},"PLACED TILES:"]
[null,null,2,null,"A",null,1,{"$nulls":4},"P2",{"$nulls":9},"B",null,2,null,0,0]
[null,null,3,null,"A",null,1,{"$nulls":4},"P3",{"$nulls":9},"C",null,3,null,0,0]
[null,null,4,null,"A",null,1,{"$nulls":4},"P4",{"$nulls":9},"D",null,4,null,0,0]
[null,null,5,null,"A",null,1,{"$nulls":14},"E",null,5,null,0,0]
[null,null,6,null,"A",null,1,{"$nulls":5},"EXCHANGE LETTERS:",{"$nulls":8},"F",null,6,null,0,0]
[null,null,7,null,"A",null,1,{"$nulls":14},"G",null,7,null,0,0]
[null,null,8,null,"A",null,1,{"$nulls":5},1,2,3,4,5,6,7,null,null,"H",null,8,null,0,0]
[null,null,9,null,"A",null,1,{"$nulls":14},"I",null,9,null,0,0]
[null,null,10,null,"B",null,3,{"$nulls":14},"J",null,10,null,0,0]
[null,null,11,null,"B",null,3,{"$nulls":14},"K",null,11,null,0,0]
[null,null,12,null,"C",null,3,{"$nulls":14},"L",null,12,null,0,0]
[null,null,13,null,"C",null,3,{"$nulls":14},"M",null,13,null,0,0]
[null,null,14,null,"D",null,2,{"$nulls":14},"N",null,14,null,0,0]
[null,null,15,null,"D",null,2,{"$nulls":14},"O",null,15,null,0,0]
[null,null,16,null,"D",null,2,{"$nulls":14},"P",null,16,null,0,0]
[null,null,17,null,"D",null,2,{"$nulls":14},"Q",null,17,null,0,0]
[null,null,18,null,"E",null,1,{"$nulls":14},"R",null,18,null,0,0]
[null,null,19,null,"E",null,1,{"$nulls":14},"S",null,19,null,0,0]
[null,null,20,null,"E",null,1,{"$nulls":14},"T",null,20,null,0,0]
[null,null,21,null,"E",null,1,{"$nulls":14},"U",null,21,null,0,0]
[null,null,22,null,"E",null,1,{"$nulls":14},"V",null,22,null,0,0]
[null,null,23,null,"E",null,1,{"$nulls":14},"W",null,23,null,0,0]
[null,null,24,null,"E",null,1,{"$nulls":14},"X",null,24,null,0,0]
[null,null,25,null,"E",null,1,{"$nulls":14},"Y",null,25,null,0,0]
[null,null,26,null,"E",null,1,{"$nulls":14},"Z",null,26,null,0,0]
[null,null,27,null,"E",null,1,{"$nulls":14},"BLANK",null,0,null,0,{"$f":"COUNTIF(Board,\"-\")+COUNTIF(M103:S106,\"-\")","v":0}]
[null,null,28,null,"E",null,1,{"$nulls":18},{"$f":"SUM(Z103:Z129)","v":0},{"$f":"SUM(AA103:AA129)","v":0}]
[null,null,29,null,"E",null,1]
[null,null,30,null,"F",null,4]
[null,null,31,null,"F",null,4]
[null,null,32,null,"G",null,2]
[null,null,33,null,"G",null,2]
[null,null,34,null,"G",null,2]
[null,null,35,null,"H",null,4]
[null,null,36,null,"H",null,4]
[null,null,37,null,"I",null,1]
[null,null,38,null,"I",null,1]
[null,null,39,null,"I",null,1]
[null,null,40,null,"I",null,1]
[null,null,41,null,"I",null,1]
[null,null,42,null,"I",null,1]
[null,null,43,null,"I",null,1]
[null,null,44,null,"I",null,1]
[null,null,45,null,"I",null,1]
[null,null,46,null,"J",null,8]
[null,null,47,null,"K",null,5]
[null,null,48,null,"L",null,1]
[null,null,49,null,"L",null,1]
[null,null,50,null,"L",null,1]
[null,null,51,null,"L",null,1]
[null,null,52,null,"M",null,3]
[null,null,53,null,"M",null,3]
[null,null,54,null,"N",null,1]
[null,null,55,null,"N",null,1]
[null,null,56,null,"N",null,1]
[null,null,57,null,"N",null,1]
[null,null,58,null,"N",null,1]
[null,null,59,null,"N",null,1]
[null,null,60,null,"O",null,1]
[null,null,61,null,"O",null,1]
[null,null,62,null,"O",null,1]
[null,null,63,null,"O",null,1]
[null,null,64,null,"O",null,1]
[null,null,65,null,"O",null,1]
[null,null,66,null,"O",null,1]
[null,null,67,null,"O",null,1]
[null,null,68,null,"P",null,3]
[null,null,69,null,"P",null,3]
[null,null,70,null,"Q",null,10]
[null,null,71,null,"R",null,1]
[null,null,72,null,"R",null,1]
[null,null,73,null,"R",null,1]
[null,null,74,null,"R",null,1]
[null,null,75,null,"R",null,1]
[null,null,76,null,"R",null,1]
[null,null,77,null,"S",null,1]
[null,null,78,null,"S",null,1]
[null,null,79,null,"S",null,1]
[null,null,80,null,"S",null,1]
[null,null,81,null,"T",null,1]
[null,null,82,null,"T",null,1]
[null,null,83,null,"T",null,1]
[null,null,84,null,"T",null,1]
[null,null,85,null,"T",null,1]
[null,null,86,null,"T",null,1]
[null,null,87,null,"U",null,1]
[null,null,88,null,"U",null,1]
[null,null,89,null,"U",null,1]
[null,null,90,null,"U",null,1]
[null,null,91,null,"V",null,4]
[null,null,92,null,"V",null,4]
[null,null,93,null,"W",null,4]
[null,null,94,null,"W",null,4]
[null,null,95,null,"X",null,8]
[null,null,96,null,"Y",null,4]
[null,null,97,null,"Y",null,4]
[null,null,98,null,"Z",null,10]
[null,null,99,null,"BLANK",null,0]
[null,null,100,null,"BLANK",null,0]
[{"$nulls":7},"TOTAL",{"$f":"SUM(UsedLetterDist)","v":0}]
[]
[{"$nulls":7},"CHECKSUM",{"$f":"COUNTA(Board)+COUNTA(M103:S106)","v":0}]
[{"$nulls":7},"VARIANCE",{"$f":"SumUsed-I205","v":0}]

{"sheet":"Version","index":1,"n_rows":23,"n_cols":6,"rows_kept":23,"merged":[[1,1,1,2],[1,3,1,4],[1,5,1,8],[2,1,2,2],[2,3,2,4],[2,5,2,8],[3,1,3,2],[3,3,3,4],[3,5,3,8],[4,1,4,2],[4,3,4,4],[4,5,4,8],[5,1,5,2],[5,3,5,4],[5,5,5,8],[6,1,6,2],[6,3,6,4],[6,5,6,8],[7,1,7,2],[7,3,7,4],[7,5,7,8],[8,1,8,2],[8,3,8,4],[8,5,8,8],[9,1,9,2],[9,3,9,4],[9,5,9,8],[10,1,10,2],[10,3,10,4],[10,5,10,8],[11,1,11,2],[11,3,11,4],[11,5,11,8],[12,1,12,2],[12,3,12,4],[12,5,12,8],[13,1,13,2],[13,3,13,4],[13,5,13,8],[14,1,14,2],[14,3,14,4],[14,5,14,8],[15,1,15,2],[15,3,15,4],[15,5,15,8],[16,1,16,2],[16,3,16,4],[16,5,16,8],[17,1,17,2],[17,3,17,4],[17,5,17,8],[18,1,18,2],[18,3,18,4],[18,5,18,8],[19,1,19,2],[19,3,19,4],[19,5,19,8],[20,1,20,2],[20,3,20,4],[20,5,20,8]]}
[]
[null,"Version",null,"Date",null,"Description"]
[null,{"v":0.1,"d":"0.10"},null,"2017-09-01",null,"Initial Board setup. Definitions added. Userforms added for game start."]
[null,{"v":0.2,"d":"0.20"},null,"2017-09-05",null,"Reset board functionality. Initial turn setup."]
[null,{"v":0.3,"d":"0.30"},null,"2017-09-07",null,"Tile placement. Completing Word."]
[null,{"v":0.4,"d":"0.40"},null,"2017-09-16",null,"Variations on scoring introduced with Double Letter, Triple Letter, Double Word and Triple Word.\nDifferent word combinations modelled. Complete remodelling of scoring algorithm."]
[null,{"v":0.5,"d":"0.50"},null,"2017-09-17",null,"Store Range offset bug fixed."]
[null,{"v":0.6,"d":"0.60"},null,"2017-09-19",null,"Bingo! scenario. Endgame scenarios. Endgame bug fixes."]
[null,0.65,null,"2017-09-25",null,"Pass implemented. "]
[null,{"v":0.7,"d":"0.70"},null,"2017-10-05",null,"Up-Down scoring bug fixed. Final score message box adjustment. Tile rack cell selection update."]
[null,0.75,null,"2017-10-07",null,"Exchange Letters implemented. "]
[null,0.78,null,"2017-10-26",null,"Bug fixes player numbers 3 and 4 selection."]
[null,0.81,null,"2019-12-27",null,"Bug fix end game score adjustment message player numbers 2 & 3."]
[null,{"v":1,"d":"1.00"},null,"2019-12-28",null,"Final version."]
[null,1.01,null,"2020-02-07",null,"Button graphics updated."]
[null,1.02,null,"2020-04-11",null,"Bug fix with network play. 'Players' global variable converted to named range. \nAllows saving, closing file and resuming game without loss of player number memory."]
[null,1.03,null,"2020-04-11",null,"End game scoring calculation bug fix & update to show winning player name in final message box."]
[null,1.04,null,"2020-09-28",null,"Bug fixes. Error catching on button presses in various scenarios."]
[null,1.05,null,"2021-01-23",null,"Bug fix. Fixed endgame scenario: placed tile number does not equal tile number from store."]
[null,1.06,null,"2021-01-24",null,"Bug fix. Fixed overscoring bug one letter placed in up-down orientation."]
[null,1.07,null,"2021-02-06",null,"Bug fix. Fixed underscoring bug (up-down orientation)."]
[]
[null,"Contact:","tomhedge1981@gmail.com"]