Lucky Ten Thousand (TIL)

Things that don't belong anywhere else. (Check first).

Moderators: Moderators General, Prelates, Magistrates

User avatar
teenidle
Posts: 167
Joined: Sat Jun 08, 2013 9:15 pm UTC
Location: Europe

Re: Today I Learned

Postby teenidle » Sun Jun 09, 2013 7:15 pm UTC

Note to self: The fact that someone has 1000+ posts doesn't necessarily mean they're not an idiot.

User avatar
You, sir, name?
Posts: 6983
Joined: Sun Apr 22, 2007 10:07 am UTC
Location: Chako Paul City
Contact:

Re: Today I Learned

Postby You, sir, name? » Sun Jun 09, 2013 7:17 pm UTC

Eheh. What could you possibly mean?
I edit my posts a lot and sometimes the words wrong order words appear in sentences get messed up.

User avatar
SecondTalon
SexyTalon
Posts: 26528
Joined: Sat May 05, 2007 2:10 pm UTC
Location: Louisville, Kentucky, USA, Mars. HA!
Contact:

Re: Today I Learned

Postby SecondTalon » Mon Jun 10, 2013 2:05 am UTC

teenidle finally finished my post history.
heuristically_alone wrote:I want to write a DnD campaign and play it by myself and DM it myself.
heuristically_alone wrote:I have been informed that this is called writing a book.

User avatar
teenidle
Posts: 167
Joined: Sat Jun 08, 2013 9:15 pm UTC
Location: Europe

Re: Today I Learned

Postby teenidle » Mon Jun 10, 2013 8:47 pm UTC

nope. i'll never get past how much i hate your avatar. it reminds me of a very very sad time in my life when i watched PGSM. :|

User avatar
Felstaff
Occam's Taser
Posts: 5178
Joined: Fri Feb 01, 2008 7:10 pm UTC
Location: ¢ ₪ ¿ ¶ § ∴ ® © ™ ؟ ¡ ‽ æ Þ ° ₰ ₤ ಡಢ

Re: Today I Learned

Postby Felstaff » Mon Jun 10, 2013 11:24 pm UTC

teenidle wrote:Note to self: The fact that someone has 1000+ posts doesn't necessarily mean they're not an idiot.

In fact, quite the opposite.


It keeps us occupied.
Away, you scullion! you rampallion! You fustilarian! I'll tickle your catastrophe.

User avatar
Yoshisummons
Posts: 93
Joined: Tue Nov 20, 2012 6:47 pm UTC
Location: Happily curled up in a cardboard box alone

Re: Today I Learned

Postby Yoshisummons » Tue Jun 11, 2013 5:53 am UTC

eran_rathan wrote:Listen to the man with the cone on his head - these are Words of WisdomTM.

User avatar
SecondTalon
SexyTalon
Posts: 26528
Joined: Sat May 05, 2007 2:10 pm UTC
Location: Louisville, Kentucky, USA, Mars. HA!
Contact:

Re: Today I Learned

Postby SecondTalon » Tue Jun 11, 2013 1:48 pm UTC

teenidle wrote:nope. i'll never get past how much i hate your avatar. it reminds me of a very very sad time in my life when i watched PGSM. :|


Huh. So that was the name of the show. I had no idea*.



*I'm certain I looked it up before, I just don't give enough of a crap to remember past 20 minutes or so.
heuristically_alone wrote:I want to write a DnD campaign and play it by myself and DM it myself.
heuristically_alone wrote:I have been informed that this is called writing a book.

User avatar
roband
Posts: 2545
Joined: Tue Sep 21, 2010 2:52 pm UTC
Location: UK

Re: Today I Learned

Postby roband » Tue Jun 11, 2013 1:51 pm UTC

TIL you can loop nest if statements in Excel/Drive-Spreadsheets.
Last edited by roband on Tue Jun 11, 2013 2:08 pm UTC, edited 1 time in total.

User avatar
bluebambue
An der schönen blauen Donau
Posts: 900
Joined: Wed Oct 03, 2007 5:14 am UTC

Re: Today I Learned

Postby bluebambue » Tue Jun 11, 2013 1:54 pm UTC

