Thepr1de44

I read the help section on Excel! :[)

Creating Trackers with Excel 2007 Table of Contents 1.0 Introduction 1.1 Requirements 2.0 Starting the Tracker 2.1 Getting the Stats from Runescape's Hiscores 2.2 Creating the Formulas 2.3 Creating an Update Macro 2.4 Designing your Tracker 3.0 Final Words 1.0 Introduction Ever wanted to have your own tracker but you really have no idea how to use Microsoft Excel? Well here's the Step By Step Tutorial for you! 1.1 Requirements You will obviously need Microsoft Excel 2007, it would also work on Microsoft Excel 2003 but I'm showing you the "2007 Way". 2.0 Starting the Tracker First, open up Microsoft Excel 2007 and Write your Runescape Username the followings: Your first step is done! 2.1 Getting the Stats from Runescape's Hiscores Now you will have to extract your Stats from Runescape's Hiscores... First, go to the second sheet of your workbook. Then press on the DATA tab and get external data from WEB. In the address bar, put: http://hiscore.runescape.com/hiscorepersonal.ws?user1=(YOUR USERNAME) Then check the little box above your hiscore table... Then click "Import" at the bottom right of the window... Then a Message will pop up, just press ok... You have now loaded your hiscore stats to your workbook! 2.2 Creating the Formulas You know have to go back onto your first sheet... Under the Current Exp box, put "=" and click back on your "sheet 2" without clicking anywhere else... Then Click on your current exp of your desired skill to track. Then press enter. Do the same thing but now with your Current Level... Then, for the % Done to Goal, you need to do the following... Then press enter and you're done with this step! 2.3 Creating an Update Macro Now this is where it gets really complicated... First, go onto the Excel options... And check the box That says "Show Developer Tab in the Ribbon". Now go in the Developer Tab and Click on "Macros Security". Then, enable all Macros... After you've done that, hit ok and Click on the "Record Macro" button. Name your Macro "Update" and hit OK. NOW IT'S VERY IMPORTANT TO DO EXACTLY WHAT I DO AND NOTHING ELSE!! Click on the Data tab and hit the "Refresh All" button. Then click Stop Recording... Now, on your Developer's Tab, Click on Insert and then Click on The Form Control Button. Click and Drag your location and size of your button... And then, select the "Update" Macro and press OK. You have now created your first Macro in Microsoft Excel 2007! Congratulations! 2.4 Designing your Tracker You have finished your tracker but now you have to make it look good! I won't really get into how to design in Microsoft Excel 2007 but I will just show you a picture of my finished tracker.. You will just have to try the borders colors etc... This is just something fast I did to show you an example... 3.0 Final Words In conclusion, this is just the basic of making a Tracker... You can make alot more kinds of trackers with alot more people in it... Just try different things and you'll come up with something good I'm sure! Thank you! Thepr1de 44. © 2009 Thepr1de 44's Creating Trackers with Excel 2007.

Ok, now I see what you mean. But let me ask, why don't YOU pay membership? EDIT: This is in the rants section, rants for me is complaining about something. Jagex has made so many different payments methods, don't tell me it's about how sending the money to Jagex.

My turn \ Free to play players shouldn't really complain at all. FORUM Yes the only think would be them to access to the Runescape's forum. But Jagex has puted an update so that even if you're Free to Play you can use the forum but with the required Total level. ( I don't remember the required Total level. ) It is because ( In my opinion. ), most of the Free to Play players, I'm not saying YOU!, are immature kids and Jagex wouldn't want them to spam the forum, etc. F2P VS P2P A reason why Free to Play players shouldn't complain is the fact that Runescape, comparing to other games online where you have to play, is really cheap. You could always go and get 5 $ anywhere! I mean, how couldn't you get 5 $ in one month? That's ridicoulous! If you decided ( Your choice ) not to Pay to Play, THEN STOP COMPLAINING! I think I made my point. Thank you, Thepr1de 44.

Seriously, the user name changing is really stupid... First of all, like alot said, your friends wouldn't know who the hell you are ... Second of all, you played so long on your account with the same name, why would you NOW want to change your name, couldn't you changed at the beginning when you were level 30 combat or less? Third of all, stop buzzing Jagex about this thing ... If I were a Jagex Moderator, I would just tell you to create a new account if you're not happy with your name, because you're not going to make Jagex pass through a huge refresh of all the accounts of Runescape just because Mister or Ma'am ( Or whatever you want to call it. ) created a account with a name they didn't like ... Think I made my point. Thank you, Thepr1de 44.

It's not that the guide is not good but I just couldn't read it all ... You have no pictures to show me what you're doing or anything so I got bored reading. You should add some pictures to your guide so it becomes more clear... Thank you, Thepr1de 44.

At first, I thought this was a wonderfull ideaso I went to take the pie recipe book and after some calculations, you could make profit only doing Admiral pies, which requires 70 cooking BUT it would make you just a little money, less than 100k per hour, so I wouldn't really want to lose my time doing pictures and writing a guide about something that won't even make me 100k in 1 hour... Thank you, Thepr1de 44.

