{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["SCR Form","Company List","Reference List"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"SCR Form","index":0,"n_rows":58,"n_cols":17,"rows_kept":58,"cut":false,"hidden":false,"merged":[[39,13,40,14],[41,15,41,16],[41,13,43,14],[0,0,0,10],[2,0,2,5],[2,7,2,12],[3,0,3,1],[3,2,3,5],[3,7,3,8],[3,9,3,12],[25,9,25,11],[4,0,4,1],[4,2,4,5],[4,7,4,8],[4,9,4,12],[5,0,5,1],[5,2,5,3],[5,7,5,8],[5,9,5,10],[5,11,5,12],[17,0,17,5],[6,0,6,1],[6,2,6,5],[6,7,6,8],[6,9,6,12],[8,0,8,2],[8,7,8,9],[21,7,21,12],[23,0,23,5],[23,8,23,11],[24,8,24,11],[22,8,22,11],[26,8,26,11],[38,0,39,3],[27,8,27,11],[28,8,28,11],[29,8,29,11],[31,7,31,12],[32,7,33,12],[26,0,26,5],[38,6,38,10],[39,6,39,10],[40,0,43,12],[57,0,58,12],[53,0,53,1],[53,2,53,5],[53,7,53,8],[53,9,53,12],[54,0,54,1],[54,2,54,3],[54,7,54,8],[54,9,54,10],[45,0,45,3],[45,6,45,12],[55,0,55,1],[55,2,55,5],[55,7,55,8],[55,9,55,12],[46,0,49,12],[51,0,51,5],[52,0,52,1],[52,2,52,5],[52,7,52,8],[52,9,52,11],[51,7,51,8],[51,9,51,12],[16,15,16,16],[19,15,19,16],[28,15,29,15],[28,16,29,16],[20,15,23,16],[35,15,38,16],[36,7,36,8],[36,10,36,12],[30,15,31,16],[34,15,34,16],[34,7,34,12],[35,7,35,9],[35,10,35,12],[30,7,30,12]]}
["TTM SITE CONDITION RATING FORM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V27"]
[]
["SITE DETAILS",null,null,null,null,null,null,"OPERATION DETAILS"]
["Road Name",null,null,null,null,null,null,"Activity Description"]
["Suburb",null,null,null,null,null,null,"TTM Method"]
["CAR Number",null,null,null,"TTM Level",null,null,"Contractor",null,null,null,"MAIN"]
["Date/Time",null,null,null,null,null,null,"Client / Principal"]
[]
["SIGNS",null,null,"Weighting","Tally Box","Total",null,"MISCELLANEOUS",null,null,"Weighting","Tally Box","Total"]
["A1","Missing (including side road)","Sign",5,null,{"$f":"E10*D10","v":0},null,"E1","Working in Live lanes","Individual",20,null,{"$f":"L10*K10","v":0}]
["A2","Position","Sign",2,null,0,null,"E2","Missing traffic controller","Individual",20,null,0]
["A3","Not visible/Fallen Over","Sign",5,null,0,null,"E3","Safety zone compromised","Individual",10,null,0]
["A4","Wrong sign","Sign",5,null,0,null,"E4","High visibility garment not acceptable","Individual",5,null,0]
["A5","Condition unacceptable","Sign",4,null,0,null,"E5","Marginal surface condition (carriageway only)","Occasion",15,null,0]
["A6","Permanent sign","Sign",5,null,0,null,"E6","Unacceptable surface condition (peds, cyclists or carriageway)","Occasion",30,null,0]
["A7","Unapproved sign used / too small","Sign",4,null,0,null,"E7","Barrier defects (Missing or Incorrect components)","Component",10,null,0,null,null,"TOTAL SCR",{"$f":"SUM(F10:F17,F19:F23,F25:F26,F28:F37,M10:M21)","v":0}]
["A8","Non-compliant support / sign too low","Support",2,null,0,null,"E8","Unsafe or Redundant TTM","Equipment",5,null,0,null,null,"Note that this score does not appear on the final printout"]
["MOBILE & SEMI STATIC",null,null,null,null,null,null,"E9","VMS message incorrect or Inappropriate","AWVMS or Arrowboard",15,null,0]
["B1","Tail pilot vehicle / AWVMS omitted or incorrect location","Vehicle",30,null,{"$f":"E19*D19","v":0},null,"E10","Flashing beacons / hazard lights not used or ineffective","Vehicle",3,null,0]
["B2","Lead pilot vehicle omitted or incorrect location","Vehicle",20,null,{"$f":"E20*D20","v":0},null,"E11","Parking / stopping features not relocated","Feature",5,null,0,null,null,"SCR OVERRIDE"]
["B3","Shadow Vehicle omitted or incorrect location","Vehicle",20,null,{"$f":"E21*D21","v":0},null,"E12","Unsafe and illegal parking of plant/equip.","Feature",20,null,0,null,null,"This function can only be used if certain criteria below are not met (and only if required):"]
["B4","TMA missing or non compliant","TMA",20,null,{"$f":"E22*D22","v":0},null,"OTHER CHECKS"]
["B5","AWVMS/Arrow Board non compliant","Vehicle",26,null,{"$f":"E23*D23","v":0},null,"G1","QUALIFIED PERSON ON SITE  [REFER TO A5 OF COPTTM]"]
["PEDESTRIANS / CYCLISTS ",null,null,null,null,null,null,"G2","TSL APPROPRIATE [REFER TO C4 OF COPTTM]"]
["C1","Inadequate provision for pedestrians","Feature",10,null,{"$f":"D25*E25","v":0},null,"G3","ROAD USER FLOW ACCEPTABLE",null,null,null,null,null,null,"Any single SCR column with a weighting of 20 or over is blank?",{"$f":"IF(SUM(E19:E22)+E28+E36+L15+L21+L11+L10>0,\"N\",\"Y\")","v":"Y"}]
["C2","Inadequate provision for cyclists","Feature",10,null,{"$f":"D26*E26","v":0},null,"G4","ON-SITE RECORD","[FORM MUST INCLUDE STMS AUTHORITY, 2 HOURLY CHECKS AND TSL IMPLEMENTATION]",null,null,null,null,null,"The site passes all areas of Other Checks? [NOT G4]",{"$f":"IF(OR(M23=\"N\",M24=\"N\",M25=\"N\",M27=\"N\",M28=\"N\",M29=\"N\",M30=\"N\"),\"N\",\"Y\")","v":"Y"}]
["DELINEATION",null,null,null,null,null,null,"G5","TMP APPROVED?",null,null,null,null,null,null,"The SCR does not exceed 150 points?",{"$f":"IF(Q16>150,\"N\",\"Y\")","v":"Y"}]
["D1","Missing or ineffective Taper","Leading Taper",26,null,{"$f":"D28*E28","v":0},null,"G6","APPROVED TMP SIGHTED?",null,null,null,null,null,null,"Could the SCR Change?",{"$f":"IF(AND(Q16>50,OR(M40=\"N\",Q25=\"N\", Q26=\"N\",Q27=\"N\")),\"Y\",IF(OR(M40=\"SELECT ONE\",M40=\"\"),\"PLEASE COMPLETE OVERRIDE CHECKS\",\"N\"))","v":"PLEASE COMPLETE OVERRIDE CHECKS"}]
["D2","Tapers too short","Leading Taper",15,null,{"$f":"D29*E29","v":0},null,"G7","APPROVED TMP APPLICABLE?",null,null,null,null,null,null,"IS THE OVERRIDE REQUIRED?",{"$f":"IF(AND(M40=\"N\",Q28=\"Y\",Q16>50),\"Y\",IF(OR(M40=\"SELECT ONE\",M40=\"\"),\"PLEASE COMPLETE OVERRIDE CHECKS IF REQUIRED\",\"N\"))","v":"PLEASE COMPLETE OVERRIDE CHECKS IF REQUIRED"}]
["D3","Taper too short or missing","Trailing Taper",5,null,{"$f":"D30*E30","v":0},null,"G8","TTM IN ACCORDANCE WITH APPROVED TMP?"]
["D4","Spacing in taper","Taper",5,null,{"$f":"D31*E31","v":0},null,{"$f":"IF(OR(L39=\"N\",K37=\"AT AUDITOR\",H33=\"DANGEROUS\",H33=\"UNACCEPTABLE (MULTIPLE ISSUES)\",H33=\"UNACCEPTABLE (>50)\",H33=\"UNACCEPTABLE (OTHER)\"),\"AS A RESULT OF THE FINDINGS OF THIS REVIEW, ADDITIONAL FEES ARE PAYABLE TO AUCKLAND TRANSPORT. PLEASE DISCUSS WITH ADVISOR IF ANY ISSUES\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(Q29=\"N\",\"THIS SCR CANNOT BE OVERRIDEN AND THE EXISTING RESULT MUST REMAIN\",\" \")","v":" "}]
["D5","Spacing in Lanes","Per 100m Delineation",3,null,{"$f":"D32*E32","v":0},null,"FINAL RESULT"]
["D6","Missing or Ineffective delineation along lanes","Delineation Section",10,null,{"$f":"D33*E33","v":0},null,{"$f":"IF(Q29=\"Y\",\"DANGEROUS\",IF(AND(B38=\"UNACCEPTABLE (>50)\",E38=\"UNACCEPTABLE (OTHER)\"),\"UNACCEPTABLE (MULTIPLE ISSUES)\",IF(E38=\"UNACCEPTABLE (OTHER)\",E38,B38)))","v":"HIGH STANDARD (≤10)"},null,null,null,null,null,null,null,null," "]
["D7","Condition unacceptable","Device",2,null,0]
["D8","Using non-approved device","Device",4,null,0,null,{"$f":"IF((H33=\"DANGEROUS\"),\"THIS SITE HAS SAFETY ISSUES WHICH REQUIRE IMMEDIATE ACTION\",\" \")","v":" "},null,null,null,null,null,null,null,{"$f":"IF(P36=\"\",\"\",\"ADVISOR NOTE\")","v":""}]
["D9","Road marking incorrect at Long Term Level 2 or 3 roads","Site",30,null,0,null,"ACTIONS PLANNED BY STMS",null,null,"SITE ACTIVITY CEASED BY",null,null,null,null,{"$f":"IF(AND(K45=\"\",L45=\"\"),M45,IF(AND(L45=\"\",M45=\"\"),K45,(IF(AND(M45=\"\",K45=\"\"),L45,\"\"))))","v":""}]
["D10","Inadequate Site Access","Access",10,null,0,null,"FIX SITE?"]
[null,{"$f":"IF(Q16<=10, \"HIGH STANDARD (≤10)\",IF(AND(Q16>10,Q16<26),\"ACCEPTABLE (11-25)\",IF(AND(Q16>25,Q16<51),\"NEEDS IMPROVEMENT (26-50)\",IF(Q16>50,\"UNACCEPTABLE (>50)\",\"\"))))","v":"HIGH STANDARD (≤10)"},null,null,{"$f":"IF(OR(M23=\"N\",M24=\"N\",M25=\"N\",M26=\"N\",M27=\"N\",M28=\"N\",M29=\"N\",M30=\"N\"), \"UNACCEPTABLE (OTHER)\",\" \")","v":" "}]
["KEY POINTS",null,null,null,"SITE ACTIVITY STATUS",null,"NOTIFICATIONS (AT/ATOC/PT) [DOES NOT AFFECT SCORE]",null,null,null,null,null,"SITE SAFE?"]
[null,null,null,null,"PLANNED / UNPLANNED?",null,"SITE INDUCTION GOOD? [DOES NOT AFFECT SCORE]",null,null,null,null,null,null,{"$f":"IF(OR(P36=\"ISSUE STOP WORKS NOTICE IMMEDIATELY\",K37=\"AT AUDITOR\",),\"è\",\"\")","v":""},null,{"$f":"IF(N42=\"\",\"\",\"Stop Works Order Required?\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N42=\"\",\"\",\"Who gave you advice on this?\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(P36=\"ISSUE STOP WORKS NOTICE IMMEDIATELY\",K37=\"AT AUDITOR\",),\"ENTER INFO FOR STOP WORKS ORDER\",\"\")","v":""},null,{"$f":"IF(N42=\"\",\"\",\"ENTER TIME BELOW USING AM/PM FORMAT (EXAMPLE: 12.15PM)\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N42=\"\",\"\",\"Time Stop Works Order Issued?\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N42=\"\",\"\",\"Time Uplifted? (If Applicable)\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(H33=\"UNACCEPTABLE (OTHER)\",J37=\"NO\",L45=\"\"),\"STOP WORKS ORDER COULD BE CONSIDERED FOR THIS SITE - SEEK ADVICE FIRST\",\"\")","v":""},{"$f":"IF(OR(M23=\"N\",M24=\"N\",M25=\"N\",M27=\"N\",M28=\"N\",M29=\"N\",M30=\"N\"),\"\",IF(M26=\"N\",\"THIS SITE MAY CONTINUE PROVIDED STMS FILLS OUT DAILY SITE RECORD ASAP\",\"\"))","v":""},{"$f":"IF(OR(H33=\"DANGEROUS\",AND(OR(H33=\"UNACCEPTABLE (>50)\",H33=\"UNACCEPTABLE (MULTIPLE ISSUES)\"),J37=\"NO\")),\"ISSUE STOP WORKS ORDER IMMEDIATELY\",\"\")","v":""},{"$f":"IF(AND(Q40=\"YES\",N40=\"è\"),\"STOP WORKS ORDER ISSUED AT \",\"\")","v":""}]
["ACTIONS TO BE TAKEN",null,null,null,null,null,{"$f":"IF(H33=\"UNACCEPTABLE (MULTIPLE ISSUES)\",\"YOUR SITE REQUIRES URGENT RECTIFICATION\",\" \")","v":" "}]
[]
[]
[]
[]
[]
["REVIEWED BY",null,null,null,null,null,null,"STMS DETAILS",null,{"$f":"CONCATENATE(N45,Q43)","v":""}]
["Signature",null,null,null,null,null,null,"RECEIVED BY / SIGNED",null,null,null,null,"SCR LEFT ONSITE?"]
["Reviewer Name",null,null,null,null,null,null,"STMS Name"]
["Qualifications",null,null,null,"NZTA ID No.",null,null,"Qualifications",null,null,null,"NZTA ID No."]
["Reviewer Contact Details",null,null,null,null,null,null,"STMS Contact Details"]
[]
["In submitting this form, the reviewer specified above agrees that they have explained the significant issues and proposed remedies to the relevant parties specified above and have handed these parties a physical copy of the audit (does not apply for unattended sites)."]

{"sheet":"Company List","index":1,"n_rows":85,"n_cols":3,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
["Standard Organisation Names"]
[]
["(STMS / TTM employer)","(Note this is to be the main contractor)","(Private for non company principals)"]
["TTM Companies","Contractors","Principals"]
["Absolute Traffic Solutions Ltd","Asplundh","Auckland Council"]
["AKL Traffic Ltd","Auckland Council","Auckland Transport"]
["Arrow International (NZ) Ltd","Bassett Plumbing & Drainage Ltd","Chorus"]
["Asplundh","Brian James Contracting Ltd","Counties Power Ltd"]
["Auckland Council","Canadian Pacific Ltd","Housing NZ / Creating Communities Ltd"]
["Auckland Motorway Alliance","City Care Ltd","KiwiRail"]
["Beesafe Traffic Control Ltd","City Contractors Ltd","NZTA"]
["Bryce Traffic Solutions Ltd","CMP Construction Ltd","Pānuku Development Auckland"]
["Camhut Ltd","Community Asset Management NZ Ltd","Phantom Bill Stickers Ltd"]
["CEW Ltd","Counties Power Ltd","Private"]
["Chevron Traffic Solutions Ltd","DDS Ltd","Rose Gardens Apartments"]
["Chicane Traffic Ltd","Dempsey Wood Traffic Ltd","Transpower"]
["City Care Ltd","Downer EDI Ltd","Unknown"]
["City Contractors Ltd","Drill Tech (Holdings) Ltd","Vector Gas"]
["Coast Line","Electrix Ltd","Vector Power"]
["Community Asset Management NZ Ltd","Event","Vodafone"]
["Counties Power Ltd","Fletcher Construction Company Ltd","WaterCare Services Ltd"]
["DDS Ltd","Flowerday Enterprises Ltd"]
["Dempsey Wood Traffic Ltd","Fulton Hogan Ltd"]
["Direction NZ","GB Civil & Roading Contractors Ltd"]
["DK Signs Ltd","Hawkins Construction"]
["Downer EDI Ltd","HEB Contractors Ltd"]
["Drill Tech (Holdings) Ltd","Hick Bros Civil Ltd"]
["Earthco Civil Ltd","Higgins Contractors Ltd"]
["Electrix Ltd","Hiway Stabilizers Ltd"]
["Evolution Road Services Group","Infrastructure & Civilworks Ltd"]
["Flowerday Enterprises Ltd","J&R Civil"]
["Fulton Hogan Ltd","JB Civil"]
["GB Civil & Roading Contractors Ltd","JCW Construction Ltd"]
["GNC Traffic Ltd","Jet Trac Drilling Ltd"]
["Gorrie Traffic Management Ltd","John Fillmore Contracting Ltd"]
["HEB Contractors Ltd","K.C. Wong Ltd"]
["Higgins Contractors Ltd","Liveable Streets"]
["Hiway Stabilizers Ltd","MacKenzie Civil Ltd"]
["Home Fibre Soultions","Maka Civil Contracting Ltd"]
["Independent Traffic Control Ltd","Mc Kenzie & Parma Ltd"]
["Infrastructure & Civilworks Ltd","McConnell Dowell"]
["ISS Ltd","Naylor Contracting Ltd"]
["J&R Civil","North Harbour Paving And Construction Ltd"]
["JB Civil","Northpower Ltd"]
["JCW Construction Ltd","NZ Bore Ltd"]
["Jet Trac Drilling Ltd","OT Contractors Ltd"]
["John Fillmore Contracting Ltd","Phantom Bill Stickers Ltd"]
["K.C. Wong Ltd","Pipeline Civil"]
["Kirby","Scott Thrust Ltd"]
["Liveable Streets","Streetworx Ltd"]
["Maka Civil Contracting Ltd","TEBO Services Ltd"]
["Marchcato","Total Infrastructure Ltd"]
["Mc Kenzie & Parma Ltd","Traffic Systems Ltd"]
["McConnell Dowell","Transfield Services (New Zealand) Ltd"]
["Naylor Contracting Ltd","Tree Scape Ltd"]
["None","Unknown"]
["North Harbour Paving And Construction Ltd","Visionstream Pty Ltd"]
["Northpower Ltd","Watercare Services Ltd"]
["NZ Bore Ltd","Watts & Hughes Ltd"]
["OT Contractors Ltd"]
["Outsource Communications Ltd"]
["Phantom Bill Stickers Ltd"]
["Pipeline Civil"]
["Pro-tect (Auck) Ltd"]
["Rec Services"]
["Reliable Traffic Control"]
["Rixon Contracting Ltd"]
["Scott Thrust Ltd"]
["Sen Ventures"]
["Smiths Underground Services Pty"]
["Stockman General"]
["Streetworx Ltd"]
["T8 Traffic Control Ltd"]
["TEBO Services Ltd"]
["Tiger Traffic Ltd"]
["Total Infrastructure Ltd"]
["Traffic Management NZ Ltd"]
["Traffic Systems Ltd"]
["Traffix Ltd"]
["Transfield Services (New Zealand) Ltd"]
["Tree Scape Ltd"]
["Unknown"]
["Visionstream Pty Ltd"]
["Watercare Services Ltd"]
["Watts & Hughes Ltd"]

{"sheet":"Reference List","index":2,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["YES",0,"Planned","Not Required","Y","Berm Closure",null,"Attended","Planned"]
["NO",5,"Unplanned","STMS","N","Bus/Transit Lane Closure",null,"Unattended","Unplanned"]
["N/A",null,null,"AT Auditor","N/A","Contraflow"]
[null,null,null,"Non-STMS",null,"Cycle Lane Closure"]
[null,null,null,"SITE DID NOT CEASE",null,"Footpath Closure"]
[null,null,null,null,null,"Inspection"]
[null,null,null,null,null,"Lane Closure"]
[null,null,null,null,null,"Lane Shift"]
[null,null,null,null,null,"Mobile Closure"]
[null,null,null,null,null,"Nothing"]
[null,null,null,null,null,"Partial Road Closure"]
[null,null,null,null,null,"Pilot Vehicle Static"]
[null,null,null,null,null,"Priority Control"]
[null,null,null,null,null,"Road Closure"]
[null,null,null,null,null,"Semi-Static Closure"]
[null,null,null,null,null,"Shoulder Closure"]
[null,null,null,null,null,"Special Mobile"]
[null,null,null,null,null,"Stop/Go"]
[null,null,null,null,null,"Temporary Signals"]
[null,null,null,null,null,"TSL"]
[null,null,null,null,null,"Warning Only"]