Company Guide v 0.6 beta - New Features

Day 1,552, 20:49 • Published in India Greece • by Jack Lantos

I am releasing an update of the Company Guide tool with a few new features and improvements.

1. MyCompanies Tab

There is a new page allowing the user to enter the number of each type of company that they own, and see their projected profits over time.

By popular request this table shows the balance of raw materials, i.e. whether production companies will be supplied with enough raw materials or not. It is possible to adjust the company numbers to see how many raw materials companies are required for material self-sufficiency.

The Company Builder panel in the lower right corner of this page, calculates how many new companies you would be able to afford at the current income rate. You can select any type of company from the drop-down list to see roughly how often you would be able to afford new companies of that type. This currently assumes all income is devoted to building new companies; the next version I am working on might allow you to define what proportion of income you are spending on companies for a more realistic estimate.

Click screenshot for full size:



2. Improved worker usage panel

The output screen now shows the amount of profit per hired worker, so you can easily decide how many workers to hire in each company type.

Click screenshot for full size:



Download

To download the latest version go to the sourceforge page here:
https://sourceforge.net/projects/ecompanyguide/

Requirements

You will need a recent version of Excel (2007 or later) to open this calculator with full functionality. It is an xlsx file. I am still working on a normal xls file so that in the near future more people can use this. Some users have reported the xlsx file can be adapted into Google Docs with varying degrees of success, so improving this compatibility may be another avenue for future improvements.

Feedback and Acknowledgements

Feel free to message me with further feedback on the new version. Thank you and please continue to link to this newspaper to share this tool if you like it. There have been 233 downloads so far!


EDIT:
Updated to v 0.61b
- Fixed VAT deduction to be exactly how eRepublik calculates it (thanks Th1ngy for notifying).

The two methods of calculating the VAT deduction are:
A. taking the product price and multiplying by (-VAT/100), or
B. taking the product price and dividing by ((1+VAT)/100) then subtracting the product price.

There is a difference between the two results which is significant at higher VAT, see the example below: