Jump to content


Yo! You're not logged in. Why am I seeing this ad?

Photo

Posting data


  • Please log in to reply
10 replies to this topic

#1 AlNipper49


  • Huge Member


  • 34,594 posts

Posted 01 March 2009 - 01:32 PM

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:

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.

#2 Hyde Park Factor


  • token lebanese


  • 1,280 posts

Posted 02 March 2009 - 03:46 AM

Can this be pinned?

#3 Cuzittt


  • Bouncing with Anger


  • 17,370 posts

Posted 26 March 2009 - 02: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...nile/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.

#4 BucketOBalls


  • SoSH Member


  • 5,644 posts

Posted 08 August 2009 - 10:18 AM

Three notes if your trying to make small table manually

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

CODE
   [td] my info [/td]  <--- gives an error
   [td=10%]my info[/td] <---- 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
   [table]
   [tr][td=*]row 1[/td][/tr]
   [tr][td=*]row 2[/td][/tr]
   [/table]
   ^^^^
   This is wrong.
  
   [table][tr][td=*]row 1[/td][/tr][tr][td=*]row 2[/td][/tr][/table]
   ^^^^
   Correct version


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

#5 The Dali

  • 49 posts

Posted 12 May 2010 - 11:04 AM

QUOTE (Cuzittt @ Mar 26 2009, 03:02 PM) <{POST_SNAPBACK}>
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...nile/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.

Edited by The Dali, 12 May 2010 - 11:05 AM.


#6 Hokie Sox

  • 83 posts

Posted 02 August 2010 - 03:46 PM

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...nile/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.




#7 absintheofmalaise


  • too many flowers


  • 11,086 posts

Posted 04 August 2010 - 10:41 PM

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.

#8 Domer

  • 1,956 posts

Posted 10 August 2010 - 04:16 PM

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.

#9 Jer

  • 280 posts

Posted 17 January 2014 - 11:52 AM

Does anyone have a link that works for this table generator? Or is there a newer trick for it?



#10 phrenile


  • SoSH Member


  • 5,997 posts

Posted 17 January 2014 - 12:15 PM

Does anyone have a link that works for this table generator? Or is there a newer trick for it?


http://www.sonsofsam....net/soshchart/

#11 Jer

  • 280 posts

Posted 17 January 2014 - 12:18 PM

Perfect. Thanks!






1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users