ene

FIFA 14 on next gen consoles only.

This is probably going to sound like a really stupid question and no doubt the option is right in front of my face. But I can't find the answer anywhere online so here goes...

When playing a friendly match (i.e. not career) is there an option to control just one player (as I do in career mode) and where is the option to control the goalkeeper?

I am new to FIFA and I have to say, the lack of manual (either paper or electronic) is frustrating.

Thanks all.

This is a fairly technical question so probably for intermediate to advanced Excel users only (and database knowledge would be a plus too).

Basically, I want to get lots of data into Excel to feed lots of pivot tables. Its about 600,000 rows by 50 fields. I have been outputting this file from SAS into a CSV file and then reading the CSV into Excel via an external connection. Bare in mind this is an office environment and both CSV and Excel files are held on a LAN that itself has lots of traffic.

I need the pivot tables to auto update on opening the file. So when I open the Excel, it pulls in the CSV data and the pivots update. This takes between 2 - 4 minutes, dependent on the LAN traffic. This is an eternity.

Is there any way to get this volume of data into Excel for use in pivot tables? Storing it in the actual Excel file is possible but the file becomes HUGE and its still very slow.

All ideas are welcome.

(I thought I would try Yahoo Answers before going onto more hardcore excel sites as the solution might be simple)

Thanks!

I'm just beginning to get a taste for whiskey (straight, no coke or ice). Its funny to think just a few years ago I literally hated it but I have really acquired the taste for it in the last year or so. I get the feeling it isn't a young person's drink...anyway I digress.

I went to the whiskey shop in Oxford today determined to buy a good quality whiskey as I have just been buying supermarket Teachers whiskey until now. However, the sheer wealth of choice and types of whiskey completely boggled me and I actually walked out with nothing!

My question is this. Given that I like the flavour of Teachers and also Jonnie Walker double black (a treat I bought in Duty free on my last holiday), what whiskeys would you recommend that are £50 and under?

I really have no idea about malt or peat etc and how that affects the taste. I think I like a smokey flavour with some peaty qualities (I believe Teachers is quite peaty??) I'm just a beginner so any guidance is appreciated. I'm particularly keen to move away from supermarket stuff though as I am sure there is plenty out there that is better. Thanks all :)

Bit of a broad question but any help would be appreciated.

I would like to invest in a better audio set up with my 50" plasma.

Looking at the cinema systems available, it seems all of them come with a blu ray player or dvd player. What I am looking for is the components to go with my PS3, Sky HD and Xbox HD DVD player to make up a 5.1 (or 7.1 - not sure which to go for) system.

Im a complete beginner at this so can someone just tell me if the below logic is correct?

I would need the following:

A receiver (such as the Yamaha RX-V667)

Optical cables for ps3-receiver and sky hd-receiver

(How can I connect the xbox 360 to the system when video and audio go through hdmi?)

Speakers to connect to the receiver (5 or 7)

Can all these be bought seperatly? I dont want to buy a home cinema system that comes with a blu ray player because I already have one.

Thanks

I have tried endlessly looking online but cannot find it. I have a feeling it might be an old tune that has been remixed. Ok the lyrics I think I understand are:

"If I seem a mile away, dont leave me cos Im coming home

Or something like that. The 'coming home' bit is also replaced by 'all alone' at times. Its hard to explain.

Any trance/dance enthusiasts will probably know this immediately cos it has some great trance riffs inbetween when the guys sings.

I have selected a movie to download but accidentally purchased it to stream rather than download. I dont want to watch it now and plus my internet connection probably cant stream it anyway. Is there any way to upgrade to download? There seems to be an option to do it but I cant see how to select it properly. Thanks

I have a logo and I want to remove the background colour in it so it will fit into a colour scheme on a brochure I am designing. Essentially I want the background colour on my logo to become just void space (not plain white) until I paste onto my brochure. I know you could do this on photoshop but its expensive. Any free alternatives that can do that task? Thanks all.

Ive heard of the term 'clutch slip' and I know it can ruin the clutch material. Im concerned I may be doing this and Im not sure how to prevent it. Case in point:

Slow moving traffic (really slow - stop and start kinda thing). If the traffic infront starts moving a bit then I take the foot off the brake, lift the clutch a bit, let the car move but Im not fully off the clutch. If I do that, the car will go too fast and I might bump into the car infront. As such, all the way through the traffic (apart from the times I am stationary), I am always 'halfway' on the clutch. Any less and I dont move and any more I gain too much speed. Is this ok? Am I wearing out the friction material by doing this? I cant see any other way to creep forward so slowly and in a controlled way.

Thanks

Im a first time driver so I really have no idea.

I have a quote ready to process on Tesco car Insurance. Once it goes through and I make the payment am I covered immediately or is there a 'red tape' paperwork process to follow after that?

