Power Drag Speed Gear Ratio and stuff in an Excel Spreadsheet

Hello there!!

Please bid only if you agree to my terms.

I am looking for a spreadsheet to put some physics formulas to work. It doesn't have to be fancy and beautiful, but understandful and practical.

No Macros should be used!!!

I'm attaching a spreadsheet that is basically what I want, with 60% or 70% of what I want done. There you will have a good idea of what is good for me.

All of the physics formulas used should be placed beside the excel formulas, or commented, with the explanation on how it works.

This is what I mean, for example:

km/h = RPM *2*pi*r/(R1*R2) inches per minute

RPM = revolutions per minute

pi = 3.1416

r = loaded tire radius

R1 = transmission gear ratio

R2 = differential gear ratio

1 mile = 5280 feet = 63,360 inches, so inches per minute to miles per hour is: 60/63,360 = 0,00595

Why use this: HP = torque (ft*lbf) * RPM/5252 ==> The 5252 is the constant for HP, which is obtained by Watts observation that a horse could pull 150lb, 220ft in one minute.

Instead of this: HP (ft-lbf/min) = {torque (ft-lbf) * (rev/min) * (2 * Pi) (rad/rev)} / [33,000 {(ft-lbf/min)/(HP)}]

Something that will be self explaining (of course, if someone that reads it, knows what he is reading!).

Should be made using Metric Units and English Units.

I will give preference to bidders who can provide what I want in the smallest time period.


What I need is the project to be done. Completely. Fully. In all it's extent. Period. I don't want half of a project, or partial something whatsoever. What I want is the complete project and this is what I am willing to get and, of course, pay for.

By this, I am creating one milestone only, to be released when all that I asked for up here is delivered. This is why I tried to be so criterious about each part. No exceptions will be made. PLEASE BID ONLY IF YOU ACCEPT THESE TERMS.

I've had some disappointing experience in the past and this is why I created this policy. Fortunately, the good experiences prevailed over the bad ones.

Kemahiran: Kejuruteraan, Excel, Matematik, Matlab and Mathematica, Fizik

Lihat lagi: you pull and pay, works need excel, work n gear, what is power up, what is engineering all about, spreadsheet engineering, pull and pay, power up reading, power up 2, power part 2, over rev, how excel works, good and the bad, work on physics, who provide the work excel, what is milestone, what is milestone ?, torque, speed up my, power transmission, milestone r, excel speed, Excel Formulas, excel 2013, engineering physics

Tentang Majikan:
( 35 ulasan ) BRASILIA, Brazil

ID Projek: #4085564

Dianugerahkan kepada:


I will help you RANS

$30 USD dalam sehari
(7 Ulasan)

i can do this work according to your requirements

$40 USD dalam 5 hari
(6 Ulasan)

5 pekerja bebas membida secara purata $36 untuk pekerjaan ini


Hi, Ready to start your work. Eagerly awaiting for your positive reply. Please check your inbox for further details. Thanks, Shaik.

$40 USD dalam 2 hari
(8 Ulasan)


$100 USD dalam 5 hari
(10 Ulasan)

I am reliable, responsible and disciplined. Hire me for this assignment.

$30 USD dalam 0 hari
(0 Ulasan)

I am very good at doing Excel related jobs. You will get 100% satisfaction after seeing my work done. """"" Can start from now itself """"" Please see private message also.

$40 USD dalam sehari
(0 Ulasan)