Topic: Anybody here good with excel?
+FuckAlms !vX8K53rFBI — 10 years ago #45,085
Is there some way you can calculate a way get my Pokemon onto all of the games?Specifics:
- Section 1 (Sapphire & Leaf Green) are my carts. My intent is to collect one of every species on both games.
- Section 2 (R/S/FR/LG) are my cousin's games. I'm only worried about getting 1 of each species/evolutionary line onto those games.
- For section 2, some preference is given to Sapphire & Leaf Green because these have my cousin's saves on them. Ruby & Fire Red were bought secondhand and have someone else's saves.
- I'm not worried about shuffling legendaries around, only Pokemon that can be caught multiple times or bred.
- I'm breeding/catching them, not just shuffling around to fill in dex entries.
- Fire Red is the designated 'dumping' game if there are to be one-sided trades for Magikarp.
So is there some way to use some function magic to tell me the most efficient way to accomplish these goals?
+Anonymous B — 10 years ago, 48 seconds later[T] [B] #493,364
A
U
T
I
S
M
U
T
I
S
M
+Maddy is !grate/DTHM — 10 years ago, 4 hours later, 4 hours after the original post[T] [B] #493,377
I think a cloning glitch is the most effective way to accomplish your goals. However, in gen 3 cloning is only possible on Emerald, by exploiting a glitch in Battle Tower. I really have no idea how to easily accomplish this otherwise, sorry bud.
·FuckAlms !vX8K53rFBI (OP) — 10 years ago, 2 hours later, 6 hours after the original post[T] [B] #493,380
@previous (Maddy is !grate/DTHM)
I'm just breeding them. The thing I'm trying to solve is choosing pairs to trade between games. Like I need to get a Caterpie onto the Sapphire in section 1, and section 2 Leaf Green needs a Ralts. It's a logistical puzzle I suppose.
I'm just breeding them. The thing I'm trying to solve is choosing pairs to trade between games. Like I need to get a Caterpie onto the Sapphire in section 1, and section 2 Leaf Green needs a Ralts. It's a logistical puzzle I suppose.
·Maddy is !grate/DTHM — 10 years ago, 2 hours later, 9 hours after the original post[T] [B] #493,383
@previous (FuckAlms !vX8K53rFBI)
I guess I misunderstood what you're asking then, would you please clarify?
I guess I misunderstood what you're asking then, would you please clarify?
·FuckAlms !vX8K53rFBI (OP) — 10 years ago, 3 hours later, 13 hours after the original post[T] [B] #493,390
@previous (Maddy is !grate/DTHM)
I want to find some way to get a list of trade pairings that will distribute the work evenly enough that I don't have to do a lot of one-sided trades. Like ending up with my Leaf Green having all the non-legendary Pokemon, but still needing to trade for several on my Sapphire.
I want to find some way to get a list of trade pairings that will distribute the work evenly enough that I don't have to do a lot of one-sided trades. Like ending up with my Leaf Green having all the non-legendary Pokemon, but still needing to trade for several on my Sapphire.
·Maddy is !grate/DTHM — 10 years ago, 17 minutes later, 13 hours after the original post[T] [B] #493,391
@previous (FuckAlms !vX8K53rFBI)
So, you're trying to figure out exactly which Pokemon are specific to each game?
So, you're trying to figure out exactly which Pokemon are specific to each game?
+Anti !M6R0eWkIpk — 10 years ago, 1 hour later, 15 hours after the original post[T] [B] #493,394
·Maddy is !grate/DTHM — 10 years ago, 36 minutes later, 15 hours after the original post[T] [B] #493,396
@previous (Anti !M6R0eWkIpk)
Alot of religious nuts think that poekmanz is satanic, and anti-Christian. Look at who we're talking about, tho. Some of them still believe the Earth is only 6,000 years old.
Alot of religious nuts think that poekmanz is satanic, and anti-Christian. Look at who we're talking about, tho. Some of them still believe the Earth is only 6,000 years old.
·Anti !M6R0eWkIpk — 10 years ago, 42 minutes later, 16 hours after the original post[T] [B] #493,398
@previous (Maddy is !grate/DTHM)
Oh that stuff just cracks me up sometimes.
As a reminder the universe is just a simulation and we should be near another reset in 20XX.
Oh that stuff just cracks me up sometimes.
As a reminder the universe is just a simulation and we should be near another reset in 20XX.
·FuckAlms !vX8K53rFBI (OP) — 10 years ago, 21 minutes later, 16 hours after the original post[T] [B] #493,399
@493,391 (Maddy is !grate/DTHM)
You know that Futurama episode where the Professor invents a machine that can swap people's brains?
You know that Futurama episode where the Professor invents a machine that can swap people's brains?
·Maddy is !grate/DTHM — 10 years ago, 1 hour later, 18 hours after the original post[T] [B] #493,403
@previous (FuckAlms !vX8K53rFBI)
You mean one where Leela doesn't like to spend 14 dollars to watch me solve things?
You mean one where Leela doesn't like to spend 14 dollars to watch me solve things?
(Edited 13 seconds later.)
+Anonymous E — 10 years ago, 5 minutes later, 18 hours after the original post[T] [B] #493,405
·FuckAlms !vX8K53rFBI (OP) — 10 years ago, 1 hour later, 19 hours after the original post[T] [B] #493,407
@493,403 (Maddy is !grate/DTHM)
I don't know about that part, but they call in the Harlem Globetrotters at the end to figure out how to get everyone's brain back into the right body.
Anyway, it's sort of like that, but I don't want to do tradebacks unless it's a Pokemon that evolves via trade.
I don't know about that part, but they call in the Harlem Globetrotters at the end to figure out how to get everyone's brain back into the right body.
Anyway, it's sort of like that, but I don't want to do tradebacks unless it's a Pokemon that evolves via trade.
·Maddy is !grate/DTHM — 10 years ago, 2 hours later, 21 hours after the original post[T] [B] #493,414
@previous (FuckAlms !vX8K53rFBI)
Unless you have ready supplies of certain held items, necessary for trade evolutions, be prepared to play at least one game more than once.
Unless you have ready supplies of certain held items, necessary for trade evolutions, be prepared to play at least one game more than once.
(Edited 12 seconds later.)
·FuckAlms !vX8K53rFBI (OP) — 10 years ago, 1 hour later, 23 hours after the original post[T] [B] #493,427
@previous (Maddy is !grate/DTHM)I've got Theif. Wild Magnemite holds Metal Coat and wild Slowpoke holds King's Rock.
(Edited 1 minute later.)
·Maddy is !grate/DTHM — 10 years ago, 8 hours later, 1 day after the original post[T] [B] #493,450
@previous (FuckAlms !vX8K53rFBI)
Ok, just making sure you had taken that into consideration.
Ok, just making sure you had taken that into consideration.
(Edited 1 minute later.)
+Anonymous F — 10 years ago, 3 hours later, 1 day after the original post[T] [B] #493,465
this is actually a legit problem. i think this is a variant on the stable matching problem (https://en.wikipedia.org/wiki/Stable_marriage_problem). that being said, this is probably an interesting problem to write an algorithm for.
btw, not sure excel does what you want it to do for this, but it could. not sure of excel's limitations.
btw, not sure excel does what you want it to do for this, but it could. not sure of excel's limitations.
Start a new topic to continue this conversation.
Or browse the latest topics.