Tavern on the Meta

Bart

3:02 PM

@hichris123 sigh ... that wasn't the ping we needed

hichris123

okay nevermind that's a bad idea.

Bart

:)

vba4all

downvote & close

-1

Q: EXCEL how to sum up a row up with different ranges

How to sum up a row using Excel VBA OR using an Excel formula, if the number of cells in that row could vary - and then place its answer in the last cell on that row - and then repeat this for every row?

and please explain to the answerer that poor questions shouldnt be answered. thanks

Bart

Anything else we can do for you?

2

Shadow Wizard

@Bart Coffee please, thanks.

Bart

3:15 PM

@ShadowWizard good idea. Brb

hichris123

Me too!

Braiam

Am I late?

hichris123

@Braiam Yes. Maybe. No.

Braiam

¬_¬

Pham

Low Quality A (38.1%): 3566666655555555555555555555555, by Ahmet, on android.stackexchange.com.

Bart

3:20 PM

Okay, coffee for all of you. Come and get it

Shadow Wizard

yay!

Hey, you put white pepper instead of sugar!

Bart

Frappusneezo.

Shadow Wizard

@Bart God bless you

(that was a sneeze, right?)

ArceusMaster0493

Hi

Bart

o/

Shadow Wizard

3:23 PM

Hey @Arc

ArceusMaster0493

Hi there can someone kindly review this and see if it can be reopened? meta.stackexchange.com/questions/246425/…

Mooseman

reopen-pls meta.stackexchange.com/q/246799/202832

@ArceusMaster0493 reopen vote cast

vba4all

@Bart that's it! thanks ;)

ArceusMaster0493

@Mooseman I actually flagged 'cause of duplicate

vba4all

just one more vote needed though -> stackoverflow.com/q/27841498/2140173

Mooseman

3:26 PM

@vba4all boom

vba4all

@Mooseman made my day!

Shadow Wizard

@ArceusMaster0493 sure, voted to reopen.

ArceusMaster0493

@ShadowWizard Thanks

Bart

@ArceusMaster0493 voted

ArceusMaster0493

@Bart Thank you :D

Shadow Wizard

3:28 PM

Also added meta tag since it's specific to MSE itself

ArceusMaster0493

@ShadowWizard Oh. Sure. Thanks.

Ugh need just 1 more vote

(off topic) what is the SE shop

Shadow Wizard

@ArceusMaster0493 there used to be an online shop (website) selling stuff like T-shirts and mugs with Stack Overflow logo. Closed some years ago.

ArceusMaster0493

@ShadowWizard Oh. Wow, SE even have (had) merchandise :O

Braiam

@Mooseman why?

Bart

@ShadowWizard that reminds me, you were here for the MSO/MSE switchover as well, right?

Did you ever fill out Abby's post for swag?

Shadow Wizard

3:34 PM

@Bart yup, and even before that. Few years.

Bart

I meant the event

Mooseman

@Braiam Incorrect duplicate. This question pertains to handling the tag rather than only adding a synonym.

Shadow Wizard

