Anyone got a good race car spreadsheet I can use for ref?
Anyone got a good race car spreadsheet I can use for ref?
Author
Discussion

450Nick

Original Poster:

4,027 posts

241 months

Tuesday 29th January 2013
quotequote all
Does anyone have a sort of racecar spreadsheet I can use as a template? I'd like something where I can keep a list of all settings for the car, part numbers, fuse sizes, fluid types and amounts etc. Has anyone got anything I can use as a starting point? PS - ITS ALIVE!!!

450Nick

Original Poster:

4,027 posts

241 months

Wednesday 30th January 2013
quotequote all
No one...??

tbdgriff500

1,647 posts

232 months

Wednesday 30th January 2013
quotequote all
whats a spread sheet!!

ctsdave

872 posts

203 months

Wednesday 30th January 2013
quotequote all
Nick
Ive got something for settings etc i can ping across to you. As for parts and fluids etc, just write them in a notebook or somethng? Thats all we do...

Graham

16,381 posts

313 months

Wednesday 30th January 2013
quotequote all
kick the tyres and light the fires....

I've got a tuscan check list that I already need to dig out a copy for someone else I'll pop it together with the cage certificate on the web under downloads when i get a moment.


other stuff I just have is separate documents

450Nick

Original Poster:

4,027 posts

241 months

Wednesday 30th January 2013
quotequote all
Well my plan was to put together a spreadsheet for the car, and have several pages with the following bits of information:

- Nut & Bolt & fitting torques
- Consumable part numbers (belts, filters, plugs, etc)
- Number of track hours for each component on the car (eg bearings, clutch, seals, suspension components etc)
- Fluid types (brake, clutch, engine/gearbox/diff oil)
- Wiring diagrams, fuse sizes and relay part numbers
- Geo/aero/suspension/ECU setup data for each circuit, lap times

Probably a bit anal but I wanted to keep a good log of what is on the car, how long it has been on there and all that good stuff - I guess most people do it with note pads but I'm terrible with paper and I'll lose it within a month! Since it is likely to be a ballache to put together I thought I'd see if anyone had something similar to use as a starting point but no probs if not!

450Nick

Original Poster:

4,027 posts

241 months

Wednesday 30th January 2013
quotequote all
Graham said:
kick the tyres and light the fires....

I've got a tuscan check list that I already need to dig out a copy for someone else I'll pop it together with the cage certificate on the web under downloads when i get a moment.


other stuff I just have is separate documents
Thanks G that would be helpful... Still a little way off testing yet, but its running and I think we have brakes and clutch now so starting to think about actually driving the thing which seems like a pretty novel idea!

Graham

16,381 posts

313 months

Wednesday 30th January 2013
quotequote all
450Nick said:
- Geo/aero/suspension/ECU setup data for each circuit, lap times
My advice to anyone starting out is to put a known base setup on the car, and run with that for the first part of the season, obviously continuously checking it to make sure nothings changed, but not to constantly bugger about with the settings. You tend to find that your driving changes a lot so that you cant make sense of the setup changes your making.

keep the car setup a constant until your comfortable with what the car does in different situations, then when you get some testing time start to try different things.

the obvious exception to that is if the car is doing something nasty, then you do need to dial that out, but once happy then leave it to learn the car properly, otherwise you'll be constantly chasing your tail..

slinky

15,704 posts

278 months

Wednesday 30th January 2013
quotequote all
450Nick said:
Well my plan was to put together a spreadsheet for the car, and have several pages with the following bits of information:

- Nut & Bolt & fitting torques
- Consumable part numbers (belts, filters, plugs, etc)
- Number of track hours for each component on the car (eg bearings, clutch, seals, suspension components etc)
- Fluid types (brake, clutch, engine/gearbox/diff oil)
- Wiring diagrams, fuse sizes and relay part numbers
- Geo/aero/suspension/ECU setup data for each circuit, lap times

