PerpetualBudget    

Contact Us
 

January 27, 2007 v4.20 released to the web site. Read about new features here.

November 4, 2006 Drill-down support for PDDs and FTEs worksheets has been added to v4.10. These features allow you to add as much detail to any budget line item you require.

October 15, 2006 Reporting has been supplemented with new drag and drop features. Drag any P & L node object to the Add Worksheets folder to create a new report. Expand the report to a By Org view and you get a report of the parent's child

October 1, 2006 Added support for multi-segmented GL Microsoft Great Plains applications. Import and interpret segmented batch dumps from Great Plains. Configure PerpeptualBudget on-the-fly during the import. Export batch reports. PerpetualBudget serves as the spreadsheet middleware application between Enterprise accounting and consolidation systems.

May 15, 2006 We have updated the web site with a new version of PerpetualBudget (v4) that creates a master budget from multiple company files (QuickBooks - all versions). Drag and drop class objects from multiple files until you are satisfied with the consolidated structure, then create the entire master budget.

March 26, 2006 PerpetualBudget v4.00 released to the web site and also submitted to Intuit's Solutions Marketplace in support of all QuickBooks versions (Pro and higher). Features Auto-Configure for supported accounting programs.

October 29, 2005 More reports! The power of Worksheets On-Demand again proves it's worth with a new consolidated view, By Period, By Org. This worksheet view provides a powerful look at any consolidated operation. The database delivery of aggregated SumOf queries populates the operations P & L easily at a high level. Dynamic field mapping adapts to any changes in the subsidiary operations.

October 7, 2005 Try the new drag and drop support to move budget operations to new parents. Download and evaluate v3.70 PerpetualBudget.

September 8, 2005 Join us at the First Excel User Conference, Fort Worth, Texas, September 16/17th where we will present a new white paper, "Worksheets On-Demand". This paper unveils many of the design concepts of PerpetualBudget and other related products. To get your copy of "Worksheets On-Demand", click here.

September 7, 2005 v3.70 released to the web site. This release is a break-through for PerpetualBudget, featuring unlimited levels and support for asymmetrical organizations. After a prolonged test period for the prior version, 3.70 represents the most solid release in the history of PerpetualBudget. This version has been field tested and proven with a variety of customer sites. Download and evaluate v3.70 PerpetualBudget.

July 7, 2005 

May 24, 2005 A Hide worksheet function for User Workbooks has been added to PerpetualWorkbook, v3.60.

May 23, 2005 We've been doing Spring Cleaning, working on old annoying little problems with the code base and fixing things like making the program exit and load between the Windows application and Excel seamless. Our goal is to have Zero Defects.

May 14, 2005 A final beta version of v3.60 PerpetualBudget is available off the web site. We plan to finalize v3.60 by June 1.

QA bulletin: We have fixed a nagging bug that "snuck" into the code preventing the compacting of the database if you launched PB or PW in Excel. It also was impacting Team network operations.

April 19, 2005 A beta version of v3.60 PerpetualBudget is available off the web site. This version implements variance management both integrated with the organization's P & L and available separately as an Excel report.

January 28, 2005 A beta version of v3.50 PerpetualBudget is available off the web site. The Allocation Engine, Cash Flow and Balance Sheet documents have all been integrated with pbDesigner to produce all documents from customized outlines automatically.

January 15, 2005 An alpha version of the v3.50 release of PerpetualBudget is available off the web site. The features of this release are described here. This release is a merge of detailed templating with summary templates, an advanced allocation engine and the completion of more integrated financial reports.

December 31, 2004 The evaluation licenses in demo products timed out at year's end creating a situation where downloaded products exhibited "Demo Expired" status on installation. We apologize for this and it has been remedied. If this happened to you and you want your demo license extended please contact support (Support@spicer-baer.com) for an on-line extension.

November 30, 2004 PerpetualBudget v3.40 Beta is available off the web site. This is a milestone release of PB featuring pbNOW. The worksheet restore engine has been extended to support creating all required worksheets dynamically on-the-fly, driven by a document-centric method controlled by pbDesigner. The Template Manager, now in it's second generation hosts all the interfaces required to construct an applied GL account strategy across the budgeting organization and then builds all worksheets using the pbNOW featureset. This release is stable and is expected to go final by 12/6/2004.

August 27, 2004 We received a bug report from a new customer outlining an Outlook SendMail failure for user names which include "white-space" in the names. "White-space" is the use of a spacebar character between names. After confirming this bug, we have re-built all products. If you are using a recent version of either product, and your user names contain white space, you should download and overinstall the latest version of your product from the web site.

