{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Français","English"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":61,"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":"Français","index":0,"n_rows":59,"n_cols":21,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Calculateur pour Antenne a Fente"]
[null,null,null,"from W1GHZ  modifs F1CHF (Mai 2008)"]
[]
["Parametres",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard WG sizes","Width","Height"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G21","v":8.8924152516019959},null,null,null,null,"Pick from list",0,0]
["ENTREZ vos Paramétres  dans les cases jaunes (résultats dans les cases Vertes)",null,null,null,null,null,null,null,null,"Choisir\nguide d'ondes ordinaire ",null,null,null,"ou",null,null,null,null,"WG10 / WR284",72.14,34.04]
["Frequence"," "," ",10.686,null,null,null,null,null,"WG16 / WR90",null,null,null,{"$f":"G22","v":26.677245754805988},null,null,null,null,"WG11A / WR229",58.17,29.08]
["Dimensions INTERNES grand coté",null," ",null,null,null,{"$f":"IF(D9=\"\",(VLOOKUP($J$8,$S$6:$U$16,2,FALSE)),D9)","v":22.86},null,null,null,null,null,null,null,null,null,null,null,"WG12 / WR187",47.55,22.15]
["Dimensions INTERNES petit coté",null," ",null,null,null,{"$f":"IF(D10=\"\",(VLOOKUP($J$8,$S$6:$U$16,3,FALSE)),D10)","v":10.16},null,null,null,null,null,null,null,null,null,null,null,"WG13 / WR159",40.39,20.190000000000001]
["Nombre TOTAL de fentes",null,null,22,{"$f":"IF(D12=\"Yes\",1,2)","v":2},{"$f":"IF(Cotes=1,\"coté\",\"cotés\")","v":"cotés"},null,null,null,null,null,null,null,null,null,null,null,null,"WG14 / WR137",34.840000000000003,15.8]
["Seul côté?",null,null,"Non",null,null,null,null,null,null,null,{"$f":"G18","v":13.597050243549329},null,null,null,null,null,null,"WG15 / WR112",28.5,12.62]
["Estimation des Performances","Gain ="," ",{"$f":"10 * LOG((Nslots/Cotes) * lam_guide/lam_zero)","v":11.441663264847822},null,null,"Beamwidth=",null,{"$f":"50.7 * lam_zero/((Nslots_en/Cotes)*(lam_guide/2))","v":10.004014825845223},"deg",null,null,null,null,null,null,null,null,"WG16 / WR90",22.86,10.16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WG17 / WR75",19.05,9.5299999999999994]
["RESULTATS des CALCULS :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WG20 / WR42",10.67,4.32]
[null,"old from KB7TRZ",null,null,null,null,"improved from Elliott",null,null,null,null,null,null,null,null,null,null,null,"...",0,0]
["Offset  from centerline ",{"$f":"Slot_disp","v":1.9564537883465969},"mm",null,null,null,{"$f":"New_slot_disp","v":2.1547163898347006},"mm",null,null,null,null,null,null,{"$f":"G20","v":17.784830503203992}]
["Longeur de la fente",{"$f":"lam_zero/2","v":14.03705783267827},"mm",null,null,null,{"$f":"New_slot_len","v":13.597050243549329},"mm",null,null,null,{"$f":"G19","v":1.5874999999999999}]
["Largeur de la fente",{"$f":"lam_guide/20","v":1.7784830503203992},"mm",null,null,null,{"$f":"((WG_a/25.4)*0.0625/0.9)*25.4","v":1.5874999999999999},"mm",null,null,null,{"$f":"G17","v":2.1547163898347006},null,null,null,null,null,null,"Non"]
["Slot spacing center to center ",{"$f":"lam_guide/2","v":17.784830503203992},"mm",null,null,null,{"$f":"lam_guide/2","v":17.784830503203992},"mm",null,null,null,null,null,null,null,null,null,null,"Oui"]
["End space = 1/4 wave ",{"$f":"lam_guide/4","v":8.8924152516019959},"mm",null,null,null,{"$f":"lam_guide/4","v":8.8924152516019959},"mm"]
["End space = 3/4 wave ",{"$f":"3*lam_guide/4","v":26.677245754805988},"mm",null,null,null,{"$f":"3*lam_guide/4","v":26.677245754805988},"mm"]
["End space = distance entre haut (fermé ou avec charge) et l'axe de la derniere fente",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fully round end slots"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rounded corners on slot ends"]
["Wavelength - free space (Lo)",{"$f":"300/FGhz","v":28.07411566535654},"mm"]
["Wavelength - cutoff",{"$f":"2*WG_a","v":45.72},"mm","frequence basse =",null,null,{"$f":"(300/lam_cutoff)*1.2","v":7.8740157480314963},"ghz"]
["Guide wavelength (Lg)",{"$f":"1/SQRT(((1/lam_zero)^2)-((1/lam_cutoff)^2))","v":35.569661006407983},"mm"]
[null,null,null,null,null,null,null,null,null,null,null,"Minimum",{"$f":"B27","v":35.569661006407983}]
[]
["INTERMEDIATE TERMS -- ne pas toucher !"]
["Gslot",{"$f":"1/Nslots","v":4.5454545454545456E-2},null,null,null,null,{"$f":"1/Nslots","v":4.5454545454545456E-2},"enter taper admittance here"]
["G1",{"$f":"2.09*(lam_guide/lam_zero)*(WG_a/WG_b)*(COS(PI()*lam_zero/2/lam_guide)^2)","v":0.62931658439296767},null,null,null,null,{"$f":"2.09*(lam_guide/lam_zero)*(WG_a/WG_b)*(COS(0.464*PI()*lam_zero/lam_guide)-COS(0.464*PI()))^2","v":0.51904674006200913},null,null,null,null,{"$f":"B55","v":4.4462076258009979}]
["Y",{"$f":"G_slot/G_1","v":7.222842458282018E-2},null,null,null,null,{"$f":"G_2_slot/New_G1","v":8.7573125782689859E-2},null,null,null,null,"ou"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"D55","v":8.8924152516019959}]
["Offset calculation: Mathcad from KB7TRZ:",null,null,null,null,null,"New offset calc from Elliott:"]
["OFFSET",{"$f":"(WG_a/PI())*SQRT(ASIN(Y))","v":1.9564537883465969},"mm",null,null,null,{"$f":"(WG_a/PI())*SQRT(ASIN(New_Y))","v":2.1547163898347006},"mm",null," "]
["CORRECTED OFFSET **"]
[null,{"$f":"(WG_a/PI())*ASIN(SQRT(Y))","v":1.9799432307831124},"mm",{"$f":"B38/25.4","v":7.7950520896972936E-2},"inches",null,{"$f":"(WG_a/PI())*ASIN(SQRT(New_Y))","v":2.1860721793300981},"mm",{"$f":"G38/25.4","v":8.6065833831893632E-2},"inch",null,"Minimum",{"$f":"B27","v":35.569661006407983}]
[]
["Offset calculation: BASIC from W6OYJ:"]
["AG",{"$f":"ATAN(Y/SQRT(1-Y^2))","v":7.2291374434661257E-2},"mm"]
["Offset",{"$f":"(WG_a/PI())*SQRT(AG)","v":1.9564537883465969},"mm",null,null,null,null,null,null,null,null,null,null,null,{"$f":"B54","v":4.2683593207689583}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ou"]
["Slot Length Calculation from Stegen curves:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D54","v":22.05318982397295}]
["Slot in wavelengths",null,null,null,null,null,{"$f":"0.210324*G_2_slot^4-0.338065*G_2_slot^3+0.12712*G_2_slot^2+0.034433*G_2_slot+0.48253","v":0.48432692967522711}]
["Slot Length",null,null,null,null,null,{"$f":"lam_zero*Slot_wl","v":13.597050243549329},"mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"diam",{"$f":"B52","v":0.96038084717301553},"mm"]
["* Correction tested on CNC machining and measurement by Dan Welch W6DFW",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
["** correction from Petr Kauler kauler@volzny.cz"]
[]
["calculs pour le  PROBE",null,null,null,null,null,"FORMULES :"]
["diamètre du probe(diam)",{"$f":"lam_guide*0.027","v":0.96038084717301553},"mm",null,null,null,"Diamètre du probe = 0,027 Lg ",null,null,null,null,null,null,null,{"$f":"B53","v":5.6911457610252771},"mm"]
["longueur du probe (long)",{"$f":"lam_guide*0.16","v":5.6911457610252771},"mm",null,null,null,"Longueur du probe = 0,160 Lg",null,null,null,null,null,null," "," "]
["distance par rapport au fond ",{"$f":"lam_guide*0.12","v":4.2683593207689583},"mm",{"$f":"lam_guide*0.62","v":22.05318982397295},"mm",null,"Distance du fond = 0,120 Lg (ou 0,620 Lg)"]
["espacement vis de réglages",{"$f":"lam_guide/8","v":4.4462076258009979},"mm",{"$f":"lam_guide/4","v":8.8924152516019959},"mm",null,"Match =  3 vis espacées de Lg/8 ou Lg/4 "]
["longueur MAXI  de l'antenne",{"$f":"G22+(G20*((D11/2)-1))+(G18/2)+B27+(2*D55)+B27+D54","v":322.30141824861346},"mm",null,null,null,"taille MAXI avec les plus grandes cotes"]
["longueur MINI  de l'antenne",{"$f":"G21+(G20*((D11/2)-1))+(G18/2)+B27+(2*B55)+B27+B54","v":277.83934199060349},"mm",null,null,null,"a vous de calculer pour optimiser la facture !"]
["le fond peut être réglable ainsi que le haut de l'antenne, mais en tout état de cause , les extrémités sont closes !"]
["il semble conseillé de prolonger le bas de l'antenne et de coller une cale pour faciliter les réglages "]

{"sheet":"English","index":1,"n_rows":59,"n_cols":21,"rows_kept":59,"cut":false,"hidden":false,"merged":[[22,4,22,7]]}
[]
[null,"Slotted Waveguide Antenna Calculator"]
[null,null,null,"from W1GHZ  modifs F1CHF (Mai 2008)"]
[null,null,null,"Modifications translated by GM4ISM and added standard WG selection "]
["Parameters",null,null,"Added  Single face selection and estimated correction for slot ends with macro driven graphic changes (2020)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Standard WG sizes","Width","Height"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(E21,2)","v":19.600000000000001},null,null,null,null,"Pick from list",0,0]
["ENTER your parameters in Yellow cells, results in Green cells",null,null,null,"WG Dimension will be red is  not suited to the frequency ",null,null,null,null,"Pick Standard Waveguide",null,null,null,"or",null,null,null,null,"WG10 / WR284",72.14,34.04]
["Frequency"," "," ",5.7601000000000004,null,null,"Dimensions for calculations",null,null,"WG14 / WR137",null,null,null,{"$f":"ROUND(E22,3)","v":58.8},null,null,null,null,"WG11A / WR229",58.17,29.08]
["Waveguide intenal dimensions, broad face","Enter here or",null,null,null,null,{"$f":"IF(D9=\"\",(VLOOKUP($J$8,$S$6:$U$16,2,FALSE)),D9)","v":34.840000000000003},null,null,null,null,null,null,null,null,null,null,null,"WG12 / WR187",47.55,22.15]
["Waveguide intenal dimensions, narrow face","pick Standard",null,null,null,null,{"$f":"IF(D10=\"\",(VLOOKUP($J$8,$S$6:$U$16,3,FALSE)),D10)","v":15.8},null,null,null,null,null,null,null,null,null,null,null,"WG13 / WR159",40.39,20.190000000000001]
["TOTAL number of slots ",null,null,16,{"$f":"IF(D12=\"Yes\",1,2)","v":1},{"$f":"IF(Faces=1,\"face\",\"faces\")","v":"face"},null,null,null,null,null,null,null,null,null,null,null,null,"WG14 / WR137",34.840000000000003,15.8]
["Single face?",null,null,"Yes",null,null,null,null,null,null,null,{"$f":"ROUND(J18,3)","v":24.76},null,null,null,null,null,null,"WG15 / WR112",28.5,12.62]
["Performance estimates","Gain ="," ",{"$f":"10 * LOG((Nslots_en/Faces) * lam_guide_en/lam_zero_en)","v":13.817451113599336},null,null,"Vertical Beamwidth=",{"$f":"50.7 * lam_zero_en/((Nslots_en/Faces)*(lam_guide_en/2))","v":4.2101041892241486},"deg",null,null,null,null,null,null,null,null,null,"WG16 / WR90",22.86,10.16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WG17 / WR75",19.05,9.5299999999999994]
["Calculation Results",null,null,null,null,null,null,"Subtract",{"$f":"VLOOKUP(J15,S23:T25,2,FALSE)","v":2},"Square end slots",null,null,null,null,null,null,null,null,"WG20 / WR42",10.67,4.32]
[null,"old from KB7TRZ",null,null,"improved from Elliott",null,null,null,null,{"$f":"IF(J15=\"Rounded corners on slot ends\",\"based on radius 2/5 slot width\",\"\")","v":""},null,null,null,null,null,null,null,null,"...",0,0]
["Offset  from centerline ",{"$f":"slot_disp_en","v":2.0921000281839714},"mm",null,{"$f":"New_slot_disp_en","v":2.3200204719880988},"mm",{"$f":"$E17/25.4","v":9.1339388660948775E-2},"inch",null,"corrected for slot end shape",null,null,null,null,{"$f":"ROUND(E20,2)","v":39.200000000000003}]
["Slot Length",{"$f":"lam_zero_en/2","v":26.04121456224718},"mm",null,{"$f":"New_slot_len_en","v":25.265149852736588},"mm",0.99469093908411765,"inch",null,{"$f":"E18*((100-I15)/100)","v":24.759846855681857},null,{"$f":"ROUND(E19,2)","v":2.42}]
["Slot Width",{"$f":"lam_guide_en/20","v":3.920002685697308},"mm",null,{"$f":"((WG_a_en/25.4)*0.0625/0.9)*25.4","v":2.4194444444444447},"mm",9.5253718285214367E-2,"inch",null,null,null,null,null,null,null,null,null,null,"No "]
["Slot spacing center to center ",{"$f":"lam_guide_en/2","v":39.200026856973082},"mm",null,{"$f":"lam_guide_en/2","v":39.200026856973082},"mm",1.5433081439753182,"inch",null,null,null,{"$f":"ROUND(G38,2)","v":2.34},null,null,null,null,null,null,"Yes"]
["End space = 1/4 wave ",{"$f":"lam_guide_en/4","v":19.600013428486541},"mm",null,{"$f":"lam_guide_en/4","v":19.600013428486541},"mm",0.77165407198765912,"inch"]
["End space = 3/4 wave ",{"$f":"3*lam_guide_en/4","v":58.800040285459623},"mm",null,{"$f":"3*lam_guide_en/4","v":58.800040285459623},"mm",2.3149622159629772,"inch"]
["   End space is from shorted end to center of last slot",null,null,null,"Assumes round ended slots, radius = slot width",null,null,null,null,null,null,null,null,null,null,null,null,null,"Square end slots",2]
[null,null,null,null,null,null,null,{"$f":"100+2","v":102},null,null,null,null,null,null,null,null,null,null,"Rounded corners on slot ends",1.4]
["Wavelength - free space (Lo)",{"$f":"300/FGhz_en","v":52.082429124494361},"mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rounded ends",0]
["Wavelength - cutoff",{"$f":"2*WG_a_en","v":69.680000000000007},"mm","Minimum frequency =",null,null,{"$f":"(300/lam_cutoff_en)*1.2","v":5.1664753157290466},"GHz"]
["Guide wavelength (Lg)",{"$f":"1/SQRT(((1/lam_zero_en)^2)-((1/lam_cutoff_en)^2))","v":78.400053713946164},"mm"]
["Overmode (2x f cutoff)",null,null,null,null,null,{"$f":"2*G26","v":10.332950631458093},"GHz",null,null,null,{"$f":"ROUND(B27,1)","v":78.400000000000006},"min"]
[]
["INTERMEDIATE TERMS --do not touch !"]
["Gslot",{"$f":"1/Nslots_en","v":6.25E-2},null,null,null,null,{"$f":"1/Nslots_en","v":6.25E-2},"enter taper admittance here"]
["G1",{"$f":"2.09*(lam_guide_en/lam_zero_en)*(WG_a_en/WG_b_en)*(COS(PI()*lam_zero_en/2/lam_guide_en)^2)","v":1.756561471162787},null,null,null,null,{"$f":"2.09*(lam_guide_en/lam_zero_en)*(WG_a_en/WG_b_en)*(COS(0.464*PI()*lam_zero_en/lam_guide_en)-COS(0.464*PI()))^2","v":1.4285372809251931},null,null,null,null,{"$f":"ROUND(B55,1)","v":9.8000000000000007}]
["Y",{"$f":"G_slot_en/G_1_en","v":3.5580878338762043E-2},null,null,null,null,{"$f":"G_2_slot_en/New_G1_en","v":4.3751045796664008E-2},null,null,null,null,"or"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(D55,1)","v":19.600000000000001}]
["Offset calculation: Mathcad from KB7TRZ:",null,null,null,null,null,"New offset calc from Elliott:"]
["OFFSET",{"$f":"(WG_a_en/PI())*SQRT(ASIN(Y_en))","v":2.0921000281839714},"mm",null,null,null,{"$f":"(WG_a_en/PI())*SQRT(ASIN(New_Y_en))","v":2.3200204719880988},"mm",{"$f":"$G36/25.4","v":9.1339388660948775E-2},"inch"]
["CORRECTED OFFSET **"]
[null,{"$f":"(WG_a_en/PI())*ASIN(SQRT(Y_en))","v":2.1044873059969205},"mm",{"$f":"B38/25.4","v":8.2853830944760648E-2},"inches",null,{"$f":"(WG_a_en/PI())*ASIN(SQRT(New_Y_en))","v":2.3369066404339853},"mm",{"$f":"G38/25.4","v":9.2004198442282886E-2},"inch",null,{"$f":"ROUND(B27,1)","v":78.400000000000006},"min"]
[]
["Offset calculation: BASIC from W6OYJ:"]
["AG",{"$f":"ATAN(Y_en/SQRT(1-Y_en^2))","v":3.5588390177866677E-2},"mm"]
["Offset",{"$f":"(WG_a_en/PI())*SQRT(AG_en)","v":2.0921000281839714},"mm",null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(B54,1)","v":9.4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"or"]
["Slot Length Calculation from Stegen curves:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D54","v":48.6}]
["Slot in wavelengths",null,null,null,null,null,{"$f":"0.210324*G_2_slot_en^4-0.338065*G_2_slot_en^3+0.12712*G_2_slot_en^2+0.034433*G_2_slot_en+0.48253","v":0.48509929888916015}]
["Slot Length",null,null,null,null,null,{"$f":"lam_zero_en*slot_wl_en","v":25.265149852736588},"mm"]
["* Correction tested on CNC machining and measurement by Dan Welch W6DFW",null,null,null,null,null,null,null,null,null,null,null,null,"diam",{"$f":"B52","v":2.1168014502765464},"mm"]
["** correction from Petr Kauler kauler@volzny.cz",null,null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Distance from short = 0.12 lg (or 0.62 lg)"]
[]
[" PROBE calculations",null,null,null,null,null,"FORMULAE :"]
["diameter of probe(diam)",{"$f":"lam_guide_en*0.027","v":2.1168014502765464},"mm",null,null,null,"Probe diamater = 0.027 lg "]
["lenght of probe (len)",{"$f":"lam_guide_en*0.16","v":12.544008594231386},"mm",null,null,null,"Probe length = 0.16 lg ",null,null,null,null,null,null," ",{"$f":"B53","v":12.544008594231386},"mm"]
["distance  to short circuit end",{"$f":"lam_guide_en*0.12","v":9.4080064456735393},"mm",{"$f":"(ROUND(lam_guide_en*0.62,1))","v":48.6},"mm",null,"Distance from short = 0.12 lg (or 0.62 lg)"]
["matching screw spacing",{"$f":"lam_guide_en/8","v":9.8000067142432705},"mm",{"$f":"(ROUND(lam_guide_en/4,1))","v":19.600000000000001},"mm",null,"Matching =  3 screws spaced lg/8 or lg/4 "]
["Total length of antenna with long ends",{"$f":"E22+(E20*((D11/2)-1))+(E18/2)+B27+(2*D55)+B27+D54","v":590.43291063853189},"mm"]
["Minimum length of guide required ( short ends)",{"$f":"E21+(E20*((D11/2)-1))+(E18/2)+B27+(2*B55)+B27+B54","v":492.4409036557189},"mm"]
["Top and bottom may have adjustable shorts, but must not be left open "]
["It may be wise to extend the length of the guide at the base of the antenna to facilitate mounting"]