Thank you! (: I have to try the Yannille method to see if it's even faster! :P Thepr1de 44.

Wow... I really didn't know that since I didn't make alot of money from it since I use my other money making ways... I will correct that but I'll go see if I can do fast runs to varrock castle kitchen's to get pie dish... I'll do some testes and come back to you guys... Thanks for the information, Thepr1de 44.

Wow.. I just loved reading all the blog.. Usually I get bored reading blogs, but yours really rocks.. Plus I love the way you pj! X) Getting Cooking cape and then I'll save money for AGS and own the PVP world like you! (: (: You're my idol... Would you please add me or tell me in which clan chat you usually hang.. Or both? ... : LOVE, Thepr1de 44.

Pie makes money, even for YOU! V2.1 On my last version, I explained how to buy pie dishes from for 3 gp each, but you had to switch worlds alot, today, I'm going to explain how to do it without any quest requirements but you must be a member. Table of Content: 1.0 Introduction 1.1 Requirements 2.0 Start up 2.1 Process 2.2 Ending 2.3 Profit 3.0 Credits 3.1 Future 1.0 Introduction [hide=]While I was wondering if cooking Summer pies from 95 Cooking to 99 was good, I did some calculations of the profit I would make if I would bake pies to 99.. Lucky me, I just found out a good money making method for people with no skills and a little money and that works even on free to play servers... For the faster method you will need some parts of the quest recipe for disaster...[/hide] 1.1 Requirements [hide=]For the GE Method, you only need a few coins but there's one thing you need to know, you can only buy 100 dishes every four hours so it is not good money if you want to do money on short term. But in long term, it is splendid money for low-leveled players. In other hand, the Recipe for Disaster method requires some parts of the quest " Recipe for Disaster ". ( Parts still needs to be confirmed ) If you guys still wonder if the RFD Method would be slower in long-term, you're wrong because if you buy the pie dishes at the RFD chest, it will cost you alot less... ( More information below, keep reading ) Finally, for the Yanille Method, it will only require you some money, same as the RFD Method, and it will also require you to go to Yanille... There are 4 methods to get to Yanille... 1- Teleport to your house ( Which is in Yanille ), and leave your house. 2- Get a ring of duelling and teleport to castle wars, then walk east until you enter Yanille. ( Refer to the world map if needed. ) 3- If you have done the Watchtower Quest and have 58 Magic, you can cast the Watchtower teleport to The Watchtower which is 10 meters North from Yanille. 4- This method requires the Quest Tree Gnome Village. From the Grand Exchange, use the Spirit Tree to the Tree Gnome Village. Then get out of the Village and follow Elkoy to get out of the maze, then walk all the way South ( Probably longest Method ), refer to the world map.[/hide] 2.0 Start up [hide=Using the GE]You will need a few thousand gold pieces, depending on how the Great Exchange database changes.. Then buy 14 Pie dishes and Pastry doughs for max price. ( They sell automatically! ) [/hide] [hide=RFD Method]After done some parts in the Recipe for Disaster Quest ( Need to confirm how many and which ), you can buy Pie dishes for only 3 GP at the Culinaromancer's Chest. But it only has a Player stock with 50 Pie dishes in each world so I suggest buying 50 and switching worlds... My calculations will be in the profit section if you're wondering if it's slow or not! Now go to the Grand Exchange and buy Pastry Dough, the same amount as the Pie Dishes. [/hide] [hide=Yanille Method]First, you need some light equipment so your run energy restores faster... You will need to head to Yanille's bank and take all your money, or a part of it... ( You can also use a Beast of Burden to speed things up. ) Then you must follow this route... Trade a woman named Frenita... Buy a full inventory of Pie dishes, and head bank them... Now go to the Grand Exchange and buy Pastry Dough, the same amount as the Pie Dishes. [/hide] 2.1 Process [hide=]Now bank your ingredients and withdraw them as objects. Use the Pie dish on the Pastry dough and Make-All. [/hide] 2.2 Ending [hide=]Now note all your Pie Shells and sell them in the Grand Exchange for the lowest price possible, they will sell immediately also. [/hide] 2.3 Profit [hide=Using the GE]So we bought 14 Pie dishes for 1,330 gp. We also bought 14 Pastry doughs for 2,870 gp. We sold 14 Pie shells for 6,524 gp. So that means... 1,330 gp + 2,870 gp = 4,200 gp 6,524 gp - 4,200 gp = 2,324 gp So you just made 2,324 gp! In just 22.587 seconds! Which means that will make ... 3,600 seconds = 1 hour 3,600 seconds/22 seconds = Aprox. 164 Repetitions 164 repetitions * 2,324 gp = 381,136 gp 381,136 gp/h ![/hide] [hide=RFD Method]So let's say we bought 50 Pie dishes and we switched worlds... This took me 1:03 minutes and 561 semi-seconds... ( Or whatever you want to call it ). If I want to make 50... Let's find how many seconds it would take to Make-All 50 Pie Shells... 22 seconds / 14 Pie Shells = X seconds / 50 Pie Shells X = (22 seconds * 50 Pie Shells) = 78 seconds ...................14 So it would take 78 seconds or 1:18 minutes. So to buy and Make-All, it would take.. 78 seconds + 63 seconds = 141 seconds 3600 seconds = 1 hour 3600 seconds / 141 seconds = 26 repetitions Cost to make 50... 50 * 3 gp ( Cost for 1 Pie dish ) = 150 gp 50 * 205 gp ( Cost for 1 Pastry Dough ) = 10,250 gp 150 gp + 10250 gp = 10,400 gp Now I sold all my Pie dishes at minimum price but you could sell them at Medium as they will sell after a while also... So the profit... Minimum 21,300 gp - 10,400 gp = 10,900 gp Medium 22,450 gp - 10,400 gp = 12,050 gp TO RECAPITULATE EVERYTHING Total money made in 1 hour selling minimum... 26 repetitions * 10,900 gp = 283,400 gp 283,400 gp/h Total money made in 1 hour selling medium... 26 repetitions * 12,050 hp = 313,300 gp 313,300 gp/h[/hide] [hide=Yanille Method]Let's say we ran from to bank to the shop, we bought 27 Pie Dishes and we ran from the shop to the bank, it took me 35 seconds and 434 semi-seconds.. ( Or whatever you want to call it. ) If I want to make 27... Let's find how many seconds it would take to Make-All 27 Pie Shells... 22 seconds / 14 Pie Shells = X seconds / 27 Pie Shells X = (22 seconds * 27 Pie Shells) = 42 seconds ...................14 So it would take 42 seconds. So to buy and Make-All, it would take.. 35 seconds + 42 seconds = 77 seconds 3600 seconds = 1 hour 3600 seconds / 77 seconds = 47 repetitions Cost to make 27... 27 * 3 gp ( Cost for 1 Pie dish ) = 81 gp 27 * 205 gp ( Cost for 1 Pastry Dough ) = 5,535 gp 81 gp + 5,535 gp = 5,616 gp That's the worth of 27 Pie Shells... So for the profit... 12,069 gp - 5,616 gp = 6,453 gp TO RECAPITULATE EVERYTHING Profit made selling Medium Price... 47 repetitions * 6,453 gp = 303,291 gp 303,291 gp/h[/hide] 3.0 Credits [hide=]Tipit Forums - For allowing me to post this guide. The Tipit Community - For welcoming me as part of the forums. You - For reading. Other guides- For giving me an example on how to make a good guide.[/hide] 3.1 Future [hide=]Please leave some corrections if I'm wrong, or constructive comments... I WILL make a spreadsheet that I will update every day with the prices and profit for everything...[/hide] That's all for now folks! Regards, Thepr1de 44. © 2009 Thepr1de 44's Pie money making Guide.

