TreeCalcs: WrathCalcs, respecced - Page 2

• Hamlet · 01/14/10, 9:56 AM

Sheet updated.
--Fixed a bug where the scaling factors for Spirit were being underestimated if you had Living Spirit.
--First iteration of Trauma model.

Alfei · 01/18/10, 3:47 AM

Arawethion

Do you have a mac version of your TreeCalcs?

i try use spreadsheet in the OpenOffice but it cannot recognize Names in calcs

Found 1 solution but did not check if it works correctly because just start to dig the calcs inside file

"Formula refers directly or indirectly to itself and the Iterations option is not set under Tools - Options - OpenOffice.org Calc - Calculate."

seems that calcs are destroyed ((

lolofora · 01/18/10, 4:10 AM

I love your work

Do you add the effects of trinkets ICC?

Is that I can link your file on my blog (in french)?

Kermit · 01/18/10, 4:22 AM

Originally Posted by Alfei

Arawethion

Do you have a mac version of your TreeCalcs?

i try use spreadsheet in the OpenOffice but it cannot recognize Names in calcs

Brgds

Alfei

I just tried it on Microsoft Excel 2008 on Mac as well - gives errors about circular references in formulas, but don't display the formula(s) giving the error for some reason. I get 9 alerts about that when opening the file, after that it's usable, but as soon as I change a value I get the same alert.

• Hamlet · 01/18/10, 11:28 AM

Try updating Excel 2008 (Mac) to 12.2.1? That's actually what I use.

Not sure what would give rise to circular reference errors in some versions but not others.

• Hamlet · 01/18/10, 7:14 PM

By the way, updates will start appearing in this post:
Resto PvE Compendium and General Discussion

Alfei · 01/26/10, 4:47 AM

I update Exel for mac still same error and for Openoffice it does not work "Formula refers directly or indirectly to itself"

• Hamlet · 01/26/10, 4:20 PM

Originally Posted by Alfei

I update Exel for mac still same error and for Openoffice it does not work "Formula refers directly or indirectly to itself"

Maybe there actually is a circular reference in there somewhere? Just to check, let me upload a version without the tables. I tried that in WC and someone said it helped, let me test with this sheet and then I'll see if there's some better way to handle both of them.

e: See if this works in both programs.

Fallenangel · 01/26/10, 4:41 PM

Getting some odd results in nourish's cast time. At haste cap, rejuv is 1s cast with 0 instant delay and nourish is oh-so slightly under 1.05. Not taking WoA into account?

• Hamlet · 01/26/10, 4:45 PM

Originally Posted by Fallenangel

Getting some odd results in nourish's cast time. At haste cap, rejuv is 1s cast with 0 instant delay and nourish is oh-so slightly under 1.05. Not taking WoA into account?

Turn both instant and queue delay to 0. The sheet doesn't restrict them, but it's not really sensible, as far as real-world behavior, for queue delay to be higher than instant delay.

Alfei · 01/27/10, 5:00 AM

Originally Posted by Arawethion

Maybe there actually is a circular reference in there somewhere? Just to check, let me upload a version without the tables. I tried that in WC and someone said it helped, let me test with this sheet and then I'll see if there's some better way to handle both of them.

e: See if this works in both programs.

Good news it works now )) on Openoffice

Huge thanks from mac users !!!

I try to put 3 points in Living Seed seems it does not change my hps result

Erdluf · 01/27/10, 8:30 AM

Originally Posted by Alfei

I try to put 3 points in Living Seed seems it does not change my hps result

The default rotation is 5x1. Pick a rotation that can proc LS.

• Hamlet · 02/01/10, 5:02 PM

Replying here

Originally Posted by Evolve

I've been trying to get treecalcs to work on openoffice as well. This is what I've found so far:

- Activating iterations and leaving default values in there (100 steps, 0.001 min change) gives 0.0hps or 0.0mp5 as marginal value for every stat.

- Using INDIRECT("CellName")+1 instead of CellName+1 gives correct marginal values regardless of iterations settings. I'm wondering if it'd be possible to add this everywhere ?

PS: The same is most likely also applicable for wrathcalcs

What exactly did you do? I looked up INDIRECT and can't see how that would be used to replicate what the data tables do. Ideally I'd find some way to do it that works in both programs, because I'm probably not going to maintain two parallel sheets.

Erdluf · 02/03/10, 4:35 PM

I recommend changing the Number of Ticks on the Regrowth Calcs tab from

7+2*Nat_Splen

to

7+2*Nat_Splen-GRGActive

as a better reflection of how the Regrowth glyph is used.

• Hamlet · 02/03/10, 4:43 PM

Probably should. Still not perfect, but would be better than what's there now.

Erdluf · 02/04/10, 9:35 AM

The Nourish Heal cell, (C5 on Nourish Calcs tab) has a misplaced parenthesis.

The formula should be (paraphrased)

(2035+(SP Stuff))*GoN*MSS*ToL

but TreeCalcs has

(2035+(SP Stuff)*GoN*MSS*ToL)

If you set TotalSP (or Nourish Coefficient) to zero, you'd expect to see a heal of

2035*GoN*ToL*MSS

but instead you see 2035.

The result is a value about 400 too low for talented Nourish+0, non-crit

• Hamlet · 02/04/10, 10:01 AM

Yup, thanks, uploading now.

e: actually, will put up new version a little later, but you're right.

• Hamlet · 02/04/10, 3:31 PM

Fix for Nourish is up.