Experimenting with Excel

[CORSNING]

I installed Excel recently (thanks GregP for the push). I am planning to transfer
all the WW2 fighter information I have accumulated over the last several years
from my files (thanks Mike and Neil for the help) to Excel. I have started with the
P-51D. I will now attempt to see if I can transfer that information to this post for
future referencing.

AIRCRAFT P-51D-15 44-15342P-51D-15Mustang IV TK589Mustang IVFIRM / REPORTAAF: TSCEP5E-1908 Speed interceptorA&AEE: July 1944 NII VVS: 0227 rkka.esCONFIGURATIONClean: 2 wing racksClean: no wing racksClean: 2 wing racksNot knownALTITUDEMPH/FPM/TIMEMPH/FPM/TIMEMPH/FPM/TIMEMPH/FPM/TIMESea Level375 / 3600 / ***SL379 mphSL354 mph - 379 mphSL378 mph / ***3,280.84 ft. (1 Km)388 / 3600 / .91392 mph1367 mph - 393 mph1385 mph / 1.56,561.68 ft. (2 Km)403 / 3385 / 1.82407 mph2381 mph - 398 mph2405 mph / 2.19,842.52 ft. (3 Km)416 / 2985 / 2.93422 mph3395 mph -397 mph 3419 mph / 3.2513,123.36 ft. (4 Km)413 / 2534 / 4.14418 mph44434 mph / 4.4516,404.2 ft. (5Km)410 / 3200 / 5.455415 mph55428 mph / 5.719,685.04 ft. (6 Km)420 / 3100 / 6.556425 mph66426 mph / 6.9522,965.88 ft, (7 Km)432 / 2654 / 7.657437 mph77426 mph / 8.5526,246.72 ft. (8 Km)441 / 2200 / 8.88447 mph88442 mph / ***29,527.56 ft. (9 Km)431 / 1765 / 11.29437 mph99436mph / ***32,808.4 ft (10 Km)417 / 1285 / 12.7510423 mph1010430 mph / ***36,089.24 ft. (11 Km)*** / 1115 / 15.711111139,370.08 ft. (12 Km)*** / 400 / 20.8512121242,650.92 ft. (13 Km)131313Low s/c full throttle height417 mph / 3,048 mLo422 mph / 10,000 ft.Lo396 /3139.4m/10,300ftLos/c switch low to high409.5 mph / 5,121 ms/c415 mph / 16,800 ft.Lo398mph/1311m/4,300fts/cHi s/c full throttle height442 mph / 7,925 mHi448 mph / 26,000 ft.HiHi442 mph / 8,000 mLow s/c critical altitude3600 fpm / 1,463.4 mLoNo affect on climbLoLos/c switch low to high2100-3200 fpm/4878 ms/cs/cs/cHi s/c critical altitude3200 fpm / 5,792.7 mHiHiHiTURN TIMEMAX. ROLL RATECOMBAT CEILING35,000 ft. (10,668 m )ft.No or very little affectft.ft.OPERATIONAL CEILING38,700 ft. (11,795.8 m )ft.ft.ft.SERVICE CEILING41,600 ft. (12,679.7 m )ft.ft.ft.RANGE CLEANmlmlmlRANGE MAXIMUMmlmlmlARMAMENT4x0.5/270+2x0.5/4004x0.5/270+2x0.5/400WING AREA235 sq. ft.235 sq. ft.WING LOADING41.53 lb / sq. ft.40.34 lb / sq. ft.POWER LOADING5.674 lb / hp5.512 - 4.887 lb / hpW.E.P. AVAILABLE1720 LB-1505HB @ 67"hphp1720/+18 - 1940/+25hpCOMBAT WEIGHT9,760 lb ( 4,426.3 kg )lbslbs9,480 lb ( 4,299.3 kg )lbs

Wow, that didn't go as planned. Anyone have any information on how this can
be done?

 

[tomo pauk]

<delete>

 

[CORSNING]

Thanks for responding Tomo. How do you save as PDF?

 

[tomo pauk]

Thanks for responding Tomo. How do you save as PDF?

Perhaps you'd like to contach Shipachi, I can't do that on my Excel.

 

[gumbyk]

Thanks for responding Tomo. How do you save as PDF?

If you've got the latest version of Excel:
File, Save a Copy, and select PDF from the drop-down

 

[CORSNING]

Thank you for responding gumbyk. I have Excel 2013 / Office 2013.
I haven't located a 'Save a Copy' yet.

