Looking for an Excel wizard

[DJAd]

I have a basic Excel spreadsheet I use when crafting out my armour.

I would like to add a column under each item that will tell me intensity of each piece.

I have no idea on how to add this as I'm on a rookie when it comes to excel.

If anyone could help me out please let me know.

 

[Gidge]

http://community.stratics.com/threads/spreadsheet-for-imbuing-armor.218027/

This may help you. I am good with spreadsheets, but I don't know squat about crafting (the numbers aspect). It's just out of my understanding.

 

[DJAd]

Yeah I guess its the intensity formula thing that I need added into mine.

 

[Elden of Baja]

Do you have a column for each Mod. If so, then on your formula for weight, you take The Total Weight for the max Imbue, and divide that by the number that represents the max imbue. That will give you the multiplier for the weight. so Mana Increase = 110 / 8 = 13.75. So on your spread sheet do = (Target cell ) * 13.75 And that will output the weight for the Mana Increase.

 

[Scribbles]

*hides*

 

[Maelwyn]

I can't find that skill in my skill list.