Gatabud

Sports, Tech, Gaming, and helping YOU.

Creator of Home Stadium app.

Pro Software Engineer & Computer Science + MBA Georgia Southern Double Eagle

[Gatabud @Gatabud]

I've been running some interesting data analytics projects on FFXIV. I am an extreme gil maker and that dates back to 2.0 by having the maximum number of retainers and I crank out crafter scrips in mass. There are so many questions I have always thought I had the answer to:

- How Many Retainers of each type is ideal
- What Purple or Orange recipe to target
- What to sell once scrips are secured

My configuration is all max stats
- 3 Botanist
- 2 Miner
- 3 Hunter
- 1 Fisher

My home base is Aether, and I have been running some python code to answer this question definitively.

I loaded all of the market data into Redis from Universalis of all Scrip and venture items.

I scraped all of the wiki sites to regenerate all of the recipes into a data store.

Orange was exactly what i thought it would be:
Rarefied Tacos de Carne Asada (CUL Lv100) | 337117 net gil/hr
25.00 crafts/hr | 3600 scrip/hr | 360000 gross gil/hr | 22883 buy cost/hr | 62.3% retainer material coverage
Scrip value: 100.00 gil/scrip via manual override
Retainers:
botany: 1 x Dark Rye (50 each/hr, profile.dol_profile_5820_perception)
botany: 1 x White Pepper (50 each/hr, profile.dol_profile_5820_perception)
botany: 1 x Yyasulani Garlic (50 each/hr, profile.dol_profile_5820_perception)
fishing: 1 x Water Crystal via Megapiranha desynth (62.50 each/hr, profile.supplemental_supply_sources.desynthesis_conversion)
hunting: 3 x Rroneek Chuck (15 each/hr, profile.combat_i730_plus)
mining: 2 x Fire Crystal (120 each/hr, profile.supplemental_supply_sources.direct_venture)
Market board compensation:
Dark Rye: buy 50.00/hr x 200 = 10000/hr (retainer deficit)
Water Crystal: buy 137.50/hr x 50 = 6875/hr (crystals)
Fire Crystal: buy 93.33/hr x 55 = 5133/hr (crystals)
Rroneek Chuck: buy 5.00/hr x 175 = 875/hr (retainer deficit)
Rate driver:
Yyasulani Garlic exactly consumed at 50.00/hr

Purple was interesting....

Purple winner: Rarefied Stuffed Peppers (CUL Lv99) | 321108 net gil/hr
16.67 crafts/hr | 3300 scrip/hr | 330000 gross gil/hr | 8892 buy cost/hr | 79.9% retainer material coverage
Scrip value: 100.00 gil/scrip via manual override
Retainers:
botany: 1 x Bell Pepper (50 each/hr, profile.dol_profile_5820_perception)
botany: 1 x Turali Corn (50 each/hr, profile.dol_profile_5820_perception)
botany: 1 x Ut'ohmu Tomato (50 each/hr, profile.dol_profile_5820_perception)
fishing: 1 x Water Crystal via Megapiranha desynth (62.50 each/hr, profile.supplemental_supply_sources.desynthesis_conversion)
hunting: 3 x Alpaca Fillet (15 each/hr, profile.combat_i730_plus)
mining: 2 x Fire Crystal (120 each/hr, profile.supplemental_supply_sources.direct_venture)
Market board compensation:
Water Crystal: buy 70.83/hr x 50 = 3542/hr (crystals)
Dragon Pepper: buy 11.11/hr x 200 = 2222/hr (not assigned / not venture-sourced)
Ut'ohmu Tomato: buy 5.56/hr x 299 = 1661/hr (retainer deficit)
Fire Crystal: buy 26.67/hr x 55 = 1467/hr (crystals)
Rate driver:
Bell Pepper exactly consumed at 50.00/hr

Purple #2: Rarefied Gargantuaskin Trousers (LTW Lv99) | 259785 net gil/hr
15.00 crafts/hr | 2970 scrip/hr | 297000 gross gil/hr | 37215 buy cost/hr | 65.5% retainer material coverage
Scrip value: 100.00 gil/scrip via manual override
Retainers:
botany: 1 x Acacia Bark (50 each/hr, profile.dol_profile_5820_perception)
botany: 2 x Levinsilk (50 each/hr, profile.dol_profile_5820_perception)
fishing: 1 idle/external
hunting: 3 x Gargantua Hide (15 each/hr, profile.combat_i730_plus)
mining: 1 x Fire Crystal (120 each/hr, profile.supplemental_supply_sources.direct_venture)
mining: 1 x Magnesia Powder (50 each/hr, profile.dol_profile_5820_perception)
Market board compensation:
Earth Crystal: buy 360.00/hr x 42 = 15120/hr (crystals)
Ra'Kaznar Ore: buy 75.00/hr x 115 = 8625/hr (not assigned / not venture-sourced)
Wind Crystal: buy 120.00/hr x 71 = 8520/hr (crystals)
Gargantua Hide: buy 75.00/hr x 34 = 2550/hr (retainer deficit)
Lightning Crystal: buy 120.00/hr x 20 = 2400/hr (crystals)
Rate driver:
Fire Crystal exactly consumed at 120.00/hr

