View previous topic :: View next topic |
Author |
Message |
shoewizard
Hall of Famer

Joined: 10 Aug 2006
Posts: 2679
Location: In front of my computer
|
Posted: Mon Jan 08, 2007 3:02 pm Post subject: I Need Help importing excel spreadsheet |
 |
|
I'd like to paste an excel spreadsheet into a message here. It is my projections for the season.
Just pasting them and putting "code" around it doesn't work.
Can anyone help me? Either give me detailed instructions, and if I can't get it to work, perhaps I could e mail the spread sheet to you to help me out?? |
|
Back to top |
|
 |
matt
Veteran Presence

Joined: 10 Aug 2006
Posts: 1507
Location: Researching my theory that a lime hat is more effective than tinfoil
|
Posted: Mon Jan 08, 2007 4:22 pm Post subject: |
 |
|
There may be an easier way to do it but they way I do it is to copy hte sheet into a txt file and then go on each column to make sure the spaces are right. It may look correct right away but you need to have the spacing correct. |
|
Back to top |
|
 |
EvilJuan
Veteran Presence

Joined: 10 Aug 2006
Posts: 1535
Location: Phoenix, AZ
|
Posted: Mon Jan 08, 2007 4:31 pm Post subject: |
 |
|
I have also been majorly frustrated trying to go direct from Excel. Matt's suggestion has worked for me; but it's still a lot more work than it should be...
Hey, Jim/Admin, and TAP: I know that other types of groups (such as the ones at Yahoo) have a "Files" section where information can be uploaded so that those interested can access/download it. Is that a possibility here?
_________________
Is It Next Season Yet? 
Last edited by EvilJuan on Mon Jan 08, 2007 4:31 pm; edited 1 time in total |
|
Back to top |
|
 |
shoewizard
Hall of Famer

Joined: 10 Aug 2006
Posts: 2679
Location: In front of my computer
|
Posted: Mon Jan 08, 2007 4:31 pm Post subject: |
 |
|
a txt file....like a word document or something?
I am trying to have to avoid spending tons of time manually fixing the spacing...kind of defeats the purpose. |
|
Back to top |
|
 |
EvilJuan
Veteran Presence

Joined: 10 Aug 2006
Posts: 1535
Location: Phoenix, AZ
|
Posted: Mon Jan 08, 2007 4:34 pm Post subject: |
 |
|
shoewizard wrote: |
a txt file....like a word document or something?
I am trying to have to avoid spending tons of time manually fixing the spacing...kind of defeats the purpose. |
No, more primitive than a Word document.
You can use MS Word to create such a document; but you must save it as a ".txt" file. It's easier to import the Excel file into a new file in Wordpad or Notepad (text editor programs), which save files as .txt files. Then, you can copy these into a dialog box here at the DBBP, using the "code" command. However, you're still going to have to do some tweaking if the columns...
If you're using XP, click Start>All Programs> Accessories; and then scroll down to find Notepad and Wordpad...
_________________
Is It Next Season Yet? 
Last edited by EvilJuan on Mon Jan 08, 2007 4:36 pm; edited 1 time in total
|
|
Back to top |
|
 |
matt
Veteran Presence

Joined: 10 Aug 2006
Posts: 1507
Location: Researching my theory that a lime hat is more effective than tinfoil
|
Posted: Mon Jan 08, 2007 4:35 pm Post subject: |
 |
|
A txt file is a plain text file. You can save word documents as plain text or you can just right click and choose create new file and select plain text file from the list.
That's the only way I know of here. It sucks and its a pain in the ass but that's my only way. |
|
Back to top |
|
 |
rgndvo
AAA Stud

Joined: 07 Dec 2006
Posts: 66
|
Posted: Mon Jan 08, 2007 4:42 pm Post subject: |
 |
|
I dont know anything really about adding objects to this board but...
If you copy and paste it into microsoft paint (comes standard on any office machine) it can be saved as a picture. Not sure if thats easier. If you figure it out though let me know cause I have some projections coming soon. |
|
Back to top |
|
 |
TAP
Veteran Presence

Joined: 10 Aug 2006
Posts: 1976
Location: Gold Canyon
|
Posted: Mon Jan 08, 2007 4:45 pm Post subject: |
 |
|
rgndvo wrote: |
I dont know anything really about adding objects to this board but...
If you copy and paste it into microsoft paint (comes standard on any office machine) it can be saved as a picture. Not sure if thats easier. If you figure it out though let me know cause I have some projections coming soon. |
That could be the easiest route. Then put it into photobucket and post here as a pic.
|
|
Back to top |
|
 |
