lighting database user guide · lighting database overview ... luminaire property sheet ... you to...

of 54

Lighting Database User Guide

<Virtual Environment> 5.9

of 54

Contents

1. Lighting Database Overview............................................................................61.1. Access to the Lighting Database.......................................................................................... 6

1.1.1. Select Light Fitting Command ..................................................................................... 61.1.2. Review Command ....................................................................................................... 71.1.3. Path Command............................................................................................................ 71.1.4. Filters Command ......................................................................................................... 7

2. Dialogue Boxes and Property Sheets .............................................................82.1. Select Light Fitting Dialogue Box ......................................................................................... 8

2.1.1. Database Menu ........................................................................................................... 92.1.2. Edit Menu................................................................................................................... 102.1.3. View Menu................................................................................................................. 102.1.4. List View Panes ......................................................................................................... 112.1.5. Luminaire Label ......................................................................................................... 112.1.6. Lamp Label ................................................................................................................ 112.1.7. Colour Label .............................................................................................................. 112.1.8. Path Button................................................................................................................ 112.1.9. Filter Button ............................................................................................................... 112.1.10. Select System Databases Button.............................................................................. 112.1.11. Polar Curve Display................................................................................................... 11

2.2. Review Database Dialogue Box......................................................................................... 122.2.1. Database Menu ......................................................................................................... 122.2.2. Edit Menu................................................................................................................... 142.2.3. View Menu................................................................................................................. 142.2.4. List of Database Items............................................................................................... 152.2.5. Table Options ............................................................................................................ 152.2.6. Path Button................................................................................................................ 152.2.7. Filter Button ............................................................................................................... 152.2.8. Select System Databases Button.............................................................................. 15

2.3. Database Path Dialogue Box ............................................................................................. 162.3.1. Custom Database Paths List ..................................................................................... 162.3.2. Browse....................................................................................................................... 162.3.3. Remove ..................................................................................................................... 16

2.4. Filters Dialogue Box ........................................................................................................... 172.4.1. Luminaire Use Categories List .................................................................................. 172.4.2. Luminaire Manufacturers List .................................................................................... 182.4.3. Other Luminaire Manufacturers................................................................................. 182.4.4. Description Contains This Text ................................................................................. 182.4.5. Lamp Type Categories List........................................................................................ 182.4.6. Lamp Manufacturers List ........................................................................................... 182.4.7. Other Lamp Manufacturers........................................................................................ 182.4.8. Description Contains This Text ................................................................................. 182.4.9. Project Check Box ..................................................................................................... 182.4.10. System Check Box .................................................................................................... 192.4.11. Custom Check Box.................................................................................................... 192.4.12. Clear All Search Filters Button .................................................................................. 19

2.5. Select System Databases Dialogue Box ........................................................................... 192.6. Luminaire Property Sheet .................................................................................................. 20

2.6.1. Luminaire General Page............................................................................................ 202.6.1.1. Luminaire ID .......................................................................................................... 202.6.1.2. Luminaire is Still Manufactured?........................................................................... 212.6.1.3. Title........................................................................................................................ 212.6.1.4. Type Options ......................................................................................................... 212.6.1.5. Standard Length.................................................................................................... 21

of 54

2.6.1.6. Width ..................................................................................................................... 212.6.1.7. Height .................................................................................................................... 212.6.1.8. Upward Light Output Ratio.................................................................................... 212.6.1.9. Downward Light Output Ratio ............................................................................... 212.6.1.10. Maximum Spacing/Height Ratio ....................................................................... 212.6.1.11. Transverse Spacing/Height Ratio ..................................................................... 212.6.1.12. Lamps per Luminaire ........................................................................................ 212.6.1.13. Luminaire Use Categories List.......................................................................... 222.6.1.14. Luminaire Manufacturer.................................................................................... 222.6.1.15. Luminaire Manufacturers List ........................................................................... 22

2.6.2. Luminaire Valid Lamp Page ...................................................................................... 222.6.2.1. Luminaire ID .......................................................................................................... 232.6.2.2. List of Valid Lamps................................................................................................ 232.6.2.3. Add New Button .................................................................................................... 232.6.2.4. Properties Button .................................................................................................. 23

2.6.3. Luminaire Polar Page ................................................................................................ 242.6.3.1. Data is Valid? ........................................................................................................ 252.6.3.2. Design Attitude...................................................................................................... 252.6.3.3. Edit button ............................................................................................................. 252.6.3.4. Photometry Options .............................................................................................. 252.6.3.5. Show Selected Column Only Check Box.............................................................. 252.6.3.6. Polar Data Grid...................................................................................................... 252.6.3.7. Angles Menu ......................................................................................................... 252.6.3.8. Polar Curve Display .............................................................................................. 26

2.6.4. Luminaire Utilisation Factor Page ............................................................................. 272.6.4.1. Data is Valid? ........................................................................................................ 272.6.4.2. Utilisation Factor List ............................................................................................. 272.6.4.3. Edit Button............................................................................................................. 282.6.4.4. Utilisation Factor Dialogue Box ............................................................................. 28

2.6.5. Uncorrected Glare Indices Page ............................................................................... 282.6.5.1. Data is Valid? ........................................................................................................ 292.6.5.2. Glare Data List ...................................................................................................... 292.6.5.3. Edit Button............................................................................................................. 292.6.5.4. Glare Dialogue Box ............................................................................................... 29

2.7. Valid Lamp Property Sheet ................................................................................................ 292.7.1. Valid Lamp Page ....................................................................................................... 30

2.7.1.1. Luminaire ID .......................................................................................................... 302.7.1.2. Lamps List ............................................................................................................. 302.7.1.3. Watts ..................................................................................................................... 302.7.1.4. VA.......................................................................................................................... 302.7.1.5. Lamp Length ......................................................................................................... 302.7.1.6. Shape Codes List .................................................................................................. 312.7.1.7. Base Area.............................................................................................................. 312.7.1.8. Side Area............................................................................................................... 312.7.1.9. End Area ............................................................................................................... 312.7.1.10. Utilisation Factor Correction Factor .................................................................. 312.7.1.11. Ballast Correction Factor .................................................................................. 31

2.8. Lamp Property Sheet ......................................................................................................... 312.8.1. Lamp General Page .................................................................................................. 32

2.8.1.1. Lamp ID................................................................................................................. 322.8.1.2. Lamp is Still Manufactured?.................................................................................. 322.8.1.3. Title........................................................................................................................ 322.8.1.4. Lamp Type Categories List ................................................................................... 322.8.1.5. Lamp Manufacturer ............................................................................................... 322.8.1.6. Lamp Manufacturers List....................................................................................... 32

2.8.2. Lamp Colours Page................................................................................................... 33

of 54

2.8.2.1. Lamp ID................................................................................................................. 332.8.2.2. Colours List ........................................................................................................... 332.8.2.3. Add New Button .................................................................................................... 332.8.2.4. Properties Button .................................................................................................. 342.8.2.5. Delete Button......................................................................................................... 34

2.9. Colour Property Sheet........................................................................................................ 342.9.1. Colour Page............................................................................................................... 34

2.9.1.1. Lamp ID................................................................................................................. 342.9.1.2. Colour ID ............................................................................................................... 342.9.1.3. Initial Bare-lamp Output ........................................................................................ 342.9.1.4. Lamp-lumen Maintenance Factor Curve List ........................................................ 34

