{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Main","Horn Calculator","Calculations"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Main","index":0,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[[14,0,15,0],[16,0,17,0],[22,0,31,0],[3,0,5,0],[1,0,2,0],[6,0,8,0],[9,0,10,0],[11,0,13,0]]}
["Stage","Parameter","Symbol","Unit","Value"]
[null,"Frequency",null,"GHz",28]
[null,"Bandwidth",null,"MHz",800]
["DUT"]
[null,"Equivalent Isotropically Radiated Power","EIRP","dBm",30]
[null,"Tx SNR","SNR_In","dB",114.96910013008058]
["OTA"]
[null,"Distance","d","m",1]
[null,"Free Space Path Loss","FSPL","dB",{"$f":"20*LOG10((4*PI()*E2*1000000000*E8)/300000000)","v":61.384932812893062}]
["Rx Antenna"]
[null,"Antenna Gain","G_Rx","dBi",10]
["LNA"]
[null,"Gain","G_LNA","dB",15]
[null,"Noise Figure","NF_LNA","dB",2]
["Rx Cable"]
[null,"Cable Loss","A_Rx","dB",4]
["Receiver"]
[null,"DANL","DANL_RX","dBm/Hz",-144]
[]
[]
[]
[]
["Results"]
[null,"Rx Power","P_Rx","dBm",-10.384933471679688]
[null,"Rx Noise Power","N_Rx","dBm",-54.427345275878906]
[null,"Rx SNR","SNR_Rx","dB",44.042411804199219]
[]
[null,"Total Gain","G_tot","dB",-40.384932812893062]
[null,"Total Noise Figure","NF_tot","dB",70.926686816818915]
[]
[null,"Target System SNR",null,"dB",40]
[null,"Resulting Margin",null,"dB",4.0424118041992188]
[]
[]
[]
[]
[]
[null,"Antenna Parameters"]
[null,"Aperture Diagonal","D","m",3.3000000000000002E-2]
[null,"Wavelength","l","m",{"$f":"300000000/(E2*1000000000)","v":1.0714285714285714E-2}]
[null,"Far Field Distance","d_f","m",{"$f":"(2*E39^2)/E40","v":0.20328000000000002}]

