
I enjoy making macros, and currently I am trying to make a macro for my GM that would allow him to get the capture value easily. I currently have the initial formula working perfectly (100 - (level * 2) + (value based on current health level)). The second portion (persistent, volatile, stuck, slow, injuries) I thought would be easy as it is just a matter of totaling the values from the check boxes since they are saved as either 1 or 0. ** Except that Frozen (st_froz) is saved as 'on' or 0. Since checked is recorded in text form, that ruins the formula. I solved this by replacing the check for the status with a query to the macro user with a drop box for 0 or 1. The final stage of the formula (evo stages and rarity) aren't an option as the sheet stands, so they will be completely query to the user based. ---- Not sure how to inquire directly to the sheet scripter, so I'd appreciate if someone that does were to direct them here (post that you will here first so we don't get a bunch of people bothering them). ---- What I'm asking for, if they could: 1) Adjust Frozen status (st_froz) to record being checked as a numerical 1 like the other statuses so it can work with a mathematical formula. 2) Consider adding a drop down menu for stages remaining (0, 1, 2) that is stored as a numerical value. 3) Consider adding a Legendary check box saved as 0 or 1 (near the status boxes would be handy since the variable needs to be 'created' before the macro can work). 4) Consider adding a Shiny check box, also saved as 0 or 1 and beside the Legendary check box. If the GM doesn't want their player to know if it is 'shiny', they can clear the box before giving the sheet to the player.