Chapter 15 Template Menu by nil13868

VIEWS: 41 PAGES: 28

									                                            Chapter 15

                                        Template Menu


"Template" is the kernel entity of e-DPP. Through various templates, you can access, edit and output
the equipment database of e-DPP.
e-DPP has eighty six (86) predefined templates along with the corresponding MS Excel formats.
(Some of them are used by the system and not disclosed to users.)

In addition to the e-DPP standard templates, you can design your own templates by the Template
Design function. The basic concept to design a user template is to relate a user MS Excel sheet with
the e-DPP database table. Columns of MS Excel sheet are linked with the fields of the e-DPP database
table. The Template Design program facilitates those relating processes.




                        <e-DPP Database>                    <MS EXCEL format>




ELTECHS Engineering & Consulting Co., Ltd          15-1                                    e-DPP 3..0
Template Menu                                                                      Template List


15.1 Template List
You can see the list of all e-DPP templates, standard and user-designed, and alter their properties in
this window.




User Template Only
Check this checkbox to view only the user-designed template list.

Document No.
Enter a document no. for the current template (document) with a maximum 30 characters.

Print Type of Rev. No.
Select one option "Official only" or "All". This option becomes effective in the revision column of MS
Excel data sheet.
The bottom row of the revision column is always fixed to Rev. 0. Therefore, even if your document
has Rev. A before Rev.0, Rev. A will not be shown.

"Save" Button
When you make any changes in the document no. or "Print Type of Rev. No.", and you want to save
them, click on Save button for each document. You cannot save the changes for more than one
template at a time.

"Delete" Button
You can delete user-designed templates only. Therefore, if the current template is e-DPP standard, you
cannot delete it.



ELTECHS Engineering & Consulting Co., Ltd           15-2                                     e-DPP 3..0
Template Menu                                                                 Schedule Sheet


15.2 Schedule Sheet
A user template for Schedule Sheet is designed in this window. Before designing a new template, you
need to create a new MS Excel sheet for this template. Your MS Excel sheet is viewed on this window
as below.




"Copy" Button
To copy the presently shown template to a new one




The new template name should not start with "DPP" since "DPP" is a reserved prefix for the e-DPP
standard template.




ELTECHS Engineering & Consulting Co., Ltd           15-3                                   e-DPP 3..0
Template Menu                                                                      Schedule Sheet

"Create" Button
To create a new template




The new template name should not start with "DPP" since "DPP" is a reserved prefix for the e-DPP
standard template.

"Save" Button
Save all the changes made on the template design window.

Category and Template Selection

Category
Select a category from the list box.

Template Name
Select a template from the list box.

Template Title
Enter a template title with up to 64 characters. Template title must be unique throughout the project.

MS Excel File

File Name
Select MS Excel file with "Find" button. Full path name is limited to 255 characters.

Sheet Name
Select a sheet name of the selected MS Excel file.

Data Offset

Max. Data Rows per Page
Enter the maximum number of data rows to be displayed on the output page (not a sheet).

Data Starting Column
Enter the starting column number of MS Excel sheet from where the e-DPP data are outputted. As
columns are named A, B, C, … in MS Excel, you need to convert the letters to number, e.g. A=1, B=2,
etc.




ELTECHS Engineering & Consulting Co., Ltd             15-4                                      e-DPP 3..0
Template Menu                                                                       Schedule Sheet

Data Starting Row
Enter the starting row number of MS Excel sheet from where the e-DPP data are outputted.

Source Table and Field

Header Table
Field values that contain a single record are displayed on this e-DPP table. i.e. DPPProjectRec (Project
information), DPPMotorDefault (Default data for induction motors) and REVData (Revision data)
These values are assigned to the header part of your Schedule Sheet.

Data Table
Field values that contain more than one record is displayed one this e-DPP table. These values are
assigned to the body part of your Schedule Sheet. Individual categories have single particular table
related.

Initial Filter
You can enter an initial filter to limit the data shown in your new template by SQL statement.

"Header" area
You can assign the fields of the "Header Table" by dragging and dropping to this area.

Cell Data
When a cursor is located in the "Header" grid (MS Excel sheet), the cell data is shown in this field.

