Page 1 of 1

How to use Excel to format a Log for posting

PostPosted: Wed Dec 02, 2009 3:40 pm
by Xairren
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.

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

PostPosted: Wed Dec 02, 2009 3:54 pm
by Stam
Awesome, Brian. Thanks!!

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

PostPosted: Thu Dec 03, 2009 3:36 am
by Jiriki
All hail the mighty Brian! :D