Nodiatis Forums

Nodiatis Forums (//forums.nodiatis.com/forums/index.php)
-   Player Guides and Help (//forums.nodiatis.com/forums/forumdisplay.php?f=7)
-   -   Formula Sheets (//forums.nodiatis.com/forums/showthread.php?t=6914)

beetdabrat 01-18-2010 04:30 AM

Formula Sheets
 
I will post instructions on how to create formula sheets for various things in Nod.
These instructions are for OpenOffice.Org calc.
Format will be cell coordinate and the value

I will start with pet damage and healing.

Step 1, Labels:

B1 Value
C1 Effect
A2 Min
A3 Max
A4 Delay
A5 Attack Pet

A7 Taming
A8 Loyalty
A9 Ferocity
A10 Stalking

A12 Predacity
A13 Fire and Ice

B15 Damage
C15 Damage With Wound
D15 Heal

A16 Min Damage
A17 Max Damage
A18 Min Crit
A19 Max Crit

A 21 DPS/HPS

Step Two, Values:

B2 Min pet damage
B3 Max pet damage
B4 Pet Delay
B5 0 for healing pet 1 for attacking pet

B7 Taming Level
B8 Loyalty Level
B9 Ferocity Level
B10 Stalking Level

B12 Predacity Level
B13 Fire/Ice Level

Step 3, Calculations

C7 =1 + B7 / 100
C8 =1 + B8 * 0.0075
C9 =1 + B9 / 400
C10 =1 + B10 / 100
D10 =1 + (B10 * 0.4) / 100

C12 =20 + (B12 / 10)
C13 =B13 / 100

B16 =B2 * C7 * C9 * C10
D16 =B2 * C7 * C8 * C10
B17 =B3 * C7 * C9 * C10
D17 =B3 * C7 * C8 * C10
B18 =B16 * 1.5
C18 =B18 * 2
B19 =B17 * 1.5
C19 =B19 * 2

B21 =((B16 + B17) / 2 + ((B18 + B19) / 2 * (C12 / 100))) / (B4 * D10 / 10) * IF(B5 = 0; C13; 1)
C21 =(((B16 + B17) / 2) + ((C18 + C19) / 2) * (C12 / 100)) / (B4 * D10 / 10) * IF(B5 = 0; C13; 1)
D21 =(D16 + D17) / (B4 * D10 / 5) * IF(B5 = 1; C13; 1)

Will add Sense Fear to the dps calcs later.

Beet Da Brat


All times are GMT -5. The time now is 02:14 PM
Boards live since 05-21-2008

Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.