Bard Songs per level: Google Doc

[wc4482]

Hello everyone,

I made a google doc that will show numerical values of various bard songs based on level.

Simply enter the desired level in cell A1 and change instrument modifiers and the spreadsheet should populate with songs available for that level.

http://docs.google.com/spreadsheet/ccc?key=0AkeXTHUjDTgGdHBIOFpiUzhfT192dkJxTmZMSlp3R 1E&hl=en_US

The spreadsheet is open to the public through clicking this link, so you may want to make a copy of it if someone else is using it.

[falkun]

That's awesome! I'll have to check it against what I see at L52 when I get the opportunity (hopefully tonight). I do know that with a 21 mod on my drums (MM battle drums (http://wiki.project1999.org/index.php/Mistmoore_Battle_Drums)), I'm only seeing 37pt DoT on Fufil's, not 38. But the Chants (frost and flame) look accurate at 56. I'll check the other songs out and provide feedback.

[wc4482]

That's awesome! I'll have to check it against what I see at L52 when I get the opportunity (hopefully tonight). I do know that with a 21 mod on my drums (MM battle drums (http://wiki.project1999.org/index.php/Mistmoore_Battle_Drums)), I'm only seeing 37pt DoT on Fufil's, not 38. But the Chants (frost and flame) look accurate at 56. I'll check the other songs out and provide feedback.

Thanks! I forgot to mention where I came up with the data -- It is all based on the p99 wiki. I wonder if there might be a more accurate source. Also I don't know how rounding is treated in game (the spreadsheet should just round to the nearest integer).

As far as the formula goes, it finds a simple rise/run (remember algebra?) and then its somewhat of a linear equation with level being X and whatever stat being Y. I assume this is how it works? But again the math is just quick and dirty -- some testing is definitely needed :)

[falkun]

(the spreadsheet should just round to the nearest integer)

That may be your issue. I believe EQ utilizes floor(x) (http://www.mathworks.com/help/techdoc/ref/floor.html) instead of round(x) (http://www.mathworks.com/help/techdoc/ref/round.html), or whatever the EQ equivalent is of those 2 matlab functions.

Examples to help make things clear:

floor(32) = round(32) = 32
floor(32.3) = round(32.3) = 32
floor(32.5) = 32, round(23.5) = 33
floor(32.8) = 32, round(32.8) = 33

Basically, until the new integer number is actually obtained through mods/levels, the next lowest is used. You can never "gain" values (damage, healing, +resist) through rounding, but you can "lose" some through the floor conversion (always <1 value lost).

Graphically, it would look like this, with the solid circles indicating inclusive on the lower step bound on the integer mark while the hollow circles indicate exclusive at the upper bound:
http://www.mathwords.com/f/f_assets/floor_graph.gif

Do note that a rounding graph would look similar, but would be translated 0.5 units, so that x=5.5 would yield y=6, etc.

[Teeroyoyort]

That's awesome! Is mana regen really effected with an instrument? I thought it was just the HP value

[falkun]

That's awesome! Is mana regen really effected with an instrument? I thought it was just the HP value

To my understanding, only levels affect the amount of mana regen offered by the various mana songs (L32 & L55).

[wc4482]

That may be your issue. I believe EQ utilizes floor(x) (http://www.mathworks.com/help/techdoc/ref/floor.html) instead of round(x) (http://www.mathworks.com/help/techdoc/ref/round.html), or whatever the EQ equivalent is of those 2 matlab functions.
Examples to help make things clear:

floor(32) = round(32) = 32
floor(32.3) = round(32.3) = 32
floor(32.5) = 32, round(23.5) = 33
floor(32.8) = 32, round(32.8) = 33

Basically, until the new integer number is actually obtained through mods/levels, the next lowest is used. You can never "gain" values (damage, healing, +resist) through rounding, but you can "lose" some through the floor conversion (always <1 value lost).

Graphically, it would look like this, with the solid circles indicating inclusive on the lower step bound on the integer mark while the hollow circles indicate exclusive at the upper bound:

Do note that a rounding graph would look similar, but would be translated 0.5 units, so that x=5.5 would yield y=6, etc.

I was just thinking that a -0.5 at the end of the formula should fix the problem.

That's awesome! Is mana regen really effected with an instrument? I thought it was just the HP value
To my understanding, only levels affect the amount of mana regen offered by the various mana songs (L32 & L55).

Well L32 is singing only, I wasn't sure about the L55 song so i guessed, but after some research I tend to agree with you that instrument mods don't effect mana regen -- I have removed this from the spreadsheet.

[Halfelfbard]

Mana regen for bards is effected by the ur 1 meditation point by *per lvl.

No songs or spells effect bard mana regen.

[wc4482]

I have updated the formulas using -0.5 and for Level 52 Curtailing Chant shows 37 instead of 38 :)


Mana regen for bards is effected by the ur 1 meditation point by *per lvl.

No songs or spells effect bard mana regen.

The mana regen for the L55 song shown on the spreadsheet should be what each group member other than the bard gets per tick.

[Mcbard]

Nice work, I would recommend you link to a downloadable copy so that people can download and use it.

Reminds me very much of the old spreadsheet that used to be on EQdiva http://web.archive.org/web/20011119203339/http://eqdiva.com/files/songanalysis.asp

Edit: oops that version is too old would have to find a slightly newer one http://web.archive.org/web/20030425032519/http://www.eqdiva.com/files/songanalysis.asp