Gp2 Manager Tool

Here you can post everything that fits in the topic "GP2 Screenshots & GP2 Patcher"
Post Reply
User avatar
MaxX
GP2 Star
Posts: 1073
Joined: 28.02.2007, 11:41
Location: Salzburg, Austria

Gp2 Manager Tool

Post 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
Last edited by MaxX on 21.01.2010, 16:23, edited 2 times in total.
HF
GP2 Star
Posts: 1168
Joined: 08.09.2006, 16:14
Location: Germany
Contact:

Re: Gp2 Manager Tool

Post by HF »

wow, sounds nice! would be the perfect thing for "lazy" persons like me ;)
- . -
User avatar
jakesanson
GP2 Acc
Posts: 673
Joined: 31.10.2008, 21:37
Location: Chester, UK
Contact:

Re: Gp2 Manager Tool

Post by jakesanson »

This sounds very exciting! Looking forward to it.
Find me on @jakesansonofficial or www.jakesanson.com
Voice of the FIA Karting World and European Championships, IAME Euro & Asia Series, and more.

Commentated at the British Grand Prix for Formula 1 in 2019 and the Le Mans 24 Hours for ACO in 2016. Yep, I can't believe it either.....

Come and play the RRML using Grand Prix 2 via Downforce Racing YouTube channel!
User avatar
MaxX
GP2 Star
Posts: 1073
Joined: 28.02.2007, 11:41
Location: Salzburg, Austria

Re: Gp2 Manager Tool

Post 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
User avatar
rremedio
GP2 Legend
Posts: 1559
Joined: 14.01.2007, 15:05

Re: Gp2 Manager Tool

Post 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.
"The Fox provides for himself. but God provides for the Lion"
Image
Early 90s F1 forever!
User avatar
MaxX
GP2 Star
Posts: 1073
Joined: 28.02.2007, 11:41
Location: Salzburg, Austria

Re: Gp2 Manager Tool

Post 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 :)
User avatar
rremedio
GP2 Legend
Posts: 1559
Joined: 14.01.2007, 15:05

Re: Gp2 Manager Tool

Post by rremedio »

"The Fox provides for himself. but God provides for the Lion"
Image
Early 90s F1 forever!
User avatar
MaxX
GP2 Star
Posts: 1073
Joined: 28.02.2007, 11:41
Location: Salzburg, Austria

Re: Gp2 Manager Tool

Post by MaxX »

Sent it to you :wink:

It`s pretty Beta though
User avatar
rremedio
GP2 Legend
Posts: 1559
Joined: 14.01.2007, 15:05

Re: Gp2 Manager Tool

Post by rremedio »

I think you're doing a great job, I like the workbook a lot. I'll post my comments later.
"The Fox provides for himself. but God provides for the Lion"
Image
Early 90s F1 forever!
User avatar
MaxX
GP2 Star
Posts: 1073
Joined: 28.02.2007, 11:41
Location: Salzburg, Austria

Re: Gp2 Manager Tool

Post by MaxX »

Thank you :)

Unfortunately I haven`t found any more time to continue but it will be found again I suppose ;)
Alexandre Faustini
GP2 Newbie
Posts: 27
Joined: 22.10.2007, 20:31

Re: Gp2 Manager Tool

Post by Alexandre Faustini »

Any further progress?
hansel
GP2 Newbie
Posts: 36
Joined: 12.09.2006, 17:50

Re: Gp2 Manager Tool

Post by hansel »

Pleas, could you send to me? davidprieto@hotmail.es

Thanks in advance
johnrafael
GP2 Newbie
Posts: 8
Joined: 05.02.2017, 11:58
Location: Brazil
Contact:

Re: Gp2 Manager Tool

Post by johnrafael »

Maybe a little too late, but since I'm working in a fantasy championship, this could be nice.
User avatar
MaxX
GP2 Star
Posts: 1073
Joined: 28.02.2007, 11:41
Location: Salzburg, Austria

Re: Gp2 Manager Tool

Post 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
Post Reply