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
Here is an Austrian version of Traffic Lights. Thanks to Jesse Aden.
Here is a blown up version of the same.
[...] This post was mentioned on Twitter by The Xcelsius Gurus, kalyanverma. kalyanverma said: Simulating Traffic Lights using Xcelsius. Literally! http://bit.ly/c06IvR [...]
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.
Thanks,
Yash
@Yash,
Why use a bubble chart when you have the Icon Component?
Oh yeah!!
Would use Icon and Play selector component
@Ram, looks like you got it…now, what would be the logic?
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.
100003003003
020003003003
003003003003
etc.
@Josh Interesting approach
@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?
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
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.