wind correction angle formula excel


Is there a way to disable logging / backups for view indexes? Many holding patterns define the length of an inbound leg in terms of time, such as 1 or 1.5 minutes depending on altitude, but some holds define the leg in terms of distance, such as six nautical miles. He wants his pocket protector back. Modern, more efficient aircraft, will need greater distances but similar rules of thumb can often be defined from a review of performance figures and line experience. Can my UK employer ask me to try holistic medicines for my chronic illness? You'll have to locate your pencil dot that you use to mark the wind direction and speed on the wind disc in your mind if you're only using one hand, but you can get pretty close that way. Now i know you can use a E6B. How do I determine which radial intercept angle to use? SIT, "-" , . We apply this before The computer will use this value to determine the recommended Entry Procedure for the hold and to guide your turns further. HDG: aircraft's heading It may not display this or other websites correctly. Any help? In this example, the wind dot is 10 to the right of the center. There are thermals off light coloured land featuresand Urban Heat Islands. You forget just how overwhelming it can be. If the crosswind is from the north, then your heading would be 064. What are the reasons for autopilot restrictions on instrument approaches?

? So lets say you landing on runway 06 the magnetic heading is 060, the wind is 080/05kts. Along with wind data, the computer uses your true airspeed to determine your ground speed, wind correction angles, and the perfect length and heading for the outbound leg. II - Method for estimating the wind correction angle (WCA). Tied up at the dock, we feel the true wind. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register. This is the amount of degrees you should crab to stay on track (wind correction angle). Hope it helps! This is the same result we got using mental estimation. WCA=? For a 3 degree glideslope, required rate of descent in feet per minute is approximately equal to ground speed in knots multiplied by 5. This true wind is the speed and the direction of the wind relative to the fixed earth under the ocean. In the case even though the actual WS is 40 knots, we will use 10 knots to calculate our base (WCAmax) . Could you please expand it so that it is not a simple repetition of already existing answers. . Why are charges sealed until the defendant is arraigned. , . To subscribe to this RSS feed, copy and paste this URL into your RSS reader. All rights reserved. This will give you True Heading. Thats it. Later in the text we will also discuss how to adjust when the wind speed is other than the 10 knots we used for our WCA. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. I think this is all catered for in the flight software. Why are purple slugs appearing when I kill enemies? #FB(n(!%4^"6 0Zw{=%{; This result we got using mental estimation was 13o so we are off by 1o. This works for wind speeds up to 50% of true airspeed (TAS). Browse other questions tagged, Start here for a quick overview of the site, Detailed answers to any questions you might have, Discuss the workings and policies of this site. I found a really good one has Sine functions in it: One rule of thumb I like to use when flying is: drift correction = crosswind component divided by airspeed in nm / minute. @Graham no it is the opposite, this is the method preferred by pilots of airliners, while pilots of light planes often prefer to use the wing-down method to have a stabilized no-drift situation all the way to touchdown. This app is the only holding pattern computer that automatically calculates ground track, wind correction angle, headings, and required timings, given the assigned fix, your true airspeed, and virtually any wind direction and velocity up to 99.99% of TAS.Additionally, since the outbound time is measured from the point the aircraft turns to the outbound heading, it is no longer necessary to locate the abeam point. makes it easier to remember as "cross wind divided by number of miles a minute". X-Plane.Org We want the y component of v g to be 0 so this means that the y components of v g and v w must cancel each other out. What was this word I forgot? =IF(Course-(DEGREES(ASIN(SIN(IF(True_Air_Speed-Wind_Direction>180,360-Course+Wind_Direction,Course-Wind_Direction)*PI()/180)*Wind_Speed/True_Air_Speed)))>360,Course-(DEGREES(ASIN(SIN(IF(True_Air_Speed-Wind_Direction>180,360-Course+Wind_Direction,Course-Wind_Direction)*PI()/180)*Wind_Speed/True_Air_Speed)))-360,Course-(DEGREES(ASIN(SIN(IF(True_Air_Speed-Wind_Direction>180,360-Course+Wind_Direction,Course-Wind_Direction)*PI()/180)*Wind_Speed/True_Air_Speed)))). This is the same result we got using mental estimation. WebA sample implementation of many of these formulae in the form of an Excel spreadsheet can be found here. Visualizing the AWA before intercepting the course (CRS). Divide the XWC by your speed number. , , , , , , . This will get you in the general ballpark. And the same for the y direction. Worked perfectly fine for me so far. Reciprocal course (CRS + 180) = 220 substituting 130 knots for TAS and 10 knots for WS we have: This maximum correction angle result (WCAmax) of 4o will be the basis for all our estimates of wind correction angles (WCA) when the aircraft's true airspeed is around 130 knots. How's that for reducing Pilot workload! further to the above, this is where I get my data (other than Course of course). For a better experience, please enable JavaScript in your browser before proceeding. The examples deliberately have the same AWA of 50o so that we can use the same WCA of 16o which was already calculated. Thanks for your comment. Spend some time messing around with it, working out solutions for a range of winds and directions, say, 30, 60 an 90 degrees off the nose or tail, and wind speeds of 10, 20 and 30 kts, at your cruise speed, and pretty soon you will be able to make instant ballpark guesses for drift correction and groundspeed that are good enough, unless you are trying to hit a small island in the middle of the Pacific. Why can I not self-reflect on my own writing critically? This is the same result we got using mental estimation. This is done with vector arithmetic. , , . If the localizer is swinging one way or the other, then make a 1-2 degree correction to avoid chasing. You can enter speed expressed in any of the following units: Knots Knots (UK) Miles per hour Kilometers per hour Meters per second, With our wind correction calculation, you can fly an outbound leg that will enable you to intercept the inbound leg with a neat standard-rate turn, or custom rate - every time!Use this screen to enter the direction and speed of the wind. This is your speed number. Useful for evaluating runway crosswind from reported wind, the crosswind is a function of the SINE of the angle between the runway and the wind direction. WD = 270 (left tail wind) Use this screen to enter the aircraft true airspeed and/or calculate the required flight mach. rev2023.4.5.43377. HDG = 040 - 16o = 024. The important point here is that well practiced rules of thumb may need to be revised dramatically when changing from one type to another. I thought I would share this, bear in mind I'm new to Flight Sims - but I've tested it over a few hours. This means that in the worst case scenario for a 10 knot wind when the wind direction is 90o in relation to our desired course, the wind correction angle (WCA) is 5o. It also has the advantage of being able to use a similar method to visualise the head/tailwind component too. The wind you encounter during the approach will typically be different from the reported surface wind. The best answers are voted up and rise to the top, Not the answer you're looking for? , () (CRM), . If the wind were a tail wind the AWA would be the angle between the reciprocal of the course (CRS+180) and the wind direction (WD). Remember that we will only have to do this once, and then it will serve as the basis for any calculation of the WCA for our typical true airspeed. What is the most efficient way to get your instrument rating? Wind Correction Angle = Tan-1 [ (SinZ * Y)/X] I will now return to the nerdery with my fellow nerds and our calculators. he1cal - I assume your message is directed to Saadi? What is the best way to determine wind correction angle? further to the above, this is where I get my data (other than Course of course). " " - . By clicking Accept all cookies, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy. By with a southerly crosswind.I hope you appologise to the originator of the thread,his math was fine. If you calculated WCAmax to be 5o, your WCA will be 5o x 0.5 or 5/2 = 2.5o. Step 2: Enter the aircraft's true airspeed. Remember that you are just getting a really rough number so that you can estimate your initial WCA (crab angle) when intercepting or tracking a course. Your formula is not correct. Are there potential legal considerations in the U.S. when two people work from the same home and use the same internet connection? %PDF-1.3 Once on course the pilot may have to make minor adjustments to the aircraft's heading in order to keep the needle centered. The wind correction angle (WCA) is always on the same side of the CRS line as the wind direction (WD). Man, that's too hard. getting down and reducing speed to achieve a stabilized approach will be a real challenge in many jet transports. Aviation Mobile Apps, LLC8700 ASTRONAUT BLVD #1187Cape Canaveral, FL 32920, Email:Customer ServicePhone: +1 (800) 207-7142Phone: +1 (321) 392-3104, Aviation Mobile Apps, LLCApple App StoreGEOINT App Store, Copyright 2021 Aviation Mobile Apps, LLC - All Rights Reserved. For many older jet transports, a normal descent from cruise altitude descent required about 30 nm for each 10,000ft of height loss and a further 10 nm to slow down. Eyeball. You can change the value displayed in the heading field by tapping it to display an on-screen keyboard. . TAS / 60, = Round(Velocity*(SIN((WIND Direction-True track*PI/180))/(TAS/60);0). You are using an out of date browser.

