ActPresentation.com HOME FAQ forum info@ActPresentation.com
Addons for ACT! by Sage :
Abacus Calculated Fields for ACT!
make calculations involving ACT! fields
  • Create calculations involving ACT! fields
  • Assign calculation formula to field (make a field "calculated")
  • Calculate Total
  • Run your calculations either automatically or manually
  • Over 80 supported functions (mathematical, string, datetime, financial)
  • Mortgage/loan calculation
  • Use "IF" and "CASE" conditional statements to build calculation scenarios
  • Automatic data entry (fill fields automatically)
  • Calculate Interest Rates
  • Accounting software functions
  • Mass replace field values
Dynamic Field Color for ACT! by Sage
highlight fields depending on field values
  • Calculate and change field colors "ON THE FLY"
  • Conditional color calculations using "IF" and "CASE" statements
  • Perform data entry validation
  • Highlight incorrecly entered fields
  • Highlight fields depending on field values
New Contact List for ACT! by Sage
say "good bye" to look-ups!
  • Contact list is EMBEDDED in Detail View
  • List can be docked or floating
  • Built-in search by any field
  • Built-in FILTER bar - build quick LOOKUPS!
  • "Two monitors view" in floating mode
PicturePlus for ACT! by Sage
advanced features for picture fields + Scanner & Camera support
  • Links picture fields to Image files
  • Links to PDF, Video and Audio files
  • Scan directly to picture fields!
  • Load images from digital cameras
  • Full size image view
  • Open pictures in your favourite image viewer
  • Clipboard support (copy/paste images)
  • Drag'n'drop image files to/form ACT!
Employment History for ACT! by Sage
track who works for whom records
  • Associate chronological employment history with contacts
  • Enter work period ( start date, end date ) for every company associated with contact
  • Usefull for recruitment agencies
Quick Search for ACT! by Sage
find contacts quickly and easily!
  • Quick search tool for contacts, companies, groups and opportunities
  • Search by several fields simultaneously
Presentation for ACT! by Sage
run slide show based on ACT! report
  • Run slide show based on ACT! report
  • Convert report to MS Powerpoint Presentation

Our add-ons are compatible with:

ACT! 2005 (v7)
ACT! 2006 (v8)
ACT! 2007 (v9)
ACT! 2008 (v10)
ACT! 2009 (v11)
ACT! 2010 (v12)
ACT! 2011 (v13)
ACT! 2012 (v14)
Sage ACT! 2013 (v15)
Swiftpage ACT! 2014 (v16)
Swiftpage ACT! 2015 (v17)
Swiftpage ACT! 2016 (v18)
Swiftpage ACT! 2017 (v19)
Swiftpage ACT! 2018 (v20)
Swiftpage ACT! 2019 (v21)

forum
Abacus Calculated Fields for ACT!
On-line help - Financial functions

DDB( cost, salvage, life, period [, factor] )
Returns the depreciation of an asset for a specific time period using the double-declining balance method or some other method you specify

Examples:

DDB( 2400, 300, 10*365, 1, default ) --> 1.31
DDB( 2400, 300, 10*12,1,2) --> 40



FV(rate;nper;pmt;pv;type)
Returns the future value of an annuity based on periodic, fixed payments and a fixed interest rate.
The rate and nper must be calculated using payment periods expressed in the same units. For example, if rate is calculated using months, nper must also be calculated using months.
For all arguments, cash paid out (such as deposits to savings) is represented by negative numbers; cash received (such as dividend checks) is represented by positive numbers.

rate: interest rate per period. For example, if you get a car loan at an annual percentage rate (APR) of 10 percent and make monthly payments, the rate per period is 0.1/12, or 0.0083.

nper: total number of payment periods in the annuity. For example, if you make monthly payments on a four-year car loan, your loan has a total of 4 * 12 (or 48) payment periods.

pmt: payment to be made each period. Payments usually contain principal and interest that doesn't change over the life of the annuity.

pv: (optional) present value (or lump sum) of a series of future payments. For example, when you borrow money to buy a car, the loan amount is the present value to the lender of the monthly car payments you will make. If omitted, 0 is assumed.

type: (optional) when payments are due. Use 0 if payments are due at the end of the payment period, or use 1 if payments are due at the beginning of the period. If omitted, 0 is assumed.

Examples:

Fv(0.005,12,-100,0,1) --> $1239.72
Fv(0.005,24,-100,0,1) --> $2555.91
Fv(0.005,36,-100,0,1) --> $3953.28
Fv(0.005 , 12, 50, -1000, default ) --> $444.90
Fv(0.01, 15*12, -550, 50000, default) --> -$25,020.99



