04-08-2016, 05:21 AM
In case you wish to update the feature on the "Mafia Event Sheet" tab, I've fixed your Boss success % equation to more accurately reflect what is currently written on the IOU Wiki. Thus far (I've only checked it against the first two bosses), the formula on the IOU Wiki is correct. I've rewritten it slightly to be less cumbersome to write in a Google Doc sheet. My revised equation is: if($T$22="Test",if($T$23<F9,"Not enough power",MIN((($T$23-F9)/(F9*0.075)/100)+1/100,1)),if($Q$29<F9,"Not enough power!",MIN((($Q$29-F9)/(F9*0.075)/100)+1/100,1))). I added the MIN(boss success equation, 1) so that the spreadsheet will not return results > 100%. Also, it appears as though IOU's displayed success percentage is floored to remove decimal points (e.g. 27%, 27.3%, 27.69421%, etc. will all be displayed as a 27% success chance in IOU).