[Cyan]

Was it obvious in the '60s, was there a period of time during TNG/Voyager/DS9 when there was still a glimmer of hope, or can we not even be certain now?

The latter.

[wolfmat]

What year did our telescopes become powerful enough that it became obvious that a Star Trek level of other inhabited planets was clearly a fantasy?

What are you talking about? We have found one planet so far that is certainly in the zone that can sustain M-class planets, we don't know of one certain M-class planet, but that doesn't mean that the galaxy isn't teaming with life. We just haven't got the technology yet to determine that.

Our telescopes aren't powerful enough for anything. We can only observe macro (star level) and indirect gravity and light source obstruction effects over distances greater than 1 lightyear.

[UncleSporky]

That's interesting.

I remembered that recent news story about a planet being observed that appears to be very earth-like, though it's like a hundred light years away.

That made me think that everywhere else we've looked, we haven't seen planets that appear to be able to support any life.

[Lireu77]

No I don't Do I have to obtain the vengeful set in order for teh transmogrification to work on my shadowcraft heirlooms?

That was what I understood from the patch notes. I am not playing myself anymore but keep me updated still and for being able to change your gear into something lookwise by transmogrifying, you need to have it first.

It seems at this point you will have to own the items you want to transform things into.

http://www.wowwiki.com/Transmogrification

[Cyan]

That made me think that everywhere else we've looked, we haven't seen planets that appear to be able to support any life.

We haven't. But it's not that we haven't seen them because they aren't there, it's that it's really difficult for us to find them. That was why actually spotting one was kind of a big deal.

[KarmaCow]

That's interesting. I remembered that recent news story about a planet being observed that appears to be very earth-like, though it's like a hundred light years away. That made me think that everywhere else we've looked, we haven't seen planets that appear to be able to support any life.

Observations of extrasolar planets is very new (like within the decade almost IIRC), mostly due to a technology. Most techniques rely on detecting minute changes in the star's spectrum that would be due to a planet, like slight dimming as the planet passing in front the star, so that's a function of the telescope's resolution and the size of the planet.

There are also finding that fraction of the billions of stars in the Milky Way that could have a planet, so that's another issue.

[MrBelmontvedere]

nvm

[Kylehimself]

Ugh, I'm trying to make an Excel sheet to calculate marks for my assignments. This in itself is supposed to be a practice for an assignment on Excel.

If I have a mark scheme like so...



How do I get Excel to produce the actual percentage achieved in the "Weighted (F)" column based on the the marks I will enter in the "Actual (E)" column?

I hope this question makes sense. Any help would be appreciated. Thanks.

[JGS]

Is there a way to warm up sushi? Krogers has good sushi at good prices. The only problem is they use the produce in store so both the packaged stuff and the stuff the chef makes is colder than I like. Can I leave it out to get to near room temp? Microwave it slightly? I'm not interested in dying.

[Zeppu]

Ugh, I'm trying to make an Excel sheet to calculate marks for my assignments. This in itself is supposed to be a practice for an assignment on Excel. If I have a mark scheme like so... How do I get Excel to produce the actual percentage achieved in the "Weighted (F)" column based on the the marks I will enter in the "Actual (E)" column? I hope this question makes sense. Any help would be appreciated. Thanks.

In the F column write '=E3/D3*100'

Even better, write '=E3/D3' which would give you a decimal value. Then from the formatting toolbar set it to display values as percentages.

Drag from the bottom right down to autofill fields. The values for the fields will match automatically increase so that calculations remain relative to the current row.

[Lucky Forward]