Less than a day if you have no life. I suggest just getting a better top, barrows armour, bandos, dragon... I don't think you should call people no-lifers.. At my first torso, 6 months ago, I remember that I gogt it in around 4 hours.. Thepr1de 44. Depends if you're with a good clan or good ol' world 6 noobs. If you were with a Barb Assault clan, I believe you. If you just stepped into a room in world 6, you're lying through your teeth. I actually stepped into a world 6 room and some high levels took me, believe me or not, this is what happened... And if you don't believe me, that's your choice, I'm only giving my opinion.. Thepr1de 44. EDIT: I must admit, penance torso isn't really good, barrows armour such as Torag's platebody or Dharok's Platebody are alot better...

The problem is exactly there.. I had enough fun chatting with friends and doing random stuff before, now I would like to train hard in my summer on my account so I can, finally, have fun when I will be a experienced player. Fun for me is being strong and doing dangerous stuff, exemple, doing God Wars Boss hunting or Corporal beast or even King Black Dragon, etc.. ( Excluding PKing since I keep dieing ( If that is spelled right... ) Thank you anyway, Bauke!

Less than a day if you have no life. I suggest just getting a better top, barrows armour, bandos, dragon... I don't think you should call people no-lifers.. At my first torso, 6 months ago, I remember that I gogt it in around 4 hours.. Thepr1de 44.

Hey, A few days ago, I started playing RuneScape again. The only thing I remembered since I quited was Barrows and Farming. So guess what.. That's what I did! I farmed Toadflax until I got enough money for some basic barrows equipment. I went to do some barrows runs and.. I got Dharok helmet. 5.2m... So now that I sold everything, I need someone to tell me what to do next in RuneScape.. Should I get a skillcape? Should I make more money? My Combat level is 110. Here's a link to RuneScape's hiscores, please enter my RuneScape Username to get my stats.. (thepr1de_44): http://hiscore.runescape.com/hiscorepersonal.ws I have exactly 6,390,946 gold pieces OR 6391 K. Thank you, Thepr1de 44.