# Spreadsheets as Interoperability Solution for Business Process Representation
## 6 Evaluation
### Case Studies  
For the evaluation of our method, we present an example of the \"Bank account opening\" business process. Table 17 shows the spreadsheet describing the process. The corresponding diagram is presented in Figure 4.  
One can noticed that our approach supports fewer elements than such complex approaches as Branching or More Properties approaches. However, the other approaches support the elements in a straightforward way, requiring the deeper knowledge of business process elements, even in the case of such simple structures like gateways. Moreover, there are several points, in which our approach has the advantage over the existing approaches:  
* We do not use explicit notion of XOR/OR/AND gateways, thus the user does not have to think about the kind of flow branching. Instead, in our model it is modeled in the implicit way. * For describing the condition, we use the \"condition\" column, what is more clear than using the \"description\" field. * We do not use the notion of \"Successor\" as it does not always show clearly the flow in the spreadsheet representation. Thus, in our opinion, a well-known jump statement \"goto\" (one-way control flow transfer), existing in many computer programming languages, in this particular usage performs better, as it is clearly visible in the Activity field. \begin{table}
\begin{tabular}{c c c} \hline \hline
**Order** & **Activity** & **Condition** & **Who** \\ \hline
0 & & & Bank \\ \hline
1 & Get Customer Coordinates & \\ \hline
2a1 & Retrieve Customer Information & Actual customer \\ \hline
2a2 & Analyze Customer Relation & \\ \hline
2b & Build Customer Profile & else \\ \hline
3 & Identify Customer Account Selection & \\ \hline
4 & Select Account Type & \\ \hline
5a & Register Deposit & Deposit when opening \\ \hline
5b & goto 6 & else \\ \hline
6 & Prepare Account & \\  & Opening Document & \\ \hline
7a & Record & \\  & Customer Information & \\ \hline
7b & Propose Account Opening & \\ \hline
7c1 & Schedule Status Review & \\ \hline
7c2a & Review Account Status & \\ \hline
7c2b & Confirm Customer Identifier & \\ \hline
8 & Open Banking Account & \\ \hline
9 & & \\ \hline \hline \end{tabular}
\end{table} 
Table 17: Bank account opening. Although we do not consider data flow in our model, it is possible to add this kind of perspective in the exactly the same way, as it was proposed in [26]--by adding two new columns: Input and Output column (as presented in Table 1). To illustrate the idea of spreadsheet representation and its interoperability, a sample model of tramway departure process was selected. The BPMN model of this process is shown in Figure 5, while Figures 6-9 illustrate this process in different modeling notations, namely: EPC, Petri net, UML AD and YAWL. The goal of this process is the preparation of a tramway car to leave the storage yard in the morning. In the workflow, there are two organizational participants: the Depot which is responsible for storing and servicing the rolling stock and the Traffic Department which controls and manages the daily operations, as well as the human actor, represented by the driver. The desired outcome of the process is the successful departure of the car from the depot which results in starting regular service with passengers. Based on the departure time taken from the schedule, the Traffic Department prepares and prints the Traffic Card which serves as the main document for the driver. In the next step, two parallel chains of activities are executed. The Depot prepares the car for the daily service while the Traffic Department awaits the driver. If the driver does not arrive, a next employee is called to come. Then, the driver is tested fot alcohol level in the exhaled air. If alcohol is detected, a new driver is called and the testing procedure is repeated. Finally, when the tramway car is ready for departure and the driver is authorized to work, the car can be taken by the driver from the outbound track. The process ends when the Traffic Department registers the departure in their systems.