Looking for a math wiz type

[Cravin]

I created a spreadsheet to some basic calculations on Solstice Robes what it does right now is calculates the Number of Silk Swatches, Celestial Essances, Emeralds and Acid. It also gives a cost estimate based on the cost of each item (You enter your cost). It also will give a ballpark estimate on how much GSCs will cost Useing a Jewlcrafter with JCM3 and no JCM. There are a couple things that I really dont have a clue as to how to build the formulas. I would really like to be able to put my current skill level in a cell and have the spredsheet use that to determine how many GSCs im going to need to make. That would also lead to getting an approxamate skill points gained. Anybody feel upto the challange? Anybody feel like helping?

If you want to see the spreadsheet its at http://www.phoenixhorizon.com/solrobe.xls or PM me here. and we will work something out.

Thanks for your time
Cravin

[Cravin]

WOW Im suprised all the folks round here fueling the debates on Skillups and sucess VS failures and I cant get 1 person to bite on helping with this ohwell I went from 204 to 219 yesterday on solstice robes. I also made 52 solstice robe on approxamatly 350 combines. I ran out of GSCs cause I was unsure of the amount to make.

[kiztent]

I'm not even going to guess at success rates (more accurately, the trivial) or points per skill up, which is what you would need for both of those formulas :P

Ok, I bit.

a1 = raw skill
b1 = combines/skill point (30)

Note, this formula will only work for skill over 209 (modified). I assume a geerlok and 340 trivial for robes

no geerlok:
c1 '=b1*(a1-208.5)' (chains for next skill pointb)
d1 '=10*b1*((a1-208.5)+.55)' (chains for next 10 skill points)

geerlok:
c1 '=b1*((1.05*a1)-208.5)' (chains for next skill point)

Of course I'm guessing at b1. Have fun.