Anyone have a tracking spreadsheet?


Capa_Devans

 

Posted

I just started working a bit with open office, but don't really know how to use it. I have so many toons now i gets hard to track who has what.
I was thinking of a spreadsheet or something similar to make it easier to track Amerits, Reward merits, AE tickets etc.

Anyone use anything like this?


Virtue: Sistah Powah, Afrodizziac, NeutronBlonde,Distortionist,IonMaiden,BlindFaith,M adwoman, Vital Signs,Yzzorrdrex,Diesel Mage, Defend, Glasshouse,Rescue I, Bootytrap, The Experience, AE Virus, Drawback, Daytime, Nighttime, Chamberwraith, Invincible Ink, Monster Mitts, Hex Object, Hexperiment, Frightningbolt, Spooky Deville, Scream Weaver, Cackler, Shocktopus, Ogrekill,Road Hazard,Fahrenhate,Duotherm,Black Lung, Horrorculturalist,Foulmouth,

 

Posted

Yes I do but it's all hand-inputted it's nothing fancy.

Just one sheet with different tabs.

Cash - chars that have a billion, chars that are collecting money (working to a billion) and chars that have bids/sales on the market and the date they were last checked

Set IOs in base - self explanatory, colour-coded for redside/blueside. I don't trace orange/yellow salvage specifics but they're all in one VG.

Merits - actually tracks which alpha is slotted or working towards, reward merits, AE tickets, alignment merits, recipies on hand waiting for crafting, accolades and whether they've done the weekly SF

TFC - which chars have done which SF/TF, midnighter arc, vanguard arc, costume, aura and cape if I remember those bits

Yes I am job hunting and have a lot of time on my hands.

It does mean that if I'm outfitting a char I know I have stuff on an alt that I need to craft and how much of a prospective build I can pull out of the bins and if I need to use merits/tickets which alt to hit first.





SAVE CoX info:
Titan Network efforts
Saving CoX events/FB info

 

Posted

Quote:
Originally Posted by Jawbreaker View Post
I was thinking of a spreadsheet or something similar to make it easier to track Amerits, Reward merits, AE tickets etc.
For something simple like this, I'd just create a table, something like this (mind you, this is excel, but I've not done anything that can't be done just as well in OOo):



Also, ditch OpenOffice. LibreOffice is the new name*.


* The full story is that Oracle, and before them Sun Microsystems, have simply done a horrible job at managing the project. LibreOffice is semi-forked from OpenOffice by the vast majority of the OpenOffice developers, and has a much more developer-friendly environment, such as not requiring the developers sign over their full copyrights for the express purpose of selling a closed source, competing product (i.e. StarOffice). Since the split, the number of developers contributing to LibreOffice has far surpassed the number that have ever contributed to OpenOffice. OpenOffice is basically a repeat of the XFree86 incident... the group controlling the project becomes so out of touch with the developers of the project, that the developers revolt and fork the project, which quickly replaces the original in pretty much every distribution channel.


Quote:
Originally Posted by ShadowNate
;_; ?!?! What the heck is wrong with you, my god, I have never been so confused in my life!

 

Posted

*offtopic

Re: Kitsune Knight's image

I feel bad for What's-His-Name. He owes somebody a Gumball, but Bob has 154! lol

On a side note, can I haz gumball? haha


 

Posted

Quote:
Originally Posted by Master-Blade View Post
I feel bad for What's-His-Name. He owes somebody a Gumball, but Bob has 154! lol
It's this kind of thing that makes me smile when reading the forums.


If we are to die, let us die like men. -- Patrick Cleburne
----------------------------------------------------------

The rule is that they must be loved. --Jayne Fynes-Clinton, Death of an Abandoned Dog

 

Posted

OP I think what you want is Steelclaw's spreadsheets


 

Posted

Quote:
Originally Posted by Emberly View Post
OP I think what you want is Steelclaw's spreadsheets
Oh? I tried a search, nothing came up. Where should I look?