@Bart hmm.... I think it was only for people from USA so no. :(

Bart

@ShadowWizard ah, that might explain it. I think I filled that out but never got anything

ArceusMaster0493

@Mooseman But [stackexchange] is [stack-exchange] right

Braiam

3:35 PM

@Mooseman mm... both questions wants the tag deleted, no?

Shadow Wizard

@Bart yup, I remember few people asked and got clear answer "sorry, can't ship outside of USA this time"

Bart

Booooh. I was promised a mug. For lots of coffee

2

Mooseman

@ArceusMaster0493 [stack-exchange] was added as a synonym of [stackexchange] as a result of the old question. The new question asks that [stackexchange] be removed.

Shadow Wizard

But hey, I did get a T-shirt and bunch of stickers :D

Bart

@ShadowWizard I got nothing but stars. Glorious shiny stars

2

ArceusMaster0493

3:36 PM

@Mooseman But still your question's whole idea is the same as meta.stackexchange.com/questions/237139/…

Shadow Wizard

@Bart here, another one for you :P

@ArceusMaster0493 true. 100% duplicate.

Mooseman

@ArceusMaster0493 That would be an acceptable dupe.

ArceusMaster0493

@Mooseman Yay.

@Mooseman And THAT is what ShadowWizard is talking about XD

nicael

15

Q: Is there a way to turn off this disturbing green light from the status bar?

Unlike notifications for the incoming messages, this number is absolutely POINTLESS. It requires no actual action to perform, yet it jumps in the eye with the same force. I don't like no pointless interface elements, Thank you. Besides that, what I am supposed to do by noticing it? To race and s...

feature-request status-declined top-bar

Who doesn't like this green indicator?! :P

ArceusMaster0493

@nicael MEE LIKE +REP

Infinite Recursion

3:39 PM

@ArceusMaster0493 done

ArceusMaster0493

@InfiniteRecursion :D Thanks so much

Shadow Wizard

ArceusMaster0493

@InfiniteRecursion I used like 2 days (?) to fix that

Shadow Wizard

If anyone can explain how those two are not dupes, it would be great ^^

ArceusMaster0493

@ShadowWizard The titles are not the same

@ShadowWizard Does that count

Shadow Wizard

3:41 PM

lol

Titles can't be the same actually, you get error message when submitting.

ArceusMaster0493

@ShadowWizard And also Moose's +vote is way worse than the original one

Infinite Recursion

@Bart You have too may stars :(

ArceusMaster0493

@InfiniteRecursion Gave ya one

@InfiniteRecursion :P

Bart

@InfiniteRecursion There is no such thing as too many stars

Infinite Recursion

@ArceusMaster0493 Thanks :D

ArceusMaster0493

3:43 PM

@InfiniteRecursion np

gotta sleep cya tmr thx 4 da reopen votez thx so much :3

Pham

Bad Tag(s) Used: [api] | youtube api wont work after changing display-setting on mobile, by Peter, on stackoverflow.com.

Infinite Recursion

@Bart How many stars do you have?

Bart

@InfiniteRecursion never enough

(not a clue really)

Infinite Recursion

@Bart :O

Shadow Wizard

@Bart chat.meta.stackexchange.com/rooms/info/89/tavern-on-the-meta/…

how many pages?

Infinite Recursion

3:46 PM

The correct answer is 'too many stars'

inb4 infinite

Bart

@ShadowWizard just 16 ... that's like nothing

Shadow Wizard

wow, less than 800 stars

what a shame :D

hmm... maybe it's capped to 800?

Braiam

/me has 6

Bart

It seems capped because it only goes back to September 2013 ... surely I was here before then.

Shadow Wizard

hmm....

Infinite Recursion

3:48 PM

/me has 10

Shadow Wizard

@Bart chat.meta.stackexchange.com/rooms/info/89/tavern-on-the-meta/…

what you get now?

Bart

16

Shadow Wizard

dang, it's only saving latest 800.

needz script to crawl all starred messages

hichris123

Eeek I have 7.

@Fundamental That obviously means I spend too much time in here.

Infinite Recursion

Eeek!

Shadow Wizard

3:51 PM

I have 4! But I'm proud of this small... number. :D

Braiam

@ShadowWizard or you know... data dump of chat.*

Shadow Wizard

@Braiam /facepalm

Braiam

4

Q: Adding chat transcripts as an available data dump

Since the chat system has received a bit more love recently (thank you @balpha), it would appear now is the time to make any suggestions regarding additional functionality. Chat is still an important part of the system (albeit it secondary) and has an emphasis that's it public, so should be avai...

discussion feature-request chat

Bart

Want to know what my most starred post is @ShadowWizard?

Shadow Wizard

@Bart sure!

Bart

3:58 PM

Apr 29 '14 at 8:06, by Bart

"Hello, my name is Shadow Wizard, and I am a rep vulture." ... HI SHADOW WIZARD!

Patrick Hofman

Recommendation: stackoverflow.com/questions/27844238/…

Jan Dvorak

closed

hichris123

@Bart rofl

This was the most starred message that I've starred:

Apr 16 '14 at 21:43, by Tim Post

Just kidding all, we're not really splitting. This was the most elaborate hoax for a rep-cap EVAR.

Shadow Wizard

@Bart hahaha, awesome

Jan Dvorak

Yay! 15krep

Patrick Hofman

4:01 PM

Yay! 35K :) + 1 -> stackoverflow.com/users/993547/patrick-hofman

@JanDvorak + 10 :)

Bart

Congrats to you both

Jan Dvorak

It wasn't round in the first place :-)

