brainymidget

Herblore added.

Lol I was going to post that your pictures are broken but it looks like about 10 others beat me to the punch. And by the way, you were kind of contradictory. Early in the guide you said: And then later on you said: I personally have found the best money thieving is doing Pyramid Plunder, if you keep all Gold things and sell them you can probably make 50k-100k per hour and every few hours you can get a Pharaoh's Scepter which is currently worth about 1 million.

Glad to help, and by the way, the URL you posted links to the page where you edit the spread sheet. You don't have it set so that people can edit or view your document, so people can't view it. What you need to do is click Share > Publish as a web page, then it will give you the link to it.

Well with Hi-scores, which should be the same as extracting from the GE database, it updates every 1 hour, or whenever I refreshed all the data in my spreadsheet, but I never really do that so it's pretty much every 1 hour.

Rolled a 6, got 81 prayer.

Didn't play yesterday due to a friends birthday. Rolled an 18 though and got 76 thieving.

If you are using guthans, you shouldn't have to use Mage protect very much at all, especially if you have a good familiar to heal you. If you are using veracs, you will need to use it almost all the time if you don't have a familiar, but the better familiar you get, the less you have to have it on. With a unicorn, I very rarely need it but it is still helpful when I'm getting hit by a lot of spinolyps. And it's bad getting prime on you because sometimes you really don't need mage pray, and sometimes your pray might drop and then you are usually dead within a couple hits.

I doubt it. First off, if Sailing is coming out, I'm guessing it wouldn't be Timbo that would accidentally/purposely leak it out. He is in charge of the clan community and does not know as much about those other things. I have talked with him on various occasions and there are some things that he has said he is not allowed to talk about but most he just doesn't know because that isn't his department.

Is there any way to change where the bar goes? I personally am not a fan of the bar positioning so if it can be moved, please explain how. Also, is it possible to add any kind of IRC function into this? Maybe if using the low detail, it could be positioned in the black space below the Runescape window, although for high detail it would not be as easy.

Ya, I've used svens guide for a while to track competitions within my community. I based this largely off that, I just had to ImportHtml instead of ImportData.

Eh, don't really feel like downloading at the moment, I'll take a look at it on Google Docs. So, what was the best pouch to use?

Simple and to the point. 8/10 This can be pretty helpful for low'ish levels who need to make a little bit of money.

