Spreadsheet: 77303d1277812370-multiple-lookup-table-schedule-of-circuit-details-for-lamination
Sheet: Test Results 

 | Schedule of Circuit Details
 | Distribution Board |  |  | Lighting and Power |  |  | Source of Supply |  |  |  |  | ORIGIN DB2 |  |  | No Phases |  | 1 |  |  |  |  | Nominal Voltage |  |  | 230V
 | Location |  |  |  |  |  | Supply Cable : Type |  |  |  |  | 6241BH |  |  | [NAME]25mm2 |  |  |  |  |  |  | CPC 6491BH CSA 25mm2
 | Designation |  |  | DB1 |  |  | Overcurrent Protective : Type |  |  |  |  |  |  |  | BS 1361 IIA |  |  |  |  |  |  | Rating 60/80A
 | Main Switch:  Type |  |  | BS EN 60947 |  | Rating | 100 | A | Ze at | DB1 | = | 0.29 | Ω |  |  |  |  |  |  |  |  |  |  |  | [NAME]: |  |  | TNCS |  | Ipfc at DB1 |  | 1.1 | kA
 | Circuit Number | Phase Number | Circuit Details |  |  |  |  | Wiring Type | Installation Method | Number of Points Served | CSA Live mm2 | CSA CPC mm2 | X Measured R1+R2 | Real R1+R2 | R1 | Rn | R2 | Phase / Phase (MΩ) | Phases / Neutral (MΩ) | Phases / Earth (MΩ) | Neutral / Earth (MΩ) | Polarity | Max Permitted Disconnection Time (s) | Overcurrent Protective Device |  |  |  | RCD |  |  | Maximum Circuit Zs Permitted (Ω) | Actual Zs (Ω) =                         Ze+(R1 + R2) | Pass / Fail
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BS EN | Type | Rating (A) | Short Circuit Capacity (KA) | Operating Current mA | Operating Times at I∆n ms | Operating Times at 5  I∆n (if applicable) ms
 | 1 | 1 | Radial Circuit - Hob |  |  |  |  | A | 3 | 1 | 10 | 4 | N/A | 0.09 | 0.036 | 0.09 | 0.054 | >500 | >500 | >500 | >500 | √ | 5 | 61009 | B | 40 | 6 | 30 | 34.2 | 8.2 | 0.92 | 0.38 | Pass
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | if you can I need -                                                                                                                         IF Column X9 =5 +  Column Z9= B + Column AA9=40 then column AF9=P31                                                                                     giving a numerical  answer or N/A. THE VARIABLES ARE:-COLUMN X9 CAN =5 OR 0.4,                                                          COLUMN Z9 CAN =88, 1361, 3036, 1, 2, B, C, D                         AND COLUMN AA9 CAN = 5,6,10,15,16,20,25,30,32,40,45,50,60,63,80,100,125,160,   200, THESE VARIABLE NEED TO LOOKUP THE APPROPRIATE ANSWER IN THE TABLE TO THE [NAME], ANY HELP WILL VERY MUCH BE APPRECIATED
 | Limiting Values of Measured Earth Fault Loop Impedances for common oversurrent protective devices, for indirect contact, operating at 230v based on 80% (Approx) of the values given in BS7671-2008
 |  | Fuses |  |  |  |  |  | [NAME] to BS3871 or BSEN60898 oR RCBO to BSEN 61009
 |  | BS |  | 1361  Cartidge |  | BS Re-wireable |  | Type | Type | Type | Type | Type | Type | Type | Type | Type | Type
 |  | 88 |  | 1361 |  | 3036 |  | 1 | 2 | B | C | D | 1 | 2 | B | C | D
 | Rating | 0.4 | 5 | 0.4 | 5 | 0.4 | 5 | 0.4 |  |  |  |  | 5
 | 5 | N/A | N/A | 8.36 | 13.12 | 7.66 | 14.16 | 9.2 | 5.26 | N/A | N/A | N/A | 9.2 | 5.26 | N/A | N/A | N/A
 | 6 | 6.81 | 10.8 | N/A | N/A | N/A | N/A | 7.68 | 4.38 | 6.13 | 3.06 | 1.53 | 7.68 | 4.38 | 6.13 | 3.06 | 1.53
 | 10 | 4.08 | 5.93 | N/A | N/A | N/A | N/A | 4.6 | 2.63 | 3.68 | 1.84 | 0.92 | 4.6 | 2.63 | 3.68 | 1.84 | 0.92
 | 15 | N/A | N/A | 2.62 | 4 | 2.04 | 4.28 | 3.07 | 1.75 | N/A | N/A | N/A | 3.07 | 1.75 | N/A | N/A | N/A
 | 16 | 2.16 | 3.34 | N/A | N/A | N/A | N/A | 2.88 | 1.64 | 2.29 | 1.15 | 0.57 | 2.88 | 1.64 | 2.29 | 1.15 | 0.57
 | 20 | 1.41 | 2.32 | 1.36 | 2.24 | 1.41 | 3.06 | 2.3 | 1.3 | 1.84 | 0.92 | 1.45 | 2.3 | 1.3 | 1.84 | 0.92 | 1.45
 | 25 | 1.15 | 1.84 | N/A | N/A | N/A | N/A | 1.84 | 1.04 | 1.47 | 1.73 | 0.36 | 1.84 | 1.04 | 1.47 | 1.73 | 0.36
 | 30 | N/A | N/A | 0.92 | 1.47 | 0.87 | 2.11 | 1.53 | 0.87 | N/A | N/A | N/A | 1.53 | 0.87 | N/A | N/A | N/A
 | 32 | 0.83 | 1.47 | N/A | N/A | N/A | N/A | 1.44 | 0.82 | 1.15 | 0.57 | 0.28 | 1.44 | 0.82 | 1.15 | 0.57 | 0.28
 | 40 | N/A | 1.08 | N/A | N/A | N/A | N/A | 1.15 | 0.66 | 0.92 | 0.45 | 0.23 | 1.15 | 0.66 | 0.92 | 0.45 | 0.23
 | 45 | N/A | N/A | N/A | 0.76 | N/A | 1.27 | 1.02 | 0.58 | N/A | 1 | N/A | 1.02 | 0.58 | N/A | 1 | N/A
 | 50 | N/A | 0.83 | N/A | N/A | N/A | N/A | 0.92 | 0.52 | 0.73 | 0.36 | 0.18 | 0.92 | 0.52 | 0.73 | 0.36 | 0.18
 | 60 | N/A | N/A | N/A | 0.56 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
 | 63 | N/A | 0.65 | N/A | N/A | N/A | N/A | 0.72 | 0.41 | 0.58 | 0.28 | 1.14 | 0.72 | 0.41 | 0.58 | 0.28 | 1.14
 | 80 | N/A | 0.45 | N/A | 0.4 | N/A | N/A | 0.57 | 0.32 | 0.45 | 0.23 | 0.11 | 0.57 | 0.32 | 0.45 | 0.23 | 0.11
 | 100 | N/A | 0.33 | N/A | 0.28 | N/A | N/A | 0.46 | 0.25 | 0.36 | 0.18 | 0.08 | 0.46 | 0.25 | 0.36 | 0.18 | 0.08
 | 125 | N/A | 0.26 | N/A | N/A | N/A | N/A | N/A | N/A | 0.29 | 1.14 | 0.07 | N/A | N/A | 0.29 | 1.14 | 0.07
 | 160 | N/A | 0.2 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
 | 200 | N/A | 0.15 | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A