08-09-2016, 09:47 AM
Regarding the time extend optimizer.
Oh so one thing I realized while investigating this is that Ascensions&Challenge!H16 isn't doing anything (number of time freeze).
To fix that first.
Main!H56 =60+'Ascension & Challenge'!K8+H3
should be Main!H56 =60+'Ascension & Challenge'!K8*'Ascension & Challenge'!H16+H3
Optimizer!AO14 =60+'Ascension & Challenge'!K8+C3
should be =60+'Ascension & Challenge'!K8*'Ascension & Challenge'!H16+C3
Side question during investigation. Question about ability time Main!H57 =8.5* 'Ascension & Challenge'!H17 (# of Ability Cycles). Wondering because isn't ability time 10 seconds?
So the problem with the time extend optimizer is that its missing the pet cd.
Assuming your Main!H65 formula is right.
Optimizer!A017 =AO14*Pets!C24
should be =Main!H65/Main!H56*AO14
Oh so one thing I realized while investigating this is that Ascensions&Challenge!H16 isn't doing anything (number of time freeze).
To fix that first.
Main!H56 =60+'Ascension & Challenge'!K8+H3
should be Main!H56 =60+'Ascension & Challenge'!K8*'Ascension & Challenge'!H16+H3
Optimizer!AO14 =60+'Ascension & Challenge'!K8+C3
should be =60+'Ascension & Challenge'!K8*'Ascension & Challenge'!H16+C3
Side question during investigation. Question about ability time Main!H57 =8.5* 'Ascension & Challenge'!H17 (# of Ability Cycles). Wondering because isn't ability time 10 seconds?
So the problem with the time extend optimizer is that its missing the pet cd.
Assuming your Main!H65 formula is right.
Optimizer!A017 =AO14*Pets!C24
should be =Main!H65/Main!H56*AO14
A leader of Fire Clan