PFQ Hunt Planner - Spreadsheet to help you plan!

👍 10

Posted 05/Oct/2020 03:28:23 (3 years ago)
Edited 19/Jan/2021 00:51:32 (3 years ago)

Spreadsheet Link

check me out here!

to use, file > make a copy. delete the current pokemon names and put in your own! the sheet will do the rest of the work for you.

Example

this is my current hunt plan! click the egg codes to get the full image code. each pokemon also has a tip with their name.

pokemon	egg code	exp	clicks
Azurill	g/i/c //pfq-static.com/img/pkmn/g/i/c.png	2560	32
Cleffa	g/i/1 //pfq-static.com/img/pkmn/g/i/1.png	2560	41
Gastly	f/b/0 //pfq-static.com/img/pkmn/f/b/0.png	5120	82
Honedge	n/x/e //pfq-static.com/img/pkmn/n/x/e.png	5120	82
Litleo	s/j/m //pfq-static.com/img/pkmn/s/j/m.png	5120	64
Mimikyu	s/j/7/m //pfq-static.com/img/pkmn/s/j/7/m.png	5120	82
Ralts	m/u/8 //pfq-static.com/img/pkmn/m/u/8.png	5120	82
Sneasel	h/p/h //pfq-static.com/img/pkmn/h/p/h.png	5120	82
Swinub	j/z/s //pfq-static.com/img/pkmn/j/z/s.png	5120	82

working on

making the sheet sort from lowest clicks to highest clicks
inserting an option to select the badge you want to upgrade and sort the 'mons based on type
option to remove the egg code column/a checkbox for using the QOL userscript

useful guides

Avatar by this | plant trees | box hunts

933/50,000 GP

0/100

6/100 Life Antlers

Sapphyre

👍 0

Posted 08/Jan/2021 01:48:10 (3 years ago)

I love this so much!

Sapphyre • She/Her • 22

/ ??? Lake Summons

Background | Code | Forum Icon | Avatar made by MochaFox

kemvon

👍 0

Posted 19/Jan/2021 00:51:57 (3 years ago)

somehow accidentally deleted the file, so i remade it and made it a bit more a e s t h e t i c. currently working on making a little table creator for your wishforge badges in there too~

Barenziah

👍 0

Posted 09/Mar/2021 04:25:27 (3 years ago)
Edited 09/Mar/2021 04:26:08 (3 years ago)

I wanna say thank you for this! been planning on doing daily minihunts and I love spreadsheets... will keep an eye out..!

☾☆ avatar animated by me with official Pokémon Ranger sprites ripped by redblueyellow on TSR

QueenDiancie

👍 4

Posted 09/Mar/2021 13:11:46 (3 years ago)
Edited 09/Mar/2021 13:29:48 (3 years ago)

