Thread:Sirebel/@comment-30967537-20170906151631/@comment-30967537-20170912122040

Hi Dave.

Ok, I had my first stab at what we discussed which involved a few other changes/improvements ...
 * I added functions to the Events sheet to calculate the Cash-to-Fame ratio for each event, the average for all entries and a check for the number of entries which fall within 20% of the average (94%).
 * I added functions to the Upgrades sheet to calculate the Cash-to-Gold ratio for each upgrade, the average for all entries which can be purchased for both Gold and Cash and a check for the number of entries which fall within 20% of the average (71%).
 * I added a global sheet file to my spreadsheet and a function to retrieve the specified parameter(s) or all of them AND included the above as parameters.
 * I changed my Wiki Strategy creation script to allow for the above.

This gave me a Cash-to-Fame ratio of 5.1 and a Cash-to-Gold ratio of 3660.

I then used those values to convert the event Fame rewards to Gold and added them to the Series Gold rewards ... I also added the event R$ (but not the CRB) rewards.

I've just re-run the Wiki Strategy creation script and created a new page ... it actually makes quite a difference ... I double-checked my calculations, they look correct!
 * Before
 * After

I haven't (yet) allowed for non-specific rewards e.g. Endurance races.

Let me know what you think.

Cheers,

Nick