If you're unfamiliar with writing Excel formulas

If you are already somewhat familiar with Excel's formulas

🧑🏻‍🏫 Beginners’ guides

01. Start with a simple calculation

A step by step guide to build your first formula in Opera (6 mins)

https://share.synthesia.io/1b2a1f3d-57e3-42ff-b2e2-bba759b60dd4

02. Build cases for your control

Generate a change in setpoint value when a specific event occurs (4 mins)

https://share.synthesia.io/c457078d-5664-42f4-a2dc-6ffc9c617fea

03. AND and OR conditions

Generate a change in setpoint values when multiple events occur (5 mins)

https://share.synthesia.io/e0bcbaf5-d6d3-49d3-85fa-f26cc5626b03

We have covered the fundamental concepts of Opera formulas. You might want to delve deeper into enhancing your skills by exploring Calculation metrics. Should you encounter any errors during your coding endeavors, please consult our common error table or contact Koidra for support.