| --- Log opened Sun Nov 23 00:00:38 2014 |
| 01:34 | | Alek [omegaboot@Nightstar-c8t.a00.36.73.IP] has quit [Ping timeout: 121 seconds] |
| 01:35 | | Checkmate [Z@Nightstar-484uip.cust.comxnet.dk] has quit [Ping timeout: 121 seconds] |
| 01:38 | | Alek [omegaboot@Nightstar-c8t.a00.36.73.IP] has joined #code |
| 01:38 | | mode/#code [+o Alek] by ChanServ |
| 01:59 | | Checkmate [Z@Nightstar-484uip.cust.comxnet.dk] has joined #code |
| 01:59 | | mode/#code [+o Checkmate] by ChanServ |
| 02:49 | | Checkmate [Z@Nightstar-484uip.cust.comxnet.dk] has quit [Ping timeout: 121 seconds] |
| 03:44 | | celticminstrel [celticminst@Nightstar-l2rg83.dsl.bell.ca] has quit [[NS] Quit: KABOOM! It seems that I have exploded. Please wait while I reinstall the universe.] |
| 04:39 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has quit [[NS] Quit: Program Shutting down] |
| 05:30 | | Kindamoody[zZz] is now known as Kindamoody |
| 05:47 | | Derakon is now known as Derakon[AFK] |
| 06:22 | | Vornicus [vorn@ServerAdministrator.Nightstar.Net] has quit [[NS] Quit: Leaving] |
| 06:59 | | thalass [thalass@Nightstar-bakqqn.bigpond.net.au] has joined #code |
| 06:59 | | mode/#code [+o thalass] by ChanServ |
| 07:00 | | Harlow [harlow@Nightstar-04f.4po.201.71.IP] has joined #code |
| 08:03 | | Orthia [orthianz@Nightstar-q9h.84h.224.119.IP] has quit [Ping timeout: 121 seconds] |
| 08:07 | | Orthia [orthianz@Nightstar-pe5.ufa.184.203.IP] has joined #code |
| 08:07 | | mode/#code [+o Orthia] by ChanServ |
| 08:43 | | thalass [thalass@Nightstar-bakqqn.bigpond.net.au] has quit [Ping timeout: 121 seconds] |
| 08:44 | | Harlow [harlow@Nightstar-04f.4po.201.71.IP] has quit [[NS] Quit: BED] |
| 09:24 | | thalass [thalass@Nightstar-bakqqn.bigpond.net.au] has joined #code |
| 09:24 | | mode/#code [+o thalass] by ChanServ |
| 09:36 | | Orthia [orthianz@Nightstar-pe5.ufa.184.203.IP] has quit [Ping timeout: 121 seconds] |
| 09:41 | | Orthia [orthianz@Nightstar-r89.tbp.224.119.IP] has joined #code |
| 09:41 | | mode/#code [+o Orthia] by ChanServ |
| 10:12 | | gizmore [kvirc@Nightstar-f1n405.pools.vodafone-ip.de] has quit [[NS] Quit: KVIrc 4.3.1 Aria http://www.kvirc.net/] |
| 10:15 | | gizmore [kvirc@Nightstar-f1n405.pools.vodafone-ip.de] has joined #code |
| 11:14 | | Kindamoody is now known as Kindamoody|afk |
| 11:28 | | Checkmate [Z@Nightstar-484uip.cust.comxnet.dk] has joined #code |
| 11:29 | | mode/#code [+o Checkmate] by ChanServ |
| 11:31 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has joined #code |
| 12:57 | | mac [macdjord@Nightstar-c0i1dq.cable.rogers.com] has quit [[NS] Quit: Tekeli-li! Tekeli-li!] |
| 13:50 | | gnolam [lenin@Nightstar-utbkuh.cust.bredbandsbolaget.se] has joined #code |
| 13:51 | | mode/#code [+o gnolam] by ChanServ |
| 14:27 | <&jerith> | Whee! I won at Excel. |
| 14:28 | <@Tamber> | ...by which you mean you lost the least? |
| 14:29 | <&jerith> | My sister's boyfriend showed my mom how to use a VLOOKUP function to calculate the cost of her baking. |
| 14:29 | <&jerith> | There's a sheet with the ingredients list and then a sheet for each recipe. |
| 14:29 | <@Tamber> | :) |
| 14:29 | <&jerith> | Except this thing kept returning absurd costs. |
| 14:30 | <&jerith> | Turns out there were two different problems. |
| 14:30 | <&jerith> | Firstly, VLOOKUP defaults to "pick an arbitrary row if you can't find the one you're looking for". |
| 14:32 | <&jerith> | (The actual behaviour is "assume the list is sorted and pick the closest existing value", but her list isn't sorted. It's a bloody stupid default.) |
| 14:36 | <&jerith> | Secondly, all cell references are relative by default and therefore range of cells the lookup referenced kept changing when Excel decided to be clever. |
| 14:36 | <@Azash> | >VLOOKUP defaults to "pick an arbitrary row if you can't find the one you're looking for" |
| 14:36 | <@Azash> | What? |
| 14:37 | <@Tamber> | See the line immediately after that. ;) |
| 14:37 | <@Azash> | Yeah it's still stupid |
| 14:37 | <&jerith> | By their powers combined, these two problems resulted in wrong answers instead of errors. |
| 14:37 | <@Azash> | "Here's a value kinda similar to what you wanted" seems more Mongo than Excel |
| 14:37 | <@Azash> | >> |
| 14:38 | <&jerith> | See the "Range_lookup" entry at http://office.microsoft.com/en-za/excel-help/vlookup-HP005209335.aspx |
| 14:39 | <&jerith> | I can see how that might be useful behaviour in some circumstances, but *not* the bloody default. |
| 14:40 | <&jerith> | Anyway, I learned enough VBA to write a function that does the necessary calculation using the correct parameters and showed my mom how to use that. |
| 14:41 | <&jerith> | She is now very happy. |
| 16:26 | | Vornicus [vorn@ServerAdministrator.Nightstar.Net] has joined #code |
| 16:26 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
| 16:58 | | celticminstrel [celticminst@Nightstar-l2rg83.dsl.bell.ca] has joined #code |
| 16:58 | | mode/#code [+o celticminstrel] by ChanServ |
| 18:04 | | iospace is now known as io\ |
| 18:04 | | io\ is now known as io\PACKERS |
| 18:45 | | Kindamoody|afk is now known as Kindamoody |
| 18:53 | | Turaiel is now known as Tur[a]iel |
| 19:23 | | Derakon[AFK] is now known as Derakon |
| 20:24 | | gnolam [lenin@Nightstar-utbkuh.cust.bredbandsbolaget.se] has quit [The TLS connection was non-properly terminated.] |
| 20:30 | | Checkmate [Z@Nightstar-484uip.cust.comxnet.dk] has quit [Ping timeout: 121 seconds] |
| 20:31 | | gnolam [lenin@Nightstar-utbkuh.cust.bredbandsbolaget.se] has joined #code |
| 20:31 | | mode/#code [+o gnolam] by ChanServ |
| 20:54 | | Kindamoody is now known as Kindamoody[zZz] |
| 20:57 | | macdjord [macdjord@Nightstar-7rac1r.mc.videotron.ca] has joined #code |
| 20:57 | | mode/#code [+o macdjord] by ChanServ |
| 21:09 | | Lamabo [thelambo@Nightstar-ic6koa.fl.comcast.net] has joined #code |
| 21:11 | | Lambo [thelambo@Nightstar-ic6koa.fl.comcast.net] has quit [Ping timeout: 121 seconds] |
| 21:56 | | Lamabo is now known as Lambo |
| 23:40 | | Orthia [orthianz@Nightstar-r89.tbp.224.119.IP] has quit [Ping timeout: 121 seconds] |
| 23:44 | | Orthia [orthianz@Nightstar-r89.tbp.224.119.IP] has joined #code |
| 23:44 | | mode/#code [+o Orthia] by ChanServ |
| 23:44 | | Orthia is now known as ReivWerk |
| 23:45 | | Checkmate [Z@Nightstar-484uip.cust.comxnet.dk] has joined #code |
| 23:45 | | mode/#code [+o Checkmate] by ChanServ |
| --- Log closed Mon Nov 24 00:00:53 2014 |