PoE Damage Conversion Calculator

I been a long time since I updated the conversion calculator as it run quite well and accurate. However there was some bizarre issue with Avatar of Fire not working properly due to mathematical and formula errors. This is mostly due to terrible eye sight as the formula UI element of Excel is very bad. Google spreadsheet does it right which makes it easier to chain long formula and remember what it does several weeks later. However, Google spreadsheet doesn’t have a good embed option which excel is far better at so I’m stuck with excel. I decide to rewrite the whole system and make it very easy to do changes to it. This is what it used to look like. It quite crammed and hard to know where the flow is going so I did major edits. Now updated for easier editing and reading the process. The first version had the whole system jump all over the place but the second version goes from top to bottom. It makes it easier to find errors and adjust accordingly to the patch notes.



Now the calculator is updated to look better than before. It is color coded to know what element is being converted to or added as. This makes it easier to read the chart and input the information. The optimization of space allow me to add a conversion rate to show the total conversion which is helpful for those that wants feedback from adjusting the conversion values. Then there is the DPS which is mainly for Avatar of Fire to make sure the build is close to 100% DPS as possible. It look cleaner than the first version which was hard to read at times.



I would love if I get some feedback on improving the visuals, errors, and how it appears on different monitor size. I will update a bit later with a smaller version for smaller monitor.



Link to the Calculator!!!


Link to the Mini Version!!!