It was recently pointed out to me that the non-uniform load calculation in Frame4.xls gave incorrect results.

The code for the non-uniform load has now been fixed, and the spreadsheet can be downloaded from Frame4.zip