MS Excel Grid
You can drag and drop any fields of "Header Table" to this area. Dropped fields are expressed in the
format "*[<Table Name>,<Field Name>]".

"Data" area
You can assign the fields of "Data Table" by dragging and dropping to this area.
(Note: Letters in the column header do not correspond to those of MS Excel Sheet. You need to take
the value of "Data Starting Column" into account.)

Description
Enter descriptions for individual fields. These are shown in the column headers of the editor grid and
on the Sort (scroll-down list) and Filter (pull-down list) dialogs brought up by the same editor.

Decimal
Enter the number of significant digits after decimal point (e.g. 3 for "12.465").

Expression
You can concatenate the text type of existing fields and substitute into any of user defined text fields.
Also, you can conduct the four rules of arithmetic operation with more than one numeric type of
existing fields and substitute the calculation results into any of user defined numeric fields.
The Expression Builder helps you to organize a string concatenation or build a formula with "+", "-",
"*" and "/" operators.




ELTECHS Engineering & Consulting Co., Ltd             15-5                                       e-DPP 3..0
Template Menu                                                                      Schedule Sheet



Expression Builder
Double clicking the "Expression" cell of a user field, enables you to create an expression by
dragging/dropping field names from "Available Fields" and clicking several operators on the
Expression Builder.
For the text type of user fields, only string (text) type of fields can be referred. Each string field is
connected with "&" and "-" operators. Also, other constant strings than "-" can be included in the
expression, e.g. "_", "=". The constant string has to be sandwiched by single quotations in the
"Expression" box.

     <String Expression>




For the numeric type of user fields, only numeric type of fields can be referred. Each numeric field is
connected with "+", "-", "/", "*", "(" and ")" operators.

     <Numeric Expression>




ELTECHS Engineering & Consulting Co., Ltd             15-6                                      e-DPP 3..0
Template Menu                                                                        Data Sheet


15.3 Data Sheet
A user template for Data Sheet is designed in this window. Before designing a new template, you need
to create a new MS Excel sheet for this template. Your MS Excel sheet is viewed on this window as
below.




"Copy" Button
To copy the presently shown template to a new one




The new template name should not start with "DPP" since "DPP" is a reserved prefix for the e-DPP
standard template.

"Create" Button
To create a new template




ELTECHS Engineering & Consulting Co., Ltd           15-7                                   e-DPP 3..0
Template Menu                                                                            Data Sheet




The new template name should not start with "DPP" since "DPP" is a reserved prefix for the e-DPP
standard template.

"Save" Button
Save all the changes made on this template design window.

Category and Template Selection

Category
Select a category from the list box.

Template Name
Select a template from the list box.

Template Title
Enter a template title with up to 64 characters. Template title must be unique throughout the project.

MS Excel File

File Name
Select MS Excel file with "Find" button. Full path name is limited to 255 characters.

Sheet Name
Select a sheet name of the selected MS Excel file.

Data Offset

Max. Data Cols per Page
This cell indicates the number of data columns per page. User is not allowed to change its value.
The value is always 1 for the conventional style of datasheets and 3 for the vertical style of schedule
sheets which is categorized in datasheet in e-DPP.

Data Starting Column
Enter the starting column number of MS Excel sheet from where the e-DPP data are outputted. As
columns are named A, B, C, … in MS Excel, you need to convert the letters to number, e.g. A=1, B=2,
etc.
This cell is enabled for the vertical style of schedule sheets only.




ELTECHS Engineering & Consulting Co., Ltd             15-8                                      e-DPP 3..0
Template Menu                                                                           Data Sheet

Data Starting Row
Enter the starting row number of MS Excel sheet from where the e-DPP data are outputted.
This cell is enabled for the vertical style of schedule sheets only.

Source Table and Field

Header Table
Field values that contain a single record are displayed on this e-DPP table. i.e. DPPProjectRec (Project
information), DPPMotorDefault (Default data for induction motors) and REVData (Revision data)
These values are assigned to the header part of your Data Sheet. Individual categories have single
particular table related.

Data Table
Field values that contain more than one record is displayed one this e-DPP table. These values are
assigned to the body part of your Data Sheet.

Initial Filter
You can enter an initial filter to limit the data shown in your new template by SQL statement.

