Perusoe's Testing Grounds

Go to your Code block above. Copy all of it into Word.

Then highlight it all and copy to Excel

From there copy to the forum.

Not sure about the underscores and stuff, but the rest of the basic chart should work. It took me under a minute to just copy paste the section I did.

Everything in that code block was copied from Word and pasted directly here. Shouldn’t I just paste that into Excel?

Okay, I just pasted directly into Excel. When I did, everything was already selected so I just copied it. Now, I’m going to paste it below. Here goes:

Season Start End Days Patch*

1	Friday,	8/29/2014	9:00	PM EDT	Friday,	2/3/2015	7:00	PM EST	158	2.1.0
2	Friday,	2/13/2015	9:00	PM EST	Sunday,	4/6/2015	12:00	AM EDT	51	2.1.2
3	Friday,	4/10/2015	9:00	PM EDT	Sunday,	8/23/2015	8:00	PM EDT	135	2.2.0
4	Friday,	8/28/2015	8:00	PM EDT						2.3.0
					Wednesday,	12/30/2015	8:00	PM EST	124	2.4.0
5	Friday,	1/15/2016	8:00	PM EDT	Friday,	4/15/2016	8:00	PM EST	91	2.4.1
6	Friday,	4/29/2016	8:00	PM EDT	Friday,	7/22/2016	8:00	PM EDT	84	2.4.2
7	Friday,	8/5/2016	8:00	PM EDT	Friday,	10/14/2016	8:00	PM EDT	70	
8	Friday,	10/21/2016	8:00	PM EDT	Friday,	12/30/2016	8:00	PM EST	70	2.4.3
9	Friday,	1/6/2017	8:00	PM EST	Friday,	3/17/2017	8:00	PM EDT	70	2.5.0
10	Friday,	3/31/2017	8:00	PM EST	Friday,	6/23/2017	8:00	PM EDT	84	2.6.0**
11	Thursday,	7/20/2017	8:00	PM EDT	Friday,	10/20/2017	8:00	PM EDT	92	2.6.1
12	Thursday,	11/9/2017	8:00	PM EST	Sunday,	2/11/2018	8:00	PM EST	94	
13	Friday,	2/23/2018	8:00	PM EST	Sunday,	6/3/2018	8:00	PM EDT	100	2.6.1a
14	Friday,	6/15/2018	8:00	PM EDT	Sunday,	9/16/2018	8:00	PM EDT	93	
15	Friday,	9/21/2018	8:00	PM EDT	Sunday,	1/6/2019	8:00	PM EST	107	2.6.4
16	Friday,	1/18/2019	8:00	PM EST	Sunday,	5/12/2019	8:00	PM EDT	114	2.6.5

══════════════════════════════════════════════════════════════════════════════════════════════

*Patches were deployed before the following Season started.
**Necromancer Class introduced on Tuesday, July 27, 2017 with Patch 2.6.0

Word has all your TAB marks. When you paste to Excel it takes those tab marks and puts stuff in columns for you. When you copy from Excel it adds the forum formatting for you.

Word > Excel > Forum :stuck_out_tongue:

Takes only a few mins and is FAR easier than having to re-format and re-type a whole big doc or table.

Okay. Well it didn’t seem to work when I edited my previous post. So, let me try again.

I will have to play with it some more too. I had no problem doing it the first time, but I just tried it again and it is not translating the tabs to columns between word and excel. Not sure what is different yet between this and the first one I tried.

