Posts

Sorted by New

Wiki Contributions

Comments

Sorted by
Petrus00

Meeting postponed to 22nd, correct?

Petrus00

I'll be there!

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

Petrus10

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

Petrus40

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.