extract data from one spread sheet into another
Ryans Electronic Diary Sheet 1.2.1
Ryans Electronic Diary Sheet allows members of an organization to inform each other of their proposed whereabouts. more>>
Like its sister application Ryans In/Out Board it was written to fulfil a need at my employer Contact a Family. Staff needed a simple centralised way to let each other know when they would be out of the office rather than get into the complexities of sharing calendars.
The diary sheet works on a week by week basis and stores its data accordingly. A shell script (bacth file) is supplied which (when run as a scheduled event/cron job) will clear out data older that your chosen limit. Thus data storage is kept to a minimum. The diary sheet itself also has a feature will prevent users from going too far forward or backward.
Main features:
- Simple to use and administer
- Week to a screen view
- Users can be grouped into (colour coded) departments - current users department shown at top
- User aliases permit users to have friendly names on the diary sheet whilst logging in with more secure names 1
- No database required - uses simple text files for storage
- Tidies up after itself - deletes old storage files 2.
- No client application required - save for a web browser
- Easily configurable styles - all through the config file no HTML/CSS skills required.
- Allows additional comments/notes to be linked from the main diary sheet view
- Cross platform - runs on any browser and a range of server OSs.
- W3C compliant and fully accessible HTML output
- Suitable for small-medium installations (< 100 users)
Video Contact Sheet *NIX 1.0.9a
Video Contact Sheet *NIX is a script that creates a contact sheet (preview) from videos by taking still captures of the video. more>>
The output image contains useful information on the video such as codecs, file size, screen size, frame rate, and length.
Notes:
Using -i or -n with values that lead to the same number of vidcaps doesnt necessarily yield exactly the same vidcaps, youll have to play with them for best results.
Example: With a video that lasts for 22min 14secs, -n 6 will create the six vidcaps:
3:22, 6:44, 10:04, 13:28, 16:50 and 20:12, while -i 3m will create
3:00, 6:00, 9:00, 12:00, 15:00 and 18:00.
As you can see, -n distributes the vidcaps all over the video while -i N starts at N and goes in increments of it up to the end.
You can set the aspect ratio of the video with -a. It is only required for anamorphic material and discouraged for the rest.
It can take either a floating point number (like 1.33 or 1.778) or a fraction (like 4/3 or 16/9). The latter is slightly preferable.
Online Contact Sheet Creator 2.5
Online Contact Sheet Creator is an online tool that generates stylish contact sheets without any fussing around in Photoshop. more>>
You can use the script to generate contact sheets for clients (great for photographers or graphic designers), or you can use it personally for a small photo album.
You can also add Online Contact Sheet Creator to your web site to add some functionality for your visitors.
Main features:
- Online Contact Sheet Creator is easy to install, just a few simple steps and youre done!
- You select the number of images a visitor can upload for their sheet.
- A temporary file system insures that you wont max out your web hosts file size limits.
- The contact sheets look clean and professional, with each photo numbered for easy reference.
Data::SpreadPagination 0.1.2
Data::SpreadPagination is a Perl module for page numbering and spread pagination. more>>
SYNOPSIS
use Data::SpreadPagination;
my $pageInfo = Data::SpreadPagination->new({
totalEntries => $totalEntries,
entriesPerPage => $entriesPerPage,
# Optional, will use defaults otherwise.
# only 1 of currentPage / startEntry can be provided.
currentPage => $currentPage,
startEntry => $startEntry,
maxPages => $maxPages,
});
# General page information
print " First page: ", $pageInfo->first_page, "n";
print " Last page: ", $pageInfo->last_page, "n";
print " Next page: ", $pageInfo->next_page, "n";
print " Previous page: ", $pageInfo->previous_page, "n";
# Results on current page
print "First entry on page: ", $pageInfo->first, "n";
print " Last entry on page: ", $pageInfo->last, "n";
# Page range information
my $pageRanges = $pageInfo->page_ranges;
# Print out the page spread
foreach my $page ($pageInfo->pages_in_spread()) {
if (!defined $page) {
print "... ";
} elsif ($page == $pageInfo->current_page) {
print "$page ";
} else {
print "$page ";
}
}
The object produced by Data::SpreadPagination can be used to create a spread pagination navigator. It inherits from Data::Page, and has access to all of the methods from this object.
In addition, it also provides methods for creating a pagination spread, to allow for keeping the number of pagenumbers displayed within a sensible limit, but at the same time allowing easy navigation.
The object can easily be passed to a templating system such as Template Toolkit or be used within a script.
Attendance sheet 1.0 Beta
Attendance sheet is a simple script that will help you keep track of registrations for arbitrary sports activities. more>>
The idea came from the problem our small group of amateur volleyball at our University faced. At the beginning the number of players was quite small and since many times we did not know each other well, we often ended up coming in 2 or 3 people.
Attendance-sheet helps to:
- see registered players who is coming and who is not
- make registered players to know each other better (if they are from different faculty or whatever), supported by photo, fullname, icq # and faculty
Extract archive 1.11
Extract archive is a service menu that allows you to extract any archive file that ark is capable to read + ACE files. more>>
You can chose to extract here, or in a subdirectory. In that case, it asks you the name of the subdirectory where you want to extract, and suggests you the archive name by default.
To install, simply extract, and move the 2 files in ~/.kde/share/apps/konqueror/servicemenus
Its highly recommended to download the latest version of unace on www.winace.com and to run this command line in the unace directory location : sudo cp unace /usr/bin/unace
You should desactivate ark integration into kde by going into the configuration menu of ark.
If you want translation to be added, post me comments.
Enhancements:
- thanks to shirka, extract archive path is now "test" for an "test.tar.bz2" file
- Name that appears in the menu is now "Extract archive" as suggested by dovidhalevi to differentiate with ark
Style Sheet Chooser 0.2
Style Sheet Chooser is an extension which allows you to choose author-provided alternate style. more>>
Style Sheet Chooser 0.2 allows you to choose author-provided alternate style sheets for a web site, and have those choices be persisted for all pages on the same site.
Style Sheet Chooser 0.2 does NOT interact with Firefoxs built-in style sheet switcher -- its functionality is instead available via the [View]->[Style Sheet Chooser 0.2] menu item.
mod-log-spread2 0.0beta1
mod-log-spread2 is an Apache 2.x module for logging into spread framework. more>>
mod-log-spread2 doesnt support fallback hosts, and virtual host groups.
Spreadsheet Calculator (SCalc) for UNIX 1.0
SCalc is a simple spread sheet program. The user interface applies the UNIX curses library for control of a terminal screen in text mode. more>>
SCalc is a simple spread sheet program. The user interface applies the
UNIX curses library for control of a terminal screen in text mode.
This program was developed using the GNU C++ compiler and related tools.
Limitations in SCalc
-- The screen does not scroll. The entire spread sheet is the size of
the terminal screen with five columns, A to E, and nine rows 1 to 9.
-- Numbers are double precision floating point and are displayed in
scientific format or in floating point format.
-- Column widths will are fixed at 14 spaces. Text that exceeds the column
width is clipped in the cell view. Numerical data in scientific
format should always fit this space.
-- The user cannot copy from cells to other cells, insert or delete lines
or columns, of change cell widths.
Some features of SCalc
-- Built in mathematical functions abs, cos, ln, exp, ...
-- Features for saving and loading spread sheets to and from disk
-- Capability to clear spread sheets
-- Features for automatically or manually re-calculate cell values
Requirements: UNIX w/ gnu compiler
Whats new in this version: New release
<<lesslibextractor 0.5.18a
libextractor is a library used to extract meta-data from files of arbitrary type. more>>
The goal is to provide developers of file-sharing networks or WWW-indexing bots with a universal library to obtain simple keywords to match against queries. libextractor contains a shell-command "extract" that, similar to the well-known "file" command, can extract meta-data from a file an print the results to stdout.
Currently, libextractor supports the following formats: HTML, PDF, PS, OLE2 (DOC, XLS, PPT), OpenOffice (sxw), StarOffice (sdw), DVI, MAN, MP3 (ID3v1 and ID3v2), OGG, WAV, JPEG, GIF, PNG, TIFF, DEB, RPM, TAR(.GZ), ZIP, ELF, REAL, RIFF (AVI), MPEG, QT and ASF.
Also, various additional MIME types are detected.
libextractor is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
Enhancements:
- This release fixes various build problems and a crash with recent versions of libgsf.
vAn incomplete manual was added.
JavaPK for Desktop 2.5
JavaPK for Desktop (JPKD) is a Clinical Pharmacokinetic (CPK) Services (or Therapeutic Drug Monitoring, TDM). more>>
It not only inherits all functionalities of JavaPK for Mobile Devices, but also has a built- in algorithm of users defined Bayesian model for individualized pharmacokinetic parameter estimation (UDBM) for batch input data.
Users can define their own pharmacokinetic prediction models with population PK parameters and then use the defined model to solve batch prediction data or applied the defined model to therapeutic drug monitoring (TDM).
JPKD is created for your own personal uses and testing purposes. JPKD shall be used as a guide or a decision support tool only. Medical decisions should NOT be solely based on the results of this program. Although this program has been tested thoroughly, the accuracy of the information cannot be guaranteed. Once you use JPKD, you have automatically agreed with this disclaimer.
Main features:
- Sawchuk-Zaske (aminoglycosides & vancomycin) and Bayesian method for PK parameter estimation
- 15 built-in drugs for TDM (see the below drug lists)
- functions for users defined Bayesian estimation drug models
- portable function for users defined models
- a built-in spread sheet for batch PK parameter estimation & input data manipulation
- application user-defined Bayesian model to TDM
- multiple desktop platforms (WinXP/NT, Mac OS X, Linux PC) supported
Built-in drug lists
- Amikacin
- Carbamazepine
- Cyclosporin
- Digoxin
- Enfuvirtide
- Everolimus
- Gentamicin
- Indinavir
- Lithium
- Phenytoin
- Ritonavir
- Tacrolimus
- Theophylline
- Tobramycin
- Vancomycin
Obscure-Extractor-GTK 0.2
Obscure-Extractor-GTK can extract data from simple and unusual archives as used by games. more>>
Mostly a framework where I can easily add new modules when I want to have a look at the inner workings of games, though the Delphi version has some more advanced stuff like support for old InstallShield archives that would need to be ported.
The layer extract plug-in
The layer extract plug-in is a Gimp plug-in that creates a new image/film by periodically extracting layers from another image. more>>
It takes one interval (number of sequent layers) every period. The number of periods can be limited.
"< Image >/Filters/Animation/Layer Extract"
VCG TriMeshInfo 1.2
VCG TriMeshInfo is a tool designed to inspect 3D models and retrieve many types of topological and geometrical information. more>>
It can be used to automate the process of decoding 3D mesh inherent properties and ease data classification and retrieval.
For each analyzed dataset, the following data are extracted:
- Number of Vertices (Unreferenced vertices are listed separately)
- Number of Faces
- Number of Edges
- Number of Connected Components
- Number of Boundaries
- Number of Isolated Vertices (i.e. Unreferenced)
- Manifold
- Genus (Computed only for Manifold Datasets)
- Orientability
- Orientation
- Regularity (We consider as regular those meshes generated through regular subdivision. Each non boundary vertex of a regular mesh has 6 incident edges, if there are only 5 incident edges the mesh is said to be semi-regular, irregular in all other cases)
- Number of Duplicated Vertices
- Self-Intersection (Currently computed only for Datasets with less than 3M faces)
Enhancements:
- This release included a major rewrite of the core component for computing geometrical and topological features of the analyzed mesh.
- Important changes included speeded up self-intersection tests, more robust (and correct) computation of topological genus and volume, and more flexible output with an HTML output option.
Construction Management Software 1.35d
Construction Management Software is a solution for builders and construction groups to manage construction projects. more>>
Construction Management Software lets your clients stay up to date on their projects online. You can create a project, add tasks and clients, log in and can place comments on each task, and view estimated completion dates and the status of each task.
You can export a project to a spread sheet for reporting or to create a status report to take to the job site.
Enhancements:
- This release included some updates to the quick start tutorial for the system.