August 20, 2004 PerpetualBudget v3.30 Beta is available off the web site. This release focuses on the Template Manager features of customizing budget base workbooks. Applications include adapting existing Excel budgets to the PerpetualBudget model, drill-down capabilities for any line item in the P & L structure, creating unique P & L templates on-the-fly from any GL structure and much more.

For the technically inclined, the Template Manager will catalog all Named Ranges and link-dependent formulas, remove such attributes from templates and store the templates as "inert" formatted shells. Named Ranges and formulas are re-applied when templates are selected to join a base budget workbook. This allows the user to create complex budget workbooks without having to manage the PerpetualBudget complexities.

July 5, 2004 PerpetualBudget v3.20 is released to the web site.

March 26, 2004 We have updated our computers to be current with the latest Microsoft updates for Windows, including IE6. IE6 installs some files that affect the MDAC (Microsoft Data Access Components) baseline. We now require MDAC v2.5 or higher to be installed on any machine running PB or PW. The product installer may direct you to download/install it. This is the version that installs with Microsoft Office 2000.

March 13, 2004 The final beta version of PerpetualWorkbook v3.10 has been posted to the web site. The two main features of this release are the seamless Outlook interface to handle remote users and roll back file versioning. It is functionally complete with the exception of rolling versions using the update data from the database. We have a lot of this feature implemented but would like to get feedback on the file versioning feature contained in v3.10 before releasing a data solution. Comments can be sent to support@spicer-baer.com. The expected release date for PW v3.10 is 3/31/2004.

February 28, 2004 Tree handling and link handling bugs have been reported in v3.00. These have been fixed and a bug-fix build (v3.01) is on the web site. Download this package and overinstall v3.00; it installs a fresh evaluation license or preserves your retail license. All data is migrated. Contains new Outlook features.

January 24, 2004 Take our survey on corporate file system methods. It's getting harder and harder to distribute files in the corporate world. What file distribution features do you need?

January 22, 2004 PerpetualBudget v3.00 and PerpetualWorkbook v3.00 are released to the web site and available for purchase.

December 30,2003 Effective today, we are requesting contact information from potential customers requesting PerpetualBudget downloads. This is to improve our evaluation support. Thank you for your cooperation. 

December 22, 2003 PerpetualWorkbook v3.00 Beta is on the web site today.

December 8, 2003 PerpetualBudget v3.00 will release to the web site January 5, 2004. 
    New features include:

• Explorer views of projects, budget structures and system reports. 
• BudgetBuilder is integrated with tree views of the budget structure.
• Goal Setting Mode - This enables you to quickly shape and guide the budget results.
• Allocations controls for InterCompany and IntraCompany expense distribution. 
• Enhanced report generation such as consolidation of multiple profit centers.
• Offset Controls to coordinate Standard Cost expenses with department detail.
• Enhanced database management - run from Windows for analysis and reporting.
• Evaluation Guide - web enabled guide to speed evaluation of sample or new budgets.
• All code has been removed from workbooks. 
• Excel interface customizations have been removed.
• Full creation and maintenance of spreadsheet components.

November 11, 2003 While we are preparing the v3.00 release of PerpetualBudget, we have suspended web sales of PerpetualBudget v2.40. There have been substantial database changes which require a fresh install of PerpetualBudget. The no-charge evaluation download for v3.00 is available and the 30-day evaluation period can be extended until the product is fully released for production sales.

October 23, 2003 v3.00 PerpetualBudget Beta is on the web site. The Help documentation has not been updated yet. We expect to add the documentation by October/end.

September 28, 2003 v2.50 PerpetualBudget Alpha goes on the web site this week. This release is a dramatic shift in the graphical control and presentation of the budget system. The treeview/listview paradigm of the new interface allows a rich flow of data between worksheets and the database. In addition, the increased database interaction with the system allows more levels of data input from Goals Setting at the highest level down to collaborative detailed department input utilizing the update features of PerpetualWorkbook technology. 

August 12, 2003 v2.40 PerpetualBudget Beta is on the web site. The new features are:

• Interface consolidations of the Excel Add-in as well as improvements to PBNavBar.
• Complete integration with the distributed  Group Users sub-system to automate remote updates.
• The ability to make multiple worksheet User Workbooks marks the beginning of a new phase in PerpetualBudget; the User Workbooks now become full-featured remote budget workbooks on their own.

