Required Qualification Excel 2007 File :: Forum :: Virtonomics

Search Rating log

List of forums -> FAQ -> Required Qualification Excel 2007 File

Topic:

«...»

Topic created : 25 May 2010, 23:33

Last time edited : 5 February 2011, 13:18

Pyrex

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 Well

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 Well

- Credits to noglue5 for the coefficients Well

Cheers

Page:

1 2 3 →

Message list:

25 May 2010, 23:36

Last time edited : 25 May 2010, 23:36

Pyrex

Also looking for some alternative host to upload the file. Just found out that 4shared sucks.

26 May 2010, 02:09

Ablemit

I can upload it today to my website and re-post it here.

26 May 2010, 02:19

Ablemit

Btw, very very helpful file. Thanks!

26 May 2010, 04:02

Pyrex

Upload it and I'll update the link.

26 May 2010, 17:09

Ixnad

Ix Nelieus

Hi, Can you upload it to http://www.mediafire.com/ ... ? Tried to download it but the site sure has some misleading buttons. Eyes in a heap

26 May 2010, 19:10

noglues5

Wave company

Click!
Mirror

27 May 2010, 00:03

Pyrex

thanks noglues5, link on the first topic updated Well

27 May 2010, 00:26

ArxCorvus

OMG this if frickin amazing!

27 May 2010, 02:13

pectopatop

KKompany

Pyrex, how did you make such colour schemas in Excel?
I see that there are no formulas and no macros in file. How does it works?

27 May 2010, 03:58

Pyrex

@pectopatop

Conditional formatting, it's on the first office tab. Open it's menu, click the item in the bottom (don't know the name, my office is in portuguese), and select something like "This worksheet" and you can check the conditions I used Well

31 May 2010, 02:25

globeballa

Sigamoney Enterprises

International "GOT BEEF?" Agency

What happens when you have a little over the maximum amount? Will you efficiency drop ALOT?

31 May 2010, 02:40

Pyrex

click the Work Efficiency link right at the bottom of the subdivision (wait 15-20 minutes after increasing the workers) to have a preview of what will happen. sometimes it's nothing

2 June 2010, 11:54

Chamurapi

CB Corp.

thanks for great work done,

however, it seems that the numbers on the left (total number of employees) are not fully right..

e.g. I have level 16 in stock rising, according the table I should be able to support 4552 workers, however I have 5 320 employees and I'm on 100% eff

how were these numbers for farms calculated?

thanks

2 June 2010, 15:30

Pyrex

Those numbers are from VLLord and I think they were discover by experiment.

3 June 2010, 09:19

Fractal

Moderator

Company 2.0

Revolution Corp.

The numbers are accurate but I think they can be influenced by other qualification use.
For example, if your management qualification is underutilised it can increase the number of workers for other qualification areas (like stock raising).

I'm sure VLLord will have a more accurate answer, but I hope it helps in the meantime.

List of forums -> FAQ-> Required Qualification Excel 2007 File

Page:

1 2 3 →