DAVION

SYSTEMS

Spreadsheet Usage

 

If you are using your own spreadsheet with the Monte Carlo Formula Generator, you will need to tell the software what kind of data you have and where it is located on the spreadsheet. The Spreadsheet Usage frame lets you do this.

 

Data Mode

Your data can be in either base+contingency format (2-point data) or in mid/high/low format (3-point data). Choose the appropriate option for your data.

 

Contingency or Variance Type

Contingencies (in base+contingency mode) or variances (in mid/high/low mode) can be defined in terms of an incremental amount, e.g. $1000 plus $100 contingency, or as a total amount, e.g. $1000 base cost, $1100 total cost. Choose the appropriate option for your data.

 

Contingency or Variance Format

Contingencies (in base+contingency mode) or variances (in mid/high/low mode) can be defined as percentages, e.g. $1000 + 10%, or as actual amounts, e.g. $1000 + $100. Choose the appropriate format for your data.

N.B. If your data is in percentage mode, it does not matter if the percentages have been entered as actual percentage values (e.g. 10 entered for 10%), or entered as decimal fractions and then formatted as percentages (e.g. 0.1 formatted as 10%). Mandrel will determine the format you have used.

 

Data Columns

In base+contingency mode you must have a column containing base amounts and another column containing contingency amounts.

In mid/high/low mode you must have three data columns, for mid-range, high-range, and low-range values respectively.

You can also have up to two columns containing identifying data for each cost item, such as cost number and cost name. However, these are optional.

 

Data Rows

You must indicate the first and last rows between which numeric data occurs.

Mandrel will ignore any blank or non-numeric rows in this range. Do not include any total or subtotal row(s) at the end of this range.