[TERA PC & Console] En Masse is closing, but TERA lives on! We will continue to support TERA PC (NA) and TERA Console until service is transferred. Stay tuned for more information.
[TERA Console] The Grotto of Lost Souls update (v85) is now live! Read the patch notes here: https://bit.ly/TERACon_v85

[TERA PC] The 64-bit update (v97) is now live. Check out all the changes delivered on August 11 here: https://bit.ly/tera64_patchnotes
[TERA PC & CONSOLE] Summerfest Part 2: The Beach Bash is on from August 11 until September 1! Participate in event activities to earn tokens redeemable for costumes, consumables, mounts, and more! Details: https://bit.ly/tera_sf20

Spreadsheet for calculating Vanguard Initiatives earnings

shoetf2shoetf2
edited June 2016 in TERA PC - General Discussion
I am currently completing a spreadsheet that sums up the total amount of gold that you can make with every Vanguard Initiative. Please comment with ideas of what you want in the docs. I plan on sharing this publically with everyone so they can use it in the future.

If you want to play around with the file go to File > Download as > Excel and all the functions are in there. The reason this is incomplete is because I still have to run the dungeons in the spreadsheet for the feedstock/gold that you get in the dungeon.

06/20/2016 Update: All values are correct except the exact dungeon ones. Still working on those. if you want to start using the spreadsheet download it and follow the instructions.

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

Comments

  • Deleted UserDeleted User
    good work =) !
  • Deleted UserDeleted User
    Thank you!
  • DerpagonDerpagon ✭
    can i bump this
  • Deleted UserDeleted User
    If someone were to put together a 'top 8 dailies' based on this and maximum gold output--that would be amazing. I'd do it myself but the calculations are a bit confusing to me... are you basing this off the assumption that we sell everything we get from the dungeons?
  • shoetf2shoetf2 ✭
    edited June 2016
    The calculations are the total value in gold that you get from the dungeon. Even if you don't sell the MWA, it is still worth what it is in the market. If you end up using the MWA, that's still value that you didn't spend getting the MWA. If you don't plan on selling it, then replace the MWA or Red Niveot value with 0.
    The calculations are on the bottom. The "red niveot" and "mwa box" are the two things that people usually use VG's to buy. These two items are the ones that give you the most value which is why I included them in the calculation. If you want another item in there I can add it.
    You can download the spreadsheet and use calculations on the bottom to find the highest value. However, someone with only an hour might just want to do 8 IOD bams whereas someone that has more time can do 8 SSHM's.
  • EschatologueEschatologue ✭
    edited June 2016
    The calculations for gold value from fod are wrong. Can you revise the mistakes and update the spreadsheet?
  • KaasahthurKaasahthur ✭✭
    Eschatologue wrote: »
    The calculations for gold value from fod are wrong. Can you revise the mistakes and update the spreadsheet?

    Something like that each person will need to edit as that will vary server to server and sometimes week to week.
  • shoetf2shoetf2 ✭
    Eschatologue wrote: »
    The calculations for gold value from fod are wrong. Can you revise the mistakes and update the spreadsheet?
    In the instructions it specifies that you have to update the feedstock values for your server. I only play in two servers (MT and AV) and for other servers you just replace the values in those tables by the value in your server. If you're talking about the feedstock from dungeon I'm still updating that while waiting for a definitive answer from EME as to whether or not the +48 feedstock event will continue.
Sign In or Register to comment.