"Data Sheet" area
You can assign the fields of the "Header Table" and "Data Table" tables by dragging and dropping to
this area.




ELTECHS Engineering & Consulting Co., Ltd            15-9                                        e-DPP 3..0
Template Menu                                                                   Load Summary


15.4 Load Summary
User is allowed to design desired forms to output the results of load summary calculation (refer to
chapter 12) in this menu.




                                  <Template Design dialog for Load Summary>

In general, a report form for calculation results consists of three parts, i.e. header, main body and
footer. The dialog shown above has three tabs "General & Header Part", "Body Part" and "Footer Part"
accordingly. By this, user is allowed to design each part on each tab independently.


15.4.1 "General & Header Part" Tab

Template

Template Information

Template Name
Select a template you want to edit from the pull down list.

MS Excel File
Select MS Excel file with "Browse" button. Full path name is limited to 255 characters.

Sheet
The first sheet name of the selected MS Excel file is shown here. Only the first sheet can be used for
template design.




ELTECHS Engineering & Consulting Co., Ltd              15-10                                 e-DPP 3..0
Template Menu                                                                    Load Summary

Document No.
Enter a document number with up to 64 characters. Document number is one of the items that can be
included in the header and/or footer.

Command Buttons

Create
Clicking this button brings up a dialog to enter a new template name with up to 64 characters. To
enable this button, you need to clear all the tab data first by clicking "Clear" button.
Prior to creation of new template, a desired option in "General Parameters" - "Summary Base" needs
to be selected. Once any option has been selected, user cannot change it.

Copy
Clicking this button brings up a dialog to enter a new (destination) template name with up to 64
characters. New template name must be unique throughout the project. The summary base of
destination template is always the same as that of source template.

Delete
When you want to delete the current template, click this button. Warning message will appear to
confirm the deletion action.

Clear
Clicking this button clears all the settings on three tabs. This action is required to create a new
template whenever any project is loaded.

General Parameters

Summary Base
When user creates a new template, one of the options, i.e. "Switchboard", "Bus" or "Lumped Load"
needs to be selected.
When "Switchboard" is selected as a summary base, the items "Bus ID" and "Lump ID" in "Header
Part" and "Footer Part" are hidden.
When "Bus" is selected as a summary base, the item "Lump ID" in "Header Part" and "Footer Part" is
hidden.
When "Lumped Load" is selected as a summary base, no item is hidden.

MS Excel Cell Address

Print Area (Body & Footer Parts)
It is required to specify the Print Area of Excel sheet for the current template by selecting four
parameters from the pull down list.

Row Title area (header part) needs to be specified with MS Excel menu "File" → "Page Setup" →
"Sheet" → "Print Title".

Start Row
Row number of the top-left corner cell in the body part (see the image below).




ELTECHS Engineering & Consulting Co., Ltd           15-11                                  e-DPP 3..0
Template Menu                                                                   Load Summary

End Row
Row number of the bottom-right corner cell in the footer part (see the image below).

Start Column
Column number (A, B, C, … AA, AB, AC,…) of the top-left corner cell in the body part (see the
image below).

End Column
Column number (A, B, C, … AA, AB, AC,…) of the bottom-right corner cell in the footer part (see the
image below).




                                      <Structure of Load Summary Form>

Header Part
You can select the properties that you want to indicate in the header of Excel template. Check the
checkboxes for the properties and select the row and column numbers from the pull down lists. The
contents of pull down lists dynamically change depending on the specified values in "Print Area".

The items included in the header part are as follows:

 No.      Caption               Description        No.       Caption        Description
  1     Proj title         Project Title            8      Lump ID     Lumped Load ID
  2     Job No.            Job No.                  9      kV          Rated kV
  3     Location           Location                10      Engineer    Name of Engineer
  4     S/S                Substation ID           11      Doc. No.    Document No.
  5     Proj code          Project Code            12      Config.     System Configuration
  6     Swbd ID            Switchboard ID          13      Loading     Loading Category
  7     Bus ID             Bus ID




ELTECHS Engineering & Consulting Co., Ltd                15-12                                e-DPP 3..0
Template Menu                                                                     Load Summary

15.4.2 "Body Part" Tab




MS Excel Cell Address - Body

General Parameters

