Go Back  R/C Tech Forums > General Forums > Electric On-Road
Excel top speed calculator >

Excel top speed calculator

Community
Wiki Posts
Search

Excel top speed calculator

Thread Tools
 
Search this Thread
 
Old 12-20-2007, 07:25 AM
  #1  
Tech Elite
Thread Starter
iTrader: (1)
 
joe of loath's Avatar
 
Join Date: Mar 2007
Location: Bristol, England, United Kingdom
Posts: 4,857
Trader Rating: 1 (100%+)
Talking Excel top speed calculator

i made this because i was bored, and because i wanted to know my top speed not my rollout. i think i got it right, so if theres anything wrong tell me.

btw its defaulted to an 'out of the box' HPI E10. and as it says, only edit the yellow cells or you'll break it

if you have no internal gear ratio, then set it to 1.

Joe

p.s i added an extra unit of speed for all you speed freaks!
Attached Files
File Type: zip
speed calculator 1.21.zip (5.2 KB, 491 views)

Last edited by joe of loath; 12-20-2007 at 02:28 PM.
joe of loath is offline  
Old 12-20-2007, 08:30 AM
  #2  
Tech Fanatic
iTrader: (15)
 
gacjr0's Avatar
 
Join Date: Dec 2002
Posts: 796
Trader Rating: 15 (100%+)
Default

from what I saw, theres no Pi in your formulas anywhere, and your overall gear ratio needs to be spur/pinion * internal gear ratio.

you can fudge aerodynamic drag by multiplying by .95 or .8 or pick a number less than 1, or you could figure out/find the formula for drag

good luck
gacjr0 is offline  
Old 12-20-2007, 12:01 PM
  #3  
Tech Elite
Thread Starter
iTrader: (1)
 
joe of loath's Avatar
 
Join Date: Mar 2007
Location: Bristol, England, United Kingdom
Posts: 4,857
Trader Rating: 1 (100%+)
Default

hmm strange, it seems to work..... i know, i should replace diameter with circumfrence.
joe of loath is offline  
Old 12-20-2007, 12:06 PM
  #4  
Tech Elite
Thread Starter
iTrader: (1)
 
joe of loath's Avatar
 
Join Date: Mar 2007
Location: Bristol, England, United Kingdom
Posts: 4,857
Trader Rating: 1 (100%+)
Default

Originally Posted by gacjr0
from what I saw, theres no Pi in your formulas anywhere, and your overall gear ratio needs to be spur/pinion * internal gear ratio.

you can fudge aerodynamic drag by multiplying by .95 or .8 or pick a number less than 1, or you could figure out/find the formula for drag

good luck
i'm still not sure how to work out inernal gear ratio. i did it as 7.48 (final ratio) minus 4.25 (spur/pinion)... total bodge job!

oh and aerodynamic drag is exponential (or is it squared or cubed) anyway it isnt linear....


EDIT: a bit of trial and error later i seem to have my internal gear ratio sorted, but still no formula... it works as logn as you know it!

EDIT: it wont work.. somethings wrong :'(

EDIT: ok i got it working! there were some relics in the equations from when i was working in millimeters.

Last edited by joe of loath; 12-20-2007 at 12:59 PM.
joe of loath is offline  
Old 12-20-2007, 01:12 PM
  #5  
Tech Elite
Thread Starter
iTrader: (1)
 
joe of loath's Avatar
 
Join Date: Mar 2007
Location: Bristol, England, United Kingdom
Posts: 4,857
Trader Rating: 1 (100%+)
Default

ok it seems to work now.

btw this is just a bump TTT
^
|
|
|

EDIT: now changed tyre diameter into MM from meters

Last edited by joe of loath; 12-21-2007 at 02:17 PM.
joe of loath is offline  
Old 05-19-2008, 10:34 AM
  #6  
Tech Elite
Thread Starter
iTrader: (1)
 
joe of loath's Avatar
 
Join Date: Mar 2007
Location: Bristol, England, United Kingdom
Posts: 4,857
Trader Rating: 1 (100%+)
Default

bump, just in case someone actually cares.


p.s. IT WORKS!
joe of loath is offline  
Old 05-19-2008, 01:46 PM
  #7  
Tech Master
iTrader: (21)
 
shadow102's Avatar
 
Join Date: Feb 2008
Posts: 1,441
Trader Rating: 21 (96%+)
Default

anybody got an idea of the RPM of a 4.5R brushless motor?
shadow102 is offline  
Old 05-19-2008, 09:53 PM
  #8  
Tech Regular
iTrader: (3)
 
SpidarX's Avatar
 
Join Date: Dec 2006
Location: San Antonio
Posts: 469
Trader Rating: 3 (100%+)
Default

When trying to open the file, it says the file is corrupted.
SpidarX is offline  
Old 05-20-2008, 03:38 AM
  #9  
Tech Elite
Thread Starter
iTrader: (1)
 
joe of loath's Avatar
 
Join Date: Mar 2007
Location: Bristol, England, United Kingdom
Posts: 4,857
Trader Rating: 1 (100%+)
Default

Originally Posted by shadow102
anybody got an idea of the RPM of a 4.5R brushless motor?
Kv * volts

so for a 6600kv motor it's 6600*7.2(or 7.4 if running lipo)
joe of loath is offline  

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

Copyright © 2024 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.