$1).$ Using a spreadsheet, please develop a table that converts the attached boring information into "corrected" blow count information. Please use equation $12\mathrm{.}4$ for the Noo correction and equation $12\mathrm{.}6$ and $12\mathrm{.}7$ for the N$1(60)$ correction. $($hint: see example table below$).$ Please assume an automatic hammer was used with $"1\mathrm{.}2"$ energy correction value and that the bore hole was $6-$inches in diameter$\mathrm{.}2).$ Using the corrected blow count information, please develop your best estimate for reasonable soil strength parameters. Consider the information presented in Table $12\mathrm{.}4$ and equation $12\mathrm{.}4$ for cohesive soils and equations $12\mathrm{.}18,12\mathrm{.}19$ and $12\mathrm{.}20$ for frictional materials. $($hint: add columns to your existing spreadsheet to determine strength parameters. You will have either a friction angle, or a cohesion angle for each N$-$value, not both$).$