Saturday, October 7, 2017

Saturday Software: OED Monster Database v.2

Linked below is an updated version of the OED Monster Database (ODS open document spreadsheet). A few people observed trouble dealing with the first version a weeks ago, especially on systems different from mine, in terms of the formulas present in a few of the columns. So the rather minor changes are:
  • Took out all of the formulas on the 1st sheet and replaced them with fixed values; and clarified column N with the label "Table" (it's meant to indicate the recommend Wandering Monster Level Table).
  • On the 2nd sheet of stat blocks, converted the CONCAT function to the more traditional CONCATENATE.
  • Added a 3rd sheet explication of the conversion in use of EHD to Monster Table (for use with VLOOKUP in any future additions).
While I personally created this in LibreOffice Calc 5, this version was tested and found to work in both Microsoft Excel 2010 and 2013 (in the former, after a file validation and repair operation), including the computed stat blocks on the 2nd sheet. Tell me if you still have notable problems with this version!



4 comments:

  1. works fine in excel 2015. thanks for the update!

    ReplyDelete
  2. It seems to work just fine using Google Sheets on my Android phone.

    ReplyDelete