Kellog'z [Stat Requirement Calculator] - Goggle Sheet

Today I want to share with the community a Google sheets that I created for my characters and used for the last few seasons. Originally I built this for myself but having some new friends of mine join the game I shared this with them to help them understand the basic stat requirements for there builds and the game in general. After there feedback and seeing them use it I have now decided that I would like to share this with the public as I feel it could be useful in the future to both new and current players. Today has seen a pretty big overhaul of my original sheet allowing much more faster small things such as colour of gems, being able to pick gems from a drop down and generally removing a lot of manual typing. Currently its easier to input your values of stats / resists as a drop down menu of 0 - 45 or even 100+ on some things is just more hard work and messier.

Screenshot of the Sheet:


Spreadsheet Link - https://docs.google.com/spreadsheets/d/1I_tbC_d2zP4lB_ZDWQGTsKZJVLg2d04r8jBAzg465R0/edit?usp=sharing

Basic Tutorial:
Video Coming Soon!

[Area 1 - Item Stats] - All Gear Resists (Fire/Cold/Light/Chaos) and stat mod's (Int/Str/Dex) should be inputed here for each item. The dropdown menu lets you keep track of what you "need", "got", or "Craftable", where a further stat can be added such as resistance/life/or any other mods required.
[Area 2 - Narutal Stats] - This is where you input your natural stats from your build, you can find these out by copying your https://www.pathofexile.com/passive-skill-tree/ into http://www.poeplanner.com/
[Area 3 - Totals] - This is where you will see the results of all the data once inputed. "Totals" = what you will see on your character sheet (This does not consider buffs from skills yet) "Needed" = how much of either resist or stat is required for the current difficulty to be at max resistance.
[Area 4 - Stats Required] - Maximum stat mods should be put here for Gem / Gear requirements of the build.
[Area 5 - Jewels] - Jewel sockets stats should be inputed here just like in area 1.. All Gear Resists (Fire/Cold/Light/Chaos) and stat mod's (Int/Str/Dex)
[Area 6 - Difficulty] - Here you can set the difficulty either Normal/Cruel/Mercilles/Max Reduced Resist.
[Area 7] - Here is a area to help you remember what gem setups you will use on the build. if you are using a 1h and a shield or than you should just input the 3 gems for the main weapon in the "Main Hand Weapon" and 3 gems in the "offhand". If you are using a 6L weapon just leave offhand values at N/A and set your 6L setup on the "Main Hand Weapon". *This is work in progress I plan to make it tell you the max Str / Int / Dex requirements for your skills gems required.

Current Features:
*Able to input stat requirements such as str/int/dex and calculate your natural stats from the build + gear items totals, to get an easier understanding of what is still needed for the build or where stats can be sacrificed.

*Able to input resistances both natural from the build and from gear to work out resists for the level of difficulty selected on the sheet - *Not buffs such as purity of elements currently...

*Able to select your builds skill gems with automatic text colouring of the gem so that its much easier to see required socket and colours for the builds.

*Difficulty Selection (Normal / Cruel / Merciless / Max Reduced Resist)

Near Future Features:
*Skill Gem stat requirement total window - this will take some time but the goal is to allow the user to select all there skills and the level of the gems they will use and than the sheet will calculate the max STR/INT/DEX required to use all gems selected. *inputting every skills level from 1-30 and stat requirements is quite tedious but will come eventually.

*Adding support of buffs based resistances being added to the totals from the gem selection in [Area 5].

Further away Features:
*Convert to a website - Future goal is to make this work on a website where you can input the values with a much easier user interface but with the same basic results and with very simple save features for your characters.

DREAM Features - currently well out of my experience its just a dream and will probably never happen but who knows!

*Fully convert the interface to a website with the same goal of the sheet but so the user will be able to select there current or desired items and input the stats of each gear piece based on the items min max values. It will also calculate all skill gems Buff/Nerf and it will than be able to calculate all of your stats from a intertwined build calculator.