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.
ExportSpreadsheets is a class that can be used to create an Excel spreadsheet from data in a MySQL table. It performs a query to a given MySQL table and creates an Excel spreadsheet file using the PEAR Spreadsheet_Excel_Writer package. The class can export multiple worksheets to a single Excel file. Several parameters may be used to configure details like which table fields map to which spreadsheet columns, field sorting, etc.
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)).
Aspose.Cells for SharePoint is a flexible solution for converting Excel documents into multiple document formats within Microsoft SharePoint applications. It lets you easily convert documents right from the SharePoint document library into popular formats like XLS, XLSX, CSV, HTML, ODS, PDF, XML, and TXT without using MS Excel for document generation. It is designed to be used with Windows SharePoint Services 3.0 (WSS) and MS Office SharePoint Server 2007 (MOSS) standard and enterprise editions.
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.