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

**andargor** · Monday, 30th May, 2016, 04:31 AM

MPMB, what is the name of the array containing all limited features, if it's globally available? Also the names of the Notes and Character History fields? As I mentioned I have insufficient space for Limited Features and want to see if I can code up something to put the overflow elsewhere, a bit like you do for the Battle Master maneuvers.

**Astromath** · Monday, 30th May, 2016, 05:42 AM

I've created a new dragonborn PC using 11.4b [letter]. The breath weapon no longer appears in the limited feature section.

EDIT (instead of starting a new post)

I tried something with the equipment and it did not work. I was adding modified equipment and I did not know how much the equipment weighed, so I added the unmodified equipment to find out its weight. I was going to delete the line after I found out. But what happened is something I did not expect. See below.

Step 1: Type in modified equipment and leave the # and lb blank. Example: Drum crafted from a bear's skull
Step 2: Go to the equipment button and add the unmodified equipment in the same column as the modified equipment. Example: Drum

Expected behavior: Add a new line for the unmodified equipment with the proper entry for lb. field.
What actually happened: # field for the modified equipment increased by 1* and the lb. field was still empty.

* The # field was originally blank. Now it had a 2 in it.

EDIT 2

New suggestion: Linking the Faction field to the Faction Symbol so that if you type in the faction the faction's symbol will appear, or when adding the faction symbol, the faction's name will appear in the faction field.

**morepurplemorebetter** · Monday, 30th May, 2016, 09:49 AM

Originally Posted by Paragore

I love your character sheet, and have enjoyed how easy it is to quickly build a character with this sheet. One minor suggestion I have for the adventure log would be to add the option to change the date system. Instead of only allowing the; Day, Month, Year, date format I would appreciate the option of the; Month, Day, Year, date format.

Thank you! The date system is something I didn't even think about, putting the month first is just so illogical to me as nobody in Europe does that (except maybe the British). I think I will just change the Letter version to adhere to the (illogical) American system of Month Day, Year, as the Letter is only used by Americans anyway.

Originally Posted by andargor

MPMB, what is the name of the array containing all limited features, if it's globally available? Also the names of the Notes and Character History fields? As I mentioned I have insufficient space for Limited Features and want to see if I can code up something to put the overflow elsewhere, a bit like you do for the Battle Master maneuvers.

There is no global variable that stores the limited features, those are stored in the fields. You can query the field values with the "What()" function. However, when there is no more space available, any overflow will not be put into any field or any global variable. You would have to change the function "AddFeature()" to put the overflow anywhere. If you just want to move some stuff from the fields that are filled, than you can do that using the field names. For the different columns in the Limited Features section, the character history, and the notes, the field names are:

Feature: "Limited Feature 1"
Max Usages: "Limited Feature Max Usages 1"
Recovery: "Limited Feature Recovery 1"
Used: "Limited Feature Used 1"
Notes on the third page: "Extra.Notes"
Character History: "Background_History"

Where the number (1 in the example), indicates the row number

Originally Posted by Astromath

I've created a new dragonborn PC using 11.4b [letter]. The breath weapon no longer appears in the limited feature section.

EDIT (instead of starting a new post)

I tried something with the equipment and it did not work. I was adding modified equipment and I did not know how much the equipment weighed, so I added the unmodified equipment to find out its weight. I was going to delete the line after I found out. But what happened is something I did not expect. See below.

Step 1: Type in modified equipment and leave the # and lb blank. Example: Drum crafted from a bear's skull
Step 2: Go to the equipment button and add the unmodified equipment in the same column as the modified equipment. Example: Drum

Expected behavior: Add a new line for the unmodified equipment with the proper entry for lb. field.
What actually happened: # field for the modified equipment increased by 1* and the lb. field was still empty.

* The # field was originally blank. Now it had a 2 in it.

EDIT 2

New suggestion: Linking the Faction field to the Faction Symbol so that if you type in the faction the faction's symbol will appear, or when adding the faction symbol, the faction's name will appear in the faction field.

The breath weapon appears when you add the race, given that the level field is filled. If you first add the race and then change the level field to something other than 1, the racial limited features will be updated. I will fix it in the new version so that they will also be updated if you change the field to level 1.

The equipment addition that you describe is not very unexpected, but exactly as intended. The code looks through all the field to see if the equipment to add is found in the name of a row (even in only a part of the name of a row). Once it finds a match, it will add 1 to the # column. It will not change the weight, because that might be something the user has manually modified. In your example above, you 'modified' the weight to be empty. The sheet just assumes that that modification was intentional and that you don't want it overwritten.

Linking the Faction field to the Faction Symbol might be doable, but then I would have to make it a drop-down box that seemingly 'limits' the choices for people. I don't want people to feel they can only add the name of a Adventurers League faction. But I'll look into it.

**Astromath** · Monday, 30th May, 2016, 10:58 AM

