Spreadsheet: 57330d1257437836-referencing-many-closed-workbooks-01031109
Sheet: 01031109

[NAME]) | 690 | 700 | 688 | 688 | 680 | 678 | 676 | 672 | 672 | 672 | 684 | 692 | 722 | 728 | 742 | 788 | 840 | 876 | 842 | 834 | 856 | 884 | 902 | 888 | 862 | 826 | 840 | 860 | 864 | 884 | 852 | 832 | 784 | 782 | 750 | 730 | 712 | 710 | 686 | 684 | 682 | 666 | 654 | 662 | 642 | 652 | 634 | 576
Feeder A(kVAr) | 128 | 130 | 122 | 128 | 122 | 120 | 118 | 122 | 118 | 114 | 116 | 118 | 134 | 134 | 132 | 162 | 172 | 192 | 184 | 174 | 176 | 194 | 214 | 204 | 200 | 178 | 192 | 202 | 208 | 224 | 214 | 202 | 170 | 166 | 160 | 152 | 138 | 136 | 124 | 122 | 130 | 112 | 104 | 110 | 96 | 102 | 94 | 82
[NAME]) | 672 | 680 | 668 | 668 | 662 | 662 | 658 | 658 | 652 | 658 | 668 | 678 | 716 | 722 | 742 | 786 | 842 | 878 | 846 | 838 | 860 | 886 | 904 | 890 | 872 | 832 | 844 | 868 | 870 | 890 | 860 | 838 | 792 | 786 | 754 | 734 | 712 | 706 | 684 | 682 | 680 | 664 | 648 | 656 | 634 | 640 | 622 | 564
[NAME]) | 36 | 38 | 32 | 36 | 32 | 30 | 28 | 34 | 28 | 24 | 26 | 24 | 36 | 32 | 30 | 48 | 54 | 66 | 62 | 56 | 54 | 70 | 82 | 78 | 74 | 60 | 70 | 76 | 80 | 96 | 88 | 80 | 56 | 52 | 50 | 46 | 38 | 34 | 28 | 24 | 30 | 16 | 12 | 16 | 8 | 12 | 8 | 4
Nitrogen(m³) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sub 3, [NAME]) | 110 | 100 | 110 | 100 | 100 | 100 | 100 | 110 | 100 | 100 | 110 | 120 | 110 | 110 | 120 | 130 | 130 | 140 | 140 | 150 | 140 | 140 | 120 | 100 | 110 | 100 | 110 | 110 | 110 | 120 | 130 | 120 | 130 | 120 | 130 | 120 | 120 | 100 | 110 | 110 | 100 | 100 | 80 | 80 | 80 | 80 | 80 | 70
Sub 3, LT1(kW) | 74 | 83 | 75 | 82 | 78 | 72 | 74 | 74 | 71 | 74 | 74 | 73 | 76 | 84 | 76 | 89 | 113 | 113 | 106 | 106 | 105 | 115 | 124 | 140 | 116 | 116 | 109 | 105 | 107 | 99 | 96 | 92 | 94 | 95 | 88 | 84 | 76 | 80 | 77 | 74 | 75 | 74 | 75 | 81 | 73 | 69 | 67 | 62
N/A
Sub 2, 2T1(kW) | 78 | 86 | 79 | 81 | 83 | 78 | 83 | 81 | 77 | 82 | 80 | 77 | 86 | 87 | 102 | 109 | 106 | 99 | 92 | 87 | 95 | 100 | 96 | 102 | 104 | 96 | 99 | 98 | 98 | 105 | 93 | 93 | 88 | 77 | 78 | 76 | 69 | 73 | 69 | 67 | 73 | 65 | 68 | 71 | 66 | 71 | 71 | 60
Sub 2 , 2T2(kW) | 60 | 59 | 57 | 57 | 57 | 55 | 56 | 55 | 53 | 54 | 53 | 54 | 55 | 55 | 56 | 58 | 64 | 66 | 64 | 65 | 64 | 72 | 70 | 64 | 67 | 62 | 64 | 64 | 64 | 64 | 63 | 63 | 61 | 61 | 58 | 58 | 59 | 58 | 58 | 58 | 57 | 56 | 56 | 56 | 55 | 54 | 55 | 49
Sub 5, 5T7(kW) | 91 | 91 | 91 | 93 | 99 | 91 | 87 | 87 | 88 | 88 | 108 | 106 | 110 | 115 | 123 | 125 | 127 | 132 | 145 | 140 | 135 | 136 | 139 | 141 | 141 | 137 | 140 | 142 | 145 | 149 | 139 | 134 | 130 | 123 | 117 | 113 | 112 | 107 | 105 | 102 | 101 | 101 | 102 | 101 | 102 | 98 | 96 | 78
Sub 5, 5T8(kW) | 179 | 187 | 180 | 179 | 158 | 178 | 173 | 168 | 176 | 176 | 176 | 176 | 198 | 191 | 196 | 205 | 205 | 206 | 208 | 201 | 210 | 213 | 230 | 221 | 217 | 231 | 218 | 213 | 218 | 227 | 209 | 208 | 205 | 194 | 193 | 182 | 184 | 194 | 178 | 183 | 182 | 172 | 171 | 185 | 156 | 171 | 145 | 150
Natural Gas(m³) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Natural Gas Gate Hse(ft³) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 200 | 90 | 90 | 30 | 10 | 10 | 0 | 10 | 0 | 10 | 10 | 0 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 0
Mains Water Gate Hse(m³) | 2.443 | 3.254 | 2.887 | 2.268 | 2.475 | 2.347 | 2.24 | 2.807 | 2.542 | 2.343 | 2.794 | 3.928 | 2.752 | 2.47 | 3.183 | 3.526 | 3.211 | 2.728 | 4.223 | 4.535 | 3.419 | 4.112 | 4.534 | 3.784 | 4.812 | 3.478 | 4.303 | 3.01 | 4.687 | 3.973 | 3.924 | 2.586 | 3.406 | 3.237 | 2.586 | 2.782 | 4.207 | 3.309 | 2.662 | 2.595 | 3.005 | 3.582 | 2.42 | 2.434 | 2.44 | 3.955 | 2.039 | 2.62
Mains Water Sub Station(m³) | 0.42 | 0.33 | 0.12 | 0.46 | 0.45 | 0.32 | 0.31 | 0.33 | 0.36 | 0.69 | 0.48 | 0.35 | 4.74 | 8.11 | 8.6 | 8.67 | 9.07 | 9.58 | 9.94 | 7.27 | 7.15 | 9.54 | 9.62 | 10.48 | 9.89 | 9.95 | 9.52 | 5 | 14.54 | 0 | 12.9 | 1.13 | 0.02 | 0.86 | 0.85 | 0.66 | 0.47 | 0.43 | 0.56 | 0.22 | 0.34 | 0.57 | 0.44 | 0.32 | 0.34 | 0.49 | 0.48 | 0.3
Sub 6 - 6T9(kW) | 14 | 14 | 14 | 14 | 14 | 14 | 13 | 14 | 13 | 13 | 14 | 14 | 16 | 16 | 16 | 16 | 16 | 18 | 17 | 18 | 18 | 20 | 20 | 22 | 22 | 21 | 18 | 16 | 14 | 14 | 14 | 13 | 12 | 12 | 12 | 11 | 12 | 12 | 11 | 11 | 10 | 10 | 9 | 10 | 10 | 10 | 9 | 9
Sub 6- 6T8(kW) | 15 | 17 | 16 | 17 | 17 | 17 | 17 | 18 | 17 | 17 | 18 | 17 | 18 | 17 | 19 | 24 | 58 | 57 | 41 | 59 | 86 | 65 | 48 | 52 | 26 | 21 | 65 | 54 | 46 | 45 | 46 | 46 | 33 | 33 | 23 | 33 | 36 | 15 | 21 | 21 | 17 | 18 | 18 | 18 | 18 | 17 | 19 | 16
Sub 9(kW) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
N/A
N/A
N/A
N/A
N/A
Sub 7, 7T11(kW) | 234 | 223 | 231 | 226 | 228 | 222 | 229 | 226 | 227 | 223 | 226 | 225 | 243 | 245 | 239 | 245 | 254 | 255 | 245 | 243 | 249 | 258 | 257 | 252 | 251 | 255 | 248 | 253 | 242 | 232 | 237 | 223 | 224 | 222 | 220 | 225 | 207 | 216 | 210 | 207 | 205 | 204 | 209 | 205 | 220 | 218 | 221 | 196
Sub 7, 7T12(kW) | 221 | 223.5 | 219.5 | 224 | 222 | 223 | 219.5 | 220.5 | 221 | 219.5 | 221.5 | 217 | 222.5 | 221 | 227 | 228.5 | 234 | 235.5 | 234.5 | 236 | 238.5 | 239.5 | 242.5 | 243 | 241 | 241 | 240.5 | 235.5 | 240 | 252 | 236 | 236.5 | 233 | 226 | 230 | 235 | 232 | 230.5 | 229 | 226.5 | 227 | 224 | 218 | 217 | 213 | 211 | 210.5 | 194.5
Sub 4, 4J1(kW) | 40 | 40 | 40 | 40 | 40 | 39 | 39 | 40 | 38 | 38 | 40 | 38 | 41 | 47 | 51 | 58 | 62 | 63 | 60 | 65 | 64 | 64 | 67 | 68 | 67 | 67 | 68 | 67 | 66 | 67 | 64 | 55 | 48 | 48 | 48 | 43 | 43 | 45 | 42 | 42 | 43 | 41 | 42 | 40 | 38 | 39 | 40 | 36
Sub 4, 4T1(kW) | 61 | 62 | 62 | 61 | 63 | 59 | 61 | 63 | 60 | 62 | 63 | 68 | 79 | 78 | 85 | 102 | 114 | 119 | 119 | 116 | 126 | 119 | 120 | 120 | 119 | 121 | 121 | 122 | 118 | 116 | 116 | 111 | 105 | 106 | 98 | 98 | 94 | 92 | 91 | 91 | 88 | 85 | 72 | 79 | 76 | 71 | 69 | 62
Sub 10, 10A(kW) | 52 | 50 | 50 | 48 | 46 | 47 | 47 | 46 | 44 | 40 | 40 | 45 | 44 | 40 | 39 | 45 | 44 | 43 | 41 | 46 | 40 | 39 | 41 | 39 | 40 | 39 | 41 | 41 | 43 | 47 | 44 | 44 | 45 | 43 | 45 | 47 | 46 | 47 | 43 | 46 | 46 | 40 | 43 | 42 | 37 | 43 | 42 | 35
Sub 10, 10B(kW) | 124 | 128 | 125 | 124 | 124 | 128 | 125 | 124 | 123 | 129 | 124 | 123 | 124 | 130 | 126 | 125 | 126 | 133 | 128 | 127 | 128 | 133 | 128 | 128 | 128 | 133 | 128 | 128 | 126 | 131 | 126 | 125 | 125 | 131 | 124 | 125 | 126 | 129 | 123 | 124 | 123 | 129 | 123 | 124 | 123 | 128 | 123 | 111
N/A
N/A
N/A
N/A
N/A
PF(/) | 0.9832 | 0.9832 | 0.9846 | 0.9831 | 0.9843 | 0.9847 | 0.9851 | 0.9839 | 0.9849 | 0.9859 | 0.9859 | 0.9858 | 0.9832 | 0.9835 | 0.9845 | 0.9795 | 0.9797 | 0.9768 | 0.9769 | 0.9789 | 0.9795 | 0.9768 | 0.973 | 0.9746 | 0.9741 | 0.9776 | 0.9749 | 0.9735 | 0.9722 | 0.9694 | 0.9699 | 0.9718 | 0.9773 | 0.9782 | 0.978 | 0.979 | 0.9817 | 0.9821 | 0.9841 | 0.9845 | 0.9823 | 0.9862 | 0.9876 | 0.9865 | 0.989 | 0.988 | 0.9892 | 0.99
Feeder A PF(Calc) | 0.9832 | 0.9832 | 0.9846 | 0.9831 | 0.9843 | 0.9847 | 0.9851 | 0.9839 | 0.9849 | 0.9859 | 0.9859 | 0.9858 | 0.9832 | 0.9835 | 0.9845 | 0.9795 | 0.9797 | 0.9768 | 0.9769 | 0.9789 | 0.9795 | 0.9768 | 0.973 | 0.9746 | 0.9741 | 0.9776 | 0.9749 | 0.9735 | 0.9722 | 0.9694 | 0.9699 | 0.9718 | 0.9773 | 0.9782 | 0.978 | 0.979 | 0.9817 | 0.9821 | 0.9841 | 0.9845 | 0.9823 | 0.9862 | 0.9876 | 0.9865 | 0.989 | 0.988 | 0.9892 | 0.99
[NAME]) | 0.9986 | 0.9984 | 0.9989 | 0.9986 | 0.9988 | 0.999 | 0.9991 | 0.9987 | 0.9991 | 0.9993 | 0.9992 | 0.9994 | 0.9987 | 0.999 | 0.9992 | 0.9981 | 0.9979 | 0.9972 | 0.9973 | 0.9978 | 0.998 | 0.9969 | 0.9959 | 0.9962 | 0.9964 | 0.9974 | 0.9966 | 0.9962 | 0.9958 | 0.9942 | 0.9948 | 0.9955 | 0.9975 | 0.9978 | 0.9978 | 0.998 | 0.9986 | 0.9988 | 0.9992 | 0.9994 | 0.999 | 0.9997 | 0.9998 | 0.9997 | 0.9999 | 0.9998 | 0.9999 | 1
Total [NAME] ([NAME]) | 1362 | 1380 | 1356 | 1356 | 1342 | 1340 | 1334 | 1330 | 1324 | 1330 | 1352 | 1370 | 1438 | 1450 | 1484 | 1574 | 1682 | 1754 | 1688 | 1672 | 1716 | 1770 | 1806 | 1778 | 1734 | 1658 | 1684 | 1728 | 1734 | 1774 | 1712 | 1670 | 1576 | 1568 | 1504 | 1464 | 1424 | 1416 | 1370 | 1366 | 1362 | 1330 | 1302 | 1318 | 1276 | 1292 | 1256 | 1140
Sub 2 Total(Calc) | 138 | 145 | 136 | 138 | 140 | 133 | 139 | 136 | 130 | 136 | 133 | 131 | 141 | 142 | 158 | 167 | 170 | 165 | 156 | 152 | 159 | 172 | 166 | 166 | 171 | 158 | 163 | 162 | 162 | 169 | 156 | 156 | 149 | 138 | 136 | 134 | 128 | 131 | 127 | 125 | 130 | 121 | 124 | 127 | 121 | 125 | 126 | 109
Sub 3 Total(Calc) | 184 | 183 | 185 | 182 | 178 | 172 | 174 | 184 | 171 | 174 | 184 | 193 | 186 | 194 | 196 | 219 | 243 | 253 | 246 | 256 | 245 | 255 | 244 | 240 | 226 | 216 | 219 | 215 | 217 | 219 | 226 | 212 | 224 | 215 | 218 | 204 | 196 | 180 | 187 | 184 | 175 | 174 | 155 | 161 | 153 | 149 | 147 | 132
Sub 4 Total(Calc) | 101 | 102 | 102 | 101 | 103 | 98 | 100 | 103 | 98 | 100 | 103 | 106 | 120 | 125 | 136 | 160 | 176 | 182 | 179 | 181 | 190 | 183 | 187 | 188 | 186 | 188 | 189 | 189 | 184 | 183 | 180 | 166 | 153 | 154 | 146 | 141 | 137 | 137 | 133 | 133 | 131 | 126 | 114 | 119 | 114 | 110 | 109 | 98
Sub 5 Total(Calc) | 270 | 278 | 271 | 272 | 257 | 269 | 260 | 255 | 264 | 264 | 284 | 282 | 308 | 306 | 319 | 330 | 332 | 338 | 353 | 341 | 345 | 349 | 369 | 362 | 358 | 368 | 358 | 355 | 363 | 376 | 348 | 342 | 335 | 317 | 310 | 295 | 296 | 301 | 283 | 285 | 283 | 273 | 273 | 286 | 258 | 269 | 241 | 228
Sub 6 Total(Calc) | 29 | 31 | 30 | 31 | 31 | 31 | 30 | 32 | 30 | 30 | 32 | 31 | 34 | 33 | 35 | 40 | 74 | 75 | 58 | 77 | 104 | 85 | 68 | 74 | 48 | 42 | 83 | 70 | 60 | 59 | 60 | 59 | 45 | 45 | 35 | 44 | 48 | 27 | 32 | 32 | 27 | 28 | 27 | 28 | 28 | 27 | 28 | 25
Sub 7 Total(Calc) | 455 | 446.5 | 450.5 | 450 | 450 | 445 | 448.5 | 446.5 | 448 | 442.5 | 447.5 | 442 | 465.5 | 466 | 466 | 473.5 | 488 | 490.5 | 479.5 | 479 | 487.5 | 497.5 | 499.5 | 495 | 492 | 496 | 488.5 | 488.5 | 482 | 484 | 473 | 459.5 | 457 | 448 | 450 | 460 | 439 | 446.5 | 439 | 433.5 | 432 | 428 | 427 | 422 | 433 | 429 | 431.5 | 390.5
Sub10 Total(Calc) | 176 | 178 | 175 | 172 | 170 | 175 | 172 | 170 | 167 | 169 | 164 | 168 | 168 | 170 | 165 | 170 | 170 | 176 | 169 | 173 | 168 | 172 | 169 | 167 | 168 | 172 | 169 | 169 | 169 | 178 | 170 | 169 | 170 | 174 | 169 | 172 | 172 | 176 | 166 | 170 | 169 | 169 | 166 | 166 | 160 | 171 | 165 | 146
N/A
N/A
N/A
N/A
N/A
N/A