Spreadsheet

NUM2ABC(X), where X is an integer, returns a string corresponding to the column label commonly employed by spreadsheet programs, such as MicrosoftExcel. Example: x = 45; num2abc(x); ans = AS

ABC2NUM(S), where S is a one or two letter string representing a column label commonly employed by spreadsheet programs, returns a number corresponding to the spreadsheet column indicated by S. Example: S = 'CS'; abc2num(S); ans = 97

Reads all rough data from Excel spreadsheet file in a data structureUses xlsread to read each 'Sheet' in the 'Workbook' separately.All numeric data and text data is saved in separate fields.M-file is quickly prototyped. It is documented for others to improve the code.


Platforms: Matlab

Sheetnode integrates the javascript spreadsheet engine SocialCalc as a new node type in Drupal. SocialCalc was written by Dan Bricklin, co-author of the original VisiCalc spreadsheet app in 1979, and is used in the OLPC XO laptop and the SocialText Collaboration Platform.Need a new feature for...


Platforms: PHP

This script creates a binary spreadsheet to indicate if there exists a rare variant in the window centered about the current marker. At chromosome edges, the maximum number of markers up to the window size is used without running into the next chromosome.


Platforms: Mac

This script activates only the columns in a spreadsheet from which the script is run whose column labels are in another spreadsheet specified by the user. Any inactive columns in the other spreadsheet are not used in activating columns in the current spreadsheet. Non-unique columns in the current...


Platforms: Mac

From a spreadsheet containing numeric data, this script saves the spreadsheet in the CNT file format. All non-numeric data columns should be inactivated before running the script.


Platforms: Mac

From a spreadsheet containing numeric data, this script saves the spreadsheet in the CNT file format. All non-numeric data columns should be inactivated before running the script.


Platforms: Mac

For a spreadsheet with real valued data, this script calculates the mean, variance and standard deviation of each row, creating a new spreadsheet with the respective row statistics.


Platforms: Mac

This script activates only the columns in a spreadsheet from which the script is run whose column labels are in another spreadsheet specified by the user. Any inactive columns in the other spreadsheet are not used in activating columns in the current spreadsheet. Non-unique columns in the current...


Platforms: Mac

This script takes genotypes from two different arrays and creates a consensus spreadsheet, and two optional spreadsheets. In order to run this script two spreadsheets of mapped genotype data are required. The spreadsheets may also contain non-marker mapped columns as they will be skipped when...


Platforms: Mac

This script inactivates only the rows in a spreadsheet from which the script is run whose row labels are in another spreadsheet specified by the user. Any inactive rows in the other spreadsheet are not used in inactivating rows in the current spreadsheet. Non-unique rows in the current...


Platforms: Mac

This script inactivates only the columns in a spreadsheet from which the script is run whose column labels are in another spreadsheet specified by the user. Any inactive columns in the other spreadsheet are not used in inactivating columns in the current spreadsheet. Non-unique columns in the...


Platforms: Mac

Bean Sheet is an interpreted Java spreadsheet. At its core is Bean Shell, an open source Java interpreter. The potential of marrying a Java interpreter with a spreadsheet allows a single document to be a powerful application in its own right.


Platforms: *nix

Pyspread is a cross-platform Python spreadsheet software based on and written in the Python programming language. Instead of spreadsheet formulas, Python expressions are entered into the spreadsheet cells. Each expression returns a Python object that can be accessed from other cells. These...


Platforms: *nix

xlwt is a Python library for generating spreadsheet files that are compatible with Excel 97/2000/XP/2003, OpenOffice.org Calc, and Gnumeric. xlwt has full support for Unicode. Excel spreadsheets can be generated on any platform without needing Excel or a COM server. xlwt is a fork of...


Platforms: *nix

Gnumeric is a powerful and easy to use spreadsheet using GNOME. Its goal is to provide a full featured spreadsheet and a smooth migration path for people and organizations currently using proprietary applications. Gnumeric provides more sheet functions and greatly improved accuracy when compared...


Platforms: *nix

What is BulkPDF? BulkPDF is a free and easy to use freeware software (Open Source), which allows to automatically fill an existing PDF form with different values. Only a spreadsheet (Microsoft Excel 2007/2010/2013, LibreOffice or OpenOffice Calc) with the desired values is required. How does...


Platforms: Windows, Mac, *nix, Windows 7

Gridraw is a new feeling UML drawing tool based on the cell system. Gridraw uses to draw UML diagrams by incorporating features of spreadsheets, drawing tools, and a text editor. Diagrams are editable in a similar way to spreadsheet programs. No more difficulties trying to select a...


Platforms: *nix, Windows 8, Windows 7, Windows

SSuite Axcel is a professional, very useful, and practical spreadsheet application for everyday use at home or the office, and it's also absolutely and completely free! This powerful spreadsheet application has all the tools you need to calculate, analyse, summarise, and present your data in...


Platforms: Windows, Windows 8, Windows 7, Windows Server