Excel Social Security and Annuity Functions

[JButtrick]

I have a suite of Excel "Actuarial" functions that include calculators for annuity rates and social security benefits that were developed by a co-worker many years and many versions of Excel and Windows ago.

I am finding that the annuity calcuator now occasionally encounter errors when run in Excel 2002 on some Windows XP installations (but not others).

I have been dutifully updating the COLA, wagebase, covered comp and old wage base tables each year, but with this year, whether due to limitations on the size of the array or the Excel/Windows installation, the Social Security function is returning "#VALUE!" errors

I am interested in either finding a source for obtaining updated replacements OR finding some VB programmer who might be willing to debug/update the current coding in exchange for the source code.

Does anyone have any suggestions?

[masteff]

It's possible that certain workstations do not have the proper Excel add-in loaded. In Excel, go to Tools on the menu and then down to Add-ins. My thought would be "Analysis ToolPak"; next thought would be "Analysis ToolPak - VBA". See if selecting the add-in helps the situation.

[Guest toddez]

I've found the SSN format in excel to be a waste given the multitute of formats you may receive a ssn in.

Text is the way to go. Use the formula =text(A1, "000-00-0000") to convert the ssn to a text format. Then copy and paste as values over your original data to lock it down.