Memory space

  • Thread starter Thread starter Tracey Stevenson
  • Start date Start date
T

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
 
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.
 
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,

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
 
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.
Click to expand...
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
 
Back
Top