Your Company Name
Customer Order # Ship From Ship To Ship Via Item 1 Item 2 Item 3 Item 4 Item 5 Item 6 Item 7 Item 8 Item 9 Item 10
11/8/2009
Use Dimensional Weights?
Please see the Control Panel to input Your Company Name. Your special instructions go in this space.
Quantity Weight Rate Freight
Destination Charge
Print Clear
$10.00
Total:
Rates Last Updated 11/9/3001
Calculator Expires 12/7/2020
Control Panel
Ship From Home Office Main W/House Vendor 1 Vendor 2
Entries in RED can be modified by the end user Name Your Freight Calculator Your Company Name
Ship Via
Express Postal Two Day Air Air Overnight Air Priority Surface 12/7/2020 11/9/3001 25
Home Office Main W/House Vendor 1 0.20 0.21 0.23 0.40 0.41 0.43 0.60 0.61 0.63 1.00 1.10 1.20 Surface Rates vary by destination and are input on the Rates Page Input Your Special Instructions Here Please see the Control Panel to input Your Company Name. Your special instructions go in this space.
Calculator Expires Rates Last Updated % Uplift all rates
Dimensional Weights Divisor Typical Divisor is 166 166
Vendor 2 0.24 0.44 0.64 1.30 ut on the Rates Page
Rates
After updating this page remember to hide it and protect the WORKBOOK with the password freight (no caps). Entries in RED can be updated. Ship To Home Office Main W/House Vendor 1 Vendor 2 AK 0.10 0.11 0.12 0.13 AL 0.11 0.12 0.13 0.14 AR 0.12 0.13 0.14 0.15 AZ 0.10 0.11 0.12 0.13 CA 0.11 0.12 0.13 0.14 CO 0.12 0.13 0.14 0.15 CT 0.10 0.11 0.12 0.13 DC 0.11 0.12 0.13 0.14 DE 0.12 0.13 0.14 0.15 FL 0.10 0.11 0.12 0.13 GA 0.11 0.12 0.13 0.14 HI 0.12 0.13 0.14 0.15 IA 0.10 0.11 0.12 0.13 ID 0.11 0.12 0.13 0.14 IL 0.12 0.13 0.14 0.15 IN 0.10 0.11 0.12 0.13 KS 0.11 0.12 0.13 0.14 KY 0.12 0.13 0.14 0.15 LA 0.10 0.11 0.12 0.13 MA 0.11 0.12 0.13 0.14 MD 0.12 0.13 0.14 0.15 ME 0.10 0.11 0.12 0.13 MI 0.11 0.12 0.13 0.14 MN 0.12 0.13 0.14 0.15 MO 0.10 0.11 0.12 0.13 MS 0.11 0.12 0.13 0.14 MT 0.12 0.13 0.14 0.15 NC 0.10 0.11 0.12 0.13 ND 0.11 0.12 0.13 0.14 NE 0.12 0.13 0.14 0.15 NH 0.10 0.11 0.12 0.13 NJ 0.11 0.12 0.13 0.14 NM 0.12 0.13 0.14 0.15 NV 0.10 0.11 0.12 0.13 NY 0.11 0.12 0.13 0.14
Page 4
Rates
Ship To
Home Office
Main W/House
Vendor 1
Vendor 2
Entries in RED can be updated.
OH OK OR PA RI SC SD TN TX UT VA VT WA WI WV WY Mexico Canada Europe Asia Australia Latin America Middle East Africa
0.12 0.10 0.11 0.12 0.10 0.11 0.12 0.10 0.11 0.12 0.10 0.11 0.12 0.10 0.11 0.12 0.50 0.75 1.00 1.50 1.75 0.80 1.25 1.00
0.13 0.11 0.12 0.13 0.11 0.12 0.13 0.11 0.12 0.13 0.11 0.12 0.13 0.11 0.12 0.13 0.25 0.30 0.40 0.45 0.50 0.55 0.60 0.65
0.14 0.12 0.13 0.14 0.12 0.13 0.14 0.12 0.13 0.14 0.12 0.13 0.14 0.12 0.13 0.14 0.30 0.35 0.45 0.50 0.55 0.60 0.65 0.70
0.15 0.13 0.14 0.15 0.13 0.14 0.15 0.13 0.14 0.15 0.13 0.14 0.15 0.13 0.14 0.15 0.35 0.40 0.50 0.55 0.60 0.65 0.70 0.75
Page 5
Rates
Page 6
Rates
Page 7
Weights
After updating this page remember to hide it and protect the WORKBOOK with the password freight (no caps). Entries in RED can be updated. Weight Chart Item Weight Height Length Width Dim. Test1 5 10 10 10 6.03 Test2 6 11 11 11 8.02 Test3 7 12 12 12 10.41 Test4 8 13 13 13 13.24 Test5 25 14 14 14 16.54
Page 8
Weights
Item
Weight
Height
Length
Width
Dim.
Page 9
Weights
Item
Weight
Height
Length
Width
Dim.
Page 10
Instructions
Instructions For Using This Calculator Step-by-step directions: 1) Print out these instructions 2) Click on the Calculator tab below 3) Input the Customer Name and Order # (optional) 4) Select a Ship From location 5) Select a Ship To location 6) Select a Ship Via method 7) Select your Item(s) in the dropdown windows labeled Item 1, Item 2, etc. 8) Input the correct quantity by using the gray spinner bars to the right of the Item dropdown boxes 9) Check (or uncheck) the Use Dimensional Weights? box as appropriate 10) Input a dollar amount, or clear, the Destination Charge Box just above the Total Box near the bottom 11) Print out this calculator for your records using the Print button (optional) 12) The Clear button clears the Calculator page and readies it for new input To prevent the freight rates in this calculator from becoming dated it can be programmed to stop working after a specified date. To see this date go to the Calculator page and look directly below the calculator. If this calculator does not calculate your freight: 1) Check the expiration date visible directly below the calculator 2) Make sure you have made an appropriate selection from Ship From, Ship To, and Ship Via 3) Make sure you have selected your Item from the dropdown boxes 4) Make sure you have input a Quantity 5) Check with your system administrator
Page 11
After reading this page remember to hide it and protect the WORKBOOK with the password freight (no caps). Instructions For Maintaining This Calculator Step-by-Step Instructions for Administrators
1) Print out these instructions 2) Make sure the "Rates" and "Weights" tabs are visible below 3) If all tabs are not visible, use the Format/Sheet/Unhide options on the toolbar to unhide them 4) If the WORKBOOK is protected, use the Tools/Protection/Unprotect Workbook function to unprotect it 5) The password to unprotect the WORKBOOK is freight (no caps) 6) Click on the "Weights" tab 7) Input the names of all the items you wish to weigh in the "Item" column 8) Input the weights of all the items you wish to weigh in the "Weight" column 9) Input the dimensions of your product (in inches) in the appropriate columns* 10) Click on the "Rates" tab 11) Input all possible destinations in the "Ship To" column 12) In each of the remaining columns of this table, input the per/pound or per/kilogram rate 13) Fill out the tables on the Control Panel as appropriate. Note that all rates can be uplifted via a box on the Control Pa 14) Using the Format/Sheet/Hide function on the toolbar, hide all sheets except the Calculator, Instructions and XL Gizm 15) Using the Tools/Protection/Workbook function, protect the WORKBOOK with the password "freight" (no caps) 16) Save**
*To make EZ Calc PLUS work with units other than inches, you will need to input a different DIVISOR on the Control Pan **EZ Calc PLUS closes without reminding the user to save any new inputs. Please save all inputs before closing this too
ssword freight (no caps).
to unprotect it
ed via a box on the Control Panel ator, Instructions and XL Gizmos word "freight" (no caps)
nt DIVISOR on the Control Panel. ll inputs before closing this tool.
Thank you for your interest in this XL Gizmos business tool. EZ Calc Plus is free to use and distribute, as long as this page is included with the tool without alteration. XL Gizmos is the on-line home page of Lawrence W. Lanum. If you would like to have EZ Calc Plus customized for your business, or have in mind an entirely different Excel/VBA project, please contact me for a quote. Whether your needs are modest or you want a full-blown business tool with help files and an installer, I can provide custom work at reasonable rates. I can also relocate to work on-site. For quotes, or to inquire about engaging me for an on-site assignment, please e-mail me at: lwlanum@xlgizmos.com Disclaimers and Warranty This program is owned by XL Gizmos and is protected by the United States copyright laws and international treaty provisions. It is provided as a “freeware” product and can be used without purchase or registration. Copying or publishing this program with the intent of reselling to another party is expressly prohibited. All redistribution of this program by any party other than XL Gizmos or its licensed agents must be free of charge and must include all the original disclaimer and warranty provisions, including this one. No purchaser or third party may modify, adapt, or create derivative code based upon this XL Gizmos program with the intent or purpose of distribution for a fee, except that such fee be paid to XL Gizmos or its agent. XL Gizmos warrants that this product will perform satisfactorily in accordance with the included instructions and for the purposes described herein. XL Gizmos’ entire liability under terms of this warranty is for the purchase price or replacement price of the product, whichever is less. In no event shall XL Gizmos be responsible for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss off business information, or other pecuniary loss) arising out of the use or inability to use this product, even if XL Gizmos has been advised of the possibility of such damages. Because some states/jurisdictions do not allow the exclusion or limitation of liability for consequential damages, the above limitation may not apply to you. The warranty and remedies set forth in this agreement are exclusive of all others, oral or written, express or implied. No XL Gizmos dealer, agent, distributor, or employee is authorized to make any addition to this warranty. Excel is a trademark of Microsoft Corporation.
mind an entirely ds are modest ide custom work
e-mail me at:
pyright laws and e used without eselling to another er than XL Gizmos or its mer and warranty or create derivative tion for a fee, except
with the included under terms of this er is less. In no event ut limitation, damages or other pecuniary s been advised of the e exclusion or limitation .
rs, oral or written, thorized to make any