Help with a formula to work out average difference in cost

[Biskit]

Huomenta from Finland!

I have a web shop where I sell a material, but charge different price per metre depending on the work carried out. At the moment I have each product in a different category, but I'd like to have them in one category to make it easier for the visitors on my site. I've tried working out the difference in price between the products as a percentage and using that formula across the whole row, but it differs so much from one size to the other. Simply adding a percentage to the price doesn't work unless I do it for each size seperately, which would take months or even years to do with the amount of products I have on my site.

I'll show an example of one product and the three price levels it's available in. If anybody fancy's a challenge on this I'd be very grateful as I'm at a loss, I'm pretty much self taught when it comes to Excel and this goes way over my head.

Cheers!

Length (cm) 50 60 70 80 90 100 110 120 130 140 150 160 170 180 190 200 210 220 230 240 250 260 270 280 290 300 310 320 330 340 350 360 370 380 390 400 410 420 430 440 450 460 470 480 490 500 510 520 530 540 550 560 570 580 590 600 610 620 630 640 650 660 670 680 690 700 710 720 730 740 750 760 770 780 790 800 810 820 830 840 850 860 870 880 890 900 910 920 930 940 950 960 970 980 990 1000 1010 1020 1030 1040 1050 1060 1070 1080 1090 1100 1110 1120 1130 1140 1150 1160 1170 1180 1190 1200 1210 1220 1230 1240 1250 1260 1270 1280 1290 1300 1310 1320 1330 1340 1350 1360 1370 1380 1390 1400 1410 1420 1430 1440 1450 1460 1470 1480 1490 1500 <tbody> </tbody>

Price 1 6.95 8.34 9.73 11.12 12.51 13.9 15.29 16.68 18.07 19.46 20.85 22.24 23.63 25.02 26.41 27.8 29.19 30.58 31.97 33.36 34.75 36.14 37.53 38.92 40.31 41.7 43.09 44.48 45.87 47.26 48.65 50.04 51.43 52.82 54.21 55.6 56.99 58.38 59.77 61.16 62.55 63.94 65.33 66.72 68.11 69.5 70.89 72.28 73.67 75.06 76.45 77.84 79.23 80.62 82.01 83.4 84.79 86.18 87.57 88.96 90.35 91.74 93.13 94.52 95.91 97.3 98.69 100.08 101.47 102.86 104.25 105.64 107.03 108.42 109.81 111.2 112.59 113.98 115.37 116.76 118.15 119.54 120.93 122.32 123.71 125.1 126.49 127.88 129.27 130.66 132.05 133.44 134.83 136.22 137.61 139 140.39 141.78 143.17 144.56 145.95 147.34 148.73 150.12 151.51 152.9 154.29 155.68 157.07 158.46 159.85 161.24 162.63 164.02 165.41 166.8 168.19 169.58 170.97 172.36 173.75 175.14 176.53 177.92 179.31 180.7 182.09 183.48 184.87 186.26 187.65 189.04 190.43 191.82 193.21 194.6 195.99 197.38 198.77 200.16 201.55 202.94 204.33 205.72 207.11 208.50 <tbody> </tbody>

Price 2 31.12 32.51 33.90 35.29 36.68 38.07 39.46 40.85 42.24 43.63 45.02 46.41 47.80 49.19 50.58 51.97 53.36 54.75 56.14 57.53 58.92 60.31 61.70 63.09 64.48 65.87 67.26 68.65 70.04 71.43 72.82 74.21 75.60 76.99 78.38 79.77 81.16 82.55 83.94 85.33 86.72 88.11 89.50 90.89 92.28 93.67 95.06 96.45 97.84 99.23 100.62 102.01 103.40 104.79 106.18 107.57 108.96 110.35 111.74 113.13 114.52 115.91 117.30 118.69 120.08 121.47 122.86 124.25 125.64 127.03 128.42 129.81 131.20 132.59 133.98 135.37 136.76 138.15 139.54 140.93 142.32 143.71 145.10 146.49 147.88 149.27 150.66 152.05 153.44 154.83 156.22 157.61 159.00 160.39 161.78 163.17 164.56 165.95 167.34 168.73 170.12 171.51 172.90 174.29 175.68 177.07 178.46 179.85 181.24 183.63 186.02 188.41 190.80 193.19 195.58 197.97 200.36 202.75 205.14 207.53 209.92 212.31 214.70 217.09 219.48 221.87 224.26 226.65 229.04 231.43 233.82 236.21 238.60 240.99 243.38 245.77 248.16 250.55 252.94 255.33 257.72 260.11 262.50 264.89 267.28 269.67 <tbody> </tbody>

Price 3 71.12 72.51 73.90 75.29 76.68 78.07 79.46 80.85 82.24 83.63 85.02 86.41 87.80 89.19 90.58 91.97 93.36 94.75 96.14 97.53 98.92 100.31 101.70 103.09 104.48 105.87 107.26 108.65 110.04 111.43 112.82 114.21 115.60 116.99 118.38 119.77 121.16 122.55 123.94 125.33 126.72 128.11 129.50 130.89 132.28 133.67 115.06 116.45 117.84 119.23 120.62 122.01 123.40 124.79 126.18 127.57 128.96 130.35 131.74 133.13 134.52 135.91 137.30 138.69 140.08 141.47 142.86 144.25 145.64 147.03 148.42 149.81 151.20 152.59 153.98 155.37 156.76 158.15 159.54 160.93 162.32 163.71 165.10 166.49 167.88 169.27 170.66 172.05 173.44 174.83 176.22 177.61 179.00 180.39 181.78 183.17 184.56 185.95 187.34 188.73 190.12 191.51 192.90 194.29 195.68 197.07 198.46 199.85 201.24 202.63 204.02 205.41 206.80 208.19 209.58 210.97 212.36 213.75 215.14 216.53 217.92 219.31 220.70 222.09 223.48 224.87 226.26 227.65 229.04 230.43 231.82 233.21 234.60 235.99 237.38 238.77 240.16 241.55 242.94 244.33 245.72 247.11 248.50 249.89 251.28 252.67 <tbody> </tbody>

<tbody>
</tbody>

 

[Biskit]

I've just seen how bad the table looks, is there any way of attaching a file instead?

 

[VoG]

You cannot attach a file but you can use one of the HTML makers - see http://www.mrexcel.com/forum/showthread.php?508133-Attachments

 

[Biskit]

Thanks! I'll take a look now.

 

[Biskit]

I'm using Excel 2010 which doesn't seem to work with the first 2 options on the link you sent me, and on the third option I get lost after 'quick links' as there is no option called 'edit options'.

 

[VoG]

Excel Jeanie http://www.excel-jeanie-html.de/html/hlp_schnell_en.php works with Excel 2010. The icons will appear on the Add-Ins tab.

 

[Biskit]

It's ok, I've managed top solve the issue. It wasn't Excel related in the end... Duh! Thanks anyway!