{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Disclaimer","General Instructions","FIG1","FIG2","FIG3","FIG4","FIG5","FIG6","FIG7","FIG8"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"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":"Disclaimer","index":0,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[12,2,16,10],[18,2,19,10],[2,2,9,10]]}
[]
[]
[null,null,"Whilst efforts have been made to ensure the accuracy of the information contained in this spreadsheet, the content is subject to change and TRL Limited, the UK Foreign, Commonwealth & Development Office (FCDO), and DT Global, and their affiliated organisations cannot guarantee its accuracy or currency. The right is reserved to make changes to the contents without notice.  TRL Limited, the UK Foreign, Commonwealth & Development Office (FCDO), and DT Global, and their affiliated organisations  do not accept any liability for any direct, indirect, incidental or consequential losses arising from the the use of this tool. By using this tool, you are deemed to have consented to these conditions."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"This spreadsheet was designed and programmed by Andrew Otto and checked by Warsame Mohamed. For queries please email aotto@trl.co.uk or enquiries@trl.co.uk"]

{"sheet":"General Instructions","index":1,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[18,2,18,6],[13,2,13,6],[14,2,14,6],[15,2,15,6],[16,2,16,6],[17,2,17,6]]}
[]
[]
[null,null,"Defect observed","Go to Tab"]
[null,null,"Rutting without shoving"]
[null,null,"Rutting with shoving"]
[null,null,"Wheelpath cracking in asphalt surfacing"]
[null,null,"Wheelpath cracking in thin bituminous seal"]
[null,null,"Non-wheelpath cracking in asphalt surfacing"]
[null,null,"Longitudinal cracking in asphalt surfacing"]
[null,null,"Transverse cracking in asphalt surfacing"]
[null,null,"Block cracking in asphalt surfacing"]
[]
[]
[null,"Step 1","For each of the FIG tabs press \"RESET\" followed by \"START\" before use"]
[null,"Step 2","Questions will appear in order and in sequence"]
[null,"Step 3","Using the dropdown list, respond to the question that appears"]
[null,"Step 4","If a question does not appear, then do not answer it"]
[null,"Step 5","When a response appears in the yellow box, that is the answer and the end of the process."]
[null,"Step 6","You may repeat the assessment using different responses by pressing \"RESET\" followed by \"START\" "]
[]
[null,"Macros must be enabled for this workbook to function correctly."]

{"sheet":"FIG1","index":2,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[21,3,21,4],[21,5,21,14],[5,5,5,14],[2,2,2,4]]}
[]
[]
[null,null,"Initial deterioration of Asphalt/thin bituminous seal: Rutting without shoving observed"]
[]
[]
[null,null,"No.","Question","Respond here","Questions"]
[null,null,"Question 1",null,null,"Is the past directional traffic loading significantly different?"]
[]
[null,null,"Question 2",{"$f":"IF(D7=\"\",\"\",IF(E7=\"Yes\",F11,\"\"))","v":""},null,"Is there a relation between rut depth and maximum deflection or modified structural number?"]
[]
[null,null,"Question 3",{"$f":"IF(D7=\"\",\"\",IF(OR(E7=\"No\",E9=\"No\"),F9,\"\"))","v":""},null,"Is there a significant difference in the rutting for each direction that relates to the past traffic loading?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Possible cause of the defect:",{"$f":"IF(OR(AND(E7=\"Yes\", E9=\"Yes\"), AND(E7=\"No\", E11=\"Yes\")), F23, IF(OR(AND(E7=\"No\", E11=\"No\"), AND(E7=\"Yes\", E9=\"No\", E11=\"No\")), F25, \"\"))","v":""},null,"Answers"]
[null,null,null,null,null,"Initial deterioration is the result of excessive traffic loading and/or inadequate pavement layer thickness for subgrade strength."]
[]
[null,null,null,null,null,"Initial deterioration is the result of secondary compaction."]
[]
[]
[]
[]
[null,null,null,null,null,"No"]
[null,null,null,null,null,"Yes"]

