Title/Award breakdown

[drummond504]

Chris,

I can't seem to make this work for my Fancie, 08-12193.  I've included a screen shot of what I get, maybe you can tell me what I'm doing wrong.  If not, could you possibly send it to me my dog to drummond_j@charter.net.  Thanks


Jo Ann Drummond
Smiling Fancie Pants CD, OA, AXJ, NF, RE, TDI, O-NCC, OJC, 0-NAC, TG-N, TN-E, WV-O, HP-N (Border Collie)
Niki TDI, CGC (Siberian Husky)
Smoky CD, RE, TDI (Siberian Husky)

Be kinder than necessary, for everyone you meet is fighting some kind of battle.

Waiting at the Rainbow Bridge
Misty TDI, CD, RE, NA, NAJ (Siberian Husky)

[Chris Nelson]

Chris,

I can't seem to make this work for my Fancie, 08-12193.  I've included a screen shot of what I get, maybe you can tell me what I'm doing wrong.  If not, could you possibly send it to me my dog to drummond_j@charter.net.  Thanks


Jo Ann Drummond
Smiling Fancie Pants CD, OA, AXJ, NF, RE, TDI, O-NCC, OJC, 0-NAC, TG-N, TN-E, WV-O, HP-N (Border Collie)
Niki TDI, CGC (Siberian Husky)
Smoky CD, RE, TDI (Siberian Husky)

Be kinder than necessary, for everyone you meet is fighting some kind of battle.

Waiting at the Rainbow Bridge
Misty TDI, CD, RE, NA, NAJ (Siberian Husky)

Unless I am missing something I believe it's all there?

I went through and took a look at your points and it's matching up with what your screenshot shows.

[LJKing]

THank you, Chris. Tanya made it work for me. I'm a total Excel idiot....

[drummond504]

Thanks Chris, when it came up at first I saw so many "no's" I thought "that couldn't be right."  Immediately after I sent my post, I realized that it was there, but I couldn't "retrieve" the post.  Thanks for checking and sorry for being too "quick on the post."    

[danforth]

If we create the sheet today, then when there are new points, we should be able to copy all the data from a new CVS and pasted it into A1 of our spreadsheet that was created today.

Is that correct?

Isabel

[Chris Nelson]

If we create the sheet today, then when there are new points, we should be able to copy all the data from a new CVS and pasted it into A1 of our spreadsheet that was created today.

Is that correct?

Isabel

Indeed.

That would work perfectly.

[Jo-Anne Hamilton]

Hi Chris,
Could I please have a copy of this form for Ashton?  His NADAC number is 09-08226.
Thanks for your help,
Jo

[Lorrie Stelz]

AWESOME, Chris!  Thanks so much!!!! 

[Linda W. Anderson]

Hi Chris,

This is great but soooo beyond my experience level.  Could you please send me copies for the following dogs:

Ezri  4J083
Dax 04-04217
Zia  07-12295

Thanks,  Linda
lindaezridax@cox.net

[arlene]

Chris could you do the spreadsheet for Skye 06-06055? Thanks so much. Arlene

[Chris Nelson]

A little helpful bit that Tim Spring built that works into my spreadsheet.

This will pull all your points from the website, so essentially skips the step of having to export to csv and all that jazz.

[Amy McGovern]

It doesn't quite work on the mac.  It all shows up in the left hand column (without parsing out to the separate columns).

-Amy and the schnauzers

[Sharon Nelson]

It doesn't quite work on the mac.  It all shows up in the left hand column (without parsing out to the separate columns).

-Amy and the schnauzers

True, it was written as a PC-based sub-routine.

Sharon

[LeeAnne McAdam]

Well, that is just the coolest thing ever!  Tim Spring...you rock!  Thank you!

[SpringCrew]

It doesn't quite work on the mac.  It all shows up in the left hand column (without parsing out to the separate columns).

-Amy and the schnauzers

For some reason the PC version doesn't work on a Mac.  I was able to get the old points lookup to work on a Mac but then it did not work on a PC.  Attached is an updated version of what worked on a Mac with the awards stuff added.  Try it and let me know if it works.  I don't have a Mac to test it on.

Tim

Actually I think I used the wrong starting point.  Look for an update version in Reply 52 once it is approved.  Sorry for the confusion.

Tim