Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Whats the advantages of a database versus my paper system or an Excel spreadsheet?

0
Posted

Whats the advantages of a database versus my paper system or an Excel spreadsheet?

0

For medium and large operations, it’s difficult to manage everything in Excel. With Lodgepole: 1) You are organized: you have one place to enter data, versus several spreadsheets. 2) You can easily do queries: at the click of a button, pull out a list of all the work that needs to be done on several buildings for the year 2012, rather than manually compiling information from several spreadsheets. 3) You can save time: you only need to change the name of a building in one field, vs. all spreadsheets. 4) Your data is connected together: a photo can be shown with the information about a waterline. By leveraging the capabilities of a relational database, Lodgepole is much more powerful. However, if you have a small operation, juggling a handful of spreadsheets becomes more manageable, and we often recommend that you use a spreadsheet system, rather than Lodgepole.

Thanksgiving questions

*Sadly, we had to bring back ads too. Hopefully more targeted.