NADAC Forum

General => General Discussion => Topic started by: Chris Nelson on January 08, 2013, 04:36:50 PM

Title: Title/Award breakdown
Post by: Chris Nelson on January 08, 2013, 04:36:50 PM
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 :)



Title: Re: Title/Award breakdown
Post by: Chris Nelson on January 08, 2013, 04:40:55 PM
~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 :)
Title: Re: Title/Award breakdown
Post by: Amy McGovern on January 08, 2013, 05:52:27 PM
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 :-)

Title: Re: Title/Award breakdown
Post by: Jean Sather (McCreight) on January 08, 2013, 06:00:26 PM
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!  :)
Title: Re: Title/Award breakdown
Post by: Chris Nelson on January 08, 2013, 06:23:08 PM
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
Title: Re: Title/Award breakdown
Post by: Chris Nelson on January 08, 2013, 06:27:42 PM
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 8)
Title: Re: Title/Award breakdown
Post by: Chris Nelson on January 08, 2013, 11:43:55 PM
Got it updated to include Versatility NATCH's now.

It's in the same post above, but it's a new file now.
Title: Re: Title/Award breakdown
Post by: Amy McGovern on January 09, 2013, 05:51:03 AM
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.
Title: Re: Title/Award breakdown
Post by: Sara Langston on January 09, 2013, 07:52:24 AM
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
Title: Re: Title/Award breakdown
Post by: Chris Nelson on January 09, 2013, 09:36:49 PM
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?
Title: Re: Title/Award breakdown
Post by: Nancy H on January 10, 2013, 04:28:16 AM
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
Title: Re: Title/Award breakdown
Post by: Marcy Matties on January 10, 2013, 04:29:31 AM
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.

Title: Re: Title/Award breakdown
Post by: jacque on January 10, 2013, 09:44:25 AM
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
Title: Re: Title/Award breakdown
Post by: Rose on January 10, 2013, 10:02:39 AM
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
Title: Re: Title/Award breakdown
Post by: SpringCrew on January 10, 2013, 10:08:00 AM
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.
Title: Re: Title/Award breakdown
Post by: Marcy Matties on January 10, 2013, 11:11:35 AM
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

This is happening on mine as well.  The reason seems to be that the formula for those columns is referring to Column D which is the Class column.  It looks to me like the formula should be referencing Column F instead, as column F is the Title column.

Also, Chris, you said to paste your stuff into Column K - which I did.  But that then replaced the DRI #s which were in Column K.  (Not that it mattered for my dog because we don't have any DRI numbers to write home about  ..  lol)

Has anyone else had this work correctly?  Where it referenced to Column D and that was correct?
Title: Re: Title/Award breakdown
Post by: TSacks on January 10, 2013, 11:34:19 AM
Only problem I had was using another dogs # when pulling up points the first time!  At first I thought, this didn't work right, but then realized what I did!!

Once I used the right #'s, I got the right results and both my dogs are in Elite with lots of titles etc.
I just followed Chris's instructions.

Thanks Chris!!

Tanya, Jake & Indy
Title: Re: Title/Award breakdown
Post by: Chris Nelson on January 10, 2013, 02:30:53 PM
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

Let me know which dog it's for and I will give it a shot and see what's happening :)
Title: Re: Title/Award breakdown
Post by: Chris Nelson on January 10, 2013, 02:33:06 PM
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

This is happening on mine as well.  The reason seems to be that the formula for those columns is referring to Column D which is the Class column.  It looks to me like the formula should be referencing Column F instead, as column F is the Title column.

Also, Chris, you said to paste your stuff into Column K - which I did.  But that then replaced the DRI #s which were in Column K.  (Not that it mattered for my dog because we don't have any DRI numbers to write home about  ..  lol)

Has anyone else had this work correctly?  Where it referenced to Column D and that was correct?


Column D is the Title column ;)  Column F is the DRI column.   I am not sure how you are getting those. 
Title: Re: Title/Award breakdown
Post by: Chris Nelson on January 10, 2013, 02:55:35 PM
Another update.

I also forgot to add in a column for lifetime points.   That is now rectified.

