| --- Log opened Thu Sep 30 00:00:51 2021 |
| 00:09 | | Emmy [Emmy@Nightstar-l49opt.fixed.kpn.net] has joined #code |
| 00:16 | | * McMartin must admit he mostly ghosts recruiters in part because his LinkedIn account is a burner. |
| 00:16 | <&McMartin> | But you have reminded me to go clear out the last six months of cold calls |
| 00:16 | | Kindamoody is now known as Kindamoody[zZz] |
| 00:20 | <&Reiver> | why do you have a linkedin account to then be a burner |
| 00:22 | | ToxicFrog [ToxicFrog@ServerAdministrator.Nightstar.Net] has quit [[NS] Quit: WeeChat 3.1] |
| 00:22 | | ToxicFrog [ToxicFrog@ServerAdministrator.Nightstar.Net] has joined #code |
| 00:22 | | mode/#code [+ao ToxicFrog ToxicFrog] by ChanServ |
| 00:22 | <&McMartin> | It wasn't originally a cesspool, but they never implemented email verification, so I had to use an alternate email address after some idiot in Brazil used my normal one |
| 00:23 | <&McMartin> | This turns out to have been a blessing, and the alt account I used at the time *became* a burner as LinkedIn turned to shit |
| 00:23 | <&Reiver> | oh |
| 00:23 | <&Reiver> | how is it shit again |
| 00:24 | <&McMartin> | Spammy on its own, ends up enabling a large amount of cattle-call low-quality recruiting spiels from dodgy groups |
| 00:25 | <@celticminstrel> | …that screenshot. |
| 00:25 | <&McMartin> | The way it used to *not* be shit was that it was a way to keep tabs on the coworkers you liked in an environment where the only way anyone ever got promotions or raises was by jumping companies, which meant that you generally only directly worked with them for a couple years. |
| 00:25 | <@celticminstrel> | WTH is that |
| 00:25 | <&[R]> | "some idiot in Brazil used my normal one" <-- yeah, I've got the same issue with my gmail, some guy thinks he's got my email address and signs up for spanish shit |
| 00:26 | <&[R]> | celticminstrel: gotta prevent password reuse |
| 00:26 | <@celticminstrel> | By exposing other people’s passwords. Cool. |
| 00:27 | <&[R]> | How else would you do it? |
| 00:29 | <@Tamber> | By, uh, not doing that |
| 00:29 | | * [R] wasn't being serious |
| 00:52 | <@celticminstrel> | Eh, Wiktionary is missing one sense of “already” but I don’t know how to describe it, what do I do… |
| 00:54 | <@celticminstrel> | Seems like an edit war… |
| 01:05 | <@celticminstrel> | Removed in 2019 (according to an edit message), restored in February, then immediately reverted. |
| 01:07 | <@celticminstrel> | Ohh, it split out into a whole new section. Well, that’s not confusing at all! |
| 01:30 | | catalyst [catalyst@Nightstar-ejd4sd.cable.virginm.net] has quit [Connection closed] |
| 01:35 | | * ToxicFrog bonks her head gently against the keyboard |
| 01:35 | <&ToxicFrog> | Half an hour of debugging that boils down to: '(foo) and (list foo) are not synonyms |
| 01:38 | <@celticminstrel> | Huh? |
| 01:38 | <@celticminstrel> | What language is this? |
| 01:41 | <&McMartin> | Clojure, I'd guess |
| 01:41 | <&McMartin> | But in Scheme, that is also true: '(foo) is equivalent to (list 'foo). |
| 01:41 | <&McMartin> | (list foo) is equivalent to `(,foo) instead, since foo is evaluated |
| 01:42 | <&Reiver> | aaaand none of those symbols mean nothin |
| 01:42 | <@celticminstrel> | I don’t get it either. My sole exposure to Lisp-likes is basically UCB Logo after all… |
| 01:42 | <@celticminstrel> | I mean, I read a bit about Common Lisp but I don’t remember any of it. |
| 01:43 | <&McMartin> | It's the difference between a function call or a SQL query with, say, SELECT * FROM stuff WHERE name = customer |
| 01:43 | <&McMartin> | and SELECT * FROM stuff WHERE name = "customer" |
| 01:43 | <&McMartin> | One is part of a larger piece of logic, where the customer is some variable or parameter. |
| 01:43 | <&McMartin> | The other is searching for a customer literally named "customer" and not finding shit |
| 01:44 | <@celticminstrel> | I assume by “customer” you mean ‘customer’, because in standard SQL the two statements you posted are in fact synonymous. |
| 01:44 | <@celticminstrel> | Oh, and my client is auto-smart-quoting, yay. |
| 01:44 | <&McMartin> | It may be the first that is incorrect; my SQL is rather weak. |
| 01:44 | <&McMartin> | This is a matter of quoting something that was supposed to be evaluated as a variable name, though, yes. |
| 01:44 | <@celticminstrel> | I can turn it off but it never seems to stick. |
| 01:44 | <&ToxicFrog> | Specifically, '(foo) is "a list containing the literal symbol 'foo'" and (list foo) is "a list containing whatever the variable 'foo' holds" |
| 01:45 | <@celticminstrel> | Yeah, in standard SQL, "customer" is the same as unquoted customer. |
| 01:45 | <@celticminstrel> | While 'customer' is a string. |
| 01:45 | <@celticminstrel> | But in MySQL IIRC you use `customer` instead of "customer" and it treats "customer" as synonymous to 'customer' |
| 01:46 | <@celticminstrel> | Oh, but in your first example, customer would have to be another column… |
| 01:46 | <&McMartin> | OK, maybe SQL is not the best source language to be using here for the syntax |
| 01:46 | <@celticminstrel> | Tho it could be a column in a different table if you're doing a join. |
| 01:46 | <@celticminstrel> | Okay fine. |
| 01:46 | <&McMartin> | I *think* this would have to be in the context of a stored procedure or something to make sense |
| 01:47 | <&McMartin> | In JS it's the difference between x = { foo } and x = { "foo" } |
| 01:47 | <@celticminstrel> | So '(foo) is the former and (list foo) is the latter? Or the other way around? |
| 01:49 | <&ToxicFrog> | Other way around. |
| 03:53 | | catalyst [catalyst@Nightstar-ejd4sd.cable.virginm.net] has joined #code |
| 04:14 | <@celticminstrel> | Ugh, my iPhone insisted on telling me a mail server certificate is expired every 10 seconds or so and there was nothing I could do to make it stop. Who thought it was a good idea to not add a "yeah I know just stop trying" option!? (I finally managed to get it to stop by rebooting the phone after deactivating the account but still.) |
| 04:15 | | Degi [Degi@Nightstar-rlfp0u.pool.telefonica.de] has quit [Operation timed out] |
| 04:23 | | Degi [Degi@Nightstar-m0822a.dyn.telefonica.de] has joined #code |
| 05:54 | | VirusJTG [VirusJTG@Nightstar-b00.oti.104.208.IP] has quit [Connection closed] |
| 05:54 | | VirusJTG [VirusJTG@Nightstar-b00.oti.104.208.IP] has joined #code |
| 05:54 | | mode/#code [+ao VirusJTG VirusJTG] by ChanServ |
| 05:55 | <@celticminstrel> | Is there really no Quick Look plugin for GIMP now…? |
| 06:53 | | Kindamoody[zZz] is now known as Kindamoody |
| 07:29 | <@gnolam> | Quick Look? |
| 08:22 | | Emmy is now known as Emmy-work |
| 08:52 | | macdjord is now known as macdjord|slep |
| 10:59 | | Kindamoody is now known as Kindamoody|out |
| 14:06 | <@celticminstrel> | The Mac's file preview feature. |
| 14:06 | <@celticminstrel> | Possibly also responsible for rendering file thumbnails, not sure. |
| 14:18 | | catalyst_ [catalyst@Nightstar-ejd4sd.cable.virginm.net] has joined #code |
| 14:18 | | catalyst [catalyst@Nightstar-ejd4sd.cable.virginm.net] has quit [Connection closed] |
| 14:31 | | abudhabi__ [abudhabi@Nightstar-pnp95l.adsl.tpnet.pl] has joined #code |
| 14:34 | | abudhabi_ [abudhabi@Nightstar-j0ji7d.adsl.tpnet.pl] has quit [Ping timeout: 121 seconds] |
| 14:34 | | abudhabi [abudhabi@Nightstar-j0ji7d.adsl.tpnet.pl] has quit [Ping timeout: 121 seconds] |
| 14:35 | | abudhabi [abudhabi@Nightstar-pnp95l.adsl.tpnet.pl] has joined #code |
| 16:34 | | catalyst [catalyst@Nightstar-ejd4sd.cable.virginm.net] has joined #code |
| 16:34 | | catalyst_ [catalyst@Nightstar-ejd4sd.cable.virginm.net] has quit [Connection closed] |
| 16:35 | | abudhabi__ [abudhabi@Nightstar-pnp95l.adsl.tpnet.pl] has quit [Ping timeout: 121 seconds] |
| 17:50 | | abudhabi__ [abudhabi@Nightstar-pnp95l.adsl.tpnet.pl] has joined #code |
| 17:52 | | Emmy-work is now known as Emmy |
| 18:33 | | gnolam [lenin@Nightstar-j9ajs0.priv.bahnhof.se] has quit [Connection closed] |
| 18:33 | | gnolam [lenin@Nightstar-j9ajs0.priv.bahnhof.se] has joined #code |
| 18:33 | | mode/#code [+o gnolam] by ChanServ |
| 18:34 | | abudhabi__ [abudhabi@Nightstar-pnp95l.adsl.tpnet.pl] has quit [Ping timeout: 121 seconds] |
| 18:47 | | catalyst_ [catalyst@Nightstar-gqk5at.dab.02.net] has joined #code |
| 18:49 | | catalyst [catalyst@Nightstar-ejd4sd.cable.virginm.net] has quit [Ping timeout: 121 seconds] |
| 18:58 | | Kindamoody|out is now known as Kindamoody |
| 18:59 | | catalyst [catalyst@Nightstar-058ijn.cable.virginm.net] has joined #code |
| 19:01 | | catalyst_ [catalyst@Nightstar-gqk5at.dab.02.net] has quit [Ping timeout: 121 seconds] |
| 19:03 | | abudhabi [abudhabi@Nightstar-pnp95l.adsl.tpnet.pl] has quit [Ping timeout: 121 seconds] |
| 19:04 | | abudhabi [abudhabi@Nightstar-pnp95l.adsl.tpnet.pl] has joined #code |
| 19:16 | | macdjord|slep is now known as macdjord |
| 19:28 | | ErikMesoy [Bruker@Nightstar-9hbv99.bb.online.no] has quit [Connection closed] |
| 19:29 | | ErikMesoy [Bruker@Nightstar-9hbv99.bb.online.no] has joined #code |
| 21:04 | | tripflag [ed@Nightstar-7pe1df.clients.your-server.de] has quit [Ping timeout: 121 seconds] |
| 21:10 | | tripflag [ed@Nightstar-7pe1df.clients.your-server.de] has joined #code |
| 21:38 | | * Reiver does battle with Excel, but in truth, it is with his own soul |
| 21:42 | <~Vornicus> | we have several excel knowfulmen here |
| 21:42 | <~Vornicus> | waht're you up to |
| 21:43 | | * TheWatcher presents Reiv with the VLOOKUP() Of Enlightenment |
| 21:43 | <~Vornicus> | vlookup's actually old & busted now, xlookup is so much better |
| 21:44 | <&Reiver> | wait is that a true statement? |
| 21:44 | <&Reiver> | I was planning to fuck about with INDEX and MATCH today but this is useful info if so |
| 21:44 | <~Vornicus> | that is a true statement. |
| 21:44 | <&Reiver> | what change |
| 21:48 | <@TheWatcher> | Yeah, it is. xlookup's more flexible, faster, replaces vlookup and hlookup, and handles unsorted data better and sorted data faster |
| 21:49 | <~Vornicus> | anyway what're you up to, we're probably able to help |
| 21:52 | <&Reiver> | I am now suddenly curious if xlookup would do it, but |
| 21:52 | <&Reiver> | So, part of this is Wrestling With My Soul to be clear, I suspect the solution is to denormalise this shit for human use |
| 21:52 | <&Reiver> | But I am making, effectively, a pretty calendar in Excel. Yes, we have outlook, we have teams calendars, we have salesforce calendars, but I'm doing it in Excel because I was told to by my boss's boss and that's the end of it |
| 21:53 | <&Reiver> | This calendar will be a grid of dates vertically, environments horizontally. |
| 21:55 | <&Reiver> | I intend to populate it from another sheet that lists, for the moment, shit like |
| 21:57 | <&Reiver> | [Environment,Project,Startdate,Enddate] |
| 21:57 | <&Reiver> | PRODUCTION,BAU,startdate,enddate |
| 21:57 | <&Reiver> | TEST,ACCOUNTS,startdate,enddate |
| 21:57 | <&Reiver> | TEST,PLANNING,startdate,enddate |
| 21:57 | <&Reiver> | TAHI,MOBILE,startdate,enddate |
| 21:57 | <&Reiver> | TAHI,REFRESH,startdate,enddate [they match because this is a single row] |
| 21:57 | <&Reiver> | TAHI,CONTRACTS,startdate,enddate |
| 21:57 | <&Reiver> | etc |
| 21:58 | <&Reiver> | commas are columns ofc but you get the idea |
| 21:58 | <&Reiver> | What I /need/ |
| 21:58 | <~Vornicus> | where production is a location and bau is the name of an event |
| 21:58 | <&Reiver> | Correct |
| 21:59 | <&Reiver> | Is for the column in the 'calendar view' named foo, on the row dated bar, to hunt through this big ol' list and return me where the dates and environments match |
| 22:00 | <&Reiver> | I keep swinging between "This is just a set of if statemetns" and "I should be using a match" and "But wait how do I match on two columns in the tasklist" and |
| 22:00 | <~Vornicus> | question: is it ever the case that two different events happen in the same place at the same time |
| 22:01 | <&Reiver> | Yes! I intend for the calendar to explode horribly in these circumstances. |
| 22:01 | <&Reiver> | ... although shit, yeah actually you can have REFRESH happen mid-project so I guess I need to be careful of that one after all |
| 22:02 | <&Reiver> | well that's an annoyance I had not thought of |
| 22:02 | <&Reiver> | I can't just have the thing throw errors to warn everyone our project resources are overutilized :V |
| 22:03 | <~Vornicus> | okay, hm. |
| 22:04 | <~Vornicus> | office 365? |
| 22:05 | | catalyst_ [catalyst@Nightstar-gqk5at.dab.02.net] has joined #code |
| 22:08 | | catalyst [catalyst@Nightstar-058ijn.cable.virginm.net] has quit [Ping timeout: 121 seconds] |
| 22:13 | | catalyst [catalyst@Nightstar-ejd4sd.cable.virginm.net] has joined #code |
| 22:15 | <&Reiver> | yes |
| 22:15 | <~Vornicus> | https://imgur.com/D25pXQ3 we have a winner |
| 22:15 | <&Reiver> | :o |
| 22:15 | <&Reiver> | what in the |
| 22:16 | <&Reiver> | oh my goodness |
| 22:16 | <&Reiver> | how |
| 22:16 | <&Reiver> | I |
| 22:17 | <~Vornicus> | one formula, no data massage, all sexiness. It is like Microsoft uploaded my brain to the internet. |
| 22:17 | | catalyst_ [catalyst@Nightstar-gqk5at.dab.02.net] has quit [Connection closed] |
| 22:18 | | * Reiver stares in awe. Ponders. |
| 22:18 | <&Reiver> | Is this |
| 22:18 | <&Reiver> | hm |
| 22:18 | <&Reiver> | Is this something where we could, like |
| 22:19 | <&Reiver> | Plug this into Conditional Formatting somehow |
| 22:19 | <&Reiver> | To be clear That Will Work Just Fine but I am now pondering prettification |
| 22:19 | <&Reiver> | no actually that's just 'contains REFRESH' isn't it hm |
| 22:22 | <&Reiver> | My pretty ~ideal~ would be to return the title of the task in the first row of the block, an extra column's data in the second row (if one is there - this would be a point of contact name), color in the rest of the block to represent that it's all busy, and then color in the next block a different color |
| 22:22 | <&Reiver> | But overlaps mess that up don't they, so I'm not sure your solution there is not in fact better |
| 22:22 | | catalyst [catalyst@Nightstar-ejd4sd.cable.virginm.net] has quit [Connection reset by peer] |
| 22:25 | | catalyst [catalyst@Nightstar-ejd4sd.cable.virginm.net] has joined #code |
| 22:25 | <~Vornicus> | they do. WIth some trickery you can color blocks according to contents (though it won't work with multiple items) and then invisible the text for cells where the one above is identical. |
| 22:29 | <&Reiver> | ... oooh you know that could work |
| 22:29 | <&Reiver> | hm |
| 22:29 | <&Reiver> | Especially if I used a color range, like, one of those green-to-red dealies |
| 22:29 | <&Reiver> | Then overlaps get an interviening color and at least called out as HEY SO PAY ATTENTION |
| 22:30 | <&Reiver> | And whatever we do I want REFRESH to get a special call out of HEY PAY ATTENTION WE ARE NUKING THE FUCKING THING TO BEDROCK |
| 22:30 | <&Reiver> | SERIOUSLY WE'VE LOST ENTIRE CONFIGS BECAUSE YOU LOT DO NOT LISTEN TO ME WHEN I SAY THIS |
| 22:33 | <&Reiver> | "Whenever we 'refresh the data', it resets the entire environment back to the source system - usually Production - data, config, customisations, everything. It's literally copying the whole of Production over. "Okay, got it. We don't need anything in there any more, it's fine." |
| 22:33 | <&Reiver> | *two days later* "...Hey, the refresh wiped the config that the consultant just spent three weeks on?" "oh fuck me I thought you said we didn't need anything in there any more" "oh no we don't care about the data we were going to use up to date stuff to test the config" |
| 22:33 | | * Reiver twitch |
| 22:33 | | * Reiver figures REFRESH gets a special color all to itself. :p |
| 22:34 | <~Vornicus> | use a bunch of pale colors, then refresh is white text on dark red |
| 22:36 | <~Vornicus> | it also stops other rules from running, etc, etc. I assume you have some idea what you're doing with conditional formatting |
| 22:37 | <&Reiver> | The basics yeah |
| 22:37 | <&Reiver> | The if matches above is... oh wait that's an if duhhhh |
| 22:39 | <~Vornicus> | this'll be a thing you can do in conditional formatting, it's a little tricky to set up though |
| 23:04 | | Kindamoody is now known as Kindamoody[zZz] |
| 23:28 | | Emmy [Emmy@Nightstar-l49opt.fixed.kpn.net] has quit [Ping timeout: 121 seconds] |
| --- Log closed Fri Oct 01 00:00:52 2021 |