Matrix Games Forums

Forums  Register  Login  Photo Gallery  Member List  Search  Calendars  FAQ 

My Profile  Inbox  Address Book  My Subscription  My Forums  Log Out

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 >> Excel Strike Planner Page: [1] 2   next >   >>
Login
Message << Older Topic   Newer Topic >>
Excel Strike Planner - 1/25/2016 10:19:28 PM   
skorpio667

 

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

I made a Time-on-Target Planner spreadsheet. It calculates mission execution times for different platforms in different groups with different roles (CAP, SEAD, Strike etc), different weapons and different ingress route (waypoints), but all part of the same strike package. The intend is to have all strike platforms deliver their weapons on the same time on target in order to swamp enemy air defenses.

Unfortunately, it seems MS Excel dependent, as another poster reported back it didn't work in OpenOffice (see a couple of posts down). The spreadsheet contains ActiveX and VBA elements.

Skorpio667


Version 1.08 for DB3K_v444 and CWDB_v443

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

SEE POST 37 FOR Excel TOT SHEET v1.10 beta 1 for DB3K v480 for CMO

Attachment (1)

< Message edited by skorpio667 -- 12/21/2020 4:03:02 PM >
Post #: 1
RE: Excel Strike Planner - 1/26/2016 7:11:17 AM   
Dimitris

 

Posts: 13282
Joined: 7/31/2005
Status: offline
No, not a problem with that. Just be aware that you'll have a problem keeping the values up-to-date when we release new DB versions.

_____________________________


(in reply to skorpio667)
Post #: 2
RE: Excel Strike Planner - 1/26/2016 7:38:15 AM   
skorpio667

 

Posts: 30
Joined: 10/24/2013
From: The Netherlands
Status: offline
Great! Yeah, I discovered that already, as I had to update them yesterday, when I discovered the new update earlier this week. With your schedule of a major update average 2 months on average, I might

However, I hope users should be able to update the tables themselves with a little Google, and coaching?!

Skorpio

EDIT: The spreadsheet contained some unnecesary vba code that generated an error and there were some other issue's. Should besolved now. Uploaded v1.031 DB3K441
EDIT 2: Removed file, download latest from first post.

< Message edited by skorpio667 -- 1/27/2016 10:56:19 AM >

(in reply to Dimitris)
Post #: 3
RE: Excel Strike Planner - 1/26/2016 8:26:57 AM   
jarraya

 

Posts: 321
Joined: 9/10/2007
Status: offline
Skorpio,
I'm getting a runtime error in your code:

Private Declare PtrSafe Function getFrequency Lib "kernel32" _

The problem appears to be with the PtrSafe Function.

(in reply to skorpio667)
Post #: 4
RE: Excel Strike Planner - 1/26/2016 8:39:00 AM   
skorpio667

 

Posts: 30
Joined: 10/24/2013
From: The Netherlands
Status: offline
Hmmm, That vba module is not even necesary (It part of a timer code to calculate the time it takes to (re)calculate (parts) of the workbook).
Unfurtunately I discover some more typo's and errors. I'll update the file ASAP

Skorpio

(in reply to jarraya)
Post #: 5
RE: Excel Strike Planner - 1/26/2016 9:19:12 AM   
skorpio667

 

Posts: 30
Joined: 10/24/2013
From: The Netherlands
Status: offline
Removed the error generating module and updated the file to v1.031. Jarraya, could you try again please?

Skorpio

(in reply to skorpio667)
Post #: 6
RE: Excel Strike Planner - 1/26/2016 10:01:41 AM   
bradinggs


Posts: 362
Joined: 7/17/2013
Status: offline
Hi Skorpio667, thanks for this. Will this work in OpenOffice as well by any chance or only Microsofts Excel?

(in reply to skorpio667)
Post #: 7
RE: Excel Strike Planner - 1/26/2016 10:08:19 AM   
skorpio667

 

Posts: 30
Joined: 10/24/2013
From: The Netherlands
Status: offline
Bradinggs, I don't know. I learned the code, commands and structure on the fly, so I guess no special MS Excel-only commands are used, but really, I can't vouche for it.

Just try, I guess.

Skorpio

(in reply to bradinggs)
Post #: 8
RE: Excel Strike Planner - 1/26/2016 10:37:36 AM   
bradinggs


Posts: 362
Joined: 7/17/2013
Status: offline
Will do, will give you any feedback on it. Thanks.

UPDATE EDIT: Seems best to use in Office then, doesn't appear to work with OpenOffice, as far as I can see VBA doesn't work in OpenOffice.

Btw, looking forward to learn how we can keep this up to date. Thanks again.

< Message edited by bradinggs -- 1/26/2016 3:27:05 PM >

(in reply to skorpio667)
Post #: 9
RE: Excel Strike Planner - 1/26/2016 2:52:45 PM   
Dysta


Posts: 1909
Joined: 8/8/2015
Status: offline
Admiral Saturatius will be utterly thankful for your contribution.

Need time to fiddle with it, too bad my old iPad is too slow to make me use it on-the-fly.

(in reply to bradinggs)
Post #: 10
RE: Excel Strike Planner - 1/26/2016 2:53:56 PM   
Rory Noonan

 

Posts: 2816
Joined: 12/18/2014
From: Brooklyn, NY
Status: offline
I suspect keeping it up to date will only be an issue in the (relative) short term; IIRC ToT planning has long been identified as something that the Dev's want to implement.

Fantastic work on the spreadsheet though, it's clear a lot of work has gone into it. Good on you!

(in reply to bradinggs)
Post #: 11
RE: Excel Strike Planner - 1/26/2016 3:24:29 PM   
skorpio667

 

Posts: 30
Joined: 10/24/2013
From: The Netherlands
Status: offline
Thanks! It took me a month to create it, working on and off on it. It went through 8 builds or so. Every time I "finished" it, I kept thinking on how to improve it's usefulness and completeness/comprehensiveness. BTW, any suggestions are welcome.

Using it on an iPad is actually a good idea, hadn't thought of that myself. I have 3 screens, so space isn't a real issue.
Any Excel-knowledgeable people out there to improve the speed of the code so it can be used on a tablet?

Like Apache85 says, let's hope the build-in strike planner come online very soon. But updating the tables takes about 15 to 20 min. Not to bad for a 2 month-on-average period, before the next DB comes out.

Skorpio

(in reply to Rory Noonan)
Post #: 12
RE: Excel Strike Planner - 1/26/2016 7:41:58 PM   
stilesw


Posts: 1497
Joined: 6/26/2014
From: Hansville, WA, USA
Status: offline
skorpio667

Incredibly impressive. Great tool that obviously took significant time and thought to complete. Kudos!!

Wayne Stiles

(in reply to skorpio667)
Post #: 13
RE: Excel Strike Planner - 1/26/2016 9:08:27 PM   
skorpio667

 

Posts: 30
Joined: 10/24/2013
From: The Netherlands
Status: offline
Bradinggs, too bad it isn't application independent!

I seem to recall from a SQL-course during my study that SQL can do simple math, like that of this planner, too? If it could be written in SQL it would be more application independent and perhaps more efficient as the data lookup functions seem to take the bulk of the time needed to do the calculations. Then it could perhaps even be used on a tablet?
Does anybody know?

Skorpio

(in reply to stilesw)
Post #: 14
RE: Excel Strike Planner - 1/26/2016 9:22:24 PM   
ComDev

 

Posts: 5735
Joined: 5/12/2006
Status: offline
Hehe this is veeery nice, thanks for sharing!

Version 1.11 adds slightly improved mission start and end functionality, so should make it a bit easier to work with too

< Message edited by emsoy -- 1/26/2016 10:23:41 PM >


_____________________________



Developer "Command: Modern Air/Naval Operations" project!

(in reply to skorpio667)
Post #: 15
RE: Excel Strike Planner - 1/26/2016 9:25:32 PM   
ExNusquam

 

