SigFig

SigFig 1.0

SigFig 1.0 Image
Screenshot
Category: Business / Calculators & Converters
Publisher / Version: SigFig / 1.0
Added / Released: 10 Jun 2009 / 09 Jun 2009
License / Cost: Demo / 0.00$
File Size / Downloads: 976.6 KB / 56
Operating Systems: Windows XP, NT, Me, 98, 2003, 2000
SigFig is an Excel add-in.

At the heart of SigFig is an algorithm that determines the exact digital (base 10) representation of any double precision (8 byte) number. Endowed with this capability, SigFig has been configured to do a variety of things:

(1) It displays numbers in engineering format, with powers of 10 as multiples of 3.

(2) It gives various digit grouping options. For example, 1.234567 can be depicted as 1. 234 567.

(3) It can round numbers off to between 3 and 17 significant figures. Note that 17 significant figures is required to uniquely identify a specific double precision value.

(4) It promotes, but does not require, the practice of entering numbers as character strings (with an essentially unlimited number of significant figures); replacing Excel number entries which are limited to 15 significant figures).

(5) It promotes, but does not require, the practice of calculations being done in such a way that double precision is maintained in a chain of calculations. Excel arithmetics can lose precision in a variety of contexts, whereas Visual Basic arithmetics in the form of Excel user functions are much more reliable. Therefore, SigFig is shipped with a variety of arithmetic user functions that can be called out in your spreadsheet that operate on either (a) numbers or (b) numbers entered as character strings, and return numbers coded as character strings. Primary among these functions is RPN(), which is a reverse polish notation calculator, which implements the vast majority of functions you are likely to find on a scientific calculator.

Requirements: User must have Excel 2002 or 2003

Download | Order | Broken Link Report | More Info

Support Languages: English
Install Support: Install Only

Your Rating: 0 Star0 Star0 Star0 Star0 Star Our Rating: 0 Star0 Star0 Star0 Star0 Star
Rate It:
Keywords:
Engineering Format, Excel Add-In, Excel Visual Basic, Help With Visual Basic, Significant Figures, Vba, Visual Basic, Visual Basic 3, Visual Basic 3.0, Visual Basic 4, Visual Basic 5, Visual Basic Excel, Visual Basic For Excel, Visual Basic Help, Visual Basic Sql

SigFig Comments

Join to SigFig discussion at FileGets! Let's see what our visitors think about it and write your own opinion! Rate this software to support developers or to make them work better! Also please write here if you want to see any additional features in this software.

Your Rating *
Your Name *
Email *
Comment Text *
Notice:  * - required fields