The system is based on Wald-Savage synthetic criterion used in "games against nature" (game theory). This system was used by me to solve the problem of building the priority queue of the commercial bank mortgage loan recipients.
The program collects information by connecting to a relational database (such as MySQL) stored on a remote server, and reading information from it using SQL queries, which is provided by the MySQL Connector/NET 1.3.8 library. Information is systematized within the program by entering it into a specialized data structure - a 2-dimensional array. The Wald-Savage algorithm is formalized using C# with Windows Forms GUI on a .NET Core 5.0. After the information has been processed by the algorithm, it is displayed in the control element of Windows Forms GUI - DataGridView. Note: As a data source that can be defined by a DataSource property of a DataGridView element, this element can use various types of data storage (including database tables) or work without binding to any data source. The optional function is to output the processed to the MS Excel file, which is implemented with the Open-XML-SDK 2.9.1 package. This option can be applied if the user puts a check box next to the inscription «Output to MS Excel».
Screenshot below shows the program window at startup:
After filling in all the corresponding fields, press the button shown in the screenshot below to connect to the database using the input data:
After connecting to the database, the program window will look like the next screenshot:
After the necessary database has been connected and data has been unloaded, to form priority queues of game strategies it is necessary to press the button shown in the screenshot:
After clicking the above button, the algorithm will be launched to build a set of strategies optimally according to the Wald-Savage criterion, and then an algorithm to build a set of priority queues of game strategies with all the necessary results displayed:
If it is necessary that the set of priority queues of game strategies formed is written into a file, before pressing the button responsible for running the algorithm, you need to put a check box opposite the inscription «Output to MS Excel file»:
An examle of the sheet in the MS Excel workbook, in which a number of priority queues of game strategies were written:
For a deeper understanding I advise you to read: Labsker, L. G. Priority of lending to the bank of corporate borrowers. Formation of the priority order on the basis of the synthetic criterion of Wald-Savage / L. G. Labsker, N. A. Yashchenko, A. V. Ameline. - Saarbrüken: LAP LAMBERT Academic Publishing GmbH & Co. KG, 2012. - 237 p.