I have Verizon email, and whenever I paste a link into an email it just shows up as text and not as a clickable hyperlink like I want. How do I put a hyperlink into a Verizon email? (I'm not in 'plain text' mode.)

[Kylehimself]

In the F column write '=E3/D3*100' Even better, write '=E3/D3' which would give you a decimal value. Then from the formatting toolbar set it to display values as percentages. Drag from the bottom right down to autofill fields. The values for the fields will match automatically increase so that calculations remain relative to the current row.

Thanks mate. Much appreciated.

[Cyan]

In the F column write '=E3/D3*100' Even better, write '=E3/D3' which would give you a decimal value. Then from the formatting toolbar set it to display values as percentages. Drag from the bottom right down to autofill fields. The values for the fields will match automatically increase so that calculations remain relative to the current row.

I think it would be E3/D3*C3. Unless I'm misunderstanding what that last column is supposed to be.

[Kylehimself]

I think it would be E3/D3*C3. Unless I'm misunderstanding what that last column is supposed to be.

you're correct. But as it goes I had already worked it out and when I came back to edit my post it had been answered. So I just thanked the poster for their help and moved along :lol

Another Excel question. Can I set a limit on what numbers are typed in a cell? So, if the top mark available is 10. If 11 is entered in error, Excel bitches and wont allow it.

[Cyan]

you're correct. But as it goes I had already worked it out and when I came back to edit my post it had been answered. So I just thanked the poster for their help and moved along :lol Another Excel question. Can I set a limit on what numbers are typed in a cell? So, if the top mark available is 10. If 11 is entered in error, Excel bitches and wont allow it.

Well, you could use conditional formatting to make it highlight incorrect cells red, say. But if there are a bunch of different top marks, that could be a bit of a pain.

The other option is maybe using an IF statement, but it wouldn't be simple.

[Zoe]

Why is everything in the sheet starting from B2?

[Deadstar]

Does anyone know of a site that can take an image upload and tell you the source of it? Or maybe just find the high resolution version of it? It was in a youtube video and I ran a google image search but nothing came up.

[Cyan]

Tineye or reverse image search on Google.

[Kylehimself]

Well, you could use conditional formatting to make it highlight incorrect cells red, say. But if there are a bunch of different top marks, that could be a bit of a pain. The other option is maybe using an IF statement, but it wouldn't be simple.

By the end of it I'll have IF statements coming out the ass. Probably just leave it.

Why is everything in the sheet starting from B2?

For formatting reasons really. It wont be there in the finished product. I just threw that together to take a screen.

[Zeppu]

I think it would be E3/D3*C3. Unless I'm misunderstanding what that last column is supposed to be.

Haha :) I know excel but not what weighted means.

Another Excel question. Can I set a limit on what numbers are typed in a cell? So, if the top mark available is 10. If 11 is entered in error, Excel bitches and wont allow it.

Well, it's an easy IF though. Basically if value of Actual is greater than Marks then show N/A, otherwise show the actual weighted result. IF is very important to learn for excel IMHO so even though you said leave it, I'm going to explain

=IF(Condition,true,false)
=IF(E3>D3, "Error", E3/D3*C3)

Edit: Blah I still don't think I understand what weighted means, heh.

[Baconbitz]

Would someone create a "scam" thread? I think it would be a good idea to keep users up to date on up to date scams. I just came a new one in my email.

[Maklershed]

I just came a new one in my email.

The scam was that good eh?

[Baconbitz]

The scam was that good eh?

Came across*

Edit: http://www.google.com/search?hl=en&c...iw=480&bih=268

[Oreoleo]

Does anyone have a good recommendation for a car charger/FM transmitter for iPod? It seems all the ones on Amazon are cheap POS are overly expensive. Would prefer something in the $15-25 range, but I'd just like to get an idea of what people use.

[Kylehimself]

Haha :) I know excel but not what weighted means. Well, it's an easy IF though. Basically if value of Actual is greater than Marks then show N/A, otherwise show the actual weighted result. IF is very important to learn for excel IMHO so even though you said leave it, I'm going to explain =IF(Condition,true,false) =IF(E3>D3, "Error", E3/D3*C3) Edit: Blah I still don't think I understand what weighted means, heh.

