Version history

 

[Version 11.6.0]

Updates

The worksheets "Calculation of interest", "Imputation" and "Recapitulation" are updated with the most recent legal interest rates (Civil cases: year 2017: 2,00 %).

Where being applicable (worksheets Temporary Invalidity/Disability, Permanent Invalidity/Disability and  Cosmetic damage) the worksheets are updated with the most recent data from the new Indicative Table 2016.

The manual has been updated.

[Version 11.5.0]

New component

A new worksheet "Filing schedule" has been added. It lets the user calculate filing periods according to art. 747 § 2 Gerechtelijk Wetboek (Judicial code) and if desired insert a letter or a decision including the calendar in MS Word.

Updates

The worksheet "Date calculation concerning the appeal in criminal proceedings" has been changed.

In the worksheet "Legal Assistance" the amounts on the basis of the living wages as of 1/06/2016 are updated and also the amounts of the income limits as of 1/09/2016 are updated (Belgian Law Gazette 31/8/2016).

The worksheets "Tables", "Prostheses" and "Funeral costs" are updated with new recent data for life expectancy calculation (see below).

The most recent mortality tables of 2015 are used now, instead of those of 2014 used in the previous program version.

The manual has been updated.

[Version 11.4.5]

Updates

The worksheet "Date calculation concerning the appeal in criminal proceedings" has been updated in accordance with the new legal provisions of the law of February 5th, 2016.

In the worksheet "Legal Assistance" The amounts on the basis of the living wages as of 1/04/2016 are updated.

The Help file has been changed and extended according to the update of the program indicated above. Also the user interface of this manual has been completely renewed.

[Version 11.4.2]

Fixes

An error in the source code has been fixed: the program did not run with Excel 2007.

[Version 11.4.1]

Fixes

An error has been fixed in the French installation program: it was not possible to finish setup properly because Administrator is not a valid user or group (in the French operating system).

An error has been fixed in the French worksheet Calculation of interest: it was not possible to add data to the worksheet through the userform.

Updates

The worksheets "Tables", "Prostheses" and "Funeral costs" are updated with new recent data for life expectancy calculation (see below).

The data from the newest prosepective tables 2016 from J. SCHRYVERS and J.-P. AOUST are added. Those new tables contain the prospective life expectancy 2016 and the prospective median life expectancy 2016.

The worksheets "Calculation of interest", "Imputation" and "Recapitulation" are updated with the most recent legal interest rates (Civil cases: year 2016: 2,25%).

[Version 11.4.0]

New system requirements

  • Windows 7 or higher (Windows 7, 8, 8.1, 10)
  • Office (Excel) 2007 or higher (Excel 2007, 2010, 2013, 2016) - 32-bit version
  • The 64-bit version of Office (Excel) is no longer supported.
  • Office (Excel) XP and Office (Excel 2003) are no longer supported. The users of those versions can install the Microsoft Office Compatibilty Pack, which is available at the Microsoft Office download website.

User interface

The license status is now shown at the top of the Home page. This also happens when clicking on the button "License" in "About Daproverb" (Homepage).

The buttons "Hide Excel" and "Show Excel" has been dropped from the Home page.

Updates

In the worksheet "Deduction of own maintenance costs" statistical data are updated based on the most recent annual Household budget survey 2014 from DGSEI (Directorate General Statistics and Economic Information of the Federal Public Service Economy).

[Version 11.3.8]

Updates

In the worksheet "Legal Assistance" the amounts of the income limits and the amounts on the basis of the living wages as of 1/09/2015 are updated (Belgian Law Gazette 18/8/2015).

The worksheets "Calculation of interest", "Imputation" and "Recapitulation" are updated with the most recent legal interest rates (Civil cases: year 2015: 2,50%).

The possibility to add automatically the legal interest rate in commercial dealings has been dropped.

The worksheets "Tables", "Prostheses" and "Funeral costs" are updated with new recent data for life expectancy calculation (see below).

The most recent mortality tables of 2014 are used now, instead of those of 2013 used in the previous program version.

