| kemosabe |
Background: this is in response to a user who wanted to post their Pilot gas mileage data that they had in a Microsoft Excel spreadsheet into this forum.....
Bring up your spreadsheet in MS Excel. In my case here, I am using Tom Clancy books as my example... |
|
|
| kemosabe |
Save your spreadsheet as a web page by choosing the File --> Save As... menu option.
I'm calling mine (duh!) clancy.htm |
|
|
| kemosabe |
| Use Wordpad or Notepad to bring up your newly created web page file (in my example, clancy.htm) and search for the line that says "border=0" and change it to read "border=1". Save the change!! |
|
|
| kemosabe |
| Highlight everything starting from the HTML tag that starts with "<"table x:str border=1 until... |
|
|
| kemosabe |
| ...the last html table tag near the bottom of the document. Then click on the "Copy" button (or choose the Edit --> Copy menu item). |
|
|
| kemosabe |
| Paste your selected text into your post. Using the keyboard combo of Ctrl-V will work nicely... |
|
|
| kemosabe |
And when all is said and done, you should have somewhat of a table... (don't know why there is so much space before the table shows up!!! :3: :3: )
1984 |
The Hunt for Red October |
1986 |
Red Storm Rising |
1987 |
Patriot Games |
1988 |
The Cardinal of the Kremlin |
1989 |
Clear and Present Danger |
1991 |
The Sum of All Fears |
1993 |
Without Remorse |
1994 |
Debt of Honor |
1996 |
Executive Orders |
1998 |
Rainbow Six |
2000 |
The Bear and the Dragon |
2002 |
Red Rabbit |
|
|
|
|
|
| kemosabe |
| Also, be sure that HTML code is turned ON for the thread you're posting to!!!!! :4: :17: |
|
|
| florida_guy |
Oh mighty graphics master :6:
What do you use to capture your screen shots? |
|
|
| kemosabe |
quote:
Originally posted by florida_guy
Oh mighty graphics master :6:
What do you use to capture your screen shots?
I take my Nikon 35mm camera and aim it at my 19" computer monitor. When I have used up all 36 shots on the roll, I take the film to Wal-Mart and in 3 days, I go pick it up. I then scan the 4"x6" pictures in.....
Just kidding... I used a package called Paint Shop Pro to do the screen captures... it works pretty well. ;) |
|
|
| havasu |
quote:
Originally posted by kemosabe
And when all is said and done, you should have somewhat of a table... (don't know why there is so much space before the table shows up!!! :3: :3: )
All the space is because a break (new line) is inserted for each new line in the post.
To fix this, you can edit your html (before posting is easier) to remove the newlines.
I have to do this in the VIN table thread or there would be over 300 blank lines!! Thanks to admin for pointing this out to me. |
|
|
| kemosabe |
Well, I'll be... thanks, havasu!!! Who would've thunk it was the newlines, huh???
Thanks!!! :29:
| 1984 | The Hunt for Red October | | 1986 | Red Storm Rising | | 1987 | Patriot Games | | 1988 | The Cardinal of the Kremlin | | 1989 | Clear and Present Danger | | 1991 | The Sum of All Fears | | 1993 | Without Remorse | | 1994 | Debt of Honor | | 1996 | Executive Orders | | 1998 | Rainbow Six | | 2000 | The Bear and the Dragon | | 2002 | Red Rabbit | | |
|
|
|
| florida_guy |
quote:
Originally posted by kemosabe
I take my Nikon 35mm camera and aim it at my 19" computer monitor. When I have used up all 36 shots on the roll, I take the film to Wal-Mart and in 3 days, I go pick it up. I then scan the 4"x6" pictures in.....
Just kidding... I used a package called Paint Shop Pro to do the screen captures... it works pretty well. ;)
You had me going until you talked about the "roll" of film. :eek:
I used to use the shareware version of PaintShop. Still installed on here somewhere. Didn't know it could do that. Thanks for the info. |
|
|
| kemosabe |
| If you're using the shareware version of PSP (ver. 4.12), then go to the Capture menu to setup and start your screen captures... |
|
|
| florida_guy |
quote:
Originally posted by kemosabe
If you're using the shareware version of PSP (ver. 4.12), then go to the Capture menu to setup and start your screen captures...
Just did a search. I have 4.14 zipped up but not installed. Thanks for the info. |
|
|
| Ferdball |
quote:
Originally posted by kemosabe
Background: this is in response to a user who wanted to post their Pilot gas mileage data that they had in a Microsoft Excel spreadsheet into this forum.....
I think that was me. I'll try it out. Thanks. |
|
|
| Ferdball |
Date |
Sale |
Price |
Gallons |
Octane |
Odo |
Miles |
MPG |
MP$ |
|
8/10/2002 |
? |
? |
15.00 |
? |
|
|
|
|
|
8/17/2002 |
$25.29 |
$1.699 |
|
x:fmla="=SUM(B3/C3)">14.89
89 |
280 |
|
|
|
|
8/22/2002 |
$27.54 |
$1.799 |
|
x:fmla="=SUM(B4/C4)">15.31
89 |
563 |
283 |
|
x:fmla="=SUM(G4/D3)">19.01
|
|
8/26/2002 |
$28.90 |
$1.759 |
|
x:fmla="=SUM(B5/C5)">16.43
89 |
843.5 |
280.5 |
|
x:fmla="=SUM(G5/D4)">18.32
|
x:fmla="=SUM(G5/B4)">10.19
|
9/2/2002 |
$31.38 |
$1.899 |
|
x:fmla="=SUM(B6/C6)">16.52
91 |
1115 |
271.4 |
|
x:fmla="=SUM(G6/D5)">16.52
|
x:fmla="=SUM(G6/B5)">9.39
|
9/8/2002 |
$28.56 |
$1.839 |
|
x:fmla="=SUM(B7/C7)">15.53
91 |
1377 |
261.8 |
|
x:fmla="=SUM(G7/D6)">15.84
|
x:fmla="=SUM(G7/B6)">8.34
|
9/15/2002 |
$28.68 |
$1.759 |
16.31 |
89 |
1635 |
257.9 |
16.61 |
|
x:fmla="=SUM(G8/B7)">9.03
|
9/21/2002 |
$26.78 |
$1.639 |
16.34 |
89 |
1921 |
286.8 |
|
x:fmla="=SUM(G9/D8)">17.58
10.00 |
Shell |
9/30/2002 |
$26.34 |
$1.679 |
15.69 |
89 |
2167 |
246 |
|
x:fmla="=SUM(G10/D9)">15.05
|
x:fmla="=SUM(G10/B9)">9.19
Shell |
10/6/2002 |
$27.23 |
$1.739 |
15.66 |
89 |
2423 |
256 |
|
x:fmla="=SUM(G11/D10)">16.32
|
x:fmla="=SUM(G11/B10)">9.72
Unocal 76 |
10/17/2002 |
$28.85 |
$1.769 |
16.31 |
89 |
2684 |
260.1 |
|
x:fmla="=SUM(G12/D11)">16.61
|
x:fmla="=SUM(G12/B11)">9.55
Shell |
10/25/2002 |
$28.48 |
$1.739 |
16.38 |
89 |
2949 |
265.9 |
|
x:fmla="=SUM(G13/D12)">16.30
|
x:fmla="=SUM(G13/B12)">9.22
Unocal 76 |
11/1/2002 |
$26.66 |
$1.689 |
15.78 |
89 |
3214 |
264.6 |
|
x:fmla="=SUM(G14/D13)">16.16
|
x:fmla="=SUM(G14/B13)">9.29
Shell |
11/6/2002 |
$29.27 |
$1.839 |
15.92 |
89 |
3490 |
275.9 |
|
x:fmla="=SUM(G15/D14)">17.48
|
x:fmla="=SUM(G15/B14)">10.35
Unocal 76 |
11/11/2002 |
$25.73 |
$1.719 |
14.97 |
89 |
3751 |
260.7 |
|
x:fmla="=SUM(G16/D15)">16.38
|
x:fmla="=SUM(G16/B15)">8.91
Shell |
11/22/2002 |
$27.19 |
$1.699 |
16.01 |
89 |
3997 |
246.3 |
|
x:fmla="=SUM(G17/D16)">16.45
|
x:fmla="=SUM(G17/B16)">9.57
Shell |
12/2/2002 |
$27.34 |
$1.699 |
16.09 |
89 |
4255 |
258.4 |
|
x:fmla="=SUM(G18/D17)">16.14
|
x:fmla="=SUM(G18/B17)">9.50
Shell |
12/9/2002 |
$26.71 |
$1.679 |
15.91 |
89 |
4521 |
265.2 |
|
x:fmla="=SUM(G19/D18)">16.48
|
x:fmla="=SUM(G19/B18)">9.70
Shell |
1/3/2003 |
$25.83 |
$1.599 |
16.15 |
87 |
4759 |
238.4 |
|
x:fmla="=SUM(G20/D19)">14.99
|
x:fmla="=SUM(G20/B19)">8.93
Shell |
1/12/2003 |
$25.31 |
$1.599 |
15.83 |
87 |
5016 |
257.5 |
|
x:fmla="=SUM(G21/D20)">15.94
|
x:fmla="=SUM(G21/B20)">9.97
Shell |
1/24/2003 |
$26.37 |
$1.579 |
16.70 |
87 |
5271 |
|
x:fmla="=SUM(F22-F21)">254.7
|
x:fmla="=SUM(G22/D21)">16.09
|
x:fmla="=SUM(G22/B21)">10.06
Shell |
2/6/2003 |
$29.23 |
$1.799 |
16.25 |
87 |
5485 |
213.5 |
|
x:fmla="=SUM(G23/D22)">12.79
|
x:fmla="=SUM(G23/B22)">8.10
Ultramar |
2/15/2003 |
$30.67 |
$1.859 |
16.50 |
87 |
5729 |
|
x:fmla="=SUM(F24-F23)">244.3
|
x:fmla="=SUM(G24/D23)">15.04
|
x:fmla="=SUM(G24/B23)">8.36
Shell |
2/23/2003 |
$31.19 |
$1.919 |
16.25 |
87 |
5980 |
251.3 |
|
x:fmla="=SUM(G25/D24)">15.23
|
x:fmla="=SUM(G25/B24)">8.19
Shell |
3/6/2003 |
$31.54 |
$2.029 |
15.55 |
87 |
6243 |
262.6 |
|
x:fmla="=SUM(G26/D25)">16.16
|
x:fmla="=SUM(G26/B25)">8.42
Shell |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Ferdball |
quote:
Originally posted by havasu
you can edit your html (before posting is easier) to remove the newlines.
Eh? All I see is a bunch of td and tr tags. Which ones should I nix? |
|
|
| havasu |
quote:
Originally posted by Ferdball
Eh? All I see is a bunch of td and tr tags. Which ones should I nix?
You essentially have to make all the html one line, with no newlines in there. Many text editors allow you to do this, depends on your editor. |
|
|
| florida_guy |
quote:
Originally posted by havasu
You essentially have to make all the html one line, with no newlines in there. Many text editors allow you to do this, depends on your editor.
Just a clarification...
The
new
lines
are
invisible.
But there is one at the end of each of the words in that last sentence. |
|
|
| kemosabe |
Ferdball, I took the liberty of stripping the newlines out of your html code for you... (please double check the table to make sure it looks right)
| Date | Sale | Price | Gallons | Octane | Odo | Miles | MPG | MP$ | | | 8/10/2002 | ? | ? | 15.00 | ? | | | | | | | 8/17/2002 | $25.29 | $1.699 | 14.89 | 89 | 280 | | | | | | 8/22/2002 | $27.54 | $1.799 | 15.31 | 89 | 563 | 283 | 19.01 | | | | 8/26/2002 | $28.90 | $1.759 | 16.43 | 89 | 843.5 | 280.5 | 18.32 | 10.19 | | | 9/2/2002 | $31.38 | $1.899 | 16.52 | 91 | 1115 | 271.4 | 16.52 | 9.39 | | | 9/8/2002 | $28.56 | $1.839 | 15.53 | 91 | 1377 | 261.8 | 15.84 | 8.34 | | | 9/15/2002 | $28.68 | $1.759 | 16.31 | 89 | 1635 | 257.9 | 16.61 | 9.03 | | | 9/21/2002 | $26.78 | $1.639 | 16.34 | 89 | 1921 | 286.8 | 17.58 | 10.00 | Shell | | 9/30/2002 | $26.34 | $1.679 | 15.69 | 89 | 2167 | 246 | 15.05 | 9.19 | Shell | | 10/6/2002 | $27.23 | $1.739 | 15.66 | 89 | 2423 | 256 | 16.32 | 9.72 | Unocal 76 | | 10/17/2002 | $28.85 | $1.769 | 16.31 | 89 | 2684 | 260.1 | 16.61 | 9.55 | Shell | | 10/25/2002 | $28.48 | $1.739 | 16.38 | 89 | 2949 | 265.9 | 16.30 | 9.22 | Unocal 76 | | 11/1/2002 | $26.66 | $1.689 | 15.78 | 89 | 3214 | 264.6 | 16.16 | 9.29 | Shell | | 11/6/2002 | $29.27 | $1.839 | 15.92 | 89 | 3490 | 275.9 | 17.48 | 10.35 | Unocal 76 | | 11/11/2002 | $25.73 | $1.719 | 14.97 | 89 | 3751 | 260.7 | 16.38 | 8.91 | Shell | | 11/22/2002 | $27.19 | $1.699 | 16.01 | 89 | 3997 | 246.3 | 16.45 | 9.57 | Shell | | 12/2/2002 | $27.34 | $1.699 | 16.09 | 89 | 4255 | 258.4 | 16.14 | 9.50 | Shell | | 12/9/2002 | $26.71 | $1.679 | 15.91 | 89 | 4521 | 265.2 | 16.48 | 9.70 | Shell | | 1/3/2003 | $25.83 | $1.599 | 16.15 | 87 | 4759 | 238.4 | 14.99 | 8.93 | Shell | | 1/12/2003 | $25.31 | $1.599 | 15.83 | 87 | 5016 | 257.5 | 15.94 | 9.97 | Shell | | 1/24/2003 | $26.37 | $1.579 | 16.70 | 87 | 5271 | 254.7 | 16.09 | 10.06 | Shell | | 2/6/2003 | $29.23 | $1.799 | 16.25 | 87 | 5485 | 213.5 | 12.79 | 8.10 | Ultramar | | 2/15/2003 | $30.67 | $1.859 | 16.50 | 87 | 5729 | 244.3 | 15.04 | 8.36 | Shell | | 2/23/2003 | $31.19 | $1.919 | 16.25 | 87 | 5980 | 251.3 | 15.23 | 8.19 | Shell | | 3/6/2003 | $31.54 | $2.029 | 15.55 | 87 | 6243 | 262.6 | 16.16 | 8.42 | Shell | | | | | | | | | | | |
|
|
| kemosabe |
quote:
Originally posted by Ferdball
I think that was me. I'll try it out. Thanks.
Ferdball: yes, you were the intended audience. I had made a mental note to myself to figure it out for you and I finally found some time this weekend to experiment with it... |
|
|
| N_Jay |
| Why not just cut and paste into MS Paint, and save as a .jpg? |
|
|
| Ferdball |
quote:
Originally posted by kemosabe
Ferdball, I took the liberty of stripping the newlines out of your html code for you... (please double check the table to make sure it looks right)
Thanks, it looks good. I don't see much difference in the code though. Did you strip out random carriage returns? The code looks the same. |
|
|
| kemosabe |
| Ferdball: no, I didn't strip out random carriage returns -- I stripped out ALL of the carriage returns!!. Suppose your html code looked like this image: |
|
|
| kemosabe |
| ...I then joined all of the separate lines into ONE big long one like this: |
|
|
| florida_guy |
quote:
Originally posted by kemosabe
Ferdball: no, I didn't strip out random carriage returns -- I stripped out ALL of the carriage returns!!. Suppose your html code looked like this image:
My name in Wordpad?! Why I never thought I'd see the day. :awais: |
|
|
| kemosabe |
quote:
Originally posted by florida_guy
Oh mighty graphics master :6:
What do you use to capture your screen shots?
Another tried and true method to capture screen shots, florida_guy...... |
|
|
| florida_guy |
quote:
Originally posted by kemosabe
Another tried and true method to capture screen shots, florida_guy......
And so convenient too! :D |
|
|
| ramirami |
quote:
Originally posted by kemosabe
Another tried and true method to capture screen shots, florida_guy......
oh so thats how its done...I always thought you used a sketch artist:2: |
|
|
| Ferdball |
quote:
Originally posted by kemosabe
Another tried and true method to capture screen shots, florida_guy......
I always thought that was the blonde way of printing. :) |
|
|
| Sage |
quote:
Originally posted by Ferdball
I always thought that was the blonde way of printing. :)
It... isn't????? :( |
|
|
| florida_guy |
quote:
Originally posted by kemosabe
Another tried and true method to capture screen shots, florida_guy......
Ever see on one of those "Captured on camera shows." A woman (possibly a blond) has to work overtime to post an Excel spreadsheet and instead she goes into the copy room, lifts her skirt, sits on the copy machine, and presses start. Not knowing there is a camera recording the whole thing? :D |
|
|
| Sage |
quote:
Originally posted by florida_guy
Ever see on one of those "Captured on camera shows." A woman (possibly a blond) has to work overtime to post an Excel spreadsheet and instead she goes into the copy room, lifts her skirt, sits on the copy machine, and presses start. Not knowing there is a camera recording the whole thing? :D
YES! Saw that! She could've been blonde - I doubt it though. She woulda pressed start BEFORE she sat down if she was!
WEEEE! :2: |
|
|
|
