Lvl 10 Dungeon Ranarr Spawn and Jagex’s Great Conspiracy
Jul 20th
Everybody thinks Ranarrs are going to continue crashing because of the new cave which spawns them that you only need 10 Dungeoneering to enter. I beg to differ.
In this cave, Ranarrs spawn once every 100 seconds. This means 36 can be gathered on each world per hour hour. If people can get 8k each for them then (36*8k) that’s 288k per hour. They can also pick up Irit herbs which would add about 100k and make it 388k per hour. But that’s only if there is no competition. If there is, that profit could easily be halved or worse.
Only the noobiest noob would sit around for an hour picking up spawns for (a questionable) 388k gp and no exp. Especially when there are so many other more profitable, less tedious and exp-gaining ways to make money. If the prices did drop alot they wouldn’t stay down for long because then it would be even less worth it to pick up spawns i.e. it might only be 250k per hour then.
The reason Ranarr herbs are dropping now is artificial. Everybody is dumping because people don’t understand that it’s so not worth it to gather ranarrs and irits and that nobody is going to bother. As soon as people realize the truth they’re gonna stop dumping and start buying at max (because the price will have dropped and you’ll be able to get for really cheap.) and the price will go back to normal.
EDIT: I just found out that there are Chaos Druids in the lvl 10 cave,
too. This may provide people a greater incentive to camp there because they can kill druids for their herb drops and pick up the ranarrs at the same time. This means ranarrs might be going down afterall – though not for sure.
If, as they always do when there’s a PvP update or more people playing for whatever reason, the prices of Ranarrs go up a bunch, it will make gathering this way somewhat profitable so people will start gathering again and the prices of Ranarrs will go back to their average price. So what this cave really does is keeps the price Ranarr Herbs and prayer pots from getting too high.
It’s not only the price of ranarrs and prayer pots that Jagex wants to keep low, though, they also want to decrease the price of leveling smithing and prayer. This is, of course, what I call “Jagex’s Great conspiracy”.
Prayer: Frost Dragons drop bones that give 2.5x as much exp as dragon bones but aren’t that much harder to kill than normal dragons. Everybody’s going to be killing them to get 20k for the bones and so there will be a lot of supply and price will go down along with prices of other bones and the price of leveling prayer.
Smithing: There are 3 runite ores in one of the caves. This will make it much easier to obtain ores and thus increase their supply, effectively lowering the price it costs to smith rune stuff. Also, in one of the Dungeoneering caves there are steel + iron dragons and and anvil all together. This means people can kill the metal dragons and then make iron/steel platebodies to get free smithing exp. Plus (one of the most shocking things) one of the resource dungeons holds 6 mithril 3 silver and 13 coal rocks that are right next to a bank and, what’s more, F2P players can access them! This will definitely make the prices of coal and mithril fall, along with the prices of all bars.
More about the whole conspiracy thing: I think it is a conspiracy because this isn’t the first time they’ve done stuff to cheapen or “noob down” skills. Take double exp weekend when people could get 99 summoning for half the money and time or effigies which make lvling slayer a lot faster because they’re dropped all the time and give a ton of exp. I’m sure there are more out there that I’m not aware of. I think they’re doing this to cater to the desires of all the 12 year olds (who make up the majority of their members) out there who all want an easier game.
How to Make Spreadsheets For Runescape Using Google Docs.
Jun 9th
Contents
- 1.0 [ Introduction ]
- 2.0 [ Getting Started ]
- 3.0 [ Using ImportHTML to import GE Prices ]
- 4.0 [ Extracting One Item at a Time ]
- 5.0 [ Using the GE Prices to Make a Spreadsheet ]
- 6.0 [ Concatenate - Another Useful Function ]
- 7.0 [ Dealing with Ks and Ms ]
- 8.0 [ Final Words and Credits ]
1.0 [ Introduction ]
Many of my charming readers have been asking me how I made the spreadsheets that I’ve embedded onto some of my posts. These spreadsheets automatically extract the prices of items from the Grand Exchange Database and then do certain calculations with those prices. The Process is really not too difficult but it can be somewhat frustrating at first if you’re not familiar with how spreadsheet programs work. Hopefully this guide will make it as easy for you as possible.
If you’re not exactly sure what I mean by these spreadsheets, check out the ones I have on the following posts:
1) Beginner’s Guide to GE Merchanting.
2) How to Make Money by Swapping Pouches for Shards.
3) How to Make Money by Making Pouches into Scrolls
You might also want to check out Grimy Bunyip’s Spreadsheets. Grimy is a pro at making Runescape spreadsheets on Google docs. I often use his spreadsheets when looking for the best way to train a particular skill. For instance, by looking at his spreadsheets I found that making air battlestaffs is a great way to train Crafting and cleaning grimy herbs is a great (and profitable) way to train Herblore.
How to Turn this into something beautiful.
======================
2.0 [ Getting Started ]
Start off by doing the following:
2A) Head to Google Docs and sign in. If you don’t have a Gmail account, you will see a button somewhere on the bottom of the screen that will lead you to a page where you can create an account. Once logged in, on the top left part of the page press ‘CREATE NEW’ and then ‘SPREADSHEET’ (see screenshot below).
Make an account and then create a new spreadsheet.
======================
3.0 [ Using ImportHTML to Import GE prices]
After you’ve gotten that all straightened out, it’s time to learn how to use Google Doc’s function ImportHTML which, unavailable in Microsoft Excel and OpenOffice Calc, is the key to extracting prices from the Grand Exchange Database:
3A) The basic ImportHTML code we’ll be using for this guide goes like this:
=ImportHTML("LINK HERE", "table", 2)
The “table”, 2 part is necessary because otherwise it would extract everything on the page rather than only the items and their prices. Go to the Grand Exchange Database and search for an item. Copy the link and insert it into the code where it says “LINK HERE”. Put the entire code, then, into one of the cells on your Google Doc spreadsheet (like A1 or A2). Repeat this until you have imported all the items you need for your spreadsheet.
>> Let’s trying searching “Dragonhide” in order to make a spreadsheet for my Tanning Dragonhides Guide. Notice that other items come up besides dragonhides in the search. That’s okay (we’ll learn how to deal with that more later on) but, for now, just to narrow down the items a bit, I’ll put the price range between 1-5K. The final link, which I will insert into A2, is http://services.runescape.com/m=itemdb_rs/results.ws?query=dragonhide& price=1000-5000 and, when added to the code, becomes
=ImportHTML("http://services.runescape.com/m=itemdb_rs/results.ws?query=dragonhide&price=1000-5000", "table", 2)
You now have a list of items that will be updated each time the GE updates.
======================
4.0 [ Extracting One Item at a Time ]
By importing items the way mentioned above, you’ll almost always end up with some extra unwanted items (like Black D’hide Vambraces or Black Spiky Vambraces above). It’s easy to get away with this problem by simply right-clicking the unwanted-item column and pressing ‘hide’ or simply not publishing that sheet but you can also just import items 1-by-1. Whether or not you do it this way is up to you (I personally don’t usually bother) but here’s how to import items 1-by-1, anyway:
4A) Add Index( before the code and , ITEM COLUMN NUMBER HERE) after the code. It looks like this in the end:
=Index(ImportHTML("LINK HERE", "table", 2), ITEM COLUMN NUMBER HERE)
Fill in the LINK HERE and the ITEM COLUMN NUMBER (explained below) and copy and paste into a cell. Repeat this for each item until you have all the items you need.
Importing Items one-by-one
4B) To figure out the column number for, say, Red Dragonhides just count down from the first column until you reach Red Dragonhides. If, like before, you search ‘Dragonhide’ and narrow down the options to prices between 1-5k, Red Dragonhides will be in the fifth column (see image below) so replace ITEM COLUMN NUMBER HERE with 5. The link is, of course, figured out the same way as previously – in this case, it’s http://services.runescape.com/m=itemdb_rs/results.ws?query=dragonhide&price=1000-5000. The final code, then (see above screenshot), is:
=Index(ImportHTML("http://services.runescape.com/m=itemdb_rs/results.ws?query=dragonhide&price=1000-5000", "table", 2), 5)
Start counting at the ‘Item – Current Price – Change Today (gp)’ Column
======================
5.0 [ Using the GE Prices to make a Spreadsheet ]
Using the prices you’ve imported to make a worthwhile Runescape spreadsheet can be very easy or very difficult, depending on what you want it to do. A spreadsheet determining how much money you make per Dragonhide per hour is pretty simple and basic, so we’ll start with that and then later I’ll show you some more complex stuff.
5A) First off, import all dragonhides, tanned and untanned using the ImportHtml function (however you choose to do it: 1-by-1 or altogether) and then create a new sheet by pressing the ‘+’ on the bottom right of the same spreadsheet page.
Have your calculations on a separate page from the one where you imported the prices
5B) The new sheet should tell us four things: (1) Item name. (2) Profit per hide. (3) Profit per trip. (4) Profit per hour. Write these four things at the top of each column (i.e. type ‘Item Name’ in A1, ‘Profit Per Hide’ in B1 and so forth). Then simply write the names of the dragonhides in four different cells below the ‘Item Name’ column or, rather than writing it out, you could also just put CELL=CELL WHICH SAYS DRAGONHIDE NAME HERE. It’s really very simple: just click the cell you want, type in =, and then find and choose the cell whose contents you want it to mirror.
On the other sheet “Calculations” on A2 it will now say Green Dragonhide
However you decide to do it, just make sure it ends up looking something like this.
5C) To figure out the ‘Profit per hide’ all you have to do is subtract the price of the untanned dragon hide + the cost of tanning the dragonhide (20gp) from the price of the corresponding tanned dragonhide. The code in the cell to the right of each dragonhide name should end up looking something like this, then: =CELL THAT CONTAINS PRICE OF TANNED DRAGONHIDE-CELL THAT CONTAINS PRICE OF UNTANNED DRAGONHIDE-20.
Notice that there are some rows of cells you can’t see. This is because I hid them.
It should end up looking like this on the other sheet.
5D) To figure out the profit per trip just multiply 27 (the amount you can do per trip) by the cell that shows the profit per hide i.e. C2=27*B2. Because the formula is the same for all four hides, you can simply copy the first cell and paste it into the other three.
Don’t forget that you can just copy and paste
5E) To figure out the ‘Profit Per Hour’ simply multiply the corresponding ‘Profit Per Trip’ by the number of trips you can do in an hour – which in this case is 110 i.e. D2=110*C2.
Okay, that’s almost everything! The only thing that’s missing is a little color.
5F) It’s very easy (and worthwhile) in Google Docs to add coloring and change font type and size. Simply scroll over the cells you want to color and choose the text type, text color and background color for all of them.
Here’s how I colored mine. Ain’t it purty? How will you color yours?
5G) Now you just need to share your spreadsheet with the world. Click the ‘Share’ button in the near-top right corner and share it whatever way you want. You can even embed a spreadsheet on your website or blog like I’ve done and it’ll give your readers a good reason to come back every day. Make sure to post a link to your spreadsheet(s) in a comment on this post, too – I’d love to see it!
Be generous and you will be broccoli. Help others and they will eat you….
======================
6.0 [ Concatenate - Another Useful Function ]
6A) The basic concatenate function code is this:
=Index(ImportHtml(Concatenate("http://services.runescape.com/m=itemdb_rs/results.ws?query=",A2), "table", 2),2,3)
Looks complicated, right? All you need to know, though, is that, with this code, whatever you put in A2 will be put in place of where it now says A2 in the code. So if you type ‘Green Dragonhide’ into A2 the code will now be
=Index(ImportHtml(Concatenate("http://services.runescape.com/m=itemdb_rs/results.ws?query=",Green Dragonhide), "table", 2),2,3)
The new code will tell you what the price of Green Dragonhides are.
Yo-ho-ho it’s magic, you know! Never believe it’s not so!
6B) Fill Column B with the basic Concatenate code by first putting the code into B2 and then clicking the bottom right corner of that cell and pulling down (this is a very useful thing to know, so don’t forget!). Then all you have to do is write the names of items in Column A and you’ll quickly have the item price.
“Wait a second… Red D-leather doesn’t cost 222gp each!” Yes, I’ll get to that
6C) Occasionally you’ll run into a small problem when using Concatenate. The problem is that sometimes (pretty rarely) when you search an item name it doesn’t show up in the second column so you end up getting the price of some other item that came up in that column instead. This is the case for Red D-leather. To fix the problem, as before, replace the 2 in the code “Table”, 2),2,3) with the actual column number:
=Index(ImportHtml(Concatenate("http://services.runescape.com/m=itemdb_rs/results.ws?query=",A2), "table", 2),5,3)
By searching Red D-leather on the Grand Exchange Database we learn that it comes up in the fifth column (see 4B screenshot above which demonstrates the same procedure, in case you’ve forgotten). So we replace the 2 in the code with a 5 and that’s that.
It can be annoying sometimes but it’s not too bad.
6D) If you also want to see how much the item in the ‘A’ column changed in price today just replace the final 3 in the code “Table”, 2),2,3) with a 4 and that will do it because when you search for an item on the Grand Exchange Database it is the fourth column that shows the Change in Price.
=Index(ImportHtml(Concatenate("http://services.runescape.com/m=itemdb_rs/results.ws?query=",A2), "table", 2),2,4)
All you have to do is count. I did it for you, just in case you don’t know how.
Pretty nifty, huh?
======================
7.0 [ Dealing with Ks and Ms ]
Any item worth 10,000 gold pieces or more will show up as 10k. Any item worth 1,000,000 gold pieces or more will show up as 1m. Google Docs doesn’t recognize that k stands for three zeros and that m stands for six so the calculations won’t work properly (I know. Annoying, right?). To fix this problem copy and paste the following code into whatever cell you want the fixed price to show up in:
=SUBSTITUTE( left(FAULTY CELL,len(FAULTY CELL)-1); "+";"")*sum(Index((right(FAULTY CELL)={"k","m"})*10^{3,6}))+N(FAULTY CELL)
If the “faulty cell” is B2, replace all the FAULTY CELLs with B2.
If you can understand that code you can understand the meaning to life
======================
8.0 [ Final Words and Credits ]
I originally meant to add something about the IF and Filter functions which I’ve found useful but because of how large this guide already is and how difficult it is to explain those things to beginners, I’ll have to postpone that.
If you read this guide please give me your feedback on it. Feel free to ask me for help if you’re experiencing spreadsheet problems. If you make a spreadsheet yourself please be sure to post a link to it here so I can see it.
Much of the credit for this post goes to Brainymidget, the guy whose post on tip.it forums taught me the basics of creating Runescape spreadsheets. I was originally just going to link you to his post but I saw it was a bit outdated and missing some stuff I thought was important so I decided just to make my own.
Why and How Rares Should Be Removed From Runescape
Jun 2nd
Contents
- 1.0 [ Introduction ]
- 2.0 [ Problem 1]
- 3.0 [ Problem 2 ]
- 4.0 [ Flawed Solutions ]
- 5.0 [ The Only Real Solution ]
1.0 [ Introduction ]
I saw an interesting topic on tip.it forums about removing rares a little while back and I wrote a reply to it. The reply was on page 20, though, so, as is often the sad case, nobody really saw it or replied to it. I’m gonna post it here (in slightly edited form more appropriate for my blog) so at least you guys can read it.
I see only one solution to the problem and I’ll explain why other solutions wouldn’t work.
======================
2.0 [ Problem 1 ]
The prices of rares will continue to rise over the years, making people who were lucky enough to have gotten one in the beginning or near the beginning have a huge advantage over other players because they can trade them for a lot cash, while other players have to work hard to get that money (and to buy rares). When Jagex released rares they intended them to be only fun souvenirs – not the hoarded bundles of cash that they are today. That is why Jagex no longer makes holiday items tradeable and sees to it that no new rares are created (like they did with pickax and hatchet handles and heads).
======================
3.0 [ Problem 2]
Because rares are worth more than their market price on the Grand Exchange, large-scale Real World Trading can (and already does often) occur. People who have rares can sell them through trade at market price to other people for cash or junk and require real money as payment from the other person. If a rare is worth 300m more at street price than market price, people maybe be able to get more than $1,000 by selling it to someone at market price. Some people have tons of rares that they got when they weren’t worth much or were free that are now already worth thousands of dollars and Lord knows how much they’ll be worth in 10 or 20 years – hundreds of thousands? (especially if no other rares are introduced). That’s serious real world trading and if Jagex really wants to stop RWT they’ll have to do something before it gets more out of hand than it already has.
======================
4.0 [ Flawed Solutions ]
A few people on the forum who recognized the problem offered solutions that I think would do more harm than good. Here they are:
1. Simply remove them from the game or make it so that everybody can buy the current rares from a store for free or nearly nothing (I.E. make them not rare). If someone owned 5 blue party hats, he now owns nothing or at least nothing of value.
Problem – It would work but it would make the people who own rares become crazy angry, start riots, and quit.
2. Exchange all rares for Gold Pieces at their market value. If someone owned 5 blue party hats which today have a Market Price of just over 500 million gp each, instead of those 5 blue party hats they would now own 2.5 billion gp. This is supposed to be a way to make it up to those people who paid a lot of money to buy rares, not expecting them
to suddenly be worth nothing.
Problem - So much cash suddenly flowing into the economy would cause a vast inflation and have detrimental effects on the economy, for which Jagex would have to take great measures in order to fix. Think about it – if there are 10,000 rares with an average market price of 100M gp, that would mean 1 Trillion GP would suddenly be introduced into the game. Everybody would be using that money to buy resources to get all their skills to 99 and because there would be more demand than supply, prices would skyrocket like crazy. Plus it still wouldn’t be fair that those people who got rares when they first came out would suddenly have all that cash. Not to mention it’s basically an impossibility, anyway (if someone has 20 blue phats worth 10bil gp how can he get the 10bil gp when the max you can hold is a bit over 2bil?).
======================
5.0 [ The Only Real Solution ]
The only real solution I see (and I really would not be at all surprised if Jagex does this soon) is to make all the rares untradeable and make it so no more can be ever obtained. This way the people who got it for free will finally get the item as Jagex intended it to be and those who paid for it will get what they paid for – an item that has no real value besides sentimental. Most of the people who bought them at high prices would still be angry at this but not as much because they would at least be able to keep their rares and the sentimental value they hold. In fact, they’re sentimental value would likely increase if this was done.
======================
After reading, feel free to offer your own arguments about the subject
– I’d be glad to hear them and take them into consideration -
Commenting wasn’t working before, I’m sorry to say, but it’s fine now.
Runescape Blogs and Fansites I read/use
May 31st
Here are some Runescape Blogs and Fansites I read and use.
Fan Sites:
Runescape Wiki – my favorite fansite.
Tip.it Forums – my favorite forum.
The Grand Exchange Central – my favorite GE database.
Fellow Runescape Blogging Friends:
Lumbridge City’s Blog – Has some great posts about merchanting among others.
If you’re a runescape blogger or fansite and wish to exchange links, just post a link to my site on yours (in sidebar) and then post your link in a comment here. I’ll add it as long as I think it’s good (and some people click on the link). Plus, if you write a review of my blog I’d gladly write a review of yours.
Dungeoneering Solo Party Problem
Apr 16th
Overall, I love the new Dungeoneering skill. Yes, it’s really more of a minigame than a skill and is in that sense disappointing but I still think it’s fun. It definitely has some good rewards, too, and it’s nice how you get experience for other skills while training it.
Dungeoneering has one major and very frustrating problem, though – If you’re playing by yourself and you log out for whatever reason you can’t rejoin so you have to restart the dungeon all over again. This means that if you spend an hour Dungeoneering and then lag out (if you suffer from lag, see my guide 5 Ways to Stop Runescape Lag) or need to go away for more than five minutes you will lose all your progress. The worst thing is that, when you try to rejoin a solo party, Jagex mocks you by saying “You want to party with yourself?”
Just imagine the sort of terrible problems this error on Jagex’s part could cause. Say someone has been playing Dungeoneering for half an hour and is almost done with the level and then suddenly realizes that his neighbor’s house is on fire. He is now confronted with a difficult option – Should he get up and call the fire department so as to save the house and the people inside or keep Dungeoneering so he doesn’t lose his progress? After contemplating for a moment, he would make the obvious choice that I’m sure we all would make – he would keep Dungeoneering and let his neighbor’s house burn down. This is the type of thing that is going to happen if Jagex doesn’t fix this problem soon.
I do believe that Jagex will fix the problem but, until then, I am going to protest by not training the skill at all. Who’s with me?
EDIT: It has been affirmed here by Mod Emilee that Jagex intends to fix the problem.
“If I play solo and get disconnected, will I need to start the dungeon again?”
Unfortunately yes as dungeons have a habit of moving around when nobody is looking; you need to have a “party” in the dungeon in order to rejoin it.
It is worth noting, if you had progressed through at least 50% of the dungeon, you may get some experience reimbursed to you (but it will be considerably less than if you actually finished the dungeon).
Please note – we are working with our Game Engine Team to try to resolve this issue, but it wasn’t something we could achieve for launch and wasn’t a big enough issue to delay the whole launch or indeed withhold the ability to solo a dungeon.
Loading ...