While ISSA A$165$ does provide general guidance for aggregate and emulsified asphalt application

rate in a chip seal treatment, the ranges provided are that only: guidance. However, the actual

application rates are extremely job specific, and may change due to gradation of the aggregate,

traffic, existing road conditions, absorption of aggregate, patches that haven't been sealed, residue

of emulsion, and other inputs. Therefore, it is important to execute an actual chip seal design.

Create and upload a spreadsheet that can calculate the emulsified asphalt quantity, given

the following values:

Quantity of chips from the board test $=30l\frac{b}{f}{t}^2$

Dry loose unit weight of chips $=104l\frac{b}{f}{t}^3$

Dry bulk specific gravity of chips $=2\mathrm{.}15$

Traffic correction factor $=$ chip seal class I, $251-500$ AADT

Pavement surface correction factor $=$ smooth, non$-$porous

Emulsified asphalt residue $=65\%$

Using the spreadsheet, adjust the following values $($as compared to the control design

above$)$ and record the emulsified asphalt quantity. Report the asphalt quantities in a table.

State why the trend you are observing makes sense.

$Q=10,20,30,40,$ and $50$

$T=1\mathrm{.}00,1\mathrm{.}05,1\mathrm{.}10,1\mathrm{.}15,1\mathrm{.}20$

$V=-0\mathrm{.}06,-0\mathrm{.}03,0\mathrm{.}00,+0\mathrm{.}03,+0\mathrm{.}06$

$R=0\mathrm{.}60,0\mathrm{.}65,0\mathrm{.}70$