Difference between revisions of "Users Guide to SOLM-2024 database"

Revision as of 10:29, April 9, 2024

This is the start of the Users Guide to the SOLM-2024 database

Overview of the database

- Technology: Excel Workbook
- Size: 22 MB
- Dimensions: 23,715 rows; 320 columns
- Sheets: One
- Conceptual structure: Flat semi-structured database
- Author: Colin Greenstreet
- Date started: 2017
- Latest version: SOLM-2024 Ver.13.2 08/04/2024

Conceptual structure

- Primary dimension is formed by the personal depositions of people

- Secondary dimension is formed by the named ships with which most of the personal depositions of people are associated

- Each of the primary dimensions is characterized in multiple ways, which can be grouped into sub-categores

e.g. The dimension of people has the following sub-dimensions, some of which are textual and some of which are numerical

People

PEOPLE: BASICS
-- Name [Forname; Surname]
-- Age [Years; Estimated birth year]

PEOPLE: GEOGRAPHY
-- Current residence [Street/Hamlet; Parish; Town; County/Province]
-- Current state [e.g. England; e,g. France]

PEOPLE: GEOGRAPHY ADVANCED
-- Place of birth [Parish; county; Province; State]
-- Length of time in current residence [Years; textual comment]

Ships

SHIPS: BASICS
-- Name of ship
-- Place of affiliation of ship [e.g. the Seaventure of Yarmouth]
-- Name of master of ship

SHIPS: VOYAGES
-- Extent of voyage knowledge [None; Partal; Full]
-- Voyage nodes [Named nodes in route order, if known]

SHIPS: PHYSICAL
-- Shp burthen [Tons]
-- Ship company size [including master and boys] [Number]
-- Ship ordnance [Guns]

SHIPS: PEOPLE
-- Name of master of ship
-- Ship company size [including master and boys] [Number]

Sorting the database

- Use of filters

- Use of sort buttons

- Use of F5 function

Practice exercises

Special requests

==Providing feedback