pulli23

Or maybe add some other variable: run speed! This would allow for kiting, which actually IS the advantage of using ranged skills.. Then kiting naturally becomes better vs melee (yet not so much vs range, if the initial range of the mage is lower than a ranger he doesn't have advantage of his faster run speed)

wrong url :)

Well my biggest question isn't really answered here: is it better to mine or not to mine them? (seeing your pictures I doubt you mine them.. However you didn't answer this and explained why!

the angelsaxian model of economy destroyed the world for thousands please, for the love of god get it out of your brain or either never EVER try to lay it on others.. Economy has become completely inhuman and unforgiving.. People are getting fired just because some holders over at the US like it.. Companies with a history bigger than 200 years are sold out since it's apparantly needed for the european free market.. And are now in hands of private investors of the us, who completely strip the proud company and destroy it! Only aimed at short term monetary gains!

As for the rares, here are the graphs http://www.tip.it/runescape/quest2/graphofphats.png http://www.tip.it/runescape/quest2/graphofsmallrares.png And in my 5 years here, I've never heard even a hint that anyone had tracked rune prices that precisly let alone made a graph so I wouldn't hold my breath... hmm I made some (very) irregular updates from the prices of runes.. Let me look if I can find the sheet (it was on my old pc wish is now in the pc heaven, but maybe I still have an backup). I did this only after the GE was settled though (2008ish). As before that zybez kept track of the prices for me. here is a copy

