Hello world. I'd appreciate some help as I'm really not sure how to solve this complex problem in an efficient manner.
I need to find a fast way to price potentially hundreds of items. I know that loops will be the slowest thing in the world because of the sheer number of things that EACH ITEM must be parsed through. You'll know what I mean when I break down how complex this is. Thanks for your help in advance; I'm quite stumped.
Let's begin.
I'm am trying to write a macro that prices items in a quote.
Each item is priced based upon its weight (lbs) and thickness (inches). (certain ranges of thicknesses are more expensive than others)
A sample item is: (made up values)
<tbody>
</tbody>
Here is a sample pricing structure for just one grade (44w) (prices made up)
Note: I know this is an inefficient structure for a table (it's more for visual means), but I'm not sure how to go about making it more efficient though.
44w:
<colgroup><col span="6"><col><col></colgroup><tbody>
</tbody>
How we price things is, first, you find which grade the item is (There are many more 'grade' tables like this, each with their own prices AND different "THRU" ranges). Then, you find which thickness column it lines up with, and then you match it to the criteria it meets (which price bracket or other criteria), and then where they intersect is the price we use.
I can't make all prices in one column based off one another either (% up and down).
I know this is a lot of work, even if someone could point me in the right direction that would be great. It's just such a monster problem that I feel stumped and I don't know how to make this actually usable (fast).
Thanks for your help.
I need to find a fast way to price potentially hundreds of items. I know that loops will be the slowest thing in the world because of the sheer number of things that EACH ITEM must be parsed through. You'll know what I mean when I break down how complex this is. Thanks for your help in advance; I'm quite stumped.
Let's begin.
I'm am trying to write a macro that prices items in a quote.
Each item is priced based upon its weight (lbs) and thickness (inches). (certain ranges of thicknesses are more expensive than others)
A sample item is: (made up values)
| Mark # | Grade | Pieces | Thickness | W | L | Weight |
| 43431 | 44w | 10 | 0.5 | 22 | 100 | 250 |
<tbody>
</tbody>
Here is a sample pricing structure for just one grade (44w) (prices made up)
Note: I know this is an inefficient structure for a table (it's more for visual means), but I'm not sure how to go about making it more efficient though.
44w:
| If Other similar Grade, Add | -> | $ 5 | 0.375 | .625 | 1.25 | 2.125 | |
| THRU | THRU | THRU | THRU | ||||
| 0.1875 | .25 | 0.3125 | .5 | 1 | 2 | 3 | |
| Critera 1 | $10 | $12 | $16 | $13 | $11 | $8 | $4 |
| Criteria 2 | $12 | $14 | $20 | $15 | $13 | $10 | $7 |
| Low bracket | $14 | $17 | $24 | $17 | $16 | $12 | $10 |
| High Bracket | $16 | $21 | $28 | $20 | $19 | $15 | $12 |
<colgroup><col span="6"><col><col></colgroup><tbody>
</tbody>
How we price things is, first, you find which grade the item is (There are many more 'grade' tables like this, each with their own prices AND different "THRU" ranges). Then, you find which thickness column it lines up with, and then you match it to the criteria it meets (which price bracket or other criteria), and then where they intersect is the price we use.
I can't make all prices in one column based off one another either (% up and down).
I know this is a lot of work, even if someone could point me in the right direction that would be great. It's just such a monster problem that I feel stumped and I don't know how to make this actually usable (fast).
Thanks for your help.
