The latter.
Stupid Questions |OT| of questions that don't deserve their own threads
- Thread starter Cyan
- Start date
- Status
The latter.
wolfmat
Confirmed Asshole
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
Member
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.
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.
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.
WoWwiki said:
http://www.wowwiki.com/Transmogrification
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.
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
Member
nvm
José Mourinho
cocknose
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.
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.
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.
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
Member
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.)
José Mourinho
cocknose
Thanks mate. Much appreciated.
I think it would be E3/D3*C3. Unless I'm misunderstanding what that last column is supposed to be.
José Mourinho
cocknose
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.
José Mourinho
cocknose
By the end of it I'll have IF statements coming out the ass. Probably just leave it.
For formatting reasons really. It wont be there in the finished product. I just threw that together to take a screen.
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.
Maklershed
Member
The scam was that good eh?
José Mourinho
cocknose
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.Haha
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.
I'll give the suggested IF statement a go when I get home.
Cheers for the input guys.
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
Banned
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?
Sincerely,
Buddha Beam
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?
Sincerely,
Buddha Beam
But does it charge it?
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.
archnemesis
Member
A tape for digital recording. There are a bunch of different formats and you can read more here.
No. But what you do is get a car charger with a USB peice on it and just get an extra iPod USB cable.
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?
Professor Beef
Banned
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
Member
#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?
#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?
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
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 want to know this too.
#4 The one who picked it first I think.
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.
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
Confirmed Asshole
José Mourinho
cocknose
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.
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.
NotTheGuyYouKill
Member
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
Member
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.
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
Link for reference: http://www.youtube.com/watch?v=cbEvmJmw7fI&feature=related
- Status