2.10. Lamp-lumen Maintenance Factor Curve Property Sheet .................................................. 342.10.1. Lamp-lumen Maintenance Factor Curve Page.......................................................... 35

2.10.1.1. Reference ......................................................................................................... 362.10.1.2. Title ................................................................................................................... 362.10.1.3. List of Curve Points........................................................................................... 362.10.1.4. Grid Check Box................................................................................................. 362.10.1.5. Print Curve Button............................................................................................. 362.10.1.6. Curve Display.................................................................................................... 362.10.1.7. LLMF/LSF Dialogue Box................................................................................... 37

2.11. Overview Dialogue Box...................................................................................................... 372.12. User Name Dialogue Box................................................................................................... 38

2.12.1. Login ID ..................................................................................................................... 382.12.2. User Name................................................................................................................. 38

2.13. Database Calculations Dialogue Box................................................................................. 392.13.1. Light Output Ratios and Spacing/Height Ratios Button ............................................ 392.13.2. Utilisation Factors Button........................................................................................... 392.13.3. Glare Data Button...................................................................................................... 392.13.4. Aspect Factors Button ............................................................................................... 402.13.5. BZ Classification Button ............................................................................................ 402.13.6. LG3 Checks Button ................................................................................................... 402.13.7. More Detail Check Box.............................................................................................. 402.13.8. Print Output Button .................................................................................................... 402.13.9. Clear Output Button................................................................................................... 402.13.10. Results Area.......................................................................................................... 40

2.14. Batch Calculations Dialogue Box ....................................................................................... 412.15. Batch Edits Dialogue Box................................................................................................... 42

2.15.1. Set Type Check Box.................................................................................................. 422.15.2. Set Use Category Check Box.................................................................................... 422.15.3. Luminaire Use Categories List .................................................................................. 422.15.4. Set Manufacturer Check Box..................................................................................... 422.15.5. Luminaire Manufacturer............................................................................................. 432.15.6. Luminaire Manufacturers List .................................................................................... 43

2.16. Import Dialogue Box........................................................................................................... 43General Import Page................................................................................................................... 44

2.16.1.1. If the ID and Description Both Match an Existing Luminaire Option................. 442.16.1.2. If it is Assumed to be a New Lamp Option ....................................................... 45

2.16.2. IESNA Import Page ................................................................................................... 452.16.2.1. Method for Obtaining the Luminaire and Lamp ID’s and Descriptions Option . 46

2.17. LG3 Dialogue Box .............................................................................................................. 462.17.1. Luminance Limit ........................................................................................................ 472.17.2. Limiting Angle ............................................................................................................ 47

2.18. Import Summary Dialogue Box .......................................................................................... 472.19. Database Summary Dialogue Box ..................................................................................... 482.20. Results Dialogue Box......................................................................................................... 48

2.20.1. Clear Button............................................................................................................... 49

of 54

2.20.2. Print Button ................................................................................................................ 492.20.3. Save Button ............................................................................................................... 49

2.21. Numeric Entry Dialogue Box .............................................................................................. 492.21.1. Prompt ....................................................................................................................... 492.21.2. Numeric Value ........................................................................................................... 49

2.22. Text Entry Dialogue Box .................................................................................................... 492.22.1. Prompt ....................................................................................................................... 502.22.2. Text Value.................................................................................................................. 50

2.23. Visualisation of Photometric Web ...................................................................................... 50

3. Predefined Categories....................................................................................513.1. Luminaire Use Categories.................................................................................................. 513.2. Luminaire Manufacturers ................................................................................................... 513.3. Lamp Type Categories ....................................................................................................... 523.4. Lamp Manufacturers .......................................................................................................... 52

4. Version History ...............................................................................................534.1. Version 12.8.0.9 ................................................................................................................. 534.2. Version 12.8.0.5 ................................................................................................................. 534.3. Version 12.6.0.0 ................................................................................................................. 53

of 54

1. Lighting Database OverviewThe lighting database is stored in IES’ own format, and contains all the dataabout luminaires, lamps and lamp colours required for performing Radiance orFlucsPro calculations. You may edit any of the data, import it from or export it tomanufacturers' data in CIBSE, EULUMDAT or IESNA format files, or performdatabase calculations to produce processed data such as light output ratios andutilisation factors from the raw polar data.

The database can be used to add, delete, edit and store information aboutluminaires and lamps. The information from the database is used by the IESlighting applications (FlucsPro, Radiance, Template Manager, etc.). Anextensive system database is provided but this can be supplemented with yourown data.

Photometric data may be entered into the program either interactively or byimporting data from files in standard CIBSE, EULUMDAT or IESNA formats.The standard CIBSE type-1 and type-2 formats are used and are described inCIBSE TM14. For interactive input you describe the luminaire, the valid lampsfor the luminaire, and polar-curve data for luminous intensities. Optionally, light-output ratios, spacing-to-height ratios, utilisation factors, and glare indices maybe entered. For lamps the lamp description and, optionally, lamp-lumenmaintenance-factor curves are specified.

The database can calculate light-output ratios, spacing-to-height ratios,utilisation factors, glare data and aspect factors and can perform LG3 checksand BZ classifications for a luminaire, based on the polar-curve information. Theresults can be viewed on the screen and output as hard copy if you wish.

The database is not an application that may be run directly, but instead isaccessed via other applications such as LightPro, FlucsPro, Radiance and theTemplate Manager.

1.1. Access to the Lighting Database

These commands are provided as buttons in the applications that use thedatabase.

1.1.1. Select Light Fitting Command

This command is available from several dialogue boxes in the applications that usethe lighting database. The button is named “Select”. It allows you to select theluminaire, lamp, and colour from the database to use for the light fitting. The Selectlight fitting dialogue box is displayed. The selection is made from a list view (as usedin the right-hand pane of Windows Explorer) that allows you to click any of thecolumn headers to sort the data based on the values in that column. In addition you

of 54

may use filters to help when searching for items. Colour coded icons show thesource of the data.

Note you may also edit the database and perform database calculations from thisdialogue box, but only when called from LightPro.

1.1.2. Review Command

This command is available from several dialogue boxes in the applications that usethe lighting database. The button is named “Review”. It allows you to review and editthe database. The Review database dialogue box is displayed. The five databasetables are displayed, allowing you to review the items in the tables. In addition youmay use filters to help when searching for items.

Note you may also edit the database and perform database calculations from thisdialogue box, but only when called from LightPro.

1.1.3. Path Command

This command is available from several dialogue boxes in the applications that usethe lighting database. The button is named “Path”. It allows you to set the list ofcustom folder paths where lighting database files are to be accessed. This allowsyou to access lighting data from different parts of your network in addition to thesystem data and the data within your own project folder. The Database pathdialogue box will open allowing you to browse for and add folders, or to removefolders, from the list of paths.

1.1.4. Filters Command

This command is available from several dialogue boxes in the applications that usethe lighting database. The button is named “Filters”. It allows you to set the filtersthat affect what elements of the lighting database are to be displayed in the lightfitting selection or lighting database review dialogue boxes (Note filters only affectthe display - the program still has internal access to all of the data). The Filtersdialogue box opens, allowing you to enter filters based on type and manufacturercategories, and on whether the data is from the system folder, the custom folders, orthe local project folder.

of 54

2. Dialogue Boxes and Property SheetsThe dialogue boxes and property sheets in the lighting database, and the itemsshown on them, are explained in this section.

2.1. Select Light Fitting Dialogue Box

