Excel Pricing Tool Development

I need an Excel-based pricing tool for product pricing. The tool should be able to generate price lists based on data that will be imported from another file

Calculate the distance between our company locations and the customer via zip code or address

Add the product and delivery size in gallons

Based on this a delivered price would be obtained

Ideal Skills and Experience:
- Proficiency in Excel
- Experience with data import functionalities
- Strong background in pricing tools and price list generation