Company Guide v 0.5 beta release
Jack Lantos
Today I announce the release of a new company calculator that I have made. It is essentially an Excel spreadsheet containing all formulas required to calculate the performance of different company types in your individual economic conditions. I feel this is the perfect time for people to consider exactly which companies are worth investing in, with recent economic module updates and the end of a company upgrade offer approaching.
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 expect this will limit the number of people who can actually use the calculator at this stage, so I would like to make a normal xls file as well in future so that more people can use this.
Key features:
- Enter current market values, taxes, bonuses, etc. for your individual needs.
- Calculate daily production volumes and earnings.
- Calculate the amount of days to repay the cost of any type of company, and you can factor in the company upgrade discount.
- Modify worker usage to find the best possible worker allocation for any company type.
- Company types receive an Investment Score (scaled from 0 to 10), as an indication of which company types are suitable for your economy.
- Test any conditions to see how they will impact different companies.
- Formulas and constants are protected so you won't accidentally mess them up, and there is some programming to help you input valid numbers.
Screenshots
The sheet you see when you open the file, provides instructions for use and allows you to input current variables manually. I have used Australia day 1542 data as an example.
When the form is complete, switch to the output tab to see the calculations. You can adjust the worker usage and see how the company types compare.
Click images for full size:
Feedback
This is the first open release so there are bound to be things that can be improved. Please share your experiences and suggestions for consideration in future versions.
The inspiration for this calculator is from an old player named Corny-Ratbag who did something like this ages ago during erepublik V1 in eAustralia. His calculator was called GM Records - let me know if you were alive in V1 and previously used this!
Please vote this internationally to make this tool available to all!
Shout it
New company calculator release😛
http://www.erepublik.com/en/article/1964883/1/20
Jack Lantos
EDIT:
Updated to v 0.51b
- Fixed region bonuses for weapons/food being reversed (thanks Roboa)
Comments
Utterly awesome!
Good going. : D
voted and shouted!
Simply Awesome!!!
Thanks Jack \o/
v21 s194
good stuff, Jack!
Wow
It's simply great! Big thanks!
v+s+shouted
Corny-Ratbag is a legend.
Great one!
V+s+s
Nice!
GM Records was great, let's hope that this is as good. Cheers!
voted hard.
nice tool o/
nice but unfortunately doesn't work good with Office 2003 (with formats converter 2007 included)
great job mate
Sheer Brilliant!
This is Jack Lantos for ya! Total Awesomeness!
excellente
v+s
Awesome!!!!! Great Job 🙂
Voted Hard o7
This is fucking awesome! Jack Lantos 4 King!
Perfectly usable in google docs
I always said you should be the ABA president! Great Job!
This guy along with arawn lives needs a award for renewed energy in eIndia.
v+s
V + S
More partial nudity and special effects are needed
great...voted!
v
Sweet!
s+v
V+S, seems to be very interesting ! o/
v+s 238
o7
VS! What a great!! Thank you very much!
Drop down list ??? where is it ?
(voted)
Thanks everyone for a great response, I have ideas for adding more features to help you
Alegevo, see for example in the second screenshot there is a down-pointing triangle next to the selected cell, if you click that the dropdown menu containing possible values for that cell will appear. It might need the recent versions of Excel to give dropdown menues, but might otherwise be possible to enter the values manually.
v+s
Great! huge work! thx
v!
Voted! \o/