{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet2"],"not_rendered":{"images":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Sheet2","index":0,"n_rows":61,"n_cols":25,"rows_kept":61,"merged":[[1,1,1,21],[3,5,3,7],[3,9,3,12],[5,5,5,7],[7,5,7,7],[7,18,7,21],[9,9,9,12],[12,1,14,7],[12,8,14,12],[12,13,13,17],[12,18,13,21],[14,18,14,19],[14,20,14,21],[15,2,15,6],[16,1,24,1],[16,2,24,6],[16,7,24,7],[27,1,34,1],[27,2,34,6],[27,7,34,7],[36,1,44,1],[36,2,44,6],[36,7,44,7],[46,1,48,1],[46,2,48,6],[46,7,48,7],[51,3,51,5]]}
[]
[null,"4.2 Scorecard: Gauteng"]
[]
[null,"Group",{"$nulls":3},"DISTRIBUTION",null,null,"Name","DISCONNECTION/RECONNECTION CONTRACT"]
[]
[null,"Business Unit",{"$nulls":3},"GOU",null,null,"Grade","TOTAL",{"$nulls":3},"Signed Manager"]
[]
[null,"Department",{"$nulls":3},"RCM",null,null,"Unique No","TOTAL",{"$nulls":8},"Final Score"]
[]
[{"$nulls":8},"Job Title","CONTRACTOR SCORECARD",{"$nulls":3},"Signed Individual",{"$nulls":4},"Rev1",null,"Rev2"]
[]
[]
[null,"KPA",{"$nulls":6},"Key Performance Indicators",{"$nulls":4},"Target Setting wrt Expectation",{"$nulls":4},"Results"]
[]
[{"$nulls":13},"Floor","Kick","Target","Stretch","Ceiling","Review 1",null,"Review 2 "]
[null,"No","KPIs for KPA 4",{"$nulls":4},"Weight","No","Performance Measure/Indicator ","Metric","Source of Evidence","Weight",1,2,3,4,5,"Actual","Score","Actual","Score"]
[null,1,"Disconnections within 24 hours at Meterbox and Pillar Box ",{"$nulls":4},{"v":0.4,"d":"40%"},1.1,"Disconnections done within 24hrs","Hours","Maximo Report ",{"v":0.4,"d":"40%"},{"v":48,"d":"48.00"},{"v":36,"d":"36.00"},{"v":24,"d":"24.00"},{"v":12,"d":"12.00"},{"v":6,"d":"6.00"},{"$nulls":5},{"$f":"IF(R17>N17,ABS(IF(S17<=N17,1,IF(AND(S17>N17,S17<=O17),1+((S17-N17)/(O17-N17)),IF(AND(S17>O17,S17<=P17),2+((S17-O17)/(P17-O17)),IF(AND(S17>P17,S17<=Q17),3+((S17-P17)/(Q17-P17)),IF(AND(S17>Q17,S17<=R17),4+((S17-Q17)/(R17-Q17)),IF(S17>R17,5,ERROR))))))),ABS(IF(S17>=N17,1,IF(AND(S17<N17,S17>=O17),1+((S17-N17)/(O17-N17)),IF(AND(S17<O17,S17>=P17),2+((S17-O17)/(P17-O17)),IF(AND(S17<P17,S17>=Q17),3+((S17-P17)/(Q17-P17)),IF(AND(S17<Q17,S17>=R17),4+((S17-Q17)/(R17-Q17)),IF(S17<R17,5,ERROR))))))))","v":{"v":5,"d":"5.00"}},{"$f":"IF(R17>N17,ABS(IF(U17<=N17,1,IF(AND(U17>N17,U17<=O17),1+((U17-N17)/(O17-N17)),IF(AND(U17>O17,U17<=P17),2+((U17-O17)/(P17-O17)),IF(AND(U17>P17,U17<=Q17),3+((U17-P17)/(Q17-P17)),IF(AND(U17>Q17,U17<=R17),4+((U17-Q17)/(R17-Q17)),IF(U17>R17,5,ERROR))))))),ABS(IF(U17>=N17,1,IF(AND(U17<N17,U17>=O17),1+((U17-N17)/(O17-N17)),IF(AND(U17<O17,U17>=P17),2+((U17-O17)/(P17-O17)),IF(AND(U17<P17,U17>=Q17),3+((U17-P17)/(Q17-P17)),IF(AND(U17<Q17,U17>=R17),4+((U17-Q17)/(R17-Q17)),IF(U17<R17,5,ERROR))))))))","v":{"v":5,"d":"5.00"}}]
[{"$nulls":9},"Scope entails the following:"]
[{"$nulls":9},"Identify correct electrical address to physical address, switch off circuitbreaker in meter box, test dead,remove bridge piece, secure roll up tie and fasten end.",{"$nulls":13},{"$f":"IF(R19>N19,ABS(IF(S19<=N19,1,IF(AND(S19>N19,S19<=O19),1+((S19-N19)/(O19-N19)),IF(AND(S19>O19,S19<=P19),2+((S19-O19)/(P19-O19)),IF(AND(S19>P19,S19<=Q19),3+((S19-P19)/(Q19-P19)),IF(AND(S19>Q19,S19<=R19),4+((S19-Q19)/(R19-Q19)),IF(S19>R19,5,ERROR))))))),ABS(IF(S19>=N19,1,IF(AND(S19<N19,S19>=O19),1+((S19-N19)/(O19-N19)),IF(AND(S19<O19,S19>=P19),2+((S19-O19)/(P19-O19)),IF(AND(S19<P19,S19>=Q19),3+((S19-P19)/(Q19-P19)),IF(AND(S19<Q19,S19>=R19),4+((S19-Q19)/(R19-Q19)),IF(S19<R19,5,ERROR))))))))","v":{"v":1,"d":"1.00"}},{"$f":"IF(R19>N19,ABS(IF(U19<=N19,1,IF(AND(U19>N19,U19<=O19),1+((U19-N19)/(O19-N19)),IF(AND(U19>O19,U19<=P19),2+((U19-O19)/(P19-O19)),IF(AND(U19>P19,U19<=Q19),3+((U19-P19)/(Q19-P19)),IF(AND(U19>Q19,U19<=R19),4+((U19-Q19)/(R19-Q19)),IF(U19>R19,5,ERROR))))))),ABS(IF(U19>=N19,1,IF(AND(U19<N19,U19>=O19),1+((U19-N19)/(O19-N19)),IF(AND(U19<O19,U19>=P19),2+((U19-O19)/(P19-O19)),IF(AND(U19<P19,U19>=Q19),3+((U19-P19)/(Q19-P19)),IF(AND(U19<Q19,U19>=R19),4+((U19-Q19)/(R19-Q19)),IF(U19<R19,5,ERROR))))))))","v":{"v":1,"d":"1.00"}}]
[{"$nulls":9},"Seal meter and log seal number on spreadsheet",{"$nulls":13},{"$f":"IF(R20>N20,ABS(IF(S20<=N20,1,IF(AND(S20>N20,S20<=O20),1+((S20-N20)/(O20-N20)),IF(AND(S20>O20,S20<=P20),2+((S20-O20)/(P20-O20)),IF(AND(S20>P20,S20<=Q20),3+((S20-P20)/(Q20-P20)),IF(AND(S20>Q20,S20<=R20),4+((S20-Q20)/(R20-Q20)),IF(S20>R20,5,ERROR))))))),ABS(IF(S20>=N20,1,IF(AND(S20<N20,S20>=O20),1+((S20-N20)/(O20-N20)),IF(AND(S20<O20,S20>=P20),2+((S20-O20)/(P20-O20)),IF(AND(S20<P20,S20>=Q20),3+((S20-P20)/(Q20-P20)),IF(AND(S20<Q20,S20>=R20),4+((S20-Q20)/(R20-Q20)),IF(S20<R20,5,ERROR))))))))","v":{"v":1,"d":"1.00"}},{"$f":"IF(R20>N20,ABS(IF(U20<=N20,1,IF(AND(U20>N20,U20<=O20),1+((U20-N20)/(O20-N20)),IF(AND(U20>O20,U20<=P20),2+((U20-O20)/(P20-O20)),IF(AND(U20>P20,U20<=Q20),3+((U20-P20)/(Q20-P20)),IF(AND(U20>Q20,U20<=R20),4+((U20-Q20)/(R20-Q20)),IF(U20>R20,5,ERROR))))))),ABS(IF(U20>=N20,1,IF(AND(U20<N20,U20>=O20),1+((U20-N20)/(O20-N20)),IF(AND(U20<O20,U20>=P20),2+((U20-O20)/(P20-O20)),IF(AND(U20<P20,U20>=Q20),3+((U20-P20)/(Q20-P20)),IF(AND(U20<Q20,U20>=R20),4+((U20-Q20)/(R20-Q20)),IF(U20<R20,5,ERROR))))))))","v":{"v":1,"d":"1.00"}}]
[{"$nulls":9},"Remove 2m of the cable and spike into the ground",{"$nulls":13},{"$f":"IF(R21>N21,ABS(IF(S21<=N21,1,IF(AND(S21>N21,S21<=O21),1+((S21-N21)/(O21-N21)),IF(AND(S21>O21,S21<=P21),2+((S21-O21)/(P21-O21)),IF(AND(S21>P21,S21<=Q21),3+((S21-P21)/(Q21-P21)),IF(AND(S21>Q21,S21<=R21),4+((S21-Q21)/(R21-Q21)),IF(S21>R21,5,ERROR))))))),ABS(IF(S21>=N21,1,IF(AND(S21<N21,S21>=O21),1+((S21-N21)/(O21-N21)),IF(AND(S21<O21,S21>=P21),2+((S21-O21)/(P21-O21)),IF(AND(S21<P21,S21>=Q21),3+((S21-P21)/(Q21-P21)),IF(AND(S21<Q21,S21>=R21),4+((S21-Q21)/(R21-Q21)),IF(S21<R21,5,ERROR))))))))","v":{"v":1,"d":"1.00"}},{"$f":"IF(R21>N21,ABS(IF(U21<=N21,1,IF(AND(U21>N21,U21<=O21),1+((U21-N21)/(O21-N21)),IF(AND(U21>O21,U21<=P21),2+((U21-O21)/(P21-O21)),IF(AND(U21>P21,U21<=Q21),3+((U21-P21)/(Q21-P21)),IF(AND(U21>Q21,U21<=R21),4+((U21-Q21)/(R21-Q21)),IF(U21>R21,5,ERROR))))))),ABS(IF(U21>=N21,1,IF(AND(U21<N21,U21>=O21),1+((U21-N21)/(O21-N21)),IF(AND(U21<O21,U21>=P21),2+((U21-O21)/(P21-O21)),IF(AND(U21<P21,U21>=Q21),3+((U21-P21)/(Q21-P21)),IF(AND(U21<Q21,U21>=R21),4+((U21-Q21)/(R21-Q21)),IF(U21<R21,5,ERROR))))))))","v":{"v":1,"d":"1.00"}}]
[{"$nulls":9},"Place disconnection sticker in meter box ",{"$nulls":13},{"$f":"IF(R22>N22,ABS(IF(S22<=N22,1,IF(AND(S22>N22,S22<=O22),1+((S22-N22)/(O22-N22)),IF(AND(S22>O22,S22<=P22),2+((S22-O22)/(P22-O22)),IF(AND(S22>P22,S22<=Q22),3+((S22-P22)/(Q22-P22)),IF(AND(S22>Q22,S22<=R22),4+((S22-Q22)/(R22-Q22)),IF(S22>R22,5,ERROR))))))),ABS(IF(S22>=N22,1,IF(AND(S22<N22,S22>=O22),1+((S22-N22)/(O22-N22)),IF(AND(S22<O22,S22>=P22),2+((S22-O22)/(P22-O22)),IF(AND(S22<P22,S22>=Q22),3+((S22-P22)/(Q22-P22)),IF(AND(S22<Q22,S22>=R22),4+((S22-Q22)/(R22-Q22)),IF(S22<R22,5,ERROR))))))))","v":{"v":1,"d":"1.00"}},{"$f":"IF(R22>N22,ABS(IF(U22<=N22,1,IF(AND(U22>N22,U22<=O22),1+((U22-N22)/(O22-N22)),IF(AND(U22>O22,U22<=P22),2+((U22-O22)/(P22-O22)),IF(AND(U22>P22,U22<=Q22),3+((U22-P22)/(Q22-P22)),IF(AND(U22>Q22,U22<=R22),4+((U22-Q22)/(R22-Q22)),IF(U22>R22,5,ERROR))))))),ABS(IF(U22>=N22,1,IF(AND(U22<N22,U22>=O22),1+((U22-N22)/(O22-N22)),IF(AND(U22<O22,U22>=P22),2+((U22-O22)/(P22-O22)),IF(AND(U22<P22,U22>=Q22),3+((U22-P22)/(Q22-P22)),IF(AND(U22<Q22,U22>=R22),4+((U22-Q22)/(R22-Q22)),IF(U22<R22,5,ERROR))))))))","v":{"v":1,"d":"1.00"}}]
[{"$nulls":9},"Take photos: \n*Photo before disconnection\n*Indicate meter number\n*Date and time of disconnection\n*Readings of all meters\n*Photo of work completed( After disconnection)",{"$nulls":13},{"$f":"IF(R23>N23,ABS(IF(S23<=N23,1,IF(AND(S23>N23,S23<=O23),1+((S23-N23)/(O23-N23)),IF(AND(S23>O23,S23<=P23),2+((S23-O23)/(P23-O23)),IF(AND(S23>P23,S23<=Q23),3+((S23-P23)/(Q23-P23)),IF(AND(S23>Q23,S23<=R23),4+((S23-Q23)/(R23-Q23)),IF(S23>R23,5,ERROR))))))),ABS(IF(S23>=N23,1,IF(AND(S23<N23,S23>=O23),1+((S23-N23)/(O23-N23)),IF(AND(S23<O23,S23>=P23),2+((S23-O23)/(P23-O23)),IF(AND(S23<P23,S23>=Q23),3+((S23-P23)/(Q23-P23)),IF(AND(S23<Q23,S23>=R23),4+((S23-Q23)/(R23-Q23)),IF(S23<R23,5,ERROR))))))))","v":{"v":1,"d":"1.00"}},{"$f":"IF(R23>N23,ABS(IF(U23<=N23,1,IF(AND(U23>N23,U23<=O23),1+((U23-N23)/(O23-N23)),IF(AND(U23>O23,U23<=P23),2+((U23-O23)/(P23-O23)),IF(AND(U23>P23,U23<=Q23),3+((U23-P23)/(Q23-P23)),IF(AND(U23>Q23,U23<=R23),4+((U23-Q23)/(R23-Q23)),IF(U23>R23,5,ERROR))))))),ABS(IF(U23>=N23,1,IF(AND(U23<N23,U23>=O23),1+((U23-N23)/(O23-N23)),IF(AND(U23<O23,U23>=P23),2+((U23-O23)/(P23-O23)),IF(AND(U23<P23,U23>=Q23),3+((U23-P23)/(Q23-P23)),IF(AND(U23<Q23,U23>=R23),4+((U23-Q23)/(R23-Q23)),IF(U23<R23,5,ERROR))))))))","v":{"v":1,"d":"1.00"}}]
[{"$nulls":9},"Provide disconnection feedback electronically within 24 hours",{"$nulls":13},{"$f":"IF(R24>N24,ABS(IF(S24<=N24,1,IF(AND(S24>N24,S24<=O24),1+((S24-N24)/(O24-N24)),IF(AND(S24>O24,S24<=P24),2+((S24-O24)/(P24-O24)),IF(AND(S24>P24,S24<=Q24),3+((S24-P24)/(Q24-P24)),IF(AND(S24>Q24,S24<=R24),4+((S24-Q24)/(R24-Q24)),IF(S24>R24,5,ERROR))))))),ABS(IF(S24>=N24,1,IF(AND(S24<N24,S24>=O24),1+((S24-N24)/(O24-N24)),IF(AND(S24<O24,S24>=P24),2+((S24-O24)/(P24-O24)),IF(AND(S24<P24,S24>=Q24),3+((S24-P24)/(Q24-P24)),IF(AND(S24<Q24,S24>=R24),4+((S24-Q24)/(R24-Q24)),IF(S24<R24,5,ERROR))))))))","v":{"v":1,"d":"1.00"}},{"$f":"IF(R24>N24,ABS(IF(U24<=N24,1,IF(AND(U24>N24,U24<=O24),1+((U24-N24)/(O24-N24)),IF(AND(U24>O24,U24<=P24),2+((U24-O24)/(P24-O24)),IF(AND(U24>P24,U24<=Q24),3+((U24-P24)/(Q24-P24)),IF(AND(U24>Q24,U24<=R24),4+((U24-Q24)/(R24-Q24)),IF(U24>R24,5,ERROR))))))),ABS(IF(U24>=N24,1,IF(AND(U24<N24,U24>=O24),1+((U24-N24)/(O24-N24)),IF(AND(U24<O24,U24>=P24),2+((U24-O24)/(P24-O24)),IF(AND(U24<P24,U24>=Q24),3+((U24-P24)/(Q24-P24)),IF(AND(U24<Q24,U24>=R24),4+((U24-Q24)/(R24-Q24)),IF(U24<R24,5,ERROR))))))))","v":{"v":1,"d":"1.00"}}]
[{"$nulls":9},"Invoice processing to be completed by 3rd of every month.",{"$nulls":13},{"$f":"IF(R25>N25,ABS(IF(S25<=N25,1,IF(AND(S25>N25,S25<=O25),1+((S25-N25)/(O25-N25)),IF(AND(S25>O25,S25<=P25),2+((S25-O25)/(P25-O25)),IF(AND(S25>P25,S25<=Q25),3+((S25-P25)/(Q25-P25)),IF(AND(S25>Q25,S25<=R25),4+((S25-Q25)/(R25-Q25)),IF(S25>R25,5,ERROR))))))),ABS(IF(S25>=N25,1,IF(AND(S25<N25,S25>=O25),1+((S25-N25)/(O25-N25)),IF(AND(S25<O25,S25>=P25),2+((S25-O25)/(P25-O25)),IF(AND(S25<P25,S25>=Q25),3+((S25-P25)/(Q25-P25)),IF(AND(S25<Q25,S25>=R25),4+((S25-Q25)/(R25-Q25)),IF(S25<R25,5,ERROR))))))))","v":{"v":1,"d":"1.00"}},{"$f":"IF(R25>N25,ABS(IF(U25<=N25,1,IF(AND(U25>N25,U25<=O25),1+((U25-N25)/(O25-N25)),IF(AND(U25>O25,U25<=P25),2+((U25-O25)/(P25-O25)),IF(AND(U25>P25,U25<=Q25),3+((U25-P25)/(Q25-P25)),IF(AND(U25>Q25,U25<=R25),4+((U25-Q25)/(R25-Q25)),IF(U25>R25,5,ERROR))))))),ABS(IF(U25>=N25,1,IF(AND(U25<N25,U25>=O25),1+((U25-N25)/(O25-N25)),IF(AND(U25<O25,U25>=P25),2+((U25-O25)/(P25-O25)),IF(AND(U25<P25,U25>=Q25),3+((U25-P25)/(Q25-P25)),IF(AND(U25<Q25,U25>=R25),4+((U25-Q25)/(R25-Q25)),IF(U25<R25,5,ERROR))))))))","v":{"v":1,"d":"1.00"}}]
[{"$nulls":12},{"v":1,"d":"100%"}]
[]
[null,2,"Reconnections to be done with in 24 hrs of receipt from Credit Management",{"$nulls":4},{"v":0.35,"d":"35%"},2.1,"Reconnections to be done within 24hrs","Hours","Maximo Report ",{"v":0.35,"d":"35%"},{"v":48,"d":"48.00"},{"v":36,"d":"36.00"},{"v":24,"d":"24.00"},{"v":12,"d":"12.00"},{"v":6,"d":"6.00"},{"$nulls":5},{"$f":"IF(R28>N28,ABS(IF(S28<=N28,1,IF(AND(S28>N28,S28<=O28),1+((S28-N28)/(O28-N28)),IF(AND(S28>O28,S28<=P28),2+((S28-O28)/(P28-O28)),IF(AND(S28>P28,S28<=Q28),3+((S28-P28)/(Q28-P28)),IF(AND(S28>Q28,S28<=R28),4+((S28-Q28)/(R28-Q28)),IF(S28>R28,5,ERROR))))))),ABS(IF(S28>=N28,1,IF(AND(S28<N28,S28>=O28),1+((S28-N28)/(O28-N28)),IF(AND(S28<O28,S28>=P28),2+((S28-O28)/(P28-O28)),IF(AND(S28<P28,S28>=Q28),3+((S28-P28)/(Q28-P28)),IF(AND(S28<Q28,S28>=R28),4+((S28-Q28)/(R28-Q28)),IF(S28<R28,5,ERROR))))))))","v":{"v":5,"d":"5.00"}},{"$f":"IF(R28>N28,ABS(IF(U28<=N28,1,IF(AND(U28>N28,U28<=O28),1+((U28-N28)/(O28-N28)),IF(AND(U28>O28,U28<=P28),2+((U28-O28)/(P28-O28)),IF(AND(U28>P28,U28<=Q28),3+((U28-P28)/(Q28-P28)),IF(AND(U28>Q28,U28<=R28),4+((U28-Q28)/(R28-Q28)),IF(U28>R28,5,ERROR))))))),ABS(IF(U28>=N28,1,IF(AND(U28<N28,U28>=O28),1+((U28-N28)/(O28-N28)),IF(AND(U28<O28,U28>=P28),2+((U28-O28)/(P28-O28)),IF(AND(U28<P28,U28>=Q28),3+((U28-P28)/(Q28-P28)),IF(AND(U28<Q28,U28>=R28),4+((U28-Q28)/(R28-Q28)),IF(U28<R28,5,ERROR))))))))","v":{"v":5,"d":"5.00"}}]
[{"$nulls":9},"Scope entails the following:"]
[{"$nulls":9},"Pre-task planning must be done and ensure grouping of reconnections into routes and that work and resources are properly planned"]
[{"$nulls":9},"Check electrical address to physical address",{"$nulls":13},{"$f":"IF(R31>N31,ABS(IF(S31<=N31,1,IF(AND(S31>N31,S31<=O31),1+((S31-N31)/(O31-N31)),IF(AND(S31>O31,S31<=P31),2+((S31-O31)/(P31-O31)),IF(AND(S31>P31,S31<=Q31),3+((S31-P31)/(Q31-P31)),IF(AND(S31>Q31,S31<=R31),4+((S31-Q31)/(R31-Q31)),IF(S31>R31,5,ERROR))))))),ABS(IF(S31>=N31,1,IF(AND(S31<N31,S31>=O31),1+((S31-N31)/(O31-N31)),IF(AND(S31<O31,S31>=P31),2+((S31-O31)/(P31-O31)),IF(AND(S31<P31,S31>=Q31),3+((S31-P31)/(Q31-P31)),IF(AND(S31<Q31,S31>=R31),4+((S31-Q31)/(R31-Q31)),IF(S31<R31,5,ERROR))))))))","v":{"v":1,"d":"1.00"}},{"$f":"IF(R31>N31,ABS(IF(U31<=N31,1,IF(AND(U31>N31,U31<=O31),1+((U31-N31)/(O31-N31)),IF(AND(U31>O31,U31<=P31),2+((U31-O31)/(P31-O31)),IF(AND(U31>P31,U31<=Q31),3+((U31-P31)/(Q31-P31)),IF(AND(U31>Q31,U31<=R31),4+((U31-Q31)/(R31-Q31)),IF(U31>R31,5,ERROR))))))),ABS(IF(U31>=N31,1,IF(AND(U31<N31,U31>=O31),1+((U31-N31)/(O31-N31)),IF(AND(U31<O31,U31>=P31),2+((U31-O31)/(P31-O31)),IF(AND(U31<P31,U31>=Q31),3+((U31-P31)/(Q31-P31)),IF(AND(U31<Q31,U31>=R31),4+((U31-Q31)/(R31-Q31)),IF(U31<R31,5,ERROR))))))))","v":{"v":1,"d":"1.00"}}]
[{"$nulls":9},"Remove seal from meter",{"$nulls":13},{"$f":"IF(R32>N32,ABS(IF(S32<=N32,1,IF(AND(S32>N32,S32<=O32),1+((S32-N32)/(O32-N32)),IF(AND(S32>O32,S32<=P32),2+((S32-O32)/(P32-O32)),IF(AND(S32>P32,S32<=Q32),3+((S32-P32)/(Q32-P32)),IF(AND(S32>Q32,S32<=R32),4+((S32-Q32)/(R32-Q32)),IF(S32>R32,5,ERROR))))))),ABS(IF(S32>=N32,1,IF(AND(S32<N32,S32>=O32),1+((S32-N32)/(O32-N32)),IF(AND(S32<O32,S32>=P32),2+((S32-O32)/(P32-O32)),IF(AND(S32<P32,S32>=Q32),3+((S32-P32)/(Q32-P32)),IF(AND(S32<Q32,S32>=R32),4+((S32-Q32)/(R32-Q32)),IF(S32<R32,5,ERROR))))))))","v":{"v":1,"d":"1.00"}},{"$f":"IF(R32>N32,ABS(IF(U32<=N32,1,IF(AND(U32>N32,U32<=O32),1+((U32-N32)/(O32-N32)),IF(AND(U32>O32,U32<=P32),2+((U32-O32)/(P32-O32)),IF(AND(U32>P32,U32<=Q32),3+((U32-P32)/(Q32-P32)),IF(AND(U32>Q32,U32<=R32),4+((U32-Q32)/(R32-Q32)),IF(U32>R32,5,ERROR))))))),ABS(IF(U32>=N32,1,IF(AND(U32<N32,U32>=O32),1+((U32-N32)/(O32-N32)),IF(AND(U32<O32,U32>=P32),2+((U32-O32)/(P32-O32)),IF(AND(U32<P32,U32>=Q32),3+((U32-P32)/(Q32-P32)),IF(AND(U32<Q32,U32>=R32),4+((U32-Q32)/(R32-Q32)),IF(U32<R32,5,ERROR))))))))","v":{"v":1,"d":"1.00"}}]
[{"$nulls":9},"Untie tail and connect to circuit breaker",{"$nulls":13},{"$f":"IF(R33>N33,ABS(IF(S33<=N33,1,IF(AND(S33>N33,S33<=O33),1+((S33-N33)/(O33-N33)),IF(AND(S33>O33,S33<=P33),2+((S33-O33)/(P33-O33)),IF(AND(S33>P33,S33<=Q33),3+((S33-P33)/(Q33-P33)),IF(AND(S33>Q33,S33<=R33),4+((S33-Q33)/(R33-Q33)),IF(S33>R33,5,ERROR))))))),ABS(IF(S33>=N33,1,IF(AND(S33<N33,S33>=O33),1+((S33-N33)/(O33-N33)),IF(AND(S33<O33,S33>=P33),2+((S33-O33)/(P33-O33)),IF(AND(S33<P33,S33>=Q33),3+((S33-P33)/(Q33-P33)),IF(AND(S33<Q33,S33>=R33),4+((S33-Q33)/(R33-Q33)),IF(S33<R33,5,ERROR))))))))","v":{"v":1,"d":"1.00"}},{"$f":"IF(R33>N33,ABS(IF(U33<=N33,1,IF(AND(U33>N33,U33<=O33),1+((U33-N33)/(O33-N33)),IF(AND(U33>O33,U33<=P33),2+((U33-O33)/(P33-O33)),IF(AND(U33>P33,U33<=Q33),3+((U33-P33)/(Q33-P33)),IF(AND(U33>Q33,U33<=R33),4+((U33-Q33)/(R33-Q33)),IF(U33>R33,5,ERROR))))))),ABS(IF(U33>=N33,1,IF(AND(U33<N33,U33>=O33),1+((U33-N33)/(O33-N33)),IF(AND(U33<O33,U33>=P33),2+((U33-O33)/(P33-O33)),IF(AND(U33<P33,U33>=Q33),3+((U33-P33)/(Q33-P33)),IF(AND(U33<Q33,U33>=R33),4+((U33-Q33)/(R33-Q33)),IF(U33<R33,5,ERROR))))))))","v":{"v":1,"d":"1.00"}}]
[{"$nulls":9},"Take photos: \n*Photo before reconnection\n*Indicate meter number\n*Date and time of reconnection\n*Readings of all meters\n*Photo of work completed( After Reconnection)"]
[{"$nulls":23},{"$f":"IF(R35>N35,ABS(IF(S35<=N35,1,IF(AND(S35>N35,S35<=O35),1+((S35-N35)/(O35-N35)),IF(AND(S35>O35,S35<=P35),2+((S35-O35)/(P35-O35)),IF(AND(S35>P35,S35<=Q35),3+((S35-P35)/(Q35-P35)),IF(AND(S35>Q35,S35<=R35),4+((S35-Q35)/(R35-Q35)),IF(S35>R35,5,ERROR))))))),ABS(IF(S35>=N35,1,IF(AND(S35<N35,S35>=O35),1+((S35-N35)/(O35-N35)),IF(AND(S35<O35,S35>=P35),2+((S35-O35)/(P35-O35)),IF(AND(S35<P35,S35>=Q35),3+((S35-P35)/(Q35-P35)),IF(AND(S35<Q35,S35>=R35),4+((S35-Q35)/(R35-Q35)),IF(S35<R35,5,ERROR))))))))","v":{"v":1,"d":"1.00"}},{"$f":"IF(R35>N35,ABS(IF(U35<=N35,1,IF(AND(U35>N35,U35<=O35),1+((U35-N35)/(O35-N35)),IF(AND(U35>O35,U35<=P35),2+((U35-O35)/(P35-O35)),IF(AND(U35>P35,U35<=Q35),3+((U35-P35)/(Q35-P35)),IF(AND(U35>Q35,U35<=R35),4+((U35-Q35)/(R35-Q35)),IF(U35>R35,5,ERROR))))))),ABS(IF(U35>=N35,1,IF(AND(U35<N35,U35>=O35),1+((U35-N35)/(O35-N35)),IF(AND(U35<O35,U35>=P35),2+((U35-O35)/(P35-O35)),IF(AND(U35<P35,U35>=Q35),3+((U35-P35)/(Q35-P35)),IF(AND(U35<Q35,U35>=R35),4+((U35-Q35)/(R35-Q35)),IF(U35<R35,5,ERROR))))))))","v":{"v":1,"d":"1.00"}}]
[{"$nulls":12},{"v":1,"d":"100%"}]
[null,3,"Meter Changes to be done within 24 hours",{"$nulls":4},{"v":0.05,"d":"5%"},3.1,"Meter changes to be done within 24hrs after receipt from Eskom and feedback to given to Eskom after installation within 24hrs","Hours","Maximo Report ",5,{"v":48,"d":"48.00"},{"v":36,"d":"36.00"},{"v":24,"d":"24.00"},{"v":12,"d":"12.00"},{"v":6,"d":"6.00"},{"$nulls":5},{"$f":"IF(R37>N37,ABS(IF(S37<=N37,1,IF(AND(S37>N37,S37<=O37),1+((S37-N37)/(O37-N37)),IF(AND(S37>O37,S37<=P37),2+((S37-O37)/(P37-O37)),IF(AND(S37>P37,S37<=Q37),3+((S37-P37)/(Q37-P37)),IF(AND(S37>Q37,S37<=R37),4+((S37-Q37)/(R37-Q37)),IF(S37>R37,5,ERROR))))))),ABS(IF(S37>=N37,1,IF(AND(S37<N37,S37>=O37),1+((S37-N37)/(O37-N37)),IF(AND(S37<O37,S37>=P37),2+((S37-O37)/(P37-O37)),IF(AND(S37<P37,S37>=Q37),3+((S37-P37)/(Q37-P37)),IF(AND(S37<Q37,S37>=R37),4+((S37-Q37)/(R37-Q37)),IF(S37<R37,5,ERROR))))))))","v":{"v":5,"d":"5.00"}},{"$f":"IF(R37>N37,ABS(IF(U37<=N37,1,IF(AND(U37>N37,U37<=O37),1+((U37-N37)/(O37-N37)),IF(AND(U37>O37,U37<=P37),2+((U37-O37)/(P37-O37)),IF(AND(U37>P37,U37<=Q37),3+((U37-P37)/(Q37-P37)),IF(AND(U37>Q37,U37<=R37),4+((U37-Q37)/(R37-Q37)),IF(U37>R37,5,ERROR))))))),ABS(IF(U37>=N37,1,IF(AND(U37<N37,U37>=O37),1+((U37-N37)/(O37-N37)),IF(AND(U37<O37,U37>=P37),2+((U37-O37)/(P37-O37)),IF(AND(U37<P37,U37>=Q37),3+((U37-P37)/(Q37-P37)),IF(AND(U37<Q37,U37>=R37),4+((U37-Q37)/(R37-Q37)),IF(U37<R37,5,ERROR))))))))","v":{"v":5,"d":"5.00"}}]
[{"$nulls":9},"Scope entails the following:",{"$nulls":13},{"$f":"IF(R38>N38,ABS(IF(S38<=N38,1,IF(AND(S38>N38,S38<=O38),1+((S38-N38)/(O38-N38)),IF(AND(S38>O38,S38<=P38),2+((S38-O38)/(P38-O38)),IF(AND(S38>P38,S38<=Q38),3+((S38-P38)/(Q38-P38)),IF(AND(S38>Q38,S38<=R38),4+((S38-Q38)/(R38-Q38)),IF(S38>R38,5,ERROR))))))),ABS(IF(S38>=N38,1,IF(AND(S38<N38,S38>=O38),1+((S38-N38)/(O38-N38)),IF(AND(S38<O38,S38>=P38),2+((S38-O38)/(P38-O38)),IF(AND(S38<P38,S38>=Q38),3+((S38-P38)/(Q38-P38)),IF(AND(S38<Q38,S38>=R38),4+((S38-Q38)/(R38-Q38)),IF(S38<R38,5,ERROR))))))))","v":{"v":1,"d":"1.00"}},{"$f":"IF(R38>N38,ABS(IF(U38<=N38,1,IF(AND(U38>N38,U38<=O38),1+((U38-N38)/(O38-N38)),IF(AND(U38>O38,U38<=P38),2+((U38-O38)/(P38-O38)),IF(AND(U38>P38,U38<=Q38),3+((U38-P38)/(Q38-P38)),IF(AND(U38>Q38,U38<=R38),4+((U38-Q38)/(R38-Q38)),IF(U38>R38,5,ERROR))))))),ABS(IF(U38>=N38,1,IF(AND(U38<N38,U38>=O38),1+((U38-N38)/(O38-N38)),IF(AND(U38<O38,U38>=P38),2+((U38-O38)/(P38-O38)),IF(AND(U38<P38,U38>=Q38),3+((U38-P38)/(Q38-P38)),IF(AND(U38<Q38,U38>=R38),4+((U38-Q38)/(R38-Q38)),IF(U38<R38,5,ERROR))))))))","v":{"v":1,"d":"1.00"}}]
[{"$nulls":9},"Change out/Replace Meter of Conventional SPU Meters/ Prepaid Meter Conversions",{"$nulls":13},{"$f":"IF(R39>N39,ABS(IF(S39<=N39,1,IF(AND(S39>N39,S39<=O39),1+((S39-N39)/(O39-N39)),IF(AND(S39>O39,S39<=P39),2+((S39-O39)/(P39-O39)),IF(AND(S39>P39,S39<=Q39),3+((S39-P39)/(Q39-P39)),IF(AND(S39>Q39,S39<=R39),4+((S39-Q39)/(R39-Q39)),IF(S39>R39,5,ERROR))))))),ABS(IF(S39>=N39,1,IF(AND(S39<N39,S39>=O39),1+((S39-N39)/(O39-N39)),IF(AND(S39<O39,S39>=P39),2+((S39-O39)/(P39-O39)),IF(AND(S39<P39,S39>=Q39),3+((S39-P39)/(Q39-P39)),IF(AND(S39<Q39,S39>=R39),4+((S39-Q39)/(R39-Q39)),IF(S39<R39,5,ERROR))))))))","v":{"v":1,"d":"1.00"}},{"$f":"IF(R39>N39,ABS(IF(U39<=N39,1,IF(AND(U39>N39,U39<=O39),1+((U39-N39)/(O39-N39)),IF(AND(U39>O39,U39<=P39),2+((U39-O39)/(P39-O39)),IF(AND(U39>P39,U39<=Q39),3+((U39-P39)/(Q39-P39)),IF(AND(U39>Q39,U39<=R39),4+((U39-Q39)/(R39-Q39)),IF(U39>R39,5,ERROR))))))),ABS(IF(U39>=N39,1,IF(AND(U39<N39,U39>=O39),1+((U39-N39)/(O39-N39)),IF(AND(U39<O39,U39>=P39),2+((U39-O39)/(P39-O39)),IF(AND(U39<P39,U39>=Q39),3+((U39-P39)/(Q39-P39)),IF(AND(U39<Q39,U39>=R39),4+((U39-Q39)/(R39-Q39)),IF(U39<R39,5,ERROR))))))))","v":{"v":1,"d":"1.00"}}]
[{"$nulls":9},"Receive meter change out/replace request from Eskom",{"$nulls":13},{"$f":"IF(R40>N40,ABS(IF(S40<=N40,1,IF(AND(S40>N40,S40<=O40),1+((S40-N40)/(O40-N40)),IF(AND(S40>O40,S40<=P40),2+((S40-O40)/(P40-O40)),IF(AND(S40>P40,S40<=Q40),3+((S40-P40)/(Q40-P40)),IF(AND(S40>Q40,S40<=R40),4+((S40-Q40)/(R40-Q40)),IF(S40>R40,5,ERROR))))))),ABS(IF(S40>=N40,1,IF(AND(S40<N40,S40>=O40),1+((S40-N40)/(O40-N40)),IF(AND(S40<O40,S40>=P40),2+((S40-O40)/(P40-O40)),IF(AND(S40<P40,S40>=Q40),3+((S40-P40)/(Q40-P40)),IF(AND(S40<Q40,S40>=R40),4+((S40-Q40)/(R40-Q40)),IF(S40<R40,5,ERROR))))))))","v":{"v":1,"d":"1.00"}},{"$f":"IF(R40>N40,ABS(IF(U40<=N40,1,IF(AND(U40>N40,U40<=O40),1+((U40-N40)/(O40-N40)),IF(AND(U40>O40,U40<=P40),2+((U40-O40)/(P40-O40)),IF(AND(U40>P40,U40<=Q40),3+((U40-P40)/(Q40-P40)),IF(AND(U40>Q40,U40<=R40),4+((U40-Q40)/(R40-Q40)),IF(U40>R40,5,ERROR))))))),ABS(IF(U40>=N40,1,IF(AND(U40<N40,U40>=O40),1+((U40-N40)/(O40-N40)),IF(AND(U40<O40,U40>=P40),2+((U40-O40)/(P40-O40)),IF(AND(U40<P40,U40>=Q40),3+((U40-P40)/(Q40-P40)),IF(AND(U40<Q40,U40>=R40),4+((U40-Q40)/(R40-Q40)),IF(U40<R40,5,ERROR))))))))","v":{"v":1,"d":"1.00"}}]
[{"$nulls":9},"Pre-task planning must be done and ensure grouping of meter change outs/ replacements into routes and that work and resources are properly planned"]
[{"$nulls":9},"Identify apparatus to be correct by checking Electrical and Physical Address"]
[{"$nulls":9},"Check the status of the supply and check if any illegal reconnections took place"]
[{"$nulls":9},"Take photos: \n*Photo of installation before the meter replacement\n*Indicate meter number\n*Date and time of  meter replacement\n*Readings of all meters\n*Photo of work completed( After meter replacement)"]
[{"$nulls":9},"Log information on the spreadsheet and New meters must be collected from CNC stores and old meters must be returned to CNC stores",{"$nulls":13},{"$f":"IF(R45>N45,ABS(IF(S45<=N45,1,IF(AND(S45>N45,S45<=O45),1+((S45-N45)/(O45-N45)),IF(AND(S45>O45,S45<=P45),2+((S45-O45)/(P45-O45)),IF(AND(S45>P45,S45<=Q45),3+((S45-P45)/(Q45-P45)),IF(AND(S45>Q45,S45<=R45),4+((S45-Q45)/(R45-Q45)),IF(S45>R45,5,ERROR))))))),ABS(IF(S45>=N45,1,IF(AND(S45<N45,S45>=O45),1+((S45-N45)/(O45-N45)),IF(AND(S45<O45,S45>=P45),2+((S45-O45)/(P45-O45)),IF(AND(S45<P45,S45>=Q45),3+((S45-P45)/(Q45-P45)),IF(AND(S45<Q45,S45>=R45),4+((S45-Q45)/(R45-Q45)),IF(S45<R45,5,ERROR))))))))","v":{"v":1,"d":"1.00"}},{"$f":"IF(R45>N45,ABS(IF(U45<=N45,1,IF(AND(U45>N45,U45<=O45),1+((U45-N45)/(O45-N45)),IF(AND(U45>O45,U45<=P45),2+((U45-O45)/(P45-O45)),IF(AND(U45>P45,U45<=Q45),3+((U45-P45)/(Q45-P45)),IF(AND(U45>Q45,U45<=R45),4+((U45-Q45)/(R45-Q45)),IF(U45>R45,5,ERROR))))))),ABS(IF(U45>=N45,1,IF(AND(U45<N45,U45>=O45),1+((U45-N45)/(O45-N45)),IF(AND(U45<O45,U45>=P45),2+((U45-O45)/(P45-O45)),IF(AND(U45<P45,U45>=Q45),3+((U45-P45)/(Q45-P45)),IF(AND(U45<Q45,U45>=R45),4+((U45-Q45)/(R45-Q45)),IF(U45<R45,5,ERROR))))))))","v":{"v":1,"d":"1.00"}}]
[{"$nulls":12},{"v":1,"d":"100%"}]
[null,4,"Vehicle inspections and Authorizations",{"$nulls":4},{"v":0.2,"d":"20%"},4.1,"Vehicle inspections to be done monthly:\n*Check for cracked windows and no dents or smash on body of vehicle, seat belts in working order\n*Eskom Branded stickers to be visible an to be in good order. Stickers to be purchased by Contractors on Eskom specification.\n*Drivers Licence to be valid for all authorized drivers.\n*Tyres to be in good condition and All vehicles to include 2 triangles in an event of an emergency.                                                                                                                                                                                                                                                                                                                          ","Months","Vehichle inspection reports",{"v":0.05,"d":"5%"},{"v":6,"d":"6.00"},{"v":8,"d":"8.00"},{"v":12,"d":"12.00"},{"v":14,"d":"14.00"},{"v":18,"d":"18.00"},null,{"$f":"IF(AND(ISNUMBER(P47),ISNUMBER(S47)),X47,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(AND(ISNUMBER(P47),ISNUMBER(U47)),Y47,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(R47>N47,ABS(IF(S47<=N47,1,IF(AND(S47>N47,S47<=O47),1+((S47-N47)/(O47-N47)),IF(AND(S47>O47,S47<=P47),2+((S47-O47)/(P47-O47)),IF(AND(S47>P47,S47<=Q47),3+((S47-P47)/(Q47-P47)),IF(AND(S47>Q47,S47<=R47),4+((S47-Q47)/(R47-Q47)),IF(S47>R47,5,ERROR))))))),ABS(IF(S47>=N47,1,IF(AND(S47<N47,S47>=O47),1+((S47-N47)/(O47-N47)),IF(AND(S47<O47,S47>=P47),2+((S47-O47)/(P47-O47)),IF(AND(S47<P47,S47>=Q47),3+((S47-P47)/(Q47-P47)),IF(AND(S47<Q47,S47>=R47),4+((S47-Q47)/(R47-Q47)),IF(S47<R47,5,ERROR))))))))","v":{"v":1,"d":"1.00"}},{"$f":"IF(R47>N47,ABS(IF(U47<=N47,1,IF(AND(U47>N47,U47<=O47),1+((U47-N47)/(O47-N47)),IF(AND(U47>O47,U47<=P47),2+((U47-O47)/(P47-O47)),IF(AND(U47>P47,U47<=Q47),3+((U47-P47)/(Q47-P47)),IF(AND(U47>Q47,U47<=R47),4+((U47-Q47)/(R47-Q47)),IF(U47>R47,5,ERROR))))))),ABS(IF(U47>=N47,1,IF(AND(U47<N47,U47>=O47),1+((U47-N47)/(O47-N47)),IF(AND(U47<O47,U47>=P47),2+((U47-O47)/(P47-O47)),IF(AND(U47<P47,U47>=Q47),3+((U47-P47)/(Q47-P47)),IF(AND(U47<Q47,U47>=R47),4+((U47-Q47)/(R47-Q47)),IF(U47<R47,5,ERROR))))))))","v":{"v":1,"d":"1.00"}}]
[{"$nulls":9},"Valid Roadworthy Certificates for all vehicles ( 5 Vehicles)","No of certificates ","No of vehicles ",{"v":0.05,"d":"5%"},{"v":3,"d":"3.00"},{"v":4,"d":"4.00"},{"v":5,"d":"5.00"},{"v":6,"d":"6.00"},{"v":7,"d":"7.00"},{"$nulls":5},{"$f":"IF(R48>N48,ABS(IF(S48<=N48,1,IF(AND(S48>N48,S48<=O48),1+((S48-N48)/(O48-N48)),IF(AND(S48>O48,S48<=P48),2+((S48-O48)/(P48-O48)),IF(AND(S48>P48,S48<=Q48),3+((S48-P48)/(Q48-P48)),IF(AND(S48>Q48,S48<=R48),4+((S48-Q48)/(R48-Q48)),IF(S48>R48,5,ERROR))))))),ABS(IF(S48>=N48,1,IF(AND(S48<N48,S48>=O48),1+((S48-N48)/(O48-N48)),IF(AND(S48<O48,S48>=P48),2+((S48-O48)/(P48-O48)),IF(AND(S48<P48,S48>=Q48),3+((S48-P48)/(Q48-P48)),IF(AND(S48<Q48,S48>=R48),4+((S48-Q48)/(R48-Q48)),IF(S48<R48,5,ERROR))))))))","v":{"v":1,"d":"1.00"}},{"$f":"IF(R48>N48,ABS(IF(U48<=N48,1,IF(AND(U48>N48,U48<=O48),1+((U48-N48)/(O48-N48)),IF(AND(U48>O48,U48<=P48),2+((U48-O48)/(P48-O48)),IF(AND(U48>P48,U48<=Q48),3+((U48-P48)/(Q48-P48)),IF(AND(U48>Q48,U48<=R48),4+((U48-Q48)/(R48-Q48)),IF(U48>R48,5,ERROR))))))),ABS(IF(U48>=N48,1,IF(AND(U48<N48,U48>=O48),1+((U48-N48)/(O48-N48)),IF(AND(U48<O48,U48>=P48),2+((U48-O48)/(P48-O48)),IF(AND(U48<P48,U48>=Q48),3+((U48-P48)/(Q48-P48)),IF(AND(U48<Q48,U48>=R48),4+((U48-Q48)/(R48-Q48)),IF(U48<R48,5,ERROR))))))))","v":{"v":1,"d":"1.00"}}]
[{"$nulls":9},"All technicians to be authrized according to LV practice( Minimum of 5 Authorized Technicians) and should be valid. Renewal to be done in 3 months in advance before expiration of authorizations.","No of Authorizations","Authorization certificates",{"v":0.1,"d":"10%"},{"v":3,"d":"3.00"},{"v":4,"d":"4.00"},{"v":5,"d":"5.00"},{"v":6,"d":"6.00"},{"v":7,"d":"7.00"},{"$nulls":5},{"$f":"IF(R49>N49,ABS(IF(S49<=N49,1,IF(AND(S49>N49,S49<=O49),1+((S49-N49)/(O49-N49)),IF(AND(S49>O49,S49<=P49),2+((S49-O49)/(P49-O49)),IF(AND(S49>P49,S49<=Q49),3+((S49-P49)/(Q49-P49)),IF(AND(S49>Q49,S49<=R49),4+((S49-Q49)/(R49-Q49)),IF(S49>R49,5,ERROR))))))),ABS(IF(S49>=N49,1,IF(AND(S49<N49,S49>=O49),1+((S49-N49)/(O49-N49)),IF(AND(S49<O49,S49>=P49),2+((S49-O49)/(P49-O49)),IF(AND(S49<P49,S49>=Q49),3+((S49-P49)/(Q49-P49)),IF(AND(S49<Q49,S49>=R49),4+((S49-Q49)/(R49-Q49)),IF(S49<R49,5,ERROR))))))))","v":{"v":1,"d":"1.00"}},{"$f":"IF(R49>N49,ABS(IF(U49<=N49,1,IF(AND(U49>N49,U49<=O49),1+((U49-N49)/(O49-N49)),IF(AND(U49>O49,U49<=P49),2+((U49-O49)/(P49-O49)),IF(AND(U49>P49,U49<=Q49),3+((U49-P49)/(Q49-P49)),IF(AND(U49>Q49,U49<=R49),4+((U49-Q49)/(R49-Q49)),IF(U49>R49,5,ERROR))))))),ABS(IF(U49>=N49,1,IF(AND(U49<N49,U49>=O49),1+((U49-N49)/(O49-N49)),IF(AND(U49<O49,U49>=P49),2+((U49-O49)/(P49-O49)),IF(AND(U49<P49,U49>=Q49),3+((U49-P49)/(Q49-P49)),IF(AND(U49<Q49,U49>=R49),4+((U49-Q49)/(R49-Q49)),IF(U49<R49,5,ERROR))))))))","v":{"v":1,"d":"1.00"}}]
[{"$nulls":12},{"v":0,"d":"0%"},8]
[]
[{"$nulls":3},"Total Weight",{"$nulls":3},{"$f":"H17+H28+H37+H47","v":{"v":1,"d":"100%"}}]
[]
[null,"Notes:"]
[null,"1) Complete only the required information."]
[null,null,"(DO NOT DELETE OR ADD ANY ROWS OR COLUMNS. DO NOT ALTER FORMULAE) "]
[null,"2) The weights of the KPAs must add up to 100% and that the weights for the KPIs within each KPA must add up to 100%."]
[null,"3) Format cells in the \"Target setting area\"  by \"right\" clicking on the cell and choosing the approriate option."]
[null,"4) For non-managerial staff, KPA 4 has a 100% weighting"]
[null,"5) There is a limit of 5 KPIs for KPA 4"]
[null,"6) Provision on this manual template has been made so that each of the 5 KPIs under KPA 4 can be unpacked i.e.  detail for the 5 KPIs under KPA 4 is accomodated"]