How to use Excel to format a Log for posting

A place to discuss the setting, rules and anything else Out of Character.

Moderator: Dungeon Masters

How to use Excel to format a Log for posting

Postby Xairren » Wed Dec 02, 2009 3:40 pm

How to use Excel to format a Log for posting:
(As requested this includes each and every step.)

  1. Left click on the "Log" button from the selected chat room.
  2. Select "Note Pad" (if not auto-selected) for the log destination.
  3. Highlight and copy (Ctrl-C) all the text in the "Note Pad".
  4. Open and paste (Ctrl-V) the copied text to a blank Excel worksheet.
  5. Now you will see two columns of text that overlap into the next columns.
  6. Left click on the column heading "A" to select that column only.
  7. Move your mouse left over the line between column headings "A" & "B" and double left click on that line to automatically expand column "A" to the proper width for the names in the log.
  8. Left click on the column heading "B" to select that column only.
  9. Right click on column "B" to bring up the options menu, select "Column Width" and set it to "100"
  10. Right click on column "B" to bring up the options menu again, select "Format Cells" and select the "Alignment" tab.
  11. Change the "Vertical" alignment to "Top", check the "Text Control" option "Wrap Text" and click on "Ok"
  12. Now you have the raw log in a readable format. Go through and select those rows that have text that you do not want to keep (ie people logging in and out of the room). Left click on the junk row number, right click on the row and select delete.
  13. Go to the top of column "C" (cell C1), enter number "1" and press enter
  14. In the next column "C" cell (cell C2) and enter the following Excel code: "=c1+1" and press enter
  15. Now left click that cell (cell C2) and press Ctrl-C to copy it
  16. Left click on the next column "C" cell (cell C3), press and hold the "Shift" key, scroll down to bottom of log, left click the matching "C" cell and press Ctrl-V to paste the formula in all of the cells.
  17. Now left click on the "Data" tab at the top of the page
  18. Left click on "Sort", choose "Column C, Values, Largest to Smallest" and click "Ok" -- Now the log is in a readable order
  19. Go to the top of column D and select the first cell (cell D1)
  20. Enter the following Excel code to format the log for pasting to the forums
    Code: Select all
    = A1 & "[list][b]" & B1 & "[/b][/list]"
  21. Now left click that cell (cell D1) and press Ctrl-C to copy it
  22. Left click on the next column "D" cell (cell D2), press and hold the "Shift" key, scroll down to bottom of log, left click the matching "D" cell and press Ctrl-V to paste the formula in all of the cells.
  23. Highlight all of the column D cells with the formatted log, copy (Ctrl-C) and paste to a forum post (Ctrl-V)
  24. Click on "Preview" to check your work and the "Submit" if it is correct.
Xairren
 
Posts: 1191
Joined: Sat Sep 30, 2006 7:04 am
Location: Keokuk, Iowa

Re: How to use Excel to format a large Log for posting

Postby Stam » Wed Dec 02, 2009 3:54 pm

Awesome, Brian. Thanks!!
User avatar
Stam
 
Posts: 1763
Joined: Wed Nov 01, 2006 6:50 pm

Re: How to use Excel to format a large Log for posting

Postby Jiriki » Thu Dec 03, 2009 3:36 am

All hail the mighty Brian! :D
"Meddle not in the affairs of dragons, for thou art crunchy and taste good with gold."
User avatar
Jiriki
 
Posts: 1434
Joined: Wed Nov 01, 2006 1:30 pm
Location: UK!


Return to OOC Questions, Answers & Discussions

Who is online

Users browsing this forum: No registered users and 0 guests

cron