I will attach it here and also fix it back on the original attachment
Title: Re: Title/Award breakdown
Post by: Marcy Matties on January 10, 2013, 03:21:20 PM
[

This is happening on mine as well.  The reason seems to be that the formula for those columns is referring to Column D which is the Class column.  It looks to me like the formula should be referencing Column F instead, as column F is the Title column.

Also, Chris, you said to paste your stuff into Column K - which I did.  But that then replaced the DRI #s which were in Column K.  (Not that it mattered for my dog because we don't have any DRI numbers to write home about  ..  lol)

Has anyone else had this work correctly?  Where it referenced to Column D and that was correct?


Column D is the Title column ;)  Column F is the DRI column.   I am not sure how you are getting those.
[/quote]

On the points excel file that i download and opened on my Mac, here's what i get:
Column A - registration #
Column B - Call name
C - points
D - class
E - total points
F - title
G - Platinum
H - Silver
I - Date earned
J - Host Club
K - DRI

I can always modify the column names in the formulas and get it to work.  Just not sure why my columns are different than yours.
Title: Re: Title/Award breakdown
Post by: Chris Nelson on January 10, 2013, 03:26:06 PM
Marcy,

Are you downloading your points from the Member section?

If so that is the problem.

I made it to work off the older style page since that is still what the majority of people use:  http://www.nadacforum.com/Points.php (http://www.nadacforum.com/Points.php)
Title: Re: Title/Award breakdown
Post by: Marcy Matties on January 10, 2013, 03:27:13 PM


Column D is the Title column ;)  Column F is the DRI column.   I am not sure how you are getting those.
[/quote]

I figured it out.  I was downloading points from the Members Section rather than the Points section.  ;D

Title: Re: Title/Award breakdown
Post by: Rose on January 10, 2013, 08:33:50 PM
I was also downloading points from the Members Section.  Downloaded it from points and it works.  TX

Rose
Title: Re: Title/Award breakdown
Post by: LeeAnne McAdam on January 11, 2013, 05:06:10 AM
Very cool!  I don't know how to do any of this, and you made it simple enough that I followed your instructions and it even worked for me!  And now to show my complete ignorance, do you have to follow that procedure any time points are updated or is there a way to update what we just did?  And if it's too much trouble to explain, don't worry about it...I can just check on here.

Thanks, Chris!
Title: Re: Title/Award breakdown
Post by: LJKing on January 11, 2013, 09:52:58 AM
Hi Chris, thanks for doing this! I tried it but got nowhere...probably because I don't know how to use Excel. When I pasted your file into my dog's point file in Excel (starting with the K column), all I got was your file pasted on the side of the dog's file. It didn't compute anything.

Do you have an idea what I'm doing wrong? As I said, I don't use Excel except to sum.

Thanks again!
Title: Re: Title/Award breakdown
Post by: Chris Nelson on January 11, 2013, 01:47:36 PM
Very cool!  I don't know how to do any of this, and you made it simple enough that I followed your instructions and it even worked for me!  And now to show my complete ignorance, do you have to follow that procedure any time points are updated or is there a way to update what we just did?  And if it's too much trouble to explain, don't worry about it...I can just check on here.

Thanks, Chris!

It will have to be redone for each upload.

Someday I plan on getting a program built that will keep track of everything automatically right from the website.  But that will be a long way off
Title: Re: Title/Award breakdown
Post by: Chris Nelson on January 11, 2013, 01:48:05 PM
Hi Chris, thanks for doing this! I tried it but got nowhere...probably because I don't know how to use Excel. When I pasted your file into my dog's point file in Excel (starting with the K column), all I got was your file pasted on the side of the dog's file. It didn't compute anything.

Do you have an idea what I'm doing wrong? As I said, I don't use Excel except to sum.

Thanks again!

Go ahead and let me know for which dog and I will give it a shot and see whats happening :)
Title: Re: Title/Award breakdown
Post by: LeeAnne McAdam on January 11, 2013, 02:50:01 PM
Very cool!  I don't know how to do any of this, and you made it simple enough that I followed your instructions and it even worked for me!  And now to show my complete ignorance, do you have to follow that procedure any time points are updated or is there a way to update what we just did?  And if it's too much trouble to explain, don't worry about it...I can just check on here.

Thanks, Chris!

It will have to be redone for each upload.

Someday I plan on getting a program built that will keep track of everything automatically right from the website.  But that will be a long way off