Well as for the higher end runes, I can give some identification: natures Before the trade limitations they were "on the rise".. I remember being able to easily sell natures for 330-350 each the summer before GWD came out.. After GWD people had other things to spend money on (before that rares, magic or dragon were really the only high end items). Then after bots were banned, ge was introduced (so much less high alchemy was needed as you could just sell it), and not unimportant the introduction of the infinite rune stocks at shops: The prices dropped like a stone over the next years.. With an all-time low-point of 180 GP a rune I noticed.. After that the nature price "recovered" (though it didn't rise as much as the inflation did) to the price it is now. Deaths Before the GE they were slightly more worth than the nature runes, simply since less people made them (though they were much harder to sell too).. Staying around a 350 gold. After the GE these were initially already capped at 320 gold, and dropped to the 300 range.. They kept there for a long time, however as the wilderness was removed, and boss hunting started to become a more and more important part of runescape they were bound to drop. (and especially since between the updates to magic-damage boosting of staves there was no improvement of magic for literary years, magic had become obsolete). However since the big inflation these items are "on the rise", quickly recovering to 300 gp a piece. (suddenly magic started to become popular to collect charms, and people had the money to spend made from statuettes). Now with the increase in power from dungeoneering magic is back in business and so are these runes! Astralls These are funny runes: before the GE they were hardly ever made (only few people needed them, resulting in a long sell time). Thus once the GE was release many people discovered their uses, and they actually rose in price. Going to as high as 200 gold. After that they fall back to 150ish. (around the fall after the GE was introduced all runes took a big hit).. Now they made their way steadily back to a 200 gold price. blood These weren't madeable for a very long time, and the main profit of those "shop buyers". Before all the ANTI-RWT updates happened, they were selling for a very high price, in the 450-500 gold regions. After that they were also initially capped at a much lower price than they were actually worth. However they kept that price for a very long time. When the blood altar was introduced these runes experienced a small "drop", however as crafting these takes almost the same level as crafting double natures, crafting these was pretty much often obsolete.. So they kept stable at 300 gold for a very long time. Since the inflation began the price has been steadily growing to a mere 400+ gold a piece These are runes I knew about when I did my runecrafting (had 85-86 already before the wilderness was removed) Hope that gives you some identification.. Also the place to search would really be zybez.net.. It used to be the main (and only?) price watcher for a very long time

making (emerald) rings profitted last time I checked.. Or you could do the old fashioned cow-hide method.

You hit only very little with the lbs already, thanks to it's lower accuracy than the whip, the difference between the sol and a whip is minimal. The reduced accuracy of the SOL would mean it hits less often than the LBS, and an extra +25 damage on average IF you hit won't really matter. (at to that that the sol is slower..)

lol couldn't care less about merched or not :P - I like to in a personal pace :). Anyways, well I guess I should prayer-increasing (proselyte) armour in that case? Wouldn't it be better to safe-spot-range them there?

Hello, I've got a task of 202 bloodveld.. And since I like to get my range up to par with my melee stats I decided to cannon them. How many cannonballs would I roughly need for those bloodveld? - And what setup is best?

Retrieving Grand Exchange data with excel Using macros to work around the limtations Introduction In this tutorial a way to retrieve data from the grand exchange will be presented and explained. The method uses the visual basic for applications language, commonly known as "macros". The tutorial is aimed at other developers who are searching for a reliable easy method of incorporating this data into excel sheets. Prerequisites for this tutorial are knowledge of the basic excel commands, but no knowledge of VBA is expected nor needed - the tutorial won't explain any of the VBA or EXCEL commands and is only focussed on how to use the macro. Excel 2007 or 2010 is recommended, though previous versions work as well: the only version which won't work are the "starter" version as they have macroes often disabled. In this post first will be discussed why a macro is the best option, a quick review of other options and the disadvantages. After that an thorough explanation follows on how to build your own sheet with these macros. During that chapter I will also explain the internal workings of the macro and the safety will be quickly discussed. This will be followed by a paragraph discussing the limitations & problems of the presented method. Finally the tutorial will be concluded with an example, and a quick summary of the usage. Contents Introduction Contents 1) Why a macro? 2) How to use the macro 2.1) Adding a macro to your workbook 2.2) Using the GE macro 2.3) Safety of the GE macro 3) Limitations 4) An example Summary Final notes 1) Why a macro? Why would anyone use a macro? Macros bring all kind of difficult side effects (can't save as a normal file anymore, always a security warning), and are possible safety leaks? While that is true, there are simply things which can't be achieved without using macros, and on top of that macros also allow for neater user inteface. Thus macros in short will make it much easier for the users while slightly increasing the difficulty for the developer. In the case of the Grand Exchange there are a few methods to retrieve data without using macros. (Though when looking in the how those methods work we see they aren't so difficult from our macro). The first and most commonly used method is to use standard excel interface: in the data ribbon under "get external data" one could click on "from webpage". Then in the pop-up screen one should navigate to the grand exchange and search for the item. Then one clicks on the correct table (for the grand exchange there is sadly only 1 table: the whole webpage) and import it. While this works it has quite a few drawbacks, which macroes don't have: First of all fore each item alone you have to go through the grand exchange manually and update the items, this quickly becomes a hassle and getting the values manually becomes easier. Secondly to update the page, you have to find the original cell where the table was started and right click there to "refresh". Especially if you're not the original creator this is very troublesome. (and again for each item this has to be done in a row. thirdly the items come in "raw" format, meaning there is a lot of extra data (see pic %%%) which is redundant and filling up the worksheet. What's worse is that you can't reliable remove this data as it would return as soon as the query is refreshed. fourthly there are a few limitations on the grand exchange which will prevent you from entering more than 12 terms in a reliable matter. This means you have to build for each 12 items a new query. Also if the items are spread over multiple pages in the grand exchange it's very difficult to miss it. So to conclude while this method works "on paper' there are many limitations prevent it from being useful in bigger projects where there are more than 3-4 items. Another method would be to parse the data with a separate program, or PHP file, after which it is loaded by the "get external data" interface. By parsing the data into a better format for excel one could prevent the problems from above. However there are some other problems rising then: First of all, this makes your workbook depending very much on an external program. If the program would be included with the package you're asking a lot from the user (he has to run the updater manually), and it isn't 1 neat file anymore. If the program would be stored online and the excel sheet become very dependent of other sources.. and might at a some point no longer function. To conclude, this options works very well, however it is demanding on the user. Other options such as using google docs etc might also exist, however there will always be the difficulty of important stuff into the excel sheet, and getting the data at the right positions. Using macros this is all streamlined, and in the presented macro there is a work around presented for each problem with the grand exchange. 2)How to use a macro? In this chapter we will first discus how to generally add macros to a workbook, after that the GE macro will be descussed, first explaining how to use it in your workbook, then explaining quickly the internal working of the macro. The chapter will conclude with an overview of possible problems with macroes and how to tackle those. 2.1)Adding a macro to your workbook First of all we have to know how to open the macro editor. There are several ways to open the editor. The easiest way is to simply press "ALT+F11". Another option is to go to the developer ribbon, and press the first item there (named "visual basic"). On how to enable the developer ribbon, MSDN has an excellent article on how to start writing a macro. Once you open the macro editor, there should be a screen looking such as in pic %%%. It consist of 3 child windows: the window labeled 1 is the "project explorer", here in a treeview you can see all items currently in your excel file - I will return to it later. The window labeled "2" is the main window, this window will display the code of the selected item. The window labeled 3 is the properties window, it can be ignored for now. Now that you opened your macro editor, you should get the macro I build: It can be downloaded: (alternative mirror HERE, or if one prefers to build the macro himself, the source is Pastebin) Though I prefer if you could download from the first source, as that allows me to track the number of downloads making me maybe more eager to update the macro :P. Once you downloaded the "bas" file you can important it into your project. To do so click on the "file" menu and then "import file": browse to the location the file is saved and import it. In the tree view, under your project you will see a new folder: "modules", this folder will hold all your macros. Open the folder and you should find a file "GetGEPrices", double click to open and in the main window the file should now be visible (a hell load of code, we'll get to that later). Now that you have done there are a few things to remember: -First of all you can't save as a standard excel 2007-2010 file (.xlsx) anymore, you have to use the macro enabled file (.xlsm). This is not a problem in pre 2007 version of excel though -Secondly every time a file is opened with macros enabled, they are disabled by default for security measures. You have to enable the macros by clicking on the bar. (in the developer tab you can also change the default behavior, but I don't recommend doing that) If you understand and have done this, you're good to go, and you can actually start using the build macro. 2.2) Using the GE macro Now that you know how to add a macro to your workbook it's time to let the macro do the annoying stuff for you. This macro will retrieve GE prices of items you put in a vertical list. (and will return the names, price and change today) The macro is completely controlled by setting 13 variables, the "default" lines are shown below . It shouldn't be hard to find those lines in the macro (they are the second "block" of code). I will explain each line below Set DataSheet = Sheets("Sheet2") Set InputSheet = Sheets("Sheet1") InputRow = 2 OutputRow = 2 OutputNameCol = 1 OutputPriceCol = 2 OutputChangeCol = 3 InputNameCol = 1 RemoveTrailingRows = True OnlyExact = True OrderAsInput = False showdebug = False Set DataSheet = Sheets("Sheet2") This lines sets the sheet in which the data should be outputted. Simply replace Sheet2 with the name of your desired sheet, don't forget the double quotation marks The data sheet can be the same as the input sheet (though make sure you don't overwrite the input-column) Set InputSheet = Sheets("Sheet1") This lines sets the sheet from which the data should be read. Simply replace Sheet1 with the name of your desired sheet, don't forget the double quotation marks The input sheet can be the same as the data sheet (though make sure you don't overwrite the input-column) InputRow = 2 The row number from which to start reading the data list (top row has number "1") Replace the number [i[2[/i] with the desired number. The number should be greater than 0 OutputRow = 2 The row number from which to start displaying all data (top row has number "1") Replace the number [i[2[/i] with the desired number. The number should be greater than 0 Note that if "OrderAsInput" is set to true this variable is ignored. OutputNameCol = 1 The column number where the found "names" of all items will be displayed. (The first column, labeled "A" has number 1) Replace the number [i[1[/i] with the desired number. Using 0 or a negative value makes the script not display this data OutputPriceCol = 2 The column number where the found "prices" of all items will be displayed. (The first column, labeled "A" has number 1) Replace the number [i[2[/i] with the desired number. Using 0 or a negative value makes the script not display this data. OutputChangeCol = 3 The column number where the found "price change" of all items will be displayed. (The first column, labeled "A" has number 1) Replace the number [i[3[/i] with the desired number. Using 0 or a negative value makes the script not display this data. InputNameCol = 1 The column number where all the items to search for should be presented (The first column, labeled "A" has number 1) Replace the number [i[3[/i] with the desired number. Using 0 or a negative value makes the script not display this data. RemoveTrailingRows = True Sometimes when changing the items there will be less items than the previous call. If set to true the script will remove all extra items from previous calls to the function. Replace True with either True or False Note that if "OrderAsInput" is set to true this variable is ignored. OnlyExact = True If one for example searches for "evil turnip" 7 items show up. If this variable is set to False all these items would be present in the sheet. Setting it to "true" makes only exact matches present. Replace True with either True or False Note that if "OrderAsInput" is set to true this variable is considered "True". OrderAsInput = False The name is slightly misleading, if set to False for each item it will search the exact row of the input. And then place the information of the searched item on this line. This is particularly useful if you want to get the outputted data next to the input. Replace True with either True or False Remember that you should never overwrite the input column. showdebug = False If set to true it will show some debug information. - There will be an extra sheet with all raw data from the pages loaded, the 3rd row in that sheet will contain the actual urls for each page. Also at the currently selected cells (and below) it will put the strings it used to search. Better keep it false, unless you actually have a bug and are trying to solve it yourself. Replace True with either True or False These variables are hopefully self explanatory and you should just follow your own intelligence mostly :), a quick setup if you want for example to get the output prices next to the items: Set DataSheet = Sheets("sheet1") Set InputSheet = Sheets("sheet1") InputRow = 2 OutputRow = 2 OutputNameCol = -1 'We're using the names of the input row OutputPriceCol = 2 OutputChangeCol = -1 'not interested in the change InputNameCol = 1 RemoveTrailingRows = True OnlyExact = True OrderAsInput = True showdebug = False activating he macro Now that you setted up how the macro works you still have to active it's use. A simple way that doesn't require the developer to do anything is to go each time to open the ribbon "view", then click on the "macro" item "view macros", select the wanted (GetGEPrices) macro and press "run". That was a lot of work to activate it, and the tutorial started to say that marcos allow for a neat user interface and are easy for the user of your workbook. The other simple way is using a textbox. This textbox would act as a "button". To create such a button-textbox, first add a textbox to your workbook at the desired location (insert->textbox), give it some neat layout (I'll leave that for your imagination, hint: use bevel & emboss).. And hen right-mouse click your textbox, and from the drop down menu select "Assign macro...". In the pop-up screen search for the wanted (GetGEPrices) macro and press "OK". Now if you click on that textbox with a single left click the macro is activated! Congratulations! Now you're probably wondering what it actually does? Well first of all it reads the input (in batches of 12), it will keep reading the input-column until an empty cell has been found. Then for that input it simply searches the GE and puts the results -removing any format and extracting only useful data- into the output columns. Next chapter will describe in more technical detail. 2.3) Internal workings & safety This chapter will explain in a bit more detail how the script actually gets its data, skip it if you don't like to read dull technical information. The macro works by doing a "get" connection at the runescape site. Since I don't know of anyways to keep a connection open and ask multiple queries with VBA, for each search string it has to open a new connection. There are also a few limitations on the GE which work it's way into the macro. Notably the GE can only handle 12 different terms, so the script reads only 12 items a time. Then it opens the first page with these items, and copies that page to a temporary sheet, then it processes the items in that page line-by-line. It will continue to do this for all pages of the ge. After that it reads the next 12 items.. This cycle continues until the script reads an "empty" input space. The script has a special sub-function to handle numbers and the special character (K, M & B) so the final cells will always have a number in them. The biggest safety problem with scripts are left-overs when an error occurs. Looking at the places where errors might occur the only obvious point is during the collection of the webpage (if ie your internet connection fails). However this possible error is being catched: if internet fails it will simply try to open the next page. (until there are no more pages & items to search for and it will end). This won't result in any leftovers. However if at any point something crashes it still shouldn't be a problem. There simply is only 1 (visible) extra sheet which should then be removed manually. 3) Limitations There are a few limitations to the macro, some which are important some which are not. -The input (and output) has to be in "column" format.. This was simply easiest to program and most logical (if there is strong demand I'll make a way to change it to rows using another variable) -The input has to end with an empty cell. -Special character aren't handled well by the GE. Notably & and + aren't handled well by the GE, I made a workaround by replacing the character by * (this is all done in the script though, no need to change anything in the sheet). It might make the script more slowly as much more results will be found than necessary. 4) An example A complete example can be found: summary To summarize these steps do you have to do to create a GE-listening workbook: Download the macro (HERE, or HERE) Create a new workbook with macros enabled (save as .xlsm) Import the macro Set all variables Add a textbox-button to activate the macro Simple isn't it? :P Final notes This spot is open for some discussion & important notes made by other members from tip.it. Also I'll keep a to-do list for now -I still have to add pictures -Second (rapidshare) mirror has to be uploaded -Example should be explained I hope you can take your advantage with this, and I hope to see spreadsheets have automatic GE-updating prices in the future.

I thought of that too, but both SQL (which is used to read the database internally) as well as PHP (which is used to parse user input from the website to an SQL string) don't put limits on the size of strings (there strings aren't 0-ended, as string starts with an number identifying the size).. It is more likely that there is some (hidden) limitation in the SQL parser to disallow too many words. Thanks for thinking with me though :)

