Data Issue

[waynegraham]

There is an issue in the data by an entry (S96 Wyoming State Archives) in the metadata creation levels that causes the calculation for level 1 metadata creation to be nearly seven times more than level two.

[waynegraham]

The data in the Descriptive metadata creation -Level 1-Percent of scans on which process was performed (i.e., "20"; do not use the % sign) is expected to be an integer (e.g. 3 for 3 percent) however, this Is a decimal (0.003) which appears to throw off the calculation in an unexpected way.

Two ways to resolve this:

1) Remove the data for the metadata 2) Contact the archives and get updated information

The first option is probably the simplest.

[waynegraham]

Google updated the API used to generate the JSON for this application, effectively removing API access to the sheet (https://github.com/clirdlf/digitization_cost_calculator/blob/gh-pages/lib/utilities.rb).

Unfortunately, resolving this data issue (which has been there for 5 years) will require a complete rewrite of the sheet processing engine.

• Roo can read an Excel sheet directly from a URL.
• Can probably read a CSV URL as well with net-http.