| 1 | TESU ID | | Drift Loss of Circulating Water (1)
(%) | Peak Recirculation Flow Rate (1)
(gpm) | Average Recirculation Flow Rate (1)
(gpm) | Drift Loss | | TAC Concentration (2)
(ppm) | | | | | Emissions Estimate (5) | | | | | | | | | | | | | | | | | | | |
| 2 | | | | | | | | | | | | | Glutaraldehyde | | | | Methanol | | | | Aluminum | | | | Phosphoric Acid | | | | Sulfuric Acid | | | |
| 3 | | | | | | | | | | | | | 111-30-8 | | | | 67-56-1 | | | | 7429-90-5 | | | | 7664-38-2 | | | | 7664-93-9 | | | |
| 4 | | | | | | Daily (a)
(lb/day) | Annual (b)
(lb/yr) | Glutaraldehyde | Methanol | Aluminum (e) | Phosphoric Acid | Sulfuric Acid | Daily (c)
(lb/day) | | Annual (d)
(lb/yr) | | Daily (c)
(lb/day) | | Annual (d)
(lb/yr) | | Daily (d)
(lb/day) | | Annual (e)
(lb/yr) | | Daily (c)
(lb/day) | | Annual (d)
(lb/yr) | | Daily (c)
(lb/day) | | Annual (d)
(lb/yr) | |
| 5 | RAC4-CT114-1 | | =_XLFN.XLOOKUP($A5,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A5,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A5,F:F,L:L) | =$D5*$H$93*$C5/100*60*$H$94 | =$E5*$H$93*$C5/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$13/20*26.98/610.91 | ='[37]Dosing overview'!$I$12/20 | ='[37]Dosing overview'!$J$12/20 | =IFERROR($F5*$H5/1000000,"--") | | =IFERROR($G5*$H5/1000000,"--") | | =IFERROR($F5*$I5/1000000,"--") | | =IFERROR($G5*$I5/1000000,"--") | | =IFERROR($F5*$J5/1000000,"--") | | =IFERROR($G5*$J5/1000000,"--") | | =$F5*$K5/1000000 | | =$G5*$K5/1000000 | | =$F5*$L5/1000000 | | =$G5*$L5/1000000 | |
| 6 | RAC4-CT114-2 | | =_XLFN.XLOOKUP($A6,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A6,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A6,F:F,L:L) | =$D6*$H$93*$C6/100*60*$H$94 | =$E6*$H$93*$C6/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$13/20*26.98/610.91 | ='[37]Dosing overview'!$I$12/20 | ='[37]Dosing overview'!$J$12/20 | =IFERROR($F6*$H6/1000000,"--") | | =IFERROR($G6*$H6/1000000,"--") | | =IFERROR($F6*$I6/1000000,"--") | | =IFERROR($G6*$I6/1000000,"--") | | =IFERROR($F6*$J6/1000000,"--") | | =IFERROR($G6*$J6/1000000,"--") | | =$F6*$K6/1000000 | | =$G6*$K6/1000000 | | =$F6*$L6/1000000 | | =$G6*$L6/1000000 | |
| 7 | RAC4-CT114-3 | | =_XLFN.XLOOKUP($A7,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A7,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A7,F:F,L:L) | =$D7*$H$93*$C7/100*60*$H$94 | =$E7*$H$93*$C7/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$13/20*26.98/610.91 | ='[37]Dosing overview'!$I$12/20 | ='[37]Dosing overview'!$J$12/20 | =IFERROR($F7*$H7/1000000,"--") | | =IFERROR($G7*$H7/1000000,"--") | | =IFERROR($F7*$I7/1000000,"--") | | =IFERROR($G7*$I7/1000000,"--") | | =IFERROR($F7*$J7/1000000,"--") | | =IFERROR($G7*$J7/1000000,"--") | | =$F7*$K7/1000000 | | =$G7*$K7/1000000 | | =$F7*$L7/1000000 | | =$G7*$L7/1000000 | |
| 8 | RAC4-CT114-4 | | =_XLFN.XLOOKUP($A8,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A8,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A8,F:F,L:L) | =$D8*$H$93*$C8/100*60*$H$94 | =$E8*$H$93*$C8/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$13/20*26.98/610.91 | ='[37]Dosing overview'!$I$12/20 | ='[37]Dosing overview'!$J$12/20 | =IFERROR($F8*$H8/1000000,"--") | | =IFERROR($G8*$H8/1000000,"--") | | =IFERROR($F8*$I8/1000000,"--") | | =IFERROR($G8*$I8/1000000,"--") | | =IFERROR($F8*$J8/1000000,"--") | | =IFERROR($G8*$J8/1000000,"--") | | =$F8*$K8/1000000 | | =$G8*$K8/1000000 | | =$F8*$L8/1000000 | | =$G8*$L8/1000000 | |
| 9 | RAC4-CT114-5 | | =_XLFN.XLOOKUP($A9,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A9,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A9,F:F,L:L) | =$D9*$H$93*$C9/100*60*$H$94 | =$E9*$H$93*$C9/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$13/20*26.98/610.91 | ='[37]Dosing overview'!$I$12/20 | ='[37]Dosing overview'!$J$12/20 | =IFERROR($F9*$H9/1000000,"--") | | =IFERROR($G9*$H9/1000000,"--") | | =IFERROR($F9*$I9/1000000,"--") | | =IFERROR($G9*$I9/1000000,"--") | | =IFERROR($F9*$J9/1000000,"--") | | =IFERROR($G9*$J9/1000000,"--") | | =$F9*$K9/1000000 | | =$G9*$K9/1000000 | | =$F9*$L9/1000000 | | =$G9*$L9/1000000 | |
| 10 | RAC4-CT114-6 | | =_XLFN.XLOOKUP($A10,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A10,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A10,F:F,L:L) | =$D10*$H$93*$C10/100*60*$H$94 | =$E10*$H$93*$C10/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$13/20*26.98/610.91 | ='[37]Dosing overview'!$I$12/20 | ='[37]Dosing overview'!$J$12/20 | =IFERROR($F10*$H10/1000000,"--") | | =IFERROR($G10*$H10/1000000,"--") | | =IFERROR($F10*$I10/1000000,"--") | | =IFERROR($G10*$I10/1000000,"--") | | =IFERROR($F10*$J10/1000000,"--") | | =IFERROR($G10*$J10/1000000,"--") | | =$F10*$K10/1000000 | | =$G10*$K10/1000000 | | =$F10*$L10/1000000 | | =$G10*$L10/1000000 | |
| 11 | RAC4-CT114-7 | | =_XLFN.XLOOKUP($A11,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A11,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A11,F:F,L:L) | =$D11*$H$93*$C11/100*60*$H$94 | =$E11*$H$93*$C11/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$13/20*26.98/610.91 | ='[37]Dosing overview'!$I$12/20 | ='[37]Dosing overview'!$J$12/20 | =IFERROR($F11*$H11/1000000,"--") | | =IFERROR($G11*$H11/1000000,"--") | | =IFERROR($F11*$I11/1000000,"--") | | =IFERROR($G11*$I11/1000000,"--") | | =IFERROR($F11*$J11/1000000,"--") | | =IFERROR($G11*$J11/1000000,"--") | | =$F11*$K11/1000000 | | =$G11*$K11/1000000 | | =$F11*$L11/1000000 | | =$G11*$L11/1000000 | |
| 12 | RAC4-CT114-8 | | =_XLFN.XLOOKUP($A12,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A12,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A12,F:F,L:L) | =$D12*$H$93*$C12/100*60*$H$94 | =$E12*$H$93*$C12/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$13/20*26.98/610.91 | ='[37]Dosing overview'!$I$12/20 | ='[37]Dosing overview'!$J$12/20 | =IFERROR($F12*$H12/1000000,"--") | | =IFERROR($G12*$H12/1000000,"--") | | =IFERROR($F12*$I12/1000000,"--") | | =IFERROR($G12*$I12/1000000,"--") | | =IFERROR($F12*$J12/1000000,"--") | | =IFERROR($G12*$J12/1000000,"--") | | =$F12*$K12/1000000 | | =$G12*$K12/1000000 | | =$F12*$L12/1000000 | | =$G12*$L12/1000000 | |
| 13 | RAC4-CT114-9 | | =_XLFN.XLOOKUP($A13,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A13,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A13,F:F,L:L) | =$D13*$H$93*$C13/100*60*$H$94 | =$E13*$H$93*$C13/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$13/20*26.98/610.91 | ='[37]Dosing overview'!$I$12/20 | ='[37]Dosing overview'!$J$12/20 | =IFERROR($F13*$H13/1000000,"--") | | =IFERROR($G13*$H13/1000000,"--") | | =IFERROR($F13*$I13/1000000,"--") | | =IFERROR($G13*$I13/1000000,"--") | | =IFERROR($F13*$J13/1000000,"--") | | =IFERROR($G13*$J13/1000000,"--") | | =$F13*$K13/1000000 | | =$G13*$K13/1000000 | | =$F13*$L13/1000000 | | =$G13*$L13/1000000 | |
| 14 | RAC4-CT114-10 | | =_XLFN.XLOOKUP($A14,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A14,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A14,F:F,L:L) | =$D14*$H$93*$C14/100*60*$H$94 | =$E14*$H$93*$C14/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$13/20*26.98/610.91 | ='[37]Dosing overview'!$I$12/20 | ='[37]Dosing overview'!$J$12/20 | =IFERROR($F14*$H14/1000000,"--") | | =IFERROR($G14*$H14/1000000,"--") | | =IFERROR($F14*$I14/1000000,"--") | | =IFERROR($G14*$I14/1000000,"--") | | =IFERROR($F14*$J14/1000000,"--") | | =IFERROR($G14*$J14/1000000,"--") | | =$F14*$K14/1000000 | | =$G14*$K14/1000000 | | =$F14*$L14/1000000 | | =$G14*$L14/1000000 | |
| 15 | RAC4-CT114-11 | | =_XLFN.XLOOKUP($A15,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A15,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A15,F:F,L:L) | =$D15*$H$93*$C15/100*60*$H$94 | =$E15*$H$93*$C15/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$13/20*26.98/610.91 | ='[37]Dosing overview'!$I$12/20 | ='[37]Dosing overview'!$J$12/20 | =IFERROR($F15*$H15/1000000,"--") | | =IFERROR($G15*$H15/1000000,"--") | | =IFERROR($F15*$I15/1000000,"--") | | =IFERROR($G15*$I15/1000000,"--") | | =IFERROR($F15*$J15/1000000,"--") | | =IFERROR($G15*$J15/1000000,"--") | | =$F15*$K15/1000000 | | =$G15*$K15/1000000 | | =$F15*$L15/1000000 | | =$G15*$L15/1000000 | |
| 16 | RAC4-CT114-12 | | =_XLFN.XLOOKUP($A16,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A16,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A16,F:F,L:L) | =$D16*$H$93*$C16/100*60*$H$94 | =$E16*$H$93*$C16/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$13/20*26.98/610.91 | ='[37]Dosing overview'!$I$12/20 | ='[37]Dosing overview'!$J$12/20 | =IFERROR($F16*$H16/1000000,"--") | | =IFERROR($G16*$H16/1000000,"--") | | =IFERROR($F16*$I16/1000000,"--") | | =IFERROR($G16*$I16/1000000,"--") | | =IFERROR($F16*$J16/1000000,"--") | | =IFERROR($G16*$J16/1000000,"--") | | =$F16*$K16/1000000 | | =$G16*$K16/1000000 | | =$F16*$L16/1000000 | | =$G16*$L16/1000000 | |
| 17 | RAC4-CT114-13 | | =_XLFN.XLOOKUP($A17,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A17,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A17,F:F,L:L) | =$D17*$H$93*$C17/100*60*$H$94 | =$E17*$H$93*$C17/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$13/20*26.98/610.91 | ='[37]Dosing overview'!$I$12/20 | ='[37]Dosing overview'!$J$12/20 | =IFERROR($F17*$H17/1000000,"--") | | =IFERROR($G17*$H17/1000000,"--") | | =IFERROR($F17*$I17/1000000,"--") | | =IFERROR($G17*$I17/1000000,"--") | | =IFERROR($F17*$J17/1000000,"--") | | =IFERROR($G17*$J17/1000000,"--") | | =$F17*$K17/1000000 | | =$G17*$K17/1000000 | | =$F17*$L17/1000000 | | =$G17*$L17/1000000 | |
| 18 | RAC4-CT114-14 | | =_XLFN.XLOOKUP($A18,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A18,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A18,F:F,L:L) | =$D18*$H$93*$C18/100*60*$H$94 | =$E18*$H$93*$C18/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$13/20*26.98/610.91 | ='[37]Dosing overview'!$I$12/20 | ='[37]Dosing overview'!$J$12/20 | =IFERROR($F18*$H18/1000000,"--") | | =IFERROR($G18*$H18/1000000,"--") | | =IFERROR($F18*$I18/1000000,"--") | | =IFERROR($G18*$I18/1000000,"--") | | =IFERROR($F18*$J18/1000000,"--") | | =IFERROR($G18*$J18/1000000,"--") | | =$F18*$K18/1000000 | | =$G18*$K18/1000000 | | =$F18*$L18/1000000 | | =$G18*$L18/1000000 | |
| 19 | RAC4-CT114-15 | | =_XLFN.XLOOKUP($A19,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A19,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A19,F:F,L:L) | =$D19*$H$93*$C19/100*60*$H$94 | =$E19*$H$93*$C19/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$13/20*26.98/610.91 | ='[37]Dosing overview'!$I$12/20 | ='[37]Dosing overview'!$J$12/20 | =IFERROR($F19*$H19/1000000,"--") | | =IFERROR($G19*$H19/1000000,"--") | | =IFERROR($F19*$I19/1000000,"--") | | =IFERROR($G19*$I19/1000000,"--") | | =IFERROR($F19*$J19/1000000,"--") | | =IFERROR($G19*$J19/1000000,"--") | | =$F19*$K19/1000000 | | =$G19*$K19/1000000 | | =$F19*$L19/1000000 | | =$G19*$L19/1000000 | |
| 20 | RAC4-CT114-16 | | =_XLFN.XLOOKUP($A20,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A20,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A20,F:F,L:L) | =$D20*$H$93*$C20/100*60*$H$94 | =$E20*$H$93*$C20/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$13/20*26.98/610.91 | ='[37]Dosing overview'!$I$12/20 | ='[37]Dosing overview'!$J$12/20 | =IFERROR($F20*$H20/1000000,"--") | | =IFERROR($G20*$H20/1000000,"--") | | =IFERROR($F20*$I20/1000000,"--") | | =IFERROR($G20*$I20/1000000,"--") | | =IFERROR($F20*$J20/1000000,"--") | | =IFERROR($G20*$J20/1000000,"--") | | =$F20*$K20/1000000 | | =$G20*$K20/1000000 | | =$F20*$L20/1000000 | | =$G20*$L20/1000000 | |
| 21 | RAC4-CT114-17 | | =_XLFN.XLOOKUP($A21,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A21,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A21,F:F,L:L) | =$D21*$H$93*$C21/100*60*$H$94 | =$E21*$H$93*$C21/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$13/20*26.98/610.91 | ='[37]Dosing overview'!$I$12/20 | ='[37]Dosing overview'!$J$12/20 | =IFERROR($F21*$H21/1000000,"--") | | =IFERROR($G21*$H21/1000000,"--") | | =IFERROR($F21*$I21/1000000,"--") | | =IFERROR($G21*$I21/1000000,"--") | | =IFERROR($F21*$J21/1000000,"--") | | =IFERROR($G21*$J21/1000000,"--") | | =$F21*$K21/1000000 | | =$G21*$K21/1000000 | | =$F21*$L21/1000000 | | =$G21*$L21/1000000 | |
| 22 | RAC4-CT114-18 | | =_XLFN.XLOOKUP($A22,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A22,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A22,F:F,L:L) | =$D22*$H$93*$C22/100*60*$H$94 | =$E22*$H$93*$C22/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$13/20*26.98/610.91 | ='[37]Dosing overview'!$I$12/20 | ='[37]Dosing overview'!$J$12/20 | =IFERROR($F22*$H22/1000000,"--") | | =IFERROR($G22*$H22/1000000,"--") | | =IFERROR($F22*$I22/1000000,"--") | | =IFERROR($G22*$I22/1000000,"--") | | =IFERROR($F22*$J22/1000000,"--") | | =IFERROR($G22*$J22/1000000,"--") | | =$F22*$K22/1000000 | | =$G22*$K22/1000000 | | =$F22*$L22/1000000 | | =$G22*$L22/1000000 | |
| 23 | RAC4-CT114-19 | | =_XLFN.XLOOKUP($A23,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A23,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A23,F:F,L:L) | =$D23*$H$93*$C23/100*60*$H$94 | =$E23*$H$93*$C23/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$13/20*26.98/610.91 | ='[37]Dosing overview'!$I$12/20 | ='[37]Dosing overview'!$J$12/20 | =IFERROR($F23*$H23/1000000,"--") | | =IFERROR($G23*$H23/1000000,"--") | | =IFERROR($F23*$I23/1000000,"--") | | =IFERROR($G23*$I23/1000000,"--") | | =IFERROR($F23*$J23/1000000,"--") | | =IFERROR($G23*$J23/1000000,"--") | | =$F23*$K23/1000000 | | =$G23*$K23/1000000 | | =$F23*$L23/1000000 | | =$G23*$L23/1000000 | |
| 24 | RAC4-CT114-20 | | =_XLFN.XLOOKUP($A24,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A24,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A24,F:F,L:L) | =$D24*$H$93*$C24/100*60*$H$94 | =$E24*$H$93*$C24/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$13/20*26.98/610.91 | ='[37]Dosing overview'!$I$12/20 | ='[37]Dosing overview'!$J$12/20 | =IFERROR($F24*$H24/1000000,"--") | | =IFERROR($G24*$H24/1000000,"--") | | =IFERROR($F24*$I24/1000000,"--") | | =IFERROR($G24*$I24/1000000,"--") | | =IFERROR($F24*$J24/1000000,"--") | | =IFERROR($G24*$J24/1000000,"--") | | =$F24*$K24/1000000 | | =$G24*$K24/1000000 | | =$F24*$L24/1000000 | | =$G24*$L24/1000000 | |
| 25 | RAC5-CT115-1 | | =_XLFN.XLOOKUP($A25,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A25,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A25,F:F,L:L) | =$D25*$H$93*$C25/100*60*$H$94 | =$E25*$H$93*$C25/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$15/17*26.98/610.91 | ='[37]Dosing overview'!$I$14/17 | ='[37]Dosing overview'!$J$14/17 | =IFERROR($F25*$H25/1000000,"--") | | =IFERROR($G25*$H25/1000000,"--") | | =IFERROR($F25*$I25/1000000,"--") | | =IFERROR($G25*$I25/1000000,"--") | | =IFERROR($F25*$J25/1000000,"--") | | =IFERROR($G25*$J25/1000000,"--") | | =$F25*$K25/1000000 | | =$G25*$K25/1000000 | | =$F25*$L25/1000000 | | =$G25*$L25/1000000 | |
| 26 | RAC5-CT115-2 | | =_XLFN.XLOOKUP($A26,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A26,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A26,F:F,L:L) | =$D26*$H$93*$C26/100*60*$H$94 | =$E26*$H$93*$C26/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$15/17*26.98/610.91 | ='[37]Dosing overview'!$I$14/17 | ='[37]Dosing overview'!$J$14/17 | =IFERROR($F26*$H26/1000000,"--") | | =IFERROR($G26*$H26/1000000,"--") | | =IFERROR($F26*$I26/1000000,"--") | | =IFERROR($G26*$I26/1000000,"--") | | =IFERROR($F26*$J26/1000000,"--") | | =IFERROR($G26*$J26/1000000,"--") | | =$F26*$K26/1000000 | | =$G26*$K26/1000000 | | =$F26*$L26/1000000 | | =$G26*$L26/1000000 | |
| 27 | RAC5-CT115-3 | | =_XLFN.XLOOKUP($A27,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A27,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A27,F:F,L:L) | =$D27*$H$93*$C27/100*60*$H$94 | =$E27*$H$93*$C27/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$15/17*26.98/610.91 | ='[37]Dosing overview'!$I$14/17 | ='[37]Dosing overview'!$J$14/17 | =IFERROR($F27*$H27/1000000,"--") | | =IFERROR($G27*$H27/1000000,"--") | | =IFERROR($F27*$I27/1000000,"--") | | =IFERROR($G27*$I27/1000000,"--") | | =IFERROR($F27*$J27/1000000,"--") | | =IFERROR($G27*$J27/1000000,"--") | | =$F27*$K27/1000000 | | =$G27*$K27/1000000 | | =$F27*$L27/1000000 | | =$G27*$L27/1000000 | |
| 28 | RAC5-CT115-4 | | =_XLFN.XLOOKUP($A28,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A28,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A28,F:F,L:L) | =$D28*$H$93*$C28/100*60*$H$94 | =$E28*$H$93*$C28/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$15/17*26.98/610.91 | ='[37]Dosing overview'!$I$14/17 | ='[37]Dosing overview'!$J$14/17 | =IFERROR($F28*$H28/1000000,"--") | | =IFERROR($G28*$H28/1000000,"--") | | =IFERROR($F28*$I28/1000000,"--") | | =IFERROR($G28*$I28/1000000,"--") | | =IFERROR($F28*$J28/1000000,"--") | | =IFERROR($G28*$J28/1000000,"--") | | =$F28*$K28/1000000 | | =$G28*$K28/1000000 | | =$F28*$L28/1000000 | | =$G28*$L28/1000000 | |
| 29 | RAC5-CT115-5 | | =_XLFN.XLOOKUP($A29,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A29,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A29,F:F,L:L) | =$D29*$H$93*$C29/100*60*$H$94 | =$E29*$H$93*$C29/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$15/17*26.98/610.91 | ='[37]Dosing overview'!$I$14/17 | ='[37]Dosing overview'!$J$14/17 | =IFERROR($F29*$H29/1000000,"--") | | =IFERROR($G29*$H29/1000000,"--") | | =IFERROR($F29*$I29/1000000,"--") | | =IFERROR($G29*$I29/1000000,"--") | | =IFERROR($F29*$J29/1000000,"--") | | =IFERROR($G29*$J29/1000000,"--") | | =$F29*$K29/1000000 | | =$G29*$K29/1000000 | | =$F29*$L29/1000000 | | =$G29*$L29/1000000 | |
| 30 | RAC5-CT115-6 | | =_XLFN.XLOOKUP($A30,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A30,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A30,F:F,L:L) | =$D30*$H$93*$C30/100*60*$H$94 | =$E30*$H$93*$C30/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$15/17*26.98/610.91 | ='[37]Dosing overview'!$I$14/17 | ='[37]Dosing overview'!$J$14/17 | =IFERROR($F30*$H30/1000000,"--") | | =IFERROR($G30*$H30/1000000,"--") | | =IFERROR($F30*$I30/1000000,"--") | | =IFERROR($G30*$I30/1000000,"--") | | =IFERROR($F30*$J30/1000000,"--") | | =IFERROR($G30*$J30/1000000,"--") | | =$F30*$K30/1000000 | | =$G30*$K30/1000000 | | =$F30*$L30/1000000 | | =$G30*$L30/1000000 | |
| 31 | RAC5-CT115-7 | | =_XLFN.XLOOKUP($A31,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A31,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A31,F:F,L:L) | =$D31*$H$93*$C31/100*60*$H$94 | =$E31*$H$93*$C31/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$15/17*26.98/610.91 | ='[37]Dosing overview'!$I$14/17 | ='[37]Dosing overview'!$J$14/17 | =IFERROR($F31*$H31/1000000,"--") | | =IFERROR($G31*$H31/1000000,"--") | | =IFERROR($F31*$I31/1000000,"--") | | =IFERROR($G31*$I31/1000000,"--") | | =IFERROR($F31*$J31/1000000,"--") | | =IFERROR($G31*$J31/1000000,"--") | | =$F31*$K31/1000000 | | =$G31*$K31/1000000 | | =$F31*$L31/1000000 | | =$G31*$L31/1000000 | |
| 32 | RAC5-CT115-8 | | =_XLFN.XLOOKUP($A32,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A32,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A32,F:F,L:L) | =$D32*$H$93*$C32/100*60*$H$94 | =$E32*$H$93*$C32/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$15/17*26.98/610.91 | ='[37]Dosing overview'!$I$14/17 | ='[37]Dosing overview'!$J$14/17 | =IFERROR($F32*$H32/1000000,"--") | | =IFERROR($G32*$H32/1000000,"--") | | =IFERROR($F32*$I32/1000000,"--") | | =IFERROR($G32*$I32/1000000,"--") | | =IFERROR($F32*$J32/1000000,"--") | | =IFERROR($G32*$J32/1000000,"--") | | =$F32*$K32/1000000 | | =$G32*$K32/1000000 | | =$F32*$L32/1000000 | | =$G32*$L32/1000000 | |
| 33 | RAC5-CT115-9 | | =_XLFN.XLOOKUP($A33,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A33,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A33,F:F,L:L) | =$D33*$H$93*$C33/100*60*$H$94 | =$E33*$H$93*$C33/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$15/17*26.98/610.91 | ='[37]Dosing overview'!$I$14/17 | ='[37]Dosing overview'!$J$14/17 | =IFERROR($F33*$H33/1000000,"--") | | =IFERROR($G33*$H33/1000000,"--") | | =IFERROR($F33*$I33/1000000,"--") | | =IFERROR($G33*$I33/1000000,"--") | | =IFERROR($F33*$J33/1000000,"--") | | =IFERROR($G33*$J33/1000000,"--") | | =$F33*$K33/1000000 | | =$G33*$K33/1000000 | | =$F33*$L33/1000000 | | =$G33*$L33/1000000 | |
| 34 | RAC5-CT115-10 | | =_XLFN.XLOOKUP($A34,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A34,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A34,F:F,L:L) | =$D34*$H$93*$C34/100*60*$H$94 | =$E34*$H$93*$C34/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$15/17*26.98/610.91 | ='[37]Dosing overview'!$I$14/17 | ='[37]Dosing overview'!$J$14/17 | =IFERROR($F34*$H34/1000000,"--") | | =IFERROR($G34*$H34/1000000,"--") | | =IFERROR($F34*$I34/1000000,"--") | | =IFERROR($G34*$I34/1000000,"--") | | =IFERROR($F34*$J34/1000000,"--") | | =IFERROR($G34*$J34/1000000,"--") | | =$F34*$K34/1000000 | | =$G34*$K34/1000000 | | =$F34*$L34/1000000 | | =$G34*$L34/1000000 | |
| 35 | RAC5-CT115-11 | | =_XLFN.XLOOKUP($A35,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A35,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A35,F:F,L:L) | =$D35*$H$93*$C35/100*60*$H$94 | =$E35*$H$93*$C35/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$15/17*26.98/610.91 | ='[37]Dosing overview'!$I$14/17 | ='[37]Dosing overview'!$J$14/17 | =IFERROR($F35*$H35/1000000,"--") | | =IFERROR($G35*$H35/1000000,"--") | | =IFERROR($F35*$I35/1000000,"--") | | =IFERROR($G35*$I35/1000000,"--") | | =IFERROR($F35*$J35/1000000,"--") | | =IFERROR($G35*$J35/1000000,"--") | | =$F35*$K35/1000000 | | =$G35*$K35/1000000 | | =$F35*$L35/1000000 | | =$G35*$L35/1000000 | |
| 36 | RAC5-CT115-12 | | =_XLFN.XLOOKUP($A36,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A36,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A36,F:F,L:L) | =$D36*$H$93*$C36/100*60*$H$94 | =$E36*$H$93*$C36/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$15/17*26.98/610.91 | ='[37]Dosing overview'!$I$14/17 | ='[37]Dosing overview'!$J$14/17 | =IFERROR($F36*$H36/1000000,"--") | | =IFERROR($G36*$H36/1000000,"--") | | =IFERROR($F36*$I36/1000000,"--") | | =IFERROR($G36*$I36/1000000,"--") | | =IFERROR($F36*$J36/1000000,"--") | | =IFERROR($G36*$J36/1000000,"--") | | =$F36*$K36/1000000 | | =$G36*$K36/1000000 | | =$F36*$L36/1000000 | | =$G36*$L36/1000000 | |
| 37 | RAC5-CT115-13 | | =_XLFN.XLOOKUP($A37,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A37,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A37,F:F,L:L) | =$D37*$H$93*$C37/100*60*$H$94 | =$E37*$H$93*$C37/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$15/17*26.98/610.91 | ='[37]Dosing overview'!$I$14/17 | ='[37]Dosing overview'!$J$14/17 | =IFERROR($F37*$H37/1000000,"--") | | =IFERROR($G37*$H37/1000000,"--") | | =IFERROR($F37*$I37/1000000,"--") | | =IFERROR($G37*$I37/1000000,"--") | | =IFERROR($F37*$J37/1000000,"--") | | =IFERROR($G37*$J37/1000000,"--") | | =$F37*$K37/1000000 | | =$G37*$K37/1000000 | | =$F37*$L37/1000000 | | =$G37*$L37/1000000 | |
| 38 | RAC5-CT115-14 | | =_XLFN.XLOOKUP($A38,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A38,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A38,F:F,L:L) | =$D38*$H$93*$C38/100*60*$H$94 | =$E38*$H$93*$C38/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$15/17*26.98/610.91 | ='[37]Dosing overview'!$I$14/17 | ='[37]Dosing overview'!$J$14/17 | =IFERROR($F38*$H38/1000000,"--") | | =IFERROR($G38*$H38/1000000,"--") | | =IFERROR($F38*$I38/1000000,"--") | | =IFERROR($G38*$I38/1000000,"--") | | =IFERROR($F38*$J38/1000000,"--") | | =IFERROR($G38*$J38/1000000,"--") | | =$F38*$K38/1000000 | | =$G38*$K38/1000000 | | =$F38*$L38/1000000 | | =$G38*$L38/1000000 | |
| 39 | RAC5-CT115-15 | | =_XLFN.XLOOKUP($A39,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A39,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A39,F:F,L:L) | =$D39*$H$93*$C39/100*60*$H$94 | =$E39*$H$93*$C39/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$15/17*26.98/610.91 | ='[37]Dosing overview'!$I$14/17 | ='[37]Dosing overview'!$J$14/17 | =IFERROR($F39*$H39/1000000,"--") | | =IFERROR($G39*$H39/1000000,"--") | | =IFERROR($F39*$I39/1000000,"--") | | =IFERROR($G39*$I39/1000000,"--") | | =IFERROR($F39*$J39/1000000,"--") | | =IFERROR($G39*$J39/1000000,"--") | | =$F39*$K39/1000000 | | =$G39*$K39/1000000 | | =$F39*$L39/1000000 | | =$G39*$L39/1000000 | |
| 40 | RAC5-CT115-16 | | =_XLFN.XLOOKUP($A40,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A40,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A40,F:F,L:L) | =$D40*$H$93*$C40/100*60*$H$94 | =$E40*$H$93*$C40/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$15/17*26.98/610.91 | ='[37]Dosing overview'!$I$14/17 | ='[37]Dosing overview'!$J$14/17 | =IFERROR($F40*$H40/1000000,"--") | | =IFERROR($G40*$H40/1000000,"--") | | =IFERROR($F40*$I40/1000000,"--") | | =IFERROR($G40*$I40/1000000,"--") | | =IFERROR($F40*$J40/1000000,"--") | | =IFERROR($G40*$J40/1000000,"--") | | =$F40*$K40/1000000 | | =$G40*$K40/1000000 | | =$F40*$L40/1000000 | | =$G40*$L40/1000000 | |
| 41 | RAC5-CT115-17 | | =_XLFN.XLOOKUP($A41,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A41,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A41,F:F,L:L) | =$D41*$H$93*$C41/100*60*$H$94 | =$E41*$H$93*$C41/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$15/17*26.98/610.91 | ='[37]Dosing overview'!$I$14/17 | ='[37]Dosing overview'!$J$14/17 | =IFERROR($F41*$H41/1000000,"--") | | =IFERROR($G41*$H41/1000000,"--") | | =IFERROR($F41*$I41/1000000,"--") | | =IFERROR($G41*$I41/1000000,"--") | | =IFERROR($F41*$J41/1000000,"--") | | =IFERROR($G41*$J41/1000000,"--") | | =$F41*$K41/1000000 | | =$G41*$K41/1000000 | | =$F41*$L41/1000000 | | =$G41*$L41/1000000 | |
| 42 | RA5-CT114-1 | (6) | =_XLFN.XLOOKUP($A42,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A42,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A42,F:F,L:L) | =$D42*$H$93*$C42/100*60*$H$94 | =$E42*$H$93*$C42/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$15*26.98/610.91 | ='[37]Dosing overview'!$I$14 | ='[37]Dosing overview'!$J$14 | =IFERROR($F42*$H42/1000000,"--") | | =IFERROR($G42*$H42/1000000,"--") | | =IFERROR($F42*$I42/1000000,"--") | | =IFERROR($G42*$I42/1000000,"--") | | =IFERROR($F42*$J42/1000000,"--") | | =IFERROR($G42*$J42/1000000,"--") | | =IFERROR($F42*$K42/1000000,"--") | | =IFERROR($G42*$K42/1000000,"--") | | =IFERROR($F42*$L42/1000000,"--") | | =IFERROR($G42*$L42/1000000,"--") | |
| 43 | RA6-CT114-1 | (6) | =_XLFN.XLOOKUP($A43,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A43,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A43,F:F,L:L) | =$D43*$H$93*$C43/100*60*$H$94 | =$E43*$H$93*$C43/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$15*26.98/610.91 | ='[37]Dosing overview'!$I$14 | ='[37]Dosing overview'!$J$14 | =IFERROR($F43*$H43/1000000,"--") | | =IFERROR($G43*$H43/1000000,"--") | | =IFERROR($F43*$I43/1000000,"--") | | =IFERROR($G43*$I43/1000000,"--") | | =IFERROR($F43*$J43/1000000,"--") | | =IFERROR($G43*$J43/1000000,"--") | | =IFERROR($F43*$K43/1000000,"--") | | =IFERROR($G43*$K43/1000000,"--") | | =IFERROR($F43*$L43/1000000,"--") | | =IFERROR($G43*$L43/1000000,"--") | |
| 44 | CT-114-1-210 | | =_XLFN.XLOOKUP($A44,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A44,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A44,F:F,L:L) | =$D44*$H$93*$C44/100*60*$H$94 | =$E44*$H$93*$C44/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$11/11*26.98/610.91 | ='[37]Dosing overview'!$I$10/11 | ='[37]Dosing overview'!$J$10/11 | =IFERROR($F44*$H44/1000000,"--") | | =IFERROR($G44*$H44/1000000,"--") | | =IFERROR($F44*$I44/1000000,"--") | | =IFERROR($G44*$I44/1000000,"--") | | =IFERROR($F44*$J44/1000000,"--") | | =IFERROR($G44*$J44/1000000,"--") | | =$F44*$K44/1000000 | | =$G44*$K44/1000000 | | =$F44*$L44/1000000 | | =$G44*$L44/1000000 | |
| 45 | CT-114-2-210 | | =_XLFN.XLOOKUP($A45,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A45,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A45,F:F,L:L) | =$D45*$H$93*$C45/100*60*$H$94 | =$E45*$H$93*$C45/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$11/11*26.98/610.91 | ='[37]Dosing overview'!$I$10/11 | ='[37]Dosing overview'!$J$10/11 | =IFERROR($F45*$H45/1000000,"--") | | =IFERROR($G45*$H45/1000000,"--") | | =IFERROR($F45*$I45/1000000,"--") | | =IFERROR($G45*$I45/1000000,"--") | | =IFERROR($F45*$J45/1000000,"--") | | =IFERROR($G45*$J45/1000000,"--") | | =$F45*$K45/1000000 | | =$G45*$K45/1000000 | | =$F45*$L45/1000000 | | =$G45*$L45/1000000 | |
| 46 | CT-114-3-210 | | =_XLFN.XLOOKUP($A46,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A46,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A46,F:F,L:L) | =$D46*$H$93*$C46/100*60*$H$94 | =$E46*$H$93*$C46/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$11/11*26.98/610.91 | ='[37]Dosing overview'!$I$10/11 | ='[37]Dosing overview'!$J$10/11 | =IFERROR($F46*$H46/1000000,"--") | | =IFERROR($G46*$H46/1000000,"--") | | =IFERROR($F46*$I46/1000000,"--") | | =IFERROR($G46*$I46/1000000,"--") | | =IFERROR($F46*$J46/1000000,"--") | | =IFERROR($G46*$J46/1000000,"--") | | =$F46*$K46/1000000 | | =$G46*$K46/1000000 | | =$F46*$L46/1000000 | | =$G46*$L46/1000000 | |
| 47 | CT-114-4-210 | | =_XLFN.XLOOKUP($A47,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A47,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A47,F:F,L:L) | =$D47*$H$93*$C47/100*60*$H$94 | =$E47*$H$93*$C47/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$11/11*26.98/610.91 | ='[37]Dosing overview'!$I$10/11 | ='[37]Dosing overview'!$J$10/11 | =IFERROR($F47*$H47/1000000,"--") | | =IFERROR($G47*$H47/1000000,"--") | | =IFERROR($F47*$I47/1000000,"--") | | =IFERROR($G47*$I47/1000000,"--") | | =IFERROR($F47*$J47/1000000,"--") | | =IFERROR($G47*$J47/1000000,"--") | | =$F47*$K47/1000000 | | =$G47*$K47/1000000 | | =$F47*$L47/1000000 | | =$G47*$L47/1000000 | |
| 48 | CT-114-5-210 | | =_XLFN.XLOOKUP($A48,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A48,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A48,F:F,L:L) | =$D48*$H$93*$C48/100*60*$H$94 | =$E48*$H$93*$C48/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$11/11*26.98/610.91 | ='[37]Dosing overview'!$I$10/11 | ='[37]Dosing overview'!$J$10/11 | =IFERROR($F48*$H48/1000000,"--") | | =IFERROR($G48*$H48/1000000,"--") | | =IFERROR($F48*$I48/1000000,"--") | | =IFERROR($G48*$I48/1000000,"--") | | =IFERROR($F48*$J48/1000000,"--") | | =IFERROR($G48*$J48/1000000,"--") | | =$F48*$K48/1000000 | | =$G48*$K48/1000000 | | =$F48*$L48/1000000 | | =$G48*$L48/1000000 | |
| 49 | CUB3-CT114-21-10 | | =_XLFN.XLOOKUP($A49,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A49,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A49,F:F,L:L) | =$D49*$H$93*$C49/100*60*$H$94 | =$E49*$H$93*$C49/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$11/11*26.98/610.91 | ='[37]Dosing overview'!$I$10/11 | ='[37]Dosing overview'!$J$10/11 | =IFERROR($F49*$H49/1000000,"--") | | =IFERROR($G49*$H49/1000000,"--") | | =IFERROR($F49*$I49/1000000,"--") | | =IFERROR($G49*$I49/1000000,"--") | | =IFERROR($F49*$J49/1000000,"--") | | =IFERROR($G49*$J49/1000000,"--") | | =$F49*$K49/1000000 | | =$G49*$K49/1000000 | | =$F49*$L49/1000000 | | =$G49*$L49/1000000 | |
| 50 | CUB3-CT114-22-10 | | =_XLFN.XLOOKUP($A50,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A50,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A50,F:F,L:L) | =$D50*$H$93*$C50/100*60*$H$94 | =$E50*$H$93*$C50/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$11/11*26.98/610.91 | ='[37]Dosing overview'!$I$10/11 | ='[37]Dosing overview'!$J$10/11 | =IFERROR($F50*$H50/1000000,"--") | | =IFERROR($G50*$H50/1000000,"--") | | =IFERROR($F50*$I50/1000000,"--") | | =IFERROR($G50*$I50/1000000,"--") | | =IFERROR($F50*$J50/1000000,"--") | | =IFERROR($G50*$J50/1000000,"--") | | =$F50*$K50/1000000 | | =$G50*$K50/1000000 | | =$F50*$L50/1000000 | | =$G50*$L50/1000000 | |
| 51 | CUB3-CT114-23-10 | | =_XLFN.XLOOKUP($A51,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A51,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A51,F:F,L:L) | =$D51*$H$93*$C51/100*60*$H$94 | =$E51*$H$93*$C51/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$11/11*26.98/610.91 | ='[37]Dosing overview'!$I$10/11 | ='[37]Dosing overview'!$J$10/11 | =IFERROR($F51*$H51/1000000,"--") | | =IFERROR($G51*$H51/1000000,"--") | | =IFERROR($F51*$I51/1000000,"--") | | =IFERROR($G51*$I51/1000000,"--") | | =IFERROR($F51*$J51/1000000,"--") | | =IFERROR($G51*$J51/1000000,"--") | | =$F51*$K51/1000000 | | =$G51*$K51/1000000 | | =$F51*$L51/1000000 | | =$G51*$L51/1000000 | |
| 52 | CUB3-CT114-24-10 | | =_XLFN.XLOOKUP($A52,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A52,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A52,F:F,L:L) | =$D52*$H$93*$C52/100*60*$H$94 | =$E52*$H$93*$C52/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$11/11*26.98/610.91 | ='[37]Dosing overview'!$I$10/11 | ='[37]Dosing overview'!$J$10/11 | =IFERROR($F52*$H52/1000000,"--") | | =IFERROR($G52*$H52/1000000,"--") | | =IFERROR($F52*$I52/1000000,"--") | | =IFERROR($G52*$I52/1000000,"--") | | =IFERROR($F52*$J52/1000000,"--") | | =IFERROR($G52*$J52/1000000,"--") | | =$F52*$K52/1000000 | | =$G52*$K52/1000000 | | =$F52*$L52/1000000 | | =$G52*$L52/1000000 | |
| 53 | CUB3-CT114-25-10 | | =_XLFN.XLOOKUP($A53,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A53,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A53,F:F,L:L) | =$D53*$H$93*$C53/100*60*$H$94 | =$E53*$H$93*$C53/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$11/11*26.98/610.91 | ='[37]Dosing overview'!$I$10/11 | ='[37]Dosing overview'!$J$10/11 | =IFERROR($F53*$H53/1000000,"--") | | =IFERROR($G53*$H53/1000000,"--") | | =IFERROR($F53*$I53/1000000,"--") | | =IFERROR($G53*$I53/1000000,"--") | | =IFERROR($F53*$J53/1000000,"--") | | =IFERROR($G53*$J53/1000000,"--") | | =$F53*$K53/1000000 | | =$G53*$K53/1000000 | | =$F53*$L53/1000000 | | =$G53*$L53/1000000 | |
| 54 | CUB3-CT114-26-10 | | =_XLFN.XLOOKUP($A54,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A54,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A54,F:F,L:L) | =$D54*$H$93*$C54/100*60*$H$94 | =$E54*$H$93*$C54/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$11/11*26.98/610.91 | ='[37]Dosing overview'!$I$10/11 | ='[37]Dosing overview'!$J$10/11 | =IFERROR($F54*$H54/1000000,"--") | | =IFERROR($G54*$H54/1000000,"--") | | =IFERROR($F54*$I54/1000000,"--") | | =IFERROR($G54*$I54/1000000,"--") | | =IFERROR($F54*$J54/1000000,"--") | | =IFERROR($G54*$J54/1000000,"--") | | =$F54*$K54/1000000 | | =$G54*$K54/1000000 | | =$F54*$L54/1000000 | | =$G54*$L54/1000000 | |
| 55 | RP1-CT114-1-200 | | =_XLFN.XLOOKUP($A55,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A55,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A55,F:F,L:L) | =$D55*$H$93*$C55/100*60*$H$94 | =$E55*$H$93*$C55/100*60*$H$94*$H$96 | ='[37]Dosing overview'!$K$20/3 | ='[37]Dosing overview'!$L$20/3 | ='[37]Dosing overview'!$M$21/3*26.98/610.91 | ='[37]Dosing overview'!$I$19/3 | ='[37]Dosing overview'!$J$19/3 | =$F55*$H55/1000000 | | =$G55*$H55/1000000 | | =$F55*$I55/1000000 | | =$G55*$I55/1000000 | | =IFERROR($F55*$J55/1000000,"--") | | =IFERROR($G55*$J55/1000000,"--") | | =$F55*$K55/1000000 | | =$G55*$K55/1000000 | | =$F55*$L55/1000000 | | =$G55*$L55/1000000 | |
| 56 | RP1-CT114-2-200 | | =_XLFN.XLOOKUP($A56,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A56,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A56,F:F,L:L) | =$D56*$H$93*$C56/100*60*$H$94 | =$E56*$H$93*$C56/100*60*$H$94*$H$96 | ='[37]Dosing overview'!$K$20/3 | ='[37]Dosing overview'!$L$20/3 | ='[37]Dosing overview'!$M$21/3*26.98/610.91 | ='[37]Dosing overview'!$I$19/3 | ='[37]Dosing overview'!$J$19/3 | =$F56*$H56/1000000 | | =$G56*$H56/1000000 | | =$F56*$I56/1000000 | | =$G56*$I56/1000000 | | =IFERROR($F56*$J56/1000000,"--") | | =IFERROR($G56*$J56/1000000,"--") | | =$F56*$K56/1000000 | | =$G56*$K56/1000000 | | =$F56*$L56/1000000 | | =$G56*$L56/1000000 | |
| 57 | RP1-CT114-3-00 | | =_XLFN.XLOOKUP($A57,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A57,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A57,F:F,L:L) | =$D57*$H$93*$C57/100*60*$H$94 | =$E57*$H$93*$C57/100*60*$H$94*$H$96 | ='[37]Dosing overview'!$K$20/3 | ='[37]Dosing overview'!$L$20/3 | ='[37]Dosing overview'!$M$21/3*26.98/610.91 | ='[37]Dosing overview'!$I$19/3 | ='[37]Dosing overview'!$J$19/3 | =$F57*$H57/1000000 | | =$G57*$H57/1000000 | | =$F57*$I57/1000000 | | =$G57*$I57/1000000 | | =IFERROR($F57*$J57/1000000,"--") | | =IFERROR($G57*$J57/1000000,"--") | | =$F57*$K57/1000000 | | =$G57*$K57/1000000 | | =$F57*$L57/1000000 | | =$G57*$L57/1000000 | |
| 58 | CUB2-CT114-1-210 | | =_XLFN.XLOOKUP($A58,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A58,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A58,F:F,L:L) | =$D58*$H$93*$C58/100*60*$H$94 | =$E58*$H$93*$C58/100*60*$H$94*$H$96 | ='[37]Dosing overview'!$K$5/10 | ='[37]Dosing overview'!$L$5/10 | ='[37]Dosing overview'!$M$6/10*26.98/610.91 | ='[37]Dosing overview'!$I$4/10 | ='[37]Dosing overview'!$J$4/10 | =$F58*$H58/1000000 | | =$G58*$H58/1000000 | | =$F58*$I58/1000000 | | =$G58*$I58/1000000 | | =IFERROR($F58*$J58/1000000,"--") | | =IFERROR($G58*$J58/1000000,"--") | | =$F58*$K58/1000000 | | =$G58*$K58/1000000 | | =$F58*$L58/1000000 | | =$G58*$L58/1000000 | |
| 59 | CUB2-CT114-2-210 | | =_XLFN.XLOOKUP($A59,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A59,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A59,F:F,L:L) | =$D59*$H$93*$C59/100*60*$H$94 | =$E59*$H$93*$C59/100*60*$H$94*$H$96 | ='[37]Dosing overview'!$K$5/10 | ='[37]Dosing overview'!$L$5/10 | ='[37]Dosing overview'!$M$6/10*26.98/610.91 | ='[37]Dosing overview'!$I$4/10 | ='[37]Dosing overview'!$J$4/10 | =$F59*$H59/1000000 | | =$G59*$H59/1000000 | | =$F59*$I59/1000000 | | =$G59*$I59/1000000 | | =IFERROR($F59*$J59/1000000,"--") | | =IFERROR($G59*$J59/1000000,"--") | | =$F59*$K59/1000000 | | =$G59*$K59/1000000 | | =$F59*$L59/1000000 | | =$G59*$L59/1000000 | |
| 60 | CUB2-CT114-3-210 | | =_XLFN.XLOOKUP($A60,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A60,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A60,F:F,L:L) | =$D60*$H$93*$C60/100*60*$H$94 | =$E60*$H$93*$C60/100*60*$H$94*$H$96 | ='[37]Dosing overview'!$K$5/10 | ='[37]Dosing overview'!$L$5/10 | ='[37]Dosing overview'!$M$6/10*26.98/610.91 | ='[37]Dosing overview'!$I$4/10 | ='[37]Dosing overview'!$J$4/10 | =$F60*$H60/1000000 | | =$G60*$H60/1000000 | | =$F60*$I60/1000000 | | =$G60*$I60/1000000 | | =IFERROR($F60*$J60/1000000,"--") | | =IFERROR($G60*$J60/1000000,"--") | | =$F60*$K60/1000000 | | =$G60*$K60/1000000 | | =$F60*$L60/1000000 | | =$G60*$L60/1000000 | |
| 61 | CUB2-CT114-4-210 | | =_XLFN.XLOOKUP($A61,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A61,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A61,F:F,L:L) | =$D61*$H$93*$C61/100*60*$H$94 | =$E61*$H$93*$C61/100*60*$H$94*$H$96 | ='[37]Dosing overview'!$K$5/10 | ='[37]Dosing overview'!$L$5/10 | ='[37]Dosing overview'!$M$6/10*26.98/610.91 | ='[37]Dosing overview'!$I$4/10 | ='[37]Dosing overview'!$J$4/10 | =$F61*$H61/1000000 | | =$G61*$H61/1000000 | | =$F61*$I61/1000000 | | =$G61*$I61/1000000 | | =IFERROR($F61*$J61/1000000,"--") | | =IFERROR($G61*$J61/1000000,"--") | | =$F61*$K61/1000000 | | =$G61*$K61/1000000 | | =$F61*$L61/1000000 | | =$G61*$L61/1000000 | |
| 62 | CUB2-CT114-5-210 | | =_XLFN.XLOOKUP($A62,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A62,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A62,F:F,L:L) | =$D62*$H$93*$C62/100*60*$H$94 | =$E62*$H$93*$C62/100*60*$H$94*$H$96 | ='[37]Dosing overview'!$K$5/10 | ='[37]Dosing overview'!$L$5/10 | ='[37]Dosing overview'!$M$6/10*26.98/610.91 | ='[37]Dosing overview'!$I$4/10 | ='[37]Dosing overview'!$J$4/10 | =$F62*$H62/1000000 | | =$G62*$H62/1000000 | | =$F62*$I62/1000000 | | =$G62*$I62/1000000 | | =IFERROR($F62*$J62/1000000,"--") | | =IFERROR($G62*$J62/1000000,"--") | | =$F62*$K62/1000000 | | =$G62*$K62/1000000 | | =$F62*$L62/1000000 | | =$G62*$L62/1000000 | |
| 63 | CUB2-CT114-6-210 | | =_XLFN.XLOOKUP($A63,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A63,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A63,F:F,L:L) | =$D63*$H$93*$C63/100*60*$H$94 | =$E63*$H$93*$C63/100*60*$H$94*$H$96 | ='[37]Dosing overview'!$K$5/10 | ='[37]Dosing overview'!$L$5/10 | ='[37]Dosing overview'!$M$6/10*26.98/610.91 | ='[37]Dosing overview'!$I$4/10 | ='[37]Dosing overview'!$J$4/10 | =$F63*$H63/1000000 | | =$G63*$H63/1000000 | | =$F63*$I63/1000000 | | =$G63*$I63/1000000 | | =IFERROR($F63*$J63/1000000,"--") | | =IFERROR($G63*$J63/1000000,"--") | | =$F63*$K63/1000000 | | =$G63*$K63/1000000 | | =$F63*$L63/1000000 | | =$G63*$L63/1000000 | |
| 64 | CUB2-CT114-7-210 | | =_XLFN.XLOOKUP($A64,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A64,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A64,F:F,L:L) | =$D64*$H$93*$C64/100*60*$H$94 | =$E64*$H$93*$C64/100*60*$H$94*$H$96 | ='[37]Dosing overview'!$K$5/10 | ='[37]Dosing overview'!$L$5/10 | ='[37]Dosing overview'!$M$6/10*26.98/610.91 | ='[37]Dosing overview'!$I$4/10 | ='[37]Dosing overview'!$J$4/10 | =$F64*$H64/1000000 | | =$G64*$H64/1000000 | | =$F64*$I64/1000000 | | =$G64*$I64/1000000 | | =IFERROR($F64*$J64/1000000,"--") | | =IFERROR($G64*$J64/1000000,"--") | | =$F64*$K64/1000000 | | =$G64*$K64/1000000 | | =$F64*$L64/1000000 | | =$G64*$L64/1000000 | |
| 65 | CUB2-CT114-8-210 | | =_XLFN.XLOOKUP($A65,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A65,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A65,F:F,L:L) | =$D65*$H$93*$C65/100*60*$H$94 | =$E65*$H$93*$C65/100*60*$H$94*$H$96 | ='[37]Dosing overview'!$K$5/10 | ='[37]Dosing overview'!$L$5/10 | ='[37]Dosing overview'!$M$6/10*26.98/610.91 | ='[37]Dosing overview'!$I$4/10 | ='[37]Dosing overview'!$J$4/10 | =$F65*$H65/1000000 | | =$G65*$H65/1000000 | | =$F65*$I65/1000000 | | =$G65*$I65/1000000 | | =IFERROR($F65*$J65/1000000,"--") | | =IFERROR($G65*$J65/1000000,"--") | | =$F65*$K65/1000000 | | =$G65*$K65/1000000 | | =$F65*$L65/1000000 | | =$G65*$L65/1000000 | |
| 66 | CUB2-CT114-9-210 | | =_XLFN.XLOOKUP($A66,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A66,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A66,F:F,L:L) | =$D66*$H$93*$C66/100*60*$H$94 | =$E66*$H$93*$C66/100*60*$H$94*$H$96 | ='[37]Dosing overview'!$K$5/10 | ='[37]Dosing overview'!$L$5/10 | ='[37]Dosing overview'!$M$6/10*26.98/610.91 | ='[37]Dosing overview'!$I$4/10 | ='[37]Dosing overview'!$J$4/10 | =$F66*$H66/1000000 | | =$G66*$H66/1000000 | | =$F66*$I66/1000000 | | =$G66*$I66/1000000 | | =IFERROR($F66*$J66/1000000,"--") | | =IFERROR($G66*$J66/1000000,"--") | | =$F66*$K66/1000000 | | =$G66*$K66/1000000 | | =$F66*$L66/1000000 | | =$G66*$L66/1000000 | |
| 67 | CUB2-CT114-10-210 | | =_XLFN.XLOOKUP($A67,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A67,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A67,F:F,L:L) | =$D67*$H$93*$C67/100*60*$H$94 | =$E67*$H$93*$C67/100*60*$H$94*$H$96 | ='[37]Dosing overview'!$K$5/10 | ='[37]Dosing overview'!$L$5/10 | ='[37]Dosing overview'!$M$6/10*26.98/610.91 | ='[37]Dosing overview'!$I$4/10 | ='[37]Dosing overview'!$J$4/10 | =$F67*$H67/1000000 | | =$G67*$H67/1000000 | | =$F67*$I67/1000000 | | =$G67*$I67/1000000 | | =IFERROR($F67*$J67/1000000,"--") | | =IFERROR($G67*$J67/1000000,"--") | | =$F67*$K67/1000000 | | =$G67*$K67/1000000 | | =$F67*$L67/1000000 | | =$G67*$L67/1000000 | |
| 68 | CUB2-CT114-11-10 | | =_XLFN.XLOOKUP($A68,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A68,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A68,F:F,L:L) | =$D68*$H$93*$C68/100*60*$H$94 | =$E68*$H$93*$C68/100*60*$H$94*$H$96 | ='[37]Dosing overview'!$K$7/4 | ='[37]Dosing overview'!$L$7/4 | ='[37]Dosing overview'!$M$8/4*26.98/610.91 | ='[37]Dosing overview'!$I$9/4 | ='[37]Dosing overview'!$J$9/4 | =$F68*$H68/1000000 | | =$G68*$H68/1000000 | | =$F68*$I68/1000000 | | =$G68*$I68/1000000 | | =IFERROR($F68*$J68/1000000,"--") | | =IFERROR($G68*$J68/1000000,"--") | | =$F68*$K68/1000000 | | =$G68*$K68/1000000 | | =$F68*$L68/1000000 | | =$G68*$L68/1000000 | |
| 69 | CUB2-CT114-12-10 | | =_XLFN.XLOOKUP($A69,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A69,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A69,F:F,L:L) | =$D69*$H$93*$C69/100*60*$H$94 | =$E69*$H$93*$C69/100*60*$H$94*$H$96 | ='[37]Dosing overview'!$K$7/4 | ='[37]Dosing overview'!$L$7/4 | ='[37]Dosing overview'!$M$8/4*26.98/610.91 | ='[37]Dosing overview'!$I$9/4 | ='[37]Dosing overview'!$J$9/4 | =$F69*$H69/1000000 | | =$G69*$H69/1000000 | | =$F69*$I69/1000000 | | =$G69*$I69/1000000 | | =IFERROR($F69*$J69/1000000,"--") | | =IFERROR($G69*$J69/1000000,"--") | | =$F69*$K69/1000000 | | =$G69*$K69/1000000 | | =$F69*$L69/1000000 | | =$G69*$L69/1000000 | |
| 70 | CUB2-CT114-13-10 | | =_XLFN.XLOOKUP($A70,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A70,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A70,F:F,L:L) | =$D70*$H$93*$C70/100*60*$H$94 | =$E70*$H$93*$C70/100*60*$H$94*$H$96 | ='[37]Dosing overview'!$K$7/4 | ='[37]Dosing overview'!$L$7/4 | ='[37]Dosing overview'!$M$8/4*26.98/610.91 | ='[37]Dosing overview'!$I$9/4 | ='[37]Dosing overview'!$J$9/4 | =$F70*$H70/1000000 | | =$G70*$H70/1000000 | | =$F70*$I70/1000000 | | =$G70*$I70/1000000 | | =IFERROR($F70*$J70/1000000,"--") | | =IFERROR($G70*$J70/1000000,"--") | | =$F70*$K70/1000000 | | =$G70*$K70/1000000 | | =$F70*$L70/1000000 | | =$G70*$L70/1000000 | |
| 71 | CUB2-CT114-14-10 | | =_XLFN.XLOOKUP($A71,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A71,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A71,F:F,L:L) | =$D71*$H$93*$C71/100*60*$H$94 | =$E71*$H$93*$C71/100*60*$H$94*$H$96 | ='[37]Dosing overview'!$K$7/4 | ='[37]Dosing overview'!$L$7/4 | ='[37]Dosing overview'!$M$8/4*26.98/610.91 | ='[37]Dosing overview'!$I$9/4 | ='[37]Dosing overview'!$J$9/4 | =$F71*$H71/1000000 | | =$G71*$H71/1000000 | | =$F71*$I71/1000000 | | =$G71*$I71/1000000 | | =IFERROR($F71*$J71/1000000,"--") | | =IFERROR($G71*$J71/1000000,"--") | | =$F71*$K71/1000000 | | =$G71*$K71/1000000 | | =$F71*$L71/1000000 | | =$G71*$L71/1000000 | |
| 72 | F20-CT114-1-210 | | =_XLFN.XLOOKUP($A72,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A72,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A72,F:F,L:L) | =$D72*$H$93*$C72/100*60*$H$94 | =$E72*$H$93*$C72/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$3/11*26.98/610.91 | ='[37]Dosing overview'!$I$2/11 | ='[37]Dosing overview'!$J$2/11 | =IFERROR($F72*$H72/1000000,"--") | | =IFERROR($G72*$H72/1000000,"--") | | =IFERROR($F72*$I72/1000000,"--") | | =IFERROR($G72*$I72/1000000,"--") | | =IFERROR($F72*$J72/1000000,"--") | | =IFERROR($G72*$J72/1000000,"--") | | =$F72*$K72/1000000 | | =$G72*$K72/1000000 | | =$F72*$L72/1000000 | | =$G72*$L72/1000000 | |
| 73 | F20-CT114-2-210 | | =_XLFN.XLOOKUP($A73,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A73,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A73,F:F,L:L) | =$D73*$H$93*$C73/100*60*$H$94 | =$E73*$H$93*$C73/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$3/11*26.98/610.91 | ='[37]Dosing overview'!$I$2/11 | ='[37]Dosing overview'!$J$2/11 | =IFERROR($F73*$H73/1000000,"--") | | =IFERROR($G73*$H73/1000000,"--") | | =IFERROR($F73*$I73/1000000,"--") | | =IFERROR($G73*$I73/1000000,"--") | | =IFERROR($F73*$J73/1000000,"--") | | =IFERROR($G73*$J73/1000000,"--") | | =$F73*$K73/1000000 | | =$G73*$K73/1000000 | | =$F73*$L73/1000000 | | =$G73*$L73/1000000 | |
| 74 | F20-CT114-3-210 | | =_XLFN.XLOOKUP($A74,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A74,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A74,F:F,L:L) | =$D74*$H$93*$C74/100*60*$H$94 | =$E74*$H$93*$C74/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$3/11*26.98/610.91 | ='[37]Dosing overview'!$I$2/11 | ='[37]Dosing overview'!$J$2/11 | =IFERROR($F74*$H74/1000000,"--") | | =IFERROR($G74*$H74/1000000,"--") | | =IFERROR($F74*$I74/1000000,"--") | | =IFERROR($G74*$I74/1000000,"--") | | =IFERROR($F74*$J74/1000000,"--") | | =IFERROR($G74*$J74/1000000,"--") | | =$F74*$K74/1000000 | | =$G74*$K74/1000000 | | =$F74*$L74/1000000 | | =$G74*$L74/1000000 | |
| 75 | F20-CT114-4-210 | | =_XLFN.XLOOKUP($A75,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A75,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A75,F:F,L:L) | =$D75*$H$93*$C75/100*60*$H$94 | =$E75*$H$93*$C75/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$3/11*26.98/610.91 | ='[37]Dosing overview'!$I$2/11 | ='[37]Dosing overview'!$J$2/11 | =IFERROR($F75*$H75/1000000,"--") | | =IFERROR($G75*$H75/1000000,"--") | | =IFERROR($F75*$I75/1000000,"--") | | =IFERROR($G75*$I75/1000000,"--") | | =IFERROR($F75*$J75/1000000,"--") | | =IFERROR($G75*$J75/1000000,"--") | | =$F75*$K75/1000000 | | =$G75*$K75/1000000 | | =$F75*$L75/1000000 | | =$G75*$L75/1000000 | |
| 76 | F20-CT114-5-210 | | =_XLFN.XLOOKUP($A76,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A76,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A76,F:F,L:L) | =$D76*$H$93*$C76/100*60*$H$94 | =$E76*$H$93*$C76/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$3/11*26.98/610.91 | ='[37]Dosing overview'!$I$2/11 | ='[37]Dosing overview'!$J$2/11 | =IFERROR($F76*$H76/1000000,"--") | | =IFERROR($G76*$H76/1000000,"--") | | =IFERROR($F76*$I76/1000000,"--") | | =IFERROR($G76*$I76/1000000,"--") | | =IFERROR($F76*$J76/1000000,"--") | | =IFERROR($G76*$J76/1000000,"--") | | =$F76*$K76/1000000 | | =$G76*$K76/1000000 | | =$F76*$L76/1000000 | | =$G76*$L76/1000000 | |
| 77 | F20-CT114-6-210 | | =_XLFN.XLOOKUP($A77,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A77,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A77,F:F,L:L) | =$D77*$H$93*$C77/100*60*$H$94 | =$E77*$H$93*$C77/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$3/11*26.98/610.91 | ='[37]Dosing overview'!$I$2/11 | ='[37]Dosing overview'!$J$2/11 | =IFERROR($F77*$H77/1000000,"--") | | =IFERROR($G77*$H77/1000000,"--") | | =IFERROR($F77*$I77/1000000,"--") | | =IFERROR($G77*$I77/1000000,"--") | | =IFERROR($F77*$J77/1000000,"--") | | =IFERROR($G77*$J77/1000000,"--") | | =$F77*$K77/1000000 | | =$G77*$K77/1000000 | | =$F77*$L77/1000000 | | =$G77*$L77/1000000 | |
| 78 | F20-CT114-7-210 | | =_XLFN.XLOOKUP($A78,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A78,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A78,F:F,L:L) | =$D78*$H$93*$C78/100*60*$H$94 | =$E78*$H$93*$C78/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$3/11*26.98/610.91 | ='[37]Dosing overview'!$I$2/11 | ='[37]Dosing overview'!$J$2/11 | =IFERROR($F78*$H78/1000000,"--") | | =IFERROR($G78*$H78/1000000,"--") | | =IFERROR($F78*$I78/1000000,"--") | | =IFERROR($G78*$I78/1000000,"--") | | =IFERROR($F78*$J78/1000000,"--") | | =IFERROR($G78*$J78/1000000,"--") | | =$F78*$K78/1000000 | | =$G78*$K78/1000000 | | =$F78*$L78/1000000 | | =$G78*$L78/1000000 | |
| 79 | F20-CT114-8-210 | | =_XLFN.XLOOKUP($A79,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A79,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A79,F:F,L:L) | =$D79*$H$93*$C79/100*60*$H$94 | =$E79*$H$93*$C79/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$3/11*26.98/610.91 | ='[37]Dosing overview'!$I$2/11 | ='[37]Dosing overview'!$J$2/11 | =IFERROR($F79*$H79/1000000,"--") | | =IFERROR($G79*$H79/1000000,"--") | | =IFERROR($F79*$I79/1000000,"--") | | =IFERROR($G79*$I79/1000000,"--") | | =IFERROR($F79*$J79/1000000,"--") | | =IFERROR($G79*$J79/1000000,"--") | | =$F79*$K79/1000000 | | =$G79*$K79/1000000 | | =$F79*$L79/1000000 | | =$G79*$L79/1000000 | |
| 80 | F20-CT114-9-210 | | =_XLFN.XLOOKUP($A80,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A80,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A80,F:F,L:L) | =$D80*$H$93*$C80/100*60*$H$94 | =$E80*$H$93*$C80/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$3/11*26.98/610.91 | ='[37]Dosing overview'!$I$2/11 | ='[37]Dosing overview'!$J$2/11 | =IFERROR($F80*$H80/1000000,"--") | | =IFERROR($G80*$H80/1000000,"--") | | =IFERROR($F80*$I80/1000000,"--") | | =IFERROR($G80*$I80/1000000,"--") | | =IFERROR($F80*$J80/1000000,"--") | | =IFERROR($G80*$J80/1000000,"--") | | =$F80*$K80/1000000 | | =$G80*$K80/1000000 | | =$F80*$L80/1000000 | | =$G80*$L80/1000000 | |
| 81 | F20-CT114-10-210 | | =_XLFN.XLOOKUP($A81,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A81,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A81,F:F,L:L) | =$D81*$H$93*$C81/100*60*$H$94 | =$E81*$H$93*$C81/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$3/11*26.98/610.91 | ='[37]Dosing overview'!$I$2/11 | ='[37]Dosing overview'!$J$2/11 | =IFERROR($F81*$H81/1000000,"--") | | =IFERROR($G81*$H81/1000000,"--") | | =IFERROR($F81*$I81/1000000,"--") | | =IFERROR($G81*$I81/1000000,"--") | | =IFERROR($F81*$J81/1000000,"--") | | =IFERROR($G81*$J81/1000000,"--") | | =$F81*$K81/1000000 | | =$G81*$K81/1000000 | | =$F81*$L81/1000000 | | =$G81*$L81/1000000 | |
| 82 | F20-CT114-11-210 | | =_XLFN.XLOOKUP($A82,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A82,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A82,F:F,L:L) | =$D82*$H$93*$C82/100*60*$H$94 | =$E82*$H$93*$C82/100*60*$H$94*$H$96 | -- | -- | ='[37]Dosing overview'!$M$3/11*26.98/610.91 | ='[37]Dosing overview'!$I$2/11 | ='[37]Dosing overview'!$J$2/11 | =IFERROR($F82*$H82/1000000,"--") | | =IFERROR($G82*$H82/1000000,"--") | | =IFERROR($F82*$I82/1000000,"--") | | =IFERROR($G82*$I82/1000000,"--") | | =IFERROR($F82*$J82/1000000,"--") | | =IFERROR($G82*$J82/1000000,"--") | | =$F82*$K82/1000000 | | =$G82*$K82/1000000 | | =$F82*$L82/1000000 | | =$G82*$L82/1000000 | |
| 83 | N2-CT114-1 | | =_XLFN.XLOOKUP($A83,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A83,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A83,F:F,L:L) | =$D83*$H$93*$C83/100*60*$H$94 | =$E83*$H$93*$C83/100*60*$H$94*$H$96 | -- | -- | -- | ='[37]Dosing overview'!$I$28 | ='[37]Dosing overview'!$J$28 | =IFERROR($F83*$H83/1000000,"--") | | =IFERROR($G83*$H83/1000000,"--") | | =IFERROR($F83*$I83/1000000,"--") | | =IFERROR($G83*$I83/1000000,"--") | | =IFERROR($F83*$J83/1000000,"--") | | =IFERROR($G83*$J83/1000000,"--") | | =$F83*$K83/1000000 | | =$G83*$K83/1000000 | | =$F83*$L83/1000000 | | =$G83*$L83/1000000 | |
| 84 | N2-CT114-2 | | =_XLFN.XLOOKUP($A84,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A84,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A84,F:F,L:L) | =$D84*$H$93*$C84/100*60*$H$94 | =$E84*$H$93*$C84/100*60*$H$94*$H$96 | -- | -- | -- | ='[37]Dosing overview'!$I$29 | ='[37]Dosing overview'!$J$29 | =IFERROR($F84*$H84/1000000,"--") | | =IFERROR($G84*$H84/1000000,"--") | | =IFERROR($F84*$I84/1000000,"--") | | =IFERROR($G84*$I84/1000000,"--") | | =IFERROR($F84*$J84/1000000,"--") | | =IFERROR($G84*$J84/1000000,"--") | | =$F84*$K84/1000000 | | =$G84*$K84/1000000 | | =$F84*$L84/1000000 | | =$G84*$L84/1000000 | |
| 85 | N2-CT114-3 | | =_XLFN.XLOOKUP($A85,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A85,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A85,F:F,L:L) | =$D85*$H$93*$C85/100*60*$H$94 | =$E85*$H$93*$C85/100*60*$H$94*$H$96 | -- | -- | -- | ='[37]Dosing overview'!$I$31 | ='[37]Dosing overview'!$J$31 | =IFERROR($F85*$H85/1000000,"--") | | =IFERROR($G85*$H85/1000000,"--") | | =IFERROR($F85*$I85/1000000,"--") | | =IFERROR($G85*$I85/1000000,"--") | | =IFERROR($F85*$J85/1000000,"--") | | =IFERROR($G85*$J85/1000000,"--") | | =$F85*$K85/1000000 | | =$G85*$K85/1000000 | | =$F85*$L85/1000000 | | =$G85*$L85/1000000 | |
| 86 | RACB3-CT-114-1-35 | | =_XLFN.XLOOKUP($A86,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A86,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A86,F:F,L:L) | =$D86*$H$93*$C86/100*60*$H$94 | =$E86*$H$93*$C86/100*60*$H$94*$H$96 | ='[37]Dosing overview'!$K$17/3 | ='[37]Dosing overview'!$L$17/3 | ='[37]Dosing overview'!$M$18/3*26.98/610.91 | ='[37]Dosing overview'!$I$16/3 | ='[37]Dosing overview'!$J$16/3 | =$F86*$H86/1000000 | | =$G86*$H86/1000000 | | =$F86*$I86/1000000 | | =$G86*$I86/1000000 | | =IFERROR($F86*$J86/1000000,"--") | | =IFERROR($G86*$J86/1000000,"--") | | =$F86*$K86/1000000 | | =$G86*$K86/1000000 | | =$F86*$L86/1000000 | | =$G86*$L86/1000000 | |
| 87 | RACB3-CT-114-2-35 | | =_XLFN.XLOOKUP($A87,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A87,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A87,F:F,L:L) | =$D87*$H$93*$C87/100*60*$H$94 | =$E87*$H$93*$C87/100*60*$H$94*$H$96 | ='[37]Dosing overview'!$K$17/3 | ='[37]Dosing overview'!$L$17/3 | ='[37]Dosing overview'!$M$18/3*26.98/610.91 | ='[37]Dosing overview'!$I$16/3 | ='[37]Dosing overview'!$J$16/3 | =$F87*$H87/1000000 | | =$G87*$H87/1000000 | | =$F87*$I87/1000000 | | =$G87*$I87/1000000 | | =IFERROR($F87*$J87/1000000,"--") | | =IFERROR($G87*$J87/1000000,"--") | | =$F87*$K87/1000000 | | =$G87*$K87/1000000 | | =$F87*$L87/1000000 | | =$G87*$L87/1000000 | |
| 88 | RACB3-CT-114-3-35 | | =_XLFN.XLOOKUP($A88,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$G$4:$G$95) | =_XLFN.XLOOKUP($A88,'Input_Cooling Towers'!$A$4:$A$95,'Input_Cooling Towers'!$F$4:$F$95) | =_XLFN.XLOOKUP(A88,F:F,L:L) | =$D88*$H$93*$C88/100*60*$H$94 | =$E88*$H$93*$C88/100*60*$H$94*$H$96 | ='[37]Dosing overview'!$K$17/3 | ='[37]Dosing overview'!$L$17/3 | ='[37]Dosing overview'!$M$18/3*26.98/610.91 | ='[37]Dosing overview'!$I$16/3 | ='[37]Dosing overview'!$J$16/3 | =$F88*$H88/1000000 | | =$G88*$H88/1000000 | | =$F88*$I88/1000000 | | =$G88*$I88/1000000 | | =IFERROR($F88*$J88/1000000,"--") | | =IFERROR($G88*$J88/1000000,"--") | | =$F88*$K88/1000000 | | =$G88*$K88/1000000 | | =$F88*$L88/1000000 | | =$G88*$L88/1000000 | |
| 89 | Total | | | | | | | | | | | | =SUM(M5:M88) | | =SUM(O5:O88) | | =SUM(Q5:Q88) | | =SUM(S5:S88) | | =SUM(U5:U88) | | =SUM(W5:W88) | | =SUM(Y5:Y88) | | =SUM(AA5:AA88) | | =SUM(AC5:AC88) | | =SUM(AE5:AE88) | |
| 90 | Notes | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| 91 | TAC = Toxic Air Contaminant | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| 92 | ="("&CHAR((ROW()-MATCH("Notes",A:A,FALSE)-COUNTIF(INDIRECT(ADDRESS(MATCH("Notes",A:A,FALSE),COLUMN())):INDIRECT(ADDRESS(ROW()-1,COLUMN())),""))+95)&")" | Daily drift loss (lb/day) = (total water circulation rate [gpm]) x (density of water [lb/gal]) x (drift loss percent of circulating water [%] / 100) x (60 min/hr) x (daily hours of operation [hrs/day]) | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| 93 | | | | | | | Density of water (lb/gal) = | 8.34 | | | | | | | | | | | | | | | | | | | | | | | | |
| 94 | | | | | | | Daily hours of operation (hrs/day) = | 24 | =$A$105 | | | | | | | | | | | | | | | | | | | | | | | |
| 95 | ="("&CHAR((ROW()-MATCH("Notes",A:A,FALSE)-COUNTIF(INDIRECT(ADDRESS(MATCH("Notes",A:A,FALSE),COLUMN())):INDIRECT(ADDRESS(ROW()-1,COLUMN())),""))+95)&")" | Annual drift loss (lb/yr) = (daily drift loss [lb/day]) x (annual days of operation [days/yr]) | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| 96 | | | | | | | Annual days of operation (days/yr) = | 365 | =$A$105 | | | | | | | | | | | | | | | | | | | | | | | |
| 97 | ="("&CHAR((ROW()-MATCH("Notes",A:A,FALSE)-COUNTIF(INDIRECT(ADDRESS(MATCH("Notes",A:A,FALSE),COLUMN())):INDIRECT(ADDRESS(ROW()-1,COLUMN())),""))+95)&")" | Daily emissions estimate (lb/day) = (daily drift loss [lb/day]) x (concentration [ppm] / 1,000,000) | | | | | | | =$A$106 | | | | | | | | | | | | | | | | | | | | | | | |
| 98 | ="("&CHAR((ROW()-MATCH("Notes",A:A,FALSE)-COUNTIF(INDIRECT(ADDRESS(MATCH("Notes",A:A,FALSE),COLUMN())):INDIRECT(ADDRESS(ROW()-1,COLUMN())),""))+95)&")" | Annual emissions estimate (lb/yr) = (annual drift loss [lb/yr]) x (concentration [ppm] / 1,000,000) | | | | | | | =$A$106 | | | | | | | | | | | | | | | | | | | | | | | |
| 99 | ="("&CHAR((ROW()-MATCH("Notes",A:A,FALSE)-COUNTIF(INDIRECT(ADDRESS(MATCH("Notes",A:A,FALSE),COLUMN())):INDIRECT(ADDRESS(ROW()-1,COLUMN())),""))+95)&")" | Aluminum concentration (ppm) = (aluminum distearate concentration [ppm]) x (molecular weight of aluminum [g/mol]) / (molecular weight of aluminum distearate [g/mol]) | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| 100 | | | | | | | Molecular weight of aluminum (g/mol) = | 26.98 | | | | | | | | | | | | | | | | | | | | | | | | |
| 101 | | | | | | | Molecular weight of aluminum distearate (g/mol) = | 610.91 | | | | | | | | | | | | | | | | | | | | | | | | |
| 102 | References | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| 103 | ="("&(ROW()-MATCH("References",A:A,FALSE)-COUNTIF(INDIRECT(ADDRESS(MATCH("References",A:A,FALSE),COLUMN())):INDIRECT(ADDRESS(ROW()-1,COLUMN())),""))&")" | See Input Cooling Tower for Rates and Parameters | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| 104 | ="("&(ROW()-MATCH("References",A:A,FALSE)-COUNTIF(INDIRECT(ADDRESS(MATCH("References",A:A,FALSE),COLUMN())):INDIRECT(ADDRESS(ROW()-1,COLUMN())),""))&")" | Information provided by Intel Corporation. TAC concentration Is based on dosage rates and TAC percentage in SDS. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| 105 | ="("&(ROW()-MATCH("References",A:A,FALSE)-COUNTIF(INDIRECT(ADDRESS(MATCH("References",A:A,FALSE),COLUMN())):INDIRECT(ADDRESS(ROW()-1,COLUMN())),""))&")" | Based on continuous operation. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| 106 | ="("&(ROW()-MATCH("References",A:A,FALSE)-COUNTIF(INDIRECT(ADDRESS(MATCH("References",A:A,FALSE),COLUMN())):INDIRECT(ADDRESS(ROW()-1,COLUMN())),""))&")" | Assumes the composition of the drift loss is same as the cooling tower makeup water. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| 107 | (5) | Assumes that dosing frequency is daily | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| 108 | (6) | Dosing rates for RA5 and RA6 assumed to be similar to RAC5 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| 109 | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |