Trash SPW911. Do hand calcs for a layerd soil condition where one of the layers is a relatively weaker soil. Then compare your results with the SPW911 results for the same soil conditions.
A wall about 10 to 12 feet high should be a cantilevered wall. For a cantilevered wall, I would use no less than a 5 foot socket in good rock or about 7 feet in fractured rock. For the stiff clay or rock, the passive pressure diagram would be rectangular, not triangular. When I am not sure if there will be rock at every soldier beam, I design embedment for both all soil and all rock, call for soldier beams long enough for soil, and give a note saying that the soldier beam embedment needs not be longer than the all soil length or can be terminated once the minimum rock socket length is drilled, if rock is encountered. For example, if the embedment length in soil is 12 feet and the embedment length in rock is 6 feet, and if I the rock is encountered 3 feet below subgrade, then the lotal embedment length would be 3' + 6' = 9' which is less than 12'.
Some of the older AASHTO manuals do not indicate that the passive pressure should be multiplied by the socket width or wider. It's amazing that thousands of highway engineers use the manuals every day and haven't questioned the absence of a width multiplier. It's also amazing that AASHTO never corrected this.
Also, in the 1994 Imterim of AASHTO's Standard Specifications for Highway Bridges, Figure 5.6.2A.a, there is a mistake in the formula for active pressure behind the soldier beam below subgrade. The Pa2 formula should be 0.5 x Ka2 x b x D etc..... Not 1.5 x Ka2 ....... For some reason, AASHTO applied the active pressure behind the beam to 3 times the soldier beam or socket width as is done for the passive pressure. I mentioned this to one of FHWA's experts. His response was that I should be using the LRFD manual. Some help! He obviously didn't give a _ _ _ _ !