Difference between revisions of "User talk:Cem"

From The Coppermind
Jump to navigation Jump to search
m
Line 3: Line 3:
 
:It's nothing complicated, though it's a bit of boring work. I have all the books in ebook format. I just went and copied every POV in tWoK, one by one, to MS Word and got the word count from there. Then I dumped the word counts to Excel and let it make the calculations with few easy functions. Then I converted that to a wikitable using one of the online converters, and made some adjustments to make it prettier. All told, the whole process took an evening. I uploaded the Excel file [https://drive.google.com/file/d/0B326dy4dXmx6elFLUW4zQ2p2WTg/edit?usp=sharing here], if you want to take a look at it. I've thought about compiling the same sort of information for other books, but so far I haven't been able to muster enough motivation. I'll eventually get to it, but if anyone else wants to take a shot at it meanwhile, go ahead, I'd be happy to help. For improvements, I'm open to suggestions, can you clarify what you mean by "depth of dialogue/mentions?" --[[User:Cem|Cem]] ([[User talk:Cem|talk]]) 12:05, 13 January 2014 (UTC)
 
:It's nothing complicated, though it's a bit of boring work. I have all the books in ebook format. I just went and copied every POV in tWoK, one by one, to MS Word and got the word count from there. Then I dumped the word counts to Excel and let it make the calculations with few easy functions. Then I converted that to a wikitable using one of the online converters, and made some adjustments to make it prettier. All told, the whole process took an evening. I uploaded the Excel file [https://drive.google.com/file/d/0B326dy4dXmx6elFLUW4zQ2p2WTg/edit?usp=sharing here], if you want to take a look at it. I've thought about compiling the same sort of information for other books, but so far I haven't been able to muster enough motivation. I'll eventually get to it, but if anyone else wants to take a shot at it meanwhile, go ahead, I'd be happy to help. For improvements, I'm open to suggestions, can you clarify what you mean by "depth of dialogue/mentions?" --[[User:Cem|Cem]] ([[User talk:Cem|talk]]) 12:05, 13 January 2014 (UTC)
 
:: As in, counting how many words of dialogue each character has, or counting number of mentions/etc of different people.. Those are definitely more sizable tasks than your previous ones tho. I was just wondering out loud what other possibly interesting stats there might be thats all --[[User:Fbstj|Joe ST]] ([[User talk:Fbstj|talk]]) 12:10, 13 January 2014 (UTC)
 
:: As in, counting how many words of dialogue each character has, or counting number of mentions/etc of different people.. Those are definitely more sizable tasks than your previous ones tho. I was just wondering out loud what other possibly interesting stats there might be thats all --[[User:Fbstj|Joe ST]] ([[User talk:Fbstj|talk]]) 12:10, 13 January 2014 (UTC)
  +
  +
==Re: Elhokar's Shards==
  +
Pretty sure it's canon that they're Gavilar's. I was just talking about this over on 17S here: http://www.17thshard.com/forum/topic/5155-chapters-3-5-up-on-tor/?p=86235
  +
--[[user:FeatherWriter|FeatherWriter]]
  +
  +
PS: How do you guys do the signature with the timestamp and all? Bluh there's so much I don't know.

Revision as of 17:44, 16 January 2014

Statistical Analysis

Hey Cem, can I ask how you compiled your statistical analysis, I really like the stuff you've done and I think it would be awesome to be able to apply it to more of the books, or add extra information (like maybe to the depth of dialogue/mentions and stuff?) --Joe ST (talk) 11:25, 13 January 2014 (UTC)

It's nothing complicated, though it's a bit of boring work. I have all the books in ebook format. I just went and copied every POV in tWoK, one by one, to MS Word and got the word count from there. Then I dumped the word counts to Excel and let it make the calculations with few easy functions. Then I converted that to a wikitable using one of the online converters, and made some adjustments to make it prettier. All told, the whole process took an evening. I uploaded the Excel file here, if you want to take a look at it. I've thought about compiling the same sort of information for other books, but so far I haven't been able to muster enough motivation. I'll eventually get to it, but if anyone else wants to take a shot at it meanwhile, go ahead, I'd be happy to help. For improvements, I'm open to suggestions, can you clarify what you mean by "depth of dialogue/mentions?" --Cem (talk) 12:05, 13 January 2014 (UTC)
As in, counting how many words of dialogue each character has, or counting number of mentions/etc of different people.. Those are definitely more sizable tasks than your previous ones tho. I was just wondering out loud what other possibly interesting stats there might be thats all --Joe ST (talk) 12:10, 13 January 2014 (UTC)

Re: Elhokar's Shards

Pretty sure it's canon that they're Gavilar's. I was just talking about this over on 17S here: http://www.17thshard.com/forum/topic/5155-chapters-3-5-up-on-tor/?p=86235 --FeatherWriter

PS: How do you guys do the signature with the timestamp and all? Bluh there's so much I don't know.