Memory space

[Tracey Stevenson]

Hi

I need to provide caller / officer stats sheets for every working day
of the year, quite a lot of figures for each day. What I was wondering
was, which would be the best use of memory: 52 weekly worksheets, each
with 5 days' worth of figures, or 312 pages each with just 1 day's
worth? We use Excel 2007, if that makes any difference.

Thanks for any advice

Ttacey

 

[Minty Fresh]

Hi Tracey
As each worksheet eats up a certain amount of space for the code required to
tell Excel that it exists, and considering that there is going to be some
redundant data in the form of column/row headings, I think that 52 weekly
sheets will probably consume less memory space.

 

[Jim Thomlinson]

Memory is not going to be an issue. The overhead of a sheet is very minimal.
The bigger concern will be the manageability of the spreadsheet. At 52 tabs
it will be difficult to manage. At 312 it will be darn near impossible.

 

[Tracey Stevenson]

Hi,

Thank you for the reply. I'd decided it would be easier for me to
stick to the 52 / 53 weeks' plan.

Thank you!

Tracey

 

[Tracey Stevenson]

Memory is not going to be an issue. The overhead of a sheet is very minimal.
The bigger concern will be the manageability of the spreadsheet. At 52 tabs
it will be difficult to manage. At 312 it will be darn near impossible.

Hi

Thanks for your reply.

My husband got round this by doing a 52 / 53 week plan, and nameing
each tab "w/c xxxx" where 'xxxx' is the date of the Monday of each
week. He then put a pop-up calendar control on another sheet to select
the appropriate week. He knows nothing about how Excel works its'
memory, though, so couldn't help me.

The 52 week idea is much more manageble, yes. Thanks again!

Tracey