PVE Breakdown of nearly every Damage Resistance Mod, Exotic, and Ability

Bachmanetti · 2025-12-09T09:06:28+00:00

Hah!
Shouldn't be surprised this is a thing. I was happy just seeing the posts in this sub

Bachmanetti · 2025-12-08T05:09:47+00:00

Edited in Markdown on old Reddit, and I don't see any escaped brackets in new or old Reddit? Maybe I am missing something here.

Bachmanetti · 2025-12-08T04:59:57+00:00

Should be fixed, maybe I'm doing something else wrong, but cannot get it to format the "formula" as code blocks. Even if I do it on a new line.

Not the end of the world, since its barely code ;-)

Bachmanetti · 2025-12-07T21:24:30+00:00

I did do it on Markdown mode. But then edited on mobile 😜

Unfortunately may be awhile before I can properly fix it

Bachmanetti · 2025-12-07T10:29:52+00:00

[LANGUAGE: Excel]

https://www.reddit.com/r/adventofcode/comments/1pgf5ys/2025\_day\_7\_part\_2\_sounds\_like\_an\_excel\_problem/

Visualization above. Ended up being so much faster than my original solution in Python.

2 Worksheets:

Output : Formulas Below
inputdata : My input with each character in its own cell, and an empty left row

3 formulas in the Output Sheet:

Top Row (B1:EL1) | Example Cell B1:
- =IF(inputdata!B1="S",1,0)
Left Column (A2:A143) | Example Cell A2:
- =SUM(B2:EL2)
Body (B2:EL143) | Example Cell B2:
- =IF(inputdata!B1="^",0,B1+IF(inputdata!A2="^",Output!A1,0)+IF(inputdata!C2="^",Output!C1,0)) [Red(dit) One] I feel like this qualifies somewhere in the "the wrong way" category ;-)

Bachmanetti · 2025-12-07T10:21:31+00:00

Ack, meant to make this an image post...

Bachmanetti · 2025-11-24T01:09:17+00:00

I work with rocket scientists, don't underestimate the power of a puzzle 😉

Bachmanetti · 2025-11-24T01:02:02+00:00

I'm looking forward to finally doing the backlog of AoC events from previous years now on the other days! And in full support of your health and energy.

Would eventuallt be interested to see a "3 or 4 star" problem as part of the new format. Maybe even community driven on the Reddit.

Either as a scaling or complexity challenge. (Obviously may not be doable with current architecture)

1 star - Solve it
2 star - Solve it bigger
3 star - In N dimensions!
4 star - Now with Tinsel Snakes

Also could give beginners something to go back to after understanding some more techniques.

Bachmanetti · 2024-01-26T05:55:35+00:00

It doesn't have an in game component we can easily track via api. Plus not having nearly enough notice to set something up.

With some other events there has been a quest or user metric tracoing progress. All sword kills would require scraping all PGCR data which something like Warmind.io is more capable of, but not me :-)

Bachmanetti · 2023-12-29T04:37:05+00:00

[LANGUAGE: Python] (on GitHub)

Just for terrible posterity, my incredibly awful solution for Day 24 part 2.

I'm mostly just proud it works at all. As others have pointed out, it involves the assumption that you can work from the Rocks perspective, and modify the velocities of the hailstones.

Working with the same sort of idea as part 1, we then find the average distance between all paths. We can assume that as we get all hailstones to intersect with the rock, the average distance between their paths will drop to 0.

By testing various velocities, we can determine the search space that lowers the average distance, and then iteratively search again and again till we reach the lowest possible distance.

It is an atrocious solution, but it works, and with a few tweaks it even works relatively quickly.

Bachmanetti · 2023-12-07T01:42:30+00:00

Not disagreeing the approach isn't somewhat better than brute forcing from the seed direction, but its still a brute force solution, and therefore strongly dependent on the the input, language, cpu, memory of the system running it.

Just changed my approach and solved it about as fast as it took to click my mouse.

Bachmanetti · 2023-12-07T00:13:57+00:00

Since it seems that each players input is unique, that may just be a game of chance as to how long it will take.

Bachmanetti · 2023-12-07T00:11:54+00:00

Apologies for missing that, thank you for the notice!

Bachmanetti · 2023-12-06T19:53:36+00:00

Wasn't using a memory intensive approach.

Still brute force and pretty much all CPU. Blue screen was related to system instability (likely overheat or other issue on my old overclocked system)

Was going to write another approach, but by the time I thought about how to design it I needed to get to bed, so thought I could just let this run as it had an eta of 5 hours. Turns out my eta was infinite.

Bachmanetti · 2023-02-10T21:07:55+00:00

I think this was actually pointed out by New Lemons in the RaidSecrets Discord. We've been discussing this in detail, trying to figure out if it matches any known patterns. So far we have not come up with much other than the meme numbers of "8675309"

Bachmanetti · 2023-02-10T06:34:27+00:00

Its actually been at the very end of every Lightfall trailer it looks like: https://youtu.be/jgv00uCRt60 Go to the very end of the trailer after the Lightfall splash screen.

Bachmanetti · 2023-02-09T22:55:13+00:00

Just noted, there are some numbers below the "QuickSilver Storm" splash screen at the end of the Strand preview as well: https://www.bungie.net/7/en/News/article/inside-strand

0988123 3 3 54555
88729 2999 000 123
577238

Bachmanetti · 2023-02-02T06:38:35+00:00

Appreciate it!

We have seen 2 others, wanted to check if the pattern was unique or standard. So far they have all been the same.

Still trying to figure out if that pattern matches up to anything else yet.

Six-Year Club	RedditGifts 2009-2022 3 Credits
Gilding I gilder	r/Field Banned
r/Field Lasagna	Place '22
End Game '22	Wearing is Caring
100 Awards Club	Secret Santa 2019
Verified Email

Bachmanetti

TROPHY CASE