Jump to content


Mjk Tyre Selector


27 replies to this topic

#1 shadow_rusty

    "Team ABC" Team Leader

  • Members
  • PipPipPipPipPip
  • 3,333 posts
  • Gender:Male
  • Location:Canberra

Posted 28 February 2013 - 06:38 PM

I got annoyed looking for the right tyre in the printed out 2011 catalog. So, I did what any IT geek would do... Firstly I printed the .PDF using XPS document printer, then ran it through Document Imaging OCR to create a text file. Then I re-formatted it to a .CSV file, which allow me to make myself an excel spreadsheet with all of the MJK tyres in it.

A big thanks to Andrew for giving me the knowledge that somtimes the 'right' tyre is not necessarly the 'best' tyre...
So, armed with that knowledge, I then created a lookup table, so that I could narrow down the list of tyres to find the right tyre based on the rim Dimensions...

Anyway, here's a screenshot...
Posted Image

And for those of you who would like to use it themselves, MJK 2011 Catalog.xlsm, and MJK 2013 Catalog.xlsm

Update: Online Version Now Available - MJK Tyre Selector - Google Sheets Version

edit: You will need to enable macros for the auto lookup to work.
edit 2: if there are no results, it means that there are no tyres within -5% and +10% of each variable
edit 3: New 2013 Catalog released and spreadsheet has now been updated
edit 4: Google Sheets version has now been released
edit 5: Added adjustable Accuracy % to google sheets version

Anyway, I hope you guys like it...

ps. As the most recent catalog on the MJK website is from October 2011, if there have been any tyres released since then, I may not have them on my list...

Edited by shadow_rusty, 31 January 2018 - 09:17 AM.

Posted Image
Stolen from SlotsNZ

Team ABC Team Leader
(Ambitious, But Crap)


Home Track Threads - Shadow's Semi-Permanent Layout & Another Rug Racer & Proud of It & Gymkhana Test Track
Car Collection Thread - My Car Collection
Charts / Diagrams - MJK Tyre Selector
/ Slot.it 4wd Gearing / PoliCar Rollout / [size=3]Rollout Chart Generator / SCX 4wd Rollout / Track Wiring with Brake on Track Call

#2 Ember

    Possible diorama queen

  • Super Moderator
  • PipPipPipPipPipPipPip
  • 8,238 posts
  • Gender:Female
  • Location:Hamilton, Victoria

Posted 28 February 2013 - 08:23 PM

Nice work. There have been quite a few added since 2011, but not sure how many.
Computers. They'll never catch on.

Posted Image

Tiny Tyers Targa - The build saga continues - Aging wood - A recipe for staining wood - Don't take a fence - Step by step paling fence - An old shed for my new cars - Wooden garage under construction

#3 shadow_rusty

    "Team ABC" Team Leader

  • Members
  • PipPipPipPipPip
  • 3,333 posts
  • Gender:Male
  • Location:Canberra

Posted 28 February 2013 - 09:03 PM

Thanks Embs...

If anyone can advise me of the details you see in the image above for any new tyres, I'll happily add it to the spreadsheet...

Currently in the spreadsheet the last part number in each catagory is as below...
Rear 1/32 tyres - '4273'
Front 1/32 tyres - '4409'
Rear 1/24 tyres - '4118'
Front 1/24 tyres - '4303'
Posted Image
Stolen from SlotsNZ

Team ABC Team Leader
(Ambitious, But Crap)


Home Track Threads - Shadow's Semi-Permanent Layout & Another Rug Racer & Proud of It & Gymkhana Test Track
Car Collection Thread - My Car Collection
Charts / Diagrams - MJK Tyre Selector
/ Slot.it 4wd Gearing / PoliCar Rollout / [size=3]Rollout Chart Generator / SCX 4wd Rollout / Track Wiring with Brake on Track Call

#4 ZeGas

    ZeGas

  • Members
  • PipPipPip
  • 1,127 posts
  • Gender:Male
  • Location:Mundoolun, QLD

Posted 28 February 2013 - 09:05 PM

OMG thanks very much,
I have been trying to match up some new alloy rims and tyres for my DBR9 and tyres to suit so that I get the same end result, what a mission this will definitely help with that process.
Thanks again you busy boy you.
Cheers Grant
Posted Image.......................................................Posted Image
Home Track..........Corvette C1 Build..........McLaren M1A Build..........Maserati 300S Build..........Allard J2 Build..........50's Diner..........Iso Griffo A3C

