Split summary spreadsheet into multiple sheets

uga-libraries / format-report

Aggregate and analyze csv files with file format information generated by the UGA Libraries' digital preservation system (ARCHive).

Creative Commons Attribution Share Alike 4.0 International

0 stars 0 forks source link

Split summary spreadsheet into multiple sheets #15

Closed amhanson9 closed 1 year ago

amhanson9 commented 1 year ago

The current script output has a lot of tabs, making it difficult to see what information is there without a lot of scrolling back and forth. Split into spreadsheets by purpose or data being summarized.

amhanson9 commented 1 year ago

Could also make a separate script for each report type (commonness, group overlap, department reports). The main benefit would be to organize the code more clearly and make it easier to find what I want to update. Generally do want all the reports at once, but could sometimes just want a department report. // Decided to make the department report a separate script, but one script to do all of the spreadsheets that analyze ARCHive as a whole to be able to generate them at once.

amhanson9 commented 1 year ago

Divisions:

Frequency has Group Overview, Format Types, Format Names, and Format ID
Group Overlap has Groups per Type, Groups per Name, and Groups per Format ID
Ranges has Format Name Ranges, Format Name Sizes, Format ID Ranges, and Format ID Sizes