Create Personal Scenarios
Security:
- Version Access Control: Any exceptHidden. See Lock or Hide Versions with Version Access Controls.
- Permission:Create Scenarios.
Scenarios enable you to draft changes to versions before you commit them to the working version. Scenarios are based on existing versions, which we call base versions. You can later merge your changes into the base version when you’re ready. Only you can review that data in your scenarios from sheets, reports, and dashboards.
Once you create the scenario, only you can select it from any version selector in sheets, reports, and dashboards. Scenarios have a distinct icon that differentiates them from other plan versions.
After you update the data in scenarios, we highlight data in the scenario that differs from the base version from your sheet view. You can create web reports, OfficeConnect reports, and dashboards to analyze your scenario against other versions, including the base version.
Duplicate scenarios start with all the same data as the original scenario. You can make changes to either the original or the duplicate scenario without affecting the other.
- SelectScenariosfrom the main menu.
- ClickAdd New.Or hover over an existing scenario. Click the 3 dots that display and selectDuplicate.
- As you complete the task, consider:
Option Description Base VersionSelect the plan version. The scenario starts with the base version data until you change the data. Later, when you merge the scenario, you update the base version with the data in your scenario.You can’t select virtual versions or actuals or versions with the Calculate Formulas Values option enabled.When you're duplicating a scenario, this option doesn't display because you can't change the base version.Scenario NameEnter a unique name that doesn’t match any scenarios for the same base version. Maximum: 64 characters.DescriptionMaximum: 2,048 characters. - ClickCreate.
The scenario name displays in the scenario list. It also displays in the version prompt, nested under the base version for you only.
- Make changes to the data in sheets.
- (Optional) Build reports and charts to analyze your changes.
- (Optional) Download and Review Scenario Changes.
- (Optional) Merge Personal Scenarios into Base Versions. Merging updates the base version with the changes you made in the scenario and deletes the scenario.