{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Lists","Version","Base - Site","Base - Network","Proposed- Site","Proposed - Network"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":12,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Lists","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,"Modeller","Auditor","ProModeller"]
[null,"TBC","TBC","TBC"]
[null,"As recommended","Info required","As Base"]
[null,"Modified","Pass","As proposed"]
[null,"NA","Fail","NA"]
[null,null,"NA"]

{"sheet":"Version","index":1,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,"Document Control"]
[]
[null,"Version number","Date","Author/Editor","Nature of Amendment","TRIM Reference"]
[null,"1.0","Sept 2018","OMV - MK","First Release","D17#712398"]
[null,"2.0","2020-09-01","OMV - MK","Second Release - SIDRA 9","D20#1074330"]

{"sheet":"Base - Site","index":2,"n_rows":203,"n_cols":6,"rows_kept":203,"cut":false,"hidden":false,"merged":[[0,1,0,4],[202,1,202,5],[188,4,188,5],[190,4,190,5],[192,4,192,5],[12,4,12,5],[138,4,138,5],[145,4,145,5],[152,4,152,5],[160,4,160,5],[169,4,169,5],[100,4,100,5],[109,4,109,5],[122,4,122,5],[124,4,124,5],[133,4,133,5],[59,4,59,5],[75,4,75,5],[78,4,78,5],[87,4,87,5],[93,4,93,5],[25,4,25,5],[37,4,37,5],[40,4,40,5],[43,4,43,5],[55,4,55,5],[1,2,1,4],[8,2,8,4],[9,2,9,4],[2,2,2,4],[3,2,3,4],[4,2,4,4],[5,2,5,4],[6,2,6,4],[7,2,7,4]]}
[null,"SIDRA Base Model Audit Checklist - Site (Ver 2.0)"]
[null,"Project Information",{"$f":"IF(C4=\"\",\"\",C4)","v":""}]
[null,"Project"]
[null,"Model Name"]
[null,"Site Name"]
[null,"Site ID (if applicable)"]
[null,"Applicant (Name & Organisation / MRWA Team)"]
[null,"Modeller (Name & Consultancy / MRWA Team)"]
[null,"Auditing Process Coordinator (Name & MRWA Team)"]
[null,"Model Auditor (Name & MRWA Team)"]
[]
[null,"Base Model Checks","Modeller","Model Auditor","Find it in SIDRA software - SITE tab","General SIDRA Model Criteria\n(also check Modelling Instruction Form for specific requirements)"]
[null,"Supply Information - for all sites",{"$f":"IF((COUNTIF(Table4[Column2],\"\")+COUNTIF(Table4[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table4[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table4[Column4],\"info required\")+COUNTIF(Table4[Column4],\"TBC\")+COUNTIF(Table4[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"Electronic version of base model(s)","TBC","TBC"]
[null,"Approved Modelling Instruction Form","TBC","TBC"]
[null,"Traffic survey data","TBC","TBC"]
[null,"Site observations notes","TBC","TBC"]
[null,"SCATS history files","TBC","TBC"]
[null,"SCATS traffic flows","TBC","TBC"]
[null,"Existing drawings","TBC","TBC",null,"e.g. LMA drawings and SCATS graphic "]
[null,"Peak hour estimation spreadsheet","TBC","TBC"]
[null,"Average signal timings spreadsheet","TBC","TBC",null,".xlsx file should be provided."]
[null,"Marked measurement on layout ","TBC","TBC",null,"e.g. lane lengths, lane width, roundabouts island diameter etc."]
[null,"Other input data","TBC","TBC"]
[null,"Base modelling calibration and validation report","TBC","TBC"]
[null,"INTERSECTION",{"$f":"IF((COUNTIF(Table5[Column2],\"\")+COUNTIF(Table5[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table5[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table5[Column4],\"info required\")+COUNTIF(Table5[Column4],\"TBC\")+COUNTIF(Table5[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"INTERSECTION Dialog - Intersection Tab"]
[null,"Sites - Control ","TBC","TBC","PROJECT Pane","Signals, Roundabout, Sign Control, etc."]
[null,"Site Name ","TBC","TBC","Site Data - Site Name","All sites to be labelled reasonably (Intersection name, AM/PM, Year, etc.)"]
[null,"Site ID","TBC","TBC","Site Data - Site ID","e.g. SCATS TCS"]
[null,"Intersection legs direction","TBC","TBC","Approach Editor","N, NE, E, SE, S, SW, W or NW"]
[null,"Name (approach)","TBC","TBC","Approach Geometry - Name","Road Name"]
[null,"Leg geometry","TBC","TBC","Approach Geometry - Leg Geometry","Two-way, One-way Approach or Exit"]
[null,"Approach lanes distance","TBC","TBC","Approach Geometry - Approach Distance","For internal arms within a network, Approach Distance should be measured from the last conflict point of all exit movements at the upstream site to the stop line of the current site. The default value of Approach Distance (500 meters) can be used for external arms."]
[null,"Exit lanes distance (if applicable)","TBC","TBC","Approach Geometry - Exit Distance","Applicable if exit lane distance is not the same as approach distance (Input)"]
[null,"Extra Bunching (if applicable)","TBC","TBC","Approach Data - Extra Bunching","Refer to the Operational Modelling Guidelines."]
[null,"Area Type Factor  (Signals only)","TBC","TBC","Signals - Area Type Factor","Calibration parameter for Signals. Modifications should be justified."]
[null,"Approach Control (Sign Control sites only)","TBC","TBC","Sign Control - Approach Control "," Major Road, Give-way/Yield or Stop"]
[null,"VEHICLE CLASSES",{"$f":"IF((COUNTIF(Table6[Column2],\"\")+COUNTIF(Table6[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table6[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table6[Column4],\"info required\")+COUNTIF(Table6[Column4],\"TBC\")+COUNTIF(Table6[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"MOVEMENT DEFINITIONS Dialog - Movement Classes Tab"]
[null,"Additional standard vehicle classes (if applicable)","TBC","TBC","Standard Classes"]
[null,"Additional user defined vehicle classes (if applicable)","TBC","TBC","User Classes"]
[null,"MOVEMENTS",{"$f":"IF((COUNTIF(Table7[Column2],\"\")+COUNTIF(Table7[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table7[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table7[Column4],\"info required\")+COUNTIF(Table7[Column4],\"TBC\")+COUNTIF(Table7[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"MOVEMENT DEFINITIONS Dialog - Origin- Destination Movements Tab"]
[null,"Banned Movements exists (if applicable)","TBC","TBC","Origin - Destination Movements - Movement Exists","SIDRA checks all movements except U-turns by default. Uncheck any banned movements."]
[null,"U-turn Movements exists (if applicable)","TBC","TBC","Origin - Destination Movements - Movement Exists","U-turn movements box should be ticked if applicable. If U-turn before intersection is excluded from the analysis, it should be mentioned in the modelling report."]
[null,"LANE GEOMETRY",{"$f":"IF((COUNTIF(Table8[Column2],\"\")+COUNTIF(Table8[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table8[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table8[Column4],\"info required\")+COUNTIF(Table8[Column4],\"TBC\")+COUNTIF(Table8[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"LANE GEOMETRY Dialog - Lane Configuration Tab"]
[null,"Number of lanes (approach and exit lanes)","TBC","TBC","Lane Configuration Data -  Lane Editor","Approach and exit lanes should be checked."]
[null,"Lane configuration (approach and exit lanes)","TBC","TBC","Lane Configuration Data -  Lane Configuration","Full-length, short lane, short lane with parking or two-segment lane "]
[null,"Lane type","TBC","TBC","Lane Configuration Data -  Lane Type","Normal, Slip/Bypass - High or Short Angle"]
[null,"Lane control (approach and exit lanes)","TBC","TBC","Lane Configuration Data - Lane Control","Signals, Give-way/Yield, Stop, or Continuous"]
[null,"Lane length (approach and exit lanes)","TBC","TBC","Lane Configuration Data - Lane Length","Set equal to Approach Distance automatically. For isolated, long lanes length can be left as default (500 meters).\nFor networks, Lane Length is important for internal approaches since it acts as storage length that affects the probability of blocking upstream lanes. "]
[null,"Short lane length (compulsory)","TBC","TBC","Lane Configuration Data - Short Lane Length","Short Lane Length typically to be measured from the stop point to where the lane width is 2.0m at the taper section. "]
[null,"Lane width","TBC","TBC","Lane Configuration Data - Lane Width","Printed width in LM drawings may not be accurate."]
[null,"Lane grade","TBC","TBC","Lane Configuration Data - Grade","To be defined based on the traffic movement direction (Flat = 0, Uphill>0 and Downhill <0)."]
[null,"Overflow Lane Number /  Merge Lane Number","TBC","TBC","Lane Configuration Data - Overflow Lane Number /  Merge Lane Number"]
[null,"Islands geometry","TBC","TBC","Lane Configuration Data - Strip Island Configuration Data","Front and back width"]
[null,"Intersection Geometry","TBC","TBC","Double click on the Site","Overall geometry of model should be consistent with the existing road geometry."]
[null,"LANE DICIPLINES",{"$f":"IF((COUNTIF(Table9[Column2],\"\")+COUNTIF(Table9[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table9[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table9[Column4],\"info required\")+COUNTIF(Table9[Column4],\"TBC\")+COUNTIF(Table9[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"LANE GEOMETRY Dialog - Lane Disciplines Tab"]
[null,"Available movements for each Vehicle class (All approaches)","TBC","TBC","Lane Disciplines","E.g. Bus lanes.  This should be checked against the lane marking."]
[null,"Free queue area (for Signals only)","TBC","TBC","Lane Disciplines -  Free Queue Distance"]
[null,"Two-segment lanes definition (if applicable)","TBC","TBC","Lane Disciplines"]
[null,"LANE DATA",{"$f":"IF((COUNTIF(Table10[Column2],\"\")+COUNTIF(Table10[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table10[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table10[Column4],\"info required\")+COUNTIF(Table10[Column4],\"TBC\")+COUNTIF(Table10[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"LANE GEOMETRY Dialog - Lane Data Tab"]
[null,"Basic Saturation Flow data (Through Car Unit / Hour)","TBC","TBC","Approach Lane Data - Basic Saturation Flow","If it is adjusted for calibration purposes of Signals, justification should be provided. For justification, measurements can be attempted on site for the critical approaches (vehicle / hour)."]
[null,"Apply Saturation Flow Estimation","TBC","TBC","Approach Lane Data - Basic Saturation Flow","This checkbox should be ticked, otherwise, justifications should be provided."]
[null,"Short Lane Capacity (calibration Options)","TBC","TBC","Approach Lane Data - Basic Saturation Flow","This should be 'Program'."]
[null,"Delay Model Parameters (Uninterrupted Flow)","TBC","TBC","Approach Lane Data - Basic Saturation Flow","This should be 'Program'."]
[null,"Lane Utilisation","TBC","TBC","Approach Lane Data - Lane Utilisation Ratio","If it is used for calibration, justification should be provided in the modelling report."]
[null,"Saturation Speed","TBC","TBC","Approach Lane Data - Saturation Speed","If it is measured on site, data should be provided."]
[null,"Capacity adjustment","TBC","TBC","Approach Lane Data - Capacity Adjustment","MRWA does not recommend to adjust this parameter. If adjusted, justification should be provided in the modelling report."]
[null,"Bus Stopping (if applicable) - Signals only","TBC","TBC","Signals - Bus Stopping"]
[null,"Parking manoeuvres (if applicable) - Signals only","TBC","TBC","Signals - Parking Manoeuvres"]
[null,"Dominant Lane - Roundabouts only","TBC","TBC","Roundabouts - Dominant Lane"]
[null,"Merge Type (Exit lanes)","TBC","TBC","Merge Analysis","Merge Analysis should be applied and Merge Type should be defined based on site observations."]
[null,"Percent  Opposing in Short Lane and in Merge Lane","TBC","TBC","Merge Analysis","Based on site observations."]
[null,"Critical Gap and Follow-up Headway (Merge Analysis)","TBC","TBC","Merge Analysis","Default values can be applied, otherwise, justifications should be provided in the modelling report."]
[null,"Minimum Departures (vehicles per minute)","TBC","TBC","Merge Analysis","Default values can be applied, otherwise, justifications should be provided in the modelling report."]
[null,"Exclude Slip/Bypass Lane from Signal Analysis","TBC","TBC","Signals","This checkbox should be ticked, otherwise, justifications should be provided in the modelling report."]
[null,"LANE MOVEMENTS",{"$f":"IF((COUNTIF(Table11[Column2],\"\")+COUNTIF(Table11[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table11[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table11[Column4],\"info required\")+COUNTIF(Table11[Column4],\"TBC\")+COUNTIF(Table11[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"LANE MOVEMENTS Dialog - Flow Proportions or Blockage Calibration Tabs"]
[null,"Exit lanes flow proportions","TBC","TBC","Flow Proportions Tab - Lane Movement Flow Proportions","These affect downstream blockage estimates for upstream lanes as well as second-by-second platoon arrival patterns for downstream lanes"]
[null,"Exit lane blockage factor","TBC","TBC","Blockage Calibration Tab - Lane Blockage Calibration Factor","For calibration of program estimates for downstream blocking. If used, justification should be provided in the modelling report."]
[null,"ROUNDABOUTS (Roundabouts only)",{"$f":"IF((COUNTIF(Table12[Column2],\"\")+COUNTIF(Table12[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table12[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table12[Column4],\"info required\")+COUNTIF(Table12[Column4],\"TBC\")+COUNTIF(Table12[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"ROUNDABOUTS Dialog - Options or Roundabout Data Tabs"]
[null,"Roundabout Capacity Manual","TBC","TBC","Options tab - Roundabout Model Options","If it is not SIDRA Standard, justification should be provided in the modelling report."]
[null,"Exclude Geometry Delay","TBC","TBC","Options tab - Roundabout Model Options","If Exclude Geometric Delay parameter is checked, justifications should be provided in the modelling report."]
[null,"Number of Circulating Lanes","TBC","TBC","Roundabout data tab - Geometry"]
[null,"Circulating Width","TBC","TBC","Roundabout data tab - Geometry"]
[null,"Island Diameter or Inscribed Diameter","TBC","TBC","Roundabout data tab - Geometry"]
[null,"Entry Radius and Entry Angle","TBC","TBC","Roundabout data tab - Geometry"]
[null,"Environment Factor","TBC","TBC","Roundabout data tab - SIDRA Standard Roundabout Model Calibration","If this is modified to calibrate the Roundabout model, justification should be provided in the modelling report."]
[null,"Entry/Circulating Flow Adjustment","TBC","TBC","Roundabout data tab - SIDRA Standard Roundabout Model Calibration"]
[null,"ROUNDABOUTS (Metered Roundabouts only)",{"$f":"IF((COUNTIF(Table13[Column2],\"\")+COUNTIF(Table13[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table13[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table13[Column4],\"info required\")+COUNTIF(Table13[Column4],\"TBC\")+COUNTIF(Table13[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"ROUNDABOUTS Dialog - Roundabout Metering Tab"]
[null,"Metered and controlled approaches coding","TBC","TBC"]
[null,"Stop Line Setback Distance","TBC","TBC","Roundabout Metering - Metered Approach"]
[null,"Start Loss and End Gain","TBC","TBC","Roundabout Metering - Metered Approach","If modified, justification should be provided in the modelling report."]
[null,"Cycle Time Option","TBC","TBC","Cycle Time Option","Applied option should be specified in the modelling report."]
[null,"Phase Data - Yellow Time, All-Red Time and Minimum Phase Time","TBC","TBC","Phase Data","For an existing site should be as per SCATS settings (roundup 0.5 seconds)."]
[null,"PEDESTRIAN",{"$f":"IF((COUNTIF(Table14[Column2],\"\")+COUNTIF(Table14[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table14[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table14[Column4],\"info required\")+COUNTIF(Table14[Column4],\"TBC\")+COUNTIF(Table14[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"PEDESTRIAN Dialog - Pedestrian Movements or Pedestrian Movement Data Tabs"]
[null,"Crossing types","TBC","TBC","Pedestrian Movements Tab - Movement definitions - Pedestrian Movements Tab - Main Crossing","None, full crossing or staged crossing, signalised slip/bypass lane crossing, unsignalised (zebra) slip/bypass lane crossing or diagonal crossing"]
[null,"Pedestrian volume unit and peak period (if applicable)","TBC","TBC","Volume Data Settings for Site"]
[null,"Pedestrian Volume","TBC","TBC","Pedestrian Movements Tab - Volume Data","Entered as per site survey. SIDRA SOLUTIONS highly recommends to input the real data or reasonable pedestrian volume rather than using default. These may affect signal timings when Pedestrian Actuation feature is on (default)."]
[null,"Crossing Distance","TBC","TBC","Pedestrian Movement Data Tab - Pedestrians Movements Data - Crossing Distance","When it is 'Input', then measured on site, on drawings or map"]
[null,"Conflict Zone Length","TBC","TBC","Pedestrian Movement Data Tab - Conflict Zone Length","Conflict Zone Length should be set as Program. Otherwise, justification should be provided in the modelling report"]
[null,"Walking Speed","TBC","TBC","Pedestrian Movement Data Tab - Pedestrians Movements Data - Walking Speed (Average)"]
[null,"PEDESTRIAN TIMING DATA (Signals only)",{"$f":"IF((COUNTIF(Table15[Column2],\"\")+COUNTIF(Table15[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table15[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table15[Column4],\"info required\")+COUNTIF(Table15[Column4],\"TBC\")+COUNTIF(Table15[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"PEDESTRIAN Dialog - Pedestrian Timing Data Tabs"]
[null,"Pedestrian Actuation","TBC","TBC","Pedestrian Timing Data","None, Program and % Pedestrian Call. If Pedestrian Actuation is set to Program, pedestrians volume must to be defined accurately."]
[null,"Walk Time Extension","TBC","TBC","Pedestrian Timing Data","If applicable."]
[null,"Minimum Walk Time ","TBC","TBC","Pedestrian Timing Data","Walk Time plus delay in SCATS for each signal group "]
[null,"Minimum Clearance Time","TBC","TBC","Pedestrian Timing Data","Clearance 1 + Clearance 2 in SCATS"]
[null,"Clearance 1 Time","TBC","TBC","Pedestrian Timing Data","Clearance 1 in SCATS"]
[null,"Clearance 2 Time","TBC","TBC","Pedestrian Timing Data","Clearance 2 in SCATS"]
[null,"Start Loss","TBC","TBC","Pedestrian Timing Data","If modified, justification should be provided in the modelling report."]
[null,"End Gain","TBC","TBC","Pedestrian Timing Data","If modified, justification should be provided in the modelling report."]
[null,"TRAFFIC FLOWS",{"$f":"IF((COUNTIF(Table16[Column2],\"\")+COUNTIF(Table16[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table16[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table16[Column4],\"info required\")+COUNTIF(Table16[Column4],\"TBC\")+COUNTIF(Table16[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"VOLUMES Dialog - Vehicle Volume or Volume Factors"]
[null,"SCATS traffic reporter or site turning count survey","TBC","TBC",null,"Data should be provided."]
[null,"Future traffic methodology and calculations","TBC","TBC",null,"Assumptions and calculations should be provided."]
[null,"Heavy Vehicle volume/ percentage Estimation","TBC","TBC",null,"Data should be provided."]
[null,"Historical growths - if applicable","TBC","TBC",null,"Data should be provided."]
[null,"ROM outputs - if applicable","TBC","TBC",null,"Data should be provided."]
[null,"Sensitivity growths","TBC","TBC",null,"Assumptions should be provided."]
[null,"Traffic flows unit time","TBC","TBC","Vehicle Volume Tab - Volume Data Settings for Site - Unit Time for Volumes"]
[null,"Peak flow period","TBC","TBC","Vehicle Volume Tab - Volume Data Settings for Site - Peak Flow Period","Assumptions should be provided in the modelling report."]
[null,"Traffic flows input data","TBC","TBC","Vehicle Volume Tab - Volume Data Settings for Site - Total/ Light Vehicle/ Heavy Vehicle","To be checked for all vehicle classes"]
[null,"Peak flow factor","TBC","TBC","Volume Factors Tab - Peak Flow Factor","Assumptions should be provided in the modelling report."]
[null,"Flow scales","TBC","TBC","Volume Factors Tab - Flow Scales","This can be used for calibration purpose when detected traffic flows by SCATs loops are not the actual demand for the approaches under oversaturated conditions. Subsequently, justification should be provided in the modelling report."]
[null,"Growth Rate (if applicable - Design Life analysis)","TBC","TBC","Volume Factors Tab - Growth Rate "]
[null,"PRIORITIES (Not applicable for Roundabouts)",{"$f":"IF((COUNTIF(Table17[Column2],\"\")+COUNTIF(Table17[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table17[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table17[Column4],\"info required\")+COUNTIF(Table17[Column4],\"TBC\")+COUNTIF(Table17[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"PRIORITIES Dialog "]
[null,"Priorities for all the movements","TBC","TBC","Priorities Dialog","If drivers should give-way to pedestrians, required priority rules should be defined here."]
[null,"GAP ACCEPTANCE",{"$f":"IF((COUNTIF(Table18[Column2],\"\")+COUNTIF(Table18[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table18[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table18[Column4],\"info required\")+COUNTIF(Table18[Column4],\"TBC\")+COUNTIF(Table18[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"GAP ACCEPTANCE Dialog - Gap Acceptance Data Tab"]
[null,"Critical Gap (applicable for Give-way/Yield movements)","TBC","TBC","Gap Acceptance Tab - Gap Acceptance Data - Critical Gap","If this is modified to calibrate Two-Way Sign Control model, justification should be provided in the modelling report.  Calibrate the base value to allow for program adjustments. "]
[null,"Follow-up Headway (applicable for Give-way/Yield movements)","TBC","TBC","Gap Acceptance Tab - Gap Acceptance Data - Follow-up Headway","If this is modified to calibrate Two-Way Sign Control model, justification should be provided in the modelling report.  Calibrate the base value to allow for program adjustments. "]
[null,"End Departures (Signals only)","TBC","TBC","Gap Acceptance Tab - Gap Acceptance Data - End Departures","If modified, justification should be provided in the modelling report."]
[null,"Exiting flow effect","TBC","TBC","Gap Acceptance Tab - Gap Acceptance Data - Exiting Flow Effect","If modified, justification should be provided in the modelling report."]
[null,"Percent Opposed by Nearest Lane Only","TBC","TBC","Gap Acceptance Tab - Gap Acceptance Data - Precent Opposed by Nearest Lane Only","If modified, justification should be provided in the modelling report."]
[null,"Opposing Pedestrians (if applicable)","TBC","TBC","Gap Acceptance Tab - Gap Acceptance Data - Opposing Peds","If used, pedestrians must be specified as opposing in the Priorities dialog. Pedestrian protection time for signals should be defined here."]
[null,"Critical Gap and Follow-up Headway (Zebra crossing) ","TBC","TBC","Gap Acceptance Tab - Gap Acceptance Data for vehicles Movement at Zebra Crossing ","Program. This should be the same as the base model. Adjustments should be justified in the modelling report."]
[null,"Minimum Departures (vehicles per minutes)","TBC","TBC","Gap Acceptance Tab - Gap Acceptance Data for vehicles Movement at Zebra Crossing ","If modified, justification should be provided in the modelling report."]
[null,"GAP ACCEPTANCE- Two-way Sign Control only",{"$f":"IF((COUNTIF(Table19[Column2],\"\")+COUNTIF(Table19[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table19[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table19[Column4],\"info required\")+COUNTIF(Table19[Column4],\"TBC\")+COUNTIF(Table19[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"GAP ACCEPTANCE Dialog - Two-Way Sign Control Tab"]
[null,"Level of Reduction with Opposing Flow Rate","TBC","TBC","Two-Way Sign Control Calibration - Level of Reduction with Opposing Flow Rate","If used to calibrate the critical gap and follow-up headway values, justification should be provided in the modelling report."]
[null,"Major Road Turning Flow Factor","TBC","TBC","Two-Way Sign Control Calibration - Major Road Turning Flow Factor","If modified, justification should be provided in the modelling report."]
[null,"Two-Way Sign Control Parameters Adjustments for Major Road Number of Lanes ","TBC","TBC","Two-Way Sign Control Parameters Adjustments for Major Road Number of Lanes","If modified, justification should be provided in the modelling report."]
[null,"Two-Way Sign Control Parameters Adjustments for Geometry and Control","TBC","TBC","Two-Way Sign Control Parameters Adjustments for Geometry and Control","If modified, justification should be provided in the modelling report."]
[null,"GAP ACCEPTANCE - Settings",{"$f":"IF((COUNTIF(Table20[Column2],\"\")+COUNTIF(Table20[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table20[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table20[Column4],\"info required\")+COUNTIF(Table20[Column4],\"TBC\")+COUNTIF(Table20[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"GAP ACCEPTANCE Dialog - Settings Tab"]
[null,"Gap Acceptance Capacity","TBC","TBC","Gap Acceptance Options - Gap Acceptance Capacity","Refer to the Operational Modelling Guidelines. If modified, justification should be provided in the modelling report."]
[null,"Turn on Red parameters (Signals Only)","TBC","TBC","Gap Acceptance Data for Specified Applications","If 'turn on red' is allowed, default gap acceptance values should be applied. If modified, justification should be provided in the modelling report."]
[null,"Gap Acceptance and Opposing Vehicle Factors (Zebra Crossing on Slip/Bypass Lane)","TBC","TBC","Gap Acceptance Options - Merge Analysis & Zebra Crossing Analysis Parameters","Refer to Operational Modelling Guidelines (Table 4 6 in Section 4.2.11.2)"]
[null,"Gap Acceptance and Opposing Vehicle Factors (Midblock Zebra Crossing)","TBC","TBC","Gap Acceptance Options - Merge Analysis & Zebra Crossing Analysis Parameters","Refer to Operational Modelling Guidelines (Table 4 6 in Section 4.2.11.2)"]
[null,"Gap Acceptance and Opposing Vehicle Factors (Merge Analysis Exit Short Lane)","TBC","TBC","Gap Acceptance Options - Merge Analysis & Zebra Crossing Analysis Parameters","Refer to Operational Modelling Guidelines (Table 4 6 in Section 4.2.11.2)"]
[null,"Gap Acceptance and Opposing Vehicle Factors (Merge Analysis Merge Lane)","TBC","TBC","Gap Acceptance Options - Merge Analysis & Zebra Crossing Analysis Parameters","Refer to Operational Modelling Guidelines (Table 4 6 in Section 4.2.11.2)"]
[null,"VEHICLE MOVEMENT DATA - Path Data",{"$f":"IF((COUNTIF(Table21[Column2],\"\")+COUNTIF(Table21[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table21[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table21[Column4],\"info required\")+COUNTIF(Table21[Column4],\"TBC\")+COUNTIF(Table21[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"VEHICLE MOVEMENT DATA Dialog - Path Data Tab"]
[null,"Approach Cruise Speed","TBC","TBC","Movement Path Data - Approach Cruise Speed"]
[null,"Exit Cruise Speed","TBC","TBC","Movement Path Data - Exit Cruise Speed"]
[null,"Negotiation Speed","TBC","TBC","Movement Path Data - Negotiation Speed","If it is not program, justification should be provided in the modelling report."]
[null,"Negotiation Distance","TBC","TBC","Movement Path Data - Negotiation Distance","If it is not program, justification should be provided in the modelling report."]
[null,"Negotiation Radius","TBC","TBC","Movement Path Data - Negotiation Radius","If it is not program, justification should be provided in the modelling report."]
[null,"Downstream Distance","TBC","TBC","Movement Path Data - Downstream Distance","If it is not program, justification should be provided in the modelling report."]
[null,"VEHICLE MOVEMENT DATA - Calibration",{"$f":"IF((COUNTIF(Table22[Column2],\"\")+COUNTIF(Table22[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table22[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table22[Column4],\"info required\")+COUNTIF(Table22[Column4],\"TBC\")+COUNTIF(Table22[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"VEHICLE MOVEMENT DATA Dialog - Calibration Tab"]
[null,"Queue Space","TBC","TBC","Movement Calibration Data","Queue space parameter is a key parameter to calculate back of queue, by affecting short lane capacities and upstream lane blockage. Refer to the Operational Modelling Guidelines."]
[null,"Vehicle Length","TBC","TBC","Movement Calibration Data","Refer to the Operational Modelling Guidelines."]
[null,"Vehicle Occupancy","TBC","TBC","Movement Calibration Data","If it is modified, justification should be provided in the modelling report."]
[null,"Turning Vehicle Effects","TBC","TBC","Movement Calibration Data"]
[null,"Gap Acceptance Factor","TBC","TBC","Movement Calibration Data","Refer to the Operational Modelling Guidelines."]
[null,"Opposing Vehicle Factor","TBC","TBC","Movement Calibration Data","Refer to the Operational Modelling Guidelines."]
[null,"Practical Degree of Saturation","TBC","TBC","Movement Calibration Data","If it is modified, justification should be provided in the modelling report."]
[null,"VEHICLE MOVEMENT DATA - Signals (Signals Only)",{"$f":"IF((COUNTIF(Table23[Column2],\"\")+COUNTIF(Table23[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table23[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table23[Column4],\"info required\")+COUNTIF(Table23[Column4],\"TBC\")+COUNTIF(Table23[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"VEHICLE MOVEMENT DATA Dialog - Calibration Tab"]
[null,"Signal Coordination (Network Only)","TBC","TBC","Movement Data - Signals"]
[null,"Stop line Travel Time (Network Only)","TBC","TBC","Movement Data - Signals"]
[null,"Start Loss and End Gain","TBC","TBC","Movement Data - Signals - Vehicle Movement Timing Data","Start Loss = 3 sec and End Gain = 3 sec. If these are modified, justification should be provided in the modelling report."]
[null,"Minimum Green","TBC","TBC","Movement Data - Signals - Vehicle Movement Timing Data","the calculated phase time for 100 per cent frequency should not be longer than the minimum phase in SCATS"]
[null,"Maximum Green","TBC","TBC","Movement Data - Signals - Vehicle Movement Timing Data","This should be consistent with SCATS."]
[null,"Phase Actuation","TBC","TBC","Movement Data - Signals - Vehicle Movement Timing Data","if it is not none, justification should be provided in the modelling report."]
[null,"Early Cut-Off (if applicable)","TBC","TBC","Movement Data - Signals - Vehicle Movement Timing Data","This should be consistent with SCATS. Dummy phase may be used to apply Early cut-off. Refer to Operational Modelling Guidelines."]
[null,"Late Start (if applicable)","TBC","TBC","Movement Data - Signals - Vehicle Movement Timing Data","This should be consistent with SCATS. This should be used to define filtering right turn or pedestrian protection time. Refer to Operational Modelling Guidelines."]
[null,"PHASING & TIMING (Signals Only)",{"$f":"IF((COUNTIF(Table24[Column2],\"\")+COUNTIF(Table24[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table24[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table24[Column4],\"info required\")+COUNTIF(Table24[Column4],\"TBC\")+COUNTIF(Table24[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"PHASING & TIMING Dialog"]
[null,"Provide SCATS Intersection graphs and SCATS Historical or IDM data","TBC","TBC"]
[null,"Signal Analysis Method","TBC","TBC","Sequence tab","Fixed-Time/Pretimed for intersections running under SCATS-coordinated or master-isolated control.\nThe Actuated analysis method should be used for intersections operating under a traditional actuated control method."]
[null,"Phases","TBC","TBC","Sequence Editor tab","This should be consistent with SCATS or LM drawings."]
[null,"Phasing sequence","TBC","TBC","Sequence Editor tab","For each movement class, this should be consistent with SCATS. For the base model, phase sequence should be defined based on SCATS history data."]
[null,"Variable Phases","TBC","TBC","Phase & Sequence Data tab - Phase Data","This should be consistent with SCATS site graphics or LM drawings."]
[null,"Phase Time","TBC","TBC","Phase & Sequence Data tab - Phase Data","Applicable if Cycle Time Option is User-Given Phase Times. Refer to the Operational Modelling Guidelines. "]
[null,"Phase Frequency","TBC","TBC","Phase & Sequence Data tab - Phase Data","Applicable if Cycle Time Option is User-Given Phase Times. Refer to the Operational Modelling Guidelines. "]
[null,"Yellow Time and All-Red Time","TBC","TBC","Phase & Sequence Data tab - Phase Data","This should be checked against SCATS settings for the existing sites. If only one yellow time or all-red time has a decimal value, it should be rounded up. However, if both have decimal values, one should be rounded up and the other should be rounded down."]
[null,"Dummy Movement Exists","TBC","TBC","Phase & Sequence Data tab - Phase Data","If dummy movements are defined, assumptions should be provided in the modelling report. "]
[null,"Minimum Green Time (dummy movements only)","TBC","TBC","Phase & Sequence Data tab - Phase Data","Defined values should be justified."]
[null,"Maximum Green Time (dummy movements only)","TBC","TBC","Phase & Sequence Data tab - Phase Data","Defined values should be justified."]
[null,"Maximum Green Time (actuated signals only)","TBC","TBC","Phase & Sequence Data tab - Actuated Signal Data","For actuated signals and when fixed green time is required for a phase."]
[null,"Gap Setting (actuated signals only)","TBC","TBC","Phase & Sequence Data tab - Actuated Signal Data","Applicable on actuated signal only."]
[null,"Cycle Time Option","TBC","TBC","Timing Options tab - Cycle Time Option","Practical, Optimum, etc. If it is User-Given Phase Times, then specify Phase Time and Frequency in Phase & Sequence Data tab."]
[null,"Green Split Priority","TBC","TBC","Timing Options tab - Green Split Option","Applicable only for User-Given Cycle Time and Network."]
[null,"Phase Transition (Apply Intergreen)","TBC","TBC","Advanced tab - Movement Data","Specify if intergreen time must be applied during phase transition for vehicle and pedestrian signal groups (no overlap). Particularly, for pedestrian signal group runs in consecutive phases and for diamond phases."]
[null,"Red Arrow Drop Off","TBC","TBC","Advanced tab - Movement Data","In order to define the late start for a filtering right turn phase which comes after a leading right turn phase, Red-Arrow Drop Off box should be checked"]
[null,"Undetected Movements","TBC","TBC","Advanced tab - Movement Data"]
[null,"DEMAND & SENSITIVITY",{"$f":"IF((COUNTIF(Table25[Column2],\"\")+COUNTIF(Table25[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table25[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table25[Column4],\"info required\")+COUNTIF(Table25[Column4],\"TBC\")+COUNTIF(Table25[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"DEMAND & SENSITIVITY Dialog"]
[null,"Appropriate Analysis Option ( if applicable)","TBC","TBC","Analysis Option"]
[null,"PARAMETER SETTINGS",{"$f":"IF((COUNTIF(Table26[Column2],\"\")+COUNTIF(Table26[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table26[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table26[Column4],\"info required\")+COUNTIF(Table26[Column4],\"TBC\")+COUNTIF(Table26[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"PARAMETER SETTINGS"]
[null,"Provide supporting data when parameters are modified.","TBC","TBC","All parameters"]
[null,"SITE MODEL OUTPUTS",{"$f":"IF((COUNTIF(Table27[Column2],\"\")+COUNTIF(Table27[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table27[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table27[Column4],\"info required\")+COUNTIF(Table27[Column4],\"TBC\")+COUNTIF(Table27[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"SITE OUTPUT Pane"]
[null,"Diagnostics","TBC","TBC","Diagnostics","Error and warning messages should be reviewed and fixed."]
[null,"Saturation Flows Rate (vehicle / hour)","TBC","TBC","Detailed Output - Lane Flow and Capacity Information","To be compared against measured saturation flows on site. Adjusted Basic Saturation Flow must not be used for checking against field data directly since it does not include all factors affecting Saturation Flow Rate (e.g. heavy vehicle effects). "]
[null,"Degree of Saturation (%)","TBC","TBC","Lane Summary - Degree of Saturation (v/c)","the base model, which was developed based on recorded signal timing data and traffic flows for the same day, should have less than or equal to 100% degree of saturation for all of the lanes."]
[null,"Queue Distance","TBC","TBC","Lane Summary - Average Back of Queue","For calibration, average queue distance for approaches to be compared against measured average queue length on site. Careful attention required about the use of Average and Percentile values in output. "]
[null,"Short Lane Capacity","TBC","TBC","Detailed Output - Lane Performance and Capacity Information","Capacity and Saturation Flow Rate values to be checked if reduced capacity due to a short lane effect."]
[null,"Site Level of Service","TBC","TBC","Lane Summary or Movement Summary"]
[null,"Short Lane Overflow Probability","TBC","TBC","Lane Flows - Prob. SL Ov. %","Probability of the short lane back of queue exceeding the short lane length"]
[null,"Upstream Lane Blockage","TBC","TBC","Lane Summary - Prob. Block %","Upstream congestion exists - site observations to be provided in the modelling report."]
[null,"Capacity Reduction","TBC","TBC","Lane Summary - Cap. Adj. %","Downstream congestion exists - site observations to be provided in the modelling report."]
[null,"Other Comments"]

{"sheet":"Base - Network","index":3,"n_rows":79,"n_cols":6,"rows_kept":79,"cut":false,"hidden":false,"merged":[[78,1,78,5],[65,4,65,5],[68,4,68,5],[0,1,0,4],[33,4,33,5],[36,4,36,5],[52,4,52,5],[62,4,62,5],[7,2,7,4],[8,2,8,4],[9,2,9,4],[12,4,12,5],[15,4,15,5],[1,2,1,4],[2,2,2,4],[3,2,3,4],[4,2,4,4],[5,2,5,4],[6,2,6,4]]}
[null,"SIDRA Base Model Audit Checklist - Network (Ver2.0)"]
[null,"Project Information",{"$f":"IF(C4=\"\",\"\",C4)","v":""}]
[null,"Project"]
[null,"Model Name"]
[null,"Network Name"]
[null,"Network ID (if applicable)"]
[null,"Applicant (Name & Organisation / MRWA Team)"]
[null,"Modeller (Name & Consultancy / MRWA Team)"]
[null,"Auditing Process Coordinator (Name & MRWA Team)"]
[null,"Model Auditor (Name & MRWA Team)"]
[]
[null,"Base Model Checks","Modeller","Model Auditor","Find it in SIDRA software - Network tab","General SIDRA Model Criteria\n(also check Instruction Form for specific requirements)"]
[null,"NETWORK CONFIGURATION",{"$f":"IF((COUNTIF(Table102[Column2],\"\")+COUNTIF(Table102[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table102[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table102[Column4],\"info required\")+COUNTIF(Table102[Column4],\"TBC\")+COUNTIF(Table102[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"NETWORK CONFIGURATION Dialog or Network Layout"]
[null,"Network Connections","TBC","TBC","NETWORK CONFIGURATION Dialog","All the connectors should be green indicating a valid connection. If there is an error or a warning check number of lanes, movement classes and approach and exit distance at connections."]
[null,"Network Layout","TBC","TBC",null,"Should be consistent with the existing network layout."]
[null,"NETWORK  DATA",{"$f":"IF((COUNTIF(Table103[Column2],\"\")+COUNTIF(Table103[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table103[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table103[Column4],\"info required\")+COUNTIF(Table103[Column4],\"TBC\")+COUNTIF(Table103[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"NETWORK  DATA Dialog"]
[null,"Network Name ","TBC","TBC","Network Data tab - Network Data","Network to be labelled reasonably (e.g. corridor name, AM/PM, Year, etc.)."]
[null,"Network ID","TBC","TBC","Network Data tab - Network Data","Allocate unique IDs to all sites and common control groups in the network, e.g. SCATS TCS."]
[null,"Network Level of Service Method and Level of Service Target","TBC","TBC","Network Data tab - Network Data","SIDRA Speed Efficiency and LOS D"]
[null,"Network Performance Measure","TBC","TBC","Network Data tab - Network Data","Justify in the modelling report, if it is adjusted. Default is Delay."]
[null,"Apply Platoon Dispersion","TBC","TBC","Network Data tab - Network Data","Unchecked, if the distance between network sites is short and there is zero offset for individual sites."]
[null,"Apply Lane Blockage Model","TBC","TBC","Network Data tab - Network Data","It should be checked"]
[null,"Desired Speed","TBC","TBC","Network Data tab - Network Data","Justify in the modelling report, if it is not program."]
[null,"Lower Limit of Speed Efficiency for TTI","TBC","TBC","Network Data tab - Network Data","Justify in the modelling report, if it is adjusted. Default value = 0.1."]
[null,"Maximum Number of Iteration","TBC","TBC","Network Data tab - Network Analysis Settings","Should be set to 10 or greater value (up to 30)."]
[null,"Percentage Stopping Condition","TBC","TBC","Network Data tab - Network Analysis Settings","Should be set to 1.0% or less (down to 0.1%)."]
[null,"Peak Flow Period ","TBC","TBC","Override Site Data - Network Parameters that override Site Data"]
[null,"Site Level of Service Method","TBC","TBC","Override Site Data - Network Parameters that override Site Data","Delay (SIDRA)"]
[null,"Queue in Output","TBC","TBC","Override Site Data - Network Parameters that override Site Data","Average queue should be used for calibration."]
[null,"Hours per Year ","TBC","TBC","Override Site Data - Network Parameters that override Site Data","Justify in the modelling report, if it is adjusted. Default value = 480 h."]
[null,"Cost Unit","TBC","TBC","Override Site Data - Network Parameters that override Site Data","$"]
[null,"Exclude Geometric Delay","TBC","TBC","Override Site Data - Network Parameters that override Site Data","This should be unchecked."]
[null,"Include Short Lanes in determining Approach Queue Storage Ratio","TBC","TBC","Override Site Data - Network Parameters that override Site Data","If it is checked, justify in the modelling report."]
[null,"DEFINE CCGS (Networks with Common Control Groups only)",{"$f":"IF((COUNTIF(Table104[Column2],\"\")+COUNTIF(Table104[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table104[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table104[Column4],\"info required\")+COUNTIF(Table104[Column4],\"TBC\")+COUNTIF(Table104[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"CCG1 ID","TBC","TBC","Create Common Control Groups","For the existing signals Main Roads TCS number to be used."]
[null,"Allocate Sites to Common Control Groups","TBC","TBC","Allocate Sites to Common Control Groups"]
[null,"COMMON CONTROL GROUPS (Networks with Common Control Groups only)",{"$f":"IF((COUNTIF(Table105[Column2],\"\")+COUNTIF(Table105[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table105[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table105[Column4],\"info required\")+COUNTIF(Table105[Column4],\"TBC\")+COUNTIF(Table105[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"COMMON CONTROL GROUPS Dialog"]
[null,"Provide SCATS Intersection graphs and SCATS Historical or IDM data","TBC","TBC"]
[null,"Signal Analysis Method","TBC","TBC","Sequence tab","Fixed-Timed or Actuated:\nFixed-Time/Pretimed for intersections running under SCATS-coordinated or master-isolated control.\nThe Actuated analysis method should be used for intersections operating under a traditional actuated control method."]
[null,"Phases","TBC","TBC","Sequence Editor tab","To be checked the against SCATS or LM drawings."]
[null,"Phasing sequence (for each movement class if applicable)","TBC","TBC","Sequence Editor tab","To be checked the against SCATS."]
[null,"Variable Phases","TBC","TBC","Phase & Sequence Data tab - Phase Data","To be checked the against SCATS site graphics."]
[null,"Reference Phase","TBC","TBC","Phase & Sequence Data tab - Phase Data","For traffic signal coordination in network, it should be consistent with SCATS."]
[null,"Phase Time","TBC","TBC","Phase & Sequence Data tab - Phase Data","Applicable when cycle time option is User-Given Phase Times."]
[null,"Yellow Time and All-Red Time","TBC","TBC","Phase & Sequence Data tab - Phase Data","To be checked the against SCATS settings for the existing sites."]
[null,"Dummy Movement Exists","TBC","TBC","Phase & Sequence Data tab - Phase Data","If applicable, provide justification in the modelling report."]
[null,"Maximum Green Time (Actuated Signals only)","TBC","TBC","Phase & Sequence Data tab - Actuated Signal Data"]
[null,"Gap Setting (Actuated Signals only)","TBC","TBC","Phase & Sequence Data tab - Actuated Signal Data"]
[null,"Cycle Time Option","TBC","TBC","Timing Options tab - Cycle Time Option","Practical, Optimum, etc. If User-Given Phase Times is applied, then specify phase time in Phase & Sequence Data tab."]
[null,"Green Split Priority","TBC","TBC","Timing Options tab - Green Split Option","Applicable only for User-Given Cycle Time and Network."]
[null,"Undetected movements","TBC","TBC","Advanced tab - Movement Data","Specify if applicable"]
[null,"Phase Transition (no phase overlap)","TBC","TBC","Advanced tab - Movement Data","specify if intergreen time should run for vehicles and pedestrians signal groups. Particularly for pedestrian signal group runs in consecutive phases and for Diamond phases."]
[null,"NETWORK TIMING DATA (Network with signalised intersections)",{"$f":"IF((COUNTIF(Table106[Column2],\"\")+COUNTIF(Table106[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table106[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table106[Column4],\"info required\")+COUNTIF(Table106[Column4],\"TBC\")+COUNTIF(Table106[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"NETWORK TIMING DATA Dialog"]
[null,"Coordinated Site / CCG","TBC","TBC","Network Timing Data tab - Signal Coordination","To be checked the against SCATS."]
[null,"Reference Site / CCG","TBC","TBC","Network Timing Data tab - Signal Coordination","To be checked the against SCATS."]
[null,"User Offset","TBC","TBC","Network Timing Data tab - Signal Coordination","Applicable when the Signal Offset is set to User in the Signal Offset tab. To be checked the against SCATS."]
[null,"Network Cycle Time","TBC","TBC","Network Timing Data tab - Cycle Time and Phase Time"]
[null,"Signal Offset","TBC","TBC","Signal Offsets tab - Signal Offsets","If it is set to program, User Offsets will not apply to Sites that are on routes specified for offset calculation (checked in the Routes for Offset Calculation table in Signal Offsets tab). User offsets will apply to the other sites."]
[null,"Route for Offset Calculation","TBC","TBC","Signal Offsets tab - Routes for Offset Calculation","The relevant route should be checked."]
[null,"Signal Offset Method","TBC","TBC","Signal Offsets tab - Routes for Offset Calculation","For program signal offset only. To be set to the default (Start of Green (Leading))."]
[null,"Route for Offset Calculation -  Movement Class","TBC","TBC","Signal Offsets tab - Routes for Offset Calculation","The majority vehicle class on the route should be selected."]
[null,"Signal Offset Definition","TBC","TBC","Signal Offsets tab - Setting","When yellow time and all-red time are not the same for all the sites, must be set to  Offset (Green Start)."]
[null,"NETWORK ROUTES",{"$f":"IF((COUNTIF(Table107[Column2],\"\")+COUNTIF(Table107[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},"TBC","NETWORK ROUTES Dialog"]
[null,"Network Routes","TBC","TBC","NETWORK ROUTES tab - Network Routes","Required network routes should be defined and selected according to sub-area assessment purposes."]
[null,"Network Output by Routes Options","TBC","TBC","NETWORK ROUTES tab - Network Output by Routes Options"]
[null,"SITES OF NETWORK",{"$f":"IF((COUNTIF(Table108[Column2],\"\")+COUNTIF(Table108[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table108[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table108[Column4],\"info required\")+COUNTIF(Table108[Column4],\"TBC\")+COUNTIF(Table108[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"SITE tab"]
[null,"Lane Movement Flow Proportions  inside the Network","TBC","TBC","LANE MOVEMENTS Dialog - Flow Proportions tab - Lane Movements Flow Proportions","Refer to the case study in the Operational Modelling Guidelines."]
[null,"Early Cut-off or Late Start in CCGs","TBC","TBC","VEHICLE MOVEMENT DATA dialog - Signals Tab","Refer to the case study in the Operational Modelling Guidelines."]
[null,"NETWORK MODEL OUTPUTS",{"$f":"IF((COUNTIF(Table109[Column2],\"\")+COUNTIF(Table109[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table109[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table109[Column4],\"info required\")+COUNTIF(Table109[Column4],\"TBC\")+COUNTIF(Table109[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"NETWORK tab - OUTPUT Pane or Route tab"]
[null,"Diagnostics","TBC","TBC","Diagnostics","Error and warning messages should be reviewed and fixed."]
[null,"Network and Route Level of Service","TBC","TBC","Network Summary, Route Summary"]
[null,"Capacity Adjustment or Blockage Probability","TBC","TBC","Lane Summary, Lane Displays (Site, network, Route)"]
[null,"Degree of Saturation","TBC","TBC","Lane Summary, Lane Displays (Site, network, Route)","Should be below 100% for the base model."]
[null,"Lane Utilisation","TBC","TBC","Lane Summary","Should be reported if it is less than 100%."]
[null,"Midblock Inflow and Outflow Rates","TBC","TBC","Network Flows","Should be reported if it is greater than 0."]
[null,"Midblock Lane Change Rates","TBC","TBC","Lane Changes ","High lane changes volume should be reported."]
[null,"Arrival Flow Rates","TBC","TBC","Lane Summary, Arrival Flows display","Arrival flow reduction should be reported."]
[null,"Platoon Ratio","TBC","TBC","Signal Offsets"]
[null,"Other Comments"]

{"sheet":"Proposed- Site","index":4,"n_rows":223,"n_cols":6,"rows_kept":223,"cut":false,"hidden":false,"merged":[[189,4,189,5],[208,4,208,5],[210,4,210,5],[212,4,212,5],[222,1,222,5],[180,4,180,5],[98,4,98,5],[107,4,107,5],[113,4,113,5],[120,4,120,5],[129,4,129,5],[142,4,142,5],[144,4,144,5],[153,4,153,5],[158,4,158,5],[165,4,165,5],[172,4,172,5],[95,4,95,5],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[35,4,35,5],[45,4,45,5],[57,4,57,5],[60,4,60,5],[63,4,63,5],[75,4,75,5],[79,4,79,5],[18,1,18,2],[5,2,5,4],[11,1,11,3],[32,1,32,3],[0,1,0,4],[1,2,1,4],[2,2,2,4],[3,2,3,4],[4,2,4,4]]}
[null,"SIDRA Proposed Model Audit Checklist - Site (Ver2.0)"]
[null,"Project Information",{"$f":"IF(C4=\"\",\"\",C4)","v":""}]
[null,"Project"]
[null,"Model Name"]
[null,"Site Name"]
[null,"Site ID (if applicable)"]
[null,"Applicant (Name & Organisation / MRWA Team)"]
[null,"Modeller (Name & Consultancy / MRWA Team)"]
[null,"Auditing Process Coordinator (Name & MRWA Team)"]
[null,"Model Auditor (Name & MRWA Team)"]
[]
[null,"Step 1 - Comparing the Base and Proposed Sites Input"]
[]
[]
[null,"1 - Select Site tab, then select Input Comparison "]
[]
[]
[]
[null,"2 - Select Compare input data for two Sites in the Project"]
[null,"     Site B = Option model "]
[null,"     Site A = Its relevant Base model"]
[null,"     Press OK."]
[]
[]
[]
[]
[]
[null,"3 - Check the highlighted differences"]
[]
[]
[]
[]
[null,"Step 2 - Checking the Proposed model"]
[]
[null,"Proposed Model Checks","Modeller","Model Auditor","Find it in SIDRA software - SITE tab","General SIDRA Model Criteria\n(also check Instruction Form for specific requirements)"]
[null,"Supply Information - for all sites",{"$f":"IF((COUNTIF(Table201[Column2],\"\")+COUNTIF(Table201[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table201[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table201[Column4],\"info required\")+COUNTIF(Table201[Column4],\"TBC\")+COUNTIF(Table201[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"Electronic version of approved base model(s)","TBC","TBC"]
[null,"Electronic version of proposed model(s)","TBC","TBC"]
[null,"Approved Modelling Instruction Form","TBC","TBC"]
[null,"Calculation of future traffic flows","TBC","TBC"]
[null,"Proposed signal timings","TBC","TBC"]
[null,"Proposed design drawings","TBC","TBC"]
[null,"Marked measurement on layout","TBC","TBC",null,"e.g. lane lengths, lane width, roundabouts island diameter etc."]
[null,"Other input data","TBC","TBC"]
[null,"Proposed modelling report","TBC","TBC"]
[null,"INTERSECTION",{"$f":"IF((COUNTIF(Table202[Column2],\"\")+COUNTIF(Table202[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table202[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table202[Column4],\"info required\")+COUNTIF(Table202[Column4],\"TBC\")+COUNTIF(Table202[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"INTERSECTION Dialog - Intersection Tab"]
[null,"Sites - Control ","TBC","TBC","PROJECT Pane","Signals, Roundabout, Sign Control, etc."]
[null,"Site Name ","TBC","TBC","Site Data - Site Name","All sites to be labelled reasonably (Intersection name, AM/PM, Year, etc.)"]
[null,"Site ID","TBC","TBC","Site Data - Site ID","e.g. SCATS TCS"]
[null,"Intersection legs direction","TBC","TBC","Approach Editor","N, NE, E, SE, S, SW, W or NW"]
[null,"Name (approach)","TBC","TBC","Approach Geometry - Name","Road Name"]
[null,"Leg geometry","TBC","TBC","Approach Geometry - Leg Geometry","Two-way, One-way Approach or Exit"]
[null,"Approach lanes distance","TBC","TBC","Approach Geometry - Approach Distance","For internal arms within a network, Approach Distance should be measured from the last conflict point of all exit movements at the upstream site to the stop line of the current site. The default value of Approach Distance (500 meters) can be used for external arms."]
[null,"Exit lanes distance (if applicable)","TBC","TBC","Approach Geometry - Exit Distance","Applicable if exit lane distance is not the same as approach distance (Input)"]
[null,"Extra Bunching (if applicable)","TBC","TBC","Approach Data - Extra Bunching","Refer to the Operational Modelling Guidelines."]
[null,"Area Type Factor  (Signals only)","TBC","TBC","Signals - Area Type Factor","Calibration parameter for Signals. Modifications should be justified."]
[null,"Approach Control (Sign Control sites only)","TBC","TBC","Sign Control - Approach Control "," Major Road, Give-way/Yield or Stop"]
[null,"VEHICLE CLASSES",{"$f":"IF((COUNTIF(Table203[Column2],\"\")+COUNTIF(Table203[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table203[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table203[Column4],\"info required\")+COUNTIF(Table203[Column4],\"TBC\")+COUNTIF(Table203[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"MOVEMENT DEFINITIONS Dialog - Movement Classes Tab"]
[null,"Additional standard vehicle classes (if applicable)","TBC","TBC","Standard Classes"]
[null,"Additional user defined vehicle classes (if applicable)","TBC","TBC","User Classes"]
[null,"MOVEMENTS",{"$f":"IF((COUNTIF(Table204[Column2],\"\")+COUNTIF(Table204[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table204[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table204[Column4],\"info required\")+COUNTIF(Table204[Column4],\"TBC\")+COUNTIF(Table204[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"MOVEMENT DEFINITIONS Dialog - Origin- Destination Movements Tab"]
[null,"Banned Movements exists (if applicable)","TBC","TBC","Origin - Destination Movements - Movement Exists","SIDRA checks all movements except U-turns by default. Uncheck any banned movements."]
[null,"U-turn Movements exists (if applicable)","TBC","TBC","Origin - Destination Movements - Movement Exists","U-turn movements box should be ticked if applicable. If U-turn before intersection is excluded from the analysis, it should be mentioned in the modelling report."]
[null,"LANE GEOMETRY",{"$f":"IF((COUNTIF(Table205[Column2],\"\")+COUNTIF(Table205[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table205[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table205[Column4],\"info required\")+COUNTIF(Table205[Column4],\"TBC\")+COUNTIF(Table205[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"LANE GEOMETRY Dialog - Lane Configuration Tab"]
[null,"Number of lanes (approach and exit lanes)","TBC","TBC","Lane Configuration Data -  Lane Editor","Approach and exit lanes should be checked."]
[null,"Lane configuration (approach and exit lanes)","TBC","TBC","Lane Configuration Data -  Lane Configuration","Full-length, short lane, short lane with parking or two-segment lane "]
[null,"Lane type","TBC","TBC","Lane Configuration Data -  Lane Type","Normal, Slip/Bypass - High or Short Angle"]
[null,"Lane control (approach and exit lanes)","TBC","TBC","Lane Configuration Data - Lane Control","Signals, Give-way/Yield, Stop, or Continuous"]
[null,"Lane length (approach and exit lanes)","TBC","TBC","Lane Configuration Data - Lane Length","Set equal to Approach Distance automatically. For isolated, long lanes length can be left as default (500 meters).\nFor networks, Lane Length is important for internal approaches since it acts as storage length that affects the probability of blocking upstream lanes."]
[null,"Short lane length (compulsory)","TBC","TBC","Lane Configuration Data - Short Lane Length","Short Lane Length typically to be measured from the stop point to where the lane width is 2.0m at the taper section. "]
[null,"Lane width","TBC","TBC","Lane Configuration Data - Lane Width","Printed width in LM drawings may not be accurate."]
[null,"Lane grade","TBC","TBC","Lane Configuration Data - Grade","To be defined based on the traffic movement direction (Flat = 0, Uphill>0 and Downhill <0)."]
[null,"Overflow Lane Number /  Merge Lane Number","TBC","TBC","Lane Configuration Data - Overflow Lane Number /  Merge Lane Number"]
[null,"Islands geometry","TBC","TBC","Lane Configuration Data - Strip Island Configuration Data","Front and back width"]
[null,"Intersection Geometry","TBC","TBC","Double click on the Site","Overall geometry of model should be consistent with the proposed road geometry."]
[null,"LANE DICIPLINES",{"$f":"IF((COUNTIF(Table206[Column2],\"\")+COUNTIF(Table206[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table206[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table206[Column4],\"info required\")+COUNTIF(Table206[Column4],\"TBC\")+COUNTIF(Table206[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"LANE GEOMETRY Dialog - Lane Disciplines Tab"]
[null,"Available movements for each Vehicle class (All approaches)","TBC","TBC","Lane Disciplines","E.g. Bus lanes.  This should be checked against the lane marking."]
[null,"Free queue area (for Signals only)","TBC","TBC","Lane Disciplines -  Free Queue Distance"]
[null,"Two-segment lanes definition (if applicable)","TBC","TBC","Lane Disciplines"]
[null,"LANE DATA",{"$f":"IF((COUNTIF(Table207[Column2],\"\")+COUNTIF(Table207[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table207[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table207[Column4],\"info required\")+COUNTIF(Table207[Column4],\"TBC\")+COUNTIF(Table207[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"LANE GEOMETRY Dialog - Lane Data Tab"]
[null,"Basic Saturation Flow data (Through Car Unit / Hour)","TBC","TBC","Approach Lane Data - Basic Saturation Flow","If it is adjusted for calibration purposes of Signals, justification should be provided. For justification, measurements can be attempted on site for the critical approaches (vehicle / hour)."]
[null,"Apply Saturation Flow Estimation","TBC","TBC","Approach Lane Data - Basic Saturation Flow","This checkbox should be ticked, otherwise, justifications should be provided."]
[null,"Short Lane Capacity (calibration Options)","TBC","TBC","Approach Lane Data - Basic Saturation Flow","This should be 'Program'."]
[null,"Delay Model Parameters (Uninterrupted Flow)","TBC","TBC","Approach Lane Data - Basic Saturation Flow","This should be 'Program'."]
[null,"Lane Utilisation","TBC","TBC","Approach Lane Data - Lane Utilisation Ratio","If it is used for calibration, justification should be provided in the modelling report."]
[null,"Saturation Speed","TBC","TBC","Approach Lane Data - Saturation Speed","If it is measured on site, data should be provided."]
[null,"Capacity adjustment","TBC","TBC","Approach Lane Data - Capacity Adjustment","MRWA does not recommend to adjust this parameter. If adjusted, justification should be provided in the modelling report."]
[null,"Bus Stopping (if applicable) - Signals only","TBC","TBC","Signals - Bus Stopping"]
[null,"Parking manoeuvres (if applicable) - Signals only","TBC","TBC","Signals - Parking Manoeuvres"]
[null,"Dominant Lane - Roundabouts only","TBC","TBC","Roundabouts - Dominant Lane"]
[null,"Merge Type (Exit lanes)","TBC","TBC","Merge Analysis","For new merging lanes, assumptions should be provided in the modelling report."]
[null,"Percent  Opposing in Short Lane and in Merge Lane","TBC","TBC","Merge Analysis","For new merging lanes, based on new design and expected driving behaviours."]
[null,"Critical Gap and Follow-up Headway (Merge Analysis)","TBC","TBC","Merge Analysis","Default values can be applied, otherwise, justifications should be provided in the modelling report."]
[null,"Minimum Departures (vehicles per minute)","TBC","TBC","Merge Analysis","Default values can be applied, otherwise, justifications should be provided in the modelling report."]
[null,"Exclude Slip/Bypass Lane from Signal Analysis","TBC","TBC","Signals","This checkbox should be ticked, otherwise, justifications should be provided in the modelling report."]
[null,"LANE MOVEMENTS",{"$f":"IF((COUNTIF(Table208[Column2],\"\")+COUNTIF(Table208[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table208[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table208[Column4],\"info required\")+COUNTIF(Table208[Column4],\"TBC\")+COUNTIF(Table208[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"LANE MOVEMENTS Dialog - Flow Proportions or Blockage Calibration Tabs"]
[null,"Exit lanes flow proportions","TBC","TBC","Flow Proportions Tab - Lane Movement Flow Proportions","These affect downstream blockage estimates for upstream lanes as well as second-by-second platoon arrival patterns for downstream lanes"]
[null,"Exit lane blockage factor","TBC","TBC","Blockage Calibration Tab - Lane Blockage Calibration Factor","For calibration of program estimates for downstream blocking. If used, justification should be provided in the modelling report."]
[null,"ROUNDABOUTS (Roundabouts only)",{"$f":"IF((COUNTIF(Table209[Column2],\"\")+COUNTIF(Table209[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table209[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table209[Column4],\"info required\")+COUNTIF(Table209[Column4],\"TBC\")+COUNTIF(Table209[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"ROUNDABOUTS Dialog - Options or Roundabout Data Tabs"]
[null,"Roundabout Capacity Manual","TBC","TBC","Options tab - Roundabout Model Options","If it is not SIDRA Standard, justification should be provided in the modelling report."]
[null,"Exclude Geometry Delay","TBC","TBC","Options tab - Roundabout Model Options","If Exclude Geometric Delay parameter is checked, justifications should be provided in the modelling report."]
[null,"Number of Circulating Lanes","TBC","TBC","Roundabout data tab - Geometry"]
[null,"Circulating Width","TBC","TBC","Roundabout data tab - Geometry"]
[null,"Island Diameter or Inscribed Diameter","TBC","TBC","Roundabout data tab - Geometry"]
[null,"Entry Radius and Entry Angle","TBC","TBC","Roundabout data tab - Geometry"]
[null,"Environment Factor","TBC","TBC","Roundabout data tab - SIDRA Standard Roundabout Model Calibration","This should be set up the same as the base model. For the new sites, this should be 1.00."]
[null,"Entry/Circulating Flow Adjustment","TBC","TBC","Roundabout data tab - SIDRA Standard Roundabout Model Calibration"]
[null,"ROUNDABOUTS (Metered Roundabouts only)",{"$f":"IF((COUNTIF(Table210[Column2],\"\")+COUNTIF(Table210[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table210[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table210[Column4],\"info required\")+COUNTIF(Table210[Column4],\"TBC\")+COUNTIF(Table210[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"ROUNDABOUTS Dialog - Roundabout Metering Tab"]
[null,"Metered and controlled approaches coding","TBC","TBC"]
[null,"Stop Line Setback Distance","TBC","TBC","Roundabout Metering - Metered Approach"]
[null,"Start Loss and End Gain (Provide justification if these are modified)","TBC","TBC","Roundabout Metering - Metered Approach","If modified, justification should be provided in the modelling report."]
[null,"Cycle Time Option","TBC","TBC","Cycle Time Option","Applied option should be specified in the modelling report."]
[null,"Phase Data - Yellow Time, All-Red Time and Minimum Phase Time","TBC","TBC","Phase Data","For an existing site should be as per SCATS settings (roundup 0.5 seconds). For new or modified sites, refer to the Operational Modelling Guidelines."]
[null,"PEDESTRIAN",{"$f":"IF((COUNTIF(Table211[Column2],\"\")+COUNTIF(Table211[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table211[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table211[Column4],\"info required\")+COUNTIF(Table211[Column4],\"TBC\")+COUNTIF(Table211[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"PEDESTRIAN Dialog - Pedestrian Movements or Pedestrian Movement Data Tabs"]
[null,"Crossing types","TBC","TBC","Pedestrian Movements Tab - Movement definitions - Pedestrian Movements Tab - Main Crossing","Full Crossing or Staged Crossing"]
[null,"Pedestrian volume unit and peak period (if applicable)","TBC","TBC","Volume Data Settings for Site"]
[null,"Pedestrian Volume","TBC","TBC","Pedestrian Movements Tab - Volume Data","Entered as per site survey. SIDRA SOLUTIONS highly recommends to input the real data or reasonable pedestrian volume rather than using default. These may affect signal timings when Pedestrian Actuation feature is on (default)."]
[null,"Crossing Distance","TBC","TBC","Pedestrian Movement Data Tab - Pedestrians Movements Data - Crossing Distance","When it is 'Input', then it should be measured on site, on drawings or map."]
[null,"Conflict Zone Length","TBC","TBC","Pedestrian Movement Data Tab - Conflict Zone Length","Conflict Zone Length should be set as Program. Otherwise, justification should be provided in the modelling report"]
[null,"Walking Speed","TBC","TBC","Pedestrian Movement Data Tab - Pedestrians Movements Data - Walking Speed (Average)"]
[null,"PEDESTRIAN TIMING DATA (Signals only)",{"$f":"IF((COUNTIF(Table212[Column2],\"\")+COUNTIF(Table212[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table212[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table212[Column4],\"info required\")+COUNTIF(Table212[Column4],\"TBC\")+COUNTIF(Table212[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"PEDESTRIAN Dialog - Pedestrian Timing Data Tabs"]
[null,"Pedestrian Actuation","TBC","TBC","Pedestrian Timing Data","None, Program and % Pedestrian Call. If Pedestrian Actuation is set to Program, pedestrians volume must to be defined accurately."]
[null,"Walk Time Extension","TBC","TBC","Pedestrian Timing Data","If applicable."]
[null,"Minimum Walk Time ","TBC","TBC","Pedestrian Timing Data","SCATS walk time plus delay. For new pedestrian movements, refer to the Operational Modelling Guidelines."]
[null,"Minimum Clearance Time","TBC","TBC","Pedestrian Timing Data","For existing sites Clearance 1 + 2 in SCATS\nFor new or modified sites refer to the Operational Modelling Guidelines."]
[null,"Clearance 1 Time","TBC","TBC","Pedestrian Timing Data","For existing sites Clearance 1 in SCATS\nFor new or modified sites refer to the Operational Modelling Guidelines."]
[null,"Clearance 2 Time","TBC","TBC","Pedestrian Timing Data","For existing sites Clearance 2 in SCATS\nFor new or modified sites refer to the Operational Modelling Guidelines."]
[null,"Start Loss","TBC","TBC","Pedestrian Timing Data","If modified, justification should be provided in the modelling report."]
[null,"End Gain","TBC","TBC","Pedestrian Timing Data","If modified, justification should be provided in the modelling report."]
[null,"TRAFFIC FLOWS",{"$f":"IF((COUNTIF(Table213[Column2],\"\")+COUNTIF(Table213[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table213[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table213[Column4],\"info required\")+COUNTIF(Table213[Column4],\"TBC\")+COUNTIF(Table213[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"VOLUMES Dialog - Vehicle Volume or Volume Factors"]
[null,"SCATS traffic reporter or site turning count survey","TBC","TBC",null,"Data should be provided."]
[null,"Future traffic methodology and calculations","TBC","TBC",null,"Assumptions and calculations should be provided."]
[null,"Heavy Vehicle volume/ percentage Estimation","TBC","TBC",null,"Data should be provided."]
[null,"Historical growths - if applicable","TBC","TBC",null,"Data should be provided."]
[null,"ROM outputs - if applicable","TBC","TBC",null,"Data should be provided."]
[null,"Sensitivity growths","TBC","TBC",null,"Assumptions should be provided."]
[null,"Traffic flows unit time","TBC","TBC","Vehicle Volume Tab - Volume Data Settings for Site - Unit Time for Volumes"]
[null,"Peak flow period","TBC","TBC","Vehicle Volume Tab - Volume Data Settings for Site - Peak Flow Period","Assumptions should be provided in the modelling report."]
[null,"Traffic flows input data","TBC","TBC","Vehicle Volume Tab - Volume Data Settings for Site - Total/ Light Vehicle/ Heavy Vehicle","To be checked for all vehicle classes"]
[null,"Peak flow factor","TBC","TBC","Volume Factors Tab - Peak Flow Factor","Assumptions should be provided in the modelling report."]
[null,"Flow scales","TBC","TBC","Volume Factors Tab - Flow Scales","This should be the same as the base model, if there is no modification in the demand. Adjustments should be justified in the modelling report."]
[null,"Growth Rate (if applicable - Design Life analysis)","TBC","TBC","Volume Factors Tab - Growth Rate "]
[null,"PRIORITIES (Not applicable for Roundabouts)",{"$f":"IF((COUNTIF(Table214[Column2],\"\")+COUNTIF(Table214[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table214[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table214[Column4],\"info required\")+COUNTIF(Table214[Column4],\"TBC\")+COUNTIF(Table214[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"PRIORITIES Dialog "]
[null,"Priorities for all the movements","TBC","TBC","Priorities Dialog","If drivers should give-way to pedestrians, required priority rules should be defined here."]
[null,"GAP ACCEPTANCE",{"$f":"IF((COUNTIF(Table215[Column2],\"\")+COUNTIF(Table215[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table215[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table215[Column4],\"info required\")+COUNTIF(Table215[Column4],\"TBC\")+COUNTIF(Table215[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"GAP ACCEPTANCE Dialog - Gap Acceptance Data Tab"]
[null,"Critical Gap (applicable for Give-way/Yield movements)","TBC","TBC","Gap Acceptance Tab - Gap Acceptance Data - Critical Gap","This should be the same as the base model. Adjustments should be justified in the modelling report."]
[null,"Follow-up Headway (applicable for Give-way/Yield movements)","TBC","TBC","Gap Acceptance Tab - Gap Acceptance Data - Follow-up Headway","This should be the same as the base model. Adjustments should be justified in the modelling report."]
[null,"End Departures (Signals only)","TBC","TBC","Gap Acceptance Tab - Gap Acceptance Data - End Departures","If modified, justification should be provided in the modelling report."]
[null,"Exiting flow effect","TBC","TBC","Gap Acceptance Tab - Gap Acceptance Data - Exiting Flow Effect","If modified, justification should be provided in the modelling report."]
[null,"Percent Opposed by Nearest Lane Only","TBC","TBC","Gap Acceptance Tab - Gap Acceptance Data - Precent Opposed by Nearest Lane Only","If modified, justification should be provided in the modelling report."]
[null,"Opposing Pedestrians (if applicable)","TBC","TBC","Gap Acceptance Tab - Gap Acceptance Data - Opposing Peds","If used, pedestrians must be specified as opposing in the Priorities dialog. Pedestrian protection time for signals should be defined here."]
[null,"Critical Gap and Follow-up Headway (Zebra crossing) ","TBC","TBC","Gap Acceptance Tab - Gap Acceptance Data for vehicles Movement at Zebra Crossing ","If modified, justification should be provided in the modelling report."]
[null,"Minimum Departures (vehicles per minutes)","TBC","TBC","Gap Acceptance Tab - Gap Acceptance Data for vehicles Movement at Zebra Crossing ","If modified, justification should be provided in the modelling report."]
[null,"GAP ACCEPTANCE- Two-way Sign Control only",{"$f":"IF((COUNTIF(Table216[Column2],\"\")+COUNTIF(Table216[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table216[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table216[Column4],\"info required\")+COUNTIF(Table216[Column4],\"TBC\")+COUNTIF(Table216[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"GAP ACCEPTANCE Dialog - Two-Way Sign Control Tab"]
[null,"Level of Reduction with Opposing Flow Rate","TBC","TBC","Two-Way Sign Control Calibration - Level of Reduction with Opposing Flow Rate","This should be the same as the base model, if there is no modification. Adjustments should be provided in the modelling report."]
[null,"Major Road Turning Flow Factor","TBC","TBC","Two-Way Sign Control Calibration - Major Road Turning Flow Factor","This should be the same as the base model. Adjustments should be justified in the modelling report."]
[null,"Two-Way Sign Control Parameters Adjustments for Major Road Number of Lanes ","TBC","TBC","Two-Way Sign Control Parameters Adjustments for Major Road Number of Lanes","Program. This should be the same as the base model. Adjustments should be justified in the modelling report."]
[null,"Two-Way Sign Control Parameters Adjustments for Geometry and Control","TBC","TBC","Two-Way Sign Control Parameters Adjustments for Geometry and Control","This should be the same as the base model. Adjustments should be justified in the modelling report."]
[null,"GAP ACCEPTANCE - Settings",{"$f":"IF((COUNTIF(Table217[Column2],\"\")+COUNTIF(Table217[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table217[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table217[Column4],\"info required\")+COUNTIF(Table217[Column4],\"TBC\")+COUNTIF(Table217[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"GAP ACCEPTANCE Dialog - Settings Tab"]
[null,"Gap Acceptance Capacity","TBC","TBC","Gap Acceptance Options - Gap Acceptance Capacity","This should be the same as the base model. Adjustments should be justified in the modelling report."]
[null,"Turn on Red parameters (Signals Only)","TBC","TBC","Gap Acceptance Data for Specified Applications","This should be the same as the base model. Adjustments should be justified in the modelling report."]
[null,"Gap Acceptance and Opposing Vehicle Factors (Zebra Crossing on Slip/Bypass Lane)","TBC","TBC","Gap Acceptance Options - Merge Analysis & Zebra Crossing Analysis Parameters","Refer to Operational Modelling Guidelines (Table 4 6 in Section 4.2.11.2)"]
[null,"Gap Acceptance and Opposing Vehicle Factors (Midblock Zebra Crossing)","TBC","TBC","Gap Acceptance Options - Merge Analysis & Zebra Crossing Analysis Parameters","Refer to Operational Modelling Guidelines (Table 4 6 in Section 4.2.11.2)"]
[null,"Gap Acceptance and Opposing Vehicle Factors (Merge Analysis Exit Short Lane)","TBC","TBC","Gap Acceptance Options - Merge Analysis & Zebra Crossing Analysis Parameters","Refer to Operational Modelling Guidelines (Table 4 6 in Section 4.2.11.2)"]
[null,"Gap Acceptance and Opposing Vehicle Factors (Merge Analysis Merge Lane)","TBC","TBC","Gap Acceptance Options - Merge Analysis & Zebra Crossing Analysis Parameters","Refer to Operational Modelling Guidelines (Table 4 6 in Section 4.2.11.2)"]
[null,"VEHICLE MOVEMENT DATA - Path Data",{"$f":"IF((COUNTIF(Table218[Column2],\"\")+COUNTIF(Table218[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table218[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table218[Column4],\"info required\")+COUNTIF(Table218[Column4],\"TBC\")+COUNTIF(Table218[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"VEHICLE MOVEMENT DATA Dialog - Path Data Tab"]
[null,"Approach Cruise Speed","TBC","TBC","Movement Path Data - Approach Cruise Speed"]
[null,"Exit Cruise Speed","TBC","TBC","Movement Path Data - Exit Cruise Speed"]
[null,"Negotiation Speed","TBC","TBC","Movement Path Data - Negotiation Speed","If it is not program, justification should be provided in the modelling report."]
[null,"Negotiation Distance","TBC","TBC","Movement Path Data - Negotiation Distance","If it is not program, justification should be provided in the modelling report."]
[null,"Negotiation Radius","TBC","TBC","Movement Path Data - Negotiation Radius","If it is not program, justification should be provided in the modelling report."]
[null,"Downstream Distance","TBC","TBC","Movement Path Data - Downstream Distance","If it is not program, justification should be provided in the modelling report."]
[null,"VEHICLE MOVEMENT DATA - Calibration",{"$f":"IF((COUNTIF(Table219[Column2],\"\")+COUNTIF(Table219[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table219[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table219[Column4],\"info required\")+COUNTIF(Table219[Column4],\"TBC\")+COUNTIF(Table219[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"VEHICLE MOVEMENT DATA Dialog - Calibration Tab"]
[null,"Queue Space","TBC","TBC","Movement Calibration Data","This should be the same as the base model, if there is no modification. Adjustments should be provided in the modelling report.."]
[null,"Vehicle Length","TBC","TBC","Movement Calibration Data","This should be the same as the base model, if there is no modification. Adjustments should be provided in the modelling report."]
[null,"Vehicle Occupancy","TBC","TBC","Movement Calibration Data","This should be the same as the base model, if there is no modification. Adjustments should be provided in the modelling report."]
[null,"Turning Vehicle Effects","TBC","TBC","Movement Calibration Data"]
[null,"Gap Acceptance Factor","TBC","TBC","Movement Calibration Data","Refer to the Operational Modelling Guidelines."]
[null,"Opposing Vehicle Factor","TBC","TBC","Movement Calibration Data","Refer to the Operational Modelling Guidelines."]
[null,"Practical Degree of Saturation","TBC","TBC","Movement Calibration Data","If it is modified, it should be provided in the modelling report."]
[null,"VEHICLE MOVEMENT DATA - Signals (Signals Only)",{"$f":"IF((COUNTIF(Table220[Column2],\"\")+COUNTIF(Table220[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table220[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table220[Column4],\"info required\")+COUNTIF(Table220[Column4],\"TBC\")+COUNTIF(Table220[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"VEHICLE MOVEMENT DATA Dialog - Calibration Tab"]
[null,"Signal Coordination (Network Only)","TBC","TBC","Movement Data - Signals"]
[null,"Stop line Travel Time (Network Only)","TBC","TBC","Movement Data - Signals"]
[null,"Start Loss and End Gain","TBC","TBC","Movement Data - Signals - Vehicle Movement Timing Data","These should be the same as the base model."]
[null,"Minimum Green","TBC","TBC","Movement Data - Signals - Vehicle Movement Timing Data","the calculated phase time for 100 per cent frequency should not be longer than the minimum phase in SCATS"]
[null,"Maximum Green","TBC","TBC","Movement Data - Signals - Vehicle Movement Timing Data"]
[null,"Phase Actuation","TBC","TBC","Movement Data - Signals - Vehicle Movement Timing Data"]
[null,"Early Cut-Off (if applicable)","TBC","TBC","Movement Data - Signals - Vehicle Movement Timing Data","Calculations for the new sites should be provided in the modelling report. Refer to Operational Modelling Guidelines."]
[null,"Late Start (if applicable)","TBC","TBC","Movement Data - Signals - Vehicle Movement Timing Data","Calculations for the new or modified sites should be provided in the modelling report. This should be used to define filtering right turn or pedestrian protection time. Refer to Operational Modelling Guidelines."]
[null,"PHASING & TIMING (Signals Only)",{"$f":"IF((COUNTIF(Table221[Column2],\"\")+COUNTIF(Table221[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table221[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table221[Column4],\"info required\")+COUNTIF(Table221[Column4],\"TBC\")+COUNTIF(Table221[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"PHASING & TIMING Dialog"]
[null,"Provide SCATS Intersection graphs and SCATS Historical or IDM data","TBC","TBC"]
[null,"Signal Analysis Method","TBC","TBC","Sequence tab","Fixed-Time/Pretimed for intersections running under SCATS-coordinated or master-isolated control.\nThe Actuated analysis method should be used for intersections operating under a traditional actuated control method."]
[null,"Phases","TBC","TBC","Sequence Editor tab","This should be consistent with SCATS or LM drawings."]
[null,"Phasing sequence","TBC","TBC","Sequence Editor tab","For each movement class, this should be consistent with SCATS."]
[null,"Variable Phases","TBC","TBC","Phase & Sequence Data tab - Phase Data","Should be consistent with SCATS site graphics or LM drawings."]
[null,"Phase Time","TBC","TBC",null,"Applicable if Cycle Time Option is User-Given Phase Times. This is not recommended for proposed models."]
[null,"Phase Frequency","TBC","TBC","Phase & Sequence Data tab - Phase Data","Applicable if Cycle Time Option is User-Given Phase Times. This is not recommended for proposed models."]
[null,"Yellow Time and All-Red Time","TBC","TBC","Phase & Sequence Data tab - Phase Data","For a new or modified sites, these should be calculated. If only one yellow time or all-red time has a decimal value, it should be rounded up. However, if both have decimal values, one should be rounded up and the other should be rounded down."]
[null,"Dummy Movement Exists","TBC","TBC","Phase & Sequence Data tab - Phase Data","If dummy movements are defined, assumptions should be provided in the modelling report. "]
[null,"Minimum Green Time (dummy movements only)","TBC","TBC","Phase & Sequence Data tab - Phase Data","Defined values should be justified."]
[null,"Maximum Green Time (dummy movements only)","TBC","TBC","Phase & Sequence Data tab - Phase Data","Defined values should be justified."]
[null,"Maximum Green Time (actuated signals only)","TBC","TBC","Phase & Sequence Data tab - Actuated Signal Data","For actuated signals and when fixed green time is required for a phase."]
[null,"Gap Setting (actuated signals only)","TBC","TBC","Phase & Sequence Data tab - Actuated Signal Data","Applicable on actuated signal only."]
[null,"Cycle Time Option","TBC","TBC","Timing Options tab - Cycle Time Option","Practical, Optimum, etc. If it is User-Given Phase Times, then specify Phase Time and Frequency in Phase & Sequence Data tab."]
[null,"Green Split Priority","TBC","TBC","Timing Options tab - Green Split Option","Applicable only for User-Given Cycle Time and Network."]
[null,"Phase Transition (Apply Intergreen)","TBC","TBC","Advanced tab - Movement Data","Specify if intergreen time must be applied during phase transition for vehicle and pedestrian signal groups (no overlap). Particularly, for pedestrian signal group runs in consecutive phases and for diamond phases."]
[null,"Red Arrow Drop Off","TBC","TBC","Advanced tab - Movement Data","In order to define the late start for a filtering right turn phase which comes after a leading right turn phase, Red-Arrow Drop Off box should be checked"]
[null,"Undetected Movements","TBC","TBC","Advanced tab - Movement Data"]
[null,"DEMAND & SENSITIVITY",{"$f":"IF((COUNTIF(Table222[Column2],\"\")+COUNTIF(Table222[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table222[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table222[Column4],\"info required\")+COUNTIF(Table222[Column4],\"TBC\")+COUNTIF(Table222[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"DEMAND & SENSITIVITY Dialog"]
[null,"Appropriate Analysis Option ( if applicable)","TBC","TBC","Analysis Option"]
[null,"PARAMETER SETTINGS",{"$f":"IF((COUNTIF(Table223[Column2],\"\")+COUNTIF(Table223[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table223[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table223[Column4],\"info required\")+COUNTIF(Table223[Column4],\"TBC\")+COUNTIF(Table223[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"PARAMETER SETTINGS"]
[null,"Provide supporting data when parameters are modified.","TBC","TBC","All parameters"]
[null,"SITE MODEL OUTPUTS",{"$f":"IF((COUNTIF(Table224[Column2],\"\")+COUNTIF(Table224[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table224[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table224[Column4],\"info required\")+COUNTIF(Table224[Column4],\"TBC\")+COUNTIF(Table224[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"SITE OUTPUT Pane"]
[null,"Diagnostics","TBC","TBC","Diagnostics","Error and warning messages should be reviewed and fixed."]
[null,"Saturation Flows Rate (vehicle / hour)","TBC","TBC","Detailed Output - Lane Flow and Capacity Information"]
[null,"Degree of Saturation (%)","TBC","TBC","Lane Summary - Degree of Saturation (v/c)"]
[null,"Queue Distance","TBC","TBC","Lane Summary - Average Back of Queue","Depending on the scheme, the modeller may be required to report either 95th percentile back of queue or average back of queue."]
[null,"Short Lane Capacity","TBC","TBC","Detailed Output - Lane Performance and Capacity Information","Capacity and Saturation Flow Rate values to be checked if reduced capacity due to a short lane effect."]
[null,"Site Level of Service","TBC","TBC","Lane Summary or Movement Summary"]
[null,"Short Lane Overflow Probability","TBC","TBC","Lane Flows - Prob. SL Ov. %","Probability of the short lane back of queue exceeding the short lane length"]
[null,"Upstream Lane Blockage","TBC","TBC","Lane Summary - Prob. Block %"]
[null,"Capacity Reduction","TBC","TBC","Lane Summary - Cap. Adj. %"]
[null,"Other Comments"]

{"sheet":"Proposed - Network","index":5,"n_rows":102,"n_cols":6,"rows_kept":102,"cut":false,"hidden":false,"merged":[[32,1,32,4],[91,4,91,5],[101,1,101,5],[38,4,38,5],[56,4,56,5],[59,4,59,5],[75,4,75,5],[85,4,85,5],[88,4,88,5],[35,4,35,5],[0,1,0,4],[1,2,1,4],[2,2,2,4],[3,2,3,4],[4,2,4,4],[18,1,18,2],[11,1,11,4],[5,2,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,2,9,4]]}
[null,"SIDRA Proposed Model Audit Checklist - Network (Ver2.0)"]
[null,"Project Information",{"$f":"IF(C4=\"\",\"\",C4)","v":""}]
[null,"Project"]
[null,"Model Name"]
[null,"Network Name"]
[null,"Network ID (if applicable)"]
[null,"Applicant (Name & Organisation / MRWA Team)"]
[null,"Modeller (Name & Consultancy / MRWA Team)"]
[null,"Auditing Process Coordinator (Name & MRWA Team)"]
[null,"Model Auditor (Name & MRWA Team)"]
[]
[null,"Step 1 - Comparing the Base and Proposed Networks Input"]
[]
[]
[null,"1 - Select Network tab, then select Input"]
[null,"     Comparison  "]
[]
[]
[null,"2 -"]
[null,"     Network B = Option model "]
[null,"     Network A = Its relevant Base model"]
[null,"     Press OK."]
[]
[]
[]
[]
[]
[null,"3 - Check the highlighted differences"]
[]
[]
[]
[]
[null,"Step 2 - Checking the Proposed model"]
[]
[null,"Proposed Model Checks","Modeller","Model Auditor","Find it in SIDRA software - Network tab","General SIDRA Model Criteria\n(also check Instruction Form for specific requirements)"]
[null,"NETWORK CONFIGURATION",{"$f":"IF((COUNTIF(Table302[Column2],\"\")+COUNTIF(Table302[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table302[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table302[Column4],\"info required\")+COUNTIF(Table302[Column4],\"TBC\")+COUNTIF(Table302[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"NETWORK CONFIGURATION Dialog or Network Layout"]
[null,"Network Connections","TBC","TBC","NETWORK CONFIGURATION Dialog","All the connectors should be green indicating a valid connection. If there is an error or a warning check number of lanes, movement classes and approach and exit distance at connections."]
[null,"Network Layout","TBC","TBC",null,"Should be consistent with the proposed layout."]
[null,"NETWORK  DATA",{"$f":"IF((COUNTIF(Table303[Column2],\"\")+COUNTIF(Table303[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table303[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table303[Column4],\"info required\")+COUNTIF(Table303[Column4],\"TBC\")+COUNTIF(Table303[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"NETWORK  DATA Dialog"]
[null,"Network Name ","TBC","TBC","Network Data tab - Network Data","Network to be labelled reasonably (e.g. corridor name, AM/PM, Year, etc.)."]
[null,"Network ID","TBC","TBC","Network Data tab - Network Data","Allocate unique IDs to all sites and common control groups in the network, e.g. SCATS TCS."]
[null,"Network Level of Service Method and Level of Service Target","TBC","TBC","Network Data tab - Network Data","SIDRA Speed Efficiency and LOS D"]
[null,"Network Performance Measure","TBC","TBC","Network Data tab - Network Data","Justify in the modelling report, if it is adjusted. Default is Delay."]
[null,"Apply Platoon Dispersion","TBC","TBC","Network Data tab - Network Data","Unchecked, if the distance between network sites is short and there is zero offset for individual sites."]
[null,"Apply Lane Blockage Model","TBC","TBC","Network Data tab - Network Data","It should be checked"]
[null,"Desired Speed","TBC","TBC","Network Data tab - Network Data","Justify in the modelling report, if it is not program."]
[null,"Lower Limit of Speed Efficiency for TTI","TBC","TBC","Network Data tab - Network Data","Justify in the modelling report, if it is adjusted. Default value = 0.1."]
[null,"Maximum Number of Iteration","TBC","TBC","Network Data tab - Network Analysis Settings","Should be set to 10 or greater value (up to 30)."]
[null,"Percentage Stopping Condition","TBC","TBC","Network Data tab - Network Analysis Settings","Should be set to 1.0% or less (down to 0.1%)."]
[null,"Peak Flow Period ","TBC","TBC","Override Site Data - Network Parameters that override Site Data"]
[null,"Site Level of Service Method","TBC","TBC","Override Site Data - Network Parameters that override Site Data","Delay (SIDRA)"]
[null,"Queue in Output","TBC","TBC","Override Site Data - Network Parameters that override Site Data","As required for the project."]
[null,"Hours per Year ","TBC","TBC","Override Site Data - Network Parameters that override Site Data","Justify in the modelling report, if it is adjusted. Default value = 480 h."]
[null,"Cost Unit","TBC","TBC","Override Site Data - Network Parameters that override Site Data","$"]
[null,"Exclude Geometric Delay","TBC","TBC","Override Site Data - Network Parameters that override Site Data","This should be unchecked."]
[null,"Include Short Lanes in determining Approach Queue Storage Ratio","TBC","TBC","Override Site Data - Network Parameters that override Site Data","If it is checked, justify in the modelling report."]
[null,"DEFINE CCGS (Networks with Common Control Groups only)",{"$f":"IF((COUNTIF(Table304[Column2],\"\")+COUNTIF(Table304[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table304[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table304[Column4],\"info required\")+COUNTIF(Table304[Column4],\"TBC\")+COUNTIF(Table304[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"CCG1 ID","TBC","TBC","Create Common Control Groups","For the existing signals Main Roads TCS number to be used."]
[null,"Allocate Sites to Common Control Groups","TBC","TBC","Allocate Sites to Common Control Groups"]
[null,"COMMON CONTROL GROUPS (Networks with Common Control Groups only)",{"$f":"IF((COUNTIF(Table305[Column2],\"\")+COUNTIF(Table305[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table305[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table305[Column4],\"info required\")+COUNTIF(Table305[Column4],\"TBC\")+COUNTIF(Table305[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"COMMON CONTROL GROUPS Dialog"]
[null,"Provide SCATS Intersection graphs and SCATS Historical or IDM data","TBC","TBC"]
[null,"Signal Analysis Method","TBC","TBC","Sequence tab","Fixed-Timed or Actuated:\nFixed-Time/Pretimed for intersections running under SCATS-coordinated or master-isolated control.\nThe Actuated analysis method should be used for intersections operating under a traditional actuated control method."]
[null,"Phases","TBC","TBC","Sequence Editor tab","To be checked against SCATS or LM drawings."]
[null,"Phasing sequence - (for each movement class if applicable)","TBC","TBC","Sequence Editor tab","To be checked against SCATS."]
[null,"Variable Phases","TBC","TBC","Phase & Sequence Data tab - Phase Data","To be checked against SCATS site graphics."]
[null,"Reference Phase","TBC","TBC","Phase & Sequence Data tab - Phase Data","For traffic signal coordination in network, it should be consistent with SCATS."]
[null,"Phase Time","TBC","TBC","Phase & Sequence Data tab - Phase Data","Applicable when cycle time option is User-Given Phase Times."]
[null,"Yellow Time and All-Red Time","TBC","TBC","Phase & Sequence Data tab - Phase Data","To be checked the against SCATS settings for the existing sites. To be calculated for new or modified sites."]
[null,"Dummy Movement Exists","TBC","TBC","Phase & Sequence Data tab - Phase Data","If applicable, provide justification in the modelling report."]
[null,"Maximum Green Time (Actuated Signals only)","TBC","TBC","Phase & Sequence Data tab - Actuated Signal Data"]
[null,"Gap Setting (Actuated Signals only)","TBC","TBC","Phase & Sequence Data tab - Actuated Signal Data"]
[null,"Cycle Time Option","TBC","TBC","Timing Options tab - Cycle Time Option","Practical, Optimum, etc. If User-Given Phase Times is applied, then specify phase time in Phase & Sequence Data tab."]
[null,"Green Split Priority","TBC","TBC","Timing Options tab - Green Split Option","Applicable only for User-Given Cycle Time and Network."]
[null,"Undetected movements","TBC","TBC","Advanced tab - Movement Data","Specify if applicable"]
[null,"Phase Transition (no phase overlap)","TBC","TBC","Advanced tab - Movement Data","specify if intergreen time should run for vehicles and pedestrians signal groups. Particularly for pedestrian signal group runs in consecutive phases and for Diamond phases."]
[null,"NETWORK TIMING DATA (Network with signalised intersections)",{"$f":"IF((COUNTIF(Table306[Column2],\"\")+COUNTIF(Table306[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table306[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table306[Column4],\"info required\")+COUNTIF(Table306[Column4],\"TBC\")+COUNTIF(Table306[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"NETWORK TIMING DATA Dialog"]
[null,"Coordinated Site / CCG","TBC","TBC","Network Timing Data tab - Signal Coordination","To be checked the against SCATS."]
[null,"Reference Site / CCG","TBC","TBC","Network Timing Data tab - Signal Coordination","To be checked the against SCATS."]
[null,"User Offset","TBC","TBC","Network Timing Data tab - Signal Coordination","Applicable when the Signal Offset is set to User in the Signal Offset tab. To be checked the against SCATS."]
[null,"Network Cycle Time","TBC","TBC","Network Timing Data tab - Cycle Time and Phase Time"]
[null,"Signal Offset","TBC","TBC","Signal Offsets tab - Signal Offsets","If it is set to program, User Offsets will not apply to Sites that are on routes specified for offset calculation (checked in the Routes for Offset Calculation table in Signal Offsets tab). User offsets will apply to the other sites."]
[null,"Route for Offset Calculation","TBC","TBC","Signal Offsets tab - Routes for Offset Calculation","The relevant route should be checked."]
[null,"Signal Offset Method","TBC","TBC","Signal Offsets tab - Routes for Offset Calculation","For program signal offset only. To be set to the default (Start of Green (Leading))."]
[null,"Route for Offset Calculation -  Movement Class","TBC","TBC","Signal Offsets tab - Routes for Offset Calculation","The majority vehicle class on the route should be selected."]
[null,"Signal Offset Definition","TBC","TBC","Signal Offsets tab - Setting","When yellow time and all-red time are not the same for all the sites, must be set to  Offset (Green Start)."]
[null,"NETWORK ROUTES",{"$f":"IF((COUNTIF(Table307[Column2],\"\")+COUNTIF(Table307[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table307[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table307[Column4],\"info required\")+COUNTIF(Table307[Column4],\"TBC\")+COUNTIF(Table307[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"NETWORK ROUTES Dialog"]
[null,"Network Routes","TBC","TBC","NETWORK ROUTES tab - Network Routes","Required network routes should be defined and selected according to sub-area assessment purposes."]
[null,"Network Output by Routes Options","TBC","TBC","NETWORK ROUTES tab - Network Output by Routes Options"]
[null,"SITES OF NETWORK",{"$f":"IF((COUNTIF(Table308[Column2],\"\")+COUNTIF(Table308[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table308[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table308[Column4],\"info required\")+COUNTIF(Table308[Column4],\"TBC\")+COUNTIF(Table308[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"SITE tab"]
[null,"Lane Movement Flow Proportions  inside the Network","TBC","TBC","LANE MOVEMENTS Dialog - Flow Proportions tab - Lane Movements Flow Proportions","Refer to the Operational Modelling Guidelines."]
[null,"Early Cut-off or Late Start in CCGs","TBC","TBC","VEHICLE MOVEMENT DATA dialog - Signals Tab","Refer to the Operational Modelling Guidelines."]
[null,"NETWORK MODEL OUTPUTS",{"$f":"IF((COUNTIF(Table309[Column2],\"\")+COUNTIF(Table309[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table309[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table309[Column4],\"info required\")+COUNTIF(Table309[Column4],\"TBC\")+COUNTIF(Table309[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"},"NETWORK tab - OUTPUT Pane or Route tab"]
[null,"Diagnostics","TBC","TBC","Diagnostics","Error and warning messages should be reviewed and fixed."]
[null,"Network and Route Level of Service","TBC","TBC","Network Summary, Route Summary","LOS A, B, C or D is acceptable."]
[null,"Capacity Adjustment or Blockage Probability","TBC","TBC","Lane Summary, Lane Displays (Site, network, Route)"]
[null,"Degree of Saturation","TBC","TBC","Lane Summary, Lane Displays (Site, network, Route)","Less or equal to 0.9 is desirable."]
[null,"Lane Utilisation","TBC","TBC","Lane Summary","Should be reported if it is less than 100%."]
[null,"Midblock Inflow and Outflow Rates","TBC","TBC","Network Flows","Should be reported if it is greater than 0."]
[null,"Midblock Lane Change Rates","TBC","TBC","Lane Changes ","High lane changes volume should be reported."]
[null,"Arrival Flow Rates","TBC","TBC","Lane Summary, Arrival Flows display","Arrival Flow reduction should be reported."]
[null,"Platoon Ratio","TBC","TBC","Signal Offsets","Greater than 1 is desirable."]
[null,"Other Comments"]