Sthax
05-01-2017, 03:45 AM
Dear fellow DDO addicts,
In light of the new Racial TR options i embarked on a 9+ lives TR journey. To smooth this journey out a bit i was interested in what quests would be best to run.
To keep track of this i've made an excel sheet.
You can use this excel to see what quest you want to run and what xp is gives. but also after you have run them input your run time and get an XP per min and XP/Min at quest lvl rating. This way you'll know what quest yield best xp and what quests are best to run on lvl.
Get the latest from here:
Download: https://www.dropbox.com/sh/0zmv7xpz8upi2w7/AAAHJ8qeGhlE5ITv1kHegTTla?dl=0
http://www.ewoudbakker.com/DD/dash.jpg
On the Dash tab you can set several main xp modifier. such as if your ViP have shipbuffs running with a xp pot all the time or have tomes. There is also an average Quest optinal percentage. I've set it to 35% as i find this to reflect most quests best.
Also you'll find on the dash an avarage XP/Min, the amount of quest ran, your lvl and time to go till lvl 20.
http://www.ewoudbakker.com/DD/quest.jpg
On the heroic quests tab you can set your quests. use the drop down menu to select your quest and on what difficulty you are running it. THen put in if your running with BB 1 for yes 0 for no. the sheet always assumes your running first time completions.
The light orange spaces are for the user to fill in. there is a "Mod base xp" for you to fill in extra xp bonusses for example if you are doing traps, conquest and what not. this can also be used in negative value to compensate the first time run bonus you dont get by inputting -xx% xx beeing the firsttime compensation.
the formula needs a q run time to opperate. Once you fill in the run time it will spit out the xp/min and color red if its beneath 20% of average and green if its 20% above average of all quests.
the Q XP rating looks at all Quests of the same lvl and give you an percentage of the average XP/min. this gives a good idea on what quests are worth the time.
I've your like me and dont want to keep meticulous records. you'll just put in a good value on avg Q opt and run alot of quests. This means you'll get discrepancy in your quest xp. I usually solve this by adding a SAGA XP to reflect the sheets p to the characters xp.
you'll also find a tables tab with all the xp tables and a quests tab with all the quests and XP (here you can add future quests)
At the end of every life you'll get your data. You can add them all into one sheet and get a better reflection of your overall Quest rating.
Hope you all can put this to use.
You are welcome to give pointers and options. this is an ongoing project and there are still things that can be optimized and added. Might even go and make a EPIC Quest tab and add in the different SAGA's. Also i've been tinkering around to have a searchable drop down menu but its a pain within excel (amazing they havn't build in the option).
Cheers,
Sth*x of Ghallanda
In light of the new Racial TR options i embarked on a 9+ lives TR journey. To smooth this journey out a bit i was interested in what quests would be best to run.
To keep track of this i've made an excel sheet.
You can use this excel to see what quest you want to run and what xp is gives. but also after you have run them input your run time and get an XP per min and XP/Min at quest lvl rating. This way you'll know what quest yield best xp and what quests are best to run on lvl.
Get the latest from here:
Download: https://www.dropbox.com/sh/0zmv7xpz8upi2w7/AAAHJ8qeGhlE5ITv1kHegTTla?dl=0
http://www.ewoudbakker.com/DD/dash.jpg
On the Dash tab you can set several main xp modifier. such as if your ViP have shipbuffs running with a xp pot all the time or have tomes. There is also an average Quest optinal percentage. I've set it to 35% as i find this to reflect most quests best.
Also you'll find on the dash an avarage XP/Min, the amount of quest ran, your lvl and time to go till lvl 20.
http://www.ewoudbakker.com/DD/quest.jpg
On the heroic quests tab you can set your quests. use the drop down menu to select your quest and on what difficulty you are running it. THen put in if your running with BB 1 for yes 0 for no. the sheet always assumes your running first time completions.
The light orange spaces are for the user to fill in. there is a "Mod base xp" for you to fill in extra xp bonusses for example if you are doing traps, conquest and what not. this can also be used in negative value to compensate the first time run bonus you dont get by inputting -xx% xx beeing the firsttime compensation.
the formula needs a q run time to opperate. Once you fill in the run time it will spit out the xp/min and color red if its beneath 20% of average and green if its 20% above average of all quests.
the Q XP rating looks at all Quests of the same lvl and give you an percentage of the average XP/min. this gives a good idea on what quests are worth the time.
I've your like me and dont want to keep meticulous records. you'll just put in a good value on avg Q opt and run alot of quests. This means you'll get discrepancy in your quest xp. I usually solve this by adding a SAGA XP to reflect the sheets p to the characters xp.
you'll also find a tables tab with all the xp tables and a quests tab with all the quests and XP (here you can add future quests)
At the end of every life you'll get your data. You can add them all into one sheet and get a better reflection of your overall Quest rating.
Hope you all can put this to use.
You are welcome to give pointers and options. this is an ongoing project and there are still things that can be optimized and added. Might even go and make a EPIC Quest tab and add in the different SAGA's. Also i've been tinkering around to have a searchable drop down menu but its a pain within excel (amazing they havn't build in the option).
Cheers,
Sth*x of Ghallanda