I was working on a new spreadsheet for calculating whether certain BODs were worth filling, though combining HLOOKUP and VLOOKUP in the same spreadsheet has become daunting to me. I wanted to create something with pulldown menus where you could select 10/EX/COPPER/PLATEMAIL/LBOD but haven't gotten there.
As a check to see if my calculations were working, I first did a spot check on ingot prices on Atlantic based on available deeds (throwing out the outrageously priced ones and looking primarily at 1000 ingot deeds when available). More or less, these are the going prices today, with the odd observation that DC/Shadow actually costs more than copper:
Iron 150 ea
Dull Copper 145 ea
Shadow 225 ea
Copper 125 ea
Bronze 150 ea
Gold 175 ea
Agapite 325 ea
Verite 750 ea
Valorite 2000 ea (really? Sheesh)
Then I picked a middle of the road LBOD, 10/N/Copper Plate. I assumed at 120 Blacksmithing, no talisman, 100% success except for the tunic at 90% success, averaging 103 ingots per set. Multiply by 10 sets and 125 gold per ingot gives a total crafting price of 128,472.
10/N/Copper Platemail provides 910 points, approximately enough to buy (2) POF (I know you can't actually buy 2, you can only get 1 and lose the remaining points, but the calculations are useful nonetheless.) On LS, POF prices have started to increase again, I've been selling them for 90,000 each. Based on these calcs, that's a profit of 40%.
If I use the higher priced shadow ingots and take into account lost ingots due to lower success rate, I calculate for a 20/Ex/Shadow Plate LBOD a total of 168 ingots per set, then again multiply by 20 and then the ingot price to get a total cost of 758,000. 20/Ex/Shadow Platemail LBOD also yields 900 points at a substantially higher cost. Again, I get (2) POFs I can sell for a total of 180,000 gp, a net loss of 76%.
As you can see, crafting costs are all over the map. If you're selling rewards, there are only a few reliable sellers. POF at 90k, Copper hammers at 225k, Bronze hammers at 265k. Based on what it costs to craft and using the gp/point ratio of POF, that's about 200 gp/pt. A copper runic hammer is 650 pts for 225k, or 346 gp/pt which is more profitable to sell.
Then some things are squirrely to calculate. a 10N/Gold Platemail LBOD is 1030 ingots at a total cost of 179,861 and provides 810 points, just enough to cash in for a gold miner's map at 700 points (you could also cash in for a 800 +15 scroll, but you'd be an idiot for doing so). The miners map comes with a random number of charges, around 245 uses, netting you 490 golden ingots, about 1/2 the ingots it took you to claim the map at almost a 50% loss.
Just an observation. I enjoy doing LBODs - it's something I can do while laggy on a hotspot tethering connection - but if I did my numbers right, LBOD collection is not a profitable endeavor unless I'm selective at which LBODs I'm going to do and whith which ingot.
Hence the need for the spreadsheet I started working on.
As a check to see if my calculations were working, I first did a spot check on ingot prices on Atlantic based on available deeds (throwing out the outrageously priced ones and looking primarily at 1000 ingot deeds when available). More or less, these are the going prices today, with the odd observation that DC/Shadow actually costs more than copper:
Iron 150 ea
Dull Copper 145 ea
Shadow 225 ea
Copper 125 ea
Bronze 150 ea
Gold 175 ea
Agapite 325 ea
Verite 750 ea
Valorite 2000 ea (really? Sheesh)
Then I picked a middle of the road LBOD, 10/N/Copper Plate. I assumed at 120 Blacksmithing, no talisman, 100% success except for the tunic at 90% success, averaging 103 ingots per set. Multiply by 10 sets and 125 gold per ingot gives a total crafting price of 128,472.
10/N/Copper Platemail provides 910 points, approximately enough to buy (2) POF (I know you can't actually buy 2, you can only get 1 and lose the remaining points, but the calculations are useful nonetheless.) On LS, POF prices have started to increase again, I've been selling them for 90,000 each. Based on these calcs, that's a profit of 40%.
If I use the higher priced shadow ingots and take into account lost ingots due to lower success rate, I calculate for a 20/Ex/Shadow Plate LBOD a total of 168 ingots per set, then again multiply by 20 and then the ingot price to get a total cost of 758,000. 20/Ex/Shadow Platemail LBOD also yields 900 points at a substantially higher cost. Again, I get (2) POFs I can sell for a total of 180,000 gp, a net loss of 76%.
As you can see, crafting costs are all over the map. If you're selling rewards, there are only a few reliable sellers. POF at 90k, Copper hammers at 225k, Bronze hammers at 265k. Based on what it costs to craft and using the gp/point ratio of POF, that's about 200 gp/pt. A copper runic hammer is 650 pts for 225k, or 346 gp/pt which is more profitable to sell.
Then some things are squirrely to calculate. a 10N/Gold Platemail LBOD is 1030 ingots at a total cost of 179,861 and provides 810 points, just enough to cash in for a gold miner's map at 700 points (you could also cash in for a 800 +15 scroll, but you'd be an idiot for doing so). The miners map comes with a random number of charges, around 245 uses, netting you 490 golden ingots, about 1/2 the ingots it took you to claim the map at almost a 50% loss.
Just an observation. I enjoy doing LBODs - it's something I can do while laggy on a hotspot tethering connection - but if I did my numbers right, LBOD collection is not a profitable endeavor unless I'm selective at which LBODs I'm going to do and whith which ingot.
Hence the need for the spreadsheet I started working on.