Calculating liftetime points

[Vargie]

Is there an easy way to calculate life time points from the points file?
Thanks
Vargie

[Chris Nelson]

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]

Wow Chris,

Option B sounds so much more user friendly!!!

 

[Chris Nelson]

That's me, Mister user friendly

[Richard Wolfe]

I was thinking that you need to be very careful when offering room service!

[arlene]

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

[Chris Nelson]

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]

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]

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

[Lisa Schmit In The Zone Agility]

Do DRI's over 100 still get a 5 point addition to lifetime points like they use to?

[Sheila & the Shelties]

Everyone is answering their own questions

True.  Which is why I will remove mine.  Thinking aloud while online is not good.

[Chris Nelson]

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]

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.

[Becky Wolfe]

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.

[Linda W. Anderson]

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