ࡱ> LK g2ɀ\p Gareth Draperr Ba==PL,8@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial1 Arial1$Arial1 Arial1Arial1h8Cambria1,8Arial18Arial18Arial1Arial1Arial1<Arial1>Arial1?Arial14Arial14Arial1 Arial1 Arial1Arial1Arial1 Arial1Arial""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.005*0_-""* #,##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\)                                                                      ff + ) , *      P  P         `            a>    ( (  @ @      (  ( (    (   ||Q}<} 00_)ef\([$}<} 00_)ef\([$}<} 00_)ef\([$}<} 00_)ef\([$}<} 00_)ef\([$}<} 00_)ef \([$}<} 00_)L\([$}<} 00_)L\([$}<} 00_)L\([$}<} 00_)L\([$}<} 00_)L\([$}<} 00_)L \([$}<} 00_)23\([$}<} 00_)23\([$}<} 00_)23\([$}<} 00_)23\([$}<}  00_)23\([$}<}! 00_)23 \([$}<}" 00_)\([$}<}# 00_)\([$}<}$ 00_)\([$}<}% 00_)\([$}<}& 00_)\([$}<}' 00_) \([$}<}( 00_)\([$}}) }00_)\([$#,##  }}* 00_)\([$???#,##??? ??? ???}(}/ 00_)}<}1 a00_)\([$}<}2 00_)\([$}<}3 00_)?\([$}<}4 00_)23\([$}(}5 00_)}}7 ??v00_)̙\([$#,##  }<}8 }00_)\([$}<}9 e00_)\([$}x}:00_)\([$#,##  }}; ???00_)\([$???#,##??? ??? ???}-}= 00_)}P}> 00_)\([$#,##}(}? 00_) 20% - Accent1H 20% - Accent1 ef  20% - Accent2H" 20% - Accent2 ef  20% - Accent3H& 20% - Accent3 ef  20% - Accent4H* 20% - Accent4 ef  20% - Accent5H. 20% - Accent5 ef  20% - Accent6H2 20% - Accent6  ef  40% - Accent1H 40% - Accent1 L  40% - Accent2H# 40% - Accent2 L渷  40% - Accent3H' 40% - Accent3 L  40% - Accent4H+ 40% - Accent4 L  40% - Accent5H/ 40% - Accent5 L  40% - Accent6H3 40% - Accent6  Lմ  60% - Accent1H 60% - Accent1 23  60% - Accent2H$ 60% - Accent2 23ږ  60% - Accent3H( 60% - Accent3 23כ  60% - Accent4H, 60% - Accent4 23  60% - Accent5H0 60% - Accent5 23 ! 60% - Accent6H4 60% - Accent6  23  "Accent1<Accent1 O  #Accent2<!Accent2 PM  $Accent3<%Accent3 Y  %Accent4<)Accent4 d  &Accent5<-Accent5 K  'Accent6<1Accent6  F (Bad4Bad  ) Calculation| Calculation  } * Check Cellz Check Cell  ????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextB5Explanatory Text 0 : Followed Hyperlink 1Good6Good  a2 Heading 1B Heading 1 I}O3 Heading 2B Heading 2 I}?4 Heading 3B Heading 3 I}235 Heading 44 Heading 4 I}6( Hyperlink 7InputpInput ̙ ??v 8 Linked CellF Linked Cell } 9Neutral<Neutral  e"Normal :Noteb Note   ;OutputrOutput  ???????????? ???<$Percent =Title1Title I}% >TotalHTotal OO? Warning Text: Warning Text XTableStyleMedium2PivotStyleLight16`P4NOTES TO READ FIRST[both contributions!doutdoor sports space onlylplay areas only,8 <N/AExample of calculations Final Total-STEP 1 Insert number of dwellings in column B"On site or financial contribution?1 bedroom dwelling 1 bedroom 2 bedroom 3 bedroom 4 bedroom5 or more bedrooms2 bedroom dwelling3 bedroom dwelling4 bedroom dwelling5 or more bedrooms dwellingTotals for dwelling typeTOTAL DWELLINGS)contribution towards outdoor sports space2Equipped play areas (where not a local deficiency)STEP 2 Column B, row 14 to 15 will determine if open space needs to be provided on site or a financial contribution in lieu of on site provision is necessaryStep 3 - the totals required for each type of dwelling type will be shown in row 15, with the total financial contribution shown in row 17The thresholds in the Open Space SPD determine based on the number of dwellings if open space is to be provided on site or if a financial contribution in lieu of on site provision is required. The sheets in the spreadsheet have been worked out to show the financial contributions in lieu of on site provision for both outdoor sports space and play space and a separate sheet for play areas only or for outdoor sports space only. Insert the number of dwellings shown in yellow in the relevant spreadsheet to determine the requirements"STEP 2 - Column B, row 13 to 14 will determine if open space needs to be provided on site or a financial contribution in lieu of on site provision is necessary. If facility is to be provided on site, then no financial contribution is required disregard the amounts for that type of facilityStep 3 - the totals required for each type of dwelling type will be shown in row 15, with the total financial contribution shown in row 17. If on site, then no financial contribution will be required and disregard the amountsStep 2 - the totals required for each type of dwelling type will be shown in row 15, with the total financial contribution shown in row 17. If on site, then no financial contribution will be required and disregard the amounts shown."+ ,$-a2"ccB g2ɀ ^ZZ  dMbP?_*+%&?'?(?)?M \\BB-Print01\BH4-8589$ 4dXXdPcKD 4 *##*4 *##* 00000000L -L -2 dd@ ? ?XX0J,X< OffdPcKPD0dPcK'DdPcK NDConfidential 1<" dXX??&cU} , @ P">@7ggD g2ɀ @\c  dMbP?_*+%&?'?(?)?"??&cU} } I} m }  }  } m }  @  @ U@ *@ X@ @ @AAAAAA BCAAAAA A~ DAAAAA A~ D&@AAAAA A~ D&@AAAAA A ~ D@AAAAA A ~ D@AAAAA E#F?@  %!GGGGG H IGGGGG H IGGGGG J H H H H H H KZ G  DD @on site$@financial contributionBfinancial contribution L <D L@ 0D L@G@ wD L@  D L@   D KZ G DD @on site$@financial contributionB on site L M%@  D M@  D M@  D ME@  D EG#N % #N@  % #N@  % #NG@  % #Ny@  % GGGGGGG OG#N0@@  %!GGGG$,$$00000I$$^8  G>@TGB  7ggDh4hRange1 g2ɀ ek  dMbP?_*+%&?'?(?)?"??&cU} } } I  @ 4@ W@ @  ,@ @AAAAAAAAAAAAA BCAAAAA ADAAAAA A~ D&@AAAAA A~ D&@AAAAA A ~ D@AAAAA A ~ DAAAAA E#F:@  %GGGGG H IGGGGG J H H H H H H KZ GDD @on site$@financial contributionBfinancial contribution L  <D L@  0D L@G@  wD L@   D L   D E G# N  % # N@  % # N@G@  % # N@  % # N %  GGGGGGG OG#N @ % wGGGG"$$$0000I$^8$  G    >@  7ggDh4hRange1 g2ɀ ms  dMbP?_*+%&?'?(?)?"??&cU} "} } $ I@ d@ S@ f@ v@  @AAAAAAAAAAAAA BCAAAAA A~ DAAAAA A~ D&@AAAAA A~ D&@AAAAA A ~ D@AAAAA A ~ DAAAAA E#F:@  %GGGGG H IGGGGG H IGGGGG J H H H H H H KZ GDD @on site$@financial contributionBfinancial contribution L M%@  D M@  D M@  D M  D E GN# N%@  % # N@  % # N@  % # N % GGGGGGG OG#N;@ % GGGG$,$$00000I$$^#$  G    >@  7ggDh4hRange1 Oh+'0HPd|  sgallaherSonia GallaherMicrosoft Excel@q@jľ@MOt`՜.+,0, PXx  Bedford Borough Council NOTES TO READ FIRSTboth contributionsoutdoor sports space onlyplay areas only  Worksheets  !"#$%&'()*+,-./0123456789:<=>?@ABDEFGHIJRoot Entry F2&#WorkbooktSummaryInformation(;DocumentSummaryInformation8C