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
Web Health Tracker Development Category: AI Development, API Integration, Data Analysis, Data Collection, Data Management, Data Modeling, Health Care Management, Image Processing, User Experience Research, Web Development Budget: £250 - £750 GBP
Personalized AI Travel Planner Category: AI Chatbot, AI Development, AI Model Development, API Integration, Graphic Design, HTML, PHP, Web Design Budget: $250 - $750 USD
Scrape MIMS India Descriptions Category: Automation, BeautifulSoup, Data Collection, Data Extraction, Data Mining, Python, Scrapy, Selenium, Software Architecture, Web Scraping Budget: ₹12500 - ₹37500 INR
Used Car Social Media Setup Category: Branding, Content Creation, Facebook Marketing, Instagram Marketing, Lead Generation, Social Media Management, Social Media Marketing, Video Editing Budget: £20 - £250 GBP