• 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
    • 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
    • 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
    • Articles➡
      • Comparing Visio for the Web and Desktop
      • Customising Visio Shapes for the Web App
      • Key differences between the Visio desktop and web apps
      • 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 ➡
      • 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➡
      • 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
    • Visio blog on Orbus website
    • 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 / Shape Design / ShapeSheet Formulas / Play Checkers with Visio in Teams

Published on December 25, 2020 by David Parker

Play Checkers with Visio in Teams

We are all spending more time in Teams or SharePoint nowadays, but not everyone knows that Visio documents can now be shared and collaborated with, and even set as a Teams tab. I was trying to think of a suitable demonstration of the co-working and collaboration possibilities, and came up with a reworking of an earlier post about playing checkers with Visio. Since this previous document was made before Visio for the web, I made some enhancements that work just as well with Visio for desktop and Visio for the web. This article explains a few ShapeSheet customisations that can be developed in Visio for the desktop, but can then be used in Visio for the web. Notice how each player can see which piece was moved by their opponent because their initials are displayed, and this is expanded to the full name if the mouse cursor is hovered over them.

Two players co-working in Visio for the web

Firstly, I reminded myself of the rules of checkers (or draughts in the UK), and for the first time realised that there are three different sizes of boards, 8×8, 10×10 and 12×12. So, my new board shape has the ability of switching between each with a simple data change that can be done with the Shape Data window or a right mouse menu action. However, I have included three pages in the provided Visio document, one for each board size, along with the checkers already laid out.

Secondly, I think that one of the time-consuming parts of playing checkers is setting the pieces up for the start of a game, so I wanted to include a purely ShapeSheet way of re-positioning the pieces easily, and one that can work in Visio for the web.

The rules of the game can be opened from the right mouse menu of the Controller shape in the top left corner. The board can be reset by selecting the Reset Positions option on the right mouse menu, twice.

  • Right mouse menu of instructions to view the rules
  • Right mouse menu of a checker to make a King (or change colour)
  • Select Reset Positions at the end of a game
  • Select Reset Positions again before starting a game

When a checker is taken, then it should just be moved to the side, off the board. It should not be deleted because it will be automatically re-positioned before the start of a new game.

When a checker reaches the opposite end, then the right mouse menu of the checker turns it into a King. There is no need to manually turn the back to normal mode at the end of a game, because the Reset Positions action will do this too.

The page has been set to a Fixed Grid, with the XGridSpacing and YGridSpacing set to the same dimensions of the squares in the board. This makes it easier to snap the checker pieces in the squares.

The ShapeSheet formula that does this is in the User.SizeTrigger cell of the Controller shape:

=SETF(GetRef(ThePage!XGridSpacing),"="&Width/User.Units)+
SETF(GetRef(ThePage!YGridSpacing),"="&Width/User.Units)+
SETF(GetRef(ThePage!XRulerDensity),"=0")+
SETF(GetRef(ThePage!YRulerDensity),"=0")+
SETF(GetRef(ThePage!XGridDensity),"=0")+
SETF(GetRef(ThePage!YGridDensity),"=0")

The User.Units value is 8, 10 or 12, depending upon the Prop.Size option selected. The change in value will cause the formula in User.SizeTrigger to set the desired changes in the page cells.

  • The Board ShapeSheet
  • The PageSheet
  • The Controller ShapeSheet
  • The Checker ShapeSheet

So, how does the position resetting work? Well, there is a ResetPositions User-defined cell whose value is toggled between TRUE and FALSE by the Reset Positions action of the Controller shape.

When the User.ResetPositions value in the page is TRUE, then in value causes the formula in the User.PinTrigger of each Checker shape to set the PinX, PinY, Prop.King and Prop.Color formulas. These formulas are captured when the User.SetPositions vale in the page is TRUE.

=IF(ThePage!User.SetPositions,
SETF(GetRef(User.PinX),"="&PinX)+
SETF(GetRef(User.PinY),"="&PinY)+
SETF(GetRef(User.Color),"="&User.ColorIdx)
,
IF(ThePage!User.ResetPositions,
SETF(GetRef(PinX),"="&User.PinX)+
SETF(GetRef(PinY),"="&User.PinY)+
SETF(GetRef(Prop.King),"=FALSE")+
SETF(GetRef(Prop.Color),"=INDEX("&User.Color&",Prop.Color.Format)")
,
0)
)

Note that the right mouse menu of the page is not available in Visio for the web, so the Controller shape duplicates these actions, but I have left the Set Positions row as invisible, since it is only required to capture the formulas when the board has been initially laid out. After that, the only action required is the Reset Positions one.

All in all, I think that this demonstrates that Visio for the desktop can be used to create smart Visio documents that can be edited in Visio for the web.

Please download the Online Checkerboards.vsdx and try it in your own Office365 tenant, and maybe include it as a tab in Teams.

Play Backgammon with Visio

Still in lockdown on holiday, so I thought I would create a version of backgammon that can be played with Visio for the web. This was inspired by my original Visio tutor, the late David Edson, who created a Visio backgammon document which included macros. Macros are not available in Visio for the web, so…

Play Chess with Visio in Teams

Following on from my last article about playing checkers with Visio in Teams, I decided that I should also revisit my earlier Visio chessboard to make it work in Visio online. I have implemented the ability to automatically reset the positions before a new game, and I have made a single chess piece shape that…

Visio is NOT Vizio!

Update 1 : Microsoft read this post and immediately corrected the spelling so the following now works : https://adoption.microsoft.com/virtual-hub/search/?_sft_vh_product=microsoft-visio 🙂 Update 2 : Mr VisGuy! “spelt” is the same as “spelled” outside USA! Aarghh! What kind of message is sent out if a company does not know how to spell the name of their own…

Visio now and beyond at Microsoft Ignite 2020

I have presented at the last four Microsoft Ignite conferences and was part way through the world-wide tour when this pandemic began. I was looking forward to visiting New Orleans for this years shindig, but, alas, we are now in a new world where in-person events are a fond memory. Fortunately, Microsoft have the tools…

Visio Slide Snippets

Manual Fix for Slide Snippets in Visio Plan 2

Microsoft Visio Plan 2 has a cool feature, Slide Snippets, that can create a PowerPoint slide show from special rectangle shapes placed around the pages of a Visio document. Unfortunately, there is currently an issue with distortion of the images in PowerPoint, so I will show how this can be fixed manually… (more…)

Learn how to create custom Visio web app templates

I have now finished three articles about the differences between the Visio desktop and web apps, and how you can already create custom templates for Visio Plan 1. Comparing Visio for the Web and Desktop Customising Visio shapes for the web app Key differences between the Visio desktop and web apps Register for my webinar…

    Related

    Filed Under: Games, ShapeSheet Formulas, SharePoint Online, Teams, Visio for Desktop, Visio for Web, Visio Online Tagged With: ShapeSheet Functions, SharePoint, Teams, Visio for the desktop, Visio for the Web

    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

    Leave a Reply Cancel reply

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

    Primary Sidebar

    • LinkedIn
    • Twitter

    Recent Posts

    • Referencing Visio Shapes
    • Play Backgammon with Visio
    • Play Chess with Visio in Teams
    • Play Checkers with Visio in Teams
    • Creating PowerPoint Presentations automatically from Visio

    Categories

    Tags

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

    • Referencing Visio Shapes
    • Play Backgammon with Visio
    • Play Chess with Visio in Teams
    • Play Checkers with Visio in Teams
    • Creating PowerPoint Presentations automatically from Visio

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

    We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OkPrivacy policy