I've followed your instructions and I was wondering if you have found any problems when the added date is later than the last played date?
I have only just added an %added% tag to my music (using custominfo) and obviously since my playback stats existed before I added this tag my Days Since Added is negative. Every rating for every song that I've played in my library is 10000, no matter how many times I've played the song.
The excel spreadsheet returns what seem like realistic values for various songs. Could excels behaviour with negative numbers be different to foobars?
This is the modified rating formula I'm using (%play_counter% ---> %play_count% should be the only change)
$puts(ra,$add(1000,$div($mul(%length_seconds%,$sub(%play_count%,$div(%skip%,2))),100)))$puts(ra2,$mul($get(ra),10))$puts(dd,$div($add($cwb_datediff(%added%,%last_played%),50),10))$puts(pp,$div($mul(%play_count%,10000),$cwb_datediff(%added%,%cwb_systemdatetime%)))$puts(pd,$mul($get(dd),$get(pp)))$puts(pd2,$div($get(pd),100))$puts(pd3,$div($mul($cwb_datediff(%added%,%cwb_systemdatetime%),125),100))$puts(pd4,$div($get(pp),40))$puts(r1,$add($get(pd2),$get(ra2)))$puts(r2,$add($get(pd4),$sub($get(r1),$get(pd3))))$puts(r3,$ifgreater($cwb_datediff(%added%,%cwb_systemdatetime%),7,$get(r2),10000))$ifgreater(%play_count%,0,$num($get(r3),5),-----)