Simulating Traffic Lights using Xcelsius. Literally!

On a bright Sunday morning, it just clicked to me and I thought, why not. I will leave this for you all to figure it out. Please use the comments section to let me know how would you create this simulation in Xcelsius. I will definitely share the code, however I would like to see your approach first. Just to give you a hint, I’m using the color binding property that came along with the new SP3. Here is a blown up version of the same.

Update: 13 Apr 2010

Download Source Files

Here is an Austrian version of Traffic Lights. Thanks to Jesse Aden.

Here is a blown up version of the same.

  • Pingback: Tweets that mention Simulating Traffic Lights using Xcelsius. Literally! รขโ‚ฌโ€œ MyXcelsius.Com --

  • Yash Patel

    I would begin by using alerts in bubble chart to form the traffic light and then use play selector to time it. Let me know your thoughts.


    • @Yash,
      Why use a bubble chart when you have the Icon Component? ๐Ÿ˜‰

      • Yash Patel

        Oh yeah!! ๐Ÿ™‚

  • Ram

    Would use Icon and Play selector component

    • @Ram, looks like you got it…now, what would be the logic?

  • Josh Tapley

    I would do the following:

    Establish 9 icons and link them each to cells in a row: A1, B1, C1, etc. Next setup alerts (disable auto color) for 0,1,2 and 3 to be black, green, yellow and red respectively. You then hide the play selector using dynamic visibility.

    The play selector would use the row insert into row one from a table with all of the defined interations as displayed in the sample table below. You could use nested if statements to remove the table, but that might be more trouble than it’s worth.


  • @All, I’ve updated the post with the Download link to the Source XLF. Make sure you are running SP 3

  • I am in Austria, and we have a bit of a different street light system… I used your file and created my own simple version with vlookup and values. I think it would be more complicated using the new color set-up as you did.
    Is it faster processor-wise or something?

    Also, is there somewhere to upload this version, or no?

  • Josh Tapley

    Vlookups tend to slow the file in general and seem to cause odd scripting errors on occassion. The match and offset functions appear to be more efficient.

    I also recommend skipping pivot tables (or at least paste-special-values in the version that you import into Xcelsius).

  • @Yash,
    Why use a bubble chart when you have the Icon Component? ๐Ÿ˜‰

  • @Josh Interesting approach

  • Darryn

    Could anyone help me figure out how to play pie chart with play control, just cant figure it out.

    I have data dynamically displayed when you select each section of the pie chart, but I would like the pie chart to play i.e. section to be selected at 1 min intervals.

    Also the properties of my play control seem different to what I have seen in examples – using SP3 Xcelsius 2008 Engage.

    • @Darryn Use the Play Selector from the Selectors category (Not Play Control). Use the Row/Column insert type to acheive the desired functionality. Set the duration (in seconds) to give u 1min intervals (E.g. If you have 6 items, set the duration to 6×60=360 sec).

      Unfortunately you cannot bind the selected item for a pie chart. You can only select a series number in design time which is pretty much hardcoded.

  • sagar

    Hi Kalyan,

    I am having a problem with the Dynamic Binding. I am getting data dynamically,used vlookup condition to look for a particular name and displays a color based on the name in a is working fine with the static data. But whenever i am getting data from the database that colors are not showing and showing the graph with Black Colors. Is this Dynamic binding cannot applicable for Pie,Stacked Bar Charts? Could You please help on this?

    Sagar Reddy