Quote:
Originally Posted by SBL9A
Looks nicer than mine. Are you going to share them? Thanks.
|
I'm happy to share.
I can't post an Excel Spreadsheet so I've posting it as a ZIP file. There are 2 versions included, an ".XLS" and ".XLSX". The XLS should work with older versions of Excel and the XLSX with the newer versions. The boxes with "
GREEN" fill (Column "I") are my attempt to show Over/Under weights (RED being over weight). Some of the Conditional Formatting may be lost in the XLS version but that's just window dressing.
Each spreadsheet has 2 tabs, one for a 5th and one for a bumper-pull.
The cells I intend to be changed have a "
RED" outline and currently contain the numbers from our HTT (now gone) and 5th.
I have hidden column "M" just to make it a little more tidy.
Feel free to make any changes you like (including the title).
Please note that though I believe my calculations are correct I do not guarantee them to be error free. If you find errors please let me know so I can update the sheets.
SBL, I would be interested to hear if our calculations give different results.
Weight Analysis-v3.0.zip
If you have trouble with the ZIP file send me a PM with a return e-mail and I'll send an unzipped copy directly to you.
__________________
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