Purple #3: Rarefied Draught (ALC Lv89) | 252975 net gil/hr
25.00 crafts/hr | 2700 scrip/hr | 270000 gross gil/hr | 17025 buy cost/hr | 62.8% retainer material coverage
Scrip value: 100.00 gil/scrip via manual override
Retainers:
botany: 3 x Light Gerbera (50 each/hr, profile.dol_profile_5820_perception)
fishing: 1 x Water Crystal via Megapiranha desynth (62.50 each/hr, profile.supplemental_supply_sources.desynthesis_conversion)
hunting: 3 x Berkanan Sap (15 each/hr, profile.combat_i730_plus)
mining: 2 x Ambrosial Water (50 each/hr, profile.dol_profile_5820_perception)
Market board compensation:
Water Crystal: buy 137.50/hr x 50 = 6875/hr (crystals)
Berkanan Sap: buy 30.00/hr x 205 = 6150/hr (retainer deficit)
Lightning Crystal: buy 200.00/hr x 20 = 4000/hr (crystals)
Rate driver:
Ambrosial Water exactly consumed at 100.00/hr

Purple #4: Rarefied Thunderyards Silk Gloves (WVR Lv99) | 249355 net gil/hr
15.00 crafts/hr | 2970 scrip/hr | 297000 gross gil/hr | 47645 buy cost/hr | 67.8% retainer material coverage
Scrip value: 100.00 gil/scrip via manual override
Retainers:
botany: 1 x Acacia Bark (50 each/hr, profile.dol_profile_5820_perception)
botany: 2 x Levinsilk (50 each/hr, profile.dol_profile_5820_perception)
fishing: 1 idle/external
hunting: 3 x Gargantua Hide (15 each/hr, profile.combat_i730_plus)
mining: 1 x Fire Crystal (120 each/hr, profile.supplemental_supply_sources.direct_venture)
mining: 1 x Magnesia Powder (50 each/hr, profile.dol_profile_5820_perception)
Market board compensation:
Levinsilk: buy 50.00/hr x 355 = 17750/hr (retainer deficit)
Ra'Kaznar Ore: buy 75.00/hr x 115 = 8625/hr (not assigned / not venture-sourced)
Wind Crystal: buy 120.00/hr x 71 = 8520/hr (crystals)
Lightning Crystal: buy 360.00/hr x 20 = 7200/hr (crystals)
Earth Crystal: buy 120.00/hr x 42 = 5040/hr (crystals)
Gargantua Hide: buy 15.00/hr x 34 = 510/hr (retainer deficit)
Rate driver:
Fire Crystal exactly consumed at 120.00/hr

Purple #5: Rarefied Banana Ponzecake (CUL Lv93) | 231331 net gil/hr
16.67 crafts/hr | 2367 scrip/hr | 236667 gross gil/hr | 5336 buy cost/hr | 82.9% retainer material coverage
Scrip value: 100.00 gil/scrip via manual override
Retainers:
botany: 1 x Royal Maple Sap (50 each/hr, profile.dol_profile_5820_perception)
botany: 1 x Upland Wheat (50 each/hr, profile.dol_profile_5820_perception)
botany: 1 x Wild Ja Tiika Bananas (50 each/hr, profile.dol_profile_5820_perception)
fishing: 1 x Water Crystal via Megapiranha desynth (62.50 each/hr, profile.supplemental_supply_sources.desynthesis_conversion)
hunting: 3 x Egg of Elpis (15 each/hr, profile.combat_i730_plus)
mining: 2 x Fire Crystal (120 each/hr, profile.supplemental_supply_sources.direct_venture)
Market board compensation:
Water Crystal: buy 54.17/hr x 50 = 2708/hr (crystals)
Royal Maple Sap: buy 16.67/hr x 88 = 1467/hr (retainer deficit)
Fire Crystal: buy 21.11/hr x 55 = 1161/hr (crystals)
Rate driver:
Wild Ja Tiika Bananas exactly consumed at 50.00/hr