Posts: 513
Joined: 3/4/2014
From: Washington, D.C.
Status: offline
Skorpio, this is great; it's a huge improvement over my previous method for planning strikes. Thanks for sharing!

(in reply to ComDev)
Post #: 16
RE: Excel Strike Planner - 1/26/2016 9:39:34 PM   
skorpio667

 

Posts: 30
Joined: 10/24/2013
From: The Netherlands
Status: offline
Emsoy, in relation to the strike planner, would it be possible to pre-plot a mission from the mission planner, a bit like with the cruise missiles, so we could plan on an external planner and set course and altitude manually?
This would be nearly like the upcomming advanced strike planner you are working on (got this idea from a line apache85 said and added it to the feature requests too)

Skorpio

(in reply to ExNusquam)
Post #: 17
RE: Excel Strike Planner - 1/26/2016 9:43:07 PM   
ComDev

 

Posts: 5735
Joined: 5/12/2006
Status: offline
Hi Skorpio,

Yes this is planned. Horribly complex stuff so need to do it in baby-steps, but we'll get there eventually

_____________________________



Developer "Command: Modern Air/Naval Operations" project!

(in reply to skorpio667)
Post #: 18
RE: Excel Strike Planner - 1/26/2016 9:56:18 PM   
skorpio667

 

Posts: 30
Joined: 10/24/2013
From: The Netherlands
Status: offline
Emsoy, I think you mean the complete planner? I understand that is very complex and should be implemented in little increments.

I was hoping one of those increments (in the near future?) could be pre-plotting the course just like the course of the waypointed cruise missiles with manual lauch?

Skorpio

(in reply to ComDev)
Post #: 19
RE: Excel Strike Planner - 1/26/2016 10:24:35 PM   
ComDev

 

Posts: 5735
Joined: 5/12/2006
Status: offline
Yeah hope to add that soon. Not in v1.11 or v1.12 but perhaps v1.13 or v1.14. No promises though

_____________________________



Developer "Command: Modern Air/Naval Operations" project!

(in reply to skorpio667)
Post #: 20
RE: Excel Strike Planner - 1/26/2016 11:32:50 PM   
Rudd

 

Posts: 1501
Joined: 7/10/2013
Status: offline
Awesome!

Thanks Skorps

_____________________________


(in reply to ComDev)
Post #: 21
RE: Excel Strike Planner - 1/27/2016 8:58:46 AM   
skorpio667

 

Posts: 30
Joined: 10/24/2013
From: The Netherlands
Status: offline
Updated, see First Post

Skorpio

(in reply to Rudd)
Post #: 22
RE: Excel Strike Planner - 1/27/2016 10:48:22 AM   
Dysta


Posts: 1909
Joined: 8/8/2015
Status: offline
I got time today to test it out, with my small scenario that contained the whole 7th fleet in 2016 or older equipment.

UPDATE: RC2 released, test halted.

< Message edited by Dysta -- 1/27/2016 1:00:24 PM >

(in reply to skorpio667)
Post #: 23
RE: Excel Strike Planner - 1/27/2016 10:57:14 AM   
ziolo


Posts: 63
Joined: 3/27/2014
From: United Kingdom
Status: offline
very nice tool, thanks skorpio667!

_____________________________

C/MANO - The Digital Wargame of the Year

(in reply to Dysta)
Post #: 24
RE: Excel Strike Planner - 2/1/2016 9:49:14 AM   
skorpio667

 

Posts: 30
Joined: 10/24/2013
From: The Netherlands
Status: offline
Updated to version 1.04 for DB3K_v441 and CWDB_v440
The previous version seemed full of bugs. I think I used an earlier, not-debugged version. However, I correct them and added a CWDB-version, too.

