Author Topic: Calculating liftetime points  (Read 2333 times)

Sharon Nelson

  • Mother NADAC
  • Administrator
  • *****
  • Posts: 6054
Re: Calculating liftetime points
« Reply #15 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
« Last Edit: July 24, 2012, 08:58:35 AM by Sharon Nelson »
Sharon
In-Sync-Agility

SpringCrew

  • 2016 Online Seminar Group
  • *****
  • Posts: 108
  • NADAC Addict
Re: Calculating liftetime points
« Reply #16 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.
Tim Spring
If you aren't having fun you're not playing NADAC!

Jackie Brasen

  • Trial Secretary
  • *****
  • Posts: 70
Re: Calculating liftetime points
« Reply #17 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??
mom to the TN Shedding Wonders

MoabDiane

  • 2016 Online Seminar Group
  • *****
  • Posts: 418
Re: Calculating liftetime points
« Reply #18 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

Lynn Saunders

  • Trial Secretary
  • *****
  • Posts: 36
  • Karosel Sheltie 3-Pack
Re: Calculating liftetime points
« Reply #19 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
Lynn Saunders
Truckee, CA
Where the Stars Shine Brighter...

Sharon Nelson

  • Mother NADAC
  • Administrator
  • *****
  • Posts: 6054
Re: Calculating liftetime points
« Reply #20 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
Sharon
In-Sync-Agility

Sharon Nelson

  • Mother NADAC
  • Administrator
  • *****
  • Posts: 6054
Re: Calculating liftetime points
« Reply #21 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
Sharon
In-Sync-Agility

Sharon Nelson

  • Mother NADAC
  • Administrator
  • *****
  • Posts: 6054
Re: Calculating liftetime points
« Reply #22 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
Sharon
In-Sync-Agility

Cynthia & springers

  • Trial Secretary
  • *****
  • Posts: 26
Re: Calculating liftetime points
« Reply #23 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
Cynthia Gilliland &
Ivy, Rosie, Eero, & Iris
Wilder, VT

Goldenbcagilitychamps

  • *****
  • Posts: 11
  • Its the Journey that counts, not the destination!
    • GoldenBCDreams
Re: Calculating liftetime points
« Reply #24 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
Becky and Boys
www.goldenbcdreams.com
Florida

Sharon Nelson

  • Mother NADAC
  • Administrator
  • *****
  • Posts: 6054
Re: Calculating liftetime points
« Reply #25 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
Sharon
In-Sync-Agility

Re: Calculating liftetime points
« Reply #26 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
Charlotte

Chris Nelson

  • Administrator
  • *****
  • Posts: 928
Re: Calculating liftetime points
« Reply #27 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

Cathy

  • *****
  • Posts: 13
Re: Calculating liftetime points
« Reply #28 on: July 31, 2012, 05:46:53 AM »
Thanks, Chris.  That was really easy, even though I don't know anything about Excel :)

Cathy
Cathy