Spreadsheet: 73081d1273744707-the-source-currently-evaluates-to-an-error-bs7671-v7
Sheet: Factors (Cg)

Grouping factors
Table 4C1 - Air installations, Grouping rating factors (Cg)
Item | No. of Circuits/Cables
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 12 | 16 | 20
Bunched in air, on a surface, embedded or enclosed | 1 | 0.8 | 0.7 | 0.65 | 0.6 | 0.57 | 0.54 | 0.52 | 0.5 | 0.45 | 0.41 | 0.38
Single layer on wall or floor | 1 | 0.85 | 0.79 | 0.75 | 0.73 | 0.72 | 0.72 | 0.71 | 0.7 | 0.7 | 0.7 | 0.7
Single Layer multicore on a perforated horizontal or vertical cable tray system | 1 | 0.88 | 0.82 | 0.77 | 0.75 | 0.73 | 0.73 | 0.72 | 0.72 | 0.72 | 0.72 | 0.72
Single layer multicore on cable ladder system or cleats | 1 | 0.87 | 0.82 | 0.8 | 0.8 | 0.79 | 0.79 | 0.78 | 0.78 | 0.78 | 0.78 | 0.78
Table 4C2 - Installed 'Direct in the ground', Grouping rating factors ([NAME])
No. of circuits | Cable/Cable clearance
dia/clearance | dia |  | Clearance (m)
 | 0 | 1 | 0.125 | 0.25 | 0.5
2 | 0.75 | 0.8 | 0.85 | 0.9 | 0.9
3 | 0.65 | 0.7 | 0.75 | 0.8 | 0.85
4 | 0.6 | 0.6 | 0.7 | 0.75 | 0.8
5 | 0.55 | 0.55 | 0.65 | 0.7 | 0.8
6 | 0.5 | 0.55 | 0.6 | 0.7 | 0.8
Table 4C3 – Cables in Ducts - grouping rating factors ([NAME])
No. of circuits | Multicore cables installed in single-way ducts | Single-core cables installed in single-way ducts
 | Clearance (m) | Clearance (m)
[4/2] | 0 | 0.25 | 0.5 | 1 | 0 | 0.25 | 0.5 | 1
2 | 0.85 | 0.9 | 0.95 | 0.95 | 0.8 | 0.9 | 0.9 | 0.95
3 | 0.75 | 0.85 | 0.9 | 0.95 | 0.7 | 0.8 | 0.85 | 0.9
4 | 0.7 | 0.8 | 0.85 | 0.9 | 0.65 | 0.75 | 0.8 | 0.9
5 | 0.65 | 0.8 | 0.85 | 0.9 | 0.6 | 0.7 | 0.8 | 0.9
6 | 0.6 | 0.8 | 0.8 | 0.9 | 0.6 | 0.7 | 0.8 | 0.9
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
Table 4C5 – Single-core, [NAME] and ladder installations, Grouping rating factors (Cg)
Installation Method | Arrangement | No. of trays, ladder | No. of cables per tray or ladder
 |  |  | 1 | 2 | 3
31 | Horizontal Flat Touching | 1 | 0.98 | 0.91 | 0.87
31 | Horizontal Flat Touching | 2 | 0.96 | 0.87 | 0.81
31 | Horizontal Flat Touching | 3 | 0.95 | 0.85 | 0.78
31 | Vertical Flat Touching | 1 | 0.96 | 0.86
31 | Vertical Flat Touching | 2 | 0.95 | 0.84
32 | Horizontal Flat Touching | 1 | 1 | 0.97 | 0.96
33 | Horizontal Flat Touching | 1 | 1 | 0.97 | 0.96
34 | Horizontal Flat Touching | 1 | 1 | 0.97 | 0.96
32 | Horizontal Flat Touching | 2 | 0.98 | 0.93 | 0.89
33 | Horizontal Flat Touching | 2 | 0.98 | 0.93 | 0.89
34 | Horizontal Flat Touching | 2 | 0.98 | 0.93 | 0.89
32 | Horizontal Flat Touching | 3 | 0.97 | 0.9 | 0.86
33 | Horizontal Flat Touching | 3 | 0.97 | 0.9 | 0.86
34 | Horizontal Flat Touching | 3 | 0.97 | 0.9 | 0.86
31 | Horizontal Trefoil Spaced | 1 | 1 | 0.98 | 0.96
31 | Horizontal Trefoil Spaced | 2 | 0.97 | 0.93 | 0.89
31 | Horizontal Trefoil Spaced | 3 | 0.96 | 0.92 | 0.86
31 | Vertical Trefoil Spaced | 1 | 1 | 0.91 | 0.89
31 | Vertical Trefoil Spaced | 2 | 1 | 0.9 | 0.86
32 | Horizontal Trefoil Spaced | 1 | 1 | 1 | 1
33 | Horizontal Trefoil Spaced | 1 | 1 | 1 | 1
34 | Horizontal Trefoil Spaced | 1 | 1 | 1 | 1
32 | Horizontal Trefoil Spaced | 2 | 0.97 | 0.95 | 0.93
33 | Horizontal Trefoil Spaced | 2 | 0.97 | 0.95 | 0.93
34 | Horizontal Trefoil Spaced | 2 | 0.97 | 0.95 | 0.93
32 | Horizontal Trefoil Spaced | 3 | 0.96 | 0.94 | 0.9
33 | Horizontal Trefoil Spaced | 3 | 0.96 | 0.94 | 0.9
34 | Horizontal Trefoil Spaced | 3 | 0.96 | 0.94 | 0.9