Formula Sheet
R
R
(1) Integration By Parts: u(x)v 0 (x)dx = u(x)v(x) u0 (x)v(x)dx.
(2) Partial Fractions Integral: If c 6= d then
Z
ax + b
1
dx =
(ac + b) ln x c (ad + b) ln x d + K.
(x c)(x d)
cd
(3) For linear homogeneous d.e. with constant coeffici
Implementing Custom Events
In the early versions of VB, programmers were limited to working with the builtin events. In VB5,
however, three simple keywordsEvent, RaiseEvent, and WithEventswere added to the language to
allow the programmer to define cus
VBA Lesson 21: VBA Code General Tips
 All VBA procedures (macros) start with Sub with a set of parentheses at the end
Sub proTest()
In the parentheses you will submit variables that you carry from one procedure to the other. I always
use the prefix "pro
VBA Lesson 11: The Visual Basic Editor in Excel (VBE)
When you want somebody to do some work for you you open your Email program and you send him a
message in a language that he understands (English, Spanish, French.). When you want Excel to do
some work
Hide All
Worksheet functions listed by category
Database
Microsoft Excel includes worksheet functions that analyze data stored in lists or
databases. Each of these functions, referred to collectively as the Dfunctions, uses three
arguments: database, fiel
VBA Lesson 31: Forms (Userforms) in VBA for Excel
The form or userForm is also known as a GUI (Graphical User Interface). The form is used to require
values, parameters and information from the user to feed the VBA procedure. Different basic controls
can
VBA Lesson 41: Additional References / Addins
Introduction
There may be times, especially when copying a workbook from one machine to another, that the
references for that VBA project are not properly carried through to the new machine. This normally
ha
Help and Tips on Excel Macros

Programming in VBA for Excel
o Vocabulary from the Programmers' Language in Excel
o The Visual Basic Editor in Excel (VBE)
The most user friendly programming environment. You will create your procedures (macros) and
userfor
Vocabulary from the Programmers' Language in Excel
In the universe of VBA for Excel (Macros) there is some vocabulary that you might want to adopt so that others
can understand you and so that you can understand the others.
As a start let's correct a gene
EXCERPTS FROM S. BROVERMAN STUDY GUIDE
FOR SOA EXAM FM/CAS EXAM 2
2009
Table of Contents
Introductory Comments
Section 12  Bond Amortization, Callable Bonds
Section 18  Option Strategies (1)
Problem Set 7  Annuities Whose Payments Follow a Geometric Pr
SOA Course FM / CAS Exam 2
Calculator advice
Course FM / Exam 2
Calculator advice
Introduction
It wasnt very long ago that the square root key was the most advanced function of the
only calculator approved by the SOA/CAS for use during an actuarial exam.
MATHEMATICS OF
INVESTMENT
AND
CREDIT
Fourth Edition
Samuel A. Broverman, ASA, Ph.D.
University of Toronto
ACTEX Publications, Inc.
Winsted, Connecticut
CHAPTER 1
INTEREST RATE MEASUREMENT
1.1
1.2
1.3
1.4
1.5
1.6
1.7
1.8
1.9
1.8
1
Interest Accumulation and
Tutorial on Excel
Table of Contents
Introduction
Nothing has really changed in Excel since 1997 except for some cosmetic transformations and WEB related functionalities
that are weak at best. What has changed radically is the computer on your desk. Since