Commission Calculator using Points System

[Lustful Salmon]

Good Morning,

I am trying to create a commission calculator for a point system incentive plan similar to the plan found here.

Incentive Points Plan</SPAN>
Product</SPAN>	Pricing</SPAN>	Base Pts</SPAN>	Comp Conv</SPAN>	Comp Conv Over</SPAN>	Upgrade</SPAN>
Quart</SPAN>	$64,000</SPAN>	4</SPAN>	4</SPAN>	6</SPAN>	1</SPAN>
Quart Tier 1</SPAN>	$60,000</SPAN>	3</SPAN>	3</SPAN>	5</SPAN>	1</SPAN>
Quart Tier 2</SPAN>	$54,000</SPAN>	2</SPAN>	2</SPAN>	4</SPAN>	1 </SPAN>

<TBODY>
</TBODY><COLGROUP><COL span=2><COL><COL><COL><COL></COLGROUP>

Here is an example of how the calculator should work based on the sales examples provided...see the Points rewarded.

Sales Examples with Points</SPAN>	Points Rewarded</SPAN>
Invoiced Qty</SPAN>	Item Group</SPAN>	Program</SPAN>	Net Price</SPAN>	Base Pts</SPAN>	Comp Conv</SPAN>	Comp Conv Over</SPAN>	Upgrade</SPAN>	Total Pts</SPAN>
1</SPAN>	Quart</SPAN>	Rollover</SPAN>	$54,000</SPAN>	2</SPAN>	0</SPAN>	0</SPAN>	0</SPAN>	2</SPAN>
1</SPAN>	Quart</SPAN>	Upgrade</SPAN>	$64,000</SPAN>	4</SPAN>	0</SPAN>	0</SPAN>	1</SPAN>	5</SPAN>
2</SPAN>	Quart</SPAN>	Comp Conv</SPAN>	$140,000</SPAN>	8</SPAN>	4</SPAN>	0</SPAN>	0</SPAN>	12</SPAN>
3</SPAN>	Quart</SPAN>	Comp Conv Over</SPAN>	$250,000</SPAN>	12</SPAN>	0</SPAN>	6</SPAN>	0</SPAN>	18</SPAN>

<TBODY>
</TBODY><COLGROUP><COL span=2><COL><COL><COL><COL span=4></COLGROUP>

How do I set up formulas that will allow me to populate my "Points Rewarded" section while tying up the incentive plan criteria to the sales examples found here?

	A	B	C	D	E	F	G	H	I
1	Product	Pricing	Base Pts	Comp Conv	Comp Conv Over	Upgrade
2	Quart	$64,000	4	4	6	1
3	Quart T1	$60,000	3	3	5	1
4	Quart T2	$54,000	2	2	4	1
5	Invoiced Qty</SPAN>	Item Group	Program	Net Price</SPAN>	Base Pts</SPAN>	Comp Conv	Comp Conv Over	Upgrade	Total Pts
6	1	Quart	Rollover	$54,000
7	1	Quart	Upgrade	$64,000
8	2	Quart	Comp Conv	$150,000
9	3	Quart	Comp Conv Over	$250,000

<TBODY>
</TBODY>

Thank you in advance for any help or suggestions in helping work out how to formulate this table...