(08-24-2016, 03:23 PM)JourneyOver Wrote: Going to Mark down what needs to be looked at for Pet sheet that I've noticed at least.

AL16 calculations are way off now. (it's showing that I would get a total of 3,800 pet food a day for beating up to arena 19 when in reality I'm getting 29 pet food a day for beating up to arena 19) if I throw AL15 onto AP instead of No-AP it goes down to the reasonable number of 29.

AL17 and AL18 both are calling "pets new" sheet supposedly even though there is no such sheet at all made named that along with them calling blank cells so calculations can't even be made for them (possibly calling on cells as well that are not made for these calculations)

Even though the next two are in the WIP section might as well let you know about them.

AM7 is calling on cells that are completely blank as well so nothing can be calculated for it as well as cells that I don't think are made for "Maximum Pet Arena w/o AP" calculations.

AM8 is calling on the "pets new" sheet like AL17 and AL18.


And for Node stuff

Anything to do with critical damage does not seem to be calculated for the sections under it as seen here ----

Picture

as you can see I have 10 in cell N8 but N9 (same with H27 and I27) doesn't seem to get the calculated value of DPS increase provided by the next single upgrade to that node divided by the PP cost for that upgrade.

(08-24-2016, 04:17 PM)jiecut Wrote: AL16 fix.

=if(AL15="NO AP",sum(NY4:NZ6),sum(NX4:NX6))

Critical Damage doesn't do anything because crit chance is 0%.

(08-24-2016, 04:31 PM)IndigoFerret Wrote:

(08-24-2016, 03:23 PM)JourneyOver Wrote: Going to Mark down what needs to be looked at for Pet sheet that I've noticed at least.

AL16 calculations are way off now. (it's showing that I would get a total of 3,800 pet food a day for beating up to arena 19 when in reality I'm getting 29 pet food a day for beating up to arena 19) if I throw AL15 onto AP instead of No-AP it goes down to the reasonable number of 29.

AL17 and AL18 both are calling "pets new" sheet supposedly even though there is no such sheet at all made named that along with them calling blank cells so calculations can't even be made for them (possibly calling on cells as well that are not made for these calculations)

Even though the next two are in the WIP section might as well let you know about them.

AM7 is calling on cells that are completely blank as well so nothing can be calculated for it as well as cells that I don't think are made for "Maximum Pet Arena w/o AP" calculations.

AM8 is calling on the "pets new" sheet like AL17 and AL18.


And for Node stuff

Anything to do with critical damage does not seem to be calculated for the sections under it as seen here ----

Picture

as you can see I have 10 in cell N8 but N9 (same with H27 and I27) doesn't seem to get the calculated value of DPS increase provided by the next single upgrade to that node divided by the PP cost for that upgrade.

I'll work on your issues tomorrow morning.  In regards to Critical Hits, Critical Chance has a starting value of 0% and Critical Chance has a starting value of 20%.  If you haven't increased Critical Chance past 0%, then there will be no increase to DPS by increasing Critical Damage.  Thus, cell N9 shows zero benefit for increasing that node since Critical Chance is still zero, while E7 shows a very small benefit for increasing that node.

(08-26-2016, 10:12 AM)k3rb3r05 Wrote: Also, in Ascension & challenge sheet, could you make the following changes? (also minor)
C52:  =if(C12="Yes",8,0)
C59: =1*((C19*(C19+1)/2))
C60: =1*((C20*(C20+1)/2))

(08-26-2016, 10:12 AM)k3rb3r05 Wrote: Great work on pet sheet... a minor edit though: HJ39:ID39 have to be re-numbered, because cells contain dups and instead of going up to CriC21, they go up to CriC10.

Also, in Ascension & challenge sheet, could you make the following changes? (also minor)
C52:  =if(C12="Yes",8,0)
C59: =1*((C19*(C19+1)/2))
C60: =1*((C20*(C20+1)/2))

In Challenge Data sheet, is there any way to mark finished challenges as done, or apply conditional formating on them, based on "Ascension & challenge"!F26:N26 ? (edit: when there is code in it (not "ok" or "done") like s3d)

(08-26-2016, 10:43 AM)jiecut Wrote:

(08-26-2016, 10:12 AM)k3rb3r05 Wrote: Also, in Ascension & challenge sheet, could you make the following changes? (also minor)
C52:  =if(C12="Yes",8,0)
C59: =1*((C19*(C19+1)/2))
C60: =1*((C20*(C20+1)/2))

Those are zero because it assumes you respec to do training or woodcutting. And if you don't respect and just leave it on, it's not that big of a problem.