Page 1 of 1
Tables
Posted: Tue Aug 02, 2022 12:21 pm
by SwampSooner
I am getting Survivor Pick'em ready for the season. Last year, my Excel tables would mush together and I would have to space the columns manually. I reviewed the "instruction" manual and can't get tables to work (I need some code examples).
Can anyone help me to the right path?
Re: Tables
Posted: Tue Aug 02, 2022 5:50 pm
by OU_Tom
What sort of examples are you looking for? something like this?
Year | AVG | OBP | SLG | OPS |
2022 | .371 | .474 | .734 | 1.208 |
2021 | .405 | .490 | .778 | 1.268 |
2020 | .317 | .392 | .542 | .934 |
2019 | .344 | .435 | .639 | 1.074 |
2018 | .321 | .424 | .532 | .956 |
2017 | .311 | .393 | .471 | .864 |
2016 | .351 | .427 | .538 | .965 |
2015 | .361 | .473 | .657 | 1.130 |
2014 | .319 | .431 | .546 | .977 |
2013 | .335 | .461 | .582 | 1.043 |
2012 | .316 | .410 | .546 | .956 |
|Year|AVG|OBP|SLG|OPS|
|---:|---:|---:|---:|---:|
|2022|.371|.474|.734|1.208|
|2021|.405|.490|.778|1.268|
|2020|.317|.392|.542|.934|
|2019|.344|.435|.639|1.074|
|2018|.321|.424|.532|.956|
|2017|.311|.393|.471|.864|
|2016|.351|.427|.538|.965|
|2015|.361|.473|.657|1.130|
|2014|.319|.431|.546|.977|
|2013|.335|.461|.582|1.043|
|2012|.316|.410|.546|.956|
Season | AVG | GP | GS | AB | R | H | 2B | 3B | HR | RBI | SLG | BB | HBP | SO | OBP | SB | SBA | FLD% |
2019 | .263 | 63 | 63 | 137 | 35 | 36 | 8 | 1 | 8 | 27 | .511 | 17 | 10 | 23 | .380 | 6 | 8 | .953 |
2020 | .370 | 24 | 24 | 73 | 22 | 27 | 7 | 0 | 5 | 23 | .671 | 9 | 3 | 6 | .448 | 4 | 5 | .950 |
2021 | .392 | 60 | 60 | 166 | 62 | 65 | 12 | 0 | 14 | 52 | .717 | 27 | 9 | 14 | .495 | 8 | 8 | .963 |
TOTAL | .340 | 147 | 147 | 376 | 119 | 128 | 27 | 1 | 27 | 102 | .633 | 53 | 22 | 43 | .444 | 18 | 21 | .956 |
Season |AVG |GP |GS |AB |R |H |2B |3B |HR |RBI |SLG |BB |HBP |SO |OBP |SB |SBA |FLD%
----- |--- |-- |-- |-- |--|--|-- |-- |-- |----|----|-- |----|-- |----|-- |----|----
2019 |.263 |63 |63 |137 |35 |36 |8 |1 |8 |27 |.511 |17 |10 |23 |.380 |6 |8 |.953
2020 |.370 |24 |24 |73 |22 |27 |7 |0 |5 |23 |.671 |9 |3 |6 |.448 |4 |5 |.950
2021 |.392 |60 |60 |166 |62 |65 |12 |0 |14 |52 |.717 |27 |9 |14 |.495 |8 |8 |.963
TOTAL |.340 |147 |147 |376 |119 |128 |27 |1 |27 |102 |.633 |53 |22 |43 |.444 |18 |21 |.956
Re: Tables
Posted: Tue Aug 02, 2022 8:30 pm
by SwampSooner
Table Test 1
oklahoma texas tie
2021 2018 RS 1995
2020 2015 1984
2019 2013 1976
2018 CCG 2009 1937
2017 2008 1903
2016 2006
2014 2005
2012 1999
2011 1998
2010 1997
|oklahoma|---:|texas|---:|tie|
|2021|---:|2018|RS|1984|
|2020|---:|2015|---:|1976|
|2019|---:|2013|---:|1937|
|2018|CCG|2009|---:|1903|
|2017|---:|2008|---:|---:|
|2016|---:|2006|---:|---:|
|2014|---:|2005|---:|---:|
|2012|---:|1999|---:|---:|
|2011|---:|1998|---:|---:|
|2010|---:|1997|---:|---:|
Re: Tables
Posted: Tue Aug 02, 2022 8:35 pm
by SwampSooner
I tried to copy your format, but doesn't appear to work. Is there something I need to do to tell the software that this supposed to be a table?
FYI - this is what I am trying to get the table to look like.
oklahoma Texas* tie
2021 2018 RS 1995
2020 2015 1984
2019 2013 1976
2018 CCG 2009 1937
2017 2008 1903
2016 2006
2014 2005
2012 1999
2011 1998
2010 1997
Re: Tables
Posted: Tue Aug 02, 2022 8:46 pm
by OU_Tom
oklahoma | | Texas* | | tie |
2021 | | 2018 | RS | 1984 |
2020 | | 2015 | | 1976 |
2019 | | 2013 | | 1937 |
2018 | CCG | 2009 | | 1903 |
2017 | | 2008 | | |
2016 | | 2006 | | |
2014 | | 2005 | | |
2012 | | 1999 | | |
2011 | | 1998 | | |
2010 | | 1997 | | |
Code: Select all
|oklahoma||Texas*||tie|
|-----| ---:|---:| ----:
|2021||2018|RS|1984|
|2020||2015||1976|
|2019||2013||1937|
|2018|CCG|2009||1903|
|2017||2008|||
|2016||2006|||
|2014||2005|||
|2012||1999|||
|2011||1998|||
|2010||1997|||
Add a row after your header that has the ---: for each column
Don't put the ---: in any cell besides the row that you added after the header
I think that you are getting close
Re: Tables
Posted: Tue Aug 02, 2022 8:57 pm
by SwampSooner
Table Test 2
oklahoma | | Texas* | | tie |
2021 | | 2018 | RS | 1995 |
2020 | | 2015 | | 1984 |
2019 | | 2013 | | 1976 |
2018 | CCG | 2009 | | 1937 |
2017 | | 2008 | | 1903 |
2016 | | 2006 | | |
2014 | | 2005 | | |
2012 | | 1999 | | |
2011 | | 1998 | | |
2010 | | 1997 | | |
Re: Tables
Posted: Tue Aug 02, 2022 9:02 pm
by SwampSooner
Thanks for the help. I guess there is no way to drop a table directly from Excel ....
Re: Tables
Posted: Tue Aug 02, 2022 9:20 pm
by OU_Tom
let me work on that.
Re: Tables
Posted: Tue Aug 02, 2022 10:49 pm
by OU_Tom
@SwampSooner - check out this page. It might be a good way to convert excel to markdown. Probably is a lot easier than doing it by hand
https://tabletomarkdown.com/convert-spr ... -markdown/
PLAYER | SEASONS | SO | IP | SO/7 | BB | SO/BB |
1. | Keilani Ricketts | 2010-13 | 1605 | 1074.1 | 10.46 | | |
2. | Paige Parker | 2015-18 | 968 | 867.1 | 7.81 | 210 | 4.61 |
3. | Jill Most | 1994-97 | 805 | 671.2 | 8.39 | | |
4. | Kami Keiter | 2002-05 | 733 | 910.1 | 5.64 | | |
5. | Jennifer Stewart | 1999-02 | 634 | 928.2 | 4.78 | | |
6. | D. J. Mathis | 2006-09 | 597 | 637.0 | 6.56 | | |
7. | Michelle Gascoigne | 2010-13 | 528 | | | | |
8. | Patti Graham | 1981-84 | 462 | 807.1 | 4.01 | | |
| Cheryl Jacobs | 1978-80 | 462 | 752.1 | 4.30 | | |
10. | Kelsey Stevens | 2014-16 | 456 | 429.0 | 7.44 | 203 | 2.25 |
11. | Giselle Juarez | 2019-21 | 437 | 321.0 | 9.53 | 66 | 6.62 |
12. | Lana Moran | 1997-00 | 420 | 621.1 | 4.73 | | |
13. | Mariah Lopez | 2017-19 | 355 | 295.0 | 8.42 | 55 | 6.45 |
14. | Shannon Saile | 2019-21 | 347 | 249.0 | 9.76 | 97 | 3.58 |
| Lauren Eckermann | 2007-08 | 347 | 387.2 | 6.27 | 72 | 0.00 |
16. | Nicole Denes | 2003-06 | 325 | | | | |
17. | Brea Moore | 1994-95 | 311 | |
Re: Tables
Posted: Fri Aug 05, 2022 7:11 am
by OU_Tom
I did use that link to create some tables. It works great. Hopefully you will have the same sort of success with your spread sheets Swamp
Re: Tables
Posted: Sun Aug 07, 2022 2:16 pm
by SwampSooner
| Players |
| -------------:|
| |
| gcruse7 |
| Aries |
| White River |
| Wishbone |
| OU Guy |
| BixSooner |
| Triple Option |
| Bixby\_Sooner |
| OU Chinaman |
| SwampSooner |
| HumbleSooner |
| MHSooner |
| IMASooner |
| OU Tom |
| Gandalf |
Re: Tables
Posted: Sun Aug 07, 2022 2:25 pm
by SwampSooner
Date | Bowl | Opponents |
| | |
Dec. 29 | Alamo | Oklahoma (10-2) vs. Oregon (10-3) |
| San Antonio | |
| | |
Dec. 29 | Cheez-It | Clemson (9-3) vs. Iowa State (7-5) |
| Orlando, Fla. | |
| | |
Dec. 28 | Liberty | Texas Tech (6-6) vs. Miss. State (7-5) |
| Memphis | |
| | |
Dec. 28 | Holiday | UCLA (8-4) vs. NC State (9-3) |
| San Diego | |
| | |
Dec. 28 | Birmingham | Houston (11-2) vs. Auburn (6-6) |
| Birmingham, Ala. | |
| | |
Dec. 22 | Armed Forces | Army (8-3) vs. Missouri (6-6) |
| Fort Worth, Tex. | |
Re: Tables
Posted: Sun Aug 07, 2022 2:27 pm
by SwampSooner
Thank you for the help. The last two entries shows me that I cannot have a table with just one column, but it works fine with several columns. Shows me what I get when I am being lazy.