Announcement

Collapse
No announcement yet.

PoP Hurricane armor, analysis of drops and cost

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • PoP Hurricane armor, analysis of drops and cost

    I have several of the ingredients needed to attempt some Hurricane armor. I decided to make a chart to help me determine how many "Storm Rider Blood" and how many "A Drop of Pure Rain" I needed to craft any particular piece. This is the result of my efforts. I hope that it is useful to you.

    The far two columns on the right indicate how many blood and rain are needed to make the sub component. In the case of the emblem, you don't actually need a blood to make it, but the gray diamond used in the recipe needs a blood.

    Code:
    Triv	Sub Component			Yield	Ingredients									Bloods	Rains
    ----	------------------------------	-----	------------------------------------------------------------------------	------	------
      0	Vial of Distilled Mana			Poison Vial, Sapphire(2)							0	0
      0	Gray Diamond of Storms			Raw Diamond, Spell: Imbue Storm, Storm Rider Blood				1	0
      0	Powdered Sandstorm Pearl	[4]	Sandstorm Pearl(3)								0	0
    135	Enchanted Electrified Copper		Brick of Electrified Copper, Vial of Distilled Mana				0	0
    135	Hurricane Temper			A Drop of Pure Rain, Powdered Sandstorm Pearl, Storm Rider Blood		1	1
    287	Emblem of Storms			Blank Emblem, Enchanted Electrified Copper, Gray Diamond of Storms		1	0
    The far two columns on the right indicate how many blood and rain are needed to make the sub component, but as you can see, it has decimal places. The recipe for the rings yields two, so one blood and one rain gives you two rings. So I chose to claim that half a blood and half a rain makes a ring. It is used in the calculations for the chain and plate recipes.

    Similarly to the table above, you don't actually use a blood nor a rain to make a sheet of copper for example, but the hurricane temper used in the copper sheet recipe requires one blood and one rain.

    Code:
    Triv	Sub Component			Yield	Ingredients									Bloods	Rains
    ----	------------------------------	-----	------------------------------------------------------------------------	------	------
     66	Electrified Copper Rings	[2]	Brick of Electrified Copper, File, Hurricane Temper				0.5	0.5
     75	Sheet of Electrified Copper		Brick of Electrified Copper(2), Hurricane Temper, Tanaan Smithing Hammer	1	1
    228	Electrified Copper Chain Jointing	Electrified Copper Rings, File, Hurricane Temper, Tanaan Smithing Hammer	1.5	1.5
    The following items are common to all Hurricane chain recipes, so the counts for the blood and rain are included in the chain recipe table below. These items are also common to all Hurricane plate recipes, but will be repeated below the chain recipes and ahead of the plate recipes.

    Code:
    Common to all chain recipes:
    	Tanaan Smithing Hammer
    	Emblem of Storms		1 blood
    	Hurricane Temper		1 blood, 1 rain
    
    Triv	Armor				Ingredient			Ingredient			Bloods	Rains
    ----	------------------------	----------------------------	----------------------------	------	------
    >250	Hurricane Chain Boots		Chainmail Boot Pattern,		Electrified Copper Rings(2)	3	2
    >250	Hurricane Chain Bracer		Chainmail Bracelet Pattern,	Electrified Copper Rings	2.5	1.5
    308	Hurricane Chain Coif		Chainmail Coif Pattern,		Electrified Copper Rings(2)	3	2
    308	Hurricane Chain Gloves		Chainmail Glove Pattern,	Electrified Copper Rings(2)	3	2
    >250	Hurricane Chain Leggings	Chainmail Pant Pattern,		Electrified Copper Rings(3)	3.5	2.5
    308	Hurricane Chain Sleeves		Chainmail Sleeve Pattern,	Electrified Copper Rings(2)	3	2
    308	Hurricane Chain Tunic		Chainmail Tunic Pattern,	Electrified Copper Rings(3)	3.5	2.5
    The following items are common to all Hurricane plate recipes, so the counts for the blood and rain are included in the plate recipe table below.

    Code:
    Common to all plate recipes:
    	Tanaan Smithing Hammer
    	Emblem of Storms			1 blood
    	Hurricane Temper			1 blood, 1 rain
    	Electrified Copper Chain Jointing	1.5 blood, 1.5 rain
    	Superb Leather Padding
    
    Triv	Armor				Ingredient			Ingredient			Bloods	Rains
    ----	------------------------	----------------------------	----------------------------	------	------
    >250	Hurricane Plate Boots		Full Plate Boot Mold,		Sheet of Electrified Copper(2)	5.5	4.5
    >250	Hurricane Plate Bracer		Full Plate Bracer Mold,		Sheet of Electrified Copper	4.5	3.5
    308	Hurricane Plate Breastplate	Full Breastplate Mold,		Sheet of Electrified Copper(3)	6.5	5.5
    >250	Hurricane Plate Gauntlets	Full Plate Gauntlet Mold,	Sheet of Electrified Copper(2)	5.5	4.5
    >250	Hurricane Plate Greaves		Full Plate Greaves Mold,	Sheet of Electrified Copper(3)	6.5	5.5
    >250	Hurricane Plate Helm		Full Plate Helm Mold,		Sheet of Electrified Copper(2)	5.5	4.5
    308	Hurricane Plate Vambraces	Full Plate Vambrace Mold,	Sheet of Electrified Copper(2)	5.5	4.5

  • #2
    Here is a cost analysis of the Hurricane related armor and sub components. I used the merchant price for the dropped items. I will post a message with a CSV file which can be imported to a spreadsheet, wherein you can adjust the price for the dropped items. I used zero as the cost of the tools such as a file and the tanaan smithing hammer. The CSV file allows for changing the price for the tools.

    I tried to be sure that items which are used multiple times were entered once the first time, and subsequently referenced, so that you can change the first occurrence, and all the remaining occurrences will change. This means that you can use the file as a base to setup for some other kind of PoP armor without having to make too many changes.

    You will likely want to make column two of the spreadsheet wider. I chose a width of 25 for my column two. I also formatted columns three and four to be fixed three decimal places.

    Code:
    Vial of Distilled Mana (no-fail, cast spell)
      Poison Vial			  1.575
      Sapphire			104.999
      Sapphire			104.999
    				-------
    				211.573
    
    Gray Diamond of Storms (no-fail, cast spell)
      Raw Diamond			209.999
      Spell: Imbue Storm		  0.000
      Storm Rider Blood		 41.999
    				-------
    				251.998
    
    Powdered Sandstorm Pearl (no-fail, poison making, yield 4)
      Sandstorm Pearl		 20.999
      Sandstorm Pearl		 20.999
      Sandstorm Pearl		 20.999
    				-------
    				 62.997 / 4 = 15.749
    
    Enchanted Electrified Copper (trivial 135, smithing)
      Brick of Electrified Copper	 62.999
      Vial of Distilled Mana	211.573
    				-------
    				274.572 * 100 = 27457.200 / 95 = 289.023
    An explanation of the above line: I used 95% as a success rate to determine the cost of making one enchanted electrified copper. So, if I multiply the base cost by 100 attempts, then divide by 95 successes, I have what I use as a cost for a sub component to be entered in a subsequent recipes.

    Code:
    Hurricane Temper (trivial 135, brewing)
      A Drop of Pure Rain		 26.249
      Powdered Sandstorm Pearl	 15.749
      Storm Rider Blood		 41.999
    				-------
    				 83.997 / 100 = 8399.700 / 95 = 88.418
    
    Emblem of Storms (trivial 287, jewelcraft)
      Blank Emblem			  4.199
      Enchanted Electrified Copper	289.023
      Gray Diamond of Storms	251.998
    				-------
    				545.220 * 100 = 54522.000 / 88 = 619.568
    Regarding the above jewelcraft combine, I used 88% as a success rate as calculated by the trivial program someone posted here on EQTraders, and based on 252 maxxed skill.

    Code:
    Electrified Copper Rings (trivial 66, smithing, yield 2)
      Brick of Electrified Copper	 62.999
      File				  0.000
      Hurricane Temper		 88.418
    				-------
    				151.417 * 100 = 15141.700 / 95 = 159.386 / 2 = 79.693
    There is an additional divide by two above because the recipe yields two rings on success.

    Code:
    Sheet of Electrified Copper (trivial 75, smithing)
      Brick of Electrified Copper	 62.999
      Brick of Electrified Copper	 62.999
      Hurricane Temper		 88.418
      Tanaan Smithing Hammer	  0.000
    				-------
    				214.416 * 100 = 21441.600 / 95 = 225.701
    
    Electrified Copper Chain Jointing (trivial 228, smithing)
      Electrified Copper Rings	 79.693
      File				  0.000
      Hurricane Temper		 88.418
      Tanaan Smithing Hammer	  0.000
    				-------
    				168.111
    The 73% success rate used below for the final armor combine is based on a maxxed skill of 252, and assumed that all the armor trivials at 308.

    Code:
    Hurricane Chain Boots (trivial >250, probably 308, smithing)
      Tanaan Smithing Hammer	  0.000
      Emblem of Storms		619.568
      Hurricane Temper		 88.418
      Chainmail Boot Pattern	  7.350
      Electrified Copper Rings	 79.693
      Electrified Copper Rings	 79.693
    				-------
    				874.723 * 100 = 87472.300 / 73 = 1198.251
    
    Hurricane Chain Bracer (trivial >250, probably 308, smithing)
      Tanaan Smithing Hammer	  0.000
      Emblem of Storms		619.568
      Hurricane Temper		 88.418
      Chainmail Bracelet Pattern	  2.099
      Electrified Copper Rings	 79.693
    				-------
    				789.779 * 100 = 78977.900 / 73 = 1081.889
    
    Hurricane Chain Coif (trivial 308, smithing)
      Tanaan Smithing Hammer	  0.000
      Emblem of Storms		619.568
      Hurricane Temper		 88.418
      Chainmail Coif Pattern	  4.199
      Electrified Copper Rings	 79.693
      Electrified Copper Rings	 79.693
    				-------
    				871.572 * 100 = 87157.200 / 73 = 1193.934
    
    Hurricane Chain Gloves (trivial 308, smithing)
      Tanaan Smithing Hammer	  0.000
      Emblem of Storms		619.568
      Hurricane Temper		 88.418
      Chainmail Glove Pattern	  7.349
      Electrified Copper Rings	 79.693
      Electrified Copper Rings	 79.693
    				-------
    				874.722 * 100 = 87472.200 / 73 = 1198.249
    
    Hurricane Chain Leggings (trivial >250, probably 308, smithing)
      Tanaan Smithing Hammer	  0.000
      Emblem of Storms		619.568
      Hurricane Temper		 88.418
      Chainmail Pant Pattern	  7.349
      Electrified Copper Rings	 79.693
      Electrified Copper Rings	 79.693
      Electrified Copper Rings	 79.693
    				-------
    				954.415 * 100 = 95441.500 / 73 = 1307.419
    
    Hurricane Chain Sleeves (trivial 308, smithing)
      Tanaan Smithing Hammer	  0.000
      Emblem of Storms		619.568
      Hurricane Temper		 88.418
      Chainmail Sleeve Pattern	  4.199
      Electrified Copper Rings	 79.693
      Electrified Copper Rings	 79.693
    				-------
    				871.572 * 100 = 87157.200 / 73 = 1193.934
    
    Hurricane Chain Tunic (trivial 308, smithing)
      Tanaan Smithing Hammer	  0.000
      Emblem of Storms		619.568
      Hurricane Temper		 88.418
      Chainmail Tunic Pattern	  8.399
      Electrified Copper Rings	 79.693
      Electrified Copper Rings	 79.693
      Electrified Copper Rings	 79.693
    				-------
    				955.465 * 100 = 95546.500 / 73 = 1308.856
    Code:
    Hurricane Plate Boots (trivial >250, probably 308, smithing)
      Tanaan Smithing Hammer		   0.000
      Emblem of Storms			 619.568
      Hurricane Temper			  88.418
      Electrified Copper Chain Jointing	 176.959
      Superb Leather Padding		  25.199
      Full Plate Boot Mold			  52.499
      Sheet of Electrified Copper		 225.701
      Sheet of Electrified Copper		 225.701
    					--------
    					1414.046 * 100 = 141404.600 / 73 = 1937.050
    
    Hurricane Plate Bracer (trivial >250, probably 308, smithing)
      Tanaan Smithing Hammer		   0.000
      Emblem of Storms			 619.568
      Hurricane Temper			  88.418
      Electrified Copper Chain Jointing	 176.959
      Superb Leather Padding		  25.199
      Full Plate Bracer Mold		  26.249
      Sheet of Electrified Copper		 225.701
    					--------
    					1162.095 * 100 = 116209.500 / 73 = 1591.99
    
    Hurricane Plate Breastplate (trivial 308, smithing)
      Tanaan Smithing Hammer		   0.000
      Emblem of Storms			 619.568
      Hurricane Temper			  88.418
      Electrified Copper Chain Jointing	 176.959
      Superb Leather Padding		  25.199
      Full Breastplate Mold			  92.399
      Sheet of Electrified Copper		 225.701
      Sheet of Electrified Copper		 225.701
      Sheet of Electrified Copper		 225.701
    					--------
    					1679.648 * 100 = 167964.800 / 73 = 2300.887
    
    Hurricane Plate Gauntlets (trivial >250, probably 308, smithing)
      Tanaan Smithing Hammer		   0.000
      Emblem of Storms			 619.568
      Hurricane Temper			  88.418
      Electrified Copper Chain Jointing	 176.959
      Superb Leather Padding		  25.199
      Full Plate Gauntlet Mold		  31.499
      Sheet of Electrified Copper		 225.701
      Sheet of Electrified Copper		 225.701
    					--------
    					1393.046 * 100 = 139304.600 / 73 = 1908.283
    
    Hurricane Plate Greaves (trivial >250, probably 308, smithing)
      Tanaan Smithing Hammer		   0.000
      Emblem of Storms			 619.568
      Hurricane Temper			  88.418
      Electrified Copper Chain Jointing	 176.959
      Superb Leather Padding		  25.199
      Full Plate Greaves Mold		  81.899
      Sheet of Electrified Copper		 225.701
      Sheet of Electrified Copper		 225.701
      Sheet of Electrified Copper		 225.701
    					--------
    					1669.148 * 100 = 166914.800 / 73 = 2286.503
    
    Hurricane Plate Helm (trivial >250, probably 308, smithing)
      Tanaan Smithing Hammer		   0.000
      Emblem of Storms			 619.568
      Hurricane Temper			  88.418
      Electrified Copper Chain Jointing	 176.959
      Superb Leather Padding		  25.199
      Full Plate Helm Mold			  52.499
      Sheet of Electrified Copper		 225.701
      Sheet of Electrified Copper		 225.701
    					--------
    					1414.046 * 100 = 141404.600 / 73 = 1937.050
    
    Hurricane Plate Vambraces (trivial 308, smithing)
      Tanaan Smithing Hammer		   0.000
      Emblem of Storms			 619.568
      Hurricane Temper			  88.418
      Electrified Copper Chain Jointing	 176.959
      Superb Leather Padding		  25.199
      Full Plate Vambrace Mold		  47.249
      Sheet of Electrified Copper		 225.701
      Sheet of Electrified Copper		 225.701
    					--------
    					1408.796 * 100 = 140879.600 / 73 = 1929.858

    Comment


    • #3
      Enter your preferred prices here for dropped items / crafted tools / etc,

      ,Raw Diamond,209.999
      ,Spell: Imbue Storm,0.000
      ,Storm Rider Blood,41.999
      ,Sandstorm Pearl,20.999
      ,Brick of Electrified Copper,62.999
      ,A Drop of Pure Rain,26.249
      ,File,0.000
      ,Tanaan Smithing Hammer,0.000





      Vial of Distilled Mana (no-fail - cast spell),
      ,Poison Vial,1.575
      ,Sapphire,104.999
      ,=B18,=C18
      ,,--------------
      ,,=SUM(C17..C19)

      Gray Diamond of Storms (no-fail - cast spell),
      ,=B3,=C3
      ,=B4,=C4
      ,=B5,=C5
      ,,--------------
      ,,=SUM(C24..C26)

      Powdered Sandstorm Pearl (no-fail - poison making - yield 4),
      ,=B6,=C6
      ,=B6,=C6
      ,=B6,=C6
      ,,--------------
      ,,=SUM(C31..C33),=C35/4

      Enchanted Electrified Copper (trivial 135 - smithing),
      ,=B7,=C7
      ,Vial of Distilled Mana,=C21
      ,,--------------
      ,,=SUM(C38..C39),=(C41*100)/95

      Hurricane Temper (trivial 135 - brewing),
      ,=B8,=C8
      ,Powdered Sandstorm Pearl,=D35
      ,=B5,=C5
      ,,--------------
      ,,=SUM(C44..C46),=(C48*100)/95

      Emblem of Storms (trivial 287 - jewelcraft),
      ,Blank Emblem,4.199
      ,Enchanted Electrified Copper,=D41
      ,Gray Diamond of Storms,=C28
      ,,--------------
      ,,=SUM(C51..C53),=(C55*100)/88

      Electrified Copper Rings (trivial 66 - smithing - yield 2),
      ,=B7,=C7
      ,=B9,=C9
      ,Hurricane Temper,=D48
      ,,--------------
      ,,=SUM(C58..C60),=((C62*100)/95)/2

      Sheet of Electrified Copper (trivial 75 - smithing),
      ,=B7,=C7
      ,=B7,=C7
      ,=B60,=D48
      ,=B10,=C10
      ,,--------------
      ,,=SUM(C65..C68),=(C70*100)/95

      Electrified Copper Chain Jointing (trivial 228 - smithing),
      ,Electrified Copper Rings,=D62
      ,=B9,=C9
      ,=B60,=D48
      ,=B10,=C10
      ,,--------------
      ,,=SUM(C73..C76),=(C78*100)/95

      Hurricane Chain Boots (trivial >250 - probably 308 - smithing),
      ,=B10,=C10
      ,Emblem of Storms,=D55
      ,=B60,=D48
      ,Chainmail Boot Pattern,7.350
      ,=B73,=D62
      ,=B73,=D62
      ,,--------------
      ,,=SUM(C81..C86),=(C88*100)/73

      Hurricane Chain Bracer (trivial >250 - probably 308 - smithing),
      ,=B10,=C10
      ,=B82,=D55
      ,=B60,=D48
      ,Chainmail Bracelet Pattern,2.099
      ,=B73,=D62
      ,,--------------
      ,,=SUM(C91..C95),=(C97*100)/73

      Hurricane Chain Coif (trivial 308 - smithing),
      ,=B10,=C10
      ,=B82,=D55
      ,=B60,=D48
      ,Chainmail Coif Pattern,4.199
      ,=B73,=D62
      ,=B73,=D62
      ,,--------------
      ,,=SUM(C100..C105),=(C107*100)/73

      Hurricane Chain Gloves (trivial 308 - smithing),
      ,=B10,=C10
      ,=B82,=D55
      ,=B60,=D48
      ,Chainmail Glove Pattern,7.349
      ,=B73,=D62
      ,=B73,=D62
      ,,--------------
      ,,=SUM(C110..C115),=(C117*100)/73

      Hurricane Chain Leggings (trivial >250 - probably 308 - smithing),
      ,=B10,=C10
      ,=B82,=D55
      ,=B60,=D48
      ,Chainmail Pant Pattern,7.349
      ,=B73,=D62
      ,=B73,=D62
      ,=B73,=D62
      ,,--------------
      ,,=SUM(C120..C126),=(C128*100)/73

      Hurricane Chain Sleeves (trivial 308 - smithing),
      ,=B10,=C10
      ,=B82,=D55
      ,=B60,=D48
      ,Chainmail Sleeve Pattern,4.199
      ,=B73,=D62
      ,=B73,=D62
      ,,--------------
      ,,=SUM(C131..C136),=(C138*100)/73

      Hurricane Chain Tunic (trivial 308 - smithing),
      ,=B10,=C10
      ,=B82,=D55
      ,=B60,=D48
      ,Chainmail Tunic Pattern,8.399
      ,=B73,=D62
      ,=B73,=D62
      ,=B73,=D62
      ,,--------------
      ,,=SUM(C141..C147),=(C149*100)/73

      Hurricane Plate Boots (trivial >250 - probably 308 - smithing),
      ,=B10,=C10
      ,=B82,=D55
      ,=B60,=D48
      ,Electrified Copper Chain Jointing,=D78
      ,Superb Leather Padding,25.199
      ,Full Plate Boot Mold,52.499
      ,Sheet of Electrified Copper,=D70
      ,=B158,=D70
      ,,--------------
      ,,=SUM(C152..C159),=(C161*100)/73

      Hurricane Plate Bracer (trivial >250 - probably 308 - smithing),
      ,=B10,=C10
      ,=B82,=D55
      ,=B60,=D48
      ,=B155,=D78
      ,=B156,=C156
      ,Full Plate Bracer Mold,26.249
      ,=B158,=D70
      ,,--------------
      ,,=SUM(C164..C170),=(C172*100)/73

      Hurricane Plate Breastplate (trivial 308 - smithing),
      ,=B10,=C10
      ,=B82,=D55
      ,=B60,=D48
      ,=B155,=D78
      ,=B156,=C156
      ,Full Breastplate Mold,92.399
      ,=B158,=D70
      ,=B158,=D70
      ,=B158,=D70
      ,,--------------
      ,,=SUM(C175..C183),=(C185*100)/73

      Hurricane Plate Gauntlets (trivial >250 - probably 308 - smithing),
      ,=B10,=C10
      ,=B82,=D55
      ,=B60,=D48
      ,=B155,=D78
      ,=B156,=C156
      ,Full Plate Gauntlet Mold,31.499
      ,=B158,=D70
      ,=B158,=D70
      ,,--------------
      ,,=SUM(C188..C195),=(C197*100)/73

      Hurricane Plate Greaves (trivial >250 - probably 308 - smithing),
      ,=B10,=C10
      ,=B82,=D55
      ,=B60,=D48
      ,=B155,=D78
      ,=B156,=C156
      ,Full Plate Greaves Mold,81.899
      ,=B158,=D70
      ,=B158,=D70
      ,=B158,=D70
      ,,--------------
      ,,=SUM(C200..C208),=(C210*100)/73

      Hurricane Plate Helm (trivial >250 - probably 308 - smithing),
      ,=B10,=C10
      ,=B82,=D55
      ,=B60,=D48
      ,=B155,=D78
      ,=B156,=C156
      ,Full Plate Helm Mold,52.499
      ,=B158,=D70
      ,=B158,=D70
      ,,--------------
      ,,=SUM(C213..C220),=(C222*100)/73

      Hurricane Plate Vambraces (trivial 308 - smithing),
      ,=B10,=C10
      ,=B82,=D55
      ,=B60,=D48
      ,=B155,=D78
      ,=B156,=C156
      ,Full Plate Vambrace Mold,47.249
      ,=B158,=D70
      ,=B158,=D70
      ,,--------------
      ,,=SUM(C225..C232),=(C234*100)/73

      Comment

      Working...
      X