{"sheet":"FIG2","index":3,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,2,2,4],[5,5,5,14],[21,3,21,4],[21,5,21,14]]}
[]
[]
[null,null,"Initial deterioration: Rutting with shoving"]
[]
[]
[null,null,"No.","Question","Respond here","Questions"]
[null,null,"Question 1",null,null,"What is the type of bituminous surfacing?"]
[]
[null,null,"Question 2",{"$f":"IF(D7=\"\",\"\",IF(E7=\"Asphalt surfacing\",F9,\"\"))","v":""},null,"Is rutting confined to the surfacing?"]
[]
[null,null,"Question 3",{"$f":"IF(D7=\"\",\"\",IF(AND(E7=\"Asphalt surfacing\",E9=\"Yes\"),F11,\"\"))","v":""},null,"Is the bituminous surfacing sampled and tested within materials and thickness specifications?"]
[]
[null,null,"Question 4",{"$f":"IF(D7=\"\",\"\",IF(OR(E7=\"Thin bituminous seal\",E9=\"No\"),F13,\"\"))","v":""},null,"Is the thickness of the roadbase or sub-base substantially less than specified?"]
[]
[null,null,"Question 5",{"$f":"IF(D13=\"\",\"\",IF(E13=\"No\",F15,\"\"))","v":""},null,"Is the strength of the roadbase or sub-base substantially less than specified?"]
[]
[]
[]
[]
[]
[]
[null,null,"Possible cause of the defect:",{"$f":"IF(OR(E13=\"Yes\",E15=\"Yes\"),F23,IF(E15=\"No\",F24,IF(E11=\"No\",F25,IF(E11=\"Yes\",F26,\"\"))))","v":""},null,"Answers"]
[null,null,null,null,null,"Initial deterioration is the result of inadequate roadbase and/or sub-base."]
[null,null,null,null,null,"Initial deterioration is the result of excessive wheel loads."]
[null,null,null,null,null,"Initial deterioration is the result of poor quality surfacing material."]
[null,null,null,null,null,"Initial deterioration is the result of inappropriate surfacing material for temperature and/or loading regime."]
[]
[]
[]
[null,null,null,null,null,"No"]
[null,null,null,null,null,"Yes"]
[]
[null,null,null,null,null,"Asphalt surfacing"]
[null,null,null,null,null,"Thin bituminous seal"]

