At this point I'm reluctant to pass out the spreadsheet as the calculations are hidden all over the place and the spreadsheet is essentially held together with bailing wire and duct tape. One click in the wrong place and it could start giving bogus numbers or stop working all together.

For example there are over eighty cells with the following equations to systematically search for the W point and the 0.1 point:

=IF(H23=0, 0,(C23+(H23*($E$35-B23))))