{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Lists","Cover Page","General","Scope of The Work","Modelling Time Period","Scenarios","Provided Data","Reports","Approvals"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":40,"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":24,"n_cols":29,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[null,"False/True checklist",null,"Y/N","Software List","Column1","Time Period","Column1","Scenarios","Reports","Data Provided","Format","Request","Modelling Level","Intersection","SIDRA Layout","Stage","Category","Calibration/Validation","Source","Signal","Traffic Assignment","Sat Flow Method","Optimisation","Vehicle","Coordination","Year","Optimisation Method","Future Demand"]
["Intersection Base",true,null,"Yes","LinSig","Included","AM","✔","Existing","Travel Time","Traffic Volume (Existing Survey)","No Preference","MRWA - Infrastructure Delivery Directorate","NA","Existing SCATS","Priority Junction","Concept","NA","NA","Applicant","Fixed-time/User Given Phase Time","NA","Survey","Cycle Time, Phase Split and Coordination","Light and Heavy","NA / Isolated Site","Base","Not Required","Application of Historical Growth"]
["Intersection Date",false,null,"No","SIDRA","Not included","PM","✖","Other","Average Speed","Traffic Volume (New Survey)","Tables","MRWA - Planning & Technical Services Directorate","Microscopic (Vissim / Aimsun)","Optimised signal with existing SCATS cycle time","Roundabout","Planning","Category 1","Model Calibration","Modeller","Actuated","Static","Survey/Factored RR67","Cycle Time and Phase Split","Class 1, Class 2-5, Class 6-9, Class 10-11 & Class 12","Fixed-time: SCATS Link Plan","YYYY - Opening Year","For PRC (LinSig)","Application of Strategic Model - Method One"]
["New Survey",false,null,"<<Other- press F2>>","Aimsun","<<Other- press F2>>","<<Other- press F2>>","<<Other- press F2>>","<<Other- press F2>>","Average Maximum Queue Length","SCATS Traffic Flows","Graphs","MRWA - Network Operations Directorate","Micro-Analytical (LinSig / SIDRA)","Optimised signal and cycle time","Signalised Roundabout","TSAP Stage 1","Category 2","Model Validation","Main Roads","SCATSIM","Dynamic","Survey/Factored Basic Sat Flow","Phase Split and Coordination","Class 1, Class 2-5, Class 6-12","Fixed-time: SCATS History File","YYYY - Opening + 5 Year","Practical Cycle Time (SIDRA)","Application of Strategic Model - Method Two"]
["SIDRA Scen",false,null,null,"Vissim",null,null,null,null,"95th-Percentile Queue","VDS Traffic Flows","Text","Public Transport Authority","<<Other- press F2>>","Tactical","Signals","TSAP Stage 2","Category 3","Calibration/Validation","Public Transport Authority","Optimised","<<Other- press F2>>","RR67","Phase Split Only","Class 1, Class 2-5, Class 6-9, Class 10-11 & Class 12 + Bus","Fixed-time: As Per Base","YYYY - Opening + 10 Year","For Delay (LinSig)","Application of Strategic Model - Method Three"]
["NewSurvey-SIDRA",true,null,null,"LinSig - Signal optimisation only",null,null,null,null,"Average Delay","Modelled Traffic Volume","Spreadsheet","METRONET",null,"Other (to be explained)","<<Other- press F2>>","Feasibility Assessment",null,"<<Other- press F2>>","TrafficMap","Fixed-time & Optimised",null,"Same as Base ","Not Required","Class 1, Class 2-5, Class 6-12 + Bus","Optimised","<<Other- press F2>>","Optimum Cycle Time (SIDRA)","Application of Strategic Model - As described"]
["Warm-up",true,null,null,"SIDRA - Signal optimisation only",null,null,null,null,"Density","New Development Traffic Flows","Map","Local Government Authority <<Press F2 to specify>>",null,"<<Other- press F2>>",null,"Intersection Layout Analysis",null,null,"SCATS Request form","<<Other- press F2>>",null,"<<Other- press F2>>","<<Other- press F2>>","<<Other- press F2>>","<<Other- press F2>>",null,"Manual ","Application of Mesoscopic Model"]
["AM peak hour(s)",true,null,null,"<<Other- press F2>>",null,null,null,null,"DoS (%)","SCATS History File","Plot","<<Other- press F2>>",null,null,null,"<<Other- press F2>>",null,null,"Internet",null,null,null,null,null,null,null,"Micro-analytical Model & Manual","Application of Fixed Growth Rate"]
["PM peak hour(s)",true,null,null,null,null,null,null,null,"LoS","SCATS History Events File","<<Other- press F2>>",null,null,null,null,null,null,null,"<<Other- press F2>>",null,null,null,null,null,null,null,"<<Other- press F2>>","Manual Land Use Trip Calculations"]
["Weekend Peak Hour/s",false,null,null,null,null,null,null,null,"PRC (%)","SCATS Controller Setting (TrafficMap)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TBC"]
["Other (specify below)",false,null,null,null,null,null,null,null,"Modified/New Cycle Time","New Signal Settings (Appendix A)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<<Other- press F2>>"]
["Cool-down",true,null,null,null,null,null,null,null,"Modified/New Phase Sequence ","Strategic Monitors"]
["Existing Base",true,null,null,null,null,null,null,null,"Animation Video","Pedestrian Volume Survey"]
[null,null,null,null,null,null,null,null,null,"LinSig Model Summary Spreadsheet","Queue Survey"]
[null,null,null,null,null,null,null,null,null,"Model Audit Checklist ","Saturation Flows Survey"]
[null,null,null,null,null,null,null,null,null,"Report","Observed Travel Time"]
[null,null,null,null,null,null,null,null,null,"Traffic Signal Approval Report","Strategic Model (e.g. ROM24)"]
[null,null,null,null,null,null,null,null,null,"<<Other- press F2>>","Development Land Use data"]
[null,null,null,null,null,null,null,null,null,null,"Available Existing Model"]
[null,null,null,null,null,null,null,null,null,null,"Design Drawings"]
[null,null,null,null,null,null,null,null,null,null,"Public Transport Plan"]
[null,null,null,null,null,null,null,null,null,null,"Public Transport Dwell Times"]
[null,null,null,null,null,null,null,null,null,null,"Site Observation"]
[null,null,null,null,null,null,null,null,null,null,"<<Other- press F2>>"]

{"sheet":"Cover Page","index":1,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[[15,3,15,14],[17,3,17,14],[19,3,19,14],[21,3,21,14],[9,3,9,14],[13,3,13,14],[11,8,11,9],[23,3,23,17]]}
[]
[]
[null,null,null,"Traffic Modelling Instruction Form"]
[]
[]
[]
[]
[]
[null,null,null,"TIPS"]
[null,null,null,"•   To navigate the Traffic Modelling Instruction Form use the provided buttons."]
[]
[null,null,null,"•   To create PDF file use the 'Print Form' button.",null,null,null,null,"Print Form"]
[]
[null,null,null,"•   If required, the items in the drop down lists can be updated with free text. Press F2 to modify the text."]
[]
[null,null,null,"•   To add a line break within a text box, press ALT+ENTER"]
[]
[null,null,null,"•   To add a bullet point within a text box, press ALT+7 (•) or ALT+9 (○)sing the numeric keypad on your keyboard."]
[]
[null,null,null,"•   To add additional bullet point within the same text box, press ALT+ENTER to add a line break within the text box, and then repeat\n     the ALT+7 or ALT+9 key combination."]
[]
[null,null,null,"•   As required, adjust the font size to fit the text within the box."]
[]
[null,null,null,"•   Additional information can be provided as an attachment to the form when submitting.\n  "]

{"sheet":"General","index":2,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[[38,6,38,14],[35,6,35,14],[22,6,22,8],[18,6,18,14],[24,6,33,14],[22,12,22,14],[20,6,20,14],[16,6,16,14],[3,2,3,14],[6,6,6,14],[8,6,8,14],[10,6,10,14],[12,6,12,14],[14,6,14,14]]}
["General","Inputs"]
["Model Requirements","Outputs",null,null,null,null,"Traffic Modelling Instruction Form",null,null,null,null,null,{"$f":"COUNTIF(B:B,\"Scenarios\")","v":0}]
["Demand","Approval",null,null,null,null,{"$f":"IF(General!G7=\"\",\"\",General!G7)","v":""}]
["Scenarios",null,"General"]
[]
[]
[null,null,"Title of The Project"]
[]
[null,null,"Stage"]
[]
[null,null,"Applicant"]
[]
[null,null,"Applicant Organisation"]
[]
[null,null,"Application's Reference Number"]
[]
[null,null,"Modeller (if known)"]
[]
[null,null,"Auditing Process Coordinator (APC)"]
[]
[null,null,"APC's Reference Number"]
[]
[null,null,"Modelling Level",null,null,null,null,null,null,null,"Secondary Model"]
[]
[null,null,"Modelling Objectives"]
[null,null,null," - purpose of the modelling;"]
[null,null,null," - who if it for;"]
[null,null,null," - and, …"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Study Area"]
[null,null,"(i.e. Corridor, Intersection/s etc.)"]
[]
[null,null,"TCS number(s) (if applicable)"]
[0]

{"sheet":"Scope of The Work","index":3,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,5,70,14],[8,12,8,14],[3,2,3,14],[6,5,6,7],[8,5,8,9],[6,11,6,12]]}
["General","Inputs"]
["Model Requirements","Outputs",null,null,null,null,"Traffic Modelling Instruction Form",null,null,null,null,null,{"$f":"COUNTIF(B:B,\"Scenarios\")","v":0}]
["Demand","Approval",null,null,null,null,{"$f":"IF(General!G7=\"\",\"\",General!G7)","v":""}]
["Scenarios",null,"General Modelling Requirements"]
[{"$f":"COUNTIF(B:B,\"=Software\")","v":1}]
[]
[null,{"$f":"LEFT(C7,8)","v":"Software"},"Software 1",null,null,null,null,null,null,null,"Software Version"]
[]
[null,null,null,"Vehicle Classifications",null,null,null,null,null,null,null,{"$f":"IF(OR(F7=Lists!$E$4,F7=Lists!$E$5),\"Traffic Assignment\",IF(OR(F7=Lists!$E$2,F7=Lists!$E$3,F7=Lists!$E$6,F7=Lists!$E$7),\"Sat Flow Method\",\"\"))","v":""}]
[]
[]
[null,null,"Additional Notes"]

