CPT Excel spreadsheet Project is building according with the follows characteristics

.- In the firts spreadsheet you will put the basical data like that: - Boring number - Sampler number - Total Depth (m) - Project name - Location - Coordinates (UTM) - Groundwater level - Water Unit Weigth, w (kN/m3) - “n” factor for normalize the cone tip resistance - Undrained shear strength cone factor for clays, Nkt - Over Consolidation ratio number, kOCR - An another data to be neccesary to input .- Unit will be SI Units (Kn/m) .- You will provide (like to SPT project) a sheet where show the bibliographic references .- Yo'll post in the sheet the different pressures and values data like that: - Depth of every sample (m) - Pore pressure (u), in kPa - Cone resistance (qc), in MPa - Sleeve friction (fr), in kPa .- In the mentioned sheet you will put the various columns where show the calculations for another geotechnical properties according with the depth like that: - Corrected Cone Tip Resistance, qt (MPa) - Normalized Cone Resistence - Normalized Friction Ratio - Normalized Pore Pressure Ratio - Total Unit Weigth, total (kN/m3) - Sumerged or Effective Unit Weigth, sum (kN/m3) - Total Overburden Stress, v (kPa) - Effective Overburden Stress, 'v (kPa) - In Situ Pore Pressure, u0 (kPa) - Normalized Friction Ratio, Fr ( - ) - Friction Ratio, Fr ( % ) - Soil Behaviour Type (several authors and Criteria) - NSPT equivalent (N60 and N1,60) - Undrained Shear Strength, Su (kPa) - Fines content (%) - The “n” factor for normalize the cone tip resistance - Normalized Cone Resistence with “n” factor - Net cone resistance, qn (kPa) - Hydraulic conductivity, k (cm/s) and if do you want in (m/s) - Void ratio, e (-) - Compressibility coefficient, Cc (-) - Relative density, Dr (%) - Maximun and Minimun Young Modulus, E (MPa) - In-Situ Stress Ratio (Ko Condition) - Compressibility, M (MPa) - Clay sensitivity, St ( - ) - Overconsolidation Ratio (OCR) - Friction Angle, Ø (ᴼ) or degrees - Shear Modulus, G (MPa) - Shear wave velocity,Vs (m/s) - Undrained Shear Strength Ratio (Su/’v) - SHANSEP Method for Su, if apply - State parameter - Laboratory Index properties (where apply and there is) like that moisture content, Atterberg Limits, Sieve Analysis, Hydrometer, Unit Weigth, Specific Gravity - Field shear strength and Piezometer data - Cyclic Resistance Ratio, CRR - Cyclic Stress Ratio, CSR - Safety Factor, FS - And another data to be neccesary .- You will make various columns for varios authors in a single properties (please look at my SPT project) .- Another spreadsheet inside in the CPT excel file include the all graphic of the calculations of all data calculated. Also include entry or calculated data vs depth mainly. .- One last sheep is applied to the Soil Behaviour Type (SBT) and Normalized Soil Behavious Type (SBTn) graphics or charts (according Robertson et al. (1986), Robertson et al. (1990) and Robertson et al. (2010), please show how work with colors. .- For last, if you can find additional information in the web or last hour change, put in the CPT Excel spreadsheet and notifies to you