Spreadsheet: 64785d1265632178-auto-update-or-resync-values-in-data-validated-lists-elec-toolkit-v5
Sheet: Design Data

 | Yes | Not Applicable
 | No
 | Lookup Table for 3-Phase Motors
 | Motor Rating Range (kW) |  | P.F. | Efficiency
 | 0 | 0.5 | 0.78 | 0.75
 | 0.75 | 1.8 | 0.85 | 0.83
 | 2.2 | 4 | 0.86 | 0.865
 | 5.5 | 10 | 0.88 | 0.895
 | 11 | 20 | 0.89 | 0.91
 | 22 | 40 | 0.9 | 0.925
 | 45 | 80 | 0.9 | 0.93
 | 90 | 150 | 0.9 | 0.95
 | 160 | 315 | 0.91 | 0.95
 | 335 | 400 | 0.92 | 0.95
 | Lookup Table for 3-Phase Motors
 | Motor Rating Range (A) |  | P.F. | Efficiency
 | 0.247 | 1.234 | 0.78 | 0.75
 | 1.534 | 3.683 | 0.85 | 0.83
 | 4.269 | 7.761 | 0.86 | 0.865
 | 10.079 | 18.326 | 0.88 | 0.895
 | 19.604 | 35.643 | 0.89 | 0.91
 | 38.143 | 69.351 | 0.9 | 0.925
 | 77.601 | 137.957 | 0.9 | 0.93
 | 151.934 | 253.224 | 0.9 | 0.95
 | 267.137 | 525.926 | 0.91 | 0.95
 | 553.239 | 660.584 | 0.92 | 0.95
 |  | BS88 | Single-core 70°C thermoplastic non-arm Cu Table 4D1
 |  | BS1361 | Multicore 70°C thermoplastic insulated/sheathed non-arm Cu Table 4D2
 | Single | BS EN60898 MCB | Single-core 70°C thermoplastic non-mag armoured Cu Table 4D3
 | Grouped | [NAME] MCB | Multicore 70°C thermoplastic insulated, armoured Cu Table 4D4
 |  |  | Single-core 90°C thermosetting insulated, non-arm Cu Table 4E1
 | CPD BS88 [NAME] |  | Multicore 90°C thermosetting insulated/sheathed non-arm Cu Table 4E2
 | 2 |  | Multicore 90°C thermosetting insulated non-arm LSF Cu Table 4E2
 | 4 |  | Single-core 90°C thermosetting insulated non-mag armoured Cu Table 4E3
 | 6 |  | Single-core 90°C thermosetting insulated non-mag arm LSF Cu Table 4E3
 | 10 |  | Multicore 90°C thermosetting insulated armoured Cu Table 4E4
 | 16 |  | Multicore 90°C thermosetting insulated armoured LSF Cu Table 4E4
 | 20
 | 25
 | 32
 | 40
 | 50
 | 63
 | 80
 | 100
 | 125
 | 160
 | 200
 | 250
 | 315
 | 400
 | 500
 | 630
 | 800
 | 1000
 | 1250
 | Source details
 | 3 Ph / 3 Ph + N
 | 1 Ph + N
 | 3 Ph Motor Details
 | 1 Ph Motor Details
 | Grouping Factors Cg
 | Table 4C4x - Multicore, [NAME] and ladder installations, Grouping rating factors (Cg)
 | Installation Method | Arrangement | No. of trays, ladders | No. of cables per tray or ladder
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 12 | 16 | 20
 | 31 | [NAME] | 1 | 1 | 0.88 | 0.82 | 0.77 | 0.75 | 0.73 | 0.73 | 0.72 | 0.72 | 0.72 | 0.72 | 0.72
 | 31 | [NAME] | 2 | 1 | 0.87 | 0.8 | 0.77 | 0.73 | 0.73 | 0.68 | 0.68 | 0.68
 | 31 | [NAME] | 3 | 1 | 0.86 | 0.79 | 0.76 | 0.71 | 0.71 | 0.66 | 0.66 | 0.66
 | 31 | [NAME] | 4 | 1 | 0.84 | 0.77 | 0.73 | 0.68 | 0.68 | 0.64 | 0.64 | 0.64
 | 31 | [NAME] | 5 | 1 | 0.84 | 0.77 | 0.73 | 0.68 | 0.68 | 0.64 | 0.64 | 0.64
 | 31 | [NAME] | 6 | 1 | 0.84 | 0.77 | 0.73 | 0.68 | 0.68 | 0.64 | 0.64 | 0.64
 | 31 | [NAME] | 1 | 1 | 1 | 0.98 | 0.95 | 0.91 | 0.91
 | 31 | [NAME] | 2 | 1 | 0.99 | 0.96 | 0.92 | 0.87 | 0.87
 | 31 | [NAME] | 3 | 1 | 0.98 | 0.95 | 0.91 | 0.85 | 0.85
 | 31 | Vertical Touching | 1 | 1 | 0.88 | 0.82 | 0.77 | 0.75 | 0.73 | 0.73 | 0.72 | 0.72 | 0.72 | 0.72 | 0.72
 | 31 | Vertical Touching | 2 | 1 | 0.88 | 0.81 | 0.76 | 0.71 | 0.71 | 0.7 | 0.7 | 0.7
 | 31 | Vertical Spaced | 1 | 1 | 0.91 | 0.89 | 0.88 | 0.87 | 0.87
 | 31 | Vertical Spaced | 2 | 1 | 0.91 | 0.88 | 0.87 | 0.85 | 0.85
 | 30 | [NAME] | 1 | 0.97 | 0.84 | 0.78 | 0.75 | 0.71 | 0.71 | 0.68 | 0.68 | 0.68 | 0.68 | 0.68 | 0.68
 | 30 | [NAME] | 2 | 0.97 | 0.83 | 0.76 | 0.72 | 0.68 | 0.68 | 0.63 | 0.63 | 0.63
 | 30 | [NAME] | 3 | 0.97 | 0.82 | 0.75 | 0.71 | 0.66 | 0.66 | 0.61 | 0.61 | 0.61
 | 30 | [NAME] | 4 | 0.97 | 0.81 | 0.73 | 0.69 | 0.63 | 0.63 | 0.58 | 0.58 | 0.58
 | 30 | [NAME] | 5 | 0.97 | 0.81 | 0.73 | 0.69 | 0.63 | 0.63 | 0.58 | 0.58 | 0.58
 | 30 | [NAME] | 6 | 0.97 | 0.81 | 0.73 | 0.69 | 0.63 | 0.63 | 0.58 | 0.58 | 0.58
 | 32 | [NAME] | 1 | 1 | 0.87 | 0.82 | 0.8 | 0.8 | 0.79 | 0.79 | 0.78 | 0.78 | 0.78 | 0.78 | 0.78
 | 33 | [NAME] | 1 | 1 | 0.87 | 0.82 | 0.8 | 0.8 | 0.79 | 0.79 | 0.78 | 0.78 | 0.78 | 0.78 | 0.78
 | 34 | [NAME] | 1 | 1 | 0.87 | 0.82 | 0.8 | 0.8 | 0.79 | 0.79 | 0.78 | 0.78 | 0.78 | 0.78 | 0.78
 | 32 | [NAME] | 2 | 1 | 0.86 | 0.8 | 0.78 | 0.76 | 0.76 | 0.73 | 0.73 | 0.73
 | 33 | [NAME] | 2 | 1 | 0.86 | 0.8 | 0.78 | 0.76 | 0.76 | 0.73 | 0.73 | 0.73
 | 34 | [NAME] | 2 | 1 | 0.86 | 0.8 | 0.78 | 0.76 | 0.76 | 0.73 | 0.73 | 0.73
 | 32 | [NAME] | 3 | 1 | 0.85 | 0.79 | 0.76 | 0.73 | 0.73 | 0.7 | 0.7 | 0.7
 | 33 | [NAME] | 3 | 1 | 0.85 | 0.79 | 0.76 | 0.73 | 0.73 | 0.7 | 0.7 | 0.7
 | 34 | [NAME] | 3 | 1 | 0.85 | 0.79 | 0.76 | 0.73 | 0.73 | 0.7 | 0.7 | 0.7
 | 32 | [NAME] | 4 | 1 | 0.84 | 0.77 | 0.73 | 0.68 | 0.68 | 0.64 | 0.64 | 0.64
 | 33 | [NAME] | 4 | 1 | 0.84 | 0.77 | 0.73 | 0.68 | 0.68 | 0.64 | 0.64 | 0.64
 | 34 | [NAME] | 4 | 1 | 0.84 | 0.77 | 0.73 | 0.68 | 0.68 | 0.64 | 0.64 | 0.64
 | 32 | [NAME] | 5 | 1 | 0.84 | 0.77 | 0.73 | 0.68 | 0.68 | 0.64 | 0.64 | 0.64
 | 33 | [NAME] | 5 | 1 | 0.84 | 0.77 | 0.73 | 0.68 | 0.68 | 0.64 | 0.64 | 0.64
 | 34 | [NAME] | 5 | 1 | 0.84 | 0.77 | 0.73 | 0.68 | 0.68 | 0.64 | 0.64 | 0.64
 | 32 | [NAME] | 6 | 1 | 0.84 | 0.77 | 0.73 | 0.68 | 0.68 | 0.64 | 0.64 | 0.64
 | 33 | [NAME] | 6 | 1 | 0.84 | 0.77 | 0.73 | 0.68 | 0.68 | 0.64 | 0.64 | 0.64
 | 34 | [NAME] | 6 | 1 | 0.84 | 0.77 | 0.73 | 0.68 | 0.68 | 0.64 | 0.64 | 0.64
 | 32 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 33 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 34 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | 32 | [NAME] | 2 | 1 | 0.99 | 0.98 | 0.97 | 0.96 | 0.96
 | 33 | [NAME] | 2 | 1 | 0.99 | 0.98 | 0.97 | 0.96 | 0.96
 | 34 | [NAME] | 2 | 1 | 0.99 | 0.98 | 0.97 | 0.96 | 0.96
 | 32 | [NAME] | 3 | 1 | 0.98 | 0.97 | 0.96 | 0.93 | 0.93
 | 33 | [NAME] | 3 | 1 | 0.98 | 0.97 | 0.96 | 0.93 | 0.93
 | 34 | [NAME] | 3 | 1 | 0.98 | 0.97 | 0.96 | 0.93 | 0.93
 | Cable tray, ladder system, cleats, wire mesh tray | In conduit | In trunking/ducting (reference B) | Direct in wall. Ceiling void | On, or spaced from, wall of ceiling | In moulding, architrave or window frame | Miscellaneous |  | Cable tray, ladder system, cleats, wire mesh tray | installstep24d1aa
 | 30 - On horizontal/vertical unperforated tray | 1 - In conduit in a thermally insulated wall | 7 - In vertical trunking on a wooden/masonry wall | 40 - In a building void | 20 - Clipped direct on a wooden/masonry wall | 12 - In mouldings | 35 - Suspended from/incorporating a support wire |  | In conduit | installstep24d1ab |  |  |  | 30 - On horizontal/vertical unperforated tray | config4d1atreflat |  | Configuration
 | 31 - On horizontal/vertical perforated tray | 4 - In conduit on a wooden/masonry wall | 10 - In suspended trunking | 47 - In a ceiling void or suspended floor | 21 - Under a wooden/masonry ceiling | 15 - In architrave | 56 - In open/ventilated horizontal/vertical channel |  | In trunking/ducting (reference B) | installstep24d1ac |  |  |  | 31 - On horizontal/vertical perforated tray | config4d1aall |  | Horizontal flat spaced
 | 32 - On horizontal/vertical wire mesh tray | 41 - In conduit in a building void | 13 - In skirting trunking | 57 - Direct in masonry (without capping) | 22 - Spaced from a ceiling | 16 - In window frame | Run through thermal insulation |  | Direct in wall. Ceiling void | installstep24d1ad |  |  |  | 32 - On horizontal/vertical wire mesh tray | config4d1aall |  | Vertical flat spaced
 | 33 - Spaced from a wall | 42 - In conduit in a building void | 43 - In ducting in a building void | 58 - Direct in masonry (with capping) | 33 - Spaced from a wall |  |  |  | On, or spaced from, wall of ceiling | installstep24d1ae |  |  |  | 33 - Spaced from a wall | config4d1aall |  | Trefoil
 | 34 - On a ladder | 54 - In conduit in an unventilated cable channel | 45 - In ducting in masonry |  |  |  |  |  | In moulding, architrave or window frame | installstep24d1af |  |  |  | 34 - On a ladder | config4d1aall |  | Flat touching
 |  | 55 - In conduit in open/ventilated floor channel | 50 - In flush trunking in floor |  |  |  |  |  | Miscellaneous | installstep24d1ag |  |  |  |  | Not Applicable
 |  | 59 - In conduit in masonry | 52 - In flush trunking
 |  | add section for earthing for 1 and 59 |  | add section forMeasures for protection of cables installed in Walls or Partition |  |  | add distance for thermal
 | TABLE 4D1A
 | Conductor CSA | Reference method A  Enclosed in conduit in thermally insulating wall etc) |  | Reference method B Enclosed in conduit on a wall or in trunking etc) |  | Reference method C Clipped direct |  | Reference method F (in free air or on perforated cable tray horizontal or vertical) |  |  |  |  |  |  | TABLE 4D1B
 |  |  |  |  |  |  |  | Touching |  |  | Spaced by one diameter |  |  |  | Conductor CSA | 2 cables d.c. | 2 cables, single-phase a.c. |  |  |  |  |  |  |  |  | 3 or 4 cables, three-phase a.c.
 |  | 2 cables, single-phase a.c. or d.c. | 3 or 4 cables, three-phase a.c. | 2 cables, single-phase a.c. or d.c. | 3 or 4 cables, three-phase a.c. | 2 cables, single-phase a.c. or d.c. flat and touching | 3 or 4 cables, three-phase a.c. flat and touching and trefoil | 2 cables, single-phase a.c. or d.c. flat | 3 cables, three-phase a.c. flat | 3 cables, three-phase a.c. trefoil | 2 cables, single-phase a.c. or d.c. or 3 cables three-phase a.c. flat |  |  |  |  |  | Reference methods A & B (enclosed in conduit or trunking) |  |  | Reference method C & F (clipped direct, on tray or in free air) |  |  |  |  |  | Reference methods A & B (enclosed in conduit or trunking) |  |  | Reference method C & F (clipped direct, on tray or in free air)
 |  |  |  |  |  |  |  |  |  |  | Horizontal | Vertical |  |  |  |  |  |  |  | cables touching |  |  | cables spaced |  |  |  |  |  | cables touching, Trefoil |  |  | [NAME], flat |  |  | cables spaced, flat
 | 1 | 11 | 10.5 | 13.5 | 12 | 15.5 | 14 |  |  |  |  |  |  |  | 1 | 44 | 44 |  |  | 44 |  |  | 44 |  |  | 38 |  |  | 38 |  |  | 38 |  |  | 38
 | 1.5 | 14.5 | 13.5 | 17.5 | 15.5 | 20 | 18 |  |  |  |  |  |  |  | 1.5 | 29 | 29 |  |  | 29 |  |  | 29 |  |  | 25 |  |  | 25 |  |  | 25 |  |  | 25
 | 2.5 | 20 | 18 | 24 | 21 | 27 | 25 |  |  |  |  |  |  |  | 2.5 | 18 | 18 |  |  | 18 |  |  | 18 |  |  | 15 |  |  | 15 |  |  | 15 |  |  | 15
 | 4 | 26 | 24 | 32 | 28 | 37 | 33 |  |  |  |  |  |  |  | 4 | 11 | 11 |  |  | 11 |  |  | 11 |  |  | 9.5 |  |  | 9.5 |  |  | 9.5 |  |  | 9.5
 | 6 | 34 | 31 | 41 | 36 | 47 | 43 |  |  |  |  |  |  |  | 6 | 7.3 | 7.3 |  |  | 7.3 |  |  | 7.3 |  |  | 6.4 |  |  | 6.4 |  |  | 6.4 |  |  | 6.4
 | 10 | 46 | 42 | 57 | 50 | 65 | 59 |  |  |  |  |  |  |  | 10 | 4.4 | 4.4 |  |  | 4.4 |  |  | 4.4 |  |  | 3.8 |  |  | 3.8 |  |  | 3.8 |  |  | 3.8
 | 16 | 61 | 56 | 76 | 68 | 87 | 79 |  |  |  |  |  |  |  | 16 | 2.8 | 2.8 |  |  | 2.8 |  |  | 2.8 |  |  | 2.4 |  |  | 2.4 |  |  | 2.4 |  |  | 2.4
 | 25 | 80 | 73 | 101 | 89 | 114 | 104 | 131 | 114 | 110 | 146 | 130 |  |  | 25 | 1.75 | 1.8 | 0.33 | 1.8 | 1.75 | 0.2 | 1.75 | 1.75 | 0.29 | 1.8 | 1.5 | 0.29 | 1.55 | 1.5 | 0.175 | 1.5 | 1.5 | 0.25 | 1.55 | 1.5 | 0.32 | 1.55
 | 35 | 99 | 89 | 125 | 110 | 141 | 129 | 162 | 143 | 137 | 181 | 162 |  |  | 35 | 1.25 | 1.3 | 0.31 | 1.3 | 1.25 | 0.195 | 1.25 | 1.25 | 0.28 | 1.3 | 1.1 | 0.27 | 1.1 | 1.1 | 0.17 | 1.1 | 1.1 | 0.24 | 1.1 | 1.1 | 0.32 | 1.15
 | 50 | 119 | 108 | 151 | 134 | 182 | 167 | 196 | 174 | 167 | 219 | 197 |  |  | 50 | 0.93 | 0.95 | 0.3 | 1 | 0.93 | 0.19 | 0.95 | 0.93 | 0.28 | 0.97 | 0.81 | 0.26 | 0.85 | 0.8 | 0.165 | 0.82 | 0.8 | 0.24 | 0.84 | 0.8 | 0.32 | 0.86
 | 70 | 151 | 136 | 192 | 171 | 234 | 214 | 251 | 225 | 216 | 281 | 254 |  |  | 70 | 0.63 | 0.65 | 0.29 | 0.72 | 0.63 | 0.185 | 0.66 | 0.63 | 0.27 | 0.69 | 0.56 | 0.25 | 0.61 | 0.55 | 0.16 | 0.57 | 0.55 | 0.24 | 0.6 | 0.55 | 0.31 | 0.63
 | 95 | 182 | 164 | 232 | 207 | 284 | 261 | 304 | 275 | 264 | 341 | 311 |  |  | 95 | 0.46 | 0.49 | 0.28 | 0.56 | 0.47 | 0.18 | 0.5 | 0.47 | 0.27 | 0.54 | 0.42 | 0.24 | 0.48 | 0.41 | 0.155 | 0.43 | 0.41 | 0.23 | 0.47 | 0.4 | 0.31 | 0.51
 | 120 | 210 | 188 | 269 | 239 | 330 | 303 | 352 | 321 | 308 | 396 | 362 |  |  | 120 | 0.36 | 0.39 | 0.27 | 0.47 | 0.37 | 0.175 | 0.41 | 0.37 | 0.26 | 0.45 | 0.33 | 0.23 | 0.41 | 0.32 | 0.15 | 0.36 | 0.32 | 0.23 | 0.4 | 0.32 | 0.3 | 0.44
 | 150 | 240 | 216 | 300 | 262 | 381 | 349 | 406 | 372 | 356 | 456 | 419 |  |  | 150 | 0.29 | 0.31 | 0.27 | 0.41 | 0.3 | 0.175 | 0.34 | 0.29 | 0.26 | 0.39 | 0.27 | 0.23 | 0.36 | 0.26 | 0.15 | 0.3 | 0.26 | 0.23 | 0.34 | 0.26 | 0.3 | 0.4
 | 185 | 273 | 245 | 341 | 296 | 436 | 400 | 463 | 427 | 409 | 521 | 480 |  |  | 185 | 0.23 | 0.25 | 0.27 | 0.37 | 0.24 | 0.17 | 0.29 | 0.24 | 0.26 | 0.35 | 0.22 | 0.23 | 0.32 | 0.21 | 0.145 | 0.26 | 0.21 | 0.22 | 0.31 | 0.21 | 0.3 | 0.36
 | 240 | 321 | 286 | 400 | 346 | 515 | 472 | 546 | 507 | 485 | 615 | 569 |  |  | 240 | 0.18 | 0.195 | 0.26 | 0.33 | 0.185 | 0.165 | 0.25 | 0.185 | 0.25 | 0.31 | 0.17 | 0.23 | 0.29 | 0.16 | 0.145 | 0.22 | 0.16 | 0.22 | 0.27 | 0.16 | 0.29 | 0.34
 | 300 | 367 | 328 | 458 | 394 | 594 | 545 | 629 | 587 | 561 | 709 | 659 |  |  | 300 | 0.145 | 0.16 | 0.26 | 0.31 | 0.15 | 0.165 | 0.22 | 0.15 | 0.25 | 0.29 | 0.14 | 0.23 | 0.27 | 0.13 | 0.14 | 0.19 | 0.13 | 0.22 | 0.25 | 0.13 | 0.29 | 0.32
 | 400 |  |  | 546 | 467 | 694 | 634 | 754 | 689 | 656 | 852 | 795 |  |  | 400 | 0.105 | 0.13 | 0.26 | 0.29 | 0.12 | 0.16 | 0.2 | 0.115 | 0.25 | 0.27 | 0.12 | 0.22 | 0.25 | 0.105 | 0.14 | 0.175 | 0.105 | 0.21 | 0.24 | 0.1 | 0.29 | 0.31
 | 500 |  |  | 626 | 533 | 792 | 723 | 868 | 789 | 749 | 982 | 920 |  |  | 500 | 0.086 | 0.11 | 0.26 | 0.28 | 0.098 | 0.155 | 0.185 | 0.093 | 0.24 | 0.26 | 0.1 | 0.22 | 0.25 | 0.086 | 0.135 | 0.16 | 0.086 | 0.21 | 0.23 | 0.081 | 0.29 | 0.3
 | 630 |  |  | 720 | 611 | 904 | 826 | 1005 | 905 | 855 | 1138 | 1070 |  |  | 630 | 0.068 | 0.094 | 0.25 | 0.27 | 0.081 | 0.155 | 0.175 | 0.076 | 0.24 | 0.25 | 0.08 | 0.22 | 0.24 | 0.072 | 0.135 | 0.15 | 0.072 | 0.21 | 0.22 | 0.066 | 0.28 | 0.29
 | 800 |  |  |  |  | 1030 | 943 | 1086 | 1020 | 971 | 1265 | 1188 |  |  | 800 | 0.053 |  |  |  | 0.068 | 0.15 | 0.165 | 0.061 | 0.24 | 0.25 |  |  |  | 0.06 | 0.13 | 0.145 | 0.06 | 0.21 | 0.22 | 0.053 | 0.28 | 0.29
 | 1000 |  |  |  |  | 1154 | 1058 | 1216 | 1149 | 1079 | 1420 | 1337 |  |  | 1000 | 0.042 |  |  |  | 0.059 | 0.15 | 0.16 | 0.05 | 0.24 | 0.24 |  |  |  | 0.052 | 0.13 | 0.14 | 0.052 | 0.2 | 0.21 | 0.044 | 0.28 | 0.28