Spreadsheet Calculation

Calculation of orbital elements from position end velocity of satellite according to Keplerian lows.Calculation of six Keplerian elements wich represent orbit. Platforms: Matlab

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 Platforms: Matlab

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

There is a base class that provides abstract range calculation based on the number of page and number of result rows per page to retrieve.The iterator interface is also implemented to traverse query result rows.Limit Result Set Iterator also comes with an implementation class to execute and... Platforms: PHP

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

The Bond Yield Calculator for Excel or Open Office Calc enables the automatic generation of scheduled bond payments and the calculation of resulting yield to maturity. The bond yield to maturity calculator is designed to handle odd first time periods and is ideal to analyze bond payment schedules... Platforms: Windows, Mac, Windows 8, Windows 7, Windows Server

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