I want a spreadsheet built, please, to evaluate the fit of a software product to an organisation.
It will have several levels of weighted criteria and the end result will be that a single figure is spat out at the end as to the overall 'fit' of the product to the organisation's requirements eg the product is a 30% fit.
It will need to be able to recalculate whatif's based on my 1. adjusting the weightings, 2. adding more or subtracting, criteria, and 3. adjusting the scoring.
The evaluation model is similar (but not identical) to the attached.
Within each pink box in Functionality, there are several one line requirements criteria (I can mail you what this looks like tomorrow). Each requirement is rated Mandatory, Desirable, or Nice to Have. The fit of the product is then scored for each requirement, Fully complies, Partially complies, No compliance.
For each of the blue, yellow, lilac, etc boxes, each would have a weighting within its category, and I think I would apply a score out of 5.
Some good graphical representations showing fit in various areas are needed too.
I also would appreciate your advice and your ideas on validating the model eg is the weightings structure reasonable. (You don't need to be familiar at all with the content material.)
If you are an Excel expert and feel confident to build this spreadsheet, please bid.
53 freelancers are bidding on average $93 for this job
I have around 8+ years experience in Project Management and worked in Product based as well as Services based companies where in deal with excel sheets often for either estimation effort, data management.