NADAC Forum

General => General Discussion => Topic started by: Vargie on July 23, 2012, 01:29:09 PM

Title: Calculating liftetime points
Post by: Vargie on July 23, 2012, 01:29:09 PM
Is there an easy way to calculate life time points from the points file?
Thanks
Vargie
Title: Re: Calculating liftetime points
Post by: Chris Nelson on July 23, 2012, 01:38:12 PM
Here is what I would do:


Option B
Title: Re: Calculating liftetime points
Post by: Jeff Lyons on July 23, 2012, 02:22:31 PM
Wow Chris,

Option B sounds so much more user friendly!!!

 :)
Title: Re: Calculating liftetime points
Post by: Chris Nelson on July 23, 2012, 03:50:51 PM
That's me, Mister user friendly 8)
Title: Re: Calculating liftetime points
Post by: Richard Wolfe on July 23, 2012, 04:03:54 PM
I was thinking that you need to be very careful when offering room service! ;)
Title: Re: Calculating liftetime points
Post by: arlene on July 23, 2012, 06:01:27 PM
Chris, I just looked up Skye's total points at NADAC.com. Following your instructions, I calculate she has 73 points. On the Forum website under member section, you have her listed as having 73 points. So if you are looking for lifetime points wouldn't it be easier to use the member section of the Forum? And if you get a bonus line isn't that added to the total points for that run? Seems it would be simpler to use the Forum or is there a circumstance when the 2 might be different? Arlene
Title: Re: Calculating liftetime points
Post by: Chris Nelson on July 23, 2012, 06:18:28 PM
Everyone is answering their own questions :)

Yes you could go by number of Q's and multiply by 10 if you have never earned a 5/15/20 point Q

The way I explained, in Excel, will total the values contained in the cells.   Not just give a total record #
Title: Re: Calculating liftetime points
Post by: Chris Nelson on July 23, 2012, 06:21:31 PM
If you came up with 73 that is # of records.  Not total points.

Assuming they are all 10 point Q's it would be more like 730

Sent from my ADR6300 using Tapatalk 2
Title: Re: Calculating liftetime points
Post by: arlene on July 23, 2012, 06:36:16 PM
So if I understand correctly - If you have only 10 point Q's you can just multiply by the record. But if you have any 5 point Q's or bonus lines you have to multiply your record then add either the 5 points or bonus lines. This is very complicated for those of us who taught kindergarten for many years. :) Arlene
Title: Re: Calculating liftetime points
Post by: Lisa Schmit In The Zone Agility on July 23, 2012, 07:18:05 PM
Do DRI's over 100 still get a 5 point addition to lifetime points like they use to?

Title: Re: Calculating liftetime points
Post by: Sheila & the Shelties on July 23, 2012, 07:48:28 PM
Everyone is answering their own questions :)



True.  Which is why I will remove mine.  Thinking aloud while online is not good.
Title: Re: Calculating liftetime points
Post by: Chris Nelson on July 23, 2012, 10:21:30 PM
I think this is being made just a wee bit more complicated that it needs to be.

Like I said, if you are using Excel and you do what I described, it will tell you the total of column A in the lower right hand corner.

Or just email me.   That may be the easiest way :)

Sent from my ADR6300 using Tapatalk 2
Title: Re: Calculating liftetime points
Post by: LeeAnne McAdam on July 24, 2012, 06:17:31 AM
I think this is being made just a wee bit more complicated that it needs to be.

Like I said, if you are using Excel and you do what I described, it will tell you the total of column A in the lower right hand corner.

Or just email me.   That may be the easiest way :)

Sent from my ADR6300 using Tapatalk 2

I did what you described, Chris...and it really was easy.  And I don't know anything about using Excel or what exporting to CSV or any of that means, but it showed up just like you said.  I always figure if I can do something on a computer, anybody can so don't be shy folks.  Very easy...and quick, too!  Thanks, Chris.
Title: Re: Calculating liftetime points
Post by: Becky Wolfe on July 24, 2012, 07:09:39 AM
Here is what I would do:

  • Look up your points
  • Go the bottom of the page and look to the right, click on export to CSV
  • Open up the file. From here it may get different if you're on a MAC. I am a PC
  • The very first column will be the point value for that run.  If you're in Excel or a PC based program you can just highlight column 'A' and it will give you the total

