[RESOLVED] Excel Check List Help

[thelocaluk]

Hi,

I am putting together a large check list in excel and the idea is to save the check list to another excel sheet to create a database for future reference. My question is not how to do this but what would be the sensible way to layout the database as all the questions I have on the checklist would mean creating 44 columns of data which seems a bit large?

Attached is the form I plan to use.

Thanks for any help thats out there

[TerryTee]

Hi.

When using Excel as a database you may view each sheet as a table. So if you can group your data into what seems logical tables then you can split it up this way.
However, looking at your data it looks like each row in the ‘questionnaire’ are all one collection of data for one specific occurrence or instance. If this is correct I’d put it all in the same table as separate columns. But you’ll probably end up with 85 columns, since you have both ‘Passes?’ and ‘Comment’ for 40 of them.
Is this too much? Depends on how you intend to use the data later. It’s not a nice way to read the data later, but it will work just fine if you present it in a similar schema to what you have already.

-Terry

[thelocaluk]

Thanks Terry, I've put it all onto one sheet for now.