Categories

## Inductance Calculator (Air cored, Single Layer)

This calculator can be used to find the Inductance of a multiturn single layer circular coil. This is based on a compact six-figure approximation formula for the inductance of a cylindrical current sheet from the book: “A Handbook Formula for the Inductance of a Single-Layer Circular Coil” by Richard Lindin. Reference to the book can […]

Categories

## Random Protein Sequence Generator

[randomproteinsequence]

Categories

## Random DNA Sequence Generator

Specify Size of DNA, Base frequencies and click generate to get a random DNA sequence in FASTA format [randomdnasequence] Features Generates random DNA sequence up to a length of 9999 nucleotide bases Generates output in FASTA format Please send feature request/bug report at my email address specified in the sidebar. if you find this tool […]

Categories

## Mean & Standard Deviation Calculator for Frequency Table & Grouped Data

[sdfrequencytable] Formula for Sample Data Formula for Population Data

Categories

## Line of Best Fit Calculator + Trend Line Graphing Tool

Enter one data set in the format x,y per line: For example: 4,5 5,6 8,7 3,4 5,11 11,13 14,11 Intercept(a): Slope(b): Line of Best Fit :(y=a+bx) About Linear Regression and Trend Line Formulating a equation for the line of best fit for two sets of variables allows us describe a relationship between the two variables expressed in the form of a […]

Categories

## Truth Table Generator for Arbitary Boolean Expressions

[truthtable] Use the following symbols: AND * OR + NOT – NOR # NAND \$ XOR ^ IMPLIES => or <= BICONDITIONAL(iff) <=> You can assign complex statement to a variable with “:” operator. For example: t:x*(x+y) q:y+(x*y) and you can even perform operations on each of the new variables that you created. For example: […]

Categories

## ‘Numbers to Words’ Batch Converter (Indian Numbering System)

To convert numbers to equivalent Indian number system (Lakh, Crore Counting system) use the following converter. [indiannumtowords] Important Features: Now forget adding those ugly looking code into your excel sheet, never understanding what it does under the hood.The following converter can be used to convert unlimited number of numbers to words. Features include: 1) Can […]

Categories

## ‘Numbers to Words’ Batch Converter (Num to Text)

Recently I needed to convert a series of currency numbers to words equivalent. Strangely Microsoft Excel does not have any in-built corresponding function to handle this. I wrote this code to get this done with support up to quintillion values. Now that should be sufficient for most of the cases. Truth be told, I could […]

Categories

## Macaulay Duration Calculator for Bond Instrument

Bond’s Face Value Coupon rate% Bond Purchase Price Maturity Value Term to maturity (yrs.) Yield to Maturity (YTM) (%) 1 Time Weighted Present Value of Coupon payments (A) 0.14463711368462775 Present Value of Maturity Amount (B) 5.374721077731093 Duration(A+B)(in yrs.) 5.51935819141572 Meaning that the price of the bond will decrease 5.52 % for a corresponding 1% increase […]

Categories

## Online Calculator: Find Value of a Bond or Debt Instrument

Face Value: Maturity Date:(MM/DD/YYYY) Amount Redeemable at Maturity: Annual Coupon Rate: % Number of Coupon Payments per Year: Required rate of return:% A. Present Value of \$1000 Maturity Value is \$ 563.59 B. Present Value of 13 Coupons @ 35 is \$ 339.43 C. Present Value of Bond (A + B) : \$903.02 To use […]