[X] My Assistant

Is there a way to increase boss spawnrates? Just found my first manbearpig in grindfest, and now I'm wondering whether it's possible to get them to pop more often to farm.

No.
As for the arena tip that has been given to you: no the spawn rate of bosses is not increased at all in the arenas, it's rather that you do meet them in arenas because it is scripted that you'd meet them there.

We do meet them randomly and very rarely in grindfest, item world and random encounters. But there is absolutely nothing (afaik) that influences this.

In arenas, you meet one boss in the last round pf arenas 50,55,60,65. 70 will have 2, 75 will have 3, 80 will have a schoolgirl instead, 90 1 SG + 1 boss. 100 will have the 3 goddesses+the tree. And after that you have the "schoolgirl arenas", which take quite a lot of time to complete, due to the fact that you have one HP tank that doesn't even hurt schoolgirl in every round.

Does Crit Damage have any cap? I was wondering if is worth to have several savage gear

the sum of P values + Fatality potencies. for example, i know that for DW Shade is 85% and for 1H Power is 82% - non level-dependant, since Crit Damage doesn't scale with level.

What weapon is suitable to increase parry for 1H? My block is only 44% and I lack the fund to increase it.

What weapon is suitable to increase parry for 1H? My block is only 44% and I lack the fund to increase it.

if your block is high enough, then you don't need to increase parry. but if you really, really need to, then go for a rapier of nimble. you'll lose a bit of ADB if compared to a rapier of slaughter though

I have only 300k now, should I use it to buy innate arcana?

i have an excel file with many spreadsheets. is it possible to do such that the titles of said spreadsheets are picked from a list of cells, rather than inserted manually?

I have only 300k now, should I use it to buy innate arcana?

1 and 2 are quite useful, so if you can yep, go for them.

Doesn't seem too bad.
I mean, I couldn't make it work with my reloader + Firefox (basically it only parses the last round) but whatever, I setup a quick chrome + vanilla reloader + CC and it worked like a charm.

Thanks first of all.
Yeah, this thing is very very beta as far as things go and i have no idea what restrictions FF has towards ES5/ES6 (IMG:[invalid] style_emoticons/default/heh.gif)
Usually i finish the functionality first, then test, then fix, repeat, and last check for compatibility with other scripts/browsers, then test, fix, repeat again (IMG:[invalid] style_emoticons/default/unsure.gif)

A question in general, seeing as there were more than 2 downloads ... is there interest for me to flesh this out more and build a proper script out of it? Don't want to sink hours into it when it won't get used. (IMG:[invalid] style_emoticons/default/sleep.gif)

I used no drain, no infusions no bubble-gum etc etc, there are some riddlemasters in there but I'm not failing them just to get reproducible averages.

Same parameters as i used essentially ... ED's are expensive (IMG:[invalid] style_emoticons/default/laugh.gif)

Here are the results:
--- 8< --- snip --- >8 ---