{"sheet":"FIG3","index":4,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,2,2,4],[5,5,5,14],[21,3,21,4],[21,5,21,14]]}
[]
[]
[null,null,"Initial deterioration: Wheelpath cracking in asphalt surfacing"]
[]
[]
[null,null,"No.","Question","Respond here","Questions"]
[null,null,"Question 1",null,null,"Is it the original surfacing or an overlay"]
[]
[null,null,"Question 2",{"$f":"IF(D7=\"\",\"\",IF(E7=\"Overlay\",F9,\"\"))","v":""},null,"Are they reflection cracks?"]
[]
[null,null,"Question 3",{"$f":"IF(D7=\"\",\"\",IF(OR(AND(E7=\"Overlay\",E9=\"No\"),E7=\"Original surfacing\"),F11,\"\"))","v":""},null,"What is the type of cracking?"]
[]
[null,null,"Question 4",{"$f":"IF(D11=\"\",\"\",IF(E11=\"Crocodile/Transverse/Block\",F13,\"\"))","v":""},null,"Are they crocodile cracks?"]
[]
[null,null,"Question 5",{"$f":"IF(D13=\"\",\"\",IF(E13=\"Yes\",F15,\"\"))","v":""},null,"Is there a poor bond between the surfacing and the underlying layer?"]
[]
[null,null,"Question 6",{"$f":"IF(D15=\"\",\"\",IF(E15=\"No\",F17,\"\"))","v":""},null,"Is there a relation between radius of curvature or deflection and occurrence of cracking?"]
[]
[null,null,"Question 7",{"$f":"IF(D11=\"\",\"\",IF(E11=\"Longitudinal\",F19,\"\"))","v":""},null,"Are they short cracks?"]
[]
[null,null,"Question 8",{"$f":"IF(D11=\"\",\"\",IF(E11=\"Parabolic\",F21,\"\"))","v":""},null,"Are failures confined to areas of severe acceleration or braking?"]
[null,null,"Possible cause of the defect:",{"$f":"IF(E9=\"Yes\",F23,IF(E17=\"Yes\",F24,IF(E17=\"No\",F25,IF(E15=\"Yes\",F26,IF(E19=\"No\",F27,IF(E19=\"Yes\",F28,IF(E21=\"No\",F29,IF(E21=\"Yes\",F30,IF(E13=\"No\",F31,\"\")))))))))","v":""},null,"Answers"]
[null,null,null,null,null,"Initial deterioration is the result of inappropriate construction technique or design that disregards the risk of reflection cracking."]
[null,null,null,null,null,"Initial deterioration is the result of excessive flexure of the surfacing."]
[null,null,null,null,null,"Premature cracking of this type can result from poor surfacing material."]
[null,null,null,null,null,"Initial deterioration is the result of inappropriate construction technique."]
[null,null,null,null,null,"Long longitudinal cracks are often the result of subgrade movement. They tend to be associated with a vertical step across the crack."]
[null,null,null,null,null,"Short longitudinal cracks in the wheelpath are often the beginnings of fatigue cracking. They invariably start at the top of the surfacing as a result of the ageing of the binder."]
[null,null,null,null,null,"Initial deterioration is the result of slippage caused by general inappropriate construction technique."]
[null,null,null,null,null,"Initial deterioration is the result of slippage caused by localised inappropriate construction technique."]
[null,null,null,null,null,"See tab FIG7 and tab FIG8"]
[null,null,null,null,null,"No"]
[null,null,null,null,null,"Yes"]
[null,null,null,null,null,"Overlay"]
[null,null,null,null,null,"Original surfacing"]
[]
[null,null,null,null,null,"Parabolic"]
[null,null,null,null,null,"Longitudinal"]
[null,null,null,null,null,"Crocodile/Transverse/Block"]

{"sheet":"FIG4","index":5,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,2,2,4],[5,5,5,14],[21,3,21,4],[21,5,21,14]]}
[]
[]
[null,null,"Initial deterioration: Wheelpath cracking in thin bituminous seal"]
[]
[]
[null,null,"No.","Question","Respond here","Questions"]
[null,null,"Question 1",null,null,"Is it the original surfacing or a reseal?"]
[]
[null,null,"Question 2",{"$f":"IF(D7=\"\",\"\",IF(E7=\"Reseal\",F9,\"\"))","v":""},null,"Are they reflection cracks?"]
[]
[null,null,"Question 3",{"$f":"IF(D7=\"\",\"\",IF(OR(E7=\"Original surfacing\",E9=\"No\"),F11,\"\"))","v":""},null,"What is the type of cracking?"]
[]
[null,null,"Question 4",{"$f":"IF(D11=\"\",\"\",IF(OR(AND(E7=\"Original surfacing\",E11=\"Longitudinal/Crocodile\"),AND(E7=\"Reseal\",E9=\"No\",E11=\"Longitudinal/Crocodile\")),F13,\"\"))","v":""},null,"Is there a poor bond between the surfacing and the roadbase?"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Possible cause of the defect:",{"$f":"IF(E9=\"Yes\",F23,IF(E13=\"No\",F24,IF(E13=\"Yes\",F25,IF(E11=\"Transverse/Block\",F26,\"\"))))","v":""},null,"Answers"]
[null,null,null,null,null,"Initial deterioration is the result of inappropriate construction technique or design that disregards the risk of reflection cracking."]
[null,null,null,null,null,"Initial deterioration is the result of excessive flexure of the surfacing by traffic, exacerbated by hardening of the binder in the seal."]
[null,null,null,null,null,"Initial deterioration is the result of inappropriate construction technique."]
[null,null,null,null,null,"See tab FIG7 and tab FIG8"]
[]
[]
[]
[null,null,null,null,null,"No"]
[null,null,null,null,null,"Yes"]
[]
[null,null,null,null,null,"Original surfacing"]
[null,null,null,null,null,"Reseal"]
[]
[null,null,null,null,null,"Longitudinal/Crocodile"]
[null,null,null,null,null,"Transverse/Block"]

