RE: Excel Strike Planner (Full Version)

All Forums >> [New Releases from Matrix Games] >> Command: Modern Operations series >> The War Room



Message

Maromak -> RE: Excel Strike Planner (2/20/2016 6:53:04 AM)

Ok thanks. I noticed some of the formulas had an extra /60.



mahuja -> RE: Excel Strike Planner (3/9/2016 11:04:34 PM)


quote:

ORIGINAL: skorpio667
I seem to recall from a SQL-course during my study that SQL can do simple math, like that of this planner, too?


I'm quite confident the whole task could be done in sqlite. (Making a frontend in sql would be a hassle though.)
Just to put a cherry on the top, the game's database (whichever you use) is a sqlite file, meaning you can query it directly, as a read-only. Which means a user could switch to whatever database the scenario is actually using.

It'd probably be easiest to create table as select whatever to store intermediate results and do it in smaller steps. In the :memory: database, perhaps.




skorpio667 -> RE: Excel Strike Planner (3/11/2016 5:15:19 PM)

I thought so! Seems to me the downside is installing new software for making a frontend easily.
Furthermore, I'm quite far in the process of making an auto-update script, so you can point the workbook to a Dir containing the comma separated files exported from the database and it then automatically imports, removes duplicates, makes and sorts the tables and updates the variables.
And I started the groundwork for fuel-usage and Air to Air Refueling.

All in all, to much work to redo in SQL (for now) [:(]

Skorpio



skorpio667 -> RE: Excel Strike Planner (3/17/2016 8:05:16 PM)

Updated to v1.07

Change Log v1.07
----------------
* Updated the data to DB3K v442 and CWDB v442 (as found in CMANO v1.11)

For file, see post #1



skorpio667 -> RE: Excel Strike Planner (5/20/2016 10:34:44 AM)

Update to v1.08

Change Log v1.08
----------------
* Updated the data to DB3K v444 and CWDB v443 (as found in CMANO v1.11)

For file, see post #1



Dannyp19 -> RE: Excel Strike Planner (5/20/2016 4:59:06 PM)

Thanks Skorpio! Very handy tool.



skorpio667 -> RE: Excel Strike Planner (12/21/2020 1:44:21 PM)

Hi all,

After a long laps, I pickup CMO again. I also started working on the Excel Strike Planner again. Today I upload v1.10 beta 1 for DB3K v480.
It is still in beta stage.

Changelog v1.10 beta 1 for DB3K v480
------------------------------------
* updated the database to DB3000 v480
* included used fuel calculations for strike groups (aircraft)
* included Air-to-Air Refuel calculations for aircraft

Issues with this version:
- used fuel calculations are a bit rough: Altitude Band changes during a height change will alter fuel usage per second. This is not incorporated yet. For now a height change will make the spreadsheet use the fuel usage of the new Altitude Band instantaneous (not: x seconds in Band A and y seconds in Band B).
- Determination of position of already airborne tanker aircraft is very processing power hungry. The method I now use requires at least 6000 to 10000 calculations per tanker to get a "precise" location. The more, the better... Therefore, I don't use this yet. This means that to make a successful AAR rendezvous, the tanker should take-off from an airport in a preplanned flight. Then the tanker will be at the right location when the strike group arrives.
- a BIG issue: Strike Groups lose their manually entered preplanned in-game flightpath directly after starting their AAR...
- the AAR variables need tweaking: how long does it take an aircraft to hook up, etc.

Skorpio667



skorpio667 -> RE: Excel Strike Planner (1/12/2021 10:34:51 AM)

In-game AAR testing gave me some insight to the mechanics used:
- receiving aircraft in a flight group refuel as one plane
- the formula I use for determining the tanker location at a certain time when it is on station must be altered to give a more better match with the in-game location
- in-game fuel transfer quantities per minute differ from what I found on the internet and must be adjusted in the planner.
- with the formula change for position determination of the Tanker, I might have solved the issue that a Tanker flight should be pre-planned. I hope I can get the planner to work with tankers that are already on station, now. That will probably give an time uncertainty, as launch time of the receiving group is, among other things, dependent on position of the tanker and amount of fuel used, but might be limited to a few seconds?

Working on it


Skorpio667



TBLackey -> RE: Excel Strike Planner (4/21/2021 6:32:23 AM)

Skorpio how did you extract all that in-game data into a spreadsheet?

I'd be keen to dump the platform/weapon databases into spreadsheet to skim through with ease....



hrfepo1 -> RE: Excel Strike Planner (4/28/2021 11:38:52 PM)

Skorpio,

Thank you. This work is awesome!



thewood1 -> RE: Excel Strike Planner (4/29/2021 11:32:45 AM)

I think you can dump the data or write a query through an SQL db tool. I have used MS Access on parts of the db3000 just to look at a few parameters.



TBLackey -> RE: Excel Strike Planner (5/1/2021 7:18:25 AM)

But aren't the DB3 files encrypted, and therefore there is no way to view them????



KnightHawk75 -> RE: Excel Strike Planner (5/1/2021 11:35:48 AM)


quote:

ORIGINAL: TBLackey

But aren't the DB3 files encrypted, and therefore there is no way to view them????

The DB files themselves, no, you can open them. But hashes of each file tell the game to recognize a given db or not, only ones matching official released ones will be recognized (without professional edition) and allowed to be used in game.



Page: <<   < prev  1 [2]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
1.439453