--- Log opened Thu Apr 18 00:00:22 2013 |
00:43 | | ToxicFrog|W`rkn is now known as ToxicFrog |
00:47 | | Derakon[AFK] is now known as Derakon |
01:23 | | Azash [ap@297948.F70DAA.120876.F7563D] has quit [Ping timeout: 121 seconds] |
01:39 | | Azash [ap@297948.F70DAA.120876.F7563D] has joined #code |
01:39 | | mode/#code [+o Azash] by ChanServ |
01:43 | <@Reiv> | VORNICUS VORNICUS VORNICUS |
01:43 | <@Reiv> | I SUMMON THEE OH ELDER ONE |
01:43 | <@Reiv> | GIVE UNTO ME YOUR TERRIBLE KNOWLEDGE |
01:43 | <@Reiv> | GRANT ME... EXCEL! |
01:43 | <~Vornicus> | WHO DARE DISTURB MY SLUMBER |
01:43 | <~Vornicus> | oh it's just you |
01:43 | <~Vornicus> | what |
01:43 | | * Reiv giggles. |
01:44 | <@Reiv> | So, I have a spreadsheet. |
01:44 | <&McMartin> | Why is Excel Saga not about spreadsheets |
01:44 | <@Reiv> | I have a particular operation on this spreadsheet. |
01:44 | <@Reiv> | That I need. |
01:44 | <~Vornicus> | McM: ...yes. |
01:44 | <@Azash> | McMartin: Because 1984 already existed |
01:45 | <~Vornicus> | okay what is the task? |
01:45 | <@Reiv> | Were this SQL, it would be SELECT Department, SUM(DaysAnnualLeave) PARTITION BY (Name) FROM foo GROUP BY Department; |
01:46 | <~Vornicus> | okay I don't know what PARTITION BY does. |
01:46 | <@Reiv> | ... Oh. Whoops. |
01:46 | <@Reiv> | OK. |
01:47 | <@Reiv> | I have a sheet with columns: Department; Employee; Type; Days. |
01:47 | <@Reiv> | I need to sum up the days /per employee/. |
01:48 | <@Reiv> | Then I select how many per Department have More Than X, 'cuz it's a regulatory thing. |
01:48 | <@Reiv> | (Having, eg, three months annual leave can cause issues if said employee then chooses to /take it all at once/, fex~) |
01:53 | <~Vornicus> | Okay, let me see if I get this straight: a department has many employees, each employee gets many types of leave, and each type of leave has some count of days. |
01:55 | <~Vornicus> | YOu need to 1. find out how many, total, days leave each employee gets |
01:55 | <~Vornicus> | and then given that, you need to have... okay this is what I don't get. |
01:56 | <~Vornicus> | You need to know how many employees per department have X amount of leave or more? |
01:56 | <@Reiv> | Correct. |
01:56 | <~Vornicus> | Okay, let's see what I can come up with. |
01:57 | <@Reiv> | The second part is easy enough; if I can get the first I can just run a COUNTIF |
01:57 | <~Vornicus> | I'm pretty sure what you want is a... hm. Probably a pivottable |
01:57 | <@Reiv> | There's like five departments so I don't care much |
01:57 | <@Reiv> | OK yeah I used pivot tables |
01:57 | <@Reiv> | But I couldn't get them to add by employee |
01:58 | <@Reiv> | I may have done something wrong. |
01:58 | <~Vornicus> | probably, let me remember the process here. You wouldn't happen to have outsider-usable sample data would you? |
01:58 | <@Reiv> | Mmmmmmno. |
01:58 | <@Reiv> | I could forge one, though |
02:08 | <~Vornicus> | anyway, I think you get: pivottable, department/employee on the side, nothing (I htink this is how it goes) on the top, sum(days) on the center |
02:09 | | RichyB [richardb@Nightstar-228a334c.plus.com] has quit [[NS] Quit: >:3 This is BunThulhu. Copy him into your quit message to help him take over the Internet.] |
02:11 | <@Reiv> | aha |
02:14 | <@Reiv> | augh merged cells >_< |
02:14 | <@Reiv> | Can you... un-merge cells? |
02:14 | | celticminstrel [celticminst@Nightstar-e83b3651.cable.rogers.com] has quit [[NS] Quit: KABOOM! It seems that I have exploded. Please wait while I reinstall the universe.] |
02:14 | | celticminstrel [celticminst@Nightstar-e83b3651.cable.rogers.com] has joined #code |
02:14 | | mode/#code [+o celticminstrel] by ChanServ |
02:15 | <&ToxicFrog> | ^Z?? |
02:15 | <~Vornicus> | I haven't really figured that bit out, unfortunately. |
02:16 | <~Vornicus> | TF: Will unmerge cells that you just merged; you can also unmerge cells by selecting the cell and choosing "split" but neither will do quite what Reiv wants, which I suspect is "use the merged cell as if it were in the unmerged location given by the formula" |
02:18 | <@Reiv> | I'd gladly unmerge the cell |
02:18 | <@Reiv> | Even if I then had to drag down on it or something. |
02:18 | <~Vornicus> | But this, now htat I think on it, is in the pivottable. I'm not sure how to handle that. |
02:19 | <@Reiv> | Ehhh |
02:19 | <@Reiv> | I need to fix the base data |
02:19 | <@Reiv> | The pivot table will then stop getting confused. |
02:19 | <@Reiv> | As it stands I have 103 people belonging to the deparment (blank) |
02:19 | <~Vornicus> | ah that wouldn't help. |
02:19 | <@Reiv> | Because the department column was, y'know, merged. |
02:20 | <@Reiv> | Which looks nice on a table I'm sure! |
02:31 | <~Vornicus> | Anyway alternative: normalize table to employee type days / employee department; pivottable employee and then in the center get sum(days), and then something like IF(days > target, vlookup(employee, employee_departments, 2), "") will set up so you can use FREQUENCY (using the array magic) to count by department. |
02:32 | | * Reiv whimpers. |
02:32 | <~Vornicus> | That one is pretty scary |
02:34 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has quit [Ping timeout: 121 seconds] |
02:36 | | Turaiel is now known as Turaiel[Offline] |
02:40 | <&McMartin> | Somewhat to my surprise, the MSVS2012 interface is noticably cleaner than its predecessors |
02:47 | | himi [fow035@Nightstar-a0fd8f60.in-addr.csiro.au] has joined #code |
02:47 | | mode/#code [+o himi] by ChanServ |
02:50 | | VirusJTG [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has quit [[NS] Quit: Program Shutting down] |
02:59 | <@gnolam> | Also: comes with a standard dark theme. |
03:18 | | Derakon is now known as Derakon[AFK] |
03:27 | | syksleep is now known as Syk |
03:29 | <&McMartin> | gnolam: Wait whut where is this |
03:30 | <&McMartin> | Oop, found it, n/m |
03:30 | <&McMartin> | Oh, that is very nice |
03:30 | <@Reiv> | OK new one |
03:31 | <@Reiv> | COUNTIF(foo, "Between X and Y") |
03:31 | <@Reiv> | How do? |
03:31 | | * Reiv once again summons the great elder VORNICUS |
03:32 | <~Vornicus> | Okay I'd do this by adding a column that calculates AND(X<target, target<Y) |
03:32 | <~Vornicus> | which conveniently gives you TRUE and FALSE |
03:33 | <~Vornicus> | then you get =COUNTIF(my_new_column, TRUE) |
03:34 | <@Reiv> | hum. |
03:34 | <@Reiv> | You do need the two columns too, don't you |
03:34 | <@Reiv> | Ttttttthough |
03:35 | <@Reiv> | No, wait, you do. Bleh. OK. |
03:38 | | * Vornicus hunts around for the stuff about criteria in countif |
03:38 | <~Vornicus> | There's all sorts of crazy stuff in there but I don't remember it all. |
03:41 | <@Reiv> | Sorted anyway, cheers |
03:41 | <@Reiv> | This is a one-shot (har, theoretically) |
03:41 | <@Reiv> | So I can just fudge it a bit. |
03:45 | | OrthiaLap [orthia@Nightstar-4c3407ae.xtra.co.nz] has joined #code |
03:53 | | * Vornicus pokes at convex hull algorithms. |
03:59 | | cpux|2 [cpux@Nightstar-98762b0f.dyn.optonline.net] has joined #code |
04:01 | <~Vornicus> | okay. let's write me some quickhull. |
04:01 | | cpux [cpux@Nightstar-98762b0f.dyn.optonline.net] has quit [Ping timeout: 121 seconds] |
04:02 | | cpux [cpux@Nightstar-98762b0f.dyn.optonline.net] has joined #code |
04:02 | | mode/#code [+o cpux] by ChanServ |
04:04 | | cpux|3 [cpux@Nightstar-98762b0f.dyn.optonline.net] has joined #code |
04:04 | | cpux|2 [cpux@Nightstar-98762b0f.dyn.optonline.net] has quit [Ping timeout: 121 seconds] |
04:06 | | cpux [cpux@Nightstar-98762b0f.dyn.optonline.net] has quit [Ping timeout: 121 seconds] |
04:10 | | Turaiel[Offline] is now known as Turaiel |
04:11 | | sshine [simon@Nightstar-2aa33f9d.pronoia.dk] has quit [Client closed the connection] |
04:11 | | sshine [simon@Nightstar-2aa33f9d.pronoia.dk] has joined #code |
04:17 | | OrthiaLap [orthia@Nightstar-4c3407ae.xtra.co.nz] has quit [Ping timeout: 121 seconds] |
04:23 | <~Vornicus> | ...step 1: write a thing that gets me a hyperplane from a bunch of points. :( |
04:35 | | Kindamoody[zZz] is now known as Kindamoody |
04:36 | | OrthiaLap [orthia@Nightstar-4c3407ae.xtra.co.nz] has joined #code |
04:49 | <~Vornicus> | ...also of course scipy.org is down. |
05:00 | | jeroud [uid10043@Nightstar-1d9743e5.irccloud.com] has quit [Ping timeout: 121 seconds] |
05:01 | | jeroud_ [uid10043@Nightstar-1d9743e5.irccloud.com] has joined #code |
05:46 | | Derakon[AFK] is now known as Derakon |
06:04 | | ErikMesoy|sleep is now known as ErikMesoy |
06:27 | | jeroud_ is now known as jeroud |
06:30 | | Derakon is now known as Derakon[AFK] |
07:00 | | Turaiel is now known as Turaiel[Offline] |
08:31 | | celticminstrel [celticminst@Nightstar-e83b3651.cable.rogers.com] has quit [[NS] Quit: And lo! The computer falls into a deep sleep, to awake again some other day!] |
08:57 | | himi [fow035@Nightstar-a0fd8f60.in-addr.csiro.au] has quit [Client closed the connection] |
09:09 | | thalass [thalass@Nightstar-f97b970e.bigpond.net.au] has joined #code |
09:10 | | Kindamoody is now known as Kindamoody|out |
09:13 | | himi [fow035@Nightstar-a0fd8f60.in-addr.csiro.au] has joined #code |
09:13 | | mode/#code [+o himi] by ChanServ |
10:29 | | RichyB [richardb@Nightstar-228a334c.plus.com] has joined #code |
10:34 | | OrthiaLap [orthia@Nightstar-4c3407ae.xtra.co.nz] has quit [Ping timeout: 121 seconds] |
10:43 | | thalass [thalass@Nightstar-f97b970e.bigpond.net.au] has quit [[NS] Quit: damn comp-ootars. ] |
11:02 | | OrthiaLap [orthia@Nightstar-4c3407ae.xtra.co.nz] has joined #code |
11:14 | | Vornicus [vorn@ServerAdministrator.Nightstar.Net] has quit [[NS] Quit: Leaving] |
11:50 | | OrthiaLap [orthia@Nightstar-4c3407ae.xtra.co.nz] has quit [Ping timeout: 121 seconds] |
11:56 | | VirusJTG [VirusJTG@Nightstar-09c31e7a.sta.comporium.net] has joined #code |
13:01 | | himi [fow035@Nightstar-a0fd8f60.in-addr.csiro.au] has quit [Client closed the connection] |
13:22 | | himi [fow035@Nightstar-5d05bada.internode.on.net] has joined #code |
13:22 | | mode/#code [+o himi] by ChanServ |
14:04 | | thalass [thalass@Nightstar-f97b970e.bigpond.net.au] has joined #code |
14:44 | | celticminstrel [celticminst@Nightstar-e83b3651.cable.rogers.com] has joined #code |
14:44 | | mode/#code [+o celticminstrel] by ChanServ |
15:04 | < RichyB> | I love this diagram. http://neilk.net/blog/2013/04/17/the-programmers-sefirot/ |
15:07 | <@froztbyte> | :D |
15:48 | | ToxicFrog is now known as ToxicFrog|W`rkn |
16:13 | | Thalass|phone [Thalass@Nightstar-f97b970e.bigpond.net.au] has joined #code |
16:14 | < Thalass|phone> | http://i50.photobucket.com/albums/f324/Thalass/IMG_20130418_231143.jpg This is bad, yes? |
16:14 | < Thalass|phone> | I managed to get the damn laptop to boot into lubuntu, but the hdd won't mount. |
16:15 | < Syk> | do as it says |
16:15 | < Syk> | boot into Windows, chkdsk /f |
16:16 | < Thalass|phone> | It doesn't seem to want to. |
16:16 | < Syk> | Thalass|phone: NTFS-3G refuses to mount a dirty drive |
16:16 | < Syk> | Thalass|phone: check the SMART data? |
16:20 | <&ToxicFrog|W`rkn> | "doesn't seem to want to" how? What happens when you tell it to? |
16:21 | < thalass> | Upon powering up, it presents the option to go into repair, or boot normally. Both of these options end up with the windows 7 load screen coming on for a bit, then a blank screen after that. Once it managed to almost get a desktop up, with a cursor. But nothing else. |
16:22 | < thalass> | I wouldn't care, but unbackup'd photos. Also Mel insists that she will need to buy a new laptop, rather than me throwing a spare/new hdd in it and sticking linux on the machine. >.< |
16:23 | <&ToxicFrog|W`rkn> | There is some option to ntfs-3g - I forget exactly what - that will force it to mount a dirty drive readonly |
16:23 | <@froztbyte> | haha |
16:23 | <@froztbyte> | bootloaders are fun! |
16:23 | <&ToxicFrog|W`rkn> | There's also a tool you can use to mark it dirty so windows will be forced to check it when it boots |
16:23 | <&ToxicFrog|W`rkn> | I forget the exact name |
16:23 | <&ToxicFrog|W`rkn> | But rummage around in lubuntu for ntfs-related stuff |
16:24 | <@froztbyte> | -o force |
16:24 | <@froztbyte> | from the manpage |
16:24 | <&ToxicFrog|W`rkn> | "ntfsfix", that's it |
16:24 | <@froztbyte> | isn't that still from ntfs-tools, not ntfs-3g? |
16:25 | <&ToxicFrog|W`rkn> | So, yeah, try mounting with '-o force,ro' or ntfsfix and then reboot into windows and see if it gets checked; if you're worried about stuff being badly damaged the former is safer. |
16:25 | <&ToxicFrog|W`rkn> | No idea. |
16:25 | < thalass> | ok i'll have a look. thanks. |
16:25 | < Syk> | froztbyte: NTFS-3G and ntfstools are one and the same |
16:25 | < Syk> | froztbyte: they merged in like 2011 i think |
16:27 | <@froztbyte> | ah |
16:27 | <@froztbyte> | thalass: fwiw, you'll get to a point in this process where you'll ask "what the fuck? why is this so horrible? it's 2013, does nothing better exist?!" |
16:28 | <@froztbyte> | thalass: and the answer is "no, it's all a fucking heap of shit and this is what the world runs on" |
16:28 | < thalass> | heh |
16:28 | <@froztbyte> | (also, yes, kinda, there do exist better things. but nearly no-one uses them.) |
16:28 | < thalass> | well this machine wouldn't even boot from USB, which was a bit of a shock. I had to dig up actual /CDs/, and then find a distro that would fit on one. |
16:28 | < Syk> | ubuntu? |
16:29 | < Syk> | or has ubuntu moved to dvds finally |
16:29 | < thalass> | over 800mb, even the 32bit no codecs version. Same with Mint. Lubuntu just squeezed in below 750mb. |
16:29 | < thalass> | I also tried DSL, but clearly i'm too much of a noob for that. |
16:30 | <@froztbyte> | for that case, I often recommend systemrescuecd |
16:30 | <@froztbyte> | it's gentoo based, but comes packing a fairly sane set of defaults |
16:30 | <@froztbyte> | used to be around 160MB, although I saw that the latest images are a bit bigger |
16:31 | < thalass> | Ah i have heard of a system recovery and/or bootable virus scan distro. But clearly i've been awake for 20.5 hours and should sleep. |
16:32 | < thalass> | If i wasn't going out of state on sunday, it wouldn't be an issue. But here we are. |
16:33 | <@froztbyte> | hehe |
16:39 | <&ToxicFrog|W`rkn> | My go-to tiny distro is TinyCore with some extra custom stuff |
16:39 | <&ToxicFrog|W`rkn> | But that's "fits on a 32MB SD card" tiny |
16:40 | <@froztbyte> | my favourite for that used to be DSL (DamnSmallLinux), but until recently they didn't maintain to current kernel standards |
16:40 | <@froztbyte> | (it was on 2.4.28-something for ages, iirc) |
16:40 | <@froztbyte> | the 2.6 branch is ~130MB+ :/ |
16:41 | | * froztbyte shall check out TinyCore |
16:49 | < Thalass|phone> | puppy is good, that was going to be my next move if lubuntu wasn't kind to me |
16:59 | | Xires is now known as ^Xires |
16:59 | < Thalass|phone> | the drive can't be mounted. Not found in /etc/fstab or /etc/mtab. Aaa d it's midnight. time for sleep. |
17:00 | < Thalass|phone> | thanks for your help guys. |
17:02 | <&ToxicFrog|W`rkn> | Puppy's alright. |
17:03 | <&ToxicFrog|W`rkn> | 'night. I'll probably still be around your morning, if it's still broken. |
17:04 | < Thalass|phone> | thanks. :) |
17:10 | | Thalass|phone [Thalass@Nightstar-f97b970e.bigpond.net.au] has quit [[NS] Quit: Bye] |
17:11 | | thalass is now known as Thalass|slep |
17:35 | | d4de [olorin@687AAB.418D22.06F82B.900D20] has quit [Ping timeout: 121 seconds] |
18:38 | | Syk is now known as syksleep |
19:09 | | Kindamoody|out is now known as Kindamoody |
19:23 | | Chutzpah [Moltare@583787.FF2A18.190FE2.4D81A1] has joined #code |
20:12 | | Kindamoody is now known as Kindamoody[zZz] |
20:22 | | Derakon [Derakon@Nightstar-a3b183ae.ca.comcast.net] has joined #code |
20:22 | | mode/#code [+ao Derakon Derakon] by ChanServ |
20:23 | | Derakon[AFK] [Derakon@Nightstar-a3b183ae.ca.comcast.net] has quit [Operation timed out] |
20:35 | | Derakon [Derakon@Nightstar-a3b183ae.ca.comcast.net] has quit [Ping timeout: 121 seconds] |
20:35 | | Derakon [Derakon@Nightstar-a3b183ae.ca.comcast.net] has joined #code |
20:36 | | mode/#code [+ao Derakon Derakon] by ChanServ |
20:42 | | Vornicus [vorn@ServerAdministrator.Nightstar.Net] has joined #code |
20:42 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
21:13 | | Derakon [Derakon@Nightstar-a3b183ae.ca.comcast.net] has quit [Ping timeout: 121 seconds] |
21:14 | | Derakon [Derakon@Nightstar-a3b183ae.ca.comcast.net] has joined #code |
21:14 | | mode/#code [+ao Derakon Derakon] by ChanServ |
21:17 | | Turaiel[Offline] is now known as Turaiel |
--- Log closed Thu Apr 18 21:22:48 2013 |
--- Log opened Thu Apr 18 21:23:12 2013 |
21:23 | | TheWatcher [chris@Nightstar-3762b576.co.uk] has joined #code |
21:23 | | Irssi: #code: Total of 40 nicks [19 ops, 0 halfops, 0 voices, 21 normal] |
21:23 | | mode/#code [+o TheWatcher] by ChanServ |
21:23 | < RichyB> | I'm assuming that 24GB means 6 sticks of 4GB each. |
21:23 | | Irssi: Join to #code was synced in 38 secs |
21:23 | <&ToxicFrog|W`rkn> | I have no idea. |
21:23 | < RichyB> | But 8GB sticks are pretty cheap now. ? |
21:24 | <&ToxicFrog|W`rkn> | (this is my corp workstation. A guy showed up with a gurney and when the computer came back it had twice as much memory in it.) |
21:27 | < RichyB> | Crucial sell individual 8GB sticks for about $62 at the moment. |
21:29 | < RichyB> | ooh |
21:30 | < RichyB> | SuperMicro make some really big workstations going up to 16 DIMM slots. |
21:32 | <&ToxicFrog|W`rkn> | I do not, in fact, have to buy my own workstation~ |
21:32 | < RichyB> | Naturally not. |
21:33 | < RichyB> | Just seems odd to me for google to have put lots of RAM into a software engineer's workstation when they could have put LOTS of RAM into that same software engineer's workstation. |
21:35 | | Derakon [Derakon@Nightstar-a3b183ae.ca.comcast.net] has quit [Ping timeout: 121 seconds] |
21:35 | | Derakon [Derakon@Nightstar-a3b183ae.ca.comcast.net] has joined #code |
21:35 | | mode/#code [+ao Derakon Derakon] by ChanServ |
21:39 | <&ToxicFrog|W`rkn> | RichyB: OTOH, there's no point in putting in more RAM than will actually be used, especially when that RAM could go someplace where it will actually be useful. |
21:39 | <&ToxicFrog|W`rkn> | I'm working in a domain where 12GB is the standard, but I'm working on specific projects with unusually high memory requirements, so I get an upgrade. |
21:45 | < RichyB> | You're right. I'm just very enthusiastic about chasing Moore's Law for memory capacity as much as I can since my workstations all started getting explosively faster shortly after the AMD64 switch. |
21:46 | <&ToxicFrog|W`rkn> | My gaming machine at home still has 4GB~ |
21:48 | < RichyB> | Makes little odds, current games are mostly written to the 256MB memory budget of the PS3. |
21:49 | < RichyB> | You'll find the need to upgrade as soon as the PS4 comes out because suddenly game studios will be giving you games ported from a machine with 8GB of RAM in it. |
21:53 | <&ToxicFrog|W`rkn> | Yeah, I'll probably just rebuild Durandal almost entirely when that happens. |
22:14 | | celticminstrel [celticminst@Nightstar-e83b3651.cable.rogers.com] has quit [[NS] Quit: And lo! The computer falls into a deep sleep, to awake again some other day!] |
22:18 | | Derakon [Derakon@Nightstar-a3b183ae.ca.comcast.net] has quit [Ping timeout: 121 seconds] |
22:18 | | Derakon [Derakon@Nightstar-a3b183ae.ca.comcast.net] has joined #code |
22:19 | | mode/#code [+ao Derakon Derakon] by ChanServ |
22:21 | | * ToxicFrog|W`rkn deploys git rebase -i for the first time |
22:22 | <~Vornicus> | One of the things I have my money aimed at when I actually have money is a 32gb upgrade for my desktop. |
22:25 | | Derakon [Derakon@Nightstar-a3b183ae.ca.comcast.net] has quit [Ping timeout: 121 seconds] |
22:32 | <&ToxicFrog|W`rkn> | ...what do you do with 32GB? |
22:33 | <~Vornicus> | I'm not sure but it was cheapass at fry's last time I went. |
23:00 | | Turaiel is now known as Turaiel[Offline] |
23:07 | < RichyB> | ToxicFrog|W`rkn: pull entire videogames into filesystem cache with a big sequential read by just hitting the directory with the local equivalent of "tar cf /dev/null /opt/somedamngame/" |
23:16 | | d4de [olorin@687AAB.418D22.EDB4A5.4900B1] has joined #code |
23:42 | | Derakon [Derakon@Nightstar-a3b183ae.ca.comcast.net] has joined #code |
23:42 | | mode/#code [+ao Derakon Derakon] by ChanServ |
23:49 | | d4de [olorin@687AAB.418D22.EDB4A5.4900B1] has quit [NickServ (GHOST command used by d4de_)] |
23:50 | | d4de [olorin@687AAB.418D22.EC5942.3BAF5D] has joined #code |
23:54 | | d4de [olorin@687AAB.418D22.EC5942.3BAF5D] has quit [Ping timeout: 121 seconds] |
--- Log closed Fri Apr 19 00:00:06 2013 |