Said spreadsheet is in my signature - Integrale tracker (though ofc it can be useful for other purposes).
1. Welcome
This tab has all sort of commentary describing the quirks of Custom Race mode and suggested best practices
2. Career Home
This tab is to track a long-play progression - there is an area for your bank account, garage and associated expenses, and payouts can be tallied by inputting a finishing position into the appropriate column. The series names, circuits, race lengths, entry restrictions, and weather/time of day settings are hardcoded here. Payouts are coded into a hidden ‘Aux’ sheet and governable by a single scalar you can play with to adjust things in bulk. I’ve tried to rig it to be somewhat appropriate to what you’d earn in GT7 with inflated payouts and 2nd place finishes behind a pace car, though ultimately you’ll need way more income in order to furnish the rest of the AI grids to exact spec.
3. Championship Tracker
This tab is to track an individual series/championship. You fill it out with finishing positions for each race, add series points to the season points total for each driver, and then delete the finishing positions and start over for the next series. The selector at the top dynamically populates the grid with the appropriate drivers, circuits, etc., all but drivers pulled from the Career Home tab. Drivers are in their own ‘Aux3’ sheet, as are the points awarded based on finishing position. You can optionally track a fastest lap, though I haven’t used it in a while since we figured out the pace car thing.
4. Rivals
As you go through a longer play, I’ve had fun/found it useful to track my opposing/AI driver’s personalities and preferences. Integrale’s author,
@Theufcveteran, created bios for the pre-baked drivers, but of course it can be space to do your own thing. Bios and your additions (cars owned, notes on what car/livery types they like to use) are kept in a hidden ‘Aux4’ sheet
5. Full Car List
I maintain a spreadsheet with all the cars, including their default tire. This last part is pretty useful if you want to balance a custom grid using the same tire compound, as AI drivers won’t use anything aside from default or RH.
6. AI Report Card
This doesn’t apply to Sophy, but there remain some circuits where Reggy AI is actually competent - and some where he’s hopeless. I started this a long time ago and only occasionally remember to update it, but it may be a useful reference as you’re considering which circuits to run. There is some great racing to be had at non-Sophy layouts, still! This is also the tab that contains the hidden logic referenced by the Tracker tab to color code Sophy-eligibility.
Bit of an Integrale ad (as ever with me), but hopefully relevant and useful to the budding custom championship author, too…as long as I’m blabbing, I also remade Gran Turismo 3 in a similar signature-housed spreadsheet (requires you already have all the ‘prize cars’ to award yourself throughout though), if that’s more your vibe.
Nürburgring 24h__2 (6) by 2cam16, on Flickr
Nürburgring 24h__1 (8) by 2cam16, on Flickr
Nürburgring 24h__4 (4) by 2cam16, on Flickr
https://www.youtube.com/@JTubeGame