The fact that my go to lv97 alch recipe Tisane was pretty eye opening. I just have been doing that mindlessly because it has no sub crafts that I have been gimping my gil making ability. This however prompted me to do an alternate way to calculate this with a "Lazy mode" based on coverage metrics. This was the result:

Purple winner: Rarefied Gemdraught of Vitality (ALC Lv99) | 695403 net gil/hr
22.50 crafts/hr | 4455 scrip/hr | 712978 gross gil/hr | 17575 buy cost/hr | 100.0% retainer material coverage
Total retainer support incl. crystals: 42.5% | Subcrafts: 1 | Active retainers: 9
Scrip value: 160.04 gil/scrip via Carbon Fiber
Retainers:
botany: 3 x Windsbalm Bay Leaf (40 each/hr, profile.item_quantity_overrides)
fishing: 1 x Water Crystal via Megapiranha desynth (62.50 each/hr, profile.supplemental_supply_sources.desynthesis_conversion)
hunting: 3 x Tumbleclaw Weeds (15 each/hr, profile.combat_i730_plus)
mining: 2 x Yak T'el Spring Water (50 each/hr, profile.dol_profile_5820_perception)
Market board compensation:
Water Crystal: buy 297.50/hr x 50 = 14875/hr (crystals)
Lightning Crystal: buy 180.00/hr x 14 = 2520/hr (crystals)
Axe Beak Wing: buy 90.00/hr x 2 = 180/hr (not assigned / not venture-sourced)
Rate driver:
Tumbleclaw Weeds exactly consumed at 45.00/hr

Purple #2: Rarefied Cunning Craftsman's Tisane (ALC Lv97) | 305242 net gil/hr
11.25 crafts/hr | 1924 scrip/hr | 307877 gross gil/hr | 2635 buy cost/hr | 100.0% retainer material coverage
Total retainer support incl. crystals: 86.4% | Subcrafts: 0 | Active retainers: 9
Scrip value: 160.04 gil/scrip via Carbon Fiber
Retainers:
botany: 3 x Pearl Grass (40 each/hr, profile.item_quantity_overrides)
fishing: 1 x Water Crystal via Megapiranha desynth (62.50 each/hr, profile.supplemental_supply_sources.desynthesis_conversion)
hunting: 3 x Tumbleclaw Weeds (15 each/hr, profile.combat_i730_plus)
mining: 2 x Yak T'el Spring Water (50 each/hr, profile.dol_profile_5820_perception)
Market board compensation:
Water Crystal: buy 27.50/hr x 50 = 1375/hr (crystals)
Lightning Crystal: buy 90.00/hr x 14 = 1260/hr (crystals)
Rate driver:
Tumbleclaw Weeds exactly consumed at 45.00/hr

Purple #3: Rarefied Sykon Bavarois (CUL Lv90) | 295899 net gil/hr
16.67 crafts/hr | 1900 scrip/hr | 304076 gross gil/hr | 8177 buy cost/hr | 100.0% retainer material coverage
Total retainer support incl. crystals: 70.4% | Subcrafts: 2 | Active retainers: 9
Scrip value: 160.04 gil/scrip via Carbon Fiber
Retainers:
botany: 2 x Palm Syrup (50 each/hr, profile.dol_profile_5820_perception)
botany: 1 x Sykon (50 each/hr, profile.dol_profile_5820_perception)
fishing: 1 x Brass Loach (12 each/hr, venture.quantity_tiers)
hunting: 1 x Bat Wing (15 each/hr, profile.combat_i730_plus)
hunting: 2 x Ovibos Milk (15 each/hr, profile.combat_i730_plus)
mining: 2 x Fire Crystal (120 each/hr, profile.supplemental_supply_sources.direct_venture)
Market board compensation:
Water Crystal: buy 133.33/hr x 50 = 6667/hr (crystals)
Fire Crystal: buy 26.67/hr x 48 = 1280/hr (crystals)
Fire Shard: buy 3.33/hr x 69 = 230/hr (crystals)
Rate driver:
Palm Syrup exactly consumed at 100.00/hr

