Section 7: Modeling Basics

Last edited 479 days ago by Makiel [Muh-Keel].

Spreadsheet Models

Every good spreadsheet model will have three common elements: changeable inputs, outputs, and intermediate calculations.

⁠

Changeable Inputs

The changeable inputs to this model can be found in the customer information section. These are the elements of the model that the user will change every time a new application is processed.

In general, inputs are placed at the top of a model or another place where they would be easy for the user to spot and modify.

Model Outputs

Model Outputs represent the outcome of the process that is modeled in the spreadsheet. Outputs need not be a single calculation or recommendation, but they are the end-state of the model.

Often, model outputs are placed at the bottom of the spreadsheet model because most people work in a top-down manner for completing a calculation

Intermediate Calculations

As the name implies, the “Intermediate Calculations” section of a spreadsheet model comprises the area of the worksheet where the logical steps required to complete the process are modeled.

The number and sophistication of the intermediate calculations for a complex spreadsheet model can be quite significant and can span multiple worksheets.

It is in the intermediate calculations that the nuances of the process can be modeled effectively

Spreadsheet Models

Changeable Inputs

Model Outputs

Intermediate Calculations

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.