SunRiseSet is a ruby class calculates the times of the sunrise, solar noon and sunset. It also calculates astronomical, naval and civil twilight times. Not sure of the origin of the algorithm. I have seen a fortran version http://www.srrb.noaa.gov/highlights/sunrise/program.txt a .pl www.mso.anu.edu.au/~brian/grbs/astrosubs.pl and .vb versions for spreadsheets too. All had the same comments, so are of a common origin.

A Ruby tool to handle import spreadsheets into AllPlayers API.

A gem to export spreadsheet files data into JSON

Bulk search via spreadsheet.

Read and write Google Spreadsheets like records

copy and paste between ruby arrays in irb/rails console and a spreadsheet (tab delimited) and vise versa. Based on irbcp by Ara T. Howard

A gem to generate xls documents by using rxls templates.

Rusk is library that read and write Open Document Spreadsheet Format(ods).

A spreadsheet generator (ODS, XLS) and parsing tool. Uses Roo as a backend and attempts to implement newer features on top of it.

Convert Excel or Spreadsheet to Ruby hash

Simplify the task of building a spreadsheet in Rails. This gem is based on the Spreadsheet gem. The syntax have been simplified a bit.

Generate HTML tables which popular spreadsheet software packages know how to read

Pulls a Google Spreadsheet into a CSV

Parses spreadsheets, validates its data against ActiveRecord model and instanciates valid data

Zz structures are an interesting way of representing relations invented by Ted Nelson, whose domain model I provide in a gem Yzz. In this gem, YNelson, I combine Yzz with the universal Petri net provided by YPetri (another gem I wrote) to obtain a hybrid data structure that formalizes and generelizes a spreadsheet. Because let us note spreadsheets (as I have seen them) can be considered Petri nets of a kind, with cell functions acting as Petri net transitions. At the same time, spreadsheets are globally orthogonal structures with 3 typical dimensions (rows, columns and sheets). By using zz structures, the globally orthogonal spreadsheet is generalized as a locally orthogonal zz structure, with relations represented as zz dimensions, thus generalizing and formalizing a spreadsheet. The catch is that I have not yet finished the thinking process regarding what everything should be a zz object: Places (cells) and transitions definitely yes, but how about nets and dimensions? Should YNelson go as far as making namespaces into zz objects? The reason why these questions are hard to answer is because Ted Nelson himself, while providing interfaces guidelines (zz structure views, cursors...) did not comment on these questions. While being a (textual) DSL, YNelson aims to provide convenience on par with actual spreadsheet apps. Unlike YPetri, YNelson also aims to be able to specify more than one Petri net node per command, but this is still under development. See the user guide and the documentation for the details. YNelson documentation is available online, but due to formatting issues, you may prefer to generate the documentation on your own by running rdoc in the gem directory. For an example of how YPetri can be used to model complex dynamical systems, see the eukaryotic cell cycle model which I released as "cell_cycle" gem.

Assign random pairs from a google docs spreadsheet

A tool for loading spreadsheet data into ruby objects

Use spreadsheet views in Rails 3

Provides a command line and API interface to extract data from ods spreadsheets.

Convert vocabularies created in a spreadsheet template to SKOS.