LESSWRONG
LW

Petrus
5040
Message
Dialogue
Subscribe

Posts

Sorted by New

Wikitag Contributions

Comments

Sorted by
Newest
Meetup : Shanghai Less Wrong Meetup
Petrus13y00

Meeting postponed to 22nd, correct?

Reply
Shanghai Less Wrong Meetup April 30th, 2pm
Petrus14y00

I'll be there!

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

Reply
Spreadsheet-based tool for tracking time
Petrus15y10

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

Reply
Meta: A 5 karma requirement to post in discussion
Petrus15y40

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.

Reply
No wikitag contributions to display.
No posts to display.