I spent maybe 7 hours, working with ChatGPT and a few SP users, making and figuring out the math and such required to conduct an accurate and successful MRSI (Multiple Round, Simultaneous Impact) fire mission with a modified version of my M301 Angurvadal. At a range of 62,134m, I was able to land two 155mm unguided shells within 100m of the intended target. This success led me to dig further down the rabbit hole of firing solution calculations and MRSI and whatnot, and I spent even more time with ChatGPT working in Microsoft Excel to make a functioning firing solution calculator. It was able to land shells within 100-175m of whatever target data input I typed into it. I took it a step further and made the calculator give outputs for two rounds, one at low arc and the second at high arc, to allow MRSI fire.
It integrates SimplePlanes' in-built coordinate system as well as altitudes and vehicle pitch/roll angle provided by the modified M301's gunsight to compute a baseline deflection and quadrant (traverse and elevation) as well as a modified deflection and quadrant accounting for inaccuracies caused by vehicle pitch and roll. It also provides the estimated time of flight for the low and high arc shells, as well as the amount of time to wait after firing the first shot before firing the second shot. It also includes a button (not shown in the image) to log the firing data in a separate D.O.P.E. (Data On Previous Engagements) spreadsheet.
Thank you for listening to my TED talk. As far as I am able to verify, this may very well be the first time any user in SimplePlanes history has succeeded in true MRSI artillery fire, and just the fact I was able to accomplish this kind of tactic in an aviation based game continually impresses me. I just wish there were more artillery nerds like myself lol
@SpartanBallistics i don't either but its still fun
@Erionh
I would but I've got no squad of buddies to play with ;w;
@SilverStar
I could not find a browser resource specifically for making an Excel calculator correct your aim using roll angles in mils to determine how offset you are. I also couldn't find any resource for how to make Excel calculate the approximate time of flight for high and low angle shots. A third thing I couldn't find was how to make the Excel calculator use the numbers from the high and low angle shot and find the time between rounds. To top off the numerous nonexistent tutorials for making MRSI calculators in Excel, I've never in my life touched Excel formulas before and had zero clue of where to start. Are you implying that I should have dug for potential hours on end to find resources and tutorials for how to make something that has likely almost never been made before in Microsoft Excel and published?
To further add on, yes I'm very much aware of ChatGPT's reliability. Purely because of that is why I spent maybe 45min to an hour on each individual formula and testing its resulting values against in-game numbers I've confirmed to make sure it's at LEAST mostly accurate. By itself, the modified Angurvadal I used can land shells within 100m of a target at ~62,100m. The calculator only increase that amount by 100m (200m dispersion at 62km) which may sound like a lot, but still places the overall accuracy of the calculator well within sniper accuracy for unguided artillery.
@SpartanBalistics you should play arma reforger it has a realistic mortar and artillery calculator that you actually have to do
The fact that you used ChatGPT is clearly blameworthy to me.
I mean, internet is plently of useful ressources that you can find with a simple browser search. Why would you use an artificial intelligence that want to simplify the answer, which makes it making errors and even lie...
@SpartanBallistics
KABABAYAN??!! (MY FELLOWMEN??!!)
@Graingy oorah
No I meant the crayons
@Graingy
Hungry for some Filipino food being served at the festival on base rn, yes :3
You must be hungry
@Graingy
Maybe 20 crayon-hours of labor. It still needs refining though, it seems to be best used for rough aiming since the most precise number is the CORR. DEF being accurate to within 10m at 80km, quadrant leaves a lot to be desired
I am not insane enough to achieve this thing. This is good stuff 🤝🤝🤝
How many crayons of labour did this take?
@Axartar
Prototype build or prototype spreadsheet? Either way I have both, the modified M301 is unlisted.
I mean im a fan of an excel spreadsheet, but do you have a functioning prototype?
dang son that's impressive