MPMB's Character Record Sheet (PDF form) + MPMB's Spell Sheets (Excel / PDF form)

**morepurplemorebetter** · Sunday, 3rd July, 2016, 08:22 PM

Originally Posted by Lezta

Love the sheet! Especially the printer friendly version.

Having a bit of trouble adding a spell though, I'm sure it's something tiny and obvious I'm missing. Would you mind taking a look at the script?

Code:

SpellsList["speak with stone"] + { //note the use of only lower case! The spelling here is used to identify the spell with. Also note the absence of the word "var" and the use of brackets []     
    name : "Speak With Stone", //Required; The name of the spell. This will be put in the Spell field on the Spell Sheet. Except, if a "nameShort" is present, this name will be put in the mouseover text (tooltip) of the Spell field on the Spell Sheet.
      
    classes : ["cleric"], //Required; Array of all the classes that have this spell on their list. Needs at least one entry. Even with one entry you still need to put the brackets around it []. note the use of only lower case!
     
    source : ["H", 0], //Required; The source of the feat; The "P" refers to the Player's Handbook; The number refers to the page. For material thats not from a known source, use ["H", 0]
     
    ritual : true, //Required; Whether (true) or not (false) this spell is a ritual
     
    level : 1, //Required; The Spell Level. Has to be a number from 0 to 9
     
    school : "Div", //Required; Spell School as it will show up on the Spell Sheet; Can only select from: "Abjur", "Conj", "Div", "Ench", "Evoc", "Illus", "Necro", "Trans"
     
    time : "1 a", //Required; Casting Time as it will show up on the Spell Sheet
     
    range : "Self", //Required; Spell Range as it will show up on the Spell Sheet
     
    components : "V,S", //Required; Components as they will show up on the Spell Sheet


    duration : "10 min", //Required; Spell Duration as it will show up on the Spell Sheet
     
    description : "Gain the ability to comprehend and verbally communicate with earth and stone telepathically.", //Required; Short Spell Description as it will show up on the Spell Sheet
     
}

Oh god, while reviewing your code I see that I made a huge mistake in the Syntax that I put on Dropbox. The "+" in the first line should actually be an "=". A simple typo that makes the whole code useless. When you change that it should work, sorry about the confusion. I have updated the Syntax on Dropbox as well.

**Nod_Hero** · Sunday, 3rd July, 2016, 10:29 PM

Originally Posted by morepurplemorebetter

Some fixes for the new versions and a new addition to the Spell Sheet Generator:

MPMB's Spell Sheet Generator v8.0 (1-7-2016) has the following changelog:

Added the WotC style headers as an option for the sheet

Not sure if it's something I did on my end but the WotC headers plus the "use checkboxes for spell slots" options isn't showing all the available spell slots. Set for letter sized, level 6 wizard it shows two boxes each for levels 1-3. I took a couple of pics;

Generator screenshot:
Name: generator.jpg
Views: 86
Size: 69.4 KB

Name: generator.jpg
Views: 86
Size: 69.4 KB

PDF screenshot:
Name: pdf.jpg
Views: 108
Size: 47.8 KB

**andargor** · Monday, 4th July, 2016, 03:05 AM

The new WotC style sheet looks good, scripts seem to work fine, and the file is much smaller (~5 MB). I do miss the following references that were on the magic items pages: exhaustion, conditions, and rules (actions). I found myself referring to them often during play.

Any chance to have a static page with these that can be toggled in the Layout menu?

**morepurplemorebetter** · Monday, 4th July, 2016, 12:55 PM

Originally Posted by Nod_Hero

Not sure if it's something I did on my end but the WotC headers plus the "use checkboxes for spell slots" options isn't showing all the available spell slots. Set for letter sized, level 6 wizard it shows two boxes each for levels 1-3. I took a couple of pics;

I am unable to recreate this issue, can you give me some more information on the software that you are using (i.e. which OS, version of Excel). And if you are using DPI scaling on your machine? It might also help if you could send the resulting pdf and excel (after generation).

**morepurplemorebetter** · Monday, 4th July, 2016, 09:41 PM

Originally Posted by andargor

The new WotC style sheet looks good, scripts seem to work fine, and the file is much smaller (~5 MB). I do miss the following references that were on the magic items pages: exhaustion, conditions, and rules (actions). I found myself referring to them often during play.

Any chance to have a static page with these that can be toggled in the Layout menu?

