Sure. It's quite an older copy of Excel, but if MS have done their job right it will hopefully load into a more modern version without formatting issues!
It's pretty messy in there as I tend to throw these things together hastily, so I added a few comments in the sheet to help explain.
One fixed beam, one control beam, two follower beams, modelled with simple triangle math and this 4-beam structure free to move between two limits. Fifth constraining beam then added to fixed beam and projected through target destination point on top follower beam, calculating the error of how much the final pin missed its target by.
It's pretty messy in there as I tend to throw these things together hastily, so I added a few comments in the sheet to help explain.
One fixed beam, one control beam, two follower beams, modelled with simple triangle math and this 4-beam structure free to move between two limits. Fifth constraining beam then added to fixed beam and projected through target destination point on top follower beam, calculating the error of how much the final pin missed its target by.