Can I see your spreadsheet?

[Bionic_Flea]

On 10/4/2024 at 2:44 PM, Frozen Burn said:

My Excel Workbook may make people's head explode. 

 

[RikOz]

I just have individual spreadsheets for the ATs I play, to keep track of which PS combos I've already used and avoid duplicates. Here's my brute sheet:

 

 

I have spreadsheets for blasters, brutes, scrappers, sentinels and stalkers, the ATs I play most often. Some of them need a bit of updating to take into account some new PSs and some PS proliferation

[Apogee]

18 minutes ago, RikOz said:

I just have individual spreadsheets for the ATs I play, to keep track of which PS combos I've already used and avoid duplicates. Here's my brute sheet:

 

 

I have spreadsheets for blasters, brutes, scrappers, sentinels and stalkers, the ATs I play most often. Some of them need a bit of updating to take into account some new PSs and some PS proliferation

 

Dude, you need to start a Savage/Bio! 

 

[RikOz]

2 hours ago, Apogee said:

 

Dude, you need to start a Savage/Bio! 

 

Oh, I will, eventually. I'm currently at 140 alts, and I've slowed down a bit on rolling new ones while I focus on getting the existing ones to 50, and getting my existing 50s incarnated out :)

[Icono04]

My main spreadsheet is very similar to the one in @lobster's second post in this thread. So similar that I won't even bother posting a screenie of it here.  The columns are in a different order, and I use a few more columns to track things things like reward merits, Empyreans etc,, but that is minor details. There are also a bunch of subsheets for various details and calculations, but the main sheet is what I use 98% of the time.

 

One thing that makes me curious: Looking at all the spreadsheets that people have generously shared in this thread, I notice that none of you use the Filter function in the headings line. I do, and I use it A LOT. It helps me search for subsets of characters, e.g. if I want to see only scrappers, or only villains, or only chars that don't have the TFC accolade, or whatever it might be. Who else uses the Filter tool in their spreadsheet?

[Hedgefund]

I use filters, you can see the ones I was using at the moment I took the screen snippet (4th post in this thread).  Without querying I personally wouldn't even see the value of having a spreadsheet at all.

Edited October 9 by Hedgefund

[Maelwys]

10 hours ago, Hedgefund said:

Without querying I personally wouldn't even see the value of having a spreadsheet at all.

Over the years I've definitely used Spreadsheets far more often for "pretty looking data manipulation" than for maintaining sortable lists of things.

There are a lot of use cases for a crayola-inspired splash screen which can perform a large number of recalculations based on you changing one of more input values; and Spreadsheets can accomplish that without you having to resort to breaking out a full compiler + spending half a day just writing the initial frontend (assuming that you even know how to code in the first place). Spreadsheets are also portable and tweakable in realtime in exactly the same way that source code isn't.

They're not a patch on a proper relational database mind you (although I've seen them used for that too; and almost always badly) but I'd still prefer a well-built spreadsheet to anything created in the sticky lukewarm mess that is Microsoft Access 🤮

[RikOz]

I just made a new one, that is possibly rather pointless, and mostly to satisfy my own curiosity. I used to occasionally run Ephram Sha's repeatable missions and choose the "Huge Inspiration" reward, and I started to notice that I received "Furious Rage" (damage) more often than anything else, with "Back in the Fight" (endurance) seemingly the next most common. And some seemed scarce as hen's teeth. It occurred to me that the different inspirations might be weighted differently in the RNG algorithm, but my sample size was too small for my observation to mean anything. So I started seriously farming. I mean, not non-stop farming; I just made a point of having my characters who happen to be running DA content do a round of four repeatable missions each time I logged them in, and keep track of which inspirations they were awarded. I kept track in a plain text file, but decided to stick the numbers into a spreadsheet ... because a pie chart would be fun.

 

I'm currently up to 1,404 Huge inspirations collected and recorded (small margin of error, since I'm surely forgotten to record a few here and there). 1,404 is still small in the grand RNG scheme of things, but it partly confirmed my suspicions, and definitely shows a trend in how things are weighted.

 

 

The damage insp is definitely out in front, but endurance is in third place, slightly behind health. I'm rather appalled that Liberate is the most rare, behind Ultimate.

