Obviously, i realize that 708 charts at 211 (+/-) lines each chart, is A LOT of data. On the spreadsheet, I have added what two of the 708 different possible zone charts would be (tab 91000-91899) and samples of what we would want the final calculations to look like (tab zone calc)
Everything is based on the first 3 digits of a the Origin zip code and the first 3 digits of the destination zip codeĪ link to the spreadsheet can be found at
What I want to create is the ability to type in two random zip codes in excel, and have there be a calculation done through to tell me what zone the shipment would be considered. UPS and Fedex both have zone calculators available where I can type in my starting zip code, and the website will tell us based off of that initial zip what shipping 'zone' other parts of the country are in.