The white dots around your banner annoyed me and I got bored. [img=http://img13.imageshack.us/img13/976/armadylrb3.png]

I wouldn't roll the dice again although I might decide to do something else, or I might just play Xbox. Basically, the dice just means I have to train that skill until I get a level, no matter how I go about it.

Hmm, I honestly don't know. I'll take a look into it and tell you if I find out how to make it work.

Google Docs is essentially like Microsoft Office, and the spreadsheet form which we will be using is essentially like Excel, but it has a helpful feature which is that it can extract data from the internet(Although I recently found out Excel can as well but I haven't found a way to do it as efficiently so I'm sticking with Google Docs.) Extracting prices on the GE can be helpful for many things, the biggest one is making calculators. I make lots of Gp / Xp calculators and I use this so that they are always up to date. So ya, on with the guide. [hide=How to use Google Docs]To be able to use Google Docs, you will first need a Gmail account, or Google Email. Now your first step is to 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. Now that you have Google Docs open, we need to start the process. Start off by making a new spreadsheet, this is what I use to make the calculator, or for the purpose of this guide, simply extracting prices off the database.[/hide] [hide=ImportHtml]First off, what I do is start with this formula, to extract the data from the GE database. =ImportHtml("http://itemdb-rs.runescape.com/results.ws?query=Willow Logs", "table", 2) ImportHtml takes the HTML off of the specified site. Now there are three parts that are going into the parenthesis for Importing the Html. The Url, the type of Html to look for, and the index of the html. The Url is where it is extracting the data from. Make sure it is in quotations or it will not work. The link you see me using in the code above is the link that you will always be using for extracting GE prices although the query will change. The type of Html for it to look for is next. There are only two options for this, table, or list. List will just find things that are in the list format, all you will get from this is the Drop down menus at the top of the screen. We will be using "table". This will look for tables within the page, which is what the prices are contained within. This also has to be within quotation marks or it will not work. The index is the third thing, which is where you see the number 2. This 2 is used because the table where the prices are found is the second table within the page. For other things, you may need to use a different index but just for extracting GE prices, you should always just be using 2. When I entered this whole code into excel, in cell A1, I came out with something that looked like this. As you can see, that's more information then we need, so we have to narrow it down.[/hide] [hide=Index]You see here that the first column is empty, the second column is the item name, and the third column is prices. Now prices is what we care about. The price of the thing that we want, Willow logs, is in Row 2, column 3. So now we will use "Index" to tell it to only take the information from Row 2, Column 3. Index is a code that tells what row and column to take information from. This way instead of getting all the data like in the picture above, we can just get one specific cell out of that, the cell that contains the price of whatever you are looking up, in this case, Willow Logs. After you add "Index" it will look like this: =Index(ImportHtml("http://itemdb-rs.runescape.com/results.ws?query=Willow Logs", "table", 2),2,3) So what you did was added "Index(" before Importhtml, and ",2,3)" after it. Now the results will just be "18" the price of willow logs. Sometimes, the first option when you look up an item will not be the item you are looking for, in which case you will have to change the row. If it is the second item, just change it to ",3,3" or "4,3" for the third item, and I think you get it by now. So now you have looked up the exact price of an item and put it into a cell of your spreadsheet but we are not completely done yet.[/hide] [hide=Concat]Now there is one thing you can do to make it even easier. With my calculators, I don't want to manually enter every item, so I just have the code take the item that is put in after "query=" from within my spreadsheet. To do this, I use "Concat" Concat takes the information from a cell within your spreadsheet, and inputs it into your code. We will be using it so that instead of typing out "Willow Logs" this code will see Willow Logs typed out in A2 and put willow logs directly into the link. So now, let's change the code once more. The code should now look like this: =Index(ImportHtml(Concat("http://itemdb-rs.runescape.com/results.ws?query=",A2), "table", 2),2,3) As you can see I added "(Concat" after Importhtml and ",A2" after query=" What this does is tells it to find what to put in that position is the Informaton found in A2. If the price you are looking up is in A3, then just change to A3.[/hide] [hide=Making a calculator]Now that you know how to extract information from the GE database, I will give you a little bit more help on making a calculator like my Gp / Xp ones. First off you need to make the headings, which will basically be what the Raw product is, what the finished product is, how much experience you gain per, how much it costs, and how much it sells for(Use your knowledge from the above reading to do these), and then how much you lose/profit per, and then Gp/Xp. Now that you have the headings, you need to fill them. Start off by filling up what the Raw and finished product is. Try and get the names exactly what they are so that it will extract the right prices. Then fill in the experience, there is no secret trick to this, just go on the Manual and find how much exp it gives. The next two will be the cost of the raw, and the selling price of the finished, in these two you will fill in the code you learned earlier. Next up is the Profit/Loss per. For this just subtract the Finished product from the Raw Product, or vice versa, depending how you want to do it. Now for this, don't just input the prices or it won't auto update that, you need to input the cells so it will always take the data from there no matter how much it changes. So put something like "=F2-E2" and that will give you the result you're looking for. The last one is the Gp / Xp per. For this you are dividing your profit/loss by the experience gained. To do this you just do something like =G2/C2. Once you do this, the results might not always be pretty, you will probably have a decimal with 20+ digits. To fix this we need to round it, I personally round to 3 decimals. The code I use for this is: =ROUND(G2/C2,3) which divides G2 by C2 and then rounds it to 3 decimals.[/hide] So there you go, you can now make an always updating calculator with prices straight from the GE database. Once you're done with it all, you should have a finished product something like this.

Runescript Just type !Die 24

Rolled a 19 today, got 93 fletching.

My current priority list is Smithing, then crafting, then herblore. And I posted this on another site so I'll post this here as well. An explanation on how I make the calculators, the majority of the explanation is in extracting prices. Most of making these is simple, although getting the GE prices can be complicated if you don't know how to do it. Here is a good explanation of it. First off, I start with this formula, to extract the data from the GE database. =ImportHtml("http://itemdb-rs.runescape.com/results.ws?query=Willow Logs", "table", 2) ImportHtml takes the HTML off of the specified site. For things such as extracting data off the hi-scores, the lite hi-scores where they are extracted from are all text, there is no Html involved so you can just use ImportData but for this you have to use ImportHtml. So the link tells you where to take the data from. The second part can either say "table" or "list" to tell it what to look for. If you do list, it's just going to give you the lists that are on the top, like Home, Play now, Account, etc... and the drop down lists from them. I tell it to find tables which is what the prices are in. The third thing in this formula is the 2. This tells it to find the second table. I just tried different numbers there until I found the thing that contained the prices. When I entered this whole code, I came out with something that looked like this. As you can see, that's more information then we need, so we have to narrow it down. You see here that the first column is empty, the second column is the item name, and the third column is prices. Now prices is what we care about. The price of the thing that we want, Willow logs, is in Row 2, column 3. So now we will use "Index" to tell it to only take the information from Row 2, Column 3. Now the code will look like this: =Index(ImportHtml("http://itemdb-rs.runescape.com/results.ws?query=Willow Logs", "table", 2),2,3) So what you did was added "Index(" before Importhtml, and ",2,3)" after it. Now the results will just be "18" the price of willow logs. Sometimes, the first option when you look up an item will not be the item you are looking for, in which case you will have to change the row. If it is the second item, just change it to ",3,3" or "4,3" for the third item, and I think you get it by now. So now you have looked up the prices. Now there is one thing you can do to make it even easier. With my calculators, I don't want to manually enter every item, so I just have the code take the item that is put in after "query=" from within my spreadsheet. To do this, I use "Concat" So now I am going to change my code to =Index(ImportHtml(Concat("http://itemdb-rs.runescape.com/results.ws?query=",A2), "table", 2),2,3). As you can see I added "(Concat" after Importhtml and ",A2" after query=" What this does is tells it to find what to put in that position is the Informaton found in A2. If the price you are looking up is in A3, then just change to A3. So there, now you can successfully look up prices from the GE Database. As for the rest of the calculator. The loss per is just "=E2-F2" or whatever the cells may be. And the Gp / Xp is usually just the profit divided by the experience, and rounded. To do this I use "=ROUND(G2/C2,3)" You can change the G2 and C2 to whatever the appropriate cells are, and the 3 tells it to round to 3 places, you can change this however you like.

Hehe, smithing was actually the one I planned to make next so you can wait til later today and I'll have that one out. And I do Gp / Xp which is either the profit per, loss per, or cost of the product, divided by the experience.

[url=http://forum.tip.it/viewtopic.php?f=98&t=782031]Brainymidget - The Blog Of Brainymidget[/url]

Glad to help. I plan to make a lot more. The last 3 of those only took me about 30 minutes. If anyone has any skills they would like me to make, just request it and that can be my next.

All of these calculators will show the Gp per xp of various different skills. I extracted the GE prices with Google Docs so the prices are always up to date, although I can't embed HTML so this is just a picture which will not be up to date. The links will however be up to date. Fletching Click this link for the always up to date graph. http://spreadsheets.google.com/pub?key=psI...O_sOvs-02vmJ3Rw And picture(Not kept up to date) NOTE: All numbers in this are assuming buying and selling at mid, which you can not do for somethings. Some things may have to be used as junk, and some things may be unbuyable. Firemaking Link for up to date graph http://spreadsheets.google.com/pub?key=psI...O_sN-wixazo59fQ Picture(Not kept up to date) NOTE: All numbers are without Fire ring or Flame Gloves. Prayer Link for up to date graph http://spreadsheets.google.com/pub?key=psI...O_sN0N61v4mYODw Picture(Not kept up to date) Cooking Link for up to date graph http://spreadsheets.google.com/pub?key=psI...O_sPDv2E9XgqGGA Picture(Not kept up to date) NOTE: All numbers are assuming nothing burned. Herblore Link for up to date graph <!-- m -->http://spreadsheets.google.com/pub?key= ... 2v_zp4uLLg<!-- m --> Herb farming http://spreadsheets.google.com/pub?key= ... DZiC5cf_cg

For those who don't know how I'm training skills, every day I roll a 24 sided dice, courtesy of IRC. I will find what skill that corresponds with and train that skill. If the goal is already completed or something doesn't allow me to train that skill such as being out of money for Dragon Bones, I will roll the dice again. I will train the skill for the full day and I will never stop until I get atleast 1 level, with the exception of my 98 skills. I almost always get the skill done within 1 day but not always. On Tuesday I rolled a 21 for Runecrafting, I didn't play very much Tuesday or Wednesday so today, got 75 runecrafting. That is the first goal of the blog completed (Disregard the 100% goals, I put every skill in here, whether I was already at my target level or not.)

Brainymidget's Blog of Stuff Hello everybody. I am Brainymidget. And this... Is my Blog. Starting Stats of My Blog Stats as of the Day after Yesterday My Dream Stats The Many Goals of The Midget 75+ All [X] 80+ All [] 136 Combat [] Top 10k Rank Overall [] 150m Overall Exp [] Untrimming HP cape with 8 other 99's [] Get Over 50m Cash [X] Get Over 100m Cash [X] Pictures of Recent Levels: Other Achievements: