Spreadsheet: 77088d1277517861-excel-2007-sum-help-with-formula-waterflow-rate
Sheet: Sheet1

 |  |  | Water Rate Chart
 | Choke
Pressure | 0.046875 | 0.0625 | 0.078125 | 0.09375 | 0.109375 | 0.125 | 0.140625 | 0.15625 | 0.171875 | 0.1875 | 0.203125 | 0.21875 | 0.234375 | 0.25 | 0.265625 | 0.28125 | 0.296875 | 0.3125 | 0.34375 | 0.375 | 0.40625 | 0.4375 | 0.46875 | 0.5 | 0.53125 | 0.5625 | 0.59375 | 0.625 | 0.65625 | 0.6875 | 0.71875 | 0.75 | 1
5 | 3.068 | 5.454 | 8.522 | 12.27 | 16.7 | 21.82 | 27.61 | 34.09 | 41.25 | 49.09 | 57.61 | 66.82 | 77.05 | 87.27 | 98.89 | 110.5 | 123.45 | 136.4 | 165 | 194.4 | 230.44 | 267.28 | 308.19 | 349.1 | 395.55 | 442 | 493.8 | 545.6 | 660 | 660 | 718.8 | 777.6 | 1396.4
10 | 4.339 | 7.714 | 12.05 | 17.36 | 23.62 | 30.85 | 39.05 | 48.21 | 58.33 | 69.42 | 81.87 | 94.49 | 108.95 | 123.4 | 139.8 | 156.2 | 174.5 | 192.8 | 233.32 | 277.7 | 325.88 | 377.96 | 435.83 | 493.7 | 559.25 | 624.8 | 698 | 771.2 | 933.28 | 933.28 | 1022.04 | 1110.8 | 1974.8
20 | 6.136 | 10.91 | 17.04 | 24.54 | 33.41 | 43.63 | 55.23 | 68.18 | 82.5 | 98.18 | 115.2 | 133.6 | 154.05 | 174.5 | 197.7 | 220.9 | 246.8 | 272.7 | 330 | 392.7 | 460.8 | 534.4 | 616.3 | 698.2 | 790.9 | 883.6 | 987.2 | 1090.8 | 1320 | 1320 | 1445.4 | 1570.8 | 2792.8
40 | 8.678 | 15.43 | 24.1 | 34.71 | 47.25 | 61.71 | 78.1 | 96.42 | 116.7 | 138.8 | 162.9 | 189 | 217.9 | 246.8 | 279.6 | 312.4 | 349.05 | 385.7 | 466.7 | 555.4 | 651.6 | 756 | 871.65 | 987.3 | 1118.45 | 1249.6 | 1396.2 | 1542.8 | 1866.8 | 1866.8 | 2044.2 | 2221.6 | 3949.2
60 | 10.63 | 18.89 | 29.52 | 42.51 | 57.86 | 75.58 | 95.65 | 118.1 | 142.9 | 170 | 199.6 | 231.5 | 266.9 | 302.3 | 342.45 | 382.6 | 427.5 | 472.4 | 571.6 | 680.2 | 798.4 | 926 | 1067.5 | 1209 | 1369.7 | 1530.4 | 1710 | 1889.6 | 2286.4 | 2286.4 | 2503.6 | 2720.8 | 4836
80 | 12.27 | 21.82 | 34.09 | 49.09 | 66.82 | 87.27 | 110.5 | 136.4 | 165 | 196.4 | 230.4 | 267.3 | 308.2 | 349.1 | 395.45 | 441.8 | 493.6 | 545.4 | 660 | 785.4 | 921.6 | 1069.2 | 1232.6 | 1396 | 1581.6 | 1767.2 | 1974.4 | 2181.6 | 2640 | 2640 | 2890.8 | 3141.6 | 5584
100 | 13.72 | 24.39 | 38.11 | 54.88 | 74.7 | 97.57 | 123.5 | 152.5 | 184.5 | 219.5 | 257.6 | 298.8 | 344.55 | 390.3 | 442.1 | 493.9 | 551.85 | 609.8 | 738 | 878.1 | 1030.4 | 1195.2 | 1378.1 | 1561 | 1768.3 | 1975.6 | 2207.4 | 2439.2 | 2952 | 2952 | 3232.2 | 3512.4 | 6244
125 | 15.34 | 27.27 | 42.61 | 61.36 | 83.52 | 109.1 | 138.1 | 170.4 | 206.2 | 245.4 | 288.1 | 334.1 | 385.2 | 436.3 | 494.3 | 552.3 | 617.05 | 681.8 | 824.8 | 981.8 | 1152.4 | 1336.4 | 1540.7 | 1745 | 1977.1 | 2209.2 | 2468.2 | 2727.2 | 3299.2 | 3299.2 | 3613.2 | 3927.2 | 6980
150 | 16.8 | 29.87 | 46.68 | 67.22 | 91.49 | 119.5 | 151.2 | 186.7 | 225.9 | 268.9 | 315.6 | 366 | 422 | 478 | 541.5 | 605 | 675.95 | 746.9 | 903.6 | 1075 | 1262.4 | 1464 | 1688 | 1912 | 2166 | 2420 | 2703.8 | 2987.6 | 3614.4 | 3614.4 | 3957.2 | 4300 | 7648
175 | 18.15 | 32.27 | 50.42 | 72.6 | 98.82 | 129.1 | 163.4 | 201.7 | 244 | 290.4 | 340.8 | 395.3 | 455.8 | 516.3 | 584.85 | 653.4 | 730.05 | 806.7 | 976 | 1162 | 1363.2 | 1581.2 | 1823.1 | 2065 | 2339.3 | 2613.6 | 2920.2 | 3226.8 | 3904 | 3904 | 4276 | 4648 | 8260
200 | 19.4 | 34.5 | 53.9 | 77.62 | 105.6 | 138 | 174.6 | 215.6 | 260.9 | 310.5 | 364.4 | 442.6 | 497.5 | 551.9 | 625.2 | 698.5 | 780.45 | 862.4 | 1043.6 | 1242 | 1457.6 | 1690.4 | 1949.2 | 22.08 | 2501 | 2794 | 3121.8 | 3449.6 | 4174.4 | 4174.4 | 4571 | 4968 | 8832
225 | 20.58 | 36.59 | 57..17 | 82.32 | 112.1 | 146.4 | 185.2 | 228.7 | 276.7 | 329.3 | 386.5 | 448.2 | 516.8 | 585.4 | 663.15 | 740.9 | 827.8 | 914.7 | 1106.8 | 1317 | 1546 | 1792.8 | 2067.4 | 2342 | 2652.8 | 2963.6 | 3311.2 | 3658.8 | 4427.2 | 4427.2 | 4847.6 | 5268 | 9368
250 | 21.69 | 38.57 | 60.26 | 86.78 | 118.1 | 154.3 | 195.2 | 241 | 291.7 | 347.1 | 407.4 | 472.5 | 544.8 | 617.1 | 699.05 | 781 | 872.6 | 964.2 | 1166.8 | 1388 | 1629.6 | 1890 | 2179 | 2468 | 2768 | 3124 | 3490.4 | 3856.8 | 4667.2 | 4667.2 | 5109.6 | 5552 | 9872
300 | 23.77 | 42.25 | 66.01 | 95.06 | 129.4 | 169 | 213.9 | 264.1 | 319.5 | 380.2 | 446.3 | 517.6 | 596.8 | 676 | 765.75 | 855.5 | 955.75 | 1056 | 1278 | 1521 | 1785.2 | 2070.4 | 2387.2 | 2704 | 3063 | 3422 | 3823 | 4224 | 5112 | 5112 | 5598 | 6084 | 10816
350 | 25.67 | 45.63 | 71.3 | 102.7 | 139.8 | 182.5 | 231 | 285.2 | 345.1 | 410.7 | 482 | 559 | 644.55 | 730.1 | 827.1 | 924.1 | 1032.55 | 1141 | 1380.4 | 1643 | 1928 | 2236 | 2578.5 | 2921 | 3308.7 | 3696.4 | 4130.2 | 4564 | 5521.6 | 5521.6 | 5568 | 6572 | 11684
400 | 27.44 | 48.78 | 76.23 | 109.8 | 149.4 | 195.1 | 247 | 304.9 | 368.9 | 439.1 | 515.3 | 597.6 | 689.1 | 780.6 | 884.25 | 987.9 | 1103.95 | 1220 | 1475.6 | 1756 | 2061.2 | 2390.4 | 2756.2 | 3122 | 3536.8 | 3951.6 | 4415.8 | 4880 | 5902.4 | 5902.4 | 6463.2 | 7024 | 12488
450 | 29.11 | 51.74 | 80.85 | 116.4 | 158.5 | 207 | 262 | 323.4 | 391.3 | 465.7 | 546.5 | 633.9 | 730.9 | 827.9 | 937.95 | 1048 | 1171 | 1294 | 1565.2 | 1863 | 2186 | 2535.6 | 2923.8 | 3312 | 3752 | 4192 | 4684 | 5176 | 6260.8 | 6260.8 | 6856.4 | 7452 | 13248
500 | 30.68 | 54.54 | 85.22 | 122.7 | 167 | 218.2 | 276.1 | 340.9 | 412.5 | 490.9 | 576.1 | 668.2 | 770.45 | 872.7 | 988.85 | 1105 | 1234.5 | 1364 | 1650 | 1964 | 2304.4 | 2672.8 | 3081.9 | 3491 | 3955.5 | 4420 | 4938 | 5456 | 6600 | 6600 | 7228 | 7856 | 13964
550 | 32.18 | 57.21 | 89.38 | 128.7 | 175.2 | 228.8 | 289.6 | 357.5 | 432.6 | 514.8 | 604.2 | 700.8 | 808.05 | 915.3 | 1036.65 | 1158 | 1294 | 1430 | 1730.4 | 2059 | 2416.8 | 2803.2 | 3232.1 | 3661 | 4146.5 | 4632 | 5176 | 5720 | 6921.6 | 6921.6 | 7578.8 | 8236 | 14644
600 | 33.61 | 59.75 | 93.36 | 134.4 | 183 | 239 | 302.5 | 373.4 | 451.9 | 537.7 | 631.1 | 731.9 | 843.95 | 956 | 1083 | 1210 | 1352 | 1494 | 1807.6 | 2151 | 2524.4 | 2927.6 | 3375.8 | 3824 | 4332 | 4840 | 5408 | 5976 | 7230.4 | 7230.4 | 7917.2 | 8604 | 15296
700 | 36.3 | 64.54 | 100.8 | 145.2 | 197.6 | 258.1 | 326.7 | 403.4 | 488.1 | 580.8 | 681.7 | 790.6 | 911.8 | 1033 | 1170 | 1307 | 1460 | 1613 | 1952.4 | 2323 | 2726.8 | 3162.4 | 3646.2 | 4130 | 4679 | 5228 | 5840 | 6452 | 7809.6 | 7809.6 | 8550.8 | 9292 | 16520
800 | 38.81 | 68.99 | 107.8 | 155.2 | 211.3 | 276 | 349.3 | 431.2 | 521.8 | 620.9 | 728.7 | 845.2 | 974.6 | 1104 | 1250.5 | 1397 | 1561 | 1725 | 2087.2 | 2484 | 2914.8 | 3380.8 | 3898.4 | 4416 | 5002 | 5588 | 6244 | 6900 | 8348.8 | 8348.8 | 9142.4 | 9936 | 17664
900 | 41.16 | 73.18 | 114.3 | 164.6 | 224.1 | 292.7 | 370.5 | 457.4 | 553.4 | 658.6 | 772.9 | 896.4 | 1033.7 | 1171 | 1326.5 | 1482 | 1655.5 | 1829 | 2213.6 | 2634 | 3091.6 | 3585.6 | 4134.3 | 4683 | 5305.5 | 5928 | 6622 | 7316 | 8854.4 | 8854.4 | 9695.2 | 10536 | 18732
1000 | 43.39 | 77.14 | 120.5 | 173.6 | 236.2 | 308.5 | 390.5 | 482.1 | 583.3 | 694.2 | 814.7 | 944.9 | 1089.45 | 1234 | 1398 | 1562 | 1745 | 1928 | 233.2 | 2777 | 3258.8 | 3779.6 | 4358.3 | 4937 | 5592.5 | 6248 | 6980 | 7712 | 9332.8 | 9332.8 | 10220.4 | 11108 | 19748
1100 | 45.51 | 80.9 | 126.4 | 182 | 247.8 | 323.6 | 409.6 | 505.6 | 611.8 | 728.1 | 854.5 | 991 | 1142.5 | 1294 | 1466 | 1638 | 1830.5 | 2023 | 2447.2 | 2912 | 3418 | 3964 | 4571 | 5178 | 5865 | 6552 | 7322 | 8092 | 9788.8 | 9788.8 | 19718.4 | 11648 | 20712
1200 | 47.53 | 84.5 | 132 | 190.1 | 258.8 | 338 | 427.8 | 528.1 | 639 | 760.5 | 892.5 | 1035 | 1193.5 | 1352 | 1531.5 | 1711 | 1911.5 | 2112 | 2556 | 3042 | 3570 | 4140 | 4774 | 5408 | 6126 | 6844 | 7646 | 8448 | 10224 | 10224 | 11196 | 12168 | 21632
1400 | 51.34 | 91.27 | 142.6 | 205.4 | 279.5 | 365.1 | 462 | 570.4 | 690.2 | 821.4 | 964 | 1118 | 1289 | 1460 | 1654 | 1848 | 2065 | 2282 | 2760.8 | 3286 | 3856 | 4472 | 5156.5 | 5841 | 6616.5 | 7392 | 8260 | 9128 | 11043.2 | 11043.2 | 12093.6 | 13144 | 23364
1600 | 54.88 | 97.57 | 152.5 | 219.5 | 298.8 | 390.3 | 493.9 | 609.8 | 737.9 | 878.1 | 1031 | 1195 | 1378 | 1561 | 1768.5 | 1976 | 2207.5 | 2439 | 2951.6 | 3513 | 4124 | 4780 | 5512 | 6244 | 7074 | 7904 | 8830 | 9756 | 11806.4 | 11806.4 | 12929.2 | 14052 | 24976
1800 | 58.21 | 103.5 | 161.7 | 232.8 | 316.9 | 414 | 523.9 | 646.8 | 782.6 | 931.4 | 1093 | 1268 | 1462 | 1656 | 1876 | 2096 | 2341.5 | 2587 | 3130.4 | 3726 | 4372 | 5072 | 5847.5 | 6623 | 7503.5 | 8384 | 9366 | 10348 | 12521.6 | 12521.6 | 13712.8 | 14904 | 26492
2000 | 61.36 | 109.1 | 170.4 | 245.4 | 334.1 | 436.3 | 552.3 | 681.8 | 825 | 981.8 | 1152 | 1336 | 1540.5 | 1745 | 1977 | 2209 | 2468 | 2727 | 3300 | 3927 | 4608 | 5344 | 6163 | 6982 | 7909 | 8836 | 9872 | 10908 | 13200 | 13200 | 14454 | 15708 | 27928
2200 | 64.36 | 114.4 | 178.8 | 257.4 | 350.4 | 457.6 | 579.2 | 715.1 | 865.2 | 1030 | 1208 | 1402 | 1616.5 | 1831 | 2074 | 2317 | 2588.5 | 2860 | 3460.8 | 4119 | 4832 | 5608 | 6465 | 7322 | 8295 | 9268 | 10354 | 11440 | 13843.2 | 13843.2 | 15159.6 | 16476 | 29288
2500 | 68.6 | 122 | 190.6 | 274.4 | 373.5 | 487.8 | 617.4 | 762.3 | 922.3 | 1098 | 1288 | 1494 | 1722.5 | 1951 | 2210.5 | 2470 | 2759.5 | 3049 | 3689.2 | 4391 | 5152 | 5976 | 7303 | 7806 | 8843 | 9880 | 11038 | 12196 | 14756.8 | 14756.8 | 16160.4 | 17564 | 31224
3000 | 75.15 | 133.6 | 208.8 | 300.6 | 409.2 | 534.4 | 676.4 | 835 | 1010 | 1202 | 1411 | 1637 | 1887.5 | 2138 | 2421 | 2705 | 3022.5 | 3340 | 4040 | 4810 | 5644 | 6548 | 7549.5 | 8551 | 9685.5 | 10820 | 1290 | 13360 | 16160 | 16160 | 17700 | 19240 | 34204
3500 | 81.17 | 144.3 | 225.5 | 324.7 | 441.9 | 577.2 | 730.6 | 901.9 | 1091 | 1299 | 1524 | 1768 | 2038.5 | 2309 | 2615.5 | 2922 | 3265 | 3608 | 4364 | 5195 | 6096 | 7072 | 8154 | 9236 | 10462 | 11688 | 13060 | 14432 | 17456 | 17456 | 19118 | 20780 | 36944
4000 | 86.78 | 154.3 | 241 | 347.1 | 472.5 | 617.1 | 781 | 964.2 | 1167 | 1388 | 1629 | 1890 | 2179 | 2468 | 2796 | 3124 | 3490.5 | 3857 | 4668 | 5554 | 6516 | 7560 | 8716.5 | 9873 | 11183.5 | 12494 | 13961 | 15428 | 18672 | 18672 | 20444 | 22216 | 39492
4500 | 92.04 | 163.6 | 255.7 | 368.2 | 501.1 | 654.5 | 828.4 | 1023 | 1237 | 1473 | 1728 | 2004 | 2311 | 2618 | 2966 | 3314 | 3702.5 | 4091 | 4948 | 5891 | 6912 | 8016 | 9243 | 10470 | 11863 | 13256 | 14810 | 16364 | 19792 | 19792 | 21678 | 23564 | 41880
5000 | 97.02 | 172.5 | 269.5 | 388.1 | 528.2 | 689.9 | 873.2 | 1078 | 1304 | 1552 | 1822 | 2113 | 2436.5 | 2760 | 3126.5 | 3493 | 3902.5 | 4312 | 5216 | 6209 | 7288 | 8452 | 9746 | 11040 | 12506 | 13972 | 15610 | 17248 | 20864 | 20864 | 22850 | 24836 | 44160
6000 | 106.3 | 188.9 | 295.2 | 425.1 | 578.6 | 755.8 | 956.5 | 1181 | 1429 | 1700 | 1996 | 2315 | 2673.5 | 3032 | 3429 | 3826 | 4275 | 4724 | 5716 | 6802 | 7984 | 9260 | 10675 | 12090 | 13697 | 15304 | 17100 | 18896 | 22864 | 22864 | 25036 | 27208 | 48360
7000 | 114.8 | 204.1 | 318.9 | 459.2 | 625 | 816.3 | 1033 | 1276 | 1543 | 1837 | 2156 | 2500 | 2882.5 | 3265 | 3699 | 4133 | 4617.5 | 5102 | 6172 | 7347 | 8624 | 10000 | 11530 | 13060 | 14796 | 16532 | 18470 | 20408 | 24688 | 24688 | 27038 | 29388 | 52240
8000 | 122.7 | 218.2 | 340.9 | 490.9 | 668.2 | 872.7 | 1105 | 1364 | 1650 | 1964 | 2304 | 2673 | 3082 | 3491 | 3954.5 | 4418 | 4936 | 5454 | 6600 | 7854 | 9216 | 10692 | 12026 | 13360 | 15516 | 17672 | 19744 | 21816 | 26400 | 26400 | 28908 | 31416 | 53440
9000 | 130.2 | 231.4 | 361.6 | 520.7 | 708.7 | 925.6 | 1171 | 1446 | 1750 | 2083 | 2444 | 2835 | 3269 | 3703 | 4194.5 | 4686 | 5235.5 | 5785 | 7000 | 8331 | 9776 | 11340 | 13075 | 14810 | 16777 | 18744 | 20942 | 23140 | 2800 | 2800 | 30662 | 33324 | 59240
10000 | 137.2 | 243.9 | 381.1 | 548.8 | 747 | 975.7 | 1235 | 1525 | 1845 | 2195 | 2576 | 2988 | 3445.5 | 3903 | 4421 | 4939 | 5518.5 | 6098 | 7380 | 8781 | 10304 | 11952 | 13781 | 15610 | 17683 | 9756 | 22074 | 24392 | 29440 | 29440 | 32322 | 35124 | 62440