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

You mean you wanted someone to make one right?

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..

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.

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.

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

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. :)

Only potions I would buy would be supers and renewals.

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

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?

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. :)

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)

 

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

 

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 :|

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. :)

No worries! Get well :p

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

That looks good, I can't find anything wrong with it.

 

Brilliantly done :)

Thanks! I'm glad it's helpful. :)