Elitist Jerks » Search Forums Search Results

Username Remember me? Password

Showing results 1 to 30 of 30 Search took 0.01 seconds. Search: Posts Made By: Bokomatic

Forum: Hunters 04/29/09, 10:22 AM

Replies: 4,353 WotLK DPS spreadsheet Views: 2,348,287 Posted By Bokomatic Hi, Shandara. I've downloaded spreadsheet v87c... Hi, Shandara. I've downloaded spreadsheet v87c and found a little bug concerning 'Import' button. Sheet36, Line 110 list = Worksheets("Gear").Range("W90").value Sheet36, Line 113 If Not...

Forum: Hunters 03/03/09, 11:34 AM

Replies: 4,353 WotLK DPS spreadsheet Views: 2,348,287 Posted By Bokomatic I know formula :) Number of crits possible from n... I know formula :) Number of crits possible from n shots has binomial distibution...

Forum: Hunters 03/02/09, 1:14 PM

Replies: 4,353 WotLK DPS spreadsheet Views: 2,348,287 Posted By Bokomatic I've debugged it ^^ kek Russified XL translated... I've debugged it ^^ kek Russified XL translated name of "INDIRECT" function in russian, so next "If" didn't work. Patch for russified XL: If InStr(list, "INDIRECT") > 0 Or InStr(list, "ДВССЫЛ") > 0...

Forum: Hunters 03/02/09, 12:00 PM

Replies: 4,353 WotLK DPS spreadsheet Views: 2,348,287 Posted By Bokomatic I clicked "Debug" - debugger said error in the... I clicked "Debug" - debugger said error in the first string of following (If). If Not Worksheets(sheet).Range(list).Find(bit, , , xlWhole) Is Nothing Then ...

Forum: Hunters 03/02/09, 10:12 AM

Replies: 4,353 WotLK DPS spreadsheet Views: 2,348,287 Posted By Bokomatic Yeah, I use "Export Gear String" and "Import Gear... Yeah, I use "Export Gear String" and "Import Gear String". Sorry, I thought that it's implemented by .bin file. Anyways VB reports about "Error 9". It doesn't work in my system. I have no idea why...

Forum: Hunters 03/02/09, 9:44 AM

Replies: 4,353 WotLK DPS spreadsheet Views: 2,348,287 Posted By Bokomatic Doesn't work for me. I did export - successful.... Doesn't work for me. I did export - successful. Next, import and... Microsoft Visual Basic reports: Run-time error '9': Subscript out of range Actually i even can't find export file. I saw...

Forum: Hunters 03/02/09, 6:15 AM

Replies: 4,353 WotLK DPS spreadsheet Views: 2,348,287 Posted By Bokomatic Yup, I didn't think too about these ID... Yup, I didn't think too about these ID before. I've found easy but slow way to import gear in your spreadsheet. I can create excel file containing the same info as 'gear' tab. Next I modify...

Forum: Hunters 03/02/09, 4:50 AM

Replies: 4,353 WotLK DPS spreadsheet Views: 2,348,287 Posted By Bokomatic I even know such single-string ^^ Item Comparison... I even know such single-string ^^ Item Comparison Tool - World of Warcraft...

Forum: Hunters 03/02/09, 2:40 AM

Replies: 4,353 WotLK DPS spreadsheet Views: 2,348,287 Posted By Bokomatic A little bit non-standart question: Is there... A little bit non-standart question: Is there possibility to fast import gear in Shandara spreadsheet without armory? I mean some trick like "Copy"/"Past Special". I need to import gear that i don't...

Forum: Hunters 02/26/09, 4:59 AM

Replies: 4,353 WotLK DPS spreadsheet Views: 2,348,287 Posted By Bokomatic Two day ago I found new sevice at... Two day ago I found new sevice at wowhead.com It's Stat Weighting tool (http://www.wowhead.com/?help=stat-weighting), curently in beta state. There is a possibility to import there Shandara's weights...

Forum: Hunters 02/23/09, 8:39 PM

