Produce the spreadsheet in Figure 6.4 by following the steps outlined in the reading and turn in the results.

Transcribed Image Text:

1234567890123 A B Conc. Flow (mm) (L/hr) NaOH Costs Price D Cost ($/L) ($/hr) $2,345 $2,477 E F Pmp Cost Tot Cost (S/hr) ($/hr) G H HCI flow (L/hr) = HCI conc (mM) = $5,619 $7,964 $3,746 $6,223 5.0 32,480 $.072 7.5 21,653 $.114 10.0 16,240 $.163 12.5 12,992 $.216 15.0 10,827 $.274 $2,642 $2,810 $5,452 $2,808 $2,248 $5,055 $2,967 $2,100 $5,067 $1,800 $4,918 17.5 20.0 9,280 $.336 $3,117 8,120 $.401 $3,260 $1,575 $4,835 22.5 $4,796 $4,784 14 $4,792 7,218 $.470 $3,395 $1,400 25.0 6,496 $.542 $3,524 $1,260 27.5 5,905 $.617 $3,646 $1,146 15 30.0 5,413 $.695 $3,764 $1,050 $4,814 32.5 4,997 $.776 $3,876 35.0 4,640 $.859 $3,984 18 37.5 4,331 $.944 $4,088 19 40.0 4,060 $1.032 $4,188 16 $969 $4,845 17 $900 $4,884 $840 $4,928 $788 $4,976 $741 $5,027 20 42.5 21 45.0 3,821 $1.122 $4,286 3,609 $1.214 $4,380 $5,080 $700 $663 $5,134 22 47.5 3,419 $1.308 $4,471 23 50.0 3,248 $1.404 $4,559 $630 $5,189 24 52.5 3,093 $1.502 $4,645 $600 $5,245 Figure 6.4 The final version of the calculation spreadsheet NaOH cost ($/L) = I JKL 11600 14 0.0058 *C^ Pumping cost ($/L) = C<13 mM C>=13 MM 173 194 1.4 + 017