Skip to content
View in the app

A better way to browse. Learn more.

The AVSIM Community

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

X-wind excel sheet

Featured Replies

Hi guys, Some time ago I had a little excel sheet on my PC with which I could calculate the x-wind runways very easily. But after I moved to my new system I can´t find it anymore. I tried everything but I can´t find it anywhere. I know it had been in the avsim library, so maybe it has been lost during the hack. Does someone have such a sheet and will share it with me? I need this for my upgrade of the FRF Anchorage AFCAD.

Best regards, Steffen

vrs_supporter_zpsiwiqesbo.png

Fight time: NGX 737-700: 37,0h; -800: 47,2h

Hi guys, Some time ago I had a little excel sheet on my PC with which I could calculate the x-wind runways very easily. But after I moved to my new system I can´t find it anymore. I tried everything but I can´t find it anywhere. I know it had been in the avsim library, so maybe it has been lost during the hack. Does someone have such a sheet and will share it with me? I need this for my upgrade of the FRF Anchorage AFCAD.
Calculating crosswind components for a given wind velocity and runway just needs a bit of basic trigonometry. If the wind speed is x, and the difference between wind direction and runway heading is y, then the crosswind component is x sin(y) (and the headwind is x cos(y)). Modelling that in Excel would be pretty straightforward for all possible runway headings and wind velocities: you'd create drop-downs in cells for runway heading, wind speed and wind direction and then use the formula =[cell containing wind speed]*SIN(RADIANS(ABS([cell containing rwy heading]-[cell containing wind direction]))). I'd be happy to do it if no-one can find the old spreadsheet. That said, I just use a calculator... I'm no expert at AFCAD editing, so maybe there's something else you need (maybe something that works out the runway(s) in use based on the wind velocity?). Replicating the maths into Excel formulas and so on shouldn't be too hard, though, so again if you could describe what's needed I'd be more than willing to have a go.

I think the OP might be referring to the crosswind runway technique which places pseudo short runways between non-parallel runways so they can be simultaneously active in FS9.I downloaded the FRF v4 PANC scenery. The freeware ADE9 can safely edit it appears AFX files unlike AFCAD221 which can cause problems. ADE9 has built in functions to properly space and move off the airport somewhat those pseudo runways. It has some similarities to AFCAD221.First here is a link to where exists a tutorial for creating them in any editor I think.http://www.scruffyduck.org.uk/filemanager/navega.php?PHPSESSID=733c3b43bab7f97c85c278e863e5d51d&dir=.%2FTutorials%2FAirport%20Designhttp://www.scruffyduck.org.uk/filemanager/navega.php?PHPSESSID=733c3b43bab7f97c85c278e863e5d51d&dir=.%2FTutorials%2FAirport%20Design%20Editor are turorials specific to ADE.http://www.scruffyduck.org.uk/filemanager/navega.php?PHPSESSID=733c3b43bab7f97c85c278e863e5d51d&dir=.%2FADE9X%20Current%20Version is the download page for ADE and its manuals. Download the manual and read its section about the built in Xwind runway creation tool.To work with an existing AF2_ or AFX_ file use the File\Open from Airport BGL function. Then List\Runways to display a table.I didn't study the manual but here is how I added runways 7 degrees apart. I just added seven to the previous runway. Here is a screen shot of the List\Runways and executing the Add Xwind button. Other than calculating the heading and picking an unused name (14C instead of 14) that's about it. The you save the airport project for further editing and then Compile Airport to get the .bgl which I placed in FRF's V4 PANC scenery folder where I loaded the AF2 file. I'll then rename the extension of the AF2 file to .bgh to save it. You'll probably need to check the brief ADE manual entry. It really is a quick process.

  • Author

Thanks Ron for the information. I´m a somehow expereinced use of ADE and AFCAD (Released two sceneries who are available in the library.) so ADE won´t be the problem. Knew most of the this you said. AFAIK you can go up to an 7.9° offset till FS won´t see them as parallel. I´ve just been a bit lazy to calculate this headings on my own.Btw. did your update work? Cause on the picture it seems that you forgot to relist the runways. 14/32 has to be the last.

Best regards, Steffen

vrs_supporter_zpsiwiqesbo.png

Fight time: NGX 737-700: 37,0h; -800: 47,2h

I haven't installed it yet but I knew I forgot something :) Thanks for calling my attention to it.Is your working?

  • Author
I haven't installed it yet but I knew I forgot something :) Thanks for calling my attention to it.Is your working?
I´m doing it in the moment. Hopefully everything works well.UPDATE: iI works! And how it works. All runways are open, the traffic has allmost doubled. I never knew that PANC has so much frighters to come

Best regards, Steffen

vrs_supporter_zpsiwiqesbo.png

Fight time: NGX 737-700: 37,0h; -800: 47,2h

When ordering the runways did you do it by heading? Unless I create some extra extended runway labels I don't have enough. I'll try it sorted by heading and park a bit as an observer. Either that or increase the increment or go in the other direction.

  • Author
When ordering the runways did you do it by heading? Unless I create some extra extended runway labels I don't have enough. I'll try it sorted by heading and park a bit as an observer. Either that or increase the increment or go in the other direction.
Yeah, I did it by heading.

Best regards, Steffen

vrs_supporter_zpsiwiqesbo.png

Fight time: NGX 737-700: 37,0h; -800: 47,2h

Create an account or sign in to comment

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.