Visit The Dirt Forum for More Information

Author Topic:   Homemade Scale tool.
Mikey14
Dirt Freak

Total posts: 265
posted October 24, 2003 01:23 PM  
We have digital kart scales I thought about making the ones in the tool section to use with those for our Factory Stock. I did make a Microsoft excel spreadsheet that does all the math for you if anyone is interested. I can't post it here and don't have a website to host it on but I can e-mail it. If anyone wants to host it somewhere they are more than welcome to. I could also adjust one to factor in the X 4 multiplier so that it does that math for you too. I'll try to post a picture of the screen with the spreadsheet up. It has other features to like a lap timing/tracking sheet which is handy for seeing your improvement over the leaders times. I'll post pictures of that too.

If anyone wants this or is willing to host it for others to get let me know.

Mikey14
Dirt Freak

Total posts: 265
posted October 24, 2003 01:35 PM  

 
Here's the two screen shots of the spreadsheet.

I just figured out I can zip the excel and post it!

Mikey14
Dirt Freak

Total posts: 265
posted October 24, 2003 01:41 PM  
OK, I guess I used up all my file post ability! Only 3 so I can't post a picture of the scale sheet. or the zip file. Anyone want it and I'll e-mail it to you.

Sorry!!

jay116
Dirt Freak

Total posts: 428
posted October 26, 2003 05:42 PM  
I just saw yours. Not bad, I e-mailed you mine too. One difference is I usually focus on nose weight instead of rear. It's the same thing but when I list results I list left, cross and nose. Most everyone else list left cross and rear. The numbers are the same of course, its just details.

Feel free to post it on you site if you like it. I can add in the X 4 multiplier too if you'd like.

ssr1st
Dirt Full Roller

Total posts: 61
posted October 29, 2003 12:18 PM  
how did you guys get the stuff to do the math and stuff for you its pritty neat id like to learn

Mikey14
Dirt Freak

Total posts: 265
posted October 29, 2003 01:50 PM  
Jason's got it on his website now. Its under the homemade scales pages. He also added in his reverse scaling tab so it makes it even better.

I know excel pretty decent. Most of the math for scaling is easy, but if you look at the lap times stuff that is some higher math there. I knew the formula, but excel doesn't like to add time up without relating it to a date/time of day. so if your adding laps up it bases the math on a scale of 100 seconds = 1 minute instead of a scale of 60 seconds = 1 minute.

The HP formula I took from some website and added it to excel. I had one for MPH too that was based on tire rollout, RPM and gear ratio but I can't remember what document I had that in.

ssr1st
Dirt Full Roller

Total posts: 61
posted October 29, 2003 02:55 PM  
yes i did notice it on his site. and its pritty neet. Un like you i dont know much in excel i use it for modeling cars for dtr but thats a hole other subject but i would like to know how to make excel add stuff on its own do you have aim or msn i could talk to you on ?

ssr1st
Dirt Full Roller

Total posts: 61
posted October 29, 2003 09:06 PM  
I got looking at it its real simpel i added a page for points and has a caculator to just meesing around seeing what i can do pritty basic stuff. Im also Working on one for gear ratio and ill try other things but im learing somthing new every day lol

[This message has been edited by ssr1st (edited October 29, 2003).]

Mikey14
Dirt Freak

Total posts: 265
posted October 31, 2003 01:12 AM  
most of the math in excel can be created by using the = in the cell.

Click on one of the scale % totals and see it will say something like: =C3/C5

This simply is whatever number is in cell C3 divided by the number in C5. Using the = and clicking on the cells you want for that equation adds them into the formula.

Play around with it, you'll be surprised at how much you can self teach.

Wanna see some crazy math, look on the laptimes sheet at the bottom where it adds the total time up. That truely was harder than chinese algebra!!

ssr1st
Dirt Full Roller

Total posts: 61
posted October 31, 2003 09:19 PM  
yeh i was playing around its pritty easy for sipel stuff i made some lap time and gear caculators stuff like that just messing around having fun

dan ferry
Dirt Maniac

Total posts: 183
posted November 11, 2003 05:46 PM  
can anyone tell me where i can find the plan for the homemade scales thats supposed to b in tool section? id like to see it so i can make them

ssr1st
Dirt Full Roller

Total posts: 61
posted November 11, 2003 06:24 PM  
They are in the toolbox at the very botom on the right hand side there just photos you click on to get the biger photo

jay116
Dirt Freak

Total posts: 428
posted November 18, 2003 01:50 PM  
Thanks to Mickey14 I made some improvements to the spreadsheet on our site.
I fixed the the cross weight in the reverse scale. And just made over all improvements to the whole look of the sheet.

------------------
Jason Boivin
http://www.rcracing-team.com

Back to the Archives