1. Before posting any MODs, please contact us at support@portalarium.com to ensure your MOD is acceptable to the Terms of Service and EULA of the game. Portalarium is not responsible for use of MODs and possible adverse effects on your client or computer, and we may take action on accounts using MODs that are deemed illegal. Whether submitted here or elsewhere in the community, use MODs at your own risk!
    Dismiss Notice

[Google Sheets] Recipe locations and information

Discussion in 'Player Created Resources' started by Rosemourne, Oct 10, 2017.

  1. Rosemourne

    Rosemourne Avatar

    Messages:
    329
    Likes Received:
    1,097
    Trophy Points:
    43
    Hioh everyone,

    I've been working on a spreadsheet that includes all the locations of every recipe in the game, as well as information on it. It's not quite done, but the zones of each recipe is entered in and I've been pressured to go ahead and post it on the forums. I will soon have the exact loc and details of every recipe. Until then, here is what I have:

    https://docs.google.com/spreadsheets/d/1vWEixHbrSa3mwzDfUye128UbwGy6YaPoLs6ehsZp0eo/edit?usp=sharing

    To use it, first enter in any potion of the recipe's name you wish to search for, then choose a recipe from the drop down menu.

    Please report bugs, typos, and bad info by commenting in the yellow box. I imagine there are lots of typos.
     
    Last edited: Apr 25, 2018
  2. ZhugeLiang

    ZhugeLiang Avatar

    Messages:
    21
    Likes Received:
    37
    Trophy Points:
    3
  3. Moussaka

    Moussaka Avatar

    Messages:
    118
    Likes Received:
    218
    Trophy Points:
    18
    Location:
    Switzerland
    Nice one! Added to favorites :)

    Thank you!
     
    Sara Dreygon likes this.
  4. Rosemourne

    Rosemourne Avatar

    Messages:
    329
    Likes Received:
    1,097
    Trophy Points:
    43
    Just finished adding the recipes for R49. If anyone finds another vendor with the wheelchair and operating table, let me know?

    I've added 993 recipes at the time of this post and only have 33 more to go!
     
    Sara Dreygon and Nick like this.
  5. Alley Oop

    Alley Oop Bug Brigade ā€“ Bug Hunter

    Messages:
    6,845
    Likes Received:
    11,381
    Trophy Points:
    153
     
    Sara Dreygon likes this.
  6. Rosemourne

    Rosemourne Avatar

    Messages:
    329
    Likes Received:
    1,097
    Trophy Points:
    43
    I've already got those added :) I meant additional vendors. I checked the "Estgard Region" but didn't see more than one.
     
    Sara Dreygon likes this.
  7. Alley Oop

    Alley Oop Bug Brigade ā€“ Bug Hunter

    Messages:
    6,845
    Likes Received:
    11,381
    Trophy Points:
    153
    mud, goti
     
    Sara Dreygon, Spoon and Rosemourne like this.
  8. Rosemourne

    Rosemourne Avatar

    Messages:
    329
    Likes Received:
    1,097
    Trophy Points:
    43
    Much appreciated! I was able to check them out, get their locs, and verify inventory. I've added them to the sheet :)
     
    Sara Dreygon and Spoon like this.
  9. 2112Starman

    2112Starman Avatar

    Messages:
    3,621
    Likes Received:
    8,003
    Trophy Points:
    165
    great stuff! Thanks!
     
    Sara Dreygon likes this.
  10. Sole

    Sole Avatar

    Messages:
    444
    Likes Received:
    3,393
    Trophy Points:
    80
    Gender:
    Female
    Location:
    Helsinki. Finland
    Very handy, thank you!
     
    Sara Dreygon likes this.
  11. Fiero Steele

    Fiero Steele Avatar

    Messages:
    372
    Likes Received:
    1,099
    Trophy Points:
    43
    Gender:
    Male
    Location:
    Elad's, Diamond Fields and NBM
    This is great! saves me a bunch of time trying to find recipes. Thanks!
     
    Sara Dreygon likes this.
  12. Vallo Frostbane

    Vallo Frostbane Avatar

    Messages:
    1,763
    Likes Received:
    3,591
    Trophy Points:
    113
    u da queen! :)
     
  13. Rosemourne

    Rosemourne Avatar

    Messages:
    329
    Likes Received:
    1,097
    Trophy Points:
    43
    King, but thanks all the same :)

    I am currently mid-move and won't have my computer for a couple of months. If you see an error, please let me know via PM here. I will be able to update the sheet through my phone, but can't log into the game to verify recipes for the moment.
     
    Sara Dreygon likes this.
  14. Lars vonDrachental

    Lars vonDrachental Avatar

    Messages:
    858
    Likes Received:
    1,247
    Trophy Points:
    105
    Gender:
    Male
    Location:
    Germany
    Even if I will not use such help as I like to explore novia by myself for everyone else this might be indeed a great convenience and thanks too for hiding the info behind a link that Iā€™m not forced to read the info just because I'm exploring the threads topic. ;)
     
  15. Rosemourne

    Rosemourne Avatar

    Messages:
    329
    Likes Received:
    1,097
    Trophy Points:
    43
    I'm back from my move and I'm working on this sheet again. Sorry about my absence, but I hope to have this updated and 100% accurate again by the end of the week.
     
    Mikayl, Nick, Kara Brae and 3 others like this.
  16. Rosemourne

    Rosemourne Avatar

    Messages:
    329
    Likes Received:
    1,097
    Trophy Points:
    43
    The spreadsheet has been reconstructed. It was broken two days ago by a couple of accounts who saw fit to mess with the settings that they could.

    I can't protect the entire sheet and have to leave some cells unlocked for the players to utilize. This unfortunately means those who know how to screw up the sheet can, and the trolls do. This sheet gets a couple of edits an hour and I can't police it fully, so please let me know if it breaks. I will fix it ASAP.
     
    Jaesun, 3devious, Elrond and 2 others like this.
  17. Mac2

    Mac2 Avatar

    Messages:
    2,315
    Likes Received:
    5,849
    Trophy Points:
    153
    Yep, this is why we cant have nice things.
     
    Mishras likes this.