Variables and References
Change one number and every line follows
Set a number once and let every line that depends on it follow. When the client cuts a shoot day or a rate changes, a Variable or an @ reference updates every field built on it, from the line up to the budget total.
These articles help producers keep day counts, rates and flat fees consistent across a large budget. They answer how to point one line at another, how to budget a day rate plus a delivery fee, how to carry Variables into next year's budget, and how to try a different rate in one scenario without touching the others.
Change one number everywhere
Put the day count in a Variable, point every dependent field at it with @, and one edit updates the whole budget.
Yes. Type @ in any numeric field to reference another line's Amount, Days, Fee or Total, or a Section total.
Put the day rate and the flat charge on two lines in the same Section, and the Section subtotal adds them together.
![](data:image/svg+xml,<svg display="block" role="presentation" viewBox="0 0 21 18" xmlns="http://www.w3.org/2000/svg"><g d="M 7.92 5.759 L 9.284 7.319 L 11.119 8.492 L 11.439 5.769 L 11.119 3.107 L 9.249 4.137 Z M 0 8.238 L 0 10.558 C 0 11.088 0.43 11.518 0.96 11.518 L 3.28 11.518 L 3.76 9.764 L 3.28 8.238 L 1.688 7.758 Z M 3.28 0 L 0 3.28 L 1.688 3.76 L 3.28 3.28 L 3.752 1.774 Z M 3.28 3.279 L 0 3.279 L 0 8.239 L 3.28 8.239 Z M 13.214 1.389 L 11.119 3.107 L 11.119 8.492 L 13.224 10.218 C 13.539 10.464 14 10.24 14 9.839 L 14 1.76 C 14 1.354 13.529 1.132 13.214 1.389 Z M 7.919 5.759 L 7.919 8.239 L 3.28 8.239 L 3.28 11.519 L 10.159 11.519 C 10.689 11.519 11.119 11.089 11.119 10.559 L 11.119 8.492 Z M 10.158 0 L 3.279 0 L 3.279 3.28 L 7.919 3.28 L 7.919 5.759 L 11.118 3.108 L 11.118 0.96 C 11.118 0.43 10.689 0 10.158 0 Z" fill="transparent" height="11.518707103302134px" id="msRfACIW_" transform="translate(2 3)" width="14.000000299020257px"><path d="M 0 2.652 L 1.365 4.212 L 3.2 5.385 L 3.52 2.662 L 3.2 0 L 1.329 1.03 Z" fill="rgb(0, 131, 45)" height="5.384981000453159px" id="SudOce0vk" transform="translate(7.92 3.107)" width="3.5195954251328203px"/><path d="M 0 0.48 L 0 2.8 C 0 3.33 0.43 3.76 0.96 3.76 L 3.28 3.76 L 3.76 2.006 L 3.28 0.48 L 1.688 0 Z" fill="rgb(0, 102, 218)" height="3.7595678404828874px" id="ptqOLp7eZ" transform="translate(0 7.758)" width="3.7595678404827595px"/><path d="M 3.28 0 L 0 3.28 L 1.688 3.76 L 3.28 3.28 L 3.752 1.774 Z" fill="rgb(233, 66, 53)" height="3.7595678404827595px" id="WJAuODGl2" width="3.7515687599711782px"/><path d="M 3.28 0 L 0 0 L 0 4.959 L 3.28 4.959 Z" fill="rgb(38, 132, 252)" height="4.959429917232605px" id="qovcPZtCe" transform="translate(0 3.279)" width="3.279623009782881px"/><path d="M 9.935 0.11 L 7.839 1.828 L 7.839 7.213 L 9.944 8.939 C 10.26 9.186 10.72 8.961 10.72 8.56 L 10.72 0.481 C 10.72 0.075 10.249 -0.147 9.935 0.11 Z M 4.639 4.48 L 4.639 6.96 L 0 6.96 L 0 10.24 L 6.879 10.24 C 7.41 10.24 7.839 9.81 7.839 9.28 L 7.839 7.213 Z" fill="rgb(0, 172, 71)" height="10.239776677658213px" id="N0Tu670pH" transform="translate(3.28 1.279)" width="10.72037917475268px"/><path d="M 6.879 0 L 0 0 L 0 3.28 L 4.639 3.28 L 4.639 5.759 L 7.839 3.108 L 7.839 0.96 C 7.839 0.43 7.41 0 6.879 0 Z" fill="rgb(255, 186, 0)" height="5.759337968399116px" id="DgEWgdbIb" transform="translate(3.279 0)" width="7.83909890143218px"/></g></svg>)