You have attention to detail and are able to design a freight chart calculator.
we are an online business who need a more efficient way of calculating freight.
we (user) enters freight zone
the spreadsheet, software program needs to apply a different rate based on freight zone
State No. of freight zones
we (user) enters physical weight of the products to be couriered
we (user) enters cubic weight of products to be couriered
software / spreadsheet determines higher of 2 and 3 above
we enter how many boxes are being freighted
if more than 8 boxes then software spreadsheet adds additional charge
software calculates freight based on freight zone, no. of boxes, and higher of cubic and physical weight