Fan Selector

Fan Selector Help

Making Fan Selections
  1. The Fan Selections Screen
  2. Entering the Required Duty Point
  3. The Electrical Phase & Specific Fan Power Filter
  4. Choosing the Fan Ranges to Select From
  5. Range Specific Additional Parameters
  6. OEM Range Specific Parameters
  7. Making the Selection
  8. Selected Fans
  9. Displaying Fan Data
  10. Selecting Ancillaries
Using Axial Configurator
  1. The Axial Configurator Screen
  2. Motor, Case & Impeller Options
The Performance Curve
  1. Understanding the Fan Performance Curve
Creating Fan Data Sheets
  1. Creating Fan Data Sheets
Building a Quotation
  1. Adding to a Quotation
  2. The Quotations Screen
  3. The Quotations Toolbar
  4. Save as Excel
Viewing Extra Literature
  1. Viewing Extra Literature for the Selected Fan
Program Preferences
  1. Customizing the Programs Operation
Glossary of Terms
  1. Terms Used in Fan Selector

 
 
 
 

Fan Selector Help - Building a Quotation

The Save as Excel Option

On the Quotations screen there is a Save as Excel option which allows you to save the quote as an Excel spreadsheet. The format of the spreadsheet is template driven and can be customised to your own requirements.

The default template and other samples are saved in a sub-folder under Fan Selector's installation folder and can be selected on the Program Preferences screen. These templates are themselves just simple Excel spreadsheets and you are free to create your own.

Editing the template

To create your own template you simply insert special tags which are then substituted with the relevant values in the generated spreadsheet. Everything else in the template is copied over as is. Each tag should be in a cell of its own; if you want to combine the values of more than one tag into a single cell you'll need to specify the individual tags in hidden cells and combine them using an Excel formula.

There are three distinct layouts for quotes; those that repeat by row top-to-bottom, those that repeat by column across the page left-to-right and those that have one fan per page each on its own tab. The first column 'A' and row '1' is a special control column/row and is used to describe the page layout and how rows/columns should be repeated using special ‘control words’.

Top to Bottom Layout (repeated rows)

To use the repeated row layout enter ‘T2B’ in cell A1, this is also the default layout if cell A1 is left blank. For the row you want to repeat enter ‘repeat’ in column A of that row. This will create a new row for every fan and ancillary on the quote, if you don’t want the additional ancillary rows then enter ‘repeatfans’ instead.

Left to Right Layout (repeated columns)

To use the repeated column layout enter ‘L2R’ in cell A1. For the column you want to repeat enter ‘repeat’ in row 1 of that column. That will create a new column for every fan and ancillary on the quote, if you don’t want the additional ancillary rows then enter ‘repeatfans’ instead.

For repeated columns you are able to specify a maximum number of columns to repeat across before the whole block is copied onto a new set of rows. To do this you just enter the number of repetitions you want as well, for example ‘repeatfans 4’. You also need to specify in column A the start and end of the block of columns to be repeated down the page, to do this enter ‘startblock’ and ‘endblock’ in the relevant cells and also enter a dot ‘.’ into each intervening cell. When using this layout you will need to pre-format all the columns across the page and not just the one you want to repeat.

Single Fan Layout (tabbed pages)

To use this layout enter ‘TAB’ in cell A1. For every fan on the quote a new tab is created in the spreadsheet.


General Guidelines

When using the repeated rows/columns layouts if you have any special formatting such as gridlines then it is a good idea to include a blank row/column below or to the right of the repeating one with the same formatting and make it hidden. This forces the correct formatting to be inherited by the inserted row/column and also allows you to use the SUM function to total all the rows/columns. So the control row/column is not visible in the generated spreadsheet you can make it hidden.

You can enter the control word ‘hide’ in any cell in row 1 / column A to force that column/row to be hidden in the final generated spreadsheet. You can also use the control word ‘delete’ to have the row/column deleted.

You can only have one row or one column that repeats on the page.

Merged cells are not handled very well and should be avoided.

The system is compatible with features of Excel up to version 2000. Any formatting features introduced in versions later than 2000 will not be generated correctly.


Value Tags

