KeyValue is a cross-platform library for making C++ objects accessible through LibreOffice Calc, Excel, and other front-ends. This can enhance the experience of spreadsheet users by providing an object model and a handy key-value based interface. Actually, KeyValue does more than just help creating spreadsheet functions. The object model allows end-users to build C++ objects through the front-ends. These objects are stored in a repository for later use at the user's request. Additionally, KeyValue provides a set of services to effectively use these objects. The library is named after one of its main features: the key-value based interface. Parameters are passed to functions (or, more precisely, processors) through key-value pairs, in contrast to the standard positional interfaces of LibreOffice Calc, Excel, C/C++, etc.
SYMPLiK EXZELLENZ is a program to manipulate table data in Oracle database by using a Microsoft Excel file (xls or xlsx format). Unlike Oracle WebADI, More4Apps, or other Excel-driven solutions, this program does not use Office VBA (macros) to process the data. It is a pure Java solution incorporated with Apache POI and the Oracle JDBC driver to download, upload, insert, update, and delete data from Oracle database tables. It is Linux-friendly for Open Office users as long as the spreadsheet is in Excel formats.
jQuery Calx is powerful yet easy to use jQuery plugin for building calculation forms or calculation tables. It parses provided formulae and performs calculations, scans for form changes and updates results automatically, and formats plain numbers into currency format, ordinal numbers, etc. It is suitable for both simple ($A+$B) formulae and complex ones such as ($I*$P*((1 + $I)^$N)) / (1 - ((1 + $I)^$N)).
ShiftSchedule is a simple procedure, combining random and greedy strategies with heuristics to maximize the minimal interval between consecutive shifts with multiple constraints on the workload distribution. In particular, the distribution of duties among the staff must be uniform when a number of roles and a variety of shift types are considered. The number of persons available for every shift type and role must be large compared to the number required in each case. The method also implements a strategy to deal with the suboptimal results of the simple approach when some infrequent and aperiodic day types, such as long weekends, are considered.