Difference between revisions of "User talk:Pus"
From MHWiki
Camomiletea (talk | contribs) (→Cheese Effect Sorting: new section) |
m (→Cheese Effect Sorting: +negative number sorting in string, ambigous) |
||
| Line 8: | Line 8: | ||
Hi! I noticed you did something to the weapons/bases tables concerning the sorting on the Cheese Effect column... Could you please explain? The current sorting system (before your changes) was outlined [[Talk:Traps#Freshness Chart|here]] - if you think your way is better, please post there with an explanation, so others know how to maintain it. Thanks! -- [[User:Camomiletea|Camomiletea]] 02:45, 9 June 2009 (UTC) | Hi! I noticed you did something to the weapons/bases tables concerning the sorting on the Cheese Effect column... Could you please explain? The current sorting system (before your changes) was outlined [[Talk:Traps#Freshness Chart|here]] - if you think your way is better, please post there with an explanation, so others know how to maintain it. Thanks! -- [[User:Camomiletea|Camomiletea]] 02:45, 9 June 2009 (UTC) | ||
| + | :Thank Camomiletea to raise this issue.<br><br> | ||
| + | :I upload google spreadsheets [http://spreadsheets.google.com/ccc?key=rOWWR02OH12oVSsyQrPEB-g] to update and maintain both weapons and bases. There are 4 sheets, Cheese effect, Weapon, Base and My Mouse Tally.<br><br> | ||
| + | :Cheese effect has values from -5 (Ultimately Stale) to 6 (Über Fresh), please see "cheese effect sheet". Sorting negative number on string format is ambiguous. That's why adding 5 into cheese effect value to make the value >= 0; 0 to 11. To make the string sorting happy, convert the number into 2 digit with landing zero. Multiplying the number by 3, give the figure minimum 00 and max 33. I pick the multiplier 3 because just in case we need to insert manually new "cheese effect", which is not necessary. ie: Ultimate Stale, Semi-Ultimate Stale (new), Very stale.<br><br> | ||
| + | :This is the reason, how I can make the update that fast :) The spreadsheet idea is to minimize work, time and error. All is done by spreadsheet, invest time on playing MH.<br><br> | ||
| + | :How to update *weapon statistic*, open weapon sheet, change cell A2 to identify ID# of the base (see base sheet). Copy A32:A119, edit on ==Combined Trap Statistics==, paste and save it. | ||
| + | :How to update *base statistic*, open base sheet, change cell A2 to identify ID# of the weapon (see weapon sheet). Copy A14:A49, edit on ==Combined Trap Statistics==, paste and save it. | ||
| + | :The last sheet is My mouse tally. Update B1:B6 for latest hunter information. Cut and paste from hunter profile, remove some unused information, put the number into spreadsheet D32:D107. Copy G1:G114 and paste it into WIKI. | ||
| + | Enjoy, [[User:Pus|Pus]] 04:04, 9 June 2009 (UTC) | ||
Revision as of 04:04, 9 June 2009
Hi! I noticed you are changing the minimum gold amounts for various mice. Please keep in mind that you cannot catch a 0oz Dwarf, so the migold for them is actually 451, not 450. Thanks! -- Camomiletea 21:44, 1 April 2009 (UTC)
Shelder vs. Shelder Turtle
The in-game name does not include the word "Turtle". [1] -- Camomiletea 23:39, 4 June 2009 (UTC)
Cheese Effect Sorting
Hi! I noticed you did something to the weapons/bases tables concerning the sorting on the Cheese Effect column... Could you please explain? The current sorting system (before your changes) was outlined here - if you think your way is better, please post there with an explanation, so others know how to maintain it. Thanks! -- Camomiletea 02:45, 9 June 2009 (UTC)
- Thank Camomiletea to raise this issue.
- I upload google spreadsheets [2] to update and maintain both weapons and bases. There are 4 sheets, Cheese effect, Weapon, Base and My Mouse Tally.
- Cheese effect has values from -5 (Ultimately Stale) to 6 (Über Fresh), please see "cheese effect sheet". Sorting negative number on string format is ambiguous. That's why adding 5 into cheese effect value to make the value >= 0; 0 to 11. To make the string sorting happy, convert the number into 2 digit with landing zero. Multiplying the number by 3, give the figure minimum 00 and max 33. I pick the multiplier 3 because just in case we need to insert manually new "cheese effect", which is not necessary. ie: Ultimate Stale, Semi-Ultimate Stale (new), Very stale.
- This is the reason, how I can make the update that fast :) The spreadsheet idea is to minimize work, time and error. All is done by spreadsheet, invest time on playing MH.
- How to update *weapon statistic*, open weapon sheet, change cell A2 to identify ID# of the base (see base sheet). Copy A32:A119, edit on ==Combined Trap Statistics==, paste and save it.
- How to update *base statistic*, open base sheet, change cell A2 to identify ID# of the weapon (see weapon sheet). Copy A14:A49, edit on ==Combined Trap Statistics==, paste and save it.
- The last sheet is My mouse tally. Update B1:B6 for latest hunter information. Cut and paste from hunter profile, remove some unused information, put the number into spreadsheet D32:D107. Copy G1:G114 and paste it into WIKI.
Enjoy, Pus 04:04, 9 June 2009 (UTC)
