Simbrief API Multi Plan

SimBrief API
1

Hello, I have a CSV file, and in this file, I need to add the distance in the ‘distance’ column, the flight time in the ‘flight time’ column, and the route in the ‘route’ column. Manually creating each route on SimBrief is really time-consuming. Is there an API from SimBrief that can allow me to get this information in bulk? Can I create an app on Google Sheets by entering an API key to solve this issue?

image
image1495×706 92.5 KB

2

I don’t think SimBrief is geared for bulk generation like this; And even it if was - it will give you snapshot-in-time at best;
Consider - flight length is determined by aircraft speed - that depends on aircraft and prevailing winds; the longer the route is - the bigger variance; Given the variables of arrival/departure airports and route - 80 days is a valid answer - assuming my aircraft is hand propelled :slight_smile:

Couple years back at vAMSYS we did some mathematical analysis on a bunch of A320 flights in Europe trying to solve similar problem like you have - getting a reasonable flight length - happy to share the formula:

in PHP we use

gmdate('H:i:s', floor(((0.002393 * $distance) + 0.6415) * 60 * 60))

In Excel/Sheets assuming $distance is in cell A1, the equivalent formula would be:

=TEXT(FLOOR(((0.002393 * A1) + 0.6415) * 3600, 1) / 86400, "hh:mm:ss")

For flights under 3 hours we found this to give a rather accurate output, all things considered;

Your only other issue is generating distance; For that I don’t really have suggestions in Excel to achieve a more accurate picture (summing distances between waypoints) - what we do when no route is provided by our VA Customers is calculate great circle distance between airports; If in your sheets you store latitude/longitude for departure/arrival airports you could do something like this:

Assuming:

    A1 = Latitude of departure airport (lat1)
    B1 = Longitude of departure airport (lon1)
    A2 = Latitude of arrival airport (lat2)
    B2 = Longitude of arrival airport (lon2)

=ACOS(SIN(RADIANS(A1)) * SIN(RADIANS(A2)) + COS(RADIANS(A1)) * COS(RADIANS(A2)) * COS(RADIANS(B1 - B2))) * 60 * 1.1515 * 0.8684

And then you can perhaps tweak the values - if your routings on average add 10% to distance - just multiply the values by 1.1;

All to say - not everything needs to be done by SimBrief :slight_smile: With some scrappy attitude one can come up with some very reasonable figures :slight_smile:

1 Like