This dialogue box allows you to select a luminaire, lamp, and colour from threelist views. When a luminaire is selected, the list of lamps is automaticallyupdated to show lamps that are valid for the luminaire, and the polar curve isdisplayed. Similarly, when a lamp is selected, the list of colours is automaticallyupdated to show colours that are valid for the lamp. The column headers maybe clicked to sort on the property listed in that column. Menus are provided fordatabase activities (database path and filters commands, saving the database,importing and exporting CIBSE, EULUMDAT or IESNA data, etc.) editingactivities (add, properties, delete, database calculations) and changing the listview types.

of 54

2.1.1. Database Menu

This menu (identical to the one in the Review database dialogue box) allows you toselect an option for editing the database path and filters:

Path - Allows you to set the list of custom folder paths where lightingdatabase files are to be accessed. This allows you to access lighting datafrom different parts of your network in addition to the system data and thedata within your own project folder. The Database path dialogue box willopen allowing you to browse for and add folders, or to remove folders, fromthe list of paths.

Filters - Allows you to set the filters that affect what elements of the lightingdatabase are to be displayed in the light fitting selection or lighting databasereview dialogue boxes (NB filters only affect the display - the program maystill access all the data). The Filters dialogue box opens, allowing you toenter filters based on type and manufacturer categories, and on whether thedata is from the system folder, the custom folders, or the local project folder.

Overview – Shows the Overview dialogue box that displays a graphicaloverview of the relationships between the database tables.

Save - Save the database to file, with any changes. Note any items that havebeen changed are ALWAYS saved to your project folder, even if that is notwhere they were originally held. Since the project folder is the only placewhere the database is ever saved, the original items may still be present inthe system or custom folders. However, this is not a problem, since theproject folder is always searched first.

Database import - Allows access to the database import options.o CIBSE - Allows you to import CIBSE/1 or CIBSE/2 format luminaire

data files into the database. The import dialogue box is displayed witha single page, the General import page.

o EULUMDAT - Allows you to import EULUMDAT (European LuminaireData) format luminaire data files into the database. The importdialogue box is displayed with a single page, the General importpage.

o IESNA - Allows you to import IESNA format luminaire data files intothe database. The import dialogue box is displayed with two pages,the General import page and the IESNA import page.

Database export - Allows access to the database export options.o CIBSE - Allows you to export CIBSE/1 or CIBSE/2 format luminaire

data files from the database.

of 54

o EULUMDAT - Allows you to export EULUMDAT (European LuminaireData) format luminaire data files from the database.

o IESNA - Allows you to export IESNA format luminaire data files fromthe database.

Summary - Opens the Database summary dialogue box. Exit - Close the dialogue box.

2.1.2. Edit Menu

This menu (not quite identical to the one in the Review database dialogue box)allows you to select an option for editing the database:

Add - Allows you to add an item to the database. A copy of the currentlyselected item is made and you are then allowed to edit it before saving it. Theitem being added depends on the last list you clicked.

Properties - Edit the currently selected item. Delete - Allows you to delete the currently selected item. Calculations - Allows you to perform database calculations on the currently-

selected luminaire. Displays the Database calculations dialogue box (NB onlyfor luminaires).

Copy to project – Copies the selected items from whatever source (Customor System) to the Project database.

Visualise – use a window like the Model Viewer to see the photometric webgenerated by the polar curves.

Note the currently selected item is the item selected in whichever of the three listview panes last had the keyboard focus, i.e. was the last one where you clicked withthe mouse or navigated to with the tab or cursor keys.

2.1.3. View Menu

This menu (identical to the one in the Review database dialogue box) allows you tochange the type of view for the database lists. The option you choose will be appliedto the last list that you clicked in. The 4 options are the same as in Windows Explorer- you may change between large and small icon views, list view or report view:

of 54

Large icons - Select this option to display large icons in the list view. Small icons - Select this option to display small icons in the list view. List - Select this option to display each item on a new line in the list view. Details - Select this option to display full details of each item on a new line in

the list view. Click the column headers to sort the list by the item referred toby the column.

2.1.4. List View Panes

These three list view panes show the currently selected luminaire, valid lamp andcolour. Selecting any item and selecting the edit menu option, or simply double-clicking the item, causes the item’s property sheet to be displayed for review andediting.

2.1.5. Luminaire Label

Shows the selected luminaire.

2.1.6. Lamp Label

Shows the selected valid lamp.

2.1.7. Colour Label

Shows the selected lamp colour.

2.1.8. Path Button

This provides a shortcut to the Database > Path menu option. Selected options areshown in the edit box alongside.

2.1.9. Filter Button

This provides a shortcut to the Database > Filter menu option. Selected options areshown in the edit box alongside.

2.1.10. Select System Databases Button

This allows you to select which system databases to load. Displays the SelectSystem Databases dialogue box.

2.1.11. Polar Curve Display

This shows the polar curves for the selected luminaire. Double-clicking on this plothas the same effect as using the Edit > Visualise menu option.

of 54

2.2. Review Database Dialogue Box

This dialogue box allows you to review all of the data in the lighting database.This data is organised into 5 tables (lists of data) in a relational-style database- e.g. there is a table of luminaires, a table of lamps, and a table of valid lampswhich provides the cross reference between luminaires and the lamps whichare valid for each luminaire. Use the option buttons to select the table that willbe displayed in the list box. The column headers may be clicked to sort on theproperty listed in that column. Menus are provided for database activities(database path and filters commands, saving the database, importing orexporting CIBSE, EULUMDAT or IESNA data, etc.) and editing activities (add,properties, delete, database calculations).

2.2.1. Database Menu

This menu (identical to the one in the Select light fitting dialogue box) allows you toselect an option for editing the database path and filters:

Path - Allows you to set the list of custom folder paths where lighting

of 54

database files are to be accessed. This allows you to access lighting datafrom different parts of your network in addition to the system data and thedata within your own project folder. The Database path dialogue box willopen allowing you to browse for and add folders, or to remove folders, fromthe list of paths.

Filters - Allows you to set the filters that affect what elements of the lightingdatabase are to be displayed in the light fitting selection or lighting databasereview dialogue boxes (NB filters only affect the display - the program maystill access all the data). The Filters dialogue box opens, allowing you toenter filters based on type and manufacturer categories, and on whether thedata is from the system folder, the custom folders, or the local project folder.

Overview – Shows the Overview dialogue box that displays a graphicaloverview of the relationships between the database tables.

Save - Save the database to file, with any changes you have made. Note anyitems which have been changed are ALWAYS saved to your project folder,even if that is not where they were originally held. Since the project folder isthe only place where the database is ever saved, the original items may stillbe present in the system or custom folders. However, this is not a problem,since the project folder is always searched first.

Database import - Allows access to the database import options.o CIBSE - Allows you to import CIBSE/1 or CIBSE/2 format luminaire

data files into the database. The import dialogue box is displayed witha single page, the General import page.

o EULUMDAT - Allows you to import EULUMDAT (European LuminaireData) format luminaire data files into the database. The importdialogue box is displayed with a single page, the General importpage.

o IESNA - Allows you to import IESNA format luminaire data files intothe database. The import dialogue box is displayed with two pages,the General import page and the IESNA import page.

Database export - Allows access to the database export options.o CIBSE - Allows you to export CIBSE/1 or CIBSE/2 format luminaire

