Building Services Electrical Design Support - Overview / Help
INDEX        KVAR        PANEL        TRAY       BUSBAR     LIGHT    CABLES
        CAPACITOR BANK                PANEL BOARD                CABLE TRAY
              CABLES                     CONVERT                   Q.CALS
                                                                   UNDER
                                                                CONSTRUCTION
        Building Services_Electrical Design Support
                                        HELP
ABLES   CONV.      Q.CALS   MECH.        HELP
         BUS BAR              LIGHTING
                                                XXXXXXXXXXXXX
                                                            XXXXXXXXXXXXX
        MECHANICAL
                               MAY
                               HELP
                                YOU
XXXXXXXXXXXXX
            XXXXXXXXXXXXX
                        XXXXXXXXXXXXX
                                    XXXXXXXXXXXXX
                                                XXXXXXXXXXXXX
                                                            XXXXXXXXXXXXX
XXXXXXXXXXXXX
            XXXXXXXXXXXXX
                           CAPACITOR BANK_kVAR RATING CALCULATION
PROJECT NAME:                                                                  DATE:
CAPACITOR PANEL REF:                                                           PREPARED BY:
PROJECT NO:                                                                    PAGE NO:
            Load in Kilowatts   Normal Power factor   Improving Power factor
 Ref.No           (Kw)                  (p.f)                  (p.f)           Required kVAR Selected kVAR
   1               900                  0.85                    0.9               121.88
   2               500                   0.7                    0.9               267.94
   3               900                   0.5                    0.8               883.85
   4
   5
   6
   7
   8
   9
                                                      Grand Total                    1273.67
Formulae
kVAR = P x ( tanØ1 - tanØ2)
Where as,
P - Power in watts                                          Comments
tanØ1 =   tan(cos-1 p.f)                                    Approved
tanØ2 =   tan(cos-1 p.f)                                    Date
BS_EDS                                                                                            V.Prathi
                                  PANEL BOARD _ SIZING CALCULATION
     HEIGHT       1900         PROJECT NAME:                              DATE:
     WIDTH        2000         PANEL REF:                                 PREPARED BY:
                               PROJECT NO:                                PAGE NO:
                                                                                                    1900
     Chk Avl Ht          300   Chk Avl Ht      300    250   300          300        250   300
                                                     2000
                                                                  Comments
                                                                  Approved
                                                                  Date
BS_EDS                                                                                          V.Prathi
                CABLE TRAY _ SIZE CALCULATION
PROJECT NAME:                                               DATE:
CABLE TRAY REF:                                             PREPARED BY:
PROJECT NO:                                                 PAGE NO:
Cable Type                          Cable Overall                      Layer1
                    Size in Sq.mm   Diameter in mm              Nos.            Width
XLPE/SWA/PVC
2 Core              6mm                              15.9        4               64
                    10mm                              18         6               108
                    16mm                              20                          -
                    25mm                             24.3                         -
                    35mm                             27.9                         -
4 Core              6mm                              18.7                         -
                    10mm                             21.1                         -
                    16mm                             22.9                         -
                    25mm                             29.1                         -
                    35mm                             32.1                         -
                    50mm                              32                          -
                    70mm                             37.7                         -
                    95mm                             41.7        1               42
                    120mm                            47.1        5               236
                    150mm                            51.4                         -
                    185mm                            56.6                         -
                    240mm                             63         1               63
                    300mm                            68.8                         -
Single Core 6491B (LSF)
                    10mm                              6.8                         -
                    16mm                               8                          -
                    25mm                              9.8                         -
                    35mm                              11                          -
                    50mm                              13                          -
                    70mm                              15                          -
                                                                                  -
MICC/PVC Heavy Duty
2 core              1.5mm (2H1.5)                     9.6                         -
                    2.5mm (2H2.5)                    10.4                         -
                    4mm (2H4)                        11.5                         -
                    6mm (2H6)                        12.6                         -
                    10mm (2H10)                      14.4                         -
4 core              2.5mm (4H2.5)                    11.8                         -
                    4mm (4H4)                        13.1                         -
                    6mm (4H6)                        14.4                         -
                    10mm (4H10)                      16.5                         -
                    16mm (4h16)                      19.6                         -
                    25mm (4h25)                      22.9                         -
Total Number of Cables                                           17
Cable width required                                                                   640 on 1 layers
Number of layers                            1                 Comments
Tolerance                                  25%                Approved
Selected cable tray size in mm             700                Date
                                         BUS BAR _ VOLTAGE DROP CALCULATION
        CONSTANTS
