Sheets provide the interface to view and enter data in the model. They are akin to the concept of tabs within an Excel file. Assumptions are a key piece of any driver-based financial model. Any number that may need to be flexed and upon which a formula or model relies could be considered an assumption or driver.

Assumptions

1. Assumptions within Workday Planning’s native assumptions accounts are global in nature, meaning they are the same across all levels.
2. Changing the value of those drivers in one place changes the value across all areas of the model, simplifying the user experience and enabling faster testing and analysis.
3. The following table highlights:
   1. Models in which assumptions are used
   2. Sheets and groups in which assumptions reside
   3. Types of assumption accounts used
   4. How the assumption is used in that model

Assumption	Model Used	Sheet Location	Assumption Type	Use
Days in Month	Compensation	All Assumptions	Global Assumption	Partial Month Logic
Days in Year	Compensation	All Assumptions	Global Assumption	Partial Month Logic
Pay Periods	Compensation	All Assumptions	Global Assumption	Monthly Personnel Calculations
Base Salary Increase Rate	Compensation	Cubed Assumption Sheet	Global Assumption	Calculate Base Salary Compensation Increase
Promotion Increase Rate	Compensation	Cubed Assumption Sheet	Global Assumption	Calculate Promotion Compensation Increase
Merit Increase Rate	Compensation	Cubed Assumption Sheet	Global Assumption	Calculate Merit Compensation Increase
Retention Bonus Increase Rate	Compensation	Cubed Assumption Sheet	Global Assumption	Calculate Retention Bonus Compensation Increase
Allowances Increase Rate	Compensation	Cubed Assumption Sheet	Global Assumption	Calculate Allowances Increase
Benefits Rate	Compensation	Cubed Assumption Sheet	Global Assumption	Calculate Benefits Increase

 

All Assumptions Sheet

1. How to access Compensation Assumptions Sheet:
   1. Navigation Menu > Assumptions > All Assumptions
2. The All Assumptions Sheet houses the global assumptions used in the following Compensation sheets:
   1. Base Salary
   2. Allowances
   3. Pooled

Sheet Design

1. The sheet’s rows are organized by Accounts and are in three main sections: Time, Payroll Taxes - Personnel and Other - Personnel.
2. Accounts are represented in rows

Version Selector

1. Versions fall into two categories within Workday Planning: Actuals and Working Budget.
   1. Actuals contain historical financial data.
2. To access the different All Assumptions versions, select the drop-down Versions list in the upper-right hand corner of the sheet.

Point-of-View Selector

1. You may change selectors and filters by selecting Display Options in the sheet’s toolbar.
    

1. 1. Here, you may change the time span or time view displayed by the sheet.
       
   2. After selecting Display Options, you have the view options of selecting time view and suppressing rows if all zeros or blank.
       

Use Sparklines

1. Sparklines offer a quick view of the trends associated with account values on cube sheets. When turned on, they appear in the first column of the sheet.
   1. From the navigation menu, select Sheets or Assumptions and the specific sheet you would like to open.
   2. Once a sheet is opened, select a Version/Level.
      1. Select Display Options.
          
      2. Select the Sparklines tab.
          
      3. Select the line/bar chart format, select OK.
          
      4. Select the cell with the chart for an expanded view of the sparkline
          

Add Cell Notes

1. Cell notes “stick” to the cross-section of time, accounts, levels, and versions.
2. Adding cell notes is a right-click function on a cell to Add or Edit Note.