# Create a Spreadsheet based upon a Variable Gear Configuration with Final Speed and Torque Output Numbers

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.

Skills: Excel, Mechanical Design

( 3 reviews ) Jackson Heights, United States

Project ID: #32240001

## 15 freelancers are bidding on average \$220 for this job

(248 Reviews)
8.0
rIbrarahmed

Hi, I am very good in Excel VBA, Macro charts etc. I have done several projects like this before. If you want to see my excel skills, i will share with you some of my excel work. Please contact with me for further det More

\$245 USD in 1 day
(26 Reviews)
5.0
(30 Reviews)
5.1
Valuesolutions

Hello, I hope this finds you well. I have just seen your project requiring; Excel Mechanical Design I believe that my 10-year experience in this field is what you need right away. Avoid the headache of looking furthe More

\$200 USD in 7 days
(7 Reviews)
4.2
webanis

Hello! I am very interested in your post project. looking forward to work with you. Thanks regards

\$200 USD in 7 days
(22 Reviews)
4.1
AAGGMM

Hello sir I am Ahmed, a data analytic with very good skills in Excel including advanced formula and macros (please check my profile), also in data cleansing, organization, and integrity. So, I can achieve this task p More

\$100 USD in 1 day
(16 Reviews)
3.6
afzalwaqas94

Hi! Greetings! I am a Mechanical Engineer with expertise in Mechanical Design. I have done projects that include Design of JIB Crane, Design of Base Plate for Steel Columns, Design of Pressure Vessel, Design of Transpo More

\$200 USD in 7 days
(3 Reviews)
3.2
bouzayeniabdelwa

As an Electro-mechanical Engineer, I bid on your project because I have the expertise and experience to provide high quality work. I can achieve the results that you are asking for. So , respond to the offer so that we More

\$100 USD in 7 days
(1 Review)
2.2
zahid49ch

Hello, Dear Employer. Greetings of the day, I have studied your project description & found it interesting. I have done many project-related engineering, 3D modeling, product designing, CFD & FEA simulation, design ana More

\$200 USD in 7 days
(2 Reviews)
2.4
BlessAccounts

Hello, I am a Chartered Accountant with more than 15 years of experience in accounting and finance. My profession involves me to work and play around with figures and calculations and I love working with Excel. Having More

\$500 USD in 7 days
(2 Reviews)
1.3
engrhassanwali

Hello! I have completely read your requirements. I am Mechanical engineer and have 07 years of experience in machine deisgn So I have some important questions related to this and also have few suggestions. I am waiting More

\$250 USD in 7 days
(0 Reviews)
0.0
Henazafar1234

I did manyof these types of work in different freelancing sites. I am experianced to type documents fastly. I ll try to complete your given work shortly and perfectly. Kindly consider me for this job

\$200 USD in 5 days
(0 Reviews)
0.0
aryanjainvds92

I'm confident that I will thrive in this position, seeing that I have all the skills that you are looking for.

\$200 USD in 7 days
(0 Reviews)
0.0
ceanvife

I'm engeenering and retired university professor whit thirty years of teaching in programming PC & PLC, and other subjects. I have coded many exercises in standard C.I have also taught machine theory. I develop a pr More

\$200 USD in 7 days
(0 Reviews)
0.0
josephnkahiu

Hello. Based on my mechanical engineering expertise and Excel knowledge, I am confident to provide you with the solutions you require for this task in a professional and timely manner. Please hit my inbox to discuss my More

\$200 USD in 7 days
(0 Reviews)
0.0