SEASON Start Date Time Zone End Date Time Zone Days Patch
1 Friday, 8/29/2014 9:00 PM EDT Friday, 2/3/2015 7:00 PM EST 158 2.1.0
2 Friday, 2/13/2015 9:00 PM EST Sunday, 4/6/2015 12:00 AM EDT 51 2.1.2
3 Friday, 4/10/2015 9:00 PM EDT Sunday, 8/23/2015 8:00 PM EDT 135 2.2.0
4 Friday, 8/28/2015 8:00 PM EDT 2.3.0
Wednesday, 12/30/2015 8:00 PM EST 124 2.4.0
5 Friday, 1/15/2016 8:00 PM EDT Friday, 4/15/2016 8:00 PM EST 91 2.4.1
6 Friday, 4/29/2016 8:00 PM EDT Friday, 7/22/2016 8:00 PM EDT 84 2.4.2
7 Friday, 8/5/2016 8:00 PM EDT Friday, 10/14/2016 8:00 PM EDT 70
8 Friday, 10/21/2016 8:00 PM EDT Friday, 12/30/2016 8:00 PM EST 70 2.4.3
9 Friday, 1/6/2017 8:00 PM EST Friday, 3/17/2017 8:00 PM EDT 70 2.5.0
10 Friday, 3/31/2017 8:00 PM EST Friday, 6/23/2017 8:00 PM EDT 84 2.6.0**
11 Thursday, 7/20/2017 8:00 PM EDT Friday, 10/20/2017 8:00 PM EDT 92 2.6.1
12 Thursday, 11/9/2017 8:00 PM EST Sunday, 2/11/2018 8:00 PM EST 94
13 Friday, 2/23/2018 8:00 PM EST Sunday, 6/3/2018 8:00 PM EDT 100 2.6.1a
14 Friday, 6/15/2018 8:00 PM EDT Sunday, 9/16/2018 8:00 PM EDT 93
15 Friday, 9/21/2018 8:00 PM EDT Sunday, 1/6/2019 8:00 PM EST 107 2.6.4
16 Friday, 1/18/2019 8:00 PM EST Sunday, 5/12/2019 8:00 PM EDT 114 2.6.5

Ok, this time I went back to your first post where you had the code block. Copied it all to word then to excel then to here. Added column titles.

Edit again - so it does some odd wrapping, but other than that it was a quick transition. Hmm… Still not sure why it worked copying from the first code block and not the second. Tias is probably right.

Still useful to know we can easily take things from Word to Excel then here, or build simple tables in Excel and paste them here.

Probably a random white space on either side of a copied item/block. Getting that tons with copypastas into the forum editor now. Seems to be a bug with this version of the Discourse software that isn’t present on the WoW side.

Oh, and don’t feel bad about the words wrapping around. Without the ability to properly style the cells/headers thanks to them using HTML 5 mode and no CSS available (almost all HTML 5 arguments require CSS functions), it’s going to keep doing that.

Season Start End Days Patch*

1	Friday,	8/29/2014	9:00	PM EDT	Friday,	2/3/2015	7:00	PM EST	158	2.1.0
2	Friday,	2/13/2015	9:00	PM EST	Sunday,	4/6/2015	12:00	AM EDT	51	2.1.2
3	Friday,	4/10/2015	9:00	PM EDT	Sunday,	8/23/2015	8:00	PM EDT	135	2.2.0
4	Friday,	8/28/2015	8:00	PM EDT						2.3.0
					Wednesday,	12/30/2015	8:00	PM EST	124	2.4.0
5	Friday,	1/15/2016	8:00	PM EDT	Friday,	4/15/2016	8:00	PM EST	91	2.4.1
6	Friday,	4/29/2016	8:00	PM EDT	Friday,	7/22/2016	8:00	PM EDT	84	2.4.2
7	Friday,	8/5/2016	8:00	PM EDT	Friday,	10/14/2016	8:00	PM EDT	70	
8	Friday,	10/21/2016	8:00	PM EDT	Friday,	12/30/2016	8:00	PM EST	70	2.4.3
9	Friday,	1/6/2017	8:00	PM EST	Friday,	3/17/2017	8:00	PM EDT	70	2.5.0
10	Friday,	3/31/2017	8:00	PM EST	Friday,	6/23/2017	8:00	PM EDT	84	2.6.0**
11	Thursday,	7/20/2017	8:00	PM EDT	Friday,	10/20/2017	8:00	PM EDT	92	2.6.1
12	Thursday,	11/9/2017	8:00	PM EST	Sunday,	2/11/2018	8:00	PM EST	94	
13	Friday,	2/23/2018	8:00	PM EST	Sunday,	6/3/2018	8:00	PM EDT	100	2.6.1a
14	Friday,	6/15/2018	8:00	PM EDT	Sunday,	9/16/2018	8:00	PM EDT	93	
15	Friday,	9/21/2018	8:00	PM EDT	Sunday,	1/6/2019	8:00	PM EST	107	2.6.4
16	Friday,	1/18/2019	8:00	PM EST	Sunday,	5/12/2019	8:00	PM EDT	114	2.6.5

