Selling this awesome weapon guys and gals! Bidding ends in 1 week on the 17th at 9 PM EST. Best of all is that it strikes your enemies with lightning, eliminating them in 1 to 2 microseconds! Yes, you too can fry your very own quill fiend without even having to lift a finger!
I used this evening to add a feature to the Excel:
Now it has several new sheets where you can add several weapons / armor pieces with their stats and chose from them at the origin Stat-Tab. This allows you to easy switch equipment to find the best solution for your char (you can still enter / edit an attribut at the Stat-tab manually).
Hey, I really like the changes you made to the sheet. I like that it gives you a lot more options and once you get it set up you can see the differences between gear sets easier than having open multiple sheets. The only downside is that is does create a lot of bloat and add additional complexity. I like to try to keep it simple, but still I like your changes. Thanks for taking the time to do this.
Hello, thanks guys. I updated the sheet. I locked all cells with formulas so that you don't accidentally edit them and added a few comments. For instance, base stats are automatically updated when you choose your class and skills. Also cells in the items section are filled orange if their base stat can be higher than that of other items. For example, shoulders and belts can have up to 300 strength on an ilvl item of 63, where all other armor slots max out at 200. Lastly I did as you said Gerta and changed the EH to use a thousands separator since that usually is a big number.
Hello, I just completed an Excel spreadsheet that I have been working on that calculates and displays your character's dps, its damage reduction, its effective health, and various other information. It is very great tool for comparing everything from a single piece of gear, to a whole set of gear. It allows you to see how much you are gaining or losing from whether or not you have a certain buff or passive. The best part is that it is very simple to use.
Here are the steps:
1. Go to the Inputs tab.
2. Put in your characters level.
3. Use the dropdown menus to change classes, damage types, and weapon types.
4. You may also enter passives and buffs that you may have.
5. Go to the Stats tab and enter your stats.
Displayed below is all the information about your character.
A few dps bugs still need to be worked out. Due to Blizzard's rounding it can be off by about 0.1% of what is shown in game. I'm still working out what will work in all situations.
Here is some information about the Stats tab:
-My character's stats are already entered as an example. All you have to do is empty the boxes and then start entering your own stats.
-Nothing needs to be changed in the first row that is labeled "Base w/ Passives & Buffs". All base stats are updated according to your class, and your other various inputs.
Here is some information about the Active and Passive skills in the Inputs tab:
-The Active Skills drop down boxes only include the runes that are calculated by the spreadsheet. "No Rune" means it is only calculating the base effect of the skill.
-Uncolored skills in the inputs tab are only applied to that class. For example, the Barbarian passive Ruthless will only be calculated if your class is set to Barbarian.
-Skills that have an orange color will be applied to all classes. For example, this allows a Wizard to enter War Cry if he has a Barbarian buffing him.
-Aqua colored boxes are also applied to all classes. These are considered debuffs. For example, if you have Threatening Shout active you will receive an additional 20% damage reduction under the debuff bonuses box in the stats tab.
I uploaded the file to File Dropper because Diablofans won't allow me to add an excel sheet as an attachment. Just go to the link below and download the sheet.
Thanks KageKaze. Anything that gets more people to hear really helps and I appreciate it. I really hope Blizzard doesn't make a huge mistake with the mf change. After reading their 5 choices I was really disappointed and I hope we don't have to deal with any of the annoying cons that come with them. That is why I made this thread and why I am trying to keep it going.
The funny thing is that I posted the same thing on the Official forums (twice), but like you said, I think nobody will ever see it. Good job putting that idea on Diablofans :3 I hope Blizzard ends up looking at it, since it wouldn't hurt MF and legit players.
Yeah, the idea is to appeal to blizzard's goal of eliminating gear swapping while also trying to prevent any unnecessary inconveniences due to the change.
They are all aesthetic, except cold damage, which chills targets and conversely gets a damage reduction to account for the extra utility.
So I think that those flat increases are working as intended
You are talking about 2 completely different things. Jay Wilson is talking about elemental dmg modifiers on weapons like 100-200 cold dmg on a bow or something. The OP is talking about the % to an elemental dmg found on certain legendary items. You would think when it says 6% to cold dmg it means that only your cold dmg is increased by 6%, but what it is doing right now is increasing all dmg by 6%.
Personally I'm not really sure I like the idea of changing mf, but Blizzard seems intent on changing it anyway. So if changing MF is the only option then here is my personal solution. I like option 4 the best, but it has too many downsides, such as swapping a regular non-mf piece of gear and being penalized for 3 minutes. So here is my proposal. Make it so only when you equip an item that increases your mf you are penalized for 3 minutes, and remove the part where your mf drops to 0% for the 3 minutes. Here are a few examples:
Your total mf is currently 100%.
Take off an item with 15% mf on it.
Exactly what you expect to happen happens. Your mf drops to 85%.
Now you are at 85% mf.
MF was not increased and no penalization was incurred.
Now put back on item with 15% mf on it.
Your mf remains at 85% for 3 minutes.
3 minutes later you are back at 100% mf.
You switched an item that increased your mf, and are penalized for 3 minutes.
Now you are at 100% mf.
Switch 15% mf gloves for gloves with 10% mf.
Your mf drops to 95% without having to wait 3 minutes.
Your mf was not increased and no penalization was incurred.
This modified option 4 will basically minimize any negative secondary affects that may impair your gameplay due to the mf changes. Please comment and state whether or not you like this change and discuss why. Thanks.
Or.. you know.. just use the piece that gives the most dps? Exactly the same as before. But, personally I'm going to do none of those. With the increased repair bills I'm either going to go for extra survival and if that doesn't help with getting insta-gibbed I'll probably just reroll.
And yet I do not use the same login and password on any site and my diablo account got hacked. I had no viruses on my computer either. Dunno how accurate that statement is.
OT: If what he is saying is true he should report that on the blizzard technical support forums. I know WoW has some options for those with color blindness.
0
0
0
1
Here are the steps:
1. Go to the Inputs tab.
2. Put in your characters level.
3. Use the dropdown menus to change classes, damage types, and weapon types.
4. You may also enter passives and buffs that you may have.
5. Go to the Stats tab and enter your stats.
Displayed below is all the information about your character.
A few dps bugs still need to be worked out. Due to Blizzard's rounding it can be off by about 0.1% of what is shown in game. I'm still working out what will work in all situations.
Here is some information about the Stats tab:
-My character's stats are already entered as an example. All you have to do is empty the boxes and then start entering your own stats.
-Nothing needs to be changed in the first row that is labeled "Base w/ Passives & Buffs". All base stats are updated according to your class, and your other various inputs.
Here is some information about the Active and Passive skills in the Inputs tab:
-The Active Skills drop down boxes only include the runes that are calculated by the spreadsheet. "No Rune" means it is only calculating the base effect of the skill.
-Uncolored skills in the inputs tab are only applied to that class. For example, the Barbarian passive Ruthless will only be calculated if your class is set to Barbarian.
-Skills that have an orange color will be applied to all classes. For example, this allows a Wizard to enter War Cry if he has a Barbarian buffing him.
-Aqua colored boxes are also applied to all classes. These are considered debuffs. For example, if you have Threatening Shout active you will receive an additional 20% damage reduction under the debuff bonuses box in the stats tab.
I uploaded the file to File Dropper because Diablofans won't allow me to add an excel sheet as an attachment. Just go to the link below and download the sheet.
http://www.filedropper.com/diablocraft101_1
Credits:
I would like to thank Edimasta for allowing me to use his calculations for the Demon Hunter's Sharpshooter Passive.
0
1
Let's try not to derail the thread please, and thanks guys for the support.
0
Yeah, the idea is to appeal to blizzard's goal of eliminating gear swapping while also trying to prevent any unnecessary inconveniences due to the change.
0
You are talking about 2 completely different things. Jay Wilson is talking about elemental dmg modifiers on weapons like 100-200 cold dmg on a bow or something. The OP is talking about the % to an elemental dmg found on certain legendary items. You would think when it says 6% to cold dmg it means that only your cold dmg is increased by 6%, but what it is doing right now is increasing all dmg by 6%.
0
20
Your total mf is currently 100%.
Take off an item with 15% mf on it.
Exactly what you expect to happen happens. Your mf drops to 85%.
Now you are at 85% mf.
MF was not increased and no penalization was incurred.
Now put back on item with 15% mf on it.
Your mf remains at 85% for 3 minutes.
3 minutes later you are back at 100% mf.
You switched an item that increased your mf, and are penalized for 3 minutes.
Now you are at 100% mf.
Switch 15% mf gloves for gloves with 10% mf.
Your mf drops to 95% without having to wait 3 minutes.
Your mf was not increased and no penalization was incurred.
This modified option 4 will basically minimize any negative secondary affects that may impair your gameplay due to the mf changes. Please comment and state whether or not you like this change and discuss why. Thanks.
0
Difficulty
- Whimsyshire will also be affected by the incoming difficulty changes in 1.0.3. For Hell Whimsyshire counts as Act IV and for Inferno as Act III/IV.
That was posted on the front page diablofans just 2 weeks ago.0
0
0
0
OT: If what he is saying is true he should report that on the blizzard technical support forums. I know WoW has some options for those with color blindness.