Phoenix - Your AI AssistantExcel VBA for weighted sum model
- Posted:
- Proposals: 15
- Remote
- #4294504
- PRE-FUNDED
- Completed
Ludhiana 
Description
Experience Level: Entry
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
Thank you for your interest and best regards
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
Thank you for your interest and best regards
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Could you please share the complexity level of the application example or any specific industry domain for the utility analysis???