Post by CWStra on Aug 18, 2016 16:27:07 GMT
Hello PbPers!
So, you all know HP's Fancy Sheet? Well, a while ago I made a modification to it that made roll templates for Trainer and Pokémon Moves. However, it was built into each page of the spreadsheet that had moves, which meant you had to move over to that version to use the roll templates.
NO MORE!
This new version has a separate page for all the roll template stuff, which means it's much easier to implement!
Usage guide
For the curious, here are a couple samples of the templates:
Default roll template:
Custom Blue:
Oh, and admins: feel free to move this thing if you know of a better place for it.
~Corin
1d20·1d8+11·2d8+17·1d20·2d8+26·4d8+36
So, you all know HP's Fancy Sheet? Well, a while ago I made a modification to it that made roll templates for Trainer and Pokémon Moves. However, it was built into each page of the spreadsheet that had moves, which meant you had to move over to that version to use the roll templates.
NO MORE!
This new version has a separate page for all the roll template stuff, which means it's much easier to implement!
Usage guide
For a brand new character, just go to the sheet, go to "File" up top, and select "Make a Copy..."!
For existing sheets:
1) Go to the sheet linked above
2) Right click on the bottom tab labelled "PbPF Roll Templates"
3) Click on the "Copy to..." Option
4) Choose your existing fancy sheet!
To use the roll templates for:
•Trainer Moves, type the name of your trainer combat page into the corresponding cell in the green section (Cell F2). Then copy the cell that corresponds to the move in question, somewhere in the range I10 to I32.
•Pokémon Moves, type the name of your Pokémon's page into the corresponding cell in the green section (Cell F4). Then copy the cell that corresponds to the move in question, somewhere in K10 to K20
There are also customization options:
•For Trainers, simply type the corresponding colors of choice into cells B2 through B7.
•For Pokémon, you can type the name of your Pokémon's page into the A column of a row of the yellow section, and then fill out the corresponding info into the rest of the row. Then, all roll templates for that Pokémon will be that color! There's also the Default row, which it'll... default to. Colors can be one of Proboards' names for colors or a hex code.
Other Notes:
For putting names in the Roll Templates, the code references the cells on the sheet: Cell A2 for the Trainer and Cell B1 for the 'mon. If you fill those in, it'll fill in the name automatically.
For existing sheets:
1) Go to the sheet linked above
2) Right click on the bottom tab labelled "PbPF Roll Templates"
3) Click on the "Copy to..." Option
4) Choose your existing fancy sheet!
To use the roll templates for:
•Trainer Moves, type the name of your trainer combat page into the corresponding cell in the green section (Cell F2). Then copy the cell that corresponds to the move in question, somewhere in the range I10 to I32.
•Pokémon Moves, type the name of your Pokémon's page into the corresponding cell in the green section (Cell F4). Then copy the cell that corresponds to the move in question, somewhere in K10 to K20
There are also customization options:
•For Trainers, simply type the corresponding colors of choice into cells B2 through B7.
•For Pokémon, you can type the name of your Pokémon's page into the A column of a row of the yellow section, and then fill out the corresponding info into the rest of the row. Then, all roll templates for that Pokémon will be that color! There's also the Default row, which it'll... default to. Colors can be one of Proboards' names for colors or a hex code.
Other Notes:
For putting names in the Roll Templates, the code references the cells on the sheet: Cell A2 for the Trainer and Cell B1 for the 'mon. If you fill those in, it'll fill in the name automatically.
For the curious, here are a couple samples of the templates:
Default roll template:
Steve used Struggle! | |
AC: | U7MVM_501d20+Accuracy Bonus ≥ 4 + Target Evasion |
Type: | Normal |
Frequency: | At-Will |
Damage: | 1d8+11 |
Crit: | 2d8+17 |
Damage Category: | Physical |
Range: | Melee, 1 Target |
Effects: | -- |
Custom Blue:
Dane Coley used Aura Sphere! | |
No Accuracy Check; Crit Check:1d20 | |
Type: | Fighting |
Frequency: | EOT |
Damage: | 2d8+26 |
Crit: | 4d8+36 |
Damage Category: | Special |
Range: | 8, 1 Target, Aura |
Effects: | Aura Sphere cannot miss. |
Oh, and admins: feel free to move this thing if you know of a better place for it.
~Corin
1d20·1d8+11·2d8+17·1d20·2d8+26·4d8+36