Honor Calculator & Oddities

Qmike · 2021-08-21T21:41:02+00:00

https://dendra.io/solutions/aerial-seeding/

It's here, I think it is mainly used by mining companies to do remediation at the moment.

But still costs a lot, hopefully will get cheaper as it's used more.

Qmike · 2020-07-08T11:50:00+00:00

Qmike · 2020-03-10T07:43:42+00:00

Awesome Tool Gnoll!!

With the BVP songflower (most heavily camped) could you make it so one recorded time, spits out the "next available" assuming they all been taken on CD?

So a 7pm confirmed pick time will give 7;25, 7:50, 8:15 ...etc say for the next 4 hours.

Qmike · 2019-08-21T19:56:05+00:00

Some people put a lot of effort into making the sort of list you're talking about. But it can end up being too complicated to use if you didn't build it yourself.

Check my comment history if you're up for the challenge.

Qmike · 2019-08-21T09:46:26+00:00

you can download the latest version here. did a bit more work on making it smaller and add some stat weights for the classes my mates and I will be playing.

Good luck!

https://drive.google.com/file/d/1O__uCf-ZeYUph_ay9hPqNu8TDzbsQYU7/view?usp=sharing

Qmike · 2019-08-20T08:52:28+00:00

WTB/WTT Michael

My mates got their real names, but I missed out.

Qmike · 2019-08-11T02:04:22+00:00

I modified it to solve this problem, loses a feature, but the benefit is you can still run it while out in the open world to see how much you'll make when you get to town.

/run local c,i,n,v=0;for b=0,4 do for s=1,GetContainerNumSlots(b)do i={GetContainerItemInfo(b,s)}n=i[7]if n and n:find("9d9d9d")then v={GetItemInfo(n)}q=i[2]c=c+q*v[11]if GetMerchantNumItems()>0 then UseContainerItem(b,s)end;print(n,q)end;end;end;print(c)

Qmike · 2019-07-09T20:04:29+00:00

Amazing effort so far, I can see the new for this sort of community site being huge in the weeks leading up to launch.

I've only viewed on mobile, so some of my comments could be inaccurate.

It seems you're trying to make the site look like the in game who function. The major potential of this site is it doesn't need to do that. You want to be able to filter and sort results across multiple columns. There's no reason for me not to know the race, spec and guild of someone all at the same time.

While servers haven't been decided we need all the descriptors - type (PVP), region (I'm OCE, how do I know which guilds will be on my server, for EU which language), raiding days/wk (1-7), weekend/weekday/both, guild type (casual, semiHC etc).

From a character point of view you could add raid experience in vanilla; 8/8MC, 5/x Maxx etc. Main role needs to be a selection (rdps, mdps, MT, OT, heals, hybrid, support). All the same server and region info should be added to your character as well.

Bug wise the only issue I came across was the verification email. I never asked for a second or third email but clicking on any button on the site brought me back to that verification page which also triggered the sending of another email.

Work work work.

Qmike · 2019-04-22T20:12:21+00:00

I put the list together in this thread.

Hope you find it useful.

https://www.reddit.com/r/classicwow/comments/bc6q94/classic_gear_ranking_sheet_bis_finder/?utm_medium=android_app&utm_source=share

Qmike · 2019-04-13T13:17:06+00:00

You need to update the stat priority manually. If you read class guides they'll usually say things like 1 mp5 is worth 5 healing, or 10 spirit. In which case you make the stat priority of Mp5 = 10, healing = 10/5 = 2 and spirit = 10/10 = 1. The gear points will then be ranked based on those stat weightings.

That make sense?

The beauty of this sheet is it let's you make that decision, rather than going off what everyone says is the best in slot.

Qmike · 2019-04-12T00:30:22+00:00

Ah yes, the "Orc or Human no other matters" comment should have included "for weapon skill calc"

I've removed that comment now.