══════════════════════════════════════════════════════════════════════════════════════════════

*Patches were deployed before the following Season started.
**Necromancer Class introduced on Tuesday, July 27, 2017 with Patch 2.6.0

Yeah. As you can see (above), I’m getting the same result I got when I just pasted the document straight from Word. So, at this point, copying it into Excel seems like just an extra step.

I originally spelled everything out in that chart. Like for the date, instead of β€œ12/30/2016” I had β€œDecember 30, 2016”. I later started abbreviating after we got new server hardware and forum software.

To get that chart to fit on these forums I would probably have to abbreviate some more. Like β€œFriday” to β€œFri”. Even then, I’m not sure it would fit.

For that particular chart, it would be easier for me just to link to it. :wink:

Season Start Date End Days Ptch
1 Fri 8/29/2014 9:00 PM EDT Fri 2/3/2015 7:00 PM EST 158 2.1.0
2 Fri 2/13/2015 9:00 PM EST Sun 4/6/2015 12:00 AM EDT 51 2.1.2
3 Fri 4/10/2015 9:00 PM EDT Sun 8/23/2015 8:00 PM EDT 135 2.2.0
4 Fri 8/28/2015 8:00 PM EDT 2.3.0
Wed 12/30/2015 8:00 PM EST 124 2.4.0
5 Fri 1/15/2016 8:00 PM EDT Fri 4/15/2016 8:00 PM EST 91 2.4.1
6 Fri 4/29/2016 8:00 PM EDT Fri 7/22/2016 8:00 PM EDT 84 2.4.2
7 Fri 8/5/2016 8:00 PM EDT Fri 10/14/2016 8:00 PM EDT 70
8 Fri 10/21/2016 8:00 PM EDT Fri 12/30/2016 8:00 PM EST 70 2.4.3
9 Fri 1/6/2017 8:00 PM EST Fri 3/17/2017 8:00 PM EDT 70 2.5.0
10 Fri 3/31/2017 8:00 PM EST Fri 6/23/2017 8:00 PM EDT 84 2.6.0**
11 Thurs 7/20/2017 8:00 PM EDT Fri 10/20/2017 8:00 PM EDT 92 2.6.1
12 Thurs 11/9/2017 8:00 PM EST Sun 2/11/2018 8:00 PM EST 94
13 Fri 2/23/2018 8:00 PM EST Sun 6/3/2018 8:00 PM EDT 100 2.6.1a
14 Fri 6/15/2018 8:00 PM EDT Sun 9/16/2018 8:00 PM EDT 93
15 Fri 9/21/2018 8:00 PM EDT Sun 1/6/2019 8:00 PM EST 107 2.6.4
16 Fri 1/18/2019 8:00 PM EST Sun 5/12/2019 8:00 PM EDT 114 2.6.5

Take…how ever many

