File updated with new coefficients and re-uploaded
Hey there,
I made this excel file for my own personal use while playing (since I don't like to search for values at tables all the time lol). I decided to post it here since it's being very helpful to me and I think it can helpful for someone else 
It's related to the Required Qualification tables provided by VLLord, but with some automations (without macro's).
http://www.4shared.com/file/-rD3CH_p/Qualifications.html
Instructions
1) On the top right of the sheet you have your qualification levels (Commerce, Production, Stock Raising and Management). Input your current levels (they can be found in the Office -> Qualifications page).
2) The table on the left has the maximum number of employees you can manage on ALL subdivisions of a a given type, with the qualification levels you inputed on the first step. The level you're currently at (thus, the number you can manage) is highlighted in yellow.
3) The table's on the right give you the maximum number of employees you can manage in ONE subdivision. On the top of the table (header) there's employee qualification, and on the left (first column) there's the number of employees. The inside of the table is the qualification level required to manage the given number of employees and their qualification. Values above your current qualification are highlighted in red.
It's separated by subdivision types, scroll down to see the others.
Credits and Disclaimer
- The color highlights will only work in Excel 2007 (and above, maybe).
- Credits for the table on the left and for the Factories table on the right go to VVLord. In fact, you can give him ALL the credits 
- Credits to noglue5 for the coefficients
Cheers
|