Reply to thread

Message

I have maintained a group spreadsheet before and it would serve the purpose. However it can become quite unwieldy with the inflow of data.

My example: [MEDIA=googlesheets]1IkZmIL5lZacWbQC5D4yikbn6o7UJumOQAYtEmrs0zSI[/MEDIA]

If users are given read write access then it will also be at risk of damage. If there's an admin(s) then they can protect it by vetting and adding the data.

A relational database is usually just upfront time and it'll take care of itself. It'll only report on what you're looking for a there's no need for organization or sorting as it finds whatever you're looking for and reports it. With a clear and concise input form it can run forever without manual influence. This of course is a best case option but may be overkill for our hobby. Spreadsheet data can also be added to a database at a later time if it's really successful.

It would certainly be a quick to implement solution and can be searched for particular info. I don't know enough about Excel to implement automation or reporting though.

<blockquote data-quote="jasonsmith" data-source="post: 232993" data-attributes="member: 21792">I have maintained a group spreadsheet before and it would serve the purpose. However it can become quite unwieldy with the inflow of data. My example: [MEDIA=googlesheets]1IkZmIL5lZacWbQC5D4yikbn6o7UJumOQAYtEmrs0zSI[/MEDIA]If users are given read write access then it will also be at risk of damage. If there&#039;s an admin(s) then they can protect it by vetting and adding the data.A relational database is usually just upfront time and it&#039;ll take care of itself. It&#039;ll only report on what you&#039;re looking for a there&#039;s no need for organization or sorting as it finds whatever you&#039;re looking for and reports it. With a clear and concise input form it can run forever without manual influence. This of course is a best case option but may be overkill for our hobby. Spreadsheet data can also be added to a database at a later time if it&#039;s really successful.It would certainly be a quick to implement solution and can be searched for particular info. I don&#039;t know enough about Excel to implement automation or reporting though.</blockquote>

[QUOTE="jasonsmith, post: 232993, member: 21792"] I have maintained a group spreadsheet before and it would serve the purpose. However it can become quite unwieldy with the inflow of data. My example: [MEDIA=googlesheets]1IkZmIL5lZacWbQC5D4yikbn6o7UJumOQAYtEmrs0zSI[/MEDIA] If users are given read write access then it will also be at risk of damage. If there's an admin(s) then they can protect it by vetting and adding the data. A relational database is usually just upfront time and it'll take care of itself. It'll only report on what you're looking for a there's no need for organization or sorting as it finds whatever you're looking for and reports it. With a clear and concise input form it can run forever without manual influence. This of course is a best case option but may be overkill for our hobby. Spreadsheet data can also be added to a database at a later time if it's really successful. It would certainly be a quick to implement solution and can be searched for particular info. I don't know enough about Excel to implement automation or reporting though. [/QUOTE]

Verification