Excel在微生物培养条件优化中的应用

根据正交试验设计的原理,采用Microsoft Excel软件编制优化微生物培养条件的程序,并以实例说明了该程序的使用方法。结果表明,用户只需输入试验的原始数据,即可快速、准确地进行直观分析和方差分析,并可根据极差值得出最佳工艺条件,从而大大提高微生物发酵的效率。     

计算机技术在群纱表制作和群落分类中的应用

介绍利用Microsoft Foxpro和Excel软件编写程序,实现法瑞学派植物群落分类方法中群落表制作各个步骤的新技术,说明了制表程序的运行程序,并规定了该程序所需要的数据格多。这一技术简化了传统制表过程。本文提供了一个利用此新技术对33个样地进行制表和群落分类的实例。     

利用Excel的VBA语言自动分析大量共聚焦线扫描图像数据的方法

目的：Microsoft Excel的内置控制语言是VBA(visual basic for application)。它可以极大地增强Excel的数据处理能力。本文通过一个简单的例子说明如何利用VBA自动分析大量共聚焦线扫描图像数据并图示分析结果。方法与结果：文中首先描述了取自共聚焦线扫描图像的实验数据的结构及处理要求。然后具体说明宏程序(用VBA编写)的录制、修改和使用的详细方法。宏程序代码很接近自然语言,较好理解,而且在大多数情况下可通过“录制宏”功能自动生成,把编程的工作减至最少。结论：与手工使用Excel一步步进行数据处理相比,使用Excel中的VBA处理数据可少花时间、少犯错误、减少大量单调重复的劳动．．这些可极大地提高数据处理效率,使研究者可把更多的时间用于数据处理方案的设计和完善上。特别在处理量大而复杂的实验数据时更需要如此。这样,数据中蕴含的有用信息才能更好地被有效而准确地提取出来并加以显示。     

Excel在药学数据分析工作中的应用

目的：采用常用的电子表格处理系统Microsoft Excel解决药学实验过程中遇到的数据分析问题。方法：应用工作表函数中内置的统计函数,以线性回归为例说明源数据的输入与结果返回的具体操作过程;对数据分析工具中的＂描述统计＂工具、t检验与方差分析,结合具体实例对药学实践中遇到的药学统计实际问题进行综合探讨。结果：用Excel表中内置的统计函数工具进行线性回归分析,方法简单、结果可靠;Excel表中的数据分析工具适用于日常药学实验数据分析过程中遇到的描述统计分析、t检验与方差分析。Excel与其它数据处理软件相比具有操作快捷、使用方便、计算精确、易于学习与掌握等优点。结论：Excel友好的界面,清晰的统计分析结果,使医药工作者在使用Excel的数据分析软件时会感到非常的方便快捷,灵活实用,值得在药学实践中应用推广。     

利用VBA查找核酸数据库DNA保守序列

采用VBA编写了查找核酸数据库保守序列的四个相关程序,“导入DNA序列”程序可以将Fasta格式的DNA序列文本文件存放到Excel Sheetl的A列中,保留每个序列的Gi号,删除多余的注释部分;“整理DNA序列”程序可以将DNA序列Gi号存放到A列中,B列为对应Gi号的完整序列;“DNA随机序列”程序可以产生DNA随机序列;“发现DNA保守序列”程序可以将随机序列与下载的DNA序列比对,查找每一种随机序列的出现频率.以大豆基因组序列为实例,说明了这些程序的应用方法.该程序弥补了流行序列比对软件的不足,为PCR设计引物、分析基因功能以及种质资源鉴定等方面提供新的工具.     

Excel和SAS在生物统计学的应用比较

对Excel和SAS在生物统计学的应用特点及存在问题进行了比较,指出Excel制作的统计图形美观Z函数可直接给出结果,公式编辑简便实用,具有“数据分析”功能,但也存在fx和“数据分析”结果不一致的地方,加载“数据分析”工具时需要插入“Microsoft Office”初始安装盘,不能进行平均数的多重比较以及高级试验统计的结果分析。SAS的生物统计功能齐全,操作界面直观,程序模式化;但与Excel相比,相对烦琐而复杂。因此,在生物统计教学和科研工作中,应针对所处理问题的性质和目的选用不同的统计分析软件。     

