136
edits
Important: The GCConnex decommission will not affect GCCollab or GCWiki. Thank you and happy collaborating!
Changes
Jump to navigation
Jump to search
mLine 218:
Line 218: − + + + + + + + + + + +
→Affected Stakeholder Group
====== 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 All Groups. 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.
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.
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.
[[File:Applytoall.png|center|thumb|1500x1500px|APPLYTOALL]]
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, 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:Image111111111111.png|center|thumb|1500x1500px|APPLYTOMANY]]
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.
====== Affected Stakeholder Type ======
====== Affected Stakeholder Type ======
