{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Field Data Entry","Report"],"not_rendered":{"charts":1,"images":4,"macros":1,"external_links":0,"defined_names":2,"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":"Field Data Entry","index":0,"n_rows":215,"n_cols":17,"rows_kept":215,"cut":false,"hidden":false,"merged":[[49,1,49,4],[50,1,50,4],[42,1,42,7],[43,1,43,7],[44,1,44,7],[45,1,45,7],[42,8,45,11],[172,2,172,5],[170,1,170,4],[95,1,95,11],[67,6,67,11],[127,2,127,5],[51,1,51,4],[56,1,56,4],[57,1,57,4],[59,1,59,4],[60,1,60,4],[61,1,61,4],[62,1,62,4],[66,1,66,4],[67,1,67,4],[89,1,89,4],[103,2,103,11],[59,6,59,11],[108,1,109,1],[108,2,108,3],[63,1,63,4],[90,1,90,4],[91,1,91,4],[92,1,92,4],[93,1,93,4],[65,1,65,4],[62,6,62,11],[63,6,63,11],[65,6,65,11],[66,6,66,11],[83,6,83,11],[84,1,84,4],[99,1,99,4],[100,1,100,4],[99,5,99,6],[100,5,100,6],[0,1,0,11],[1,1,1,11],[68,1,68,11],[97,1,97,6],[25,1,25,11],[7,1,7,11],[6,1,6,11],[26,5,26,11],[17,1,17,11],[94,1,94,4],[96,1,96,3],[30,1,30,4],[31,1,31,4],[33,1,33,4],[34,1,34,4],[35,1,35,4],[8,5,8,11],[9,5,9,11],[10,5,10,11],[26,1,26,4],[56,6,56,11],[57,6,57,11],[55,6,55,11],[61,6,61,11],[11,5,11,11],[14,5,14,11],[15,5,15,11],[16,5,16,11],[27,5,27,11],[5,1,5,11],[85,5,88,5],[85,1,88,4],[85,9,85,11],[86,9,86,11],[13,5,13,11],[30,5,30,11],[8,1,8,4],[9,1,9,4],[37,1,37,4],[18,1,18,11],[20,1,20,4],[20,5,20,11],[21,1,21,4],[21,5,21,11],[22,1,22,4],[22,5,22,11],[23,1,23,4],[23,5,23,11],[124,1,124,6],[123,1,123,6],[46,1,46,11],[40,1,40,11],[55,1,55,4],[83,1,83,4],[82,1,82,11],[89,6,89,11],[90,6,90,11],[91,6,91,11],[92,6,92,11],[93,6,93,11],[94,6,94,11],[84,6,84,11],[51,8,51,11],[48,1,48,4],[47,1,47,11],[48,8,48,11],[49,8,49,11],[50,8,50,11],[107,1,107,7],[108,4,108,7],[104,2,104,11],[105,2,105,11],[2,1,2,11],[3,1,3,11],[28,1,28,4],[28,5,28,11],[29,1,29,4],[29,5,29,11],[32,1,32,4],[32,5,32,11],[36,1,36,4],[36,5,36,11],[10,1,10,4],[11,1,11,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[27,1,27,4],[12,1,12,4],[12,5,12,11],[31,5,31,11],[33,5,33,11],[34,5,34,11],[35,5,35,11],[4,1,4,11],[19,5,19,11],[19,1,19,4],[64,1,64,4],[64,6,64,11],[69,1,69,11],[70,8,70,11],[79,8,79,11],[80,8,80,11],[73,8,73,11],[74,8,74,11],[24,1,24,11],[80,3,80,6],[79,1,79,2],[80,1,80,2],[37,5,37,11],[38,1,38,4],[38,5,38,11],[39,1,39,4],[39,5,39,11],[70,1,70,2],[70,3,70,6],[71,1,71,2],[54,1,54,11],[71,8,71,11],[102,1,102,3],[75,8,75,11],[76,8,76,11],[77,8,77,11],[78,1,78,11],[58,1,58,4],[58,6,58,11],[41,1,41,11],[71,3,71,6],[72,8,72,11],[74,1,74,2],[74,3,74,6],[75,1,75,2],[75,3,75,6],[72,1,72,2],[72,3,72,6],[73,1,73,2],[73,3,73,6],[76,1,76,2],[76,3,76,6],[77,1,77,2],[77,3,77,6],[79,3,79,6],[60,6,60,11]]}
[null,"Civil and Structural Engineers Initial Geotechnical Assessment Report Template"]
[null,"The Civil and Structual Engineer Initial Geotechnical Assessment Report is to be used by engineers to support their use of the Geotechnical Input Flowchart. It provides a template for the type of information that should be presented to a BCA to justify the engineer's assumptions when a geotechnical report by a Chartered Professional Engineer (Geotechnical) or Professional Engineering Geologist is unlikely to be required.  "]
[null,"This document is only an indication of what additional information or expertise may be required. There will always be exeptions to general guidance, and the Structural or Civil Engineer should use their professional judgement in every case to determine the appropriate skills and expertise required for the job.                                                "]
[null,"The document is not be to used to report ground investigations and soil assessment for projects with geotechnical risks outside the bounds of competence for a structural engineer."]
[]
[null,"This spreadsheet can be used to produce a standardised report after inputting relevant data in the shaded cells below.  This data will be collated and presented in the adjacent worksheet labeled Report. All photos should be inserted directly into the report worksheet.  The Report Sheet is locked, but allows the insert of a copmany logo and photos where relevant, and resizing of rows to improve presentation. Once complete, the report can be exported as a pdf document, or printed."]
[]
[1,"Project Details"]
[null,"Project Street Address"]
[null,"Client Details"]
[null,"Project and site testing locations",null,null,null,"Insert image of site plan including project and testing locations directly into Appendix One of the Report Sheet"]
[null,"Revision  number"]
[null,"Engineering Company Details"]
[null,"Prepared by"]
[null,"Reviewed by"]
[null,"Date"]
[null,"Job number"]
[]
[2,"Summary of Proposed Development"]
[null,"Item",null,null,null,"Comments"]
[null,"Structure type"]
[null,"Levels above ground"]
[null,"Design Life"]
[null,"Importance level"]
[]
[3,"Summary of Desktop Assessment"]
[null,"Item",null,null,null,"Comments"]
[null,"List  of previous geotechnical reports available"]
[null,"Findings of previous geotechnical reports"]
[null,"Geological maps available"]
[null,"New Zealand Geotechnical Database (NZGD) data nearby (i.e. within ~ 200 m)"]
[null,"Geotechnical hazards from council's GIS or equivalent"]
[null,"Known geotechnical hazards on the site"]
[null,"Minimum floor level and flooding"]
[null,"Review of historic aerial photographs – previous HAIL activity / earthworks / building activity at the site?"]
[null,"Close-proximity active faults"]
[null,"Subsoil class as part of current NZ standard"]
[null,"Topographical assessment of the surrounding area"]
[null,"Buried services and structures"]
[null,"Anticipated engineering geological model from maps and previous investigations and level of uncertainty in the model"]
[]
[4,"Resources"]
[null,"NZS3604:2011 Timber Framed Buildings"]
[null,"NZS4431 Code of practice for earth fill"]
[null,"DZ4431 2021 Draft Code of Practice for earth fill construction"]
[null,"NZGS Field description of rock and soil"]
[5,"Ground Investigations"]
[null,"Ground Testing"]
[null,"Test Type",null,null,null,"Number of tests","Maximum depth (mBGL)","Average depth (mGBL)","Test Standard followed"]
[null,"Scala Penetrometer (minimum required depth 2m or justifiable refusal)"]
[null,"Hand Augur/Test Pit  (minimum required depth 2m or justifiable refusal)"]
[null,"Shear Vane (Optional - note that if no data is added, this wil not be included in the report)"]
[null,"The following investigations were undertaken by","to evaluate the subsurface conditions at the site on",". Investigation data and site photos can be found in the Appendix.","hand auger tests / test pits (or other) to ","m to allow visual assessment of soil conditions and confirm groundwater depth [min 2 m depth].","scala penetrometer tests (or other) to ","m to confirm bearing capacity.","Groundwater was encountered at ","mbgl at the time of the investigation on","."]
[]
[5,"Investigation Findings"]
[null,"Item",null,null,null,"Yes/No","Comments"]
[null,"Hazard check"]
[null,"Desktop study"]
[null,"Ground investigations"]
[null,"Liquefaction risk (sandy soils, high groundwater) - if YES a geotechnical Engineer consultation is required "]
[null,"Slope stability risk, address both risk of inundation from above as well as global stability and instability from below; referring published hazard maps and local knowledge"]
[null,"Expansive soils (refer site specific testing, published maps and local knowledge)"]
[null,"Potentially compressible soils (recent alluvial soils (e.g. silts/peats); refer published hazard maps and local knowledge)"]
[null,"Minimum 300 kPa ultimate bearing strength established"]
[null,"Probable maximum settlement met under Nz Building Code"]
[null,"‘Good ground’ per NZS 3604 (latest edition)"]
[null,"Flooding risk (refer published hazard maps and local knowledge)"]
[null,"Close-proximity active fault risk – has fault location been established / is min offset met?"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cuts no greater than Xm, fill no greater than Xm "]
[6,"Geotechnical Risk Assessment"]
[null,"Risk",null,"Consequence Description",null,null,null,"Risk L/M/H","Proposed Mitigation"]
[]
[]
[]
[]
[]
[]
[]
[null,"Examples"]
[null,"Liquefiable deposits present below depth of investigated soils",null,"Foundation damage",null,null,null,"H","Consult Geotechnical Engineer. Use TC2 foundations."]
[null,"Softer areas of soil in low-lying part of site",null,"Differential settlement",null,null,null,"M","Undertake additional ground investigation and consult Geotechnical Engineer."]
[null,"Examples"]
[7,"Recommendations"]
[null,"Item",null,null,null,"Yes/No","Comments"]
[null,"Planned Earthworks"]
[null,"Cut and Fill",null,null,null,null,"Cuts no greater than",null,null,"m,"]
[null,null,null,null,null,null,"fill no  greater than",null,null,"m"]
[null,null,null,null,null,null,"to be made without involvement from CPEng (Geotech) or PEngGeol"]
[]
[null,"Ground improvement/remediation"]
[null,"Foundation recommendations"]
[null,"Building restriction zone (BRZ) (Refer any resource consent conditions)"]
[null,"Preliminary SW design / control of surface water / groundwater"]
[null,"On-site wastewater design required? Any preliminary recommendations."]
[null,"Further investigation/assessment[1]"]
[null,"[1] E.g. Any recommendations required re. earthworks control?  Filling to NZS 4431?  Cutting?  Max cut height and batter grade to ensure stability.  Retaining needed?  Max height on this site before geotech input required?  Proximity to boundaries. Temporary works if cutting near boundaries."]
[]
[8,"Field Data Entry"]
[]
[8.1,"Investigations undertaken by"]
[null,"Date of investigations"]
[null,"undertook the following investigations to evaluate the subsurface conditions at the site on ",". Site plan with test location and site photos can be found in Appendix One, investigation data, graph and soil photos can be found in Appendix Two."]
[8.1999999999999993,"Site Photos - Insert photos directly into Report worksheet"]
[null,"Photo No","Description of view including the slope of ground and direction from which photo was taken"]
[null,1]
[null,2]
[]
[8.3000000000000007,"Hand Augur/Test Pit Photos - Insert photos directly into Report worksheet"]
[null,"Photo No.","Depth (mm)",null,"Soil Description (NZGS)"]
[null,null,"From","To","Condition","Size","Material","with "]
[null,1,0]
[null,null,{"$f":"IF(ISBLANK(B112),\"\",D111)","v":""}]
[null,null,{"$f":"IF(ISBLANK(B113),\"\",D112)","v":""}]
[null,null,{"$f":"IF(ISBLANK(B114),\"\",D113)","v":""}]
[null,null,{"$f":"IF(ISBLANK(B115),\"\",D114)","v":""}]
[null,"from","to","mm"]
[8.4,"Groundwater found at ",null,null,"Groundwater  ","and Shear Vane","test results"]
[null,"Depth (mbgl)"]
[null,"Date"]
[]
[8.5,"Shear Vane Test Result"]
[null,"Average Shear Vane Strength (kPa)"]
[]
[8.6,"Scala Penetrometer Testing"]
[null,"Testing as per NZS3604:2011  Section 3.3 Test Method for Soil Bearing Capacity"]
[null,"Test Number",1,2,3,4,5]
[null,"Ground Level (m)"]
[null,"Depth (m)","     Blows/100mm"]
[null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,{"$f":"B129+0.1","v":0.1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,{"$f":"B130+0.1","v":0.2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,0.30000000000000004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,0.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,0.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,0.7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,0.79999999999999993,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,0.89999999999999991,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,0.99999999999999989,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,1.0999999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,1.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,1.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,1.4000000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,1.5000000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,1.6000000000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,1.7000000000000004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,1.8000000000000005,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,1.9000000000000006,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,2.0000000000000004,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,2.1000000000000005,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,2.2000000000000006,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,2.3000000000000007,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,2.4000000000000008,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,2.5000000000000009,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,2.600000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,2.7000000000000011,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,2.8000000000000012,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,2.9000000000000012,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,3.0000000000000013,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,3.1000000000000014,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,3.2000000000000015,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,3.3000000000000016,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,3.4000000000000017,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,3.5000000000000018,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,3.6000000000000019,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,3.700000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,3.800000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,3.9000000000000021,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,4.0000000000000018,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,4.0999999999999996,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[7.4,"Hand Augur/Test Pit Soil Testing Field Data",null,null,null,null,null,"Fields as defined by NZGS Soil Guide",null,null,null,null,null,null,null,null,3]
[null,"Test Number",1,null,null,null,null,2,null,null,null,null,null,null,null,null,3]
[null,null,"Choose drop down descriptors as appropriate",null,null,null,null,"Choose drop down descriptors as appropriate"]
[null,"Depth (m)","Condition","Size","Material"," with ","Depth (m)","Condition","Size","Material","with "]
[null,0,null,null,null,null,0]
[null,{"$f":"B175+0.1","v":0.1},null,null,null,null,{"$f":"G175+0.1","v":0.1}]
[null,{"$f":"B176+0.1","v":0.2},null,null,null,null,{"$f":"G176+0.1","v":0.2}]
[null,0.30000000000000004,null,null,null,null,0.30000000000000004]
[null,0.4,null,null,null,null,0.4]
[null,0.5,null,null,null,null,0.5]
[null,0.6,null,null,null,null,0.6]
[null,0.7,null,null,null,null,0.7]
[null,0.79999999999999993,null,null,null,null,0.79999999999999993]
[null,0.89999999999999991,null,null,null,null,0.89999999999999991]
[null,0.99999999999999989,null,null,null,null,0.99999999999999989]
[null,1.0999999999999999,null,null,null,null,1.0999999999999999]
[null,1.2,null,null,null,null,1.2]
[null,1.3,null,null,null,null,1.3]
[null,1.4000000000000001,null,null,null,null,1.4000000000000001]
[null,1.5000000000000002,null,null,null,null,1.5000000000000002]
[null,1.6000000000000003,null,null,null,null,1.6000000000000003]
[null,1.7000000000000004,null,null,null,null,1.7000000000000004]
[null,1.8000000000000005,null,null,null,null,1.8000000000000005]
[null,1.9000000000000006,null,null,null,null,1.9000000000000006]
[null,2.0000000000000004,null,null,null,null,2.0000000000000004]
[null,2.1000000000000005,null,null,null,null,2.1000000000000005]
[null,2.2000000000000006,null,null,null,null,2.2000000000000006]
[null,2.3000000000000007,null,null,null,null,2.3000000000000007]
[null,2.4000000000000008,null,null,null,null,2.4000000000000008]
[null,2.5000000000000009,null,null,null,null,2.5000000000000009]
[null,2.600000000000001,null,null,null,null,2.600000000000001]
[null,2.7000000000000011,null,null,null,null,2.7000000000000011]
[null,2.8000000000000012,null,null,null,null,2.8000000000000012]
[null,2.9000000000000012,null,null,null,null,2.9000000000000012]
[null,3.0000000000000013,null,null,null,null,3.0000000000000013]
[null,3.1000000000000014,null,null,null,null,3.1000000000000014]
[null,3.2000000000000015,null,null,null,null,3.2000000000000015]
[null,3.3000000000000016,null,null,null,null,3.3000000000000016]
[null,3.4000000000000017,null,null,null,null,3.4000000000000017]
[null,3.5000000000000018,null,null,null,null,3.5000000000000018]
[null,3.6000000000000019,null,null,null,null,3.6000000000000019]
[null,3.700000000000002,null,null,null,null,3.700000000000002]
[null,3.800000000000002,null,null,null,null,3.800000000000002]
[null,3.9000000000000021,null,null,null,null,3.9000000000000021]
[null,4.0000000000000018,null,null,null,null,4.0000000000000018]

{"sheet":"Report","index":1,"n_rows":171,"n_cols":22,"rows_kept":171,"cut":false,"hidden":false,"merged":[[74,0,74,24],[85,0,85,24],[86,0,86,24],[87,0,96,24],[84,0,84,24],[106,0,106,24],[105,0,105,24],[107,0,111,24],[100,0,104,24],[99,0,99,24],[97,0,97,24],[98,0,98,24],[81,8,81,24],[82,0,82,5],[82,8,82,24],[16,0,16,24],[62,0,62,24],[64,9,64,24],[65,0,65,24],[66,9,66,24],[36,6,36,24],[37,6,37,24],[39,0,39,24],[40,0,40,24],[41,0,41,24],[32,0,32,5],[42,0,42,24],[43,11,43,24],[44,11,44,24],[33,0,33,5],[37,0,37,5],[36,0,36,5],[35,0,35,5],[34,0,34,5],[38,0,38,22],[17,6,17,24],[18,6,18,24],[19,6,19,24],[20,6,20,24],[164,0,164,22],[0,21,0,24],[0,0,0,20],[1,0,1,24],[2,0,2,24],[3,0,3,24],[4,0,4,24],[5,0,5,24],[6,6,6,24],[7,6,7,24],[8,6,8,24],[9,6,9,24],[10,6,10,24],[11,6,11,24],[12,6,12,24],[13,6,13,24],[14,6,14,24],[15,0,15,24],[71,4,71,6],[72,4,72,6],[73,4,73,6],[63,9,63,22],[32,6,32,24],[33,6,33,24],[69,4,69,6],[70,4,70,6],[69,7,69,8],[70,7,70,8],[71,7,71,8],[66,7,66,8],[67,7,67,8],[68,7,68,8],[67,9,67,24],[68,9,68,24],[69,9,69,24],[10,0,10,5],[23,0,23,22],[6,0,6,5],[7,0,7,5],[8,0,8,5],[9,0,9,5],[11,0,11,5],[12,0,12,5],[30,0,30,5],[24,0,24,5],[25,0,25,5],[26,0,26,5],[27,0,27,5],[28,0,28,5],[29,0,29,5],[13,0,13,5],[14,0,14,5],[21,0,21,5],[21,6,21,24],[24,6,24,24],[25,6,25,24],[26,6,26,24],[27,6,27,24],[29,6,29,24],[115,8,115,11],[117,6,117,7],[115,0,115,7],[114,0,114,7],[75,8,75,24],[75,0,75,5],[76,8,76,24],[76,0,76,5],[77,0,77,5],[77,8,77,24],[78,0,78,5],[78,8,78,24],[79,0,79,5],[79,8,79,24],[80,0,80,5],[80,8,80,24],[81,0,81,5],[115,12,115,24],[116,0,116,24],[117,8,117,24],[60,8,60,24],[68,0,68,3],[17,0,17,5],[22,0,22,22],[28,6,28,24],[72,0,72,3],[72,7,72,8],[73,7,73,8],[73,0,73,3],[34,6,34,24],[35,6,35,24],[31,0,31,5],[30,6,30,24],[31,6,31,24],[18,0,18,5],[19,0,19,5],[20,0,20,5],[70,9,70,24],[71,9,71,24],[72,9,72,24],[73,9,73,24],[66,4,66,6],[67,4,67,6],[68,4,68,6],[117,0,117,5],[114,8,114,11],[112,0,112,24],[113,0,113,24],[114,12,114,24],[50,0,50,5],[51,0,51,5],[52,0,52,5],[53,0,53,5],[54,0,54,5],[55,0,55,5],[56,0,56,5],[57,0,57,5],[67,0,67,3],[58,0,58,5],[59,0,59,5],[60,0,60,5],[61,0,61,5],[61,8,61,24],[83,0,83,5],[83,8,83,24],[63,0,63,5],[64,0,64,5],[59,8,59,24],[69,0,69,3],[70,0,70,3],[71,0,71,3],[169,1,169,9],[170,1,170,9],[165,14,165,22],[166,14,166,22],[167,14,167,22],[168,14,168,22],[169,14,169,22],[170,14,170,22],[165,10,165,13],[166,10,166,13],[167,10,167,13],[168,10,168,13],[169,10,169,13],[170,10,170,13],[165,1,165,9],[166,1,166,9],[167,1,167,9],[168,1,168,9],[118,8,118,18],[120,6,120,7],[120,1,120,5],[43,8,43,10],[43,0,43,5],[44,0,44,5],[44,8,44,10],[45,0,45,5],[45,8,45,10],[46,0,46,5],[46,8,46,10],[49,8,49,24],[49,0,49,5],[45,11,45,24],[47,0,47,24],[46,11,46,24],[48,0,48,24],[50,8,50,24],[51,8,51,24],[52,8,52,24],[53,8,53,24],[54,8,54,24],[55,8,55,24],[56,8,56,24],[57,8,57,24],[58,8,58,24]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INSERT COMPANY LOGO HERE or DELETE TEXT"]
["CIVIL AND STRUCTURAL ENGINEER  INITIAL GEOTECHNICAL ASSESSMENT REPORT"]
["This report identifies soil suitability for the following project and provides a justification of the decision made by the Civil or Structural Engineer that a geotechnical report by a Chartered Professional Engineer (Geotechnical) or Professional Engineering Geologist should not be required."]
[{"$f":"'Field Data Entry'!B3","v":"This document is only an indication of what additional information or expertise may be required. There will always be exeptions to general guidance, and the Structural or Civil Engineer should use their professional judgement in every case to determine the appropriate skills and expertise required for the job.                                                "}]
[{"$f":"'Field Data Entry'!B4","v":"The document is not be to used to report ground investigations and soil assessment for projects with geotechnical risks outside the bounds of competence for a structural engineer."}]
["PROJECT DETAILS"]
["Project Street Address and legal description",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F9),\"\",'Field Data Entry'!F9)","v":""}]
["Client Details",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F10),\"\",'Field Data Entry'!F10)","v":""}]
["Project and site testing locations",null,null,null,null,null,"An image of the site plan including project and testing locations are found in Appendix One"]
["Revision  number",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F12),\"\",'Field Data Entry'!F12)","v":""}]
["Engineering Company Details",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F13),\"\",'Field Data Entry'!F13)","v":""}]
["Prepared by",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F14),\"\",'Field Data Entry'!F14)","v":""}]
["Reviewed by",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F15),\"\",'Field Data Entry'!F15)","v":""}]
["Date",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F16),\"\",'Field Data Entry'!F16)","v":""}]
["Job number",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F17),\"\",'Field Data Entry'!F17)","v":""}]
[]
["SUMMARY OF PROPOSED DEVELOPMENT"]
["Item",null,null,null,null,null,"Comments"]
["Structure type",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F21),\"\",'Field Data Entry'!F21)","v":""}]
["Levels above ground",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F22),\"\",'Field Data Entry'!F22)","v":""}]
["Design Life",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F23),\"\",'Field Data Entry'!F23)","v":""}]
["Importance level",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F24),\"\",'Field Data Entry'!F24)","v":""}]
[]
["SUMMARY OF DESKTOP ASSESSMENT"]
["Item",null,null,null,null,null,"Comments"]
["List  of previous geotechnical reports available",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F28),\"\",'Field Data Entry'!F28)","v":""}]
["Findings of previous geotechnical reports",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F29),\"\",'Field Data Entry'!F29)","v":""}]
["Geological maps available",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F30),\"\",'Field Data Entry'!F30)","v":""}]
["New Zealand Geotechnical Database (NZGD) data nearby (i.e. within ~ 200 m)",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F31),\"\",'Field Data Entry'!F31)","v":""}]
["Geotechnical hazards from council's GIS or equivalent",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F32),\"\",'Field Data Entry'!F32)","v":""}]
["Known geotechnical hazards on the site",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F33),\"\",'Field Data Entry'!F33)","v":""}]
["Minimum floor level and flooding",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F34),\"\",'Field Data Entry'!F34)","v":""}]
["Review of historic aerial photographs – previous HAIL activity / earthworks / building activity at the site?",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F35),\"\",'Field Data Entry'!F35)","v":""}]
["Close-proximity active faults",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F36),\"\",'Field Data Entry'!F36)","v":""}]
["Subsoil class as part of current NZ standard",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F37),\"\",'Field Data Entry'!F37)","v":""}]
["Topographical assessment of the surrounding area",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F38),\"\",'Field Data Entry'!F38)","v":""}]
["Buried services and structures",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F39),\"\",'Field Data Entry'!F39)","v":""}]
["Anticipated engineering geological model from maps and previous investigations and level of uncertainty in the model",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F40),\"\",'Field Data Entry'!F40)","v":""}]
[]
["GROUND INVESTIGATIONS"]
["Investigations Undertaken"]
[{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!F100,'Field Data Entry'!B102,TEXT('Field Data Entry'!C119,\"dd Mmmm yyyy\"),'Field Data Entry'!C102)","v":"undertook the following investigations to evaluate the subsurface conditions at the site on  00 January 1900 . Site plan with test location and site photos can be found in Appendix One, investigation data, graph and soil photos can be found in Appendix Two."}]
["The following tests have been undertaken"]
["Test Type",null,null,null,null,null,"Number of tests","Maximum depth (mBGL)","Average depth (mGBL)",null,null,"Test Standard followed"]
["Scala Penetrometer (minimum required depth 2m or justifiable refusal)",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F50),\"\",'Field Data Entry'!F50)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G50),\"\",'Field Data Entry'!G50)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!H50),\"\",'Field Data Entry'!H50)","v":""},null,null,{"$f":"IF(ISBLANK('Field Data Entry'!I50),\"\",'Field Data Entry'!I50)","v":""}]
["Hand Augur/Test Pit  (minimum required depth 2m or justifiable refusal)",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!F51),\"\",'Field Data Entry'!F51)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G51),\"\",'Field Data Entry'!G51)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!H51),\"\",'Field Data Entry'!H51)","v":""},null,null,{"$f":"IF(ISBLANK('Field Data Entry'!I51),\"\",'Field Data Entry'!I51)","v":""}]
[{"$f":"IF(ISBLANK('Field Data Entry'!C122),\"\",'Field Data Entry'!B122)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!C122),\"\",'Field Data Entry'!F52)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!C122),\"\",'Field Data Entry'!G52)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!C122),\"\",'Field Data Entry'!H52)","v":""},null,null,{"$f":"IF(ISBLANK('Field Data Entry'!C122),\"\",'Field Data Entry'!I52)","v":""}]
["Visual assessments were undertaken in accordance with the NZGS Field Guide for the Description of Soil and Rock, 2005."]
["Investigation Findings"]
["Item",null,null,null,null,null,"Yes","No","Comments"]
["Hazard check",null,null,null,null,null,{"$f":"IF('Field Data Entry'!F57=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F57=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G57),\"\",'Field Data Entry'!G57)","v":""}]
["Desktop study",null,null,null,{"$f":"IF('Field Data Entry'!F58=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F58=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F58=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F58=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G58),\"\",'Field Data Entry'!G58)","v":""}]
["Ground investigations",null,null,null,{"$f":"IF('Field Data Entry'!F59=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F59=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F59=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F59=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G59),\"\",'Field Data Entry'!G59)","v":""}]
["Liquefaction risk (sandy soils, high groundwater)",null,null,null,{"$f":"IF('Field Data Entry'!F60=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F60=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F60=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F60=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G60),\"\",'Field Data Entry'!G60)","v":""}]
["Lateral spread risk",null,null,null,{"$f":"IF('Field Data Entry'!F61=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F61=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F61=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F61=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G61),\"\",'Field Data Entry'!G61)","v":""}]
["Slope stability risk, address both risk of inundation from above as well as global stability and instability from below; referring published hazard maps and local knowledge",null,null,null,{"$f":"IF('Field Data Entry'!F62=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F62=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F62=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F62=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G62),\"\",'Field Data Entry'!G62)","v":""}]
["Expansive soils (refer published maps and local knowledge)",null,null,null,{"$f":"IF('Field Data Entry'!F63=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F63=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F63=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F63=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G63),\"\",'Field Data Entry'!G63)","v":""}]
["Potentially compressible soils (recent alluvial soils (e.g. silts/peats); refer published hazard maps and local knowledge)",null,null,null,{"$f":"IF('Field Data Entry'!F64=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F64=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F64=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F64=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G64),\"\",'Field Data Entry'!G64)","v":""}]
["Minimum 300 kPa ultimate bearing strength established",null,null,null,{"$f":"IF('Field Data Entry'!F65=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F65=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F65=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F65=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G65),\"\",'Field Data Entry'!G65)","v":""}]
["‘Good ground’ per NZS 3604 (latest edition)",null,null,null,{"$f":"IF('Field Data Entry'!F66=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F66=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F66=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F66=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G66),\"\",'Field Data Entry'!G66)","v":""}]
["Flooding risk (refer published hazard maps and local knowledge)",null,null,null,{"$f":"IF('Field Data Entry'!F67=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F67=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F67=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F67=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G67),\"\",'Field Data Entry'!G67)","v":""}]
["Close-proximity active fault risk – has fault location been established / is min offset met?",null,null,null,{"$f":"IF('Field Data Entry'!F68=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F68=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F68=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F68=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G68),\"\",'Field Data Entry'!G68)","v":""}]
[{"$f":"IF(ISBLANK('Field Data Entry'!C122),_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!E117,'Field Data Entry'!G117),_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!E117,'Field Data Entry'!F117,'Field Data Entry'!G117))","v":"Groundwater   test results"}]
["Groundwater level (mbgl)",null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!C118),\"\",_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!I53,'Field Data Entry'!C118,'Field Data Entry'!J53,TEXT('Field Data Entry'!C119,\"dd Mmmm yyyy\"),'Field Data Entry'!I108))","v":""}]
[{"$f":"IF(ISBLANK('Field Data Entry'!C122),\"\",'Field Data Entry'!B122)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!C122),\"\",'Field Data Entry'!C122)","v":""}]
["Geotechnical Risk Assessment"]
["Risk",null,null,null,"Consequence Description",null,null,"Risk L/M/H",null,"Proposed Mitigation"]
[{"$f":"IF(ISBLANK('Field Data Entry'!B72),\"\",'Field Data Entry'!B72)","v":""},null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!D72),\"\",'Field Data Entry'!D72)","v":""},null,null,{"$f":"IF(ISBLANK('Field Data Entry'!H72),\"\",'Field Data Entry'!H72)","v":""},null,{"$f":"IF(ISBLANK('Field Data Entry'!I72),\"\",'Field Data Entry'!I72)","v":""}]
[{"$f":"IF(ISBLANK('Field Data Entry'!B73),\"\",'Field Data Entry'!B73)","v":""},null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!D73),\"\",'Field Data Entry'!D73)","v":""},null,null,{"$f":"IF(ISBLANK('Field Data Entry'!H73),\"\",'Field Data Entry'!H73)","v":""},null,{"$f":"IF(ISBLANK('Field Data Entry'!I73),\"\",'Field Data Entry'!I73)","v":""}]
[{"$f":"IF(ISBLANK('Field Data Entry'!B74),\"\",'Field Data Entry'!B74)","v":""},null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!D74),\"\",'Field Data Entry'!D74)","v":""},null,null,{"$f":"IF(ISBLANK('Field Data Entry'!H74),\"\",'Field Data Entry'!H74)","v":""},null,{"$f":"IF(ISBLANK('Field Data Entry'!I74),\"\",'Field Data Entry'!I74)","v":""}]
[{"$f":"IF(ISBLANK('Field Data Entry'!B75),\"\",'Field Data Entry'!B75)","v":""},null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!D75),\"\",'Field Data Entry'!D75)","v":""},null,null,{"$f":"IF(ISBLANK('Field Data Entry'!H75),\"\",'Field Data Entry'!H75)","v":""},null,{"$f":"IF(ISBLANK('Field Data Entry'!I75),\"\",'Field Data Entry'!I75)","v":""}]
[{"$f":"IF(ISBLANK('Field Data Entry'!B76),\"\",'Field Data Entry'!B76)","v":""},null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!D76),\"\",'Field Data Entry'!D76)","v":""},null,null,{"$f":"IF(ISBLANK('Field Data Entry'!H76),\"\",'Field Data Entry'!H76)","v":""},null,{"$f":"IF(ISBLANK('Field Data Entry'!I76),\"\",'Field Data Entry'!I76)","v":""}]
[{"$f":"IF(ISBLANK('Field Data Entry'!B77),\"\",'Field Data Entry'!B77)","v":""},null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!D77),\"\",'Field Data Entry'!D77)","v":""},null,null,{"$f":"IF(ISBLANK('Field Data Entry'!H77),\"\",'Field Data Entry'!H77)","v":""},null,{"$f":"IF(ISBLANK('Field Data Entry'!I77),\"\",'Field Data Entry'!I77)","v":""}]
[{"$f":"IF(ISBLANK('Field Data Entry'!B78),\"\",'Field Data Entry'!B78)","v":""},null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!D78),\"\",'Field Data Entry'!D78)","v":""},null,null,{"$f":"IF(ISBLANK('Field Data Entry'!H78),\"\",'Field Data Entry'!H78)","v":""},null,{"$f":"IF(ISBLANK('Field Data Entry'!I78),\"\",'Field Data Entry'!I78)","v":""}]
["RECOMMENDATIONS"]
["Item",null,null,null,null,null,"Yes","No","Comments"]
["Planned earthworks",null,null,null,null,null,{"$f":"IF('Field Data Entry'!F85=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F85=\"NO\",\"ü\",\"\")","v":""}]
["Cut and Fill",null,null,null,null,null,{"$f":"IF('Field Data Entry'!F86=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F86=\"NO\",\"ü\",\"\")","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!I86),\" \",_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!G86,'Field Data Entry'!I86,'Field Data Entry'!J86:L86,'Field Data Entry'!G87,'Field Data Entry'!I87,'Field Data Entry'!J87:L87,'Field Data Entry'!G88))","v":" "}]
["Ground improvement/ remediation",null,null,null,null,null,{"$f":"IF('Field Data Entry'!F90=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F90=\"NO\",\"ü\",\"\")","v":""}]
["Foundation recommendations",null,null,null,null,null,{"$f":"IF('Field Data Entry'!F91=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F91=\"NO\",\"ü\",\"\")","v":""}]
["Building restriction zone (BRZ) ",null,null,null,null,null,{"$f":"IF('Field Data Entry'!F92=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F92=\"NO\",\"ü\",\"\")","v":""}]
["Preliminary SW design / control of surface water / groundwater",null,null,null,null,null,{"$f":"IF('Field Data Entry'!F93=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F93=\"NO\",\"ü\",\"\")","v":""}]
["On-site wastewater design required? Any preliminary recommendations.",null,null,null,null,null,{"$f":"IF('Field Data Entry'!F94=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F94=\"NO\",\"ü\",\"\")","v":""}]
["Further investigation/assessments",null,null,null,null,null,{"$f":"IF('Field Data Entry'!F95=\"YES\",\"ü\",\"\")","v":""},{"$f":"IF('Field Data Entry'!F95=\"NO\",\"ü\",\"\")","v":""}]
["This report has been prepared for the client's exclusive use, and it may not be relied on for any other purpose or by any person other than the client without our prior written agreement."]
["Appendix One"]
["SITE PLAN WITH TEST LOCATIONS"]
[" "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Site Photos"]
["Photo One"]
[{"$f":"IF(ISBLANK('Field Data Entry'!C105),\"\",'Field Data Entry'!C105)","v":""}]
[]
[]
[]
[]
[]
["Photo Two"]
[{"$f":"IF(ISBLANK('Field Data Entry'!C106),\"\",'Field Data Entry'!C106)","v":""}]
[]
[]
[]
[]
[]
["APPENDIX TWO"]
[]
["Scala Penetrometer and Augur/Pit Soil Test Results",null,null,null,null,null,null,null,"Date",null,null,null,{"$f":"'Field Data Entry'!F101","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,"Completed by",null,null,null,{"$f":"'Field Data Entry'!F100","v":0}]
[]
["Scala Penetrometer Test Results",null,null,null,null,null,"Augur Soil Tests Results",null,"Scala Penetrometer Test  Summary"]
["TEST NUMBER",{"$f":"'Field Data Entry'!C126","v":1},{"$f":"'Field Data Entry'!D126","v":2},{"$f":"'Field Data Entry'!E126","v":3},{"$f":"'Field Data Entry'!F126","v":4},{"$f":"'Field Data Entry'!G126","v":5},1,2]
["GROUND       LEVEL (m)",{"$f":"IF(ISBLANK('Field Data Entry'!C127),\"\",'Field Data Entry'!C127)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D127),\"\",'Field Data Entry'!D127)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E127),\"\",'Field Data Entry'!E127)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F127),\"\",'Field Data Entry'!F127)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G127),\"\",'Field Data Entry'!G127)","v":""}]
["Depth (m)","Blows/100mm",null,null,null,null,"Soil  Description: NZGS Soil field guide sheet"]
[0,{"$f":"IF(ISBLANK('Field Data Entry'!C129),\"\",'Field Data Entry'!C129)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D129),\"\",'Field Data Entry'!D129)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D129),\"\",'Field Data Entry'!D129)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E129),\"\",'Field Data Entry'!E129)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F129),\"\",'Field Data Entry'!F129)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C175,'Field Data Entry'!$D175,'Field Data Entry'!$E175,'Field Data Entry'!$F175)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H175,'Field Data Entry'!$I175,'Field Data Entry'!$J175,'Field Data Entry'!$K175)","v":""}]
[{"$f":"A122+0.1","v":0.1},{"$f":"IF(ISBLANK('Field Data Entry'!C130),\"\",'Field Data Entry'!C130)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D130),\"\",'Field Data Entry'!D130)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E130),\"\",'Field Data Entry'!E130)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F130),\"\",'Field Data Entry'!F130)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G130),\"\",'Field Data Entry'!G130)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C176,'Field Data Entry'!$D176,'Field Data Entry'!$E176,'Field Data Entry'!$F176)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H176,'Field Data Entry'!$I176,'Field Data Entry'!$J176,'Field Data Entry'!$K176)","v":""}]
[{"$f":"A123+0.1","v":0.2},{"$f":"IF(ISBLANK('Field Data Entry'!C131),\"\",'Field Data Entry'!C131)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D131),\"\",'Field Data Entry'!D131)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E131),\"\",'Field Data Entry'!E131)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F131),\"\",'Field Data Entry'!F131)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G131),\"\",'Field Data Entry'!G131)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C177,'Field Data Entry'!$D177,'Field Data Entry'!$E177,'Field Data Entry'!$F177)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H177,'Field Data Entry'!$I177,'Field Data Entry'!$J177,'Field Data Entry'!$K177)","v":""}]
[0.30000000000000004,{"$f":"IF(ISBLANK('Field Data Entry'!C132),\"\",'Field Data Entry'!C132)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D132),\"\",'Field Data Entry'!D132)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E132),\"\",'Field Data Entry'!E132)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F132),\"\",'Field Data Entry'!F132)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G132),\"\",'Field Data Entry'!G132)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C178,'Field Data Entry'!$D178,'Field Data Entry'!$E178,'Field Data Entry'!$F178)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H178,'Field Data Entry'!$I178,'Field Data Entry'!$J178,'Field Data Entry'!$K178)","v":""}]
[0.4,{"$f":"IF(ISBLANK('Field Data Entry'!C133),\"\",'Field Data Entry'!C133)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D133),\"\",'Field Data Entry'!D133)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E133),\"\",'Field Data Entry'!E133)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F133),\"\",'Field Data Entry'!F133)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G133),\"\",'Field Data Entry'!G133)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C179,'Field Data Entry'!$D179,'Field Data Entry'!$E179,'Field Data Entry'!$F179)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H179,'Field Data Entry'!$I179,'Field Data Entry'!$J179,'Field Data Entry'!$K179)","v":""}]
[0.5,{"$f":"IF(ISBLANK('Field Data Entry'!C134),\"\",'Field Data Entry'!C134)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D134),\"\",'Field Data Entry'!D134)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E134),\"\",'Field Data Entry'!E134)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F134),\"\",'Field Data Entry'!F134)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G134),\"\",'Field Data Entry'!G134)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C180,'Field Data Entry'!$D180,'Field Data Entry'!$E180,'Field Data Entry'!$F180)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H180,'Field Data Entry'!$I180,'Field Data Entry'!$J180,'Field Data Entry'!$K180)","v":""}]
[0.6,{"$f":"IF(ISBLANK('Field Data Entry'!C135),\"\",'Field Data Entry'!C135)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D135),\"\",'Field Data Entry'!D135)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E135),\"\",'Field Data Entry'!E135)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F135),\"\",'Field Data Entry'!F135)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G135),\"\",'Field Data Entry'!G135)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C181,'Field Data Entry'!$D181,'Field Data Entry'!$E181,'Field Data Entry'!$F181)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H181,'Field Data Entry'!$I181,'Field Data Entry'!$J181,'Field Data Entry'!$K181)","v":""}]
[0.7,{"$f":"IF(ISBLANK('Field Data Entry'!C136),\"\",'Field Data Entry'!C136)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D136),\"\",'Field Data Entry'!D136)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E136),\"\",'Field Data Entry'!E136)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F136),\"\",'Field Data Entry'!F136)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G136),\"\",'Field Data Entry'!G136)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C182,'Field Data Entry'!$D182,'Field Data Entry'!$E182,'Field Data Entry'!$F182)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H182,'Field Data Entry'!$I182,'Field Data Entry'!$J182,'Field Data Entry'!$K182)","v":""}]
[0.79999999999999993,{"$f":"IF(ISBLANK('Field Data Entry'!C137),\"\",'Field Data Entry'!C137)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D137),\"\",'Field Data Entry'!D137)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E137),\"\",'Field Data Entry'!E137)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F137),\"\",'Field Data Entry'!F137)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G137),\"\",'Field Data Entry'!G137)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C183,'Field Data Entry'!$D183,'Field Data Entry'!$E183,'Field Data Entry'!$F183)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H183,'Field Data Entry'!$I183,'Field Data Entry'!$J183,'Field Data Entry'!$K183)","v":""}]
[0.89999999999999991,{"$f":"IF(ISBLANK('Field Data Entry'!C138),\"\",'Field Data Entry'!C138)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D138),\"\",'Field Data Entry'!D138)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E138),\"\",'Field Data Entry'!E138)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F138),\"\",'Field Data Entry'!F138)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G138),\"\",'Field Data Entry'!G138)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C184,'Field Data Entry'!$D184,'Field Data Entry'!$E184,'Field Data Entry'!$F184)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H184,'Field Data Entry'!$I184,'Field Data Entry'!$J184,'Field Data Entry'!$K184)","v":""}]
[0.99999999999999989,{"$f":"IF(ISBLANK('Field Data Entry'!C139),\"\",'Field Data Entry'!C139)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D139),\"\",'Field Data Entry'!D139)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E139),\"\",'Field Data Entry'!E139)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F139),\"\",'Field Data Entry'!F139)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G139),\"\",'Field Data Entry'!G139)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C185,'Field Data Entry'!$D185,'Field Data Entry'!$E185,'Field Data Entry'!$F185)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H185,'Field Data Entry'!$I185,'Field Data Entry'!$J185,'Field Data Entry'!$K185)","v":""}]
[1.0999999999999999,{"$f":"IF(ISBLANK('Field Data Entry'!C140),\"\",'Field Data Entry'!C140)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D140),\"\",'Field Data Entry'!D140)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E140),\"\",'Field Data Entry'!E140)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F140),\"\",'Field Data Entry'!F140)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G140),\"\",'Field Data Entry'!G140)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C186,'Field Data Entry'!$D186,'Field Data Entry'!$E186,'Field Data Entry'!$F186)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H186,'Field Data Entry'!$I186,'Field Data Entry'!$J186,'Field Data Entry'!$K186)","v":""}]
[1.2,{"$f":"IF(ISBLANK('Field Data Entry'!C141),\"\",'Field Data Entry'!C141)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D141),\"\",'Field Data Entry'!D141)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E141),\"\",'Field Data Entry'!E141)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F141),\"\",'Field Data Entry'!F141)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G141),\"\",'Field Data Entry'!G141)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C187,'Field Data Entry'!$D187,'Field Data Entry'!$E187,'Field Data Entry'!$F187)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H187,'Field Data Entry'!$I187,'Field Data Entry'!$J187,'Field Data Entry'!$K187)","v":""}]
[1.3,{"$f":"IF(ISBLANK('Field Data Entry'!C142),\"\",'Field Data Entry'!C142)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D142),\"\",'Field Data Entry'!D142)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E142),\"\",'Field Data Entry'!E142)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F142),\"\",'Field Data Entry'!F142)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G142),\"\",'Field Data Entry'!G142)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C188,'Field Data Entry'!$D188,'Field Data Entry'!$E188,'Field Data Entry'!$F188)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H188,'Field Data Entry'!$I188,'Field Data Entry'!$J188,'Field Data Entry'!$K188)","v":""}]
[1.4000000000000001,{"$f":"IF(ISBLANK('Field Data Entry'!C143),\"\",'Field Data Entry'!C143)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D143),\"\",'Field Data Entry'!D143)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E143),\"\",'Field Data Entry'!E143)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F143),\"\",'Field Data Entry'!F143)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G143),\"\",'Field Data Entry'!G143)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C189,'Field Data Entry'!$D189,'Field Data Entry'!$E189,'Field Data Entry'!$F189)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H189,'Field Data Entry'!$I189,'Field Data Entry'!$J189,'Field Data Entry'!$K189)","v":""}]
[1.5000000000000002,{"$f":"IF(ISBLANK('Field Data Entry'!C144),\"\",'Field Data Entry'!C144)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D144),\"\",'Field Data Entry'!D144)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E144),\"\",'Field Data Entry'!E144)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F144),\"\",'Field Data Entry'!F144)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G144),\"\",'Field Data Entry'!G144)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C190,'Field Data Entry'!$D190,'Field Data Entry'!$E190,'Field Data Entry'!$F190)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H190,'Field Data Entry'!$I190,'Field Data Entry'!$J190,'Field Data Entry'!$K190)","v":""}]
[1.6000000000000003,{"$f":"IF(ISBLANK('Field Data Entry'!C145),\"\",'Field Data Entry'!C145)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D145),\"\",'Field Data Entry'!D145)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E145),\"\",'Field Data Entry'!E145)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F145),\"\",'Field Data Entry'!F145)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G145),\"\",'Field Data Entry'!G145)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C191,'Field Data Entry'!$D191,'Field Data Entry'!$E191,'Field Data Entry'!$F191)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H191,'Field Data Entry'!$I191,'Field Data Entry'!$J191,'Field Data Entry'!$K191)","v":""}]
[1.7000000000000004,{"$f":"IF(ISBLANK('Field Data Entry'!C146),\"\",'Field Data Entry'!C146)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D146),\"\",'Field Data Entry'!D146)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E146),\"\",'Field Data Entry'!E146)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F146),\"\",'Field Data Entry'!F146)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G146),\"\",'Field Data Entry'!G146)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C192,'Field Data Entry'!$D192,'Field Data Entry'!$E192,'Field Data Entry'!$F192)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H192,'Field Data Entry'!$I192,'Field Data Entry'!$J192,'Field Data Entry'!$K192)","v":""}]
[1.8000000000000005,{"$f":"IF(ISBLANK('Field Data Entry'!C147),\"\",'Field Data Entry'!C147)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D147),\"\",'Field Data Entry'!D147)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E147),\"\",'Field Data Entry'!E147)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F147),\"\",'Field Data Entry'!F147)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G147),\"\",'Field Data Entry'!G147)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C193,'Field Data Entry'!$D193,'Field Data Entry'!$E193,'Field Data Entry'!$F193)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H193,'Field Data Entry'!$I193,'Field Data Entry'!$J193,'Field Data Entry'!$K193)","v":""}]
[1.9000000000000006,{"$f":"IF(ISBLANK('Field Data Entry'!C148),\"\",'Field Data Entry'!C148)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D148),\"\",'Field Data Entry'!D148)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E148),\"\",'Field Data Entry'!E148)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F148),\"\",'Field Data Entry'!F148)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G148),\"\",'Field Data Entry'!G148)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C194,'Field Data Entry'!$D194,'Field Data Entry'!$E194,'Field Data Entry'!$F194)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H194,'Field Data Entry'!$I194,'Field Data Entry'!$J194,'Field Data Entry'!$K194)","v":""}]
[2.0000000000000004,{"$f":"IF(ISBLANK('Field Data Entry'!C149),\"\",'Field Data Entry'!C149)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D149),\"\",'Field Data Entry'!D149)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E149),\"\",'Field Data Entry'!E149)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F149),\"\",'Field Data Entry'!F149)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G149),\"\",'Field Data Entry'!G149)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C195,'Field Data Entry'!$D195,'Field Data Entry'!$E195,'Field Data Entry'!$F195)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H195,'Field Data Entry'!$I195,'Field Data Entry'!$J195,'Field Data Entry'!$K195)","v":""}]
[2.1000000000000005,{"$f":"IF(ISBLANK('Field Data Entry'!C150),\"\",'Field Data Entry'!C150)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D150),\"\",'Field Data Entry'!D150)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E150),\"\",'Field Data Entry'!E150)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F150),\"\",'Field Data Entry'!F150)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G150),\"\",'Field Data Entry'!G150)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C196,'Field Data Entry'!$D196,'Field Data Entry'!$E196,'Field Data Entry'!$F196)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H196,'Field Data Entry'!$I196,'Field Data Entry'!$J196,'Field Data Entry'!$K196)","v":""}]
[2.2000000000000006,{"$f":"IF(ISBLANK('Field Data Entry'!C151),\"\",'Field Data Entry'!C151)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D151),\"\",'Field Data Entry'!D151)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E151),\"\",'Field Data Entry'!E151)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F151),\"\",'Field Data Entry'!F151)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G151),\"\",'Field Data Entry'!G151)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C197,'Field Data Entry'!$D197,'Field Data Entry'!$E197,'Field Data Entry'!$F197)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H197,'Field Data Entry'!$I197,'Field Data Entry'!$J197,'Field Data Entry'!$K197)","v":""}]
[{"$f":"A144+0.1","v":2.3000000000000007},{"$f":"IF(ISBLANK('Field Data Entry'!C152),\"\",'Field Data Entry'!C152)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D152),\"\",'Field Data Entry'!D152)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E152),\"\",'Field Data Entry'!E152)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F152),\"\",'Field Data Entry'!F152)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G152),\"\",'Field Data Entry'!G152)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C198,'Field Data Entry'!$D198,'Field Data Entry'!$E198,'Field Data Entry'!$F198)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H198,'Field Data Entry'!$I198,'Field Data Entry'!$J198,'Field Data Entry'!$K198)","v":""}]
[2.4000000000000008,{"$f":"IF(ISBLANK('Field Data Entry'!C153),\"\",'Field Data Entry'!C153)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D153),\"\",'Field Data Entry'!D153)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E153),\"\",'Field Data Entry'!E153)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F153),\"\",'Field Data Entry'!F153)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G153),\"\",'Field Data Entry'!G153)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C199,'Field Data Entry'!$D199,'Field Data Entry'!$E199,'Field Data Entry'!$F199)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H199,'Field Data Entry'!$I199,'Field Data Entry'!$J199,'Field Data Entry'!$K199)","v":""}]
[2.5000000000000009,{"$f":"IF(ISBLANK('Field Data Entry'!C154),\"\",'Field Data Entry'!C154)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D154),\"\",'Field Data Entry'!D154)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E154),\"\",'Field Data Entry'!E154)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F154),\"\",'Field Data Entry'!F154)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G154),\"\",'Field Data Entry'!G154)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C200,'Field Data Entry'!$D200,'Field Data Entry'!$E200,'Field Data Entry'!$F200)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H200,'Field Data Entry'!$I200,'Field Data Entry'!$J200,'Field Data Entry'!$K200)","v":""}]
[2.600000000000001,{"$f":"IF(ISBLANK('Field Data Entry'!C155),\"\",'Field Data Entry'!C155)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D155),\"\",'Field Data Entry'!D155)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E155),\"\",'Field Data Entry'!E155)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F155),\"\",'Field Data Entry'!F155)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G155),\"\",'Field Data Entry'!G155)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C201,'Field Data Entry'!$D201,'Field Data Entry'!$E201,'Field Data Entry'!$F201)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H201,'Field Data Entry'!$I201,'Field Data Entry'!$J201,'Field Data Entry'!$K201)","v":""}]
[2.7000000000000011,{"$f":"IF(ISBLANK('Field Data Entry'!C156),\"\",'Field Data Entry'!C156)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D156),\"\",'Field Data Entry'!D156)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E156),\"\",'Field Data Entry'!E156)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F156),\"\",'Field Data Entry'!F156)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G156),\"\",'Field Data Entry'!G156)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C202,'Field Data Entry'!$D202,'Field Data Entry'!$E202,'Field Data Entry'!$F202)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H202,'Field Data Entry'!$I202,'Field Data Entry'!$J202,'Field Data Entry'!$K202)","v":""}]
[2.8000000000000012,{"$f":"IF(ISBLANK('Field Data Entry'!C157),\"\",'Field Data Entry'!C157)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D157),\"\",'Field Data Entry'!D157)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E157),\"\",'Field Data Entry'!E157)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F157),\"\",'Field Data Entry'!F157)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G157),\"\",'Field Data Entry'!G157)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C203,'Field Data Entry'!$D203,'Field Data Entry'!$E203,'Field Data Entry'!$F203)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H203,'Field Data Entry'!$I203,'Field Data Entry'!$J203,'Field Data Entry'!$K203)","v":""}]
[2.9000000000000012,{"$f":"IF(ISBLANK('Field Data Entry'!C158),\"\",'Field Data Entry'!C158)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D158),\"\",'Field Data Entry'!D158)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E158),\"\",'Field Data Entry'!E158)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F158),\"\",'Field Data Entry'!F158)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G158),\"\",'Field Data Entry'!G158)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C204,'Field Data Entry'!$D204,'Field Data Entry'!$E204,'Field Data Entry'!$F204)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H204,'Field Data Entry'!$I204,'Field Data Entry'!$J204,'Field Data Entry'!$K204)","v":""}]
[3.0000000000000013,{"$f":"IF(ISBLANK('Field Data Entry'!C159),\"\",'Field Data Entry'!C159)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D159),\"\",'Field Data Entry'!D159)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E159),\"\",'Field Data Entry'!E159)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F159),\"\",'Field Data Entry'!F159)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G159),\"\",'Field Data Entry'!G159)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C205,'Field Data Entry'!$D205,'Field Data Entry'!$E205,'Field Data Entry'!$F205)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H205,'Field Data Entry'!$I205,'Field Data Entry'!$J205,'Field Data Entry'!$K205)","v":""}]
[3.1000000000000014,{"$f":"IF(ISBLANK('Field Data Entry'!C160),\"\",'Field Data Entry'!C160)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D160),\"\",'Field Data Entry'!D160)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E160),\"\",'Field Data Entry'!E160)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F160),\"\",'Field Data Entry'!F160)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G160),\"\",'Field Data Entry'!G160)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C206,'Field Data Entry'!$D206,'Field Data Entry'!$E206,'Field Data Entry'!$F206)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H206,'Field Data Entry'!$I206,'Field Data Entry'!$J206,'Field Data Entry'!$K206)","v":""}]
[3.2000000000000015,{"$f":"IF(ISBLANK('Field Data Entry'!C161),\"\",'Field Data Entry'!C161)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D161),\"\",'Field Data Entry'!D161)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E161),\"\",'Field Data Entry'!E161)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F161),\"\",'Field Data Entry'!F161)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G161),\"\",'Field Data Entry'!G161)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C207,'Field Data Entry'!$D207,'Field Data Entry'!$E207,'Field Data Entry'!$F207)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H207,'Field Data Entry'!$I207,'Field Data Entry'!$J207,'Field Data Entry'!$K207)","v":""}]
[3.3000000000000016,{"$f":"IF(ISBLANK('Field Data Entry'!C162),\"\",'Field Data Entry'!C162)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D162),\"\",'Field Data Entry'!D162)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E162),\"\",'Field Data Entry'!E162)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F162),\"\",'Field Data Entry'!F162)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G162),\"\",'Field Data Entry'!G162)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C208,'Field Data Entry'!$D208,'Field Data Entry'!$E208,'Field Data Entry'!$F208)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H208,'Field Data Entry'!$I208,'Field Data Entry'!$J208,'Field Data Entry'!$K208)","v":""}]
[3.4000000000000017,{"$f":"IF(ISBLANK('Field Data Entry'!C163),\"\",'Field Data Entry'!C163)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D163),\"\",'Field Data Entry'!D163)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E163),\"\",'Field Data Entry'!E163)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F163),\"\",'Field Data Entry'!F163)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G163),\"\",'Field Data Entry'!G163)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C209,'Field Data Entry'!$D209,'Field Data Entry'!$E209,'Field Data Entry'!$F209)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H209,'Field Data Entry'!$I209,'Field Data Entry'!$J209,'Field Data Entry'!$K209)","v":""}]
[3.5000000000000018,{"$f":"IF(ISBLANK('Field Data Entry'!C164),\"\",'Field Data Entry'!C164)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D164),\"\",'Field Data Entry'!D164)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E164),\"\",'Field Data Entry'!E164)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F164),\"\",'Field Data Entry'!F164)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G164),\"\",'Field Data Entry'!G164)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C210,'Field Data Entry'!$D210,'Field Data Entry'!$E210,'Field Data Entry'!$F210)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H210,'Field Data Entry'!$I210,'Field Data Entry'!$J210,'Field Data Entry'!$K210)","v":""}]
[3.6000000000000019,{"$f":"IF(ISBLANK('Field Data Entry'!C165),\"\",'Field Data Entry'!C165)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D165),\"\",'Field Data Entry'!D165)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E165),\"\",'Field Data Entry'!E165)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F165),\"\",'Field Data Entry'!F165)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G165),\"\",'Field Data Entry'!G165)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C211,'Field Data Entry'!$D211,'Field Data Entry'!$E211,'Field Data Entry'!$F211)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H211,'Field Data Entry'!$I211,'Field Data Entry'!$J211,'Field Data Entry'!$K211)","v":""}]
[3.700000000000002,{"$f":"IF(ISBLANK('Field Data Entry'!C166),\"\",'Field Data Entry'!C166)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D166),\"\",'Field Data Entry'!D166)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E166),\"\",'Field Data Entry'!E166)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F166),\"\",'Field Data Entry'!F166)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G166),\"\",'Field Data Entry'!G166)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C212,'Field Data Entry'!$D212,'Field Data Entry'!$E212,'Field Data Entry'!$F212)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H212,'Field Data Entry'!$I212,'Field Data Entry'!$J212,'Field Data Entry'!$K212)","v":""}]
[3.800000000000002,{"$f":"IF(ISBLANK('Field Data Entry'!C167),\"\",'Field Data Entry'!C167)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D167),\"\",'Field Data Entry'!D167)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E167),\"\",'Field Data Entry'!E167)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F167),\"\",'Field Data Entry'!F167)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G167),\"\",'Field Data Entry'!G167)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C213,'Field Data Entry'!$D213,'Field Data Entry'!$E213,'Field Data Entry'!$F213)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H213,'Field Data Entry'!$I213,'Field Data Entry'!$J213,'Field Data Entry'!$K213)","v":""}]
[3.9000000000000021,{"$f":"IF(ISBLANK('Field Data Entry'!C168),\"\",'Field Data Entry'!C168)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D168),\"\",'Field Data Entry'!D168)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E168),\"\",'Field Data Entry'!E168)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F168),\"\",'Field Data Entry'!F168)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G168),\"\",'Field Data Entry'!G168)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C214,'Field Data Entry'!$D214,'Field Data Entry'!$E214,'Field Data Entry'!$F214)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H214,'Field Data Entry'!$I214,'Field Data Entry'!$J214,'Field Data Entry'!$K214)","v":""}]
[4.0000000000000018,{"$f":"IF(ISBLANK('Field Data Entry'!C169),\"\",'Field Data Entry'!C169)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!D169),\"\",'Field Data Entry'!D169)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!E169),\"\",'Field Data Entry'!E169)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!F169),\"\",'Field Data Entry'!F169)","v":""},{"$f":"IF(ISBLANK('Field Data Entry'!G169),\"\",'Field Data Entry'!G169)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$C215,'Field Data Entry'!$D215,'Field Data Entry'!$E215,'Field Data Entry'!$F215)","v":""},{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$H215,'Field Data Entry'!$I215,'Field Data Entry'!$J215,'Field Data Entry'!$K215)","v":""}]
[]
[]
["Hand Augur/Test Pit Soil Photos and Results"]
["No.","Photo",null,null,null,null,null,null,null,null,"Depth mm",null,null,null,"Consistancy"]
[{"$f":"IF(ISBLANK('Field Data Entry'!B111),\" \",'Field Data Entry'!B111)","v":1},{"$f":"IF(ISBLANK('Field Data Entry'!B111), \"\",\"insert photo\")","v":"insert photo"},null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!D111),\" \",_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$B$116,'Field Data Entry'!C111,'Field Data Entry'!$C$116,'Field Data Entry'!D111,'Field Data Entry'!D116))","v":" "},null,null,null,{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!E111,'Field Data Entry'!F111,'Field Data Entry'!G111,'Field Data Entry'!H111)","v":""}]
[{"$f":"IF(ISBLANK('Field Data Entry'!B112),\" \",'Field Data Entry'!B112)","v":" "},{"$f":"IF(ISBLANK('Field Data Entry'!B112), \"\",\"insert photo\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!D112),\" \",_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$B$116,'Field Data Entry'!C112,'Field Data Entry'!$C$116,'Field Data Entry'!D112,'Field Data Entry'!D116))","v":" "},null,null,null,{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!E112,'Field Data Entry'!F112,'Field Data Entry'!G112,'Field Data Entry'!H112)","v":""}]
[{"$f":"IF(ISBLANK('Field Data Entry'!B113),\" \",'Field Data Entry'!B113)","v":" "},{"$f":"IF(ISBLANK('Field Data Entry'!B113), \"\",\"insert photo\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!D113),\" \",_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$B$116,'Field Data Entry'!C113,'Field Data Entry'!$C$116,'Field Data Entry'!D113,'Field Data Entry'!D116))","v":" "},null,null,null,{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!E113,'Field Data Entry'!F113,'Field Data Entry'!G113,'Field Data Entry'!H113)","v":""}]
[{"$f":"IF(ISBLANK('Field Data Entry'!B114),\" \",'Field Data Entry'!B114)","v":" "},{"$f":"IF(ISBLANK('Field Data Entry'!B114), \"\",\"insert photo\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!D114),\" \",_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$B$116,'Field Data Entry'!C114,'Field Data Entry'!$C$116,'Field Data Entry'!D114,'Field Data Entry'!D116))","v":" "},null,null,null,{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!E114,'Field Data Entry'!F114,'Field Data Entry'!G114,'Field Data Entry'!H114)","v":""}]
[{"$f":"IF(ISBLANK('Field Data Entry'!B115),\" \",'Field Data Entry'!B115)","v":" "},{"$f":"IF(ISBLANK('Field Data Entry'!B115), \"\",\"insert photo\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Field Data Entry'!D115),\" \",_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!$B$116,'Field Data Entry'!C115,'Field Data Entry'!$C$116,'Field Data Entry'!D115,'Field Data Entry'!D116))","v":" "},null,null,null,{"$f":"_xlfn.TEXTJOIN(\" \",,'Field Data Entry'!E115,'Field Data Entry'!F115,'Field Data Entry'!G115,'Field Data Entry'!H115)","v":""}]