{"sheet":"Horn Calculator","index":1,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":false,"merged":[[3,14,3,16]]}
["Source: Balanis, \"Modern Antenna Handbook\", p.118-119"]
[]
["Inputs:",null,"WR-28","WR-22","WR-19","WR-15","WR-12","WR-10",null,null,null,"Waveguide Frequency Ranges, Dimensions and Designations"]
["Frequency Range","GHz","26,5 - 40","33 - 50","40 - 60","50 - 75","60 - 90","75 - 110",null,null,null,"Range","Internal","Internal","Official Designations"]
["Waveguide width","a [m]",7.1000000000000004E-3,5.7000000000000002E-3,4.7999999999999996E-3,3.8E-3,3.0999999999999999E-3,3.8E-3,null,null,null,"GHz","(inches)","(mm. approx)","I.E.C.","U.K. (RCSR)","U.S. (EIA)"]
["Waveguide height","b [m]",3.5999999999999999E-3,2.8999999999999998E-3,2.3999999999999998E-3,1.9E-3,1.5499999999999999E-3,1.9E-3,null,null,null,"8.2 - 12.4","0.9 x 0.4","23.0 x 10.0","R100","WG16","WR90"]
["Target gain","G_dBi [dBi]",15,20,20,15,20,20,null,null,null,"10.0 - 15.0","0.75 x 0.375","19.0 x 9.5","R120","WG17","WR75"]
["Frequency","f [GHz]",28,42,50,62,86,92,null,null,null,"12.4 - 18.0","0.622 x 0.311","16.0 x 7.9","R140","WG18","WR62"]
["Outputs:",null,null,null,null,null,null,null,null,null,null,"15.0 - 22.0","0.510 x 0.255","13.0 x 5.8","R180","WG19","WR51"]
["Gain linear","G_l [i]",{"$f":"10^(C7/10)","v":31.622776601683803},100,100,31.622776601683803,100,100,null,null,null,"18.0 - 26.5","0.420 x 0.170","11.0 x 4.3","R220","WG20","WR42"]
["Free-space wavelength","lambda_0 [m]",{"$f":"300000000/C8/1000000000","v":1.0714285714285714E-2},7.1428571428571426E-3,6.0000000000000001E-3,4.8387096774193551E-3,3.4883720930232558E-3,3.2608695652173911E-3,null,null,null,"22.0 - 33.0","0.340 x 0.170","8.6 x 4.3","R260","WG21","WR34"]
["Aperture width","A [m]",{"$f":"0.096*C5*(C10^0.232)+0.42*C11*(C10^0.503)-0.193*C6","v":2.6393029017938389E-2},3.1450385979106439E-2,2.6428625368569426E-2,1.1993490777380919E-2,1.5422060182106579E-2,1.4581307278890442E-2,null,null,null,"26.5 - 40.0","0.280 x 0.140","7.1 x 3.6","R320","WG22","WR28 "]
[null,"R_H [m]",{"$f":"C12*SQRT(1/4+(C12/3/C11)^2)","v":2.5373465775063074E-2},4.8764310954816023E-2,4.099231032314412E-2,1.1582487320689377E-2,2.3999442167106581E-2,2.2924164028931722E-2,null,null,null,"33.0 - 50.0","0.224 x 0.112","5.7 x 2.9","R400","WG23 ","WR22"]
[null,"L_H [m]",{"$f":"(C12-C5)*SQRT((C13/C12)^2-0.25)","v":1.5841823657780564E-2},3.7793446980513845E-2,3.1756379839058789E-2,6.7696116405895207E-3,1.815857068650541E-2,1.6069901106389835E-2,null,null,null,"40.0 - 60.0","0.188 x 0.094","4.8 x 2.4","R500","WG24","WR19"]
[null,"D_H [m]",{"$f":"SQRT(C13^2-(C12/2)^2)","v":2.1671750511965172E-2},4.6159249650956156E-2,3.8804013270677298E-2,9.9092410040905708E-3,2.272692762489387E-2,2.1733928911612167E-2,null,null,null,"50.0 - 75.0","0.148 x 0.074","3.8 x 1.9","R620","WG25","WR15"]
["Aperture height","B [m]",{"$f":"0.5*(C6+SQRT(C6^2+8*C14*C11))","v":2.0312364781669128E-2},2.4731084283939872E-2,2.075803052632615E-2,9.0995319322880412E-3,1.2057212879749755E-2,1.1231352190629391E-2,null,null,null,"60.0 - 90.0","0.122 x 0.061","3.1 x 1.6","R740","WG26","WR12"]
[null,"R_E [m]",{"$f":"C16/2*SQRT(1+(C16/C11)^2)","v":2.1768696458134097E-2},4.4563808089086526E-2,3.7377900053517502E-2,9.6906205073455376E-3,2.1691850892383627E-2,2.0140694097776243E-2,null,null,null,"75.0 - 110.0","0.100 x 0.050","2.4 x 1.3","R900","WG27","WR10"]
[null,"L_E [m]",{"$f":"(C16-C6)*SQRT((C17/C16)^2-0.25)","v":1.5841823657780561E-2},3.7793446980513852E-2,3.1756379839058796E-2,6.7696116405895198E-3,1.8158570686505414E-2,1.6069901106389832E-2,null,null,null,"90.0 - 140.0","0.080 x 0.040","2.0 x 1.0","R1200","WG28","WR8"]
[null,"D_E [m]",{"$f":"SQRT(C17^2-(C16/2)^2)","v":1.9254300941100977E-2},4.2813857090153645E-2,3.5907985944324025E-2,8.5561530766287402E-3,2.0837281481289816E-2,1.9341968377926531E-2,null,null,null,"110.0 - 170.0","0.065 x 0.0325","1.7 x 0.82",null,"WG29","WR7"]
["Aperture diagonal","D [m]",{"$f":"SQRT(C12^2+C16^2)","v":3.3304416280207194E-2},4.000941524309138E-2,3.3606071924640039E-2,1.5054743518700373E-2,1.9575911797107194E-2,1.840537405192785E-2,null,null,null,"140.0 - 220.0","0.051 x 0.0255","1.3 x 0.65",null,"WG30","WR5"]
[null,null,null,null,null,null,null,null,null,null,null,"170.0 - 260.0","0.043 x 0.0215","1.1 x 0.55",null,"WG31","WR4"]
[null,null,null,null,null,null,null,null,null,null,null,"220.0 - 325.0","0.034 x 0.017","0.87 x 0.44",null,"WG32","WR3"]

{"sheet":"Calculations","index":2,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Stage","Pout","Limit","Nsys","SNR"]
["DUT",30,-10,-84.969100130080577,114.96910013008058]
["OTA path",-31.384933471679688,-71.384933471679688,-84.969100952148438,53.58416748046875]
["Rx Antenna",-21.384933471679688,-61.384933471679688,-74.969100952148438,53.58416748046875]
["LNA",-6.3849334716796875,-46.384933471679688,-59.722236633300781,53.337303161621094]
["Rx Cable",-10.384933471679688,-50.384933471679688,-63.702667236328125,53.317733764648438]
["Receiver",-10.384933471679688,-50.384933471679688,-54.427345275878906,44.042411804199219]
[null,1.9952011108398438,-33.004798889160156,-37.520038604736328,39.515239715576172]