Perusoe's Testing Grounds

I was referencing HTML5 Tutorial sample code. :disappointed_relieved:

Oh, cool! The details code could be used for spoilers.

Spoiler: Where are you?

I’m right here. :wink:

Yeah. I like that. (Oh course, there’s probably a code specifically for spoilers).

So, you want to make this easy on yourself? Make the tables in Excel and then just highlight and paste in here. It will auto format for you.

Just tested it for funsies seeing as it auto formats when you copy from json, so i thought excel might work too. It does. It assumes whatever your top line is, is the header and puts a bold line under it. The columns under that header are all auto aligned.

This took seconds.

WING TYPE LOCATION AVAILABLE Y/N
Test Here N
Test 2 There Y
Test 3 Whimsy Y
1 Like

Could you test that with cells that have left, center, and right alignment in both the header and data cells? I suspect it isn’t truly formatting it and is just using the default left alignment.

WING TYPE LOCATION AVAILABLE Y/N
Test Here N
Test 2 There Y
Test 3 Whimsy Y
WING TYPE LOCATION AVAILABLE Y/N
Test Here N
Test 2 There Y
Test 3 Whimsy Y
1 2 3 6

Oh my, it takes the plain text output of formulas too! How nifty. That bottom right is a basic SUM function.

Data Cells and Header cells formatted as requested and no, it does not function as a fancy editor that adds that level of formatting. It just grabs the basics and makes you a really easy table. Perfect for the basics and anyone can easily do it! Even me!

2 Likes

Cool. Very handy.

Look at the code, tables are in easy format.
You may change the alignment afterwards.

Since the software auto-adjust the column width based on the data length, you may want to manually break a long line.
You may do so, by inserting a <br> tag.

Yeah, I get to do it the hard way. :slight_smile:

<div align="center">
<h2><div align="center">HeadingName</div></h2>
<table>
<th><div align="center">Column 1</div></th>
<th><div align="center">Column 2</div></th>
<th><div align="center">Column 3</div></th>

<tr>
<td><div align="center"></div><br><a href="URLHere"><div align="center"><img src="URLHere"></a></div></td>
<td><div align="center"></div></td>
<td><div align="center"></div></td>

HeadingName

Column 1
Column 2
Column 3
SomeName Here

Some Stuff Here
More Stuff Here

Note: The first column’s name is lifted upward because the cell data expects an image below it. :stuck_out_tongue:

1 Like

So, this took about 2 minutes.

# Name Source
6 Blaze (Blazing Skull): Menagerist Goblin
7 Buddy (Fallen Hound): Menagerist Goblin
8 Bumble (Yeti): Menagerist Goblin
9 Charlotte (Spider): Menagerist Goblin
10 Cow King Pet: Menagerist Goblin
11 Friendly Gauntlet: Menagerist Goblin
12 Galthrak: Menagerist Goblin
13 Grunkk: Menagerist Goblin
14 Haunting Hannah (Ghost): Menagerist Goblin
15 Humbart Wessel (White Skull): Menagerist Goblin

All I had to do was take a text document and put a tab between the number and the name another tab between name and source. Copy from text to excel and it puts it right in columns for me. Copy from excel into forum. Done.

Thank you, MissCheetah. It appears to use what Maskraider calls the β€œEasy format”.

This is what the syntax looks like with the table you posted:

|WING TYPE |LOCATION|AVAILABLE Y/N|
|---|---|---|
|Test|Here|N|
|Test 2|There|Y|
|Test 3|Whimsy|Y|

Which produces this:

WING TYPE LOCATION AVAILABLE Y/N
Test Here N
Test 2 There Y
Test 3 Whimsy Y

You could further adjust the alignment by modifying the second line in the syntax. But, as we found out earlier, whatever alignment you set, it applies to all rows, including the header.

I still like that you can just type it out in Excel and copy/paste it here. :smile:

@Maskraider beat me to the post. :stuck_out_tongue:

1 Like

Yes! You can copy from a text doc into excel and then into here even. Let the software do all the work for you. For guides that is not ideal because those are fancy, but for most simple things people are used to excel. Just copy pasting and getting a use-able table is win win.

Same things happens if you copy paste from the json file. It puts it into easy format

Oh, now you’ve got me really curious…

Season Start End Days Patch*

1	Friday,	08/29/2014	9:00	PM EDT	Friday,	02/03/2015	7:00	PM EST	158	2.1.0
2	Friday,	02/13/2015	9:00	PM EST	Sunday,	04/06/2015	12:00	AM EDT	51	2.1.2
3	Friday,	04/10/2015	9:00	PM EDT	Sunday,	08/23/2015	8:00	PM EDT	135	2.2.0
4	Friday,	08/28/2015	8:00	PM EDT						2.3.0
					Wednesday,	12/30/2015	8:00	PM EST	124	2.4.0