IPmt(rate, per, nper, pv, fv, type)
Returns the interest payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate.
The rate and nper arguments must be calculated using payment periods expressed in the same units. For example, if rate is calculated using months, nper must also be calculated using months.
For all arguments, cash paid out (such as deposits to savings) is represented by negative numbers; cash received (such as dividend checks) is represented by positive numbers.

rate: interest rate per period. For example, if you get a car loan at an annual percentage rate (APR) of 10 percent and make monthly payments, the rate per period is 0.1/12, or 0.0083.

per: payment period in the range 1 through nper.

nper: total number of payment periods in the annuity. For example, if you make monthly payments on a four-year car loan, your loan has a total of 4 * 12 (or 48) payment periods.

pv: present value, or value today, of a series of future payments or receipts. For example, when you borrow money to buy a car, the loan amount is the present value to the lender of the monthly car payments you will make.

fv: (optional) future value or cash balance you want after you've made the final payment. For example, the future value of a loan is $0 because that's its value after the final payment. However, if you want to save $50,000 over 18 years for your child's education, then $50,000 is the future value. If omitted, 0 is assumed.

type: (optional) when payments are due. Use 0 if payments are due at the end of the payment period, or use 1 if payments are due at the beginning of the period. If omitted, 0 is assumed.

Examples:

IPmt(0.08/12, 24, 12*30, 100000,default,default) --> -$655.59


NPer(rate, pmt, pv, fv, type)
Returns the number of periods for an annuity based on periodic, fixed payments and a fixed interest rate.
For all arguments, cash paid out (such as deposits to savings) is represented by negative numbers; cash received (such as dividend checks) is represented by positive numbers.

rate: interest rate per period. For example, if you get a car loan at an annual percentage rate (APR) of 10 percent and make monthly payments, the rate per period is 0.1/12, or 0.0083.

pmt: payment to be made each period. Payments usually contain principal and interest that doesn't change over the life of the annuity.

pv: present value, or value today, of a series of future payments or receipts. For example, when you borrow money to buy a car, the loan amount is the present value to the lender of the monthly car payments you will make.

fv: (optional) future value or cash balance you want after you've made the final payment. For example, the future value of a loan is $0 because that's its value after the final payment. However, if you want to save $50,000 over 18 years for your child's education, then $50,000 is the future value. If omitted, 0 is assumed.

type: (optional) when payments are due. Use 0 if payments are due at the end of the payment period, or use 1 if payments are due at the beginning of the period. If omitted, 0 is assumed.

Examples:

NPer(0.08,1000,-10000,default,default) --> 20.91 (years)


Pmt(rate, nper, pv, fv, type)
Returns the payment for an annuity based on periodic, fixed payments and a fixed interest rate.
The rate and nper arguments must be calculated using payment periods expressed in the same units. For example, if rate is calculated using months, nper must also be calculated using months.
For all arguments, cash paid out (such as deposits to savings) is represented by negative numbers; cash received (such as dividend checks) is represented by positive numbers.

rate: interest rate per period. For example, if you get a car loan at an annual percentage rate (APR) of 10 percent and make monthly payments, the rate per period is 0.1/12, or 0.0083.

nper: total number of payment periods in the annuity. For example, if you make monthly payments on a four-year car loan, your loan has a total of 4 * 12 (or 48) payment periods.

pv: present value, or value today, of a series of future payments or receipts. For example, when you borrow money to buy a car, the loan amount is the present value to the lender of the monthly car payments you will make.

fv: (optional) future value or cash balance you want after you've made the final payment. For example, the future value of a loan is $0 because that's its value after the final payment. However, if you want to save $50,000 over 18 years for your child's education, then $50,000 is the future value. If omitted, 0 is assumed.

type: (optional) when payments are due. Use 0 if payments are due at the end of the payment period, or use 1 if payments are due at the beginning of the period. If omitted, 0 is assumed.

Examples:

Pmt( 0.08/12, 30*12, 100000, default, default ) --> -$733.76
Pmt(0.07,30,100000, default, default) -- Pmt(7%,30,100K) = -8058,640351



PPmt( rate, per, nper, pv [, fv [, type]] )
Returns the principal payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate.

Examples:

PPmt(0.08/12, 24, 12*30, 100000, default, default) --> -$78.18


PV(rate, nper, pmt, fv, type)
Returns the present value of an annuity based on periodic, fixed payments to be paid in the future and a fixed interest rate.
The rate and nper arguments must be calculated using payment periods expressed in the same units. For example, if rate is calculated using months, nper must also be calculated using months.
For all arguments, cash paid out (such as deposits to savings) is represented by negative numbers; cash received (such as dividend checks) is represented by positive numbers.

