Author Topic: Calculating liftetime points  (Read 2350 times)

Vargie

  • *****
  • Posts: 18
Calculating liftetime points
« on: July 23, 2012, 01:29:09 PM »
Is there an easy way to calculate life time points from the points file?
Thanks
Vargie
Vargie, Summer and Holly

Chris Nelson

  • Administrator
  • *****
  • Posts: 933
Re: Calculating liftetime points
« Reply #1 on: July 23, 2012, 01:38:12 PM »
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

Jeff Lyons

  • Judge
  • *****
  • Posts: 341
Re: Calculating liftetime points
« Reply #2 on: July 23, 2012, 02:22:31 PM »
Wow Chris,

Option B sounds so much more user friendly!!!

 :)
Jeff L.

Chris Nelson

  • Administrator
  • *****
  • Posts: 933
Re: Calculating liftetime points
« Reply #3 on: July 23, 2012, 03:50:51 PM »
That's me, Mister user friendly 8)

Richard Wolfe

  • 2016 Online Seminar Group
  • *****
  • Posts: 385
  • The line is not your friend, do not hug the line!!
Re: Calculating liftetime points
« Reply #4 on: July 23, 2012, 04:03:54 PM »
I was thinking that you need to be very careful when offering room service! ;)
Richard Wolfe
Sparkle, Rowdy, Rumor and Raven

arlene

  • *****
  • Posts: 28
Re: Calculating liftetime points
« Reply #5 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
Arlene

Chris Nelson

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

Chris Nelson

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

arlene

  • *****
  • Posts: 28
Re: Calculating liftetime points
« Reply #8 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
Arlene

Lisa Schmit In The Zone Agility

  • Trial Secretary
  • *****
  • Posts: 307
    • In The Zone Agility
Re: Calculating liftetime points
« Reply #9 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?

Be Well & Happy
In The Zone Agility
www.inthezoneagility.com
Agility and Conditioning Seminars/Online Training Classes

Re: Calculating liftetime points
« Reply #10 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.
Sheila & the Shelties

Chris Nelson

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

LeeAnne McAdam

  • 2016 Online Seminar Group
  • *****
  • Posts: 1062
Re: Calculating liftetime points
« Reply #12 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.
Lee Anne

Becky Wolfe

  • 2016 Online Seminar Group
  • *****
  • Posts: 94
Re: Calculating liftetime points
« Reply #13 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.
Becky with Sonic, Tango, Nala and Herbie
NM

Linda W. Anderson

  • Trial Secretary
  • *****
  • Posts: 976
Re: Calculating liftetime points
« Reply #14 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
Linda W. Anderson - Dogs have only one fault, their lives are too short!