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

[newtonsgroove]

Here is the content reformatted for a GitHub issue:

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

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

[clapierre]

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]

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 <#192 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABKSFJYZF3MMNT3YTKK2G6DX6AHB7AVCNFSM6AAAAAA5GYDYBSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTONJQG42TKOBVG4> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[newtonsgroove]

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 > <#192 (comment)>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/ABKSFJYZF3MMNT3YTKK2G6DX6AHB7AVCNFSM6AAAAAA5GYDYBSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTONJQG42TKOBVG4> > . > You are receiving this because you were mentioned.Message ID: > ***@***.***> >