浅谈Excel自编函数在"村村通"直播卫星用户资料录入中的应用

国家发改委、广电总局编制印发了《全国"十二五"广播电视村村通工程建设规划》,明确"十二五"期间村村通工程建设目标任务是,到2015年底,基本完成广播电视村村通工程建设任务,基本实现广播电视"户户通"。在村村通用户平台,各县要完成辖区内上万用户的基本资料的录入,在"村村通"单机版信息录入当中,由于不能验证身份证号的准确性,给信息录入人员在审核身份证号带来了很大的工作量,本文通过以excel函数和身份证号的末尾识别码,运用自编函数来保证了身份证号录入准确性。     

资格认证程序

申请参加资格认证的人员首先要填写资格认证预审表，预审表内容为：姓名、身份证号、文化程度、申报工种、鉴定级别，参加工作时间、申报工种工龄，并应提交身份证、毕业证和原职业资格证书。     

资格认证程序

一、申请 参加资格认证的人员首先要填写资格认证预审表，预审表内容为：姓名、身份证号、文化程度、申报工种、鉴定级别，参加工作时间、申报工种工龄，并应提交身份证、毕业证和原职业资格证书。     

资格认证过程

一、申报 申请参加资格认证的人员首先要填写资格认证预审表，预审表内容为：姓名、身份证号、文化程度、申报工种、鉴定级别，工作单位、参加工作时间、申报工种工龄，并应提交身份证、毕业证和原职业资格证书。     

超值型32位MCU提供自定义管脚功能

技术的演进需要对许多软硬件方案进行升级,一般来说,如需升级原有的16位设计,获得更高性能和应用灵活性,设计人员不得不选择针对更加复杂应用设计的高端微控制器.     

美研制出能存储三位数值的纳米线存储器

<正>传统存储器件仅能存储"0","1"两位值,而美国宾夕法尼亚大学研究人员研制的一种以纳米线为基础的新型信息存储器件却能存储"0"、"1"和"2"3位数值。这—创造可能催生新—代高性能信息存储器。相关研究发表在近日《纳米快报》在线版上。     

伊万推出两款新品万用表ET111和VC105

ET111超级智能数字存储万用表 ET111万用表具有41／2位分辨力,基本测量精度达万分之五。该万用表具有定时测量功能,比如对充电电池充放电试验,不需人员职守,长达100小时及100组数据,该万用表可以完全自动记录全部过程。该表还具有最大／最小值记录、误差分选和正弦波信号输出等创新的功能组合,适合实验室人员测试、维修之用!     

空调系统按需新风控制策略的研究综述

讨论了新风量与空调能耗的关系,并综述了按需控制通风策略的研究现状。按需控制通风通常采用反映房间内人员负荷密度的CO2浓度作为室内人员相关污染物的控制指标。根据实际工程具体情况,按需控制通风与其他通风控制策略的结合更能够达到保证室内空气品质和节约电耗的目的,是一种比较有前景的通风控制策略。     

ZiLOG为8位闪存微控制器推出嵌入式网络安全套件

ZiLOG公司近日为其eZ80Acclaim高性能8位闪存微控制器家族产品推出一款嵌入式网络安全工具包——ez80F91模块化开发套件。该套件可使设计人员开发需采用SSL技术的安全数据传输嵌入式TCP／IP网络应用。     

超晶格自生成工艺推动蓝光二极管进程

Notre Dame大学电子工程分部的研究人员一次偶然的发现有可能谱写一种新的技术标准:一种制造激光二极管和其它先进混合式半导体器件的新标准。 其中的两位研究人员已经推导出一条构造自然超点阵形态材料的捷径,完全摒弃原来那种需费九牛二虎之力的延伸式沉积法。利用这种技术Se(硒)和Te(碲)原子可在Zi衬底上周期性形成层状结构。由此可见在正确     

Low complexity iterative decoding for bit-interleaved coded modulation

