136
edits
Changes
mLine 380:
Line 380: − Breakdown: this allows you to select whether you want a simple breakdown (costs, benefits, net), or a breakdown by activity, by stakeholder, or by activity and stakeholder. − Sort tables by: this allows you to sort the values in the tables in different ways. When the breakdown is set to simple, the only option is default. But if the breakdown is anything else, you can sort by the magnitude of the impact, by the activity name, or by the stakeholder group name. In general, "Default" sorting aligns with the order in which activities and stakeholders were entered on their respective sheets. + − Group tables by: by default this is set to "Discounting", meaning that it will first produce the Discounted Costs, Benefits and Net Impacts, then the Undiscounted Costs, Benefits, and Net Impacts. Changing this to "Costs | Benefits | Net" means that the output will look like: Discounted Costs, Undiscounted Costs, Discounted Benefits, Undiscounted Benefits, Discounted Net, Undiscounted Net.+ − + + + − +
→Annual Impact
'''Breakdown:''' this allows you to select whether you want a simple breakdown (costs, benefits, net), or a breakdown by activity, by stakeholder, or by activity and stakeholder.
'''Sort tables by:''' this allows you to sort the values in the tables in different ways. When the breakdown is set to simple, the only option is default. But if the breakdown is anything else, you can sort by the magnitude of the impact, by the activity name, or by the stakeholder group name. In general, "Default" sorting aligns with the order in which activities and stakeholders were entered on their respective sheets.
Order of magnitude: this lets you change from single dollars, to millions of dollars or billions of dollars. Potentially helpful if you're trying to copy-paste large numbers into Word. Note: with the order of magnitude set to millions or billions it may be helpful to adjust the number of decimals, by selecting Increase Decimal in the ribbon:
'''Group tables by:''' by default this is set to "Discounting", meaning that it will first produce the Discounted Costs, Benefits and Net Impacts, then the Undiscounted Costs, Benefits, and Net Impacts. Changing this to "Costs | Benefits | Net" means that the output will look like: Discounted Costs, Undiscounted Costs, Discounted Benefits, Undiscounted Benefits, Discounted Net, Undiscounted Net.
'''Order of magnitude:''' this lets you change from single dollars, to millions of dollars or billions of dollars. Potentially helpful if you're trying to copy-paste large numbers into Word. Note: with the order of magnitude set to millions or billions it may be helpful to adjust the number of decimals, by selecting Increase Decimal in the ribbon:
[[File:Ribbondecimals.png|center|thumb|1300x1300px|Increase decimal]]
[[File:Ribbondecimals.png|center|thumb|1300x1300px|Increase decimal]]
Display years in: by default this is set to Rows, but you can change it to columns if you'd prefer.
'''Display years in:''' by default this is set to Rows, but you can change it to columns if you'd prefer.
=== Cost-benefit statement ===
=== Cost-benefit statement ===