I'm not much of a spreadsheet writer, but I could find nothing on the subject of shear-friction. This is my first submittal, and I'm sure it won't meet the submittal standards; I don't know how to add links, etcetera. Possibly someone else could spruce it up.
Calculation Reference
ACI