Instead, you make 500M+ because of the all the wonderful drops you get from boss hunting. :smile: Apart from that getting into a team is a pain without all 99's

Hi there, The other day I noticed something wierd, searching for this string: doesn't yield any page with the item "rocktail" (yet I did include it in my search) But what's more strange only searching for: Did show that result.. So I'm thinking that there is a limited number of words? - or is the character number limited, or....? If anybody would give me an idea, I'm happy :)

Well the first course of action -if it happens through kids- is for the parents to take contact with the other parents.. Then the other parents should give their child a stern look and it ought to be over! If that doesn't work, the parent of the offended kid should take it to the school, which should take action (maybe add a theme about social interactions to the course), if all that won't work, there is apparantly something much more problematic with the offending kid. (not listening to school & parents, isn't really bright) and some other organization specialized for these types of kids should be mobilized! And don't say me this is a lot of work: most of it goes automatically and really how often do you expect this to happen? A) You have to know who is doing it B) my child is a little angel and would never do such a thing, you horible horible man!!! how do you know my kid!! are you luring him into chat rooms! i'm calling the cops, you pervert C) uh, what if the stalker is a 65 year old man? D) Hahahah!! schools cant even admit to a non-costodial parent that a child even goes to a school. You try telling a school to do something about something that they have no proof of, and happened outside of school. They are far too busy to listen to every nut that calls up and says " you should say something to little jonny, he's theatening me over what we did last night in WOW" They will call the police on you, for even calling up and mentioning a kid and you will have your life torn apart for any sign of impropriaty with minors. This one I really do promise! Anyone who calls up about a kid they have no business knowing about is looked at with suspicion. But seriously, if you try that last one, please post it on youtube for me, I need a good laugh. You really need to leave this perfect little world you've constructed where everyone is good, looks out for each other, and the police and teachers, etc go have "a good little talking to" to everyone who is heading down the wrong path, and convinces the misguided to get back on the path of good behavior, because you have "heroically" brought the problem to their attention, which they greatly apriciate. How would we have saved little Jonny with out you? Edit: Where were you to save Timmy!!! rofl!!! I'm not sure where you live.. But these course of actions nowadays happens frequently here in the netherlands for taunts through MSN & other social media! - There is even build a specific department at the police for specifically this! (electronic taunts by children)

