Reply to thread

Message

<blockquote data-quote="Criamon" data-source="post: 7232092" data-attributes="member: 6903648">Right now the issue with mine is that in trying to get all the lookup data right for career exploits it's really slowing the thing down as more careers get added.&nbsp; Also, adding a new race or career is kind of a pain in the ass.&nbsp; Not to mention right now you're limited to 5 careers.&nbsp; I was able to get this far without scripting (though an earlier version used scripts to manage named ranges).&nbsp;&nbsp; I just found a way to us INDIRECT() and UNIQUE() to fake it with smoke and mirrors.I really built it just so I could build characters fast.&nbsp; My new campaign is just starting up and hopefully it'll earn me back the time it took to get this far.I think my wishlist for what to do next with it is as follows:- Add a better instructions tab.- Add a script and button to automate saving a copy of the character under a different file name and pasting-to-values a lot of lookup data and jettisoning the unnecessary lookup tabs once that's done.&nbsp; That way you have a &quot;basic&quot; character sheet with all the stuff slowing it down gone.&nbsp; - Add tabs for inserting new races/careers and scripting the insertion of the data into the appropriate places.&nbsp; - Figuring out a way to script so as to make it possible for characters to have more (or less) career slots (not just five).&nbsp; This'd actually be pretty involved, but I think it can be done.&nbsp; Maybe it'd just be better to make slots for 10 or 12 careers and just leave the unused ones to sit idle, but it'd make the skills tab pretty onerous, since I'd have to add all the space for skills for all the careers, whether they're utilized or not. I've got a business trip next week - maybe I'll have time to tinker with it.&nbsp; But really I should concentrate on getting campaign launch ready.</blockquote>

[QUOTE="Criamon, post: 7232092, member: 6903648"] Right now the issue with mine is that in trying to get all the lookup data right for career exploits it's really slowing the thing down as more careers get added. Also, adding a new race or career is kind of a pain in the ass. Not to mention right now you're limited to 5 careers. I was able to get this far without scripting (though an earlier version used scripts to manage named ranges). I just found a way to us INDIRECT() and UNIQUE() to fake it with smoke and mirrors. I really built it just so I could build characters fast. My new campaign is just starting up and hopefully it'll earn me back the time it took to get this far. I think my wishlist for what to do next with it is as follows: - Add a better instructions tab. - Add a script and button to automate saving a copy of the character under a different file name and pasting-to-values a lot of lookup data and jettisoning the unnecessary lookup tabs once that's done. That way you have a "basic" character sheet with all the stuff slowing it down gone. - Add tabs for inserting new races/careers and scripting the insertion of the data into the appropriate places. - Figuring out a way to script so as to make it possible for characters to have more (or less) career slots (not just five). This'd actually be pretty involved, but I think it can be done. Maybe it'd just be better to make slots for 10 or 12 careers and just leave the unused ones to sit idle, but it'd make the skills tab pretty onerous, since I'd have to add all the space for skills for all the careers, whether they're utilized or not. I've got a business trip next week - maybe I'll have time to tinker with it. But really I should concentrate on getting campaign launch ready. [/QUOTE]

Verification