radar ligne EWR en radians (XLS) - Fichier XLS

Fichier partagé
radar ligne EWR en radians (XLS)

Aperçu texte

Simulation
1.0 2.0 3.0 4.0 5.0 6.0 7.0 8.0 9.0 10.0 11.0 12.0 13.0 14.0 15.0 16.0 17.0 18.0 19.0 20.0 21.0 22.0 23.0 24.0 25.0 26.0 27.0 28.0 29.0 30.0 31.0 32.0 33.0 34.0 35.0
 Pente avion    Vitesse avion    Temps  Radar    Ecart Az    Ecart min  Coordonnées de départ             
 a radian sin a cos a a Va rd/s    pas s  Vrot t/mn Az dép. en radians l rayon  1.2621381717536906e-09    6.2831853071796  Longitude 0.001471653980583687            
 0.6108652381980153 0.573576436351046 0.8191520442889918 0.7002075382097097 4.4257691395e-05    1e-08  12.5 1.8595450908700755 0.0035      fin  Latitude -0.00043715575052438727            
 35.0 °         1.3089969389957472 rd/s       42.81771689999114               
 Trajectoire avion: y=at+b        Position azimut radar                         
 y a t b     yray xray t pos° pos° rect Ar Nt coef multi                  
 -0.00043715575052438727 0.7002075382097097 0.0 -0.00043715575052438727     -0.0009966355 0.0033551032 0.0 3.430341417664976 3.430341417664976 -0.2887487535197557 0.0 0.0                  
 y = Rapport.pente . t  + Lat.départ        0.0007352864 0.0034218933 42.81771689999114 59.478601774539854 2.92993400992345 0.21165865670639974 9.466313480612374 9.0                  
                       Résultat simulation    Azimut radar       
 Plots avion       Contrôle   Coordonnées EWR            xd yd Ecart AZ t xr yr      
 Parcours t xd yd Aza range  xd yd  Latitude 0.7098817460143475                      
 0.0 0.0 0.001471653980583687 -0.00043715575052438727 -0.2887487640751754 0.0015352102751038214  0.001471653980583687 -0.00043715575052438727  Longitude -1.2947876550498993                      
 0.001895013300798284 42.81771689999114 0.0030239579998874314 0.0006497792253853253 0.21165865544426157 0.0030929815755716275  0.0030239579998874314 0.0006497792253853253                         
        Ramené à la latitude réelle                          
        -1.2933160010693157 0.7094445902638231 parcours en nm Vitesse                       
        -1.291763697050012 0.7105315252397328 5.511918523357143 463.42748097551697 kts                      
 10 derniers plots officiels          858.2676947666574 km/h                      
 415.0 0.376371527777778                                
 415.0 0.376423611111111 4.5 4.5                              
 416.0 0.376476851851852 4.6 9.1                              
 417.0 0.376528935185185 4.5 13.6                              
 418.0 0.376582175925926 4.6 18.2                              
 419.0 0.376634259259259 4.5 22.7                              
 420.0 0.3766875 4.6 27.299999999999997                              
 421.0 0.376740740740741 4.6 31.9                              
 422.0 0.376793981481481 4.6 36.5                              
 423.0 0.376847222222222 4.6 41.1                              
  h:mn:ss s s s                              
