**WARNING: LAGGY**
Give it a few moments after loading for most of the lag to subside.
If you want help implementing changes onto your sheet, let me know and I can walk you through it. Only really matters if you made a copy of the sheet before the above changes.
Give it a few moments after loading for most of the lag to subside.
It's also wierd and finicky if you wanna search. Kinda have to jump through hoops to do it.
For you absolute nutcases who really want to collect ice creams, here it is, albeit only up to 2 Cones. 3 Cones have over 5 million combinations. Due to the lag, that will literally never be a possibility.
Here it is!
- There are 5 sheets in total, with 2-cone combinations spread across 4 sheets to alleviate lag. It's still laggy. I apologize for that, but there's nothing I can really do about it except spread them across more pages, which would be annoying to navigate. I can spread them across more pages, if demand is strong enough, but I won't do it otherwise.
- Checking a box will make the adjacent box turn green, for easy visual. For the 2 Cone sheets, you may have to give it a moment to turn green or white, as this list is pretty laggy.
- There is a custom "search bar" so you can figure out what Row to navigate to in order to find your 2-cone combination. It's finicky and wierd, but I can't do anything about that either (Google sheets is very limiting). There are a few things you need to keep in mind when using this search bar:
1: A space before the first pokemon's name. It won't work without this. I don't know why.
2: 2 spaces before the second pokemon's name. It won't work at all without this. I still dunno why.
3: Press CTRL + Enter after the last (bottom) Pokemon in your search. It won't give you the right row number if you don't.
4: It gives you the row #, but does not navigate to it. You need to add a custom Script in order to do it.
Here's how you get that script, if you want.
In order to use this checklist..
You must have a Google account.
File > Make a Copy
There you go. You now have your own laggy checklist.
If you spot any errors or have any ways of making things easier, let me know and I'll see what I can do. I really hate this search function I threw together.
Enjoy!
For you absolute nutcases who really want to collect ice creams, here it is, albeit only up to 2 Cones. 3 Cones have over 5 million combinations. Due to the lag, that will literally never be a possibility.
Here it is!
- There are 5 sheets in total, with 2-cone combinations spread across 4 sheets to alleviate lag. It's still laggy. I apologize for that, but there's nothing I can really do about it except spread them across more pages, which would be annoying to navigate. I can spread them across more pages, if demand is strong enough, but I won't do it otherwise.
- Checking a box will make the adjacent box turn green, for easy visual. For the 2 Cone sheets, you may have to give it a moment to turn green or white, as this list is pretty laggy.
- There is a custom "search bar" so you can figure out what Row to navigate to in order to find your 2-cone combination. It's finicky and wierd, but I can't do anything about that either (Google sheets is very limiting). There are a few things you need to keep in mind when using this search bar:
1: A space before the first pokemon's name. It won't work without this. I don't know why.
2: 2 spaces before the second pokemon's name. It won't work at all without this. I still dunno why.
3: Press CTRL + Enter after the last (bottom) Pokemon in your search. It won't give you the right row number if you don't.
4: It gives you the row #, but does not navigate to it. You need to add a custom Script in order to do it.
Here's how you get that script, if you want.
In order to use this checklist..
You must have a Google account.
File > Make a Copy
There you go. You now have your own laggy checklist.
If you spot any errors or have any ways of making things easier, let me know and I'll see what I can do. I really hate this search function I threw together.
Enjoy!
Spoiler for Changelog: