| --- Log opened Thu Aug 09 00:00:10 2018 |
| 00:21 | | Emmy [Emmy@Nightstar-9p7hb1.direct-adsl.nl] has quit [Ping timeout: 121 seconds] |
| 00:48 | | celticminstrel [celticminst@Nightstar-v1qb0r.dsl.bell.ca] has joined #code |
| 00:48 | | mode/#code [+o celticminstrel] by ChanServ |
| 03:10 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has joined #code |
| 03:10 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
| 03:59 | | Kindamoody is now known as Kindamoody[zZz] |
| 04:36 | | celticminstrel [celticminst@Nightstar-v1qb0r.dsl.bell.ca] has quit [[NS] Quit: And lo! The computer falls into a deep sleep, to awake again some other day!] |
| 06:40 | | Netsplit Deepthought.Nightstar.Net <-> Krikkit.Nightstar.Net quits: @PinkFreud, @Syloq |
| 06:50 | | Netsplit over, joins: Syloq |
| 07:05 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has quit [Ping timeout: 121 seconds] |
| 07:18 | | Vornicus [Vorn@Nightstar-sjaki9.res.rr.com] has joined #code |
| 07:19 | | Vorntastic [uid293981@Nightstar-6br85t.irccloud.com] has joined #code |
| 07:21 | <&McMartin> | https://static.consolia-comic.com/comics/mirror.png |
| 07:23 | | Vornicus [Vorn@Nightstar-sjaki9.res.rr.com] has quit [Ping timeout: 121 seconds] |
| 07:57 | | PinkFreud [WhyNot@NetworkAdministrator.Nightstar.Net] has joined #code |
| 07:57 | | ServerMode/#code [+o PinkFreud] by *.Nightstar.Net |
| 07:57 | | mode/#code [+o Syloq] by ChanServ |
| 08:29 | | Degi [Degi@Nightstar-bbe.2r2.232.185.IP] has joined #code |
| 08:36 | | mode/#code [+qo Vorntastic Vorntastic] by ChanServ |
| 08:41 | | Degi [Degi@Nightstar-bbe.2r2.232.185.IP] has quit [Ping timeout: 121 seconds] |
| 09:14 | | Kindamoody[zZz] is now known as Kindamoody |
| 10:25 | | macdjord [macdjord@Nightstar-grpbnp.mc.videotron.ca] has quit [Connection closed] |
| 10:26 | | macdjord [macdjord@Nightstar-grpbnp.mc.videotron.ca] has joined #code |
| 10:26 | | mode/#code [+o macdjord] by ChanServ |
| 11:15 | <~Vorntastic> | I like being able to use Excel. =if(isblank(4437puzzle!N14)," ",if(vlookup(4437puzzle!N14,1E63lookup!$A$1:$B$26,55CC2,55CCtrue)="",4437puzzle!N14,vlookup(4437puzzle!N14,1E63lookup!$A$1:$B$26,55CC2,55CCtrue))) |
| 11:16 | <~Vorntastic> | Did that come out all super funny colored on your end |
| 11:16 | <@Tamber> | lots of 'censored' with blue on blue. |
| 11:17 | <@Tamber> | http://furryhelix.co.uk/~tamber/pics/tmp/wut.png |
| 11:17 | <~Vorntastic> | Wild |
| 11:18 | <~Vorntastic> | 03:15 <• Vorntastic> I like being able to use Excel. =if(isblank(puzzle!N14)," ",if(vlookup(puzzle!N14,lookup!$A$1:$B$26,2,true)="",puzzle!N14,vlookup(puzzle!N14,lookup!$A$1:$B$26,2,true))) |
| 11:18 | <@Tamber> | Well, that's... something! |
| 11:19 | <@Tamber> | (Every time I've gotten to a problem that I'm supposed to be able to solve with vlookup, I end up just sitting there scratching my head.) |
| 11:24 | <~Vorntastic> | (I have a "code crossword" puzzle, a grid of spaces set up like a crossword, each numbered; you associate a letter with each number and fill the grid with words that way.) |
| 11:30 | <~Vorntastic> | This thing will grab the cell from puzzle, check if it's blank (and is thus a black cell), and whether I've picked a letter for it, so I can see the puzzle getting filled out as I pick letters |
| 11:38 | <~Vorntastic> | I'm surprised by that because vlookup is... Straight up database shit |
| 11:39 | <@Tamber> | Dunno if it's just that I've not found a description of how it works/how to use it that really clicks; or if it's that I'm picking the worst times of day (when my brain is in shutdown mode :p) to try work it out. |
| 11:41 | | Emmy [Emmy@Nightstar-9p7hb1.direct-adsl.nl] has joined #code |
| 11:42 | <~Vorntastic> | Heh |
| 11:49 | | crystalclaw [crystalclaw@Nightstar-12q9ui.xyz] has quit [Ping timeout: 121 seconds] |
| 11:49 | | crystalclaw [crystalclaw@Nightstar-12q9ui.xyz] has joined #code |
| 11:49 | | mode/#code [+o crystalclaw] by ChanServ |
| 12:56 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has joined #code |
| 12:56 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
| 13:12 | <@gnolam> | Vorn: oh hey, you're an Excel wiz. |
| 13:12 | <@gnolam> | Right? |
| 13:16 | <@gnolam> | I have a table of values: |
| 13:16 | <@gnolam> | ID | value1 | value2 |
| 13:16 | <@gnolam> | The table is sorted by value1. |
| 13:17 | <~Vorntastic> | Okay |
| 13:17 | <@gnolam> | I'd like to have a chart displaying the top, let's say, 10 entries, and then the rest summarized as "Other". |
| 13:17 | <@gnolam> | For value1 this is simple. Just take the first 10 rows and then =SUM() the rest of column B. |
| 13:17 | <@gnolam> | For value2... not so much. |
| 13:17 | <~Vorntastic> | Mmm. You do have rank as a function |
| 13:17 | <@gnolam> | Is there a way to do it, or will I have to create a duplicate table? |
| 13:18 | <~Vorntastic> | And... Uh... Inverse rank though I don't remember its name off the top |
| 13:20 | <~Vorntastic> | So you should be able to get the top ten via that and subtract it from the full sum to get the other result |
| 13:21 | <@gnolam> | Thanks! I'll look into it. |
| 13:22 | <~Vorntastic> | LARGE |
| 13:22 | | celticminstrel [celticminst@Nightstar-v1qb0r.dsl.bell.ca] has joined #code |
| 13:22 | | mode/#code [+o celticminstrel] by ChanServ |
| 13:23 | <@gnolam> | A-ha! |
| 13:23 | <@gnolam> | That does sound like *exactly* what I need. |
| 14:29 | | celticminstrel [celticminst@Nightstar-v1qb0r.dsl.bell.ca] has quit [[NS] Quit: And lo! The computer falls into a deep sleep, to awake again some other day!] |
| 15:01 | | himi [sjjf@Nightstar-v37cpe.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 16:09 | | Vorntastic [uid293981@Nightstar-6br85t.irccloud.com] has quit [[NS] Quit: Connection closed for inactivity] |
| 16:56 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has quit [Ping timeout: 121 seconds] |
| 17:36 | | Degi [Degi@Nightstar-99948g.static.upcbusiness.at] has joined #code |
| 17:38 | | Degi_ [Degi@Nightstar-qk5.2r2.232.185.IP] has joined #code |
| 17:40 | | Degi [Degi@Nightstar-99948g.static.upcbusiness.at] has quit [Ping timeout: 121 seconds] |
| 17:41 | | Degi_ is now known as Degi |
| 18:16 | <@ErikMesoy> | https://twitter.com/allymcleangames/status/1027445459353096192 Introducing yourself. |
| 18:17 | <&McMartin> | Genuinely good advice |
| 18:18 | <&McMartin> | secondary fact: scriptwriters don't have a lot of audience time to waste |
| 18:42 | | Degi [Degi@Nightstar-qk5.2r2.232.185.IP] has quit [Connection closed] |
| 21:42 | | Degi [Degi@Nightstar-99948g.static.upcbusiness.at] has joined #code |
| 21:43 | | Degi_ [Degi@Nightstar-ub5.2r2.232.185.IP] has joined #code |
| 21:46 | | Degi [Degi@Nightstar-99948g.static.upcbusiness.at] has quit [Ping timeout: 121 seconds] |
| 21:46 | <@Alek> | Erik: so brilliant. |
| 21:46 | | Degi_ is now known as Degi |
| 22:42 | | Degi [Degi@Nightstar-ub5.2r2.232.185.IP] has quit [Ping timeout: 121 seconds] |
| 23:38 | | himi [sjjf@Nightstar-v37cpe.internode.on.net] has joined #code |
| 23:39 | | mode/#code [+o himi] by ChanServ |
| 23:54 | | Emmy [Emmy@Nightstar-9p7hb1.direct-adsl.nl] has quit [Ping timeout: 121 seconds] |
| --- Log closed Fri Aug 10 00:00:11 2018 |