Number of data rows per page
Enter the number of data rows to be indicated in one Excel page (not sheet).

Blank line between data rows
Check this box to output data on every other line. With this option only odd lines will be filled with
data.

Unit of PF, EFF and Load Factor
Select one of the units, either "Per Unit" or "Percent (%)", in which you want to indicate the values of
power factor, efficiency and loading factor.

Show Unit (*) of output rating
This option is intended for such a case as the header title already shows a default unit of output rating
of loads, for example "kW", it might nuisance to repeat the same unit description (kW) in every row.
When you check any of the boxes, i.e. "HP", "kW", "kVA" and "kvar", only the checked units are
indicated in the body part.

Data Columns
In the body part, it is required to specify only the column numbers (alphabets) for checked items.

The items included in the body part are as follows:




ELTECHS Engineering & Consulting Co., Ltd             15-13                                     e-DPP 3..0
Template Menu                                                                         Load Summary

 No.       Caption               Description     No.        Caption                Description
  1     Equip. ID           Equipment ID         17       Load Factor       Load Factor
  2     Equip. Type         Equipment Type       18       Eff @LF           Efficiency at Load Factor
  3     Service             Service              19       PF @LF            PF at Load Factor
  4     Vital               Vital                20       Eff @100%         Efficiency at 100% Load
  5     Essential           Essential            21       PF @100%          PF at 100% Load
  6     Non-Essential       Non-Essential        22       Cont. kW          kW of Continuous Load
  7     Restarting          Restarting           23       Cont. kvar        kvar of Continuous Load
  8     Continuous          Continuous           24       Cont. kVA         kVA of Continuous Load
  9     Intermittent        Intermittent         25       Inter. kW         kW of Intermittent Load
 10     Spare               Spare                26       Inter. kvar       kvar of Intermittent Load
 11     Output              Output               27       Inter. kVA        kVA of Intermittent Load
 12     Unit                Unit of Output       28       Spare kW          kW of Spare Load
 13     No. of poles        No. of poles         29       Spare kvar        kvar of Spare Load
 14     Rated kV            Rated kV             30       Spare kVA         kVA of Spare Load
 15     Phase               Number of Phase      31       Remarks           Remarks
 16     BHP                 BHP


15.4.3 "Footer Part" Tab




MS Excel Cell Address - Footer part
The items included in the footer part are as follows:

 No.   Caption                     Description     No.            Caption           Description
  1 Proj title                Project Title         6           Swbd ID        Switchboard ID
  2 Job No.                   Job No.               7           Bus ID         Bus ID
  3 Location                  Location              8           Lump ID        Lumped Load ID




ELTECHS Engineering & Consulting Co., Ltd               15-14                                      e-DPP 3..0
Template Menu                                                                           Load Summary

 No.   Caption                     Description          No.        Caption           Description
  4 S/S                       Substation ID              9       kV              Rated kV
  5 Proj code                 Project Code              10       Engineer        Name of Engineer


 No.           Group                          Caption                         Description
  1 Total continuous loads                  kW                kW of total continuous loads
  2                                         kvar              kvar of total continuous loads
  3                                         kVA               kVA of total continuous loads
  4                                         PF                Power factor of total continuous loads
  5                                         CF (x)            Coincidence factor x of total continuous
                                                              loads
  6                                         CF * kVA          kVA multiplied by coincidence factor x
                                                              of total continuous loads
   7    Total intermittent loads            kW                kW of total intermittent loads
   8                                        kvar              kvar of total intermittent loads
   9                                        kVA               kVA of total intermittent loads
  10                                        PF                Power factor of total intermittent loads
  11                                        CF (y)            Coincidence factor y of total intermittent
                                                              loads
  12                                        CF * kVA          kVA multiplied by coincidence factor y
                                                              of total intermittent loads
  13    Total spare loads                   kW                kW of total spare loads
  14                                        kvar              kvar of total spare loads
  15                                        kVA               kVA of total spare loads
  16                                        PF                Power factor of total spare loads
  17                                        CF (z)            Coincidence factor z of total spare loads
  18                                        CF * kVA          kVA multiplied by coincidence factor z
                                                              of total spare loads
  19    Total maximum loads                 kW                kW of total maximum loads
  20                                        kvar              kvar of total maximum loads
  21                                        kVA               kVA of total maximum loads
  22                                        PF                Power factor of total maximum loads
  23                                        Margin            % of margin (contingency) of total
                                                              maximum loads
  24    Total peak loads                    kW                kW of total peak loads
  25                                        kvar              kvar of total peak loads
  26                                        kVA               kVA of total peak loads
  27                                        PF                Power factor of total peak loads
  28                                        Margin            % of margin (contingency) of total peak
                                                              loads
  29    Total motor loads                   kVA               kVA of total motor loads
  30                                        Ratio             Ratio total motor loads
  31    Total static loads                  kVA               kVA of total static loads
  32                                        Ratio             Ratio total static loads
  33    Power factor compensation           Cos Phi           Power factor before compensation
  34                                        Cos Phi1          Power factor after compensation
  35                                        Req. kvar         kvar rating of required capacitor
  36    Total max. + Margin                 kW                kW of total maximum load + margin
  37                                        kvar              kvar of total maximum load + margin
  38                                        kVA               kVA of total maximum load + margin




