First, I have posted lately about force calculation stuff. I have received overwhelmingly helpful feedback, and detailed explanatory comments. Thanks! I really appreciate that. There seems to be a great depth of experience and knowledge in this area on the site. Cool.
I made a Excel spreadsheet to make these calculations easy to play with. Of course, they are approximations, but it's still interesting to learn about the possible forces in climbing situations.
If would be great if somebody felt like checking the equations, or seeing of the numbers generated are reasonable. It's easy to make a mistake.
-I attached two versions, new (.xlsx) and old (.xls) Excel. Don't know if they will both work.
-The main fields you can change are the mass, the distance fallen and length of rope deployed, and the K value.
-The K value table and equations are there for reference.
-The different forces for climber, protection, and belayer were from my best understanding of how these forces are mathematically related.
Comments welcome, and please feel free to modify/use/change/discard as wanted.