Spreadsheet: 758288d1638799082-productivity-for-individual-productivity-variance-analysis-edit-2-
Sheet: Sheet1

Emp ID | Name | Tenure Year | Tenure Month | Workout | Core Time | Productivity | Productivity Q2 | Productivity Q3 | [NAME] | [NAME] |  | CD | I - H | K -  J | [NAME]/min | up or down |  | Baseline of Productivuty |  |  |  |  |  |  |  | calculation
134 | Ovi | 4 | 3 | 1018.07 | 845.87 | 1.2036 | 1.2036 | 1.2036 | 1018.07 | 1018.07 |  |  |  |  |  |  |  |  | Baseline productiviy |  |  |  |  | Productivity Quartile 2 | if(g2<O4,O4,G2) |  | total workout baseline | workout Q2 | sum of workout Q2
20 | [NAME] | 2 | 10 | 1064.99 | 893.65 | 1.1917 | 1.1917 | 1.1938 | 1064.99 | 1066.87 |  |  |  |  |  |  |  |  |  |  |  |  |  | Productivity Quartile 3 | if(H2<O5,O4,H2) |  | sum of workout | workout Q2 | sum of workout Q3
30 | Him | 5 | 9 | 502.15 | 421.47 | 1.1914 | 1.1914 | 1.1938 | 502.15 | 503.16 |  |  |  |  |  |  |  |  | 0 | < 6m |  |  |  |  | Q2 | QUARTILE(G2:G26,2)
32 | Piy | 2 | 7 | 825.15 | 697.75 | 1.1834 | 1.1834 | 1.1938 | 825.75 | 833.01 |  |  |  |  |  |  |  |  | 6 | 6m - < 1yr |  |  |  |  | Q3 | QUARTILE(G2:G26,3) | total coretime
131 | Ape | 3 | 2 | 820.11 | 699.82 | 1.1719 | 1.1719 | 1.1938 | 820.11 | 835.44 |  |  |  |  |  |  |  |  | 12 | 1yr - < 2yr |  |  |  |  |  |  | sum of coretime
22 | San | 1 | 11 | 971.23 | 835.68 | 1.1622 | 1.1622 | 1.1938 | 971.23 | 997.64 |  |  |  |  |  |  |  |  | 24 | 2yr |  |  |  | workout Quartile 2 | iferror((e2/g2)*H2),"") |  | total workout at baseline / total core time
138 | Uth | 5 | 0 | 1000.58 | 862.92 | 1.1595 | 1.1595 | 1.1938 | 1000.58 | 1030.18 |  |  |  |  |  |  |  |  |  |  |  |  |  | workout Quartile 3 | iferror((e2/g2)*I2),"") | Prod baseline
34 | Sak | 2 | 4 | 939.56 | 811.97 | 1.1571 | 1.1571 | 1.1938 | 939.56 | 969.36 |  |  |  |  |  |  |  |  | 17 | 17
24 | Sug | 0 | 10 | 807.97 | 705.25 | 1.1457 | 1.1457 | 1.1938 | 807.97 | 841.89 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | total prod at Q2 | total workout at Q2/total core time
33 | Rav | 8 | 8 | 917.66 | 803.18 | 1.1425 | 1.1425 | 1.1938 | 917.66 | 958.86 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | total prod at Q2 | total workout at Q3/total core time
28 | [NAME] | 2 | 9 | 861.31 | 754.28 | 1.1419 | 1.1419 | 1.1938 | 861.31 | 900.46
139 | Var | 2 | 1 | 971.28 | 850.97 | 1.1414 | 1.1414 | 1.1938 | 971.28 | 1015.87
27 | [NAME] | 1 | 6 | 472.4 | 415.18 | 1.1378 | 1.1378 | 1.1938 | 472.4 | 495.65 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | % Variance | workout variance
133 | Niv | 2 | 11 | 1108.23 | 978.27 | 1.1328 | 1.1328 | 1.1938 | 1108.23 | 1167.91
35 | Smi | 6 | 2 | 907.71 | 807.12 | 1.1246 | 1.1246 | 1.1938 | 907.71 | 963.56
31 | Om | 9 | 0 | 892.36 | 797.5 | 1.1189 | 1.1238 | 1.1938 | 896.23 | 952.1
37 | Yas | 1 | 1 | 902.51 | 830.92 | 1.0862 | 1.1238 | 1.1938 | 933.71 | 991.91
19 | Log | 5 | 8 | 834.71 | 788.82 | 1.0582 | 1.1238 | 1.1938 | 886.42 | 941.67
36 | Shi | 1 | 1 | 845.05 | 807.77 | 1.0462 | 1.1238 | 1.1938 | 907.69 | 964.27
135 | Pra | 0 | 10 | 649.51 | 621 | 1.0459 | 1.1238 | 1.1938 | 697.86 | 741.36
129 | Ana | 4 | 11 | 852.18 | 823.4 | 1.035 | 1.1238 | 1.1938 | 925.25 | 982.93
25 | Sur | 1 | 1 | 884.27 | 876.8 | 1.0085 | 1.1238 | 1.1938 | 985.32 | 1046.74
21 | Rag | 0 | 8 | 797.79 | 810.08 | 0.9848 | 1.1238 | 1.1938 | 910.35 | 967.1
26 | Swa | 0 | 11 | 848.19 | 867.9 | 0.9773000000000001 | 1.1238 | 1.1938 | 975.29 | 1036.09