NPC Tracker Spreadsheet

1 post / 0 new
Hailspork Hailspork's picture
NPC Tracker Spreadsheet
This is a tool I had put together for the EP game I'm running online. It's a spreadsheet that tracks certain combat stats of various NPC's; init, fray and weapon skills, damage, etc. The macros will keep track of current init, roll fray or either of two weapons for the current character, roll init (and sort the PC's in based on what they've rolled). The basic setup is anything with a colored background has a formula or is otherwise protected. White boxes are usually free to write in without causing problems to the system. Deleting characters is a little difficult (since there are protected cells sometimes in hidden columns), so I put three buttons on the right to help out. If you delete the names in column C and click the "Clear Nameless" button, all of those characters will be removed. When you roll init, it will clear all PC's as well. [url=https://docs.google.com/file/d/0B72NrfFOe_9NVVoxUDZyQjBienc/edit?usp=sha... is the file.[/url] I know the macros work on PC versions of Excel 2013 and probably Excel 2010. I don't think they'll work on older Excel, OpenOffice, or on Macs (I used ActiveX buttons). Let me know if you find any bugs or have any comments/questions.