Talk:Gaining the Field Crafter Badge

From Unofficial Homecoming Wiki
Revision as of 11:20, 27 July 2008 by imported>Bort13 (chat about external Google Docs spreadsheet)
Jump to navigation Jump to search

Why isn't the cost of the field crafter badge equal to the difference between the cost of getting every memorization badge and getting the non-required 5th tier? Also using salvage reciped counts towards the 1000 required. --Ephemerus 22:29, 19 December 2007 (UTC)

Sigh, someone should go over this again, I should be able to go over it over the Christams break, but I make no promises. And I'm not sure what you mean in the last statment, could you rephrase it? Kessen 16:22, 20 December 2007 (UTC)
The statement that you have to craft 1000 enhancement is false as you can craft a bunch of base components which is much easier and practically free if not income generating. --Ephemerus 08:33, 22 December 2007 (UTC)

more detail on how my Google spreadsheet gets the salvage counts: The Salvage Counts tab columns are as follows:

  • the Number Required column from the first tab
  • the next few columns are pasted from the first tab, appending each of Salvage 1, Salvage 2 & Salvage 3. I checked them for length each paste. Total is calculated
  • the Unique Salvage column gets unique values from the salvage column, using
=unique(D2:D176)
  • The Quantity Counts column grabs sums from the Total column using values in the Salvage column using
=sumif($D$2:$D$176,E2,$C$2:$C$176)

I wasn't sure how to incorporate the total information without cluttering up the page, so I reference the document externally. If someone figures out a good way to capture this info in the wiki, that's where it should be. - Lem