{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":3,"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":82,"n_cols":34,"rows_kept":82,"cut":false,"hidden":false,"merged":[[13,0,13,1],[12,6,13,7]]}
[false,null,"7/8","1-5/8",3,"3 EHT",4,"4 EHT",5,"5 EHT","6\" 75","6\" 50","7\" 75 ohm","6\" 75 EHT","6\" 50 EHT","7\" 75 EHT","8\" 75","8\" 75 EHT","9\" 75","9\" 75EHT","9\" 50","WR1800","WR1500","WR1150","DTW1750A","DTW1500A","DTW1350A","Flex 7/8","Flex 1-5/8","Flex 2-1/8","Flex 3-1/8 ","Flex 4-1/16","Flex 5","Flex 6-1/18"]
[{"$f":"IF(A1,C13,IF(C13<5,57+6*(C13-2),IF(C13<7,79+6*(C13-5),IF(C13<14,177+6*(C13-7),IF(C13<70,473+6*(C13-14),IF(AND(C13>200,C13<301),(C13-201)*0.2+88.1,0))))))","v":581},"a",47.290774999999996,155.55654999999999,523.73913000000005,837.29246000000001,835.58600000000001,1410.3191999999999,1413.1215999999999,2315.5500999999999,1511.6731,1759.2597000000001,2418.2024999999999,2550.5056,2878.6275000000001,3454.3955000000001,2537.0342999999998,4371.0837000000001,3133.7802000000001,5437.2583999999997,3649.3553000000002,null,null,null,null,null,null,75.960318999999998,153.91206,195.89561,399.42122000000001,703.80641000000003,1170.6447000000001,1525.2624000000001]
[null,"b",-0.49750540999999998,-0.49960995000000002,-0.50019557000000003,-0.51903286999999998,-0.49999914000000001,-0.52862023000000002,-0.54129293999999994,-0.54987675999999996,-0.50016004000000003,-0.49988895,-0.53088340999999994,-0.52728227000000005,-0.52432537000000001,-0.53249610999999997,-0.49989272000000001,-0.53033589000000003,-0.49997380000000002,-0.53039987,-0.50010968,null,null,null,null,null,null,-0.52314837000000003,-0.50388692999999996,-0.49855509999999997,-0.51458510999999996,-0.51180545,-0.52330794000000003,-0.52038116000000001]
[]
[null,"a",3.435237E-2,1.9411759000000001E-2,8.8975164999999991E-3,8.8975164999999991E-3,6.2805954999999997E-3,6.2805954999999997E-3,5.1557423999999998E-3,5.1557423999999998E-3,4.1647840000000004E-3,4.8890857000000003E-3,3.5505700999999999E-3,4.1647840000000004E-3,4.8890857000000003E-3,3.5505700999999999E-3,3.7828537999999999E-3,3.7828537999999999E-3,3.8592881000000001E-6,3.8592881000000001E-6,null,61356900,1645009600,68650260000000,1916698900,1547868700,28536530000000,3.4249269999999998E-2,1.322221E-2,1.8434030000000001E-2,1.1068674000000001E-2,8.2383747000000004E-3,3.941857E-3,5.6980073000000003E-3]
[null,"b",1.0000283999999999,1.0000530000000001,1.0001062999999999,1.0001062999999999,0.99998030000000004,0.99998030000000004,1.0000324,1.0000324,1.0000735999999999,0.99994883999999995,1.0000798,1.0000735999999999,0.99994883999999995,1.0000798,0.49357480999999997,0.49357480999999997,0.99758369000000002,0.99758369000000002,null,1.0059289,1.0056346,1.0064850000000001,1.0064639,1.0050828000000001,1.0069969999999999,1.0000069,0.99998240000000005,1.0000198,1.0000631,1.0000655000000001,0.99988496000000004,1.0000268000000001]
[null,"c",0.51772256999999999,0.51117031999999996,0.51590535000000004,0.51590535000000004,0.51295592999999995,0.51295592999999995,0.53260412000000001,0.53260412000000001,0.51818735999999999,0.51488769000000001,0.51895020000000003,0.51818735999999999,0.51488769000000001,0.51895020000000003,null,null,1.7731509999999999,1.7731509999999999,null,-3.8658655999999998,-4.2917626999999996,-5.9119900000000003,-4.4249387999999996,-4.2096239000000004,-5.8803039999999998,0.53016951999999995,0.60199625000000001,0.51163952000000001,0.51813920000000002,0.52902780000000005,0.62544988000000001,0.52825014000000003]
[null,"d"]
[null,"e"]
[]
[null,null,null,null,null,null,null,"Ver. 10.2"]
[null,"Power Ratings and Attenuation vs. Channel or Freq."]
[null,{"$f":"IF(A1,\"FREQUENCY (VHF and UHF):\",\"FCC TV & FM Channel:\")","v":"FCC TV & FM Channel:"},32,{"$f":"IF(A1,\"MHz\",\"\")","v":""},"Total length:",500,"Select channel and line length fields. Table will automatically populate"]
["Frequency",null,{"$f":"IF(A1,C13,A2)","v":581}]
[]
[]
[null,"Transmission Line","7/8\"","1-5/8\"","3-1/8\" 50Ω","3-1/8\" EHT","4-1/16\" 50Ω","4-1/16\" EHT"]
[null,"Max. Avg. Power @ 0 psig",{"$f":"C$2*$A2^C$3","v":1.9933513344791947},{"$f":"D$2*$A2^D$3","v":6.4696144978148151},{"$f":"E$2*$A2^E$3","v":21.70133076219571},{"$f":"F21*0.885","v":27.234673918956247},{"$f":"G$2*$A2^G$3","v":34.666138347244221},{"$f":"H21*0.885","v":43.15799558333844}]
[null,"Max Power for DTV @ 0 psig",{"$f":"C18*0.9","v":1.7940162010312752},{"$f":"D18*0.9","v":5.8226530480333336},{"$f":"E18*0.9","v":19.531197685976139},{"$f":"F18*0.9","v":24.511206527060622},31.199524512519801,38.842196025004597]
[null,"Peak TV Power 10% Aural @ 0 psig",{"$f":"C18/0.7","v":2.847644763541707},{"$f":"D18/0.7","v":9.2423064254497369},{"$f":"E18/0.7","v":31.001901088851017},{"$f":"F23*0.885","v":38.906677027080356},{"$f":"G18/0.7","v":49.523054781777461},{"$f":"H23*0.885","v":61.654279404769198}]
[null,"Max. Avg. Power @ 15 psig",{"$f":"C18*1.21","v":2.4119551147198255},{"$f":"D18*1.21","v":7.8282335423559264},{"$f":"E18*1.21","v":26.258610222256809},{"$f":"F$2*$A2^F$3","v":30.773642846278246},{"$f":"G18*1.21","v":41.946027400165505},{"$f":"H$2*$A2^H$3","v":48.766096704337222}]
[null,"Max Power for DTV @ 15 psig",{"$f":"C21*0.9","v":2.1707596032478431},{"$f":"D21*0.9","v":7.0454101881203339},23.632749200031128,27.696278561650423,37.751424660148956,43.889487033903499]
[null,"Peak TV Power 10% Aural @ 15 psig",{"$f":"C21/0.7","v":3.4456501638854653},11.183190774794181,37.512300317509727,43.962346923254643,59.922896285950728,69.665852434767459]
[null,"Attenuation [dB/length]",{"$f":"C5*C6^$A$2*$A$2^C7*$F$13/100","v":4.7116064888974547},{"$f":"D5*D6^$A$2*$A$2^D7*$F$13/100","v":2.5904342222340357},{"$f":"E5*E6^$A$2*$A$2^E7*$F$13/100","v":1.262155294534856},{"$f":"F5*F6^$A$2*$A$2^F7*$F$13/100","v":1.262155294534856},{"$f":"G5*G6^$A2*$A2^G7*$F$13/100","v":0.81264433720454166},{"$f":"H5*H6^$A2*$A2^H7*$F$13/100","v":0.81264433720454166}]
[null,"Efficiency [%]",{"$f":"10^(-C24/10)","v":0.33793980653302264},0.55075262755185739,0.74779829487973326,0.74779829487973326,0.82934564082740558,0.82934564082740558]
[]
[null,"Transmission Line","5\" 50Ω","5\" EHT","6-1/8\" 75Ω","6-1/8\" 75Ω EHT","6-1/8\" 50Ω","6-1/8\" 50Ω EHT"]
[null,"Max. Avg. Power @ 0 psig",{"$f":"I$2*$A2^I$3","v":45.076533404620079},{"$f":"D31*0.885","v":61.892957692982556},{"$f":"K$2*$A2^K$3","v":62.650918153831597},{"$f":"F31*0.875","v":77.827533789708397},{"$f":"L$2*$A2^L$3","v":73.03799620456337},{"$f":"H31*0.885","v":90.531781650853546}]
[null,"Max Power for DTV @ 0 psig",{"$f":"C28*0.9","v":40.568880064158073},{"$f":"D28*0.9","v":55.703661923684301},{"$f":"E28*0.9","v":56.385826338448439},{"$f":"F28*0.9","v":70.044780410737559},{"$f":"G28*0.9","v":65.734196584107039},{"$f":"H28*0.9","v":81.47860348576819}]
[null,"Peak TV Power 10% Aural @ 0 psig",{"$f":"C28/0.7","v":64.395047720885827},{"$f":"D33*0.885","v":88.41851098997509},{"$f":"E28/0.7","v":89.501311648330855},{"$f":"F33*0.875","v":111.18219112815486},{"$f":"G28/0.7","v":104.33999457794768},{"$f":"H33*0.885","v":129.3311166440765}]
[null,"Max. Avg. Power @ 15 psig",{"$f":"C28*1.21","v":54.542605419590295},{"$f":"J$2*$A2^J$3","v":69.935545415799496},{"$f":"E28*1.22","v":76.434120147674548},{"$f":"N$2*$A2^N$3","v":88.945752902523878},{"$f":"G28*1.21","v":88.375975407521679},{"$f":"O$2*$A2^O$3","v":102.29579847554074}]
[null,"Max Power for DTV @ 15 psig",{"$f":"C31*0.9","v":49.088344877631265},{"$f":"D31*0.9","v":62.941990874219549},{"$f":"E31*0.9","v":68.790708132907099},{"$f":"F31*0.9","v":80.051177612271488},{"$f":"G31*0.9","v":79.538377866769508},{"$f":"H31*0.9","v":92.066218627986657}]
[null,"Peak TV Power 10% Aural @ 15 psig",{"$f":"C31/0.7","v":77.918007742271854},99.907922022570716,109.19160021096364,127.06536128931984,126.25139343931669,146.13685496505821]
[null,"Attenuation [dB/length]",{"$f":"I5*I6^$A2*$A2^I7*$F$13/100","v":0.77919832756445895},{"$f":"J5*J6^$A2*$A2^J7*$F$13/100","v":0.77919832756445895},{"$f":"K5*K6^$A2*$A2^K7*$F$13/100","v":0.58815807344853432},{"$f":"N5*N6^$A2*$A2^N7*$F$13/100","v":0.58815807344853432},{"$f":"L5*L6^$A2*$A2^L7*$F$13/100","v":0.628823315182646},{"$f":"O5*O6^$A2*$A2^O7*$F$13/100","v":0.628823315182646}]
[null,"Efficiency [%]",{"$f":"10^(-C34/10)","v":0.83575727801710609},0.83575727801710609,0.87334169088550273,{"$f":"10^(-F34/10)","v":0.87334169088550273},0.86520230639835249,0.86520230639835249]
[]
[null,"Transmission Line","7-3/16\" 75Ω","7-3/16\" 75Ω EHT","8-3/16\" 75Ω","8-3/16\" 75Ω EHT","9-3/16\" 75Ω","9-3/16\" 75Ω EHT"]
[null,"Max. Avg. Power @ 0 psig",{"$f":"M$2*$A2^M$3","v":82.420911822294912},{"$f":"D41*0.875","v":101.96874505573436},{"$f":"IF(OR($A$2<=704,AND($F$61>200,$F$61<301)),Q$2*$A$2^Q$3,\"N/A\")","v":105.32581138305194},{"$f":"IF(OR($A$2<=704,AND($F$61>200,$F$61<301)),F$41*0.875,\"N/A\")","v":130.81434362186084},{"$f":"IF(OR($A$2<=620,AND($F$61>200,$F$61<301)),S$2*$A2^S$3,\"N/A\")","v":130.032791959115},{"$f":"IF(OR($A$2<=620,AND($F$61>200,$F$61<301)),H$41*0.875,\"N/A\")","v":162.65572906741585}]
[null,"Max Power for DTV @ 0 psig",{"$f":"C38*0.9","v":74.178820640065425},{"$f":"D38*0.9","v":91.771870550160926},{"$f":"IF(OR($A$2<=704,AND($F$61>200,$F$61<301)),E38*0.9,\"N/A\")","v":94.793230244746752},{"$f":"IF(OR($A$2<=704,AND($F$61>200,$F$61<301)),F38*0.9,\"N/A\")","v":117.73290925967476},{"$f":"IF(OR($A$2<=620,AND($F$61>200,$F$61<301)),G38*0.9,\"N/A\")","v":117.0295127632035},{"$f":"IF(OR($A$2<=620,AND($F$61>200,$F$61<301)),H38*0.9,\"N/A\")","v":146.39015616067428}]
[null,"Peak TV Power 10% Aural @ 0 psig",{"$f":"C38/0.7","v":117.74415974613559},{"$f":"D43*0.875","v":145.66963579390622},{"$f":"IF(OR(A2<=704,AND(F61>200,F61<301)),E38/0.7,\"N/A\")","v":150.46544483293135},{"$f":"IF(OR($A$2<=704,AND($F$61>200,$F$61<301)),F$43*0.875,\"N/A\")","v":186.87763374551548},{"$f":"IF(OR($A$2<=620,AND($F$61>200,$F$61<301)),G38/0.7,\"N/A\")","v":185.76113137016429},{"$f":"IF(OR($A$2<=620,AND($F$61>200,$F$61<301)),H$43*0.875,\"N/A\")","v":232.36532723916548}]
[null,"Max. Avg. Power @ 15 psig",{"$f":"C38*1.22","v":100.55351242319979},{"$f":"P$2*$A2^P$3","v":116.53570863512498},{"$f":"IF(OR(A2<=704,AND(F61>200,F61<301)),E38*1.22,\"N/A\")","v":128.49748988732335},{"$f":"IF(OR(A2<=704,AND(F61>200,F61<301)),R$2*$A2^R$3,\"N/A\")","v":149.50210699641238},{"$f":"IF(OR($A$2<=620,AND($F$61>200,$F$61<301)),G38*1.22,\"N/A\")","v":158.64000619012029},{"$f":"IF(OR($A$2<=620,AND($F$61>200,$F$61<301)),T$2*$A2^T$3,\"N/A\")","v":185.8922617913324}]
[null,"Max Power for DTV @ 15 psig",{"$f":"C41*0.9","v":90.498161180879819},{"$f":"D41*0.9","v":104.88213777161248},{"$f":"IF(OR($A$2<=704,AND($F$61>200,$F$61<301)),E41*0.9,\"N/A\")","v":115.64774089859102},{"$f":"IF(OR($A$2<=704,AND($F$61>200,$F$61<301)),F41*0.9,\"N/A\")","v":134.55189629677113},{"$f":"IF(OR($A$2<=620,AND($F$61>200,$F$61<301)),G41*0.9,\"N/A\")","v":142.77600557110827},{"$f":"IF(OR($A$2<=620,AND($F$61>200,$F$61<301)),H41*0.9,\"N/A\")","v":167.30303561219915}]
[null,"Peak TV Power 10% Aural @ 15 psig",{"$f":"C41/0.7","v":143.64787489028544},{"$f":"D41/0.7","v":166.47958376446425},{"$f":"IF(OR(A2<=704,AND(F61>200,F61<301)),E41/0.7,\"N/A\")","v":183.56784269617623},{"$f":"IF(OR(A2<=704,AND(F61>200,F61<301)),F41/0.7,\"N/A\")","v":213.5744385663034},{"$f":"IF(OR($A$2<=620,AND($F$61>200,$F$61<301)),G41/0.7,\"N/A\")","v":226.62858027160044},{"$f":"IF(OR($A$2<=620,AND($F$61>200,$F$61<301)),H41/0.7,\"N/A\")","v":265.56037398761771}]
[null,"Attenuation [dB/length]",{"$f":"M5*M6^$A2*$A2^M7*$F$13/100","v":0.50567629075699416},{"$f":"P5*P6^$A2*$A2^P7*$F$13/100","v":0.50567629075699416},{"$f":"IF(OR(A2<=704,AND(F61>200,F61<301)),Q$5*$A2^Q$6*$F$13/100,\"N/A\")","v":0.43764026331202871},{"$f":"IF(OR(A2<=704,AND(F61>200,F61<301)),R$5*$A2^R$6*$F$13/100,\"N/A\")","v":0.43764026331202871},{"$f":"IF(OR($A$2<=620,AND($F$61>200,$F$61<301)),S5*S6^$A2*$A2^S7*$F$13/100,\"N/A\")","v":0.37700354554238297},{"$f":"IF(OR($A$2<=620,AND($F$61>200,$F$61<301)),T5*T6^$A2*$A2^T7*$F$13/100,\"N/A\")","v":0.37700354554238297}]
[null,"Efficiency [%]",{"$f":"10^(-C44/10)","v":0.89008682138332185},{"$f":"10^(-D44/10)","v":0.89008682138332185},{"$f":"IF(OR(A2<=704,AND(F61>200,F61<301)),10^(-E44/10),\"N/A\")","v":0.90414060458450862},{"$f":"IF(OR(A2<=704,AND(F61>200,F61<301)),10^(-F44/10),\"N/A\")","v":0.90414060458450862},{"$f":"IF(OR($A$2<=620,AND($F$61>200,$F$61<301)),10^(-G44/10), \"N/A\")","v":0.91685286295091362},{"$f":"IF(OR($A$2<=620,AND($F$61>200,$F$61<301)),10^(-H44/10), \"N/A\")","v":0.91685286295091362}]
[]
[null,"Flexline Air         50Ω","7/8\"  HJ5-50","1-5/8\"  HJ7-50A","2-1/4\"","3\"  HJ8-50B","4\"   HJ11-50","5\"  HJ9-50",null,null,"length/100 =",{"$f":"F13/100","v":5}]
[null,"Max. Avg. Power @ 0 psig",{"$f":"IF((2.781/($C$54/L47)>90),90,2.781/($C$54/L47))","v":2.938746425630125},{"$f":"IF((3.355/($D$54/L47)>305),305,3.355/($D54/L47))","v":6.470006440842635},{"$f":"IF((3.9042/($E54/L47)>425),425,3.9042/($E54/L47))","v":8.9824022087678941},{"$f":"IF((5.9953/($F54/L47)>640),640,5.9953/($F54/L47))","v":15.045482651712831},{"$f":"IF((7.4002/($G54/L47)>1100),1100,7.4002/($G54/L47))","v":23.749831677979554},{"$f":"IF((6.6668/($H54/L47)>1890),1890,6.6668/($H54/L47))","v":32.058941325102161}]
[null,"Max Power for DTV @ 0 psig",{"$f":"C48*0.9","v":2.6448717830671127},{"$f":"D48*0.9","v":5.8230057967583715},{"$f":"E48*0.9","v":8.0841619878911057},{"$f":"F48*0.9","v":13.540934386541549},{"$f":"G48*0.9","v":21.3748485101816},{"$f":"H48*0.9","v":28.853047192591944}]
[null,"Peak TV Power 10% Aural @ 0 psig",{"$f":"C48/0.7","v":4.1982091794716077},9.2428663440609071,12.832003155382706,21.493546645304047,33.92833096854222,45.798487607288806]
[null,"Max. Avg. Power @ 15 psig",{"$f":"C48*1.22","v":3.5852706392687526},7.8934078578280147,10.958530694696831,18.355488835089652,28.974794647135056,39.111908416624637,null,11802.853999999999]
[null,"Max Power for DTV @ 15 psig",{"$f":"C51*0.9","v":3.2267435753418772},{"$f":"D51*0.9","v":7.104067072045213},{"$f":"E51*0.9","v":9.862677625227148},{"$f":"F51*0.9","v":16.519939951580689},{"$f":"G51*0.9","v":26.07731518242155},{"$f":"H51*0.9","v":35.200717574962177}]
[null,"Peak TV Power 10% Aural @ 15 psig",{"$f":"C51/0.7","v":5.1218151989553613},11.276296939754307,15.655043849566903,26.222126907270933,41.392563781621512,55.874154880892341]
[null,"Attenuation [dB/length]",{"$f":"((0.035307*SQRT($A$2))+(0.000164*$A$2))*$L$47","v":4.7316093279529881},{"$f":"((0.01944*SQRT($A$2))+(0.000086*$A$2))*$L$47","v":2.5927331221969037},{"$f":"((0.016104*SQRT($A$2))+(0.00008*$A$2))*L47","v":2.1732493765359537},{"$f":"((0.012434*SQRT($A$2))+(0.00017*$A$2))*L47","v":1.992392048425736},{"$f":"((0.010396*SQRT($A$2))+(0.000105*$A$2))*L47","v":1.5579478836604432},{"$f":"((0.007374*SQRT($A$2))+(0.000052*$A$2))*L47","v":1.039772326290122}]
[null,"Efficiency [%]",{"$f":"10^(-C54/10)","v":0.33638689425989704},0.55046116859929661,0.60628254131382675,0.63206362147533568,0.69856240889243049,0.78708705071480622]
[]
[null,"Flexline Foam    50Ω","1/2\"","7/8\"","1-1/4\"","1-5/8\"","2-1/4\""]
[null,"Max. Avg. Power ",{"$f":"IF((2.325/($C61/L47)>40),40,2.325/($C61/L47))","v":1.3391558299069892},{"$f":"IF((2.77/($D61/L47)>91),91,2.77/($D61/L47))","v":2.9627526913228488},{"$f":"IF((3.455/($E61/L47)>205),205,3.455/($E61/L47))","v":5.2102951369518449},{"$f":"IF((3.351/($F61/L47)>315),315,3.351/($F61/L47))","v":6.0450252963105173},{"$f":"IF((3.76/($G61/L47)>425),425,3.76/($G61/L47))","v":7.66291276871873}]
[null,"Max Power for DTV ",{"$f":"C58*0.9","v":1.2052402469162904},{"$f":"D58*0.9","v":2.6664774221905638},{"$f":"E58*0.9","v":4.6892656232566603},{"$f":"F58*0.9","v":5.4405227666794653},{"$f":"G58*0.9","v":6.8966214918468571}]
[null,"Peak TV Power 10% Aural",{"$f":"C58/0.7","v":1.9130797570099847},{"$f":"D58/0.7","v":4.232503844746927},{"$f":"E58/0.7","v":7.443278767074065},{"$f":"F58/0.7","v":8.6357504233007401},{"$f":"G58/0.7","v":10.947018241026758}]
[null,"Attenuation [dB/length]",{"$f":"((0.065906*SQRT($A$2))+(0.000254*$A$2))*L47","v":8.6808418709624053},{"$f":"((0.0351*SQRT($A$2))+(0.000153*$A$2))*L47","v":4.6747067484110767},{"$f":"((0.02416*SQRT($A$2))+(0.000139*$A$2))*L47","v":3.3155511436356591},{"$f":"((0.01931*SQRT($A$2))+(0.000153*$A$2))*L47","v":2.7717005601657521},{"$f":"((0.0165*SQRT($A$2))+(0.00016*$A$2))*L47","v":2.4533751808770017}]
[null,"Efficiency [%]",{"$f":"10^(-C61/10)","v":0.13549267371181109},{"$f":"10^(-D61/10)","v":0.34082333766724676},{"$f":"10^(-E61/10)","v":0.46606327824982124},{"$f":"10^(-F61/10)","v":0.52823836979457017},{"$f":"10^(-G61/10)","v":0.56841101050249654}]
[]
[]
["Frequency to Channel",null,"Frequency>",{"$f":"A2","v":581}]
["(operating Freq - bottom channel Freq) / channel width + bottom Channel #"]
[null,"Channel # =>","=($A$2-LOOKUP($A$2,$D$50:$D$55))/VLOOKUP($A$2,$D$50:$F$55,3)+VLOOKUP($A$2,$D$50:$F$55,2)",null,null,{"$f":"(A2-F68)/F70+F69","v":32}]
[null,"BOT FREQ lookup","=LOOKUP(A2,D50:D55)",null,null,{"$f":"LOOKUP(A2,D72:D77)","v":473}]
[null,"bot chan lookup","=VLOOKUP($A$2,$D$50:$F$55,2)",null,null,{"$f":"VLOOKUP($A$2,$D$72:$F$77,2)","v":14}]
[null,"divisor lookup","=VLOOKUP($A$2,$D$50:$F$55,3)",null,null,{"$f":"VLOOKUP($A$2,$D$72:$F$77,3)","v":6},"Calculated"]
[null,null,null,"Btm Freq","bottom Ch#","divisor","Channel #"]
[null,null,null,54,2,6,{"$f":"($A$2-$D72)/$F72+$E72","v":89.833333333333329}]
[null,null,null,57,2,6,89.333333333333329]
[null,null,null,79,5,6,88.666666666666671]
[null,null,null,88.1,201,0.2,2665.4999999999995]
[null,null,null,177,7,6,74.333333333333329]
[null,null,null,473,14,6,32]
[]
[]
[]
[{"$f":"IF(AND(C13>200,C13<301),TRUE,FALSE)","v":false},"<=FM ch"]
[{"$f":"IF(AND(C13>1,C13<70),TRUE,FALSE)","v":true},"<=TV ch"]