RE: Excel Strike Planner

Matrix Games Forums

Forums Register Login Photo Gallery Member List Search Calendars FAQ

My Profile Inbox Address Book My Subscription My Forums Log Out

RE: Excel Strike Planner

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

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

Page: << < prev 1 [2]

Message

<< Older Topic Newer Topic >>

RE: Excel Strike Planner - 2/20/2016 6:53:04 AM

Maromak

Posts: 1030
Joined: 12/26/2007
From: Australia
Status: offline

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

_____________________________

Certa Cito

(in reply to skorpio667)

Post #: 31

RE: Excel Strike Planner - 3/9/2016 11:04:34 PM

mahuja

Posts: 107
Joined: 3/9/2016
Status: offline

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.

(in reply to skorpio667)

Post #: 32

RE: Excel Strike Planner - 3/11/2016 5:15:19 PM

skorpio667

Posts: 30
Joined: 10/24/2013
From: The Netherlands
Status: offline

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

< Message edited by skorpio667 -- 3/11/2016 5:19:10 PM >

(in reply to mahuja)

Post #: 33

RE: Excel Strike Planner - 3/17/2016 8:05:16 PM

skorpio667

Posts: 30
Joined: 10/24/2013
From: The Netherlands
Status: offline

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

(in reply to skorpio667)

Post #: 34

RE: Excel Strike Planner - 5/20/2016 10:34:44 AM

skorpio667

Posts: 30
Joined: 10/24/2013
From: The Netherlands
Status: offline

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

(in reply to skorpio667)

Post #: 35

RE: Excel Strike Planner - 5/20/2016 4:59:06 PM

Dannyp19

Posts: 186
Joined: 10/20/2013
Status: offline

Thanks Skorpio! Very handy tool.

(in reply to skorpio667)

Post #: 36

RE: Excel Strike Planner - 12/21/2020 1:44:21 PM

skorpio667

Posts: 30
Joined: 10/24/2013
From: The Netherlands
Status: offline

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

Attachment (1)

< Message edited by skorpio667 -- 12/22/2020 9:17:26 AM >

(in reply to Dannyp19)

Post #: 37

RE: Excel Strike Planner - 1/12/2021 10:34:51 AM

skorpio667

Posts: 30
Joined: 10/24/2013
From: The Netherlands
Status: offline

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

(in reply to skorpio667)

Post #: 38

RE: Excel Strike Planner - 4/21/2021 6:32:23 AM

TBLackey

Posts: 9
Joined: 4/8/2021
Status: offline

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....

(in reply to skorpio667)

Post #: 39

RE: Excel Strike Planner - 4/28/2021 11:38:52 PM

hrfepo1

Posts: 108
Joined: 9/19/2017
Status: offline

Skorpio,

Thank you. This work is awesome!

(in reply to TBLackey)

Post #: 40

RE: Excel Strike Planner - 4/29/2021 11:32:45 AM

thewood1

Posts: 6529
Joined: 11/27/2005
Status: offline

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.

_____________________________

You are like puss filled boil on nice of ass of bikini model. You are nasty to everybody but then try to sweeten things up with a nice post somewhere else. That's nice but you're still a boil on a beautiful thing! - BDukes

(in reply to hrfepo1)

Post #: 41

RE: Excel Strike Planner - 5/1/2021 7:18:25 AM

TBLackey

Posts: 9
Joined: 4/8/2021
Status: offline

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

(in reply to thewood1)

Post #: 42

RE: Excel Strike Planner - 5/1/2021 11:35:48 AM

KnightHawk75

Posts: 1450
Joined: 11/15/2018
Status: offline

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.

(in reply to TBLackey)

Post #: 43