Excel Light Fixture Schedule

[hbendillo]

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?

 

[BJC]

I put them on Excel as well. with 256 coulums to play with you can add columns for lumen output, watts and columns for the length, width, height of each room, etc. You can set up the calcs for a room cavity calc and get the number of each fixture you need to get the light levels required.
You also have area and watts so you have your energy calc done as well.
I have sent the blank sheet to lighting vendors and ask them to fill in the data for fixtrues we are using on a project. Most of them do it.