DPChallenge: A Digital Photography Contest You are not logged in. (log in or register) 
 

DPChallenge Forums >> General Discussion >> Dork Excel question
Pages:  
Showing posts 1 - 19 of 19, (reverse)
AuthorThread
 01/10/2007 01:12:11 PM · #1
So I want to graph my "100 challenges to date" progress (it's a flat line, more or less) and to do so I want to copy the challenges rows from my profile and paste them into Excel, but I don't want the HTML coding. If I "paste special" as text, it's a mess. Any simple way to do this?
 01/10/2007 01:15:13 PM · #2
Just go here

//www.myfoobar.com/DPC/

It will even give you the excel sheet.
 01/10/2007 01:21:27 PM · #3
Oh, that is way too friggin' cool!

Thanks!

And it is a flat line after the first 25. I've peaked.
 01/10/2007 01:24:23 PM · #4
Originally posted by Melethia:
Oh, that is way too friggin' cool!

Thanks!

And it is a flat line after the first 25. I've peaked.


I forget who did that but I will be forever grateful!

You can put in any DPC user too.
 01/10/2007 01:26:29 PM · #5
Cor! That's neat...and since I joined I have been making a slow upward climb, going from average of 4 to an average of 5. There have been peaks and troughs along the way, but better than I thought.
 01/10/2007 01:48:49 PM · #6
And for the geeks who must do it themselves...

- On your profile page, highlight the title line and all challenges in the table. Make sure you get everyting on the first and last lines.
- Copy to clipboard, either by right-clicking and selecting "copy" or by pressing CTRL-C.
- Open a new Excel spreadsheet, place cursor in cell A1 of Sheet1
- Edit>Paste Special and select Unicode Text
- Drag the width of column A to acdommodate the text
- Highlight cells A2 through A-whatever, (the bottom of your table)
- Drag the contents down one cell so that they line up with the rest of the rows
- From main menu, Insert>worksheet if you don't already have the default three sheets in your workbook. If you do, ignore this step.
- Click back to Sheet1
- Highlight columns A through I (the entire columns)
- From main menu, Data>Filter>Auto Filter
- Select the pull-down filter in Column A, and choose "custom"
- In the filter dialog, choose "Does not Equal" in the top left box, and leave the other boxes blank. Click OK.
- All your blank lines will now disappear. They are still there, but hidden.
- Now select all the rows that have data in them, and copy
- Click on sheet2
- Paste
- Now only the visible data has been copied over. You can delete Sheet1 if you wish.

The above procedure is for Excel 97. It will also work on Excel 2000 and 2003, but the auto filtering is easier in later versions. Custom filter is not required, you can just select "non-blank" from the main auto-filter choices. If this choice exists for you, use it!
 01/10/2007 01:50:13 PM · #7
Originally posted by kirbic:
And for the geeks who must do it themselves...

- On your profile page, highlight the title line and all challenges in the table. Make sure you get everyting on the first and last lines.
- Copy to clipboard, either by right-clicking and selecting "copy" or by pressing CTRL-C.
- Open a new Excel spreadsheet, place cursor in cell A1 of Sheet1
- Edit>Paste Special and select Unicode Text
- Drag the width of column A to acdommodate the text
- Highlight cells A2 through A-whatever, (the bottom of your table)
- Drag the contents down one cell so that they line up with the rest of the rows
- From main menu, Insert>worksheet if you don't already have the default three sheets in your workbook. If you do, ignore this step.
- Click back to Sheet1
- Highlight columns A through I (the entire columns)
- From main menu, Data>Filter>Auto Filter
- Select the pull-down filter in Column A, and choose "custom"
- In the filter dialog, choose "Does not Equal" in the top left box, and leave the other boxes blank. Click OK.
- All your blank lines will now disappear. They are still there, but hidden.
- Now select all the rows that have data in them, and copy
- Click on sheet2
- Paste
- Now only the visible data has been copied over. You can delete Sheet1 if you wish.

The above procedure is for Excel 97. It will also work on Excel 2000 and 2003, but the auto filtering is easier in later versions. Custom filter is not required, you can just select "non-blank" from the main auto-filter choices. If this choice exists for you, use it!


I like my way better! ;-)
 01/10/2007 01:52:11 PM · #8
Originally posted by scarbrd:
Just go here

//www.myfoobar.com/DPC/

It will even give you the excel sheet.


Holy moly that is cool!!! How come I never saw that before?
01/10/2007 01:53:19 PM · #9
Originally posted by KarenNfld:
Originally posted by scarbrd:
Just go here

