{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

LPPD_inExcel - Lake Pollution Problem constants for the...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
avergae lake depth (ft) 20 360 100 8,640 surface area of lake (sq ft) 4,356,000 20 volume of lake (cu ft) 87,120,000 432 0 18 0 vol input river (cu ft/hr) 10,000 0.1 10 10,000 step number 1 0 0.00000500 435.60 4.32 2 432 0.00000976 850.28 4.32 3 864 0.00001428 1,244.43 4.32 4 1,296 0.00001858 1,619.05 4.32 5 1,728 0.00002267 1,975.08 4.32 6 2,160 0.00002655 2,313.47 4.32 7 2,592 0.00003025 2,635.07 4.32 8 3,024 0.00003375 2,940.72 4.32 9 3,456 0.00003709 3,231.22 4.32 10 3,888 0.00004026 3,507.32 4.32 11 4,320 0.00004327 3,769.72 4.32 12 4,752 0.00004613 4,019.11 4.32 13 5,184 0.00004885 4,256.14 4.32 14 5,616 0.00005144 4,481.41 4.32 15 6,048 0.00005390 4,695.51 4.32 16 6,480 0.00005623 4,899.00 4.32 17 6,912 0.00005845 5,092.39 4.32 18 7,344 0.00006056 5,276.19 4.32 19 7,776 0.00006257 5,450.89 4.32 20 8,208 0.00006447 5,616.91 4.32 how many days should we look at surface area of lake (acres) how many hours should we look at number of time steps size of time step (hrs) init concentration in lake (lbs /cu ft) size of time step (days) concen in input river (lbs / cu ft) factory discharge concen (lbs/cu ft) vol factory discharge (cu ft/hr) vol output stream (cu ft/hr) start time (hrs) beginning concentration (lbs/cu ft) beginning amount (lbs) amount in from input stream (lbs) Lake Pollution Problem - constants for the simulation. Note that each cell containing a constant is a NAMED CELL. Lake Pollution Problem - time based simulation. Where ever appropriate, use CELL NAMES in your formula. Items in magenta are user inputs to the simul Once your simulation is set up (by filling in ce
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}