Create a Spreadsheet based upon a Variable Gear Configuration with Final Speed and Torque Output Numbers
Budget: $30 – $250 USD
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 to 3000 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 5,000 pounds of RT up to 100,000 pounds of RT.
[3] a smaller 2nd Gear (2G) rides either directly on the outer diameter of the ILRG and/or is powered via a belt or chain linkage to the ILRG; The 2G has a ratio of between 5:1 to 50:1 with the ILRG (Variable 5 in Spreadsheet); This means that for every full rotation of the ILRG, the 2G rotates between 5 to 50 times. The gear specifications (# of teeth) of each Gear (2G and ILRG) should be shown in a cell (Output Cell 1) in the Spreadsheet based upon the selection of other Variables.
[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 Output (RT) with the best (highest) Rotational Torque (RT). 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 (Variable 6: 2 spreadsheet variable cells showing GT Small Gear (GTSG Cell) and GT Larger Gear (GTLG Cell) of each GT set) and shown in 2 Output Cells indicated for that particular GT set. So, each numbered GT set should have 2 Output Cells (GTST#-- RS & RT and GTLG RS & RT) These would indicate the Final / Highest possible Rotational Speed (RS) of each gear in that GT set and the 2nd indicating the highest possible Rotational Torque (RT) of each gear in that particular 2 gear GT unit.
[6] The final output cell should show the Highest Speed (RS) and Highest Torque (RT) 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 show the formulas used (behind the scenes) 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.
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 to 3000 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 5,000 pounds of RT up to 100,000 pounds of RT.
[3] a smaller 2nd Gear (2G) rides either directly on the outer diameter of the ILRG and/or is powered via a belt or chain linkage to the ILRG; The 2G has a ratio of between 5:1 to 50:1 with the ILRG (Variable 5 in Spreadsheet); This means that for every full rotation of the ILRG, the 2G rotates between 5 to 50 times. The gear specifications (# of teeth) of each Gear (2G and ILRG) should be shown in a cell (Output Cell 1) in the Spreadsheet based upon the selection of other Variables.
[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 Output (RT) with the best (highest) Rotational Torque (RT). 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 (Variable 6: 2 spreadsheet variable cells showing GT Small Gear (GTSG Cell) and GT Larger Gear (GTLG Cell) of each GT set) and shown in 2 Output Cells indicated for that particular GT set. So, each numbered GT set should have 2 Output Cells (GTST#-- RS & RT and GTLG RS & RT) These would indicate the Final / Highest possible Rotational Speed (RS) of each gear in that GT set and the 2nd indicating the highest possible Rotational Torque (RT) of each gear in that particular 2 gear GT unit.
[6] The final output cell should show the Highest Speed (RS) and Highest Torque (RT) 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 show the formulas used (behind the scenes) 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.