How to Calculate Shipping using UPS Zones and Lbs

[PowerPal]

I'm hoping to find a spreadsheet that can calculate the shipping rates using UPS rate charts.

I want to have an entry point where I can enter the lbs and zone and get the result.

I'd like to find a spreadsheet that already does it or help on how to create it. I'm reconstructing the table that I need to work on. The numbers are just random.

If anyone has experience with shipping, I'd appreciate some help on how to do this.

.....Zones..............1..........2..........3..........4..........5
Lbs ...........1... $1.00....$1.25....$1.37....$1.43....$1.55
................2.... $1.41....$1.49....$1.65....$1.76....$1.95
................3.... $2.16....$2.34....$2.49....$2.78....$2.99


Thank you

 

[mond]

try this from c2:c2 are your zone values (1,2,3,4,5) b3:b5 lbs 1,2,3 c3:g5 are the given values for search $1.00; $1.25 etc. then on b7 are the entry value for zone b8 entry value for lbs then one e7=VLOOKUP(B8,B3:G5,MATCH(B7,C2:G2,0)+1)

hope this can help

 

[mond]

sorry typing error, from c2 to g2 are your zone value so (1,2,3,4,5) then from b3 to b5 downward are lbs values so 1,2,3, then from c3 to g5 are the given values for search $1.00; $1.25 etc. then on b7 is the entry value for zone, then b8 is the entry value for lbs then on e7=VLOOKUP(B8,B3:G5,MATCH(B7,C2:G2,0)+1)

hope this can help <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>