Replies: 4,353 WotLK DPS spreadsheet Views: 2,348,287 Posted By Bokomatic I've never posted to this thread. So, first I... I've never posted to this thread. So, first I greatly appreciate Shandara for his effort in improvement of this amazing spreadsheet. Before nerf of BM-spec I had my own spreadsheet made by me just...

Forum: Hunters 12/26/08, 1:33 AM

Replies: 61 Lethal shots not effecting my autoshot or steady shot Views: 26,021 Posted By Bokomatic I'd been faced with the same problem, lowering my... I'd been faced with the same problem, lowering my paperdoll crit when attacking high lvl target. I'm 75lvl, testing on 80lvl target dummy. So it's 5lvl higher me (Defense Skill - Weapon Skill =...

Forum: Shamans 05/08/08, 7:34 AM

Replies: 1,591 How to Heal like a Pro Views: 1,088,081 Posted By Bokomatic I'm working on something like this. It will be... I'm working on something like this. It will be new sheet in my spreadshhet named 'Healper'. It will work in the following way: 1) You enter stats (heal/haste/crit/spirit) 2) You enter HPS. 3) Sheet...

Forum: Shamans 04/26/08, 7:58 AM

Replies: 1,591 How to Heal like a Pro Views: 1,088,081 Posted By Bokomatic I've tried to do reverse engineering of... I've tried to do reverse engineering of shamstats110208.xls for extracting some information about HEP used in this thread. I describe now what i've got, tell me please if i'm wrong with...

Forum: Shamans 04/22/08, 5:35 PM

Replies: 1,591 How to Heal like a Pro Views: 1,088,081 Posted By Bokomatic I rechecked ToLW, you are right, spell doesn't... I rechecked ToLW, you are right, spell doesn't cost 393=513-20, it costs 394. I cant check T6 bonus :((( Ohh i so want to be able to check it :))) One comment to your formula and your data. There...

Forum: Shamans 04/22/08, 1:05 PM

Replies: 1,591 How to Heal like a Pro Views: 1,088,081 Posted By Bokomatic I've added 3pcT2, 2pcT6 and 4pcT6 bonuses in... I've added 3pcT2, 2pcT6 and 4pcT6 bonuses in spreadsheet. Download: RSSSS_v109.rar (77kB) (http://www.divshare.com/download/4322293-e01) or RSSSS_v109.zip (112kB)...

Forum: Shamans 04/22/08, 9:08 AM

Replies: 1,591 How to Heal like a Pro Views: 1,088,081 Posted By Bokomatic I've tested Mana = (( 1 - TidalFocus ) * BaseMana... I've tested Mana = (( 1 - TidalFocus ) * BaseMana ) - RelicMana. It's right. I don't sure about Mana = (( 1 - 2pcT6 - TidalFocus ) * BaseMana ) Get a simple example from 1st page of this...

Forum: Shamans 04/22/08, 7:34 AM

Replies: 1,591 How to Heal like a Pro Views: 1,088,081 Posted By Bokomatic Ok. Concerning 3pcT2, 2pcT6, 4pcT6. Current... Ok. Concerning 3pcT2, 2pcT6, 4pcT6. Current formulae for CH are: Mana = BaseMana * TidalFocus - RelicMana HealJump0= ( BaseHeal + SpellCoeff * DownrankCoeff * ( Healing + RelicHealing ) ) *...

Forum: Shamans 04/21/08, 4:00 PM

Replies: 1,591 How to Heal like a Pro Views: 1,088,081 Posted By Bokomatic Hmm... so we just need HEP equivalents for each... Hmm... so we just need HEP equivalents for each stats. Right? Do you mean this here? I checked Shamstats and found there calculations of HEP equivalents for each stat. Do you use these equivalency...

Forum: Shamans 04/20/08, 12:21 AM

Replies: 1,591 How to Heal like a Pro Views: 1,088,081 Posted By Bokomatic Skyhoof, what formulae do you use for calculating... Skyhoof, what formulae do you use for calculating HEP? Where can I check them out ? Thanks for info in advance ^^ ------------------- SPREADSHEET REBUILD...

Forum: Shamans 04/19/08, 3:00 AM

Replies: 1,591 How to Heal like a Pro Views: 1,088,081 Posted By Bokomatic I have one more principal question, mates... I have one more principal question, mates =) What kind of HEP do you use in this thread? I've downloaded shamstats110208.xls by Binkenstein and i tried to understand what his HEP means. If you use...

