Excel File Statistics

Used to generate random networks of any size. Necessary parameters only the number of nodes, the largest number of out-arc, the maximum interval between adjacent nodes (node number), and two parameters of beta distribution of , the output to a Excel file

Through a simple GUI, the user can select a signal by entering its name and its new name.The script can take inputs as simple strings, or Excel files.In the Excel file, there should be the names of signals to be replaced and the name to be replaced with.

Act Amort allows you to enter a loan amount, payment amount, interest rate, and/or loan duration (in months). After entering three of these values, the fourth may be calculated. Total interest, payments and ending balance are automatically computed. In addition you may create a printable payment...


Platforms: Mac

This user interface allows a user to load some Affymetrix data in an Excel file and perform some basic operations on it - log transform, log ratio, normalization, noise reduction, filtering, PCA and clustering, in addition to some visualizations like profile plots, boxplots and matrix...


Platforms: Matlab

xlscell(xcell,value)xlscell(xcell,value,filename)xlscell(xcell,value,filename,sheetname) xcell: cell name (range) (ex. C3 or A2:F19)value: value(s) to assign to specified cell.filename: Name of excel file.sheetname: sheet name. Examples:filename = 'file.xls';value =...


Platforms: Matlab

This program reads a (text data file) consisting of headers, column titles and column data (see attached data.txt). Then it opens or creates existing excel file and saves data into specified sheetname.NOTE: The program will automatically identify the number of headerlines, columns and the column...


Platforms: Matlab

Creates new Excel file (or opens it if file exists) and name the sheets as listed in (sheetnames) and saves the workbook as (filename).xlsheets(sheetnames,filename)xlsheets(sheetnames)sheetnames: List of sheet names (cell array).filename: Name of excel file.NOTE: Follow the following rules when...


Platforms: Matlab

This is a MATLAB Excel Builder demo. This demo shows how you can compile a MATLAB code into an Excel based COM component and use the same in an Excel Visal Basic environment. The example used in this demo is the simulation of a bouncing ball using MATLAB ODE solvers.Download the exe (zip archive)...


Platforms: Matlab

I wrote this for a friend who likes to use Excel to track the issues reported by the M-Lint code analyzer on her code. She explained that she would paste the M-Lint report into Microsfot Excel and check off each item as she fixed it.This file automatically creates a Microsoft Excel file...


Platforms: Matlab

Smoothicons 7 - by Corey Marion Smooth application icons including Excel & Preview. Keywords: airport america aol app apple appleworks application backup base bold browse browser calculator color colorful computer corey custom default drawn dreamweaver dvd editor entourage envelope excel file...


Platforms: Mac

This potential flow simulator simulates the flow past bodies of arbitrary shape including airfoils. With this simulator, we can do the following tasks,d-OCoDo Compute and plot the Velocity Vector Plot of the flow past the selected body.d-OCoDo Compute and plot the Pressure Distribution in terms...


Platforms: Matlab

This program uses an Excel data file "DATA.xls" as an input to the program. the input file consists these worksheets: 1.input load data (active power of each load block and their X-Y cooedinates 2. present transformers and their capacities in kVA 3. candidate points for new transformers 4....


Platforms: Matlab

xlsgraph(xtitle,ytitle,chartype,chart_title,filename,sheetname) xlsgraph : creates an Excel graph by searching specified sheet for selected columns headers.xtitle: title(s) of column to be x-axis (picked from titles).ytitle: title(s) of column to be y-axis (picked from titles).chartype: integer...


Platforms: Matlab

Slow and dirty way to save a simple structure to an Excel file with xlswrite. I did it to solve a urgent problem for a friend. Lots of improvements possible, I'm sure.STRUC2XLS (FILE,S) writes the contents of structure S to a excel file named FILE. The name of the worksheet and the starting row...


Platforms: Matlab

[S,E] = XLS2STRUCT(FILE) reads the Excel-file FILE and converts the columns into separate fields in the structure S. The first line of the file must contain unique headers for all of the columns, the rest of the file is data. Column names can contain spaces, these are converted to underscores in...


Platforms: Matlab

ANALYSEEXCELFORMULAS Extracts formulas from an Excel workbook and lists them in several different ways to aid analysis. AnalyseExcelFormulas collects all the formulas and values from all the worksheets in an Excel file. It then creates a new Excel file with 2N+1 sheets in it (where N is the...


Platforms: Matlab

The flat file can be a text file in CSV, delimited, or fixed length format. It can also be an Excel file.You supply a XML file describing the fields in the file and thier mapping to the database table columns. Ycvou can also add validations that the input data must pass before it is inserted to...


Platforms: Java

SPREADSHEET2STRUCTURE Reads in a spreadsheet and converts it into a structure whos field names are taken from the column headers in the spreadsheet. USAGE: 1. Read in the file with XLSREAD 2. Pass the text component to SPREADSHEET2STRUCTURE along with the first column header 3....


Platforms: Matlab

When you have tables in a PDF document and you want to transfer them to Excel worksheet to calculate and analyze the data, Free PDF to Excel XLS provides the solution. It can convert PDF to Excel and recreate the forms to make it editable. The best part is, it works 100% free without any form of...


Platforms: Windows, Windows 8, Windows 7

xlutils is a Python module that provides a collection of utilities for working with Excel files. Since these utilities may require either or both of the xlrd and xlwt packages, they are collected together seperately here. Currently available are: xlutils.display Utility functions for...


Platforms: *nix