The release notes are divided into sections. Each section contains a version number and the changes / adaptations in the CALC4XL software that are implemented and available with this version.
You can determine your version in the CALC4XL menu by clicking on “License”.
From the CALC4XL version 1_0_14_201, the version number includes a compatibility number.
If users use CALC4XL versions with the same compatibility number, they can exchange their calculations with each other.
A user with a lower compatibility number must update his CALC4XL version before opening the calculations.
You can always download the current version of CALC4XL from your profile on our website or directly from the following links: Download
The CALC4XL version 1_0_16_221 comes with a new compatibility number. This means if you receive a CALC4XL file created with this new version, but you still have an older CALC4XL version installed, the CALC4XL system will prompt you to install a new CALC4XL version.
Main selection fields of the project specification linkable in Excel cells
The 4 main selection fields (country, industry, product, turnover [EUR]) of the project specification can now be linked in Excel cells.
New field in project specification: Batches/year
The CALC4XL project specification was extended by the field “Batches/Year”.
This value is transferred to the field “Batches per year” in the updated CALC4XL Cost Breakdown and the lot size is automatically determined from this together with the number of parts peryear (Parts/Year).
For your own entries, the formula for calculating the batch size can be overwritten, as can the formula for calculating the set-up costs. If necessary, the formula can be retrieved by removing the value entered by the user (key “Del”).
In CALC4XL Cost Breakdown you can display the prices for any number of parts. Enter the following character combination: “/” followed by any decimal number (e.g. /100 or /0.5). This means that the CALC4XL product cost calculation software can also be used to calculate spare parts.
The set-up time (Setup) is now entered in the main columns of the CALC4XL Cost Breakdown. In previous versions, the setup time was entered on the right in the sub-table. It is now only displayed there for information purposes.
With CALC4XL version 1_0_15_220 you get an updated CALC4XL benchmark database with updated material data.
“Microsoft Visual Studio 2010 Tools for Office Runtime” is no longer a requirement for the CALC4XL Product Cost Calculation Software application. These are no longer installed during the installation of CALC4XL.
In CALC4XL Cost Breakdown, the function “Add Column” is available in the worksheet “Summary”. With this button it is possible to add more columns to be able to compare even more calculations.
Compare calculations from several calculation files
If you want to compare calculations from different cost breakdown files, you can copy them into one cost breakdown file.
It is important that all cost breakdown files have the same structure so that the values are comparable.
Carry out the following steps:
Open the cost breakdown in which you want to compare the calculations (target file).
Open the cost breakdown from which you want to copy calculations to the target cost breakdown.
Right-click on the tab of the cost estimate you want to transfer and select “Move or copy”.
Activate the checkbox “Create copy” !
Select the target file from the drop-down list “To Folder:”, define the insertion position within the workbook (e.g. Insert before: “Summary”) and click “OK”.
The calculation (without CALC4XL modules) is now inserted into the selected target file.
If you now go to “Summary” in the CALC4XL Cost Breakdown, the drop-down lists are automatically expanded and you can select the inserted calculation for comparison.
The function “Copy Sheet” can now optionally be carried out with or without a copy of the CALC4XL modules.
If a cost estimate is copied in CALC4XL Cost Breakdown with CALC4XL Modules, this cost estimate still has CALC4XL Modules in the background. In addition, a separate project specification is created/assigned for each costing spreadsheet if this was created using the “Copy Sheet with CALC4XL Modules” function.
CALC4XL product cost calculation software has suppressed the Undo button in CALC4XL templates in previous CALC4XL versions. The Undo button is available as long as no code-based CALC4XL operations (C# code) have been actively called by the user, e.g. inserting or deleting a line or making changes in CALC4XL modules.
Change date of the calculation
If you open a calculation (CALC4XL Cost Breakdown or CALC4XL Super BOM) and do not make any changes, the file’s modification date is not overwritten. The modification date of a file is only updated if a change has actually taken place and it has been saved.
View CALC4XL benchmark database vs. connect Excel cell with result of a calculation module
The CALC4XL product costing software has been optimised so that you can access the CALC4XL costing modules from the CALC4XL menu to view the contents of the CALC4XL benchmark database.
If you want to view the content of the CALC4XL database of a category (e.g. machines), you can do this from any Excel cell in your calculation. When you click on a CALC4XL calculation module in the CALC4XL menu, the system gives you a message. If you confirm this message with OK, the corresponding CALC4XL calculation module opens in a pop-up window and you can browse through the contents of the database.
Then close the pop-up window via the “X” or “OK”. The Excel cell is not linked to the CALC4XL calculation module.
If you want to link CALC4XL calculation modules to your calculation and connect values from a CALC4XL calculation module to Excel cells, please continue to use
– the link mode (“connect Excel cell”) or
– link a CALC4XL calculation module directly to your calculation via right mouse click.
In previous versions, when a CALC4XL calculation module was called, the CALC4XL system asked the user whether the result (main value) from the CALC4XL calculation module should be linked to the active cell. In some cases, this has led to users “accidentally” making invalid links and then the calculation was no longer functional.
If a CALC4XL database has been renamed or moved (changed database path), the CALC4XL system will still find it again, provided the file (calculation) with the connected standard database has been saved once with the new CALC4XL version.
In earlier versions, the CALC4XL system informed the user that the database could no longer be found. The user had to connect the “old” database manually.
If the CALC4XL benchmark database is copied and the original CALC4XL benchmark database is deleted, then the CALC4XL system will not be able to find the CALC4XL benchmark database originally connected to the calculation again, because the copied CALC4XL benchmark database is a different database from the system perspective.
CALC4XL provides various functions for this purpose.
With CALC4XL version 1_0_15_218 these functions have been extended and optimised for CALC4XL Cost Breakdown.
Insert and display picture in the project specification of CALC4XL Cost Breakdowns
If you insert a picture into the project specification, this picture will not only be visible in the CALC4XL Cost Breakdown in the designated area, but also displayed as a picture comment (larger display).
If you change the picture in the project specification, the picture in CALC4XL Cost Breakdown also changes.
If a picture is larger than 500KB, you will receive a message (see figure).
Insert picture via the “Insert Picture of Part” function
CALC4XL Cost Breakdown offers the possibility to insert pictures into the calculation via the “Insert Picture of Part” button.
Up to now you could only insert pictures into the area where the button “Insert Picture of Part” is displayed.
With CALC4XL version 1_0_15_218 you can now insert pictures in any cell or cell range in the CALC4XL Cost Breakdown.
To do this, click with the cursor in the Excel cell in which the picture is to be inserted and displayed. The cell is now activated.
If the picture is to be displayed in a larger area, mark the cell area in which the picture is to be displayed.
Then click on the “Insert Picture of Part” button and select the picture.
If the button is overlaid with a picture, move the picture so that the button becomes visible.
The inserted picture is automatically reduced/enlarged to the correct size according to the selected area and the picture quality is optimised to save storage space.
Insert picture comments
Furthermore, the following functions are available in the usual way for each Excel cell
“CALC4XL: Add/Change Picture Comment” (siehe Releasenotes CALC4XL-Version 1_0_1_197 CALC4XL Picture comments
“CALC4XL: Add/change picture comment from clipboard” (siehe Releasenotes CALC4XL-Version 1_0_1_198 CALC4XL Picture comments
CALC4XL version 217 contain various changes to improve performance and stability.
AutoSave is a new feature available in Excel, Word, and PowerPoint for Microsoft 365 subscribers. The file you are working on is saved to OneDrive or SharePoint Online in the background every few seconds.
AutoSave is enabled by default in Microsoft 365 when a file is stored on OneDrive, OneDrive for Business, or SharePoint Online.
From CALC4XL version 126.96.36.199 you can use the Microsoft Office function “AutoSave” without restrictions.
Collaborate on Excel workbooks at the same time
Microsoft provides Microsoft 365 subscribers with a simplified feature for collaborative simultaneous editing of Excel workbooks.
You and your colleagues can open and work on the same Excel workbook.
Information on this can be found on the Microsoft support page: Collaborate on Excel workbooks at the same time with co-authoring
If you do not use Microsoft Office 365, you can use the “old” function to share your workbook.
Information on this can be found on the Microsoft support page at the following link: Share your Excel workbook with others
Printing the technology plan for “Mechanical processing” and “MAG welding” has been optimised.
You can print the entire technology plan via the “Print” button. A print version is created that you can save as a PDF or image, print out and forward (e.g. to your production department).
Changes and enhancements in the cost breakdown
– In the new Cost Breakdown you can create as many lines as you like.
– The cost breakdown now has a reference number for each input line. Here you can reference, for example, which material is required for which production step..
– Sorting, which you can initiate in each section via the sort buttons (Sort), has been accelerated.
An external SQL database can now be connected using Windows authentication in addition to user ID and password.
CALC4XL versions 212/213/214/215 contain various changes to improve performance and stability.
Furthermore, preparatory work was carried out to enable CALC4XL to be operated with either an Access database or an SQL database.
From CALC4XL version 1_0_15_215 you can choose the database with which you want to operate CALC4XL.
CALC4XL is delivered with an Access database as standard.
At the customer’s request, we can deliver CALC4XL with an MS SQL database.
The injection moulding process has been adapted so that the value Ο seconds is predefined for the removal.
Optimised display of material data: material designation and dates
– The dropdowns now automatically have the correct width when long material names are inserted.
– The user can use any date format such as dd/mm/yyy or mm/dd/yy or written out date.
Extension of the visualisation of numbers with thousand separators
Any characters can be used as thousand separators, e.g. inverted commas for Swiss notation (1’200.00 and 1’200,00).
In the CALC4XL version 207/208/209/210 optimizations and stability improvements have been made.
In CALC4XL version 207/208/209/210 the CALC4XL benchmark database has been completely updated.
You can reach the CALC4XL help in the CALC4XL menu via the icon with the question mark.
The help panel has been revised and guides you through the first steps in CALC4XL.
– Connect standard database
– Select default currency
– Where can I find the manuals?
– How do I start my first calculations?
In the CALC4XL version 204/205/206 extensive architectural changes have been made.
Cost Breakdown calculation template changed from xlsm to xlsx
The template for the Cost Breakdown has been changed from an Excel workbook with macros (*.xlsm) to Excel workbook (*.xlsx) and is now available in a macro-free version, i.e. the code of the Cost Breakdown no longer contains macros or Visual Basic code.
This means for you
– fewer IT hurdles when installing and using CALC4XL, as virus scanners no longer classify the calculations as “dangerous”.
– Calculation files in xlsx format can be sent by e-mail without the message/indication that there is a potential virus danger from this file.
Convert (old) cost breakdowns with macro to xlsx files
(Old) cost breakdowns in xlsm format (with macros) can be converted into xlsx format at the push of a button.
Convert cost breakdowns with obsolete Visual Basic code into xlsx files
If your cost breakdown contains obsolete Visual Basic code, the CALC4XL system will inform you. Confirm the query with “Yes”.
CALC4XL automatically converts your file into an xlsx file.
Macros are deactivated in CALC4XL template
If macros of a CALC4XL template are deactivated, the CALC4XL system informs you of this. Confirm the message with “OK”.
For better visualisation, the numbers in the machine calculator are displayed with thousands separators.
Users can now use thousands separators when entering numbers (e.g. 1,000,000.00 (en) or 1.000.000.,.00 (de)).
In the machine calculator, the hourly fixed and variable costs are shown in addition to the complete machine hourly rate.
If you enter the machine hourly rate manually, you can also display the fixed share. The variable part is calculated..
Zero values are now allowed in the project specification.
The wage overhead costs are controlled centrally via the project specification.
If you want to change the wage overheads, this is only possible via the project specification.
The user receives a corresponding notification.
CALC4XL is multilingual. In addition to English and German, you can now also choose Chinese as the language.
23 new Chinese regions included in the project specification with all global data (wages, country data, overheads).
The CALC4XL user receives a message when opening Excel if the standard CALC4XL database is not found (e.g. deleted or renamed or moved).
CALC4XL offers two licence variants:
Node-locked licence (local licence)
Each computer (laptop, PC) requires its own licence. The licence is permanently linked to this one computer and is based on the unique hardware ID of your computer.
After installing CALC4XL, enter your individual licence key for your computer. Once the licence is activated, you can calculate at any time. You do not need to be connected to a network online.
Floating licence (network licence)
CALC4XL provides you with a licence server file. This licence server file is based on the unique hardware ID of the server. The Floating Licence Server (FLS) file must be stored on the network in a location that all ( planned) CALC4XL users in your organisation have read and write access to. This can be an (NTFS) server, a shared network folder, a SharePoint or similar. Once you have initialized the FLS file, do not move or copy the FLS file, as the FLS file will then change its ID and be locked. Therefore, choose a storage path that is permanent.
Each CALC4XL user obtains and activates a temporary licence for his or her computer as needed. As soon as the user has finished using the CALC4XL software, he can return the licence to the licence server file and thus release it for other users.
Via the button “Get Floating Licence” and “Stop Floating Licence” the users who are connected to the floating licence server (and have read and write access to the FLS file) can get and return licences from the floating licence server.
We recommend the licensing variant of the floating licence for more than two or three licences and if your CALC4XL users do not regularly calculate with CALC4XL.
Please note that every CALC4XL user who wants to use the CALC4XL software
– must be connected to the network (online access) and
– must have read and write access to the licence server file,
to activate a licence for his computer.