hichris123

@PatrickHofman downvotes

:P

Patrick Hofman

@hichris123 You need to lot to get me at 1 again :)

Bart

thinks of elaborate plot to get @PatrickHofman suspended

Andy

4:03 PM

@Bart I needs to involve sporks somehow

7 of them

Patrick Hofman

@Bart Can we do Jon instead? It doesn't seem fair to me he has the most reputation

Bart

@Andy well d'uh

Patrick Hofman

Going home afraid. Waiting to see how much rep is left tomorrow

hichris123

@PatrickHofman That would be the largest rep drop ever. 330k+ -> 1 rep.

Bart

@PatrickHofman Jon is the star we orbit. Removing his gravitational effect can't be good for any of us.

Shadow Wizard

4:06 PM

@hichris123 +1, you're totally right! ;)

hichris123

@ShadowWizard -0, obsolete. :P

Shadow Wizard

ninja edits rulz

SmokeDetector

[ SmokeDetector ] All-caps title: CALCULATE THE SURFACE INTEGRAL by user206513 on math.stackexchange.com

user259867

@SmokeDetector edited

Frank

uh

17

Q: Moderator Pro Tempore

This community needs to start contributing some names they would like to act as provisional Moderators. Please read this: Moderators Pro Tempore. Here are some basic guidelines: Each nomination should be a separate answer. Link the name to the user’s profile (parent and meta) so we can see th...

discussion featured moderation

Zach deletes his nomination.

user259867

4:16 PM

Good for him.

Frank

He should've just edited in his decline.

Sam

4:32 PM

cv-pls stackoverflow.com/questions/27824140/…

rene

clever give me the code plz

Mooseman

cv-pls stackoverflow.com/q/27845070/1234256

Infinite Recursion

naa-ish meta.lifehacks.stackexchange.com/a/2344

user259867

@Frank Editing in "I decline" into self-nomination would be kind of strange.

user259867

> She generally gave herself very good advice (though she very seldom followed it), and sometimes she scolded herself so severely as to bring tears to her eyes; and once she remembered trying to box her own ears for having cheated herself in a game of croquet she was playing against herself

Infinite Recursion

4:43 PM

^^^^

Frank

true.

His interest was short-lived...

user259867

> I have too many ideas. I have even more things to do.

user259867

And the spring semester is about to begin, or already began.

Unihedro

So we won't have cat gifs?

hichris123

@Fundamental huh?

rene

4:44 PM

cv-psl dup stackoverflow.com/questions/27845028/…

user259867

@hichris123 Never read Alice in Wonderland?

Bart

2

Infinite Recursion

I like the pearl pendant your cat is wearing

hichris123

@Fundamental It's... been a while. Like 6 years perhaps?

user259867

Time to re-read it, then. :)

Frank

4:47 PM

@Fundamental Well if that's the reason, he was kinda short-sighted in nominating himself

rene

Stop following me with your eyes cat...

Frank

@rene Why are you swaying back and forth?

Infinite Recursion

Not nice to discuss a person's decisions in his absence, why not ping him on LH chat?

Frank

@InfiniteRecursion I did.

I told him what I thought.

Infinite Recursion

Did he respond?

Frank

4:49 PM

@InfiniteRecursion no

Braiam

3

Sam

Aww, it's cuter than bjb.

5

Frank

@Braiam looks like a slow mo of taking a gut punch

Braiam

@Sam Y U GET MOAR STARS?!

Sam

@Braiam 'Cuz I wear a fake nose + moustache?

Bart

4:53 PM

... wait, what? Next you'll tell me those aren't really glasses either.

3

Braiam

@Bart's most painful realization finally arrived

Sam

They're real, actually.

Infinite Recursion

Mod nomination is an individual's decision, better to respect it @Frank. And as @Fundamental already said; writing I decline in a self-nomination doesn't make sense.

in The Junk Drawer on The Stack Exchange Network Chat, 11 hours ago, by Zach Saucier

@J.Musser not interested anymore :P

Frank

See, I have no problems, cause I have no glasses. watches in amusement

@InfiniteRecursion as said, that was short lived...

like less than 30 days.

Mooseman

star-pls brown. unicorns. serving waffles.

3

Sam

4:56 PM

@Frank At least I don't leaf a trail of leaves wherever I go ;)

