tag:blogger.com,1999:blog-8558011570345628688.post2615387385314914644..comments2023-10-01T11:14:14.368-04:00Comments on The Egg Baron: Converting Skillpoints to GoldPhilhttp://www.blogger.com/profile/06525149260217843564noreply@blogger.comBlogger19125tag:blogger.com,1999:blog-8558011570345628688.post-59691416831945804412013-02-04T10:45:31.172-05:002013-02-04T10:45:31.172-05:00I have updated the spreadsheet. Please go to my la...I have updated the spreadsheet. Please go to my latest blog post for more information (http://eggbaron.blogspot.ca/2013/02/converting-skill-points-to-gold-update.html).Philhttps://www.blogger.com/profile/06525149260217843564noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-77350153437053020632013-02-01T06:32:55.937-05:002013-02-01T06:32:55.937-05:00Alright there we go seems to be working again. I t...Alright there we go seems to be working again. I think it was getting bad data from GW2Spidy and crashing.Philhttps://www.blogger.com/profile/06525149260217843564noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-32675225958819862152013-02-01T06:27:41.297-05:002013-02-01T06:27:41.297-05:00Hold on there is still an issue. I'll look int...Hold on there is still an issue. I'll look into it. :)<br /><br />The new version is almost done. I might just work on that and release it later today. We shall see how long this takes me to fix.Philhttps://www.blogger.com/profile/06525149260217843564noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-6277566703732612272013-02-01T06:22:35.939-05:002013-02-01T06:22:35.939-05:00Thanks for pointing that out, seems something brok...Thanks for pointing that out, seems something broke the triggers that keep the sheet up-to-date. I have rebuilt the triggers, and updated the sheet.<br /><br />Thanks again!Philhttps://www.blogger.com/profile/06525149260217843564noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-39367389641564692792013-02-01T06:19:05.246-05:002013-02-01T06:19:05.246-05:00Good day sir,
I have noticed that the uploaded sh...Good day sir, <br />I have noticed that the uploaded sheet in this topic is not updated by GW2spidy since 13:00 UTC 31-01-13. but GW2spidy is online, is this an error?<br /><br />Thank you, <br />AnonAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-84136330136091829522013-01-29T09:40:15.257-05:002013-01-29T09:40:15.257-05:00No worries, it is nice to know people are double c...No worries, it is nice to know people are double checking my math :DPhilhttps://www.blogger.com/profile/06525149260217843564noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-39952050497075297812013-01-29T09:38:41.129-05:002013-01-29T09:38:41.129-05:00Lets put it this way and it is good you make me ch...Lets put it this way and it is good you make me check this :D<br /><br />Costs = T6 * 1 + T5 * 250 + Dust * 5<br />Revenue = T6 * 18<br /><br />Profit = Revenue - Costs = T6 * 18 - (T6 * 1 + T5 * 250 + Dust * 5)<br /><br />if you simplify the above equation you can see how you can get away with ignoring the one T6 in your costs if you ignore one in your revenue. Technically the sheet is not reporting the correct costs, you are right, but it is recording the correct profits.Philhttps://www.blogger.com/profile/06525149260217843564noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-75756950872158728592013-01-29T09:38:35.974-05:002013-01-29T09:38:35.974-05:00AH, ofcoure! *facepalm* sorry:P
PS you can ignore...AH, ofcoure! *facepalm* sorry:P <br />PS you can ignore the Anon post of my "math" down here<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-14595516240704971312013-01-29T09:33:51.056-05:002013-01-29T09:33:51.056-05:00It would the first time you do it. But, then so lo...It would the first time you do it. But, then so long as you always just keep that one "seed" you can do it as many times as you want and never have to buy another one again.Philhttps://www.blogger.com/profile/06525149260217843564noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-36572982472993699552013-01-29T09:32:44.435-05:002013-01-29T09:32:44.435-05:00Looking at the sheet the total cost is calculated ...Looking at the sheet the total cost is calculated by:<br />Lower tier *250 + dust *5= total cost.<br />but doesn't the cost of the 1 next tier craft mat needs to be added? <br />Because you subtracted 1 of the output but doesn't need the total cost of the procedure needs to be increased?<br />Big chance I just totally missed your point, sorryAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-86803000999645775662013-01-29T09:13:25.285-05:002013-01-29T09:13:25.285-05:00Oh ok, thank you that is smart :P
But doesnt that...Oh ok, thank you that is smart :P <br />But doesnt that change the total cost?<br />Seeing as you need to buy 1 next tier craft.mat.?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-86144916071433926922013-01-29T09:06:40.684-05:002013-01-29T09:06:40.684-05:00No this is a good question, I take that into accou...No this is a good question, I take that into account in the average number of the new material produced. I have subtracted one from the average produced for each accounting for the requirement for needing one of the materials in recipe.Philhttps://www.blogger.com/profile/06525149260217843564noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-61187716393949422332013-01-29T09:03:47.859-05:002013-01-29T09:03:47.859-05:00Hello Mr. Baron
I'm new to Spreadsheets and c...Hello Mr. Baron<br /><br />I'm new to Spreadsheets and crafting mat. promotion but comparing your sheet and GW2wiki I noticed that GW2wiki notes that for Common craft promotion you also need 1 unit of the target craft tier, <br />example: from Silk Scrap to Gossamer Scrap you need to put 1 Gossamer Scrap in the forge as well)But I don't see this requirement in your Sheet. Did I miss this? <br />Anyway thx for the sheet and sorry for the maybe stupid question.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-11650172620411221492013-01-28T10:29:46.530-05:002013-01-28T10:29:46.530-05:00Thanks for commenting!
I too would love to get in...Thanks for commenting!<br /><br />I too would love to get into figuring out the lower tier mats. The main thing I need to work on is the conversion rates. I have read and experienced them being higher on the lower tiers which would effect profits. I will try to experiment with that in the future.<br /><br />As to your other concern, this spreadsheet would be difficult to modify in the way you have suggested. This first version of the spreadsheet was coded in a non-dynamic way that will prevent you from really modifying it.<br /><br />I am working on another version of the spreadsheet that is much more dynamic. When I release this you will be able to play around with it to your hearts content. Shortly after I release this "better" spreadsheet I hope to release the code I have written so that anyone can use it and modify it to create their own spreadsheets. The new stuff works way better and I am excited to share it with the community.Philhttps://www.blogger.com/profile/06525149260217843564noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-82578401961832887802013-01-28T10:21:37.522-05:002013-01-28T10:21:37.522-05:00Glad you are liking my stuff! The way you have my ...Glad you are liking my stuff! The way you have my news setup to feed to your site is fine. :D Thanks for sharing my articles with a larger audience.Philhttps://www.blogger.com/profile/06525149260217843564noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-70245200484604302802013-01-27T09:22:01.974-05:002013-01-27T09:22:01.974-05:00Awesome Spreadsheet, thank you very much! I would ...Awesome Spreadsheet, thank you very much! I would also love to see the profits with lower tier mats, since you also need less skillpoints for it and maybe the profit per skillpoint is higher. I copied the spreadsheet and tryed to adapt it to lower mats changing the id numbers, etc, but it didnt really adapt the prices after reloading it.. Am I missing something?<br /><br />Best Regards<br /><br />ZoCksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-47638638003495778072013-01-23T20:07:16.453-05:002013-01-23T20:07:16.453-05:00Hey The Egg Baron,
We love you and your content a...Hey The Egg Baron,<br /><br />We love you and your content and found your site through this post from another friendly site. Because your site and content is awesome, we've syndicated your content over in our community news section on Gold Wars 2 http://www.goldwars2.com/news/<br /><br />By default we post the full content of your articles, but we can truncate it down to excerpts only for you if you'd like (most are fine with the full content).<br /><br />Thanks!Gold Wars 2http://www.goldwars2.com/noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-29176876844893115232013-01-21T19:06:13.218-05:002013-01-21T19:06:13.218-05:00It compares the different profits that can be made...It compares the different profits that can be made from promoting one crafting material into another via the mystic forge. For example, you can take 50 Intricate Totems and turn then into a random number of Elaborate Totems. There can be profit in this depending on the number of Elaborate Totems you get and their market prices.<br /><br />Well this spreadsheet takes all the formula for promoting materials and determines the profit to be made in doign the promotion across a number of cases. If you get the worst case of materials, a low average, the average, a high average, and the best case. You can use this to determine where best to invest your limited skill points for profit.Philhttps://www.blogger.com/profile/06525149260217843564noreply@blogger.comtag:blogger.com,1999:blog-8558011570345628688.post-70583523719849419712013-01-21T15:17:24.138-05:002013-01-21T15:17:24.138-05:00For those new to the EggBaron, could you help clar...For those new to the EggBaron, could you help clarify what the spreadsheet essentially should be used for?<br /><br />Is this a crafting spreadsheet to aide in leveling for profit? Sorry for the silly question, I'm sure there are others who might ask the same. <br /><br />I see you went through the trouble and a lot of hard work to make it, so I'd personally like to be able to use it to its full potential.Anonymousnoreply@blogger.com