The data from the newest prosepective tables from J. SCHRYVERS and J.-P. AOUST are added. Those new tables contain the prospective life expectancy 2015 and the prospective median life expectancy 2015.

The Help file has been changed and extended according to the update of the program indicated above. Also the user interface of this manual has been renewed.

[Version 11.3.5]

Updated source code in order to be compatible with Excel 64-bits.

[Version 11.3.4]

Updates

In the worksheet "Legal Assistance" the amounts of the income limits as of 1/09/2014 are updated (Belgian Law Gazette 18/8/2014).

The worksheets "Calculation of interest", "Imputation" and "Recapitulation" are updated with the most recent legal interest rates (Commercial dealings - only for agreements made before 16/03/2013: 2nd semester 2014: 7,5 %).

The worksheets "Tables", "Prostheses" and "Funeral costs" are updated with new recent data for life expectancy calculation (see below).

The most recent mortality tables of 2013 are used now, instead of those of 2012 used in the previous program version.

[Version 11.3.0]

The source code for the automatic insertion of legal interest rates in the sheets "Calculation of interest", "Imputation" and "Recapitulation" has been optimised.

Updates

In the worksheet "Legal Assistance" the amounts of the income limits as of 1/09/2013 are updated (Belgian Law Gazette 19/8/2013). The amounts on the basis of the living wages as of 01/09/2013 are also updated.

In the worksheet "Deduction of own maintenance costs" statistical data are updated based on the most recent annual Household budget survey 2012 from DGSEI (Directorate General Statistics and Economic Information of the Federal Public Service Economy).

The worksheets "Calculation of interest", "Imputation" and "Recapitulation" are updated with the most recent legal interest rates (Civil cases: year 2014: 2,75%).

 

[Version 11.2.0]

User Interface

When starting, the program checks if "Trust access to the Visual Basic-project" is enabled in Excel. If it isn't Daproverb cannot work properly. If desired the dialog Macro security is shown immediately to let the user make the necessary changes.

 

[ Version 11.1.0]

New user interface

From now on Daproverb is bilingual: Dutch - French
The program starts automatically in the language of the Microsoft Office installation on the user's computer.
The default language can be switched on the Starting page by clicking the button next to the flag icon.

New worksheet buttons

The sheets Temporary disability, Interest calculation, Imputation of payments and Recapitulation are provided now with the new buttons Export and Import.
With those buttons the worksheet data can be exported to a text file and later on can be imported again on the matching sheet.

 

[Version 10.2.0]

Updates

The worksheets "Tables", "Prostheses" and "Funeral costs" are updated with new recent data for life expectancy calculation (see below).

The most recent mortality tables of 2011 are used now, instead of those of 2010 used in the previous program version.

 

[Version 10.1.2]

New user interface

The user interface has been sweepingly changed again. Simpler command buttons on the worksheets have been choosen, stripped of all frills: actually they are just so called form controls. Also the background colors of the home page have been changed (image homepage).

New components

On the worksheets "Calculation of interest" and "Imputation" the user interface has been totally renewed . Actually it's possible to add the legal interest rates in civil cases and commercial dealings fully automatically to the worksheets matching the periods wherin they have been changed. So finished the time-consuming searching which interest rate precisely applies to which period: just check one checkbox on the user form to enable that automatic process (image checkbox). Now you are always sure that the correct interest rate is added for each period of debt amounts and/or payments (image result).

The same applies to the worksheet "Recapitulation" (of items of loss). The worksheets Recapitulation 1 and Recapitulation Plus have been fused into a single worksheet Recapitulation. Here also it is possible to let the program add automatically the correct interest rate for each period. Adding data has been made quite simpler also (image result).  With just one click on the button "Copy > Word" the table is added to your Microsoft Word document containing your draft judgement.

Updates

Where being applicable (e.g. worksheets TO and BO) the worksheets are updated with the most recent data from the new Indicative Table 2012.

In the worksheet "Legal Assistance" the amounts on the basis of the living wages as of 01/12/2012 are updated.

