View Single Post
 
Old 03-27-2023, 12:14 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

I strongly advice to drop this design, as it only adds for you problems in future, and it also will be prone for data entry errors (i.e. entering some info into wrong cell).

In case all 120 fields of info per person are different unique type of information, the best solution for data entry sheet will be a single row for every person.

When some of person info can be grouped (especially when the info for such group is usually entered in same time moment), and there is a field which always identifies the user for 100%, you may use a design, where the will be a separate information entry sheet for every such information group, along with column which identifies the person. But remember, this design will make handling your tables more dificcult!

In case some info of same type is repeated in different fields (like different phone numbers, mail addresses, bank accounts, etc.), I strongly advice to enter such info into separate table for every such info type - a separate row for every such information unit.

As the number of information fields is big, you probably need a report sheet, where you can select a person, and the full information about this person is displayed in any format comfortable for viewing/printing (as one possibility, the format which you currently use for data entry). In case you have for whatever reason several information entry sheets, having such report is a must!

Remember, designing a workbook you have to consider:
1. How difficult is entering new data;
2. How difficult is making any calculations on stored data;
3. How comfortable are your data for viewing/printing.

Usually, p.1 and especially p.2 arent compatieble with p.3 - and you can compensate this using report sheets!
Reply With Quote