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.

[TABLE="width: 599"]
<TBODY>[TR]
[TD="colspan: 6"]Incentive Points Plan</SPAN>[/TD]
[/TR]
[TR]
[TD]Product</SPAN>[/TD]
[TD]Pricing</SPAN>[/TD]
[TD]Base Pts</SPAN>[/TD]
[TD]Comp Conv</SPAN>[/TD]
[TD]Comp Conv Over</SPAN>[/TD]
[TD] Upgrade</SPAN>[/TD]
[/TR]
[TR]
[TD]Quart</SPAN>[/TD]
[TD]$64,000</SPAN>[/TD]
[TD]4</SPAN>[/TD]
[TD]4</SPAN>[/TD]
[TD]6</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[/TR]
[TR]
[TD]Quart Tier 1</SPAN>[/TD]
[TD]$60,000</SPAN>[/TD]
[TD]3</SPAN>[/TD]
[TD]3</SPAN>[/TD]
[TD]5</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[/TR]
[TR]
[TD]Quart Tier 2</SPAN>[/TD]
[TD]$54,000</SPAN>[/TD]
[TD]2</SPAN>[/TD]
[TD]2</SPAN>[/TD]
[TD]4</SPAN>[/TD]
[TD]1
</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL span=2><COL><COL><COL><COL></COLGROUP>[/TABLE]


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

[TABLE="width: 791"]
<TBODY>[TR]
[TD="colspan: 4"]Sales Examples with Points</SPAN>[/TD]
[TD="colspan: 5"]Points Rewarded</SPAN>[/TD]
[/TR]
[TR]
[TD]Invoiced Qty</SPAN>[/TD]
[TD]Item Group</SPAN>[/TD]
[TD]Program</SPAN>[/TD]
[TD]Net Price</SPAN>[/TD]
[TD]Base Pts</SPAN>[/TD]
[TD]Comp Conv</SPAN>[/TD]
[TD]Comp Conv Over</SPAN>[/TD]
[TD]Upgrade</SPAN>[/TD]
[TD]Total Pts</SPAN>[/TD]
[/TR]
[TR]
[TD]1</SPAN>[/TD]
[TD]Quart</SPAN>[/TD]
[TD]Rollover</SPAN>[/TD]
[TD]$54,000</SPAN>[/TD]
[TD]2</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]2</SPAN>[/TD]
[/TR]
[TR]
[TD]1</SPAN>[/TD]
[TD]Quart</SPAN>[/TD]
[TD]Upgrade</SPAN>[/TD]
[TD]$64,000</SPAN>[/TD]
[TD]4</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]1</SPAN>[/TD]
[TD]5</SPAN>[/TD]
[/TR]
[TR]
[TD]2</SPAN>[/TD]
[TD]Quart</SPAN>[/TD]
[TD]Comp Conv</SPAN>[/TD]
[TD]$140,000</SPAN>[/TD]
[TD]8</SPAN>[/TD]
[TD]4</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]12</SPAN>[/TD]
[/TR]
[TR]
[TD]3</SPAN>[/TD]
[TD]Quart</SPAN>[/TD]
[TD]Comp Conv Over</SPAN>[/TD]
[TD]$250,000</SPAN>[/TD]
[TD]12</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]6</SPAN>[/TD]
[TD]0</SPAN>[/TD]
[TD]18</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL span=2><COL><COL><COL><COL span=4></COLGROUP>[/TABLE]


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?
[TABLE="width: 500"]
<TBODY>[TR]
[TD][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Product[/TD]
[TD]Pricing[/TD]
[TD]Base Pts[/TD]
[TD]Comp Conv[/TD]
[TD]Comp Conv Over[/TD]
[TD]Upgrade[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Quart[/TD]
[TD]$64,000[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD]6[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Quart T1[/TD]
[TD]$60,000[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Quart T2[/TD]
[TD]$54,000[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Invoiced Qty</SPAN>[/TD]
[TD]Item Group[/TD]
[TD]Program[/TD]
[TD]Net Price</SPAN>[/TD]
[TD]Base Pts</SPAN>[/TD]
[TD]Comp Conv[/TD]
[TD]Comp Conv Over[/TD]
[TD]Upgrade[/TD]
[TD]Total Pts[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]1[/TD]
[TD]Quart[/TD]
[TD]Rollover[/TD]
[TD]$54,000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]1[/TD]
[TD]Quart[/TD]
[TD]Upgrade[/TD]
[TD]$64,000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]2[/TD]
[TD]Quart[/TD]
[TD]Comp Conv[/TD]
[TD]$150,000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]3[/TD]
[TD]Quart[/TD]
[TD]Comp Conv Over[/TD]
[TD]$250,000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]

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