登录
首页 » Others » EXCEL函数大全、实例、教程(61个示例)

EXCEL函数大全、实例、教程(61个示例)

于 2020-12-12 发布
0 250
下载积分: 1 下载次数: 1

代码说明:

EXCEL函数大全、实例、教程

下载说明:请别用迅雷下载,失败请重下,重下不扣分!

发表评论

0 个回复

  • 数值分析:病态矩阵(HIlbert矩阵)的求解
    使用Matlab语言编程,分别用Gauss消去,Jacobi迭代,Gauss-Seidel迭代,SOR迭代和共轭梯度法对Hilbert矩阵进行求解并绘制相关曲线。
    2020-12-03下载
    积分:1
  • 基于VHDL的简易CPU设计(详细实验报告)
    基于VHDL的简易CPU设计(内附详细实验报告)
    2020-12-09下载
    积分:1
  • ISO16750-3-2012
    ISO16750-3-2012Road vehicles — Environmentalconditions and testing for electricaland electronic equipment —Part 3:Mechanical loadsContents PageForeword.............................................................................................................................................Iso16750-3:2012[EContentsPageForewordScope12Normative references1Terms and definitions4Tests and requirements4.1ibration4.2 Mechanical shock274.3 Free fall…294.4 Surface strength/ scratch and abrasion resistance294.5 Gravel bombardmentCode letters for mechanical loads29Documentation…,…………111111130Annex A (informative) Guideline for the development of test profiles for vibration tests.32Annex B (informative) Recommended mechanical requirements for equipment depending on themounting location44Bibliography46C ISO 2012-All rights reservedIso16750-3:2012EForewordISo (the International Organization for Standardization) is a worldwide federation of national standardsbodies (Iso member bodies). The work of preparing International Standards is normally carried outthrough iso technical committees. Each member body interested in a subject for which a technicalcommittee has been established has the right to be represented on that committee. Internationaorganizations, governmental and non-governmental, in liaison with ISO, also take part in the workIso collaborates closely with the International Electrotechnical Commission (IEC) on all matters ofelectrotechnical standardizationInternational Standards are drafted in accordance with the rules given in the ISo/IEC Directives, Part 2The main task of technical committees is to prepare lnternational standards. draft InternationalStandards adopted by the technical committees are circulated to the member bodies for votingublication as an International Standard requires approval by at least 75 of the member bodiescasting a voteAttention is drawn to the possibility that some of the elements of this document may be the subject ofpatent rights. ISO shall not be held responsible for identifying any or all such patent rightsIso 16750-3 was prepared by Technical Committee ISO/TC 22, Road vehicle, Subcommittee SC 3,Electrical and electronical equipment.This third edition cancels and replaces the second edition (Iso 16750-3: 2007), which has beentechnically revisedISo 16750 consists of the following parts, under the general title road vehicles-Environmental conditionsand testing for electrical and electronic equipment:Part 1: GeneralPart 2: electrical loadsPart 3: Mechanical loadsPart 4: Climatic loadsPart 5: chemical loadso ISO 2012-All rights reservedINTERNATIONAL STANDARDIso16750-3:2012(E)Road vehicles- Environmental conditions and testing forelectrical and electronic equipmentPart 3Mechanical loads1 ScopeThis part of IS0 16750 applies to electric and electronic systems/components for road vehicles. Itdescribes the potential environmental stresses and specifies tests and requirements recommended forthe specific mounting location on/in the vehicleThis part of iso 16750 describes mechanical loads2 Normative referencesThe following referenced documents are indispensable for the application of this document. For datedreferences, only the edition cited applies For undated references, the latest edition of the referenceddocument (including any amendments applies.Iso16750-1, Road vehicles- Environmental conditions and testing forelectrical andelectronicequipment-Part 1: GeneralIEC 60068-2, 6, Environmental testing- Part 2-6: Testing, Test Fc: Vibration SinusoidalIEC60068-2, 14, Basicenvironmental testing procedures- Part 2-14: Tests-Test Nb: Change oftemperatureTEC 60068-2, 64, Environmental testing Part 2-64: Test methods -Test Fh -Vibration, broad-bandrandom(digital control)and guidanceIEC 60068-2, 80, Environmental testing- Part 2-80: Tests- Test Fi: Vibration - Mixed mode testingIEC 60068-2-31, Environmental testing procedures- Part 2: Tests; Test Ec: Free fall, Clause 5.23 Terms and definitionsFor the purposes of this document, the terms and definitions given in Iso 16750-1 app4 Tests and requirements4.1 Vibration41.1 GeneralThe vibration test metho ds specified consider various levels of vibration severities applicable to on-board electrical and electronic equipment. It is recommended that the vehicle manufacturer andsupplier choose the test method, the environmental temperature and vibration parameters dependingon the specific mounting locationFollowing the expressions in MIL-STD please noticeC ISO 2012-All rights reservedIso16750-3:2012EWhen applied properly, the environmental management and engineering processes described in this partof Iso 16750 can be of enormous value in generating confidence in the environmental worthiness andoverall durability. However, it is important to recognize that there are limitations inherent in laboratorytesting that make itimperative to use proper caution and engineering judgement when extrapolating theselaboratory results to results that may be obtained under actual service conditions. In many cases, realworld environmental stresses (singularly orin combination cannot be duplicated practically or reliably intestlaboratories. Therefore, users of this part of Iso 16750 should not assume that a system or componentthat passes laboratory tests of this part of Iso 16750 would also pass field/ fleet verification trialsThe specified values are the best estimation one can get up to the moment when results frommeasurements in the car are received - but they do not replace a car measurement!The specified values apply to direct mounting in defined mounting locations. Using a bracket formounting can resultin higher or lower loads. If the device under test ( DUT)is used in the vehicle with abracket then all vibration and mechanical shock test shall be done with this bracketCarry out the vibration with the dut suitably mounted on a vibration table. The mounting method (sused shall be noted in the test report. Carry out the frequency variation by logarithmic sweeping of 0,5octave/minute for sinusoidal tests and the sinusoidal part of sine on random tests. The scope of therecommended vibration tests is to avoid malfunctions and breakage mainly due to fatigue in the fieldTesting for wear has special requirements and is not covered in this part of ISo 16750Loads outside of the designated test frequency ranges are to be considered separatelNOTE Deviations from the load on the DUT can result, should vibration testing be carried out according tothis part of Iso 16750 on a heavy and bulky dut, as mounting rigidity and dynamic reaction on the vibrator tableexcitation are different compared to the situation in the vehicle. This deviation can be minimized by applying theaverage control method(see Annex A)Application of the weighted average control method according to IEC 60068-2, 64 is to be agreed uponSubject the dut during the vibration test to the temperature cycle according to iEC 60068-2, 14, withelectric operation according to diagram 1. Alternatively, a test at constant temperature may be agreed onOperate the dutelectrically as indicatedin Figure l at Tmin(Short functional testafterthe dUT completelyreached Tmin). This functional test shall be as short as possible- only long enough to check the properperformance of the dUt. This minimizes self-heating of the dUT. Additional electrical operation of theDUT between 210 min and 410 min of the cycle (see Figure 1)Additional drying of test chamber air is not permittedIn the vehicle, vibration stress can occur together with extremely low or high temperatures; for thisreason, this interaction between mechanical and temperature stress is simulated in the test, too. afailure mechanism is, for example, a plastic part of a system/component, which mellows due to the hightemperature and cannot withstand the acceleration under this condition2o ISO 2012-All rights reservedIso16750-3:2012[EYmax20aburditt0100200300400500600yY temperature[°C]x time [ minIa Operating mode 3.2 according to ISo 16750-1.b Operating mode 2. 1 according to ISo 16750-1One cycleFigure 1-Temperature profile for the vibration testTable 1- Temperature versus time for the vibration testTimeTemperaturemin°C0206040150-4021020300max41048020See Is016750-44.1.2 Tests4.1.2.1 Test I- Passenger car, engine4.1.2.1.1 PurposeThis test checks the dUt for malfunctions and breakage caused by vibrationThe vibrations of a piston engine can be split up into two kinds: Sinusoidal vibration which results from theunbalanced mass forces in the cylinders and random noise due to all other vibration-schemes of an engine,C ISO 2012-All rights reserved3Iso16750-3:2012Ee.g. closing of valves. In the lowest frequency range from 10 Hz to 100 Hz the influence of rough-roadconditions is taken into account. The main failure to be identified by this test is breakage due to fatigueNOTE 1 Road profile usually has negligible impact on engine-mounted components. Shock inputs are effectivelysolated by suspension, and engine-mounting systemsThe test profiles specified in the following clauses apply to loads generated by(four strokereciprocating enginesNotE 2 If the dut is to be tested for a specific resonance effect, then a resonance dwell test according to 8.3.2of IEC 60068-2, 6: 2007 can also be applied4.12.1.2Test4.1.2.1.2.1 GeneralIt is required to perform this test as a mixed mode vibration test according to IEC 60068-2, 80NOTE The test duration is based on A 4. The temperature in the chamher is above room temperature (rt)atthe end of the test (2 3/4 temperature cycles4.1.2.1.2.2 Sinusoidal vibrationPerform the test according to IEC 60068-2, 6, but using a sweep rate of s 0,5 octave/minute. Use a testduration of 22 h for each plane of the dUTUse curve l in Table 2/ Figure 2 for DUT intended for mounting on engines with 5 cylinders or fewerUse curve 2 in Table 2/Figure 2 for dUT test intended for mounting on engines with 6 cylinders or moreBoth curves may be combined to cover all engine types in one test2502001501005050100150200250300350400450500ⅩKeyamplitude of acceleration [m/s2IXfrequency [Hzcurve1(≤5 cylinders)curve 2(5 cylindersFigure 2- Vibration severity curves4o ISO 2012-All rights reservedIso16750-3:2012[ETable 2- values for max acceleration versus frequencyCurve 1(see Figure 2FrequencyAmplitude of accelerationHz100100200200240200270100440100Curve 2(see Figure 2)FrequencyAmplitude of accelerationHm/s2100100150150440150CombinationFrequencyAmplitude of accelerationH1001001501502002002402002551504401504,1.21.2.3 Random vibrationPerform the test according to IEC 60068-2, 64. Use a test duration of 22 h for each plane of the DUTThe r.m.s. acceleration value shall be 181 m/s2The psd versus frequency are referred to in Figure 3 and Table 3NoTE The Power Spectral Density(PSD)values (random vibration] are reduced in the frequency range of thesinusoidal vibration testC ISO 2012-All rights reserved5Iso16750-3:2012EY100100,110100100010000KeyY PSD [(m/s2)2/HzX frequency [Hz]Figure 3- PSD of acceleration versus frequencyTable 3- Values for frequency and PsDFrequencyPSDH:(m/s2)2/Hz1010100103000,5150020200024.1.2.1.3 RequirementBreakage shall not occur.Functional status a see iso 16750-1) is required during operating mode 3.2 as defined in ISo 16750-1and functional status C during periods with other operating modes4.1.2.2 Test II-Passenger car, gearbox4.1.2.2.1 PurposeThis test checks the dut for malfunctions and breakage caused by vibrationThe vibrations of a gearbox can be split up into two kinds which result partly from sinusoidal vibrationfrom unbalanced mass forces of the engine(e. g dominating orders) in the frequency range from 100 Hzto 440 Hz and vibration from the friction of the gear wheels and other schemes, which are tested in therandom part. In the lowest frequency range from 10 Hz to 100 Hz the influence of rough-road conditionsis taken into account The main failure to be identified by this test is breakage due to fatigueChanging the gears can create additional mechanical shock and shall be considered separatey brationsThe test profiles specified in the following subclauses apply to loads generated by gearbox vibo ISO 2012-All rights reserved
    2020-12-08下载
    积分:1
  • 矩形优化排样
    主要研究矩形零件的排样方法,遗传算法的用途在此处体现的淋漓尽致本文算子的选择是有效的为进一步验证算法,对零件数量从16~97的不同算例进行试验,每类有3个例子,其最优排放图均已知,各个算例的基本试验数据(零件数量,板材尺寸)和本文试验最好结果见表2,表2算例2的基本试验数据及本文试验结果Tab 2 Dimension of second exampleand best result given by this paper问题零件最优高度原最优板材所得最低高度()SA+文算法结果(b)SA+最低水平线算法结果种类数量mm尺寸/mmmm2020×2020图1算例1的排放图40×15Fig 1 Layout of first example2860×3032表1本文算法与最低水平线算法排样结果对比C4496060×6064Tab. 1 Difference between our algorithm and7360×90the lowest outline algorithm9712080×120129最小高度最小高度最大高度平均高度运行时间图2给出了部分算例的最好排放结果。 Hopper算法/mm出现频次/mm/mm/ms8. Turton对以上规模不同的矩形件采用BL、BLFSA+最低水平线481/5053.716算法进行排放,允许零件旋转90°,GA、NE、SA、HCSA+本文方法483/505 I48.6等算法搜索排放顺序。文中指出采用BLF排放效果优于BL算法10%~30%,采用SA+BLF算法所得4.2算例2结果最优,见表3。(a)C11(b)C41(c)C61图2算例2采用本文算法所得的排放图ig 2 Best layout of second example with our algorithm表3各类别实例的相对距离百分比1表4各实例运行时间对比表Tab3 Relative distance of best solution toTab 4 Average elapsed time foroptimum height for six cases%six cases with different algorithm问题种类BIBLF SA+BLF本文算法问题A+BLFSA+本文算法174种类ms162.824126.7C41816132120C657.5注:1)表中值表示所得最好结果U与最优值lO)pt差值的白分比C61528189447(U-Op:)/lOpt。宇航材料工艺2007年第4期17对比表2、表3知,本文算法和文献[6]中采用图3表明:矩形排放耗时10ms,经人机交互调BLF解码的综合算法结果相近,并且在零件数量较整后材料利用率为86.4%,比人工排样提高约11少(如n=16)时能获得最优解,与埋论分析一致;由8%。表4知,本文算法的运行时间大大少于BLF算法,这5结论是因为在排放R;时只需搜索当前轮廓线段,比BLF实际算例表明最低轮廓线搜索算法能有效地进算法(搜索所有空域区域)搜索空间减少,因此效率明行矩形件排放,与模拟退火算法相结合,能在较短时显提高。由于文献[6的运行环境是:处理器奔腾间内获得与BLF算法相近的排放结果,并且在零件200MHκ,RAM65M, Windows nt4.0;而本文运行数量较少时能获得最优解,是解决大规模矩形件排放环境为:CPU2.8GHz,RAM512M,其速度大约是问题的有效方法200MHz处理器的15倍,因此表4所给BLF混合算参考文献法的运行时间做了相应处理。可见采用轮廓搜索法1张丽萍,张春丽,蒋寿伟.皮料优化排样的有效方法与BLF算法可获得相近的排放效果,但前者效率明软件学报,2005;16(2):316~323显高于后者。文献[7采用启发式递归(HR)算法对2曹炬,周济,余俊.矩形件排样优化的背包算法.中国以上算例进行求解,大大提高了运行效率,但在零件机械工程,1994;5(2):11~12数量较多时其速度也明显低于本文算法。因此最低3曹炬.二维异形切割件优化排样的拟合算法.中国机轮廓搜索法可用于求解大规模矩形件的排样问题。械工程,2000;11(4):438~4414.3应用举例1 Jakobs S On genetic algorithms for the packing of针对不规则复合材料铺层,采用矩形包络法求出 polygons,Eur. of oper,Res.,1996881):165-181其包络矩形,然后采用上述算法进行排放。图3是飞5贾志欣.面向发电设备制造的下料优化排样原理与关机坐舱罩顶棚的铺层展开数据采用以上策略获得的键技术,四川大学博士学位论文,2002排放图。6 Hopper E, Turton B C H. An empirical investigationof meta-heuristic and heuristic algorithms for a 2D packingproblem. EurJ of Oper Res, 2001; 128(1): 34577 Zhang Defu, Kang Yan, Deng Ansheng. A new heuristicrecursive algorithm for the strip rectangular packing problemComputers &. Operations Research, 2006; 33(8): 2209-2 217图3复合材料铺层排放实例(编辑李洪泉)ig. 3 Layout for composites plys18宇航材料工艺2007年第4期矩形件优化排样的研究旧万数据WANFANG DATA文献链接作者:邓冬梅,厝米水,安鲁陵,王桂宾, Deng Dongmei, Zhou laishui, An Luling,Wang guibin作者单位:南京航空航天大学机电学院,南京,210016刊名宇航材料工艺sTc|PKU英文刊名:AEROSPACe mATERIALS technology年,卷(期):2007,37(4)被引用次数4次惨考文献(条)1.张丽萍.张春丽.蒋寿伟皮料优化排样的有效方法[期刊论文]软件学报2005(02)2.曹炬.周济.余俊矩形件排样优化的背包算法[期刊论文]中国机械工程1994(02)3.曹炬二维异形切割件优化排样的拟合算法「期刊论文]中国机械工程2000(044.Jakobs S On geretic algorithms for the packing of polygons 1996 (05.贾志欣面向发电设备制造的下料优化排样原理与关键技术[学位论文]20026. Hopper E Turton B C H An empirical investigation of meta-heuristic and heuristic algorithms for a 2Dpacking problem 2001(01)7. Zhang Defu. Kang Yan. Deng Ansheng A new heuristic recursive algorithm for the strip rectangularpacking problem 2006 (08)相似文献(1条)1.学位论文邓冬梅复合材料铺层排样抆术硏究与开发2007复合材料因其比强度高、比模量大、材料的刚度和强度可设汁等一系列优点,在航空航天领域得到广泛应用,但高昂的价咯成了复合材料应用的最大壁垒。国外的硏究和应用成果表明数字化技术是降低复合材料构件制造成本、提高构件性能的有效途径。目前国内主要还以手工没计和手工制造为主、自动化程度不高,不仅浪费人力、物力,而且产品质量难以保证,因此有必要对复合材料数字化技术进行研究。优化排样是复合材料构件数字化生产过程中的重要环节。本文在研宄各种排样算法的基础上,提岀丁新的矩形件排样算法、优化算法以及不规则样片的排样算法,并与复合材料铺层排样的特点相结合开发了复合材料铺层排样软仁。主要研究内容和创新点如下矩形件排样不仅适用于矩形样片的排放,也是不规则样片排咩的基础。本文在建立矩形件排样数学模型的基础上,介绍了各种常见的定序列矩形件排样算法并分析其特点,提出了一种新的启发式排样算法——最低轮廓线搜索算法。该算法满足“最下最左”条件,克服了其他排样算法对某些排栏图不能给出排列的缺点,实验结果表明该算法排样效果好于最低水平线算法和最下最左(BL)算法。利用该算法实现了大量不同规格图纸的集中出图,省时省力,节约氏张2050%。矩形件排样问题具有图形运算和组合优化两方面的特性,单纯的排样算法只能解决图形运算问题,样片的排放顺序对排样结果同样重要。针对较小规模(一般少于100个图形)的矩形件排样问题,本文提岀了模拟退火与最低轮廓线搜索算法相结合的综合优化算法。对于十多个图形的排样,该算法可短时间内求得最优舾:对于近百个图形的排样,在排样效果相当旳情冮下,该亥算法比其基于模拟退火的综合优化算法效率提髙百以饣。针对大规模矩形件排样问题本文提出了蚁群笪法与最低轸廓线搜索算法相结合旳综合优化算法,该算法比模拟退火与最低轮廓线算法相结合的综合优化算法效率提高十倍以上。不规则图形排栏是所有排样研究中的热点和难点。本文将不规则样片简化成多边形进行排样,提出了两种不同的解法方法:一是基于矩形的排样方法,二是直接对多边形进行排样。基于矩形求解不规则样片排样时,将图形运算、矩形件排样算法及交互调整相结合,提出了基于矩形的多边形综合排样算法。通过各种优化组合策略,对单一样片和多种样片进行组合求其最小包络矩形,从而将不规则形状样片排样转化为矩形件排样进行求解。直接冄放多边形时,重点研究两个多边形的临界多边形(NFP)的求解。首先对基于倾斜图法的NFP求解法进行了改进和优化,完善了凹、凸两多边形NFP的求解,然后提出了适用于任意两多边形N求解的边界绕行法,该方法比基于倾斜图的求解方法适用范围广,计算简单、效率高。根据复合材料构件数宇化生产的主要过程,分析总结了复合材料铺层排样的特点,并将伉化排样算法与复合材料铺层排样的特点相结合,设计丌发了复合材料构件铺层排栏软件系统。引证文献(3条)1.卢远志杨建新.文桂林.周兵.钟志华基于排样思想的工程图坐标尺寸防干涉方法[期刊论文]中南大学学报(自然科学版)2010(2)2.张伟.安鲁陵.邵挠眀.郑盈一种矩形件分层排样算法[期刊论文]宇航材料工艺2010(1)3.陈婷.许超钣金零件排样技术及其发展[期刊论文]锻压装备与制造技术2008(4)本文链接http://d.wanfangdata.comcn/periodicAlyhclgy200704005.aspx授权使用:广东工业大学图书馆( gdgydxtsg),授权号:4flc88c5-bfdd-4dec-8ebf-9ec501113fe6下载时间:2011年4月14日
    2020-12-09下载
    积分:1
  • 基于薄板样条的图像配准MATLAB代码
    基于薄板样条的图像配准MATLAB代码,已测试可以正常运行
    2020-11-28下载
    积分:1
  • FOC矢量控制参考代码
    采用SVPWM和FOC矢量控制实现电机控制
    2020-11-28下载
    积分:1
  • 模拟退火算法进行函数优化 matlab
    使用模拟退火算法进行函数优化,使用matlab编写,f为目标函数,mnth.m为模拟退火算法调用f.m解决问题的代码
    2020-12-06下载
    积分:1
  • Winform通过NPOI导出excel
    将Winform中的datagridview中的数据通过Excel导出,用SaveFileDialog指定位置导出,用到的技术是NPOI,不受office组件的影响。
    2020-06-08下载
    积分:1
  • 基于FPGA的信号发生器
    1. 信号发生器在同一端口能产生正弦波、锯齿波、方波、和三角四种周期性波形。2. 输出频率范围10Hz~10MHz。3. 实现输出信号频率和幅度可调节。1.根据设计要求,合理选择系统所需的外设组件,并完成相应电路的设计;能够完成各模块的状态转换的分析; 2.根据设计要求,确定系统架构并利用硬件描述语言设计各个功能模块;3.利用Modelsim完成各个功能模块的仿真;4. 完成系统联调,下板并给出系统调试的结果。
    2021-05-06下载
    积分:1
  • 最大效用频谱分配算法
    关于认知无线电频谱分配方面的知识,希望对寻找资源的同学有帮助第37卷第19期何利,郑湘渝,刘振坤:基于图着色理论的最大效用频谱分配算法9542最大平均效用ISAA,但小于CSGC的时问开销。但是由图2可知,在同一图2分别给出了CSGC、ISAA和MUAA3种算法在用频谱数目下,MUAA算法的最大平均效用是最高的,并且随户取值为7和12时的最大平均效用。随着系统中频谱数的不着系统中频谱数目的増多,MUAA算法的最大平均效用高于淅增加,3种算法的最大平均效用基本呈现上升趋势,但是SAA算法,ISAA算法和(S(C算法的效用相同。MUAA算MUAA算法的最大平均效用増加趋势大于CSGC和ISAA算法以牺牲较少的时间开销获得了较大的系统效用,可见,法,这是因为随着频谱数目增加,MUAA算法的用户提高了MUAA算法是这3种算法中最优的。频谱的复用率。5结束语120本文研究了认知无线电网络屮基于图论着色模型的频谱H-ISAAMUAA分配算法,在分析CSGC、ISAA存在的问题基础上,提出兼CSGC顾系统效用和时间开销的MUAA算法,并对3种算法在系统效用和时间开销方面进行仿真比较。仿真结果表明,MUAA算法是有效的。下一步工作是将ISAA的并行计算方法应用2个到MUAA屮,在不增加时间开销的基础上,提高频谱分配的系统效用。参考文献[1] Shared Spectrum Company. Dynamic Spectrum Use[EB/OLI频谱数日(2007-04-25).http://www.sharedspectrum.com(an=7[2]Zheng Haitao, Peng Chunyi. Collaboration and Fairness inOpportunistic Spectrum Access[C]/Proc. of the 40th AnnuaMUAAInlernatiunal Conference on Communications. Seoul Kurea: Ieee3]廖楚林,陈劼,唐有喜,等.认知无限电中的并行频谱分配算法[J.电子与信息学报,2007,29(7:1608-1611[4 Wang Jiao, Huang Yuqing, Jiang Hong. Improved algorithm ofSpectrum Allocation Based on Graph Coloring Model in CognitiveRadio[clproc. of International Conference on Communicationsand Mubile Conputing. Washington D. C, USA: IEEE CoInputer频谱数目ociety,2009:353-357[S]彭振,赵知劲.基于混合蛙跣算法的认知无线电频谱分配[门.图2CsGC、ISAA和MUAA的最大平均效用计算机工程,2010,36(6):210-212.综上所述,由图1可知,MUAA算法的时间开销稍大」编辑陆燕菲(上接第92页信道下本地频谱感知和认知网络合作频谱感知进行研究和仿真,结果表明,合作频谱感知能明显改善 Rician衰洛信道的检测效果。下一步工作是研究其他衰落信道如 Nakagami信道下无线认知网络的合作频谱感知参考文献[]周贤伟.软件无线电M].北京:国防工业出版社,2008AWGN[2 Ghascmi A, Sousa E s. Collaborative Spcctrum Sensing forOpportunistic Access in Fading Environments[C]//Proc. of the Ist10IEEE SYmp. on Dynamic Spectrum Access Networks, Baltimore,103锴误警报概率USA: IEEE Press. 2005: 131-136图4不同用户数目时合作频谱感知的ROC曲线[3] Digham FF, Alouini M S, Simon M K On the Energy Detection of4绪束语Unknown Signals over Fading Channels[C]/Proc. of ICC"03在深度阴影衰落环境屮,认知用户需要合作频谱感知来Ottawa Canada: IEEE Press. 2003: 3575-3579检测到主用户的存在。 Rician信道模型适用于郊区或农村建4 Fctc b a.认知无线电技术lMJ.赵知劲,郑什链,尚俊娜,译模,以后将可能广泛应用,因此,对 Rician衰落信道的认知北京:科学出版社,2008网络合作频谱感知的研究具有重要意义。本文对 Rician衰落编辑金胡考C1994-2012ChinaAcademicJournalElcctronicPublishinghOusc.Allrightsrescrved.http://www.cnki.nct
    2020-12-01下载
    积分:1
  • 696518资源总数
  • 106148会员总数
  • 10今日下载