136
edits
Changes
mLine 226:
Line 226: − +
→Affected Stakeholder Group
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. Alternatively, after selecting a completed activity, you can manually type stakeholder groups directly into the formula (each group must be separated by a comma). 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, or you can click over to the Stakeholders sheet and select multiple group names while holding Ctrl on your keyboard. Alternatively, after selecting a completed activity, you can manually type stakeholder groups directly into the formula (each group must be separated by a comma). 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]]
[[File:Image11111111111111111111111.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.
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.