data files from the database.o EULUMDAT - Allows you to export EULUMDAT (European Luminaire

Data) format luminaire data files from the database.o IESNA - Allows you to export IESNA format luminaire data files from

the database. Summary - Opens the Database summary dialogue box. Exit - Close the dialogue box.

of 54

2.2.2. Edit Menu

This menu (not quite identical to the one in the Select light fitting dialogue box)allows you to select an option for editing the database:

Add - Allows you to add an item to the database. A copy of the currentlyselected item is made and you are then allowed to edit it before saving it. Theitem being added depends on the last list you clicked.

Properties - Edit the currently selected item. Delete - Allows you to delete the currently selected item. Calculations - Allows you to perform database calculations on the currently-

selected luminaire. Displays the Database calculations dialogue box (NB onlyfor luminaires).

Batch calculations - Allows you to perform database calculations globally onthe currently-selected set of luminaires. The Batch calculations dialogue boxis displayed (NB only works with luminaires).

Batch edits - Allows you to perform database edits globally on the currently-selected set of luminaires. The Batch edits dialogue box is displayed. (NBonly works with luminaires).

Copy to project – Copies the selected items from whatever source (Customor System) to the Project database.

Note the currently selected item is the item selected from the list of database items.

2.2.3. View Menu

This menu (identical to the one in the Select light fitting dialogue box) allows you tochange the type of view for the database lists. The option you choose will be appliedto the last list that you clicked in. The 4 options are the same as in Windows Explorer- you may change between large and small icon views, list view or report view:

Large icons - Select this option to display large icons in the list view. Small icons - Select this option to display small icons in the list view. List - Select this option to display each item on a new line in the list view. Details - Select this option to display full details of each item on a new line in

of 54

the list view. Click the column headers to sort the list by the item referred toby the column.

2.2.4. List of Database Items

This list shows the items in the database for the currently selected database table.Selecting any item in the list and selecting the edit menu option, or simply double-clicking the item, causes the item’s properties to be displayed for review and editing.

2.2.5. Table Options

Select the table you wish to review:

Luminaires option - Selects the luminaires table. Valid lamps option - Selects the valid lamps table. Lamps option - Selects the lamps table. Colours option - Selects the colours table. LLMF/LSF option - Selects the lamp-lumen maintenance factors curves table.

2.2.6. Path Button

This provides a shortcut to the Database > Path menu option. Selected options areshown in the edit box alongside.

2.2.7. Filter Button

This provides a shortcut to the Database > Filter menu option. Selected options areshown in the edit box alongside.

2.2.8. Select System Databases Button

This allows you to select which system databases to load. Displays the SelectSystem Databases dialogue box.

of 54

2.3. Database Path Dialogue Box

