Hi, Alan. We discuss Best Practices at the link below if you'd like to pose
your question the
http://www.proofficedev.com/ ...especially since I don't see that anyone has
yet responded here.

****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Alan" wrote in message
...

Hi All,

Bear with me on this!

I have a large workbook that we use for calculating financial forecasts
for a fleet hire business.

The workbook contains a total of 300 vehicles, and I need to do
calculations of revenue across five years (60 monthly buckets).

Currently there are four revenue lines for each vehicle for each month and
I am doing the following calculation for each:

1) Check that the vehicle has been acquired (picked up from an asset
sheet) - Boolean
2) Check that the vehicle has not been disposed (also from asset sheet) -
Boolean
3) Occupancy rate - Percentage
4) Days in month - Days
5) Daily average rate - $ / day

Multiply those five together to get a $ figure for the month across the
300 vehicles.

The first four of those are the same for each revenue line (consider them
to be Hire, Extras, Insurance Waiver, and Other Bookings).

Obviously each calculation grid is big (300 x 60 = 18,000 calculations).

I could add another calculation area to do just the first four items, and
then refer to that and bring in the fifth item.

If I did that, it would obviously create an additional 18,000 calculation
cells, but it would (theoretically at least) reduce the actual number of
calculations for excel by 3 x 18000 = 54,000 making a net saving of 36,000
calcs.

However, it would also increase the dependency chain for each of the final
calculations by 1.


Question: Is it better to pull the common calculation out of the other
ones, and refer to it (feels like the right thing to do) or should I
prefer a smaller number of calculation cells?

Thanks,
--
Alan.

The views expressed are my own, and not those of my employer or anyone
else associated with me.

My current valid email address is:



This is valid as is. It is not munged, or altered at all.

It will be valid for AT LEAST one month from the date of this post.

If you are trying to contact me after that time,
it MAY still be valid, but may also have been
deactivated due to spam. If so, and you want
to contact me by email, try searching for a
more recent post by me to find my current
email address.

The following is a (probably!) totally unique
and meaningless string of characters that you
can use to find posts by me in a search engine:

ewygchvboocno43vb674b6nq46tvb