rate: interest rate per period. For example, if you get a car loan at an annual percentage rate (APR) of 10 percent and make monthly payments, the rate per period is 0.1/12, or 0.0083.

nper: total number of payment periods in the annuity. For example, if you make monthly payments on a four-year car loan, your loan has a total of 4 * 12 (or 48) payment periods.

pmt: payment to be made each period. Payments usually contain principal and interest that doesn't change over the life of the annuity.

fv: (optional) future value or cash balance you want after you've made the final payment.
For example, the future value of a loan is $0 because that's its value after the final payment. However, if you want to save $50,000 over 18 years for your child's education, then $50,000 is the future value. If omitted, 0 is assumed.

type: (optional) when payments are due. Use 0 if payments are due at the end of the payment period, or use 1 if payments are due at the beginning of the period. If omitted, 0 is assumed.

Examples:

Pv(0.06/12, 10*12, 100, default, default) --> -$9007.35


Rate(nper, pmt, pv, fv, type, guess)
Returns the interest rate per period for an annuity.
For all arguments, cash paid out (such as deposits to savings) is represented by negative numbers; cash received (such as dividend checks) is represented by positive numbers. Rate is calculated by iteration. Starting with the value of guess, Rate cycles through the calculation until the result is accurate to within 0.00001 percent. If Rate can't find a result after 20 tries, it fails. If your guess is 10 percent and Rate fails, try a different value for guess.

nper: total number of payment periods in the annuity. For example, if you make monthly payments on a four-year car loan, your loan has a total of 4 * 12 (or 48) payment periods.

pmt: payment to be made each period. Payments usually contain principal and interest that doesn't change over the life of the annuity.

pv: present value, or value today, of a series of future payments or receipts. For example, when you borrow money to buy a car, the loan amount is the present value to the lender of the monthly car payments you will make. fv: (optional) future value or cash balance you want after you've made the final payment.
For example, the future value of a loan is $0 because that's its value after the final payment. However, if you want to save $50,000 over 18 years for your child's education, then $50,000 is the future value. If omitted, 0 is assumed.

type: (optional) when payments are due. Use 0 if payments are due at the end of the payment period, or use 1 if payments are due at the beginning of the period. If omitted, 0 is assumed.

guess: value you estimate will be returned by Rate. If omitted, guess is 0.1 (10 percent).

Examples:

RATE( 4*12, -200, 8000, default, default, default) -- 0,007701472 = 1%
RATE( 1, -10, 1, default, default, default) -- 9 = 900%
RATE( 1,-200,12,10,0,0.5 ) -- = 14,83333333 = 1483%
RATE( 1,-200,12,10,1,0.5 ) -- = -0,946808511 = -95%
RATE( 1,-100,78,-1,0, default ) -- = 0,294871795 = 29%
rate(10*1, -1000, 65000, default, default, default) -- = -0,246951723 = -25%


Rate(
       30,
       Pmt(0.07,30,100000,default,default),
       100000-3500,default,default,default) -- = 0,073586747 = 7.36%



SLN( cost, salvage, life )
Returns the straight-line depreciation of an asset for a single period.

Examples:

SLN(30000,7500,10) -- = 2250


SYD( cost, salvage, life, period )
Returns the sum-of-years' digits depreciation of an asset for a specified period.

Examples:

SYD(30000,7500,10,1) -- = 4,090.91
SYD(30000,7500,10,10) -- = 409.09
 Information:
How to install addon
How to uninstall addon
Getting started
 On-line help:
User reference
Statements
Operators
Functions
Financial functions
 Tutorials:
Flash demo 1
Flash demo 2
Flash demo 3
Flash demo 4
Examples of calculations
Download free trial
BUY NOW
 Compatible with:
ACT! 7 / 2005
ACT! 8 / 2006
ACT! 9 / 2007
ACT! 10 / 2008
ACT! 11 / 2009
ACT! 12 / 2010
ACT! 13 / 2011
ACT! 14 / 2012
ACT! 15 / 2013
Swiftpage ACT! 16 / 2014
Swiftpage ACT! 17 / 2015
Swiftpage ACT! 18 / 2016
Swiftpage ACT! 19 / 2017
Swiftpage ACT! 20 / 2018
Swiftpage ACT! 21 / 2019
 Screenshots:
Click on these sample screenshots
to see larger views.

ACT! software addons - best plugins for ACT contact management software ( Act! by Sage software : ACT!2005, ACT!2006, ACT!2007, ACT!2008, ACT!2009, Act by Sage Premium for Workgroups ).
Custom addon solutions ( ACT! add ons ) development and CRM (Customer Relationship Management) software training and consulting.