Microsoft Excel logic
Excel provides the controlled calculation and decision layer for agreement variations.
Dulwich College used iSAMS, Microsoft Excel and Microsoft 365 to support student agreements, staff-child variations and commercial approvals across a large school group.
Admissions agreements varied for staff children and other fee structures, while commercial documents such as NDAs and service agreements required a different set of review and approval rules.
Select the right admissions terms for staff-child and standard agreements.
Collect missing parent data without returning to disconnected forms.
Route commercial agreements through legal and finance before signature.
Structured Excel data and logic determine the correct document path, iSAMS provides admissions context, and Zegal governs data requests, approvals, generation and signing across both workflow families.
Excel provides the controlled calculation and decision layer for agreement variations.
Student data can populate admissions agreements from the school’s source system.
Missing information is collected inside the agreement journey.
NDAs and service agreements route to the relevant reviewers before signature.
Dulwich established one governed layer for distinct admissions and commercial workflows while keeping the Microsoft and iSAMS environment its teams already used.
We have truly, finally gone digital! I’m looking forward to seeing this rolled out in HR and procurement teams too.
Start with the systems, decisions and handoffs around it. We'll map the governed process and the evidence your teams need.