Seems to be that one of the formulas has to be corrected under MS Excel. It works fine under Office Libre. I don’t have MS Excel at the moment, will check end of April.
Hi, Thanks for the AHP Calculation spreadsheet. I have worked on the spreadsheet for my Ph.D Thesis analysis work, however have some questions…appreciate if we can connect on Teams to discuss further.
Downloaded XLS and everything (and I mean EVERYTHING) is perfect and simple and easy to use, except I cannot get the CONSENSUS value to appear. No matter what I do, all I see is ‘######’ in the Consensus field. Please help!
Hello, first of all a compliment for the very intuitive tool. I have a question regarding the calculation of the Consolidated Global Priorities (Standard AHP Linear Scale). Is there a way to understand the calculation of the percentages in the tool at a detailed level?
Hello, I am trying to figure out why the Excell do not calculate of Consensus Indicator based on RGGM results?
Seems to be that one of the formulas has to be corrected under MS Excel. It works fine under Office Libre. I don’t have MS Excel at the moment, will check end of April.
Thank you for your reply. I have Office libre, but still some figures are missed. Especially, when I choose different scales – it doesn’t work
Hi, Thanks for the AHP Calculation spreadsheet. I have worked on the spreadsheet for my Ph.D Thesis analysis work, however have some questions…appreciate if we can connect on Teams to discuss further.
Dear Sir, I have resolved the above concern and got the AHP results. Appreciate your help on the sensitivity analysis, if we can connect.
Any questions just ask here or via the contact form.
Solution: using Office Libre
Downloaded XLS and everything (and I mean EVERYTHING) is perfect and simple and easy to use, except I cannot get the CONSENSUS value to appear. No matter what I do, all I see is ‘######’ in the Consensus field. Please help!
Probably a problem in the settings. I am using Office Libre and cannot reproduce the error.
Hello, first of all a compliment for the very intuitive tool. I have a question regarding the calculation of the Consolidated Global Priorities (Standard AHP Linear Scale). Is there a way to understand the calculation of the percentages in the tool at a detailed level?
Many thanks and BR, Johanna