Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!
I was considering the PS3 but thought for the extra £100 plus extra kit like controllers and stuff, not much point really. Although having said that the PS3 has had some decent games out so far this year not available on the 360 - depends how much you like your games really. The PS3 is a good...
Looks good. Being criticised a bit for being uber cliched and slow paced with weak ally AI but graphics are meant to be superb. MP is meant to be solid too.
Re: David. Brand. You ready?
I already spend a good bit of time each day at work reading up on Fallout 3 stuff....how lame am I haha...still so much to do and I have been playing for 70 hours now!!!
+
Re: David. Brand. You ready?
Er not sure of the op of my head but pretty sure I mentioned it before and Darren mocked me...
It runs DoW fine though really smooth so think it should be ok (I hope!)
Re: David. Brand. You ready?
Ha...I am up for getting it pending on my PC running it! Not exactly a games machine but not to shabby either. What's the performance like on your setup? No fancy graphics card here unfortunately :(
Re: David. Brand. You ready?
Say it ain't so......the reviews are loving it on the whole.....although they all say "we can't criticise a game for being original, yet at the same time, if it ain't broke...."
Re: David. Brand. You ready?
Patch I guess?
No not got it yet. Not sure my PC could run it very well...what are the unit customisations like, or the MP?
Yeh think so cheers mate, all I need to do now is do some Get formulas...do these link to a cell so that if I were to add or delete a row, it would still be pointing to a specific cell though? As in my summary table it has dealers in rows so if I added or deleted one, don't want my formulas...
Sorry no Photobucket here but basically, all the raw data and analysis formulas are on the same page.
Then I also have a sheet for each dealer, with some drop down menus and also some stuff which is autopopulated, such as these orders. I just have a countif statement for each page matching...
Don't worry, used a countif function just matching the column against the dealer name (which is written in each dealer's page) then just produces a number, then next to that I have a simple if function so that once they achieve the minimum standard (of 100 this year) it says "Achieved".
I...
Re: David. Brand. You ready?
Sack it off. SF4 has been getting some great reviews too, Gamecentral (written by one of the guys from Edge I think) gave it 10/10 - and they have only given that to about 2 or 3 games ever before...although I think one of them was the latest GTA so they can't...
Basically, in the formula where I originally had "qualify" this now returns a dealer name if it's all true.
Then in a dealer sheet I just need it to count how many qualifying sales it has from the column in the other sheet where we have put this formula into...
So it just needs to match the...
Genius - didn't work first of all, but put the code numbers as strings ("") and then worked! Brilliant!
The formula looks like this now:
=IF(AND(OR(K256="66666", K256="77777", K256="88888", K256="99999"), U256="A", T256<>"Motability"), D256, "Not Qualify")
Genius, I was excluding...
No pivot tables are out- tried that and would need 16 to do what I need and makes the file massive, I am analysing the raw data itself.
Problem is I need to include some data, exclude motability, and also have the "or" bit for the code numbers...
Still not there so still a prize available...
Hi
Basically I need a formula that does the following, a nice little challenge for a genius:
Includes anything in "plan A" (column U)
Exclude anything in "Motability" (column T)
Include anything with a code of, either, "66666" or "77777" or "88888" or "99999" (in column K)
Checks if that...
Re: David. Brand. You ready?
Yeh but the way you can create such a diverse army and care for your units is cool, plus in the skirmishes you kind of have bases, and who knows for addons.
I think it is a bold move anyway - but I know what you are saying I like just building the best army and...
Re: David. Brand. You ready?
Review is out now on IGN, sounds bloody awesome to be honest, Halo Wars sounds like a kids game in comparisson. I think doing away with base building is a bold but potentially really good move, although I do enjoy having a lot of turrets....mmm!