Title/Award breakdown

[Marcy Matties]

Chris:

I tried it, but the values remain "No" except for Novice, Open & Elite Versatility.  Even the values for the titles required to earn the Versatility Awards.

Rose

This is happening on mine as well.  The reason seems to be that the formula for those columns is referring to Column D which is the Class column.  It looks to me like the formula should be referencing Column F instead, as column F is the Title column.

Also, Chris, you said to paste your stuff into Column K - which I did.  But that then replaced the DRI #s which were in Column K.  (Not that it mattered for my dog because we don't have any DRI numbers to write home about  ..  lol)

Has anyone else had this work correctly?  Where it referenced to Column D and that was correct?

[TSacks]

Only problem I had was using another dogs # when pulling up points the first time!  At first I thought, this didn't work right, but then realized what I did!!

Once I used the right #'s, I got the right results and both my dogs are in Elite with lots of titles etc.
I just followed Chris's instructions.

Thanks Chris!!

Tanya, Jake & Indy

[Chris Nelson]

Chris:

I tried it, but the values remain "No" except for Novice, Open & Elite Versatility.  Even the values for the titles required to earn the Versatility Awards.

Rose

Let me know which dog it's for and I will give it a shot and see what's happening

[Chris Nelson]

Chris:

I tried it, but the values remain "No" except for Novice, Open & Elite Versatility.  Even the values for the titles required to earn the Versatility Awards.

Rose

This is happening on mine as well.  The reason seems to be that the formula for those columns is referring to Column D which is the Class column.  It looks to me like the formula should be referencing Column F instead, as column F is the Title column.

Also, Chris, you said to paste your stuff into Column K - which I did.  But that then replaced the DRI #s which were in Column K.  (Not that it mattered for my dog because we don't have any DRI numbers to write home about  ..  lol)

Has anyone else had this work correctly?  Where it referenced to Column D and that was correct?

Column D is the Title column   Column F is the DRI column.   I am not sure how you are getting those. 

[Chris Nelson]

Another update.

I also forgot to add in a column for lifetime points.   That is now rectified.

I will attach it here and also fix it back on the original attachment

[Marcy Matties]

[

This is happening on mine as well.  The reason seems to be that the formula for those columns is referring to Column D which is the Class column.  It looks to me like the formula should be referencing Column F instead, as column F is the Title column.

Also, Chris, you said to paste your stuff into Column K - which I did.  But that then replaced the DRI #s which were in Column K.  (Not that it mattered for my dog because we don't have any DRI numbers to write home about  ..  lol)

Has anyone else had this work correctly?  Where it referenced to Column D and that was correct?

Column D is the Title column   Column F is the DRI column.   I am not sure how you are getting those.
[/quote]

On the points excel file that i download and opened on my Mac, here's what i get:
Column A - registration #
Column B - Call name
C - points
D - class
E - total points
F - title
G - Platinum
H - Silver
I - Date earned
J - Host Club
K - DRI

I can always modify the column names in the formulas and get it to work.  Just not sure why my columns are different than yours.

[Chris Nelson]

Marcy,

Are you downloading your points from the Member section?

If so that is the problem.

I made it to work off the older style page since that is still what the majority of people use:  http://www.nadacforum.com/Points.php

[Marcy Matties]

Column D is the Title column   Column F is the DRI column.   I am not sure how you are getting those.
[/quote]

I figured it out.  I was downloading points from the Members Section rather than the Points section. 

[Rose]

I was also downloading points from the Members Section.  Downloaded it from points and it works.  TX

Rose

[LeeAnne McAdam]

Very cool!  I don't know how to do any of this, and you made it simple enough that I followed your instructions and it even worked for me!  And now to show my complete ignorance, do you have to follow that procedure any time points are updated or is there a way to update what we just did?  And if it's too much trouble to explain, don't worry about it...I can just check on here.

Thanks, Chris!

[LJKing]

Hi Chris, thanks for doing this! I tried it but got nowhere...probably because I don't know how to use Excel. When I pasted your file into my dog's point file in Excel (starting with the K column), all I got was your file pasted on the side of the dog's file. It didn't compute anything.

Do you have an idea what I'm doing wrong? As I said, I don't use Excel except to sum.

Thanks again!

[Chris Nelson]

Very cool!  I don't know how to do any of this, and you made it simple enough that I followed your instructions and it even worked for me!  And now to show my complete ignorance, do you have to follow that procedure any time points are updated or is there a way to update what we just did?  And if it's too much trouble to explain, don't worry about it...I can just check on here.

Thanks, Chris!

It will have to be redone for each upload.

Someday I plan on getting a program built that will keep track of everything automatically right from the website.  But that will be a long way off

[Chris Nelson]

Hi Chris, thanks for doing this! I tried it but got nowhere...probably because I don't know how to use Excel. When I pasted your file into my dog's point file in Excel (starting with the K column), all I got was your file pasted on the side of the dog's file. It didn't compute anything.

Do you have an idea what I'm doing wrong? As I said, I don't use Excel except to sum.

Thanks again!

Go ahead and let me know for which dog and I will give it a shot and see whats happening

[LeeAnne McAdam]

Very cool!  I don't know how to do any of this, and you made it simple enough that I followed your instructions and it even worked for me!  And now to show my complete ignorance, do you have to follow that procedure any time points are updated or is there a way to update what we just did?  And if it's too much trouble to explain, don't worry about it...I can just check on here.

Thanks, Chris!

It will have to be redone for each upload.

Someday I plan on getting a program built that will keep track of everything automatically right from the website.  But that will be a long way off

Okay...thanks!

[Shirley Wallace]

The first time I tried the copy and paste on my Mac, it didn't work.  But I remembered reading to try saving the cvs file as an xls instead of an xlsx.  So I did, and when I pasted into the cvs.xls file the second time, VOILA!!!!  Ryder had titles filled in.  It worked great that way.   
Shirley