The Newbie Matrix6 stats thread (complete)

[tn5421]

I'm curious as to how the OP gathered his data.

Edit: inb4 unnecessary drama, I want to learn how he gathered this data so that I can learn how to do so myself.

[tn5421]

I'm curious as to how the OP gathered his data.

Edit: inb4 unnecessary drama, I want to learn how he gathered this data so that I can learn how to do so myself.

Why would that question cause drama?

The way I posted it originally could be construed as me insulting his data gathering ability and implying the data was inaccurate. So I edited to show that I really just want to learn to compile stats like he does.

[tn5421]

I skim over every Newbie game in progress and note when a replacement has occured (just by noting in the Excel file), and once a game has finished I fill in the rest (because even though who has died and what roles they have are public information, I want to stay on the safe side of mentioning ongoing games). Sometimes cross-referencing with the Newbie Queue is necessary if mods don't keep their playerlist in signup order with clear indication of who has which slot. Everything is then run through a bevy of tables and math, and the numbers just pop out.

I'm looking for the 'bevies of tables and math' bit, as well as where you cross-referenced your data.

Edit: How does your spreadsheet handle multiple replacements of the same slot?

[tn5421]

OpenOffice doesn't seem to render the spreadsheet math properly. Why don't you type a single R for every replacement and have the math count the number of characters in each cell? I'm running OpenOffice 4.0.1 and I don't have Microsoft Excel.

[tn5421]

Your formulas are specifically written for microsoft excel, correct?

[tn5421]

I went ahead and installed my copy of microsoft office finally out of sheer annoyance

[tn5421]

Weird. I'm using Office Excel 2010. Everything that has the green flag thing has the same error.
I'm downloading updates for it right now, since I forgot. Will update on whether or not this fixes the error I'm getting.

Edit: As far as I can tell, it has to do with IF($C32="T" aka the very start of the equation. MS Excel expects it to increment positively, but some parts increment negatively, or something like that. All of the errors simply say the formula is inconsistent with its surrounding formulas.

[tn5421]

So there isn't anything that is actually wrong then, right?

How can I contribute to keeping this spreadsheet up-to-date now that I can edit it without breaking formulas all over the place?

P.S. I have a dropbox account, if that's relevant. PM'd you my account, since I don't want it posted publicly.

[tn5421]

Dropbox does simple collaboration fairly easily for free users. You can 'share' folders or files with other dropbox users. All users can change files and files count against everyone's file storage space. If more than one edit is made within a short time frame, multiple versions of the file will be made.

Dropbox Sharing FAQ: https://www.dropbox.com/help/19/en




Edit: Removed in-progress game tabs.

Edit 2: I'm interested in helping with data entry, not making formulae.

[tn5421]

It's something to keep in mind if you decide not to keep updating this project.

[tn5421]

Town player replacements are at 37.2%. Town Newbie player replacements at 44.9%. Scum player replacements at 46.5%. Scum Newbie player replacements at 64.6%.

Oh my, that is a big gap. 9.3% for all players, and 19.7% for newbies. But newbtown replace out often enough to make risking a policy lynch on replacing out a bit dangerous.

[tn5421]

it's an official scumtell, tho

Getting permabanned from speakeasy is a lot more scummy than replacing out, I'd wager.

[tn5421]

Goon, Scum, VT, and Town are probably significant.

[tn5421]

Newbie 1658 was, in my opinion, a good example of how daytalk can really swing things.

http://forum.mafiascum.net/viewtopic.php?f=11&t=63709