Our Safety Stock Calculator v1.8 has been released. This version supports OpenERP (previously named TinyERP). This version also comes a with slightly more tolerant behavior when importing data from Excel spreadsheets.

What do reCAPTCHA, Akismet and Lokad have in common?

Well, they are all application blocks leveraging their respective communities to better fulfill their goals.

At Lokad, we believe (like many others actually) that the future of enterprise software, such as ERP or CRM, will rely on Service-oriented Architecture (SOA is short) where each component of the system is largely decoupled from the other components, and eventually provided by independent software vendors.

Considering our initial question, let's note that

• Akismet collects blog comments from a crowd of blogs in order to better filter out the blog spam.
• reCAPTCHA (*) provides an anti-botnet filtering system to distinguish real human users from machines on the web.
• Lokad collects demand data from a crowd of companies in order to improve the overall forecast accuracy.

A modular approach gives much more flexibility to the enterprise to design an IT system that really fit its needs (rather than the other way around). Modularity also reduces the risks of being dragged down because one piece of system is completely obsolete due to lack of investment of one particular software vendor.

Yet another type of benefits brought by specialized actors (think Akismet for blog spam filtering) is that it suddenly becomes possible to leverage the community to deliver smarter behaviors: Akismet is using the information obtained on each blog to improve its spam filtering on all the other blogs.

Today, it seems like that the first wave of crowd-enabled enterprise components was mostly oriented toward security tasks. The raise of security standards such as OpenId are likely to push even further this componentization of security blocks within enterprise software.

Yet, we believe that the second wave of crowd-enabled components will be oriented toward business analytics, ranging from intellectual property management, customer behavior analysis to operations research. Obviously, we want Lokad to be a leading player in this second wave. :-)

(*) Due to a botnet attack on our forums last week, we have upgraded the forum captcha toward reCAPTCHA. The amount of non-human registrations has dropped from hundreds per day to zero.

We are often asked is if Lokad supports seasonality in its forecasting technology. Indeed, neither our add-ons nor the web application provide settings for seasonality.

Our answer to this question is twofold: yes, Lokad handles seasonality but no, there is no settings to tweak seasonality.

Indeed, seasonality or rather seasonalities - because beside yearly patterns, weekly and daily patterns should be taken into account as well - are natively handled by Lokad.

Thus, there is no need to tell Lokad about it because such types of frequent patterns are always explored and evaluated, and eventually rejected if data do not exhibit the seasonal patterns.

Our goal is to provide best possible forecasts right out of the box, batteries included, and not asking users to partially address forecasting questions for us.

The video produced by Kirix about Lokad was a great source of inspiration for us. We realized that videos were a pretty efficient way to communicate on software. Thus, we decided to produce a couple of video tutorials for Lokad.

Our first tutorial is about Lokad Safety Stock Calculator. Check out how to start optimizing your inventory with Lokad within minutes.

(English subtitles are available, just click the CC button)

In this video, you will learn how get started with Lokad Safety Stock Calculator, how to import your sales data and how to generate your first report. We will also explain how the report works and what are the key figures to look at.

You can also download the Windows Media Player file of the video. Special thanks to Rex Teodosio for helping us producing this video.

Thanks to the contribution of Toby Champion, we have updated our forecasting tutorial for PHP5. Indeed, PHP5 now natively supports SOAP web services (the standard used by Lokad). The old PHP4 tutorial based on NuSoap remains available.

Lokad Safety Stock Calculator v1.6 has been released. This version includes a couple of important bugfixes. In particular, this version should be more reliable on large datasets. We have improved the handling of network timeouts. An issue has also been fixed with reorder points that were incorrectly set to zero in specific situations.

Concerning the improvements, the version 1.6 automatically saves the report at the start and at the end of the full refresh process. Thus, if Windows gets restarted (say because of an automated security update), the newly refreshed report does not get lost in the process.

We have also fixed a bug in the Check for Updates operation. The auto-update operation was failing if the MSI file had been renamed before launching the installation. If the auto-update fails, then just uninstall and reinstall.

Lately a couple of customers have been asking whether Lokad was keeping track of its past forecast errors in order to improve its future forecasts.

The answer is simple: yes, we do, but there are more than that. In particular, we do not wait for

• the forecasts to be requested,
• the course of events to happen,
• the historical data to be updated,

to finally compare our past forecasts with what really happened. Indeed, such an approach would be way too slow and inefficient.

Instead, we are using cross-validation methods adapted for the purpose of time-series forecasting.The process is more simple than it sounds, let's start with an example.

Let assume that we have a single time-series worth 1 year of weekly sales data (i.e 52 points). We want to produce 4-weeks sales forecasts - but we also want to estimate the forecasting error.

• take the N first points (with N = 10 initially).
• create a forecasting model based on those N points.
• create a 4-weeks ahead forecast based on this model.
• compare the forecast with the complete series.
• increment N of 1 point (i.e. 1 week).
• repeat.

With cross-validation, we can accurately estimate the expected forecast error of a forecasting model. In particular, if you have two different models, cross-validation can help you choosing the best one (*). Cross-validation can also be used to adjust model parameters - in order to find the parameters that best fit the data.

