Seeing With C - Useful spreadsheets


Copyright: Hardeep Singh, 2007. All rights reserved on all sheets.
No commercial use/distribution/modification permitted.
No warranty, this is free stuff use at your own risk.

Spreadsheets

NPV

net present value calculator.

Linear Statistic relation

to find, with different probabilities, if a set of X values is statistically related to a set of Y values linearly and if so, find the relation.

Cubic Approximation

for finding the three degree curve that fits a set of points.

Biquadratic Approximation

for finding the four degree curve that fits a set of points.

Quintic Approximation

for finding the five degree curve that fits a set of points.

Numeric truth

if you feed a set of values, this sheet can tell you whether or not the values are "cooked". For example entering all the numbers in an income tax return into the sheet can indicate if the return is actual or created just to decieve the authorities. It is based on a law for numbers.

DCC Index

the Digital Camera Capability Index.

Quadratic approximation is not available here because it can be more easily performed using HSB Grapher. It can also create graphs for quadratic approximation, the functions generated out of these higher degree approximation sheets and much more.

You can use OpenOffice to open and view all these sheets. I recommend Open Office Portable, which can be installed on USB drives and can be taken along anywhere - it does not need to be installed to host computers.

To save these spreadsheets, please do NOT right-click to save target. Instead, click on the hyperlink, and the save dialog should open.