I has honestly originally planned on making a reference sheet addition to the Printer Friendly version (i.e. the WotC styled version). However, it is a LOT of work to correctly transcribe rules, put them in a nice lay-out, and make sure that everything fits pleasingly on a single page. There are a lot of reference sheets out there and none of them meet all my (arguably high) standards so I will have to make it from scratch. Some good suggestions are more than welcome, especially well-written, dense, comprehensibly transcribed rules.

**wagnert** · Tuesday, 5th July, 2016, 05:03 AM

I don't know if this can be done, but I am playing a High Elf Wizard Bladesinger. I gain proficiency in light armor and one melee weapon, but see no way to make that happen on the character sheet in the Defense or Attack areas on the first page. As a quick and dirty I manually click on proficient for my weapon.

**morepurplemorebetter** · Tuesday, 5th July, 2016, 10:28 AM

Originally Posted by wagnert

I don't know if this can be done, but I am playing a High Elf Wizard Bladesinger. I gain proficiency in light armor and one melee weapon, but see no way to make that happen on the character sheet in the Defense or Attack areas on the first page. As a quick and dirty I manually click on proficient for my weapon.

There is indeed no automation that asks you to input the melee weapon that you gain proficiency in, you are supposed to add it yourself to the list of "other weapons" in the proficiency section. As a High Elf Wizard this list is already extremely long and doesn't fit in the field. However, you should be able to edit that field and add any weapon you want at the end of the sentence, seperated with a comma.

For example, if you were to add the proficiency for "Maul", you would have to change the Other Weapons field from:
"Dagger, Dart, Light Crossbow, Longbow, Longsword, Quarterstaff, Shortbow, Shortsword, Sling"
to:
"Dagger, Dart, Light Crossbow, Longbow, Longsword, Quarterstaff, Shortbow, Shortsword, Sling, Maul"
You will then see the field update and put the weapons in alphabetical order, as well as update the tooltip. This means that it has recognized the proficiency. Now next time you enter "maul" in an attack

Of course, your solution to manually click proficient in the attack section works as well, and probably takes less effort. The attack section is the only place where the sheet looks for weapons proficiency, so either solution should work fine..

I hope you understand that this sheet is a hobby-project of mine and is in no way intended to be a fool-proof character generator. Making it fool-proof for all those exceptions such as the one you are describing is simply to (time-)exhausting.

**andargor** · Tuesday, 5th July, 2016, 03:56 PM

Originally Posted by morepurplemorebetter

I has honestly originally planned on making a reference sheet addition to the Printer Friendly version (i.e. the WotC styled version). However, it is a LOT of work to correctly transcribe rules, put them in a nice lay-out, and make sure that everything fits pleasingly on a single page. There are a lot of reference sheets out there and none of them meet all my (arguably high) standards so I will have to make it from scratch. Some good suggestions are more than welcome, especially well-written, dense, comprehensibly transcribed rules.

Hmm, OK I understand. We currently use these sheets, we can just keep a separate copy of them, but if they can inspire you here they are:

https://drive.google.com/file/d/0Byr...NuTHhHNXc/view

https://drive.google.com/file/d/0B2F...huakphRDQ/view

**Nod_Hero** · Wednesday, 6th July, 2016, 04:35 AM

Originally Posted by morepurplemorebetter

I am unable to recreate this issue, can you give me some more information on the software that you are using (i.e. which OS, version of Excel). And if you are using DPI scaling on your machine? It might also help if you could send the resulting pdf and excel (after generation).

Windows 10, Microsoft Excel 2010, and as I don't know what dpi scaling is probably not (or probably so if it's usually on by default...). The check boxes work fine with the dragon headers, it's only the wotc one that shows this problem.
I can't seem to attach the excel file so here's a link to my dropbox upload.
https://drive.google.com/open?id=0B6...250ZFVEN0huMUE
https://drive.google.com/open?id=0B6...nFKbTBZS3daRGc

**Arslan** · Wednesday, 6th July, 2016, 09:21 AM

Love the new WotC character sheet. but like andagor above I'm missing the exhaustion conditions. I'm working with some others on having critical hits give the characters exhaustion.

I realize its a fairly specialized request (so take it with a grain of salt

) but would it be possible to have exhaustion levels near the hit points on the first page? Perhaps like the circle bubbles for spell slots?

Great job on the sheets, you continue to impress!