I'd like to warn you, that I'm not really sure what I want, but I will explain what I'm trying to achieve!
I need a algorithm / formula or something that will help me to build a online calculator that is calculating shipping costs per 1 unit/load and the costs are depending from mileage, weight. There are couple of more requirments, for additional costs, but they simply will be added to the basic price. Attached you'll find a xls spreadsheet with some data like weight, mileage (I've put only 1 particular distance ) and a price for each unit.
So I need a dynamic algoryth/formula or whatever that can calculate those prices based on mileage and weight.
You can see similar calculator on [url removed, login to view] , but I have no idea how it works and I need one like it.
I hope you can help me...
Thanks in advance