FFXIV Botany - Google Sheets

Loading... you may continue waiting or load this spreadsheet more quickly as a simple list

	A	B	C	D	E	F	G	H	I	J	K	L	M
1		Market Ward Category		NPC Value	Location(s) Found			Obtained By	Max Yield	Init. Remainder	Notch (Aim)	Chop (Approach)	Notes

2
3	Source:	Raldo Volca, Ridill server
4	Instructions:	Near the bottom of this page, there is a list of spreadsheets to choose from. Click on the spreadsheet for the zone you want information for and start gathering, or look for a specific item, then select your desired camp's spreadsheet!
5
6	Notes:	• Data is currently only compiled for Botany
7		• HQ items (+1) sell for 10% more than the NQ price (rounded down); only the NQ prices are listed here
8		• Clicking on a camp link will open the spreadsheet in a new browser tab (sorry, that's just how Google Spreadsheets work)
9		• Guildleve loot tables still have some old pre-1.21 data in them, so guildleve yields may not match my data.
10		• If you need assistance during guildleves, find the item(s) on this page, then scroll to the right for its details.
11		• Please send any questions/corrections/suggestions to my thread on the Lodestone forums -->					Click to visit thread
12
13		Grade 1	Grade 2	Grade 3	Grade 4	Grade 5
14	La Noscea regions:	Bearded Rock	Skull Valley	Bloodshore	Cedarwood	Iron Lake
15	Thanlan regions:	Black Brush	Drybone	Horizon	Nophica's Wells	Halatali
16	Black Shroud regions:	Bentbranch	Emerald Moss	Tranquil	Humblehearth	Treespeak	Nine Ivies
17	Coerthas regions:	N/A	N/A	N/A	Glory	Dragonhead
18
19	Latest update:	All spreadsheets are now updated to patch 1.22a data. Enjoy! (I'm still active and updating, but nothing changed in 1.23)
20
21	All-purpose Blue Dye	Chirugeons >> Dye		32	Bearded Rock	Skull Valley	Bloodshore	Harvesting	1				NQ only
22	All-purpose Blue Dye	Chirugeons >> Dye		32	Cedarwood	Iron Lake		Harvesting	1				NQ only
23	All-purpose Green Dye	Chirugeons >> Dye		32	Bentbranch	Emerald Moss	Tranquil	Harvesting	1				NQ only
24	All-purpose Green Dye	Chirugeons >> Dye		32	Humblehearth	Treespeak		Harvesting	1				NQ only
25	All-purpose Grey Dye	Chirugeons >> Dye		32	Black Brush	Drybone	Horizon	Harvesting	1				NQ only
26	All-purpose Grey Dye	Chirugeons >> Dye		32	Nophica's Wells	Halatali		Harvesting	1				NQ only
27	Almonds	Grocers >> Spice		58	Nophica's Wells			Harvesting	4
28	Aloe	Grocers >> Fruit		50	Horizon			Logging	3	60%	1	40%
29	Alpine Parsnip	Grocers >> Vegetable		27	Emerald Moss			Harvesting	3
30	Ash Branch	Woodcutters >> Raw Wood		81	Bearded Rock	Skull Valley		Logging	4	75%	-3	75%
31	Ash Log	Woodcutters >> Raw Wood		142	Bearded Rock	Skull Valley	Drybone	Logging	3	75%	-2	65%	Drybone: Only found on cacti
32	Belladonna	Grocers >> Spice		179	Skull Valley	Drybone		Logging, Harvesting	4	75%	-2	0%	Logging: Only found on cacti
33	Black Truffle	Grocers >> Mushroom		122	Treespeak			Harvesting	3
34	Blood Currants	Grocers >> Fruit		53	Bloodshore			Harvesting	3
35	Button Mushroom	Grocers >> Mushroom		55	Tranquil			Harvesting	3
36	Chantarelle	Grocers >> Mushroom		14	Bentbranch			Harvesting	3
37	Chocobo Feather	Clothiers >> Feather		168	Glory	Dragonhead		Logging	3	85%	3	75%
38	Cieldalaes Spinach	Grocers >> Vegetable		33	Emerald Moss			Harvesting	3
39	Cinderfoot Olive	Grocers >> Fruit		29	Skull Valley	Bloodshore	Black Brush	Logging, Harvesting	4	85%	1	40%
40	Cloves	Grocers >> Spice		27	Bloodshore			Logging	4	85%	-4	0%
41	Cock Feather	Clothiers >> Feather		19	Bearded Rock	Skull Valley		Logging	4	85%	-1	75%
42	Coerthas Carrot	Grocers >> Vegetable		22	Bearded Rock			Logging	4	75%	-3	50%
43	Cotton Boll	Clothiers >> Fiber		26	Black Brush	Drybone	Horizon	Harvesting	5
44	Cotton Boll	Clothiers >> Fiber		26	Nophica's Wells	Halatali		Harvesting	5
45	Crawler Cocoon	Clothiers >> Fiber		274	Dragonhead			Harvesting	1
46	Crow Feather	Clothiers >> Feather		48	Black Brush	Drybone		Logging	4	85%	-2	75%
47	Decayed Matter	Crystaliers >> Catalyst		29	Humblehearth			Logging	1	75%	5	50%	Fingerprints of the Gods, NQ only
48	Decomposed Matter	Crystaliers >> Catalyst		39	Iron Lake			Logging	1	75%	5	50%	Fingerprints of the Gods, NQ only
49	Desert Saffron	Grocers >> Spice		79	Halatali			Harvesting	4
50	Dragon Pepper	Grocers >> Spice		58	Cedarwood	Nophica's Wells	Halatali	Logging	4	75%	-3	50%
51	Elm Log	Woodcutters >> Raw Wood		176	Black Brush	Drybone	Horizon	Logging	3	75%	0	50%
52	Faerie Apple	Grocers >> Fruit		36	Emerald Moss			Logging	4	75%	2	50%
53	Flax	Clothiers >> Fiber		54	Humblehearth	Treespeak	Glory	Harvesting	7
54	Flax	Clothiers >> Fiber		54	Dragonhead			Harvesting	7
55	Garlean Garlic	Grocers >> Spice		9	Bearded Rock	Bloodshore	Black Brush	Harvesting	4
56	Garlean Garlic	Grocers >> Spice		9	Horizon			Harvesting	4
57	Germinated Matter	Crystaliers >> Catalyst		9	Tranquil			Logging	1	75%	5	50%	Fingerprints of the Gods, NQ only
58	Gridanian Walnut	Grocers >> Fruit		14	Bloodshore	Cedarwood	Emerald Moss	Logging	4	85%	-1	25%
59	Gysahl Greens	Grocers >> Vegetable		47	Glory	Dragonhead		Harvesting	1
60	Highland Parsley	Grocers >> Vegetable		24	Bearded Rock			Harvesting	4
61	Iron Acorn	Grocers >> Fruit		79	Humblehearth	Dragonhead		Logging	3	85%	-2	75%
62	Kukuru Bean	Grocers >> Fruit		19	Black Brush			Logging	4	75%	-3	0%
63	La Noscean Lettuce	Grocers >> Vegetable		29	Skull Valley			Harvesting	3
64	La Noscean Orange	Grocers >> Fruit		14	Bearded Rock			Logging	4	75%	3	25%
65	Latex	Chirugeons >> Raegent		19	Black Brush	Drybone	Horizon	Logging	4	75%	1	60%
66	Laurel	Grocers >> Spice		59	Iron Lake			Harvesting	4
67	Lavender	Grocers >> Spice		153	Emerald Moss			Logging	4	75%	-2	50%
68	Liquified Matter	Crystaliers >> Catalyst		44	Halatali			Logging	1	75%	5	50%	Fingerprints of the Gods, NQ only
69	Lowland Grapes	Grocers >> Fruit		7	Bentbranch			Harvesting	3
70	Mahogany Log	Woodcutters >> Raw Wood		344	Iron Lake			Logging	1	60%	3	0%
71	Mandrake	Grocers >> Spice		307	Humblehearth			Harvesting	4
72	Maple Branch	Woodcutters >> Raw Wood		52	Bentbranch	Emerald Moss		Logging	4	75%	-1	50%
73	Maple Log	Woodcutters >> Raw Wood		92	Bentbranch	Emerald Moss		Logging	3	85%	-2	60%
74	Maple Sap	Chirugeons >> Raegent		140	Bentbranch	Emerald Moss		Logging	4	85%	0	40%
75	Marjoram	Grocers >> Spice		29	Skull Valley	Nophica's Wells	Halatali	Harvesting	4
76	Matron's Mistletoe	Grocers >> Spice		307	Tranquil			Logging, Harvesting	2	85%	1	0%
77	Midland Basil	Grocers >> Spice		41	Bloodshore			Harvesting	4
78	Midland Cabbage	Grocers >> Vegetable		59	Tranquil			Harvesting	4
79	Mistletoe	Grocers >> Spice		589	Treespeak			Logging	2	85%	1	0%
80	Moko Grass	Clothiers >> Fiber		12	Bearded Rock	Skull Valley	Bloodshore	Harvesting	5
81					Cedarwood	Bentbranch	Emerald Moss
82					Tranquil	Glory	Dragonhead
83	Nopales	Grocers >> Vegetable		41	Drybone			Logging	3	75%	3	25%	Only found on cacti
84	Nutmeg	Grocers >> Spice		63	Nophica's Wells			Logging	4	75%	-3	65%
85	Oak Branch	Woodcutters >> Raw Wood		158	Treespeak	Glory	Nine Ivies	Logging	5	85%	0	85%
86	Oak Log	Woodcutters >> Raw Wood		277	Iron Lake	Treespeak	Glory	Logging	3	75%	-1	75%
87	Oak Log	Woodcutters >> Raw Wood		277	Nine Ivies			Logging	3	75%	-1	75%
88	Paprika	Grocers >> Spice		28	Drybone	Horizon		Harvesting	3
89	Pearl Ginger	Grocers >> Spice		7	Black Brush	Horizon		Harvesting	3
90	Popoto	Grocers >> Vegetable		41	Emerald Moss			Harvesting	4
91	Ramhorn Zucchini	Grocers >> Vegetable		31	Drybone			Harvesting	3
92	Resin	Chirugeons >> Raegent		588	Nine Ivies			Logging	3	60%	2	75%
93	Rolanberry	Grocers >> Fruit		101	Treespeak			Harvesting	3
94	Rosewood Branch	Woodcutters >> Raw Wood		220	Halatali			Logging	3	60%	-1	65%
95	Rosewood Log	Woodcutters >> Raw Wood		386	Halatali			Logging	1	60%	-2	75%
96	Ruby Tomato	Grocers >> Vegetable		36	Skull Valley	Bloodshore		Harvesting	4
97	Rye	Grocers >> Grain		7	Emerald Moss			Harvesting	4
98	Sagolii Sage	Grocers >> Spice		76	Cedarwood	Iron Lake		Logging, Harvesting	4	75%	-5	0%
99	Salt Leek	Grocers >> Vegetable		74	Cedarwood	Humblehearth		Logging, Harvesting	4	85%	-1	0%
100	Spruce Log	Woodcutters >> Raw Wood		320	Dragonhead			Logging	1	60%	-3	80%

Account Options>