Weighted is how much each part of assignment is worth. So one section is weighted at 33%, another at 17% etc. It's just the term the college use. I personally think they use it out of place. It makes more sense to have the "Marks(%)" and "Marks" column as "Weighted(%)" and "Weighted", but that's how they set it out.

I'll give the suggested IF statement a go when I get home.

Cheers for the input guys.

[Cyan]

Does anyone have a good recommendation for a car charger/FM transmitter for iPod? It seems all the ones on Amazon are cheap POS are overly expensive. Would prefer something in the $15-25 range, but I'd just like to get an idea of what people use.

I've tried a total of three or four, and honestly they're all cheap POSs that are overly expensive.

Now I have an auxiliary input with a cable straight from the iPod, and it works so much better it's kind of ridiculous.

[Buddha Beam]

Dear GAF,
Is there something like a wireless USB cable out there that is available for me to purchase?
Like as in, plug one end into your computer and the other end into a printer or hard drive or whatever and they can communicate wirelessly?
If there is, is it on Amazon and is it eligible for Prime shipping? :D

Sincerely,
Buddha Beam

[_Isaac]

I've tried a total of three or four, and honestly they're all cheap POSs that are overly expensive. Now I have an auxiliary input with a cable straight from the iPod, and it works so much better it's kind of ridiculous.

But does it charge it?

[Oreoleo]

I've tried a total of three or four, and honestly they're all cheap POSs that are overly expensive. Now I have an auxiliary input with a cable straight from the iPod, and it works so much better it's kind of ridiculous.

Yeah that's mostly been my experience as well. Was for a gift idea I had for my mom to get the charger/transmitter with a subscription to Audible.com, but I decided against it ultimately. Thanks for replying though.

[_Isaac]

What is a DV tape?

[archnemesis]

What is a DV tape?

A tape for digital recording. There are a bunch of different formats and you can read more here.

[Baconbitz]

But does it charge it?

No. But what you do is get a car charger with a USB peice on it and just get an extra iPod USB cable.

[demon]

I have a friend who wants a spaetzle press for christmas, and I'm not sure what exactly to get her here. I'm looking to get something on amazon, and I can't tell the difference between a spaetzle press and a potato ricer. Any help here? Onkel?

[Minamu]

What's a good youtube downloader plugin for firefox?

[hayejin]

What other gaming sites exist out there besides GAF? Not commercial like IGN or 1UP but something similar to GAF?

[Professor Beef]

What's a good youtube downloader plugin for firefox?

You try this one?

https://addons.mozilla.org/en-US/fir...o-downl-10137/

[JGS]

But does it charge it?

I have separate cables and both were cheap.

The main reason to use an FM transmitter is if you don't have an aux. input

[Hung Wei Lo]

#1 My shoes squeek when I walk.. at first it was just my left shoe, now it's both. There's still a decent amount of tread left too..what's the cause of it?

#2 I was typing an email, and kind of zoned out in the middle of a sentence, staring at the word 'must' ..why does it all of a sudden look funny to me? does it have something to do with taking things for granted?

#3 how do I stand on the subway without having to hold onto anything? Driving/parking is becoming ridiculous so I'm forced to take 'the better way'

edit
#4 I thought I saw in another thread someone with the same avatar as me...who has the rights to it?

[Minamu]

You try this one? https://addons.mozilla.org/en-US/fir...o-downl-10137/

Yes, it's causing some trouble and won't let me download anything. It just goes to a blank page and nothing happens. Doesn't seem to matter what format I choose. At least, it does this on some videos and not on others O_o I found a downloader that listed every suggestions video etc as well and I could pick and choose whatever I wanted to get, but I forgot the name >_<

#1 My shoes squeek when I walk.. at first it was just my left shoe, now it's both. There's still a decent amount of tread left too..what's the cause of it? edit #4 I thought I saw in another thread someone with the same avatar as me...who has the rights to it?

#1 want to know this too.
#4 The one who picked it first I think.