Option B
  • Email me and I will total them up for ya


In a MAC, I follow these steps too.  When you open it up it appears in an excel file.  If you go to column A  and see the alphabet across the top. Have you mouse hovering over that letter A,  it will turn into an arrow pointed down. Then at that time, look down at the bottom of the page and about 3/4 the way across the page you will see the word sum= and an number.  This should be your total lifetime points.  this is what I just tried on my pup that doesn't have a lot of points and we matched up.
Title: Re: Calculating liftetime points
Post by: Linda W. Anderson on July 24, 2012, 07:15:34 AM
You can also just copy from the points page, "paste special" into your own EXCEL spread sheet, highlight the first column from the botton with one extra cell and hit "Auto Sum".  If you save this, when there's an update, you can just copy and paste over the first one.  I believe this is exactly what Chris described but I've been doing this from the regular NADAC web site for years.
Linda
Title: Re: Calculating liftetime points
Post by: Sharon Nelson on July 24, 2012, 08:54:08 AM
Do DRI's over 100 still get a 5 point addition to lifetime points like they use to?

No, we stopped doing that in 2010 for the Lifetime points.

Sharon
Title: Re: Calculating liftetime points
Post by: SpringCrew on July 24, 2012, 01:10:05 PM
Just cause I want to make it easy on Chris, :) attached is an excel file to calculate your points from the csv file.  Download the csv points file.  Download the attachment.  Open the excel file.  It will prompt you for the csv file.  Once you have selected the csv, it will go thru the file and calculate the total points for you.  As a bonus, it shows points by year as well.

The excel file uses macros so you must have macros enabled.  If you don't, Excel should tell you how to enable them.  If you don't have excel then you will have to bug Chris or PM me your dogs number and I'll handle it.

Enjoy.
Title: Re: Calculating liftetime points
Post by: Jackie Brasen on July 24, 2012, 08:25:38 PM
Just cause I want to make it easy on Chris, :) attached is an excel file to calculate your points from the csv file.  Download the csv points file.  Download the attachment.  Open the excel file.  It will prompt you for the csv file.  Once you have selected the csv, it will go thru the file and calculate the total points for you.  As a bonus, it shows points by year as well.

The excel file uses macros so you must have macros enabled.  If you don't, Excel should tell you how to enable them.  If you don't have excel then you will have to bug Chris or PM me your dogs number and I'll handle it.

Enjoy.

Wow. sounds very cool. Thank you!!  but... where can we find this attachment??
Title: Re: Calculating liftetime points
Post by: MoabDiane on July 24, 2012, 08:34:58 PM
So....didn't know anything about the 5 extra points for 100+ DRIs "back when."  If there were 100+ DRIs earned during that time....are they reflected somewhere?
It sure is easier to just use Chris's directions....
Thanks.
diane
Title: Re: Calculating liftetime points
Post by: Lynn Saunders on July 25, 2012, 06:26:58 AM
Do DRI's over 100 still get a 5 point addition to lifetime points like they use to?

No, we stopped doing that in 2010 for the Lifetime points.

Sharon

I never even knew this existed! So do 100+ DRI runs earned prior to 2010 earn 5 extra points?

Lynn Saunders
Title: Re: Calculating liftetime points
Post by: Sharon Nelson on July 25, 2012, 06:36:37 AM
Just cause I want to make it easy on Chris, :) attached is an excel file to calculate your points from the csv file.  Download the csv points file.  Download the attachment.  Open the excel file.  It will prompt you for the csv file.  Once you have selected the csv, it will go thru the file and calculate the total points for you.  As a bonus, it shows points by year as well.

The excel file uses macros so you must have macros enabled.  If you don't, Excel should tell you how to enable them.  If you don't have excel then you will have to bug Chris or PM me your dogs number and I'll handle it.

Enjoy.

Wow. sounds very cool. Thank you!!  but... where can we find this attachment??

The attachment is at the bottom of Chris' post.

