Aggregate Structure It is unlikely that any single aggregate stockpile will have a structure $($i$.$e$.$ gradation$)$ that will satisfy a specific aggregate specification. Therefore, to satisfy a particular aggregate specification, multiple stockpiles are blended together. The blend is defined by the proportion of each of the source stockpiles. On Table $6\mathrm{.}3$ of M$.-2$S$,$ Superpave aggregate specifications are provided for NMAS $37\mathrm{.}5$ mm down to NMAS $4\mathrm{.}75$ mm$.$ The specification for NMAS $25$ mm $(1$ inch$)$ is given in the table below along with the gradations for $4$ source stockpiles. Note that I didn't include the restricted zone in the Superpave specification as it was removed in $2002.$ Using a new Excel woorkbook, design an aggregate structure $($i$.$e$.$ blend$)$ to satisfy the Superpave NMAS $25$ mm $(1$ inch$)$ specification. Use one worksheet for your calculations. Use one worksheet for your $0\mathrm{.}45$ power graph $($i$.$e$.$ save the graph as a worksheet, not within a worksheet$).$ Inclulde a title and axis labels. Plot the control points for the NMAS $25$ mm $(1$ inch$)$ specification on your $0\mathrm{.}45$ power graph. The blend must lie between these control points. Plot the gradations for each of the stockpiles separately on your $0\mathrm{.}45$ power graph. Include a legend with the stockpile plots labeled. On your calculations worksheet, design an aggregate structure using at least two of the stockpiles, such that the gradation of the blend falls within the upper and lower limits of the control points of the specification. Make sure to label input values, columns and rows on your calculations worksheet so that your design is clear for grading. Plot the aggregate structure design on your $0\mathrm{.}45$ power graph. Add a label for the design plot to the legend. $\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $\backslash$multicolumn$\{2\}\{|$c$|\}\{\backslash$multirow$[$b$]\{2\}\{*\}\{$Sieve Sizes$\}\}$ & $\backslash$multicolumn$\{4\}\{|$c$|\}\{$Percent Passing$\}$ & $\backslash$multicolumn$\{2\}\{|$l$|\}\{$NMAS $25$ mm Control Points$\}\backslash \backslash$

$\backslash$hline & & Stockpile $\backslash$#$1$ & Stockpile $\backslash$#$2$ & Stockpile $\backslash$#$3$ & Stockpile $\backslash$#$4$ & Lower & Upper $\backslash \backslash$

$\backslash$hline $0\mathrm{.}075$ mm & No$.200$ & $2\mathrm{.}6$ & $0\mathrm{.}6$ & $0\mathrm{.}8$ & $9\mathrm{.}3$ & $1$ & $7\backslash \backslash$

$\backslash$hline $0\mathrm{.}15$ mm & No$.100$ & $4\mathrm{.}1$ & $1$ & $0\mathrm{.}9$ & $12\mathrm{.}1$ & & $\backslash \backslash$

$\backslash$hline $0\mathrm{.}3$ mm & No$.50$ & $17\mathrm{.}8$ & $1\mathrm{.}2$ & $1$ & $16\mathrm{.}6$ & & $\backslash \backslash$

$\backslash$hline $0\mathrm{.}6$ mm & No$.30$ & $44\mathrm{.}8$ & $1\mathrm{.}3$ & $1\mathrm{.}1$ & $22\mathrm{.}8$ & & $\backslash \backslash$

$\backslash$hline $1\mathrm{.}18$ mm & No$.16$ & $59\mathrm{.}8$ & $1\mathrm{.}3$ & $1\mathrm{.}2$ & $32\mathrm{.}8$ & & $\backslash \backslash$

$\backslash$hline $2\mathrm{.}36$ mm & No$.8$ & $74$ & $1\mathrm{.}4$ & $1\mathrm{.}3$ & $49\mathrm{.}9$ & $19$ & $45\backslash \backslash$

$\backslash$hline $4\mathrm{.}75$ mm & No$.4$ & $96\mathrm{.}5$ & $6\mathrm{.}7$ & $4$ & $80\mathrm{.}8$ & & $\backslash \backslash$

$\backslash$hline $9\mathrm{.}5$ mm & $\backslash (3/8\backslash )$ in & $100$ & $18\mathrm{.}5$ & $40\mathrm{.}3$ & $100$ & & $\backslash \backslash$

$\backslash$hline $12\mathrm{.}5$ mm & $\backslash (1/2\backslash )$ in & $100$ & $26\mathrm{.}3$ & $63$ & $100$ & & $\backslash \backslash$

$\backslash$hline $19$ mm & $\backslash (3/4\backslash )$ in & $100$ & $61\mathrm{.}5$ & $100$ & $100$ & & $90\backslash \backslash$

$\backslash$hline $25$ mm & $1$ in & $100$ & $95\mathrm{.}3$ & $100$ & $100$ & $90$ & $100\backslash \backslash$

$\backslash$hline $37\mathrm{.}5$ mm & $1\mathrm{.}5$ in & $100$ & $100$ & $100$ & $100$ & $100$ & $\backslash \backslash$

$\backslash$hline $50$ mm & $2$ in & $100$ & $100$ & $100$ & $100$ & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$