Test dashboard 2.0

[blcham]

We should do it in iteration:

1. pick WP to test, add screenshot of dasboard 2.0 from our application, add screenshot of dasboard 2.0 from CSAT
2. identify which values are not correct and put some info about them

[Tombo159]

I have tried to check correctness of values on OH-LZN maintenance check (during morning of 11.02.2023):

Planned MPD, Planned Additional - I have changed the formula please look at Google sheet

Marked red are different values, but be awared that some of CSAT values might itself not be 100% correct because there are some imperfections in calculating with defect classes.

Thus from manual revision: Findings up to limit seems to be somewhat correct with minor deviation: my values: Revised=754,25; Actual=785,71

Findings above limit seems to be incorrect: My value for actual is 474,98 and revised 730,68

Customer Request seems also to be incorrect: Revised 62,6 and actual 61,76

Planned additional Actual: my value 126,23
Planned MPD Actual my value is 2465,38

If you have suspision that any of my value is incorrect please contact me.

I am ataching picture from CSAT Excel sheet however there are slightly different values due to lack of proper calculation with defect classes:

I have created Excel sheet with values that I was calculating with:

ValuesExplanation.xlsx

Also TAT is incorrect

[blcham]

@grigoart

[Tombo159]

@grigoart

I have created a new more thorough evaluation. Please ignore the one above and try to proceed with this one:

wp = PH-XRY/H-22 HMV-10

Excel file with more explanations. Values with workorders and to which group certain workorders shall be included.
XRY Values Explanation.xlsx

I am also adding a MS ACCESS file used to evaluate these data, but keep in mind that this particular one will be usable only for instances where "per finding" limit is applied.
Test_XRY.zip

I will add in upcoming days an example where "per Taskcard" caplimit is applied.

Please If you get different values then I have received from my calculations send me WO/TC which you have used and their respective values.

Note: There are some small changes in formulas - please accept them. The most important one is, that defect class "W" is not to be included in calculations

[grigoart]

@blcham

[Tombo159]

@grigoart
@blcham

I have created a new evaluation for wp with "Taskcard" LimitType:
wp = OK-TSR/H-22 AV10Y

Here is an Excel file with more details about data from which I have created my results:
TSR Values Explanation.xlsx

I suggest that you will try to compare your results with mine (wp=PH-XRY/H-22 HMV-10 and wp=OK-TSR/H-22 AV10Y) and report a problems/differences to me and then we will try to workout a solution.

Note: There are still some small changes in formulas that haven't been accepted yet.

[blcham]

Reopen as it is not fixed.

[blcham]

@grigoart

[blcham]

According to @grigoart,

• for wp = PH-XRY/H-22 HMV-10 there are missing datasets:

  • time-analysis for date -- 9.12.2022
  • time-analysis and wp-catalog for date -- 10.1.2023

• for wp = OK-TSR/H-22 AV10Y there are lot of missing datasets related to "wp-catalog"

[grigoart]

WP data completeness: https://docs.google.com/spreadsheets/d/1EhVa6b6UbfoTxbMGUQSpTt9DEVFaqUF-_V-lXdVso18/edit?usp=share_link

[blcham]

@grigoart

• I do not have time-analysis for date -- 9.12.2022 anywhere :(
• time-analysis and wp-catalog for date -- 10.1.2023 is deployed

[blcham]

@Tombo159 as can be seen in WP data completeness document, here are some examples of complete WPs:

• PH-HSM-H-23-HMV4
• PH-HZV-H-23-REPAIR
• OE-LXE-H-22-4Y-3Y-2Y
• OH-LZM-H-22-HMV1

Can you do analysis for one of them or choose different one for which we have complete data?