The list below is definitely not inclusive.
Bad Hair Days & Nightmares happen when your Team uses a Spreadsheet for a Task that should have been done with a Database.
You spent big money, to buy the wrong tool, wasted everyone's time & corrupted your Data. Ungood.
You spent big money, to buy the wrong tool, wasted everyone's time & corrupted your Data. Ungood.
Nightmare #1 1. Open a spreadsheet 2. Select some columns 3. Sort, then Save 4. Realize that you did not Select all of the columns before you sorted 5. A bad day begins.
Nightmare #3 1. Try to have 4 people work on the same Spreadsheet at the same time. 2. Give up and proceed to Nightmare #4.
Nightmare #2 1. Create a suitable Spreadsheet 2. Distribute to 22 others in - or - out - of your office 3. Ask them to 'fix' any errors 4. Retrieve and try to Consolidate into 1 'corrected file'. 5. Develop a persistent facial tic.
Nightmare #4 1. Pay for 3 more Excel licenses 2. Sigh deeply 3. Proceed to Nightmares #1, #2 and #3.
Use the Right Tool
The error shown on the image below is not possible when you use a database.
Read More
