DPC STATS : personal tracking tool

09/20/2006 11:09:25 AM · #26

Originally posted by wavelength:

Ya'll are making this too difficult.

Copy your stats, save them to a text file, and go to data/import external data/import data on the menu (or whatever it is for openOffice) and just go through the wizard with the defaults. Works like a charm.

oops, wait. no, that doesn't work quite as well as I thought. Calculations are correct, but theres all those spaces....

Nikon AF Zoom-Nikkor 80-200mm f/2.8D ED

09/20/2006 11:18:03 AM · #27

Originally posted by wavelength:

Originally posted by wavelength:
Ya'll are making this too difficult.

Copy your stats, save them to a text file, and go to data/import external data/import data on the menu (or whatever it is for openOffice) and just go through the wizard with the defaults. Works like a charm.

oops, wait. no, that doesn't work quite as well as I thought. Calculations are correct, but theres all those spaces....

For some reason Excel is seeing the tabs as spaces. Even when I try to format the text to be tab delimited, it still doesn't see it.

If I go through the file and insert a pipeline ( | ) between all the fields I can then set the delimiter to pipeline and it works. But that would take too long.

Anyone know how to get Excel to see the tabs as tabs? I've tried paste and paste special.

I think it might have something to do with textPad chaning the tabs to spaces.

sangeeth

Nikon D50

09/20/2006 11:18:53 AM · #28

Works fine, cool
Its nice to know these figures and stats.
Thanks.

wavelength

Nikon D300

09/20/2006 11:21:31 AM · #29

Originally posted by scarbrd:

Okay saving to a text file, deleting the extra tab after the picture title, and then running the import seems to work best. I'm trying to figure a way to get around the tab delete in the import wizard.

09/20/2006 11:26:07 AM · #30

Originally posted by sangeeth:

Works fine, cool
Its nice to know these figures and stats.
Thanks.

What version of Excel are you using?

09/20/2006 12:02:56 PM · #31

Originally posted by scarbrd:

Originally posted by gooc:

Originally posted by scarbrd:

Originally posted by deapee:
I dunno...when I copy/paste it from my text editor, the values don't go into their respective cell locations...it just gets all garbled.

I don't have Microsoft Office, I have OpenOffice.org 2.0 -- maybe that's why.

If you wanna do it, that'd be cool. Otherwise, I'm going to enter my data manually later lol. If not, I don't blame you. If you do though, dbpaull[at]comcast[dot]net

I am having the same problem. I remove the tab between the title and the challenge name, copy and paste it into the Excel sheet. The first cell in each row has all the data for the row, not spliting it up into the comlumns.

I am using Text Pad and Excel

Edit to add screen shot

i tried with your data and i works fine, i'm not an excel expert but i think it has something to do with excel settings, sorry ...

if i find some time i'll do it for you and deapee :-)

Can you send me the excel sheet with my data?

david@scarbrough.cc

Thanks in advance!

Nevermind - I added the tabs manually and the spreadsheet looks good. Must be an Excel version thing.

Thanks for the spreadsheet!!!

deapee

Kodak V803

09/20/2006 12:23:09 PM · #32

oh well I give up. There are literally 40 icons and about 200 menus and I'll be damned if I can find one that says Import or Import from text file or anything along those lines. I'll just do it manually.

09/20/2006 01:37:00 PM · #33

ok... so after seeing this and so many people had trouble using it i decided to try to make something easier to use.

Try This

just go to your profile page, view the source, copy all of it and paste it in the box

09/20/2006 01:41:10 PM · #34

Originally posted by ekmendoza:

Pretty cool! Worked like a champ!

But it would be nice to have the data in a excel sheet.

09/20/2006 01:43:40 PM · #35

Originally posted by scarbrd:

But it would be nice to have the data in a excel sheet.

i could make a .csv file to download... it'll open in excel

09/20/2006 01:53:40 PM · #36

Originally posted by ekmendoza:

Originally posted by scarbrd:
But it would be nice to have the data in a excel sheet.

i could make a .csv file to download... it'll open in excel

