Determining a shipping formula

[Brian Wright <bdw@aturna.com>]

I'm having a wee bit of trouble coming up with a shipping formula for
the shipping database.  I never said I was a math major, hehe!

The first ten items have a shipping rate of $4.95.  Subsequent groups of
ten items add another rate of $4.95 per groups of ten items.  The
criteria I'm using is quantity.  So, I have figured the following:

(@@TOTAL@@ / 10) * 4.95

However, if the number is not evenly divisible by 10, I want to include
the $4.95 charge, but can't figure out a way to put this in the shipping
database.

Here's a copy of the shipping database as I currently have it:

code	description	criteria	min	max	formula
0	No shipping	quantity	0	99999999	e No shipping mode selected.
default	No shipping	quantity	0	99999999	g PriceDivide

standard	Shipping	quantity	0	0	e Nothing to ship!
standard	Shipping	quantity	1	10	4.95
standard	Shipping	quantity	11	150	f (@@TOTAL@@ / 10 ) * 4.95
standard	Shipping	quantity	150	999999	e Only 150 items maximum per shipment.  Toss out some items from your shopping cart. :-)

express	Express Shipping	quantity	0	0	e Nothing to ship!
express	Express Shipping	quantity	1	10	12.95
express	Express Shipping	quantity	11	150	f (@@TOTAL@@ / 10) * 12.95
express	Express Shipping	quantity	150	999999	e Only 150 items maximum per shipment.  Toss out some items from your shoppint cart. :-)

_________________________________________________________________________
Brian Wright                                   Aturna Communications Inc.
bdw@aturna.com                                          Internet Services
                                                WWW http://www.aturna.net
_________________________________________________________________________