New OCN calculator

Talar · May 15, 2004, 11:34 AM

This is basically the same excel OCN calculator that Lbhhh did some time ago but with a reworked interface which should make it quicker and more comfortable for frequent users.

http://www.civfanatics.net/uploads7/OCNcalculator.zip

It's still based on the OCN formula by Alexman, thanks for that one

lbhhh · May 16, 2004, 04:00 PM

Quote:

Originally Posted by Talar

This is basically the same excel OCN calculator that Lbhhh did some time ago but with a reworked interface which should make it quicker and more comfortable for frequent users.

http://www.civfanatics.net/uploads7/OCNcalculator.zip

It's still based on the OCN formula by Alexman, thanks for that one

Well done with the interface.

Here is a screen shot of the final result. Happy downloading everyone.

As always, questions/comments welcome.

10lire · May 19, 2004, 06:49 AM

Sorry for my inexperience: how can I use the OCN? How the number is calculated?
(example: Chieftain-Communism-Forb.Palace & Sec.Police HQ-Huge map-Commercial= 333 cities!!)
Alternatively: where can I find in Civfanatics this infos?

Thank you in advance!

lbhhh · May 22, 2004, 04:31 AM

Quote:

Originally Posted by 10lire

Sorry for my inexperience: how can I use the OCN? How the number is calculated?
(example: Chieftain-Communism-Forb.Palace & Sec.Police HQ-Huge map-Commercial= 333 cities!!)
Alternatively: where can I find in Civfanatics this infos?

Thank you in advance!

The OCN refers to your optimal city number. If your empire has more cities than your OCN, the corruption level gets higher in cities ranked over your OCN. Therefore it is better to have the highest OCN possible, as it allows you to have a higher number of cities that are productive.

OCN formula for your empire:
Nopt = OCN * (L/100 * (1 + c + Gr + Gp*Nwe)
where
OCN is the optimal number of cities for the map size,
as found in the editor
L is the percentage of optimal cities for the current
difficulty level, as given in the editor
Nwe is the number of active Wonders in the empire with
the “reduces corruption” ability
(Forbidden Palace, SPHQ)
c = 0.25 for a commercial civilization,
0 otherwise
Gr = 0.1 for minimal or nuisance corruption
2 for communal corruption
0 otherwise
Gp = 3/8 non-communal corruption
3 if communal corruption

For more details on distance and rank corruption, the reference is Alexman's article

http://www.civfanatics.com/civ3acad_...tion_c3c.shtml

Note: The OCN works very differently for communism vs all other governments. Because of the communal corruption, the OCN has to be higher, hence the different values in the formula.

Jurimax · May 22, 2004, 12:02 PM

I tested it, and IMHO I think there's a small mistake, when the SPHQ is checked, it increases the OCN even when not under Communism.

Dogmeat · May 22, 2004, 02:34 PM

Quote:

Originally Posted by Jurimax

I tested it, and IMHO I think there's a small mistake, when the SPHQ is checked, it increases the OCN even when not under Communism.

I think it's useful. Someone might mod the game so that SHPQ is under a different government.

lbhhh · May 23, 2004, 09:49 AM

Quote:

Originally Posted by Dogmeat

I think it's useful. Someone might mod the game so that SHPQ is under a different government.

@ Jurimax. I was aware of the issue. Just consider the Wonders menu as the Wonders currently in effect menu.

@ Dogmeat. I`m glad you like it. It would be an interesting idea to mod the SPHQ so Fascist governments could build it as well.

DJMGator13 · Jun 05, 2004, 09:33 AM

Just downloaded it, very nice and easy to use.

One question though, do you round the result up or down? 32.4 = 32 or 33

lbhhh · Jun 12, 2004, 02:08 PM

Quote:

Originally Posted by DJMGator13

Just downloaded it, very nice and easy to use.

One question though, do you round the result up or down? 32.4 = 32 or 33

Thanks for the feedback.
To answer your question, the OCN would in all likelyhood be rounded the standard way, i.e .5 or more rounds up and .49 and less rounds down. So in your example 32.4 would be 32 but 32.7 would become 33.

luckykitkat · Jul 14, 2004, 10:39 AM

Ha, Cheiftain, Communism, Huge Map, Commecrcial Civ, with SPHQ and Forbidden Palace gives 333 for OCN. I might try that...

mikezang · Mar 16, 2005, 12:15 AM

Hi, Can you made a corruption calculater for a city with distance(X, Y) and Rank R based on Alexman's article?

mikezang · Mar 16, 2005, 06:16 AM

Quote:

Originally Posted by lbhhh

OCN formula for your empire:
Nopt = OCN * (L/100 * (1 + c + Gr + Gp*Nwe)

Hi, you used mistake formula, the right is as below:
Nopt = OCN * (L/100 + c + Gr + Gp*Nwe)

So your result is wrong, for example, I play China in Tiny Map on Monarch.
So OCN=14, L=85, c=0, Gr=0.1, Gp=.375, Nwe=0
Right Nopt = 14 * (85/100 + 0 + 0.1 + 0.375 * 0) = 13.30
Your Nopt = 14 *(85/100 * (1 + 0 + 0.1 + 0.375 * 0)) = 13.09

TruePurple · May 24, 2005, 02:41 PM

ack, my head! Ok is that xcel ocn caculator inaccurate then?

Also I can't use that xcel caculator. I don't have xcel, I only have a free excel viewer. This means I can open it and see a picture of the interface, but I can't choose any of the options or otherwise.. interface with it.

What about this c2c corruption/waste calculator. I can't figure out what to do with it. It doesn't seem to calculate the OCN and I don't see a way to adopt its numbers to practical use in game. Also, There are a number of abreviations I'm not familar with WLTKD, FP, SPHQ, Rest (resistance?) and I don't see a guide explaining what these abbreviations stand for.

Can anyone point me to a OCN calculator I can use?

Krikkitone · Jun 16, 2005, 03:35 PM

One other correction the Fully correct formula is
Nopt = OCN * (L/100 + c + Gr + Gp*Nwe + 0.25*Ni)

where Ni is the number of Corruption buildings available (Courthouse+Police Station)

josephstalin · Jul 21, 2005, 02:12 PM

Well, this is nice utility, good interference! But there are some mistakes in formula, that would be wondeful not to have.

Talar · Jul 31, 2005, 04:44 PM

Hello again, I haven't checked in here for a while. If there's still any interest I could make an updated version of the Excel file with the formula changed. I could make an OpenOffice version as well if you like.

Own · Oct 14, 2005, 11:12 AM

I can't get this to work. Tried it on excel, and I can't click anything.

Could someone give me the OCN for Huge Monarch Commercial as a Republic with and without the FP?

madviking · Oct 14, 2005, 06:26 PM

41.31, Own.

Own · Oct 14, 2005, 06:28 PM

Is that with or without the FP?

Thanks a lot

! Is helping me a lot in my huge monarch 70% arch game as the iroquois, playing no invading beyond my island until modern armor (like CVH1). I need to know when to start making a science farm (when my OCN runs out).

madviking · Oct 14, 2005, 06:30 PM

without FP or SPHQ.

May 15, 2004, 11:34 AM	#1
Talar Warlord Join Date: Oct 2001 Location: Linköping, Sweden Posts: 241	New OCN calculator This is basically the same excel OCN calculator that Lbhhh did some time ago but with a reworked interface which should make it quicker and more comfortable for frequent users. http://www.civfanatics.net/uploads7/OCNcalculator.zip It's still based on the OCN formula by Alexman, thanks for that one

May 19, 2004, 06:49 AM	#3
10lire Warlord Join Date: Mar 2003 Location: Milan, Italy Posts: 197	Re: New OCN calculator Sorry for my inexperience: how can I use the OCN? How the number is calculated? (example: Chieftain-Communism-Forb.Palace & Sec.Police HQ-Huge map-Commercial= 333 cities!!) Alternatively: where can I find in Civfanatics this infos? Thank you in advance!

May 22, 2004, 12:02 PM	#5
Jurimax Duke of Flanders Join Date: Jul 2001 Location: Oostrozebeke, Belgium Posts: 636	Re: New OCN calculator I tested it, and IMHO I think there's a small mistake, when the SPHQ is checked, it increases the OCN even when not under Communism. __________________ Back after 2 years of WoW Avatar perfected by Mistfit

Jun 05, 2004, 09:33 AM	#8
DJMGator13 Not playing enough Civ Join Date: Jan 2004 Location: Leesburg, FL Posts: 3,304	Just downloaded it, very nice and easy to use. One question though, do you round the result up or down? 32.4 = 32 or 33 __________________ "I say there's some things worth fighting for. What about our freedom and this piece of ground? We didn't get to keep 'em by backing down...Have you forgotten how it felt that day?" - Darryl Worley/Wynn Varble, 2003

Mar 16, 2005, 12:15 AM	#11
mikezang Pegasus Join Date: May 2002 Location: Tokyo Posts: 465	Hi, Can you made a corruption calculater for a city with distance(X, Y) and Rank R based on Alexman's article? __________________ Zang Land - My Personal Homepage. Chinese Classical Poetry - There are a lot of SHI and CI created by me. Chinese Classical Poetry Format Checker - This tool can check if your Poetry is in correct format.

Jul 14, 2004, 10:39 AM	#10
luckykitkat Chieftain Join Date: May 2004 Location: South Carolina Posts: 22	Ha, Cheiftain, Communism, Huge Map, Commecrcial Civ, with SPHQ and Forbidden Palace gives 333 for OCN. I might try that...

May 24, 2005, 02:41 PM	#13
TruePurple Civ wanna B Join Date: May 2005 Posts: 995	Help please ack, my head! Ok is that xcel ocn caculator inaccurate then? Also I can't use that xcel caculator. I don't have xcel, I only have a free excel viewer. This means I can open it and see a picture of the interface, but I can't choose any of the options or otherwise.. interface with it. What about this c2c corruption/waste calculator. I can't figure out what to do with it. It doesn't seem to calculate the OCN and I don't see a way to adopt its numbers to practical use in game. Also, There are a number of abreviations I'm not familar with WLTKD, FP, SPHQ, Rest (resistance?) and I don't see a guide explaining what these abbreviations stand for. Can anyone point me to a OCN calculator I can use?

Jun 16, 2005, 03:35 PM	#14
Krikkitone Immortal Join Date: Apr 2004 Posts: 4,742	One other correction the Fully correct formula is Nopt = OCN * (L/100 + c + Gr + GpNwe + 0.25Ni**) where Ni is the number of Corruption buildings available (Courthouse+Police Station)

Jul 21, 2005, 02:12 PM	#15
josephstalin Madness and Civilization Join Date: Apr 2005 Location: Paris Posts: 727	Well, this is nice utility, good interference! But there are some mistakes in formula, that would be wondeful not to have. __________________ "Law is not born of nature, near the springs frequented by the first shepherds; law is born from real battles, victories, massacres, conquests which have their dates and their heroes of horror. The law is born in torched villages, ravaged lands; it is born with the notorious innocents suffering in the throes of death as the sun rises." -French Philosopher Michel Foucault Want to live 100 years? Go to this site and find out your life expectancy!

Jul 31, 2005, 04:44 PM	#16
Talar Warlord Join Date: Oct 2001 Location: Linköping, Sweden Posts: 241	Hello again, I haven't checked in here for a while. If there's still any interest I could make an updated version of the Excel file with the formula changed. I could make an OpenOffice version as well if you like.

Oct 14, 2005, 11:12 AM	#17
Own Grasshoppah Join Date: Feb 2005 Location: North Carolina Posts: 5,428	I can't get this to work. Tried it on excel, and I can't click anything. Could someone give me the OCN for Huge Monarch Commercial as a Republic with and without the FP? __________________ Own Plain Ol Deity Story - Very Picturely - Ended in Glorious Victory AWD on Standard Pangaea

Oct 14, 2005, 06:26 PM	#18
madviking Shake a leg Join Date: May 2005 Location: Clifton, VA Posts: 3,278 Images: 3	41.31, Own. __________________ Anarchist Civ3 Player... go figure... but mostly Currently boycotting :btw: L/R: -5.12 SL/A: -8.10

Oct 14, 2005, 06:28 PM	#19
Own Grasshoppah Join Date: Feb 2005 Location: North Carolina Posts: 5,428	Is that with or without the FP? Thanks a lot ! Is helping me a lot in my huge monarch 70% arch game as the iroquois, playing no invading beyond my island until modern armor (like CVH1). I need to know when to start making a science farm (when my OCN runs out). __________________ Own Plain Ol Deity Story - Very Picturely - Ended in Glorious Victory AWD on Standard Pangaea

Oct 14, 2005, 06:30 PM	#20
madviking Shake a leg Join Date: May 2005 Location: Clifton, VA Posts: 3,278 Images: 3	without FP or SPHQ. __________________ Anarchist Civ3 Player... go figure... but mostly Currently boycotting :btw: L/R: -5.12 SL/A: -8.10

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What is the OCN in Civ 4?	davidky5	Civ4 - General Discussions	5	Nov 11, 2005 09:17 AM
Check out my Excel OCN Calculator	lbhhh	Utility Programs	8	May 07, 2004 05:38 PM
Conquest OCN?	Roi du Culture	Civ3 - General Discussions	7	Feb 19, 2004 08:21 PM
Ocn	wtiberon	Civ3 - General Discussions	1	Sep 24, 2003 09:09 AM
Ocn	swilhelm73	Civ3 - General Discussions	7	Sep 20, 2003 03:53 PM

Powered by vBulletin® Copyright ©2000 - 2009, Jelsoft Enterprises Ltd. This site is copyright © 2000 - 2009, Civilization Fanatics' Center.
Support CFC: Amazon.com \| EB Games \| Amazon UK \| Amazon DE \| Amazon CA \| Amazon FR