That would be sweet!

09/20/2006 02:14:01 PM · #37

it's not completely done... but try it now... let me know what you think

09/20/2006 02:36:00 PM · #38

Originally posted by ekmendoza:

it's not completely done... but try it now... let me know what you think

You so rock!

If you were in Houston I'd ask for a resume!

Let me know if you want me to test again!

Will this stay where it is? I want to bookmark it.

Carl Zeiss 50mm ZE f/1.4 Planar T for Canon

09/20/2006 02:37:10 PM · #39

it'll stay put... let me know if you want me to add/change anything

goc

Apple iPhone 4

09/21/2006 03:00:01 AM · #40

awesome !
how about to add one more line ? percentage, i think it's rather important since the number of entries in challenge is important factor
and ... ummm ... what else ?
nothing more to add for now, excellent work !

yanko

Canon EOS-5D Mark II

09/21/2006 04:38:37 AM · #41

1-15 5.826 70%
16-30 6.225 83%
31-40 5.908 74%

Looks like I'm getting worse. Thanks gooc!

jdannels

Nikon D300s

Sigma 30mm f/1.4 EX DC HSM for Nikon

09/21/2006 06:34:24 AM · #42

1-15 5.8057 69.20%
16-30 6.1137 74.60%
31-44 5.8166 66.14%
Yeah thanks gooc! :P
Well on the flipside I am about to start a new set of 15 so I must be do to getting 6+s again, I hope...

deapee

Kodak V803

Sigma 30mm f/1.4 EX DC HSM for Nikon

09/21/2006 09:30:39 AM · #43

I get a bunch of errors line 56, 57, 58, and 59. Oh well, I'm sure it's a cool little website program. I'm really going to learn how to enter it manually and just do it from there.

Message edited by author 2006-09-21 09:36:23.

ShaneBlake

Nikon D7100

09/21/2006 10:14:19 AM · #44

Originally posted by ekmendoza:

it'll stay put... let me know if you want me to add/change anything

could you modify it to take our username, then using the .dpchallenge.com url, just go screen scrape it for us?

i could do the coding, but i'm lazy... guess scarbrd's not gonna want my resume, huh?...

09/21/2006 10:19:41 AM · #45

Originally posted by kudzu:

Originally posted by ekmendoza:
it'll stay put... let me know if you want me to add/change anything

could you modify it to take our username, then using the .dpchallenge.com url, just go screen scrape it for us?

i could do the coding, but i'm lazy... guess scarbrd's not gonna want my resume, huh?...

We're all full up on lazy coders, but I'll keep you in mind.

09/21/2006 10:34:05 AM · #46

Originally posted by kudzu:

could you modify it to take our username, then using the .dpchallenge.com url, just go screen scrape it for us?

ok... try it now

Canon EF 70-200mm f/2.8L IS USM

09/21/2006 10:42:19 AM · #47

Originally posted by ekmendoza:

Originally posted by kudzu:
could you modify it to take our username, then using the .dpchallenge.com url, just go screen scrape it for us?

ok... try it now

even better!

One suggestion. The cart that is generated, the "scores" scale would be better in whole numbers.

3, 4, 6, 8 . . . . The cart I get has 1.6, 3.2, 4.8, 6.4, 8.

Ocassionally, someone does score higher than 8, not me of course.

Message edited by author 2006-09-21 10:54:14.

C-Fox

Canon EOS-20D

09/21/2006 12:02:54 PM · #48

This is a really need idea and I wanted to thank all the people who contributed time and ideas into it.

ShaneBlake

Nikon D7100

Sigma 30mm f/1.4 EX DC HSM for Nikon

09/21/2006 12:16:01 PM · #49

Originally posted by scarbrd:

We're all full up on lazy coders, but I'll keep you in mind.

dang. good thing i didn't waste time updating my resume... ;)

Originally posted by ekmendoza:

Originally posted by kudzu:
could you modify it to take our username, then using the .dpchallenge.com url, just go screen scrape it for us?

ok... try it now

you, madam, are my new hero.