Conduct an unsignalised intersection analysis using the attached spreadsheet shell.

Conduct an unsignalised intersection analysis using the attached spreadsheet shell. • Numbering of the movements in your response must be the same as those shown here. In intersection analysis your spreadsheet, your movement calculations must be ordered in rows from the lowest to highest movement down the page. For each movement clearly carry your calculations in rows right across the spreadsheet and be consistent with placement of these calculations for all movements. • In your spreadsheet, your lane calculations must be ordered in rows according to the following convention: S1, S2, S3; E1, E2; N1, N2, N3; W1, W2. • Use sensible rounding when displaying answers on your spreadsheet (Excel has a displayed rounding tool, while still carrying the values to a high level of significance throughout the calculations). Display o Flow rate to three decimal places, o Probability to three decimal places; o Degree of saturation to two decimal places; o Delay to nearest whole second; o Queue length rounded upwards to nearest whole vehicle