• 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
    • Visio Shape Report Converter
    • SS Plus
    • 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
    • Using Visio in Education for GIS
    • Visualizing Construction Project Schedules
    • Visio Online Business Process Mapping
    • Nexans Visio Template
    • CNEE Projects, WorldCom
    • Chase Manhattan Bank
  • News
    • Recent news
    • News archive
  • Resources
    • Articles➡
      • ShapeSheet Functions A-Z
      • Comparing Visio for the Web and Desktop
      • Customising Visio Shapes for the Web App
      • Key differences between the Visio desktop and web apps
      • Using the Visio Data Visualizer in Excel
      • Using Visio in Teams
      • Creating Visio Tabs and Apps for Teams with SharePoint Framework (SPFx)
      • Designing Power Automate Flows with Microsoft Visio
      • Innovative uses of Visio Lists
    • Webcasts ➡
      • Visio in Organizations
      • My session and other Visio sessions at MSIgnite 2019
      • Power up your Visio diagrams
      • Vision up your Visio diagrams
      • The Visio 2010 MVP Sessions
    • Visio Web Learning Resources
    • Books➡
      • Visualize Complex Processes with Microsoft Visio
      • Mastering Data Visualization with Microsoft Visio
      • Microsoft Visio Business Process Diagramming and Validation
      • Visualizing Information with Microsoft Visio
  • Blog
    • Browse blog articles
    • Visio Power BI articles
    • Visio for Web articles
    • A history of messaging and encryption
  • About us
    • About bVisual
    • Testimonials
    • Bio of David Parker
    • Contact Us
    • Website Privacy Policy
    • Website terms and conditions
    • Ariba Network
You are here: Home / Diagram Types / Games / A Visio Countdown to Xmas

Published on December 24, 2014 by David Parker

A Visio Countdown to Xmas

I presented a Visio deck of cards in a previous post ( see http://blog.bvisual.net/2014/12/03/a-visio-deck-of-cards/ ), and now I present a real game that can be played with Visio over the holiday season. Countdown is a British TV programme with word and number puzzles. It was the first programme to be aired on Channel 4, and 70 series have been broadcast since its debut on 2 November 1982. With over 6,000 episodes, Countdown is one of the longest-running game shows in the world, along with the original French version, Des chiffres et des lettres, which has been running on French television continuously since 1965. Read more at http://en.wikipedia.org/wiki/Countdown_%28game_show%29.

image

You can download this Visio 2013 document from CountdownGame.vsdx There are no macros because I have restricted myself to using just ShapeSheet formulas. This example shows how a combination of List Containers and Items, along with ShapeSheet formulas can achieve a lot without resorting to any code. I am particularly pleased with being able to construct a word from the letters inside the Letter Rack, or to evaluate the arithmetic from the numbers and arithmetic characters in side the Number Rack.

A Countdown game normally consists of :

  • 10 Letter Rounds
  • 4 Number Rounds
  • A final Conundrum round

I have put instructions on each page on how to play each round, and links to a Countdown Clock web page to time yourself.

In the Letter Round, you drop 9 letter tiles, vowels and consonants, and then have 30 seconds to make as long a word as you can:

image

In the Number Round, dropping a new CECIL shape on the page creates a random 3 digit number. Then you need to get 6 number tiles (Large and Small).

image

You then have 30 seconds to work out how to get close to the target number by using arithmetic expressions with the numbers.

image

For the Conundrum round, I found a list of 9 letter words on the internet at BestWordList.com. They are intended for use with Scrabble, but I have chopped this list up into 8 parts because a Visio cell can can only hold 32k characters. There are 24,869 words in total, and the Conundrum shape picks one at random, which can then be put into the textbox on the Countdown Clock web page at http://www.interactiveclock.com/countdown-clock-and-word-jumble-resource.html.

image

You can solve Countdown word and number puzzles at http://incoherency.co.uk/countdown/

Enjoy!

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

Trackbacks

  1. Get Scrabbled with Visio | bVisual - a blog for people interested in Microsoft Visio says:
    December 31, 2014 at 8:08 am

    […] http://blog.bvisual.net/2014/12/24/a-visio-countdown-to-xmas/ […]

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

    […] Countdown game – A Visio Countdown to Xmas […]

    Reply

Leave a Reply Cancel reply

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

Primary Sidebar

  • LinkedIn
  • Twitter

Recent Posts

  • Fixing dimensions of 2D shapes
  • Merging Linked Data from Similar Tables
  • Smart Radio Buttons and Check Boxes in Visio
  • Using Button Face Ids in Visio
  • Grid Snapping Revisited

Categories

Tags

Accessibility Add-Ins Connectors Containers Data Export Data Graphics Data Import Data Visualizer Educational Excel GraphDatabase Hyperlinks Icon Sets JavaScript LayerManager Layers Legend Link Data to Shapes Lists MSIgnite MVP Office365 Org Chart PowerApps PowerBI PowerQuery Processes Setup and Deployment Shape Data Shape Design ShapeSheet ShapeSheet Functions SharePoint 2013 SQL Teams Validation VBA Video Visio Visio 2007 Visio for the Web Visio Online Visio Services Visio Viewer 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

  • Amazon
  • E-mail
  • Facebook
  • LinkedIn
  • Twitter
  • YouTube

Search this website

Recent posts

  • Fixing dimensions of 2D shapes
  • Merging Linked Data from Similar Tables
  • Smart Radio Buttons and Check Boxes in Visio
  • Using Button Face Ids in Visio
  • Grid Snapping Revisited

Copyright © 2025 · Executive Pro on Genesis Framework · WordPress · Log in