Create a SIMPLE Spreadsheet That Takes a Slow Rotating, but High Torque Rotation, and Shows the Best Speed and Torque That Can Be Created From The Initial Input

Work Details: I am seeking an Expert in Power Transfer via Gears to create a Spreadsheet. The Spreadsheet must have input cells that allow certain variables to be changed so that I can manipulate the final output of a gear-train calculation. I am seeking a final output of 1000+ rpm at the highest torque possible based upon the input variables. The spreadsheet’s goal is to let me know what is possible. The Gear-Train has the following characteristics: [1] an Initial Large Rotation Gear (ILRG) that can rotate 1 to 10 time per Hour (This is its Rotational Speed and is Variable 1 in Spreadsheet); the ILRG SIZE is a variable on the Spreadsheet (Variable 2) that can be between 80 to 120 feet in diameter (80,90,100,110 & 120 ft/Diameter) This will determine the number of Gear Teeth (Variable 3) on the ILRG; [2] The Rotational Torque (RT) which is the Force of the turning power of the ILRG - and is a Variable (Variable 4) that can be set in a Spreadsheet cell; The RT can be set between 10,000 pounds of RT up to 200,000 pounds of RT. This Value can be a Pull-Down Selection in 10,000 lb increments or a Number can be typed into this Input Cell (whichever is easier for you) [3] a smaller 2nd Gear (2G) rides either directly on the outer diameter of the ILRG and/or is powered via a belt drive or chain linkage to the ILRG; The 2G has a ratio of between 5:1 to 100:1 with the ILRG (Variable 5 in Spreadsheet); This means that for every full rotation of the ILRG, the 2G rotates between 5 to 100 times. [4] A Gear-Train (GT) consisting of smaller gears mounted on the center axis of larger gears will be used to achieve an ever-increasing rotational output speed of the GT. [5] The End Goal of the GT’s (from ILRG through 2G through any number of connected 2 concentric gear GT sets) is to achieve the highest Rotational SPEED Output (RSO = OUTPUT CELL RSO FINAL) with the best (highest) Rotational Torque Output (RTO = OUTPUT CELL RTO FINAL) . Each new GT component (a smaller gear - driven by the last GT larger Gear- that is mounted on the center axis of a larger gear) should have a set of Gear Teeth Variables. [6] The final output cells (RSO and RTO) should show the Highest Speed (RSO) and Highest Torque (RTO) of the last GT set based upon the variable that are set in the spreadsheet. NOTE 1: It is understood that as the final output Speed of the assembled Gear Train will increase, the Rotational Torque will (proportionally?) decrease in the final output GT. The Goals is to have a spreadsheet that allows the various variables to be managed to achieve (and see) the Highest RS and RT at the final GT set in the overall Gear-Train. NOTE 2: Do not concern yourself with how the ILRG is being powered in this Gear Math scenario. Just assume the ILRG is turning at the Rotational Speed set in in Spreadsheet (Variable 1) and at the Rotational Torque (set in Variable 4). Also do not concern yourself with what work is meant to be accomplished with the output of this math exercise Gear Train. Concentrate on providing the best and most accurate spreadsheet about the gear train scenario. Please Allow All formulas used (behind the scenes) to be shown in each set of calculations. Note 3: Please include a “Friction Factor” spreadsheet cell (Variable 7) where a friction coefficient can be set for the interactions of all gears in the scenario. This Friction Variable spreadsheet cell should be able to accept any number between “0%” Friction to “30%” Friction. This number should affect the rotational ability (and speed) of all gears in the system. Skills: Excel, Mechanical Design