## Examples Explained

## Popular

- Typical calculation of expenses in a bar

12.30+2.7+3*4.25+10*1.06+31.09 - A product costs 193.31. How much are you going to pay after a 6.2% discount?

193.31*(100-6.2)% - Conversion from 25° Celsius to Fahrenheit and Kelvin.

conv(25,C,F)

conv(25,C,K) - Circle area of 5.7 radius

PI*pow(5.7,2) - Knowing that an angle sine is 1/2, what is the angle in radians and degrees?

asin(1/2)

deg(asin(1/2)) - Square root of 144 and cubic root of 4913

sqrt(144,2)

pow(4913,1/3) - Number of days since D-Day in June 6, 1944 and the corresponding weekday (date format M,D,Y)

days(6,6,1944)

weekday(6,6,1944) - Bruna was born at 10/25/2006. What is the approximated conception date (date format M,D,Y)?

(Consider a normal pregnancy period 40 weeks long)

dateprojection(-40*7, 10,25,2006) - The number of five-card hands possible from a standard fifty-two card deck is:

combination(52,5) - Conversion from hexadecimal (base 16) to decimal (base 10)

0xF40C - The Sun mass is 1.9891e+30 kg, having 73.46% of Hydrogen, which 1 kg has 6.02e+26 atoms. How many Hydrogen atoms exist in the Sun? (The numbers are in scientific notation)

1.9891e+30 * 73.46% * 6.02e+26

## Finance

The financial functions PV, FV, PMT, RATE e NPER work the same as in Excel.

- A TV price rises from 910 to 1230. What is the percentage raise?

100*(1230-910)/910 - Future Value of monthly deposits of $200 during 24 months at 2% interest rate per month

fv(2%,24,-200) - Future Value of a single deposit of $2000 after 20 months at 0.9% per month

fv(0.9%,20,0,-2000)

Alternatively:

2000*pow(1+0.9%,20) - Present Value of 20 installments of $110 at 1.5% monthly interest rate

pv(1.5%,20,-110) - Present Value of $1000 for 12 months forward at 1.5% monthly interest rate

pv(1.5%,12,0,-1000) - Monthly payment of a car mortgage of $20200 at 20% per year (nominal interest rate), during 24 months

pmt(20%/12, 24, -20200) - Annual nominal interest rate of a mortgage of $30000 at 60x of $863 monthly payments

100*12*rate(60,863,-30000) - Number of payments of a mortgage of $30000 at 2% monthly and $863 per month

nper(2%,863,-30000) - How many months we need to let $4000 invested at 1.5% monthly, in order to reach $8000?

nper(1.5%,0,-4000,8000) - Conversion from 1.53% monthly to the effective annual interest rate

100*(pow(1+1.53%, 12) - 1) - Conversion from effective annual interest rate of 20% to monthly equivalent

100*(pow(1+20%, 1/12) - 1)

## Conversions

- Conversion from 85 miles/hour to km/h

conv(85,mile/hour,km/h) - Conversion from 30 yards to meters

conv(30,yard,m) - Conversion from 60 centimeters to inches

conv(60,cm,inch) - In the car manual is stated that the tire must be calibrated at 2.1 bar. What is the psi equivalent?

conv(2.1,bar,psi) - In the chocolate pack is written 7.3oz. How many grams it weights?

conv(7.3,oz,g) - The distance from our solar system to the closest star is 4.22 light years. What is the miles equivalent?

conv(4.22,ly,mile) - A space shuttle achieves 18500 mile/h. How long would it take to reach the closest star (in days)?

(conv(4.22,ly,mile)/18500)/24 - Convertion of the number 61500 to bases hexadecimal, octal and binary

hex(61500)

oct(61500)

bin(61500)

See below the complete unit Conversions reference supported by the *conv* function.

## Others

- The remainder of 153 divided by 21 (also known as "modulo of 153 by 21")

153 mod 21 - Number of days between two dates

days(05,10,2006, 12,31,2008) - Sine of 30°

sin(radianos(30)) - Number of anagrams that could be made from the word "brasil"

permutation(6,6) - Calculating the average and standard deviation, given the following heights of a basketball team: 1.89,1.93,2.02,1.95,1.87,2.05,2.12

mean(1.89,1.93,2.02,1.95,1.87,2.05,2.12)

stdev(1.89,1.93,2.02,1.95,1.87,2.05,2.12) - The maximum common divisor of numbers 24, 36 e 48

mcd(24,36,48) - The least common multiple (or lower common multiple) of numbers 8, 9 e 21

lcm(8,9,21) - How many bits are needed to store a number with a limit of 6 digits?

(We just need to calculate the base 2 logarithm of 999999 and round it up)

ceil(log(999999,2)) - Random number between 0 and 100

round(random()*100)

“Because a good example worth more than a thousand words in a boring manual.”