Bit-interleaved coded modulation with iterative decoding (ID) is an effective scheme for both AWGN and fading channels because it simultaneously realizes large Euclidean distance and high diversity. In the literature, ID schemes with hard-decision feedback (HDF), as well as soft-decision feedback (SDF), have been investigated. While HDF/ID exhibits a performance inferior to SDF/ID, it is much simpler to implement. To enhance the performance of HDF/ID with moderate additional complexity, we propose a uniform soft-decision feedback ID (USF/ID) scheme. The proposed scheme is applicable in both single antenna and multiple antenna communication systems. The simulation results verify that it achieves impressive performance gain over HDF/ID and has a practically more attractive implementation than SDF/ID, especially for complexity-constrained wireless applications.     

A dynamic ID management protocol for CSMA/IC in ad hoc networks

Contention based MAC protocols are widely used in ad hoc networks because they are suitable, where no central control node exists. However, contention based MAC protocols waste much time because of frequent collisions and long contention times. Moreover, it is hard for them to fairly distribute medium access opportunities. As a result, the problem of unfair medium access may arise under normal network conditions. Recently, another contention based MAC protocol, named the Carrier Sense Multiple Access/ID Countdown (CSMA/IC) was proposed. CSMA/IC resolves medium access contention by comparing the IDs of contending nodes with a simple signaling process. Therefore, medium access collisions never happen as long as each node possesses a unique ID, and the time cost for contention may be smaller than any other contention based MAC protocols if the number of IDs is managed so as to be as small as possible. Furthermore, CSMA/IC may support fair medium access by manipulating the ID of each node properly. In this paper, we propose a novel dynamic ID management protocol which enables a node to acquire a unique ID without any message exchanges and fairly distributed the number of medium access opportunities to all contending nodes. The proposed protocol also makes the contention process of CSMA/IC efficient by dynamically managing the length of the ID field according to the network traffic. The simulation results show that the proposed ID management protocol significantly improves the aforementioned aspects of CSMA/IC MAC protocol compared to previous ID management schemes.     

基于AVR单片机的125kHz简易RFID阅读器设计

射频识别技术已广泛应用于生产、生活的众多领域,该技术给人们的生活带来了众多的方便。介绍一种以AVR单片机为核心,并利用分立元件构成的125 kHz RFID阅读器设计,电路结构简单、无需读卡基站芯片、成本极低,用于读取EM4100ID卡,读卡距离可达8～15 cm。同时介绍了EM4100射频ID卡的结构及工作原理,提出一种应用AVR单片机对EM4100卡进行解码的软件设计方法。实验验证了方案的可行性和系统的稳定性,可将其应用于门禁、公交等系统中。     

一种适合3G移动的微支付方案

本方案提出利用改进后3G入网认证机制中密钥和随机数,结合AES算法生成安全性高的一次性签名,且计算量和存储量很少,具有不可否认性,还利用了登录第三方网站后生成的用户临时标识,具有很好的匿名性和不可跟踪性。其中商家受到第三方的监视和管理,防止用户和商家的欺诈,用户收到商品后对商家的信用进行评价,具有公平性。该方案交易灵活、效率高,适合3G用户实行微支付交易。     

Modeling and performance analysis of VI‐CRA: A congestion control algorithm for vehicular networks

This study proposes a Vehicle ID‐based CAM Rate Adaptation (VI‐CRA) algorithm for beacon messages in the vehicular network. Foremost, an improved vehicle ID–based analytical model is proposed at the MAC layer of vehicular network. The model weighs the random back‐off number chosen by vehicles participating in the back‐off process, with the vehicle ID incorporated in their respective CAMs. This eventually leads to the selection of a vehicle ID–based random back‐off number, minimizing the probability of collision due to same back‐off number selection. It is worth noting that the improved analytical model outperforms the existing works in terms of average packet delay since only one fourth of the contention window size is used throughout the simulation. To enhance the performance of the analytical model, the paper incorporates a congestion control algorithm, by adapting the rate of CAM broadcast over the control channel. The algorithm is designed considering a wide range of scenarios, ranging from nonsaturated to extremely saturated network (in terms of collision probability) and sparsely distributed to teemed network (in terms of vehicular density). For better analyses of simulation results, the algorithm is applied over different vehicle ID–based back‐off numbers. Simulation results for all the back‐off numbers show that vehicle ID–based CAM rate adaptation algorithm performs better than the traditional fixed CAM rate IEEE 802.11p, even at high vehicular density.     

