User talk:Pus
From MHWiki
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)
- Very interesting. What is the "value" of the current stalest possible effect? (I'm thinking it's 00 based on what you said?) What will happen if a new even staler effect turns up? -- Camomiletea 04:18, 9 June 2009 (UTC)
- You are right, currently 00. The range is 0-11 with 2 space in between. If we can put it in the middle, starting 33,36,.....63,66, that will be cover the possibilities. Spreadsheets updated. Pus 04:32, 9 June 2009 (UTC)