Title/Award breakdown

[Chris Nelson]

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]

~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

[Amy McGovern]

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 :-)

[Jean Sather (McCreight)]

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! 

[Chris Nelson]

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]

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

[Chris Nelson]

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]

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.

[Sara Langston]

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

[Chris Nelson]

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]

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

[Marcy Matties]

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.

[jacque]

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

[Rose]

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

[SpringCrew]

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.