Hello everyone,
Needing some assistance on creating a graph that will calculate a priced based on a board dimensions (height x width), but the graph is base on in-between lengths (see below)
I found this link but, not quite what im after, any help would be great https://www.mrexcel.com/forum/excel-questions/562186-auto-calculate-price-based-width-x-height.html
<tbody>
</tbody>
<tbody>
</tbody>
Needing some assistance on creating a graph that will calculate a priced based on a board dimensions (height x width), but the graph is base on in-between lengths (see below)
I found this link but, not quite what im after, any help would be great https://www.mrexcel.com/forum/excel-questions/562186-auto-calculate-price-based-width-x-height.html
Board Dimensions | |||||||||||||
Height (mm) | Width (mm) | Price $ | |||||||||||
400 | 150 | #N/A | |||||||||||
WIDTH (mm) | |||||||||||||
35 - 150 | 151 - 300 | 301 - 350 | 351 - 400 | 401 - 450 | 451 - 500 | 501 - 550 | 551 - 600 | 601 - 650 | 651 - 800 | 801 - 1000 | 1001 - 1200 | ||
HEIGHT (mm) | 32 -200 | $15.87 | $18.72 | $19.66 | $20.63 | $21.58 | $22.53 | $23.48 | $24.44 | $25.37 | $28.23 | $32.03 | $35.83 |
201 - 400 | $18.95 | $24.00 | $25.68 | $27.36 | $29.05 | $30.74 | $32.40 | $34.09 | $35.76 | $40.82 | $47.56 | $54.26 | |
401 - 600 | $22.01 | $29.26 | $31.67 | $34.09 | $36.49 | $38.91 | $41.34 | $43.73 | $46.16 | $53.42 | $63.05 | $72.71 | |
601 - 750 | $24.31 | $33.21 | $36.16 | $39.15 | $42.10 | $45.04 | $48.02 | $50.97 | $53.95 | $62.83 | $74.68 | $86.54 | |
751 - 900 | $26.64 | $37.16 | $40.65 | $44.20 | $47.69 | $51.22 | $54.71 | $58.24 | $61.74 | $72.28 | $86.31 | $100.35 | |
901 - 1200 | $31.24 | $45.04 | $49.68 | $54.26 | $58.87 | $63.50 | $68.11 | $72.71 | $77.31 | $91.16 | $109.58 | $128.02 | |
1201- 1500 | $35.83 | $52.96 | $58.67 | $64.36 | $70.06 | $75.78 | $81.47 | $87.20 | $92.90 | $110.01 | $132.83 | $155.66 | |
1501 - 1800 | $40.46 | $60.86 | $67.67 | $74.46 | $81.28 | $88.08 | $94.87 | $101.68 | $108.49 | $128.89 | $156.10 | $213.52 | |
1801 - 2100 | $45.04 | $68.76 | $76.64 | $84.56 | $92.46 | $100.35 | $108.25 | $116.16 | $124.06 | $147.76 | $179.34 | $243.93 | |
2101 - 2400 | $49.68 | $76.64 | $85.68 | $94.65 | $103.64 | $112.64 | $121.64 | $130.65 | $139.64 | $166.61 | $202.62 | $274.34 | |
2401 - 2700 | $57.07 | $89.08 | $99.80 | $110.45 | $121.14 | $131.82 | $142.48 | $153.18 | $163.84 | $195.88 | $238.61 | $317.05 | |
2701 - 3050 | $67.53 | $106.78 | $119.91 | $132.98 | $146.07 | $159.18 | $172.27 | $185.36 | $198.45 | $237.73 | $290.10 | $378.21 |
<tbody>
</tbody>
<tbody>
</tbody>