PDA

View Full Version : Excel Table Conversion Template



SirNibbles
2017-08-20, 03:19 PM
I'm sorry if this is the wrong section, but I thought this would be most useful here. I've written some very basic instructions for easily making tables in excel and having a template convert them to the table format for the forums. It takes 2 minutes to make the template and will save you time in the long run. Basically, you enter your information into something that looks like this (quite easy to read and modify):

http://i.imgur.com/4BK26Xk.png

and it converts it into this mess:

http://i.imgur.com/clHwlMm.png

which you simply copy and paste directly into the forum editor to get a nice table, without having to manually create it:


Spells Known
Level 0th 1st 2nd 3rd 4th 5th 6th 7th 8th 9th
1st 4 2
2nd 5 2
3rd 5 3
4th 6 3 1
5th 6 4 2
6th 7 4 2 1
7th 7 5 3 2
8th 8 5 3 2 1
9th 8 5 4 3 2
10th 9 5 4 3 2 1
11th 9 5 5 4 3 2
12th 9 5 5 4 3 2 1
13th 9 5 5 4 4 3 2
14th 9 5 5 4 4 3 2 1
15th 9 5 5 4 4 4 3 2
16th 9 5 5 4 4 4 3 2 1
17th 9 5 5 4 4 4 3 3 2
18th 9 5 5 4 4 4 3 3 2 1
19th 9 5 5 4 4 4 3 3 3 2
20th 9 5 5 4 4 4 3 3 3 3


_____

I'm sure many people already have custom setups for posting to GITP, but this is for those who don't and would like a simple way to make tables. If you like what you saw above, the instructions are below.

The first step is to create the template into which you enter the data: just type Level, 1st-20th, 0th-9th, and Spells Known into the correct shape. Then, mirror that with references, i.e. make a second table a bit to the right (or bottom) of the first, and simply reference the original. I just typed =B2 into O2 and then copied that all the way down, then all the way right, so that Y22 =L22, for example.

Next, type the following values into the following cells:
Q1:
(fix the spelling of table)
R1:
'
T1:
'

For N2-22, we'll just enter the value =' into the cells, and do =' for Z2-22.

The last steps are selecting the data field and changing the cell formats to the following:

""#"";""@""
changing the cell format of S2 (which should currently be displaying Spells Known due to the cell value of =C2) to:

"[CEeNTER]"@"[/CENTER]" (fix the spelling again, it automatically executes the formatting inside the CODE, which defeats the point of wrapping with CODE)
and setting the value of N23 to =
'

You can easily apply this to more complex tables for entire classes/class progressions with BAB, Saves, etc. The basic concept of using a duplicated data field and modified cell format to wrap the table formatting around your values is the same. If you're doing a class that doesn't have certain spell levels (for example, no 0ths or 9ths), just lower the colspan value, and use ctrl-select to avoid copying the parts you don't need.

If anyone has any trouble with replicating this table or modifying it for other tables, ask here or shoot me a PM and I'll happily answer.

Also, if anyone who already has a template made wants to share theirs, I'm sure people would appreciate it.

Edits:

Instead of setting the cell value to set colspan, you can use the horribly ugly cell format:

\[\T\D\=\"\c\o\l\s\p\a\n\:\1\0\"\]@"[/TD]"