Formula Sheets
Old 01-18-2010, 04:30 AM   #1
beetdabrat
Auction Master
 
beetdabrat's Avatar
 
beetdabrat is offline
Join Date: Mar 2009
Posts: 1,078
Default 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
  Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT -5. The time now is 03:22 AM
Boards live since 05-21-2008


vBulletin skin developed by: eXtremepixels
Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.