Log in
This World
The forum has a new format for working on a revival - new everything if people decide that they want to start a new campaign.
* Alistair Theirin is the King and did the ritual with Morrigan to save Nygozy.
* The Cousland background is taken by Macha.* - don't know yet
* The elf background is taken by Calliara.
Latest topics
Character Compendium
+5
Calliara
Dragonis
Nygozy
Final Warrior
Macha
9 posters
Page 1 of 2
Page 1 of 2 • 1, 2
Character Compendium
I was bored, so I went through the character lists and made a quick list of statistics for the characters on the thread right now, in case anyone wants to have an at-a-glance overview of who and what we all play as.
If I got anything wrong, or if this thread should be moved to another forum, let me know!
At A Glance:
60 Characters
2 Beasts
Race
Human: 32
Dalish Elf: 8 (9 if counting Serethiel)
City Elf: 4 (5 if counting Desire)
Half-Elf: 3
Dwarf: 5
Qunari: 3
Other: 6 (Drake - Shifter, Serethiel - Spirit, Desire - Demon, The Shadow - Darkspawn, Arbiter - Darkspawn, Gerrick - Werewolf (Counted Twice, as Human and Werewolf))
Gender
Male: 36
Female: 24
Age
0-10: 0
11-20: 13
21-30: 31
31-40: 6
41-50: 3
51-60: 1
61-70: 0
71-80: 1
Unknown: 3
Ancient: 2
Class
Rogue: 20
Warrior: 23
Mage: 12
Other: 5 (3 Mage/Warrior, 1 Rogue/Warrior, 1 Hurlock Emissary)
In-Depth:
Akane - Human | Female | 18 | Rogue
Arbiter - Darkspawn/Hurlock | Male | Unknown | Mage/Emissary
Bowen - Human | Male | 36 | Warrior
Bryant - Human | Male | 26 | Mage/Warrior
Calliara - Dalish Elf | Female | 25 | Rogue
Caterina - Human | Female | 27 | Warrior
Cestrah - Human | Female | 15 | Rogue
Dartmoor - City Elf | Male | 20 | Rogue
Desire - City Elf/Demon | Female | 23/Ancient | Mage
Devin - Human | Male | 24 | Warrior
Drake - Human/Shifter | Male | 29 | Warrior
Elenri - City Elf | Male | Unknown | Mage
Emil - Human | Male | 23 | Rogue
Fletcher - Half-Elf | Male | 17 | Rogue
Fremelda - Human | Female | 24 | Rogue
Gareth - Human | Male | 25 | Warrior
Garoll - Dwarf | Male | 52 | Warrior
Gerrik - Human/Werewolf | Male | 35 | Warrior
Gunnar - Dwarf | Male | 40 | Warrior
Guremi - Qunari/Half-Qunari | Female | 24 | Warrior
Hikaru - City Elf | Female | 17 | Mage
Ianto - Human | Male | 28 | Warrior
Iauron - Dalish Elf | Male | 26 | Rogue
Jezarine - Dalish Elf | Female | 26 | Rogue
Kai - Dalish Elf | Male | 18 | Rogue
Kar - Human | Male | 27 | Mage
Kassina - Dalish Elf | Female | 19 | Mage
Kestrel - Half-Elf | Male | 30 | Warrior
Khael - Dwarf | Male | 16 | Rogue
Kiverius - Human/Lyrium Altered | Male | 74 | Rogue
Lithawen - Dalish Elf | Female | 22 | Mage/Warrior
Macha - Human | Female | 22 | Rogue/Warrior
Maddox - Human | Male | 35 | Warrior
Maghai - Dalish Elf | Male | 26 | Rogue
Marcus - City Elf | Male | 32 | Warrior
Margaid - Human | Female | 27 | Mage
Neria - Dalish Elf | Female | 19 | Mage
Nygozy - Dwarf | Female | 24 | Rogue
Ostef - Human | Male | 20 | Warrior
Pendra - Dwarf | Female | 42 | Warrior
Rakot - Human | Male | 26 | Warrior
Ralen - Human | Male | 29 | Warrior
Raphael - Human | Male | 26 | Mage/Warrior
Robert - Human | Male | 19 | Rogue
Roskio - Human | Female | 24 | Rogue
Royce - Human | Male | 25 | Rogue
Saarebas - Qunari | Female | 20 | Mage
Serethiel - Dalish Elf/Spirit | Female | 25/Ancient | Mage
The Shadow - Darkspawn/Hurlock | Male | Unknown | Rogue
Sinjan - Half-Elf | Male | 23 | Warrior
Sloane - Human | Female | 28 | Warrior
Sophia - Human | Female | 21 | Mage
Takara - Human | Female | 20 | Mage
Tamassran - Qunari | Male | 42 | Warrior
Tatsoo - Human | Female | 23 | Rogue
Tiberius - Human | Male | 42 | Warrior
Volk - Human | Male | 24 | Warrior
Will - Human | Female | 23 | Warrior
Wolfram - Human | Male | 35 | Mage
Zillam - Human/Possible Elven Ancestry | Male | 24 | Rogue
Fa’hallen - Halla | Female | Beast
Fenrir - Mabari | Male | Beast
*** Archived Characters :
At A Glance:
20 Characters
2 Beasts
Race
Human: 8
Dalish Elf: 4
City Elf: 3
Half-Elf: 1
Dwarf: 1
Other: 3 (2 Qunari/Kossith, 1 Drow)
Gender
Male: 14
Female: 6
Age
0-10: 0
11-20: 5
21-30: 8
31-40: 2
41-50: 1
51-60: 1
61-70: 2
71-80: 0
Unknown: 0
Ancient: 1
Class
Rogue: 4
Warrior: 7
Mage: 5
Other: 4 (2 Mage/Rogue, 1 Mage/Warrior, 1 Non-combatant)
In-Depth:
Aayugara - Human | Male | 25 | Warrior
Ashkaari - Qunari/Kossith | Male | 67 | N/A
Canus - Qunari/Kossith | Male | 28 | Mage/Rogue
Dice - Human | Male | 21 | Warrior
Faelni - City Elf | Female | 23 | Rogue
Harval - Dwarf | Male | 55 | Warrior
Kaine - Human | Male | 35 | Warrior
Kelsia - Human | Female | 35 | Warrior
Kilik - Half-Elf | Male | 22 | Warrior
Kitty - Dalish Elf | Female | 23 | Rogue
Kraven - Dalish Elf | Male | Ancient | Mage/Warrior
Kristoff - Human | Male | 13 | Mage/Rogue
Kyon - Dalish Elf | Male | 18 | Rogue
Medea - City Elf | Female | 20 | Mage
Orios - Human | Male | 42 | Warrior
Sarune - Human | Male | 20 | Mage
Sedah - Drow | Male | 17 | Rogue
Selene - Human | Female | 28 | Mage
Uthza - Dalish Elf | Male | 65 | Mage
Varen - City Elf | Female | 22 | Mage
Abraxus - Dragon | Male | Beast
Lobo - Fae | Male | Beast
If I got anything wrong, or if this thread should be moved to another forum, let me know!
At A Glance:
60 Characters
2 Beasts
Race
Human: 32
Dalish Elf: 8 (9 if counting Serethiel)
City Elf: 4 (5 if counting Desire)
Half-Elf: 3
Dwarf: 5
Qunari: 3
Other: 6 (Drake - Shifter, Serethiel - Spirit, Desire - Demon, The Shadow - Darkspawn, Arbiter - Darkspawn, Gerrick - Werewolf (Counted Twice, as Human and Werewolf))
Gender
Male: 36
Female: 24
Age
0-10: 0
11-20: 13
21-30: 31
31-40: 6
41-50: 3
51-60: 1
61-70: 0
71-80: 1
Unknown: 3
Ancient: 2
Class
Rogue: 20
Warrior: 23
Mage: 12
Other: 5 (3 Mage/Warrior, 1 Rogue/Warrior, 1 Hurlock Emissary)
In-Depth:
Akane - Human | Female | 18 | Rogue
Arbiter - Darkspawn/Hurlock | Male | Unknown | Mage/Emissary
Bowen - Human | Male | 36 | Warrior
Bryant - Human | Male | 26 | Mage/Warrior
Calliara - Dalish Elf | Female | 25 | Rogue
Caterina - Human | Female | 27 | Warrior
Cestrah - Human | Female | 15 | Rogue
Dartmoor - City Elf | Male | 20 | Rogue
Desire - City Elf/Demon | Female | 23/Ancient | Mage
Devin - Human | Male | 24 | Warrior
Drake - Human/Shifter | Male | 29 | Warrior
Elenri - City Elf | Male | Unknown | Mage
Emil - Human | Male | 23 | Rogue
Fletcher - Half-Elf | Male | 17 | Rogue
Fremelda - Human | Female | 24 | Rogue
Gareth - Human | Male | 25 | Warrior
Garoll - Dwarf | Male | 52 | Warrior
Gerrik - Human/Werewolf | Male | 35 | Warrior
Gunnar - Dwarf | Male | 40 | Warrior
Guremi - Qunari/Half-Qunari | Female | 24 | Warrior
Hikaru - City Elf | Female | 17 | Mage
Ianto - Human | Male | 28 | Warrior
Iauron - Dalish Elf | Male | 26 | Rogue
Jezarine - Dalish Elf | Female | 26 | Rogue
Kai - Dalish Elf | Male | 18 | Rogue
Kar - Human | Male | 27 | Mage
Kassina - Dalish Elf | Female | 19 | Mage
Kestrel - Half-Elf | Male | 30 | Warrior
Khael - Dwarf | Male | 16 | Rogue
Kiverius - Human/Lyrium Altered | Male | 74 | Rogue
Lithawen - Dalish Elf | Female | 22 | Mage/Warrior
Macha - Human | Female | 22 | Rogue/Warrior
Maddox - Human | Male | 35 | Warrior
Maghai - Dalish Elf | Male | 26 | Rogue
Marcus - City Elf | Male | 32 | Warrior
Margaid - Human | Female | 27 | Mage
Neria - Dalish Elf | Female | 19 | Mage
Nygozy - Dwarf | Female | 24 | Rogue
Ostef - Human | Male | 20 | Warrior
Pendra - Dwarf | Female | 42 | Warrior
Rakot - Human | Male | 26 | Warrior
Ralen - Human | Male | 29 | Warrior
Raphael - Human | Male | 26 | Mage/Warrior
Robert - Human | Male | 19 | Rogue
Roskio - Human | Female | 24 | Rogue
Royce - Human | Male | 25 | Rogue
Saarebas - Qunari | Female | 20 | Mage
Serethiel - Dalish Elf/Spirit | Female | 25/Ancient | Mage
The Shadow - Darkspawn/Hurlock | Male | Unknown | Rogue
Sinjan - Half-Elf | Male | 23 | Warrior
Sloane - Human | Female | 28 | Warrior
Sophia - Human | Female | 21 | Mage
Takara - Human | Female | 20 | Mage
Tamassran - Qunari | Male | 42 | Warrior
Tatsoo - Human | Female | 23 | Rogue
Tiberius - Human | Male | 42 | Warrior
Volk - Human | Male | 24 | Warrior
Will - Human | Female | 23 | Warrior
Wolfram - Human | Male | 35 | Mage
Zillam - Human/Possible Elven Ancestry | Male | 24 | Rogue
Fa’hallen - Halla | Female | Beast
Fenrir - Mabari | Male | Beast
*** Archived Characters :
At A Glance:
20 Characters
2 Beasts
Race
Human: 8
Dalish Elf: 4
City Elf: 3
Half-Elf: 1
Dwarf: 1
Other: 3 (2 Qunari/Kossith, 1 Drow)
Gender
Male: 14
Female: 6
Age
0-10: 0
11-20: 5
21-30: 8
31-40: 2
41-50: 1
51-60: 1
61-70: 2
71-80: 0
Unknown: 0
Ancient: 1
Class
Rogue: 4
Warrior: 7
Mage: 5
Other: 4 (2 Mage/Rogue, 1 Mage/Warrior, 1 Non-combatant)
In-Depth:
Aayugara - Human | Male | 25 | Warrior
Ashkaari - Qunari/Kossith | Male | 67 | N/A
Canus - Qunari/Kossith | Male | 28 | Mage/Rogue
Dice - Human | Male | 21 | Warrior
Faelni - City Elf | Female | 23 | Rogue
Harval - Dwarf | Male | 55 | Warrior
Kaine - Human | Male | 35 | Warrior
Kelsia - Human | Female | 35 | Warrior
Kilik - Half-Elf | Male | 22 | Warrior
Kitty - Dalish Elf | Female | 23 | Rogue
Kraven - Dalish Elf | Male | Ancient | Mage/Warrior
Kristoff - Human | Male | 13 | Mage/Rogue
Kyon - Dalish Elf | Male | 18 | Rogue
Medea - City Elf | Female | 20 | Mage
Orios - Human | Male | 42 | Warrior
Sarune - Human | Male | 20 | Mage
Sedah - Drow | Male | 17 | Rogue
Selene - Human | Female | 28 | Mage
Uthza - Dalish Elf | Male | 65 | Mage
Varen - City Elf | Female | 22 | Mage
Abraxus - Dragon | Male | Beast
Lobo - Fae | Male | Beast
Last edited by Macha on Mon May 28, 2012 11:59 pm; edited 1 time in total
Macha- Posts : 148
Join date : 2010-08-02
Re: Character Compendium
Yay *hugs*
Thank you for doing this out for everyone. I am quite sure it will be helpful for all the other players to know who is whom.
Thank you for doing this out for everyone. I am quite sure it will be helpful for all the other players to know who is whom.
Nygozy- Admin
- Posts : 1064
Join date : 2010-05-20
Age : 57
Re: Character Compendium
Final Warrior wrote:What sort order are you using for the In-Depth section?
-- Griffinhart
I really just went in the order that they appeared in the Characters section, which is out of order in a lot of places. I was going to go through and group them by player, but I lost track of some of the accounts and who they belonged to.
Hmm - I should put them in alphabetical order to make it easier to look up certain characters.
Edit: I alphabetized them. That way I don't have to go and try and find out join date or anything complicated like that.
Macha- Posts : 148
Join date : 2010-08-02
Re: Character Compendium
Alphabetical tends to be pretty sensible when you have a list of items starting with an alphabet character.
-- Griffinhart
-- Griffinhart
Re: Character Compendium
Wouldn't Sophia count as being Ancient? She just appears 21.
Dragonis- Posts : 651
Join date : 2010-05-20
Age : 34
Location : ON, Canada
Re: Character Compendium
Yes, I thought about it, but then I decided that I'd just go with whatever was on the character's actual profile – I wouldn't want to be giving away secrets that aren't mine to give away (even if it's fairly common knowledge). I'll (quite easily) change it if Mina would like me to, though~
Same goes for any other information that anyone wants m to fix for any other character.
Same goes for any other information that anyone wants m to fix for any other character.
Macha- Posts : 148
Join date : 2010-08-02
Re: Character Compendium
Final Warrior wrote:Alphabetical tends to be pretty sensible when you have a list of items starting with an alphabet character.
I could have established a veritable dewey decimal system, and arranged them by RP author and class type, but yes, the alphabetical order was kinder on my lazy brain.
It also made me realize that we have many, many characters whose names start with the letters "g," "m," and "r." I suppose those are the names that end up sounding the most fantasy-ish.
I also secretly called the "Archived Character" list the "list of names that start with K," since the greater majority of them are all "k" names.
Macha- Posts : 148
Join date : 2010-08-02
Re: Character Compendium
People tend to use names that start with strong letters or weird ones. That would explain the amount of 'k'. For me, I can say Calliara comes from a character of mine in D&D and Neverwinter Nights videogame (for the modded campaigns, not the official ones), Bowen comes from the main character in Dragonheart and Gunnar Karanir is the father of another character of mine (that I'm currently using in a personal Skyrim RP with my best friend). Fenrir... is just Fenrir xD I'm just into mithology lol
Calliara- Admin
- Posts : 812
Join date : 2010-05-20
Age : 39
Re: Character Compendium
TIL you are a Library Scientist.Macha wrote:I could have established a veritable dewey decimal system, and arranged them by RP author and class type, but yes, the alphabetical order was kinder on my lazy brain.
Me, I would've done alphabetical by surname (if one is given), then given (or stated) name.
Speaking of which, I spent forever looking for "Griffinhart" before it occurred to me to search for "Raphael". Sure says a lot about my relationship with him.Macha wrote:Same goes for any other information that anyone wants m to fix for any other character.
inb4 I start introducing girls named after swords from the Matter of FranceMacha wrote:I also secretly called the "Archived Character" list the "list of names that start with K," since the greater majority of them are all "k" names.
(I already have a Joyeuse and a Hauteclere, and I've used Almacia as a surname... pretty much the only ones I'll avoid are Curtana [because lol Halo] and Précieuse [because fuck Baligant].)
ETA: Also inb4 I use names from Arthurian mythology (why yes I do have a female Blaziken named Clarent and a male Aron named Arondight, u mad bruce?)
-- Griffinhart
Re: Character Compendium
I sent you an email from my cougarmadcat account, Macha. It has my lists. The first tab is almost updated except for the last three characters - Roskio, Fletch and Akane. The others are not updated to now. I was going to do that but haven't yet. I was working out teams for the missions that will be coming up.
Nygozy- Admin
- Posts : 1064
Join date : 2010-05-20
Age : 57
Re: Character Compendium
o3o If you sent me an e-mail, hon, I didn't get it [/kicks computer] Would PMing it to me be easier?
Macha- Posts : 148
Join date : 2010-08-02
Re: Character Compendium
Let's see if this works ok with the attachment.
- Attachments
Nygozy- Admin
- Posts : 1064
Join date : 2010-05-20
Age : 57
Re: Character Compendium
Wow! Awesome list - really organized [/hugs the list]
The only thing I noticed was that, in the Who Owns Who thing, you put Sophia under my characters – Sophie is Sophia's (Mina's). Otherwise, everything looks awesome.
The only thing I noticed was that, in the Who Owns Who thing, you put Sophia under my characters – Sophie is Sophia's (Mina's). Otherwise, everything looks awesome.
Macha- Posts : 148
Join date : 2010-08-02
Re: Character Compendium
Yeh I knew I messed up on at least one thing but yeh, it was a lot of work put into that. You're welcome
Nygozy- Admin
- Posts : 1064
Join date : 2010-05-20
Age : 57
Re: Character Compendium
Bowen's horse is Goliath, a black stallion.
Calliara- Admin
- Posts : 812
Join date : 2010-05-20
Age : 39
Re: Character Compendium
I am very tempted to update and maintain that sheet.
EVE OCD... tingling!
-- Griffinhart
EVE OCD... tingling!
-- Griffinhart
Re: Character Compendium
If you want to Final then go for it.
Nygozy- Admin
- Posts : 1064
Join date : 2010-05-20
Age : 57
Re: Character Compendium
Don't forget Sloane has a mabari named Sobaka!!
Kassina- Posts : 235
Join date : 2011-02-19
Age : 39
Location : Canada
Re: Character Compendium
https://docs.google.com/spreadsheet/ccc?key=0Ah0WLDaPZDLddG9SdUR5a3N5UnUwTHR3X0l6NkxzdWc
Still a WIP. If you need/want edit access, I'll need your email (PM it to me or something, don't [holy fuck I just spelled that as sond't, I am totally out of sorts] plaster it on a publicly-accessible forum), since I didn't want to make the sheet editable by anyone with the link.
I had an idea to calculate counts (e.g., warrior/rogue/mage counts, specialization counts, gender counts, etc.), but I'm too tired to be able to think it out perfectly straight, and I think it'll require a calculation subsheet.
(If you're interested: =IF(EXACT(column:row, "Warrior"), 1, 0) will return 1 if the text at column:row matches "Warrior", else it returns 0. So I could make a calculation subsheet that basically has a column of =IF(EXACT(column:row, "Warrior"), 1, 0), with the column corresponding to the Class column in the "Active" sheet. Then I could have a =SUM() entry on the Active sheet that sums up all of the 1's and 0's from that column of the calculation subsheet, and that would give a count of "Warrior" entries in the Class column.
I can do this for every text data column - for example, gender would be =IF(EXACT(column:row, "M"), 1, 0) and =IF(EXACT(column:row, "F"), 1, 0) for male and female, respectively, with "column" corresponding to the Gender column on the "Active" sheet. ["row" increments in a corresponding manner as well.]
I'm just not entirely sure if this works because I haven't done this, and Google Docs and my unorthodox web browser setup don't get along.)
ETA: Instructions: right, for those of you unfamiliar with GDocs' spreadsheets. If you want to sort the list alphabetically by character name, right-click on the Character column and select "Sort sheet A-> Z" (or "Z -> A" if you want it in reverse-alphabetical). If you want to sort by the date of creation, do the same on the Created column. (You can, in fact, reverse/alphabet sort the sheet by any of the columns.) This will actually modify the sheet for anyone who can view it though, so once you're done with looking at your pretty sort, it'd be nice if you'd be kind enough to re-sort by Created date.
-- Griffinhart
Still a WIP. If you need/want edit access, I'll need your email (PM it to me or something, don't [holy fuck I just spelled that as sond't, I am totally out of sorts] plaster it on a publicly-accessible forum), since I didn't want to make the sheet editable by anyone with the link.
I had an idea to calculate counts (e.g., warrior/rogue/mage counts, specialization counts, gender counts, etc.), but I'm too tired to be able to think it out perfectly straight, and I think it'll require a calculation subsheet.
(If you're interested: =IF(EXACT(column:row, "Warrior"), 1, 0) will return 1 if the text at column:row matches "Warrior", else it returns 0. So I could make a calculation subsheet that basically has a column of =IF(EXACT(column:row, "Warrior"), 1, 0), with the column corresponding to the Class column in the "Active" sheet. Then I could have a =SUM() entry on the Active sheet that sums up all of the 1's and 0's from that column of the calculation subsheet, and that would give a count of "Warrior" entries in the Class column.
I can do this for every text data column - for example, gender would be =IF(EXACT(column:row, "M"), 1, 0) and =IF(EXACT(column:row, "F"), 1, 0) for male and female, respectively, with "column" corresponding to the Gender column on the "Active" sheet. ["row" increments in a corresponding manner as well.]
I'm just not entirely sure if this works because I haven't done this, and Google Docs and my unorthodox web browser setup don't get along.)
ETA: Instructions: right, for those of you unfamiliar with GDocs' spreadsheets. If you want to sort the list alphabetically by character name, right-click on the Character column and select "Sort sheet A-> Z" (or "Z -> A" if you want it in reverse-alphabetical). If you want to sort by the date of creation, do the same on the Created column. (You can, in fact, reverse/alphabet sort the sheet by any of the columns.) This will actually modify the sheet for anyone who can view it though, so once you're done with looking at your pretty sort, it'd be nice if you'd be kind enough to re-sort by Created date.
-- Griffinhart
Last edited by Final Warrior on Wed Jun 06, 2012 1:20 pm; edited 1 time in total
Re: Character Compendium
[/stares into space]
You literally just took something I understand (Google Docs), and made it completely incomprehensible with your math/computer wizardry.
But the sheet looks great!
You literally just took something I understand (Google Docs), and made it completely incomprehensible with your math/computer wizardry.
But the sheet looks great!
Serethiel- Posts : 102
Join date : 2011-01-30
Re: Character Compendium
=SUM() is a pretty basic spreadsheet function (take the sum of the values in a given range), but I've never actually attempted anything as advanced ("advanced") as text-parsing (=EXACT(val1, val2)) or logical evaluation (=IF(test_func(), then_val, else_val)) (though I'd've been more surprised if the latter weren't a spreadsheet function).
The math functions are pretty expected though, most spreadsheet programs have them (since that's what spreadsheet programs were basically designed to do - have an array of input data, run calculations, get output data). I picked up most of my spreadsheeting skills from one semester of taking a physics lab course, hence why I'm not so hot at it. Probably would've been useful to know statistics, but I never had much of a mind (or care) for stats (at least, the typical sort of stats - probabilities, deviations, distributions, etc.).
ETA: OH HO HO HO. There is a =COUNTIF(range, criteria) function! If this works the way I think it does (and GDocs' help page says criteria can be a character string, so it probably does work the way I think it works), then I won't need to do anything as needlessly complicated as my previous idea!
ETA2: SUCCESS!
ETA3: Added Male, Female, Warrior, Rogue, Mage, and Warrior/Mage counts. Also calculated average age (=AVERAGE(E2:E63), much cleaner than =SUM(E2:E63)/(63-2)).
Hmm, wonder if I could calculate "days since creation" values for each character...
-- Griffinhart
The math functions are pretty expected though, most spreadsheet programs have them (since that's what spreadsheet programs were basically designed to do - have an array of input data, run calculations, get output data). I picked up most of my spreadsheeting skills from one semester of taking a physics lab course, hence why I'm not so hot at it. Probably would've been useful to know statistics, but I never had much of a mind (or care) for stats (at least, the typical sort of stats - probabilities, deviations, distributions, etc.).
ETA: OH HO HO HO. There is a =COUNTIF(range, criteria) function! If this works the way I think it does (and GDocs' help page says criteria can be a character string, so it probably does work the way I think it works), then I won't need to do anything as needlessly complicated as my previous idea!
ETA2: SUCCESS!
ETA3: Added Male, Female, Warrior, Rogue, Mage, and Warrior/Mage counts. Also calculated average age (=AVERAGE(E2:E63), much cleaner than =SUM(E2:E63)/(63-2)).
Hmm, wonder if I could calculate "days since creation" values for each character...
-- Griffinhart
Last edited by Final Warrior on Wed Jun 06, 2012 1:29 pm; edited 1 time in total
Re: Character Compendium
Do you suddenly speak klingon or is it just me, that I am utterly stupid?
Calliara- Admin
- Posts : 812
Join date : 2010-05-20
Age : 39
Re: Character Compendium
Calliara wrote:Do you suddenly speak klingon or is it just me, that I am utterly stupid?
You too, huh?
You and your computer wizardry. You can't fool me - that's magic and you know it.
Serethiel- Posts : 102
Join date : 2011-01-30
Re: Character Compendium
It's probably one half hilarious amounts of sleep deprivation, one half insomnia, two halves my body trying to kill me, and mostly my assumption that I'm not the only person who's ever used a spreadsheet program. Gotta crunch dem numbers, yo.
Though, a friend of mine has made much, much sexier sheets - he's got one that queries EVE Online's API (or maybe it was EVE-Central's?) to update prices for materials and then calculates the costs of construction certain items, and the potential revenue in selling said items at an assumed value.
Looks like magstabs are still selling at the best prices. I really need to get around to baking a set some time soon, I need the ISKies for a new battleship...
ETA: Ho ho! Added a"Days Since Creation" "Meta Age" column because I could. It's as simple as =(TODAY()-K#), where # is the corresponding row.
-- Griffinhart
Though, a friend of mine has made much, much sexier sheets - he's got one that queries EVE Online's API (or maybe it was EVE-Central's?) to update prices for materials and then calculates the costs of construction certain items, and the potential revenue in selling said items at an assumed value.
Looks like magstabs are still selling at the best prices. I really need to get around to baking a set some time soon, I need the ISKies for a new battleship...
ETA: Ho ho! Added a
-- Griffinhart
Last edited by Final Warrior on Wed Jun 06, 2012 1:43 pm; edited 1 time in total
Page 1 of 2 • 1, 2
Similar topics
» City of Heroes/Villains Screenshot Compendium
» If you were a DA character what class would you be?
» Character Sheet Template
» SHAPE OF...! (Margaid's Character Theme)
» If you were a DA character what class would you be?
» Character Sheet Template
» SHAPE OF...! (Margaid's Character Theme)
Page 1 of 2
Permissions in this forum:
You cannot reply to topics in this forum
Tue Feb 10, 2015 11:26 am by Damien Zeehem
» Super Quick Sketch of Badassery
Wed Aug 27, 2014 12:04 pm by Calliara
» WHO CAN STILL PLAY?
Mon Aug 04, 2014 3:10 pm by Calliara
» Damien - the unoriginal soundtrack
Mon Nov 04, 2013 12:51 pm by Damien Zeehem
» The dawn of new days
Tue Oct 08, 2013 3:50 pm by Damien Zeehem
» Dwelling of Tears - A Double Entendre
Wed Sep 18, 2013 10:48 pm by Macha
» So - Dragon Age 3
Sat Jun 22, 2013 11:54 am by Ianto
» MSN Failure (and Graduating!)
Wed May 29, 2013 10:41 pm by Final Warrior
» Happy birthday Dragonis !
Tue May 14, 2013 11:25 pm by Dragonis