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