5	Friday,	01/15/2016	8:00	PM EDT	Friday,	04/15/2016	8:00	PM EST	91	2.4.1
6	Friday,	04/29/2016	8:00	PM EDT	Friday,	07/22/2016	8:00	PM EDT	84	2.4.2
7	Friday,	08/05/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,	01/06/2017	8:00	PM EST	Friday,	03/17/2017	8:00	PM EDT	70	2.5.0
10	Friday,	03/31/2017	8:00	PM EST	Friday,	06/23/2017	8:00	PM EDT	84	2.6.0**
11	Thursday,	07/20/2017	8:00	PM EDT	Friday,	10/20/2017	8:00	PM EDT	92	2.6.1
12	Thursday,	11/09/2017	8:00	PM EST	Sunday,	02/11/2018	8:00	PM EST	94
13	Friday,	02/23/2018	8:00	PM EST	Sunday,	06/03/2018	8:00	PM EDT	100	2.6.1a
14	Friday,	06/15/2018	8:00	PM EDT	Sunday,	09/16/2018	8:00	PM EDT	93
15	Friday,	09/21/2018	8:00	PM EDT	Sunday,	01/06/2019	8:00	PM EST	107	2.6.4
16	Friday,	01/18/2019	8:00	PM EST	Sunday,	05/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

It was just a test

Well, that didn't work like I expected to. It was a copy/paste job of a Word document I created back in... I stopped in Season 16. But, it was an ongoing project since D3 was released.

I had to try it! I opened up the .txt of my Cosmetics post Nev sent me. Copy pasted a section. It did not put the source in a column. Then I realized that the thing separating number and name was a TAB. Added a TAB between the name and source, tried again, and it put everything into columns for me.

  1. TAB Name TAB Source

EDIT

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

I understand. I just wanted to see what copy/pasting directly from a Word document would produce. (Not plain text. Word-formatted text).

I copied some straight from your code box into Word then to Excel. It needs a bit of tweaking as something is off in the Word formatting, but overall it is an easy transition.

My take away is that anything already in a Word or .txt can be easily modified with TABS and copied to Excel then the forum. Makes for simple conversions of some of our TS/CS/Bug copy paste replies.

No problem. I now have two methods of making tables.

For long tables I’ll use the β€œAdvanced formatting”. This should be easy since I have a template to work with.

For shorter tables I’ll use the β€œEasy formatting”. This too will be easy thanks to your Excel information. :beer:

1 Like

That chart was probably too large for these forums anyway.

I try to keep it updated here: The Amazon Basin - Diablo III: Seasons.

No, it fits. I just was having trouble grabbing the whole text in the code box because of how it scrolls. It fits here just fine! I also see why it had the odd stuff between line 4 and 5, extra tabs. Did that patch mid season? I assume that is why they are on diff lines.

Oh, and D3 Resource also has a fantastic season tracker. Diablo 3 Seasons Overview

Yes. Patch 2.3.0 was deployed right after Season 4. Then, before Season 5 started they deployed Patch 2.4.0. At the end of Season 5 we got Patch 2.4.1.

Always. :wink:

I got to try this. I went back to The Amazon Basin and entered Edit mode to copy that chart. I’m going to paste it below and see what happens.

You might want to stand back in case I blow something up. :fireworks: :laughing:

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

Season Start End Days Patch*

1 Friday, 08/29/2014 9:00 PM EDT Friday, 02/03/2015 7:00 PM EST 158 2.1.0

2 Friday, 02/13/2015 9:00 PM EST Sunday, 04/06/2015 12:00 AM EDT 51 2.1.2

3 Friday, 04/10/2015 9:00 PM EDT Sunday, 08/23/2015 8:00 PM EDT 135 2.2.0

4 Friday, 08/28/2015 8:00 PM EDT 2.3.0

                                         Wednesday, 12/30/2015   8:00 PM EST   124     2.4.0

5 Friday, 01/15/2016 8:00 PM EST Friday, 04/15/2016 8:00 PM EDT 91 2.4.1

6 Friday, 04/29/2016 8:00 PM EDT Friday, 07/22/2016 8:00 PM EDT 84 2.4.2

7 Friday, 08/05/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, 01/06/2017 8:00 PM EST Friday, 03/17/2017 8:00 PM EDT 70 2.5.0

10 Friday, 03/31/2017 8:00 PM EDT Friday, 06/23/2017 8:00 PM EDT 84 2.6.0**

11 Thursday, 07/20/2017 8:00 PM EDT Friday, 10/20/2017 8:00 PM EDT 92 2.6.1

12 Thursday, 11/09/2017 8:00 PM EST Sunday, 02/11/2018 8:00 PM EST 94

13 Friday, 02/23/2018 8:00 PM EST Sunday, 06/03/2018 8:00 PM EDT 100 2.6.1a

14 Friday, 06/15/2018 8:00 PM EDT Sunday, 09/16/2018 8:00 PM EDT 93

15 Friday, 09/21/2018 8:00 PM EDT Sunday, 01/06/2019 8:00 PM EST 107 2.6.4

16 Friday, 01/18/2019 8:00 PM EST Sunday, 05/12/2019 8:00 PM EDT 114 2.6.5

17 Friday, 05/17/2019 8:00 PM EDT

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

*Patches were deployed before the following Season started.

**Necromancer Class introduced on Tuesday, July 27, 2017 with Patch 2.6.0

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

Well… that was a bust. I guess I’ll just stick to what I currently know. :sweat_smile: