{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Form","DropdownData","Other"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":22,"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":"Form","index":0,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[6,7,8,7],[6,8,8,9],[8,3,8,6],[24,2,24,9],[37,13,39,18],[37,6,37,7],[27,7,27,9],[28,7,28,9],[29,7,29,9],[37,2,37,3],[16,8,16,9],[14,3,14,9],[13,5,13,7],[9,8,9,9],[9,3,9,7],[26,3,26,5],[37,4,37,5],[2,2,2,9],[3,2,3,9],[5,8,5,9],[5,3,5,6],[6,3,6,6],[36,2,36,5],[35,4,35,9],[36,8,36,9],[37,8,37,9],[35,2,35,3],[36,13,36,18],[29,3,29,5],[17,2,17,9],[32,8,32,9],[20,2,20,3],[21,2,21,3],[30,7,30,9],[31,7,31,9],[18,8,18,9],[26,7,26,9],[36,6,36,7],[30,3,30,5],[31,3,31,5],[32,3,32,5],[27,3,27,5],[28,3,28,5],[1,1,1,10],[7,2,7,6],[34,2,34,9],[21,4,21,5],[21,7,21,9],[20,4,20,5],[18,2,18,3],[18,6,18,7],[18,4,18,5],[11,2,11,9],[16,6,16,7],[16,2,16,3],[15,2,15,3],[13,2,13,4],[16,4,16,5]]}
[null,null,null,null,null,null,null,null,null,null,null,"  V    A yellow box indicates that a field is empty on that line"]
[]
[null,null,"Test Request Form",null,null,null,null,null,null,null,null,null,"Anything not inside the white rectangle to the left will not be printed"]
[{"$f":"MATCH(C4,INDIRECT(TestRange),0)","v":4},null,"Soil",null,null,null,null,null,null,null,null,{"$f":"IF(C4=\"\",\"Please specify works test request is for\",\"\")","v":""},"<-- Pick the type of work from drop down list. Options below "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"will automatically change to suit the type of works selected"]
[null,null,"To:",null,null,null,null,"Email:",null,null,null,{"$f":"IF(OR(D6=\"\",I6=\"\"),\"Please fill in 'To' details\",\"\")","v":"Please fill in 'To' details"}]
[null,null,"CC:","Darwin/Palmerston",null,null,null,"Test Request Number:",null,null,null,{"$f":"IF(OR(D7=\"\",I7=\"\"),\"Please fill in 'CC' details\",\"\")","v":"Please fill in 'CC' details"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I8=\"\",\"Please put in an email for CC details\",\"\")","v":"Please put in an email for CC details"}]
[null,null,"Supervisor:",null,null,null,null,null,null,null,null,{"$f":"IF(OR(D9=\"\",I9=\"\"),\"Please fill in 'Supervisor' details\",\"\")","v":"Please fill in 'Supervisor' details"}]
[null,null,"Project:",null,null,null,null,null,"Page 1 of 1",null,null,{"$f":"IF(D10=\"\",\"Please fill in 'Project' details\",\"\")","v":"Please fill in 'Project' details"}]
[]
[null,null,"• When required, in accordance with the contract documents, order the conformance testing in writing directly from the panel period contractors. \n• Should the next panel period contractor on the list not be available to perform the required testing, notify the superintendent immediately.\n• Give the panel period contractor written notice in advance of each stage of the works requiring conformance testing, including re-testing.\n• Notice – provide the superintendent with a copy of the order for testing simultaneously with the order being sent to the panel period contractor.\n• Any communication with the panel period contractors, other than the ordering of testing or inquiring on the timing of test results must be forwarded through the superintendent.\n• Provide the superintendent with the results of process control testing as identified in the relevant itp with all requests for conformance testing.\n• Notice – notify the superintendent prior to any rework of failed lots."]
[]
[null,null,"Date & time test required:",null,null,null,null,null,null,null,null,{"$f":"IF(F14=\"\",\"Please fill in 'date and time test required'\",\"\")","v":"Please fill in 'date and time test required'"},"<-- Fill as required, the gray text will disappear as you fill in data"]
[null,null,null,{"$f":"IF(AND(F14=\"\",DisableCell<>1),\" Reasonable notice required to be given to panel period contractors – \nensure times for testing reflect the actual proposed completion time of the lot to be tested.\",\"\")","v":" Reasonable notice required to be given to panel period contractors – \nensure times for testing reflect the actual proposed completion time of the lot to be tested."},null,null,null,null,null,null,null,null,null,"OR"]
[null,null,"Lot Number:",null,null,{"$f":"IF(AND(E16=\"\",DisableCell<>1),\"< Clearly identify number of the lot – easier for everyone\",\"\")","v":"< Clearly identify number of the lot – easier for everyone"},null,null,null,null,null,{"$f":"IF(E16=\"\",\"Please put in a lot number\",\"\")","v":"Please put in a lot number"},0," Click box on the left to show/hide the gray text without filling out this form"]
[null,null,"Start Chainage:",null,null,null,"End Chainage:",null,null,null,null,{"$f":"IF(OR(E17=\"\",I17=\"\"),\"Please fill in chainages\",\"\")","v":"Please fill in chainages"}]
[null,null,{"$f":"IF(AND(OR(E17=\"\",I17=\"\"),DisableCell<>1),\"      Ensure these are clearly marked on site – related to lot numbers \",\"\")","v":"      Ensure these are clearly marked on site – related to lot numbers "}]
[null,null,"Width (m):",null,null,null,"Length (m):",null,null,null,null,{"$f":"IF(E19=\"\",\"Please input a width\",IF(I19=\"\",\"Please input a length\",\"\"))","v":"Please input a width"}]
[]
[null,null,"Test & Layer Depth:",null,null,null,null,null,null,null,null,{"$f":"IF(E21=\"\",\"Please input test and layer depth\",\"\")","v":"Please input test and layer depth"}]
[{"$f":"OFFSET(ListBase1,0,ItemIndex)","v":"DropdownData!$F$5:$F$9"},null,"Layer Type:",null,null,null,null,null,null,null,null,{"$f":"IF(E22=\"\",\"Please select layer type\",IF(AND(E22=\"Other\",H22=\"\"),\"Please add more info about layer type\",\"\"))","v":"Please select layer type"},"<-- Drop down list will update depending on type of work "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"selected above"]
[{"$f":"OFFSET(ShowRetestBase,0,ItemIndex)=\"Yes\"","v":true},null,"Tests Required:",null,null,null,null,"Is this a retest:","Yes/No",null,null,{"$f":"IF(AND(testReqOp,OR(I24=\"\",I24=\"Yes/No\")),\"Please specify whether test is original or retest\",\"\")","v":"Please specify whether test is original or retest"},{"$f":"IF(testReqOp,\"<-- Is this request a retest (YES) or an original test (NO)?\",\"\")","v":"<-- Is this request a retest (YES) or an original test (NO)?"}]
[{"$f":"OFFSET(DescBase,0,ItemIndex)","v":0},null,{"$f":"IF(A25=0,\"\",A25)","v":""}]
[null,null,{"$f":"IF(containsMandatories(INDIRECT(OFFSET(ListBase2,0,ItemIndex))),\"      Tests with * are mandatory\",\"\")","v":""}]
[1,null,{"$f":"IF(LEFT($D$27,1)=\"*\",CHAR(82),CHAR(163))","v":"£"},{"$f":"OFFSET(ListBase2,A27,ItemIndex)","v":"Field Density / PLT"},null,null,{"$f":"IF(LEFT($H$27,1)=\"*\",CHAR(82),CHAR(163))","v":"£"},{"$f":"OFFSET(ListBase2,M27,ItemIndex)","v":"Concrete - Slump"},null,null,null,null,{"$f":"A33+1","v":8},"<-- Click to select/unselect test if any - the test available"]
[{"$f":"A27+1","v":2},null,{"$f":"IF(LEFT($D$28,1)=\"*\",CHAR(82),CHAR(163))","v":"£"},"Particle Size Distribution",null,null,{"$f":"IF(LEFT($H$28,1)=\"*\",CHAR(82),CHAR(163))","v":"£"},"Concrete - Cylinders",null,null,null,null,{"$f":"M27+1","v":9},"      vary depending on the type of work selected above"]
[3,null,{"$f":"IF(LEFT($D$29,1)=\"*\",CHAR(82),CHAR(163))","v":"£"},"Plasticity Index",null,null,{"$f":"IF(LEFT($H$29,1)=\"*\",CHAR(82),CHAR(163))","v":"£"},"Flakiness / ALD",null,null,null,null,10]
[4,null,{"$f":"IF(LEFT($D$30,1)=\"*\",CHAR(82),CHAR(163))","v":"£"},"CBR",null,null,{"$f":"IF(LEFT($H$29,1)=\"*\",CHAR(82),CHAR(163))","v":"£"},"Ball-embedment",null,null,null,null,11]
[5,null,{"$f":"CHAR(82)","v":"R"},0,null,null,{"$f":"IF(LEFT($H$31,1)=\"*\",CHAR(82),CHAR(163))","v":"£"},"Dry Back",null,null,null,null,12]
[6,null,{"$f":"CHAR(82)","v":"R"},0,null,null,{"$f":"IF(LEFT($H$32,1)=\"*\",CHAR(82),CHAR(163))","v":"£"},0,null,null,null,null,13]
[7,null,{"$f":"IF(LEFT($D$33,1)=\"*\",CHAR(82),CHAR(163))","v":"£"},0,null,null,{"$f":"IF(LEFT($H$33,1)=\"*\",CHAR(82),CHAR(163))","v":"£"},"Other:",null,null,null,{"$f":"IF(AND(H33<>0,G33=CHAR(82),I33=\"\"),\"Please specify more detail for test if selecting 'Other'\",\"\")","v":""},14]
[]
[]
[null,null,"Contractor:",null,null,null,null,null,null,null,null,{"$f":"IF(E36=\"\",\"Please specify a contractor\",\"\")","v":"Please specify a contractor"}]
[null,null,null,null,null,null,"Contact No.:",null,null,null,null,{"$f":"IF(I37=\"\",\"Please provide a contact number for contractor\",\"\")","v":"Please provide a contact number for contractor"},null,{"$f":"IF(COUNTBLANK(L4:L39)=35,\"Form is complete and ready to send\",\"Form is incomplete: \")","v":"Form is incomplete: "}]
[null,null,"Date & Time:",null,null,null,"Fax No.:",null,null,null,null,{"$f":"IF(E38=\"\",\"Please input date and time of request\",IF(I38=\"\",\"Please provide a fax number\",\"\"))","v":"Please input date and time of request"},null,{"$f":"IF(COUNTBLANK(L4:L39)=35,\"All fields have been completed\",IF(COUNTBLANK(L4:L39)<15,joinWithCommas(L4:L39),LEFT(joinWithCommas(L4:L39),250))&\"…\")","v":"Please fill in 'To' details, Please fill in 'CC' details, Please put in an email for CC details, Please fill in 'Supervisor' details, Please fill in 'Project' details, Please fill in 'date and time test required', Please put in a lot number, Please f…"}]
[]
[null,"Version 1, 27/03/2013"]

