LED Wizard 8 Documentation

Intro to LED Wizard 8 Docs
Getting Started
System Requirements
Screen Layout
LED Wizard Basics
Basic Workflow
Operating Modes
Defaults and Preferences
New in Version 8
Data Clean Up Tool
Module Filtering
LED Wizard Fonts
LED Wizard 8 Database
Population Scaling Tool
Graphical Population Scaling
Auto Stats and Title Block Merging
Auto Power Supply Loading
Auto Dimensioning
Single Run Populations
Create Guide Paths from Open Vector Paths
Freehand Drawing Tool
Power Supply Colors
New Auto Power Supply Loading Options
Multiple Document Interface
Power Supply Rotation
Population Library
Core Series Flexible Mode
Creating LED Module Layouts
Using the PowerFlow Tool
Creating and Editing LED Modules
Scaling LED Graphics
Working with Guidepaths
Working with Selections
Editing Existing Selections
Cabinet Layouts
Parallel Layouts
Module Rotations
Reusing Module Layouts
Target Density
LED Property Bar
Using Power Supplies
Using Title Blocks
Multiple Module Title Blocks
Title Block Variables
Using Guidelines
Copy and Paste
Importing Files
From Adobe Illustrator
From Corel Draw
From AutoCAD
Exporting Files
Editing Text
Vector Editing
Loop Editing
Tools, Tabs and Property Bars
PowerFlow Tool
PowerFlow Property Bar
PowerFlow Tab
PowerFlow Tool Keyboard Shortcuts
Semi-Automatic Populations
Layout Tool
Data Clean Up Tool
Auto Mounting Holes Tool
Assign Letters Tool
Scale Tab
Summary Tab
PS Tab
Objects Tab
Layers Tab
History Tab
Job Tab
Text Edit Tool
Vector Edit Tool
Keys for Vector Editing
Loop Edit Tool
On Screen Digitizing Tool
Object Property Bar
Group Property Bar
Guideline Property Bar
Measure Tool Property Bar
Bitmap Property Bar
LED Object Property Bar
Job Color Property Bar
Menu Reference
File Menu
Open Recent
Save As
Save Copy As
Snapshots Menu
Export Scaled PDF
Email PDF
Edit Menu
Paste Special
Paste in Place
Select All
Vector/Node Tools
Vector - Insert
Vector - To Line
Vector - To Arc
Vector - To Bezier
Vector - Break Loop
Vector - Set St/End Point
Vector - Join St/End Point
Vector - Move Opening
Vector - Add Vertical Guide
Vector - Add Horizontal Guide
Reorder Loops
Unexplode Vector Paths
Purge Undo/History
Document Properties
View Menu
Zoom commands
Toolbox menu
Custom Toolbars
Show Fill Colors
Show Stroke Colors
Show Grid
Show Guidelines
Show Rulers
Show Loop Direction
Show Job Color Palette
Show Side Bar
Show Info Bar
Show Help Bar
Show Group Member Names
Highlight Small Vectors
Transparent Background
Reset Toolbar Layout
Layout Menu
Guides commands
Shapes commands
Rounded Rectangle
Layout Properties
Size to Fit
Show Layout Size
Snap to Grid
Snap to Guidelines
Snap Dimensions to Graphics
Selectable Guidelines
Auto Square
Create Auto Dimensions
Arrange Menu
Align Tools
Distribute Tools
Group Tools
Select Only by Edge Click
Allow Options
Break Into Loops
Break Into Outer Loops
Close All Loops
Remove All Inner Loops
Horizontal Mirror
Vertical Mirror
Z Order Tools
Move to Layer
To Top
To Bottom
Move One Up
Move One Down
Text Menu
Text Tool
Break Apart
Live Spell Checking
Convert to Text
Change Copy
Change Case Tools
Font Wizard
Font Layout
Add Variable Text
Edit Variable Text
Remove Variable Text
Image Menu
Crop Tool
Rotate +/- 90 Degrees
Flip Horizontal/Vertical
Commit Rotation
1:1 Zoom
Save (Image) As
Cut at Max Length
Reorder Tubes
Power Supply Template Setup
Multi Excel Update
LED Menu
PowerFlow LED Tool
Assign Letters
Statistics Menu
Update Statistics
Update Grouped Statistics
Recreate Statistics
Respace Stats
Uniformly Respace Stats
Merge Title Block Template
Remove Title Block
This Document is a Title Block
Optimized Title Block Text
Create Module Hole Layer
Create Router Layer
Auto Mounting Holes Tool
Update Vector Guidepaths
Remove Vector Guidepaths
Create Guide Paths from Open Vector Paths
Recreate with Bezier Curves
Rasterize-Vectorize Filter
Remove LED Modules
Populate Menu
Populate All
Populate Along Guide
Populate Stroke Inline
Populate Single Horizontal Serif
Paste Selected Runs
Insert Parallel Guide Line
Add to Population Library
Respace Selected Runs
Auto Respace
Auto Join
Filtering Enabled
Calculate Stroke Width at Cursor
Modify Menu
Select All Modules in Run
Select All Modules in Letter
Select Stroke
Add Run to Selection
Rotate Menu
Reset Primary Rotation Angle
Reset Secondary Rotation Angle
Alternate Rotations
Rotate 90 degrees
Rotate 45 degrees
Rotate 45 degrees - Alternating
Rotate Counter-Clockwise (Left)
Rotate Clockwise (Right)
Flip Primary Rotation Angle
Flip Secondary Rotation Angle
Convert to Perpendicular Alternate Rotated
Density Menu
Increase Density
Increase Density For Entire Run
Decrease Density
Decrease Density For Entire Run
Uniform Spacing
Uniform Spacing For Entire Run
Add / Remove Density Segment
Show Density Segments
Clear All Density Segments
Append Module
Insert Single Module
Mirror Horizontal
Mirror Vertical
Fill To Cursor
Break Run
Move Opening
Convert To Line
Shift Menu
Shift Inward
Shift Outward
Slide Backward
Slide Forward
Slide to Max Spacing
Reconnect Runs
Center in Stroke
Center in Stroke w/Cleaning
Mouse Menu
Nudge Faster
Delete Current Run
Delete Module(s)
Delete Module(s) and Break
Delete All Modules in Current Letter
Delete Modules in All Letters
Remove Overlapping Modules
PowerFlow Measure Mode
Ensure Reachability
Change All Modules
PS Menu
Power Supply Edit Mode
Add Selection Rectangle Modules to Power Supply
Connect Run to Power Supply
Remove Run from Power Supply
Add New Power Supply
Remove Power Supply
Add One Power Supply per Letter
Add One Power Supply per Letter (Auto Select PS)
Add One Power Supply for All Letters
Add One Power Supply for All Letters (Auto Select PS)
Add Optimal Power Supplies by Letter
Add Optimal Power Supplies by Run
Add Optimal Power Supplies by Modules (breaks runs)
Connect Current Letter to Power Supply
Remove Current Letter from Power Supply
Drawing Left
Drawing Above
Drawing Right
Drawing Below
Next Drawing Position
Hide Power Supplies
Arrange Power Supplies in a Grid
Options Menu
Show Connecting Wires
Show Run Numbers
Show Power Supply Wires
Show Power Supply Data Boxes
Show Power Supply Data Box Borders
Show Module Drawings
Show Letters and Stats
Show Vector Guidepaths
Show Stroke Width Line
Enable Dynamic Repop
Power Supply Color Mode
Auto Extend
Remove All Stray Modules
Refresh Run Numbers
PowerFlow Menu
Ctrl Enables Snapping
Non-Snapping Movement Auto Rotates
Non-Snapping Drag Auto Rotates
Show Stroke Circle
Excel Menu
LED Excel Link Setup
Update Excel
Auto Update Excel
Excel Enabled
Title Block Setup
Letter Statistics Setup
Legacy Statistics Template Setup
Power Supply Template Setup
Power Supply Pricing Setup
Module Pricing Setup
Filter Modules
Edit Face Materials
Legacy Letter Statistics Mode
Open Merged Titleblock File
Upload Log Files
Tools Menu
General Tab
View Tab
Edit Tab
Save Tab
Text Tab
Tools Tab
High Color Toolbox
Update LED Database
Reload LED Database
Layout Tool
Vector Edit Tool
Loop Edit Tool
On Screen Digitize Tool
Freehand Drawing Tool
Data Prep Tool
Calculate Area
Channel Letter Return
Radius Corners
Convert Menu
Convert Beziers to Arcs
Convert Arcs to Beziers
Convert to All Lines
Convert Lines to Arcs
Convert Flat Blend to Simple Fills
Convert All Clippings Paths to Normal Paths
Convert All Clipping Paths to Normal Filled Paths
Detect Letters
Remove Coincident Loops Across Layout
Remove All Clipping Paths
Optimize Vectors
Find Self-Intersecting Loops
Force Loop Direction
Remove Duplicate Loops
Display Path Length
Reset Windows Explorer File Association
Open AppData Folder
Window Menu
Tile Vertical
Tile Horizontal
Help Menu
Get Help
Check for Web Updates
About LED Wizard
DXF Options
PDF Options
Shortcut Key Reference
Working with App Data Files
Previous  Next LED Excel Link Setup

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.

Setup Dialog

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.

Sheet Name

Enter the sheet name to use for the LED summary data.

Selected Only

Check this if you only want the selected object to be given to Excel, and never the entire layout's data.

Auto Update

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.

Starting Row

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.

Include Bitmap

Check this to include a bitmap rendering of the LED module design.

Horizontal Position

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.

Vertical Position

Enter the bitmap's vertical position if necessary.

Pixel Height

Enter the bitmap's pixel height.

Sheet Name

Enter the name of the Excel sheet to use for the bitmap.

Previous  Next
Was this helpful?          

Copyright (C) 2019-2023 Principal Lighting Group, LLC