Guild Wars 2

Hello ! I don’t think there’s any explanation required. Want to craft with profit but bored with calculating everything every time? Want to check if it’s worth crafting yourself for your ascended gear or you’ll be better off with just buying component from tp? This sheet will make your life easier
I double checked everything, but there still may be some mistakes (report in topic if you find any!) so I’m not refunding any money lost Profit cells are calculated with sell tax.
If 500 cooking/jeweler will come with its new materials, I’ll try to update them as fast as possible.
Prices are based on GW2Spidy

https://docs.google.com/spreadsheets/d/1g0S93uLKpNMKQ1hfEoNx5EMvx3wQ3qOUXO3-1yUFBhg/edit?usp=sharing

“Crafting profit” is counted wrong. It should be “Sell Price*0.85-Craft Price” instead of “Sell Price-Craft Price*1.15”

ow kitten . my bad
..
anyone experienced with g2spidy based sheets can possible help me with auto-refreshing?

I would suggest to make the columns skinnier (maybe make the titles be on 2+ rows?)
Also, there are times when buying bolts of silk (for example) are cheaper than buying the silk scraps. You might want to take that into account?