Problems found when the workbook was imported. Work through them so the plan the team follows is correct.
0/459
Reviewed
459 issues still open
189
Warnings to decide
Need someone who knows the plant
14
Dates ready to correct
One click each
KPI formula error
A workbook KPI cell disagrees with the value recomputed from its inputs (usually a formula error).
Workbook shows 9.65034965034965 (typed value) but the imported inputs give 12.5396.
Workbook shows 9.52167832167832 (typed value) but the imported inputs give 6.624.
Workbook shows 35 (typed value) but the imported inputs give 370.0.
Workbook shows 0.161892901618929 (formula =Q42/R42) but the imported inputs give 0.312779.
Workbook shows -218.7 (formula =SUM(S38:S41)) but the imported inputs give -230.7.
Workbook shows 722.7 (typed value) but the imported inputs give 335.7.
Workbook shows 117 (formula =SUM(Q38:Q41)) but the imported inputs give 105.0.
Workbook shows '#DIV/0!' (formula =AVERAGE(M38:M41)) but the imported inputs give 0.0.
Workbook shows 0.9895833333333334 (formula =AVERAGE(G38:G41)) but the imported inputs give 0.984615.
Workbook shows 76 (formula =SUM(F38:F41)) but the imported inputs give 64.0.
Workbook shows 77 (formula =SUM(E38:E41)) but the imported inputs give 65.0.
Workbook shows 0.2222222222222222 (formula =Q41/R41) but the imported inputs give 0.0.
Workbook shows -42 (formula =Q41-R41) but the imported inputs give -54.0.
Workbook shows 12 (formula =SUM(F41,I41,L41,O41)) but the imported inputs give 0.0.
Workbook shows 1 (formula =F41/E41) but the imported inputs give None.
Workbook shows 12 (formula =SUM(R5:R7)) but the imported inputs give 0.0.
Workbook shows 12 (formula =SUM(P5:P7)) but the imported inputs give 0.0.
Workbook shows 100 (typed value) but the imported inputs give 1.0.
Workbook shows 0.0435865504358655 (formula =Q42/R42) but the imported inputs give 0.062002.
Workbook shows 722.7 (typed value) but the imported inputs give 508.05.
Workbook shows 0.2185897435897436 (formula =AVERAGE(G38:G41)) but the imported inputs give 0.328125.
Workbook shows 100 (typed value) but the imported inputs give 1.0.