STEM help / Exchanging data

6.3.6 External defaults for Capital Cost Structure in Excel

The same potential issue arises for Capital Cost Structure data, where there is a Proportion for each Cost Index. However, since this is the only field, it would be very cumbersome to have two separate rows for each Cost Index and Proportion, so a simpler and more compact layout is used, as shown below.

Sample spreadsheet layout for Capital Cost Structure

Again these labels are the full labels, which should be used when embedded in a set of defaults for a whole Resource. If you want to link the Capital Cost Structure data directly, through a formula on the Capital Cost Structure button – move up from a Capital Cost Structure dialog – then shorter labels should be used, without the initial CapitalCostStructure. prefix.

 

© Implied Logic Limited