> .:/ u'ɀ\pjayardle Ba==X/#8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1
Arial1
Arial1Arial1Arial1$Arial1Arial1Arial1Arial1.Arial1Arial1(Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)"$"#,##0;\-"$"#,##0"$"#,##0;[Red]\-"$"#,##0"$"#,##0.00;\-"$"#,##0.00#"$"#,##0.00;[Red]\-"$"#,##0.0050_-"$"* #,##0_-;\-"$"* #,##0_-;_-"$"* "-"_-;_-@_-,'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=8_-"$"* #,##0.00_-;\-"$"* #,##0.00_-;_-"$"* "-"??_-;_-@_-4/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)0.0000
0.000 + ) , * *@ @ / *@ @ *@ @ @ @ @@ @ @ @ @ @
@ @ (@ @ (@ @ / (@ @ "@ @ " @ @
@ @ / @ @ @ @ @ @ / @ @ @ @ @ @ @ @ @ @ ( @ @ . @ @ @ @ @ @
@ @ @ @ / @ @ @ @ . @ @ . " "@ @ . "@ @ @ / " "@@ "@
@@
@
@
@ @ @ "@ @ @@
@
@
@@
@
@
! ! `$t!Snow Calculation Spreadsheet ;6TZR/3A@@/@NMunits/mmDAverage Normal snow water equivalent (mm) measured March 1 annually water equivalent (mm) snow (cm)snow (m)AssumptionsDensityRatio New Snow Compacted Snow5 to 1cm
ratio density!average total compacted snow (cm)width of snow storage area (m)?(Lane width x number of lanes) + (snow storage area width x 2) 1Calculate volume of snow per lineal metre of road'Volume of snow per lineal metre of roadInsert lane width.OCalculate width of storage area assuming a maximum storage height of 2.0 metres)Width of snow storage area is calculated.9Minimum width of R/W to encompass lanes and snow storage.Depth of snow is calculated..Volume of snow per lineal metre is calculated.8Refer to Section 1510.01.01 for more information on R/W.Dof Chapter 1500 of the BC Supplement to TAC Geometric Design Guide. maximum storage height (m) >Insert resort specific value for normal snow water equivalent.NOTE: This is one approach to calculating storage area requirements. Other cross section configurations that can accommodate the calculated snow volume will be considered.CThis spreadsheet is to be used in conjunction with Section 1520.05 P Calculate minimum right-of-way width based on lane and snow storage area width NOTE: Additional storage area for parking accesses can be accommodated over several hundred metres of roadway rather than having one large storage area adjacent to the parking accessConvert normal snow water equivalent (mm) to a total amount of snow (cm) (assume 1 mm water is equal to 1 cm snow) Reduce the volume of snow from a new snow fall density to an average compacted snow density (assuming that new snow is 100 kg/m3 and compacted snow is 500 kg/m3)
100 kg/m3
500 kg/m3
volume of snow to displace (m3)
UUse an normal snow water equivalent (mm) for the entire season measured on March 1st maximum slope angle (ratio)gTotal available storage area assuming that the maximum slope on snow pile can not exceed a 1 to 1 ratiodriveway width (m)@Volume of additional snow to displace due to driveway accesse(s)Bnumber of driveways (must be looked at for each direction)
<Calculate additional snow to displace for parking access(es)STEPGExample for calculating additional storage width for parking access(es)#Cells in purple require user input. OCells in green are calculated and protected to prevent changes in the formulas. PCells in blue are not protected and may vary with justification from developers.
4average total compacted snow converted to metres (m)Alength of roadway over which to distribute snow from accesses (m)\additional width required to accommodate accesses based on length stipulated in cell C38 (m)Ctotal width required over length stipulated in cell C38 (m) average total compacted snow (m)lane width (m)&volume of snow per lineal metre (m3/m)"
#%`width of snow storage area calculated in Step 5 (m)&volume of snow per lineal metre (m3/m)"
#%Insert number and width of access points. Volume of additional snow to displace due to driveway is calculated. Developers may then decide how to deal with this additional volume, based on Section 1520.05, Part III. See Step 8 for example of calculations.Badditional volume of snow to displace as calculated in Step 7 (m3)@
A2additional width required beyond top of 1:1 slope 2additional width required to accommodate accesses A1 = (x1 * MSH)/2
A2 = x2 * MSH
A3 = x3 * MSHx3 =x2 = x1 =2width to maximum storage height at 45 (1:1) slopeASSUMED CROSS SECTION:
F27 (both)E38F38Cell in Above Calc.xtotal ="x1 + x2 + x3 (total storage width)<(only required in situations where driveways/accesses exist)RrpTR
k i
u'ɀ6&(237
dMbP?_*+%M\\cable\P6541?
odXXLetter.HP LaserJet 4100 PCL 62pxe;/Da=|.8±+BBnb,KBe;Qğ@?4Bs|$6Sl94Ȭfd5N&DW&\A;s %NXZdS^H74~=z2;6d9YЇJ~cEGv((&p)II>)FA
}!}'"C4@Y]h\IZ6ȍ#حPH;rz"{ć>l(,_\TGl9BX4N'WRɬ35:Eg+ٔbq_b~TK<9Ǭ!gƃ&l~Z)TBY1Z?[8"KXX??U}}$$}$
}$ }
}
}$ }$ F}$ }
}$ 6;J ;@v@ -
--v-
-h-h--------55-------
F.
!
F/@AAAAA
B,
F0~
"?
X%YYYZ#$
%$~
4@p@
F&$~
)@
U VVVW +,+
*
*
* G
+
.
+
*@p@
$
*@p@ $
#
/@l
$
d
G+0+111G~
)@
U!VVVWG
+
2
+
+
,,
G+
,
+"+,,G+
,
+#
+
,,G
+,
*
*
*
*1G
+,*@p@ $
u;~
3@%/J@DDH#/p=
ף?
Dd
G+,++,,G~
)@
UVVVWG+,1
*6
*5
*7G101111G+
,1~
4y@*p=
ף? $!/tV@!DD
G101111
H~
)@
UVVVW-H+
61
*
*&
*
7G+
,'1/@=?E/I+@
/DDDDDD
G888888G~
9@
OPPPQG8
88883:Cl(@
DD@@
G888888
G~
9@
O+PPPQGD
l00."D.D 8L@LP 8D $2Z 8m$ -!-"#$R@%@')*+@,01;2;3;45; 8
6
;*
;(
;9
;$ G!8
!<)!??> @!:tV@!D'!:tV1@%D!D!D!
!N:!NNNN"~
#9 @
#O-#PPPQ$
$;8
$;2
$;;
$;3
$E4%%'I+@%D~
%Cr@%'tV1@%D!(%DRN?%D%D%D!%Db@D%D%
'\E'\
)[>)[
*[?*[
+J@+J
,JJ
0II
1(C
1D
1RF
2(B
2<2S
3(A
3=
3TG
4ML4T
5(J
5(K
5KH5L&@Z.P*&*.(
dB
s*D@]`EldB
s*D@]`EldB
s*D@]`tEldB
s*D@]` EldB
s*D@] ` EldB
s*D@!!]
`0
E~~b
@
<k*@?
s)-]`k
E
rj
0/@?
)
-]`Erj
0)@?
)
-]`\Ezr2
s*A@"`,--]`Ezz
s*L:kA@"`+R,]`L:k
E
<45<,,ldB
@
s*D@P,-K]`E
0:k
A@"`0,--] `:kE
<length of roadway<cldB
!
s*D@)+]!`0E~vB
"
<D@?&(<]"`E
#
6P;k
A@"`(x@)]#`P;kE
"<#maximum storage height (MSH) = 2 m<"~vB
$@
<LD@?+ZP,]$`$ErjB
%
0D@o-x-x]%`ErjB
&
0D@--]&`pErjB
(
0D@(--](`\E
)
0@@<dr))**''1234!!##7ggD
Oh+'0HPdx
GBONWICK jayardle Microsoft Excel@T@-r@&7pRoot Entry F`J|jq0@WorkbookJSummaryInformation(&DocumentSummaryInformation88
!"#$%'()*+,-1՜.+,D՜.+,h$ PXdlt|
MoTO
Snow Calculation Spreadsheet*'Snow Calculation Spreadsheet'!Print_AreaWorksheets
Named Ranges@T_AdHocReviewCycleID_EmailSubject
_AuthorEmail_AuthorEmailDisplayName_PreviousAdHocReviewCycleIDhhj!1REVISION to Posting Chapter 1500 on the InternetDarwin.Tyacke@gov.bc.caTyacke, Darwin TRAN:EXeet)
!"#$%'()*+,-/012345Root Entry Fˮ7pWorkbookJSummaryInformation(&DocumentSummaryInformation8.Root Entry F[#8p;@WorkbookJSummaryInformation(&DocumentSummaryInformation8
!"#$%'()*+,-<