Recent content by Dysfunkt

The spreadsheet works that way too. You don't need to fill in the expected CR, that's just extra info people can use if they want whilst filling out the other fields. The calculation you refer to is at the bottom and based only on all the stats you fill out.

Updated my initial reply and uploaded file there.

Oh wait, I see what you mean there by round towards 0 instead of down. Maybe I missed something. Might not have had negative numbers in my calculations. Update: According to the internet the floor.math functions that were -1 should be ROUNDDOWN instead. Will remove uploaded file and fix...

Excel 2010, and yes that's just an example. That part's the part that doesn't need to be changed, just needed to show where the comma should be. The internet told me that the _xlfn functions were being replaced, but I didn't look too far into it. Just know excel 2010 doesn't like them. And...

floor function FLOOR function didn't get updated, still uses _xlfn If anyone wants to try using it and it hasn't been updated then it's just a few small edits to the formulas that show the error. When you change a field like Str to a different value #NAME? errors come up everywhere...