Probably a bit anal but I wanted to keep a good log of what is on the car, how long it has been on there and all that good stuff - I guess most people do it with note pads but I'm terrible with paper and I'll lose it within a month! Since it is likely to be a ballache to put together I thought I'd see if anyone had something similar to use as a starting point but no probs if not!
Once you've got something up and running, it would be very easy to log track hours and automatically generate a replacement list for over life or approaching life items..

450Nick

Original Poster:

4,027 posts

241 months

Wednesday 30th January 2013
quotequote all
Yup, totally agree with that and I suspect that's what we'll do, eventually though we will want to start changing things and I'll want to keep any changes wrapped up in a central location with all other data about the car so its easy to keep track of smile

450Nick

Original Poster:

4,027 posts

241 months

Wednesday 30th January 2013
quotequote all
slinky said:
Once you've got something up and running, it would be very easy to log track hours and automatically generate a replacement list for over life or approaching life items..
Yup this is the plan, so I can easily see when a component was last replaced and when its due replacement. This should make maintenance a bit easier to keep on top of.

Graham

16,381 posts

313 months

Wednesday 30th January 2013
quotequote all
on most of my lifed components I stamp / mark the install date on them I keep a separate date/ time / no laps location/ event type db.


I have a record of all track time going back to when i started in 2000!

tbdgriff500

1,647 posts

232 months

Wednesday 30th January 2013
quotequote all
f@ck me !!
i am doing this all wrong!
1)look at it
2)ask rob if all is ok
3)get in it and rag it
4)get rob to check it before the next race
5)replace anything that fell off

biggrin

450Nick

Original Poster:

4,027 posts

241 months

Wednesday 30th January 2013
quotequote all
tbdgriff500 said:
f@ck me !!
i am doing this all wrong!
1)look at it
2)ask rob if all is ok
3)get in it and rag it
4)get rob to check it before the next race
5)replace anything that fell off

biggrin
Lol, I work as an engineer in oil and gas - I live this st so it comes naturally

7 TVR

2,589 posts

197 months

Wednesday 30th January 2013
quotequote all
tbdgriff500 said:
f@ck me !!
i am doing this all wrong!
1)look at it
2)ask rob if all is ok
3)get in it and rag it
4)get rob to check it before the next race
5)replace anything that fell off

biggrin
+1 For this approach as mine has not moved since i put it in the garage after Oulton smile

ctsdave

872 posts

203 months

Wednesday 30th January 2013
quotequote all
I spanner mine myself so it's always checked! Got a sheet for how the car is set up on the day (tyre pressures, suspension etc...) but that's it! I don't keep a check on the life of components... If a wheel bearing starts to have a slight bit of play I'll replace it and so with other stuff... Keep your rose joints and UJ's etc well lubricated and they last a good while!

The Griff is sat in the back of the trailer at the moment with no heart frown Hoping to get the MGB Roadster I've got in the garage (5ltr no less) sold soon to make space and free up some cash to get on with the racer soon!

TVRSH

368 posts

209 months

Wednesday 30th January 2013
quotequote all
Man after my own heart Tim - if it ain't broke don't fix it! Mind you the Griff was in need of major surgery prior to last season! Good news is I passed my eye test today at the third attempt - what a nice doc! So I'm still racing and dangerous, but only in CSCC Future Classics this year - my last year it seems.

bill tvr

359 posts

207 months

Thursday 31st January 2013
quotequote all
tbdgriff500 said:
f@ck me !!
i am doing this all wrong!
1)look at it
2)ask rob if all is ok
3)get in it and rag it
4)get rob to check it before the next race
5)replace anything that fell off

biggrin
:Brill...so true

Graham

16,381 posts

313 months

Thursday 31st January 2013
quotequote all
Tim you forgot the most important one


6) Find the money

itsallyellow

3,875 posts

249 months

Thursday 31st January 2013
quotequote all
tbdgriff500 said:
f@ck me !!
i am doing this all wrong!
1)look at it
2)ask rob if all is ok
3)get in it and rag it
4)get rob to check it before the next race
5)replace anything that fell off

biggrin
Sound like a lot of hassle to me

1. Dad make it work!
2. Rag it
3. Dad make it work!

Mike