Comment by Petrus on Meetup : Shanghai Less Wrong Meetup · 2012-04-16T05:28:38.831Z · LW · GW

Meeting postponed to 22nd, correct?

Comment by Petrus on Shanghai Less Wrong Meetup April 30th, 2pm · 2011-04-18T06:54:54.807Z · LW · GW

I'll be there!

Have been thinking about organizing a meetup myself but always doubted whether Shanghai had enough aspiring rationalists :)

Comment by Petrus on Spreadsheet-based tool for tracking time · 2011-01-21T04:59:22.467Z · LW · GW

Thank you for sharing this cleverly designed worksheet.

Have been playing with it for a couple of days now and am integrating it into my existing tracking sheet (where bodyweight and personal finances are among the other variables being tracked).

I have made a small modification to enable faster date- and time entry with keyboard shortcuts. Save the spreadsheet as a macro-enabled workbook, then open the VBA editor with alt+f11. Hit 'insert'; 'module'; paste the code below and save. You can now enter the current date using ctrl+d and the current time with ctrl+t.

Sub ins_date() ' ' insdate Macro ' ' Keyboard Shortcut: Ctrl+d ' ActiveCell.FormulaR1C1 = "=TODAY()" ActiveCell.Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks :=False, Transpose:=False Application.CutCopyMode = False

End Sub Sub ins_time() ' ' ins_time Macro ' ' Keyboard Shortcut: Ctrl+t ' ActiveCell.Value = Time

End Sub

Comment by Petrus on Meta: A 5 karma requirement to post in discussion · 2011-01-20T08:24:33.588Z · LW · GW

Absolutely. Especially when reading the discussion section in an RSS reader the sheer amount of spam is depressing.

A quick and dirty solution would be to block the IP-range of the 'Pandora' user accounts.