MapDraw，在Excel中绘制遗传连锁图的宏

MAPMAKER是现今广泛使用的遗传连锁数据分析软件,然而其广泛使用的DOS版本却不具有连锁图绘制功能,给连锁作图工作带来了相当大的麻烦。为了解决这一问题,我们以大家广泛使用的数据处理软件Microsoft Excel为平台,编写了一个Excel宏——MapDraw来在轻松的操作中实现遗传连锁图的绘制。 Abstract:MAPMAKER is one of the most widely used computer software package for constructing genetic linkage maps.However,the PC version,MAPMAKER 3.0 for PC,could not draw the genetic linkage maps that its Macintosh version,MAPMAKER 3.0 for Macintosh,was able to do.Especially in recent years,Macintosh computer is much less popular than PC.Most of the geneticists use PC to analyze their genetic linkage data.So a new computer software to draw the same genetic linkage maps on PC as the MAPMAKER for Macintosh to do on Macintosh has been crying for.Microsoft Excel,one component of Microsoft Office package,is one of the most popular software in laboratory data processing.Microsoft Visual Basic for Applications (VBA) is one of the most powerful functions of Microsoft Excel.Using this program language,we can take creative control of Excel,including genetic linkage map construction,automatic data processing and more.In this paper,a Microsoft Excel macro called MapDraw is constructed to draw genetic linkage maps on PC computer based on given genetic linkage data.Use this software,you can freely construct beautiful genetic linkage map in Excel and freely edit and copy it to Word or other application.This software is just an Excel format file.You can freely copy it from ftp://211.69.140.177 or ftp://brassica.hzau.edu.cn and the source code can be found in Excel′s Visual Basic Editor.     

SPSS方差分析在生物统计的应用

方差分析是生物统计中常采用的一种方法。如何使用统计分析软件进行方差分析来实现对研究结果的快速和科学的处理,获得正确的结论,是生物学研究中重要的一环。本文通过实例介绍了如何使用SPSS(Statistical Package for the Social Science or Statistic Products and Service Solution)数据分析工具进行方差分析的方法;实现了数据分析和处理的快捷、准确和直观;与Excel相比,SPSS的统计分析功能更为强大,既有利于提高数据处理效率,又降低了实验成本。     

microRNA相关专利分析

目的:分析microRNA(miRNA)相关专利,为我国miRNA科学研究和决策提供一定的参考。方法:运用专利文献计量学方法,使用TDA软件和Excel程序,对DII数据库中收录的miRNA相关专利的年份、国别、专利家族分布、专利权人、发明人和Derwent手工码进行分析。结果:发现了miRNA相关专利的年份分布、主要国家或组织的专利家族分布、前十位专利权人分布、前十位发明人分布及所涉及的Derwent手工代码分布情况。结论:我国在相关专利数量上虽然处于相对领先地位,但与美国等国相比仍存在很大差距,同时miRNA相关专利的专利家族多局限于本国,未曾形成一种广泛的多国高度分布的专利家族形势,缺乏对专利主动运用以获取专利信息和竞争优势的意识。     

瑞典河漫滩草甸植被的数量分类和排序

本文用目前各国学者广泛使用的一些数量分类和排序方法对瑞典河漫滩草甸样地资料进行了分类和排序。所用的方法包括多元等级聚合分类(TABORD程序),多元等级分划分类(TWINSPAN程序),PCA排序(ORDINA程序),RA和DCA排序(DECORANA程序)。研究结果表明可以把28个样地分为6个群落类型,它们的分布格局是与土壤水分梯度密切相关的。此外本文还对数量分类和排序方法在植物群落学研究中的应用以及所用方法的比较进行了讨论。     

Spreadsheet-based program for alignment of overlapping DNA sequences.