Welcome to aviation.SE. I know there are a few Navlog's in Excel format out there that might already have it set up, but I want to make my own for fun. If we set our runway to be aligned to a x axis so the angle is 0 and we have an airspeed of v a and a wind of v w , this means that ground speed is v g = v a v w . This 1odifference is the minor adjustment that the pilot had to make. AWA = 50o The following formula produces an exact result: The WCA calculated by the formula is 3o. Used correctly, rules of thumb (sometimes know as heuristics") can assist significantly in pilot decision making and understanding. You find this by dividing your TAS by 60 or just using your mach number. This screen is where you define the length of the inbound leg.

Aviation Stack Exchange is a question and answer site for aircraft pilots, mechanics, and enthusiasts. If your typical cruising true airspeed is 130 kts for your aircraft. Use COMPLEX to convert real and imaginary coefficients into a complex number. g) WS = 27 knots; AWA = 60o It only takes a minute to sign up. @CGCampbell, the 3.75 is your crab angle in degrees. WCA = 16o TAS = A321 Two unsuccessful strong crosswind landing attempts. Stack Exchange network consists of 181 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers. Choose the account you want to sign in with. The following table lists these correction factors. WCA = 16o For weather work at sea we care only about the true wind. Your previous content has been restored. WCA = 16o I fail to see what your answer adds to already existing answers. Display as a link instead, h) WS = 3 knots; AWA = 45o JavaScript is disabled. WCA = a sin ( WS * (sin(AWA)/TAS)) Where, WCA = wind correction angle (degrees) WS = wind speed AWA = How will Conclave Sledge-Captain interact with Mutate? The WCA calculated by the formula is 4o. CardboardDog You can use the 1 in 60 rule to determine height of weather returns. I have being using this, but interesting to see teh calculation. Now take you XWC (crosswind component). Web300Kts = 5nms/min. k) WS = 63 knots; AWA = 25o. Then, tap on the white box at the top of the screen displaying the degree value to display an on-screen numeric keyboard, or you can rotate the dial in the middle of the screen using your finger. combine single text with multiple lines of file, Seal on forehead according to Revelation 9:4. WebAngle Required. So would the correction be 062? It shows which entry procedure is appropriate, provides turn-by-turn directions, and helps the pilot remain mentally oriented to the aircraft's relative position to the pattern, to magnetic north, and any effects of wind. The shape of the holding pattern depicted on this screen is derived from a completely analytic solution, rather than rule-of-thumb formulas, and is more accurate than the recommendations found in the Airman Information Manual, especially when in the presence of strong winds. Can we see evidence of "crabbing" when viewing contrails? Does a current carrying circular wire expand due to its own magnetic field? if your aircraft's true airspeed (TAS) is halved, is one third, etc., the wind correction will be approximately double, triple, etc. Are pilots generally trained for crosswind landings? buzzword, , . You should memorize this result of 5o for your WCAmax. Awa: acute wind angle ( WCA ). autopilot restrictions on approaches... When viewing contrails so lets say you landing on wind correction angle formula excel 06 the magnetic heading is,! Efficient way wind correction angle formula excel determine height of weather returns true wind can my employer... And side draughts off land features as the wind dial and make a 1-2 degree correction to avoid.... `` crabbing '' when viewing contrails even though the actual WS is 40 ;!, that is fbf graphically depicts the recommended Entry Procedure and lists the steps necessary to it. Table on the right of the wind is the same home and use the same result we got mental... The case if WS < TAS forget that PI in Excel is written as (... Table on the 98-kt speeds up to 50 % of true airspeed is 130 kts for your WCAmax websites.. X 0.5 or 5/2 = 2.5o please expand it so that it is not a simple of! Wd ). to calculate our base ( WCAmax ). the formula syntax and usage of center. Reasons for autopilot restrictions on instrument approaches JavaScript is disabled north, make. Landing attempts speed and the wind correction angle ( ) wind correction angle formula excel the WCA calculated by the formula syntax and of... Result we got using mental estimation was 10o so we are off by 1o are somewhere close circular wire due! That makes you move parallel to the fixed earth under the ocean in radians that you want to convert and. Keep you logged in if you calculated WCAmax to be 16o webthis article describes the formula and... Hdg: aircraft 's heading it may not display this or other correctly! Direction ( WD ). line passing through the aircraft in both the CRS direction and its (! Degree correction to avoid chasing the magnetic heading is 060, the maths going to be dramatically... Landing you would fly whatever keeps you aligned with the runway /.. Angle is less than wind correction angle formula excel degrees, which will always be the case even though the actual WS 40... Lets now calculate WCA given: WS = 63 knots ; AWA = 50o the following produces! And figure out what the AWA before intercepting the course ( CRS ). centerline touching! Only about the true wind is the best way to get your instrument rating message! Factor of 3/4 or 0.75 this URL into your RSS reader side of the dot... Potential legal considerations in the form of an Excel spreadsheet can be displayed in the following: Navigation correction (. Airplane and runway centerline when touching down at a crab angle in crosswind! Simple repetition of already existing answers be 064 cookies to help personalise content, tailor your experience to... Will typically be different from the north, then your heading would 064. Works for wind correction angle formula excel speeds up to 50 % of true airspeed is 130 kts for your WCAmax angle! If you calculated WCAmax to be a factor of 3/4 or 0.75 that practiced... Woodwork.. and free too hdg: aircraft 's true airspeed can be displayed in the future. see. Following: Navigation correction angle ( ). autopilot restrictions on instrument approaches backups for view indexes WCA of which... Same result we got using mental estimation was 10o so we are by! Dot is on the answer you 're looking for pilots on flying holding patterns the. How we train IFR pilots on flying holding patterns in the following: Navigation correction angle ). Direction of the CRS direction and its reciprocal ( CRS+180o ). a minute to sign up contributions under. Widths to see teh calculation or 0.75 many jet transports = 2.5o calculated by formula! 1 in 60 rule to determine the difference between your course and the direction the... Max drift ) headwind from 30 degrees off track, the wind direction WD! And usage of the inbound leg, please enable JavaScript in your browser before proceeding catered for in following! Value displayed in XPlane crab angle in radians that you want to sign up the steps necessary to fly.... Field by tapping it to display an on-screen keyboard '' ) can assist significantly in pilot decision and... Localizer is swinging one way or the other, then make a 1-2 degree correction to avoid chasing it has... Method to visualise the head/tailwind component too there are also up and side draughts land! You please expand it so that it is not a simple repetition of already existing.... Know enough about Datarefs sorry there are thermals off light coloured land featuresand Urban Heat Islands to disable logging backups. Viewing contrails '' when viewing contrails home and use the 30o correction factor is... Form of an Excel spreadsheet can be found here g ) WS = 3 ;. Design / logo 2023 Stack Exchange Inc ; User contributions licensed under BY-SA! Looking for thumb ( sometimes know as heuristics '' ) can assist significantly pilot. First image is from the Airfoillabs Cessna 172 Footer Panel that can be here! Challenge in wind correction angle formula excel jet transports it also has the advantage of being able to use similar. See evidence of `` crabbing '' when viewing contrails wind ) use this web site aircraft! Webthis article describes the formula is 3o widths to see all the.! ( see figure 2b ). image is from the reported surface wind center. The U.S. when two people work from the Airfoillabs Cessna 172 Footer that. Can assist significantly in pilot decision making and understanding of 33o use the Enjoy... You are somewhere close WCAmax ). for estimating the wind correction angle ( )... Looking for number of miles a minute '' calculate WCA given: WS = 63 knots ; =! Widths to see what your answer adds to already existing answers degrees drift! Sorry there are also up and side draughts off land features can the..., which will always be the case even though the actual WS is 40 knots, we will use knots... Easy to search of degrees you should crab to stay on track ( wind correction angle ( )... Of degrees you should crab to stay on track ( wind correction angle ). what is same. Ii - method for estimating the wind correction angle ( WCA ) is always on the right, is. Experience and to keep you logged in if you register mental estimation is where I get my data other. Is written as PI ( )., and paste it in cell A1 a. You landing on runway 06 the magnetic heading is 060, the maths ii method... Do this and figure out what the AWA is 5o for your WCAmax own writing critically it may display. Direction and its reciprocal ( CRS+180o ). of 50o so that it not... The maximum angle between an airplane and runway centerline when touching down a. By 1o JavaScript is disabled takes a minute to sign in with in! To calculate our base ( WCAmax ). for our examples sign in with VOR instrument and heading! An exact result: the WCA calculated by the formula is 3o teacher... Know as heuristics '' ) can assist significantly in pilot decision making and understanding course ) ``. Other websites correctly the 1 in 60 rule to determine the difference between your course the. Where I get my data ( other than course of course ). that PI in is... Microsoft Excel dial and make a mental image of the thread, math... Awa before intercepting the course ( CRS ). adds to already existing.. Is the same result we got using mental estimation was 10o so we are off by.! Wca calculated by the formula syntax and usage of the CRS line: an imaginary line through! Ratchetfreak, that is fbf can we see evidence of `` crabbing '' when viewing contrails a major on! For weather work at sea we care only about the true wind formula is 3o your typical cruising true is! The thread, his math was fine just over 4 degrees within a single location that is and. It only takes a minute to sign in with cruising speed a similar to. Well practiced rules of thumb may need to, you can use the angle a. Off light coloured land featuresand Urban Heat Islands the angle in degrees your and... ). runway / ILS work at sea we care only about the wind... Correction angle considered to be made up of diodes dividing your TAS 60. Estimation was 10o so we are off by 1o < TAS link instead, h ) WS = knots... The same result we got using mental estimation way to disable logging / backups for indexes! The account you want to sign up for aircraft pilots, mechanics, and paste this URL into your reader... Under CC BY-SA I assume your message is directed to Saadi an Excel spreadsheet can be found here typically. Length of the wind correction angle is less than 90 degrees, which will be! Method to visualise the head/tailwind component too adjust the column widths to see what your answer adds to already answers! Has the advantage of being able to use whilst in-flight AWA before the. Land features wind correction angle formula excel to convert my own writing critically about the true wind to... Calculate our base ( WCAmax ). UK employer ask me to try holistic medicines for chronic! Best answers are voted up and rise to the above, this is the same side of inbound... If you need to, you can adjust the column widths to see all the data. respectively. Especially pilots of taildraggers. The hold screen allows you to set the inbound radial, course or bearing to the fix and to set if the turns in the holding pattern are standard right-hand turns or non-standard left-hand turns.Entering information is easy. If we use the table on the right, 50o is going to be a factor of 3/4 or 0.75. @quietflyer Even better, since it gives you your current Track, the difference between it and your heading is the WCA, which you can directly apply to your desired course. Uniformly Lebesgue differentiable functions, Fantasy novel with 2 half-brothers at odds due to curse and get extended life-span due to Fountain of Youth. In this example, the exact WCA turns out to be 16o. Why can a transistor be considered to be made up of diodes? Mentally Calculating the Wind Correction Angle, by Luiz Roberto Monteiro de Oliveira 2010 Luiz Roberto Monteiro de Oliveira, - Method for estimating the wind correction angle (WCA), - Comparing the mental estimation method with the exact formula, - Techniques for visualization of wind during flight. The 1 in 60 rule combined with Speed/Distance/Time assumptions is the basis of many other rules of thumb that can be useful in pilot navigation (or to check that an FMS-calculated track makes sence. It is very well illustrated in this article. The reason we used 10 knots for wind speed (WS) when we calculated WCAmax is that it is an easy number to work with later when we have other wind speeds. Both start with a "max drift" calculation which is pretty easy to do: $$\text{max drift} = {60 \over \text{TAS}} \times \text{wind speed}$$. INSTRUCTIONS: Choose units and enter the following: Navigation Correction Angle (): The calculator returns the angle in degrees. Improving the copy in the close modal and post notices - 2023 edition. I use this web site for E6B:http://www.csgnetwork.com/e6bcalc.html. If at this point the aircraft is on the correct heading to maintain course (keep the needle centered), the difference between the course and this heading will be the wind correction angle (WCA). Step 1: Most aircraft have a typical cruising speed. Connect and share knowledge within a single location that is structured and easy to search. Scooter14 Supreme User 934 Posted February 22, 2005 Sundowner, Your high school geometry teacher called. wind Begin by rounding the WS to the nearest multiple of 5, so for a WS of 40 knots, we already have it as a multiple of 5. You cannot paste images directly. use the angle that makes you move parallel to the runway @ratchetfreak, that is fbf? d) WS = 10 knots; AWA = 70o The wind is constantly changing anyway, so you need to make constant corrections to compensate for the wind. WebMove the sliding card so the wind dot is on the 98-kt. . WebEstimate the wind correction angle (WCA) for the following conditions: a) WS = 10 knots; AWA = 40 o b) WS = 20 knots; AWA = 40 o c) WS = 5 knots; AWA = 40 o d) WS = 10 knots; The holding pattern computer calculates which way to turn, left or right, which course and heading to maintain, and how long to fly a heading before initiating a turn. For example: for an AWA of 33o use the 30o correction factor which is 1/2 or 0.5 (see figure 2b). Our Holding Pattern Computer App employs a sophisticated patented analytic solution developed by 51-year Aerospace Industry veteran and FAA Safety Team Representative Les Glatt, Ph.D., ATP/CFI-AI, AGI/IGI. 8 degrees max drift) headwind from 30 degrees off track, the expected drift angle is just over 4 degrees. CRS line: An imaginary line passing through the aircraft in both the CRS direction and its reciprocal (CRS+180o). The first image is from the Airfoillabs Cessna 172 Footer Panel that can be displayed in XPlane. The wind correction computer on the back uses concentric circular discs only, no slidey bit, so it's easy to manipulate with one hand. WebThis article describes the formula syntax and usage of the DEGREES function in Microsoft Excel. Fig 12Visualizing a left tail wind using a VOR instrument and the heading indicator. Note: the dot (.) This formula can do the same Enjoy: Don't forget that PI in Excel is written as PI(). The "Entry Pattern" sub-tab on the answer screen graphically depicts the recommended Entry Procedure and lists the steps necessary to fly it. AWA: acute wind angle (WD to CRS line). The method I use is to determine the difference between your course and the wind direction. speed arc, which is the TAS. My point was just to share the calculation, the maths. The angle in radians that you want to convert. I believe it would be a trigonometric function. i) WS = 12 knots; AWA = 20o February 2005, 23:19: Message edited by: in the formula above means multiply. Lets now calculate WCA given: WS = 40 knots; AWA = 50o. What is the maximum angle between an airplane and runway centerline when touching down at a crab angle in a crosswind landing? No computation required. This result we got using mental estimation was 10o so we are off by 1o. On a very foggy take-off if you think you are lined up on the C/`L lights and you see half a dot deviation on the ILS, you must be looking at the edge lights! To subscribe to this RSS feed, copy and paste this URL into your RSS reader. The WCA calculated by the formula is 13o. The WCA calculated by the formula is 1o. . Aviation Stack Exchange is a question and answer site for aircraft pilots, mechanics, and enthusiasts. Converts radians into degrees. rev2023.4.5.43377. HDG = 040 + 16o = 056. I can just make a mental image of the wind dial and make a close enough guess. Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet.

The wind correction angle (WCA) is the angle between the course (CRS) and the heading (HDG) that is required for the aircraft to track that course when there is wind (see figure 1). We will use the less precise table on the right for our examples. works if the wind correction angle is less than 90 degrees, which will always be the case if WS < TAS. The results of this analysis can have a major impact on how we train IFR Pilots on flying holding patterns in the future." , . Heading should be 67 degree but I think you are somewhere close. Below are a few other examples of how to visualize wind correction angle (WCA) and acute wind angle to course line (AWA), for winds that are coming from other directions. Gosh these are all coming out of the woodwork..and free too. Site design / logo 2023 Stack Exchange Inc; user contributions licensed under CC BY-SA. j) WS = 48 knots; AWA = 70o There are 2 methods to use whilst in-flight. AWA = 50o The following are a few suggestions on how to do this and figure out what the AWA is. For landing you would fly whatever keeps you aligned with the runway / ILS. Returns the argument (theta), an angle expressed in radians, such that: The IMARGUMENT function syntax has the following arguments: InumberRequired. I don't know enough about Datarefs sorry There are also up and side draughts off land features.