August 1, 2003 v2.40 PerpetualWorkbook Beta is on the web site. The new features are:

• User Workbooks now support multiple worksheets, distributed from the master workbook. Update processing across all sheets is automatic.
• Creating new User Workbooks is configured with a single drop-down selection. Select a Group User and the new workbook is fully configured.
• New Excel Add-in interface. The many screens of the Add-in have been consolidated into a single Windows application.
• Registered users may download and overinstall this version at no-charge. Your existing data will be migrated and adapted to the interface changes.

June 18, 2003 v2.30 PerpetualBudget Beta is on the web site. The new features are:

• Orders Forecast Sub-system
• Dynamic Templates with data restoration
• Navigation from BudgetBuilder
• Blended Revenue Consolidations
• Database Storage

May 29, 2003 v2.30 PerpetualWorkbook Beta is on the web site. This is a bug-fix release. The integration and test phases of PerpetualBudget uncovered some bugs and data processing improvements that are now reflected in PerpetualWorkbook.

May 14, 2003 v2.20 PerpetualBudget is in production and will release to the web site the week of May 23.

March 28, 2003 v2.10 PerpetualWorkbook is released to the web site.

March 20, 2003 v2.10 PerpetualWorkbook (Beta) now supports the seamless merge of Global Address Lists or Contacts lists from Outlook to configure the PW Users Group.

