Using a computer spreadsheet you have written, and the data in Problem 11–26, determine the daily and annual sludge production at the following removal efficiencies: 40%, 45%, 50%, 55%, 60%, and 65%. Plot annual sludge production as a function of efficiency
I do not have any such spreadsheet.
Graph
efficiency on x axis
annual sludge produced as y values.
By the way, if your efficiency is 40% what happens to the other 60%?
Is it used to fertilize Romaine lettuce in Arizona?
To determine the daily and annual sludge production at different removal efficiencies using a computer spreadsheet, follow these steps:
1. Open a spreadsheet software like Microsoft Excel, Google Sheets, or Apple Numbers.
2. Enter the data from Problem 11-26 into the spreadsheet. The data should include efficiency values and corresponding sludge production values. For example, you might have two columns: "Efficiency" and "Sludge Production".
3. Once you have entered the data, create a new column entitled "Daily Sludge Production" next to the "Efficiency" and "Sludge Production" columns.
4. In the "Daily Sludge Production" column, calculate the daily sludge production by multiplying the sludge production value by the efficiency value. For example, if the sludge production value is 100 and the efficiency value is 40%, the daily sludge production would be calculated as 100 * 40% = 40. Apply this calculation to all rows in the column.
5. Create another column entitled "Annual Sludge Production" next to the "Daily Sludge Production" column.
6. In the "Annual Sludge Production" column, calculate the annual sludge production by multiplying the daily sludge production value by 365 (assuming a year has 365 days). For example, if the daily sludge production value is 40 (as calculated in step 4), the annual sludge production would be calculated as 40 * 365 = 14,600. Apply this calculation to all rows in the column.
7. Select all the data in the "Efficiency" and "Annual Sludge Production" columns.
8. Create a line chart or scatter plot using the selected data. The "Efficiency" values should be on the x-axis, and the "Annual Sludge Production" values on the y-axis.
9. Customize the chart as desired, including adding labels to the axes and a title.
10. Plot the chart, and you will have a visual representation of annual sludge production as a function of efficiency.
By following these steps, you should be able to determine the daily and annual sludge production for various removal efficiencies using a computer spreadsheet and plot the annual sludge production as a function of efficiency.