Using VBA? If not, do explain.

User avatar
JBJ
Posts: 1263
Joined: Fri Dec 12, 2008 6:20 pm UTC
Location: a point or extent in space

Re: Today I Learned

Postby JBJ » Tue Jun 11, 2013 2:05 pm UTC

roband wrote:TIL you can loop if statements in Excel/Drive-Spreadsheets.

Do you mean nest? like "=IF(condition, IF(condition, true, false), IF(condition, true, false)) "
If not, do explain.
So, you sacked the cocky khaki Kicky Sack sock plucker?
The second cocky khaki Kicky Sack sock plucker I've sacked since the sixth sitting sheet slitter got sick.

User avatar
roband
Posts: 2545
Joined: Tue Sep 21, 2010 2:52 pm UTC
Location: UK

Re: Today I Learned

Postby roband » Tue Jun 11, 2013 2:07 pm UTC

Yeah, that's what I meant. Sorry for the confusion, I'll edit.

User avatar
Giant Speck
Bouncy Sex Marshmallow
Posts: 3819
Joined: Tue Sep 08, 2009 12:30 pm UTC
Location: Tucson, Arizona

Re: Today I Learned

Postby Giant Speck » Tue Jun 11, 2013 4:39 pm UTC

Speaking of Excel -- which I barely know how to use -- I wish there was an easier way to fill a column using "Fill Down/Left" than just hitting Ctrl+D for each cell. Surely, there's an easier way.
Last edited by Giant Speck on Tue Jun 11, 2013 6:31 pm UTC, edited 1 time in total.
"Did I say recently that I love Giant Speck? Because I love Giant Speck. He is the best." - Weeks
BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE

User avatar
Diemo
Posts: 396
Joined: Mon Dec 03, 2007 8:43 pm UTC

Re: Today I Learned

Postby Diemo » Tue Jun 11, 2013 4:41 pm UTC

I am not sure exactly what you mean by Fill Down, but you should be able to bring your mouse to the corner of the cell and then (when it changes into a cross) drag down, to put the contents of that cell in every cell you drag to.
In the beginning the Universe was created.
This has made a lot of people very angry and been widely regarded as a bad move.
--Douglas Adams

User avatar
Giant Speck
Bouncy Sex Marshmallow
Posts: 3819
Joined: Tue Sep 08, 2009 12:30 pm UTC
Location: Tucson, Arizona

Re: Today I Learned

Postby Giant Speck » Tue Jun 11, 2013 4:46 pm UTC

Say you used a function in one cell (e.g. D2=B2+C2). Filling down, applies the same function to a cell directly under the cell with the function in it. For example, filling down would cause D3 to be equal to B3+C3, D4=B4+C4, D5=B5+C5, and so forth.
"Did I say recently that I love Giant Speck? Because I love Giant Speck. He is the best." - Weeks
BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE

User avatar
Diemo
Posts: 396
Joined: Mon Dec 03, 2007 8:43 pm UTC

Re: Today I Learned

Postby Diemo » Tue Jun 11, 2013 4:52 pm UTC

Yeah, you should be able to click and drag. It will copy the function exactly. You want to be on the bottom right corner, cursor will turn into a cross (white, or black possible). I can't screen-shot it because I am on linux at the moment.

If you want the same function but with one of the cells constant (e.g. D2 = B2+C2, D3 = B2+C3, etc) then you simply write the constant cell with dollar signs ($B$2) instead. That make sense?
In the beginning the Universe was created.
This has made a lot of people very angry and been widely regarded as a bad move.
--Douglas Adams

User avatar
Giant Speck
Bouncy Sex Marshmallow
Posts: 3819
Joined: Tue Sep 08, 2009 12:30 pm UTC
Location: Tucson, Arizona

Re: Today I Learned

Postby Giant Speck » Tue Jun 11, 2013 5:52 pm UTC

Oh, holy shit, that does work. Thank you! That has been bugging me for the longest time.
"Did I say recently that I love Giant Speck? Because I love Giant Speck. He is the best." - Weeks
BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE

User avatar
pseudoidiot
Sexy Beard Man
Posts: 5100
Joined: Mon Apr 21, 2008 9:30 pm UTC
Location: Kansas City
Contact:

Re: Today I Learned

Postby pseudoidiot » Tue Jun 11, 2013 6:22 pm UTC

Ooh, I didn't know how to make one of the cells a constant like that. That saves some time.

And if you have a number in a cell and you want to just copy it a bunch down, but not auto-increment you can highlight however many cells and hit ctrl-d
Derailed : Gaming Outside the Box.
SecondTalon wrote:*swoons* I love you, all powerful pseudoidiot!
ShootTheChicken wrote:I can't stop thinking about pseudoidiot's penis.

User avatar
bluebambue
An der schönen blauen Donau
Posts: 900
Joined: Wed Oct 03, 2007 5:14 am UTC

Re: Today I Learned

Postby bluebambue » Tue Jun 11, 2013 6:35 pm UTC

And if you have one column already populated and you want to fill down a second column to the length of the first, you can double click on the lower right-hand corner of the cell you want to fill down. This is very helpful when the columns are long.

Also CTRL + Shift + arrow key is a great way to navigate the cursor around the spreadsheet.

DSenette
Posts: 2418
Joined: Fri Mar 06, 2009 8:08 pm UTC

Re: Today I Learned

Postby DSenette » Tue Jun 11, 2013 8:38 pm UTC

The Righteous Hand Of Retribution
"The evaporation of 4 million who believe this crap would leave the world an instantly better place." ~Andre Codresu (re: "the Rapture")

User avatar
roband
Posts: 2545
Joined: Tue Sep 21, 2010 2:52 pm UTC
Location: UK

Re: Today I Learned

Postby roband » Wed Jun 12, 2013 8:12 am UTC

I love learning new things about software.

User avatar
The Scyphozoa
Posts: 2871
Joined: Sun Jun 01, 2008 6:33 pm UTC
Location: Sector 5

Re: Today I Learned

Postby The Scyphozoa » Wed Jun 12, 2013 1:26 pm UTC

Y-you didn't say what you learned.
Image
3rdtry wrote:If there ever is another World War, I hope they at least have the decency to call it "World War 2: Episode One"

doogly wrote:murder is a subset of being mean

User avatar
roband
Posts: 2545
Joined: Tue Sep 21, 2010 2:52 pm UTC
Location: UK

Re: Today I Learned

Postby roband » Wed Jun 12, 2013 1:30 pm UTC

'twas in reference to all the above posts.

User avatar
Zarq
Posts: 1993
Joined: Mon Jul 26, 2010 7:29 pm UTC
Location: Third Rock from Earth's Yellow Sun

Re: Today I Learned

Postby Zarq » Wed Jun 26, 2013 2:58 pm UTC

TIL what a filibuster is. That's just the most ridiculous concept ever. It's a veto-by-endurance. Why is that still legal?
You rang?

"It is better to shit yourself, than to die of constipation." - Some picture on reddit

User avatar
The Scyphozoa
Posts: 2871
Joined: Sun Jun 01, 2008 6:33 pm UTC
Location: Sector 5

Re: Today I Learned

Postby The Scyphozoa » Wed Jun 26, 2013 6:30 pm UTC

Yup. Sure is fun to watch people lose their minds over the timestamp change while blogs non-sarcastically and proudly call the filibuster "democracy in action".
Image
3rdtry wrote:If there ever is another World War, I hope they at least have the decency to call it "World War 2: Episode One"

doogly wrote:murder is a subset of being mean

User avatar
SurgicalSteel
Posts: 1926
Joined: Tue Jan 19, 2010 4:18 pm UTC
Location: DMV, USA

Re: Today I Learned

Postby SurgicalSteel » Wed Jun 26, 2013 6:40 pm UTC

The thing is, there are different reasons for filibustering. When it's done to prevent an issue from being voted on because you don't like the way it's likely to turn out, yea, that's shitty and most definitely not democracy. But I liked it when Rand Paul did it (even though I'm generally not a fan of his) while waiting for an answer from Holder about drones. His filibuster wasn't about preventing a vote, it was about preventing a vote until he got an answer to a very important question. It was basically, "look, answer my goddam question or this congress is coming to a screeching halt."
"There's spray paint on the teleprompter
Anchorman screams that he's seen a monster (mayday)
There's blood stains on his shirt (mayday)
They say that he's gone berserk."
--Flobots "Mayday"

User avatar
Tomlidich the second
Posts: 1230
Joined: Thu Mar 22, 2012 5:38 pm UTC

Re: Today I Learned

Postby Tomlidich the second » Wed Jun 26, 2013 6:50 pm UTC

so essentially, we have an athletic endurance competition, to determine the laws that guide our country?

im not sure what to be more upset about, that it exists, that i did not know about it, or that it has existed for so long.
Image

User avatar
SecondTalon
SexyTalon
Posts: 26528
Joined: Sat May 05, 2007 2:10 pm UTC
Location: Louisville, Kentucky, USA, Mars. HA!
Contact:

Re: Today I Learned

Postby SecondTalon » Wed Jun 26, 2013 7:32 pm UTC

Sorta? Or it could just be that if you piss someone off long enough, they'll talk for as long as it takes to make their point. On the US National level, it's not allowed in the House, and the Senate can be defeated if 60 of the 100 vote to get on with it. At least on the National scale, one pissed off Senator can't drag the whole thing to a close - they've got to make sure at minimum of 40 other senators are cool with it, or they risk business carrying on without them.

Now on the State level.... well, that all depends on the State.
heuristically_alone wrote:I want to write a DnD campaign and play it by myself and DM it myself.
heuristically_alone wrote:I have been informed that this is called writing a book.

User avatar
pseudoidiot
Sexy Beard Man
Posts: 5100
Joined: Mon Apr 21, 2008 9:30 pm UTC
Location: Kansas City
Contact:

Re: Today I Learned

Postby pseudoidiot » Wed Jun 26, 2013 9:19 pm UTC

And even then there's only 13 state legislatures that allow filibusters (according to Wikipedia).
Derailed : Gaming Outside the Box.
SecondTalon wrote:*swoons* I love you, all powerful pseudoidiot!
ShootTheChicken wrote:I can't stop thinking about pseudoidiot's penis.

User avatar
Tomlidich the second
Posts: 1230
Joined: Thu Mar 22, 2012 5:38 pm UTC

Re: Today I Learned

Postby Tomlidich the second » Wed Jun 26, 2013 9:44 pm UTC

ok, so not TOOO bad.


still, people are quite silly from time to time.
Image

User avatar
Case
Posts: 6
Joined: Fri Jun 14, 2013 11:30 pm UTC
Location: Edge of the World

Re: Today I Learned

Postby Case » Wed Jun 26, 2013 10:08 pm UTC

Today I learned that being a recently registered long-time lurker with exactly zero posts to date makes me (not suprisingly) unable to share pictures of our real life xkcd comic reenactment. So, hopefully, this is the first step in that direction ;)

User avatar
teenidle
Posts: 167
Joined: Sat Jun 08, 2013 9:15 pm UTC
Location: Europe

Re: Today I Learned

Postby teenidle » Thu Jun 27, 2013 11:58 am UTC

TIL that some people listen to Lana del Rey when they're sad. :?

User avatar
Giant Speck
Bouncy Sex Marshmallow
Posts: 3819
Joined: Tue Sep 08, 2009 12:30 pm UTC
Location: Tucson, Arizona

Re: Today I Learned

Postby Giant Speck » Thu Jun 27, 2013 2:45 pm UTC

teenidle wrote:TIL that some people listen to Lana del Rey when they're sad. :?

I've got that summertime, summertime sadness.
"Did I say recently that I love Giant Speck? Because I love Giant Speck. He is the best." - Weeks
BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE BOUNCE

User avatar
UniqueScreenname
Something something Purple. Stop asking.
Posts: 1430
Joined: Mon Oct 24, 2011 8:11 pm UTC
Location: The Restaurant at the End of the Universe

Re: Today I Learned

Postby UniqueScreenname » Fri Jun 28, 2013 2:31 am UTC

