Jump to content
Sign in to follow this  
jukky

Adena and efficiency calculator

Recommended Posts

jukky    1

Day to day i work as an Estimator for huge company - decided to apply estimation excel skills on L2. 

https://docs.google.com/spreadsheets/d/1wUdqn5oatYPVudRdk3t95H1QQubN5b4ERU-ZeEqofJg/edit#gid=1144732307

jqUD9Cj.png



1. Fill out Data, mainly i made it for myself as archer, but you should be able to make it work any class

2. Efficent, do not touch it, unless you really understand what it is, I've included an efficent factor, which means how effectivly you think you are farming, right now 0.8 out of 1,  which is 80% - 20% is chasing and running after monsters.

After you are done, enter to NPC name and enjoy


PS: As i said, I created this sheet for  myself and updating data when i get available time.

 

5gfNZdP.png

 

Edited by jukky
  • Thanks 1

Share this post


Link to post
Share on other sites
jukky    1

You can say Thanks ingame Giran Server "Rahuel :) - but you are welcome, im currently updating the database with missing mobs

Share this post


Link to post
Share on other sites
jukky    1

Included average amount of monster user farms, Level cap for lowest monsters - Im off for tonight, will continue with populating the tables tomorrow :)

Please let me know your comments, how accurate or helpful this info is.

Share this post


Link to post
Share on other sites
Pachu    1

 

Hi, interesting but...

There is a lot of data blocked, I can not know if the procedure is well done.

Regards

 

Share this post


Link to post
Share on other sites
Pachu    1
1 minute ago, Pachu said:

 

Hi, interesting but...

There is a lot of data blocked, I can not know if the procedure is well done.

Regards

 

sorry, i was wrong

Share this post


Link to post
Share on other sites
Pachu    1

Is this a good predictor of number attacks?
I do not see the Points of defence of NPCs, in game there are NPCs with strong P.def.

Anyway well done, good work

Share this post


Link to post
Share on other sites
jukky    1
17 minutes ago, Pachu said:

Is this a good predictor of number attacks?
I do not see the Points of defence of NPCs, in game there are NPCs with strong P.def.

Anyway well done, good work



as mentioned before i created this purely for my archer character, i've farmed bit over 20kk based on this table, there are no defense points and atk is formulated very simplistic - Main idea behind this table is to recognize for archer, when you are loosing adena on farm

To be honest, ive spent maybe 5-6 hours to create that sheet with updating database, anyone can dowload excel and remake it for them selves :)

Edited by jukky

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×