ELTECHS Engineering & Consulting Co., Ltd                15-15                                        e-DPP 3..0
Template Menu                                                                       Load Summary

 No.           Group                          Caption                     Description
 39 Total peak + Margin                     kW            kW of total peak load + margin
 40                                         kvar          kvar of total peak load + margin
 41                                         kVA           kVA of total peak load + margin
 42 Page information                        Page #        Page number
 43                                         Total #       Total number of pages
 44 Document No.                            No.           Document No.
 45                                         Config.       System Configuration
 46                                         Loading       Loading Category

Unit of calculated PF, CF & Ratio
Select one of the units, either "Per Unit" or "Percent (%)", in which you want to indicate the values of
calculated power factors, coincidence factors and ratio of motor/static loads.

Unit of PF for compensation
Select one of the units, either "Per Unit" or "Percent (%)", in which you want to indicate the values of
calculated power factor for capacitor compensation.

Last page only (General information)
Check this box to indicate the general information like project title, job no., etc in footer of the last
page only.

Last page only (Calculated values)
Check this box to indicate the calculated values like total kW, compensated power factor, etc in footer
of the last page only.




ELTECHS Engineering & Consulting Co., Ltd               15-16                                   e-DPP 3..0
Template Menu                                                                 Cable Sizing Result


15.5 Cable Sizing Result
User is allowed to design desired forms to output the results of power cable sizing calculation (refer to
chapter 13) in this menu.




                               <Template Design dialog for Cable Sizing Results>

In general, a report form for calculation results consists of three parts, i.e. header, main body and
footer. The dialog shown above has three tabs "General & Header Part", "Body Part" and "Footer Part"
accordingly. By this, user is allowed to design each part on each tab independently.


15.5.1 "General & Header Part" Tab

Template

Template Information

Template Name
Select a template you want to edit from the pull down list.

MS Excel File
Select MS Excel file with "Browse" button. Full path name is limited to 255 characters.

Sheet
The first sheet name of the selected MS Excel file is shown here. Only the first sheet can be used for
template design.




ELTECHS Engineering & Consulting Co., Ltd               15-17                                   e-DPP 3..0
Template Menu                                                              Cable Sizing Result

Document No.
Enter a document number with up to 64 characters. Document number is one of the items that can be
included in the header and/or footer.

Command Buttons

Create
Clicking this button brings up a dialog to enter a new template name with up to 64 characters. To
enable this button, you need to clear all the tab data first by clicking "Clear" button.

Copy
Clicking this button brings up a dialog to enter a new (destination) template name with up to 64
characters. New template name must be unique throughout the project.

Delete
When you want to delete the current template, click this button. Warning message will appear to
confirm the deletion action.

Clear
Clicking this button clears all the settings on three tabs. This action is required to create a new
template whenever any project is loaded.

MS Excel Cell Address

Print Area (Body & Footer Parts)
It is required to specify the Print Area of Excel sheet for the current template by selecting four
parameters from the pull down list.

Row Title area (header part) needs to be specified with MS Excel menu "File" → "Page Setup" →
"Sheet" → "Print Title".

Start Row
Row number of the top-left corner cell in the body part (see the image below).

