Hello, I am looking for a developer who can create a utility analysis in Excel with VBA.
The task is defined as follows: - Create a utility analysis (weighted sum model) for an application example of your choice - The documentation and description of the application example is provided on an Excel worksheet. - The data management (criteria and alternatives) takes place in an Excel worksheet. - The weights for the criteria and their evaluation are queried in VBA and saved in the Excel worksheet. - The utility values are calculated with VBA and saved in the Excel worksheet.
The following constructs are to be used in the VBA code: 1) Subroutine / subfunction with variable transfer 2) Array/Record 3) Data management in Excel using Application.Range (“A1”), Application.Value or Application.Cells(i,j)
The task is to be submitted as an Excel file / Excel workbook with macros (xslm).
The expected formula for the weighted sum model / utility analysis is to be found here: https://en.wikipedia.org/wiki/Weighted_sum_model