[Toppot]

#1 My shoes squeek when I walk.. at first it was just my left shoe, now it's both. There's still a decent amount of tread left too..what's the cause of it? #2 I was typing an email, and kind of zoned out in the middle of a sentence, staring at the word 'must' ..why does it all of a sudden look funny to me? does it have something to do with taking things for granted? #3 how do I stand on the subway without having to hold onto anything? Driving/parking is becoming ridiculous so I'm forced to take 'the better way' edit #4 I thought I saw in another thread someone with the same avatar as me...who has the rights to it?

1. Maybe some wetness has got in the tread or inside, makes mine squeak sometimes. Could be inside the tread has cracked and is squeaking, just move your foot in different ways, or bend them by hand, and see area causes it.

2. Sometimes words will look weird for no reason, usually when you are distracted mid sentence or over repeated a word. Its disrupting a common thought and making you look at it differently. Very normal.

3. I either stand at a 45 degree angle to the train, slightly apart, and one leg slightly in front of the other. This allows you to counter act the left right swinging best imo. Or lean on something.

4. Usually whoever used it first. PM them and ask when they started using that avatar, if it was before you started using yours then it's their right, If not then its yours. A mod would otherwise be the best mediator, deciding based on most posts per day or something if there is no evidence for who used it first.

[Baconbitz]

How does one stay positive when you're stressed and there is yelling...etc?

[Air]

How does one stay positive when you're stressed and there is yelling...etc?

Get out the room/take a deep breath/ think on it for a couple of seconds (what benefit will I get if I get angry, what will the detriment be)/ realize its not worth it. Be very observant, if you catch yourself starting to yell, let the other person know you don't want to take part in the discussion at that point because it's getting to you. Ask to for some time to clear your head.

[wolfmat]

What's a good youtube downloader plugin for firefox?

DownloadHelper
http://www.downloadhelper.net/

[Kylehimself]

Okay, I'm back with more Excel questions so hopefully you guys can help me finish this off. (This will be a long one)

This is an example of the mark sheets I'm going to use.



I have a main screen which uses various VLOOKUPs to pull the total marks from each module.

I'm having a few problems though. As you can see there is a filter on the left for the Students Names. If I use it to filter down to one name that's fine, as the other rows of results are hidden. However, if I filter the results to say Z-A instead of default A-Z, then the names reverse order, but the corresponding results don't. This means my VLOOKUPs on the main screen then pull the incorrect results for the selected student name. Is there a way round this? The other potential issue then is that if I were to add more student names and reset the filter so as to put them in order, the names would go in to alphabetical order but the results would remain in the same cells.

[Zoe]

I need to reset the error code in my car. Do I disconnect the negative or the positive terminal of the battery?

[NotTheGuyYouKill]

I'm going on my first overseas trip in a week. If the plane's engines fail while over the ocean (Pacific presumably), how do I survive the fall?

[dudeworld]

I'm going on my first overseas trip in a week. If the plane's engines fail while over the ocean (Pacific presumably), how do I survive the fall?

You don't

[Kccitystar]

I'm going on my first overseas trip in a week. If the plane's engines fail while over the ocean (Pacific presumably), how do I survive the fall?

in all seriousness highest chance of survival is the back of the plane

[Kyaw]

I'm going on my first overseas trip in a week. If the plane's engines fail while over the ocean (Pacific presumably), how do I survive the fall?

If ONLY the plane engine's fail, the plane should easily be able to do an emergency landing on the water. Given that it was only the engine failure (no explosions), the landing will be depend on the sea condition in the area it's landing. Then rafts, radio and stuff you'll be rescued in no time.

If the wing fell apart or the plane broke in half, you're most likely dead.

[Requiem]

What is the name of the song in Kingdom Hearts 2 E3 2005 Trailer?

Link for reference: http://www.youtube.com/watch?v=cbEvmJmw7fI&feature=related