Cos Ø:            0.90                   PROJECT NAME:              Raffles city Tower 1                                   DATE:            10.07.08
Sin Ø:            0.44                   PART :                     From 25 to 17                                          PREPARED BY:     PV
Diversitiy:       0.80                   BUSBAR NO:                 B3                                                     PAGE NO:                  1
Utility Voltage(V)          415          PROJECT NO:                    2006069
                                   POWER      LINE                                       RESISTANCE REACTANCE
                      LENGTH                                        BUSBAR                                                   VOLTAGE         VOLTAGE
     OUTLET NO                             CURRENT                                               (     ( mohm
                         (m)                                             ()                                                  DROP ( Vd )     DROP %E
                                    ( kW )       (A)                                      mohm /m )    /m )
      25TH FLOOR         3.50          70              87          KBC-II 1600 (Cu)            0.02550           0.03360             0.02           0.00
      24TH FLOOR         3.50          60              161         KBC-II 1600 (Cu)            0.02550           0.03360             0.04           0.01
      23TH FLOOR         3.50          60              235         KBC-II 1600 (Cu)            0.02550           0.03360             0.05           0.01
      22TH FLOOR         3.50          75              328         KBC-II 1600 (Cu)            0.02550           0.03360             0.07           0.02
      21TH FLOOR         3.50          75              420         KBC-II 1600 (Cu)            0.02550           0.03360             0.10           0.02
      20TH FLOOR         3.50          70              507         KBC-II 1600 (Cu)            0.02550           0.03360             0.12           0.03
      19TH FLOOR         3.50          75              600         KBC-II 1600 (Cu)            0.02550           0.03360             0.14           0.03
      18TH FLOOR         3.50          70              686         KBC-II 1600 (Cu)            0.02550           0.03360             0.16           0.04
      17TH FLOOR        104.00         70              773         KBC-II 1600 (Cu)            0.02550           0.03360             5.23           1.26
                                                                   KBC-II 1600 (Cu)            0.02550           0.03360
                                                                   KBC-II 1600 (Cu)            0.02550           0.03360
                                                                   KBC-II 1600 (Cu)            0.02550           0.03360
                                                                   KBC-II 1600 (Cu)            0.02550           0.03360
                                                                   KBC-II 1600 (Cu)            0.02550           0.03360
                                                                   KBC-II 1600 (Cu)            0.02550           0.03360
                                                                   KBC-II 1600 (Cu)            0.02550           0.03360
                                                                   KBC-II 1600 (Cu)            0.02550           0.03360
                                                                   KBC-II 1600 (Cu)            0.02550           0.03360
                                                                   KBC-II 1600 (Cu)            0.02550           0.03360
                                                                   KBC-II 1600 (Cu)            0.02550           0.03360
TOTAL :                132.00         625                                                                                            5.92          1.43
COMMENTS :           As the voltage drop percentage is lower then 4% , the selected busbar current is correct.             Result:
VOLTAGE DROP%E =                                                           1.43
Formulae
ΔV = α√3.L.I(R.Cos Ø + X1.Sin Ø) 10 ¯³ [V]
Where as,
ΔV = Voltage Drop (V)                          R       = Resistance (mΩ/m)
α      = Load Distribution Constant            X1      = Inductive Reactance (mΩ/m)                          Comments
L      = Line Length (m)                       Cos Ø = Load Factor                                           Approved
I      = Line Current (A)                      Note: a constant is on amperic value                          Date
    BS_EDS                                                                                                                                       V.Prathi
                                       LIGHTING _ CALCULATION
PROJECT NAME:                                                                 DATE:
BLOCK REF:                                                                    PREPARED BY:
PROJECT NO:                                                                   PAGE NO:
Room Ref.          Room Data               Illumination Data       Lumens /
                                                                                 Lumens O/P   No.of Fittings Req.
            Length   Width   Height   Lux Req   Wattage of Lamps    Fitting
Kitchen        5       4       2.8       200            18          1500         7142.8571            5
Dining         4       4        4        200            8            950         8113.5903            9
Majlis         4       4        3        150            13          1200         4524.8869            4
                                                        15          1300
                                                        18          1500
                                                        26          2000
                                                        30          2650
                                                        40          3000
                                                        50          4800
                                                        70          5800
                                                        80          7350
                                                        90          8000
Total Lumens O/P (Required)                        19781.3343
Total Number of Fittings (Required)                    18
Formulae
Lumens O/P = Lux(Req.) x Area / M.F x U.F
Where as,
M.F   =     Maintenance Factor                                                Comments
U.F   =     Utilisation Factor                                                Approved
R.I   =     Area x (Length x Breadth) / Height x (Length + Breadth)           Date
     CABLE SELECTION CURRENT RATING_VOLTAGE DROP_PROTECTIVE CONDUCTOR
