OOTP Developments Forums - View Single Post - Total amounts of cards that changed tiers in live update

allenciox · 08-10-2020, 08:15 PM

I added columns to the spreadsheet they published in the sticky at the top: newcol1=int(original rating/10), newcol2=int(new rating/10), and diff=newcol2-newcol1 (diff was either 0, 1, or -1) --- excluded players that were < 50 (so that I wouldn't count going from 50s to 40s or 40s to 50s) and then used subtotal excel function (which shows total # players non-filtered) for various filters applied to the data.

08-10-2020, 08:15 PM	#3
allenciox All Star Reserve Join Date: Dec 2015 Posts: 735	I added columns to the spreadsheet they published in the sticky at the top: newcol1=int(original rating/10), newcol2=int(new rating/10), and diff=newcol2-newcol1 (diff was either 0, 1, or -1) --- excluded players that were < 50 (so that I wouldn't count going from 50s to 40s or 40s to 50s) and then used subtotal excel function (which shows total # players non-filtered) for various filters applied to the data. __________________ Last edited by allenciox; 08-10-2020 at 08:18 PM.