Example: Add years by copying data from the same alternative
The plan has two alternatives: Alternative 1 and Alternative 2. Each alternative contains two years: 2019 and 2020
Alternative 1 | Alternative 2 | Alternative 1 | Alternative 2 |
|---|---|---|---|
2019 | 2020 | 2019 | 2020 |
$100 | $150 | $500 | $600 |
Assume you want to add one new year to each alternative, and you want the data in these new years to be copied from the year 2020 in the alternative to which they are being added.
- ChooseEdit,Plan Years, andAddto open theAdd Year(s)window.
- In the#Years to be addedfield, enter1.
- From theCopy data from alternativefield, selectSame alternative.
- From theCopy data from yearfield, select2020.
- SelectOK.
- The year 2021 is added to each alternative.
Alternative 1 | Alternative 2 | Alternative | Alternative | Alternative | Alternative |
|---|---|---|---|---|---|
2019 | 2020 | 2021 | 2019 | 2020 | 2021 |
$100 | $150 | $150 | $500 | $600 | $600 |
- The 2019 column in Alternative 1 contains data copied from the 2020 column in Alternative 1.
- The 2019 column in Alternative 2 contains data copied from the 2020 column in Alternative 2.