[mistagoat]

 

On 10/10/2024 at 7:35 PM, RikOz said:

I just made a new one, that is possibly rather pointless, and mostly to satisfy my own curiosity. I used to occasionally run Ephram Sha's repeatable missions and choose the "Huge Inspiration" reward, and I started to notice that I received "Furious Rage" (damage) more often than anything else, with "Back in the Fight" (endurance) seemingly the next most common. And some seemed scarce as hen's teeth. It occurred to me that the different inspirations might be weighted differently in the RNG algorithm, but my sample size was too small for my observation to mean anything. So I started seriously farming. I mean, not non-stop farming; I just made a point of having my characters who happen to be running DA content do a round of four repeatable missions each time I logged them in, and keep track of which inspirations they were awarded. I kept track in a plain text file, but decided to stick the numbers into a spreadsheet ... because a pie chart would be fun.

 

I'm currently up to 1,404 Huge inspirations collected and recorded (small margin of error, since I'm surely forgotten to record a few here and there). 1,404 is still small in the grand RNG scheme of things, but it partly confirmed my suspicions, and definitely shows a trend in how things are weighted.

 

 

The damage insp is definitely out in front, but endurance is in third place, slightly behind health. I'm rather appalled that Liberate is the most rare, behind Ultimate.

That's some top shelf data! I love the commitment and the pie chart was indeed, fun!

Edited October 14 by mistagoat

[mistagoat]

Over the weekend I added a page to track my beloved Rad Tanks!

 

[shortguy on indom]

• MINE ARE MOSTLY NOT FOR HUMAN CONSUMPTION DUE TO THE MATH.
• THIS ONE IS JUST FOR REFERENCE.
• WHEN I'M PUTTING SPREADSHEET TOGETHER, HELPS ME LEARN.

 

[Yomo Kimyata]

I won't share my spreadsheets since I am embarrassed by their appearance.

 

However, my scrapper breakdown by primary/secondary to figure out where to put the Critical Strike proc is bueno.

[tidge]

On 10/10/2024 at 11:35 PM, RikOz said:

 

The damage insp is definitely out in front, but endurance is in third place, slightly behind health. I'm rather appalled that Liberate is the most rare, behind Ultimate.

 

Definitely looks like something approaching an 8:3:1 weighting. (or if you prefer  2/2/2/2 : 1/1/1 : 0.5/0.5)

 

I like that this data appears to show a couple of things that I strongly suspect about the pseudo-RNG:

• The pseudo-RNG populates the result space flatly between the end-points of its result space. (A true random number generator wouldn't have such even-looking results)
• The pseudo-RNG very likely has a slight, but observable bias at the end-points of its result space.

The second point is confounded because I don't actually know what the probability endpoints are. This is, is the range inclusive of 0 <-> 1, or does one/both of those endpoints actually "close but not exactly 0 or 1".

 

From this one study, I would lay odds that Liberates are a result at one end of the probability space and that Furious Rages are at the other. This is a relatively small sample size so there isn't a lot of power to back it up, but I think the confidence in that result is pretty high.

 

I can think of a couple reasons why this would happen:

1. The probability space isn't inclusive of one end, but is inclusive of the opposite end.
2. There is a subtle theoretical under-pinning of the RNG relating to scale-invariance (I propose this partially because of a scale-invariate priors treat zero, but IIRC there are other subtle factors with prior choices that manifest at endpoints)

 

[UltraAlt]

On 10/2/2024 at 2:35 PM, mistagoat said:

I look forward to seeing what you've done!

 

This is the spreadsheet that I made for Homecoming. The images are reposts from a while back.

The spreadsheet that I had before the Sunset was in created in Open.

 

 

 

 

never take off the mask

[shortguy on indom]

• MORE NUMBERS.
•  

[Logansan]

Excel spreadsheets are like side quests....

 

I have one badge workbook for each server with the following sheets - iTrials, Specials, Events, Task-Strike Forces, Trials, Day Jobs. Each column been a individual character. I also have a MS Word document to record what Incarnate powers each character has, that is currently at 207 pages.

 

I should also make a spreadsheet for character names, AT and power sets. I currently record this information in text document and I've been too lazy to improve it.

Each time I want to create a new character I copy and paste the list into excel as data to work out which combination I haven't try yet. And each time I do create a new character I always think "I should save this workbook", but for some reason I never do.

 

[Seldom]

My updated post-ToT Alt tracker spreadsheet! (Names redacted)

AT	Primary	Secondary	Level	Fully Incarnated	Finished build	Page #	Alignment
Dominator	Mind Control	Psionic Assault	50	✓	✓	1	Rogue
Dominator	Fire Control	Fiery Assault	50	✓	✓	1	Vigilante
Dominator	Plant Control	Martial Assault	50	✓	✓	1	Vigilante
Dominator	Gravity Control	Dark Assault	50	✓	✓	1	Rogue
Dominator	Illusion Control	Earth Assault	50	✓	✓	1	Vigilante
Dominator	Ice Control	Savage Assault	47	X	X	1	Vigilante
Dominator	Symphony Control	Sonic Assault	50	✓	✓	1	Vigilante
Dominator	Arsenal Control	Psionic Assault	29	X	X	1	Hero
Dominator	Earth Control	Electric assault	25	X	X	1	Hero
Controller	Illusion Control	Time Manipulation	50	✓	✓	2	Vigilante
Controller	Electric Control	Kinetics	50	✓	✓	2	Vigilante
Controller	Fire Control	Radiation Emission	50	✓	✓	2	Villain
Controller	Darkness Control	Empathy	50	✓	✓	2	Vigilante
Controller	Symphony Control	Electrical Affinity	50	X	X	2	Villain
Tanker	Bio Armor	Radiation Melee	50	✓	✓	3	Hero
Tanker	Ice Armor	Staff Fighting	50	✓	✓	3	Hero
Tanker	Radiation Armor	Street Justice	50	✓	✓	3	Rogue
Tanker	Willpower	War Mace	50	✓	✓	3	Hero
Tanker	Super reflexes	Super Strength	32	X	X	3	Hero
Tanker	Invulnerability	Stone Melee	25	X	X	3	Vigilante
Corruptor	Radiation Blast	Radiation Emission	50	✓	✓	4	Hero
Corruptor	Sonic Attack	Poison	50	✓	✓	4	Villain
Corruptor	Pain Domination	Assault Rifle	50	✓	✓	4	Vigilante
Corruptor	Radiation Blast	Electrical Affinity	35	X	X	4	Rogue
Corruptor	Energy Blast	Trick arrow	25	X	X	4	Villain
Corruptor	Seismic Blast	Trick arrow	25	X	X	4	Vigilante
Corruptor	Psychic Blast	Sonic Resonance	25	X	X	4	Hero
Corruptor	Fire Blast	Marine Affinity	29	X	X	4	Vigilante
Brute	Electrical Melee	Regeneration	50	✓	✓	5	Vigilante
Brute	Broadsward	Dark Armor	50	✓	✓	5	Vigilante
Brute	Titan Weapons	Energy Aura	50	✓	✓	5	Villain
Brute	Psychic Melee	Shield Defense	38	X	X	5	Vigilante
Brute	Spines	Stone Armor	32	X	X	5	Hero
Defender	Force Field	Electrical Blast	50	✓	✓	6	Villain
Defender	Traps	Sonic Attack	50	✓	✓	6	Hero
Defender	Nature Affinity	Ice Blast	50	✓	✓	6	Hero
Defender	Dark Miasma	Psychic Blast	50	✓	✓	6	Hero
Defender	Poison	Water Blast	40	✓	✓	6	Hero
Defender	Thermal Radiation	Beam Rifle	28	X	X	6	Rogue
Blaster	Dual Pistols	Devices	50	✓	✓	7	Hero
Blaster	Psychic Blast	Plant Manipulation	50	✓	✓	7	Vigilante
Blaster	Archery	Energy Manipulation	50	✓	✓	7	Hero
Blaster	Sonic Attack	Sonic Manipulation	40	X	X	7	Villain
Blaster	Archery	Tactical Arrow	36	X	X	7	Rogue
Blaster	Water Blast	Temporal Manipulation	25	X	X	7	Vigilante
Blaster	Seismic Blast	Fire Manipulation	30	X	X	7	Vigilante
Arachnos soldier/Bane	Bane Spider Soldier	Bane Spider Training	50	✓	✓	8	Villain
Arachnos soldier/Crab	Crab Spider Soldier	Crab Spider Training	50	✓	✓	8	Vigilante
Arachnos widow/Fortunata	Fortunata Training	Fortunata Teamwork	50	✓	✓	8	Rogue
Warshade	Umbral Blast	Umbral Aura	50	✓	✓	8	Hero
Peacebringer	Luminous Blast	Luminous Aura	50	✓	✓	8	Hero
Arachnos widow/Night widow	Night Widow Training	Widow Teamwork	27	X	X	8	Rogue
Arachnos soldier/Crab	Crab Spider Soldier	Crab Spider Training	28	X	X	8	Vigilante
Sentinel	Fire Blast	Radiation Armor	50	✓	✓	9	Hero
Sentinel	Storm Blast	Electrical Armor	50	✓	✓	9	Vigilante
Sentinel	Dark Blast	Dark Armor	50	✓	✓	9	Villain
Sentinel	Water Blast	Bio Armor	37	X	X	9	Hero
Scrapper	Energy Melee	Darl Armor	50	✓	✓	10	Vigilante
Scrapper	Fire Melee	Electrical Armor	50	X	✓	10	Rogue
Scrapper	Ice Melee	Stone Armor	29	X	X	10	Vigilante
Scrapper	Battle Axe	Shield defense	26	X	X	10	Hero
Scrapper	Street Justice	Radiation Armor	25	X	X	10	Vigilante
Scrapper	electrical melee	Super reflexes	30	X	X	10	Hero
Mastermind	Demon Summoning	Cold Domination	50	✓	✓	11	Hero
Mastermind	Necromancy	Nature Affinity	50	✓	✓	11	Villain
Mastermind	Robotics	Dark Miasma	50	✓	✓	11	Rogue
Mastermind	Beast Mastery	Sonic Resonance	50	X	X	11	Vigilante
Mastermind	Thugs	Time Manipulation	38	X	X	11	Villain
Mastermind	Beast Mastery	Kinetics	28	X	X	11	Villain
Stalker	Dual Blades	Ninjitsu	50	✓	✓	12	Hero
Stalker	Savage Melee	Fire Armor	50	✓	✓	12	Rogue
Stalker	Martial Arts	Super Reflexes	26	X	X	12	Vigilante
Stalker	Energy melee	Invulnerability	25	X	X	12	Vigilante
Stalker	Dark Melee	Bio Armor	25	X	X	12	Rogue

 

 

Edited November 6 by Seldom

[Monsoon]

This is what I've got on the primary tab of my spreadsheet.  It started out just as tracking accolade completion progress, and kinda grew from there.

 

(Deleted old screen shot, replacing with one that omits character names)

 

 

The character's name (not included for an attempt at privacy), then their AT, Primary, Secondary, and Sex (I'm one of those guys who likes to play female characters purely for the visuals, and it amuses me to see what percentage are female).  The date they were created, the date they hit 50 (if applicable) and how many days in between.  Their level and veteran level, then if they've got a proper IO build slotted (with sets and such, not just common IO's or SO's),  Then come the Accolades; TFC, Atlas Medallion, FP Reserve, and Portal Jockey.  Followed by their Market Crash completion status and Patron Pool unlock status.  Then the three WST's (rotates based on math done in another tab of the document) and whether they're high enough to run them and if they've already run it that week.  Then their Incarnate powers, either a percentage to show how far they've come in the unlock or a T# to indicate which tier is slotted.  And finally a list of the various fast travel powers and how much inf I need to send to the character so they can grab them all.

Edited November 12 by Monsoon

[shortguy on indom]

• NOW THAT THERE IS A DEWEY DECIMAL SYSTEM.

[Tacheyon]

Wow!  I love making spreadsheets...at work.  For me i can usually remember what combos I have made and enjoyed.  Anything else well I just log into that character if I want.

 

I have a "rule" (although more like guideline 😁) if I have to start making spreadsheets or doing "work" to keep track of stuff, the game is no longer relaxing and I leave it, not that i could really leave COH/COV.  But you understand what I am getting at.

 

Although these are amazing pieces of art in their own right.  That's really what I wanted to say.

[WanderingAries]

HOLY SHEET PEOPLE!!!

 

I'd never get to play (when I actually played) had I gone nearly this far. 😛  That's why I liked CoH Faces back then. Shame we don't have something like that now (that I'm aware of).

[mistagoat]

22 hours ago, Monsoon said:

Then the three WST's (rotates based on math done in another tab of the document) and whether they're high enough to run them and if they've already run it that week. 

That is very clever! Nice!

I love that your "time to 50" ranges from 3 days to over 1800 days! Gives me hope for that blaster I made 2 Halloween events ago that I got to 25 and haven't touched since lol

[Skywise]

I think I may be the ultimate nerd here.  I was an electrical engineer during my career, but you do a lot of things over time and one I did for 20 years or so was coding databases for quality and productivity control stuff, graphics, databases, etc...  When I retired, I dove into COH like I couldn't while working, although I played on live since beta until shutdown.  I'm also an altaholic and hated not remembering all my toons from live so I made a spreadsheet which grew over the past few years of playing until now it has about 13 tabs, 20 summary graphs, full data and breakdowns on pareto of powers, offline days, number of badges, fun ratings (my own thing), origins, SGs, ATs, ...  well, you get the idea.  Someone above said that if they needed aa spreadsheet to remember everything then they weren't having fun.  Truthfully, I do like keeping track of my many alts.  I write bios for every one, and role play them as I play.  And when I logoff a toon I update their sheet.  That's what makes this the greatest game in the world for me.  You can play it however you want.  

 