From the quote lines and fan data:
[LocNo]The location number.
[LineNo]The line number in the format lll,nnn where lll is the location number.
[LocRef]The location reference.
[LocDesc]The location description.
[DutyFlow]The selected system volume flow in m³/s.
[DutyFlowL]The selected system volume flow in l/s.
[DutyPres]The selected system resistance in Pa.
[DesignDutyFlow]The design duty volume flow in in m³/s.
[DesignDutyPres]The design duty system resistance in Pa.
[UnitCode]The fan or ancillary code.
[FanUnitCode]The fan unit code.
[AncilUnitCode]The ancillary unit code.
[Description]The fan or ancillary description.
[Notes]The user entered comments from the bottom of the Quotation tab.
[Qty]The quantity selected.
[UnitPrice]The unit price for the item. (to show the line price multiply the [Qty] and [UnitPrice] cells in the template.
[FullPrice]The total price for the fan and ancillaries
[AncilList]A space seperated list of all the selected ancillary item codes.
[AncilListDetailed]A list of all the selected ancillary item codes with quantities and descriptions, new line terminated.
[Impeller]The units impeller type.
[AirTemp]The air temperature the selection was made at.
[Efficiency]The fan efficiency.
[AbsPower], [FanInputPower]The fans absorbed power / fan input power.
[InputPower], [MotorInputPower]The fans motor input power.
[SFP]The Specific Fan Power.
[RPM]The fan speed in RPM.
[Pole]The motor poles.
[Phase]The motor electrical phase.
[Volt]The motor volt 230 / 413.
[Hz]The motor frequency 50 / 60.
[ElecSupply]Returns phase, volt & frequency combined.
[KW]The nominal motor power kW.
[Watts]The nominal motor power Watts.
[FLC]The motor full load current.
[SC]The motor starting load current.
[MaxTemp]The maximum operating temperature of the fan.
[Weight], [kg]The weight in kg.
[Length], [L]The overall length of the unit in mm.
[Width], [W]The overall width of the unit in mm.
[Height], [H]The overall height of the unit in mm.
[SpigotSize]The spigot size in mm.
[RoofOpening]The roof opening size in mm.
[WallOpening]The wall opening size in mm.
[InsideWeatherSkirt]The inside weather skirt size in mm.
[DuctSize]The duct size in mm.
[dBA]The sound pressure level dBA.
[dBA-B]The Breakout sound pressure level dBA.
[dBA-I]The Inlet sound pressure level dBA.
[dBA-O]The Outlet sound pressure level dBA.
[dBAType]The dBA type returned by [dBA], either Breakout, Inlet or Outlet.
[dBADetailed]Returns a list if all breakout, inlet and outlet dBA, new line terminated.
[ss-63], [ss-125], [ss-250],
[ss-500], [ss-1000], [ss-2000],
[ss-4000], [ss-8000]
Sound spectrum octave bands in dB.
[ss-type]Sound spectrum type returned from [ss-63] etc.
[ss-??-63] etcwhere ?? is one of ii, io, oi, oo, b, i or o; Sound spectrum octave bands in dB for induct inlet, induct outlet, open inlet, open outlet, breakout, inlet or outlet – the latter select the either induct or open depending on which is available.
[ss-??-all] etcwhere ?? is one of ii, io, oi, oo, b, i or o. Complete sound spectrum octave band in dB for induct inlet, induct outlet, open inlet, open outlet, breakout, inlet or outlet. Comma separated list.
[ss-a-63], [ss-a-125], etc.Attenuation of selected silencer (assumes only one selected).
[ss-detailed]Returns a detailed list of all sound spectrums.
 
[a-???-selected]Returns Yes if ??? is a selected ancillary, where ??? is one of the list below.
[a-???-code]Returns the item code of selected ???.
[a-???-desc]Returns the description of selected ???.
[a-???-qty]Returns the quantity of selected ???.
??? in the above can be one of:
AC - Acoustic EnclosureACJ - Acoustic Jacket
AQ - Air Quality SensorAV - AV Mount
BDD - Back Draught DamperCC - Cooling Coil
CLM - ClampsCNT - Control
CO2 - CO2 SensorCUR - Curb
DMP - DamperFET - Feet
FIL - FilterFLN - Flange
FLX - Flexible ConnectorGRD - Guard
GRL - GrilleGRM - Motor Guard
HET - HeaterHEX - Heat Exchanger
HUM - Humidity SensorIC - Inlet Cone
MB - Mounting BracketPIR - PIR
PNT - Paint FinishRC - Roof Cowl
RFI - Remote Fail IndicatorROT - Run On Timer
SIL - SilencerSPD - Speed Control
STR - StarterTC - Timer Control
THM - ThermostatWPR - Weather Proof Roof
From the quote header details:
[ProjectName]The project name.
[ProjectDesc1]First line of project description.
[ProjectDesc2]Second line of project description.
[ProjectDesc3]Third line of project description.
[ProjectOurRef]Our project reference.
[ProjectClientRef]Clients project reference.
[ClientName]The clients company name.
[ClientAddr1]First line of client address.
[ClientAddr2]Second line of client address.
[ClientAddr3]Third line of client address.
[ClientContact]The client contact.
[ClientTel]The client telephone number.
[ClientFax]The client fax number.
[OfficeContact]Our office contact.
[OfficeTel]Our office telephone number.
[OfficeRep]Our sales rep.
[OfficeRepTel]Our sales rep telephone number.

Please look at the samples to see how this all works in practice.


 
 
 
 

Next - Viewing Extra Literature for the Selected Fan


 
 
   Copyright Nuaire     |    HTTPS version of this site: https://info.nuaire.co.uk    |    Go to Nuaire's main website: www.nuaire.co.uk