Jump to content

rux616

PC Member
  • Posts

    30
  • Joined

  • Last visited

Posts posted by rux616

  1. 6 hours ago, M0onstone said:

    Thank you and @Sebrent for this, just wanted to say again for other people that they shoud do 'File -> Make a copy' to get the whole thing (copying the pages themselves one by one will break the thing)

    Very good point about the "Make a copy..." option.  I have updated the instructions on this page and in the spreadsheet.

  2. [Edit: This has been fixed as of U19.0.4]

    So I've been thinking about this for a while as I've been doing more relic farming recently.  The gist of the problem is that when void reactants drop from enemies they don't get tracked if they are "in view", that is they exist somewhere inside your field of view, be it at your feet, 10m in front of you in plain sight, or even hidden completely behind a wall.  This is ... frustrating to say the least since they will often roll into some weird places where they may not be easily visible, or roll down some stairs, etc.  This is particularly troublesome since a lot of times in missions - let's pick on sabotage in this case - the enemy spawns can get a bit thin (or even non-existent) towards the end, forcing you to backtrack looking for that single reactant that literally slipped through the cracks.

    I propose two possible solutions to this issue:

    1. (Preferred) Make the HUD tracker be on screen at all times, even if the trace is inside your field of view, and disable the HUD tracker once you've picked up your allotted 10.
    2. Remove the HUD tracker altogether, but allow the traces to be vacuumed up by sentinels, and also allow them to be marked by us Tenno like resources can be.

    Thank you for your time.

    --rux616

  3. I recently came across the very well done relic tracking spreadsheet from @Sebrent, but I realized that I wanted more.  So I modified it some to include quantities as well as the pre-relic prime parts that are still floating around out there which have dwindled to just Bo Prime, Loki Prime, and Wyrm Prime.

    In the same spirit of helping in which Sebrent shared his spreadsheet, I now share mine.

    https://goo.gl/8PGIcb

    The instructions are in the spreadsheet itself, but I will copy them here as well:

    How the spreadsheet works

    Note: Any item that has an asterisk (*) after it has been vaulted. Baro-only relics/items have double asterisks (**).

    Column A-D of the Summary tab contains the list of all prime parts in the game and include how many you have and how many you need.

    Column F-K of the Summary tab is a combined list of the items from Column A-E of the Lith, Meso, Neo, Axi, and Pre tabs, essentially the list of all relics and their drops. This list will provide a green background for each relic drop that you have already acquired (based on the contents of Columns A-D).  You should never have to modify these columns by hand.

    Column A-E of the Lith, Meso, Neo, and Axi tabs are also where relics and their drops are entered. As new information is added here, this will automatically be added to the Summary tab as well as as for Column G-M of the respective tabs.

    Column G-J of the Lith, Meso, Neo, and Axi tabs are populated from Column A-E of the same tab.  They are simply the same items without duplicates and ordered alphabetically instead of by Relic and Rarity.

    Column R and Column S of the Summary tab, and Column M of the Lith, Meso, Neo, and Axi tabs are summaries of which Relics you still need parts from.

    Column X of the Summary tab shows the ducat value of any extra parts you have, separating vaulted from non, and giving a total as well.

    How to use it -- modifying the spreadsheet

    You cannot modify my version, but you can make a copy of it for yourself (which will then be editable by you) by going to the File menu, then choosing the "Make a copy..." option.  Then simply zero out the contents of Column C and Column D on the Summary tab and enter your own numbers.

    How to use it -- as you acquire items from relics

    As you acquire items from relics, you increment the count in Column C of the Summary tab which will then cause the values in the rest of the tabs to repopulate based on that new value.

    How to use it -- new relics added to the game

    As new relics are added to the game, you add their drop information for Columns A through E ... I will be doing the same for my own spreadsheet, so you can just copy those new rows from mine to yours if you'd like, or simply wait until I'm done editing and make a new copy of the document, copying over your quantities afterward.

    Note that this WILL cause the rows in the Summary tab to shift around, so you will need to copy and paste the Owned/Need quantities manually.

    Acknowledgement

    The vast majority of the credit for this spreadsheet goes to the user "Sebrent" on the Warframe forums.  I just modified it some to suit my tastes and needs.  His original post is here: https://forums.warframe.com/topic/687807-tool-tracking-void-relics/

×
×
  • Create New...