I recently put all of my light fixture info into an Excel spreadsheet. This works great.  Excel has all kinds of built-in functions that work with Lists which is simply consecutive rows and columns with data.  You can evoke all kind of simple sort and filter functions to reduce a large master fixture schedule down to a schedule for a specific project.  Also, it is great to use a spreadsheet for importing the schedule into AutoCAD.  Some of you may be saying duh!.  I have been doing this for years but I thought I would pass it on for those that have thought about it but never done it.  Has anyone found a better way than using a spreadsheet?