{"sheet":"FIG5","index":6,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[2,2,2,4],[5,5,5,14],[21,3,21,4],[21,5,21,14]]}
[]
[]
[null,null,"Initial deterioration: Non-wheelpath cracking in asphalt surfacing"]
[]
[]
[null,null,"No.","Question","Respond here","Questions"]
[null,null,"Question 1",null,null,"Is it an overlay?"]
[]
[null,null,"Question 2",{"$f":"IF(D7=\"\",\"\",IF(E7=\"Yes\",F9,\"\"))","v":""},null,"Are they reflection cracks?"]
[]
[null,null,"Question 3",{"$f":"IF(D7=\"\",\"\",IF(OR(E7=\"No\",E9=\"No\"),F11,\"\"))","v":""},null,"What type of cracking is it?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Possible cause of the defect:",{"$f":"IF(AND(E7=\"Yes\",E9=\"Yes\"), F23, IF(OR(AND(E7=\"No\",E11=\"Crocodile\"),AND(E7=\"Yes\",E9=\"No\",E11=\"Crocodile\")),F24,IF(OR(AND(E7=\"No\", E11=\"Block\"),AND(E7=\"Yes\",E9=\"No\",E11=\"Block\")),F25,IF(OR(AND(E7=\"No\",E11=\"Transverse\"),AND(E7=\"Yes\",E9=\"No\",E11=\"Transverse\")),F26,IF(OR(AND(E7=\"No\",E11=\"Longitudinal\"),AND(E7=\"Yes\",E9=\"No\",E11=\"Longitudinal\")),F27,\"\")))))","v":""},null,"Answers"]
[null,null,null,null,null,"Initial deterioration is the result of inappropriate construction technique or design that did not provide for arresting reflective cracking."]
[null,null,null,null,null,"Crocodile cracking that is neither confined to the wheelpaths nor associated with rutting is indicative of a fault in the construction of the surfacing."]
[null,null,null,null,null,"See tab FIG8"]
[null,null,null,null,null,"See tab FIG7"]
[null,null,null,null,null,"See tab FIG6"]
[]
[]
[null,null,null,null,null,"No"]
[null,null,null,null,null,"Yes"]
[null,null,null,null,null,"Block"]
[null,null,null,null,null,"Transverse"]
[null,null,null,null,null,"Longitudinal"]
[null,null,null,null,null,"Crocodile"]

{"sheet":"FIG6","index":7,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,2,2,4],[5,5,5,14],[21,3,21,4],[21,5,21,14]]}
[]
[]
[null,null,"Initial deterioration: Longitudinal cracking in asphalt surfacing"]
[]
[]
[null,null,"No.","Question","Respond here","Questions"]
[null,null,"Question 1",null,null,"Are the cracks at the centreline joint or alongside road marking?"]
[]
[null,null,"Question 2",{"$f":"IF(D7=\"\",\"\",IF(E7=\"No\",F9,\"\"))","v":""},null,"Are the cracks associated with transverse cracks?"]
[]
[null,null,"Question 3",{"$f":"IF(D7=\"\",\"\",IF(AND(E7=\"No\",E9=\"No\"),F11,\"\"))","v":""},null,"Are they short cracks in the wheel path?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Possible cause of the defect:",{"$f":"IF(E7=\"Yes\",F23,IF(AND(E7=\"No\",E9=\"No\",E11=\"No\"), F24, IF(AND(E7=\"No\",E9=\"No\",E11=\"Yes\"), F25,IF(AND(E7=\"No\", E9=\"Yes\"),F26, \"\"))))","v":""},null,"Answers"]
[null,null,null,null,null,"Initial deterioration is the result of thermal stresses."]
[null,null,null,null,null,"Long longitudinal cracks are often the result of subgrade movement. They tend to be associated with a vertical step across the crack."]
[null,null,null,null,null,"Short longitudinal cracks in the wheelpath are often the beginnings of fatigue cracking. They invariably start at the top of the surfacing as a result of binder ageing."]
[null,null,null,null,null,"See tab FIG8"]
[]
[]
[]
[null,null,null,null,null,"No"]
[null,null,null,null,null,"Yes"]

