Visalia Direct: Virtual Valley August 2009 Issue June 30, 2009 Keeping Track of Everything in Your Life Books, DVDs, recipes, birds we’ve seen, and our family trees. My wife and I maintain all sorts of lists and databases to organize our lives. For some lists, a simple spreadsheet or “flat file” database suffices. In other cases, you need a complex “relational” database that can perform all kinds of magic. Choosing the right tool for the task is based on your needs. Using Spreadsheets for Lists A spreadsheet is similar to a columnar book, featuring a giant table into which you can enter text or numeric data. Modern spreadsheets are very good at managing lists and basic tables of data. However, there are limits. For example, the version of Microsoft Excel I use can only store 65,535 rows of data and each row is limited to 256 columns. More importantly, Excel seems to dislike more than 100,000 “populated” cells of data. Though originally developed to analyze numeric data,...
technology • teaching • writing