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