Okay...thanks!
Title: Re: Title/Award breakdown
Post by: Shirley Wallace on January 11, 2013, 05:05:58 PM
The first time I tried the copy and paste on my Mac, it didn't work.  But I remembered reading to try saving the cvs file as an xls instead of an xlsx.  So I did, and when I pasted into the cvs.xls file the second time, VOILA!!!!  Ryder had titles filled in.  It worked great that way.   ;D
Shirley
Title: Re: Title/Award breakdown
Post by: drummond504 on January 14, 2013, 06:34:51 AM
Chris,

I can't seem to make this work for my Fancie, 08-12193.  I've included a screen shot of what I get, maybe you can tell me what I'm doing wrong.  If not, could you possibly send it to me my dog to drummond_j@charter.net.  Thanks


Jo Ann Drummond
Smiling Fancie Pants CD, OA, AXJ, NF, RE, TDI, O-NCC, OJC, 0-NAC, TG-N, TN-E, WV-O, HP-N (Border Collie)
Niki TDI, CGC (Siberian Husky)
Smoky CD, RE, TDI (Siberian Husky)

Be kinder than necessary, for everyone you meet is fighting some kind of battle.

Waiting at the Rainbow Bridge
Misty TDI, CD, RE, NA, NAJ (Siberian Husky)
Title: Re: Title/Award breakdown
Post by: Chris Nelson on January 14, 2013, 01:01:46 PM
Chris,

I can't seem to make this work for my Fancie, 08-12193.  I've included a screen shot of what I get, maybe you can tell me what I'm doing wrong.  If not, could you possibly send it to me my dog to drummond_j@charter.net.  Thanks


Jo Ann Drummond
Smiling Fancie Pants CD, OA, AXJ, NF, RE, TDI, O-NCC, OJC, 0-NAC, TG-N, TN-E, WV-O, HP-N (Border Collie)
Niki TDI, CGC (Siberian Husky)
Smoky CD, RE, TDI (Siberian Husky)

Be kinder than necessary, for everyone you meet is fighting some kind of battle.

Waiting at the Rainbow Bridge
Misty TDI, CD, RE, NA, NAJ (Siberian Husky)


Unless I am missing something I believe it's all there?

I went through and took a look at your points and it's matching up with what your screenshot shows.

Title: Re: Title/Award breakdown
Post by: LJKing on January 14, 2013, 04:34:25 PM
THank you, Chris. Tanya made it work for me. I'm a total Excel idiot....

Title: Re: Title/Award breakdown
Post by: drummond504 on January 15, 2013, 05:17:35 AM
Thanks Chris, when it came up at first I saw so many "no's" I thought "that couldn't be right."  Immediately after I sent my post, I realized that it was there, but I couldn't "retrieve" the post.  Thanks for checking and sorry for being too "quick on the post." :-[   

Title: Re: Title/Award breakdown
Post by: danforth on January 15, 2013, 06:29:07 AM
If we create the sheet today, then when there are new points, we should be able to copy all the data from a new CVS and pasted it into A1 of our spreadsheet that was created today.

Is that correct?

Isabel
Title: Re: Title/Award breakdown
Post by: Chris Nelson on January 15, 2013, 04:02:38 PM
If we create the sheet today, then when there are new points, we should be able to copy all the data from a new CVS and pasted it into A1 of our spreadsheet that was created today.

Is that correct?

Isabel

Indeed.

That would work perfectly.
Title: Re: Title/Award breakdown
Post by: Jo-Anne Hamilton on June 27, 2013, 02:25:13 AM
Hi Chris,
Could I please have a copy of this form for Ashton?  His NADAC number is 09-08226.
Thanks for your help,
Jo
Title: Re: Title/Award breakdown
Post by: Lorrie Stelz on June 27, 2013, 09:47:24 PM
AWESOME, Chris!  Thanks so much!!!!  :)
Title: Re: Title/Award breakdown
Post by: Linda W. Anderson on June 28, 2013, 05:37:44 AM
Hi Chris,

This is great but soooo beyond my experience level.  Could you please send me copies for the following dogs:

Ezri  4J083
Dax 04-04217
Zia  07-12295

Thanks,  Linda
lindaezridax@cox.net
Title: Re: Title/Award breakdown
Post by: arlene on June 28, 2013, 07:48:50 AM
Chris could you do the spreadsheet for Skye 06-06055? Thanks so much. Arlene
Title: Re: Title/Award breakdown
Post by: Chris Nelson on July 06, 2013, 06:38:27 PM
A little helpful bit that Tim Spring built that works into my spreadsheet.