I'm hoping your a law major or practice law, cause i'd love a good legal debate. For starters unless I am mistaken in facebook court cases recently the law has been ruling in favor of the people who access the information. If you upload a picture of you doing drugs/drinking underage - cops can arrest you for it because it's public information. Angry people who said face-book albums were private have already had cases dismissed. Using public information and posting it - isn't illegal. Please show me the laws where it is. For starters 4chan would have to give the IP up, they are not required to do so by law unless it's subpoenad by the goverment - The ISP also protects the customer in that right, so you would need at least 2 to get action - those takes weeks to get - And believe it or not, That information isn't available at the drop of a hat. Most ISP's use dynamic ips (albiet some are more sticky with longer expirations) - but all it takes is a modem power cycle (for high speed) and or reconnecting (for dial up) and you now have hours of logs to sift through . ISP's are not required by federal law to keep that information on hold very long in the grand scheme of things. Heh, You seem to be misguided, for starters, no one goverment controls the internet and secondly, you ironically hit the nail on the head - You post your private info on the internet elsewhere - and even if you didn't intend for this forum to see it - it's now public information. Well I have no experience with law, other than the copyright & patent laws (which are pretty stupid in some parts of the world, notably the us where not the date of research but the date of you bringing the research to the office is important). However I think the act of deliberately searching and combining some information just to blackmail a person should be considered (dang my dictionary doesn't have a translation, and bablefish came up with "steeling', dutch would be "stalking") - similar to those people in real life who keep following you and phoneing you to see where you are! Of course pictures I place here are public: however copying and/or reposting them somewhere else should be against the law (this is what I ment). Secondly, as I said in my post, it's time that the goverments worldwide take action against those things, and similar to a sports club: if THEY don't take action against offenders THEY are prosecuted for the offense! And this also works on the internet (just look at for example how child porn is handled - not saying crimes as described are as bad as child porn - but it does work). ISP's are required to keep data for a month here in europe since a year or 2.. Enough for quick-law to take action (if you're executed by quicklaw, you won't have to hassle with advocates, currently it's only used to prosecute people commiting crimes at big festivals, within 8 hours of commiting a crime you're facing the consequences). Well the first course of action -if it happens through kids- is for the parents to take contact with the other parents.. Then the other parents should give their child a stern look and it ought to be over! If that doesn't work, the parent of the offended kid should take it to the school, which should take action (maybe add a theme about social interactions to the course), if all that won't work, there is apparantly something much more problematic with the offending kid. (not listening to school & parents, isn't really bright) and some other organization specialized for these types of kids should be mobilized! And don't say me this is a lot of work: most of it goes automatically and really how often do you expect this to happen?

