Referencing rows and columns

XERAS uses a row.column syntax when referencing a cell within the current spreadsheet. In XERAS, all rows and columns must be labelled with a row code and column code respectively, to enable referencing to a cell within that row or column. In the example spreadsheet below, the following row and column referencing is required to link to the matching cells.

Example	Explanation
Sx01_Rate.CostDriver	Returns the text string Anfo_Waste from the CostDriver column on the Explosive - ANFO row.
Sx03_Rate.ConsCode	Returns the text string Price09 from the ConsCode column on the Explosive - Emulsion row.
Sx04_Rate.ConsRate	Returns the value 0.05 from the ConsRate column on the Boosters row.