This will pull all your points from the website, so essentially skips the step of having to export to csv and all that jazz.
Title: Re: Title/Award breakdown
Post by: Amy McGovern on July 06, 2013, 07:42:09 PM
It doesn't quite work on the mac.  It all shows up in the left hand column (without parsing out to the separate columns).

-Amy and the schnauzers
Title: Re: Title/Award breakdown
Post by: Sharon Nelson on July 06, 2013, 09:59:04 PM
It doesn't quite work on the mac.  It all shows up in the left hand column (without parsing out to the separate columns).

-Amy and the schnauzers

True, it was written as a PC-based sub-routine.

Sharon
Title: Re: Title/Award breakdown
Post by: LeeAnne McAdam on July 07, 2013, 07:52:29 AM
Well, that is just the coolest thing ever!  Tim Spring...you rock!  Thank you!
Title: Re: Title/Award breakdown
Post by: SpringCrew on July 07, 2013, 10:11:07 AM
It doesn't quite work on the mac.  It all shows up in the left hand column (without parsing out to the separate columns).

-Amy and the schnauzers

For some reason the PC version doesn't work on a Mac.  I was able to get the old points lookup to work on a Mac but then it did not work on a PC.  Attached is an updated version of what worked on a Mac with the awards stuff added.  Try it and let me know if it works.  I don't have a Mac to test it on.

Tim

Actually I think I used the wrong starting point.  Look for an update version in Reply 52 once it is approved.  Sorry for the confusion.

Tim
Title: Re: Title/Award breakdown
Post by: LeeAnne McAdam on July 07, 2013, 03:24:43 PM


True, it was written as a PC-based sub-routine.

Sharon
 
I understand none of that!  LOL
Title: Re: Title/Award breakdown
Post by: Amy McGovern on July 07, 2013, 06:16:13 PM
I'll be glad to test but the attachment isn't showing up :(

-Amy and the schnauzers
Title: Re: Title/Award breakdown
Post by: Shirlene Clark on July 08, 2013, 03:07:39 AM
Thank you Chris Nelson and Tim Spring.....  I have advised Australian exhibitors to log onto the forum to give the spreadsheet a go and the feedback is they love it :)
Title: Re: Title/Award breakdown
Post by: Carole Sparks (AUS) on July 08, 2013, 03:38:11 AM
Thanks Chris for the spreadsheet that is totally awesome stuff.

Title: Re: Title/Award breakdown
Post by: SpringCrew on July 08, 2013, 05:43:32 AM
I'll be glad to test but the attachment isn't showing up :(

-Amy and the schnauzers

Should show up soon.  It is await approval by the moderator.
Title: Re: Title/Award breakdown
Post by: SusanAxe on July 08, 2013, 05:25:43 PM
Hi Chris and Tim,
Ive put in Hectors nadac number, no yellow box showing up, but still showing no results found.  Not sure what else I should do.  I am using a mac, is this the reason.  I have no other computer.
Title: Re: Title/Award breakdown
Post by: Shirlene Clark on July 08, 2013, 09:51:08 PM
Hi Chris and Tim,
Ive put in Hectors nadac number, no yellow box showing up, but still showing no results found.  Not sure what else I should do.  I am using a mac, is this the reason.  I have no other computer.

Susan go to reply 44 and use the MAC version of the spreadsheet
Title: Re: Title/Award breakdown
Post by: SpringCrew on July 09, 2013, 10:19:02 AM
Hi Chris and Tim,
Ive put in Hectors nadac number, no yellow box showing up, but still showing no results found.  Not sure what else I should do.  I am using a mac, is this the reason.  I have no other computer.

Try this one.

Tim
Title: Re: Title/Award breakdown
Post by: Amy McGovern on July 09, 2013, 11:37:09 AM
It still didn't work :(  I'll be glad to keep testing the mac version.  I've never programmed in excel or I'd help fix it (I am a programmer). 

-Amy and the schnauzers
Title: Re: Title/Award breakdown
Post by: SpringCrew on July 09, 2013, 06:48:38 PM
It still didn't work :(  I'll be glad to keep testing the mac version.  I've never programmed in excel or I'd help fix it (I am a programmer). 

-Amy and the schnauzers

Try the one in 52.
Title: Re: Title/Award breakdown
Post by: Janice_Shavor on July 10, 2013, 07:38:24 AM
I am now on a mac.  I could open the spreadsheet but how do you get it to interect with the points lookup?
Title: Re: Title/Award breakdown
Post by: SpringCrew on July 10, 2013, 10:22:53 AM
I am now on a mac.  I could open the spreadsheet but how do you get it to interect with the points lookup?

It should automatically prompt you for your dog's NADAC number.  If it doesn't it is because Macros are not enabled.  For the macros to work you must allow macro by Selecting Tools->Options, Click on the Security Tab (pre- office 2010, 2010 is under File, Options, Trust Center, Trust Center Settings, Marco Settings - set to disable with notification).  Click on the Macro Security button.  Set to Medium.  This will prompt you when you open a file with macro if you want to enable them.
Title: Re: Title/Award breakdown
Post by: Janice_Shavor on July 11, 2013, 06:28:28 AM
Ah!!  I am not actually using Excel.  For the limited amount of spreadsheet work I do, I tried Numbers.  I will check on the forums and see if Numbers can import macros. 
Thanks
Title: Re: Title/Award breakdown
Post by: Amy McGovern on July 11, 2013, 08:32:49 AM
Hooray it worked!  On my mac! :)  Thank you!

