Extracting Live load Thrust

I was asked at a seminar last week how to extract the live load thrust from Archie Output.
A spreadsheet to do it is here.
This is a 4 page spreadsheet. The first contains the tabular output from a dead load only case. The second has the live load case. The third does the computation and the fourth the plotting. If you want to just use this sheet you will need to make sure you have the right number of segments (60 in this case).

Bill