I made a first cut at a Solstice Robe costing spreadsheet. What it will tell you is how many of what pieces you need (Silks, Imbued Emeralds, jars of acid, Celestial Essances) all you need to do is change the number of robe attempts you wish to make. You can also ballpark the cost by changing the cost per item. I also put in a cost per Gem Studded Chain. The one thing I didnt add in was the ability to figure out the number of GSCs needed. if somebody wants to add that info or send me the apprpriate formula I'de be happy to add that to the spreadsheet.
http://www.phoenixhorizon.com/solrobe.xls
EDIT Corrected Piece calculation for Emeralds and Jars of Acid
EDIT There is an Error if you try to get the Cost of 1 GSC it has to do with the way Excell does the round up. if there is anybody that would care to post a corrrected formula "= B11+ROUNDUP(B11*0.05,0)" with a 1 it rounds up to 2 which isnt really right. as long as you choose 2 or more the formula seems to be OK.
http://www.phoenixhorizon.com/solrobe.xls
EDIT Corrected Piece calculation for Emeralds and Jars of Acid
EDIT There is an Error if you try to get the Cost of 1 GSC it has to do with the way Excell does the round up. if there is anybody that would care to post a corrrected formula "= B11+ROUNDUP(B11*0.05,0)" with a 1 it rounds up to 2 which isnt really right. as long as you choose 2 or more the formula seems to be OK.
Comment