-Amy and the schnauzers
Title: Re: Title/Award breakdown
Post by: SpringCrew on July 11, 2013, 11:37:37 AM
Hooray it worked!  On my mac! :)  Thank you!

-Amy and the schnauzers

Glad it is working for you.  Helps when I use the right file for the starting point.
Title: Re: Title/Award breakdown
Post by: Jo Benn on July 14, 2013, 08:22:12 PM
Worked great for me on Mac.  I do have Excel.

Jo
Title: Re: Title/Award breakdown
Post by: Karen P. on July 22, 2013, 09:27:19 PM
Chris, could you send me the spreadsheet info for
Frisco: 05-01048
Desi:  11-10079

When I tried to open the CSV file the computer asked me what program to open it with, and Excel Viewer was not in the options.  I have never used Excel & I don't think I have the program, only the Viewer. 
Thanks
Karen Pelkey
k9r2d2@msn.com
Title: Re: Title/Award breakdown / Chris
Post by: Sharon, AZ on August 23, 2013, 09:45:04 AM
When you have time (after champs is fine), I would appreciate a points chart for Beau (08-09295).  Thanks so much!  Sharon
garyharlow5040@gmail.com
Title: Re: Title/Award breakdown / Chris
Post by: Audri, Cee Cee, Lily, Toto, and Calypso on August 23, 2013, 12:14:35 PM
When you have time (after champs is fine), I would appreciate a points chart for Beau (08-09295).  Thanks so much!  Sharon
garyharlow5040@gmail.com

I was working on my points and had the spreadsheet open so I just sent you yours too.  It will come from my work e-mail
Title: Re: Title/Award breakdown
Post by: danforth on September 21, 2013, 06:34:31 PM
I didn't realize that we had earned a Novice Triple Superior Award until I used your spreadsheet.

Thanks.

Isabel and Cocoa
Title: Re: Title/Award breakdown
Post by: Katie Brittan on October 04, 2013, 10:05:05 AM
I know that the line between skilled vs. proficient isn't really there any more, but all you do is type in dates.  I enjoyed making the boxes turn purple when a title/award is earned! I created these in 2011 after seeing a similar grid for another organization.
Title: Re: Title/Award breakdown
Post by: Chris Nelson on October 06, 2013, 05:26:47 PM
I like it :)
Title: Re: Title/Award breakdown
Post by: cheyaut on October 13, 2013, 12:57:22 AM
Doing it with the points look up, and the copy/paste thing, it shows the Novice Versatility as yes, but all the titles above are no.

Then I tried the thing where you get prompted to put in the dog's NADAC number, and it tells me I have to sign in to www.nadac.com (http://www.nadac.com) I tried using my forum login info but that didn't work.

Help?
Title: Re: Title/Award breakdown
Post by: cheyaut on October 13, 2013, 01:42:20 AM
Nevermind, it worked with the copy/paste. I think I wasn't looking at it right maybe lol