« first day (1831 days earlier)      last day (1349 days later) » 
00:00 - 17:0018:00 - 00:00

6:02 PM
so... I just got an email from Charles Williams, saying Rob Bovey & Stephen Bullen's PerfMon VB6 tool should be in Rubberduck... and asking if he should ask them if it's ok to give us the source code under the same terms as Smart Indenter. I've never used PerfMon, but I think we have the APIs to port it.
so I replied something along the lines of sure go ahead
2
 
mumble mumble that'd be great mumble so long mumble as mug not sued.
 
did we get perfmon?
 
If we get he gets permission, there's no suing involved
 
Can't have Mug living out of a cardboard box. He'd have no place to plug is machine into and work on RD.
 
6:08 PM
no no, i just don't remember if perfmon was ever a part of deal - I've only heard about the smart indenter.
In fact I didn't know there was such thing as VB6 Perfmon until justn ow
 
^
 
@IvenBach you're wrong. That's exactly what public library is for.
he can take a shower with the water foundation.
:D
 
Oh boy...
 
@this we might. Charles has the source code, he's merely asking them for permission to forward it to me for it to be ported and included into RD
 
aha, now I follow.
pardon, there's other spot of village I've yet to drool on
 
6:10 PM
lol
 
@this ~confused
 
4 hours ago, by this
I'd say it's Monday but it's not.... so....yeah, your plain old fashioned village idiot right here.
4 hours ago, by this
wanders off aimlessly to drool
 
@IvenBach machine? I thought he did everything from his phone...
 
@this hmm ... I mean... it was a holiday yesterday, so it might as well be monday..
 
@FreeMan ya VS 2017 CE for Android is neat
 
@FreeMan I'm even more impressed now realizing he codes for RD on his phone. That's just next level stuff right there.
 
*builds solution*
...
...
...
...
...
...
*out of battery*
2
 
@MathieuGuindon That's a development from the WinCE team, right?
 
riiiiiiiiiiight :)
 
Who's Charles Williams?
 
6:16 PM
@Hosch250 Excel MVP for, what, 20 years?
huh, no - "just" 10
 
> If the problem is VBA buy "Professional Excel Development" (stephen Bullen, Rob Bovey et al): this has a free VBA profiler called PerfMon.
So that's how you get it.
 
hm, looking at his MVP activity makes me wonder if I'm not brutally under-estimating my chances for a renewal in ~gasp~ 2 weeks
I suppose MVPGA values speaking at conferences more than answering on SO though
stops anguishing over MVP renewal
 
6:32 PM
Breathe Mug.
So long as you're contributing to the Excel community, :check:, you're probably going to get renewed.
 
@Vogel612 what holiday was it yesterday? (American centric perspective)
@this wait a second... "water foundation"???
 
my dictionary says Whitsun
 
@FreeMan All public building have them, no?
@Vogel612 praise to white sun?
 
maybe Pentecost rings a bell instead?
 
Hmm. a cost for a pente sounds less interesting than white sun, if you ask me. ;-)
 
6:42 PM
@this mkay...
 
@FreeMan I take that you've had the luck to never have to see a homeless man washing himself with one.
 
I think they're usually called "water fountain", not "foundation".
 
5 hours ago, by this
I'd say it's Monday but it's not.... so....yeah, your plain old fashioned village idiot right here.
 
@Hosch250 that
:)
 
You need to get some blood flowing to your brain. Go dance a hornpipe on the office lawn :D
 
6:56 PM
Hey @MathieuGuindon, if you ordered a beer, would you expect it to be in ml or oz?
 
355ml
8oz
10oz
12oz
20oz
IDK
I order whiskey.. simpler
 
@RubberDuck I'd expect cans, no?
 
@Hosch250 710ml or 20oz?
 
@MathieuGuindon this is the right answer IMO.
 
TBH, though, most cans/bottles say both.
Or pints :)
@MathieuGuindon Just cans. I think they need to canonize that unit.
 
6:59 PM
I may have to wait for our official Canadian contact...
But, it was a good excuse to drop by.
Ohhh @ticker. How I've not missed you.
 
@RubberDuck Canadians are a bad reference for that... we mix & match everything
 
@RubberDuck What I'd do is a table of units that you could do as an FK to your table that you are using the amount in.
Then you could store N Units of anything.
 
like, I'm 6'1", don't ask me in meters
 
And then you could write converters between them.
 
but speed and distances are km/h and kilometers
fridge & outside temp is in Celsius
 
7:01 PM
WTF Canada?
 
but pool temp is F
 
LOL.
 
I just found out your ounces are not the same as our ounces too.
 
body temp could be either
 
7:01 PM
#LocalizationIsFun
 
@RubberDuck fl.oz
ounces is also a measure of weight
 
> 16 fl oz US = 16.65341 fl oz Imperial
 
wtf USA
 
You don't give your weight in stones, do you?
 
Like the ton vs long ton?
 
7:02 PM
> Also, we can under no circumstances call our 16oz pour a “Pint”.
A Pint is _legally_ 20 fl oz Imperial.
 
LOL...
 
God save the Queen?
 
@MathieuGuindon what nonsensical amount of liquid is that...
 
King cans are 710ml in Canada IIRC
and little cans are 355ml
 
@this the fascist regime
 
7:04 PM
"king cans"...
 
and now there's baby cans at 222ml
 
TBH I never heard anything like "king cans"
 
@this that is "bourgeois propaganda" :)
0.33 and 0.5l respectively
though I don't understand why anyone would want 0.33l of beer...
from a can on top of that
 
well, Murcia's the one who gave ol'George a rude shove. Canada, OTOH was all "let's be friends and write letters", sooooo.....
 
7:06 PM
nice seeing @RubberDuck :)
 
