How do I estimate Strunk & White progress?

Question

Self-edits and retags don't count toward S&W. The former are easy to filter, but what about the latter?

#! /usr/bin/perl

use warnings;
use strict;

sub num_last_editor {
  my($id) = @_;
  open my $fh, "<", "posts.xml" or die "$0: open: $!";

  my $n;
  while (<$fh>) {
    ++$n if /\bPostTypeId="1"/         &&
            /\bLastEditorUserId="$id"/ &&
           !/\bOwnerUserId="$id"/;
  }

  $n;
}

die "Usage: $0 id-num\n" unless @ARGV == 1;

my $n = num_last_editor qr/\Q$ARGV[0]/;
print "$0: last editor on $n\n";

Answer 1

With the 2015 profile update, there is now a badge tracker on the Activity page of your profile.

On the badges overview at the top, you'll see a count of all your badges and a Next Badge section that tracks progress towards one of the badges you haven't earned. You can use this badge tracker to see how close you are to earning Strunk & White and Copy Editor. If neither badge are currently showing, click on the little gear icon to the right of the tracker:

You'll see a grid showing many of the badges you can earn and your current progress:

Selecting the badge will then allow you to track progress directly on your profile page.

Answer 2

I have added a translation to the live data using the Stack Exchange Data Explorer (SEDE):

How Many Edits Until Strunk & White

The code is:

DECLARE @UserId int = ##UserId##

SELECT 80 - COUNT(*) AS 'Edits To Strunk & White' FROM Posts
WHERE PostTypeId = 1
AND   LastEditorUserId = @UserId
AND   OwnerUserId != @UserId?

Answer 3

Disclaimer: The Data Explorer contains outdated data! Go to http://<your SE site>/review to see live info about the badge.

I've created a query loosely based on waffles' query here. It works by checking all the revisions you've made to titles and posts, grouping by the ID of the post. Multiple edits to a single post don't count. Note I've made it for Copy Editor rather than Strunk & White, but you can modify it easily.

Problems it avoids:

• Counting only the edits you've made that are also the last edit made (artlung's suffers from this)
• Counting title and post edits separately (which simply summing your changes in the PostHistory table would do even with grouping by the timestamp, since they can be off by milliseconds)
• Counting edits to your own posts
• Counting multiple edits to the same post

I'm rusty and this isn't my day job, note the crappy outer select :P. Code below if anyone wants to take a crack at improving it.

-- Copy Editor Progress
-- This query returns the number of edits you still need to
-- get the Copy Editor badge.

DECLARE @userid int = ##UserId##

SELECT 500 - COUNT(*) AS EditsLeft
FROM (
    SELECT   PostID
    FROM     PostHistory ph
    WHERE    PostHistoryTypeId IN (4,5)
        AND  PostId NOT IN (
            SELECT p.Id
            FROM   Posts p
            WHERE  p.OwnerUserId = ph.UserId
        )
        AND UserID = @userid
    GROUP BY PostID
) AS bar