Wkw Posted May 31, 2015 Share Posted May 31, 2015 Does anyone have a spreadsheet where you can plug in how many items you have, to calculate supplies needed for overloads?One that goes all the way up to supreme overload salves, perhaps? Thank you Runescape player since 2005 Ego Sum Deus Quo Malum Caligo et Barathum Link to comment Share on other sites More sharing options...
Autumntempest Posted May 31, 2015 Share Posted May 31, 2015 You mean you wanted someone to make one right? Link to comment Share on other sites More sharing options...
Wkw Posted May 31, 2015 Author Share Posted May 31, 2015 If that doesn't exist already, that'd be fantastic. Only because any effort to sit and make supreme salves often involves a lot of calculator and buying things at ge.. several dozen times.. Runescape player since 2005 Ego Sum Deus Quo Malum Caligo et Barathum Link to comment Share on other sites More sharing options...
Autumntempest Posted May 31, 2015 Share Posted May 31, 2015 If that doesn't exist already, that'd be fantastic. Only because any effort to sit and make supreme salves often involves a lot of calculator and buying things at ge.. several dozen times..It shouldn't be hard to make one :/I made one on ability damage which was far more complex than an overload spreadsheet would be. Link to comment Share on other sites More sharing options...
Meranek Posted May 31, 2015 Share Posted May 31, 2015 They're pretty easy to make. It all just depends on what potions you want to make. Would likely be easier to tell the spreadsheet how many you want to make, and then have it present you with the needed supplies. I could make one if you want. Been meaning to anyway. I've got labs due tonight, though. I wouldn't get to it for a while. Link to comment Share on other sites More sharing options...
Wkw Posted June 1, 2015 Author Share Posted June 1, 2015 Yeah, that would be brilliant! If you could input the amount of finished product you want, as well as what supplies you already have, and have it tell you the amount of supplies that you need. Have the thing tell you how much of X you need, with how much Y you already have to reach Z potions Runescape player since 2005 Ego Sum Deus Quo Malum Caligo et Barathum Link to comment Share on other sites More sharing options...
Meranek Posted June 1, 2015 Share Posted June 1, 2015 Okay, labs are done, so I have time to work on this tonight! Are you working in terms of starting with raw materials, or are you buying your potions off the Exchange? Also, are you looking at just Supreme Ovl Salves? If not, are there potions you don't plan on making? There are a lot of Ovl-variations that will end up interfering with the spreadsheet. If you want all Ovl-variants, it's going to take me more time. :) Link to comment Share on other sites More sharing options...
Wkw Posted June 1, 2015 Author Share Posted June 1, 2015 Only potions I would buy would be supers and renewals. Runescape player since 2005 Ego Sum Deus Quo Malum Caligo et Barathum Link to comment Share on other sites More sharing options...
Meranek Posted June 2, 2015 Share Posted June 2, 2015 So here's the rough draft of the spreadsheet. Let me know if you need anything changed. https://www.dropbox.com/s/kna5lrz6xqnrxpa/OverloadSpreadsheet_Rough.ods?dl=0 1 Link to comment Share on other sites More sharing options...
Wkw Posted June 2, 2015 Author Share Posted June 2, 2015 That is great, but one thing more I would ask of you.. would it be possible to have another field where, say, you put in 50 if the result, and it wlll tell you how many ingredients you need? Runescape player since 2005 Ego Sum Deus Quo Malum Caligo et Barathum Link to comment Share on other sites More sharing options...
Meranek Posted June 3, 2015 Share Posted June 3, 2015 Sure, no problem! So you only ever buy Supers and Renewals, correct? You make your own p-pots, antifire/super antifire, super-antipoisons? I ask because I want to try and make it as useful as possible. :) Link to comment Share on other sites More sharing options...
Wkw Posted June 3, 2015 Author Share Posted June 3, 2015 Any component that is tradable.. So for supreme salves.. That'd be.. Renewal (4)Prayer (4)Super Anti (4)Antifire (4)Super Antfire (4) [Antifire(3)] Supreme ovl(s atk, str, def, mage, range 4) Overloadtorstols atk 3, avatoes str 3, dwarf weeds def 3, lants mage 3, mud runes range 3, grenwall spikes x5 So basically, for each supreme salve, that'd be(4 dose renewal, prayer, super anti, 4 dose super anti(3dose anti) + SUPREME[Overload(torstol, s atk 3, avatoe, s str 3, dwarf weed, ,s def 3, lant, s mage 3, mud rune, s range 3, grenwall spikes x5) + s atk, str, def, mage, range 4] Does that make any sense? Because I haven't used symbols like that for a long time hahaha :| Runescape player since 2005 Ego Sum Deus Quo Malum Caligo et Barathum Link to comment Share on other sites More sharing options...
Meranek Posted June 8, 2015 Share Posted June 8, 2015 Hey! Sorry for not getting back to you sooner. I've been stuck in bed and super sick over the last few days. I haven't forgotten about the spreadsheet, and I should be back soon. :) Link to comment Share on other sites More sharing options...
Wkw Posted June 8, 2015 Author Share Posted June 8, 2015 No worries! Get well :p Runescape player since 2005 Ego Sum Deus Quo Malum Caligo et Barathum Link to comment Share on other sites More sharing options...
Meranek Posted June 10, 2015 Share Posted June 10, 2015 It's done! It has every Overload-variant from regular Ovls all the way up to Supreme Overload Salves. I went through and doube-checked all the calculations, but let me know if you spot any bugs or have any questions! https://www.dropbox.com/s/p8igo4xjbdh7e7i/OverloadSpreadsheet.ods?dl=0 1 Link to comment Share on other sites More sharing options...
Wkw Posted June 11, 2015 Author Share Posted June 11, 2015 That looks good, I can't find anything wrong with it. Brilliantly done :) Runescape player since 2005 Ego Sum Deus Quo Malum Caligo et Barathum Link to comment Share on other sites More sharing options...
Meranek Posted June 13, 2015 Share Posted June 13, 2015 Thanks! I'm glad it's helpful. :) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now