Forum: Shamans 04/17/08, 10:02 AM

Replies: 1,591 How to Heal like a Pro Views: 1,088,081 Posted By Bokomatic Hmm... In my opinion spellcrit differs from any... Hmm... In my opinion spellcrit differs from any other way to increase my hps. Each player have his own overheal percentage based on his preferably playstyle. I.e. if i have more +healing i will...

Forum: Shamans 04/17/08, 3:18 AM

Replies: 1,591 How to Heal like a Pro Views: 1,088,081 Posted By Bokomatic A little comment to crit value... A little comment to crit value estimating. Everyone knows that healing crits go to overheal more often than normal heals. It happens just because you predict how much you should to heal now and you...

Forum: Shamans 04/14/08, 2:55 AM

Replies: 1,591 How to Heal like a Pro Views: 1,088,081 Posted By Bokomatic Thanks Daidalos and Mestok for new data... Thanks Daidalos and Mestok for new data concerning HST. I've included it to my minimax table. Atm the HST coeffs bracket is [ 4,395%; 4,405% ] or talented [ 6,043% ; 6,057% ]. So 6.05% talented...

Forum: Shamans 04/03/08, 1:15 PM

Replies: 1,591 How to Heal like a Pro Views: 1,088,081 Posted By Bokomatic Hey! :) Im strongly disagree with using... Hey! :) Im strongly disagree with using bluepost/wiki formula (next rank lvl + 5 )/70 for downranking penalty. Simple example: Chain Heal Rank3 Lvl Learned = 54 Next Rank Lvl Learned = 61

Forum: Shamans 04/03/08, 7:43 AM

Replies: 1,591 How to Heal like a Pro Views: 1,088,081 Posted By Bokomatic (level learned+11)/70 are right formula. Ive... (level learned+11)/70 are right formula. Ive tested it for HW5-HW12, LHW2-LHW7 and CH1-CH5. It really works. In the same time (next rank lvl + 5)/70 doesn't work. As far as i understand you tested...

Forum: Shamans 04/01/08, 6:09 AM

Replies: 1,591 How to Heal like a Pro Views: 1,088,081 Posted By Bokomatic I tried to check if this value (4.3636%)... I tried to check if this value (4.3636%) corresponds with my experimental data and found that it doesn't. A little example: HST was dropped with +2299 HealingBonus. I see ticks for 163 and 164. So...

Forum: Shamans 03/31/08, 12:37 PM

Replies: 1,591 How to Heal like a Pro Views: 1,088,081 Posted By Bokomatic Its possible ofc, but i dont have T6 yet, so it... Its possible ofc, but i dont have T6 yet, so it will be unchecked data. Actually i think my spreadsheed is pretty casual and dont have something new in comparison with Daidalos' one. I made it just...

Forum: Shamans 03/31/08, 12:27 PM

Replies: 1,591 How to Heal like a Pro Views: 1,088,081 Posted By Bokomatic How did you get so precise value? Just alot of... How did you get so precise value? Just alot of experiments with different +healing and linear regression then? And about your spreadsheet... What does 'Healing/sec/mana' mean? For what purpose did...

Forum: Shamans 03/30/08, 7:46 AM

Replies: 1,591 How to Heal like a Pro Views: 1,088,081 Posted By Bokomatic I've made a little spreadsheet for shammy... I've made a little spreadsheet for shammy healing. I understand that everyone has his own spreadsheet for healing spells, but i discovered that some formulaes at wowwiki are incorrect, even based on...

Showing results 1 to 30 of 30