Virtue: Sistah Powah, Afrodizziac, NeutronBlonde,Distortionist,IonMaiden,BlindFaith,M adwoman, Vital Signs,Yzzorrdrex,Diesel Mage, Defend, Glasshouse,Rescue I, Bootytrap, The Experience, AE Virus, Drawback, Daytime, Nighttime, Chamberwraith, Invincible Ink, Monster Mitts, Hex Object, Hexperiment, Frightningbolt, Spooky Deville, Scream Weaver, Cackler, Shocktopus, Ogrekill,Road Hazard,Fahrenhate,Duotherm,Black Lung, Horrorculturalist,Foulmouth,

 

Posted

Quote:
Originally Posted by Master-Blade View Post
I feel bad for What's-His-Name. He owes somebody a Gumball, but Bob has 154! lol
Bob has 154 Gum balls and he's only level 5?!? Twink!


 

Posted

Quote:
Originally Posted by TheUnnamedOne View Post
Bob has 154 Gum balls and he's only level 5?!? Twink!
He also has 150 Vanguard Merits. Explain that one!




Obviously the answer is that "Bob" works for Paragon and can do whatever the hell he wants with his characters!


Quote:
Originally Posted by ShadowNate
;_; ?!?! What the heck is wrong with you, my god, I have never been so confused in my life!

 

Posted

Quote:
Originally Posted by Kitsune Knight View Post
He also has 150 Vanguard Merits. Explain that one!




Obviously the answer is that "Bob" works for Paragon and can do whatever the hell he wants with his characters!
I'm more interested in his 3 A-Merits


 

Posted

Quote:
Originally Posted by Kitsune Knight View Post
He also has 150 Vanguard Merits. Explain that one!
Challenge Accepted!!


He's been leeching at rikti mothership raids with xp turned off. There's a bug where you can get the 10 vanguard merits reward when someone plants a bomb even if you don't have the Member of Vanguard Badge.


Global @StarGeek
ParagonWiki.com-The original is still the best!
My Hero Merit rolls
Accuracy needed for 95% ToHit spreadsheet
Forum font change stripper for Firefox/Opera/Chrome. No more dealing with poor color choices, weird fonts or microscopic text
Search Wiki Patch notes, add site:ParagonWiki.com inurl:patch_notes to your Google Search

 

Posted

I have a really basic one that tracks my characters, their powersets, servers, and levels. It's mostly for fun more than anything else.

I also made one recently for tracking Incarnate salvage that I can use to check things off as I get them and figure out what might be useful to run in order to get what I want. I've already gone ahead and prepped it for i20, even, especially since the loot lists for that are a real nightmare.


 

Posted

Quote:
Originally Posted by Kitsune Knight View Post
He also has 150 Vanguard Merits. Explain that one!
He was on teams that planted bombs during mothership raids. You get Vanguard Merits for that, even if you are not a Vanguard Member.

Edit:
Oops, I didn't notice StarGeek already mentioned that.

Quote:
Originally Posted by Chaos Creator View Post
I'm more interested in his 3 A-Merits
Maye he's really above level 20, but switched to a second build that he hasn't trained yet.

Ok.. now I'm really stretching. rofl


 

Posted

Quote:
Originally Posted by Jawbreaker View Post
I just started working a bit with open office, but don't really know how to use it. I have so many toons now i gets hard to track who has what.
I was thinking of a spreadsheet or something similar to make it easier to track Amerits, Reward merits, AE tickets etc.

Anyone use anything like this?
Have you checked out Herostats? Keep track of all of that stuff without actually having to do it manually.


 

Posted

Quote:
Originally Posted by LVConvert View Post
Have you checked out Herostats? Keep track of all of that stuff without actually having to do it manually.
Herostats tracks merits too?


Virtue: Sistah Powah, Afrodizziac, NeutronBlonde,Distortionist,IonMaiden,BlindFaith,M adwoman, Vital Signs,Yzzorrdrex,Diesel Mage, Defend, Glasshouse,Rescue I, Bootytrap, The Experience, AE Virus, Drawback, Daytime, Nighttime, Chamberwraith, Invincible Ink, Monster Mitts, Hex Object, Hexperiment, Frightningbolt, Spooky Deville, Scream Weaver, Cackler, Shocktopus, Ogrekill,Road Hazard,Fahrenhate,Duotherm,Black Lung, Horrorculturalist,Foulmouth,

 

Posted

Quote:
Originally Posted by Jawbreaker View Post
Herostats tracks merits too?
Haven't tried it, but it says it tracks dropped items, so I would think it does...