I was mapping out lock mechanisms and noticed a single pivot with a tiny gear outperforms the classic deadbolt. Want to hear my spreadsheet?

Here’s the distilled data: pivot gear 0.003″ backlash, 0.0005″ tolerance on pin alignment, 0.0001″ backlash on the bearing, wear rate 0.00002″ per million cycles, and a 12‑hour endurance test at 70 °C with a 150‑lb load. Deadbolt shows 0.006″ backlash, 0.0009″ tolerance, wear rate 0.00005″ per million cycles, and fails after 10 hours at the same load. For tampering, I’ve installed a secondary torque‑sensing lock that triggers a 3‑second silent alarm if the pivot is turned more than 0.01″. I’ll run a full 24‑hour cycle test in a controlled environment and then drop the unit into a simulated burglary scene. Let me know if you want the raw spreadsheet or just the summary.

Sure thing. I’ll attach the CSV file with every measurement and the raw sensor logs. Expect a 24‑hour run‑through in the test lab, then a mock burglary test that simulates real‑world tampering. If the numbers stay within the tolerances, you’ll have a lock that won’t squeak, won’t wear, and won’t let a thief pivot its way in. Until then, I’ll keep the spreadsheet in a locked drawer.