don't go by the recipe, it wont really help you in this case, except as a guide for the basics of creating filtered recordsets and using the set session value server behavior.
from you description, it sounds like you need the following columns in your table:
shipingRateID - Primary Key, Auto Number
shippingRateCountry - 2 letter country code: GB, US AU etc.
shippingBase - this will store the base rate for the country, 6.75 for GB
shippingIncrement - the increment for the country, 0.26 for GB
shippingFuelPercentage - the fuel charge, .13 for GB
on the confirm page, create a shipping rate lookup recordset.
Set the filtering options to filter the shippingRateCountry equal Form Variable 'shipping_country'
Now add 4 Set Session Value server behaviors, one for each of the columns in the shipping table except the ID:
shippingRateCountry
shippingBase
shippingIncrement
shippingFuelPercentage
In each of them, set the trigger to Any Form Post.
Set the name to be the same as the database column
Click the lightning bolt next to value and select the corresponding column from the recordset.
Now in the cart object, you can create the shipping calcualation to use the session variables created:
ShippingCost:
$_SESSION['shippingBase'] + (abs(([Weight] * [Quantity]) > 10)?floor(([Weight] * [Quantity] - 10) / 0.5) * $_SESSION['shippingIncrement']:0) + ($_SESSION['shippingFuelPercentage'] * ([Price] * [Quantity]))
then on the shipping tab, create a new shipping charge. set the trigger to:
Subtotal for any column:
ig the subtotal for the column 'total weight' is '>' a value of '0'
AND
Session Variable exists 'shippingBase'
AND
Session Variable exists 'shippingIncrement'
AND
Session Variable exists 'shippingFuelPercentage'
Calculation:
Based on column subtotal:
Subtotal of Column 'ShippingCost' 'plus' '0'
