Excel Points Tracking Sheet

[Mark]

Ok folks, this is my first stab at creating something in MS Excel.

What it does:

It calculates current points for riders and will list them from 1st place to 32nd according to the points total. Also lists the top 5 on the top of the sheet. It is set up for a 15 race format, but will work with anything less than that.

Check out the bottom of the sheet for instructions on how to enter the info. Be sure to save it to your own drive after entering information.

Give it a try and let me know if you have any questions.


Zip File: http://www.floridaquadriders.com/Points Tracking Sheet.zip

Or

Excel File: http://www.floridaquadriders.com/Points Tracking Sheet.xls (this one will ask for a password, Just click on cancel and it will load)


Also, If any you Excel guru’s out there can think of way’s to make it work better please let me know. I’m a rookie.

Here's a screen shot.
http://www.floridaquadriders.com/public_html/images1/ScreenShotPointsTrackingSheet.bmp

[Albright335]

Hey Mark...

I am one of those "excel guru's" LoL!!! It looks great...I have one that I use that is very similar :D

Anyway...Looks Great!

Jen

[Mark]

Thanks Jen,

Do you know anything about writing or recording macros?

I tried over and over again to record one that would sort the results. I wanted to add it to a button on the page and after hours of trying, getting errors, and searching the internet for answers, I gave up. I don't have a clue as to what I was doing wrong. :confused:



Mark

[Albright335]

I have worked with Macros "some"....let me look into it and play around...If I can't figure it out -I know someone who could show me :D

Get back to ya soon!

Jen

[DOUG]

Anything new on this??

[Albright335]

enuff: I no longer work with the person that knew Macros enuff:

[Buddy]

I came across this thread the other day and modified an spreadsheet that I used to keep scores for the FTR Mx Series.

I have attached it here. It has the macros that you guys were looking for to sort. It also sorts and figures the lowest races that are going to be dropped.

Email with any questions,

Buddy Martin

[Mark]

WOW! Buddy, that is perfect! Thanks for sharing it.

Could you recommend any good books on Excel? From the looks of it you’ve read a few.:D

Thanks again,
Mark

[Buddy]

Sorry but I have not ever opened a book on Excel. A lot of the learning curve came from learning DOS Lotus 123 in the late 80's/early 90's and the early editions of MS's spreadsheet program that came out bundled with Works and Excel as it slowly came out.

In my job I use a lot of formulas and if you know some Basic programming language and can look up and apply functions in Excel, you can do a lot.

Macros are simple because if you know what you want to do, you just record and name it. You just record your keystrokes and you have a macro. You can assign the macro to a button and whala!, you look like you know something.

Questions just let me know,

Buddy

[Mark]

Originally posted by Buddy

Macros are simple because if you know what you want to do, you just record and name it. You just record your keystrokes and you have a macro.

That’s the problem I’m having. I have gone over and over again the steps to record one that sorts and I keep ending up with error messages when I run it. I have got to be doing something wrong but I can’t figure out what.

When I run the macro (to sort) it goes to a different page with a pop up window saying this:

Compile error:

Invalid outside procedure


And this is in the background in a different window:

Selection.Sort Key1:=Range("S5"), Order1:=xlDescending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

with “S5” highlighted

If you have any suggestions or if you could point me in a certain direction I would greatly appreciate it.


Mark

[Buddy]

I don't know where you are with all this, if you already know it, just skip it.

The problem with your macro looks like your identified range is one cell. You can't sort one cell.

Try this first. Don't worry about the macro side, just make sure you can sort.
On your spreadsheet;
1. Highlight the ranges you want to sort.
2.Click DATA | SORT
3. The sort box will come up, (if your data range included the header row, click that at the bottom) pick the column you would like to sort, ascending or descending.
Click OK... Did it work? It should of sorted according to that column.

To record a macro;
1. Click TOOLS | MACRO | RECORD NEW MACRO
2. When the "Record Macro" button comes up, name it and assign is a shortcut. The shortcut is really handy in making sure the macro works the way you want it to. Just press alt and the shortcut key and run it.
3. Go through all the motions that you did manually to sort, when you are done click TOOLS | MACRO | STOP RECORDING.
You should have a macro that you can run with your shortcut.

If you know how to sort and create a macro, now you can assign your macro to a button.
I was going to tell you how to do it my way, but a person in my office told me about a web site that explains it much better. It is http://www.mrexcel.com/tip068.shtml

That should pretty much let you do a lot, if you have problems, let me know although, I'm leaving for the H/S first thing Friday morning and will be gone all weekend.

Buddy