The worksheets "Calculation of interest" and "Imputation" are updated with the most recent legal interest rates (Commercial dealings: 1st semester 2013: 8% and Civil cases: year 2013: 2,75%).

The worksheets "Tables", "Prostheses" and "Funeral costs" are updated with new recent data for life expectancy calculation (see below).

The data from the newest Prosepective tables 2013 from J. SCHRYVERS and J.-P. AOUST are added. Those new tables contain the prospective life expectancy 2013 and the prospective median life expectancy 2013.

The Help file has been changed and extended according to the update of the program indicated above.

Improvements

The "Print" command has been improved for several applicable worksheets. Actually the Print Preview is always shown previously. From there (if everything seems to be OK), the printing itself can be started.

The command "Copy > Word" has been improved for the applicable worksheets. The pasted table in the Word document is a lot nicer now.

 

[Version 9.8.0]

New file format

Because of compatibility especially with antivirus software, from now on the program file will be kept in the Excel file format (.XLS) instead of being compiled, i.e. converted to an executable file (.EXE).

New command buttons on the worksheets

The user interface has been sweepingly changed. All ActiveX command buttons on the worksheets have been replaced with corlorful 3D rounded rectangles linked to macros. Attention: the 3D-view of the new buttons unfortunately gets lost in Excel XP (2002) and Excel 2003 where those buttons are flat. They show up fully in Excel 2007 en 2010.

Updates

The worksheets "Tables", "Prostheses" and "Funeral costs" are updated with the most recent data for life expectancy calculation (see below).

The most recent mortality tables of 2010 are used now, instead of those of 2009 used in the previous program version.

The worksheets "Calculation of interest" and "Imputation" are updated with the most recent legal interest rates (Commercial dealings: 2nd semester 2012 - 8 %).

 

[Version 9.7.5]

New components

A new userform button "Weighted average date" has been added to the worksheet "TAO" (Temporary invalidity). It lets the user calculate the so called Weighted average date as starting date for the compensatory interest for the damages amounts.

Updates

In the worksheet "Legal Assistance" the amounts on the basis of the living wages as of 01/02/2012 are updated.

In the worksheet "Deduction of own maintenance costs" statistical data are updated based on the most recent annual Household budget survey 2010 from DGSEI (Directorate General Statistics and Economic Information of the Federal Public Service Economy).

The manual has been changed and extended according to the update of the program indicated above ("Weighted average date").

 

[Version 9.7.2]

This update is a fix: a problem has been fixed keeping the program from working for some users having Excel 2007 or lower installed. This problem was related to the Excel KB255343 update. DoneEx had to release an update for XCell Compiler to solve the problem.

 

[Version 9.7.1]

Digital signature

The VBA-project and the installation file are now provided with my digital signature provided by GlobalSign CodeSigning CA-G2. So actually the user can have total certainty about the authenticity of the software. Just check if the software really has my digital signature.

Changes in workhseet tables "Certain interest" - Monthly payments

The formula for calculating a certain interest payable at the end of each month has been changed. The actual formula left the compound interest out of account. This has been changed from now on. So the new values match those from the tables of SCHRYVERS - AOUST and C. JAUMAIN and they are different from those in the tables of G. LEVIE.

Updates

The worksheets "Calculation of interest" and "Imputation" are updated with the most recent legal interest rates (Commercial dealings: 1st semester 2012: 8% and Civil cases: year 2012: 4,25%).

In the worksheet "Legal Assistance" the amounts on the basis of the emergency maintenance allowance as of 1/09/2011 are updated (Belgian Law Gazette 23/8/2011).

 

[Version 9.7.0]

New components

A new worksheet "DATES 2" has been added, containing the following tools:

  • opposition against a judgment given by default - periods.
  • suspension of the preclusion of criminal proceedings by lapse of time during the extraordinary period for opposition.
  • suspension of the preclusion of criminal proceedings by lapse of time during the cassation procedure.

A new worksheet button "Days left until the end of the year" has been added to the worksheet "Dates".

Fixes

