da Vinci bridge - excel calculator

Job ID: 36821380

Budget: $30 – $250 USD

the following websites should explain what im looking for in the calculator.

this first link provides a detailed explanation of the same questions that i have
https://math.stackexchange.com/questions/3838563/circumference-and-piece-length-of-the-da-vinci-bridge

this second link has a picture of a finished bridge
https://www.core77.com/posts/65043/Leonardo-da-Vincis-Ingenious-Design-for-a-Self-Supporting-Bridge

third link provides basic formulas
https://dotat.at/@/2020-09-14-da-vinci-bridges.html

forth link provides more design formulas.... please use inches and lbs in the calculator
https://dotat.at/random/bridge.html

these links provides info to calculate load and deflection
https://awc.org/publications/tutorial-for-understanding-loads-and-using-span-tables/
https://extension.okstate.edu/fact-sheets/strength-properties-of-wood-for-practical-applications.html

I will be using white pine and want to be able to enter beam dimensions to determine most suitable size lumber to use. for example is a 2x6 x 8 foot long a better option compared to a 2x8 x 12 foot long.