Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 29.985.367 Times

AnalyseExcelFormulas 1.0

  Date Added: September 17, 2013  |  Visits: 229

AnalyseExcelFormulas

Report Broken Link
Printer Friendly Version


Product Homepage
Download (18 downloads)

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 number of worksheets in the orginal workbook). Each odd sheet, 2n-1, lists the cell name, value and formula for sheet n (from the original file) in row order and each sheet, 2n, lists the same information in column order. The last sheet (2N+1) contains all the information on all the other sheets in one large list for easy printing. In addition, a structure is returned by the function. The structure's fields have the same name as the sheet tabs in your workbook and contain one cell array of all the values in the worksheet and another with all the formulas (e.g. A.LIBOR_Sheet.Formula and A.LIBOR_Sheet.Value. Note the example. The file name is "NonGenericSwap.xls" which has a worksheet (the 3rd sheet in the workbook) called "Generic swap cashflows" which has a cell (C12) which has the formula "=(B12-B11)/360" and a numerical value (result) of 0.252778. AnalyseExcelFormulas creates a new spreadsheet that it titles "NonGenericSwap_formulas.xls." In the 5th worksheet (2*3-1), it puts the title "'Generic swap cashflows' by row" in A1 and then creates three columns below it. The first contains the cell addresses in the row order (e.g. A1, A2, A3, ... B1, B2, C2). The second contains the values of the cells as they appear when you open the workbook. The third column contains the formulas). The 6th (2*3) worksheet's A1 would contain the title "'Generic swap cashflows" by col" and it's first column would list the addresses in column order (e.g. A1, B1, C1, ... A2, B2, C2). The last sheet in the new workbbok, number 2N+1, would contain all the data from all the other sheets. Empty cells are not listed. The function would return a structure that would have a Genericswapcashflow.Formula field with a cell array of formulas and a Genericswapcashflow.Value field with a cell array of values. >> A = AnalyseExcelFormulas('c:NonGenericSwap.xls', ... 'c:NonGenericSwap_formulas.xls') A = Key: [1x1 struct] Discountfactorslinear: [1x1 struct] Genericswapcashflows: [1x1 struct] Forward1v5HS: [1x1 struct] Forward1v5NPA: [1x1 struct] Forward1v5IF: [1x1 struct] Refrateapproach: [1x1 struct] Amortising5yrHS: [1x1 struct] Amortising5yrNPA: [1x1 struct] Amortising5yrIF: [1x1 struct] ComplexswapHS: [1x1 struct] ComplexswapNPA: [1x1 struct] ComplexswapIF: [1x1 struct] Nondiscountingaswap: [1x1 struct] NewMarketData: [1x1 struct] ValuingComplexswapNPA: [1x1 struct] ValuingComplexswapIF: [1x1 struct]>> A.Genericswapcashflowsans = Formula: {17x4 cell} Value: {17x4 cell}It's not fancy, but it works.Michael Robbins, CFA

Requirements: No special requirements
Platforms: Matlab
Keyword: Cashflows Cells Colquot Empty Field Genericswapcashflowformula Genericswapcashflowvalue It039s Listed Quot Generic Quotnongenericswap Formulasxlsquot Return Rowquot Title Workbbok Worksheet
Users rating: 0/10

License: Freeware Size: 10 KB
ANALYSEEXCELFORMULAS RELATED
Networking  -  List More Custom Field Names 1.2.1
Allows for more existing custom field names to be listed in the dropdown selection field when writing a post.By default, WordPress only allows 30 custom field names/keys to be listed in the dropdown selection 'Name' field when writing a post or...
10 KB  
Modules  -  Field Indexer 1.0
Each field enabled for indexing becomes a type of index entry. The users can search keywords with field restriction using the appropriate search module.InstallationUnpack in your modules folder (usually /sites/all/modules/) and enable under...
 
