I've been busy (having fun). I'm uploading a ZIP file that contains 2 Microsoft Excel spreadsheets for your amusement. This sheet asks you to input the weights from your TV and FW load stickers and your CAT scale results. The analysis will tell you how you are loaded and whether you are in or out of weight limits.
There are 4 sections that expect you to enter data and they all have a bright green border:
1) the title - whatever makes you happy
2) the sticker weights
3) the CAT scale weights
4) the pin weight range (as a percentage)
The Analysis section will calculate some weights and show how much under or over weight you are. The "J" column will have a Green/Red indicator to indicate Under/Over weight.
Feel free to download and use/abuse as you feel.
Disclaimer: I've done what I can to insure the results are accurate but there's no guarantee. Let me know if I've made some mistakes!
Note: I've built a version using Excel 2013 and it works on the 2010 version and is the *.xlsx file. If you are using an older version of Excel you will want to use the *.xls file.
FW weight analysis.zip
__________________
Cheers,
T_
2013 F-350 CC SB 2WD 6.7PS
2013 Eagle Premier 351 RLTS
-SOLD- 2012 X23B
-SOLD- 2003 Ford Expedition 5.4, Bilstein shocks