Sooo ...
"Important" observations first:
- Imperil + Holy approximately doubles the damage, though the addition ~70EDB might factor in too here in contrast to the 3x-4x i got with Fire.
-- Q: aside from the lazy/awesomeness-factor, might it be advantageous to still cast imperil? Trying to imperil 9 mobs is 3 casts at 0.6 turns/imperil, so 1.8 turns for all 3. Does the additional time spent offset the ~1.5 damage casts you could get in in that time?
- T3 : T2 : T1 ratio for holy (and i guess dark) seems to be approximately 1: 1.5 : 2, so not only are holy spells more expensive MP wise, also more expensive spells are cast more often comparatively
- Close to 1 prof factor (didn't calculate that one so just a guess from what i know of the 3+2 setup) basically eliminates the triple resist and almost eliminates the double resist. (Double Resists (75% resist) ~0.5% for TnT vs ~3% for DwD)

"Totally irrelevant" observations (IMG:[invalid] style_emoticons/default/wink.gif):
- 469 DwD takes about 102m dmg more to clear than 391 DwD
- You do about twice as much damage on average as me (gotta get gear and forge i guess)

i have an excel file with many spreadsheets. is it possible to do such that the titles of said spreadsheets are picked from a list of cells, rather than inserted manually?
1 and 2 are quite useful, so if you can yep, go for them.

Are you saying have it open to a menu page and select an icon ?

if so, VBA

Edit: If you mean originate new spreadsheets from a list of cells, you would have to either execute on opening, or..
or.... Execute from an icon in a cell via VBA.

Visual basic rules with both Excel and Access.. especially if you combine the two using ODBC, and maintain all your data in Access, using Excel to display and manipulate that data only via.... VBA.

True that, Excel only with macros is quick/simple.

But combine Access and Excel with VBA, and you have a "system" that can place a module on Mars.

This post has been edited by RoadShoe: Feb 15 2017, 15:08

i have an excel file with many spreadsheets. is it possible to do such that the titles of said spreadsheets are picked from a list of cells, rather than inserted manually?

Should be possible, though you'd need to write some VBA magic for that i think.
Google spat out [excel.tips.net] this

//Edit: too slow

This post has been edited by simrock87: Feb 15 2017, 14:56

i have an excel file with many spreadsheets. is it possible to do such that the titles of said spreadsheets are picked from a list of cells, rather than inserted manually?

Yes. Ths requires advanced excel. That is, if you mean that you want to use a formula that refers to one of the worksheets in the excel file, based on a drop down selection.

The function you need is[spreadsheetpro.net] "indirect"

Unless you mean something completely different?

This post has been edited by DJNoni: Feb 15 2017, 14:59

Are you saying have it open to a menu page and select an icon ?

if so, VBA

Should be possible, though you'd need to write some VBA magic for that i think.
Google spat out [excel.tips.net] this

//Edit: too slow

Yes. Ths requires advanced excel. That is, if you mean that you want to use a formula that refers to one of the worksheets in the excel file, based on a drop down selection.

The function you need is[spreadsheetpro.net] "indirect"

Unless you mean something completely different?

thank you for your answers. what i mean is that i have a first spreadsheet named Datas with cells A1, A2, ... and want the following spreadsheets to pick their names from said cells. something like this:

CODE

|   (cell A1)
|   (cell A2)
|   ....
|
|____________________________________________________
  |--------/|            /|            /|      /
  | Datas / | =Datas!A1 / | =Datas!A2 / | ... /
  |------/  |__________/  |__________/  |____/

my knowledge of VBA is almost zero, but i guess that would mean that if in one pc there are certain restrictions on VBA or the script machine doesn't work properly, then the following spreadsheets are quite fucked, right? consider that (=Datas!A1) and following contains further calculations, that may be further linked in other spreadsheets.
i guess the solution is indeed in said links, but is VBA the only way to do it?

[edit]: the link provided by simrock says the macro has to be run manually. i have 9 spreadsheets and potentially counting :3
[edit2]: thanks noni, but seems it's not what i meant (IMG:[invalid] style_emoticons/default/heh.gif)

This post has been edited by Scremaz: Feb 15 2017, 15:21

thank you for your answers. what i mean is that i have a first spreadsheet named Datas with cells A1, A2, ... and want the following spreadsheets to pick their names from said cells. something like this:

CODE

_____________________________________________________
  |        /|            /|            /|      /
  | Datas / | =Datas!A1 / | =Datas!A2 / | ... /
  |______/  |__________/  |__________/  |____/

my knowledge of VBA is almost zero, but i guess that would mean that if in one pc there are certain restrictions on VBA or the script machine doesn't work properly, then the following spreadsheets are quite fucked, right? consider that (=Datas!A1) and following contains further calculations, that may be further linked in other spreadsheets.
i guess the solution is indeed in said links, but is VBA the only way to do it?

As long as you don't break the database into front end/back end, I've never had a concern from one system to the next.

Well... change drive letters and directories that it's looking in.

I seriously took one production setup to 3 other facilities in 3 different states.
The first setup took all day and into the next... cause I'm an idiot.
The other two took a couple of hours each... cause I kind of knew why I was an idiot.
And these were elaborate systems tied into a central PLC controlling several other PLCs, IP addresses galore, etc.

If the syntax with VBA throws you a little, just spend some time playing with macros that "kind of" does what you want to do in VBA.
Then look at the VBA code it generates behind them. That will always put you in the right direction.

- Imperil + Holy approximately doubles the damage, though the addition ~70EDB might factor in too here in contrast to the 3x-4x i got with Fire.

Well, specific mitigation is quite similar.
Imperil: 0.66^1.5*50 + 25 = ~52
No Imperil: 50
Basically the big benefit is 50% mitigation reduction (double damage), 70EDB and slightly slower mitigation justify the fact that is slightly above 2x.
Sounds correct.

-- Q: aside from the lazy/awesomeness-factor, might it be advantageous to still cast imperil? Trying to imperil 9 mobs is 3 casts at 0.6 turns/imperil, so 1.8 turns for all 3. Does the additional time spent offset the ~1.5 damage casts you could get in in that time?

Usually imperil play has lower number of turns (normally imperiled mobs will die with T3+T2) and a lot lower damage received (imperil RE usually can be done without cure).
If it wasn't much slower to use (since you need to recast on the monster that resisted) it would pretty much always be the way to go.

- T3 : T2 : T1 ratio for holy (and i guess dark) seems to be approximately 1: 1.5 : 2, so not only are holy spells more expensive MP wise, also more expensive spells are cast more often comparatively

That's because you are still missing the last level of Archmage, which changes T3 cooldown to 4 turns for elemental. (btw, wiki is wrong)

didn't calculate that one so just a guess from what i know of the 3+2 setup

I have 1.00something for 3+2 and 0.66something for 4+1.

This post has been edited by Sapo84: Feb 15 2017, 15:46

I have some setups at work I'll try to sterilize and send an example.

You may find yourself automating everything all the data collection scripts do on this site with one setup. (IMG:[invalid] style_emoticons/default/smile.gif)

For now, make a macro that does a single execution of one cell on what you want to do.

Ctrl C the VBA behind it.

Start a VBA page, tie it to a menu page and have excel open to that menu page.
Make it run.

Paste the single execution, and setup an "execute this" icon on the menu page.

Now copy and paste that code for the second cell, tie it to the "execute this" icon along with the first, and make it run.

Lather/rinse/repeat

Do NOT get online and figure out how to do get VBA perfect, cause it'll end up 6 months later.
Just let imperfect code evolve on it's own.
After a while, you'll be on version 14, and it'll be clean.

You'll also have 25 other "execute this" on that menu page to do other things by then.

Tie Access into that excel sheet right away, and keep all data in this... crazy thought here... in this "database".

Input data to the database via excel, (Menu page) and populate data to excel via that database. (Menu page)

What weapon is suitable to increase parry for 1H? My block is only 44% and I lack the fund to increase it.

Rapier of the Nimble is a viable choice at your level. However, make sure that it's actually physical damage that's causing you problems. Parry won't work against magic attacks, which tend to be a far more serious issue for 1H Heavy players. Also, you might wait at least until level 250 before buying a new weapon, as that is when you'll gain access to the "Better Block" ability which certainly helps with survivability.

Any way to make the schoolgirls die faster when I'm going through the arenas?

I was told imperil might help, but I have to raise profiiency to 130 for that, right? And I'm at 0.

So:
1. Is imperil what I want
2. If yes, how do I grind deprecative magic fast

This post has been edited by Striborg: Feb 15 2017, 17:48

Rotate the cheapest dep spells you have. Or go super high interference and get more prof procs. sleep is helpful for this, because you can kill all other mobs and do everything on just one mob if you have lots of mana pots.

Edit, Imperil is way lower than 130, you're looking at max (?) prof i think.

It's MagNet that needs 100 prof

This post has been edited by tganimation6: Feb 15 2017, 17:49

Any way to make the schoolgirls die faster when I'm going through the arenas?

I was told imperil might help, but I have to raise profiiency to 130 for that, right? And I'm at 0.

So:
1. Is imperil what I want
2. If yes, how do I grind deprecative magic fast

Are you currently using a rapier? If not, get one. If yes, Imperil might not even help you all that much, as 3 stacks of PA already reduce SGs physical mitigation by 75%. You could however infuse your weapon to gain an additional elemental strike. SGs are weak to Holy and Dark, so you can gain some clearspeed that way.

If you wanna try Imperil, you'll only need 30 Deprecating prof to unlock it.

Yeah, according to the wiki if I read it right you only need 30 deprecating prof to unlock Imperil https://ehwiki.org/wiki/Spells#Deprecating_Spells, it's your character's Level that has to be 130+, as you're level 288 that should be fine.

Imperil helps out (I can only speak for mages (IMG:[invalid] style_emoticons/default/sad.gif) ), and you can grind it by going into the weakest battle (normal difficulty, Crude equipment Item World) and spamming Weaken. (Get CracklingCast or Reloader, set "Weaken" to Hover, and make sure Channelling isn't set to pause the script, then you can read a book for a few hours, occasionally top up your Mana with a Mana Potion and keep your Mana Draught active throughout). Make sure you don't have a Spike Shield on, I think that might accidentally kill the monster over a long time.

This post has been edited by ctaglack: Feb 15 2017, 17:58

So far I'm trying to just spam the last mob remaining with weaken until it kills itself on my spike shield
Then rinse and repeat until the arena is done

It might actually be fast enough, just checked that it's actually 30 prof

This is my weapon btw

http://hentaiverse.org/pages/showequip.php...;key=f62b866faa

My fighting technique is "Hover over things until everything is dead", but the schoolgirls take like 30 seconds to die and it's a pain in the ass

This post has been edited by Striborg: Feb 15 2017, 18:01