#Historical Battle Statistics Value Q1: Locations

4 messages · Page 1 of 1 (latest)

pliant shore
#

Link to Sample Google Sheets: https://docs.google.com/spreadsheets/d/1qyv9sLpecnQyQAoIsnoIST3tnW6XJYsioB-GbgrxyMs/edit?usp=sharing

Objective: Develop a prompt to gain information on various Location Aspects of a Historical Battle.

  1. Develop Prompt
  2. Plug prompt into google sheets
  3. Confirm Accuracy through random testing.
  4. Optional: Develop a list of states that existed during particular years for the AI to choose from.

Information Currently Obtained (1000s of rows)
Battle Name: (Example: Battle of Cannae)
Battle Year: (Example 216 BC)
Battle War: (Example: Second Punic War)

Information Currently Requested

Location: Origin: The State that existed and controlled the land at the time of the battle.
Location: Modern: The State that Exists and controls the land on which the battle was fought.
Location: Region: The Region the Modern State exists in according to the United Nations Geo scheme.

Example for the Battle of Cannae
Input: Name: Cannae
Input: Year: 216 BC
Input: War: Second Punic War
AI Output: Location Origin: Roman Republic
AI Output: Location Modern: Italy
AI Output: Location Region: Southern Europe
celest bough
#

Hi, can you give me more details on how to make chatgpt work in google sheet directly and fill data