{"sheet":"FIG7","index":8,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,2,2,4],[5,5,5,14],[21,3,21,4],[21,5,21,14]]}
[]
[]
[null,null,"Initial deterioration: Transverse cracking in asphalt surfacing"]
[]
[]
[null,null,"No.","Question","Respond here","Questions"]
[null,null,"Question 1",null,null,"Is there a chemically stabilised roadbase or sub-base?"]
[]
[null,null,"Question 2",{"$f":"IF(D7=\"\",\"\",IF(E7=\"Yes\",F9,\"\"))","v":""},null,"Are they reflection cracks from a lower pavement layer?"]
[]
[null,null,"Question 3",{"$f":"IF(D7=\"\",\"\",IF(OR(E7=\"No\",E9=\"No\"),F11,\"\"))","v":""},null,"Are the cracks associated with longitudinal cracks?"]
[]
[null,null,"Question 4",{"$f":"IF(D11=\"\",\"\",IF(OR(AND(E7=\"No\",E11=\"No\"),AND(E7=\"Yes\",E9=\"No\",E11=\"No\")),F13,\"\"))","v":""},null,"Are the cracks regularly spaced at >20 m spacing?"]
[]
[null,null,"Question 5",{"$f":"IF(D13=\"\",\"\",IF(E13=\"Yes\",F15,\"\"))","v":""},null,"Do the cracks extend the full width of the road?"]
[]
[]
[]
[]
[]
[]
[null,null,"Possible cause of the defect:",{"$f":"IF(E9=\"Yes\",F23,IF(E13=\"No\",F24,IF(E15=\"No\",F25,IF(E15=\"Yes\",F26,IF(E11=\"Yes\",F27,\"\")))))","v":""},null,"Answers"]
[null,null,null,null,null,"Initial deterioration is the result of reflection cracking from stablised layer(s)."]
[null,null,null,null,null,"Initial deterioration is the result of thermal or shrinkage stresses."]
[null,null,null,null,null,"Initial deterioration is the result of thermal or construction joints."]
[null,null,null,null,null,"Initial deterioration is the result of differential movements at structures such as culverts."]
[null,null,null,null,null,"See tab FIG8"]
[]
[]
[null,null,null,null,null,"No"]
[null,null,null,null,null,"Yes"]

{"sheet":"FIG8","index":9,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,2,2,4],[5,5,5,14],[21,3,21,4],[21,5,21,14]]}
[]
[]
[null,null,"Initial deterioration: Block cracking in asphalt surfacing"]
[]
[]
[null,null,"No.","Question","Respond here","Questions"]
[null,null,"Question 1",null,null,"Is there a chemically stabilised roadbase or sub-base?"]
[]
[null,null,"Question 2",{"$f":"IF(D7=\"\",\"\",IF(E7=\"Yes\",F9,IF(E7=\"No\",\"\",\"\")))","v":""},null,"Are they reflection cracks from a lower pavement layer?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Possible cause of the defect:",{"$f":"IF(AND(E7=\"Yes\", E9=\"Yes\"),F23, IF(OR(AND(E7=\"Yes\", E9=\"No\"),E7=\"No\"),F25,\"\"))","v":""},null,"Answers"]
[null,null,null,null,null,"Initial deterioration is the result of reflection cracks from the stabilised layer."]
[]
[null,null,null,null,null,"Initial deterioration is the result of thermal or shrinkage stresses."]
[]
[]
[]
[]
[null,null,null,null,null,"No"]
[null,null,null,null,null,"Yes"]