Thread:Vae Victis/@comment-6042046-20130430224020/@comment-6042046-20130519012833

RS % for luck challenges: Rare Success % = #rare/(#succ+#rare) Okay, so for the two luck-based sheets, we should add columns B & D. Then D is divided by the result, and that's the answer to column E for RS % (after you move the decimal point two places & add the % symbol, yadayada). D/(B+D)=E

The first "Rare Success" sheet is even simpler since it doesn't have a failure column to complicate calculations. For that sheet, it should add columns B & C. Then C is divided by that result and we learn the RS. Same formula; different columns. C/(B+C)=D

For figuring out the success or failure %'s of luck challenges: Fortunate % = (#succ+#rare)/(#succ+#rare+#fail) Unfortunate % = #fail/(#succ+#rare+#fail) I have to go to dinner, so I'm deserting you guys for the next hour or two. Again, column substitution is used for these formulas. I wish I knew how to direct the spreadsheet to do it, but since I'm the doofus who couldn't insert rows earlier, you shouldn't be turning to me for technical help. :P