yeah, i struggled with this, and i've dealt with it different ways in the past. i may regenerate it in this way. what i think i should do is give a blank whatever the max number was in the given ranking +1. so if a given list has 100 entries, then blanks get 101, etc.
i also struggled with excel for about an hour last night trying to make it calculate a reasonable MAD. unfortunately, the way excel deals with blanks when using formulas leaves something to be desired. i finally gave up, and am going to just export the data, calculate it myself in python or perl, and ingest the result into a new column. stoopid excel ><. i'll repost after i've made those two changes.
i also struggled with excel for about an hour last night trying to make it calculate a reasonable MAD. unfortunately, the way excel deals with blanks when using formulas leaves something to be desired. i finally gave up, and am going to just export the data, calculate it myself in python or perl, and ingest the result into a new column. stoopid excel ><. i'll repost after i've made those two changes.
Comment