UPDATED V3
I've updated the timestamps and added a couple of columns that I'm sure will be useful (they certainly are for me). I'm going to explain how it works again, so I'm editing this entire post to avoid any confusion and make sure everything is clear.
The sheet is protected to prevent any issues with the formulas, so don't worry about breaking anything. The only data you really need to enter is in the yellow cells. First, enter the current game time so the sheet can calculate the 'Time to Go' (T-Minus) for each launch. Second, enter the weapon type, cruise speed, and the desired Time on Target (ToT).
In this first example, we have three Arleigh Burke-class destroyers at different distances from the target. The first one will launch a Tomahawk following 3 waypoints (Plot Course), with a total distance of 420nm. The second ship will fire from 130nm, and the third from 210nm.
To make it even more interesting, we also have an Iwo Jima launching a Shahed-136 from 150nm and an SSN Virginia class submarine joining the strike. As you can see, the table shows the Launch Shift, the Time to Go until launch, and—most importantly—the LAUNCH TIME. This is exactly when you should pause the game to execute the launch command for that specific missile or drone.
It's incredibly useful and flexible. You don't have to make it this complex; you can simply use it to coordinate a two-unit missile strike with an incoming air strike. Another use case would be planning two separate waves from the same unit by using Table 1 and Table 2 with different arrival times.
The possibilities are endless, and I'm sure this will be a great asset for your missions. You’ll definitely have fun with it, and it will help you save a lot of ammo when trying to saturate enemy defenses!
I’Il got the idea from P Gatcomb's tutorials and I always use it in my strategy games; of course, it works perfectly in CMO.
So now you know... don't waste your Tomahawks
NOTE: I’d also like to mention that you can test this spreadsheet perfectly in the mission I recently released. You can find it in this thread or on the Steam Workshop. By the way, if you enjoyed the mission, I would really appreciate a quick 'like' or a thumbs up. These scenarios require a lot of effort—not just from me, but from everyone who collaborated—and your support really helps keep the motivation going to continue developing missions for everyone
https://steamcommunity.com/sharedfiles/ ... 3640984244
https://forums.matrixgames.com/viewtopic.php?t=414756
