Work Stats Development Calculator.

So, i wanted to buy trains to fast track the city jobs, and wanted to know (estimate) the days, director trains and cost, before hand.

You just need to input you current stats, objective stats and chose a position in the company that uses the primary stat the one you want to train (it assumes that you already got the required stats for position), the trains you get free or paid for (with value per train). There is a page per Stat if you need more than 1 Stat.



If you use, please comment, with suggestions if you encounter a way of make it better ;)



Link to Google Sheets: Google Sheets 

For Offline use (Old Version): https://drive.google.com/file/d/1RcHwqufi0YAg2_4XhVPLfb-FP6ihyBlm/view?usp=sharing

Great work man. But you need to add a category for Directors also.

Spread out the job list in two selectors First one the company and second one the job.

The list is way to long as it is now

R+

Updated to include Director Gains.

1 Star - 5; 2 Star - 10; 3 Star - 20; 4 Star - 35 and 5 Star and More - 50.

Will try to come with a way to make 2 drops, but is possible to filter. After you call the Drop-Down List, delete the text and write the type of company or position you have/can get, getting a much sorter List.

Updated. 2 Drop Down List (Company Type and Job Position). Database modded to work this way.

Looked nice, but cells stayed locked on me....

What about city jobs?

Updated to Include City Jobs.

Those who cannot use Google Sheets, can use any calculator to see how many days it would take to reach to certain goal.

Formula if your work stat is primary work stat:
(Work stat goal - current work stats) / (gain from position + 50 * amount of trains) = days needed

(100000 - 97000) / (53 + 50 * 9) = 5.96 days

For secondary gains just replace 50 with 25.

For work stat gains in any position you can check: https://www.torn.com/wiki/Companies

bump

Bump