I ask as my current dealership insurance expires monday and if Im not covered, well, my new car will have to stay parked :(

I have heard that the human body can start to get used to exersises if they are done repetitively. Currently I do 30 minutes hard work on an exersise bike every day or every other day. If I continue doing that (making sure every time I build up a healthy sweat with high heart rate) will my body start to get used to it and the benefits (e.g. losing weight) stop?

Cycling is the only thing I enjoy and can do. I hate running and the cross trainer. I would prefer to cycle it every day if possible.

I would of course increase the resistance once I find Im not sweating as much etc. Im just asking here if the same routine every day would stop any weight loss and health benefits. Thanks all.

Everyone knows the song but there is one remix where about 3 minutes in someone (not sure who) chirps in and starts rapping 'red red wine you make me feel so fine....you keep me rocking all of the time' etc and it goes on for about 4 minutes or so. Great stuff! Problem is, cant find it!

Can anyone help identify the exact remix or version? Thanks!

I have two worksheets. Worksheet A has data in it. No formulas. Worksheet B has a bunch of formulas in it that use the data in worksheet A. At the end of every working day I need to clear worksheet A of all its data but I need the values in worksheet B to remain (even tho effectively I have deleted the references).

I know there is a copy/paste values only option but I dont need to copy any data. I just need to break the link from B to A but keep the values in B. I dont mind having to do this manually (if such a process exists) but if there is a macro that can do it automatically based on the end of the day, that would be great!

How do I do this then?

Thanks!

Ok, Im coming into this series a bit late I know. But I want to buy a guitar hero of some sort (for xbox 360 or ps3). Heres my question:

Which do I buy first? There are so many!

Disregarding price (assume money no object), which is the best to buy first? Also, once you buy the guitar, can it be used with any of the other solo games that can be bought?

Example - if I bough GH5, could the guitar be used for GH world tour and GH3 solus games.

Is it possible to install all the songs on the hard drive or something so I only have to use one disc but can access all the songs from all the solus games?

Thanks for your replies

Quick question:

If an item is more expensive than my credit limit, can I send money to my credit card (before I have used it at all) to help fund the purchase?

E.g. If the item is £2300 and I have a £2000 credit limit, can I send £300 first to my card (say, from my bank) then buy the item outright in one transaction?

Thanks

A similar question has been asked before on here but it didnt quite cover everything I want to know. Basically:

1) Will Play.com charge for pre-orders before dispatch?

2) Am I able to cancel the pre-order before dispatch?

3) If the price of the product changes, what will I be charged in the end?

It seems Argos (for example) charge immediately for pre-orders whereas Game.co.uk doesnt charge until dispatch so I know not all companies are the same.

I have read around yahoo answers already but most ofthe answers presume the reader has some sort of knowledge before hand about what the hell they are doing ha

I want to hang a large mirror (10 - 15 kg and 1.2m x 1m) on the wall however I dont even know where to start.

1) How do I know the material construction of the wall? I guess if its brick it will be stronger but I have a feeling it isnt cos when I knock it it sounds less solid. I am choosing between an interior wall between bedroom and wall OR the wall between our house and the next (terraced).

2) It has a wooden frame about 1 inch thich and 2 inches wide. No attachments on there so I guess I will have to screw something in myself.

3) Where/how/what screws etc? I only have a screwdriver at my disposal. Might be able to forge a hammer out of something.

As you can see, total novice! Any help very appreciated. Thanks

Want to get one for my mum for xmas. There are so many about. I want one thats not sick and twisted - just fun, engrossing with a great story and requires some thinking. I know of the Phoenix games but Im not sure she is into anime type stuff - more real to life would be good.

Thanks

We take our electrics from a coin meter as we live in an apartment-like block where each room is like a little bedsit. I have noticed that it runs out super quick and I have been advised by the neighbours that the egency we rent it off does make the meter run faster than it should through the mains. Is this legal?

If possible, can any answers be backed up with some document online or anywhere as I need to use this in a letter to them.

Thanks everyone.

I have been watching 'das boot' lately - a very good film about a submarine in WW2. In one part of it the crew of the submarine visit spain - a neautral country. This leads to my question - how does a country declare itself neutral? I thought the Germans wanted world domination, yet they left countries such as switzerland and spain completely alone. They could have invaded and secured more land and wealth etc. In that way, how does being 'neutral' stop any invasion?

Thanks all

I am pretty sure this is a simple one.

The basic pseudo code is this:

If value in cell I2 is "x" then copy the whole row (2) into worksheet "x" (where x is a number that will be in cell I2)

This code needs to work for every cell in the I column.

For example, I2 to I10 might be full of 1s, therefore all rows 2 to 10 need to go into the worksheet 1...etc

So excel needs to test the value of every cell in the I column that is not empty and apply this formula.

Thanks