Thepr1de44 Posted July 13, 2009 Share Posted July 13, 2009 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. Link to comment Share on other sites More sharing options...
Pie Naple Posted July 19, 2009 Share Posted July 19, 2009 Wow, how did you figure all that out? Seems pretty useful, great guide. Link to comment Share on other sites More sharing options...
Thepr1de44 Posted July 20, 2009 Author Share Posted July 20, 2009 Wow, how did you figure all that out? Seems pretty useful, great guide. I read the help section on Excel! :[) Link to comment Share on other sites More sharing options...
thunderlord Posted August 2, 2009 Share Posted August 2, 2009 great guide:D i find it very useful, going to try it soon :thumbsup: (probably right now :P) Link to comment Share on other sites More sharing options...
xmrwhitex Posted August 8, 2009 Share Posted August 8, 2009 This has been annoying me for a while now. Perfect TY. :thumbsup: xmrwhitex Link to comment Share on other sites More sharing options...
Thepr1de44 Posted August 9, 2009 Author Share Posted August 9, 2009 I have a question, how to I get it to Generals Guide Section? Link to comment Share on other sites More sharing options...
Thepr1de44 Posted August 20, 2009 Author Share Posted August 20, 2009 I finally proud I got my guide to the general guides section! I'd like to know your opinions on it please! Link to comment Share on other sites More sharing options...
Sentry_Wolf Posted September 1, 2009 Share Posted September 1, 2009 Thank you for this guide, always wanted to do tracking on excel without the limits of google docs! But, is there any chance that you can do this a faster way if you wanted to track alot of people? (say for a skilling war of over 20 people?) I see you have a few wars there in one of the pictures. And grand exchange merchanting, I know how to do that on google docs aswell, I could never get the right data imported on excel, please show us how to do it? :) Love the guide, thank you so much. Link to comment Share on other sites More sharing options...
Distracted Posted September 2, 2009 Share Posted September 2, 2009 This is a nice guide, everything is explained nicely. I don't have specific goals atm but if I do, I'll be sure to use this :) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now