UKTC Archive

Not sure what u mean there Scott. Round to 10?

the 12 relates to single stemmed trees being *12 the dia
and multiple stemmed trees being *10 the dia

do you mean using Y for single stem and anything else for multiple?

Thats probably easier way

CS

To: "UK Tree Care" <uktc@xxxxxx.tree-care.info>
Sent: Friday, December 09, 2005 7:24 PM
Subject: Re: BS5837:2005 RPA Calculation

And if you do not always round to 10 it would be quite simple to either

build in a cell with "Y" or "N" as an entry variable and operate on that

condition or alternativey a cell with a numeric value to round to. I

think I like the latter becuase then that variable is right there in the

open not buried in a formula.

SC

----- Original Message -----

From: Chris Skellern

 To: UK Tree Care
 Sent: Friday, December 09, 2005 1:51 PM
 Subject: Re: BS5837:2005 RPA Calculation


 I think you can expand on this and use the logical operators. I dont use
 Excel much but notice that my version has condition testing.

 you could do something like         IF A3=1    true=12    false=10

 (where A3 holds a stem count, and the target cell creates the multiplier)


 then go further towards the end and trim the extent.


            IF A8>15    true=15

 (where A8 is the calculated rad)


 Just an idea



 CS

----- Original Message -----

From: "Hudson, Chris" <C.Hudson@xxxxxxxxxxxxx.gov.uk>

 To: "UK Tree Care" <uktc@xxxxxx.tree-care.info>
 Sent: Friday, December 09, 2005 4:54 PM
 Subject: BS5837:2005 RPA Calculation


 >
 > If anyoneis interested the RPA calculation can be used on an Excel
 > spreadsheet using the following formula
 >
 > =SUM((((A1*12)/1000)^2)*3.142  for single stemmed trees
 >
 > =SUM((((A1*10)/1000)^2)*3.142 for multistemmed trees
 >

> A1 is the result cell so the formula will need to be typed into B1

(which

 > is where you will type in your stem dia (in mm)
 >
 > You will nned separate cells for single and multistemmed trees so just
 > change A1 to A2 or whatever cell you wish to type in your calculation.
 >
 > If you wish I will put a completed table on site
 >
 > Or has someone already done this ?
 >
 > Chris Hudson
 > Senior Arboriculture and Landscape  Officer)
 > Macclesfield Borough Council
 > Town Hall
 > Macclesfield
 > Cheshire
 > SK10 1DP
 > ' 01625 504664
 > 7  01625 504675
 > *  c.hudson@xxxxxxxxxxxxx.gov.uk
 >
 >
 >

>

***********************************************************************************

> The information in this Email and any attachments is personal to

the

> sender and the views of the author may not necessarily reflect

those

> of Macclesfield Borough Council. The information is strictly

confidential

 > and is intended only for the named person or organisation to whom it is

> addressed as it may contain privileged and confidential information.

If

 > you  are not the  intended recipient  do not  copy, distribute  or use
 > this

> Email, and please notify the sender. Please note that we

cannot

 > guarantee  that this message or any attachment is virus free or has not
 > been intercepted and amended.

>

***********************************************************************************

 >
 >

> --

> The UK Tree Care mailing list

 > To unsubscribe send mailto:uktc-unsubscribe@xxxxxx.tree-care.info
 >
 > The UKTC is supported by The Arbor Centre
 > http://www.arborcentre.co.uk/
 >

--

The UK Tree Care mailing list

 To unsubscribe send mailto:uktc-unsubscribe@xxxxxx.tree-care.info

 The UKTC is supported by The Arbor Centre
 http://www.arborcentre.co.uk/




--
The UK Tree Care mailing list
To unsubscribe send mailto:uktc-unsubscribe@xxxxxx.tree-care.info

The UKTC is supported by The Arbor Centre
http://www.arborcentre.co.uk/

--
The UK Tree Care mailing list
To unsubscribe send mailto:uktc-unsubscribe@xxxxxx.tree-care.info

The UKTC is supported by The Arbor Centre
http://www.arborcentre.co.uk/