3D Printed Adjustable Chassis ($15+pp)

If life gives you lemons, take them, free s#!t is cool.

Instagram:.....__ZeGas__

#5 triggy

    Triggy

  • Members
  • PipPipPip
  • 1,544 posts
  • Gender:Male
  • Location:South of Adelaide

Posted 28 February 2013 - 09:20 PM

Great ezy find tool. Thanks
* Avatar used with permission

Normal people worry me

#6 Ember

    Possible diorama queen

  • Super Moderator
  • PipPipPipPipPipPipPip
  • 8,238 posts
  • Gender:Female
  • Location:Hamilton, Victoria

Posted 28 February 2013 - 09:32 PM

Armchair have the most up to date list that I know of. Or you could email the MJK boys, tell them what you've done and ask them for the missing information.

I know they've released tyres for the Torana and SCX 'Cuda since the 2011 list was done. I'm sure there were others in 2012 as well.
Computers. They'll never catch on.

Posted Image

Tiny Tyers Targa - The build saga continues - Aging wood - A recipe for staining wood - Don't take a fence - Step by step paling fence - An old shed for my new cars - Wooden garage under construction

#7 shadow_rusty

    "Team ABC" Team Leader

  • Members
  • PipPipPipPipPip
  • 3,333 posts
  • Gender:Male
  • Location:Canberra

Posted 28 February 2013 - 09:45 PM

THanks guys...

Embs,
Thanks for that... Both of those cars are already on the list...
So it's possible the catalog has been updated, but the year on the front page wasn't...

To be sure, I've emailed MJK to see if they have a current catalog...
Posted Image
Stolen from SlotsNZ

Team ABC Team Leader
(Ambitious, But Crap)


Home Track Threads - Shadow's Semi-Permanent Layout & Another Rug Racer & Proud of It & Gymkhana Test Track
Car Collection Thread - My Car Collection
Charts / Diagrams - MJK Tyre Selector
/ Slot.it 4wd Gearing / PoliCar Rollout / [size=3]Rollout Chart Generator / SCX 4wd Rollout / Track Wiring with Brake on Track Call

#8 Ember

    Possible diorama queen

  • Super Moderator
  • PipPipPipPipPipPipPip
  • 8,238 posts
  • Gender:Female
  • Location:Hamilton, Victoria

Posted 28 February 2013 - 09:48 PM

That's always a possibility. And while you're at it, ask them when the XB tyres are due out. :)
Computers. They'll never catch on.

Posted Image

Tiny Tyers Targa - The build saga continues - Aging wood - A recipe for staining wood - Don't take a fence - Step by step paling fence - An old shed for my new cars - Wooden garage under construction

#9 ZeGas

    ZeGas

  • Members
  • PipPipPip
  • 1,127 posts
  • Gender:Male
  • Location:Mundoolun, QLD

Posted 28 February 2013 - 09:50 PM

just been playing with it and the table isn't populating, is there some trick I don't know about or do you have to be super accurate with measurements
I put in 14 rim dia and 8.5 step and nothing appears in the table although this is the dims for the vanquish on tab2 of the spreadsheet.
Yes I have check autocalc is on.

Right just reread your first post 5% to 10%
ignore above, sorry to all for lack of reading ability.

Edited by ZeGas, 28 February 2013 - 09:55 PM.

Cheers Grant
Posted Image.......................................................Posted Image
Home Track..........Corvette C1 Build..........McLaren M1A Build..........Maserati 300S Build..........Allard J2 Build..........50's Diner..........Iso Griffo A3C

3D Printed Adjustable Chassis ($15+pp)

If life gives you lemons, take them, free s#!t is cool.

Instagram:.....__ZeGas__

#10 shadow_rusty

    "Team ABC" Team Leader

  • Members
  • PipPipPipPipPip
  • 3,333 posts
  • Gender:Male
  • Location:Canberra

Posted 28 February 2013 - 09:55 PM

Do you have macros enabled?

Edit: I've put a -5% / +10% tollerances into the formulaes already, but I have noticed that some MJK dimensions are a little off when compared to real life...
My pic above shows the real life size of a Camaro rim, and the MJK specs for the same rim. Thankfully, the MJK tyre fits just fine...

Unfortunately, you will need to fill in all of the fields too...
  • i.e. Rim Diameter, Rim Width, Step Diameter, Step Width on the left,
  • or
  • Rim Diameter & Step Width on the right...