PROJECT NAME:                                                                        DATE:
BLOCK REF:                                                                           PREPARED BY:
PROJECT NO:                                                                          PAGE NO:
Distribution Board Reference
Circuit Number
Type
Design Current              Ib                                       2
Type of Cable
Type of Protective Device
Protective Device Rating     In                                      2
Correction Factors:
                                  Ca - Ambient Temp                   3
                              Ci - Thermal Insulation                 4
                              Cp - Protection Device                  5
Single Circuit Current Rating In/Ca x Ci x Cp = It          0.033333333
Groups of Circuits (other than BS3036 fuses)
Number of circuits (where Ib > 0.3 x Cg x Ib)
Group Rating Factor "Cg" =(from table 4B1, 4B2,
4B3)                                                                 5
Are Circuits Liable to Simultaneous Overload? Y/N       n
                                                It ³         1.46860478
Minimum Conductor Rating = Largest It/Ca x Ci =             0.122383732
Cable size chosen mm2
Maximum Permissable Voltage Drop
Length of Run     (metres)                                           88
mV/A/m Parameter of Cable                                             8
Actual Voltage Drop: (Ib x L x mV/A/m) /1000   V                  1.408
Phase Conductor Resistance ohms/m
Resistance R1 ohms                                                  44
Maximum Disconnection Time 0.4s or 5s
Maximum Zs ohms
CPC constant "K" (BS7671)
CPC ohms/m
Resistance R2 ohms                                                   8
Ze                                                                   9
Actual Zs ohms (Radial) Zs = Ze + R1 + R2                           61
Actual Zs ohms (Ring) Zs = Ze + 0.25(R1 + R2)                       22
Is Actual Zs £ Maximum Zs ? If NO, recalculate
If = Uo/Actual Zs
Time t from Appendix 3 (BS7671)       sec.                            8
I=                                                                    2
k=                                                                    3
Minimum Size of CPC                 mm2                     3.265986324
Actual Size of CPC
Actual Size Acceptable? Y/N
If NO increase CPC size to          mm2
                                                                          Comments
                                                                          Approved
                                                                          Date
     Electrical Conversion                  P.F                Power                       Length
                     1000                   0.8                               1                             5
                     1250                                                   1.0139                      8800.00359
     Volume                    Energy                   Kinematic Viscosity           Dynamic Viscosity
                       1                   13650                              1                             1
                35.31466247              4.00042052                        0.000001                     0.00067197
  Molar Flowrate                Mass                       Mass Flowrate                  Heat Flux
                       1                     1                                1                             1
                   0.3786675             2239.96911                      0.00755987                      3.154591
Volumetric Flowrate            Density                Heat Transfer Coefficient        Specific Energy
                      490                    1                                1                             1
                288.4029637              0.01601846                      0.00056783                       2326
     Pressure                   Area                   Thermal Conductivity             Specific Heat
                      14.5                   1                                1                             1
                0.999739765              10.7639104                      0.01730735                       4186.8
   INDEX           KVAR       PANEL          TRAY        BUSBAR         LIGHT     CABLES
Areawise Electrical load requirements.
Project Type:                              Required Power Load in Kilowatts       41400
Cooling Strategy                           Power Factor (P.F)                       0.8
Total Area in Sq.m                 450000 Required Power Load in KVA              51750
Voltage Drop,Current Ratings of XLPE Multi Core Cables
Connected Load in                                                             Cable Size
                    Length in mtrs         Total Voltage Drop (Vd) in Volts
Amps (A)                                                                      in Sq.mm
        35                    75                          6.5625
Total Voltage Drop in %                                   1.6006
Voltage Drop,Current Ratings of PVC Multi Core Cables
Connected Load in                                                             Cable Size
                    Length in mtrs         Total Voltage Drop (Vd) in Volts
Amps (A)                                                                      in Sq.mm
        25                   120                            12
Total Voltage Drop in %                                   2.9268
Under Construction
   Generators, Switchgears, Protective Devices, ELV Solutions, Earthing, Lightning Protection, Aircra
                              IP's, Standards , Codes & Advance Technology Updates
            ABLES       CONV.        Q.CALS     MECH.   HELP
                  Approximate No. of 1.5MVA
                    Transformer's Required
                                                36
                    Max.Current Carrying
                   Capacity of the Selected     59
                      cable in Amps (A)
                    Max.Current Carrying
                   Capacity of the Selected     47
                      cable in Amps (A)
, Earthing, Lightning Protection, Aircraft Warnings ,
ce Technology Updates
INDEX          KVAR           PANEL           TRAY    BUSBAR           LIGHT          CABLES
Electric Power Conversion for Mechanical loads in Building Services
                       Fans                                                Pumps
               Volumetric flow                                       Volumetric flow
                                            21500
