{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":1,"images":0,"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":"Sheet1","index":0,"n_rows":50,"n_cols":21,"rows_kept":50,"cut":false,"hidden":false,"merged":[[30,9,31,9],[30,10,31,10],[30,11,31,11],[30,3,31,3],[30,7,31,7],[30,6,31,6],[30,5,31,5],[30,4,31,4],[30,8,31,8]]}
[null,null,null,"       Длина диполя, в метрах",null,null,null,"     Коэффициент укорочения"]
[null,null,null,null,30.48,null,null,null,0.9]
[null,null,null,"(Ctrl-d)",null,"    (Ctrl-i)"]
[]
[]
[]
[]
[{"$f":"B50","v":"11м"}]
[]
[{"$f":"B49","v":"12м"}]
[]
[{"$f":"B48","v":"14м"}]
[]
[{"$f":"B47","v":"16м"}]
[]
[{"$f":"B46","v":"21м"}]
[]
[{"$f":"B45","v":"30м"}]
[]
[{"$f":"B44","v":"42м"}]
[]
[{"$f":"B43","v":"80м"}]
[]
[]
[]
[]
[]
[null,"Примечание: Длина линии 46 метров, указывает на то, что диполь слишком короткий для данного диапазона"]
[]
[null,null,null,null,null,"Предварительные расчеты"]
["Частота","Минимальная","Расчитываемый","Длина волны, м","Len/WL","Fraction","Nrmlz","FeedlnWL","Длина волны с учетом КУ, м","LLWL/2","Section1","300xVF"]
["МГц","Длина диполя, м","диполь, м"]
[3.75,{"$f":"J33/1.2","v":30},{"$f":"$E$2+7.3152/A33","v":32.430720000000001},{"$f":"300/A33","v":80},{"$f":"C33/D33","v":0.40538400000000002},{"$f":"E33-INT(E33)","v":0.40538400000000002},{"$f":"IF(F33<0.5, F33+1, F33)","v":1.405384},{"$f":"0.25-(TAN(2.5*(G33-1)))/12.02","v":0.11651369834032033},{"$f":"L33/A33","v":72},{"$f":"I33/2","v":36},{"$f":"H33*I33","v":8.3889862805030635},{"$f":"300*I2","v":270},null,99,{"$f":"N33*0.3048","v":30.1752},{"$f":"D33/O33","v":2.6511837535459581},null,{"$f":"24/A33","v":6.4},106.4,{"$f":"S33*0.3048","v":32.430720000000001},{"$f":"T33/D33","v":0.40538400000000002}]
[7.15,{"$f":"J34/1.2","v":15.734265734265733},{"$f":"$E$2+7.3152/A34","v":31.503104895104897},{"$f":"300/A34","v":41.958041958041953},{"$f":"C34/D34","v":0.75082400000000016},{"$f":"E34-INT(E34)","v":0.75082400000000016},{"$f":"IF(F34<0.5, F34+1, F34)","v":0.75082400000000016},{"$f":"0.25-(TAN(2.5*(G34-1)))/12.02","v":0.30976345866080457},{"$f":"L33/A34","v":37.76223776223776},{"$f":"I34/2","v":18.88111888111888},{"$f":"H34*I34","v":11.69736137600241},null,null,51,{"$f":"N34*0.3048","v":15.5448},{"$f":"D34/O34","v":2.6991689798544822},null,{"$f":"24/A34","v":3.3566433566433567},103.35664335664336,{"$f":"S34*0.3048","v":31.503104895104897},{"$f":"T34/D34","v":0.75082400000000016}]
[10.125,11.111111111111112,31.20248888888889,29.62962962962963,1.0530840000000001,5.3084000000000131E-2,1.0530840000000001,0.23889395826543347,{"$f":"L33/A35","v":26.666666666666668},13.333333333333334,6.3705055537448931,null,null,37,11.277600000000001,2.6272992152257242,null,2.3703703703703702,102.37037037037037,31.20248888888889,1.0530840000000001]
[14.175000000000001,7.9365079365079367,30.996063492063492,21.164021164021165,1.464564,0.46456399999999998,1.464564,5.826381574594533E-2,{"$f":"L33/A36","v":19.047619047619047},9.5238095238095237,1.1097869665894349,null,null,26,7.9248000000000003,2.6706063451470277,null,1.693121693121693,101.6931216931217,30.996063492063495,1.4645640000000002]
[18.14,6.2017640573318635,30.883263506063948,16.5380374862183,1.8674080000000002,0.86740800000000018,0.86740800000000018,0.27863388901128372,{"$f":"L33/A37","v":14.884233737596471},7.4421168687982355,4.1472519312594596,null,null,20,6.0960000000000001,2.7129326585003772,null,1.3230429988974641,101.32304299889746,30.883263506063948,1.8674080000000002]
[21.225000000000001,5.3003533568904597,30.824650176678446,14.134275618374557,2.180844,0.180844,1.180844,0.20959566749879152,{"$f":"L33/A38","v":12.720848056537102},6.3604240282685511,2.6662346395605989,null,null,17,5.1816000000000004,2.7277820785808546,null,1.1307420494699645,101.13074204946996,30.824650176678446,2.180844]
[24.95,4.5090180360721446,30.773194388777554,12.024048096192384,2.559304,0.55930400000000002,0.55930400000000002,0.41416352450233851,{"$f":"L33/A39","v":10.821643286573147},5.4108216432865737,4.4819299244742048,null,null,15,4.5720000000000001,2.6299317795696378,null,0.96192384769539085,100.96192384769539,30.773194388777554,2.559304]
[28.4,3.9612676056338034,30.737577464788732,10.563380281690142,{"$f":"C40/D40","v":2.9098239999999995},0.90982399999999952,0.90982399999999952,0.26907973925168061,{"$f":"L33/A40","v":9.5070422535211279},4.7535211267605639,2.5581524506321749,null,null,13,3.9624000000000001,2.6659045734126141,null,0.84507042253521136,100.84507042253522,30.737577464788735,2.909824]
[null,null,null,null,"Len","Phase",null,null,null,"dl","l0"]
[null,null,null,"Оптимальная длина симметричной линии менее 45 метров, в метрах",null,null,null,null,null,null,null,null,null,null,"Hlen - длина диполя"]
[1,{"$f":"CONCATENATE(INT(D33+0.45),\"м\")","v":"80м"},{"$f":"IF(($E$2<B33), 46, K33)","v":8.3889862805030635},{"$f":"IF((C43+$J$33)>46, C43, C43+$J$33)","v":44.388986280503062},44.388986280503062,44.388986280503062,44.388986280503062,44.388986280503062,44.388986280503062,44.388986280503062,44.388986280503062,44.388986280503062,null,null,"KU - коэфициент укорочения"]
[2,"42м",11.69736137600241,{"$f":"IF((C44+$J$34)>46, C44, C44+$J$34)","v":30.578480257121292},30.578480257121292,30.578480257121292,30.578480257121292,30.578480257121292,30.578480257121292,30.578480257121292,30.578480257121292,30.578480257121292,null,null,"Freq - частота"]
[3,"30м",6.3705055537448931,{"$f":"IF((C45+$J$35)>46, C45, C45+$J$35)","v":19.703838887078227},33.037172220411563,33.037172220411563,33.037172220411563,33.037172220411563,33.037172220411563,33.037172220411563,33.037172220411563,33.037172220411563,null,null,"Len = ( Hlen + 7,3152 / Freq ) / ( 300 / Freq )"]
[4,"21м",1.1097869665894349,{"$f":"IF((C46+$J$36)>46, C46, C46+$J$36)","v":10.633596490398958},20.157406014208483,29.681215538018009,39.205025061827534,39.205025061827534,39.205025061827534,39.205025061827534,39.205025061827534,39.205025061827534,null,null,"Phase = Len - int(Len)"]
[5,"16м",4.1472519312594596,{"$f":"IF((C47+$J$37)>46, C47, C47+$J$37)","v":11.589368800057695},19.031485668855929,26.473602537654166,33.915719406452403,41.357836275250641,41.357836275250641,41.357836275250641,41.357836275250641,41.357836275250641,null,null,"IF ( Phase < 0.5 )  { Phase +=1 }"]
[6,"14м",2.6662346395605989,{"$f":"IF((C48+$J$38)>46, C48, C48+$J$38)","v":9.0266586678291496},15.3870826960977,21.74750672436625,28.1079307526348,34.468354780903354,40.828778809171908,40.828778809171908,40.828778809171908,40.828778809171908,null,null,"Phase = 0,25 - ( TAN( 2,5 * ( Phase - 1 ) ) ) / 12,02"]
[7,"12м",4.4819299244742048,{"$f":"IF((C49+$J$39)>46, C49, C49+$J$39)","v":9.8927515677607794},15.303573211047354,20.714394854333928,26.125216497620503,31.536038140907078,36.946859784193649,42.357681427480223,42.357681427480223,42.357681427480223,null,null,"dl = ( 300 * KU ) / ( 2 * Freq )"]
[8,"11м",2.5581524506321749,{"$f":"IF((C50+$J$40)>46, C50, C50+$J$40)","v":7.3116735773927388},{"$f":"IF((D50+$J$40)>46, D50, D50+$J$40)","v":12.065194704153303},16.818715830913867,21.572236957674431,26.325758084434995,31.079279211195558,35.832800337956122,40.58632146471669,45.33984259147725,null,null,"l0 = Phase * ( 300 * KU ) / Freq "]