Changes

With the blue-shaded section at the top you can modify the order of magnitude (single dollars, millions of dollars, billions of dollars), and the way you want the tables to be sorted.  

With the blue-shaded section at the top you can modify the order of magnitude (single dollars, millions of dollars, billions of dollars), and the way you want the tables to be sorted.  

The sorting methods are:   

Changing the order of magnitude may be helpful if you are trying to fit big numbers into tables in Word. With the order of magnitude set to millions or billions, you may want to adjust the number of decimals. Do this in the ribbon:  [[File:Ribbondecimals.png|center|thumb|1300x1300px|Increase decimal]]The sorting methods are:   

# Default: activities will appear in the order in which they are entered on the Activities sheet  

# Default: activities will appear in the order in which they are entered on the Activities sheet

# Total Impact (↑): ascending order according to the total impact estimates (smallest first)  

# Total Impact (↑): ascending order according to the total impact estimates (smallest first)

# Total Impact (↓): descending order according to the total impact estimates (biggest first)  

# Total Impact (↓): descending order according to the total impact estimates (biggest first)

# Administrative then Compliance  

# Administrative then Compliance

# Compliance then Administrative  

# Compliance then Administrative

# Activity (↑az): ascending order according to the name of each activity (a first)  

# Activity (↑az): ascending order according to the name of each activity (a first)

# Activity (↓za): descending order according to the name of each activity (z first)  

# Activity (↓za): descending order according to the name of each activity (z first)

==== Annual Impact ====

==== Annual Impact ====

'''Group tables by:''' by default this is set to "Discounting", meaning that it will first produce the Discounted Costs, Discounted Benefits and Discounted Net Impacts, then the Undiscounted Costs, Undiscounted Benefits, and Undiscounted Net Impacts. Changing this to "Costs | Benefits | Net" means that the output will look like: Discounted Costs, Undiscounted Costs, then Discounted Benefits, Undiscounted Benefits, then Discounted Net, Undiscounted Net.

'''Group tables by:''' by default this is set to "Discounting", meaning that it will first produce the Discounted Costs, Discounted Benefits and Discounted Net Impacts, then the Undiscounted Costs, Undiscounted Benefits, and Undiscounted Net Impacts. Changing this to "Costs | Benefits | Net" means that the output will look like: Discounted Costs, Undiscounted Costs, then Discounted Benefits, Undiscounted Benefits, then 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:

'''Order of magnitude:''' this lets you change from single dollars, to millions of dollars or billions of dollars.

 

'''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 ====