The Lokad team continuously monitors accuracy on delivered forecasts with such cross-validation methods and keeps working on more accurate forecasting models. Thus, we do keep track of our forecast errors, but without waiting for them to happen.

(*) If you try too many models, then you are likely to end-up with overfitting issues, but this problem is beyond the scope of this post.

Forecasting is important for many industries, but it is critical for the call center industry. Indeed. too much staff and the expenses get out of control. Too few staff and your customers are driven nuts by the long waiting queues.

Call Center Calculator (L3C) is a windows reporting application targeting call center managers to help them optimizing their call centers. The two main features of L3C are call volume forecasts (through Lokad) and staff level optimization (through Erlang C).

In this V1, L3C does not natively support yet many 3^rd party applications for call activity logs retrieval. Yet, we provide an Excel import format (because many call center applications support exporting data toward Excel) and a dedicated SQL query editor if you want to directly import data from a database.

The V1 does not handle events (typically marketing events), yet it is possible to manually tweak the staff level suggestions. This feature will be considered for later versions.

Don't hesitate to tell us what you think, what would be the most needed features and/or the most important 3^rd party applications that we need to support. We do our best to address all customer requests.

Lokad Safety Stock Calculator v1.5 has been released. This version now bring sales forecasting to Sage Line 50, a very popular accounting package in the UK. Also, thanks to Crimzone folks, ADempiere under PostgreSQL is now supported as well.

Then, the version 1.5 comes with several small improvements in case of inconsistent input data. Granted, when data is imported from an ERP, stock levels are usually numbers, but we did found out it can be otherwise in some situations.

Indeed, when data is imported from an Excel spreadsheet there is a lot of room for small data errors. In such a situations, the previous version of LSSC was just failing at importing the data. The version 1.5 should be more tolerant when small errors are encountered.

Reminder: You can update through Help » Check for Updates within LSSC.

We have just published public phone numbers for USA and France. Granted, telephone isn't new or even high-tech and there was actually no good reason for Lokad not to support customer phone calls right from the start. Yet, better late than never.

We are currently relying on a small call center setup based on Skype and PrettyMay. It might not be suited for large companies, but if you don't to need to handle more than 30 concurrent calls, then this is definitely a nice solution.

Both ADempiere and Compiere are now supported by our Safety Stock Calculator v1.4. Special thanks to the folks of Crimzone for making this possible.

Since this is the second release in less than a week, we have added a Check for Updates feature to LSSC. Now, upgrading the application should not require more efforts than a few clicks.

In this v1.4 release, we have also added a dedicated connector for QuickBooks Canada Multicurrency, which does not behave like the regular US editions of QuickBooks.

Lokad Safety Stock Calculator v1.3 has been released. This new version fixes many subtle, yet annoying, defects of the previous versions.

Those fixes are based on questions sent to the Lokad support. Following the two ways fix approach, we do our best, first to address customer questions, and second the fix the underlying issues which caused questions to be raised in the first place.

Among the various improvements, it is now possible to

• to cancel an operation in progress.
• to minimize the application to the system tray when waiting for the forecasts.
• to clear a report (i.e. erasing all existing data while keeping the settings).
• to import data from Excel (check the tutorial).
• to browse for the right file when the connection string is a file path.

Plus, we have improved a couple of error messages and behaviors to make them less obscure to those who did not happen to actually design the application.

Data analytics is an ubiquitous challenge. Whenever there is business, there are data - and wherever data are, Kirix Strata is going to bring them to you.

But Kirix Strata can do much more than that. At Lokad, we have been quite impressed by the amount things that were easy to achieve with Kirix Strata even when the product was still in beta. Now that Kirix Strata is completely ready for production, it's even better.

Ever felt the need to organize your business data for strategic thinking? but never done it because it was just too complicated. If so, Kirix is definitively a solution for you.

Yet, one minor feature was lacking from Kirix Strata though: forecasting. We are very proud to announce that Lokad has become the first Strata extension that takes advantage of Strata’s web scripting capabilities in order to bring advanced forecasting to this great product.

The Kirix team has just released an excellent video that demonstrates how Strata/Lokad works. Enjoy the show!

(And here’s an embeddable YouTube version)

Since the launch of the Developer's corner, I have noticed that Lokad was lacking some high level documentation that would rather address Why? questions as opposed addressing How to? questions.

Thus, I have summarized in the newly published Programmer's guide for the Time Series API a couple of answers to the questions that get frequently asked by our partners. If anything is missing, just ask.

Lokad delivers an advance forecasting technology, but for those who may just needing simple stuff, we have published a short guide about forecasting in Excel.

It is meant to be as simple as possible, and show what can be done with Excel in terms of forecasting - using linear regression or exponential fitting, through trendlines or the excel analysis toolpack (ATP).

It should allow small businesses, retailers or manufacturers, to easily perform a basic forecast of sales and demand.

It also gives useful advices about how to optimally use Excel, use comments and name your files and worksheets.