Nip and I have been working on a solution to find a better way to post data within a table on SoSH, and he asked me to post our current status here. In a nutshell, Nip created some new 'BBcodes' (the message board equivalent of basic HTML) to allow for basic table functions. Using those new codes, we have created an Excel spreadsheet available for download, which contains a macro that will take the data from the spreadsheet, and spit out the BBcode necessary to post the data in a table on SoSH.
Follow this link: http://www.geocities.com/soshtable/
On that Web page is a link to the hosted Excel file. Just right-click and save.
Once you have your data in the spreadsheet:
1. Highlight a range of cells
2. Run the macro (either by clicking the 'Convert to SoSH Table' button or from the Tools menu, selecting the macro option)
3. The Table will be named whatever the sheet name is called.
4. The macro will copy the BBcode for your table to the clipboard, just paste into the message body.
So, instead of the current method that displays:
SPLIT BAA OBP SLG OPS HR vs. Left .219 .284 .267 .551 1 vs. Right .275 .357 .488 .846 23 Home .249 .345 .449 .793 15 Away .283 .343 .446 .790 9 Total .265 .344 .447 .792 24 AL average .275 .340 .437
The new tables will look like this:
Right now the format is still basic, font color, size, bold, etc on a spreadsheet will not be translated at the moment (though they can be addded manually such as putting in a '' tag around the text you wish to bold, which is what I did for Ortiz's 2006 HR total as an example). You can look at the code format by just hitting the reply button to this message. Feel free to give it a try in Backwash, I'll be checking in to see if there are any questions or problems. Hopefully this will save folks some time and effort, and make data easier to read.