| Author | Thread |
|
|
05/08/2008 12:14:11 PM · #1 |
I would like to be able to chart my progress in excel, and it would be easier to eport the personal challenge data than manually do it.
|
|
|
|
05/08/2008 12:20:18 PM · #2 |
just click the show all box so all your challenge entries show then copy and paste the whole table into Excel. Or you can get the data analytics plug-in if you use Firefox and that will do it when the same data is just highlighted.
Message edited by author 2008-05-08 12:20:38. |
|
|
|
05/08/2008 12:41:51 PM · #3 |
Originally posted by Hot_Pixel:
I would like to be able to chart my progress in excel, and it would be easier to eport the personal challenge data than manually do it. |
I agree that it is kind of a PITA because it does not paste cleanly into Excel but requires manipulation after pasting. What would be great is a comma-delimited text file output. Pretty much any program in existence will deal well with that as input. |
|
|
|
05/08/2008 12:44:04 PM · #4 |
Originally posted by kirbic:
Originally posted by Hot_Pixel:
I would like to be able to chart my progress in excel, and it would be easier to eport the personal challenge data than manually do it. |
I agree that it is kind of a PITA because it does not paste cleanly into Excel but requires manipulation after pasting. What would be great is a comma-delimited text file output. Pretty much any program in existence will deal well with that as input. |
Comma-delimited would be wonderful ! |
|
|
|
05/08/2008 12:50:08 PM · #5 |
comma delimited with maybe the participant vs non participant vote included and your own voting avg on the challenge if you voted would be great I think.
|
|
|
|
05/08/2008 02:48:57 PM · #6 |
Originally posted by kirbic:
I agree that it is kind of a PITA because it does not paste cleanly into Excel but requires manipulation after pasting. What would be great is a comma-delimited text file output. Pretty much any program in existence will deal well with that as input. |
It depends a lot on what you cut it from. IE does a good job, Firefox not so good. Least that is what it was like last time I tried - with IE, the data is all there cleanly. |
|
|
|
05/08/2008 02:56:09 PM · #7 |
Originally posted by Gordon:
... with IE, the data is all there cleanly. |
Do you have to pick a matching range of cells to paste into, or just paste into the top-left cell, or something else? |
|
|
|
05/08/2008 03:07:42 PM · #8 |
Here is what I do to select all my challenge data.
1) On your challenge entries in the bottom left corner Select All.
2) On the top left where your entries start, skip the first little arrow thing and start at the title and drag until the last fav entry. (Basically everything)
2) Right Click copy.
3) Open Excel, select top left square.
4) Right Click->Paste Special->Unicode Text
It should drop everything into separate boxes all aligned with each entries data. :)
I use Firefox and this work great. The only data I can't get is how many votes I had on each entry to get an accurate average. That one I have to do by hand. Hope this helps, not sure if this is what you guys are looking for. :)
It would be nice to just get a text file, preferably with how many votes each entry had. |
|
Home -
Challenges -
Community -
League -
Photos -
Cameras -
Lenses -
Learn -
Help -
Terms of Use -
Privacy -
Top ^
DPChallenge, and website content and design, Copyright © 2001-2025 Challenging Technologies, LLC.
All digital photo copyrights belong to the photographers and may not be used without permission.
Current Server Time: 08/28/2025 09:17:38 AM EDT.
