{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Report","Normalized","Scratch"],"not_rendered":{"external_links":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Report","index":0,"n_rows":63,"n_cols":22,"rows_kept":63,"merged":[[0,0,0,12],[0,13,0,15],[1,0,1,2],[1,3,1,5],[1,6,1,9],[1,10,1,12],[1,13,1,15],[2,0,2,2],[2,3,2,5],[2,6,2,9],[2,10,2,12],[2,13,2,15],[3,0,3,15],[4,0,4,7],[4,8,4,15],[5,0,5,7],[5,8,5,15],[6,0,6,7],[6,8,6,15],[7,7,7,8],[8,7,8,8],[9,7,9,8],[10,7,10,8],[11,7,11,8],[12,7,12,8],[13,7,13,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[17,7,17,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[22,7,22,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[26,7,26,8],[27,7,27,8],[28,7,28,8],[29,7,29,8],[30,7,30,8],[31,7,31,8],[32,7,32,8],[33,7,33,8],[34,7,34,8],[35,7,35,8],[36,7,36,8],[37,7,37,8],[38,7,38,8],[39,7,39,8],[40,7,40,8],[41,7,41,8],[42,7,42,8],[43,7,43,8],[44,7,44,8],[45,7,45,8],[46,7,46,8],[47,7,47,8],[48,7,48,8],[49,7,49,8],[50,7,50,8],[51,7,51,8],[52,1,52,7],[53,7,53,8],[54,7,54,8],[56,7,56,8],[57,7,57,8],[57,13,57,15],[58,7,58,8],[58,13,58,15],[58,18,58,21],[59,7,59,8],[59,13,59,15],[59,18,59,21],[60,7,60,8],[60,13,60,15],[61,7,61,8],[62,0,62,23],[63,0,63,23],[64,0,64,23],[65,0,65,23],[66,0,66,23]]}
["Chapter > Summary PALMS Report",{"$nulls":12},""]
["Running User",null,null,"Run At",null,null,"Country",{"$nulls":3},"Region",null,null,"Chapter"]
[{"$nulls":6},"Canada",{"$nulls":3},"Alberta South"]
["Parameters"]
["Chapter:"]
["From:",{"$nulls":17},"Traffic"]
["To:",{"$nulls":17},"Lights"]
["First Name","Last Name","P","A","L","M","S","RGI",null,"RGO","RRI","RRO","V","1-2-1","TYFCB","CEU",null,null,"Score",null,"RGI:RGO","Referral Alerts"]
[{"$nulls":18},{"$f":"Scratch!G2","v":""},null,{"$f":"IF(ISBLANK(H9),\"\",IF(AND(H9=0,J9=0),\"None yet\",IFERROR(\"1 : \"&ROUND(J9/H9,2),\"All external\")))","v":""},{"$f":"IF(OR(ISBLANK(J9),AND(H9=0,J9=0)),\"\",IF(H9>=J9,\"Too many internal referrals\",\"\"))","v":""}]
[{"$nulls":18},{"$f":"Scratch!G3","v":""},null,{"$f":"IF(ISBLANK(H10),\"\",IF(AND(H10=0,J10=0),\"None yet\",IFERROR(\"1 : \"&ROUND(J10/H10,2),\"All external\")))","v":""},{"$f":"IF(OR(ISBLANK(J10),AND(H10=0,J10=0)),\"\",IF(H10>=J10,\"Too many internal referrals\",\"\"))","v":""}]
[{"$nulls":18},{"$f":"Scratch!G4","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G5","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G6","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G7","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G8","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G9","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G10","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G11","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G12","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G13","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G14","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G15","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G16","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G17","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G18","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G19","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G20","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G21","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G22","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G23","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G24","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G25","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G26","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G27","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G28","v":""},null,{"$f":"IF(ISBLANK(H35),\"\",IF(AND(H35=0,J35=0),\"None yet\",IFERROR(\"1 : \"&ROUND(J35/H35,1),\"All external\")))","v":""},""]
[{"$nulls":18},{"$f":"Scratch!G29","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G30","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G31","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G32","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G33","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G34","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G35","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G36","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G37","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G38","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G39","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G40","v":""},null,"",""]
[{"$nulls":18},{"$f":"Scratch!G41","v":""},null,"",""]
["Visitor"]
["BNI"]
[null,"Totals:",{"$f":"SUM(C9:C50)","v":0},0,0,0,0,0,null,{"$f":"SUM(J9:J50)","v":0},0,0,0,0,{"v":0,"d":"$0.00"},0]
[]
[null,"Percentage in Each Colour by Category",{"$nulls":12},"Top 4 members",{"$nulls":5},"Legend"]
[null,"Traffic Lights Score",{"$f":"IFERROR(COUNTIF(Scratch!$G$2:$G$41,\">=70\")/(COUNTA(Scratch!$G$2:$G$41)-COUNTIF(Scratch!$G$2:$G$41,\"\")),\"\")","v":""},{"$f":"IFERROR(COUNTIFS(Scratch!$G$2:$G$41,\">=50\",Scratch!$G$2:$G$41,\"<70\")/(COUNTA(Scratch!$G$2:$G$41)-COUNTIF(Scratch!$G$2:$G$41,\"\")),\"\")","v":""},{"$f":"IFERROR(COUNTIFS(Scratch!$G$2:$G$41,\">=25\",Scratch!$G$2:$G$41,\"<50\")/(COUNTA(Scratch!$G$2:$G$41)-COUNTIF(Scratch!$G$2:$G$41,\"\")),\"\")","v":""},{"$f":"IFERROR(COUNTIF(Scratch!$G$2:$G$41,\"<25\")/(COUNTA(Scratch!$G$2:$G$41)-COUNTIF(Scratch!$G$2:$G$41,\"\")),\"\")","v":""},{"$nulls":8},"were thanked for ",{"$nulls":5},"> 1 : 3"]
[null,"Attendance",{"$f":"IFERROR(COUNTIF(Scratch!$B$2:$B$41,20)/(COUNTA(Scratch!$C$2:$C$41)-COUNTIF(Scratch!$C$2:$C$41,\"\")),\"\")","v":""},{"$f":"IFERROR(COUNTIF(Scratch!$B$2:$B$41,15)/(COUNTA(Scratch!$C$2:$C$41)-COUNTIF(Scratch!$C$2:$C$41,\"\")),\"\")","v":""},{"$f":"IFERROR(COUNTIF(Scratch!$B$2:$B$41,10)/(COUNTA(Scratch!$C$2:$C$41)-COUNTIF(Scratch!$C$2:$C$41,\"\")),\"\")","v":""},{"$f":"IFERROR(COUNTIF(Scratch!$B$2:$B$41,\"<=5\")/(COUNTA(Scratch!$C$2:$C$41)-COUNTIF(Scratch!$C$2:$C$41,\"\")),\"\")","v":""},{"$nulls":8},{"$f":"IFERROR(ROUND(100*(LARGE(O9:O35,1)+LARGE(O9:O35,2)+LARGE(O9:O35,3)+LARGE(O9:O35,4))/SUM(O9:O35),0),\"–\") & \"% of chapter's\"","v":"–% of chapter's"},{"$nulls":5},"> 1 : 2"]
[null,"Referrals",{"$f":"IFERROR(COUNTIF(Scratch!$C$2:$C$41,20)/(COUNTA(Scratch!$C$2:$C$41)-COUNTIF(Scratch!$C$2:$C$41,\"\")),\"\")","v":""},{"$f":"IFERROR(COUNTIF(Scratch!$C$2:$C$41,15)/(COUNTA(Scratch!$C$2:$C$41)-COUNTIF(Scratch!$C$2:$C$41,\"\")),\"\")","v":""},{"$f":"IFERROR(COUNTIF(Scratch!$C$2:$C$41,10)/(COUNTA(Scratch!$C$2:$C$41)-COUNTIF(Scratch!$C$2:$C$41,\"\")),\"\")","v":""},{"$f":"IFERROR(COUNTIF(Scratch!$C$2:$C$41,\"<=5\")/(COUNTA(Scratch!$C$2:$C$41)-COUNTIF(Scratch!$C$2:$C$41,\"\")),\"\")","v":""},{"$f":"\"1 : \"&IFERROR(ROUND(J51/H51,2),\"\")","v":"1 : "},"Referral Ratio (Inside:Outside)",{"$nulls":6},"closed business.",{"$nulls":5},"> 1 : 1"]
[null,"Visitors",{"$f":"IFERROR(COUNTIF(Scratch!$D$2:$D$41,20)/(COUNTA(Scratch!$D$2:$D$41)-COUNTIF(Scratch!$D$2:$D$41,\"\")),\"\")","v":""},{"$f":"IFERROR(COUNTIF(Scratch!$D$2:$D$41,15)/(COUNTA(Scratch!$D$2:$D$41)-COUNTIF(Scratch!$D$2:$D$41,\"\")),\"\")","v":""},{"$f":"IFERROR(COUNTIF(Scratch!$D$2:$D$41,10)/(COUNTA(Scratch!$D$2:$D$41)-COUNTIF(Scratch!$D$2:$D$41,\"\")),\"\")","v":""},{"$f":"IFERROR(COUNTIF(Scratch!$D$2:$D$41,\"<=5\")/(COUNTA(Scratch!$D$2:$D$41)-COUNTIF(Scratch!$D$2:$D$41,\"\")),\"\")","v":""},{"$nulls":14},"<= 1 : 1"]
[null,"1-2-1s",{"$f":"IFERROR(COUNTIF(Scratch!$E$2:$E$41,20)/(COUNTA(Scratch!$E$2:$E$41)-COUNTIF(Scratch!$E$2:$E$41,\"\")),\"\")","v":""},{"$f":"IFERROR(COUNTIF(Scratch!$E$2:$E$41,15)/(COUNTA(Scratch!$E$2:$E$41)-COUNTIF(Scratch!$E$2:$E$41,\"\")),\"\")","v":""},{"$f":"IFERROR(COUNTIF(Scratch!$E$2:$E$41,10)/(COUNTA(Scratch!$E$2:$E$41)-COUNTIF(Scratch!$E$2:$E$41,\"\")),\"\")","v":""},{"$f":"IFERROR(COUNTIF(Scratch!$E$2:$E$41,\"<=5\")/(COUNTA(Scratch!$E$2:$E$41)-COUNTIF(Scratch!$E$2:$E$41,\"\")),\"\")","v":""},{"$nulls":7},"80/20 Rule Analysis"]
[null,"CEUs",{"$f":"IFERROR(COUNTIF(Scratch!$F$2:$F$41,20)/(COUNTA(Scratch!$F$2:$F$41)-COUNTIF(Scratch!$F$2:$F$41,\"\")),\"\")","v":""},{"$f":"IFERROR(COUNTIF(Scratch!$F$2:$F$41,15)/(COUNTA(Scratch!$F$2:$F$41)-COUNTIF(Scratch!$F$2:$F$41,\"\")),\"\")","v":""},{"$f":"IFERROR(COUNTIF(Scratch!$F$2:$F$41,10)/(COUNTA(Scratch!$F$2:$F$41)-COUNTIF(Scratch!$F$2:$F$41,\"\")),\"\")","v":""},{"$f":"IFERROR(COUNTIF(Scratch!$F$2:$F$41,\"<=5\")/(COUNTA(Scratch!$F$2:$F$41)-COUNTIF(Scratch!$F$2:$F$41,\"\")),\"\")","v":""},{"$nulls":7},"The top 20% of the chapter's",{"$nulls":4},"PALMS Analysis Tool V2.1"]
[{"$nulls":13},{"$f":"\"members (\" & IFERROR(ROUND(0.2*COUNTA($A$9:$A$48),0),\"Oops\") & \") were thanked\"","v":"members (0) were thanked"},{"$nulls":4},"© 2016 Richard Sherry"]
[{"$nulls":13},{"$f":"IFERROR(ROUND(100*(IF(IFERROR(ROUND(0.2*COUNTA($A$9:$A$48),0),\"\")<1,0,LARGE($O$9:$O$48,1))+IF(IFERROR(ROUND(0.2*COUNTA($A$9:$A$48),0),\"\")<2,0,LARGE($O$9:$O$48,2))+IF(IFERROR(ROUND(0.2*COUNTA($A$9:$A$48),0),\"\")<3,0,LARGE($O$9:$O$48,3))+IF(IFERROR(ROUND(0.2*COUNTA($A$9:$A$48),0),\"\")<4,0,LARGE($O$9:$O$48,4))+IF(IFERROR(ROUND(0.2*COUNTA($A$9:$A$48),0),\"\")<5,0,LARGE($O$9:$O$48,5))+IF(IFERROR(ROUND(0.2*COUNTA($A$9:$A$48),0),\"\")<6,0,LARGE($O$9:$O$48,6))+IF(IFERROR(ROUND(0.2*COUNTA($A$9:$A$48),0),\"\")<7,0,LARGE($O$9:$O$48,7))+IF(IFERROR(ROUND(0.2*COUNTA($A$9:$A$48),0),\"\")<8,0,LARGE($O$9:$O$48,8))+IF(IFERROR(ROUND(0.2*COUNTA($A$9:$A$48),0),\"\")<9,0,LARGE($O$9:$O$48,9))+IF(IFERROR(ROUND(0.2*COUNTA($A$9:$A$48),0),\"\")<10,0,LARGE($O$9:$O$48,10)))/SUM($O$9:$O$48),0),\"–\")&\"% of chapter's TYFCB given.\"","v":"–% of chapter's TYFCB given."}]
["Here are some suggested \"Easy Wins\""]
[{"$f":"IFERROR(IF(C54+D54>0.75,\"Wow! \",\"\")&IF(C54+D54<0.5,\"Oh, oh...\",\"\")&IF(C54+D54>=0.5,ROUND(100*(C54+D54),0)&\"% of members' Traffic Lights score is green or yellow. \" & IF(C54+D54>0.75,\"Fantastic! \",\"Good. \"),\"only \"&ROUND(100*(C54+D54),0)&\"% of members' Traffic Lights score is green or yellow. \")&IF(C54+D54<0.5,\"You should focus your efforts on getting them more active, which will encourage the other members to do more.\",IF(SUM(E54:F54)=0,\"Having no scores in the red and gray is fantastic too!\",IF(E54=0,\"You might want to focus on the \"&ROUND(100*F54,0)&\"% of members in the gray.\",\"You might want to focus on encouraging the \"&ROUND(100*E54,0)&\"% of members in the red to become more active.\"))),\"\")","v":""}]

{"sheet":"Normalized","index":1,"n_rows":48,"n_cols":14,"rows_kept":48,"hidden":true,"merged":[[0,0,0,12],[0,13,0,15],[1,0,1,2],[1,3,1,5],[1,6,1,9],[1,10,1,12],[1,13,1,15],[2,0,2,2],[2,3,2,5],[2,6,2,9],[2,10,2,12],[2,13,2,15],[4,0,4,7],[4,8,4,15],[5,0,5,7],[5,8,5,15],[6,0,6,7],[6,8,6,15],[7,7,7,8],[8,7,8,8],[9,7,9,8],[10,7,10,8],[11,7,11,8],[12,7,12,8],[13,7,13,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[17,7,17,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[22,7,22,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[26,7,26,8],[27,7,27,8],[28,7,28,8],[29,7,29,8],[30,7,30,8],[31,7,31,8],[32,7,32,8],[33,7,33,8],[34,7,34,8],[35,7,35,8],[36,7,36,8],[37,7,37,8],[38,7,38,8],[39,7,39,8],[40,7,40,8],[41,7,41,8],[42,7,42,8],[43,7,43,8],[44,7,44,8],[45,7,45,8],[46,7,46,8],[47,7,47,8],[48,7,48,8]]}
[{"$f":"Report!A1","v":"Chapter > Summary PALMS Report"}]
[{"$f":"Report!A2","v":"Running User"},null,null,{"$f":"Report!D2","v":"Run At"},null,null,{"$f":"Report!G2","v":"Country"},{"$nulls":3},{"$f":"Report!K2","v":"Region"},null,null,{"$f":"Report!N2","v":"Chapter"}]
[{"$f":"IF(ISBLANK(Report!A3),\"\",Report!A3)","v":""},null,null,{"$f":"IF(ISBLANK(Report!D3),\"\",Report!D3)","v":""},null,null,{"$f":"IF(ISBLANK(Report!G3),\"\",Report!G3)","v":"Canada"},{"$nulls":3},{"$f":"IF(ISBLANK(Report!K3),\"\",Report!K3)","v":"Alberta South"},null,null,{"$f":"IF(ISBLANK(Report!N3),\"\",Report!N3)","v":""}]
[{"$f":"Report!A4","v":"Parameters"},null,null,"Normalize to:"]
[{"$f":"Report!A5","v":"Chapter:"},{"$nulls":7},{"$f":"IF(ISBLANK(Report!I5),\"\",Report!I5)","v":""}]
[{"$f":"Report!A6","v":"From:"},{"$nulls":7},{"$f":"IF(ISBLANK(Report!I6),\"\",Report!I6)","v":""}]
[{"$f":"Report!A7","v":"To:"},{"$nulls":7},{"$f":"IF(ISBLANK(Report!I7),\"\",Report!I7)","v":""}]
[{"$f":"Report!A8","v":"First Name"},{"$f":"Report!B8","v":"Last Name"},{"$f":"Report!C8","v":"P"},{"$f":"Report!D8","v":"A"},{"$f":"Report!E8","v":"L"},{"$f":"Report!F8","v":"M"},{"$f":"Report!G8","v":"S"},{"$f":"Report!H8","v":"RGI"},null,{"$f":"Report!J8","v":"RGO"}]
[{"$f":"IF(ISBLANK(Report!A9),\"\",Report!A9)","v":""},{"$f":"IF(ISBLANK(Report!B9),\"\",Report!B9)","v":""}]
[{"$f":"IF(ISBLANK(Report!A10),\"\",Report!A10)","v":""},{"$f":"IF(ISBLANK(Report!B10),\"\",Report!B10)","v":""}]
[{"$f":"IF(ISBLANK(Report!A11),\"\",Report!A11)","v":""},{"$f":"IF(ISBLANK(Report!B11),\"\",Report!B11)","v":""}]
[{"$f":"IF(ISBLANK(Report!A12),\"\",Report!A12)","v":""},{"$f":"IF(ISBLANK(Report!B12),\"\",Report!B12)","v":""}]
[{"$f":"IF(ISBLANK(Report!A13),\"\",Report!A13)","v":""},{"$f":"IF(ISBLANK(Report!B13),\"\",Report!B13)","v":""}]
[{"$f":"IF(ISBLANK(Report!A14),\"\",Report!A14)","v":""},{"$f":"IF(ISBLANK(Report!B14),\"\",Report!B14)","v":""}]
[{"$f":"IF(ISBLANK(Report!A15),\"\",Report!A15)","v":""},{"$f":"IF(ISBLANK(Report!B15),\"\",Report!B15)","v":""}]
[{"$f":"IF(ISBLANK(Report!A16),\"\",Report!A16)","v":""},{"$f":"IF(ISBLANK(Report!B16),\"\",Report!B16)","v":""}]
[{"$f":"IF(ISBLANK(Report!A17),\"\",Report!A17)","v":""},{"$f":"IF(ISBLANK(Report!B17),\"\",Report!B17)","v":""}]
[{"$f":"IF(ISBLANK(Report!A18),\"\",Report!A18)","v":""},{"$f":"IF(ISBLANK(Report!B18),\"\",Report!B18)","v":""}]
[{"$f":"IF(ISBLANK(Report!A19),\"\",Report!A19)","v":""},{"$f":"IF(ISBLANK(Report!B19),\"\",Report!B19)","v":""}]
[{"$f":"IF(ISBLANK(Report!A20),\"\",Report!A20)","v":""},{"$f":"IF(ISBLANK(Report!B20),\"\",Report!B20)","v":""}]
[{"$f":"IF(ISBLANK(Report!A21),\"\",Report!A21)","v":""},{"$f":"IF(ISBLANK(Report!B21),\"\",Report!B21)","v":""}]
[{"$f":"IF(ISBLANK(Report!A22),\"\",Report!A22)","v":""},{"$f":"IF(ISBLANK(Report!B22),\"\",Report!B22)","v":""}]
[{"$f":"IF(ISBLANK(Report!A23),\"\",Report!A23)","v":""},{"$f":"IF(ISBLANK(Report!B23),\"\",Report!B23)","v":""}]
[{"$f":"IF(ISBLANK(Report!A24),\"\",Report!A24)","v":""},{"$f":"IF(ISBLANK(Report!B24),\"\",Report!B24)","v":""}]
[{"$f":"IF(ISBLANK(Report!A25),\"\",Report!A25)","v":""},{"$f":"IF(ISBLANK(Report!B25),\"\",Report!B25)","v":""}]
[{"$f":"IF(ISBLANK(Report!A26),\"\",Report!A26)","v":""},{"$f":"IF(ISBLANK(Report!B26),\"\",Report!B26)","v":""}]
[{"$f":"IF(ISBLANK(Report!A27),\"\",Report!A27)","v":""},{"$f":"IF(ISBLANK(Report!B27),\"\",Report!B27)","v":""}]
[{"$f":"IF(ISBLANK(Report!A28),\"\",Report!A28)","v":""},{"$f":"IF(ISBLANK(Report!B28),\"\",Report!B28)","v":""}]
[{"$f":"IF(ISBLANK(Report!A29),\"\",Report!A29)","v":""},{"$f":"IF(ISBLANK(Report!B29),\"\",Report!B29)","v":""}]
[{"$f":"IF(ISBLANK(Report!A30),\"\",Report!A30)","v":""},{"$f":"IF(ISBLANK(Report!B30),\"\",Report!B30)","v":""}]
[{"$f":"IF(ISBLANK(Report!A31),\"\",Report!A31)","v":""},{"$f":"IF(ISBLANK(Report!B31),\"\",Report!B31)","v":""}]
[{"$f":"IF(ISBLANK(Report!A32),\"\",Report!A32)","v":""},{"$f":"IF(ISBLANK(Report!B32),\"\",Report!B32)","v":""}]
[{"$f":"IF(ISBLANK(Report!A33),\"\",Report!A33)","v":""},{"$f":"IF(ISBLANK(Report!B33),\"\",Report!B33)","v":""}]
[{"$f":"IF(ISBLANK(Report!A34),\"\",Report!A34)","v":""},{"$f":"IF(ISBLANK(Report!B34),\"\",Report!B34)","v":""}]
[{"$f":"IF(ISBLANK(Report!A35),\"\",Report!A35)","v":""},{"$f":"IF(ISBLANK(Report!B35),\"\",Report!B35)","v":""}]
[{"$f":"IF(ISBLANK(Report!A36),\"\",Report!A36)","v":""},{"$f":"IF(ISBLANK(Report!B36),\"\",Report!B36)","v":""}]
[{"$f":"IF(ISBLANK(Report!A37),\"\",Report!A37)","v":""},{"$f":"IF(ISBLANK(Report!B37),\"\",Report!B37)","v":""}]
[{"$f":"IF(ISBLANK(Report!A38),\"\",Report!A38)","v":""},{"$f":"IF(ISBLANK(Report!B38),\"\",Report!B38)","v":""}]
[{"$f":"IF(ISBLANK(Report!A39),\"\",Report!A39)","v":""},{"$f":"IF(ISBLANK(Report!B39),\"\",Report!B39)","v":""}]
[{"$f":"IF(ISBLANK(Report!A40),\"\",Report!A40)","v":""},{"$f":"IF(ISBLANK(Report!B40),\"\",Report!B40)","v":""}]
[{"$f":"IF(ISBLANK(Report!A41),\"\",Report!A41)","v":""},{"$f":"IF(ISBLANK(Report!B41),\"\",Report!B41)","v":""}]
[{"$f":"IF(ISBLANK(Report!A42),\"\",Report!A42)","v":""},{"$f":"IF(ISBLANK(Report!B42),\"\",Report!B42)","v":""}]
[{"$f":"IF(ISBLANK(Report!A43),\"\",Report!A43)","v":""},{"$f":"IF(ISBLANK(Report!B43),\"\",Report!B43)","v":""}]
[{"$f":"IF(ISBLANK(Report!A44),\"\",Report!A44)","v":""},{"$f":"IF(ISBLANK(Report!B44),\"\",Report!B44)","v":""}]
[{"$f":"IF(ISBLANK(Report!A45),\"\",Report!A45)","v":""},{"$f":"IF(ISBLANK(Report!B45),\"\",Report!B45)","v":""}]
[{"$f":"IF(ISBLANK(Report!A46),\"\",Report!A46)","v":""},{"$f":"IF(ISBLANK(Report!B46),\"\",Report!B46)","v":""}]
[{"$f":"IF(ISBLANK(Report!A47),\"\",Report!A47)","v":""},{"$f":"IF(ISBLANK(Report!B47),\"\",Report!B47)","v":""}]
[{"$f":"IF(ISBLANK(Report!A48),\"\",Report!A48)","v":""},{"$f":"IF(ISBLANK(Report!B48),\"\",Report!B48)","v":""}]

{"sheet":"Scratch","index":2,"n_rows":43,"n_cols":7,"rows_kept":43,"hidden":true}
["First Name","Att","Referrals","Visitors","121s","CEUs","Total"]
[{"$f":"IF(OR(ISBLANK(Report!A9),Report!A9=0),\"\",Report!A9)","v":""},{"$f":"IFERROR(IF((Report!$C9+Report!$E9*0.5+Report!$G9*0.5)/SUM(Report!C9:E9,Report!G9)<=0.65,0,IF((Report!$C9+Report!$E9*0.5+Report!$G9*0.5)/SUM(Report!C9:E9,Report!G9)<=0.75,5,IF((Report!$C9+Report!$E9*0.5+Report!$G9*0.5)/SUM(Report!C9:E9,Report!G9)<=0.85,10,IF((Report!$C9+Report!$E9*0.5+Report!$G9*0.5)/SUM(Report!C9:E9,Report!G9)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H9+Report!$J9)/SUM(Report!$C9:'Report'!$G9)<=0.25,0,IF((Report!$H9+Report!$J9)/SUM(Report!$C9:'Report'!$G9)<=0.5,5,IF((Report!$H9+Report!$J9)/SUM(Report!$C9:'Report'!$G9)<=0.75,10,IF((Report!$H9+Report!$J9)/SUM(Report!$C9:'Report'!$G9)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M9/(SUM(Report!$C9:$G9)/4.333)<=0.25,0,IF(Report!$M9/(SUM(Report!$C9:$G9)/4.333)<=0.5,5,IF(Report!$M9/(SUM(Report!$C9:$G9)/4.333)<=0.75,10,IF(Report!$M9/(SUM(Report!$C9:$G9)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N9/SUM(Report!C9:E9,Report!G9)<=0.25,0,IF(Report!N9/SUM(Report!C9:E9,Report!G9)<=0.5,5,IF(Report!N9/SUM(Report!C9:E9,Report!G9)<0.75,10,IF(Report!N9/SUM(Report!C9:E9,Report!G9)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P9/SUM(Report!C9:E9,Report!G9)<=0.25,0,IF(Report!P9/SUM(Report!C9:E9,Report!G9)<=0.5,5,IF(Report!P9/SUM(Report!C9:E9,Report!G9)<=0.75,10,IF(Report!P9/SUM(Report!C9:E9,Report!G9)<=1,15,20)))),\"\")","v":""},{"$f":"IF(SUM(B2:F2)=0,\"\",SUM(B2:F2))","v":""}]
[{"$f":"IF(OR(ISBLANK(Report!A10),Report!A10=0),\"\",Report!A10)","v":""},{"$f":"IFERROR(IF((Report!$C10+Report!$E10*0.5+Report!$G10*0.5)/SUM(Report!C10:E10,Report!G10)<=0.65,0,IF((Report!$C10+Report!$E10*0.5+Report!$G10*0.5)/SUM(Report!C10:E10,Report!G10)<=0.75,5,IF((Report!$C10+Report!$E10*0.5+Report!$G10*0.5)/SUM(Report!C10:E10,Report!G10)<=0.85,10,IF((Report!$C10+Report!$E10*0.5+Report!$G10*0.5)/SUM(Report!C10:E10,Report!G10)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H10+Report!$J10)/SUM(Report!$C10:'Report'!$G10)<=0.25,0,IF((Report!$H10+Report!$J10)/SUM(Report!$C10:'Report'!$G10)<=0.5,5,IF((Report!$H10+Report!$J10)/SUM(Report!$C10:'Report'!$G10)<=0.75,10,IF((Report!$H10+Report!$J10)/SUM(Report!$C10:'Report'!$G10)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M10/(SUM(Report!$C10:$G10)/4.333)<=0.25,0,IF(Report!$M10/(SUM(Report!$C10:$G10)/4.333)<=0.5,5,IF(Report!$M10/(SUM(Report!$C10:$G10)/4.333)<=0.75,10,IF(Report!$M10/(SUM(Report!$C10:$G10)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N10/SUM(Report!C10:E10,Report!G10)<=0.25,0,IF(Report!N10/SUM(Report!C10:E10,Report!G10)<=0.5,5,IF(Report!N10/SUM(Report!C10:E10,Report!G10)<0.75,10,IF(Report!N10/SUM(Report!C10:E10,Report!G10)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P10/SUM(Report!C10:E10,Report!G10)<=0.25,0,IF(Report!P10/SUM(Report!C10:E10,Report!G10)<=0.5,5,IF(Report!P10/SUM(Report!C10:E10,Report!G10)<=0.75,10,IF(Report!P10/SUM(Report!C10:E10,Report!G10)<=1,15,20)))),\"\")","v":""},{"$f":"IF(SUM(B3:F3)=0,\"\",SUM(B3:F3))","v":""}]
[{"$f":"IF(OR(ISBLANK(Report!A11),Report!A11=0),\"\",Report!A11)","v":""},{"$f":"IFERROR(IF((Report!$C11+Report!$E11*0.5+Report!$G11*0.5)/SUM(Report!C11:E11,Report!G11)<=0.65,0,IF((Report!$C11+Report!$E11*0.5+Report!$G11*0.5)/SUM(Report!C11:E11,Report!G11)<=0.75,5,IF((Report!$C11+Report!$E11*0.5+Report!$G11*0.5)/SUM(Report!C11:E11,Report!G11)<=0.85,10,IF((Report!$C11+Report!$E11*0.5+Report!$G11*0.5)/SUM(Report!C11:E11,Report!G11)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H11+Report!$J11)/SUM(Report!$C11:'Report'!$G11)<=0.25,0,IF((Report!$H11+Report!$J11)/SUM(Report!$C11:'Report'!$G11)<=0.5,5,IF((Report!$H11+Report!$J11)/SUM(Report!$C11:'Report'!$G11)<=0.75,10,IF((Report!$H11+Report!$J11)/SUM(Report!$C11:'Report'!$G11)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M11/(SUM(Report!$C11:$G11)/4.333)<=0.25,0,IF(Report!$M11/(SUM(Report!$C11:$G11)/4.333)<=0.5,5,IF(Report!$M11/(SUM(Report!$C11:$G11)/4.333)<=0.75,10,IF(Report!$M11/(SUM(Report!$C11:$G11)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N11/SUM(Report!C11:E11,Report!G11)<=0.25,0,IF(Report!N11/SUM(Report!C11:E11,Report!G11)<=0.5,5,IF(Report!N11/SUM(Report!C11:E11,Report!G11)<0.75,10,IF(Report!N11/SUM(Report!C11:E11,Report!G11)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P11/SUM(Report!C11:E11,Report!G11)<=0.25,0,IF(Report!P11/SUM(Report!C11:E11,Report!G11)<=0.5,5,IF(Report!P11/SUM(Report!C11:E11,Report!G11)<=0.75,10,IF(Report!P11/SUM(Report!C11:E11,Report!G11)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A12),Report!A12=0),\"\",Report!A12)","v":""},{"$f":"IFERROR(IF((Report!$C12+Report!$E12*0.5+Report!$G12*0.5)/SUM(Report!C12:E12,Report!G12)<=0.65,0,IF((Report!$C12+Report!$E12*0.5+Report!$G12*0.5)/SUM(Report!C12:E12,Report!G12)<=0.75,5,IF((Report!$C12+Report!$E12*0.5+Report!$G12*0.5)/SUM(Report!C12:E12,Report!G12)<=0.85,10,IF((Report!$C12+Report!$E12*0.5+Report!$G12*0.5)/SUM(Report!C12:E12,Report!G12)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H12+Report!$J12)/SUM(Report!$C12:'Report'!$G12)<=0.25,0,IF((Report!$H12+Report!$J12)/SUM(Report!$C12:'Report'!$G12)<=0.5,5,IF((Report!$H12+Report!$J12)/SUM(Report!$C12:'Report'!$G12)<=0.75,10,IF((Report!$H12+Report!$J12)/SUM(Report!$C12:'Report'!$G12)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M12/(SUM(Report!$C12:$G12)/4.333)<=0.25,0,IF(Report!$M12/(SUM(Report!$C12:$G12)/4.333)<=0.5,5,IF(Report!$M12/(SUM(Report!$C12:$G12)/4.333)<=0.75,10,IF(Report!$M12/(SUM(Report!$C12:$G12)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N12/SUM(Report!C12:E12,Report!G12)<=0.25,0,IF(Report!N12/SUM(Report!C12:E12,Report!G12)<=0.5,5,IF(Report!N12/SUM(Report!C12:E12,Report!G12)<0.75,10,IF(Report!N12/SUM(Report!C12:E12,Report!G12)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P12/SUM(Report!C12:E12,Report!G12)<=0.25,0,IF(Report!P12/SUM(Report!C12:E12,Report!G12)<=0.5,5,IF(Report!P12/SUM(Report!C12:E12,Report!G12)<=0.75,10,IF(Report!P12/SUM(Report!C12:E12,Report!G12)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A13),Report!A13=0),\"\",Report!A13)","v":""},{"$f":"IFERROR(IF((Report!$C13+Report!$E13*0.5+Report!$G13*0.5)/SUM(Report!C13:E13,Report!G13)<=0.65,0,IF((Report!$C13+Report!$E13*0.5+Report!$G13*0.5)/SUM(Report!C13:E13,Report!G13)<=0.75,5,IF((Report!$C13+Report!$E13*0.5+Report!$G13*0.5)/SUM(Report!C13:E13,Report!G13)<=0.85,10,IF((Report!$C13+Report!$E13*0.5+Report!$G13*0.5)/SUM(Report!C13:E13,Report!G13)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H13+Report!$J13)/SUM(Report!$C13:'Report'!$G13)<=0.25,0,IF((Report!$H13+Report!$J13)/SUM(Report!$C13:'Report'!$G13)<=0.5,5,IF((Report!$H13+Report!$J13)/SUM(Report!$C13:'Report'!$G13)<=0.75,10,IF((Report!$H13+Report!$J13)/SUM(Report!$C13:'Report'!$G13)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M13/(SUM(Report!$C13:$G13)/4.333)<=0.25,0,IF(Report!$M13/(SUM(Report!$C13:$G13)/4.333)<=0.5,5,IF(Report!$M13/(SUM(Report!$C13:$G13)/4.333)<=0.75,10,IF(Report!$M13/(SUM(Report!$C13:$G13)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N13/SUM(Report!C13:E13,Report!G13)<=0.25,0,IF(Report!N13/SUM(Report!C13:E13,Report!G13)<=0.5,5,IF(Report!N13/SUM(Report!C13:E13,Report!G13)<0.75,10,IF(Report!N13/SUM(Report!C13:E13,Report!G13)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P13/SUM(Report!C13:E13,Report!G13)<=0.25,0,IF(Report!P13/SUM(Report!C13:E13,Report!G13)<=0.5,5,IF(Report!P13/SUM(Report!C13:E13,Report!G13)<=0.75,10,IF(Report!P13/SUM(Report!C13:E13,Report!G13)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A14),Report!A14=0),\"\",Report!A14)","v":""},{"$f":"IFERROR(IF((Report!$C14+Report!$E14*0.5+Report!$G14*0.5)/SUM(Report!C14:E14,Report!G14)<=0.65,0,IF((Report!$C14+Report!$E14*0.5+Report!$G14*0.5)/SUM(Report!C14:E14,Report!G14)<=0.75,5,IF((Report!$C14+Report!$E14*0.5+Report!$G14*0.5)/SUM(Report!C14:E14,Report!G14)<=0.85,10,IF((Report!$C14+Report!$E14*0.5+Report!$G14*0.5)/SUM(Report!C14:E14,Report!G14)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H14+Report!$J14)/SUM(Report!$C14:'Report'!$G14)<=0.25,0,IF((Report!$H14+Report!$J14)/SUM(Report!$C14:'Report'!$G14)<=0.5,5,IF((Report!$H14+Report!$J14)/SUM(Report!$C14:'Report'!$G14)<=0.75,10,IF((Report!$H14+Report!$J14)/SUM(Report!$C14:'Report'!$G14)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M14/(SUM(Report!$C14:$G14)/4.333)<=0.25,0,IF(Report!$M14/(SUM(Report!$C14:$G14)/4.333)<=0.5,5,IF(Report!$M14/(SUM(Report!$C14:$G14)/4.333)<=0.75,10,IF(Report!$M14/(SUM(Report!$C14:$G14)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N14/SUM(Report!C14:E14,Report!G14)<=0.25,0,IF(Report!N14/SUM(Report!C14:E14,Report!G14)<=0.5,5,IF(Report!N14/SUM(Report!C14:E14,Report!G14)<0.75,10,IF(Report!N14/SUM(Report!C14:E14,Report!G14)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P14/SUM(Report!C14:E14,Report!G14)<=0.25,0,IF(Report!P14/SUM(Report!C14:E14,Report!G14)<=0.5,5,IF(Report!P14/SUM(Report!C14:E14,Report!G14)<=0.75,10,IF(Report!P14/SUM(Report!C14:E14,Report!G14)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A15),Report!A15=0),\"\",Report!A15)","v":""},{"$f":"IFERROR(IF((Report!$C15+Report!$E15*0.5+Report!$G15*0.5)/SUM(Report!C15:E15,Report!G15)<=0.65,0,IF((Report!$C15+Report!$E15*0.5+Report!$G15*0.5)/SUM(Report!C15:E15,Report!G15)<=0.75,5,IF((Report!$C15+Report!$E15*0.5+Report!$G15*0.5)/SUM(Report!C15:E15,Report!G15)<=0.85,10,IF((Report!$C15+Report!$E15*0.5+Report!$G15*0.5)/SUM(Report!C15:E15,Report!G15)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H15+Report!$J15)/SUM(Report!$C15:'Report'!$G15)<=0.25,0,IF((Report!$H15+Report!$J15)/SUM(Report!$C15:'Report'!$G15)<=0.5,5,IF((Report!$H15+Report!$J15)/SUM(Report!$C15:'Report'!$G15)<=0.75,10,IF((Report!$H15+Report!$J15)/SUM(Report!$C15:'Report'!$G15)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M15/(SUM(Report!$C15:$G15)/4.333)<=0.25,0,IF(Report!$M15/(SUM(Report!$C15:$G15)/4.333)<=0.5,5,IF(Report!$M15/(SUM(Report!$C15:$G15)/4.333)<=0.75,10,IF(Report!$M15/(SUM(Report!$C15:$G15)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N15/SUM(Report!C15:E15,Report!G15)<=0.25,0,IF(Report!N15/SUM(Report!C15:E15,Report!G15)<=0.5,5,IF(Report!N15/SUM(Report!C15:E15,Report!G15)<0.75,10,IF(Report!N15/SUM(Report!C15:E15,Report!G15)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P15/SUM(Report!C15:E15,Report!G15)<=0.25,0,IF(Report!P15/SUM(Report!C15:E15,Report!G15)<=0.5,5,IF(Report!P15/SUM(Report!C15:E15,Report!G15)<=0.75,10,IF(Report!P15/SUM(Report!C15:E15,Report!G15)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A16),Report!A16=0),\"\",Report!A16)","v":""},{"$f":"IFERROR(IF((Report!$C16+Report!$E16*0.5+Report!$G16*0.5)/SUM(Report!C16:E16,Report!G16)<=0.65,0,IF((Report!$C16+Report!$E16*0.5+Report!$G16*0.5)/SUM(Report!C16:E16,Report!G16)<=0.75,5,IF((Report!$C16+Report!$E16*0.5+Report!$G16*0.5)/SUM(Report!C16:E16,Report!G16)<=0.85,10,IF((Report!$C16+Report!$E16*0.5+Report!$G16*0.5)/SUM(Report!C16:E16,Report!G16)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H16+Report!$J16)/SUM(Report!$C16:'Report'!$G16)<=0.25,0,IF((Report!$H16+Report!$J16)/SUM(Report!$C16:'Report'!$G16)<=0.5,5,IF((Report!$H16+Report!$J16)/SUM(Report!$C16:'Report'!$G16)<=0.75,10,IF((Report!$H16+Report!$J16)/SUM(Report!$C16:'Report'!$G16)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M16/(SUM(Report!$C16:$G16)/4.333)<=0.25,0,IF(Report!$M16/(SUM(Report!$C16:$G16)/4.333)<=0.5,5,IF(Report!$M16/(SUM(Report!$C16:$G16)/4.333)<=0.75,10,IF(Report!$M16/(SUM(Report!$C16:$G16)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N16/SUM(Report!C16:E16,Report!G16)<=0.25,0,IF(Report!N16/SUM(Report!C16:E16,Report!G16)<=0.5,5,IF(Report!N16/SUM(Report!C16:E16,Report!G16)<0.75,10,IF(Report!N16/SUM(Report!C16:E16,Report!G16)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P16/SUM(Report!C16:E16,Report!G16)<=0.25,0,IF(Report!P16/SUM(Report!C16:E16,Report!G16)<=0.5,5,IF(Report!P16/SUM(Report!C16:E16,Report!G16)<=0.75,10,IF(Report!P16/SUM(Report!C16:E16,Report!G16)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A17),Report!A17=0),\"\",Report!A17)","v":""},{"$f":"IFERROR(IF((Report!$C17+Report!$E17*0.5+Report!$G17*0.5)/SUM(Report!C17:E17,Report!G17)<=0.65,0,IF((Report!$C17+Report!$E17*0.5+Report!$G17*0.5)/SUM(Report!C17:E17,Report!G17)<=0.75,5,IF((Report!$C17+Report!$E17*0.5+Report!$G17*0.5)/SUM(Report!C17:E17,Report!G17)<=0.85,10,IF((Report!$C17+Report!$E17*0.5+Report!$G17*0.5)/SUM(Report!C17:E17,Report!G17)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H17+Report!$J17)/SUM(Report!$C17:'Report'!$G17)<=0.25,0,IF((Report!$H17+Report!$J17)/SUM(Report!$C17:'Report'!$G17)<=0.5,5,IF((Report!$H17+Report!$J17)/SUM(Report!$C17:'Report'!$G17)<=0.75,10,IF((Report!$H17+Report!$J17)/SUM(Report!$C17:'Report'!$G17)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M17/(SUM(Report!$C17:$G17)/4.333)<=0.25,0,IF(Report!$M17/(SUM(Report!$C17:$G17)/4.333)<=0.5,5,IF(Report!$M17/(SUM(Report!$C17:$G17)/4.333)<=0.75,10,IF(Report!$M17/(SUM(Report!$C17:$G17)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N17/SUM(Report!C17:E17,Report!G17)<=0.25,0,IF(Report!N17/SUM(Report!C17:E17,Report!G17)<=0.5,5,IF(Report!N17/SUM(Report!C17:E17,Report!G17)<0.75,10,IF(Report!N17/SUM(Report!C17:E17,Report!G17)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P17/SUM(Report!C17:E17,Report!G17)<=0.25,0,IF(Report!P17/SUM(Report!C17:E17,Report!G17)<=0.5,5,IF(Report!P17/SUM(Report!C17:E17,Report!G17)<=0.75,10,IF(Report!P17/SUM(Report!C17:E17,Report!G17)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A18),Report!A18=0),\"\",Report!A18)","v":""},{"$f":"IFERROR(IF((Report!$C18+Report!$E18*0.5+Report!$G18*0.5)/SUM(Report!C18:E18,Report!G18)<=0.65,0,IF((Report!$C18+Report!$E18*0.5+Report!$G18*0.5)/SUM(Report!C18:E18,Report!G18)<=0.75,5,IF((Report!$C18+Report!$E18*0.5+Report!$G18*0.5)/SUM(Report!C18:E18,Report!G18)<=0.85,10,IF((Report!$C18+Report!$E18*0.5+Report!$G18*0.5)/SUM(Report!C18:E18,Report!G18)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H18+Report!$J18)/SUM(Report!$C18:'Report'!$G18)<=0.25,0,IF((Report!$H18+Report!$J18)/SUM(Report!$C18:'Report'!$G18)<=0.5,5,IF((Report!$H18+Report!$J18)/SUM(Report!$C18:'Report'!$G18)<=0.75,10,IF((Report!$H18+Report!$J18)/SUM(Report!$C18:'Report'!$G18)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M18/(SUM(Report!$C18:$G18)/4.333)<=0.25,0,IF(Report!$M18/(SUM(Report!$C18:$G18)/4.333)<=0.5,5,IF(Report!$M18/(SUM(Report!$C18:$G18)/4.333)<=0.75,10,IF(Report!$M18/(SUM(Report!$C18:$G18)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N18/SUM(Report!C18:E18,Report!G18)<=0.25,0,IF(Report!N18/SUM(Report!C18:E18,Report!G18)<=0.5,5,IF(Report!N18/SUM(Report!C18:E18,Report!G18)<0.75,10,IF(Report!N18/SUM(Report!C18:E18,Report!G18)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P18/SUM(Report!C18:E18,Report!G18)<=0.25,0,IF(Report!P18/SUM(Report!C18:E18,Report!G18)<=0.5,5,IF(Report!P18/SUM(Report!C18:E18,Report!G18)<=0.75,10,IF(Report!P18/SUM(Report!C18:E18,Report!G18)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A19),Report!A19=0),\"\",Report!A19)","v":""},{"$f":"IFERROR(IF((Report!$C19+Report!$E19*0.5+Report!$G19*0.5)/SUM(Report!C19:E19,Report!G19)<=0.65,0,IF((Report!$C19+Report!$E19*0.5+Report!$G19*0.5)/SUM(Report!C19:E19,Report!G19)<=0.75,5,IF((Report!$C19+Report!$E19*0.5+Report!$G19*0.5)/SUM(Report!C19:E19,Report!G19)<=0.85,10,IF((Report!$C19+Report!$E19*0.5+Report!$G19*0.5)/SUM(Report!C19:E19,Report!G19)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H19+Report!$J19)/SUM(Report!$C19:'Report'!$G19)<=0.25,0,IF((Report!$H19+Report!$J19)/SUM(Report!$C19:'Report'!$G19)<=0.5,5,IF((Report!$H19+Report!$J19)/SUM(Report!$C19:'Report'!$G19)<=0.75,10,IF((Report!$H19+Report!$J19)/SUM(Report!$C19:'Report'!$G19)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M19/(SUM(Report!$C19:$G19)/4.333)<=0.25,0,IF(Report!$M19/(SUM(Report!$C19:$G19)/4.333)<=0.5,5,IF(Report!$M19/(SUM(Report!$C19:$G19)/4.333)<=0.75,10,IF(Report!$M19/(SUM(Report!$C19:$G19)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N19/SUM(Report!C19:E19,Report!G19)<=0.25,0,IF(Report!N19/SUM(Report!C19:E19,Report!G19)<=0.5,5,IF(Report!N19/SUM(Report!C19:E19,Report!G19)<0.75,10,IF(Report!N19/SUM(Report!C19:E19,Report!G19)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P19/SUM(Report!C19:E19,Report!G19)<=0.25,0,IF(Report!P19/SUM(Report!C19:E19,Report!G19)<=0.5,5,IF(Report!P19/SUM(Report!C19:E19,Report!G19)<=0.75,10,IF(Report!P19/SUM(Report!C19:E19,Report!G19)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A20),Report!A20=0),\"\",Report!A20)","v":""},{"$f":"IFERROR(IF((Report!$C20+Report!$E20*0.5+Report!$G20*0.5)/SUM(Report!C20:E20,Report!G20)<=0.65,0,IF((Report!$C20+Report!$E20*0.5+Report!$G20*0.5)/SUM(Report!C20:E20,Report!G20)<=0.75,5,IF((Report!$C20+Report!$E20*0.5+Report!$G20*0.5)/SUM(Report!C20:E20,Report!G20)<=0.85,10,IF((Report!$C20+Report!$E20*0.5+Report!$G20*0.5)/SUM(Report!C20:E20,Report!G20)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H20+Report!$J20)/SUM(Report!$C20:'Report'!$G20)<=0.25,0,IF((Report!$H20+Report!$J20)/SUM(Report!$C20:'Report'!$G20)<=0.5,5,IF((Report!$H20+Report!$J20)/SUM(Report!$C20:'Report'!$G20)<=0.75,10,IF((Report!$H20+Report!$J20)/SUM(Report!$C20:'Report'!$G20)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M20/(SUM(Report!$C20:$G20)/4.333)<=0.25,0,IF(Report!$M20/(SUM(Report!$C20:$G20)/4.333)<=0.5,5,IF(Report!$M20/(SUM(Report!$C20:$G20)/4.333)<=0.75,10,IF(Report!$M20/(SUM(Report!$C20:$G20)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N20/SUM(Report!C20:E20,Report!G20)<=0.25,0,IF(Report!N20/SUM(Report!C20:E20,Report!G20)<=0.5,5,IF(Report!N20/SUM(Report!C20:E20,Report!G20)<0.75,10,IF(Report!N20/SUM(Report!C20:E20,Report!G20)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P20/SUM(Report!C20:E20,Report!G20)<=0.25,0,IF(Report!P20/SUM(Report!C20:E20,Report!G20)<=0.5,5,IF(Report!P20/SUM(Report!C20:E20,Report!G20)<=0.75,10,IF(Report!P20/SUM(Report!C20:E20,Report!G20)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A21),Report!A21=0),\"\",Report!A21)","v":""},{"$f":"IFERROR(IF((Report!$C21+Report!$E21*0.5+Report!$G21*0.5)/SUM(Report!C21:E21,Report!G21)<=0.65,0,IF((Report!$C21+Report!$E21*0.5+Report!$G21*0.5)/SUM(Report!C21:E21,Report!G21)<=0.75,5,IF((Report!$C21+Report!$E21*0.5+Report!$G21*0.5)/SUM(Report!C21:E21,Report!G21)<=0.85,10,IF((Report!$C21+Report!$E21*0.5+Report!$G21*0.5)/SUM(Report!C21:E21,Report!G21)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H21+Report!$J21)/SUM(Report!$C21:'Report'!$G21)<=0.25,0,IF((Report!$H21+Report!$J21)/SUM(Report!$C21:'Report'!$G21)<=0.5,5,IF((Report!$H21+Report!$J21)/SUM(Report!$C21:'Report'!$G21)<=0.75,10,IF((Report!$H21+Report!$J21)/SUM(Report!$C21:'Report'!$G21)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M21/(SUM(Report!$C21:$G21)/4.333)<=0.25,0,IF(Report!$M21/(SUM(Report!$C21:$G21)/4.333)<=0.5,5,IF(Report!$M21/(SUM(Report!$C21:$G21)/4.333)<=0.75,10,IF(Report!$M21/(SUM(Report!$C21:$G21)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N21/SUM(Report!C21:E21,Report!G21)<=0.25,0,IF(Report!N21/SUM(Report!C21:E21,Report!G21)<=0.5,5,IF(Report!N21/SUM(Report!C21:E21,Report!G21)<0.75,10,IF(Report!N21/SUM(Report!C21:E21,Report!G21)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P21/SUM(Report!C21:E21,Report!G21)<=0.25,0,IF(Report!P21/SUM(Report!C21:E21,Report!G21)<=0.5,5,IF(Report!P21/SUM(Report!C21:E21,Report!G21)<=0.75,10,IF(Report!P21/SUM(Report!C21:E21,Report!G21)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A22),Report!A22=0),\"\",Report!A22)","v":""},{"$f":"IFERROR(IF((Report!$C22+Report!$E22*0.5+Report!$G22*0.5)/SUM(Report!C22:E22,Report!G22)<=0.65,0,IF((Report!$C22+Report!$E22*0.5+Report!$G22*0.5)/SUM(Report!C22:E22,Report!G22)<=0.75,5,IF((Report!$C22+Report!$E22*0.5+Report!$G22*0.5)/SUM(Report!C22:E22,Report!G22)<=0.85,10,IF((Report!$C22+Report!$E22*0.5+Report!$G22*0.5)/SUM(Report!C22:E22,Report!G22)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H22+Report!$J22)/SUM(Report!$C22:'Report'!$G22)<=0.25,0,IF((Report!$H22+Report!$J22)/SUM(Report!$C22:'Report'!$G22)<=0.5,5,IF((Report!$H22+Report!$J22)/SUM(Report!$C22:'Report'!$G22)<=0.75,10,IF((Report!$H22+Report!$J22)/SUM(Report!$C22:'Report'!$G22)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M22/(SUM(Report!$C22:$G22)/4.333)<=0.25,0,IF(Report!$M22/(SUM(Report!$C22:$G22)/4.333)<=0.5,5,IF(Report!$M22/(SUM(Report!$C22:$G22)/4.333)<=0.75,10,IF(Report!$M22/(SUM(Report!$C22:$G22)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N22/SUM(Report!C22:E22,Report!G22)<=0.25,0,IF(Report!N22/SUM(Report!C22:E22,Report!G22)<=0.5,5,IF(Report!N22/SUM(Report!C22:E22,Report!G22)<0.75,10,IF(Report!N22/SUM(Report!C22:E22,Report!G22)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P22/SUM(Report!C22:E22,Report!G22)<=0.25,0,IF(Report!P22/SUM(Report!C22:E22,Report!G22)<=0.5,5,IF(Report!P22/SUM(Report!C22:E22,Report!G22)<=0.75,10,IF(Report!P22/SUM(Report!C22:E22,Report!G22)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A23),Report!A23=0),\"\",Report!A23)","v":""},{"$f":"IFERROR(IF((Report!$C23+Report!$E23*0.5+Report!$G23*0.5)/SUM(Report!C23:E23,Report!G23)<=0.65,0,IF((Report!$C23+Report!$E23*0.5+Report!$G23*0.5)/SUM(Report!C23:E23,Report!G23)<=0.75,5,IF((Report!$C23+Report!$E23*0.5+Report!$G23*0.5)/SUM(Report!C23:E23,Report!G23)<=0.85,10,IF((Report!$C23+Report!$E23*0.5+Report!$G23*0.5)/SUM(Report!C23:E23,Report!G23)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H23+Report!$J23)/SUM(Report!$C23:'Report'!$G23)<=0.25,0,IF((Report!$H23+Report!$J23)/SUM(Report!$C23:'Report'!$G23)<=0.5,5,IF((Report!$H23+Report!$J23)/SUM(Report!$C23:'Report'!$G23)<=0.75,10,IF((Report!$H23+Report!$J23)/SUM(Report!$C23:'Report'!$G23)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M23/(SUM(Report!$C23:$G23)/4.333)<=0.25,0,IF(Report!$M23/(SUM(Report!$C23:$G23)/4.333)<=0.5,5,IF(Report!$M23/(SUM(Report!$C23:$G23)/4.333)<=0.75,10,IF(Report!$M23/(SUM(Report!$C23:$G23)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N23/SUM(Report!C23:E23,Report!G23)<=0.25,0,IF(Report!N23/SUM(Report!C23:E23,Report!G23)<=0.5,5,IF(Report!N23/SUM(Report!C23:E23,Report!G23)<0.75,10,IF(Report!N23/SUM(Report!C23:E23,Report!G23)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P23/SUM(Report!C23:E23,Report!G23)<=0.25,0,IF(Report!P23/SUM(Report!C23:E23,Report!G23)<=0.5,5,IF(Report!P23/SUM(Report!C23:E23,Report!G23)<=0.75,10,IF(Report!P23/SUM(Report!C23:E23,Report!G23)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A24),Report!A24=0),\"\",Report!A24)","v":""},{"$f":"IFERROR(IF((Report!$C24+Report!$E24*0.5+Report!$G24*0.5)/SUM(Report!C24:E24,Report!G24)<=0.65,0,IF((Report!$C24+Report!$E24*0.5+Report!$G24*0.5)/SUM(Report!C24:E24,Report!G24)<=0.75,5,IF((Report!$C24+Report!$E24*0.5+Report!$G24*0.5)/SUM(Report!C24:E24,Report!G24)<=0.85,10,IF((Report!$C24+Report!$E24*0.5+Report!$G24*0.5)/SUM(Report!C24:E24,Report!G24)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H24+Report!$J24)/SUM(Report!$C24:'Report'!$G24)<=0.25,0,IF((Report!$H24+Report!$J24)/SUM(Report!$C24:'Report'!$G24)<=0.5,5,IF((Report!$H24+Report!$J24)/SUM(Report!$C24:'Report'!$G24)<=0.75,10,IF((Report!$H24+Report!$J24)/SUM(Report!$C24:'Report'!$G24)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M24/(SUM(Report!$C24:$G24)/4.333)<=0.25,0,IF(Report!$M24/(SUM(Report!$C24:$G24)/4.333)<=0.5,5,IF(Report!$M24/(SUM(Report!$C24:$G24)/4.333)<=0.75,10,IF(Report!$M24/(SUM(Report!$C24:$G24)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N24/SUM(Report!C24:E24,Report!G24)<=0.25,0,IF(Report!N24/SUM(Report!C24:E24,Report!G24)<=0.5,5,IF(Report!N24/SUM(Report!C24:E24,Report!G24)<0.75,10,IF(Report!N24/SUM(Report!C24:E24,Report!G24)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P24/SUM(Report!C24:E24,Report!G24)<=0.25,0,IF(Report!P24/SUM(Report!C24:E24,Report!G24)<=0.5,5,IF(Report!P24/SUM(Report!C24:E24,Report!G24)<=0.75,10,IF(Report!P24/SUM(Report!C24:E24,Report!G24)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A25),Report!A25=0),\"\",Report!A25)","v":""},{"$f":"IFERROR(IF((Report!$C25+Report!$E25*0.5+Report!$G25*0.5)/SUM(Report!C25:E25,Report!G25)<=0.65,0,IF((Report!$C25+Report!$E25*0.5+Report!$G25*0.5)/SUM(Report!C25:E25,Report!G25)<=0.75,5,IF((Report!$C25+Report!$E25*0.5+Report!$G25*0.5)/SUM(Report!C25:E25,Report!G25)<=0.85,10,IF((Report!$C25+Report!$E25*0.5+Report!$G25*0.5)/SUM(Report!C25:E25,Report!G25)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H25+Report!$J25)/SUM(Report!$C25:'Report'!$G25)<=0.25,0,IF((Report!$H25+Report!$J25)/SUM(Report!$C25:'Report'!$G25)<=0.5,5,IF((Report!$H25+Report!$J25)/SUM(Report!$C25:'Report'!$G25)<=0.75,10,IF((Report!$H25+Report!$J25)/SUM(Report!$C25:'Report'!$G25)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M25/(SUM(Report!$C25:$G25)/4.333)<=0.25,0,IF(Report!$M25/(SUM(Report!$C25:$G25)/4.333)<=0.5,5,IF(Report!$M25/(SUM(Report!$C25:$G25)/4.333)<=0.75,10,IF(Report!$M25/(SUM(Report!$C25:$G25)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N25/SUM(Report!C25:E25,Report!G25)<=0.25,0,IF(Report!N25/SUM(Report!C25:E25,Report!G25)<=0.5,5,IF(Report!N25/SUM(Report!C25:E25,Report!G25)<0.75,10,IF(Report!N25/SUM(Report!C25:E25,Report!G25)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P25/SUM(Report!C25:E25,Report!G25)<=0.25,0,IF(Report!P25/SUM(Report!C25:E25,Report!G25)<=0.5,5,IF(Report!P25/SUM(Report!C25:E25,Report!G25)<=0.75,10,IF(Report!P25/SUM(Report!C25:E25,Report!G25)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A26),Report!A26=0),\"\",Report!A26)","v":""},{"$f":"IFERROR(IF((Report!$C26+Report!$E26*0.5+Report!$G26*0.5)/SUM(Report!C26:E26,Report!G26)<=0.65,0,IF((Report!$C26+Report!$E26*0.5+Report!$G26*0.5)/SUM(Report!C26:E26,Report!G26)<=0.75,5,IF((Report!$C26+Report!$E26*0.5+Report!$G26*0.5)/SUM(Report!C26:E26,Report!G26)<=0.85,10,IF((Report!$C26+Report!$E26*0.5+Report!$G26*0.5)/SUM(Report!C26:E26,Report!G26)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H26+Report!$J26)/SUM(Report!$C26:'Report'!$G26)<=0.25,0,IF((Report!$H26+Report!$J26)/SUM(Report!$C26:'Report'!$G26)<=0.5,5,IF((Report!$H26+Report!$J26)/SUM(Report!$C26:'Report'!$G26)<=0.75,10,IF((Report!$H26+Report!$J26)/SUM(Report!$C26:'Report'!$G26)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M26/(SUM(Report!$C26:$G26)/4.333)<=0.25,0,IF(Report!$M26/(SUM(Report!$C26:$G26)/4.333)<=0.5,5,IF(Report!$M26/(SUM(Report!$C26:$G26)/4.333)<=0.75,10,IF(Report!$M26/(SUM(Report!$C26:$G26)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N26/SUM(Report!C26:E26,Report!G26)<=0.25,0,IF(Report!N26/SUM(Report!C26:E26,Report!G26)<=0.5,5,IF(Report!N26/SUM(Report!C26:E26,Report!G26)<0.75,10,IF(Report!N26/SUM(Report!C26:E26,Report!G26)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P26/SUM(Report!C26:E26,Report!G26)<=0.25,0,IF(Report!P26/SUM(Report!C26:E26,Report!G26)<=0.5,5,IF(Report!P26/SUM(Report!C26:E26,Report!G26)<=0.75,10,IF(Report!P26/SUM(Report!C26:E26,Report!G26)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A27),Report!A27=0),\"\",Report!A27)","v":""},{"$f":"IFERROR(IF((Report!$C27+Report!$E27*0.5+Report!$G27*0.5)/SUM(Report!C27:E27,Report!G27)<=0.65,0,IF((Report!$C27+Report!$E27*0.5+Report!$G27*0.5)/SUM(Report!C27:E27,Report!G27)<=0.75,5,IF((Report!$C27+Report!$E27*0.5+Report!$G27*0.5)/SUM(Report!C27:E27,Report!G27)<=0.85,10,IF((Report!$C27+Report!$E27*0.5+Report!$G27*0.5)/SUM(Report!C27:E27,Report!G27)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H27+Report!$J27)/SUM(Report!$C27:'Report'!$G27)<=0.25,0,IF((Report!$H27+Report!$J27)/SUM(Report!$C27:'Report'!$G27)<=0.5,5,IF((Report!$H27+Report!$J27)/SUM(Report!$C27:'Report'!$G27)<=0.75,10,IF((Report!$H27+Report!$J27)/SUM(Report!$C27:'Report'!$G27)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M27/(SUM(Report!$C27:$G27)/4.333)<=0.25,0,IF(Report!$M27/(SUM(Report!$C27:$G27)/4.333)<=0.5,5,IF(Report!$M27/(SUM(Report!$C27:$G27)/4.333)<=0.75,10,IF(Report!$M27/(SUM(Report!$C27:$G27)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N27/SUM(Report!C27:E27,Report!G27)<=0.25,0,IF(Report!N27/SUM(Report!C27:E27,Report!G27)<=0.5,5,IF(Report!N27/SUM(Report!C27:E27,Report!G27)<0.75,10,IF(Report!N27/SUM(Report!C27:E27,Report!G27)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P27/SUM(Report!C27:E27,Report!G27)<=0.25,0,IF(Report!P27/SUM(Report!C27:E27,Report!G27)<=0.5,5,IF(Report!P27/SUM(Report!C27:E27,Report!G27)<=0.75,10,IF(Report!P27/SUM(Report!C27:E27,Report!G27)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A28),Report!A28=0),\"\",Report!A28)","v":""},{"$f":"IFERROR(IF((Report!$C28+Report!$E28*0.5+Report!$G28*0.5)/SUM(Report!C28:E28,Report!G28)<=0.65,0,IF((Report!$C28+Report!$E28*0.5+Report!$G28*0.5)/SUM(Report!C28:E28,Report!G28)<=0.75,5,IF((Report!$C28+Report!$E28*0.5+Report!$G28*0.5)/SUM(Report!C28:E28,Report!G28)<=0.85,10,IF((Report!$C28+Report!$E28*0.5+Report!$G28*0.5)/SUM(Report!C28:E28,Report!G28)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H28+Report!$J28)/SUM(Report!$C28:'Report'!$G28)<=0.25,0,IF((Report!$H28+Report!$J28)/SUM(Report!$C28:'Report'!$G28)<=0.5,5,IF((Report!$H28+Report!$J28)/SUM(Report!$C28:'Report'!$G28)<=0.75,10,IF((Report!$H28+Report!$J28)/SUM(Report!$C28:'Report'!$G28)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M28/(SUM(Report!$C28:$G28)/4.333)<=0.25,0,IF(Report!$M28/(SUM(Report!$C28:$G28)/4.333)<=0.5,5,IF(Report!$M28/(SUM(Report!$C28:$G28)/4.333)<=0.75,10,IF(Report!$M28/(SUM(Report!$C28:$G28)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N28/SUM(Report!C28:E28,Report!G28)<=0.25,0,IF(Report!N28/SUM(Report!C28:E28,Report!G28)<=0.5,5,IF(Report!N28/SUM(Report!C28:E28,Report!G28)<0.75,10,IF(Report!N28/SUM(Report!C28:E28,Report!G28)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P28/SUM(Report!C28:E28,Report!G28)<=0.25,0,IF(Report!P28/SUM(Report!C28:E28,Report!G28)<=0.5,5,IF(Report!P28/SUM(Report!C28:E28,Report!G28)<=0.75,10,IF(Report!P28/SUM(Report!C28:E28,Report!G28)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A29),Report!A29=0),\"\",Report!A29)","v":""},{"$f":"IFERROR(IF((Report!$C29+Report!$E29*0.5+Report!$G29*0.5)/SUM(Report!C29:E29,Report!G29)<=0.65,0,IF((Report!$C29+Report!$E29*0.5+Report!$G29*0.5)/SUM(Report!C29:E29,Report!G29)<=0.75,5,IF((Report!$C29+Report!$E29*0.5+Report!$G29*0.5)/SUM(Report!C29:E29,Report!G29)<=0.85,10,IF((Report!$C29+Report!$E29*0.5+Report!$G29*0.5)/SUM(Report!C29:E29,Report!G29)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H29+Report!$J29)/SUM(Report!$C29:'Report'!$G29)<=0.25,0,IF((Report!$H29+Report!$J29)/SUM(Report!$C29:'Report'!$G29)<=0.5,5,IF((Report!$H29+Report!$J29)/SUM(Report!$C29:'Report'!$G29)<=0.75,10,IF((Report!$H29+Report!$J29)/SUM(Report!$C29:'Report'!$G29)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M29/(SUM(Report!$C29:$G29)/4.333)<=0.25,0,IF(Report!$M29/(SUM(Report!$C29:$G29)/4.333)<=0.5,5,IF(Report!$M29/(SUM(Report!$C29:$G29)/4.333)<=0.75,10,IF(Report!$M29/(SUM(Report!$C29:$G29)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N29/SUM(Report!C29:E29,Report!G29)<=0.25,0,IF(Report!N29/SUM(Report!C29:E29,Report!G29)<=0.5,5,IF(Report!N29/SUM(Report!C29:E29,Report!G29)<0.75,10,IF(Report!N29/SUM(Report!C29:E29,Report!G29)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P29/SUM(Report!C29:E29,Report!G29)<=0.25,0,IF(Report!P29/SUM(Report!C29:E29,Report!G29)<=0.5,5,IF(Report!P29/SUM(Report!C29:E29,Report!G29)<=0.75,10,IF(Report!P29/SUM(Report!C29:E29,Report!G29)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A30),Report!A30=0),\"\",Report!A30)","v":""},{"$f":"IFERROR(IF((Report!$C30+Report!$E30*0.5+Report!$G30*0.5)/SUM(Report!C30:E30,Report!G30)<=0.65,0,IF((Report!$C30+Report!$E30*0.5+Report!$G30*0.5)/SUM(Report!C30:E30,Report!G30)<=0.75,5,IF((Report!$C30+Report!$E30*0.5+Report!$G30*0.5)/SUM(Report!C30:E30,Report!G30)<=0.85,10,IF((Report!$C30+Report!$E30*0.5+Report!$G30*0.5)/SUM(Report!C30:E30,Report!G30)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H30+Report!$J30)/SUM(Report!$C30:'Report'!$G30)<=0.25,0,IF((Report!$H30+Report!$J30)/SUM(Report!$C30:'Report'!$G30)<=0.5,5,IF((Report!$H30+Report!$J30)/SUM(Report!$C30:'Report'!$G30)<=0.75,10,IF((Report!$H30+Report!$J30)/SUM(Report!$C30:'Report'!$G30)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M30/(SUM(Report!$C30:$G30)/4.333)<=0.25,0,IF(Report!$M30/(SUM(Report!$C30:$G30)/4.333)<=0.5,5,IF(Report!$M30/(SUM(Report!$C30:$G30)/4.333)<=0.75,10,IF(Report!$M30/(SUM(Report!$C30:$G30)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N30/SUM(Report!C30:E30,Report!G30)<=0.25,0,IF(Report!N30/SUM(Report!C30:E30,Report!G30)<=0.5,5,IF(Report!N30/SUM(Report!C30:E30,Report!G30)<0.75,10,IF(Report!N30/SUM(Report!C30:E30,Report!G30)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P30/SUM(Report!C30:E30,Report!G30)<=0.25,0,IF(Report!P30/SUM(Report!C30:E30,Report!G30)<=0.5,5,IF(Report!P30/SUM(Report!C30:E30,Report!G30)<=0.75,10,IF(Report!P30/SUM(Report!C30:E30,Report!G30)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A31),Report!A31=0),\"\",Report!A31)","v":""},{"$f":"IFERROR(IF((Report!$C31+Report!$E31*0.5+Report!$G31*0.5)/SUM(Report!C31:E31,Report!G31)<=0.65,0,IF((Report!$C31+Report!$E31*0.5+Report!$G31*0.5)/SUM(Report!C31:E31,Report!G31)<=0.75,5,IF((Report!$C31+Report!$E31*0.5+Report!$G31*0.5)/SUM(Report!C31:E31,Report!G31)<=0.85,10,IF((Report!$C31+Report!$E31*0.5+Report!$G31*0.5)/SUM(Report!C31:E31,Report!G31)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H31+Report!$J31)/SUM(Report!$C31:'Report'!$G31)<=0.25,0,IF((Report!$H31+Report!$J31)/SUM(Report!$C31:'Report'!$G31)<=0.5,5,IF((Report!$H31+Report!$J31)/SUM(Report!$C31:'Report'!$G31)<=0.75,10,IF((Report!$H31+Report!$J31)/SUM(Report!$C31:'Report'!$G31)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M31/(SUM(Report!$C31:$G31)/4.333)<=0.25,0,IF(Report!$M31/(SUM(Report!$C31:$G31)/4.333)<=0.5,5,IF(Report!$M31/(SUM(Report!$C31:$G31)/4.333)<=0.75,10,IF(Report!$M31/(SUM(Report!$C31:$G31)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N31/SUM(Report!C31:E31,Report!G31)<=0.25,0,IF(Report!N31/SUM(Report!C31:E31,Report!G31)<=0.5,5,IF(Report!N31/SUM(Report!C31:E31,Report!G31)<0.75,10,IF(Report!N31/SUM(Report!C31:E31,Report!G31)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P31/SUM(Report!C31:E31,Report!G31)<=0.25,0,IF(Report!P31/SUM(Report!C31:E31,Report!G31)<=0.5,5,IF(Report!P31/SUM(Report!C31:E31,Report!G31)<=0.75,10,IF(Report!P31/SUM(Report!C31:E31,Report!G31)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A32),Report!A32=0),\"\",Report!A32)","v":""},{"$f":"IFERROR(IF((Report!$C32+Report!$E32*0.5+Report!$G32*0.5)/SUM(Report!C32:E32,Report!G32)<=0.65,0,IF((Report!$C32+Report!$E32*0.5+Report!$G32*0.5)/SUM(Report!C32:E32,Report!G32)<=0.75,5,IF((Report!$C32+Report!$E32*0.5+Report!$G32*0.5)/SUM(Report!C32:E32,Report!G32)<=0.85,10,IF((Report!$C32+Report!$E32*0.5+Report!$G32*0.5)/SUM(Report!C32:E32,Report!G32)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H32+Report!$J32)/SUM(Report!$C32:'Report'!$G32)<=0.25,0,IF((Report!$H32+Report!$J32)/SUM(Report!$C32:'Report'!$G32)<=0.5,5,IF((Report!$H32+Report!$J32)/SUM(Report!$C32:'Report'!$G32)<=0.75,10,IF((Report!$H32+Report!$J32)/SUM(Report!$C32:'Report'!$G32)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M32/(SUM(Report!$C32:$G32)/4.333)<=0.25,0,IF(Report!$M32/(SUM(Report!$C32:$G32)/4.333)<=0.5,5,IF(Report!$M32/(SUM(Report!$C32:$G32)/4.333)<=0.75,10,IF(Report!$M32/(SUM(Report!$C32:$G32)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N32/SUM(Report!C32:E32,Report!G32)<=0.25,0,IF(Report!N32/SUM(Report!C32:E32,Report!G32)<=0.5,5,IF(Report!N32/SUM(Report!C32:E32,Report!G32)<0.75,10,IF(Report!N32/SUM(Report!C32:E32,Report!G32)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P32/SUM(Report!C32:E32,Report!G32)<=0.25,0,IF(Report!P32/SUM(Report!C32:E32,Report!G32)<=0.5,5,IF(Report!P32/SUM(Report!C32:E32,Report!G32)<=0.75,10,IF(Report!P32/SUM(Report!C32:E32,Report!G32)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A33),Report!A33=0),\"\",Report!A33)","v":""},{"$f":"IFERROR(IF((Report!$C33+Report!$E33*0.5+Report!$G33*0.5)/SUM(Report!C33:E33,Report!G33)<=0.65,0,IF((Report!$C33+Report!$E33*0.5+Report!$G33*0.5)/SUM(Report!C33:E33,Report!G33)<=0.75,5,IF((Report!$C33+Report!$E33*0.5+Report!$G33*0.5)/SUM(Report!C33:E33,Report!G33)<=0.85,10,IF((Report!$C33+Report!$E33*0.5+Report!$G33*0.5)/SUM(Report!C33:E33,Report!G33)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H33+Report!$J33)/SUM(Report!$C33:'Report'!$G33)<=0.25,0,IF((Report!$H33+Report!$J33)/SUM(Report!$C33:'Report'!$G33)<=0.5,5,IF((Report!$H33+Report!$J33)/SUM(Report!$C33:'Report'!$G33)<=0.75,10,IF((Report!$H33+Report!$J33)/SUM(Report!$C33:'Report'!$G33)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M33/(SUM(Report!$C33:$G33)/4.333)<=0.25,0,IF(Report!$M33/(SUM(Report!$C33:$G33)/4.333)<=0.5,5,IF(Report!$M33/(SUM(Report!$C33:$G33)/4.333)<=0.75,10,IF(Report!$M33/(SUM(Report!$C33:$G33)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N33/SUM(Report!C33:E33,Report!G33)<=0.25,0,IF(Report!N33/SUM(Report!C33:E33,Report!G33)<=0.5,5,IF(Report!N33/SUM(Report!C33:E33,Report!G33)<0.75,10,IF(Report!N33/SUM(Report!C33:E33,Report!G33)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P33/SUM(Report!C33:E33,Report!G33)<=0.25,0,IF(Report!P33/SUM(Report!C33:E33,Report!G33)<=0.5,5,IF(Report!P33/SUM(Report!C33:E33,Report!G33)<=0.75,10,IF(Report!P33/SUM(Report!C33:E33,Report!G33)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A34),Report!A34=0),\"\",Report!A34)","v":""},{"$f":"IFERROR(IF((Report!$C34+Report!$E34*0.5+Report!$G34*0.5)/SUM(Report!C34:E34,Report!G34)<=0.65,0,IF((Report!$C34+Report!$E34*0.5+Report!$G34*0.5)/SUM(Report!C34:E34,Report!G34)<=0.75,5,IF((Report!$C34+Report!$E34*0.5+Report!$G34*0.5)/SUM(Report!C34:E34,Report!G34)<=0.85,10,IF((Report!$C34+Report!$E34*0.5+Report!$G34*0.5)/SUM(Report!C34:E34,Report!G34)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H34+Report!$J34)/SUM(Report!$C34:'Report'!$G34)<=0.25,0,IF((Report!$H34+Report!$J34)/SUM(Report!$C34:'Report'!$G34)<=0.5,5,IF((Report!$H34+Report!$J34)/SUM(Report!$C34:'Report'!$G34)<=0.75,10,IF((Report!$H34+Report!$J34)/SUM(Report!$C34:'Report'!$G34)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M34/(SUM(Report!$C34:$G34)/4.333)<=0.25,0,IF(Report!$M34/(SUM(Report!$C34:$G34)/4.333)<=0.5,5,IF(Report!$M34/(SUM(Report!$C34:$G34)/4.333)<=0.75,10,IF(Report!$M34/(SUM(Report!$C34:$G34)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N34/SUM(Report!C34:E34,Report!G34)<=0.25,0,IF(Report!N34/SUM(Report!C34:E34,Report!G34)<=0.5,5,IF(Report!N34/SUM(Report!C34:E34,Report!G34)<0.75,10,IF(Report!N34/SUM(Report!C34:E34,Report!G34)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P34/SUM(Report!C34:E34,Report!G34)<=0.25,0,IF(Report!P34/SUM(Report!C34:E34,Report!G34)<=0.5,5,IF(Report!P34/SUM(Report!C34:E34,Report!G34)<=0.75,10,IF(Report!P34/SUM(Report!C34:E34,Report!G34)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A35),Report!A35=0),\"\",Report!A35)","v":""},{"$f":"IFERROR(IF((Report!$C35+Report!$E35*0.5+Report!$G35*0.5)/SUM(Report!C35:E35,Report!G35)<=0.65,0,IF((Report!$C35+Report!$E35*0.5+Report!$G35*0.5)/SUM(Report!C35:E35,Report!G35)<=0.75,5,IF((Report!$C35+Report!$E35*0.5+Report!$G35*0.5)/SUM(Report!C35:E35,Report!G35)<=0.85,10,IF((Report!$C35+Report!$E35*0.5+Report!$G35*0.5)/SUM(Report!C35:E35,Report!G35)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H35+Report!$J35)/SUM(Report!$C35:'Report'!$G35)<=0.25,0,IF((Report!$H35+Report!$J35)/SUM(Report!$C35:'Report'!$G35)<=0.5,5,IF((Report!$H35+Report!$J35)/SUM(Report!$C35:'Report'!$G35)<=0.75,10,IF((Report!$H35+Report!$J35)/SUM(Report!$C35:'Report'!$G35)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M35/(SUM(Report!$C35:$G35)/4.333)<=0.25,0,IF(Report!$M35/(SUM(Report!$C35:$G35)/4.333)<=0.5,5,IF(Report!$M35/(SUM(Report!$C35:$G35)/4.333)<=0.75,10,IF(Report!$M35/(SUM(Report!$C35:$G35)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N35/SUM(Report!C35:E35,Report!G35)<=0.25,0,IF(Report!N35/SUM(Report!C35:E35,Report!G35)<=0.5,5,IF(Report!N35/SUM(Report!C35:E35,Report!G35)<0.75,10,IF(Report!N35/SUM(Report!C35:E35,Report!G35)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P35/SUM(Report!C35:E35,Report!G35)<=0.25,0,IF(Report!P35/SUM(Report!C35:E35,Report!G35)<=0.5,5,IF(Report!P35/SUM(Report!C35:E35,Report!G35)<=0.75,10,IF(Report!P35/SUM(Report!C35:E35,Report!G35)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A36),Report!A36=0),\"\",Report!A36)","v":""},{"$f":"IFERROR(IF((Report!$C36+Report!$E36*0.5+Report!$G36*0.5)/SUM(Report!C36:E36,Report!G36)<=0.65,0,IF((Report!$C36+Report!$E36*0.5+Report!$G36*0.5)/SUM(Report!C36:E36,Report!G36)<=0.75,5,IF((Report!$C36+Report!$E36*0.5+Report!$G36*0.5)/SUM(Report!C36:E36,Report!G36)<=0.85,10,IF((Report!$C36+Report!$E36*0.5+Report!$G36*0.5)/SUM(Report!C36:E36,Report!G36)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H36+Report!$J36)/SUM(Report!$C36:'Report'!$G36)<=0.25,0,IF((Report!$H36+Report!$J36)/SUM(Report!$C36:'Report'!$G36)<=0.5,5,IF((Report!$H36+Report!$J36)/SUM(Report!$C36:'Report'!$G36)<=0.75,10,IF((Report!$H36+Report!$J36)/SUM(Report!$C36:'Report'!$G36)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M36/(SUM(Report!$C36:$G36)/4.333)<=0.25,0,IF(Report!$M36/(SUM(Report!$C36:$G36)/4.333)<=0.5,5,IF(Report!$M36/(SUM(Report!$C36:$G36)/4.333)<=0.75,10,IF(Report!$M36/(SUM(Report!$C36:$G36)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N36/SUM(Report!C36:E36,Report!G36)<=0.25,0,IF(Report!N36/SUM(Report!C36:E36,Report!G36)<=0.5,5,IF(Report!N36/SUM(Report!C36:E36,Report!G36)<0.75,10,IF(Report!N36/SUM(Report!C36:E36,Report!G36)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P36/SUM(Report!C36:E36,Report!G36)<=0.25,0,IF(Report!P36/SUM(Report!C36:E36,Report!G36)<=0.5,5,IF(Report!P36/SUM(Report!C36:E36,Report!G36)<=0.75,10,IF(Report!P36/SUM(Report!C36:E36,Report!G36)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A37),Report!A37=0),\"\",Report!A37)","v":""},{"$f":"IFERROR(IF((Report!$C37+Report!$E37*0.5+Report!$G37*0.5)/SUM(Report!C37:E37,Report!G37)<=0.65,0,IF((Report!$C37+Report!$E37*0.5+Report!$G37*0.5)/SUM(Report!C37:E37,Report!G37)<=0.75,5,IF((Report!$C37+Report!$E37*0.5+Report!$G37*0.5)/SUM(Report!C37:E37,Report!G37)<=0.85,10,IF((Report!$C37+Report!$E37*0.5+Report!$G37*0.5)/SUM(Report!C37:E37,Report!G37)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H37+Report!$J37)/SUM(Report!$C37:'Report'!$G37)<=0.25,0,IF((Report!$H37+Report!$J37)/SUM(Report!$C37:'Report'!$G37)<=0.5,5,IF((Report!$H37+Report!$J37)/SUM(Report!$C37:'Report'!$G37)<=0.75,10,IF((Report!$H37+Report!$J37)/SUM(Report!$C37:'Report'!$G37)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M37/(SUM(Report!$C37:$G37)/4.333)<=0.25,0,IF(Report!$M37/(SUM(Report!$C37:$G37)/4.333)<=0.5,5,IF(Report!$M37/(SUM(Report!$C37:$G37)/4.333)<=0.75,10,IF(Report!$M37/(SUM(Report!$C37:$G37)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N37/SUM(Report!C37:E37,Report!G37)<=0.25,0,IF(Report!N37/SUM(Report!C37:E37,Report!G37)<=0.5,5,IF(Report!N37/SUM(Report!C37:E37,Report!G37)<0.75,10,IF(Report!N37/SUM(Report!C37:E37,Report!G37)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P37/SUM(Report!C37:E37,Report!G37)<=0.25,0,IF(Report!P37/SUM(Report!C37:E37,Report!G37)<=0.5,5,IF(Report!P37/SUM(Report!C37:E37,Report!G37)<=0.75,10,IF(Report!P37/SUM(Report!C37:E37,Report!G37)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A38),Report!A38=0),\"\",Report!A38)","v":""},{"$f":"IFERROR(IF((Report!$C38+Report!$E38*0.5+Report!$G38*0.5)/SUM(Report!C38:E38,Report!G38)<=0.65,0,IF((Report!$C38+Report!$E38*0.5+Report!$G38*0.5)/SUM(Report!C38:E38,Report!G38)<=0.75,5,IF((Report!$C38+Report!$E38*0.5+Report!$G38*0.5)/SUM(Report!C38:E38,Report!G38)<=0.85,10,IF((Report!$C38+Report!$E38*0.5+Report!$G38*0.5)/SUM(Report!C38:E38,Report!G38)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H38+Report!$J38)/SUM(Report!$C38:'Report'!$G38)<=0.25,0,IF((Report!$H38+Report!$J38)/SUM(Report!$C38:'Report'!$G38)<=0.5,5,IF((Report!$H38+Report!$J38)/SUM(Report!$C38:'Report'!$G38)<=0.75,10,IF((Report!$H38+Report!$J38)/SUM(Report!$C38:'Report'!$G38)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M38/(SUM(Report!$C38:$G38)/4.333)<=0.25,0,IF(Report!$M38/(SUM(Report!$C38:$G38)/4.333)<=0.5,5,IF(Report!$M38/(SUM(Report!$C38:$G38)/4.333)<=0.75,10,IF(Report!$M38/(SUM(Report!$C38:$G38)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N38/SUM(Report!C38:E38,Report!G38)<=0.25,0,IF(Report!N38/SUM(Report!C38:E38,Report!G38)<=0.5,5,IF(Report!N38/SUM(Report!C38:E38,Report!G38)<0.75,10,IF(Report!N38/SUM(Report!C38:E38,Report!G38)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P38/SUM(Report!C38:E38,Report!G38)<=0.25,0,IF(Report!P38/SUM(Report!C38:E38,Report!G38)<=0.5,5,IF(Report!P38/SUM(Report!C38:E38,Report!G38)<=0.75,10,IF(Report!P38/SUM(Report!C38:E38,Report!G38)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A39),Report!A39=0),\"\",Report!A39)","v":""},{"$f":"IFERROR(IF((Report!$C39+Report!$E39*0.5+Report!$G39*0.5)/SUM(Report!C39:E39,Report!G39)<=0.65,0,IF((Report!$C39+Report!$E39*0.5+Report!$G39*0.5)/SUM(Report!C39:E39,Report!G39)<=0.75,5,IF((Report!$C39+Report!$E39*0.5+Report!$G39*0.5)/SUM(Report!C39:E39,Report!G39)<=0.85,10,IF((Report!$C39+Report!$E39*0.5+Report!$G39*0.5)/SUM(Report!C39:E39,Report!G39)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H39+Report!$J39)/SUM(Report!$C39:'Report'!$G39)<=0.25,0,IF((Report!$H39+Report!$J39)/SUM(Report!$C39:'Report'!$G39)<=0.5,5,IF((Report!$H39+Report!$J39)/SUM(Report!$C39:'Report'!$G39)<=0.75,10,IF((Report!$H39+Report!$J39)/SUM(Report!$C39:'Report'!$G39)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M39/(SUM(Report!$C39:$G39)/4.333)<=0.25,0,IF(Report!$M39/(SUM(Report!$C39:$G39)/4.333)<=0.5,5,IF(Report!$M39/(SUM(Report!$C39:$G39)/4.333)<=0.75,10,IF(Report!$M39/(SUM(Report!$C39:$G39)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N39/SUM(Report!C39:E39,Report!G39)<=0.25,0,IF(Report!N39/SUM(Report!C39:E39,Report!G39)<=0.5,5,IF(Report!N39/SUM(Report!C39:E39,Report!G39)<0.75,10,IF(Report!N39/SUM(Report!C39:E39,Report!G39)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P39/SUM(Report!C39:E39,Report!G39)<=0.25,0,IF(Report!P39/SUM(Report!C39:E39,Report!G39)<=0.5,5,IF(Report!P39/SUM(Report!C39:E39,Report!G39)<=0.75,10,IF(Report!P39/SUM(Report!C39:E39,Report!G39)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A40),Report!A40=0),\"\",Report!A40)","v":""},{"$f":"IFERROR(IF((Report!$C40+Report!$E40*0.5+Report!$G40*0.5)/SUM(Report!C40:E40,Report!G40)<=0.65,0,IF((Report!$C40+Report!$E40*0.5+Report!$G40*0.5)/SUM(Report!C40:E40,Report!G40)<=0.75,5,IF((Report!$C40+Report!$E40*0.5+Report!$G40*0.5)/SUM(Report!C40:E40,Report!G40)<=0.85,10,IF((Report!$C40+Report!$E40*0.5+Report!$G40*0.5)/SUM(Report!C40:E40,Report!G40)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H40+Report!$J40)/SUM(Report!$C40:'Report'!$G40)<=0.25,0,IF((Report!$H40+Report!$J40)/SUM(Report!$C40:'Report'!$G40)<=0.5,5,IF((Report!$H40+Report!$J40)/SUM(Report!$C40:'Report'!$G40)<=0.75,10,IF((Report!$H40+Report!$J40)/SUM(Report!$C40:'Report'!$G40)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M40/(SUM(Report!$C40:$G40)/4.333)<=0.25,0,IF(Report!$M40/(SUM(Report!$C40:$G40)/4.333)<=0.5,5,IF(Report!$M40/(SUM(Report!$C40:$G40)/4.333)<=0.75,10,IF(Report!$M40/(SUM(Report!$C40:$G40)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N40/SUM(Report!C40:E40,Report!G40)<=0.25,0,IF(Report!N40/SUM(Report!C40:E40,Report!G40)<=0.5,5,IF(Report!N40/SUM(Report!C40:E40,Report!G40)<0.75,10,IF(Report!N40/SUM(Report!C40:E40,Report!G40)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P40/SUM(Report!C40:E40,Report!G40)<=0.25,0,IF(Report!P40/SUM(Report!C40:E40,Report!G40)<=0.5,5,IF(Report!P40/SUM(Report!C40:E40,Report!G40)<=0.75,10,IF(Report!P40/SUM(Report!C40:E40,Report!G40)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A41),Report!A41=0),\"\",Report!A41)","v":""},{"$f":"IFERROR(IF((Report!$C41+Report!$E41*0.5+Report!$G41*0.5)/SUM(Report!C41:E41,Report!G41)<=0.65,0,IF((Report!$C41+Report!$E41*0.5+Report!$G41*0.5)/SUM(Report!C41:E41,Report!G41)<=0.75,5,IF((Report!$C41+Report!$E41*0.5+Report!$G41*0.5)/SUM(Report!C41:E41,Report!G41)<=0.85,10,IF((Report!$C41+Report!$E41*0.5+Report!$G41*0.5)/SUM(Report!C41:E41,Report!G41)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H41+Report!$J41)/SUM(Report!$C41:'Report'!$G41)<=0.25,0,IF((Report!$H41+Report!$J41)/SUM(Report!$C41:'Report'!$G41)<=0.5,5,IF((Report!$H41+Report!$J41)/SUM(Report!$C41:'Report'!$G41)<=0.75,10,IF((Report!$H41+Report!$J41)/SUM(Report!$C41:'Report'!$G41)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M41/(SUM(Report!$C41:$G41)/4.333)<=0.25,0,IF(Report!$M41/(SUM(Report!$C41:$G41)/4.333)<=0.5,5,IF(Report!$M41/(SUM(Report!$C41:$G41)/4.333)<=0.75,10,IF(Report!$M41/(SUM(Report!$C41:$G41)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N41/SUM(Report!C41:E41,Report!G41)<=0.25,0,IF(Report!N41/SUM(Report!C41:E41,Report!G41)<=0.5,5,IF(Report!N41/SUM(Report!C41:E41,Report!G41)<0.75,10,IF(Report!N41/SUM(Report!C41:E41,Report!G41)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P41/SUM(Report!C41:E41,Report!G41)<=0.25,0,IF(Report!P41/SUM(Report!C41:E41,Report!G41)<=0.5,5,IF(Report!P41/SUM(Report!C41:E41,Report!G41)<=0.75,10,IF(Report!P41/SUM(Report!C41:E41,Report!G41)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A42),Report!A42=0),\"\",Report!A42)","v":""},{"$f":"IFERROR(IF((Report!$C42+Report!$E42*0.5+Report!$G42*0.5)/SUM(Report!C42:E42,Report!G42)<=0.65,0,IF((Report!$C42+Report!$E42*0.5+Report!$G42*0.5)/SUM(Report!C42:E42,Report!G42)<=0.75,5,IF((Report!$C42+Report!$E42*0.5+Report!$G42*0.5)/SUM(Report!C42:E42,Report!G42)<=0.85,10,IF((Report!$C42+Report!$E42*0.5+Report!$G42*0.5)/SUM(Report!C42:E42,Report!G42)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H42+Report!$J42)/SUM(Report!$C42:'Report'!$G42)<=0.25,0,IF((Report!$H42+Report!$J42)/SUM(Report!$C42:'Report'!$G42)<=0.5,5,IF((Report!$H42+Report!$J42)/SUM(Report!$C42:'Report'!$G42)<=0.75,10,IF((Report!$H42+Report!$J42)/SUM(Report!$C42:'Report'!$G42)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M42/(SUM(Report!$C42:$G42)/4.333)<=0.25,0,IF(Report!$M42/(SUM(Report!$C42:$G42)/4.333)<=0.5,5,IF(Report!$M42/(SUM(Report!$C42:$G42)/4.333)<=0.75,10,IF(Report!$M42/(SUM(Report!$C42:$G42)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N42/SUM(Report!C42:E42,Report!G42)<=0.25,0,IF(Report!N42/SUM(Report!C42:E42,Report!G42)<=0.5,5,IF(Report!N42/SUM(Report!C42:E42,Report!G42)<0.75,10,IF(Report!N42/SUM(Report!C42:E42,Report!G42)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P42/SUM(Report!C42:E42,Report!G42)<=0.25,0,IF(Report!P42/SUM(Report!C42:E42,Report!G42)<=0.5,5,IF(Report!P42/SUM(Report!C42:E42,Report!G42)<=0.75,10,IF(Report!P42/SUM(Report!C42:E42,Report!G42)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A43),Report!A43=0),\"\",Report!A43)","v":""},{"$f":"IFERROR(IF((Report!$C43+Report!$E43*0.5+Report!$G43*0.5)/SUM(Report!C43:E43,Report!G43)<=0.65,0,IF((Report!$C43+Report!$E43*0.5+Report!$G43*0.5)/SUM(Report!C43:E43,Report!G43)<=0.75,5,IF((Report!$C43+Report!$E43*0.5+Report!$G43*0.5)/SUM(Report!C43:E43,Report!G43)<=0.85,10,IF((Report!$C43+Report!$E43*0.5+Report!$G43*0.5)/SUM(Report!C43:E43,Report!G43)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H43+Report!$J43)/SUM(Report!$C43:'Report'!$G43)<=0.25,0,IF((Report!$H43+Report!$J43)/SUM(Report!$C43:'Report'!$G43)<=0.5,5,IF((Report!$H43+Report!$J43)/SUM(Report!$C43:'Report'!$G43)<=0.75,10,IF((Report!$H43+Report!$J43)/SUM(Report!$C43:'Report'!$G43)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M43/(SUM(Report!$C43:$G43)/4.333)<=0.25,0,IF(Report!$M43/(SUM(Report!$C43:$G43)/4.333)<=0.5,5,IF(Report!$M43/(SUM(Report!$C43:$G43)/4.333)<=0.75,10,IF(Report!$M43/(SUM(Report!$C43:$G43)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N43/SUM(Report!C43:E43,Report!G43)<=0.25,0,IF(Report!N43/SUM(Report!C43:E43,Report!G43)<=0.5,5,IF(Report!N43/SUM(Report!C43:E43,Report!G43)<0.75,10,IF(Report!N43/SUM(Report!C43:E43,Report!G43)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P43/SUM(Report!C43:E43,Report!G43)<=0.25,0,IF(Report!P43/SUM(Report!C43:E43,Report!G43)<=0.5,5,IF(Report!P43/SUM(Report!C43:E43,Report!G43)<=0.75,10,IF(Report!P43/SUM(Report!C43:E43,Report!G43)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A44),Report!A44=0),\"\",Report!A44)","v":""},{"$f":"IFERROR(IF((Report!$C44+Report!$E44*0.5+Report!$G44*0.5)/SUM(Report!C44:E44,Report!G44)<=0.65,0,IF((Report!$C44+Report!$E44*0.5+Report!$G44*0.5)/SUM(Report!C44:E44,Report!G44)<=0.75,5,IF((Report!$C44+Report!$E44*0.5+Report!$G44*0.5)/SUM(Report!C44:E44,Report!G44)<=0.85,10,IF((Report!$C44+Report!$E44*0.5+Report!$G44*0.5)/SUM(Report!C44:E44,Report!G44)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H44+Report!$J44)/SUM(Report!$C44:'Report'!$G44)<=0.25,0,IF((Report!$H44+Report!$J44)/SUM(Report!$C44:'Report'!$G44)<=0.5,5,IF((Report!$H44+Report!$J44)/SUM(Report!$C44:'Report'!$G44)<=0.75,10,IF((Report!$H44+Report!$J44)/SUM(Report!$C44:'Report'!$G44)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M44/(SUM(Report!$C44:$G44)/4.333)<=0.25,0,IF(Report!$M44/(SUM(Report!$C44:$G44)/4.333)<=0.5,5,IF(Report!$M44/(SUM(Report!$C44:$G44)/4.333)<=0.75,10,IF(Report!$M44/(SUM(Report!$C44:$G44)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N44/SUM(Report!C44:E44,Report!G44)<=0.25,0,IF(Report!N44/SUM(Report!C44:E44,Report!G44)<=0.5,5,IF(Report!N44/SUM(Report!C44:E44,Report!G44)<0.75,10,IF(Report!N44/SUM(Report!C44:E44,Report!G44)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P44/SUM(Report!C44:E44,Report!G44)<=0.25,0,IF(Report!P44/SUM(Report!C44:E44,Report!G44)<=0.5,5,IF(Report!P44/SUM(Report!C44:E44,Report!G44)<=0.75,10,IF(Report!P44/SUM(Report!C44:E44,Report!G44)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A45),Report!A45=0),\"\",Report!A45)","v":""},{"$f":"IFERROR(IF((Report!$C45+Report!$E45*0.5+Report!$G45*0.5)/SUM(Report!C45:E45,Report!G45)<=0.65,0,IF((Report!$C45+Report!$E45*0.5+Report!$G45*0.5)/SUM(Report!C45:E45,Report!G45)<=0.75,5,IF((Report!$C45+Report!$E45*0.5+Report!$G45*0.5)/SUM(Report!C45:E45,Report!G45)<=0.85,10,IF((Report!$C45+Report!$E45*0.5+Report!$G45*0.5)/SUM(Report!C45:E45,Report!G45)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H45+Report!$J45)/SUM(Report!$C45:'Report'!$G45)<=0.25,0,IF((Report!$H45+Report!$J45)/SUM(Report!$C45:'Report'!$G45)<=0.5,5,IF((Report!$H45+Report!$J45)/SUM(Report!$C45:'Report'!$G45)<=0.75,10,IF((Report!$H45+Report!$J45)/SUM(Report!$C45:'Report'!$G45)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M45/(SUM(Report!$C45:$G45)/4.333)<=0.25,0,IF(Report!$M45/(SUM(Report!$C45:$G45)/4.333)<=0.5,5,IF(Report!$M45/(SUM(Report!$C45:$G45)/4.333)<=0.75,10,IF(Report!$M45/(SUM(Report!$C45:$G45)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N45/SUM(Report!C45:E45,Report!G45)<=0.25,0,IF(Report!N45/SUM(Report!C45:E45,Report!G45)<=0.5,5,IF(Report!N45/SUM(Report!C45:E45,Report!G45)<0.75,10,IF(Report!N45/SUM(Report!C45:E45,Report!G45)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P45/SUM(Report!C45:E45,Report!G45)<=0.25,0,IF(Report!P45/SUM(Report!C45:E45,Report!G45)<=0.5,5,IF(Report!P45/SUM(Report!C45:E45,Report!G45)<=0.75,10,IF(Report!P45/SUM(Report!C45:E45,Report!G45)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A46),Report!A46=0),\"\",Report!A46)","v":""},{"$f":"IFERROR(IF((Report!$C46+Report!$E46*0.5+Report!$G46*0.5)/SUM(Report!C46:E46,Report!G46)<=0.65,0,IF((Report!$C46+Report!$E46*0.5+Report!$G46*0.5)/SUM(Report!C46:E46,Report!G46)<=0.75,5,IF((Report!$C46+Report!$E46*0.5+Report!$G46*0.5)/SUM(Report!C46:E46,Report!G46)<=0.85,10,IF((Report!$C46+Report!$E46*0.5+Report!$G46*0.5)/SUM(Report!C46:E46,Report!G46)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H46+Report!$J46)/SUM(Report!$C46:'Report'!$G46)<=0.25,0,IF((Report!$H46+Report!$J46)/SUM(Report!$C46:'Report'!$G46)<=0.5,5,IF((Report!$H46+Report!$J46)/SUM(Report!$C46:'Report'!$G46)<=0.75,10,IF((Report!$H46+Report!$J46)/SUM(Report!$C46:'Report'!$G46)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M46/(SUM(Report!$C46:$G46)/4.333)<=0.25,0,IF(Report!$M46/(SUM(Report!$C46:$G46)/4.333)<=0.5,5,IF(Report!$M46/(SUM(Report!$C46:$G46)/4.333)<=0.75,10,IF(Report!$M46/(SUM(Report!$C46:$G46)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N46/SUM(Report!C46:E46,Report!G46)<=0.25,0,IF(Report!N46/SUM(Report!C46:E46,Report!G46)<=0.5,5,IF(Report!N46/SUM(Report!C46:E46,Report!G46)<0.75,10,IF(Report!N46/SUM(Report!C46:E46,Report!G46)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P46/SUM(Report!C46:E46,Report!G46)<=0.25,0,IF(Report!P46/SUM(Report!C46:E46,Report!G46)<=0.5,5,IF(Report!P46/SUM(Report!C46:E46,Report!G46)<=0.75,10,IF(Report!P46/SUM(Report!C46:E46,Report!G46)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A47),Report!A47=0),\"\",Report!A47)","v":""},{"$f":"IFERROR(IF((Report!$C47+Report!$E47*0.5+Report!$G47*0.5)/SUM(Report!C47:E47,Report!G47)<=0.65,0,IF((Report!$C47+Report!$E47*0.5+Report!$G47*0.5)/SUM(Report!C47:E47,Report!G47)<=0.75,5,IF((Report!$C47+Report!$E47*0.5+Report!$G47*0.5)/SUM(Report!C47:E47,Report!G47)<=0.85,10,IF((Report!$C47+Report!$E47*0.5+Report!$G47*0.5)/SUM(Report!C47:E47,Report!G47)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H47+Report!$J47)/SUM(Report!$C47:'Report'!$G47)<=0.25,0,IF((Report!$H47+Report!$J47)/SUM(Report!$C47:'Report'!$G47)<=0.5,5,IF((Report!$H47+Report!$J47)/SUM(Report!$C47:'Report'!$G47)<=0.75,10,IF((Report!$H47+Report!$J47)/SUM(Report!$C47:'Report'!$G47)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M47/(SUM(Report!$C47:$G47)/4.333)<=0.25,0,IF(Report!$M47/(SUM(Report!$C47:$G47)/4.333)<=0.5,5,IF(Report!$M47/(SUM(Report!$C47:$G47)/4.333)<=0.75,10,IF(Report!$M47/(SUM(Report!$C47:$G47)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N47/SUM(Report!C47:E47,Report!G47)<=0.25,0,IF(Report!N47/SUM(Report!C47:E47,Report!G47)<=0.5,5,IF(Report!N47/SUM(Report!C47:E47,Report!G47)<0.75,10,IF(Report!N47/SUM(Report!C47:E47,Report!G47)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P47/SUM(Report!C47:E47,Report!G47)<=0.25,0,IF(Report!P47/SUM(Report!C47:E47,Report!G47)<=0.5,5,IF(Report!P47/SUM(Report!C47:E47,Report!G47)<=0.75,10,IF(Report!P47/SUM(Report!C47:E47,Report!G47)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A48),Report!A48=0),\"\",Report!A48)","v":""},{"$f":"IFERROR(IF((Report!$C48+Report!$E48*0.5+Report!$G48*0.5)/SUM(Report!C48:E48,Report!G48)<=0.65,0,IF((Report!$C48+Report!$E48*0.5+Report!$G48*0.5)/SUM(Report!C48:E48,Report!G48)<=0.75,5,IF((Report!$C48+Report!$E48*0.5+Report!$G48*0.5)/SUM(Report!C48:E48,Report!G48)<=0.85,10,IF((Report!$C48+Report!$E48*0.5+Report!$G48*0.5)/SUM(Report!C48:E48,Report!G48)<=0.95,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF((Report!$H48+Report!$J48)/SUM(Report!$C48:'Report'!$G48)<=0.25,0,IF((Report!$H48+Report!$J48)/SUM(Report!$C48:'Report'!$G48)<=0.5,5,IF((Report!$H48+Report!$J48)/SUM(Report!$C48:'Report'!$G48)<=0.75,10,IF((Report!$H48+Report!$J48)/SUM(Report!$C48:'Report'!$G48)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!$M48/(SUM(Report!$C48:$G48)/4.333)<=0.25,0,IF(Report!$M48/(SUM(Report!$C48:$G48)/4.333)<=0.5,5,IF(Report!$M48/(SUM(Report!$C48:$G48)/4.333)<=0.75,10,IF(Report!$M48/(SUM(Report!$C48:$G48)/4.333)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!N48/SUM(Report!C48:E48,Report!G48)<=0.25,0,IF(Report!N48/SUM(Report!C48:E48,Report!G48)<=0.5,5,IF(Report!N48/SUM(Report!C48:E48,Report!G48)<0.75,10,IF(Report!N48/SUM(Report!C48:E48,Report!G48)<=1,15,20)))),\"\")","v":""},{"$f":"IFERROR(IF(Report!P48/SUM(Report!C48:E48,Report!G48)<=0.25,0,IF(Report!P48/SUM(Report!C48:E48,Report!G48)<=0.5,5,IF(Report!P48/SUM(Report!C48:E48,Report!G48)<=0.75,10,IF(Report!P48/SUM(Report!C48:E48,Report!G48)<=1,15,20)))),\"\")","v":""},""]
[{"$f":"IF(OR(ISBLANK(Report!A72),Report!A72=0),\"\")","v":""}]
[{"$f":"IF(OR(ISBLANK(Report!A73),Report!A73=0),\"\")","v":""}]