No. of Recommendations: 0
I would like to post a spreadsheet from Excel.

I just need the numbers to come in lined up properly. It doesn't seem to work well even with or without the "Table Data" button clicked.

See what I mean:

		1	2	3	4	5	6	
Year	2005	2006	2007	2008	2009	2010	2011	Total
# Restaurants Built	7	25	30	35	40	60	0	197
# Accumulated	0	7	32	62	97	137	197	
Franchise Revenue	 $-   	 $25,480 	 $116,480 	 $225,680 	 $353,080 	 $498,680 	 $717,080 	
DAVE Revenue	 $-   	 $1,274 	 $5,824 	 $11,284 	 $17,654 	 $24,934 	 $35,854 	
DAVE Profit	 $-   	 $1,083 	 $4,950 	 $9,591 	 $15,006 	 $21,194 	 $30,476 	
DAVE EPS		 $0.10 	 $0.45 	 $0.88 	 $1.38 	 $1.94 	 $2.79 	
Discount Factor		0.8696	0.7561	0.6575	0.5718	0.4972	0.4323	
Dicounted DAVE Profit		 $942 	 $3,743 	 $6,307 	 $8,580 	 $10,537 	 $13,176 	 $43,284 
Per Share		 $0.09 	 $0.34 	 $0.58 	 $0.79 	 $0.97 	 $1.21 	 $3.97 
Print the post Back To Top
No. of Recommendations: 0
I think you'll have to do it by hand--go into the spreadsheet you're posting and backspace, etc. where the columns are out of alignment. That's what I've been doing. Unfortunately, it takes forever if you have alot of data. Maybe someone else knows another technique.
Print the post Back To Top
No. of Recommendations: 0
Thanks.

I got it figured out. Wow, there should be a better way.

Rich
Print the post Back To Top
No. of Recommendations: 1
Have you tried putting
< PRE > in front of pasted spreadsheet and
< / pre > (without the spaces) after the spreadsheet?

Bob
Print the post Back To Top
No. of Recommendations: 0
Yes, I did and it work great.

Thank you

Rich
Print the post Back To Top
No. of Recommendations: 0
In Excel if you choose File/save As and change to something like "Formatted Text/Space Delimited" you will get a "filename.prn" file. Even though the extension is .prn it is really a .txt file that you can open in a text editor and it will be formatted properly for copying into TMF.

Make sure your columns are wide enough before you save.
Print the post Back To Top
No. of Recommendations: 0
BTW there is a "Spreadsheet Advice" board here:
http://boards.fool.com/Messages.asp?bid=100002
Print the post Back To Top