Sharon
Title: Re: Calculating liftetime points
Post by: Sharon Nelson on July 25, 2012, 06:42:07 AM
So....didn't know anything about the 5 extra points for 100+ DRIs "back when."  If there were 100+ DRIs earned during that time....are they reflected somewhere?
It sure is easier to just use Chris's directions....
Thanks.
diane

This is actually a "cross-over" of topics.  When Lisa asked about the "extra five points" for lifetime points, she was actually referring the the 5 extra lifetime points bonus for dogs that ran over 100+ for calculating "Dog of the year".... it was never actually added into the dog's lifetime points records.... it was a "once a year" calculation done for the points earned during the current year and lifetime to give those awards. 

So I should have changed topics before answering the question and clarified the question and the answer!

Sharon
Title: Re: Calculating liftetime points
Post by: Sharon Nelson on July 25, 2012, 06:46:02 AM

I never even knew this existed! So do 100+ DRI runs earned prior to 2010 earn 5 extra points?

Lynn Saunders

No, they were actually never "earned"... they were used for part of the calculation for the highest scoring Proficient dog of the year and the highest scoring Skilled dog of the year and lifetime pointed dog of the year............ they were never an actual part of the dogs points records... only part of a yearly calculation, which we stopped......... since people did think that they were added into the dog's records........... which they never were........... so we stopped doing that added calculation!

Sharon
Title: Re: Calculating liftetime points
Post by: Cynthia & springers on July 26, 2012, 06:54:27 AM
Another question about lifetime points- I have an older dog that received "grandfather points" years back when jumpers/gamblers titles were changed from 20 points to 30 points.  When figuring lifetime points out for her, are these grandfathered points to be subtracted back out since they were not actually earned?  We are working toward a lifetime point goal, so this will determine whether we celebrate sooner- or later.

Thank you,

Cynthia
& Heather
Title: Re: Calculating liftetime points
Post by: Goldenbcagilitychamps on July 26, 2012, 04:41:50 PM
Wow thanks Chris!!  That sure beats adding each and every run up on a calculator, which I've been doing for years!   ;D
Title: Re: Calculating liftetime points
Post by: Sharon Nelson on July 27, 2012, 09:23:59 AM
Another question about lifetime points- I have an older dog that received "grandfather points" years back when jumpers/gamblers titles were changed from 20 points to 30 points.  When figuring lifetime points out for her, are these grandfathered points to be subtracted back out since they were not actually earned?  We are working toward a lifetime point goal, so this will determine whether we celebrate sooner- or later.

Thank you,

Cynthia
& Heather

Yes, those are added in.  Any points that are listed in the points earned are used for lifetime points.  The "extra" points we used to add for yearly top ten totals were never shown in the dog's point accumulations..... and we don't do that anymore... it got too confusing since they didn't "show"...

But all points that do "show" on the points records are added in for lifetime points!

Good luck!

Sharon
Title: Re: Calculating liftetime points
Post by: Charlotte Idleman on July 29, 2012, 05:40:01 AM
I must have missed the answer to the question about DRI 100+ adding 5 points to lifetime points ???

Charlotte
Title: Re: Calculating liftetime points
Post by: Chris Nelson on July 29, 2012, 05:34:46 PM
See below


Another question about lifetime points- I have an older dog that received "grandfather points" years back when jumpers/gamblers titles were changed from 20 points to 30 points.  When figuring lifetime points out for her, are these grandfathered points to be subtracted back out since they were not actually earned?  We are working toward a lifetime point goal, so this will determine whether we celebrate sooner- or later.

Thank you,

Cynthia
& Heather

Yes, those are added in.  Any points that are listed in the points earned are used for lifetime points.  The "extra" points we used to add for yearly top ten totals were never shown in the dog's point accumulations..... and we don't do that anymore... it got too confusing since they didn't "show"...

But all points that do "show" on the points records are added in for lifetime points!

Good luck!

Sharon
Title: Re: Calculating liftetime points
Post by: Cathy on July 31, 2012, 05:46:53 AM
Thanks, Chris.  That was really easy, even though I don't know anything about Excel :)

Cathy