Microsoft Office Tutorials and References
In Depth Information
Cases and Places
Cases and Places continued
These formulas have been supplied:
Formula A: Amount Remaining = Original Amount
0.5 (Number of Years Stored / Half-Life)
Formula B: Containment Costs = Containment Cost Per Kilogram
Total Amount Remaining
Formula C: Estimated Appropriations = Appropriations
(1 + Estimated Yearly Increase)
(Number of Years Stored / Half-Life)
Formula D: Percentage Spent on Containment = Containment Costs / Estimated Appropriations
The director has asked your group to include a function that prints “Acceptable” below the percentage
spent on containment whenever the percentage is less than 1%, otherwise print “Not Acceptable.”
Have each member of your team submit a sketch of the proposed worksheet and then implement
the best one. Use the concepts and techniques presented in this project to create and format the worksheet.
Submit the sketches and workbook as requested by your instructor.
Table 3–21 Cost of Storing Radioactive Isotopes
Number of Years Stored
.................................................
Number of Years Stored
1
2
3
10
Amount of Isotope X
Remaining (in kg)
Formula A
Amount of Isotope Y
Remaining (in kg)
Formula A
.................................................
Total Remaining (in kg)
Containment Costs
Formula B
Estimated Appropriations
Formula C
Percentage Spent on
Containment
Formula D
Message
Assumptions
Original Amount of Isotope X Remaining (in kg)
650
Half-Life of Isotope X (in years)
1
Containment Cost per Kilogram
1000
Estimated Yearly Increase
10.00%
Original Amount of Isotope Y Remaining (in kg)
3000
Half-Life of Isotope Y (in years)
0.45
Appropriations
6000000
 
Search JabSto ::




Custom Search