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
Complete Standard Horizon Budget Category: Budgeting And Forecasting, Data Analysis, Data Entry, Excel, Financial Analysis, Financial Modeling, Microsoft Office, Word Budget: €30 - €250 EUR
08-Feb-2026 23:00 GMT
Automotive Marketplace Website & PWA Category: AI Chatbot, AI Development, AI Image Editing, API Development, Database Management, HTML, MySQL, PHP, Software Architecture, Web Development Budget: $100 - $2000 USD