> the amount of beer in a regulation mug, in modern times exactly 1 litre (33.8 US fl oz)
 
@Vogel612 I couldn't drink one litre to save my life...
 
The Maß (pronounced [ˈmaːs]) or Mass (Swiss spelling, elsewhere used for dialectal [ˈmas]) is the German word describing the amount of beer in a regulation mug, in modern times exactly 1 litre (33.8 US fl oz). Maß is often used as an abbreviation for the handled drinking vessel containing it, a Maßkrug. Ubiquitous in Bavarian beer gardens and beer halls and a staple of Oktoberfest it is often acceptably referred to as a beer mug by English speakers but may only be a beer stein if made of stoneware and capable of holding a regulation Maß of beer. == Linguistics == The word "Maß" can be of either...
 
Or liter, depending on localization :D
 
in modern times ....gosh English-speakers love ambiguities
wait no that's Germany?
 
7:07 PM
so i take 2-3 standard swigs of some standard american beer
and i feel it
getting to a litre... id die
 
@KySoto "standard swigs"...
 
and i bet my scottish irish english and german ancestors are rolling in their graves over that too
 
Well a Maß is something for Wasen / Oktoberfest.
 
@KySoto standard american beer is glorified water...
 
In a restaurant you'd probably order a "Halbe" instead
 
7:09 PM
@MathieuGuindon ULTRA LIGHTWEIGHT
 
@KySoto yes, yes they are!!
 
no i mean me
i used to be able to hold my alcohol
 
And if you order a "Viertele" in southern Germany, you'll always get Wine, because nobody drinks that little beer
 
but now... its been like 9 years since i drank a lot
 
7:10 PM
I need caffeine... bbl
 
you make me sad @MathieuGuindon i want some...
 
though TBH, I'm sticking with Whisky or Gin Tonic recently
 
OH, my random windows lock screen this morning had a really awesome picture
i was able to google it down
oh jeez wikipedia(fixed)
 
@Vogel612 Scottish?
 
depends.
I actually did receive one from Germany for my birthday and I'm a huge fan of Gin from the black forest...
 
7:27 PM
PPCG just got a cool theme.
 
oh wow that does look very nice
 
7:52 PM
IT'S SHOWTIME TALK TO THE HAND
'bout time they get a theme lol
 
@MathieuGuindon ArnoldC, LOL.
That's what everyone immediately sees on it. It's Hello World in a zillion different languages.
 
8:16 PM
the logo is really nice
bwahaha they did it again
 
They aren't done updating everything.
A bunch of chat icons are missing. Catija said their designer hasn't gotten them back yet.
 
I mean the white one-boxing in chat
esp. funny with UX.SE
 
Hello everyone
 
Oh :D
 
8:19 PM
^ it's saying "you're the only one that can see me?"
 
Quick question. I have a sumproduct that one of the arrays returns an error (Like =Sumproduct(Weekday(A1:A4,2)=2) returns {#Value,2,2,2} that returns #Value. Is there any way to avoid this #Value error without the iferror+array formula?
 
It is kind of fitting that the current top question is about an excess of whitespace.
 
@Moacir short of ensuring A1:A4 doesn't contain worksheet errors, not that I know of.
 
@MathieuGuindon The point would be not manipulating the original report and do it formula only for LibreOffice compatibility, but I guess it cant be helped then
Thanks!
 
was going to suggest looking into dynamic arrays, but no way that's in LibreOffice lol
(assuming O365)
 
8:25 PM
More fuel for my "Excel Everywhere!" program
 
^ yes ^
 
People just do not realize that saving money is not worth it if it is not saving time
 
old:
=IF($D9<COLUMNS($F$7:F$7),””,INDEX(TableDiv[[App]:[App]],AGGREGATE(15,3,(TableDiv[[Division]:[Division]]=$E9)/(TableDiv[[Division]:[Division]]=$E9)*(ROW(TableDiv[Division])-ROW(TableDiv[[#Headers],[Division]])),COLUMNS($F$7:F$7))))
new:
=SORT(UNIQUE(Table1[Division])
 
That's nice.
 
#gamechanger
 
8:29 PM
This ^
 
Even the location graph already changed some things here
 
Are the dynamic arrays already there in semi-annualy or will they come in in July?
 
not sure at this point, my O365 subscription expired... I think it's GA now
they're not in 2019 though
 
Just asking because we are on semi-annualy at work.
 
does =unique look like it does something?
 
8:33 PM
I'll check tomorrow.
I am at home right now.
 
checks time of course :)
 
^ You have too much fun at work Mug.
 
My work currently really is just managing IT consultants.
 
@IvenBach hm, yeah. got the shopify stuff into my SQL db from the REST API, now to write the journal entries in Sage for each new transaction... #fun
 
and telling them how their testing framework works.
 
8:36 PM
lol
 
Knowing thet there is FakeTable in tSQLt really helps.
 
 
1 hour later…
9:48 PM
:grumble grumble grumble: I wish worksheets could have unit testing.
 
hmm generates no love from me
 
@IvenBach Write a test in VBA putting the data in, extracting the results and asserting on them.
 
10:03 PM
I'm trying to figure out what is going on before I can do that.
 
Ah, ok. So you do not really know the requirenments the worksheet is tries to satisfy.
 
at least access is easy in that regard
its all about forms and stuff
 
@M.Doerner Something like that. TLDR = Ermagawd this is :barf:
Figuring it out as I go.
 
wondering if mocking would have been enough.
 
 
1 hour later…
11:47 PM
Better. Broken out into simpler steps. Quite a bit easier to understand.
 
00:00 - 17:0018:00 - 00:00

« first day (1831 days earlier)      last day (1349 days later) »