Données radar EWR et carte
 Données radar        Coordonnées polaires   Calcul des latitudes des plots radar EWR     Calcul des longtitudes des plots radar EWR      Coordonnées EWR   
 n° timing écart range  azimut altitude  range azimut  b écart de lat. écart en rd latitude  c écart de long. rayon de la latitude C Longitude  Latitude 40.673228 0.7098817460143475 radians
 415.0 0.376371527777778  4.0 8.0 1417.0 62.0  4.125 1.9439654468715049  -1.1976272067182852 1.5038441072305746 0.00043715575052441437 0.7094445902638231  2.768423533513185 -3.8411037347548835 2610.0590121267937 -0.001471653980583749 -1.2933160010693157  Longitude -74.185868 -1.2947876550498993 radians
 415.0 0.376423611111111 5.20833333333415e-05 4.0 28.0 1337.0 56.0  4.4375 1.8212469838406535  -1.3203456697491365 1.0997925796361554 0.00031970112344783776 0.7095620448908997  2.891141996544037 -4.299053678634088 2609.795789920581 -0.001647275888495825 -1.2931403791614036     
 416.0 0.376476851851852 5.3240740740701e-05 4.0 51.0 1267.0 50.0  4.796875 1.7138683286886585  -1.4277243249011315 0.6839595285340712 0.00019882169939493155 0.7096829243149526  2.9985206516960314 -4.747863638411751 2609.5248549644525 -0.0018194360668300387 -1.2929682189830694  Déclinaison magnétique   
 417.0 0.376528935185185 5.2083333333397e-05 5.0 13.0 1208.0 45.0  5.203125 1.6233634622034057  -1.5182291913863843 0.27338742707017044 7.947159236131836e-05 0.7098022744219862  3.0890255181812845 -5.19593774792818 2609.257310357137 -0.001991347395024447 -1.292796307654875  0.22968532956245 radians ouest  
 418.0 0.376582175925926 5.3240740740701e-05 5.0 41.0 1157.0 40.0  5.640625 1.545130442021238  -1.596462211568552 -0.14475573740441827 -4.20793636278425e-05 0.7099238253779754  3.167258538363452 -5.638767255980114 2608.984793951536 -0.0021612878959864335 -1.2926263671539129     
 419.0 0.376634259259259 5.20833333333415e-05 6.0 7.0 1114.0 32.0  6.109375 1.4791692681421553  -1.6624233854476347 -0.5590011106768104 -0.00016249726212108935 0.7100442432764686  3.233219712242535 -6.0837472538631205 2608.714779843528 -0.0023320860144887233 -1.2924555690354107  Rayon moyen terrestre :   
 420.0 0.3766875 5.32407407407565e-05 6.0 38.0 1078.0 24.0  6.59375 1.4239459597782722  -1.7176466938115178 -0.9648181410484228 -0.00028046510708235625 0.7101622111214299  3.288443020606418 -6.522780466733786 2608.450222831032 -0.002500634441723948 -1.2922870206081754  3440.06479481639 nm  
 421.0 0.376740740740741 5.3240740740701e-05 7.0 8.0 1045.0 17.0  7.125 1.373324593778046  -1.768268059811744 -1.397859653095831 -0.0004063468964893262 0.7102880929108368  3.339064386606644 -6.986530855170306 2608.167877816156 -0.0026787121007794163 -1.29210894294912     
 422.0 0.376793981481481 5.32407407407565e-05 7.0 42.0 1017.0 12.0  7.65625 1.330373131717248  -1.811219521872542 -1.8230577903703657 -0.0005299486780357779 0.7104116946923833  3.382015848667442 -7.4360355267756635 2607.8906065033734 -0.002851360217423309 -1.291936294832476  Offset départ radar   
 423.0 0.376847222222222 5.32407407389251e-05 8.0 12.0 989.0 10.0  8.1875 1.28742166965645  -1.85417098393334 -2.289202905156117 -0.000665453426518468 0.710547199440866  3.42496731072824 -7.860960902397662 2607.5865879227786 -0.0030146499981271026 -1.2917730050517722  Latitude -0.00043715575052438727  
  h:mn:ss s s nm 1/64 360/4096 ft/100  nm radians  radians nm radians radians  radians nm nm radians radians  Longitude 0.001471653980583687  
  0.0004756944444440081                        
                 Coordonnées simulation         
                 -1.2933160010693157 0.7094445902638231 Distance parcourue  Temps  Vitesse   
                 -1.2947876550498993 0.7098817460143475 4.1243284717580275 nm 0.0 s 7 kts  
                   7.638256329695867 km   7 kts  
                       7 km/h  
                 Coordonnées officielles         
                 -1.2933160010693157 0.7094445902638231 Distance parcourue  Temps  Vitesse   
                 -1.2931403791614036 0.7095620448908997 0.6110253031586425 nm 4.5 s 488.820242526914 kts  
                 -1.2929682189830694 0.7096829243149526 1.223118579318164 nm 9.1 s 483.87108632366926 kts  
                 -1.292796307654875 0.7098022744219862 1.831218766590175 nm 13.6 s 484.73437939151694 kts  
                 -1.2926263671539129 0.7099238253779754 2.4405931313256364 nm 18.2 s 482.7546853171589 kts  
                 -1.2924555690354107 0.7100442432764686 3.0489758285365456 nm 22.7 s 483.53801686042135 kts  
                 -1.2922870206081754 0.7101622111214299 3.647304583168376 nm 27.299999999999997 s 480.9632417364891 kts  
                 -1.29210894294912 0.7102880929108368 4.282324064033521 mn 31.9 s 483.2716812075447 kts  
                 -1.291936294832476 0.7104116946923833 4.9015845156999545 nm 36.5 s 483.4439522334202 kts  
                 -1.2917730050517722 0.710547199440866 5.530919884404028 nm 41.1 s 484.46013586020683 kts  
                   10.24326362591626 km   483.9841579397046 kts  
                       896.3386605043329 km/h  
 Simulation avec alignement sur 8 plots officiels - Vitesse trouvée: 463 454 kts - distance parcourue jusqu'au plot 8: 4 282 nm - Temps de parcours: 33 26 s                         
 Etude réalisée avec un pas de 10 ns pour trouver les points de rencontre avion fictif / azimut radar                         
Sheet3
radar ligne EWR en radians (XLS) - Fichier XLS

radar ligne EWR en radians (XLS)

Aperçu texte

Sur le même sujet

Partager le fichier

Lien court

Code HTML

Code BB

Lien permanent
