Page 1 of 1

Gp2 Manager Tool

Posted: 20.01.2010, 09:38
by MaxX
Due I really like the idea of MaxD`s championship and designed a small tool for Jake`s GPWC I want to make one Excel based tool with many options.

It will be fully customizable, so if you don`t want to use some features just set the corresponding parameter to 0.

Please let me know what could be solved better or which features would also make sense. I`m also planning to combine this with my GP2-career tool, just in case you want to be manager and driver at the same time ;)

Feature-list will be edited

Basics:
+ Up to 14 teams are supported - implemented
+ 16 races per season are supported - implemented
+ GP2Edit values will be calculated and shown automatically - implemented
+ Points table for drivers and teams are shown - implemented
+ Once the parameters are set it should be very easy to use - hopefully implemented ;)

Sponsorship:
+ Depending on the place in last year`s championship, you can set starting budgets. The Champions have more budget than weak or new teams - implemented
+ Depending on the place in last year`s championship, you can set the bonus sponsorship on prize money (Prizemoney * Amount of bonus) - implemented
+ The official Bonusmoney can be set for each position - implemented

Chassis:
+ 6 customizable chassistypes giving different costs, basic stats on grip, rel and randomization - implemented

Engines:
+ 30 customizable enginetypes having different costs, bhp and rel - implemented
+ Choosable contracts types: customer, semi-works (50% prize reduction) and works (100% prize reduction) - implemented

Tyres:
+ 15 customizable tyres having different costs, qual grip, race grip, random and rel - implemented

Drivers:
+ 89 fully customizable drivers with different salary, sponsorship money, qual grip, race grip and random - implemented
+ Calculated Stats for total races, victories, etc. - planned
+ Boni/Mali depending on age (for instance: younger drivers have a higher random value, older drivers fewer grip) - planned
+ Calculated Driver Grip changes for next season based upon results & randomization (maybe using experience points) - planned
+ Drivers can give a bonus on reliability - implemented

Results:
+ Points can be awarded for each position, Pole and Fastest Lap - implemented
+ Maximum values can be defined for bhp, grip, random and rel - implemented
+ Starting values can be defined for bhp, grip, random and rel - implemented
+ MaxD`s Bonus System (for instance +10 grip for fastest lap, -100 rel for a puncture) can be used to give a bonus for good finishing positions or to give a penalty for good positions to keep the field closer (like the use it in Touring cars) - implemented
+ Results can be entered on a seperate tab - implemented

Tuning:
+ bhp, grip values, randomization and rel can be improved - implemented

Re: Gp2 Manager Tool

Posted: 20.01.2010, 12:20
by HF
wow, sounds nice! would be the perfect thing for "lazy" persons like me ;)

Re: Gp2 Manager Tool

Posted: 21.01.2010, 09:12
by jakesanson
This sounds very exciting! Looking forward to it.

Re: Gp2 Manager Tool

Posted: 21.01.2010, 11:17
by MaxX
I want to revise my fictional carset and then drive a fictional career with it using this tool. ;)

Drivers will also be able to give a bonus on reliability. This makes sense for employing test drivers or slower drivers but with good technical knowledge.

Does anybody know how the player grip value works in GP2 Edit? I also want to implement this feature. For instance I have this values at the start of the season:

Driver base grip: 10.000 (best driver)
Chassis base grip: 4.000
Tyres base grip: 1.000

Total grip at season start for this driver would be 15.000. I limit the total max grip value to 16.100.

Ok, but now I need to ajust the player grip to similar values, considered that the player has the same grip as the best driver. So if i use the standart 170 the player has the best grip at start of the season and an unfair advantage due this fact. After the calculation the player grip should be equally to the 15.000 of the best pilot at start of the season and be affected due upgrades in the season. Can anyone help me? Thanks in advance

Re: Gp2 Manager Tool

Posted: 24.01.2010, 20:32
by rremedio
I've had a similar project but it's dead now...but I can help you if you want. I'm a VBA expert 8)

I think the best way to control the player performance is to use 0xdd 0xd2 commands in the track for changing the human grip. You can also patch the game directly (just like Belini's GP3 Grip Patch, I can help you to implement this in your excel sheet). So you must setup the race in a way the ccs have the same performance as the player when they have the same BHP and grip 16384. Then if you want to drive a lower team you just need to set the grip (using track commands, or patching the game) to a value close to the performance values that team have in GP2Edit.

I guess you should let GP2Edit grip value to give you the driving feeling you want.

My english always sucks when trying to explain such things.

Re: Gp2 Manager Tool

Posted: 25.01.2010, 12:22
by MaxX
Some help would be great thx, currently I have no idea how to implement that. But due I want to have the other things working first, I didn`t put too much efforts into this so far ;)

The tool itself uses no VBA so far, due I want to have it working with any Excel or OpenOffice version. My VBA skills are pretty rusty, I last programmed years ago ;) I can send you what I have got so far, so you can understand better how currently works :)

Re: Gp2 Manager Tool

Posted: 25.01.2010, 14:19
by rremedio

Re: Gp2 Manager Tool

Posted: 25.01.2010, 15:13
by MaxX
Sent it to you :wink:

It`s pretty Beta though

Re: Gp2 Manager Tool

Posted: 27.01.2010, 15:44
by rremedio
I think you're doing a great job, I like the workbook a lot. I'll post my comments later.

Re: Gp2 Manager Tool

Posted: 28.01.2010, 21:15
by MaxX
Thank you :)

Unfortunately I haven`t found any more time to continue but it will be found again I suppose ;)

Re: Gp2 Manager Tool

Posted: 10.08.2015, 14:02
by Alexandre Faustini
Any further progress?

Re: Gp2 Manager Tool

Posted: 22.10.2015, 10:15
by hansel
Pleas, could you send to me? davidprieto@hotmail.es

Thanks in advance

Re: Gp2 Manager Tool

Posted: 05.02.2017, 17:43
by johnrafael
Maybe a little too late, but since I'm working in a fantasy championship, this could be nice.

Re: Gp2 Manager Tool

Posted: 30.06.2018, 22:07
by MaxX
Currently there is no further progress, the last version can be retrived from the utils-section on the main-site: http://grandprix2.de/Util/util.htm

Gp2Career includes the Excel, formulars are only hidden, the Sheets are not protected. Feel free to edit it for your purposes