Some of the egg exp is wrong :( Edit: as well as the badge images I made this for myself if you wanna use it to find image codes. The badges follow this order:

Badge Order

1 = Bronze 2 = Silver 3 = Gold 4 = Platinum 5 = Titanium 6 = Mythril 7 = Adamantium 8 = Nintendium 9 = Wishalloy 10 = Master 1 11 = Master 2 12 = Master 3 13 = Master 4

Badges

Normal

https://pfq-static.com/img/badges/normal-1.png/t=1448590254

https://pfq-static.com/img/badges/normal-2.png/t=1448590254

https://pfq-static.com/img/badges/normal-3.png/t=1448590254

https://pfq-static.com/img/badges/normal-4.png/t=1448590254

https://pfq-static.com/img/badges/normal-5.png/t=1448590254

https://pfq-static.com/img/badges/normal-6.png/t=1448590254

https://pfq-static.com/img/badges/normal-7.png/t=1448590254

https://pfq-static.com/img/badges/normal-8.png/t=1448590254

https://pfq-static.com/img/badges/normal-9.png/t=1448590254

https://pfq-static.com/img/badges/normal-10.png/t=1448590254

https://pfq-static.com/img/badges/normal-11.png/t=1448590254

https://pfq-static.com/img/badges/normal-12.png/t=1448590254

https://pfq-static.com/img/badges/normal-13.png/t=1448590254

Fire

https://pfq-static.com/img/badges/fire-1.png/t=1448590254

https://pfq-static.com/img/badges/fire-2.png/t=1448590254

https://pfq-static.com/img/badges/fire-3.png/t=1448590254

https://pfq-static.com/img/badges/fire-4.png/t=1448590254

https://pfq-static.com/img/badges/fire-5.png/t=1448590254

https://pfq-static.com/img/badges/fire-6.png/t=1448590254

https://pfq-static.com/img/badges/fire-7.png/t=1448590254

https://pfq-static.com/img/badges/fire-8.png/t=1448590254

https://pfq-static.com/img/badges/fire-9.png/t=1448590254

https://pfq-static.com/img/badges/fire-10.png/t=1448590254

https://pfq-static.com/img/badges/fire-11.png/t=1448590254

https://pfq-static.com/img/badges/fire-12.png/t=1448590254

https://pfq-static.com/img/badges/fire-13.png/t=1448590254

Water

https://pfq-static.com/img/badges/water-1.png/t=1448590254

https://pfq-static.com/img/badges/water-2.png/t=1448590254

https://pfq-static.com/img/badges/water-3.png/t=1448590254

https://pfq-static.com/img/badges/water-4.png/t=1448590254

https://pfq-static.com/img/badges/water-5.png/t=1448590254

https://pfq-static.com/img/badges/water-6.png/t=1448590254

https://pfq-static.com/img/badges/water-7.png/t=1448590254

https://pfq-static.com/img/badges/water-8.png/t=1448590254

https://pfq-static.com/img/badges/water-9.png/t=1448590254

https://pfq-static.com/img/badges/water-10.png/t=1448590254

https://pfq-static.com/img/badges/water-11.png/t=1448590254

https://pfq-static.com/img/badges/water-12.png/t=1448590254

https://pfq-static.com/img/badges/water-13.png/t=1448590254

Electric

https://pfq-static.com/img/badges/electric-1.png/t=1448590254

https://pfq-static.com/img/badges/electric-2.png/t=1448590254

https://pfq-static.com/img/badges/electric-3.png/t=1448590254

https://pfq-static.com/img/badges/electric-4.png/t=1448590254

https://pfq-static.com/img/badges/electric-5.png/t=1448590254

https://pfq-static.com/img/badges/electric-6.png/t=1448590254

https://pfq-static.com/img/badges/electric-7.png/t=1448590254

https://pfq-static.com/img/badges/electric-8.png/t=1448590254

https://pfq-static.com/img/badges/electric-9.png/t=1448590254

https://pfq-static.com/img/badges/electric-10.png/t=1448590254

https://pfq-static.com/img/badges/electric-11.png/t=1448590254

https://pfq-static.com/img/badges/electric-12.png/t=1448590254

https://pfq-static.com/img/badges/electric-13.png/t=1448590254

Grass

https://pfq-static.com/img/badges/grass-1.png/t=1448590254

https://pfq-static.com/img/badges/grass-2.png/t=1448590254

https://pfq-static.com/img/badges/grass-3.png/t=1448590254

https://pfq-static.com/img/badges/grass-4.png/t=1448590254

https://pfq-static.com/img/badges/grass-5.png/t=1448590254

https://pfq-static.com/img/badges/grass-6.png/t=1448590254

https://pfq-static.com/img/badges/grass-7.png/t=1448590254

https://pfq-static.com/img/badges/grass-8.png/t=1448590254

https://pfq-static.com/img/badges/grass-9.png/t=1448590254

https://pfq-static.com/img/badges/grass-10.png/t=1448590254

https://pfq-static.com/img/badges/grass-11.png/t=1448590254

https://pfq-static.com/img/badges/grass-12.png/t=1448590254

https://pfq-static.com/img/badges/grass-13.png/t=1448590254

Ice

https://pfq-static.com/img/badges/ice-1.png/t=1448590254

https://pfq-static.com/img/badges/ice-2.png/t=1448590254

https://pfq-static.com/img/badges/ice-3.png/t=1448590254

https://pfq-static.com/img/badges/ice-4.png/t=1448590254

https://pfq-static.com/img/badges/ice-5.png/t=1448590254

https://pfq-static.com/img/badges/ice-6.png/t=1448590254

https://pfq-static.com/img/badges/ice-7.png/t=1448590254

https://pfq-static.com/img/badges/ice-8.png/t=1448590254

https://pfq-static.com/img/badges/ice-9.png/t=1448590254

https://pfq-static.com/img/badges/ice-10.png/t=1448590254

https://pfq-static.com/img/badges/ice-11.png/t=1448590254

https://pfq-static.com/img/badges/ice-12.png/t=1448590254

https://pfq-static.com/img/badges/ice-13.png/t=1448590254

Fighting

https://pfq-static.com/img/badges/fighting-1.png/t=1448590254

https://pfq-static.com/img/badges/fighting-2.png/t=1448590254

https://pfq-static.com/img/badges/fighting-3.png/t=1448590254

https://pfq-static.com/img/badges/fighting-4.png/t=1448590254

https://pfq-static.com/img/badges/fighting-5.png/t=1448590254

https://pfq-static.com/img/badges/fighting-6.png/t=1448590254

https://pfq-static.com/img/badges/fighting-7.png/t=1448590254

https://pfq-static.com/img/badges/fighting-8.png/t=1448590254

https://pfq-static.com/img/badges/fighting-9.png/t=1448590254

https://pfq-static.com/img/badges/fighting-10.png/t=1448590254

https://pfq-static.com/img/badges/fighting-11.png/t=1448590254

https://pfq-static.com/img/badges/fighting-12.png/t=1448590254

https://pfq-static.com/img/badges/fighting-13.png/t=1448590254

Poison

https://pfq-static.com/img/badges/poison-1.png/t=1448590254

https://pfq-static.com/img/badges/poison-2.png/t=1448590254

https://pfq-static.com/img/badges/poison-3.png/t=1448590254

https://pfq-static.com/img/badges/poison-4.png/t=1448590254

https://pfq-static.com/img/badges/poison-5.png/t=1448590254

https://pfq-static.com/img/badges/poison-6.png/t=1448590254

https://pfq-static.com/img/badges/poison-7.png/t=1448590254

https://pfq-static.com/img/badges/poison-8.png/t=1448590254

https://pfq-static.com/img/badges/poison-9.png/t=1448590254

https://pfq-static.com/img/badges/poison-10.png/t=1448590254

https://pfq-static.com/img/badges/poison-11.png/t=1448590254

https://pfq-static.com/img/badges/poison-12.png/t=1448590254

https://pfq-static.com/img/badges/poison-13.png/t=1448590254

Ground

https://pfq-static.com/img/badges/ground-1.png/t=1448590254

https://pfq-static.com/img/badges/ground-2.png/t=1448590254

https://pfq-static.com/img/badges/ground-3.png/t=1448590254

https://pfq-static.com/img/badges/ground-4.png/t=1448590254

https://pfq-static.com/img/badges/ground-5.png/t=1448590254

https://pfq-static.com/img/badges/ground-6.png/t=1448590254

https://pfq-static.com/img/badges/ground-7.png/t=1448590254

https://pfq-static.com/img/badges/ground-8.png/t=1448590254

https://pfq-static.com/img/badges/ground-9.png/t=1448590254

https://pfq-static.com/img/badges/ground-10.png/t=1448590254

https://pfq-static.com/img/badges/ground-11.png/t=1448590254

https://pfq-static.com/img/badges/ground-12.png/t=1448590254

https://pfq-static.com/img/badges/ground-13.png/t=1448590254

Flying

https://pfq-static.com/img/badges/flying-1.png/t=1448590254

https://pfq-static.com/img/badges/flying-2.png/t=1448590254

https://pfq-static.com/img/badges/flying-3.png/t=1448590254

https://pfq-static.com/img/badges/flying-4.png/t=1448590254

https://pfq-static.com/img/badges/flying-5.png/t=1448590254

https://pfq-static.com/img/badges/flying-6.png/t=1448590254

https://pfq-static.com/img/badges/flying-7.png/t=1448590254

https://pfq-static.com/img/badges/flying-8.png/t=1448590254

https://pfq-static.com/img/badges/flying-9.png/t=1448590254

https://pfq-static.com/img/badges/flying-10.png/t=1448590254

https://pfq-static.com/img/badges/flying-11.png/t=1448590254

https://pfq-static.com/img/badges/flying-12.png/t=1448590254

https://pfq-static.com/img/badges/flying-13.png/t=1448590254

Psychic

https://pfq-static.com/img/badges/psychic-1.png/t=1448590254

https://pfq-static.com/img/badges/psychic-2.png/t=1448590254

https://pfq-static.com/img/badges/psychic-3.png/t=1448590254

https://pfq-static.com/img/badges/psychic-4.png/t=1448590254

https://pfq-static.com/img/badges/psychic-5.png/t=1448590254

https://pfq-static.com/img/badges/psychic-6.png/t=1448590254

https://pfq-static.com/img/badges/psychic-7.png/t=1448590254

https://pfq-static.com/img/badges/psychic-8.png/t=1448590254

https://pfq-static.com/img/badges/psychic-9.png/t=1448590254

https://pfq-static.com/img/badges/psychic-10.png/t=1448590254

https://pfq-static.com/img/badges/psychic-11.png/t=1448590254

https://pfq-static.com/img/badges/psychic-12.png/t=1448590254

https://pfq-static.com/img/badges/psychic-13.png/t=1448590254

Bug

https://pfq-static.com/img/badges/bug-1.png/t=1448590254

https://pfq-static.com/img/badges/bug-2.png/t=1448590254

https://pfq-static.com/img/badges/bug-3.png/t=1448590254

https://pfq-static.com/img/badges/bug-4.png/t=1448590254

https://pfq-static.com/img/badges/bug-5.png/t=1448590254

https://pfq-static.com/img/badges/bug-6.png/t=1448590254

https://pfq-static.com/img/badges/bug-7.png/t=1448590254

https://pfq-static.com/img/badges/bug-8.png/t=1448590254

https://pfq-static.com/img/badges/bug-9.png/t=1448590254

https://pfq-static.com/img/badges/bug-10.png/t=1448590254

https://pfq-static.com/img/badges/bug-11.png/t=1448590254

https://pfq-static.com/img/badges/bug-12.png/t=1448590254

https://pfq-static.com/img/badges/bug-13.png/t=1448590254

Rock

https://pfq-static.com/img/badges/rock-1.png/t=1448590254

https://pfq-static.com/img/badges/rock-2.png/t=1448590254

https://pfq-static.com/img/badges/rock-3.png/t=1448590254

https://pfq-static.com/img/badges/rock-4.png/t=1448590254

https://pfq-static.com/img/badges/rock-5.png/t=1448590254

https://pfq-static.com/img/badges/rock-6.png/t=1448590254

https://pfq-static.com/img/badges/rock-7.png/t=1448590254

https://pfq-static.com/img/badges/rock-8.png/t=1448590254

https://pfq-static.com/img/badges/rock-9.png/t=1448590254

https://pfq-static.com/img/badges/rock-10.png/t=1448590254

https://pfq-static.com/img/badges/rock-11.png/t=1448590254

https://pfq-static.com/img/badges/rock-12.png/t=1448590254

https://pfq-static.com/img/badges/rock-13.png/t=1448590254

Ghost

https://pfq-static.com/img/badges/ghost-1.png/t=1448590254

https://pfq-static.com/img/badges/ghost-2.png/t=1448590254

https://pfq-static.com/img/badges/ghost-3.png/t=1448590254

https://pfq-static.com/img/badges/ghost-4.png/t=1448590254

https://pfq-static.com/img/badges/ghost-5.png/t=1448590254

https://pfq-static.com/img/badges/ghost-6.png/t=1448590254

https://pfq-static.com/img/badges/ghost-7.png/t=1448590254

https://pfq-static.com/img/badges/ghost-8.png/t=1448590254

https://pfq-static.com/img/badges/ghost-9.png/t=1448590254

https://pfq-static.com/img/badges/ghost-10.png/t=1448590254

https://pfq-static.com/img/badges/ghost-11.png/t=1448590254

https://pfq-static.com/img/badges/ghost-12.png/t=1448590254

https://pfq-static.com/img/badges/ghost-13.png/t=1448590254

Dragon

https://pfq-static.com/img/badges/dragon-1.png/t=1448590254

https://pfq-static.com/img/badges/dragon-2.png/t=1448590254

https://pfq-static.com/img/badges/dragon-3.png/t=1448590254

https://pfq-static.com/img/badges/dragon-4.png/t=1448590254

https://pfq-static.com/img/badges/dragon-5.png/t=1448590254

https://pfq-static.com/img/badges/dragon-6.png/t=1448590254

https://pfq-static.com/img/badges/dragon-7.png/t=1448590254

https://pfq-static.com/img/badges/dragon-8.png/t=1448590254

https://pfq-static.com/img/badges/dragon-9.png/t=1448590254

https://pfq-static.com/img/badges/dragon-10.png/t=1448590254

https://pfq-static.com/img/badges/dragon-11.png/t=1448590254

https://pfq-static.com/img/badges/dragon-12.png/t=1448590254

https://pfq-static.com/img/badges/dragon-13.png/t=1448590254

Dark

https://pfq-static.com/img/badges/dark-1.png/t=1448590254

https://pfq-static.com/img/badges/dark-2.png/t=1448590254

https://pfq-static.com/img/badges/dark-3.png/t=1448590254

https://pfq-static.com/img/badges/dark-4.png/t=1448590254

https://pfq-static.com/img/badges/dark-5.png/t=1448590254

https://pfq-static.com/img/badges/dark-6.png/t=1448590254

https://pfq-static.com/img/badges/dark-7.png/t=1448590254

https://pfq-static.com/img/badges/dark-8.png/t=1448590254

https://pfq-static.com/img/badges/dark-9.png/t=1448590254

https://pfq-static.com/img/badges/dark-10.png/t=1448590254

https://pfq-static.com/img/badges/dark-11.png/t=1448590254

https://pfq-static.com/img/badges/dark-12.png/t=1448590254

https://pfq-static.com/img/badges/dark-13.png/t=1448590254

Steel

https://pfq-static.com/img/badges/steel-1.png/t=1448590254

https://pfq-static.com/img/badges/steel-2.png/t=1448590254

https://pfq-static.com/img/badges/steel-3.png/t=1448590254

https://pfq-static.com/img/badges/steel-4.png/t=1448590254

https://pfq-static.com/img/badges/steel-5.png/t=1448590254

https://pfq-static.com/img/badges/steel-6.png/t=1448590254

https://pfq-static.com/img/badges/steel-7.png/t=1448590254

https://pfq-static.com/img/badges/steel-8.png/t=1448590254

https://pfq-static.com/img/badges/steel-9.png/t=1448590254

https://pfq-static.com/img/badges/steel-10.png/t=1448590254

https://pfq-static.com/img/badges/steel-11.png/t=1448590254

https://pfq-static.com/img/badges/steel-12.png/t=1448590254

https://pfq-static.com/img/badges/steel-13.png/t=1448590254

Fairy

https://pfq-static.com/img/badges/fairy-1.png/t=1448590254

https://pfq-static.com/img/badges/fairy-2.png/t=1448590254

https://pfq-static.com/img/badges/fairy-3.png/t=1448590254

https://pfq-static.com/img/badges/fairy-4.png/t=1448590254

https://pfq-static.com/img/badges/fairy-5.png/t=1448590254

https://pfq-static.com/img/badges/fairy-6.png/t=1448590254

https://pfq-static.com/img/badges/fairy-7.png/t=1448590254

https://pfq-static.com/img/badges/fairy-8.png/t=1448590254

https://pfq-static.com/img/badges/fairy-9.png/t=1448590254

https://pfq-static.com/img/badges/fairy-10.png/t=1448590254

https://pfq-static.com/img/badges/fairy-11.png/t=1448590254

https://pfq-static.com/img/badges/fairy-12.png/t=1448590254

https://pfq-static.com/img/badges/fairy-13.png/t=1448590254

Go Team Breakneck Blitz! -> Score: 0

Lv. 100 — +7,498,418

Likes:

Dry food

27%

Mild nature

Poseidon ❤️ [MELANISTIC]

Lv. 100 — +8,505,824

Likes:

Any food

27%

Bashful nature

Avatar by TikiKat, for my use only

muffi

👍 0

Posted 21/Mar/2021 05:23:27 (3 years ago)

this is an awesome sheet, i love it! thanks a lot for sharing!!! <3

	Made by popcorn8784
	0/5000

Looking for jolly:

Blazebrem

👍 0

Posted 07/Apr/2021 11:22:04 (3 years ago)

Noticed that you got sandshrew but not alolan so checked the reference sheet and it says just sandshrew twice. May wanna fix that.

Blazey| She/Her | Asexual | UK My current focus is Wishforge/Dex, check my trade shop for Pairs etc. I am always happy for more as I don't have many. Will you give me a hug?

I hoard Snoms

Current Score: 0

Sig by Blazebrem

Lil-Peanut

👍 0

Posted 03/May/2021 17:30:55 (2 years ago)

when i try to use the table code, i get this and i have no idea what im doing =iferror(concatenate("[table][tr][th]Pokemon[/th][th]Type(s)[/th][th]Egg Code[/th][th]Exp[/th][th]Clicks[/th][/tr]",L5:L,"[/table]"))

angelatos

👍 1

Posted 29/Apr/2022 11:48:24 (2 years ago)
Edited 21/May/2022 05:38:00 (1 year ago)

I just spent the last few hours going through and adding all the missing pokemon + their types and img codes, so here you go^^ it should now have the rest of the alolan formes as well as the galar region and the exclusives/variants that weren't on there, and it also has a separate sheet to sort by type! edit: the correct link should be in there now, sorry about that! edit 2: there's now also a sheet to sort by EHP!

moth | they/them

Cannot post: Please log in to post

Loading...