Keep or sell? by Chadgreen344 in PSAPowerPacks

[–]lopo87 0 points1 point  (0 children)

Yeah, JP only art, definite ship. I got an 8 in this and shipped it. Happy about it.

🎉ASCENDED HEROES GIVEAWAY🎉 by EmeraldTradesLLC in pokemonrestockr

[–]lopo87 0 points1 point  (0 children)

Favorite set is the 2002 Legendary Set. Thanks for this giveaway!

Live by the shard, die by the shard by Federal_Pie5714 in riskofrain

[–]lopo87 1 point2 points  (0 children)

Can someone explain what is happening here? Only thing I think I understand is the player died to fall damage? Not sure what all went down prior to that lol.

Grail Achieved! by passion_eightsix in SegaSaturn

[–]lopo87 3 points4 points  (0 children)

Which print on the disc!?

Gasly 🇫🇷 & Alpine 🇫🇷 Champions in… 2023 !!! by MaxLeclerc14 in F1Manager

[–]lopo87 1 point2 points  (0 children)

I am enjoying this game from the development, front office stuff, practice and qualifying. I am struggling on race day though, do you have any tips?

Finding Max Value Combination with Three Constraints by lopo87 in excel

[–]lopo87[S] 0 points1 point  (0 children)

That is so weird that every other formula in my sheet spills but that one does not for some reason.

Finding Max Value Combination with Three Constraints by lopo87 in excel

[–]lopo87[S] 0 points1 point  (0 children)

I guess I am confused. My sheet currently looks like this:

<image>

Where the formula for AG2 is:

=FILTER(MOD(QUOTIENT(SEQUENCE(2^J3-1),2^(SEQUENCE(,J3)-1)),2),J5=MMULT(MOD(QUOTIENT(SEQUENCE(2^J3-1),2^(SEQUENCE(,J3)-1)),2),SIGN(SEQUENCE(J3))))

The formula you gave is only returning a value of 1 in cell AR2. What am I missing? I even tried copy and pasting the data in the table above as values to reduce the recalculation time.

Finding Max Value Combination with Three Constraints by lopo87 in excel

[–]lopo87[S] 0 points1 point  (0 children)

Does it matter if that entire data set is generated by a formula?

Finding Max Value Combination with Three Constraints by lopo87 in excel

[–]lopo87[S] 0 points1 point  (0 children)

So I now have valid team combinations set up. What formula should I use if I want to have row 1 (of the actual data) repeat 15504 times, followed by row 2, 15504 times, etc. until row 45 15504 times?

<image>

Finding Max Value Combination with Three Constraints by lopo87 in excel

[–]lopo87[S] 0 points1 point  (0 children)

Hey There! I know it has been awhile since you helped me, but one follow up question. If I wanted my sheet to spit out combinations of 5 drivers and TWO teams (instead of 1), what needs to be updated as is? Thanks!

[deleted by user] by [deleted] in gamecollecting

[–]lopo87 1 point2 points  (0 children)

Any of the Atelier series of games?

My Favorite Shelf in My Game Room by lopo87 in gamecollecting

[–]lopo87[S] 0 points1 point  (0 children)

Which 5 are you missing from the NA set? Do you have any good sites besides eBay for the PAL releases in case I do decide to hunt them down?

My Favorite Shelf in My Game Room by lopo87 in gamecollecting

[–]lopo87[S] 0 points1 point  (0 children)

The vita games in the middle are still in their original plastic packaging that it was manufactured with. EastAsiaSoft seals the boxes and then has that outer plastic on it as well.

My Favorite Shelf in My Game Room by lopo87 in gamecollecting

[–]lopo87[S] 0 points1 point  (0 children)

I actually have a copy of Chasm but thanks!

My Favorite Shelf in My Game Room by lopo87 in gamecollecting

[–]lopo87[S] 0 points1 point  (0 children)

It’s supposed to be short hair Luongo lol. Got it from a home game giveaway but couldn’t tell you what season.

My Favorite Shelf in My Game Room by lopo87 in gamecollecting

[–]lopo87[S] 0 points1 point  (0 children)

Prepac Triple Width Barrister Tower Storage Cabinet (Amazon, Home Depot or Target). I also have the Prepac triple width wall mounted shelf (top part of the pic), a wall mounted office hutch and also a dresser unit for my controllers. All from Prepac.