Dear Meca,
I have downloaded the Demo to your spreadsheet for saddle design and I have two questions.
1.) On page 5 of 8 on the PDF paper you show a calculation for the variable “d” as being
B-R*sin(Theta)/Theta with a result of 49 inches. Using your numbers for this calculation I get 44.25 inches. Theta is equal to 2.097 rad and sin Theta is 0.865 rad. Therefore, the calculation is 69-60* 0.865/2.097 which is equal to 44 .25 inches. This changes the bending stress from 913 psi to 824 psi.
2.) Also on page 5 of 8 you show a bending stress in the wear plate fb = 17,624 psi. Again using your numbers for the calculation I get 121,518 psi.
(6*Q*K5*wb)/(8*tw^2*Rs) = 121,518 or 6*300,000*0.7595*24/(8*0.750^2*60) = 121,518.
Since I only have your Demo I can’t see the actual formula that was used. I was contemplating purchasing your software until I saw these discrepancies. Could you take a look at these two and let me know if it is just me or is it the spreadsheet that is incorrect.