Author Topic: Title/Award breakdown  (Read 4891 times)

drummond504

  • *****
  • Posts: 2
Re: Title/Award breakdown
« Reply #30 on: January 14, 2013, 06:34:51 AM »
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

  • Administrator
  • *****
  • Posts: 768
Re: Title/Award breakdown
« Reply #31 on: January 14, 2013, 01:01:46 PM »
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

  • Trial Secretary
  • *****
  • Posts: 62
Re: Title/Award breakdown
« Reply #32 on: January 14, 2013, 04:34:25 PM »
THank you, Chris. Tanya made it work for me. I'm a total Excel idiot....

Lynda King

drummond504

  • *****
  • Posts: 2
Re: Title/Award breakdown
« Reply #33 on: January 15, 2013, 05:17:35 AM »
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

  • 2016 Online Seminar Group
  • *****
  • Posts: 244
Re: Title/Award breakdown
« Reply #34 on: January 15, 2013, 06:29:07 AM »
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
Isabel and Cocoa

Chris Nelson

  • Administrator
  • *****
  • Posts: 768
Re: Title/Award breakdown
« Reply #35 on: January 15, 2013, 04:02:38 PM »
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

  • *****
  • Posts: 1
Re: Title/Award breakdown
« Reply #36 on: June 27, 2013, 02:25:13 AM »
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

  • *****
  • Posts: 84
    • My website
Re: Title/Award breakdown
« Reply #37 on: June 27, 2013, 09:47:24 PM »
AWESOME, Chris!  Thanks so much!!!!  :)
Lorrie Stelz

Kaiden: NATCH 10, VersNATCH 8 Tartan Bay More Than Meets The Eye MX MXJ MXF O-HP-E XBR-E IT HIC HOF
Tripp: NATCH 4, VersNATCH 3, All Around NATCH BB's Embrace The Journey HIT HIC HOF
& ret. Chaney: NATCH 8 VersNATCH 5 Wildblue Enchanted MX MXJ MJB MXF S-HP-E HOF

Linda W. Anderson

  • Trial Secretary
  • *****
  • Posts: 962
Re: Title/Award breakdown
« Reply #38 on: June 28, 2013, 05:37:44 AM »
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
Linda W. Anderson - Dogs have only one fault, their lives are too short!

arlene

  • *****
  • Posts: 28
Re: Title/Award breakdown
« Reply #39 on: June 28, 2013, 07:48:50 AM »
Chris could you do the spreadsheet for Skye 06-06055? Thanks so much. Arlene
Arlene

Chris Nelson

  • Administrator
  • *****
  • Posts: 768
Re: Title/Award breakdown
« Reply #40 on: July 06, 2013, 06:38:27 PM »
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

  • *****
  • Posts: 167
Re: Title/Award breakdown
« Reply #41 on: July 06, 2013, 07:42:09 PM »
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
Amy and the schnauzers

Sharon Nelson

  • Mother NADAC
  • Administrator
  • *****
  • Posts: 6031
Re: Title/Award breakdown
« Reply #42 on: July 06, 2013, 09:59:04 PM »
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
Sharon
In-Sync-Agility

LeeAnne McAdam

  • 2016 Online Seminar Group
  • *****
  • Posts: 1061
Re: Title/Award breakdown
« Reply #43 on: July 07, 2013, 07:52:29 AM »
Well, that is just the coolest thing ever!  Tim Spring...you rock!  Thank you!
Lee Anne

SpringCrew

  • 2016 Online Seminar Group
  • *****
  • Posts: 108
  • NADAC Addict
Re: Title/Award breakdown
« Reply #44 on: July 07, 2013, 10:11:07 AM »
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
« Last Edit: July 09, 2013, 01:29:15 PM by SpringCrew »
Tim Spring
If you aren't having fun you're not playing NADAC!