The problem must be solved in Excel as desired, including graphics. Thanks in advance. I would appreciate it if you could write down the formulas required to create charts in Excel in detail, in addition to the solution to the question.Q $1$: $(50$ P$.)$

Draw Modified Kent and Park confined and plain concrete model for $f_c=30$ and $f_y=420$MPa

$($longitudinal and transverse reinforcements$)$

Confined Concrete

Where :

${}_0$

is strain at max stress of plain$($unconfined$)$ concrete

K

is strength enhancing factor

$K=1+\frac{{}_s*f_{yh}}{f_c^{\text{'}}}$

ps is transverse reinforcement ratio

${}_s=\frac{A_{sw}}{b_w*s_h}$

$f_{yh},$ is yield strength of transverse reinforcement

$Z_m=\frac{0\mathrm{.}5}{{}_{50u}+\frac{3}{4}{}_s\sqrt[\phantom{2}]{\frac{h}{s_h}}-0\mathrm{.}002K}$

h$"$ width of the concrete core measured to out$/$out of peripheral hoop $(mm)$

$s{h}_h,$ spacing of hoops $(mm)$