.png%3Falt%3Dmedia%26token%3D9c406ae2-91f4-4844-841c-7ed5f5d9313b)
.png%3Falt%3Dmedia%26token%3D9c406ae2-91f4-4844-841c-7ed5f5d9313b)
Use groups and hierarchies
Francis includes three different hierarchies:
Rows, groups, and sections.
You can always drag n' drop rows/groups/sections to reorder your model, without any formulas breaking.
Rows work like regular rows in spreadsheets. You can create formulas that reference other rows and groups.
Groups are a way to organize rows and cannot be edited directly.Groups will always sum the values of the rows placed inside it, and will automatically update as you drag n' drop rows in and out of the group (no need to update your formulas!). 
Be wary of whether
rows are placed correctly into groups! Groups will only sum rows that are placed inside it.- If you create a
rowvia the button, therowis by default created at the bottom of thesectionat the highest hierarchy, i.e. outside anygroups - If you create a
rowvia agroup's menu option "add new row," the row is automatically placed inside thatgroup - If you create a
rowvia the shortcut ⌘+⌥+N, therowis automatically placed below your current cell selection and adjusted to the hierarchy of your current selection
Use
Sections to organize your model. Sections do not show any values and are purely for organizing purposes.You can always reference formulas across
sections. 