Is this table tructure good?

[thara05]

I need to create a table to records some information in a excel sheet. So I tried to draft a table like this .

[TABLE="width: 1305"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Code
[/TD]
[TD]Name
[/TD]
[TD]Officer
[/TD]
[TD]Advance[/TD]
[TD]Advance Date[/TD]
[TD]Receive Date[/TD]
[TD="colspan: 6"]Balance Due[/TD]
[/TR]
[TR]
[TD]1st Installment [/TD]
[TD]Collect Date [/TD]
[TD]Receive Date[/TD]
[TD]2nd Installment [/TD]
[TD]Collect Date [/TD]
[TD]Receive Date[/TD]
[/TR]
</tbody>[/TABLE]


So here I would like to get some ideas from professionals about this table structure is good or bad design to record above information?

Any ideas would be greatly appreciated.

Thank you.

 

[swaink]

Morning thara05

Depending on what you will do with the sheet going forward I would try to avoid repeating column names try to make them more unique

All the best

Kevin

 

[thara05]

[TABLE="width: 1279"]
<tbody>[TR]
[TD]Tutor Code
[/TD]
[TD]Tutor Name
[/TD]
[TD]Marcketing Officer[/TD]
[TD]Advance[/TD]
[TD]Advance Date[/TD]
[TD]Receive Date[/TD]
[TD="align: center"]Balance Due
[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]

1st Installment

Collect Date

Receive Date

2nd Installment

Collect Date

Receive Date

<tbody>
</tbody>

[/TD]
[/TR]
</tbody>[/TABLE]


Its not repeat columns. It should be something like that.

 

[swaink]

Hi thara05

Thats better, I also tend to try and shorten the headers but thats up to your preference for example I would use Rxd_Date for Received Date or Coll_Date for Collect Date as so on

When planning the layout of your worksheet consider how you will use it once its completed will you use it simply as a database of data or will you interact with it and create charts.

Kevin