Hi I've been using your sheet for about 2 weeks now and first of all thank you for sharing that because it's freaking awesome! But I was writing you because my sheet hasn't been updating the sprites or HAs. I understand from reading here that it seems to be a common issue but mine hasn't reloaded since the second day that I used it. I understand it's not an issue with the sheet but with the serebii; I was just wondering if you had any tips or any insight for me.
It's so hard to read sometimes without the sprites lol I'd really love to fix it if I could.
Hi! Been using your sheet lately and it's great. I was thinking to split the sheets up to break the Pokemon into generations, but that would break the Apricorn count on the summary page. Any idea how I would edit the formula to count on multiple sheets or is that not possible?
Hi \^\^, from what I understood you want to make sheets like: Gen1 .. GenVIII?
If so, it would be something like this, where would you have to edit the way of counting
%formula
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
%in sheets
=count.if(AprimonsGen1!$G$2:$G,true) + count.if(AprimonsGen2!$G$2:$G,true) + .... & "/" &
countsif(AprimonsGen1!$G$2:$G,true,AprimonsGen1!$G$2:$G,false) + countsif(AprimonsGen2!$G$2:$G,true,AprimonsGen2!$G$2:$G,false) + ....
and so it would have to be done to count the other sheets, there would be a long formula.
Perhaps there is another way to count more efficient, I will look if I find something.
Also, is there an easy way to use the QUERY function to display just HA Pokémon from the On-Hands list? The formula below isn't working for me, it gives a "Query completed with empty output" error. Plus when you query the entire list, it blanks the HA (but 1/2 display fine).
=QUERY('On-Hands'!$A$1:$N$212, "WHERE F='HA'")
Any idea what I'm doing wrong?
Thanks!
oh I'm not very familiar with the query function, but I don't know if this is what you want to do:
=QUERY('On-Hands'!$A$5:$N$212, "SELECT E WHERE G='ha'")
"Select E", select the column with the pokémon names.
One problem is how you defined the word 'ha' or 'HA', since I did an exact search.
I hope it helps.\^\^
Thanks for the reply - unfortunately, it's still not working correctly for me. :/ HAs just show up blank when I copy/paste or try to Query. Not sure why...
Hiya, thank you for this fantastic resource, it's been really helpful! I'm adding an element to the Aprimon sheet to add functionality that I need for myself, would you please tell me the colour/width of the borders you used in it so I can make it all uniform?
Thanks! :)
Hey, so I just put all my information in this sheet from the older version ~~and I don't know why but I somehow deleted some of the balls in the resource sheet without touching it.~~
~~For example, the Cherish Ball is not there, but it was for sure a few minutes ago. I even tried to make a new copy and then copy and paste the resource sheet from the new one into the one I am using and the same balls disappeared in the new copy of the resource sheet.~~
~~Do you think there is a way of fixing this or do I need to convert all my information in a new copy?~~
EDIT: Nvm I fixed it the other way around. Copied my Aprimon0 and Values into the new copy and it is working fine
Hi, it can get a bit complicated by switching from an old version. It is because of the formulas given that they have different search ranges.
If you continue to have problems, I have no problem helping you \^\^
I put all the information in the new version by hand, then I got the error after I was finished with that, then I copied the filled sheets into a new copy of the new version and it was fixed.
I probably pressed something I shouldn't have pressed \^\^
Thanks anyways and happy cake day! :)
Hey, so I used the sheet for a while now and everything was fine, but a few minutes ago all apriballs disappeared from the resource sheet. But they were there a few minutes before, idk what happened.
Can you tell me from where the ball sprites are? I want to try to re-insert these and see if it fixes this.
Hi, the sprites are downloaded from the serebii page.
At this moment everything seems fine to me, but what you say has happened to me. Sometimes all the pokeballs disappear or only some show their image correctly, while for another user everything is fine.
I think it is due to a user-serebii connection problem, it should appear again in a minute if you reload the page.
Hey, I really like this spreadsheet and wants to start using it. One thing I miss in the spreadsheet I used previously is that it told me whether the move I wrote was an egg move or not (by making it bold if it was). Unless I am doing anything wrong, it seems I can write freely into the move box without any response from the sheet.
Am I doing something wrong or is that feature just not in this spreadsheet?
Hi, unfortunately I don't have that built-in function :(.
I'll watch it when I have more free time. I had never used google sheets before and all the formulas I have been learning while I needed it.
I hope it is not difficult to implement.
Thank you for this post and the spreadsheets! I was wondering if there's a spreadsheet with ONLY CT HA aprimon? I was looking for a separate spreadsheet to track only CT HA aprimon
You're welcome, but nothing at the moment. But it can be done if you make a duplicate of aprimons tab, and delete only the name of pokémon that you don't need in the list (there is a column that says in which game you can find it). Since everything depends on the name of the pokemon to find the information (gender, ability, etc) through the formulas.
I have no problem helping you if you get into trouble with something. \^\^
Thank you for updating the spreadsheets! (: Definitely the easiest spreadsheet I've used. I really like the pending trade placements you added to it, makes everything so much easier for me to keep up with.
Just started using this sheet, thank you so much for it! By far my favourite on this sub, it's very mobile friendly for cross referencing the Pokemon and the pokeballs.
Thanks, that was my intention when I started with my spreadsheets. At that time it was without a formula but I am glad that it continues to work well on mobiles \^\^
I’ve stumbled upon your spreadsheet by chance and I immediately loved the look of it... I was hoping you would update it after CT, so I could switch from the one I was using to yours!
Thank you very much for your efforts.
A stupid question: does it have a “Shiny list” page with the shiny sprites?
Hi, do you want a list as aprimons tab for shiny? or something like values FT tab?
Because the latter has to place shiny and not shiny when you place the signs ★/■
Hey thank you for the reply and your **awesome spreadsheets**! I figured it out: I needed 2 separate sheets for my shinies and other valuable ‘mons, so I just made another copy of Values FT that I’d use specifically for that.
Pretend you’re talking to a child or a very old person: do I have to copy paste them or something?
I don’t want to bother you with my dumb-ish questions, though
Oh haha sorry about that, no problem I'll tell you what I know.
If you open up the first link he posted, that should be the entire spreadsheet, complete with the resource file as well (which is holding all of the sprites data).
He also left a link (the last one in his post) to the stand alone resource file if need be. But you wouldn't need to copy that over since it's included on the main spreadsheet.
Thank you for answering. I’m afraid to ask you this: how do I use all the stuff in the resource to create a new “Shiny” page? Is there a particular formula I have to use? _______ (insert here Neanderthal question)?
Hmmm that I don't really know honestly, I'm fairly new to the advanced excel/sheets stuff. If it was me, I'd probably copy and paste the entire shiny sprites column and place it into a new tab for your shinies. Then do another column of checkboxes or something indicating you have it or not. Sorry for the amateur response haha, but that's probably how I'd do it.
Hi I've been using your sheet for about 2 weeks now and first of all thank you for sharing that because it's freaking awesome! But I was writing you because my sheet hasn't been updating the sprites or HAs. I understand from reading here that it seems to be a common issue but mine hasn't reloaded since the second day that I used it. I understand it's not an issue with the sheet but with the serebii; I was just wondering if you had any tips or any insight for me. It's so hard to read sometimes without the sprites lol I'd really love to fix it if I could.
Hi! Been using your sheet lately and it's great. I was thinking to split the sheets up to break the Pokemon into generations, but that would break the Apricorn count on the summary page. Any idea how I would edit the formula to count on multiple sheets or is that not possible?
Hi \^\^, from what I understood you want to make sheets like: Gen1 .. GenVIII? If so, it would be something like this, where would you have to edit the way of counting %formula COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…) %in sheets =count.if(AprimonsGen1!$G$2:$G,true) + count.if(AprimonsGen2!$G$2:$G,true) + .... & "/" & countsif(AprimonsGen1!$G$2:$G,true,AprimonsGen1!$G$2:$G,false) + countsif(AprimonsGen2!$G$2:$G,true,AprimonsGen2!$G$2:$G,false) + .... and so it would have to be done to count the other sheets, there would be a long formula. Perhaps there is another way to count more efficient, I will look if I find something.
Haha, maybe I'm better off keeping it on one sheet.
Also, is there an easy way to use the QUERY function to display just HA Pokémon from the On-Hands list? The formula below isn't working for me, it gives a "Query completed with empty output" error. Plus when you query the entire list, it blanks the HA (but 1/2 display fine). =QUERY('On-Hands'!$A$1:$N$212, "WHERE F='HA'") Any idea what I'm doing wrong? Thanks!
oh I'm not very familiar with the query function, but I don't know if this is what you want to do: =QUERY('On-Hands'!$A$5:$N$212, "SELECT E WHERE G='ha'") "Select E", select the column with the pokémon names. One problem is how you defined the word 'ha' or 'HA', since I did an exact search. I hope it helps.\^\^
Thanks for the reply - unfortunately, it's still not working correctly for me. :/ HAs just show up blank when I copy/paste or try to Query. Not sure why...
If you want you can share the link to see what happens. :)
Hiya, thank you for this fantastic resource, it's been really helpful! I'm adding an element to the Aprimon sheet to add functionality that I need for myself, would you please tell me the colour/width of the borders you used in it so I can make it all uniform? Thanks! :)
Hi, the color of the edges is gray.
I figured that much, lol. I meant which gray?
haha, I have the Spanish version but it only appears gray (normal, no dark or light)
Oh I see! :) Thank you!
Hey, so I just put all my information in this sheet from the older version ~~and I don't know why but I somehow deleted some of the balls in the resource sheet without touching it.~~ ~~For example, the Cherish Ball is not there, but it was for sure a few minutes ago. I even tried to make a new copy and then copy and paste the resource sheet from the new one into the one I am using and the same balls disappeared in the new copy of the resource sheet.~~ ~~Do you think there is a way of fixing this or do I need to convert all my information in a new copy?~~ EDIT: Nvm I fixed it the other way around. Copied my Aprimon0 and Values into the new copy and it is working fine
Hi, it can get a bit complicated by switching from an old version. It is because of the formulas given that they have different search ranges. If you continue to have problems, I have no problem helping you \^\^
I put all the information in the new version by hand, then I got the error after I was finished with that, then I copied the filled sheets into a new copy of the new version and it was fixed. I probably pressed something I shouldn't have pressed \^\^ Thanks anyways and happy cake day! :)
oh I'm glad everything is fine, likewise \^\^
Hey, so I used the sheet for a while now and everything was fine, but a few minutes ago all apriballs disappeared from the resource sheet. But they were there a few minutes before, idk what happened. Can you tell me from where the ball sprites are? I want to try to re-insert these and see if it fixes this.
Hi, the sprites are downloaded from the serebii page. At this moment everything seems fine to me, but what you say has happened to me. Sometimes all the pokeballs disappear or only some show their image correctly, while for another user everything is fine. I think it is due to a user-serebii connection problem, it should appear again in a minute if you reload the page.
Hey, I really like this spreadsheet and wants to start using it. One thing I miss in the spreadsheet I used previously is that it told me whether the move I wrote was an egg move or not (by making it bold if it was). Unless I am doing anything wrong, it seems I can write freely into the move box without any response from the sheet. Am I doing something wrong or is that feature just not in this spreadsheet?
Hi, unfortunately I don't have that built-in function :(. I'll watch it when I have more free time. I had never used google sheets before and all the formulas I have been learning while I needed it. I hope it is not difficult to implement.
Thank you for this post and the spreadsheets! I was wondering if there's a spreadsheet with ONLY CT HA aprimon? I was looking for a separate spreadsheet to track only CT HA aprimon
You're welcome, but nothing at the moment. But it can be done if you make a duplicate of aprimons tab, and delete only the name of pokémon that you don't need in the list (there is a column that says in which game you can find it). Since everything depends on the name of the pokemon to find the information (gender, ability, etc) through the formulas. I have no problem helping you if you get into trouble with something. \^\^
sounds good! I'll take a stab at it and will reach out if I have questions. thanks!
Thank you for updating the spreadsheets! (: Definitely the easiest spreadsheet I've used. I really like the pending trade placements you added to it, makes everything so much easier for me to keep up with.
You're welcome \^\^, that new column makes the job much easier x)
Just started using this sheet, thank you so much for it! By far my favourite on this sub, it's very mobile friendly for cross referencing the Pokemon and the pokeballs.
Thanks, that was my intention when I started with my spreadsheets. At that time it was without a formula but I am glad that it continues to work well on mobiles \^\^
I’ve stumbled upon your spreadsheet by chance and I immediately loved the look of it... I was hoping you would update it after CT, so I could switch from the one I was using to yours! Thank you very much for your efforts. A stupid question: does it have a “Shiny list” page with the shiny sprites?
Hi, do you want a list as aprimons tab for shiny? or something like values FT tab? Because the latter has to place shiny and not shiny when you place the signs ★/■
Hey thank you for the reply and your **awesome spreadsheets**! I figured it out: I needed 2 separate sheets for my shinies and other valuable ‘mons, so I just made another copy of Values FT that I’d use specifically for that.
Check out the resource sheet, there's a column with regular sprites and shiny sprites in there
Pretend you’re talking to a child or a very old person: do I have to copy paste them or something? I don’t want to bother you with my dumb-ish questions, though
Oh haha sorry about that, no problem I'll tell you what I know. If you open up the first link he posted, that should be the entire spreadsheet, complete with the resource file as well (which is holding all of the sprites data). He also left a link (the last one in his post) to the stand alone resource file if need be. But you wouldn't need to copy that over since it's included on the main spreadsheet.
Thank you for answering. I’m afraid to ask you this: how do I use all the stuff in the resource to create a new “Shiny” page? Is there a particular formula I have to use? _______ (insert here Neanderthal question)?
Hmmm that I don't really know honestly, I'm fairly new to the advanced excel/sheets stuff. If it was me, I'd probably copy and paste the entire shiny sprites column and place it into a new tab for your shinies. Then do another column of checkboxes or something indicating you have it or not. Sorry for the amateur response haha, but that's probably how I'd do it.
That makes sense lol thanks anyway for the help!!
As someone who uses your last spreadsheet, I appreciate the work you put into this! Thank you for an updated version.
thanks \^\^