Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

branch is a connection between two nodes. For example, there are two branches that extend from "Cat," and three that extend from "Pet."

Each row in the Organization Chart the Tree spreadsheet represents a node on the tree. 

 

 Column 1Column 2Column 3Column 4
Data Typeplain textplain textplain textnumber
Contents

The word "node"

Note:

  • Enter the word "node" in the first cell for every row

The name of the node's parent

Note:

  • If this is the first node on the tree (called the root), write "root" in the cell
  • Keep node names consistent across the spreadsheet
The name of the node

The number of branches that extend from the node

  • In the example above, Column 4 for the "Cat" node would be 2.

 

 

For the sample tree above, the spreadsheet might look like this: 

 ParentNodeBranches
noderootPet3

node

PetCat2
nodePetDog3
nodePetRabbit0
nodeCatDomestic Shorthair0
nodeCatSiamese0
nodeDogCorgi0
nodeDogGreat Dane0
nodeDogLabrador0