Regarding the Monthly Tag Counts

[godsoffortune]

Regarding the Monthly Tag Counts



The Problem

What happened?
We had a problem with our automated process for calculating tag counts. The result was that we lost tag counts for about two weeks in the middle of September. We know this based on some timestamps.

How we tried to fix it
We reached out to Dreamwidth with a service ticket, citing the issue as a bug with unpaid accounts when their inboxes are maxed out. Unfortunately, they did not get back to us with a solution.

The Solution

For Mods: Process Change
The bug does not appear to affect paid accounts, so for now our solution is to keep our tracking account paid.

For Players: A September Event Bonus
As for tag counts themselves: September's tag counts will have an Event Bonus for all characters that were in the game that month. That Event Bonus is a complicated equation that, in short, is meant to be our best guess of what each character would have earned during the two-week down-time of our tag counting process. The Event Bonus is calculated in a similar way for all characters, as described below.

We started with trying to find a character’s average Total Comment Bonus, which includes both Network and Log totals but nothing else. We averaged October, September, and August when possible, and dropped October or August when it wasn’t available. For characters who were new in September, this was a strict average between October and September’s numbers, since the front half of September was more affected than the latter half, so of course new characters were less affected by the time they apped in. For all existing characters, we double-weighted September’s numbers when finding the average.

Once we had the Average, we took 30% of that number and rounded it up to the nearest whole integer (for Gods) or nearest 1 decimal place, or tenth of a digit (for Shinki). Then, we rounded up one more time - to the nearest multiple of 5 (for Gods) and the nearest multiple of 0.5 (for Shinki) - so that the final Event Bonus number is one that could have reasonably come from the normal tag count tallying.

The Calculation

Here is a sample for a Shinki that was apped prior to September.

Green is September's Total Comment Bonus getting the double-weight, Blue is finding the average, Red is doing the first round up, and Black is the final round up to a real Event Bonus number:

=CEILING(ROUNDUP(AVERAGE(vlookup($B66,'August 2018'!$B$2:$K$187,4,false),vlookup($B66,'October 2018'!$B$2:$K$187,4,false),E66*2)*0.3,1),0.5)

Here is the same calculation, but if it was for a God, with the changes bolded:

=CEILING(ROUNDUP(AVERAGE(vlookup($B66,'August 2018'!$B$2:$K$187,4,false),vlookup($B66,'October 2018'!$B$2:$K$187,4,false),E66*2)*0.3,0),5)

October Counts | September Counts | August Counts

We apologize for the delay and appreciate your understanding,
- The Far Shore Mods