Get Scrabbled with Visio

Last day of 2014, and the last of my word and number games in Visio … this is Scrabbled, which is a trainer for Scrabble. Okay, it was too difficult to do a fully working Scrabble board without code, and I was likely to break copyright if I did, so I invented a game with the Scrabble tile rack.

I have some suggested rules, but you can make your own up … I just wanted to see what I could do with just ShapeSheet functions..

It works in a similar manner to my previous three games. For example, the formula for Get random letter is:

=SETF(GetRef(User.RandomValue),INT(RAND()*27))

This pushes a number between 0 and 26 into the User.RandomValue cell, then the formula in the User.RandomValueTrigger reacts to this change in value and pushes it into the Prop.Letter cell:

=SETF(GetRef(Prop.Letter),”=INDEX(“&INT(User.RandomValue)+1&”,Prop.Letter.Format)”)

As John Goldsmith ( see http://visualsignals.typepad.co.uk/vislog/ ) pointed out to me, I don’t need DEPENDSON(User.RandomValue)+ in the above formula because User.RandomValue is already referenced.

The Letter Tile is minimalist and efficient as it it is comprised of only one sub-shape (to display the Value), and formatted with the Visio 2013 Top Bevel 3-D Format to give it that cool shaded look.

I have built the shape with the ability to include other languages, but have only included English currently.

You can download Scrabbled from ScrabbleTiles.vsdx

Here are my previous games with Visio:

How to play Yahtzee with Visio

A Visio Countdown to Xmas

A Visio Deck of Cards

Happy New Year!