@Jase:
Oh, teaser! I would suspect that whatever you're working on in regards to this would be an additive that lets me offload some of the work to RPOL rather than a replacement for what I've been doing with Sheets. Though... I won't rule out me being shocked and awed by it :)
@horus
Here's probably the best example, mostly for technique. I was learning what I was doing while I was making it, so it's a bit sloppy. It gets the job done, but it's not polished or anything.
https://goo.gl/R0tDVc
You'll note down the sheet that there's a theme. The left side is a generally open character sheet you fill stuff in. To the right, each line will get turned into a summary line or an X if there's nothing entered on the line and it doesn't need to be printed. Down around T79, things start to condense, then there's another condense step to make the "output" at A191.
The reason why I prefer Sheets over Excel or the open equivalents is that is has the JOIN and FILTER commands built in (you CAN do this in Excel, but you need to write VBA). For instance:
JOIN(", ",FILTER(V55:V120,NOT(V55:V120="X")))
This makes a comma delimited list out of all of the cells in the range V55:V120 that aren't equal to X (my placeholder for a cell that doesn't need to be printed). So ten skills in individual cells would become a single string with "Guns 4, Athletics 9, Jumping 12" or whatever.
Since the above is mostly useful for showing the Sheets side and produces something that does flip a lot of formatting around but DOESN'T really do pretty RPOL formatting, here's another example that does a
lot more with RPOL formatting. The big concepts are the same, but it does a lot more with formatting (including fun stuff like using LEN calculations to make sure the raw view of the output sheet aligns within tables).
https://goo.gl/uWgD3d
Once you're doing the level of stuff that's in the one above, adding in the dice rolling lines is not hard, though it might be a bit tedious.