Posting data

AlNipper49

Huge Member
Dope
SoSH Member
Apr 3, 2001
44,840
Mtigawi
figured with the season right around the corner I'll remind folks of the ability to paste data from excel in the forums. Many thanks to Marbleheader for coming up with this and for Sprowl for suggesting we re-post this crap

===================================================================

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:

Code:
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:
Ortiz career stats
Year Team G AB R H 2B 3B HR RBI BB K SB CS AVG OBP SLG OPS
1997 MIN 15 49 10 16 3 0 1 6 2 19 0 0 0.327 0.353 0.449 0.802
1998 MIN 86 278 47 77 20 0 9 46 39 72 1 0 0.277 0.371 0.446 0.817
1999 MIN 10 20 1 0 0 0 0 0 5 12 0 0 0 0.2 0 0.2
2000 MIN 130 415 59 117 36 1 10 63 57 81 1 0 0.282 0.364 0.446 0.81
2001 MIN 89 303 46 71 17 1 18 48 40 68 1 0 0.234 0.324 0.475 0.799
2002 MIN 125 412 52 112 32 1 20 75 43 87 1 2 0.272 0.339 0.5 0.839
2003 BOS 128 448 79 129 39 2 31 101 58 83 0 0 0.288 0.369 0.592 0.961
2004 BOS 150 582 94 175 47 3 41 139 75 133 0 0 0.301 0.38 0.603 0.983
2005 BOS 159 601 119 180 40 1 47 148 102 124 1 0 0.3 0.397 0.604 1.001
2006 BOS 151 558 115 160 29 2 54 137 119 117 1 0 0.287 0.413 0.636 1.049
Career 1043 3666 622 1037 263 11 231 763 540 796 6 2 0.283 0.374 0.55 0.924


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.
 

Cuzittt

Bouncing with Anger
Lifetime Member
SoSH Member
Nov 20, 2001
20,301
Sinister Funkhouse #17
From phrenile:

---
Because I love you, I wrote some Javascript that will generate a table suitable for posting here on SoSH. At this time, it has very limited handling of text style formatting, but it works without VisualBasic macro scripting, so it should work if you can't get the soshtable Excel spreadsheet to work because you're running Excel with your security settings turned up or on a mac, or using OpenOffice, etc.

See here: http://www.geocities.com/phrenile/soshtable/

The directions should be self-explanatory, but just put a title in the Title field and copy and paste your spreadsheet cell range into the big box on the left. The BBcode table should appear in the big box on the right, suitable for copying and pasting into posts or comments at SoSH. (The result will look like it's trying to handle font colors. That's because it's adorable.)

If you want your column headers to be bolded/italicized/underlined, put your first row in that field and click the checkboxes.

(If you have trouble pasting your cells for whatever reason, then try exporting your spreadsheet as a tab-separated file; open it in a text editor; and copy and paste it from there.)

Bug reports and feedback are welcome.
 

BucketOBalls

Member
SoSH Member
Apr 5, 2009
5,643
Steak of Turmoil
Three notes if your trying to make small table manually

1) You need to include the width(=XX%) parameter on the table data "" tags. (this is not true in HTML)

CODE
my info <--- gives an error
my info <---- correct

The width only matters in a relative sense, so a 2 column table with widths of 2% and 4% gives the second cell twice as wide as the first. You can also use a "*" in place of a number, but the parameter does have to be there.


2)The table must be all on one line, with nothing between the tags. Any white space/carriage returns that are between tags ends up inside one of the cells or creating a big empty space at the end of the table rather than being ignored as one might expect
CODE
row 1
row 2

^^^^
This is wrong.

row 1
row 2

^^^^
Correct version


3) phrenile's applet is actually here. (although the above does link to it)
 

The Dali

New Member
Aug 5, 2009
52
QUOTE (Cuzittt @ Mar 26 2009, 03:02 PM) index.php?act=findpost&pid=2178975
From phrenile:

---
Because I love you, I wrote some Javascript that will generate a table suitable for posting here on SoSH. At this time, it has very limited handling of text style formatting, but it works without VisualBasic macro scripting, so it should work if you can't get the soshtable Excel spreadsheet to work because you're running Excel with your security settings turned up or on a mac, or using OpenOffice, etc.

See here: http://www.geocities.com/phrenile/soshtable/

