The tiered formula is useful when you have products that have a maximum capacity, such as:
vans
guides
minibuses
boats
rooms
or any other product whose quantity depends on a threshold of participants.
1. The formula to use:
To automatically adjust a quantity according to a capacity/tier, use the following formula: [number of people / product capacity]
number of people = p or P
product capacity = in numbers
ℹ️ Don't forget the square brackets [] in your formula, this is what allows you to round up to the next whole number.
Thus:
[p/4]with p = 5 will give 2...while
p/4will give 1.25!
💡 On Mac, you can use the following shortcut: Alt + Shift + ()
Tiered quantities are based on the same principles as automatic quantities. To learn more, consult our dedicated article ✍️ Automate your default quantity
Example: a van for 4 people
If you need a van for 4 people, you can define the quantity with the following formula: [p/4]
Here:
p corresponds to the number of people in the step
4 corresponds to the van's capacity
Number of people | Formula | Calculated quantity |
4 people | [p/4] | 1 van |
5 people | [p/4] | 2 vans |
8 people | [p/4] | 2 vans |
9 people | [p/4] | 3 vans |
Another example: 1 guide for 20 people
You have a guide for 20 people, at the price of €200. If your project includes 35 people, you will need 2 guides.
The formula to use to automate this calculation is therefore: [p/20]
Number of people | Formula | Calculated quantity | Total price | Price per person |
20 people | [p/20] | 1 guide | €200 | €10 |
21 people | [p/20] | 2 guides | €400 | €19.05 |
35 people | [p/20] | 2 guides | €400 | €11.43 |
40 people | [p/20] | 2 guides | €400 | €10 |
41 people | [p/20] | 3 guides | €600 | €14.63 |
2. Define the number of people: by project or step?
Variable | Meaning |
P | Number of people in the project |
p | Number of people in the step |
When you create a new step, by default the number of people is P, which is equivalent to the number of people in the project (so p = P).
Nevertheless, there are cases where p can differ from P (see example below).
💡 We recommend prioritizing p if you want the number of people in the step to take precedence over the number of people in the project.
Example: a van for 4 people
In my project, I have a family of 7 people (so P = 7).
On day 2, I have a step that involves a trip to the zoo. Only some of the travelers will participate in this activity, let's say 4 people (so p = 4).
I want to book a van for these 4 people as part of this trip.
The formula to use is [p/4] = 4/4 = 1 van.
If I had used the formula [P/4], the calculated quantity would have been 2 vans.