This dialogue box allows you to edit the list of custom paths (including UNCnetwork paths such as "\\server\c\lighting\") that are searched for lightingdatabase files. The system files (in the "lights" folder below the IES installationfolder) and the project files (in the "lights" folder below your project folder) areloaded by default. The custom files are loaded according to the set of pathsthat you may edit here. You may make a particular set of paths alwaysavailable by editing "autoexec.bat" to add a line beginning "set FLUCS="followed by a list of folder paths, separated by semicolons, e.g.:

set FLUCS="C:\Program Files\IES\apps\lights\osram";"C:\ProgramFiles\IES\apps\lights\Philips"

(This example would produce the set of paths shown in the diagram).

2.3.1. Custom Database Paths List

This list shows the list of custom database folder paths in effect.

2.3.2. Browse

Allows you to browse for another folder to add to the database path.

2.3.3. Remove

Allows you to remove the selected folder from the database path.

of 54

2.4. Filters Dialogue Box

This dialogue box allows you to set the filters that are applied to the lightingdatabase data for display purposes. It is useful if you have a large list ofluminaires or lamps and wish to see a more relevant subset. Note filters do notaffect the accessible data - only what is displayed in the various dialogueboxes.

2.4.1. Luminaire Use Categories List

Lists the luminaire use categories from which none, one, or more may be selected.The luminaire category is a form of classification, so that particular types of luminairecan be reviewed more easily. See Luminaire use categories for a list of availablecategories.

of 54

2.4.2. Luminaire Manufacturers List

The manufacturer name is the second form of luminaire classification so that thereview procedure can be used more easily. The manufacturer is represented by adescriptive name. See Luminaire manufacturers for a list of available names, but anyadditional strings can be entered in the box below.

2.4.3. Other Luminaire Manufacturers

Enter full or partial manufacturer names if they are not available in the list above.Each name should be entered on a new line by pressing the Return key.

2.4.4. Description Contains This Text

Enter text here for a case-insensitive match with the text in the luminaire description.If you know a word in the description, this will make your search much more efficient.

2.4.5. Lamp Type Categories List

Lists the lamp-type categories from which one may be selected. The lamp-typecategory is a form of classification, so that particular types of lamp can be reviewedmore easily. See Lamp type categories for a list of available categories.

2.4.6. Lamp Manufacturers List

The manufacturer name is the second form of lamp classification so that the reviewprocedure can be used more easily. The manufacturer is represented by adescriptive name. See Luminaire manufacturers for a list of available names, but anyadditional strings can be entered in the box below.

2.4.7. Other Lamp Manufacturers

Enter full or partial manufacturer names if they are not available in the list above.Each name should be entered on a new line by pressing the Return key.

2.4.8. Description Contains This Text

Enter text here for a case-insensitive match with the text in the lamp description. Ifyou know a word in the description, this will make your search much more efficient.

2.4.9. Project Check Box

Select this option to include the project database path (the "lights" folder below yourproject folder) in the filter.

of 54

2.4.10. System Check Box

Select this option to include the system database path (the "lights" folder below thefolder where the IES software is installed) in the filter.

2.4.11. Custom Check Box

Select this option to include the custom database paths (the folders specified usingthe database path command or by the environment variable "FLUCS") in the filter.

2.4.12. Clear All Search Filters Button

Allows you to reset all filters to the default state (i.e. no filters are in effect).

2.5. Select System Databases Dialogue Box

This dialogue box appears when you press the Select System Databasesbutton on the Review dialogue box or the Select Light Fitting dialogue box.

Using this you can easily select which system databases to load. Click toselect an individual item. Use Ctrl and click together to change the selectedstatus of a particular item without changing that of other items – so you canuse this to add or remove items from the list of selected items. Note that someof the databases are always loaded, but the manufacturer-specific databasesare mostly selectable using this mechanism. (Tip: You may even place yourown databases in the system folder, as long as they have unique names. If thelast 17 characters of the name are “(always load).db2” it will be always loaded.)

of 54

2.6. Luminaire Property Sheet

This property sheet is for editing the properties of a luminaire. It has five pages: General page Valid lamps page Polar curves page Utilisation factors page Uncorrected glare indices page

2.6.1. Luminaire General Page

This page allows you to enter the general details required for the luminaire, includingits ID and title, type, dimensions, light output ratios and type and manufacturercategories.

2.6.1.1. Luminaire ID

Enter a unique ID.

of 54

2.6.1.2. Luminaire is Still Manufactured?

Select this box if the item is still manufactured, i.e. still available for use.

2.6.1.3. Title

Enter a title for this luminaire.

2.6.1.4. Type Options

Select the type of luminaire:

Point source option - Select this option to specify that the luminaire may be treatedas a point source - i.e. has negligible area of light source.

Uplighter option - Select this option to specify that the luminaire may be treated asan uplighter - i.e. most of the light output is upwards.

Linear option - Select this option to specify that the luminaire may be treated as alinear luminaire - i.e. has an extended area of light source.

2.6.1.5. Standard Length

The luminaire standard length is the length used for photometry. It is the base for glarecorrections and has a correction factor for polar curves and a utilisation factor of 1.0 and aglare-indices conversion factor of 0.

2.6.1.6. Width

The luminaire width is used to calculate the default luminous base area, which is used inthe detailed glare calculations.

2.6.1.7. Height

The luminaire height is used to calculate the default luminaire side and end areas which areused in the detailed glare calculations.

2.6.1.8. Upward Light Output Ratio

The ratio of the total light output of a luminaire above the horizontal under stated practicalconditions to that of the lamp or lamps under reference conditions.

2.6.1.9. Downward Light Output Ratio

The ratio of the total light output of a luminaire below the horizontal under stated practicalconditions to that of the lamp or lamps under reference conditions.

2.6.1.10. Maximum Spacing/Height Ratio

This ratio describes the distance between luminaire centres in relation to their height abovethe working plane. The maximum spacing-to-height value should not be exceeded if theuniformity of illuminance is to be acceptable for general lighting.

2.6.1.11. Transverse Spacing/Height Ratio

The transverse spacing-to-height ratio ensures that spacing in the transverse directionprovides the illuminance uniformity.

2.6.1.12. Lamps per Luminaire

Enter the number of lamps mounted within the luminaire.

of 54

2.6.1.13. Luminaire Use Categories List

Lists the luminaire use categories from which none, one, or more may be selected. Theluminaire category is a form of classification, so that particular types of luminaire can bereviewed more easily. See Luminaire use categories for a list of available categories.

2.6.1.14. Luminaire Manufacturer

Enter a 2-character manufacturer reference if it is not available in the list below.

2.6.1.15. Luminaire Manufacturers List

The manufacturer name is the second form of luminaire classification so that the reviewprocedure can be used more easily. The manufacturer is represented by a descriptivename. See Luminaire manufacturers for a list of available names, but any other name canbe entered in the box above.

2.6.2. Luminaire Valid Lamp Page

This page allows you to edit the list of valid lamps for the luminaire. This is basicallya list of entries in the valid lamps table, which contains cross-references to theluminaire and lamps tables, with some additional data. When you add or edit a valid

of 54

lamp the Valid lamp page appears which allows you to select a lamp from the lampstable. You may also delete any existing valid lamp.

Any number of valid lamps may be specified for each luminaire. For a linearfluorescent fitting for instance you may wish to define the various lengths, such as1200, 1500 and 1800. Alternatively, a high-bay fitting may be capable of taking aSON lamp or a MBF lamp. For each valid lamp a number of other relevant pieces ofdata are required, such as the length and wattage, which will depend upon the lampbeing used.


Shows the luminaire ID. This is not editable here.

2.6.2.2. List of Valid Lamps

This displays the list of valid lamps for the luminaire.

2.6.2.3. Add New Button

Adds a new colour for the lamp and displays its property sheet.

2.6.2.4. Properties Button

Displays the property sheet for the selected colour.

of 54

2.6.3. Luminaire Polar Page

This page allows you to edit the polar curve data for the luminaire. The polar curvedata is presented in a grid and displayed in the graphic area. Angles may be added,inserted, edited or deleted from the context menu that appears when you click theright mouse button in the shaded area of the grid. The design attitude andphotometry type may also be edited. Individual intensity values may be edited byselecting an intensity value and clicking the right mouse button in the non-shadedarea of the grid. A range of intensity values may be selected and then edited bypressing the Edit button.

Polar-curve data may be measured using the “C-gamma” (C-γ) system, the “Horizontal–Vertical” (H-V) system or the “IESNA Type C” system (see CIBSETechnical Memorandum 14 and IESNA-LM63 for further information on thesesystems).

The C-gamma system allows both point and linear sources to be defined in the samemanner.

A maximum of 72 C (or H) angles and 55 gamma (or V) angles can be defined whenthe data is entered interactively. For example, for a symmetrical luminaire this allowsthe C angles to be in steps of 15 degrees from 0 to 180, and the gamma angles to

of 54

be in steps of 5 degrees from 0 to 180. Such a large number of polar points will allowalmost any type of polar curve to be defined, yet not all values need to be enteredwhen specifying simple symmetrical polar curves. You can define the actual angles;in this way a large number of points can be specified where the curve is rapidlychanging and fewer where the curve is changing little. The luminous intensitiesshould all be expressed in terms of candelas per thousand lumens. Note that if thedata are entered from a standard format file using the database facility, 72 C anglesand 55 gamma angles can be defined.

2.6.3.1. Data is Valid?

Select this box if the polar data is valid for use in calculations.

2.6.3.2. Design Attitude

The design attitude is the angle at which the luminaire is designed to operate. For normalindoor luminaires it is zero.

2.6.3.3. Edit button

If a range of intensities are selected this button will allow you to enter a new value to applyto the whole range. So, for instance, you may select the whole row at gamma=0 and setthem to the same value in one go.

2.6.3.4. Photometry Options

Select the photometry that was used to create this data:

C-gamma option - Most interior luminaires are photometered using the C-gammasystem.

Horizontal-vertical option - Floodlights (due to their intensity distribution) are usuallyphotometered using the horizontal-vertical system.

IESNA Type C option – similar to H-V but differing in the pole direction.

2.6.3.5. Show Selected Column Only Check Box

This check box allows you to turn on or off the display of the selected column (i.e. one C (orHorizontal) angle) of polar intensity values. This is useful if you have defined several C (orHorizontal) angles and want to see the data for individual angles.

2.6.3.6. Polar Data Grid

Displays the numeric values of the polar data. C (or Horizontal) angles are listed along rows1 and 2. Gamma (or Vertical) angles are listed down columns 1 and 2. The body of the gridshows the intensities for the relevant pair of angles (in candelas/1000 lumen). The rightmouse button may be clicked in any of these three areas to edit the angles or intensityvalues.

2.6.3.7. Angles Menu

of 54

This menu is available when you right-click in grid row 1 or column 1, and it allows you toselect an option for editing angles for the polar curve:

Edit angle - Select this option to edit the selected angle. Insert angle - Select this option to insert a new angle at the currently selected

position in the list. Add angle - Select this option to add a new angle at the end of the list. Remove angle - Select this option to remove the selected angle from the list. Visualise – use a window like the Model Viewer to see the photometric web

generated by the polar curves.

2.6.3.8. Polar Curve Display

Displays the polar curves graphically, for confirmation. If the Show selected column onlycheck box is selected, it displays only the column that has the currently selected grid cell:

Double-clicking on this plot has the same effect as using the Angles > Visualise menuoption.

of 54

2.6.4. Luminaire Utilisation Factor Page

Allows you to edit the list of utilisation factors at standard room indices for theluminaire. Individual values may be edited using the Utilisation factor dialogue box.Note it is recommended that you use the database calculations to calculate thesevalues rather than entering them manually here. The utilisation factor is theproportion of luminous flux emitted by the lamps that reaches the working plane. Thefactors should be for zero reflectances for the nominal spacing-to-height ratio at thestandard room indices, as described in CIBSE TM5. Nine values should be enteredin ascending order, to correspond to room indices of 0.75, 1.0, 1.25, 1.5, 2.0, 2.5,3.0, 4.0, and 5.0.


Select this box if the UF data is valid for use in calculations.

2.6.4.2. Utilisation Factor List

Displays the list of utilisation factors for the different room indices. Double-click a row to editit, or select a row and press the Edit button.

of 54

2.6.4.3. Edit Button

Edits the selected row.

2.6.4.4. Utilisation Factor Dialogue Box

Allows you to edit an individual utilisation factor for the luminaire.

2.6.5. Uncorrected Glare Indices Page

This page allows you to edit the uncorrected crosswise and endwise glare indices atthe standard room reflectances. Individual rows may be edited using the Glaredialogue box. Note it is recommended that you use the database calculations tocalculate these values rather than entering them manually here. The indices shouldbe entered for each of the nineteen standard-room dimensions, as described inCIBSE TM10. They should be for ceiling, wall and floor reflectances of 70%, 50%

of 54

and 20% respectively.


Select this box if the glare data is valid for use in calculations.

2.6.5.2. Glare Data List

Lists the glare indices for each set of standard room dimensions. Double-click a row to editit, or select a row and press the Edit button.

2.6.5.3. Edit Button

Edits the selected row.

2.6.5.4. Glare Dialogue Box

Allows you to edit an individual pair of uncorrected crosswise and endwise glare indices forthe luminaire.

Crosswise glare - allows you to edit the crosswise glare index.

Endwise glare - allows you to edit the endwise glare index.

2.7. Valid Lamp Property Sheet

This property sheet is for editing the properties of a lamp-luminaire relationship(referred to as a valid lamp for a luminaire). It has only one page:

Valid lamp page

of 54

2.7.1. Valid Lamp Page

This page gives the details of one valid lamp for a luminaire. It allows you to selectthe lamp from the list of lamps in the database, and to enter the additional datarequired for each luminaire-lamp cross-reference.


Shows the luminaire ID. This is not editable here.

2.7.1.2. Lamps List

Shows the complete list of lamps in the database, from which you must select one to usewith this luminaire.

2.7.1.3. Watts

The luminaire wattage is the TOTAL power consumed by the lamps AND control gear andis used by the program to calculate the total wattage for a particular lighting scheme.

2.7.1.4. VA

The luminaire voltamperes are the apparent power consumed by the luminaire. It is theproduct of the total current input to the luminaire and the supply voltage.

2.7.1.5. Lamp Length

Enter the lamp length in metres.

of 54

2.7.1.6. Shape Codes List

Allows you to select from the list of standard shape codes. Select one of the following glare-shape codes (as defined in the CIBSE Technical Memorandum Number 14):

Rectangular box Sphere Vertical cylinder or flat disc Horizontal cylinder Any other shape Not applicable

2.7.1.7. Base Area

The luminous areas are used by the program when calculating glare indices from basicprinciples. The default base area is the product of the luminaire width and length for thislamp.

2.7.1.8. Side Area

The luminous areas are used by the program when calculating glare indices from basicprinciples. The default side area is the product of the luminaire height and length for thislamp.

2.7.1.9. End Area

The luminous areas are used by the program when calculating glare indices from basicprinciples. The default end area is the product of the luminaire width and height for thislamp.

2.7.1.10. Utilisation Factor Correction Factor

The utilisation-factor correction factor is used to convert the UF data when the standard isnot being used. It is also applied to the polar - curve data.

2.7.1.11. Ballast Correction Factor

The ballast-correction factor is the ratio of the light output of a reference lamp operatedunder reference conditions on a test ballast to the light output of the same lamp operatedunder the same conditions on a reference ballast.

2.8. Lamp Property Sheet

This property sheet is for editing the properties of a lamp. It has two pages:

General page Valid colours page

of 54

2.8.1. Lamp General Page

This page allows you to set the lamp ID and title, whether it is still manufactured,select a type category, and select or enter a manufacturer.

2.8.1.1. Lamp ID

Enter a unique ID.

2.8.1.2. Lamp is Still Manufactured?

Select this box if the lamp data is valid, i.e. it is still manufactured.

2.8.1.3. Title

Enter a title for this lamp.

2.8.1.4. Lamp Type Categories List

Lists the lamp-type categories from which one may be selected. The lamp-type category isa form of classification, so that particular types of lamp can be reviewed more easily. SeeLamp type categories for a list of available categories.

2.8.1.5. Lamp Manufacturer

Enter a manufacturer’s name if it is not available in the list below.

2.8.1.6. Lamp Manufacturers List

Displays a list of lamp manufacturers from which one may be selected. The lamp-manufacturer is represented by a descriptive name. See Lamp manufacturers for a list ofavailable names. However you may enter ANY other manufacturer name in the box above.

of 54

2.8.2. Lamp Colours Page

This page allows you to edit the list of valid colours for the lamp. This is basically alist of entries in the colours table (not to a separate cross-reference table as used forvalid lamps). When you add or edit a valid colour the Colour property sheet appearswhich allows you add a colour to the database. You may also delete any existingvalid colour.

2.8.2.1. Lamp ID

Shows the lamp ID. This is not editable here.

2.8.2.2. Colours List

Lists the available colours for the selected lamp. Double-click or select and press Propertiesto edit.

2.8.2.3. Add New Button

Adds a new colour for the lamp and displays its property sheet.

of 54

2.8.2.4. Properties Button

Displays the property sheet for the selected colour.

2.8.2.5. Delete Button

Deletes the selected colour.

2.9. Colour Property Sheet

This property sheet is for editing the properties of an available colour that hasbeen assigned to a lamp. It has only one page:

Colour page

2.9.1. Colour Page

This page allows you to edit a valid lamp colour. You may change its ID, its initialbare lamp output, and its cross-reference to the LLMF/LSF curves table.

2.9.1.1. Lamp ID

Shows the lamp ID. This is not editable here.

2.9.1.2. Colour ID

Enter a unique ID.

2.9.1.3. Initial Bare-lamp Output

The initial bare-lamp output is the luminous flux measured after 100 hours and is used inthe calculations to determine the total luminous flux within the room.

2.9.1.4. Lamp-lumen Maintenance Factor Curve List

Shows the complete list of LLMF/LSF curve sets in the database, from which you mustselect one to use with this lamp.

2.10. Lamp-lumen Maintenance Factor Curve Property Sheet

This property sheet is for editing the properties of a pair of time-depreciation

of 54

curves for lamp-lumen maintenance factor and for lamp survival factor. It hasonly one page:

Lamp-lumen maintenance factor curve page

2.10.1. Lamp-lumen Maintenance Factor Curve Page

This page allows you to specify the curves used when looking up the lamp-lumenmaintenance factor and lamp survival factor based on the lamp replacement period.Each curve is given a numeric reference and a title that will be displayed in theselection lists. The curve is displayed in the graphic area for confirmation, and a gridmay be overlaid if you wish.

The percentage lamp-lumen maintenance factors and lamp survival factors for timeintervals of 1000 hours should be entered. Individual rows may be edited by double-clicking the row; this displays the LLMF/LSF dialogue box where the values may beedited.

of 54

2.10.1.1. Reference

The lamp-lumen maintenance-factor (LLMF) curve reference is a code used to identify aLLMF/LSF curve set. System curves have a code in the range of 1 - 99 and user curveshave a code in the range 100 - 9999.

2.10.1.2. Title

This allows you to specify a title for the LLMF/LSF curve set.

2.10.1.3. List of Curve Points

This displays the list of points on the LLMF and LSF curves. The first column shows thetime interval, the second column the LLMF value, and the third column the LSF value.

2.10.1.4. Grid Check Box

Turns on or off the display of the grid on the graph of the LLMF and LSF curves:

2.10.1.5. Print Curve Button

Allows you to print the contents of the dialogue box.

2.10.1.6. Curve Display

Displays the LLMF and LSF curves graphically, for confirmation.

of 54

2.10.1.7. LLMF/LSF Dialogue Box

Allows you to edit an individual pair of points in the LLMF and LSF curves for the luminaire.

Interval - this displays the interval in hours of the selected curve points.

Lamp-lumen maintenance factor - allows you to enter the lamp lumen maintenance factor atthis time interval. This represents an average deterioration in lamp luminous output due todust build-up etc.

Lamp survival factor - allows you to enter the lamp survival factor at this time interval. Thiscategory is used to assess the proportion of lamps that have not failed after a set time.Typical lamp survival factors are shown in the CIBSE Code for Interior Lighting, 1994, Table4.4.

2.11. Overview Dialogue Box

This dialogue box shows you an overview of the relationship between the 5tables used in the database. It is for information only.

of 54

2.12. User Name Dialogue Box

This dialogue box asks you to confirm your user name before any changes aremade to the database. It only appears once, the first time the user name isrequired, and then the same name will be used for any subsequent changes.The default name is based on your Windows login name.

2.12.1. Login ID

Displays the ID you used to login to Windows. This is used as a base for the defaultuser name.

2.12.2. User Name

Enter your user name or accept the default suggested for you.

of 54

2.13. Database Calculations Dialogue Box

This dialogue box appears when you select the "Database" option from thecontext menu when a luminaire is selected and then select "Calculations". Thebuttons show the available calculations:

2.13.1. Light Output Ratios and Spacing/Height Ratios Button

This option is used to calculate the upward and downward light-output ratios (LORs)and the maximum, maximum transverse, and nominal spacing-to-height ratios(SHRs) for the given luminaire. The calculation method is based on the proceduresin CIBSE TM5. Results are stored with the luminaire.

2.13.2. Utilisation Factors Button

This option calculates the standard utilisation factors for the nine given room indices(0.75 to 5) following the procedures given in CIBSE TM5. Results are stored with theluminaire.

2.13.3. Glare Data Button

The standard uncorrected glare indices for the nineteen standard room sizes of Xand Y for reflection factors of 70 (ceiling), 50 (walls) and 20 (floor) are calculated.

of 54

For each room size, values for endwise and crosswise viewing are given based onthe procedures in CIBSE TM10. Results are stored with the luminaire.

2.13.4. Aspect Factors Button

The parallel and perpendicular aspect factors for the luminaire are calculated at 5degree intervals from 0 to 90 degrees.

2.13.5. BZ Classification Button

Not available at present

This option calculates the British Zonal (BZ) classification for the luminaire within thenine standard room indices (0.75 to 5).

2.13.6. LG3 Checks Button

This option checks that the luminaire selected meets the criterion for the design ofdownlighting, from the CIBSE Lighting Guide LG3, 'Areas for Visual DisplayTerminals', as amended in 2001. You will be asked to select the luminance limit forthe luminaire and the limit elevation angle above which the luminance limit must notbe exceeded.

2.13.7. More Detail Check Box

Select this option to get more control over, and more detailed output from, thecalculations.

Allows you to turn on or off the parts of the calculations which request more inputdata from you or give more detailed output.

2.13.8. Print Output Button

Allows you to print the messages from the calculations.

2.13.9. Clear Output Button

Allows you to clear the messages from the calculations.

2.13.10. Results Area

Displays the results of the database calculations.

of 54

2.14. Batch Calculations Dialogue Box

This gives you important information about what the batch calculations willperform.

After the calculations the results are displayed in a Results dialogue box.

of 54

2.15. Batch Edits Dialogue Box

This allows you to override selected data on a global basis for all the selectedluminaires.

2.15.1. Set Type Check Box

Select this if you want to set the type for all the selected luminaires, and then selectan option below:

Point source option - select this option to specify that the luminaire may betreated as a point source - i.e. has negligible area of light source.

Uplighter option - select this option to specify that the luminaire may be treatedas an uplighter, i.e. most of the light output is upwards.

Linear option - select this option to specify that the luminaire may be treated asa linear luminaire, i.e. has an extended area of light source.

2.15.2. Set Use Category Check Box

Select this if you want to set the use category for all the selected luminaires, andthen select a use category below.

2.15.3. Luminaire Use Categories List

Lists the luminaire use categories from which none, one, or more may be selected.The luminaire category is a form of classification, so that particular types of luminairecan be reviewed more easily. See Luminaire use categories for a list of availablecategories.

2.15.4. Set Manufacturer Check Box

Select this if you want to set the manufacturer for all the selected luminaires, andthen enter or select a manufacturer below.

of 54

2.15.5. Luminaire Manufacturer

Enter a manufacturer name if it is not available in the list below.

2.15.6. Luminaire Manufacturers List

The manufacturer name is the second form of luminaire classification so that thereview procedure can be used more easily. The manufacturer is represented by adescriptive name. See Luminaire manufacturers for a list of available names, but anyadditional name can be entered in the box above.

2.16. Import Dialogue Box

This property sheet is displayed when you import from external photometricdata. It has one or two pages, depending on which format you are importingfrom:

General import page IESNA import page

See http://www.helios32.com/Eulumdat.htm to view the specification of theEULUMDAT format provided by HELIOS32.

The IESNA and CIBSE formats are available from the respective bodies.

of 54

General Import Page

This property page allows you to control the process of importing luminaire data fromexternal file formats.

The options allow you control over what happens if the luminaire name alreadyexists, or if the lamp name does NOT already exist.

2.16.1.1. If the ID and Description Both Match an Existing Luminaire Option

Select the action you wish to take in this circumstance:

Overwrite option - overwrite the luminaire if it already exists. Overwrite extra data option – if this option is selected, the polar data of the existing

luminaire will be overwritten. Prompt for unique ID option - ask for a new luminaire ID if it already exists. Automatically generate unique ID option - automatically generate a new unique

luminaire ID if it already exists. This works by appending numbers to the ID, startingwith "0" and increasing until a unique ID is found (i.e. does not already exist in thedatabase). It is the safest option, because a new ID will always be created. Thedownside of this is that the same luminaire may be stored in the database undermore than one ID.

Skip luminaire option – if this option is selected, the luminaire data will not beoverwritten. The import file will continue to be read until another luminaire is found

of 54

or the file has no more luminaire data.

2.16.1.2. If it is Assumed to be a New Lamp Option

Select the action you wish to take in this circumstance:

Add valid lamp AND lamp option - if this option is selected, the relevant valid lampwill be created in the database, and ALSO the relevant lamp will be created.

Add valid lamp ONLY option - if this option is selected, the relevant valid lamp willbe created in the database, but the relevant lamp will NOT be created.

2.16.2. IESNA Import Page

This property page only appears when importing IESNA format luminaire data (NoteIESNA = Illuminating Engineering Society of North America, NOT IntegratedEnvironmental Solutions).

The page is fairly complex because of the degree of flexibility the IESNA formatallows the manufacturers or photometric testers who produce the files. Somemanufacturers use particular lines within the first 9 lines of the file to encode theluminaire and lamp catalogue reference and titles. Some use the keywords forencoding this information. Finally, some do not encode the information within the fileat all, but instead encode it into the file NAME, using their own non-standard formats.

of 54

In addition, there may be one luminaire per file or multiple luminaires per file.

2.16.2.1. Method for Obtaining the Luminaire and Lamp ID’s and Descriptions Option

Select the method that will be used to obtain these items from the file:

Decode option - select this option if the luminaire and lamp ID's are encoded in thefilename. If this option is selected you must enter data in the next two fields also:

Delimiter - enter the character which the manufacturer or photometric testerused to separate the luminaire and lamp ID's encoded into the file name; e.g.for the ERCO file "ERCO_12408+T16_54W.IES", the luminaire is "12408", thelamp is "T16_54W", and the delimiter is "+".

Ignore text - enter text which the manufacturer or photometric tester added tothe file name which must be ignored; e.g. for the ERCO file"ERCO_12408+T16_54W.IES", the luminaire is "12408", the lamp is"T16_54W", and the ignore text is "ERCO_".

Use line 2/3/4 option - select this option if the file contains the luminaire ID on line2, the luminaire description on line 3, and the lamp description on line 4.

Use line 3/2/4 option - select this option if the file contains the luminaire ID on line3, the luminaire description on line 2, and the lamp description on line 4.

Keywords option - select this option if the luminaire and lamp ID's and descriptionsare encoded in the file using keywords such as "[LUMCAT]ABCD".

2.17. LG3 Dialogue Box

This dialogue box is displayed when you select the LG3 calculation.

The CIBSE Lighting Guide LG3:1996 "The visual environment for displayscreen use" specifies a test for assessing the potential for glare from aluminaire. A luminance limit is specified and a limiting angle to the verticalabove which the luminance is checked. If the luminaire's luminance is belowthe limit at all angles below the limiting angle then the LG3 check issatisfactory.

of 54

2.17.1. Luminance Limit

Select the luminance limit to be checked above the specified limiting angle.

2.17.2. Limiting Angle

Select the angle to the vertical above which to check the luminance limit.

2.18. Import Summary Dialogue Box

This appears after importing photometric data. You should heed the warningsgiven, as the same categories must be applied to the whole batch of imports.Also bear in mind that the import process depends on the quality of thephotometric data.

of 54

2.19. Database Summary Dialogue Box

This dialogue box gives you a brief summary of the location and contents ofthe lighting database, using a Results dialogue box.

2.20. Results Dialogue Box

This is a general purpose dialogue box that is used in different situationswhere a list of results is required.

of 54

2.20.1. Clear Button

Allows you to clear the summary.

2.20.2. Print Button

Allows you to print the summary.

2.20.3. Save Button

Allows you to save the summary to file.

2.21. Numeric Entry Dialogue Box

This dialogue box is used when the program requires you to enter any numericvalue apart from the usual data entered via dialogue boxes or property pages.

2.21.1. Prompt

Displays the text describing the data input that is required.

2.21.2. Numeric Value

Enter the required numeric value here.

2.22. Text Entry Dialogue Box

This dialogue box is used when the program requires you to enter any textvalue apart from the usual data entered via dialogue boxes or property pages.

of 54

2.22.1. Prompt

Displays the text describing the data input that is required.

2.22.2. Text Value

Enter the required text value here.

2.23. Visualisation of Photometric Web

This displays the photometric web generated by the polar curve data. It isuseful for examining complex webs and for checking your edits. It is obtainedby using the Visualise menu option, or by double-clicking the polar curve plot,on the Select light fitting dialogue box or on the Luminaire polar curve page. Ituses the same 3d viewer control as the Model Viewer, so the buttons fornavigation, movie-making etc. are the same. The only difference is that theground plane is irrelevant here, so it is disabled. The x and y axes and thebounding rectangle of the luminaire are also displayed.

of 54

3. Predefined Categories

3.1. Luminaire Use Categories

C CommercialI IndustrialD DownlighterU UplighterS Spotlight

H High-bayL Low-bayW Wall-mountedN Non-classified

3.2. Luminaire Manufacturers

3F FilippiABS LightingAcculiteAdvancedAleraAnsorgAppleton Electric LLCAtelje LyktanBartenbachBegaBeluxClaudeColumbiaConcordCooper Crouse-HindsCooper LightingCromptonDALDesigned Architectural LightingDesignplanDurlumEMCOEnessErcoETAPExceLineFagerhultFluoliteFluoraGEGlamoxGlasshuette LimburgHess

Hitech Architectural LightingHoffmeisterHolophaneHubbell LightingHucoHVAC & LightingiGuzziniIllumaIntereuroLanziniLBMLCLLedaliteLeipziger LeuchtenLenneperLighting and Ceiling LouvresLiteLichtLithoniaLouis PoulsenLTSLumianceLuminaire LightingMarlinMetalichtMitraluxMoorliteNewey and EyreNorkaOligoOsramParklumePhilipsPraezisa

of 54

RadaRademacherRegentRegioluxRibagRidiRiegensRuud LightingRZBSchmitzSEAESeluxSideSiemensSimesSpectralSpittlerStaffSylvania

SystemtechnikTargettiThorluxThornTobias GrauTreciluceTriluxTrustTuluxUrbisWaldmannWever+DucreWhitecroftWILAWoodhouseWRTLXenonZumtobel

3.3. Lamp Type Categories

IN IncandescentTH Tungsten HalogenLF Linear FluorescentCF Compact FluorescentME Mercury

MH Metal HalideSX Low-Pressure SodiumSN High-Pressure SodiumNC Non-classified

3.4. Lamp Manufacturers

General ElectricOsramPhilips

SylvaniaThornWotan

of 54

4. Version History

4.1. Version 12.8.0.9

The system database has been updated and extended. 39000luminaires have been added (total now 85000).

Polar curves are now displayed in the Select Light Fitting dialogue box Polar curves may now be visualized in 3d Plots of polar curves and LLMF's now redraw themselves when the

dialogue box needs to be redrawn on the screen after another window isclosed

Their respective print buttons now also work Fixed bug where LSF curve always set equal to LLMF curve on property

page Manufacturer’s names and user names no longer limited to 2 or 4

characters Database files can now have any name with a .db2 extension (formerly

they were called lighting.db2) The system database now has a set of (mostly) manufacturer-specific

databases, and the user may now use a new dialogue box to selectwhich of these databases are loaded, making browsing and selectioneasier. The custom path mechanism is now not required for selectingsystem manufacturer’s databases, though it is still useful in othercircumstances.

After importing the imported filename and type are now stored in theluminaire.

EULUMDAT files with symmetry indicator 3 now imported correctly. Some errors on import came up in dialogue boxes – these have now

been added to the import summary.

4.2. Version 12.8.0.5

IP units may now be used Copy item to project will now also copy all referenced items Easier to edit polar intensities - and no flashing afterwards

4.3. Version 12.6.0.0

The database format has been revised to allow a simpler, more logical,data structure and presentation.

The database screens allow more filtering and sorting to enable you tofind the required luminaire.

The database has been added to considerably, now featuring data fromover 40 manufacturers.

The database import and export facilities have been extended to includeEULUMDAT and have also been made more robust.

of 54

The database calculations and interface have been completely rewrittenand improved.

The new CIBSE LG3 (display screen) calculations have beenimplemented.

Many small fixes.

lighting database user guide · lighting database overview ... luminaire property sheet ... you to...

Documents