Modules  -  Dynamic Field 6.x-1.0
Dynamic Field is a CCK field that returns a textarea where you can enter custom PHP code. The code is computed real-time and lets you access Drupal objects like $node, $user...Note:This is not a duplicate of ComputedField! ComputedField computes...
10 KB  
Libraries  -  File::Sort 1.01
File::Sort is a Perl module to sort a file or merge sort multiple files. SYNOPSIS use File::Sort qw(sort_file); sort_file({ I => [qw(file_1 file_2)], o => file_new, k => 5.3,5.5rn, -t => | }); sort_file(file1, file1.sorted); This...
32.77 KB  
Modules  -  Spamicide 7.x-1.0-beta3
The purpose of Spamicide is to prevent spam submission to any form on your Drupal web site. Spamicide adds an input field to each form then hides it with css, when spam bots fill in the field the form is discarded. The field, and matching .css...
10 KB  
Games  -  BlockBuster 1.0
The playing field consists of rectangular blocks, activated and non- activated bombs and bonus flags. From time to time one of the bombs activates. Your goal is to move your sapper to a block with the activated bomb before its fuse stops...
457 KB  
Libraries  -  Maypole::FormBuilder 0.44
Maypole::FormBuilder is a Perl module with CGI::FormBuilder support in Maypole. SYNOPSIS use Maypole::Application qw( FormBuilder QuickTable ); BeerFB->config->model( Maypole::FormBuilder::Model ); Maypole provides a great framework for...
37.89 KB  
Form Processors  -  List Chooser 1.1
The user can immediately locate what he has been searching for in the long options list just by typing.With each character the user types in the text field, the available items listed are narrowed down (similar to a help file's inailable ire).
10 KB  
Communication  -  Smartspice binary format RAW file reader 1.0
[data, plot_title] = ssbin2mlab(filename, desired_variable) reads a Binary Smartspice RAW file 'filename' and extract the variable(s) of interest from 'desired_variable' using the file's own variable index format and place the data in column into...
10 KB  
Communication  -  Smartspice binary format RAW file reader with complex capabilities 1.0
this second version support complex data.[data, plot_title] = ssbin2mlab(filename, desired_variable) reads a Binary Smartspice RAW file 'filename' and extract the variable(s) of interest from 'desired_variable' using the file's own variable index...
10 KB  
NEW DOWNLOADS IN SCRIPTS, DEVELOPMENT TOOLS
Scripts  -  Free Ecommerce website creator 1.2
Free Ecommerce website creator is a free PHP shop creating script. This allows you to put a online shop on your own website. Create your own free ecommerce website for Your Business. Create an online shop using easyGUI online shop creator. The...
1.44 KB  
Scripts  -  MochiGames PHP Script ZDR 1.00
MochiGames PHP Script ZDR is web site, ready for use, for flash games. These flash games are downloaded automatically by "MochiGames PHP Script ZDR" from MochiGames media. The use of the games is free, you can use your own Mochi Publisher ID and...
368.54 KB  
Scripts  -  Php Chat 2.0
Add a free php site, single sign-on and multiple skins, 100% free 1. Server Modes: The chat server has paid mode and free mode. If the free chat mode, a free chat room will be assigned to your website with your domain as the room name. 2....
938.87 KB  
Scripts  -  Nibbleblog 3.0.1
Nibbleblog it's a powerful engine for creation and manipulation of BLOG's completely free. Very simple to install and configure (Only 1 step). The database used is based on XML files and this way it is not necessary to use MySQL or similar DBMS....
371.09 KB  
Scripts  -  PHP File Manager | CloudOsys 2.9b8
CloudOsys is a PHP file manager, a tool that allows your visitors upload files such as media content directly to your website. Your visitors will upload files directly to your website, where they can share and comment on them. Through cloud...
1.41 MB  
Development Tools  -  VMP Viewer 1.0
This is a very rudimentary tool to visualize the VMP files generated by BrainVoyager. Useful to share files with people who do not have BV.
10 KB  
Development Tools  -  7-Zip for Script 4.42
7-Zip is a file archiver with a high compression ratio.Features:- High compression ratio in new 7z format with LZMA compression- Supported formats:- Packing / unpacking: 7z, ZIP, GZIP, BZIP2 and TAR- Unpacking only: RAR, CAB, ISO, ARJ, LZH, CHM,...
624.64 KB  
Development Tools  -  PHP Docbook Displayer for Scripts 1.0b
PHP Docbook Displayer provides XSL and CSS stylesheets, and PHP scripts, to generate easily and dynamically websites from Docbook files.It aims at simplifying to the max the web publication process : simply drop the docbook file under the site root !
102.4 KB  
Development Tools  -  WP Translate 1.0
This simple language translation plugin allows your users to quickly translate your webpages, through a widget on your blog.You have the option to select the title of the Widget, which will be displayed above the language translation form. Users...
10 KB  
Development Tools  -  save2word 1.0
A simple function to copy figure from MATLAB into MS Word automatically. It is a modification of saveppt (a function in File exchange) that save figures to MS Powerpoint.
10 KB