Unofficial EDBTR Database Editor Re-release

[ian66]

Hello, thanks again for this it looks great thought I haven't spend much time on it yet, looks like I should be able to modify the main thing that always bugged me, JG3XX's never upgrading! Excuse me if I missing something obvious but on the aircraft sheet I can't see anywhere to change the engine assigned to it? I would like to change/add some aircraft but I can't without giving them an engine, is this possible?

[K 19]

ORIGINAL: ian66

Hello, thanks again for this it looks great thought I haven't spend much time on it yet, looks like I should be able to modify the main thing that always bugged me, JG3XX's never upgrading! Excuse me if I missing something obvious but on the aircraft sheet I can't see anywhere to change the engine assigned to it? I would like to change/add some aircraft but I can't without giving them an engine, is this possible?

Hello. Aircraft frames, engines, etc are located under the 'Devices' tab. Just simply assign the correct part to the correct aircraft ID number. And don't forget to select the 'Unfreeze Tabs' option at top so you can scroll the screen around.

And you cannot add new aircraft slots under the 'Aircraft' tab. You should only replace (overwrite) existing ones with new ones. Adding new aircraft slots causes game crashes. According to Creeper, only aircraft slots 1-200 are dedicated to Axis aircraft in Campaigns '43 and '44. But replacing (overwriting) the unused Allied Pacific theatre aircraft with new Allied European theatre aircraft should work.

[ian66]

Hi, thanks again, I found it in devices, not sure about the "unfreeze tabs" bit? I found the "unfreeze panes", is this the same thing or another option? Sorry I'm not used to excel but I really want to play with this editor. Also can the "swap drop tanks for bombs" and "add rockets", "add extra cannons" be modified? I think it would be useful to use this on RAF aircraft as well as German and American.

[Creeper]

The editor is programmed for a high screen resolution.
I'm using 1920x1080 screen mode; all data are visible for me.
If you have problems to see some data, try to set the zoom to 90% or lower.

Regarding 'add extra cannon' etc... yes, it's possible to modify this.
Look at the aircraft editor 'tab'.
There are two columns; 'normal version' and 'extra version'.
The extra version column is where you can change the aircraft, which
you want to be the 'extra cannon version'.

Aargh, I'm so bad in explanations...

In short words... copy the whole aircraft data (normal version) row to a new and empty slot.
There you can add the cannons and droptanks you want to use.
Then add this slot id to the column 'extra version' of the 'normal version' aircraft column.
The 'normal version' column of the modified aircraft should point to the aircraft, you've copied.

On more thing... if you can't copy a whole row, press ALT+F11, now the macro editor window should appear.
There you can press the 'pause key'. Now you are able to copy and paste whole rows and columns.
But you must 'unpause' the macros, to save all changes you've made in the editor.

[Misconduct]

I am curious, I tried to add the P-51B to the Allies and set for 7/43 - its not adding in game, the idea I wanted was to copy the game twice, once for allies and one axis and give the opposite planesets an earlier entrance.
I mostly play the AI so I was hoping to have the AI getting a few different planesets early would make it a little more interesting.

[TaggedYa]

Your first problem is that the P51b is a starting aircraft. That is, no unit is ever set to upgrade to it. Thus the AI will never use it. It is introduced into the game by bringing in new units that use it. Also, you will need to change the replacement schedule to add some in earlier than normal.

There is not anything that you could call an AI in the game. The effect of one is simulated by complex interactions in the unit tables, the plane tables, and the pilot tables. If you go changing things you need to go slow and learn how it all works together. Else you break things big time. I am waiting for the first p40 to show up in a game carrying 12,000 lb bombs and flying at night because someone stuck it in a Lancaster special load slot.

[Turner]

ORIGINAL: Creeper

Regarding 'add extra cannon' etc... yes, it's possible to modify this.
Look at the aircraft editor 'tab'.
There are two columns; 'normal version' and 'extra version'.
The extra version column is where you can change the aircraft, which
you want to be the 'extra cannon version'.

