Page 1 of 1

Spreadsheet

Posted: April 24th, 2013, 9:23 am
by Meemo
I really want a spreadsheet with all the Battle Pets and which area you can catch them in (or the lowest level area) Is there such a thing? I can get a list of my pets off petsear.ch do a vlookup so I know which ones I need and then sort by area.

At the moment I'm having to look at a list of pets for the area I'm in and then check what I've got... any ideas?

Re: Spreadsheet

Posted: April 24th, 2013, 9:27 am
by Dawayn
I don't know about any spreadsheet, but why don't you use the Pets by Zone function here on this website?
You can find it under Tools.
The pets you filter that way also show all the other zones you can find them in.

Re: Spreadsheet

Posted: April 24th, 2013, 9:34 am
by GormanGhaste

Re: Spreadsheet

Posted: April 24th, 2013, 10:08 am
by Meemo
Dawayn wrote:I don't know about any spreadsheet, but why don't you use the Pets by Zone function here on this website?
You can find it under Tools.
The pets you filter that way also show all the other zones you can find them in.
but that doesn't tell me which ones I need... I want a list of pets I still need to catch by zone - not all pets in a zone.

Re: Spreadsheet

Posted: April 24th, 2013, 10:14 am
by Meemo
GormanGhaste wrote:I used this back in 5.0:

http://www.warcraftpets.com/community/f ... preadsheet
Perfik!! *goes off to excel heaven with VLOOKUPs, filters and macros!*

if anyone is interested and has Office 2010 let me know and I'll post some instructions on how to do this with your own list (assuming it works how I expect it!)

Re: Spreadsheet

Posted: April 24th, 2013, 10:38 am
by Dragonwizard
You could also use the addon petjournal enhanced and just choose the option to filter pets by current zone and just start flying in the low level zones and work your way up. Personally I would start with the higher level zones cause it's better to get a level 23 frog then a level 2 frog if you know what I mean.

Re: Spreadsheet

Posted: April 24th, 2013, 4:47 pm
by Meemo
Meemo wrote:
Dawayn wrote:I don't know about any spreadsheet, but why don't you use the Pets by Zone function here on this website?
You can find it under Tools.
The pets you filter that way also show all the other zones you can find them in.
but that doesn't tell me which ones I need... I want a list of pets I still need to catch by zone - not all pets in a zone.
apologies Dawayn, I didn't realise i could filter this!! have everything I need now - thanks guys :mrgreen:

Re: Spreadsheet

Posted: April 25th, 2013, 12:43 am
by Kayfabe
This website really does tend to fill the roles I need instead of a spreadsheet for the most part...