An error has been fixed in the worksheet "Imputation". It was not possible to add the amounts of debts and payments entered in the text boxes to the worksheet itself when the tab "Civil Affairs" was selected in the user form. This problem has now been solved.

Updates

The manual has been changed and extended according to the update of the program indicated above. So, of course, a new detailed topic has been added about the new tools in the new worksheet "DATES 2".

 

[Version 9.6.5]

Fixes

An error has been fixed in the worksheet "Imputation". It was not possible to manually change erroneous cell content, because the cells were locked due to the security settings.

In the worksheet "Legal Assistance" changes made through "Settings" or "Restore backup" are immediately shown now on the worksheet itself.

Updates

The worksheet "Calculation of percentages" has a new button offering the user the opportunity to convert gross amounts (VAT included) to net amounts (excluding VAT).

The worksheets "Calculation of interest" and "Imputation" are updated with the most recent legal interest rates (Commercial dealings: 2nd semester 2011 - 8,5 %).

In the worksheet "Legal Assistance" the amounts on the basis of the emergency maintenance allowance as of 9/5/2011 are updated (Belgian Law Gazette 13/5/2011).

The worksheets "Tables", "Prostheses" and "Funeral costs" are updated with new recent data for life expectancy calculation (see below).

The projection tables have been removed and from now on they will be replaced by the newest prosepective tables from J. SCHRYVERS and J.-P. AOUST. Those new tables contain the prospective life expectancy 2011 and the prospective median life expectancy.

 

[Version 9.6.1]

Multilingual setup program

According to the language of the operating system, setup runs now in Dutch, French or English.
ATTENTION: for the time being there's only a Dutch version of Daproverb itself. The developer is working on a French version, which possibly will be finished towards the end of 2011.

New worksheet - Deduction of own maintenance costs

A new worksheet "Deduction of own maintenance costs" has been added. In case of a fatal accident the user can easily determine the part of the costs of own maintenance of the victim to be deducted from the lost income. Statistical data is used from DGSEI (Directorate General Statistics and Economic Information of the Federal Public Service Economy) on household income and expenses from the most recent annual Household budget survey 2009. The calculation comes much closer to reality than the actual used fixed percentages, including the formula suggested by the Indicative table version 2008.

Updated parts

The worksheet "Legal Assistance" has been updated as for the user interface of the form "Data". From now on the user fist must enter the data and then click on the button "Calculate". The button "Print" has been added to offer the user the opportunity to print the worksheet. New program code has been written for entering data and executing calculations.

The worksheets "Calculation of interest" and "Imputation" are updated with the most recent legal interest rates.

The worksheets "Tables", "Prostheses" and "Funeral costs" are updated with the most recent data for life expectancy calculation (see below).

The most recent mortality tables of 2009 are used now, instead of those of 2007 used in the previous program version.

Based on those classical tables of 2009, also the projection tables have been updated (actually for 2011).

Trial period

The trial period to use the program without registration is from now on 20 days. After that trial period Daproverb cannot be used anymore without registration.

Save format for Excel files

For reasons of compatibility with Excel 2002 and Excel 2003 the ".xls"  format is used in Daproverb.To keep the user preferences for Excel 2007 and above unaltered after use of the program, from now on the following actions will be performed.
When starting Daproverb the program checks which save format the user has set (e.g. ".xls", ".xlsx", ".xlsm")and when closing the program this setting will be restored.

License agreement window

To enhance the user-friendliness of the program, from now on the license agreemt window is only shown at the very first start of Daproverb and not at every runtime anymore.

Home page - new help button

At the top right of the Home page a button is added to call easily the Help topics.

The "About Daproverb" window

To the window "About Daproverb" that can be opened from the Home page, three buttons have been added. (1) The "EULA" button (End-User License Agreement): with this button the License agreement can be shown. (2) The "Readme" button: with this button the "Readme.txt" file can be opened. (3) The "Changes" button: with this button the most recent and previous program changes can be shown.

Help file

The Help file has been changed and extended according to the update of the program indicated above. So, of course, a new detailed topic has been added about the "deduction of own maintenance cost".