u/Anxious-Bluebird-157

▲ 5 r/excel

Make it so that Autofill only increases by 1 no matter how many tiles are involved

Excel Version: Windows 7

I am working on a sheet that, to put it together, requires the use of Autofill to drag multiple formulas downward. I want to know, rather than the current situation I am in:

https://preview.redd.it/vosqeu4p8fbh1.png?width=139&format=png&auto=webp&s=4ecf2a624d553cdb4d87c135733cf24abd9aef55

(The selected tile has been autofilled by dragging the top three tiles down, as shown below: The first tile's value was =$A1, as shown on the image underneath the below one)

https://preview.redd.it/mvl7wooa9fbh1.png?width=93&format=png&auto=webp&s=ef1be58bce08fd17950733eb3211cc86b98a5270

https://preview.redd.it/3bsxqp5y8fbh1.png?width=133&format=png&auto=webp&s=0967397e880c244f84945cb64dd913655385ed47

The values are to only increase by 1 no matter what happens.

https://preview.redd.it/zvalofk39fbh1.png?width=181&format=png&auto=webp&s=c6dcabfdae9697bd3273a278278f3a81c8c0a5e7

...Like this!

reddit.com
u/Anxious-Bluebird-157 — 23 hours ago

Pokégotchi Endless Dreams Prototype Overworld Sprites (Feedback Wanted!)

While I intend to get help with making all of the overworld sprites for my project, Pokégotchi Endless Dreams, I made these ones, for the 15 playable Tamagotchi in the game, as part of a little free time months ago. They may not be the best, but they're certainly a start!

From left to the right, the characters are:

Row 1: Mametchi, Kuchipatchi, Memetchi

Row 2: Kuromametchi, Lovelitchi, Melodytchi

Row 3: Himespetchi, Moriritchi, Coffretchi

Row 4: Candy Pakupaku, Yumemitchi, Kiraritchi

Row 5: Pianitchi, Miraitchi, Clulutchi

(Yes, these are all real Tamagotchi!)

Below are links to the previous four posts I made:

Pokégotchi Endless Dreams (Recruiting!) : r/PokemonROMhacks

Pokégotchi Endless Dream's Regional Pokédex! (Feedback Wanted!) : r/PokemonROMhacks

Pokégotchi Endless Dreams's Fakemon! (Feedback Wanted!) : r/PokemonROMhacks

A clearer look at Pokégotchi Endless Dreams's Fakemon (Feedback wanted!) : r/PokemonROMhacks

u/Anxious-Bluebird-157 — 17 days ago

A clearer look at Pokégotchi Endless Dreams's Fakemon (Feedback wanted!)

Does this look familiar to you? Why, it's the same Pokédex post I made on the recruitment page for Pokégotchi Endless Dreams a few days ago, except now you can zoom in and have a closer look at all the names and types of the Fakemon, as well as all of the new mode changes, Mega Evolutions, Gigantamax Forms, and the all-new Biomerge forms!
These displays were originally made for the project's Instagram page, which you can see below:
https://www.instagram.com/ubertrainerinfinitydx/

Below are links to the previous three posts I made:

Pokégotchi Endless Dreams (Recruiting!) : r/PokemonROMhacks

Pokégotchi Endless Dream's Regional Pokédex! (Feedback Wanted!) : r/PokemonROMhacks

Pokégotchi Endless Dreams's Fakemon! (Feedback Wanted!) : r/PokemonROMhacks

u/Anxious-Bluebird-157 — 17 days ago

Pokégotchi Endless Dreams (Recruiting!)

Pokégotchi Endless Dreams

A ROM Hack of Pokémon Emerald that serves as a crossover between Pokémon and Tamagotchi, designed to celebrate the 30th anniversaries of both franchises!

Planned Features:

●Play as one of fifteen different Tamagotchi

●Utilize the new Cheer Ability and Biomerge mechanics in battle

●All previous generational gimmicks return

●A vast story lasting ten chapters with side quests

●Play the game in either Normal Mode or Challenge Mode, and set a variety of limits, including a level cap and the ability to enforce rules for Nuzlockes, Monotype Runs, Egglockes, and Wedlockes

●Built in randomizer mode for a unique gameplay experience

●Gain several quality of life features, such as automatic Move Relearner, Pokémon Box Link, and the Judge Function

●Pokémon Contests make a return appearance!

Positions Wanted:

●Spriters for the following categories: (I've already made the front and back sprites for all of the new Pokémon)

●Gen 3 style sprites for all of the trainers in the game

●Gen 3 style back sprites for the 15 playable Tamagotchi

●Gen 3 style sprites for the plushies

●Gen 3 style overworld sprites, including playable characters, NPCs, and Pokémon

●Gen 3 style backgrounds

●Gen 3 style maps

●Mappers for Generation 3 maps

●Programmers fluent in pokeemerald-expansion and it's surrounding tools

●Sound Artists

●Storywriters/Game Balancers (I have a ten chapter tale ready but it needs reviewing!)

IMPORTANT NOTICE: I have not yet begun work on the actual ROM Hack itself yet because of my lack of skills in pokeemerald-expansion at the time.

Important Links:

The Recruitment Page: https://www.pokecommunity.com/threads/pokégotchi-endless-dreams-help-wanted.539554/

The Database: https://docs.google.com/spreadsheets/d/1ZW1ENH7O-diX4R1W6QYsrDABw5UU6V9qyuE-AGG2r0E/edit?usp=sharing

The Discord Server: https://discord.gg/W2U2e9Evkv

The Instagram Page: https://www.instagram.com/ubertrainerinfinitydx// Scripter / Playtester / …>

u/Anxious-Bluebird-157 — 18 days ago

Pokégotchi Endless Dreams's Fakemon! (Feedback Wanted!)

Following on from the previous post I made, here's all of the new Fakemon I designed for Pokégotchi Endless Dreams! The first image shows all of the front sprites, the second shows a second frame for each of the sprites to correlate with Pokémon Emerald's animated sprites, and the third shows all of the back sprites, though the regional forms are not shown on the back sprite sheet.

You can view all the information about them in the database below:

https://docs.google.com/spreadsheets/d/1ZW1ENH7O-diX4R1W6QYsrDABw5UU6V9qyuE-AGG2r0E/edit?usp=sharing

Below are links to the previous two posts I made:

Pokégotchi Endless Dreams (Recruiting!) : r/PokemonROMhacks

Pokégotchi Endless Dream's Regional Pokédex! (Feedback Wanted!) : r/PokemonROMhacks

u/Anxious-Bluebird-157 — 18 days ago

Pokégotchi Endless Dream's Regional Pokédex! (Feedback Wanted!)

This post is designed to go with the Recruitment Post of Pokégotchi Endless Dreams I made here three days ago, and showcases the complete regional Pokédex! While I'm pretty sure it's the final version, feedback would be appreciated! (And don't forget to read the previous post about Pokégotchi Endless Dreams as well! You can see all of the new fakemon's information in the database below!)
https://docs.google.com/spreadsheets/d/1ZW1ENH7O-diX4R1W6QYsrDABw5UU6V9qyuE-AGG2r0E/edit?usp=sharing

u/Anxious-Bluebird-157 — 19 days ago

Pokégotchi Endless Dreams (Recruiting!)

Pokégotchi Endless Dreams

A ROM Hack of Pokémon Emerald that serves as a crossover between Pokémon and Tamagotchi, designed to celebrate the 30th anniversaries of both franchises!

Planned Features:

●Play as one of fifteen different Tamagotchi

●Utilize the new Cheer Ability and Biomerge mechanics in battle

●All previous generational gimmicks return

●A vast story lasting ten chapters with side quests

●Play the game in either Normal Mode or Challenge Mode, and set a variety of limits, including a level cap and the ability to enforce rules for Nuzlockes, Monotype Runs, Egglockes, and Wedlockes

●Built in randomizer mode for a unique gameplay experience

●Gain several quality of life features, such as automatic Move Relearner, Pokémon Box Link, and the Judge Function

●Pokémon Contests make a return appearance!

Positions Wanted:

●Spriters for the following categories: (I've already made the front and back sprites for all of the new Pokémon)

●Gen 3 style sprites for all of the trainers in the game

●Gen 3 style back sprites for the 15 playable Tamagotchi

●Gen 3 style sprites for the plushies

●Gen 3 style overworld sprites, including playable characters, NPCs, and Pokémon

●Gen 3 style backgrounds

●Gen 3 style maps

●Mappers for Generation 3 maps

●Programmers fluent in pokeemerald-expansion and it's surrounding tools

●Sound Artists

●Storywriters/Game Balancers (I have a ten chapter tale ready but it needs reviewing!)

IMPORTANT NOTICE: I have not yet begun work on the actual ROM Hack itself yet because of my lack of skills in pokeemerald-expansion at the time.

Important Links:

The Recruitment Page: https://www.pokecommunity.com/threads/pokégotchi-endless-dreams-help-wanted.539554/

The Database: https://docs.google.com/spreadsheets/d/1ZW1ENH7O-diX4R1W6QYsrDABw5UU6V9qyuE-AGG2r0E/edit?usp=sharing

The Discord Server: https://discord.gg/W2U2e9Evkv

The Instagram Page: https://www.instagram.com/ubertrainerinfinitydx/

u/Anxious-Bluebird-157 — 21 days ago