ElecDB

This variable is a string that lists the full path of the Design Master Electrical database to use in the query.

The default value for this variable is 'DM Elec'!$B$1. This cell is the one updated by the Select Electrical Database function. Defaulting all functions to this one cell makes it easy to reuse a database on multiple projects.

It is possible to change this value from the default if necessary. For example, if you wanted to include quantities from two different projects on a single spreadsheet, it would be necessary to specify a different database for some of the functions here.

Examples

=LightFixtureCount('DM Elec'!$B$1', "A", "", "")

This is the default value for this variable. The function will return a count of light fixtures from the database specified in cell B1 on worksheet DM Elec.

=LightFixtureCount("C:/Program Files/Design Master Software/Practice Job/dm_elec.mdb", "A", "", "")

This function will return the count of light fixtures from the practice job database.