Michael-5 said: Carl2291 said: In an unbiased opinion, I for one think the Wii U is perfect here on VGChartz. Still waiting on that updated table with rank by score Michael! You want your rank by score? Didn't i put that as a message? I should add it to the OP shouldn't I? Tonight, I will, I'll clean this all up.

In my Excel I don't understand what IF(MAX() part accomplishes under Entrant in the Platform and Weekly tabs. I think with only the VLOOKUP part you'll be fine.

OK so ethomaz I just have to comment on your Xbox One prediction.

Do you actually expect WW sales for the X1 (the 13 countries that Xbox sells best in) to be the same as the 360 when it launched in only the US and Canada despite X1 pre-orders being twice as high with it being a few weeks out from launch still?

You said youd do it here -

http://gamrconnect.vgchartz.com/post.php?id=5782441

non-gravity said: Michael-5 said: Carl2291 said: In an unbiased opinion, I for one think the Wii U is perfect here on VGChartz. Still waiting on that updated table with rank by score Michael! You want your rank by score? Didn't i put that as a message? I should add it to the OP shouldn't I? Tonight, I will, I'll clean this all up. In my Excel I don't understand what IF(MAX() part accomplishes under Entrant in the Platform and Weekly tabs. I think with only the VLOOKUP part you'll be fine.

I don't understand what you just said....you "Entrant" tab only lists people in the order they are written in at the very start.

OHHH Oh, yea for next week, this week it's just one week.

Yea I'm going to organize peoples predictions (what's currently in the OP) alphabetically, instead of the order in which we voted. I'm also going to list results by rank next week (not alphabetically). That way when you do well, you feel it, and I think in the past non-gravity organized by rank.

However I just noticed that there already is a column for peoples overall score, so what I'll do net week when I post results is organiz people by rank and put their score in actual points immediatly beside that so people know how far behind they are. I can't do this for every category, so I'm just going to do it for overall. Console specific results will still be organized by name.

Basically I'm going to do something like this:

http://gamrconnect.vgchartz.com/post.php?id=4890479

every week, but I'll put your overall score in points in one more colum.

In my Platform and Weekly tabs in the Entrant column there's a VLOOKUP that selects the names in order of their ranks for which it uses the ugly brown ranking tables in the Data tab. Then in the rest of the table it look up the name under entrant and selects all that person's scores. Thus all tables are automatically ranked by score.

Then in the Rankings tab it takes all the data that's already ranked from Platform and Weekly.

I'm still willing do make this work for you, as when it's done you don't have to spend any time ranking everything yourself.

Now I'm starting to wonder if you've even seen any of my other tabs, as everything you posted so far could have come from my Data tab only. 

I....I did not see that

OMG.....everything is already done for me! LOL, alright, let me just fiddle around with this, add in new consoles and whatnot and, well by the time week 2 data comes in everything will be clean and pretty. Oh so pretty.

Sorry for the sloppyness, now I know how to do this.

Thanks Michael, thats what was missing!

I hate Vita and Wii U or rather the adjustments