|
Post by boldaussie on Feb 19, 2018 21:57:05 GMT 10
Hi guys A project I had been working on which is still unfinished but more than usable how it is. You must have Microsoft excel installed to use it AND have extracted hdv files to use with it. Will pull most hdv files into it and calculations done automatically. You can then compare your setups against defaults and adjust accordingly to suit the balance you ordinarily like in your car Hope you like it, feedback welcome. Cheers File available on request Request only if you have Microsoft Excel installed and the ability to extract hdv files from vehicle mas files when not encrypted. Thank you Attachments:
|
|
|
Post by daniel on Feb 20, 2018 13:23:38 GMT 10
Havent used excel in 10 years or so, this might be a dumb question then. How do I import the hdv? Also I’m using excel online so I dunno if it works but I’m willing to mess around and see if it does. Thanks.
|
|
|
Post by boldaussie on Feb 20, 2018 16:40:19 GMT 10
Hi Dan, As if you need any leg ups....LOL Once you have extracted the HDV file from the 'vehicle name' main.mas with the rfactor mas tool, you load my excel file into excel, read the read me first, allow macros, your choice and select the crit damping page ( either/or ) and select the big pink/purple button and navigate to where you extracted your HDV file and select it, it does the rest. Its actually the whole point of it..............ITS WAyyyyyyyyyyyyyyyyy better than manually inputing everything into a spreadsheet, let alone find all the info you want to use. It takes seconds, not forever If you are comparing my calculated results to your own setup save files, you open the hdv FIRST, then using the big yellow button import your svm (setup file, best also if you copy any of these files to where your hdv file was extracted ) of that vehicle, which will update spring setting and calculate best damping for that. Do this via the crit damping multiplier first and then the fine tune section top right where you alter percentages to get closer matches to your setup file results. Bear in mind that if you're used to a particular damper/balance setup any of this may seem weird and a waste of time. Its a tool that may be useful, or not, for you. Most of the time vehicle dependent, you will be using 1.5 or 2 times rebound damping and largely leaving bump alone, but I start with crit damping figures which are about 2.5 X rebound vs bump and reduce rebound only to get the feel right. The top right section is to alter percentages to suit the natural way you tend to set up your cars, via using your best setups, which gives you a head start in setting new cars up for practice sessions. Hope this helps. Happy to try and answer relevant questions if I can I will one day set it up so it will also write svm files to make it even more helpful
|
|
|
Post by daniel on Feb 20, 2018 18:40:33 GMT 10
Oh yes I hope this makes me faster cause Josh still beats me, lol. I still have some things to learn about setup for sure, I’m still not that good with damper setup. But I think I’m going to have to “aquire” a copy of excel cause I don’t think it works with excel online, I can’t for the life of me find the pink/purple button you speak of. Either that or I’m stupid which is more than likely. Would you be so kind as to upload a screenshot of it so I can confirm whether it is I or Microsoft that is stupid? I think maybe the online one ignores scripts without telling me so. Thanks Aussie.
|
|
|
Post by daniel on Feb 20, 2018 20:57:03 GMT 10
Thanks for that, yeah excel online obviously ignores scripts so the buttons aren’t there. I’ll get my hands on a copy of excel next few days. Any chance you could send Josh a sabotaged speadsheet? 😂
|
|