Only thing about my spreadsheet is it has gotten so massive it's a pain to add new columns without messing up all the many interlocked calculations so I'm thinking of changing it to a relational database.  Anyone have a good one for example?  I haven't coded dbs in 20 years so going to have to do some brushing up for sure.

[lemming]

2 hours ago, Skywise said:

Only thing about my spreadsheet is it has gotten so massive it's a pain to add new columns without messing up all the many interlocked calculations so I'm thinking of changing it to a relational database.  Anyone have a good one for example?  I haven't coded dbs in 20 years so going to have to do some brushing up for sure.

Heh.   I started looking into that myself due to complexities of my own sheets.  (haven't found what I want to work with yet)

Edited December 6 by lemming

[TheMultiVitamin]

On 10/4/2024 at 12:44 PM, Frozen Burn said:

My Excel Workbook may make people's head explode.  😄  Here are pics of most of my sheets....

 

TF/SF/Trial Tracker along with tracking incarnate tiers.

 

 

List of WSTs...

 

 

Toons that need Villain Epics unlocked - so I can quickly switch when I see that announcement in LFG!

 

 

Non-Passive Accolade Tracker (All my toons get the passives, so no need to track except Dimensional Warder - see next).

 

 

Dimensional Warder / Praet AV Tracker with List of alts with saved missions...

 

 

Toon Needs and those who store things (like IO types, catalysts, Boosters, etc)...

 

 

HP Caps!  (I can never remember them.)

 

 

MoM Nightmare Checklist....

 

 

Day Jobs....

 

 

Praetorian Arcs - Use this for deciding how I want to play my toon, when to switch between Loyalist / Resistance (or not at all), etc....

 

 

Praetorian Arcs / iTrials (Primal) Timeline - not complete, but mostly use for the lvl 40+ content timeline so I can play them in order.

 

 

Alpha Chart - SO useful for picking Alphas - YES, THERE ARE SOMETIMES BETTER OPTIONS THAN MUSCULATURE!  😛  

 

 

Lore Buff Pets and What They Can Do For Me!

 

 

Ouro Badge Checklist - needs updating, but my main badger has all of them already, so not in a rush to fix it.

 

 

 

I have some other sheets in the workbook for random things I work on related to COX, but no one else would find useful in anyway.  🙂  

You ever finish that Praetorian Arcs/ITrials timeline? I'd like to see what that looks like to make my own (I love doing things sequentially).