Help getting the planes and weapons DBs in a readable form

[MSO Bob]

Hello All, 

I am just getting back into Harpoon after a few years. I have the HUD3 and ANW versions and I am trying to put together a Time over Target spreadsheet. I have the very basics now for just a few planes and weapons but I would like to get the planes and weapons databases into a spreadsheet. I need speed info on the aircraft and weapons (harpoons, tomahawk, etc) to work the numbers. It looks like it will take some tweaking but so far I can get close. Way back I had edited the Ship DB adding the MSO, MCM, and MHC. But that was maybe 20 years ago. Can anybody give me a hand with this? Thanks in Advance!

Bob Cashman

[MSO Bob]

Sorry,

I wanted to add that I'm using windows 10, and have Office 365. I can work with Excel and Access. I have no intention of editing or altering the DBs, I would just like to have a copy of the 2 databases so I can try to make a workable ToT spreadsheet. Typing the data in one at a time is a little more than I'm up for. Thanks again.

Bob

[TonyE]

Hi Bob, you have the tools and the game comes with the database editor so what you want should be within your reach.  You mention HUD3, is that the database from which you want the information?

Perhaps more precisely, what database and version of that database are you interested in so that we can either just do the export for you or write up instructions for you to do it yourself?

You'll see for instance that we have no less than three versions of HUD3 here at https://harpgamer.com/harpforum/files/category/4-databases/

[TonyE]

Hmm, and your tags say HUD4 so we definitely need clarification on which DB and version thereof.

[MSO Bob]

Thanks Tony,

I have 2 different databases. The HUD 3 game  1.3.21, and the HUD 3 ANW shows HUD 3 1.5.0.  There are other options, but these are the 2 I have been using. For what I want it for I don't know that there would be a major difference in aircraft or missile or speeds, and since I'm still rusty concerning the databases I don't know if i'm ready to do any updates yet. Either directions or the export will work. I do know that there was a comment in the text file about the editor not working with windows 10. I guess I'm just a bit hesitant with trying to use it.

Thanks Again,

Bob

So you have a better idea of what I need, its the item(plane, weapon), and the text info. I can pull it up one at a time or I could get the database info.  

Edited April 13, 2019 by MSO Bob
Adding a comment and pics

[TonyE]

Bob, try the attached on for size.  It doesn't separate out the altitude bands, holler if you need that.  Once we get to a useable output I can run it for more databases or just send you the modified database editor.

 

HUD3_1.5.0_AircraftLoadoutRanges_20190416a.zip

[MSO Bob]

Tony,

Thanks. This is a great start and I appreciate it I can build from this file. What I really need is the aircraft speeds, or I believe the performance factors. The basic calculation for the ToT is distance to tgt divided by speed equals time. There are other factors that have to be added to get really close but I just need to know how long it will take each plane or missile to get from point a to point be so launch time from mission start can be calculated. The text boxes show that in the performance info. I have the DB editor but for some reason there was no text showing up in the boxes. Most likely I'm doing something wrong. I'm not clear as to the column labelled cruise factor as well. So if you can tell me how to get to the text that shows up in the large box on the in game database I think it would solve the problem.  Thanks again for all your help.

Bob

[TonyE]

Bob, I'm not sure when I'll get a better output for you.  I have put some more time in but don't have much to devote to this request.  

[MSO Bob]

No problem. If you get to it, great, otherwise I'll pick and choose what I need for now. I can start on the basics and build from there. Thanks for all your help.