136
edits
Changes
mLine 227:
Line 227: − + − + − − 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 (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]]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. − − [[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]] − − [[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)]] + Line 270:
Line 258: − |+ Line 306:
Line 293: − − −
→Affected Stakeholder Group
====== Affected Stakeholder Group ======
====== Affected Stakeholder Group ======
All Activities must have an affected stakeholder group. The affected stakeholder group is one of the groups listed on your stakeholder profile sheet.
All Activities must have an affected stakeholder group. The affected stakeholder group must be one of the groups listed on your stakeholder profile sheet. If you select a particular stakeholder group on the Activities sheet and then modify its group name on the Stakeholders sheet, you will have to re-select the 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.
If the Calculator is being used to calculate impacts for government, then a Government stakeholder group should be created with a Non-Business Count equal to one.
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 (when sorting impacts "By Stakeholder Group"). Alternatively, sometimes you may want to apply an activity to all stakeholders and see a distinct row for each one on the Activities tab. Having a distinct row for the same activity applied to each stakeholder group may be necessary if different stakeholders would incur different impacts to conduct the activity (e.g., the different groups may have different baseline compliance rates).
====== Affected Stakeholder Type ======
====== Affected Stakeholder Type ======
The stakeholder type, specifying whether it applies to businesses, non-businesses, small businesses, or large businesses.
The stakeholder type, specifying whether it applies to businesses, non-businesses, small businesses, or large businesses.
====== Combinations of Apply to Existing Stakeholders and Apply to New Entrants ======
====== Combinations of Apply to Existing Stakeholders and Apply to New Entrants ======
{| class="wikitable"
{| class="wikitable"
!Apply to Existing Stakeholders
!Apply to Existing Stakeholders
!Apply to New Entrants
!Apply to New Entrants
====== Capital: Unit Price ======
====== Capital: Unit Price ======
This is the price of one unit.
This is the price of one unit.
====== Capital: Price Year of Unit Price ======
====== Capital: Price Year of Unit Price ======
On the Initiative sheet you entered the Price Year to be used in the analysis, which is an important aspect of the units of measurement. If the unit price info was pulled from an older document, then the price may not align with the Price Year on the Initiative sheet. This is normal, but you just need to specify the price year for the unit price information. The RCC will then automatically convert this value to 2012 prices for the one-for-one rule (if applicable), and to the price year selected on the Initiative sheet everywhere else.
On the Initiative sheet you entered the Price Year to be used in the analysis, which is an important aspect of the units of measurement. If the unit price info was pulled from an older document, then the price may not align with the Price Year on the Initiative sheet. This is normal, but you just need to specify the price year for the unit price information. The RCC will then automatically convert this value to 2012 prices for the one-for-one rule (if applicable), and to the price year selected on the Initiative sheet everywhere else.