{"sheet":"Modelling Time Period","index":4,"n_rows":34,"n_cols":20,"rows_kept":34,"cut":false,"hidden":false,"merged":[[34,3,47,14],[29,2,29,14],[31,9,31,13],[3,2,3,14],[5,3,5,7],[6,11,8,13],[22,3,27,14],[4,2,4,14]]}
["General","Inputs"]
["Model Requirements","Outputs",null,null,null,null,"Traffic Modelling Instruction Form"]
["Demand","Approval",null,null,null,null,{"$f":"IF(General!G7=\"\",\"\",General!G7)","v":""},null,null,null,null,null,{"$f":"COUNTIF(B:B,\"Scenarios\")","v":0},null,null,null,null,null,null,{"$f":"COUNTIF(G:G,\"Scenarios\")","v":0}]
["Scenarios",null,"Modelling Traffic Demand"]
[null,null,"Modelling Time Period"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Traffic demand profile interval / peak flow period (minutes)"]
[null,null,null,null,null,null,null,null,null,"Duration (Minutes)"]
[]
[null,null,null,null,null,null,"Warm-up (micro/meso models only)"]
[]
[null,null,null,null,null,null,"AM peak hour(s)"]
[]
[null,null,null,null,null,null,"PM peak hour(s)"]
[]
[null,null,null,null,null,null,"Weekend Peak Hour/s"]
[]
[null,null,null,null,null,null,"Other"]
[]
[null,null,null,null,null,null,"Cool-down"]
[null,null,null,null,null,null,"(micro/meso models only)"]
[null,null,null,"Additional information"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Future Modelling Demand"]
[]
[null,null,null,"Future Traffic Demand Calculations Methodology"]
[]
[null,null,null,"Descriptions"]

{"sheet":"Scenarios","index":5,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[[3,2,3,13],[12,11,12,13],[17,9,17,10],[14,4,14,5],[14,9,14,10],[15,9,15,10],[16,9,16,10],[4,2,4,13],[6,8,6,9],[10,4,10,7],[10,11,10,13],[8,4,8,5],[8,11,8,12],[17,4,17,5],[12,4,12,7],[15,4,15,5],[20,9,20,10],[18,9,18,10],[19,9,19,10],[40,11,40,13],[24,4,30,11],[22,4,22,5],[36,9,36,11],[15,3,22,3],[21,9,21,10],[22,6,22,8],[21,11,21,13],[42,4,48,11],[34,4,34,11],[36,4,36,6],[38,4,38,7],[38,11,38,13],[16,4,16,5],[40,4,40,7],[18,4,18,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[32,2,32,13]]}
["General","Inputs"]
["Model Requirements","Outputs",null,null,null,null,"Traffic Modelling Instruction Form"]
["Demand","Approval",null,null,null,null,{"$f":"IF(General!G7=\"\",\"\",General!G7)","v":""}]
["Scenarios",null,"Modelling Scenarios"]
[{"$f":"COUNTIF(B:B,\"Scenario\")","v":1},null,"Base Model"]
[]
[null,null,null,"Base Model",null,null,null,"Date of the Base Model "]
[]
[null,null,null,"Model Category",null,null,null,null,null,null,"Operational Modelling Guidelines Version","Version 2.0"]
[]
[null,null,null,"Signal Phase Lengths",null,null,null,null,null,null,"Signal Coordination"]
[]
[null,null,null,"Signal Optimisation",null,null,null,null,null,null,"Optimisation Method"]
[]
[null,null,null,null,"Vissim/Aimsun",null,null,null,null,"LinSig/SIDRA"]
[null,null,null,"Model Calibration / Validation",null,null,"Traffic Volume (Turns & Links)",null,null,null,null,"Traffic Volume (Turns & Links)"]
[null,null,null,null,null,null,"Travel Time ",null,null,null,null,"Travel Time "]
[null,null,null,null,null,null,"Queue Length",null,null,null,null,"Queue Length"]
[null,null,null,null,null,null,"Degree of Saturation",null,null,null,null,"Degree of Saturation"]
[null,null,null,null,null,null,"Saturation flow",null,null,null,null,"Saturation flow"]
[null,null,null,null,null,null,"Signal Timing",null,null,null,null,"Signal Timing"]
[null,null,null,null,null,null,"Vehicle Speed Map",null,null,null,null,"<<Other- define here>>"]
[null,null,null,null,null,null,"<<Other- define here>>"]
[]
[null,null,null,"Additional Information"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Modelling Scenarios"]
[]
[null,{"$f":"LEFT(D35,8)","v":"Scenario"},null,"Scenario 1 "]
[]
[null,null,null,"Year",null,null,null,null,"Sat Flow Method"]
[]
[null,null,null,"Signal Phase Lengths",null,null,null,null,null,null,"Signal Coordination"]
[]
[null,null,null,"Signal Optimisation",null,null,null,null,null,null,"Optimisation Method"]
[]
[null,null,null,"Additional Information"]

{"sheet":"Provided Data","index":6,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[4,3,5,7],[6,5,6,6],[6,7,6,14],[3,2,3,14],[7,2,8,2],[7,3,8,4],[6,3,6,4],[7,7,8,14],[7,5,8,6]]}
["General","Inputs"]
["Model Requirements","Outputs",null,null,null,null,"Traffic Modelling Instruction Form"]
["Demand","Approval",null,null,null,null,{"$f":"IF(General!G7=\"\",\"\",General!G7)","v":""}]
["Scenarios",null,"Input Data"]
[{"$f":"COUNTIF(B:B,\"Inp\")","v":1},null,null,"All input data to be requested by the Modeller"]
[]
[null,null,null,"Input",null,"Source",null,"Description"]
[null,{"$f":"LEFT(C8,3)","v":"Inp"},"Input 1"]

{"sheet":"Reports","index":7,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[3,2,3,14],[6,3,6,4],[7,2,8,2],[7,3,8,4],[7,7,8,14],[7,5,8,6],[6,5,6,6],[6,7,6,14]]}
["General","Inputs"]
["Model Requirements","Outputs",null,null,null,null,"Traffic Modelling Instruction Form"]
["Demand","Approval",null,null,null,null,{"$f":"IF(General!G7=\"\",\"\",General!G7)","v":""}]
["Scenarios",null,"Outputs & Deliverables"]
[{"$f":"COUNTIF(B:B,\"out\")","v":1}]
[]
[null,null,null,"Outputs & Deliverables",null,"Format",null,"Description"]
[null,{"$f":"LEFT(C8,3)","v":"Out"},"Output 1"]

{"sheet":"Approvals","index":8,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,5,20,6],[3,3,3,14],[6,5,6,8],[10,5,10,6],[6,11,6,14],[16,5,16,8],[16,11,16,14],[8,5,8,7],[18,5,18,7]]}
["General","Inputs"]
["Model Requirements","Outputs",null,null,null,null,"Traffic Modelling Instruction Form"]
["Demand","Approval",null,null,null,null,{"$f":"IF(General!G7=\"\",\"\",General!G7)","v":""}]
["Scenarios",null,null,"Approvals"]
[]
[]
[null,null,null,null,"Applicant",null,null,null,null,null,"Title"]
[]
[null,null,null,null,"Contact details",null,null,null,null,null,"Signature"]
[]
[null,null,null,null,"Date"]
[]
[]
[]
[]
[]
[null,null,null,"Auditing Process Coordinator",null,null,null,null,null,null,"Title"]
[]
[null,null,null,null,"Contact details",null,null,null,null,null,"Signature"]
[]
[null,null,null,null,"Date"]