{"sheet":"DropdownData","index":1,"n_rows":30,"n_cols":27,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["DO NOT EDIT GRAY CELLS",null,1,{"$f":"IF(D2=\"\",\"\",C1+1)","v":2},{"$f":"IF(E2=\"\",\"\",D1+1)","v":3},4,"","","","","","","","","","","","","","","","","","","","","MAX"]
["Test Form",{"$f":"\"DropdownData!C2:\"&ADDRESS(2,2+COUNT(C1:Z1))","v":"DropdownData!C2:$F$2"},"Aggregates for Sealing Works","Asphalt Works","Priming or Sealing Works","Soil",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COLUMNS"]
["Comments/ Description/ Notes to user",null,"Testing is take place on site – what materials are to be used for sealing - no quarry results are to be accepted\n\nMinimum 3 sample to be tested once you get above 750 tonne then 1 extra test per every 250 tonne to be used (i.e. 1200 tonne - 5 sets of tests required)","3 areas here need to be tested:\n  1. Bitumen to be used in asphalt mix: 1 sample consisting of 3 tins\n  2. Asphalt used on project: Psd, bitumen content, stability and flow, maximum density\n  3. Density once asphalt laid: Voids cores from site","You need to test every time priming or sealing takes place – note generally one per day or as per specification.\nThe bituminous supplier is to sample and the tester is to witness only (OH&S request from industry).\n\n  Urban Works - Witness by tester (test request to RMG)\n  Rural Works - Witness by DoI (test request to supplier)"]
["Layer Type",null,{"$f":"\"DropdownData!\"&ADDRESS(RowNum1,COLUMN(C5))&\":\"&ADDRESS(RowNum1+MAX(1,COUNTA(C5:C12))-1,COLUMN(C5))","v":"DropdownData!$C$5:$C$5"},"DropdownData!$D$5:$D$8","DropdownData!$E$5:$E$8","DropdownData!$F$5:$F$9","DropdownData!$G$5:$G$5","DropdownData!$H$5:$H$5","DropdownData!$I$5:$I$5","DropdownData!$J$5:$J$5","DropdownData!$K$5:$K$5","DropdownData!$L$5:$L$5","DropdownData!$M$5:$M$5","DropdownData!$N$5:$N$5","DropdownData!$O$5:$O$5","DropdownData!$P$5:$P$5","DropdownData!$Q$5:$Q$5","DropdownData!$R$5:$R$5","DropdownData!$S$5:$S$5","DropdownData!$T$5:$T$5","DropdownData!$U$5:$U$5","DropdownData!$V$5:$V$5","DropdownData!$W$5:$W$5","DropdownData!$X$5:$X$5","DropdownData!$Y$5:$Y$5","DropdownData!$Z$5:$Z$5"]
[null,{"$f":"ROW(A5)","v":5},"N/A","Deep Lift","Prime","Base"]
["You can add more layer type",null,null,"Wearing Course","Seal","Sub-Base"]
["options by inserting more rows",null,null,"Deep Lift and Wearing Course","Prime and Seal","Subgrade"]
["Do not leave gaps!",null,null,"Other","Other","Fill"]
[null,null,null,null,null,"Other"]
[]
[]
[]
["Show test/retest option",null,"No","No","No","Yes"]
["Test Required",null,{"$f":"\"DropdownData!\"&ADDRESS(RowNum2,COLUMN(C15))&\":\"&ADDRESS(RowNum2+MAX(1,COUNTA(C15:C28))-1,COLUMN(C15))","v":"DropdownData!$C$15:$C$17"},"DropdownData!$D$15:$D$17","DropdownData!$E$15:$E$16","DropdownData!$F$15:$F$24","DropdownData!$G$15:$G$15","DropdownData!$H$15:$H$15","DropdownData!$I$15:$I$15","DropdownData!$J$15:$J$15","DropdownData!$K$15:$K$15","DropdownData!$L$15:$L$15","DropdownData!$M$15:$M$15","DropdownData!$N$15:$N$15","DropdownData!$O$15:$O$15","DropdownData!$P$15:$P$15","DropdownData!$Q$15:$Q$15","DropdownData!$R$15:$R$15","DropdownData!$S$15:$S$15","DropdownData!$T$15:$T$15","DropdownData!$U$15:$U$15","DropdownData!$V$15:$V$15","DropdownData!$W$15:$W$15","DropdownData!$X$15:$X$15","DropdownData!$Y$15:$Y$15","DropdownData!$Z$15:$Z$15"]
[null,{"$f":"ROW(A15)","v":15},"*PSD (Minimum 3)","*Sample of bitumen used in asphalt","Prime (1 sample consisting of 3 tins)","Field Density / PLT"]
["Max of 13 tests + 1 'Other' option",null,"*ALD (Minimum 3)","*Asphalt used on project","Sealing (1 sample consisting of 3 tins)","Particle Size Distribution"]
["DO NOT ADD MORE ROWS",null,"*FI (Minimum 3)","*Voids",null,"Plasticity Index"]
["Anything after the 14th row",null,null,null,null,"CBR"]
["will be ignored"]
[]
["You can leave gaps between tests - "]
["this will affect the position of items",null,null,null,null,"Concrete - Slump"]
["on the form",null,null,null,null,"Concrete - Cylinders"]
[null,null,null,null,null,"Flakiness / ALD"]
[null,null,null,null,null,"Ball-embedment"]
["Last test should only be 'other' or ",null,null,null,null,"Dry Back"]
["similar as a special field is provided"]
["to specify what 'Other' is          >>>",null,null,null,null,"Other:"]
[]
["You can add more test request types by filling in more columns. The columns must be filled in from left to right with no empty columns."]

{"sheet":"Other","index":2,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Fax Numbers",null,null,null,"Test Request Type",null,null,"Yes/No Options"]
[{"$f":"\"Other!\"&CELL(\"address\",A3)&\":\"&CELL(\"address\",OFFSET(A3,COUNTA(A3:A15)-1,0))","v":"Other!$A$3:$A$6"},"Fax No.","Email",null,{"$f":"\"Other!\"&CELL(\"address\",E3)&\":\"&CELL(\"address\",OFFSET(E3,COUNTA(E3:E15)-1,0))","v":"Other!$E$3:$E$4"},null,null,{"$f":"\"Other!\"&CELL(\"address\",H3)&\":\"&CELL(\"address\",OFFSET(H3,COUNTA(H3:H15)-1,0))","v":"Other!$H$3:$H$5"}]
["Darwin/Palmerston","8999 4682",null,null,"Retest",null,null,"Yes/No"]
["Alice Springs","8951 5566",null,null,"Original",null,null,"Yes"]
["Katherine","8973 8666",null,null,null,null,null,"No"]
["Tennant Creek","8962 4553"]