Season Start Date End Date Days Ptch
1 Fri 8/29/2014 21:00 EDT Fri 2/3/2015 19:00 EST 158 2.1.0
2 Fri 2/13/2015 21:00 EST Sun 4/6/2015 0:00 EDT 51 2.1.2
3 Fri 4/10/2015 21:00 EDT Sun 8/23/2015 20:00 EDT 135 2.2.0
4 Fri 8/28/2015 20:00 EDT 2.3.0
Wed 12/30/2015 20:00 EST 124 2.4.0
5 Fri 1/15/2016 20:00 EDT Fri 4/15/2016 20:00 EST 91 2.4.1
6 Fri 4/29/2016 20:00 EDT Fri 7/22/2016 20:00 EDT 84 2.4.2
7 Fri 8/5/2016 20:00 EDT Fri 10/14/2016 20:00 EDT 70
8 Fri 10/21/2016 20:00 EDT Fri 12/30/2016 20:00 EST 70 2.4.3
9 Fri 1/6/2017 20:00 EST Fri 3/17/2017 20:00 EDT 70 2.5.0
10 Fri 3/31/2017 20:00 EST Fri 6/23/2017 20:00 EDT 84 2.6.0**
11 Thurs 7/20/2017 20:00 EDT Fri 10/20/2017 20:00 EDT 92 2.6.1
12 Thurs 11/9/2017 20:00 EST Sun 2/11/2018 20:00 EST 94
13 Fri 2/23/2018 20:00 EST Sun 6/3/2018 20:00 EDT 100 2.6.1a
14 Fri 6/15/2018 20:00 EDT Sun 9/16/2018 20:00 EDT 93
15 Fri 9/21/2018 20:00 EDT Sun 1/6/2019 20:00 EST 107 2.6.4
16 Fri 1/18/2019 20:00 EST Sun 5/12/2019 20:00 EDT 114 2.6.5

Wow. You’re getting closer.

Try abbreviating times from β€œ8:00” to β€œ8”, etc. :wink:

What browser are you using. It displays correctly here. Mobile? I am on PC.

I’m on a PC running Firefox. It looks great, just a little cramped.

Edit: You know, the more I look at it, the better it looks. Fine just the way it is.

To clarify something, because I may be missing this…

You need to be at T3 to be able to post some of this in this formatted style?

I don’t think so. You only have to be TL2 or TL3 to embed videos, images and clickable links. But, even TL1 can post links to videos and images. You just have to paste the link in your post, select it and then click the </> button on the Reply Editor toolbar.

Like this: https://i.imgur.com/6PIA4Ul.jpg

This is the syntax:

`https://i.imgur.com/6PIA4Ul.jpg`

Check out the New Forum Guide - Syntax & Features

Last table looks good. It does horizontal scrolling for the width.

Samsung Galaxy S8 Active with Firefox.

1 Like

I haven’t really studied it at length. But, one mistake I notice is the row between Season 4 and Season 5. It is supposed to indicate a new Patch between Seasons and yet it’s showing β€œ124” days. The β€œ124” days should be in the row for Season 4. That may have just been typo when tweaking the formatting.

Edit: Sorry, DogBone. I wasn’t directing that at you. Just using your comment as a reference. :blush:

Edit 2: My apologies to @MissCheetah. There is no typo. The chart is correct. And excellent job by the way! :beer:

1 Like

That is not a typo. I did not actually adjust that in any way. You decided to have the season duration listed with the end of season date :slight_smile: Not my decision! This is how you formatted it. I literally just copied it. I added the headers, and shortened times and days. I left all the formatting intact.

I think your intent was to show that Season started with one patch, but ended with another.

You are absolutely right. I’m so sorry. :blush:

1 Like

I was referring to tables and layouts that you all were posting here. I knew that links and images required T2/T3. I just also knew that all of you are already set at T3 so wasn’t sure. lol

I know that. And I answered you:

To be clear: Trust Level 0 and above can post any HTML code as long as it’s supported in these forums.

The rest of my post was just explaining what you need TL2 and TL3 for. Which is: Embedding Videos, posting clickable links, embedding images and creating wikis.

Here are two excellent guides for most of the HTML codes you can use on these new forums:

Have fun! :partying_face: