Tired of seeing ads? Click here to upgrade to Elite Membership!

Your User Name:
Your Password:	Forget your password? \| Register
Subject:
Message: Emoticon Listing HTML Help	[quote]Hi, I have a question for you. I'm trying to make a building calculator to compare building strats, but I'm having problems with the max population formula. I know what the formula is, but its cyclical. =(30[Homes] + 15([Employed Buildings]+[Land in Construction]) + [Barren Land][Racial Barren Pop])[Max Population Mods] - MAX(0, [Total Military] - 40*[Barracks]) - [draftees] The Draftees part depends on Total population but total population depends (in part) on draftees, thus excel tells me it is a circular reference (which it is) and I have no idea how to fix the problem. BTW, I looked at your excel sheets and they are very nice, but I have one problem with them. I can't zoom to see what I'm looking at better. Thanks for any help, -Regis[/quote]
Options:	Check here to include your profile signature. Check here to stay logged in. Convert smiles. Preview your post. (This feature will still post your message, but you can edit it from there if you need to make changes)

Tired of seeing ads? Click here to upgrade to Elite Membership!

Author

Message / Information

Regis

Hey Tim (excel question)
replied on: 5/28/2003 6:12:39 PM

Hi, I have a question for you. I'm trying to make a building calculator to compare building strats, but I'm having problems with the max population formula. I know what the formula is, but its cyclical.

=(30*[Homes] + 15*([Employed Buildings]+[Land in Construction]) + [Barren Land]*[Racial Barren Pop])*[Max Population Mods] - MAX(0, [Total Military] - 40*[Barracks]) - [draftees]

The Draftees part depends on Total population but total population depends (in part) on draftees, thus excel tells me it is a circular reference (which it is) and I have no idea how to fix the problem.

BTW, I looked at your excel sheets and they are very nice, but I have one problem with them. I can't zoom to see what I'm looking at better.

Thanks for any help,

-Regis

Tired of seeing ads? Click here to upgrade to Elite Membership!

ChatArea.com Help & News Forums | Terms of Use | Contact ChatArea.com | Advertising