iebb / F1ManagerSaveReader

F1ManagerSaveReader
https://f1-manager-save-reader.vercel.app
MIT License
8 stars 1 forks source link

[SUGGESTION] Cost Cap Projection #25

Open edutenorio opened 4 weeks ago

edutenorio commented 4 weeks ago

Hi. I created a script to do one thing I believe is missing in the game but could be easily done on your page: a cost cap projection, taking all we have spent so far and accounting for all the commited spending that affects the cost cap: facilities upkeep and specific staff salaries. It's the only way to know eactly how much we can spend on design and research and parts development.

I used a script from xAranaktu to unpack the save file and made an SQL sript to get the data from the tables and a python script to organize the output to something like:

Cost Cap Spending Break Down
  Car Part Development..... $  94,500,000.00
  Car Part Research........ $   7,600,000.00
  Staff Salaries........... $   1,588,745.00
  Engineering Team......... $     409,200.00
  Scouting Team............ $      24,500.00
  Pit Crew................. $     350,000.00
  Emergency Purchases...... $   4,700,000.00
  Facilities............... $   9,135,500.00
--------------------------------------------
  Total.................... $ 118,307,945.00

Monthly Cost
  Staff Salaries........... $     263,083.00 x  5 = $   1,315,415.00
  Engineering Team......... $      52,800.00 x  5 = $     264,000.00
  Scouting Team............ $           0.00 x  5 = $           0.00
  Pit Crew................. $      50,000.00 x  5 = $     250,000.00
  Facilities............... $   1,283,500.00 x  5 = $   6,417,500.00
--------------------------------------------------------------------
  Total.................... $   1,649,383.00        $   8,246,915.00

Cost Cap Summary
Total cost cap:    $  139,200,000.00
Spent so far:      $  118,307,945.00
Commited spending: $    8,246,915.00
------------------------------------
Remaining:         $   12,645,140.00

I believe it would be a nice addition to your page. Let me know if you're interested, I can give away the code for you. I do this for fun, no intention of any profit.

iebb commented 4 weeks ago

The plugin feature (WIP) is actually for these community creations. Will update once I have time