@Mooseman You forgot the waffles!

Mooseman

@Sam FR Completed ;)

Sam

:D

Frank

@Sam eh, neither to I. Look carefully at my dp. ;)

Pham

Low Quality Q (30.4%): I want to show in a map where the user is. Current location with Swift, by Aitor Sola, on stackoverflow.com.

Jan Dvorak

offensive superuser.com/questions/862301/jdebp-is-a-stupid-jerk

Sam

5:02 PM

@Frank must be a conspiracy

Mooseman

@JanDvorak Bill Gates is off his rocker, apparently.

Sam

... and that children, is what happens when you use Windows 8.

Braiam

ChrisF and Jon Seigel for mods on MSE because this

hichris123

Blog - Stack Exchange: Stack Exchange Year in Review 2014

Matt Sherman on January 08, 2015

We – which is to say, you, the Stack Exchange community – had another great year in 2014.

We cracked Quantcast’s top 50 networks in the US. We did this without posting celebrity gossip, top 10 lists, or cat pictures. We did it by creating artifacts: useful, canonical bits of information, edited, refined, and curated by our community.

By donating your knowledge to the largest community of developers in the world, you’ve been able to create a slice of the Internet that is indeed a better place. Amidst the noise, clutter, and chaos of the web, you’ve built one of the largest, most trusted knowledge repositories ever created. …

Mooseman

@Sam But. But. Windows 8 is great!

Frank

5:06 PM

@hichris123 WITHOUT POSTING CAT PICTURES?? Lies...

95 edits to go on GL to 1k

for me

Infinite Recursion

@hichris123 Nothing about stars :O

user259867

> 3.2 million downvotes

user259867

NOT ENOUGH

Infinite Recursion

> 21 million upvotes

Braiam

@Fundamental Hey... is a proportion 1/7 against upvotes

user259867

5:19 PM

Predictably, "most upvoted answers" category is not a great showcase for SE.

Pham

Low Quality A (100%): Your manager is a parasite and is slowly sucking you., by Edu, on workplace.stackexchange.com.

3

Sam

^ Off?

Infinite Recursion

lol, not offensive. It answers the question.

Bart

@Pham *r popsicle?

user259867

@Sam Just another day at The Workplace.

Sam

5:26 PM

@InfiniteRecursion lol ok.

user259867

The blog post does not say how many of those 3.1 million questions were deleted.

Sam

@Fundamental o_o

Bart

It doesn't even mention my utter star domination.

Infinite Recursion

Buy some mice and release them into the centre of the pile. — TheMathemagician 23 hours ago

Braiam

@metions work in the blog?

user259867

5:29 PM

@Braiam Nothing works in the blog comments.

user259867

No votes, flags, mentions...

Infinite Recursion

I am reading a few of the posts on the workplace, they are very extraordinary.

Bart

In a good way?

Infinite Recursion

No

Looks like they have too many hygiene issues and gender issues at their workplace. All of them should stop posting and find new jobs asap.

SmokeDetector

[ SmokeDetector ] All-caps title: PHP QUERY FROM WORDPRESS WRITES 2 RECORDS INSTEAD OF ONE by tjmai on stackoverflow.com

Infinite Recursion

5:40 PM

@Infinite My girlfriend has a pet unicorn, but she hasn't let me see it yet - it is (apparently) invisible. — Tim 24 mins ago

Bart

Pff, and when I show my pet Unicorn it's "oh so inappropriate".

user259867

@SmokeDetector false

SmokeDetector

@Fundamental Registered as false positive and added title to Bayesian doctype 'good'.

Infinite Recursion

@Bart You have a unicorn? :O

hichris123

6:02 PM

@Bart Were you here in the days of rchern?

SmokeDetector

[ SmokeDetector ] All-caps title: FNRCS0005E: SECURITY_INVALID_CREDENTIALS by nb2015 on stackoverflow.com

bjb568

6:18 PM

Yay, cold day, no skewl

user259867

@bjb568 How cold is cold?

bjb568

The high will be 19F

hichris123

@bjb568 skewl? rolls eyes

Sam

@bjb568 Eww, Fahrenheit.

Mooseman

bjb568

6:24 PM

!comp 19 degrees F to C

-7.222 °C (degrees Celsius)

hichris123

blog.stackoverflow.com/2015/01/year-in-review-2014/…

