{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Requirements","Rules","Tile Information","Bag","Gameboard"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":"Requirements","index":0,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["I'd like to build the game \"Scrabble\" in VBA.  The program will be designed to."]
["Setup the game with the desired number of players."]
["Setup the game board."]
["Give the player their letters."]
["Allow the players to put their pieces in place."]
["Give the players new letters."]
["Keep score. "]

{"sheet":"Rules","index":1,"n_rows":41,"n_cols":2,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[null,"These rules come from the Hasbro website:  "]
[null,"http://www.hasbro.com/scrabble/en_US/rulesSetup.cfm"]
[null,"http://www.hasbro.com/scrabble/en_US/scoringRules.cfm"]
[null,"http://www.hasbro.com/scrabble/en_US/gamePlayRules.cfm"]
[]
[null,"Rules – Setup"]
[null,"You should have a game board, 100 letter tiles, a letter bag, and four racks."]
[]
[null,"Before the game begins, all players should agree upon the dictionary that they will use, in case of a challenge. All words labeled as a part of speech (including those listed of foreign origin, and as archaic, obsolete, colloquial, slang, etc.) are permitted with the exception of the following: words always capitalized, abbreviations, prefixes and suffixes standing alone, words requiring a hyphen or an apostrophe."]
[]
[null,"Place all letters in the pouch, or facedown beside the board, and mix them up. Draw for first play. The player with the letter closest to \"A\" plays first. A blank tile beats any letter. Return the letters to the pool and remix. All players draw seven new letters and place them on their racks."]
[]
[]
[]
[null,"The Rules of the Game: Game Play"]
[null,"The first player combines two or more of his or her letters to form a word and places it on the board to read either across or down with one letter on the center square. Diagonal words are not allowed."]
[null,"Complete your turn by counting and announcing your score for that turn. Then draw as many new letters as you played; always keep seven letters on your rack, as long as there are enough tiles left in the bag."]
[null,"Play passes to the left. The second player, and then each in turn, adds one or more letters to those already played to form new words. All letters played on a turn must be placed in one row across or down the board, to form at least one complete word. If, at the same time, they touch others letters in adjacent rows, those must also form complete words, crossword fashion, with all such letters. The player gets full credit for all words formed or modified on his or her turn."]
[null,"New words may be formed by:"]
[null,"Adding one or more letters to a word or letters already on the board."]
[null,"Placing a word at right angles to a word already on the board. The new word must use one of the letters already on the board or must add a letter to it. (See Turns 2, 3 and 4 below.)"]
[null,"Placing a complete word parallel to a word already played so that adjacent letters also form complete words. (See Turn 5 in the Scoring Examples section below.)"]
[null,"No tile may be shifted or replaced after it has been played and scored."]
[null,"Blanks: The two blank tiles may be used as any letters. When playing a blank, you must state which letter it represents. It remains that letter for the rest of the game."]
[null,"You may use a turn to exchange all, some, or none of the letters. To do this, place your discarded letter(s) facedown. Draw the same number of letters from the pool, then mix your discarded letter(s) into the pool. This ends your turn."]
[null,"Any play may be challenged before the next player starts a turn. If the play challenged is unacceptable, the challenged player takes back his or her tiles and loses that turn. If the play challenged is acceptable, the challenger loses his or her next turn. Consult the dictionary for challenges only. All words made in one play are challenged simultaneously. If any word is unacceptable, then the entire play is unacceptable. Only one turn is lost on any challenge."]
[null,"The game ends when all letters have been drawn and one player uses his or her last letter; or when all possible plays have been made."]
[]
[]
[null,"SCRABBLE Rules: Scoring"]
[null,"Use a score pad or piece of paper to keep a tally of each player's score, entering it after each turn. The score value of each letter is indicated by a number at the bottom of the tile. The score value of a blank is zero."]
[null,"The score for each turn is the sum of the letter values in each word(s) formed or modified on that turn, plus the additional points obtained from placing letters on Premium Squares."]
[null,"Premium Letter Squares: A light blue square doubles the score of a letter placed on it; a dark blue square triples the letter score."]
[null,"Premium Word Squares: The score for an entire word is doubled when one of its letters is placed on a pink square: it is tripled when one of its letters is placed on a red square. Include premiums for double or triple letter values, if any, before doubling or tripling the word score. If a word is formed that covers two premium word squares, the score is doubled and then re-doubled (4 times the letter count), or tripled and then re-tripled (9 times the letter count). NOTE: the center square is a pink square, which doubles the score for the first word."]
[null,"Letter and word premiums count only on the turn in which they are played. On later turns, letters already played on premium squares count at face value."]
[null,"When a blank tile is played on a pink or red square, the value of the word is doubled or tripled, even though the blank itself has no score value."]
[null,"When two or more words are formed in the same play, each is scored. The common letter is counted (with full premium value, if any) for each word. (See Turns 3, 4 and 5 in the Scoring Examples section.)"]
[null,"BINGO! If you play seven tiles on a turn, it's a Bingo. You score a premium of 50 points after totaling your score for the turn."]
[null,"Unplayed Letters: When the game ends, each player's score is reduced by the sum of his or her unplayed letters. In addition, if a player has used all of his or her letters, the sum of the other players' unplayed letters is added to that player's score."]
[null,"The player with the highest final score wins the game. In case of a tie, the player with the highest score before adding or deducting unplayed letters wins."]

{"sheet":"Tile Information","index":2,"n_rows":139,"n_cols":3,"rows_kept":139,"cut":false,"hidden":true,"merged":[]}
["*****Do not change any information on this page as it will interfere with game functionality.*****"]
["Scrabble Tiles"]
["There are 100 total tiles.  The number of tiles available (at the start of the game)"]
["and point value of each tile is given below.  "]
[]
["Please note that blank tiles can be used during the game as any "]
["letter but are still worth 0 points."]
[]
["Letter","Number of Tiles","Point Value"]
["A",9,1]
["B",2,3]
["C",2,3]
["D",4,2]
["E",12,1]
["F",2,4]
["G",3,2]
["H",2,4]
["I",9,1]
["J",1,8]
["K",1,5]
["L",4,1]
["M",2,3]
["N",6,1]
["O",8,1]
["P",2,3]
["Q",1,10]
["R",6,1]
["S",4,1]
["T",6,1]
["U",4,1]
["V",2,4]
["W",2,4]
["X",1,8]
["Y",2,4]
["Z",1,10]
["blank",2,0]
[]
["This is the Starting Tile information"]
["Array Index","Letter"]
[0,"A"]
[{"$f":"A40+1","v":1},"A"]
[{"$f":"A41+1","v":2},"A"]
[3,"A"]
[4,"A"]
[5,"A"]
[6,"A"]
[7,"A"]
[8,"A"]
[9,"B"]
[10,"B"]
[11,"C"]
[12,"C"]
[13,"D"]
[14,"D"]
[15,"D"]
[16,"D"]
[17,"E"]
[18,"E"]
[19,"E"]
[20,"E"]
[21,"E"]
[22,"E"]
[23,"E"]
[24,"E"]
[25,"E"]
[26,"E"]
[27,"E"]
[28,"E"]
[29,"F"]
[30,"F"]
[31,"G"]
[32,"G"]
[33,"G"]
[34,"H"]
[35,"H"]
[{"$f":"A75+1","v":36},"I"]
[37,"I"]
[38,"I"]
[39,"I"]
[40,"I"]
[41,"I"]
[42,"I"]
[43,"I"]
[44,"I"]
[45,"J"]
[46,"K"]
[47,"L"]
[48,"L"]
[49,"L"]
[50,"L"]
[51,"M"]
[52,"M"]
[53,"N"]
[54,"N"]
[55,"N"]
[56,"N"]
[57,"N"]
[58,"N"]
[59,"O"]
[60,"O"]
[61,"O"]
[62,"O"]
[63,"O"]
[64,"O"]
[65,"O"]
[{"$f":"A105+1","v":66},"O"]
[67,"P"]
[68,"P"]
[69,"Q"]
[70,"R"]
[71,"R"]
[72,"R"]
[73,"R"]
[74,"R"]
[75,"R"]
[76,"S"]
[77,"S"]
[78,"S"]
[79,"S"]
[80,"T"]
[81,"T"]
[82,"T"]
[83,"T"]
[84,"T"]
[85,"T"]
[86,"U"]
[87,"U"]
[88,"U"]
[89,"U"]
[90,"V"]
[91,"V"]
[92,"W"]
[93,"W"]
[94,"X"]
[95,"Y"]
[96,"Y"]
[97,"Z"]
[98,"blank"]
[{"$f":"A138+1","v":99},"blank"]

{"sheet":"Bag","index":3,"n_rows":101,"n_cols":5,"rows_kept":101,"cut":false,"hidden":true,"merged":[]}
["Array Index","Letter",null,"****This page will be hidden from the players during game play.****"]
[0,"A",null,null,"Player 1)"]
[{"$f":"A2+1","v":1},"A"]
[{"$f":"A3+1","v":2},"A"]
[3,"A",null,null,"Player 2)"]
[4,"A"]
[5,"A"]
[6,"A",null,null,"Player 3)"]
[7,"A"]
[8,"A"]
[9,"B",null,null,"Player 4)"]
[10,"B"]
[11,"C"]
[12,"C"]
[13,"D"]
[14,"D"]
[15,"D"]
[16,"D"]
[17,"E"]
[18,"E"]
[19,"E"]
[20,"E"]
[21,"E"]
[22,"E"]
[23,"E"]
[24,"E"]
[25,"E"]
[26,"E"]
[27,"E"]
[28,"E"]
[29,"F"]
[30,"F"]
[31,"G"]
[32,"G"]
[33,"G"]
[34,"H"]
[35,"H"]
[{"$f":"A37+1","v":36},"I"]
[37,"I"]
[38,"I"]
[39,"I"]
[40,"I"]
[41,"I"]
[42,"I"]
[43,"I"]
[44,"I"]
[45,"J"]
[46,"K"]
[47,"L"]
[48,"L"]
[49,"L"]
[50,"L"]
[51,"M"]
[52,"M"]
[53,"N"]
[54,"N"]
[55,"N"]
[56,"N"]
[57,"N"]
[58,"N"]
[59,"O"]
[60,"O"]
[61,"O"]
[62,"O"]
[63,"O"]
[64,"O"]
[65,"O"]
[{"$f":"A67+1","v":66},"O"]
[67,"P"]
[68,"P"]
[69,"Q"]
[70,"R"]
[71,"R"]
[72,"R"]
[73,"R"]
[74,"R"]
[75,"R"]
[76,"S"]
[77,"S"]
[78,"S"]
[79,"S"]
[80,"T"]
[81,"T"]
[82,"T"]
[83,"T"]
[84,"T"]
[85,"T"]
[86,"U"]
[87,"U"]
[88,"U"]
[89,"U"]
[90,"V"]
[91,"V"]
[92,"W"]
[93,"W"]
[94,"X"]
[95,"Y"]
[96,"Y"]
[97,"Z"]
[98,"blank"]
[{"$f":"A100+1","v":99},"blank"]

{"sheet":"Gameboard","index":4,"n_rows":25,"n_cols":25,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"EXCEL SCRABBLE"]
[]
[null,null,"3W",null,null,"2L",null,null,null,"3W",null,null,null,"2L",null,null,"3W"]
[null,null,null,"2W",null,null,null,"3L",null,null,null,"3L",null,null,null,"2W"]
[null,null,null,null,"2W",null,null,null,"2L",null,"2L",null,null,null,"2W",null,null,null,"Player 1)",null,null,null,null,0,"Points"]
[null,null,"2L",null,null,"2W",null,null,null,"2L",null,null,null,"2W",null,null,"2L"]
[null,null,null,null,null,null,"2W",null,null,null,null,null,"2W"]
[null,null,null,"3L",null,null,null,"3L",null,null,null,"3L",null,null,null,"3L",null,null,"Player 2)",null,null,null,null,0,"Points"]
[null,null,null,null,"2L",null,null,null,"2L",null,"2L",null,null,null,"2L"]
[null,null,"3W",null,null,"2L",null,null,null,"Start",null,null,null,"2L",null,null,"3W"]
[null,null,null,null,"2L",null,null,null,"2L",null,"2L",null,null,null,"2L",null,null,null,"Player 3)",null,null,null,null,0,"Points"]
[null,null,null,"3L",null,null,null,"3L",null,null,null,"3L",null,null,null,"3L"]
[null,null,null,null,null,null,"2W",null,null,null,null,null,"2W"]
[null,null,"2L",null,null,"2W",null,null,null,"2L",null,null,null,"2W",null,null,"2L",null,"Player 4)",null,null,null,null,0,"Points"]
[null,null,null,null,"2W",null,null,null,"2L",null,"2L",null,null,null,"2W"]
[null,null,null,"2W",null,null,null,"3L",null,null,null,"3L",null,null,null,"2W"]
[null,null,"3W",null,null,"2L",null,null,null,"3W",null,null,null,"2L",null,null,"3W"]
[]
[null,null,"Key"]
[null,null,"2L - Double Letter Score"]
[null,null,"3L - Triple Letter Score"]
[null,null,"2W - Double Word Score"]
[null,null,"3W - Triple Word Score"]
[null,null,"2W - Double Word Score"]
[null,null,"3W - Triple Word Score"]