Difference between revisions of "Users Guide to SOLM-2024 database"
m (→Conceptual structure) |
|||
Line 18: | Line 18: | ||
- Primary dimension is formed by the personal depositions of people | - Primary dimension is formed by the personal depositions of people | ||
− | - Secondary | + | - 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 | - Each of the primary dimensions is characterized in multiple ways, which can be grouped into sub-categores |
Revision as of 10:26, April 9, 2024
[TOC]
This is the start of the Users Guide to the SOLM-2024 databsae
Contents
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