Latest Big Version

Link to all my sheets

Welcome to my Imperial Sheet!

Please read the notes below.

1) File -> Make a copy

2) Go to the 'Setup' tab

cells with a note

General Notes

Structure of the Sheet

- Supported regions: PC: NA, EU, SA, SEA, TW, RU, MENA, TH, KR | Console: NA, EU

- Market prices update every 30 minutes. They're provided by Warflash's API.

Data can be input here.

- For questions or comments on the sheet, message me on Discord at Summer#8727.

Summary View: Shows imperial profits sorted by profit per box.

Imperial profits are calculated based on market prices and the item costs calculated in 'Recipes'.

- Lifeskill Discord

Dish/Elixir prices are calculated using item prices from the 'Prices' tab.

- Docs to help understand the formulas in this sheet: Vlookup, Named Ranges.

Item prices can be edited here.

Q: How is the cost to make a dish calculated?

Snow - For providing an awesome market API.

Eumel2 - For helping me build the sheet.

A: In the default config, all dishes are self-crafted from the ground up using market-bought raw materials.

Thell - For adding a way to cache market prices.

Warflash - For providing a public market price sheet.

Material prices as well as which dishes are self-crafted or bought can be adjusted in the 'Prices' tab.

Skooti - For the groundwork on being cool.

I took some inspiration for the SortedProfit tab from http://bdo.anbu.io/ :)

Q: Is the time spent crafting a dish to box worth compared to buying it?

A: Check the self-craft value of the dish (the profit compared to buying)

Q: Is it worthwhile to box cooking rare procs, e.g. crispy meat croquette?

A: Go to the 'Cooking - Imperial' tab and look at column P: 'Proc (Sale)' (may need to be expanded).

Is the profit shown in this column higher than the profit of the box you usually do? Yes->box the rare proc.

Q: Is there a market cooking or alch sheet?

↓ Change Log

Fixed the number of items required for Balacs Lunchbox (21->27) and Special Eilton Specialty Meal (21->39) guru boxes.

Added the new Mountain of Eternal Winter recipes and made custom prices in the 'Prices' tab taxable.

Fixed the recipe for steamed prawn (4 cooking honey -> 3 cooking wine)

Reworked the Time Cost field to be more intuitive.

Added items per box and cost per item columns to the SortedProfit tab thanks to a suggestion from Ringzero.

Added an FAQ section, reworked the time cost explanation in the 'Setup' tab.

fix by multiplying them with 1 or sth.)

Added a section for the profit per box compared to selling the dishes to the imperial table.

Integrated the new market API. Reworked the SortedProfit tab.

Lotta restructuring: Added a setup tab and separated the cooking/alch tabs into imperial and recipe tabs. Also changed the lookup method. Using VLOOKUP(X,Range,COLUMNS(Range)) now.

Added the option to not value imperial seals

orderd the yield data section.

Added the option to account for item quantities when buying.

time/cycle was hardcoded as 5 mins.

Removed the temporary custom prices for some items. Prices for all items should show up now.

Fixed the market count not showing up for some mats. (market count formula in the Prices tab wasn't filled in for all cells).

Added Ody recipes and boxes. Market cooking is now its own sheet.

Fixed the recipes for Coconut Fried Fish (Dough 3->2), Fried Vegetables (1 HQ/Special Hot Pepper->4 Vegetables), Steamed Prawn (HQ/Special Hot Pepper 2->1)

slot seeds was not penalized.

Fixed the error where in the daily profit table in Alchemy, CP was referenced instead of #boxes

Added tables for daily profit from imperials.

Fixed an error in the recipe for Elixir of Fury

Market cooking/alch section: The profit/h is now displayed independent of the time cost.

Corrected an error in the custom milk price calculation where tax could be applied twice.

Added the option to calculate the milk custom price from cream/butter in addition to cheese.

Added the new imperial seals, changed the cooking/alch setup.

Corrected the recipe for assorted side dishes (fruit: 4->5)

Removed a duplicate entry from the price table

Added the SortedProfitMarket tab.

Added market alch template. Unified some named ranges.

Added market quantities to the SortedProfit tab. Damn you Irbein and your useful suggestions.

Changed the lookup column for Total Crafts from hardcoded to named range.

Changed the profit/h in the market cooking section to display the true profit/h. Added 3 new columns to the recipe table.

Added the SortedProfitTab

Pulled the Acq. method into the price table

Changed the lookup method for almost everything again (:

Changed the lookup method in 'Prices'

Changed dried fish to use the price of a slightly cheaper dried fish

Revamped the cooking/alch setup.

Corrected the recipe for Serendia meals (1 egg -> 2 eggs).

Lots of cleanup stuff:

- Removed features which had a negligible effect on the accuracy of the sheet.

I hope this makes the sheet a little more accessible:

- Rare proc is now always sold in Make1Cost formula for cooking.

- Removed shining powder value for alchemy.