Profile image

So I just made a calculator for SimplePlanes artillery...

5,751 SpartanBallistics  21 days ago

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

  • Log in to leave a comment
  • Profile image
    5,300 Erionh

    @SpartanBallistics i don't either but its still fun

    +1 20 days ago
  • Profile image

    @Erionh
    I would but I've got no squad of buddies to play with ;w;

    20 days ago
  • Profile image

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

    +2 20 days ago
  • Profile image
    5,300 Erionh

    @SpartanBalistics you should play arma reforger it has a realistic mortar and artillery calculator that you actually have to do

    +1 20 days ago
  • Profile image
    16.6k SilverStar

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

    20 days ago
  • Profile image

    @SpartanBallistics

    KABABAYAN??!! (MY FELLOWMEN??!!)

    20 days ago
  • Profile image
    30.1k TriStar

    @Graingy oorah

    21 days ago
  • Profile image
    42.3k Graingy

    No I meant the crayons

    21 days ago
  • Profile image

    @Graingy
    Hungry for some Filipino food being served at the festival on base rn, yes :3

    +1 21 days ago
  • Profile image
    42.3k Graingy

    You must be hungry

    21 days ago
  • Profile image

    @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

    21 days ago
  • Profile image

    I am not insane enough to achieve this thing. This is good stuff 🤝🤝🤝

    +1 21 days ago
  • Profile image
    42.3k Graingy

    How many crayons of labour did this take?

    +4 21 days ago
  • Profile image

    @Axartar
    Prototype build or prototype spreadsheet? Either way I have both, the modified M301 is unlisted.

    +3 21 days ago
  • Profile image
    23.6k Axartar

    I mean im a fan of an excel spreadsheet, but do you have a functioning prototype?

    +1 21 days ago
  • Profile image
    31.4k 32

    dang son that's impressive

    +3 21 days ago