Static Pressure in millimeters                 60    Head in Meters
Power Required in Kilowatts              28.67       Power Required in Kilowatts
Formulae                                             Formulae
P = (Air flow x Static pressure) / (t x η x 75)      P = (Q x H x δ ) / ( 367 x η )
Where as,                                            Where as,
P - Power                                            Q - Discharge
t - Time in seconds                                  H - Head in meters
η - Effeciency                                       δ - Density
       ABLES     CONV.   Q.CALS   MECH.   HELP
mps
etric flow
                 650
                  40
             104.18
INDEX          KVAR           PANEL           TRAY          BUSBAR            LIGHT         CABLES
Building Services Electrical Design Support - Overview / Help
Instructions
You may move from worksheet to worksheet by clicking on the blue buttons
located at the top of each worksheet or the blue tabs at the bottom of this workbook.
Enter data in only the white cells with gray borders:        81
Use the drop down boxes                       to select the standard values
KVAR (Capacitor bank)
Create a quick and easy result for the required KVAR rating for the capacitor panel by filling out the white cells on the "Capac
Sheet. As in the calculation format fill the connected load in kilowatts ,initial Power factor (P.F) and correction Power Factor .
KVAR rating of the capacitor panel for individual sections as well Bulk. Either select the exact value or select the next availa
(Comply with local regulations.)
Panel
Use this "Panel sizing calculation sheet" to get the size of the LV panel's. Use drop down box at the Top left of the format to s
Use the drop down boxes in the format to get the standard ratings of the incomers & Outgoings. Select the breaker ratings b
boxes in the compartments, Note that the down side dimensions should not be "Check availabilty Height".In such a case, Eith
Protective Device instead of high rated Protective device or remove (select empty ----------- indicates no compartment) any of
 / Compartment in that particular column.
Tray
In this sheet there are two formats for the cable tray selection whereas first format will gives the exact width with our customis
our local regulations) and the second format will be considered as the international standard with having the expand space fa
more for the security reasons notified by the NFPA standards & it should be mainly considered in industrial projects as well a
Busbar
Uses this "Busbar_ Voltage drop calculation" sheet to select the Copper busbar ratings . The constant values are common fo
distance & connected loads at every tapoff can be fill by rows. The Diversity factor applied by us in the white cell is considere
Select the available standard ratings of bus bars by using the drop down boxes. "Increase (A) rating" indicates that the select
Line current, By selecting the higher size will gives the good result if the voltege drop must not exceeds the limit.
Light
Uses this “Lighting_ Calculation” to find the total lumens O/P & number of fittings required for an area by our recommended l
in watts and also fill the inputs such as length, Width & height of the area in the white cells with grey borders.
Cable
In this sheet there are two format for Cable schedule. You can customize your format for the cable schedule as per your stan
Conv.
Enter the value in white cells with grey borders & select the units by using drop down boxes for Unit conversions.
Q.Cals.
Area wise Electrical Load requirements: As per CIBSE rule of thumb we can determine the Approximate electrical load & Ma
Ampere Transformer's required by filling total area of the project in Square meter, Also select the Type of project,Infra and fi
Voltage drop.Current ratings of Multicore XLPE & PVC Cables : Create a quick and easy selection of cable by filling out the w
"Quick Cals" sheet. Enter the "Amps rating,length of cable" in the white cell.Select the "Standard Cable Size"by using the dr
in the cell. The Total Voltage drop & Percentage of Votage Drop (Vd) are calculated for you. "Increase cable size for CCC"
can't carry the connected load, for solution Select the next size cable.
           ABLES         CONV.          Q.CALS          MECH.           HELP
nel by filling out the white cells on the "Capacitor bank_kVAR calculation"
er factor (P.F) and correction Power Factor .We will get the required
 lect the exact value or select the next available rating in the market.
op down box at the Top left of the format to select the height of the Panel.
 s & Outgoings. Select the breaker ratings by using the drop down
Check availabilty Height".In such a case, Either replace the Low Rated
y ----------- indicates no compartment) any of the Protective device
at will gives the exact width with our customised tolerance (ie as per
 al standard with having the expand space factor / Groupings having 50%
nly considered in industrial projects as well as in highrise buildings.
ratings . The constant values are common for the calculation. Floor levels,
or applied by us in the white cell is considered in the line current.
"Increase (A) rating" indicates that the selected Busbar rating the
drop must not exceeds the limit.
 required for an area by our recommended lux level & type of fitting
white cells with grey borders.
rmat for the cable schedule as per your standard format.
own boxes for Unit conversions.
ermine the Approximate electrical load & Max. Number 1.5Mega Volt
 r, Also select the Type of project,Infra and fill the available power factor.
nd easy selection of cable by filling out the white cells on the
ect the "Standard Cable Size"by using the drop down menu provided
ated for you. "Increase cable size for CCC" indicates the selected cable
                                            By V.Pradeesh (2007-08)