• 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 / Case Studies / Visualizing Construction Project Schedules

Visualizing Construction Project Schedules

[UPDATE July 2021 : This project has now become the subject of a Microsoft Customer Storey]

Construction projects can last many years and involve a large number of contractors and sub-contractors. It is essential that all of these different areas are co-ordinated and sequenced efficiently for effective and timely progression. This huge responsibility can often fall on the shoulders of a professional scheduler who may use applications like Microsoft Project or Oracle P6 to organize packets of work, sequence and resource them. Great as these tools are, they do not produce an output that can be easily understood on site by the managers, foremen and the tradesmen.

  • Lots of paper pages pinned to wall to try to understand the schedule
    Lots of paper pages pinned to wall to try to understand the schedule
  • A TimeTable printed and pinned up on the wall is easy to understand
    A TimeTable printed and pinned up on the wall is easy to understand

Robins & Morton provide construction scheduling, and even tried using Microsoft Visio to manually draw out diagrams to help present these complicated schedules. However, they soon realized that these diagrams need to be automatically created directly if they are going to be useful. Therefore, they sought out some Visio expertise, and asked bVisual, whose owner, David Parker, used to be an RIBA architect himself, and used to work on construction projects. David could understand the requirements of the R&M, and used his years of Visio expertise to enhance the proposed solution, which came to be known as TimeTable. R&M created a new company, BuildFore, develop this, and other construction project related applications.

Importing the Project XML

Microsoft Project can export XML, and Oracle P6 can export in Project XML format, so TimeTable can import this XML and summarize it with the WBS codes. The height of the drawing is dependent on the number of summary codes selected, and the width of the page can be controlled by selecting the date range and the time scale

Importing the Project XML

Drawing the TimeTable

The TimeTable is then automatically drawn using the selected summary tasks, date range and time scale.

Drawing the TimeTable automatically

Highlight Critical and Color by Value

Once drawn, the critical tasks can be highlighted, and all of the activities can be colored by a a selected range of values, such as the resources that were imported from the project XML.

Highlighting the critical activities and coloring them by a selected value

Import Abbreviations and Manipulate Labels

The activities are automatically labelled with their names, but these may be quite verbose, so a list of acceptable abbreviations can be imported to shorten the text length. If the labels still don’t fit within the activity shape, then they font size can be reduced, the text manually edited, or the label repositioned or rotated.

Importing abbreviations from a csv file and manipulating activity labels for clarity

Hide Non-Driving Links and Follow Links

The number of optionally displayed links betwen activities can be filtered by hiding the non-driving and/or intra summary task links.

Hyperlinks are automatically added to each link yo make it easy to quickly navigate between the predecessor and successor tasks.

Hiding non-driving links and navigating links from predecessor to successor

Setting the Data Range to Print

Although it is possible to plot very wide TimeTables on long pieces of paper, there are times when the focus needs to be a on a narrower date range. Moreover, this data range may need to shifted on a week, or a month, a quarter or even a year.

Setting the date range to print on smaller paper

Finding with the Outline Window and Adding a Legend

The Outline Window shows a hierarchy of all of the summary tasks, and can be used to highlight or zoom into a summary task. It also lists the activities and milestones of the selected summary task, and can be used to highlight or zoom to them too.

Similarly, any legends can be used to find all of the activities and milestones of a selected one …. even if they are outside the pritable range.

Finding summary tasks and activities with the Outline Window and adding  legend

Changing the TimeScale

The Time Scale can be varied from 1 day per inch to 1 day per quarter of an inch, with or without weekends, and from 1 week per inch to 1 week per quarter of an inch. This greatly varies the total width of the TimeTable for viewing or for printing.

Changing the time scale to vary the width of the page

Adding Scaled Annotations

The TimeTable page is divided horizontally into days, but the actual width of these days varies with the Time Scale selected. Os, when the user wants to add shapes to show the elapsed days from point A to B, or to highlight a particular date, then scaled annotations make this easy. They will stay in the required position when the printable data range is moved, and they will progressively disappear when they go beyond the start and end dates.

Inserting Informational Notes

Informational notes can be added by insering a reference to many of the properties of the TimeTable shape.

Adding anchored notes with inserted TimeTable information

An example TimeTable

TimeTables can be quite wide if they are intended to be printed for display on the wall of a construction site hut, or they can be sliced by date ranges to suit digital documentation. The embedded Visio TimeTable page below can be panned and zoomed.

Related blog articles

TimeTable at RMConnect 2022

I was privileged to be invited to the biennial Robins & Morton conference in Orlando recently, where I assisted in presenting TimeTable to the hundreds of attendees there. A single wall-hanger (OPS) TimeTable Visio diagram automatically drawn from #OraclePrimaveraCloud data, is a condensed version of the same data printed as a Gantt chart some six…

Getting the Microsoft Office Theme Value

I am working on a Visio VSTO project where I need to synchronise a UI element with the current session Microsoft Office Theme. At first, I thought that there would be some way of getting a value from the Visio object model, but I was wrong… The Office Theme can be selected from either the…

Week Nums in Timelines

Writing a WeekNum(…) function for Visio

Learn how to write a WeekNum() function for Visio ShapeSheet, just like Excel’s!

Using Advanced Installer with Viso VSTO Add-Ins

Read how I used Advanced Installer with my Visio VSTO add-in

The Ruler & Grid dialog

Really Snapping to Grids in Visio

Learn how to ensure that Visio shapes snap and size to fixed grids

EvalCell Shape

Using EVALCELL() in Visio to calculate Workdays

Using the EVALCELL() formula in Visio to return equivalent of NETWORKDAYS() in Excel

Primary Sidebar

  • LinkedIn
  • Twitter

Recent Posts

  • Co-authoring and Commenting with Visio Documents
  • 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

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

  • Co-authoring and Commenting with Visio Documents
  • 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

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