Tables
- SwampSooner
- Posts: 1014
- Joined: Tue Oct 26, 2021 2:22 pm
- 2
- Has thanked: 402 times
- Been thanked: 299 times
Tables
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?
Can anyone help me to the right path?
- OU_Tom
- Posts: 1894
- Joined: Sun Sep 26, 2021 12:36 pm
- 2
- Has thanked: 359 times
- Been thanked: 395 times
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
- SwampSooner
- Posts: 1014
- Joined: Tue Oct 26, 2021 2:22 pm
- 2
- Has thanked: 402 times
- Been thanked: 299 times
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|---:|---:|
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|---:|---:|
- SwampSooner
- Posts: 1014
- Joined: Tue Oct 26, 2021 2:22 pm
- 2
- Has thanked: 402 times
- Been thanked: 299 times
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
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
Last edited by SwampSooner on Tue Aug 02, 2022 8:49 pm, edited 1 time in total.
- OU_Tom
- Posts: 1894
- Joined: Sun Sep 26, 2021 12:36 pm
- 2
- Has thanked: 359 times
- Been thanked: 395 times
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|||
Don't put the ---: in any cell besides the row that you added after the header
I think that you are getting close
- SwampSooner
- Posts: 1014
- Joined: Tue Oct 26, 2021 2:22 pm
- 2
- Has thanked: 402 times
- Been thanked: 299 times
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 |
- SwampSooner
- Posts: 1014
- Joined: Tue Oct 26, 2021 2:22 pm
- 2
- Has thanked: 402 times
- Been thanked: 299 times
- OU_Tom
- Posts: 1894
- Joined: Sun Sep 26, 2021 12:36 pm
- 2
- Has thanked: 359 times
- Been thanked: 395 times
@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/
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 |
- SwampSooner
- Posts: 1014
- Joined: Tue Oct 26, 2021 2:22 pm
- 2
- Has thanked: 402 times
- Been thanked: 299 times
| Players |
| -------------:|
| |
| gcruse7 |
| Aries |
| White River |
| Wishbone |
| OU Guy |
| BixSooner |
| Triple Option |
| Bixby\_Sooner |
| OU Chinaman |
| SwampSooner |
| HumbleSooner |
| MHSooner |
| IMASooner |
| OU Tom |
| Gandalf |
| -------------:|
| |
| gcruse7 |
| Aries |
| White River |
| Wishbone |
| OU Guy |
| BixSooner |
| Triple Option |
| Bixby\_Sooner |
| OU Chinaman |
| SwampSooner |
| HumbleSooner |
| MHSooner |
| IMASooner |
| OU Tom |
| Gandalf |
- SwampSooner
- Posts: 1014
- Joined: Tue Oct 26, 2021 2:22 pm
- 2
- Has thanked: 402 times
- Been thanked: 299 times
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. |
- SwampSooner
- Posts: 1014
- Joined: Tue Oct 26, 2021 2:22 pm
- 2
- Has thanked: 402 times
- Been thanked: 299 times
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.
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute