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

Chris Nelson

  • Administrator
  • *****
  • Posts: 805
Title/Award breakdown
« on: January 08, 2013, 04:36:50 PM »
Howdy everybody,

I was bored today and didn't have much to do.

So to occupy my time I played around in Excel and made a little title/award sheet.

Basically what it does is checks your points for titles and then lists them, and then the more important aspect is it will also list any and all awards you have earned.  I know sometimes figuring all that out can be a little taxing.

Anyway I will post a screenshot so you can see what it looks like.

If you want a list like this for your own dogs awards just shoot me an email with your dogs registration number.   Or if you want to run the formula yourself shoot me an email and I will explain the steps :)




Chris Nelson

  • Administrator
  • *****
  • Posts: 805
Re: Title/Award breakdown
« Reply #1 on: January 08, 2013, 04:40:55 PM »
~Updated to include Versatility NATCH's~



A couple notes:



There is more than what the screenshot shows, I just couldn't fit it all on one page.
You may have to re size a couple columns to fit correctly.   I assume if you have the knowledge to do this then making a column a little wider won't be something I need to explain :)
If you find a error/glitch please let me know :)


If you want to run this yourself here is what you need to do:

1) Look up your dogs points using the 'Points' tab above.
2) Export to CSV
3) Open my file that is attached here
4) Copy everything from K1 to T58
5) Paste this into your dogs csv file, starting at K1.

If that is above and beyond your technical skill than just shoot me an email :)
« Last Edit: January 10, 2013, 02:55:59 PM by Chris 'CJ' Nelson »

Amy McGovern

  • *****
  • Posts: 167
Re: Title/Award breakdown
« Reply #2 on: January 08, 2013, 05:52:27 PM »
Chris,

This is great, thank you! Would you consider adding several columns for the versatility NATCH criteria as well?

I found a few new awards we didn't know we had :-)

Amy and the schnauzers

Jean Sather (McCreight)

  • 2016 Online Seminar Group
  • *****
  • Posts: 278
Re: Title/Award breakdown
« Reply #3 on: January 08, 2013, 06:00:26 PM »
Hey Chris, that's cool!  Might just add to your directions that you have to "enable editing" before copying your awards listing formulas to make it work.  And maybe double-check your formula in cell M-11 (Elite Regular Basic) -- when I applied it to Zack's records that title is showing as a "No" but he is showing Outstanding and Superior Regular Elite titles as earned (which they all should be).

Thanks for doing this!  :)
Jean, Zack & Tux
Montana

Chris Nelson

  • Administrator
  • *****
  • Posts: 805
Re: Title/Award breakdown
« Reply #4 on: January 08, 2013, 06:23:08 PM »
Chris,

This is great, thank you! Would you consider adding several columns for the versatility NATCH criteria as well?

I found a few new awards we didn't know we had :-)



Ahh I knew I was forgetting something!

Yup I will get those added in there too

Chris Nelson

  • Administrator
  • *****
  • Posts: 805
Re: Title/Award breakdown
« Reply #5 on: January 08, 2013, 06:27:42 PM »
Hey Chris, that's cool!  Might just add to your directions that you have to "enable editing" before copying your awards listing formulas to make it work.  And maybe double-check your formula in cell M-11 (Elite Regular Basic) -- when I applied it to Zack's records that title is showing as a "No" but he is showing Outstanding and Superior Regular Elite titles as earned (which they all should be).

Thanks for doing this!  :)

Figured it out.

You earned your EAC on a 20 point bonus run, and the formula I use when adding in titles messed up and didn't give you the title.

So your point records are fixed now, and I got to fix a bug in my title stuff, Score 8)

Chris Nelson

  • Administrator
  • *****
  • Posts: 805
Re: Title/Award breakdown
« Reply #6 on: January 08, 2013, 11:43:55 PM »
Got it updated to include Versatility NATCH's now.

It's in the same post above, but it's a new file now.

Amy McGovern

  • *****
  • Posts: 167
Re: Title/Award breakdown
« Reply #7 on: January 09, 2013, 05:51:03 AM »
Thank you!  This is cool :) I keep track of my points using my own spreadsheet in Numbers (Apple's excel) but this is very useful.
Amy and the schnauzers

Sara Langston

  • Trial Secretary
  • *****
  • Posts: 303
Re: Title/Award breakdown
« Reply #8 on: January 09, 2013, 07:52:24 AM »
Yes, Chris, please send me this spreadsheet.  My dog is Kane, 06-10385.  My private e-mail is sarabillandpups@att.net.  This is a great tool.  You are the best!!!

Sara Langston, Laughing Dog Agility
Sara Langston, Laughing Dog Agility
The Bridge Creek Boys
NATCH3 V-NATCH Kane, Mac, Blaze, & Rocket

Chris Nelson

  • Administrator
  • *****
  • Posts: 805
Re: Title/Award breakdown
« Reply #9 on: January 09, 2013, 09:36:49 PM »
So it seems the biggest issue right now is making this work for folks with a Mac.

I am not 100% on what that solution may be.   I can turn it into just a basic CSV file, which a Mac should be able to open, it won't be pretty anymore but the data would all be correct.  But I do not know what the correct Apple program is to open csv documents on a Mac.   

Ideas?

Nancy H

  • 2016 Online Seminar Group
  • *****
  • Posts: 59
    • Stewie JRT-Agility Blog
Re: Title/Award breakdown
« Reply #10 on: January 10, 2013, 04:28:16 AM »
Hi Chris,

This just worked great for me on a Mac using Excel, but it should also work using Libre office, Open Office, or Neo Office for the Mac.

thanks for the great file,

Nancy and Stewie in NH
Nancy and Skipper JRT

Marcy Matties

  • 2016 Online Seminar Group
  • *****
  • Posts: 532
  • LuvMyDogs
Re: Title/Award breakdown
« Reply #11 on: January 10, 2013, 04:29:31 AM »
So it seems the biggest issue right now is making this work for folks with a Mac.

I am not 100% on what that solution may be.   I can turn it into just a basic CSV file, which a Mac should be able to open, it won't be pretty anymore but the data would all be correct.  But I do not know what the correct Apple program is to open csv documents on a Mac.   

Ideas?

Excel files work fine on a Mac if you have Office.  And Numbers can open excel files as well.

Marcy, Toby, Abby, Dublin and Odie
===============
I want to be runnin' when the sand runs out.

jacque

  • *****
  • Posts: 3
Re: Title/Award breakdown
« Reply #12 on: January 10, 2013, 09:44:25 AM »
Chris this looks great.  Could you please send the breakdown on Banner 09-01240 to jwshimko@charter.net.
Thank you for this and all you do!
Jacque
Jacque S

Rose

  • *****
  • Posts: 24
    • My YouTube Channel
Re: Title/Award breakdown
« Reply #13 on: January 10, 2013, 10:02:39 AM »
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
Rose Kirwan

SpringCrew

  • 2016 Online Seminar Group
  • *****
  • Posts: 108
  • NADAC Addict
Re: Title/Award breakdown
« Reply #14 on: January 10, 2013, 10:08:00 AM »
If they are using Excel on the MAC and having problems opening it, it could be that they have an older version.  Try saving the file as an xls instead of and xlsx.
Tim Spring
If you aren't having fun you're not playing NADAC!