...
You place nodes on the tree using two values: the name of the node, and the name of the node's parent. This is the only relationship that matters when you're building your spreadsheet. For example, you can place the Labrador node with by knowing only "Labrador" (it's name) and "Dog" (it's parent). Remember, any node on the tree can be a parent.
A 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 spreadsheet represents a node on the tree.
Column 1 | Column 2 | Column 3 | Column 4 | |
---|---|---|---|---|
Data Type | plain text | plain text | plain text | number |
Contents | The name of the node. Each node must have a unique name.word "node" Note:
| The name of the node's parent. Note:
| The name of the node | The number of branches that extend from the node
|
For the sample tree above, the spreadsheet might look like this:
Parent | Node | ParentBranches | |
---|---|---|---|
node | root | Pet | 3 |
node | Pet | Cat | 2 |
node | Pet | Dog | 3 |
node | Pet | Rabbit | 0 |
node | PetCat | Domestic Shorthair | 0 |
node | Cat | Siamese | 0 |
node | CatDog | Corgi | 0 |
node | Dog | Great Dane | 0 |
node | Dog | Labrador | Dog0 |