Aargh, I'm so bad in explanations...

In short words... copy the whole aircraft data (normal version) row to a new and empty slot.
There you can add the cannons and droptanks you want to use.
Then add this slot id to the column 'extra version' of the 'normal version' aircraft column.
The 'normal version' column of the modified aircraft should point to the aircraft, you've copied.

On more thing... if you can't copy a whole row, press ALT+F11, now the macro editor window should appear.
There you can press the 'pause key'. Now you are able to copy and paste whole rows and columns.
But you must 'unpause' the macros, to save all changes you've made in the editor.

Tried this some time ago but was not succesful in implementing it. Will test it again until I get it to work. I believe there is some issue with the requirement of there being more guns on the extra cannon version and not just different, heavier guns. The problem I had was the FW190A, the standard version having 4x20 mm cannons and the /R2 version having 2 x MG151/20 and in the outboard station MK108s, so the number of weapons was the same which seems to be what caused the problem.

Need to do some more testing.

The above issue (I did not verify it yet, it could have been because of date/availability) would explain the use of the /R1 on the Anton, instead of the historically more commonly used /R2 option.

[Misconduct]

ORIGINAL: TaggedYa

Your first problem is that the P51b is a starting aircraft. That is, no unit is ever set to upgrade to it. Thus the AI will never use it. It is introduced into the game by bringing in new units that use it. Also, you will need to change the replacement schedule to add some in earlier than normal.

There is not anything that you could call an AI in the game. The effect of one is simulated by complex interactions in the unit tables, the plane tables, and the pilot tables. If you go changing things you need to go slow and learn how it all works together. Else you break things big time. I am waiting for the first p40 to show up in a game carrying 12,000 lb bombs and flying at night because someone stuck it in a Lancaster special load slot.

I completely understand, i've had this game for YEARS and wanted to tinker with the database. What I don't understand is so many american units switched from P38s to P47s or P47s to P38s or P51s. Historically speaking, my idea was to give a more dynamite approach for the allies and luftwaffe in terms of upgrades.

And I know all about the Lancaster special load slot, I made a mistake and had Beaufighters with 4,000lb eggs in WITPAE, a small taboo that costed me a 6 month PBEM when we realized I broken the database.

/what happen was rubaul got hit at night, half his fleet got sunk by mega bombs.

[JeffroK]

+1 for the AFB, can I get that mod!!

[jakla1027]

Can someone do a walk through of how to use the editor once we get it up & running?

Or could some help/show me via teamviewer sometime?

Thx

[jakla1027]

Can someone help with this error?

"Compile error:

The code in this project must be updated for use on 64-bit
systems. Please review and update Declare statements and then
mark them with the PtrSafe attribute."

I have tried the cmd. command fix mentioned above to no avail.

Running Excel 2010, & Visual Basic is installed.

Also I can't get any of the other versions (1.10 or 1.14) download links from filedropper.com to work. it just send me to a page with a faucet & wants me to join, no download option available

[Denniss]

Do you use a 64Bit Office version?

[jakla1027]

yep, so do I need to get a 32bit Office version? If so how do I do that on a 64bit system?

[Texeiro]

another goodie I lost. Can someone reupload please?????

[warshipbuilder]

Version 1.15

http://www33.zippyshare.com/v/64120533/file.html

[cohimbra]

ORIGINAL: warshipbuilder

Version 1.15

http://www33.zippyshare.com/v/64120533/file.html

v1.15, you're my hero [&o]

[Texeiro]

Mine too!! thanks WSB!!!!

[Augenstein]

Thank you WSB! Much, much appreciated!

[Mac Linehan]

Hi, warshipbuilder-

Used your link to the editor download at zippyshare; while still listed and download prompt appears, an error message appears "EDBTR Editor could not be downloaded". I tried both "save as" and "save target as".

Also, as I have not yet played, does Alter Ego's unofficial patch supplant this editor?

Am most grateful for your assistance.

Luftwaffe wannabe Mac

[warshipbuilder]

Sent you an email.