136
edits
Changes
mLine 233:
Line 233: + + + + +
→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 (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]]
[[File:Duplicate3.png|center|thumb|1300x1300px|Another method: step 1]]
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]]
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.