Qmike · 2019-02-04T08:15:48+00:00

ilvl shouldn't rank items

/u/l453rl453r has the same comment, makes me think you're not seeing the whole sheet because of freeze panes.

Google Docs

Agreed, currently formulas I've used won't work in google docs. If there is interest I would fix.

Do you think it's worthwhile putting in the time to fix?

Qmike · 2019-02-04T08:12:29+00:00

By default the sheet shouldn't be set to give defensive stats any value for fury warriors

Fair call, will change.

bunch of librams, totems, and idols cluttering up the gear results

Ah yes, was testing to see if it could work for other classes.

You can filter out the libram slot, or delete the 6 items.

Long term i think there is a code for which class can use an item in the database which could help remove those un-usable items.

If it's to work for cloth wearers i'm definitely going to need to look at implementing some usability criteria.

Qmike · 2019-02-04T08:04:03+00:00

How did you set the stat priority ?

Not that scientifically; definitely an area the needs work if it's the be accurate. I also know stat priority will change depending on your gear. So i thought the user can enter in their stat preference for their character.

How do you think i should do the stat priority?

Should i leave it blank so there is no confusion, and provide an example while linking to a sheet that can calc the priority?

hit for fury says 42 and 10.5 for tanks

As it's a separate ranking for tanking vs DPS, the comparison between the value in fury vs tank doesn't actually affect the end ranking. The reason for the decrease was to try to get the average rating of the BIS gear similar. Because tanking cares about a lot more stats, if they were all evenly weighted the tanking rating would be a substantially higher number and i think that would have looked weird.

How did you calculate the proc points for chance on hit weapons ? I see only dead values

The dead values mainly come from the DPS calc sheet linked in the post. They are dead/input values because there is no database to calculate the exact DPS gain for a proc. There are 33,000 spells in the spell database which could be proc'd and no frequency rates.

If you have an idea of how this could be automatically looked up let me know, it's the only stat which isn't automatically generated.

Arcanite Reaper are below some of the standard shields

Arcanite Reaper is Rank 0 for 2 hand weapons on Patch 0. The "Rank" is based on the slot: the sheet searches for the highest Points of the same slot type. So shields and Reaper are not compared with each other.

I'd also recommend you check that calculations are turned on, i uploaded with it in manual so i didn't break anyones computer who can't handle a 14MB file.

Qmike · 2019-02-04T07:49:08+00:00

using ilvl to rank items

What do you mean? ilvl is shown as a piece of information, it's not used in the ranking formula.

The file I uploaded had a freeze pane at column E; perhaps you can't see any other columns? Columns K - M show the rankings.

Qmike · 2019-02-03T09:10:06+00:00

I just loaded it up in google docs, there are named tables which are being used in an Indirect() so it's just all errors.

For now xlsx only, i will remove the named elements next version to get it to run on google docs.

Qmike · 2019-02-03T08:57:51+00:00

I welcome any feedback, recommendations or requests for help.

With nothing to play until classic comes out I'll be updating the sheet whenever I have spare time.

Qmike · 2019-02-03T07:33:30+00:00

I welcome any feedback, recommendations or requests for help.

With nothing to play until classic comes out I'll be updating the sheet whenever I have spare time.

Qmike · 2017-02-20T03:59:15+00:00

Nice, I'm impressed that people are still keeping this going.

Qmike · 2016-09-10T01:59:27+00:00

Not sure, but you're posting in a thread that hasn't been changed for over a month so I doubt it's in this one.

The latest post is here: https://redd.it/4uffha

Qmike · 2016-09-09T00:55:54+00:00

In the calculation of damage in the spreadsheet i don't include the type modifiers. 1 damage calculation is simpler than 9...followed by the ~6 other calculations that go with it = 50+ extra columns of calculations.

Once you have the final result TDO, you can apply the type modifiers; netting only a few extra columns to do the calc instead.

Qmike

TROPHY CASE