On the particular page I am trying to post there is a "Faxit PDF" button.
I pushed that and then off to the left I chose the "Create PDF". I the form
I tried to post came up on two pages (my fault). I am unable to do anything
with the two pages (at this time). I'm still working on if for a few more minutes
until bedtime though.

 

[Wurger]

Check in the Excel options at its top bar. File->Save As. The File selector should be opened. Find a line with "Save as file type" or just File Type and click the small triangle on its right. The line should be unfolded with all allowed file types for the Save option. Check if there is the PDF type. It there is , choose it and the click the Save As button below.

 

[Wurger]

Also please check if there isn't the option "Export as PDF" in the same File menu of the Excel. File -> Export as PDF.

 

[gumbyk]

Thank you for responding gumbyk. I have Excel 2013 / Office 2013.
I haven't located a 'Save a Copy' yet.

On the particular page I am trying to post there is a "Faxit PDF" button.
I pushed that and then off to the left I chose the "Create PDF". I the form
I tried to post came up on two pages (my fault). I am unable to do anything
with the two pages (at this time). I'm still working on if for a few more minutes
until bedtime though.

It might be labelled 'Save As' in 2013.

There might also be an option under hte print menu. I've got 'Microsoft Print to PDF" listed as a printer

 

[Crimea_River]

Yep. Instead of selecting your printer there should be a print to pdf option.

 

[wuzak]

I installed Excel recently (thanks GregP for the push). I am planning to transfer
all the WW2 fighter information I have accumulated over the last several years
from my files (thanks Mike and Neil for the help) to Excel. I have started with the
P-51D. I will now attempt to see if I can transfer that information to this post for
future referencing.

Wow, that didn't go as planned. Anyone have any information on how this can
be done?

You can also use the CODE function to have columns align.

Test Code      Column Number 2
It works       If you use spaces
I don't think    tabs line up consistently

 

[CORSNING]

Thanks everyone for responding. I have been able to turn the excel page into a PDF
and am able to read it on the same area as I read other PDFs. I just haven't figured
out how to 'copy / paste' it here...yet.

I'm still working on it.

 

[Wurger]

Click the "Attach files" button and then choose the PDF file in the File selector. When the file is added click the "Post replay" button. In the case all of users would be able to either download the file or open and browse it. However if you want to show a particular page of the PDF document you have to take "a pic" of the page. For that you have to open your PDF file with the Adobe Reader or another soft for readin/edition of the PDF documents. In the Edit menu at the top bar, you will find the icon of camera. Click that and then mark the area ( page ) for copying. The pic is taken automatically and copied to the clipboard. Then you have to open a pic editor eg the IrfanView and paste the clipboard content to the pic editor. The next step is to save the pic as a file of JPG type or another, eg. GiF, PNG etc.
The Adobe Reader allows to copy a page without using the camera option. Just click the page you want to copy with the left mouse button in order to mark it and then click with the right mouse button to get the popup menu with the Copy option. The next steps like above for the IrfanView and Clipboard content.

 

[CORSNING]

Thank you for the added help Wojtek.

Is everyone able to open and see the posting?

 

[tomo pauk]

It works

 

[CORSNING]

Thank you for the feedback Tomo.
It took me several years to put my files together. It is finally time to put
all that information on excel where it will now be easily accessible for
posting, thanks to all of you.

You are the man, Wurger.

 

[Wurger]

My pleasure.

I have downloaded the file on my HDD and opened with the AR. No trouble. Also I opened it directly from the post without any problem. So both ways of accessing work.

 

[gumbyk]

Thank you for the feedback Tomo.
It took me several years to put my files together. It is finally time to put
all that information on excel where it will now be easily accessible for
posting, thanks to all of you.

You are the man, Wurger.

You could always just attach the excel files.

 

[Wurger]

Also true. But there may be a trouble with opening of the file if there is no the Mickeysoft Office installed. Also saving with the newer Excell may cause a problem for the older programs because of the different file extension. So the PDF form is let's say quite universal.

 

[CORSNING]

Here goes gumbyk:

Yes, I was able to view it just as entered into excel.

For all those interested, the first column is somewhat self explanatory and the
testing can be viewed on wwiiaircraftperformance.org.
The second column shows the maximum speeds of the same aircraft without
the wing pylons.
The third column is testing of the Mustang IV at higher boosting by the A&AEE.
The forth column is the results of the Soviet testing which I have not finished
filling out yet.