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. We have called these optimising programmes ‘Excel Tools’ and placed a few for downloading below and will add more on member request.
Optimise board thickness with Excel tool 64c
Excel Tools are 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 exact changes, 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 increase instantly (note effect is not proportional to thickness). Another example - if your customer needs the weight of a sitka spruce pallet as it dries down to 20% moisture content in his warehouse, key in your exact board sizes and from the Excel worksheet you get the exact weight for good quality average growth sitka spruce.
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 need help call us or and if you need another spreadsheet format like Quattro or Lotus-123 then we can e-mail this to you.
Note that none of these Excel spreadsheets give working loads. If you want a line drawing of a pallet or box in 3-D see 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.
64a Block pallet weight calculator in 3 species and 3 moisture contents (Excel 25kb)
64b Bearer pallet weight calculator in 3 species and 3 moisture contents (Excel 25kb)
64c Effect on board strength of changing thickness (Excel 26kb)
64d Wood specimen density & moisture content calculator (Excel 28kb)
64e Wood strength (MOR) from small clear 300mm specimens (Excel 24kb)
64f Wood sheet weight calculator (Excel 28kb)
64g Sawn wood weight calculator in 2 species varying dryness levels (Excel 27kb)
64h EPAL Euro weight calculator in 2 species at 6 moisture contents (Excel 31kb)
64n Nail bending strength test procedure to EN ISO 12777 (Excel 35kb)