Two Dimensional Rate Table with Ranges

A two dimensional rate table with ranges consists of:

Any number of columns, each with a type.
Any number of rows, each with a type.
Any number of cells, each with:
- a minimum value
- a maximum value
- a value

An example of a rate table of this type is given below:

Table 1. Two Dimensional Rate Table with Ranges
	Account Percentage (%)	New Employer (%)	Q Rate Employer (%)	G Rate Employer (%)
Normal Rate	0 : 1.5 1.6 : 3 3	1 1.5 1.6	2 2.1 2.2	4 4.1 4.2
Subsidiary Rate	0 : 1.5 1.6 : 3 3	2 2 2	4 4 4	8 8 8
RESF Rate	0 : 100	0.075	0.075	0.075

The above example illustrates the format used by the Cúram Reference Application to display minimum and maximum values for a cell. The minimum and maximum values for a cell are separated using a colon (':'), e.g. '0 : 1.5'. If in addition to a range, a value is also specified, the value is separated from the range using another colon character, e.g. '0 : 1.5 : 4'.

In the example above, the account percentage column is used to determine the rate appropriate for each different employer type, e.g. a Q Rate Employer with an account percentage value of 1.9%, will be charged 2.1% for the Normal Rate and 4% for the Subsidiary Rate.

The XML string for the whole of this rate table would look like this:

(CT1 implies Account Percentage %, RT1 implies Normal Rate, and so on)

<RATES_DATA>
<COLUMN  INDEX=1  ID=1  TYPE=CT1>
<ROW INDEX=1  ID =2  TYPE=RT1 NUM_SUB_ROWS=3>
<CELL ID=3 MINIMUM=0.0 MAXIMUM=1.5 COLUMN_INDEX=1/>
<CELL ID=4 MINIMUM=1.6 MAXIMUM=3.0 COLUMN_INDEX=2/>
<CELLID=5 VALUE=3.0  COLUMN_INDEX=3/>
</ROW>
<ROW INDEX=2  ID =6  TYPE=RT2 NUM_SUB_ROWS=3>
<CELL ID=7 MINIMUM=0.0 MAXIMUM=1.5 COLUMN_INDEX=1/>
<CELL ID=8 MINIMUM=1.6 MAXIMUM=3.0 COLUMN_INDEX=2/>
<CELL ID=9 VALUE=3.0  COLUMN_INDEX=3/>
</ROW>
<ROW INDEX=3  ID =10  TYPE=RT3>
<CELL ID=11 MINIMUM=0.0 MAXIMUM=100.0 COLUMN_INDEX=3/>
</ROW>
</COLUMN>
<COLUMN  INDEX=2  ID=12 TYPE=CT2>
<ROW INDEX=1  ID =2  TYPE=RT1 NUM_SUB_ROWS=3>
<CELL ID=13  VALUE=1  COLUMN_INDEX=1/>
<CELL ID=14  VALUE=1.5  COLUMN_INDEX=2/>
<CELL ID=15  VALUE=1.6  COLUMN_INDEX=3/>
</ROW>
<ROW INDEX=2  ID =6  TYPE=RT2 NUM_SUB_ROWS=3>>
<CELL ID=16  VALUE=2  COLUMN_INDEX=1/>
<CELL ID=17  VALUE=2  COLUMN_INDEX=2/>
<CELL ID=18  VALUE=2  COLUMN_INDEX=3/>
</ROW>
<ROW INDEX=3  ID =10  TYPE=RT3>
<CELL ID=19  VALUE=0.075  COLUMN_INDEX=3/>
</ROW>
</COLUMN>
<COLUMN  INDEX=3  ID=20 TYPE=CT3>
<ROW INDEX=1  ID =2  TYPE=RT1 NUM_SUB_ROWS=3>
<CELL ID=21  VALUE=2  COLUMN_INDEX=1/>
<CELL ID=22  VALUE=2.1  COLUMN_INDEX=2/>
<CELL ID=23  VALUE=2.2  COLUMN_INDEX=3/>
</ROW>
<ROW INDEX=2  ID =6  TYPE=RT2 NUM_SUB_ROWS=3>>
<CELL ID=24  VALUE=4  COLUMN_INDEX=1/>
<CELL ID=25  VALUE=4  COLUMN_INDEX=2/>
<CELL ID=26  VALUE=4  COLUMN_INDEX=3/>
</ROW>
<ROW INDEX=3  ID =10  TYPE=RT3>
CELL ID=27 VALUE=0.075  COLUMN_INDEX=3/>
</ROW>
</COLUMN>
</COLUMN>
<COLUMN  INDEX=4  ID=28 TYPE=CT4>
<ROW INDEX=1  ID =2  TYPE=RT1 NUM_SUB_ROWS=3>
<CELL ID=29  VALUE=4  COLUMN_INDEX=1/>
<CELL ID=30  VALUE=4.1  COLUMN_INDEX=2/>
<CELL ID=31  VALUE=4.2  COLUMN_INDEX=3/>
</ROW>
<ROW INDEX=2  ID =6  TYPE=RT2 NUM_SUB_ROWS=3>>
<CELL ID=32  VALUE=8  COLUMN_INDEX=1/>
<CELL ID=33  VALUE=8  COLUMN_INDEX=2/>
<CELL ID=34  VALUE=8  COLUMN_INDEX=3/>
</ROW>
<ROW INDEX=3  ID =10  TYPE=RT3>
<CELL ID=35 VALUE=0.075  COLUMN_INDEX=3/>
</ROW>
</COLUMN>
</RATES_DATA>