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..

image

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.

image

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

You can download Scrabbled from http://1drv.ms/1B3vzMe

Here are my previous games with Visio:

https://blog.bvisual.net/2014/12/29/how-to-play-yahtzee-with-visio/

https://blog.bvisual.net/2014/12/24/a-visio-countdown-to-xmas/

https://blog.bvisual.net/2014/12/03/a-visio-deck-of-cards/

Happy New Year!

2 Responses to “Get Scrabbled with Visio”

  1. John Says:

    Another job well done.
    So when are you going to tackle the periodic table? 😉


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Chris Webb's BI Blog

Microsoft Analysis Services, MDX, DAX, Power Pivot, Power Query and Power BI

davecra.wordpress.com/

Microsoft Office 365 Development, and more...

PowerShell.Amsterdam

Automate, Accelerate, Accurate

johnvisiomvp

Life with Visio and other Microsoft Toys!

Title (Required)

Windows Server Essentials Tips & Tricks

Nilsandrey's Weblog

Just another WordPress.com weblog

Things that Should be Easy

Every so often (too often in the IT industry) I encounter things that should have been very easy to do but turned out to be far too complicated. My favorite topics include SharePoint, .Net development, and software architecture, especially distributed systems.

Visio Guy

Shapes, Stencils, Drawings Templates, Tutorials, Tips & Developer Info for Microsoft Visio

Hannes's Virtual Earth

Tips & Tricks around Mapping and Cloud Computing

Pluralsight blog

be smart, be clear, be visual ...

%d bloggers like this: