Crafting Recipies Spreadsheet- updated!

Discussion in 'Guild & Town Hall' started by Sir Stile Teckel, Apr 13, 2014.

  1. iansmellios

    iansmellios Avatar

    Messages:
    178
    Likes Received:
    338
    Trophy Points:
    30
    Will do! Thanks for the heads up.
     
    Time Lord, Spoon and Dorham Isycle like this.
  2. Dorham Isycle

    Dorham Isycle Avatar

    Messages:
    2,002
    Likes Received:
    2,910
    Trophy Points:
    165
    Gender:
    Male
    Location:
    Ontario, Canada
    Hey my apologies, I never scrolled down, there's more to see. I like the listing of the Bows & Staves in that every variable is shown what it gives. That is very helpful. In time the Armor & Bladed Weapon sections will get filled out no doubt. I'm just scared to enter that all in the wiki now because each release things change so much when they think of a new & better way to do things:eek:
     
    Time Lord and iansmellios like this.
  3. majoria70

    majoria70 Avatar

    Messages:
    8,863
    Likes Received:
    22,155
    Trophy Points:
    153
    Gender:
    Female
    Location:
    United States
    Hmmmm well just thinking, why is this getting updated right now? I thought it was mentioned that as much as possible of crafting recipes would be fixed and put in the game. Do we know what the fixes are exactly? Not trying to make light or devalue the hard work you all are doing, just wondering.:)
     
    Time Lord likes this.
  4. Dorham Isycle

    Dorham Isycle Avatar

    Messages:
    2,002
    Likes Received:
    2,910
    Trophy Points:
    165
    Gender:
    Male
    Location:
    Ontario, Canada
    Fixes in my mind are ingredient quantities reflecting the value of the end product. Working through it to figure out how to display it is part of the process. It is a side quest. As far as the spreadsheet things aren't really getting updated unless I think of new ways to do things, there was a change in the wiki to be ready for future data that we believe is coming so I updated the spreadsheet to accept the data in auto updates, Doing that I broke it elsewhere so in working to repair that I discovered the spreadsheet was broken in a different section all along when it went over the 500 entry mark doing updates. So now when recipes are 'fixed', the changes are entered in the wiki & the player needs only to click the update button in the spreadsheet to download the data from the wiki & it might even work.:D
     
    Time Lord, iansmellios and Acred like this.
  5. majoria70

    majoria70 Avatar

    Messages:
    8,863
    Likes Received:
    22,155
    Trophy Points:
    153
    Gender:
    Female
    Location:
    United States
    Thank you for the explaination. I appreciate it very much. I was really just curious. I hope it didn't sound like I was complaining. I was interested. Wow I'm glad it will be easier in the future to update the recipes. I am really excited about seeing new crafting recipes come in to the game. :)
     
    Time Lord and iansmellios like this.
  6. Dorham Isycle

    Dorham Isycle Avatar

    Messages:
    2,002
    Likes Received:
    2,910
    Trophy Points:
    165
    Gender:
    Male
    Location:
    Ontario, Canada
    Item bonus calculation is a Thing! v49
    Spreadsheet will now calculate the material bonuses on armor & weapons as defined by Weins201 google sheet. These are customizable if things change, in the Legend tab by merely changing/adding the values there.

    Now to start on wiki recipes now that they are more standardized.
     
    Time Lord, Weins201, Acred and 6 others like this.
  7. Sir Stile Teckel

    Sir Stile Teckel Avatar

    Messages:
    2,775
    Likes Received:
    5,604
    Trophy Points:
    165
    Gender:
    Male
    Location:
    United States, Indiana
    Your a machine!
     
    Time Lord, Mata, iansmellios and 2 others like this.
  8. iansmellios

    iansmellios Avatar

    Messages:
    178
    Likes Received:
    338
    Trophy Points:
    30
    You my friend, are amazing!!
     
    Time Lord, Mata and Sir Stile Teckel like this.
  9. Dorham Isycle

    Dorham Isycle Avatar

    Messages:
    2,002
    Likes Received:
    2,910
    Trophy Points:
    165
    Gender:
    Male
    Location:
    Ontario, Canada
    Update

    v0050- Many Recipes added to Wiki
    This revealed an issue when syncing or resetting where it loaded wiki data in sections (resolved)
    Screen updating turned off during updates to increase updating speed(screen may go blank for periods during update)
    Material bonus calculation adjusted for R17 using 3 main ingredients
     
  10. Dorham Isycle

    Dorham Isycle Avatar

    Messages:
    2,002
    Likes Received:
    2,910
    Trophy Points:
    165
    Gender:
    Male
    Location:
    Ontario, Canada
    Thanks! It is a labor of love
     
  11. Earl Atogrim von Draken

    Earl Atogrim von Draken Avatar

    Messages:
    5,693
    Likes Received:
    10,801
    Trophy Points:
    165
    Gender:
    Male
  12. Dorham Isycle

    Dorham Isycle Avatar

    Messages:
    2,002
    Likes Received:
    2,910
    Trophy Points:
    165
    Gender:
    Male
    Location:
    Ontario, Canada
    Oh my, silly me. Forgot to change a for next loop number back to 2 from 325 in testing so half of the recipes didn't get processed for material bonuses, my bad.

    get v51 !! Ack
     
  13. Anendrue

    Anendrue Avatar

    Messages:
    466
    Likes Received:
    928
    Trophy Points:
    43
    Gender:
    Male
    Location:
    College Station, TX
    Found your spreadsheet around v49. It's just Awesome! Thank You
     
    Time Lord, Acred and Sir Stile Teckel like this.
  14. Dorham Isycle

    Dorham Isycle Avatar

    Messages:
    2,002
    Likes Received:
    2,910
    Trophy Points:
    165
    Gender:
    Male
    Location:
    Ontario, Canada
    That's great, glad people find good use of my hobby. Currently I'm pressing the Devs for clarity on item naming, what exactly determines an item name. When that is achieved the wiki should receive a large increase in recipes.
    Always a work in progress.
     
  15. Sir Stile Teckel

    Sir Stile Teckel Avatar

    Messages:
    2,775
    Likes Received:
    5,604
    Trophy Points:
    165
    Gender:
    Male
    Location:
    United States, Indiana
    The amount of time you put into this is fantastic. really glad you took the project over. your doing a lot more and a better job then i would have and continue to blow me away with it all the time. keep up the great work!!!
     
  16. Anendrue

    Anendrue Avatar

    Messages:
    466
    Likes Received:
    928
    Trophy Points:
    43
    Gender:
    Male
    Location:
    College Station, TX
    I agree intuition allows you to feel out recipes but devs could be more forthcoming. I appreciate the time and effort from y'all. Thank you.
     
  17. Anendrue

    Anendrue Avatar

    Messages:
    466
    Likes Received:
    928
    Trophy Points:
    43
    Gender:
    Male
    Location:
    College Station, TX
    My mini guild says to give you a great big Thank You. How can we help? You seem to beat us to the wiki for recipe updates as we only play casually.
     
  18. Dorham Isycle

    Dorham Isycle Avatar

    Messages:
    2,002
    Likes Received:
    2,910
    Trophy Points:
    165
    Gender:
    Male
    Location:
    Ontario, Canada
    Since you asked & anyone that wishes to contribute
    Base Recipes, I need screenshots of recipe book so I can verify actual in game proof & less chance of errors.
    Base Stats on all armor pieces
    Base Stats on all weapons
    I'll wiki enter them when the 'Power' naming is finalized so having the recipe & stat info then would be helpful.

    Since this is for anyone, if you don't know how to link screenshots here you can send them to me directly
    at Isycle11@gmail.com
     
    Time Lord and Acred like this.
  19. Anendrue

    Anendrue Avatar

    Messages:
    466
    Likes Received:
    928
    Trophy Points:
    43
    Gender:
    Male
    Location:
    College Station, TX
    Sounds good. But so far you are way ahead of me recipe wise. Mining is difficult as heck to get enough and purchasing ore/ingots is getting bad too. If we could get large ore amounts on the QA server from the devs it would help. Anyone with that kind of pull, could you please help get that arranged? Basically it would allow us to test each and every recipe and provide a nice tool in the end for the community.
     
    Time Lord likes this.
  20. Dorham Isycle

    Dorham Isycle Avatar

    Messages:
    2,002
    Likes Received:
    2,910
    Trophy Points:
    165
    Gender:
    Male
    Location:
    Ontario, Canada
    Well really, if someone has the recipe in book, screenshot it & share. Just the main one for all cloth, leather, chain, plate, weapon pieces. The player vendors have items listed for the mouse over stats but need that all cataloged.
     
    Time Lord likes this.