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)).
crackxls2003 breaks the encryption on Microsoft Excel and Word 97/2000/XP/2002/2003 files which have been encrypted using the RC4 method. These files are encrypted using a 40-bit-long key. It will not work on files encrypted using versions later than 2007 or versions 95 or earlier, or if a non-default encryption method was used.
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.