For the Dragonborn. This is what I did. I added the Background first, then the race, then the class in that order.

For the equipment, I can understand how you coded it. But, I still believe that a "Drum" (unmodified) is different enough from "Drum crafted from a bear's skull" to warrant a separate line entry. I don't know enough about Java but can it compare the string lengths? In other words, compare the string length of "Drum" (which would equal 4) to the string length of "Drum crafted from a bear's skull" (which would be 32). If the string lengths are identical, increase the # field by one and go on. If the string lengths are not identical, add a new line.

For the Factions. I was trying to make the suggestion in such a way to avoid the drop-down box for the same reason you mentioned. But if you have to do it via a drop-down box, here is my suggestion on how you could do it. The drop-down box would have 6 items, 5 items of the names of the factions, and one item to be a blank line. Choosing the blank line would disable the linking routine.

Since you gave a way to modify the scripts, the sheet user can add to that drop-down box and link it to the symbols they came up with. That way, the user can home brew to their hearts content.

**morepurplemorebetter** · Monday, 30th May, 2016, 12:16 PM

Originally Posted by Astromath

For the Dragonborn. This is what I did. I added the Background first, then the race, then the class in that order.

For the equipment, I can understand how you coded it. But, I still believe that a "Drum" (unmodified) is different enough from "Drum crafted from a bear's skull" to warrant a separate line entry. I don't know enough about Java but can it compare the string lengths? In other words, compare the string length of "Drum" (which would equal 4) to the string length of "Drum crafted from a bear's skull" (which would be 32). If the string lengths are identical, increase the # field by one and go on. If the string lengths are not identical, add a new line.

For the Factions. I was trying to make the suggestion in such a way to avoid the drop-down box for the same reason you mentioned. But if you have to do it via a drop-down box, here is my suggestion on how you could do it. The drop-down box would have 6 items, 5 items of the names of the factions, and one item to be a blank line. Choosing the blank line would disable the linking routine.

Since you gave a way to modify the scripts, the sheet user can add to that drop-down box and link it to the symbols they came up with. That way, the user can home brew to their hearts content.

I can understand the difference between the drums, but having code that can understand the difference is very difficult. If you can show me a way how to code something that can see the relevant differences between the phrasing, then I might be able to implement it. But currently I don't have any way of doing this short of having it run through an online speech analysis that will take a lot of resources and time.

Comparing the string length (or just exact matches) wouldn't really work because what if there is a "- " in front of it? Or somebody made it a plural? Or somebody just likes the term "musical instrument, drum" better? Or would rather call it a "big drum", or "loud drum", or, with another example, likes "Pouch, with:" better than the default "Pouch", or "backpack" better than "Backpack, with:". There is simply too much variation to solve with a simple comparative piece of code like that. My code now searches for an exact match of the thing to be added, in the string of the field. So if part of the field name matches the equipment to be added, it will assume they are the same.

**Astromath** · Monday, 30th May, 2016, 01:19 PM

Didn't think of that. Since I don't know Java, I can't be of any help. Give me a couple of months to think about it and by then I probably will have forgotten about it (especially since it is something that probably wouldn't come up all that often).

**Astromath** · Monday, 30th May, 2016, 02:14 PM

I just thought of something. Each class has a quick build for those who don't want to take the time to create their own. Or do the quick build and modify as needed. Question: Would it be possible to put a button on the bar labeled "Quick Build" and have all those fields automatically filled in when toggled?

**Astromath** · Monday, 30th May, 2016, 03:35 PM

I was just looking over a generated spell sheet. Where you have "Spellcasting ability score" it should be "Spellcasting ability" (without the word "score"). By adding the word "score" I expect the ability score to be there, not the ability.

**morepurplemorebetter** · Monday, 30th May, 2016, 05:21 PM

Originally Posted by Astromath

I just thought of something. Each class has a quick build for those who don't want to take the time to create their own. Or do the quick build and modify as needed. Question: Would it be possible to put a button on the bar labeled "Quick Build" and have all those fields automatically filled in when toggled?

Of course it can be done. The big question is, is it something that a lot of people would want and use? It is another feature that would take quite a bit of time to make and that I believe doesn't really at [I]that[/] much to the whole. The major thing that the 'quick build' does is make suggestions where to put your highest ability score (something that is hard to automate), and it selects a background. The background selection is just as much work as clicking which quick build you want, so I am not really convinced that this would be a time-saver.

Originally Posted by Astromath

I was just looking over a generated spell sheet. Where you have "Spellcasting ability score" it should be "Spellcasting ability" (without the word "score"). By adding the word "score" I expect the ability score to be there, not the ability.

You are absolutely right. It is something that I overlooked when creating the spell sheet additions and that I had my eye on changing since. However, it is a fair amount of work because of how well I hid all the fields (I will have to change 10 of those manually and will have to move each one to get to the next). So it is something on my to-do list, but no promises on when it'll be done