But for 14 and 8.5 I get 2 results...
4201 - Suit Vanquish Rear - 14,13,15.7,8.5,21.6,14
4256 - Suit Carrera Capri RS3100 - 14.2,12,17.6,8.2,20,13

Edited by shadow_rusty, 28 February 2013 - 10:06 PM.

Posted Image
Stolen from SlotsNZ

Team ABC Team Leader
(Ambitious, But Crap)


Home Track Threads - Shadow's Semi-Permanent Layout & Another Rug Racer & Proud of It & Gymkhana Test Track
Car Collection Thread - My Car Collection
Charts / Diagrams - MJK Tyre Selector
/ Slot.it 4wd Gearing / PoliCar Rollout / [size=3]Rollout Chart Generator / SCX 4wd Rollout / Track Wiring with Brake on Track Call

#11 ZeGas

    ZeGas

  • Members
  • PipPipPip
  • 1,127 posts
  • Gender:Male
  • Location:Mundoolun, QLD

Posted 28 February 2013 - 10:14 PM

Yeah I had macros enabled

ARGH you mentioned the "C" word. (Capri)
Still a sore point atm :angry:

After a restart it worked fine
I'll blame Bill Gates or his successor.

Thanks for the time to put this together, now get outside and get a life :D
Cheers Grant
Posted Image.......................................................Posted Image
Home Track..........Corvette C1 Build..........McLaren M1A Build..........Maserati 300S Build..........Allard J2 Build..........50's Diner..........Iso Griffo A3C

3D Printed Adjustable Chassis ($15+pp)

If life gives you lemons, take them, free s#!t is cool.

Instagram:.....__ZeGas__

#12 Caddo

    Kart Driver

  • Members
  • PipPip
  • 847 posts
  • Gender:Male
  • Location:Kellyville Sydney

Posted 28 February 2013 - 10:22 PM

Thanks Shadow_Rusty, great work :)

#13 32coupe

    Kart Driver

  • Members
  • PipPip
  • 467 posts
  • Gender:Male
  • Location:Canberra

Posted 01 March 2013 - 07:43 AM

Hi Michael
Glad I could inspire you to achieve such great things but, the link won't open for me here at work, all I get is "code".
Any chance of emailing me a copy?

Cheers
Andrew
If you can't fix it with a hammer, you have an electrical problem.

#14 shadow_rusty

    "Team ABC" Team Leader

  • Members
  • PipPipPipPipPip
  • 3,333 posts
  • Gender:Male
  • Location:Canberra

Posted 01 March 2013 - 07:51 AM

Thanks again guys...

Email sent Andrew...
Posted Image
Stolen from SlotsNZ

Team ABC Team Leader
(Ambitious, But Crap)


Home Track Threads - Shadow's Semi-Permanent Layout & Another Rug Racer & Proud of It & Gymkhana Test Track
Car Collection Thread - My Car Collection
Charts / Diagrams - MJK Tyre Selector
/ Slot.it 4wd Gearing / PoliCar Rollout / [size=3]Rollout Chart Generator / SCX 4wd Rollout / Track Wiring with Brake on Track Call

#15 shadow_rusty

    "Team ABC" Team Leader

  • Members
  • PipPipPipPipPip
  • 3,333 posts
  • Gender:Male
  • Location:Canberra

Posted 10 October 2013 - 10:22 AM

View Postshadow_rusty, on 28 February 2013 - 06:38 PM, said:

Updated Catalog: MJK 2013 Catalog.xlsm

edit 3: New 2013 Catalog released and spreadsheet has now been updated
Catalog has been updated (Thanks Gaz), and spreadsheet updated...
Posted Image
Stolen from SlotsNZ

Team ABC Team Leader
(Ambitious, But Crap)


Home Track Threads - Shadow's Semi-Permanent Layout & Another Rug Racer & Proud of It & Gymkhana Test Track
Car Collection Thread - My Car Collection
Charts / Diagrams - MJK Tyre Selector
/ Slot.it 4wd Gearing / PoliCar Rollout / [size=3]Rollout Chart Generator / SCX 4wd Rollout / Track Wiring with Brake on Track Call

#16 shadow_rusty

    "Team ABC" Team Leader

  • Members
  • PipPipPipPipPip
  • 3,333 posts
  • Gender:Male
  • Location:Canberra

Posted 25 March 2014 - 12:50 PM

Spreadsheet has been updated again...
http://www.users.on....%20Catalog.xlsm

Added the new rims, and Ninco GoKart tyres...
Also tweaked the lookup section...
Posted Image
Stolen from SlotsNZ

Team ABC Team Leader
(Ambitious, But Crap)


Home Track Threads - Shadow's Semi-Permanent Layout & Another Rug Racer & Proud of It & Gymkhana Test Track
Car Collection Thread - My Car Collection
Charts / Diagrams - MJK Tyre Selector
/ Slot.it 4wd Gearing / PoliCar Rollout / [size=3]Rollout Chart Generator / SCX 4wd Rollout / Track Wiring with Brake on Track Call

#17 ZeGas

    ZeGas

  • Members
  • PipPipPip
  • 1,127 posts
  • Gender:Male
  • Location:Mundoolun, QLD

Posted 25 March 2014 - 01:20 PM

Thanks for your time in doing this and keeping it updated S.R.
Been meaning to ask, can the tabs be copied and still stay live, I have tried but they loose the formulas.
I want to copy each tab so that I have it set up for each car.
It's not a biggie as I can use the original and copy once I have the data imputed.
Just a Q of curiosity really.
Cheers Grant
Posted Image.......................................................Posted Image
Home Track..........Corvette C1 Build..........McLaren M1A Build..........Maserati 300S Build..........Allard J2 Build..........50's Diner..........Iso Griffo A3C

3D Printed Adjustable Chassis ($15+pp)

If life gives you lemons, take them, free s#!t is cool.

Instagram:.....__ZeGas__

#18 shadow_rusty

    "Team ABC" Team Leader

  • Members
  • PipPipPipPipPip
  • 3,333 posts
  • Gender:Male
  • Location:Canberra

Posted 25 March 2014 - 02:09 PM

The formulas are linked to the 'code' on the tab...

If you right click on the 'Lookup' tab, and go 'View Code', you can copy the code to a new tab and it should work...
If you can't get it to work, let me know and I'll build you a special sheet...
Posted Image
Stolen from SlotsNZ

Team ABC Team Leader
(Ambitious, But Crap)


Home Track Threads - Shadow's Semi-Permanent Layout & Another Rug Racer & Proud of It & Gymkhana Test Track
Car Collection Thread - My Car Collection
Charts / Diagrams - MJK Tyre Selector
/ Slot.it 4wd Gearing / PoliCar Rollout / [size=3]Rollout Chart Generator / SCX 4wd Rollout / Track Wiring with Brake on Track Call

#19 ZeGas

    ZeGas

  • Members
  • PipPipPip
  • 1,127 posts
  • Gender:Male
  • Location:Mundoolun, QLD

Posted 25 March 2014 - 04:59 PM

Yeah, The only VB I understand has a tab on top not the bottom. :D
Cheers Grant
Posted Image.......................................................Posted Image
Home Track..........Corvette C1 Build..........McLaren M1A Build..........Maserati 300S Build..........Allard J2 Build..........50's Diner..........Iso Griffo A3C

3D Printed Adjustable Chassis ($15+pp)

If life gives you lemons, take them, free s#!t is cool.

Instagram:.....__ZeGas__

#20 shadow_rusty

    "Team ABC" Team Leader

  • Members
  • PipPipPipPipPip
  • 3,333 posts
  • Gender:Male
  • Location:Canberra

Posted 25 March 2014 - 11:05 PM

View Postshadow_rusty, on 25 March 2014 - 12:50 PM, said:

Spreadsheet has been updated again...
http://www.users.on....%20Catalog.xlsm

Added the new rims, and Ninco GoKart tyres...
Also tweaked the lookup section...
Oops... There was a mistake on one of the tabs...

Updated again...

View PostZeGas, on 25 March 2014 - 04:59 PM, said:

Yeah, The only VB I understand has a tab on top not the bottom. :D
Hmmm, the coding was a little more embedded than I thought...
Currently working on a 10 lookup page for you...
Posted Image
Stolen from SlotsNZ

Team ABC Team Leader
(Ambitious, But Crap)


Home Track Threads - Shadow's Semi-Permanent Layout & Another Rug Racer & Proud of It & Gymkhana Test Track
Car Collection Thread - My Car Collection
Charts / Diagrams - MJK Tyre Selector
/ Slot.it 4wd Gearing / PoliCar Rollout / [size=3]Rollout Chart Generator / SCX 4wd Rollout / Track Wiring with Brake on Track Call





1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users