//www.myfoobar.com/DPC/

It will even give you the excel sheet.


Holy moly that is cool!!! How come I never saw that before?


There are a few threads that mention it. I'll try to find the memeber that did this. Pretty slick programming.

She didn't seem to break a sweat doing it either.
 01/10/2007 01:53:30 PM · #10
Warning: fopen(//fotomann_forever.dpchallenge.com): failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request in /home/content/e/k/m/ekmendoza/html/DPC/add.php on line 16

Warning: file_get_contents(//fotomann_forever.dpchallenge.com): failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request in /home/content/e/k/m/ekmendoza/html/DPC/add.php on line 17

Warning: strpos(): Offset not contained in string. in /home/content/e/k/m/ekmendoza/html/DPC/add.php on line 23
Click Here

Darn it :-(

Seems not to like the underscore... angela_packard crashes it too...and so does _eug

Message edited by author 2007-01-10 13:55:44.
 01/10/2007 01:54:57 PM · #11
Originally posted by fotomann_forever:
Warning: fopen(//fotomann_forever.dpchallenge.com): failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request in /home/content/e/k/m/ekmendoza/html/DPC/add.php on line 16

Warning: file_get_contents(//fotomann_forever.dpchallenge.com): failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request in /home/content/e/k/m/ekmendoza/html/DPC/add.php on line 17

Warning: strpos(): Offset not contained in string. in /home/content/e/k/m/ekmendoza/html/DPC/add.php on line 23
Click Here

Darn it :-(


Must be the under score or something. Try the copy and paste field

Message edited by author 2007-01-10 14:02:09.
 01/10/2007 01:58:08 PM · #12
Originally posted by scarbrd:
Originally posted by KarenNfld:
Originally posted by scarbrd:
Just go here

//www.myfoobar.com/DPC/

It will even give you the excel sheet.


Holy moly that is cool!!! How come I never saw that before?


There are a few threads that mention it. I'll try to find the memeber that did this. Pretty slick programming.

She didn't seem to break a sweat doing it either.


ekmendoza
 01/10/2007 02:11:06 PM · #13
Originally posted by scarbrd:

Must be the under score or something. Try the copy and paste field


What exactly do I copy and paste?
 01/10/2007 02:14:10 PM · #14
Originally posted by scarbrd:
Just go here

//www.myfoobar.com/DPC/

It will even give you the excel sheet.


This will not work for me. I think it's because I have two challenges with no title. I tried to manually enter "no title" in and it still does not work.

Here is what I get.

Warning: fopen(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /home/content/e/k/m/ekmendoza/html/DPC/add.php on line 16

Warning: fopen(//Southern Gentleman.dpchallenge.com): failed to open stream: Success in /home/content/e/k/m/ekmendoza/html/DPC/add.php on line 16

Warning: file_get_contents(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /home/content/e/k/m/ekmendoza/html/DPC/add.php on line 17

Warning: file_get_contents(//Southern Gentleman.dpchallenge.com): failed to open stream: Success in /home/content/e/k/m/ekmendoza/html/DPC/add.php on line 17

Warning: strpos(): Offset not contained in string. in /home/content/e/k/m/ekmendoza/html/DPC/add.php on line 23
Click Here
 01/10/2007 02:15:56 PM · #15
Originally posted by Southern Gentleman:
This will not work for me. I think it's because I have two challenges with no title. I tried to manually enter "no title" in and it still does not work.

Here is what I get.


I think its the space in your name. I remember that being a problem. Seems like the work around is to put a * in the space. (I have unnamed challenges too, so its not that)
 01/10/2007 02:17:48 PM · #16
It seems to miss challenges. I don't know if it is a lot or a few. I just noticed because I have 2 scores below 5 and only saw one on the graph. Adulthood is missing when I plug my name in.
 01/10/2007 02:18:04 PM · #17
//www.dpchallenge.com/forum.php?action=read&FORUM_THREAD_ID=425843
 01/10/2007 02:23:47 PM · #18
Originally posted by fotomann_forever:
Originally posted by scarbrd:

Must be the under score or something. Try the copy and paste field


What exactly do I copy and paste?


First have you Profile page show all your entries

Then go to View Source

Copy all the text and paste into the box

Hit Submit
 01/10/2007 02:44:42 PM · #19
I guess I'm not smart enough to figure this out... LOL... I'll just chart it in Open Office later :-)
Pages:  
Current Server Time: 09/19/2025 11:24:27 AM

Please log in or register to post to the forums.


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: 09/19/2025 11:24:27 AM EDT.