•  
  Pallets
  • British Pallets
  • European Pallets
  • Military Pallets
  • North American Pallets
  • Pacific Asia Region
  • Pallet Pools
  • Pallet Testing
  • Plastic Pallets
  • Recycled Pallets
  • Steel and Aluminium Pallets
  • Model Drawings
• Containers Export Cases
  • Small Packing Cases
  • Large Export Packing Cases
  • Non-standard Platforms
  • Freight Containers
• Potato Boxes
  • Box Design
  • BS Strength Classes
• Timber for Packaging
  • Sawn Timber
  • Species / Strength
  • Processed Wood
•  
  ISPM 15
  • ISPM 15 Phytosanitary
• Nails & Nailplates
  • Annular Ring / Helical / Plain
  • Nailplates / Shearplates
  • Testing Nails
• Roll Containers
  • Designs / Terminology
  • Roll Container Testing
  • Safety in Use
• Treatments Moisture
  • Drying
  • Paper
  • Durability
  • Bluestain
  • Treatments
  • Measuring Moisture
• Collars Shelving
  • Collars
  • Racking
  • Shelving
  • Automation
• Published Standards
  • International Work
  • Timber
  • Non-timber
  • Workplace

• • Safe Working Loads
  • Safety Publications
  Safety Issues

Excel Tools

Excel spreadsheet programmes have been written to optimise designs for pallet decks, potato box sides, notched bearer pallets, and skid bases for export cases. We have developed some 30 short Excel programmes based on questions members have raised in the last few years. We have called these optimising programmes ‘Excel Tools’ and placed a few for downloading below and will add more in due course.

Optimise board thickness with Excel tool 64g

Excel Tools are short, easy to use and free to PalletLink Members. Those that modify strength leave the user in full control by not adding safety factors to results, so what you get are not working loads. For example if you want to see the effect of changing stringers from 20 to 23mm thickness, you get the exact strength change instantly (note the effect is not proportional to thickness). Another example - if your customer needs the weight of a spruce pallet you supply as it dries down to 20% moisture content in his warehouse, key in your board sizes and from the Excel worksheet you get the exact weight.

Excel Tools downloadable now or due shortly are -

• Effect of pallet drying out on overall strength
• Effect of thicker/thinner deckboards on deck strength
• Effect of changed stringer thickness on breaking strength in pallet racks
• How much a pallet weighs after drying out, if made in pine/spruce etc
• The weakening effect of increasing bearer notch height in a 2-way pallet
• Calculating total wood weight for the Packaging Waste Regulations

There is no charge for downloading these useful programmes, if you make incorrect entries, just delete and download from the PalletLink site again. If you still need help call us or if you need another spreadsheet format like Quattro or Lotus-123 then we can e-mail you.

Note that none of these Excel spreadsheets give working loads. What they do is to help you if, for example, pallet deck breakage in use means you are required by a customer to increase deck strength by say 20% with the minimum timber cost. To illustrate to your customer what you are proposing and if you want a line drawing in 3-d, see the main designs of pallet on page PALLETS / MODEL DRAWINGS

For Downloading...

This is a members only document.  Login if you are an existing member.

Click Here for information on joining PalletLink to gain access to all the benefits of a subscription.