Reply to thread

Message: <blockquote data-quote="AnotherCrappyDM" data-source="post: 7433356" data-attributes="member: 6807484">Automating magic items can be done with or without macros. The real problem is the volume of items. The CS has over 1000 items built in and many of them have unique properties. The manhours to put all these in are beyond my commitment to this. Also, without using macros, the number of formulas required would be immense and would lag excel with frequent recalculations.  The problem with using macros is (besides mobile/tablet compatibility) they have to be written very precisely to account for shifts in cell locations as the tool matures.  A formula in a cell will automatically update if columns/row are added/moved where as a macro can't update explicit cell references.  Compounding the issue.. magic items can be removed which means we'd have to set up change events in the macros and these would fire every time users made changes to specific areas of the workbook (inventory sheets, weapon/armor slots, gear slots) and have to check ALL of the magic items to figure out what to update (and we'd have to write all that scripting and update it with every major revision/publication.  TL;DR version - Implementing magic items is a messy proposition regardless of method.</blockquote>