What is Gamerz Edge?

This is a spreadsheet for helping you tune your Forza racing game car and is really two tools in one! The first part of the spreadsheet will tell you the best combination of engine components to select for optimum HP to weight ratio, or Torque to weight ratio. To set your car up for top end speed, then you want to select engine components that give you the maximum horse power with the least amount of weight. To set your car up for fast acceleration, then you want to select engine components that give you the maximum amount of torque with the least amount of weight.

Of course in the Forza racing game you may be limited by how many points you can use before your car crosses over into a new racing class (e.g. C, B, R1, etc.). Therefore, what you really want to do is select the best possible combination of engine components for a target value of points you have in mind. The engine component selection tool will do this for you indirectly by automatically creating tables that will tell you the best combination of engine components for the full range of HP or TRQ values possible for a given engine.

As an example, you may have 50 points remaining in your B class car before your car crosses over to the next level (A class). And you want to upgrade your engine to produce the best power to weight ratio, while at the same time spending only the 50 Forza points and keep the car in the B class. The engine component selection tool will do this for you indirectly by automatically creating tables that will tell you the best combination of engine components for the full range of HP or TRQ values possible for a given engine.

How is this accomplished you might ask? It's the "solver" add-in that comes with Excel. If you read up a little bit about solver you will learn that selecting combinations is one of the things it is good at. Of course a lot of work has gone into this spreadsheet in order to make things happen automatically for you. All you have to do is fill out a form on the first page of the spreadsheet telling it the points, horse power, torque, and weight for each engine upgrade component possible for a given engine and then hit some macro shortcut keys on the appropriate sheets.

What you get is table like the one below for the 2010 Civic Mugen with stock engine, indicating which parts you should select for a given HP target value. A similar table will be produced for Torque. The 1's and 0's in the table below identify Yes/No decisions for the individual engine upgrade components. This tool will work for all cars in Forza racing game!

The second part of the spreadsheet tool will give you the correct values for spring stiffness in order to keep your car perfectly balanced. When you add, or delete engine components from your car you will notice the weight distribution may change. What you want is spring stiffness values that will make your car balanced based upon this weight distribution. All you have to do is enter in the minimum and maximum stiffness values for the springs on your car, and enter in the weight distribution factor for the front of your car. These values can be found in the spring tuning page of Forza 3 or Forza 4. Then just hit a macro key combination and the chart below is created.

If the car is heavier in the front, then the front springs have to be a little stiffer than the rear springs in order to maintain balance. Of course if you look in the tuning setup you will see your springs can have a wide range of values. So what this chart is telling you is that; If you pick a front spring value and a rear spring value that intersect on the sloped line, then you will have a perfectly balanced car. It's up to you to determine if a perfectly balanced car with stiffer springs or weaker springs is correct for a particular track. As long as you select front and rear values that intersect on the sloped line, then you will maintain balance.