teenidle wrote:TIL that some people listen to Lana del Rey when they're sad. :?

I listen to Lana and it makes me sad.

♪♫ It's only worth living if somebooooooody is loving yoooooooou, and baby now you do. ♪♫

Seriously, she is such a jerk.

But I love that song so much.
PolakoVoador wrote:Pizza is never a question, pizza is always the answer.
poxic wrote:When we're stuck, flailing, and afraid, that's usually when we're running into the limitations of our old ways of doing things. Something new is being born. Stick around and find out what it is.

User avatar
teenidle
Posts: 167
Joined: Sat Jun 08, 2013 9:15 pm UTC
Location: Europe

Re: Today I Learned

Postby teenidle » Fri Jun 28, 2013 8:08 am UTC

UniqueScreenname wrote:
teenidle wrote:TIL that some people listen to Lana del Rey when they're sad. :?

I listen to Lana and it makes me sad.

♪♫ It's only worth living if somebooooooody is loving yoooooooou, and baby now you do. ♪♫

Exactly!

User avatar
Tomlidich the second
Posts: 1230
Joined: Thu Mar 22, 2012 5:38 pm UTC

Re: Today I Learned

Postby Tomlidich the second » Tue Jul 02, 2013 5:07 pm UTC

TIL googling songs that make other people sad, when you yourself are having some tough times, is probably not the best ideas.

time to find some cat videos.
Image

User avatar
Magnanimous
Madmanananimous
Posts: 3491
Joined: Wed Feb 17, 2010 7:11 pm UTC
Location: Land of Hipsters and Rain (LOHAR)

Re: Today I Learned

Postby Magnanimous » Thu Jul 04, 2013 7:41 pm UTC

TIL the guy who wrote the US Pledge of Allegiance was a hardcore socialist, which probably wouldn't be taken too well today. Also the phrase "my flag" was changed to "the flag of the United States of America" in 1923 because of concerns that immigrants would salute their home country's flag.

User avatar
teenidle
Posts: 167
Joined: Sat Jun 08, 2013 9:15 pm UTC
Location: Europe

Re: Today I Learned

Postby teenidle » Sat Jul 06, 2013 7:27 am UTC

TIL that vacuuming can only be done in the morning while I'm still trying to sleep. I missed being home...

Sheikh al-Majaneen
Name Checks Out On Time, Tips Chambermaid
Posts: 1075
Joined: Fri Jan 01, 2010 5:17 am UTC

Re: Today I Learned

Postby Sheikh al-Majaneen » Sat Jul 06, 2013 5:18 pm UTC

teenidle wrote:TIL that vacuuming can only be done in the morning while I'm still trying to sleep. I missed being home...

When I had just begun attending university, the first thing I learned is that 8 AM is the best time to begin construction and renovation of buildings near dorms.

User avatar
UniqueScreenname
Something something Purple. Stop asking.
Posts: 1430
Joined: Mon Oct 24, 2011 8:11 pm UTC
Location: The Restaurant at the End of the Universe

Re: Today I Learned

Postby UniqueScreenname » Sat Jul 06, 2013 6:13 pm UTC

TIL that there are only 7 US states that don't have state tax, and I'm living in one of them. It's hard to hate living somewhere while it would be more expensive to live almost anywhere else.
PolakoVoador wrote:Pizza is never a question, pizza is always the answer.
poxic wrote:When we're stuck, flailing, and afraid, that's usually when we're running into the limitations of our old ways of doing things. Something new is being born. Stick around and find out what it is.

Fire Brns
Posts: 1114
Joined: Thu Oct 20, 2011 2:25 pm UTC

Re: Today I Learned

Postby Fire Brns » Mon Jul 08, 2013 5:00 pm UTC

TIL the first crime solved by fingerprint identification was in 1892 in Argentina and the first crime solved by fingerprints pulled off human skin was in 1979 in Miami.
Pfhorrest wrote:As someone who is not easily offended, I don't really mind anything in this conversation.
Mighty Jalapeno wrote:It was the Renaissance. Everyone was Italian.


Return to “General”

Who is online

Users browsing this forum: Google [Bot] and 30 guests