Reply to thread

Message

<blockquote data-quote="hafrogman" data-source="post: 5383999" data-attributes="member: 8858">This is actually a lot more difficult that it first appeared to me.&nbsp; The spreadsheet (and in some cases, GoogleDocs spreadsheets specifically) have a few issues that make it really difficult to recreate the Wiki format, or any other character sheet.&nbsp; There's a few smaller things, the refusal to format positive numbers as +x is an annoying one.&nbsp; Maybe just stylistic to me.The inability to create comma delineated lists is vaguely irritating, but could be gotten around with just retyping everything.&nbsp; Which, to be fair, is how the Wiki handles it.But the biggest issue is uncertainty.&nbsp; Since there is no way of knowing how many powers of each type each character will have, the summary sheet will need to be heavily customized each time it's used.&nbsp; Even the existing version would face severe issues with this past the first level.&nbsp; But add in a few more levels, powers and feats, and everything becomes a tangled mess of cell references, nested if() statements and massive abuse of the concatenate() function.It appears as is there may be a way forward using customized scripts, but I don't know anything about the programming format Google uses for them, or if they'd be able to do what we need.&nbsp; So this is as far as I can go.&nbsp; This is by no means a functional version:<a href="https://spreadsheets.google.com/ccc?key=0AjZWfCFa66hydGxadkREem0xaGVqLWhHT2R4ZG1VOWc&amp;hl=en&amp;authkey=COqtzOIH" target="_blank">Spreadsheet vX</a></blockquote>

[QUOTE="hafrogman, post: 5383999, member: 8858"] This is actually a lot more difficult that it first appeared to me. The spreadsheet (and in some cases, GoogleDocs spreadsheets specifically) have a few issues that make it really difficult to recreate the Wiki format, or any other character sheet. There's a few smaller things, the refusal to format positive numbers as +x is an annoying one. Maybe just stylistic to me. The inability to create comma delineated lists is vaguely irritating, but could be gotten around with just retyping everything. Which, to be fair, is how the Wiki handles it. But the biggest issue is uncertainty. Since there is no way of knowing how many powers of each type each character will have, the summary sheet will need to be heavily customized each time it's used. Even the existing version would face severe issues with this past the first level. But add in a few more levels, powers and feats, and everything becomes a tangled mess of cell references, nested if() statements and massive abuse of the concatenate() function. It appears as is there may be a way forward using customized scripts, but I don't know anything about the programming format Google uses for them, or if they'd be able to do what we need. So this is as far as I can go. This is by no means a functional version: [url=https://spreadsheets.google.com/ccc?key=0AjZWfCFa66hydGxadkREem0xaGVqLWhHT2R4ZG1VOWc&hl=en&authkey=COqtzOIH]Spreadsheet vX[/url] [/QUOTE]

Verification