Question: First, copy the model sheet and do all your analysis in the new sheet. The easiest approach is to modify the line that has emissions

First, copy the model sheet and do all your analysis in the new sheet. The easiest approach is to modify the line that has emissions in such a way that starting with the second time step you use an equation to compute emissions. Assuming that the cell for emissions in the year 2011 is C24, the Excel formula might look like "=B23*(1-$B$20)". In this case the cell B20 would have the percent reduction in emission per year in it and you could quickly change the emissions profile by changing the value in cell B20. Finally, you might want to have one cell that displays the maximum temperature increase over the model time horizon. Assuming the predicted temperatures are in cells B48 to KF48, you might add a cell that has the equation "=MAX(B48:KF48)" in it to help you

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!