Hello everyone,
unfortunately I have several problems in carrying out a job, so I have many doubts before to present everything clearly.
I have a value that comes from some of the formulas set out above, let's call WEIGHT. Then I have another value, the CAP.
WEIGHT must be associated with the weight ranges: up to 100, 300, 500, 1000, 2000, 2500, 3000, 4000, 5000.
The CAP will instead be assigned to a particular area: ZONE 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11. In the same area can be assigned more CAP.
The end of the weight determines a cost in relation to the area.
Suppose that the 300 is up to 300 and the ZONE 7 (because for example the cap 41 corresponds to that area), in this case you will find a value that should be determined previously, we have made € 10; if the range is 1000 and the ZONE 1, the value found will be different. A little 'as the baleship game!
I am confused about how to create tables with data and to ensure that they relate properly and with all parameters!
Thank you all for the tremendous help