GnomeSlice

Today's Listening | Synthrock / Retro Electronic

NSFW Additional listening from the same artist has very NSFW cover art, so maybe don't click that one at work.

@bjb568 It's like -25 out right now for me.

bjb568

Hm… that music isn't that bad.

Aurélien Gasser

@GnomeSlice I prefixed your msg with NSFW to make it more obvious (it was flagged)

bjb568

O_O

GnomeSlice

6:31 PM

@AurélienGasser Oh, thanks.

Aurélien Gasser

Not that I'm too bothered with it, but apparently a user was, just trying to round the edges here

GnomeSlice

Whatever, all good.

Thanks for not banning me over it.

Aurélien Gasser

sure thing

bjb568

@Sam ಠ_ಠ

Sam

I have a feeling I might've just started a cat fight.

Pham

7:00 PM

Low Quality A (55.6%): Да, запятая нужна, как и после этого союза., by Superportvein, on russian.stackexchange.com.

Mooseman

in Low Quality Posts HQ, 39 secs ago, by Mooseman

@Pham fp

user259867

@Pham Kind of brief, but nothing out of ordinary. "Do I need a comma here?" - "Yes, and here too".

hichris123

@Pham why

Sam

in Low Quality Posts HQ, 1 min ago, by Pham

@Mooseman
Terms found:
^\<p\>[^a-z]*\<\/p\>$  (Sensitivity: 0.8%. Specificity: 99.8%. Ignored: 89.8%. Score: 10. Auto: True)

^(?i).{0,80}$  (Sensitivity: 36.6%. Specificity: 90.3%. Ignored: 79.2%. Score: 89. Auto: False)

Mooseman

in Low Quality Posts HQ, 49 secs ago, by Sam

@Mooseman That would be the auto-all-caps-answer term.

user259867

7:02 PM

No match for [a-z], so mistaken for an all-caps post.

hichris123

ah.

... totally means someone needs to work on their all-caps regex. ;P

Sam

Yeah, I'm still working on non-english sites.

hichris123

Smokey's is ^(?=.*[A-Z])[^a-z]*$.

Infinite Recursion

Dec 25 '14 at 13:34, by Yi Jiang

@Unihedro Might want to have the site ignore foreign language sites for that rule, at least

hichris123

No match: regex101.com/r/sY1mR5/1.

Bart

7:04 PM

@hichris123 don't think so. How so?

hichris123

@Bart Oh, I'm fairly sure she has/had a unicorn. Was thinking maybe you would have remembered it...

Sam

@InfiniteRecursion github.com/ArcticEcho/Phamhilator/issues/…

Infinite Recursion

So uni made a note of it, fair enough.

Unihedro

Yeah!

Bart

And a wild Uni appears :)

Sam

7:15 PM

I'm just sayin' I'd rather automate the process.

Infinite Recursion

uni scares me, why doesn't he sleep like a normal person? :/

Lynn Crumbling

o/

Infinite Recursion

\o

hichris123

@Sam chat.meta.stackexchange.com/transcript/message/2880229#2880229 - just fix the regex

Sam

@hichris123 This isn't an isolated issue.

hichris123

7:21 PM

@Sam I'm betting you'll still have less fp's.

Lynn Crumbling

I'm ready to be done with Polar Vortex 2.0 now.

So is my car's starter.

Infinite Recursion

After the botling era, a few fp's hardly seem like interruptions.

hichris123

6

A: Why does air seem to affect local surface temperatures so much?

The surface temperature is the temperature of the air at the surface (rather than the temperature of the ground itself). This temperature is typically taken between 1 and 2 m off the ground, and this is the temperature we feel when we are outside. Simply put, the reason air affects this tempera...

Sam

@hichris123 FPs aren't bad. They give Pham more opportunities to learn what's right/wrong.

Infinite Recursion

*they

hichris123

7:23 PM

> You mention the polar vortex, which is a often misused term which has recently come into popular vocabulary. The polar vortex is primarily a mid-upper atmospheric circulation above the poles. When you hear it on TV you are most likely hearing it misused and the generally just mean a really strong cold front with a (perhaps unseasonably) cold arctic continental airmass behind it. A front, in simple terms, is an enhanced surface temperature gradient that separates airmasses with different properties. The key feature is a strong temperature gradient -- a relatively large change in surface te…