The directions should be self-explanatory, but just put a title in the Title field and copy and paste your spreadsheet cell range into the big box on the left. The BBcode table should appear in the big box on the right, suitable for copying and pasting into posts or comments at SoSH. (The result will look like it's trying to handle font colors. That's because it's adorable.)

If you want your column headers to be bolded/italicized/underlined, put your first row in that field and click the checkboxes.

(If you have trouble pasting your cells for whatever reason, then try exporting your spreadsheet as a tab-separated file; open it in a text editor; and copy and paste it from there.)

Bug reports and feedback are welcome.








These link are broken.
 

Hokie Sox

New Member
Aug 2, 2010
83
Falls Church, VA
QUOTE (Cuzittt @ Mar 26 2009, 03:02 PM) From phrenile:

---
Because I love you, I wrote some Javascript that will generate a table suitable for posting here on SoSH. At this time, it has very limited handling of text style formatting, but it works without VisualBasic macro scripting, so it should work if you can't get the soshtable Excel spreadsheet to work because you're running Excel with your security settings turned up or on a mac, or using OpenOffice, etc.

See here: http://www.geocities.com/phrenile/soshtable/

The directions should be self-explanatory, but just put a title in the Title field and copy and paste your spreadsheet cell range into the big box on the left. The BBcode table should appear in the big box on the right, suitable for copying and pasting into posts or comments at SoSH. (The result will look like it's trying to handle font colors. That's because it's adorable.)

If you want your column headers to be bolded/italicized/underlined, put your first row in that field and click the checkboxes.

(If you have trouble pasting your cells for whatever reason, then try exporting your spreadsheet as a tab-separated file; open it in a text editor; and copy and paste it from there.)

Bug reports and feedback are welcome.







These link are broken.

What do you guys think about having a thread with advanced baseball statistics from BP including UZR/all the Sabermetrics to pin for the lurkers thread? It could be along the lines of an "Advanced Baseball Statistics For Dumbies" idea. This should cultivate more knowledge/intelligent discussion through the lurker board and even the main board, as there are many people in both threads who don't know what these statistics mean (myself included).

It would involve someone from the main board who knows this stuff having to explain. However, I think it would definitely be worth it and would result in less tautological arguments going on around in both boards.


 

absintheofmalaise

too many flowers
Dope
SoSH Member
Mar 16, 2005
23,287
The gran facenda
What do you guys think about having a thread with advanced baseball statistics from BP including UZR/all the Sabermetrics to pin for the lurkers thread? It could be along the lines of an "Advanced Baseball Statistics For Dumbies" idea. This should cultivate more knowledge/intelligent discussion through the lurker board and even the main board, as there are many people in both threads who don't know what these statistics mean (myself included).

It would involve someone from the main board who knows this stuff having to explain. However, I think it would definitely be worth it and would result in less tautological arguments going on around in both boards.
We've had threads like that in the past. I think there's also some stuff on the SoSH wiki. Go ahead and start a thread in MLB if you want to. It's always good to have a discussion on stats.
 

Senator Donut

post-Domer
SoSH Member
Apr 21, 2010
5,485
What do you guys think about having a thread with advanced baseball statistics from BP including UZR/all the Sabermetrics to pin for the lurkers thread? It could be along the lines of an "Advanced Baseball Statistics For Dumbies" idea. This should cultivate more knowledge/intelligent discussion through the lurker board and even the main board, as there are many people in both threads who don't know what these statistics mean (myself included).

It would involve someone from the main board who knows this stuff having to explain. However, I think it would definitely be worth it and would result in less tautological arguments going on around in both boards.
If you want a brief, but thorough introduction to statistics such as UZR, FIP, and WAR, I recommend Alex Remington's "Everything You Always Wanted to Know" series. They are so well written that even my father was able to read through all of them.
 

AlNipper49

Huge Member
Dope
SoSH Member
Apr 3, 2001
44,840
Mtigawi
yeah I would need to make the changes on this end, that's just a link to the actual bbcode changes (which scott and I had to do on the old board as well)

(I just say that so nobody else tries, it'll just be a waste of time ;) )
 

SumnerH

Malt Liquor Picker
Dope
SoSH Member
Jul 18, 2005
31,842
Alexandria, VA
yeah I would need to make the changes on this end, that's just a link to the actual bbcode changes (which scott and I had to do on the old board as well)

(I just say that so nobody else tries, it'll just be a waste of time ;) )
I implemented table bbcode for some backward compatibility when we did the migration, so that old tables render (e.g. in the Death pool thread). But the tableizer's busted going forward.

Give me a minute to think about it.