New Update out on the spreadsheet! New packs & Routes included! File - Make A Copy - To get your own editable file! docs.google.com/spreadsheets/d/15qRJ114rFRzPAZ2K0EDdbQdEGY9dZXHfI_JvsPjl8dE/edit?usp=sharing
Hey @JimpahGG - why does the spreadsheet says "Warning: Some formulas are trying to send and receive data from external parties." on the top? thank you
hey man, I am so grateful for your excell sheet One suggestion I have that would help a lot, if you dont mind, is that if you could add a line with all the costs of the packs. thats the most important info to look at in my opinion when I am comparing the price of the packs, so it would be very helpful if they are lined up because that way I do less maths and I can make more runs. Just like you did with the profit line, do like a cost line with all packs on it
also preferably, if you consider to att that, it is cool if it is in crescent order like the cheapest pack to the most expensive pack all packs sell for the same money, but they have different cost, so we have to compare less things
Hey man! Thanks for your comment! :) I did actually fix the sheet today couple hours ago, now all the numbers should count correctly and I do have a total sell value box aswell! At the moment it doesnt have this extra feature that sort by the most profitable, may come in near future, but at least it changes color, so the greener it is the more profit, hope you'll enjoy it! :)
The most valuable thing people can do to me right now is keep liking my videos, comment and subscribe. In that way I can keep my videos in the algoritm :)
It would be nice if you could include in a future update the route Seabreeze > Darzuac as it is the most profitable when you can use the certificates, usually a better percentage than Seabreeze > Defiance. Also even though Seabreeze > Darzuac is a long route, from what i notice you don't get crazy percentage swings in a short period of time (which can risk all of your profit calculations). Probably due to the fact that you don't have that many low level character running darzuac as they do Defiance.
Great content, my dude! edit: the "Strawberry Cakes" formula is wrong - you're not calculating the first item (D53). This is also happening with "Butcher's Box". Kindly check that! thanks!
@@JimpahGG Hey Jimpah - another tip if I may. I noticed I was struggling to find each item's value on the sheet to update it. So I've ordered the 'master value table' it from A-Z to simplify this. So instead of modifying manually all formulas that selected these values, I've made a VLOOKUP formula that finds the item name and it's current value, so right now my "master" table is nice and ordered. Let me know if you want it, I can share it with you! thanks
Amazing, thank you! Do we need to be in warchannel before crafting the pack? Or can we run on normal channel, put in warehouse at destination, move to warchannel, and then sell?
Hi! Thanks for the video! Tell me, is it possible to carry these packages on a secure channel? And how are you doing with the percentage on your server?
Hello! During peace time it's safe to run with wagon across the map, but make sure it is peace in all the zones you are corssing! On the water it is always PVP on, but it's also the most money to grab!
Is there any guide how I can get items for Tradepack creation? I dont know where to find Stones for example or coal. I need 3x items for on tradepack and its hard to get... Thanks for ana naswer!
If you want easy money try fishing, you need 3 things, a ship, a fish stick and fishing hook -> all of that you will get by completing quests. Then find on the sea some fishes (you will notice a special places for fishing). Then you can sell them to the MAN FISH BROKER nearby warehouses - but that man is not in every town. or go to cut wood and sell it on the market. Stones, copper ore or coal you can get from the mine, but there are creatures so you need to be able to kill them. First of all DO THE QUESTS and that will teach you all of the things.
Most basic is learnt through the introduction, like woodcutting will give you logs, mining will give you, stone, copper ore, coal etc. But if you have a small volume I recommend to run something like the Slums package that requires only about 7k to craft and almost always like 4-6k profit as well you can start building bank!
No, you can stock them up in every one of them, but keep in mind as soon as you leave the dock and there is packages ready in that werehouse you will bring max limit with you!
You won't get the bonus if you do so! What I haven't tested is if you craft for example 10 pack in warchannel - go to normal, run to them to the raven werehouse for example and then again swap to warchannel and deliver! That could work!
The base value equation is: (8 x Tiles) + 12000 = BASE VALUE OF PACKAGE But if you use the spreadsheet, you just use the dropdown menu and choose your route :)
GOOD GOT EVEN BETTER! SPREADSHEET NOW HAS A LIST TO CHOOSE ROUTE IN AND ALSO CHECK BOXES FOR BONUS %, CHECK IT OUT! docs.google.com/spreadsheets/d/15qRJ114rFRzPAZ2K0EDdbQdEGY9dZXHfI_JvsPjl8dE/edit#gid=428975624
You shouldn't look blindly at the percent at seabreeze, you should check at the sell point! So if you decide to go the Seabreeze to Ravencrest, you look at both and decide which way gives more profit if Seabreeze is 70% and Raven is 110% you would of course create your package in Seabreeze and go to Raven, the tiles are still the same so it has the same base value! :) Hope it made it a bit more clear for you :)
New Update out on the spreadsheet! New packs & Routes included!
File - Make A Copy - To get your own editable file!
docs.google.com/spreadsheets/d/15qRJ114rFRzPAZ2K0EDdbQdEGY9dZXHfI_JvsPjl8dE/edit?usp=sharing
Please add Defiance - Tarmire route ti spreadsheet
Hey @JimpahGG - why does the spreadsheet says "Warning: Some formulas are trying to send and receive data from external parties." on the top? thank you
hey man, I am so grateful for your excell sheet
One suggestion I have that would help a lot, if you dont mind, is that if you could add a line with all the costs of the packs.
thats the most important info to look at in my opinion when I am comparing the price of the packs, so it would be very helpful if they are lined up
because that way I do less maths and I can make more runs.
Just like you did with the profit line, do like a cost line with all packs on it
also preferably, if you consider to att that, it is cool if it is in crescent order like the cheapest pack to the most expensive pack
all packs sell for the same money, but they have different cost, so we have to compare less things
Hey man! Thanks for your comment! :)
I did actually fix the sheet today couple hours ago, now all the numbers should count correctly and I do have a total sell value box aswell! At the moment it doesnt have this extra feature that sort by the most profitable, may come in near future, but at least it changes color, so the greener it is the more profit, hope you'll enjoy it! :)
Thanks so much for sharing this. It's really kind. You should ask for in game donations for sharing the Google doc. I'd pay 5k silver for it. 😂
The most valuable thing people can do to me right now is keep liking my videos, comment and subscribe. In that way I can keep my videos in the algoritm :)
Easy brother -done!
Un millon de gracias bro, no sabes cuanto me ayudas con esto
I'm glad it helped you! :)
so much helpful info tysm for this!!
Thank you for this comment! :)
It would be nice if you could include in a future update the route Seabreeze > Darzuac as it is the most profitable when you can use the certificates, usually a better percentage than Seabreeze > Defiance.
Also even though Seabreeze > Darzuac is a long route, from what i notice you don't get crazy percentage swings in a short period of time (which can risk all of your profit calculations). Probably due to the fact that you don't have that many low level character running darzuac as they do Defiance.
Thank you for your sharp eye! I thought I'd added all of 'em! :) It is now updated!
Again, great content, thank you!
Appreciate it man!
Great content, my dude!
edit: the "Strawberry Cakes" formula is wrong - you're not calculating the first item (D53). This is also happening with "Butcher's Box". Kindly check that! thanks!
Hey! Thanks for the headsup, it was applying to all the ones with 4 items! It is now fixed! :)
@@JimpahGG Hey Jimpah - another tip if I may. I noticed I was struggling to find each item's value on the sheet to update it. So I've ordered the 'master value table' it from A-Z to simplify this. So instead of modifying manually all formulas that selected these values, I've made a VLOOKUP formula that finds the item name and it's current value, so right now my "master" table is nice and ordered. Let me know if you want it, I can share it with you! thanks
Thanks😊
My pleasure! :)
Was that a small sail on the basic ship? Iv struggled fitting the basic. Love the vid btw. Thank you for putting together foe us.
Yes! If you have crafted the small sail you press Y and press on the sail to put it on! Thank you for your comment! :)
Amazing, thank you! Do we need to be in warchannel before crafting the pack? Or can we run on normal channel, put in warehouse at destination, move to warchannel, and then sell?
Hi, thank you!
It doesn't work to change channel, also if you die in the warchannel it seems like you lose your 20% bonus as well!
Excellent video!!!! Thx
Thank you! :)
Most trade packs are like 50% now.
😢
Angerhorn I guess! On Serafine we're still doing big money with 120%+ :)
Amäzing content, keep it up king // Zalandra
:p
Thanks bro :D
good stuff thanks for the videos
Thanks for your comment, appreciate it! :)
Hi! Thanks for the video!
Tell me, is it possible to carry these packages on a secure channel?
And how are you doing with the percentage on your server?
Hello! During peace time it's safe to run with wagon across the map, but make sure it is peace in all the zones you are corssing!
On the water it is always PVP on, but it's also the most money to grab!
Is there any guide how I can get items for Tradepack creation? I dont know where to find Stones for example or coal. I need 3x items for on tradepack and its hard to get... Thanks for ana naswer!
If you want easy money try fishing, you need 3 things, a ship, a fish stick and fishing hook -> all of that you will get by completing quests. Then find on the sea some fishes (you will notice a special places for fishing). Then you can sell them to the MAN FISH BROKER nearby warehouses - but that man is not in every town.
or go to cut wood and sell it on the market.
Stones, copper ore or coal you can get from the mine, but there are creatures so you need to be able to kill them.
First of all DO THE QUESTS and that will teach you all of the things.
Most basic is learnt through the introduction, like woodcutting will give you logs, mining will give you, stone, copper ore, coal etc. But if you have a small volume I recommend to run something like the Slums package that requires only about 7k to craft and almost always like 4-6k profit as well you can start building bank!
is there like a 10 max limit of holding traderpacks across all warehouses?
No, you can stock them up in every one of them, but keep in mind as soon as you leave the dock and there is packages ready in that werehouse you will bring max limit with you!
Can i go on normal sever, and then use the fishing warehouse to deposit it, and then move to a warmode channel and deliver it on ravendawn?
You won't get the bonus if you do so! What I haven't tested is if you craft for example 10 pack in warchannel - go to normal, run to them to the raven werehouse for example and then again swap to warchannel and deliver! That could work!
Amazing!
Thanks!:)
where can i find the base value
The base value equation is: (8 x Tiles) + 12000 = BASE VALUE OF PACKAGE
But if you use the spreadsheet, you just use the dropdown menu and choose your route :)
Unfortunatelly trade packs are becoming less profitable by the day
On Serafine we're living the life! :D
how the hell you have such high demand? what server is this?
This is Serafine :)
GOOD GOT EVEN BETTER! SPREADSHEET NOW HAS A LIST TO CHOOSE ROUTE IN AND ALSO CHECK BOXES FOR BONUS %, CHECK IT OUT!
docs.google.com/spreadsheets/d/15qRJ114rFRzPAZ2K0EDdbQdEGY9dZXHfI_JvsPjl8dE/edit#gid=428975624
how can edit the Tradepost Price Calculator v 2.2?
Top left you can press "File" then "Make A Copy" so you will copy it to your own account! :)
Wait a minute, on Warchannel whole SEA is a peace all the time?
Sea is always war, you are never safe there ;)
@@JimpahGGI asked because when you gone into the water with ship you got small peace icon near your nickname, that was weird.
the excel is wrong. it is no longer 8 silver x tile it is now 6.4silver x Tile.
Hi, the nerf was on the value of the tradepack, not the distance. So it's still (8xtiles)+9600 instead of 12k, so it works perfectly for me :)
@@JimpahGG no, is 6.4xtile now
If you gonna die on ship via PvP - are you losing your tradepacks ?
Yes, the water is full PVP so you should run in group or do de-routes to avoid the most obvious routes! :)
@@JimpahGG meh, so that's pretty pointless :-/
Do you just buy the resources from the market?
Yes, and you set the prices in the list of reasorces to make it calculate in the right way :)
holy crap on the first server everywhere demands are 50% xD
Yeah, I've heard Angerhorn is struggling right now!
what is the build u are using?
I'm using Warfare, Shadow, Archery :)
Every single pack is at 50-60% from seabreeze, not sure how do you have over 100 xd
You shouldn't look blindly at the percent at seabreeze, you should check at the sell point! So if you decide to go the Seabreeze to Ravencrest, you look at both and decide which way gives more profit if Seabreeze is 70% and Raven is 110% you would of course create your package in Seabreeze and go to Raven, the tiles are still the same so it has the same base value! :) Hope it made it a bit more clear for you :)
Hi bro, how to reset the atributes?
The reputation can't be reset, if that is what you meant :(
I mean, we need money first to make tradepacks. Its high risk, big investiment money. New players can be baited.
I usually recommend people who doesn't want to risk to much to do the slums/basic ones because it's very low investment on these :)
Why are some items priced at 999?
You are suppose to change the prices yourself 😁 the 999s are the new ones 🙂
You have discord?
I haven't set it up! But I thinking about to have one just for beeing able to answer people questions in a easier way!
WERE DO U FIND THE BASE VALUE?
The new sheet is a list you choose from. But to find the actual value you just (8xTiles)+12000=x :)