Obviously, i realize that 708 charts at 211 (+/-) lines each chart, is A LOT of data. But shipping from 91311 to 73301 would be a zone 6. So in looking at the attached file, we would look at shipping from 91311 to 91605 would be a Zone 2. ![]() I have attached a sample of what ONE of the 708 different possible zone charts would be (tab 91000-91899) and what we would want the final calculations to look like (tab zone calc) ![]() Everything is based on the first 3 digits of a zip code. 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 excel 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |