A spread lookup translates entered text or a selected dimension from a row of the input sheet into values spread over time. These spread values can be used to generate values into one account based on another account.
Some example uses of spread lookups.
- Capital Depreciation: Each asset row is associated with a depreciation method, which determines how an asset value entered in the current time period is spread into depreciation expense in future time period(s).
- Sales Revenue Recognition: Each sales row is associated with a revenue recognition method, which determines how a sales value entered in the current time period is spread into revenue in future time period(s).
- Sales Invoicing: Each sales row is associated with an invoicing method, which determines how a sales value entered in the current time period is spread intoaccounts receivable in future time period(s).
To edit a spread lookup for a modeled sheet:
You can edit a spread lookup from a modeled sheet's summary page. Click Spread Lookups on Sheet Summary. Or, you can edit lookups directly within the model sheet builder.
Navigate to: Modeling > Model Management.
Select a sheet type (Level Assigned Sheets or User Assigned Sheets), then click to open the sheet.
From Sheet Summary, click Columns and Levels.
Select a custom Dimension or Text Selector in the sheet builder. (center pane).
In Properties (right pane), open the expander for Spread Lookups.
Find the spread lookup and click Edit .
Enter the Spread (Months). Use a whole number greater than 0.
Enter the Spread Expression, which is a range and a fraction like A:B=n/d,C:D=n/d where A and C are start month numbers, B and D are end month numbers. The spread proportion is n/d and can be entered as a fraction like 1/40, or as number like .025.
The Spread Expression input area does not accept thousands separators in values. Only one range is required. Separate each range by the locale specific separator (either , or ; depending on your locale).
Example Spread Expressions
Description Spread(Months) Spread Expression
A quarterly spread over the course of a year.
A spread over every other month in a year.
A sales ramp up to reach 100% of quota within the first year of 5 years. A newly hired sales person must sell 10% of their quota the first quarter, 50% the second quarter, 75% the third quarter, and 100% by the fourth quarter.
When you've finished making changes, click Save .
You can associate more than one lookup to a text selector or dimension element. For example, a text selector element called Employee Type has options for Officer, Vice President, Director, Manager, Staff. You can associate this element with one monthly lookup to calculate the bonus expense and another lookup to calculate auto parking expenses.