The Excel document scoring has not been updated for the new content (if indeed the new content is to be there. It is possible to score well beyond 100% by populating categories.

To reproduce

Open Excel doc
Select a tab (ex: 3.2. Knowledge and Skills)
Change each status under “Optimize Stage Goal” to “Complete”
View result (I got as high as 325% NOTE: on 3.3 Support results of the same process resulted in 0%)

325 percent

clapierre commented 8 months ago

Hello @newtonsgroove the reason why you are getting a % score above 100% is that you haven't filled in the statuses for the preceding stages.

Ideally the spreadsheet wouldn't allow us to add any status in a later stage until you mark the previous stage as "complete" but this is a lot of extra error checking/coding in the excel spreadsheet and this is only a stop-gap solution until we finalize all the dimensions / proof points at which time a more robust web implementation will be created.

To fix your issue make all previous stages as complete and I believe you will get a more accurate % for your final score.

There was one issue that was fixed around the time you posted this issue in the Communication Tab on Cell C63 which didn't take into account the first 3 proof points in the total points available. Should have started at B11 not B14. This has been fixed in the most recent version of the spreadsheet.

Thanks

newtonsgroove commented 8 months ago

Thanx, Charles. Is the following the correct methodology for the scoring?

Scoring Formulas Scoring Formula (Unweighted) Scoring Formula (Weighted) Total Points Recieved ((Total Launch 1) + (Total Integrate 2) + (Total Optimize 3) ((Total Launch 1) + (Total Integrate * 2) + (Total Optimize

3) Total Points Available (Total Number of Proof Points - Proof Points Not Applicable) (Total Number of Proof Points - Proof Points Not Applicable) * 3 Maturity Score (Dimension) Total Points Received / Total Points Available Total Points Received / Total Points Available Maturity Score (All Dimensions) Average of all Matutiry Scores (from seven dimensions - unweighted)

Average of all Matutiry Scores (from seven dimensions - weighted)

Dr. Keith Newton (Call me "Dr. Keith") Executive Leader and Strategic a11y in Digital Accessibility Experience 614-654-4116 <%28614%29%20654-4116> | https://www.linkedin.com/in/dr-keith-newton | @.***

On Fri, Oct 6, 2023 at 10:15 AM Charles LaPierre @.***> wrote:

Hello @newtonsgroove https://github.com/newtonsgroove the reason why you are getting a % score above 100% is that you haven't filled in the statuses for the preceding stages.

Ideally the spreadsheet wouldn't allow us to add any status in a later stage until you mark the previous stage as "complete" but this is a lot of extra error checking/coding in the excel spreadsheet and this is only a stop-gap solution until we finalize all the dimensions / proof points at which time a more robust web implementation will be created.

To fix your issue make all previous stages as complete and I believe you will get a more accurate % for your final score.

There was one issue that was fixed around the time you posted this issue in the Communication Tab on Cell C63 which didn't take into account the first 3 proof points in the total points available. Should have started at B11 not B14. This has been fixed in the most recent version of the spreadsheet.

Thanks

— Reply to this email directly, view it on GitHub https://github.com/w3c/maturity-model/issues/192#issuecomment-1750755857, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABKSFJYZF3MMNT3YTKK2G6DX6AHB7AVCNFSM6AAAAAA5GYDYBSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTONJQG42TKOBVG4 . You are receiving this because you were mentioned.Message ID: @.***>

newtonsgroove commented 8 months ago

sorry, I forgot:

Weights and Values Maturity Stage Points (Unweighted) Points (Weighted) Inactive 0 0 Launch 1 1 Integrate 1 2 Optimize 1 3 Not Applicable 0 0 Yet to be Added 0 0

Dr. Keith Newton (Call me "Dr. Keith") Executive Leader and Strategic a11y in Digital Accessibility Experience 614-654-4116 <%28614%29%20654-4116> | https://www.linkedin.com/in/dr-keith-newton | @.***

On Fri, Oct 6, 2023 at 1:38 PM Keith Newton @.***> wrote:

Thanx, Charles. Is the following the correct methodology for the scoring?

Scoring Formulas Scoring Formula (Unweighted) Scoring Formula (Weighted) Total Points Recieved ((Total Launch 1) + (Total Integrate 2) + (Total Optimize 3) ((Total Launch 1) + (Total Integrate 2) + (Total Optimize 3) Total Points Available (Total Number of Proof Points - Proof Points Not Applicable) (Total Number of Proof Points - Proof Points Not Applicable)

3 Maturity Score (Dimension) Total Points Received / Total Points Available Total Points Received / Total Points Available Maturity Score (All Dimensions) Average of all Matutiry Scores (from seven dimensions - unweighted)

Average of all Matutiry Scores (from seven dimensions - weighted)

Dr. Keith Newton (Call me "Dr. Keith") Executive Leader and Strategic a11y in Digital Accessibility Experience 614-654-4116 <%28614%29%20654-4116> | https://www.linkedin.com/in/dr-keith-newton | @.***

On Fri, Oct 6, 2023 at 10:15 AM Charles LaPierre @.***> wrote:

Hello @newtonsgroove https://github.com/newtonsgroove the reason why you are getting a % score above 100% is that you haven't filled in the statuses for the preceding stages.

Ideally the spreadsheet wouldn't allow us to add any status in a later stage until you mark the previous stage as "complete" but this is a lot of extra error checking/coding in the excel spreadsheet and this is only a stop-gap solution until we finalize all the dimensions / proof points at which time a more robust web implementation will be created.

To fix your issue make all previous stages as complete and I believe you will get a more accurate % for your final score.

There was one issue that was fixed around the time you posted this issue in the Communication Tab on Cell C63 which didn't take into account the first 3 proof points in the total points available. Should have started at B11 not B14. This has been fixed in the most recent version of the spreadsheet.

Thanks

— Reply to this email directly, view it on GitHub https://github.com/w3c/maturity-model/issues/192#issuecomment-1750755857, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABKSFJYZF3MMNT3YTKK2G6DX6AHB7AVCNFSM6AAAAAA5GYDYBSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTONJQG42TKOBVG4 . You are receiving this because you were mentioned.Message ID: @.***>

w3c / maturity-model

The Excel document scoring has not been updated for the new content #192

The Excel document scoring has not been updated for the new content (if indeed the new content is to be there. It is possible to score well beyond 100% by populating categories.

To reproduce