How can I tell how much rep I lost to repcap in recent day(s)?

Question

How can I tell how much rep I lost to repcap in recent day(s)? (less than 1 week ago)

@rand al'thor asked me that in comments, and I was at a loss how to answer.

I know how much rep I got from the rep tracker dropdown for any recent day.

I know I can calculate my total (ever) rep loss using Data.stackexchange.com queries, except that this data is 1 week old so I can't use it on recent week's days.

Is there a decent not-too-labour-intensive way for me to answer that question for a day in this week?

Answer 1

You can get a figure for how much rep you lost to the repcap in 1 week, Sunday to Sunday, as follows:

• visit this page at Data.SE to find out what your rep would have been last Sunday, 20 Dec at around 3am UTC, if not for the rep cap; the answer is 219322 rep
• visit the same page again next week to get a corresponding figure for next Sunday, 27 Dec at around 3am UTC; EDIT: I've now done this and found a figure of 229752 rep
• subtract the two figures
• PROFIT!!!

DVK, you earned 10,000 rep in a single week between the 20th and 27th December. To quote @steelerfan: faints, then explodes!!!

Answer 2

When you repcap, your profile page's "reputation" activity still tracks your upvotes.

If you change to display the reputation by "post":

Then you'll see exactly how many votes you received for a given question, whether or not it added to your reputation total, and can quick tally that up in your head or with a calculator.

Using this last method, you can easily construct a spreadsheet to tabulate your totals.

If you expand all the "# events" listed, you can then copy and paste the entire day's activity into Excel or Google Sheets, starting in A1.

Then, in the last column you can use a formula such as:

=IF(AND(C2="upvote",ISBLANK(A2)),10,IF(AND(C2="upvote",MOD(A2,10)>0),10-MOD(A2,10),0))

This formula performs the following:

if(activity == "upvote" && reputation.isBlank()) {
 return 10;
}
else if (activity == "upvote" && reputation % 10 > 0) {
 return 10 - reputation % 10; 
}
else { return 0;}

The else if accounts for partial rep gain earned because of downvotes.

Then, you do a simple SUM() of that new column, and you get, for example, 1417 lost reputation for @DVK on 2015-12-21 UTC.

I confirmed that the formula I posted works in both Excel and Google Sheets, but I don't know if it works in OpenCalc/LibreCalc/Numbers.

Answer 3

Since I recently found myself with a whole mess of free time, I thought I'd take a stab at this. So I wrote a small webapp using the StackExchange API:

SE Rep Loss Calculator

It's still a work-in-progress, but it seems to more-or-less work for the time being. A few remarks and caveats:

• It's (in theory) somewhat of an improvement over the SEDE query in Rand al'thor's answer:

  • It's updated in real-time, so you don't have to worry about the SEDE update delay
  • It accounts for reputation lost from your votes, not just other people voting on your posts
  • It also accounts for reputation from non-vote sources: things like suggested edits, deleted posts, bounties, and so on

• Because it takes into account things like reputation gained/lost from you downvoting posts (which isn't visible to people other than you and SE employees), you need to log into the application with your SE credentials. I (meaning, the application) use the authentication protocol provided by the API, but I do request access to private information (it wouldn't work at all otherwise). I can't use this to impersonate you, or read your global inbox, but I can and do use it to look at basically your entire up- and down-voting history.

  Now, I (as myself, not the app) can't actually see any of this. All of the processing happens on your computer, so even if I wanted to save and inspect this information, I couldn't. The app is also open source, so you're welcome to take a look at the code to ensure that I'm not doing anything untoward with the access tokens. That said, it does require a little bit of trust. If you don't trust me, it is possible to run this application on your local computer, but it's a bit of a pain.

• Because of a bug I haven't quite figured out yet, the reputation counters don't reset every time you click the button; so if you want to re-calculate, you'll need to reload the page. I'm working on that.

• You also need to re-login on every page load, because I don't store the access token. I'm not sure if that's a bug or a feature.

• I'm running the app on a free Heroku account, so it may not be available 100% of the time. If it's not available when you want it, try again later

• Bear in mind that I'm limited to 10,000 API calls per day, and the number of calls per click grows quite substantially the longer your time period is, or the more reputation you gain per day¹. Be kind: don't spam the "calculate" button.

• I've done very little testing of this. It should work for most things, but there may be some weird edge cases I can't replicate

• If When you run into problems, kindly either post a comment here, or file a bug on GitHub and I'll look into it

---

¹ Every calculation takes at least two calls: one to authenticate you, and at least one to retrieve your reputation history. Because I can only retrieve up to 100 items with a single call, I may need lots of calls to get your entire reputation history.

In addition, in order to distinguish between votes on questions and votes on answers (which affect your rep in different ways), I need to ask the API for information on each post you've received rep for; again, I can only get up to 100 of these at a time (although I'm a little smart; I don't ask for the same post more than once), so receiving rep on more than 100 unique posts will cause more calls.