Molecular biology laboratories frequently face the challenge of aligning small overlapping DNA sequences derived from a long DNA segment. Here, we present a short program that can be used to adapt Excel spreadsheets as a tool for aligning DNA sequences, regardless of their orientation. The program runs on any Windows or Macintosh operating system computer with Excel 97 or Excel 98. The program is available for use as an Excel file, which can be downloaded from the BioTechniques Web site. Upon execution, the program opens a specially designed customized workbook and is capable of identifying overlapping regions between two sequence fragments and displaying the sequence alignment. It also performs a number of specialized functions such as recognition of restriction enzyme cutting sites and CpG island mapping without costly specialized software.     

Microarray data assembler

SUMMARY: Large volumes of microarray data are generated and deposited in public databases. Most of this data is in the form of tab-delimited text files or Excel spreadsheets. Combining data from several of these files to reanalyze these data sets is time consuming. Microarray Data Assembler is specifically designed to simplify this task. The program can list files and data sources, convert selected text files into Excel files and assemble data across multiple Excel worksheets and workbooks. This program thus makes data assembling easy, saves time and helps avoid manual error. AVAILABILITY: The program is freely available for non-profit use, via email request from the author, after signing a Material Transfer Agreement with Johns Hopkins University.     

Comparison between In-house developed and Diamond commercial software for patient specific independent monitor unit calculation and verification with heterogeneity corrections

The study was aimed to compare two different monitor unit (MU) or dose verification software in volumetric modulated arc therapy (VMAT) using modified Clarkson's integration technique for 6 MV photons beams. In-house Excel Spreadsheet based monitor unit verification calculation (MUVC) program and PTW's DIAMOND secondary check software (SCS), version-6 were used as a secondary check to verify the monitor unit (MU) or dose calculated by treatment planning system (TPS). In this study 180 patients were grouped into 61 head and neck, 39 thorax and 80 pelvic sites. Verification plans are created using PTW OCTAVIUS-4D phantom and also measured using 729 detector chamber and array with isocentre as the suitable point of measurement for each field. In the analysis of 154 clinically approved VMAT plans with isocentre at a region above −350 HU, using heterogeneity corrections, In-house Spreadsheet based MUVC program and Diamond SCS showed good agreement TPS. The overall percentage average deviations for all sites were (−0.93% + 1.59%) and (1.37% + 2.72%) for In-house Excel Spreadsheet based MUVC program and Diamond SCS respectively. For 26 clinically approved VMAT plans with isocentre at a region below −350 HU showed higher variations for both In-house Spreadsheet based MUVC program and Diamond SCS. It can be concluded that for patient specific quality assurance (QA), the In-house Excel Spreadsheet based MUVC program and Diamond SCS can be used as a simple and fast accompanying to measurement based verification for plans with isocentre at a region above −350 HU.     

Software for analysis of bacterial genomes

GenomeExplorer is a program for comparative analysis of regulation in prokaryotic genomes. The program has options for signal search, comparison of gene samples, search for paralogs and orthologs, iterative construction of signal profiles. The program has a convenient graphic interface, allowing for navigation in the annotation window, in the genome map, and in the table of gene similarities. The use of the system clipboard allows one to export the results of analysis into Word and Excel, and to call external programs via the Internet.     

Computer-assisted simulations of phosphofructokinase-1 kinetics using simplified velocity equations

Equations useful for simulating the kinetic behavior of phosphofructokinase are presented. The equations, which are based on the concerted transition (symmetry) model for allosteric enzymes, account for substrate inhibition by MgATP, cooperative binding by F-6-P, activation by F-2,6-P₂, and deinhibition by AMP. Velocity calculations can be performed using either a spreadsheet program (e.g., MS Excel) or a web-based program (e.g., Authorware). Both approaches are illustrated.     

A simple program to measure and analyse tree rings using Excel,R and SigmaScan

I present a new software that links a program for image analysis (SigmaScan), one for spreadsheets (Excel) and one for statistical analysis (R) for applications of tree-ring analysis. The first macro measures ring width marked by the user on scanned images, stores raw and detrended data in Excel and calculates the distance to the pith and inter-series correlations. A second macro measures darkness along a defined path to identify latewood–earlywood transition in conifers, and a third shows the potential for automatic detection of boundaries. Written in Visual Basic for Applications, the code makes use of the advantages of existing programs and is consequently very economic and relatively simple to adjust to the requirements of specific projects or to expand making use of already available code.