• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

bVisual

  • Home
  • Services
    • How Visio smartness can help your business
    • Visio visual in Power BI
    • Visio Consulting Services
    • Visio Bureau Services
    • Visio Training and Support Services
  • Products
    • LayerManager
    • visViewer
    • Metro Icons
    • Rules Tools for Visio
    • The Visio 2010 Sessions App
    • Multi-Language Text for Visio
    • Document Imager for Visio
    • multiSelect for Visio
    • pdSelect for Visio
  • Case Studies
    • Case studies overview
    • Visualizing Construction Project Schedules
    • Visio Online Business Process Mapping
    • Nexans Visio Template
    • VRA makes the case for Prudential
    • CNEE Projects, WorldCom
    • Chase Manhattan Bank
  • News
    • Recent news
    • News archive
  • Resources
    • My session and other Visio sessions at MSIgnite 2019
    • Innovative uses of Visio Lists
    • Vision up your Visio diagrams
    • Power up your Visio diagrams
    • Mastering Data Visualization with Microsoft Visio
    • Microsoft Visio Business Process Diagramming and Validation
    • The Visio 2010 MVP Sessions
    • Visualizing Information with Microsoft Visio
    • Visio Web Learning Resources
  • Blog
    • Browse blog articles
    • Visio Power BI articles
    • Visio for Web articles
    • Visio blog on Orbus website
    • A history of messaging and encryption
  • About us
    • About bVisual
    • Testimonials
    • Bio of David Parker
    • Contact Us
    • Ariba Network
You are here: Home / Visio / Visio 2013 / Get Scrabbled with Visio

Published on December 31, 2014 by David Parker

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:

How to play Yahtzee with Visio
A Visio Countdown to Xmas
A Visio Deck of Cards

Happy New Year!

Print Friendly, PDF & Email

Related

Filed Under: Games, Lists, Visio 2013 Tagged With: Shape Data, ShapeSheet Functions

About David Parker

David Parker has 25 years' experience of providing data visualization solutions to companies around the globe. He is a Microsoft MVP and Visio expert.

Reader Interactions

Comments

  1. John says

    December 31, 2014 at 4:35 pm

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

    Reply

Trackbacks

  1. Visio Pro for Office365 Partner Templates | bVisual - for people interested in Microsoft Visio says:
    November 17, 2016 at 12:42 pm

    […] Scrabble Tiles – Get Scrabbled with Visio […]

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Sign up for our newsletter

No spam. Unsubscribe anytime. Get email updates whenever we publish new blog posts.

  • LinkedIn
  • Twitter

Recent Posts

  • Displaying Visio Number Shapes data clearly
  • Using Visio Org Chart Wizard to work with Exchange Online
  • Overcoming ‘We can’t open your file in Visio because it exceeds the shape count limit’ in Power BI
  • Visio news from MS Ignite 2019
  • Clarity Videos Re-boot

Categories

Tags

Accessibility Add-Ins Connectors Data Export Data Graphics Data Import DataRecordset Data Visualizer Educational Excel FM GraphDatabase Hyperlinks Icons Icon Sets JavaScript Layers Legend Link Data to Shapes Macros MSIgnite MVP Office365 Org Chart PowerApps PowerBI PowerQuery Processes Scales Shape Data ShapeSheet ShapeSheet Functions SharePoint 2013 SQL Validation VBA Video Visio Visio 2007 Visio 2013 Visio Pro for Office365 Visio Services Visio Viewer Web Webinar

Footer

bVisual Profile

The UK-based independent Visio consultancy with a worldwide reach. We have over 25 years experience of providing data visualization solutions to companies around the globe.

Learn more about bVisual

  • LinkedIn
  • Twitter

Search this website

Recent posts

  • Displaying Visio Number Shapes data clearly
  • Using Visio Org Chart Wizard to work with Exchange Online
  • Overcoming ‘We can’t open your file in Visio because it exceeds the shape count limit’ in Power BI
  • Visio news from MS Ignite 2019
  • Clarity Videos Re-boot

Sign up for our newsletter

No spam. Unsubscribe anytime. Get email updates whenever we publish new blog posts.

Copyright © 2019 bVisual Ltd. All rights reserved. · Privacy policy · Terms and conditions