March 14, 2003 v2.10 PerpetualWorkbook (Beta) is on the web site. This is a maintenance update.(ftp://ftp.spicer-baer.com/PW210SYS.exe). 

March 13, 2003 v2.00 PerpetualBudget (Beta) has been refreshed on the web site. The budgeting functions have been working since January this year. Our current efforts are focused on "Budget Builder", a graphical and textual Interview process to develop new budgets. Today's build marks the first link-up between managing the budget build from the workbook controls or PB's Builder interface. This provides a seamless budget building interface from Excel or Windows.(ftp://ftp.spicer-baer.com/PB200SYS.exe).

February, 2003 v2.00 PerpetualBudget (Beta) is on the web site.

January, 2003 v2.00 PerpetualBudget (Alpha) is on the web site.

August 14, 2002 v1.90 PerpetualWorkbook (Beta) is on the web site. The Synchronization feature has been polished and stress testing applied. This technique is effective for workbooks of any size and complexity. We project the version to go final by September 15, the same day we plan to upload PerpetualBudget v2.00 as a beta version.

July 8, 2002 Version 1.90 Beta PerpetualWorkbook is on the web site. This version features Workbook Synchronization for top-down modifications and QA of master workbooks. A complete feature list will be prepared and sent in the monthly newsletter.

June 8, 2002 Version 1.8 PerpetualWorkbook has been upgraded with a new feature, "Rebuild Workbook". This enables you to completely and automatically rebuild data populated workbooks.  This is handy for adding/deleting rows or columns and making formula changes to the worksheet template. This is an important new feature of the upcoming PerpetualBudget products.

April 19, 2002 Version 1.8 PerpetualWorkbook is released to the web site. This officially changes the product line name of PerpetualBudget to PerpetualWorkbook. Read the FAQ in Support to get instructions on switching your product type from PerpetualBudget to PerpetualWorkbook (it's easy!).

March 27, 2002 Version 1.8 of both product lines (PerpetualBudget and PerpetualWorkbook) are available in beta test here. The functionality is generally the same as v1.70 with many bug fixes and system refinements in preparation for the production release of PerpetualWorkbook and the new bundled budgeting products of PerpetualBudget.

March 16, 2002 On request we added the protected worksheets processing to the Excel Add-In, PerpetualBudgetXL.  There have been several revisions to this code over the past two weeks while we smoothed the wrinkles out of it.  Currently the builds are at:
PerpetualBudgetXL v1.70.83
PerpetualBudget v1.70.70

You can download these versions here.

March, 2002 New products, product name changes and general information.  We had set as a goal the end of January to begin rolling out a series of spreadsheet budgeting products using PerpetualBudget System as the underlying processing technology.  These products are underway but won't begin releasing until the end of the quarter.

At that time, the product name "PerpetualBudget" will associate with the spreadsheet budgeting products bundled with the existing PerpetualBudget System.  The general workbook collaboration products will be re-named "PerpetualWorkbook".  We have heard from many of our users that they use our technology for a lot more than budgeting so in response to them, we are re-naming the products more appropriately.

Thursday, February 28, 2002 The PerpetualBudget Staff is getting a short vacation with family starting March1 and returning March 5.  All emails and support questions will be answered then.  The v1.7x products continue to be released to the web site as we prepare for the initial release of PerpetualBudget v2.0 - Manufacturing scheduled for March 31.  This will be a full-featured distributed Excel budgeting product using the perpetual workbook distributed desktop philosophy. Full details will be posted to the web site soon.

Friday, February 8, 2002 PB/PBXL v1.70 will release to the web site.  The new feature sets are:

• Accept, Preview or Edit user budget changes before committing them to the master workbooks.
• Point and click review of corrupted user files cell values side-by-side with master values.  Repaired files process automatically.  Non-reparable files are saved as <userfileold.xls> and a new template is created.
• Copy - Values only.  Create User files (templates) as copies of master workbook worksheets either with Formulas, or Values Only.  This is useful for remote updaters who don't have access to the LAN.  Solves the #REF problem!
• File management screen added to PerpetualBudgetXL.  Launch budget workbooks, templates and user files from a single screen.
• Bug fixes.  During this period of code merge and quality improvements, we have supported several system evaluators who have uncovered a number of bugs and made suggestions for improving our system.  We have incorporated many of these suggestions and we thank the users for their support. 

Monday, January 14, 2002 New builds of PB v1.61, PBXL v1.61 and PB SYS v1.61 are going up on the web site today.  Thanks to some input from beta sites, we have cleaned up the add/del record code in the Configure screen.  This screen is shared on all products and the behavior of adds and deletes is consistent.  Later in the week, we will be adding the RC location of corrupted User file cells to the Error screen processing.  This is in preparation to improve the handling of corrupted user files.

Monday, January 7, 2002 Happy New Year from the PB Product Team!  In preparation for the expansion of our product lines later this month, we are making a quality release of v1.61.  In order to build multiple versions of the Windows product and the Excel Add-in, we have re-merged all binary modules and re-designed our build system to support OEM code production.  The beneficiary of this consolidation is the Add-in product PerpetualBudgetXL which now shares most of the functions found in PerpetualBudget.  In the course of consolidating the base code, we fixed many bugs and re-worked some of the screens. Beta versions of v1.61 can be found here.

Saturday, December 8, 2001 All versions of PerpetualBudget v1.60 are released to the download page of the web site.  These products run on Windows 95/98/NT2000 and Excel '97 and higher.  See below for new features.

Sunday, November 18, 2001 An annoying bug in PerpetualBudget v1.51 was reported today.  If you right-mouse click on a worksheet in the BudgetExplorer, the program crashes!  There isn't any functionality in this event but a crash is a crash!  This has been fixed;  the link to download a new install is at ftp://ftp.spicer-baer.com/PB160SYS.exe.

Friday, November 16, 2001 We're starting to post new beta versions of PerpetualBudget v1.60 on the beta download page.  The added feature list is:

• Cut and paste for data table editing.
• Drag and drop file operations on selected screens.
• New QuickStart Wizard.  Drop your budget workbook(s) on the main screen and have the Wizard build your system automatically.
• Point and click your Outlook Address Book contacts and lists into the budget users group.  Automatically manages duplication so when your distribution lists change just add them again.
• Find and Replace features for long list tables.
• Improved LockedOut controls to point and click.
• Major cleanup of screens, fewer controls, more auto-fill point/click.

This release is becoming a cleanup prelude in preparation for the planned expansion of the product line to include a family of Excel budgeting applications specially designed around the PerpetualBudget concept.

Wednesday, October 31, 2001  Read our new white paper on "Improving Excel Collaboration".

Friday, October 19, 2001  All versions of PerpetualBudget v1.51 are released to the download page of the web site.  These products run on Windows 95/98/NT2000 and Excel '97 and higher.

Friday, October 5, 2001 (update 10/12/2001 - we are extending the QA cycle to handle the extra test load of Excel 97.  The beta is stable;  go here to download the beta versions.

• PerpetualBudget System v1.51 is available for evaluation and purchase.
  • This minor update to 1.50 includes Excel 97 support for PBXL.

Friday, September 28, 2001

• The latest builds of PerpetualBudget 1.50.6x contain three new requested features:
  • Skip open User Files - during an Update Master Files operation, if various User Files are in use, the program detects this, logs to the Error table and skips the file.
  • Process protected worksheets - when you add a master budget workbook to a budget, protected worksheets prompt the Admin User to enter the protection password.  If the password is not supplied, this worksheet is not included in the update system.  This automates the processing of protected worksheets.
  • Process password protected Workbooks.  Identify the Open and Modify passwords when prompted.  Stored as encrypted strings, the program manages the application of passwords to fully automate existing workbooks.  Apply or remove workbook passwords with a mouse click! 

Friday, September 7, 2001

• PerpetualBudget System v1.50 is available for evaluation and purchase.

Friday, August 24, 2001 (slipping to 9/7/2001)

• PerpetualBudget System v1.50 becomes available for evaluation and purchase.
  PerpetualBudget and PerpetualBudgetXL are available separately in addition to the system product. There is no planned change in price for either product.  Registered users can upgrade at no cost.  Users in mid-evaluation stages can extend their demo period by contacting Support@spicer-baer.com with the two user codes found by running "Unlock By Phone" on the About box.
• PerpetualBudgetXL will be available for Office 97/Excel 8 users.  We're working to use the existing COM DLL for Excel 2000 in the Office 97 environment.  The installation package will detect an Office 97 install and use the new components.  This addition helps corporate customers who have a variety of Office 97 and higher versions running on their client machines.  This code is still in test and will release in v1.51 on September 21.2001.

Monday, August 6, 2001 (actual date = 08/13/01, had some issues!)

• PerpetualBudget System v1.50 Beta becomes available for evaluation.
  Feature list includes:
  • Multi-user admins can now work together on the network.  ANY installation of PerpetualBudget can publish their local database on the network and create user accounts for other Admin users of PB.  At runtime use the local database module or logon to the network database.  Existing database modules migrate seamlessly to the new version.
  • Migrate budget records easily between the local and network databases.  Author status and network permissions protect your work. 
  • UNC file support is now fully supported and tested.  This removes the dependencies from mapped drive strings in the database.
  • Code merge DLLs have been written to streamline the code base on shared functions between PerpetualBudget and PerpetualBudgetXL.  This results in better code quality, smaller memory footprint and faster processing at runtime.
  • PB File Wizard now inspects your existing Excel workbooks and makes suggestions as to how to modify them for better adaption to the PerpetualBudget user file network creation and processing.
  • Encryption/decryption of sensitive information
  • PerpetualBudgetXL runs on Excel 8 and higher versions.

Thursday, August 2, 2001

A bug has been reported on PB v1.40 and PBXL v1.40 for International language versions of Windows that prevents the file from running in some cases.  We found a hard-coded string associated with the test for existence of the file pbudget.dsn;  the error reports that the file can't be found.  This has been corrected and a new version will be available on the web site Monday, August 6, 2001 here.

Monday, June 11, 2001

• PerpetualBudget v1.40 becomes available for evaluation and purchase.  Feature list includes:
  • New and 'smarter' installation program, many fixes
  • Automated e-mail retrieve features
  • New e-mail compose screen
  • Migration, backup and restore database features
  • SendMail and Configure screens as in PerpetualBudgetXL
  • Significantly smaller memory footprint, faster load and processing
  • Help file cleanup and new tutorials

  This brings PerpetualBudget and PerpetualBudgetXL to a new baseline of features in preparation for the multi-user product release planned for June 30, 2001.

Friday, June 1, 2001

PerpetualBudget v1.40 Beta was unloaded to the web site today.  The overinstall and database migration features work on installations v1.40 and above.  For assistance in migrating your existing data to the new version, contact Support@spicer-baer.com.

Thursday, May 24, 2001

Windows 2000 users have found a bug.  If your operating system is not installed on the C drive, for instance, the program installs but fails to locate the database module.  This has been corrected so that PerpetualBudget installs and run wherever the the operating system is installed.

Tuesday, May 22, 2001

Budget_Name characters bug found.  Non-alpha numeric characters used in the Budget Name are causing query errors in both PerpetualBudget v1.33 and PerpetualBudgetXL v1.30.  A fix is underway for v1.40.  Until then, don't use special characters like the apostrophe in the Budget Name;  use aA-zZ, 0-9 and whitespace.  The latest binaries are available for anonymous FTP download at ftp://ftp.spicer-baer.com (pbudget.exe, perpbxl.dll and the latest database module, pbmaster.mdb).

Friday, May 18, 2001

PerpetualBudget v1.33 has a new build on the web site.  We found a bug relating to updating multiple workbooks in a budget context.  If each master workbook has multiple User files to update, the error involved the update engine attempting to open an already open workbook.  This spawns a multitude of downstream errors which don't kill the application but acts pretty ugly!  A new version has been uploaded to the web site.

Thursday, May 17, 2001

We've just completed a major overhaul of the HELP system for PerpetualBudgetXL, including a tutorial on budget workbook construction and budgetsystem creation.  You can download the file here; it is compatible with Microsoft HTML Help.

Wednesday, May 2, 2001  

• PerpetualBudgetXL v1.30 was uploaded to the web site today and is available for evaluation and purchase.  Feature list includes:
  • Automatic email retrieval of user file attachments.  By creating an admin user mailbox, budget users can update the master spreadsheets via email attachments.  After updating their user files, they reply to the admin email and attach the user file.  The program examines the email and attachment, locates the proper folder, overwrites the old file and alerts the admin user of an update..
  • Application based HELP system.
  • Top-down hierarchical views of budget structures
  • Sample files get installed with the product and launch from the program.
  • Worksheet models for templating get installed with the product and can be loaded from the product.
  • Tracks workbook changes and updates database records automatically.
  • Windows 2000 support

Monday, April 9, 2001

• Windows 2000 support for PerpetualBudget v1.33 Beta is available on the web site.

• PerpetualBudget v1.21.21 was uploaded to the web site today.  We are continuing development of the retrieve email functions in preparation for the 1.30 release.  If you have installed v1.21, download this file ftp://ftp.spicer-baer.com/pbxldll.exe and copy it to your install directory.  It may be necessary to reload the COM DLL in Excel.  Go to "Tools" and select "COM Add-Ins..".  If this menuitem isn't present read our article on adding the COM Add-Ins... menuitem.  Click on "Add" and browse to the install directory and select perpbxl.dll.

Wednesday, April 4, 2001
Win95/98 install issues advise:
If your install is aborting after receiving these error messages " your system files are out of date..." and then a second error message "can't read a temporary file..." we may have a fix.  Our Microsoft installer doesn't always handle long filenames and we have introduced several new commercial components with long filenames into PerpetualBudget.  Click on the appropriate link ( PerpetualBudget v1.33 or PerpetualBudgetXL v1.21) download and install the file (small files).  The long filename components will be installed on your system.  Then re-install the PerpetualBudget product and it should install ok.  We will fix this problem on future releases.

Saturday, March 31, 2001

ADO errors advise:
If you are getting ADO errors with PB or PBXL, download this patch and install.  It is the latest database module (ftp://ftp.spicer-baer.com/dbms.exe password="dbms").  The problem being reported by users is they installed PBXL v1.21, and then installed PB v1.33.  The ADO errors occurred in PBXL.  We believe a downrev database module was distributed in the sample files for several days after PBXL v1.21.15 was released.

Thursday, March 29, 2001

Build Alert! PerpetualBudgetXL v1.21.00
While testing the code for auto-retrieve user file, we found some bugs in the SendMail functions which are fixed in this release. Also, the build left out a file pvprgbar.ocx which is needed for correct operation.  If you have installed PerpetualBudget in addition to PerpetualBudgetXL then you have this file.  PerpetualBudgetXL users should download and install version 1.21.15 from the web site. 

Tuesday, March 20, 2001
We are in test with Windows 2000 support, which installs with MDAC v2.5.  In late Q2, we   will merge all PerpetualBudget code to only support MDAC v2.5.  MDAC v2.5 is compatible with Win 95, 98, NT4, Me and 2000.  This will require users to have MDAC v2.5 on their system or to download it (one time) and install it before running PerpetualBudget v1.50 or higher.

Wednesday, March 14, 2001 The PerpetualBudgetXL schedule is firm for this date.   See the features list for more information.

• PerpetualBudgetXL v1.21 becomes available for evaluation and purchase.  Feature list includes:
  • Product runs from Excel as a COM Add-In
  • Build Worksheets functions include automated proliferation from selected templates.
  • Run Macros - record a macro on the template worksheet and automatically proliferate the action(s) to all selected worksheets.
  • Make Summary Worksheet automatically by point & clicking rows/columns
  • Create User Files - selected worksheets are copied automatically to named folders.
  • Manage Users - enter budget group user information and assign users to file folder areas.
  • Send Mail - manage the budget cycle via email and deliver user files to remote network users.
  • Update Master Files - automatically update the master workbooks from user file inputs.  
  • Seamless compatibility with PerpetualBudget.  Both products share the same control database.  Open a workbook in Excel and get instant budget context.  

Monday, March 12, 2001 Posted PerpetualBudget v1.33 to the web site.  Fixed the Options screen to display the proper size.

Wednesday, March 7, 2001

• Posted PerpetualBudgetXL v1.20 Beta to the web site

Wednesday, February 28, 2001

• Posted PerpetualBudget v1.32 to the web site
  • Fixed a bug where the "Add Budget" function from the main screen overwrites an existing budget record.

Monday, February 26, 2001

• PerpetualBudget v1.31 is available for download and evaluation
  Bug fix release includes:
  • Contextual display of screen data for Folder Names - required a change to the control database (pbmaster.mdb).  If the install prompts you to keep the old file, select "No".
  • Prompting for Admin data configuration when adding new budget
  • Work around for Data Explorer node control inconsistencies
  • Improved handling of "<NewBudget>" Cancel and Back controls when adding new budget. 
  • Fixed problem with launching user file from data table with only one record.
• New sample files for v 1.31 are available on the Download page.

Sunday, February 25, 2001

NOTE:  Where did createuf.exe and updatemf.exe go?  If you remember these were the original PerpetualBudget Components freeware products for Excel 2000.  These functions were merged into a single Excel 2000 COM Add-In and is now called "PerpetualBudgetXL", which is now in beta test.  It is still freeware;  the initial install has a 30-day evaluation mode.  After 30-days, all functions that have been implemented continue to work as freeware;  the product can be purchased at any time to continue expanding the application of the product.

Friday, February 16, 2001 

• PerpetualBudget v1.30 becomes available for evaluation.
  Feature list includes:
  • Manage multiple budgets - Budgets Explorer
  • Simplified main screen interface - Budget context sensitive
  • New & improved budget Wizard
  • High speed update engine
  • Worksheet & User File data storage becomes an optional background operation.
  • Improved point & click integration between PerpetualBudget and Excel.

Friday, January 5, 2001

• PerpetualBudget 1.20 goes final and available for evaluation and purchase.

Thursday, December 14, 2000

• PerpetualBudget 1.20 Beta has been updated and uploaded to site.  Additional features include:
  • File Operations screen includes restore User Files from data, refresh User File data and hierarchical Delete User File.
  • Launch Excel with master file or user file loaded by double-clicking on file objects in the Explorer table.  This enhances the back-and-forth interaction between working in Excel using the PerpetualBudget Components (CreateUserFiles) and PerpetualBudget's Import function to automatically build the storage/management system from configuration files. 

Friday, December 8, 2000    UPDATE:

• PerpetualBudget 1.20 Beta has been uploaded to site.
  • This version will add an import function to seamlessly work with the  CreateUserFiles and UpdateMasterFiles Excel add-ins.  
  • This release also removes any file location restrictions on master files that currently exist in PerpetualBudget.  PerpetualBudget will run wherever your master files are stored.
  • Hierarchical master file table entry deletion.  Now when you delete a master file entry in the Setup Budget Files Wizard P2 table, all associated objects will also be removed.  This allows you to update your system or import a previously configured master file from CreateUserFiles without having to run the System Clean functions.

Wednesday, November 29, 2000

• CreateUserFiles 1.10 Beta is uploaded to the web site.
  • Added delete row function to the data table.  The worksheet/user file complement can now be edited by Folder Name and row content, and then saved to a file.
  • Added code to check the version of the master file when loading the data table from the configuration file.

Wednesday, November 29, 2000

• UpdateMasterFiles 1.00 Beta will be released and uploaded to site.
  • This version finds the CreateUserFiles configuration file, loads the data table and performs full updating of the master file spreadsheets.
  • Code checks for full User File integrity including 'illegal' changes to the User File spreadsheet.

Friday, November 17, 2000

• PerpetualBudget 1.11 released and uploaded to site.
  • Completed testing.  Fixed a bug where in some cases, the Update master files handled the data correctly but didn't update the file modified dates on all master files.

Thursday, November 16, 2000

• CreateUserFiles 1.00 Beta uploaded to site.  This is a freeware Excel addin product exampling some of the techniques of PerpetualBudget.  You can read about it here.

Monday, October 30, 2000
If the 30 day period to evaluate PerpetualBudget is not enough, send us the unlock codes from the About box and we will refresh your demo period.

• PerpetualBudget 1.10 Beta uploaded to site.  You can tell which build you are using by looking at the About box.
  • Added new controls to display when errors in the User File have occurred.
  • Added a Clear button to clear the errors table from the main screen.
  • Fixed a bug when updating the Master Budget files for strings greater than 255 characters.
  • Improved the error processing of boundary conditions such as trying to pass Excel arrays which contain excessively long strings (> 768 characters).
  • Added additional levels of error processing to prevent application crashes and improve automated handling of errors.

Friday, October 20, 2000

• PerpetualBudget 1.10 Beta uploaded to site
  • Added controls to Update All or Update Folder Name
  • Added multi-row selection to all screen data tables

Friday, Sepetember 29th, 2000

• PerpetualBudget PB10.EXE goes on sale as shareware.

Tuesday, September 19th, 2000

• Refresh database file for 1.00 version on ftp site (pbmaster.mdb)
• Most recent HELP file on ftp site (pbhelp.chm)

Monday, September 18th, 2000

• PerpetualBudgetSampleFiles.exe uploaded to download site

Wednesday, September 13, 2000

• PerpetualBudget PB10B34.EXE & PB10B34M.EXE made available for FTP download
  • Web purchase features
  • Remote activation: Extended services
  • Move Database functions

Wednesday, September 6, 2000

• PerpetualBudget PB10B33.EXE & PB10B33M.EXE made available for FTP download
  • Trialware features enabled
  • Remote activation: Application feature enabling

Wednesday, August 23rd, 2000

•  PerpetualBudget PB10B32.EXE & PB10B32M.EXE made available for FTP download
  • Many bugs fixed (see newsletter) in preparation for release.
  • General cleanup of the user interface in preparation for release.
  • Errors detected in creating/updating User File database storage tables automatically removes that template from updating the master spreadsheet files.

Thursday, August 10th, 2000

• PerpetualBudget PB10B31.EXE & PB10B31M.EXE made available for FTP download
  • New & improved Compact Database function
  • New & improved Date handling, multiple instances of Excel, table naming, and file operations errors.
  • Better Splash screen and Wizard Intro screen control.
  • Help system updated.
  • Cleaned up user interface.

Monday, July 24th, 2000

• PerpetualBudget PB10B30.EXE & PB10B30M.EXE made available for FTP download
  • Added Record Length error handling
  • Expanded and improved compression controls & error handling
  • Fixed SendMail logic/display bugs

Monday, July 17th, 2000

• PerpetualBudget PB10B23.EXE & PB10B23M.EXE made available for FTP download
  • Added general purpose data compression
  • Added Error reporting screen
  • Added Error Correction Wizard
  • Added Getting Started screen

Friday, June 30th, 2000

• PerpetualBudget PB10B22M.EXE made available for FTP download
  • Re-organized Setup Budget Files Wizard
  • Removed error handling - reworking
  • Bug fix release

Monday, June 26th, 2000

• PerpetualBudget PB10B21M.EXE made available for FTP download.
  • Added Attachments to SendMail functions
  • Added table background cell color coding to update management
  • Added text editor support for custom email body text

Monday, June 19th, 2000

• PerpetualBudget PB10B20M.EXE made available for FTP download.  This version does not include MDAC 2.1 support, reducing the download package size by 6MB.
  • Added SendMail functions

Tuesday, June 13th, 2000

• PerpetualBudget PB10B19M.EXE made available for FTP download
  • Improved System Clean functions
  • Added Compact Database function
  • Added Toolbar functions
  • Added Print functions

Wednesday, June 7th, 2000

• PerpetualBudget PB10B18.EXE made available for FTP download
  • Added Set/Restore Excel environment control
  • Expanded error handling to table processing
  • Save hidden controls setting in registry
  • M version of download available (4.9MB)

• PerpetualBudget PB10B17.EXE made available for FTP download
  • Only 'change data' updated in master file worksheets
  • Error handling added to all editable table controls
  • Help system added

Monday, May 22nd, 2000

• PerpetualBudget beta test program web placed on-line

PerpetualBudget and Spicer-Baer Associates are registered trademarks of Spicer-Baer Associates, Inc.  Excel, Access and Microsoft Windows are registered trademarks of the Microsoft Corporation.  QuickBooks Pro is a registered trademark of Intuit Inc.

Questions or problems regarding this web site should be directed to Webmaster@spicer-baer.com.
Copyright © 1999-2007 Spicer-Baer Associates, Inc.  All rights reserved.
Last modified: Sunday April 22, 2007.