Tribal-wars used to have almost realistic distances :)

Yeah it's very unlikely, but there's a good chance that you'd be harassed if you really did things someone didn't like. And besides, all it would take would be one case where someone being hurt was made possible by the information that was "provided" by blizzard and they'd be [bleep]ed as a company. Or at least in quite a bit of trouble. Harrassing someone is a crime! - The goverment should protect it's citizens from this: a simple prosecution by quick-law would be enough.. And as I said it's time that this happens (this can only happen once the internet is considered public though, and for that to happen you also have to have your own ID when coming on the internet and not hiding behind something else.. So we're stuck a bit with the egg-chicken problem)

why you mad why do you want e-respect for your pixels? no1 asked you to open the thread Simple answer: Neither. Only impressive capes are ones that take work, like slayer/summoning/prayer/herb. Define work

I think the " thingymummywhat" should remain a mystery :P

Wow this year really must've sucked so far quest-based.. This quest had potentional, a lot: it's been participated for I don't know how long anymore (I still remember that draynor bank didn't have to be patched though, it's been like 5 years ago). The wise old man really was/is one of the most important people of RS.. And now in a quest of around an hour he simply "retires". Really where are the quests with a lot of length & lots of different stuff.. (the whole old elves storyline, from underground pass till mep2 did everytime bring an amazing new region to runescape). Last quest with a big story & long (non repetitive) time to finish was while guthix sleeps, and to a lesser extend curse of arrav! quest nowadays are: "help I need some help", "wow something unexpected happens", "few funny (I admit the quest WAS amazingly fun) actions", "over".. All finishable in an hour without any prior knowledge!

Cities3-5 days walking from each other? IN the medieval time there were lots of smaller and bigger "grow points". Cities like paris, berlin & amsterdam were -during the middle ages- actually multiple smaller towns next to each other. I would say that between "major" cities there used to be around a 40 km distance.

from all playermods I met since the new update, about 60% are pretty much like: "hey I'm a player mod, you should some respect" - something I consider borderline power hungry!

Maybe no one cared because no one has heard of this forum. ROFL.. you know that forum probably has more members than runescape has.. And for sure a better reputation (they are often the place important articles about programming/game design are published).. Maybe you don't know about it, but that shows more about your knowledge than about that forum I think these things actually IMPROVE the maturity of a forum. People are less inclined to troll if they know that they might actually commit a crime which is prosecuted! Of course they are not the only reason for immaturity at gaming communities, but they play an important part in it.

... wow master of arguments I see.. You know another forum I'm at, gamedev.net requires you to show these information (along with education, and location you live) for a long time already.. Nobody had any problem with it ever.. (It only worked in positive way since people could ACTUALLY contact each other)