Sorry I did not make that clear Chris. I was actually referring back to
Bill's post quoted following:
"Yes, but its thoughtful of you Chris. If you set the Format - Cell to no
decimal places it conveniently rounds up the figure to a whole number.
However so
far I've been rounding up to the nearest 10 or so depending on how big the
tree is, and I can't make Excel or Lotus do that for me, especially as I'm a
bit
haphazard with when I decide to round it up or not."
And I tacked that on to your reply.
SC
----- Original Message -----
From: Chris Skellern
To: UK Tree Care
Sent: Friday, December 09, 2005 4:19 PM
Subject: Re: BS5837:2005 RPA Calculation
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
----- Original Message -----
From: "Scott Cullen" <dscottcul@xxxx.net>
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/
--
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/
