OOTP Developments Forums - View Single Post - GMEXcel

marc420 · 11-29-2009, 03:18 AM

Is the formulas under 'bandwagon' correct?

What i see now is

Code:

=(3*B4+2*B5+B6/6)

For some reason, to me it looks like the '/6' is out of place.
Did you mean to take
3*B4 + 2*B5 + B6
And then divide all of that by 6 to get it back to an average win per
season weighted towards the most recent season.

Currently, it just takes the 3 years ago wins and divides them by 6 and
then adds that to 3*current wins and 2* last years wins. That just looks
odd to me, but then I don't know what you were trying to do with this.

And I guess some more instructions might help. Why are there two teams listed in ACCTX? Is that workspace for two teams? Or, am I supposed to enter my team in one and some other team in the other area? Or just use one of the areas for my team and ignore the other one?

11-29-2009, 03:18 AM	#19 (permalink)
marc420 Minors (Double A) Join Date: Oct 2002 Location: Terrapin Station Posts: 106 Thanks: 0 Thanked 1x in 1 post	Is the formulas under 'bandwagon' correct? What i see now is Code: =(3B4+2B5+B6/6) For some reason, to me it looks like the '/6' is out of place. Did you mean to take 3B4 + 2B5 + B6 And then divide all of that by 6 to get it back to an average win per season weighted towards the most recent season. Currently, it just takes the 3 years ago wins and divides them by 6 and then adds that to 3current wins and 2 last years wins. That just looks odd to me, but then I don't know what you were trying to do with this. And I guess some more instructions might help. Why are there two teams listed in ACCTX? Is that workspace for two teams? Or, am I supposed to enter my team in one and some other team in the other area? Or just use one of the areas for my team and ignore the other one?