End Row
Row number of the bottom-right corner cell in the footer part (see the image below).

Start Column
Column number (A, B, C, … AA, AB, AC,…) of the top-left corner cell in the body part (see the
image below).

End Column
Column number (A, B, C, … AA, AB, AC,…) of the bottom-right corner cell in the footer part (see the
image below).




ELTECHS Engineering & Consulting Co., Ltd           15-18                                  e-DPP 3..0
Template Menu                                                                Cable Sizing Result




                                       <Structure of Cable Sizing Results>

(Note: Footer part is not shown on the image above since it is defined with respect to the specified row
and column of the body part.)

Header Part
You can select the properties that you want to indicate in the header of Excel template. Check the
checkboxes for the properties and select the row and column items from the pull down lists. The
contents of pull down lists dynamically change depending on the specified values in "Print Area".

The items included in the header part are as follows:

 No.  Caption                   Description          No.       Caption        Description
  1 Proj title             Project Title              4      Proj code   Project Code
  2 Job No.                Job No.                    5      Engineer    Name of Engineer
  3 Location               Location                   6      Doc. No.    Document No.




ELTECHS Engineering & Consulting Co., Ltd                  15-19                               e-DPP 3..0
Template Menu                                                                  Cable Sizing Result

15.5.2 "Body Part" Tab




MS Excel Cell Address - Body

General Parameters

Number of data rows per page
Enter the number of data rows to be indicated in one Excel page (not sheet).

Blank line between data rows
Check this box to output data on every other line. With this option, only odd number lines are filled
with data.

Unit of PF, EFF and Load Factor
Select one of the units, either "Per Unit" or "Percent (%)", in which you want to indicate the values of
power factor, efficiency and loading factor.

Show Unit (*) of output rating
This option is intended for such a case as the header title already shows a default unit of output rating
of loads, for example "kW", it might nuisance to repeat the same unit description (kW) in every row.
When you check any of the boxes, i.e. "HP", "kW", "kVA" and "kvar", only the checked units are
indicated in the body part.

Data Columns
In the body part, it is required to specify only the column numbers (alphabets) for checked items.

The items included in the body part are as follows:




ELTECHS Engineering & Consulting Co., Ltd             15-20                                     e-DPP 3..0
Template Menu                                                                 Cable Sizing Result

 No.       Caption               Description        No.        Caption           Description
  1     Lock                Lock Option             26      Cable Type      Cable Type
  2     Load ID             Load ID                 27      # Cores         No. of Cores
  3     Equip. Type         Equipment Type          28      Wire Type "C"   Wire Type "C"
  4     Load Type           Load Type               29      Cable Size      Cable Size
  5     Service             Service                 30      #/Phase         Wires per Phase
  6     Cont. Qty           Continuous Quantity     31      Cable Length    Cable Length
  7     Inter. Qty          Intermittent Quantity   32      Resistance      Resistance
  8     Spare Qty           Spare Quantity          33      Reactance       Reactance
  9     Output              Output                  34      Base Amp.       Base Ampacity
 10     Unit                Unit of Output          35      Temp. Factor    Temperature Factor
 11     Phase No.           No. of Phase            36      Temp. Amp.      Temperature
                                                                            Ampacity
  12    KV                  Rated kV                37      RHO Factor      RHO Factor
  13    Poles               No. of Poles            38      Group Factor    Group Factor
  14    Volt. Class         Voltage Class           39      Derate Factor   Derating Factor
  15    System KV           System kV               40      Derated Amp.    Derated Ampacity
  16    FLC                 Full Load Current       41      VDrop @Run      Voltage    Drop      at
                                                                            Running
  17    App. MF             Application MF          42      Max Len Run     Maximum Length       at
                                                                            Running
  18    MF x FLC            MF x Full               43      VDrop @Start    Voltage    Drop      at
                            Load Current                                    Starting
  19    PF @FL              PF at Full Load         44      Max Len Start   Maximum Length       at
                                                                            Starting
  20    LRC (%)             Locked Rotor            45      Amp. Ratio      Ampacity Ratio
                            Current
  21    PF @LR              PF at Locked Rotor      46      Min Cab Size    Minimum Cable Size
  22    Raceway             Installation Method     47      Min Sec Area    Minimum Sectional
                                                                            Area
  23    Cable ID            Cable ID                48      Recalculated    Recalculated
  24    Conductor           Type of Conductor       49      User Cab Size   User Defined Size
  25    Cable Volt.         Cable Voltage           50      Sized Factor    Sized Factor




