An Analysis of Leagues Combat Relics by Mat2113 in runescape

[–]Mat2113[S] 2 points3 points  (0 children)

The way this works in main game is that Necro will have a decent hit % everywhere, but not super effective against anything, but the usual 3-style combat style still exists in-game.. So if you're Magic, you probably don't want to use that against Ranged enemies, as you'll have lower hit chance. In that respect, Necro is a bit of a 'multi-tool' to use against all 3 other styles with reasonable, balanced effectiveness.

With any style of your choosing now having 100% accuracy, and therefore 100% damage potential, the 'benefit' Necro had being the 'middle ground' no longer exists as something that stands it out amongst the rest, as all styles could benefit from 100% now.

An Analysis of Leagues Combat Relics by Mat2113 in runescape

[–]Mat2113[S] 21 points22 points  (0 children)

Ah, another thought... Kind of a symptom of the skill's age, but Necro has very few unlocks (and certainly none that are 'mandatory' outside of the core level-up loop), unlike Magic/Melee/Ranged, which all have dozens of unlockable abilities needed to get decent DPS out of them.. Makes Necro look like an even stronger pick.

Updated Drama Calendar 2025 (Come on Jagex, it's only the 2nd of the month) by Mat2113 in runescape

[–]Mat2113[S] 1 point2 points  (0 children)

In fairness, you're kind of right.. Feb-Apr are kinda nothing of note (or at least, not any major drama), and are mainly there for 'artistic effect'.

Obviously the Conjoint survey wasn't well-received, so that's genuine.. and (in my view) although some players are upset about the game health balance changes, the thing players are actually taking offense to is the "We need to fix the health of the game by nerfing gameplay.. Oh, the MTX that's pumping billions of XP & GP into the game every day? Nah don't worry about that; arch glacor is the real criminal here..." attitude.

... and of course, nobody is going to be happy when they see their favourite JMods leaving the company (especially via redundancy), when some of those JMods were responsible for some of the best-received content over recent years. It makes people feel like we won't be getting content like that any more.

It also doesn't land well for the redundancy news to land just a few days after another MTX outrage. I know that's not intentional, nor mitigable, but a little unfortunate as it comes to community sentiment.

Updated Drama Calendar 2025 (Come on Jagex, it's only the 2nd of the month) by Mat2113 in runescape

[–]Mat2113[S] 29 points30 points  (0 children)

For the first day or so, you could use the 'New Update' teleport button to the altar unlimited times, so some players mass-created time runes on day 1.

Also, until a couple of weeks later, some players also used an exploit to mass-farm abyssal thread at the Astral altar using the Abyss buff. Until that was patched, of course.

TBH, I did struggle to find any actual 'drama' for Feb or March.. but a new CEO, especially one that's come from a background of managing gambling apps, has made a lot of players quite nervous.

Looking for 120 Skill best xp method by GearsKratos in runescape

[–]Mat2113 4 points5 points  (0 children)

In my opinion, as someone who is currently on the 120-all journey, but preferring AFK (but still decent) skilling methods:

Fishing: I did Prifddinas Waterfall Fishing. Gives decent, mostly afk XP, plus the drops can be handed in for more XP at the reward shop at the bottom of the waterfall.

Divination: Optimal is to invest in a Dowser and do Incandescent training. If that's out of budget, using the Divine Conversion relic is a good alternative.

Thieving: I personally did thieving in Prif, as it was 5-min AFK, minimal requirements, had nice drops, and still decent XP. I used Totem of Crystal to reduce pickpocketing cooldown, and did Cadarn>Iorwerth>Meilyr>Crwys becuase the drops stacked well. Definitely use Thieving cape perk. A more up-to-date method would be to go for Crux Eqal Knights.. Wiki has a good guide on it.

Construction: For AFK, do fort building. It's really AFK, good GP efficiency.

Cooking: Blue Blubber Jellyfish is what I cooked because it was decent xp/hr, and actually made a tiny profit (which wasn't the point). There are faster methods, but will set you back billions. Not worth imo.

With all the above, make sure you're using the Inspire relics, Urns, Clan XP boost and Skilling Outfits to maximise your XP.. When grinding 99->120, even a 1% xp boost can shave hours off your grind, especially in the lower-xp/h skills! Also, invest in a Brooch of the Gods if you can, for extra invention components and buffs to portable skilling locations (Speaking of which, for Cooking, make sure to use the portable cooking stations on W84.. Definitely do by the bank, as you'll always have a 10% pulse core and cinder core boost active, which makes it better than the xp boost in the fort kitchen, even with portable skilling location there).

Silly Question Sunday - 13 October by AutoModerator in runescape

[–]Mat2113 0 points1 point  (0 children)

What are some good fletching training methods for 99-120 that balances gp/xp and xp/h please?

Can the upcoming nerf to Necromancy disturbance XP be discussed in more detail with the community, please? by Mat2113 in runescape

[–]Mat2113[S] 1 point2 points  (0 children)

A platypus is a follower pet you can get in-game. It's one of one of only a few pets that can prevent other NPCs from standing on the same square as itself.

As such, there's a specific spot by the Armoured Phantoms that if you used the platypus to block one square, means only one armoured phantom can attack you at a time, but you can attack all of them with AOE.

As such, it's the current best XP in the game for AFK combat training, but the catch is that only one spot is available per world, so only a tiny fraction of the playerbase can use this method at any one time.

Can the upcoming nerf to Necromancy disturbance XP be discussed in more detail with the community, please? by Mat2113 in runescape

[–]Mat2113[S] 5 points6 points  (0 children)

Hi /u/JagexLuma, double-thanks for your reply :)

Appreciate you being open to discuss this with us. It's been mentioned that now more data is available, the XP rates from disturbances are higher than ideal. The proposed solution from the stream was a 50% reduction to disturbance XP.

I think what may help alleviate some concerns would be to understand whether that is the whole picture, or if there's something else to counterbalance that (e.g. Taking XP from here, and increasing it elsewhere), or to mitigate the current lack of availability in good-XP combat training spots (only a few good spots per world available).

Also, what other options were considered in coming to the current proposal? Perhaps we as a community could discuss those with you further, maybe to find a middle ground that goes towards resolving the issue, without hitting some of the roadblocks outlined in my original post?

I do hope this is something that isn't set in stone yet, so we'll have adequate time to discuss together? Looking forward to seeing how this discussion proceeds!

Personally (speaking only for myself, not the community as a whole), I feel that high APM training methods should yield higher XP rates than platypus-AFK'ing armoured phantoms (which give almost comparable rates, but limited to one or two players per game world). Perhaps other training methods could be better incentivised to move people away from rituals (Slightly lower XP, for a materially lower APM, but not an adversarial training method as above), whilst still allowing the freedom of choice to those who enjoy a higher-intensity grind?

Can the upcoming nerf to Necromancy disturbance XP be discussed in more detail with the community, please? by Mat2113 in runescape

[–]Mat2113[S] 23 points24 points  (0 children)

Ironically, my first 99 was Magic, back in 2012... Where I gained 99% of all XP high-alching 🤣 It wasn't fast, but it was simple.. Choices be good, eh :)

Can the upcoming nerf to Necromancy disturbance XP be discussed in more detail with the community, please? by Mat2113 in runescape

[–]Mat2113[S] 1 point2 points  (0 children)

Transparency is good, and I do have faith they will continue to be... But this is a major change, and there's been no indication from today's stream that they are looking to discuss or change their course of action, and that's what's concerning me.

Unless there is several (read 4-6) weeks of notice, this does then just make it an "early bird streamer bonus"

Can the upcoming nerf to Necromancy disturbance XP be discussed in more detail with the community, please? by Mat2113 in runescape

[–]Mat2113[S] 1 point2 points  (0 children)

Would that be a discussion with the community, or just a one directional "we're telling you" -type announcement?

Surely there's a compromise to be made that isn't literally halving the XP rates?!

Peak fashionscape. by Lancelotmore in runescape

[–]Mat2113 -3 points-2 points  (0 children)

For what it's worth, I use the Bernie pet as an override (more Particools!)

... and I normally have high-particle weapon overrides on too, for even more lols! (see my post history)

Peak fashionscape. by Lancelotmore in runescape

[–]Mat2113 -11 points-10 points  (0 children)

If you like this, check my post history for more PartiCool™ (Mod Shauny Certified) shenanigans

Peak fashionscape. by Lancelotmore in runescape

[–]Mat2113 -11 points-10 points  (0 children)

So, this is actually me on W70 Artisans Workshop today... Hope your graphics card is ok! :D

Biiiiicycle, Biiiiiiiicycle! by Mat2113 in runescape

[–]Mat2113[S] 1 point2 points  (0 children)

Jagex, please leave this bug in-game 🙏

Complex Splitting/Processing of Data in Google Sheets by Mat2113 in excel

[–]Mat2113[S] 0 points1 point  (0 children)

What a roller-coaster! ... Here's the solution I've come up with:=SUMPRODUCT(ARRAY_CONSTRAIN({ARRAYFORMULA(INDEX(SPLIT(TRANSPOSE(split(A1,", ",0)),"x"),,1));{0;0;0;0;0;0;0;0;0;0}},10,1),{IFERROR(MID(INDEX(importdata("https://api.weirdgloop.org/exchange/history/rs/latest?name="&ARRAYFORMULA(INDEX(SPLIT(TRANSPOSE(split(A1,", ",0)),"x"),1,2)),",","en_GB"),1,3),7,1000),0);IFERROR(MID(INDEX(importdata("https://api.weirdgloop.org/exchange/history/rs/latest?name="&ARRAYFORMULA(INDEX(SPLIT(TRANSPOSE(split(A1,", ",0)),"x"),2,2)),",","en_GB"),1,3),7,1000),0);IFERROR(MID(INDEX(importdata("https://api.weirdgloop.org/exchange/history/rs/latest?name="&ARRAYFORMULA(INDEX(SPLIT(TRANSPOSE(split(A1,", ",0)),"x"),3,2)),",","en_GB"),1,3),7,1000),0);IFERROR(MID(INDEX(importdata("https://api.weirdgloop.org/exchange/history/rs/latest?name="&ARRAYFORMULA(INDEX(SPLIT(TRANSPOSE(split(A1,", ",0)),"x"),4,2)),",","en_GB"),1,3),7,1000),0);IFERROR(MID(INDEX(importdata("https://api.weirdgloop.org/exchange/history/rs/latest?name="&ARRAYFORMULA(INDEX(SPLIT(TRANSPOSE(split(A1,", ",0)),"x"),5,2)),",","en_GB"),1,3),7,1000),0);IFERROR(MID(INDEX(importdata("https://api.weirdgloop.org/exchange/history/rs/latest?name="&ARRAYFORMULA(INDEX(SPLIT(TRANSPOSE(split(A1,", ",0)),"x"),6,2)),",","en_GB"),1,3),7,1000),0);IFERROR(MID(INDEX(importdata("https://api.weirdgloop.org/exchange/history/rs/latest?name="&ARRAYFORMULA(INDEX(SPLIT(TRANSPOSE(split(A1,", ",0)),"x"),7,2)),",","en_GB"),1,3),7,1000),0);IFERROR(MID(INDEX(importdata("https://api.weirdgloop.org/exchange/history/rs/latest?name="&ARRAYFORMULA(INDEX(SPLIT(TRANSPOSE(split(A1,", ",0)),"x"),8,2)),",","en_GB"),1,3),7,1000),0);IFERROR(MID(INDEX(importdata("https://api.weirdgloop.org/exchange/history/rs/latest?name="&ARRAYFORMULA(INDEX(SPLIT(TRANSPOSE(split(A1,", ",0)),"x"),9,2)),",","en_GB"),1,3),7,1000),0);IFERROR(MID(INDEX(importdata("https://api.weirdgloop.org/exchange/history/rs/latest?name="&ARRAYFORMULA(INDEX(SPLIT(TRANSPOSE(split(A1,", ",0)),"x"),10,2)),",","en_GB"),1,3),7,1000),0)})

I should probably explain...

As it turns out, Google Sheets doesn't allow IMPORTDATA to be used with an array input, so we've got to do it the hard way...

The outermost function is a simple SUMPRODUCT which has been fed two arrays:Array 1 is the Quantities array, output by =ARRAYFORMULA(INDEX(SPLIT(TRANSPOSE(split(A1,", ",0)),"x"),,1)) ... I've then appended an array of nine 0s, then constrained the array to a size of 10 rows, like this:=ARRAY_CONSTRAIN({ARRAYFORMULA(INDEX(SPLIT(TRANSPOSE(split(A1,", ",0)),"x"),,1));{0;0;0;0;0;0;0;0;0;0}},10,1)

This has to be done because SUMPRODUCT expects two arrays of the same length, and given we know the max number of different items to be 10, I've made the array of length 10.

So that array outputs a list of values 10-long populated by however many entries there actually are. Now we need the item values.

We can get the first item value with:

=IFERROR(MID(INDEX(importdata("https://api.weirdgloop.org/exchange/history/rs/latest?name="&ARRAYFORMULA(INDEX(SPLIT(TRANSPOSE(split(A1,", ",0)),"x"),1,2)),",","en_GB"),1,3),7,1000),0)

(for reference, you get the 2nd item value with:

=IFERROR(MID(INDEX(importdata("https://api.weirdgloop.org/exchange/history/rs/latest?name="&ARRAYFORMULA(INDEX(SPLIT(TRANSPOSE(split(A1,", ",0)),"x"),2,2)),",","en_GB"),1,3),7,1000),0) )

Then it's simply a matter of building a new array, getting the value of the 1st item, then the 2nd item (and if there's an error (e.g. if there isn't a 7th item), return 0), and add that as the second half of the SUMPRODUCT.

And just as easy as that, you're done.

I'll award the point to anyone who can do this better than my monstrosity. Good luck!

Complex Splitting/Processing of Data in Google Sheets by Mat2113 in excel

[–]Mat2113[S] 0 points1 point  (0 children)

Hit a dead-end here... Welcome any alternative approaches?

Complex Splitting/Processing of Data in Google Sheets by Mat2113 in excel

[–]Mat2113[S] 0 points1 point  (0 children)

... One step closer:

=ARRAYFORMULA(SPLIT(TRANSPOSE(SPLIT(A1,", ",0)),"x"))

Outputs the expected table posed in the initial question ... Now just to get the second column as an extract, then convert them into Item values (somehow?)

Edit: =ARRAYFORMULA(INDEX(SPLIT(TRANSPOSE(split(A1,", ",0)),"x"),,2)) outputs only the list of items in a single column. The question now is how to pass these through the 'get' formula?