Thanks for all the thoughful comments. Much appreciated.
We have to do this type of calculation quite a few times during the year - every time we have more than a single storey basement, which is quite often, given the hospitals, office buildings and condos we do with below grade parking etc. , where the grade etc. changes several times around the 4 sides of the building. For example, a recent building in which we were involved had 5 levels of underground parking.
Most likely my 50 years of experience has slowed me down from the speed at which you young guys can do manual calculations, as it took me several hours to work out one wall section for all the pressures and pressure variations, water table effects, submerged unit weights, and changes in pressure where the soil changes to rock, etc. Then input all the various partial triangular and rectangular loads to a continuous beam programme to determine the moments and shears. Then manually detrmine the rebar for the wall and check that the shear stress is ok. All this my spreasheet can do in a few minutes, but my spreasheet does not cover the change in unit soil weight or other changes in pressure that do not occur at floor lines. I think I will expand my spreadsheet that I wrote a few years ago, so that it can handle the water table and pressure changes that do not occur at floor lines.
I am all in favour of manual calculations and encourage any young engineer starting out with us under my mentorship, to design the various elements of a building by hand first, before letting him/her use our programmes. But if we are to be competitive, at some point we have to make use of technology, and we think that a programme for this would pay for itself fairly quickly. Others may disagree, and I respect that.
Again, thanks for the comments. It is gratifying that so many took the trpouble to respond and provide suggestions,