Change log v1.04
----------------
* Added: New Workbook/spreadsheet for the CWDB (v440)
* Fixed: ToT field corrected (added platflorm role twice instead of once)
* Fixed: Platform Speed and (error-)messages for each waypoint checked and corrected
* Fixed: Clear All Groups now clears all groups instead 1 group per push
* Fixed: Take-off duration per group got broken along the way, it's working again.
* Fixed: Runways can handle 2 Large aircraft at once for take-off, instead of 1
* Added: a button for each single waypoint to set all throttles of the platform to a setting (Push once to set all throttles), while keeping empty platform-slots in Loiter/Creep
- waypoints 1 to 9: Set all to Cruise
- waypoint 10: Set all to Cruise or Military/Full
- waypoints IP and Target: Set all to Cruise, Military/Full or Afterburner/Flank
* Added: Clear All Groups or Clear a Single Group buttons now also resets all throttle settings to Loiter/Creep
* Added: When selecting a platform, Loadout Type is automatically set to Weapon (was Primary Loadout only)

(in reply to ziolo)
Post #: 25
RE: Excel Strike Planner - 2/6/2016 10:01:58 AM   
Maromak


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

Would you mind taking a look at the attached file. I have started entering CAP and OECM aircraft but there appears to be a value error in the Strike Launch box (cell EB21). Any tips on what I may have left out?

Thanks

M

Attachment (1)

< Message edited by Maromak -- 2/6/2016 11:33:11 AM >


_____________________________

Certa Cito

(in reply to skorpio667)
Post #: 26
RE: Excel Strike Planner - 2/7/2016 6:24:52 AM   
skorpio667

 

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

I checked your file, and discovered the following:
* In field D14 (date and time of strike) you entered a forward slash as date separator (22/02/1994) instead of a minus sign (22-02-1994). (Now I realize I used Dutch date-formatting)
* In field D14 (date and time of strike) you give the time of the strike in as 23:00:00 PM, where 23:00:00 (without the PM) is expected.
* In field DM26 (Range to Target @ Weapon Release) you forgot to enter the range the weapon travels to it's target (245nm). BTW, I see in the platform info the weapon is said to have No Engine, but in the weapon info the correct engine is found. I thought I fixed that. I'll have a look.

Skorpio

EDIT: Attached the latest version, with your strike entered

Attachment (1)

< Message edited by skorpio667 -- 2/7/2016 7:57:15 AM >

(in reply to Maromak)
Post #: 27
RE: Excel Strike Planner - 2/7/2016 6:26:53 PM   
Maromak


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

Thanks for taking a look and providing advice. I am using your planner with one of Gunner98's excellent scenarios (Anteaters Revenge) and it's proving very difficult without proper planning.

M

_____________________________

Certa Cito

(in reply to skorpio667)
Post #: 28
RE: Excel Strike Planner - 2/19/2016 9:49:28 AM   
Maromak


Posts: 1030
Joined: 12/26/2007
From: Australia
Status: offline
I am still a little confused about the takeoff times in column DZ. A few of the times seem very early considering the planned time of the strike on target.

Are the given times meant to be the actual Zulu/local time?



Attachment (1)

_____________________________

Certa Cito

(in reply to Maromak)
Post #: 29
RE: Excel Strike Planner - 2/19/2016 8:52:32 PM   
skorpio667

 

Posts: 30
Joined: 10/24/2013
From: The Netherlands
Status: offline
Argh! You are quiet right! In that column most cell have lost an extra division by 60! That results in the role-time-adjustment (in seconds) to be substracted from the impact time in minutes instead of second.
For example, in your file the OECM group (adjustment -180 second) is planned to arrive at ToT - 180 minutes (eg. 2 hours and 57 minutes early).

I have a new version ready to post, but I was waiting for the imminent(?) final v1.10 update, so I could post it with the CWDB v441 (instead of the v440 version that is out now). But in the light of this bug, I'll post it now (download in the first post).

BTW, Using Local or Zulu time is the user's own decision, it depends on the (date &) time the user enters in field D14. If it is local time, the planners calculates for local; if Zulu, it calculates for Zulu time

Skorpio

(in reply to Maromak)
Post #: 30
Page:   [1] 2   next >   >>
All Forums >> [New Releases from Matrix Games] >> Command: Modern Operations series >> The War Room >> Excel Strike Planner Page: [1] 2   next >   >>
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.797