 The Paragon Wiki Archive documents the state of City of Heroes/Villains as it existed on December 1, 2012.
|
Difference between revisions of "Talk:Gaining the Field Crafter Badge"
From Paragon Wiki Archive
m (chat about external Google Docs spreadsheet) |
|||
| Line 2: | Line 2: | ||
: 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? [[User:Kessen|Kessen]] 16:22, 20 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? [[User:Kessen|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. --[[User:Ephemerus|Ephemerus]] 08:33, 22 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. --[[User:Ephemerus|Ephemerus]] 08:33, 22 December 2007 (UTC) | ||
| + | |||
| + | more detail on how my Google spreadsheet gets the salvage counts: | ||
| + | The [http://spreadsheets.google.com/pub?key=pwwhPw8k3ohSenW4gpfvWfQ&gid=2 Salvage Counts] tab columns are as follows: | ||
| + | * the Number Required column from [http://spreadsheets.google.com/pub?key=pwwhPw8k3ohSenW4gpfvWfQ&gid=0 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 | ||
Revision as of 11:20, 27 July 2008
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
