On the three newest rows of Robbie's own copy the calculation is split across two columns: Commission Owed holds the commissionable origination less the $150 file fee, and Commission Paid holds that times 25% - 2314 N Jecker St, 829 W 9th St, 6722 Ave E. The amounts come out right, and the Paid Date cell on the last of the three holds their total rather than a date. Is that the intended shape going forward, or should Commission Owed hold the commission as it does on every row above?
This is not a shortage and nobody is overpaid. Our reader takes the commission from Commission Owed, which is where every row above it holds one, so on these three rows it reads the base and reports a difference against the engine that is not money. Mike said on 21 October that he is folding Robbie's last three loans into his own sheet, which is when the shape of these rows starts to matter. Worth knowing alongside it: Commission Owed is a typed constant on rows 25 to 33, so nothing recomputes those 9.