An artificial fingerprint device (AFD): a study of identification number applications utilizing characteristics variation of polycrystalline silicon TFTs

An idea for obtaining unique identification (ID) numbers using polycrystalline silicon (poly-Si) thin-film transistors (TFTs) with a logic LSI compatible process is proposed. Like an actual human fingerprint, the characteristic variations of poly-Si TFTs are utilized for ID numbers in LSIs. The variation of poly-Si TFT characteristics is random, and this method offers unique, nonalterable, and nonduplicable numbers without any special processes, unlike other methods such as flash memory and mask ROM. These characteristics are highly suitable for ID number applications. The device physics of poly-Si TFTs for realizing the stable recognition of ID numbers was studied and a recognition circuit is proposed. The design guidelines for the grain size of poly-Si and AFD applications are also discussed.     

A visual model weighted cosine transform for hiding watermark in images

Watermarking is a technique for labeling digital pictures by hiding secret information into images. Watermark embedding is a method to discourage unauthorized copying and identify the owner or distributor of digital data. In this paper, a new method is proposed. The watermark is processed as a visually recognizable pattern-binary image, which includes more information than the traditional symbol or ID number and is "extracted" instead of only "detected" to characterize the owner. The watermark is hidden in the host image by selectively modifying the middle-frequency part of the host image in conjunction with the human visual system(HVS) and the image discrete cosine transform(DCT). The experimental results show that this method can survive image cropping and image compression, and get better results, this is also a prospective method.     

Split-aloha algorithm for radio frequency identification system

Anti-Collision algorithm is one of the most important components of radio frequency identification (RFID) technology, which possesses a key position in the performance of the whole system. ALOHA algorithm is one of the most popular methods to solve the collision problem because of its efficiency and practicability. The grouping method has been developed for enhancing the performance of conventional ALOHA when there are thousands of tags. However, the existing grouping method has limitations in applications due to its rigorous requirements for the estimation of the number of backlog tags or the admirable characteristics of the tags' ID number. Working on the improvement of the grouping methods, we proposed an algorithm named split-ALOHA with a novel grouping method that split tags as a binary tree. The novel grouping method makes it more practicable than the existing grouping methods due to the simplified requirements for tags. Simulations of the proposed algorithm show the superior performance of a linearly increasing of the number of consumed time slots while the number of tags increases. The algorithm performance analysis between split-ALOHA and ALOHA algorithms with other grouping methods has been implemented in a proper way.     

Man-computer graphics for computer-aided design

This paper reviews the history, concepts, state-of-the-art, and future directions of the use of man-computer graphics for computer-aided design. Computer-aided design is based on a real-time graphical dialogue between the man and the computer in which the man draws on a display by means of a "light pen" or other input device. The computer "understands" the picture, makes calculations based on it, and presents the results pictorially to the user for his approval or revision. This man-computer graphical conversation has been made possible by recent advances in the speed of the digital computer, time-sharing programming, computer-driven display technology, and graphical input devices. The light pen is the most commonly used graphical input device, but keyboards, joysticks, flat matrix arrays, and other devices are also used. The programming state-of-the-art is a limiting factor in the implementatation of graphical computer-aided design; much work remains to be done in systems programming, efficient time sharing, list structure concepts, file organization, and memory protection. A number of experimental equipment configurations in use in various laboratories are cited and the hardware state-of-the-art is reviewed. Several experimental and production applications of computer-aided design evolved in a large aircraft company are described and illustrated, by display photographs. These applications relate to structural analysis, dynamics, information retrieval, accounting, and numerical control tape preparation. For the future, advances are required in improved man-computer communication, techniques to permit the operation of displays at great distances from the central computer, and methods of inputting existing drawings into the computer in a meaningful form.     

基于并行BP神经网络的路由查找算法

结合Bloom-filter算法和并行反向传播神经网络,提出了一种新的基于并行神经网络的路由查找算法(BFBP)。该算法满足路由查找的需求,只需学习路由条目的网络ID,且易于扩展到IPv6地址查询。研究结果表明,相比于己有的神经网络路由查找方法,该算法需要学习的条目数平均减少了520倍,提高了学习效率,为神经网络应用于路由查找创造了有利条件。