ELTECHS Engineering & Consulting Co., Ltd                 15-21                                   e-DPP 3..0
Template Menu                                                                Cable Sizing Result

15.5.3 "Footer Part" Tab




MS Excel Cell Address - Footer part
The items included in the footer part are as follows:

 No.  Caption                   Description        No.       Caption         Description
  1 Proj title             Project Title            4      Proj code    Project Code
  2 Job No.                Job No.                  5      Engineer     Name of Engineer
  3 Location               Location

 No.          Group                           Caption                  Description
 42 Page information                        Page #         Page number
 43                                         Total #        Total number of pages
 44 Document No.                            No.            Document No.

Last page only (General information)
Check this box to indicate the general information like project title, job no., etc in footer of the last
page only.




ELTECHS Engineering & Consulting Co., Ltd                15-22                                  e-DPP 3..0
Template Menu                                                                  Cable Sizing Chart


15.6 Cable Sizing Chart
User is allowed to design desired forms to output the results of power cable sizing chart (refer to
chapter 13) in this menu.




                               <Template Design dialog for Cable Sizing Results>

In general, a report form for calculation results consists of three parts, i.e. header, main body and
footer. The dialog shown above has three tabs "General & Header Part", "Body Part" and "Footer Part"
accordingly. By this, user is allowed to design each part on each tab independently.


15.6.1 "General & Header Part" Tab

Template

Template Information

Template Name
Select a template you want to edit from the pull down list.

MS Excel File
Select MS Excel file with "Browse" button. Full path name is limited to 255 characters.

Sheet
The first sheet name of the selected MS Excel file is shown here. Only the first sheet can be used for
template design.




ELTECHS Engineering & Consulting Co., Ltd               15-23                                e-DPP 3..0
Template Menu                                                              Cable Sizing Chart

Document No.
Enter a document number with up to 64 characters. Document number is one of the items that can be
included in the header and/or footer.

Command Buttons

Create
Clicking this button brings up a dialog to enter a new template name with up to 64 characters. To
enable this button, you need to clear all the tab data first by clicking "Clear" button.
Prior to creation of new template, a desired option in "General Parameters" - "Load Type" needs to be
selected. Once any option has been selected, user cannot change it.

Copy
Clicking this button brings up a dialog to enter a new (destination) template name with up to 64
characters. New template name must be unique throughout the project. The Load Type of destination
template is always the same as that of source template.

Delete
When you want to delete the current template, click this button. Warning message will appear to
confirm the deletion action.

Clear
Clicking this button clears all the settings on three tabs. This action is required to create a new
template whenever any project is loaded.

General Parameters

Load Type
When user creates a new template, one of the options, i.e. "Motor" or "Static Load" needs to be
selected.
When "Motor" is selected as a load type, no item is hidden.
When "Static Load" is selected as a load type, items "VDrop@LR", "Pole" and "Enclosure" in
"Header Part" and "Footer Part" are hidden.




ELTECHS Engineering & Consulting Co., Ltd          15-24                                    e-DPP 3..0
Template Menu                                                                 Cable Sizing Chart



MS Excel Cell Address




                                        <Structure of Cable Sizing Chart>

(Note: Footer part is not shown in the image above since items were already included in the header
part. For other template design, user has the option on what to include for the header and the footer
part.)

Header Part
You can select the properties that you want to indicate in the header of Excel template. Check the
checkboxes for the properties and select the row (1-30) and column (A-AZ) items from the pull down
lists. The contents of pull down lists are now fixed.

