Jim Perry-Tony Woods Luftwaffe Air Combat Claims List?
 

My understanding is that Jim Perry is filling in records gaps in Tony Woods Luftwaffe Air Combat Claims List and that this is a ONGOING project –any word on how close this is to completion?

http://www.lesbutler.ip3.co.uk/tony/tonywood.htm

I’m not proficient with Excel (a spreadsheet program) at all –how might this be useful to a researcher?

How up to date are my versions?

25 Dec 2004 my last download of Tony Woods text/word processing version –a great Xmas present IMHO!

23 Oct 06 my last download of Jim Perry’s Excell Spreadsheet Version 25 Dec 2004 –a great Xmas present IMHO!

Thanks,

Rob Romero

Re: Jim Perry-Tony Woods Luftwaffe Air Combat Claims List?
 

Rob:

Excel lets you search, sort, summarise etc very quickly and easily. So, if you want totals or subtotals, or targeted lists of, for example, how many of which type of aircraft were claimed by which Luftwaffe units between which dates, Excel is the way to go.

Re: Jim Perry-Tony Woods Luftwaffe Air Combat Claims List?
 

Re: Jim Perry-Tony Woods Luftwaffe Air Combat Claims List?
 

Off-topic. Although I am not a spreadsheet expert, I found that MS Access is much better in sorting such kind of extensive data than Excel.

Re: Jim Perry-Tony Woods Luftwaffe Air Combat Claims List?
 

Have actually just finished a major re-edit and combining of my lists. Suppose I should send it on to Les Butler. Please note that my 'filling in the gaps' above Tony's transcription of the files he's found is based primarily on recent published sources - I certainly have no 'secret' stash or knowledge. (Of cousre if anyone has information or corrections to contribute, they will be greatly received and acknowlegded.)

BTW, how many rows does Excel allow? I use MS Access and the single combined file now has 70K+ records. It just occurred to me that this may be a problem for Excel.

Re: Jim Perry-Tony Woods Luftwaffe Air Combat Claims List?
 

Jim,
I have Office 2000 on my PC, and a check in Excel shows that it has a limit of 65,536 rows. Access, which I have used for close to 15 years (I may still have the discs for Access 1.1 here somewhere) can go over one million (1,000,000). I much prefer Access to Excel for these databases, since the relational aspects will allow much more consistent construction.

I am not sure about the limits on Excel 2003, it may be the same. Excel 2007 may have increased the number of rows.

Further checking on line turned up the following website: http://blogs.msdn.com/excel/archive/...26/474258.aspx

For Excel 2007 (Excel 12) the number of columns was increased from 256 (2^8) to 16K (2^14). The number of rows was increased from 64k (2^16) to 1m (2^20). I would hope that the number of columns in Access was increased also, otherwise you can't import these new Excel files. Well, another check shows that Access has stayed at 256 columns. I really wonder how much support Access has within Microsoft.

Frank.

Re: Jim Perry-Tony Woods Luftwaffe Air Combat Claims List?
 

Jim, I'm using the files you sent to Les and Tony some time (years?) ago and converted them to Excel, as I have not Acces at home. There were allready too many claims to have them on a single sheet, but by dividing them into Western and Eastern claims (as you did in files) Excel is able to use them.

I have currently no more home Internet connexion since more than one month, and still many difficulties to come over to come back fully to the Net community (I'm surfing right now from a public library), but I have noted kept the track of all corrections I did in the file (usually names written in different ways from one record to another, but also some first names missing, completed using for example the last JG 4 and JG 300 books by Monbeek and Laurant respectively). As soon as possible I will send you them, in case you didn't correct them already.

I will be immensely interested in your updated files, especially if you fill in the gap in Eastern claims between October 1941 and July 1942.

Best regards

Laurent

Re: Jim Perry-Tony Woods Luftwaffe Air Combat Claims List?
 

Hi Jim,

What new additions/corrections have you added to your files? Are they taken from Prien's Die Jagdfliegerverbände der Deutschen Luftwaffe: Teil 9/I-III.

I also use Access, I too find the sorting and filtering far better than Excel.

Best Regards

Andy Fletcher

Re: Jim Perry-Tony Woods Luftwaffe Air Combat Claims List?
 

Most updates from Prien, Barbas and Lorant and a few other odds and ends.

Re: Jim Perry-Tony Woods Luftwaffe Air Combat Claims List?
 

http://www.coolutils.com/TotalExcelConverter
Cost $39.90

Also try
www.bolton.ac.uk/education/educat/courses/ITT/resources/ICT/data_transfer_example.pdf
http://www.tethyssolutions.com/T72.htm


Kind regards

Ross

Re: Jim Perry-Tony Woods Luftwaffe Air Combat Claims List?
 

Hi !

A possible way to convert an excel into a word file :
Save the excel file in hmtl format. This format can also be opened by word.

If you don't have excel the applications Open Office can be a solution. They can be downloaded (free of charge ) via http://www.openoffice.org/

Looking forward to receive your feedback !

Best regards from rainy Belgium

Luc

Re: Jim Perry-Tony Woods Luftwaffe Air Combat Claims List?
 

I'm not a Microsoft user but is there a "save as" option for tab-delimited text?

That is sometimes offered in spreadsheets - you wind up with all the data in the right rows/columns but no longer in actual cells.

Re: Jim Perry-Tony Woods Luftwaffe Air Combat Claims List?
 

Excellent, look forward to the latest update.

Cheers

Andy Fletcher

Re: Jim Perry-Tony Woods Luftwaffe Air Combat Claims List?
 

Jim, please let us know when you’re ready to update! What a dept of gratitude we ALL owe to the likes of you, Ruy, Tony, and Ed West.

My best wishes,

Rob Romero

Re: Jim Perry-Tony Woods Luftwaffe Air Combat Claims List?
 

I have to say I'm rather amused - after converting Tony's original Word docs to Access to make the data easier to work with, someone is now asking how to convert back to Word!!! There were a couple of workable suggestions from Nick and Luc. Another possible idea - Word Mail Merge. I have used this to take data and print out as loss lists that look more like something you might see in a published source. Mail Merge can take data from different sources such as Excel or a delimited text file. If you can save the output to a doc file versus printing it - and I haven't looked to see if it can actually be done that way. You also can copy and paste Excel data into a Word doc. Looks like a table - but 72+ K records might be a daunting task....

Re: Jim Perry-Tony Woods Luftwaffe Air Combat Claims List?
 

Jim, I saw that some new files in Tony's site that I haven't seen before are there listed as from film. Has the updates been added? Also will the info from Dr. Prien's "jagdfliegereverbande" be added?

Best Regards,
Nokose

Re: Jim Perry-Tony Woods Luftwaffe Air Combat Claims List?
 

New file has been sent to Mr. Butler.

Re: Jim Perry-Tony Woods Luftwaffe Air Combat Claims List?
 

Rob,

I think I can help you with your projects as I am listing all of the Luftwaffe's aerial victories that I can find on an excel spreadsheet and have over 61,000 listed so far.
Please email me off board. Nicklhector@hotmail.com

Nick