CE$241$: Intro to CE Materials

Assignments

Program an excel sheet that calculates the weights of all concrete ingredients needed to produce a trial batch for a laboratory study $($column $3$ in image below$).$ A concrete lab can typically produce $0\mathrm{.}5-2f{t}^3$ of concrete at a time. Use the following as input variables $($values of these inputs provided by the user based on mix design method learned in class$).$

a$.$ w$/$c ratio

b$.$ water content

c$.$ air content

d$.$ Aggregate Properties $-$ Specific Gravity, Absorption, Moisture Content

e$.$ Cement specific gravity

f$.$ Coarse aggregate content

g$.$ Volume of concrete needed for trial batching $(0\mathrm{.}5-2\mathrm{.}0f{t}^3)$

Program the excel to use the input values to fill all cells of the table shown below.

$\backslash$table$[[,1,2,3],[$Material$,$Mix Desing assuming SSD condition $($values in $l\frac{b}{c}$uyd $),$Mix Design after moisture corrections $($values in $\frac{?}{?}\frac{b}{c}$uyd $),$Batch Weight for Trial Mixture $($values in lb$/$cu ft$)],[$Cement$,,,],[$Water$,,,],[$Fine Agg.,,,$],[$Coarse Agg.,,,$]]$