The items included in the header part are as follows:

     No.       Caption               Description         No.       Caption        Description
      1      Client             Client                   17      Load Type   Load Type
      2      Project            Project                  18      Load kV     Load kV
      3      Job No             Job No                   19      Phase No    No. of Phase
      4      Doc No             Document No              20      Poles       No. of Poles
      5      Date               Date                     21      Enclosure   Enclosure
      6      Rev No             Revision No              22      Cab Std     Cable Standard
      7      Sys kV             System kV                23      Cab Unit    Cable Unit
      8      Frequency          Frequency                24      Conduit     Conduit
      9      VDrop@Run          Voltage Drop             25      Conduct     Conductor
                                at Running
      10     VDrop@LR           Voltage Drop             26      CabVolt     Cable Voltage
                                at Motor Starting
      11     Ph-Wire            Wire per Phase           27      CabType     Cable Type
      12     Raceway            Installation Method      28      # Cores     No. of Cores




ELTECHS Engineering & Consulting Co., Ltd                15-25                                  e-DPP 3..0
Template Menu                                                               Cable Sizing Chart

     No. Caption                   Description        No.      Caption          Description
     13 Amb Temp                Ambient Temperature   29      AG Temp     Above Ground
                                                                          Temperature
      14     Temp F             Temperature Factor    30      UG Temp     Underground
                                                                          Temperature
      15     Group F            Group Factor          31      Cnd Temp    Conductor Temperature
      16     Derate F           Derating Factor       32      File Name   File Name


15.6.2 "Body Part" Tab




MS Excel Cell Address - Body

General Parameters

Number of Cable Data Columns
Enter the number of Cable Data Columns to be indicated in Excel output (not sheet).

Start Row of Cable Data
Define the starting row for the cable data.

(Note 1: As the number of cable data rows are fixed to 5, it is required to consider those 5 rows when
defining the start row of load data.)

Start Column of Cable Data
Define the starting column for the cable data.

(Note 2: As the field type of "Cable Size" is text (not number), cell format in MS Excel sheet for them
has to be specified "Text". When AWG/kcmils unit is applied to cable sizes, for example, the size




ELTECHS Engineering & Consulting Co., Ltd             15-26                                   e-DPP 3..0
Template Menu                                                                Cable Sizing Chart

presentation "1/0", "2/0", "3/0" or "4/0" will be indicated in "date" format in Excel like "Jan-00",
"Feb-00", "Mar-00" or "Apr-00".)

Number of Load Data Columns
Enter the number of Load Data Columns to be indicated in Excel output (not sheet).

(Note 3: As the number of load data columns are fixed to 9 for motors and 7 for static loads, it is
required to consider those 9 or 7 columns when defining the start column of cable data.)

Start Row of Load Data
Define the starting row for the Load data.

Start Column of Load Data
Define the starting column for the Load data.


15.6.3 "Footer Part" Tab




MS Excel Cell Address - Footer part
Items on the Footer Part are the same as the Header. User has the option of what to include on the
report.

The items included in the footer part are as follows:


     No.  Caption                    Description        No.       Caption        Description
      1 Client                  Client                  17      Load Type   Load Type
      2 Project                 Project                 18      Load kV     Load kV
      3 Job No                  Job No.                 19      Phase No    No. Of Phase




ELTECHS Engineering & Consulting Co., Ltd               15-27                                  e-DPP 3..0
Template Menu                                                               Cable Sizing Chart

     No.       Caption                Description      No.       Caption        Description
      4      Doc No             Document No.           20      Poles       No. of Poles
      5      Date               Date                   21      Enclosure   Enclosure
      6      Rev No             Revision No.           22      Cab Std     Cable Standard
      7      Sys kV             System kV              23      Cab Unit    Cable Unit
      8      Frequency          Frequency              24      Conduit     Conduit
      9      VDrop@Run          Voltage Drop           25      Conduct     Conductor
                                at Running
      10     VDrop@LR           Voltage Drop           26      CabVolt     Cable Voltage
                                at Starting
      11     Ph-Wire            Wire per Phase         27      CabType     Cable Type
      12     Raceway            Installation Method    28      # Cores     No. of Cores
      13     Amb Temp           Ambient Temperature    29      AG Temp     Above Ground
                                                                            Temperature
      14     Temp F             Temperature Factor     30      UG Temp     Underground
                                                                           Temperature
      15     Group F            Group Factor           31      Cnd Temp    Conductor Temperature
      16     Derate F           Derating Factor        32      File Name   File Name


                                             <End of Chapter 15>




ELTECHS Engineering & Consulting Co., Ltd              15-28                                  e-DPP 3..0

								
To top