FP Rank: Sorting algorithm for Twitter history needed

Description
<p style="color: rgb(85, 85, 85);background-color: rgb(255, 255, 255);"><span>Our current algorithm does not </span><span>work because the top tweets for @chrisamccoy have zero RTs and zero favs. </span><br/></p><p style="color: rgb(85, 85, 85);background-color: rgb(255, 255, 255);">If it doesn't work for @chrisamccoy, it doesn't work for @pmarca.</p><p style="color: rgb(85, 85, 85);background-color: rgb(255, 255, 255);">It needs to work for both.</p><p style="color: rgb(85, 85, 85);background-color: rgb(255, 255, 255);">CURRENT ALGORITHM</p><p style="color: rgb(85, 85, 85);background-color: rgb(255, 255, 255);">Summary: Algorithm calculates the difference in days, score and order. It calculates the difference in days between the data of the tweet and today's date. Score is the difference between retweet and favorited tweets. Order is a log value from Score rounded to 10 decimals. The final rank is calculated based on this formula Round(s * order + daysDIFF, 7)<br/></p><div style="color: rgb(34, 34, 34);background-color: rgb(255, 255, 255);">daysDIFF =Difference in days between today and the date of tweet</div><div style="color: rgb(34, 34, 34);background-color: rgb(255, 255, 255);">SCORE = retweet - fav</div><div style="color: rgb(34, 34, 34);background-color: rgb(255, 255, 255);"><div>order = WorksheetFunction.Log(<wbr/>WorksheetFunction.Max(Abs(<wbr/>SCORE), 1), 10)</div><div><br/></div><div>If order &gt; 0 Then</div><div>s = 1</div><div>ElseIf order = 0 Then</div><div>s = 0</div><div>ElseIf order &lt; 0 Then</div><div>s = -1</div><div>End If</div><div><br/></div><div><br/></div><div>HOTNEW = Round(s * order + daysDIFF, 7)</div><p>_______________</p><p style="color: rgb(85, 85, 85);background-color: rgb(255, 255, 255);">Files to work with:</p><p style="color: rgb(85, 85, 85);background-color: rgb(255, 255, 255);">@pmarca: https://dl.dropboxusercontent.com/u/13612299/Footprint/PmarcaAllTweets_v4%20%281%29.xlsx</p><p style="color: rgb(85, 85, 85);background-color: rgb(255, 255, 255);">@chrisamccoy: https://dl.dropboxusercontent.com/u/13612299/Footprint/chrisamccoyAllTweets_v2%20%281%29.xlsx</p></div><p style="color: rgb(85, 85, 85);background-color: rgb(255, 255, 255);"><span>_____________</span><br/></p><p style="color: rgb(85, 85, 85);background-color: rgb(255, 255, 255);">What to do (requirements)</p><div style="color: rgb(34, 34, 34);background-color: rgb(255, 255, 255);">1/ Builds on top of what we did  with the first algorithm.</div><div style="color: rgb(34, 34, 34);background-color: rgb(255, 255, 255);"><br/></div><div style="color: rgb(34, 34, 34);background-color: rgb(255, 255, 255);">2/ In your sorting algorithm, account for history. So older tweets that have favorites and likes are weighted higher than newer tweets with favorites and likes. </div><div style="color: rgb(34, 34, 34);background-color: rgb(255, 255, 255);"><br/></div><div style="color: rgb(34, 34, 34);background-color: rgb(255, 255, 255);">3/ Sorts all tweets by the hour of the day they were created and then based upon likes/favorites, normalizes for that. So if a tweet is sent at 2pm--a time when Twitter is inactive--but it gets popular, then that tweet would be worth more than the same tweet sent at 9pm, a time where Twitter is very active. </div><p style="color: rgb(85, 85, 85);background-color: rgb(255, 255, 255);"><br/></p><div style="color: rgb(34, 34, 34);background-color: rgb(255, 255, 255);">4/ Works for both my account (@chrisamccoy) and for Marc Andreessen (@pmarca).</div><div style="color: rgb(34, 34, 34);background-color: rgb(255, 255, 255);"><br/></div><div style="color: rgb(34, 34, 34);background-color: rgb(255, 255, 255);">5/ You do a short write-up explaining the<span class="Apple-converted-space"> </span><span class="il">algorithm</span>. </div><p style="color: rgb(85, 85, 85);background-color: rgb(255, 255, 255);">____________</p><div style="color: rgb(34, 34, 34);background-color: rgb(255, 255, 255);">Deliverable: Dropbox link to download @chrisamccoy and @pmarca databases with your new ranking algo applied as a sorting mechanism. </div><p style="color: rgb(85, 85, 85);background-color: rgb(255, 255, 255);"><br/></p><p style="color: rgb(85, 85, 85);background-color: rgb(255, 255, 255);">Call your algorithm FP-rank.</p><div style="color: rgb(34, 34, 34);background-color: rgb(255, 255, 255);"><br/></div><div style="color: rgb(34, 34, 34);background-color: rgb(255, 255, 255);">Then, a do a short write-up on the algorithm.</div><p style="color: rgb(85, 85, 85);background-color: rgb(255, 255, 255);"><br/></p><p style="color: rgb(85, 85, 85);background-color: rgb(255, 255, 255);">Marc Andreessen will see your work, too!</p>
Discussion
  • {{comment.username}}
Status
Active
submission(s) pending review
Bounty expires in
Bounty expired
Bounty
150
Tags
(no tags)