Changes

====== Affected Stakeholder Group ======

====== Affected Stakeholder Group ======

The affected stakeholder group is one of the groups listed on your stakeholder profile sheet. Users can select a specific group from the dropdown list or select "All Groups." Selecting "All Groups" will apply the activity to each group entered on the Stakeholders sheet, and the impacts will be disaggregated appropriately on the yellow output sheets. 

All Activities must have an affected stakeholder group. The affected stakeholder group is one of the groups listed on your stakeholder profile sheet.  

Alternatively, sometimes you may want to apply an activity to all stakeholders and see a distinct row for each one on the Activities tab. Depending on the number of stakeholder groups this can be time consuming to do manually. To make this process easier there are two new custom formulas in the RCC: APPLYTOALL and APPLYTOMANY.   

 

Users can select a specific group from the dropdown list or select "All Groups." Selecting "All Groups" will apply the activity to each group entered on the Stakeholders sheet, and the impacts will be disaggregated appropriately on the yellow output sheets. Alternatively, sometimes you may want to apply an activity to all stakeholders and see a distinct row for each one on the Activities tab. Depending on the number of stakeholder groups this can be time consuming to do manually. To make this process easier there are two new custom formulas in the RCC: APPLYTOALL and APPLYTOMANY.   

To use APPLYTOALL, type this as you would any other formula, and select any row that you've already filled out in the activities table. The formula will then duplicate the entries and cycle through all remaining stakeholder groups on the Stakeholders sheet. The next step is to copy-paste (as values!) into the table. The table will automatically expand to include the new rows. After this is done you will be able to make any tweaks, for instance if some stakeholder groups have different costs or percentages affected.   

To use APPLYTOALL, type this as you would any other formula, and select any row that you've already filled out in the activities table. The formula will then duplicate the entries and cycle through all remaining stakeholder groups on the Stakeholders sheet. The next step is to copy-paste (as values!) into the table. The table will automatically expand to include the new rows. After this is done you will be able to make any tweaks, for instance if some stakeholder groups have different costs or percentages affected.   

APPLYTOMANY is similar but you have to select a completed activity AND other stakeholder group(s). Other stakeholder groups can be entered manually in the formula (separate each group with a comma), or you can click over to the Stakeholders sheet and select multiple group names while holding Ctrl on your keyboard. The output will be a duplication of the selected activity for as many stakeholder groups as you want. As with APPLYTOALL, this output will then need to be copy-pasted (as values!) into the table. Unfortunately this has to be done in 2 steps using copy-paste due to the constraints associated with Tables in Excel.   

APPLYTOMANY is similar but you have to select a completed activity AND other stakeholder group(s). Other stakeholder groups can be entered manually in the formula (separate each group with a comma), or you can click over to the Stakeholders sheet and select multiple group names while holding Ctrl on your keyboard. The output will be a duplication of the selected activity for as many stakeholder groups as you want. As with APPLYTOALL, this output will then need to be copy-pasted (as values!) into the table. Unfortunately this has to be done in 2 steps using copy-paste due to the constraints associated with Tables in Excel.   

[[File:Image11111111111111111111111.png|center|thumb|1500x1500px|APPLYTOMANY]]

[[File:Image11111111111111111111111.png|center|thumb|1500x1500px|APPLYTOMANY]]Instead of using the custom functions described above, you can highlight all columns in one row of the table up to and including Labour: Staff Level (Hourly Wage Without Overhead) (i.e., columns B to T, inclusive), and then copy-paste values directly below the bottom entry. Then you can override the Affected Stakeholder Group by Copy-pasting from the Stakeholder Group column on the input table on the Stakeholders sheet.

 

Instead of using the custom functions described above, you can highlight all columns of a table up to and including Labour: Staff Level (Hourly Wage Without Overhead) (i.e., columns B to T, inclusive), and then copy-paste values directly below the bottom entry. Then you can override the Affected Stakeholder Group by Copy-pasting from the Stakeholder Group column on the input table on the Stakeholders sheet.  

[[File:Duplicate4.png|center|thumb|1300x1300px|Another method: step 2]]

[[File:Duplicate3.png|center|thumb|1300x1300px|Another method: step 1: copy the row you want to duplicate, then select a number of rows beneath the table corresponding to the number of times you want to duplicate the activity]]

[[File:Duplicate999.png|center|thumb|1300x1300px|Another method: step 2: paste the activity into the selected area]]  

All Activities must have an affected stakeholder group. If the Calculator is being used to calculate impacts for government, then a Government stakeholder group should be create with a Non-Business count equal to one.

[[File:Duplicate4.png|center|thumb|1300x1300px|Another method: step 3: override the Affected Stakeholder Group column (and any other columns that you want to change)]] 

====== Affected Stakeholder Type ======

====== Affected Stakeholder Type ======