Was this helpful?
The Excel integration features makes it a snap to use the various data generated by LED Wizard with Microsoft Excel. This dialog box lets you configure how the LED data is sent to Excel.
The way this works is by utilizing COM (Component Object Model), which is a Microsoft technology that separate, independently developed software programs can use to control each other's operation and exchange data in real time, without the need for clumsy and slow file transfers or copy/paste via the clipboard.
If you use Excel to make additional calculations for estimates, pricing, and/or inventory, this can be a very powerful capability.
The following is a description of the configuration dialog box for the LED Excel integration feature:
Template Excel File
This is the path of the XLS file that will be used as the template file. You can create a template with cells reserved for the LED data, plus any other data you would use. This file can be a starting point that you customize, or you can start with your own file.
Enter the sheet name to use for the LED summary data.
Check this if you only want the selected object to be given to Excel, and never the entire layout's data.
This controls whether Excel is updated whenever you change the layout. With this unchecked, you have to select Update Excel yourself to update Excel.
Uncheck this to disable this feature of LED Wizard.
Include Totals Row
Check this to include the totals at the end of the table. If not using either Feet + Inches option, you can let Excel do the totals if you want.
This is the row where you want to start the data.
Column for Run Numbers
Enter the column for run numbers (blank for none).
Column for Brand
This lists the brand of LED used.
Column for Part #:
This lists the LED part number used.
Column for Letters
This lists the name of the graphic, typically an individual letter. The Name field on the LED Property Bar lets you specify this.
Columns for Modules / Run
This lists the total modules per run. A run is a single connected series of modules.
Column for Modules / Letter
This lists the total modules per letter. A letter is a single named graphic or individual letters inside of a single text graphic when the text is created within the program rather than imported. You can use the Name field on the LED Property Bar to set the Letter in the layout.
Column for Watts/Letter
This lists the total watts for the most recent letter listed in the table.
Column for Watts
This lists the watts for this run.
Column for Area
This lists the area for the letter the LED path was derived from. This will not work on files created before version 6.5.33.
Column for Density
This lists the density, which is defined as the letter module count divided by the area (above).
Column for Edge Length
This is the total perimeter length of the vector graphics.
Column for Lumens
This is the total lumens of all the modules. This doesn't represent an accurate lumen output through teh sign face, but is simply a total to be used as desired in some cases.
Column for Module Cost
This is the total cost of the modules for each letter (if you have entered module prices).
Column for Power Supply
This column lists each power supply used.
Column for PS Cost
This column lists the cost for each power supply, if a price is specified for the power supply.
Total Rows To Clear
This is the maximum number of rows the data section in the Excel file is likely to be. It it used to clear the file of any existing data.
Check this to include a bitmap rendering of the LED module design.
Enter the bitmap's horizontal position. This is normally not entered manually; when you move the bitmap into position within Excel, the Wizard will detect this new position the next time the bitmap is updated in Excel, and store the new position in the Excel settings in the registry. This value is not a row or column but a different scaling used for bitmaps.
Enter the bitmap's vertical position if necessary.
Enter the bitmap's pixel height.
Enter the name of the Excel sheet to use for the bitmap.
Copyright (C) 2019-2023 Principal Lighting Group, LLC