Purple #4: Rarefied Banana Ponzecake (CUL Lv93) | 282821 net gil/hr
12.50 crafts/hr | 1775 scrip/hr | 284071 gross gil/hr | 1250 buy cost/hr | 100.0% retainer material coverage
Total retainer support incl. crystals: 93.8% | Subcrafts: 2 | Active retainers: 9
Scrip value: 160.04 gil/scrip via Carbon Fiber
Retainers:
botany: 1 x Royal Maple Sap (50 each/hr, profile.dol_profile_5820_perception)
botany: 1 x Upland Wheat (50 each/hr, profile.dol_profile_5820_perception)
botany: 1 x Wild Ja Tiika Bananas (50 each/hr, profile.dol_profile_5820_perception)
fishing: 1 x Water Crystal via Megapiranha desynth (62.50 each/hr, profile.supplemental_supply_sources.desynthesis_conversion)
hunting: 3 x Egg of Elpis (15 each/hr, profile.combat_i730_plus)
mining: 2 x Fire Crystal (120 each/hr, profile.supplemental_supply_sources.direct_venture)
Market board compensation:
Water Crystal: buy 25.00/hr x 50 = 1250/hr (crystals)
Rate driver:
Royal Maple Sap exactly consumed at 50.00/hr

Purple #5: Rarefied Draught (ALC Lv89) | 254710 net gil/hr
15.00 crafts/hr | 1620 scrip/hr | 259265 gross gil/hr | 4555 buy cost/hr | 100.0% retainer material coverage
Total retainer support incl. crystals: 78.7% | Subcrafts: 0 | Active retainers: 9
Scrip value: 160.04 gil/scrip via Carbon Fiber
Retainers:
botany: 3 x Light Gerbera (50 each/hr, profile.dol_profile_5820_perception)
fishing: 1 x Water Crystal via Megapiranha desynth (62.50 each/hr, profile.supplemental_supply_sources.desynthesis_conversion)
hunting: 3 x Berkanan Sap (15 each/hr, profile.combat_i730_plus)
mining: 2 x Ambrosial Water (50 each/hr, profile.dol_profile_5820_perception)
Market board compensation:
Water Crystal: buy 57.50/hr x 50 = 2875/hr (crystals)
Lightning Crystal: buy 120.00/hr x 14 = 1680/hr (crystals)
Rate driver:
Berkanan Sap exactly consumed at 45.00/hr

[Gatabud @Gatabud]

@brockpierson Thanks for the offer, but it's my wife and I's anniversary and I'd prefer not to be blown by strangers 🤣🤣🤣🤣

[Gatabud @Gatabud]

Grand Theft Auto VI cost about as much as Mercedes Benz Stadium. Let that sink in

Hopefully I have more fun playing GTA than I do watching my Atlanta falcons lose

[Gatabud @Gatabud]

@Opereth I have quite a few dated ones on my IG but I'm working on a complete 2026 cave tour video for here and YouTube

[Gatabud @Gatabud]

What is the point of a Steam Machine?

[Gatabud @Gatabud]

@RealKyleOhio While utilizing a comparability layer to translate windows instructions into Linux instructions. I'd love to run tests on that and see what the pros / cons of that approach is as a software engineer

[Gatabud @Gatabud]

@puzzud It sorta is but it sorta isn't.

[Gatabud @Gatabud]

@yataktyni

[Gatabud @Gatabud]

@ThePharticusMax I'm training AI models with it?

My monitors back there are old 1080p cheap ones, they use a small fraction of its power playing FFXI and FFXIV when I do actually play games on it.

I'm a software engineer working on several projects and business entities.

[Gatabud @Gatabud]

@FinalFantasy Is this upgrade coming to PS5 and Xbox? Would love to speed up on my ps5

[Gatabud @Gatabud]

@JimboMint It's cool. Come drink beer and watch 4 football games at the same time with me and my buddies this fall

[Gatabud @Gatabud]

@JTBibito Married with 3 kids. Today's my 9th anniversary actually. She controls the other 2 floors in the house, I get to do what I want down here in the cave

[Gatabud @Gatabud]

@X560562207114 Yeah I suck

[Gatabud @Gatabud]

@yawn_io Nope I just slam the door

[Y3LLOWVESTS @Y3LLOWVESTS]

@Gatabud I think the newer generation has the same pc skills as boomers do (they are computer illiterate oddly enough)

[Gatabud @Gatabud]

@Y3LLOWVESTS I'm noticing this with my children. I was trying to figure out how to explain what the Internet is. They don't even notice connectivity and everything just magically works

[Gatabud @Gatabud]

@ThePharticusMax "Business Expense" was my justification

[Gatabud @Gatabud]

@OyasumiBastet I'm trolling

[Gatabud @Gatabud]

@Farris214 I'm trolling you

[Gatabud @Gatabud]

@SmoothNinja100 I don't know why I get myself so worked up when trying to communicate. Probably a tism thing. Something I'm working on

[Gatabud @Gatabud]

@GradStolen You just described a ps5

[Gatabud @Gatabud]

@LLAMADrama2891