Update Log V1.3.3
Date Version Changes Issue Author
16/02/2006 1.0.1 Peds - Special All Red times has own button and uses normal intergreen lookups  Speed ranges for SAR not sufficient RNM
Detectors - XSF1 and XSF2 added to validation list Automatic data not provided RNM
17/02/2006 1.0.2 Target completion date formatted as text Date format changes on second and future updates RNM
Phasing North Arrow is linked picture to Group Allocation original  Phasing North should follow Group Allocation RNM
9/03/2006 1.0.3 Phasing Arrow Modified Phasing arrow draws attention by being dark/thick lines RNM
30/03/2006 1.0.5 Updated macro to perform rotation in Phasing sheet North Arrow not always behaving as intended RNM
6/05/2006 1.1 Version number added to face sheet No tracking for op sheet version RNM
PSC2003 new controller default is now V5 R78 Update from V4 R64 RNM
All Red and Special All Red calculated automatically - buttons removed Buttons used unnecessarily. RNM
Phase diagrams updated Phase diagram sizes unequal, Pn do not have group numbers, e.g. P4 not P4(12) or similar. RNM
Group Allocation diagram items regrouped Group arrows and numbers not grouped as single items RNM
Ops Sheet Menu name changed to OpSheet, menu unload/load procedure changed Multiple open books all have menu/macro from last loaded workbook. To avoid incompatibility with existing template, menu name should change RNM
10/05/2006 Only Alpha 16 and PSC2003 remain in New controller list Old controllers (unlikely to be used for new sites) remain in lists RNM
SCATS VC and COM are filled programatically With VC5 and HDLC parameters, SCATS sheet defaults for VC and COM more likely to be incorrect RNM
Document structure protected - sheets can not be added / deleted Document structure can be altered leading to macro problems RNM
Digital signature applied to workbook Workbook requires 'Enable Macros' to be selected on opening RNM
10/07/2006 1.2 Added Flexi sheets and 'Toggle Flexi Sheets' Menu Item Flexi sheets not included - manual work to complete site name/ no. etc. RNM
14/07/2006 1.2.1 Minor fixes to support all concerns Warrnambool not in SW municipality list, MSE municipality list too long, Unsupported 'regions' don't allow Business area entry without workaround RNM
17/07/2006 1.2.2 End-user error appears once on change/sheet opening for northpoint and ped design speeds.  Debug messages appear when save attempted if northpoint has been manually edited.  Also ped speed error can appear more than once. RNM
Gridlines reinstated "Peds" sheet can be confusing - 'phase(s)' cells no longer divided by gridlines RNM
20/07/2006 1.2.3 Guidance / Data validation provided where appropriate No limits on values in various cells (phase, split plans, no. of peds, timesettings) RNM
Formatting updated to text Split plan entries like '10 A' converted to 10:00 AM RNM
28/07/2006 1.2.4 "SCATS Data Changes -" text added to cover sheet Inconsistent text on cover for SCATS changes RNM
8/08/2006 1.2.5 New Controller Sheet reformatted with merged cells  New Controller Sheet does not allow multiple potential controllers to be entered easily RNM
26/09/2006 1.2.7 Input number column added to Detectors sheet Input mapping may differ from detector numbering RNM
5/10/2006 1.2.8 Format project no field on face sheets and data sheet as Text Project field may contain 'E', confused for scientific notation RNM
19/10/2006 1.2.9 Fix all sheets' formula for referencing site name Site name disappeared from detectors sheet after reformatting RNM
10/11/2006 1.3.0 Renamed to Roadside & Electrical Ops, format cell as shrink to fit On Road Electrical has been renamed - name may be too long to fit RNM
4/12/2006 1.3.1 Conflict Check button added No check for correctness of conflict RNM
11/12/2006 1.3.2 Detector sheet cells unmerged Errors owing to merged cells on detector sheet RNM
15/12/2006 Refer Special Notes is ticked for P1-8 Does not tick refer special notes on P1-P8 on detector sheet RNM
Added PIVOT text box to phasing PIVOT text has to be added manually RNM
19/03/2007 1.3.3 V5 R80 is new default for PSC New software version for PSC, V5 R80 released RNM