View Single Post
Old 02-26-2019, 02:19 PM   #9
coronatiger
 
Join Date: Apr 2018
Location: Trondheim, Norway
Default Re: Excel Character Sheet

Quote:
Originally Posted by kenjames113 View Post
Have you thought about converting it to a google sheet?
Not really. There hasn't been a need for it in my gaming groups. But if it could be done easily, that would make it accessible to more people.

You made me curious, so I tried just now to open it as a Google Sheet from Google Drive, but it didn't work out, unfortunately. Without analyzing it in detail, the main problem (or at least the one that pops out at me) seems to be that many custom defined names got lost in translation, and that broke a lot of formulas and data validations.

If it had worked, that would have been great, but even if everything had looked all right, that wouldn't have meant that some bugs hadn't emerged. Thorough testing would be required.

Doing the project as a Google Sheet from the start might have worked better, but I'm far more experienced with Excel programming, so I didn't consider Google Sheet as a serious alternative.

The project is open source*, so if anyone wants to try a manual conversion or rebuilding it from scratch as a Google Sheet, they are welcome to do so**. Whenever I release a new version of the Character Sheet, the attached change log could be useful if the Google Sheet version is to be kept up to date.

* You need to unhide sheets, columns and rows, as well as opening the name manager, to find all the code.
** I'd appreciate it if my name and this thread are mentioned in the credits. Also, please remember to read SJGames' policy for player created content.

By the way, version 11.0 was released yesterday :)
__________________
You don't need to spend 100 CP on Status 5 [25] and Multimillionaire [75] to feel like a princess, when Delusion [-10] will do.

Character sheet: Google Drive link (See this thread for details.)

Campaign logs: Chaotic Pioneering / Confessions of a Forked Tongue
coronatiger is offline   Reply With Quote