{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Example1","Example2","Example3","Example4","Example 5","Example6"],"not_rendered":{"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Example1","index":0,"n_rows":9,"n_cols":5,"rows_kept":9}
["Enter a number:",-2.5]
[]
[null,"Values","Formula"]
["Absolute Value",2.5,{"$f":"ABS(B1)","v":2.5}]
["2 * num + 1",-4,{"$f":"2*B1+1","v":-4}]
["Natural Log","Undefined",{"$f":"LN(B1)","v":{"$error":"#NUM!"}}]
["Exponential",0.0820849986238988,{"$f":"EXP(B1)","v":0.0820849986238988}]
[{"$nulls":4},"This macro will take the number you enter and print out its\nabsolute value, 2 * num + 1, Natural Log, and Exponential of the number.\nIt will print out the value in column B, and it will print out a formula in column C."]
[{"$nulls":4},"Click the box above to run the macro"]

{"sheet":"Example2","index":1,"n_rows":15,"n_cols":7,"rows_kept":15}
["Number of random numbers",10,"(Enter an integer amount)"]
["Lower bound",0.5]
["Upper bound",2.5]
[]
["Random Numbers"]
[1.229990839958191]
[1.4797894954681396]
[0.8113261461257935,{"$nulls":5},"This macro will print out the specified number of random "]
[1.448918342590332,{"$nulls":5},"numbers between the lower bound and upper bound in Column A"]
[1.0145353078842163]
[1.7575037479400635]
[1.584140419960022]
[0.8126044273376465]
[2.377090334892273]
[1.8089988231658936]

{"sheet":"Example3","index":2,"n_rows":11,"n_cols":8,"rows_kept":11}
["Life Table",null,null,"radix"]
["age","px","lx",1000]
[0,0.94,1000]
[1,0.6,940]
[2,0.4,564]
[3,0.33,225.60000000000002]
[4,0,74.44800000000001,{"$nulls":4},"This macro reads the life table and will calculate"]
[{"$nulls":7},"qx based on your values of px and print it out"]
[{"$nulls":7},"horizontally"]
["age",0,1,2,3,4]
["Qx",0.06000000000000005,0.4,0.6,0.6699999999999999,1]

{"sheet":"Example4","index":3,"n_rows":14,"n_cols":6,"rows_kept":14}
["Time:",2,"years"]
["interest rate:",0.03]
[]
["Present Value:",942.5959091337544]
[]
["PV function",{"$f":"Example9(B1,B2)","v":{"v":942.5959091337544,"d":"942.5959"}}]
[]
[]
[]
[]
[{"$nulls":5},"When you click the button, a pop up will ask you for"]
[{"$nulls":5},"time and interest rate.  A message box will then "]
[{"$nulls":5},"pop up and tell you the present value of $1000"]
[{"$nulls":5},"in t years"]

{"sheet":"Example 5","index":4,"n_rows":5,"n_cols":2,"rows_kept":5}
[null,5]
[]
[]
[]
[null,10]

{"sheet":"Example6","index":5,"n_rows":5,"n_cols":2,"rows_kept":5}
[null,4]
[]
[]
[]
[null,12]