EvilJuan
Veteran Presence

Joined: 10 Aug 2006
Posts: 1535
Location: Phoenix, AZ
|
Posted: Mon Jan 08, 2007 4:48 pm Post subject: |
 |
|
rgndvo wrote: |
I dont know anything really about adding objects to this board but...
If you copy and paste it into microsoft paint (comes standard on any office machine) it can be saved as a picture. Not sure if thats easier. If you figure it out though let me know cause I have some projections coming soon. |
Here's a test run of a small Excel file I have on my system from last season:

So it works, after a fashion. You'll need a place (such as ImageShack) to host the resulting file; and then post to its direct link via the [ img ] function.
_________________
Is It Next Season Yet? 
Last edited by EvilJuan on Tue Jan 09, 2007 8:57 pm; edited 1 time in total
|
|
Back to top |
|
 |
shoewizard
Hall of Famer

Joined: 10 Aug 2006
Posts: 2679
Location: In front of my computer
|
Posted: Mon Jan 08, 2007 5:13 pm Post subject: |
 |
|
screw it....too difficult, too much work. The images don't look good....come out too small to read properly.
If anyone would like to see the projections, give me your e mail via PM and I'll e mail them to you in an attachment. If you have a way to get them on the board so they look good, I will be grateful. |
|
Back to top |
|
 |
EvilJuan
Veteran Presence

Joined: 10 Aug 2006
Posts: 1535
Location: Phoenix, AZ
|
Posted: Mon Jan 08, 2007 5:27 pm Post subject: |
 |
|
shoewizard wrote: |
If anyone would like to see the projections, give me your e mail via PM and I'll e mail them to you in an attachment. If you have a way to get them on the board so they look good, I will be grateful. |
Check yer mailbox! 
_________________
Is It Next Season Yet?
|
|
Back to top |
|
 |
EvilJuan
Veteran Presence

Joined: 10 Aug 2006
Posts: 1535
Location: Phoenix, AZ
|
Posted: Mon Jan 08, 2007 5:46 pm Post subject: |
 |
|
Shoe, the projections are in the "Another 2007 D-Back Projection" thread in the "Team News" forum.
Link
_________________
Is It Next Season Yet?  |
|
Back to top |
|
 |
XB3
Journeyman
Joined: 10 Aug 2006
Posts: 278
Location: Free Scott Hairston!
|
Posted: Mon Jan 08, 2007 5:50 pm Post subject: |
 |
|
If HTML was enabled on the board, you can export Excel to HTML, then post the source. This might be something for our Admin to see if feasible or not. |
|
Back to top |
|
 |
shoewizard
Hall of Famer

Joined: 10 Aug 2006
Posts: 2679
Location: In front of my computer
|
Posted: Mon Jan 08, 2007 5:54 pm Post subject: |
 |
|
Thanks Evil Juan.
Your proficiency makes me feel secure that the board is in good hands with fantastic moderators. |
|
Back to top |
|
 |
EvilJuan
Veteran Presence

Joined: 10 Aug 2006
Posts: 1535
Location: Phoenix, AZ
|
Posted: Mon Jan 08, 2007 6:00 pm Post subject: |
 |
|
XB3 wrote: |
If HTML was enabled on the board, you can export Excel to HTML, then post the source. This might be something for our Admin to see if feasible or not. |
Thanks for the suggestion. I'll give it a try.
shoewizard wrote: |
Your proficiency makes me feel secure that the board is in good hands with fantastic moderators. |
No real proficiency -- just a wild tendency to experiment. Hey, if it doesn't blow up or crash the board, it's a success, right? But thank you for the praise, of which I am unworthy.
"We exist only to serve."
_________________
Is It Next Season Yet?
|
|
Back to top |
|
 |
Admin
Site Admin

Joined: 10 Aug 2006
Posts: 45
Location: Circling menacingly overhead...
|
Posted: Tue Jan 09, 2007 5:29 pm Post subject: |
 |
|
I've created an FTP user "bullpen", which can upload to the "files" directory here. So if you uploaded a file called "projections.xls", the address for it then would be: http://diamondbacksbullpen.org/files/projections.xls. Don't want to provide the password here, but PM me and I'll reply with it.
I'll also try and work on a nice interface anyone can use, without needing an FTP program...
_________________
Cordially,
The Management. |
|
Back to top |
|
 |
|