{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Lists","Version","Base","Option Model","Proposed"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,"Document Control"]
[null,"D21#365823"]
[null,"Version number","Date","Author/Editor","Nature of Amendment"]
[null,"1.0","2021-07-01","OMV - KG","First Release"]

{"sheet":"Base","index":2,"n_rows":89,"n_cols":5,"rows_kept":89,"cut":false,"hidden":false,"merged":[[0,1,0,4],[8,2,8,4],[2,2,2,4],[4,2,4,4],[6,2,6,4],[7,2,7,4],[3,2,3,4],[5,2,5,4]]}
[null,"Aimsun Mesoscopic and Hybrid Base Model Audit Checklist (Ver 1.0)"]
[null,"Project Information"]
[null,"Project Name"]
[null,"Model Name"]
[null,"Model Date"]
[null,"Software Version"]
[null,"Project Manager (Name & Organisation / MRWA Team)"]
[null,"Modeller (Name & Consultancy / MRWA Team)"]
[null,"Model Auditor (Name & MRWA Team)"]
[]
[null,"Check Items","Modeller","Model Auditor","General Aimsun Model Criteria"]
[null,"Supply Information",{"$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","Refer to Section 3.8.4.1 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Calibration and Validation Report","TBC","TBC","Refer to Section 3.8.4.2 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Methodology Report","TBC","TBC","Refer to Section 3.8.3 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Traffic count survey data","TBC","TBC","Refer to Section 4.1.4 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Origin-destination data (overarching model or survey data)","TBC","TBC","Refer to Section 4.1.5 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Travel time data","TBC","TBC","Refer to Section 4.1.6 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"SCATS files","TBC","TBC","Refer to Section 4.1.9 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Peak hour estimation and demand profile spreadsheet","TBC","TBC","Refer to Section 3.4 and Section 5.7.3.5 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Average signal timings and signal offset spreadsheet","TBC","TBC","Provide the average signal timings and signal offset spreadsheet"]
[null,"Traffic flow diagram(s)","TBC","TBC","Refer to Section 4.2 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Real data set files","TBC","TBC","Provide the real data set files in .txt or .csv format"]
[null,"Background aerial image","TBC","TBC","Refer to Section 5.1.3 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Basic Network Set-up",{"$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"}]
[null,"Network settings","TBC","TBC","Refer to Section 5.1.1 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Coordinate system, background scale and positioning","TBC","TBC","Refer to Section 5.1.2 and Section 5.1.3 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Model boundaries","TBC","TBC","Review the model boundaries to ensure that it aligns with the scope stated in the Methodology Report."]
[null,"Traffic Assignment","TBC","TBC","Refer to Section 5.2 and Section 7.1.1 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Microsimulation pocket for hybrid modelling","TBC","TBC","Review the microsimulation pocket(s) to ensure that it aligns with the scope stated in the Methodology Report."]
[null,"Road Section",{"$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"}]
[null,"Network checked to ensure it accurately represents the alignment (e.g. no. lanes, lane lengths etc.)","TBC","TBC","Review the modelled road network"]
[null,"Section: Road parameters (speed limit, capacity, lane width, road type, banned vehicles)","TBC","TBC","Refer to Section 5.3 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Section: Dynamic parameters (jam density, reaction time factor, lane selection, lane change cooperation, queue discharge)","TBC","TBC","Refer to Section 5.3 and Section 7.1.2.1 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Section: Static parameters (if applicable)","TBC","TBC","Refer to Section 5.2.3 and Section 7.1.2.1 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Geometry configuration","TBC","TBC","If applicable, review any geometry configurations"]
[null,"Lane types (e.g. bus lanes)","TBC","TBC","Refer to Section 5.3.4 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Lane utilisation","TBC","TBC","Refer to Section 5.4.6 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Subpaths: Correct sections selected","TBC","TBC","Review subpaths"]
[null,"Intersection and Node Control",{"$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"}]
[null,"Lane movements","TBC","TBC","Review the lane movements within the node"]
[null,"Turn lane lengths","TBC","TBC","Review the lane lengths"]
[null,"Turning speeds","TBC","TBC","Refer to Section 5.4.1 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Signal controller type (fixed, actuated or SCATSIM)","TBC","TBC","Refer to Section 5.4.2 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Signal operations (e.g. cycle time, phase sequence, green times, offsets, filtering movements, yellow, red times and master control plan)","TBC","TBC","As per SCATS operations during the modelled period"]
[null,"Priority control type (stop or give-way)","TBC","TBC","Refer to Section 5.4.3 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Turn Penalty Function and Junction Delay Function(only applicable when using static assignment)","TBC","TBC","Refer to Section 5.2.3 and Section 7.1.2.2 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Yellow box and yellow box speeds (if applicable)","TBC","TBC","Review the yellow box and yellow box speeds"]
[null,"Lane change look-ahead distance","TBC","TBC","Review the look-ahead distance"]
[null,"Turn restrictions","TBC","TBC","Refer to Section 5.8 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Public Transport",{"$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"}]
[null,"Public transport lines: All routes connected, bus stops, timetables and dwell time setting.","TBC","TBC","Refer to Section 5.5 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Public transport plans: PT lines checked for each plan","TBC","TBC","Review PT lines selected for each plan"]
[null,"Demand Data",{"$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"}]
[null,"Model period (including warm-up and cool-down)","TBC","TBC","Refer to Section 5.7.1 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Vehicle type parameters","TBC","TBC","Refer to Section 5.7.2 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Centroid configuration: Zone disaggregation, location and connectivity","TBC","TBC","Refer to Section 5.7.3 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Traffic demands: demand profile, initial times, duration, vehicle classes etc.","TBC","TBC","Refer to Section 5.7.4 and Section 5.7.5 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Path assignments: Files locations and names provided","TBC","TBC","Review the Path Assignment settings"]
[null,"Real data set (RDS) set-up","TBC","TBC","Review the Real Data Set settings"]
[null,"Consideration of pedestrians and cyclists","TBC","TBC","Refer to Section 5.6 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Scenarios",{"$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"}]
[null,"Scenario management","TBC","TBC","Refer to Section 5.9.1 and review the selected traffic demand, public transport, path assignment, real data set and master control plan are correct."]
[null,"Seed numbers","TBC","TBC","Refer to Section 5.9.2 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Scenario Set-up: Traffic Demand, Public Transport, Path Assignment, Master Control, Geometry Configuration, Real Data Set, Output to Generate intervals, Strategies and Conditions, Aimsun API","TBC","TBC","Review the selected traffic demand, public transport, path assignment, real data set and master control plan are correct."]
[null,"Experiment Setup - Attribute Overrides, Behaviour, Reaction Times, Dynamic Traffic Assignment parameters, Policies","TBC","TBC","Refer to Section 7.1.1 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Scripts",{"$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"}]
[null,"Python script checked for activated functions (if applicable)","TBC","TBC","-"]
[null,"Traffic Management (e.g. school zones, ITS, construction traffic management)",{"$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"}]
[null,"Strategies, traffic conditions, triggers","TBC","TBC","Review the Traffic Management schemes"]
[null,"Calibration and Validation",{"$f":"IF((COUNTIF(Table19[Column2],\"\")+COUNTIF(Table19[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table19[Column3],\"fail\")>0,\"Fail\",IF(COUNTIF(Table19[Column3],\"info required\")+COUNTIF(Table19[Column3],\"TBC\")+COUNTIF(Table19[Column3],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"Route choice review","TBC","TBC","Refer to Section 5.10.2 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Prior and post matrix review","TBC","TBC","Refer to Section 5.10.3 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Individual Traffic Volume Comparison","TBC","TBC","Refer to Section 5.10.4.1 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Total Traffic Volume Comparison","TBC","TBC","Refer to Section 5.10.4.2 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Travel time Comparison","TBC","TBC","Refer to Section 5.10.5 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Queues length Comparison","TBC","TBC","Refer to Section 5.10.6 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Signal Timings Comparison (Reporting is only required when Actuated or SCATSIM has been used)","TBC","TBC","Refer to Section 5.10.7 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Vehicle Speeds Comparison (if applicable)","TBC","TBC","Refer to Section 5.10.8 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Origin and Destination Comparison (if applicable)","TBC","TBC","Refer to Section 5.10.9 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Model stability","TBC","TBC","Refer to Section 5.10.10 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Latent (unreleased) demand","TBC","TBC","Refer to Section 5.10.11 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Sensitivity analysis","TBC","TBC","Refer to Section 5.10.12 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Other Comments",{"$f":"IF((COUNTIF(Table197[Column2],\"\")+COUNTIF(Table197[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table197[Column3],\"fail\")>0,\"Fail\",IF(COUNTIF(Table197[Column3],\"info required\")+COUNTIF(Table197[Column3],\"TBC\")+COUNTIF(Table197[Column3],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,null,"TBC","TBC"]
[null,null,"TBC","TBC"]
[null,null,"TBC","TBC"]
[null,null,"TBC","TBC"]
[null,null,"TBC","TBC"]

{"sheet":"Option Model","index":3,"n_rows":60,"n_cols":5,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,1,0,4],[2,2,2,4],[3,2,3,4],[6,4,6,5],[13,4,13,5],[22,4,22,5],[54,4,54,5],[33,4,33,5],[36,4,36,5],[41,4,41,5],[46,4,46,5],[48,4,48,5],[50,4,50,5]]}
[null,"Aimsun Mesoscopic and Hybrid Option Model Audit Checklist (Ver 1.0)"]
[null,"Project Information"]
[null,"Model Name"]
[null,"Future Year(s)"]
[]
[null,"Check Items","Modeller","Model Auditor","General Aimsun Model Criteria"]
[null,"Supply Information",{"$f":"IF((COUNTIF(Table410[Column2],\"\")+COUNTIF(Table410[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table410[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table410[Column4],\"info required\")+COUNTIF(Table410[Column4],\"TBC\")+COUNTIF(Table410[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"Electronic version of option model(s)","TBC","TBC","Refer to Section 3.8.4.1 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Future Year Growth Memorandum","TBC","TBC","Refer to Section 3.8.3 and Section 6.3 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Future year origin-destination data (overarching model)","TBC","TBC","Refer to Section 4.1.5 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Proposed design drawings","TBC","TBC","-"]
[null,"Proposed signal timings (if applicable)","TBC","TBC","-"]
[null,"Option Model Report","TBC","TBC","Refer to Section 3.8.4.2 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Road Section",{"$f":"IF((COUNTIF(Table1037[Column2],\"\")+COUNTIF(Table1037[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table1037[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table1037[Column4],\"info required\")+COUNTIF(Table1037[Column4],\"TBC\")+COUNTIF(Table1037[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"Network checked to ensure it accurately represents the proposed alignment (e.g. no. lanes, lane lengths etc.)","TBC","TBC","Review the proposed road network"]
[null,"Section: Road parameters (speed limit, capacity, lane width, road type, banned vehicles)","TBC","TBC","Refer to Section 5.3 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Section: Dynamic parameters (jam density, reaction time factor, lane selection, lane change cooperation, queue discharge)","TBC","TBC","Refer to Section 5.3 and Section 7.1.2.1 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Section: Static parameters (if applicable)","TBC","TBC","Refer to Section 5.2.3 and Section 7.1.2.1 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Geometry configuration","TBC","TBC","If applicable, review any geometry configurations"]
[null,"Lane types (e.g. bus lanes)","TBC","TBC","Refer to Section 5.3.4 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Lane utilisation","TBC","TBC","Refer to Section 5.4.6 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Subpaths: Correct sections selected","TBC","TBC","Review subpaths"]
[null,"Intersection and Node Control",{"$f":"IF((COUNTIF(Table831[Column2],\"\")+COUNTIF(Table831[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table831[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table831[Column4],\"info required\")+COUNTIF(Table831[Column4],\"TBC\")+COUNTIF(Table831[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"Lane movements","TBC","TBC","Review the lane movements within the node"]
[null,"Turn lane lengths","TBC","TBC","Review the lane lengths"]
[null,"Turning speeds","TBC","TBC","Refer to Section 5.4.1 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Signal controller type (fixed, actuated or SCATSIM)","TBC","TBC","Refer to Section 5.4.2 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Signal operations (e.g. cycle time, phase sequence, green times, offsets, filtering movements, yellow, red times and master control plan)","TBC","TBC","As per SCATS operations during the modelled period"]
[null,"Priority control type (stop or give-way)","TBC","TBC","Refer to Section 5.4.3 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Turn Penalty Function and Junction Delay Function(only applicable when using static assignment)","TBC","TBC","Refer to Section 5.2.3 and Section 7.1.2.2 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Yellow box and yellow box speeds","TBC","TBC","Review the yellow box and yellow box speeds"]
[null,"Lane change look-ahead distance","TBC","TBC","Review the look-ahead distance"]
[null,"Turn restrictions","TBC","TBC","Refer to Section 5.8 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Public Transport",{"$f":"IF((COUNTIF(Table1232[Column2],\"\")+COUNTIF(Table1232[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table1232[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table1232[Column4],\"info required\")+COUNTIF(Table1232[Column4],\"TBC\")+COUNTIF(Table1232[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"Public transport lines: All routes connected, bus stops, timetables and dwell time setting.","TBC","TBC","If applicable, update public transport line information"]
[null,"Public transport plans: PT lines checked for each plan","TBC","TBC","Review PT lines selected for each plan"]
[null,"Demand Data",{"$f":"IF((COUNTIF(Table730[Column2],\"\")+COUNTIF(Table730[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table730[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table730[Column4],\"info required\")+COUNTIF(Table730[Column4],\"TBC\")+COUNTIF(Table730[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"Centroid configuration: Zone disaggregation, location and connectivity","TBC","TBC","Refer to Section 5.7.3 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Traffic demands: demand profile, initial times, duration, vehicle classes etc.","TBC","TBC","Refer to Section 5.7.4 and Section 5.7.5 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Path assignments: Files locations and names provided","TBC","TBC","Review the Path Assignment settings"]
[null,"Consideration of pedestrians and cyclists","TBC","TBC","Refer to Section 5.6 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Scenarios",{"$f":"IF((COUNTIF(Table1334[Column2],\"\")+COUNTIF(Table1334[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table1334[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table1334[Column4],\"info required\")+COUNTIF(Table1334[Column4],\"TBC\")+COUNTIF(Table1334[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"Scenario management","TBC","TBC","Refer to Section 5.9.1 and Section 6.1 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Seed numbers","TBC","TBC","Refer to Section 5.9.2 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Scenario Set-up: Traffic Demand, Public Transport, Path Assignment, Master Control, Geometry Configuration, Output to Generate intervals, Strategies and Conditions, Aimsun API","TBC","TBC","Review the selected traffic demand, public transport, path assignment and master control plan are correct."]
[null,"Experiment Setup - Attribute Overrides, Behaviour, Reaction Times, Dynamic Traffic Assignment parameters, Policies","TBC","TBC","Refer to Section 7.1.1 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Scripts",{"$f":"IF((COUNTIF(Table1435[Column2],\"\")+COUNTIF(Table1435[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table1435[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table1435[Column4],\"info required\")+COUNTIF(Table1435[Column4],\"TBC\")+COUNTIF(Table1435[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"Python script checked for activated functions (if applicable)","TBC","TBC","-"]
[null,"Traffic Management (e.g. school zones, ITS, construction traffic management)",{"$f":"IF((COUNTIF(Table1536[Column2],\"\")+COUNTIF(Table1536[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table1536[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table1536[Column4],\"info required\")+COUNTIF(Table1536[Column4],\"TBC\")+COUNTIF(Table1536[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"Strategies, traffic conditions, triggers","TBC","TBC","Review the Traffic Management schemes"]
[null,"Option Model Review",{"$f":"IF((COUNTIF(Table1938[Column2],\"\")+COUNTIF(Table1938[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table1938[Column3],\"fail\")>0,\"Fail\",IF(COUNTIF(Table1938[Column3],\"info required\")+COUNTIF(Table1938[Column3],\"TBC\")+COUNTIF(Table1938[Column3],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"Route choice review","TBC","TBC","Refer to Section 6.4 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Signal timing review","TBC","TBC","Improve signal timing and offset (if applicable)"]
[null,"Latent (unreleased) demand","TBC","TBC","Refer to Section 6.3.3 of the Mesoscopic and Hybrid Modelling Guidelines"]
[null,"Other Comments",{"$f":"IF((COUNTIF(Table19739[Column2],\"\")+COUNTIF(Table19739[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table19739[Column3],\"fail\")>0,\"Fail\",IF(COUNTIF(Table19739[Column3],\"info required\")+COUNTIF(Table19739[Column3],\"TBC\")+COUNTIF(Table19739[Column3],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,null,"TBC","TBC"]
[null,null,"TBC","TBC"]
[null,null,"TBC","TBC"]
[null,null,"TBC","TBC"]
[null,null,"TBC","TBC"]

{"sheet":"Proposed","index":4,"n_rows":94,"n_cols":6,"rows_kept":94,"cut":false,"hidden":true,"merged":[[5,2,5,4],[0,1,0,4],[1,2,1,4],[2,2,2,4],[3,2,3,4],[4,2,4,4],[66,4,66,5],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[12,4,12,5],[23,4,23,5],[26,4,26,5],[28,4,28,5],[43,4,43,5],[51,4,51,5],[53,4,53,5],[68,4,68,5],[73,4,73,5],[87,4,87,5],[89,4,89,5],[93,1,93,5]]}
[null,"Aimsun Proposed Model Audit Checklist (Ver 1.1)"]
[null,"Project Information",{"$f":"IF(C4=\"\",\"\",C4)","v":""}]
[null,"Project"]
[null,"Model Name"]
[null,"Modelling Area / Corridor"]
[null,"Intersection Numbers"]
[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,"Proposed Model Checks","Modeller","Model Auditor","Location in Aimsun software","General Aimsun Model Criteria\n(also check Modelling Instruction Form for specific requirements)"]
[null,"Supply Information",{"$f":"IF((COUNTIF(Table416[Column2],\"\")+COUNTIF(Table416[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table416[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table416[Column4],\"info required\")+COUNTIF(Table416[Column4],\"TBC\")+COUNTIF(Table416[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,"Other input data","TBC","TBC"]
[null,"ROM data","TBC","TBC",null,"This may include the sub-area zone structure, sub-area matrices and zone boundaries."]
[null,"Background aerial images","TBC","TBC",null,"Aerials images used to code the network"]
[null,"Proposed modelling report","TBC","TBC"]
[null,"Background Check",{"$f":"IF((COUNTIF(Table517[Column2],\"\")+COUNTIF(Table517[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table517[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table517[Column4],\"info required\")+COUNTIF(Table517[Column4],\"TBC\")+COUNTIF(Table517[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"Background Scale provided/outlined","TBC","TBC","Image Properties Editor"]
[null,"Background Position checked","TBC","TBC","Image Properties Editor"]
[null,"Attributes",{"$f":"IF((COUNTIF(Table618[Column2],\"\")+COUNTIF(Table618[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table618[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table618[Column4],\"info required\")+COUNTIF(Table618[Column4],\"TBC\")+COUNTIF(Table618[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"Attribute overrides","TBC","TBC","Project / New / Attributes Override menu","Only present in the static or dynamic simulation model. Consultant to provide information of use of attribute and script"]
[null,"Demand Data",{"$f":"IF((COUNTIF(Table719[Column2],\"\")+COUNTIF(Table719[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table719[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table719[Column4],\"info required\")+COUNTIF(Table719[Column4],\"TBC\")+COUNTIF(Table719[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"Centroid configuration: Zones' location, connectivity and refinement confirmed","TBC","TBC","Network Window ","Centroid connection ‘Generates to’ it is drawn in blue, to extract flow ‘Attracts from’ it is drawn in green. Centroid connections should be set to the start and end of the sections"]
[null,"Centroid configuration: Missing zones justified","TBC","TBC",null,"Check all zones are cover by a centroid"]
[null,"Path assignments: Files locations and names provided","TBC","TBC","Project / Demand Data / Path Assignments","Check file location - check each project scenario using correct Path Assignment file"]
[null,"Traffic demands: Initial times and duration of the modelling period checked","TBC","TBC","Project / Demand Data / Traffic Demands","Traffic Demand Main tab"]
[null,"Traffic demands: Factors (i.e. scaling factors) applied and checked","TBC","TBC","Project / Demand Data / Traffic Demands","Traffic Demand Main tab"]
[null,"User classes checked and confirmed, if applicable","TBC","TBC","Project / Demand Data / Users Classes","Check user classes in use"]
[null,"Vehicle classes checked for each class","TBC","TBC","Project / Demand Data / Vehicles","Parameters available in OMG. Main, Dynamic Models, Microscopic Model tabs"]
[null,"Vehicle type: Vehicle parameters considered/ provided","TBC","TBC","Project / Demand Data / Vehicles","Reaction time, vehicle parameters and car following factors available in OMG. Main, Dynamic Models, Microscopic Model tabs"]
[null,"Trip purpose stated, if applicable","TBC","TBC","Project / Demand Data / Trip Purposes","Check if any in use"]
[null,"Traffic state applied, if applicable","TBC","TBC","Project / Demand Data / Traffic State","Check if any in use"]
[null,"Initial state indicated, if applicable","TBC","TBC","Project / Demand Data / Initial State","Initial simulation State, using a saved Initial State: check if used"]
[null,"Warm up period considered","TBC","TBC","Project / Scenarios / Dynamic Experiment","Initial simulation State, using warm-up. Check Traffic demand used and time"]
[null,"Macro function component checked, if applicable","TBC","TBC","Project / Demand Data / Macro Function Component","Check if any in use"]
[null,"Traffic profile included and checked, as applicable","TBC","TBC","Project / Demand Data / Traffic Profile","Check if any in use"]
[null,"Control",{"$f":"IF((COUNTIF(Table833[Column2],\"\")+COUNTIF(Table833[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table833[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table833[Column4],\"info required\")+COUNTIF(Table833[Column4],\"TBC\")+COUNTIF(Table833[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"Control plans correctly activated","TBC","TBC","Intersection Node. Edit Control Plan","Check if the correct control plans are activated on Master Control Plans and scenarios"]
[null,"Signal controller type","TBC","TBC","Intersection Node. Edit Control Plan","Type of signal operation appropriate (fixed, actuated, SCATSIM, etc.)"]
[null,"Signal operations (e.g. cycle time, phase sequence, green times, offsets, filtering movements, yellow and red times)","TBC","TBC","Intersection Node. Edit Control Plan","Check signal operations"]
[null,"Late start / early cut-off, if appropriate","TBC","TBC","Intersection Node. Edit Control Plan","Late start/ Early cut-off time to be defined as per SCATS time settings"]
[null,"Pedestrian consideration","TBC","TBC","Intersection Node. Edit Control Plan","Consider additional delays due to vehicles yielding to pedestrians"]
[null,"Use of detectors considered and checked","TBC","TBC","Intersection Node. Edit Control Plan","For actuated or SCATSIM"]
[null,"Master Control Plans setting checked and activated for each peak period","TBC","TBC","Project / Control / Master Control Plans","Check control plans activated for each peak"]
[null,"Data Analysis",{"$f":"IF((COUNTIF(Table921[Column2],\"\")+COUNTIF(Table921[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table921[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table921[Column4],\"info required\")+COUNTIF(Table921[Column4],\"TBC\")+COUNTIF(Table921[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"Real data sets aligned with the collected data","TBC","TBC","Project / Data Analysis /  Real Data Sets","Check if tables (detectors, flows) align with the collected data. Consultant to provide .txt files. "]
[null,"Infrastructure",{"$f":"IF((COUNTIF(Table1027[Column2],\"\")+COUNTIF(Table1027[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table1027[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table1027[Column4],\"info required\")+COUNTIF(Table1027[Column4],\"TBC\")+COUNTIF(Table1027[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"Network checked to ensure it accurately represents the proposed alignment (e.g. lanes, missing section links, etc.)","TBC","TBC",null,"Check background position, lane lengths, number of lanes, intersections, stop lines, merge points, intersection, reserved lanes etc."]
[null,"Section: Road type confirmed and correct","TBC","TBC","Main tab on each section. Create Drawing mode","Check section road types, maximum speed, capacity. "]
[null,"Section: Speed limit supplied and correct","TBC","TBC","Main tab on each section. Create Drawing mode"]
[null,"Banned turns considered ","TBC","TBC","Main tab on each intersection node.","Check banned turns coded correctly"]
[null,"Geometry configurations","TBC","TBC",null,"Check if it is correctly connected to network. With the geometry configuration, also check subpaths, PT lines, attribute overrides strategies and policies."]
[null,"Lane types parameters checked","TBC","TBC","Project / Infrastructure / Lane Types","Check lane types parameters"]
[null,"Road types: Lane changing added/considered and checked","TBC","TBC","Project / Infrastructure / Road Types/ Dynamic Models/ Section Parameters","Check Lane changing cooperation, aggressiveness, braking intensity, imprudent lane changing, queue discharge. Parameters available in OMG. Consultants should document if parameters have been changed"]
[null,"Road types: Turns added/considered and checked","TBC","TBC","Project / Infrastructure / Road Types/ Dynamic Models / Turn Parameters","Parameters available in OMG. Consultants should document if parameters have been changed"]
[null,"Road types: Jam density added/considered and checked","TBC","TBC","Project / Infrastructure / Road Types/ Dynamic Models/ Section Parameters","Parameters available in OMG. Consultants should document if parameters have been changed"]
[null,"Road types:  Volume delay functions (VDFs) considered and checked","TBC","TBC","Project / Infrastructure / Road Types/ Dynamic Models/ Static Model","Consultants should document if VDF's have been used"]
[null,"Turn Penalty Function and Junction Delay Function","TBC","TBC","Node / Turn / Static Model","The application of TPF and JDF should be consistent. Consultants should document if parameters have been changed"]
[null,"Subpaths: Correct sections selected","TBC","TBC","Project / Infrastructure / Subpaths","Check correct sections are selected"]
[null,"Microsimulation Areas",{"$f":"IF((COUNTIF(Table1122[Column2],\"\")+COUNTIF(Table1122[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table1122[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table1122[Column4],\"info required\")+COUNTIF(Table1122[Column4],\"TBC\")+COUNTIF(Table1122[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"Microsimulation checked to ensure it covers requested area","TBC","TBC"]
[null,"Public Transport",{"$f":"IF((COUNTIF(Table1223[Column2],\"\")+COUNTIF(Table1223[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table1223[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table1223[Column4],\"info required\")+COUNTIF(Table1223[Column4],\"TBC\")+COUNTIF(Table1223[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"Public transport lines: All routes connected and correctly aligned","TBC","TBC","Project / Public Transport / Public Transport Lines","Check all routes are connected and correctly aligned"]
[null,"Public transport lines: Stops included along route","TBC","TBC","Project / Public Transport / Public Transport Lines","Check included stops along route"]
[null,"Public transport lines: Time tables and dwell time settings checked","TBC","TBC","Project / Public Transport / Public Transport Lines","Check time tables and dwell time settings."]
[null,"Public transport plans: PT lines checked for each plan","TBC","TBC","Project / Public Transport / Public Transport Plans","Check PT lines selected for each plan"]
[null,"Scenarios",{"$f":"IF((COUNTIF(Table1324[Column2],\"\")+COUNTIF(Table1324[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table1324[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table1324[Column4],\"info required\")+COUNTIF(Table1324[Column4],\"TBC\")+COUNTIF(Table1324[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"Scenario - Set-up","TBC","TBC","Project / Scenarios / Static Assignment-Dynamic Scenario","Check selected traffic demand, public transport, path assignment and master control plan are correct."]
[null,"Scenario - Settings","TBC","TBC","Project / Scenarios / Static Assignment-Dynamic Scenario","Check Geometry Configurations selected are connected correctly."]
[null,"Experiment - Initial Simulation State reviewed","TBC","TBC","Project / Scenarios / Static Assignment-Dynamic Scenario / Experiment","Check if warm-up or Initial State has been used. Consultants should document"]
[null,"Experiment - Attribute Overrides considered and checked","TBC","TBC","Project / Scenarios / Static Assignment-Dynamic Scenario / Experiment","Check which attributes have been selected. Consultants should document."]
[null,"Experiment - Performance Settings included and checked","TBC","TBC","Project / Scenarios / Static Assignment-Dynamic Scenario / Experiment","Check Simulation Threads, Route Choice Threads.  Parameters available in OMG. Consultants should document if parameters have been changed"]
[null,"Experiment - Scripts included and checked","TBC","TBC","Project / Scenarios / Static Assignment-Dynamic Scenario / Experiment","Check if any Pre-Run or Post-Run scripts have been used. Consultants should document"]
[null,"Experiment - Behaviour reviewed","TBC","TBC","Project / Scenarios / Static Assignment-Dynamic Scenario / Experiment","Check Car Following, Lane Changing, queue Speeds.  Parameters available in OMG. Consultants should document if parameters have been changed"]
[null,"Experiment - Reaction Times reviewed","TBC","TBC","Project / Scenarios / Static Assignment-Dynamic Scenario / Experiment","Check Simulation Step and Reaction Time Settings.  Parameters available in OMG. Consultants should document if parameters have been changed"]
[null,"Experiment -  Arrivals reviewed","TBC","TBC","Project / Scenarios / Static Assignment-Dynamic Scenario / Experiment","Check if Arrivals per Origin have been added. Consultants should document"]
[null,"Experiment - Dynamic Traffic Assignment included and checked","TBC","TBC","Project / Scenarios / Static Assignment-Dynamic Scenario / Experiment","Check parameters used. Consultants should document if parameters have been changed"]
[null,"Experiment - Variables considered and applied, if appropriate","TBC","TBC","Project / Scenarios / Static Assignment-Dynamic Scenario / Experiment","Check if any variable have been used. Consultants should document"]
[null,"Experiment - Policies considered and applied, if appropriate","TBC","TBC","Project / Scenarios / Static Assignment-Dynamic Scenario / Experiment","Check what Policies if any have been used. Consultants should document"]
[null,"Replication - Seed numbers reviewed","TBC","TBC","Project / Scenarios / Static Assignment-Dynamic Scenario / Experiment / Replication","Check Seed numbers for each replication. Check if Average Replication is for relevant seeds.  Parameters available in OMG. Consultants should document if parameters have been changed"]
[null,"Scripts",{"$f":"IF((COUNTIF(Table1425[Column2],\"\")+COUNTIF(Table1425[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table1425[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table1425[Column4],\"info required\")+COUNTIF(Table1425[Column4],\"TBC\")+COUNTIF(Table1425[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"Python script checked for activated functions","TBC","TBC"]
[null,"Traffic Management",{"$f":"IF((COUNTIF(Table1526[Column2],\"\")+COUNTIF(Table1526[Column2],\"TBC\"))>0,\"TBC\",\"Checked\")","v":"TBC"},{"$f":"IF(COUNTIF(Table1526[Column4],\"fail\")>0,\"Fail\",IF(COUNTIF(Table1526[Column4],\"info required\")+COUNTIF(Table1526[Column4],\"TBC\")+COUNTIF(Table1526[Column4],\"\")>0,\"TBC\",\"Pass\"))","v":"TBC"}]
[null,"Strategies coded correctly","TBC","TBC","Project / Traffic Management / Strategies","Check if strategies are coded correctly"]
[null,"Traffic conditions coded correctly","TBC","TBC","Project / Traffic Management / Traffic Conditions","Check if traffic conditions are coded correctly"]
[null,"Triggers coded correctly","TBC","TBC","Project / Traffic Management / Triggers","Check if triggers are coded correctly"]
[null,"Other Comments"]