code logs -> 2013 -> Thu, 18 Apr 2013< code.20130417.log - code.20130419.log >
--- 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
code logs -> 2013 -> Thu, 18 Apr 2013< code.20130417.log - code.20130419.log >

[ Latest log file ]